subset - subsetting error in R -
i have large dataframe
called dualbeta
contains 2 rows , 6080 columns. here sample:
row.names a.close aa.close aadr.close aait.close aal.close 1 upside 1.253929 0.9869027 0.6169613 0.6353903 0.1782124 2 downside 1.027412 1.1936236 0.5915299 0.5697878 0.1702382
i trying extract upside
>= 1.00 , downside
<=1.00. used combinations <- subset(dualbeta, upside>=1.00 & downside<=1.00)
following:
row.names a.close aa.close aadr.close aait.close 1 na na na na na 2 na.1 na na na na 3 na.2 na na na na 4 na.3 na na na na 5 na.4 na na na na ...
it should return 2 x
table x number of combinations found. not know why getting bunch of rows? additionally, thought had na
values in dualbeta
used na.omit(dualbeta)->dualbeta
deleted & turned dualbeta
0 6080
. used which(is.na(dualbeta))
returned 3307
, 3308
when checked columns, did not contain nas.
you might work on transpose of data in order select rows proper characteristics (which columns in transpose):
# fix data, use proper row names rownames(x) <- x$row.names # remove old row name column x <- x[-1] # transpose , subset subset(data.frame(t(x)), upside > 1 & downside < 1)
this expression returns zero-length result example data. changing parameters shows returned:
subset(data.frame(t(x)), upside > .6 & downside < .6) ## upside downside ## aadr.close 0.6169613 0.5915299 ## aait.close 0.6353903 0.5697878
Comments
Post a Comment