{ "cells": [ { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "# XPN 90s A to Z Countdown\n", "\n", "It's countdown time at [XPN](https://xpn.org).\n", "While I took a year off from doing stats last year,\n", "as the station did a bang up job and I had other things going on,\n", "I'm up for another crack at it.\n", "\n", "This year it's the [90s A-Z](https://xpn.org/program/90s-a-z/) countdown, \n", "which stated at 8am on December 1st.\n", "There's a [Real Time Countdown](https://xpn.org/countdown/90s-a-z/)\n", "and the usual [Twitter banter](https://twitter.com/search?q=%23XPN90sAtoZ).\n", "\n" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true, "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "%matplotlib inline\n", "from IPython.display import display, HTML" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "## Status\n", "\n", "It's Thursday, Dec 8, things have been running for over a week.\n", "And We're just finished Z at 8:30.\n", "\n", " - Resurrected most of the [Data Loading](Dataloading2.ipynb) with updates for the new playlist format\n", " - Started with the the absolute basics\n", " - Added in the trivial manipulations that don't need much data augmentation\n", " - Took a pass at doing breakdown by years. It needs work. But running with it for the moment\n", " - Added scan for sequential tracks by the same artist.\n", " - Added pivots for artist by year and by letter." ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "## Loading Data\n", "\n", "Most people don't care about how I get the data.\n", "If you do, checkout my [Dataloading](Dataloading2.ipynp) notebook.\n", "If you just want to play with the data,\n", "the playlist with some data augmentation, is here as [90sA2Z.csv](data/90sA2Z.csv).\n", "If you do something interesting, let me know,\n", "and post with the `#XPN90sAtoZ` hashtag so people can find it." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false, "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/html": [ "
So far, as of Dec 08 08:27AM, we have seen 2133 tracks with 2083 unique titles, from 860 artists.
" ], "text/plain": [ "So far, as of %s, we have seen %d tracks with %d unique titles, from %d artists.
' %\\\n", " (end_time.strftime('%b %d %I:%M%p'),\n", " len(playlist),\n", " playlist.describe(include='all')['Title']['unique'], \n", " playlist.describe(include='all')['Artist']['unique']\n", " ))" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "## Analysis\n", "\n", "### Most Popular Artist\n", "The first question everyone seems to ask is \"which artist has been played the most\".\n", "\n" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false, "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "[Artist | \n", "Songs | \n", "
---|---|
Nirvana | \n", "[All Apologies, All Apologies] | \n", "
Gomez | \n", "[Get Miles, Get Myself Arrested] | \n", "
Pearl Jam | \n", "[Given to Fly, Glorified G] | \n", "
Guided By Voices | \n", "[I Am A Scientist, I Am A Tree] | \n", "
The Lemonheads | \n", "[It's A Shame About Ray, It's About Time] | \n", "
Ben Harper | \n", "[Mama's Got A Girlfriend, Mama's Trippin'] | \n", "
Wilco | \n", "[Outta Mind (Outta Sight), Outtasite (Outta Mi... | \n", "
Nirvana | \n", "[Pennyroyal Tea, Pennyroyal Tea] | \n", "
Los Lobos | \n", "[Reva's House, Revolution] | \n", "
10,000 Maniacs | \n", "[These Are Days, These Days] | \n", "
Title | \n", "Count | \n", "
---|---|
All Apologies | \n", "3 | \n", "
Alright | \n", "2 | \n", "
Be Thankful For What You Got | \n", "2 | \n", "
Believe | \n", "2 | \n", "
Blue | \n", "2 | \n", "
Changes | \n", "2 | \n", "
Closing Time | \n", "2 | \n", "
Congo Square | \n", "2 | \n", "
Crazy | \n", "2 | \n", "
Creep | \n", "4 | \n", "
December | \n", "2 | \n", "
Drown | \n", "2 | \n", "
Early In The Morning | \n", "2 | \n", "
Everyday Is A Winding Road | \n", "2 | \n", "
Excuse Me Mr. | \n", "2 | \n", "
Friend Of The Devil | \n", "2 | \n", "
Hold On | \n", "4 | \n", "
I Know | \n", "2 | \n", "
I Need Love | \n", "2 | \n", "
It's Alright | \n", "2 | \n", "
Last Goodbye | \n", "2 | \n", "
Late At Night | \n", "2 | \n", "
Liar | \n", "2 | \n", "
Maria | \n", "2 | \n", "
Nothing Compares 2 U | \n", "2 | \n", "
One | \n", "2 | \n", "
Pennyroyal Tea | \n", "2 | \n", "
Right Here, Right Now | \n", "3 | \n", "
Ripple | \n", "2 | \n", "
Sexuality | \n", "2 | \n", "
Shine | \n", "2 | \n", "
Show Me Love | \n", "2 | \n", "
Spoonman | \n", "2 | \n", "
Stars | \n", "2 | \n", "
Stones In The Road | \n", "2 | \n", "
Summertime | \n", "2 | \n", "
Superstar | \n", "2 | \n", "
Tennessee | \n", "2 | \n", "
There She Goes | \n", "2 | \n", "
Time Bomb | \n", "2 | \n", "
Wild Horses | \n", "2 | \n", "
You | \n", "2 | \n", "
You And Your Sister | \n", "2 | \n", "
You Bowed Down | \n", "2 | \n", "