SpotiPY_v4.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# importando bibliotecas\n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "# Bibliotecas de conexão com a API do Spotify\n",
    "import spotipy\n",
    "from spotipy.oauth2 import SpotifyClientCredentials\n",
    "import spotipy.util as util"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Inserindo as constantes\n",
    "client_id = 'xXxxXxxXxxXxxXxxXxxXxxXxxXx'\n",
    "client_secret = 'xXxxXxxXxxXxxXxxXxxXxxXxxXx'\n",
    "redirect_uri = 'https://www.google.com'\n",
    "username = 'xXxxXxxXxxXxxXxxXxxXxxXx'\n",
    "scope = 'user-library-read playlist-read-private user-read-currently-playing'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criando a conexão com a API\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id = client_id, client_secret = client_secret)\n",
    "token = util.prompt_for_user_token(username, scope, client_id = client_id, client_secret = client_secret, redirect_uri = redirect_uri)\n",
    "sp = spotipy.Spotify(auth = token)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "playlist_id = '37i9dQZF1DWY3ikieEzZoK'\n",
    "offset = 0\n",
    "playlist = sp.playlist_tracks(playlist_id = playlist_id, offset = offset)\n",
    "songs = playlist['items']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>added_at</th>\n",
       "      <th>added_by</th>\n",
       "      <th>is_local</th>\n",
       "      <th>primary_color</th>\n",
       "      <th>track</th>\n",
       "      <th>video_thumbnail</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-05-30T20:27:29Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'compilation', 'artis...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-03-16T16:50:47Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'compilation', 'artis...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2022-03-16T16:50:47Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2021-05-06T09:51:30Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'compilation', 'artis...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2022-03-16T16:50:47Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2022-03-16T16:50:47Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>{'external_urls': {'spotify': 'https://open.sp...</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>{'album': {'album_type': 'album', 'artists': [...</td>\n",
       "      <td>{'url': None}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                added_at                                           added_by  \\\n",
       "0   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "1   2022-05-30T20:27:29Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "2   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "3   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "4   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "5   2022-03-16T16:50:47Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "6   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "7   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "8   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "9   2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "10  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "11  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "12  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "13  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "14  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "15  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "16  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "17  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "18  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "19  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "20  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "21  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "22  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "23  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "24  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "25  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "26  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "27  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "28  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "29  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "30  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "31  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "32  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "33  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "34  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "35  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "36  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "37  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "38  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "39  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "40  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "41  2022-03-16T16:50:47Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "42  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "43  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "44  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "45  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "46  2021-05-06T09:51:30Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "47  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "48  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "49  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "50  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "51  2022-03-16T16:50:47Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "52  2022-03-16T16:50:47Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "53  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "54  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "55  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "56  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "57  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "58  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "59  2021-03-17T09:17:18Z  {'external_urls': {'spotify': 'https://open.sp...   \n",
       "\n",
       "    is_local primary_color                                              track  \\\n",
       "0      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "1      False          None  {'album': {'album_type': 'compilation', 'artis...   \n",
       "2      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "3      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "4      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "5      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "6      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "7      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "8      False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "9      False          None  {'album': {'album_type': 'compilation', 'artis...   \n",
       "10     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "11     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "12     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "13     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "14     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "15     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "16     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "17     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "18     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "19     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "20     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "21     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "22     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "23     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "24     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "25     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "26     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "27     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "28     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "29     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "30     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "31     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "32     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "33     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "34     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "35     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "36     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "37     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "38     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "39     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "40     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "41     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "42     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "43     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "44     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "45     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "46     False          None  {'album': {'album_type': 'compilation', 'artis...   \n",
       "47     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "48     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "49     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "50     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "51     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "52     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "53     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "54     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "55     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "56     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "57     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "58     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "59     False          None  {'album': {'album_type': 'album', 'artists': [...   \n",
       "\n",
       "   video_thumbnail  \n",
       "0    {'url': None}  \n",
       "1    {'url': None}  \n",
       "2    {'url': None}  \n",
       "3    {'url': None}  \n",
       "4    {'url': None}  \n",
       "5    {'url': None}  \n",
       "6    {'url': None}  \n",
       "7    {'url': None}  \n",
       "8    {'url': None}  \n",
       "9    {'url': None}  \n",
       "10   {'url': None}  \n",
       "11   {'url': None}  \n",
       "12   {'url': None}  \n",
       "13   {'url': None}  \n",
       "14   {'url': None}  \n",
       "15   {'url': None}  \n",
       "16   {'url': None}  \n",
       "17   {'url': None}  \n",
       "18   {'url': None}  \n",
       "19   {'url': None}  \n",
       "20   {'url': None}  \n",
       "21   {'url': None}  \n",
       "22   {'url': None}  \n",
       "23   {'url': None}  \n",
       "24   {'url': None}  \n",
       "25   {'url': None}  \n",
       "26   {'url': None}  \n",
       "27   {'url': None}  \n",
       "28   {'url': None}  \n",
       "29   {'url': None}  \n",
       "30   {'url': None}  \n",
       "31   {'url': None}  \n",
       "32   {'url': None}  \n",
       "33   {'url': None}  \n",
       "34   {'url': None}  \n",
       "35   {'url': None}  \n",
       "36   {'url': None}  \n",
       "37   {'url': None}  \n",
       "38   {'url': None}  \n",
       "39   {'url': None}  \n",
       "40   {'url': None}  \n",
       "41   {'url': None}  \n",
       "42   {'url': None}  \n",
       "43   {'url': None}  \n",
       "44   {'url': None}  \n",
       "45   {'url': None}  \n",
       "46   {'url': None}  \n",
       "47   {'url': None}  \n",
       "48   {'url': None}  \n",
       "49   {'url': None}  \n",
       "50   {'url': None}  \n",
       "51   {'url': None}  \n",
       "52   {'url': None}  \n",
       "53   {'url': None}  \n",
       "54   {'url': None}  \n",
       "55   {'url': None}  \n",
       "56   {'url': None}  \n",
       "57   {'url': None}  \n",
       "58   {'url': None}  \n",
       "59   {'url': None}  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(songs)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Artists</th>\n",
       "      <th>Music</th>\n",
       "      <th>Album</th>\n",
       "      <th>Added_At</th>\n",
       "      <th>Id</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Popularity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eagles</td>\n",
       "      <td>Life in the Fast Lane - 2013 Remaster</td>\n",
       "      <td>Hotel California (2013 Remaster)</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>6gXrEUzibufX9xYPk3HD5p</td>\n",
       "      <td>[album rock, classic rock, country rock, folk ...</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KISS</td>\n",
       "      <td>Detroit Rock City</td>\n",
       "      <td>Smashes Thrashes &amp; Hits</td>\n",
       "      <td>2022-05-30T20:27:29Z</td>\n",
       "      <td>3uz0O62HqYoyRiWZjS61KK</td>\n",
       "      <td>[album rock, glam rock, hard rock, metal, rock]</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aerosmith</td>\n",
       "      <td>Back In the Saddle</td>\n",
       "      <td>Rocks</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>0ZGLuduCPjgWY1n85ykgMe</td>\n",
       "      <td>[album rock, classic rock, hard rock, rock]</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bob Seger</td>\n",
       "      <td>The Fire Down Below</td>\n",
       "      <td>Night Moves</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>7uQftgqxvkdl9GLE1Q3OOQ</td>\n",
       "      <td>[album rock, classic rock, country rock, detro...</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rainbow</td>\n",
       "      <td>Stargazer</td>\n",
       "      <td>Rising</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>1aDNYyeU62BuQsBAY18i48</td>\n",
       "      <td>[album rock, blues rock, classic rock, glam me...</td>\n",
       "      <td>60</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Boston</td>\n",
       "      <td>More Than a Feeling</td>\n",
       "      <td>Boston</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>1QEEqeFIZktqIpPI4jSVSF</td>\n",
       "      <td>[album rock, classic rock, country rock, hard ...</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>David Bowie</td>\n",
       "      <td>Golden Years - 2016 Remaster</td>\n",
       "      <td>Station to Station (2016 Remaster)</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>4JRem7xHp2l0kmUvt9zCKu</td>\n",
       "      <td>[art rock, classic rock, glam rock, permanent ...</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Patti Smith</td>\n",
       "      <td>Ain't It Strange</td>\n",
       "      <td>Radio Ethiopia</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>4Q0gexDyqLyLHmnktsn0KQ</td>\n",
       "      <td>[art punk, art rock, folk rock, permanent wave...</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>Carry on Wayward Son</td>\n",
       "      <td>Leftoverture (Expanded Edition)</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>4DMKwE2E2iYDKY01C335Uw</td>\n",
       "      <td>[album rock, art rock, classic rock, hard rock...</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Rod Stewart</td>\n",
       "      <td>The First Cut Is the Deepest</td>\n",
       "      <td>A Night on the Town</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>3FeYjbIVqvAhuTcwsE6K3v</td>\n",
       "      <td>[mellow gold, soft rock]</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Artists                                  Music  \\\n",
       "0        Eagles  Life in the Fast Lane - 2013 Remaster   \n",
       "1          KISS                      Detroit Rock City   \n",
       "2     Aerosmith                     Back In the Saddle   \n",
       "3     Bob Seger                    The Fire Down Below   \n",
       "4       Rainbow                              Stargazer   \n",
       "..          ...                                    ...   \n",
       "55       Boston                    More Than a Feeling   \n",
       "56  David Bowie           Golden Years - 2016 Remaster   \n",
       "57  Patti Smith                       Ain't It Strange   \n",
       "58       Kansas                   Carry on Wayward Son   \n",
       "59  Rod Stewart           The First Cut Is the Deepest   \n",
       "\n",
       "                                 Album              Added_At  \\\n",
       "0     Hotel California (2013 Remaster)  2021-03-17T09:17:18Z   \n",
       "1              Smashes Thrashes & Hits  2022-05-30T20:27:29Z   \n",
       "2                                Rocks  2021-03-17T09:17:18Z   \n",
       "3                          Night Moves  2021-03-17T09:17:18Z   \n",
       "4                               Rising  2021-03-17T09:17:18Z   \n",
       "..                                 ...                   ...   \n",
       "55                              Boston  2021-03-17T09:17:18Z   \n",
       "56  Station to Station (2016 Remaster)  2021-03-17T09:17:18Z   \n",
       "57                      Radio Ethiopia  2021-03-17T09:17:18Z   \n",
       "58     Leftoverture (Expanded Edition)  2021-03-17T09:17:18Z   \n",
       "59                 A Night on the Town  2021-03-17T09:17:18Z   \n",
       "\n",
       "                        Id                                             Genres  \\\n",
       "0   6gXrEUzibufX9xYPk3HD5p  [album rock, classic rock, country rock, folk ...   \n",
       "1   3uz0O62HqYoyRiWZjS61KK    [album rock, glam rock, hard rock, metal, rock]   \n",
       "2   0ZGLuduCPjgWY1n85ykgMe        [album rock, classic rock, hard rock, rock]   \n",
       "3   7uQftgqxvkdl9GLE1Q3OOQ  [album rock, classic rock, country rock, detro...   \n",
       "4   1aDNYyeU62BuQsBAY18i48  [album rock, blues rock, classic rock, glam me...   \n",
       "..                     ...                                                ...   \n",
       "55  1QEEqeFIZktqIpPI4jSVSF  [album rock, classic rock, country rock, hard ...   \n",
       "56  4JRem7xHp2l0kmUvt9zCKu  [art rock, classic rock, glam rock, permanent ...   \n",
       "57  4Q0gexDyqLyLHmnktsn0KQ  [art punk, art rock, folk rock, permanent wave...   \n",
       "58  4DMKwE2E2iYDKY01C335Uw  [album rock, art rock, classic rock, hard rock...   \n",
       "59  3FeYjbIVqvAhuTcwsE6K3v                           [mellow gold, soft rock]   \n",
       "\n",
       "    Popularity  \n",
       "0           74  \n",
       "1           71  \n",
       "2           74  \n",
       "3           66  \n",
       "4           60  \n",
       "..         ...  \n",
       "55          64  \n",
       "56          75  \n",
       "57          57  \n",
       "58          64  \n",
       "59          71  \n",
       "\n",
       "[60 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "musics_info = []\n",
    "\n",
    "for i, item in enumerate(songs):\n",
    "    track = item['track']\n",
    "    added_at = item['added_at']\n",
    "    try:\n",
    "      artist = sp.artist(track['artists'][0]['id'])\n",
    "    except AttributeError:\n",
    "       print('Erro ao obter dados do artista')\n",
    "    musics_info.append((track['artists'][0]['name'], track['name'], track['album']['name'], added_at, track['id'], artist['genres'], artist['popularity']))\n",
    "\n",
    "#print(artists)\n",
    "\n",
    "pd.set_option('display.max_rows', 50)\n",
    "musics = pd.DataFrame(musics_info, columns=('Artists', 'Music', 'Album', 'Added_At', 'Id', 'Genres', 'Popularity'))\n",
    "musics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>energy</th>\n",
       "      <th>liveness</th>\n",
       "      <th>tempo</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>time_signature</th>\n",
       "      <th>danceability</th>\n",
       "      <th>key</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>loudness</th>\n",
       "      <th>valence</th>\n",
       "      <th>mode</th>\n",
       "      <th>type</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.755</td>\n",
       "      <td>0.0523</td>\n",
       "      <td>109.535</td>\n",
       "      <td>0.0690</td>\n",
       "      <td>0.09660</td>\n",
       "      <td>0.000069</td>\n",
       "      <td>4</td>\n",
       "      <td>0.667</td>\n",
       "      <td>9</td>\n",
       "      <td>286220</td>\n",
       "      <td>-7.246</td>\n",
       "      <td>0.883</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:6gXrEUzibufX9xYPk3HD5p</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.847</td>\n",
       "      <td>0.1440</td>\n",
       "      <td>90.654</td>\n",
       "      <td>0.0984</td>\n",
       "      <td>0.00884</td>\n",
       "      <td>0.000206</td>\n",
       "      <td>4</td>\n",
       "      <td>0.479</td>\n",
       "      <td>0</td>\n",
       "      <td>228560</td>\n",
       "      <td>-11.036</td>\n",
       "      <td>0.317</td>\n",
       "      <td>0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:3uz0O62HqYoyRiWZjS61KK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.903</td>\n",
       "      <td>0.0945</td>\n",
       "      <td>122.201</td>\n",
       "      <td>0.0389</td>\n",
       "      <td>0.00578</td>\n",
       "      <td>0.009450</td>\n",
       "      <td>4</td>\n",
       "      <td>0.426</td>\n",
       "      <td>1</td>\n",
       "      <td>280360</td>\n",
       "      <td>-9.661</td>\n",
       "      <td>0.762</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:0ZGLuduCPjgWY1n85ykgMe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.843</td>\n",
       "      <td>0.1030</td>\n",
       "      <td>111.848</td>\n",
       "      <td>0.0278</td>\n",
       "      <td>0.39100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>0.715</td>\n",
       "      <td>0</td>\n",
       "      <td>267172</td>\n",
       "      <td>-2.830</td>\n",
       "      <td>0.512</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:7uQftgqxvkdl9GLE1Q3OOQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.948</td>\n",
       "      <td>0.7690</td>\n",
       "      <td>177.495</td>\n",
       "      <td>0.0631</td>\n",
       "      <td>0.00374</td>\n",
       "      <td>0.013100</td>\n",
       "      <td>4</td>\n",
       "      <td>0.166</td>\n",
       "      <td>11</td>\n",
       "      <td>506160</td>\n",
       "      <td>-8.503</td>\n",
       "      <td>0.476</td>\n",
       "      <td>0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:1aDNYyeU62BuQsBAY18i48</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>0.681</td>\n",
       "      <td>0.0504</td>\n",
       "      <td>108.789</td>\n",
       "      <td>0.0298</td>\n",
       "      <td>0.00088</td>\n",
       "      <td>0.002300</td>\n",
       "      <td>4</td>\n",
       "      <td>0.377</td>\n",
       "      <td>7</td>\n",
       "      <td>285133</td>\n",
       "      <td>-8.039</td>\n",
       "      <td>0.285</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:1QEEqeFIZktqIpPI4jSVSF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>0.701</td>\n",
       "      <td>0.1110</td>\n",
       "      <td>108.287</td>\n",
       "      <td>0.0360</td>\n",
       "      <td>0.31600</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>4</td>\n",
       "      <td>0.680</td>\n",
       "      <td>6</td>\n",
       "      <td>243280</td>\n",
       "      <td>-10.360</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4JRem7xHp2l0kmUvt9zCKu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>0.510</td>\n",
       "      <td>0.1410</td>\n",
       "      <td>121.823</td>\n",
       "      <td>0.0513</td>\n",
       "      <td>0.09010</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>0.415</td>\n",
       "      <td>5</td>\n",
       "      <td>396360</td>\n",
       "      <td>-9.531</td>\n",
       "      <td>0.382</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4Q0gexDyqLyLHmnktsn0KQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>0.786</td>\n",
       "      <td>0.4460</td>\n",
       "      <td>126.755</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>0.00321</td>\n",
       "      <td>0.000089</td>\n",
       "      <td>4</td>\n",
       "      <td>0.482</td>\n",
       "      <td>7</td>\n",
       "      <td>323000</td>\n",
       "      <td>-5.735</td>\n",
       "      <td>0.793</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4DMKwE2E2iYDKY01C335Uw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>0.627</td>\n",
       "      <td>0.0960</td>\n",
       "      <td>81.278</td>\n",
       "      <td>0.0244</td>\n",
       "      <td>0.31600</td>\n",
       "      <td>0.001140</td>\n",
       "      <td>4</td>\n",
       "      <td>0.546</td>\n",
       "      <td>0</td>\n",
       "      <td>271200</td>\n",
       "      <td>-9.037</td>\n",
       "      <td>0.764</td>\n",
       "      <td>1</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:3FeYjbIVqvAhuTcwsE6K3v</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    energy  liveness    tempo  speechiness  acousticness  instrumentalness  \\\n",
       "0    0.755    0.0523  109.535       0.0690       0.09660          0.000069   \n",
       "1    0.847    0.1440   90.654       0.0984       0.00884          0.000206   \n",
       "2    0.903    0.0945  122.201       0.0389       0.00578          0.009450   \n",
       "3    0.843    0.1030  111.848       0.0278       0.39100          0.000000   \n",
       "4    0.948    0.7690  177.495       0.0631       0.00374          0.013100   \n",
       "..     ...       ...      ...          ...           ...               ...   \n",
       "55   0.681    0.0504  108.789       0.0298       0.00088          0.002300   \n",
       "56   0.701    0.1110  108.287       0.0360       0.31600          0.000005   \n",
       "57   0.510    0.1410  121.823       0.0513       0.09010          0.000000   \n",
       "58   0.786    0.4460  126.755       0.0320       0.00321          0.000089   \n",
       "59   0.627    0.0960   81.278       0.0244       0.31600          0.001140   \n",
       "\n",
       "    time_signature  danceability  key  duration_ms  loudness  valence  mode  \\\n",
       "0                4         0.667    9       286220    -7.246    0.883     1   \n",
       "1                4         0.479    0       228560   -11.036    0.317     0   \n",
       "2                4         0.426    1       280360    -9.661    0.762     1   \n",
       "3                4         0.715    0       267172    -2.830    0.512     1   \n",
       "4                4         0.166   11       506160    -8.503    0.476     0   \n",
       "..             ...           ...  ...          ...       ...      ...   ...   \n",
       "55               4         0.377    7       285133    -8.039    0.285     1   \n",
       "56               4         0.680    6       243280   -10.360    0.933     0   \n",
       "57               4         0.415    5       396360    -9.531    0.382     1   \n",
       "58               4         0.482    7       323000    -5.735    0.793     1   \n",
       "59               4         0.546    0       271200    -9.037    0.764     1   \n",
       "\n",
       "              type                                   uri  \n",
       "0   audio_features  spotify:track:6gXrEUzibufX9xYPk3HD5p  \n",
       "1   audio_features  spotify:track:3uz0O62HqYoyRiWZjS61KK  \n",
       "2   audio_features  spotify:track:0ZGLuduCPjgWY1n85ykgMe  \n",
       "3   audio_features  spotify:track:7uQftgqxvkdl9GLE1Q3OOQ  \n",
       "4   audio_features  spotify:track:1aDNYyeU62BuQsBAY18i48  \n",
       "..             ...                                   ...  \n",
       "55  audio_features  spotify:track:1QEEqeFIZktqIpPI4jSVSF  \n",
       "56  audio_features  spotify:track:4JRem7xHp2l0kmUvt9zCKu  \n",
       "57  audio_features  spotify:track:4Q0gexDyqLyLHmnktsn0KQ  \n",
       "58  audio_features  spotify:track:4DMKwE2E2iYDKY01C335Uw  \n",
       "59  audio_features  spotify:track:3FeYjbIVqvAhuTcwsE6K3v  \n",
       "\n",
       "[60 rows x 15 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "af = sp.audio_features(musics['Id'])[0:100]\n",
    "\n",
    "af = pd.DataFrame(af, columns = ['energy', 'liveness',\n",
    "'tempo', 'speechiness',\n",
    "'acousticness', 'instrumentalness',\n",
    "'time_signature', 'danceability',\n",
    "'key', 'duration_ms', 'loudness',\n",
    "'valence', 'mode', 'type', 'uri'])\n",
    "\n",
    "af"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Music</th>\n",
       "      <th>Album</th>\n",
       "      <th>Added_At</th>\n",
       "      <th>Id</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>energy</th>\n",
       "      <th>liveness</th>\n",
       "      <th>tempo</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>...</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>time_signature</th>\n",
       "      <th>danceability</th>\n",
       "      <th>key</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>loudness</th>\n",
       "      <th>valence</th>\n",
       "      <th>mode</th>\n",
       "      <th>type</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Artists</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>Eagles</th>\n",
       "      <td>Life in the Fast Lane - 2013 Remaster</td>\n",
       "      <td>Hotel California (2013 Remaster)</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>6gXrEUzibufX9xYPk3HD5p</td>\n",
       "      <td>[album rock, classic rock, country rock, folk ...</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KISS</th>\n",
       "      <td>Detroit Rock City</td>\n",
       "      <td>Smashes Thrashes &amp; Hits</td>\n",
       "      <td>2022-05-30T20:27:29Z</td>\n",
       "      <td>3uz0O62HqYoyRiWZjS61KK</td>\n",
       "      <td>[album rock, glam rock, hard rock, metal, rock]</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aerosmith</th>\n",
       "      <td>Back In the Saddle</td>\n",
       "      <td>Rocks</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>0ZGLuduCPjgWY1n85ykgMe</td>\n",
       "      <td>[album rock, classic rock, hard rock, rock]</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bob Seger</th>\n",
       "      <td>The Fire Down Below</td>\n",
       "      <td>Night Moves</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>7uQftgqxvkdl9GLE1Q3OOQ</td>\n",
       "      <td>[album rock, classic rock, country rock, detro...</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rainbow</th>\n",
       "      <td>Stargazer</td>\n",
       "      <td>Rising</td>\n",
       "      <td>2021-03-17T09:17:18Z</td>\n",
       "      <td>1aDNYyeU62BuQsBAY18i48</td>\n",
       "      <td>[album rock, blues rock, classic rock, glam me...</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.681</td>\n",
       "      <td>0.0504</td>\n",
       "      <td>108.789</td>\n",
       "      <td>0.0298</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002300</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.377</td>\n",
       "      <td>7.0</td>\n",
       "      <td>285133.0</td>\n",
       "      <td>-8.039</td>\n",
       "      <td>0.285</td>\n",
       "      <td>1.0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:1QEEqeFIZktqIpPI4jSVSF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.701</td>\n",
       "      <td>0.1110</td>\n",
       "      <td>108.287</td>\n",
       "      <td>0.0360</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.680</td>\n",
       "      <td>6.0</td>\n",
       "      <td>243280.0</td>\n",
       "      <td>-10.360</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4JRem7xHp2l0kmUvt9zCKu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.510</td>\n",
       "      <td>0.1410</td>\n",
       "      <td>121.823</td>\n",
       "      <td>0.0513</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.415</td>\n",
       "      <td>5.0</td>\n",
       "      <td>396360.0</td>\n",
       "      <td>-9.531</td>\n",
       "      <td>0.382</td>\n",
       "      <td>1.0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4Q0gexDyqLyLHmnktsn0KQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.786</td>\n",
       "      <td>0.4460</td>\n",
       "      <td>126.755</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000089</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.482</td>\n",
       "      <td>7.0</td>\n",
       "      <td>323000.0</td>\n",
       "      <td>-5.735</td>\n",
       "      <td>0.793</td>\n",
       "      <td>1.0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:4DMKwE2E2iYDKY01C335Uw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.627</td>\n",
       "      <td>0.0960</td>\n",
       "      <td>81.278</td>\n",
       "      <td>0.0244</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001140</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.546</td>\n",
       "      <td>0.0</td>\n",
       "      <td>271200.0</td>\n",
       "      <td>-9.037</td>\n",
       "      <td>0.764</td>\n",
       "      <td>1.0</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>spotify:track:3FeYjbIVqvAhuTcwsE6K3v</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>120 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Music  \\\n",
       "Artists                                            \n",
       "Eagles     Life in the Fast Lane - 2013 Remaster   \n",
       "KISS                           Detroit Rock City   \n",
       "Aerosmith                     Back In the Saddle   \n",
       "Bob Seger                    The Fire Down Below   \n",
       "Rainbow                                Stargazer   \n",
       "...                                          ...   \n",
       "0                                              0   \n",
       "0                                              0   \n",
       "0                                              0   \n",
       "0                                              0   \n",
       "0                                              0   \n",
       "\n",
       "                                      Album              Added_At  \\\n",
       "Artists                                                             \n",
       "Eagles     Hotel California (2013 Remaster)  2021-03-17T09:17:18Z   \n",
       "KISS                Smashes Thrashes & Hits  2022-05-30T20:27:29Z   \n",
       "Aerosmith                             Rocks  2021-03-17T09:17:18Z   \n",
       "Bob Seger                       Night Moves  2021-03-17T09:17:18Z   \n",
       "Rainbow                              Rising  2021-03-17T09:17:18Z   \n",
       "...                                     ...                   ...   \n",
       "0                                         0                     0   \n",
       "0                                         0                     0   \n",
       "0                                         0                     0   \n",
       "0                                         0                     0   \n",
       "0                                         0                     0   \n",
       "\n",
       "                               Id  \\\n",
       "Artists                             \n",
       "Eagles     6gXrEUzibufX9xYPk3HD5p   \n",
       "KISS       3uz0O62HqYoyRiWZjS61KK   \n",
       "Aerosmith  0ZGLuduCPjgWY1n85ykgMe   \n",
       "Bob Seger  7uQftgqxvkdl9GLE1Q3OOQ   \n",
       "Rainbow    1aDNYyeU62BuQsBAY18i48   \n",
       "...                           ...   \n",
       "0                               0   \n",
       "0                               0   \n",
       "0                               0   \n",
       "0                               0   \n",
       "0                               0   \n",
       "\n",
       "                                                      Genres  Popularity  \\\n",
       "Artists                                                                    \n",
       "Eagles     [album rock, classic rock, country rock, folk ...        74.0   \n",
       "KISS         [album rock, glam rock, hard rock, metal, rock]        71.0   \n",
       "Aerosmith        [album rock, classic rock, hard rock, rock]        74.0   \n",
       "Bob Seger  [album rock, classic rock, country rock, detro...        66.0   \n",
       "Rainbow    [album rock, blues rock, classic rock, glam me...        60.0   \n",
       "...                                                      ...         ...   \n",
       "0                                                          0         0.0   \n",
       "0                                                          0         0.0   \n",
       "0                                                          0         0.0   \n",
       "0                                                          0         0.0   \n",
       "0                                                          0         0.0   \n",
       "\n",
       "           energy  liveness    tempo  speechiness  ...  instrumentalness  \\\n",
       "Artists                                            ...                     \n",
       "Eagles      0.000    0.0000    0.000       0.0000  ...          0.000000   \n",
       "KISS        0.000    0.0000    0.000       0.0000  ...          0.000000   \n",
       "Aerosmith   0.000    0.0000    0.000       0.0000  ...          0.000000   \n",
       "Bob Seger   0.000    0.0000    0.000       0.0000  ...          0.000000   \n",
       "Rainbow     0.000    0.0000    0.000       0.0000  ...          0.000000   \n",
       "...           ...       ...      ...          ...  ...               ...   \n",
       "0           0.681    0.0504  108.789       0.0298  ...          0.002300   \n",
       "0           0.701    0.1110  108.287       0.0360  ...          0.000005   \n",
       "0           0.510    0.1410  121.823       0.0513  ...          0.000000   \n",
       "0           0.786    0.4460  126.755       0.0320  ...          0.000089   \n",
       "0           0.627    0.0960   81.278       0.0244  ...          0.001140   \n",
       "\n",
       "           time_signature  danceability  key  duration_ms  loudness  valence  \\\n",
       "Artists                                                                        \n",
       "Eagles                0.0         0.000  0.0          0.0     0.000    0.000   \n",
       "KISS                  0.0         0.000  0.0          0.0     0.000    0.000   \n",
       "Aerosmith             0.0         0.000  0.0          0.0     0.000    0.000   \n",
       "Bob Seger             0.0         0.000  0.0          0.0     0.000    0.000   \n",
       "Rainbow               0.0         0.000  0.0          0.0     0.000    0.000   \n",
       "...                   ...           ...  ...          ...       ...      ...   \n",
       "0                     4.0         0.377  7.0     285133.0    -8.039    0.285   \n",
       "0                     4.0         0.680  6.0     243280.0   -10.360    0.933   \n",
       "0                     4.0         0.415  5.0     396360.0    -9.531    0.382   \n",
       "0                     4.0         0.482  7.0     323000.0    -5.735    0.793   \n",
       "0                     4.0         0.546  0.0     271200.0    -9.037    0.764   \n",
       "\n",
       "           mode            type                                   uri  \n",
       "Artists                                                                \n",
       "Eagles      0.0               0                                     0  \n",
       "KISS        0.0               0                                     0  \n",
       "Aerosmith   0.0               0                                     0  \n",
       "Bob Seger   0.0               0                                     0  \n",
       "Rainbow     0.0               0                                     0  \n",
       "...         ...             ...                                   ...  \n",
       "0           1.0  audio_features  spotify:track:1QEEqeFIZktqIpPI4jSVSF  \n",
       "0           0.0  audio_features  spotify:track:4JRem7xHp2l0kmUvt9zCKu  \n",
       "0           1.0  audio_features  spotify:track:4Q0gexDyqLyLHmnktsn0KQ  \n",
       "0           1.0  audio_features  spotify:track:4DMKwE2E2iYDKY01C335Uw  \n",
       "0           1.0  audio_features  spotify:track:3FeYjbIVqvAhuTcwsE6K3v  \n",
       "\n",
       "[120 rows x 21 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "songs_features = pd.concat([musics, af]) # Concatenando os dois Datasets\n",
    "songs_features.fillna(0, inplace=True)\n",
    "songs_features.set_index(['Artists'], inplace = True) # Passando a variável 'SEQN' como Index ou Chave Única\n",
    "songs_features"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "a4368f5c4c460ff459960bc4e5411f7699554dc7701aa5fe5c574ecc9c7df956"
  },
  "kernelspec": {
   "display_name": "Python 3.9.2 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.2"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}