Data Cleaning Exercises

Dataset pack

Discount codes and rates

Discount codes whose rates were sometimes typed as percents instead of fractions.

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 Rates are fractions, not percents.

discounts 13 rows × 3 columns

Download discounts.csv (Pro)

Data dictionary

id
Unique discount ID.
code
Discount code.
rate
Discount rate as a fraction (0.15 = 15 %), 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.