spotifyDataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "a80887be",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandas import read_csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "bf5aaaf4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(32833, 22)"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = 'https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2020/2020-01-21/spotify_songs.csv'\n",
    "dataset = read_csv(url, index_col=0)\n",
    "dataset.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "63681cde",
   "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>track_name</th>\n",
       "      <th>track_artist</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_id</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>playlist_name</th>\n",
       "      <th>playlist_id</th>\n",
       "      <th>playlist_genre</th>\n",
       "      <th>playlist_subgenre</th>\n",
       "      <th>...</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>track_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6f807x0ima9a1j3VPbc7VN</th>\n",
       "      <td>I Don't Care (with Justin Bieber) - Loud Luxur...</td>\n",
       "      <td>Ed Sheeran</td>\n",
       "      <td>66</td>\n",
       "      <td>2oCs0DGTsRO98Gh5ZSl2Cx</td>\n",
       "      <td>I Don't Care (with Justin Bieber) [Loud Luxury...</td>\n",
       "      <td>2019-06-14</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>-2.634</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0653</td>\n",
       "      <td>0.518</td>\n",
       "      <td>122.036</td>\n",
       "      <td>194754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0r7CVbZTWZgbTCYdfa2P31</th>\n",
       "      <td>Memories - Dillon Francis Remix</td>\n",
       "      <td>Maroon 5</td>\n",
       "      <td>67</td>\n",
       "      <td>63rPSO264uRjW1X5E6cWv6</td>\n",
       "      <td>Memories (Dillon Francis Remix)</td>\n",
       "      <td>2019-12-13</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>-4.969</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0373</td>\n",
       "      <td>0.0724</td>\n",
       "      <td>0.004210</td>\n",
       "      <td>0.3570</td>\n",
       "      <td>0.693</td>\n",
       "      <td>99.972</td>\n",
       "      <td>162600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1z1Hg7Vb0AhHDiEmnDE79l</th>\n",
       "      <td>All the Time - Don Diablo Remix</td>\n",
       "      <td>Zara Larsson</td>\n",
       "      <td>70</td>\n",
       "      <td>1HoSmj2eLcsrR0vE9gThr4</td>\n",
       "      <td>All the Time (Don Diablo Remix)</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>-3.432</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0742</td>\n",
       "      <td>0.0794</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.613</td>\n",
       "      <td>124.008</td>\n",
       "      <td>176616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75FpbthrwQmzHlBJLuGdC7</th>\n",
       "      <td>Call You Mine - Keanu Silva Remix</td>\n",
       "      <td>The Chainsmokers</td>\n",
       "      <td>60</td>\n",
       "      <td>1nqYsOef1yKKuGOVchbsk6</td>\n",
       "      <td>Call You Mine - The Remixes</td>\n",
       "      <td>2019-07-19</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>-3.778</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.0287</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>0.277</td>\n",
       "      <td>121.956</td>\n",
       "      <td>169093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1e8PAfcKUYoKkxPhrHqw4x</th>\n",
       "      <td>Someone You Loved - Future Humans Remix</td>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>69</td>\n",
       "      <td>7m7vv9wlQ4i0LFuJiE2zsQ</td>\n",
       "      <td>Someone You Loved (Future Humans Remix)</td>\n",
       "      <td>2019-03-05</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>-4.672</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.0803</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0833</td>\n",
       "      <td>0.725</td>\n",
       "      <td>123.976</td>\n",
       "      <td>189052</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               track_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) - Loud Luxur...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories - Dillon Francis Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time - Don Diablo Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7                  Call You Mine - Keanu Silva Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved - Future Humans Remix   \n",
       "\n",
       "                            track_artist  track_popularity  \\\n",
       "track_id                                                     \n",
       "6f807x0ima9a1j3VPbc7VN        Ed Sheeran                66   \n",
       "0r7CVbZTWZgbTCYdfa2P31          Maroon 5                67   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      Zara Larsson                70   \n",
       "75FpbthrwQmzHlBJLuGdC7  The Chainsmokers                60   \n",
       "1e8PAfcKUYoKkxPhrHqw4x     Lewis Capaldi                69   \n",
       "\n",
       "                                track_album_id  \\\n",
       "track_id                                         \n",
       "6f807x0ima9a1j3VPbc7VN  2oCs0DGTsRO98Gh5ZSl2Cx   \n",
       "0r7CVbZTWZgbTCYdfa2P31  63rPSO264uRjW1X5E6cWv6   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  1HoSmj2eLcsrR0vE9gThr4   \n",
       "75FpbthrwQmzHlBJLuGdC7  1nqYsOef1yKKuGOVchbsk6   \n",
       "1e8PAfcKUYoKkxPhrHqw4x  7m7vv9wlQ4i0LFuJiE2zsQ   \n",
       "\n",
       "                                                         track_album_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) [Loud Luxury...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories (Dillon Francis Remix)   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time (Don Diablo Remix)   \n",
       "75FpbthrwQmzHlBJLuGdC7                        Call You Mine - The Remixes   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved (Future Humans Remix)   \n",
       "\n",
       "                       track_album_release_date playlist_name  \\\n",
       "track_id                                                        \n",
       "6f807x0ima9a1j3VPbc7VN               2019-06-14     Pop Remix   \n",
       "0r7CVbZTWZgbTCYdfa2P31               2019-12-13     Pop Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l               2019-07-05     Pop Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7               2019-07-19     Pop Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x               2019-03-05     Pop Remix   \n",
       "\n",
       "                                   playlist_id playlist_genre  \\\n",
       "track_id                                                        \n",
       "6f807x0ima9a1j3VPbc7VN  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "0r7CVbZTWZgbTCYdfa2P31  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "75FpbthrwQmzHlBJLuGdC7  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "1e8PAfcKUYoKkxPhrHqw4x  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "\n",
       "                       playlist_subgenre  ...  key  loudness  mode  \\\n",
       "track_id                                  ...                        \n",
       "6f807x0ima9a1j3VPbc7VN         dance pop  ...    6    -2.634     1   \n",
       "0r7CVbZTWZgbTCYdfa2P31         dance pop  ...   11    -4.969     1   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l         dance pop  ...    1    -3.432     0   \n",
       "75FpbthrwQmzHlBJLuGdC7         dance pop  ...    7    -3.778     1   \n",
       "1e8PAfcKUYoKkxPhrHqw4x         dance pop  ...    1    -4.672     1   \n",
       "\n",
       "                        speechiness  acousticness  instrumentalness  liveness  \\\n",
       "track_id                                                                        \n",
       "6f807x0ima9a1j3VPbc7VN       0.0583        0.1020          0.000000    0.0653   \n",
       "0r7CVbZTWZgbTCYdfa2P31       0.0373        0.0724          0.004210    0.3570   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l       0.0742        0.0794          0.000023    0.1100   \n",
       "75FpbthrwQmzHlBJLuGdC7       0.1020        0.0287          0.000009    0.2040   \n",
       "1e8PAfcKUYoKkxPhrHqw4x       0.0359        0.0803          0.000000    0.0833   \n",
       "\n",
       "                        valence    tempo  duration_ms  \n",
       "track_id                                               \n",
       "6f807x0ima9a1j3VPbc7VN    0.518  122.036       194754  \n",
       "0r7CVbZTWZgbTCYdfa2P31    0.693   99.972       162600  \n",
       "1z1Hg7Vb0AhHDiEmnDE79l    0.613  124.008       176616  \n",
       "75FpbthrwQmzHlBJLuGdC7    0.277  121.956       169093  \n",
       "1e8PAfcKUYoKkxPhrHqw4x    0.725  123.976       189052  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "77249f7f",
   "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>track_name</th>\n",
       "      <th>track_artist</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_id</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>playlist_name</th>\n",
       "      <th>playlist_id</th>\n",
       "      <th>playlist_genre</th>\n",
       "      <th>playlist_subgenre</th>\n",
       "      <th>...</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>track_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6f807x0ima9a1j3VPbc7VN</th>\n",
       "      <td>I Don't Care (with Justin Bieber) - Loud Luxur...</td>\n",
       "      <td>Ed Sheeran</td>\n",
       "      <td>66</td>\n",
       "      <td>2oCs0DGTsRO98Gh5ZSl2Cx</td>\n",
       "      <td>I Don't Care (with Justin Bieber) [Loud Luxury...</td>\n",
       "      <td>2019-06-14</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>-2.634</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>0.102000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0653</td>\n",
       "      <td>0.5180</td>\n",
       "      <td>122.036</td>\n",
       "      <td>194754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0r7CVbZTWZgbTCYdfa2P31</th>\n",
       "      <td>Memories - Dillon Francis Remix</td>\n",
       "      <td>Maroon 5</td>\n",
       "      <td>67</td>\n",
       "      <td>63rPSO264uRjW1X5E6cWv6</td>\n",
       "      <td>Memories (Dillon Francis Remix)</td>\n",
       "      <td>2019-12-13</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>-4.969</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0373</td>\n",
       "      <td>0.072400</td>\n",
       "      <td>0.004210</td>\n",
       "      <td>0.3570</td>\n",
       "      <td>0.6930</td>\n",
       "      <td>99.972</td>\n",
       "      <td>162600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1z1Hg7Vb0AhHDiEmnDE79l</th>\n",
       "      <td>All the Time - Don Diablo Remix</td>\n",
       "      <td>Zara Larsson</td>\n",
       "      <td>70</td>\n",
       "      <td>1HoSmj2eLcsrR0vE9gThr4</td>\n",
       "      <td>All the Time (Don Diablo Remix)</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>-3.432</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0742</td>\n",
       "      <td>0.079400</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.6130</td>\n",
       "      <td>124.008</td>\n",
       "      <td>176616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75FpbthrwQmzHlBJLuGdC7</th>\n",
       "      <td>Call You Mine - Keanu Silva Remix</td>\n",
       "      <td>The Chainsmokers</td>\n",
       "      <td>60</td>\n",
       "      <td>1nqYsOef1yKKuGOVchbsk6</td>\n",
       "      <td>Call You Mine - The Remixes</td>\n",
       "      <td>2019-07-19</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>-3.778</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.028700</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>0.2770</td>\n",
       "      <td>121.956</td>\n",
       "      <td>169093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1e8PAfcKUYoKkxPhrHqw4x</th>\n",
       "      <td>Someone You Loved - Future Humans Remix</td>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>69</td>\n",
       "      <td>7m7vv9wlQ4i0LFuJiE2zsQ</td>\n",
       "      <td>Someone You Loved (Future Humans Remix)</td>\n",
       "      <td>2019-03-05</td>\n",
       "      <td>Pop Remix</td>\n",
       "      <td>37i9dQZF1DXcZDD7cfEKhW</td>\n",
       "      <td>pop</td>\n",
       "      <td>dance pop</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>-4.672</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.080300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0833</td>\n",
       "      <td>0.7250</td>\n",
       "      <td>123.976</td>\n",
       "      <td>189052</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>7bxnKAamR3snQ1VGLuVfC1</th>\n",
       "      <td>City Of Lights - Official Radio Edit</td>\n",
       "      <td>Lush &amp; Simon</td>\n",
       "      <td>42</td>\n",
       "      <td>2azRoBBWEEEYhqV6sb7JrT</td>\n",
       "      <td>City Of Lights (Vocal Mix)</td>\n",
       "      <td>2014-04-28</td>\n",
       "      <td>♥ EDM LOVE 2020</td>\n",
       "      <td>6jI1gFr6ANFtT8MmTvA2Ux</td>\n",
       "      <td>edm</td>\n",
       "      <td>progressive electro house</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-1.814</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0936</td>\n",
       "      <td>0.076600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0668</td>\n",
       "      <td>0.2100</td>\n",
       "      <td>128.170</td>\n",
       "      <td>204375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5Aevni09Em4575077nkWHz</th>\n",
       "      <td>Closer - Sultan &amp; Ned Shepard Remix</td>\n",
       "      <td>Tegan and Sara</td>\n",
       "      <td>20</td>\n",
       "      <td>6kD6KLxj7s8eCE3ABvAyf5</td>\n",
       "      <td>Closer Remixed</td>\n",
       "      <td>2013-03-08</td>\n",
       "      <td>♥ EDM LOVE 2020</td>\n",
       "      <td>6jI1gFr6ANFtT8MmTvA2Ux</td>\n",
       "      <td>edm</td>\n",
       "      <td>progressive electro house</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.462</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0420</td>\n",
       "      <td>0.001710</td>\n",
       "      <td>0.004270</td>\n",
       "      <td>0.3750</td>\n",
       "      <td>0.4000</td>\n",
       "      <td>128.041</td>\n",
       "      <td>353120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7ImMqPP3Q1yfUHvsdn7wEo</th>\n",
       "      <td>Sweet Surrender - Radio Edit</td>\n",
       "      <td>Starkillers</td>\n",
       "      <td>14</td>\n",
       "      <td>0ltWNSY9JgxoIZO4VzuCa6</td>\n",
       "      <td>Sweet Surrender (Radio Edit)</td>\n",
       "      <td>2014-04-21</td>\n",
       "      <td>♥ EDM LOVE 2020</td>\n",
       "      <td>6jI1gFr6ANFtT8MmTvA2Ux</td>\n",
       "      <td>edm</td>\n",
       "      <td>progressive electro house</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>-4.899</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0481</td>\n",
       "      <td>0.108000</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>0.4360</td>\n",
       "      <td>127.989</td>\n",
       "      <td>210112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2m69mhnfQ1Oq6lGtXuYhgX</th>\n",
       "      <td>Only For You - Maor Levi Remix</td>\n",
       "      <td>Mat Zo</td>\n",
       "      <td>15</td>\n",
       "      <td>1fGrOkHnHJcStl14zNx8Jy</td>\n",
       "      <td>Only For You (Remixes)</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>♥ EDM LOVE 2020</td>\n",
       "      <td>6jI1gFr6ANFtT8MmTvA2Ux</td>\n",
       "      <td>edm</td>\n",
       "      <td>progressive electro house</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-3.361</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1090</td>\n",
       "      <td>0.007920</td>\n",
       "      <td>0.127000</td>\n",
       "      <td>0.3430</td>\n",
       "      <td>0.3080</td>\n",
       "      <td>128.008</td>\n",
       "      <td>367432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29zWqhca3zt5NsckZqDf6c</th>\n",
       "      <td>Typhoon - Original Mix</td>\n",
       "      <td>Julian Calor</td>\n",
       "      <td>27</td>\n",
       "      <td>0X3mUOm6MhxR7PzxG95rAo</td>\n",
       "      <td>Typhoon/Storm</td>\n",
       "      <td>2014-03-03</td>\n",
       "      <td>♥ EDM LOVE 2020</td>\n",
       "      <td>6jI1gFr6ANFtT8MmTvA2Ux</td>\n",
       "      <td>edm</td>\n",
       "      <td>progressive electro house</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-4.571</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0385</td>\n",
       "      <td>0.000133</td>\n",
       "      <td>0.341000</td>\n",
       "      <td>0.7420</td>\n",
       "      <td>0.0894</td>\n",
       "      <td>127.984</td>\n",
       "      <td>337500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32828 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               track_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) - Loud Luxur...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories - Dillon Francis Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time - Don Diablo Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7                  Call You Mine - Keanu Silva Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved - Future Humans Remix   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               City Of Lights - Official Radio Edit   \n",
       "5Aevni09Em4575077nkWHz                Closer - Sultan & Ned Shepard Remix   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender - Radio Edit   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                     Only For You - Maor Levi Remix   \n",
       "29zWqhca3zt5NsckZqDf6c                             Typhoon - Original Mix   \n",
       "\n",
       "                            track_artist  track_popularity  \\\n",
       "track_id                                                     \n",
       "6f807x0ima9a1j3VPbc7VN        Ed Sheeran                66   \n",
       "0r7CVbZTWZgbTCYdfa2P31          Maroon 5                67   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      Zara Larsson                70   \n",
       "75FpbthrwQmzHlBJLuGdC7  The Chainsmokers                60   \n",
       "1e8PAfcKUYoKkxPhrHqw4x     Lewis Capaldi                69   \n",
       "...                                  ...               ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1      Lush & Simon                42   \n",
       "5Aevni09Em4575077nkWHz    Tegan and Sara                20   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo       Starkillers                14   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX            Mat Zo                15   \n",
       "29zWqhca3zt5NsckZqDf6c      Julian Calor                27   \n",
       "\n",
       "                                track_album_id  \\\n",
       "track_id                                         \n",
       "6f807x0ima9a1j3VPbc7VN  2oCs0DGTsRO98Gh5ZSl2Cx   \n",
       "0r7CVbZTWZgbTCYdfa2P31  63rPSO264uRjW1X5E6cWv6   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  1HoSmj2eLcsrR0vE9gThr4   \n",
       "75FpbthrwQmzHlBJLuGdC7  1nqYsOef1yKKuGOVchbsk6   \n",
       "1e8PAfcKUYoKkxPhrHqw4x  7m7vv9wlQ4i0LFuJiE2zsQ   \n",
       "...                                        ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1  2azRoBBWEEEYhqV6sb7JrT   \n",
       "5Aevni09Em4575077nkWHz  6kD6KLxj7s8eCE3ABvAyf5   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo  0ltWNSY9JgxoIZO4VzuCa6   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX  1fGrOkHnHJcStl14zNx8Jy   \n",
       "29zWqhca3zt5NsckZqDf6c  0X3mUOm6MhxR7PzxG95rAo   \n",
       "\n",
       "                                                         track_album_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) [Loud Luxury...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories (Dillon Francis Remix)   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time (Don Diablo Remix)   \n",
       "75FpbthrwQmzHlBJLuGdC7                        Call You Mine - The Remixes   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved (Future Humans Remix)   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1                         City Of Lights (Vocal Mix)   \n",
       "5Aevni09Em4575077nkWHz                                     Closer Remixed   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender (Radio Edit)   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                             Only For You (Remixes)   \n",
       "29zWqhca3zt5NsckZqDf6c                                      Typhoon/Storm   \n",
       "\n",
       "                       track_album_release_date    playlist_name  \\\n",
       "track_id                                                           \n",
       "6f807x0ima9a1j3VPbc7VN               2019-06-14        Pop Remix   \n",
       "0r7CVbZTWZgbTCYdfa2P31               2019-12-13        Pop Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l               2019-07-05        Pop Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7               2019-07-19        Pop Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x               2019-03-05        Pop Remix   \n",
       "...                                         ...              ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               2014-04-28  ♥ EDM LOVE 2020   \n",
       "5Aevni09Em4575077nkWHz               2013-03-08  ♥ EDM LOVE 2020   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo               2014-04-21  ♥ EDM LOVE 2020   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX               2014-01-01  ♥ EDM LOVE 2020   \n",
       "29zWqhca3zt5NsckZqDf6c               2014-03-03  ♥ EDM LOVE 2020   \n",
       "\n",
       "                                   playlist_id playlist_genre  \\\n",
       "track_id                                                        \n",
       "6f807x0ima9a1j3VPbc7VN  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "0r7CVbZTWZgbTCYdfa2P31  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "75FpbthrwQmzHlBJLuGdC7  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "1e8PAfcKUYoKkxPhrHqw4x  37i9dQZF1DXcZDD7cfEKhW            pop   \n",
       "...                                        ...            ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1  6jI1gFr6ANFtT8MmTvA2Ux            edm   \n",
       "5Aevni09Em4575077nkWHz  6jI1gFr6ANFtT8MmTvA2Ux            edm   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo  6jI1gFr6ANFtT8MmTvA2Ux            edm   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX  6jI1gFr6ANFtT8MmTvA2Ux            edm   \n",
       "29zWqhca3zt5NsckZqDf6c  6jI1gFr6ANFtT8MmTvA2Ux            edm   \n",
       "\n",
       "                                playlist_subgenre  ...  key  loudness  mode  \\\n",
       "track_id                                           ...                        \n",
       "6f807x0ima9a1j3VPbc7VN                  dance pop  ...    6    -2.634     1   \n",
       "0r7CVbZTWZgbTCYdfa2P31                  dance pop  ...   11    -4.969     1   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                  dance pop  ...    1    -3.432     0   \n",
       "75FpbthrwQmzHlBJLuGdC7                  dance pop  ...    7    -3.778     1   \n",
       "1e8PAfcKUYoKkxPhrHqw4x                  dance pop  ...    1    -4.672     1   \n",
       "...                                           ...  ...  ...       ...   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1  progressive electro house  ...    2    -1.814     1   \n",
       "5Aevni09Em4575077nkWHz  progressive electro house  ...    0    -4.462     1   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo  progressive electro house  ...    6    -4.899     0   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX  progressive electro house  ...    2    -3.361     1   \n",
       "29zWqhca3zt5NsckZqDf6c  progressive electro house  ...    5    -4.571     0   \n",
       "\n",
       "                        speechiness  acousticness  instrumentalness  liveness  \\\n",
       "track_id                                                                        \n",
       "6f807x0ima9a1j3VPbc7VN       0.0583      0.102000          0.000000    0.0653   \n",
       "0r7CVbZTWZgbTCYdfa2P31       0.0373      0.072400          0.004210    0.3570   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l       0.0742      0.079400          0.000023    0.1100   \n",
       "75FpbthrwQmzHlBJLuGdC7       0.1020      0.028700          0.000009    0.2040   \n",
       "1e8PAfcKUYoKkxPhrHqw4x       0.0359      0.080300          0.000000    0.0833   \n",
       "...                             ...           ...               ...       ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1       0.0936      0.076600          0.000000    0.0668   \n",
       "5Aevni09Em4575077nkWHz       0.0420      0.001710          0.004270    0.3750   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo       0.0481      0.108000          0.000001    0.1500   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX       0.1090      0.007920          0.127000    0.3430   \n",
       "29zWqhca3zt5NsckZqDf6c       0.0385      0.000133          0.341000    0.7420   \n",
       "\n",
       "                        valence    tempo  duration_ms  \n",
       "track_id                                               \n",
       "6f807x0ima9a1j3VPbc7VN   0.5180  122.036       194754  \n",
       "0r7CVbZTWZgbTCYdfa2P31   0.6930   99.972       162600  \n",
       "1z1Hg7Vb0AhHDiEmnDE79l   0.6130  124.008       176616  \n",
       "75FpbthrwQmzHlBJLuGdC7   0.2770  121.956       169093  \n",
       "1e8PAfcKUYoKkxPhrHqw4x   0.7250  123.976       189052  \n",
       "...                         ...      ...          ...  \n",
       "7bxnKAamR3snQ1VGLuVfC1   0.2100  128.170       204375  \n",
       "5Aevni09Em4575077nkWHz   0.4000  128.041       353120  \n",
       "7ImMqPP3Q1yfUHvsdn7wEo   0.4360  127.989       210112  \n",
       "2m69mhnfQ1Oq6lGtXuYhgX   0.3080  128.008       367432  \n",
       "29zWqhca3zt5NsckZqDf6c   0.0894  127.984       337500  \n",
       "\n",
       "[32828 rows x 22 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset = dataset.dropna()\n",
    "dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "1cbb5891",
   "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>track_name</th>\n",
       "      <th>track_artist</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>playlist_genre</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>track_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6f807x0ima9a1j3VPbc7VN</th>\n",
       "      <td>I Don't Care (with Justin Bieber) - Loud Luxur...</td>\n",
       "      <td>Ed Sheeran</td>\n",
       "      <td>66</td>\n",
       "      <td>I Don't Care (with Justin Bieber) [Loud Luxury...</td>\n",
       "      <td>2019-06-14</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.748</td>\n",
       "      <td>0.916</td>\n",
       "      <td>6</td>\n",
       "      <td>-2.634</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>0.102000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0653</td>\n",
       "      <td>0.5180</td>\n",
       "      <td>122.036</td>\n",
       "      <td>194754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0r7CVbZTWZgbTCYdfa2P31</th>\n",
       "      <td>Memories - Dillon Francis Remix</td>\n",
       "      <td>Maroon 5</td>\n",
       "      <td>67</td>\n",
       "      <td>Memories (Dillon Francis Remix)</td>\n",
       "      <td>2019-12-13</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.815</td>\n",
       "      <td>11</td>\n",
       "      <td>-4.969</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0373</td>\n",
       "      <td>0.072400</td>\n",
       "      <td>0.004210</td>\n",
       "      <td>0.3570</td>\n",
       "      <td>0.6930</td>\n",
       "      <td>99.972</td>\n",
       "      <td>162600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1z1Hg7Vb0AhHDiEmnDE79l</th>\n",
       "      <td>All the Time - Don Diablo Remix</td>\n",
       "      <td>Zara Larsson</td>\n",
       "      <td>70</td>\n",
       "      <td>All the Time (Don Diablo Remix)</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.675</td>\n",
       "      <td>0.931</td>\n",
       "      <td>1</td>\n",
       "      <td>-3.432</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0742</td>\n",
       "      <td>0.079400</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.6130</td>\n",
       "      <td>124.008</td>\n",
       "      <td>176616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75FpbthrwQmzHlBJLuGdC7</th>\n",
       "      <td>Call You Mine - Keanu Silva Remix</td>\n",
       "      <td>The Chainsmokers</td>\n",
       "      <td>60</td>\n",
       "      <td>Call You Mine - The Remixes</td>\n",
       "      <td>2019-07-19</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.718</td>\n",
       "      <td>0.930</td>\n",
       "      <td>7</td>\n",
       "      <td>-3.778</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.028700</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>0.2770</td>\n",
       "      <td>121.956</td>\n",
       "      <td>169093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1e8PAfcKUYoKkxPhrHqw4x</th>\n",
       "      <td>Someone You Loved - Future Humans Remix</td>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>69</td>\n",
       "      <td>Someone You Loved (Future Humans Remix)</td>\n",
       "      <td>2019-03-05</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.833</td>\n",
       "      <td>1</td>\n",
       "      <td>-4.672</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.080300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0833</td>\n",
       "      <td>0.7250</td>\n",
       "      <td>123.976</td>\n",
       "      <td>189052</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7bxnKAamR3snQ1VGLuVfC1</th>\n",
       "      <td>City Of Lights - Official Radio Edit</td>\n",
       "      <td>Lush &amp; Simon</td>\n",
       "      <td>42</td>\n",
       "      <td>City Of Lights (Vocal Mix)</td>\n",
       "      <td>2014-04-28</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.428</td>\n",
       "      <td>0.922</td>\n",
       "      <td>2</td>\n",
       "      <td>-1.814</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0936</td>\n",
       "      <td>0.076600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0668</td>\n",
       "      <td>0.2100</td>\n",
       "      <td>128.170</td>\n",
       "      <td>204375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5Aevni09Em4575077nkWHz</th>\n",
       "      <td>Closer - Sultan &amp; Ned Shepard Remix</td>\n",
       "      <td>Tegan and Sara</td>\n",
       "      <td>20</td>\n",
       "      <td>Closer Remixed</td>\n",
       "      <td>2013-03-08</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.522</td>\n",
       "      <td>0.786</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.462</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0420</td>\n",
       "      <td>0.001710</td>\n",
       "      <td>0.004270</td>\n",
       "      <td>0.3750</td>\n",
       "      <td>0.4000</td>\n",
       "      <td>128.041</td>\n",
       "      <td>353120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7ImMqPP3Q1yfUHvsdn7wEo</th>\n",
       "      <td>Sweet Surrender - Radio Edit</td>\n",
       "      <td>Starkillers</td>\n",
       "      <td>14</td>\n",
       "      <td>Sweet Surrender (Radio Edit)</td>\n",
       "      <td>2014-04-21</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.529</td>\n",
       "      <td>0.821</td>\n",
       "      <td>6</td>\n",
       "      <td>-4.899</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0481</td>\n",
       "      <td>0.108000</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>0.4360</td>\n",
       "      <td>127.989</td>\n",
       "      <td>210112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2m69mhnfQ1Oq6lGtXuYhgX</th>\n",
       "      <td>Only For You - Maor Levi Remix</td>\n",
       "      <td>Mat Zo</td>\n",
       "      <td>15</td>\n",
       "      <td>Only For You (Remixes)</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.626</td>\n",
       "      <td>0.888</td>\n",
       "      <td>2</td>\n",
       "      <td>-3.361</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1090</td>\n",
       "      <td>0.007920</td>\n",
       "      <td>0.127000</td>\n",
       "      <td>0.3430</td>\n",
       "      <td>0.3080</td>\n",
       "      <td>128.008</td>\n",
       "      <td>367432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29zWqhca3zt5NsckZqDf6c</th>\n",
       "      <td>Typhoon - Original Mix</td>\n",
       "      <td>Julian Calor</td>\n",
       "      <td>27</td>\n",
       "      <td>Typhoon/Storm</td>\n",
       "      <td>2014-03-03</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.603</td>\n",
       "      <td>0.884</td>\n",
       "      <td>5</td>\n",
       "      <td>-4.571</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0385</td>\n",
       "      <td>0.000133</td>\n",
       "      <td>0.341000</td>\n",
       "      <td>0.7420</td>\n",
       "      <td>0.0894</td>\n",
       "      <td>127.984</td>\n",
       "      <td>337500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32828 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               track_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) - Loud Luxur...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories - Dillon Francis Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time - Don Diablo Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7                  Call You Mine - Keanu Silva Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved - Future Humans Remix   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               City Of Lights - Official Radio Edit   \n",
       "5Aevni09Em4575077nkWHz                Closer - Sultan & Ned Shepard Remix   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender - Radio Edit   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                     Only For You - Maor Levi Remix   \n",
       "29zWqhca3zt5NsckZqDf6c                             Typhoon - Original Mix   \n",
       "\n",
       "                            track_artist  track_popularity  \\\n",
       "track_id                                                     \n",
       "6f807x0ima9a1j3VPbc7VN        Ed Sheeran                66   \n",
       "0r7CVbZTWZgbTCYdfa2P31          Maroon 5                67   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      Zara Larsson                70   \n",
       "75FpbthrwQmzHlBJLuGdC7  The Chainsmokers                60   \n",
       "1e8PAfcKUYoKkxPhrHqw4x     Lewis Capaldi                69   \n",
       "...                                  ...               ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1      Lush & Simon                42   \n",
       "5Aevni09Em4575077nkWHz    Tegan and Sara                20   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo       Starkillers                14   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX            Mat Zo                15   \n",
       "29zWqhca3zt5NsckZqDf6c      Julian Calor                27   \n",
       "\n",
       "                                                         track_album_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) [Loud Luxury...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories (Dillon Francis Remix)   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time (Don Diablo Remix)   \n",
       "75FpbthrwQmzHlBJLuGdC7                        Call You Mine - The Remixes   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved (Future Humans Remix)   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1                         City Of Lights (Vocal Mix)   \n",
       "5Aevni09Em4575077nkWHz                                     Closer Remixed   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender (Radio Edit)   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                             Only For You (Remixes)   \n",
       "29zWqhca3zt5NsckZqDf6c                                      Typhoon/Storm   \n",
       "\n",
       "                       track_album_release_date playlist_genre  danceability  \\\n",
       "track_id                                                                       \n",
       "6f807x0ima9a1j3VPbc7VN               2019-06-14            pop         0.748   \n",
       "0r7CVbZTWZgbTCYdfa2P31               2019-12-13            pop         0.726   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l               2019-07-05            pop         0.675   \n",
       "75FpbthrwQmzHlBJLuGdC7               2019-07-19            pop         0.718   \n",
       "1e8PAfcKUYoKkxPhrHqw4x               2019-03-05            pop         0.650   \n",
       "...                                         ...            ...           ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               2014-04-28            edm         0.428   \n",
       "5Aevni09Em4575077nkWHz               2013-03-08            edm         0.522   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo               2014-04-21            edm         0.529   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX               2014-01-01            edm         0.626   \n",
       "29zWqhca3zt5NsckZqDf6c               2014-03-03            edm         0.603   \n",
       "\n",
       "                        energy  key  loudness  mode  speechiness  \\\n",
       "track_id                                                           \n",
       "6f807x0ima9a1j3VPbc7VN   0.916    6    -2.634     1       0.0583   \n",
       "0r7CVbZTWZgbTCYdfa2P31   0.815   11    -4.969     1       0.0373   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l   0.931    1    -3.432     0       0.0742   \n",
       "75FpbthrwQmzHlBJLuGdC7   0.930    7    -3.778     1       0.1020   \n",
       "1e8PAfcKUYoKkxPhrHqw4x   0.833    1    -4.672     1       0.0359   \n",
       "...                        ...  ...       ...   ...          ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1   0.922    2    -1.814     1       0.0936   \n",
       "5Aevni09Em4575077nkWHz   0.786    0    -4.462     1       0.0420   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo   0.821    6    -4.899     0       0.0481   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX   0.888    2    -3.361     1       0.1090   \n",
       "29zWqhca3zt5NsckZqDf6c   0.884    5    -4.571     0       0.0385   \n",
       "\n",
       "                        acousticness  instrumentalness  liveness  valence  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN      0.102000          0.000000    0.0653   0.5180   \n",
       "0r7CVbZTWZgbTCYdfa2P31      0.072400          0.004210    0.3570   0.6930   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      0.079400          0.000023    0.1100   0.6130   \n",
       "75FpbthrwQmzHlBJLuGdC7      0.028700          0.000009    0.2040   0.2770   \n",
       "1e8PAfcKUYoKkxPhrHqw4x      0.080300          0.000000    0.0833   0.7250   \n",
       "...                              ...               ...       ...      ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1      0.076600          0.000000    0.0668   0.2100   \n",
       "5Aevni09Em4575077nkWHz      0.001710          0.004270    0.3750   0.4000   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo      0.108000          0.000001    0.1500   0.4360   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX      0.007920          0.127000    0.3430   0.3080   \n",
       "29zWqhca3zt5NsckZqDf6c      0.000133          0.341000    0.7420   0.0894   \n",
       "\n",
       "                          tempo  duration_ms  \n",
       "track_id                                      \n",
       "6f807x0ima9a1j3VPbc7VN  122.036       194754  \n",
       "0r7CVbZTWZgbTCYdfa2P31   99.972       162600  \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  124.008       176616  \n",
       "75FpbthrwQmzHlBJLuGdC7  121.956       169093  \n",
       "1e8PAfcKUYoKkxPhrHqw4x  123.976       189052  \n",
       "...                         ...          ...  \n",
       "7bxnKAamR3snQ1VGLuVfC1  128.170       204375  \n",
       "5Aevni09Em4575077nkWHz  128.041       353120  \n",
       "7ImMqPP3Q1yfUHvsdn7wEo  127.989       210112  \n",
       "2m69mhnfQ1Oq6lGtXuYhgX  128.008       367432  \n",
       "29zWqhca3zt5NsckZqDf6c  127.984       337500  \n",
       "\n",
       "[32828 rows x 18 columns]"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset = dataset.drop(['playlist_id','playlist_name','track_album_id','playlist_subgenre'], axis=1)\n",
    "dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "e250b980",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "track_id\n",
       "6f807x0ima9a1j3VPbc7VN    False\n",
       "0r7CVbZTWZgbTCYdfa2P31    False\n",
       "1z1Hg7Vb0AhHDiEmnDE79l    False\n",
       "75FpbthrwQmzHlBJLuGdC7    False\n",
       "1e8PAfcKUYoKkxPhrHqw4x    False\n",
       "                          ...  \n",
       "7bxnKAamR3snQ1VGLuVfC1    False\n",
       "5Aevni09Em4575077nkWHz    False\n",
       "7ImMqPP3Q1yfUHvsdn7wEo    False\n",
       "2m69mhnfQ1Oq6lGtXuYhgX    False\n",
       "29zWqhca3zt5NsckZqDf6c    False\n",
       "Length: 32828, dtype: bool"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "duplicates_list = dataset.duplicated(keep='first')\n",
    "duplicates_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "2b451600",
   "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>track_name</th>\n",
       "      <th>track_artist</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>playlist_genre</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>track_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6f807x0ima9a1j3VPbc7VN</th>\n",
       "      <td>I Don't Care (with Justin Bieber) - Loud Luxur...</td>\n",
       "      <td>Ed Sheeran</td>\n",
       "      <td>66</td>\n",
       "      <td>I Don't Care (with Justin Bieber) [Loud Luxury...</td>\n",
       "      <td>2019-06-14</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.748</td>\n",
       "      <td>0.916</td>\n",
       "      <td>6</td>\n",
       "      <td>-2.634</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>0.102000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0653</td>\n",
       "      <td>0.5180</td>\n",
       "      <td>122.036</td>\n",
       "      <td>194754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0r7CVbZTWZgbTCYdfa2P31</th>\n",
       "      <td>Memories - Dillon Francis Remix</td>\n",
       "      <td>Maroon 5</td>\n",
       "      <td>67</td>\n",
       "      <td>Memories (Dillon Francis Remix)</td>\n",
       "      <td>2019-12-13</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.815</td>\n",
       "      <td>11</td>\n",
       "      <td>-4.969</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0373</td>\n",
       "      <td>0.072400</td>\n",
       "      <td>0.004210</td>\n",
       "      <td>0.3570</td>\n",
       "      <td>0.6930</td>\n",
       "      <td>99.972</td>\n",
       "      <td>162600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1z1Hg7Vb0AhHDiEmnDE79l</th>\n",
       "      <td>All the Time - Don Diablo Remix</td>\n",
       "      <td>Zara Larsson</td>\n",
       "      <td>70</td>\n",
       "      <td>All the Time (Don Diablo Remix)</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.675</td>\n",
       "      <td>0.931</td>\n",
       "      <td>1</td>\n",
       "      <td>-3.432</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0742</td>\n",
       "      <td>0.079400</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.6130</td>\n",
       "      <td>124.008</td>\n",
       "      <td>176616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75FpbthrwQmzHlBJLuGdC7</th>\n",
       "      <td>Call You Mine - Keanu Silva Remix</td>\n",
       "      <td>The Chainsmokers</td>\n",
       "      <td>60</td>\n",
       "      <td>Call You Mine - The Remixes</td>\n",
       "      <td>2019-07-19</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.718</td>\n",
       "      <td>0.930</td>\n",
       "      <td>7</td>\n",
       "      <td>-3.778</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.028700</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>0.2770</td>\n",
       "      <td>121.956</td>\n",
       "      <td>169093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1e8PAfcKUYoKkxPhrHqw4x</th>\n",
       "      <td>Someone You Loved - Future Humans Remix</td>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>69</td>\n",
       "      <td>Someone You Loved (Future Humans Remix)</td>\n",
       "      <td>2019-03-05</td>\n",
       "      <td>pop</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.833</td>\n",
       "      <td>1</td>\n",
       "      <td>-4.672</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.080300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0833</td>\n",
       "      <td>0.7250</td>\n",
       "      <td>123.976</td>\n",
       "      <td>189052</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7bxnKAamR3snQ1VGLuVfC1</th>\n",
       "      <td>City Of Lights - Official Radio Edit</td>\n",
       "      <td>Lush &amp; Simon</td>\n",
       "      <td>42</td>\n",
       "      <td>City Of Lights (Vocal Mix)</td>\n",
       "      <td>2014-04-28</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.428</td>\n",
       "      <td>0.922</td>\n",
       "      <td>2</td>\n",
       "      <td>-1.814</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0936</td>\n",
       "      <td>0.076600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0668</td>\n",
       "      <td>0.2100</td>\n",
       "      <td>128.170</td>\n",
       "      <td>204375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5Aevni09Em4575077nkWHz</th>\n",
       "      <td>Closer - Sultan &amp; Ned Shepard Remix</td>\n",
       "      <td>Tegan and Sara</td>\n",
       "      <td>20</td>\n",
       "      <td>Closer Remixed</td>\n",
       "      <td>2013-03-08</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.522</td>\n",
       "      <td>0.786</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.462</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0420</td>\n",
       "      <td>0.001710</td>\n",
       "      <td>0.004270</td>\n",
       "      <td>0.3750</td>\n",
       "      <td>0.4000</td>\n",
       "      <td>128.041</td>\n",
       "      <td>353120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7ImMqPP3Q1yfUHvsdn7wEo</th>\n",
       "      <td>Sweet Surrender - Radio Edit</td>\n",
       "      <td>Starkillers</td>\n",
       "      <td>14</td>\n",
       "      <td>Sweet Surrender (Radio Edit)</td>\n",
       "      <td>2014-04-21</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.529</td>\n",
       "      <td>0.821</td>\n",
       "      <td>6</td>\n",
       "      <td>-4.899</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0481</td>\n",
       "      <td>0.108000</td>\n",
       "      <td>0.000001</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>0.4360</td>\n",
       "      <td>127.989</td>\n",
       "      <td>210112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2m69mhnfQ1Oq6lGtXuYhgX</th>\n",
       "      <td>Only For You - Maor Levi Remix</td>\n",
       "      <td>Mat Zo</td>\n",
       "      <td>15</td>\n",
       "      <td>Only For You (Remixes)</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.626</td>\n",
       "      <td>0.888</td>\n",
       "      <td>2</td>\n",
       "      <td>-3.361</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1090</td>\n",
       "      <td>0.007920</td>\n",
       "      <td>0.127000</td>\n",
       "      <td>0.3430</td>\n",
       "      <td>0.3080</td>\n",
       "      <td>128.008</td>\n",
       "      <td>367432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29zWqhca3zt5NsckZqDf6c</th>\n",
       "      <td>Typhoon - Original Mix</td>\n",
       "      <td>Julian Calor</td>\n",
       "      <td>27</td>\n",
       "      <td>Typhoon/Storm</td>\n",
       "      <td>2014-03-03</td>\n",
       "      <td>edm</td>\n",
       "      <td>0.603</td>\n",
       "      <td>0.884</td>\n",
       "      <td>5</td>\n",
       "      <td>-4.571</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0385</td>\n",
       "      <td>0.000133</td>\n",
       "      <td>0.341000</td>\n",
       "      <td>0.7420</td>\n",
       "      <td>0.0894</td>\n",
       "      <td>127.984</td>\n",
       "      <td>337500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30376 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               track_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) - Loud Luxur...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories - Dillon Francis Remix   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time - Don Diablo Remix   \n",
       "75FpbthrwQmzHlBJLuGdC7                  Call You Mine - Keanu Silva Remix   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved - Future Humans Remix   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               City Of Lights - Official Radio Edit   \n",
       "5Aevni09Em4575077nkWHz                Closer - Sultan & Ned Shepard Remix   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender - Radio Edit   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                     Only For You - Maor Levi Remix   \n",
       "29zWqhca3zt5NsckZqDf6c                             Typhoon - Original Mix   \n",
       "\n",
       "                            track_artist  track_popularity  \\\n",
       "track_id                                                     \n",
       "6f807x0ima9a1j3VPbc7VN        Ed Sheeran                66   \n",
       "0r7CVbZTWZgbTCYdfa2P31          Maroon 5                67   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      Zara Larsson                70   \n",
       "75FpbthrwQmzHlBJLuGdC7  The Chainsmokers                60   \n",
       "1e8PAfcKUYoKkxPhrHqw4x     Lewis Capaldi                69   \n",
       "...                                  ...               ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1      Lush & Simon                42   \n",
       "5Aevni09Em4575077nkWHz    Tegan and Sara                20   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo       Starkillers                14   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX            Mat Zo                15   \n",
       "29zWqhca3zt5NsckZqDf6c      Julian Calor                27   \n",
       "\n",
       "                                                         track_album_name  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN  I Don't Care (with Justin Bieber) [Loud Luxury...   \n",
       "0r7CVbZTWZgbTCYdfa2P31                    Memories (Dillon Francis Remix)   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l                    All the Time (Don Diablo Remix)   \n",
       "75FpbthrwQmzHlBJLuGdC7                        Call You Mine - The Remixes   \n",
       "1e8PAfcKUYoKkxPhrHqw4x            Someone You Loved (Future Humans Remix)   \n",
       "...                                                                   ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1                         City Of Lights (Vocal Mix)   \n",
       "5Aevni09Em4575077nkWHz                                     Closer Remixed   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo                       Sweet Surrender (Radio Edit)   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX                             Only For You (Remixes)   \n",
       "29zWqhca3zt5NsckZqDf6c                                      Typhoon/Storm   \n",
       "\n",
       "                       track_album_release_date playlist_genre  danceability  \\\n",
       "track_id                                                                       \n",
       "6f807x0ima9a1j3VPbc7VN               2019-06-14            pop         0.748   \n",
       "0r7CVbZTWZgbTCYdfa2P31               2019-12-13            pop         0.726   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l               2019-07-05            pop         0.675   \n",
       "75FpbthrwQmzHlBJLuGdC7               2019-07-19            pop         0.718   \n",
       "1e8PAfcKUYoKkxPhrHqw4x               2019-03-05            pop         0.650   \n",
       "...                                         ...            ...           ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1               2014-04-28            edm         0.428   \n",
       "5Aevni09Em4575077nkWHz               2013-03-08            edm         0.522   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo               2014-04-21            edm         0.529   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX               2014-01-01            edm         0.626   \n",
       "29zWqhca3zt5NsckZqDf6c               2014-03-03            edm         0.603   \n",
       "\n",
       "                        energy  key  loudness  mode  speechiness  \\\n",
       "track_id                                                           \n",
       "6f807x0ima9a1j3VPbc7VN   0.916    6    -2.634     1       0.0583   \n",
       "0r7CVbZTWZgbTCYdfa2P31   0.815   11    -4.969     1       0.0373   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l   0.931    1    -3.432     0       0.0742   \n",
       "75FpbthrwQmzHlBJLuGdC7   0.930    7    -3.778     1       0.1020   \n",
       "1e8PAfcKUYoKkxPhrHqw4x   0.833    1    -4.672     1       0.0359   \n",
       "...                        ...  ...       ...   ...          ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1   0.922    2    -1.814     1       0.0936   \n",
       "5Aevni09Em4575077nkWHz   0.786    0    -4.462     1       0.0420   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo   0.821    6    -4.899     0       0.0481   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX   0.888    2    -3.361     1       0.1090   \n",
       "29zWqhca3zt5NsckZqDf6c   0.884    5    -4.571     0       0.0385   \n",
       "\n",
       "                        acousticness  instrumentalness  liveness  valence  \\\n",
       "track_id                                                                    \n",
       "6f807x0ima9a1j3VPbc7VN      0.102000          0.000000    0.0653   0.5180   \n",
       "0r7CVbZTWZgbTCYdfa2P31      0.072400          0.004210    0.3570   0.6930   \n",
       "1z1Hg7Vb0AhHDiEmnDE79l      0.079400          0.000023    0.1100   0.6130   \n",
       "75FpbthrwQmzHlBJLuGdC7      0.028700          0.000009    0.2040   0.2770   \n",
       "1e8PAfcKUYoKkxPhrHqw4x      0.080300          0.000000    0.0833   0.7250   \n",
       "...                              ...               ...       ...      ...   \n",
       "7bxnKAamR3snQ1VGLuVfC1      0.076600          0.000000    0.0668   0.2100   \n",
       "5Aevni09Em4575077nkWHz      0.001710          0.004270    0.3750   0.4000   \n",
       "7ImMqPP3Q1yfUHvsdn7wEo      0.108000          0.000001    0.1500   0.4360   \n",
       "2m69mhnfQ1Oq6lGtXuYhgX      0.007920          0.127000    0.3430   0.3080   \n",
       "29zWqhca3zt5NsckZqDf6c      0.000133          0.341000    0.7420   0.0894   \n",
       "\n",
       "                          tempo  duration_ms  \n",
       "track_id                                      \n",
       "6f807x0ima9a1j3VPbc7VN  122.036       194754  \n",
       "0r7CVbZTWZgbTCYdfa2P31   99.972       162600  \n",
       "1z1Hg7Vb0AhHDiEmnDE79l  124.008       176616  \n",
       "75FpbthrwQmzHlBJLuGdC7  121.956       169093  \n",
       "1e8PAfcKUYoKkxPhrHqw4x  123.976       189052  \n",
       "...                         ...          ...  \n",
       "7bxnKAamR3snQ1VGLuVfC1  128.170       204375  \n",
       "5Aevni09Em4575077nkWHz  128.041       353120  \n",
       "7ImMqPP3Q1yfUHvsdn7wEo  127.989       210112  \n",
       "2m69mhnfQ1Oq6lGtXuYhgX  128.008       367432  \n",
       "29zWqhca3zt5NsckZqDf6c  127.984       337500  \n",
       "\n",
       "[30376 rows x 18 columns]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasetwd = dataset[~duplicates_list] #dataset without duplicates\n",
    "datasetwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "1e85db10",
   "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>track_name</th>\n",
       "      <th>track_artist</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>playlist_genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>edm</th>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "      <td>5536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>latin</th>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "      <td>4638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pop</th>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "      <td>5130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>r&amp;b</th>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "      <td>5138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rap</th>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "      <td>5483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rock</th>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "      <td>4451</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                track_name  track_artist  track_popularity  track_album_name  \\\n",
       "playlist_genre                                                                 \n",
       "edm                   5536          5536              5536              5536   \n",
       "latin                 4638          4638              4638              4638   \n",
       "pop                   5130          5130              5130              5130   \n",
       "r&b                   5138          5138              5138              5138   \n",
       "rap                   5483          5483              5483              5483   \n",
       "rock                  4451          4451              4451              4451   \n",
       "\n",
       "                track_album_release_date  danceability  energy   key  \\\n",
       "playlist_genre                                                         \n",
       "edm                                 5536          5536    5536  5536   \n",
       "latin                               4638          4638    4638  4638   \n",
       "pop                                 5130          5130    5130  5130   \n",
       "r&b                                 5138          5138    5138  5138   \n",
       "rap                                 5483          5483    5483  5483   \n",
       "rock                                4451          4451    4451  4451   \n",
       "\n",
       "                loudness  mode  speechiness  acousticness  instrumentalness  \\\n",
       "playlist_genre                                                                \n",
       "edm                 5536  5536         5536          5536              5536   \n",
       "latin               4638  4638         4638          4638              4638   \n",
       "pop                 5130  5130         5130          5130              5130   \n",
       "r&b                 5138  5138         5138          5138              5138   \n",
       "rap                 5483  5483         5483          5483              5483   \n",
       "rock                4451  4451         4451          4451              4451   \n",
       "\n",
       "                liveness  valence  tempo  duration_ms  \n",
       "playlist_genre                                         \n",
       "edm                 5536     5536   5536         5536  \n",
       "latin               4638     4638   4638         4638  \n",
       "pop                 5130     5130   5130         5130  \n",
       "r&b                 5138     5138   5138         5138  \n",
       "rap                 5483     5483   5483         5483  \n",
       "rock                4451     4451   4451         4451  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasetwd.groupby('playlist_genre').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "833d93c9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "playlist_genre\n",
       "edm      5536\n",
       "latin    4638\n",
       "pop      5130\n",
       "r&b      5138\n",
       "rap      5483\n",
       "rock     4451\n",
       "dtype: int64"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasetwd.groupby('playlist_genre').size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "f4944432",
   "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>track_name</th>\n",
       "      <th>track_popularity</th>\n",
       "      <th>track_album_name</th>\n",
       "      <th>track_album_release_date</th>\n",
       "      <th>playlist_genre</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>track_artist</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>!!!</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>!deladap</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\"Dear Evan Hansen\" August 2018 Broadway Cast</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#TocoParaVos</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>$ANFI</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>真之介</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>空音</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>竹内アンナ</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>落日飛車 Sunset Rollercoaster</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>香取慎吾</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10692 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              track_name  track_popularity  \\\n",
       "track_artist                                                                 \n",
       "!!!                                                    2                 2   \n",
       "!deladap                                               5                 5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast           1                 1   \n",
       "#TocoParaVos                                           1                 1   \n",
       "$ANFI                                                  3                 3   \n",
       "...                                                  ...               ...   \n",
       "真之介                                                    1                 1   \n",
       "空音                                                     1                 1   \n",
       "竹内アンナ                                                  1                 1   \n",
       "落日飛車 Sunset Rollercoaster                              1                 1   \n",
       "香取慎吾                                                   1                 1   \n",
       "\n",
       "                                              track_album_name  \\\n",
       "track_artist                                                     \n",
       "!!!                                                          2   \n",
       "!deladap                                                     5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast                 1   \n",
       "#TocoParaVos                                                 1   \n",
       "$ANFI                                                        3   \n",
       "...                                                        ...   \n",
       "真之介                                                          1   \n",
       "空音                                                           1   \n",
       "竹内アンナ                                                        1   \n",
       "落日飛車 Sunset Rollercoaster                                    1   \n",
       "香取慎吾                                                         1   \n",
       "\n",
       "                                              track_album_release_date  \\\n",
       "track_artist                                                             \n",
       "!!!                                                                  2   \n",
       "!deladap                                                             5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast                         1   \n",
       "#TocoParaVos                                                         1   \n",
       "$ANFI                                                                3   \n",
       "...                                                                ...   \n",
       "真之介                                                                  1   \n",
       "空音                                                                   1   \n",
       "竹内アンナ                                                                1   \n",
       "落日飛車 Sunset Rollercoaster                                            1   \n",
       "香取慎吾                                                                 1   \n",
       "\n",
       "                                              playlist_genre  danceability  \\\n",
       "track_artist                                                                 \n",
       "!!!                                                        2             2   \n",
       "!deladap                                                   5             5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast               1             1   \n",
       "#TocoParaVos                                               1             1   \n",
       "$ANFI                                                      3             3   \n",
       "...                                                      ...           ...   \n",
       "真之介                                                        1             1   \n",
       "空音                                                         1             1   \n",
       "竹内アンナ                                                      1             1   \n",
       "落日飛車 Sunset Rollercoaster                                  1             1   \n",
       "香取慎吾                                                       1             1   \n",
       "\n",
       "                                              energy  key  loudness  mode  \\\n",
       "track_artist                                                                \n",
       "!!!                                                2    2         2     2   \n",
       "!deladap                                           5    5         5     5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast       1    1         1     1   \n",
       "#TocoParaVos                                       1    1         1     1   \n",
       "$ANFI                                              3    3         3     3   \n",
       "...                                              ...  ...       ...   ...   \n",
       "真之介                                                1    1         1     1   \n",
       "空音                                                 1    1         1     1   \n",
       "竹内アンナ                                              1    1         1     1   \n",
       "落日飛車 Sunset Rollercoaster                          1    1         1     1   \n",
       "香取慎吾                                               1    1         1     1   \n",
       "\n",
       "                                              speechiness  acousticness  \\\n",
       "track_artist                                                              \n",
       "!!!                                                     2             2   \n",
       "!deladap                                                5             5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast            1             1   \n",
       "#TocoParaVos                                            1             1   \n",
       "$ANFI                                                   3             3   \n",
       "...                                                   ...           ...   \n",
       "真之介                                                     1             1   \n",
       "空音                                                      1             1   \n",
       "竹内アンナ                                                   1             1   \n",
       "落日飛車 Sunset Rollercoaster                               1             1   \n",
       "香取慎吾                                                    1             1   \n",
       "\n",
       "                                              instrumentalness  liveness  \\\n",
       "track_artist                                                               \n",
       "!!!                                                          2         2   \n",
       "!deladap                                                     5         5   \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast                 1         1   \n",
       "#TocoParaVos                                                 1         1   \n",
       "$ANFI                                                        3         3   \n",
       "...                                                        ...       ...   \n",
       "真之介                                                          1         1   \n",
       "空音                                                           1         1   \n",
       "竹内アンナ                                                        1         1   \n",
       "落日飛車 Sunset Rollercoaster                                    1         1   \n",
       "香取慎吾                                                         1         1   \n",
       "\n",
       "                                              valence  tempo  duration_ms  \n",
       "track_artist                                                               \n",
       "!!!                                                 2      2            2  \n",
       "!deladap                                            5      5            5  \n",
       "\"Dear Evan Hansen\" August 2018 Broadway Cast        1      1            1  \n",
       "#TocoParaVos                                        1      1            1  \n",
       "$ANFI                                               3      3            3  \n",
       "...                                               ...    ...          ...  \n",
       "真之介                                                 1      1            1  \n",
       "空音                                                  1      1            1  \n",
       "竹内アンナ                                               1      1            1  \n",
       "落日飛車 Sunset Rollercoaster                           1      1            1  \n",
       "香取慎吾                                                1      1            1  \n",
       "\n",
       "[10692 rows x 17 columns]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasetwd.groupby('track_artist').count()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}