Data Cleaning Exercises

Dataset pack

Contacts and a suppression list

A contact list and an opt-out suppression list that contains blank rows.

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 Exclude a suppression list safely.

contacts 10 rows × 2 columns

Download contacts.csv (Pro)

Data dictionary

id
Unique contact ID.
email
Email as entered.

suppression 4 rows × 1 columns

Download suppression.csv (Pro)

Data dictionary

email
Suppressed email (lower case); may be missing.

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.