Comment by Razengan
I may try that, but at this point it's already more work wrestling with the AI than just doing it myself.
The most important factor is confidence: After seeing them get some things mixed up a few times, I would have to manually verify the output myself anyway.
----
Re: the multiple comments that suggest to ask AI for code instead of feeding data to the chatbot:
I get what you mean, but I WANT the AI's non-deterministic AIness in this case!
For example, in some countries there are these "omni apps" that can be used for ride hailing or ordering food etc. The bank statement lists all such transactions with the same merchant name. I want the AI to do its AI thing to guess which transactions were rides and which were food deliveries, based on the prices and times etc. Like if there are multiple small transactions those are taxis, and the most expensive transactions during a day are my lunch and dinner.
And there are other cases, that would be too much "imperative" code that would fail anyway.
Like I said, this is a task that any human could do easily after a short explanation, but takes a hell of a lot of wrangling with AI.
This is exactly why you have it write code instead of analyzing the data. You can have tests, you can inspect then code, you know that the process will be deterministic. The chatbot LLMs are a bad match for bulk data analysis on regular, structured data. But they're often quite decent at writing code.