The merge function and its optional parameters allow you to:
R automatically joins the frames by common variable names, thus the inner join merge(df1, df2) will work for these cases. However, you should probably specify merge(df1, df2, by = "CustomerId") to ensure that you were matching on exactly the fields you required. If the matching variables have different names in the various data frames, you may also use the by.x and by.y arguments.
Merge: outer join
(by = "CustomerId," all = TRUE, x = df1, y = df2)
Left outer: merge(x = df1, y = df2, by = "CustomerId", all.
x = TRUE)
Right outer: merge(x = df1, y = df2, by = "CustomerId", all.
y = TRUE)
Cross join: merge
(x = df1, y = df2, by = NULL)
Just as with the inner join, you would probably want to explicitly pass