Test playlist gathering and spotipy recommendation function.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Playlist Queries & Testing\n",
    "\n",
    "This notebook served as a quick testing ground for playlist retrieval from the SpotifyAPI and some basic recommendation before creating the **Combined recommendations** notebook.\n",
    "As a simple testing ground it is not really commented."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials\n",
    "import spotipy.util as util\n",
    "from pathlib import Path\n",
    "import pandas as pd\n",
    "from spotifuncs import authenticate,create_df_top_songs, append_audio_features,create_similarity_score,get_recommendations, top_artists_from_API, create_df_saved_songs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = Path(\"C:/Users/ms101/OneDrive/DataScience_ML/projects/spotify_app\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(path / \"client_s.txt\") as f:\n",
    "    content = f.readlines()\n",
    "content = [x.strip() for x in content]\n",
    "\n",
    "client_id = content[0]\n",
    "client_secret = content[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(path / \"usernames.txt\") as f:\n",
    "    usernames = f.readlines()\n",
    "usernames = [x.strip() for x in usernames]\n",
    "\n",
    "username1 = usernames[0]\n",
    "username2 = usernames[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "scope = \"user-library-read user-read-recently-played user-top-read playlist-modify-public playlist-read-private playlist-read-collaborative\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "redirect_uri = \"https://developer.spotify.com/dashboard/applications/4a4e029d299a4241873db8300038bf0a\"\n",
    "\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=client_id, \n",
    "                                                      client_secret=client_secret)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# def authenticate(redirect_uri, client_cred_manager, username, scope,client_id,client_secret):\n",
    "#     sp = spotipy.Spotify(client_credentials_manager = client_credentials_manager)\n",
    "#     token = util.prompt_for_user_token(username, scope, client_id, client_secret, redirect_uri)\n",
    "#     if token:\n",
    "#         sp = spotipy.Spotify(auth=token)\n",
    "#     else:\n",
    "#         print(\"Can't get token for\", username)\n",
    "#     return sp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "sp = authenticate(redirect_uri, client_credentials_manager, username1, scope, client_id, client_secret)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# redirect_uri = \"https://developer.spotify.com/dashboard/applications/4a4e029d299a4241873db8300038bf0a\"\n",
    "\n",
    "\n",
    "# client_credentials_manager = SpotifyClientCredentials(client_id=client_id, \n",
    "#                                                       client_secret=client_secret)\n",
    "\n",
    "# sp = spotipy.Spotify(client_credentials_manager = client_credentials_manager)\n",
    "\n",
    "\n",
    "# token = util.prompt_for_user_token(username1, scope, client_id, client_secret, redirect_uri)\n",
    "\n",
    "# if token:\n",
    "#     sp = spotipy.Spotify(auth=token)\n",
    "# else:\n",
    "#     print(\"Can't get token for\", username1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "##queries\n",
    "#user top tracks\n",
    "top_tracks_short = sp.current_user_top_tracks(limit = 50,offset=0,time_range='short_term')\n",
    "top_tracks_med = sp.current_user_top_tracks(limit = 50,offset=0,time_range='medium_term')\n",
    "top_tracks_long = sp.current_user_top_tracks(limit = 50,offset=0,time_range='long_term')\n",
    "#user top artists\n",
    "top_artists_long = sp.current_user_top_artists(limit = 50, time_range = \"long_term\")\n",
    "top_artists_med = sp.current_user_top_artists(limit = 50, time_range = \"medium_term\")\n",
    "top_artists_short = sp.current_user_top_artists(limit = 50, time_range = \"short_term\")\n",
    "#user recent tracks\n",
    "#still in BETA phase no spotipy function (workaround??)\n",
    "\n",
    "#user saved tracks\n",
    "user_saved_tracks = sp.current_user_saved_tracks(limit = 50)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# def top_artists_from_API(api_results):\n",
    "#     df = pd.DataFrame(api_results[\"items\"])\n",
    "#     cols = [\"name\",\"id\",\"genres\",\"popularity\",\"uri\"]\n",
    "#     return df[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>id</th>\n",
       "      <th>genres</th>\n",
       "      <th>popularity</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>6C1ohJrd5VydigQtaGy5Wa</td>\n",
       "      <td>boston hip hop,hip hop,pop rap,rap</td>\n",
       "      <td>78</td>\n",
       "      <td>spotify:artist:6C1ohJrd5VydigQtaGy5Wa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fynn Kliemann</td>\n",
       "      <td>2YIxQoGvBukvoC1CbJ7opS</td>\n",
       "      <td>german pop</td>\n",
       "      <td>65</td>\n",
       "      <td>spotify:artist:2YIxQoGvBukvoC1CbJ7opS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Geegun</td>\n",
       "      <td>5W7N6u4EjCEMKj7bDyzPEC</td>\n",
       "      <td>russian dance,russian dance pop,russian hip ho...</td>\n",
       "      <td>57</td>\n",
       "      <td>spotify:artist:5W7N6u4EjCEMKj7bDyzPEC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gidge</td>\n",
       "      <td>7aibxFH8hIlSUlXgshCgAP</td>\n",
       "      <td>electronica,italian electronica,microhouse</td>\n",
       "      <td>49</td>\n",
       "      <td>spotify:artist:7aibxFH8hIlSUlXgshCgAP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Peter Fox</td>\n",
       "      <td>6rqlONGmPuP2wJVSfliLBI</td>\n",
       "      <td>german hip hop,german pop,german rock</td>\n",
       "      <td>61</td>\n",
       "      <td>spotify:artist:6rqlONGmPuP2wJVSfliLBI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Chris Rock</td>\n",
       "      <td>36eSjIksD6fehqxyDUHDA3</td>\n",
       "      <td>black comedy,comedy</td>\n",
       "      <td>48</td>\n",
       "      <td>spotify:artist:36eSjIksD6fehqxyDUHDA3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Carnage</td>\n",
       "      <td>7CCjtD0hCK005Bvg2WG1a7</td>\n",
       "      <td>edm,electro house,electronic trap,pop rap,rap,...</td>\n",
       "      <td>64</td>\n",
       "      <td>spotify:artist:7CCjtD0hCK005Bvg2WG1a7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Wardruna</td>\n",
       "      <td>0NJ6wlOAsAJ1PN4VRdTPKA</td>\n",
       "      <td>medieval folk,nordic folk,rune folk,viking folk</td>\n",
       "      <td>62</td>\n",
       "      <td>spotify:artist:0NJ6wlOAsAJ1PN4VRdTPKA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Motörhead</td>\n",
       "      <td>1DFr97A9HnbV3SKTJFu62M</td>\n",
       "      <td>album rock,alternative metal,hard rock,metal,r...</td>\n",
       "      <td>68</td>\n",
       "      <td>spotify:artist:1DFr97A9HnbV3SKTJFu62M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Thirty Seconds To Mars</td>\n",
       "      <td>0RqtSIYZmd4fiBKVFqyIqD</td>\n",
       "      <td>modern rock,post-grunge,rock</td>\n",
       "      <td>70</td>\n",
       "      <td>spotify:artist:0RqtSIYZmd4fiBKVFqyIqD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      name                      id  \\\n",
       "0             Joyner Lucas  6C1ohJrd5VydigQtaGy5Wa   \n",
       "1            Fynn Kliemann  2YIxQoGvBukvoC1CbJ7opS   \n",
       "2                   Geegun  5W7N6u4EjCEMKj7bDyzPEC   \n",
       "3                    Gidge  7aibxFH8hIlSUlXgshCgAP   \n",
       "4                Peter Fox  6rqlONGmPuP2wJVSfliLBI   \n",
       "..                     ...                     ...   \n",
       "45              Chris Rock  36eSjIksD6fehqxyDUHDA3   \n",
       "46                 Carnage  7CCjtD0hCK005Bvg2WG1a7   \n",
       "47                Wardruna  0NJ6wlOAsAJ1PN4VRdTPKA   \n",
       "48               Motörhead  1DFr97A9HnbV3SKTJFu62M   \n",
       "49  Thirty Seconds To Mars  0RqtSIYZmd4fiBKVFqyIqD   \n",
       "\n",
       "                                               genres  popularity  \\\n",
       "0                  boston hip hop,hip hop,pop rap,rap          78   \n",
       "1                                          german pop          65   \n",
       "2   russian dance,russian dance pop,russian hip ho...          57   \n",
       "3          electronica,italian electronica,microhouse          49   \n",
       "4               german hip hop,german pop,german rock          61   \n",
       "..                                                ...         ...   \n",
       "45                                black comedy,comedy          48   \n",
       "46  edm,electro house,electronic trap,pop rap,rap,...          64   \n",
       "47    medieval folk,nordic folk,rune folk,viking folk          62   \n",
       "48  album rock,alternative metal,hard rock,metal,r...          68   \n",
       "49                       modern rock,post-grunge,rock          70   \n",
       "\n",
       "                                      uri  \n",
       "0   spotify:artist:6C1ohJrd5VydigQtaGy5Wa  \n",
       "1   spotify:artist:2YIxQoGvBukvoC1CbJ7opS  \n",
       "2   spotify:artist:5W7N6u4EjCEMKj7bDyzPEC  \n",
       "3   spotify:artist:7aibxFH8hIlSUlXgshCgAP  \n",
       "4   spotify:artist:6rqlONGmPuP2wJVSfliLBI  \n",
       "..                                    ...  \n",
       "45  spotify:artist:36eSjIksD6fehqxyDUHDA3  \n",
       "46  spotify:artist:7CCjtD0hCK005Bvg2WG1a7  \n",
       "47  spotify:artist:0NJ6wlOAsAJ1PN4VRdTPKA  \n",
       "48  spotify:artist:1DFr97A9HnbV3SKTJFu62M  \n",
       "49  spotify:artist:0RqtSIYZmd4fiBKVFqyIqD  \n",
       "\n",
       "[141 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "artists_short_df = top_artists_from_API(top_artists_short)\n",
    "artists_med_df = top_artists_from_API(top_artists_med)\n",
    "artists_long_df = top_artists_from_API(top_artists_long)\n",
    "artists_df = pd.concat([artists_short_df,artists_med_df,artists_long_df])\n",
    "artists_df[\"genres\"] = artists_df[\"genres\"].apply(lambda x: \",\".join(x))\n",
    "artists_df.drop_duplicates().reset_index(drop = True)\n",
    "artists_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Working with the saved tracks (only the last 50)\n",
    "\n",
    "The dictionary follows a different structure than the one for top_tracks, a new function will be necessary. \n",
    "\n",
    "Let's first explore the structure and try to access the info we want."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['album', 'artists', 'available_markets', 'disc_number', 'duration_ms', 'explicit', 'external_ids', 'external_urls', 'href', 'id', 'is_local', 'name', 'popularity', 'preview_url', 'track_number', 'type', 'uri'])"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"].keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'I Fell In Love'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"name\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Autumn Bells'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"album\"][\"name\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Gidge'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"artists\"][0][\"name\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "44"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"popularity\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0zrHx4EhLePXUa8KhGpS3E'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"id\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "385726"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_saved_tracks[\"items\"][0][\"track\"][\"duration_ms\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# def create_df_saved_songs(api_results):\n",
    "#     track_name = []\n",
    "#     track_id = []\n",
    "#     artist = []\n",
    "#     album = []\n",
    "#     duration = []\n",
    "#     popularity = []\n",
    "#     for items in api_results[\"items\"]:\n",
    "#         try:\n",
    "#             track_name.append(items[\"track\"]['name'])\n",
    "#             track_id.append(items[\"track\"]['id'])\n",
    "#             artist.append(items[\"track\"][\"artists\"][0][\"name\"])\n",
    "#             duration.append(items[\"track\"][\"duration_ms\"])\n",
    "#             album.append(items[\"track\"][\"album\"][\"name\"])\n",
    "#             popularity.append(items[\"track\"][\"popularity\"])\n",
    "#         except TypeError: \n",
    "#             pass\n",
    "\n",
    "#     # Create the final df   \n",
    "#     df = pd.DataFrame({ \"track_name\": track_name, \n",
    "#                              \"album\": album, \n",
    "#                              \"track_id\": track_id,\n",
    "#                              \"artist\": artist, \n",
    "#                              \"duration\": duration, \n",
    "#                              \"popularity\": popularity})\n",
    "#     return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "saved_tracks_df = create_df_saved_songs(user_saved_tracks)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>track_name</th>\n",
       "      <th>album</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist</th>\n",
       "      <th>duration</th>\n",
       "      <th>popularity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>I Fell In Love</td>\n",
       "      <td>Autumn Bells</td>\n",
       "      <td>0zrHx4EhLePXUa8KhGpS3E</td>\n",
       "      <td>Gidge</td>\n",
       "      <td>385726</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Beginning</td>\n",
       "      <td>The Beginning</td>\n",
       "      <td>4njhWDhTAjhReWtYkiMH9t</td>\n",
       "      <td>NR:TN</td>\n",
       "      <td>201904</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Between Breaths</td>\n",
       "      <td>Stateless</td>\n",
       "      <td>4DJGTc1OsgqFsUGI6W8Mtx</td>\n",
       "      <td>Riyoon</td>\n",
       "      <td>479885</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Berlin Nights</td>\n",
       "      <td>Berlin Nights</td>\n",
       "      <td>6gG1R1bFdJeNc2ERAwXxCb</td>\n",
       "      <td>Vnce Dolanbay</td>\n",
       "      <td>292115</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fall Slowly (feat. Ashanti) - Extended Version</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>7wK4pOTZKVaAJ00rziu901</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>292056</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Evolution</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>2VopDw2GlF3uwD1kihHmTT</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>153250</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Zim Zimma</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>17nPeSliosCi427f0lUb75</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>239702</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Money In The Grave (Drake ft. Rick Ross)</td>\n",
       "      <td>The Best In The World Pack</td>\n",
       "      <td>5ry2OE6R2zPQFDO85XkgRb</td>\n",
       "      <td>Drake</td>\n",
       "      <td>205426</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Beifahrersitz</td>\n",
       "      <td>Beifahrersitz</td>\n",
       "      <td>01qOl2pM8emx1sxdBQc05g</td>\n",
       "      <td>LEA</td>\n",
       "      <td>199586</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Twingo</td>\n",
       "      <td>POP</td>\n",
       "      <td>6vFEvkXOnOTUMgPHxogIRK</td>\n",
       "      <td>Fynn Kliemann</td>\n",
       "      <td>186984</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ADHD</td>\n",
       "      <td>ADHD</td>\n",
       "      <td>4X4v3KtkUXwXvDBw5KS9cp</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>205872</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Fall Slowly</td>\n",
       "      <td>Fall Slowly</td>\n",
       "      <td>01WOwxkxOw2FqNIHkraxcN</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>208095</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>When I'm Small</td>\n",
       "      <td>Eyelid Movies</td>\n",
       "      <td>3498wF96LsgVgMkGmJzJOC</td>\n",
       "      <td>Phantogram</td>\n",
       "      <td>249066</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Desert Woman</td>\n",
       "      <td>RINGOS DESERT</td>\n",
       "      <td>4O1nIKXTS87DKHIQejrn3n</td>\n",
       "      <td>ZHU</td>\n",
       "      <td>374610</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Risky Business - Mathame Remix</td>\n",
       "      <td>Risky Business (Mathame Remix)</td>\n",
       "      <td>5R4hprpCcdgKz1DsPoh9p2</td>\n",
       "      <td>ZHU</td>\n",
       "      <td>410078</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Aura</td>\n",
       "      <td>Aura (Exclusive Version)</td>\n",
       "      <td>6sDb7wNlVXQGqnhEHiNt8B</td>\n",
       "      <td>Kool Savas</td>\n",
       "      <td>168093</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Blackout</td>\n",
       "      <td>EROS (2018)</td>\n",
       "      <td>7s2s2QBaO8cRhyBssmjI1q</td>\n",
       "      <td>RIN</td>\n",
       "      <td>168013</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Who - Single Version</td>\n",
       "      <td>Who</td>\n",
       "      <td>0CjBORMsmiQNe3vPDcNIvk</td>\n",
       "      <td>Modeselektor</td>\n",
       "      <td>207988</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ghostkeeper</td>\n",
       "      <td>Ghostkeeper</td>\n",
       "      <td>13EMVBU1hcy5yJdX1Xhf9a</td>\n",
       "      <td>Klangkarussell</td>\n",
       "      <td>331381</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Falling</td>\n",
       "      <td>Falling</td>\n",
       "      <td>4WA4jmG98kErhzC9oNf8Sx</td>\n",
       "      <td>Besomorph</td>\n",
       "      <td>149571</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Five Minutes - Zimmer Remix</td>\n",
       "      <td>Five Minutes (Remixes)</td>\n",
       "      <td>4X864m4tHKfMyfPUzJzqqd</td>\n",
       "      <td>Her</td>\n",
       "      <td>342105</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Five Minutes</td>\n",
       "      <td>Five Minutes</td>\n",
       "      <td>3pJnvBbwIvuwebHHTYzoR3</td>\n",
       "      <td>Her</td>\n",
       "      <td>224672</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>The Man With the Red Face - Video Edit</td>\n",
       "      <td>Unreasonable Behaviour</td>\n",
       "      <td>3FwsjsakjJkeLotPOGIr7s</td>\n",
       "      <td>Laurent Garnier</td>\n",
       "      <td>551493</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Man With The Red Face - Radio Edit</td>\n",
       "      <td>Man With The Red Face</td>\n",
       "      <td>5FDn1oWUD5BXL2HCfmCk2F</td>\n",
       "      <td>Mark Knight</td>\n",
       "      <td>235039</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Slap the Ghost</td>\n",
       "      <td>Slap the Ghost / Stinger</td>\n",
       "      <td>4RRNgDu0Mas7w3DUZm62Jk</td>\n",
       "      <td>Misanthrop</td>\n",
       "      <td>234429</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>You.Won't.Do.Shit</td>\n",
       "      <td>SWAN DIVE</td>\n",
       "      <td>61wOkYtKm5AwDbIhl05W0C</td>\n",
       "      <td>convolk</td>\n",
       "      <td>145582</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Full Metal</td>\n",
       "      <td>Full Metal</td>\n",
       "      <td>3oMueNQTlVgOdIfFP9ENz9</td>\n",
       "      <td>BVDLVD</td>\n",
       "      <td>224400</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Lost In The Static</td>\n",
       "      <td>Lost In The Static</td>\n",
       "      <td>6iGXUJW99KAwbRiwxIjKPU</td>\n",
       "      <td>After The Burial</td>\n",
       "      <td>273194</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bounce Back (feat. Jay Anthony)</td>\n",
       "      <td>Bounce Back (feat. Jay Anthony)</td>\n",
       "      <td>6zsPaeGXa4UxM3EBzlFyjN</td>\n",
       "      <td>Rexx Life Raj</td>\n",
       "      <td>249882</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>So Far</td>\n",
       "      <td>Broadchurch (Music From The Original TV Series)</td>\n",
       "      <td>6oVhL0lLUMswqSV3VcKwJO</td>\n",
       "      <td>Ólafur Arnalds</td>\n",
       "      <td>272014</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Idol (feat. Tech N9ne)</td>\n",
       "      <td>Idol (feat. Tech N9ne)</td>\n",
       "      <td>3bLU7rl0xkgzcLPYHO3HuK</td>\n",
       "      <td>Hollywood Undead</td>\n",
       "      <td>247154</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Phoenix</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>6zAiRKvAMlXHxEtyO4yxIO</td>\n",
       "      <td>League of Legends</td>\n",
       "      <td>197633</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>YAYA</td>\n",
       "      <td>YAYA</td>\n",
       "      <td>6EfBMJQwe2xLgldra6DaYp</td>\n",
       "      <td>6ix9ine</td>\n",
       "      <td>149857</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Light Rain</td>\n",
       "      <td>Sleep (Rain Sounds Compilation)</td>\n",
       "      <td>3BA4y1ENVDOeT7XP82sk09</td>\n",
       "      <td>Chill Bees</td>\n",
       "      <td>188598</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Over Now</td>\n",
       "      <td>beerbongs &amp; bentleys</td>\n",
       "      <td>09IOPhEh1OMe0HD9b36FJk</td>\n",
       "      <td>Post Malone</td>\n",
       "      <td>246986</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Grave - Stripped</td>\n",
       "      <td>Grave (Stripped)</td>\n",
       "      <td>5CAY4BdezEpG9qiERXktBz</td>\n",
       "      <td>Wage War</td>\n",
       "      <td>196015</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>ERROR</td>\n",
       "      <td>ERROR</td>\n",
       "      <td>1EDp2rxkQSznqL2u5H5Z5U</td>\n",
       "      <td>KLOUD</td>\n",
       "      <td>240000</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Killer</td>\n",
       "      <td>Killer</td>\n",
       "      <td>0h6oAoexZGyHKayxVPcwpU</td>\n",
       "      <td>Coopex</td>\n",
       "      <td>195951</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>BURNING</td>\n",
       "      <td>BURNING</td>\n",
       "      <td>520okjtLo9gYtfYPyyqzPT</td>\n",
       "      <td>Miscris</td>\n",
       "      <td>190760</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Alarm</td>\n",
       "      <td>Alarm</td>\n",
       "      <td>0TQvtNvWhJxSrHyq6sJORx</td>\n",
       "      <td>Frontliner</td>\n",
       "      <td>124631</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Stargazing - Remix</td>\n",
       "      <td>Stargazing (Remix)</td>\n",
       "      <td>1HK6TWeHG9q5upt2WcI0sw</td>\n",
       "      <td>Yung Eazy</td>\n",
       "      <td>174262</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Omertà</td>\n",
       "      <td>The Best In The World Pack</td>\n",
       "      <td>3kCwyvhvVTyehIzYN2I0nF</td>\n",
       "      <td>Drake</td>\n",
       "      <td>219506</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Generation YouPorn - Agia Napa Edit</td>\n",
       "      <td>Gefällt euch Faber so besser? EP</td>\n",
       "      <td>3kwVVzIFs3kkncZhE0aXPN</td>\n",
       "      <td>Faber</td>\n",
       "      <td>202369</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>C'est La Vie</td>\n",
       "      <td>Part Two</td>\n",
       "      <td>5VawgLrsO34HG1sZK0abiE</td>\n",
       "      <td>Pop Talk</td>\n",
       "      <td>188272</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Dreams</td>\n",
       "      <td>Dreams</td>\n",
       "      <td>3oJbhteEJPFZgyax1xBSxb</td>\n",
       "      <td>Theis EZ</td>\n",
       "      <td>184637</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Fire in Me</td>\n",
       "      <td>Forged Memories</td>\n",
       "      <td>6I43srowpNolBY5FGEb5bg</td>\n",
       "      <td>Dexperia</td>\n",
       "      <td>219636</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        track_name  \\\n",
       "0                                   I Fell In Love   \n",
       "1                                    The Beginning   \n",
       "2                                  Between Breaths   \n",
       "3                                    Berlin Nights   \n",
       "4   Fall Slowly (feat. Ashanti) - Extended Version   \n",
       "5                                        Evolution   \n",
       "6                                        Zim Zimma   \n",
       "7         Money In The Grave (Drake ft. Rick Ross)   \n",
       "8                                    Beifahrersitz   \n",
       "9                                           Twingo   \n",
       "10                                            ADHD   \n",
       "11                                     Fall Slowly   \n",
       "12                                  When I'm Small   \n",
       "13                                    Desert Woman   \n",
       "14                  Risky Business - Mathame Remix   \n",
       "15                                            Aura   \n",
       "16                                        Blackout   \n",
       "17                            Who - Single Version   \n",
       "18                                     Ghostkeeper   \n",
       "19                                         Falling   \n",
       "20                     Five Minutes - Zimmer Remix   \n",
       "21                                    Five Minutes   \n",
       "22          The Man With the Red Face - Video Edit   \n",
       "23              Man With The Red Face - Radio Edit   \n",
       "24                                  Slap the Ghost   \n",
       "25                               You.Won't.Do.Shit   \n",
       "26                                      Full Metal   \n",
       "27                              Lost In The Static   \n",
       "28                 Bounce Back (feat. Jay Anthony)   \n",
       "29                                          So Far   \n",
       "30                          Idol (feat. Tech N9ne)   \n",
       "31                                         Phoenix   \n",
       "32                                            YAYA   \n",
       "33                                      Light Rain   \n",
       "34                                        Over Now   \n",
       "35                                Grave - Stripped   \n",
       "36                                           ERROR   \n",
       "37                                          Killer   \n",
       "38                                         BURNING   \n",
       "39                                           Alarm   \n",
       "40                              Stargazing - Remix   \n",
       "41                                          Omertà   \n",
       "42             Generation YouPorn - Agia Napa Edit   \n",
       "43                                    C'est La Vie   \n",
       "44                                          Dreams   \n",
       "45                                      Fire in Me   \n",
       "\n",
       "                                              album                track_id  \\\n",
       "0                                      Autumn Bells  0zrHx4EhLePXUa8KhGpS3E   \n",
       "1                                     The Beginning  4njhWDhTAjhReWtYkiMH9t   \n",
       "2                                         Stateless  4DJGTc1OsgqFsUGI6W8Mtx   \n",
       "3                                     Berlin Nights  6gG1R1bFdJeNc2ERAwXxCb   \n",
       "4                                         Evolution  7wK4pOTZKVaAJ00rziu901   \n",
       "5                                         Evolution  2VopDw2GlF3uwD1kihHmTT   \n",
       "6                                         Evolution  17nPeSliosCi427f0lUb75   \n",
       "7                        The Best In The World Pack  5ry2OE6R2zPQFDO85XkgRb   \n",
       "8                                     Beifahrersitz  01qOl2pM8emx1sxdBQc05g   \n",
       "9                                               POP  6vFEvkXOnOTUMgPHxogIRK   \n",
       "10                                             ADHD  4X4v3KtkUXwXvDBw5KS9cp   \n",
       "11                                      Fall Slowly  01WOwxkxOw2FqNIHkraxcN   \n",
       "12                                    Eyelid Movies  3498wF96LsgVgMkGmJzJOC   \n",
       "13                                    RINGOS DESERT  4O1nIKXTS87DKHIQejrn3n   \n",
       "14                   Risky Business (Mathame Remix)  5R4hprpCcdgKz1DsPoh9p2   \n",
       "15                         Aura (Exclusive Version)  6sDb7wNlVXQGqnhEHiNt8B   \n",
       "16                                      EROS (2018)  7s2s2QBaO8cRhyBssmjI1q   \n",
       "17                                              Who  0CjBORMsmiQNe3vPDcNIvk   \n",
       "18                                      Ghostkeeper  13EMVBU1hcy5yJdX1Xhf9a   \n",
       "19                                          Falling  4WA4jmG98kErhzC9oNf8Sx   \n",
       "20                           Five Minutes (Remixes)  4X864m4tHKfMyfPUzJzqqd   \n",
       "21                                     Five Minutes  3pJnvBbwIvuwebHHTYzoR3   \n",
       "22                           Unreasonable Behaviour  3FwsjsakjJkeLotPOGIr7s   \n",
       "23                            Man With The Red Face  5FDn1oWUD5BXL2HCfmCk2F   \n",
       "24                         Slap the Ghost / Stinger  4RRNgDu0Mas7w3DUZm62Jk   \n",
       "25                                        SWAN DIVE  61wOkYtKm5AwDbIhl05W0C   \n",
       "26                                       Full Metal  3oMueNQTlVgOdIfFP9ENz9   \n",
       "27                               Lost In The Static  6iGXUJW99KAwbRiwxIjKPU   \n",
       "28                  Bounce Back (feat. Jay Anthony)  6zsPaeGXa4UxM3EBzlFyjN   \n",
       "29  Broadchurch (Music From The Original TV Series)  6oVhL0lLUMswqSV3VcKwJO   \n",
       "30                           Idol (feat. Tech N9ne)  3bLU7rl0xkgzcLPYHO3HuK   \n",
       "31                                          Phoenix  6zAiRKvAMlXHxEtyO4yxIO   \n",
       "32                                             YAYA  6EfBMJQwe2xLgldra6DaYp   \n",
       "33                  Sleep (Rain Sounds Compilation)  3BA4y1ENVDOeT7XP82sk09   \n",
       "34                             beerbongs & bentleys  09IOPhEh1OMe0HD9b36FJk   \n",
       "35                                 Grave (Stripped)  5CAY4BdezEpG9qiERXktBz   \n",
       "36                                            ERROR  1EDp2rxkQSznqL2u5H5Z5U   \n",
       "37                                           Killer  0h6oAoexZGyHKayxVPcwpU   \n",
       "38                                          BURNING  520okjtLo9gYtfYPyyqzPT   \n",
       "39                                            Alarm  0TQvtNvWhJxSrHyq6sJORx   \n",
       "40                               Stargazing (Remix)  1HK6TWeHG9q5upt2WcI0sw   \n",
       "41                       The Best In The World Pack  3kCwyvhvVTyehIzYN2I0nF   \n",
       "42                 Gefällt euch Faber so besser? EP  3kwVVzIFs3kkncZhE0aXPN   \n",
       "43                                         Part Two  5VawgLrsO34HG1sZK0abiE   \n",
       "44                                           Dreams  3oJbhteEJPFZgyax1xBSxb   \n",
       "45                                  Forged Memories  6I43srowpNolBY5FGEb5bg   \n",
       "\n",
       "               artist  duration  popularity  \n",
       "0               Gidge    385726          44  \n",
       "1               NR:TN    201904          44  \n",
       "2              Riyoon    479885          43  \n",
       "3       Vnce Dolanbay    292115          39  \n",
       "4        Joyner Lucas    292056          59  \n",
       "5        Joyner Lucas    153250          62  \n",
       "6        Joyner Lucas    239702          70  \n",
       "7               Drake    205426          81  \n",
       "8                 LEA    199586          71  \n",
       "9       Fynn Kliemann    186984          56  \n",
       "10       Joyner Lucas    205872          70  \n",
       "11       Joyner Lucas    208095          64  \n",
       "12         Phantogram    249066           0  \n",
       "13                ZHU    374610          44  \n",
       "14                ZHU    410078          46  \n",
       "15         Kool Savas    168093          54  \n",
       "16                RIN    168013           0  \n",
       "17       Modeselektor    207988          42  \n",
       "18     Klangkarussell    331381          64  \n",
       "19          Besomorph    149571          55  \n",
       "20                Her    342105          36  \n",
       "21                Her    224672           0  \n",
       "22    Laurent Garnier    551493          49  \n",
       "23        Mark Knight    235039          52  \n",
       "24         Misanthrop    234429          38  \n",
       "25            convolk    145582          52  \n",
       "26             BVDLVD    224400          40  \n",
       "27   After The Burial    273194           0  \n",
       "28      Rexx Life Raj    249882          51  \n",
       "29     Ólafur Arnalds    272014          55  \n",
       "30   Hollywood Undead    247154          62  \n",
       "31  League of Legends    197633          75  \n",
       "32            6ix9ine    149857          68  \n",
       "33         Chill Bees    188598          61  \n",
       "34        Post Malone    246986          71  \n",
       "35           Wage War    196015          44  \n",
       "36              KLOUD    240000          51  \n",
       "37             Coopex    195951          40  \n",
       "38            Miscris    190760          34  \n",
       "39         Frontliner    124631          42  \n",
       "40          Yung Eazy    174262          38  \n",
       "41              Drake    219506          61  \n",
       "42              Faber    202369          30  \n",
       "43           Pop Talk    188272          39  \n",
       "44           Theis EZ    184637          23  \n",
       "45           Dexperia    219636          42  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "saved_tracks_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>track_name</th>\n",
       "      <th>album</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist</th>\n",
       "      <th>duration</th>\n",
       "      <th>popularity</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10 Feet Down</td>\n",
       "      <td>Perception</td>\n",
       "      <td>68biLwi894rMQPeIiSky2t</td>\n",
       "      <td>NF</td>\n",
       "      <td>217106</td>\n",
       "      <td>63</td>\n",
       "      <td>0.620</td>\n",
       "      <td>0.835</td>\n",
       "      <td>5</td>\n",
       "      <td>-6.634</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0984</td>\n",
       "      <td>0.096400</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.269</td>\n",
       "      <td>0.0535</td>\n",
       "      <td>96.090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Let You Down</td>\n",
       "      <td>Perception</td>\n",
       "      <td>52okn5MNA47tk87PeZJLEL</td>\n",
       "      <td>NF</td>\n",
       "      <td>212120</td>\n",
       "      <td>82</td>\n",
       "      <td>0.662</td>\n",
       "      <td>0.714</td>\n",
       "      <td>5</td>\n",
       "      <td>-5.680</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1210</td>\n",
       "      <td>0.312000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.4640</td>\n",
       "      <td>147.997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fall Slowly (feat. Ashanti) - Extended Version</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>7wK4pOTZKVaAJ00rziu901</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>292056</td>\n",
       "      <td>59</td>\n",
       "      <td>0.542</td>\n",
       "      <td>0.453</td>\n",
       "      <td>6</td>\n",
       "      <td>-11.208</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0.204000</td>\n",
       "      <td>0.000007</td>\n",
       "      <td>0.137</td>\n",
       "      <td>0.0375</td>\n",
       "      <td>88.310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Zuhause</td>\n",
       "      <td>Nie</td>\n",
       "      <td>5vC4M4GjYLkgDaUwQcL7WA</td>\n",
       "      <td>Fynn Kliemann</td>\n",
       "      <td>197887</td>\n",
       "      <td>65</td>\n",
       "      <td>0.656</td>\n",
       "      <td>0.448</td>\n",
       "      <td>9</td>\n",
       "      <td>-8.676</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0442</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>0.103</td>\n",
       "      <td>0.4030</td>\n",
       "      <td>95.626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rolls Royce</td>\n",
       "      <td>Rolls Royce</td>\n",
       "      <td>22XFe65IH0P2RY0uowBqdI</td>\n",
       "      <td>Geegun</td>\n",
       "      <td>143437</td>\n",
       "      <td>68</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.423</td>\n",
       "      <td>1</td>\n",
       "      <td>-7.337</td>\n",
       "      <td>1</td>\n",
       "      <td>0.2130</td>\n",
       "      <td>0.142000</td>\n",
       "      <td>0.000010</td>\n",
       "      <td>0.104</td>\n",
       "      <td>0.3730</td>\n",
       "      <td>95.980</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Like A G6</td>\n",
       "      <td>Like a G6</td>\n",
       "      <td>5S1yeuswEPofFOCkMFLNLc</td>\n",
       "      <td>Far East Movement</td>\n",
       "      <td>218346</td>\n",
       "      <td>0</td>\n",
       "      <td>0.629</td>\n",
       "      <td>0.869</td>\n",
       "      <td>7</td>\n",
       "      <td>-7.013</td>\n",
       "      <td>0</td>\n",
       "      <td>0.3140</td>\n",
       "      <td>0.006570</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.191</td>\n",
       "      <td>0.7150</td>\n",
       "      <td>125.024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Halftime</td>\n",
       "      <td>Wolke 7</td>\n",
       "      <td>1N9ZAbqVw5o0m7wccSgRIt</td>\n",
       "      <td>Gzuz</td>\n",
       "      <td>181060</td>\n",
       "      <td>1</td>\n",
       "      <td>0.533</td>\n",
       "      <td>0.783</td>\n",
       "      <td>2</td>\n",
       "      <td>-6.490</td>\n",
       "      <td>1</td>\n",
       "      <td>0.3250</td>\n",
       "      <td>0.181000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.101</td>\n",
       "      <td>0.4710</td>\n",
       "      <td>129.844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Push It</td>\n",
       "      <td>Wisconsin Death Trip</td>\n",
       "      <td>43WFwjiWFHc8ZryT1Tz1aY</td>\n",
       "      <td>Static-X</td>\n",
       "      <td>154906</td>\n",
       "      <td>36</td>\n",
       "      <td>0.557</td>\n",
       "      <td>0.977</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.965</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0493</td>\n",
       "      <td>0.000393</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.291</td>\n",
       "      <td>0.5040</td>\n",
       "      <td>149.879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Talk Shit, Get Shot</td>\n",
       "      <td>Manslaughter</td>\n",
       "      <td>2rsho1vI3L5o65QOjM5Mwx</td>\n",
       "      <td>Body Count</td>\n",
       "      <td>227147</td>\n",
       "      <td>39</td>\n",
       "      <td>0.455</td>\n",
       "      <td>0.993</td>\n",
       "      <td>3</td>\n",
       "      <td>-1.952</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2930</td>\n",
       "      <td>0.002350</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.149</td>\n",
       "      <td>0.3840</td>\n",
       "      <td>175.004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>The Beautiful &amp; Damned</td>\n",
       "      <td>The Beautiful &amp; Damned</td>\n",
       "      <td>2WWruw7ul9N7eqoHELyMc2</td>\n",
       "      <td>G-Eazy</td>\n",
       "      <td>189306</td>\n",
       "      <td>60</td>\n",
       "      <td>0.656</td>\n",
       "      <td>0.804</td>\n",
       "      <td>8</td>\n",
       "      <td>-5.191</td>\n",
       "      <td>0</td>\n",
       "      <td>0.3630</td>\n",
       "      <td>0.173000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.837</td>\n",
       "      <td>0.3140</td>\n",
       "      <td>125.882</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>142 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         track_name                   album  \\\n",
       "0                                      10 Feet Down              Perception   \n",
       "1                                      Let You Down              Perception   \n",
       "2    Fall Slowly (feat. Ashanti) - Extended Version               Evolution   \n",
       "3                                           Zuhause                     Nie   \n",
       "4                                       Rolls Royce             Rolls Royce   \n",
       "..                                              ...                     ...   \n",
       "137                                       Like A G6               Like a G6   \n",
       "138                                        Halftime                 Wolke 7   \n",
       "139                                         Push It    Wisconsin Death Trip   \n",
       "140                             Talk Shit, Get Shot            Manslaughter   \n",
       "141                          The Beautiful & Damned  The Beautiful & Damned   \n",
       "\n",
       "                   track_id             artist  duration  popularity  \\\n",
       "0    68biLwi894rMQPeIiSky2t                 NF    217106          63   \n",
       "1    52okn5MNA47tk87PeZJLEL                 NF    212120          82   \n",
       "2    7wK4pOTZKVaAJ00rziu901       Joyner Lucas    292056          59   \n",
       "3    5vC4M4GjYLkgDaUwQcL7WA      Fynn Kliemann    197887          65   \n",
       "4    22XFe65IH0P2RY0uowBqdI             Geegun    143437          68   \n",
       "..                      ...                ...       ...         ...   \n",
       "137  5S1yeuswEPofFOCkMFLNLc  Far East Movement    218346           0   \n",
       "138  1N9ZAbqVw5o0m7wccSgRIt               Gzuz    181060           1   \n",
       "139  43WFwjiWFHc8ZryT1Tz1aY           Static-X    154906          36   \n",
       "140  2rsho1vI3L5o65QOjM5Mwx         Body Count    227147          39   \n",
       "141  2WWruw7ul9N7eqoHELyMc2             G-Eazy    189306          60   \n",
       "\n",
       "     danceability  energy  key  loudness  mode  speechiness  acousticness  \\\n",
       "0           0.620   0.835    5    -6.634     0       0.0984      0.096400   \n",
       "1           0.662   0.714    5    -5.680     0       0.1210      0.312000   \n",
       "2           0.542   0.453    6   -11.208     0       0.2400      0.204000   \n",
       "3           0.656   0.448    9    -8.676     0       0.0442      0.860000   \n",
       "4           0.872   0.423    1    -7.337     1       0.2130      0.142000   \n",
       "..            ...     ...  ...       ...   ...          ...           ...   \n",
       "137         0.629   0.869    7    -7.013     0       0.3140      0.006570   \n",
       "138         0.533   0.783    2    -6.490     1       0.3250      0.181000   \n",
       "139         0.557   0.977    0    -3.965     1       0.0493      0.000393   \n",
       "140         0.455   0.993    3    -1.952     0       0.2930      0.002350   \n",
       "141         0.656   0.804    8    -5.191     0       0.3630      0.173000   \n",
       "\n",
       "     instrumentalness  liveness  valence    tempo  \n",
       "0            0.000012     0.269   0.0535   96.090  \n",
       "1            0.000000     0.179   0.4640  147.997  \n",
       "2            0.000007     0.137   0.0375   88.310  \n",
       "3            0.000005     0.103   0.4030   95.626  \n",
       "4            0.000010     0.104   0.3730   95.980  \n",
       "..                ...       ...      ...      ...  \n",
       "137          0.000000     0.191   0.7150  125.024  \n",
       "138          0.000000     0.101   0.4710  129.844  \n",
       "139          0.000004     0.291   0.5040  149.879  \n",
       "140          0.000000     0.149   0.3840  175.004  \n",
       "141          0.000000     0.837   0.3140  125.882  \n",
       "\n",
       "[142 rows x 17 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#combine the top_tracks\n",
    "top_tracks_short_df = append_audio_features(create_df_top_songs(top_tracks_short),sp)\n",
    "top_tracks_med_df = append_audio_features(create_df_top_songs(top_tracks_med),sp)\n",
    "top_tracks_long_df = append_audio_features(create_df_top_songs(top_tracks_long),sp)\n",
    "top_tracks_df = pd.concat([top_tracks_short_df,top_tracks_med_df,top_tracks_long_df]).drop_duplicates().reset_index(drop = True)\n",
    "top_tracks_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "saved_tracks_df = append_audio_features(saved_tracks_df,sp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>track_name</th>\n",
       "      <th>album</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist</th>\n",
       "      <th>duration</th>\n",
       "      <th>popularity</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>I Fell In Love</td>\n",
       "      <td>Autumn Bells</td>\n",
       "      <td>0zrHx4EhLePXUa8KhGpS3E</td>\n",
       "      <td>Gidge</td>\n",
       "      <td>385726</td>\n",
       "      <td>44</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0.610</td>\n",
       "      <td>8</td>\n",
       "      <td>-10.999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1340</td>\n",
       "      <td>0.12100</td>\n",
       "      <td>0.809000</td>\n",
       "      <td>0.0857</td>\n",
       "      <td>0.0395</td>\n",
       "      <td>123.218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Beginning</td>\n",
       "      <td>The Beginning</td>\n",
       "      <td>4njhWDhTAjhReWtYkiMH9t</td>\n",
       "      <td>NR:TN</td>\n",
       "      <td>201904</td>\n",
       "      <td>44</td>\n",
       "      <td>0.783</td>\n",
       "      <td>0.714</td>\n",
       "      <td>7</td>\n",
       "      <td>-7.408</td>\n",
       "      <td>1</td>\n",
       "      <td>0.2460</td>\n",
       "      <td>0.24300</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>0.4460</td>\n",
       "      <td>0.0341</td>\n",
       "      <td>125.955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Between Breaths</td>\n",
       "      <td>Stateless</td>\n",
       "      <td>4DJGTc1OsgqFsUGI6W8Mtx</td>\n",
       "      <td>Riyoon</td>\n",
       "      <td>479885</td>\n",
       "      <td>43</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.665</td>\n",
       "      <td>7</td>\n",
       "      <td>-10.441</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0438</td>\n",
       "      <td>0.00748</td>\n",
       "      <td>0.877000</td>\n",
       "      <td>0.5820</td>\n",
       "      <td>0.0347</td>\n",
       "      <td>99.992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Berlin Nights</td>\n",
       "      <td>Berlin Nights</td>\n",
       "      <td>6gG1R1bFdJeNc2ERAwXxCb</td>\n",
       "      <td>Vnce Dolanbay</td>\n",
       "      <td>292115</td>\n",
       "      <td>39</td>\n",
       "      <td>0.901</td>\n",
       "      <td>0.457</td>\n",
       "      <td>10</td>\n",
       "      <td>-13.238</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1630</td>\n",
       "      <td>0.22900</td>\n",
       "      <td>0.424000</td>\n",
       "      <td>0.0977</td>\n",
       "      <td>0.5310</td>\n",
       "      <td>127.999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fall Slowly (feat. Ashanti) - Extended Version</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>7wK4pOTZKVaAJ00rziu901</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>292056</td>\n",
       "      <td>59</td>\n",
       "      <td>0.542</td>\n",
       "      <td>0.453</td>\n",
       "      <td>6</td>\n",
       "      <td>-11.208</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0.20400</td>\n",
       "      <td>0.000007</td>\n",
       "      <td>0.1370</td>\n",
       "      <td>0.0375</td>\n",
       "      <td>88.310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Evolution</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>2VopDw2GlF3uwD1kihHmTT</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>153250</td>\n",
       "      <td>62</td>\n",
       "      <td>0.687</td>\n",
       "      <td>0.819</td>\n",
       "      <td>9</td>\n",
       "      <td>-6.670</td>\n",
       "      <td>0</td>\n",
       "      <td>0.4310</td>\n",
       "      <td>0.21800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3920</td>\n",
       "      <td>0.5680</td>\n",
       "      <td>81.185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Zim Zimma</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>17nPeSliosCi427f0lUb75</td>\n",
       "      <td>Joyner Lucas</td>\n",
       "      <td>239702</td>\n",
       "      <td>70</td>\n",
       "      <td>0.883</td>\n",
       "      <td>0.621</td>\n",
       "      <td>11</td>\n",
       "      <td>-6.063</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2120</td>\n",
       "      <td>0.08710</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.4990</td>\n",
       "      <td>0.6760</td>\n",
       "      <td>149.052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Money In The Grave (Drake ft. Rick Ross)</td>\n",
       "      <td>The Best In The World Pack</td>\n",
       "      <td>5ry2OE6R2zPQFDO85XkgRb</td>\n",
       "      <td>Drake</td>\n",
       "      <td>205426</td>\n",
       "      <td>81</td>\n",
       "      <td>0.831</td>\n",
       "      <td>0.502</td>\n",
       "      <td>10</td>\n",
       "      <td>-4.045</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0460</td>\n",
       "      <td>0.10100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1220</td>\n",
       "      <td>0.1010</td>\n",
       "      <td>100.541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Beifahrersitz</td>\n",
       "      <td>Beifahrersitz</td>\n",
       "      <td>01qOl2pM8emx1sxdBQc05g</td>\n",
       "      <td>LEA</td>\n",
       "      <td>199586</td>\n",
       "      <td>71</td>\n",
       "      <td>0.712</td>\n",
       "      <td>0.774</td>\n",
       "      <td>6</td>\n",
       "      <td>-3.967</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1330</td>\n",
       "      <td>0.34600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1760</td>\n",
       "      <td>0.4710</td>\n",
       "      <td>159.977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Twingo</td>\n",
       "      <td>POP</td>\n",
       "      <td>6vFEvkXOnOTUMgPHxogIRK</td>\n",
       "      <td>Fynn Kliemann</td>\n",
       "      <td>186984</td>\n",
       "      <td>56</td>\n",
       "      <td>0.619</td>\n",
       "      <td>0.638</td>\n",
       "      <td>2</td>\n",
       "      <td>-5.754</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0906</td>\n",
       "      <td>0.29700</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.4400</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>141.967</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       track_name                       album  \\\n",
       "0                                  I Fell In Love                Autumn Bells   \n",
       "1                                   The Beginning               The Beginning   \n",
       "2                                 Between Breaths                   Stateless   \n",
       "3                                   Berlin Nights               Berlin Nights   \n",
       "4  Fall Slowly (feat. Ashanti) - Extended Version                   Evolution   \n",
       "5                                       Evolution                   Evolution   \n",
       "6                                       Zim Zimma                   Evolution   \n",
       "7        Money In The Grave (Drake ft. Rick Ross)  The Best In The World Pack   \n",
       "8                                   Beifahrersitz               Beifahrersitz   \n",
       "9                                          Twingo                         POP   \n",
       "\n",
       "                 track_id         artist  duration  popularity  danceability  \\\n",
       "0  0zrHx4EhLePXUa8KhGpS3E          Gidge    385726          44         0.539   \n",
       "1  4njhWDhTAjhReWtYkiMH9t          NR:TN    201904          44         0.783   \n",
       "2  4DJGTc1OsgqFsUGI6W8Mtx         Riyoon    479885          43         0.738   \n",
       "3  6gG1R1bFdJeNc2ERAwXxCb  Vnce Dolanbay    292115          39         0.901   \n",
       "4  7wK4pOTZKVaAJ00rziu901   Joyner Lucas    292056          59         0.542   \n",
       "5  2VopDw2GlF3uwD1kihHmTT   Joyner Lucas    153250          62         0.687   \n",
       "6  17nPeSliosCi427f0lUb75   Joyner Lucas    239702          70         0.883   \n",
       "7  5ry2OE6R2zPQFDO85XkgRb          Drake    205426          81         0.831   \n",
       "8  01qOl2pM8emx1sxdBQc05g            LEA    199586          71         0.712   \n",
       "9  6vFEvkXOnOTUMgPHxogIRK  Fynn Kliemann    186984          56         0.619   \n",
       "\n",
       "   energy  key  loudness  mode  speechiness  acousticness  instrumentalness  \\\n",
       "0   0.610    8   -10.999     0       0.1340       0.12100          0.809000   \n",
       "1   0.714    7    -7.408     1       0.2460       0.24300          0.860000   \n",
       "2   0.665    7   -10.441     0       0.0438       0.00748          0.877000   \n",
       "3   0.457   10   -13.238     0       0.1630       0.22900          0.424000   \n",
       "4   0.453    6   -11.208     0       0.2400       0.20400          0.000007   \n",
       "5   0.819    9    -6.670     0       0.4310       0.21800          0.000000   \n",
       "6   0.621   11    -6.063     0       0.2120       0.08710          0.000000   \n",
       "7   0.502   10    -4.045     0       0.0460       0.10100          0.000000   \n",
       "8   0.774    6    -3.967     0       0.1330       0.34600          0.000000   \n",
       "9   0.638    2    -5.754     0       0.0906       0.29700          0.000001   \n",
       "\n",
       "   liveness  valence    tempo  \n",
       "0    0.0857   0.0395  123.218  \n",
       "1    0.4460   0.0341  125.955  \n",
       "2    0.5820   0.0347   99.992  \n",
       "3    0.0977   0.5310  127.999  \n",
       "4    0.1370   0.0375   88.310  \n",
       "5    0.3920   0.5680   81.185  \n",
       "6    0.4990   0.6760  149.052  \n",
       "7    0.1220   0.1010  100.541  \n",
       "8    0.1760   0.4710  159.977  \n",
       "9    0.4400   0.3600  141.967  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "saved_tracks_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "similarity_top_tracks = create_similarity_score(top_tracks_df,top_tracks_df)\n",
    "similarity_saved_tracks = create_similarity_score(saved_tracks_df,saved_tracks_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MOSKAU \n",
      "\n",
      "112        Light Rain\n",
      "27            Crainte\n",
      "21     Slap the Ghost\n",
      "89          Magnifico\n",
      "22               Zver\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "FEUER \n",
      "\n",
      "22                          Zver\n",
      "128       I Mean It (feat. Remo)\n",
      "4                    Rolls Royce\n",
      "51                          YAYA\n",
      "16     Creep - R3HAB Chill Remix\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "Nero Forte \n",
      "\n",
      "75                                              Holy War\n",
      "60                                              Unspoken\n",
      "116                                The Sound of Violence\n",
      "95     Still A Full Gentle Racket - Angerfist 2019 Refix\n",
      "103                                           Gold Cobra\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "m.A.A.d city \n",
      "\n",
      "112       Light Rain\n",
      "88       Holy Roller\n",
      "97      m.A.A.d city\n",
      "107    6 Foot 7 Foot\n",
      "75          Holy War\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "Huldra \n",
      "\n",
      "47                                                Huldra\n",
      "49                                Huldra - Other Version\n",
      "24     In The (Last) Moment - Robag's Ponk Pramen NB ...\n",
      "22                                                  Zver\n",
      "112                                           Light Rain\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for track in top_tracks_df[\"track_name\"].sample(5):\n",
    "    print(track, \"\\n\")\n",
    "    print(get_recommendations(top_tracks_df,track,similarity_top_tracks))\n",
    "    print(\"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Idol (feat. Tech N9ne) \n",
      "\n",
      "24        Slap the Ghost\n",
      "41                Omertà\n",
      "34              Over Now\n",
      "27    Lost In The Static\n",
      "38               BURNING\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "Light Rain \n",
      "\n",
      "26         Full Metal\n",
      "2     Between Breaths\n",
      "38            BURNING\n",
      "29             So Far\n",
      "0      I Fell In Love\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "I Fell In Love \n",
      "\n",
      "0                                     I Fell In Love\n",
      "33                                        Light Rain\n",
      "4     Fall Slowly (feat. Ashanti) - Extended Version\n",
      "2                                    Between Breaths\n",
      "14                    Risky Business - Mathame Remix\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "When I'm Small \n",
      "\n",
      "32                 YAYA\n",
      "25    You.Won't.Do.Shit\n",
      "16             Blackout\n",
      "10                 ADHD\n",
      "39                Alarm\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n",
      "Generation YouPorn - Agia Napa Edit \n",
      "\n",
      "29                                            So Far\n",
      "21                                      Five Minutes\n",
      "4     Fall Slowly (feat. Ashanti) - Extended Version\n",
      "42               Generation YouPorn - Agia Napa Edit\n",
      "7           Money In The Grave (Drake ft. Rick Ross)\n",
      "Name: track_name, dtype: object\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for track in saved_tracks_df[\"track_name\"].sample(5):\n",
    "    print(track, \"\\n\")\n",
    "    print(get_recommendations(saved_tracks_df,track,similarity_saved_tracks))\n",
    "    print(\"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "##Playlists\n",
    "#spotify features playlists + get playlist by id\n",
    "#featured_playlists, playlist"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For later use:\n",
    "\n",
    "current_user_saved_tracks\n",
    "- Gets a list of the tracks saved in the current authorized user’s “Your Music” library\n",
    "\n",
    "artist_top_tracks\n",
    "- Get Spotify catalog information about an artist’s top 10 tracks by country. \n",
    "\n",
    "artist_related_artists\n",
    "- Get Spotify catalog information about artists similar to an identified artist. Similarity is based on analysis of the Spotify community’s listening history.\n",
    "\n",
    "playlist_add_items\n",
    "\n",
    "recommendations(seed_artists=None, seed_genres=None, seed_tracks=None, limit=20, country=None, \\*\\*kwargs)\n",
    "- Get a list of recommended tracks for one to five seeds. (at least one of seed_artists, seed_tracks and seed_genres are needed)\n",
    "\n",
    "- Parameters:\n",
    "- seed_artists - a list of artist IDs, URIs or URLs\n",
    "- seed_tracks - a list of track IDs, URIs or URLs\n",
    "- seed_genres - a list of genre names. Available genres for\n",
    "- recommendations can be found by calling recommendation_genre_seeds\n",
    "\n",
    "user_playlist_replace_tracks(user, playlist_id, tracks)\n"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}