Data Cleaning Exercises

Dataset pack

Amounts from two offices

Amount files from a German and a US office, each using its local number format.

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 Number format depends on the file.

de 9 rows × 2 columns

Download de.csv (Pro)

Data dictionary

id
Unique row ID.
amount
Amount in German format (1.234,50).

us 10 rows × 2 columns

Download us.csv (Pro)

Data dictionary

id
Unique row ID.
amount
Amount in US format (1,234.50).

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.