Data Cleaning Exercises

Dataset pack

Coupon redemptions

Redemptions of case-sensitive coupon codes, where some codes differ only by case.

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 Some codes are case-sensitive.

redemptions 17 rows × 2 columns

Download redemptions.csv (Pro)

Data dictionary

id
Unique redemption ID.
coupon
Coupon code as typed (case-sensitive).

coupons 6 rows × 2 columns

Download coupons.csv (Pro)

Data dictionary

code
Coupon code (unique, case-sensitive).
percent
Discount percent, whole number.

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.