Question
You need an AI agent to build a Python script that reconciles two CSV exports — a bank statement and your internal ledger — and emits a third CSV of unmatched transactions. The matching key is (date, amount, last-4-of-description), but real data has trailing whitespace, mixed date formats, and occasional duplicate rows. Write the prompt or spec you'd give the agent so it produces a correct, re-runnable script the first time. What would a vague one-line prompt ("write a script to reconcile these two CSVs") get wrong here?
Treat the AI’s output as a draft to verify, not an answer to trust. Name the specific flaw and the input that triggers it, say how you’d catch it — tests, edge cases, reading critically — and how you’d re-prompt or decompose to get it right.
Vibe coding: describe the solution in plain language (or narrate it) and the coach grades your approach. Generating runnable code from your description is coming next.