Data Cleaning Exercises

Dataset pack

People and their addresses

People with addresses typed in inconsistent case and padding.

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 Group people into households.

people 18 rows × 4 columns

Download people.csv (Pro)

Data dictionary

id
Unique person ID.
name
First name.
address
Street address as typed.
postcode
Postcode as typed.

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.