Spotify_Data_Pipeline.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d48f7f1d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Defaulting to user installation because normal site-packages is not writeable\n",
      "Collecting spotipy\n",
      "  Downloading spotipy-2.23.0-py3-none-any.whl (29 kB)\n",
      "Requirement already satisfied: six>=1.15.0 in c:\\anaconda3\\lib\\site-packages (from spotipy) (1.16.0)\n",
      "Requirement already satisfied: requests>=2.25.0 in c:\\anaconda3\\lib\\site-packages (from spotipy) (2.28.1)\n",
      "Collecting redis>=3.5.3\n",
      "  Downloading redis-5.0.1-py3-none-any.whl (250 kB)\n",
      "     -------------------------------------- 250.3/250.3 kB 5.1 MB/s eta 0:00:00\n",
      "Requirement already satisfied: urllib3>=1.26.0 in c:\\anaconda3\\lib\\site-packages (from spotipy) (1.26.14)\n",
      "Collecting async-timeout>=4.0.2\n",
      "  Downloading async_timeout-4.0.3-py3-none-any.whl (5.7 kB)\n",
      "Requirement already satisfied: charset-normalizer<3,>=2 in c:\\anaconda3\\lib\\site-packages (from requests>=2.25.0->spotipy) (2.0.4)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\anaconda3\\lib\\site-packages (from requests>=2.25.0->spotipy) (2022.12.7)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\anaconda3\\lib\\site-packages (from requests>=2.25.0->spotipy) (3.4)\n",
      "Installing collected packages: async-timeout, redis, spotipy\n",
      "Successfully installed async-timeout-4.0.3 redis-5.0.1 spotipy-2.23.0\n"
     ]
    }
   ],
   "source": [
    "!pip install spotipy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4afdc6a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "19ad94fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Authentication\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id = \"\", client_secret=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6647742f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Authorization\n",
    "sp = spotipy.Spotify(client_credentials_manager = client_credentials_manager)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "05f0da6e",
   "metadata": {},
   "outputs": [],
   "source": [
    "playlist_link = \"https://open.spotify.com/playlist/37i9dQZEVXbNG2KDcFcKOF\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "192188fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "playlist_uri= playlist_link.split(\"/\")[-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "16b3ddae",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = sp.playlist_tracks(playlist_uri)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "170977b7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data['items'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "1fb052da",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'3UOV8XvCwMKaATRNXrYCjN'"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['album']['id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "b683a619",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'greedy'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['album']['name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "d8d1c81b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2023-09-15'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['album']['release_date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "bb58ba75",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['album']['total_tracks']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "a1d17adc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://open.spotify.com/album/3UOV8XvCwMKaATRNXrYCjN'"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['album']['external_urls']['spotify']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "80e77295",
   "metadata": {},
   "outputs": [],
   "source": [
    "album_list = []\n",
    "for row in data['items']:\n",
    "    album_id = row['track']['album']['id']\n",
    "    album_name = row['track']['album']['name']\n",
    "    album_release_date = row['track']['album']['release_date']\n",
    "    album_total_tracks = row['track']['album']['total_tracks']\n",
    "    album_url = row['track']['album']['external_urls']['spotify']\n",
    "    album_element = {'album_id': album_id, 'name': album_name, 'release_date': album_release_date,\n",
    "                    'total_tracks':album_total_tracks,'url' :album_url}\n",
    "    album_list.append(album_element)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "4de0ad2a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'album_id': '3UOV8XvCwMKaATRNXrYCjN',\n",
       "  'name': 'greedy',\n",
       "  'release_date': '2023-09-15',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/3UOV8XvCwMKaATRNXrYCjN'},\n",
       " {'album_id': '2IoSjweCu07y9mv5H1Cj3v',\n",
       "  'name': 'La Diabla',\n",
       "  'release_date': '2023-11-30',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/2IoSjweCu07y9mv5H1Cj3v'},\n",
       " {'album_id': '6VCO0fDBGbRW8mCEvV95af',\n",
       "  'name': 'Lovin On Me',\n",
       "  'release_date': '2023-11-10',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/6VCO0fDBGbRW8mCEvV95af'},\n",
       " {'album_id': '1NAmidJlEaVgA3MpcPFYGq',\n",
       "  'name': 'Lover',\n",
       "  'release_date': '2019-08-23',\n",
       "  'total_tracks': 18,\n",
       "  'url': 'https://open.spotify.com/album/1NAmidJlEaVgA3MpcPFYGq'},\n",
       " {'album_id': '2Cn1d2KgbkAqbZCJ1RzdkA',\n",
       "  'name': 'The Land Is Inhospitable and So Are We',\n",
       "  'release_date': '2023-09-15',\n",
       "  'total_tracks': 11,\n",
       "  'url': 'https://open.spotify.com/album/2Cn1d2KgbkAqbZCJ1RzdkA'},\n",
       " {'album_id': '7tzVd1fwkxsorytCBjEJkU',\n",
       "  'name': 'The Idol Episode 4 (Music from the HBO Original Series)',\n",
       "  'release_date': '2023-06-23',\n",
       "  'total_tracks': 3,\n",
       "  'url': 'https://open.spotify.com/album/7tzVd1fwkxsorytCBjEJkU'},\n",
       " {'album_id': '5pSk3c3wVwnb2arb6ohCPU',\n",
       "  'name': 'GOLDEN',\n",
       "  'release_date': '2023-11-03',\n",
       "  'total_tracks': 11,\n",
       "  'url': 'https://open.spotify.com/album/5pSk3c3wVwnb2arb6ohCPU'},\n",
       " {'album_id': '1bBez9PNvkJPW08bU7NYta',\n",
       "  'name': 'Scarlet',\n",
       "  'release_date': '2023-09-20',\n",
       "  'total_tracks': 15,\n",
       "  'url': 'https://open.spotify.com/album/1bBez9PNvkJPW08bU7NYta'},\n",
       " {'album_id': '30KJEN3ICjhYsZ1NgunRCr',\n",
       "  'name': 'La Víctima',\n",
       "  'release_date': '2023-08-17',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/30KJEN3ICjhYsZ1NgunRCr'},\n",
       " {'album_id': '3VLY9g3CAG1Y5r2eGVEaZ0',\n",
       "  'name': 'BELLAKEO',\n",
       "  'release_date': '2023-12-07',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/3VLY9g3CAG1Y5r2eGVEaZ0'},\n",
       " {'album_id': '50ZenUP4O2Q5eCy2NRNvuz',\n",
       "  'name': 'Stick Season',\n",
       "  'release_date': '2022-10-14',\n",
       "  'total_tracks': 14,\n",
       "  'url': 'https://open.spotify.com/album/50ZenUP4O2Q5eCy2NRNvuz'},\n",
       " {'album_id': '22sXXkKgjEuawIFL1e1tRw',\n",
       "  'name': 'Water',\n",
       "  'release_date': '2023-07-28',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/22sXXkKgjEuawIFL1e1tRw'},\n",
       " {'album_id': '18ogtNq9F7DmMkNYO6Xb4k',\n",
       "  'name': 'Strangers',\n",
       "  'release_date': '2023-09-01',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/18ogtNq9F7DmMkNYO6Xb4k'},\n",
       " {'album_id': '4FftCsAcXXD1nFO9RFUNFO',\n",
       "  'name': 'nadie sabe lo que va a pasar mañana',\n",
       "  'release_date': '2023-10-13',\n",
       "  'total_tracks': 22,\n",
       "  'url': 'https://open.spotify.com/album/4FftCsAcXXD1nFO9RFUNFO'},\n",
       " {'album_id': '0FqAaUEyKCyUNFE1uQPZ7i',\n",
       "  'name': 'MAÑANA SERÁ BONITO (BICHOTA SEASON)',\n",
       "  'release_date': '2023-08-10',\n",
       "  'total_tracks': 9,\n",
       "  'url': 'https://open.spotify.com/album/0FqAaUEyKCyUNFE1uQPZ7i'},\n",
       " {'album_id': '5pSk3c3wVwnb2arb6ohCPU',\n",
       "  'name': 'GOLDEN',\n",
       "  'release_date': '2023-11-03',\n",
       "  'total_tracks': 11,\n",
       "  'url': 'https://open.spotify.com/album/5pSk3c3wVwnb2arb6ohCPU'},\n",
       " {'album_id': '78bpIziExqiI9qztvNFlQu',\n",
       "  'name': 'AM',\n",
       "  'release_date': '2013-09-09',\n",
       "  'total_tracks': 12,\n",
       "  'url': 'https://open.spotify.com/album/78bpIziExqiI9qztvNFlQu'},\n",
       " {'album_id': '0lgs2Sa82lyX89nBUWyUy6',\n",
       "  'name': 'FERXXOCALIPSIS',\n",
       "  'release_date': '2023-12-01',\n",
       "  'total_tracks': 10,\n",
       "  'url': 'https://open.spotify.com/album/0lgs2Sa82lyX89nBUWyUy6'},\n",
       " {'album_id': '4x6cjOcVz44aiLSOHCLKPd',\n",
       "  'name': 'Que Onda',\n",
       "  'release_date': '2023-08-30',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/4x6cjOcVz44aiLSOHCLKPd'},\n",
       " {'album_id': '3zu0hJJew2qXZNlselIQk8',\n",
       "  'name': \"Pa las Baby's Y Belikeada\",\n",
       "  'release_date': '2023-10-20',\n",
       "  'total_tracks': 30,\n",
       "  'url': 'https://open.spotify.com/album/3zu0hJJew2qXZNlselIQk8'},\n",
       " {'album_id': '5O0zUvdnJr0RbWzLFneN2i',\n",
       "  'name': 'Popular (Music from the HBO Original Series)',\n",
       "  'release_date': '2023-06-02',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/5O0zUvdnJr0RbWzLFneN2i'},\n",
       " {'album_id': '66k6EGkPtYoN44anGIsEPW',\n",
       "  'name': 'Si No Estás',\n",
       "  'release_date': '2022-09-23',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/66k6EGkPtYoN44anGIsEPW'},\n",
       " {'album_id': '1xJHno7SmdVtZAtXbdbDZp',\n",
       "  'name': 'GUTS',\n",
       "  'release_date': '2023-09-08',\n",
       "  'total_tracks': 12,\n",
       "  'url': 'https://open.spotify.com/album/1xJHno7SmdVtZAtXbdbDZp'},\n",
       " {'album_id': '1bBez9PNvkJPW08bU7NYta',\n",
       "  'name': 'Scarlet',\n",
       "  'release_date': '2023-09-20',\n",
       "  'total_tracks': 15,\n",
       "  'url': 'https://open.spotify.com/album/1bBez9PNvkJPW08bU7NYta'},\n",
       " {'album_id': '5r36AJ6VOJtp00oxSkBZ5h',\n",
       "  'name': \"Harry's House\",\n",
       "  'release_date': '2022-05-20',\n",
       "  'total_tracks': 13,\n",
       "  'url': 'https://open.spotify.com/album/5r36AJ6VOJtp00oxSkBZ5h'},\n",
       " {'album_id': '2ODvWsOgouMbaA5xf0RkJe',\n",
       "  'name': 'Starboy',\n",
       "  'release_date': '2016-11-25',\n",
       "  'total_tracks': 18,\n",
       "  'url': 'https://open.spotify.com/album/2ODvWsOgouMbaA5xf0RkJe'},\n",
       " {'album_id': '1nrVofqDRs7cpWXJ49qTnP',\n",
       "  'name': 'SOS',\n",
       "  'release_date': '2022-12-08',\n",
       "  'total_tracks': 23,\n",
       "  'url': 'https://open.spotify.com/album/1nrVofqDRs7cpWXJ49qTnP'},\n",
       " {'album_id': '5cH7FqB7JD5q1tJXJ7FHYu',\n",
       "  'name': 'Dance The Night (From Barbie The Album)',\n",
       "  'release_date': '2023-05-25',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/5cH7FqB7JD5q1tJXJ7FHYu'},\n",
       " {'album_id': '6NcI39WPu4kY6Tul11nhSv',\n",
       "  'name': 'Daylight',\n",
       "  'release_date': '2023-04-14',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/6NcI39WPu4kY6Tul11nhSv'},\n",
       " {'album_id': '5DvJgsMLbaR1HmAI6VhfcQ',\n",
       "  'name': 'Endless Summer Vacation',\n",
       "  'release_date': '2023-08-18',\n",
       "  'total_tracks': 14,\n",
       "  'url': 'https://open.spotify.com/album/5DvJgsMLbaR1HmAI6VhfcQ'},\n",
       " {'album_id': '3Fk8yQvPlCHgwR2pNhEIRA',\n",
       "  'name': 'Don Juan',\n",
       "  'release_date': '2023-08-25',\n",
       "  'total_tracks': 25,\n",
       "  'url': 'https://open.spotify.com/album/3Fk8yQvPlCHgwR2pNhEIRA'},\n",
       " {'album_id': '5MU0RmBSpoSxOPYBfcobDc',\n",
       "  'name': 'Prada',\n",
       "  'release_date': '2023-08-11',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/5MU0RmBSpoSxOPYBfcobDc'},\n",
       " {'album_id': '3AafSrFIbJPH6BJHiJm1Cd',\n",
       "  'name': 'What Was I Made For? [From The Motion Picture \"Barbie\"]',\n",
       "  'release_date': '2023-07-13',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/3AafSrFIbJPH6BJHiJm1Cd'},\n",
       " {'album_id': '4FftCsAcXXD1nFO9RFUNFO',\n",
       "  'name': 'nadie sabe lo que va a pasar mañana',\n",
       "  'release_date': '2023-10-13',\n",
       "  'total_tracks': 22,\n",
       "  'url': 'https://open.spotify.com/album/4FftCsAcXXD1nFO9RFUNFO'},\n",
       " {'album_id': '5pTaRVLwZOFObIbRBubmeb',\n",
       "  'name': 'Houdini',\n",
       "  'release_date': '2023-11-09',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/5pTaRVLwZOFObIbRBubmeb'},\n",
       " {'album_id': '4rJDCELWL0fjdmN9Gn4f4g',\n",
       "  'name': 'The Forever Story (Extended Version)',\n",
       "  'release_date': '2022-10-31',\n",
       "  'total_tracks': 16,\n",
       "  'url': 'https://open.spotify.com/album/4rJDCELWL0fjdmN9Gn4f4g'},\n",
       " {'album_id': '4yP0hdKOZPNshxUOjY0cZj',\n",
       "  'name': 'After Hours',\n",
       "  'release_date': '2020-03-20',\n",
       "  'total_tracks': 14,\n",
       "  'url': 'https://open.spotify.com/album/4yP0hdKOZPNshxUOjY0cZj'},\n",
       " {'album_id': '3qmauw54W5zniG20b5q4iJ',\n",
       "  'name': 'Rompe La Dompe',\n",
       "  'release_date': '2023-12-28',\n",
       "  'total_tracks': 1,\n",
       "  'url': 'https://open.spotify.com/album/3qmauw54W5zniG20b5q4iJ'},\n",
       " {'album_id': '3puAvurwvtvi1rodndIPW8',\n",
       "  'name': 'LA VIDA ES UNA',\n",
       "  'release_date': '2023-03-23',\n",
       "  'total_tracks': 23,\n",
       "  'url': 'https://open.spotify.com/album/3puAvurwvtvi1rodndIPW8'},\n",
       " {'album_id': '7M842DMhYVALrXsw3ty7B3',\n",
       "  'name': \"I'm Good (Blue)\",\n",
       "  'release_date': '2022-08-26',\n",
       "  'total_tracks': 2,\n",
       "  'url': 'https://open.spotify.com/album/7M842DMhYVALrXsw3ty7B3'},\n",
       " {'album_id': '6PbnGueEO6LGodPfvNldYf',\n",
       "  'name': 'Zach Bryan',\n",
       "  'release_date': '2023-08-25',\n",
       "  'total_tracks': 16,\n",
       "  'url': 'https://open.spotify.com/album/6PbnGueEO6LGodPfvNldYf'},\n",
       " {'album_id': '0fJ0beklzFwoBv01U8792s',\n",
       "  'name': '3D : The Remixes',\n",
       "  'release_date': '2023-10-02',\n",
       "  'total_tracks': 7,\n",
       "  'url': 'https://open.spotify.com/album/0fJ0beklzFwoBv01U8792s'},\n",
       " {'album_id': '4jox3ip1I39DFC2B7R5qLH',\n",
       "  'name': 'GÉNESIS',\n",
       "  'release_date': '2023-06-29',\n",
       "  'total_tracks': 17,\n",
       "  'url': 'https://open.spotify.com/album/4jox3ip1I39DFC2B7R5qLH'},\n",
       " {'album_id': '3yoNZlqerJnsnMN5EDwwBS',\n",
       "  'name': 'Strange Trails',\n",
       "  'release_date': '2015-04-07',\n",
       "  'total_tracks': 14,\n",
       "  'url': 'https://open.spotify.com/album/3yoNZlqerJnsnMN5EDwwBS'},\n",
       " {'album_id': '07w0rG5TETcyihsEIZR3qG',\n",
       "  'name': 'SOS',\n",
       "  'release_date': '2022-12-09',\n",
       "  'total_tracks': 23,\n",
       "  'url': 'https://open.spotify.com/album/07w0rG5TETcyihsEIZR3qG'},\n",
       " {'album_id': '4AdZV63ycxFLF6Hcol0QnB',\n",
       "  'name': 'Starboy',\n",
       "  'release_date': '2016-11-24',\n",
       "  'total_tracks': 18,\n",
       "  'url': 'https://open.spotify.com/album/4AdZV63ycxFLF6Hcol0QnB'},\n",
       " {'album_id': '5i9lMMUZ1QZNsLEE3j50kT',\n",
       "  'name': 'El Comienzo',\n",
       "  'release_date': '2023-08-25',\n",
       "  'total_tracks': 12,\n",
       "  'url': 'https://open.spotify.com/album/5i9lMMUZ1QZNsLEE3j50kT'},\n",
       " {'album_id': '1ZBDI1LqnuAKdrePUF2D5m',\n",
       "  'name': 'Layover',\n",
       "  'release_date': '2023-08-11',\n",
       "  'total_tracks': 2,\n",
       "  'url': 'https://open.spotify.com/album/1ZBDI1LqnuAKdrePUF2D5m'},\n",
       " {'album_id': '5qmZefgh78fN3jsyPPlvuw',\n",
       "  'name': 'a Gift & a Curse',\n",
       "  'release_date': '2023-06-16',\n",
       "  'total_tracks': 15,\n",
       "  'url': 'https://open.spotify.com/album/5qmZefgh78fN3jsyPPlvuw'},\n",
       " {'album_id': '0nayxjaX54Frd7GsZq6Pbs',\n",
       "  'name': 'Rave & Roses Ultra',\n",
       "  'release_date': '2023-04-27',\n",
       "  'total_tracks': 22,\n",
       "  'url': 'https://open.spotify.com/album/0nayxjaX54Frd7GsZq6Pbs'}]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "album_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "26f7aa3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'45dkTj5sMRSjrmBSBeiHym'"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['items'][0]['track']['artists'][0]['id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "8134f016",
   "metadata": {},
   "outputs": [],
   "source": [
    "artist_list = []\n",
    "for row in data['items']:\n",
    "    for key,value in row.items():\n",
    "        if key == \"track\":\n",
    "            for artist in value['artists']:\n",
    "                artist_dict = {'artist_id':artist['id'],'artist_name':artist['name'],'external_url':artist['href']}\n",
    "                artist_list.append(artist_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "49b988b9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'artist_id': '45dkTj5sMRSjrmBSBeiHym',\n",
       "  'artist_name': 'Tate McRae',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/45dkTj5sMRSjrmBSBeiHym'},\n",
       " {'artist_id': '3Me35AWHCGqW4sZ7bWWJt1',\n",
       "  'artist_name': 'Xavi',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3Me35AWHCGqW4sZ7bWWJt1'},\n",
       " {'artist_id': '2LIk90788K0zvyj2JJVwkJ',\n",
       "  'artist_name': 'Jack Harlow',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2LIk90788K0zvyj2JJVwkJ'},\n",
       " {'artist_id': '06HL4z0CvFAxyc27GXpf02',\n",
       "  'artist_name': 'Taylor Swift',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/06HL4z0CvFAxyc27GXpf02'},\n",
       " {'artist_id': '2uYWxilOVlUdk4oV9DvwqK',\n",
       "  'artist_name': 'Mitski',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2uYWxilOVlUdk4oV9DvwqK'},\n",
       " {'artist_id': '1Xyo4u8uXC1ZmMpatF05PJ',\n",
       "  'artist_name': 'The Weeknd',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ'},\n",
       " {'artist_id': '250b0Wlc5Vk0CoUsaCY84M',\n",
       "  'artist_name': 'JENNIE',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/250b0Wlc5Vk0CoUsaCY84M'},\n",
       " {'artist_id': '1pBLC0qVRTB5zVMuteQ9jJ',\n",
       "  'artist_name': 'Lily-Rose Depp',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1pBLC0qVRTB5zVMuteQ9jJ'},\n",
       " {'artist_id': '6HaGTQPmzraVmaVxvz6EUc',\n",
       "  'artist_name': 'Jung Kook',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6HaGTQPmzraVmaVxvz6EUc'},\n",
       " {'artist_id': '3MdXrJWsbVzdn6fe5JYkSQ',\n",
       "  'artist_name': 'Latto',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3MdXrJWsbVzdn6fe5JYkSQ'},\n",
       " {'artist_id': '5cj0lLjcoR7YOSnhnX0Po5',\n",
       "  'artist_name': 'Doja Cat',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5cj0lLjcoR7YOSnhnX0Po5'},\n",
       " {'artist_id': '3Me35AWHCGqW4sZ7bWWJt1',\n",
       "  'artist_name': 'Xavi',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3Me35AWHCGqW4sZ7bWWJt1'},\n",
       " {'artist_id': '12GqGscKJx3aE4t07u7eVZ',\n",
       "  'artist_name': 'Peso Pluma',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/12GqGscKJx3aE4t07u7eVZ'},\n",
       " {'artist_id': '7FNnA9vBm6EKceENgCGRMb',\n",
       "  'artist_name': 'Anitta',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7FNnA9vBm6EKceENgCGRMb'},\n",
       " {'artist_id': '2RQXRUsr4IW1f3mKyKsy4B',\n",
       "  'artist_name': 'Noah Kahan',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2RQXRUsr4IW1f3mKyKsy4B'},\n",
       " {'artist_id': '3SozjO3Lat463tQICI9LcE',\n",
       "  'artist_name': 'Tyla',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3SozjO3Lat463tQICI9LcE'},\n",
       " {'artist_id': '7uMDnSZyUYNBPLhPMNuaM2',\n",
       "  'artist_name': 'Kenya Grace',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7uMDnSZyUYNBPLhPMNuaM2'},\n",
       " {'artist_id': '4q3ewBCX7sLwd24euuV69X',\n",
       "  'artist_name': 'Bad Bunny',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/4q3ewBCX7sLwd24euuV69X'},\n",
       " {'artist_id': '2LRoIwlKmHjgvigdNGBHNo',\n",
       "  'artist_name': 'Feid',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2LRoIwlKmHjgvigdNGBHNo'},\n",
       " {'artist_id': '790FomKkXshlbRYZFtlgla',\n",
       "  'artist_name': 'KAROL G',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/790FomKkXshlbRYZFtlgla'},\n",
       " {'artist_id': '12GqGscKJx3aE4t07u7eVZ',\n",
       "  'artist_name': 'Peso Pluma',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/12GqGscKJx3aE4t07u7eVZ'},\n",
       " {'artist_id': '6HaGTQPmzraVmaVxvz6EUc',\n",
       "  'artist_name': 'Jung Kook',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6HaGTQPmzraVmaVxvz6EUc'},\n",
       " {'artist_id': '7Ln80lUS6He07XvHI8qqHH',\n",
       "  'artist_name': 'Arctic Monkeys',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7Ln80lUS6He07XvHI8qqHH'},\n",
       " {'artist_id': '2LRoIwlKmHjgvigdNGBHNo',\n",
       "  'artist_name': 'Feid',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2LRoIwlKmHjgvigdNGBHNo'},\n",
       " {'artist_id': '7jAs1uPnpfNmT6e5qtEPxq',\n",
       "  'artist_name': 'ATL Jacob',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7jAs1uPnpfNmT6e5qtEPxq'},\n",
       " {'artist_id': '6dLuQ5qXxIuWc5urxfIiZR',\n",
       "  'artist_name': 'Calle 24',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6dLuQ5qXxIuWc5urxfIiZR'},\n",
       " {'artist_id': '2rmkQLzj0k4nZdQehOUByO',\n",
       "  'artist_name': 'Chino Pacas',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2rmkQLzj0k4nZdQehOUByO'},\n",
       " {'artist_id': '0ys2OFYzWYB5hRDLCsBqxt',\n",
       "  'artist_name': 'Fuerza Regida',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/0ys2OFYzWYB5hRDLCsBqxt'},\n",
       " {'artist_id': '0ys2OFYzWYB5hRDLCsBqxt',\n",
       "  'artist_name': 'Fuerza Regida',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/0ys2OFYzWYB5hRDLCsBqxt'},\n",
       " {'artist_id': '64KEffDW9EtZ1y2vBYgq8T',\n",
       "  'artist_name': 'Marshmello',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/64KEffDW9EtZ1y2vBYgq8T'},\n",
       " {'artist_id': '1Xyo4u8uXC1ZmMpatF05PJ',\n",
       "  'artist_name': 'The Weeknd',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ'},\n",
       " {'artist_id': '699OTQXzgjhIYAHMy9RyPD',\n",
       "  'artist_name': 'Playboi Carti',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/699OTQXzgjhIYAHMy9RyPD'},\n",
       " {'artist_id': '6tbjWDEIzxoDsBA1FuhfPW',\n",
       "  'artist_name': 'Madonna',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6tbjWDEIzxoDsBA1FuhfPW'},\n",
       " {'artist_id': '0jbo7KFNMiIkfBR6ih0yhm',\n",
       "  'artist_name': 'iñigo quintero',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/0jbo7KFNMiIkfBR6ih0yhm'},\n",
       " {'artist_id': '1McMsnEElThX1knmY4oliG',\n",
       "  'artist_name': 'Olivia Rodrigo',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1McMsnEElThX1knmY4oliG'},\n",
       " {'artist_id': '5cj0lLjcoR7YOSnhnX0Po5',\n",
       "  'artist_name': 'Doja Cat',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5cj0lLjcoR7YOSnhnX0Po5'},\n",
       " {'artist_id': '6KImCVD70vtIoJWnq6nGn3',\n",
       "  'artist_name': 'Harry Styles',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6KImCVD70vtIoJWnq6nGn3'},\n",
       " {'artist_id': '1Xyo4u8uXC1ZmMpatF05PJ',\n",
       "  'artist_name': 'The Weeknd',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ'},\n",
       " {'artist_id': '4tZwfgrHOc3mvqYlEYSvVi',\n",
       "  'artist_name': 'Daft Punk',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/4tZwfgrHOc3mvqYlEYSvVi'},\n",
       " {'artist_id': '7tYKF4w9nC0nq9CsPZTHyP',\n",
       "  'artist_name': 'SZA',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7tYKF4w9nC0nq9CsPZTHyP'},\n",
       " {'artist_id': '6M2wZ9GZgrQXHCFfjv46we',\n",
       "  'artist_name': 'Dua Lipa',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6M2wZ9GZgrQXHCFfjv46we'},\n",
       " {'artist_id': '33NVpKoXjItPwUJTMZIOiY',\n",
       "  'artist_name': 'David Kushner',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/33NVpKoXjItPwUJTMZIOiY'},\n",
       " {'artist_id': '5YGY8feqx7naU7z4HrwZM6',\n",
       "  'artist_name': 'Miley Cyrus',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5YGY8feqx7naU7z4HrwZM6'},\n",
       " {'artist_id': '1r4hJ1h58CWwUQe3MxPuau',\n",
       "  'artist_name': 'Maluma',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1r4hJ1h58CWwUQe3MxPuau'},\n",
       " {'artist_id': '66ihevNkSYNzRAl44dx6jJ',\n",
       "  'artist_name': 'Carin Leon',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/66ihevNkSYNzRAl44dx6jJ'},\n",
       " {'artist_id': '5wCmhq5J2hPwL2r0eKurxn',\n",
       "  'artist_name': 'cassö',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5wCmhq5J2hPwL2r0eKurxn'},\n",
       " {'artist_id': '5KKpBU5eC2tJDzf0wmlRp2',\n",
       "  'artist_name': 'RAYE',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5KKpBU5eC2tJDzf0wmlRp2'},\n",
       " {'artist_id': '5VadK1havLhK1OpKYsXv9y',\n",
       "  'artist_name': 'D-Block Europe',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/5VadK1havLhK1OpKYsXv9y'},\n",
       " {'artist_id': '6qqNVTkY8uBg9cP3Jd7DAH',\n",
       "  'artist_name': 'Billie Eilish',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6qqNVTkY8uBg9cP3Jd7DAH'},\n",
       " {'artist_id': '4q3ewBCX7sLwd24euuV69X',\n",
       "  'artist_name': 'Bad Bunny',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/4q3ewBCX7sLwd24euuV69X'},\n",
       " {'artist_id': '6M2wZ9GZgrQXHCFfjv46we',\n",
       "  'artist_name': 'Dua Lipa',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6M2wZ9GZgrQXHCFfjv46we'},\n",
       " {'artist_id': '6U3ybJ9UHNKEdsH7ktGBZ7',\n",
       "  'artist_name': 'JID',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6U3ybJ9UHNKEdsH7ktGBZ7'},\n",
       " {'artist_id': '1URnnhqYAYcrqrcwql10ft',\n",
       "  'artist_name': '21 Savage',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1URnnhqYAYcrqrcwql10ft'},\n",
       " {'artist_id': '3IJ21966TwNZI24MwZHMu4',\n",
       "  'artist_name': 'Baby Tate',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3IJ21966TwNZI24MwZHMu4'},\n",
       " {'artist_id': '1Xyo4u8uXC1ZmMpatF05PJ',\n",
       "  'artist_name': 'The Weeknd',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ'},\n",
       " {'artist_id': '12GqGscKJx3aE4t07u7eVZ',\n",
       "  'artist_name': 'Peso Pluma',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/12GqGscKJx3aE4t07u7eVZ'},\n",
       " {'artist_id': '7Gi6gjaWy3DxyilpF1a8Is',\n",
       "  'artist_name': 'Junior H',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7Gi6gjaWy3DxyilpF1a8Is'},\n",
       " {'artist_id': '3l9G1G9MxH6DaRhwLklaf5',\n",
       "  'artist_name': 'Oscar Maydon',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3l9G1G9MxH6DaRhwLklaf5'},\n",
       " {'artist_id': '7iK8PXO48WeuP03g8YR51W',\n",
       "  'artist_name': 'Myke Towers',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7iK8PXO48WeuP03g8YR51W'},\n",
       " {'artist_id': '1Cs0zKBU1kc0i8ypK3B9ai',\n",
       "  'artist_name': 'David Guetta',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Cs0zKBU1kc0i8ypK3B9ai'},\n",
       " {'artist_id': '64M6ah0SkkRsnPGtGiRAbb',\n",
       "  'artist_name': 'Bebe Rexha',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/64M6ah0SkkRsnPGtGiRAbb'},\n",
       " {'artist_id': '40ZNYROS4zLfyyBSs2PGe2',\n",
       "  'artist_name': 'Zach Bryan',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/40ZNYROS4zLfyyBSs2PGe2'},\n",
       " {'artist_id': '70kkdajctXSbqSMJbQO424',\n",
       "  'artist_name': 'Kacey Musgraves',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/70kkdajctXSbqSMJbQO424'},\n",
       " {'artist_id': '6HaGTQPmzraVmaVxvz6EUc',\n",
       "  'artist_name': 'Jung Kook',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6HaGTQPmzraVmaVxvz6EUc'},\n",
       " {'artist_id': '2LIk90788K0zvyj2JJVwkJ',\n",
       "  'artist_name': 'Jack Harlow',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2LIk90788K0zvyj2JJVwkJ'},\n",
       " {'artist_id': '12GqGscKJx3aE4t07u7eVZ',\n",
       "  'artist_name': 'Peso Pluma',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/12GqGscKJx3aE4t07u7eVZ'},\n",
       " {'artist_id': '6Sbl0NT50roqWvy746MfVf',\n",
       "  'artist_name': 'Gabito Ballesteros',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6Sbl0NT50roqWvy746MfVf'},\n",
       " {'artist_id': '7Gi6gjaWy3DxyilpF1a8Is',\n",
       "  'artist_name': 'Junior H',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7Gi6gjaWy3DxyilpF1a8Is'},\n",
       " {'artist_id': '6ltzsmQQbmdoHHbLZ4ZN25',\n",
       "  'artist_name': 'Lord Huron',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6ltzsmQQbmdoHHbLZ4ZN25'},\n",
       " {'artist_id': '7tYKF4w9nC0nq9CsPZTHyP',\n",
       "  'artist_name': 'SZA',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/7tYKF4w9nC0nq9CsPZTHyP'},\n",
       " {'artist_id': '1Xyo4u8uXC1ZmMpatF05PJ',\n",
       "  'artist_name': 'The Weeknd',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ'},\n",
       " {'artist_id': '6XkjpgcEsYab502Vr1bBeW',\n",
       "  'artist_name': 'Grupo Frontera',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/6XkjpgcEsYab502Vr1bBeW'},\n",
       " {'artist_id': '1dKdetem2xEmjgvyymzytS',\n",
       "  'artist_name': 'Grupo Firme',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/1dKdetem2xEmjgvyymzytS'},\n",
       " {'artist_id': '3JsHnjpbhX4SnySpvpa9DK',\n",
       "  'artist_name': 'V',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/3JsHnjpbhX4SnySpvpa9DK'},\n",
       " {'artist_id': '2hlmm7s2ICUX0LVIhVFlZQ',\n",
       "  'artist_name': 'Gunna',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/2hlmm7s2ICUX0LVIhVFlZQ'},\n",
       " {'artist_id': '46pWGuE3dSwY3bMMXGBvVS',\n",
       "  'artist_name': 'Rema',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/46pWGuE3dSwY3bMMXGBvVS'},\n",
       " {'artist_id': '0C8ZW7ezQVs4URX5aX7Kqx',\n",
       "  'artist_name': 'Selena Gomez',\n",
       "  'external_url': 'https://api.spotify.com/v1/artists/0C8ZW7ezQVs4URX5aX7Kqx'}]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "artist_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "5e854993",
   "metadata": {},
   "outputs": [],
   "source": [
    "song_list = []\n",
    "for row in data['items']:\n",
    "    song_id = row['track']['id']\n",
    "    song_name = row['track']['name']\n",
    "    song_duration = row['track']['duration_ms']\n",
    "    song_url = row['track']['external_urls']['spotify']\n",
    "    song_popularity = row['track']['popularity']\n",
    "    song_added = row['added_at']\n",
    "    album_id = row['track']['album']['id']\n",
    "    artist_id = row['track']['album']['artists'][0]['id']\n",
    "    song_element = {'song_id':song_id,'song_name':song_name,'duration_ms':song_duration,'url':song_url,\n",
    "                    'popularity':song_popularity,'song_added':song_added,'album_id':album_id,\n",
    "                    'artist_id':artist_id\n",
    "                   }\n",
    "    song_list.append(song_element)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "c5229f30",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "album_df = pd.DataFrame.from_dict(album_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "3d87325c",
   "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_id</th>\n",
       "      <th>name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>total_tracks</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3UOV8XvCwMKaATRNXrYCjN</td>\n",
       "      <td>greedy</td>\n",
       "      <td>2023-09-15</td>\n",
       "      <td>1</td>\n",
       "      <td>https://open.spotify.com/album/3UOV8XvCwMKaATR...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2IoSjweCu07y9mv5H1Cj3v</td>\n",
       "      <td>La Diabla</td>\n",
       "      <td>2023-11-30</td>\n",
       "      <td>1</td>\n",
       "      <td>https://open.spotify.com/album/2IoSjweCu07y9mv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6VCO0fDBGbRW8mCEvV95af</td>\n",
       "      <td>Lovin On Me</td>\n",
       "      <td>2023-11-10</td>\n",
       "      <td>1</td>\n",
       "      <td>https://open.spotify.com/album/6VCO0fDBGbRW8mC...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1NAmidJlEaVgA3MpcPFYGq</td>\n",
       "      <td>Lover</td>\n",
       "      <td>2019-08-23</td>\n",
       "      <td>18</td>\n",
       "      <td>https://open.spotify.com/album/1NAmidJlEaVgA3M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2Cn1d2KgbkAqbZCJ1RzdkA</td>\n",
       "      <td>The Land Is Inhospitable and So Are We</td>\n",
       "      <td>2023-09-15</td>\n",
       "      <td>11</td>\n",
       "      <td>https://open.spotify.com/album/2Cn1d2KgbkAqbZC...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 album_id                                    name   \n",
       "0  3UOV8XvCwMKaATRNXrYCjN                                  greedy  \\\n",
       "1  2IoSjweCu07y9mv5H1Cj3v                               La Diabla   \n",
       "2  6VCO0fDBGbRW8mCEvV95af                             Lovin On Me   \n",
       "3  1NAmidJlEaVgA3MpcPFYGq                                   Lover   \n",
       "4  2Cn1d2KgbkAqbZCJ1RzdkA  The Land Is Inhospitable and So Are We   \n",
       "\n",
       "  release_date  total_tracks   \n",
       "0   2023-09-15             1  \\\n",
       "1   2023-11-30             1   \n",
       "2   2023-11-10             1   \n",
       "3   2019-08-23            18   \n",
       "4   2023-09-15            11   \n",
       "\n",
       "                                                 url  \n",
       "0  https://open.spotify.com/album/3UOV8XvCwMKaATR...  \n",
       "1  https://open.spotify.com/album/2IoSjweCu07y9mv...  \n",
       "2  https://open.spotify.com/album/6VCO0fDBGbRW8mC...  \n",
       "3  https://open.spotify.com/album/1NAmidJlEaVgA3M...  \n",
       "4  https://open.spotify.com/album/2Cn1d2KgbkAqbZC...  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "album_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "55e254fa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50 entries, 0 to 49\n",
      "Data columns (total 5 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   album_id      50 non-null     object\n",
      " 1   name          50 non-null     object\n",
      " 2   release_date  50 non-null     object\n",
      " 3   total_tracks  50 non-null     int64 \n",
      " 4   url           50 non-null     object\n",
      "dtypes: int64(1), object(4)\n",
      "memory usage: 2.1+ KB\n"
     ]
    }
   ],
   "source": [
    "album_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "7287f430",
   "metadata": {},
   "outputs": [],
   "source": [
    "album_df = album_df.drop_duplicates(subset=['album_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "d5a98763",
   "metadata": {},
   "outputs": [],
   "source": [
    "artist_df = pd.DataFrame.from_dict(artist_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "bf7a8268",
   "metadata": {},
   "outputs": [],
   "source": [
    "artist_df = artist_df.drop_duplicates(subset=['artist_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "ef891de5",
   "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>artist_id</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>external_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45dkTj5sMRSjrmBSBeiHym</td>\n",
       "      <td>Tate McRae</td>\n",
       "      <td>https://api.spotify.com/v1/artists/45dkTj5sMRS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3Me35AWHCGqW4sZ7bWWJt1</td>\n",
       "      <td>Xavi</td>\n",
       "      <td>https://api.spotify.com/v1/artists/3Me35AWHCGq...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2LIk90788K0zvyj2JJVwkJ</td>\n",
       "      <td>Jack Harlow</td>\n",
       "      <td>https://api.spotify.com/v1/artists/2LIk90788K0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>06HL4z0CvFAxyc27GXpf02</td>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>https://api.spotify.com/v1/artists/06HL4z0CvFA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2uYWxilOVlUdk4oV9DvwqK</td>\n",
       "      <td>Mitski</td>\n",
       "      <td>https://api.spotify.com/v1/artists/2uYWxilOVlU...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                artist_id   artist_name   \n",
       "0  45dkTj5sMRSjrmBSBeiHym    Tate McRae  \\\n",
       "1  3Me35AWHCGqW4sZ7bWWJt1          Xavi   \n",
       "2  2LIk90788K0zvyj2JJVwkJ   Jack Harlow   \n",
       "3  06HL4z0CvFAxyc27GXpf02  Taylor Swift   \n",
       "4  2uYWxilOVlUdk4oV9DvwqK        Mitski   \n",
       "\n",
       "                                        external_url  \n",
       "0  https://api.spotify.com/v1/artists/45dkTj5sMRS...  \n",
       "1  https://api.spotify.com/v1/artists/3Me35AWHCGq...  \n",
       "2  https://api.spotify.com/v1/artists/2LIk90788K0...  \n",
       "3  https://api.spotify.com/v1/artists/06HL4z0CvFA...  \n",
       "4  https://api.spotify.com/v1/artists/2uYWxilOVlU...  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "artist_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "1d6b1fc7",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Song Dataframe\n",
    "song_df = pd.DataFrame.from_dict(song_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "3dbddbe1",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>url</th>\n",
       "      <th>popularity</th>\n",
       "      <th>song_added</th>\n",
       "      <th>album_id</th>\n",
       "      <th>artist_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3rUGC1vUpkDG9CZFHMur1t</td>\n",
       "      <td>greedy</td>\n",
       "      <td>131872</td>\n",
       "      <td>https://open.spotify.com/track/3rUGC1vUpkDG9CZ...</td>\n",
       "      <td>99</td>\n",
       "      <td>2024-01-05T11:50:35Z</td>\n",
       "      <td>3UOV8XvCwMKaATRNXrYCjN</td>\n",
       "      <td>45dkTj5sMRSjrmBSBeiHym</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0R6NfOiLzLj4O5VbYSJAjf</td>\n",
       "      <td>La Diabla</td>\n",
       "      <td>172264</td>\n",
       "      <td>https://open.spotify.com/track/0R6NfOiLzLj4O5V...</td>\n",
       "      <td>95</td>\n",
       "      <td>2024-01-05T11:50:35Z</td>\n",
       "      <td>2IoSjweCu07y9mv5H1Cj3v</td>\n",
       "      <td>3Me35AWHCGqW4sZ7bWWJt1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4xhsWYTOGcal8zt0J161CU</td>\n",
       "      <td>Lovin On Me</td>\n",
       "      <td>138411</td>\n",
       "      <td>https://open.spotify.com/track/4xhsWYTOGcal8zt...</td>\n",
       "      <td>98</td>\n",
       "      <td>2024-01-05T11:50:35Z</td>\n",
       "      <td>6VCO0fDBGbRW8mCEvV95af</td>\n",
       "      <td>2LIk90788K0zvyj2JJVwkJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1BxfuPKGuaTgP7aM0Bbdwr</td>\n",
       "      <td>Cruel Summer</td>\n",
       "      <td>178426</td>\n",
       "      <td>https://open.spotify.com/track/1BxfuPKGuaTgP7a...</td>\n",
       "      <td>98</td>\n",
       "      <td>2024-01-05T11:50:35Z</td>\n",
       "      <td>1NAmidJlEaVgA3MpcPFYGq</td>\n",
       "      <td>06HL4z0CvFAxyc27GXpf02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3vkCueOmm7xQDoJ17W1Pm3</td>\n",
       "      <td>My Love Mine All Mine</td>\n",
       "      <td>137773</td>\n",
       "      <td>https://open.spotify.com/track/3vkCueOmm7xQDoJ...</td>\n",
       "      <td>98</td>\n",
       "      <td>2024-01-05T11:50:35Z</td>\n",
       "      <td>2Cn1d2KgbkAqbZCJ1RzdkA</td>\n",
       "      <td>2uYWxilOVlUdk4oV9DvwqK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  song_id              song_name  duration_ms   \n",
       "0  3rUGC1vUpkDG9CZFHMur1t                 greedy       131872  \\\n",
       "1  0R6NfOiLzLj4O5VbYSJAjf              La Diabla       172264   \n",
       "2  4xhsWYTOGcal8zt0J161CU            Lovin On Me       138411   \n",
       "3  1BxfuPKGuaTgP7aM0Bbdwr           Cruel Summer       178426   \n",
       "4  3vkCueOmm7xQDoJ17W1Pm3  My Love Mine All Mine       137773   \n",
       "\n",
       "                                                 url  popularity   \n",
       "0  https://open.spotify.com/track/3rUGC1vUpkDG9CZ...          99  \\\n",
       "1  https://open.spotify.com/track/0R6NfOiLzLj4O5V...          95   \n",
       "2  https://open.spotify.com/track/4xhsWYTOGcal8zt...          98   \n",
       "3  https://open.spotify.com/track/1BxfuPKGuaTgP7a...          98   \n",
       "4  https://open.spotify.com/track/3vkCueOmm7xQDoJ...          98   \n",
       "\n",
       "             song_added                album_id               artist_id  \n",
       "0  2024-01-05T11:50:35Z  3UOV8XvCwMKaATRNXrYCjN  45dkTj5sMRSjrmBSBeiHym  \n",
       "1  2024-01-05T11:50:35Z  2IoSjweCu07y9mv5H1Cj3v  3Me35AWHCGqW4sZ7bWWJt1  \n",
       "2  2024-01-05T11:50:35Z  6VCO0fDBGbRW8mCEvV95af  2LIk90788K0zvyj2JJVwkJ  \n",
       "3  2024-01-05T11:50:35Z  1NAmidJlEaVgA3MpcPFYGq  06HL4z0CvFAxyc27GXpf02  \n",
       "4  2024-01-05T11:50:35Z  2Cn1d2KgbkAqbZCJ1RzdkA  2uYWxilOVlUdk4oV9DvwqK  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "song_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "16b1f4af",
   "metadata": {},
   "outputs": [],
   "source": [
    "album_df['release_date'] = pd.to_datetime(album_df['release_date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "800713e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "song_df['song_added'] =  pd.to_datetime(song_df['song_added'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "f1bf817a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50 entries, 0 to 49\n",
      "Data columns (total 8 columns):\n",
      " #   Column       Non-Null Count  Dtype              \n",
      "---  ------       --------------  -----              \n",
      " 0   song_id      50 non-null     object             \n",
      " 1   song_name    50 non-null     object             \n",
      " 2   duration_ms  50 non-null     int64              \n",
      " 3   url          50 non-null     object             \n",
      " 4   popularity   50 non-null     int64              \n",
      " 5   song_added   50 non-null     datetime64[ns, UTC]\n",
      " 6   album_id     50 non-null     object             \n",
      " 7   artist_id    50 non-null     object             \n",
      "dtypes: datetime64[ns, UTC](1), int64(2), object(5)\n",
      "memory usage: 3.2+ KB\n"
     ]
    }
   ],
   "source": [
    "song_df.info()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}