On Oct 11, 2011, at 11:18 AM, Samir Benzerfa wrote:
Hi everyone,
I've got two data sets as below. My question now is: how can I use
Dataset2
as a filter for Dataset1? My goal is just to keep the rows of
Dataset1 where
the first column (Date) matches the Dates in Dataset2.
Perhaps:
merge(Dataset1, Dataset2)
Or:
Dataset1[ Dataset1$Date %in% Dataset1$Date , ]
--
David.
I would appreciate any solutions to this issue.
Many thanks!
S.B.
Dataset1:
Date A B C D
1 1977 10 11 12 13
2 1978 14 15 16 17
3 1979 18 19 20 21
4 1980 22 23 24 25
5 1981 26 27 28 29
Dateset2:
Date
1 1977
2 1978
3 1979
[[alternative HTML version deleted]]
______________________________________________
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.
David Winsemius, MD
West Hartford, CT
______________________________________________
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.