From d9e7bac3496d434d65e3c1358918e4df3b247433 Mon Sep 17 00:00:00 2001 From: Neil Smith Date: Mon, 7 Aug 2017 10:50:05 +0100 Subject: [PATCH] Added another data source --- 1m.pkl.million-song-pickle.ipynb | 1330 +++++++++++++++++++++++++++ beatles-vs-stones-gather-data.ipynb | 306 ++---- 2 files changed, 1408 insertions(+), 228 deletions(-) create mode 100644 1m.pkl.million-song-pickle.ipynb diff --git a/1m.pkl.million-song-pickle.ipynb b/1m.pkl.million-song-pickle.ipynb new file mode 100644 index 0000000..d0c3600 --- /dev/null +++ b/1m.pkl.million-song-pickle.ipynb @@ -0,0 +1,1330 @@ +{ + "cells": [ + { + "cell_type": "code", + "execution_count": 1, + "metadata": { + "collapsed": true + }, + "outputs": [], + "source": [ + "import pickle\n", + "import gzip\n", + "import numpy\n", + "import collections" + ] + }, + { + "cell_type": "code", + "execution_count": 4, + "metadata": { + "collapsed": true + }, + "outputs": [], + "source": [ + "# data = pickle.load(open('1m.pkl/1m.pkl', 'rb'), encoding='latin1')" + ] + }, + { + "cell_type": "code", + "execution_count": 2, + "metadata": { + "collapsed": true + }, + "outputs": [], + "source": [ + "data = pickle.load(gzip.open('1m.pkl.gz', 'rb'), encoding='latin1')" + ] + }, + { + "cell_type": "code", + "execution_count": 3, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "{'artist_name': 'Baka Beyond',\n", + " 'duration': 368.14322,\n", + " 'key': 9,\n", + " 'loudness': -11.482,\n", + " 'tempo': 139.092,\n", + " 'track_name': 'Journey (Album Version)',\n", + " 'year': 1995}" + ] + }, + "execution_count": 3, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "data[0]" + ] + }, + { + "cell_type": "code", + "execution_count": 4, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "1000000" + ] + }, + "execution_count": 4, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "len(data)" + ] + }, + { + "cell_type": "code", + "execution_count": 5, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "72665" + ] + }, + "execution_count": 5, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "len(set(t['artist_name'] for t in data))" + ] + }, + { + "cell_type": "code", + "execution_count": 6, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "[('Michael Jackson', 194),\n", + " ('Johnny Cash', 193),\n", + " ('Beastie Boys', 187),\n", + " ('Joan Baez', 181),\n", + " ('Neil Diamond', 176)]" + ] + }, + "execution_count": 6, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "artist_counts = collections.Counter(t['artist_name'] for t in data)\n", + "artist_counts.most_common(5)" + ] + }, + { + "cell_type": "code", + "execution_count": 7, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "58" + ] + }, + "execution_count": 7, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "artist_counts['The Beatles']" + ] + }, + { + "cell_type": "code", + "execution_count": 8, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "95" + ] + }, + "execution_count": 8, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "artist_counts['Queen']" + ] + }, + { + "cell_type": "code", + "execution_count": 9, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "171" + ] + }, + "execution_count": 9, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "artist_counts['The Rolling Stones']" + ] + }, + { + "cell_type": "code", + "execution_count": 10, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "[{'artist_name': 'The Beatles',\n", + " 'duration': 267.10159,\n", + " 'key': 2,\n", + " 'loudness': -57.871,\n", + " 'tempo': 181.989,\n", + " 'track_name': 'Larry Kane Interviews Derek Taylor',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 263.88853,\n", + " 'key': 1,\n", + " 'loudness': -24.558,\n", + " 'tempo': 75.276,\n", + " 'track_name': 'Post Beatles Interview With George Harrison (c. 1976)',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 179.51302,\n", + " 'key': 5,\n", + " 'loudness': -22.808,\n", + " 'tempo': 111.16,\n", + " 'track_name': 'John and George To Allan Lappin in Melbourne',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 33.17506,\n", + " 'key': 11,\n", + " 'loudness': -21.798,\n", + " 'tempo': 215.977,\n", + " 'track_name': 'John Lennon on Yoko',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 117.62893,\n", + " 'key': 2,\n", + " 'loudness': -21.31,\n", + " 'tempo': 126.445,\n", + " 'track_name': 'Melody Maker Award Presentation En Route To The East Coast On 27th August 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 95.97342,\n", + " 'key': 10,\n", + " 'loudness': -20.954,\n", + " 'tempo': 85.521,\n", + " 'track_name': 'Italian TV Interview June 1965',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 160.15628,\n", + " 'key': 6,\n", + " 'loudness': -51.503,\n", + " 'tempo': 43.09,\n", + " 'track_name': 'Derek Taylor With The Beatles Hairdresser',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 596.6624,\n", + " 'key': 9,\n", + " 'loudness': -51.621,\n", + " 'tempo': 169.864,\n", + " 'track_name': 'Derek Taylor With George Harrison',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 196.12689,\n", + " 'key': 5,\n", + " 'loudness': -18.536,\n", + " 'tempo': 107.754,\n", + " 'track_name': 'John_ Paul_ George and Jimmy Nicol To DJ Bob Rogers on Route To Adelaide',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 331.02322,\n", + " 'key': 8,\n", + " 'loudness': -19.745,\n", + " 'tempo': 74.333,\n", + " 'track_name': 'The Beatles To Bob Rogers At St. George Hotel_ Wellington_ New Zealand',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 25.18159,\n", + " 'key': 1,\n", + " 'loudness': -23.683,\n", + " 'tempo': 85.482,\n", + " 'track_name': 'George Telephone Conversation To DJ Barry Ferber',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 259.70893,\n", + " 'key': 11,\n", + " 'loudness': -18.095,\n", + " 'tempo': 221.12,\n", + " 'track_name': 'Press Conference in Minneapolis August 1965',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 52.03546,\n", + " 'key': 1,\n", + " 'loudness': -23.042,\n", + " 'tempo': 53.874,\n", + " 'track_name': 'Ringo To DJ Mike Walsh',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 209.71057,\n", + " 'key': 3,\n", + " 'loudness': -17.987,\n", + " 'tempo': 74.803,\n", + " 'track_name': \"Ringo's Arrival in Sydney To Garvin Rutherford\",\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 153.93914,\n", + " 'key': 11,\n", + " 'loudness': -27.675,\n", + " 'tempo': 75.756,\n", + " 'track_name': 'Ringo Starr Gives His Reactions To New York And The Fans On 29th August 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 435.48689,\n", + " 'key': 6,\n", + " 'loudness': -50.714,\n", + " 'tempo': 56.613,\n", + " 'track_name': 'Derek Taylor - With Ringo Starr',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 66.0371,\n", + " 'key': 7,\n", + " 'loudness': -15.485,\n", + " 'tempo': 81.801,\n", + " 'track_name': 'The Beatles in Melbourne',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 373.10649,\n", + " 'key': 2,\n", + " 'loudness': -31.538,\n", + " 'tempo': 114.095,\n", + " 'track_name': 'Manager Brian Epstein Gives A Rare Interview On 28th August 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 240.95302,\n", + " 'key': 8,\n", + " 'loudness': -19.91,\n", + " 'tempo': 215.253,\n", + " 'track_name': 'John_ Paul_ George and Jimmy Nicol Arrival in Sydney',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 303.80363,\n", + " 'key': 1,\n", + " 'loudness': -18.414,\n", + " 'tempo': 196.224,\n", + " 'track_name': 'Paul Mccartney Discusses The Fans Reaction On Arrival At New York_ The Big Apple And The Forest Hill',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 303.41179,\n", + " 'key': 1,\n", + " 'loudness': -17.13,\n", + " 'tempo': 123.351,\n", + " 'track_name': 'Ringo Starr Gives His Views On Country And Western Music_ Sports_ Monopoly_ The Beatles And Fan Club',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 403.1473,\n", + " 'key': 0,\n", + " 'loudness': -17.741,\n", + " 'tempo': 123.082,\n", + " 'track_name': 'Press Officer Derek Taylor Discusses The Atlantic City Concert And The Police Protection On 1st Sept',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 501.91628,\n", + " 'key': 5,\n", + " 'loudness': -23.96,\n", + " 'tempo': 197.495,\n", + " 'track_name': 'Seattle Interview August 1966',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 125.54404,\n", + " 'key': 9,\n", + " 'loudness': -27.262,\n", + " 'tempo': 117.996,\n", + " 'track_name': 'Tokyo Interview July 1966',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 84.58404,\n", + " 'key': 8,\n", + " 'loudness': -21.393,\n", + " 'tempo': 67.384,\n", + " 'track_name': 'John Lennon on Religion',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 168.64608,\n", + " 'key': 2,\n", + " 'loudness': -15.198,\n", + " 'tempo': 55.097,\n", + " 'track_name': 'John Lennon Talks About New York And The Concert At Forest Hills On 29th August 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 57.67791,\n", + " 'key': 4,\n", + " 'loudness': -21.752,\n", + " 'tempo': 177.38,\n", + " 'track_name': \"Paul McCartney's Birthday on 2SM Radio_ Sydney\",\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 24.08444,\n", + " 'key': 11,\n", + " 'loudness': -19.717,\n", + " 'tempo': 100.013,\n", + " 'track_name': 'John Lennon on Exams',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 230.50404,\n", + " 'key': 2,\n", + " 'loudness': -25.958,\n", + " 'tempo': 111.458,\n", + " 'track_name': 'George_ John_ Ringo and Fans in Auckland To Bob Rogers',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 130.45506,\n", + " 'key': 1,\n", + " 'loudness': -16.694,\n", + " 'tempo': 109.879,\n", + " 'track_name': 'Road Manager Neil Aspinall Talks About The Escape From Fans Following The Concert In Atlantic City O',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 183.69261,\n", + " 'key': 1,\n", + " 'loudness': -20.684,\n", + " 'tempo': 101.193,\n", + " 'track_name': 'Sydney Farewell With Bob Rogers_ George and John',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 197.22404,\n", + " 'key': 1,\n", + " 'loudness': -20.205,\n", + " 'tempo': 110.443,\n", + " 'track_name': 'John Lennon on the Rolling Stones',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 699.55873,\n", + " 'key': 5,\n", + " 'loudness': -24.965,\n", + " 'tempo': 224.343,\n", + " 'track_name': \"John_ Paul_ Ringo_ and George After the Lord Mayor's Reception in Auckland To Bob Rogers\",\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 205.00853,\n", + " 'key': 1,\n", + " 'loudness': -21.308,\n", + " 'tempo': 112.673,\n", + " 'track_name': 'Inside Adelaide Hotel Room To Bob Rogers',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 196.44036,\n", + " 'key': 1,\n", + " 'loudness': -21.216,\n", + " 'tempo': 83.73,\n", + " 'track_name': 'George_ John_ Ringo and Paul to Bob Rogers on Arrival in New Zealand',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 73.66485,\n", + " 'key': 8,\n", + " 'loudness': -23.871,\n", + " 'tempo': 91.695,\n", + " 'track_name': 'Paul and John on Landing in Australia from Hong Kong To DJ John Edwards',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 131.63057,\n", + " 'key': 1,\n", + " 'loudness': -8.485,\n", + " 'tempo': 159.317,\n", + " 'track_name': \"Ain't She Sweet\",\n", + " 'year': 1964},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 53.78567,\n", + " 'key': 6,\n", + " 'loudness': -47.664,\n", + " 'tempo': 112.361,\n", + " 'track_name': 'Derek Taylor - Introduction',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 148.84526,\n", + " 'key': 0,\n", + " 'loudness': -18.393,\n", + " 'tempo': 88.617,\n", + " 'track_name': 'Madrid To Australian By Graham Webb July 1965',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 163.52608,\n", + " 'key': 0,\n", + " 'loudness': -21.606,\n", + " 'tempo': 100.62,\n", + " 'track_name': 'Messages from the Beatles After First Trip To USA in Miami_ February 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 133.04118,\n", + " 'key': 4,\n", + " 'loudness': -7.119,\n", + " 'tempo': 159.323,\n", + " 'track_name': \"Ain't She Sweet\",\n", + " 'year': 1964},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 140.38159,\n", + " 'key': 6,\n", + " 'loudness': -22.085,\n", + " 'tempo': 189.577,\n", + " 'track_name': 'George Harrison Telephone Interview_ Miami February 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 283.08853,\n", + " 'key': 6,\n", + " 'loudness': -27.49,\n", + " 'tempo': 89.028,\n", + " 'track_name': \"George Harrison Gives His Views On Press Conferences_ A Hard Day'S Night And The Usa Compared To The\",\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 180.76689,\n", + " 'key': 10,\n", + " 'loudness': -23.302,\n", + " 'tempo': 120.125,\n", + " 'track_name': 'Paul and George To Tony McArthur in Wellington',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 139.38893,\n", + " 'key': 11,\n", + " 'loudness': -19.4,\n", + " 'tempo': 74.434,\n", + " 'track_name': 'George_ John and Paul About Hong Kong To DJ Bob Rogers',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 354.71628,\n", + " 'key': 1,\n", + " 'loudness': -19.857,\n", + " 'tempo': 135.677,\n", + " 'track_name': 'Paul Mccartney Talks About Acting_ Folk-Rock_ Miami And The Press On 29th August',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 209.05751,\n", + " 'key': 4,\n", + " 'loudness': -50.664,\n", + " 'tempo': 71.725,\n", + " 'track_name': 'Derek Taylor With John_ Paul_ George and Ringo',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 177.6322,\n", + " 'key': 1,\n", + " 'loudness': -19.084,\n", + " 'tempo': 98.264,\n", + " 'track_name': 'In Sydney With Bob Rogers',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 100.20526,\n", + " 'key': 0,\n", + " 'loudness': -19.02,\n", + " 'tempo': 243.151,\n", + " 'track_name': 'Concert Announcements_ from Paul in Melbourne',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 228.12689,\n", + " 'key': 6,\n", + " 'loudness': -51.235,\n", + " 'tempo': 46.343,\n", + " 'track_name': 'Derek Taylor With John Lennon',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 460.48608,\n", + " 'key': 10,\n", + " 'loudness': -17.625,\n", + " 'tempo': 254.209,\n", + " 'track_name': 'John Discusses The Effects Of Beatlemania On Family Life_ A Hard Days Night_ Touring And Concerts On',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 134.84363,\n", + " 'key': 9,\n", + " 'loudness': -19.704,\n", + " 'tempo': 226.528,\n", + " 'track_name': 'John Lennon on \"Yesterday and Today\" Album Cover',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 213.28934,\n", + " 'key': 10,\n", + " 'loudness': -17.143,\n", + " 'tempo': 129.532,\n", + " 'track_name': 'George Harrison Discusses The Differences Between English And Americam Lifestyles On 9th September 1',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 749.66159,\n", + " 'key': 9,\n", + " 'loudness': -19.887,\n", + " 'tempo': 70.212,\n", + " 'track_name': 'Sydney Press Conference June 1964',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 58.04363,\n", + " 'key': 3,\n", + " 'loudness': -22.677,\n", + " 'tempo': 85.418,\n", + " 'track_name': 'John Lennon on Drugs',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 490.68363,\n", + " 'key': 10,\n", + " 'loudness': -49.7,\n", + " 'tempo': 40.103,\n", + " 'track_name': 'Derek Taylor With Paul McCartney',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 52.45342,\n", + " 'key': 6,\n", + " 'loudness': -22.014,\n", + " 'tempo': 98.448,\n", + " 'track_name': 'Post Beatles Interviews With John Lennon (c. 1971/74). JL on School.',\n", + " 'year': 0},\n", + " {'artist_name': 'The Beatles',\n", + " 'duration': 197.17179,\n", + " 'key': 7,\n", + " 'loudness': -16.026,\n", + " 'tempo': 106.759,\n", + " 'track_name': 'Adelaide Town Hall Balcony With Bob Francis and Bob Rogers',\n", + " 'year': 0}]" + ] + }, + "execution_count": 10, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "[t for t in data if t['artist_name'] == 'The Beatles']" + ] + }, + { + "cell_type": "code", + "execution_count": 11, + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "[{'artist_name': 'Queen',\n", + " 'duration': 262.19057,\n", + " 'key': 2,\n", + " 'loudness': -13.386,\n", + " 'tempo': 77.464,\n", + " 'track_name': 'Love Of My Life',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 68.64934,\n", + " 'key': 2,\n", + " 'loudness': -18.707,\n", + " 'tempo': 67.584,\n", + " 'track_name': 'Dear Friends (1993 Digital Remaster)',\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 247.71873,\n", + " 'key': 10,\n", + " 'loudness': -13.475,\n", + " 'tempo': 180.291,\n", + " 'track_name': 'Breakthru',\n", + " 'year': 1989},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 123.16689,\n", + " 'key': 11,\n", + " 'loudness': -9.329,\n", + " 'tempo': 81.346,\n", + " 'track_name': 'We Will Rock You',\n", + " 'year': 1973},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 378.06975,\n", + " 'key': 9,\n", + " 'loudness': -6.268,\n", + " 'tempo': 155.912,\n", + " 'track_name': \"Now I'm Here\",\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 521.82159,\n", + " 'key': 4,\n", + " 'loudness': -10.479,\n", + " 'tempo': 149.901,\n", + " 'track_name': \"Now I'm Here (Live) (1994 Digital Remaster)\",\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 116.08771,\n", + " 'key': 9,\n", + " 'loudness': -18.238,\n", + " 'tempo': 171.156,\n", + " 'track_name': 'Crazy Little Thing Called Love (With Commentary)',\n", + " 'year': 2009},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 170.84036,\n", + " 'key': 0,\n", + " 'loudness': -5.09,\n", + " 'tempo': 120.082,\n", + " 'track_name': \"You're My Best Friend\",\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 176.69179,\n", + " 'key': 3,\n", + " 'loudness': -9.607,\n", + " 'tempo': 95.714,\n", + " 'track_name': 'Good Old Fashioned Lover Boy (2008 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 216.63302,\n", + " 'key': 2,\n", + " 'loudness': -19.615,\n", + " 'tempo': 195.766,\n", + " 'track_name': 'Bijou',\n", + " 'year': 1991},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 313.70404,\n", + " 'key': 3,\n", + " 'loudness': -13.806,\n", + " 'tempo': 141.549,\n", + " 'track_name': 'Bohemian Rhapsody (Live In Frankfurt Bootleg)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 168.80281,\n", + " 'key': 9,\n", + " 'loudness': -6.722,\n", + " 'tempo': 137.835,\n", + " 'track_name': 'Need Your Loving Tonight (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 111.72526,\n", + " 'key': 4,\n", + " 'loudness': -16.231,\n", + " 'tempo': 98.86,\n", + " 'track_name': 'The Show Must Go On (With Commentary)',\n", + " 'year': 2009},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 203.41506,\n", + " 'key': 1,\n", + " 'loudness': -17.797,\n", + " 'tempo': 181.896,\n", + " 'track_name': 'My Baby Does Me',\n", + " 'year': 1989},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 110.68036,\n", + " 'key': 1,\n", + " 'loudness': -5.039,\n", + " 'tempo': 191.219,\n", + " 'track_name': 'Hello Mary Lou (Goodbye Heart) (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 352.46975,\n", + " 'key': 2,\n", + " 'loudness': -15.195,\n", + " 'tempo': 72.398,\n", + " 'track_name': 'Teo Torriatte (Let Us Cling Together) (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 133.92934,\n", + " 'key': 7,\n", + " 'loudness': -6.5,\n", + " 'tempo': 120.923,\n", + " 'track_name': 'Stone Cold Crazy',\n", + " 'year': 1973},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 259.00363,\n", + " 'key': 0,\n", + " 'loudness': -7.761,\n", + " 'tempo': 88.218,\n", + " 'track_name': 'Dragon Attack (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 83.9571,\n", + " 'key': 9,\n", + " 'loudness': -12.052,\n", + " 'tempo': 110.587,\n", + " 'track_name': \"Flash's Theme Reprise (Victory Celebrations) (1994 Digital Remaster)\",\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 136.14975,\n", + " 'key': 0,\n", + " 'loudness': -10.266,\n", + " 'tempo': 168.344,\n", + " 'track_name': 'Seaside Rendezvous (1993 Digital Remaster)',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 272.48281,\n", + " 'key': 1,\n", + " 'loudness': -12.685,\n", + " 'tempo': 132.384,\n", + " 'track_name': 'Body Language (1994 Digital Remaster)',\n", + " 'year': 1982},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 114.1024,\n", + " 'key': 4,\n", + " 'loudness': -10.178,\n", + " 'tempo': 111.034,\n", + " 'track_name': 'Flash',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 206.49751,\n", + " 'key': 7,\n", + " 'loudness': -10.206,\n", + " 'tempo': 104.682,\n", + " 'track_name': \"'39 (Live) (1994 Digital Remaster)\",\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 73.09016,\n", + " 'key': 0,\n", + " 'loudness': -14.905,\n", + " 'tempo': 152.266,\n", + " 'track_name': \"Vultan's Theme (Attack Of The Hawk Men) (1994 Digital Remaster)\",\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 354.2722,\n", + " 'key': 10,\n", + " 'loudness': -10.872,\n", + " 'tempo': 71.568,\n", + " 'track_name': 'Bohemian Rhapsody',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 294.37342,\n", + " 'key': 10,\n", + " 'loudness': -13.753,\n", + " 'tempo': 94.789,\n", + " 'track_name': 'The Millionaire Waltz (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 255.60771,\n", + " 'key': 7,\n", + " 'loudness': -6.067,\n", + " 'tempo': 161.351,\n", + " 'track_name': 'Crazy Little Thing Called Love (Live In Montreal)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 109.73995,\n", + " 'key': 8,\n", + " 'loudness': -12.07,\n", + " 'tempo': 126.34,\n", + " 'track_name': 'Misfire (1993 Digital Remaster)',\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 287.7122,\n", + " 'key': 7,\n", + " 'loudness': -8.905,\n", + " 'tempo': 91.968,\n", + " 'track_name': 'Mother Love',\n", + " 'year': 1995},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 76.43383,\n", + " 'key': 9,\n", + " 'loudness': -13.642,\n", + " 'tempo': 116.07,\n", + " 'track_name': 'The Hero (Live In Frankfurt Bootleg)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 379.55873,\n", + " 'key': 9,\n", + " 'loudness': -4.855,\n", + " 'tempo': 147.381,\n", + " 'track_name': \"Now I'm Here (Live)\",\n", + " 'year': 2009},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 385.93261,\n", + " 'key': 2,\n", + " 'loudness': -6.982,\n", + " 'tempo': 90.895,\n", + " 'track_name': \"It's Late\",\n", + " 'year': 1977},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 212.16608,\n", + " 'key': 2,\n", + " 'loudness': -9.37,\n", + " 'tempo': 136.986,\n", + " 'track_name': 'Death On Two Legs (Dedicated To....) (Live) (1994 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 363.85914,\n", + " 'key': 9,\n", + " 'loudness': -4.79,\n", + " 'tempo': 136.562,\n", + " 'track_name': 'Hammer To Fall (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 225.17506,\n", + " 'key': 2,\n", + " 'loudness': -11.716,\n", + " 'tempo': 134.304,\n", + " 'track_name': 'In The Lap Of The Gods...Revisited (1993 Digital Remaster)',\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 331.62404,\n", + " 'key': 6,\n", + " 'loudness': -5.582,\n", + " 'tempo': 152.226,\n", + " 'track_name': \"Now I'm Here (Live In Montreal)\",\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 224.96608,\n", + " 'key': 9,\n", + " 'loudness': -5.282,\n", + " 'tempo': 76.72,\n", + " 'track_name': 'Tie Your Mother Down',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 181.08036,\n", + " 'key': 10,\n", + " 'loudness': -8.196,\n", + " 'tempo': 94.836,\n", + " 'track_name': 'We Are The Champions (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 355.7873,\n", + " 'key': 0,\n", + " 'loudness': -12.557,\n", + " 'tempo': 72.499,\n", + " 'track_name': 'Bohemian Rhapsody (2008 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 228.44036,\n", + " 'key': 2,\n", + " 'loudness': -15.229,\n", + " 'tempo': 121.664,\n", + " 'track_name': 'Under Pressure (Live At Nepstadion)',\n", + " 'year': 1986},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 227.91791,\n", + " 'key': 7,\n", + " 'loudness': -8.168,\n", + " 'tempo': 81.603,\n", + " 'track_name': 'Save Me (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 66.37669,\n", + " 'key': 9,\n", + " 'loudness': -4.79,\n", + " 'tempo': 154.831,\n", + " 'track_name': 'Big Spender (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 78.47138,\n", + " 'key': 5,\n", + " 'loudness': -13.964,\n", + " 'tempo': 121.926,\n", + " 'track_name': 'Nevermore (1994 Digital Remaster)',\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 173.76608,\n", + " 'key': 3,\n", + " 'loudness': -12.068,\n", + " 'tempo': 95.912,\n", + " 'track_name': 'Good Old Fashioned Lover Boy (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 297.29914,\n", + " 'key': 8,\n", + " 'loudness': -8.393,\n", + " 'tempo': 109.753,\n", + " 'track_name': 'Somebody To Love (2008 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 384.65261,\n", + " 'key': 4,\n", + " 'loudness': -9.182,\n", + " 'tempo': 159.334,\n", + " 'track_name': 'Liar (1994 Digital Remaster)',\n", + " 'year': 1973},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 124.73424,\n", + " 'key': 9,\n", + " 'loudness': -13.43,\n", + " 'tempo': 115.926,\n", + " 'track_name': 'Marriage Of Dale And Ming (And Flash Approaching) (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 186.14812,\n", + " 'key': 4,\n", + " 'loudness': -4.656,\n", + " 'tempo': 180.066,\n", + " 'track_name': 'We Will Rock You (Fast Version) (Live In Montreal)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 298.26567,\n", + " 'key': 7,\n", + " 'loudness': -11.878,\n", + " 'tempo': 119.786,\n", + " 'track_name': 'White Man (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 270.88934,\n", + " 'key': 2,\n", + " 'loudness': -9.656,\n", + " 'tempo': 81.568,\n", + " 'track_name': 'Las Palabras De Amor (The Words Of Love) (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 218.95791,\n", + " 'key': 5,\n", + " 'loudness': -15.136,\n", + " 'tempo': 76.601,\n", + " 'track_name': 'Love Of My Life (1993 Digital Remaster)',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 253.80526,\n", + " 'key': 9,\n", + " 'loudness': -11.099,\n", + " 'tempo': 132.488,\n", + " 'track_name': \"Now I'm Here (2008 Digital Remaster)\",\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 224.522,\n", + " 'key': 2,\n", + " 'loudness': -14.544,\n", + " 'tempo': 145.206,\n", + " 'track_name': 'Drowse (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 237.40036,\n", + " 'key': 0,\n", + " 'loudness': -5.567,\n", + " 'tempo': 248.405,\n", + " 'track_name': 'Play The Game (Live In Montreal)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 295.99302,\n", + " 'key': 8,\n", + " 'loudness': -11.901,\n", + " 'tempo': 109.669,\n", + " 'track_name': 'Somebody To Love (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 307.85261,\n", + " 'key': 0,\n", + " 'loudness': -8.478,\n", + " 'tempo': 111.493,\n", + " 'track_name': 'Machines (Or Back To Humans) (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 175.59465,\n", + " 'key': 0,\n", + " 'loudness': -13.07,\n", + " 'tempo': 170.908,\n", + " 'track_name': 'We Will Rock You (Live In Frankfurt Bootleg)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 222.06649,\n", + " 'key': 7,\n", + " 'loudness': -10.986,\n", + " 'tempo': 150.93,\n", + " 'track_name': 'A Human Body (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 185.20771,\n", + " 'key': 4,\n", + " 'loudness': -10.598,\n", + " 'tempo': 143.214,\n", + " 'track_name': \"I'm In Love With My Car (1993 Digital Remaster)\",\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 60.89098,\n", + " 'key': 2,\n", + " 'loudness': -14.096,\n", + " 'tempo': 115.744,\n", + " 'track_name': 'Crash Dive On Mingo City (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 213.36771,\n", + " 'key': 9,\n", + " 'loudness': -11.069,\n", + " 'tempo': 116.52,\n", + " 'track_name': 'Long Away (1993 Digital Remaster)',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 285.98812,\n", + " 'key': 3,\n", + " 'loudness': -7.002,\n", + " 'tempo': 110.103,\n", + " 'track_name': 'Get Down Make Love (Live In Montreal)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 202.762,\n", + " 'key': 2,\n", + " 'loudness': -10.352,\n", + " 'tempo': 89.171,\n", + " 'track_name': 'Fat Bottomed Girls (2008 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 67.23873,\n", + " 'key': 3,\n", + " 'loudness': -14.364,\n", + " 'tempo': 132.818,\n", + " 'track_name': 'Lazing On A Sunday Afternoon (1993 Digital Remaster)',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 208.43057,\n", + " 'key': 7,\n", + " 'loudness': -10.255,\n", + " 'tempo': 150.796,\n", + " 'track_name': 'Man On The Prowl (1994 Digital Remaster)',\n", + " 'year': 1984},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 344.39791,\n", + " 'key': 9,\n", + " 'loudness': -12.427,\n", + " 'tempo': 88.254,\n", + " 'track_name': 'Was It All Worth It',\n", + " 'year': 1989},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 258.84689,\n", + " 'key': 7,\n", + " 'loudness': -8.539,\n", + " 'tempo': 107.714,\n", + " 'track_name': \"Thank God It's Christmas\",\n", + " 'year': 1991},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 355.02975,\n", + " 'key': 10,\n", + " 'loudness': -14.333,\n", + " 'tempo': 72.11,\n", + " 'track_name': 'Bohemian Rhapsody (1993 Digital Remaster)',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 264.09751,\n", + " 'key': 4,\n", + " 'loudness': -13.56,\n", + " 'tempo': 130.117,\n", + " 'track_name': 'A Kind Of Magic',\n", + " 'year': 1986},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 358.94812,\n", + " 'key': 4,\n", + " 'loudness': -5.566,\n", + " 'tempo': 115.89,\n", + " 'track_name': 'Another One Bites The Dust (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 83.87873,\n", + " 'key': 7,\n", + " 'loudness': -6.376,\n", + " 'tempo': 141.076,\n", + " 'track_name': 'God Save The Queen',\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 335.77751,\n", + " 'key': 0,\n", + " 'loudness': -9.632,\n", + " 'tempo': 110.236,\n", + " 'track_name': 'Heaven For Everyone (Album Version)',\n", + " 'year': 1995},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 473.23383,\n", + " 'key': 8,\n", + " 'loudness': -6.163,\n", + " 'tempo': 119.702,\n", + " 'track_name': 'Somebody To Love',\n", + " 'year': 1976},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 189.59628,\n", + " 'key': 5,\n", + " 'loudness': -14.154,\n", + " 'tempo': 79.734,\n", + " 'track_name': 'All Dead All Dead (1993 Digital Remaster)',\n", + " 'year': 1977},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 245.9424,\n", + " 'key': 7,\n", + " 'loudness': -3.678,\n", + " 'tempo': 147.047,\n", + " 'track_name': 'Tie Your Mother Down (Live)',\n", + " 'year': 2004},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 210.46812,\n", + " 'key': 2,\n", + " 'loudness': -10.369,\n", + " 'tempo': 117.933,\n", + " 'track_name': 'The Hero (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 252.682,\n", + " 'key': 8,\n", + " 'loudness': -7.533,\n", + " 'tempo': 60.782,\n", + " 'track_name': 'No One But You (Only The Good Die Young)',\n", + " 'year': 1997},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 78.75873,\n", + " 'key': 0,\n", + " 'loudness': -15.896,\n", + " 'tempo': 111.159,\n", + " 'track_name': 'Heaven For Everyone (With Commentary)',\n", + " 'year': 2009},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 172.59057,\n", + " 'key': 0,\n", + " 'loudness': -5.079,\n", + " 'tempo': 120.179,\n", + " 'track_name': \"You're My Best Friend\",\n", + " 'year': 1975},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 178.41587,\n", + " 'key': 1,\n", + " 'loudness': -8.478,\n", + " 'tempo': 123.755,\n", + " 'track_name': 'Is This The World We Created? (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 227.36934,\n", + " 'key': 2,\n", + " 'loudness': -5.906,\n", + " 'tempo': 123.966,\n", + " 'track_name': 'Under Pressure',\n", + " 'year': 1986},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 179.9571,\n", + " 'key': 10,\n", + " 'loudness': -6.269,\n", + " 'tempo': 120.693,\n", + " 'track_name': 'Killer Queen (2009 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 204.14649,\n", + " 'key': 4,\n", + " 'loudness': -4.291,\n", + " 'tempo': 93.786,\n", + " 'track_name': 'Tutti Frutti (Live)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 205.73995,\n", + " 'key': 2,\n", + " 'loudness': -4.758,\n", + " 'tempo': 103.898,\n", + " 'track_name': 'Sheer Heart Attack',\n", + " 'year': 1977},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 225.74975,\n", + " 'key': 11,\n", + " 'loudness': -14.94,\n", + " 'tempo': 122.329,\n", + " 'track_name': 'Hang On In There',\n", + " 'year': 1989},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 134.71302,\n", + " 'key': 1,\n", + " 'loudness': -19.959,\n", + " 'tempo': 80.784,\n", + " 'track_name': 'Is This The World We Created? (1994 Digital Remaster)',\n", + " 'year': 1984},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 373.62893,\n", + " 'key': 0,\n", + " 'loudness': -14.601,\n", + " 'tempo': 152.444,\n", + " 'track_name': 'Father To Son (1994 Digital Remaster)',\n", + " 'year': 1974},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 292.44036,\n", + " 'key': 2,\n", + " 'loudness': -5.021,\n", + " 'tempo': 86.322,\n", + " 'track_name': 'Action This Day',\n", + " 'year': 1982},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 88.73751,\n", + " 'key': 9,\n", + " 'loudness': -13.621,\n", + " 'tempo': 183.511,\n", + " 'track_name': 'Football Fight (1994 Digital Remaster)',\n", + " 'year': 1980},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 141.92281,\n", + " 'key': 0,\n", + " 'loudness': -12.546,\n", + " 'tempo': 76.129,\n", + " 'track_name': 'Imagine (Live In Frankfurt Bootleg)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 181.49832,\n", + " 'key': 10,\n", + " 'loudness': -10.605,\n", + " 'tempo': 166.493,\n", + " 'track_name': 'Bicycle Race (2008 Digital Remaster)',\n", + " 'year': 0},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 390.922,\n", + " 'key': 1,\n", + " 'loudness': -16.323,\n", + " 'tempo': 144.715,\n", + " 'track_name': 'Innuendo',\n", + " 'year': 1991},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 212.11383,\n", + " 'key': 4,\n", + " 'loudness': -10.729,\n", + " 'tempo': 80.739,\n", + " 'track_name': 'Life Is Real (Song For Lennon) (1994 Digital Remaster)',\n", + " 'year': 1982},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 139.17995,\n", + " 'key': 4,\n", + " 'loudness': -19.173,\n", + " 'tempo': 260.231,\n", + " 'track_name': 'Who Wants To Live Forever (With Commentary)',\n", + " 'year': 2009},\n", + " {'artist_name': 'Queen',\n", + " 'duration': 278.30812,\n", + " 'key': 2,\n", + " 'loudness': -6.678,\n", + " 'tempo': 143.874,\n", + " 'track_name': 'Headlong',\n", + " 'year': 1991}]" + ] + }, + "execution_count": 11, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "[t for t in data if t['artist_name'] == 'Queen']" + ] + }, + { + "cell_type": "code", + "execution_count": null, + "metadata": { + "collapsed": true + }, + "outputs": [], + "source": [] + } + ], + "metadata": { + "kernelspec": { + "display_name": "Python 3", + "language": "python", + "name": "python3" + }, + "language_info": { + "codemirror_mode": { + "name": "ipython", + "version": 3 + }, + "file_extension": ".py", + "mimetype": "text/x-python", + "name": "python", + "nbconvert_exporter": "python", + "pygments_lexer": "ipython3", + "version": "3.5.2+" + } + }, + "nbformat": 4, + "nbformat_minor": 2 +} diff --git a/beatles-vs-stones-gather-data.ipynb b/beatles-vs-stones-gather-data.ipynb index a902935..05b77a0 100644 --- a/beatles-vs-stones-gather-data.ipynb +++ b/beatles-vs-stones-gather-data.ipynb @@ -12,9 +12,15 @@ "\n", "I'm also on a bit of a Beatles jag, so I've also done the analysis for Beatles songs.\n", "\n", - "http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0115255#s5\n", - "https://www.discogs.com/developers/#page:database,header:database-artist-releases\n", - "http://data.discogs.com/\n", + "### Some data sources\n", + "\n", + "* http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0115255#s5\n", + "* https://www.discogs.com/developers/#page:database,header:database-artist-releases\n", + "* http://data.discogs.com/\n", + "\n", + "* https://labrosa.ee.columbia.edu/millionsong/\n", + "\n", + "* https://twitter.com/kcimc/status/893855561590157312?s=09 and https://drive.google.com/file/d/0B9tyIRZ76JCdN3NtaVpPU3c4QWs/view (stored locally in the [1m.pkl](1m.pkl) folder)\n", "\n", "\n", "## Contents\n", @@ -98,9 +104,7 @@ { "cell_type": "code", "execution_count": 3, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "# try:\n", @@ -112,9 +116,7 @@ { "cell_type": "code", "execution_count": 4, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "# Create a database and a collections within it.\n", @@ -136,9 +138,7 @@ { "cell_type": "code", "execution_count": 5, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -188,9 +188,7 @@ { "cell_type": "code", "execution_count": 6, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def get_artists(artist_name):\n", @@ -211,9 +209,7 @@ { "cell_type": "code", "execution_count": 7, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -238,9 +234,7 @@ { "cell_type": "code", "execution_count": 8, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -272,9 +266,7 @@ { "cell_type": "code", "execution_count": 9, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def get_albums(artist_id):\n", @@ -292,9 +284,7 @@ { "cell_type": "code", "execution_count": 41, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -315,9 +305,7 @@ { "cell_type": "code", "execution_count": 13, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -338,9 +326,7 @@ { "cell_type": "code", "execution_count": 13, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -658,7 +644,6 @@ "cell_type": "code", "execution_count": 11, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -1091,9 +1076,7 @@ { "cell_type": "code", "execution_count": 16, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def get_tracks(album_id):\n", @@ -1117,7 +1100,6 @@ "cell_type": "code", "execution_count": 45, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -1151,7 +1133,6 @@ "cell_type": "code", "execution_count": 17, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -1185,7 +1166,6 @@ "cell_type": "code", "execution_count": 18, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -1766,9 +1746,7 @@ { "cell_type": "code", "execution_count": 49, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -1830,9 +1808,7 @@ { "cell_type": "code", "execution_count": 15, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -1865,7 +1841,6 @@ "cell_type": "code", "execution_count": 16, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -2601,9 +2576,7 @@ { "cell_type": "code", "execution_count": 30, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "a_type, a_token = get_spotify_auth_token()\n", @@ -2616,7 +2589,6 @@ "cell_type": "code", "execution_count": 37, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -4562,7 +4534,6 @@ "cell_type": "code", "execution_count": 33, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -6199,9 +6170,7 @@ { "cell_type": "code", "execution_count": 38, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6231,9 +6200,7 @@ { "cell_type": "code", "execution_count": 35, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6263,9 +6230,7 @@ { "cell_type": "code", "execution_count": 31, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6299,9 +6264,7 @@ { "cell_type": "code", "execution_count": 39, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def genius_artist_search(artist_name, per_page=20):\n", @@ -6322,9 +6285,7 @@ { "cell_type": "code", "execution_count": 40, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6346,9 +6307,7 @@ { "cell_type": "code", "execution_count": 41, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6377,9 +6336,7 @@ { "cell_type": "code", "execution_count": 42, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def genius_song_search(artist_id):\n", @@ -6406,9 +6363,7 @@ { "cell_type": "code", "execution_count": 43, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6429,9 +6384,7 @@ { "cell_type": "code", "execution_count": 44, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6452,9 +6405,7 @@ { "cell_type": "code", "execution_count": 45, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -6496,7 +6447,6 @@ "cell_type": "code", "execution_count": 46, "metadata": { - "collapsed": false, "scrolled": false }, "outputs": [ @@ -7415,9 +7365,7 @@ { "cell_type": "code", "execution_count": 47, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "def genius_lyrics(song_url):\n", @@ -7437,9 +7385,7 @@ { "cell_type": "code", "execution_count": 48, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -7461,9 +7407,7 @@ { "cell_type": "code", "execution_count": 49, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -7491,9 +7435,7 @@ { "cell_type": "code", "execution_count": 50, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -7514,7 +7456,6 @@ "cell_type": "code", "execution_count": 51, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -7570,9 +7511,7 @@ { "cell_type": "code", "execution_count": 53, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -7620,9 +7559,7 @@ { "cell_type": "code", "execution_count": 55, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -7646,7 +7583,6 @@ "cell_type": "code", "execution_count": 56, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -7724,9 +7660,7 @@ { "cell_type": "code", "execution_count": 57, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8304,9 +8238,7 @@ { "cell_type": "code", "execution_count": 58, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8326,9 +8258,7 @@ { "cell_type": "code", "execution_count": 59, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8357,9 +8287,7 @@ { "cell_type": "code", "execution_count": 52, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8390,9 +8318,7 @@ { "cell_type": "code", "execution_count": 79, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8425,9 +8351,7 @@ { "cell_type": "code", "execution_count": 80, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "for t in tracks.find({}, ['ctitle', 'duration_ms']):\n", @@ -8453,7 +8377,6 @@ "cell_type": "code", "execution_count": 81, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [], @@ -8474,9 +8397,7 @@ { "cell_type": "code", "execution_count": 82, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8496,9 +8417,7 @@ { "cell_type": "code", "execution_count": 83, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8710,9 +8629,7 @@ { "cell_type": "code", "execution_count": 84, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -8940,9 +8857,7 @@ { "cell_type": "code", "execution_count": 85, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9080,9 +8995,7 @@ { "cell_type": "code", "execution_count": 86, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9112,9 +9025,7 @@ { "cell_type": "code", "execution_count": 88, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9151,9 +9062,7 @@ { "cell_type": "code", "execution_count": 89, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9195,7 +9104,6 @@ "cell_type": "code", "execution_count": 90, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -9383,7 +9291,6 @@ "cell_type": "code", "execution_count": 91, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -9567,9 +9474,7 @@ { "cell_type": "code", "execution_count": 92, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9600,9 +9505,7 @@ { "cell_type": "code", "execution_count": 93, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9633,9 +9536,7 @@ { "cell_type": "code", "execution_count": 95, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9676,9 +9577,7 @@ { "cell_type": "code", "execution_count": 97, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -9859,9 +9758,7 @@ { "cell_type": "code", "execution_count": 471, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -10060,9 +9957,7 @@ { "cell_type": "code", "execution_count": 98, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -10250,7 +10145,6 @@ "cell_type": "code", "execution_count": 99, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -10451,9 +10345,7 @@ { "cell_type": "code", "execution_count": 100, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -10647,9 +10539,7 @@ { "cell_type": "code", "execution_count": 101, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -10841,9 +10731,7 @@ { "cell_type": "code", "execution_count": 102, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -10943,9 +10831,7 @@ { "cell_type": "code", "execution_count": 103, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -11139,9 +11025,7 @@ { "cell_type": "code", "execution_count": 104, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -11326,9 +11210,7 @@ { "cell_type": "code", "execution_count": 105, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -11358,7 +11240,6 @@ "cell_type": "code", "execution_count": 106, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -11890,9 +11771,7 @@ { "cell_type": "code", "execution_count": 107, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12098,9 +11977,7 @@ { "cell_type": "code", "execution_count": 108, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12303,9 +12180,7 @@ { "cell_type": "code", "execution_count": 109, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12337,7 +12212,6 @@ "cell_type": "code", "execution_count": 110, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [], @@ -12363,7 +12237,6 @@ "cell_type": "code", "execution_count": 111, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -12416,7 +12289,6 @@ "cell_type": "code", "execution_count": 112, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -12749,9 +12621,7 @@ { "cell_type": "code", "execution_count": 113, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12782,9 +12652,7 @@ { "cell_type": "code", "execution_count": 114, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12955,9 +12823,7 @@ { "cell_type": "code", "execution_count": 115, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -12986,9 +12852,7 @@ { "cell_type": "code", "execution_count": 116, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13139,9 +13003,7 @@ { "cell_type": "code", "execution_count": 117, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13180,7 +13042,6 @@ "cell_type": "code", "execution_count": 118, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -13233,7 +13094,6 @@ "cell_type": "code", "execution_count": 119, "metadata": { - "collapsed": false, "scrolled": true }, "outputs": [ @@ -13334,9 +13194,7 @@ { "cell_type": "code", "execution_count": 120, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13365,9 +13223,7 @@ { "cell_type": "code", "execution_count": 121, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13405,9 +13261,7 @@ { "cell_type": "code", "execution_count": 122, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [], "source": [ "pipeline = [\n", @@ -13422,9 +13276,7 @@ { "cell_type": "code", "execution_count": 123, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13455,9 +13307,7 @@ { "cell_type": "code", "execution_count": 124, - "metadata": { - "collapsed": false - }, + "metadata": {}, "outputs": [ { "data": { @@ -13543,5 +13393,5 @@ } }, "nbformat": 4, - "nbformat_minor": 0 + "nbformat_minor": 1 } -- 2.34.1