Data Cleaning Exercises

Dataset pack

Orders and a customer crosswalk

Orders keyed by shop or CRM customer keys, and the crosswalk that maps each key to a master customer.

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 Resolve customers through a crosswalk.

orders 15 rows × 3 columns

Download orders.csv (Pro)

Data dictionary

id
Unique order ID.
source_key
Customer key from the shop or the CRM.
amount
Order amount as text.

xwalk 6 rows × 2 columns

Download xwalk.csv (Pro)

Data dictionary

source_key
Source system key (unique, upper case).
master_id
Master customer ID.

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.