Data Cleaning Exercises

Dataset pack

Contact emails

Emails with padding and mixed case, including dots and plus tags that must be kept.

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 Normalize emails under a declared policy.

contacts 12 rows × 2 columns

Download contacts.csv

Data dictionary

id
Unique contact ID.
email
ASCII email address with possible padding and mixed case.
idemail
"c2e40""\ts.am@Shop.Example.net "
"co4rf"" carol_99@MAIL.example.org "
"cf5co""Sam+offers@example.COM"
"c3vyo"" carol_99@Example.com "
"cgbcs""\tbob@example.com\t"
"cmnxs"" Sam+offers@Shop.Example.net "

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.