Learn to use the power and flexibility of R subscripting. ## Warning:untested
apply(df,1,function(x)any(!is.na(x))) gives TRUE for all rows that aren't all NA's. So stick this expression into the 1st coordinate of a subscript for the df: df[apply(df,1,function(x)any(!is.na(x))),] Cheers, Bert Gunter Genentech -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joseph Sent: Thursday, February 14, 2008 8:53 PM To: r-help@r-project.org Cc: r-help@r-project.org Subject: [R] Remove rows with NA across all columns Hi I have a data frame df with 3 columns. Some rows are NA across all 3 columns. How can I remove rows with NA across all columns? df=data.frame(col1=c(1:3,NA,NA,4),col2=c(7:9,NA,NA,NA),col3=c(2:4,NA,NA,4)) Thanks Joseph ____________________________________________________________________________ ________ Be a better friend, newshound, and [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
