Data Cleaning Exercises

Dataset pack

Payments in several currencies and locales

Amounts written with US or German separators, sometimes in parentheses for negatives, in several currencies.

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 Sum amounts by currency, without converting.

payments 18 rows × 4 columns

Download payments.csv (Pro)

Data dictionary

id
Unique payment ID.
raw
Amount text using the row's locale separators.
locale
en-US, de-DE, another locale, or missing.
currency
Three-letter currency code.

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.