Member-only story
How to use OpenAI’s Code Interpreter to Analyze Data
Exploring SaaS Revenue Multiples with the Help of AI
I’ve put off writing new data analysis posts for a while now. The return on investment seemed too low. Gathering data, cleaning it, and writing fine-tuned plotting code takes a long time and involves lots of tedious work.
But times have changed! I saw that OpenAI finally releasing their Code Interpreter tool, potentially freeing me from the need to do boring and repetetive data tasks. Let’s see how AI can help me on a project I’ve been putting off for monts — a follow up of to my story SaaS Revenue Multiples, Interest Rates, and Modeling in R
Getting the Data
This is the one area where Code Interpreter can’t yet help. I had to go out myself and collect data from the following sources:
- Stock Price-to-Sales from Macrotrends
- Federal Funds Rates from the St Louis Federal Reserve page
- Treasury yield data from the Deptartmen of the Treasury site
Without the help of AI, I also wrote the python code to parse and combine these sources into a single csv file. Here too, I should have used AI tools. ChatGPT for example is great at generating python pandas code for data manipulation.
