📊 AI Data Analysis Agent

🎓 FREE Step-by-Step Tutorial

👉 Click here to follow our complete step-by-step tutorial and learn how to build this from scratch with detailed code walkthroughs, explanations, and best practices.

An AI data analysis Agent built using the Agno Agent framework and Openai's gpt-4o model. This agent helps users analyze their data - csv, excel files through natural language queries, powered by OpenAI's language models and DuckDB for efficient data processing - making data analysis accessible to users regardless of their SQL expertise.

Features

📤 File Upload Support:
- Upload CSV and Excel files
- Automatic data type detection and schema inference
- Support for multiple file formats
💬 Natural Language Queries:
- Convert natural language questions into SQL queries
- Get instant answers about your data
- No SQL knowledge required
🔍 Advanced Analysis:
- Perform complex data aggregations
- Filter and sort data
- Generate statistical summaries
- Create data visualizations
🎯 Interactive UI:
- User-friendly Streamlit interface
- Real-time query processing
- Clear result presentation

How to Run

Setup Environment

# Clone the repository
git clone https://github.com/Shubhamsaboo/awesome-llm-apps.git
cd awesome-llm-apps/starter_ai_agents/ai_data_analysis_agent

# Install dependencies
pip install -r requirements.txt

Configure API Keys
- Get OpenAI API key from OpenAI Platform
Run the Application
```
streamlit run ai_data_analyst.py
```

Usage

Launch the application using the command above
Provide your OpenAI API key in the sidebar of Streamlit
Upload your CSV or Excel file through the Streamlit interface
Ask questions about your data in natural language
View the results and generated visualizations