Data Cleaning Exercises

Dataset pack

Mixed two- and three-letter country codes

Customer countries captured as ISO alpha-2 or alpha-3 codes, plus a reference 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 Two code systems in one column.

customers 18 rows × 2 columns

Download customers.csv (Pro)

Data dictionary

id
Unique customer ID.
country
Country code as typed.

iso 10 rows × 2 columns

Download iso.csv (Pro)

Data dictionary

code
Accepted code (alpha-2 or alpha-3).
alpha2
Its alpha-2 equivalent.

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.