Data Cleaning Exercises

Dataset pack

Customer file saved with a BOM

A customer CSV saved as UTF-8 with a byte-order mark before the first header.

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 An invisible character in the header.

customers 9 rows × 3 columns

Download customers.csv (Pro)

Data dictionary

customer_id
Customer ID; the header starts with U+FEFF.
email
Email as typed.
country
Country code 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.