1. Which song was the streaming champion in each region and each year? Implement a loop to process each region and year automatically.

2. Which regional champions had the highest total stream counts overall, and where (and when) did they top the charts? Rank the champions against each other, not just by song name, but the region and the year they won are just as important.

3. How does the world's taste compare to a single country's taste? Are the global chart-toppers the same songs that also win locally, or does each region march to its own beat?

4. Is there a song that topped the charts in more than one region or in more than one year? A true hit that was successful in multiple regions tells a different story than a song that dominates just once.

• exclude Viral50 & missing # streams

• from date to year

• remove redundant columns

• streams / 1000

• exclude region = global

1

2

3

4