Data Cleaning Exercises

Dataset pack

Branch sales files without IDs

Daily sales files from two branches with no row IDs, where identical rows are separate sales.

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 Stack files without losing identical rows.

branch_a 10 rows × 3 columns

Download branch_a.csv (Pro)

Data dictionary

sale_date
Sale date.
sku
SKU as typed.
qty
Units sold.

branch_b 7 rows × 3 columns

Download branch_b.csv (Pro)

Data dictionary

sale_date
Sale date.
sku
SKU as typed.
qty
Units sold.

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.