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.

Reply via email to