Data Cleaning Exercises

Dataset pack

Suppliers with hand-typed country codes

Supplier master data where country codes were typed by hand in mixed case and spacing.

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 Validate supplier country codes.

suppliers 16 rows × 3 columns

Download suppliers.csv (Pro)

Data dictionary

id
Unique supplier ID.
name
Supplier name.
country
Country code as typed; approved codes are US, GB, DE, FR, NL.

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.