Async OpenAI not Compatible with PandasAI

[julianmukaj]

System Info

pandasai 2.4.0

🐛 Describe the bug

Can we see a working example of AsyncOpenAI Working with PandasAI? The models in the examples/base classes are all synchronous

[dosubot[bot]]

Hey @julianmukaj! I'm here to help you with any bugs, questions, or contributions you have. Let's take a look at the issue you're facing.

Currently, there is no built-in support for asynchronous operations in PandasAI, and the library primarily uses synchronous models for handling OpenAI API calls. The requests library, which PandasAI uses for API requests, does not natively support asynchronous operations ^[1].

To integrate asynchronous operations, you would need to modify the codebase to use an asynchronous HTTP client, such as httpx or aiohttp, and refactor the API call handling to support async/await syntax. This would involve changes in the parts of the code responsible for API interactions, such as the OpenAI class in pandasai/llm/openai.py ^[2].

As of now, there are no examples or documentation in the PandasAI repository demonstrating the integration of asynchronous models .

To continue talking to Dosu, mention @dosu.

[gdcsinaptik]

Hey @julianmukaj, this is not a bug. PandasAI simply does not support asynchronous calls. Moved it to conversation and ideas in the github discussion to see wether this idea may gain traction in the community