DataCareerHub
Explore learning
← Practice challengesFree companion · 15 minute suggested activity

Normalize a category without losing the source

Data preparation practice · Use the messy source and independent clean control. Corrections belong in a derived output and a change log.

Learn → Try → ExplainReviewed 2026-10-15
01

Your task

The messy export has R02 channel " store ". Define a safe correction. Describe the risk of an automatic correction.

02

Hint

Distinguish formatting fixes from changes in business meaning. Specify what evidence authorizes each correction.

Worked solution

Retain channel_raw, apply trim plus a reviewed case mapping to Store, then check the allowed set {Web,Store}. Reject an unexpected value such as wholesale rather than mapping it silently to Store.

04

What to hand over

Provide raw source fingerprint, old/new values, rule, evidence, affected row IDs and validation totals. A clean-looking table alone is insufficient.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗