Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution with table output:
This was fun!!
My Solution is here...
@AYXAcademy wrote:A solution to last week's challenge can be found here.
The Billboard (magazine) is a weekly American music and entertainment magazine that provides music charts. The Hot 100 lists the 100 most popular songs of the week in the US.
This dataset contains information about the Top 100 most popular songs between 2015 and 2021. Find out the top 5 artists and songs who stayed on the chart the longest (weekly) for each in 2017, 2018, 2019, 2020. Then create a table in the format of your choice to display your results.
Hint: The column "Weeks on Chart" shows how many weeks the song was on the charts since its launch.
I found different results when finding artists and songs who stayed on the chart the longest (weekly):