Data Cleaning Exercises

Dataset pack

Quarterly store sales (wide)

One row per store with a column per quarter; some quarters weren't reported and some are zero.

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 Unpivot quarterly sales, keeping zeros.

sales 6 rows × 5 columns

Download sales.csv (Pro)

Data dictionary

store
Unique store ID.
q1
Q1 sales, whole number or missing.
q2
Q2 sales.
q3
Q3 sales.
q4
Q4 sales.

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.