merge(x = df1, y = df2, by = "Name")
merge(
x = df1,
y = df2,
by = intersect(names(x), names(y)),
by.x = by,
by.y = by,
all = FALSE, -- Shorthand for all.x and all.y
all.x = all,
all.y = all,
sort = TRUE,
suffixes = c(".x",".y"), -- To make unique the columns names
incomparables = NULL,
...
)
where:
The default method coerces the arguments to data frames and calls the “data.frame” method.
SQL - (Equi|Simple|Inner|Natural) Join
merge(df1, df2)
merge(x = df1, y = df2, by = "Name", all.x = TRUE)
merge(x = df1, y = df2, by = "Name", all.y = TRUE)
merge(x = df1, y = df2, by = "Name", all.y = TRUE, all.x = TRUE)
# or
merge(x = df1, y = df2, by = "Name", all = TRUE)
merge(x = df1, y = df2, by = NULL)