💬 Chat2Data – Ask Questions (Powered by Gemini + Streamlit)

I built a lightweight AI assistant using Gemini Pro and Streamlit that allows you to explore a global economic dataset using plain English—no SQL required!

🔧 What It Does

• Converts natural language questions into SQL queries using Gemini
• Runs the query on a local SQLite database
• Returns real-time results as a DataFrame
• Maintains a sidebar question history log for traceability

📊 Dataset

• Global Economic Indicators (2010–2025)
• Sourced from: Kaggle

💡 Example Questions

• Top 5 countries with highest GDP in 2020
• Show inflation rate of India from 2015 to 2022
• Compare public debt between United States and China

🧠 Tech Stack

• 🐍 Python (3.10+)
• 🎈 Streamlit for the web interface
• 🗃️ SQLite for database
• 🤖 Google Generative AI (Gemini 1.5) for NL-to-SQL
• 📦 Pandas for data processing

📎 Try It Out

• 👉 Webapp: Chat2Data
• 👉 GitHub Repo: GitHub
• 🔑 Requires a free Gemini API key
• 🧪 Contributions & feedback welcome!