Datagirlie1/food-prices-in-Nigeria

### Food prices in Nigeria Analysis- ## Table of Contents - Introduction - Data-Sources - Tools - Data-cleaning-And-preparation - Objectives - Recommendation - Reference ### Introduction Food prices in Nigeria have become a pressing concern, exhibiting significant variability across different commodities and states. The country's diverse geographical regions, cultural preferences, and economic factors contribute to the difference in food costs. This report provides an overview of the prevailing food price trends in Nigeria, highlighting the differences across major commodities and states, including Lagos, Kano, Abia, and others, to better understand the complexities of the country's food market. ### Data Sources Food prices Data: The primary dataset used for this Analysis is the "food_prices.csv" file, containing detailed information about food prices in Nigeria. ### Tools - Excel - Data cleaning - Powerbi - creating Reports And Dashboard ### Data cleaning And preparation Data cleaning Process: 1.Review data from errors, inconsistency and missing values. 2.Create standardized date format,remove duplicate. 3.Transform data by sorting and filtering the data with different states. 4.Designed a dashboard layout. ### Objectives 1. Average price over the years. 2. prices across state. 3. Price type by price. 4. Average price of commodity. ### Recommendation Base on the Analysis we recommend the following action: - Implement price stabilization policies to cushion seasonal fluctuations. - Invest in transportation infrastructure to reduce costs. - Promote regional agricultural development to increase local production. - Develop market information systems for real-time price data. - Enhance food storage and preservation infrastructure. ### Reference Amerigeo.org