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
[email protected]
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
[email protected]
______________________________________________
[email protected] 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.
______________________________________________
[email protected] 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.
