Merging data

join two data sets keeping the observations in the right one

right_join()

{dplyr}

return unique observations in x or y

union()

{base}

add rows to data frame

add_row()

{tibble}

return observations in x but not y

setdiff()

{base}

return only observations in both x and y

intersect()

{base}

return all observations in x or y

union_all()

{dplyr}

join two data sets keeping all observations in x that have a match in y

semi_join()

{dplyr}

NA

join_by()

{dplyr}

bind columns in dplyr

bind_cols()

{dplyr}

join two data sets keeping the observations in both

full_join()

{dplyr}

bind rows in dplyr

bind_rows()

{dplyr}

join two data sets keeping the observations in the left one

left_join()

{dplyr}

join two data sets dropping all observations in x that have a match in y

anti_join()

{dplyr}

join two data sets keeping the observations that they have in common

inner_join()

{dplyr}

The end!