Data Cleaning Exercises

Dataset pack

Ticket sources and channel map

Ticket sources typed by agents and the approved mapping to reporting channels.

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 Report unmapped values as other.

tickets 14 rows × 2 columns

Download tickets.csv (Pro)

Data dictionary

id
Unique ticket ID.
source
Source as typed.

channel_map 7 rows × 2 columns

Download channel_map.csv (Pro)

Data dictionary

raw
Normalized source (unique).
channel
Reporting channel.

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.