spotify-data-extract.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Extracting Spotify Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "client_id = 'ID here'\n",
    "client_secret = 'Key here'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Authentication - without user\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=client_id, client_secret=client_secret)\n",
    "sp = spotipy.Spotify(client_credentials_manager = client_credentials_manager)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "playlist_link = \"https://open.spotify.com/playlist/1inW0f6Fp6qmtYo9MJSHwn\" # Insert your own playlist here\n",
    "\n",
    "\n",
    "playlist_URI = playlist_link.split(\"/\")[-1].split(\"?\")[0]\n",
    "track_uris = [x[\"track\"][\"uri\"] for x in sp.playlist_tracks(playlist_URI)[\"items\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = {\n",
    "    \"Track URI\": [],\n",
    "    \"Track Name\": [],\n",
    "    \"Artist Name\": [],\n",
    "    \"Artist Popularity\": [],\n",
    "    \"Artist Genres\": [],\n",
    "    \"Album\": [],\n",
    "    \"Track Popularity\": [],\n",
    "    \"Danceability\": [],\n",
    "    \"Energy\": [],\n",
    "    \"Key\": [],\n",
    "    \"Loudness\": [],\n",
    "    \"Mode\": [],\n",
    "    \"Speechiness\": [],\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "offset = 0\n",
    "limit = 100 # In order to get all playlists, so multiple calls to the api"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "while True:\n",
    "    playlist_tracks = sp.playlist_tracks(playlist_URI, offset=offset, limit=limit)\n",
    "\n",
    "    # If there are no more tracks, break the loop\n",
    "    if not playlist_tracks[\"items\"]:\n",
    "        break\n",
    "\n",
    "    for track in playlist_tracks[\"items\"]:\n",
    "        # URI\n",
    "        track_uri = track[\"track\"][\"uri\"]\n",
    "\n",
    "        # Track name\n",
    "        track_name = track[\"track\"][\"name\"]\n",
    "\n",
    "        # Main Artist\n",
    "        artist_uri = track[\"track\"][\"artists\"][0][\"uri\"]\n",
    "        artist_info = sp.artist(artist_uri)\n",
    "\n",
    "        # Name, popularity, genre\n",
    "        artist_name = track[\"track\"][\"artists\"][0][\"name\"]\n",
    "        artist_pop = artist_info[\"popularity\"]\n",
    "        artist_genres = artist_info[\"genres\"]\n",
    "\n",
    "        # Album\n",
    "        album = track[\"track\"][\"album\"][\"name\"]\n",
    "\n",
    "        # Popularity of the track\n",
    "        track_pop = track[\"track\"][\"popularity\"]\n",
    "\n",
    "        # Audio Features\n",
    "        audio_features = sp.audio_features(track_uri)[0]\n",
    "\n",
    "        # Check if audio_features is None, and skip this entry if it is\n",
    "        if audio_features is None:\n",
    "            audio_features = {\n",
    "                \"danceability\": 0,\n",
    "                \"energy\": 0,\n",
    "                \"key\": 0,\n",
    "                \"loudness\": 0,\n",
    "                \"mode\": 0,\n",
    "                \"speechiness\": 0\n",
    "            }\n",
    "        # Append data to lists\n",
    "        data[\"Track URI\"].append(track_uri)\n",
    "        data[\"Track Name\"].append(track_name)\n",
    "        data[\"Artist Name\"].append(artist_name)\n",
    "        data[\"Artist Popularity\"].append(artist_pop)\n",
    "        data[\"Artist Genres\"].append(artist_genres)\n",
    "        data[\"Album\"].append(album)\n",
    "        data[\"Track Popularity\"].append(track_pop)\n",
    "        \n",
    "        # Extract specific audio features\n",
    "        data[\"Danceability\"].append(audio_features[\"danceability\"])\n",
    "        data[\"Energy\"].append(audio_features[\"energy\"])\n",
    "        data[\"Key\"].append(audio_features[\"key\"])\n",
    "        data[\"Loudness\"].append(audio_features[\"loudness\"])\n",
    "        data[\"Mode\"].append(audio_features[\"mode\"])\n",
    "        data[\"Speechiness\"].append(audio_features[\"speechiness\"])\n",
    "\n",
    "    # Increment the offset to fetch the next batch of tracks\n",
    "    offset += limit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data[\"Danceability\"].append(0)\n",
    "data[\"Energy\"].append(0)\n",
    "data[\"Key\"].append(0)\n",
    "data[\"Loudness\"].append(0)\n",
    "data[\"Mode\"].append(0)\n",
    "data[\"Speechiness\"].append(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_length = len(data[\"Track URI\"])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Length of 'Track URI': 1000\n",
      "Length of 'Track Name': 1000\n",
      "Length of 'Artist Name': 1000\n",
      "Length of 'Artist Popularity': 1000\n",
      "Length of 'Artist Genres': 1000\n",
      "Length of 'Album': 1000\n",
      "Length of 'Track Popularity': 1000\n",
      "Length of 'Danceability': 1001\n",
      "Length of 'Energy': 1001\n",
      "Length of 'Key': 1001\n",
      "Length of 'Loudness': 1001\n",
      "Length of 'Mode': 1001\n",
      "Length of 'Speechiness': 1001\n"
     ]
    }
   ],
   "source": [
    "for feature_name, feature_values in data.items():\n",
    "    feature_length = len(feature_values)\n",
    "    print(f\"Length of '{feature_name}': {feature_length}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "data[\"Track URI\"].append(0)\n",
    "data[\"Track Name\"].append(0)\n",
    "data[\"Artist Name\"].append(0)\n",
    "data[\"Artist Popularity\"].append(0)\n",
    "data[\"Artist Genres\"].append(0)\n",
    "data[\"Album\"].append(0)\n",
    "data[\"Track Popularity\"].append(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Length of 'Track URI': 1001\n",
      "Length of 'Track Name': 1001\n",
      "Length of 'Artist Name': 1001\n",
      "Length of 'Artist Popularity': 1001\n",
      "Length of 'Artist Genres': 1001\n",
      "Length of 'Album': 1001\n",
      "Length of 'Track Popularity': 1001\n",
      "Length of 'Danceability': 1001\n",
      "Length of 'Energy': 1001\n",
      "Length of 'Key': 1001\n",
      "Length of 'Loudness': 1001\n",
      "Length of 'Mode': 1001\n",
      "Length of 'Speechiness': 1001\n"
     ]
    }
   ],
   "source": [
    "for feature_name, feature_values in data.items():\n",
    "    feature_length = len(feature_values)\n",
    "    print(f\"Length of '{feature_name}': {feature_length}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(data)\n",
    "df = df[(df != 0).any(axis=1)] #Drop the rows with 0\n",
    "\n",
    "df.to_csv(\"Playlist_2023.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = \"../Playlist_2023.csv\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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 URI</th>\n",
       "      <th>Track Name</th>\n",
       "      <th>Artist Name</th>\n",
       "      <th>Artist Popularity</th>\n",
       "      <th>Artist Genres</th>\n",
       "      <th>Album</th>\n",
       "      <th>Track Popularity</th>\n",
       "      <th>Danceability</th>\n",
       "      <th>Energy</th>\n",
       "      <th>Key</th>\n",
       "      <th>Loudness</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Speechiness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>spotify:track:2qxmye6gAegTMjLKEBoR3d</td>\n",
       "      <td>Let Me Down Slowly</td>\n",
       "      <td>Alec Benjamin</td>\n",
       "      <td>74</td>\n",
       "      <td>['alt z', 'pop', 'pov: indie']</td>\n",
       "      <td>Narrated For You</td>\n",
       "      <td>86</td>\n",
       "      <td>0.652</td>\n",
       "      <td>0.557</td>\n",
       "      <td>1</td>\n",
       "      <td>-5.714</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0318</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Track URI          Track Name    Artist Name  \\\n",
       "0  spotify:track:2qxmye6gAegTMjLKEBoR3d  Let Me Down Slowly  Alec Benjamin   \n",
       "\n",
       "   Artist Popularity                   Artist Genres             Album  \\\n",
       "0                 74  ['alt z', 'pop', 'pov: indie']  Narrated For You   \n",
       "\n",
       "   Track Popularity  Danceability  Energy  Key  Loudness  Mode  Speechiness  \n",
       "0                86         0.652   0.557    1    -5.714     0       0.0318  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(path)\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Artist Popularity</th>\n",
       "      <th>Artist Genres</th>\n",
       "      <th>Album</th>\n",
       "      <th>Track Popularity</th>\n",
       "      <th>Danceability</th>\n",
       "      <th>Energy</th>\n",
       "      <th>Key</th>\n",
       "      <th>Loudness</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Speechiness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>74</td>\n",
       "      <td>['alt z', 'pop', 'pov: indie']</td>\n",
       "      <td>Narrated For You</td>\n",
       "      <td>86</td>\n",
       "      <td>0.652</td>\n",
       "      <td>0.557</td>\n",
       "      <td>1</td>\n",
       "      <td>-5.714</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>59</td>\n",
       "      <td>['sad lo-fi']</td>\n",
       "      <td>Living Life, In The Night</td>\n",
       "      <td>78</td>\n",
       "      <td>0.624</td>\n",
       "      <td>0.499</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.962</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>49</td>\n",
       "      <td>[]</td>\n",
       "      <td>The Very Very Very Strongest! (Epic Version)</td>\n",
       "      <td>36</td>\n",
       "      <td>0.529</td>\n",
       "      <td>0.806</td>\n",
       "      <td>7</td>\n",
       "      <td>-6.772</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65</td>\n",
       "      <td>['irish pop', 'singer-songwriter pop']</td>\n",
       "      <td>Overwhelmed (Ryan Mack Remix)</td>\n",
       "      <td>76</td>\n",
       "      <td>0.658</td>\n",
       "      <td>0.445</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.749</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>62</td>\n",
       "      <td>['anthem worship', 'bossbeat']</td>\n",
       "      <td>Cinematic Songs (Vol. 6)</td>\n",
       "      <td>69</td>\n",
       "      <td>0.581</td>\n",
       "      <td>0.803</td>\n",
       "      <td>2</td>\n",
       "      <td>-4.935</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1520</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>38</td>\n",
       "      <td>['brostep', 'electro house']</td>\n",
       "      <td>Signals (Christian Reindl Remix)</td>\n",
       "      <td>34</td>\n",
       "      <td>0.558</td>\n",
       "      <td>0.867</td>\n",
       "      <td>4</td>\n",
       "      <td>-7.193</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>26</td>\n",
       "      <td>[]</td>\n",
       "      <td>Music Inspired By The Witcher 3: Wild Hunt</td>\n",
       "      <td>37</td>\n",
       "      <td>0.498</td>\n",
       "      <td>0.443</td>\n",
       "      <td>10</td>\n",
       "      <td>-15.061</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>48</td>\n",
       "      <td>['rebel blues']</td>\n",
       "      <td>Eye of the Storm</td>\n",
       "      <td>38</td>\n",
       "      <td>0.537</td>\n",
       "      <td>0.878</td>\n",
       "      <td>5</td>\n",
       "      <td>-7.861</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>49</td>\n",
       "      <td>['bass trap']</td>\n",
       "      <td>Solo</td>\n",
       "      <td>60</td>\n",
       "      <td>0.442</td>\n",
       "      <td>0.847</td>\n",
       "      <td>10</td>\n",
       "      <td>-4.111</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>51</td>\n",
       "      <td>['rebel blues']</td>\n",
       "      <td>Machines</td>\n",
       "      <td>40</td>\n",
       "      <td>0.451</td>\n",
       "      <td>0.954</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.714</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1220</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Artist Popularity                           Artist Genres  \\\n",
       "0                   74          ['alt z', 'pop', 'pov: indie']   \n",
       "1                   59                           ['sad lo-fi']   \n",
       "2                   49                                      []   \n",
       "3                   65  ['irish pop', 'singer-songwriter pop']   \n",
       "4                   62          ['anthem worship', 'bossbeat']   \n",
       "..                 ...                                     ...   \n",
       "995                 38            ['brostep', 'electro house']   \n",
       "996                 26                                      []   \n",
       "997                 48                         ['rebel blues']   \n",
       "998                 49                           ['bass trap']   \n",
       "999                 51                         ['rebel blues']   \n",
       "\n",
       "                                            Album  Track Popularity  \\\n",
       "0                                Narrated For You                86   \n",
       "1                       Living Life, In The Night                78   \n",
       "2    The Very Very Very Strongest! (Epic Version)                36   \n",
       "3                   Overwhelmed (Ryan Mack Remix)                76   \n",
       "4                        Cinematic Songs (Vol. 6)                69   \n",
       "..                                            ...               ...   \n",
       "995              Signals (Christian Reindl Remix)                34   \n",
       "996    Music Inspired By The Witcher 3: Wild Hunt                37   \n",
       "997                              Eye of the Storm                38   \n",
       "998                                          Solo                60   \n",
       "999                                      Machines                40   \n",
       "\n",
       "     Danceability  Energy  Key  Loudness  Mode  Speechiness  \n",
       "0           0.652   0.557    1    -5.714     0       0.0318  \n",
       "1           0.624   0.499    0    -9.962     0       0.0495  \n",
       "2           0.529   0.806    7    -6.772     1       0.0346  \n",
       "3           0.658   0.445    0    -8.749     0       0.1540  \n",
       "4           0.581   0.803    2    -4.935     0       0.1520  \n",
       "..            ...     ...  ...       ...   ...          ...  \n",
       "995         0.558   0.867    4    -7.193     0       0.0775  \n",
       "996         0.498   0.443   10   -15.061     1       0.0334  \n",
       "997         0.537   0.878    5    -7.861     1       0.0926  \n",
       "998         0.442   0.847   10    -4.111     0       0.1070  \n",
       "999         0.451   0.954    0    -3.714     1       0.1220  \n",
       "\n",
       "[1000 rows x 10 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drop = ['Track Name','Track URI','Artist Name']\n",
    "df.drop(drop, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Some basic cleaning\n",
    "import ast\n",
    "\n",
    "def extract_main_genre(genres_str):\n",
    "    try:\n",
    "        genres_list = ast.literal_eval(genres_str)\n",
    "        if genres_list:\n",
    "            return genres_list[0]\n",
    "        else:\n",
    "            return None\n",
    "    except (SyntaxError, ValueError):\n",
    "        return None\n",
    "\n",
    "df['Main Genre'] = df['Artist Genres'].apply(lambda x: extract_main_genre(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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 URI</th>\n",
       "      <th>Track Name</th>\n",
       "      <th>Artist Name</th>\n",
       "      <th>Artist Popularity</th>\n",
       "      <th>Artist Genres</th>\n",
       "      <th>Album</th>\n",
       "      <th>Track Popularity</th>\n",
       "      <th>Danceability</th>\n",
       "      <th>Energy</th>\n",
       "      <th>Key</th>\n",
       "      <th>Loudness</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Speechiness</th>\n",
       "      <th>Main Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>spotify:track:2qxmye6gAegTMjLKEBoR3d</td>\n",
       "      <td>Let Me Down Slowly</td>\n",
       "      <td>Alec Benjamin</td>\n",
       "      <td>74</td>\n",
       "      <td>['alt z', 'pop', 'pov: indie']</td>\n",
       "      <td>Narrated For You</td>\n",
       "      <td>86</td>\n",
       "      <td>0.652</td>\n",
       "      <td>0.557</td>\n",
       "      <td>1</td>\n",
       "      <td>-5.714</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0318</td>\n",
       "      <td>alt z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>spotify:track:2kx5sQgmjYug0GiDh1a4sU</td>\n",
       "      <td>Living Life, In The Night</td>\n",
       "      <td>Cheriimoya</td>\n",
       "      <td>59</td>\n",
       "      <td>['sad lo-fi']</td>\n",
       "      <td>Living Life, In The Night</td>\n",
       "      <td>78</td>\n",
       "      <td>0.624</td>\n",
       "      <td>0.499</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.962</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0495</td>\n",
       "      <td>sad lo-fi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>spotify:track:6KDLF8dSIrhW0snVS4KK1m</td>\n",
       "      <td>The Very Very Very Strongest! - Epic Version</td>\n",
       "      <td>Carameii</td>\n",
       "      <td>49</td>\n",
       "      <td>[]</td>\n",
       "      <td>The Very Very Very Strongest! (Epic Version)</td>\n",
       "      <td>36</td>\n",
       "      <td>0.529</td>\n",
       "      <td>0.806</td>\n",
       "      <td>7</td>\n",
       "      <td>-6.772</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0346</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>spotify:track:03eyNjBM2mpx28H6kdaufN</td>\n",
       "      <td>Overwhelmed (Ryan Mack Remix)</td>\n",
       "      <td>Ryan Mack</td>\n",
       "      <td>65</td>\n",
       "      <td>['irish pop', 'singer-songwriter pop']</td>\n",
       "      <td>Overwhelmed (Ryan Mack Remix)</td>\n",
       "      <td>76</td>\n",
       "      <td>0.658</td>\n",
       "      <td>0.445</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.749</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1540</td>\n",
       "      <td>irish pop</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>spotify:track:5X3T8jHNIJSXviiDmiBdz0</td>\n",
       "      <td>Enemy</td>\n",
       "      <td>Tommee Profitt</td>\n",
       "      <td>62</td>\n",
       "      <td>['anthem worship', 'bossbeat']</td>\n",
       "      <td>Cinematic Songs (Vol. 6)</td>\n",
       "      <td>69</td>\n",
       "      <td>0.581</td>\n",
       "      <td>0.803</td>\n",
       "      <td>2</td>\n",
       "      <td>-4.935</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1520</td>\n",
       "      <td>anthem worship</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Track URI  \\\n",
       "0  spotify:track:2qxmye6gAegTMjLKEBoR3d   \n",
       "1  spotify:track:2kx5sQgmjYug0GiDh1a4sU   \n",
       "2  spotify:track:6KDLF8dSIrhW0snVS4KK1m   \n",
       "3  spotify:track:03eyNjBM2mpx28H6kdaufN   \n",
       "4  spotify:track:5X3T8jHNIJSXviiDmiBdz0   \n",
       "\n",
       "                                     Track Name     Artist Name  \\\n",
       "0                            Let Me Down Slowly   Alec Benjamin   \n",
       "1                     Living Life, In The Night      Cheriimoya   \n",
       "2  The Very Very Very Strongest! - Epic Version        Carameii   \n",
       "3                 Overwhelmed (Ryan Mack Remix)       Ryan Mack   \n",
       "4                                         Enemy  Tommee Profitt   \n",
       "\n",
       "   Artist Popularity                           Artist Genres  \\\n",
       "0                 74          ['alt z', 'pop', 'pov: indie']   \n",
       "1                 59                           ['sad lo-fi']   \n",
       "2                 49                                      []   \n",
       "3                 65  ['irish pop', 'singer-songwriter pop']   \n",
       "4                 62          ['anthem worship', 'bossbeat']   \n",
       "\n",
       "                                          Album  Track Popularity  \\\n",
       "0                              Narrated For You                86   \n",
       "1                     Living Life, In The Night                78   \n",
       "2  The Very Very Very Strongest! (Epic Version)                36   \n",
       "3                 Overwhelmed (Ryan Mack Remix)                76   \n",
       "4                      Cinematic Songs (Vol. 6)                69   \n",
       "\n",
       "   Danceability  Energy  Key  Loudness  Mode  Speechiness      Main Genre  \n",
       "0         0.652   0.557    1    -5.714     0       0.0318           alt z  \n",
       "1         0.624   0.499    0    -9.962     0       0.0495       sad lo-fi  \n",
       "2         0.529   0.806    7    -6.772     1       0.0346            None  \n",
       "3         0.658   0.445    0    -8.749     0       0.1540       irish pop  \n",
       "4         0.581   0.803    2    -4.935     0       0.1520  anthem worship  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}