Data Cleaning Exercises

Dataset pack

Invoices and CRM billing emails

Invoices to be emailed, and a CRM extract where some customers lack a billing 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 The referenced record is incomplete.

invoices 17 rows × 3 columns

Download invoices.csv (Pro)

Data dictionary

invoice_id
Unique invoice ID.
customer_id
Customer ID as typed.
amount
Invoice amount as text.

crm 5 rows × 2 columns

Download crm.csv (Pro)

Data dictionary

customer_id
Customer ID (upper case, unique).
billing_email
Billing email; may be 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.