19pw14_19pw18_IR_Package.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "collapsed_sections": [
        "0edsVK-Yt3ad"
      ]
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "# IR PACKAGE - Music Recommendation System\n",
        "\n",
        "We propose a novel approach to music recommendation that takes the audio of the user as input, converts it to text and performs sentiment analysis, tf-idf, and normalization. We then use content-based and collaborative filtering techniques to recommend songs that are likely to be enjoyed by the user based on their expressed sentiments and preferences. By leveraging user-generated content, our approach offers a more personalized and relevant music recommendation experience"
      ],
      "metadata": {
        "id": "DfcDyzdCbPBO"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Pre requisites"
      ],
      "metadata": {
        "id": "WXN022CkAY5P"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import json\n",
        "import pandas as pd\n",
        "import spotipy\n",
        "from spotipy.oauth2 import SpotifyClientCredentials\n",
        "from sklearn.preprocessing import StandardScaler\n",
        "from sklearn.cluster import KMeans"
      ],
      "metadata": {
        "id": "UvnjdtJwiJcp"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install spotipy"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ShREwIofibmu",
        "outputId": "f3932ebb-ca93-4d7c-f059-eb4736d5f4d9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting spotipy\n",
            "  Downloading spotipy-2.22.1-py3-none-any.whl (28 kB)\n",
            "Requirement already satisfied: requests>=2.25.0 in /usr/local/lib/python3.9/dist-packages (from spotipy) (2.27.1)\n",
            "Requirement already satisfied: six>=1.15.0 in /usr/local/lib/python3.9/dist-packages (from spotipy) (1.16.0)\n",
            "Collecting redis>=3.5.3\n",
            "  Downloading redis-4.5.3-py3-none-any.whl (238 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m238.6/238.6 KB\u001b[0m \u001b[31m13.0 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: urllib3>=1.26.0 in /usr/local/lib/python3.9/dist-packages (from spotipy) (1.26.15)\n",
            "Collecting async-timeout>=4.0.2\n",
            "  Downloading async_timeout-4.0.2-py3-none-any.whl (5.8 kB)\n",
            "Requirement already satisfied: charset-normalizer~=2.0.0 in /usr/local/lib/python3.9/dist-packages (from requests>=2.25.0->spotipy) (2.0.12)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.9/dist-packages (from requests>=2.25.0->spotipy) (3.4)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.9/dist-packages (from requests>=2.25.0->spotipy) (2022.12.7)\n",
            "Installing collected packages: async-timeout, redis, spotipy\n",
            "Successfully installed async-timeout-4.0.2 redis-4.5.3 spotipy-2.22.1\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Credentials \n",
        "\n",
        "spotify = spotipy.Spotify(client_credentials_manager=SpotifyClientCredentials(\n",
        "    client_id='23d70a1ad9154551b8e3e52577eeebe9',\n",
        "    client_secret='60f1dcf960fb4c0598eb2354253bd93d'))"
      ],
      "metadata": {
        "id": "wYTew0b7iNq7"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def playlist_analyzer(user, playlist_id):    \n",
        "    names = []\n",
        "    uris = []\n",
        "    artists = []\n",
        "    popularity = []\n",
        "    danceability = []\n",
        "    energy = []\n",
        "    key = []\n",
        "    loudness = []\n",
        "    mode = []\n",
        "    speechiness = []\n",
        "    acousticness = []\n",
        "    instrumentalness =[]\n",
        "    liveness=[]\n",
        "    valence = []\n",
        "    tempo =[]\n",
        "    duration_ms =[]\n",
        "    time_signature =[]\n",
        "    playlist = spotify.user_playlist_tracks(user=user, playlist_id=playlist_id)\n",
        "    tracks = playlist['items']\n",
        "    \n",
        "    while playlist['next']: # While statement to switch to next page of the playlist\n",
        "        playlist = spotify.next(playlist)\n",
        "        tracks.extend(playlist['items'])\n",
        "   \n",
        "    for item in tracks:\n",
        "        names.append(item[\"track\"][\"name\"])\n",
        "        uri = item[\"track\"][\"uri\"]\n",
        "        uris.append(uri)\n",
        "        popularity.append(item[\"track\"][\"popularity\"])\n",
        "        artists.append([artist[\"name\"] for artist in item[\"track\"][\"artists\"]])\n",
        "        features = spotify.audio_features(uri)[0]\n",
        "        danceability.append(features[\"danceability\"])\n",
        "        energy.append(features[\"energy\"])\n",
        "        key.append(features[\"key\"])\n",
        "        loudness.append(features[\"loudness\"])\n",
        "        mode.append(features[\"mode\"])\n",
        "        speechiness.append(features[\"speechiness\"])\n",
        "        acousticness.append(features[\"acousticness\"])\n",
        "        instrumentalness.append(features[\"instrumentalness\"])\n",
        "        liveness.append(features[\"liveness\"])\n",
        "        valence.append(features[\"valence\"])\n",
        "        tempo.append(features[\"tempo\"])\n",
        "        duration_ms.append(features[\"duration_ms\"])\n",
        "        time_signature.append(features[\"time_signature\"])\n",
        "    \n",
        "    # Creating a df from with the song information\n",
        "    df = pd.DataFrame({\"names\":names, \n",
        "                      \"uri\": uris,\n",
        "                      \"artists\": artists,\n",
        "                      \"popularity\": popularity,\n",
        "                        \"danceability\":danceability,\n",
        "                       \"energy\":energy,\n",
        "                       \"key\": key,\n",
        "                       \"loudness\":loudness,\n",
        "                       \"mode\": mode,\n",
        "                       \"speechiness\":speechiness,\n",
        "                       \"acousticness\":acousticness,\n",
        "                       \"instrumentalness\":instrumentalness,\n",
        "                       \"liveness\": liveness,\n",
        "                       \"valence\":valence,\n",
        "                       \"tempo\": tempo,\n",
        "                       \"duration_ms\":duration_ms,\n",
        "                       \"time_signature\": time_signature})\n",
        "\n",
        "    return df"
      ],
      "metadata": {
        "id": "PxE-gP1NiQiA"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Audio query to text query"
      ],
      "metadata": {
        "id": "dbmlJn8s_fw2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!sudo apt-get install libportaudio2\n",
        "!pip install sounddevice"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7ZeRpaBVf2nP",
        "outputId": "32eb6503-47a3-4e02-f4e8-3b934c8b0ea9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Reading package lists... Done\n",
            "Building dependency tree       \n",
            "Reading state information... Done\n",
            "The following NEW packages will be installed:\n",
            "  libportaudio2\n",
            "0 upgraded, 1 newly installed, 0 to remove and 23 not upgraded.\n",
            "Need to get 65.4 kB of archives.\n",
            "After this operation, 223 kB of additional disk space will be used.\n",
            "Get:1 http://archive.ubuntu.com/ubuntu focal/universe amd64 libportaudio2 amd64 19.6.0-1build1 [65.4 kB]\n",
            "Fetched 65.4 kB in 0s (194 kB/s)\n",
            "debconf: unable to initialize frontend: Dialog\n",
            "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76, <> line 1.)\n",
            "debconf: falling back to frontend: Readline\n",
            "debconf: unable to initialize frontend: Readline\n",
            "debconf: (This frontend requires a controlling tty.)\n",
            "debconf: falling back to frontend: Teletype\n",
            "dpkg-preconfigure: unable to re-open stdin: \n",
            "Selecting previously unselected package libportaudio2:amd64.\n",
            "(Reading database ... 128285 files and directories currently installed.)\n",
            "Preparing to unpack .../libportaudio2_19.6.0-1build1_amd64.deb ...\n",
            "Unpacking libportaudio2:amd64 (19.6.0-1build1) ...\n",
            "Setting up libportaudio2:amd64 (19.6.0-1build1) ...\n",
            "Processing triggers for libc-bin (2.31-0ubuntu9.9) ...\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting sounddevice\n",
            "  Downloading sounddevice-0.4.6-py3-none-any.whl (31 kB)\n",
            "Requirement already satisfied: CFFI>=1.0 in /usr/local/lib/python3.9/dist-packages (from sounddevice) (1.15.1)\n",
            "Requirement already satisfied: pycparser in /usr/local/lib/python3.9/dist-packages (from CFFI>=1.0->sounddevice) (2.21)\n",
            "Installing collected packages: sounddevice\n",
            "Successfully installed sounddevice-0.4.6\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install sounddevice soundfile"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0Qx0AJUSkrws",
        "outputId": "deaf2e09-7d1a-475f-cf42-4ecdd33a1746"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: sounddevice in /usr/local/lib/python3.9/dist-packages (0.4.6)\n",
            "Requirement already satisfied: soundfile in /usr/local/lib/python3.9/dist-packages (0.12.1)\n",
            "Requirement already satisfied: CFFI>=1.0 in /usr/local/lib/python3.9/dist-packages (from sounddevice) (1.15.1)\n",
            "Requirement already satisfied: pycparser in /usr/local/lib/python3.9/dist-packages (from CFFI>=1.0->sounddevice) (2.21)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install ffmpeg-python"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qXBvE7tVlotB",
        "outputId": "a19944ca-38d2-48d4-b761-7e41c95b4229"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting ffmpeg-python\n",
            "  Downloading ffmpeg_python-0.2.0-py3-none-any.whl (25 kB)\n",
            "Requirement already satisfied: future in /usr/local/lib/python3.9/dist-packages (from ffmpeg-python) (0.18.3)\n",
            "Installing collected packages: ffmpeg-python\n",
            "Successfully installed ffmpeg-python-0.2.0\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Import Libraries\n",
        "import nltk\n",
        "from nltk.corpus import stopwords\n",
        "nltk.download('stopwords')\n",
        "nltk.download('punkt')\n",
        "nltk.download('wordnet')\n",
        "from nltk.stem import PorterStemmer\n",
        "from nltk.stem import WordNetLemmatizer\n",
        "from wordcloud import WordCloud\n",
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "from nltk.tokenize import word_tokenize, sent_tokenize\n",
        "import pandas as pd \n",
        "import seaborn as sns\n",
        "import matplotlib.pyplot as plt\n",
        "import re\n",
        "import os\n",
        "import numpy as np"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6kUxZqAfWM2b",
        "outputId": "7af0106f-cc28-45a2-f956-3324da2c9985"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package stopwords to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/stopwords.zip.\n",
            "[nltk_data] Downloading package punkt to /root/nltk_data...\n",
            "[nltk_data]   Unzipping tokenizers/punkt.zip.\n",
            "[nltk_data] Downloading package wordnet to /root/nltk_data...\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import nltk\n",
        "from nltk.corpus import stopwords\n",
        "stopwords.words('english')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bYw98BJ3W6gi",
        "outputId": "c8c9d72e-ee9b-4298-b240-9f6d1b2501d3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['i',\n",
              " 'me',\n",
              " 'my',\n",
              " 'myself',\n",
              " 'we',\n",
              " 'our',\n",
              " 'ours',\n",
              " 'ourselves',\n",
              " 'you',\n",
              " \"you're\",\n",
              " \"you've\",\n",
              " \"you'll\",\n",
              " \"you'd\",\n",
              " 'your',\n",
              " 'yours',\n",
              " 'yourself',\n",
              " 'yourselves',\n",
              " 'he',\n",
              " 'him',\n",
              " 'his',\n",
              " 'himself',\n",
              " 'she',\n",
              " \"she's\",\n",
              " 'her',\n",
              " 'hers',\n",
              " 'herself',\n",
              " 'it',\n",
              " \"it's\",\n",
              " 'its',\n",
              " 'itself',\n",
              " 'they',\n",
              " 'them',\n",
              " 'their',\n",
              " 'theirs',\n",
              " 'themselves',\n",
              " 'what',\n",
              " 'which',\n",
              " 'who',\n",
              " 'whom',\n",
              " 'this',\n",
              " 'that',\n",
              " \"that'll\",\n",
              " 'these',\n",
              " 'those',\n",
              " 'am',\n",
              " 'is',\n",
              " 'are',\n",
              " 'was',\n",
              " 'were',\n",
              " 'be',\n",
              " 'been',\n",
              " 'being',\n",
              " 'have',\n",
              " 'has',\n",
              " 'had',\n",
              " 'having',\n",
              " 'do',\n",
              " 'does',\n",
              " 'did',\n",
              " 'doing',\n",
              " 'a',\n",
              " 'an',\n",
              " 'the',\n",
              " 'and',\n",
              " 'but',\n",
              " 'if',\n",
              " 'or',\n",
              " 'because',\n",
              " 'as',\n",
              " 'until',\n",
              " 'while',\n",
              " 'of',\n",
              " 'at',\n",
              " 'by',\n",
              " 'for',\n",
              " 'with',\n",
              " 'about',\n",
              " 'against',\n",
              " 'between',\n",
              " 'into',\n",
              " 'through',\n",
              " 'during',\n",
              " 'before',\n",
              " 'after',\n",
              " 'above',\n",
              " 'below',\n",
              " 'to',\n",
              " 'from',\n",
              " 'up',\n",
              " 'down',\n",
              " 'in',\n",
              " 'out',\n",
              " 'on',\n",
              " 'off',\n",
              " 'over',\n",
              " 'under',\n",
              " 'again',\n",
              " 'further',\n",
              " 'then',\n",
              " 'once',\n",
              " 'here',\n",
              " 'there',\n",
              " 'when',\n",
              " 'where',\n",
              " 'why',\n",
              " 'how',\n",
              " 'all',\n",
              " 'any',\n",
              " 'both',\n",
              " 'each',\n",
              " 'few',\n",
              " 'more',\n",
              " 'most',\n",
              " 'other',\n",
              " 'some',\n",
              " 'such',\n",
              " 'no',\n",
              " 'nor',\n",
              " 'not',\n",
              " 'only',\n",
              " 'own',\n",
              " 'same',\n",
              " 'so',\n",
              " 'than',\n",
              " 'too',\n",
              " 'very',\n",
              " 's',\n",
              " 't',\n",
              " 'can',\n",
              " 'will',\n",
              " 'just',\n",
              " 'don',\n",
              " \"don't\",\n",
              " 'should',\n",
              " \"should've\",\n",
              " 'now',\n",
              " 'd',\n",
              " 'll',\n",
              " 'm',\n",
              " 'o',\n",
              " 're',\n",
              " 've',\n",
              " 'y',\n",
              " 'ain',\n",
              " 'aren',\n",
              " \"aren't\",\n",
              " 'couldn',\n",
              " \"couldn't\",\n",
              " 'didn',\n",
              " \"didn't\",\n",
              " 'doesn',\n",
              " \"doesn't\",\n",
              " 'hadn',\n",
              " \"hadn't\",\n",
              " 'hasn',\n",
              " \"hasn't\",\n",
              " 'haven',\n",
              " \"haven't\",\n",
              " 'isn',\n",
              " \"isn't\",\n",
              " 'ma',\n",
              " 'mightn',\n",
              " \"mightn't\",\n",
              " 'mustn',\n",
              " \"mustn't\",\n",
              " 'needn',\n",
              " \"needn't\",\n",
              " 'shan',\n",
              " \"shan't\",\n",
              " 'shouldn',\n",
              " \"shouldn't\",\n",
              " 'wasn',\n",
              " \"wasn't\",\n",
              " 'weren',\n",
              " \"weren't\",\n",
              " 'won',\n",
              " \"won't\",\n",
              " 'wouldn',\n",
              " \"wouldn't\"]"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "\"\"\"\n",
        "To write this piece of code I took inspiration/code from a lot of places.\n",
        "It was late night, so I'm not sure how much I created or just copied o.O\n",
        "Here are some of the possible references:\n",
        "https://blog.addpipe.com/recording-audio-in-the-browser-using-pure-html5-and-minimal-javascript/\n",
        "https://stackoverflow.com/a/18650249\n",
        "https://hacks.mozilla.org/2014/06/easy-audio-capture-with-the-mediarecorder-api/\n",
        "https://air.ghost.io/recording-to-an-audio-file-using-html5-and-js/\n",
        "https://stackoverflow.com/a/49019356\n",
        "\"\"\"\n",
        "from IPython.display import HTML, Audio\n",
        "from google.colab.output import eval_js\n",
        "from base64 import b64decode\n",
        "import numpy as np\n",
        "from scipy.io.wavfile import read as wav_read\n",
        "import io\n",
        "import ffmpeg\n",
        "\n",
        "AUDIO_HTML = \"\"\"\n",
        "<script>\n",
        "var my_div = document.createElement(\"DIV\");\n",
        "var my_p = document.createElement(\"P\");\n",
        "var my_btn = document.createElement(\"BUTTON\");\n",
        "var t = document.createTextNode(\"Press to start recording\");\n",
        "\n",
        "my_btn.appendChild(t);\n",
        "//my_p.appendChild(my_btn);\n",
        "my_div.appendChild(my_btn);\n",
        "document.body.appendChild(my_div);\n",
        "\n",
        "var base64data = 0;\n",
        "var reader;\n",
        "var recorder, gumStream;\n",
        "var recordButton = my_btn;\n",
        "\n",
        "var handleSuccess = function(stream) {\n",
        "  gumStream = stream;\n",
        "  var options = {\n",
        "    //bitsPerSecond: 8000, //chrome seems to ignore, always 48k\n",
        "    mimeType : 'audio/webm;codecs=opus'\n",
        "    //mimeType : 'audio/webm;codecs=pcm'\n",
        "  };            \n",
        "  //recorder = new MediaRecorder(stream, options);\n",
        "  recorder = new MediaRecorder(stream);\n",
        "  recorder.ondataavailable = function(e) {            \n",
        "    var url = URL.createObjectURL(e.data);\n",
        "    var preview = document.createElement('audio');\n",
        "    preview.controls = true;\n",
        "    preview.src = url;\n",
        "    document.body.appendChild(preview);\n",
        "\n",
        "    reader = new FileReader();\n",
        "    reader.readAsDataURL(e.data); \n",
        "    reader.onloadend = function() {\n",
        "      base64data = reader.result;\n",
        "      //console.log(\"Inside FileReader:\" + base64data);\n",
        "    }\n",
        "  };\n",
        "  recorder.start();\n",
        "  };\n",
        "\n",
        "recordButton.innerText = \"Recording... press to stop\";\n",
        "\n",
        "navigator.mediaDevices.getUserMedia({audio: true}).then(handleSuccess);\n",
        "\n",
        "\n",
        "function toggleRecording() {\n",
        "  if (recorder && recorder.state == \"recording\") {\n",
        "      recorder.stop();\n",
        "      gumStream.getAudioTracks()[0].stop();\n",
        "      recordButton.innerText = \"Saving the recording... pls wait!\"\n",
        "  }\n",
        "}\n",
        "\n",
        "// https://stackoverflow.com/a/951057\n",
        "function sleep(ms) {\n",
        "  return new Promise(resolve => setTimeout(resolve, ms));\n",
        "}\n",
        "\n",
        "var data = new Promise(resolve=>{\n",
        "//recordButton.addEventListener(\"click\", toggleRecording);\n",
        "recordButton.onclick = ()=>{\n",
        "toggleRecording()\n",
        "\n",
        "sleep(2000).then(() => {\n",
        "  // wait 2000ms for the data to be available...\n",
        "  // ideally this should use something like await...\n",
        "  //console.log(\"Inside data:\" + base64data)\n",
        "  resolve(base64data.toString())\n",
        "\n",
        "});\n",
        "\n",
        "}\n",
        "});\n",
        "      \n",
        "</script>\n",
        "\"\"\"\n",
        "\n",
        "def get_audio():\n",
        "  display(HTML(AUDIO_HTML))\n",
        "  data = eval_js(\"data\")\n",
        "  binary = b64decode(data.split(',')[1])\n",
        "  \n",
        "  process = (ffmpeg\n",
        "    .input('pipe:0')\n",
        "    .output('pipe:1', format='wav')\n",
        "    .run_async(pipe_stdin=True, pipe_stdout=True, pipe_stderr=True, quiet=True, overwrite_output=True)\n",
        "  )\n",
        "  output, err = process.communicate(input=binary)\n",
        "  \n",
        "  riff_chunk_size = len(output) - 8\n",
        "  # Break up the chunk size into four bytes, held in b.\n",
        "  q = riff_chunk_size\n",
        "  b = []\n",
        "  for i in range(4):\n",
        "      q, r = divmod(q, 256)\n",
        "      b.append(r)\n",
        "\n",
        "  # Replace bytes 4:8 in proc.stdout with the actual size of the RIFF chunk.\n",
        "  riff = output[:4] + bytes(b) + output[8:]\n",
        "\n",
        "  sr, audio = wav_read(io.BytesIO(riff))\n",
        "\n",
        "  return audio, sr"
      ],
      "metadata": {
        "id": "guDpgbs9pYMs"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "audio, sr = get_audio()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 96
        },
        "id": "GxZsz4Atpc77",
        "outputId": "d4c87ad3-d8e8-47b8-a87e-8a36a63b17d3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "<script>\n",
              "var my_div = document.createElement(\"DIV\");\n",
              "var my_p = document.createElement(\"P\");\n",
              "var my_btn = document.createElement(\"BUTTON\");\n",
              "var t = document.createTextNode(\"Press to start recording\");\n",
              "\n",
              "my_btn.appendChild(t);\n",
              "//my_p.appendChild(my_btn);\n",
              "my_div.appendChild(my_btn);\n",
              "document.body.appendChild(my_div);\n",
              "\n",
              "var base64data = 0;\n",
              "var reader;\n",
              "var recorder, gumStream;\n",
              "var recordButton = my_btn;\n",
              "\n",
              "var handleSuccess = function(stream) {\n",
              "  gumStream = stream;\n",
              "  var options = {\n",
              "    //bitsPerSecond: 8000, //chrome seems to ignore, always 48k\n",
              "    mimeType : 'audio/webm;codecs=opus'\n",
              "    //mimeType : 'audio/webm;codecs=pcm'\n",
              "  };            \n",
              "  //recorder = new MediaRecorder(stream, options);\n",
              "  recorder = new MediaRecorder(stream);\n",
              "  recorder.ondataavailable = function(e) {            \n",
              "    var url = URL.createObjectURL(e.data);\n",
              "    var preview = document.createElement('audio');\n",
              "    preview.controls = true;\n",
              "    preview.src = url;\n",
              "    document.body.appendChild(preview);\n",
              "\n",
              "    reader = new FileReader();\n",
              "    reader.readAsDataURL(e.data); \n",
              "    reader.onloadend = function() {\n",
              "      base64data = reader.result;\n",
              "      //console.log(\"Inside FileReader:\" + base64data);\n",
              "    }\n",
              "  };\n",
              "  recorder.start();\n",
              "  };\n",
              "\n",
              "recordButton.innerText = \"Recording... press to stop\";\n",
              "\n",
              "navigator.mediaDevices.getUserMedia({audio: true}).then(handleSuccess);\n",
              "\n",
              "\n",
              "function toggleRecording() {\n",
              "  if (recorder && recorder.state == \"recording\") {\n",
              "      recorder.stop();\n",
              "      gumStream.getAudioTracks()[0].stop();\n",
              "      recordButton.innerText = \"Saving the recording... pls wait!\"\n",
              "  }\n",
              "}\n",
              "\n",
              "// https://stackoverflow.com/a/951057\n",
              "function sleep(ms) {\n",
              "  return new Promise(resolve => setTimeout(resolve, ms));\n",
              "}\n",
              "\n",
              "var data = new Promise(resolve=>{\n",
              "//recordButton.addEventListener(\"click\", toggleRecording);\n",
              "recordButton.onclick = ()=>{\n",
              "toggleRecording()\n",
              "\n",
              "sleep(2000).then(() => {\n",
              "  // wait 2000ms for the data to be available...\n",
              "  // ideally this should use something like await...\n",
              "  //console.log(\"Inside data:\" + base64data)\n",
              "  resolve(base64data.toString())\n",
              "\n",
              "});\n",
              "\n",
              "}\n",
              "});\n",
              "      \n",
              "</script>\n"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import scipy\n",
        "scipy.io.wavfile.write('recording.wav', sr, audio)"
      ],
      "metadata": {
        "id": "k66TqwTgpjsn"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install SpeechRecognition"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 471
        },
        "id": "aB5LqnckSSG4",
        "outputId": "60c04da5-9235-48ae-a523-f9d06b835e50"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting SpeechRecognition\n",
            "  Downloading SpeechRecognition-3.10.0-py2.py3-none-any.whl (32.8 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m32.8/32.8 MB\u001b[0m \u001b[31m35.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hCollecting requests>=2.26.0\n",
            "  Downloading requests-2.28.2-py3-none-any.whl (62 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m62.8/62.8 KB\u001b[0m \u001b[31m8.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.9/dist-packages (from requests>=2.26.0->SpeechRecognition) (2.10)\n",
            "Collecting charset-normalizer<4,>=2\n",
            "  Downloading charset_normalizer-3.1.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (199 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m199.2/199.2 KB\u001b[0m \u001b[31m21.5 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/local/lib/python3.9/dist-packages (from requests>=2.26.0->SpeechRecognition) (1.26.15)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.9/dist-packages (from requests>=2.26.0->SpeechRecognition) (2022.12.7)\n",
            "Installing collected packages: charset-normalizer, requests, SpeechRecognition\n",
            "  Attempting uninstall: requests\n",
            "    Found existing installation: requests 2.25.1\n",
            "    Uninstalling requests-2.25.1:\n",
            "      Successfully uninstalled requests-2.25.1\n",
            "Successfully installed SpeechRecognition-3.10.0 charset-normalizer-3.1.0 requests-2.28.2\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "application/vnd.colab-display-data+json": {
              "pip_warning": {
                "packages": [
                  "requests"
                ]
              }
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import speech_recognition as sr\n",
        "\n",
        "# Set the path to your audio file\n",
        "audio_file_path = '/content/recording.wav'\n",
        "\n",
        "# Create a recognizer object\n",
        "r = sr.Recognizer()\n",
        "\n",
        "# Load the audio file\n",
        "with sr.AudioFile(audio_file_path) as source:\n",
        "    audio = r.record(source)\n",
        "\n",
        "# Transcribe the audio file\n",
        "text = r.recognize_google(audio)\n",
        "\n",
        "# Print the transcribed text\n",
        "print(text)\n"
      ],
      "metadata": {
        "id": "QU4ytS4aSB0K"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Tokenize the input text\n",
        "tokens = nltk.word_tokenize(text)\n",
        "\n",
        "# Get the set of English stopwords\n",
        "stop_words = set(stopwords.words('english'))\n",
        "\n",
        "# Remove the stopwords from the token list\n",
        "filtered_tokens = [token for token in tokens if not token.lower() in stop_words]\n",
        "\n",
        "# Join the filtered tokens back into a string\n",
        "filtered_text = ' '.join(filtered_tokens)"
      ],
      "metadata": {
        "id": "_2QfOB-LbN2B"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nltk.download('omw-1.4')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "70aIWQyFcHKO",
        "outputId": "7d10c0c6-bbd2-4a65-9ff3-0657f50904df"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package omw-1.4 to /root/nltk_data...\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "lemmatizer = WordNetLemmatizer()  \n",
        "text = [lemmatizer.lemmatize(word) for word in filtered_text]   \n",
        "#joining the sentences\n",
        "cleanedLine=\" \"\n",
        "cleanedLine=cleanedLine.join(text)"
      ],
      "metadata": {
        "id": "noQi9dPJb86B"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(cleanedLine)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-YS1iBfqX7a3",
        "outputId": "efe21871-111d-4b39-a78c-625c10faa224"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "a d o r e   a d o r e\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Search engine"
      ],
      "metadata": {
        "id": "kE3rxVY4_u0I"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "from sklearn.feature_extraction.text import TfidfVectorizer\n",
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "from sklearn.metrics.pairwise import cosine_similarity"
      ],
      "metadata": {
        "id": "w_5GLbrkCWyH"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "https://open.spotify.com/playlist/4ulHIyJD1fn3HnmFaD0ZMC"
      ],
      "metadata": {
        "id": "szxkWRNHJlkb"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#General playlist -> feature extraction\n",
        "df = playlist_analyzer(\"spotify\", \"https://open.spotify.com/playlist/0X9hkrRqCCP69Ze1MheAda?si=099e5aeff89140b7\")"
      ],
      "metadata": {
        "id": "WwS6d2SmCcae"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(df.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-7EMDKDnJy5T",
        "outputId": "d3e74da3-fbd7-4140-91c4-8340809bf843"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 600 entries, 0 to 599\n",
            "Data columns (total 17 columns):\n",
            " #   Column            Non-Null Count  Dtype  \n",
            "---  ------            --------------  -----  \n",
            " 0   names             600 non-null    object \n",
            " 1   uri               600 non-null    object \n",
            " 2   artists           600 non-null    object \n",
            " 3   popularity        600 non-null    int64  \n",
            " 4   danceability      600 non-null    float64\n",
            " 5   energy            600 non-null    float64\n",
            " 6   key               600 non-null    int64  \n",
            " 7   loudness          600 non-null    float64\n",
            " 8   mode              600 non-null    int64  \n",
            " 9   speechiness       600 non-null    float64\n",
            " 10  acousticness      600 non-null    float64\n",
            " 11  instrumentalness  600 non-null    float64\n",
            " 12  liveness          600 non-null    float64\n",
            " 13  valence           600 non-null    float64\n",
            " 14  tempo             600 non-null    float64\n",
            " 15  duration_ms       600 non-null    int64  \n",
            " 16  time_signature    600 non-null    int64  \n",
            "dtypes: float64(9), int64(5), object(3)\n",
            "memory usage: 79.8+ KB\n",
            "None\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.to_csv(\"general.csv\", index=False)"
      ],
      "metadata": {
        "id": "xGixNIdci6g1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "vectorizer = TfidfVectorizer()\n",
        "test=pd.concat([df['names'],df['artists']], join = 'outer', axis = 1)\n",
        "X = vectorizer.fit_transform(test)"
      ],
      "metadata": {
        "id": "6nfGL7IuCeHQ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "li=[]\n",
        "for i in range(0,600):\n",
        "    li.append(df.loc[i, 'names']+\" \"+df.loc[i,'artists'][0])\n",
        "\n",
        "df['names+artist']=li\n",
        "X = vectorizer.fit_transform(df['names+artist'])"
      ],
      "metadata": {
        "id": "5_QfM9E8OeNp"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "query = \"Calm Down (with Selena Gomez)\"\n",
        "query_vec = vectorizer.transform([query])"
      ],
      "metadata": {
        "id": "tOW03dIyCiid"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "results = cosine_similarity(X,query_vec)"
      ],
      "metadata": {
        "id": "DsbdUEYnCkNz"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "results"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PxrHfueXOaD8",
        "outputId": "207fe797-73b8-4268-8872-2b01e634736f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([[0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.1360295 ],\n",
              "       [0.        ],\n",
              "       [0.32830088],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.17448182],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.39867574],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.28931214],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.2512211 ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.17537091],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.25536564],\n",
              "       [0.37264548],\n",
              "       [0.        ],\n",
              "       [0.18754552],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.27551479],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.2327894 ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.19898098],\n",
              "       [0.33349274],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.20392697],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.17139753],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.2379463 ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.22787883],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.2262208 ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.30347619],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.21327101],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.17102141],\n",
              "       [0.        ],\n",
              "       [0.16603859],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.16363797],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.32759343],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.21530686],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.26878495],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.23260353],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ]])"
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['cosine']=np.array(results)\n",
        "sort_df = df.sort_values(by = 'cosine', ascending=False)\n",
        "sort_df.head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 756
        },
        "id": "h6u804r1GsGg",
        "outputId": "dfa7e7b2-9b01-4899-85a1-bb4a418524e7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                      names  \\\n",
              "127                                    Down   \n",
              "286                              Kryptonite   \n",
              "332                       Don't Let Me Down   \n",
              "79                              Upside Down   \n",
              "520                        Here Without You   \n",
              "435                          Shake You Down   \n",
              "218                              Down Under   \n",
              "294                           Rock With You   \n",
              "563                          Lay Down Sally   \n",
              "285  Can't Nobody Hold Me Down (feat. Mase)   \n",
              "\n",
              "                                      uri                   artists  \\\n",
              "127  spotify:track:7LP4Es66zdY7CyjepqmvAg     [Jay Sean, Lil Wayne]   \n",
              "286  spotify:track:6ZOBP3NvffbU4SZcrnt1k6            [3 Doors Down]   \n",
              "332  spotify:track:0w75KG0DuLDi6tdHmEMovD  [The Chainsmokers, Daya]   \n",
              "79   spotify:track:3pbtBomO4Zt5gGiqsYeiBH              [Diana Ross]   \n",
              "520  spotify:track:3NLrRZoMF0Lx6zTlYqeIo4            [3 Doors Down]   \n",
              "435  spotify:track:7wQ9alB79WZb0F5gFLbxSh          [Gregory Abbott]   \n",
              "218  spotify:track:46RVKt5Edm1zl0rXhPJZxz             [Men At Work]   \n",
              "294  spotify:track:0oA7AdpU9Uhg1GL7p739H6         [Michael Jackson]   \n",
              "563  spotify:track:6io0LJIP9ntX35hTfaxwQG            [Eric Clapton]   \n",
              "285  spotify:track:1EM23A621Z0QyTlWKu7T1l             [Diddy, Mase]   \n",
              "\n",
              "     popularity  danceability  energy  key  loudness  mode  speechiness  \\\n",
              "127           1         0.657   0.695    2    -4.493     1       0.0321   \n",
              "286          78         0.545   0.865   11    -5.708     0       0.0286   \n",
              "332          48         0.534   0.868   11    -5.057     1       0.2050   \n",
              "79           67         0.873   0.855    5    -8.559     0       0.0615   \n",
              "520          74         0.557   0.533   10    -6.817     0       0.0252   \n",
              "435          56         0.787   0.474   11   -10.384     0       0.0265   \n",
              "218          69         0.746   0.790   11    -4.700     0       0.0257   \n",
              "294           0         0.794   0.741    1    -6.494     1       0.0394   \n",
              "563          60         0.690   0.500    4   -16.145     0       0.0909   \n",
              "285          57         0.928   0.771    3    -5.935     0       0.2510   \n",
              "\n",
              "     acousticness  instrumentalness  liveness  valence    tempo  duration_ms  \\\n",
              "127       0.01080          0.000000    0.0822    0.683   65.997       212107   \n",
              "286       0.00664          0.000011    0.1680    0.543   99.009       233933   \n",
              "332       0.18700          0.003200    0.1480    0.406  159.763       208667   \n",
              "79        0.17900          0.028500    0.0377    0.884  107.868       245600   \n",
              "520       0.04920          0.000000    0.2050    0.233  143.994       238733   \n",
              "435       0.52300          0.000000    0.2350    0.826   94.995       245413   \n",
              "218       0.04850          0.026100    0.0534    0.891  107.231       220867   \n",
              "294       0.07930          0.000292    0.1160    0.856  114.489       220040   \n",
              "563       0.59800          0.028800    0.1100    0.586  191.539       236093   \n",
              "285       0.10200          0.000011    0.3380    0.679   93.987       231160   \n",
              "\n",
              "     time_signature                                  names+artist    cosine  \n",
              "127               4                                 Down Jay Sean  0.398676  \n",
              "286               4                       Kryptonite 3 Doors Down  0.372645  \n",
              "332               4            Don't Let Me Down The Chainsmokers  0.333493  \n",
              "79                4                        Upside Down Diana Ross  0.328301  \n",
              "520               4                 Here Without You 3 Doors Down  0.327593  \n",
              "435               4                 Shake You Down Gregory Abbott  0.303476  \n",
              "218               4                        Down Under Men At Work  0.289312  \n",
              "294               4                 Rock With You Michael Jackson  0.275515  \n",
              "563               4                   Lay Down Sally Eric Clapton  0.268785  \n",
              "285               4  Can't Nobody Hold Me Down (feat. Mase) Diddy  0.255366  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b4ba3687-5888-44ce-9899-d53935796e6a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>names</th>\n",
              "      <th>uri</th>\n",
              "      <th>artists</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>energy</th>\n",
              "      <th>key</th>\n",
              "      <th>loudness</th>\n",
              "      <th>mode</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>valence</th>\n",
              "      <th>tempo</th>\n",
              "      <th>duration_ms</th>\n",
              "      <th>time_signature</th>\n",
              "      <th>names+artist</th>\n",
              "      <th>cosine</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>Down</td>\n",
              "      <td>spotify:track:7LP4Es66zdY7CyjepqmvAg</td>\n",
              "      <td>[Jay Sean, Lil Wayne]</td>\n",
              "      <td>1</td>\n",
              "      <td>0.657</td>\n",
              "      <td>0.695</td>\n",
              "      <td>2</td>\n",
              "      <td>-4.493</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0321</td>\n",
              "      <td>0.01080</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0822</td>\n",
              "      <td>0.683</td>\n",
              "      <td>65.997</td>\n",
              "      <td>212107</td>\n",
              "      <td>4</td>\n",
              "      <td>Down Jay Sean</td>\n",
              "      <td>0.398676</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>286</th>\n",
              "      <td>Kryptonite</td>\n",
              "      <td>spotify:track:6ZOBP3NvffbU4SZcrnt1k6</td>\n",
              "      <td>[3 Doors Down]</td>\n",
              "      <td>78</td>\n",
              "      <td>0.545</td>\n",
              "      <td>0.865</td>\n",
              "      <td>11</td>\n",
              "      <td>-5.708</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0286</td>\n",
              "      <td>0.00664</td>\n",
              "      <td>0.000011</td>\n",
              "      <td>0.1680</td>\n",
              "      <td>0.543</td>\n",
              "      <td>99.009</td>\n",
              "      <td>233933</td>\n",
              "      <td>4</td>\n",
              "      <td>Kryptonite 3 Doors Down</td>\n",
              "      <td>0.372645</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>332</th>\n",
              "      <td>Don't Let Me Down</td>\n",
              "      <td>spotify:track:0w75KG0DuLDi6tdHmEMovD</td>\n",
              "      <td>[The Chainsmokers, Daya]</td>\n",
              "      <td>48</td>\n",
              "      <td>0.534</td>\n",
              "      <td>0.868</td>\n",
              "      <td>11</td>\n",
              "      <td>-5.057</td>\n",
              "      <td>1</td>\n",
              "      <td>0.2050</td>\n",
              "      <td>0.18700</td>\n",
              "      <td>0.003200</td>\n",
              "      <td>0.1480</td>\n",
              "      <td>0.406</td>\n",
              "      <td>159.763</td>\n",
              "      <td>208667</td>\n",
              "      <td>4</td>\n",
              "      <td>Don't Let Me Down The Chainsmokers</td>\n",
              "      <td>0.333493</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>Upside Down</td>\n",
              "      <td>spotify:track:3pbtBomO4Zt5gGiqsYeiBH</td>\n",
              "      <td>[Diana Ross]</td>\n",
              "      <td>67</td>\n",
              "      <td>0.873</td>\n",
              "      <td>0.855</td>\n",
              "      <td>5</td>\n",
              "      <td>-8.559</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0615</td>\n",
              "      <td>0.17900</td>\n",
              "      <td>0.028500</td>\n",
              "      <td>0.0377</td>\n",
              "      <td>0.884</td>\n",
              "      <td>107.868</td>\n",
              "      <td>245600</td>\n",
              "      <td>4</td>\n",
              "      <td>Upside Down Diana Ross</td>\n",
              "      <td>0.328301</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>520</th>\n",
              "      <td>Here Without You</td>\n",
              "      <td>spotify:track:3NLrRZoMF0Lx6zTlYqeIo4</td>\n",
              "      <td>[3 Doors Down]</td>\n",
              "      <td>74</td>\n",
              "      <td>0.557</td>\n",
              "      <td>0.533</td>\n",
              "      <td>10</td>\n",
              "      <td>-6.817</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0252</td>\n",
              "      <td>0.04920</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2050</td>\n",
              "      <td>0.233</td>\n",
              "      <td>143.994</td>\n",
              "      <td>238733</td>\n",
              "      <td>4</td>\n",
              "      <td>Here Without You 3 Doors Down</td>\n",
              "      <td>0.327593</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>435</th>\n",
              "      <td>Shake You Down</td>\n",
              "      <td>spotify:track:7wQ9alB79WZb0F5gFLbxSh</td>\n",
              "      <td>[Gregory Abbott]</td>\n",
              "      <td>56</td>\n",
              "      <td>0.787</td>\n",
              "      <td>0.474</td>\n",
              "      <td>11</td>\n",
              "      <td>-10.384</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0265</td>\n",
              "      <td>0.52300</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2350</td>\n",
              "      <td>0.826</td>\n",
              "      <td>94.995</td>\n",
              "      <td>245413</td>\n",
              "      <td>4</td>\n",
              "      <td>Shake You Down Gregory Abbott</td>\n",
              "      <td>0.303476</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>218</th>\n",
              "      <td>Down Under</td>\n",
              "      <td>spotify:track:46RVKt5Edm1zl0rXhPJZxz</td>\n",
              "      <td>[Men At Work]</td>\n",
              "      <td>69</td>\n",
              "      <td>0.746</td>\n",
              "      <td>0.790</td>\n",
              "      <td>11</td>\n",
              "      <td>-4.700</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0257</td>\n",
              "      <td>0.04850</td>\n",
              "      <td>0.026100</td>\n",
              "      <td>0.0534</td>\n",
              "      <td>0.891</td>\n",
              "      <td>107.231</td>\n",
              "      <td>220867</td>\n",
              "      <td>4</td>\n",
              "      <td>Down Under Men At Work</td>\n",
              "      <td>0.289312</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>294</th>\n",
              "      <td>Rock With You</td>\n",
              "      <td>spotify:track:0oA7AdpU9Uhg1GL7p739H6</td>\n",
              "      <td>[Michael Jackson]</td>\n",
              "      <td>0</td>\n",
              "      <td>0.794</td>\n",
              "      <td>0.741</td>\n",
              "      <td>1</td>\n",
              "      <td>-6.494</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0394</td>\n",
              "      <td>0.07930</td>\n",
              "      <td>0.000292</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>0.856</td>\n",
              "      <td>114.489</td>\n",
              "      <td>220040</td>\n",
              "      <td>4</td>\n",
              "      <td>Rock With You Michael Jackson</td>\n",
              "      <td>0.275515</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>563</th>\n",
              "      <td>Lay Down Sally</td>\n",
              "      <td>spotify:track:6io0LJIP9ntX35hTfaxwQG</td>\n",
              "      <td>[Eric Clapton]</td>\n",
              "      <td>60</td>\n",
              "      <td>0.690</td>\n",
              "      <td>0.500</td>\n",
              "      <td>4</td>\n",
              "      <td>-16.145</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0909</td>\n",
              "      <td>0.59800</td>\n",
              "      <td>0.028800</td>\n",
              "      <td>0.1100</td>\n",
              "      <td>0.586</td>\n",
              "      <td>191.539</td>\n",
              "      <td>236093</td>\n",
              "      <td>4</td>\n",
              "      <td>Lay Down Sally Eric Clapton</td>\n",
              "      <td>0.268785</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>285</th>\n",
              "      <td>Can't Nobody Hold Me Down (feat. Mase)</td>\n",
              "      <td>spotify:track:1EM23A621Z0QyTlWKu7T1l</td>\n",
              "      <td>[Diddy, Mase]</td>\n",
              "      <td>57</td>\n",
              "      <td>0.928</td>\n",
              "      <td>0.771</td>\n",
              "      <td>3</td>\n",
              "      <td>-5.935</td>\n",
              "      <td>0</td>\n",
              "      <td>0.2510</td>\n",
              "      <td>0.10200</td>\n",
              "      <td>0.000011</td>\n",
              "      <td>0.3380</td>\n",
              "      <td>0.679</td>\n",
              "      <td>93.987</td>\n",
              "      <td>231160</td>\n",
              "      <td>4</td>\n",
              "      <td>Can't Nobody Hold Me Down (feat. Mase) Diddy</td>\n",
              "      <td>0.255366</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b4ba3687-5888-44ce-9899-d53935796e6a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b4ba3687-5888-44ce-9899-d53935796e6a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b4ba3687-5888-44ce-9899-d53935796e6a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Content based"
      ],
      "metadata": {
        "id": "eV2Wj-eUh-wF"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Playlist \n",
        "playlist_df = playlist_analyzer(\"spotify\", \"https://open.spotify.com/playlist/4hMcqod7ERKJ9mtjgdimeV?si=00bfd8719a074aa7\")\n",
        "features_playlist = df.iloc[:,4:17].copy() #Creating a subset of the df with only the features "
      ],
      "metadata": {
        "id": "zGOg-lwfiTSU"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "playlist_df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IMR_jK1eiolx",
        "outputId": "922fb372-fe81-40e9-f372-8f28f75cf27d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 225 entries, 0 to 224\n",
            "Data columns (total 17 columns):\n",
            " #   Column            Non-Null Count  Dtype  \n",
            "---  ------            --------------  -----  \n",
            " 0   names             225 non-null    object \n",
            " 1   uri               225 non-null    object \n",
            " 2   artists           225 non-null    object \n",
            " 3   popularity        225 non-null    int64  \n",
            " 4   danceability      225 non-null    float64\n",
            " 5   energy            225 non-null    float64\n",
            " 6   key               225 non-null    int64  \n",
            " 7   loudness          225 non-null    float64\n",
            " 8   mode              225 non-null    int64  \n",
            " 9   speechiness       225 non-null    float64\n",
            " 10  acousticness      225 non-null    float64\n",
            " 11  instrumentalness  225 non-null    float64\n",
            " 12  liveness          225 non-null    float64\n",
            " 13  valence           225 non-null    float64\n",
            " 14  tempo             225 non-null    float64\n",
            " 15  duration_ms       225 non-null    int64  \n",
            " 16  time_signature    225 non-null    int64  \n",
            "dtypes: float64(9), int64(5), object(3)\n",
            "memory usage: 30.0+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "playlist_df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "3NcK7hPYFQDi",
        "outputId": "8cfd740b-26fe-46ad-e252-641872775e92"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                     names  \\\n",
              "0                       Boy's a liar Pt. 2   \n",
              "1                      Die For You - Remix   \n",
              "2                                  Flowers   \n",
              "3                Unholy (feat. Kim Petras)   \n",
              "4                                Kill Bill   \n",
              "5                          I'm Good (Blue)   \n",
              "6            Calm Down (with Selena Gomez)   \n",
              "7   Creepin' (with The Weeknd & 21 Savage)   \n",
              "8                                Escapism.   \n",
              "9                             Here With Me   \n",
              "10                               Anti-Hero   \n",
              "11                               As It Was   \n",
              "12                           Falling Apart   \n",
              "13                                 CUFF IT   \n",
              "14                               Bad Habit   \n",
              "15                           Made You Look   \n",
              "16                    tell me who hurt you   \n",
              "17                              Sure Thing   \n",
              "18              Bam Bam (feat. Ed Sheeran)   \n",
              "19                         Just Wanna Rock   \n",
              "\n",
              "                                     uri  \\\n",
              "0   spotify:track:6AQbmUe0Qwf5PZnt4HmTXv   \n",
              "1   spotify:track:7oDd86yk8itslrA9HRP2ki   \n",
              "2   spotify:track:0yLdNVWF3Srea0uzk55zFn   \n",
              "3   spotify:track:3nqQXoyQOWXiESFLlDF1hG   \n",
              "4   spotify:track:1Qrg8KqiBpW07V7PNxwwwL   \n",
              "5   spotify:track:4uUG5RXrOk84mYEfFvj3cK   \n",
              "6   spotify:track:0WtM2NBVQNNJLh6scP13H8   \n",
              "7   spotify:track:2dHHgzDwk4BJdRwy9uXhTO   \n",
              "8   spotify:track:5Z2MiIZ5I3jJvvmeWMLbOQ   \n",
              "9   spotify:track:78Sw5GDo6AlGwTwanjXbGh   \n",
              "10  spotify:track:0V3wPSX9ygBnCm8psDIegu   \n",
              "11  spotify:track:4LRPiXqCikLlN15c3yImP7   \n",
              "12  spotify:track:7aDxQPHQmH5YZGf9yxIRnn   \n",
              "13  spotify:track:1xzi1Jcr7mEi9K2RfzLOqS   \n",
              "14  spotify:track:4k6Uh1HXdhtusDW5y8Gbvy   \n",
              "15  spotify:track:0QHEIqNKsMoOY5urbzN48u   \n",
              "16  spotify:track:2K8K4pPrufVNrVu2MV8u7I   \n",
              "17  spotify:track:0JXXNGljqupsJaZsgSbMZV   \n",
              "18  spotify:track:0QBzMgT7NIeoCYy3sJCof1   \n",
              "19  spotify:track:4FyesJzVpA39hbYvcseO2d   \n",
              "\n",
              "                                  artists  popularity  danceability  energy  \\\n",
              "0             [PinkPantheress, Ice Spice]          95         0.696   0.809   \n",
              "1             [The Weeknd, Ariana Grande]          94         0.531   0.525   \n",
              "2                           [Miley Cyrus]         100         0.707   0.681   \n",
              "3                 [Sam Smith, Kim Petras]          92         0.714   0.472   \n",
              "4                                   [SZA]          93         0.644   0.735   \n",
              "5              [David Guetta, Bebe Rexha]          93         0.561   0.965   \n",
              "6                    [Rema, Selena Gomez]          93         0.801   0.806   \n",
              "7   [Metro Boomin, The Weeknd, 21 Savage]          94         0.715   0.620   \n",
              "8                       [RAYE, 070 Shake]          90         0.538   0.742   \n",
              "9                                  [d4vd]          92         0.574   0.469   \n",
              "10                         [Taylor Swift]          92         0.637   0.643   \n",
              "11                         [Harry Styles]          90         0.520   0.731   \n",
              "12                  [Besomorph, Treetalk]          53         0.738   0.678   \n",
              "13                              [Beyoncé]          89         0.780   0.689   \n",
              "14                           [Steve Lacy]          83         0.686   0.494   \n",
              "15                       [Meghan Trainor]          89         0.838   0.525   \n",
              "16                                [Meric]          46         0.545   0.890   \n",
              "17                               [Miguel]          90         0.684   0.607   \n",
              "18           [Camila Cabello, Ed Sheeran]          79         0.756   0.697   \n",
              "19                         [Lil Uzi Vert]          90         0.486   0.545   \n",
              "\n",
              "    key  loudness  mode  speechiness  acousticness  instrumentalness  \\\n",
              "0     5    -8.254     1       0.0500       0.25200          0.000128   \n",
              "1     1    -6.500     0       0.0671       0.23200          0.000000   \n",
              "2     0    -4.325     1       0.0668       0.06320          0.000005   \n",
              "3     2    -7.375     1       0.0864       0.01300          0.000005   \n",
              "4     8    -5.747     1       0.0391       0.05210          0.144000   \n",
              "5     7    -3.673     0       0.0343       0.00383          0.000007   \n",
              "6    11    -5.206     1       0.0381       0.38200          0.000669   \n",
              "7     1    -6.005     0       0.0484       0.41700          0.000000   \n",
              "8     2    -5.355     1       0.1140       0.13800          0.000047   \n",
              "9     4    -8.209     1       0.0254       0.53400          0.000092   \n",
              "10    4    -6.571     1       0.0519       0.13000          0.000002   \n",
              "11    6    -5.338     0       0.0557       0.34200          0.001010   \n",
              "12    7    -6.107     0       0.0406       0.30300          0.000000   \n",
              "13    7    -5.668     1       0.1410       0.03680          0.000010   \n",
              "14    1    -7.093     1       0.0355       0.61300          0.000058   \n",
              "15   10    -3.562     1       0.0665       0.34500          0.000002   \n",
              "16    9    -5.395     0       0.1010       0.20500          0.000002   \n",
              "17   11    -8.127     0       0.1000       0.02670          0.000307   \n",
              "18    8    -6.377     1       0.0401       0.18200          0.000000   \n",
              "19   11    -7.924     1       0.0336       0.06520          0.004740   \n",
              "\n",
              "    liveness  valence    tempo  duration_ms  time_signature  \n",
              "0     0.2480   0.8570  132.962       131013               4  \n",
              "1     0.4410   0.5020   66.900       232857               4  \n",
              "2     0.0322   0.6460  117.999       200455               4  \n",
              "3     0.2660   0.2380  131.121       156943               4  \n",
              "4     0.1610   0.4180   88.980       153947               4  \n",
              "5     0.3710   0.3040  128.040       175238               4  \n",
              "6     0.1140   0.8020  106.999       239318               4  \n",
              "7     0.0822   0.1720   97.950       221520               4  \n",
              "8     0.0934   0.2500   96.107       272373               4  \n",
              "9     0.1280   0.2880  132.023       242485               4  \n",
              "10    0.1420   0.5330   97.008       200690               4  \n",
              "11    0.3110   0.6620  173.930       167303               4  \n",
              "12    0.2720   0.2640  110.023       161727               4  \n",
              "13    0.0698   0.6420  115.042       225389               4  \n",
              "14    0.4020   0.7000  168.946       232067               4  \n",
              "15    0.0771   0.8840  144.981       134256               4  \n",
              "16    0.2520   0.2970  147.056       184779               4  \n",
              "17    0.1910   0.4980   81.001       195373               4  \n",
              "18    0.3330   0.9560   94.996       206071               4  \n",
              "19    0.0642   0.0385  150.187       123891               4  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-32b7036f-881d-48c1-bc18-f98aab662fc6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>names</th>\n",
              "      <th>uri</th>\n",
              "      <th>artists</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>energy</th>\n",
              "      <th>key</th>\n",
              "      <th>loudness</th>\n",
              "      <th>mode</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>valence</th>\n",
              "      <th>tempo</th>\n",
              "      <th>duration_ms</th>\n",
              "      <th>time_signature</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Boy's a liar Pt. 2</td>\n",
              "      <td>spotify:track:6AQbmUe0Qwf5PZnt4HmTXv</td>\n",
              "      <td>[PinkPantheress, Ice Spice]</td>\n",
              "      <td>95</td>\n",
              "      <td>0.696</td>\n",
              "      <td>0.809</td>\n",
              "      <td>5</td>\n",
              "      <td>-8.254</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0500</td>\n",
              "      <td>0.25200</td>\n",
              "      <td>0.000128</td>\n",
              "      <td>0.2480</td>\n",
              "      <td>0.8570</td>\n",
              "      <td>132.962</td>\n",
              "      <td>131013</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Die For You - Remix</td>\n",
              "      <td>spotify:track:7oDd86yk8itslrA9HRP2ki</td>\n",
              "      <td>[The Weeknd, Ariana Grande]</td>\n",
              "      <td>94</td>\n",
              "      <td>0.531</td>\n",
              "      <td>0.525</td>\n",
              "      <td>1</td>\n",
              "      <td>-6.500</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0671</td>\n",
              "      <td>0.23200</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.4410</td>\n",
              "      <td>0.5020</td>\n",
              "      <td>66.900</td>\n",
              "      <td>232857</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Flowers</td>\n",
              "      <td>spotify:track:0yLdNVWF3Srea0uzk55zFn</td>\n",
              "      <td>[Miley Cyrus]</td>\n",
              "      <td>100</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.06320</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>0.0322</td>\n",
              "      <td>0.6460</td>\n",
              "      <td>117.999</td>\n",
              "      <td>200455</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Unholy (feat. Kim Petras)</td>\n",
              "      <td>spotify:track:3nqQXoyQOWXiESFLlDF1hG</td>\n",
              "      <td>[Sam Smith, Kim Petras]</td>\n",
              "      <td>92</td>\n",
              "      <td>0.714</td>\n",
              "      <td>0.472</td>\n",
              "      <td>2</td>\n",
              "      <td>-7.375</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0864</td>\n",
              "      <td>0.01300</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>0.2660</td>\n",
              "      <td>0.2380</td>\n",
              "      <td>131.121</td>\n",
              "      <td>156943</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Kill Bill</td>\n",
              "      <td>spotify:track:1Qrg8KqiBpW07V7PNxwwwL</td>\n",
              "      <td>[SZA]</td>\n",
              "      <td>93</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.05210</td>\n",
              "      <td>0.144000</td>\n",
              "      <td>0.1610</td>\n",
              "      <td>0.4180</td>\n",
              "      <td>88.980</td>\n",
              "      <td>153947</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>I'm Good (Blue)</td>\n",
              "      <td>spotify:track:4uUG5RXrOk84mYEfFvj3cK</td>\n",
              "      <td>[David Guetta, Bebe Rexha]</td>\n",
              "      <td>93</td>\n",
              "      <td>0.561</td>\n",
              "      <td>0.965</td>\n",
              "      <td>7</td>\n",
              "      <td>-3.673</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0343</td>\n",
              "      <td>0.00383</td>\n",
              "      <td>0.000007</td>\n",
              "      <td>0.3710</td>\n",
              "      <td>0.3040</td>\n",
              "      <td>128.040</td>\n",
              "      <td>175238</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Calm Down (with Selena Gomez)</td>\n",
              "      <td>spotify:track:0WtM2NBVQNNJLh6scP13H8</td>\n",
              "      <td>[Rema, Selena Gomez]</td>\n",
              "      <td>93</td>\n",
              "      <td>0.801</td>\n",
              "      <td>0.806</td>\n",
              "      <td>11</td>\n",
              "      <td>-5.206</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0381</td>\n",
              "      <td>0.38200</td>\n",
              "      <td>0.000669</td>\n",
              "      <td>0.1140</td>\n",
              "      <td>0.8020</td>\n",
              "      <td>106.999</td>\n",
              "      <td>239318</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Creepin' (with The Weeknd &amp; 21 Savage)</td>\n",
              "      <td>spotify:track:2dHHgzDwk4BJdRwy9uXhTO</td>\n",
              "      <td>[Metro Boomin, The Weeknd, 21 Savage]</td>\n",
              "      <td>94</td>\n",
              "      <td>0.715</td>\n",
              "      <td>0.620</td>\n",
              "      <td>1</td>\n",
              "      <td>-6.005</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0484</td>\n",
              "      <td>0.41700</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0822</td>\n",
              "      <td>0.1720</td>\n",
              "      <td>97.950</td>\n",
              "      <td>221520</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Escapism.</td>\n",
              "      <td>spotify:track:5Z2MiIZ5I3jJvvmeWMLbOQ</td>\n",
              "      <td>[RAYE, 070 Shake]</td>\n",
              "      <td>90</td>\n",
              "      <td>0.538</td>\n",
              "      <td>0.742</td>\n",
              "      <td>2</td>\n",
              "      <td>-5.355</td>\n",
              "      <td>1</td>\n",
              "      <td>0.1140</td>\n",
              "      <td>0.13800</td>\n",
              "      <td>0.000047</td>\n",
              "      <td>0.0934</td>\n",
              "      <td>0.2500</td>\n",
              "      <td>96.107</td>\n",
              "      <td>272373</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Here With Me</td>\n",
              "      <td>spotify:track:78Sw5GDo6AlGwTwanjXbGh</td>\n",
              "      <td>[d4vd]</td>\n",
              "      <td>92</td>\n",
              "      <td>0.574</td>\n",
              "      <td>0.469</td>\n",
              "      <td>4</td>\n",
              "      <td>-8.209</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0254</td>\n",
              "      <td>0.53400</td>\n",
              "      <td>0.000092</td>\n",
              "      <td>0.1280</td>\n",
              "      <td>0.2880</td>\n",
              "      <td>132.023</td>\n",
              "      <td>242485</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Anti-Hero</td>\n",
              "      <td>spotify:track:0V3wPSX9ygBnCm8psDIegu</td>\n",
              "      <td>[Taylor Swift]</td>\n",
              "      <td>92</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.13000</td>\n",
              "      <td>0.000002</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>0.5330</td>\n",
              "      <td>97.008</td>\n",
              "      <td>200690</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>As It Was</td>\n",
              "      <td>spotify:track:4LRPiXqCikLlN15c3yImP7</td>\n",
              "      <td>[Harry Styles]</td>\n",
              "      <td>90</td>\n",
              "      <td>0.520</td>\n",
              "      <td>0.731</td>\n",
              "      <td>6</td>\n",
              "      <td>-5.338</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0557</td>\n",
              "      <td>0.34200</td>\n",
              "      <td>0.001010</td>\n",
              "      <td>0.3110</td>\n",
              "      <td>0.6620</td>\n",
              "      <td>173.930</td>\n",
              "      <td>167303</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Falling Apart</td>\n",
              "      <td>spotify:track:7aDxQPHQmH5YZGf9yxIRnn</td>\n",
              "      <td>[Besomorph, Treetalk]</td>\n",
              "      <td>53</td>\n",
              "      <td>0.738</td>\n",
              "      <td>0.678</td>\n",
              "      <td>7</td>\n",
              "      <td>-6.107</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0406</td>\n",
              "      <td>0.30300</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2720</td>\n",
              "      <td>0.2640</td>\n",
              "      <td>110.023</td>\n",
              "      <td>161727</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>CUFF IT</td>\n",
              "      <td>spotify:track:1xzi1Jcr7mEi9K2RfzLOqS</td>\n",
              "      <td>[Beyoncé]</td>\n",
              "      <td>89</td>\n",
              "      <td>0.780</td>\n",
              "      <td>0.689</td>\n",
              "      <td>7</td>\n",
              "      <td>-5.668</td>\n",
              "      <td>1</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>0.03680</td>\n",
              "      <td>0.000010</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.6420</td>\n",
              "      <td>115.042</td>\n",
              "      <td>225389</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Bad Habit</td>\n",
              "      <td>spotify:track:4k6Uh1HXdhtusDW5y8Gbvy</td>\n",
              "      <td>[Steve Lacy]</td>\n",
              "      <td>83</td>\n",
              "      <td>0.686</td>\n",
              "      <td>0.494</td>\n",
              "      <td>1</td>\n",
              "      <td>-7.093</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0355</td>\n",
              "      <td>0.61300</td>\n",
              "      <td>0.000058</td>\n",
              "      <td>0.4020</td>\n",
              "      <td>0.7000</td>\n",
              "      <td>168.946</td>\n",
              "      <td>232067</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Made You Look</td>\n",
              "      <td>spotify:track:0QHEIqNKsMoOY5urbzN48u</td>\n",
              "      <td>[Meghan Trainor]</td>\n",
              "      <td>89</td>\n",
              "      <td>0.838</td>\n",
              "      <td>0.525</td>\n",
              "      <td>10</td>\n",
              "      <td>-3.562</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0665</td>\n",
              "      <td>0.34500</td>\n",
              "      <td>0.000002</td>\n",
              "      <td>0.0771</td>\n",
              "      <td>0.8840</td>\n",
              "      <td>144.981</td>\n",
              "      <td>134256</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>tell me who hurt you</td>\n",
              "      <td>spotify:track:2K8K4pPrufVNrVu2MV8u7I</td>\n",
              "      <td>[Meric]</td>\n",
              "      <td>46</td>\n",
              "      <td>0.545</td>\n",
              "      <td>0.890</td>\n",
              "      <td>9</td>\n",
              "      <td>-5.395</td>\n",
              "      <td>0</td>\n",
              "      <td>0.1010</td>\n",
              "      <td>0.20500</td>\n",
              "      <td>0.000002</td>\n",
              "      <td>0.2520</td>\n",
              "      <td>0.2970</td>\n",
              "      <td>147.056</td>\n",
              "      <td>184779</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Sure Thing</td>\n",
              "      <td>spotify:track:0JXXNGljqupsJaZsgSbMZV</td>\n",
              "      <td>[Miguel]</td>\n",
              "      <td>90</td>\n",
              "      <td>0.684</td>\n",
              "      <td>0.607</td>\n",
              "      <td>11</td>\n",
              "      <td>-8.127</td>\n",
              "      <td>0</td>\n",
              "      <td>0.1000</td>\n",
              "      <td>0.02670</td>\n",
              "      <td>0.000307</td>\n",
              "      <td>0.1910</td>\n",
              "      <td>0.4980</td>\n",
              "      <td>81.001</td>\n",
              "      <td>195373</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Bam Bam (feat. Ed Sheeran)</td>\n",
              "      <td>spotify:track:0QBzMgT7NIeoCYy3sJCof1</td>\n",
              "      <td>[Camila Cabello, Ed Sheeran]</td>\n",
              "      <td>79</td>\n",
              "      <td>0.756</td>\n",
              "      <td>0.697</td>\n",
              "      <td>8</td>\n",
              "      <td>-6.377</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0401</td>\n",
              "      <td>0.18200</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.3330</td>\n",
              "      <td>0.9560</td>\n",
              "      <td>94.996</td>\n",
              "      <td>206071</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Just Wanna Rock</td>\n",
              "      <td>spotify:track:4FyesJzVpA39hbYvcseO2d</td>\n",
              "      <td>[Lil Uzi Vert]</td>\n",
              "      <td>90</td>\n",
              "      <td>0.486</td>\n",
              "      <td>0.545</td>\n",
              "      <td>11</td>\n",
              "      <td>-7.924</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0336</td>\n",
              "      <td>0.06520</td>\n",
              "      <td>0.004740</td>\n",
              "      <td>0.0642</td>\n",
              "      <td>0.0385</td>\n",
              "      <td>150.187</td>\n",
              "      <td>123891</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-32b7036f-881d-48c1-bc18-f98aab662fc6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-32b7036f-881d-48c1-bc18-f98aab662fc6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-32b7036f-881d-48c1-bc18-f98aab662fc6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(features_playlist)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Tjty5_t1isjq",
        "outputId": "7b0af3a1-96c9-47c5-f4f8-b958018a3460"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "     danceability  energy  key  loudness  mode  speechiness  acousticness  \\\n",
            "0           0.533   0.638    4    -7.130     1       0.0341       0.20200   \n",
            "1           0.609   0.923    9    -3.908     1       0.0338       0.16000   \n",
            "2           0.549   0.529    3   -12.291     0       0.1080       0.76000   \n",
            "3           0.856   0.609    0    -7.223     1       0.0824       0.00801   \n",
            "4           0.577   0.462    2    -7.989     1       0.0279       0.12800   \n",
            "..            ...     ...  ...       ...   ...          ...           ...   \n",
            "595         0.376   0.246   10    -9.803     1       0.0286       0.86200   \n",
            "596         0.724   0.907   11    -4.780     0       0.0632       0.01870   \n",
            "597         0.631   0.932    5    -4.142     1       0.0354       0.04360   \n",
            "598         0.528   0.863    6    -5.772     0       0.0368       0.06160   \n",
            "599         0.573   0.902    6    -7.638     0       0.0540       0.01800   \n",
            "\n",
            "     instrumentalness  liveness  valence    tempo  duration_ms  time_signature  \n",
            "0            0.000000    0.0729    0.937  156.663       153760               4  \n",
            "1            0.000005    0.2950    0.961  115.996       294987               4  \n",
            "2            0.000000    0.2060    0.464   82.755       184333               4  \n",
            "3            0.000082    0.0344    0.928  114.988       269667               4  \n",
            "4            0.000000    0.0822    0.258  128.303       266973               4  \n",
            "..                ...       ...      ...      ...          ...             ...  \n",
            "595          0.000000    0.1550    0.282   80.167       168093               1  \n",
            "596          0.000005    0.0824    0.962  139.016       244827               4  \n",
            "597          0.137000    0.0918    0.971  122.429       213067               4  \n",
            "598          0.000007    0.3550    0.575   95.468       257400               4  \n",
            "599          0.001250    0.0928    0.876   84.412       225280               4  \n",
            "\n",
            "[600 rows x 13 columns]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#General playlist creation\n",
        "playlist_df.to_csv(\"collab.csv\", index=False)"
      ],
      "metadata": {
        "id": "VmZI2Sumtm4K"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Current top songs\n",
        "Hothits_df = playlist_analyzer(\"spotify\", \"https://open.spotify.com/playlist/37i9dQZF1DX0ieekvzt1Ic?si=dfd6d0e9ec974915\")\n",
        "Hothits_features_playlist = playlist_df.iloc[:,4:17].copy() #Creating a subset of the df with only the features "
      ],
      "metadata": {
        "id": "kHDxtNoTx03G"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "Hothits_df.to_csv(\"hothits.csv\", index=False) # hothits playlist"
      ],
      "metadata": {
        "id": "Yvb_Bbvp-fH2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(Hothits_df.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pq2lE2dL-UmX",
        "outputId": "79aa4bc7-28b3-4dfb-b631-149883ab75aa"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 51 entries, 0 to 50\n",
            "Data columns (total 17 columns):\n",
            " #   Column            Non-Null Count  Dtype  \n",
            "---  ------            --------------  -----  \n",
            " 0   names             51 non-null     object \n",
            " 1   uri               51 non-null     object \n",
            " 2   artists           51 non-null     object \n",
            " 3   popularity        51 non-null     int64  \n",
            " 4   danceability      51 non-null     float64\n",
            " 5   energy            51 non-null     float64\n",
            " 6   key               51 non-null     int64  \n",
            " 7   loudness          51 non-null     float64\n",
            " 8   mode              51 non-null     int64  \n",
            " 9   speechiness       51 non-null     float64\n",
            " 10  acousticness      51 non-null     float64\n",
            " 11  instrumentalness  51 non-null     float64\n",
            " 12  liveness          51 non-null     float64\n",
            " 13  valence           51 non-null     float64\n",
            " 14  tempo             51 non-null     float64\n",
            " 15  duration_ms       51 non-null     int64  \n",
            " 16  time_signature    51 non-null     int64  \n",
            "dtypes: float64(9), int64(5), object(3)\n",
            "memory usage: 6.9+ KB\n",
            "None\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "li=[]\n",
        "for i in range(0,51):\n",
        "    li.append(Hothits_df.loc[i, 'names']+\" \"+Hothits_df.loc[i,'artists'][0])\n",
        "\n",
        "Hothits_df['names+artist']=li"
      ],
      "metadata": {
        "id": "aDMi3xmlBVA9"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "combined = pd.concat([df,Hothits_df])"
      ],
      "metadata": {
        "id": "HmKYqbgoBHt9"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "combined.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vWtQ0qZXBkxl",
        "outputId": "cb88e74d-297c-4120-f148-81f32a5d5919"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 651 entries, 0 to 50\n",
            "Data columns (total 19 columns):\n",
            " #   Column            Non-Null Count  Dtype  \n",
            "---  ------            --------------  -----  \n",
            " 0   names             651 non-null    object \n",
            " 1   uri               651 non-null    object \n",
            " 2   artists           651 non-null    object \n",
            " 3   popularity        651 non-null    int64  \n",
            " 4   danceability      651 non-null    float64\n",
            " 5   energy            651 non-null    float64\n",
            " 6   key               651 non-null    int64  \n",
            " 7   loudness          651 non-null    float64\n",
            " 8   mode              651 non-null    int64  \n",
            " 9   speechiness       651 non-null    float64\n",
            " 10  acousticness      651 non-null    float64\n",
            " 11  instrumentalness  651 non-null    float64\n",
            " 12  liveness          651 non-null    float64\n",
            " 13  valence           651 non-null    float64\n",
            " 14  tempo             651 non-null    float64\n",
            " 15  duration_ms       651 non-null    int64  \n",
            " 16  time_signature    651 non-null    int64  \n",
            " 17  names+artist      651 non-null    object \n",
            " 18  cluster           600 non-null    float64\n",
            "dtypes: float64(10), int64(5), object(4)\n",
            "memory usage: 101.7+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "features_playlist = combined.iloc[:,4:17].copy() #Creating a subset of the df with only the features "
      ],
      "metadata": {
        "id": "6DiXRTBfBx-n"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Initialize the model, fit and transform data\n",
        "scaler = StandardScaler()\n",
        "scaler.fit(features_playlist)\n",
        "features_scaled = scaler.transform(features_playlist)\n",
        "features_scaled_df = pd.DataFrame(features_playlist)"
      ],
      "metadata": {
        "id": "RtnOZ1NCiUv3"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "features_scaled_df.head(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 207
        },
        "id": "Gb-NHYVGiWk5",
        "outputId": "19635800-ffac-4bc9-9856-54fec2c7d79a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   danceability  energy  key  loudness  mode  speechiness  acousticness  \\\n",
              "0         0.533   0.638    4    -7.130     1       0.0341         0.202   \n",
              "1         0.609   0.923    9    -3.908     1       0.0338         0.160   \n",
              "2         0.549   0.529    3   -12.291     0       0.1080         0.760   \n",
              "\n",
              "   instrumentalness  liveness  valence    tempo  duration_ms  time_signature  \n",
              "0          0.000000    0.0729    0.937  156.663       153760               4  \n",
              "1          0.000005    0.2950    0.961  115.996       294987               4  \n",
              "2          0.000000    0.2060    0.464   82.755       184333               4  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2ac6e0c9-d7a2-46d4-812f-839780e10cd7\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>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",
              "      <th>time_signature</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0.533</td>\n",
              "      <td>0.638</td>\n",
              "      <td>4</td>\n",
              "      <td>-7.130</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0341</td>\n",
              "      <td>0.202</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0729</td>\n",
              "      <td>0.937</td>\n",
              "      <td>156.663</td>\n",
              "      <td>153760</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.609</td>\n",
              "      <td>0.923</td>\n",
              "      <td>9</td>\n",
              "      <td>-3.908</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0338</td>\n",
              "      <td>0.160</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>0.2950</td>\n",
              "      <td>0.961</td>\n",
              "      <td>115.996</td>\n",
              "      <td>294987</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.549</td>\n",
              "      <td>0.529</td>\n",
              "      <td>3</td>\n",
              "      <td>-12.291</td>\n",
              "      <td>0</td>\n",
              "      <td>0.1080</td>\n",
              "      <td>0.760</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2060</td>\n",
              "      <td>0.464</td>\n",
              "      <td>82.755</td>\n",
              "      <td>184333</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2ac6e0c9-d7a2-46d4-812f-839780e10cd7')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2ac6e0c9-d7a2-46d4-812f-839780e10cd7 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2ac6e0c9-d7a2-46d4-812f-839780e10cd7');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 129
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "features_scaled_df[['loudness','key']].shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "arZvvTVLw-iD",
        "outputId": "90fda148-59c2-4606-ea1d-cc4c15b7ffe7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(651, 2)"
            ]
          },
          "metadata": {},
          "execution_count": 130
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Initializing the model, fit and predict clusters\n",
        "kmeans = KMeans()\n",
        "kmeans.fit(features_scaled_df[['loudness','key']])\n",
        "clusters = kmeans.predict(features_scaled_df[['loudness','key']])\n",
        "combined[\"cluster\"]=clusters"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "D02t_fh3ij5E",
        "outputId": "2cdf2b9e-e863-48d5-9abc-6dfb20368b0f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.9/dist-packages/sklearn/cluster/_kmeans.py:870: FutureWarning: The default value of `n_init` will change from 10 to 'auto' in 1.4. Set the value of `n_init` explicitly to suppress the warning\n",
            "  warnings.warn(\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Check the size of the clusters\n",
        "pd.Series(clusters).value_counts().sort_index()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vNDQGFkPilY5",
        "outputId": "fed864dd-ea7a-49ae-9a1a-f49767a5b09e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0     66\n",
              "1     89\n",
              "2     94\n",
              "3     55\n",
              "4     38\n",
              "5     97\n",
              "6    113\n",
              "7     99\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 133
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "combined.head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 791
        },
        "id": "C5WdHk74c7Ue",
        "outputId": "750a6fcf-df44-4290-81b5-da0568134df9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                            names                                   uri  \\\n",
              "0                       The Twist  spotify:track:3ohLnESFgYACPMCkoTOzqE   \n",
              "1       Smooth (feat. Rob Thomas)  spotify:track:0n2SEXB2qoRQg171q7XqeW   \n",
              "2                  Mack the Knife  spotify:track:3E5ndyOfO6vFDEIE42HA8o   \n",
              "3  Uptown Funk (feat. Bruno Mars)  spotify:track:32OlwWuMpZ6b0aN2RZOeMS   \n",
              "4                   How Do I Live  spotify:track:7BD50ATrF3Vab5FQy7vtK8   \n",
              "5               Party Rock Anthem  spotify:track:0IkKz2J93C94Ei4BvDop7P   \n",
              "6                 I Gotta Feeling  spotify:track:4vp2J1l5RD4gMZwGFLfRAu   \n",
              "7   Macarena - Bayside Boys Remix  spotify:track:2df5QsXucx4VLiHNGusXD5   \n",
              "8                    Shape of You  spotify:track:7qiZfU4dY1lWllzX7mPBI3   \n",
              "9                        Physical  spotify:track:3hVrI7snZMTmHCnbwME47u   \n",
              "\n",
              "                             artists  popularity  danceability  energy  key  \\\n",
              "0                   [Chubby Checker]          51         0.533   0.638    4   \n",
              "1              [Santana, Rob Thomas]          67         0.609   0.923    9   \n",
              "2                      [Bobby Darin]          60         0.549   0.529    3   \n",
              "3          [Mark Ronson, Bruno Mars]          80         0.856   0.609    0   \n",
              "4                      [LeAnn Rimes]          67         0.577   0.462    2   \n",
              "5  [LMFAO, Lauren Bennett, GoonRock]          67         0.750   0.727    5   \n",
              "6                  [Black Eyed Peas]           5         0.743   0.766    0   \n",
              "7                      [Los Del Rio]          55         0.737   0.930    1   \n",
              "8                       [Ed Sheeran]          85         0.825   0.652    1   \n",
              "9               [Olivia Newton-John]           0         0.834   0.633    4   \n",
              "\n",
              "   loudness  mode  speechiness  acousticness  instrumentalness  liveness  \\\n",
              "0    -7.130     1       0.0341       0.20200          0.000000    0.0729   \n",
              "1    -3.908     1       0.0338       0.16000          0.000005    0.2950   \n",
              "2   -12.291     0       0.1080       0.76000          0.000000    0.2060   \n",
              "3    -7.223     1       0.0824       0.00801          0.000082    0.0344   \n",
              "4    -7.989     1       0.0279       0.12800          0.000000    0.0822   \n",
              "5    -4.210     0       0.1420       0.01890          0.000000    0.2660   \n",
              "6    -6.375     1       0.0265       0.08730          0.000000    0.5090   \n",
              "7    -6.083     1       0.0534       0.23700          0.000002    0.0911   \n",
              "8    -3.183     0       0.0802       0.58100          0.000000    0.0931   \n",
              "9   -11.442     0       0.0422       0.06310          0.000050    0.3130   \n",
              "\n",
              "   valence    tempo  duration_ms  time_signature  \\\n",
              "0    0.937  156.663       153760               4   \n",
              "1    0.961  115.996       294987               4   \n",
              "2    0.464   82.755       184333               4   \n",
              "3    0.928  114.988       269667               4   \n",
              "4    0.258  128.303       266973               4   \n",
              "5    0.359  129.993       262173               4   \n",
              "6    0.610  127.960       289133               4   \n",
              "7    0.965  103.191       253107               4   \n",
              "8    0.931   95.977       233713               4   \n",
              "9    0.904  123.815       224773               4   \n",
              "\n",
              "                                 names+artist  cluster  \n",
              "0                    The Twist Chubby Checker        2  \n",
              "1           Smooth (feat. Rob Thomas) Santana        5  \n",
              "2                  Mack the Knife Bobby Darin        3  \n",
              "3  Uptown Funk (feat. Bruno Mars) Mark Ronson        6  \n",
              "4                   How Do I Live LeAnn Rimes        1  \n",
              "5                     Party Rock Anthem LMFAO        2  \n",
              "6             I Gotta Feeling Black Eyed Peas        6  \n",
              "7   Macarena - Bayside Boys Remix Los Del Rio        6  \n",
              "8                     Shape of You Ed Sheeran        6  \n",
              "9                 Physical Olivia Newton-John        3  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3eabadc8-04e3-4190-bf40-f7f81bdf5923\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>names</th>\n",
              "      <th>uri</th>\n",
              "      <th>artists</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>energy</th>\n",
              "      <th>key</th>\n",
              "      <th>loudness</th>\n",
              "      <th>mode</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>valence</th>\n",
              "      <th>tempo</th>\n",
              "      <th>duration_ms</th>\n",
              "      <th>time_signature</th>\n",
              "      <th>names+artist</th>\n",
              "      <th>cluster</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>The Twist</td>\n",
              "      <td>spotify:track:3ohLnESFgYACPMCkoTOzqE</td>\n",
              "      <td>[Chubby Checker]</td>\n",
              "      <td>51</td>\n",
              "      <td>0.533</td>\n",
              "      <td>0.638</td>\n",
              "      <td>4</td>\n",
              "      <td>-7.130</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0341</td>\n",
              "      <td>0.20200</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0729</td>\n",
              "      <td>0.937</td>\n",
              "      <td>156.663</td>\n",
              "      <td>153760</td>\n",
              "      <td>4</td>\n",
              "      <td>The Twist Chubby Checker</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Smooth (feat. Rob Thomas)</td>\n",
              "      <td>spotify:track:0n2SEXB2qoRQg171q7XqeW</td>\n",
              "      <td>[Santana, Rob Thomas]</td>\n",
              "      <td>67</td>\n",
              "      <td>0.609</td>\n",
              "      <td>0.923</td>\n",
              "      <td>9</td>\n",
              "      <td>-3.908</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0338</td>\n",
              "      <td>0.16000</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>0.2950</td>\n",
              "      <td>0.961</td>\n",
              "      <td>115.996</td>\n",
              "      <td>294987</td>\n",
              "      <td>4</td>\n",
              "      <td>Smooth (feat. Rob Thomas) Santana</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mack the Knife</td>\n",
              "      <td>spotify:track:3E5ndyOfO6vFDEIE42HA8o</td>\n",
              "      <td>[Bobby Darin]</td>\n",
              "      <td>60</td>\n",
              "      <td>0.549</td>\n",
              "      <td>0.529</td>\n",
              "      <td>3</td>\n",
              "      <td>-12.291</td>\n",
              "      <td>0</td>\n",
              "      <td>0.1080</td>\n",
              "      <td>0.76000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2060</td>\n",
              "      <td>0.464</td>\n",
              "      <td>82.755</td>\n",
              "      <td>184333</td>\n",
              "      <td>4</td>\n",
              "      <td>Mack the Knife Bobby Darin</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Uptown Funk (feat. Bruno Mars)</td>\n",
              "      <td>spotify:track:32OlwWuMpZ6b0aN2RZOeMS</td>\n",
              "      <td>[Mark Ronson, Bruno Mars]</td>\n",
              "      <td>80</td>\n",
              "      <td>0.856</td>\n",
              "      <td>0.609</td>\n",
              "      <td>0</td>\n",
              "      <td>-7.223</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0824</td>\n",
              "      <td>0.00801</td>\n",
              "      <td>0.000082</td>\n",
              "      <td>0.0344</td>\n",
              "      <td>0.928</td>\n",
              "      <td>114.988</td>\n",
              "      <td>269667</td>\n",
              "      <td>4</td>\n",
              "      <td>Uptown Funk (feat. Bruno Mars) Mark Ronson</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>How Do I Live</td>\n",
              "      <td>spotify:track:7BD50ATrF3Vab5FQy7vtK8</td>\n",
              "      <td>[LeAnn Rimes]</td>\n",
              "      <td>67</td>\n",
              "      <td>0.577</td>\n",
              "      <td>0.462</td>\n",
              "      <td>2</td>\n",
              "      <td>-7.989</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0279</td>\n",
              "      <td>0.12800</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0822</td>\n",
              "      <td>0.258</td>\n",
              "      <td>128.303</td>\n",
              "      <td>266973</td>\n",
              "      <td>4</td>\n",
              "      <td>How Do I Live LeAnn Rimes</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Party Rock Anthem</td>\n",
              "      <td>spotify:track:0IkKz2J93C94Ei4BvDop7P</td>\n",
              "      <td>[LMFAO, Lauren Bennett, GoonRock]</td>\n",
              "      <td>67</td>\n",
              "      <td>0.750</td>\n",
              "      <td>0.727</td>\n",
              "      <td>5</td>\n",
              "      <td>-4.210</td>\n",
              "      <td>0</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>0.01890</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2660</td>\n",
              "      <td>0.359</td>\n",
              "      <td>129.993</td>\n",
              "      <td>262173</td>\n",
              "      <td>4</td>\n",
              "      <td>Party Rock Anthem LMFAO</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>I Gotta Feeling</td>\n",
              "      <td>spotify:track:4vp2J1l5RD4gMZwGFLfRAu</td>\n",
              "      <td>[Black Eyed Peas]</td>\n",
              "      <td>5</td>\n",
              "      <td>0.743</td>\n",
              "      <td>0.766</td>\n",
              "      <td>0</td>\n",
              "      <td>-6.375</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0265</td>\n",
              "      <td>0.08730</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.5090</td>\n",
              "      <td>0.610</td>\n",
              "      <td>127.960</td>\n",
              "      <td>289133</td>\n",
              "      <td>4</td>\n",
              "      <td>I Gotta Feeling Black Eyed Peas</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Macarena - Bayside Boys Remix</td>\n",
              "      <td>spotify:track:2df5QsXucx4VLiHNGusXD5</td>\n",
              "      <td>[Los Del Rio]</td>\n",
              "      <td>55</td>\n",
              "      <td>0.737</td>\n",
              "      <td>0.930</td>\n",
              "      <td>1</td>\n",
              "      <td>-6.083</td>\n",
              "      <td>1</td>\n",
              "      <td>0.0534</td>\n",
              "      <td>0.23700</td>\n",
              "      <td>0.000002</td>\n",
              "      <td>0.0911</td>\n",
              "      <td>0.965</td>\n",
              "      <td>103.191</td>\n",
              "      <td>253107</td>\n",
              "      <td>4</td>\n",
              "      <td>Macarena - Bayside Boys Remix Los Del Rio</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Shape of You</td>\n",
              "      <td>spotify:track:7qiZfU4dY1lWllzX7mPBI3</td>\n",
              "      <td>[Ed Sheeran]</td>\n",
              "      <td>85</td>\n",
              "      <td>0.825</td>\n",
              "      <td>0.652</td>\n",
              "      <td>1</td>\n",
              "      <td>-3.183</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0802</td>\n",
              "      <td>0.58100</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0931</td>\n",
              "      <td>0.931</td>\n",
              "      <td>95.977</td>\n",
              "      <td>233713</td>\n",
              "      <td>4</td>\n",
              "      <td>Shape of You Ed Sheeran</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Physical</td>\n",
              "      <td>spotify:track:3hVrI7snZMTmHCnbwME47u</td>\n",
              "      <td>[Olivia Newton-John]</td>\n",
              "      <td>0</td>\n",
              "      <td>0.834</td>\n",
              "      <td>0.633</td>\n",
              "      <td>4</td>\n",
              "      <td>-11.442</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0422</td>\n",
              "      <td>0.06310</td>\n",
              "      <td>0.000050</td>\n",
              "      <td>0.3130</td>\n",
              "      <td>0.904</td>\n",
              "      <td>123.815</td>\n",
              "      <td>224773</td>\n",
              "      <td>4</td>\n",
              "      <td>Physical Olivia Newton-John</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3eabadc8-04e3-4190-bf40-f7f81bdf5923')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3eabadc8-04e3-4190-bf40-f7f81bdf5923 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3eabadc8-04e3-4190-bf40-f7f81bdf5923');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 134
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df=df.drop(['cosine'],axis=1)"
      ],
      "metadata": {
        "id": "eKrxDe-s99Q2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "playlist_df.to_csv(\"clustered.csv\", index=False) # clustered playlist\n",
        "#features_scaled_df.to_csv(\"features_scales_df.csv\", index=False)"
      ],
      "metadata": {
        "id": "Fu4wmOtvinlH"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "https://open.spotify.com/playlist/37i9dQZF1DX0ieekvzt1Ic?si=dfd6d0e9ec974915"
      ],
      "metadata": {
        "id": "DXFrLbXjtpRZ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "u_labels = np.unique(df['cluster'])\n",
        "print(u_labels)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "HqVlXZ9W795b",
        "outputId": "8696d5cf-ca1a-491d-bd8d-3d2f1545e4a7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "[0 1]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "droped=df.drop(['names','uri','artists'],axis=1)"
      ],
      "metadata": {
        "id": "kAoRtOBk9Neh"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Collaborative "
      ],
      "metadata": {
        "id": "0edsVK-Yt3ad"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "from sklearn.feature_extraction.text import TfidfVectorizer\n",
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "from sklearn.metrics.pairwise import cosine_similarity\n",
        "vectorizer = TfidfVectorizer()"
      ],
      "metadata": {
        "id": "EYfUdGmo688x"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import librosa\n",
        "import numpy as np\n",
        "from scipy import stats\n",
        "import pandas as pd\n",
        "import glob\n",
        "import spotipy\n",
        "import spotipy.util as util\n",
        "import spotipy\n",
        "from spotipy.oauth2 import SpotifyOAuth\n",
        "from pathlib import Path\n",
        "import nltk\n",
        "from nltk.tokenize import sent_tokenize\n",
        "from nltk.corpus import stopwords \n",
        "from nltk.tokenize import word_tokenize\n",
        "import pickle\n",
        "import math\n",
        "import numpy as np\n",
        "from nltk.tree import *\n",
        "from nltk.stem import WordNetLemmatizer \n",
        "import random\n",
        "import numpy as num\n",
        "from math import exp\n",
        "from nltk.tokenize import RegexpTokenizer \n",
        "from nltk.stem import WordNetLemmatizer "
      ],
      "metadata": {
        "id": "krLjNu6guo8z"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "token=\"BQBFFqEfiu4G7O2Y37NtYLu07mXmk_iCLo4KLdw87wshGCLPx8F1Gd1SpBGejLs9yL3NcJh21ZTuRqFvsUHNBfOPhzWss6r44pWvRYBqKchBfUgN_1vHu0FCkFYY6klc3rxABttJiExhUdC2A0fFFnmMJc4daxRHEnwDRNcKSJiLH5pkN3Em0LGF6pXtsUZjFpA9745fYA\""
      ],
      "metadata": {
        "id": "bgGHvbOR4mMV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "sp = spotipy.Spotify(auth=\"BQBhz6fIu8gzIrUHMph37l9u9EEQ47nCQvmwWuwrsb4DGEhUjyWp46AgwpB0qiCRTs7eNKY65gVsvXAIt4tvfM2_33u4QlgMimDchv8qRdeNednVGFTvRZ9ncKQHRDqZY-vLnPWxCM800l3T04fh_qwueyEKPRatmFyhWrytVih7qXFaSkMQjHDHIplanlXlKCPmOq194g\")"
      ],
      "metadata": {
        "id": "YqSEe00M4lx5"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "results = sp.current_user_top_tracks(limit=1000, offset=0,time_range='short_term')"
      ],
      "metadata": {
        "id": "cpplzq_I4c0s"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Convert it to Dataframe\n",
        "track_name = []\n",
        "track_id = []\n",
        "artist = []\n",
        "album = []\n",
        "duration = []\n",
        "popularity = []\n",
        "for i, items in enumerate(results['items']):\n",
        "        track_name.append(items['name'])\n",
        "        track_id.append(items['id'])\n",
        "        artist.append(items[\"artists\"][0][\"name\"])\n",
        "        duration.append(items[\"duration_ms\"])\n",
        "        album.append(items[\"album\"][\"name\"])\n",
        "        popularity.append(items[\"popularity\"])\n",
        "\n",
        "# Create the final df   \n",
        "df_favourite = pd.DataFrame({ \"track_name\": track_name, \n",
        "                             \"album\": album, \n",
        "                             \"track_id\": track_id,\n",
        "                             \"artist\": artist, \n",
        "                             \"duration\": duration, \n",
        "                             \"popularity\": popularity})\n",
        "\n",
        "df_favourite.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 894
        },
        "id": "9l2cQPml4ugd",
        "outputId": "cbbefad9-f259-4afe-d4f7-50f6f3d8602b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                              track_name  \\\n",
              "0                                 willow   \n",
              "1                 Idhayathai Yedho Ondru   \n",
              "2                              The Hills   \n",
              "3   Vaa Vaathi (Dhanush Reprise Version)   \n",
              "4                   Koodamela Koodavechi   \n",
              "5                             Azhakooril   \n",
              "6                             Nenjukkule   \n",
              "7                     Kannan Varum Velai   \n",
              "8                             London Boy   \n",
              "9                           Nallai Allai   \n",
              "10                 Sara Sara Saara Kathu   \n",
              "11                    Pogatha Yennavittu   \n",
              "12    Agayam Theepiditha - From \"Madras\"   \n",
              "13             Mogathirai - From \"Pizza\"   \n",
              "14                           Ambikapathy   \n",
              "15                       Blinding Lights   \n",
              "16                            The Nights   \n",
              "17                               Nanbane   \n",
              "18                            Photograph   \n",
              "19     Ninaivirukka (From \"Pathu Thala\")   \n",
              "\n",
              "                                                album                track_id  \\\n",
              "0                                            evermore  0lx2cLdOt3piJbcaXIV74f   \n",
              "1   Yennai Arindhaal (Original Motion Picture Soun...  23bpCCVsTUKviTEfoy4tbM   \n",
              "2                           Beauty Behind The Madness  7fBv7CLKzipRk6EC6TWHOB   \n",
              "3                                              Vaathi  43bgjI3ZddPJsu3JvNmYui   \n",
              "4          Rummy (Original Motion Picture Soundtrack)  102YVYHLNfgkfQP3qvDqsD   \n",
              "5     Thirumalai (Original Motion Picture Soundtrack)  7BsQNB20nHHZY9pNcrrrsI   \n",
              "6          Kadal (Original Motion Picture Soundtrack)  7FEWG1bL31YAcnxJQvxJJO   \n",
              "7      Deepavali (Original Motion Picture Soundtrack)  72niNpc1LP2DEqaF118U7M   \n",
              "8                                               Lover  1LLXZFeAHK9R4xUramtUKw   \n",
              "9   Kaatru Veliyidai (Original Motion Picture Soun...  7gwuIhFmNaf3wcRWG1WadD   \n",
              "10  Vaagai Sooda Vaa (Original Motion Picture Soun...  04NcPs5V6181I5hvUFY4Vp   \n",
              "11  Vikram Vedha (Original Motion Picture Soundtrack)  07aADAqhVze8oPrzBil7FX   \n",
              "12                               I Love Pradeep Kumar  0Ei1ZN3Fj6lkp9QV7Q20MR   \n",
              "13                               I Love Pradeep Kumar  0JZPgDCigVlkSbKz16ec4l   \n",
              "14   Ambikapathy (Original Motion Picture Soundtrack)  0QBuP7vvKyoGAMlUBDJVWn   \n",
              "15                                        After Hours  0VjIjW4GlUZAMYd2vXMi3b   \n",
              "16                                  The Days / Nights  0ct6r3EGTcMLPtrXHDvVjc   \n",
              "17      Mankatha (Original Motion Picture Soundtrack)  0uVrPeEM1Q02sbGA3zJ3CC   \n",
              "18                                 x (Deluxe Edition)  1HNkqx9Ahdgi1Ixy2xkKkL   \n",
              "19                  Ninaivirukka (From \"Pathu Thala\")  1QFt7JduUhTeos7dNxPeHw   \n",
              "\n",
              "                    artist  duration  popularity  \n",
              "0             Taylor Swift    214706          75  \n",
              "1           Harris Jayaraj    235391          54  \n",
              "2               The Weeknd    242253          85  \n",
              "3            G. V. Prakash    223934          63  \n",
              "4                 D. Imman    300373          55  \n",
              "5   S. P. Balasubrahmanyam    272826          53  \n",
              "6              A.R. Rahman    290000          55  \n",
              "7          Anuradha Sriram    228066          42  \n",
              "8             Taylor Swift    190240          72  \n",
              "9              A.R. Rahman    239507          55  \n",
              "10                 Ghibran    298848          50  \n",
              "11           Pradeep Kumar    281428          53  \n",
              "12           Pradeep Kumar    230062          51  \n",
              "13           Pradeep Kumar    227017          47  \n",
              "14             A.R. Rahman    256360          56  \n",
              "15              The Weeknd    200040          89  \n",
              "16                  Avicii    176658          84  \n",
              "17      Yuvan Shankar Raja    302600          55  \n",
              "18              Ed Sheeran    258986          83  \n",
              "19             A.R. Rahman    255096          39  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bc67b979-a85f-4a1a-b918-7bb2d02c1578\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>track_name</th>\n",
              "      <th>album</th>\n",
              "      <th>track_id</th>\n",
              "      <th>artist</th>\n",
              "      <th>duration</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>willow</td>\n",
              "      <td>evermore</td>\n",
              "      <td>0lx2cLdOt3piJbcaXIV74f</td>\n",
              "      <td>Taylor Swift</td>\n",
              "      <td>214706</td>\n",
              "      <td>75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Idhayathai Yedho Ondru</td>\n",
              "      <td>Yennai Arindhaal (Original Motion Picture Soun...</td>\n",
              "      <td>23bpCCVsTUKviTEfoy4tbM</td>\n",
              "      <td>Harris Jayaraj</td>\n",
              "      <td>235391</td>\n",
              "      <td>54</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>The Hills</td>\n",
              "      <td>Beauty Behind The Madness</td>\n",
              "      <td>7fBv7CLKzipRk6EC6TWHOB</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>242253</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Vaa Vaathi (Dhanush Reprise Version)</td>\n",
              "      <td>Vaathi</td>\n",
              "      <td>43bgjI3ZddPJsu3JvNmYui</td>\n",
              "      <td>G. V. Prakash</td>\n",
              "      <td>223934</td>\n",
              "      <td>63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Koodamela Koodavechi</td>\n",
              "      <td>Rummy (Original Motion Picture Soundtrack)</td>\n",
              "      <td>102YVYHLNfgkfQP3qvDqsD</td>\n",
              "      <td>D. Imman</td>\n",
              "      <td>300373</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Azhakooril</td>\n",
              "      <td>Thirumalai (Original Motion Picture Soundtrack)</td>\n",
              "      <td>7BsQNB20nHHZY9pNcrrrsI</td>\n",
              "      <td>S. P. Balasubrahmanyam</td>\n",
              "      <td>272826</td>\n",
              "      <td>53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Nenjukkule</td>\n",
              "      <td>Kadal (Original Motion Picture Soundtrack)</td>\n",
              "      <td>7FEWG1bL31YAcnxJQvxJJO</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>290000</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Kannan Varum Velai</td>\n",
              "      <td>Deepavali (Original Motion Picture Soundtrack)</td>\n",
              "      <td>72niNpc1LP2DEqaF118U7M</td>\n",
              "      <td>Anuradha Sriram</td>\n",
              "      <td>228066</td>\n",
              "      <td>42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>London Boy</td>\n",
              "      <td>Lover</td>\n",
              "      <td>1LLXZFeAHK9R4xUramtUKw</td>\n",
              "      <td>Taylor Swift</td>\n",
              "      <td>190240</td>\n",
              "      <td>72</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Nallai Allai</td>\n",
              "      <td>Kaatru Veliyidai (Original Motion Picture Soun...</td>\n",
              "      <td>7gwuIhFmNaf3wcRWG1WadD</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>239507</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Sara Sara Saara Kathu</td>\n",
              "      <td>Vaagai Sooda Vaa (Original Motion Picture Soun...</td>\n",
              "      <td>04NcPs5V6181I5hvUFY4Vp</td>\n",
              "      <td>Ghibran</td>\n",
              "      <td>298848</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Pogatha Yennavittu</td>\n",
              "      <td>Vikram Vedha (Original Motion Picture Soundtrack)</td>\n",
              "      <td>07aADAqhVze8oPrzBil7FX</td>\n",
              "      <td>Pradeep Kumar</td>\n",
              "      <td>281428</td>\n",
              "      <td>53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Agayam Theepiditha - From \"Madras\"</td>\n",
              "      <td>I Love Pradeep Kumar</td>\n",
              "      <td>0Ei1ZN3Fj6lkp9QV7Q20MR</td>\n",
              "      <td>Pradeep Kumar</td>\n",
              "      <td>230062</td>\n",
              "      <td>51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Mogathirai - From \"Pizza\"</td>\n",
              "      <td>I Love Pradeep Kumar</td>\n",
              "      <td>0JZPgDCigVlkSbKz16ec4l</td>\n",
              "      <td>Pradeep Kumar</td>\n",
              "      <td>227017</td>\n",
              "      <td>47</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Ambikapathy</td>\n",
              "      <td>Ambikapathy (Original Motion Picture Soundtrack)</td>\n",
              "      <td>0QBuP7vvKyoGAMlUBDJVWn</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>256360</td>\n",
              "      <td>56</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Blinding Lights</td>\n",
              "      <td>After Hours</td>\n",
              "      <td>0VjIjW4GlUZAMYd2vXMi3b</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>200040</td>\n",
              "      <td>89</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>The Nights</td>\n",
              "      <td>The Days / Nights</td>\n",
              "      <td>0ct6r3EGTcMLPtrXHDvVjc</td>\n",
              "      <td>Avicii</td>\n",
              "      <td>176658</td>\n",
              "      <td>84</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Nanbane</td>\n",
              "      <td>Mankatha (Original Motion Picture Soundtrack)</td>\n",
              "      <td>0uVrPeEM1Q02sbGA3zJ3CC</td>\n",
              "      <td>Yuvan Shankar Raja</td>\n",
              "      <td>302600</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Photograph</td>\n",
              "      <td>x (Deluxe Edition)</td>\n",
              "      <td>1HNkqx9Ahdgi1Ixy2xkKkL</td>\n",
              "      <td>Ed Sheeran</td>\n",
              "      <td>258986</td>\n",
              "      <td>83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Ninaivirukka (From \"Pathu Thala\")</td>\n",
              "      <td>Ninaivirukka (From \"Pathu Thala\")</td>\n",
              "      <td>1QFt7JduUhTeos7dNxPeHw</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>255096</td>\n",
              "      <td>39</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bc67b979-a85f-4a1a-b918-7bb2d02c1578')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bc67b979-a85f-4a1a-b918-7bb2d02c1578 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bc67b979-a85f-4a1a-b918-7bb2d02c1578');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Creating a function get features of each track from track id\n",
        "def getTrackFeatures(track_id):\n",
        "  meta = sp.track(track_id)\n",
        "  features = sp.audio_features(track_id)\n",
        "\n",
        "  # meta\n",
        "  track_id = track_id\n",
        "  name = meta['name']\n",
        "  album = meta['album']['name']\n",
        "  artist = meta['album']['artists'][0]['name']\n",
        "  release_date = meta['album']['release_date']\n",
        "  length = meta['duration_ms']\n",
        "  popularity = meta['popularity']\n",
        "\n",
        "  # features\n",
        "  acousticness = features[0]['acousticness']\n",
        "  danceability = features[0]['danceability']\n",
        "  energy = features[0]['energy']\n",
        "  instrumentalness = features[0]['instrumentalness']\n",
        "  liveness = features[0]['liveness']\n",
        "  loudness = features[0]['loudness']\n",
        "  speechiness = features[0]['speechiness']\n",
        "  tempo = features[0]['tempo']\n",
        "  time_signature = features[0]['time_signature']\n",
        "\n",
        "  track = [track_id, name, album, artist, release_date, length, popularity, danceability, acousticness, energy, instrumentalness, liveness, loudness, speechiness, tempo, time_signature]\n",
        "  print(track)\n",
        "  return track"
      ],
      "metadata": {
        "id": "Y8Ms0rf8528F"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Getting track features for each song in favorite song dataframe\n",
        "fav_tracks = []\n",
        "for track in df_favourite['track_id']:\n",
        "    try:  \n",
        "        track = getTrackFeatures(track)\n",
        "        fav_tracks.append(track)\n",
        "    except:\n",
        "        pass"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wM9cLcXo425B",
        "outputId": "d89cec12-7d70-4925-87a9-46f703d5b80e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['0lx2cLdOt3piJbcaXIV74f', 'willow', 'evermore', 'Taylor Swift', '2020-12-11', 214706, 75, 0.392, 0.833, 0.574, 0.00179, 0.145, -9.195, 0.17, 81.112, 4]\n",
            "['23bpCCVsTUKviTEfoy4tbM', 'Idhayathai Yedho Ondru', 'Yennai Arindhaal (Original Motion Picture Soundtrack)', 'Harris Jayaraj', '2015-01-04', 235391, 54, 0.721, 0.845, 0.496, 0, 0.11, -8.063, 0.0508, 131.969, 3]\n",
            "['7fBv7CLKzipRk6EC6TWHOB', 'The Hills', 'Beauty Behind The Madness', 'The Weeknd', '2015-08-28', 242253, 85, 0.585, 0.0671, 0.564, 0, 0.135, -7.063, 0.0515, 113.003, 4]\n",
            "['43bgjI3ZddPJsu3JvNmYui', 'Vaa Vaathi (Dhanush Reprise Version)', 'Vaathi', 'G. V. Prakash', '2023-02-23', 223934, 63, 0.59, 0.605, 0.368, 0, 0.671, -12.03, 0.0306, 91.05, 4]\n",
            "['102YVYHLNfgkfQP3qvDqsD', 'Koodamela Koodavechi', 'Rummy (Original Motion Picture Soundtrack)', 'D. Imman', '2013-10-25', 300373, 55, 0.694, 0.324, 0.695, 0, 0.177, -5.035, 0.0276, 120.057, 4]\n",
            "['7BsQNB20nHHZY9pNcrrrsI', 'Azhakooril', 'Thirumalai (Original Motion Picture Soundtrack)', 'Vidyasagar', '2003-04-13', 272826, 53, 0.473, 0.0905, 0.659, 3.98e-05, 0.168, -9.292, 0.0477, 94.817, 4]\n",
            "['7FEWG1bL31YAcnxJQvxJJO', 'Nenjukkule', 'Kadal (Original Motion Picture Soundtrack)', 'A.R. Rahman', '2012-12-14', 290000, 55, 0.473, 0.699, 0.4, 1.27e-05, 0.132, -8.224, 0.0311, 154.04, 3]\n",
            "['72niNpc1LP2DEqaF118U7M', 'Kannan Varum Velai', 'Deepavali (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2007-01-05', 228066, 42, 0.795, 0.497, 0.508, 0.0147, 0.645, -9.838, 0.0594, 150.365, 3]\n",
            "['1LLXZFeAHK9R4xUramtUKw', 'London Boy', 'Lover', 'Taylor Swift', '2019-08-23', 190240, 72, 0.695, 0.0246, 0.71, 0.000104, 0.133, -6.639, 0.05, 157.925, 4]\n",
            "['7gwuIhFmNaf3wcRWG1WadD', 'Nallai Allai', 'Kaatru Veliyidai (Original Motion Picture Soundtrack)', 'A.R. Rahman', '2017-03-20', 239507, 55, 0.579, 0.803, 0.355, 0, 0.043, -9.323, 0.0253, 101.04, 4]\n",
            "['04NcPs5V6181I5hvUFY4Vp', 'Sara Sara Saara Kathu', 'Vaagai Sooda Vaa (Original Motion Picture Soundtrack)', 'Ghibran', '2011-07-01', 298848, 50, 0.578, 0.602, 0.629, 0, 0.0708, -6.774, 0.118, 104.097, 4]\n",
            "['07aADAqhVze8oPrzBil7FX', 'Pogatha Yennavittu', 'Vikram Vedha (Original Motion Picture Soundtrack)', 'Sam C.S.', '2017-06-19', 281428, 53, 0.381, 0.674, 0.577, 0, 0.0903, -7.02, 0.0933, 167.719, 4]\n",
            "['0Ei1ZN3Fj6lkp9QV7Q20MR', 'Agayam Theepiditha - From \"Madras\"', 'I Love Pradeep Kumar', 'Pradeep Kumar', '2018-06-12', 230062, 51, 0.517, 0.869, 0.423, 0, 0.0785, -8.388, 0.0389, 117.867, 4]\n",
            "['0JZPgDCigVlkSbKz16ec4l', 'Mogathirai - From \"Pizza\"', 'I Love Pradeep Kumar', 'Pradeep Kumar', '2018-06-12', 227017, 47, 0.522, 0.633, 0.264, 4.03e-05, 0.1, -9.428, 0.0415, 199.686, 4]\n",
            "['0QBuP7vvKyoGAMlUBDJVWn', 'Ambikapathy', 'Ambikapathy (Original Motion Picture Soundtrack)', 'A.R. Rahman', '2013-06-17', 256360, 56, 0.676, 0.255, 0.702, 1.99e-05, 0.114, -8.891, 0.0455, 113.006, 4]\n",
            "['0VjIjW4GlUZAMYd2vXMi3b', 'Blinding Lights', 'After Hours', 'The Weeknd', '2020-03-20', 200040, 89, 0.514, 0.00146, 0.73, 9.54e-05, 0.0897, -5.934, 0.0598, 171.005, 4]\n",
            "['0ct6r3EGTcMLPtrXHDvVjc', 'The Nights', 'The Days / Nights', 'Avicii', '2014-01-01', 176658, 84, 0.527, 0.0166, 0.835, 0, 0.249, -5.298, 0.0433, 125.983, 4]\n",
            "['0uVrPeEM1Q02sbGA3zJ3CC', 'Nanbane', 'Mankatha (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2011-08-10', 302600, 55, 0.451, 0.82, 0.306, 0.00544, 0.207, -6.325, 0.0403, 102.659, 4]\n",
            "['1HNkqx9Ahdgi1Ixy2xkKkL', 'Photograph', 'x (Deluxe Edition)', 'Ed Sheeran', '2014-06-21', 258986, 83, 0.614, 0.607, 0.379, 0.000464, 0.0986, -10.48, 0.0476, 107.989, 4]\n",
            "['1QFt7JduUhTeos7dNxPeHw', 'Ninaivirukka (From \"Pathu Thala\")', 'Ninaivirukka (From \"Pathu Thala\")', 'A.R. Rahman', '2023-03-13', 255096, 39, 0.633, 0.824, 0.31, 0, 0.124, -8.014, 0.0378, 74.996, 4]\n",
            "['1rLkzFZdokhx6Wcs80uvnw', 'Dimple', \"Love Yourself 結 'Answer'\", 'BTS', '2018-08-24', 196776, 62, 0.612, 0.14, 0.844, 0, 0.289, -4.694, 0.0757, 134.872, 4]\n",
            "['2QophXhN2Ls2URfoPmiviC', 'Kho Gaye', 'Mismatched: Season 2 (Music from the Netflix Series)', 'Mismatched', '2022-09-30', 197763, 73, 0.478, 0.628, 0.374, 0.000736, 0.0979, -11.627, 0.0361, 76.163, 4]\n",
            "['2pR4IQmI0Z8rEycgg0qDvz', 'Sahana Saral Thoo', 'Sivaji', 'A.R. Rahman', '2022-04-13', 318598, 54, 0.608, 0.265, 0.67, 0.00184, 0.185, -8.509, 0.042, 95.059, 3]\n",
            "['3cKMq4aFrfWV0DQzYbaxdi', 'Unnai Kaanadhu Naan', 'Vishwaroopam (Tamil) [Original Motion Picture Soundtrack]', 'Shankar-Ehsaan-Loy', '2012-12-07', 337133, 48, 0.502, 0.374, 0.643, 0, 0.227, -7.629, 0.0603, 127.25, 3]\n",
            "['3trnNo4KeaUlFuUiV7iRCj', 'Tera Chehra', 'Sanam Teri Kasam (Original Motion Picture Soundtrack)', 'Himesh Reshammiya', '2016-01-06', 274000, 61, 0.707, 0.436, 0.714, 2.89e-06, 0.0919, -4.143, 0.0311, 118.974, 4]\n",
            "['4FUNKKui6uiezyKE2j3YiM', 'Needhane', 'Sarvam (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2009-05-15', 312000, 41, 0.716, 0.559, 0.856, 0.00414, 0.0495, -3.737, 0.0375, 110.01, 4]\n",
            "['4tkSvA7zfuhwgHQbEeNEJU', 'Kaathodu Kaathanen (From \"Jail\")', 'Kaathodu Kaathanen (From \"Jail\")', 'G. V. Prakash', '2020-06-15', 310000, 47, 0.368, 0.739, 0.174, 0.000262, 0.122, -17.293, 0.0327, 80.06, 4]\n",
            "['5ofC5Bkx59uOWCG3gJnQy2', 'Kutti Puli Kootam', 'Thuppakki (Original Motion Picture Soundtrack)', 'Harris Jayaraj', '2012-10-10', 368848, 47, 0.819, 0.0737, 0.866, 0.0256, 0.15, -5.83, 0.0478, 124.011, 4]\n",
            "['6JWMTqPAdsNd97qMtaT4FS', 'Kombula Poova', 'Virumandi', 'Ilaiyaraaja', '2003-01-10', 301053, 46, 0.813, 0.16, 0.944, 0.0121, 0.0553, -3.2, 0.112, 163.991, 4]\n",
            "['6nP69wy9Y1PonStmqt33uk', 'Avalukena', 'Avalukena', 'Anirudh Ravichander', '2016-02-14', 287786, 49, 0.5, 0.758, 0.374, 0.000438, 0.0828, -10.043, 0.0348, 79.992, 4]\n",
            "['6nZiYSBwPQ7fYnVWkkkj4g', 'Kho Gaye Hum Kahan', 'Baar Baar Dekho (Original Motion Picture Soundtrack)', 'Various Artists', '2016-08-04', 213055, 65, 0.778, 0.983, 0.227, 0.14, 0.113, -16.191, 0.0379, 116.033, 4]\n",
            "['7j6Cb59M9yOq3aw4fmDzQj', 'Unna Vida', 'Virumandi', 'Ilaiyaraaja', '2003-01-10', 385226, 56, 0.712, 0.49, 0.439, 0.000179, 0.0873, -11.056, 0.0332, 120.016, 4]\n",
            "['7rU7uLC3OCfxCe7Hhh6FXj', 'Naetru Aval Irundhal', 'Maryan (Original Motion Picture Soundtrack)', 'A.R. Rahman', '2013-05-13', 298626, 52, 0.377, 0.869, 0.271, 1.44e-05, 0.0887, -13.725, 0.029, 79.743, 3]\n",
            "['0r1ppERo8Mp5iKg3lANvnB', 'Poo Avizhum Pozhudhil', 'Enakkul Oruvan (Original Motion Picture Soundtrack)', 'Santhosh Narayanan', '2014-09-08', 240637, 53, 0.585, 0.412, 0.444, 6.99e-05, 0.242, -9.969, 0.0458, 119.774, 5]\n",
            "['1AbSrAwrzuC3FcDXoYi3ED', 'Naan Nee', 'Madras (Original Motion Picture Soundtrack)', 'Santhosh Narayanan', '2014-06-23', 253582, 62, 0.651, 0.741, 0.42, 0.000257, 0.0976, -8.341, 0.0274, 139.905, 4]\n",
            "['3HzMxBV957tidhL2ft7KXA', 'Hair Toss, Arms Crossed', 'Hair Toss, Arms Crossed', 'Mark Ambor', '2022-04-13', 157851, 58, 0.72, 0.597, 0.49, 0, 0.0827, -6.131, 0.0477, 108.88, 4]\n",
            "['5YPRNP0c9KiZSMJDVL3h0x', 'Kaathellam', 'Gypsy', 'Santhosh Narayanan', '2019-05-20', 223770, 50, 0.645, 0.428, 0.303, 3.82e-06, 0.4, -9.792, 0.0588, 120.9, 4]\n",
            "['5q2MZwkvdw28qv0WPsRPHA', 'Muzumathi', 'Jodhaa Akbar (Tamil) [Original Motion Picture Soundtrack]', 'A.R. Rahman', '2007-12-31', 312453, 58, 0.708, 0.819, 0.325, 1.42e-06, 0.0827, -11.414, 0.0369, 137.814, 4]\n",
            "['74kfB0egOrXC9L6TNz26S5', 'Adada Vaa', 'Sarvam (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2009-05-15', 271386, 35, 0.674, 0.276, 0.83, 0.227, 0.0164, -4.765, 0.0739, 170.0, 4]\n",
            "['7kvlhTrxrB84Pq169LHKsB', 'Kalaarasiga', 'Ambikapathy (Original Motion Picture Soundtrack)', 'A.R. Rahman', '2013-06-17', 291013, 42, 0.696, 0.152, 0.782, 0, 0.177, -7.641, 0.129, 90.959, 4]\n",
            "['0jXnRZTUASl2uhsRfXjoJT', 'Kaadhal Vaithu', 'Deepavali (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2007-01-05', 309000, 61, 0.679, 0.032, 0.645, 0.131, 0.213, -11.743, 0.0361, 100.217, 4]\n",
            "['62AGxKeU4Hr5QkDuzj7uG2', 'Avatha Paiyya', 'Paradesi', 'Various Artists', '2020-08-12', 339108, 29, 0.682, 0.769, 0.463, 0.000967, 0.0904, -10.682, 0.0471, 119.993, 4]\n",
            "['0Bmsyr5cSBRdls7yFswkhL', 'Venpaniye', 'KO (Original Motion Picture Soundtrack)', 'Harris Jayaraj', '2011-01-17', 326666, 47, 0.702, 0.362, 0.426, 0.000138, 0.0654, -10.732, 0.0259, 93.012, 4]\n",
            "['2StGyGUbGAeXiPXbkBvU4s', 'En Fuse Pochu', 'Arrambam (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2013-09-23', 282853, 45, 0.679, 0.505, 0.554, 0, 0.145, -7.078, 0.0303, 104.964, 4]\n",
            "['384x7qDzho8phQt5NoCofh', 'Angnyaade', 'Raja Rani (Original Motion Picture Soundtrack)', 'G. V. Prakash', '2013-08-23', 218173, 46, 0.632, 0.771, 0.482, 0.00023, 0.109, -7.934, 0.108, 119.989, 4]\n",
            "['3DjGqlbBIzrZdVtVfAwRDh', 'Siragugal', 'Sarvam (Original Motion Picture Soundtrack)', 'Yuvan Shankar Raja', '2009-05-15', 321893, 58, 0.638, 0.184, 0.915, 0.000129, 0.0848, -3.272, 0.151, 169.968, 4]\n",
            "['09mEdoA6zrmBPgTEN5qXmN', 'Call Out My Name', 'My Dear Melancholy,', 'The Weeknd', '2018-03-30', 228373, 86, 0.461, 0.17, 0.593, 0, 0.307, -4.954, 0.0356, 134.17, 3]\n",
            "['1SymEzIT3H8UZfibCs3TYi', 'Afterglow', 'Lover', 'Taylor Swift', '2019-08-23', 223293, 76, 0.756, 0.13, 0.449, 0, 0.114, -8.746, 0.0344, 111.011, 4]\n",
            "['22VdIZQfgXJea34mQxlt81', \"Can't Feel My Face\", 'Beauty Behind The Madness', 'The Weeknd', '2015-08-28', 213520, 81, 0.705, 0.113, 0.769, 0, 0.105, -5.526, 0.0425, 107.949, 4]\n",
            "['2P4OICZRVAQcYAV2JReRfj', 'Waiting For Love', 'Stories', 'Avicii', '2015-10-02', 230613, 80, 0.579, 0.31, 0.736, 0, 0.198, -3.863, 0.0527, 127.999, 4]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Create favorite track wtih audio features dataset\n",
        "df_fav = pd.DataFrame(fav_tracks, columns = ['track_id', 'name', 'album', 'artist', 'release_date', 'length', 'popularity', 'danceability', 'acousticness', 'energy', 'instrumentalness', 'liveness', 'loudness', 'speechiness', 'tempo', 'time_signature'])\n",
        "df_fav.head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 999
        },
        "id": "cA6dHHHA45SZ",
        "outputId": "8012a6b2-b9aa-4637-c25c-35d58afa8b59"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 track_id                                  name  \\\n",
              "0  0lx2cLdOt3piJbcaXIV74f                                willow   \n",
              "1  23bpCCVsTUKviTEfoy4tbM                Idhayathai Yedho Ondru   \n",
              "2  7fBv7CLKzipRk6EC6TWHOB                             The Hills   \n",
              "3  43bgjI3ZddPJsu3JvNmYui  Vaa Vaathi (Dhanush Reprise Version)   \n",
              "4  102YVYHLNfgkfQP3qvDqsD                  Koodamela Koodavechi   \n",
              "5  7BsQNB20nHHZY9pNcrrrsI                            Azhakooril   \n",
              "6  7FEWG1bL31YAcnxJQvxJJO                            Nenjukkule   \n",
              "7  72niNpc1LP2DEqaF118U7M                    Kannan Varum Velai   \n",
              "8  1LLXZFeAHK9R4xUramtUKw                            London Boy   \n",
              "9  7gwuIhFmNaf3wcRWG1WadD                          Nallai Allai   \n",
              "\n",
              "                                               album              artist  \\\n",
              "0                                           evermore        Taylor Swift   \n",
              "1  Yennai Arindhaal (Original Motion Picture Soun...      Harris Jayaraj   \n",
              "2                          Beauty Behind The Madness          The Weeknd   \n",
              "3                                             Vaathi       G. V. Prakash   \n",
              "4         Rummy (Original Motion Picture Soundtrack)            D. Imman   \n",
              "5    Thirumalai (Original Motion Picture Soundtrack)          Vidyasagar   \n",
              "6         Kadal (Original Motion Picture Soundtrack)         A.R. Rahman   \n",
              "7     Deepavali (Original Motion Picture Soundtrack)  Yuvan Shankar Raja   \n",
              "8                                              Lover        Taylor Swift   \n",
              "9  Kaatru Veliyidai (Original Motion Picture Soun...         A.R. Rahman   \n",
              "\n",
              "  release_date  length  popularity  danceability  acousticness  energy  \\\n",
              "0   2020-12-11  214706          75         0.392        0.8330   0.574   \n",
              "1   2015-01-04  235391          54         0.721        0.8450   0.496   \n",
              "2   2015-08-28  242253          85         0.585        0.0671   0.564   \n",
              "3   2023-02-23  223934          63         0.590        0.6050   0.368   \n",
              "4   2013-10-25  300373          55         0.694        0.3240   0.695   \n",
              "5   2003-04-13  272826          53         0.473        0.0905   0.659   \n",
              "6   2012-12-14  290000          55         0.473        0.6990   0.400   \n",
              "7   2007-01-05  228066          42         0.795        0.4970   0.508   \n",
              "8   2019-08-23  190240          72         0.695        0.0246   0.710   \n",
              "9   2017-03-20  239507          55         0.579        0.8030   0.355   \n",
              "\n",
              "   instrumentalness  liveness  loudness  speechiness    tempo  time_signature  \n",
              "0          0.001790     0.145    -9.195       0.1700   81.112               4  \n",
              "1          0.000000     0.110    -8.063       0.0508  131.969               3  \n",
              "2          0.000000     0.135    -7.063       0.0515  113.003               4  \n",
              "3          0.000000     0.671   -12.030       0.0306   91.050               4  \n",
              "4          0.000000     0.177    -5.035       0.0276  120.057               4  \n",
              "5          0.000040     0.168    -9.292       0.0477   94.817               4  \n",
              "6          0.000013     0.132    -8.224       0.0311  154.040               3  \n",
              "7          0.014700     0.645    -9.838       0.0594  150.365               3  \n",
              "8          0.000104     0.133    -6.639       0.0500  157.925               4  \n",
              "9          0.000000     0.043    -9.323       0.0253  101.040               4  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f5b0335f-2873-4571-8f79-3678703696d6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>track_id</th>\n",
              "      <th>name</th>\n",
              "      <th>album</th>\n",
              "      <th>artist</th>\n",
              "      <th>release_date</th>\n",
              "      <th>length</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>energy</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>loudness</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>tempo</th>\n",
              "      <th>time_signature</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0lx2cLdOt3piJbcaXIV74f</td>\n",
              "      <td>willow</td>\n",
              "      <td>evermore</td>\n",
              "      <td>Taylor Swift</td>\n",
              "      <td>2020-12-11</td>\n",
              "      <td>214706</td>\n",
              "      <td>75</td>\n",
              "      <td>0.392</td>\n",
              "      <td>0.8330</td>\n",
              "      <td>0.574</td>\n",
              "      <td>0.001790</td>\n",
              "      <td>0.145</td>\n",
              "      <td>-9.195</td>\n",
              "      <td>0.1700</td>\n",
              "      <td>81.112</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>23bpCCVsTUKviTEfoy4tbM</td>\n",
              "      <td>Idhayathai Yedho Ondru</td>\n",
              "      <td>Yennai Arindhaal (Original Motion Picture Soun...</td>\n",
              "      <td>Harris Jayaraj</td>\n",
              "      <td>2015-01-04</td>\n",
              "      <td>235391</td>\n",
              "      <td>54</td>\n",
              "      <td>0.721</td>\n",
              "      <td>0.8450</td>\n",
              "      <td>0.496</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.110</td>\n",
              "      <td>-8.063</td>\n",
              "      <td>0.0508</td>\n",
              "      <td>131.969</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>7fBv7CLKzipRk6EC6TWHOB</td>\n",
              "      <td>The Hills</td>\n",
              "      <td>Beauty Behind The Madness</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>2015-08-28</td>\n",
              "      <td>242253</td>\n",
              "      <td>85</td>\n",
              "      <td>0.585</td>\n",
              "      <td>0.0671</td>\n",
              "      <td>0.564</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.135</td>\n",
              "      <td>-7.063</td>\n",
              "      <td>0.0515</td>\n",
              "      <td>113.003</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>43bgjI3ZddPJsu3JvNmYui</td>\n",
              "      <td>Vaa Vaathi (Dhanush Reprise Version)</td>\n",
              "      <td>Vaathi</td>\n",
              "      <td>G. V. Prakash</td>\n",
              "      <td>2023-02-23</td>\n",
              "      <td>223934</td>\n",
              "      <td>63</td>\n",
              "      <td>0.590</td>\n",
              "      <td>0.6050</td>\n",
              "      <td>0.368</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.671</td>\n",
              "      <td>-12.030</td>\n",
              "      <td>0.0306</td>\n",
              "      <td>91.050</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>102YVYHLNfgkfQP3qvDqsD</td>\n",
              "      <td>Koodamela Koodavechi</td>\n",
              "      <td>Rummy (Original Motion Picture Soundtrack)</td>\n",
              "      <td>D. Imman</td>\n",
              "      <td>2013-10-25</td>\n",
              "      <td>300373</td>\n",
              "      <td>55</td>\n",
              "      <td>0.694</td>\n",
              "      <td>0.3240</td>\n",
              "      <td>0.695</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.177</td>\n",
              "      <td>-5.035</td>\n",
              "      <td>0.0276</td>\n",
              "      <td>120.057</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>7BsQNB20nHHZY9pNcrrrsI</td>\n",
              "      <td>Azhakooril</td>\n",
              "      <td>Thirumalai (Original Motion Picture Soundtrack)</td>\n",
              "      <td>Vidyasagar</td>\n",
              "      <td>2003-04-13</td>\n",
              "      <td>272826</td>\n",
              "      <td>53</td>\n",
              "      <td>0.473</td>\n",
              "      <td>0.0905</td>\n",
              "      <td>0.659</td>\n",
              "      <td>0.000040</td>\n",
              "      <td>0.168</td>\n",
              "      <td>-9.292</td>\n",
              "      <td>0.0477</td>\n",
              "      <td>94.817</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>7FEWG1bL31YAcnxJQvxJJO</td>\n",
              "      <td>Nenjukkule</td>\n",
              "      <td>Kadal (Original Motion Picture Soundtrack)</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>2012-12-14</td>\n",
              "      <td>290000</td>\n",
              "      <td>55</td>\n",
              "      <td>0.473</td>\n",
              "      <td>0.6990</td>\n",
              "      <td>0.400</td>\n",
              "      <td>0.000013</td>\n",
              "      <td>0.132</td>\n",
              "      <td>-8.224</td>\n",
              "      <td>0.0311</td>\n",
              "      <td>154.040</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>72niNpc1LP2DEqaF118U7M</td>\n",
              "      <td>Kannan Varum Velai</td>\n",
              "      <td>Deepavali (Original Motion Picture Soundtrack)</td>\n",
              "      <td>Yuvan Shankar Raja</td>\n",
              "      <td>2007-01-05</td>\n",
              "      <td>228066</td>\n",
              "      <td>42</td>\n",
              "      <td>0.795</td>\n",
              "      <td>0.4970</td>\n",
              "      <td>0.508</td>\n",
              "      <td>0.014700</td>\n",
              "      <td>0.645</td>\n",
              "      <td>-9.838</td>\n",
              "      <td>0.0594</td>\n",
              "      <td>150.365</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>1LLXZFeAHK9R4xUramtUKw</td>\n",
              "      <td>London Boy</td>\n",
              "      <td>Lover</td>\n",
              "      <td>Taylor Swift</td>\n",
              "      <td>2019-08-23</td>\n",
              "      <td>190240</td>\n",
              "      <td>72</td>\n",
              "      <td>0.695</td>\n",
              "      <td>0.0246</td>\n",
              "      <td>0.710</td>\n",
              "      <td>0.000104</td>\n",
              "      <td>0.133</td>\n",
              "      <td>-6.639</td>\n",
              "      <td>0.0500</td>\n",
              "      <td>157.925</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>7gwuIhFmNaf3wcRWG1WadD</td>\n",
              "      <td>Nallai Allai</td>\n",
              "      <td>Kaatru Veliyidai (Original Motion Picture Soun...</td>\n",
              "      <td>A.R. Rahman</td>\n",
              "      <td>2017-03-20</td>\n",
              "      <td>239507</td>\n",
              "      <td>55</td>\n",
              "      <td>0.579</td>\n",
              "      <td>0.8030</td>\n",
              "      <td>0.355</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.043</td>\n",
              "      <td>-9.323</td>\n",
              "      <td>0.0253</td>\n",
              "      <td>101.040</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f5b0335f-2873-4571-8f79-3678703696d6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f5b0335f-2873-4571-8f79-3678703696d6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f5b0335f-2873-4571-8f79-3678703696d6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_fav.to_csv('Contentbased.csv')"
      ],
      "metadata": {
        "id": "JUCddXAS6K_7"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_fav = df_fav.drop(columns=['name', 'album', 'artist', 'release_date'])\n",
        "df_fav.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "B22XfvZd48ZS",
        "outputId": "fddfdbcf-b71e-45b5-e0cd-40da91ad304f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 track_id  length  popularity  danceability  acousticness  \\\n",
              "0  0lx2cLdOt3piJbcaXIV74f  214706          75         0.392        0.8330   \n",
              "1  23bpCCVsTUKviTEfoy4tbM  235391          54         0.721        0.8450   \n",
              "2  7fBv7CLKzipRk6EC6TWHOB  242253          85         0.585        0.0671   \n",
              "3  43bgjI3ZddPJsu3JvNmYui  223934          63         0.590        0.6050   \n",
              "4  102YVYHLNfgkfQP3qvDqsD  300373          55         0.694        0.3240   \n",
              "\n",
              "   energy  instrumentalness  liveness  loudness  speechiness    tempo  \\\n",
              "0   0.574           0.00179     0.145    -9.195       0.1700   81.112   \n",
              "1   0.496           0.00000     0.110    -8.063       0.0508  131.969   \n",
              "2   0.564           0.00000     0.135    -7.063       0.0515  113.003   \n",
              "3   0.368           0.00000     0.671   -12.030       0.0306   91.050   \n",
              "4   0.695           0.00000     0.177    -5.035       0.0276  120.057   \n",
              "\n",
              "   time_signature  \n",
              "0               4  \n",
              "1               3  \n",
              "2               4  \n",
              "3               4  \n",
              "4               4  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b0bc8f61-3aeb-4ef4-8ace-784331ce4eb7\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>track_id</th>\n",
              "      <th>length</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>energy</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>loudness</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>tempo</th>\n",
              "      <th>time_signature</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0lx2cLdOt3piJbcaXIV74f</td>\n",
              "      <td>214706</td>\n",
              "      <td>75</td>\n",
              "      <td>0.392</td>\n",
              "      <td>0.8330</td>\n",
              "      <td>0.574</td>\n",
              "      <td>0.00179</td>\n",
              "      <td>0.145</td>\n",
              "      <td>-9.195</td>\n",
              "      <td>0.1700</td>\n",
              "      <td>81.112</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>23bpCCVsTUKviTEfoy4tbM</td>\n",
              "      <td>235391</td>\n",
              "      <td>54</td>\n",
              "      <td>0.721</td>\n",
              "      <td>0.8450</td>\n",
              "      <td>0.496</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.110</td>\n",
              "      <td>-8.063</td>\n",
              "      <td>0.0508</td>\n",
              "      <td>131.969</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>7fBv7CLKzipRk6EC6TWHOB</td>\n",
              "      <td>242253</td>\n",
              "      <td>85</td>\n",
              "      <td>0.585</td>\n",
              "      <td>0.0671</td>\n",
              "      <td>0.564</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.135</td>\n",
              "      <td>-7.063</td>\n",
              "      <td>0.0515</td>\n",
              "      <td>113.003</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>43bgjI3ZddPJsu3JvNmYui</td>\n",
              "      <td>223934</td>\n",
              "      <td>63</td>\n",
              "      <td>0.590</td>\n",
              "      <td>0.6050</td>\n",
              "      <td>0.368</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.671</td>\n",
              "      <td>-12.030</td>\n",
              "      <td>0.0306</td>\n",
              "      <td>91.050</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>102YVYHLNfgkfQP3qvDqsD</td>\n",
              "      <td>300373</td>\n",
              "      <td>55</td>\n",
              "      <td>0.694</td>\n",
              "      <td>0.3240</td>\n",
              "      <td>0.695</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.177</td>\n",
              "      <td>-5.035</td>\n",
              "      <td>0.0276</td>\n",
              "      <td>120.057</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b0bc8f61-3aeb-4ef4-8ace-784331ce4eb7')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b0bc8f61-3aeb-4ef4-8ace-784331ce4eb7 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b0bc8f61-3aeb-4ef4-8ace-784331ce4eb7');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_fav['favorite'] = 1"
      ],
      "metadata": {
        "id": "vaxumY1X4_7i"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "li=[]\n",
        "for i in range(0,50):\n",
        "    li.append(df_fav.loc[i, 'name']+\" \"+df_fav.loc[i,'artist'])\n",
        "\n",
        "print(li)\n",
        "df_fav['name+artist']=li\n",
        "X = vectorizer.fit_transform(df_fav['name+artist'])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6_Fy--KL6884",
        "outputId": "6606a2be-895f-4da3-8f12-4af683d8d553"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['willow Taylor Swift', 'Idhayathai Yedho Ondru Harris Jayaraj', 'The Hills The Weeknd', 'Vaa Vaathi (Dhanush Reprise Version) G. V. Prakash', 'Koodamela Koodavechi D. Imman', 'Azhakooril Vidyasagar', 'Nenjukkule A.R. Rahman', 'Kannan Varum Velai Yuvan Shankar Raja', 'London Boy Taylor Swift', 'Nallai Allai A.R. Rahman', 'Sara Sara Saara Kathu Ghibran', 'Pogatha Yennavittu Sam C.S.', 'Agayam Theepiditha - From \"Madras\" Pradeep Kumar', 'Mogathirai - From \"Pizza\" Pradeep Kumar', 'Ambikapathy A.R. Rahman', 'Blinding Lights The Weeknd', 'The Nights Avicii', 'Nanbane Yuvan Shankar Raja', 'Photograph Ed Sheeran', 'Ninaivirukka (From \"Pathu Thala\") A.R. Rahman', 'Dimple BTS', 'Kho Gaye Mismatched', 'Sahana Saral Thoo A.R. Rahman', 'Unnai Kaanadhu Naan Shankar-Ehsaan-Loy', 'Tera Chehra Himesh Reshammiya', 'Needhane Yuvan Shankar Raja', 'Kaathodu Kaathanen (From \"Jail\") G. V. Prakash', 'Kutti Puli Kootam Harris Jayaraj', 'Kombula Poova Ilaiyaraaja', 'Avalukena Anirudh Ravichander', 'Kho Gaye Hum Kahan Various Artists', 'Unna Vida Ilaiyaraaja', 'Naetru Aval Irundhal A.R. Rahman', 'Poo Avizhum Pozhudhil Santhosh Narayanan', 'Naan Nee Santhosh Narayanan', 'Hair Toss, Arms Crossed Mark Ambor', 'Kaathellam Santhosh Narayanan', 'Muzumathi A.R. Rahman', 'Adada Vaa Yuvan Shankar Raja', 'Kalaarasiga A.R. Rahman', 'Kaadhal Vaithu Yuvan Shankar Raja', 'Avatha Paiyya Various Artists', 'Venpaniye Harris Jayaraj', 'En Fuse Pochu Yuvan Shankar Raja', 'Angnyaade G. V. Prakash', 'Siragugal Yuvan Shankar Raja', 'Call Out My Name The Weeknd', 'Afterglow Taylor Swift', \"Can't Feel My Face The Weeknd\", 'Waiting For Love Avicii']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "query = \"Pradeep Kumar\"\n",
        "query_vec = vectorizer.transform([query])"
      ],
      "metadata": {
        "id": "g-es6T2N6884"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "results = cosine_similarity(X,query_vec)"
      ],
      "metadata": {
        "id": "5k9UAG456884"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "results"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "z6VeswwS71F4",
        "outputId": "be46defd-2494-4ca7-f7f8-914d1f3d01b2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([[0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.55816904],\n",
              "       [0.6203695 ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ],\n",
              "       [0.        ]])"
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_fav['cosine']=np.array(results)"
      ],
      "metadata": {
        "id": "ISPJ08zs6884"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_fav=df_fav.drop(['names+artist'], axis=1)"
      ],
      "metadata": {
        "id": "fhKBINNZ8uPM"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "sort_df = df_fav.sort_values(by = ['cosine', 'popularity'], ascending=False)\n",
        "sort_df.head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 774
        },
        "outputId": "8515ae70-c610-4dba-c911-81d0bca7f482",
        "id": "F_jqB6hc6885"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  track_id                                name  \\\n",
              "13  0JZPgDCigVlkSbKz16ec4l           Mogathirai - From \"Pizza\"   \n",
              "12  0Ei1ZN3Fj6lkp9QV7Q20MR  Agayam Theepiditha - From \"Madras\"   \n",
              "15  0VjIjW4GlUZAMYd2vXMi3b                     Blinding Lights   \n",
              "46  09mEdoA6zrmBPgTEN5qXmN                    Call Out My Name   \n",
              "2   7fBv7CLKzipRk6EC6TWHOB                           The Hills   \n",
              "16  0ct6r3EGTcMLPtrXHDvVjc                          The Nights   \n",
              "18  1HNkqx9Ahdgi1Ixy2xkKkL                          Photograph   \n",
              "48  22VdIZQfgXJea34mQxlt81                  Can't Feel My Face   \n",
              "49  2P4OICZRVAQcYAV2JReRfj                    Waiting For Love   \n",
              "47  1SymEzIT3H8UZfibCs3TYi                           Afterglow   \n",
              "\n",
              "                        album         artist release_date  length  popularity  \\\n",
              "13       I Love Pradeep Kumar  Pradeep Kumar   2018-06-12  227017          47   \n",
              "12       I Love Pradeep Kumar  Pradeep Kumar   2018-06-12  230062          51   \n",
              "15                After Hours     The Weeknd   2020-03-20  200040          89   \n",
              "46        My Dear Melancholy,     The Weeknd   2018-03-30  228373          86   \n",
              "2   Beauty Behind The Madness     The Weeknd   2015-08-28  242253          85   \n",
              "16          The Days / Nights         Avicii   2014-01-01  176658          84   \n",
              "18         x (Deluxe Edition)     Ed Sheeran   2014-06-21  258986          83   \n",
              "48  Beauty Behind The Madness     The Weeknd   2015-08-28  213520          81   \n",
              "49                    Stories         Avicii   2015-10-02  230613          80   \n",
              "47                      Lover   Taylor Swift   2019-08-23  223293          76   \n",
              "\n",
              "    danceability  acousticness  energy  instrumentalness  liveness  loudness  \\\n",
              "13         0.522       0.63300   0.264          0.000040    0.1000    -9.428   \n",
              "12         0.517       0.86900   0.423          0.000000    0.0785    -8.388   \n",
              "15         0.514       0.00146   0.730          0.000095    0.0897    -5.934   \n",
              "46         0.461       0.17000   0.593          0.000000    0.3070    -4.954   \n",
              "2          0.585       0.06710   0.564          0.000000    0.1350    -7.063   \n",
              "16         0.527       0.01660   0.835          0.000000    0.2490    -5.298   \n",
              "18         0.614       0.60700   0.379          0.000464    0.0986   -10.480   \n",
              "48         0.705       0.11300   0.769          0.000000    0.1050    -5.526   \n",
              "49         0.579       0.31000   0.736          0.000000    0.1980    -3.863   \n",
              "47         0.756       0.13000   0.449          0.000000    0.1140    -8.746   \n",
              "\n",
              "    speechiness    tempo  time_signature    cosine  \\\n",
              "13       0.0415  199.686               4  0.620369   \n",
              "12       0.0389  117.867               4  0.558169   \n",
              "15       0.0598  171.005               4  0.000000   \n",
              "46       0.0356  134.170               3  0.000000   \n",
              "2        0.0515  113.003               4  0.000000   \n",
              "16       0.0433  125.983               4  0.000000   \n",
              "18       0.0476  107.989               4  0.000000   \n",
              "48       0.0425  107.949               4  0.000000   \n",
              "49       0.0527  127.999               4  0.000000   \n",
              "47       0.0344  111.011               4  0.000000   \n",
              "\n",
              "                                         name+artist  \n",
              "13           Mogathirai - From \"Pizza\" Pradeep Kumar  \n",
              "12  Agayam Theepiditha - From \"Madras\" Pradeep Kumar  \n",
              "15                        Blinding Lights The Weeknd  \n",
              "46                       Call Out My Name The Weeknd  \n",
              "2                               The Hills The Weeknd  \n",
              "16                                 The Nights Avicii  \n",
              "18                             Photograph Ed Sheeran  \n",
              "48                     Can't Feel My Face The Weeknd  \n",
              "49                           Waiting For Love Avicii  \n",
              "47                            Afterglow Taylor Swift  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f04f6687-0789-49fb-a6ca-7c02e3f15a1d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>track_id</th>\n",
              "      <th>name</th>\n",
              "      <th>album</th>\n",
              "      <th>artist</th>\n",
              "      <th>release_date</th>\n",
              "      <th>length</th>\n",
              "      <th>popularity</th>\n",
              "      <th>danceability</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>energy</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>loudness</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>tempo</th>\n",
              "      <th>time_signature</th>\n",
              "      <th>cosine</th>\n",
              "      <th>name+artist</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>0JZPgDCigVlkSbKz16ec4l</td>\n",
              "      <td>Mogathirai - From \"Pizza\"</td>\n",
              "      <td>I Love Pradeep Kumar</td>\n",
              "      <td>Pradeep Kumar</td>\n",
              "      <td>2018-06-12</td>\n",
              "      <td>227017</td>\n",
              "      <td>47</td>\n",
              "      <td>0.522</td>\n",
              "      <td>0.63300</td>\n",
              "      <td>0.264</td>\n",
              "      <td>0.000040</td>\n",
              "      <td>0.1000</td>\n",
              "      <td>-9.428</td>\n",
              "      <td>0.0415</td>\n",
              "      <td>199.686</td>\n",
              "      <td>4</td>\n",
              "      <td>0.620369</td>\n",
              "      <td>Mogathirai - From \"Pizza\" Pradeep Kumar</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>0Ei1ZN3Fj6lkp9QV7Q20MR</td>\n",
              "      <td>Agayam Theepiditha - From \"Madras\"</td>\n",
              "      <td>I Love Pradeep Kumar</td>\n",
              "      <td>Pradeep Kumar</td>\n",
              "      <td>2018-06-12</td>\n",
              "      <td>230062</td>\n",
              "      <td>51</td>\n",
              "      <td>0.517</td>\n",
              "      <td>0.86900</td>\n",
              "      <td>0.423</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0785</td>\n",
              "      <td>-8.388</td>\n",
              "      <td>0.0389</td>\n",
              "      <td>117.867</td>\n",
              "      <td>4</td>\n",
              "      <td>0.558169</td>\n",
              "      <td>Agayam Theepiditha - From \"Madras\" Pradeep Kumar</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>0VjIjW4GlUZAMYd2vXMi3b</td>\n",
              "      <td>Blinding Lights</td>\n",
              "      <td>After Hours</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>2020-03-20</td>\n",
              "      <td>200040</td>\n",
              "      <td>89</td>\n",
              "      <td>0.514</td>\n",
              "      <td>0.00146</td>\n",
              "      <td>0.730</td>\n",
              "      <td>0.000095</td>\n",
              "      <td>0.0897</td>\n",
              "      <td>-5.934</td>\n",
              "      <td>0.0598</td>\n",
              "      <td>171.005</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Blinding Lights The Weeknd</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>09mEdoA6zrmBPgTEN5qXmN</td>\n",
              "      <td>Call Out My Name</td>\n",
              "      <td>My Dear Melancholy,</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>2018-03-30</td>\n",
              "      <td>228373</td>\n",
              "      <td>86</td>\n",
              "      <td>0.461</td>\n",
              "      <td>0.17000</td>\n",
              "      <td>0.593</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.3070</td>\n",
              "      <td>-4.954</td>\n",
              "      <td>0.0356</td>\n",
              "      <td>134.170</td>\n",
              "      <td>3</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Call Out My Name The Weeknd</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>7fBv7CLKzipRk6EC6TWHOB</td>\n",
              "      <td>The Hills</td>\n",
              "      <td>Beauty Behind The Madness</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>2015-08-28</td>\n",
              "      <td>242253</td>\n",
              "      <td>85</td>\n",
              "      <td>0.585</td>\n",
              "      <td>0.06710</td>\n",
              "      <td>0.564</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.1350</td>\n",
              "      <td>-7.063</td>\n",
              "      <td>0.0515</td>\n",
              "      <td>113.003</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>The Hills The Weeknd</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>0ct6r3EGTcMLPtrXHDvVjc</td>\n",
              "      <td>The Nights</td>\n",
              "      <td>The Days / Nights</td>\n",
              "      <td>Avicii</td>\n",
              "      <td>2014-01-01</td>\n",
              "      <td>176658</td>\n",
              "      <td>84</td>\n",
              "      <td>0.527</td>\n",
              "      <td>0.01660</td>\n",
              "      <td>0.835</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.2490</td>\n",
              "      <td>-5.298</td>\n",
              "      <td>0.0433</td>\n",
              "      <td>125.983</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>The Nights Avicii</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>1HNkqx9Ahdgi1Ixy2xkKkL</td>\n",
              "      <td>Photograph</td>\n",
              "      <td>x (Deluxe Edition)</td>\n",
              "      <td>Ed Sheeran</td>\n",
              "      <td>2014-06-21</td>\n",
              "      <td>258986</td>\n",
              "      <td>83</td>\n",
              "      <td>0.614</td>\n",
              "      <td>0.60700</td>\n",
              "      <td>0.379</td>\n",
              "      <td>0.000464</td>\n",
              "      <td>0.0986</td>\n",
              "      <td>-10.480</td>\n",
              "      <td>0.0476</td>\n",
              "      <td>107.989</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Photograph Ed Sheeran</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>22VdIZQfgXJea34mQxlt81</td>\n",
              "      <td>Can't Feel My Face</td>\n",
              "      <td>Beauty Behind The Madness</td>\n",
              "      <td>The Weeknd</td>\n",
              "      <td>2015-08-28</td>\n",
              "      <td>213520</td>\n",
              "      <td>81</td>\n",
              "      <td>0.705</td>\n",
              "      <td>0.11300</td>\n",
              "      <td>0.769</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.1050</td>\n",
              "      <td>-5.526</td>\n",
              "      <td>0.0425</td>\n",
              "      <td>107.949</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Can't Feel My Face The Weeknd</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>2P4OICZRVAQcYAV2JReRfj</td>\n",
              "      <td>Waiting For Love</td>\n",
              "      <td>Stories</td>\n",
              "      <td>Avicii</td>\n",
              "      <td>2015-10-02</td>\n",
              "      <td>230613</td>\n",
              "      <td>80</td>\n",
              "      <td>0.579</td>\n",
              "      <td>0.31000</td>\n",
              "      <td>0.736</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.1980</td>\n",
              "      <td>-3.863</td>\n",
              "      <td>0.0527</td>\n",
              "      <td>127.999</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Waiting For Love Avicii</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>1SymEzIT3H8UZfibCs3TYi</td>\n",
              "      <td>Afterglow</td>\n",
              "      <td>Lover</td>\n",
              "      <td>Taylor Swift</td>\n",
              "      <td>2019-08-23</td>\n",
              "      <td>223293</td>\n",
              "      <td>76</td>\n",
              "      <td>0.756</td>\n",
              "      <td>0.13000</td>\n",
              "      <td>0.449</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.1140</td>\n",
              "      <td>-8.746</td>\n",
              "      <td>0.0344</td>\n",
              "      <td>111.011</td>\n",
              "      <td>4</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Afterglow Taylor Swift</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f04f6687-0789-49fb-a6ca-7c02e3f15a1d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f04f6687-0789-49fb-a6ca-7c02e3f15a1d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f04f6687-0789-49fb-a6ca-7c02e3f15a1d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 55
        }
      ]
    }
  ]
}