Spotipy_.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'external_urls': {'spotify': 'https://open.spotify.com/artist/0du5cEVh5yTK9QJze8zA0C'},\n",
       "  'href': 'https://api.spotify.com/v1/artists/0du5cEVh5yTK9QJze8zA0C',\n",
       "  'id': '0du5cEVh5yTK9QJze8zA0C',\n",
       "  'name': 'Bruno Mars',\n",
       "  'type': 'artist',\n",
       "  'uri': 'spotify:artist:0du5cEVh5yTK9QJze8zA0C'}]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials #To access authorised Spotify data\n",
    "\n",
    "client_id= \"your_clientID\"\n",
    "client_secret= \"your_client_secret_\"\n",
    "\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=client_id, client_secret=client_secret)\n",
    "\n",
    "sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager) #spotify object to access API\n",
    "\n",
    "name = \"Bruno Mars\" #chosen artist\n",
    "\n",
    "result = sp.search(name) #search query\n",
    "\n",
    "result['tracks']['items'][0]['artists']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'spotify:artist:0du5cEVh5yTK9QJze8zA0C'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Extract Artist's uri\n",
    "artist_uri = result['tracks']['items'][0]['artists'][0]['uri']\n",
    "artist_uri"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'sp_albums' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-d3190063406c>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0msp_albums\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'sp_albums' is not defined"
     ]
    }
   ],
   "source": [
    "sp_albums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['spotify:album:4PgleR09JVnm3zY1fW3XBA',\n",
       " 'spotify:album:4w6KUt7eyD4paTTNctylCS',\n",
       " 'spotify:album:7KBjLhk3IM27k3ry4vBk3i',\n",
       " 'spotify:album:58ufpQsJ1DS5kq4hhzQDiI',\n",
       " 'spotify:album:4xWulj18AGahlyuZPulaGe',\n",
       " 'spotify:album:6J84szYCnMfzEcvIcfWMFL',\n",
       " 'spotify:album:1uyf3l2d4XYwiEqAb7t7fX']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Pull all of the artist's albums\n",
    "sp_albums = sp.artist_albums(artist_uri, album_type='album')\n",
    "#Store artist's albums' names' and uris in separate lists\n",
    "album_names = []\n",
    "album_uris = []\n",
    "for i in range(len(sp_albums['items'])):\n",
    "    album_names.append(sp_albums['items'][i]['name'])\n",
    "    album_uris.append(sp_albums['items'][i]['uri'])\n",
    "    \n",
    "album_names\n",
    "album_uris\n",
    "#Keep names and uris in same order to keep track of duplicate albums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['24K Magic',\n",
       " 'Unorthodox Jukebox (Deluxe Edition)',\n",
       " 'Unorthodox Jukebox',\n",
       " 'Unorthodox Jukebox',\n",
       " 'Unorthodox Jukebox',\n",
       " 'Doo-Wops & Hooligans',\n",
       " 'Doo-Wops & Hooligans']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "album_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def albumSongs(uri):\n",
    "    album = uri #assign album uri to a_name\n",
    "    spotify_albums[album] = {} #Creates dictionary for that specific album\n",
    "    #Create keys-values of empty lists inside nested dictionary for album\n",
    "    spotify_albums[album]['album'] = [] #create empty list\n",
    "    spotify_albums[album]['track_number'] = []\n",
    "    spotify_albums[album]['id'] = []\n",
    "    spotify_albums[album]['name'] = []\n",
    "    spotify_albums[album]['uri'] = []\n",
    "    tracks = sp.album_tracks(album) #pull data on album tracks\n",
    "    for n in range(len(tracks['items'])): #for each song track\n",
    "            spotify_albums[album]['album'].append(album_names[album_count]) #append album name tracked via album_count\n",
    "            spotify_albums[album]['track_number'].append(tracks['items'][n]['track_number'])\n",
    "            spotify_albums[album]['id'].append(tracks['items'][n]['id'])\n",
    "            spotify_albums[album]['name'].append(tracks['items'][n]['name'])\n",
    "            spotify_albums[album]['uri'].append(tracks['items'][n]['uri'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Album 24K Magic songs has been added to spotify_albums dictionary\n",
      "Album Unorthodox Jukebox (Deluxe Edition) songs has been added to spotify_albums dictionary\n",
      "Album Unorthodox Jukebox songs has been added to spotify_albums dictionary\n",
      "Album Unorthodox Jukebox songs has been added to spotify_albums dictionary\n",
      "Album Unorthodox Jukebox songs has been added to spotify_albums dictionary\n",
      "Album Doo-Wops & Hooligans songs has been added to spotify_albums dictionary\n",
      "Album Doo-Wops & Hooligans songs has been added to spotify_albums dictionary\n"
     ]
    }
   ],
   "source": [
    "spotify_albums = {}\n",
    "album_count = 0\n",
    "for i in album_uris: #each album\n",
    "    albumSongs(i)\n",
    "    print(\"Album \" + str(album_names[album_count]) + \" songs has been added to spotify_albums dictionary\")\n",
    "    album_count+=1 #Updates album count once all tracks have been added"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def audio_features(album):\n",
    "    #Add new key-values to store audio features\n",
    "    spotify_albums[album]['acousticness'] = []\n",
    "    spotify_albums[album]['danceability'] = []\n",
    "    spotify_albums[album]['energy'] = []\n",
    "    spotify_albums[album]['instrumentalness'] = []\n",
    "    spotify_albums[album]['liveness'] = []\n",
    "    spotify_albums[album]['loudness'] = []\n",
    "    spotify_albums[album]['speechiness'] = []\n",
    "    spotify_albums[album]['tempo'] = []\n",
    "    spotify_albums[album]['valence'] = []\n",
    "    spotify_albums[album]['popularity'] = []\n",
    "    #create a track counter\n",
    "    track_count = 0\n",
    "    for track in spotify_albums[album]['uri']:\n",
    "        #pull audio features per track\n",
    "        features = sp.audio_features(track)\n",
    "        \n",
    "        #Append to relevant key-value\n",
    "        spotify_albums[album]['acousticness'].append(features[0]['acousticness'])\n",
    "        spotify_albums[album]['danceability'].append(features[0]['danceability'])\n",
    "        spotify_albums[album]['energy'].append(features[0]['energy'])\n",
    "        spotify_albums[album]['instrumentalness'].append(features[0]['instrumentalness'])\n",
    "        spotify_albums[album]['liveness'].append(features[0]['liveness'])\n",
    "        spotify_albums[album]['loudness'].append(features[0]['loudness'])\n",
    "        spotify_albums[album]['speechiness'].append(features[0]['speechiness'])\n",
    "        spotify_albums[album]['tempo'].append(features[0]['tempo'])\n",
    "        spotify_albums[album]['valence'].append(features[0]['valence'])\n",
    "        #popularity is stored elsewhere\n",
    "        pop = sp.track(track)\n",
    "        spotify_albums[album]['popularity'].append(pop['popularity'])\n",
    "        track_count+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5 playlists completed\n",
      "Loop #: 5\n",
      "Elapsed Time: 39.98214364051819 seconds\n"
     ]
    }
   ],
   "source": [
    "import time\n",
    "import numpy as np\n",
    "sleep_min = 2\n",
    "sleep_max = 5\n",
    "start_time = time.time()\n",
    "request_count = 0\n",
    "for i in spotify_albums:\n",
    "    audio_features(i)\n",
    "    request_count+=1\n",
    "    if request_count % 5 == 0:\n",
    "        print(str(request_count) + \" playlists completed\")\n",
    "        time.sleep(np.random.uniform(sleep_min, sleep_max))\n",
    "        print('Loop #: {}'.format(request_count))\n",
    "        print('Elapsed Time: {} seconds'.format(time.time() - start_time))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "76"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dic_df = {}\n",
    "dic_df['album'] = []\n",
    "dic_df['track_number'] = []\n",
    "dic_df['id'] = []\n",
    "dic_df['name'] = []\n",
    "dic_df['uri'] = []\n",
    "dic_df['acousticness'] = []\n",
    "dic_df['danceability'] = []\n",
    "dic_df['energy'] = []\n",
    "dic_df['instrumentalness'] = []\n",
    "dic_df['liveness'] = []\n",
    "dic_df['loudness'] = []\n",
    "dic_df['speechiness'] = []\n",
    "dic_df['tempo'] = []\n",
    "dic_df['valence'] = []\n",
    "dic_df['popularity'] = []\n",
    "for album in spotify_albums: \n",
    "    for feature in spotify_albums[album]:\n",
    "        dic_df[feature].extend(spotify_albums[album][feature])\n",
    "        \n",
    "len(dic_df['album'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>acousticness</th>\n",
       "      <th>album</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>id</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>loudness</th>\n",
       "      <th>name</th>\n",
       "      <th>popularity</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>tempo</th>\n",
       "      <th>track_number</th>\n",
       "      <th>uri</th>\n",
       "      <th>valence</th>\n",
       "      <th>artist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.034000</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.818</td>\n",
       "      <td>0.803</td>\n",
       "      <td>6b8Be6ljOzmkOmFslEb23P</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1530</td>\n",
       "      <td>-4.282</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>75</td>\n",
       "      <td>0.0797</td>\n",
       "      <td>106.970</td>\n",
       "      <td>1</td>\n",
       "      <td>spotify:track:6b8Be6ljOzmkOmFslEb23P</td>\n",
       "      <td>0.632</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.020800</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.571</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0mBKv9DkYfQHjdMcw2jdyI</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1250</td>\n",
       "      <td>-4.446</td>\n",
       "      <td>Chunky</td>\n",
       "      <td>68</td>\n",
       "      <td>0.1160</td>\n",
       "      <td>202.103</td>\n",
       "      <td>2</td>\n",
       "      <td>spotify:track:0mBKv9DkYfQHjdMcw2jdyI</td>\n",
       "      <td>0.727</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.014500</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.853</td>\n",
       "      <td>0.871</td>\n",
       "      <td>1I6pKIyaBp4OebTGLJpCCC</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>0.1980</td>\n",
       "      <td>-3.715</td>\n",
       "      <td>Perm</td>\n",
       "      <td>65</td>\n",
       "      <td>0.0851</td>\n",
       "      <td>124.021</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:1I6pKIyaBp4OebTGLJpCCC</td>\n",
       "      <td>0.863</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.013000</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.853</td>\n",
       "      <td>0.560</td>\n",
       "      <td>0KKkJNfGyhkQ5aFogxQAPU</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0944</td>\n",
       "      <td>-4.961</td>\n",
       "      <td>That's What I Like</td>\n",
       "      <td>80</td>\n",
       "      <td>0.0406</td>\n",
       "      <td>134.066</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:0KKkJNfGyhkQ5aFogxQAPU</td>\n",
       "      <td>0.860</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.196000</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.578</td>\n",
       "      <td>0.574</td>\n",
       "      <td>0kN8xEmgMW9mh7UmDYHlJP</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0830</td>\n",
       "      <td>-6.209</td>\n",
       "      <td>Versace on the Floor</td>\n",
       "      <td>73</td>\n",
       "      <td>0.0454</td>\n",
       "      <td>174.152</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:0kN8xEmgMW9mh7UmDYHlJP</td>\n",
       "      <td>0.301</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.020900</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.552</td>\n",
       "      <td>0.733</td>\n",
       "      <td>2mrZYZGmPFV3QOyYPZ1zsn</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0858</td>\n",
       "      <td>-6.898</td>\n",
       "      <td>Straight Up &amp; Down</td>\n",
       "      <td>63</td>\n",
       "      <td>0.0933</td>\n",
       "      <td>143.560</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:2mrZYZGmPFV3QOyYPZ1zsn</td>\n",
       "      <td>0.643</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.039200</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.662</td>\n",
       "      <td>0.705</td>\n",
       "      <td>6ObpR8ek44tvWefQRcSo8K</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.1050</td>\n",
       "      <td>-6.560</td>\n",
       "      <td>Calling All My Lovelies</td>\n",
       "      <td>62</td>\n",
       "      <td>0.0399</td>\n",
       "      <td>159.996</td>\n",
       "      <td>7</td>\n",
       "      <td>spotify:track:6ObpR8ek44tvWefQRcSo8K</td>\n",
       "      <td>0.865</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.007810</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.741</td>\n",
       "      <td>0.798</td>\n",
       "      <td>5XMkENs3GfeRza8MfVAhjK</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0232</td>\n",
       "      <td>-5.342</td>\n",
       "      <td>Finesse</td>\n",
       "      <td>65</td>\n",
       "      <td>0.0718</td>\n",
       "      <td>104.953</td>\n",
       "      <td>8</td>\n",
       "      <td>spotify:track:5XMkENs3GfeRza8MfVAhjK</td>\n",
       "      <td>0.939</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.038900</td>\n",
       "      <td>24K Magic</td>\n",
       "      <td>0.587</td>\n",
       "      <td>0.630</td>\n",
       "      <td>0B0tYbVp7pDQAqKDhgMeaL</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3500</td>\n",
       "      <td>-6.054</td>\n",
       "      <td>Too Good to Say Goodbye</td>\n",
       "      <td>63</td>\n",
       "      <td>0.0311</td>\n",
       "      <td>76.970</td>\n",
       "      <td>9</td>\n",
       "      <td>spotify:track:0B0tYbVp7pDQAqKDhgMeaL</td>\n",
       "      <td>0.433</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.461000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.561</td>\n",
       "      <td>0.749</td>\n",
       "      <td>5Pr2AFUNbDMo73grOJDWvy</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.2050</td>\n",
       "      <td>-4.951</td>\n",
       "      <td>Young Girls</td>\n",
       "      <td>19</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>125.986</td>\n",
       "      <td>1</td>\n",
       "      <td>spotify:track:5Pr2AFUNbDMo73grOJDWvy</td>\n",
       "      <td>0.501</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.049000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.698</td>\n",
       "      <td>2VoO0foG09SUeuat3wYLNG</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3090</td>\n",
       "      <td>-4.165</td>\n",
       "      <td>Locked Out of Heaven</td>\n",
       "      <td>23</td>\n",
       "      <td>0.0431</td>\n",
       "      <td>143.994</td>\n",
       "      <td>2</td>\n",
       "      <td>spotify:track:2VoO0foG09SUeuat3wYLNG</td>\n",
       "      <td>0.867</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.445000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.544</td>\n",
       "      <td>13dX0sTiBQabys1vYMjmIk</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>0.0973</td>\n",
       "      <td>-6.598</td>\n",
       "      <td>Gorilla</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0371</td>\n",
       "      <td>139.959</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:13dX0sTiBQabys1vYMjmIk</td>\n",
       "      <td>0.641</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.041200</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.874</td>\n",
       "      <td>0.692</td>\n",
       "      <td>5rCuwVqnDRL45hxb7cm6SJ</td>\n",
       "      <td>0.000072</td>\n",
       "      <td>0.3240</td>\n",
       "      <td>-5.280</td>\n",
       "      <td>Treasure</td>\n",
       "      <td>27</td>\n",
       "      <td>0.0431</td>\n",
       "      <td>116.017</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:5rCuwVqnDRL45hxb7cm6SJ</td>\n",
       "      <td>0.937</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.211000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.705</td>\n",
       "      <td>0.784</td>\n",
       "      <td>6dvacupcEKreloCB9nkAsT</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.0813</td>\n",
       "      <td>-4.351</td>\n",
       "      <td>Moonshine</td>\n",
       "      <td>16</td>\n",
       "      <td>0.0279</td>\n",
       "      <td>104.980</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:6dvacupcEKreloCB9nkAsT</td>\n",
       "      <td>0.418</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.932000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.612</td>\n",
       "      <td>0.280</td>\n",
       "      <td>3Aj1JsbwzjCEKsYF6TtRKc</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0880</td>\n",
       "      <td>-8.648</td>\n",
       "      <td>When I Was Your Man</td>\n",
       "      <td>20</td>\n",
       "      <td>0.0434</td>\n",
       "      <td>72.795</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:3Aj1JsbwzjCEKsYF6TtRKc</td>\n",
       "      <td>0.387</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.150000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.760</td>\n",
       "      <td>0.733</td>\n",
       "      <td>1rZu1PXFKzO5AP9ODhgq1f</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0647</td>\n",
       "      <td>-6.704</td>\n",
       "      <td>Natalie</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0504</td>\n",
       "      <td>111.975</td>\n",
       "      <td>7</td>\n",
       "      <td>spotify:track:1rZu1PXFKzO5AP9ODhgq1f</td>\n",
       "      <td>0.611</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.046100</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.743</td>\n",
       "      <td>0.706</td>\n",
       "      <td>3TBAyGWDLOaaLW3g14AVAi</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>-5.728</td>\n",
       "      <td>Show Me</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0535</td>\n",
       "      <td>77.989</td>\n",
       "      <td>8</td>\n",
       "      <td>spotify:track:3TBAyGWDLOaaLW3g14AVAi</td>\n",
       "      <td>0.514</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.094300</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.754</td>\n",
       "      <td>0.677</td>\n",
       "      <td>0yxyY3XyGhWdkd22OILEHO</td>\n",
       "      <td>0.000074</td>\n",
       "      <td>0.1530</td>\n",
       "      <td>-6.555</td>\n",
       "      <td>Money Make Her Smile</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0709</td>\n",
       "      <td>93.022</td>\n",
       "      <td>9</td>\n",
       "      <td>spotify:track:0yxyY3XyGhWdkd22OILEHO</td>\n",
       "      <td>0.780</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.722000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.522</td>\n",
       "      <td>0.413</td>\n",
       "      <td>0RuG8C8gJGv9QAy29DMZiQ</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0854</td>\n",
       "      <td>-5.860</td>\n",
       "      <td>If I Knew</td>\n",
       "      <td>16</td>\n",
       "      <td>0.0316</td>\n",
       "      <td>175.972</td>\n",
       "      <td>10</td>\n",
       "      <td>spotify:track:0RuG8C8gJGv9QAy29DMZiQ</td>\n",
       "      <td>0.490</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.443000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.566</td>\n",
       "      <td>0.430</td>\n",
       "      <td>3zRfP7U300ogttIfwqB5HD</td>\n",
       "      <td>0.000470</td>\n",
       "      <td>0.2060</td>\n",
       "      <td>-10.464</td>\n",
       "      <td>Old &amp; Crazy (feat. Esperanza Spalding)</td>\n",
       "      <td>19</td>\n",
       "      <td>0.2780</td>\n",
       "      <td>187.766</td>\n",
       "      <td>11</td>\n",
       "      <td>spotify:track:3zRfP7U300ogttIfwqB5HD</td>\n",
       "      <td>0.828</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.862000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.631</td>\n",
       "      <td>0.337</td>\n",
       "      <td>2OTH8T7TqMYt51baDvVEHQ</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3740</td>\n",
       "      <td>-8.624</td>\n",
       "      <td>Young Girls - Demo</td>\n",
       "      <td>16</td>\n",
       "      <td>0.0312</td>\n",
       "      <td>125.909</td>\n",
       "      <td>12</td>\n",
       "      <td>spotify:track:2OTH8T7TqMYt51baDvVEHQ</td>\n",
       "      <td>0.489</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.752000</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.631</td>\n",
       "      <td>0.435</td>\n",
       "      <td>1Yl0H4Mn4xDVAFSJ0IM5t3</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0579</td>\n",
       "      <td>-6.561</td>\n",
       "      <td>Gorilla - Demo</td>\n",
       "      <td>14</td>\n",
       "      <td>0.0308</td>\n",
       "      <td>139.829</td>\n",
       "      <td>13</td>\n",
       "      <td>spotify:track:1Yl0H4Mn4xDVAFSJ0IM5t3</td>\n",
       "      <td>0.410</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.000188</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.654</td>\n",
       "      <td>0.782</td>\n",
       "      <td>03wqOqPhG7W8T83L7hOt4j</td>\n",
       "      <td>0.002250</td>\n",
       "      <td>0.1750</td>\n",
       "      <td>-4.924</td>\n",
       "      <td>Moonshine - The Futuristics Remix</td>\n",
       "      <td>14</td>\n",
       "      <td>0.0561</td>\n",
       "      <td>108.954</td>\n",
       "      <td>14</td>\n",
       "      <td>spotify:track:03wqOqPhG7W8T83L7hOt4j</td>\n",
       "      <td>0.594</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.000509</td>\n",
       "      <td>Unorthodox Jukebox (Deluxe Edition)</td>\n",
       "      <td>0.686</td>\n",
       "      <td>0.827</td>\n",
       "      <td>1uQ8qCbeeA39xd1gIcaxgM</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.7260</td>\n",
       "      <td>-4.063</td>\n",
       "      <td>Locked Out of Heaven - Major Lazer Remix</td>\n",
       "      <td>14</td>\n",
       "      <td>0.0325</td>\n",
       "      <td>144.035</td>\n",
       "      <td>15</td>\n",
       "      <td>spotify:track:1uQ8qCbeeA39xd1gIcaxgM</td>\n",
       "      <td>0.648</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.461000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.561</td>\n",
       "      <td>0.749</td>\n",
       "      <td>6aDzodSr4gqsMXAX8yt3bb</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.2050</td>\n",
       "      <td>-4.951</td>\n",
       "      <td>Young Girls</td>\n",
       "      <td>30</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>125.986</td>\n",
       "      <td>1</td>\n",
       "      <td>spotify:track:6aDzodSr4gqsMXAX8yt3bb</td>\n",
       "      <td>0.501</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.049000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.698</td>\n",
       "      <td>1qCdYQdkWvm4cYXAuOlbyc</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3090</td>\n",
       "      <td>-4.165</td>\n",
       "      <td>Locked Out of Heaven</td>\n",
       "      <td>43</td>\n",
       "      <td>0.0431</td>\n",
       "      <td>143.994</td>\n",
       "      <td>2</td>\n",
       "      <td>spotify:track:1qCdYQdkWvm4cYXAuOlbyc</td>\n",
       "      <td>0.867</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.453000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.719</td>\n",
       "      <td>0.562</td>\n",
       "      <td>1DKkwzIV0EefeF2c3xmVd3</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>0.0974</td>\n",
       "      <td>-6.608</td>\n",
       "      <td>Gorilla</td>\n",
       "      <td>31</td>\n",
       "      <td>0.0381</td>\n",
       "      <td>139.960</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:1DKkwzIV0EefeF2c3xmVd3</td>\n",
       "      <td>0.622</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.029100</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.699</td>\n",
       "      <td>1GDrGx9VWaAgaekuddnLYq</td>\n",
       "      <td>0.000121</td>\n",
       "      <td>0.0639</td>\n",
       "      <td>-5.071</td>\n",
       "      <td>Treasure</td>\n",
       "      <td>44</td>\n",
       "      <td>0.0349</td>\n",
       "      <td>116.033</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:1GDrGx9VWaAgaekuddnLYq</td>\n",
       "      <td>0.934</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.211000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.705</td>\n",
       "      <td>0.784</td>\n",
       "      <td>2VQjYduVaHdaQZmgOUKRwl</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.0813</td>\n",
       "      <td>-4.351</td>\n",
       "      <td>Moonshine</td>\n",
       "      <td>23</td>\n",
       "      <td>0.0279</td>\n",
       "      <td>104.980</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:2VQjYduVaHdaQZmgOUKRwl</td>\n",
       "      <td>0.418</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.932000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.612</td>\n",
       "      <td>0.280</td>\n",
       "      <td>4tLihrsL9WMgvI0n9R2bFS</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0880</td>\n",
       "      <td>-8.648</td>\n",
       "      <td>When I Was Your Man</td>\n",
       "      <td>45</td>\n",
       "      <td>0.0434</td>\n",
       "      <td>72.795</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:4tLihrsL9WMgvI0n9R2bFS</td>\n",
       "      <td>0.387</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.469000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.721</td>\n",
       "      <td>0.547</td>\n",
       "      <td>3zQ4t4cmfM6DuP0j79POrV</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.0969</td>\n",
       "      <td>-6.539</td>\n",
       "      <td>Gorilla</td>\n",
       "      <td>28</td>\n",
       "      <td>0.0367</td>\n",
       "      <td>139.990</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:3zQ4t4cmfM6DuP0j79POrV</td>\n",
       "      <td>0.667</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0.034000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.874</td>\n",
       "      <td>0.687</td>\n",
       "      <td>4G2Hbfwvn3oH7LxxPXjjGn</td>\n",
       "      <td>0.000076</td>\n",
       "      <td>0.3240</td>\n",
       "      <td>-5.253</td>\n",
       "      <td>Treasure</td>\n",
       "      <td>40</td>\n",
       "      <td>0.0426</td>\n",
       "      <td>116.054</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:4G2Hbfwvn3oH7LxxPXjjGn</td>\n",
       "      <td>0.920</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0.205000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.706</td>\n",
       "      <td>0.773</td>\n",
       "      <td>4KqOYNpmqcsptsEliWnCJE</td>\n",
       "      <td>0.000018</td>\n",
       "      <td>0.0756</td>\n",
       "      <td>-4.383</td>\n",
       "      <td>Moonshine</td>\n",
       "      <td>22</td>\n",
       "      <td>0.0276</td>\n",
       "      <td>104.987</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:4KqOYNpmqcsptsEliWnCJE</td>\n",
       "      <td>0.457</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0.937000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.601</td>\n",
       "      <td>0.271</td>\n",
       "      <td>0B7wvvmu9EISAwZnOpjhNI</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1440</td>\n",
       "      <td>-8.688</td>\n",
       "      <td>When I Was Your Man</td>\n",
       "      <td>49</td>\n",
       "      <td>0.0403</td>\n",
       "      <td>145.494</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:0B7wvvmu9EISAwZnOpjhNI</td>\n",
       "      <td>0.411</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0.152000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.761</td>\n",
       "      <td>0.729</td>\n",
       "      <td>5zHgYHO5WWz5Nme7Js1HEp</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0696</td>\n",
       "      <td>-6.539</td>\n",
       "      <td>Natalie</td>\n",
       "      <td>24</td>\n",
       "      <td>0.0503</td>\n",
       "      <td>111.994</td>\n",
       "      <td>7</td>\n",
       "      <td>spotify:track:5zHgYHO5WWz5Nme7Js1HEp</td>\n",
       "      <td>0.667</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.053600</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.745</td>\n",
       "      <td>0.687</td>\n",
       "      <td>11EZ9WJIQW7H37zPO2KXgf</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2070</td>\n",
       "      <td>-5.700</td>\n",
       "      <td>Show Me</td>\n",
       "      <td>23</td>\n",
       "      <td>0.0616</td>\n",
       "      <td>77.979</td>\n",
       "      <td>8</td>\n",
       "      <td>spotify:track:11EZ9WJIQW7H37zPO2KXgf</td>\n",
       "      <td>0.539</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>0.094500</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.755</td>\n",
       "      <td>0.664</td>\n",
       "      <td>232nQnyelarnhjBOB6JSJd</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.1400</td>\n",
       "      <td>-6.400</td>\n",
       "      <td>Money Make Her Smile</td>\n",
       "      <td>19</td>\n",
       "      <td>0.0750</td>\n",
       "      <td>93.011</td>\n",
       "      <td>9</td>\n",
       "      <td>spotify:track:232nQnyelarnhjBOB6JSJd</td>\n",
       "      <td>0.778</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>0.720000</td>\n",
       "      <td>Unorthodox Jukebox</td>\n",
       "      <td>0.472</td>\n",
       "      <td>0.437</td>\n",
       "      <td>7hTINtDW5V8tWMJvi4HH7v</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0858</td>\n",
       "      <td>-5.739</td>\n",
       "      <td>If I Knew</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0327</td>\n",
       "      <td>175.797</td>\n",
       "      <td>10</td>\n",
       "      <td>spotify:track:7hTINtDW5V8tWMJvi4HH7v</td>\n",
       "      <td>0.442</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>0.146000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.706</td>\n",
       "      <td>0.558</td>\n",
       "      <td>4lLtanYk6tkMvooU0tWzG8</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1180</td>\n",
       "      <td>-7.237</td>\n",
       "      <td>Grenade</td>\n",
       "      <td>71</td>\n",
       "      <td>0.0593</td>\n",
       "      <td>110.443</td>\n",
       "      <td>1</td>\n",
       "      <td>spotify:track:4lLtanYk6tkMvooU0tWzG8</td>\n",
       "      <td>0.227</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>0.015100</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.637</td>\n",
       "      <td>0.843</td>\n",
       "      <td>47Slg6LuqLaX0VodpSCvPt</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0876</td>\n",
       "      <td>-5.413</td>\n",
       "      <td>Just the Way You Are</td>\n",
       "      <td>74</td>\n",
       "      <td>0.0432</td>\n",
       "      <td>109.012</td>\n",
       "      <td>2</td>\n",
       "      <td>spotify:track:47Slg6LuqLaX0VodpSCvPt</td>\n",
       "      <td>0.434</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>0.381000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.705</td>\n",
       "      <td>0.451</td>\n",
       "      <td>4LjkHlY5qDz0hhFJJH5M7a</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2760</td>\n",
       "      <td>-8.221</td>\n",
       "      <td>Our First Time</td>\n",
       "      <td>51</td>\n",
       "      <td>0.0429</td>\n",
       "      <td>77.998</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:4LjkHlY5qDz0hhFJJH5M7a</td>\n",
       "      <td>0.868</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.656</td>\n",
       "      <td>0.767</td>\n",
       "      <td>7hCNBVRhHzcsRAv0TQnOzq</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1140</td>\n",
       "      <td>-3.038</td>\n",
       "      <td>Runaway Baby</td>\n",
       "      <td>61</td>\n",
       "      <td>0.0396</td>\n",
       "      <td>163.834</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:7hCNBVRhHzcsRAv0TQnOzq</td>\n",
       "      <td>0.871</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>0.332000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.804</td>\n",
       "      <td>386RUes7n1uM1yfzgeUuwp</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2790</td>\n",
       "      <td>-3.851</td>\n",
       "      <td>The Lazy Song</td>\n",
       "      <td>70</td>\n",
       "      <td>0.0621</td>\n",
       "      <td>174.943</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:386RUes7n1uM1yfzgeUuwp</td>\n",
       "      <td>0.949</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>0.332000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.620</td>\n",
       "      <td>0.832</td>\n",
       "      <td>6SKwQghsR8AISlxhcwyA9R</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1040</td>\n",
       "      <td>-4.848</td>\n",
       "      <td>Marry You</td>\n",
       "      <td>70</td>\n",
       "      <td>0.0360</td>\n",
       "      <td>144.926</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:6SKwQghsR8AISlxhcwyA9R</td>\n",
       "      <td>0.481</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>0.512000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.523</td>\n",
       "      <td>0.606</td>\n",
       "      <td>1wVuPmvt6AWvTL5W2GJnzZ</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1060</td>\n",
       "      <td>-4.754</td>\n",
       "      <td>Talking to the Moon</td>\n",
       "      <td>66</td>\n",
       "      <td>0.0301</td>\n",
       "      <td>145.837</td>\n",
       "      <td>7</td>\n",
       "      <td>spotify:track:1wVuPmvt6AWvTL5W2GJnzZ</td>\n",
       "      <td>0.065</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>0.110000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.691</td>\n",
       "      <td>0.824</td>\n",
       "      <td>1ewMCmw7qCb5a9ttqiyemu</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3530</td>\n",
       "      <td>-3.925</td>\n",
       "      <td>Liquor Store Blues (feat. Damian Marley)</td>\n",
       "      <td>57</td>\n",
       "      <td>0.0731</td>\n",
       "      <td>75.516</td>\n",
       "      <td>8</td>\n",
       "      <td>spotify:track:1ewMCmw7qCb5a9ttqiyemu</td>\n",
       "      <td>0.685</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>0.840000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.577</td>\n",
       "      <td>0.397</td>\n",
       "      <td>3B5UbSndRz907IZhhmUfLi</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0772</td>\n",
       "      <td>-5.980</td>\n",
       "      <td>Count on Me - EP Version</td>\n",
       "      <td>64</td>\n",
       "      <td>0.0280</td>\n",
       "      <td>89.044</td>\n",
       "      <td>9</td>\n",
       "      <td>spotify:track:3B5UbSndRz907IZhhmUfLi</td>\n",
       "      <td>0.509</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>0.117000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.559</td>\n",
       "      <td>0.807</td>\n",
       "      <td>78Z199FfQHt4VpnJzlYaIe</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.1480</td>\n",
       "      <td>-3.887</td>\n",
       "      <td>The Other Side (feat. CeeLo Green and B.o.B) -...</td>\n",
       "      <td>51</td>\n",
       "      <td>0.0304</td>\n",
       "      <td>140.081</td>\n",
       "      <td>10</td>\n",
       "      <td>spotify:track:78Z199FfQHt4VpnJzlYaIe</td>\n",
       "      <td>0.543</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>0.569000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.701</td>\n",
       "      <td>0.579</td>\n",
       "      <td>3P4v70V3Zt804r2c9dZivK</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2550</td>\n",
       "      <td>-5.673</td>\n",
       "      <td>Somewhere in Brooklyn - EP Version</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0412</td>\n",
       "      <td>129.969</td>\n",
       "      <td>11</td>\n",
       "      <td>spotify:track:3P4v70V3Zt804r2c9dZivK</td>\n",
       "      <td>0.349</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>0.867000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.354</td>\n",
       "      <td>0.333</td>\n",
       "      <td>6YKT5HoPwjTwhHiCNQsBMK</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1070</td>\n",
       "      <td>-6.423</td>\n",
       "      <td>Talking to the Moon - Acoustic Piano Version</td>\n",
       "      <td>53</td>\n",
       "      <td>0.0324</td>\n",
       "      <td>101.145</td>\n",
       "      <td>12</td>\n",
       "      <td>spotify:track:6YKT5HoPwjTwhHiCNQsBMK</td>\n",
       "      <td>0.209</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>0.146000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.706</td>\n",
       "      <td>0.558</td>\n",
       "      <td>2tJulUYLDKOg9XrtVkMgcJ</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1180</td>\n",
       "      <td>-7.237</td>\n",
       "      <td>Grenade</td>\n",
       "      <td>71</td>\n",
       "      <td>0.0593</td>\n",
       "      <td>110.443</td>\n",
       "      <td>1</td>\n",
       "      <td>spotify:track:2tJulUYLDKOg9XrtVkMgcJ</td>\n",
       "      <td>0.227</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>0.015100</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.637</td>\n",
       "      <td>0.843</td>\n",
       "      <td>7BqBn9nzAq8spo5e7cZ0dJ</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0876</td>\n",
       "      <td>-5.413</td>\n",
       "      <td>Just the Way You Are</td>\n",
       "      <td>76</td>\n",
       "      <td>0.0432</td>\n",
       "      <td>109.012</td>\n",
       "      <td>2</td>\n",
       "      <td>spotify:track:7BqBn9nzAq8spo5e7cZ0dJ</td>\n",
       "      <td>0.434</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>0.381000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.705</td>\n",
       "      <td>0.451</td>\n",
       "      <td>5BmKRyAjCnvkko7Ms00YtA</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2760</td>\n",
       "      <td>-8.221</td>\n",
       "      <td>Our First Time</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0429</td>\n",
       "      <td>77.998</td>\n",
       "      <td>3</td>\n",
       "      <td>spotify:track:5BmKRyAjCnvkko7Ms00YtA</td>\n",
       "      <td>0.868</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.656</td>\n",
       "      <td>0.767</td>\n",
       "      <td>5MMLS3xm12D7N26xlfFApr</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1140</td>\n",
       "      <td>-3.038</td>\n",
       "      <td>Runaway Baby</td>\n",
       "      <td>60</td>\n",
       "      <td>0.0396</td>\n",
       "      <td>163.834</td>\n",
       "      <td>4</td>\n",
       "      <td>spotify:track:5MMLS3xm12D7N26xlfFApr</td>\n",
       "      <td>0.871</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>0.332000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.804</td>\n",
       "      <td>1ExfPZEiahqhLyajhybFeS</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2790</td>\n",
       "      <td>-3.851</td>\n",
       "      <td>The Lazy Song</td>\n",
       "      <td>67</td>\n",
       "      <td>0.0621</td>\n",
       "      <td>174.943</td>\n",
       "      <td>5</td>\n",
       "      <td>spotify:track:1ExfPZEiahqhLyajhybFeS</td>\n",
       "      <td>0.949</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>0.332000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.620</td>\n",
       "      <td>0.832</td>\n",
       "      <td>22PMfvdz35fFKYnJyMn077</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1040</td>\n",
       "      <td>-4.848</td>\n",
       "      <td>Marry You</td>\n",
       "      <td>70</td>\n",
       "      <td>0.0360</td>\n",
       "      <td>144.926</td>\n",
       "      <td>6</td>\n",
       "      <td>spotify:track:22PMfvdz35fFKYnJyMn077</td>\n",
       "      <td>0.481</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>0.512000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.523</td>\n",
       "      <td>0.606</td>\n",
       "      <td>161DnLWsx1i3u1JT05lzqU</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1060</td>\n",
       "      <td>-4.754</td>\n",
       "      <td>Talking to the Moon</td>\n",
       "      <td>69</td>\n",
       "      <td>0.0301</td>\n",
       "      <td>145.837</td>\n",
       "      <td>7</td>\n",
       "      <td>spotify:track:161DnLWsx1i3u1JT05lzqU</td>\n",
       "      <td>0.065</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>0.110000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.691</td>\n",
       "      <td>0.824</td>\n",
       "      <td>4KykoaJQ5UxjCpp3lYkvTE</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3530</td>\n",
       "      <td>-3.925</td>\n",
       "      <td>Liquor Store Blues (feat. Damian Marley)</td>\n",
       "      <td>58</td>\n",
       "      <td>0.0731</td>\n",
       "      <td>75.516</td>\n",
       "      <td>8</td>\n",
       "      <td>spotify:track:4KykoaJQ5UxjCpp3lYkvTE</td>\n",
       "      <td>0.685</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>0.840000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.577</td>\n",
       "      <td>0.397</td>\n",
       "      <td>7l1qvxWjxcKpB9PCtBuTbU</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0772</td>\n",
       "      <td>-5.980</td>\n",
       "      <td>Count on Me - EP Version</td>\n",
       "      <td>68</td>\n",
       "      <td>0.0280</td>\n",
       "      <td>89.044</td>\n",
       "      <td>9</td>\n",
       "      <td>spotify:track:7l1qvxWjxcKpB9PCtBuTbU</td>\n",
       "      <td>0.509</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>0.117000</td>\n",
       "      <td>Doo-Wops &amp; Hooligans</td>\n",
       "      <td>0.559</td>\n",
       "      <td>0.807</td>\n",
       "      <td>0HasfWMrNxTjycDy9TkRtA</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.1480</td>\n",
       "      <td>-3.887</td>\n",
       "      <td>The Other Side (feat. CeeLo Green and B.o.B) -...</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0304</td>\n",
       "      <td>140.081</td>\n",
       "      <td>10</td>\n",
       "      <td>spotify:track:0HasfWMrNxTjycDy9TkRtA</td>\n",
       "      <td>0.543</td>\n",
       "      <td>Bruno Mars</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>76 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    acousticness                                album  danceability  energy  \\\n",
       "0       0.034000                            24K Magic         0.818   0.803   \n",
       "1       0.020800                            24K Magic         0.571   0.539   \n",
       "2       0.014500                            24K Magic         0.853   0.871   \n",
       "3       0.013000                            24K Magic         0.853   0.560   \n",
       "4       0.196000                            24K Magic         0.578   0.574   \n",
       "5       0.020900                            24K Magic         0.552   0.733   \n",
       "6       0.039200                            24K Magic         0.662   0.705   \n",
       "7       0.007810                            24K Magic         0.741   0.798   \n",
       "8       0.038900                            24K Magic         0.587   0.630   \n",
       "9       0.461000  Unorthodox Jukebox (Deluxe Edition)         0.561   0.749   \n",
       "10      0.049000  Unorthodox Jukebox (Deluxe Edition)         0.726   0.698   \n",
       "11      0.445000  Unorthodox Jukebox (Deluxe Edition)         0.717   0.544   \n",
       "12      0.041200  Unorthodox Jukebox (Deluxe Edition)         0.874   0.692   \n",
       "13      0.211000  Unorthodox Jukebox (Deluxe Edition)         0.705   0.784   \n",
       "14      0.932000  Unorthodox Jukebox (Deluxe Edition)         0.612   0.280   \n",
       "15      0.150000  Unorthodox Jukebox (Deluxe Edition)         0.760   0.733   \n",
       "16      0.046100  Unorthodox Jukebox (Deluxe Edition)         0.743   0.706   \n",
       "17      0.094300  Unorthodox Jukebox (Deluxe Edition)         0.754   0.677   \n",
       "18      0.722000  Unorthodox Jukebox (Deluxe Edition)         0.522   0.413   \n",
       "19      0.443000  Unorthodox Jukebox (Deluxe Edition)         0.566   0.430   \n",
       "20      0.862000  Unorthodox Jukebox (Deluxe Edition)         0.631   0.337   \n",
       "21      0.752000  Unorthodox Jukebox (Deluxe Edition)         0.631   0.435   \n",
       "22      0.000188  Unorthodox Jukebox (Deluxe Edition)         0.654   0.782   \n",
       "23      0.000509  Unorthodox Jukebox (Deluxe Edition)         0.686   0.827   \n",
       "24      0.461000                   Unorthodox Jukebox         0.561   0.749   \n",
       "25      0.049000                   Unorthodox Jukebox         0.726   0.698   \n",
       "26      0.453000                   Unorthodox Jukebox         0.719   0.562   \n",
       "27      0.029100                   Unorthodox Jukebox         0.872   0.699   \n",
       "28      0.211000                   Unorthodox Jukebox         0.705   0.784   \n",
       "29      0.932000                   Unorthodox Jukebox         0.612   0.280   \n",
       "..           ...                                  ...           ...     ...   \n",
       "46      0.469000                   Unorthodox Jukebox         0.721   0.547   \n",
       "47      0.034000                   Unorthodox Jukebox         0.874   0.687   \n",
       "48      0.205000                   Unorthodox Jukebox         0.706   0.773   \n",
       "49      0.937000                   Unorthodox Jukebox         0.601   0.271   \n",
       "50      0.152000                   Unorthodox Jukebox         0.761   0.729   \n",
       "51      0.053600                   Unorthodox Jukebox         0.745   0.687   \n",
       "52      0.094500                   Unorthodox Jukebox         0.755   0.664   \n",
       "53      0.720000                   Unorthodox Jukebox         0.472   0.437   \n",
       "54      0.146000                 Doo-Wops & Hooligans         0.706   0.558   \n",
       "55      0.015100                 Doo-Wops & Hooligans         0.637   0.843   \n",
       "56      0.381000                 Doo-Wops & Hooligans         0.705   0.451   \n",
       "57      0.250000                 Doo-Wops & Hooligans         0.656   0.767   \n",
       "58      0.332000                 Doo-Wops & Hooligans         0.738   0.804   \n",
       "59      0.332000                 Doo-Wops & Hooligans         0.620   0.832   \n",
       "60      0.512000                 Doo-Wops & Hooligans         0.523   0.606   \n",
       "61      0.110000                 Doo-Wops & Hooligans         0.691   0.824   \n",
       "62      0.840000                 Doo-Wops & Hooligans         0.577   0.397   \n",
       "63      0.117000                 Doo-Wops & Hooligans         0.559   0.807   \n",
       "64      0.569000                 Doo-Wops & Hooligans         0.701   0.579   \n",
       "65      0.867000                 Doo-Wops & Hooligans         0.354   0.333   \n",
       "66      0.146000                 Doo-Wops & Hooligans         0.706   0.558   \n",
       "67      0.015100                 Doo-Wops & Hooligans         0.637   0.843   \n",
       "68      0.381000                 Doo-Wops & Hooligans         0.705   0.451   \n",
       "69      0.250000                 Doo-Wops & Hooligans         0.656   0.767   \n",
       "70      0.332000                 Doo-Wops & Hooligans         0.738   0.804   \n",
       "71      0.332000                 Doo-Wops & Hooligans         0.620   0.832   \n",
       "72      0.512000                 Doo-Wops & Hooligans         0.523   0.606   \n",
       "73      0.110000                 Doo-Wops & Hooligans         0.691   0.824   \n",
       "74      0.840000                 Doo-Wops & Hooligans         0.577   0.397   \n",
       "75      0.117000                 Doo-Wops & Hooligans         0.559   0.807   \n",
       "\n",
       "                        id  instrumentalness  liveness  loudness  \\\n",
       "0   6b8Be6ljOzmkOmFslEb23P          0.000000    0.1530    -4.282   \n",
       "1   0mBKv9DkYfQHjdMcw2jdyI          0.000000    0.1250    -4.446   \n",
       "2   1I6pKIyaBp4OebTGLJpCCC          0.000068    0.1980    -3.715   \n",
       "3   0KKkJNfGyhkQ5aFogxQAPU          0.000000    0.0944    -4.961   \n",
       "4   0kN8xEmgMW9mh7UmDYHlJP          0.000000    0.0830    -6.209   \n",
       "5   2mrZYZGmPFV3QOyYPZ1zsn          0.000000    0.0858    -6.898   \n",
       "6   6ObpR8ek44tvWefQRcSo8K          0.000002    0.1050    -6.560   \n",
       "7   5XMkENs3GfeRza8MfVAhjK          0.000000    0.0232    -5.342   \n",
       "8   0B0tYbVp7pDQAqKDhgMeaL          0.000000    0.3500    -6.054   \n",
       "9   5Pr2AFUNbDMo73grOJDWvy          0.000002    0.2050    -4.951   \n",
       "10  2VoO0foG09SUeuat3wYLNG          0.000000    0.3090    -4.165   \n",
       "11  13dX0sTiBQabys1vYMjmIk          0.000005    0.0973    -6.598   \n",
       "12  5rCuwVqnDRL45hxb7cm6SJ          0.000072    0.3240    -5.280   \n",
       "13  6dvacupcEKreloCB9nkAsT          0.000004    0.0813    -4.351   \n",
       "14  3Aj1JsbwzjCEKsYF6TtRKc          0.000000    0.0880    -8.648   \n",
       "15  1rZu1PXFKzO5AP9ODhgq1f          0.000000    0.0647    -6.704   \n",
       "16  3TBAyGWDLOaaLW3g14AVAi          0.000000    0.2040    -5.728   \n",
       "17  0yxyY3XyGhWdkd22OILEHO          0.000074    0.1530    -6.555   \n",
       "18  0RuG8C8gJGv9QAy29DMZiQ          0.000000    0.0854    -5.860   \n",
       "19  3zRfP7U300ogttIfwqB5HD          0.000470    0.2060   -10.464   \n",
       "20  2OTH8T7TqMYt51baDvVEHQ          0.000000    0.3740    -8.624   \n",
       "21  1Yl0H4Mn4xDVAFSJ0IM5t3          0.000000    0.0579    -6.561   \n",
       "22  03wqOqPhG7W8T83L7hOt4j          0.002250    0.1750    -4.924   \n",
       "23  1uQ8qCbeeA39xd1gIcaxgM          0.000001    0.7260    -4.063   \n",
       "24  6aDzodSr4gqsMXAX8yt3bb          0.000002    0.2050    -4.951   \n",
       "25  1qCdYQdkWvm4cYXAuOlbyc          0.000000    0.3090    -4.165   \n",
       "26  1DKkwzIV0EefeF2c3xmVd3          0.000005    0.0974    -6.608   \n",
       "27  1GDrGx9VWaAgaekuddnLYq          0.000121    0.0639    -5.071   \n",
       "28  2VQjYduVaHdaQZmgOUKRwl          0.000004    0.0813    -4.351   \n",
       "29  4tLihrsL9WMgvI0n9R2bFS          0.000000    0.0880    -8.648   \n",
       "..                     ...               ...       ...       ...   \n",
       "46  3zQ4t4cmfM6DuP0j79POrV          0.000012    0.0969    -6.539   \n",
       "47  4G2Hbfwvn3oH7LxxPXjjGn          0.000076    0.3240    -5.253   \n",
       "48  4KqOYNpmqcsptsEliWnCJE          0.000018    0.0756    -4.383   \n",
       "49  0B7wvvmu9EISAwZnOpjhNI          0.000000    0.1440    -8.688   \n",
       "50  5zHgYHO5WWz5Nme7Js1HEp          0.000000    0.0696    -6.539   \n",
       "51  11EZ9WJIQW7H37zPO2KXgf          0.000000    0.2070    -5.700   \n",
       "52  232nQnyelarnhjBOB6JSJd          0.000039    0.1400    -6.400   \n",
       "53  7hTINtDW5V8tWMJvi4HH7v          0.000000    0.0858    -5.739   \n",
       "54  4lLtanYk6tkMvooU0tWzG8          0.000000    0.1180    -7.237   \n",
       "55  47Slg6LuqLaX0VodpSCvPt          0.000000    0.0876    -5.413   \n",
       "56  4LjkHlY5qDz0hhFJJH5M7a          0.000000    0.2760    -8.221   \n",
       "57  7hCNBVRhHzcsRAv0TQnOzq          0.000000    0.1140    -3.038   \n",
       "58  386RUes7n1uM1yfzgeUuwp          0.000000    0.2790    -3.851   \n",
       "59  6SKwQghsR8AISlxhcwyA9R          0.000000    0.1040    -4.848   \n",
       "60  1wVuPmvt6AWvTL5W2GJnzZ          0.000000    0.1060    -4.754   \n",
       "61  1ewMCmw7qCb5a9ttqiyemu          0.000000    0.3530    -3.925   \n",
       "62  3B5UbSndRz907IZhhmUfLi          0.000000    0.0772    -5.980   \n",
       "63  78Z199FfQHt4VpnJzlYaIe          0.000004    0.1480    -3.887   \n",
       "64  3P4v70V3Zt804r2c9dZivK          0.000000    0.2550    -5.673   \n",
       "65  6YKT5HoPwjTwhHiCNQsBMK          0.000000    0.1070    -6.423   \n",
       "66  2tJulUYLDKOg9XrtVkMgcJ          0.000000    0.1180    -7.237   \n",
       "67  7BqBn9nzAq8spo5e7cZ0dJ          0.000000    0.0876    -5.413   \n",
       "68  5BmKRyAjCnvkko7Ms00YtA          0.000000    0.2760    -8.221   \n",
       "69  5MMLS3xm12D7N26xlfFApr          0.000000    0.1140    -3.038   \n",
       "70  1ExfPZEiahqhLyajhybFeS          0.000000    0.2790    -3.851   \n",
       "71  22PMfvdz35fFKYnJyMn077          0.000000    0.1040    -4.848   \n",
       "72  161DnLWsx1i3u1JT05lzqU          0.000000    0.1060    -4.754   \n",
       "73  4KykoaJQ5UxjCpp3lYkvTE          0.000000    0.3530    -3.925   \n",
       "74  7l1qvxWjxcKpB9PCtBuTbU          0.000000    0.0772    -5.980   \n",
       "75  0HasfWMrNxTjycDy9TkRtA          0.000004    0.1480    -3.887   \n",
       "\n",
       "                                                 name  popularity  \\\n",
       "0                                           24K Magic          75   \n",
       "1                                              Chunky          68   \n",
       "2                                                Perm          65   \n",
       "3                                  That's What I Like          80   \n",
       "4                                Versace on the Floor          73   \n",
       "5                                  Straight Up & Down          63   \n",
       "6                             Calling All My Lovelies          62   \n",
       "7                                             Finesse          65   \n",
       "8                             Too Good to Say Goodbye          63   \n",
       "9                                         Young Girls          19   \n",
       "10                               Locked Out of Heaven          23   \n",
       "11                                            Gorilla          17   \n",
       "12                                           Treasure          27   \n",
       "13                                          Moonshine          16   \n",
       "14                                When I Was Your Man          20   \n",
       "15                                            Natalie          17   \n",
       "16                                            Show Me          15   \n",
       "17                               Money Make Her Smile          15   \n",
       "18                                          If I Knew          16   \n",
       "19             Old & Crazy (feat. Esperanza Spalding)          19   \n",
       "20                                 Young Girls - Demo          16   \n",
       "21                                     Gorilla - Demo          14   \n",
       "22                  Moonshine - The Futuristics Remix          14   \n",
       "23           Locked Out of Heaven - Major Lazer Remix          14   \n",
       "24                                        Young Girls          30   \n",
       "25                               Locked Out of Heaven          43   \n",
       "26                                            Gorilla          31   \n",
       "27                                           Treasure          44   \n",
       "28                                          Moonshine          23   \n",
       "29                                When I Was Your Man          45   \n",
       "..                                                ...         ...   \n",
       "46                                            Gorilla          28   \n",
       "47                                           Treasure          40   \n",
       "48                                          Moonshine          22   \n",
       "49                                When I Was Your Man          49   \n",
       "50                                            Natalie          24   \n",
       "51                                            Show Me          23   \n",
       "52                               Money Make Her Smile          19   \n",
       "53                                          If I Knew          26   \n",
       "54                                            Grenade          71   \n",
       "55                               Just the Way You Are          74   \n",
       "56                                     Our First Time          51   \n",
       "57                                       Runaway Baby          61   \n",
       "58                                      The Lazy Song          70   \n",
       "59                                          Marry You          70   \n",
       "60                                Talking to the Moon          66   \n",
       "61           Liquor Store Blues (feat. Damian Marley)          57   \n",
       "62                           Count on Me - EP Version          64   \n",
       "63  The Other Side (feat. CeeLo Green and B.o.B) -...          51   \n",
       "64                 Somewhere in Brooklyn - EP Version          50   \n",
       "65       Talking to the Moon - Acoustic Piano Version          53   \n",
       "66                                            Grenade          71   \n",
       "67                               Just the Way You Are          76   \n",
       "68                                     Our First Time          50   \n",
       "69                                       Runaway Baby          60   \n",
       "70                                      The Lazy Song          67   \n",
       "71                                          Marry You          70   \n",
       "72                                Talking to the Moon          69   \n",
       "73           Liquor Store Blues (feat. Damian Marley)          58   \n",
       "74                           Count on Me - EP Version          68   \n",
       "75  The Other Side (feat. CeeLo Green and B.o.B) -...          50   \n",
       "\n",
       "    speechiness    tempo  track_number                                   uri  \\\n",
       "0        0.0797  106.970             1  spotify:track:6b8Be6ljOzmkOmFslEb23P   \n",
       "1        0.1160  202.103             2  spotify:track:0mBKv9DkYfQHjdMcw2jdyI   \n",
       "2        0.0851  124.021             3  spotify:track:1I6pKIyaBp4OebTGLJpCCC   \n",
       "3        0.0406  134.066             4  spotify:track:0KKkJNfGyhkQ5aFogxQAPU   \n",
       "4        0.0454  174.152             5  spotify:track:0kN8xEmgMW9mh7UmDYHlJP   \n",
       "5        0.0933  143.560             6  spotify:track:2mrZYZGmPFV3QOyYPZ1zsn   \n",
       "6        0.0399  159.996             7  spotify:track:6ObpR8ek44tvWefQRcSo8K   \n",
       "7        0.0718  104.953             8  spotify:track:5XMkENs3GfeRza8MfVAhjK   \n",
       "8        0.0311   76.970             9  spotify:track:0B0tYbVp7pDQAqKDhgMeaL   \n",
       "9        0.0320  125.986             1  spotify:track:5Pr2AFUNbDMo73grOJDWvy   \n",
       "10       0.0431  143.994             2  spotify:track:2VoO0foG09SUeuat3wYLNG   \n",
       "11       0.0371  139.959             3  spotify:track:13dX0sTiBQabys1vYMjmIk   \n",
       "12       0.0431  116.017             4  spotify:track:5rCuwVqnDRL45hxb7cm6SJ   \n",
       "13       0.0279  104.980             5  spotify:track:6dvacupcEKreloCB9nkAsT   \n",
       "14       0.0434   72.795             6  spotify:track:3Aj1JsbwzjCEKsYF6TtRKc   \n",
       "15       0.0504  111.975             7  spotify:track:1rZu1PXFKzO5AP9ODhgq1f   \n",
       "16       0.0535   77.989             8  spotify:track:3TBAyGWDLOaaLW3g14AVAi   \n",
       "17       0.0709   93.022             9  spotify:track:0yxyY3XyGhWdkd22OILEHO   \n",
       "18       0.0316  175.972            10  spotify:track:0RuG8C8gJGv9QAy29DMZiQ   \n",
       "19       0.2780  187.766            11  spotify:track:3zRfP7U300ogttIfwqB5HD   \n",
       "20       0.0312  125.909            12  spotify:track:2OTH8T7TqMYt51baDvVEHQ   \n",
       "21       0.0308  139.829            13  spotify:track:1Yl0H4Mn4xDVAFSJ0IM5t3   \n",
       "22       0.0561  108.954            14  spotify:track:03wqOqPhG7W8T83L7hOt4j   \n",
       "23       0.0325  144.035            15  spotify:track:1uQ8qCbeeA39xd1gIcaxgM   \n",
       "24       0.0320  125.986             1  spotify:track:6aDzodSr4gqsMXAX8yt3bb   \n",
       "25       0.0431  143.994             2  spotify:track:1qCdYQdkWvm4cYXAuOlbyc   \n",
       "26       0.0381  139.960             3  spotify:track:1DKkwzIV0EefeF2c3xmVd3   \n",
       "27       0.0349  116.033             4  spotify:track:1GDrGx9VWaAgaekuddnLYq   \n",
       "28       0.0279  104.980             5  spotify:track:2VQjYduVaHdaQZmgOUKRwl   \n",
       "29       0.0434   72.795             6  spotify:track:4tLihrsL9WMgvI0n9R2bFS   \n",
       "..          ...      ...           ...                                   ...   \n",
       "46       0.0367  139.990             3  spotify:track:3zQ4t4cmfM6DuP0j79POrV   \n",
       "47       0.0426  116.054             4  spotify:track:4G2Hbfwvn3oH7LxxPXjjGn   \n",
       "48       0.0276  104.987             5  spotify:track:4KqOYNpmqcsptsEliWnCJE   \n",
       "49       0.0403  145.494             6  spotify:track:0B7wvvmu9EISAwZnOpjhNI   \n",
       "50       0.0503  111.994             7  spotify:track:5zHgYHO5WWz5Nme7Js1HEp   \n",
       "51       0.0616   77.979             8  spotify:track:11EZ9WJIQW7H37zPO2KXgf   \n",
       "52       0.0750   93.011             9  spotify:track:232nQnyelarnhjBOB6JSJd   \n",
       "53       0.0327  175.797            10  spotify:track:7hTINtDW5V8tWMJvi4HH7v   \n",
       "54       0.0593  110.443             1  spotify:track:4lLtanYk6tkMvooU0tWzG8   \n",
       "55       0.0432  109.012             2  spotify:track:47Slg6LuqLaX0VodpSCvPt   \n",
       "56       0.0429   77.998             3  spotify:track:4LjkHlY5qDz0hhFJJH5M7a   \n",
       "57       0.0396  163.834             4  spotify:track:7hCNBVRhHzcsRAv0TQnOzq   \n",
       "58       0.0621  174.943             5  spotify:track:386RUes7n1uM1yfzgeUuwp   \n",
       "59       0.0360  144.926             6  spotify:track:6SKwQghsR8AISlxhcwyA9R   \n",
       "60       0.0301  145.837             7  spotify:track:1wVuPmvt6AWvTL5W2GJnzZ   \n",
       "61       0.0731   75.516             8  spotify:track:1ewMCmw7qCb5a9ttqiyemu   \n",
       "62       0.0280   89.044             9  spotify:track:3B5UbSndRz907IZhhmUfLi   \n",
       "63       0.0304  140.081            10  spotify:track:78Z199FfQHt4VpnJzlYaIe   \n",
       "64       0.0412  129.969            11  spotify:track:3P4v70V3Zt804r2c9dZivK   \n",
       "65       0.0324  101.145            12  spotify:track:6YKT5HoPwjTwhHiCNQsBMK   \n",
       "66       0.0593  110.443             1  spotify:track:2tJulUYLDKOg9XrtVkMgcJ   \n",
       "67       0.0432  109.012             2  spotify:track:7BqBn9nzAq8spo5e7cZ0dJ   \n",
       "68       0.0429   77.998             3  spotify:track:5BmKRyAjCnvkko7Ms00YtA   \n",
       "69       0.0396  163.834             4  spotify:track:5MMLS3xm12D7N26xlfFApr   \n",
       "70       0.0621  174.943             5  spotify:track:1ExfPZEiahqhLyajhybFeS   \n",
       "71       0.0360  144.926             6  spotify:track:22PMfvdz35fFKYnJyMn077   \n",
       "72       0.0301  145.837             7  spotify:track:161DnLWsx1i3u1JT05lzqU   \n",
       "73       0.0731   75.516             8  spotify:track:4KykoaJQ5UxjCpp3lYkvTE   \n",
       "74       0.0280   89.044             9  spotify:track:7l1qvxWjxcKpB9PCtBuTbU   \n",
       "75       0.0304  140.081            10  spotify:track:0HasfWMrNxTjycDy9TkRtA   \n",
       "\n",
       "    valence      artist  \n",
       "0     0.632  Bruno Mars  \n",
       "1     0.727  Bruno Mars  \n",
       "2     0.863  Bruno Mars  \n",
       "3     0.860  Bruno Mars  \n",
       "4     0.301  Bruno Mars  \n",
       "5     0.643  Bruno Mars  \n",
       "6     0.865  Bruno Mars  \n",
       "7     0.939  Bruno Mars  \n",
       "8     0.433  Bruno Mars  \n",
       "9     0.501  Bruno Mars  \n",
       "10    0.867  Bruno Mars  \n",
       "11    0.641  Bruno Mars  \n",
       "12    0.937  Bruno Mars  \n",
       "13    0.418  Bruno Mars  \n",
       "14    0.387  Bruno Mars  \n",
       "15    0.611  Bruno Mars  \n",
       "16    0.514  Bruno Mars  \n",
       "17    0.780  Bruno Mars  \n",
       "18    0.490  Bruno Mars  \n",
       "19    0.828  Bruno Mars  \n",
       "20    0.489  Bruno Mars  \n",
       "21    0.410  Bruno Mars  \n",
       "22    0.594  Bruno Mars  \n",
       "23    0.648  Bruno Mars  \n",
       "24    0.501  Bruno Mars  \n",
       "25    0.867  Bruno Mars  \n",
       "26    0.622  Bruno Mars  \n",
       "27    0.934  Bruno Mars  \n",
       "28    0.418  Bruno Mars  \n",
       "29    0.387  Bruno Mars  \n",
       "..      ...         ...  \n",
       "46    0.667  Bruno Mars  \n",
       "47    0.920  Bruno Mars  \n",
       "48    0.457  Bruno Mars  \n",
       "49    0.411  Bruno Mars  \n",
       "50    0.667  Bruno Mars  \n",
       "51    0.539  Bruno Mars  \n",
       "52    0.778  Bruno Mars  \n",
       "53    0.442  Bruno Mars  \n",
       "54    0.227  Bruno Mars  \n",
       "55    0.434  Bruno Mars  \n",
       "56    0.868  Bruno Mars  \n",
       "57    0.871  Bruno Mars  \n",
       "58    0.949  Bruno Mars  \n",
       "59    0.481  Bruno Mars  \n",
       "60    0.065  Bruno Mars  \n",
       "61    0.685  Bruno Mars  \n",
       "62    0.509  Bruno Mars  \n",
       "63    0.543  Bruno Mars  \n",
       "64    0.349  Bruno Mars  \n",
       "65    0.209  Bruno Mars  \n",
       "66    0.227  Bruno Mars  \n",
       "67    0.434  Bruno Mars  \n",
       "68    0.868  Bruno Mars  \n",
       "69    0.871  Bruno Mars  \n",
       "70    0.949  Bruno Mars  \n",
       "71    0.481  Bruno Mars  \n",
       "72    0.065  Bruno Mars  \n",
       "73    0.685  Bruno Mars  \n",
       "74    0.509  Bruno Mars  \n",
       "75    0.543  Bruno Mars  \n",
       "\n",
       "[76 rows x 16 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.DataFrame.from_dict(dic_df)\n",
    "df['artist'] = name\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "76\n",
      "36\n"
     ]
    }
   ],
   "source": [
    "print(len(df))\n",
    "final_df = df.sort_values('popularity', ascending=False).drop_duplicates('name').sort_index()\n",
    "print(len(final_df))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from openpyxl import load_workbook\n",
    "\n",
    "path = r\"C:\\Blog\\post2\\Playlists\\playlist_jhon.xlsx\"\n",
    "\n",
    "book = load_workbook(path)\n",
    "writer = pd.ExcelWriter(path, engine = 'openpyxl')\n",
    "writer.book = book\n",
    "\n",
    "final_df.to_excel(writer, sheet_name = name)\n",
    "writer.save()\n",
    "writer.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "final_df.to_excel('Bruno.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}