Data Cleaning Exercises

Dataset pack

Store files for one load

Three store extracts for the same load, one of which arrived with the wrong columns.

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 Load summary per source file.

north 8 rows × 2 columns

Download north.csv (Pro)

Data dictionary

id
Unique sale ID.
amount
Sale amount as text.

south 5 rows × 3 columns

Download south.csv (Pro)

Data dictionary

id
Unique sale ID.
amount
Sale amount as text.
note
Optional note.

west 3 rows × 2 columns

Download west.csv (Pro)

Data dictionary

id
Unique sale ID.
total
Wrongly named amount column.

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.