First off, I am assuming that you have scraped the appropriate data using the code from the previous post.
Next, I will select just the data from 2013 and find the songs that were played most often.
top.songs=sqldf("Select ArtistSong, Count(ArtistSong) as Num
Group By ArtistSong
Order by Num DESC
The top 10 songs are the following:
Artist-Song Number Plays
1 FITZ AND THE TANTRUMS-OUT OF MY LEAGUE 809
2 ALT J-BREEZEBLOCKS 764
3 COLD WAR KIDS-MIRACLE MILE 759
4 ATLAS GENIUS-IF SO 750
5 FOALS-MY NUMBER 687
6 MS MR-HURRICANE 679
7 THE NEIGHBOURHOOD-SWEATER WEATHER 657
8 CAPITAL CITIES-SAFE AND SOUND 646
9 VAMPIRE WEEKEND-DIANE YOUNG 639
10 THE FEATURES-THIS DISORDER 632
I will make a plot similar to the plots made in the last post to show when the top 5 songs were played throughout the year.
plays.per.day=sqldf("Select Day, Count(Artist) as Num
Group By Day
Order by Day")
playlist.top.songs=subset(playlist,ArtistSong %in% top.songs$ArtistSong[1:5])
song.per.day=sqldf(paste0("Select Day, ArtistSong, Count(ArtistSong) as Num
Group By Day, ArtistSong
Order by Day, ArtistSong"))
labs(x="Date",y="Plays Per Day",title="Top Songs",colour=NULL)+
I can similarly summarize by artist as well.
top.artists=sqldf("Select Artist, Count(Artist) as Num
Group By Artist
Order by Num DESC
1 MUSE 1683
2 VAMPIRE WEEKEND 1504
3 SILVERSUN PICKUPS 1442
4 FOALS 1439
5 PHOENIX 1434
6 COLD WAR KIDS 1425
7 JAKE BUGG 1316
8 QUEENS OF THE STONE AGE 1296
9 ALT J 1233
10 OF MONSTERS AND MEN 1150
playlist.top.artists=subset(playlist,Artist %in% top.artists$Artist[1:5])
artists.per.day=sqldf(paste0("Select Day, Artist, Count(Artist) as Num
Group By Day, Artist
Order by Day, Artist"))
labs(x="Date",y="Plays Per Day",title="Top Artists",colour=NULL)+
Finally, I wrote a Shiny interactive app. They are surprisingly easy to create and if you are thinking about experimenting with it, I suggest you try it. I will leave the code for the app in a gist. In the app, you can enter any artist you want, and it will show you the most popular songs on CD102.5 for that artist. You can also select the number of songs that it plots with the slider.
For example, even though Muse did not have one of the most popular songs of the year, they were still the band that was played the most. By typing in "MUSE" in the Artist text input, you will get the following output.
Play around with it and let me know what you think.