Module 7

Pivoting & joining data

Author

Affiliation

Lars Schöbitz

ETH Zurich

Learning Objectives

1. Learners can apply functions from the tidyr R Package to transform their data from a wide to a long format and vice versa.
2. Learners can apply functions from the dplyr R Package to join multiple data sets.
3. Learners can understand the relevance a data dictionary to describe variable names in a data set.

Slides

View slides in full screen | Download slides as PDF

Readings

1. Read R for Data Science - Section 20 - Joins

Assignments

Due date: November 19, 2025

• Assignment 1: Pivot your data
• Assignment 2: Get going with your capstone project

Thank you for working through this assignment.

Quiz

No quiz for Module 7

Completing quizzes 1 through 6 is sufficient to successfully complete the course. No additional quiz will be prepared for Module 7.

Session Recording

You can access the Zoom recording of Module 7 on November 13, 2025. To watch the recording, you will need to register for it.

Register for the recording at this link: https://ethz.zoom.us/rec/share/PJwd7X_yGQyy2rNuFNTyymW5khn8KpfJqMiyZolYkFKxoI6rvCHURbv-aPNcf8_u.dP8f8zy7-mZcVyS3

Note: The video will show once the recording has been processed.