Data Cleaning Exercises

Dataset pack

Versioned order lines

Order lines re-sent with increasing versions; multi-line orders are common.

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 Deduplicate order lines at the right grain.

lines 15 rows × 5 columns

Download lines.csv (Pro)

Data dictionary

ingest_id
Unique row ID.
order_id
Order number.
line_id
Line within the order.
version
Whole-number version; unique within (order_id, line_id).
amount_cents
Line amount in cents.

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.