dplyr merge dataframes by common row values in R

Question

I have two dataframes from two different years, and I would like to merge them to a single dataframe based on common row values from column code present in both the dataframes.

How can I do this using dplyr in R?

DF1

Code Count_2020
A    1
B    2
C    3
D    4
E    5
F    6

DF2

Code Count_2021
A    4
B    8
C    6
D    8
E    10
F    12
G    2
H    3
I    4
J    5

@akrun, no worries, just waiting for `stackoverflow's` time limit to end, before I can accept the answer. — Ed_Gravy, Aug 05 '21 at 22:10

score 4 · Accepted Answer · answered Aug 05 '21 at 22:06

4

We can use inner_join

library(dplyr)
inner_join(DF1, DF2)

answered Aug 05 '21 at 22:06

akrun

874,273
37
540
662

score 2 · Answer 2 · answered Aug 05 '21 at 22:15

2

Base R:

merge(DF1,DF2)

Outuput:

  Code Count_2021 Count_2020
1    A          4          1
2    B          8          2
3    C          6          3
4    D          8          4
5    E         10          5
6    F         12          6

answered Aug 05 '21 at 22:15

TarJae

72,363
6
19
66

Base R brother. I tried to learn pivoting with base R and I guess this is the hardest thing ever check this link: https://rstudio-pubs-static.s3.amazonaws.com/610313_0328bc102fc1468ba34a9e2ca4c295be.html – Anoushiravan R Aug 06 '21 at 18:20

dplyr merge dataframes by common row values in R

2 Answers2