Data Cleaning Exercises

Dataset pack

Order export with Windows line endings

An order file exported on Windows; the last column carries stray carriage returns.

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 Windows line endings in the last column.

orders 16 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
qty
Quantity as text.
status
Order status; may end with \r.

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.