Hi Eric,
Thanks for your quick response. It works.
Have a nice weekend!
Aiguo
From: Eric Berger
Date: Friday, February 18, 2022 at 3:35 PM
To: "Li, Aiguo (NIH/NCI) [E]"
Cc: "r-help@r-project.org"
Subject: [EXTERNAL] Re: [R] A question of data frame filter based on another one
CAUTION: This email originated from outside of the organization. Do not click
links or open attachments unless you recognize the sender and are confident the
content is safe.
x[apply(y,MAR=1,sum) > 0,]
On Fri, Feb 18, 2022 at 10:24 PM Li, Aiguo (NIH/NCI) [E] via R-help
mailto:r-help@r-project.org>> wrote:
I have tow dataframes as below:
> x
id g
1 1 21
2 3 52
3 2 43
4 4 94
5 5 35
> y
id g
1 1 1
2 0 0
3 0 1
4 1 0
5 1 0
Results dataframe I want is:
1 21
2 43
4 94
5 35
Basically I want to extract all the values in x which corresponding those
values =1 in y.
I tried:
x[which(y==1),]. It gets:
id g
1 1 21
4 4 94
5 5 35
NA NA NA
NA.1 NA NA
But missing the row: 2 43.
Any help will be appreciated.
Thanks,
Aiguo
[[alternative HTML version deleted]]
__
R-help@r-project.org<mailto:R-help@r-project.org> mailing list -- To
UNSUBSCRIBE and more, see
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.
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.