Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

using python only , the fourth picture is a sample of the data file Problem A text file (Car_sale2.txt) with information about some cars is

using python only , the fourth picture is a sample of the data fileimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Problem A text file (Car_sale2.txt) with information about some cars is provided to you. This is a screenshot of the first lines with the header (1st line). Actually, the figure shown below is the screenshot of the same file in csv format. 23.555 Manufacturer Acura Acura Acura Audi Audi Audi BMW BMW Buick Buick Buick Buick Cadillac Cadillac Model Integra TL RL A4 A6 328 5281 Century Regal Park Avenue LeSabre Deville Seville Sales_in_thousands _year_resale_value Vehicle_type Price_in_thousands Engine_size Horsepower Wheelbase Width Length Curb_weight Fuel_capacity Fuel_efficiency Latest_Launch Power_perf_factor 16.919 16.36 Passenger 21.5 1.8 140 1012 67.3 172.4 2.639 13.2 28 2/2/12 58.28014952 39.384 19.875 Passenger 28.4 3.2 225 1081 70.3 192.9 3.517 17.2 25 6/3/11 91.37077766 8.588 29.725 Passenger 42 3.5 210 114.6 71.4 196.6 3.85 18 22 3/10/11 91.38977933 20.397 22.255 Passenger 23.99 18 150 1026 68.2 178 2.998 16.4 27 10/8/11 62.7776392 18.78 Passenger 33.95 28 200 108.7 76.1 192 3.561 18.5 22 8/9/11 1.38 39 84.56510502 Passenger 62 4.2 310 113 74 198.2 3.902 23.7 21 2/27/12 134.6568582 9.231 28.675 Passenger 33.4 28 193 1073 68.5 176 3.197 16.6 24 1/29/12 81.87706856 17-527 36.125 Passenger 38.9 2.8 193 70.9 188 3.472 18.5 25 4/4/11 83.9987238 91.561 12.475 Passenger 21.975 3.1 175 109 72.7 194.6 3.368 17.5 25 11/2/11 71.18145132 39.35 13.74 Passenger 25.3 3.8 240 109 72.7 196.2 3.543 17,5 22 9/3/11 95.63670253 27.851 20.19 Passenger 31.965 3.8 205 113.8 747 206.8 3.778 18.5 24 3/23/12 85.82840825 83.257 13.36 Passenger 27.885 3.8 205 1122 735 200 3.591 17.5 25 7/23/11 84 25452581 63.729 22.525 Passenger 39.895 4.6 275 115.3 74.5 207.2 3.978 18.5 22 2/23/12 113.8545976 15.943 27.1 Passenger 44.475 4.6 275 1122 75 201 18.5 22 4/29/11 115.6213578 Objectives: 1. Display the names of the available car manufacturers. 2. Calculate the total profits of each car manufacturer. 3. Calculate the total profits for all car manufacturers. 4. Calculate the average fuel efficiency of all car manufacturers. 5. Display the car that are above and below average fuel efficiency as follows: Car by fuel effeciency ===== > average | average |

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

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

What are the requirements for effective inventory management?

Answered: 1 week ago

Question

Were the right people involved in the decision-making process?

Answered: 1 week ago