Data Cleaning Exercises

Dataset pack

Overlapping customer exports

This week's customer export and an older archive that overlaps with it.

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 Combine overlapping exports.

latest 8 rows × 3 columns

Download latest.csv (Pro)

Data dictionary

id
Customer ID.
email
Email as exported.
plan
Current plan.

archive 6 rows × 3 columns

Download archive.csv (Pro)

Data dictionary

id
Customer ID.
email
Email as exported then.
plan
Plan at the time.

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.