Data Cleaning Exercises

Dataset pack

Customer spend for a partner

A customer table with personal details, of which a partner may receive only city-level spend.

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 Share only the columns needed.

customers 11 rows × 6 columns

Download customers.csv (Pro)

Data dictionary

customer_id
Pseudonymous customer ID.
full_name
Personal name (do not share).
email
Email (do not share).
phone
Phone (do not share).
city
City as typed.
lifetime_spend
Lifetime spend as text.

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.