Data Cleaning Exercises

Dataset pack

Contact preference checkboxes

A preference form that stored each channel checkbox in its own column.

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 Checkbox columns to rows.

prefs 13 rows × 4 columns

Download prefs.csv (Pro)

Data dictionary

respondent
Respondent ID (unique).
email_opt
x when email was ticked.
sms_opt
x when SMS was ticked.
post_opt
x when post was ticked.

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.