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

Protect cents and identifiers during import

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

Why should order IDs remain text and net_cents become an integer? 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

IDs are labels, not quantities; preserve prefixes and any leading zeros. net_cents must parse as a nonnegative integer. A value such as "12 EUR" should be rejected for review, not coerced to zero.

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 ↗