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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started