Dataset pack
Orders and product names
Orders that carry the customer's name, and a product list whose name column means something else.
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 Joins with clashing column names.
orders 13 rows × 3 columns
Download orders.csv (Pro)Data dictionary
- id
- Unique order ID.
- name
- Customer name.
- sku
- SKU as typed.
products 4 rows × 2 columns
Download products.csv (Pro)Data dictionary
- sku
- SKU (upper case, unique).
- name
- Product name.
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.