i just need help with 2.7-14 please
auto.csv (it's a long file):
Problem 2 1. Go to the Canvas Week 2 Module to download the data 'auto.csv' to your Week 2 folder. Load the auto data and name it auto. 2. Find length and the shape of auto. 3. Drop the missing values and name the data auto again (Hint: auto=auto.dropnal)). 4. Find the column names of auto. 5. Find the first 20 rows of auto. 6. Select columns car', 'cylinders' and 'mpg' 7. Select the cell at the third row (row 2)and the fifth column 5(column 4) 8. Select the data from row 30 to row 100 within the columns 'mpg' and 'car 9. Sort auto by origin' and 'cylinders' 10. Drop auto columns 'displacement', 'weight', 'acceleration', and 'model, and name the remaining data as my_auto' 11. In the data table my_auto, select the rows by the two conditions: origin is US and mpg greater than 30, and name the selected rows as 'piecel' 12. In the data table my_auto, select the rows by the two conditions: origin is Japan and mpg greater than 30, and name the selected rows as 'piece2' 13. Merge piece1 and piece 2 along rows, name the merged data as 'auto_new' and save it toauto_new.xlsx' 14. Group auto_new by 'origin' and 'cylinders', and calculate the mean of other numerical columns. #Problem 2 #1 auto = pd. read_csv ( 'auto.csv') auto.head() #2 print('Length of the auto is: ', len(auto)) print( 'Shape of the auto is: ', auto.shape) #3 auto = auto.dropna () #4 print( 'column names of the auto are: ',list(auto.columns)) #5 auto. head (20) #6 print(auto[['car', 'cylinders', 'mpg'l]) #7 70 Europe 71 Europe mpg cylinders displacemehorsepowe weight acceleration model origin car 18 8 130 3504 12 70 US chevrolet chevelle malibu 15 8 165 3693 11.5 70 US buick skylark 320 18 8 8 150 3436 11 70 US plymouth satellite 16 8 150 3433 12 70 US amc rebel sst 17 8 140 3449 10.5 70 US ford torino 15 8 198 4341 10 70 US ford galaxie 500 14 8 220 4354 9 70 US chevrolet Impala 14 8 215 4312 8.5 70 US plymouth fury i 14 8 225 4425 10 70 US pontiac catalina 15 8 190 3850 8.5 70 US amc ambassador dpl 15 8 170 3563 10 70 US dodge challenger se 14 8 8 160 3609 8 70 US plymouth cuda 340 15 8 150 3761 9.5 70 US chevrolet monte carlo 14 8 225 3086 10 70 US buick estate wagon (sw) 24 4 4 95 2372 15 70 Japan toyota corona markii 22 6 95 2833 15.5 70 US plymouth duster 18 6 97 2774 15.5 70 US amc homet 21 6 85 2587 16 70 US ford maverick 27 4 4 88 2130 14.5 70 Japan datsun pl510 26 4 4 46 1835 20.5 70 Europe volkswagen 1131 deluxe sedan 25 4 4 87 2672 17.5 70 Europe peugeot 504 24 4 90 2430 14.5 70 Europe audi 100 Is 25 4 95 2375 17.5 70 Europe saab 99e 26 4 113 2234 12.5 bmw 2002 21 6 90 2648 15 70 US amc gremlin 10 8 215 4615 14 70 US ford f250 10 8 200 4376 15 70 US chevy c20 11 8 210 4382 13.5 70 US dodge d200 9 8 193 4732 18.5 70 US hi 12000 27 4 88 2130 14.5 71 Japan datsun pl510 28 4 90 2264 15.5 71 US chevrolet vega 2300 25 4 95 2228 14 71 Japan toyota corona 25 4 2046 19 71 US ford pinto 19 6 100 2634 13 71 US amc gremlin 16 6 105 3439 15.5 71 US plymouth satellite custom 17 6 100 3329 15.5 71 US chevrolet chevelle malibu 19 6 6 88 3302 15.5 71 US ford torino 500 18 6 100 3288 15.5 71 US amc matador 14 8 165 4209 12 71 US chevrolet Impala 14 8 175 4464 11.5 71 US pontiac catalina brougham 14 8 8 153 4154 13.5 71 US ford galaxie 500 14 8 150 4096 13 71 US plymouth fury it 12 8 180 4955 11.5 71 US dodge monaco (sw) 13 8 170 4746 12 71 US ford country squire (sw) 13 8 8 175 5140 12 71 US pontiac safari (sw) 18 6 110 2962 13.5 71 US amc homet sportabout (sw) 22 4 72 2408 19 71 US chevrolet vega (sw) 19 6 6 100 3282 15 71 US pontiac firebird 18 6 88 3139 14.5 71 US ford mustang 23 4 86 2220 14 71 US mercury capri 2000 28 4 90 2123 14 71 Europe opel 1900 30 4 4 70 2074 19.5 peugeot 304 30 4 4 76 2065 14.5 71 Europe fiat 124b 31 4 65 1773 19 71 Japan toyota corolla 1200 35 4 69 1613 18 71 Japan datsun 1200 27 4 60 1834 19 71 Europe volkswagen model 111 26 4 4 70 1955 20.5 71 US plymouth cricket 24 4 95 2278 15.5 72 Japan toyota corona hardtop 25 4 80 2126 17 72 US dodge colt hardtop 23 4 54 2254 23.5 72 Europe Volkswagen type 3 20 4 90 2408 19.5 72 US chevrolet vega 21 4 86 2226 16.5 72 US ford pinto runabout 13 8 165 4274 12 72 US chevrolet Impala 14 8 175 4385 12 72 US pontiac catalina 15 8 8 150 4135 13.5 72 US plymouth fury it 14 8 153 4129 13 72 US ford galaxie 500 17 8 150 3672 11.5 72 US amc ambassador sst 11 8 208 4633 11 72 US mercury marquis 13 8 8 155 4502 13.5 72 US buick lesabre custom 12 8 160 4456 13.5 72 US oldsmobile delta 88 royale 13 8 190 4422 12.5 72 US chrysler newport royal 19 3 97 2330 13.5 72 Japan mazda rx2 coupe 15 8 150 3892 12.5 72 US amc matador (sw) 13 8 130 4098 14 72 US chevrolet chevelle concours (sw) 13 8 140 4294 16 72 US ford gran torino (sw) 14 8 8 150 4077 14 72 US plymouth satellite custom (sw) 18 4 112 2933 14.5 72 Europe volvo 145e (sw) 22 4 76 2511 18 72 Europe volkswagen 411 (sw) 21 4 87 2979 19.5 72 Europe peugeot 504 (sw) 26 4 69 2189 18 72 Europe renault 12 (sw) 22 4 86 2395 16 72 US ford pinto (sw) 28 4 92 2288 17 72 Japan datsun 510 (SW) 23 4 97 2506 14.5 toyouta corona mark ii (sw) 28 4 80 2164 15 72 US dodge colt (sw) 27 4 88 2100 16.5 72 Japan toyota corolla 1600 (SW) 13 8 175 4100 13 73 US buick century 350 14 8 150 3672 11.5 73 US amc matador 13 8 145 3988 13 73 US chevrolet malibu 14 8 137 4042 14.5 73 US ford gran torino 15 8 150 3777 12.5 73 US dodge coronet custom 12 8 198 4952 11.5 73 US mercury marquis brougham 13 8 150 4464 12 73 US chevrolet caprice classic 13 8 158 4363 13 73 US ford Itd 14 8 150 4237 14.5 73 US plymouth fury gran sedan 13 8 215 4735 11 73 US chrysler new yorker brougham 12 8 8 225 4951 11 73 US buick electra 225 custom 13 8 175 3821 11 73 US amc ambassador brougham 18 6 6 105 3121 16.5 73 US plymouth valiant 16 6 100 3278 18 73 US chevrolet nova custom 18 6 100 2945 16 73 US amchomet 18 6 88 3021 16.5 73 US ford maverick 23 6 95 2904 16 73 US plymouth duster 26 4 46 1950 21 73 Europe volkswagen super beetle 11 8 150 4997 14 73 US chevrolet Impala 12 8 167 4906 12.5 73 US ford country 13 8 170 4654 13 73 US plymouth custom suburb 12 8 8 180 4499 12.5 73 US oldsmobile vista cruiser 18 6 100 2789 15 73 US amc gremlin 20 4 88 2279 19 73 Japan toyota carina 21 4 72 2401 19.5 73 US chevrolet vega 22 4 94 2379 16.5 73 Japan datsun 610 18 3 90 2124 13.5 73 Japan maxda rx3 19 4 85 2310 18.5 73 US ford pinto 21 6 107 2472 14 73 US mercury capri V6 26 4 90 2265 15.5 73 Europe fiat 124 sport coupe E 72 Japan 73 Europe 73 US US 74 Japa 74 US 74 US BEB1%=9npb%===%%5B%%%%%BBBBBBEHHEBEN%B 74 Europ 74 Europe 74 Europe apar 74 US 74 Europe 74 Europ apan Euro 75 US 75 US 75 US 75 US DER SIDENTIEREN TESETRE DROBRE SERREISEANNONSERRALEONTERTAINERS BEARNIER BEAN BENEDE EN REDENAARSEMANA SANGRANA SERENA ARIAS EORSANDROILERE ERHALTEN 75 US 75 Japan 75 US 75 US 15 75 Europ 75 Japa 75 US 4 75 Europe 75 Europe 75 Europe 75 Europ 78 76. Furos 76 US smakabadilikatalmi katalok adaladalinas 1. 76 US 76 Eurog S o Europ 78 76 US 76 US 14.9 180 27 11.1 119 145 14.5 2 lo 77 US 77 Eurog 77 US 77 Japat U 77 US 77 US uc us 77 US 77 US TU us 77 Eurog 77 US 77 Japa Tu 77 US 77 Japan 77 Europe pan 77 Janan 78 Europ 78 US 78 Japan volkswagen dasher 21.5 volkswagen rabbit custom diesel mazda gled 70 60 110 140 139 105 95 85 88 100 90 105 85 110 120 145 165 139 140 yon datsun b210 gx honda civic CVCC oldsmobile cutlass salon brougham dodge diplomat mercury monarch ghia pontiac phoenix chevrolet malibu ford fairmont (auto) ford fairmont (man) plymouth volare amc concord buick century special mercury zephyr dodge aspen amc concord d1 chevrolet monte carlo landau buick regal sport coupe (turbo) ford futura dodge magnum 10 chevrolet chevette toyota corona datsun 510 dodge omni toyota celica gt liftback plymouth Sapporo oldsmobile starfire sx datsun 200-sx audi 5000 volvo 264g saab 99gle 97 75 95 105 85 97 115 peugeot 604si 71 115 39.4 36.1 19.9 19.4 20.2 19.2 20.5 20.2 25.1 20.5 19.4 20.6 20.8 18.6 18.1 19.2 17.7 18.1 17.5 30 27.5 27.2 30.9 21.1 23.2 23.8 23.9 20.3 17 21.6 16.2 31.5 29.5 21.5 19.8 22.3 20.2 20.6 17 17.6 16.5 18.2 16.9 15.5 19.2 18.5 31.9 34.1 35.7 27.4 25.4 23 27.2 23.9 34.2 34.5 31.8 37.3 28.4 28.8 26.8 33.5 41.5 38.1 32.1 37.2 28 26.4 24.3 19.1 34.3 29.8 31.3 37 32.2 46.6 27.9 40.8 44.3 43.4 36.4 30 44.6 40.9 33.8 29.8 32.7 23.7 35 23.6 32.4 27.2 26.6 25.8 23.5 30 39.1 39 35.1 32.3 37 37.7 34.1 34.7 34.4 29.9 33 34.5 33.7 32.4 32.9 31.6 28.1 30.7 25.4 24.2 22.4 26.6 20.2 17.6 28 27 34 31 29 27 24 23 36 37 31 38 4 4 4 8 8 8 6 6 6 4 6 6 6 6 6 6 6 8 6 6 8 8 4 4 4 4 4 4 4 4 5 5 6 4 6 4 4 6 6 4 6 6 8 8 8 8 8 8 8 8 4 4 4 4 5 8 4 8 4 4 4 4 4 6 6 6 4 4 4 4 4 4 4 4 6 4 4 4 4 4 4 4 4 4 4 4 5 4 4 4 4 4 6 3 4 4 4 4 4 4 6 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 6 6 6 6 8 8 6 6 4 4 4 4 4 4 4 4 4 4 4 4 235SELESAIN SERAI 25888328385233588 * 3888888SIRET 8 8 8 8 5 BREEEEEEEEEE 8 2 8 8 585 95989889288555125 985803883588 59 a agbegEDERBIERENESS Blagog 8782%88% 8%Bm mu ws west amsuwns8ws 8 8333 88 90 110 130 129 138 135 155 142 125 150 71 65 80 80 77 125 71 90 70 70 65 69 90 115 115 90 76 60 70 65 90 88 90 90 78 90 75 92 75 2070 1800 3365 3735 3570 3535 3155 2965 2720 3430 3210 3380 3070 3620 3410 3425 3445 3205 4080 2155 2560 2300 2230 2515 2745 2855 2405 2830 3140 2795 3410 1990 2135 3245 2990 2890 3265 3360 3840 3725 3955 3830 4360 4054 3605 3940 1925 1975 1915 2670 3530 3900 3190 3420 2200 2150 2020 2130 2670 2595 2700 2556 2144 1968 2120 2019 2678 2870 3003 3381 2188 2711 2542 2434 2265 2110 2800 2110 2085 2335 2950 3250 1850 1835 2145 1845 2910 2420 2500 2905 2290 2490 2635 2620 2725 2385 1755 1875 1760 2065 1975 2050 1985 2215 2045 2380 2190 2320 2210 2350 2615 2635 3230 3160 2900 2930 3415 3725 3060 3465 2605 2640 2395 2575 2525 2735 2865 3035 1980 2025 1970 2125 18.6 16.4 15.5 13.2 12.8 19.2 18.2 15.8 15.4 17.2 17.2 15.8 16.7 18.7 15.1 13.2 13.4 11.2 13.7 16.5 14.2 14.7 14.5 14.8 16.7 17.6 14.9 15.9 13.6 15.7 15.8 14.9 16.6 15.4 18.2 17.3 18.2 16.6 15.4 13.4 13.2 15.2 14.9 14.3 15 13 14 15.2 14.4 15 20.1 17.4 24.8 222 13.2 14.9 19.2 14.7 16 11.3 12.9 13.2 14.7 18.8 15.5 16.4 16.5 18.1 20.1 18.7 15.8 15.5 17.5 15 15.2 17.9 14.4 19.2 21.7 23.7 19.9 21.8 13.8 17.3 78 Japan 78 Japan 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 US 78 Japan 78 Japan 78 US 78 Japan 78 US 78 US 78 Japan 78 Europe 78 Europe 78 Europe 78 Europe 78 Europe 78 Japan 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 US 79 Europe 79 Japan 79 US 79 US 79 Europe 79 US 79 Europe 79 US 79 US 79 US 79 Japan 79 Europe 79 US 79 US 79 US 79 US 80 Europe 80 Japan 80 US 80 Japan 80 US 80 US 80 US 80 US 80 Europe 80 Japan 80 Japan 80 Japan 80 Japan 80 Japan 80 US 80 Japan 80 Europe 80 Europe 80 Europe 80 Europe 80 Japan 80 Europe 80 Japan 80 Europe 80 Japan 80 Japan 80 Europe 80 US 80 Japan 81 US 81 US 81 US 81 US 81 US 81 Japan 81 US 81 Japan 81 Japan 81 Japan 81 Japan 81 Japan 81 US 81 US 81 US 81 Europe 81 Europe 81 Japan 81 Japan 81 Japan 81 Japan 81 Europe 81 Europe 81 Japan 81 Japan 81 US 81 US 81 US 81 US 82 US 82 US 82 US 82 US 82 US 82 US 82 US 82 US 82 Europe 82 Japan 82 Japan 82 US volkswagen Scirocco honda accord lx pontiac lemans v6 mercury zephyr 6 ford fairmont 4 amc concord dl 6 dodge aspen 6 chevrolet caprice classic ford Itd landau mercury grand marquis dodge st. regis buick estate wagon (sw) ford country squire (sw) chevrolet malibu classic (sw) chrysler lebaron town @ country (sw) ww rabbit custom maxda glc deluxe dodge colt hatchback custom amc spirit di mercedes benz 300d cadillac eldorado peugeot 504 oldsmobile cutlass salon brougham plymouth horizon plymouth horizontc3 datsun 210 fiat strada custom buick skylark limited chevrolet citation oldsmobile omega brougham pontiac phoenix ww rabbit toyota corolla tercel chevrolet chevette datsun 310 chevrolet citation ford fairmont amc concord dodge aspen audi 4000 toyota corona liftback mazda 626 datsun 510 hatchback toyota corolla mazda glc dodge colt datsun 210 ww rabbit c (diesel) ww dasher (diesel) audi 5000s (diesel) mercedes-benz 240d honda civic 1500 g renault lecar deluxe 105 48 67 67 67 18 subaru di 67 62 132 100 72 84 84 92 110 84 58 64 60 67 65 62 68 63 74 75 75 100 74 80 76 116 120 110 15.3 11.4 12.5 15.1 14.3 17 15.7 16.4 14.4 12.6 12.9 16.9 16.4 16.1 17.8 19.4 17.3 16 14.9 16.2 20.7 14.2 15.8 14.4 16.8 14.8 18.3 20.4 19.6 12.6 13.8 15.8 19 17.1 16.6 19.6 18.6 18 16.2 16 18 16.4 20.5 15.3 18.2 17.6 14.7 vokswagen rabbit datsun 280-zx mazda rx-7 gs triumph tr7 coupe ford mustang cobra honda accord plymouth reliant buick skylark dodge aries wagon (sw) chevrolet citation plymouth reliant toyota starlet plymouth champ honda civic 1300 subaru datsun 210 mpg toyota tercel mazda glc 4 plymouth horizon 4 ford escort 4w ford escort 2h volkswagen jetta renault 181 honda prelude toyota corolla datsun 200sx mazda 626 peugeot 505s turbo diesel volvo diesel toyota cressida datsun 810 maxima buick century oldsmobile cutlass is ford granada gl chrysler lebaron salon chevrolet cavalier chevrolet cavalier wagon chevrolet cavalier 2-door pontiac 2000 se hatchback dodge aries se pontiac phoenix ford fairmont futura amc concord di volkswagen rabbit mazda gle custom mazda glc custom plymouth horizon miser 88 85 88 88 88 85 84 90 92 74 68 68 63 70 36 36 36 34 38 32 38 25 38 26 22 32 36 27 27 44 32 28 31 4 4 4 4 4 4 6 6 4 6 4 4 4 4 4 4 4 4 98 120 107 108 91 91 91 181 262 156 232 144 135 151 140 97 135 120 119 88 75 70 67 67 67 110 85 92 112 96 2125 2160 2205 2245 1965 1965 1995 2945 3015 2585 2835 2665 2370 2950 2790 2130 2295 2625 2720 17.3 14.5 14.5 16.9 15 15.7 16.2 16.4 17 14.5 14.7 13.9 13 17.3 15.6 24.6 11.6 18.6 19.4 82 US mercury lynx 82 Japan nissan stanza xe 82 Japan honda accord 82 Japan toyota corolla 82 Japan honda civic 82 Japan honda civic (auto) 82 Japan datsun 310 gx 82 US buick century limited 82 US oldsmobile cutlass ciera (diesel) 82 US chrysler lebaron medallion 82 US ford granada 82 Japan toyota celica gt 82 US dodge charger 2.2 82 US chevrolet Camaro 82 US ford mustang gi 82 Europe w pickup 82 US dodge rampage 82 US ford ranger 82 US chevy S-10 84 90 86 52 84 79 82
