Data Cleaning Exercises

Dataset pack

Order lines and product catalog

Order lines with hand-typed SKUs, and the product catalog they should match.

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 Look up product names by SKU.

lines 17 rows × 3 columns

Download lines.csv (Pro)

Data dictionary

line_id
Unique line ID.
sku
SKU as typed; may be padded, lower case, missing or unknown.
qty
Quantity as text.

products 4 rows × 2 columns

Download products.csv (Pro)

Data dictionary

sku
Unique upper-case SKU.
name
Product name.

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.