How to merge this two dataframes this way

Question

I would like to merge this two dataframes :

library(dplyr)
table1 <- data.frame(
  siren = "A",
  siret = "X",
  var1 = 0
)
table2 <- data.frame(
  siren = c("A","A"),
  siret = c("X","Y")
)

Expected result :

result <- data.frame(
  siren = c("A","A",
  siret = c("X","Y"),
  var1 = c(0,NA)
)

Maybe it could be done with a left_join in dplyr ?

Many thanks in advance

Yes I tried `table3 <- table1 %>% left_join(table2,by = c("siren"))` but it's not the result expected — Damien Dotta, Mar 03 '21 at 20:11

score 1 · Answer 1 · answered Mar 03 '21 at 20:14

1

Try this

full_join(table1, table2)

answered Mar 03 '21 at 20:14

big parma

score 1 · Answer 2 · answered Mar 03 '21 at 20:16

1

Almost :) Try a right_join.

    right_answer <- right_join(table1, table2)

EDIT: As above commenter said, a full_join is a better habit to get into using, though a right_join will get the job done here.

answered Mar 03 '21 at 20:16

Anoraka

score 1 · Accepted Answer · answered Mar 03 '21 at 20:16

1

We can use left_join on table2

library(dplyr)
left_join(table2, table1)

by is not really needed here as it will pick it from the matching names

answered Mar 03 '21 at 20:16

akrun

3 Answers3