Predicting the output before running it is how a script I can't write from scratch ended up automating real work

Description and use

Automating password updates in CSV files with a Python script built using a predict‑then‑check loop.

Problem

Automating a manual CSV password update process without writing code from scratch.

Outcome

The script automates password updates, includes backup, error handling, and verification, replacing a manual process.

Workflow

• Specify the exact desired behavior before coding.
• Generate the code using an AI assistant.
• Predict the output and behavior of the generated code.
• Run the script and compare actual results to predictions, learning from discrepancies.

Evidence

It searches CSV files of accounts, finds someone by name or login, and safely updates their password. It backs itself up before touching anything, handles a batch job's leftover error rows without crashing, and replaced a manual find-and-edit process I used to do by hand.

Source