Data Cleaning Exercises

Dataset pack

Monthly export files

Three monthly files: one without the optional channel column, one with it, and one with a broken schema.

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 Append monthly files under a declared schema.

jan 6 rows × 2 columns

Download jan.csv

Data dictionary

id
Row ID.
amount
Whole-number amount.
idamount
"iz6d""8"
"rna5""262"
"s38t""410"
"pk5w""345"
"r8id""426"
"azjp""425"

feb 4 rows × 3 columns

Download feb.csv

Data dictionary

id
Row ID.
amount
Whole-number amount.
channel
Sales channel (optional column).
idamountchannel
"irsl""91""web"
"byjg""143""store"
"fate""28"∅
"ujtb""207""store"

bad 3 rows × 2 columns

Download bad.csv

Data dictionary

id
Row ID.
currency
Unexpected column; amount is missing.
idcurrency
"o8wv""EUR"
"vmuv""EUR"
"yt74""EUR"

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.