Nnamdi Azikiwe International Airport Aircraft Incident Analysis
Table of Contents • Introduction • Data Cleaning • Data Visualization • Wrap Up • Data Analytics Portfolio • Resources
INTRODUCTION: Our six-week-long portfolio Bootcamp, which began a month ago, has been both great and difficult simultaneously. We were given the assignment of assessing an airport incident data set for week four. The journey was interesting and exciting. Let's get started!
Data Cleaning: Data from the Nnamdi Azikiwe Airport from 2000 to 2021 was analyzed. This data collection was mixed up with other data sets from various airports, and even more so, there were several tables that were unnecessary and unrelated to the results we were hoping to achieve. We extracted the data related to the Nnamdi Azikiwe Airport, eliminated empty rows, and verified that each column was formatted correctly to produce our required Dataset. We published our data, which included the incident's type, its cause, category, type of aircraft, operator, model, and date.
Data Visualization: Our graphic served to address our concerns and demonstrate the patterns of airport mishaps from 2000 to 2021. Our inquiries were as follows: 1. What caused the aircraft incidents?
- The number of fatalities
- The stage of the incidents
- The fatality rate for both crew and passengers
- The degree of the aircraft's damage
- The number of fatalities among passengers
Wrap up : Our analysis indicates that although there are not as many airplane incidents, the fatalities caused by each incident are high. The ratio of fatalities among passengers as opposed to members of the crew shows that passengers are more adversely affected. Data Analytics Portfolio Team 11 Our team is made up of 10 Data analysts, they are