Data Cleaning Exercises

Dataset pack

Orders with missing statuses

An order export where cancelled orders must be excluded and some statuses are missing.

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 Exclude cancelled, keep unknown status.

orders 17 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
status
Order status as typed; may be missing.
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.