Data Cleaning Exercises

Dataset pack

Records and CRM emails

Records from three systems to be matched to CRM customers by email.

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 Match rate per source system.

records 16 rows × 3 columns

Download records.csv (Pro)

Data dictionary

id
Unique record ID.
source
Source system.
email
Email as captured.

crm 7 rows × 2 columns

Download crm.csv (Pro)

Data dictionary

email
Customer email (lower case, unique).
customer_id
CRM customer ID.

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.