Data Cleaning Exercises

Dataset pack

Nightly order batch

A nightly order batch that overlaps with orders an earlier run already loaded.

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 Load a new batch only once.

batch 12 rows × 2 columns

Download batch.csv (Pro)

Data dictionary

order_id
Order ID (unique in the batch).
amount
Order amount as text.

loaded 5 rows × 2 columns

Download loaded.csv (Pro)

Data dictionary

order_id
Order already in the warehouse.
loaded_on
Date it was loaded.

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.