[R] Select only rows that don't contain one number

[Bert Gunter]

or

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

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

-- Bert

On Tue, Jul 30, 2013 at 7:30 AM, arun <smartpink111 at yahoo.com> wrote:
> 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.
>
>
> ______________________________________________
> 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