How to merge 2 data sets using 2 common columns in each in R

Question

I'm trying to merge two data frames based on 2 columns in each. I want to merge the Territory column and IDMate column from Data Frame 2 to Data Frame 1 based on matching ID and Year columns.

Data Frame 1:

Data Frame 2:

       ID Year Territory  IDMate
    1  1 1998         A    22
    2  1 1999         B    24
    3  1 2000         C    25
    4  2 2001         D    26
    5  2 2002         E    27
    6  3 2005         F    28
    7  4 2008         G    29

Goal is to get this:

       ID Year Territory  IDMate
    1  1 1998         A    22
    2  2 2001         D    26
    3  3 2005         F    28
    4  4 2008         G    29

Simply `merge` should work`merge( dataframe1, dataframe2)` – S Rivero Jul 03 '17 at 20:11 — S Rivero, Jul 03 '17 at 20:11

score -1 · Answer 1 · answered Jul 03 '17 at 20:09

-1

common <- intersect(data.frame1$col, data.frame2$col) data.frame2[common,]

Hopefully, this will get you what you want

answered Jul 03 '17 at 20:09

Harjeet Singh Bariar

120
1
10

Thanks! I haven't tried this code yet because I used the one George Wood recommended and it seemed to have worked. Thanks for helping! I really appreciate it! – Jennifer Diamond Jul 03 '17 at 22:37

score -1 · Accepted Answer · answered Jul 03 '17 at 20:11

-1

You can use left_join from dplyr:

library(dplyr)
res <- left_join(df1, df2, by = c("ID", "Year"))

#  ID Year Territory IDMate
#   1 1998         A     22
#   2 2001         D     26
#   3 2005         F     28
#   4 2008         G     29

answered Jul 03 '17 at 20:11

George Wood

1,914
17
18

How to merge 2 data sets using 2 common columns in each in R

2 Answers2