Data Cleaning Exercises

Dataset pack

Invoice totals with formatting problems

Invoices from a billing export with missing, malformed and negative totals.

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 Validate invoice totals.

invoices 17 rows × 3 columns

Download invoices.csv (Pro)

Data dictionary

id
Unique invoice ID.
customer
Customer name.
total
Invoice total as text, expected as a plain number with up to two decimals.

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.