Data Cleaning Exercises

Dataset pack

Ticket channels and a dictionary

Support tickets with free-text channels, and the dictionary of spellings already mapped.

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 What the dictionary doesn't cover.

tickets 17 rows × 2 columns

Download tickets.csv (Pro)

Data dictionary

id
Unique ticket ID.
channel
Channel as typed.

dictionary 5 rows × 2 columns

Download dictionary.csv (Pro)

Data dictionary

raw
Covered spelling (lower case, unique).
channel
Standard channel it maps to.

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.