Data Cleaning Exercises

Dataset pack

Customer order dates

Order dates per customer, typed in mixed case, with some missing and impossible dates.

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 First and last order per customer.

orders 20 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

order_id
Unique order ID.
customer
Customer account name as typed.
order_date
Order date, YYYY-MM-DD as text; may be missing or invalid.

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.