Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

3 Commits
ย 
ย 
ย 
ย 

Repository files navigation

๐Ÿ“Š Analytics AI โ€“ AI-Powered Data Analysis Tool

Analytics AI is a user-friendly, Streamlit-based web application that uses Groq AI (LLaMA 3 model) to help you analyze your CSV and Excel datasets using natural language questions.

๐Ÿ” Upload your data โ†’ Ask a question โ†’ Get insights powered by AI!


๐Ÿš€ Features

  • ๐Ÿ“ Upload CSV, XLSX, or XLS files
  • ๐Ÿง  Ask data-related questions in natural language
  • ๐Ÿ“ˆ Get AI-generated insights with statistics and summaries
  • ๐Ÿงฎ View descriptive statistics, column types, and missing values
  • ๐Ÿค– Powered by Groq LLaMA3-70b for high-speed AI processing

๐Ÿ› ๏ธ Installation

  1. Clone the repository
git clone https://github.com/<your-username>/analytics_ai.git
cd analytics_ai
  1. Install dependencies
pip install -r requirements.txt
  1. Set up environment variables

Create a .env file in the project root and add your Groq API key:

GROQ_API_KEY=your_groq_api_key_here
  1. Run the Streamlit app
streamlit run app.py

๐Ÿ“‚ File Structure

analytics_ai/
โ”œโ”€โ”€ app.py               # Main Streamlit application
โ”œโ”€โ”€ .env                 # API Key (not committed)
โ”œโ”€โ”€ requirements.txt     # Python dependencies
โ””โ”€โ”€ README.md            # Project documentation

๐Ÿง  How to Use

  1. Launch the app: streamlit run app.py

  2. Upload your dataset (CSV or Excel)

  3. Explore:

    • View data preview
    • Check dataset shape and data types
    • See statistical summaries
    • Check missing values
  4. Ask questions like:

    • "What are the key trends?"
    • "What's the average salary by department?"
    • "Which columns are most correlated?"

๐Ÿ“Œ Example Questions

  • What are the top 5 most frequent values in column X?
  • What is the average, min, and max of column Y?
  • Show trends based on year or category.
  • Which columns have missing values?

๐Ÿ“ฆ Dependencies

  • streamlit
  • pandas
  • chardet
  • groq
  • python-dotenv

Install with:

pip install -r requirements.txt

โš ๏ธ Notes

  • CSV files should preferably be UTF-8 encoded.
  • Avoid uploading very large datasets (recommended < 10MB).
  • Requires a valid Groq API key to access the LLaMA 3 model.

๐Ÿ™Œ Acknowledgments

  • Groq โ€“ for providing blazing-fast inference with LLaMA 3.
  • Streamlit โ€“ for easy web app deployment.
  • Open-source community for continuous inspiration.

๐Ÿ‘จโ€๐Ÿ’ป Author

Prince Thummar Connect with me on GitHub

About

Chat with your data! ๐Ÿ’ฌ An AI-powered tool to analyze CSV & Excel files using natural language. Built with Streamlit and Groq.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages