Data Cleaning Exercises

Dataset pack

Apparel stock by size

Stock counts per SKU and size, with sizes spelled several ways, and the size order table.

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 Sizes have an order, letters don't.

stock 17 rows × 4 columns

Download stock.csv (Pro)

Data dictionary

id
Unique row ID.
sku
SKU as typed.
size
Size as typed.
qty
Units in stock.

sizes 5 rows × 2 columns

Download sizes.csv (Pro)

Data dictionary

size
Standard size (unique).
rank
Order of the size, 1 = smallest.

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.