Data Cleaning Exercises

Dataset pack

Club members with common names

A membership list where common names repeat and some members were entered 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 Same name is not the same person.

members 15 rows × 4 columns

Download members.csv (Pro)

Data dictionary

id
Unique member record ID.
name
Name as entered.
birth_date
Birth date, YYYY-MM-DD.
city
Home city.

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.