Data cleaning steps you won't redo
Research and writingAnalyst working on CSVs with an agent
We cleaned a messy sales export: fixed dates, merged two customer columns, dropped test rows. The next month's export needed the same cleaning, and the agent worked it all out again.
How do I get an AI agent to reuse last month's CSV cleaning steps on the new export?
Save the cleaning steps with the task in ArcRoom. Next month, find_task returns them, and the agent applies the same steps and flags anything new. If the export format changes, the old steps won't fit.
Also asked as: My agent works out the same data cleaning every month. How do I stop that? · How do I save data cleaning steps an AI agent can repeat? · Can an AI agent remember how I cleaned a sales export last time?
The cleaning steps are saved with the task.
- Reused answer
find_task → reuse: "clean sales export" 1 parse dd/mm dates 2 merge cust_id+customer 3 drop rows where email ends @test
Step by step
- The cleaning steps are saved with the task.
- Next month, find_task returns them.
- The agent applies the same steps and flags anything new.
What the agent sees
find_task → reuse: "clean sales export" 1 parse dd/mm dates 2 merge cust_id+customer 3 drop rows where email ends @testCompared with today's tools
A saved cleaning script (DIY)
Ask the agent to write the cleaning as a script, commit it and run it on next month's export.
- Setup
- 30 min
- Ongoing
- patch it when columns change
ArcRoom
Every agent reads the team playbook before it works and writes to it when it finishes. Nothing to update by hand.
- Setup
- 2 min (npx arcroom init)
- Ongoing
- None
For a repeat export a script is the better tool; ArcRoom keeps the reasons for each step, which helps when the format shifts.
Where it stops
If the export format changes, the old steps don't fit.
Try it in your project
Works with the agents your team already uses, and any agent over MCP or the HTTP API.