Data Cleaning Exercises

Dataset pack

Orders and customer statuses

Orders from customers with different account statuses, plus a few orders for customers that don't exist.

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 Scope by a reference attribute.

orders 17 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

order_id
Unique order ID.
customer_id
Customer ID as typed.
amount
Order amount as text.

customers 6 rows × 2 columns

Download customers.csv (Pro)

Data dictionary

customer_id
Customer ID (upper case, unique).
status
active, closed or trial.

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.