📊 AI Data Analyst Agent

An AI-powered Data Analyst built with Streamlit + Gemini API that allows users to upload CSV/Excel files and ask questions in natural language.

Instead of manually exploring datasets, users can upload data and get instant AI-generated insights, summaries, comparisons, and statistics.

---

🚀 Features

• Upload CSV / Excel datasets
• Ask questions in plain English
• AI-powered analysis using Gemini
• Automatic dataset preview
• Column & datatype detection
• Summary statistics generation
• Smart query suggestions
• Interactive sidebar UI
• Modern custom-themed dashboard
• Error handling and timeout protection

---

🛠 Tech Stack

• Python
• Streamlit
• Gemini API
• Pandas
• HTML/CSS

---

📂 Project Structure

AI-Data-Analyst/
│
├── ai_data_analyst.py
├── requirements.txt
├── README.md
├── sample_dataset.csv
└── assets/

---

⚙ Installation

Clone repository:

git clone https://github.com/DishantBhere/AI-Data-Analyst.git

Move into project:

cd AI-Data-Analyst

Install dependencies:

pip install -r requirements.txt

Run application:

streamlit run ai_data_analyst.py

---

🔑 API Setup

1. Visit: https://aistudio.google.com
2. Generate Gemini API Key
3. Paste key into sidebar
4. Upload dataset and start asking questions

---

📈 Example Questions

• Which category has the highest average price?
• Show out-of-stock products
• Top 5 brands by product count
• What is the average product price?
• Summarise this dataset

---

📷 Screenshots

---

🎯 Future Improvements

• Data visualization charts
• Downloadable reports
• Multi-file analysis
• Export results as PDF
• Advanced filtering

---