Data Cleaning Exercises

Dataset pack

Member birth dates with placeholders

A membership export where unknown birth dates were stored as 1900-01-01 or 0001-01-01.

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 Placeholder dates mean unknown.

members 16 rows × 3 columns

Download members.csv (Pro)

Data dictionary

id
Unique member ID.
name
First name.
birth_date
Birth date, YYYY-MM-DD; placeholders mean unknown.

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.