Data Cleaning Exercises

Dataset pack

Pasted-together sales exports

Sales exports pasted into one sheet, with repeated header rows and a TOTAL row.

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 Stray header and total rows.

sales 17 rows × 3 columns

Download sales.csv (Pro)

Data dictionary

id
Sale ID; the text id or TOTAL marks non-record rows.
region
Region as typed.
amount
Sale amount as text.

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.