kenobech/Food_Prices_Analysis

This is a data analysis of food prices in Kenya # Food Prices Analysis in Kenya ## Overview This project analyzes food price trends in Kenya using a dataset provided by the World Food Programme (WFP). The analysis aims to uncover insights into price fluctuations in different locations across Kenya and their potential causes. This project demonstrates expertise in SQL for data analysis and Git for version control. --- ## Objectives The primary objectives of this project are: 1. To analyze historical food price trends in Kenya. 2. To identify regional price disparities and their potential causes. 3. To highlight commodities with the highest price volatility. 4. To provide actionable insights for policymakers, farmers, businesses, and researchers. ## Table of Contents 1. Dataset 2. SQL Analysis 3. How to Run 4. Results 5. Tools Used 6. Folder Structure 7. Documentation 8. Contributing 9. License 10. Author --- ## Dataset - **File**: `wfp_food_prices_ken.csv` - **Source**: World Food Programme (WFP) - **Description**: Contains historical food price data for various commodities in Kenya, including prices, regions, and dates. --- ## SQL Analysis The SQL script `SQL_Analysis_Food_Prices_Kenya_v2.sql` performs the following: 1. Cleans and preprocesses the data to handle missing or inconsistent values. 2. Analyzes price trends over time to identify patterns and anomalies. 3. Identifies regional price variations to highlight disparities across locations. 4. Highlights commodities with the highest price volatility to understand market dynamics. 5. Provides additional insights into seasonal trends and correlations. The SQL script is optimized for performance and includes detailed comments for clarity. ## Prerequisites Before running this project, ensure you have the following: 1. A SQL database management system (e.g., MySQL, PostgreSQL, or SQL Server). This script is for Ms SQL Server. 2. A text editor or IDE for SQL scripts (e.g., VS Code, DBeaver). In this case, the text editor I used is VS Code. 3. Git installe …