Write a reusable prompt with replaceable inputs. Submit your prompt and one test output for this example.
Task: Design an auditable data-cleaning workflow for a small table.
Example input: CSV columns: id,date,minutes,status. Rows: "A1,2026-06-02,30,done"; "A2,2026-06-03, 45 ,Done"; "A2,2026-06-03, 45 ,Done"; "A3,03/04/2026,twenty,pending"; "A4,2026-06-05,-10,done"; "A5,,25, pending ". Rules: IDs must be unique, dates must be ISO YYYY-MM-DD, minutes must be a nonnegative integer, and status must be done or pending. Ambiguous dates must not be interpreted without clarification.
Constraints:
- Trim whitespace and normalize status case.
- Remove only exact duplicate records after harmless whitespace normalization.
- Retain invalid or missing values with an explicit issue flag.
Required output from your prompt: A cleaned table, a row-level change log, and a separate list of unresolved issues requiring human review.
Success checks:
- The duplicate A2 appears once.
- A3’s ambiguous date and text duration are flagged.
- A4’s negative duration and A5’s missing date remain visible.
- No unsupported replacement value is invented.