spotify_rest_api_challenge.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "ef05c1d6",
   "metadata": {},
   "source": [
    "# Spotify REST API Challenge\n",
    "\n",
    "__What to listen?__\n",
    "\n",
    "Create your own playlist based on the related artists and their most popular tracks using the [Spotify REST API](https://developer.spotify.com/)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "17a49776",
   "metadata": {},
   "outputs": [],
   "source": [
    "# imports\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4e97884c",
   "metadata": {},
   "source": [
    "### Get access!!!\n",
    "\n",
    "Get your `client_id` and `client_secret` a generate your __token__ access"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cfd9fb85",
   "metadata": {},
   "source": [
    "Hay que rellenar las variables.\n",
    "Para crear el token, hay que hacer una peticion post a spotify para que te devuelva el token pero hay que pedir unos permisos. 'auth_url' es el 'end point'.\n",
    "En 'auth_response' ponemos el end point y varios headers, y el servidor nos devuelve el token."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7b5d2e52",
   "metadata": {},
   "outputs": [],
   "source": [
    "# generate token with a POST request\n",
    "\n",
    "client_id = '8c5be5d8e64244c8ad0c8274c85fcc7e'\n",
    "client_secret = '0c396ca53d2448bdace07a4ac51b4146'\n",
    "auth_url = 'https://accounts.spotify.com/api/token'\n",
    "\n",
    "auth_response = requests.post(auth_url, {'grant_type': 'client_credentials',\n",
    "                                         'client_id': client_id,\n",
    "                                         'client_secret': client_secret}).json()\n",
    "access_token = auth_response['access_token']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e617caff",
   "metadata": {},
   "source": [
    "### Set your main variables!!!\n",
    "\n",
    "Set the `base_url` (i.e.: End-point) and `headers` for your __GET__ operations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "62e6d4fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# setting the main variables\n",
    "base_url = 'https://api.spotify.com/v1'\n",
    "resource = '/artists'\n",
    "artist_id = '/711MCceyCBcFnzjGY4Q7Un'\n",
    "related_artists = '/related-artists'\n",
    "headers = {'Authorization':'Bearer {token}'.format(token=access_token)}\n",
    "top_tracks = '/top-tracks'\n",
    "country = '?market=ES'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16660a9b",
   "metadata": {},
   "source": [
    "### Create your new playlist!!!\n",
    "\n",
    "Use [`/related-artists`](https://developer.spotify.com/documentation/web-api/reference/#/operations/get-an-artists-related-artists) and [`/top-tracks`](https://developer.spotify.com/documentation/web-api/reference/#/operations/get-an-artists-top-tracks) in order to get the data that you need\n",
    "\n",
    "__Here you have the different artists to start with:__\n",
    "\n",
    "_Option 1:_ 711MCceyCBcFnzjGY4Q7Un\n",
    "\n",
    "_Option 2:_ 5gs3QMiBgkUgNofeA16Awv\n",
    "\n",
    "_Option 3:_ 1ZcvF2meiXi5UPDJWxrKR5\n",
    "\n",
    "_Option 4:_ 0HSGpDMeXaEmH5aUIHjnBF\n",
    "\n",
    "_Option 5:_ 5TYxZTjIPqKM8K8NuP9woO\n",
    "\n",
    "_Option 6:_ 36QJpDe2go2KgaRleHCDTp\n",
    "\n",
    "_Option 7:_ 3qm84nBOXUEQ2vnTfUTTFC\n",
    "\n",
    "_Option 8:_ 4NJhFmfw43RLBLjQvxDuRS\n",
    "\n",
    "_Option 9:_ 0L8ExT028jH3ddEcZwqJJ5\n",
    "\n",
    "_Option 10:_ 1vCWHaC5f2uS3yhpwWbIA6\n",
    "\n",
    "_Option 11:_ 1dfeR4HaWDbWqFHLkxsg1d\n",
    "\n",
    "_Option 12:_ 6ogn9necmbUdCppmNnGOdi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "c194ac9f",
   "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>external_urls</th>\n",
       "      <th>followers</th>\n",
       "      <th>genres</th>\n",
       "      <th>href</th>\n",
       "      <th>id</th>\n",
       "      <th>images</th>\n",
       "      <th>name</th>\n",
       "      <th>popularity</th>\n",
       "      <th>type</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/3...</td>\n",
       "      <td>{'href': None, 'total': 22741369}</td>\n",
       "      <td>[glam metal, hard rock, rock]</td>\n",
       "      <td>https://api.spotify.com/v1/artists/3qm84nBOXUE...</td>\n",
       "      <td>3qm84nBOXUEQ2vnTfUTTFC</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Guns N' Roses</td>\n",
       "      <td>81</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:3qm84nBOXUEQ2vnTfUTTFC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/6...</td>\n",
       "      <td>{'href': None, 'total': 593307}</td>\n",
       "      <td>[album rock, glam metal, hard rock, metal, roc...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/6urzdpGY5yU...</td>\n",
       "      <td>6urzdpGY5yUimWZsgJUoTb</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Airbourne</td>\n",
       "      <td>61</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:6urzdpGY5yUimWZsgJUoTb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/0...</td>\n",
       "      <td>{'href': None, 'total': 6574911}</td>\n",
       "      <td>[album rock, classic rock, glam rock, hard roc...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/07XSN3sPlIl...</td>\n",
       "      <td>07XSN3sPlIlB2L2XNcTwJw</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>KISS</td>\n",
       "      <td>74</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:07XSN3sPlIlB2L2XNcTwJw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/3...</td>\n",
       "      <td>{'href': None, 'total': 2792054}</td>\n",
       "      <td>[album rock, blues rock, classic rock, detroit...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/3EhbVgyfGd7...</td>\n",
       "      <td>3EhbVgyfGd7HkpsagwL9GS</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Alice Cooper</td>\n",
       "      <td>66</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:3EhbVgyfGd7HkpsagwL9GS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/7...</td>\n",
       "      <td>{'href': None, 'total': 11286447}</td>\n",
       "      <td>[album rock, classic rock, hard rock, rock]</td>\n",
       "      <td>https://api.spotify.com/v1/artists/7Ey4PD4MYsK...</td>\n",
       "      <td>7Ey4PD4MYsKc5I2dolUwbH</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Aerosmith</td>\n",
       "      <td>78</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:7Ey4PD4MYsKc5I2dolUwbH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/2...</td>\n",
       "      <td>{'href': None, 'total': 2925246}</td>\n",
       "      <td>[album rock, birmingham metal, classic rock, h...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/2tRsMl4eGxw...</td>\n",
       "      <td>2tRsMl4eGxwoNabM08Dm4I</td>\n",
       "      <td>[{'height': 688, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Judas Priest</td>\n",
       "      <td>68</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:2tRsMl4eGxwoNabM08Dm4I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/2...</td>\n",
       "      <td>{'href': None, 'total': 5108026}</td>\n",
       "      <td>[album rock, german hard rock, german metal, g...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/27T030eWyCQ...</td>\n",
       "      <td>27T030eWyCQRmDyuvr1kxY</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Scorpions</td>\n",
       "      <td>75</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:27T030eWyCQRmDyuvr1kxY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/6...</td>\n",
       "      <td>{'href': None, 'total': 3916513}</td>\n",
       "      <td>[album rock, birmingham metal, hard rock, meta...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/6ZLTlhejhnd...</td>\n",
       "      <td>6ZLTlhejhndI4Rh53vYhrY</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Ozzy Osbourne</td>\n",
       "      <td>74</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:6ZLTlhejhndI4Rh53vYhrY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/4...</td>\n",
       "      <td>{'href': None, 'total': 1847320}</td>\n",
       "      <td>[album rock, classic rock, glam metal, hard ro...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/4CYeVo5iZbt...</td>\n",
       "      <td>4CYeVo5iZbtYGBN4Isc3n6</td>\n",
       "      <td>[{'height': 644, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Dio</td>\n",
       "      <td>64</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:4CYeVo5iZbtYGBN4Isc3n6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/5...</td>\n",
       "      <td>{'href': None, 'total': 4270990}</td>\n",
       "      <td>[album rock, blues rock, classic rock, hard ro...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/568ZhdwyaiC...</td>\n",
       "      <td>568ZhdwyaiCyOGJRtNYhWf</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Deep Purple</td>\n",
       "      <td>70</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:568ZhdwyaiCyOGJRtNYhWf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/5...</td>\n",
       "      <td>{'href': None, 'total': 5790873}</td>\n",
       "      <td>[album rock, birmingham metal, classic rock, h...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/5M52tdBnJaK...</td>\n",
       "      <td>5M52tdBnJaKSvOpJGz8mfZ</td>\n",
       "      <td>[{'height': 1333, 'url': 'https://i.scdn.co/im...</td>\n",
       "      <td>Black Sabbath</td>\n",
       "      <td>74</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:5M52tdBnJaKSvOpJGz8mfZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/6...</td>\n",
       "      <td>{'href': None, 'total': 6921685}</td>\n",
       "      <td>[hard rock, metal, nwobhm, rock]</td>\n",
       "      <td>https://api.spotify.com/v1/artists/6mdiAmATAx7...</td>\n",
       "      <td>6mdiAmATAx73kdxrNrnlao</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Iron Maiden</td>\n",
       "      <td>76</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:6mdiAmATAx73kdxrNrnlao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/0...</td>\n",
       "      <td>{'href': None, 'total': 3619230}</td>\n",
       "      <td>[glam metal, hard rock, metal, rock, sleaze rock]</td>\n",
       "      <td>https://api.spotify.com/v1/artists/0cc6vw3VN8Y...</td>\n",
       "      <td>0cc6vw3VN8YlIcvr1v7tBL</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Mötley Crüe</td>\n",
       "      <td>73</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:0cc6vw3VN8YlIcvr1v7tBL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/7...</td>\n",
       "      <td>{'href': None, 'total': 1896369}</td>\n",
       "      <td>[album rock, glam metal, hard rock, metal, rock]</td>\n",
       "      <td>https://api.spotify.com/v1/artists/7b85ve82Sh3...</td>\n",
       "      <td>7b85ve82Sh36a3UAx74wut</td>\n",
       "      <td>[{'height': 589, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Twisted Sister</td>\n",
       "      <td>65</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:7b85ve82Sh36a3UAx74wut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/2...</td>\n",
       "      <td>{'href': None, 'total': 4377248}</td>\n",
       "      <td>[album rock, classic rock, hard rock, metal, r...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/2cnMpRsOVqt...</td>\n",
       "      <td>2cnMpRsOVqtPMfq7YiFE6K</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Van Halen</td>\n",
       "      <td>74</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:2cnMpRsOVqtPMfq7YiFE6K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/1...</td>\n",
       "      <td>{'href': None, 'total': 3015445}</td>\n",
       "      <td>[album rock, alternative metal, hard rock, met...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/1DFr97A9Hnb...</td>\n",
       "      <td>1DFr97A9HnbV3SKTJFu62M</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Motörhead</td>\n",
       "      <td>68</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:1DFr97A9HnbV3SKTJFu62M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/2...</td>\n",
       "      <td>{'href': None, 'total': 3332157}</td>\n",
       "      <td>[album rock, blues rock, classic rock, country...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/2AM4ilv6UzW...</td>\n",
       "      <td>2AM4ilv6UzW0uMRuqKtDgN</td>\n",
       "      <td>[{'height': 1503, 'url': 'https://i.scdn.co/im...</td>\n",
       "      <td>ZZ Top</td>\n",
       "      <td>71</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:2AM4ilv6UzW0uMRuqKtDgN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/1...</td>\n",
       "      <td>{'href': None, 'total': 1311560}</td>\n",
       "      <td>[album rock, classic rock, glam metal, hard ro...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/1dLWg6m8RRh...</td>\n",
       "      <td>1dLWg6m8RRhizsdqJbhyj3</td>\n",
       "      <td>[{'height': 610, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Quiet Riot</td>\n",
       "      <td>61</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:1dLWg6m8RRhizsdqJbhyj3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/4...</td>\n",
       "      <td>{'href': None, 'total': 496858}</td>\n",
       "      <td>[album rock, alternative rock, classic rock, g...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/49DW3KvkyjH...</td>\n",
       "      <td>49DW3KvkyjHO35mK1JnSyS</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>The Cult</td>\n",
       "      <td>62</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:49DW3KvkyjHO35mK1JnSyS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>{'spotify': 'https://open.spotify.com/artist/6...</td>\n",
       "      <td>{'href': None, 'total': 1124746}</td>\n",
       "      <td>[album rock, classic rock, glam metal, hard ro...</td>\n",
       "      <td>https://api.spotify.com/v1/artists/6SLAMfhOi7U...</td>\n",
       "      <td>6SLAMfhOi7UJI0fMztaK0m</td>\n",
       "      <td>[{'height': 971, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Rainbow</td>\n",
       "      <td>64</td>\n",
       "      <td>artist</td>\n",
       "      <td>spotify:artist:6SLAMfhOi7UJI0fMztaK0m</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        external_urls  \\\n",
       "0   {'spotify': 'https://open.spotify.com/artist/3...   \n",
       "1   {'spotify': 'https://open.spotify.com/artist/6...   \n",
       "2   {'spotify': 'https://open.spotify.com/artist/0...   \n",
       "3   {'spotify': 'https://open.spotify.com/artist/3...   \n",
       "4   {'spotify': 'https://open.spotify.com/artist/7...   \n",
       "5   {'spotify': 'https://open.spotify.com/artist/2...   \n",
       "6   {'spotify': 'https://open.spotify.com/artist/2...   \n",
       "7   {'spotify': 'https://open.spotify.com/artist/6...   \n",
       "8   {'spotify': 'https://open.spotify.com/artist/4...   \n",
       "9   {'spotify': 'https://open.spotify.com/artist/5...   \n",
       "10  {'spotify': 'https://open.spotify.com/artist/5...   \n",
       "11  {'spotify': 'https://open.spotify.com/artist/6...   \n",
       "12  {'spotify': 'https://open.spotify.com/artist/0...   \n",
       "13  {'spotify': 'https://open.spotify.com/artist/7...   \n",
       "14  {'spotify': 'https://open.spotify.com/artist/2...   \n",
       "15  {'spotify': 'https://open.spotify.com/artist/1...   \n",
       "16  {'spotify': 'https://open.spotify.com/artist/2...   \n",
       "17  {'spotify': 'https://open.spotify.com/artist/1...   \n",
       "18  {'spotify': 'https://open.spotify.com/artist/4...   \n",
       "19  {'spotify': 'https://open.spotify.com/artist/6...   \n",
       "\n",
       "                            followers  \\\n",
       "0   {'href': None, 'total': 22741369}   \n",
       "1     {'href': None, 'total': 593307}   \n",
       "2    {'href': None, 'total': 6574911}   \n",
       "3    {'href': None, 'total': 2792054}   \n",
       "4   {'href': None, 'total': 11286447}   \n",
       "5    {'href': None, 'total': 2925246}   \n",
       "6    {'href': None, 'total': 5108026}   \n",
       "7    {'href': None, 'total': 3916513}   \n",
       "8    {'href': None, 'total': 1847320}   \n",
       "9    {'href': None, 'total': 4270990}   \n",
       "10   {'href': None, 'total': 5790873}   \n",
       "11   {'href': None, 'total': 6921685}   \n",
       "12   {'href': None, 'total': 3619230}   \n",
       "13   {'href': None, 'total': 1896369}   \n",
       "14   {'href': None, 'total': 4377248}   \n",
       "15   {'href': None, 'total': 3015445}   \n",
       "16   {'href': None, 'total': 3332157}   \n",
       "17   {'href': None, 'total': 1311560}   \n",
       "18    {'href': None, 'total': 496858}   \n",
       "19   {'href': None, 'total': 1124746}   \n",
       "\n",
       "                                               genres  \\\n",
       "0                       [glam metal, hard rock, rock]   \n",
       "1   [album rock, glam metal, hard rock, metal, roc...   \n",
       "2   [album rock, classic rock, glam rock, hard roc...   \n",
       "3   [album rock, blues rock, classic rock, detroit...   \n",
       "4         [album rock, classic rock, hard rock, rock]   \n",
       "5   [album rock, birmingham metal, classic rock, h...   \n",
       "6   [album rock, german hard rock, german metal, g...   \n",
       "7   [album rock, birmingham metal, hard rock, meta...   \n",
       "8   [album rock, classic rock, glam metal, hard ro...   \n",
       "9   [album rock, blues rock, classic rock, hard ro...   \n",
       "10  [album rock, birmingham metal, classic rock, h...   \n",
       "11                   [hard rock, metal, nwobhm, rock]   \n",
       "12  [glam metal, hard rock, metal, rock, sleaze rock]   \n",
       "13   [album rock, glam metal, hard rock, metal, rock]   \n",
       "14  [album rock, classic rock, hard rock, metal, r...   \n",
       "15  [album rock, alternative metal, hard rock, met...   \n",
       "16  [album rock, blues rock, classic rock, country...   \n",
       "17  [album rock, classic rock, glam metal, hard ro...   \n",
       "18  [album rock, alternative rock, classic rock, g...   \n",
       "19  [album rock, classic rock, glam metal, hard ro...   \n",
       "\n",
       "                                                 href                      id  \\\n",
       "0   https://api.spotify.com/v1/artists/3qm84nBOXUE...  3qm84nBOXUEQ2vnTfUTTFC   \n",
       "1   https://api.spotify.com/v1/artists/6urzdpGY5yU...  6urzdpGY5yUimWZsgJUoTb   \n",
       "2   https://api.spotify.com/v1/artists/07XSN3sPlIl...  07XSN3sPlIlB2L2XNcTwJw   \n",
       "3   https://api.spotify.com/v1/artists/3EhbVgyfGd7...  3EhbVgyfGd7HkpsagwL9GS   \n",
       "4   https://api.spotify.com/v1/artists/7Ey4PD4MYsK...  7Ey4PD4MYsKc5I2dolUwbH   \n",
       "5   https://api.spotify.com/v1/artists/2tRsMl4eGxw...  2tRsMl4eGxwoNabM08Dm4I   \n",
       "6   https://api.spotify.com/v1/artists/27T030eWyCQ...  27T030eWyCQRmDyuvr1kxY   \n",
       "7   https://api.spotify.com/v1/artists/6ZLTlhejhnd...  6ZLTlhejhndI4Rh53vYhrY   \n",
       "8   https://api.spotify.com/v1/artists/4CYeVo5iZbt...  4CYeVo5iZbtYGBN4Isc3n6   \n",
       "9   https://api.spotify.com/v1/artists/568ZhdwyaiC...  568ZhdwyaiCyOGJRtNYhWf   \n",
       "10  https://api.spotify.com/v1/artists/5M52tdBnJaK...  5M52tdBnJaKSvOpJGz8mfZ   \n",
       "11  https://api.spotify.com/v1/artists/6mdiAmATAx7...  6mdiAmATAx73kdxrNrnlao   \n",
       "12  https://api.spotify.com/v1/artists/0cc6vw3VN8Y...  0cc6vw3VN8YlIcvr1v7tBL   \n",
       "13  https://api.spotify.com/v1/artists/7b85ve82Sh3...  7b85ve82Sh36a3UAx74wut   \n",
       "14  https://api.spotify.com/v1/artists/2cnMpRsOVqt...  2cnMpRsOVqtPMfq7YiFE6K   \n",
       "15  https://api.spotify.com/v1/artists/1DFr97A9Hnb...  1DFr97A9HnbV3SKTJFu62M   \n",
       "16  https://api.spotify.com/v1/artists/2AM4ilv6UzW...  2AM4ilv6UzW0uMRuqKtDgN   \n",
       "17  https://api.spotify.com/v1/artists/1dLWg6m8RRh...  1dLWg6m8RRhizsdqJbhyj3   \n",
       "18  https://api.spotify.com/v1/artists/49DW3KvkyjH...  49DW3KvkyjHO35mK1JnSyS   \n",
       "19  https://api.spotify.com/v1/artists/6SLAMfhOi7U...  6SLAMfhOi7UJI0fMztaK0m   \n",
       "\n",
       "                                               images            name  \\\n",
       "0   [{'height': 640, 'url': 'https://i.scdn.co/ima...   Guns N' Roses   \n",
       "1   [{'height': 640, 'url': 'https://i.scdn.co/ima...       Airbourne   \n",
       "2   [{'height': 640, 'url': 'https://i.scdn.co/ima...            KISS   \n",
       "3   [{'height': 640, 'url': 'https://i.scdn.co/ima...    Alice Cooper   \n",
       "4   [{'height': 640, 'url': 'https://i.scdn.co/ima...       Aerosmith   \n",
       "5   [{'height': 688, 'url': 'https://i.scdn.co/ima...    Judas Priest   \n",
       "6   [{'height': 640, 'url': 'https://i.scdn.co/ima...       Scorpions   \n",
       "7   [{'height': 640, 'url': 'https://i.scdn.co/ima...   Ozzy Osbourne   \n",
       "8   [{'height': 644, 'url': 'https://i.scdn.co/ima...             Dio   \n",
       "9   [{'height': 640, 'url': 'https://i.scdn.co/ima...     Deep Purple   \n",
       "10  [{'height': 1333, 'url': 'https://i.scdn.co/im...   Black Sabbath   \n",
       "11  [{'height': 640, 'url': 'https://i.scdn.co/ima...     Iron Maiden   \n",
       "12  [{'height': 640, 'url': 'https://i.scdn.co/ima...     Mötley Crüe   \n",
       "13  [{'height': 589, 'url': 'https://i.scdn.co/ima...  Twisted Sister   \n",
       "14  [{'height': 640, 'url': 'https://i.scdn.co/ima...       Van Halen   \n",
       "15  [{'height': 640, 'url': 'https://i.scdn.co/ima...       Motörhead   \n",
       "16  [{'height': 1503, 'url': 'https://i.scdn.co/im...          ZZ Top   \n",
       "17  [{'height': 610, 'url': 'https://i.scdn.co/ima...      Quiet Riot   \n",
       "18  [{'height': 640, 'url': 'https://i.scdn.co/ima...        The Cult   \n",
       "19  [{'height': 971, 'url': 'https://i.scdn.co/ima...         Rainbow   \n",
       "\n",
       "    popularity    type                                    uri  \n",
       "0           81  artist  spotify:artist:3qm84nBOXUEQ2vnTfUTTFC  \n",
       "1           61  artist  spotify:artist:6urzdpGY5yUimWZsgJUoTb  \n",
       "2           74  artist  spotify:artist:07XSN3sPlIlB2L2XNcTwJw  \n",
       "3           66  artist  spotify:artist:3EhbVgyfGd7HkpsagwL9GS  \n",
       "4           78  artist  spotify:artist:7Ey4PD4MYsKc5I2dolUwbH  \n",
       "5           68  artist  spotify:artist:2tRsMl4eGxwoNabM08Dm4I  \n",
       "6           75  artist  spotify:artist:27T030eWyCQRmDyuvr1kxY  \n",
       "7           74  artist  spotify:artist:6ZLTlhejhndI4Rh53vYhrY  \n",
       "8           64  artist  spotify:artist:4CYeVo5iZbtYGBN4Isc3n6  \n",
       "9           70  artist  spotify:artist:568ZhdwyaiCyOGJRtNYhWf  \n",
       "10          74  artist  spotify:artist:5M52tdBnJaKSvOpJGz8mfZ  \n",
       "11          76  artist  spotify:artist:6mdiAmATAx73kdxrNrnlao  \n",
       "12          73  artist  spotify:artist:0cc6vw3VN8YlIcvr1v7tBL  \n",
       "13          65  artist  spotify:artist:7b85ve82Sh36a3UAx74wut  \n",
       "14          74  artist  spotify:artist:2cnMpRsOVqtPMfq7YiFE6K  \n",
       "15          68  artist  spotify:artist:1DFr97A9HnbV3SKTJFu62M  \n",
       "16          71  artist  spotify:artist:2AM4ilv6UzW0uMRuqKtDgN  \n",
       "17          61  artist  spotify:artist:1dLWg6m8RRhizsdqJbhyj3  \n",
       "18          62  artist  spotify:artist:49DW3KvkyjHO35mK1JnSyS  \n",
       "19          64  artist  spotify:artist:6SLAMfhOi7UJI0fMztaK0m  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response1 = requests.get(base_url + resource + artist_id + related_artists, headers=headers).json()\n",
    "response1\n",
    "df_related_artist = pd.DataFrame(response1['artists'])\n",
    "df_related_artist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "6b3d04e0",
   "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>album</th>\n",
       "      <th>artists</th>\n",
       "      <th>disc_number</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>explicit</th>\n",
       "      <th>external_ids</th>\n",
       "      <th>external_urls</th>\n",
       "      <th>href</th>\n",
       "      <th>id</th>\n",
       "      <th>is_local</th>\n",
       "      <th>is_playable</th>\n",
       "      <th>name</th>\n",
       "      <th>popularity</th>\n",
       "      <th>preview_url</th>\n",
       "      <th>track_number</th>\n",
       "      <th>type</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>255493</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP08000046'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/08...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/08mG3Y1vljYA...</td>\n",
       "      <td>08mG3Y1vljYA6bvDt4Wqkj</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Back In Black</td>\n",
       "      <td>85</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/506bc9a048599097...</td>\n",
       "      <td>6</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:08mG3Y1vljYA6bvDt4Wqkj</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>208400</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP07900028'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/2z...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/2zYzyRzz6pRm...</td>\n",
       "      <td>2zYzyRzz6pRmhPzyfMEC8s</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Highway to Hell</td>\n",
       "      <td>85</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/db138a9742397601...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:2zYzyRzz6pRmhPzyfMEC8s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>292880</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP09000014'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/57...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/57bgtoPSgt23...</td>\n",
       "      <td>57bgtoPSgt236HzfBOd8kj</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Thunderstruck</td>\n",
       "      <td>84</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/df9f0326adc85339...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:57bgtoPSgt236HzfBOd8kj</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>210173</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP08000047'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/2S...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/2SiXAy7TuUky...</td>\n",
       "      <td>2SiXAy7TuUkycRVbbWDEpo</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>You Shook Me All Night Long</td>\n",
       "      <td>81</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/2a200f628c41fadd...</td>\n",
       "      <td>7</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:2SiXAy7TuUkycRVbbWDEpo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>214666</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP07600012'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/7L...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7LRMbd3LEoV5...</td>\n",
       "      <td>7LRMbd3LEoV5wZJvXT1Lwb</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>T.N.T.</td>\n",
       "      <td>79</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/baea5e2b5a731532...</td>\n",
       "      <td>5</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:7LRMbd3LEoV5wZJvXT1Lwb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>312293</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP08000041'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/69...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/69QHm3pustz0...</td>\n",
       "      <td>69QHm3pustz01CJRwdo20z</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Hells Bells</td>\n",
       "      <td>75</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/63c396837c1738dd...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:69QHm3pustz01CJRwdo20z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>231933</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP07600046'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/2d...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/2d4e45fmUngu...</td>\n",
       "      <td>2d4e45fmUnguxh6yqC7gNT</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Dirty Deeds Done Dirt Cheap</td>\n",
       "      <td>74</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/e966a99df223f101...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:2d4e45fmUnguxh6yqC7gNT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>317426</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'AUAP08000042'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/0C...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0C80GCp0mMuB...</td>\n",
       "      <td>0C80GCp0mMuBzLf3EAXqxv</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Shoot to Thrill</td>\n",
       "      <td>74</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/289d87e96d7e99b0...</td>\n",
       "      <td>2</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:0C80GCp0mMuBzLf3EAXqxv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>301226</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'USEW17500002'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/7n...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7nemcVsXVFZF...</td>\n",
       "      <td>7nemcVsXVFZF01iqpIIo2Y</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>It's a Long Way to the Top (If You Wanna Rock ...</td>\n",
       "      <td>72</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/0637218420f50db9...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:7nemcVsXVFZF01iqpIIo2Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{'album_type': 'album', 'artists': [{'external...</td>\n",
       "      <td>[{'external_urls': {'spotify': 'https://open.s...</td>\n",
       "      <td>1</td>\n",
       "      <td>261506</td>\n",
       "      <td>False</td>\n",
       "      <td>{'isrc': 'USSM10802975'}</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/track/4f...</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4feXJ5IC3avX...</td>\n",
       "      <td>4feXJ5IC3avXsVW9WNFSag</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Rock N Roll Train</td>\n",
       "      <td>70</td>\n",
       "      <td>https://p.scdn.co/mp3-preview/eefd2f76a89e1c20...</td>\n",
       "      <td>1</td>\n",
       "      <td>track</td>\n",
       "      <td>spotify:track:4feXJ5IC3avXsVW9WNFSag</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               album  \\\n",
       "0  {'album_type': 'album', 'artists': [{'external...   \n",
       "1  {'album_type': 'album', 'artists': [{'external...   \n",
       "2  {'album_type': 'album', 'artists': [{'external...   \n",
       "3  {'album_type': 'album', 'artists': [{'external...   \n",
       "4  {'album_type': 'album', 'artists': [{'external...   \n",
       "5  {'album_type': 'album', 'artists': [{'external...   \n",
       "6  {'album_type': 'album', 'artists': [{'external...   \n",
       "7  {'album_type': 'album', 'artists': [{'external...   \n",
       "8  {'album_type': 'album', 'artists': [{'external...   \n",
       "9  {'album_type': 'album', 'artists': [{'external...   \n",
       "\n",
       "                                             artists  disc_number  \\\n",
       "0  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "1  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "2  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "3  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "4  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "5  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "6  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "7  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "8  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "9  [{'external_urls': {'spotify': 'https://open.s...            1   \n",
       "\n",
       "   duration_ms  explicit              external_ids  \\\n",
       "0       255493     False  {'isrc': 'AUAP08000046'}   \n",
       "1       208400     False  {'isrc': 'AUAP07900028'}   \n",
       "2       292880     False  {'isrc': 'AUAP09000014'}   \n",
       "3       210173     False  {'isrc': 'AUAP08000047'}   \n",
       "4       214666     False  {'isrc': 'AUAP07600012'}   \n",
       "5       312293     False  {'isrc': 'AUAP08000041'}   \n",
       "6       231933     False  {'isrc': 'AUAP07600046'}   \n",
       "7       317426     False  {'isrc': 'AUAP08000042'}   \n",
       "8       301226     False  {'isrc': 'USEW17500002'}   \n",
       "9       261506     False  {'isrc': 'USSM10802975'}   \n",
       "\n",
       "                                       external_urls  \\\n",
       "0  {'spotify': 'https://open.spotify.com/track/08...   \n",
       "1  {'spotify': 'https://open.spotify.com/track/2z...   \n",
       "2  {'spotify': 'https://open.spotify.com/track/57...   \n",
       "3  {'spotify': 'https://open.spotify.com/track/2S...   \n",
       "4  {'spotify': 'https://open.spotify.com/track/7L...   \n",
       "5  {'spotify': 'https://open.spotify.com/track/69...   \n",
       "6  {'spotify': 'https://open.spotify.com/track/2d...   \n",
       "7  {'spotify': 'https://open.spotify.com/track/0C...   \n",
       "8  {'spotify': 'https://open.spotify.com/track/7n...   \n",
       "9  {'spotify': 'https://open.spotify.com/track/4f...   \n",
       "\n",
       "                                                href                      id  \\\n",
       "0  https://api.spotify.com/v1/tracks/08mG3Y1vljYA...  08mG3Y1vljYA6bvDt4Wqkj   \n",
       "1  https://api.spotify.com/v1/tracks/2zYzyRzz6pRm...  2zYzyRzz6pRmhPzyfMEC8s   \n",
       "2  https://api.spotify.com/v1/tracks/57bgtoPSgt23...  57bgtoPSgt236HzfBOd8kj   \n",
       "3  https://api.spotify.com/v1/tracks/2SiXAy7TuUky...  2SiXAy7TuUkycRVbbWDEpo   \n",
       "4  https://api.spotify.com/v1/tracks/7LRMbd3LEoV5...  7LRMbd3LEoV5wZJvXT1Lwb   \n",
       "5  https://api.spotify.com/v1/tracks/69QHm3pustz0...  69QHm3pustz01CJRwdo20z   \n",
       "6  https://api.spotify.com/v1/tracks/2d4e45fmUngu...  2d4e45fmUnguxh6yqC7gNT   \n",
       "7  https://api.spotify.com/v1/tracks/0C80GCp0mMuB...  0C80GCp0mMuBzLf3EAXqxv   \n",
       "8  https://api.spotify.com/v1/tracks/7nemcVsXVFZF...  7nemcVsXVFZF01iqpIIo2Y   \n",
       "9  https://api.spotify.com/v1/tracks/4feXJ5IC3avX...  4feXJ5IC3avXsVW9WNFSag   \n",
       "\n",
       "   is_local  is_playable                                               name  \\\n",
       "0     False         True                                      Back In Black   \n",
       "1     False         True                                    Highway to Hell   \n",
       "2     False         True                                      Thunderstruck   \n",
       "3     False         True                        You Shook Me All Night Long   \n",
       "4     False         True                                             T.N.T.   \n",
       "5     False         True                                        Hells Bells   \n",
       "6     False         True                        Dirty Deeds Done Dirt Cheap   \n",
       "7     False         True                                    Shoot to Thrill   \n",
       "8     False         True  It's a Long Way to the Top (If You Wanna Rock ...   \n",
       "9     False         True                                  Rock N Roll Train   \n",
       "\n",
       "   popularity                                        preview_url  \\\n",
       "0          85  https://p.scdn.co/mp3-preview/506bc9a048599097...   \n",
       "1          85  https://p.scdn.co/mp3-preview/db138a9742397601...   \n",
       "2          84  https://p.scdn.co/mp3-preview/df9f0326adc85339...   \n",
       "3          81  https://p.scdn.co/mp3-preview/2a200f628c41fadd...   \n",
       "4          79  https://p.scdn.co/mp3-preview/baea5e2b5a731532...   \n",
       "5          75  https://p.scdn.co/mp3-preview/63c396837c1738dd...   \n",
       "6          74  https://p.scdn.co/mp3-preview/e966a99df223f101...   \n",
       "7          74  https://p.scdn.co/mp3-preview/289d87e96d7e99b0...   \n",
       "8          72  https://p.scdn.co/mp3-preview/0637218420f50db9...   \n",
       "9          70  https://p.scdn.co/mp3-preview/eefd2f76a89e1c20...   \n",
       "\n",
       "   track_number   type                                   uri  \n",
       "0             6  track  spotify:track:08mG3Y1vljYA6bvDt4Wqkj  \n",
       "1             1  track  spotify:track:2zYzyRzz6pRmhPzyfMEC8s  \n",
       "2             1  track  spotify:track:57bgtoPSgt236HzfBOd8kj  \n",
       "3             7  track  spotify:track:2SiXAy7TuUkycRVbbWDEpo  \n",
       "4             5  track  spotify:track:7LRMbd3LEoV5wZJvXT1Lwb  \n",
       "5             1  track  spotify:track:69QHm3pustz01CJRwdo20z  \n",
       "6             1  track  spotify:track:2d4e45fmUnguxh6yqC7gNT  \n",
       "7             2  track  spotify:track:0C80GCp0mMuBzLf3EAXqxv  \n",
       "8             1  track  spotify:track:7nemcVsXVFZF01iqpIIo2Y  \n",
       "9             1  track  spotify:track:4feXJ5IC3avXsVW9WNFSag  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response2 = requests.get(base_url + resource + artist_id + top_tracks + country , headers=headers).json()\n",
    "response2\n",
    "df_top_tracks = pd.DataFrame(response2['tracks'])\n",
    "df_top_tracks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "92751d09",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['3qm84nBOXUEQ2vnTfUTTFC',\n",
       " '6urzdpGY5yUimWZsgJUoTb',\n",
       " '07XSN3sPlIlB2L2XNcTwJw',\n",
       " '3EhbVgyfGd7HkpsagwL9GS',\n",
       " '7Ey4PD4MYsKc5I2dolUwbH',\n",
       " '2tRsMl4eGxwoNabM08Dm4I',\n",
       " '27T030eWyCQRmDyuvr1kxY',\n",
       " '6ZLTlhejhndI4Rh53vYhrY',\n",
       " '4CYeVo5iZbtYGBN4Isc3n6',\n",
       " '568ZhdwyaiCyOGJRtNYhWf',\n",
       " '5M52tdBnJaKSvOpJGz8mfZ',\n",
       " '6mdiAmATAx73kdxrNrnlao',\n",
       " '0cc6vw3VN8YlIcvr1v7tBL',\n",
       " '7b85ve82Sh36a3UAx74wut',\n",
       " '2cnMpRsOVqtPMfq7YiFE6K',\n",
       " '1DFr97A9HnbV3SKTJFu62M',\n",
       " '2AM4ilv6UzW0uMRuqKtDgN',\n",
       " '1dLWg6m8RRhizsdqJbhyj3',\n",
       " '49DW3KvkyjHO35mK1JnSyS',\n",
       " '6SLAMfhOi7UJI0fMztaK0m']"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "related_artist_id =[]\n",
    "for i in df_related_artist['id']:\n",
    "    related_artist_id.append(i)\n",
    "    related_artist_top_tracks = requests.get(base_url + resource + i + top_tracks, headers=headers).json()\n",
    "related_artist_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3642cb32",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "93beaae0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:ironhack]",
   "language": "python",
   "name": "conda-env-ironhack-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}