Data Cleaning Exercises

Dataset pack

Customer tier history

A customer tier history table with closed versions and current rows, including a duplicate open 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 Current rows from a history table.

history 14 rows × 5 columns

Download history.csv (Pro)

Data dictionary

row_id
Unique row ID.
customer
Customer code.
tier
Tier name.
valid_from
Start date of the version.
valid_to
End date; empty for the current version.

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.