SharonNamuki/agricultural-data-dashboard

Python-based data pipeline and dashboard analyzing agricultural production data using FAOSTAT datasets, with visualizations of crop production trends in East Africa. # Agricultural Data Dashboard and Visualization System ## Project Overview This project demonstrates the development of a data pipeline, analytical dashboard, and visualization system for agricultural production data. The system extracts, cleans, and analyzes crop production data to generate insights on agricultural trends in Africa, with a focus on root and staple crops such as potatoes, sweet potatoes, cassava, and maize. The project uses publicly available agricultural datasets to demonstrate how data engineering workflows, visualization dashboards, and analytical tools can support agricultural research, food security analysis, and data-driven decision making. This type of analytical system can support organizations working in agricultural research and development by transforming raw agricultural datasets into actionable insights and interactive visualizations. ### Objectives The objectives of this project are to: Develop a data pipeline to ingest and process agricultural datasets Perform data cleaning and transformation to prepare datasets for analysis Analyze crop production trends across East African countries Build visualization dashboards that communicate agricultural insights Demonstrate the use of data engineering, data analysis, and visualization systems for agricultural data ### Dataset The dataset used in this project comes from the Food and Agriculture Organization FAOSTAT database. #### Dataset: Crops and Livestock Products The dataset contains agricultural production statistics including: Country / Region Crop Type Production Quantity Harvested Area Yield Year of Production For this analysis, the dataset was filtered to include: Selected East African countries Key staple crops including potatoes, sweet potatoes, cassava, and maize Production data from 2004 to 2024 These crops are important for food security and agricultural development across East Africa. ### Project Workflow The project follows a structured data engineerin …