Data Cleaning Exercises

Dataset pack

Exports with different column orders

Two exports with the same columns in a different order.

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 Stack by column name, not position.

a 8 rows × 3 columns

Download a.csv (Pro)

Data dictionary

id
Unique row ID.
amount
Amount as text.
region
Region.

b 7 rows × 3 columns

Download b.csv (Pro)

Data dictionary

region
Region.
id
Unique row ID.
amount
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.