Data Cleaning Exercises

Dataset pack

CRM and web shop customers

Customer records from the CRM and the web shop with different ids, email variants and name spellings.

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 Resolve customer records by normalized email.

customers 17 rows × 4 columns

Download customers.csv (Pro)

Data dictionary

id
Unique record ID.
source
crm or shop.
name
Name as stored in that system; spellings differ across systems; may be missing.
email
Email with possible padding and mixed case; may be blank or missing.

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.