(1) Let's visit the billboard hot 100 page "https://www.billboard.com/charts/hot-100". Retrieve the following information: i) the rank of the song, ii) the artist's name, iii) the title of the song. Create a data frame to store this information. Rename your columns as "hot100.rank", "hot100.artist", "hot100.title". Your dataset should look like the following. Create a function with one input. The output of the function 5 is. If the input is a specific artist's name that exists in the data frame that you just created, then this function returns all his(her) songs on chart. If the input is a specific word "List", then this function returns all the names of the artists that are on chart. If the input is an artist's name that is in the data frame, or any other input, then return "Invalid Input".

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 4.9CP
icon
Related questions
Question
(1)
Let's visit the billboard hot 100 page
"https://www.billboard.com/charts/hot-100". Retrieve the following
information: i) the rank of the song, ii) the artist's name, iii) the title of the
song. Create a data frame to store this information. Rename your columns
as "hot100.rank", "hot100.artist", "hot100.title". Your dataset should look
like the following.
Transcribed Image Text:(1) Let's visit the billboard hot 100 page "https://www.billboard.com/charts/hot-100". Retrieve the following information: i) the rank of the song, ii) the artist's name, iii) the title of the song. Create a data frame to store this information. Rename your columns as "hot100.rank", "hot100.artist", "hot100.title". Your dataset should look like the following.
Create a function with one input. The output of the function
5
is.
If the input is a specific artist's name that exists in the data frame that
you just created, then this function returns all his(her) songs on chart.
If the input is a specific word "List", then this function returns all the
names of the artists that are on chart.
If the input is an artist's name that is in the data frame, or any other
input, then return "Invalid Input".
Transcribed Image Text:Create a function with one input. The output of the function 5 is. If the input is a specific artist's name that exists in the data frame that you just created, then this function returns all his(her) songs on chart. If the input is a specific word "List", then this function returns all the names of the artists that are on chart. If the input is an artist's name that is in the data frame, or any other input, then return "Invalid Input".
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning