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

Reply via email to