Data Cleaning Exercises

Dataset pack

Repeat sign-ups

People who signed up more than once, with details filled in on some rows and not others.

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 Keep the first row, not the first values.

signups 13 rows × 5 columns

Download signups.csv (Pro)

Data dictionary

id
Unique row ID.
email
Email as typed (identifies the person).
name
Name as typed.
phone
Phone as typed.
signed_up
Sign-up date, YYYY-MM-DD.

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.