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()],
        markdown=True,
)
agent.print_response("Load and analyze the dataset from data.csv")

​
Usage

1

Create a virtual environment

Open the Terminal and create a python virtual environment.
python3 -m venv .venv
source .venv/bin/activate
2

Set your API key

export OPENAI_API_KEY=xxx
3

Install libraries

pip install -U pandas openai agno
4

Run Agent

python cookbook/tools/pandas_tools.py