Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

***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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions