Data Cleaning Exercises

Dataset pack

Expense claims by category

Expense claims with hand-typed categories and some malformed amounts.

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 Expense totals by category.

expenses 15 rows × 3 columns

Download expenses.csv (Pro)

Data dictionary

id
Unique claim ID.
category
Category as typed; may be missing.
amount
Amount as text 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.