Data & analysisData cleaningdata

Document a category recode

Shows what changed when labels were consolidated.

Editorial illustration for this prompt; the prompt itself does not generate this image.

Ready to use

Prompt

Inputs: [OLD CATEGORIES], [NEW CATEGORIES], [SAMPLE ROWS]. Build an explicit old-to-new mapping with ambiguous cases held for review. Quantify counts before and after without erasing original values. Output: A crosswalk, unmatched queue and audit totals. Check: Every input category maps once or is flagged; totals reconcile. If essential information is missing, identify it rather than filling the gap with a guess. Report the count and percentage of rows still awaiting a mapping decision.