R- delete rows in multiple columns by unique number

Posted by Vincent Moriarty on Stack Overflow See other posts from Stack Overflow or by Vincent Moriarty
Published on 2012-06-11T04:07:38Z Indexed on 2012/06/11 4:40 UTC
Read the original article Hit count: 194

Filed under:

Given data like this

C1<-c(3,-999.000,4,4,5)
C2<-c(3,7,3,4,5)
C3<-c(5,4,3,6,-999.000)
DF<-data.frame(ID=c("A","B","C","D","E"),C1=C1,C2=C2,C3=C3)

How do I go about removing the -999.000 data in all of the columns

I know this works per column

DF2<-DF[!(DF$C1==-999.000 | DF$C2==-999.000 | DF$C3==-999.000),]

But I'd like to avoid referencing each column. I am thinking there is an easy way to reference all of the columns in a particular data frame aka:

DF3<-DF[!(DF[,]==-999.000),]

or

DF3<-DF[!(DF[,(2:4)]==-999.000),]

but obviously these do not work

And out of curiosity, bonus points if you can me why I need that last comma before the ending square bracket as in:

==-999.000),]

© Stack Overflow or respective owner

Related posts about r