Data Cleaning Exercises

Dataset pack

Orders and product status

Historical order lines and the current product catalog, which marks some products as discontinued.

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 Old orders for discontinued products.

orders 15 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order line ID.
sku
SKU as typed.
qty
Quantity as text.

products 4 rows × 3 columns

Download products.csv (Pro)

Data dictionary

sku
SKU (unique, upper case).
price
Current price.
status
active or discontinued.

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.