Data Cleaning Exercises

Dataset pack

Contacts with three phone slots

A contact form with three phone fields, often filled with the same number twice.

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 Repeated phone columns to distinct rows.

contacts 12 rows × 4 columns

Download contacts.csv (Pro)

Data dictionary

person_id
Person ID (unique).
phone_1
First phone field.
phone_2
Second phone field.
phone_3
Third phone field.

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.