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

Popular posts from this blog

database - VFP Grid + SQL server 2008 - grid not showing correctly -

jquery - Set jPicker field to empty value -

.htaccess - htaccess convert request to clean url and add slash at the end of the url -