X-Git-Url: https://git.njae.me.uk/?a=blobdiff_plain;f=radiohead-data.ipynb;fp=radiohead-data.ipynb;h=e3325563f06eacf56f42b9a79a21e8f4cb099f5e;hb=f957e34d6d16305be59287c3ca0ffb7a08805ca3;hp=6388a655b56481be2e3bb822e0609e577cda21ef;hpb=42878b0e4c2676f859a0df5633140dcc91b39167;p=battle-of-the-bands.git diff --git a/radiohead-data.ipynb b/radiohead-data.ipynb index 6388a65..e332556 100644 --- a/radiohead-data.ipynb +++ b/radiohead-data.ipynb @@ -38,7 +38,7 @@ }, { "cell_type": "code", - "execution_count": 58, + "execution_count": 3, "metadata": { "collapsed": true, "run_control": { @@ -75,7 +75,7 @@ }, { "cell_type": "code", - "execution_count": 2, + "execution_count": 4, "metadata": { "collapsed": true }, @@ -87,21 +87,29 @@ }, { "cell_type": "code", - "execution_count": 39, + "execution_count": 6, "metadata": { "collapsed": false }, - "outputs": [], + "outputs": [ + { + "name": "stdout", + "output_type": "stream", + "text": [ + "DB doesn't exist yet.\n" + ] + } + ], "source": [ - "try:\n", - " client.drop_database(songs_db)\n", - "except NameError:\n", - " print(\"DB doesn't exist yet.\")" + "# try:\n", + "# client.drop_database(songs_db)\n", + "# except NameError:\n", + "# print(\"DB doesn't exist yet.\")" ] }, { "cell_type": "code", - "execution_count": 40, + "execution_count": 5, "metadata": { "collapsed": false }, @@ -125,7 +133,7 @@ }, { "cell_type": "code", - "execution_count": 5, + "execution_count": 6, "metadata": { "collapsed": false }, @@ -136,7 +144,7 @@ "['app_name', 'client_id', 'client_secret', 'redirect_uri', 'token']" ] }, - "execution_count": 5, + "execution_count": 6, "metadata": {}, "output_type": "execute_result" } @@ -149,7 +157,7 @@ }, { "cell_type": "code", - "execution_count": 385, + "execution_count": 9, "metadata": { "collapsed": true }, @@ -177,7 +185,7 @@ }, { "cell_type": "code", - "execution_count": 6, + "execution_count": 7, "metadata": { "collapsed": false }, @@ -200,7 +208,7 @@ }, { "cell_type": "code", - "execution_count": 7, + "execution_count": 8, "metadata": { "collapsed": false }, @@ -214,7 +222,7 @@ " 'name': 'Radiohead'}])" ] }, - "execution_count": 7, + "execution_count": 8, "metadata": {}, "output_type": "execute_result" } @@ -227,7 +235,7 @@ }, { "cell_type": "code", - "execution_count": 8, + "execution_count": 9, "metadata": { "collapsed": false }, @@ -241,7 +249,7 @@ " 'name': 'The Beatles'}])" ] }, - "execution_count": 8, + "execution_count": 9, "metadata": {}, "output_type": "execute_result" } @@ -261,7 +269,7 @@ }, { "cell_type": "code", - "execution_count": 9, + "execution_count": 13, "metadata": { "collapsed": false }, @@ -281,7 +289,7 @@ }, { "cell_type": "code", - "execution_count": 41, + "execution_count": 14, "metadata": { "collapsed": false }, @@ -289,10 +297,10 @@ { "data": { "text/plain": [ - "15" + "48" ] }, - "execution_count": 41, + "execution_count": 14, "metadata": {}, "output_type": "execute_result" } @@ -304,7 +312,7 @@ }, { "cell_type": "code", - "execution_count": 42, + "execution_count": 15, "metadata": { "collapsed": false }, @@ -312,10 +320,10 @@ { "data": { "text/plain": [ - "28" + "48" ] }, - "execution_count": 42, + "execution_count": 15, "metadata": {}, "output_type": "execute_result" } @@ -327,7 +335,7 @@ }, { "cell_type": "code", - "execution_count": 13, + "execution_count": 16, "metadata": { "collapsed": false }, @@ -365,12 +373,28 @@ "
383 rows × 5 columns
\n", + "671 rows × 5 columns
\n", "" ], "text/plain": [ - " album_id album_name artist_name \\\n", - "0 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "1 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "2 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "3 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "4 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "5 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "6 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "7 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "8 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "9 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "10 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "11 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "12 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "13 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "14 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "15 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "16 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", - "17 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "18 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "19 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "20 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "21 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "22 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "23 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "24 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "25 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "26 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "27 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "28 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - "29 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", - ".. ... ... ... \n", - "353 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "354 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "355 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "356 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "357 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "358 7dxKtc08dYeRVHt3p9CZJn OK Computer Radiohead \n", - "359 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "360 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "361 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "362 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "363 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "364 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "365 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "366 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "367 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "368 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "369 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "370 500FEaUzn8lN9zWFyZG5C2 The Bends Radiohead \n", - "371 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "372 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "373 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "374 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "375 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "376 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "377 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "378 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "379 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "380 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "381 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", - "382 6400dnyeDyD2mIFHfkwHXN Pablo Honey Radiohead \n", + " album_id album_name artist_name \\\n", + "0 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "1 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "2 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "3 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "4 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "5 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "6 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "7 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "8 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "9 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "10 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "11 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "12 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "13 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "14 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "15 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "16 5XfJmldgWzrc1AIdbBaVZn Live At The Hollywood Bowl The Beatles \n", + "17 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "18 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "19 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "20 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "21 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "22 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "23 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "24 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "25 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "26 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "27 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "28 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + "29 5ju5Ouzan3QwXqQt1Tihbh 1 (Remastered) The Beatles \n", + ".. ... ... ... \n", + "641 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "642 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "643 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "644 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "645 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "646 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "647 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "648 54sqbAXxR1jFfyXb1WvrHK Some Girls The Rolling Stones \n", + "649 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "650 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "651 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "652 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "653 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "654 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "655 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "656 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "657 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "658 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "659 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "660 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "661 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "662 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "663 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "664 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "665 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "666 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "667 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "668 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "669 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", + "670 6FjXxl9VLURGuubdXUn2J3 Some Girls (Deluxe Version) The Rolling Stones \n", "\n", " track_id track_name \n", "0 4edArG2VehvJdwOZfYOxtK Twist And Shout - Live / Remastered \n", @@ -1940,41 +2143,41 @@ "28 0vXGSlE4ft3n5JHZMHHSIj Day Tripper - Remastered 2015 \n", "29 0Lckblu9CJUXOeMV0XY3b9 We Can Work It Out - Remastered 2015 \n", ".. ... ... \n", - "353 53aFGAl0Vebwp2bo8wtdWR Fitter Happier \n", - "354 6PBHfI3G8MlQ8qdItoVoxL Electioneering \n", - "355 0R332cdlS9LyE0Ge2PSlVC Climbing Up the Walls \n", - "356 1bSpwPhAxZwlR2enJJsv7U No Surprises \n", - "357 6n7GUf2h8D2Ad2wUy5s7nE Lucky \n", - "358 75YUnz58ajMo2VIIuUFvOV The Tourist \n", - "359 05evePUsIT1cmIURp1hgu6 Planet Telex \n", - "360 3aDUSpF3LexOr1lFKvPV2h The Bends \n", - "361 5jafMI8FLibnjkYTZ33m0c High And Dry \n", - "362 045sp2JToyTaaKyXkGejPy Fake Plastic Trees \n", - "363 0OT4Rhd9cw1yajN9ZxL6qL Bones \n", - "364 4QbQ55kHcRNho6XLaPctT1 (Nice Dream) \n", - "365 4SE81CrzH0qPA8KHqM9Syz Just \n", - "366 4dPKQxaraW6CG1rTBzV6DW My Iron Lung \n", - "367 7wB2VenWR6rchtLwawreIg Bullet Proof ... I Wish I Was \n", - "368 6JzzI3YxHCcjZ7MCQS2YS1 Black Star \n", - "369 4HtPAkZnSyGtNvBnfDc2nw Sulk \n", - "370 5gz38AxRkD6Ywxd4fr2pLj Street Spirit (Fade Out) \n", - "371 1MyqLTRhgyWPw7v107BEuI You \n", - "372 6b2oQwSGFkzsMtQruIWm2p Creep \n", - "373 71wIOoaoVMUwskK5yCXZL4 How Do You? \n", - "374 2zYmvi3w2T8a9Ckrv21bvW Stop Whispering \n", - "375 3ovbSnT5NNhl1gzMcw1NRZ Thinking About You \n", - "376 4NUc1M0CS7b6zvWoyvibju Anyone Can Play Guitar \n", - "377 4nklmaiY4gfQI3SB1sLGsd Ripcord \n", - "378 11qDTSr3Dj4TkPnBcIOqEJ Vegetable \n", - "379 4D6ZExVvYLZxhcAvifX5px Prove Yourself \n", - "380 48IEDejXX5LH8TAC3VIGpc I Can't \n", - "381 2B5P22cfUadACK7jLQegU6 Lurgee \n", - "382 6qttbImnJ5wuA8AtDKEy18 Blow Out \n", + "641 5ZesVHq9Nox8YjOR1kCpbN Just My Imagination (Running Away With Me) - R... \n", + "642 6hLpp90qMxG3TMvMzwJsiQ Some Girls - Remastered \n", + "643 3WqR7lRoHEvG0ExkAqBkPj Lies - Remastered \n", + "644 06PEXSCNl8Xwf2633TdNnx Far Away Eyes - Remastered \n", + "645 0Za26pWVLQpKfXmb9FX10S Respectable - Remastered \n", + "646 6295nz7PVXm49Ihqwm39Ew Before They Make Me Run - Remastered \n", + "647 0832Tptls5YicHPGgw7ssP Beast Of Burden - Remastered \n", + "648 6yq33zsqWCd8cYXQdtAFZ9 Shattered - Remastered \n", + "649 5pTWpY8l7B1XcQnijEFGFj Miss You - Remastered \n", + "650 4E8qFhiuYAWEYYAsYIf4dW When The Whip Comes Down - Remastered \n", + "651 7sDQlyQACyT7mNHFwwEMI7 Just My Imagination (Running Away With Me) - R... \n", + "652 48bJ1sWhJKdB8M43uqi924 Some Girls - Remastered \n", + "653 6362zAWHGgbrQaoeCFZpuO Lies - Remastered \n", + "654 4RlD0KvoqPZy5n9Zi76X9l Far Away Eyes - Remastered \n", + "655 33PXyHrkIHxp6PBVPlQGx7 Respectable - Remastered \n", + "656 7vsPbFinz35mfQO5d6oL0l Before They Make Me Run - Remastered \n", + "657 7pfVe0VrMK5QhTaAYzkuYn Beast Of Burden - Remastered \n", + "658 2giRM7RrP6utWLAb8jnFFk Shattered - Remastered \n", + "659 1V25DJ3ghDJs8m58jbVMbf Claudine \n", + "660 3rNTjyvxae83nJCLMxoVSW So Young \n", + "661 5oAcuuY504M7eDCln5Xq89 Do You Think I Really Care \n", + "662 1ZBnd9Z80QPQ58BaL5OWlP When You're Gone \n", + "663 624njB7Ny3mlA46QokEin9 No Spare Parts \n", + "664 0WpZfMNsNhiEJ8RSLyjElp Don't Be A Stranger \n", + "665 0Baq94uZKy4pPvnc40xjPX We Had It All \n", + "666 4oOU3GgiZblheOI9JUmM1f Tallahassee Lassie \n", + "667 4LW3JaAze7gF8DpPBb2zzl I Love You Too Much \n", + "668 4LSyTg4sm3N99Pcckw9zjf Keep Up Blues \n", + "669 3u06WsJ1KtvEqmmmZqy76J You Win Again \n", + "670 7DgRvvPcJlxks2lNpudsuT Petrol Blues \n", "\n", - "[383 rows x 5 columns]" + "[671 rows x 5 columns]" ] }, - "execution_count": 52, + "execution_count": 25, "metadata": {}, "output_type": "execute_result" } @@ -2002,7 +2205,7 @@ }, { "cell_type": "code", - "execution_count": 22, + "execution_count": 26, "metadata": { "collapsed": true }, @@ -2022,9 +2225,9 @@ }, { "cell_type": "code", - "execution_count": 30, + "execution_count": 1, "metadata": { - "collapsed": true + "collapsed": false }, "outputs": [], "source": [ @@ -2032,19 +2235,40 @@ " url = 'https://api.spotify.com/v1/audio-features?ids={ids}'.format(ids=','.join(track_ids))\n", " headers = {'Authorization': auth_type + ' ' + auth_token}\n", " request = urllib.request.Request(url, headers=headers, method='GET')\n", - " with urllib.request.urlopen(request) as f:\n", - " response = json.loads(f.read().decode('utf-8'))\n", - " for track in response['audio_features']:\n", - " tracks.update_one({'_id': track['id']}, {'$set': track})" + " \n", + " for _ in range(10):\n", + " try:\n", + " with urllib.request.urlopen(request) as f:\n", + " response = json.loads(f.read().decode('utf-8'))\n", + " for track in response['audio_features']:\n", + " tracks.update_one({'_id': track['id']}, {'$set': track})\n", + " break\n", + " except urllib.error.HTTPError as e:\n", + " print(\"Rate limited. Pausing for\", e.info()['Retry-After'])\n", + " time.sleep(int(e.info()['Retry-After']) + 0.5)\n", + " continue" ] }, { "cell_type": "code", - "execution_count": 54, + "execution_count": 33, "metadata": { "collapsed": false }, - "outputs": [], + "outputs": [ + { + "name": "stdout", + "output_type": "stream", + "text": [ + "Rate limited. Pausing for 2\n", + "Rate limited. Pausing for 0\n", + "Rate limited. Pausing for 2\n", + "Rate limited. Pausing for 0\n", + "Rate limited. Pausing for 2\n", + "Rate limited. Pausing for 2\n" + ] + } + ], "source": [ "a_type, a_token = get_spotify_auth_token()\n", "for a in albums.find({}, []):\n", @@ -2054,7 +2278,7 @@ }, { "cell_type": "code", - "execution_count": 55, + "execution_count": 10, "metadata": { "collapsed": false, "scrolled": true @@ -2079,6 +2303,7 @@ "34 rows × 230 columns
\n", + "41 rows × 229 columns
\n", "" ], "text/plain": [ " 0 \\\n", - "_id 4edArG2VehvJdwOZfYOxtK \n", - "acousticness 7.67e-05 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 5XfJmldgWzrc1AIdbBaVZn \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/4edA... \n", + "_id 2ucFulEWapRAmTn7l6f5Q7 \n", + "acousticness 0.425 \n", + "album {'name': 'The Beatles (Remastered)', 'images':... \n", + "album_id 03Qh833fEdVT30Pfs93ea6 \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/2ucF... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", - "danceability 0.311 \n", + "complexity 0.0598502 \n", + "ctitle wild honey pie \n", + "danceability 0.792 \n", "disc_number 1 \n", - "duration_ms 93507 \n", - "energy 0.822 \n", + "duration_ms 52973 \n", + "energy 0.763 \n", "explicit False \n", - "external_ids {'isrc': 'GBUM71603960'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/4e... \n", - "href https://api.spotify.com/v1/tracks/4edArG2VehvJ... \n", - "id 4edArG2VehvJdwOZfYOxtK \n", - "instrumentalness 2.04e-06 \n", + "external_ids {'isrc': 'GBAYE0601648'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/2u... \n", + "gloom 0.418731 \n", + "href https://api.spotify.com/v1/tracks/2ucFulEWapRA... \n", + "id 2ucFulEWapRAmTn7l6f5Q7 \n", + "instrumentalness 0.627 \n", "key 2 \n", - "liveness 0.508 \n", - "loudness -8.696 \n", + "liveness 0.789 \n", + "loudness -11.185 \n", + "lyrical_density 0.169898 \n", + "lyrics honey pie honey pie i love you, honey pie \n", "mode 1 \n", - "name Twist And Shout - Live / Remastered \n", - "popularity 47 \n", - "preview_url https://p.scdn.co/mp3-preview/cd82d2f8f92a7222... \n", - "speechiness 0.0395 \n", - "tempo 126.441 \n", + "name Wild Honey Pie - Remastered 2009 \n", + "original_lyrics \\n\\nHoney Pie\\nHoney Pie\\nI love you, Honey Pi... \n", + "popularity 43 \n", + "preview_url https://p.scdn.co/mp3-preview/ddebab4d5e87d46a... \n", + "sentiment {'probability': {'pos': 0.6088223652469111, 'n... \n", + "speechiness 0.0506 \n", + "tempo 89.9 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/4edArG2VehvJ... \n", - "track_number 1 \n", + "track_href https://api.spotify.com/v1/tracks/2ucFulEWapRA... \n", + "track_number 5 \n", "type audio_features \n", - "uri spotify:track:4edArG2VehvJdwOZfYOxtK \n", - "valence 0.588 \n", + "uri spotify:track:2ucFulEWapRAmTn7l6f5Q7 \n", + "valence 0.153 \n", "\n", " 1 \\\n", + "_id 2z1p43SNSbeowzy8WdYHNk \n", + "acousticness 0.368 \n", + "album {'name': 'Magical Mystery Tour (Remastered)', ... \n", + "album_id 6P9yO0ukhOx3dvmhGKeYoC \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/2z1p... \n", + "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", + "artist_name The Beatles \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", + "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle flying \n", + "danceability 0.551 \n", + "disc_number 1 \n", + "duration_ms 135520 \n", + "energy 0.395 \n", + "explicit False \n", + "external_ids {'isrc': 'GBAYE0601635'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/2z... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/2z1p43SNSbeo... \n", + "id 2z1p43SNSbeowzy8WdYHNk \n", + "instrumentalness 0.88 \n", + "key 0 \n", + "liveness 0.0932 \n", + "loudness -14.755 \n", + "lyrical_density 0 \n", + "lyrics \n", + "mode 1 \n", + "name Flying - Remastered 2009 \n", + "original_lyrics \\n\\n[Instrumental]\\n\\n \n", + "popularity 44 \n", + "preview_url https://p.scdn.co/mp3-preview/15f07b753cb7e50c... \n", + "sentiment NaN \n", + "speechiness 0.0501 \n", + "tempo 92.929 \n", + "time_signature 4 \n", + "track_href https://api.spotify.com/v1/tracks/2z1p43SNSbeo... \n", + "track_number 3 \n", + "type audio_features \n", + "uri spotify:track:2z1p43SNSbeowzy8WdYHNk \n", + "valence 0.246 \n", + "\n", + " 2 \\\n", + "_id 3ckvsHnEffhhS5c0Cs6Gv5 \n", + "acousticness 0.614 \n", + "album {'name': 'Beatles For Sale (Remastered)', 'ima... \n", + "album_id 7BgGBZndAvDlKOcwe5rscZ \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/3ckv... \n", + "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", + "artist_name The Beatles \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", + "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle kansas city heyheyheyhey \n", + "danceability 0.588 \n", + "disc_number 1 \n", + "duration_ms 158147 \n", + "energy 0.724 \n", + "explicit False \n", + "external_ids {'isrc': 'GBAYE0601457'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/3c... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/3ckvsHnEffhh... \n", + "id 3ckvsHnEffhhS5c0Cs6Gv5 \n", + "instrumentalness 8.92e-05 \n", + "key 7 \n", + "liveness 0.877 \n", + "loudness -6.63 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", + "mode 1 \n", + "name Kansas City / Hey-Hey-Hey-Hey - Remastered 2009 \n", + "original_lyrics NaN \n", + "popularity 38 \n", + "preview_url https://p.scdn.co/mp3-preview/bd13930c7706bdd4... \n", + "sentiment NaN \n", + "speechiness 0.0335 \n", + "tempo 131.36 \n", + "time_signature 4 \n", + "track_href https://api.spotify.com/v1/tracks/3ckvsHnEffhh... \n", + "track_number 7 \n", + "type audio_features \n", + "uri spotify:track:3ckvsHnEffhhS5c0Cs6Gv5 \n", + "valence 0.929 \n", + "\n", + " 3 \\\n", + "_id 4edArG2VehvJdwOZfYOxtK \n", + "acousticness 7.67e-05 \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", + "album_id 5XfJmldgWzrc1AIdbBaVZn \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/4edA... \n", + "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", + "artist_name The Beatles \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", + "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.293946 \n", + "ctitle twist and shout \n", + "danceability 0.311 \n", + "disc_number 1 \n", + "duration_ms 93507 \n", + "energy 0.822 \n", + "explicit False \n", + "external_ids {'isrc': 'GBUM71603960'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/4e... \n", + "gloom 0.238815 \n", + "href https://api.spotify.com/v1/tracks/4edArG2VehvJ... \n", + "id 4edArG2VehvJdwOZfYOxtK \n", + "instrumentalness 2.04e-06 \n", + "key 2 \n", + "liveness 0.508 \n", + "loudness -8.696 \n", + "lyrical_density 2.82332 \n", + "lyrics well shake it up baby now (shake it up baby) t... \n", + "mode 1 \n", + "name Twist And Shout - Live / Remastered \n", + "original_lyrics \\n\\n[Verse 1]\\nWell shake it up baby now (shak... \n", + "popularity 48 \n", + "preview_url https://p.scdn.co/mp3-preview/cd82d2f8f92a7222... \n", + "sentiment {'probability': {'pos': 0.500092464930449, 'ne... \n", + "speechiness 0.0395 \n", + "tempo 126.441 \n", + "time_signature 4 \n", + "track_href https://api.spotify.com/v1/tracks/4edArG2VehvJ... \n", + "track_number 1 \n", + "type audio_features \n", + "uri spotify:track:4edArG2VehvJdwOZfYOxtK \n", + "valence 0.588 \n", + "\n", + " 4 \\\n", "_id 150EAeMGWJRubuH8zyx7h8 \n", "acousticness 0.00675 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/150E... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.316303 \n", + "ctitle shes a woman \n", "danceability 0.188 \n", "disc_number 1 \n", "duration_ms 192053 \n", @@ -2967,16 +3497,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603957'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/15... \n", + "gloom 0.22727 \n", "href https://api.spotify.com/v1/tracks/150EAeMGWJRu... \n", "id 150EAeMGWJRubuH8zyx7h8 \n", "instrumentalness 2.42e-05 \n", "key 9 \n", "liveness 0.85 \n", "loudness -8.189 \n", + "lyrical_density 0.577965 \n", + "lyrics my love don't give me presents i know that she... \n", "mode 1 \n", "name She's A Woman - Live / Remastered \n", - "popularity 43 \n", + "original_lyrics \\n\\n[Chorus]\\nMy love don't give me presents\\n... \n", + "popularity 45 \n", "preview_url https://p.scdn.co/mp3-preview/37806a7d82c5d2a8... \n", + "sentiment {'probability': {'pos': 0.437183810867932, 'ne... \n", "speechiness 0.0662 \n", "tempo 175.86 \n", "time_signature 4 \n", @@ -2986,16 +3521,18 @@ "uri spotify:track:150EAeMGWJRubuH8zyx7h8 \n", "valence 0.562 \n", "\n", - " 2 \\\n", + " 5 \\\n", "_id 1fVeHYkyMxrjbjRAD9uWsZ \n", "acousticness 0.0131 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/1fVe... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.445783 \n", + "ctitle dizzy miss lizzy \n", "danceability 0.406 \n", "disc_number 1 \n", "duration_ms 219733 \n", @@ -3003,16 +3540,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603952'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/1f... \n", + "gloom 0.154272 \n", "href https://api.spotify.com/v1/tracks/1fVeHYkyMxrj... \n", "id 1fVeHYkyMxrjbjRAD9uWsZ \n", "instrumentalness 0.000141 \n", "key 11 \n", "liveness 0.496 \n", "loudness -6.879 \n", + "lyrical_density 0.796421 \n", + "lyrics {intro} you make me dizzy, miss lizzy the way ... \n", "mode 0 \n", "name Dizzy Miss Lizzy - Live / Remastered \n", - "popularity 42 \n", + "original_lyrics \\n\\n{Intro}\\n\\nYou make me dizzy, Miss Lizzy\\n... \n", + "popularity 44 \n", "preview_url https://p.scdn.co/mp3-preview/5ee6d20e1808908e... \n", + "sentiment {'probability': {'pos': 0.4118957822060205, 'n... \n", "speechiness 0.0461 \n", "tempo 129.417 \n", "time_signature 4 \n", @@ -3022,16 +3564,18 @@ "uri spotify:track:1fVeHYkyMxrjbjRAD9uWsZ \n", "valence 0.758 \n", "\n", - " 3 \\\n", + " 6 \\\n", "_id 0GRplBEB2FWCKutwMmS6nY \n", "acousticness 0.00327 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/0GRp... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.334303 \n", + "ctitle ticket to ride \n", "danceability 0.39 \n", "disc_number 1 \n", "duration_ms 146240 \n", @@ -3039,16 +3583,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603959'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/0G... \n", + "gloom 0.35295 \n", "href https://api.spotify.com/v1/tracks/0GRplBEB2FWC... \n", "id 0GRplBEB2FWCKutwMmS6nY \n", "instrumentalness 0 \n", "key 9 \n", "liveness 0.366 \n", "loudness -8.007 \n", + "lyrical_density 1.85312 \n", + "lyrics i think i'm going to be sad i think it's today... \n", "mode 1 \n", "name Ticket To Ride - Live / Remastered \n", - "popularity 43 \n", + "original_lyrics \\n\\n[Verse 1]\\nI think I'm going to be sad\\nI ... \n", + "popularity 44 \n", "preview_url https://p.scdn.co/mp3-preview/558bb39228550744... \n", + "sentiment {'probability': {'pos': 0.1745613462608472, 'n... \n", "speechiness 0.0423 \n", "tempo 121.216 \n", "time_signature 4 \n", @@ -3058,16 +3607,18 @@ "uri spotify:track:0GRplBEB2FWCKutwMmS6nY \n", "valence 0.405 \n", "\n", - " 4 \\\n", + " 7 \\\n", "_id 1eVymk74iroqhsZxm0Vy3g \n", "acousticness 0.00865 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/1eVy... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.493981 \n", + "ctitle cant buy me love \n", "danceability 0.2 \n", "disc_number 1 \n", "duration_ms 134867 \n", @@ -3075,16 +3626,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603951'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/1e... \n", + "gloom 0.242494 \n", "href https://api.spotify.com/v1/tracks/1eVymk74iroq... \n", "id 1eVymk74iroqhsZxm0Vy3g \n", "instrumentalness 0 \n", "key 5 \n", "liveness 0.894 \n", "loudness -7.606 \n", + "lyrical_density 1.47553 \n", + "lyrics can't buy me love, love can't buy me love i'll... \n", "mode 1 \n", "name Can't Buy Me Love - Live / Remastered \n", - "popularity 43 \n", + "original_lyrics \\n\\n[Chorus 1]\\nCan't buy me love, love\\nCan't... \n", + "popularity 44 \n", "preview_url https://p.scdn.co/mp3-preview/c6b9c820e62868db... \n", + "sentiment {'probability': {'pos': 0.2616130113907563, 'n... \n", "speechiness 0.0571 \n", "tempo 173.283 \n", "time_signature 4 \n", @@ -3094,16 +3650,18 @@ "uri spotify:track:1eVymk74iroqhsZxm0Vy3g \n", "valence 0.669 \n", "\n", - " 5 \\\n", + " 8 \\\n", "_id 2p5a9gu6NECVSvBtGSU1vm \n", "acousticness 0.0836 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/2p5a... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.24995 \n", + "ctitle things we said today \n", "danceability 0.307 \n", "disc_number 1 \n", "duration_ms 138733 \n", @@ -3111,16 +3669,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603958'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/2p... \n", + "gloom 0.307075 \n", "href https://api.spotify.com/v1/tracks/2p5a9gu6NECV... \n", "id 2p5a9gu6NECVSvBtGSU1vm \n", "instrumentalness 0 \n", "key 5 \n", "liveness 0.756 \n", "loudness -8.35 \n", + "lyrical_density 1.29746 \n", + "lyrics you say you will love me if i have to go you'l... \n", "mode 1 \n", "name Things We Said Today - Live / Remastered \n", - "popularity 42 \n", + "original_lyrics \\n\\n[Verse 1]\\nYou say you will love me\\nIf I ... \n", + "popularity 43 \n", "preview_url https://p.scdn.co/mp3-preview/7b71156485b9e3e1... \n", + "sentiment {'probability': {'pos': 0.3672150785922961, 'n... \n", "speechiness 0.0392 \n", "tempo 146.636 \n", "time_signature 4 \n", @@ -3130,16 +3693,18 @@ "uri spotify:track:2p5a9gu6NECVSvBtGSU1vm \n", "valence 0.395 \n", "\n", - " 6 \\\n", + " 9 \\\n", "_id 1HyLh5cctOnP186CBi8bhm \n", "acousticness 0.00242 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Live At The Hollywood Bowl', 'images... \n", "album_id 5XfJmldgWzrc1AIdbBaVZn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/1HyL... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity 0.467134 \n", + "ctitle roll over beethoven \n", "danceability 0.204 \n", "disc_number 1 \n", "duration_ms 134013 \n", @@ -3147,16 +3712,21 @@ "explicit False \n", "external_ids {'isrc': 'GBUM71603955'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/1H... \n", + "gloom 0.22049 \n", "href https://api.spotify.com/v1/tracks/1HyLh5cctOnP... \n", "id 1HyLh5cctOnP186CBi8bhm \n", "instrumentalness 0 \n", "key 2 \n", "liveness 0.634 \n", "loudness -7.948 \n", + "lyrical_density 1.7461 \n", + "lyrics i'm gonna write a little letter gonna mail it ... \n", "mode 1 \n", "name Roll Over Beethoven - Live / Remastered \n", - "popularity 41 \n", + "original_lyrics \\n\\nI'm gonna write a little letter\\nGonna mai... \n", + "popularity 43 \n", "preview_url https://p.scdn.co/mp3-preview/318950f70347c556... \n", + "sentiment {'probability': {'pos': 0.35656423276148513, '... \n", "speechiness 0.0398 \n", "tempo 179.24 \n", "time_signature 3 \n", @@ -3166,114 +3736,6 @@ "uri spotify:track:1HyLh5cctOnP186CBi8bhm \n", "valence 0.726 \n", "\n", - " 7 \\\n", - "_id 7fZEWm7TAL2oZDyiYrrgnk \n", - "acousticness 0.0358 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 5XfJmldgWzrc1AIdbBaVZn \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/7fZE... \n", - "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", - "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", - "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", - "danceability 0.226 \n", - "disc_number 1 \n", - "duration_ms 128747 \n", - "energy 0.933 \n", - "explicit False \n", - "external_ids {'isrc': 'GBUM71603950'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/7f... \n", - "href https://api.spotify.com/v1/tracks/7fZEWm7TAL2o... \n", - "id 7fZEWm7TAL2oZDyiYrrgnk \n", - "instrumentalness 0.00057 \n", - "key 9 \n", - "liveness 0.844 \n", - "loudness -6.146 \n", - "mode 1 \n", - "name Boys - Live / Remastered \n", - "popularity 42 \n", - "preview_url https://p.scdn.co/mp3-preview/d0c2027d928e938a... \n", - "speechiness 0.108 \n", - "tempo 160.11 \n", - "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/7fZEWm7TAL2o... \n", - "track_number 8 \n", - "type audio_features \n", - "uri spotify:track:7fZEWm7TAL2oZDyiYrrgnk \n", - "valence 0.641 \n", - "\n", - " 8 \\\n", - "_id 21nhooOxso7CCoHPE73w4L \n", - "acousticness 0.0439 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 5XfJmldgWzrc1AIdbBaVZn \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/21nh... \n", - "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", - "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", - "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", - "danceability 0.293 \n", - "disc_number 1 \n", - "duration_ms 193760 \n", - "energy 0.866 \n", - "explicit False \n", - "external_ids {'isrc': 'GBUM71603948'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/21... \n", - "href https://api.spotify.com/v1/tracks/21nhooOxso7C... \n", - "id 21nhooOxso7CCoHPE73w4L \n", - "instrumentalness 2.64e-06 \n", - "key 0 \n", - "liveness 0.927 \n", - "loudness -7.366 \n", - "mode 1 \n", - "name A Hard Day's Night - Live / Remastered \n", - "popularity 44 \n", - "preview_url https://p.scdn.co/mp3-preview/88b8add083e60507... \n", - "speechiness 0.049 \n", - "tempo 134.825 \n", - "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/21nhooOxso7C... \n", - "track_number 9 \n", - "type audio_features \n", - "uri spotify:track:21nhooOxso7CCoHPE73w4L \n", - "valence 0.635 \n", - "\n", - " 9 \\\n", - "_id 1alcPfZWUHh01l4Fnoo5Jt \n", - "acousticness 0.02 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 5XfJmldgWzrc1AIdbBaVZn \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/1alc... \n", - "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", - "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", - "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", - "danceability 0.436 \n", - "disc_number 1 \n", - "duration_ms 172600 \n", - "energy 0.772 \n", - "explicit False \n", - "external_ids {'isrc': 'GBUM71603953'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/1a... \n", - "href https://api.spotify.com/v1/tracks/1alcPfZWUHh0... \n", - "id 1alcPfZWUHh01l4Fnoo5Jt \n", - "instrumentalness 0 \n", - "key 11 \n", - "liveness 0.828 \n", - "loudness -7.133 \n", - "mode 0 \n", - "name Help! - Live / Remastered \n", - "popularity 43 \n", - "preview_url https://p.scdn.co/mp3-preview/1aff27bfc59a0bc1... \n", - "speechiness 0.044 \n", - "tempo 96.413 \n", - "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/1alcPfZWUHh0... \n", - "track_number 10 \n", - "type audio_features \n", - "uri spotify:track:1alcPfZWUHh01l4Fnoo5Jt \n", - "valence 0.515 \n", - "\n", " ... \\\n", "_id ... \n", "acousticness ... \n", @@ -3284,6 +3746,8 @@ "artist_name ... \n", "artists ... \n", "available_markets ... \n", + "complexity ... \n", + "ctitle ... \n", "danceability ... \n", "disc_number ... \n", "duration_ms ... \n", @@ -3291,16 +3755,21 @@ "explicit ... \n", "external_ids ... \n", "external_urls ... \n", + "gloom ... \n", "href ... \n", "id ... \n", "instrumentalness ... \n", "key ... \n", "liveness ... \n", "loudness ... \n", + "lyrical_density ... \n", + "lyrics ... \n", "mode ... \n", "name ... \n", + "original_lyrics ... \n", "popularity ... \n", "preview_url ... \n", + "sentiment ... \n", "speechiness ... \n", "tempo ... \n", "time_signature ... \n", @@ -3310,16 +3779,18 @@ "uri ... \n", "valence ... \n", "\n", - " 220 \\\n", + " 219 \\\n", "_id 43feVCF6QfqIt9LnLs9BAH \n", "acousticness 0.607 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/43fe... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle boys \n", "danceability 0.402 \n", "disc_number 1 \n", "duration_ms 146440 \n", @@ -3327,16 +3798,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601414'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/43... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/43feVCF6QfqI... \n", "id 43feVCF6QfqIt9LnLs9BAH \n", "instrumentalness 0 \n", "key 4 \n", "liveness 0.736 \n", "loudness -10.31 \n", + "lyrical_density 0.901393 \n", + "lyrics i been told when a boy kiss a girl take a trip... \n", "mode 1 \n", "name Boys - Remastered 2009 \n", - "popularity 41 \n", + "original_lyrics \\n\\n[Verse 1]\\nI been told when a boy kiss a g... \n", + "popularity 42 \n", "preview_url https://p.scdn.co/mp3-preview/c84bcc2dd65c3d9b... \n", + "sentiment {'probability': {'pos': 0.4595305514727438, 'n... \n", "speechiness 0.0504 \n", "tempo 142.445 \n", "time_signature 4 \n", @@ -3346,16 +3822,18 @@ "uri spotify:track:43feVCF6QfqIt9LnLs9BAH \n", "valence 0.825 \n", "\n", - " 221 \\\n", + " 220 \\\n", "_id 3NwEPV9MDr1z3KcHiAuz9d \n", "acousticness 0.767 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/3NwE... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle ask me why \n", "danceability 0.605 \n", "disc_number 1 \n", "duration_ms 146533 \n", @@ -3363,16 +3841,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601415'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/3N... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/3NwEPV9MDr1z... \n", "id 3NwEPV9MDr1z3KcHiAuz9d \n", "instrumentalness 0 \n", "key 4 \n", "liveness 0.0967 \n", "loudness -11.33 \n", + "lyrical_density 1.01001 \n", + "lyrics i love you, because you tell me things i want ... \n", "mode 1 \n", "name Ask Me Why - Remastered 2009 \n", - "popularity 40 \n", + "original_lyrics \\n\\n[Verse 1]\\nI love you, because you tell me... \n", + "popularity 41 \n", "preview_url https://p.scdn.co/mp3-preview/f42256fa5367c68f... \n", + "sentiment {'probability': {'pos': 0.20446882559048601, '... \n", "speechiness 0.0378 \n", "tempo 133.942 \n", "time_signature 4 \n", @@ -3382,16 +3865,18 @@ "uri spotify:track:3NwEPV9MDr1z3KcHiAuz9d \n", "valence 0.606 \n", "\n", - " 222 \\\n", + " 221 \\\n", "_id 2Iccm3cKBQHWt5yk0yX9nh \n", "acousticness 0.334 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/2Icc... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle please please me \n", "danceability 0.527 \n", "disc_number 1 \n", "duration_ms 120853 \n", @@ -3399,16 +3884,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601416'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/2I... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/2Iccm3cKBQHW... \n", "id 2Iccm3cKBQHWt5yk0yX9nh \n", "instrumentalness 0 \n", "key 4 \n", "liveness 0.0702 \n", "loudness -9.61 \n", + "lyrical_density 2.19275 \n", + "lyrics (lennon/mccartney) last night i said these wor... \n", "mode 1 \n", "name Please Please Me - Remastered 2009 \n", - "popularity 46 \n", + "original_lyrics \\n\\n(Lennon/McCartney)\\n\\nLast night I said th... \n", + "popularity 48 \n", "preview_url https://p.scdn.co/mp3-preview/c7974d03d8cd26de... \n", + "sentiment {'probability': {'pos': 0.16446745008480748, '... \n", "speechiness 0.028 \n", "tempo 139.388 \n", "time_signature 4 \n", @@ -3418,16 +3908,18 @@ "uri spotify:track:2Iccm3cKBQHWt5yk0yX9nh \n", "valence 0.708 \n", "\n", - " 223 \\\n", + " 222 \\\n", "_id 2OLMjGIhCNI6j34ysPscbp \n", "acousticness 0.386 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/2OLM... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle love me do \n", "danceability 0.52 \n", "disc_number 1 \n", "duration_ms 141693 \n", @@ -3435,16 +3927,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601417'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/2O... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/2OLMjGIhCNI6... \n", "id 2OLMjGIhCNI6j34ysPscbp \n", "instrumentalness 6.2e-05 \n", "key 0 \n", "liveness 0.227 \n", "loudness -6.228 \n", + "lyrical_density 0.783384 \n", + "lyrics love, love me do you know i love you i'll alwa... \n", "mode 1 \n", "name Love Me Do - Remastered 2009 \n", - "popularity 53 \n", + "original_lyrics \\n\\nLove, love me do\\nYou know I love you\\nI'l... \n", + "popularity 55 \n", "preview_url https://p.scdn.co/mp3-preview/c0c7944dcb9d2457... \n", + "sentiment {'probability': {'pos': 0.5071807762286473, 'n... \n", "speechiness 0.0806 \n", "tempo 147.997 \n", "time_signature 4 \n", @@ -3454,16 +3951,18 @@ "uri spotify:track:2OLMjGIhCNI6j34ysPscbp \n", "valence 0.765 \n", "\n", - " 224 \\\n", + " 223 \\\n", "_id 01n20rdBC5czKAhxmGREkr \n", "acousticness 0.389 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/01n2... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle ps i love you \n", "danceability 0.635 \n", "disc_number 1 \n", "duration_ms 124360 \n", @@ -3471,16 +3970,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601418'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/01... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/01n20rdBC5cz... \n", "id 01n20rdBC5czKAhxmGREkr \n", "instrumentalness 0.00127 \n", "key 2 \n", "liveness 0.0828 \n", "loudness -8.5 \n", + "lyrical_density 1.2303 \n", + "lyrics as i write this letter send my love to you rem... \n", "mode 1 \n", "name P.S. I Love You - Remastered 2009 \n", - "popularity 41 \n", + "original_lyrics \\n\\nAs I write this letter\\nSend my love to yo... \n", + "popularity 43 \n", "preview_url https://p.scdn.co/mp3-preview/5ef1f2ba07489648... \n", + "sentiment {'probability': {'pos': 0.6580284675394283, 'n... \n", "speechiness 0.0291 \n", "tempo 134.435 \n", "time_signature 4 \n", @@ -3490,16 +3994,18 @@ "uri spotify:track:01n20rdBC5czKAhxmGREkr \n", "valence 0.78 \n", "\n", - " 225 \\\n", + " 224 \\\n", "_id 5gnrZoSS7nbDYtHp32RFiI \n", "acousticness 0.778 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/5gnr... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle baby its you \n", "danceability 0.608 \n", "disc_number 1 \n", "duration_ms 160520 \n", @@ -3507,16 +4013,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601419'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/5g... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/5gnrZoSS7nbD... \n", "id 5gnrZoSS7nbDYtHp32RFiI \n", "instrumentalness 0 \n", "key 4 \n", "liveness 0.0926 \n", "loudness -12.211 \n", + "lyrical_density 1.32694 \n", + "lyrics sha la la la la la la la sha la la la la la la... \n", "mode 0 \n", "name Baby It's You - Remastered 2009 \n", - "popularity 42 \n", + "original_lyrics \\n\\n[Intro-The Beatles]\\nSha la la la la la la... \n", + "popularity 44 \n", "preview_url https://p.scdn.co/mp3-preview/d7eeb1f68c39066d... \n", + "sentiment {'probability': {'pos': 0.3209861049246835, 'n... \n", "speechiness 0.0345 \n", "tempo 112.421 \n", "time_signature 4 \n", @@ -3526,16 +4037,18 @@ "uri spotify:track:5gnrZoSS7nbDYtHp32RFiI \n", "valence 0.889 \n", "\n", - " 226 \\\n", + " 225 \\\n", "_id 5FBxWhG0nbBAF6lWgJFklM \n", "acousticness 0.608 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/5FBx... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle do you want to know a secret \n", "danceability 0.673 \n", "disc_number 1 \n", "duration_ms 117013 \n", @@ -3543,16 +4056,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601420'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/5F... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/5FBxWhG0nbBA... \n", "id 5FBxWhG0nbBAF6lWgJFklM \n", "instrumentalness 0 \n", "key 4 \n", "liveness 0.38 \n", "loudness -12.414 \n", + "lyrical_density 1.1879 \n", + "lyrics you'll never know how much i really love you y... \n", "mode 1 \n", "name Do You Want To Know A Secret - Remastered 2009 \n", - "popularity 47 \n", + "original_lyrics \\n\\n[Intro]\\nYou'll never know how much I real... \n", + "popularity 48 \n", "preview_url https://p.scdn.co/mp3-preview/5bd705943290818c... \n", + "sentiment {'probability': {'pos': 0.440458717583442, 'ne... \n", "speechiness 0.0368 \n", "tempo 124.451 \n", "time_signature 4 \n", @@ -3562,16 +4080,18 @@ "uri spotify:track:5FBxWhG0nbBAF6lWgJFklM \n", "valence 0.636 \n", "\n", - " 227 \\\n", + " 226 \\\n", "_id 6tEwCsVtZ5tI8uHNJSHQ3b \n", "acousticness 0.698 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/6tEw... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle a taste of honey \n", "danceability 0.42 \n", "disc_number 1 \n", "duration_ms 123480 \n", @@ -3579,16 +4099,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601421'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/6t... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/6tEwCsVtZ5tI... \n", "id 6tEwCsVtZ5tI8uHNJSHQ3b \n", "instrumentalness 0 \n", "key 1 \n", "liveness 0.104 \n", "loudness -11.416 \n", + "lyrical_density 0.74506 \n", + "lyrics a taste of honey! tasting much sweeter than wi... \n", "mode 0 \n", "name A Taste Of Honey - Remastered 2009 \n", - "popularity 39 \n", + "original_lyrics \\n\\n[Intro]\\nA taste of honey! Tasting much sw... \n", + "popularity 40 \n", "preview_url https://p.scdn.co/mp3-preview/dd94439cdf6e7668... \n", + "sentiment {'probability': {'pos': 0.6485651627744511, 'n... \n", "speechiness 0.0327 \n", "tempo 101.408 \n", "time_signature 3 \n", @@ -3598,16 +4123,18 @@ "uri spotify:track:6tEwCsVtZ5tI8uHNJSHQ3b \n", "valence 0.378 \n", "\n", - " 228 \\\n", + " 227 \\\n", "_id 50jq8RgbDfmNNd0NiRnl4L \n", "acousticness 0.629 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/50jq... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle theres a place \n", "danceability 0.455 \n", "disc_number 1 \n", "duration_ms 110493 \n", @@ -3615,16 +4142,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601422'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/50... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/50jq8RgbDfmN... \n", "id 50jq8RgbDfmNNd0NiRnl4L \n", "instrumentalness 4.22e-06 \n", "key 4 \n", "liveness 0.172 \n", "loudness -10.009 \n", + "lyrical_density 0.895984 \n", + "lyrics there is a place where i can go when i feel lo... \n", "mode 1 \n", "name There's A Place - Remastered 2009 \n", - "popularity 41 \n", + "original_lyrics \\n\\n[Verse 1]\\nThere is a place\\nWhere I can g... \n", + "popularity 43 \n", "preview_url https://p.scdn.co/mp3-preview/5260a1d4f12c23ac... \n", + "sentiment {'probability': {'pos': 0.3487106796498656, 'n... \n", "speechiness 0.0292 \n", "tempo 140.928 \n", "time_signature 4 \n", @@ -3634,16 +4166,18 @@ "uri spotify:track:50jq8RgbDfmNNd0NiRnl4L \n", "valence 0.928 \n", "\n", - " 229 \n", + " 228 \n", "_id 4Z1fbYp0HuxLBje4MOZcSD \n", "acousticness 0.641 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Please Please Me (Remastered)', 'ima... \n", "album_id 7gDXyW16byCQOgK965BRzn \n", "analysis_url https://api.spotify.com/v1/audio-analysis/4Z1f... \n", "artist_id 3WrFJ7ztbogyGnTHbHJFl2 \n", "artist_name The Beatles \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'The Beatles', 'id': '3WrFJ7ztbogyGn... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CH, CL, CO, C... \n", + "complexity NaN \n", + "ctitle twist and shout \n", "danceability 0.482 \n", "disc_number 1 \n", "duration_ms 155227 \n", @@ -3651,16 +4185,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE0601423'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/4Z... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/4Z1fbYp0HuxL... \n", "id 4Z1fbYp0HuxLBje4MOZcSD \n", "instrumentalness 7.74e-06 \n", "key 2 \n", "liveness 0.0414 \n", "loudness -9.198 \n", + "lyrical_density 1.70075 \n", + "lyrics well shake it up baby now (shake it up baby) t... \n", "mode 1 \n", "name Twist And Shout - Remastered 2009 \n", - "popularity 63 \n", + "original_lyrics \\n\\n[Verse 1]\\nWell shake it up baby now (shak... \n", + "popularity 64 \n", "preview_url https://p.scdn.co/mp3-preview/b7e3bc96b46e4dcc... \n", + "sentiment {'probability': {'pos': 0.500092464930449, 'ne... \n", "speechiness 0.0452 \n", "tempo 124.631 \n", "time_signature 4 \n", @@ -3670,10 +4209,10 @@ "uri spotify:track:4Z1fbYp0HuxLBje4MOZcSD \n", "valence 0.942 \n", "\n", - "[34 rows x 230 columns]" + "[41 rows x 229 columns]" ] }, - "execution_count": 55, + "execution_count": 10, "metadata": {}, "output_type": "execute_result" } @@ -3685,7 +4224,7 @@ }, { "cell_type": "code", - "execution_count": 56, + "execution_count": 11, "metadata": { "collapsed": false, "scrolled": true @@ -3725,16 +4264,16 @@ " \n", "34 rows × 146 columns
\n", + "41 rows × 146 columns
\n", "" ], "text/plain": [ " 0 \\\n", - "_id 6tLALP9mi7VbNC7s16iBRK \n", - "acousticness 0.62 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "_id 0eECFDnWy0RdjMmJ8NOeAL \n", + "acousticness 0.00101 \n", + "album {'name': 'The King Of Limbs', 'images': [{'wid... \n", "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/6tLA... \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/0eEC... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.518 \n", + "complexity 0.349377 \n", + "ctitle feral \n", + "danceability 0.49 \n", "disc_number 1 \n", - "duration_ms 313671 \n", - "energy 0.959 \n", + "duration_ms 192743 \n", + "energy 0.777 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100003'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/6t... \n", - "href https://api.spotify.com/v1/tracks/6tLALP9mi7Vb... \n", - "id 6tLALP9mi7VbNC7s16iBRK \n", - "instrumentalness 0.884 \n", - "key 0 \n", - "liveness 0.0831 \n", - "loudness -7.596 \n", - "mode 0 \n", - "name Bloom \n", - "popularity 47 \n", - "preview_url https://p.scdn.co/mp3-preview/1f06ac997e3f6e9b... \n", - "speechiness 0.157 \n", - "tempo 149.722 \n", + "external_ids {'isrc': 'GBU4B1100006'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/0e... \n", + "gloom 0.1245 \n", + "href https://api.spotify.com/v1/tracks/0eECFDnWy0Rd... \n", + "id 0eECFDnWy0RdjMmJ8NOeAL \n", + "instrumentalness 0.898 \n", + "key 7 \n", + "liveness 0.0896 \n", + "loudness -11.521 \n", + "lyrical_density 0.0933886 \n", + "lyrics you are not mine and i am not yours and that's... \n", + "mode 1 \n", + "name Feral \n", + "original_lyrics \\n\\n[Verse]\\nYou are not mine\\nAnd I am not yo... \n", + "popularity 43 \n", + "preview_url https://p.scdn.co/mp3-preview/9dc0af2fa010c41d... \n", + "sentiment {'probability': {'pos': 0.5347839139034816, 'n... \n", + "speechiness 0.0974 \n", + "tempo 135.991 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/6tLALP9mi7Vb... \n", - "track_number 1 \n", + "track_href https://api.spotify.com/v1/tracks/0eECFDnWy0Rd... \n", + "track_number 4 \n", "type audio_features \n", - "uri spotify:track:6tLALP9mi7VbNC7s16iBRK \n", - "valence 0.325 \n", + "uri spotify:track:0eECFDnWy0RdjMmJ8NOeAL \n", + "valence 0.751 \n", "\n", " 1 \\\n", - "_id 3wxmJSQ3Z1HfAuxeHQoZcE \n", - "acousticness 0.42 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/3wxm... \n", + "_id 6Unw1AAcpS1ZgZoRlj2jxA \n", + "acousticness 0.00822 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/6Unw... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.648 \n", + "complexity NaN \n", + "ctitle little by little caribou rmx \n", + "danceability 0.8 \n", "disc_number 1 \n", - "duration_ms 280719 \n", - "energy 0.588 \n", + "duration_ms 340160 \n", + "energy 0.586 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100004'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/3w... \n", - "href https://api.spotify.com/v1/tracks/3wxmJSQ3Z1Hf... \n", - "id 3wxmJSQ3Z1HfAuxeHQoZcE \n", - "instrumentalness 0.84 \n", - "key 5 \n", - "liveness 0.141 \n", - "loudness -10.993 \n", + "external_ids {'isrc': 'GBU4B1100013'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/6U... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/6Unw1AAcpS1Z... \n", + "id 6Unw1AAcpS1ZgZoRlj2jxA \n", + "instrumentalness 0.773 \n", + "key 2 \n", + "liveness 0.0846 \n", + "loudness -9.633 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 1 \n", - "name Morning Mr Magpie \n", - "popularity 45 \n", - "preview_url https://p.scdn.co/mp3-preview/88e1ea3713ddc68f... \n", - "speechiness 0.052 \n", - "tempo 70.124 \n", + "name Little By Little (Caribou Rmx) \n", + "original_lyrics NaN \n", + "popularity 44 \n", + "preview_url https://p.scdn.co/mp3-preview/0e4982f830936c3c... \n", + "sentiment NaN \n", + "speechiness 0.0601 \n", + "tempo 115.62 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/3wxmJSQ3Z1Hf... \n", - "track_number 2 \n", + "track_href https://api.spotify.com/v1/tracks/6Unw1AAcpS1Z... \n", + "track_number 1 \n", "type audio_features \n", - "uri spotify:track:3wxmJSQ3Z1HfAuxeHQoZcE \n", - "valence 0.407 \n", + "uri spotify:track:6Unw1AAcpS1ZgZoRlj2jxA \n", + "valence 0.131 \n", "\n", " 2 \\\n", - "_id 4tCwsdqqG4jASHhbsMHCx0 \n", - "acousticness 0.427 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/4tCw... \n", + "_id 5hfzW7LG97Hxv62HHUKgaj \n", + "acousticness 0.0589 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/5hfz... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.619 \n", + "complexity NaN \n", + "ctitle lotus flower jacques greene rmx \n", + "danceability 0.629 \n", "disc_number 1 \n", - "duration_ms 267154 \n", - "energy 0.886 \n", + "duration_ms 429947 \n", + "energy 0.592 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100005'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/4t... \n", - "href https://api.spotify.com/v1/tracks/4tCwsdqqG4jA... \n", - "id 4tCwsdqqG4jASHhbsMHCx0 \n", - "instrumentalness 0.411 \n", - "key 4 \n", - "liveness 0.212 \n", - "loudness -8.423 \n", + "external_ids {'isrc': 'GBU4B1100014'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/5h... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/5hfzW7LG97Hx... \n", + "id 5hfzW7LG97Hxv62HHUKgaj \n", + "instrumentalness 0.938 \n", + "key 2 \n", + "liveness 0.0951 \n", + "loudness -8.405 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 0 \n", - "name Little By Little \n", + "name Lotus Flower (Jacques Greene Rmx) \n", + "original_lyrics NaN \n", "popularity 44 \n", - "preview_url https://p.scdn.co/mp3-preview/9677d537851e5091... \n", - "speechiness 0.0376 \n", - "tempo 115.625 \n", + "preview_url https://p.scdn.co/mp3-preview/fb82884344aaffd3... \n", + "sentiment NaN \n", + "speechiness 0.0327 \n", + "tempo 127.982 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/4tCwsdqqG4jA... \n", - "track_number 3 \n", + "track_href https://api.spotify.com/v1/tracks/5hfzW7LG97Hx... \n", + "track_number 2 \n", "type audio_features \n", - "uri spotify:track:4tCwsdqqG4jASHhbsMHCx0 \n", - "valence 0.602 \n", + "uri spotify:track:5hfzW7LG97Hxv62HHUKgaj \n", + "valence 0.171 \n", "\n", " 3 \\\n", - "_id 0eECFDnWy0RdjMmJ8NOeAL \n", - "acousticness 0.00101 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/0eEC... \n", + "_id 64lecUR19lBSu317AzVZv3 \n", + "acousticness 0.0825 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/64le... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.49 \n", + "complexity NaN \n", + "ctitle morning mr magpie nathan fake rmx \n", + "danceability 0.661 \n", "disc_number 1 \n", - "duration_ms 192743 \n", - "energy 0.777 \n", + "duration_ms 291987 \n", + "energy 0.707 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100006'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/0e... \n", - "href https://api.spotify.com/v1/tracks/0eECFDnWy0Rd... \n", - "id 0eECFDnWy0RdjMmJ8NOeAL \n", - "instrumentalness 0.898 \n", - "key 7 \n", - "liveness 0.0896 \n", - "loudness -11.521 \n", + "external_ids {'isrc': 'GBU4B1100015'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/64... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/64lecUR19lBS... \n", + "id 64lecUR19lBSu317AzVZv3 \n", + "instrumentalness 0.0772 \n", + "key 0 \n", + "liveness 0.117 \n", + "loudness -7.023 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 1 \n", - "name Feral \n", - "popularity 42 \n", - "preview_url https://p.scdn.co/mp3-preview/9dc0af2fa010c41d... \n", - "speechiness 0.0974 \n", - "tempo 135.991 \n", + "name Morning Mr Magpie (Nathan Fake Rmx) \n", + "original_lyrics NaN \n", + "popularity 40 \n", + "preview_url https://p.scdn.co/mp3-preview/e8aa276e76b8e753... \n", + "sentiment NaN \n", + "speechiness 0.232 \n", + "tempo 139.976 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/0eECFDnWy0Rd... \n", - "track_number 4 \n", + "track_href https://api.spotify.com/v1/tracks/64lecUR19lBS... \n", + "track_number 3 \n", "type audio_features \n", - "uri spotify:track:0eECFDnWy0RdjMmJ8NOeAL \n", - "valence 0.751 \n", + "uri spotify:track:64lecUR19lBSu317AzVZv3 \n", + "valence 0.837 \n", "\n", " 4 \\\n", - "_id 1amSa5xo79zINsgrpNlNge \n", - "acousticness 0.0895 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/1amS... \n", + "_id 1CxhtUbe1o2PeMM3l5Kch6 \n", + "acousticness 0.102 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/1Cxh... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.721 \n", + "complexity NaN \n", + "ctitle bloom harmonic 313 rmx \n", + "danceability 0.443 \n", "disc_number 1 \n", - "duration_ms 300219 \n", - "energy 0.676 \n", + "duration_ms 304333 \n", + "energy 0.665 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100007'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/1a... \n", - "href https://api.spotify.com/v1/tracks/1amSa5xo79zI... \n", - "id 1amSa5xo79zINsgrpNlNge \n", - "instrumentalness 0.336 \n", - "key 2 \n", - "liveness 0.0826 \n", - "loudness -8.78 \n", + "external_ids {'isrc': 'GBU4B1100016'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/1C... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/1CxhtUbe1o2P... \n", + "id 1CxhtUbe1o2PeMM3l5Kch6 \n", + "instrumentalness 0.937 \n", + "key 9 \n", + "liveness 0.111 \n", + "loudness -13.055 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 0 \n", - "name Lotus Flower \n", - "popularity 54 \n", - "preview_url https://p.scdn.co/mp3-preview/dead2fbe5cece1a2... \n", - "speechiness 0.0321 \n", - "tempo 127.997 \n", + "name Bloom (Harmonic 313 Rmx) \n", + "original_lyrics NaN \n", + "popularity 39 \n", + "preview_url https://p.scdn.co/mp3-preview/686816b702063d96... \n", + "sentiment NaN \n", + "speechiness 0.0536 \n", + "tempo 150.023 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/1amSa5xo79zI... \n", - "track_number 5 \n", + "track_href https://api.spotify.com/v1/tracks/1CxhtUbe1o2P... \n", + "track_number 4 \n", "type audio_features \n", - "uri spotify:track:1amSa5xo79zINsgrpNlNge \n", - "valence 0.603 \n", + "uri spotify:track:1CxhtUbe1o2PeMM3l5Kch6 \n", + "valence 0.172 \n", "\n", " 5 \\\n", - "_id 4sLGaMl33I6mcsk7u4xHAU \n", - "acousticness 0.841 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/4sLG... \n", + "_id 2H7Y8wYixrSlKJoaZ1N2yl \n", + "acousticness 0.000801 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/2H7Y... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.327 \n", + "complexity NaN \n", + "ctitle bloom mark pritchard rmx \n", + "danceability 0.414 \n", "disc_number 1 \n", - "duration_ms 287067 \n", - "energy 0.128 \n", + "duration_ms 367280 \n", + "energy 0.712 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100008'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/4s... \n", - "href https://api.spotify.com/v1/tracks/4sLGaMl33I6m... \n", - "id 4sLGaMl33I6mcsk7u4xHAU \n", - "instrumentalness 0.76 \n", - "key 2 \n", - "liveness 0.13 \n", - "loudness -17.536 \n", - "mode 0 \n", - "name Codex \n", - "popularity 51 \n", - "preview_url https://p.scdn.co/mp3-preview/1022e7001ecff7cf... \n", - "speechiness 0.0301 \n", - "tempo 58.993 \n", + "external_ids {'isrc': 'GBU4B1100017'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/2H... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/2H7Y8wYixrSl... \n", + "id 2H7Y8wYixrSlKJoaZ1N2yl \n", + "instrumentalness 0.936 \n", + "key 0 \n", + "liveness 0.119 \n", + "loudness -7.97 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", + "mode 1 \n", + "name Bloom (Mark Pritchard Rmx) \n", + "original_lyrics NaN \n", + "popularity 38 \n", + "preview_url https://p.scdn.co/mp3-preview/7e51561e95c5a3aa... \n", + "sentiment NaN \n", + "speechiness 0.0325 \n", + "tempo 75.007 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/4sLGaMl33I6m... \n", - "track_number 6 \n", + "track_href https://api.spotify.com/v1/tracks/2H7Y8wYixrSl... \n", + "track_number 5 \n", "type audio_features \n", - "uri spotify:track:4sLGaMl33I6mcsk7u4xHAU \n", - "valence 0.0629 \n", + "uri spotify:track:2H7Y8wYixrSlKJoaZ1N2yl \n", + "valence 0.287 \n", "\n", " 6 \\\n", - "_id 4OrGm3fBdhlXuHtRBoLUMW \n", - "acousticness 0.885 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/4OrG... \n", + "_id 3zkFTfcboFcOdno0CHCmTc \n", + "acousticness 0.0955 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/3zkF... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.26 \n", + "complexity NaN \n", + "ctitle feral lone rmx \n", + "danceability 0.761 \n", "disc_number 1 \n", - "duration_ms 290067 \n", - "energy 0.264 \n", + "duration_ms 317507 \n", + "energy 0.877 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100009'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/4O... \n", - "href https://api.spotify.com/v1/tracks/4OrGm3fBdhlX... \n", - "id 4OrGm3fBdhlXuHtRBoLUMW \n", - "instrumentalness 0.0799 \n", + "external_ids {'isrc': 'GBU4B1100018'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/3z... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/3zkFTfcboFcO... \n", + "id 3zkFTfcboFcOdno0CHCmTc \n", + "instrumentalness 0.00018 \n", "key 7 \n", - "liveness 0.191 \n", - "loudness -12.279 \n", + "liveness 0.611 \n", + "loudness -7.806 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 1 \n", - "name Give Up The Ghost \n", - "popularity 45 \n", - "preview_url https://p.scdn.co/mp3-preview/16fb53b598cb153e... \n", - "speechiness 0.0299 \n", - "tempo 79.652 \n", + "name Feral (Lone RMX) \n", + "original_lyrics NaN \n", + "popularity 38 \n", + "preview_url https://p.scdn.co/mp3-preview/3d4ad1a19809193c... \n", + "sentiment NaN \n", + "speechiness 0.174 \n", + "tempo 134.938 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/4OrGm3fBdhlX... \n", - "track_number 7 \n", + "track_href https://api.spotify.com/v1/tracks/3zkFTfcboFcO... \n", + "track_number 6 \n", "type audio_features \n", - "uri spotify:track:4OrGm3fBdhlXuHtRBoLUMW \n", - "valence 0.157 \n", + "uri spotify:track:3zkFTfcboFcOdno0CHCmTc \n", + "valence 0.208 \n", "\n", " 7 \\\n", - "_id 2rA36OZNb3LkvqcNro1ugK \n", - "acousticness 0.0395 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 1DBkJIEoeHrTX4WCBQGcCi \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/2rA3... \n", + "_id 7KKglMFf5KV0PIDSAOqfnH \n", + "acousticness 0.0147 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/7KKg... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.693 \n", + "complexity NaN \n", + "ctitle morning mr magpie pearson sound scavenger rmx \n", + "danceability 0.481 \n", "disc_number 1 \n", - "duration_ms 319249 \n", - "energy 0.776 \n", + "duration_ms 278893 \n", + "energy 0.336 \n", "explicit False \n", - "external_ids {'isrc': 'GBU4B1100010'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/2r... \n", - "href https://api.spotify.com/v1/tracks/2rA36OZNb3Lk... \n", - "id 2rA36OZNb3LkvqcNro1ugK \n", - "instrumentalness 0.737 \n", - "key 3 \n", - "liveness 0.0884 \n", - "loudness -9.804 \n", + "external_ids {'isrc': 'GBU4B1100020'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/7K... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/7KKglMFf5KV0... \n", + "id 7KKglMFf5KV0PIDSAOqfnH \n", + "instrumentalness 0.834 \n", + "key 0 \n", + "liveness 0.232 \n", + "loudness -12.43 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 1 \n", - "name Separator \n", - "popularity 47 \n", - "preview_url https://p.scdn.co/mp3-preview/32f41947c08dae34... \n", - "speechiness 0.056 \n", - "tempo 113.808 \n", - "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/2rA36OZNb3Lk... \n", - "track_number 8 \n", + "name Morning Mr Magpie (Pearson Sound Scavenger RMX) \n", + "original_lyrics NaN \n", + "popularity 37 \n", + "preview_url https://p.scdn.co/mp3-preview/c62871a98cd382a0... \n", + "sentiment NaN \n", + "speechiness 0.0674 \n", + "tempo 132.035 \n", + "time_signature 3 \n", + "track_href https://api.spotify.com/v1/tracks/7KKglMFf5KV0... \n", + "track_number 7 \n", "type audio_features \n", - "uri spotify:track:2rA36OZNb3LkvqcNro1ugK \n", - "valence 0.666 \n", + "uri spotify:track:7KKglMFf5KV0PIDSAOqfnH \n", + "valence 0.0894 \n", "\n", " 8 \\\n", - "_id 3pcCifdPTc2BbqmWpEhtUd \n", - "acousticness 0.303 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 6vuykQgDLUCiZ7YggIpLM9 \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/3pcC... \n", + "_id 4raxzmnFq93jfKC8c3xcIv \n", + "acousticness 0.443 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/4rax... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.541 \n", + "complexity NaN \n", + "ctitle separator four tet rmx \n", + "danceability 0.461 \n", "disc_number 1 \n", - "duration_ms 220609 \n", - "energy 0.847 \n", + "duration_ms 423000 \n", + "energy 0.455 \n", "explicit False \n", - "external_ids {'isrc': 'GBBKS1600071'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/3p... \n", - "href https://api.spotify.com/v1/tracks/3pcCifdPTc2B... \n", - "id 3pcCifdPTc2BbqmWpEhtUd \n", - "instrumentalness 0.271 \n", - "key 11 \n", - "liveness 0.109 \n", - "loudness -6.52 \n", - "mode 1 \n", - "name Burn the Witch \n", - "popularity 62 \n", - "preview_url https://p.scdn.co/mp3-preview/c5b0b198ee3f0459... \n", - "speechiness 0.0297 \n", - "tempo 148.937 \n", + "external_ids {'isrc': 'GBU4B1100019'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/4r... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/4raxzmnFq93j... \n", + "id 4raxzmnFq93jfKC8c3xcIv \n", + "instrumentalness 0.641 \n", + "key 10 \n", + "liveness 0.0812 \n", + "loudness -12.403 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", + "mode 0 \n", + "name Separator (Four Tet RMX) \n", + "original_lyrics NaN \n", + "popularity 38 \n", + "preview_url https://p.scdn.co/mp3-preview/d7e13aaa8cf0f949... \n", + "sentiment NaN \n", + "speechiness 0.0716 \n", + "tempo 113.752 \n", "time_signature 4 \n", - "track_href https://api.spotify.com/v1/tracks/3pcCifdPTc2B... \n", - "track_number 1 \n", + "track_href https://api.spotify.com/v1/tracks/4raxzmnFq93j... \n", + "track_number 8 \n", "type audio_features \n", - "uri spotify:track:3pcCifdPTc2BbqmWpEhtUd \n", - "valence 0.625 \n", + "uri spotify:track:4raxzmnFq93jfKC8c3xcIv \n", + "valence 0.309 \n", "\n", " 9 \\\n", - "_id 1uRxyAup7OYrlh2SHJb80N \n", - "acousticness 0.968 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", - "album_id 6vuykQgDLUCiZ7YggIpLM9 \n", - "analysis_url https://api.spotify.com/v1/audio-analysis/1uRx... \n", + "_id 1gaAIZ4vGQ6QvDUgN2Xyus \n", + "acousticness 0.313 \n", + "album {'name': 'TKOL RMX 1234567', 'images': [{'widt... \n", + "album_id 47xaqCsJcYFWqD1gwujl1T \n", + "analysis_url https://api.spotify.com/v1/audio-analysis/1gaA... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", - "danceability 0.299 \n", + "complexity NaN \n", + "ctitle give up the ghost thriller houseghost remix \n", + "danceability 0.596 \n", "disc_number 1 \n", - "duration_ms 384439 \n", - "energy 0.263 \n", + "duration_ms 373760 \n", + "energy 0.894 \n", "explicit False \n", - "external_ids {'isrc': 'GBBKS1600072'} \n", - "external_urls {'spotify': 'https://open.spotify.com/track/1u... \n", - "href https://api.spotify.com/v1/tracks/1uRxyAup7OYr... \n", - "id 1uRxyAup7OYrlh2SHJb80N \n", - "instrumentalness 0.857 \n", - "key 9 \n", - "liveness 0.126 \n", - "loudness -13.207 \n", + "external_ids {'isrc': 'GBU4B1100031'} \n", + "external_urls {'spotify': 'https://open.spotify.com/track/1g... \n", + "gloom NaN \n", + "href https://api.spotify.com/v1/tracks/1gaAIZ4vGQ6Q... \n", + "id 1gaAIZ4vGQ6QvDUgN2Xyus \n", + "instrumentalness 0.849 \n", + "key 4 \n", + "liveness 0.115 \n", + "loudness -9.477 \n", + "lyrical_density NaN \n", + "lyrics NaN \n", "mode 0 \n", - "name Daydreaming \n", - "popularity 60 \n", - "preview_url https://p.scdn.co/mp3-preview/fbf970f6ee1e7d84... \n", - "speechiness 0.0323 \n", - "tempo 137.848 \n", - "time_signature 3 \n", - "track_href https://api.spotify.com/v1/tracks/1uRxyAup7OYr... \n", - "track_number 2 \n", + "name Give Up The Ghost (Thriller Houseghost Remix) \n", + "original_lyrics NaN \n", + "popularity 37 \n", + "preview_url https://p.scdn.co/mp3-preview/19cf8afa026a7449... \n", + "sentiment NaN \n", + "speechiness 0.102 \n", + "tempo 119.968 \n", + "time_signature 4 \n", + "track_href https://api.spotify.com/v1/tracks/1gaAIZ4vGQ6Q... \n", + "track_number 9 \n", "type audio_features \n", - "uri spotify:track:1uRxyAup7OYrlh2SHJb80N \n", - "valence 0.115 \n", + "uri spotify:track:1gaAIZ4vGQ6QvDUgN2Xyus \n", + "valence 0.145 \n", "\n", " ... \\\n", "_id ... \n", @@ -4915,6 +5692,8 @@ "artist_name ... \n", "artists ... \n", "available_markets ... \n", + "complexity ... \n", + "ctitle ... \n", "danceability ... \n", "disc_number ... \n", "duration_ms ... \n", @@ -4922,16 +5701,21 @@ "explicit ... \n", "external_ids ... \n", "external_urls ... \n", + "gloom ... \n", "href ... \n", "id ... \n", "instrumentalness ... \n", "key ... \n", "liveness ... \n", "loudness ... \n", + "lyrical_density ... \n", + "lyrics ... \n", "mode ... \n", "name ... \n", + "original_lyrics ... \n", "popularity ... \n", "preview_url ... \n", + "sentiment ... \n", "speechiness ... \n", "tempo ... \n", "time_signature ... \n", @@ -4944,13 +5728,15 @@ " 136 \\\n", "_id 71wIOoaoVMUwskK5yCXZL4 \n", "acousticness 0.000659 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/71wI... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle how do you \n", "danceability 0.185 \n", "disc_number 1 \n", "duration_ms 132173 \n", @@ -4958,16 +5744,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300105'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/71... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/71wIOoaoVMUw... \n", "id 71wIOoaoVMUwskK5yCXZL4 \n", "instrumentalness 0.879 \n", "key 9 \n", "liveness 0.107 \n", "loudness -8.316 \n", + "lyrical_density 0.76415 \n", + "lyrics he's bitter and twisted he knows what he wants... \n", "mode 1 \n", "name How Do You? \n", - "popularity 41 \n", + "original_lyrics \\n\\n[Verse 1]\\nHe's bitter and twisted\\nHe kno... \n", + "popularity 43 \n", "preview_url https://p.scdn.co/mp3-preview/b99a13688f7d39b0... \n", + "sentiment {'probability': {'pos': 0.7154238539707657, 'n... \n", "speechiness 0.084 \n", "tempo 147.362 \n", "time_signature 4 \n", @@ -4980,13 +5771,15 @@ " 137 \\\n", "_id 2zYmvi3w2T8a9Ckrv21bvW \n", "acousticness 0.000849 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/2zYm... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle stop whispering \n", "danceability 0.212 \n", "disc_number 1 \n", "duration_ms 325627 \n", @@ -4994,16 +5787,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300106'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/2z... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/2zYmvi3w2T8a... \n", "id 2zYmvi3w2T8a9Ckrv21bvW \n", "instrumentalness 0.0165 \n", "key 2 \n", "liveness 0.129 \n", "loudness -10.059 \n", + "lyrical_density 0.39616 \n", + "lyrics and the wise man said i don't want to hear you... \n", "mode 1 \n", "name Stop Whispering \n", - "popularity 44 \n", + "original_lyrics \\n\\n[Verse 1]\\nAnd the wise man said I don't w... \n", + "popularity 45 \n", "preview_url https://p.scdn.co/mp3-preview/397951413134fe02... \n", + "sentiment {'probability': {'pos': 0.14401774438176765, '... \n", "speechiness 0.0472 \n", "tempo 122.37 \n", "time_signature 4 \n", @@ -5016,13 +5814,15 @@ " 138 \\\n", "_id 3ovbSnT5NNhl1gzMcw1NRZ \n", "acousticness 0.704 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/3ovb... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle thinking about you \n", "danceability 0.364 \n", "disc_number 1 \n", "duration_ms 161533 \n", @@ -5030,16 +5830,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9200114'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/3o... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/3ovbSnT5NNhl... \n", "id 3ovbSnT5NNhl1gzMcw1NRZ \n", "instrumentalness 7.71e-06 \n", "key 7 \n", "liveness 0.0883 \n", "loudness -14.134 \n", + "lyrical_density 1.15147 \n", + "lyrics been thinking about you your records are here ... \n", "mode 1 \n", "name Thinking About You \n", - "popularity 45 \n", + "original_lyrics \\n\\n[Verse 1]\\nBeen thinking about you\\nYour r... \n", + "popularity 46 \n", "preview_url https://p.scdn.co/mp3-preview/ec90a4cef1ff0cbf... \n", + "sentiment {'probability': {'pos': 0.20834015470559455, '... \n", "speechiness 0.0331 \n", "tempo 103.44 \n", "time_signature 4 \n", @@ -5052,13 +5857,15 @@ " 139 \\\n", "_id 4NUc1M0CS7b6zvWoyvibju \n", "acousticness 0.000101 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/4NUc... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle anyone can play guitar \n", "danceability 0.294 \n", "disc_number 1 \n", "duration_ms 217800 \n", @@ -5066,16 +5873,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300107'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/4N... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/4NUc1M0CS7b6... \n", "id 4NUc1M0CS7b6zvWoyvibju \n", "instrumentalness 0.000756 \n", "key 4 \n", "liveness 0.333 \n", "loudness -10.772 \n", + "lyrical_density 0.688705 \n", + "lyrics destiny, destiny protect me from the world des... \n", "mode 0 \n", "name Anyone Can Play Guitar \n", - "popularity 45 \n", + "original_lyrics \\n\\n[Verse 1]\\nDestiny, destiny protect me fro... \n", + "popularity 46 \n", "preview_url https://p.scdn.co/mp3-preview/76e430500d399da2... \n", + "sentiment {'probability': {'pos': 0.37346493338226217, '... \n", "speechiness 0.0547 \n", "tempo 150.845 \n", "time_signature 4 \n", @@ -5088,13 +5900,15 @@ " 140 \\\n", "_id 4nklmaiY4gfQI3SB1sLGsd \n", "acousticness 1.93e-05 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/4nkl... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle ripcord \n", "danceability 0.256 \n", "disc_number 1 \n", "duration_ms 189733 \n", @@ -5102,16 +5916,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300108'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/4n... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/4nklmaiY4gfQ... \n", "id 4nklmaiY4gfQI3SB1sLGsd \n", "instrumentalness 0.366 \n", "key 2 \n", "liveness 0.322 \n", "loudness -10.436 \n", + "lyrical_density 0.479621 \n", + "lyrics soul destroyed with clever toys for little boy... \n", "mode 1 \n", "name Ripcord \n", - "popularity 39 \n", + "original_lyrics \\n\\n[Verse 1]\\nSoul destroyed with clever toys... \n", + "popularity 40 \n", "preview_url https://p.scdn.co/mp3-preview/a519caf188516bc5... \n", + "sentiment {'probability': {'pos': 0.34086279665703845, '... \n", "speechiness 0.0548 \n", "tempo 137.949 \n", "time_signature 4 \n", @@ -5124,13 +5943,15 @@ " 141 \\\n", "_id 11qDTSr3Dj4TkPnBcIOqEJ \n", "acousticness 0.00281 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/11qD... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle vegetable \n", "danceability 0.384 \n", "disc_number 1 \n", "duration_ms 192667 \n", @@ -5138,16 +5959,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300109'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/11... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/11qDTSr3Dj4T... \n", "id 11qDTSr3Dj4TkPnBcIOqEJ \n", "instrumentalness 0.569 \n", "key 6 \n", "liveness 0.187 \n", "loudness -8.868 \n", + "lyrical_density 0.711075 \n", + "lyrics i never wanted anything but this i worked hard... \n", "mode 1 \n", "name Vegetable \n", - "popularity 39 \n", + "original_lyrics \\n\\n[Verse 1]\\nI never wanted anything but thi... \n", + "popularity 40 \n", "preview_url https://p.scdn.co/mp3-preview/22dd1bf01746cb6d... \n", + "sentiment {'probability': {'pos': 0.11670905100312225, '... \n", "speechiness 0.0339 \n", "tempo 105.852 \n", "time_signature 4 \n", @@ -5160,13 +5986,15 @@ " 142 \\\n", "_id 4D6ZExVvYLZxhcAvifX5px \n", "acousticness 0.000849 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/4D6Z... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle prove yourself \n", "danceability 0.25 \n", "disc_number 1 \n", "duration_ms 145373 \n", @@ -5174,16 +6002,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9200115'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/4D... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/4D6ZExVvYLZx... \n", "id 4D6ZExVvYLZxhcAvifX5px \n", "instrumentalness 0.0848 \n", "key 0 \n", "liveness 0.175 \n", "loudness -10.915 \n", + "lyrical_density 0.749795 \n", + "lyrics i can't afford to breathe in this time nowhere... \n", "mode 1 \n", "name Prove Yourself \n", - "popularity 38 \n", + "original_lyrics \\n\\n[Verse 1]\\nI can't afford to breathe in th... \n", + "popularity 40 \n", "preview_url https://p.scdn.co/mp3-preview/6d62fc6cd2849212... \n", + "sentiment {'probability': {'pos': 0.1849939345419322, 'n... \n", "speechiness 0.0611 \n", "tempo 114.098 \n", "time_signature 4 \n", @@ -5196,13 +6029,15 @@ " 143 \\\n", "_id 48IEDejXX5LH8TAC3VIGpc \n", "acousticness 0.00968 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/48IE... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle i cant \n", "danceability 0.284 \n", "disc_number 1 \n", "duration_ms 253093 \n", @@ -5210,16 +6045,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300110'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/48... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/48IEDejXX5LH... \n", "id 48IEDejXX5LH8TAC3VIGpc \n", "instrumentalness 0.3 \n", "key 7 \n", "liveness 0.118 \n", "loudness -10.256 \n", + "lyrical_density 0.56501 \n", + "lyrics please forget the words that i just blurted ou... \n", "mode 1 \n", "name I Can't \n", - "popularity 38 \n", + "original_lyrics \\n\\n[Verse 1]\\nPlease forget the words that I ... \n", + "popularity 39 \n", "preview_url https://p.scdn.co/mp3-preview/516d9e9499a86318... \n", + "sentiment {'probability': {'pos': 0.15026967254930432, '... \n", "speechiness 0.0595 \n", "tempo 106.108 \n", "time_signature 4 \n", @@ -5232,13 +6072,15 @@ " 144 \\\n", "_id 2B5P22cfUadACK7jLQegU6 \n", "acousticness 0.000135 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/2B5P... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle lurgee \n", "danceability 0.42 \n", "disc_number 1 \n", "duration_ms 187867 \n", @@ -5246,16 +6088,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9200116'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/2B... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/2B5P22cfUadA... \n", "id 2B5P22cfUadACK7jLQegU6 \n", "instrumentalness 0.399 \n", "key 0 \n", "liveness 0.111 \n", "loudness -12.298 \n", + "lyrical_density 0.399221 \n", + "lyrics i feel better i feel better now you've gone i ... \n", "mode 1 \n", "name Lurgee \n", - "popularity 38 \n", + "original_lyrics \\n\\n[Verse 1]\\nI feel better\\nI feel better no... \n", + "popularity 40 \n", "preview_url https://p.scdn.co/mp3-preview/ae0de4e9b90a15a7... \n", + "sentiment {'probability': {'pos': 0.262975963283913, 'ne... \n", "speechiness 0.0268 \n", "tempo 101.9 \n", "time_signature 4 \n", @@ -5268,13 +6115,15 @@ " 145 \n", "_id 6qttbImnJ5wuA8AtDKEy18 \n", "acousticness 0.000465 \n", - "album {'artists': [{'href': 'https://api.spotify.com... \n", + "album {'name': 'Pablo Honey', 'images': [{'width': 6... \n", "album_id 6400dnyeDyD2mIFHfkwHXN \n", "analysis_url https://api.spotify.com/v1/audio-analysis/6qtt... \n", "artist_id 4Z8W4fKeB5YxbusRsdQVPb \n", "artist_name Radiohead \n", - "artists [{'href': 'https://api.spotify.com/v1/artists/... \n", + "artists [{'name': 'Radiohead', 'id': '4Z8W4fKeB5YxbusR... \n", "available_markets [AD, AR, AT, AU, BE, BG, BO, BR, CA, CH, CL, C... \n", + "complexity NaN \n", + "ctitle blow out \n", "danceability 0.284 \n", "disc_number 1 \n", "duration_ms 282067 \n", @@ -5282,16 +6131,21 @@ "explicit False \n", "external_ids {'isrc': 'GBAYE9300111'} \n", "external_urls {'spotify': 'https://open.spotify.com/track/6q... \n", + "gloom NaN \n", "href https://api.spotify.com/v1/tracks/6qttbImnJ5wu... \n", "id 6qttbImnJ5wuA8AtDKEy18 \n", "instrumentalness 0.382 \n", "key 11 \n", "liveness 0.24 \n", "loudness -10.739 \n", + "lyrical_density 0.340346 \n", + "lyrics in my mind and nailed into my heels all the ti... \n", "mode 0 \n", "name Blow Out \n", - "popularity 39 \n", + "original_lyrics \\n\\n[Verse 1]\\nIn my mind\\nAnd nailed into my ... \n", + "popularity 41 \n", "preview_url https://p.scdn.co/mp3-preview/69a5564e6733d6d2... \n", + "sentiment {'probability': {'pos': 0.3796885990250341, 'n... \n", "speechiness 0.0506 \n", "tempo 141.539 \n", "time_signature 4 \n", @@ -5301,10 +6155,10 @@ "uri spotify:track:6qttbImnJ5wuA8AtDKEy18 \n", "valence 0.287 \n", "\n", - "[34 rows x 146 columns]" + "[41 rows x 146 columns]" ] }, - "execution_count": 56, + "execution_count": 11, "metadata": {}, "output_type": "execute_result" } @@ -5323,7 +6177,7 @@ }, { "cell_type": "code", - "execution_count": 59, + "execution_count": 12, "metadata": { "collapsed": false }, @@ -5331,18 +6185,18 @@ { "data": { "text/plain": [ - "15 rows × 611 columns
\n", + "18 rows × 1071 columns
\n", "" ], "text/plain": [ - " 0 \\\n", - "_id 210353 \n", + " 0 \\\n", + "_id 1497768 \n", "annotation_count 1 \n", - "api_path /songs/210353 \n", - "full_title 1822! by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Live%20at%2... \n", - "header_image_url https://s3.amazonaws.com/rapgenius/Live%20at%2... \n", - "id 210353 \n", - "lyrics_owner_id 225680 \n", - "path /The-beatles-1822-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/1497768 \n", + "ctitle NaN \n", + "full_title All Together on the Wireless Machine by The Be... \n", + "header_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "header_image_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "id 1497768 \n", + "lyrics NaN \n", + "lyrics_owner_id 1549345 \n", + "original_lyrics NaN \n", + "path /The-beatles-all-together-on-the-wireless-mach... \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Live%20at%2... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title 1822! \n", - "url https://genius.com/The-beatles-1822-lyrics \n", - "\n", - " 1 \\\n", - "_id 123444 \n", - "annotation_count 12 \n", - "api_path /songs/123444 \n", - "full_title Across the Universe by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/the_beatles... \n", - "header_image_url https://s3.amazonaws.com/rapgenius/the_beatles... \n", - "id 123444 \n", - "lyrics_owner_id 22533 \n", - "path /The-beatles-across-the-universe-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 18 \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/the_beatles... \n", - "stats {'hot': False, 'unreviewed_annotations': 0, 'p... \n", - "title Across the Universe \n", - "url https://genius.com/The-beatles-across-the-univ... \n", + "song_art_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title All Together on the Wireless Machine \n", + "url https://genius.com/The-beatles-all-together-on... \n", "\n", - " 2 \\\n", - "_id 1679385 \n", + " 1 \\\n", + "_id 210315 \n", "annotation_count 1 \n", - "api_path /songs/1679385 \n", - "full_title Across the Universe (Wildlife Version) by The ... \n", - "header_image_thumbnail_url https://images.genius.com/a3463161b8063164d2e3... \n", - "header_image_url https://images.genius.com/a3463161b8063164d2e3... \n", - "id 1679385 \n", - "lyrics_owner_id 1549345 \n", - "path /The-beatles-across-the-universe-wildlife-vers... \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/210315 \n", + "ctitle NaN \n", + "full_title A Little Rhyme by The Beatles (Ft. John & Rodn... \n", + "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", + "header_image_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", + "id 210315 \n", + "lyrics NaN \n", + "lyrics_owner_id 250962 \n", + "original_lyrics NaN \n", + "path /The-beatles-a-little-rhyme-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/a3463161b8063164d2e3... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Across the Universe (Wildlife Version) \n", - "url https://genius.com/The-beatles-across-the-univ... \n", + "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title A Little Rhyme \n", + "url https://genius.com/The-beatles-a-little-rhyme-... \n", "\n", - " 3 \\\n", - "_id 123816 \n", + " 2 \\\n", + "_id 123533 \n", "annotation_count 5 \n", - "api_path /songs/123816 \n", - "full_title Act Naturally by The Beatles \n", - "header_image_thumbnail_url https://images.genius.com/adbf27acc77a06acfa4a... \n", - "header_image_url https://images.genius.com/adbf27acc77a06acfa4a... \n", - "id 123816 \n", - "lyrics_owner_id 22533 \n", - "path /The-beatles-act-naturally-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 2 \n", - "song_art_image_thumbnail_url https://images.genius.com/adbf27acc77a06acfa4a... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Act Naturally \n", - "url https://genius.com/The-beatles-act-naturally-l... \n", - "\n", - " 4 \\\n", - "_id 1436 \n", - "annotation_count 19 \n", - "api_path /songs/1436 \n", - "full_title A Day In the Life by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/The-Beatles... \n", - "header_image_url https://s3.amazonaws.com/rapgenius/The-Beatles... \n", - "id 1436 \n", - "lyrics_owner_id 7 \n", - "path /The-beatles-a-day-in-the-life-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 34 \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/The-Beatles... \n", - "stats {'hot': False, 'unreviewed_annotations': 0, 'p... \n", - "title A Day In the Life \n", - "url https://genius.com/The-beatles-a-day-in-the-li... \n", + "api_path /songs/123533 \n", + "ctitle NaN \n", + "full_title And I Love Her by The Beatles \n", + "header_image_thumbnail_url https://images.genius.com/68c11c7f5b6b66194d77... \n", + "header_image_url https://images.genius.com/68c11c7f5b6b66194d77... \n", + "id 123533 \n", + "lyrics NaN \n", + "lyrics_owner_id 46871 \n", + "original_lyrics NaN \n", + "path /The-beatles-and-i-love-her-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", + "pyongs_count 15 \n", + "song_art_image_thumbnail_url https://images.genius.com/68c11c7f5b6b66194d77... \n", + "stats {'unreviewed_annotations': 0, 'hot': False, 'p... \n", + "title And I Love Her \n", + "url https://genius.com/The-beatles-and-i-love-her-... \n", "\n", - " 5 \\\n", - "_id 118166 \n", - "annotation_count 13 \n", - "api_path /songs/118166 \n", - "full_title A Hard Day's Night by The Beatles \n", + " 3 \\\n", + "_id 123537 \n", + "annotation_count 4 \n", + "api_path /songs/123537 \n", + "ctitle NaN \n", + "full_title Any Time at All by The Beatles \n", "header_image_thumbnail_url https://images.genius.com/68c11c7f5b6b66194d77... \n", "header_image_url https://images.genius.com/68c11c7f5b6b66194d77... \n", - "id 118166 \n", - "lyrics_owner_id 1553 \n", - "path /The-beatles-a-hard-days-night-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 4 \n", + "id 123537 \n", + "lyrics NaN \n", + "lyrics_owner_id 46871 \n", + "original_lyrics NaN \n", + "path /The-beatles-any-time-at-all-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", + "pyongs_count 2 \n", "song_art_image_thumbnail_url https://images.genius.com/68c11c7f5b6b66194d77... \n", - "stats {'hot': False, 'unreviewed_annotations': 0, 'p... \n", - "title A Hard Day's Night \n", - "url https://genius.com/The-beatles-a-hard-days-nig... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Any Time at All \n", + "url https://genius.com/The-beatles-any-time-at-all... \n", "\n", - " 6 \\\n", - "_id 210540 \n", - "annotation_count 0 \n", - "api_path /songs/210540 \n", - "full_title Ain't She Sweet by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/view.jpg \n", - "header_image_url https://s3.amazonaws.com/rapgenius/view.jpg \n", - "id 210540 \n", - "lyrics_owner_id 250962 \n", - "path /The-beatles-aint-she-sweet-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + " 4 \\\n", + "_id 117722 \n", + "annotation_count 6 \n", + "api_path /songs/117722 \n", + "ctitle NaN \n", + "full_title A Taste of Honey by The Beatles \n", + "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/1360709432_... \n", + "header_image_url https://s3.amazonaws.com/rapgenius/1360709432_... \n", + "id 117722 \n", + "lyrics NaN \n", + "lyrics_owner_id 70799 \n", + "original_lyrics NaN \n", + "path /The-beatles-a-taste-of-honey-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/view.jpg \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Ain't She Sweet \n", - "url https://genius.com/The-beatles-aint-she-sweet-... \n", + "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/1360709432_... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title A Taste of Honey \n", + "url https://genius.com/The-beatles-a-taste-of-hone... \n", "\n", - " 7 \\\n", - "_id 210315 \n", + " 5 \\\n", + "_id 210284 \n", "annotation_count 1 \n", - "api_path /songs/210315 \n", - "full_title A Little Rhyme by The Beatles (Ft. John & Rodn... \n", + "api_path /songs/210284 \n", + "ctitle NaN \n", + "full_title Beatle Greetings by The Beatles (Ft. George Ha... \n", "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", "header_image_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", - "id 210315 \n", + "id 210284 \n", + "lyrics NaN \n", "lyrics_owner_id 250962 \n", - "path /The-beatles-a-little-rhyme-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "original_lyrics NaN \n", + "path /The-beatles-beatle-greetings-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", "pyongs_count NaN \n", "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/110537_cda_... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title A Little Rhyme \n", - "url https://genius.com/The-beatles-a-little-rhyme-... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Beatle Greetings \n", + "url https://genius.com/The-beatles-beatle-greeting... \n", "\n", - " 8 \\\n", - "_id 123414 \n", + " 6 \\\n", + "_id 1336394 \n", "annotation_count 1 \n", - "api_path /songs/123414 \n", - "full_title All I've Got to Do by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "header_image_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "id 123414 \n", - "lyrics_owner_id 22533 \n", - "path /The-beatles-all-ive-got-to-do-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/1336394 \n", + "ctitle NaN \n", + "full_title Can You Take Me Back by The Beatles \n", + "header_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "header_image_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "id 1336394 \n", + "lyrics NaN \n", + "lyrics_owner_id 1549345 \n", + "original_lyrics NaN \n", + "path /The-beatles-can-you-take-me-back-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Can You Take Me Back \n", + "url https://genius.com/The-beatles-can-you-take-me... \n", + "\n", + " 7 \\\n", + "_id 107915 \n", + "annotation_count 6 \n", + "api_path /songs/107915 \n", + "ctitle NaN \n", + "full_title Carry That Weight by The Beatles \n", + "header_image_thumbnail_url https://images.genius.com/560d707ac51a528c952d... \n", + "header_image_url https://images.genius.com/560d707ac51a528c952d... \n", + "id 107915 \n", + "lyrics NaN \n", + "lyrics_owner_id 116340 \n", + "original_lyrics NaN \n", + "path /The-beatles-carry-that-weight-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", "pyongs_count 1 \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title All I've Got to Do \n", - "url https://genius.com/The-beatles-all-ive-got-to-... \n", + "song_art_image_thumbnail_url https://images.genius.com/560d707ac51a528c952d... \n", + "stats {'unreviewed_annotations': 0, 'hot': False, 'p... \n", + "title Carry That Weight \n", + "url https://genius.com/The-beatles-carry-that-weig... \n", "\n", - " 9 \\\n", - "_id 123415 \n", - "annotation_count 4 \n", - "api_path /songs/123415 \n", - "full_title All My Loving by The Beatles \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "header_image_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "id 123415 \n", + " 8 \\\n", + "_id 1308579 \n", + "annotation_count 1 \n", + "api_path /songs/1308579 \n", + "ctitle NaN \n", + "full_title Down in Eastern Australia by The Beatles \n", + "header_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "header_image_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "id 1308579 \n", + "lyrics NaN \n", + "lyrics_owner_id 1549345 \n", + "original_lyrics NaN \n", + "path /The-beatles-down-in-eastern-australia-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/ad1f59e8a03be4eb521e... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Down in Eastern Australia \n", + "url https://genius.com/The-beatles-down-in-eastern... \n", + "\n", + " 9 \\\n", + "_id 123808 \n", + "annotation_count 1 \n", + "api_path /songs/123808 \n", + "ctitle NaN \n", + "full_title Everybody's Trying to Be My Baby by The Beatles \n", + "header_image_thumbnail_url https://images.genius.com/4268a08d2b36372eb6e8... \n", + "header_image_url https://images.genius.com/4268a08d2b36372eb6e8... \n", + "id 123808 \n", + "lyrics NaN \n", "lyrics_owner_id 22533 \n", - "path /The-beatles-all-my-loving-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 4 \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/Beatles2.jpg \n", - "stats {'hot': False, 'unreviewed_annotations': 0, 'p... \n", - "title All My Loving \n", - "url https://genius.com/The-beatles-all-my-loving-l... \n", + "original_lyrics NaN \n", + "path /The-beatles-everybodys-trying-to-be-my-baby-l... \n", + "primary_artist {'image_url': 'https://images.genius.com/ad1f5... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/4268a08d2b36372eb6e8... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Everybody's Trying to Be My Baby \n", + "url https://genius.com/The-beatles-everybodys-tryi... \n", "\n", " ... \\\n", "_id ... \n", "annotation_count ... \n", "api_path ... \n", + "ctitle ... \n", "full_title ... \n", "header_image_thumbnail_url ... \n", "header_image_url ... \n", "id ... \n", + "lyrics ... \n", "lyrics_owner_id ... \n", + "original_lyrics ... \n", "path ... \n", "primary_artist ... \n", "pyongs_count ... \n", @@ -6188,180 +7147,210 @@ "title ... \n", "url ... \n", "\n", - " 601 \\\n", - "_id 2853637 \n", - "annotation_count 0 \n", - "api_path /songs/2853637 \n", - "full_title Where Bluebirds Fly by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/8ae50c3392a15c9c558c... \n", - "header_image_url https://images.genius.com/8ae50c3392a15c9c558c... \n", - "id 2853637 \n", - "lyrics_owner_id 2726776 \n", - "path /Radiohead-where-bluebirds-fly-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/8ae50c3392a15c9c558c... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Where Bluebirds Fly \n", - "url https://genius.com/Radiohead-where-bluebirds-f... \n", - "\n", - " 602 \\\n", - "_id 115809 \n", + " 1061 \\\n", + "_id 81705 \n", "annotation_count 7 \n", - "api_path /songs/115809 \n", - "full_title Where I End and You Begin by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/5ccb8a89b0f674962982... \n", - "header_image_url https://images.genius.com/5ccb8a89b0f674962982... \n", - "id 115809 \n", - "lyrics_owner_id 2726776 \n", - "path /Radiohead-where-i-end-and-you-begin-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 5 \n", - "song_art_image_thumbnail_url https://images.genius.com/5ccb8a89b0f674962982... \n", - "stats {'hot': False, 'unreviewed_annotations': 2, 'p... \n", - "title Where I End and You Begin \n", - "url https://genius.com/Radiohead-where-i-end-and-y... \n", + "api_path /songs/81705 \n", + "ctitle you cant always get what you want \n", + "full_title You Can't Always Get What You Want by The Roll... \n", + "header_image_thumbnail_url https://images.genius.com/7e75133e0e4017798a7a... \n", + "header_image_url https://images.genius.com/7e75133e0e4017798a7a... \n", + "id 81705 \n", + "lyrics i saw her today at the reception a glass of wi... \n", + "lyrics_owner_id 779 \n", + "original_lyrics \\n\\n[Intro: London Bach Choir]\\nI saw her toda... \n", + "path /The-rolling-stones-you-cant-always-get-what-y... \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count 15 \n", + "song_art_image_thumbnail_url https://images.genius.com/7e75133e0e4017798a7a... \n", + "stats {'unreviewed_annotations': 0, 'hot': False, 'p... \n", + "title You Can't Always Get What You Want \n", + "url https://genius.com/The-rolling-stones-you-cant... \n", "\n", - " 603 \\\n", - "_id 1205907 \n", + " 1062 \\\n", + "_id 310483 \n", "annotation_count 1 \n", - "api_path /songs/1205907 \n", - "full_title Wicked Child by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "header_image_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "id 1205907 \n", - "lyrics_owner_id 1549345 \n", - "path /Radiohead-wicked-child-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/310483 \n", + "ctitle you cant catch me \n", + "full_title You Can't Catch Me by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/9c0263f14c39b6df59e5... \n", + "header_image_url https://images.genius.com/9c0263f14c39b6df59e5... \n", + "id 310483 \n", + "lyrics i bought a brand new air mobile it was custom ... \n", + "lyrics_owner_id 354383 \n", + "original_lyrics \\n\\n[Verse 1]\\nI bought a brand new air mobile... \n", + "path /The-rolling-stones-you-cant-catch-me-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Wicked Child \n", - "url https://genius.com/Radiohead-wicked-child-lyrics \n", + "song_art_image_thumbnail_url https://images.genius.com/9c0263f14c39b6df59e5... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title You Can't Catch Me \n", + "url https://genius.com/The-rolling-stones-you-cant... \n", "\n", - " 604 \\\n", - "_id 1383236 \n", + " 1063 \\\n", + "_id 313269 \n", "annotation_count 1 \n", - "api_path /songs/1383236 \n", - "full_title Wish You Were Here by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "header_image_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "id 1383236 \n", - "lyrics_owner_id 1549345 \n", - "path /Radiohead-wish-you-were-here-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/313269 \n", + "ctitle you dont have to mean it \n", + "full_title You Don't Have To Mean It by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/eb7fd9257058b77179cb... \n", + "header_image_url https://images.genius.com/eb7fd9257058b77179cb... \n", + "id 313269 \n", + "lyrics you don't have to mean it you just got to say ... \n", + "lyrics_owner_id 354608 \n", + "original_lyrics \\n\\n[Verse 1]\\nYou don't have to mean it\\nYou ... \n", + "path /The-rolling-stones-you-dont-have-to-mean-it-l... \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Wish You Were Here \n", - "url https://genius.com/Radiohead-wish-you-were-her... \n", + "song_art_image_thumbnail_url https://images.genius.com/eb7fd9257058b77179cb... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title You Don't Have To Mean It \n", + "url https://genius.com/The-rolling-stones-you-dont... \n", "\n", - " 605 \\\n", - "_id 1081664 \n", + " 1064 \\\n", + "_id 313043 \n", "annotation_count 1 \n", - "api_path /songs/1081664 \n", - "full_title Wonderwall by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "header_image_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "id 1081664 \n", - "lyrics_owner_id 1549345 \n", - "path /Radiohead-wonderwall-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + "api_path /songs/313043 \n", + "ctitle you got me rocking \n", + "full_title You Got Me Rocking by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/a8ed1f93846da84943a7... \n", + "header_image_url https://images.genius.com/a8ed1f93846da84943a7... \n", + "id 313043 \n", + "lyrics i was a butcher cutting up meat my hands were ... \n", + "lyrics_owner_id 354382 \n", + "original_lyrics \\n\\n[Verse 1]\\nI was a butcher\\nCutting up mea... \n", + "path /The-rolling-stones-you-got-me-rocking-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/25efaa8c220fdcfec8a9... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Wonderwall \n", - "url https://genius.com/Radiohead-wonderwall-lyrics \n", + "song_art_image_thumbnail_url https://images.genius.com/a8ed1f93846da84943a7... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title You Got Me Rocking \n", + "url https://genius.com/The-rolling-stones-you-got-... \n", "\n", - " 606 \\\n", - "_id 350065 \n", - "annotation_count 12 \n", - "api_path /songs/350065 \n", - "full_title Worrywort by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/e4bdb3ab980f0f1b6ce4... \n", - "header_image_url https://images.genius.com/e4bdb3ab980f0f1b6ce4... \n", - "id 350065 \n", - "lyrics_owner_id 428027 \n", - "path /Radiohead-worrywort-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", + " 1065 \\\n", + "_id 2389345 \n", + "annotation_count 4 \n", + "api_path /songs/2389345 \n", + "ctitle you got the silver \n", + "full_title You Got the Silver by The Rolling Stones (Ft. ... \n", + "header_image_thumbnail_url https://images.rapgenius.com/ac969979ccb91a0d2... \n", + "header_image_url https://images.rapgenius.com/ac969979ccb91a0d2... \n", + "id 2389345 \n", + "lyrics hey babe, what's in your eyes? i saw them flas... \n", + "lyrics_owner_id 1217557 \n", + "original_lyrics \\n\\n[Verse 1]\\nHey babe, what's in your eyes?\\... \n", + "path /The-rolling-stones-you-got-the-silver-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.genius.com/e4bdb3ab980f0f1b6ce4... \n", - "stats {'hot': False, 'unreviewed_annotations': 11} \n", - "title Worrywort \n", - "url https://genius.com/Radiohead-worrywort-lyrics \n", + "song_art_image_thumbnail_url https://images.rapgenius.com/ac969979ccb91a0d2... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title You Got the Silver \n", + "url https://genius.com/The-rolling-stones-you-got-... \n", "\n", - " 607 \\\n", - "_id 1226422 \n", + " 1066 \\\n", + "_id 1245984 \n", "annotation_count 1 \n", - "api_path /songs/1226422 \n", - "full_title Yes I Am by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/6b45ffa7fd55970e6411... \n", - "header_image_url https://images.genius.com/6b45ffa7fd55970e6411... \n", - "id 1226422 \n", + "api_path /songs/1245984 \n", + "ctitle dont look back \n", + "full_title Don't Look Back by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/23bbf05f7ee8286a8905... \n", + "header_image_url https://images.genius.com/23bbf05f7ee8286a8905... \n", + "id 1245984 \n", + "lyrics if it's love that you're running from there's ... \n", "lyrics_owner_id 1549345 \n", - "path /Radiohead-yes-i-am-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 2 \n", - "song_art_image_thumbnail_url https://images.genius.com/6b45ffa7fd55970e6411... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title Yes I Am \n", - "url https://genius.com/Radiohead-yes-i-am-lyrics \n", + "original_lyrics \\n\\nIf it's love that you're running from\\nThe... \n", + "path /The-rolling-stones-dont-look-back-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/23bbf05f7ee8286a8905... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Don't Look Back \n", + "url https://genius.com/The-rolling-stones-dont-loo... \n", "\n", - " 608 \\\n", - "_id 98114 \n", - "annotation_count 6 \n", - "api_path /songs/98114 \n", - "full_title You by Radiohead \n", - "header_image_thumbnail_url https://images.genius.com/6c0cb1c55fc88c941dac... \n", - "header_image_url https://images.genius.com/6c0cb1c55fc88c941dac... \n", - "id 98114 \n", - "lyrics_owner_id 116170 \n", - "path /Radiohead-you-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 1 \n", - "song_art_image_thumbnail_url https://images.genius.com/6c0cb1c55fc88c941dac... \n", - "stats {'hot': False, 'unreviewed_annotations': 1} \n", - "title You \n", - "url https://genius.com/Radiohead-you-lyrics \n", + " 1067 \\\n", + "_id 311907 \n", + "annotation_count 1 \n", + "api_path /songs/311907 \n", + "ctitle each and every day of the year \n", + "full_title Each and every day of the year by The Rolling ... \n", + "header_image_thumbnail_url https://images.genius.com/6c322c96140487d56076... \n", + "header_image_url https://images.genius.com/6c322c96140487d56076... \n", + "id 311907 \n", + "lyrics do i miss her kiss at night time arms around m... \n", + "lyrics_owner_id 354385 \n", + "original_lyrics \\n\\n[Verse 1]\\nDo I miss her kiss at night tim... \n", + "path /The-rolling-stones-each-and-every-day-of-the-... \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/6c322c96140487d56076... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Each and every day of the year \n", + "url https://genius.com/The-rolling-stones-each-and... \n", "\n", - " 609 \\\n", - "_id 114477 \n", + " 1068 \\\n", + "_id 310293 \n", "annotation_count 4 \n", - "api_path /songs/114477 \n", - "full_title You and Whose Army? by Radiohead \n", - "header_image_thumbnail_url https://s3.amazonaws.com/rapgenius/1359924238_... \n", - "header_image_url https://s3.amazonaws.com/rapgenius/1359924238_... \n", - "id 114477 \n", - "lyrics_owner_id 116340 \n", - "path /Radiohead-you-and-whose-army-lyrics \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count 4 \n", - "song_art_image_thumbnail_url https://s3.amazonaws.com/rapgenius/1359924238_... \n", - "stats {'hot': False, 'unreviewed_annotations': 0, 'p... \n", - "title You and Whose Army? \n", - "url https://genius.com/Radiohead-you-and-whose-arm... \n", + "api_path /songs/310293 \n", + "ctitle im a king bee \n", + "full_title I'm A King Bee by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/076d49bcc219432b68b4... \n", + "header_image_url https://images.genius.com/076d49bcc219432b68b4... \n", + "id 310293 \n", + "lyrics well i am a king bee buzzing around your hive ... \n", + "lyrics_owner_id 354383 \n", + "original_lyrics \\n\\n[Chorus]\\nWell I am a king bee\\nBuzzing ar... \n", + "path /The-rolling-stones-im-a-king-bee-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/076d49bcc219432b68b4... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title I'm A King Bee \n", + "url https://genius.com/The-rolling-stones-im-a-kin... \n", + "\n", + " 1069 \\\n", + "_id 310289 \n", + "annotation_count 1 \n", + "api_path /songs/310289 \n", + "ctitle little by little \n", + "full_title Little By Little by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/076d49bcc219432b68b4... \n", + "header_image_url https://images.genius.com/076d49bcc219432b68b4... \n", + "id 310289 \n", + "lyrics tried to trail you last night, baby, trail you... \n", + "lyrics_owner_id 354383 \n", + "original_lyrics \\n\\n[Verse 1]\\nTried to trail you last night, ... \n", + "path /The-rolling-stones-little-by-little-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count NaN \n", + "song_art_image_thumbnail_url https://images.genius.com/076d49bcc219432b68b4... \n", + "stats {'unreviewed_annotations': 0, 'hot': False} \n", + "title Little By Little \n", + "url https://genius.com/The-rolling-stones-little-b... \n", "\n", - " 610 \n", - "_id 642622 \n", - "annotation_count 1 \n", - "api_path /songs/642622 \n", - "full_title You Never Wash Up After Yourself by Radiohead \n", - "header_image_thumbnail_url https://images.rapgenius.com/0d14d86aec456da16... \n", - "header_image_url https://images.rapgenius.com/0d14d86aec456da16... \n", - "id 642622 \n", - "lyrics_owner_id 1158811 \n", - "path /Radiohead-you-never-wash-up-after-yourself-ly... \n", - "primary_artist {'is_meme_verified': False, 'header_image_url'... \n", - "pyongs_count NaN \n", - "song_art_image_thumbnail_url https://images.rapgenius.com/0d14d86aec456da16... \n", - "stats {'hot': False, 'unreviewed_annotations': 0} \n", - "title You Never Wash Up After Yourself \n", - "url https://genius.com/Radiohead-you-never-wash-up... \n", + " 1070 \n", + "_id 106069 \n", + "annotation_count 16 \n", + "api_path /songs/106069 \n", + "ctitle brown sugar \n", + "full_title Brown Sugar by The Rolling Stones \n", + "header_image_thumbnail_url https://images.genius.com/5b7d4f11893ff2fdeba7... \n", + "header_image_url https://images.genius.com/5b7d4f11893ff2fdeba7... \n", + "id 106069 \n", + "lyrics gold coast slave ship bound for cotton fields ... \n", + "lyrics_owner_id 16 \n", + "original_lyrics \\n\\n[Verse 1]\\nGold coast slave ship bound for... \n", + "path /The-rolling-stones-brown-sugar-lyrics \n", + "primary_artist {'image_url': 'https://images.genius.com/23bbf... \n", + "pyongs_count 7 \n", + "song_art_image_thumbnail_url https://images.genius.com/5b7d4f11893ff2fdeba7... \n", + "stats {'unreviewed_annotations': 0, 'hot': False, 'p... \n", + "title Brown Sugar \n", + "url https://genius.com/The-rolling-stones-brown-su... \n", "\n", - "[15 rows x 611 columns]" + "[18 rows x 1071 columns]" ] }, - "execution_count": 68, + "execution_count": 45, "metadata": {}, "output_type": "execute_result" } @@ -6382,7 +7371,7 @@ }, { "cell_type": "code", - "execution_count": 69, + "execution_count": 46, "metadata": { "collapsed": false }, @@ -6404,7 +7393,7 @@ }, { "cell_type": "code", - "execution_count": 70, + "execution_count": 47, "metadata": { "collapsed": false }, @@ -6416,7 +7405,7 @@ " \"\\n\\n[Chorus 1]]\\nOh ain't she sweet\\nWell see her walking down that street\\nYes I ask you very confidentially\\nAin't she sweet?\\n\\n[Chorus 2]\\nOh ain't she nice\\nWell look her over once or twice\\nYes I ask you very confidentially\\nAin't she nice?\\n\\n[Chorus 3]\\nJust cast an eye\\nIn her direction\\nOh me oh my\\nAin't that perfection?\\n\\n[Chorus 4]\\nOh I repeat\\nWell don't you think that's kind of neat?\\nYes I ask you very confidentially\\nAin't she sweet?\\n\\n[Chorus 1]\\n\\n[Chorus 2]\\n\\n[Chorus 3]\\n\\n[Chorus 4]\\n\\n[Chorus 1]\\nOh ain't she sweet\\nWell see her walking down that street\\nWell I ask you very confidentially\\nAin't she sweet?\\nWell I ask you very confidentially\\nAin't she sweet?\\n\\n\")" ] }, - "execution_count": 70, + "execution_count": 47, "metadata": {}, "output_type": "execute_result" } @@ -6428,7 +7417,7 @@ }, { "cell_type": "code", - "execution_count": 71, + "execution_count": 48, "metadata": { "collapsed": false }, @@ -6442,7 +7431,7 @@ " 'title': 'All Together on the Wireless Machine'}" ] }, - "execution_count": 71, + "execution_count": 48, "metadata": {}, "output_type": "execute_result" } @@ -6467,7 +7456,7 @@ }, { "cell_type": "code", - "execution_count": 72, + "execution_count": 49, "metadata": { "collapsed": true }, @@ -6482,7 +7471,7 @@ }, { "cell_type": "code", - "execution_count": 73, + "execution_count": 50, "metadata": { "collapsed": false }, @@ -6493,7 +7482,7 @@ "'a hard days night'" ] }, - "execution_count": 73, + "execution_count": 50, "metadata": {}, "output_type": "execute_result" } @@ -6511,7 +7500,7 @@ }, { "cell_type": "code", - "execution_count": 74, + "execution_count": 51, "metadata": { "collapsed": true }, @@ -6532,7 +7521,7 @@ }, { "cell_type": "code", - "execution_count": 75, + "execution_count": 52, "metadata": { "collapsed": false }, @@ -6540,10 +7529,10 @@ { "data": { "text/plain": [ - "(301, 298, 46)" + "(489, 559, 57)" ] }, - "execution_count": 75, + "execution_count": 52, "metadata": {}, "output_type": "execute_result" } @@ -6557,7 +7546,7 @@ }, { "cell_type": "code", - "execution_count": 76, + "execution_count": 53, "metadata": { "collapsed": false, "scrolled": true @@ -6568,16 +7557,20 @@ "text/plain": [ "{'2 2 5 live at earls court',\n", " 'a punch up at a wedding',\n", + " 'band introductions',\n", " 'bloom blawan rmx',\n", " 'bloom harmonic 313 rmx',\n", " 'bloom jamie xx rework',\n", " 'bloom mark pritchard rmx',\n", " 'bloom objekt rmx',\n", " 'bullet proof i wish i was',\n", + " 'charlies intro to little red rooster',\n", " 'codex illum sphere',\n", " 'dollars cents',\n", " 'dollars cents live',\n", + " 'everybody needs somebody to love finale',\n", " 'everything in its right place live in france',\n", + " 'faraway eyes',\n", " 'feral lone rmx',\n", " 'fog again live',\n", " 'give up the ghost brokenchord rmx',\n", @@ -6586,16 +7579,23 @@ " 'i might be wrong live',\n", " 'i will los angeles version',\n", " 'idioteque live in oxford',\n", + " 'intro take the a train',\n", + " 'jumping jack flash',\n", + " 'just my imagination',\n", " 'kansas city heyheyheyhey',\n", + " 'key to the highway',\n", " 'like spinning plates live',\n", " 'little by little caribou rmx',\n", " 'little by little shed',\n", + " 'little ta',\n", " 'lotus flower jacques greene rmx',\n", " 'lotus flower sbtrkt rmx',\n", " 'march of the meanies',\n", + " 'martin scorsese intro',\n", " 'morning bell live in oxford',\n", " 'morning mr magpie nathan fake rmx',\n", " 'morning mr magpie pearson sound scavenger rmx',\n", + " 'outro',\n", " 'packt like sardines in a crushed tin box',\n", " 'pepperland',\n", " 'pepperland laid waste',\n", @@ -6614,7 +7614,7 @@ " 'when im sixty four'}" ] }, - "execution_count": 76, + "execution_count": 53, "metadata": {}, "output_type": "execute_result" } @@ -6625,7 +7625,7 @@ }, { "cell_type": "code", - "execution_count": 77, + "execution_count": 54, "metadata": { "collapsed": false }, @@ -6633,7 +7633,13 @@ { "data": { "text/plain": [ - "{'1822',\n", + "{'100 years ago',\n", + " '1822',\n", + " '19th nervous breakdown',\n", + " '2000 light years from home',\n", + " '2000 man',\n", + " '2120 south michigan avenue',\n", + " '3',\n", " 'a little rhyme',\n", " 'a moon shaped pool tracklist album cover',\n", " 'a picture of you',\n", @@ -6642,14 +7648,24 @@ " 'a shot of rhythm and blues',\n", " 'across the universe wildlife version',\n", " 'aint she sweet',\n", + " 'aint that loving you baby',\n", + " 'aint too proud to beg',\n", + " 'all sold out',\n", " 'all things must pass',\n", " 'all together on the wireless machine',\n", + " 'andrews blues',\n", " 'another beatles christmas record',\n", + " 'anyway you look at it',\n", + " 'around and around',\n", + " 'baby please dont go',\n", + " 'baby whats wrong',\n", + " 'backstreet girl',\n", " 'bad boy',\n", " 'bad to me',\n", " 'banana co',\n", " 'beatle greetings',\n", " 'beatles movie medley',\n", + " 'beautiful delilah',\n", " 'beautiful dreamer',\n", " 'bebopalula',\n", " 'because i know you love me so',\n", @@ -6660,179 +7676,352 @@ " 'big boots',\n", " 'big ideas',\n", " 'bishops robes',\n", + " 'bitch',\n", " 'bitches talkin',\n", " 'blackbirdyesterday',\n", + " 'blood red wine',\n", " 'blue moon of kentucky',\n", " 'blue suede shoes',\n", + " 'blue turns to grey',\n", + " 'bright lights big city',\n", " 'bullet proofi wish i was',\n", " 'burning bush',\n", + " 'bye bye johnny',\n", + " 'can i get a witness',\n", + " 'can you hear the music',\n", " 'can you take me back',\n", + " 'cant get next to you',\n", " 'carol',\n", + " 'casino boogie',\n", " 'ceremony',\n", + " 'charlie watts introduction of marianne faithfull',\n", + " 'cherry oh baby',\n", " 'child of nature',\n", + " 'child of the moon',\n", " 'christmas time is here again',\n", " 'cinnamon girl',\n", + " 'citadel',\n", " 'clarabella',\n", " 'climbing up a bloody great hill',\n", + " 'cocksucker blues',\n", " 'coke babies',\n", " 'come and get it',\n", + " 'come on',\n", " 'come togetherdear prudence',\n", + " 'coming down again',\n", " 'commonwealth',\n", + " 'complicated',\n", + " 'con le mie lacrime',\n", + " 'confessin the blues',\n", + " 'congratulations',\n", + " 'cook cook blues',\n", + " 'cool calm and collected',\n", + " 'cops and robbers',\n", + " 'corinna',\n", + " 'country honk',\n", + " 'crackin up',\n", + " 'crazy mama',\n", " 'crinsk dee night',\n", + " 'criss cross man',\n", + " 'crushed pearl',\n", " 'cry for a shadow',\n", + " 'cry to me',\n", " 'crying waiting hoping',\n", " 'cut a hole',\n", " 'cuttooth',\n", + " 'da doo ron ron',\n", + " 'dance',\n", + " 'dance little sister',\n", + " 'dancing in the light',\n", + " 'dancing with mr d',\n", + " 'dandelion',\n", + " 'dear doctor',\n", " 'dear wack',\n", + " 'diddley daddy',\n", " 'dollars and cents',\n", + " 'doncha bother me',\n", " 'dont ever change',\n", " 'dont let me down',\n", + " 'dont lie to me',\n", + " 'dont look back',\n", + " 'dont stop',\n", + " 'doo doo doo doo doo heartbreaker',\n", + " 'doom and gloom',\n", + " 'down home girl',\n", " 'down in eastern australia',\n", + " 'down in the bottom',\n", + " 'downtown suzie',\n", " 'dream baby',\n", + " 'drift away',\n", " 'drive my carthe wordwhat youre doing',\n", + " 'each and every day of the year',\n", " 'eds scary song',\n", " 'egyptian song',\n", " 'eleanor rigbyjulia transition',\n", + " 'empty heart',\n", " 'everybody lies through their teeth',\n", " 'everyone needs someone to hate',\n", + " 'everything is turning to gold',\n", " 'faithless the wonderboy',\n", " 'falling in love again',\n", + " 'family',\n", + " 'fancyman blues',\n", + " 'fanny mae',\n", " 'fasttrack',\n", " 'final show',\n", + " 'fingerprint file',\n", + " 'flight 505',\n", " 'fog',\n", " 'follow me around',\n", + " 'following the river',\n", + " 'fool to cry',\n", + " 'fortune teller',\n", " 'four guys',\n", " 'free as a bird',\n", " 'from fluff to you',\n", " 'from us to you',\n", + " 'gangsters maul',\n", " 'get back aka no pakistanis',\n", + " 'get off of my cloud',\n", " 'give it up',\n", " 'give peace a chance',\n", " 'glad all over',\n", " 'glass onion love remix',\n", " 'gnik nus',\n", + " 'goin home',\n", + " 'gomper',\n", + " 'good time women',\n", + " 'good times',\n", + " 'good times bad times',\n", " 'goodbye',\n", + " 'goodbye girl',\n", + " 'gotta get away',\n", + " 'grown up wrong',\n", " 'hallelujah i love her so',\n", + " 'hand of fate',\n", " 'happy song',\n", + " 'harlem shuffle ny mix',\n", " 'harry patch in memory of',\n", " 'have a banana',\n", " 'have a banana speech',\n", + " 'have you seen your mother baby standing in the shadow',\n", " 'hear me lord harrison',\n", + " 'heart of stone',\n", + " 'heavys pizza',\n", " 'hello little girl',\n", " 'here comes the sunthe inner light transition',\n", + " 'hey crawdaddy',\n", + " 'hey negrita',\n", + " 'hide your love',\n", + " 'highway child',\n", + " 'hiheel sneakers',\n", + " 'hitch hike',\n", + " 'honest i do',\n", + " 'hoochie coochie man',\n", + " 'hot stuff',\n", + " 'hound dog',\n", " 'how can you be sure',\n", " 'how do you do it',\n", " 'how i made my millions',\n", + " 'i aint superstitious',\n", + " 'i am waiting',\n", " 'i call your name',\n", + " 'i cant be satisfied',\n", + " 'i cant help it',\n", + " 'i dont know why',\n", + " 'i dont know why aka dont know why i love you',\n", " 'i forgot to remember to forget',\n", " 'i froze up',\n", + " 'i get a kick out of you',\n", " 'i got a woman',\n", + " 'i got the blues',\n", " 'i got to find my baby',\n", " 'i just dont understand',\n", + " 'i just want to make love to you',\n", + " 'i just want to see his face',\n", + " 'i need you baby mona',\n", " 'i promise',\n", + " 'i think im going mad',\n", " 'i want none of this',\n", + " 'i want to be loved',\n", " 'i want to know',\n", + " 'id much rather be with the boys',\n", + " 'if i was a dancer dance part 2',\n", + " 'if you cant rock me',\n", + " 'if you let me',\n", " 'if you love me baby',\n", + " 'if you need me',\n", + " 'if you really want to be my friend',\n", " 'if youve got trouble',\n", " 'ill be on my way',\n", " 'ill get you',\n", " 'ill wear it proudly',\n", " 'ill wind',\n", + " 'im a king bee',\n", " 'im coming up',\n", " 'im down',\n", + " 'im going down',\n", + " 'im gonna drive',\n", " 'im gonna sit right down and cry over you',\n", + " 'im not signifying',\n", " 'im talking about you',\n", + " 'in another land',\n", " 'in spite of all the danger',\n", " 'india',\n", " 'india rubber',\n", " 'inside my head',\n", + " 'intro',\n", + " 'intro excerpt from fanfare for the common man',\n", + " 'it hurts me too',\n", + " 'it should be you',\n", + " 'its all over now',\n", " 'its for you',\n", + " 'its not easy',\n", + " 'ive been loving you too long',\n", " 'james bond theme',\n", " 'jazz piano song',\n", " 'jerusalem',\n", + " 'jigsaw puzzle',\n", " 'jingle bells',\n", + " 'jiving sister fanny',\n", " 'john lennon vs bill oreilly',\n", + " 'john wesley harding',\n", " 'johnny b goode',\n", + " 'jump on top of me',\n", " 'junk',\n", " 'just a rumour',\n", " 'just a rumour speech',\n", " 'kansas city',\n", " 'keep strong',\n", " 'keep your hands off my baby',\n", + " 'keith richards introduction of the who',\n", + " 'keys to your love',\n", " 'kid a tracklist album cover',\n", " 'killer cars',\n", " 'komm gib mir deine hand',\n", + " 'ladies and gentlemen the rolling stones',\n", + " 'lady jane',\n", " 'ladytron',\n", " 'leave my kitten alone',\n", " 'lend me your comb',\n", + " 'let it loose',\n", + " 'let it rock',\n", " 'lets dance',\n", " 'lewis mistreated',\n", " 'lift',\n", " 'like dreamers do',\n", + " 'linda lu',\n", + " 'little queenie',\n", + " 'little t a',\n", " 'lonesome tears in my eyes',\n", + " 'long long while',\n", + " 'look what youve done',\n", + " 'looking tired',\n", + " 'losing my touch',\n", " 'love',\n", " 'love of the loved',\n", " 'love these goon shows',\n", " 'lozenge of love',\n", " 'lucille',\n", " 'lull',\n", + " 'luxury',\n", " 'mailman bring me no more blues',\n", + " 'mannish boy',\n", " 'manowar',\n", " 'mantua',\n", " 'maquiladora',\n", " 'matchbox',\n", " 'medley kansas cityhey hey hey hey',\n", " 'medley rip it up shake rattle and roll blue suede shoes',\n", + " 'meet me in the bottom',\n", " 'meeting in the aisle',\n", " 'melatonin',\n", + " 'melody',\n", + " 'memo from turner',\n", + " 'memory motel',\n", " 'memphis',\n", " 'memphis tennessee',\n", + " 'mercy mercy',\n", + " 'mick jaggers and john lennons introduction of the dirty mac',\n", + " 'mick jaggers introduction of rock roll circus',\n", + " 'mick jaggers introduction to jethro tull',\n", " 'million dollar question',\n", + " 'miss amanda jones',\n", + " 'miss you dr dre remix 2002',\n", " 'missing links bootleg',\n", " 'molasses',\n", + " 'mona',\n", + " 'money',\n", " 'moonlight',\n", " 'moonlight bay',\n", + " 'moonlight mile',\n", + " 'mothers little helper',\n", " 'movie medley',\n", " 'mr b',\n", " 'my bonnie',\n", " 'my bonnie english intro',\n", " 'my bonnie german intro',\n", + " 'my girl',\n", + " 'my obsession',\n", + " 'no expectations',\n", " 'no reply demo',\n", " 'nobody does it better',\n", " 'nobodys child',\n", " 'not guilty',\n", " 'nothin shakin',\n", " 'nothin shakin but the leaves on the trees',\n", + " 'nothing from nothing',\n", " 'nothing touches me',\n", + " 'oh baby we got a good thing goin',\n", " 'old brown shoe',\n", " 'on the beach',\n", + " 'on with the show',\n", " 'one and one is two',\n", + " 'one more shot',\n", + " 'one more try',\n", " 'ooh my arms',\n", " 'ooh my arms speech',\n", " 'ooh my soul',\n", " 'open pick',\n", + " 'out of time',\n", " 'packt like sardines in a crushd tin box',\n", + " 'paint it blacker',\n", " 'palo alto',\n", " 'pantomime everywhere its christmas',\n", + " 'parachute woman',\n", + " 'pass the wine sophia loren',\n", + " 'pay your dues',\n", " 'pearly',\n", " 'pedro the fisherman',\n", " 'permanent daylight',\n", + " 'petrol gang',\n", " 'phillipa chicken',\n", + " 'play with fire',\n", + " 'please go home',\n", + " 'plundered my soul',\n", + " 'poison ivy',\n", " 'polyethylene parts 1 2',\n", " 'pop is dead',\n", + " 'prodigal son',\n", " 'punchdrunk lovesick singalong',\n", " 'rain',\n", + " 'rain fall down william remix',\n", " 'ready teddy',\n", " 'real love',\n", + " 'reelin and rockin',\n", " 'reminiscing',\n", " 'revolution',\n", " 'revolution i',\n", " 'rhinestone cowboy',\n", + " 'ride on baby',\n", " 'riding on a bus',\n", " 'rip it up medley',\n", + " 'road runner',\n", " 'ruby baby',\n", + " 'sad day',\n", " 'saints',\n", " 'saints when the saints go marching in',\n", + " 'salt of the earth',\n", " 'searchin',\n", " 'september in the rain',\n", " 'set fire to that lot',\n", @@ -6841,40 +8030,76 @@ " 'sgt peppers lonely hearts club band reprise',\n", " 'sha la la la la',\n", " 'shake rattle and roll',\n", + " 'shake your hips',\n", + " 'she said yeah',\n", + " 'she smiled sweetly',\n", + " 'shes a rainbow',\n", + " 'short and curlies',\n", " 'shout',\n", " 'sie liebt dich',\n", + " 'silver train',\n", " 'sing a song for you',\n", + " 'sing this all together',\n", + " 'sing this all together see what happens',\n", " 'sinking ship',\n", + " 'sister morphine',\n", + " 'sittin on a fence',\n", + " 'sleepy city',\n", " 'slow down',\n", + " 'so divine aladdin story',\n", " 'so how come no one loves me',\n", " 'soldier of love',\n", " 'some other guy',\n", + " 'some things just stick in your mind',\n", " 'somebody else',\n", " 'someone else',\n", + " 'something happened to me yesterday',\n", " 'something with blue jay way transition',\n", " 'somewhere',\n", + " 'soul survivor',\n", " 'sour milk sea',\n", " 'spectre',\n", " 'staircase',\n", " 'stand by me',\n", + " 'star star',\n", + " 'stealing my heart',\n", " 'step inside love',\n", " 'step inside love los paranoias',\n", + " 'still a fool',\n", + " 'stoned',\n", + " 'stop breaking down',\n", " 'stranger in my arms',\n", " 'strawberry fields forever take 1',\n", " 'strawberry fields forever take 7 edit piece',\n", + " 'stray cat blues',\n", + " 'stuck out all alone',\n", " 'stupid car',\n", + " 'stupid girl',\n", + " 'summertime blues',\n", " 'supercollider',\n", " 'sure to fall',\n", " 'sure to fall in love with you',\n", + " 'surprise surprise',\n", + " 'susie q',\n", " 'suzy parker',\n", " 'swanee river',\n", + " 'sway',\n", + " 'sweet black angel',\n", " 'sweet georgia brown',\n", " 'sweet little sixteen',\n", + " 'sympathy for the devil fatboy slim remix',\n", + " 'sympathy for the devil the neptunes remix',\n", " 'take good care of my baby',\n", + " 'take it or leave it',\n", " 'talk show host',\n", + " 'talkin about you',\n", " 'teddy boy',\n", + " 'tell me',\n", + " 'tell me baby how many times',\n", " 'tell me why ep',\n", + " 'tell me youre coming back',\n", " 'thank you girl',\n", + " 'that girl belongs to yesterday',\n", " 'that means a lot',\n", " 'thatll be the day',\n", " 'thats alright mama',\n", @@ -6888,33 +8113,64 @@ " 'the fool on the hill demo',\n", " 'the fool on the hill take 4',\n", " 'the happy rishikesh song',\n", + " 'the harder they come',\n", " 'the hippy hippy shake',\n", " 'the honeymoon song',\n", " 'the inner light',\n", + " 'the lantern',\n", " 'the new generation',\n", + " 'the rocky road to dublin',\n", " 'the sheik of araby',\n", + " 'the singer not the song',\n", + " 'the storm',\n", " 'the thief',\n", " 'the trickster',\n", + " 'the under assistant west coast promotion man',\n", " 'these are my twisted words',\n", + " 'think',\n", " 'this boy',\n", " 'three cool cats',\n", + " 'through the lonely nights',\n", + " 'till the next goodbye',\n", + " 'time waits for no one',\n", + " 'title 5',\n", " 'to be a brilliant light',\n", " 'to know her is to love her',\n", " 'too much monkey business',\n", + " 'torn and frayed',\n", " 'transatlantic drawl',\n", + " 'travellin man',\n", + " 'try a little harder',\n", + " 'turd on the run',\n", + " 'under the board walk',\n", " 'union city blue',\n", " 'untogether',\n", " 'upside down',\n", + " 'ventilator blues',\n", + " 'wake up in the morning',\n", + " 'walking the dog',\n", + " 'walking through the sleepy city',\n", " 'watching rainbows',\n", + " 'we are wasting time',\n", + " 'we love you',\n", + " 'we want the stones',\n", + " 'were wastin time',\n", + " 'what a shame',\n", " 'what goes on girl',\n", " 'what is it that you say',\n", " 'what is that you say',\n", + " 'what to do',\n", " 'whatd i say',\n", " 'whats the new mary jane',\n", " 'when im sixtyfour',\n", " 'when the saints go marchin in',\n", + " 'who am i',\n", + " 'whos been sleeping here',\n", + " 'whos driving your plane',\n", " 'why',\n", " 'wicked child',\n", + " 'winter',\n", + " 'wish i never met you',\n", " 'wish you were here',\n", " 'within you without youtomorrow never knows',\n", " 'wonderwall',\n", @@ -6923,6 +8179,11 @@ " 'ya ya',\n", " 'yes i am',\n", " 'yes it is',\n", + " 'yesterdays papers',\n", + " 'you better move on',\n", + " 'you can make it if you try',\n", + " 'you cant catch me',\n", + " 'you gotta move',\n", " 'you know my name',\n", " 'you know my name look up the number',\n", " 'you know what to do',\n", @@ -6933,7 +8194,7 @@ " 'yove got to hide your love away'}" ] }, - "execution_count": 77, + "execution_count": 54, "metadata": {}, "output_type": "execute_result" } @@ -6953,7 +8214,7 @@ }, { "cell_type": "code", - "execution_count": 78, + "execution_count": 55, "metadata": { "collapsed": false }, @@ -6961,10 +8222,10 @@ { "data": { "text/plain": [ - "\n", + " | _id | \n", + "artist_name | \n", + "name | \n", + "valence | \n", + "
---|---|---|---|---|
20 | \n", + "3gKuywOm38axM8sJGq6Laq | \n", + "Radiohead | \n", + "MK 1 | \n", + "0.0391 | \n", + "
39 | \n", + "4DPQvbgSM0IdX4O3HOACwL | \n", + "Radiohead | \n", + "Treefingers | \n", + "0.0585 | \n", + "
37 | \n", + "2mvmuCtmmrERnm03ULdDye | \n", + "Radiohead | \n", + "Dollars & Cents | \n", + "0.0943 | \n", + "
1 | \n", + "6Unw1AAcpS1ZgZoRlj2jxA | \n", + "Radiohead | \n", + "Little By Little (Caribou Rmx) | \n", + "0.1310 | \n", + "
122 | \n", + "05evePUsIT1cmIURp1hgu6 | \n", + "Radiohead | \n", + "Planet Telex | \n", + "0.2720 | \n", + "
29 | \n", + "3bk7mfQWZ0acgp0hXzYQKS | \n", + "Radiohead | \n", + "The National Anthem (Live in France) | \n", + "0.2870 | \n", + "
134 | \n", + "1MyqLTRhgyWPw7v107BEuI | \n", + "Radiohead | \n", + "You | \n", + "0.3050 | \n", + "
22 | \n", + "3Y0ZPYdFsJ1ynQxpWZLNDj | \n", + "Radiohead | \n", + "2 + 2 = 5 (Live at Earls Court) | \n", + "0.3430 | \n", + "
78 | \n", + "37kUGdEJJ7NaMl5LFW4EA4 | \n", + "Radiohead | \n", + "2 + 2 = 5 | \n", + "0.3650 | \n", + "
48 | \n", + "3pcCifdPTc2BbqmWpEhtUd | \n", + "Radiohead | \n", + "Burn the Witch | \n", + "0.6250 | \n", + "