Module 4

Data import & Data organization in spreadsheets

Author

Affiliation

Lars Schöbitz

ETH Zurich

Learning Objectives

1. Learners can import data from files in CSV and XLSX format located in sub-directories of the root directory.
2. Learners can explain the difference between the vector class character and the vector class factor.
3. Learners can discuss the difference between unprocessed raw data, processed analysis-ready data, and data underlying a publication.
4. Learners can apply 12 principles for data organisation in spreadsheets to the layout of a provided dataset.

Slides

View slides in full screen | Download slides as PDF

Readings

1. Read R for Data Science - Section 3 - Workflow: code style

Assignments

Due date: October 08, 2025

• Assignment 1: Data assessment for capstone project
• Assignment 2: Study groups

Thank you for working through this assignment.

Quiz

Due date: October 15, 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.

Access the quiz here: https://u4x6xe-lars-sch0bitz.shinyapps.io/md-04-quiz/

You can verify your submissions using our Live Quiz Checker.

Session Recording

You can access the Zoom recording of Module 4 on October 02, 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/0TtwKqtouNhHcogovS1sQGqCWQz30GvvWzrhVsoG3jww3Rq-AuPqq9TIu66Q3tDf.FIYR3gCRaReqwZfk

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