Song_Rec_System-checkpoint.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "213c91ef",
   "metadata": {},
   "source": [
    "## Song Recommendation System"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a7a9c773",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "087319b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "albums_data=pd.read_csv('spotify_albums.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "466def61",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>album_type</th>\n",
       "      <th>artist_id</th>\n",
       "      <th>available_markets</th>\n",
       "      <th>external_urls</th>\n",
       "      <th>href</th>\n",
       "      <th>id</th>\n",
       "      <th>images</th>\n",
       "      <th>name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>release_date_precision</th>\n",
       "      <th>total_tracks</th>\n",
       "      <th>track_id</th>\n",
       "      <th>track_name_prev</th>\n",
       "      <th>uri</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>single</td>\n",
       "      <td>3DiDSECUqqY1AuBP8qtaIa</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/1g...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/1gAM7M4rBwEb...</td>\n",
       "      <td>1gAM7M4rBwEbSPeAQR2nx1</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>If I Ain't Got You EP</td>\n",
       "      <td>2/8/2019</td>\n",
       "      <td>day</td>\n",
       "      <td>6</td>\n",
       "      <td>2iejTMy9XZ8Gaae0aQ2yl0</td>\n",
       "      <td>track_32</td>\n",
       "      <td>spotify:album:1gAM7M4rBwEbSPeAQR2nx1</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>album</td>\n",
       "      <td>6s1pCNXcbdtQJlsnM1hRIA</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/4K...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/4KfJZV7WfolY...</td>\n",
       "      <td>4KfJZV7WfolYlxBzOTo66s</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Shostakovich Symphony No.5 - Four Romances on ...</td>\n",
       "      <td>3/1/2019</td>\n",
       "      <td>day</td>\n",
       "      <td>8</td>\n",
       "      <td>1WQfghEjszJJ4H8MAWrQ2C</td>\n",
       "      <td>track_11</td>\n",
       "      <td>spotify:album:4KfJZV7WfolYlxBzOTo66s</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>single</td>\n",
       "      <td>5YjfNaHq05WrwldRe1QSBc</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/7n...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/7nLYY7uAVUb5...</td>\n",
       "      <td>7nLYY7uAVUb57kpd7tZxnS</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Take My Bass</td>\n",
       "      <td>3/14/2019</td>\n",
       "      <td>day</td>\n",
       "      <td>1</td>\n",
       "      <td>3jJKj4QTK3v18ZSwpk7AcV</td>\n",
       "      <td>track_15</td>\n",
       "      <td>spotify:album:7nLYY7uAVUb57kpd7tZxnS</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>single</td>\n",
       "      <td>2G9Vc16JCpnZmK4uGH46Fa</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/6p...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/6p20Rt4x2Qn5...</td>\n",
       "      <td>6p20Rt4x2Qn5mUMRi1s6pj</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Hypnotizing (Are U)</td>\n",
       "      <td>11/16/2016</td>\n",
       "      <td>day</td>\n",
       "      <td>1</td>\n",
       "      <td>1xGtDafUZbHyYC3Xarcbrj</td>\n",
       "      <td>track_46</td>\n",
       "      <td>spotify:album:6p20Rt4x2Qn5mUMRi1s6pj</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>single</td>\n",
       "      <td>2dwM9OcE4c3Ph1UBINSodx</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/1X...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/1XeoOqC1q7U2...</td>\n",
       "      <td>1XeoOqC1q7U2iyLEQJ64cu</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Sunshine</td>\n",
       "      <td>7/20/2018</td>\n",
       "      <td>day</td>\n",
       "      <td>1</td>\n",
       "      <td>0gWtsXvXOzAT6FtM3ur8in</td>\n",
       "      <td>track_10</td>\n",
       "      <td>spotify:album:1XeoOqC1q7U2iyLEQJ64cu</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75506</th>\n",
       "      <td>75506</td>\n",
       "      <td>album</td>\n",
       "      <td>0S7CCsKpXJ8e1dIstizHw5</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/4Z...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/4ZbkQn6amf1t...</td>\n",
       "      <td>4ZbkQn6amf1t3a202zen2u</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Latino For Life</td>\n",
       "      <td>1/24/2014</td>\n",
       "      <td>day</td>\n",
       "      <td>13</td>\n",
       "      <td>3CZY7jD1Zf30zIdbwS5212</td>\n",
       "      <td>track_17</td>\n",
       "      <td>spotify:album:4ZbkQn6amf1t3a202zen2u</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75507</th>\n",
       "      <td>75507</td>\n",
       "      <td>album</td>\n",
       "      <td>73Vk4dL8kYkbRJxWJDq1wL</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/4D...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/4DifRQy4Dyey...</td>\n",
       "      <td>4DifRQy4Dyey9NSS7ywnEx</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Dime Qué Pasa</td>\n",
       "      <td>3/31/2011</td>\n",
       "      <td>day</td>\n",
       "      <td>11</td>\n",
       "      <td>7GOBsKucPG5Bh8qzStmrQ6</td>\n",
       "      <td>track_18</td>\n",
       "      <td>spotify:album:4DifRQy4Dyey9NSS7ywnEx</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75508</th>\n",
       "      <td>75508</td>\n",
       "      <td>album</td>\n",
       "      <td>3yW6jTzGjHUUkLvLkjLOVn</td>\n",
       "      <td>['AU', 'NZ']</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/4P...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/4PXy3cBCNeY0...</td>\n",
       "      <td>4PXy3cBCNeY0ZVKTOGi9Cw</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Black Fingernails, Red Wine</td>\n",
       "      <td>6/10/2006</td>\n",
       "      <td>day</td>\n",
       "      <td>13</td>\n",
       "      <td>0ujklxrVM2jwpLMgbTwTd1</td>\n",
       "      <td>track_7</td>\n",
       "      <td>spotify:album:4PXy3cBCNeY0ZVKTOGi9Cw</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75509</th>\n",
       "      <td>75509</td>\n",
       "      <td>album</td>\n",
       "      <td>4iudEcmuPlYNdbP3e1bdn1</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/51...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/511p6iaCuK8S...</td>\n",
       "      <td>511p6iaCuK8Sr0BYdpcfkq</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>Freak Show</td>\n",
       "      <td>1997</td>\n",
       "      <td>year</td>\n",
       "      <td>13</td>\n",
       "      <td>58nHFSWj5N5JxNtWgS85TL</td>\n",
       "      <td>track_14</td>\n",
       "      <td>spotify:album:511p6iaCuK8Sr0BYdpcfkq</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75510</th>\n",
       "      <td>75510</td>\n",
       "      <td>album</td>\n",
       "      <td>023YMawCG3OvACmRjWxLWC</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>{'spotify': 'https://open.spotify.com/album/7H...</td>\n",
       "      <td>https://api.spotify.com/v1/albums/7H3Bgvb3hs4v...</td>\n",
       "      <td>7H3Bgvb3hs4vvLwccHDRlr</td>\n",
       "      <td>[{'height': 640, 'url': 'https://i.scdn.co/ima...</td>\n",
       "      <td>The Cat Empire</td>\n",
       "      <td>10/24/2003</td>\n",
       "      <td>day</td>\n",
       "      <td>13</td>\n",
       "      <td>1pXtUVmSS3Aky3j6nQ4sQT</td>\n",
       "      <td>track_21</td>\n",
       "      <td>spotify:album:7H3Bgvb3hs4vvLwccHDRlr</td>\n",
       "      <td>album</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75511 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 album_type               artist_id  \\\n",
       "0               0     single  3DiDSECUqqY1AuBP8qtaIa   \n",
       "1               1      album  6s1pCNXcbdtQJlsnM1hRIA   \n",
       "2               2     single  5YjfNaHq05WrwldRe1QSBc   \n",
       "3               3     single  2G9Vc16JCpnZmK4uGH46Fa   \n",
       "4               4     single  2dwM9OcE4c3Ph1UBINSodx   \n",
       "...           ...        ...                     ...   \n",
       "75506       75506      album  0S7CCsKpXJ8e1dIstizHw5   \n",
       "75507       75507      album  73Vk4dL8kYkbRJxWJDq1wL   \n",
       "75508       75508      album  3yW6jTzGjHUUkLvLkjLOVn   \n",
       "75509       75509      album  4iudEcmuPlYNdbP3e1bdn1   \n",
       "75510       75510      album  023YMawCG3OvACmRjWxLWC   \n",
       "\n",
       "                                       available_markets  \\\n",
       "0      ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "1      ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "2      ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "3      ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "4      ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "...                                                  ...   \n",
       "75506  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "75507  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "75508                                       ['AU', 'NZ']   \n",
       "75509  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "75510  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...   \n",
       "\n",
       "                                           external_urls  \\\n",
       "0      {'spotify': 'https://open.spotify.com/album/1g...   \n",
       "1      {'spotify': 'https://open.spotify.com/album/4K...   \n",
       "2      {'spotify': 'https://open.spotify.com/album/7n...   \n",
       "3      {'spotify': 'https://open.spotify.com/album/6p...   \n",
       "4      {'spotify': 'https://open.spotify.com/album/1X...   \n",
       "...                                                  ...   \n",
       "75506  {'spotify': 'https://open.spotify.com/album/4Z...   \n",
       "75507  {'spotify': 'https://open.spotify.com/album/4D...   \n",
       "75508  {'spotify': 'https://open.spotify.com/album/4P...   \n",
       "75509  {'spotify': 'https://open.spotify.com/album/51...   \n",
       "75510  {'spotify': 'https://open.spotify.com/album/7H...   \n",
       "\n",
       "                                                    href  \\\n",
       "0      https://api.spotify.com/v1/albums/1gAM7M4rBwEb...   \n",
       "1      https://api.spotify.com/v1/albums/4KfJZV7WfolY...   \n",
       "2      https://api.spotify.com/v1/albums/7nLYY7uAVUb5...   \n",
       "3      https://api.spotify.com/v1/albums/6p20Rt4x2Qn5...   \n",
       "4      https://api.spotify.com/v1/albums/1XeoOqC1q7U2...   \n",
       "...                                                  ...   \n",
       "75506  https://api.spotify.com/v1/albums/4ZbkQn6amf1t...   \n",
       "75507  https://api.spotify.com/v1/albums/4DifRQy4Dyey...   \n",
       "75508  https://api.spotify.com/v1/albums/4PXy3cBCNeY0...   \n",
       "75509  https://api.spotify.com/v1/albums/511p6iaCuK8S...   \n",
       "75510  https://api.spotify.com/v1/albums/7H3Bgvb3hs4v...   \n",
       "\n",
       "                           id  \\\n",
       "0      1gAM7M4rBwEbSPeAQR2nx1   \n",
       "1      4KfJZV7WfolYlxBzOTo66s   \n",
       "2      7nLYY7uAVUb57kpd7tZxnS   \n",
       "3      6p20Rt4x2Qn5mUMRi1s6pj   \n",
       "4      1XeoOqC1q7U2iyLEQJ64cu   \n",
       "...                       ...   \n",
       "75506  4ZbkQn6amf1t3a202zen2u   \n",
       "75507  4DifRQy4Dyey9NSS7ywnEx   \n",
       "75508  4PXy3cBCNeY0ZVKTOGi9Cw   \n",
       "75509  511p6iaCuK8Sr0BYdpcfkq   \n",
       "75510  7H3Bgvb3hs4vvLwccHDRlr   \n",
       "\n",
       "                                                  images  \\\n",
       "0      [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "1      [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "2      [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "3      [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "4      [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "...                                                  ...   \n",
       "75506  [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "75507  [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "75508  [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "75509  [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "75510  [{'height': 640, 'url': 'https://i.scdn.co/ima...   \n",
       "\n",
       "                                                    name release_date  \\\n",
       "0                                  If I Ain't Got You EP     2/8/2019   \n",
       "1      Shostakovich Symphony No.5 - Four Romances on ...     3/1/2019   \n",
       "2                                           Take My Bass    3/14/2019   \n",
       "3                                    Hypnotizing (Are U)   11/16/2016   \n",
       "4                                               Sunshine    7/20/2018   \n",
       "...                                                  ...          ...   \n",
       "75506                                    Latino For Life    1/24/2014   \n",
       "75507                                      Dime Qué Pasa    3/31/2011   \n",
       "75508                        Black Fingernails, Red Wine    6/10/2006   \n",
       "75509                                         Freak Show         1997   \n",
       "75510                                     The Cat Empire   10/24/2003   \n",
       "\n",
       "      release_date_precision  total_tracks                track_id  \\\n",
       "0                        day             6  2iejTMy9XZ8Gaae0aQ2yl0   \n",
       "1                        day             8  1WQfghEjszJJ4H8MAWrQ2C   \n",
       "2                        day             1  3jJKj4QTK3v18ZSwpk7AcV   \n",
       "3                        day             1  1xGtDafUZbHyYC3Xarcbrj   \n",
       "4                        day             1  0gWtsXvXOzAT6FtM3ur8in   \n",
       "...                      ...           ...                     ...   \n",
       "75506                    day            13  3CZY7jD1Zf30zIdbwS5212   \n",
       "75507                    day            11  7GOBsKucPG5Bh8qzStmrQ6   \n",
       "75508                    day            13  0ujklxrVM2jwpLMgbTwTd1   \n",
       "75509                   year            13  58nHFSWj5N5JxNtWgS85TL   \n",
       "75510                    day            13  1pXtUVmSS3Aky3j6nQ4sQT   \n",
       "\n",
       "      track_name_prev                                   uri   type  \n",
       "0            track_32  spotify:album:1gAM7M4rBwEbSPeAQR2nx1  album  \n",
       "1            track_11  spotify:album:4KfJZV7WfolYlxBzOTo66s  album  \n",
       "2            track_15  spotify:album:7nLYY7uAVUb57kpd7tZxnS  album  \n",
       "3            track_46  spotify:album:6p20Rt4x2Qn5mUMRi1s6pj  album  \n",
       "4            track_10  spotify:album:1XeoOqC1q7U2iyLEQJ64cu  album  \n",
       "...               ...                                   ...    ...  \n",
       "75506        track_17  spotify:album:4ZbkQn6amf1t3a202zen2u  album  \n",
       "75507        track_18  spotify:album:4DifRQy4Dyey9NSS7ywnEx  album  \n",
       "75508         track_7  spotify:album:4PXy3cBCNeY0ZVKTOGi9Cw  album  \n",
       "75509        track_14  spotify:album:511p6iaCuK8Sr0BYdpcfkq  album  \n",
       "75510        track_21  spotify:album:7H3Bgvb3hs4vvLwccHDRlr  album  \n",
       "\n",
       "[75511 rows x 16 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "albums_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "61cbaef5",
   "metadata": {},
   "outputs": [],
   "source": [
    "artists_data=pd.read_csv('spotify_artists.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "71eddda9",
   "metadata": {},
   "outputs": [],
   "source": [
    "tracks_data=pd.read_csv('spotify_tracks.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a176a9ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>artist_popularity</th>\n",
       "      <th>followers</th>\n",
       "      <th>genres</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>track_id</th>\n",
       "      <th>track_name_prev</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>23230</td>\n",
       "      <td>['sertanejo', 'sertanejo pop', 'sertanejo trad...</td>\n",
       "      <td>4mGnpjhqgx4RUdsIJiURdo</td>\n",
       "      <td>Juliano Cezar</td>\n",
       "      <td>0wmDmAILuW9e2aRttkl4aC</td>\n",
       "      <td>track_9</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>313</td>\n",
       "      <td>[]</td>\n",
       "      <td>1dLnVku4VQUOLswwDFvRc9</td>\n",
       "      <td>The Grenadines</td>\n",
       "      <td>4wqwj0gA8qPZKLl5WVqXml</td>\n",
       "      <td>track_30</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>1596</td>\n",
       "      <td>['danish pop rock']</td>\n",
       "      <td>6YVY310fjfUzKi8hiqR7iK</td>\n",
       "      <td>Gangway</td>\n",
       "      <td>1bFqWDbvHmZe2f4Nf9qaD8</td>\n",
       "      <td>track_38</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>149</td>\n",
       "      <td>['uk alternative pop']</td>\n",
       "      <td>2VElyouiCfoYPDJluzwJwK</td>\n",
       "      <td>FADES</td>\n",
       "      <td>3MFSUBAidPzRBbIS7BDj1S</td>\n",
       "      <td>track_34</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>['french baroque']</td>\n",
       "      <td>4agVy03qW8juSysCTUOuDI</td>\n",
       "      <td>Jean-Pierre Guignon</td>\n",
       "      <td>2r3q57FhxdsCyYr0kuDq4b</td>\n",
       "      <td>track_26</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56124</th>\n",
       "      <td>56124</td>\n",
       "      <td>23</td>\n",
       "      <td>1212</td>\n",
       "      <td>['chilean rock']</td>\n",
       "      <td>48YkQQTWzmT248VY8DF7Fv</td>\n",
       "      <td>Profetas y Freneticos</td>\n",
       "      <td>29WK73lMQpLELfHd6PfbjY</td>\n",
       "      <td>track_20</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56125</th>\n",
       "      <td>56125</td>\n",
       "      <td>42</td>\n",
       "      <td>57973</td>\n",
       "      <td>['aggro chileno', 'andean', 'chilean rock', 'l...</td>\n",
       "      <td>1OgaghfYd1qr8DFoNrfDNk</td>\n",
       "      <td>Sinergia</td>\n",
       "      <td>0rXhmIYRPIoVYstJdZt4uq</td>\n",
       "      <td>track_21</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56126</th>\n",
       "      <td>56126</td>\n",
       "      <td>38</td>\n",
       "      <td>20870</td>\n",
       "      <td>['australian alternative rock', 'australian ro...</td>\n",
       "      <td>7o9kdTx6RmO12iAVVsNehd</td>\n",
       "      <td>The Superjesus</td>\n",
       "      <td>1B7tV3WzEnDUS7wXSKDXk3</td>\n",
       "      <td>track_1</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56127</th>\n",
       "      <td>56127</td>\n",
       "      <td>44</td>\n",
       "      <td>33923</td>\n",
       "      <td>['australian alternative rock', 'australian ro...</td>\n",
       "      <td>6n3YUZcayLRuAunJUUelvz</td>\n",
       "      <td>Regurgitator</td>\n",
       "      <td>4e5wI6VC4eVDTtpyZ409Pw</td>\n",
       "      <td>track_8</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56128</th>\n",
       "      <td>56128</td>\n",
       "      <td>44</td>\n",
       "      <td>42026</td>\n",
       "      <td>['australian alternative rock', 'australian in...</td>\n",
       "      <td>47yawJswuSfSvizYhItoOP</td>\n",
       "      <td>Something For Kate</td>\n",
       "      <td>1bOjAQHYtPIsZfPAc1Qq61</td>\n",
       "      <td>track_9</td>\n",
       "      <td>artist</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56129 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  artist_popularity  followers  \\\n",
       "0               0                 44      23230   \n",
       "1               1                 22        313   \n",
       "2               2                 26       1596   \n",
       "3               3                 31        149   \n",
       "4               4                 21         11   \n",
       "...           ...                ...        ...   \n",
       "56124       56124                 23       1212   \n",
       "56125       56125                 42      57973   \n",
       "56126       56126                 38      20870   \n",
       "56127       56127                 44      33923   \n",
       "56128       56128                 44      42026   \n",
       "\n",
       "                                                  genres  \\\n",
       "0      ['sertanejo', 'sertanejo pop', 'sertanejo trad...   \n",
       "1                                                     []   \n",
       "2                                    ['danish pop rock']   \n",
       "3                                 ['uk alternative pop']   \n",
       "4                                     ['french baroque']   \n",
       "...                                                  ...   \n",
       "56124                                   ['chilean rock']   \n",
       "56125  ['aggro chileno', 'andean', 'chilean rock', 'l...   \n",
       "56126  ['australian alternative rock', 'australian ro...   \n",
       "56127  ['australian alternative rock', 'australian ro...   \n",
       "56128  ['australian alternative rock', 'australian in...   \n",
       "\n",
       "                           id                   name                track_id  \\\n",
       "0      4mGnpjhqgx4RUdsIJiURdo          Juliano Cezar  0wmDmAILuW9e2aRttkl4aC   \n",
       "1      1dLnVku4VQUOLswwDFvRc9         The Grenadines  4wqwj0gA8qPZKLl5WVqXml   \n",
       "2      6YVY310fjfUzKi8hiqR7iK                Gangway  1bFqWDbvHmZe2f4Nf9qaD8   \n",
       "3      2VElyouiCfoYPDJluzwJwK                  FADES  3MFSUBAidPzRBbIS7BDj1S   \n",
       "4      4agVy03qW8juSysCTUOuDI    Jean-Pierre Guignon  2r3q57FhxdsCyYr0kuDq4b   \n",
       "...                       ...                    ...                     ...   \n",
       "56124  48YkQQTWzmT248VY8DF7Fv  Profetas y Freneticos  29WK73lMQpLELfHd6PfbjY   \n",
       "56125  1OgaghfYd1qr8DFoNrfDNk               Sinergia  0rXhmIYRPIoVYstJdZt4uq   \n",
       "56126  7o9kdTx6RmO12iAVVsNehd         The Superjesus  1B7tV3WzEnDUS7wXSKDXk3   \n",
       "56127  6n3YUZcayLRuAunJUUelvz           Regurgitator  4e5wI6VC4eVDTtpyZ409Pw   \n",
       "56128  47yawJswuSfSvizYhItoOP     Something For Kate  1bOjAQHYtPIsZfPAc1Qq61   \n",
       "\n",
       "      track_name_prev    type  \n",
       "0             track_9  artist  \n",
       "1            track_30  artist  \n",
       "2            track_38  artist  \n",
       "3            track_34  artist  \n",
       "4            track_26  artist  \n",
       "...               ...     ...  \n",
       "56124        track_20  artist  \n",
       "56125        track_21  artist  \n",
       "56126         track_1  artist  \n",
       "56127         track_8  artist  \n",
       "56128         track_9  artist  \n",
       "\n",
       "[56129 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "artists_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cedf1d2e",
   "metadata": {},
   "source": [
    "## Joining the artist genre information and album release date with  the track dataset\n",
    "* dropping irrelevant columns\n",
    "* get only tracks after 2012"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7b55c0bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "def join_genre_and_date(artist_df,album_df,track_df):\n",
    "    album = album_df.rename(columns={'id':\"album_id\"}).set_index('album_id')\n",
    "    artist = artist_df.rename(columns={'id':\"artists_id\",'name':\"artists_name\"}).set_index('artists_id')\n",
    "    track = track_df.set_index('album_id').join(album['release_date'],on='album_id')\n",
    "    track.artists_id=track.artists_id.apply(lambda x: x[2:-2])\n",
    "    track = track.set_index('artists_id').join(artist[['artists_name','genres']] , on='artists_id')\n",
    "    track.reset_index(drop=False, inplace=True)\n",
    "    track['release_year']=pd.to_datetime(track.release_date).dt.year\n",
    "    track.drop(columns = ['Unnamed: 0','country','track_name_prev','track_number','type'], inplace = True)\n",
    "    return track[track.release_year >=2012]\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f1c6e63b",
   "metadata": {},
   "source": [
    "# Further filtering data according to genre preference "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "54f2d2f1",
   "metadata": {},
   "outputs": [],
   "source": [
    "def filtered_track_df(df,genres_to_include):\n",
    "    df['genres']=df.genres.apply(lambda x: [i[1:-1] for i in str(x)[1:-1].split(\",\")])\n",
    "    df_exploded = df.explode(\"genres\")[df.explode(\"genres\")[\"genres\"].isin(genres_to_include)]\n",
    "    df_exploded.loc[df_exploded[\"genres\"]==\"korean pop\",\"genres\"] = \"k-pop\"\n",
    "    df_exploded_indices=list(df_exploded.index.unique())\n",
    "    df=df[df.index.isin(df_exploded_indices)]\n",
    "    f=df.reset_index(drop=True)\n",
    "    return df\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "cd868392",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Genres that are not included in the list will be removed\n",
    "genres_to_include=genres = ['dance pop', 'uk drill', 'uk hip hop','japanese city pop',['uk hiphop','uk drill'], 'hip hop', 'k-pop', 'pop', 'pop rap']\n",
    "new_tracklist = join_genre_and_date(artists_data, albums_data, tracks_data)\n",
    "genrefiltered_track_df = filtered_track_df(new_tracklist, genres_to_include)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "623ac128",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artists_id</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>analysis_url</th>\n",
       "      <th>available_markets</th>\n",
       "      <th>danceability</th>\n",
       "      <th>disc_number</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>energy</th>\n",
       "      <th>href</th>\n",
       "      <th>id</th>\n",
       "      <th>...</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>tempo</th>\n",
       "      <th>time_signature</th>\n",
       "      <th>track_href</th>\n",
       "      <th>uri</th>\n",
       "      <th>valence</th>\n",
       "      <th>release_date</th>\n",
       "      <th>artists_name</th>\n",
       "      <th>genres</th>\n",
       "      <th>release_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.25700</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/26Q7...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.803</td>\n",
       "      <td>1.0</td>\n",
       "      <td>204393.0</td>\n",
       "      <td>0.833</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/26Q7f4tUntDt...</td>\n",
       "      <td>26Q7f4tUntDtlL4EyZz65X</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0844</td>\n",
       "      <td>130.002</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/26Q7f4tUntDt...</td>\n",
       "      <td>spotify:track:26Q7f4tUntDtlL4EyZz65X</td>\n",
       "      <td>0.783</td>\n",
       "      <td>10/7/2016</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.01950</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/0cdW...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.634</td>\n",
       "      <td>1.0</td>\n",
       "      <td>197429.0</td>\n",
       "      <td>0.964</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0cdWNnS1h92f...</td>\n",
       "      <td>0cdWNnS1h92fLcrKQzKaM6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0469</td>\n",
       "      <td>111.139</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0cdWNnS1h92f...</td>\n",
       "      <td>spotify:track:0cdWNnS1h92fLcrKQzKaM6</td>\n",
       "      <td>0.917</td>\n",
       "      <td>1/2/2019</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.02350</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/0xUK...</td>\n",
       "      <td>['CA', 'MX', 'US']</td>\n",
       "      <td>0.657</td>\n",
       "      <td>1.0</td>\n",
       "      <td>204190.0</td>\n",
       "      <td>0.697</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...</td>\n",
       "      <td>0xUKmfxvqoZ696QwNXeAyT</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1670</td>\n",
       "      <td>141.884</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...</td>\n",
       "      <td>spotify:track:0xUKmfxvqoZ696QwNXeAyT</td>\n",
       "      <td>0.216</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.14800</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/0df0...</td>\n",
       "      <td>['CA', 'MX', 'US']</td>\n",
       "      <td>0.808</td>\n",
       "      <td>1.0</td>\n",
       "      <td>229918.0</td>\n",
       "      <td>0.885</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0df0v14JjRFt...</td>\n",
       "      <td>0df0v14JjRFtYYH6uhs95Y</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2270</td>\n",
       "      <td>112.033</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0df0v14JjRFt...</td>\n",
       "      <td>spotify:track:0df0v14JjRFtYYH6uhs95Y</td>\n",
       "      <td>0.560</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>2BTZIqw0ntH9MvilQ3ewNY</td>\n",
       "      <td>0.11100</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/4Qes...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.795</td>\n",
       "      <td>1.0</td>\n",
       "      <td>136453.0</td>\n",
       "      <td>0.462</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4QesgDOrAoI2...</td>\n",
       "      <td>4QesgDOrAoI2sfMfrYgOnZ</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0461</td>\n",
       "      <td>114.423</td>\n",
       "      <td>3.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4QesgDOrAoI2...</td>\n",
       "      <td>spotify:track:4QesgDOrAoI2sfMfrYgOnZ</td>\n",
       "      <td>0.918</td>\n",
       "      <td>5/6/2016</td>\n",
       "      <td>Cyndi Lauper</td>\n",
       "      <td>[dance pop, 'dance rock, 'disco, 'europop, 'me...</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101854</th>\n",
       "      <td>5CCwRZC6euC8Odo6y9X8jr</td>\n",
       "      <td>0.15800</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/4c2W...</td>\n",
       "      <td>['AD', 'AR', 'AT', 'AU', 'BE', 'BG', 'BO', 'BR...</td>\n",
       "      <td>0.855</td>\n",
       "      <td>1.0</td>\n",
       "      <td>180757.0</td>\n",
       "      <td>0.624</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...</td>\n",
       "      <td>4c2W3VKsOFoIg2SFaO6DY5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0488</td>\n",
       "      <td>117.959</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...</td>\n",
       "      <td>spotify:track:4c2W3VKsOFoIg2SFaO6DY5</td>\n",
       "      <td>0.962</td>\n",
       "      <td>5/25/2017</td>\n",
       "      <td>Rita Ora</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop, 'r&amp;b, 'tropi...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101907</th>\n",
       "      <td>4npEfmQ6YuiwW1GpUmaq3F</td>\n",
       "      <td>0.07540</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/0uUN...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.684</td>\n",
       "      <td>1.0</td>\n",
       "      <td>184296.0</td>\n",
       "      <td>0.677</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...</td>\n",
       "      <td>0uUNN1nSoUx1A4fkDCWDQ7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0464</td>\n",
       "      <td>130.141</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...</td>\n",
       "      <td>spotify:track:0uUNN1nSoUx1A4fkDCWDQ7</td>\n",
       "      <td>0.595</td>\n",
       "      <td>3/7/2019</td>\n",
       "      <td>Ava Max</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop]</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101908</th>\n",
       "      <td>64M6ah0SkkRsnPGtGiRAbb</td>\n",
       "      <td>0.17500</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/0i0w...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.514</td>\n",
       "      <td>1.0</td>\n",
       "      <td>150333.0</td>\n",
       "      <td>0.618</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...</td>\n",
       "      <td>0i0wnv9UoFdZ5MfuFGQzMy</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0317</td>\n",
       "      <td>84.259</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...</td>\n",
       "      <td>spotify:track:0i0wnv9UoFdZ5MfuFGQzMy</td>\n",
       "      <td>0.401</td>\n",
       "      <td>2/15/2019</td>\n",
       "      <td>Bebe Rexha</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop]</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101911</th>\n",
       "      <td>5CCwRZC6euC8Odo6y9X8jr</td>\n",
       "      <td>0.28800</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/6xtc...</td>\n",
       "      <td>['AD', 'AR', 'AT', 'AU', 'BE', 'BG', 'BO', 'BR...</td>\n",
       "      <td>0.531</td>\n",
       "      <td>1.0</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>0.854</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...</td>\n",
       "      <td>6xtcFXSo8H9BZN637BMVKS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1980</td>\n",
       "      <td>94.419</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...</td>\n",
       "      <td>spotify:track:6xtcFXSo8H9BZN637BMVKS</td>\n",
       "      <td>0.456</td>\n",
       "      <td>9/21/2018</td>\n",
       "      <td>Rita Ora</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop, 'r&amp;b, 'tropi...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101924</th>\n",
       "      <td>0NIIxcxNHmOoyBx03SfTCD</td>\n",
       "      <td>0.00597</td>\n",
       "      <td>https://api.spotify.com/v1/audio-analysis/7D8a...</td>\n",
       "      <td>['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...</td>\n",
       "      <td>0.888</td>\n",
       "      <td>1.0</td>\n",
       "      <td>158757.0</td>\n",
       "      <td>0.586</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...</td>\n",
       "      <td>7D8aQaRzoi9Qzz5yerVK5b</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0604</td>\n",
       "      <td>150.051</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...</td>\n",
       "      <td>spotify:track:7D8aQaRzoi9Qzz5yerVK5b</td>\n",
       "      <td>0.401</td>\n",
       "      <td>7/27/2018</td>\n",
       "      <td>Tinashe</td>\n",
       "      <td>[dance pop, 'deep pop r&amp;b, 'electropop, 'metro...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1787 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    artists_id  acousticness  \\\n",
       "246     56oDRnqbIiwx4mymNEv7dS       0.25700   \n",
       "250     56oDRnqbIiwx4mymNEv7dS       0.01950   \n",
       "255     56oDRnqbIiwx4mymNEv7dS       0.02350   \n",
       "260     56oDRnqbIiwx4mymNEv7dS       0.14800   \n",
       "668     2BTZIqw0ntH9MvilQ3ewNY       0.11100   \n",
       "...                        ...           ...   \n",
       "101854  5CCwRZC6euC8Odo6y9X8jr       0.15800   \n",
       "101907  4npEfmQ6YuiwW1GpUmaq3F       0.07540   \n",
       "101908  64M6ah0SkkRsnPGtGiRAbb       0.17500   \n",
       "101911  5CCwRZC6euC8Odo6y9X8jr       0.28800   \n",
       "101924  0NIIxcxNHmOoyBx03SfTCD       0.00597   \n",
       "\n",
       "                                             analysis_url  \\\n",
       "246     https://api.spotify.com/v1/audio-analysis/26Q7...   \n",
       "250     https://api.spotify.com/v1/audio-analysis/0cdW...   \n",
       "255     https://api.spotify.com/v1/audio-analysis/0xUK...   \n",
       "260     https://api.spotify.com/v1/audio-analysis/0df0...   \n",
       "668     https://api.spotify.com/v1/audio-analysis/4Qes...   \n",
       "...                                                   ...   \n",
       "101854  https://api.spotify.com/v1/audio-analysis/4c2W...   \n",
       "101907  https://api.spotify.com/v1/audio-analysis/0uUN...   \n",
       "101908  https://api.spotify.com/v1/audio-analysis/0i0w...   \n",
       "101911  https://api.spotify.com/v1/audio-analysis/6xtc...   \n",
       "101924  https://api.spotify.com/v1/audio-analysis/7D8a...   \n",
       "\n",
       "                                        available_markets  danceability  \\\n",
       "246     ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.803   \n",
       "250     ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.634   \n",
       "255                                    ['CA', 'MX', 'US']         0.657   \n",
       "260                                    ['CA', 'MX', 'US']         0.808   \n",
       "668     ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.795   \n",
       "...                                                   ...           ...   \n",
       "101854  ['AD', 'AR', 'AT', 'AU', 'BE', 'BG', 'BO', 'BR...         0.855   \n",
       "101907  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.684   \n",
       "101908  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.514   \n",
       "101911  ['AD', 'AR', 'AT', 'AU', 'BE', 'BG', 'BO', 'BR...         0.531   \n",
       "101924  ['AD', 'AE', 'AR', 'AT', 'AU', 'BE', 'BG', 'BH...         0.888   \n",
       "\n",
       "        disc_number  duration_ms  energy  \\\n",
       "246             1.0     204393.0   0.833   \n",
       "250             1.0     197429.0   0.964   \n",
       "255             1.0     204190.0   0.697   \n",
       "260             1.0     229918.0   0.885   \n",
       "668             1.0     136453.0   0.462   \n",
       "...             ...          ...     ...   \n",
       "101854          1.0     180757.0   0.624   \n",
       "101907          1.0     184296.0   0.677   \n",
       "101908          1.0     150333.0   0.618   \n",
       "101911          1.0     190000.0   0.854   \n",
       "101924          1.0     158757.0   0.586   \n",
       "\n",
       "                                                     href  \\\n",
       "246     https://api.spotify.com/v1/tracks/26Q7f4tUntDt...   \n",
       "250     https://api.spotify.com/v1/tracks/0cdWNnS1h92f...   \n",
       "255     https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...   \n",
       "260     https://api.spotify.com/v1/tracks/0df0v14JjRFt...   \n",
       "668     https://api.spotify.com/v1/tracks/4QesgDOrAoI2...   \n",
       "...                                                   ...   \n",
       "101854  https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...   \n",
       "101907  https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...   \n",
       "101908  https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...   \n",
       "101911  https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...   \n",
       "101924  https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...   \n",
       "\n",
       "                            id  ...  speechiness    tempo  time_signature  \\\n",
       "246     26Q7f4tUntDtlL4EyZz65X  ...       0.0844  130.002             4.0   \n",
       "250     0cdWNnS1h92fLcrKQzKaM6  ...       0.0469  111.139             4.0   \n",
       "255     0xUKmfxvqoZ696QwNXeAyT  ...       0.1670  141.884             4.0   \n",
       "260     0df0v14JjRFtYYH6uhs95Y  ...       0.2270  112.033             4.0   \n",
       "668     4QesgDOrAoI2sfMfrYgOnZ  ...       0.0461  114.423             3.0   \n",
       "...                        ...  ...          ...      ...             ...   \n",
       "101854  4c2W3VKsOFoIg2SFaO6DY5  ...       0.0488  117.959             4.0   \n",
       "101907  0uUNN1nSoUx1A4fkDCWDQ7  ...       0.0464  130.141             4.0   \n",
       "101908  0i0wnv9UoFdZ5MfuFGQzMy  ...       0.0317   84.259             4.0   \n",
       "101911  6xtcFXSo8H9BZN637BMVKS  ...       0.1980   94.419             4.0   \n",
       "101924  7D8aQaRzoi9Qzz5yerVK5b  ...       0.0604  150.051             4.0   \n",
       "\n",
       "                                               track_href  \\\n",
       "246     https://api.spotify.com/v1/tracks/26Q7f4tUntDt...   \n",
       "250     https://api.spotify.com/v1/tracks/0cdWNnS1h92f...   \n",
       "255     https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...   \n",
       "260     https://api.spotify.com/v1/tracks/0df0v14JjRFt...   \n",
       "668     https://api.spotify.com/v1/tracks/4QesgDOrAoI2...   \n",
       "...                                                   ...   \n",
       "101854  https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...   \n",
       "101907  https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...   \n",
       "101908  https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...   \n",
       "101911  https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...   \n",
       "101924  https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...   \n",
       "\n",
       "                                         uri  valence release_date  \\\n",
       "246     spotify:track:26Q7f4tUntDtlL4EyZz65X    0.783    10/7/2016   \n",
       "250     spotify:track:0cdWNnS1h92fLcrKQzKaM6    0.917     1/2/2019   \n",
       "255     spotify:track:0xUKmfxvqoZ696QwNXeAyT    0.216   12/11/2015   \n",
       "260     spotify:track:0df0v14JjRFtYYH6uhs95Y    0.560   12/11/2015   \n",
       "668     spotify:track:4QesgDOrAoI2sfMfrYgOnZ    0.918     5/6/2016   \n",
       "...                                      ...      ...          ...   \n",
       "101854  spotify:track:4c2W3VKsOFoIg2SFaO6DY5    0.962    5/25/2017   \n",
       "101907  spotify:track:0uUNN1nSoUx1A4fkDCWDQ7    0.595     3/7/2019   \n",
       "101908  spotify:track:0i0wnv9UoFdZ5MfuFGQzMy    0.401    2/15/2019   \n",
       "101911  spotify:track:6xtcFXSo8H9BZN637BMVKS    0.456    9/21/2018   \n",
       "101924  spotify:track:7D8aQaRzoi9Qzz5yerVK5b    0.401    7/27/2018   \n",
       "\n",
       "        artists_name                                             genres  \\\n",
       "246            Lizzo  [dance pop, 'electropop, 'escape room, 'pop, '...   \n",
       "250            Lizzo  [dance pop, 'electropop, 'escape room, 'pop, '...   \n",
       "255            Lizzo  [dance pop, 'electropop, 'escape room, 'pop, '...   \n",
       "260            Lizzo  [dance pop, 'electropop, 'escape room, 'pop, '...   \n",
       "668     Cyndi Lauper  [dance pop, 'dance rock, 'disco, 'europop, 'me...   \n",
       "...              ...                                                ...   \n",
       "101854      Rita Ora  [dance pop, 'pop, 'post-teen pop, 'r&b, 'tropi...   \n",
       "101907       Ava Max                  [dance pop, 'pop, 'post-teen pop]   \n",
       "101908    Bebe Rexha                  [dance pop, 'pop, 'post-teen pop]   \n",
       "101911      Rita Ora  [dance pop, 'pop, 'post-teen pop, 'r&b, 'tropi...   \n",
       "101924       Tinashe  [dance pop, 'deep pop r&b, 'electropop, 'metro...   \n",
       "\n",
       "       release_year  \n",
       "246            2016  \n",
       "250            2019  \n",
       "255            2015  \n",
       "260            2015  \n",
       "668            2016  \n",
       "...             ...  \n",
       "101854         2017  \n",
       "101907         2019  \n",
       "101908         2019  \n",
       "101911         2018  \n",
       "101924         2018  \n",
       "\n",
       "[1787 rows x 30 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genrefiltered_track_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21e99fc6",
   "metadata": {},
   "source": [
    "## more preprocessing for the uri column , drop unnecessary columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "725339d0",
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "\"['analysis_url', 'available_markets'] not found in axis\"",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Input \u001b[1;32mIn [21]\u001b[0m, in \u001b[0;36m<cell line: 2>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      1\u001b[0m genrefiltered_track_df[\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124muri\u001b[39m\u001b[38;5;124m\"\u001b[39m]\u001b[38;5;241m=\u001b[39mgenrefiltered_track_df[\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124muri\u001b[39m\u001b[38;5;124m\"\u001b[39m]\u001b[38;5;241m.\u001b[39mstr\u001b[38;5;241m.\u001b[39mreplace(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mspotify:track:\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[1;32m----> 2\u001b[0m genrefiltered_track_df\u001b[38;5;241m=\u001b[39m\u001b[43mgenrefiltered_track_df\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdrop\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcolumns\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43manalysis_url\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m,\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mavailable_markets\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mC:\\Python310\\lib\\site-packages\\pandas\\util\\_decorators.py:311\u001b[0m, in \u001b[0;36mdeprecate_nonkeyword_arguments.<locals>.decorate.<locals>.wrapper\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m    305\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mlen\u001b[39m(args) \u001b[38;5;241m>\u001b[39m num_allow_args:\n\u001b[0;32m    306\u001b[0m     warnings\u001b[38;5;241m.\u001b[39mwarn(\n\u001b[0;32m    307\u001b[0m         msg\u001b[38;5;241m.\u001b[39mformat(arguments\u001b[38;5;241m=\u001b[39marguments),\n\u001b[0;32m    308\u001b[0m         \u001b[38;5;167;01mFutureWarning\u001b[39;00m,\n\u001b[0;32m    309\u001b[0m         stacklevel\u001b[38;5;241m=\u001b[39mstacklevel,\n\u001b[0;32m    310\u001b[0m     )\n\u001b[1;32m--> 311\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m func(\u001b[38;5;241m*\u001b[39margs, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs)\n",
      "File \u001b[1;32mC:\\Python310\\lib\\site-packages\\pandas\\core\\frame.py:4954\u001b[0m, in \u001b[0;36mDataFrame.drop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   4806\u001b[0m \u001b[38;5;129m@deprecate_nonkeyword_arguments\u001b[39m(version\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m, allowed_args\u001b[38;5;241m=\u001b[39m[\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mself\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mlabels\u001b[39m\u001b[38;5;124m\"\u001b[39m])\n\u001b[0;32m   4807\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdrop\u001b[39m(\n\u001b[0;32m   4808\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   4815\u001b[0m     errors: \u001b[38;5;28mstr\u001b[39m \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mraise\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m   4816\u001b[0m ):\n\u001b[0;32m   4817\u001b[0m     \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[0;32m   4818\u001b[0m \u001b[38;5;124;03m    Drop specified labels from rows or columns.\u001b[39;00m\n\u001b[0;32m   4819\u001b[0m \n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   4952\u001b[0m \u001b[38;5;124;03m            weight  1.0     0.8\u001b[39;00m\n\u001b[0;32m   4953\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[1;32m-> 4954\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43msuper\u001b[39;49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdrop\u001b[49m\u001b[43m(\u001b[49m\n\u001b[0;32m   4955\u001b[0m \u001b[43m        \u001b[49m\u001b[43mlabels\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mlabels\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4956\u001b[0m \u001b[43m        \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4957\u001b[0m \u001b[43m        \u001b[49m\u001b[43mindex\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mindex\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4958\u001b[0m \u001b[43m        \u001b[49m\u001b[43mcolumns\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mcolumns\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4959\u001b[0m \u001b[43m        \u001b[49m\u001b[43mlevel\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mlevel\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4960\u001b[0m \u001b[43m        \u001b[49m\u001b[43minplace\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43minplace\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4961\u001b[0m \u001b[43m        \u001b[49m\u001b[43merrors\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43merrors\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   4962\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mC:\\Python310\\lib\\site-packages\\pandas\\core\\generic.py:4267\u001b[0m, in \u001b[0;36mNDFrame.drop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   4265\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m axis, labels \u001b[38;5;129;01min\u001b[39;00m axes\u001b[38;5;241m.\u001b[39mitems():\n\u001b[0;32m   4266\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m labels \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m-> 4267\u001b[0m         obj \u001b[38;5;241m=\u001b[39m \u001b[43mobj\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_drop_axis\u001b[49m\u001b[43m(\u001b[49m\u001b[43mlabels\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mlevel\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mlevel\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43merrors\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43merrors\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   4269\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m inplace:\n\u001b[0;32m   4270\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_update_inplace(obj)\n",
      "File \u001b[1;32mC:\\Python310\\lib\\site-packages\\pandas\\core\\generic.py:4311\u001b[0m, in \u001b[0;36mNDFrame._drop_axis\u001b[1;34m(self, labels, axis, level, errors, consolidate, only_slice)\u001b[0m\n\u001b[0;32m   4309\u001b[0m         new_axis \u001b[38;5;241m=\u001b[39m axis\u001b[38;5;241m.\u001b[39mdrop(labels, level\u001b[38;5;241m=\u001b[39mlevel, errors\u001b[38;5;241m=\u001b[39merrors)\n\u001b[0;32m   4310\u001b[0m     \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m-> 4311\u001b[0m         new_axis \u001b[38;5;241m=\u001b[39m \u001b[43maxis\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdrop\u001b[49m\u001b[43m(\u001b[49m\u001b[43mlabels\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43merrors\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43merrors\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   4312\u001b[0m     indexer \u001b[38;5;241m=\u001b[39m axis\u001b[38;5;241m.\u001b[39mget_indexer(new_axis)\n\u001b[0;32m   4314\u001b[0m \u001b[38;5;66;03m# Case for non-unique axis\u001b[39;00m\n\u001b[0;32m   4315\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n",
      "File \u001b[1;32mC:\\Python310\\lib\\site-packages\\pandas\\core\\indexes\\base.py:6644\u001b[0m, in \u001b[0;36mIndex.drop\u001b[1;34m(self, labels, errors)\u001b[0m\n\u001b[0;32m   6642\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m mask\u001b[38;5;241m.\u001b[39many():\n\u001b[0;32m   6643\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m errors \u001b[38;5;241m!=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mignore\u001b[39m\u001b[38;5;124m\"\u001b[39m:\n\u001b[1;32m-> 6644\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(\u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;132;01m{\u001b[39;00m\u001b[38;5;28mlist\u001b[39m(labels[mask])\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m not found in axis\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[0;32m   6645\u001b[0m     indexer \u001b[38;5;241m=\u001b[39m indexer[\u001b[38;5;241m~\u001b[39mmask]\n\u001b[0;32m   6646\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdelete(indexer)\n",
      "\u001b[1;31mKeyError\u001b[0m: \"['analysis_url', 'available_markets'] not found in axis\""
     ]
    }
   ],
   "source": [
    "genrefiltered_track_df[\"uri\"]=genrefiltered_track_df[\"uri\"].str.replace(\"spotify:track:\", \"\")\n",
    "genrefiltered_track_df=genrefiltered_track_df.drop(columns=['analysis_url','available_markets'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "2dc9080b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artists_id</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>danceability</th>\n",
       "      <th>disc_number</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>energy</th>\n",
       "      <th>href</th>\n",
       "      <th>id</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>key</th>\n",
       "      <th>...</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>tempo</th>\n",
       "      <th>time_signature</th>\n",
       "      <th>track_href</th>\n",
       "      <th>uri</th>\n",
       "      <th>valence</th>\n",
       "      <th>release_date</th>\n",
       "      <th>artists_name</th>\n",
       "      <th>genres</th>\n",
       "      <th>release_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.25700</td>\n",
       "      <td>0.803</td>\n",
       "      <td>1.0</td>\n",
       "      <td>204393.0</td>\n",
       "      <td>0.833</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/26Q7f4tUntDt...</td>\n",
       "      <td>26Q7f4tUntDtlL4EyZz65X</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0844</td>\n",
       "      <td>130.002</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/26Q7f4tUntDt...</td>\n",
       "      <td>26Q7f4tUntDtlL4EyZz65X</td>\n",
       "      <td>0.783</td>\n",
       "      <td>10/7/2016</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.01950</td>\n",
       "      <td>0.634</td>\n",
       "      <td>1.0</td>\n",
       "      <td>197429.0</td>\n",
       "      <td>0.964</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0cdWNnS1h92f...</td>\n",
       "      <td>0cdWNnS1h92fLcrKQzKaM6</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0469</td>\n",
       "      <td>111.139</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0cdWNnS1h92f...</td>\n",
       "      <td>0cdWNnS1h92fLcrKQzKaM6</td>\n",
       "      <td>0.917</td>\n",
       "      <td>1/2/2019</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.02350</td>\n",
       "      <td>0.657</td>\n",
       "      <td>1.0</td>\n",
       "      <td>204190.0</td>\n",
       "      <td>0.697</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...</td>\n",
       "      <td>0xUKmfxvqoZ696QwNXeAyT</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1670</td>\n",
       "      <td>141.884</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...</td>\n",
       "      <td>0xUKmfxvqoZ696QwNXeAyT</td>\n",
       "      <td>0.216</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>56oDRnqbIiwx4mymNEv7dS</td>\n",
       "      <td>0.14800</td>\n",
       "      <td>0.808</td>\n",
       "      <td>1.0</td>\n",
       "      <td>229918.0</td>\n",
       "      <td>0.885</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0df0v14JjRFt...</td>\n",
       "      <td>0df0v14JjRFtYYH6uhs95Y</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2270</td>\n",
       "      <td>112.033</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0df0v14JjRFt...</td>\n",
       "      <td>0df0v14JjRFtYYH6uhs95Y</td>\n",
       "      <td>0.560</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Lizzo</td>\n",
       "      <td>[dance pop, 'electropop, 'escape room, 'pop, '...</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>2BTZIqw0ntH9MvilQ3ewNY</td>\n",
       "      <td>0.11100</td>\n",
       "      <td>0.795</td>\n",
       "      <td>1.0</td>\n",
       "      <td>136453.0</td>\n",
       "      <td>0.462</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4QesgDOrAoI2...</td>\n",
       "      <td>4QesgDOrAoI2sfMfrYgOnZ</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0461</td>\n",
       "      <td>114.423</td>\n",
       "      <td>3.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4QesgDOrAoI2...</td>\n",
       "      <td>4QesgDOrAoI2sfMfrYgOnZ</td>\n",
       "      <td>0.918</td>\n",
       "      <td>5/6/2016</td>\n",
       "      <td>Cyndi Lauper</td>\n",
       "      <td>[dance pop, 'dance rock, 'disco, 'europop, 'me...</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101854</th>\n",
       "      <td>5CCwRZC6euC8Odo6y9X8jr</td>\n",
       "      <td>0.15800</td>\n",
       "      <td>0.855</td>\n",
       "      <td>1.0</td>\n",
       "      <td>180757.0</td>\n",
       "      <td>0.624</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...</td>\n",
       "      <td>4c2W3VKsOFoIg2SFaO6DY5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0488</td>\n",
       "      <td>117.959</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...</td>\n",
       "      <td>4c2W3VKsOFoIg2SFaO6DY5</td>\n",
       "      <td>0.962</td>\n",
       "      <td>5/25/2017</td>\n",
       "      <td>Rita Ora</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop, 'r&amp;b, 'tropi...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101907</th>\n",
       "      <td>4npEfmQ6YuiwW1GpUmaq3F</td>\n",
       "      <td>0.07540</td>\n",
       "      <td>0.684</td>\n",
       "      <td>1.0</td>\n",
       "      <td>184296.0</td>\n",
       "      <td>0.677</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...</td>\n",
       "      <td>0uUNN1nSoUx1A4fkDCWDQ7</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0464</td>\n",
       "      <td>130.141</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...</td>\n",
       "      <td>0uUNN1nSoUx1A4fkDCWDQ7</td>\n",
       "      <td>0.595</td>\n",
       "      <td>3/7/2019</td>\n",
       "      <td>Ava Max</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop]</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101908</th>\n",
       "      <td>64M6ah0SkkRsnPGtGiRAbb</td>\n",
       "      <td>0.17500</td>\n",
       "      <td>0.514</td>\n",
       "      <td>1.0</td>\n",
       "      <td>150333.0</td>\n",
       "      <td>0.618</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...</td>\n",
       "      <td>0i0wnv9UoFdZ5MfuFGQzMy</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0317</td>\n",
       "      <td>84.259</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...</td>\n",
       "      <td>0i0wnv9UoFdZ5MfuFGQzMy</td>\n",
       "      <td>0.401</td>\n",
       "      <td>2/15/2019</td>\n",
       "      <td>Bebe Rexha</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop]</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101911</th>\n",
       "      <td>5CCwRZC6euC8Odo6y9X8jr</td>\n",
       "      <td>0.28800</td>\n",
       "      <td>0.531</td>\n",
       "      <td>1.0</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>0.854</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...</td>\n",
       "      <td>6xtcFXSo8H9BZN637BMVKS</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1980</td>\n",
       "      <td>94.419</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...</td>\n",
       "      <td>6xtcFXSo8H9BZN637BMVKS</td>\n",
       "      <td>0.456</td>\n",
       "      <td>9/21/2018</td>\n",
       "      <td>Rita Ora</td>\n",
       "      <td>[dance pop, 'pop, 'post-teen pop, 'r&amp;b, 'tropi...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101924</th>\n",
       "      <td>0NIIxcxNHmOoyBx03SfTCD</td>\n",
       "      <td>0.00597</td>\n",
       "      <td>0.888</td>\n",
       "      <td>1.0</td>\n",
       "      <td>158757.0</td>\n",
       "      <td>0.586</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...</td>\n",
       "      <td>7D8aQaRzoi9Qzz5yerVK5b</td>\n",
       "      <td>0.036500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0604</td>\n",
       "      <td>150.051</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...</td>\n",
       "      <td>7D8aQaRzoi9Qzz5yerVK5b</td>\n",
       "      <td>0.401</td>\n",
       "      <td>7/27/2018</td>\n",
       "      <td>Tinashe</td>\n",
       "      <td>[dance pop, 'deep pop r&amp;b, 'electropop, 'metro...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1787 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    artists_id  acousticness  danceability  disc_number  \\\n",
       "246     56oDRnqbIiwx4mymNEv7dS       0.25700         0.803          1.0   \n",
       "250     56oDRnqbIiwx4mymNEv7dS       0.01950         0.634          1.0   \n",
       "255     56oDRnqbIiwx4mymNEv7dS       0.02350         0.657          1.0   \n",
       "260     56oDRnqbIiwx4mymNEv7dS       0.14800         0.808          1.0   \n",
       "668     2BTZIqw0ntH9MvilQ3ewNY       0.11100         0.795          1.0   \n",
       "...                        ...           ...           ...          ...   \n",
       "101854  5CCwRZC6euC8Odo6y9X8jr       0.15800         0.855          1.0   \n",
       "101907  4npEfmQ6YuiwW1GpUmaq3F       0.07540         0.684          1.0   \n",
       "101908  64M6ah0SkkRsnPGtGiRAbb       0.17500         0.514          1.0   \n",
       "101911  5CCwRZC6euC8Odo6y9X8jr       0.28800         0.531          1.0   \n",
       "101924  0NIIxcxNHmOoyBx03SfTCD       0.00597         0.888          1.0   \n",
       "\n",
       "        duration_ms  energy  \\\n",
       "246        204393.0   0.833   \n",
       "250        197429.0   0.964   \n",
       "255        204190.0   0.697   \n",
       "260        229918.0   0.885   \n",
       "668        136453.0   0.462   \n",
       "...             ...     ...   \n",
       "101854     180757.0   0.624   \n",
       "101907     184296.0   0.677   \n",
       "101908     150333.0   0.618   \n",
       "101911     190000.0   0.854   \n",
       "101924     158757.0   0.586   \n",
       "\n",
       "                                                     href  \\\n",
       "246     https://api.spotify.com/v1/tracks/26Q7f4tUntDt...   \n",
       "250     https://api.spotify.com/v1/tracks/0cdWNnS1h92f...   \n",
       "255     https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...   \n",
       "260     https://api.spotify.com/v1/tracks/0df0v14JjRFt...   \n",
       "668     https://api.spotify.com/v1/tracks/4QesgDOrAoI2...   \n",
       "...                                                   ...   \n",
       "101854  https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...   \n",
       "101907  https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...   \n",
       "101908  https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...   \n",
       "101911  https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...   \n",
       "101924  https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...   \n",
       "\n",
       "                            id  instrumentalness   key  ...  speechiness  \\\n",
       "246     26Q7f4tUntDtlL4EyZz65X          0.000001   0.0  ...       0.0844   \n",
       "250     0cdWNnS1h92fLcrKQzKaM6          0.000000   1.0  ...       0.0469   \n",
       "255     0xUKmfxvqoZ696QwNXeAyT          0.000000  10.0  ...       0.1670   \n",
       "260     0df0v14JjRFtYYH6uhs95Y          0.000000   7.0  ...       0.2270   \n",
       "668     4QesgDOrAoI2sfMfrYgOnZ          0.000004   1.0  ...       0.0461   \n",
       "...                        ...               ...   ...  ...          ...   \n",
       "101854  4c2W3VKsOFoIg2SFaO6DY5          0.000000   1.0  ...       0.0488   \n",
       "101907  0uUNN1nSoUx1A4fkDCWDQ7          0.000000   6.0  ...       0.0464   \n",
       "101908  0i0wnv9UoFdZ5MfuFGQzMy          0.000000  11.0  ...       0.0317   \n",
       "101911  6xtcFXSo8H9BZN637BMVKS          0.000000  10.0  ...       0.1980   \n",
       "101924  7D8aQaRzoi9Qzz5yerVK5b          0.036500   0.0  ...       0.0604   \n",
       "\n",
       "          tempo time_signature  \\\n",
       "246     130.002            4.0   \n",
       "250     111.139            4.0   \n",
       "255     141.884            4.0   \n",
       "260     112.033            4.0   \n",
       "668     114.423            3.0   \n",
       "...         ...            ...   \n",
       "101854  117.959            4.0   \n",
       "101907  130.141            4.0   \n",
       "101908   84.259            4.0   \n",
       "101911   94.419            4.0   \n",
       "101924  150.051            4.0   \n",
       "\n",
       "                                               track_href  \\\n",
       "246     https://api.spotify.com/v1/tracks/26Q7f4tUntDt...   \n",
       "250     https://api.spotify.com/v1/tracks/0cdWNnS1h92f...   \n",
       "255     https://api.spotify.com/v1/tracks/0xUKmfxvqoZ6...   \n",
       "260     https://api.spotify.com/v1/tracks/0df0v14JjRFt...   \n",
       "668     https://api.spotify.com/v1/tracks/4QesgDOrAoI2...   \n",
       "...                                                   ...   \n",
       "101854  https://api.spotify.com/v1/tracks/4c2W3VKsOFoI...   \n",
       "101907  https://api.spotify.com/v1/tracks/0uUNN1nSoUx1...   \n",
       "101908  https://api.spotify.com/v1/tracks/0i0wnv9UoFdZ...   \n",
       "101911  https://api.spotify.com/v1/tracks/6xtcFXSo8H9B...   \n",
       "101924  https://api.spotify.com/v1/tracks/7D8aQaRzoi9Q...   \n",
       "\n",
       "                           uri valence  release_date  artists_name  \\\n",
       "246     26Q7f4tUntDtlL4EyZz65X   0.783     10/7/2016         Lizzo   \n",
       "250     0cdWNnS1h92fLcrKQzKaM6   0.917      1/2/2019         Lizzo   \n",
       "255     0xUKmfxvqoZ696QwNXeAyT   0.216    12/11/2015         Lizzo   \n",
       "260     0df0v14JjRFtYYH6uhs95Y   0.560    12/11/2015         Lizzo   \n",
       "668     4QesgDOrAoI2sfMfrYgOnZ   0.918      5/6/2016  Cyndi Lauper   \n",
       "...                        ...     ...           ...           ...   \n",
       "101854  4c2W3VKsOFoIg2SFaO6DY5   0.962     5/25/2017      Rita Ora   \n",
       "101907  0uUNN1nSoUx1A4fkDCWDQ7   0.595      3/7/2019       Ava Max   \n",
       "101908  0i0wnv9UoFdZ5MfuFGQzMy   0.401     2/15/2019    Bebe Rexha   \n",
       "101911  6xtcFXSo8H9BZN637BMVKS   0.456     9/21/2018      Rita Ora   \n",
       "101924  7D8aQaRzoi9Qzz5yerVK5b   0.401     7/27/2018       Tinashe   \n",
       "\n",
       "                                                   genres  release_year  \n",
       "246     [dance pop, 'electropop, 'escape room, 'pop, '...          2016  \n",
       "250     [dance pop, 'electropop, 'escape room, 'pop, '...          2019  \n",
       "255     [dance pop, 'electropop, 'escape room, 'pop, '...          2015  \n",
       "260     [dance pop, 'electropop, 'escape room, 'pop, '...          2015  \n",
       "668     [dance pop, 'dance rock, 'disco, 'europop, 'me...          2016  \n",
       "...                                                   ...           ...  \n",
       "101854  [dance pop, 'pop, 'post-teen pop, 'r&b, 'tropi...          2017  \n",
       "101907                  [dance pop, 'pop, 'post-teen pop]          2019  \n",
       "101908                  [dance pop, 'pop, 'post-teen pop]          2019  \n",
       "101911  [dance pop, 'pop, 'post-teen pop, 'r&b, 'tropi...          2018  \n",
       "101924  [dance pop, 'deep pop r&b, 'electropop, 'metro...          2018  \n",
       "\n",
       "[1787 rows x 28 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genrefiltered_track_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "224dd259",
   "metadata": {},
   "outputs": [],
   "source": [
    "genrefiltered_track_df.to_csv(\"cleaned_dataset.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5b1ad761",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.5 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.5"
  },
  "vscode": {
   "interpreter": {
    "hash": "369f2c481f4da34e4445cda3fffd2e751bd1c4d706f27375911949ba6bb62e1c"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}