AgenticDataAnalyst

# 🤖 AgenticDataAnalyst

> An AI-powered data analysis platform that converts natural language queries into executable Python code and runs it securely.

[![Python](https://img.shields.io/badge/Python-3.10+-blue.svg)](https://www.python.org/)
[![Streamlit](https://img.shields.io/badge/Streamlit-1.28+-red.svg)](https://streamlit.io/)
[![License](https://img.shields.io/badge/License-MIT-green.svg)](LICENSE)
[![Status](https://img.shields.io/badge/Status-Production%20Ready-success.svg)](https://github.com)

**Fully functional and Streamlit Cloud compatible!** The system uses LangGraph for workflow orchestration, Google Gemini for code generation, and codibox for secure code execution with dual backend support (Host/Docker).

## ✨ Features

- 🧠 **Natural Language to Code**: Converts user queries into executable Python code using AI
- 🔍 **Intelligent File Selection**: Automatically selects relevant datasets using semantic search
- ⚡ **Dual Backend Execution**: 
  - **Host backend** (default): Fast execution, works on Streamlit Cloud
  - **Docker backend** (optional): Secure, isolated execution for local development
- 📊 **Visualization Generation**: Automatically creates charts and visualizations
- 🔄 **Error Recovery**: Automatic code refinement with up to 3 retry attempts
- 🤖 **AI-Powered Metadata**: Generates dataset descriptions and summaries automatically
- 🌐 **Multiple Interfaces**: CLI, Streamlit web app, and programmatic API

## 📸 Demo

### Main Interface
![AgenticDataAnalyst Analysis Results](assets/msedge_I4NO2Ub53P.png)

### Analysis Results
![AgenticDataAnalyst Main Interface](assets/msedge_PeuJyv18yG.png)

*Interactive web interface for natural language data analysis with AI-powered insights*

## Project Structure

```
AgenticDataAnalyst/
├── agent_coder/              # AI workflow system
│   ├── agents.py             # FileAccessAgent, CodeGenerationAgent, CodeExecutor
│   ├── workflow.py           # LangGraph workflow definitions
│   ├── simple_workfl