Data Cleaning Exercises

Dataset pack

Sales and refunds

Transactions including very large sales and negative refunds.

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 Flag large transactions, keep refunds.

transactions 9 rows × 3 columns

Download transactions.csv

Data dictionary

id
Unique transaction ID.
type
sale or refund.
amount
Amount with up to 2 decimals; refunds are negative.
idtypeamount
"twnh2""sale""128.99"
"tthzj""sale""3529"
"tkv8b""sale""8988.5"
"two43""sale""280.05"
"tgsij""sale""11052.01"
"t958j""refund""-3290.10"

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.