Join - dsofe/coderr GitHub Wiki
- merging rows, or compiling rows
# JOIN data sets
# in a way that resembles, visually, "adding" data sets, or adding rows
# create complete data set
df <- tibble(x = 1:4, y = 4:1)
# split data sets
df1 <- df %>%
filter(x <= 2)
df2 <- df %>%
filter(x > 2)
df2.1 <- df %>%
filter(x > 2) %>%
mutate(z = 25:26)
# join data
complete1 <- full_join(df1, df2) # dfs have the same
## GOOD
complete1.1 <- full_join(df1, df2.1) # df1 doesn't have `z`
## GOOD