Creator4me/Exploratory-Data-Analysis-on-the-2019-Presidential-Election-in-Nigeria-Using-SQL
Domain:
socioeconomicCreator:
Cre
Host:
The provided queries analyze the 2015 Presidential Election in Nigeria. Various aspects of the election data have been explored to understand voter turnout, party performances, regional patterns, and more.
# Exploratory-Data-Analysis-on-the-2019-Presidential-Election-in-Nigeria-Using-SQL
## Table Of Content
-Project Overview
-Data Sources
-Tool Used
-Data Cleaning And Preparation
-Exploratory Data Analysis
-Data Analysis
-Result and Findings
-Recommendation
-Limitation
-References
### Project Overview
The provided queries analyze the 2019 Presidential Election in Nigeria. Various aspects of the election data have been explored to understand voter turnout, party performances, regional patterns, and more.
### Data Source
The primary dataset utilized for this investigative analysis is the "2019election.csv" file, which details the electoral performance of the dominant political parties in the 2019 presidential election.
### Tool Used
-Excel - Data Cleaning
- Download Here
-SQL - Data Analysis
-PowerBi - Creating Report
- Download Here
### Data Cleaning And Preparation
To guarantee the dataset's cleanliness, the subsequent tasks were executed.
1.Data Loading and Inspection
2.Data Cleaning and Formatting
### Exploratory Data Analysis(EDA)
This involves exploring the election data to answer key questions such as:
- Count of States?
- Count of Geopolitical Zones?
- Spread of Potential Voters?
- Spread of Accredited Voters?
- Spread of Cast Votes?
- Spread of Valid Cast Votes?
- Spread of Rejected Votes?
- Voting Trends by Region?
- Voter Participation Rate?
- Which state holds the highest Percentage of PDP Votes?
- Which state holds the highest Percentage of APC Votes?
- Difference in Votes Margin between the Parties?
- What Percentage of Rejected Votes is seen Across States?
- Trend in Geopolitical Zones?
### Data Analysis
Code utilized/Features addressed
```SQL
--To get the entire Table--
SELECT *
FROM Election_2019;
--Exploratory Data Analysis On the 2015 Presidential Election In Nigeria--
--Number Of States--
SELECT COUNT(state)
FROM Election_2019;
--Number Of Geopolitical Zones
SELECT COUNT(distinct geopolitical_zone)
FROM Election_2019;
- …