This is the fourth post in the series where we explore the OpenAI Assistants API. In this post, we will be looking at the code interpreter tool which allows us to generate charts based on some data. This is very powerful for scenarios where you have to do data analysis on JSON, csv or Microsoft Excel files and generate charts and reports based on them.
See the following posts for the entire series:
Working with the OpenAI Assistants API: Create a simple assistant
Working with the OpenAI Assistants API: Using file search
Working with the OpenAI Assistants API: Chat with Excel files using Code interpreter
Working with the OpenAI Assistants API: Using code interpreter to generate charts (this post)
The Code Interpreter tool has access to a sandboxed python code execution environment within the Assistants API. This can provide very useful as the Assistants API can iteratively run code against the files provided to it and generate charts!
So in this post, let's see how we can generate charts based on an excel file with the code interpreter tool. The excel file we will be querying will be the same one we used in the last post. It contains details of customers like their name and the licenses purchased of a fictional product by them:
To generate charts using the Code interpreter, we have to use the following moving pieces:
- First, we need to upload the excel file using the Open AI File client
- Then, we need to connect the uploaded file to the Code Interpreter tool in either an assistant or a thread which would enable the assistant to generate a chart on the document.
And this is the file generated by the code interpreter tool:
As you can see the code interpreter tool takes a few passes at the data. It tries to understand the document before generating the chart. This is a really powerful feature and the possibilities are endless!
Hope this helps.