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 mpg.csv. 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 well-formatted 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 main()...main() 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 a419991829
audi a419992129
audi a420082031
audi a420082130
audi a419991626
audi a419991826
audi a420081827
audi a4 quattro 19991826
audi a4 quattro 19991625
audi a4 quattro 20082028
audi a4 quattro 20081927
audi a4 quattro 19991525
audi a4 quattro 19991725
audi a4 quattro 20081725
audi a4 quattro 20081525
audi a6 quattro 19991524
audi a6 quattro 20081725
audi a6 quattro 20081623
chevrolet c1500 suburban 2wd 20081420
chevrolet c1500 suburban 2wd 20081115
chevrolet c1500 suburban 2wd 20081420
chevrolet c1500 suburban 2wd 19991317
chevrolet c1500 suburban 2wd 20081217
chevrolet corvette 19991626
chevrolet corvette 19991523
chevrolet corvette 20081626
chevrolet corvette 20081525
chevrolet corvette 20081524
chevrolet k1500 tahoe 4wd 20081419
chevrolet k1500 tahoe 4wd 20081114
chevrolet k1500 tahoe 4wd 19991115
chevrolet k1500 tahoe 4wd 19991417
chevrolet malibu 19991927
chevrolet malibu 20082230
chevrolet malibu 19991826
chevrolet malibu 20081829
chevrolet malibu 20081726
dodge caravan 2wd 19991824
dodge caravan 2wd 19991724
dodge caravan 2wd 19991622
dodge caravan 2wd 19991622
dodge caravan 2wd 20081724
dodge caravan 2wd 20081724
dodge caravan 2wd 20081117
dodge caravan 2wd 19991522
dodge caravan 2wd 19991521
dodge caravan 2wd 20081623
dodge caravan 2wd 20081623
dodge dakota pickup 4wd 20081519
dodge dakota pickup 4wd 20081418
dodge dakota pickup 4wd 19991317
dodge dakota pickup 4wd 19991417
dodge dakota pickup 4wd 20081419
dodge dakota pickup 4wd 20081419
dodge dakota pickup 4wd 19991117
dodge dakota pickup 4wd 19991115
dodge durango 4wd 19991317
dodge durango 4wd 20081317
dodge durango 4wd 20081317
dodge durango 4wd 19991116
dodge durango 4wd 20081318
dodge durango 4wd 19991115
dodge ram 1500 pickup 4wd 20081216
dodge ram 1500 pickup 4wd 20081317
dodge ram 1500 pickup 4wd 20081317
dodge ram 1500 pickup 4wd 20081216
dodge ram 1500 pickup 4wd 19991115
dodge ram 1500 pickup 4wd 19991116
dodge ram 1500 pickup 4wd 20081317
dodge ram 1500 pickup 4wd 19991115
ford expedition 2wd 19991117
ford expedition 2wd 19991117
ford expedition 2wd 20081218
ford explorer 4wd 19991417
ford explorer 4wd 19991519
ford explorer 4wd 19991417
ford explorer 4wd 20081319
ford explorer 4wd 20081319
ford explorer 4wd 19991317
ford f150 pickup 4wd 19991417
ford f150 pickup 4wd 19991417
ford f150 pickup 4wd 19991316
ford f150 pickup 4wd 19991316
ford f150 pickup 4wd 20081317
ford f150 pickup 4wd 19991115
ford f150 pickup 4wd 20081317
ford mustang 19991826
ford mustang 19991825
ford mustang 20081726
ford mustang 20081624
ford mustang 19991521
ford mustang 19991522
ford mustang 20081523
ford mustang 20081522
ford mustang 20081420
honda civic 19992833
honda civic 19992432
honda civic 19992532
honda civic 19992329
honda civic 19992432
honda civic 20082634
honda civic 20082536
honda civic 20082436
honda civic 20082129
hyundai sonata 19991826
hyundai sonata 19991827
hyundai sonata 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!