1Elaigwu/Food-Price-Dynamics

Conducting an in-depth analysis of food prices in Nigeria. Leveraging advanced SQL techniques, the project explores historical trends, regional disparities, and key factors impacting prices. # Food Price Dynamics ## Table Of Content - Overview - Installation - EDA - Findings - Methods - Limitations - Recomendations - License ### Overview This project involve the use of two dataset to gain insights into historical trends, regional variations, and factors influencing food prices in Nigeria. The project stores and manages two primary datasets: food prices in Nigeria (wfp_food_prices_nga) and economic indicators (Economic_indicators), facilitating easy access and manipulation of relevant information. The project will focus on using SQL queries to extract meaningful information and present it descriptively and where appropriate visually for stakeholders. ### Installation To set up the project locally, follow these steps: 1. Clone the repository: 'github.com' 2. Navigate to project directory: 'cd Food-Price-Dynamics' or 3. Ensure MySQL Workbench is Installed 4. Download CSV Files: Ensure that your CSV files are correctly formatted and contain the data you expect for your analysis. 5. Execute SQL Queries with MySQL Workbench: Open MySQL Workbench and connect to your MySQL database. Then, execute the SQL queries provided in your SQL query file. ### EDA The project enables users to perform exploratory data analysis, allowing them to understand the distribution and characteristics of the data. Users can explore temporal trends, regional variations, inflation impact, seasonal patterns, price volatility, and market-specific insights within the dataset. ### Findings Based on the queries and interpretations provided regarding regional, temporal, seasonal trends, market-specific insights and inflation impact on food prices in Nigeria, the overall findings can be summarized as follows: #### Regional Disparities There are significant variations in food prices across different regions of Nigeria. Factors such as market dynamics, infrastructure, local production capacity, and economic conditions contribute to these dis …