Question: In this final program, you will use an input file ( in the Files tab in the zyBook IDE for this program ) . The
In this final program, you will use an input file in the Files tab in the zyBook IDE for this program The file contains a header row. The file is a csv file you used a csv file in the Toolbox: Working with CSV Files The file is called mpgcsv It contains mileage data on many automobiles. The data rows contain the manufacturer name, the model name, the year, the city mpg miles per gallon and the highway mpg Your program should read the records in the file and display on the screen a wellformatted report that contains the above fields manufacturer model, year, city mpg and highway mpg as well as the combined mpg the average of the cars city and highway mpg Additionally, at the bottom, the report should include a summary with the manufacturer name, model name, year, and combined mpg of the car with the highest combined mpg
You must use well defined variable and constant names following our course guidelines. Likewise, your program must be well documented. You must use the def mainmain structure. And, you must use a user defined function to perform the following:
Compute the combined mileage for each car
You can use more user defined functions if you like but you must use a user defined function for the above task. Write your program in the zyBook IDE, submit it there, AND copy and paste it in the textbox below.
manufacturer model year cty hwy
audi a
audi a
audi a
audi a
audi a
audi a
audi a
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
audi a quattro
chevrolet c suburban wd
chevrolet c suburban wd
chevrolet c suburban wd
chevrolet c suburban wd
chevrolet c suburban wd
chevrolet corvette
chevrolet corvette
chevrolet corvette
chevrolet corvette
chevrolet corvette
chevrolet k tahoe wd
chevrolet k tahoe wd
chevrolet k tahoe wd
chevrolet k tahoe wd
chevrolet malibu
chevrolet malibu
chevrolet malibu
chevrolet malibu
chevrolet malibu
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge caravan wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge dakota pickup wd
dodge durango wd
dodge durango wd
dodge durango wd
dodge durango wd
dodge durango wd
dodge durango wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
dodge ram pickup wd
ford expedition wd
ford expedition wd
ford expedition wd
ford explorer wd
ford explorer wd
ford explorer wd
ford explorer wd
ford explorer wd
ford explorer wd
ford f pickup wd
ford f pickup wd
ford f pickup wd
ford f pickup wd
ford f pickup wd
ford f pickup wd
ford f pickup wd
ford mustang
ford mustang
ford mustang
ford mustang
ford mustang
ford mustang
ford mustang
ford mustang
ford mustang
honda civic
honda civic
honda civic
honda civic
honda civic
honda civic
honda civic
honda civic
honda civic
hyundai sonata
hyundai sonata
hyundai sonata
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
