Data Cleaning Exercises

Dataset pack

Payments with currency codes

Payments where currency codes and amounts were typed by hand.

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 Validate currency, then amount.

payments 13 rows × 3 columns

Download payments.csv (Pro)

Data dictionary

id
Unique payment ID.
currency
Currency code as typed.
amount
Amount as text with up to two decimals.

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.