Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a Python program that conforms to the specifications below: 1 . Read the aviation.csv file ( I have the . csv file, just need

Write a Python program that conforms to the specifications below:
1. Read the aviation.csv file (I have the .csv file, just need the code to extract it and make it into the format examples below.)
2. Create dictionaries to keep track of (count) the fatalities, injuries, accidents, and fatal accidents. Key
the dictionary by aircraft make and model.
3. Prompt the user to enter an aircraft make and output the items listed below for the selected make.
o The number of fatalities for each model within the make
o The number of injuries for each model within the make
o The number of accidents for each model within the make
o The number of fatal accidents for each model within the make
o The total number of fatalities for the make
o The total number of injuries for the make
o The total number of accidents for the make
o The total number of fatal accidents for the make
o The fatality ratio and associate percentage for the make
o The fatal accident ratio and associated percentage for the make* Format the output of your program as shown in the examples on the following pages. Example:
Enter a make of aircraft: AVIAT
AVIAT
Fatalities: ,19
Serious Injuties: 4
Total Accidents : 136
Fatal Accidents : 14
AVIAT averages 1 fatality every 7.16 accidents. (13.97%)
AVIAT averages 1 fatal accident out of every 9.71 accidents. (10.29%)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

41 External labor markets and/or economic factors.

Answered: 1 week ago