Assemble a data-cleanup prompt

Intermediate · data cleanup · spreadsheets · verification

Your orders export has the usual damage: order_date mixes two date formats, region has 214 blanks, order_id contains 38 suspected duplicates, and amount mixes dot and comma as decimal separators. You need a cleanup plan you can run and verify — not a magic clean file.

Fill the fields to assemble a cleanup request with the mess, the target state, the safety rules and the checks — then compare with a strong example.

The mess — each problem with its count

The target — what the cleaned sheet must look like

Safety rules — what the cleanup may never do

The check — how each step is verified

Your prompt, assembled

Hint

Problems with counts turn vague cleaning into a testable plan — the counts are the specification.

The check field is where the cleanup stops being trust and becomes verification: counts, spot-checks, before/after totals.

From the lesson

Clean up messy data

← All practice