Pandas

Description: Implemented an AI agent using the agno library with PandasTools for automated data analysis. The agent loads a CSV file (data.csv) and performs analysis based on natural language instructions. Enables interaction with data without manual Pandas coding, simplifying data exploration and insights extraction. Includes setup instructions for environment variables and dependencies.

title: Pandas Tools

Code

cookbook/tools/pandas_tools.py

from agno.agent import Agent
from agno.tools.pandas import PandasTools

agent = Agent(
    tools=[PandasTools()],
    show_tool_calls=True,
    markdown=True,
)
agent.print_response("Load and analyze the dataset from data.csv")

Usage

Create a virtual environment

Open the Terminal and create a python virtual environment.

python3 -m venv .venv
source .venv/bin/activate

python3 -m venv .venv
.venv/scripts/activate

Set your API key

export OPENAI_API_KEY=xxx

Install libraries

pip install -U pandas openai agno

Run Agent

python cookbook/tools/pandas_tools.py

python cookbook/tools/pandas_tools.py

Mem0 Memory Tools Postgres Tools

Examples

Agent Concepts

Models

title: Pandas Tools

Code

Usage

​title: Pandas Tools

​Code

​Usage

title: Pandas Tools

Code

Usage