Ososeomo/ECONOMY-ANALYSIS-OF-NIGERIA

A comprehensive study of key economic indicators in Nigeria, including inflation, unemployment, sectoral GDP contributions, and debt-to-GDP ratio. The project highlights trends, insights, and policy recommendations to support sustainable economic growth and job creation. # Economic Analysis of Nigeria Using SQL and Data Visualization ### Project Overview #### Objective The goal of this project was to analyze Nigeria's economic data over the past few decades, focusing on key indicators such as inflation, unemployment, sector contributions to GDP, and government debt. The analysis utilized SQL for data extraction and manipulation, alongside data visualization tools to provide insights into the country’s economic performance from 1990 to 2022. #### Key Analysis Areas - **Inflation and Unemployment Trends**: Examining the relationship between inflation and unemployment rates over time. - **Sectoral Contributions to GDP**: Investigating how the sectors of Agriculture, Industry, and Services have contributed to Nigeria's GDP. - **Debt-to-GDP Ratio**: Analyzing Nigeria’s growing government debt relative to GDP over time. ### Data Overview The data for this project came from two main sources: - **Nigeria Economy - Data Prepared by Alaoh Sodiq.xlsx** These datasets provided information about various economic indicators, including inflation, unemployment, GDP contributions by sector, nominal GDP, real GDP, and government debt from 1990 to 2022. #### Columns: - **Year**: The year the data was collected. - **Inflation rate**: Annual inflation rate. - **Unemployment rate**: The percentage of the labor force that is unemployed. - **Government debt**: The total government debt. - **Sector contributions**: Contribution of Agriculture, Industry, and Services to the GDP. - **Nominal GDP**: GDP at current market prices. - **Real GDP**: GDP adjusted for inflation. ### Data Cleaning and Preparation Before beginning the analysis, the following steps were performed: - **Standardized column names**: Ensured column names are consistent across both datasets. - **Handled missing data**: Filled or removed any missing or redundant data. ### Exploratory Data Analysis (EDA) #### Inflation & Unemployment Trends The trends of inflation and unemployment ra …