task 15 (second picture is for reference)

Out [79]: 2907.0 Task 15 (7 points) What is the most popular flavored vodka (imported or American) by Volume Sold (Gallons)? In [102] : NameError Traceback (most recent call las t) in 1 db - data t'City', 'Volume Sold(Gallons) '11.copy 2 df['total volumes" - df.groupby( 'City') I'Volume Sold(Gallons) 'J. transform('sum') 3 dt - af.drop ('Volume Sold (Gallons), axis-1).drop_duplicates().s0 rt_values('total_volumes').reset_index (drop True) 4 print(aft city'[df.shape0)-1]) NameError: name data is not defined Task 16 (5 points) What city drank the most Canadian Whiskios by Volumo Sold (Gallons)? In 11791: 'Itom Description" - "Canadian Whiskies" 11"Volume sold (Gallons)").mean() Save the lowaliquor Sales 2019and2020 csv file to the same place on your computer where this jupytar notebook is being saved. Pead in the lowaliquor Sales 2019and2020 csv file. Store the data in DataFrame called Aliquot. Show the top 4 rows Hint 1: it will take a long time to load this fie as it is a LARGE data file it is around 12 GB). Hint 2. you would like to make the look of the error go away, use, low_momory-False)" at the end of your pd.road.com. In 175): IAL.quor-pd. read_csv"Towat.quortales_2019 and 2020.01", low_memory-Palo) TALiquor.bend (4) them ber Date Store Number Store Name Address City Zip Store County Code Location Number County Bottle State State tiem Hem Pack Volume Bottle Bottle Number Description ml Cost Retail Volume Volume Bottle Sale Sold Sold Sold polfars) (Gallons) NUN NAN 6 10.50 NIN INV. 2010 0022 07.15 NAN 277 NaN NaN 1750 Scoresby Rare Scotch 4:00 10000 15.75 10,6 Fareway Stores 1470/ Perry Quick Shop Clear NAN 1000 10.11 6.74 2 0.52 NAN 2012 10000 20 3456 NAN Scoresby re Scotch NON NN INV 2019 0100 07.11 NN Captain Morgan OSRG wbom Arte 6 2.93 DA 162.00 1050 18.00 27.00 NAN 47,0 100107 INV. 2010 0013 07.23 516450 5151 500 Ida UM Hwy 175 Grove Smash Gain Me Out [79]: 2907.0 Task 15 (7 points) What is the most popular flavored vodka (imported or American) by Volume Sold (Gallons)? In [102] : NameError Traceback (most recent call las t) in 1 db - data t'City', 'Volume Sold(Gallons) '11.copy 2 df['total volumes" - df.groupby( 'City') I'Volume Sold(Gallons) 'J. transform('sum') 3 dt - af.drop ('Volume Sold (Gallons), axis-1).drop_duplicates().s0 rt_values('total_volumes').reset_index (drop True) 4 print(aft city'[df.shape0)-1]) NameError: name data is not defined Task 16 (5 points) What city drank the most Canadian Whiskios by Volumo Sold (Gallons)? In 11791: 'Itom Description" - "Canadian Whiskies" 11"Volume sold (Gallons)").mean() Save the lowaliquor Sales 2019and2020 csv file to the same place on your computer where this jupytar notebook is being saved. Pead in the lowaliquor Sales 2019and2020 csv file. Store the data in DataFrame called Aliquot. Show the top 4 rows Hint 1: it will take a long time to load this fie as it is a LARGE data file it is around 12 GB). Hint 2. you would like to make the look of the error go away, use, low_momory-False)" at the end of your pd.road.com. In 175): IAL.quor-pd. read_csv"Towat.quortales_2019 and 2020.01", low_memory-Palo) TALiquor.bend (4) them ber Date Store Number Store Name Address City Zip Store County Code Location Number County Bottle State State tiem Hem Pack Volume Bottle Bottle Number Description ml Cost Retail Volume Volume Bottle Sale Sold Sold Sold polfars) (Gallons) NUN NAN 6 10.50 NIN INV. 2010 0022 07.15 NAN 277 NaN NaN 1750 Scoresby Rare Scotch 4:00 10000 15.75 10,6 Fareway Stores 1470/ Perry Quick Shop Clear NAN 1000 10.11 6.74 2 0.52 NAN 2012 10000 20 3456 NAN Scoresby re Scotch NON NN INV 2019 0100 07.11 NN Captain Morgan OSRG wbom Arte 6 2.93 DA 162.00 1050 18.00 27.00 NAN 47,0 100107 INV. 2010 0013 07.23 516450 5151 500 Ida UM Hwy 175 Grove Smash Gain Me