Create a Python Notebook with your response to the following questions. Ensure that your work is presented neatly, include your name in the notebook and indicate which question you are...

Create a Python Notebook with your response to the following questions. Ensure that your work is presented neatly, include your name in the notebook and indicate which question you are answering.


Note:


Ensure that you explain the results from each question.

Question 1: NTSB Data Science Accident & Incident Investigation (50 pts)

TheNational Transportation Safety BoardLinks to an external site.





(NTSB) publishes a dataset on selectaviation accidents and incidentsLinks to an external site.





within the United States, its territories, and in international waters. The NTSB database is updated daily and the status of each event, i.e. the accident or incident, undergoes different stages from filing a preliminary report, to obtaining factual information, leading up to the end of the investigation and the probable cause. The dataset can be obtained from the NTSB website along with thedata dictionaryLinks to an external site.





.

You are given the task of performing a preliminary investigation of the domestic (United States) and international flights using the dataset. Note: you are working with a real dataset, that was generated by the NTSB. Be mindful of the nature of the dataset, when determining data preparation steps. I also encourage you to open the file, using a text editor, and manually inspect it. This will help you to import it correctly into the dataframe.

Dataset:





source files








Download source files








|








https://www.ntsb.gov/_layouts/ntsb.aviation/AviationDownloadDataDictionary.aspx











Links to an external site.





Use this link for data set

Load the data into a DataFrame and answer the following questions:

1. (5 pts) import the data into a dataframe, and extract the following columns: Broad Phase of Flight, Total Uninjured, Total Minor Injuries, Total Serious Injuries, Total Fatal Injuries, Air Carrier, Make, Model, Aircraft Category, Aircraft Damage, Injury Severity, Country, Event Date, Investigation Type, Event Id.
   
   
   
   
   • Remove leading and trailing white-spaces from the selected columns, convert their data to suitable data types and perform at least one additional data preparation step.
     
     
     
     
   
   
   
   
   
   
   
   




2. (10 pts) Calculate the number of events that transpired each year and display the results using a line chart. Which year has the highest number of events?
   
   
   
   




3. (10 pts) Create a suitable visualization that shows the
   
   
   
   
   
   proportion
   
   
   
   
   
   of Accidents and Incidents in the dataset. Hint: use the Investigation Type. Explain the results.
   
   
   
   




4. (10) Create a suitable visualization that calculates the number of events grouped by the aircraft make (e.g. Cessna, Boeing, Piper, etc).** Visualize which aircraft has the most events; only show the top ten results. Comment on the results.
   
   
   
   




5. (15 pts) Let's dig deeper: Filter the data and extract all events for the Boeing 737 aircraft (i.e. the make is Boeing and the model is 737)**. Create suitable visualizations to answer the following using the extracted data:
   
   
   
   
   • What year had the most
     
     
     accidents
     
     
     ,
   
   
   
   
   • What Phase of Flight did most
     
     
     accidents
     
     
     transpire,and
   
   
   
   
   • Using theInjury Severityvariable, determine if most events were fatal or non-fatal? Note: you may need to do additional preparation for theInjury Severityvariable.
   
   
   
   
   
   
   
   




6. (5 pts)[optional/bonus] Create any (1) visualization of your choice to demonstrate something interesting about the data. Ensure that you explain what you will demonstrate and the results.
   
   
   
   

**Tip: You will need to perform a case insensitive search (or convert the text/string data to lowercase).

Note: Ensure that all visualizations have a title and label both the x and y axes.