Data Cleaning Exercises

Dataset pack

Orders for a repeat-customer list

Orders with mixed statuses, to find customers with at least two paid orders.

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 Filter rows, then filter groups.

orders 18 rows × 4 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
customer
Customer handle.
status
Order status.
amount
Order amount 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.