GREATER MANCHESTER ROAD ACCIDENTS ANALYSIS USING JUPYTER NOTEBOOK
Author: Babatunde Akeredolu
R oad accident is one of the most dangerous threats to the health and lives of people around the world today, thousands of deaths are as a result of road accidents every year. In a bid to proffer solutions to the occurrence of road accidents, I did an analysis of Greater Manchester county road accident dataset using Python, Greater Manchester is a metropolitan county and combined authority area in North West England, with a population of 2.8 million. I provided some recommendations that can help reduce road accidents in this county.
The first thing I did was to import the necessary libraries required for the analysis. They include Pandas(for data manipulation and analysis), Numpy(for working with arrays and performing mathematical functions), Matplotlib(for data visualization) etc.
Analysis Steps
After importing the necessary libraries, I followed the steps in the flow diagram below.
Gathering the data
The dataset used in this analysis was downloaded from data.world and can be assessed here.
Assessing the data
This section helps in understanding the data. The dataset was assessed for quality and tidiness issues both programmatically and visually. The number of rows and columns; column types and contents; duplicated rows and null values were all assessed. I had to do this to better understand the data I will be working with and also identify the cleaning processes to be carried out.
Cleaning the data
To perform the analysis, it is very important that the data to be analyzed is clean as unclean data can lead to inaccurate results. In this section, a lot of cleaning was performed on the dataset, some columns were dropped, renamed and values which were not appropriately represented were dealt with.
Analysis & Visualization
After cleaning the data, I analyzed and visualized the insights generated from the data. The insights include:
- Most accidents happen during rush hours between the hours of 16:00 to 18:00 in the evening and 08:00 to 09:00 in the morning.
2. Saturday recorded the most accidents out of the days of the week.
The full visualization is available on my Tableau Dashboard here.
Recommendations
- Facilities such as overhead bridge for pedestrians should be provided for safe crossing of pedestrians and other road users.
- Traffic wardens should be provided during rush hours of the day.
- Traffic control devices should be installed at appropriate places for road users to see and follow.
- There should be regular public enlightenment education of the general public especially the motorists on the proper use of the road and road signs.
- There should be strict penalties for road users that fail to follow the road signs and rules.
THANKS FOR GOING THROUGH MY ARTICLE!
You can also check my other pages here:
Github repository
