This section provides some pointers on resources related to joining data.
8.5.1 Help on joining tables
For more details on joining data tables with the two-table verbs of the dplyr package (Wickham, François, Henry, & Müller, 2021):
study the vignette
vignette("two-table")for two-table verbs, and
vignette("dplyr")for one-table verbs of dplyr;
study the documentation for
study https://dplyr.tidyverse.org and its examples;
study (the second page of) the RStudio cheatsheet on data transformation:
- A quick tutorial on merging data with the *_join() family of functions in dplyr (by Steven V. Miller, 2021-01-22) explains mutating and filtering joins with additional datasets.
Read and follow the links on Wikipedia:Join_SQL for additional information.