XPN 885 Greatest Songs by Women¶
It's countdown time at XPN. This year it's the 885 Greatest Songs by Women. The stations is stepping up its stats game, so I'm not sure how much value I'll add. With only 885 tracks, compared with last year's 90's A-Z 2133 tracks, it may be a challenge. But we'll see what we can do.
Status¶
It's Tuesday, Dec 12, and we just finished.
- updated Data Loading, which always changes a bit
- resurrected data augmentation via MusicBrainz for publication year
- started with the basics, stealing from earlier years.
- add check to see how many of my votes have been played yet
- added a word (ok phrase) cloud of the most played artists
- added duplicated song titles.
Loading Data¶
If you want to see how I get the data,
checkout my Data Loading notebook.
If you want to play with the data,
an augmented playlist dataset is in women.csv.
If you do something interesting, let me know.
And post it to social media with the #XPNCountdown hashtag.
Word Cloud of Artists¶
Just for fun, we can turn that list into a word cloud
Popular Albums¶
On a short, 885 track, countdown, you might not expect too many tracks from the same album. But even this soon, there are a few albums with two tracks.
Tracks by Year¶
It's always interesting to see the distribution over time. XPN listeners are pretty diverse with broad tastes, so there's usually a spread here.
One catch is that I'm back to using Musicbrainz for publication dates. So I likely won't have years for all tracks.
Tracks by First Word¶
Back in the original A-Z, the first thing I did was break things down by first word. The whole "how much does counting 'the' and 'a' matter, is kind of what got this effort started.
Longest Songs¶
At some level the duration we calculate is somewhat suspect. There are station id breaks, and such. So just counting start to start is iffy. I may go back and pull this from Musicbrainz, since I need that for years and it will be more accurate. But it's still interesting.
Sequential Runs by an Artist¶
How often do we get runs of two or more consecutive tracks by the same artist? Those would have to have the same or "off by one" vote counts. Depending on how the playlist is orders among ties, this might happen a bit. But the two I see so far look like issues with the play list.
Duplicate Titles¶
It's hard to tell if the "same song" with diffrent artists has been played. But "same song title" is a decent approximation.
How did my votes do?¶
Like a lot of XPN listeners, I voted on this countdown. so how did my votes do?
Availability¶
The code for this project is in my github repo and this file is specifically 885SongsByWomen.ipynb.
License¶
This project is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. You are free to use for commercial or non-commercial purposes, so long as you attribute the source and also allow sharing.