Module 7

Pivoting & joining data

Author

Affiliation

Lars Schöbitz

ETH Zurich

Learning Objectives

1. Learners can apply functions from dplyr to change specific values of a variable in a dataframe.
2. Learners can apply functions from the lubridate package to convert dates not in ISO 8601 to the date class in R.
3. Learners can apply functions from knitr and gt package to display and cross-reference tables in HTML output reports.

Slides

View slides in full screen | Download slides as PDF

Readings

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

Assignments

Due date: November 12, 2025

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

Thank you for working through this assignment.

Quiz

Due date: November 19, 2025

Complete this quiz after you have worked through the assignments. Completing the quiz of each week is required to receive a course certificate at the end of the course.

Quiz in preparation

Session Recording

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

Register for the recording at this link: provided after the session

Note: The video link will be shared once the recording is available.