Using the tips dataset, Create a pivot table showing average tip amount spent each day for...

  

Transcribed Image Text:

Using the tips dataset, Create a pivot table showing average tip amount spent each day for each gender. Your output should look like this. IMAKK Mala Famo day Thur 2.080333 2.575625 Fr 2.603000 2.781111 Sat 3.083893 2.801786 Sun 3.220345 3.367222 Figure 1 Output Example Q) Using the titanic dataset, use loc and Boolean indexing to return the dataframe only for women who did not survived the crash and were travelling in the third class. Your output may look like the one shown below; Using the titanic dataset, use loc and Boolean indexing to return the dataframe only for women who did not survived the crash and were travelling in the third class. Your output may look like the one shown below; EL INA survived plass 0 0 0 11 10 PA **** sibap parch 3 box 215 3 Senale 160 tale 304 3 hear 167 reak 164 899 SANGAT SAY # 52 4 # 11 2 rambarked class who aduk male deck arbark Thad worn & Tied wohan & Thad wanat & Thad woRLEY 3 Thid wohat DOD 1090000 0 $4700 4 1.5m 14:00 € 62 Trave Southamphoe Fake NaN Fase Nan Suntamplat FINE NAN Fake Na Fale NOW Sachar Souhay Love Swe Question marks) Sort the tips data frame with lowest to highest Tip Percentage (Hint: You need to first create a lip Percentage column) In the mpg dataset calculate the average weight of cars manufactured in each country. Your output may look like: 2423.300000 japan Use: 3361.931727 Name: weight, type: float64 On average how much do male smokers spend in the restaurant for their food bill (excluding tips) Your answer should be. Using the tips dataset, Create a pivot table showing average tip amount spent each day for each gender. Your output should look like this. IMAKK Mala Famo day Thur 2.080333 2.575625 Fr 2.603000 2.781111 Sat 3.083893 2.801786 Sun 3.220345 3.367222 Figure 1 Output Example Q) Using the titanic dataset, use loc and Boolean indexing to return the dataframe only for women who did not survived the crash and were travelling in the third class. Your output may look like the one shown below; Using the titanic dataset, use loc and Boolean indexing to return the dataframe only for women who did not survived the crash and were travelling in the third class. Your output may look like the one shown below; EL INA survived plass 0 0 0 11 10 PA **** sibap parch 3 box 215 3 Senale 160 tale 304 3 hear 167 reak 164 899 SANGAT SAY # 52 4 # 11 2 rambarked class who aduk male deck arbark Thad worn & Tied wohan & Thad wanat & Thad woRLEY 3 Thid wohat DOD 1090000 0 $4700 4 1.5m 14:00 € 62 Trave Southamphoe Fake NaN Fase Nan Suntamplat FINE NAN Fake Na Fale NOW Sachar Souhay Love Swe Question marks) Sort the tips data frame with lowest to highest Tip Percentage (Hint: You need to first create a lip Percentage column) In the mpg dataset calculate the average weight of cars manufactured in each country. Your output may look like: 2423.300000 japan Use: 3361.931727 Name: weight, type: float64 On average how much do male smokers spend in the restaurant for their food bill (excluding tips) Your answer should be.