PandasAI

Overview

PandasAI adds a chat() method to DataFrames. It sends your question and the column layout (plus a few sample rows) to an LLM, which returns Python or SQL; PandasAI runs it and gives back a string, number, DataFrame or chart. The current release is 3.0.0 (October 2025). Version 3 changed the API: the old SmartDataframe(df, config={...}) and from pandasai.llm import OpenAI style still appears in tutorials, but SmartDataframe is deprecated and the pandasai.llm module only exposes the base LLM class. The model comes from the separate pandasai-litellm package. Checked against the package source and docs.pandas-ai.com/v3.

Instructions

Step 1: Install (Python 3.11 or older)

python3.11 -m venv .venv && source .venv/bin/activate
pip install pandasai pandasai-litellm

pandasai 3.0.0 declares python <3.12, so on 3.12 or 3.13 pip refuses to install it; use a 3.11 environment. There are no pandasai[openai] or [langchain] extras in v3.

Step 2: Configure an LLM once, globally