Data Cleaning Exercises

Dataset pack

Payment amounts near the column limit

Payment amounts, some too large for the warehouse's decimal(10,2) column.

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 Amounts that don't fit the column.

payments 15 rows × 2 columns

Download payments.csv (Pro)

Data dictionary

id
Unique payment ID.
amount
Amount as 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.