Data can be an interesting and eye opening thing.
I decided to cut and paste some sections of my ITunes library into Google Docs and create a data set from Artist Track, Genre and Plays.
- sort tracks by PLAY COUNT
- remove TIME, BITRATE, DATE ADDED and TRACK NO columns
- scroll down to the bottom of the tracks with “2” plays
- select every song with 2+ plays
- open a blank spreadsheet (I use Google Docs) and CTRL-V into the top left corner of the page
- the Itunes data appear in the Spreadsheet
Obviously this data is immediately out of date, so I am looking now into turning this into a live feed. As a PC user ITunes stats is not an option.
Points to Note
- I often listen to Spotify instead of Itunes at home
- I only listen to Itunes when I am working – this does not take into account Ipod plays, or CD listening in car
- genre categorizations on Itunes can be questionable
So the first chart:
I’m not sure what I find more interesting – that metal is SUCH a tiny category (smaller than Country, worryingly) or that I seem to really like pop. I will investigate this further. Ok – a quick tweak to the options (colour to genre and label to ARTIST) showed that, phew, Ive not turned into a pop-loving indie kid just yet. It’s just that someone thinks Celldweller (industrial drum n bass noise) is alternative (see for yourself). (See, mislabelling , very deceiving)
- Find a way to make my Itunes data public, feed this into a live chart.
- Create a flash animation using one of these charts, with shooty out bits that play music from that artist or genre …
- Stop messing around with data for today and make some tea.