Data Cleaning Exercises

Dataset pack

Survey answers (wide)

One row per respondent and one column per question; unanswered questions are missing.

Fictional data · UTF-8 CSV, every value quoted so padding and leading zeros survive; empty fields are missing values · free for personal and classroom practice · practise it in Unpivot survey answers without inventing scores.

survey 6 rows × 4 columns

Download survey.csv

Data dictionary

respondent
Unique respondent ID.
q1
Answer 1–5 or missing.
q2
Answer 1–5 or missing.
q3
Answer 1–5 or missing.
respondentq1q2q3
"r344""2""1"∅
"r390"∅∅∅
"r342""5""3"∅
"r340"∅"1""2"
"r341""5"∅"1"
"r343""3""2""4"

Values are shown in quotes so leading and trailing spaces are visible. ∅ means the cell is missing. Exercises are also graded on hidden datasets that are never published.