An AI data analysis Agent built using the Agno Agent framework and Openai's gpt-4.1 mini 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.
-
📤 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
-
Setup Environment
# Clone the repository git clone cd 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
- 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