🌾 Agri Data Explorer

A Mini Project to analyze Indian agricultural datasets using Python, Pandas, SciPy, Plotly, Streamlit, and Power BI.
It provides statistical insights and interactive dashboards for understanding trends in crop production, yield, and cultivated area.

---

🚀 Key Features

• 🔍 Exploratory Data Analysis via Streamlit
• 📈 Interactive visualizations using Plotly
• 📊 Power BI Dashboard for state/district level insights
• 🧪 Statistical computations with SciPy
• 💾 CSV & PostgreSQL support via SQLAlchemy
• ☁️ Google Colab notebooks for EDA and preprocessing

---

🛠️ Tech Stack

---

📁 Project Structure

Project_2-Agri_Data_Explorer/
├── app/                # Streamlit app code
│   └── main.py
├── data/               # Raw and cleaned datasets
├── scripts/            # ETL scripts
├── dashboards/         # Power BI .pbix files
├── notebooks/          # Google Colab notebooks
├── images,videos/      # Visuals for dashboard & Project demonstration video
├── requirements.txt    # Python dependencies
├── README.md           # Project documentation
├── LICENSE             # Open-source license
└── .gitignore          # Files to be ignored by Git

---

📊 Streamlit Dashboard Preview

📌 Rice vs Wheat Production Over the Last 50 Years

---

📌 Impact of Area Cultivated on Rice, Wheat, and Maize Production

---

📊 Power BI Dashboard

📁 Located in the dashboards/ folder

📌 Power BI Dashboard Preview

---

🧪 Sample Insights

• 📈 Year‑wise trend of rice production across top 3 states
• 🌾 Districts with highest wheat yield in last 5 years
• 🛢️ Top oilseed producing states and their growth
• 🌽 Area vs. production correlation for major crops
• 🧵 Cotton production trends and groundnut yield by district

---

🔧 Installation & Running

1. Clone the repository

git clone https://github.com/Infant-Joshva/Project_2-Agri_Data_Explorer.git
cd Project_2-Agri_Data_Explorer

2. Create virtual environment

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

3. Install Python dependencies

pip install -r requirements.txt

📝 Requirements

The following Python libraries are required:

• pandas
• scipy
• plotly
• streamlit
• sqlalchemy
• psycopg2-binary

4. Run the Streamlit app

streamlit run app/main.py

---

📚 Data Sources

• India agricultural datasets
• Custom CSV/Excel files based on domain data

---

---

📜 License

This project is licensed under the MIT License.
See the LICENSE file for full text.

---

👤 Author

Project developed by Infant Joshva A

📧 [email protected]
🐙 GitHub
🔗 LinkedIn

⭐ Give a Star!

If you liked this project, please give it a ⭐ on GitHub!