Re: [R] Delete rows in the data frame by limiting values in two columns

From: Henrique Dallazuanna <wwwhsd_at_gmail.com>
Date: Fri, 25 Jun 2010 16:04:48 -0300

Try this:
test[rowSums(mapply('%in%', test[c('x', 'y')], list(c('germany','england','brazil')))) > 0,]

On Fri, Jun 25, 2010 at 4:00 PM, Yi <liuyi.feier_at_gmail.com> wrote:

> Hi, folks,
>
> Finally Friday~~ Here comes the question:
>
> x=c('germany','poor italy','usa','england','poor italy','japan')
> y=c('Spain','germany','usa','brazil','england','chile')
> s=1:6
> z=3:8
> test=data.frame(x,y,s,z)
>
> #Now I only concern the countries ('germany','england','brazil'). I would
> like to keep the rows where these three countries
> #are involved either in test$x OR test$y. So the result should be like as
> follows (I did this manually >< ):
>
> x y s z
> 1 germany Spain 1 3
> 2 poor italy germany 2 4
> 3 england Brazil 4 6
> 4 poor italy england 5 7
>
> Any codes work for this?

>
> Thanks great in advance.
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>

-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]


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

Received on Fri 25 Jun 2010 - 19:08:42 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 25 Jun 2010 - 19:10:35 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive