Curious, is there a reason to get Python script instead of Custom Chat GPT? I have successfully created custom chat GPTs for spreadsheet processing. My sense is that Python scripts are a lot more reliable as Custom GPTs still hallucinate from time to time. Is that the primary reason?
Yes, exactly! When you use a custom GPT for spreadsheet processing, it’s running the new data through the LLM, and the results are similar but not identical because inherently there’s a probabilistic output with LLMs. Creating a python script lets you remove that probabilistic variation — once you lock down a version of the python script, the business logic stays the same and the same inputs always get the same outputs.
Amazing explanation of how to expand our use of AI for financial work! Thank you so much
Curious, is there a reason to get Python script instead of Custom Chat GPT? I have successfully created custom chat GPTs for spreadsheet processing. My sense is that Python scripts are a lot more reliable as Custom GPTs still hallucinate from time to time. Is that the primary reason?
Yes, exactly! When you use a custom GPT for spreadsheet processing, it’s running the new data through the LLM, and the results are similar but not identical because inherently there’s a probabilistic output with LLMs. Creating a python script lets you remove that probabilistic variation — once you lock down a version of the python script, the business logic stays the same and the same inputs always get the same outputs.
got it thank you for responding. I think Power Query could handle many of these tasks? https://www.youtube.com/watch?v=GNgutUElOTk&t=64s