Data Cleaning Exercises

Dataset pack

Daily stock snapshots

Two consecutive full stock snapshots from a warehouse.

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 Snapshots are not deltas.

snap_0629 5 rows × 2 columns

Download snap_0629.csv (Pro)

Data dictionary

sku
SKU.
qty
Units at end of 29 June.

snap_0630 7 rows × 2 columns

Download snap_0630.csv (Pro)

Data dictionary

sku
SKU.
qty
Units at end of 30 June.

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.