test[which(test[,"total"] %in% needed),] --- On Fri, 25/9/09, Dimitri Liakhovitski <ld7...@gmail.com> wrote:
> From: Dimitri Liakhovitski <ld7...@gmail.com> > Subject: [R] keeping all rows with the same values, and not only unique ones > To: "R-Help List" <r-h...@stat.math.ethz.ch> > Received: Friday, 25 September, 2009, 8:52 AM > Dear R-ers, > > I have a data frame "test": > test<-data.frame(x=c(1,2,3,4,5,6,7,8),y=c(2,3,4,5,6,7,8,9),total=c(7,7,8,8,9,9,10,10)) > test > > I have a vector "needed": > needed<-c(7,9) > needed > > I need the result to look like this: > 1 2 7 > 2 3 7 > 5 6 9 > 6 7 9 > > When I do the following: > result<-test[test["total"]==needed,] > result > > I only get unique rows that have 7 or 9 in "total": > 1 2 7 > 6 7 9 > > How could I keep ALL rows that have 7 or 9 in "total" > > Thanks a million! > > -- > Dimitri Liakhovitski > Ninah.com > dimitri.liakhovit...@ninah.com > > ______________________________________________ > 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.