Data Cleaning Exercises

Dataset pack

Ages and an age-band table

Self-reported ages to be grouped with the approved age-band table.

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 Bin ages with a band table.

people 18 rows × 2 columns

Download people.csv (Pro)

Data dictionary

id
Unique person ID.
age
Age as text.

bands 121 rows × 2 columns

Download bands.csv (Pro)

Data dictionary

age
Whole age 0–120 as text.
band
Approved band label.

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.