Data Cleaning Exercises

Dataset pack

Support tickets by channel

Tickets where agents typed the channel freely: case, spacing and spelling variants.

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 Map channels with an approved dictionary.

tickets 13 rows × 2 columns

Download tickets.csv

Data dictionary

id
Unique ticket ID.
channel
Channel as typed; may be blank, missing or outside the approved dictionary.
idchannel
"tx6ld"""
"t1bmf""Phone "
"t6s3m""TELEPHONE"
"t7f5e"" email"
"tsvpj""Web Chat"
"ta4en""e mail"

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.