Data Cleaning Exercises

Dataset pack

Quantities with free-text units

Ingredient lines with quantities and units typed in many ways.

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 Units spelled many ways.

lines 20 rows × 4 columns

Download lines.csv (Pro)

Data dictionary

id
Unique line ID.
item
Ingredient.
qty
Quantity as text.
unit
Unit as typed.

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.