Data Cleaning Exercises

Dataset pack

Vendor customer file

A customer extract from a vendor system with display-style headers and zero-padded IDs.

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 Rename vendor columns and type them.

customers 18 rows × 3 columns

Download customers.csv (Pro)

Data dictionary

Customer ID
Zero-padded customer ID; text.
Signup Date
Signup date, YYYY-MM-DD.
Total Spend
Lifetime spend as text; empty when unknown.

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.