SpotifyAPI_Top10GrammyGenre.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a2c1a77d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\gupta\\anaconda3\\envs\\music\\Lib\\site-packages\\numpy\\_distributor_init.py:30: UserWarning: loaded more than 1 DLL from .libs:\n",
      "C:\\Users\\gupta\\anaconda3\\envs\\music\\Lib\\site-packages\\numpy\\.libs\\libopenblas.FB5AE2TYXYH2IJRDKGDGQ3XBKLKTF43H.gfortran-win_amd64.dll\n",
      "C:\\Users\\gupta\\anaconda3\\envs\\music\\Lib\\site-packages\\numpy\\.libs\\libopenblas64__v0.3.21-gcc_10_3_0.dll\n",
      "  warnings.warn(\"loaded more than 1 DLL from .libs:\"\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n"
     ]
    }
   ],
   "source": [
    "## Creating dataframe of top 50 genres\n",
    "# Data Exploration\n",
    "import pandas as pd\n",
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials\n",
    "\n",
    "cid = '3be62ceebcef44a1807e9002adf8d159'\n",
    "secret = 'bde76e0d3cd54a68b6ca267237bf7e0e'\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=cid, client_secret=secret)\n",
    "sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)\n",
    "\n",
    "artist_name = []\n",
    "track_name = []\n",
    "popularity = []\n",
    "track_id = []\n",
    "artist_href = []\n",
    "track_href = []\n",
    "album_image = []\n",
    "\n",
    "for i in range(0,50,50):\n",
    "    track_results = sp.search(q='year:2023', type='track', limit=50,offset=i)\n",
    "    for i, t in enumerate(track_results['tracks']['items']):\n",
    "        artist_name.append(t['artists'][0]['name'])\n",
    "        track_name.append(t['name'])\n",
    "        track_id.append(t['id'])\n",
    "        popularity.append(t['popularity'])\n",
    "        artist_href.append(t['artists'][0]['external_urls']['spotify'])\n",
    "        track_href.append(t['external_urls']['spotify'])\n",
    "        album_image.append(t['album']['images'][0]['url'])\n",
    "        \n",
    "test1_df = pd.DataFrame({'artist_name' : artist_name, 'track_name' : track_name, 'album_image' : album_image})\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0ad589f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# # Making API request - getting the list of genres from Spotify API\n",
    "# genres = []\n",
    "# None_counter = 0\n",
    "\n",
    "# # get a list of all available categories\n",
    "# categories = sp.categories(limit=20)\n",
    "\n",
    "# # loop over the categories and extract their names\n",
    "# for category in categories['categories']['items']:\n",
    "#     genres.append(category['name'])\n",
    "\n",
    "# # print the list of genres\n",
    "# print(genres)\n",
    "genres = ['Pop', 'Dance/Electronic', 'Rock', 'Rap', 'R&B','Country', 'New Age', 'Jazz', 'Latin', 'Comedy']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "115c40ef",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n"
     ]
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "# Now going thorought the 126 genres and request Spotify API to return 112,000 artist name, track name and genre name\n",
    "# Used for lyrics/genre merge\n",
    "\n",
    "artist_name = []\n",
    "track_name = []\n",
    "genre_name = []\n",
    "# print(genres)\n",
    "\n",
    "for genre in genres:\n",
    "    # print(genre)\n",
    "    for i in range(0,1000,50):\n",
    "        q1 = 'genre:'+str(genre)\n",
    "        genre_results = sp.search(q=q1, type='track', limit=50,offset=i)\n",
    "        for i, t in enumerate(genre_results['tracks']['items']):\n",
    "            artist_name.append(t['artists'][0]['name'])\n",
    "            track_name.append(t['name'])\n",
    "            genre_name.append([genre])\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7091a627",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(10000, 3)\n",
      "            artist_name                            track_name genre_name\n",
      "0           Miley Cyrus                               Flowers      [Pop]\n",
      "1                   SZA                             Kill Bill      [Pop]\n",
      "2          Taylor Swift                             Anti-Hero      [Pop]\n",
      "3                 Drake                       Search & Rescue      [Pop]\n",
      "4           FIFTY FIFTY                     Cupid - Twin Ver.      [Pop]\n",
      "...                 ...                                   ...        ...\n",
      "9995            Afroman                   Let's All Get Drunk   [Comedy]\n",
      "9996  The Lonely Island                      Turn Up The Beef   [Comedy]\n",
      "9997        Brian Regan               Big Family Stuff - Live   [Comedy]\n",
      "9998       Kurt Metzger  The Mayan Prophecies, 2012, And You!   [Comedy]\n",
      "9999        Aziz Ansari        Having a Kid Is a Crazy Gamble   [Comedy]\n",
      "\n",
      "[10000 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "# Genre Dataframe\n",
    "\n",
    "# import pandas as pd\n",
    "\n",
    "genre_dataframe = pd.DataFrame({'artist_name' : artist_name, 'track_name' : track_name, 'genre_name' : genre_name})\n",
    "print(genre_dataframe.shape)\n",
    "print(genre_dataframe)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "3bd8c2b5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Data Exploration\n",
    "\n",
    "genre_dataframe['track_name'] = genre_dataframe['track_name'].apply(lambda row: row.lower())\n",
    "genre_dataframe['artist_name'] = genre_dataframe['artist_name'].apply(lambda row: row.lower())\n",
    "genre_dataframe['genre_name'] = genre_dataframe['genre_name'].str[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fc72953a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Data Exploration\n",
    "\n",
    "# convert to csv\n",
    "\n",
    "import pandas as pd\n",
    "genre_dataframe.to_csv ('Downloads/genre_dataframe4.csv', index = False, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "57aaa1fe",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n"
     ]
    }
   ],
   "source": [
    "# Making API request - going thorough the 126 genres and request Spotify API to return 112,000 artist name, track name, track_href and genre name\n",
    "\n",
    "artist_name = []\n",
    "track_name = []\n",
    "genre_name = []\n",
    "track_id = []\n",
    "artist_href = []\n",
    "track_href = []\n",
    "album_image = []\n",
    "\n",
    "# Set up Spotify API credentials\n",
    "\n",
    "cid = '3be62ceebcef44a1807e9002adf8d159'\n",
    "secret = 'bde76e0d3cd54a68b6ca267237bf7e0e'\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=cid, client_secret=secret)\n",
    "sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)\n",
    "\n",
    "\n",
    "for genre in genres:\n",
    "#     print(genre)\n",
    "    for i in range(0,300,50):\n",
    "        q1 = 'genre:'+str(genre)\n",
    "        genre_results = sp.search(q=q1, type='track', limit=50,offset=i)\n",
    "#         print(genre_results)\n",
    "        for i, t in enumerate(genre_results['tracks']['items']):\n",
    "            artist_name.append(t['artists'][0]['name'])\n",
    "            track_name.append(t['name'])\n",
    "            track_id.append(t['id'])\n",
    "            artist_href.append(t['artists'][0]['external_urls']['spotify'])\n",
    "            track_href.append(t['external_urls']['spotify'])\n",
    "            if t['album']['images']:\n",
    "                album_image.append(t['album']['images'][0]['url'])\n",
    "            else:\n",
    "                album_image.append(None)\n",
    "            genre_name.append([genre])\n",
    "#             print(genre_name)\n",
    "\n",
    "\n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7d51a760",
   "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_name</th>\n",
       "      <th>track_name</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist_href</th>\n",
       "      <th>track_href</th>\n",
       "      <th>genre_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>0yLdNVWF3Srea0uzk55zFn</td>\n",
       "      <td>https://open.spotify.com/artist/5YGY8feqx7naU7...</td>\n",
       "      <td>https://open.spotify.com/track/0yLdNVWF3Srea0u...</td>\n",
       "      <td>[Pop]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SZA</td>\n",
       "      <td>Kill Bill</td>\n",
       "      <td>1Qrg8KqiBpW07V7PNxwwwL</td>\n",
       "      <td>https://open.spotify.com/artist/7tYKF4w9nC0nq9...</td>\n",
       "      <td>https://open.spotify.com/track/1Qrg8KqiBpW07V7...</td>\n",
       "      <td>[Pop]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>Anti-Hero</td>\n",
       "      <td>0V3wPSX9ygBnCm8psDIegu</td>\n",
       "      <td>https://open.spotify.com/artist/06HL4z0CvFAxyc...</td>\n",
       "      <td>https://open.spotify.com/track/0V3wPSX9ygBnCm8...</td>\n",
       "      <td>[Pop]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Search &amp; Rescue</td>\n",
       "      <td>7aRCf5cLOFN1U7kvtChY1G</td>\n",
       "      <td>https://open.spotify.com/artist/3TVXtAsR1Inumw...</td>\n",
       "      <td>https://open.spotify.com/track/7aRCf5cLOFN1U7k...</td>\n",
       "      <td>[Pop]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FIFTY FIFTY</td>\n",
       "      <td>Cupid - Twin Ver.</td>\n",
       "      <td>7FbrGaHYVDmfr7KoLIZnQ7</td>\n",
       "      <td>https://open.spotify.com/artist/4GJ6xDCF5jaUqD...</td>\n",
       "      <td>https://open.spotify.com/track/7FbrGaHYVDmfr7K...</td>\n",
       "      <td>[Pop]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2995</th>\n",
       "      <td>Nate Bargatze</td>\n",
       "      <td>Or He is Walking out and Never Coming Back</td>\n",
       "      <td>00O2gEl8u7c9QY3F4q3DTA</td>\n",
       "      <td>https://open.spotify.com/artist/7ySGZcqhTpH02I...</td>\n",
       "      <td>https://open.spotify.com/track/00O2gEl8u7c9QY3...</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2996</th>\n",
       "      <td>Mike Birbiglia</td>\n",
       "      <td>Like Fun</td>\n",
       "      <td>5H9Rm4YeN5lkkTc15y7Weh</td>\n",
       "      <td>https://open.spotify.com/artist/7LA4bHpsuQA1bN...</td>\n",
       "      <td>https://open.spotify.com/track/5H9Rm4YeN5lkkTc...</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2997</th>\n",
       "      <td>Louis C.K.</td>\n",
       "      <td>Currency</td>\n",
       "      <td>1HwDMRya9LRxFFsBymimlk</td>\n",
       "      <td>https://open.spotify.com/artist/4fQii15cX3Q0Zk...</td>\n",
       "      <td>https://open.spotify.com/track/1HwDMRya9LRxFFs...</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2998</th>\n",
       "      <td>Daniel Tosh</td>\n",
       "      <td>Buff</td>\n",
       "      <td>2OEG6N9cG9z5Z5zdcfZmCr</td>\n",
       "      <td>https://open.spotify.com/artist/6XUNUZVWpFql1y...</td>\n",
       "      <td>https://open.spotify.com/track/2OEG6N9cG9z5Z5z...</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2999</th>\n",
       "      <td>Tommy Campbell</td>\n",
       "      <td>Just Like You're Here</td>\n",
       "      <td>6RdnASiZFd4QhORE0IZC3x</td>\n",
       "      <td>https://open.spotify.com/artist/7eLIwcypaAbo4z...</td>\n",
       "      <td>https://open.spotify.com/track/6RdnASiZFd4QhOR...</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3000 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         artist_name                                  track_name   \n",
       "0        Miley Cyrus                                     Flowers  \\\n",
       "1                SZA                                   Kill Bill   \n",
       "2       Taylor Swift                                   Anti-Hero   \n",
       "3              Drake                             Search & Rescue   \n",
       "4        FIFTY FIFTY                           Cupid - Twin Ver.   \n",
       "...              ...                                         ...   \n",
       "2995   Nate Bargatze  Or He is Walking out and Never Coming Back   \n",
       "2996  Mike Birbiglia                                    Like Fun   \n",
       "2997      Louis C.K.                                    Currency   \n",
       "2998     Daniel Tosh                                        Buff   \n",
       "2999  Tommy Campbell                       Just Like You're Here   \n",
       "\n",
       "                    track_id   \n",
       "0     0yLdNVWF3Srea0uzk55zFn  \\\n",
       "1     1Qrg8KqiBpW07V7PNxwwwL   \n",
       "2     0V3wPSX9ygBnCm8psDIegu   \n",
       "3     7aRCf5cLOFN1U7kvtChY1G   \n",
       "4     7FbrGaHYVDmfr7KoLIZnQ7   \n",
       "...                      ...   \n",
       "2995  00O2gEl8u7c9QY3F4q3DTA   \n",
       "2996  5H9Rm4YeN5lkkTc15y7Weh   \n",
       "2997  1HwDMRya9LRxFFsBymimlk   \n",
       "2998  2OEG6N9cG9z5Z5zdcfZmCr   \n",
       "2999  6RdnASiZFd4QhORE0IZC3x   \n",
       "\n",
       "                                            artist_href   \n",
       "0     https://open.spotify.com/artist/5YGY8feqx7naU7...  \\\n",
       "1     https://open.spotify.com/artist/7tYKF4w9nC0nq9...   \n",
       "2     https://open.spotify.com/artist/06HL4z0CvFAxyc...   \n",
       "3     https://open.spotify.com/artist/3TVXtAsR1Inumw...   \n",
       "4     https://open.spotify.com/artist/4GJ6xDCF5jaUqD...   \n",
       "...                                                 ...   \n",
       "2995  https://open.spotify.com/artist/7ySGZcqhTpH02I...   \n",
       "2996  https://open.spotify.com/artist/7LA4bHpsuQA1bN...   \n",
       "2997  https://open.spotify.com/artist/4fQii15cX3Q0Zk...   \n",
       "2998  https://open.spotify.com/artist/6XUNUZVWpFql1y...   \n",
       "2999  https://open.spotify.com/artist/7eLIwcypaAbo4z...   \n",
       "\n",
       "                                             track_href genre_name  \n",
       "0     https://open.spotify.com/track/0yLdNVWF3Srea0u...      [Pop]  \n",
       "1     https://open.spotify.com/track/1Qrg8KqiBpW07V7...      [Pop]  \n",
       "2     https://open.spotify.com/track/0V3wPSX9ygBnCm8...      [Pop]  \n",
       "3     https://open.spotify.com/track/7aRCf5cLOFN1U7k...      [Pop]  \n",
       "4     https://open.spotify.com/track/7FbrGaHYVDmfr7K...      [Pop]  \n",
       "...                                                 ...        ...  \n",
       "2995  https://open.spotify.com/track/00O2gEl8u7c9QY3...   [Comedy]  \n",
       "2996  https://open.spotify.com/track/5H9Rm4YeN5lkkTc...   [Comedy]  \n",
       "2997  https://open.spotify.com/track/1HwDMRya9LRxFFs...   [Comedy]  \n",
       "2998  https://open.spotify.com/track/2OEG6N9cG9z5Z5z...   [Comedy]  \n",
       "2999  https://open.spotify.com/track/6RdnASiZFd4QhOR...   [Comedy]  \n",
       "\n",
       "[3000 rows x 6 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "   \n",
    "spotify_dataframe = pd.DataFrame({'artist_name' : artist_name, 'track_name' : track_name, 'track_id' : track_id, 'artist_href' : artist_href, 'track_href' : track_href, 'genre_name' : genre_name})\n",
    "\n",
    "\n",
    "spotify_dataframe \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e49c5a66",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "         artist_name                                  track_name   \n",
      "0        Miley Cyrus                                     Flowers  \\\n",
      "1                SZA                                   Kill Bill   \n",
      "2       Taylor Swift                                   Anti-Hero   \n",
      "3              Drake                             Search & Rescue   \n",
      "4        FIFTY FIFTY                           Cupid - Twin Ver.   \n",
      "...              ...                                         ...   \n",
      "2995   Nate Bargatze  Or He is Walking out and Never Coming Back   \n",
      "2996  Mike Birbiglia                                    Like Fun   \n",
      "2997      Louis C.K.                                    Currency   \n",
      "2998     Daniel Tosh                                        Buff   \n",
      "2999  Tommy Campbell                       Just Like You're Here   \n",
      "\n",
      "                    track_id   \n",
      "0     0yLdNVWF3Srea0uzk55zFn  \\\n",
      "1     1Qrg8KqiBpW07V7PNxwwwL   \n",
      "2     0V3wPSX9ygBnCm8psDIegu   \n",
      "3     7aRCf5cLOFN1U7kvtChY1G   \n",
      "4     7FbrGaHYVDmfr7KoLIZnQ7   \n",
      "...                      ...   \n",
      "2995  00O2gEl8u7c9QY3F4q3DTA   \n",
      "2996  5H9Rm4YeN5lkkTc15y7Weh   \n",
      "2997  1HwDMRya9LRxFFsBymimlk   \n",
      "2998  2OEG6N9cG9z5Z5zdcfZmCr   \n",
      "2999  6RdnASiZFd4QhORE0IZC3x   \n",
      "\n",
      "                                            artist_href   \n",
      "0     https://open.spotify.com/artist/5YGY8feqx7naU7...  \\\n",
      "1     https://open.spotify.com/artist/7tYKF4w9nC0nq9...   \n",
      "2     https://open.spotify.com/artist/06HL4z0CvFAxyc...   \n",
      "3     https://open.spotify.com/artist/3TVXtAsR1Inumw...   \n",
      "4     https://open.spotify.com/artist/4GJ6xDCF5jaUqD...   \n",
      "...                                                 ...   \n",
      "2995  https://open.spotify.com/artist/7ySGZcqhTpH02I...   \n",
      "2996  https://open.spotify.com/artist/7LA4bHpsuQA1bN...   \n",
      "2997  https://open.spotify.com/artist/4fQii15cX3Q0Zk...   \n",
      "2998  https://open.spotify.com/artist/6XUNUZVWpFql1y...   \n",
      "2999  https://open.spotify.com/artist/7eLIwcypaAbo4z...   \n",
      "\n",
      "                                             track_href genre_name  \n",
      "0     https://open.spotify.com/track/0yLdNVWF3Srea0u...        Pop  \n",
      "1     https://open.spotify.com/track/1Qrg8KqiBpW07V7...        Pop  \n",
      "2     https://open.spotify.com/track/0V3wPSX9ygBnCm8...        Pop  \n",
      "3     https://open.spotify.com/track/7aRCf5cLOFN1U7k...        Pop  \n",
      "4     https://open.spotify.com/track/7FbrGaHYVDmfr7K...        Pop  \n",
      "...                                                 ...        ...  \n",
      "2995  https://open.spotify.com/track/00O2gEl8u7c9QY3...     Comedy  \n",
      "2996  https://open.spotify.com/track/5H9Rm4YeN5lkkTc...     Comedy  \n",
      "2997  https://open.spotify.com/track/1HwDMRya9LRxFFs...     Comedy  \n",
      "2998  https://open.spotify.com/track/2OEG6N9cG9z5Z5z...     Comedy  \n",
      "2999  https://open.spotify.com/track/6RdnASiZFd4QhOR...     Comedy  \n",
      "\n",
      "[3000 rows x 6 columns]\n"
     ]
    }
   ],
   "source": [
    "# Data Cleanup - get rid of [] in genre_name column\n",
    "\n",
    "spotify_dataframe['genre_name'] = spotify_dataframe['genre_name'].str[0]\n",
    "print(spotify_dataframe)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "dd3858dc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "270"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "# using groupby to check for duplicates\n",
    "\n",
    "grouped = spotify_dataframe.groupby(['artist_name','track_name'], as_index=True).size()\n",
    "grouped[grouped > 1].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "11a2f63a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Data Cleanup - dropping duplicates based on artist_name and track_name\n",
    "\n",
    "# dropping those values\n",
    "\n",
    "spotify_dataframe.drop_duplicates(subset=['artist_name','track_name'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "e94da767",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "# making sure they are gone\n",
    "\n",
    "grouped_after_dropping = spotify_dataframe.groupby(['artist_name','track_name'], as_index=True).size()\n",
    "grouped_after_dropping[grouped_after_dropping > 1].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "6adbf743",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "artist_name    0\n",
       "track_name     0\n",
       "track_id       0\n",
       "artist_href    0\n",
       "track_href     0\n",
       "genre_name     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Data Exploration\n",
    "\n",
    "# how to check duplicates\n",
    "\n",
    "spotify_dataframe[spotify_dataframe.duplicated(subset=['artist_name','track_name'],keep=False)].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "c03fe426",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2654, 6)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "spotify_dataframe.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "65826e61",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n",
      "Couldn't read cache at: .cache\n",
      "Couldn't write token to cache at: .cache\n"
     ]
    }
   ],
   "source": [
    "# Making API request - use Spotipy to request Spotify API and return audio features for 112,000 tracks from sound_dataframe in batches of 100\n",
    "\n",
    "rows = []\n",
    "batchsize = 100\n",
    "None_counter = 0\n",
    "\n",
    "for i in range(0,len(spotify_dataframe['track_id']),batchsize):\n",
    "    batch = spotify_dataframe['track_id'][i:i+batchsize]\n",
    "    feature_results = sp.audio_features(batch)\n",
    "    for i, t in enumerate(feature_results):\n",
    "        if t == None:\n",
    "            None_counter = None_counter + 1\n",
    "        else:\n",
    "            rows.append(t)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "e9613884",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of the dataset: (2654, 18)\n"
     ]
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "audio_features_df = pd.DataFrame.from_dict(rows,orient='columns')\n",
    "print(\"Shape of the dataset:\", audio_features_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "cb845633",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2654 entries, 0 to 2653\n",
      "Data columns (total 18 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   danceability      2654 non-null   float64\n",
      " 1   energy            2654 non-null   float64\n",
      " 2   key               2654 non-null   int64  \n",
      " 3   loudness          2654 non-null   float64\n",
      " 4   mode              2654 non-null   int64  \n",
      " 5   speechiness       2654 non-null   float64\n",
      " 6   acousticness      2654 non-null   float64\n",
      " 7   instrumentalness  2654 non-null   float64\n",
      " 8   liveness          2654 non-null   float64\n",
      " 9   valence           2654 non-null   float64\n",
      " 10  tempo             2654 non-null   float64\n",
      " 11  type              2654 non-null   object \n",
      " 12  id                2654 non-null   object \n",
      " 13  uri               2654 non-null   object \n",
      " 14  track_href        2654 non-null   object \n",
      " 15  analysis_url      2654 non-null   object \n",
      " 16  duration_ms       2654 non-null   int64  \n",
      " 17  time_signature    2654 non-null   int64  \n",
      "dtypes: float64(9), int64(4), object(5)\n",
      "memory usage: 373.3+ KB\n"
     ]
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "audio_features_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "e772ff20",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2654, 13)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Cleanup - dropping and renaming columns\n",
    "\n",
    "columns_to_drop = ['analysis_url','type','uri', 'track_href','time_signature']\n",
    "audio_features_df.drop(columns_to_drop, axis=1,inplace=True)\n",
    "audio_features_df.rename(columns={'id': 'track_id'}, inplace=True)\n",
    "audio_features_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "d6f01f6a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2654 entries, 0 to 2653\n",
      "Data columns (total 13 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   danceability      2654 non-null   float64\n",
      " 1   energy            2654 non-null   float64\n",
      " 2   key               2654 non-null   int64  \n",
      " 3   loudness          2654 non-null   float64\n",
      " 4   mode              2654 non-null   int64  \n",
      " 5   speechiness       2654 non-null   float64\n",
      " 6   acousticness      2654 non-null   float64\n",
      " 7   instrumentalness  2654 non-null   float64\n",
      " 8   liveness          2654 non-null   float64\n",
      " 9   valence           2654 non-null   float64\n",
      " 10  tempo             2654 non-null   float64\n",
      " 11  track_id          2654 non-null   object \n",
      " 12  duration_ms       2654 non-null   int64  \n",
      "dtypes: float64(9), int64(3), object(1)\n",
      "memory usage: 269.7+ KB\n"
     ]
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "audio_features_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "b02fcea0",
   "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_name</th>\n",
       "      <th>track_name</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist_href</th>\n",
       "      <th>track_href</th>\n",
       "      <th>genre_name</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>0yLdNVWF3Srea0uzk55zFn</td>\n",
       "      <td>https://open.spotify.com/artist/5YGY8feqx7naU7...</td>\n",
       "      <td>https://open.spotify.com/track/0yLdNVWF3Srea0u...</td>\n",
       "      <td>Pop</td>\n",
       "      <td>0.707</td>\n",
       "      <td>0.681</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.325</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0668</td>\n",
       "      <td>0.0632</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>0.0322</td>\n",
       "      <td>0.646</td>\n",
       "      <td>117.999</td>\n",
       "      <td>200455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SZA</td>\n",
       "      <td>Kill Bill</td>\n",
       "      <td>1Qrg8KqiBpW07V7PNxwwwL</td>\n",
       "      <td>https://open.spotify.com/artist/7tYKF4w9nC0nq9...</td>\n",
       "      <td>https://open.spotify.com/track/1Qrg8KqiBpW07V7...</td>\n",
       "      <td>Pop</td>\n",
       "      <td>0.644</td>\n",
       "      <td>0.735</td>\n",
       "      <td>8</td>\n",
       "      <td>-5.747</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0391</td>\n",
       "      <td>0.0521</td>\n",
       "      <td>0.144000</td>\n",
       "      <td>0.1610</td>\n",
       "      <td>0.418</td>\n",
       "      <td>88.980</td>\n",
       "      <td>153947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>Anti-Hero</td>\n",
       "      <td>0V3wPSX9ygBnCm8psDIegu</td>\n",
       "      <td>https://open.spotify.com/artist/06HL4z0CvFAxyc...</td>\n",
       "      <td>https://open.spotify.com/track/0V3wPSX9ygBnCm8...</td>\n",
       "      <td>Pop</td>\n",
       "      <td>0.637</td>\n",
       "      <td>0.643</td>\n",
       "      <td>4</td>\n",
       "      <td>-6.571</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0519</td>\n",
       "      <td>0.1300</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.1420</td>\n",
       "      <td>0.533</td>\n",
       "      <td>97.008</td>\n",
       "      <td>200690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Search &amp; Rescue</td>\n",
       "      <td>7aRCf5cLOFN1U7kvtChY1G</td>\n",
       "      <td>https://open.spotify.com/artist/3TVXtAsR1Inumw...</td>\n",
       "      <td>https://open.spotify.com/track/7aRCf5cLOFN1U7k...</td>\n",
       "      <td>Pop</td>\n",
       "      <td>0.817</td>\n",
       "      <td>0.440</td>\n",
       "      <td>10</td>\n",
       "      <td>-8.482</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0734</td>\n",
       "      <td>0.0603</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0.544</td>\n",
       "      <td>142.024</td>\n",
       "      <td>272113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FIFTY FIFTY</td>\n",
       "      <td>Cupid - Twin Ver.</td>\n",
       "      <td>7FbrGaHYVDmfr7KoLIZnQ7</td>\n",
       "      <td>https://open.spotify.com/artist/4GJ6xDCF5jaUqD...</td>\n",
       "      <td>https://open.spotify.com/track/7FbrGaHYVDmfr7K...</td>\n",
       "      <td>Pop</td>\n",
       "      <td>0.783</td>\n",
       "      <td>0.592</td>\n",
       "      <td>11</td>\n",
       "      <td>-8.332</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0331</td>\n",
       "      <td>0.4350</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.3470</td>\n",
       "      <td>0.726</td>\n",
       "      <td>120.018</td>\n",
       "      <td>174253</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    artist_name         track_name                track_id   \n",
       "0   Miley Cyrus            Flowers  0yLdNVWF3Srea0uzk55zFn  \\\n",
       "1           SZA          Kill Bill  1Qrg8KqiBpW07V7PNxwwwL   \n",
       "2  Taylor Swift          Anti-Hero  0V3wPSX9ygBnCm8psDIegu   \n",
       "3         Drake    Search & Rescue  7aRCf5cLOFN1U7kvtChY1G   \n",
       "4   FIFTY FIFTY  Cupid - Twin Ver.  7FbrGaHYVDmfr7KoLIZnQ7   \n",
       "\n",
       "                                         artist_href   \n",
       "0  https://open.spotify.com/artist/5YGY8feqx7naU7...  \\\n",
       "1  https://open.spotify.com/artist/7tYKF4w9nC0nq9...   \n",
       "2  https://open.spotify.com/artist/06HL4z0CvFAxyc...   \n",
       "3  https://open.spotify.com/artist/3TVXtAsR1Inumw...   \n",
       "4  https://open.spotify.com/artist/4GJ6xDCF5jaUqD...   \n",
       "\n",
       "                                          track_href genre_name  danceability   \n",
       "0  https://open.spotify.com/track/0yLdNVWF3Srea0u...        Pop         0.707  \\\n",
       "1  https://open.spotify.com/track/1Qrg8KqiBpW07V7...        Pop         0.644   \n",
       "2  https://open.spotify.com/track/0V3wPSX9ygBnCm8...        Pop         0.637   \n",
       "3  https://open.spotify.com/track/7aRCf5cLOFN1U7k...        Pop         0.817   \n",
       "4  https://open.spotify.com/track/7FbrGaHYVDmfr7K...        Pop         0.783   \n",
       "\n",
       "   energy  key  loudness  mode  speechiness  acousticness  instrumentalness   \n",
       "0   0.681    0    -4.325     1       0.0668        0.0632          0.000005  \\\n",
       "1   0.735    8    -5.747     1       0.0391        0.0521          0.144000   \n",
       "2   0.643    4    -6.571     1       0.0519        0.1300          0.000002   \n",
       "3   0.440   10    -8.482     0       0.0734        0.0603          0.000001   \n",
       "4   0.592   11    -8.332     0       0.0331        0.4350          0.000004   \n",
       "\n",
       "   liveness  valence    tempo  duration_ms  \n",
       "0    0.0322    0.646  117.999       200455  \n",
       "1    0.1610    0.418   88.980       153947  \n",
       "2    0.1420    0.533   97.008       200690  \n",
       "3    0.3300    0.544  142.024       272113  \n",
       "4    0.3470    0.726  120.018       174253  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Cleanup - now we merge user inner to make sure we only keep track ids present\n",
    "\n",
    "clean_df = pd.merge(spotify_dataframe,audio_features_df,on='track_id',how='inner')\n",
    "clean_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "46780935",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2654 entries, 0 to 2653\n",
      "Data columns (total 18 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   artist_name       2654 non-null   object \n",
      " 1   track_name        2654 non-null   object \n",
      " 2   track_id          2654 non-null   object \n",
      " 3   artist_href       2654 non-null   object \n",
      " 4   track_href        2654 non-null   object \n",
      " 5   genre_name        2654 non-null   object \n",
      " 6   danceability      2654 non-null   float64\n",
      " 7   energy            2654 non-null   float64\n",
      " 8   key               2654 non-null   int64  \n",
      " 9   loudness          2654 non-null   float64\n",
      " 10  mode              2654 non-null   int64  \n",
      " 11  speechiness       2654 non-null   float64\n",
      " 12  acousticness      2654 non-null   float64\n",
      " 13  instrumentalness  2654 non-null   float64\n",
      " 14  liveness          2654 non-null   float64\n",
      " 15  valence           2654 non-null   float64\n",
      " 16  tempo             2654 non-null   float64\n",
      " 17  duration_ms       2654 non-null   int64  \n",
      "dtypes: float64(9), int64(3), object(6)\n",
      "memory usage: 373.3+ KB\n"
     ]
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "clean_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "ba3de0c1",
   "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_name</th>\n",
       "      <th>track_name</th>\n",
       "      <th>track_id</th>\n",
       "      <th>artist_href</th>\n",
       "      <th>track_href</th>\n",
       "      <th>genre_name</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [artist_name, track_name, track_id, artist_href, track_href, genre_name, danceability, energy, key, loudness, mode, speechiness, acousticness, instrumentalness, liveness, valence, tempo, duration_ms]\n",
       "Index: []"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data Exploration\n",
    "\n",
    "# make sure no duplicates\n",
    "\n",
    "clean_df[clean_df.duplicated(subset=['artist_name','track_name'],keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "121c7da5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Data Cleanup - making everything lower case\n",
    "\n",
    "clean_df['track_name'] = clean_df['track_name'].apply(lambda row: row.lower())\n",
    "clean_df['artist_name'] = clean_df['artist_name'].apply(lambda row: row.lower())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "6cff74ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "# convert to csv\n",
    "\n",
    "\n",
    "clean_df.to_csv ('Downloads/spotify_df_Top10GrammyGenre.csv', index = False, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d8324df2",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Music",
   "language": "python",
   "name": "music"
  },
  "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.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}