Icon

Challenge 05 - October

Loading the data

Filter for chart, getting the year and grouping the data

1. question - Regional champions

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

2. question - Overall winner

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.

Global champions

3. question - Regional or Global

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. question - Topped songs

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.

Reading the CSVfile into KNIME
CSV Reader
Bottom: Region = GlobalTop: Everything else
Row Splitter
Filter just for thetop200 chart as theviral50 has missingstreams
Row Filter
Extract the yearfrom the officialdate column
Date&Time Part Extractor
Making officialdate from thedate column
String to Date&Time
Grouping thedata by title, artist, url (UI),Region and YearSumming the streams
GroupBy
Looping through everyYear...
Group Loop Start
Creating the tableand the bar chartvisualization(3) Region andthe global win%)
Visualization
Just themost streamedsong
Top k Row Filter
Creating the tableand the bar chartvisualization(2/B How many years, unique years and regions was there a win?)
Visualization
Is the global winnerand the local winner isthe same in the Year?
Rule Engine
Region to groupglobal or local winner to columns
Pivot
... Collect themost streamedsongs
Loop End
Join the localchampions tableto the global champions table
Joiner
Global winner %calculation
Math Formula
Sort Global win%DESC
Sorter
Join thecount titleto the table
Joiner
Renamingthe table
Table Manipulator
By UI the rea
GroupBy
... Collect themost streamedsongs
Loop End
Looping through everyRegion and Year...
Group Loop Start
Descending orderof the streams
Sorter
TOP5 by Year
Table View
Just themost streamedsong
Top k Row Filter
Stream columnto double
Math Formula
Top: TOP5 by RegionBottom: TOP5 by Year
Data preparation
TOP5 by Region
Table View
Propercolumnnaming
Column Renamer
Creating the tableand the bar chartvisualization(1.) Showing the championsof the region and year)
Visualization
Song UI andcount of wins, uniqueregion and year counts
GroupBy
Creating the tableand the bar chartvisualization(2/A Showing the biggeststream count)
Visualization

Nodes

Extensions

Links