{ "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 }