[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