Data Cleaning Exercises

Dataset pack

Invoice cost allocations

Invoice costs split across departments by percentage.

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 Allocations must add up to 100%.

allocations 19 rows × 4 columns

Download allocations.csv (Pro)

Data dictionary

id
Unique line ID.
invoice
Invoice number.
dept
Department.
pct
Share of the invoice in percent.

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.