Join two data.tables together
Join two data.tables together
left_join.(x, y, by = NULL)
inner_join.(x, y, by = NULL)
right_join.(x, y, by = NULL)
full_join.(x, y, by = NULL, suffix = c(".x", ".y"))
anti_join.(x, y, by = NULL)
semi_join.(x, y, by = NULL)x |
A data.frame or data.table |
y |
A data.frame or data.table |
by |
A character vector of variables to join by. If NULL, the default, the join will do a natural join, using all variables with common names across the two tables. |
suffix |
Append created for duplicated column names when using |
A data.table
df1 <- data.table(x = c("a","a","a","b","b"), y = 1:5)
df2 <- data.table(x = c("a","b"), z = 1:2)
df1 %>% left_join.(df2)
df1 %>% inner_join.(df2)
df1 %>% right_join.(df2)
df1 %>% full_join.(df2)
df1 %>% anti_join.(df2)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.