Combine two dataframes based on the values of a specific column

Asked Jul 14 '23 at 08:09

Active Jul 14 '23 at 08:09

Viewed 22 times

I have the following dataframe:

Code, Name_A
1,    Name1
2,    Name2
3,    Name3
4,    Name4
5,    Name5
6,    Name6

and another dataframe, called df2, which has a subset of the rows of dataframe 1:

Code, Name_B
1,    Name1
3,    Name3
6,    Name6

I would like to combine df1 and df2 to construct a new dataframe, df3, as follow:

Code, Name_A,Name_B
1,    Name1, Name1
2,    Name2,
3,    Name3, Name3
4,    Name4,
5,    Name5,
6,    Name6, Name6

asked Jul 14 '23 at 08:09

1

Do you need a left join like `left_join(df1,df2,by="Code")`? – Quinten Jul 14 '23 at 08:11
Here's a useful reference: https://dplyr.tidyverse.org/reference/mutate-joins.html (it's tidyverse style, if that matters to you). – Paul Stafford Allen Jul 14 '23 at 08:22

0 Answers0