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 <smartpink...@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.liakhovit...@gmail.com> > To: r-help <r-help@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@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@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 ______________________________________________ R-help@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.
