[R] Remove rows with NA across all columns

Bert Gunter gunter.berton at gene.com
Fri Feb 15 06:03:08 CET 2008


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: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On
Behalf Of joseph
Sent: Thursday, February 14, 2008 8:53 PM
To: r-help at r-project.org
Cc: r-help at 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 at 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.



More information about the R-help mailing list