[R] keeping all rows with the same values, and not only unique ones

[Moshe Olshansky]

test[which(test[,"total"] %in% needed),]

--- On Fri, 25/9/09, Dimitri Liakhovitski <ld7631 at gmail.com> wrote:

> From: Dimitri Liakhovitski <ld7631 at gmail.com>
> Subject: [R] keeping all rows with the same values, and not only unique ones
> To: "R-Help List" <r-help at 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.Liakhovitski at ninah.com
> 
> ______________________________________________
> 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.
>