Anisa Dhana shows off several tidyverse methods for combining data sets together:
The goal of this Tidyverse section is to learn. Subsetting Datasets; Merging Datasets; Summarizing; Plotting; In this section we will be continuing to be working with the BLS data we downloaded in the Introduction. Tidyverse provides us with some useful tools for data manipulation and cleaning. Discover how to merge data sets in R using rbind and fulljoin while exploring innerjoin, rightjoin, and leftjoin in RStudio. # Tidyverse allows us to quickly and easily load many useful.
semi_join function is different than the previous examples of joins. A semi join creates a new dataset in which there are all rows from the
data1 where there is a corresponding matching value in
data2. Still, instead of the final dataset merging both the first (data1) and second (data2) datasets, it only contains the variables from the first one (data1).
Most of this looks like standard SQL joins, but read through to the end for a bonus which doesn’t typically appear in relational database products.