Participants are expected to have some experience with basic data manipulation using R. If you are new to R and dplyr package, consider attending our beginner R worksops first. See the UBC library Research Commons event calendar.
Learning objectives
This workshop will introduce how to work with multiple data frames in R. At the end of this workshop, you will be able to:
- Understand the need to work with multiple data frames.
- Identify primary keys and foreign keys for data frames.
- Use different join functions to gain insights from multiple data frames.
Schedule
| 0:00 - 0:05 | Welcome and using Zoom |
| 0:05 - 0:15 | Warm-up |
| 0:15 - 0:35 | Keys |
| 0:35 - 0:55 | Joins |
| 0:55 - 1:00 | Wrap-up and Discussion |
| 1:00 - 1:30 | Optional Q & A |
Materials
The following R markdown files contain R code used during the workshop. Please download the first file and open it with R Studio. The second file contains answers to exercises in the first file.
Resources
- Chapter 13 Relational data in the book R for Data Science
- Chapter 31 Working with multiple data frames in the book R for Epidemiology
This workshop was developed by Ashley Yue Mao (Author).