dev/Spotify_Scraper_08_Artist_Album_Tracks_Attributes.ipynb

{
 "metadata": {
  "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.3-final"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "Python 3.8.3 64-bit ('base': conda)",
   "display_name": "Python 3.8.3 64-bit ('base': conda)",
   "metadata": {
    "interpreter": {
     "hash": "dca0ade3e726a953b501b15e8e990130d2b7799f14cfd9f4271676035ebe5511"
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2,
 "cells": [
  {
   "source": [
    "# Artist's Look-a-Like\n",
    "\n",
    "This notebook retrieve Motor's artists genre and other related attribute of his/her works.  Attributes quereied are primary from Spotify API.  These attributes are then fed into <>, which ultimate identify other similar artists."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "# 0.) Initialize Parameters"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## a. Libraries"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "output_type": "error",
     "ename": "ModuleNotFoundError",
     "evalue": "No module named 'hausgemachtspotipy'",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mModuleNotFoundError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-1-460cb716a4d3>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;31m# API Client file located locally in ./client/hausgemacht_SpotiPy.py\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0;32mfrom\u001b[0m \u001b[0mhausgemachtspotipy\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhausgemacht_SpotiPy\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mpandas\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mModuleNotFoundError\u001b[0m: No module named 'hausgemachtspotipy'"
     ]
    }
   ],
   "source": [
    "# API Client file located locally in ./client/hausgemacht_SpotiPy.py\n",
    "from hausgemachtspotipy.hausgemacht_SpotiPy import *\n",
    "\n",
    "import pandas as pd\n",
    "import datetime\n",
    "import math"
   ]
  },
  {
   "source": [
    "## b. Credentials"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Spotify\n",
    "client_id = \"cd1845f23d914228b14f6bed139ee594\"\n",
    "client_secret = \"\""
   ]
  },
  {
   "source": [
    "---\n",
    "\n",
    "# 1.) Create connectiont to Spotify API\n",
    "\n",
    "Calling API Client Class, `hausgemacht Spotipy`."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calling API Client Class, `SpotifyAPI`\n",
    "sp = SpotifyAPI(client_id, client_secret)"
   ]
  },
  {
   "source": [
    "---\n",
    "\n",
    "# 2.) Artists"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## a. Import Motor's Artists"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = [\n",
    "    [\"03uMw43UVu9MsQCcHVSGjX\", \"Alice Phoebe Lou\"], \n",
    "    [\"3mmI5HKArDwgggj4j0aJyC\", \"BHZ\"], \n",
    "    [\"3ea4XDPCrAm68rpImApb94\", \"Adam Wendler\"], \n",
    "    [\"1cIilB8ckONPBhSG6IvxSu\", \"ZUSTRA\"], \n",
    "    [\"0SCFEgshN89tlgOPM7lbSB\", \"Alex Stein\"], \n",
    "    [\"6u79NimWxdl5RXgDrnGeqk\", \"Max Raabe & Palast Orchester\"], \n",
    "    [\"78TTCmh2koperK5NBn7DgR\", \"102 BOYZ\"], \n",
    "    [\"13Vka7xGjRHhIOGzvomJZd\", \"Bae.con\"], \n",
    "    [\"3IFgjVPT8yeB4UnJCWOpZA\", \"Teenage Mutants\"], \n",
    "    [\"7FvEqUihbJfx5vpfGd1OLz\", \"Luca Eck\"], \n",
    "    [\"4AScySQVdebovwUwTVWzhN\", \"Inoffiziell.Goldenboy\"], \n",
    "    [\"0kQfuEQhZ0BxRSM5TyKolM\", \"Kellermensch\"], \n",
    "    [\"7ctR7ruX0kn0gUrmbfTzL1\", \"Bobby San\"]\n",
    "]\n",
    "\n",
    "df_artists = pd.DataFrame(data, columns=[\"artist_id\", \"artist_name\"])"
   ]
  },
  {
   "source": [
    "## b. I.D Artist's Genres"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "https://api.spotify.com/v1/artists/03uMw43UVu9MsQCcHVSGjX\n",
      "https://api.spotify.com/v1/artists/3mmI5HKArDwgggj4j0aJyC\n",
      "https://api.spotify.com/v1/artists/3ea4XDPCrAm68rpImApb94\n",
      "https://api.spotify.com/v1/artists/1cIilB8ckONPBhSG6IvxSu\n",
      "https://api.spotify.com/v1/artists/0SCFEgshN89tlgOPM7lbSB\n",
      "https://api.spotify.com/v1/artists/6u79NimWxdl5RXgDrnGeqk\n",
      "https://api.spotify.com/v1/artists/78TTCmh2koperK5NBn7DgR\n",
      "https://api.spotify.com/v1/artists/13Vka7xGjRHhIOGzvomJZd\n",
      "https://api.spotify.com/v1/artists/3IFgjVPT8yeB4UnJCWOpZA\n",
      "https://api.spotify.com/v1/artists/7FvEqUihbJfx5vpfGd1OLz\n",
      "https://api.spotify.com/v1/artists/4AScySQVdebovwUwTVWzhN\n",
      "https://api.spotify.com/v1/artists/0kQfuEQhZ0BxRSM5TyKolM\n",
      "https://api.spotify.com/v1/artists/7ctR7ruX0kn0gUrmbfTzL1\n"
     ]
    }
   ],
   "source": [
    "genres = []\n",
    "\n",
    "for id in df_artists[\"artist_id\"]:\n",
    "    artist_resp = sp.get_artist(id)\n",
    "    genres.append(artist_resp[\"genres\"])\n",
    "\n",
    "df_artists[\"artist_genres\"] = genres\n",
    "\n",
    "# Export dataframe as ZIP-CSV file\n",
    "compression_opts = dict(method='zip', archive_name='out_artists.csv')  \n",
    "df_artists.to_csv('./results/out_artists.zip', index=False, compression=compression_opts) "
   ]
  },
  {
   "source": [
    "---\n",
    "\n",
    "# 3.) Albums"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## a. Populate Artist's Albums\n",
    "\n",
    "List all albums of an artist via artist's Spotify ID"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "https://api.spotify.com/v1/artists/03uMw43UVu9MsQCcHVSGjX/albums\n",
      "https://api.spotify.com/v1/artists/3mmI5HKArDwgggj4j0aJyC/albums\n",
      "https://api.spotify.com/v1/artists/3ea4XDPCrAm68rpImApb94/albums\n",
      "https://api.spotify.com/v1/artists/1cIilB8ckONPBhSG6IvxSu/albums\n",
      "https://api.spotify.com/v1/artists/0SCFEgshN89tlgOPM7lbSB/albums\n",
      "https://api.spotify.com/v1/artists/6u79NimWxdl5RXgDrnGeqk/albums\n",
      "https://api.spotify.com/v1/artists/78TTCmh2koperK5NBn7DgR/albums\n",
      "https://api.spotify.com/v1/artists/13Vka7xGjRHhIOGzvomJZd/albums\n",
      "https://api.spotify.com/v1/artists/3IFgjVPT8yeB4UnJCWOpZA/albums\n",
      "https://api.spotify.com/v1/artists/7FvEqUihbJfx5vpfGd1OLz/albums\n",
      "https://api.spotify.com/v1/artists/4AScySQVdebovwUwTVWzhN/albums\n",
      "https://api.spotify.com/v1/artists/0kQfuEQhZ0BxRSM5TyKolM/albums\n",
      "https://api.spotify.com/v1/artists/7ctR7ruX0kn0gUrmbfTzL1/albums\n"
     ]
    }
   ],
   "source": [
    "row_albums = []\n",
    "\n",
    "for index, row_artist in df_artists.iterrows():\n",
    "    \n",
    "    albums = sp.get_artist_albums(row_artist['artist_id'])\n",
    "\n",
    "    # --- #HardCode \"20\" for max. number of rows returned by Spotify \n",
    "    if albums[\"total\"] > 20:\n",
    "        albums_cnt = 20\n",
    "    else:\n",
    "        albums_cnt = albums[\"total\"]\n",
    "    \n",
    "    for i in range(albums_cnt):\n",
    "        artist_id = row_artist['artist_id']\n",
    "        album_id = albums[\"items\"][i][\"id\"]\n",
    "        album_release_date = albums[\"items\"][i][\"release_date\"]\n",
    "        album_name = albums[\"items\"][i][\"name\"]\n",
    "        row_albums.append([artist_id, album_id, album_release_date, album_name])\n",
    "\n",
    "\n",
    "\n",
    "df_albums = pd.DataFrame(row_albums, columns=[\"artist_id\", \"album_id\", \"album_release_date\", \"album_name\"])\n",
    "df_albums.to_clipboard(sep = \",\", index=False)\n",
    "\n",
    "compression_opts = dict(method='zip', archive_name='out_albums.csv')  \n",
    "df_albums.to_csv('./results/out_albums.zip', index=False, compression=compression_opts)  "
   ]
  },
  {
   "source": [
    "---\n",
    "\n",
    "# 4.) Tracks"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## a. List Tracks per Album\n",
    "\n",
    "LIst all tracks of an album via album's Spotify ID"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "https://api.spotify.com/v1/albums/0toymsLJ0xNYQExQf1jKeN/tracks\n",
      "https://api.spotify.com/v1/albums/4r8HtFE8TGFtqEpMV7mU60/tracks\n",
      "https://api.spotify.com/v1/albums/3hslHc7Pmv3PyuUZVcMbZG/tracks\n",
      "https://api.spotify.com/v1/albums/1GJ3SzkwuktHSSSIb3zThC/tracks\n",
      "https://api.spotify.com/v1/albums/2GcpfpIBh1EbZYyvqYMeAI/tracks\n",
      "https://api.spotify.com/v1/albums/4ieLwljBoO1svXM5K6UtzA/tracks\n",
      "https://api.spotify.com/v1/albums/6k8uz0zLnKhSWA1jPbrKvv/tracks\n",
      "https://api.spotify.com/v1/albums/63OtMpfcpIe7FiXY2Cpb4v/tracks\n",
      "https://api.spotify.com/v1/albums/4cSGagidZg8OfE9TY8mnP9/tracks\n",
      "https://api.spotify.com/v1/albums/288HbeEv8cuamJikA3PPrN/tracks\n",
      "https://api.spotify.com/v1/albums/288MFsW7Tq858DT9VKt2tg/tracks\n",
      "https://api.spotify.com/v1/albums/7hIkxeYznFQftpneL5H9ZZ/tracks\n",
      "https://api.spotify.com/v1/albums/6fWpiDZCwdITgoJDx8aqXT/tracks\n",
      "https://api.spotify.com/v1/albums/2FhvMcP1mm2SSp3q5htGtp/tracks\n",
      "https://api.spotify.com/v1/albums/3XQhpRdAkLI9WbFfO8h6AU/tracks\n",
      "https://api.spotify.com/v1/albums/51WdYoFcDsqIA03c5TAPoW/tracks\n",
      "https://api.spotify.com/v1/albums/1ZIExdR8hJ4wyi782lnv18/tracks\n",
      "https://api.spotify.com/v1/albums/3i8sIf6iXA0cEcYHqTt9L3/tracks\n",
      "https://api.spotify.com/v1/albums/1u6joTV1ZssCmHfGaiCLAY/tracks\n",
      "https://api.spotify.com/v1/albums/6DwJzHX7dUSBTxw3wx6Fnr/tracks\n",
      "https://api.spotify.com/v1/albums/070RlcxMqrzDWzOt8LjlPw/tracks\n",
      "https://api.spotify.com/v1/albums/51DeIS0ySUJLKdlOCdqCsX/tracks\n",
      "https://api.spotify.com/v1/albums/7gr2YbcnJF1g6IorxlZBpG/tracks\n",
      "https://api.spotify.com/v1/albums/7LSaftXgHKgnpSDQCkJ7Pf/tracks\n",
      "https://api.spotify.com/v1/albums/3LLRzLefD2RqvEwk7v2LYT/tracks\n",
      "https://api.spotify.com/v1/albums/3pR9S8T5071mtFgfBongZV/tracks\n",
      "https://api.spotify.com/v1/albums/1PNHAqSSaOLpNKb6LhnPTz/tracks\n",
      "https://api.spotify.com/v1/albums/15Ye6UgJWDQxItZ1LQHrJh/tracks\n",
      "https://api.spotify.com/v1/albums/3g1LZV1met3VctPP1ggbuB/tracks\n",
      "https://api.spotify.com/v1/albums/6e4Ab5ioNiyrpR1n5WvMfe/tracks\n",
      "https://api.spotify.com/v1/albums/2RYcEGGlaqGreqPXrj55r3/tracks\n",
      "https://api.spotify.com/v1/albums/1ZeGHtbBKByCBFhVU2roD2/tracks\n",
      "https://api.spotify.com/v1/albums/1njYuoyxD0pnNS9wz5gZJ7/tracks\n",
      "https://api.spotify.com/v1/albums/0bb3BISI32HxCCyfrdA7EG/tracks\n",
      "https://api.spotify.com/v1/albums/3wN0rFZOjLI5YGW9wygDSt/tracks\n",
      "https://api.spotify.com/v1/albums/7xCiUrNWfSk2vuqpnS6Wdy/tracks\n",
      "https://api.spotify.com/v1/albums/1FsMuvJeD7dFyPXqd1IrR8/tracks\n",
      "https://api.spotify.com/v1/albums/5fdkYytUo46sYtNzttnP1Q/tracks\n",
      "https://api.spotify.com/v1/albums/5N0DfVR1uLTCYDWB9LGZ7L/tracks\n",
      "https://api.spotify.com/v1/albums/2e4G7pinqtudRX0Ofk4lwM/tracks\n",
      "https://api.spotify.com/v1/albums/3TfaqQmPgC1swNVWXr8lXB/tracks\n",
      "https://api.spotify.com/v1/albums/1xRMGHvRNXMZEOFxjPHI9c/tracks\n",
      "https://api.spotify.com/v1/albums/5B4cpHxKFHD7l4WbDVnJfG/tracks\n",
      "https://api.spotify.com/v1/albums/6mHO1jNDck1pdmhglUqK3J/tracks\n",
      "https://api.spotify.com/v1/albums/6gzbbwrz7Qym6ni3F7Prnv/tracks\n",
      "https://api.spotify.com/v1/albums/21IbdgCG9BIgBx2CDE0T11/tracks\n",
      "https://api.spotify.com/v1/albums/4TRkWA70SDJajI7Lb9ESIr/tracks\n",
      "https://api.spotify.com/v1/albums/62HzvWF4JNhNlRSGUP1Jrv/tracks\n",
      "https://api.spotify.com/v1/albums/2tA3cnyb1cixfcof1m3TeN/tracks\n",
      "https://api.spotify.com/v1/albums/4yNPua4Z7GwBHN8UDpglaF/tracks\n",
      "https://api.spotify.com/v1/albums/78MK5BlDmVHr2jXr6PDEuR/tracks\n",
      "https://api.spotify.com/v1/albums/0ICv0pzcuO9gr943CKjky5/tracks\n",
      "https://api.spotify.com/v1/albums/6A9gHWgB9CKqlPxdz0Y66u/tracks\n",
      "https://api.spotify.com/v1/albums/1G5X9nXn6yYp6iJjnrxnzJ/tracks\n",
      "https://api.spotify.com/v1/albums/5XJjD3eiYyMeZgkq1E2gcX/tracks\n",
      "https://api.spotify.com/v1/albums/4XoU0Tm1LPQ3kj40WSRcf6/tracks\n",
      "https://api.spotify.com/v1/albums/2rHuwSbPttjlfC1EOPPEE0/tracks\n",
      "https://api.spotify.com/v1/albums/4PYlbfTOhlG5wSpVYzCVTL/tracks\n",
      "https://api.spotify.com/v1/albums/0yMUpFxQEkMxrwxPQvMaeU/tracks\n",
      "https://api.spotify.com/v1/albums/1VRKs7ES3PTkUt3y6vAoiy/tracks\n",
      "https://api.spotify.com/v1/albums/7LJIBXuft6v3uVlUeT8fga/tracks\n",
      "https://api.spotify.com/v1/albums/2BRJKhub4ILkAauSbEkZwJ/tracks\n",
      "https://api.spotify.com/v1/albums/2QNQ70W1GQDok7KYjN6od1/tracks\n",
      "https://api.spotify.com/v1/albums/1lAqbKoYIf5YyLI0D2z0ZH/tracks\n",
      "https://api.spotify.com/v1/albums/0wfErFXKKtGKFWaSpG03az/tracks\n",
      "https://api.spotify.com/v1/albums/5WV3j5PoBLPfVu1RTIrFpX/tracks\n",
      "https://api.spotify.com/v1/albums/6r7chVRg3oKzEVjA0H5iSL/tracks\n",
      "https://api.spotify.com/v1/albums/0KNhjTstJ7nXJO3vTIxWgO/tracks\n",
      "https://api.spotify.com/v1/albums/3U8fcQP1pBGdTn8HlNXooi/tracks\n",
      "https://api.spotify.com/v1/albums/7rket5eUIzvg3NER0w1SU2/tracks\n",
      "https://api.spotify.com/v1/albums/7phnlhQWzdK7fpI2LmQorP/tracks\n",
      "https://api.spotify.com/v1/albums/08Aa9oWimqfo7ad2BX1Zm6/tracks\n",
      "https://api.spotify.com/v1/albums/5Fn8XI5NgLh2N5pR58wfMM/tracks\n",
      "https://api.spotify.com/v1/albums/1jv2ysCpalooSXOTyctlCf/tracks\n",
      "https://api.spotify.com/v1/albums/0U6sf2wQRkO8G3kOD3MBFu/tracks\n",
      "https://api.spotify.com/v1/albums/7GVIGrNzsQSpDzhW2JcB6N/tracks\n",
      "https://api.spotify.com/v1/albums/5YPFb4bdA1OtLxkrCXmRJq/tracks\n",
      "https://api.spotify.com/v1/albums/6lPoyRkujQpPkiy3c86eIE/tracks\n",
      "https://api.spotify.com/v1/albums/3vSDNB8IY2v2SAbj8lkQUY/tracks\n",
      "https://api.spotify.com/v1/albums/7kbbtljOWuM4xhQCPAMxNU/tracks\n",
      "https://api.spotify.com/v1/albums/4L8O0MLMnp8ipTQAxrMGwZ/tracks\n",
      "https://api.spotify.com/v1/albums/4ZFkZVBcnpevIXByJZ8Dq7/tracks\n",
      "https://api.spotify.com/v1/albums/563rcNkfbCq0ZAeoJRBWF2/tracks\n",
      "https://api.spotify.com/v1/albums/46MtxGmpslJUT3t3qmM30N/tracks\n",
      "https://api.spotify.com/v1/albums/7f42MWnnzaJ0x3oentXDrx/tracks\n",
      "https://api.spotify.com/v1/albums/2w1aUC9UmHwvgpez0UC2jq/tracks\n",
      "https://api.spotify.com/v1/albums/60oNTYye8PIG8WtVznEeIa/tracks\n",
      "https://api.spotify.com/v1/albums/0y9S20P4dC8RfVcUtxDW5c/tracks\n",
      "https://api.spotify.com/v1/albums/1Z6vonQ1pf9U2IUGjd4Kvi/tracks\n",
      "https://api.spotify.com/v1/albums/5ob5ZW1O7jdNyoiiNuOs1R/tracks\n",
      "https://api.spotify.com/v1/albums/7ykQSmyBLQSsfQlRgY1dI7/tracks\n",
      "https://api.spotify.com/v1/albums/5vrbcnXTiRb9xoO61FYHp6/tracks\n",
      "https://api.spotify.com/v1/albums/5q2YGmTg7WuubhnrmF6FWz/tracks\n",
      "https://api.spotify.com/v1/albums/7C9c7ZvLWRx946AvDKmpZG/tracks\n",
      "https://api.spotify.com/v1/albums/6atccnocs176HZ45UUssZD/tracks\n",
      "https://api.spotify.com/v1/albums/2ODGLDHuJuzSksth6roeWI/tracks\n",
      "https://api.spotify.com/v1/albums/3v4GJ3wO6EPYGNOTVcO43L/tracks\n",
      "https://api.spotify.com/v1/albums/1uRVlctiN7QZdd3LMckm4q/tracks\n",
      "https://api.spotify.com/v1/albums/3bZQh8nPjo1Fk5UpKHFkTE/tracks\n",
      "https://api.spotify.com/v1/albums/40fCvTddKZD0iAzX3TH6Tz/tracks\n",
      "https://api.spotify.com/v1/albums/2sZHSKUeUYpbYtjjOPPhSF/tracks\n",
      "https://api.spotify.com/v1/albums/3IdppQlDRdSDbmMOg5IgkO/tracks\n",
      "https://api.spotify.com/v1/albums/1PpSHEuFNZ9Kn6XmPQkxSQ/tracks\n",
      "https://api.spotify.com/v1/albums/6NHQH7NQ0fCavOH5C1bOnJ/tracks\n",
      "https://api.spotify.com/v1/albums/01Hq72wSvemk4SsuEWvZNQ/tracks\n",
      "https://api.spotify.com/v1/albums/0uv6lmYRfbuTSbbm3CafS4/tracks\n",
      "https://api.spotify.com/v1/albums/2flnsPa25StKHMDtrFCs8q/tracks\n",
      "https://api.spotify.com/v1/albums/5J3bMPWbldLAQhD6IZZmKU/tracks\n",
      "https://api.spotify.com/v1/albums/73n7ZDHjAK7flDQuoLqr5C/tracks\n",
      "https://api.spotify.com/v1/albums/7fQ5b1oaxg85eLVmC6Ujgg/tracks\n",
      "https://api.spotify.com/v1/albums/5cV7gOLf2w8YiePjtmtzwP/tracks\n",
      "https://api.spotify.com/v1/albums/2FvtHuRI6bnXMKQsnwhH3v/tracks\n",
      "https://api.spotify.com/v1/albums/0p0hxVqZm7LGwysvxNjz5K/tracks\n",
      "https://api.spotify.com/v1/albums/7z9p6jlSry8SDS2LndsXQb/tracks\n",
      "https://api.spotify.com/v1/albums/4VsyosAkqUBp6DdYPD98Ub/tracks\n",
      "https://api.spotify.com/v1/albums/08FT3rtOAaYIijuSUnMVrX/tracks\n",
      "https://api.spotify.com/v1/albums/1eedF2qaDm5dZfJaRB3D29/tracks\n",
      "https://api.spotify.com/v1/albums/3lLpRCb5Tnl8eO4uOyqfPr/tracks\n",
      "https://api.spotify.com/v1/albums/1s6kqclbVWT20toCE3fGAm/tracks\n",
      "https://api.spotify.com/v1/albums/6l4CdcTOCBo8t5avLneUph/tracks\n",
      "https://api.spotify.com/v1/albums/6gXUBFgbYrQjJHfrZaYF8z/tracks\n",
      "https://api.spotify.com/v1/albums/2IHkKiib30oJJNdk7kTJQm/tracks\n",
      "https://api.spotify.com/v1/albums/45sS3k4Z4k54HHTvpCJ2c4/tracks\n",
      "https://api.spotify.com/v1/albums/1iiCxh25lUcGzY7ed0bNpg/tracks\n",
      "https://api.spotify.com/v1/albums/4BQNP4oTpQv5b6LLe6cRjQ/tracks\n",
      "https://api.spotify.com/v1/albums/1pT0i5maf1yNOLrDhfUfR9/tracks\n",
      "https://api.spotify.com/v1/albums/0Wva4nlihSHCsRRAwumhHb/tracks\n",
      "https://api.spotify.com/v1/albums/2XwRgCDg7KxwtmPu7EBujL/tracks\n",
      "https://api.spotify.com/v1/albums/647hVoRT9zzXTFvNwRoAGh/tracks\n",
      "https://api.spotify.com/v1/albums/73xNoLJXdBg0N4PhhXA8wR/tracks\n",
      "https://api.spotify.com/v1/albums/4vLDSPN692DFxWybeyjbUa/tracks\n",
      "https://api.spotify.com/v1/albums/5J0gFsJB6rARRYRIELuVBi/tracks\n",
      "https://api.spotify.com/v1/albums/5IhoXM2vit0N8h7tJs9AIQ/tracks\n",
      "https://api.spotify.com/v1/albums/7r3bIWd6s1UvzT6e4UbqW5/tracks\n",
      "https://api.spotify.com/v1/albums/42EHCeuqeShvx8FOSyuzge/tracks\n",
      "https://api.spotify.com/v1/albums/1HVomqY2E4JFpJZKIYBvhF/tracks\n",
      "https://api.spotify.com/v1/albums/4YQCACW6UFsOpovH8BZEj6/tracks\n",
      "https://api.spotify.com/v1/albums/5PcQhQs0uQ7rWN5C1SD2dw/tracks\n",
      "https://api.spotify.com/v1/albums/7HO65KoSmjopmBdqvAtWFk/tracks\n",
      "https://api.spotify.com/v1/albums/3qbfY3KuGaswZDOAcDq1OF/tracks\n",
      "https://api.spotify.com/v1/albums/4elD1eGJZnZ0fVpUh6dX8P/tracks\n",
      "https://api.spotify.com/v1/albums/4A4tHDjf79N2Hbs5z26qdA/tracks\n",
      "https://api.spotify.com/v1/albums/1Rc4nae7LR97ULS1KczBhU/tracks\n",
      "https://api.spotify.com/v1/albums/0rhlv3DB9dhYezF0yHIMMj/tracks\n",
      "https://api.spotify.com/v1/albums/49ERmjcEpmsuzVtx7lJB7b/tracks\n",
      "https://api.spotify.com/v1/albums/5heCuElXYttXmNTFZYHfXD/tracks\n",
      "https://api.spotify.com/v1/albums/1VoxUvj45xC3mlVYljTESQ/tracks\n",
      "https://api.spotify.com/v1/albums/48dQ1dGmyh7JYYjooDTV58/tracks\n",
      "https://api.spotify.com/v1/albums/4J8rXLjCZOstDZ1plm995U/tracks\n",
      "https://api.spotify.com/v1/albums/6u2O6DmFMTrq7FQ8R8l62q/tracks\n",
      "https://api.spotify.com/v1/albums/2TWY1g7jJpZzfhhEcW9z5L/tracks\n",
      "https://api.spotify.com/v1/albums/4D8rHGyAQSzjOHGiqMuWle/tracks\n",
      "https://api.spotify.com/v1/albums/6jfO1q5XzEdMfyDqSyh1ov/tracks\n",
      "https://api.spotify.com/v1/albums/5cV7gOLf2w8YiePjtmtzwP/tracks\n",
      "https://api.spotify.com/v1/albums/1SozCRpcIdLLX80fjlsSGT/tracks\n",
      "https://api.spotify.com/v1/albums/18Qmlqo7RuMN3KJmvxEawb/tracks\n",
      "https://api.spotify.com/v1/albums/1m1B9Cdx0GaJxdKZRUUr0c/tracks\n",
      "https://api.spotify.com/v1/albums/2FXLILjJjPKKzUrO5I21s6/tracks\n",
      "https://api.spotify.com/v1/albums/2ZT6dFqylN2yJbpA08WjXp/tracks\n",
      "https://api.spotify.com/v1/albums/4LivETR21Bmq2w4maVdtV9/tracks\n",
      "https://api.spotify.com/v1/albums/53ULXGBG34wy7FnGQ14lqY/tracks\n",
      "https://api.spotify.com/v1/albums/2RXRxVjUJunokLl4hx8In6/tracks\n",
      "https://api.spotify.com/v1/albums/314NByD5bjQBUDpeUYaBo2/tracks\n",
      "https://api.spotify.com/v1/albums/3VHvLrlsfgDUSrg89rF1yn/tracks\n",
      "https://api.spotify.com/v1/albums/4rCC6Z3WtcWiu4qllaFYuQ/tracks\n",
      "https://api.spotify.com/v1/albums/77PzY5Rte8FeWIUAl1Zhi1/tracks\n",
      "https://api.spotify.com/v1/albums/0zAvZPqUVadNEtebPD3Jrq/tracks\n",
      "https://api.spotify.com/v1/albums/5mp26INPj6uSRxd3u7ZpQ0/tracks\n",
      "https://api.spotify.com/v1/albums/1dSqSHeaDTIQnKw7EKebA9/tracks\n",
      "https://api.spotify.com/v1/albums/5RKkTqwyEL7u7nvBjsCNTZ/tracks\n",
      "https://api.spotify.com/v1/albums/5yfuKRQindEM1Hn1BANEFl/tracks\n",
      "https://api.spotify.com/v1/albums/2o8qmIf2zZMj9nIqQSZ2Ay/tracks\n",
      "https://api.spotify.com/v1/albums/0XZlIZVdUH2MTVnsh1vrQS/tracks\n",
      "https://api.spotify.com/v1/albums/3LmQY2RYIaM7a5BjzORugi/tracks\n",
      "https://api.spotify.com/v1/albums/008XpNd6EClYQZIvBJeKHX/tracks\n",
      "https://api.spotify.com/v1/albums/6ecLmeW1SRT9ghIas6NgHZ/tracks\n",
      "https://api.spotify.com/v1/albums/5PKDyiXXniZWIM5ATTsDVB/tracks\n",
      "https://api.spotify.com/v1/albums/1pJEXk1qAZsyEsT3EFQziL/tracks\n",
      "https://api.spotify.com/v1/albums/0ywkGOvZDZ2zxgYvXNBgTg/tracks\n",
      "https://api.spotify.com/v1/albums/4TkrSlB7nA2hQmo7ssbHeY/tracks\n",
      "https://api.spotify.com/v1/albums/1FPEHmCHje6FY1uo4rODlL/tracks\n",
      "https://api.spotify.com/v1/albums/2CWpSFj1aVgmDauGP7SGSy/tracks\n",
      "https://api.spotify.com/v1/albums/5SHdxwvOWKDMAAyBZYudeG/tracks\n",
      "https://api.spotify.com/v1/albums/4ns2cVhBIxZ4FP23CIHMIi/tracks\n",
      "https://api.spotify.com/v1/albums/0gl8QnEuq22N8ifEyGjDXi/tracks\n",
      "https://api.spotify.com/v1/albums/3I0cpYYDICQOjRI6oipMge/tracks\n",
      "https://api.spotify.com/v1/albums/6fGHWnU9t15m3yuQJeFKVj/tracks\n",
      "https://api.spotify.com/v1/albums/0zfOQEvKTztqXWtUzuetFj/tracks\n",
      "https://api.spotify.com/v1/albums/7aGjMcnhqz7aQ0FQRlhHtf/tracks\n",
      "https://api.spotify.com/v1/albums/0xTp3cCKzR8VCgQMbTS7gV/tracks\n"
     ]
    }
   ],
   "source": [
    "row_tracks = []\n",
    "\n",
    "for index, row_album in df_albums.iterrows():\n",
    "\n",
    "    tracks = sp.get_album_tracks(row_album['album_id'])\n",
    "\n",
    "    # --- #HardCode \"20\" for max. number of rows returned by Spotify \n",
    "    if tracks[\"total\"] > 20:\n",
    "        track_cnt = 20\n",
    "    else:\n",
    "        track_cnt = tracks[\"total\"]\n",
    "\n",
    "    for i in range(track_cnt):\n",
    "        album_id = row_album['album_id']\n",
    "        track_id = tracks[\"items\"][i][\"id\"]\n",
    "        track_num = tracks[\"items\"][i][\"track_number\"]\n",
    "        track_name = tracks[\"items\"][i][\"name\"]\n",
    "        # track_duration = tracks[\"items\"][i][\"duration_ms\"]\n",
    "        track_duration = datetime.timedelta(milliseconds = tracks[\"items\"][i][\"duration_ms\"])\n",
    "        row_tracks.append([album_id, track_id, track_num, track_name, track_duration])\n",
    "\n",
    "\n",
    "df_tracks = pd.DataFrame(row_tracks, columns=[\"album_id\", \"track_id\", \"track_num\", \"track_name\", \"track_duration\"])\n",
    "df_tracks.to_clipboard(sep = \",\", index=False)\n",
    "\n",
    "# compression_opts = dict(method='zip', archive_name='out_tracks.csv')  \n",
    "# df_tracks.to_csv('./results/out_tracks.zip', index=False, compression=compression_opts)  "
   ]
  },
  {
   "source": [
    "## b. Query track's Audio Features"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "tags": [
     "outputPrepend"
    ]
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "com/v1/audio-features/2fNSDlX6Fa8adWskDUfKae\n",
      "https://api.spotify.com/v1/audio-features/469TsPGP0T3DGokNo6Vdgq\n",
      "https://api.spotify.com/v1/audio-features/235Hq2mOb7ezbjqTlmNRKY\n",
      "https://api.spotify.com/v1/audio-features/2pfMSI2iQddJeePcui2drG\n",
      "https://api.spotify.com/v1/audio-features/36r73EpuviBetBuQeF5kvk\n",
      "https://api.spotify.com/v1/audio-features/3Dg5wHk8yf0XvG1ROugtUK\n",
      "https://api.spotify.com/v1/audio-features/4CCyxM5XX8fFbhH7Jp9S7w\n",
      "https://api.spotify.com/v1/audio-features/2Ee5Trz9wwLffTwRn8jWqJ\n",
      "https://api.spotify.com/v1/audio-features/1so0272NRu2ZYUTb3fjZC6\n",
      "https://api.spotify.com/v1/audio-features/3PW5xknWSgWVMAKIH7fcwC\n",
      "https://api.spotify.com/v1/audio-features/22YxC3ytBdBfQ7to3ABvFr\n",
      "https://api.spotify.com/v1/audio-features/53vcRE2LvvyiYTVI94APFZ\n",
      "https://api.spotify.com/v1/audio-features/3IzygbKjMcooi8tz7lTLKa\n",
      "https://api.spotify.com/v1/audio-features/2zo2pEbYQLJOwWUbBUM6LP\n",
      "https://api.spotify.com/v1/audio-features/3YsuqzCeNs1xK2xO59XGaN\n",
      "https://api.spotify.com/v1/audio-features/0iyWAb9IVdB7MxmNLMmHhy\n",
      "https://api.spotify.com/v1/audio-features/43oLFRWZf9bszW0REUQGmt\n",
      "https://api.spotify.com/v1/audio-features/2SSYP3kgfd3WQU2F5CuF3G\n",
      "https://api.spotify.com/v1/audio-features/48MWjOcvNmYcHJeKtVwAFM\n",
      "https://api.spotify.com/v1/audio-features/3kdbasmf45Gz9aowT9N0JE\n",
      "https://api.spotify.com/v1/audio-features/3hJ6VTXIND92wpon4TKjy1\n",
      "https://api.spotify.com/v1/audio-features/6hg11XB9rUTSM92Sx2WDhJ\n",
      "https://api.spotify.com/v1/audio-features/5EvfdR8QCKNNLws55z5qSx\n",
      "https://api.spotify.com/v1/audio-features/7EQRodrf8WpP3CtFpNcq4A\n",
      "https://api.spotify.com/v1/audio-features/705lwz3v9ghk7N9GfOzUbR\n",
      "https://api.spotify.com/v1/audio-features/5kYOza7jdwwLmjgNeviQgK\n",
      "https://api.spotify.com/v1/audio-features/6DFDmJJojEXEZAx8kZeEek\n",
      "https://api.spotify.com/v1/audio-features/74LpMlzlxhRNo2Gi8awj83\n",
      "https://api.spotify.com/v1/audio-features/1OsNEXbTdP94uYTVrgqSe4\n",
      "https://api.spotify.com/v1/audio-features/1ezWw5TYIYczYaMiA1FyRN\n",
      "https://api.spotify.com/v1/audio-features/3oagf3lrr3iBFemwHyHQV6\n",
      "https://api.spotify.com/v1/audio-features/5JI7sTCjPwFp6JzTQFO8Q9\n",
      "https://api.spotify.com/v1/audio-features/73cRpqYNVlsOHB5QtKI1iG\n",
      "https://api.spotify.com/v1/audio-features/2qQusCcWR2A9Q6lK5Uz6bw\n",
      "https://api.spotify.com/v1/audio-features/25xSQHXSVmGzBnLnAMNHuv\n",
      "https://api.spotify.com/v1/audio-features/7ym6tzOOEOSEn73ewdUYpb\n",
      "https://api.spotify.com/v1/audio-features/1gDzETSJ1IYKa2PeB9SFEk\n",
      "https://api.spotify.com/v1/audio-features/6bPDXBWTc6OFVT3mG6DQMN\n",
      "https://api.spotify.com/v1/audio-features/1r56FCFfeJM2EHnbbRn2CY\n",
      "https://api.spotify.com/v1/audio-features/40M4kZhMVHhDSzlC4Ov5vd\n",
      "https://api.spotify.com/v1/audio-features/7dYxxaPbLZ2FzmIvQwnfAg\n",
      "https://api.spotify.com/v1/audio-features/2kdVVsyRJpzxXg5epvRhol\n",
      "https://api.spotify.com/v1/audio-features/3QiqTaDFEaN1TvIRRpI1g0\n",
      "https://api.spotify.com/v1/audio-features/20hb3sCcWTsVg1yA9G3Uan\n",
      "https://api.spotify.com/v1/audio-features/2h511scwb1NJGrCeK6bfgx\n",
      "https://api.spotify.com/v1/audio-features/20V1M5ogpu42KNYYlWyyle\n",
      "https://api.spotify.com/v1/audio-features/1SXZbC5vhJLwltu3xUDbPz\n",
      "https://api.spotify.com/v1/audio-features/5g5ufkwMMJxt3pGlPaVEDh\n",
      "https://api.spotify.com/v1/audio-features/2oLMYh6jriuWBZOrcBZJje\n",
      "https://api.spotify.com/v1/audio-features/0xMMzW4VNp7tK41voCOADP\n",
      "https://api.spotify.com/v1/audio-features/6QGYVrFICLbBvlZQaa8H6y\n",
      "https://api.spotify.com/v1/audio-features/2opCjPqzKam0Lcqnk3wNbI\n",
      "https://api.spotify.com/v1/audio-features/7u5oqyy0m3LWE0dMXNa2Qe\n",
      "https://api.spotify.com/v1/audio-features/1uMSYgI5aGn6XInwc5XcXy\n",
      "https://api.spotify.com/v1/audio-features/7L5XlP3AleCrAizTNy9mc7\n",
      "https://api.spotify.com/v1/audio-features/278bKEd7Fus9UYUReNULqb\n",
      "https://api.spotify.com/v1/audio-features/6xnN2JrZQ9Jo3JhvbPTVpU\n",
      "https://api.spotify.com/v1/audio-features/49jkg9JGY8y1XRajzvJnb4\n",
      "https://api.spotify.com/v1/audio-features/6FxftXefvr3CgOvR8EeIuL\n",
      "https://api.spotify.com/v1/audio-features/7fEcqeyZshj1UMxQVDYuaE\n",
      "https://api.spotify.com/v1/audio-features/3nbeOTDy4mNtNRRA22PkJK\n",
      "https://api.spotify.com/v1/audio-features/4K4JX4ViW5UuOVTVEO49nY\n",
      "https://api.spotify.com/v1/audio-features/4fcCvh4KdCytw924kW773X\n",
      "https://api.spotify.com/v1/audio-features/56WRIxY0Wh3Jw5TYDUxhbj\n",
      "https://api.spotify.com/v1/audio-features/7DPZgrjAeDLr4ROa4XPjyf\n",
      "https://api.spotify.com/v1/audio-features/0IyqBSDUesJgRdnLDPS6TX\n",
      "https://api.spotify.com/v1/audio-features/06IwxLzapWyWDKGwr0NBLb\n",
      "https://api.spotify.com/v1/audio-features/56JycIKw2ADWexv2NftaGL\n",
      "https://api.spotify.com/v1/audio-features/7oNaxasI86s97zHKDxq9Ku\n",
      "https://api.spotify.com/v1/audio-features/0zK4cjHxWYGISIA1FDqEF7\n",
      "https://api.spotify.com/v1/audio-features/1pbUAUXu9r59VibUZ8vlCg\n",
      "https://api.spotify.com/v1/audio-features/7hyqXTRnyxde8VaAnIymCf\n",
      "https://api.spotify.com/v1/audio-features/5QXuYFiASY3JKoZ34FFog7\n",
      "https://api.spotify.com/v1/audio-features/2EO7qJIDCj3h1eAaPWuQoy\n",
      "https://api.spotify.com/v1/audio-features/1v51Ly4ODUWLPm0ZSApy2P\n",
      "https://api.spotify.com/v1/audio-features/3NEMOevTaiMYE84qMaZipX\n",
      "https://api.spotify.com/v1/audio-features/7yV25tzz6Mptukg1yJXPjV\n",
      "https://api.spotify.com/v1/audio-features/6oPdKRcDN35LCZa1OxuhaQ\n",
      "https://api.spotify.com/v1/audio-features/5V4D8clUZSawn8v7YFcLsw\n",
      "https://api.spotify.com/v1/audio-features/58qLrqTojWTnSy6YT00Ril\n",
      "https://api.spotify.com/v1/audio-features/1FsRok20QxYT631LCJNdOU\n",
      "https://api.spotify.com/v1/audio-features/1JWZPKWCMGjikmTgL71drd\n",
      "https://api.spotify.com/v1/audio-features/6kCqRzctzlZUYuMqqrapEx\n",
      "https://api.spotify.com/v1/audio-features/3UgKuH1nJpNki8CetFM6lA\n",
      "https://api.spotify.com/v1/audio-features/4ifzOC2JzBZcwuKLKJAmeH\n",
      "https://api.spotify.com/v1/audio-features/4NhJDrY2o0lMR32GQ02i3C\n",
      "https://api.spotify.com/v1/audio-features/1YL22H1qLKYR77oZoCSJHB\n",
      "https://api.spotify.com/v1/audio-features/4gbTyIyHyGpADgnP40RZRY\n",
      "https://api.spotify.com/v1/audio-features/0Fz8foQq6bW0Goi7vro49T\n",
      "https://api.spotify.com/v1/audio-features/54axCO0FMpyfLL7IKLIMgn\n",
      "https://api.spotify.com/v1/audio-features/4VXbmTFLJOZ3mUNzRxfv11\n",
      "https://api.spotify.com/v1/audio-features/5I9bzVtmzlKSFoVz2Iu3GJ\n",
      "https://api.spotify.com/v1/audio-features/6sv9VeIFpiRF3R8zpQp6oH\n",
      "https://api.spotify.com/v1/audio-features/5j92MTLsnlDw1f2UUGEght\n",
      "https://api.spotify.com/v1/audio-features/3DHj2dQdQZZPpWL7gh8lK3\n",
      "https://api.spotify.com/v1/audio-features/2yDjXN1vDP0TIc4pJg2lcl\n",
      "https://api.spotify.com/v1/audio-features/7E89JvczmcJHGiG7r6yMhz\n",
      "https://api.spotify.com/v1/audio-features/11HTyxAon5toXG0hnzQycj\n",
      "https://api.spotify.com/v1/audio-features/7K6xXajAfgynlzDGkkmV2Y\n",
      "https://api.spotify.com/v1/audio-features/6scTzdtFo9uafQWpzhLTgN\n",
      "https://api.spotify.com/v1/audio-features/5aWh20vwERQvdz3sSKdC08\n",
      "https://api.spotify.com/v1/audio-features/0d8T6EbxWtEFR89Z8pILy6\n",
      "https://api.spotify.com/v1/audio-features/1BOh2HABUfjjVi91xYeYBb\n",
      "https://api.spotify.com/v1/audio-features/7G7krPqrnRuhkqkbeSIpcf\n",
      "https://api.spotify.com/v1/audio-features/4UgxgUF8Fueuqvzw9ujf7D\n",
      "https://api.spotify.com/v1/audio-features/2moVWdrQaJI4jIpq8Wm1R8\n",
      "https://api.spotify.com/v1/audio-features/0sJLR7WqklxYXmrT0g6WxV\n",
      "https://api.spotify.com/v1/audio-features/7zoNIFGEFKyv35YZjVReCH\n",
      "https://api.spotify.com/v1/audio-features/3msQ8ELdhC7mWzIJjb6VxS\n",
      "https://api.spotify.com/v1/audio-features/6yBOGBRwhlqS2purdBPvFK\n",
      "https://api.spotify.com/v1/audio-features/7iH1t97ExMZCa64e9MawbV\n",
      "https://api.spotify.com/v1/audio-features/6RqVEUHeY21f7slUzBHHGP\n",
      "https://api.spotify.com/v1/audio-features/1ZLP8l5QFZXEZwKMfm4fJm\n",
      "https://api.spotify.com/v1/audio-features/0TNmyGNIMtzzdazxRNPFeR\n",
      "https://api.spotify.com/v1/audio-features/5Eb5T5UA2oeBWyAzitAx3s\n",
      "https://api.spotify.com/v1/audio-features/5YEoPeBTPZxfeS1TOZyfb9\n",
      "https://api.spotify.com/v1/audio-features/3PKNmnIWEk6uKomIpvFbhA\n",
      "https://api.spotify.com/v1/audio-features/3eX180174qAiYiGRdMh1Cq\n",
      "https://api.spotify.com/v1/audio-features/4pgoa5ZRSGSMvRC1H4OSIX\n",
      "https://api.spotify.com/v1/audio-features/3YPnuy2VMeZJIlbvKt8yDJ\n",
      "https://api.spotify.com/v1/audio-features/25bmYn2g3NRlMjM8knztXh\n",
      "https://api.spotify.com/v1/audio-features/1KzrtvrWt8kGA0R5v2H3Gu\n",
      "https://api.spotify.com/v1/audio-features/7vNYUZWEoSUX2wGkE2M4TO\n",
      "https://api.spotify.com/v1/audio-features/5AtPSuOvPW8nqQovvkKSSG\n",
      "https://api.spotify.com/v1/audio-features/5qJfzHpDnEk3Ayts2UYhN3\n",
      "https://api.spotify.com/v1/audio-features/6q7mksCG72DPPUgHWo9HsE\n",
      "https://api.spotify.com/v1/audio-features/7iVfZ6kcJxeGa3aVaZHzAc\n",
      "https://api.spotify.com/v1/audio-features/5z7GI8wrnNa4fl2D41ul6J\n",
      "https://api.spotify.com/v1/audio-features/428HTqAq6rqcdEbjix9Emd\n",
      "https://api.spotify.com/v1/audio-features/3fkhdlwz4TH6Lp3BjyeI3D\n",
      "https://api.spotify.com/v1/audio-features/31uGw0kpuRc9zMRl6hi6zW\n",
      "https://api.spotify.com/v1/audio-features/0VTTV4AdtlULtcBvgtORjZ\n",
      "https://api.spotify.com/v1/audio-features/0x3MGCy7WTMMTbjvbSJB9z\n",
      "https://api.spotify.com/v1/audio-features/2qVe0s2hNkveHNOx8uO7Ap\n",
      "https://api.spotify.com/v1/audio-features/3Mi7AmMWvTGFKrMTEHxZQm\n",
      "https://api.spotify.com/v1/audio-features/2NrBEiXSjAmUhOeHyCBbKN\n",
      "https://api.spotify.com/v1/audio-features/1KCJbkrJfcqcMrzQA7Sdnb\n",
      "https://api.spotify.com/v1/audio-features/5pEO1icAE6ixpdUPgtREhb\n",
      "https://api.spotify.com/v1/audio-features/3FHpoZtNUdB2dy9fqcyDUN\n",
      "https://api.spotify.com/v1/audio-features/2Ocks3bZJkuj6HBNl2iuKk\n",
      "https://api.spotify.com/v1/audio-features/6Jm4ds4KUa7IMfMod5QJtl\n",
      "https://api.spotify.com/v1/audio-features/5GPmUo15y2irYRPK67g3fc\n",
      "https://api.spotify.com/v1/audio-features/3PZ5Id5y3H3Tzbnbs56vFt\n",
      "https://api.spotify.com/v1/audio-features/4Fdi3APBU1LG113MyvIum1\n",
      "https://api.spotify.com/v1/audio-features/55oN88lEZjMEDPTMd1fPHM\n",
      "https://api.spotify.com/v1/audio-features/24pxrpzkl7XpfcIjF0JN80\n",
      "https://api.spotify.com/v1/audio-features/6gVdNBrJkljAls2XKif968\n",
      "https://api.spotify.com/v1/audio-features/6vUqxPIDhYUUv3pOsMG82b\n",
      "https://api.spotify.com/v1/audio-features/5Q9DgVfMvHDh0WH2KEuSKr\n",
      "https://api.spotify.com/v1/audio-features/6iMj0RtLLH56B7URmHYIzR\n",
      "https://api.spotify.com/v1/audio-features/799BKIbSpIC7xuimdHk0Uq\n",
      "https://api.spotify.com/v1/audio-features/6pCjv9c4MmL6bWmoNj3vzd\n",
      "https://api.spotify.com/v1/audio-features/2bXWsZ5oziNnfnGOBKjkgE\n",
      "https://api.spotify.com/v1/audio-features/4PDdHctpWJdeQPiNp4nRWy\n",
      "https://api.spotify.com/v1/audio-features/5fSWWkX9zDuk9Er0kKqzjf\n",
      "https://api.spotify.com/v1/audio-features/29iTZV6rkNcCX8KiQEGGsB\n",
      "https://api.spotify.com/v1/audio-features/0i4ElOLY3sHwx6GWMqGdVm\n",
      "https://api.spotify.com/v1/audio-features/4J5fU6XcELhDMeE0HEeh0U\n",
      "https://api.spotify.com/v1/audio-features/2Yjqhe5zCUBzObC7SA42cl\n",
      "https://api.spotify.com/v1/audio-features/4i8vEennfrX4uv2psSoX2w\n",
      "https://api.spotify.com/v1/audio-features/0ud3p3rDjhWowKK1nBtwuw\n",
      "https://api.spotify.com/v1/audio-features/68TeCKyPWNLOQRKDLfTlMy\n",
      "https://api.spotify.com/v1/audio-features/66N6gvZSZmBy1yqCEELXSk\n",
      "https://api.spotify.com/v1/audio-features/0vrVcBUuowLnc1bf89hcil\n",
      "https://api.spotify.com/v1/audio-features/5WsHplGS8kmz6trFicFOls\n",
      "https://api.spotify.com/v1/audio-features/0ukj1LjBwkINbzSl0C1OYH\n",
      "https://api.spotify.com/v1/audio-features/154qdwBm98nk6rrtGKBSkN\n",
      "https://api.spotify.com/v1/audio-features/7L1LwPEWudCeuDDgGCoPub\n",
      "https://api.spotify.com/v1/audio-features/21sGGsxqriMlGymOII2sZL\n",
      "https://api.spotify.com/v1/audio-features/6W4jW1DnsrvWm4XSelNN7R\n",
      "https://api.spotify.com/v1/audio-features/1CCqm5vgsa8psqIEUVM6uX\n",
      "https://api.spotify.com/v1/audio-features/0gaOYdcqRl88fxFpfcTm97\n",
      "https://api.spotify.com/v1/audio-features/5WHQBG3RmwiMNRdjBF1XGW\n",
      "https://api.spotify.com/v1/audio-features/7mOEBkx7heXbtsTJ4WP4JF\n",
      "https://api.spotify.com/v1/audio-features/3bQfHjzGMlUCFqrFLkqopJ\n",
      "https://api.spotify.com/v1/audio-features/4AGJG70lJHQzFM6gPLy9Np\n",
      "https://api.spotify.com/v1/audio-features/2ZLvYFnHxpXmY1tjXHdZ7j\n",
      "https://api.spotify.com/v1/audio-features/27lsKT7aicPSe25W8dJDkz\n",
      "https://api.spotify.com/v1/audio-features/2RG3JR5zBUyNFqn2YUmzAe\n",
      "https://api.spotify.com/v1/audio-features/55H9zVgZ9jqZRXx4SAfo7k\n",
      "https://api.spotify.com/v1/audio-features/5xRsLH4kYBlUDzLFcwfG87\n",
      "https://api.spotify.com/v1/audio-features/3LMWDXlQf2arrrdSARiTu8\n",
      "https://api.spotify.com/v1/audio-features/2Noxg8LFsBH5u4FifycHhd\n",
      "https://api.spotify.com/v1/audio-features/2kKdmB6IFRdrOVtbs9izGB\n",
      "https://api.spotify.com/v1/audio-features/2Ku2kNyxLWfvvxEb40xGWT\n",
      "https://api.spotify.com/v1/audio-features/61S3Mb1lITDa2pLkcGRpe4\n",
      "https://api.spotify.com/v1/audio-features/6qgZYBYOW7zE7IN4n0m5JJ\n",
      "https://api.spotify.com/v1/audio-features/6wiDlILo9i7wON7oDhKV5k\n",
      "https://api.spotify.com/v1/audio-features/624XqDtK2oHMC81DqrvQrq\n",
      "https://api.spotify.com/v1/audio-features/4hbdB8gjSH0gFrvK7MTaTz\n",
      "https://api.spotify.com/v1/audio-features/6Ld0P3pME8kLp3xFzDP2c5\n",
      "https://api.spotify.com/v1/audio-features/01uiPxpeJhbWPWlXevK5Jq\n",
      "https://api.spotify.com/v1/audio-features/0eZPgoBAHvU6TH2jOOpWhS\n",
      "https://api.spotify.com/v1/audio-features/67TtUjknieVZuDAPZEitRl\n",
      "https://api.spotify.com/v1/audio-features/4OUgQ4nb9mvm7hE8clNUqs\n",
      "https://api.spotify.com/v1/audio-features/7IzRlMcaTqHxCljQVCcmPZ\n",
      "https://api.spotify.com/v1/audio-features/2rkhUxIcfq82ayHZbSJk2n\n",
      "https://api.spotify.com/v1/audio-features/21qPmy9tKnsOMsyMptJVZj\n",
      "https://api.spotify.com/v1/audio-features/19txd6ai9XF4sHd4Bg9Oyk\n",
      "https://api.spotify.com/v1/audio-features/2J5dxClDG8T0YqI8CRsvTe\n",
      "https://api.spotify.com/v1/audio-features/5Q4Drez3RUu4wvSU3qo29C\n",
      "https://api.spotify.com/v1/audio-features/5tyXiJKHIgsYrCKhVZrBma\n",
      "https://api.spotify.com/v1/audio-features/03uOo2Gu3Q0EL3W1yWSgt5\n",
      "https://api.spotify.com/v1/audio-features/1z9ZzER0q4nMLLo96N1buy\n",
      "https://api.spotify.com/v1/audio-features/4NSSGphxt9TPwEi7xDVChT\n",
      "https://api.spotify.com/v1/audio-features/6cqJBGtXa9FDAAj2SBcvdc\n",
      "https://api.spotify.com/v1/audio-features/55xo7TCclsqQgy8qsGONsi\n",
      "https://api.spotify.com/v1/audio-features/7cr0xZA7txvBSfZ8DA9iMs\n",
      "https://api.spotify.com/v1/audio-features/5sJN67kvSkadLmm3Ek8Atg\n",
      "https://api.spotify.com/v1/audio-features/64tNKiApPJRlpYxSF2k4Fa\n",
      "https://api.spotify.com/v1/audio-features/75UyPuIyu6mlZ8JWbZ9Oxi\n",
      "https://api.spotify.com/v1/audio-features/2JBrxVSPxwLM5AqzjNSzVH\n",
      "https://api.spotify.com/v1/audio-features/7dDsBpwmVz44cUGnHNKa9b\n",
      "https://api.spotify.com/v1/audio-features/0CoYax5Dbua0zc9esZK7Sv\n",
      "https://api.spotify.com/v1/audio-features/7hK3JNnJGlh9Z2QHOUoE8I\n",
      "https://api.spotify.com/v1/audio-features/3lGSvaRpO8Y7B8hwQYWRbH\n",
      "https://api.spotify.com/v1/audio-features/4ASsFWfZCtZI20HXrgC8c2\n",
      "https://api.spotify.com/v1/audio-features/4SPgkONlGNEclNPVf5REJD\n",
      "https://api.spotify.com/v1/audio-features/58KihocAFn2VFbIdoyOSrK\n",
      "https://api.spotify.com/v1/audio-features/6dSu40OVSXn0xPqqzTGWwR\n",
      "https://api.spotify.com/v1/audio-features/77ofc1q8ULdC4l1GnIcema\n",
      "https://api.spotify.com/v1/audio-features/0znbvec9Nxq9UPOJ2k08xK\n",
      "https://api.spotify.com/v1/audio-features/5DHBIs8FxAPqWqIgvfs73o\n",
      "https://api.spotify.com/v1/audio-features/4ICGw9i33LLiYwyKKf3WNq\n",
      "https://api.spotify.com/v1/audio-features/1IbaVuUslWlj0TrSPjN77j\n",
      "https://api.spotify.com/v1/audio-features/0xh9CS434sQgIVvUR3KGn3\n",
      "https://api.spotify.com/v1/audio-features/7If8KoYFeDrwbkDR3euzCR\n",
      "https://api.spotify.com/v1/audio-features/3SKqIuSBWPYsuGkfG9NSG5\n",
      "https://api.spotify.com/v1/audio-features/2M1YOm0b2fpxnN8eeacXY3\n",
      "https://api.spotify.com/v1/audio-features/3Lkl8jbDeqToOyHhXH7wM7\n",
      "https://api.spotify.com/v1/audio-features/4IuJ7VOcjF1kPqPYVIb6lK\n",
      "https://api.spotify.com/v1/audio-features/5R4OQby2tOZ9CMXEK4PpMo\n",
      "https://api.spotify.com/v1/audio-features/1kIHAXIGCBThg05xBhu15t\n",
      "https://api.spotify.com/v1/audio-features/1Ii6Ie4F6OzaZKuMcyTSho\n",
      "https://api.spotify.com/v1/audio-features/6tQg0wJHKwnmoGIZXyjbRc\n",
      "https://api.spotify.com/v1/audio-features/5FGkmSptkKRtJMq0OnqGI9\n",
      "https://api.spotify.com/v1/audio-features/6F6ZLRMduOFHCkt1UlAXhc\n",
      "https://api.spotify.com/v1/audio-features/4nYxhtbb8Wu0mAuYM3bEJS\n",
      "https://api.spotify.com/v1/audio-features/0b41I4X2LjUSZ7J5Bxv8E1\n",
      "https://api.spotify.com/v1/audio-features/26oJ2ehtajiggjptJgND5Z\n",
      "https://api.spotify.com/v1/audio-features/4IaqCq8JFdbSxoouPNa7C5\n",
      "https://api.spotify.com/v1/audio-features/2rD1nsBjVxZ1L9sKsL71TR\n",
      "https://api.spotify.com/v1/audio-features/4KkXpyc2nlpJ6YCbvRvRGO\n",
      "https://api.spotify.com/v1/audio-features/77bQrvBDkwIOe8i2AG0CZs\n",
      "https://api.spotify.com/v1/audio-features/29ZKL9lU8D9rTOsEtFTTXB\n",
      "https://api.spotify.com/v1/audio-features/6xyTT1l8TWxKKqCYjF63RJ\n",
      "https://api.spotify.com/v1/audio-features/5NEbpQmJl2nKNBWqRbGIOe\n",
      "https://api.spotify.com/v1/audio-features/5O6QWWZ1MamNOAc5QdGN2w\n",
      "https://api.spotify.com/v1/audio-features/0hiLsryEJ2jiGIQwiXsbOp\n",
      "https://api.spotify.com/v1/audio-features/69WjDE9U51u4ge8BFCxQKi\n",
      "https://api.spotify.com/v1/audio-features/25BhFEuQb87r8gcmlsNKHe\n",
      "https://api.spotify.com/v1/audio-features/6N11RXSD2xZ8fUUYPyUdF3\n",
      "https://api.spotify.com/v1/audio-features/2GZRmL339pA25eFibQW8Qn\n",
      "https://api.spotify.com/v1/audio-features/5q8nqAMHNUS393Rcgs6k1Y\n",
      "https://api.spotify.com/v1/audio-features/1yj2Gpnt34HbspNCwP7jpi\n",
      "https://api.spotify.com/v1/audio-features/77L7qvSLC9IsX0tbO9LWd6\n",
      "https://api.spotify.com/v1/audio-features/7cpiurluUfUcOn9WKBSeLW\n",
      "https://api.spotify.com/v1/audio-features/27DeYjwaWFSrPXu087Sfmf\n",
      "https://api.spotify.com/v1/audio-features/2ASNsySC0ZStrI45CaZ7jM\n",
      "https://api.spotify.com/v1/audio-features/2XNQTSvyyCJXMnPZNHEtum\n",
      "https://api.spotify.com/v1/audio-features/3u2GQokLG0JeVWFsYohMOw\n",
      "https://api.spotify.com/v1/audio-features/6hbQxcFCSbYFGCsiDr5fPh\n",
      "https://api.spotify.com/v1/audio-features/0EiC36AyU0sMHJVsNJCDD4\n",
      "https://api.spotify.com/v1/audio-features/2UxjoXSjad5cySXyr8LblW\n",
      "https://api.spotify.com/v1/audio-features/6uodiRlwsP2tfDJy2hLgHg\n",
      "https://api.spotify.com/v1/audio-features/7aJLTXYS2wdONYJtJfCTYB\n",
      "https://api.spotify.com/v1/audio-features/2XrvNcawFtBpZUtnMfOyle\n",
      "https://api.spotify.com/v1/audio-features/6aH72UPeru6f30qcn9TgAI\n",
      "https://api.spotify.com/v1/audio-features/5EqpDX6mEOP7ffxIt1v8mR\n",
      "https://api.spotify.com/v1/audio-features/56NuiMtGojg71LdJREwdK9\n",
      "https://api.spotify.com/v1/audio-features/2g6oN9T11IIW1N3AApcsj9\n",
      "https://api.spotify.com/v1/audio-features/02NHMn3kkORy0POXUcl9pp\n",
      "https://api.spotify.com/v1/audio-features/0LhhCaAmdrC7B7CKVP5rzF\n",
      "https://api.spotify.com/v1/audio-features/51s5SeypNVsOslP5bC2D2n\n",
      "https://api.spotify.com/v1/audio-features/12V4k1d9QEQ2RKtYjUDhgi\n",
      "https://api.spotify.com/v1/audio-features/00cbim1loXO1mjfE647uIs\n",
      "https://api.spotify.com/v1/audio-features/16LAo0fDyBakf2sCHbS3Ud\n",
      "https://api.spotify.com/v1/audio-features/2i4VsOvjYtbsm8KgPtnNFT\n",
      "https://api.spotify.com/v1/audio-features/2LiZZZfCuwmmiG2tgQPpcS\n",
      "https://api.spotify.com/v1/audio-features/00W0J8q6WkTWPSQpf7ujd4\n",
      "https://api.spotify.com/v1/audio-features/6UixhG9h16voUbsaUamU0b\n",
      "https://api.spotify.com/v1/audio-features/3ICcLeLa9iXfn38Yar1XOG\n",
      "https://api.spotify.com/v1/audio-features/6ig1wYlbaQzOdSwUOI8Ydh\n",
      "https://api.spotify.com/v1/audio-features/4YeEF6jrh2s5jXo2V7owKH\n",
      "https://api.spotify.com/v1/audio-features/3wCTa5o7hfnQVGL1JqB78z\n",
      "https://api.spotify.com/v1/audio-features/5GgRhQXcf6PbUQrce7CDnm\n",
      "https://api.spotify.com/v1/audio-features/09XMTAzvqpf4RMzvh9merR\n",
      "https://api.spotify.com/v1/audio-features/0GYgydYwuoFfthl3FdB0Cl\n",
      "https://api.spotify.com/v1/audio-features/2e4XazvPedvgaJsaVtac2Y\n",
      "https://api.spotify.com/v1/audio-features/0n0ToyqyI5dHPsrkdT6pG6\n",
      "https://api.spotify.com/v1/audio-features/5b0LYOVhvPC2192AM0rgpT\n",
      "https://api.spotify.com/v1/audio-features/4aSYlhRxM8FkCDjPTkRdyb\n",
      "https://api.spotify.com/v1/audio-features/1u5oA77tUet3HsxbL895y9\n",
      "https://api.spotify.com/v1/audio-features/7ulwV2WDp3QPbZSI9CyfcS\n",
      "https://api.spotify.com/v1/audio-features/2aWbImvc4mU3TO3YrxX4ZG\n",
      "https://api.spotify.com/v1/audio-features/5rUXfHl7PuKsaVZ0IO97Iv\n",
      "https://api.spotify.com/v1/audio-features/7zJXZ0YRmMlaafZP2HtvE9\n",
      "https://api.spotify.com/v1/audio-features/06w91dUhAoYzPinMrVu80d\n",
      "https://api.spotify.com/v1/audio-features/0bIqMyqbKiKhvixs8laN9w\n",
      "https://api.spotify.com/v1/audio-features/3gm3mBDy96tbKn8goB4Bey\n",
      "https://api.spotify.com/v1/audio-features/1ZodMHgyyQ5SKyMkYByggk\n",
      "https://api.spotify.com/v1/audio-features/603FeFqfYl3XeJLikBmUvf\n",
      "https://api.spotify.com/v1/audio-features/0auuPNkhr2HZngxPLkhwUQ\n",
      "https://api.spotify.com/v1/audio-features/3nHZ5o71NOnupkFwMNJocM\n",
      "https://api.spotify.com/v1/audio-features/3G3Oo5Wj0j5Jdz4sy6HBw8\n",
      "https://api.spotify.com/v1/audio-features/0gstIh3jr4ZpNTV2wT5FTG\n",
      "https://api.spotify.com/v1/audio-features/73mFWbTtW1Jn4lMrsNTcQw\n",
      "https://api.spotify.com/v1/audio-features/49m7lqNswC4JGl2GXQovDr\n"
     ]
    }
   ],
   "source": [
    "danceability = []\n",
    "energy = []\n",
    "key = []\n",
    "loudness = []\n",
    "speechiness = []\n",
    "acousticness = []\n",
    "instrumentalness = []\n",
    "liveness = []\n",
    "valence = []\n",
    "tempo = []\n",
    "\n",
    "for id in df_tracks[\"track_id\"]:\n",
    "    track_resp = sp.get_track_features(id)\n",
    "    danceability.append( track_resp[\"danceability\"] )\n",
    "    energy.append( track_resp[\"energy\"] )\n",
    "    key.append( track_resp[\"key\"] )\n",
    "    loudness.append( track_resp[\"loudness\"] )\n",
    "    speechiness.append( track_resp[\"speechiness\"] )\n",
    "    acousticness.append( track_resp[\"acousticness\"] )\n",
    "    instrumentalness.append( track_resp[\"instrumentalness\"] )\n",
    "    liveness.append( track_resp[\"liveness\"] )\n",
    "    valence.append( track_resp[\"valence\"] )\n",
    "    tempo.append( track_resp[\"tempo\"] )\n",
    "\n",
    "df_tracks[\"danceability\"] = danceability\n",
    "df_tracks[\"energy\"] = energy\n",
    "df_tracks[\"key\"] = key\n",
    "df_tracks[\"loudness\"] = loudness\n",
    "df_tracks[\"speechiness\"] = speechiness\n",
    "df_tracks[\"acousticness\"] = acousticness\n",
    "df_tracks[\"instrumentalness\"] = instrumentalness\n",
    "df_tracks[\"liveness\"] = liveness\n",
    "df_tracks[\"valence\"] = valence\n",
    "df_tracks[\"tempo\"] = tempo\n",
    "\n",
    "compression_opts = dict(method='zip', archive_name='out_tracks.csv')  \n",
    "df_tracks.to_csv('./results/out_tracks.zip', index=False, compression=compression_opts)  "
   ]
  }
 ]
}