[R] Subsetting data frame problem....
Marko Milicic
milicic.marko at gmail.com
Wed Jan 2 02:50:05 CET 2008
Dear R users,
I'm new but already fascinated R user so please forgive for my
ignorance. I have the problem, I read most of help pages but couldn't
find the solution. The problem follows....
I have large data set 10,000 rows and more than 100 columns... Say
something like
var1,var2,var2,var4.......var120
-------------------------------------------
12,12,345,657,67,8.....
12,12,345,657,0,8.....
NA,12,345,657,NA,8.....
12,12,NA,657,67,8.....
12,12,345,657,NA,8.....
I would like to select only rows where all variables are not NA.... so
I can do something like
df <- subset(
df
, !is.na(var1) & !is.na(var2) &
!is.na(var3) & !is.na(var4) & !is.na(var5)......................
);
But that would be very bad solution because I have more than 100
variables and if would be lengthy code to maintan..... also, it might
be error prone programming style...Am I right?
my question is if there is some smarter way of doing this which would
work even if I have 1000 variables???
More information about the R-help
mailing list