SYNTHETIC EDITORIAL ANSWER KEY, NOT CAPTURED CHATGPT OUTPUT
input rows 8; clean rows 5; duplicate rows 1; quarantined rows 2
clean: r1,001,2026-09-01,North,120.00
clean: r2,002,2026-09-01,North,80.00
clean: r3,003,2026-09-02,South,50.00
clean: r5,004,2026-09-03,East,-20.00
clean: r8,007,2026-09-05,East,0.00
r4 duplicate_of r3; exclude once, retain original fields
r6 impossible date; no replacement inferred
r7 unknown amount; no zero substituted
Known amount totals: input 350.00; clean 230.00; duplicate 50.00; quarantine 70.00
Unknown amount counts: input 1; clean 0; duplicate 0; quarantine 1
Every source_row appears exactly once across clean and exception dispositions.
Change log records trimmed/title-case regions, slash-date normalization and removal of the GBP currency symbol. Representation conversions should be explicit. No order_id loses its leading zero.