Select only rows that don't contain one number

or

x[ !rowSums(x == -1), ]

 if you are willing to tolerate the coercions and equality testing.

-- Bert
x[rowSums(!x<0)==ncol(x),] #if you don't want x<0
#  a b c d e
#3 2 3 3 4 3
#5 4 5 5 6 4

#or
 x[rowSums(!x==-1)==ncol(x),]
#  a b c d e
#3 2 3 3 4 3
#5 4 5 5 6 4

A.K.

----- Original Message -----
From: Dimitri Liakhovitski <dimitri.liakhovitski at gmail.com>
To: r-help <r-help at r-project.org>
Cc:
Sent: Tuesday, July 30, 2013 10:06 AM
Subject: [R] Select only rows that don't contain one number

Hello!

I have a data frame:

x<-data.frame(a=c(-1,1,2,3,4),b=c(1,-1,3,4,5),c=1:5,d=2:6,e=c(1,2,3,-1,4))
x

How can I grab only those rows that don't contain any -1s (no matter in
what columns? Without writing a loop.
In other words, I want my output to contain only rows 3 and 5 of x.

Thank you very much!

    [[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.

Bert Gunter
Genentech Nonclinical Biostatistics

Internal Contact Info:
Phone: 467-7374
Website:
http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm

Select only rows that don't contain one number

Thread (7 messages)