1m.pkl.million-song-pickle.ipynb

   1 {
   2  "cells": [
   3   {
   4    "cell_type": "code",
   5    "execution_count": 1,
   6    "metadata": {
   7     "collapsed": true
   8    },
   9    "outputs": [],
  10    "source": [
  11     "import pickle\n",
  12     "import gzip\n",
  13     "import numpy\n",
  14     "import collections"
  15    ]
  16   },
  17   {
  18    "cell_type": "code",
  19    "execution_count": 4,
  20    "metadata": {
  21     "collapsed": true
  22    },
  23    "outputs": [],
  24    "source": [
  25     "# data = pickle.load(open('1m.pkl/1m.pkl', 'rb'), encoding='latin1')"
  26    ]
  27   },
  28   {
  29    "cell_type": "code",
  30    "execution_count": 2,
  31    "metadata": {
  32     "collapsed": true
  33    },
  34    "outputs": [],
  35    "source": [
  36     "data = pickle.load(gzip.open('1m.pkl.gz', 'rb'), encoding='latin1')"
  37    ]
  38   },
  39   {
  40    "cell_type": "code",
  41    "execution_count": 3,
  42    "metadata": {},
  43    "outputs": [
  44     {
  45      "data": {
  46       "text/plain": [
  47        "{'artist_name': 'Baka Beyond',\n",
  48        " 'duration': 368.14322,\n",
  49        " 'key': 9,\n",
  50        " 'loudness': -11.482,\n",
  51        " 'tempo': 139.092,\n",
  52        " 'track_name': 'Journey (Album Version)',\n",
  53        " 'year': 1995}"
  54       ]
  55      },
  56      "execution_count": 3,
  57      "metadata": {},
  58      "output_type": "execute_result"
  59     }
  60    ],
  61    "source": [
  62     "data[0]"
  63    ]
  64   },
  65   {
  66    "cell_type": "code",
  67    "execution_count": 4,
  68    "metadata": {},
  69    "outputs": [
  70     {
  71      "data": {
  72       "text/plain": [
  73        "1000000"
  74       ]
  75      },
  76      "execution_count": 4,
  77      "metadata": {},
  78      "output_type": "execute_result"
  79     }
  80    ],
  81    "source": [
  82     "len(data)"
  83    ]
  84   },
  85   {
  86    "cell_type": "code",
  87    "execution_count": 5,
  88    "metadata": {},
  89    "outputs": [
  90     {
  91      "data": {
  92       "text/plain": [
  93        "72665"
  94       ]
  95      },
  96      "execution_count": 5,
  97      "metadata": {},
  98      "output_type": "execute_result"
  99     }
 100    ],
 101    "source": [
 102     "len(set(t['artist_name'] for t in data))"
 103    ]
 104   },
 105   {
 106    "cell_type": "code",
 107    "execution_count": 6,
 108    "metadata": {},
 109    "outputs": [
 110     {
 111      "data": {
 112       "text/plain": [
 113        "[('Michael Jackson', 194),\n",
 114        " ('Johnny Cash', 193),\n",
 115        " ('Beastie Boys', 187),\n",
 116        " ('Joan Baez', 181),\n",
 117        " ('Neil Diamond', 176)]"
 118       ]
 119      },
 120      "execution_count": 6,
 121      "metadata": {},
 122      "output_type": "execute_result"
 123     }
 124    ],
 125    "source": [
 126     "artist_counts = collections.Counter(t['artist_name'] for t in data)\n",
 127     "artist_counts.most_common(5)"
 128    ]
 129   },
 130   {
 131    "cell_type": "code",
 132    "execution_count": 7,
 133    "metadata": {},
 134    "outputs": [
 135     {
 136      "data": {
 137       "text/plain": [
 138        "58"
 139       ]
 140      },
 141      "execution_count": 7,
 142      "metadata": {},
 143      "output_type": "execute_result"
 144     }
 145    ],
 146    "source": [
 147     "artist_counts['The Beatles']"
 148    ]
 149   },
 150   {
 151    "cell_type": "code",
 152    "execution_count": 8,
 153    "metadata": {},
 154    "outputs": [
 155     {
 156      "data": {
 157       "text/plain": [
 158        "95"
 159       ]
 160      },
 161      "execution_count": 8,
 162      "metadata": {},
 163      "output_type": "execute_result"
 164     }
 165    ],
 166    "source": [
 167     "artist_counts['Queen']"
 168    ]
 169   },
 170   {
 171    "cell_type": "code",
 172    "execution_count": 9,
 173    "metadata": {},
 174    "outputs": [
 175     {
 176      "data": {
 177       "text/plain": [
 178        "171"
 179       ]
 180      },
 181      "execution_count": 9,
 182      "metadata": {},
 183      "output_type": "execute_result"
 184     }
 185    ],
 186    "source": [
 187     "artist_counts['The Rolling Stones']"
 188    ]
 189   },
 190   {
 191    "cell_type": "code",
 192    "execution_count": 10,
 193    "metadata": {},
 194    "outputs": [
 195     {
 196      "data": {
 197       "text/plain": [
 198        "[{'artist_name': 'The Beatles',\n",
 199        "  'duration': 267.10159,\n",
 200        "  'key': 2,\n",
 201        "  'loudness': -57.871,\n",
 202        "  'tempo': 181.989,\n",
 203        "  'track_name': 'Larry Kane Interviews Derek Taylor',\n",
 204        "  'year': 0},\n",
 205        " {'artist_name': 'The Beatles',\n",
 206        "  'duration': 263.88853,\n",
 207        "  'key': 1,\n",
 208        "  'loudness': -24.558,\n",
 209        "  'tempo': 75.276,\n",
 210        "  'track_name': 'Post Beatles Interview With George Harrison (c. 1976)',\n",
 211        "  'year': 0},\n",
 212        " {'artist_name': 'The Beatles',\n",
 213        "  'duration': 179.51302,\n",
 214        "  'key': 5,\n",
 215        "  'loudness': -22.808,\n",
 216        "  'tempo': 111.16,\n",
 217        "  'track_name': 'John and George To Allan Lappin in Melbourne',\n",
 218        "  'year': 0},\n",
 219        " {'artist_name': 'The Beatles',\n",
 220        "  'duration': 33.17506,\n",
 221        "  'key': 11,\n",
 222        "  'loudness': -21.798,\n",
 223        "  'tempo': 215.977,\n",
 224        "  'track_name': 'John Lennon on Yoko',\n",
 225        "  'year': 0},\n",
 226        " {'artist_name': 'The Beatles',\n",
 227        "  'duration': 117.62893,\n",
 228        "  'key': 2,\n",
 229        "  'loudness': -21.31,\n",
 230        "  'tempo': 126.445,\n",
 231        "  'track_name': 'Melody Maker Award Presentation En Route To The East Coast On 27th August 1964',\n",
 232        "  'year': 0},\n",
 233        " {'artist_name': 'The Beatles',\n",
 234        "  'duration': 95.97342,\n",
 235        "  'key': 10,\n",
 236        "  'loudness': -20.954,\n",
 237        "  'tempo': 85.521,\n",
 238        "  'track_name': 'Italian TV Interview June 1965',\n",
 239        "  'year': 0},\n",
 240        " {'artist_name': 'The Beatles',\n",
 241        "  'duration': 160.15628,\n",
 242        "  'key': 6,\n",
 243        "  'loudness': -51.503,\n",
 244        "  'tempo': 43.09,\n",
 245        "  'track_name': 'Derek Taylor With The Beatles Hairdresser',\n",
 246        "  'year': 0},\n",
 247        " {'artist_name': 'The Beatles',\n",
 248        "  'duration': 596.6624,\n",
 249        "  'key': 9,\n",
 250        "  'loudness': -51.621,\n",
 251        "  'tempo': 169.864,\n",
 252        "  'track_name': 'Derek Taylor With George Harrison',\n",
 253        "  'year': 0},\n",
 254        " {'artist_name': 'The Beatles',\n",
 255        "  'duration': 196.12689,\n",
 256        "  'key': 5,\n",
 257        "  'loudness': -18.536,\n",
 258        "  'tempo': 107.754,\n",
 259        "  'track_name': 'John_ Paul_ George and Jimmy Nicol To DJ Bob Rogers on Route To Adelaide',\n",
 260        "  'year': 0},\n",
 261        " {'artist_name': 'The Beatles',\n",
 262        "  'duration': 331.02322,\n",
 263        "  'key': 8,\n",
 264        "  'loudness': -19.745,\n",
 265        "  'tempo': 74.333,\n",
 266        "  'track_name': 'The Beatles To Bob Rogers At St. George Hotel_ Wellington_ New Zealand',\n",
 267        "  'year': 0},\n",
 268        " {'artist_name': 'The Beatles',\n",
 269        "  'duration': 25.18159,\n",
 270        "  'key': 1,\n",
 271        "  'loudness': -23.683,\n",
 272        "  'tempo': 85.482,\n",
 273        "  'track_name': 'George Telephone Conversation To DJ Barry Ferber',\n",
 274        "  'year': 0},\n",
 275        " {'artist_name': 'The Beatles',\n",
 276        "  'duration': 259.70893,\n",
 277        "  'key': 11,\n",
 278        "  'loudness': -18.095,\n",
 279        "  'tempo': 221.12,\n",
 280        "  'track_name': 'Press Conference in Minneapolis August 1965',\n",
 281        "  'year': 0},\n",
 282        " {'artist_name': 'The Beatles',\n",
 283        "  'duration': 52.03546,\n",
 284        "  'key': 1,\n",
 285        "  'loudness': -23.042,\n",
 286        "  'tempo': 53.874,\n",
 287        "  'track_name': 'Ringo To DJ Mike Walsh',\n",
 288        "  'year': 0},\n",
 289        " {'artist_name': 'The Beatles',\n",
 290        "  'duration': 209.71057,\n",
 291        "  'key': 3,\n",
 292        "  'loudness': -17.987,\n",
 293        "  'tempo': 74.803,\n",
 294        "  'track_name': \"Ringo's Arrival in Sydney To Garvin Rutherford\",\n",
 295        "  'year': 0},\n",
 296        " {'artist_name': 'The Beatles',\n",
 297        "  'duration': 153.93914,\n",
 298        "  'key': 11,\n",
 299        "  'loudness': -27.675,\n",
 300        "  'tempo': 75.756,\n",
 301        "  'track_name': 'Ringo Starr Gives His Reactions To New York And The Fans On 29th August 1964',\n",
 302        "  'year': 0},\n",
 303        " {'artist_name': 'The Beatles',\n",
 304        "  'duration': 435.48689,\n",
 305        "  'key': 6,\n",
 306        "  'loudness': -50.714,\n",
 307        "  'tempo': 56.613,\n",
 308        "  'track_name': 'Derek Taylor - With Ringo Starr',\n",
 309        "  'year': 0},\n",
 310        " {'artist_name': 'The Beatles',\n",
 311        "  'duration': 66.0371,\n",
 312        "  'key': 7,\n",
 313        "  'loudness': -15.485,\n",
 314        "  'tempo': 81.801,\n",
 315        "  'track_name': 'The Beatles in Melbourne',\n",
 316        "  'year': 0},\n",
 317        " {'artist_name': 'The Beatles',\n",
 318        "  'duration': 373.10649,\n",
 319        "  'key': 2,\n",
 320        "  'loudness': -31.538,\n",
 321        "  'tempo': 114.095,\n",
 322        "  'track_name': 'Manager Brian Epstein Gives A Rare Interview On 28th August 1964',\n",
 323        "  'year': 0},\n",
 324        " {'artist_name': 'The Beatles',\n",
 325        "  'duration': 240.95302,\n",
 326        "  'key': 8,\n",
 327        "  'loudness': -19.91,\n",
 328        "  'tempo': 215.253,\n",
 329        "  'track_name': 'John_ Paul_ George and Jimmy Nicol Arrival in Sydney',\n",
 330        "  'year': 0},\n",
 331        " {'artist_name': 'The Beatles',\n",
 332        "  'duration': 303.80363,\n",
 333        "  'key': 1,\n",
 334        "  'loudness': -18.414,\n",
 335        "  'tempo': 196.224,\n",
 336        "  'track_name': 'Paul Mccartney Discusses The Fans Reaction On Arrival At New York_ The Big Apple And The Forest Hill',\n",
 337        "  'year': 0},\n",
 338        " {'artist_name': 'The Beatles',\n",
 339        "  'duration': 303.41179,\n",
 340        "  'key': 1,\n",
 341        "  'loudness': -17.13,\n",
 342        "  'tempo': 123.351,\n",
 343        "  'track_name': 'Ringo Starr Gives His Views On Country And Western Music_ Sports_ Monopoly_ The Beatles And Fan Club',\n",
 344        "  'year': 0},\n",
 345        " {'artist_name': 'The Beatles',\n",
 346        "  'duration': 403.1473,\n",
 347        "  'key': 0,\n",
 348        "  'loudness': -17.741,\n",
 349        "  'tempo': 123.082,\n",
 350        "  'track_name': 'Press Officer Derek Taylor Discusses The Atlantic City Concert And The Police Protection On 1st Sept',\n",
 351        "  'year': 0},\n",
 352        " {'artist_name': 'The Beatles',\n",
 353        "  'duration': 501.91628,\n",
 354        "  'key': 5,\n",
 355        "  'loudness': -23.96,\n",
 356        "  'tempo': 197.495,\n",
 357        "  'track_name': 'Seattle Interview August 1966',\n",
 358        "  'year': 0},\n",
 359        " {'artist_name': 'The Beatles',\n",
 360        "  'duration': 125.54404,\n",
 361        "  'key': 9,\n",
 362        "  'loudness': -27.262,\n",
 363        "  'tempo': 117.996,\n",
 364        "  'track_name': 'Tokyo Interview July 1966',\n",
 365        "  'year': 0},\n",
 366        " {'artist_name': 'The Beatles',\n",
 367        "  'duration': 84.58404,\n",
 368        "  'key': 8,\n",
 369        "  'loudness': -21.393,\n",
 370        "  'tempo': 67.384,\n",
 371        "  'track_name': 'John Lennon on Religion',\n",
 372        "  'year': 0},\n",
 373        " {'artist_name': 'The Beatles',\n",
 374        "  'duration': 168.64608,\n",
 375        "  'key': 2,\n",
 376        "  'loudness': -15.198,\n",
 377        "  'tempo': 55.097,\n",
 378        "  'track_name': 'John Lennon Talks About New York And The Concert At Forest Hills On 29th August 1964',\n",
 379        "  'year': 0},\n",
 380        " {'artist_name': 'The Beatles',\n",
 381        "  'duration': 57.67791,\n",
 382        "  'key': 4,\n",
 383        "  'loudness': -21.752,\n",
 384        "  'tempo': 177.38,\n",
 385        "  'track_name': \"Paul McCartney's Birthday on 2SM Radio_ Sydney\",\n",
 386        "  'year': 0},\n",
 387        " {'artist_name': 'The Beatles',\n",
 388        "  'duration': 24.08444,\n",
 389        "  'key': 11,\n",
 390        "  'loudness': -19.717,\n",
 391        "  'tempo': 100.013,\n",
 392        "  'track_name': 'John Lennon on Exams',\n",
 393        "  'year': 0},\n",
 394        " {'artist_name': 'The Beatles',\n",
 395        "  'duration': 230.50404,\n",
 396        "  'key': 2,\n",
 397        "  'loudness': -25.958,\n",
 398        "  'tempo': 111.458,\n",
 399        "  'track_name': 'George_ John_ Ringo and Fans in Auckland To Bob Rogers',\n",
 400        "  'year': 0},\n",
 401        " {'artist_name': 'The Beatles',\n",
 402        "  'duration': 130.45506,\n",
 403        "  'key': 1,\n",
 404        "  'loudness': -16.694,\n",
 405        "  'tempo': 109.879,\n",
 406        "  'track_name': 'Road Manager Neil Aspinall Talks About The Escape From Fans Following The Concert In Atlantic City O',\n",
 407        "  'year': 0},\n",
 408        " {'artist_name': 'The Beatles',\n",
 409        "  'duration': 183.69261,\n",
 410        "  'key': 1,\n",
 411        "  'loudness': -20.684,\n",
 412        "  'tempo': 101.193,\n",
 413        "  'track_name': 'Sydney Farewell With Bob Rogers_ George and John',\n",
 414        "  'year': 0},\n",
 415        " {'artist_name': 'The Beatles',\n",
 416        "  'duration': 197.22404,\n",
 417        "  'key': 1,\n",
 418        "  'loudness': -20.205,\n",
 419        "  'tempo': 110.443,\n",
 420        "  'track_name': 'John Lennon on the Rolling Stones',\n",
 421        "  'year': 0},\n",
 422        " {'artist_name': 'The Beatles',\n",
 423        "  'duration': 699.55873,\n",
 424        "  'key': 5,\n",
 425        "  'loudness': -24.965,\n",
 426        "  'tempo': 224.343,\n",
 427        "  'track_name': \"John_ Paul_ Ringo_ and George After the Lord Mayor's Reception in Auckland To Bob Rogers\",\n",
 428        "  'year': 0},\n",
 429        " {'artist_name': 'The Beatles',\n",
 430        "  'duration': 205.00853,\n",
 431        "  'key': 1,\n",
 432        "  'loudness': -21.308,\n",
 433        "  'tempo': 112.673,\n",
 434        "  'track_name': 'Inside Adelaide Hotel Room To Bob Rogers',\n",
 435        "  'year': 0},\n",
 436        " {'artist_name': 'The Beatles',\n",
 437        "  'duration': 196.44036,\n",
 438        "  'key': 1,\n",
 439        "  'loudness': -21.216,\n",
 440        "  'tempo': 83.73,\n",
 441        "  'track_name': 'George_ John_ Ringo and Paul to Bob Rogers on Arrival in New Zealand',\n",
 442        "  'year': 0},\n",
 443        " {'artist_name': 'The Beatles',\n",
 444        "  'duration': 73.66485,\n",
 445        "  'key': 8,\n",
 446        "  'loudness': -23.871,\n",
 447        "  'tempo': 91.695,\n",
 448        "  'track_name': 'Paul and John on Landing in Australia from Hong Kong To DJ John Edwards',\n",
 449        "  'year': 0},\n",
 450        " {'artist_name': 'The Beatles',\n",
 451        "  'duration': 131.63057,\n",
 452        "  'key': 1,\n",
 453        "  'loudness': -8.485,\n",
 454        "  'tempo': 159.317,\n",
 455        "  'track_name': \"Ain't She Sweet\",\n",
 456        "  'year': 1964},\n",
 457        " {'artist_name': 'The Beatles',\n",
 458        "  'duration': 53.78567,\n",
 459        "  'key': 6,\n",
 460        "  'loudness': -47.664,\n",
 461        "  'tempo': 112.361,\n",
 462        "  'track_name': 'Derek Taylor - Introduction',\n",
 463        "  'year': 0},\n",
 464        " {'artist_name': 'The Beatles',\n",
 465        "  'duration': 148.84526,\n",
 466        "  'key': 0,\n",
 467        "  'loudness': -18.393,\n",
 468        "  'tempo': 88.617,\n",
 469        "  'track_name': 'Madrid To Australian By Graham Webb July 1965',\n",
 470        "  'year': 0},\n",
 471        " {'artist_name': 'The Beatles',\n",
 472        "  'duration': 163.52608,\n",
 473        "  'key': 0,\n",
 474        "  'loudness': -21.606,\n",
 475        "  'tempo': 100.62,\n",
 476        "  'track_name': 'Messages from the Beatles After First Trip To USA in Miami_ February 1964',\n",
 477        "  'year': 0},\n",
 478        " {'artist_name': 'The Beatles',\n",
 479        "  'duration': 133.04118,\n",
 480        "  'key': 4,\n",
 481        "  'loudness': -7.119,\n",
 482        "  'tempo': 159.323,\n",
 483        "  'track_name': \"Ain't She Sweet\",\n",
 484        "  'year': 1964},\n",
 485        " {'artist_name': 'The Beatles',\n",
 486        "  'duration': 140.38159,\n",
 487        "  'key': 6,\n",
 488        "  'loudness': -22.085,\n",
 489        "  'tempo': 189.577,\n",
 490        "  'track_name': 'George Harrison Telephone Interview_ Miami February 1964',\n",
 491        "  'year': 0},\n",
 492        " {'artist_name': 'The Beatles',\n",
 493        "  'duration': 283.08853,\n",
 494        "  'key': 6,\n",
 495        "  'loudness': -27.49,\n",
 496        "  'tempo': 89.028,\n",
 497        "  'track_name': \"George Harrison Gives His Views On Press Conferences_ A Hard Day'S Night And The Usa Compared To The\",\n",
 498        "  'year': 0},\n",
 499        " {'artist_name': 'The Beatles',\n",
 500        "  'duration': 180.76689,\n",
 501        "  'key': 10,\n",
 502        "  'loudness': -23.302,\n",
 503        "  'tempo': 120.125,\n",
 504        "  'track_name': 'Paul and George To Tony McArthur in Wellington',\n",
 505        "  'year': 0},\n",
 506        " {'artist_name': 'The Beatles',\n",
 507        "  'duration': 139.38893,\n",
 508        "  'key': 11,\n",
 509        "  'loudness': -19.4,\n",
 510        "  'tempo': 74.434,\n",
 511        "  'track_name': 'George_ John and Paul About Hong Kong To DJ Bob Rogers',\n",
 512        "  'year': 0},\n",
 513        " {'artist_name': 'The Beatles',\n",
 514        "  'duration': 354.71628,\n",
 515        "  'key': 1,\n",
 516        "  'loudness': -19.857,\n",
 517        "  'tempo': 135.677,\n",
 518        "  'track_name': 'Paul Mccartney Talks About Acting_ Folk-Rock_ Miami And The Press On 29th August',\n",
 519        "  'year': 0},\n",
 520        " {'artist_name': 'The Beatles',\n",
 521        "  'duration': 209.05751,\n",
 522        "  'key': 4,\n",
 523        "  'loudness': -50.664,\n",
 524        "  'tempo': 71.725,\n",
 525        "  'track_name': 'Derek Taylor With John_ Paul_ George and Ringo',\n",
 526        "  'year': 0},\n",
 527        " {'artist_name': 'The Beatles',\n",
 528        "  'duration': 177.6322,\n",
 529        "  'key': 1,\n",
 530        "  'loudness': -19.084,\n",
 531        "  'tempo': 98.264,\n",
 532        "  'track_name': 'In Sydney With Bob Rogers',\n",
 533        "  'year': 0},\n",
 534        " {'artist_name': 'The Beatles',\n",
 535        "  'duration': 100.20526,\n",
 536        "  'key': 0,\n",
 537        "  'loudness': -19.02,\n",
 538        "  'tempo': 243.151,\n",
 539        "  'track_name': 'Concert Announcements_ from Paul in Melbourne',\n",
 540        "  'year': 0},\n",
 541        " {'artist_name': 'The Beatles',\n",
 542        "  'duration': 228.12689,\n",
 543        "  'key': 6,\n",
 544        "  'loudness': -51.235,\n",
 545        "  'tempo': 46.343,\n",
 546        "  'track_name': 'Derek Taylor With John Lennon',\n",
 547        "  'year': 0},\n",
 548        " {'artist_name': 'The Beatles',\n",
 549        "  'duration': 460.48608,\n",
 550        "  'key': 10,\n",
 551        "  'loudness': -17.625,\n",
 552        "  'tempo': 254.209,\n",
 553        "  'track_name': 'John Discusses The Effects Of Beatlemania On Family Life_ A Hard Days Night_ Touring And Concerts On',\n",
 554        "  'year': 0},\n",
 555        " {'artist_name': 'The Beatles',\n",
 556        "  'duration': 134.84363,\n",
 557        "  'key': 9,\n",
 558        "  'loudness': -19.704,\n",
 559        "  'tempo': 226.528,\n",
 560        "  'track_name': 'John Lennon on \"Yesterday and Today\" Album Cover',\n",
 561        "  'year': 0},\n",
 562        " {'artist_name': 'The Beatles',\n",
 563        "  'duration': 213.28934,\n",
 564        "  'key': 10,\n",
 565        "  'loudness': -17.143,\n",
 566        "  'tempo': 129.532,\n",
 567        "  'track_name': 'George Harrison Discusses The Differences Between English And Americam Lifestyles On 9th September 1',\n",
 568        "  'year': 0},\n",
 569        " {'artist_name': 'The Beatles',\n",
 570        "  'duration': 749.66159,\n",
 571        "  'key': 9,\n",
 572        "  'loudness': -19.887,\n",
 573        "  'tempo': 70.212,\n",
 574        "  'track_name': 'Sydney Press Conference June 1964',\n",
 575        "  'year': 0},\n",
 576        " {'artist_name': 'The Beatles',\n",
 577        "  'duration': 58.04363,\n",
 578        "  'key': 3,\n",
 579        "  'loudness': -22.677,\n",
 580        "  'tempo': 85.418,\n",
 581        "  'track_name': 'John Lennon on Drugs',\n",
 582        "  'year': 0},\n",
 583        " {'artist_name': 'The Beatles',\n",
 584        "  'duration': 490.68363,\n",
 585        "  'key': 10,\n",
 586        "  'loudness': -49.7,\n",
 587        "  'tempo': 40.103,\n",
 588        "  'track_name': 'Derek Taylor With Paul McCartney',\n",
 589        "  'year': 0},\n",
 590        " {'artist_name': 'The Beatles',\n",
 591        "  'duration': 52.45342,\n",
 592        "  'key': 6,\n",
 593        "  'loudness': -22.014,\n",
 594        "  'tempo': 98.448,\n",
 595        "  'track_name': 'Post Beatles Interviews With John Lennon (c. 1971/74). JL on School.',\n",
 596        "  'year': 0},\n",
 597        " {'artist_name': 'The Beatles',\n",
 598        "  'duration': 197.17179,\n",
 599        "  'key': 7,\n",
 600        "  'loudness': -16.026,\n",
 601        "  'tempo': 106.759,\n",
 602        "  'track_name': 'Adelaide Town Hall Balcony With Bob Francis and Bob Rogers',\n",
 603        "  'year': 0}]"
 604       ]
 605      },
 606      "execution_count": 10,
 607      "metadata": {},
 608      "output_type": "execute_result"
 609     }
 610    ],
 611    "source": [
 612     "[t for t in data if t['artist_name'] == 'The Beatles']"
 613    ]
 614   },
 615   {
 616    "cell_type": "code",
 617    "execution_count": 11,
 618    "metadata": {},
 619    "outputs": [
 620     {
 621      "data": {
 622       "text/plain": [
 623        "[{'artist_name': 'Queen',\n",
 624        "  'duration': 262.19057,\n",
 625        "  'key': 2,\n",
 626        "  'loudness': -13.386,\n",
 627        "  'tempo': 77.464,\n",
 628        "  'track_name': 'Love Of My Life',\n",
 629        "  'year': 1975},\n",
 630        " {'artist_name': 'Queen',\n",
 631        "  'duration': 68.64934,\n",
 632        "  'key': 2,\n",
 633        "  'loudness': -18.707,\n",
 634        "  'tempo': 67.584,\n",
 635        "  'track_name': 'Dear Friends (1993 Digital Remaster)',\n",
 636        "  'year': 1974},\n",
 637        " {'artist_name': 'Queen',\n",
 638        "  'duration': 247.71873,\n",
 639        "  'key': 10,\n",
 640        "  'loudness': -13.475,\n",
 641        "  'tempo': 180.291,\n",
 642        "  'track_name': 'Breakthru',\n",
 643        "  'year': 1989},\n",
 644        " {'artist_name': 'Queen',\n",
 645        "  'duration': 123.16689,\n",
 646        "  'key': 11,\n",
 647        "  'loudness': -9.329,\n",
 648        "  'tempo': 81.346,\n",
 649        "  'track_name': 'We Will Rock You',\n",
 650        "  'year': 1973},\n",
 651        " {'artist_name': 'Queen',\n",
 652        "  'duration': 378.06975,\n",
 653        "  'key': 9,\n",
 654        "  'loudness': -6.268,\n",
 655        "  'tempo': 155.912,\n",
 656        "  'track_name': \"Now I'm Here\",\n",
 657        "  'year': 1974},\n",
 658        " {'artist_name': 'Queen',\n",
 659        "  'duration': 521.82159,\n",
 660        "  'key': 4,\n",
 661        "  'loudness': -10.479,\n",
 662        "  'tempo': 149.901,\n",
 663        "  'track_name': \"Now I'm Here (Live) (1994 Digital Remaster)\",\n",
 664        "  'year': 0},\n",
 665        " {'artist_name': 'Queen',\n",
 666        "  'duration': 116.08771,\n",
 667        "  'key': 9,\n",
 668        "  'loudness': -18.238,\n",
 669        "  'tempo': 171.156,\n",
 670        "  'track_name': 'Crazy Little Thing Called Love (With Commentary)',\n",
 671        "  'year': 2009},\n",
 672        " {'artist_name': 'Queen',\n",
 673        "  'duration': 170.84036,\n",
 674        "  'key': 0,\n",
 675        "  'loudness': -5.09,\n",
 676        "  'tempo': 120.082,\n",
 677        "  'track_name': \"You're My Best Friend\",\n",
 678        "  'year': 1975},\n",
 679        " {'artist_name': 'Queen',\n",
 680        "  'duration': 176.69179,\n",
 681        "  'key': 3,\n",
 682        "  'loudness': -9.607,\n",
 683        "  'tempo': 95.714,\n",
 684        "  'track_name': 'Good Old Fashioned Lover Boy (2008 Digital Remaster)',\n",
 685        "  'year': 0},\n",
 686        " {'artist_name': 'Queen',\n",
 687        "  'duration': 216.63302,\n",
 688        "  'key': 2,\n",
 689        "  'loudness': -19.615,\n",
 690        "  'tempo': 195.766,\n",
 691        "  'track_name': 'Bijou',\n",
 692        "  'year': 1991},\n",
 693        " {'artist_name': 'Queen',\n",
 694        "  'duration': 313.70404,\n",
 695        "  'key': 3,\n",
 696        "  'loudness': -13.806,\n",
 697        "  'tempo': 141.549,\n",
 698        "  'track_name': 'Bohemian Rhapsody (Live In Frankfurt Bootleg)',\n",
 699        "  'year': 0},\n",
 700        " {'artist_name': 'Queen',\n",
 701        "  'duration': 168.80281,\n",
 702        "  'key': 9,\n",
 703        "  'loudness': -6.722,\n",
 704        "  'tempo': 137.835,\n",
 705        "  'track_name': 'Need Your Loving Tonight (1994 Digital Remaster)',\n",
 706        "  'year': 1980},\n",
 707        " {'artist_name': 'Queen',\n",
 708        "  'duration': 111.72526,\n",
 709        "  'key': 4,\n",
 710        "  'loudness': -16.231,\n",
 711        "  'tempo': 98.86,\n",
 712        "  'track_name': 'The Show Must Go On (With Commentary)',\n",
 713        "  'year': 2009},\n",
 714        " {'artist_name': 'Queen',\n",
 715        "  'duration': 203.41506,\n",
 716        "  'key': 1,\n",
 717        "  'loudness': -17.797,\n",
 718        "  'tempo': 181.896,\n",
 719        "  'track_name': 'My Baby Does Me',\n",
 720        "  'year': 1989},\n",
 721        " {'artist_name': 'Queen',\n",
 722        "  'duration': 110.68036,\n",
 723        "  'key': 1,\n",
 724        "  'loudness': -5.039,\n",
 725        "  'tempo': 191.219,\n",
 726        "  'track_name': 'Hello Mary Lou (Goodbye Heart) (Live)',\n",
 727        "  'year': 0},\n",
 728        " {'artist_name': 'Queen',\n",
 729        "  'duration': 352.46975,\n",
 730        "  'key': 2,\n",
 731        "  'loudness': -15.195,\n",
 732        "  'tempo': 72.398,\n",
 733        "  'track_name': 'Teo Torriatte (Let Us Cling Together) (1993 Digital Remaster)',\n",
 734        "  'year': 1976},\n",
 735        " {'artist_name': 'Queen',\n",
 736        "  'duration': 133.92934,\n",
 737        "  'key': 7,\n",
 738        "  'loudness': -6.5,\n",
 739        "  'tempo': 120.923,\n",
 740        "  'track_name': 'Stone Cold Crazy',\n",
 741        "  'year': 1973},\n",
 742        " {'artist_name': 'Queen',\n",
 743        "  'duration': 259.00363,\n",
 744        "  'key': 0,\n",
 745        "  'loudness': -7.761,\n",
 746        "  'tempo': 88.218,\n",
 747        "  'track_name': 'Dragon Attack (1994 Digital Remaster)',\n",
 748        "  'year': 1980},\n",
 749        " {'artist_name': 'Queen',\n",
 750        "  'duration': 83.9571,\n",
 751        "  'key': 9,\n",
 752        "  'loudness': -12.052,\n",
 753        "  'tempo': 110.587,\n",
 754        "  'track_name': \"Flash's Theme Reprise (Victory Celebrations) (1994 Digital Remaster)\",\n",
 755        "  'year': 1980},\n",
 756        " {'artist_name': 'Queen',\n",
 757        "  'duration': 136.14975,\n",
 758        "  'key': 0,\n",
 759        "  'loudness': -10.266,\n",
 760        "  'tempo': 168.344,\n",
 761        "  'track_name': 'Seaside Rendezvous (1993 Digital Remaster)',\n",
 762        "  'year': 1975},\n",
 763        " {'artist_name': 'Queen',\n",
 764        "  'duration': 272.48281,\n",
 765        "  'key': 1,\n",
 766        "  'loudness': -12.685,\n",
 767        "  'tempo': 132.384,\n",
 768        "  'track_name': 'Body Language (1994 Digital Remaster)',\n",
 769        "  'year': 1982},\n",
 770        " {'artist_name': 'Queen',\n",
 771        "  'duration': 114.1024,\n",
 772        "  'key': 4,\n",
 773        "  'loudness': -10.178,\n",
 774        "  'tempo': 111.034,\n",
 775        "  'track_name': 'Flash',\n",
 776        "  'year': 1980},\n",
 777        " {'artist_name': 'Queen',\n",
 778        "  'duration': 206.49751,\n",
 779        "  'key': 7,\n",
 780        "  'loudness': -10.206,\n",
 781        "  'tempo': 104.682,\n",
 782        "  'track_name': \"'39 (Live) (1994 Digital Remaster)\",\n",
 783        "  'year': 0},\n",
 784        " {'artist_name': 'Queen',\n",
 785        "  'duration': 73.09016,\n",
 786        "  'key': 0,\n",
 787        "  'loudness': -14.905,\n",
 788        "  'tempo': 152.266,\n",
 789        "  'track_name': \"Vultan's Theme (Attack Of The Hawk Men) (1994 Digital Remaster)\",\n",
 790        "  'year': 1980},\n",
 791        " {'artist_name': 'Queen',\n",
 792        "  'duration': 354.2722,\n",
 793        "  'key': 10,\n",
 794        "  'loudness': -10.872,\n",
 795        "  'tempo': 71.568,\n",
 796        "  'track_name': 'Bohemian Rhapsody',\n",
 797        "  'year': 1975},\n",
 798        " {'artist_name': 'Queen',\n",
 799        "  'duration': 294.37342,\n",
 800        "  'key': 10,\n",
 801        "  'loudness': -13.753,\n",
 802        "  'tempo': 94.789,\n",
 803        "  'track_name': 'The Millionaire Waltz (1993 Digital Remaster)',\n",
 804        "  'year': 1976},\n",
 805        " {'artist_name': 'Queen',\n",
 806        "  'duration': 255.60771,\n",
 807        "  'key': 7,\n",
 808        "  'loudness': -6.067,\n",
 809        "  'tempo': 161.351,\n",
 810        "  'track_name': 'Crazy Little Thing Called Love (Live In Montreal)',\n",
 811        "  'year': 0},\n",
 812        " {'artist_name': 'Queen',\n",
 813        "  'duration': 109.73995,\n",
 814        "  'key': 8,\n",
 815        "  'loudness': -12.07,\n",
 816        "  'tempo': 126.34,\n",
 817        "  'track_name': 'Misfire (1993 Digital Remaster)',\n",
 818        "  'year': 1974},\n",
 819        " {'artist_name': 'Queen',\n",
 820        "  'duration': 287.7122,\n",
 821        "  'key': 7,\n",
 822        "  'loudness': -8.905,\n",
 823        "  'tempo': 91.968,\n",
 824        "  'track_name': 'Mother Love',\n",
 825        "  'year': 1995},\n",
 826        " {'artist_name': 'Queen',\n",
 827        "  'duration': 76.43383,\n",
 828        "  'key': 9,\n",
 829        "  'loudness': -13.642,\n",
 830        "  'tempo': 116.07,\n",
 831        "  'track_name': 'The Hero (Live In Frankfurt Bootleg)',\n",
 832        "  'year': 0},\n",
 833        " {'artist_name': 'Queen',\n",
 834        "  'duration': 379.55873,\n",
 835        "  'key': 9,\n",
 836        "  'loudness': -4.855,\n",
 837        "  'tempo': 147.381,\n",
 838        "  'track_name': \"Now I'm Here (Live)\",\n",
 839        "  'year': 2009},\n",
 840        " {'artist_name': 'Queen',\n",
 841        "  'duration': 385.93261,\n",
 842        "  'key': 2,\n",
 843        "  'loudness': -6.982,\n",
 844        "  'tempo': 90.895,\n",
 845        "  'track_name': \"It's Late\",\n",
 846        "  'year': 1977},\n",
 847        " {'artist_name': 'Queen',\n",
 848        "  'duration': 212.16608,\n",
 849        "  'key': 2,\n",
 850        "  'loudness': -9.37,\n",
 851        "  'tempo': 136.986,\n",
 852        "  'track_name': 'Death On Two Legs (Dedicated To....) (Live) (1994 Digital Remaster)',\n",
 853        "  'year': 0},\n",
 854        " {'artist_name': 'Queen',\n",
 855        "  'duration': 363.85914,\n",
 856        "  'key': 9,\n",
 857        "  'loudness': -4.79,\n",
 858        "  'tempo': 136.562,\n",
 859        "  'track_name': 'Hammer To Fall (Live)',\n",
 860        "  'year': 0},\n",
 861        " {'artist_name': 'Queen',\n",
 862        "  'duration': 225.17506,\n",
 863        "  'key': 2,\n",
 864        "  'loudness': -11.716,\n",
 865        "  'tempo': 134.304,\n",
 866        "  'track_name': 'In The Lap Of The Gods...Revisited (1993 Digital Remaster)',\n",
 867        "  'year': 1974},\n",
 868        " {'artist_name': 'Queen',\n",
 869        "  'duration': 331.62404,\n",
 870        "  'key': 6,\n",
 871        "  'loudness': -5.582,\n",
 872        "  'tempo': 152.226,\n",
 873        "  'track_name': \"Now I'm Here (Live In Montreal)\",\n",
 874        "  'year': 0},\n",
 875        " {'artist_name': 'Queen',\n",
 876        "  'duration': 224.96608,\n",
 877        "  'key': 9,\n",
 878        "  'loudness': -5.282,\n",
 879        "  'tempo': 76.72,\n",
 880        "  'track_name': 'Tie Your Mother Down',\n",
 881        "  'year': 1976},\n",
 882        " {'artist_name': 'Queen',\n",
 883        "  'duration': 181.08036,\n",
 884        "  'key': 10,\n",
 885        "  'loudness': -8.196,\n",
 886        "  'tempo': 94.836,\n",
 887        "  'track_name': 'We Are The Champions (2009 Digital Remaster)',\n",
 888        "  'year': 0},\n",
 889        " {'artist_name': 'Queen',\n",
 890        "  'duration': 355.7873,\n",
 891        "  'key': 0,\n",
 892        "  'loudness': -12.557,\n",
 893        "  'tempo': 72.499,\n",
 894        "  'track_name': 'Bohemian Rhapsody (2008 Digital Remaster)',\n",
 895        "  'year': 0},\n",
 896        " {'artist_name': 'Queen',\n",
 897        "  'duration': 228.44036,\n",
 898        "  'key': 2,\n",
 899        "  'loudness': -15.229,\n",
 900        "  'tempo': 121.664,\n",
 901        "  'track_name': 'Under Pressure (Live At Nepstadion)',\n",
 902        "  'year': 1986},\n",
 903        " {'artist_name': 'Queen',\n",
 904        "  'duration': 227.91791,\n",
 905        "  'key': 7,\n",
 906        "  'loudness': -8.168,\n",
 907        "  'tempo': 81.603,\n",
 908        "  'track_name': 'Save Me (2009 Digital Remaster)',\n",
 909        "  'year': 0},\n",
 910        " {'artist_name': 'Queen',\n",
 911        "  'duration': 66.37669,\n",
 912        "  'key': 9,\n",
 913        "  'loudness': -4.79,\n",
 914        "  'tempo': 154.831,\n",
 915        "  'track_name': 'Big Spender (Live)',\n",
 916        "  'year': 0},\n",
 917        " {'artist_name': 'Queen',\n",
 918        "  'duration': 78.47138,\n",
 919        "  'key': 5,\n",
 920        "  'loudness': -13.964,\n",
 921        "  'tempo': 121.926,\n",
 922        "  'track_name': 'Nevermore (1994 Digital Remaster)',\n",
 923        "  'year': 1974},\n",
 924        " {'artist_name': 'Queen',\n",
 925        "  'duration': 173.76608,\n",
 926        "  'key': 3,\n",
 927        "  'loudness': -12.068,\n",
 928        "  'tempo': 95.912,\n",
 929        "  'track_name': 'Good Old Fashioned Lover Boy (1993 Digital Remaster)',\n",
 930        "  'year': 1976},\n",
 931        " {'artist_name': 'Queen',\n",
 932        "  'duration': 297.29914,\n",
 933        "  'key': 8,\n",
 934        "  'loudness': -8.393,\n",
 935        "  'tempo': 109.753,\n",
 936        "  'track_name': 'Somebody To Love (2008 Digital Remaster)',\n",
 937        "  'year': 0},\n",
 938        " {'artist_name': 'Queen',\n",
 939        "  'duration': 384.65261,\n",
 940        "  'key': 4,\n",
 941        "  'loudness': -9.182,\n",
 942        "  'tempo': 159.334,\n",
 943        "  'track_name': 'Liar (1994 Digital Remaster)',\n",
 944        "  'year': 1973},\n",
 945        " {'artist_name': 'Queen',\n",
 946        "  'duration': 124.73424,\n",
 947        "  'key': 9,\n",
 948        "  'loudness': -13.43,\n",
 949        "  'tempo': 115.926,\n",
 950        "  'track_name': 'Marriage Of Dale And Ming (And Flash Approaching) (1994 Digital Remaster)',\n",
 951        "  'year': 1980},\n",
 952        " {'artist_name': 'Queen',\n",
 953        "  'duration': 186.14812,\n",
 954        "  'key': 4,\n",
 955        "  'loudness': -4.656,\n",
 956        "  'tempo': 180.066,\n",
 957        "  'track_name': 'We Will Rock You (Fast Version) (Live In Montreal)',\n",
 958        "  'year': 0},\n",
 959        " {'artist_name': 'Queen',\n",
 960        "  'duration': 298.26567,\n",
 961        "  'key': 7,\n",
 962        "  'loudness': -11.878,\n",
 963        "  'tempo': 119.786,\n",
 964        "  'track_name': 'White Man (1993 Digital Remaster)',\n",
 965        "  'year': 1976},\n",
 966        " {'artist_name': 'Queen',\n",
 967        "  'duration': 270.88934,\n",
 968        "  'key': 2,\n",
 969        "  'loudness': -9.656,\n",
 970        "  'tempo': 81.568,\n",
 971        "  'track_name': 'Las Palabras De Amor (The Words Of Love) (2009 Digital Remaster)',\n",
 972        "  'year': 0},\n",
 973        " {'artist_name': 'Queen',\n",
 974        "  'duration': 218.95791,\n",
 975        "  'key': 5,\n",
 976        "  'loudness': -15.136,\n",
 977        "  'tempo': 76.601,\n",
 978        "  'track_name': 'Love Of My Life (1993 Digital Remaster)',\n",
 979        "  'year': 1975},\n",
 980        " {'artist_name': 'Queen',\n",
 981        "  'duration': 253.80526,\n",
 982        "  'key': 9,\n",
 983        "  'loudness': -11.099,\n",
 984        "  'tempo': 132.488,\n",
 985        "  'track_name': \"Now I'm Here (2008 Digital Remaster)\",\n",
 986        "  'year': 0},\n",
 987        " {'artist_name': 'Queen',\n",
 988        "  'duration': 224.522,\n",
 989        "  'key': 2,\n",
 990        "  'loudness': -14.544,\n",
 991        "  'tempo': 145.206,\n",
 992        "  'track_name': 'Drowse (1993 Digital Remaster)',\n",
 993        "  'year': 1976},\n",
 994        " {'artist_name': 'Queen',\n",
 995        "  'duration': 237.40036,\n",
 996        "  'key': 0,\n",
 997        "  'loudness': -5.567,\n",
 998        "  'tempo': 248.405,\n",
 999        "  'track_name': 'Play The Game (Live In Montreal)',\n",
1000        "  'year': 0},\n",
1001        " {'artist_name': 'Queen',\n",
1002        "  'duration': 295.99302,\n",
1003        "  'key': 8,\n",
1004        "  'loudness': -11.901,\n",
1005        "  'tempo': 109.669,\n",
1006        "  'track_name': 'Somebody To Love (1993 Digital Remaster)',\n",
1007        "  'year': 1976},\n",
1008        " {'artist_name': 'Queen',\n",
1009        "  'duration': 307.85261,\n",
1010        "  'key': 0,\n",
1011        "  'loudness': -8.478,\n",
1012        "  'tempo': 111.493,\n",
1013        "  'track_name': 'Machines (Or Back To Humans) (2009 Digital Remaster)',\n",
1014        "  'year': 0},\n",
1015        " {'artist_name': 'Queen',\n",
1016        "  'duration': 175.59465,\n",
1017        "  'key': 0,\n",
1018        "  'loudness': -13.07,\n",
1019        "  'tempo': 170.908,\n",
1020        "  'track_name': 'We Will Rock You (Live In Frankfurt Bootleg)',\n",
1021        "  'year': 0},\n",
1022        " {'artist_name': 'Queen',\n",
1023        "  'duration': 222.06649,\n",
1024        "  'key': 7,\n",
1025        "  'loudness': -10.986,\n",
1026        "  'tempo': 150.93,\n",
1027        "  'track_name': 'A Human Body (2009 Digital Remaster)',\n",
1028        "  'year': 0},\n",
1029        " {'artist_name': 'Queen',\n",
1030        "  'duration': 185.20771,\n",
1031        "  'key': 4,\n",
1032        "  'loudness': -10.598,\n",
1033        "  'tempo': 143.214,\n",
1034        "  'track_name': \"I'm In Love With My Car (1993 Digital Remaster)\",\n",
1035        "  'year': 1975},\n",
1036        " {'artist_name': 'Queen',\n",
1037        "  'duration': 60.89098,\n",
1038        "  'key': 2,\n",
1039        "  'loudness': -14.096,\n",
1040        "  'tempo': 115.744,\n",
1041        "  'track_name': 'Crash Dive On Mingo City (1994 Digital Remaster)',\n",
1042        "  'year': 1980},\n",
1043        " {'artist_name': 'Queen',\n",
1044        "  'duration': 213.36771,\n",
1045        "  'key': 9,\n",
1046        "  'loudness': -11.069,\n",
1047        "  'tempo': 116.52,\n",
1048        "  'track_name': 'Long Away (1993 Digital Remaster)',\n",
1049        "  'year': 1976},\n",
1050        " {'artist_name': 'Queen',\n",
1051        "  'duration': 285.98812,\n",
1052        "  'key': 3,\n",
1053        "  'loudness': -7.002,\n",
1054        "  'tempo': 110.103,\n",
1055        "  'track_name': 'Get Down Make Love (Live In Montreal)',\n",
1056        "  'year': 0},\n",
1057        " {'artist_name': 'Queen',\n",
1058        "  'duration': 202.762,\n",
1059        "  'key': 2,\n",
1060        "  'loudness': -10.352,\n",
1061        "  'tempo': 89.171,\n",
1062        "  'track_name': 'Fat Bottomed Girls (2008 Digital Remaster)',\n",
1063        "  'year': 0},\n",
1064        " {'artist_name': 'Queen',\n",
1065        "  'duration': 67.23873,\n",
1066        "  'key': 3,\n",
1067        "  'loudness': -14.364,\n",
1068        "  'tempo': 132.818,\n",
1069        "  'track_name': 'Lazing On A Sunday Afternoon (1993 Digital Remaster)',\n",
1070        "  'year': 1975},\n",
1071        " {'artist_name': 'Queen',\n",
1072        "  'duration': 208.43057,\n",
1073        "  'key': 7,\n",
1074        "  'loudness': -10.255,\n",
1075        "  'tempo': 150.796,\n",
1076        "  'track_name': 'Man On The Prowl (1994 Digital Remaster)',\n",
1077        "  'year': 1984},\n",
1078        " {'artist_name': 'Queen',\n",
1079        "  'duration': 344.39791,\n",
1080        "  'key': 9,\n",
1081        "  'loudness': -12.427,\n",
1082        "  'tempo': 88.254,\n",
1083        "  'track_name': 'Was It All Worth It',\n",
1084        "  'year': 1989},\n",
1085        " {'artist_name': 'Queen',\n",
1086        "  'duration': 258.84689,\n",
1087        "  'key': 7,\n",
1088        "  'loudness': -8.539,\n",
1089        "  'tempo': 107.714,\n",
1090        "  'track_name': \"Thank God It's Christmas\",\n",
1091        "  'year': 1991},\n",
1092        " {'artist_name': 'Queen',\n",
1093        "  'duration': 355.02975,\n",
1094        "  'key': 10,\n",
1095        "  'loudness': -14.333,\n",
1096        "  'tempo': 72.11,\n",
1097        "  'track_name': 'Bohemian Rhapsody (1993 Digital Remaster)',\n",
1098        "  'year': 1975},\n",
1099        " {'artist_name': 'Queen',\n",
1100        "  'duration': 264.09751,\n",
1101        "  'key': 4,\n",
1102        "  'loudness': -13.56,\n",
1103        "  'tempo': 130.117,\n",
1104        "  'track_name': 'A Kind Of Magic',\n",
1105        "  'year': 1986},\n",
1106        " {'artist_name': 'Queen',\n",
1107        "  'duration': 358.94812,\n",
1108        "  'key': 4,\n",
1109        "  'loudness': -5.566,\n",
1110        "  'tempo': 115.89,\n",
1111        "  'track_name': 'Another One Bites The Dust (Live)',\n",
1112        "  'year': 0},\n",
1113        " {'artist_name': 'Queen',\n",
1114        "  'duration': 83.87873,\n",
1115        "  'key': 7,\n",
1116        "  'loudness': -6.376,\n",
1117        "  'tempo': 141.076,\n",
1118        "  'track_name': 'God Save The Queen',\n",
1119        "  'year': 1975},\n",
1120        " {'artist_name': 'Queen',\n",
1121        "  'duration': 335.77751,\n",
1122        "  'key': 0,\n",
1123        "  'loudness': -9.632,\n",
1124        "  'tempo': 110.236,\n",
1125        "  'track_name': 'Heaven For Everyone (Album Version)',\n",
1126        "  'year': 1995},\n",
1127        " {'artist_name': 'Queen',\n",
1128        "  'duration': 473.23383,\n",
1129        "  'key': 8,\n",
1130        "  'loudness': -6.163,\n",
1131        "  'tempo': 119.702,\n",
1132        "  'track_name': 'Somebody To Love',\n",
1133        "  'year': 1976},\n",
1134        " {'artist_name': 'Queen',\n",
1135        "  'duration': 189.59628,\n",
1136        "  'key': 5,\n",
1137        "  'loudness': -14.154,\n",
1138        "  'tempo': 79.734,\n",
1139        "  'track_name': 'All Dead All Dead (1993 Digital Remaster)',\n",
1140        "  'year': 1977},\n",
1141        " {'artist_name': 'Queen',\n",
1142        "  'duration': 245.9424,\n",
1143        "  'key': 7,\n",
1144        "  'loudness': -3.678,\n",
1145        "  'tempo': 147.047,\n",
1146        "  'track_name': 'Tie Your Mother Down (Live)',\n",
1147        "  'year': 2004},\n",
1148        " {'artist_name': 'Queen',\n",
1149        "  'duration': 210.46812,\n",
1150        "  'key': 2,\n",
1151        "  'loudness': -10.369,\n",
1152        "  'tempo': 117.933,\n",
1153        "  'track_name': 'The Hero (1994 Digital Remaster)',\n",
1154        "  'year': 1980},\n",
1155        " {'artist_name': 'Queen',\n",
1156        "  'duration': 252.682,\n",
1157        "  'key': 8,\n",
1158        "  'loudness': -7.533,\n",
1159        "  'tempo': 60.782,\n",
1160        "  'track_name': 'No One But You (Only The Good Die Young)',\n",
1161        "  'year': 1997},\n",
1162        " {'artist_name': 'Queen',\n",
1163        "  'duration': 78.75873,\n",
1164        "  'key': 0,\n",
1165        "  'loudness': -15.896,\n",
1166        "  'tempo': 111.159,\n",
1167        "  'track_name': 'Heaven For Everyone (With Commentary)',\n",
1168        "  'year': 2009},\n",
1169        " {'artist_name': 'Queen',\n",
1170        "  'duration': 172.59057,\n",
1171        "  'key': 0,\n",
1172        "  'loudness': -5.079,\n",
1173        "  'tempo': 120.179,\n",
1174        "  'track_name': \"You're My Best Friend\",\n",
1175        "  'year': 1975},\n",
1176        " {'artist_name': 'Queen',\n",
1177        "  'duration': 178.41587,\n",
1178        "  'key': 1,\n",
1179        "  'loudness': -8.478,\n",
1180        "  'tempo': 123.755,\n",
1181        "  'track_name': 'Is This The World We Created? (Live)',\n",
1182        "  'year': 0},\n",
1183        " {'artist_name': 'Queen',\n",
1184        "  'duration': 227.36934,\n",
1185        "  'key': 2,\n",
1186        "  'loudness': -5.906,\n",
1187        "  'tempo': 123.966,\n",
1188        "  'track_name': 'Under Pressure',\n",
1189        "  'year': 1986},\n",
1190        " {'artist_name': 'Queen',\n",
1191        "  'duration': 179.9571,\n",
1192        "  'key': 10,\n",
1193        "  'loudness': -6.269,\n",
1194        "  'tempo': 120.693,\n",
1195        "  'track_name': 'Killer Queen (2009 Digital Remaster)',\n",
1196        "  'year': 0},\n",
1197        " {'artist_name': 'Queen',\n",
1198        "  'duration': 204.14649,\n",
1199        "  'key': 4,\n",
1200        "  'loudness': -4.291,\n",
1201        "  'tempo': 93.786,\n",
1202        "  'track_name': 'Tutti Frutti (Live)',\n",
1203        "  'year': 0},\n",
1204        " {'artist_name': 'Queen',\n",
1205        "  'duration': 205.73995,\n",
1206        "  'key': 2,\n",
1207        "  'loudness': -4.758,\n",
1208        "  'tempo': 103.898,\n",
1209        "  'track_name': 'Sheer Heart Attack',\n",
1210        "  'year': 1977},\n",
1211        " {'artist_name': 'Queen',\n",
1212        "  'duration': 225.74975,\n",
1213        "  'key': 11,\n",
1214        "  'loudness': -14.94,\n",
1215        "  'tempo': 122.329,\n",
1216        "  'track_name': 'Hang On In There',\n",
1217        "  'year': 1989},\n",
1218        " {'artist_name': 'Queen',\n",
1219        "  'duration': 134.71302,\n",
1220        "  'key': 1,\n",
1221        "  'loudness': -19.959,\n",
1222        "  'tempo': 80.784,\n",
1223        "  'track_name': 'Is This The World We Created? (1994 Digital Remaster)',\n",
1224        "  'year': 1984},\n",
1225        " {'artist_name': 'Queen',\n",
1226        "  'duration': 373.62893,\n",
1227        "  'key': 0,\n",
1228        "  'loudness': -14.601,\n",
1229        "  'tempo': 152.444,\n",
1230        "  'track_name': 'Father To Son (1994 Digital Remaster)',\n",
1231        "  'year': 1974},\n",
1232        " {'artist_name': 'Queen',\n",
1233        "  'duration': 292.44036,\n",
1234        "  'key': 2,\n",
1235        "  'loudness': -5.021,\n",
1236        "  'tempo': 86.322,\n",
1237        "  'track_name': 'Action This Day',\n",
1238        "  'year': 1982},\n",
1239        " {'artist_name': 'Queen',\n",
1240        "  'duration': 88.73751,\n",
1241        "  'key': 9,\n",
1242        "  'loudness': -13.621,\n",
1243        "  'tempo': 183.511,\n",
1244        "  'track_name': 'Football Fight (1994 Digital Remaster)',\n",
1245        "  'year': 1980},\n",
1246        " {'artist_name': 'Queen',\n",
1247        "  'duration': 141.92281,\n",
1248        "  'key': 0,\n",
1249        "  'loudness': -12.546,\n",
1250        "  'tempo': 76.129,\n",
1251        "  'track_name': 'Imagine (Live In Frankfurt Bootleg)',\n",
1252        "  'year': 0},\n",
1253        " {'artist_name': 'Queen',\n",
1254        "  'duration': 181.49832,\n",
1255        "  'key': 10,\n",
1256        "  'loudness': -10.605,\n",
1257        "  'tempo': 166.493,\n",
1258        "  'track_name': 'Bicycle Race (2008 Digital Remaster)',\n",
1259        "  'year': 0},\n",
1260        " {'artist_name': 'Queen',\n",
1261        "  'duration': 390.922,\n",
1262        "  'key': 1,\n",
1263        "  'loudness': -16.323,\n",
1264        "  'tempo': 144.715,\n",
1265        "  'track_name': 'Innuendo',\n",
1266        "  'year': 1991},\n",
1267        " {'artist_name': 'Queen',\n",
1268        "  'duration': 212.11383,\n",
1269        "  'key': 4,\n",
1270        "  'loudness': -10.729,\n",
1271        "  'tempo': 80.739,\n",
1272        "  'track_name': 'Life Is Real (Song For Lennon) (1994 Digital Remaster)',\n",
1273        "  'year': 1982},\n",
1274        " {'artist_name': 'Queen',\n",
1275        "  'duration': 139.17995,\n",
1276        "  'key': 4,\n",
1277        "  'loudness': -19.173,\n",
1278        "  'tempo': 260.231,\n",
1279        "  'track_name': 'Who Wants To Live Forever (With Commentary)',\n",
1280        "  'year': 2009},\n",
1281        " {'artist_name': 'Queen',\n",
1282        "  'duration': 278.30812,\n",
1283        "  'key': 2,\n",
1284        "  'loudness': -6.678,\n",
1285        "  'tempo': 143.874,\n",
1286        "  'track_name': 'Headlong',\n",
1287        "  'year': 1991}]"
1288       ]
1289      },
1290      "execution_count": 11,
1291      "metadata": {},
1292      "output_type": "execute_result"
1293     }
1294    ],
1295    "source": [
1296     "[t for t in data if t['artist_name'] == 'Queen']"
1297    ]
1298   },
1299   {
1300    "cell_type": "code",
1301    "execution_count": null,
1302    "metadata": {
1303     "collapsed": true
1304    },
1305    "outputs": [],
1306    "source": []
1307   }
1308  ],
1309  "metadata": {
1310   "kernelspec": {
1311    "display_name": "Python 3",
1312    "language": "python",
1313    "name": "python3"
1314   },
1315   "language_info": {
1316    "codemirror_mode": {
1317     "name": "ipython",
1318     "version": 3
1319    },
1320    "file_extension": ".py",
1321    "mimetype": "text/x-python",
1322    "name": "python",
1323    "nbconvert_exporter": "python",
1324    "pygments_lexer": "ipython3",
1325    "version": "3.5.2+"
1326   }
1327  },
1328  "nbformat": 4,
1329  "nbformat_minor": 2
1330 }