Question: Please help me to find the result with python code. Here is the CSV content : index,company,body-style,wheel-base,length,engine-type,num-of-cylinders,horsepower,average-mileage,price 0,alfa-romero,convertible,88.6,168.8,dohc,four,111,21,13495 1,alfa-romero,convertible,88.6,168.8,dohc,four,111,21,16500 2,alfa-romero,hatchback,94.5,171.2,ohcv,six,154,19,16500 3,audi,sedan,99.8,176.6,ohc,four,102,24,13950 4,audi,sedan,99.4,176.6,ohc,five,115,18,17450 5,audi,sedan,99.8,177.3,ohc,five,110,19,15250 6,audi,wagon,105.8,192.7,ohc,five,110,19,18920 9,bmw,sedan,101.2,176.8,ohc,four,101,23,16430

Please help me to find the result with python code.
Here is the CSV content :
| index,company,body-style,wheel-base,length,engine-type,num-of-cylinders,horsepower,average-mileage,price |
| 0,alfa-romero,convertible,88.6,168.8,dohc,four,111,21,13495 |
| 1,alfa-romero,convertible,88.6,168.8,dohc,four,111,21,16500 |
| 2,alfa-romero,hatchback,94.5,171.2,ohcv,six,154,19,16500 |
| 3,audi,sedan,99.8,176.6,ohc,four,102,24,13950 |
| 4,audi,sedan,99.4,176.6,ohc,five,115,18,17450 |
| 5,audi,sedan,99.8,177.3,ohc,five,110,19,15250 |
| 6,audi,wagon,105.8,192.7,ohc,five,110,19,18920 |
| 9,bmw,sedan,101.2,176.8,ohc,four,101,23,16430 |
| 10,bmw,sedan,101.2,176.8,ohc,four,101,23,16925 |
| 11,bmw,sedan,101.2,176.8,ohc,six,121,21,20970 |
| 13,bmw,sedan,103.5,189,ohc,six,182,16,30760 |
| 14,bmw,sedan,103.5,193.8,ohc,six,182,16,41315 |
| 15,bmw,sedan,110,197,ohc,six,182,15,36880 |
| 16,chevrolet,hatchback,88.4,141.1,l,three,48,47,5151 |
| 17,chevrolet,hatchback,94.5,155.9,ohc,four,70,38,6295 |
| 18,chevrolet,sedan,94.5,158.8,ohc,four,70,38,6575 |
| 19,dodge,hatchback,93.7,157.3,ohc,four,68,31,6377 |
| 20,dodge,hatchback,93.7,157.3,ohc,four,68,31,6229 |
| 27,honda,wagon,96.5,157.1,ohc,four,76,30,7295 |
| 28,honda,sedan,96.5,175.4,ohc,four,101,24,12945 |
| 29,honda,sedan,96.5,169.1,ohc,four,100,25,10345 |
| 30,isuzu,sedan,94.3,170.7,ohc,four,78,24,6785 |
| 31,isuzu,sedan,94.5,155.9,ohc,four,70,38, |
| 32,isuzu,sedan,94.5,155.9,ohc,four,70,38, |
| 33,jaguar,sedan,113,199.6,dohc,six,176,15,32250 |
| 34,jaguar,sedan,113,199.6,dohc,six,176,15,35550 |
| 35,jaguar,sedan,102,191.7,ohcv,twelve,262,13,36000 |
| 36,mazda,hatchback,93.1,159.1,ohc,four,68,30,5195 |
| 37,mazda,hatchback,93.1,159.1,ohc,four,68,31,6095 |
| 38,mazda,hatchback,93.1,159.1,ohc,four,68,31,6795 |
| 39,mazda,hatchback,95.3,169,rotor,two,101,17,11845 |
| 43,mazda,sedan,104.9,175,ohc,four,72,31,18344 |
| 44,mercedes-benz,sedan,110,190.9,ohc,five,123,22,25552 |
| 45,mercedes-benz,wagon,110,190.9,ohc,five,123,22,28248 |
| 46,mercedes-benz,sedan,120.9,208.1,ohcv,eight,184,14,40960 |
| 47,mercedes-benz,hardtop,112,199.2,ohcv,eight,184,14,45400 |
| 49,mitsubishi,hatchback,93.7,157.3,ohc,four,68,37,5389 |
| 50,mitsubishi,hatchback,93.7,157.3,ohc,four,68,31,6189 |
| 51,mitsubishi,sedan,96.3,172.4,ohc,four,88,25,6989 |
| 52,mitsubishi,sedan,96.3,172.4,ohc,four,88,25,8189 |
| 53,nissan,sedan,94.5,165.3,ohc,four,55,45,7099 |
| 54,nissan,sedan,94.5,165.3,ohc,four,69,31,6649 |
| 55,nissan,sedan,94.5,165.3,ohc,four,69,31,6849 |
| 56,nissan,wagon,94.5,170.2,ohc,four,69,31,7349 |
| 57,nissan,sedan,100.4,184.6,ohcv,six,152,19,13499 |
| 61,porsche,hardtop,89.5,168.9,ohcf,six,207,17,34028 |
| 62,porsche,convertible,89.5,168.9,ohcf,six,207,17,37028 |
| 63,porsche,hatchback,98.4,175.7,dohcv,eight,288,17, |
| 66,toyota,hatchback,95.7,158.7,ohc,four,62,35,5348 |
| 67,toyota,hatchback,95.7,158.7,ohc,four,62,31,6338 |
| 68,toyota,hatchback,95.7,158.7,ohc,four,62,31,6488 |
| 69,toyota,wagon,95.7,169.7,ohc,four,62,31,6918 |
| 70,toyota,wagon,95.7,169.7,ohc,four,62,27,7898 |
| 71,toyota,wagon,95.7,169.7,ohc,four,62,27,8778 |
| 79,toyota,wagon,104.5,187.8,dohc,six,156,19,15750 |
| 80,volkswagen,sedan,97.3,171.7,ohc,four,52,37,7775 |
| 81,volkswagen,sedan,97.3,171.7,ohc,four,85,27,7975 |
| 82,volkswagen,sedan,97.3,171.7,ohc,four,52,37,7995 |
| 86,volkswagen,sedan,97.3,171.7,ohc,four,100,26,9995 |
| 87,volvo,sedan,104.3,188.8,ohc,four,114,23,12940 |
| 88,volvo,wagon,104.3,188.8,ohc,four,114,23,13415 |
Assignment 2 of Python Programming II Requirements Deadline: submit to K2 system before 18th Feb, 2021. File format: Please submit"ipynb" file, not ".docx" file or ".py" file. File name: Please use your name as the file name. Question 1: read a data set from the given "Automobile data.csv" file and print out the first and last five rows separately. tips: pandas.read csv() function will be helpful. Question 2: Find the most expensive car's company name. Question 3: Sort all cars by the Price column. Question 4: Print All Toyota Cars details. Question 5: Count total cars per company. Question 6: Find the average mileage of each car making, tips: For Q5 and Q6, try to use groupby method of DataFrame for help. Question 7: Construct a 4x4 DataFrame using NumPy arrays as shown in the following figure and delete the fourth column. One Two Three Four a 0 1 2 3 b 4 5 6 7 8 9 10 11 d 12 13 14 15 Question 8: Select the data from the first row, second and third columns using either axis labels (loc) or integers (iloc). Question 9: Sort it by index from high to low and figure out the sum of each column. Question 10: Define a function f to find the maximum value of each row
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
