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

[Phil Spector]

Dimitri -
    Use %in% instead of ==:

> test[test$total %in% needed,]
   x y total
1 1 2     7
2 2 3     7
5 5 6     9
6 6 7     9

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu


On Thu, 24 Sep 2009, Dimitri Liakhovitski wrote:

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