Data Cleaning Exercises

Dataset pack

Order values by channel

Orders from three sales channels with a few missing or broken amounts.

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 Average order value per channel.

orders 19 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
channel
Sales channel as typed.
amount
Order 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.