Data Cleaning Exercises

Dataset pack

Duplicated contacts

Contacts entered several times, where newer copies sometimes lost the phone number.

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 Prefer the most complete record.

contacts 14 rows × 4 columns

Download contacts.csv (Pro)

Data dictionary

id
Unique record ID.
email
Email as entered.
phone
Phone number; may be blank.
updated
Date the record was last updated.

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.