KabucyeKelly/agriculture-yield-analysis-final-project

Analyzing factors affecting maize & bean yields in Rwanda (2000–2027) — Python & Power BI capstone project.” # agriculture-yield-analysis-final-project Analyzing factors affecting maize & bean yields in Rwanda (2000–2027) — Python & Power BI capstone project.” # README – Agricultural Crop Yield Analysis in Rwanda (2000–2027) ### Student: **Kabucye Kelly** **Institution:** Adventist University of Central Africa (AUCA) **Faculty:** Information Technology **Course Code:** INSY 8413 **Course Name:** Introduction to Big Data Analytics **Lecturer:** Eric Maniraguha **Capstone Group:** E **Academic Year:** 2024–2025, Semester III ### Contact Information - **Student Email:** kel.kabucye@gmail.com - **Lecturer Email:** eric.maniraguha@auca.ac.rw --- ## Project Title **Analyzing Factors Affecting Crop Production in Rwanda (2000–2027)** --- ## Problem Statement & Motivation Agricultural production is critical to Rwanda’s economy and food security, yet crop yields are highly sensitive to environmental factors such as rainfall and input usage like fertilizer and land area. Policymakers and farmers often lack timely, data-driven tools to forecast trends and make informed decisions. This project aims to explore historical data on rainfall, fertilizer use, and land area to understand their effects on crop yield — focusing on Rwanda's key staple crops: **maize** and **beans**. The ultimate goal is to develop predictive models and visual dashboards that support smarter resource allocation and agricultural planning, especially under changing climate conditions. --- ## Project Scope ### Python Components: - Dataset merging and cleaning using **Pandas** - Exploratory Data Analysis (EDA) with **Seaborn** and **Matplotlib** - Linear regression modeling using **scikit-learn** - Prediction of crop yields from 2022–2027 - Output saved to CSV for Power BI ### Power BI Components: - 4-page interactive dashboard - Slicers for crop and year selection - Visuals for production trends, rainfall, fertilizer usage, and yield efficiency - Forecast summary with KPI cards and predi …