Question: ***I KNOW YOU DO NOT HAVE THE CSV FILE BUT I NEED HELP TROUBLESHOOTING THE CODE FOR IT*** FOR REFERENCE SuperBowl Date Network AVG_viewers TOT_viewers

***I KNOW YOU DO NOT HAVE THE CSV FILE BUT I NEED HELP TROUBLESHOOTING THE CODE FOR IT***

FOR REFERENCE

SuperBowl Date Network AVG_viewers TOT_viewers Rating Share 30secAD_Cost$
45 XLVI 2/5/2012 NBC 111350000 159200000.0 47.0 71 3442752
46 XLVII 2/3/2013 CBS 108690000 164100000.0 46.4 69 3765130
47 XLVIII 2/2/2014 Fox 112190000 NaN 46.7 69 4084864
48 XLIX 2/1/2015 NBC 114440000 161300000.0 47.5 71 4283129
49 L 2/7/2016 CBS 111860000 167000000.0 46.6 72 4800000
50 LI 2/5/2017 Fox 111320000 172000000.0 45.3 70 5399873
51 LII 2/4/2018 NBC 103470000 NaN 43.1 68 5235379
52 LIII 2/3/2019 CBS 98480000 149000000.0 41.1 67 5199916
53 LIV 2/2/2020 Fox 101320000 148500000.0 41.6 69 5400000
54 LV 2/7/2021 CBS 98200000 NaN 38.2 68 5500000

1. Create an array named SB_NUM containing the SuperBowl number DF_SUPERBOWL['SuperBowl'] - Use slicing syntax to only get ROWS 45 thru 55 ([45:55]) 2. Create an array named AD_COST containing the SuperBowl 30-second Ad Costs DF_SUPERBOWL['30secAD_Cost$'] - Use slicing syntax to only get ROWS 45 thru 55 ([45:55]) 3. Divide all the values in AD_COST by 1 million (i.e. 1000000) and save back to AD_COST 4. Set the title to 'SuperBowl 30 Second AD Costs (Millions USD)' with fontsize=15 5. Create a bar plot using SB_NUM & AD_COST 6. Set the xticks to the string of values in SB_NUM. [HINT: Remember to specify the range.] 7. Set the xlabel to 'SuperBowl Games'. 8. Set the ylabel to 'Ad Costs (Millions USD)'. 9. Add a horizontal grid() ONLY to make reading the values easier. 10. Show the plot

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!