Data Cleaning Exercises

Dataset pack

International order dates

Orders from shops in several countries, with dates typed in each country's convention.

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 Date format depends on the country.

orders 16 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
country
Shop country code.
order_date
Order date as typed.

countries 4 rows × 2 columns

Download countries.csv (Pro)

Data dictionary

country
Country code (unique).
date_order
DMY or MDY.

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.