API_spotipy_audio_features.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# conda install requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import time\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### First, I will import my top tracks dataframe from other notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "tracksdf=pd.read_csv('lastfm_top_tracks.csv')\n",
    "df= pd.DataFrame(tracksdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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</th>\n",
       "      <th>track</th>\n",
       "      <th>play_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>La vuelta</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>To Be So Lonely</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Watermelon Sugar</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Golden</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Tú Mandas</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Treat People with Kindness</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>Conduciendo y Llorando</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>She</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>John Legend</td>\n",
       "      <td>God Only Knows (feat. yMusic)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Maxence Cyrin</td>\n",
       "      <td>Where is my mind</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NACH</td>\n",
       "      <td>Leyenda</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Prince</td>\n",
       "      <td>Purple Rain</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Set Fire to the Rain</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Erika Jayne</td>\n",
       "      <td>How Many Fucks?</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Feten Feten</td>\n",
       "      <td>Límite</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Guitarricadelafuente</td>\n",
       "      <td>El Conticinio</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>From the Dining Table</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Kiwi</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Sweet Creature</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>¡Yep!</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Déjame Vivir - Versión 50 Palos</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Grita</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Grita - Versión Filarmónica</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Hombrecitos</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Hoy No Soy Yo</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>La Vida Es el Momento</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Me Flechaste Ingrata</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Misteriosamente Hoy</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Que Bueno - Versión 50 Palos</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Jarabe de Palo</td>\n",
       "      <td>Tragas o Escupes</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Joy Crookes</td>\n",
       "      <td>Darkest Hour</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>Héroes del Sábado</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Shallow</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Miguel</td>\n",
       "      <td>Remember Me (Dúo)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Morgan</td>\n",
       "      <td>Volver - Bonus Track</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Prince</td>\n",
       "      <td>Raspberry Beret</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 artist                            track  \\\n",
       "0   La Maravillosa Orquesta del Alcohol                        La vuelta   \n",
       "1                          Harry Styles                  To Be So Lonely   \n",
       "2                          Harry Styles                 Watermelon Sugar   \n",
       "3                          Harry Styles                           Golden   \n",
       "4                        Jarabe de Palo                        Tú Mandas   \n",
       "5                          Harry Styles       Treat People with Kindness   \n",
       "6   La Maravillosa Orquesta del Alcohol           Conduciendo y Llorando   \n",
       "7                                 Adele                 Someone Like You   \n",
       "8                          Harry Styles                              She   \n",
       "9                           John Legend    God Only Knows (feat. yMusic)   \n",
       "10                        Maxence Cyrin                 Where is my mind   \n",
       "11                                 NACH                          Leyenda   \n",
       "12                               Prince                      Purple Rain   \n",
       "13                                Adele             Set Fire to the Rain   \n",
       "14                          Erika Jayne                  How Many Fucks?   \n",
       "15                          Feten Feten                           Límite   \n",
       "16                 Guitarricadelafuente                    El Conticinio   \n",
       "17                         Harry Styles            From the Dining Table   \n",
       "18                         Harry Styles                             Kiwi   \n",
       "19                         Harry Styles                   Sweet Creature   \n",
       "20                       Jarabe de Palo                            ¡Yep!   \n",
       "21                       Jarabe de Palo  Déjame Vivir - Versión 50 Palos   \n",
       "22                       Jarabe de Palo                            Grita   \n",
       "23                       Jarabe de Palo      Grita - Versión Filarmónica   \n",
       "24                       Jarabe de Palo                      Hombrecitos   \n",
       "25                       Jarabe de Palo                    Hoy No Soy Yo   \n",
       "26                       Jarabe de Palo            La Vida Es el Momento   \n",
       "27                       Jarabe de Palo             Me Flechaste Ingrata   \n",
       "28                       Jarabe de Palo              Misteriosamente Hoy   \n",
       "29                       Jarabe de Palo     Que Bueno - Versión 50 Palos   \n",
       "30                       Jarabe de Palo                 Tragas o Escupes   \n",
       "31                          Joy Crookes                     Darkest Hour   \n",
       "32  La Maravillosa Orquesta del Alcohol                Héroes del Sábado   \n",
       "33                            Lady Gaga                          Shallow   \n",
       "34                               Miguel                Remember Me (Dúo)   \n",
       "35                               Morgan             Volver - Bonus Track   \n",
       "36                               Prince                  Raspberry Beret   \n",
       "\n",
       "    play_count  \n",
       "0           12  \n",
       "1            6  \n",
       "2            6  \n",
       "3            5  \n",
       "4            5  \n",
       "5            4  \n",
       "6            3  \n",
       "7            2  \n",
       "8            2  \n",
       "9            2  \n",
       "10           2  \n",
       "11           2  \n",
       "12           2  \n",
       "13           1  \n",
       "14           1  \n",
       "15           1  \n",
       "16           1  \n",
       "17           1  \n",
       "18           1  \n",
       "19           1  \n",
       "20           1  \n",
       "21           1  \n",
       "22           1  \n",
       "23           1  \n",
       "24           1  \n",
       "25           1  \n",
       "26           1  \n",
       "27           1  \n",
       "28           1  \n",
       "29           1  \n",
       "30           1  \n",
       "31           1  \n",
       "32           1  \n",
       "33           1  \n",
       "34           1  \n",
       "35           1  \n",
       "36           1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(37, 3)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().any().any()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pip install spotipy --upgrade"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import spotipy \n",
    "from spotipy.oauth2 import SpotifyClientCredentials\n",
    "\n",
    "SPOTIPY_CLIENT_ID = 'YOUR_ID'\n",
    "SPOTIPY_CLIENT_SECRET = 'YOUR_SECRET_KEY'\n",
    "\n",
    "client_credentials_manager = SpotifyClientCredentials(client_id=SPOTIPY_CLIENT_ID,\n",
    "                                                      client_secret=SPOTIPY_CLIENT_SECRET)\n",
    "sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### How to retrieve single Spotify URI"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "spotify:track:6UelLqGlWMcVH1E5c4H7lY\n"
     ]
    }
   ],
   "source": [
    "artist = 'Harry Styles'\n",
    "track = 'Watermelon sugar'\n",
    "q = 'artist:{} track: {}'.format(artist, track)\n",
    "results = sp.search(q=q, limit=1, type='track')\n",
    "print(results['tracks']['items'][0]['uri'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# it works!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['spotify:track:3YsSrx48KZev7vwh7Q60bW', 'spotify:track:5JiH89mHrv9oWHlD0T326z', 'spotify:track:6UelLqGlWMcVH1E5c4H7lY', 'spotify:track:45S5WTQEGOB1VHr1Q4FuPl', 'spotify:track:4fwbYkgNGj2C8sRYRijbod', 'spotify:track:03mMSLEJCPoGJwQhHpN5y0', 'spotify:track:4zTSNEmvuSKM9dmsZhdXoe', 'spotify:track:4kflIGfjdZJW4ot2ioixTB', 'spotify:track:6SQLk9HSNketfgs2AyIiMs', 'spotify:track:4mhcNoThsVSE1Mpnb7Wnj6', 'spotify:track:4jNQkWhuzqrbqQuqanFFJ6', 'spotify:track:37X505Iu3dYrZGBhbN6kNP', 'spotify:track:54X78diSLoUDI3joC2bjMz', 'spotify:track:3CKCZ9pfwAfoMZlMncA1Nc', 'spotify:track:2vCeiBLcH8GE9glPD6DqDf', 'spotify:track:1Sey4AxNpGoPNnBPszy8TE', 'spotify:track:69YDupexPCFwKmEVejktZ5', 'spotify:track:1IF5UcqRO42D12vYwceOY6', 'spotify:track:33SNO8AaciGbNaQFkxvPrW', 'spotify:track:5kRPPEWFJIMox5qIkQkiz5', 'spotify:track:0OvunixTw2i118Pkwm7l2K', 'spotify:track:0PpiaOdNaP2LehDMo1yeKi', 'spotify:track:3zz4oi4aiOUV6lcQfKP5pU', 'spotify:track:0POoXCqMIUul7VVH8SfjWV', 'spotify:track:1MEVq5Th4tyT93iOs9uUiX', 'spotify:track:6WC1yCqmFG0Uy4Hc4bsgQ1', 'spotify:track:2eK25uxRzhSbm3J9D77rCR', 'spotify:track:4rS7EC8tR4mR2ZmDwGzqYw', 'spotify:track:5uaoc1ImgNE5QR9GJ3XZFt', 'spotify:track:6IUPA3Wm6UL9uKGEEVCT38', 'spotify:track:0JFy8vibEvoRAXYQRZWfOJ', 'spotify:track:44gBofMgplbG0f1XQwTraO', 'spotify:track:5Wcz0MyZQa7tgPu62WMqzl', 'spotify:track:2VxeLyX666F8uXCJ0dZF8B', 'spotify:track:3pCgIUkmRHKydu9HE03QKY', 'spotify:track:2y4PSWPjzw72KOxIFArn9b', 'spotify:track:5jSz894ljfWE0IcHBSM39i']\n"
     ]
    }
   ],
   "source": [
    "    saved_uris = []\n",
    "    artist_names = df['artist'].values\n",
    "    track_names = df['track'].values\n",
    "    \n",
    "    for i in range(len(artist_names)):\n",
    "        artist = artist_names[i]\n",
    "        track = track_names[i]\n",
    "        q = 'artist:{} track: {}'.format(artist, track)\n",
    "        results = sp.search(q=q, limit=1, type='track')\n",
    "        uri = results['tracks']['items'][0]['uri']\n",
    "        saved_uris.append(uri)\n",
    "        \n",
    "    print(saved_uris)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['spotify:track:3YsSrx48KZev7vwh7Q60bW',\n",
       " 'spotify:track:5JiH89mHrv9oWHlD0T326z',\n",
       " 'spotify:track:6UelLqGlWMcVH1E5c4H7lY',\n",
       " 'spotify:track:45S5WTQEGOB1VHr1Q4FuPl',\n",
       " 'spotify:track:4fwbYkgNGj2C8sRYRijbod',\n",
       " 'spotify:track:03mMSLEJCPoGJwQhHpN5y0',\n",
       " 'spotify:track:4zTSNEmvuSKM9dmsZhdXoe',\n",
       " 'spotify:track:4kflIGfjdZJW4ot2ioixTB',\n",
       " 'spotify:track:6SQLk9HSNketfgs2AyIiMs',\n",
       " 'spotify:track:4mhcNoThsVSE1Mpnb7Wnj6',\n",
       " 'spotify:track:4jNQkWhuzqrbqQuqanFFJ6',\n",
       " 'spotify:track:37X505Iu3dYrZGBhbN6kNP',\n",
       " 'spotify:track:54X78diSLoUDI3joC2bjMz',\n",
       " 'spotify:track:3CKCZ9pfwAfoMZlMncA1Nc',\n",
       " 'spotify:track:2vCeiBLcH8GE9glPD6DqDf',\n",
       " 'spotify:track:1Sey4AxNpGoPNnBPszy8TE',\n",
       " 'spotify:track:69YDupexPCFwKmEVejktZ5',\n",
       " 'spotify:track:1IF5UcqRO42D12vYwceOY6',\n",
       " 'spotify:track:33SNO8AaciGbNaQFkxvPrW',\n",
       " 'spotify:track:5kRPPEWFJIMox5qIkQkiz5',\n",
       " 'spotify:track:0OvunixTw2i118Pkwm7l2K',\n",
       " 'spotify:track:0PpiaOdNaP2LehDMo1yeKi',\n",
       " 'spotify:track:3zz4oi4aiOUV6lcQfKP5pU',\n",
       " 'spotify:track:0POoXCqMIUul7VVH8SfjWV',\n",
       " 'spotify:track:1MEVq5Th4tyT93iOs9uUiX',\n",
       " 'spotify:track:6WC1yCqmFG0Uy4Hc4bsgQ1',\n",
       " 'spotify:track:2eK25uxRzhSbm3J9D77rCR',\n",
       " 'spotify:track:4rS7EC8tR4mR2ZmDwGzqYw',\n",
       " 'spotify:track:5uaoc1ImgNE5QR9GJ3XZFt',\n",
       " 'spotify:track:6IUPA3Wm6UL9uKGEEVCT38',\n",
       " 'spotify:track:0JFy8vibEvoRAXYQRZWfOJ',\n",
       " 'spotify:track:44gBofMgplbG0f1XQwTraO',\n",
       " 'spotify:track:5Wcz0MyZQa7tgPu62WMqzl',\n",
       " 'spotify:track:2VxeLyX666F8uXCJ0dZF8B',\n",
       " 'spotify:track:3pCgIUkmRHKydu9HE03QKY',\n",
       " 'spotify:track:2y4PSWPjzw72KOxIFArn9b',\n",
       " 'spotify:track:5jSz894ljfWE0IcHBSM39i']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "saved_uris"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n",
      "append\n"
     ]
    }
   ],
   "source": [
    "    artist = []\n",
    "    track = []\n",
    "    \n",
    "    danceability = []\n",
    "    energy = []\n",
    "    key = []\n",
    "    loudness = []\n",
    "    mode = []\n",
    "    speechiness = []\n",
    "    acousticness = []\n",
    "    instrumentalness = []\n",
    "    liveness = []\n",
    "    valence = []\n",
    "    tempo = []\n",
    "    duration_ms = []\n",
    "\n",
    "    for uri in saved_uris:\n",
    "        x = sp.audio_features(uri)\n",
    "        y = sp.track(uri)\n",
    "        for audio_features in x:\n",
    "            danceability.append(audio_features['danceability'])\n",
    "            energy.append(audio_features['energy'])\n",
    "            key.append(audio_features['key'])\n",
    "            loudness.append(audio_features['loudness'])\n",
    "            mode.append(audio_features['mode'])\n",
    "            speechiness.append(audio_features['speechiness'])\n",
    "            acousticness.append(audio_features['acousticness'])\n",
    "            instrumentalness.append(audio_features['instrumentalness'])\n",
    "            liveness.append(audio_features['liveness'])\n",
    "            valence.append(audio_features['valence'])\n",
    "            tempo.append(audio_features['tempo'])\n",
    "            duration_ms.append(audio_features['duration_ms'])\n",
    "            print('append')\n",
    "      \n",
    "        artist.append(y['album']['artists'][0]['name'])\n",
    "        track.append(y['name'])\n",
    "\n",
    "    df1 = pd.DataFrame()\n",
    "    df1['artist'] = artist\n",
    "    df1['track'] = track\n",
    "    df1['danceability'] = danceability\n",
    "    df1['energy'] = energy\n",
    "    df1['key'] = key\n",
    "    df1['loudness'] = loudness\n",
    "    df1['mode'] = mode\n",
    "    df1['speechiness'] = speechiness\n",
    "    df1['acousticness'] = acousticness\n",
    "    df1['instrumentalness'] = instrumentalness\n",
    "    df1['liveness'] = liveness\n",
    "    df1['valence'] = valence\n",
    "    df1['tempo'] = tempo\n",
    "    df1['duration_ms'] = duration_ms\n",
    "    \n",
    "    df1.to_csv('OnelateAudioFeatures.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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</th>\n",
       "      <th>track</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>instrumentalness</th>\n",
       "      <th>liveness</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>La vuelta</td>\n",
       "      <td>0.521</td>\n",
       "      <td>0.436</td>\n",
       "      <td>8</td>\n",
       "      <td>-7.263</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0260</td>\n",
       "      <td>0.726000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0946</td>\n",
       "      <td>0.2960</td>\n",
       "      <td>63.390</td>\n",
       "      <td>182531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>To Be So Lonely</td>\n",
       "      <td>0.758</td>\n",
       "      <td>0.436</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.269</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0418</td>\n",
       "      <td>0.618000</td>\n",
       "      <td>0.000016</td>\n",
       "      <td>0.3350</td>\n",
       "      <td>0.6050</td>\n",
       "      <td>104.959</td>\n",
       "      <td>192080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Watermelon Sugar</td>\n",
       "      <td>0.548</td>\n",
       "      <td>0.816</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.209</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0465</td>\n",
       "      <td>0.122000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3350</td>\n",
       "      <td>0.5570</td>\n",
       "      <td>95.390</td>\n",
       "      <td>174000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Golden</td>\n",
       "      <td>0.448</td>\n",
       "      <td>0.838</td>\n",
       "      <td>4</td>\n",
       "      <td>-5.257</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0557</td>\n",
       "      <td>0.210000</td>\n",
       "      <td>0.000131</td>\n",
       "      <td>0.1310</td>\n",
       "      <td>0.2540</td>\n",
       "      <td>139.863</td>\n",
       "      <td>208907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Tú Mandas</td>\n",
       "      <td>0.643</td>\n",
       "      <td>0.834</td>\n",
       "      <td>11</td>\n",
       "      <td>-10.542</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0376</td>\n",
       "      <td>0.243000</td>\n",
       "      <td>0.000050</td>\n",
       "      <td>0.1230</td>\n",
       "      <td>0.5540</td>\n",
       "      <td>128.829</td>\n",
       "      <td>190204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Treat People With Kindness</td>\n",
       "      <td>0.653</td>\n",
       "      <td>0.869</td>\n",
       "      <td>5</td>\n",
       "      <td>-3.725</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0382</td>\n",
       "      <td>0.128000</td>\n",
       "      <td>0.000022</td>\n",
       "      <td>0.0460</td>\n",
       "      <td>0.6970</td>\n",
       "      <td>122.017</td>\n",
       "      <td>197347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>Conduciendo y Llorando</td>\n",
       "      <td>0.571</td>\n",
       "      <td>0.730</td>\n",
       "      <td>9</td>\n",
       "      <td>-7.381</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0578</td>\n",
       "      <td>0.067700</td>\n",
       "      <td>0.000057</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0.3060</td>\n",
       "      <td>130.583</td>\n",
       "      <td>210452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>0.559</td>\n",
       "      <td>0.330</td>\n",
       "      <td>9</td>\n",
       "      <td>-8.251</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0285</td>\n",
       "      <td>0.892000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0975</td>\n",
       "      <td>0.2850</td>\n",
       "      <td>135.109</td>\n",
       "      <td>285040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>She</td>\n",
       "      <td>0.535</td>\n",
       "      <td>0.521</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.942</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0272</td>\n",
       "      <td>0.000532</td>\n",
       "      <td>0.371000</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>0.4570</td>\n",
       "      <td>140.026</td>\n",
       "      <td>362653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>John Legend</td>\n",
       "      <td>God Only Knows (feat. yMusic)</td>\n",
       "      <td>0.272</td>\n",
       "      <td>0.158</td>\n",
       "      <td>9</td>\n",
       "      <td>-9.829</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>0.943000</td>\n",
       "      <td>0.000076</td>\n",
       "      <td>0.1580</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>83.385</td>\n",
       "      <td>201800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Maxence Cyrin</td>\n",
       "      <td>Where Is My Mind</td>\n",
       "      <td>0.333</td>\n",
       "      <td>0.114</td>\n",
       "      <td>9</td>\n",
       "      <td>-21.255</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0453</td>\n",
       "      <td>0.906000</td>\n",
       "      <td>0.960000</td>\n",
       "      <td>0.1190</td>\n",
       "      <td>0.0566</td>\n",
       "      <td>141.839</td>\n",
       "      <td>165160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Various Artists</td>\n",
       "      <td>Leyenda</td>\n",
       "      <td>0.429</td>\n",
       "      <td>0.963</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.945</td>\n",
       "      <td>1</td>\n",
       "      <td>0.3990</td>\n",
       "      <td>0.504000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0831</td>\n",
       "      <td>0.4850</td>\n",
       "      <td>92.444</td>\n",
       "      <td>199567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Prince</td>\n",
       "      <td>Purple Rain</td>\n",
       "      <td>0.367</td>\n",
       "      <td>0.452</td>\n",
       "      <td>10</td>\n",
       "      <td>-10.422</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0307</td>\n",
       "      <td>0.035300</td>\n",
       "      <td>0.002280</td>\n",
       "      <td>0.6890</td>\n",
       "      <td>0.1890</td>\n",
       "      <td>113.066</td>\n",
       "      <td>520787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Set Fire to the Rain</td>\n",
       "      <td>0.610</td>\n",
       "      <td>0.683</td>\n",
       "      <td>2</td>\n",
       "      <td>-3.879</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0253</td>\n",
       "      <td>0.003820</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.1250</td>\n",
       "      <td>0.4660</td>\n",
       "      <td>108.003</td>\n",
       "      <td>241693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Erika Jayne</td>\n",
       "      <td>How Many Fucks?</td>\n",
       "      <td>0.716</td>\n",
       "      <td>0.944</td>\n",
       "      <td>1</td>\n",
       "      <td>-3.418</td>\n",
       "      <td>1</td>\n",
       "      <td>0.2680</td>\n",
       "      <td>0.238000</td>\n",
       "      <td>0.000014</td>\n",
       "      <td>0.1330</td>\n",
       "      <td>0.6240</td>\n",
       "      <td>180.966</td>\n",
       "      <td>197723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Feten Feten</td>\n",
       "      <td>Límite</td>\n",
       "      <td>0.461</td>\n",
       "      <td>0.736</td>\n",
       "      <td>4</td>\n",
       "      <td>-7.494</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0479</td>\n",
       "      <td>0.369000</td>\n",
       "      <td>0.001170</td>\n",
       "      <td>0.3160</td>\n",
       "      <td>0.7260</td>\n",
       "      <td>112.078</td>\n",
       "      <td>230828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Guitarricadelafuente</td>\n",
       "      <td>El Conticinio</td>\n",
       "      <td>0.629</td>\n",
       "      <td>0.106</td>\n",
       "      <td>4</td>\n",
       "      <td>-22.447</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0535</td>\n",
       "      <td>0.916000</td>\n",
       "      <td>0.000006</td>\n",
       "      <td>0.1080</td>\n",
       "      <td>0.1810</td>\n",
       "      <td>110.049</td>\n",
       "      <td>213994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>From the Dining Table</td>\n",
       "      <td>0.671</td>\n",
       "      <td>0.156</td>\n",
       "      <td>8</td>\n",
       "      <td>-16.288</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0371</td>\n",
       "      <td>0.804000</td>\n",
       "      <td>0.051800</td>\n",
       "      <td>0.1130</td>\n",
       "      <td>0.2010</td>\n",
       "      <td>94.080</td>\n",
       "      <td>211960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Kiwi</td>\n",
       "      <td>0.375</td>\n",
       "      <td>0.930</td>\n",
       "      <td>2</td>\n",
       "      <td>-2.631</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0561</td>\n",
       "      <td>0.000640</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.3180</td>\n",
       "      <td>0.4910</td>\n",
       "      <td>147.124</td>\n",
       "      <td>176387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Harry Styles</td>\n",
       "      <td>Sweet Creature</td>\n",
       "      <td>0.427</td>\n",
       "      <td>0.262</td>\n",
       "      <td>7</td>\n",
       "      <td>-8.541</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0276</td>\n",
       "      <td>0.746000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0680</td>\n",
       "      <td>0.2280</td>\n",
       "      <td>104.085</td>\n",
       "      <td>224867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>¡Yep! - Versión 50 Palos</td>\n",
       "      <td>0.827</td>\n",
       "      <td>0.494</td>\n",
       "      <td>5</td>\n",
       "      <td>-5.826</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0329</td>\n",
       "      <td>0.548000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2380</td>\n",
       "      <td>0.6360</td>\n",
       "      <td>142.991</td>\n",
       "      <td>180242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Déjame Vivir - Versión 50 Palos</td>\n",
       "      <td>0.401</td>\n",
       "      <td>0.326</td>\n",
       "      <td>9</td>\n",
       "      <td>-6.997</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>0.707000</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.0998</td>\n",
       "      <td>0.3240</td>\n",
       "      <td>120.183</td>\n",
       "      <td>208934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Grita</td>\n",
       "      <td>0.490</td>\n",
       "      <td>0.694</td>\n",
       "      <td>4</td>\n",
       "      <td>-7.770</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0463</td>\n",
       "      <td>0.064500</td>\n",
       "      <td>0.000066</td>\n",
       "      <td>0.1060</td>\n",
       "      <td>0.2920</td>\n",
       "      <td>200.064</td>\n",
       "      <td>212227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Grita - Versión Filarmónica</td>\n",
       "      <td>0.482</td>\n",
       "      <td>0.382</td>\n",
       "      <td>7</td>\n",
       "      <td>-6.870</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0262</td>\n",
       "      <td>0.508000</td>\n",
       "      <td>0.000320</td>\n",
       "      <td>0.1160</td>\n",
       "      <td>0.2460</td>\n",
       "      <td>89.710</td>\n",
       "      <td>226734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Hombrecitos</td>\n",
       "      <td>0.655</td>\n",
       "      <td>0.765</td>\n",
       "      <td>6</td>\n",
       "      <td>-5.150</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0378</td>\n",
       "      <td>0.456000</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.1090</td>\n",
       "      <td>0.9250</td>\n",
       "      <td>190.087</td>\n",
       "      <td>217520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Hoy No Soy Yo - Versión 50 Palos</td>\n",
       "      <td>0.535</td>\n",
       "      <td>0.302</td>\n",
       "      <td>7</td>\n",
       "      <td>-6.180</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0349</td>\n",
       "      <td>0.911000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0954</td>\n",
       "      <td>0.3820</td>\n",
       "      <td>146.883</td>\n",
       "      <td>200066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>La Vida Es el Momento</td>\n",
       "      <td>0.720</td>\n",
       "      <td>0.836</td>\n",
       "      <td>7</td>\n",
       "      <td>-4.937</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>0.047800</td>\n",
       "      <td>0.000008</td>\n",
       "      <td>0.0566</td>\n",
       "      <td>0.9430</td>\n",
       "      <td>122.960</td>\n",
       "      <td>186640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Me Flechaste Ingrata</td>\n",
       "      <td>0.803</td>\n",
       "      <td>0.733</td>\n",
       "      <td>2</td>\n",
       "      <td>-5.256</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0306</td>\n",
       "      <td>0.397000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.7650</td>\n",
       "      <td>129.984</td>\n",
       "      <td>204338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Misteriosamente Hoy</td>\n",
       "      <td>0.651</td>\n",
       "      <td>0.886</td>\n",
       "      <td>9</td>\n",
       "      <td>-4.900</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0313</td>\n",
       "      <td>0.081800</td>\n",
       "      <td>0.000458</td>\n",
       "      <td>0.1770</td>\n",
       "      <td>0.5550</td>\n",
       "      <td>145.067</td>\n",
       "      <td>185898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Que Bueno - Versión 50 Palos</td>\n",
       "      <td>0.512</td>\n",
       "      <td>0.557</td>\n",
       "      <td>2</td>\n",
       "      <td>-6.788</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>0.451000</td>\n",
       "      <td>0.038700</td>\n",
       "      <td>0.0668</td>\n",
       "      <td>0.5530</td>\n",
       "      <td>94.780</td>\n",
       "      <td>214876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Jarabe De Palo</td>\n",
       "      <td>Tragas o Escupes</td>\n",
       "      <td>0.756</td>\n",
       "      <td>0.896</td>\n",
       "      <td>7</td>\n",
       "      <td>-4.262</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0435</td>\n",
       "      <td>0.205000</td>\n",
       "      <td>0.000013</td>\n",
       "      <td>0.0571</td>\n",
       "      <td>0.9630</td>\n",
       "      <td>95.006</td>\n",
       "      <td>192652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Joy Crookes</td>\n",
       "      <td>Darkest Hour</td>\n",
       "      <td>0.747</td>\n",
       "      <td>0.590</td>\n",
       "      <td>11</td>\n",
       "      <td>-6.883</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0857</td>\n",
       "      <td>0.388000</td>\n",
       "      <td>0.000095</td>\n",
       "      <td>0.1210</td>\n",
       "      <td>0.6620</td>\n",
       "      <td>120.998</td>\n",
       "      <td>216172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>La Maravillosa Orquesta del Alcohol</td>\n",
       "      <td>Héroes del Sábado</td>\n",
       "      <td>0.531</td>\n",
       "      <td>0.686</td>\n",
       "      <td>10</td>\n",
       "      <td>-6.309</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.263000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0975</td>\n",
       "      <td>0.3160</td>\n",
       "      <td>135.970</td>\n",
       "      <td>244767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Shallow</td>\n",
       "      <td>0.572</td>\n",
       "      <td>0.385</td>\n",
       "      <td>7</td>\n",
       "      <td>-6.362</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0308</td>\n",
       "      <td>0.371000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2310</td>\n",
       "      <td>0.3230</td>\n",
       "      <td>95.799</td>\n",
       "      <td>215733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Various Artists</td>\n",
       "      <td>Remember Me (Dúo)</td>\n",
       "      <td>0.611</td>\n",
       "      <td>0.553</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.681</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0328</td>\n",
       "      <td>0.415000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.4970</td>\n",
       "      <td>0.5730</td>\n",
       "      <td>84.996</td>\n",
       "      <td>164453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Morgan</td>\n",
       "      <td>Volver - Bonus Track</td>\n",
       "      <td>0.578</td>\n",
       "      <td>0.117</td>\n",
       "      <td>10</td>\n",
       "      <td>-13.018</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0323</td>\n",
       "      <td>0.951000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.1020</td>\n",
       "      <td>0.4550</td>\n",
       "      <td>103.167</td>\n",
       "      <td>148422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Prince</td>\n",
       "      <td>Raspberry Beret</td>\n",
       "      <td>0.761</td>\n",
       "      <td>0.670</td>\n",
       "      <td>2</td>\n",
       "      <td>-12.759</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0438</td>\n",
       "      <td>0.210000</td>\n",
       "      <td>0.000426</td>\n",
       "      <td>0.0685</td>\n",
       "      <td>0.9100</td>\n",
       "      <td>120.752</td>\n",
       "      <td>215173</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 artist                             track  \\\n",
       "0   La Maravillosa Orquesta del Alcohol                         La vuelta   \n",
       "1                          Harry Styles                   To Be So Lonely   \n",
       "2                          Harry Styles                  Watermelon Sugar   \n",
       "3                          Harry Styles                            Golden   \n",
       "4                        Jarabe De Palo                         Tú Mandas   \n",
       "5                          Harry Styles        Treat People With Kindness   \n",
       "6   La Maravillosa Orquesta del Alcohol            Conduciendo y Llorando   \n",
       "7                                 Adele                  Someone Like You   \n",
       "8                          Harry Styles                               She   \n",
       "9                           John Legend     God Only Knows (feat. yMusic)   \n",
       "10                        Maxence Cyrin                  Where Is My Mind   \n",
       "11                      Various Artists                           Leyenda   \n",
       "12                               Prince                       Purple Rain   \n",
       "13                                Adele              Set Fire to the Rain   \n",
       "14                          Erika Jayne                   How Many Fucks?   \n",
       "15                          Feten Feten                            Límite   \n",
       "16                 Guitarricadelafuente                     El Conticinio   \n",
       "17                         Harry Styles             From the Dining Table   \n",
       "18                         Harry Styles                              Kiwi   \n",
       "19                         Harry Styles                    Sweet Creature   \n",
       "20                       Jarabe De Palo          ¡Yep! - Versión 50 Palos   \n",
       "21                       Jarabe De Palo   Déjame Vivir - Versión 50 Palos   \n",
       "22                       Jarabe De Palo                             Grita   \n",
       "23                       Jarabe De Palo       Grita - Versión Filarmónica   \n",
       "24                       Jarabe De Palo                       Hombrecitos   \n",
       "25                       Jarabe De Palo  Hoy No Soy Yo - Versión 50 Palos   \n",
       "26                       Jarabe De Palo             La Vida Es el Momento   \n",
       "27                       Jarabe De Palo              Me Flechaste Ingrata   \n",
       "28                       Jarabe De Palo               Misteriosamente Hoy   \n",
       "29                       Jarabe De Palo      Que Bueno - Versión 50 Palos   \n",
       "30                       Jarabe De Palo                  Tragas o Escupes   \n",
       "31                          Joy Crookes                      Darkest Hour   \n",
       "32  La Maravillosa Orquesta del Alcohol                 Héroes del Sábado   \n",
       "33                            Lady Gaga                           Shallow   \n",
       "34                      Various Artists                 Remember Me (Dúo)   \n",
       "35                               Morgan              Volver - Bonus Track   \n",
       "36                               Prince                   Raspberry Beret   \n",
       "\n",
       "    danceability  energy  key  loudness  mode  speechiness  acousticness  \\\n",
       "0          0.521   0.436    8    -7.263     0       0.0260      0.726000   \n",
       "1          0.758   0.436    0    -7.269     1       0.0418      0.618000   \n",
       "2          0.548   0.816    0    -4.209     1       0.0465      0.122000   \n",
       "3          0.448   0.838    4    -5.257     0       0.0557      0.210000   \n",
       "4          0.643   0.834   11   -10.542     1       0.0376      0.243000   \n",
       "5          0.653   0.869    5    -3.725     1       0.0382      0.128000   \n",
       "6          0.571   0.730    9    -7.381     0       0.0578      0.067700   \n",
       "7          0.559   0.330    9    -8.251     1       0.0285      0.892000   \n",
       "8          0.535   0.521    0    -5.942     1       0.0272      0.000532   \n",
       "9          0.272   0.158    9    -9.829     1       0.0319      0.943000   \n",
       "10         0.333   0.114    9   -21.255     1       0.0453      0.906000   \n",
       "11         0.429   0.963    0    -3.945     1       0.3990      0.504000   \n",
       "12         0.367   0.452   10   -10.422     1       0.0307      0.035300   \n",
       "13         0.610   0.683    2    -3.879     0       0.0253      0.003820   \n",
       "14         0.716   0.944    1    -3.418     1       0.2680      0.238000   \n",
       "15         0.461   0.736    4    -7.494     0       0.0479      0.369000   \n",
       "16         0.629   0.106    4   -22.447     1       0.0535      0.916000   \n",
       "17         0.671   0.156    8   -16.288     1       0.0371      0.804000   \n",
       "18         0.375   0.930    2    -2.631     1       0.0561      0.000640   \n",
       "19         0.427   0.262    7    -8.541     1       0.0276      0.746000   \n",
       "20         0.827   0.494    5    -5.826     1       0.0329      0.548000   \n",
       "21         0.401   0.326    9    -6.997     0       0.0319      0.707000   \n",
       "22         0.490   0.694    4    -7.770     0       0.0463      0.064500   \n",
       "23         0.482   0.382    7    -6.870     1       0.0262      0.508000   \n",
       "24         0.655   0.765    6    -5.150     0       0.0378      0.456000   \n",
       "25         0.535   0.302    7    -6.180     1       0.0349      0.911000   \n",
       "26         0.720   0.836    7    -4.937     1       0.0319      0.047800   \n",
       "27         0.803   0.733    2    -5.256     0       0.0306      0.397000   \n",
       "28         0.651   0.886    9    -4.900     1       0.0313      0.081800   \n",
       "29         0.512   0.557    2    -6.788     1       0.1500      0.451000   \n",
       "30         0.756   0.896    7    -4.262     1       0.0435      0.205000   \n",
       "31         0.747   0.590   11    -6.883     0       0.0857      0.388000   \n",
       "32         0.531   0.686   10    -6.309     1       0.0359      0.263000   \n",
       "33         0.572   0.385    7    -6.362     1       0.0308      0.371000   \n",
       "34         0.611   0.553    0    -6.681     1       0.0328      0.415000   \n",
       "35         0.578   0.117   10   -13.018     1       0.0323      0.951000   \n",
       "36         0.761   0.670    2   -12.759     1       0.0438      0.210000   \n",
       "\n",
       "    instrumentalness  liveness  valence    tempo  duration_ms  \n",
       "0           0.000000    0.0946   0.2960   63.390       182531  \n",
       "1           0.000016    0.3350   0.6050  104.959       192080  \n",
       "2           0.000000    0.3350   0.5570   95.390       174000  \n",
       "3           0.000131    0.1310   0.2540  139.863       208907  \n",
       "4           0.000050    0.1230   0.5540  128.829       190204  \n",
       "5           0.000022    0.0460   0.6970  122.017       197347  \n",
       "6           0.000057    0.3600   0.3060  130.583       210452  \n",
       "7           0.000000    0.0975   0.2850  135.109       285040  \n",
       "8           0.371000    0.1900   0.4570  140.026       362653  \n",
       "9           0.000076    0.1580   0.2400   83.385       201800  \n",
       "10          0.960000    0.1190   0.0566  141.839       165160  \n",
       "11          0.000000    0.0831   0.4850   92.444       199567  \n",
       "12          0.002280    0.6890   0.1890  113.066       520787  \n",
       "13          0.000002    0.1250   0.4660  108.003       241693  \n",
       "14          0.000014    0.1330   0.6240  180.966       197723  \n",
       "15          0.001170    0.3160   0.7260  112.078       230828  \n",
       "16          0.000006    0.1080   0.1810  110.049       213994  \n",
       "17          0.051800    0.1130   0.2010   94.080       211960  \n",
       "18          0.000000    0.3180   0.4910  147.124       176387  \n",
       "19          0.000000    0.0680   0.2280  104.085       224867  \n",
       "20          0.000000    0.2380   0.6360  142.991       180242  \n",
       "21          0.000030    0.0998   0.3240  120.183       208934  \n",
       "22          0.000066    0.1060   0.2920  200.064       212227  \n",
       "23          0.000320    0.1160   0.2460   89.710       226734  \n",
       "24          0.000012    0.1090   0.9250  190.087       217520  \n",
       "25          0.000000    0.0954   0.3820  146.883       200066  \n",
       "26          0.000008    0.0566   0.9430  122.960       186640  \n",
       "27          0.000003    0.1100   0.7650  129.984       204338  \n",
       "28          0.000458    0.1770   0.5550  145.067       185898  \n",
       "29          0.038700    0.0668   0.5530   94.780       214876  \n",
       "30          0.000013    0.0571   0.9630   95.006       192652  \n",
       "31          0.000095    0.1210   0.6620  120.998       216172  \n",
       "32          0.000000    0.0975   0.3160  135.970       244767  \n",
       "33          0.000000    0.2310   0.3230   95.799       215733  \n",
       "34          0.000000    0.4970   0.5730   84.996       164453  \n",
       "35          0.000000    0.1020   0.4550  103.167       148422  \n",
       "36          0.000426    0.0685   0.9100  120.752       215173  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2=df1.head(6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA00AAAFBCAYAAACrXkR+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3de5xVZb348c93ZhgHkJsgCIKppXlFUsCSk9EpJbO00qSLlqbZTT3lT8vqVJpWntPFysz0aCexk6LWUStLs2N5L1ARRRONMBEQGLkPMLfn98daM2zHmcUenM2M+nm/XrzY6/bs77PXmrXWdz3PWitSSkiSJEmSOlfV2wFIkiRJUl9m0iRJkiRJBUyaJEmSJKmASZMkSZIkFTBpkiRJkqQCJk2SJEmSVKBiSVNE/DQilkXEo11Mj4j4YUQ8FRFzI+LASsUiSZIkSVurki1NPwPeUTD9CGCP/N+pwKUVjEWSJEmStkrFkqaU0p3A8wWzHA3MSJn7gaERMbpS8UiSJEnS1ujNe5p2Bp4pGV6Uj5MkSZKkPqOmF787OhmXOp0x4lSyLnwMGDjwoN12351+NTW0NLfQSmK7fv3Y1NREdVUVATS3tlJbU0NTczMA/fr1ozGfDtDS2kptv340NTVl02tqaGxupqaqipRPbyuziqC6ppqm5mZqqqtJrYmWVDI9gurqzdNbW1tpTekF06uqqmhuaclibml5wfTqqCKqYvN062SdrJN1sk7WyTpZJ+tknazTS6rTvEceWZFS2pEe0ptJ0yJgXMnwWGBxZzOmlC4HLgeYOHFimj17duWjkyRJkvSyFBFP92R5vdk972bgI/lT9N4IrE4pLenFeCRJkiTpRSrW0hQR1wBTgRERsQj4GtAPIKX0E+AW4J3AU0ADcFKlYpEkSZKkrVWxpCml9MEtTE/AZyr1/ZIkSZLUE3rzniZJkiSpT2hqamLRokVs3Lixt0NRN9TV1TF27Fj69etX0e8xaZIkSdKr3qJFixg0aBC77rorEZ095Fl9TUqJ+vp6Fi1axG677VbR7+rNB0FIkiRJfcLGjRsZPny4CdPLSEQwfPjwbdI6aNIkSZIkgQnTy9C2WmcmTZIkSVIfUF1dzYQJE9h333054IAD+N73vkdra2uvxrRw4UL222+/TqedcsopPPbYYwDsuuuurFixAoBDDjmkfdlf/OIX3fq+e+65h/HjxzNp0iSeeuopAFatWsW0adPIniPXO0yaJEmSpA6ih/+Vo3///syZM4d58+bxhz/8gVtuuYXzzjuv5yrVw6644gr22WefF42/9957ga1Lmr773e/yy1/+km9+85tceumlAJx//vl86Utf6tWWQJMmSZIkqY8ZOXIkl19+OT/60Y9IKbFw4ULe/OY3c+CBB3LggQe2JyZ/+tOfmDp1Ksceeyx77bUXH/7wh9tbZGbNmsUhhxzCAQccwOTJk1m7di0tLS2cffbZTJo0ifHjx3PZZZcBsG7dOt72trdx4IEHsv/++3PTTTe1x9Lc3MxHP/pRxo8fz7HHHktDQwMAU6dOZfbs2S+KffvttwfgnHPO4a677mLChAlcdNFFvPnNb2bOnDnt802ZMoW5c+e+YNl+/fqxYcMGGhoa6NevH3//+9959tlnectb3tKDv273+fQ8SZIkqQ/afffdaW1tZdmyZYwcOZI//OEP1NXV8eSTT/LBD36wPWF56KGHmDdvHmPGjGHKlCncc889TJ48menTpzNz5kwmTZrEmjVr6N+/P1deeSVDhgxh1qxZbNq0iSlTpnD44Yczbtw4/vd//5fBgwezYsUK3vjGN3LUUUcB8MQTT3DllVcyZcoUPvaxj/HjH/+Ys846a4vxX3jhhXznO9/hN7/5DQA77LADP/vZz/j+97/P/Pnz2bRpE+PHj3/BMl/84hc59dRT6d+/P1dffTVnnXUW559/fg//st1nS5MkSZLUR7W1GjU1NfHxj3+c/fffn/e///3t9xIBTJ48mbFjx1JVVcWECRNYuHAhTzzxBKNHj2bSpEkADB48mJqaGm677TZmzJjBhAkTOPjgg6mvr+fJJ58kpcSXvvQlxo8fz9vf/naeffZZnnvuOQDGjRvHlClTADj++OO5++67t6ou73//+/nNb35DU1MTP/3pTznxxBNfNM+ECRO4//77ueOOO1iwYAFjxowhpcT06dM5/vjj22Pa1mxpkiRJkvqgBQsWUF1dzciRIznvvPMYNWoUDz/8MK2trdTV1bXPt91227V/rq6uprm5mZRSp/cApZS4+OKLmTZt2gvG/+xnP2P58uU88MAD9OvXj1133bX9Ud4dy9nae4sGDBjAYYcdxk033cR1113Xade+0jgvuOACZs6cyWmnncZ5553HwoUL+eEPf8g3vvGNrfr+l8KWJkmSJKmPWb58OZ/85Cc57bTTiAhWr17N6NGjqaqq4uqrr6alpaVw+b322ovFixcza9YsANauXUtzczPTpk3j0ksvpampCYD58+ezfv16Vq9ezciRI+nXrx933HEHTz/9dHtZ//znP7nvvvsAuOaaa/iXf/mXsuowaNAg1q5d+4Jxp5xyCmeccQaTJk1ihx126HLZq666iiOPPJJhw4bR0NBAVVUVVVVV7fdTbWu2NEmSJEl9wIYNG5gwYQJNTU3U1NRwwgkncOaZZwLw6U9/mmOOOYbrr7+et771rQwcOLCwrNraWmbOnMnpp5/Ohg0b6N+/P7fffjunnHIKCxcu5MADDySlxI477siNN97Ihz/8Yd797nczceJEJkyYwF577dVe1t57781VV13FJz7xCfbYYw8+9alPlVWf8ePHU1NTwwEHHMCJJ57I5z73OQ466CAGDx7MSSed1OVyDQ0NXHXVVdx2220AnHnmmRxzzDHU1tZyzTXXlPXdPS1683nnW2PixImpqClPkiRJ6q7HH3+cvffeu7fDeMVbvHgxU6dO5W9/+xtVVT3T6a2zdRcRD6SUJvbIF2D3PEmSJEnbwIwZMzj44IP5xje+0WMJ07Zi9zxJkiRJFfeRj3yEj3zkI70dxlZ5eaV4kiRJkrSNmTRJkiRJUgGTJkmSJEkqYNIkSZIkSQVMmiRJkqQ+YPvtt3/RuJ/85CfMmDGjF6Ip38UXX8x+++3HO9/5ThobGwG4++67298x9Urg0/MkSZKkDnY957c9Wt7CC4/cquU++clP9mgclXDFFVcwd+5cvvKVr3Drrbfyrne9i/PPP59rr722t0PrMbY0SZIkSX3Uueeey3e+8x0ef/xxJk+e3D5+4cKFjB8/HoAHHniAt7zlLRx00EFMmzaNJUuWADB16lS+8IUvMHnyZPbcc0/uuusuAFpaWjj77LOZNGkS48eP57LLLgNgyZIlHHrooUyYMIH99tuPu+66i5aWFk488UT2228/9t9/fy666KJO42xqaqKhoYF+/fpx9dVX8853vpNhw4ZV8qfZpmxpkiRJkvq4vffem8bGRhYsWMDuu+/OzJkzOe6442hqauL000/npptuYscdd2TmzJl8+ctf5qc//SkAzc3N/PWvf+WWW27hvPPO4/bbb+fKK69kyJAhzJo1i02bNjFlyhQOP/xwfvWrXzFt2jS+/OUv09LSQkNDA3PmzOHZZ5/l0UcfBWDVqlUviu2ss87ijW98I/vuuy9TpkzhPe95D7///e+36e9TaSZNkiRJ0svAcccdx3XXXcc555zDzJkzmTlzJk888QSPPvoohx12GJC1Io0ePbp9mfe9730AHHTQQSxcuBCA2267jblz53LDDTcAsHr1ap588kkmTZrExz72MZqamnjPe97DhAkT2H333VmwYAGnn346Rx55JIcffviL4jrhhBM44YQTADjvvPM444wz+N3vfseMGTMYN24c3/3ud6mqenl3cHt5Ry9JkiS9SkyfPp3rrruO+fPnExHssccepJTYd999mTNnDnPmzOGRRx7htttua19mu+22A6C6uprm5mYAUkpcfPHF7cv84x//4PDDD+fQQw/lzjvvZOedd+aEE05gxowZDBs2jIcffpipU6dyySWXcMopp3QZ3+LFi5k1axZHH300F1xwATNnzmS77bbjj3/8Y2V/mG3ApEmSJEl6GXjta19LdXU1559/PtOnTwfg9a9/PcuXL+e+++4DsnuL5s2bV1jOtGnTuPTSS2lqagJg/vz5rF+/nqeffpqRI0fy8Y9/nJNPPpkHH3yQFStW0NrayjHHHMP555/Pgw8+2GW5X/nKVzj//PMB2LBhAxFBVVUVDQ0NPVH9XmX3PEmSJKkPaGhoYOzYse3DnT2ye/r06Zx99tn84x//AKC2tpYbbriBM844g9WrV9Pc3MxnP/tZ9t133y6/55RTTmHhwoUceOCBpJTYcccdufHGG/nTn/7Et7/9bfr168f222/PjBkzePbZZznppJNobW0F4Fvf+lanZT700EMAvOENbwDg5JNPZv/992fcuHF87Wtf27ofpA+JlFJvx9AtEydOTLNnz+7tMCRJkvQK8vjjj7P33nv3dhjaCp2tu4h4IKU0sae+w+55kiRJklTApEmSJEmSCpg0SZIkSVIBkyZJkiSJ7FHcennZVuvMpEmSJEmvenV1ddTX15s4vYyklKivr6eurq7i3+UjxyVJkvSqN3bsWBYtWsTy5ct7OxR1Q11d3Qse014pJk2SJEl61evXrx+77bZbb4ehPsrueZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKmASZMkSZIkFTBpkiRJkqQCJk2SJEmSVMCkSZIkSZIKmDRJkiRJUoGKJk0R8Y6IeCIinoqIczqZvktE3BERD0XE3Ih4ZyXjkSRJkqTuqljSFBHVwCXAEcA+wAcjYp8Os/07cF1K6Q3AB4AfVyoeSZIkSdoalWxpmgw8lVJakFJqBK4Fju4wTwIG55+HAIsrGI8kSZIkdVtNBcveGXimZHgRcHCHec4FbouI04GBwNs7KygiTgVOBRg7dizzFy5kpxEjeH7Vahqbm9hl9Gj+uWQJgwYOpKa6mpVr1jBm5EiW1dfT2poYM2oki5YuZcj2gwBYvW4tY3faicXPLaOqKhg5fDiLly1j2ODBNLe0sHb9+vYya2v6scPQISxdsYLhQ4eycVMj6zc0tE+vq61lyKBBPFdfz4hhw2jYsIGGjRvbpw+oq2NA//6sWLmSUcOHs3rtWjY2NrZPH9h/AHXb1VK/apV1sk7WyTpZJ+tknayTdbJO1qkH6tTTIqXU44UCRMT7gWkppVPy4ROAySml00vmOTOP4bsR8SbgSmC/lFJrV+VOnDgxzZ49uyIxS5IkSXr5i4gHUkoTe6q8SnbPWwSMKxkey4u7350MXAeQUroPqANGVDAmSZIkSeqWSiZNs4A9ImK3iKgle9DDzR3m+SfwNoCI2JssaVpewZgkSZIkqVsqljSllJqB04BbgcfJnpI3LyK+HhFH5bP9P+DjEfEwcA1wYqpUf0FJkiRJ2gqVfBAEKaVbgFs6jPtqyefHgCmVjEGSJEmSXoqKvtxWkiRJkl7uTJokSZIkqYBJkyRJkiQVMGmSJEmSpAImTZIkSZJUwKRJkiRJkgpU9JHj0qtV9HYAW+DL0CRJkspnS5MkSZIkFTBpkiRJkqQCJk2SJEmSVMCkSZIkSZIKmDRJkiRJUgGTJkmSJEkqYNIkSZIkSQVMmiRJkiSpgEmTJEmSJBUwaZIkSZKkAiZNkiRJklTApEmSJEmSCpg0SZIkSVIBkyZJkiRJKmDSJEmSJEkFTJokSZIkqYBJkyRJkiQVMGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKmASZMkSZIkFTBpkiRJkqQCJk2SJEmSVKCmtwOQJEmStGXR2wFsQertACrIliZJkiRJKmDSJEmSJEkF7J4nSZLUx9gNS+pbbGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKlARZOmiHhHRDwREU9FxDldzHNcRDwWEfMi4heVjEeSJEmSuqtiL7eNiGrgEuAwYBEwKyJuTik9VjLPHsAXgSkppZURMbJS8UiSJEnS1qhkS9Nk4KmU0oKUUiNwLXB0h3k+DlySUloJkFJaVsF4JEmSJKnbKpk07Qw8UzK8KB9Xak9gz4i4JyLuj4h3VDAeSZIkSeq2srvnRUR/YJeU0hPlLtLJuNTJ9+8BTAXGAndFxH4ppVUdvvtU4FSAsWPHMn/hQnYaMYLnV62msbmJXUaP5p9LljBo4EBqqqtZuWYNY0aOZFl9Pa2tiTGjRrJo6VKGbD8IgNXr1jJ2p51Y/NwyqqqCkcOHs3jZMoYNHkxzSwtr169vL7O2ph87DB3C0hUrGD50KBs3NbJ+Q0P79LraWoYMGsRz9fWMGDaMhg0baNi4sX36gLo6BvTvz4qVKxk1fDir165lY2Nj+/SB/QdQt10t9atWWadXUJ0OqK+nujUxf9RI9lq6lOV5nXZct5a/7bQTez63jJaqYOHw4eyxbBnPDR5MTUsLw9ev57HRo9lnyRI21vRj8dAh7L5iBYuHDmXApkaGbmhon95QW8vyQYN4TX09zwwbxtANGxi0cWP79LV1dazq359xK1fy9PDh7Lh2LQMaG3ls9Gjmu56sk3WyTtapT9dpQBn78n2WLGFV/wE0bFfLmFWrWDBiBGNWraauual9ev3AgTRXVzNqzRqeHDmSXXvo+LTG9dQrdZrYR84jutr25veh9dTTIqWOeUwnM0W8G/gOUJtS2i0iJgBfTykdVbDMm4BzU0rT8uEvAqSUvlUyz0+A+1NKP8uH/wick1Ka1VW5EydOTLNnzy6nblKv6eyKQV+y5b96SVJv8jiizrhdlC8iHkgpTeyp8srtnncu2T1KqwBSSnOAXbewzCxgj4jYLSJqgQ8AN3eY50bgrQARMYKsu96CMmOSJEmSpIorN2lqTimt7k7BKaVm4DTgVuBx4LqU0ryI+HpEtLVQ3QrUR8RjwB3A2Smlnm9PkyRJkqStVO49TY9GxIeA6vwx4WcA925poZTSLcAtHcZ9teRzAs7M/0mSJElSn1NuS9PpwL7AJuAaYA3w2UoFJUmSJEl9RVktTSmlBuDL+T9JkiRJetUoK2mKiF/z4gdirAZmA5ellDb2dGCSJEmS1BeU2z1vAbAO+K/83xrgObKn3f1XZUKTJEmSpN5X7oMg3pBSOrRk+NcRcWdK6dCImFeJwCRJkiSpLyi3pWnHiNilbSD/PCIfbOzxqCRJkiSpjyi3pen/AXdHxN/JXka8G/DpiBgIXFWp4CRJkiSpt5X79Lxb8vcz7UWWNP2t5OEP369UcJIkSZLU28ptaQLYA3g9UAeMjwhSSjMqE5YkSZIk9Q3lPnL8a8BUYB/gFuAI4G7ApEmSyhS9HcAWdHyvhCRJypT7IIhjgbcBS1NKJwEHANtVLCpJkiRJ6iPKTZo2pJRageaIGAwsA3avXFiSJEmS1DeUe0/T7IgYSvYi2wfIXnT714pFJUmSJEl9RLlPz/t0/vEnEfF7YHBKaW7lwpIkSZKkvqGs7nkR8ce2zymlhSmluaXjJEmSJOmVqrClKSLqgAHAiIgYxuaHPw0GxlQ4NkmSJEnqdVvqnvcJ4LNkCdIDbE6a1gCXVDCulw0fISxJkiS9shUmTSmlHwA/iIjTU0oXb6OYJEmSJKnPKPdBEBdHxCHArqXLpJR8ua0kSZKkV7SykqaIuBp4LTAHaMlHJ8CkSZIkSdIrWrnvaZoI7JNS8hYZSZIkSa8qZT1yHHgU2KmSgUiSJElSX1RuS9MI4LGI+CuwqW1kSumoikQlSZIkSX1EuUnTuZUMQpIkSZL6qnKfnvfniHgNsEdK6faIGABUVzY0SZIkSep9Zd3TFBEfB24ALstH7QzcWKmgJEmSJKmvKPdBEJ8BpgBrAFJKTwIjKxWUJEmSJPUV5SZNm1JKjW0DEVFD9p4mSZIkSXpFKzdp+nNEfAnoHxGHAdcDv65cWJIkSZLUN5SbNJ0DLAceAT4B3AL8e6WCkiRJkqS+otxHjvcHfppS+i+AiKjOxzVUKjBJkiRJ6gvKbWn6I1mS1KY/cHvPhyNJkiRJfUu5SVNdSmld20D+eUBlQpIkSZKkvqPcpGl9RBzYNhARBwEbKhOSJEmSJPUd5d7T9G/A9RGxOB8eDUyvTEiSJEmS1HdsMWmKiCqgFtgLeD0QwN9SSk0Vjk2SJEmSet0Wk6aUUmtEfDel9Cbg0W0QkyRJrxrR2wFsgW+yl6Ty72m6LSKOiYi+vm+XJEmSpB5V7j1NZwIDgZaI2EB2YSyllAZXLDJJkiRJ6gPKSppSSoMqHYgkSZIk9UVldc+LzPER8ZV8eFxETK5saJIkSZLU+8q9p+nHwJuAD+XD64BLKhKRJEmSJPUh5d7TdHBK6cCIeAggpbQyImorGJckSZIk9QnltjQ1RUQ1+ZNHI2JHoLViUUmSJElSH1Fu0vRD4H+BkRHxDeBu4JsVi0qSJEmS+oiykqaU0v8Anwe+BSwB3pNSun5Ly0XEOyLiiYh4KiLOKZjv2IhIETGx3MAlSZIkaVsovKcpIuqATwKvAx4BLkspNZdTcN6d7xLgMGARMCsibk4pPdZhvkHAGcBfuh++JEmSJFXWllqargImkiVMRwDf6UbZk4GnUkoLUkqNwLXA0Z3Mdz7wn8DGbpQtSZIkSdvElpKmfVJKx6eULgOOBQ7tRtk7A8+UDC/Kx7WLiDcA41JKv+lGuZIkSZK0zWzpkeNNbR9SSs0R0Z2yO5s5tU+MqAIuAk7cYkERpwKnAowdO5b5Cxey04gRPL9qNY3NTewyejT/XLKEQQMHUlNdzco1axgzciTL6utpbU2MGTWSRUuXMmT7QQCsXreWsTvtxOLnllFVFYwcPpzFy5YxbPBgmltaWLt+fXuZtTX92GHoEJauWMHwoUPZuKmR9Rsa2qfvU1vL8kGDeE19Pc8MG8bQDRsYtHEjj40ezT5LlrC2ro5V/fszbuVKnh4+nB3XrmVAY2P79FX9B9CwXS1jVq1iwYgRjFm1mrrmpvbp9QMH0lxdzag1a3hy5Eh2ra+nujUxf9RI9lq6lOV5nXZct5a/7bQTez63jJaqYOHw4eyxbBnLt6JOdbW1DBk0iOfq6xkxbBgNGzbQsHFj+/QBdXUM6N+fFStXMmr4cFavXcvGxsb26QP7D6Buu1rqV63qM+tpW9fpgG6up+cGD6ampYXh69e3r/uNNf1YPHQIu69YweKhQxmwqZGhGxrapze8hG1vvuupV+o0qg/uI0q3vY2up16p08Q+uI8o3fbmu556pU4D+uA+onTbW+N66pU6TeyD+4jSbW9+H1pPPS1SSl1PjGgB1rcNAv2BhvxzSikNLlj2TcC5KaVp+fAXyRb6Vj48BPg72YtyAXYCngeOSinN7qrciRMnptmzu5y8zXUrjewFXa9dVZLbhTrjdqHOuF2oM24X6ozbRfki4oGUUo89ZK6wpSmlVP0Syp4F7BERuwHPAh8APlRS9mpgRNtwRPwJOKsoYZIkSZKkba3c9zR1W/6UvdOAW4HHgetSSvMi4usRcVSlvleSJEmSetKW7ml6SVJKtwC3dBj31S7mnVrJWCRJkiRpa1SspUmSJEmSXglMmiRJkiSpgEmTJEmSJBUwaZIkSZKkAiZNkiRJklTApEmSJEmSCpg0SZIkSVIBkyZJkiRJKmDSJEmSJEkFTJokSZIkqYBJkyRJkiQVMGmSJEmSpAImTZIkSZJUoKa3A5BeiV5zzm97O4RiFx7Z2xG8KrldSJL08mRLkyRJkiQVMGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKmASZMkSZIkFTBpkiRJkqQCJk2SJEmSVMCkSZIkSZIKmDRJkiRJUgGTJkmSJEkqYNIkSZIkSQVMmiRJkiSpgEmTJEmSJBUwaZIkSZKkAiZNkiRJklTApEmSJEmSCpg0SZIkSVIBkyZJkiRJKmDSJEmSJEkFTJokSZIkqYBJkyRJkiQVMGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKlARZOmiHhHRDwREU9FxDmdTD8zIh6LiLkR8ceIeE0l45EkSZKk7qpY0hQR1cAlwBHAPsAHI2KfDrM9BExMKY0HbgD+s1LxSJIkSdLWqGRL02TgqZTSgpRSI3AtcHTpDCmlO1JKDfng/cDYCsYjSZIkSd1WU8GydwaeKRleBBxcMP/JwO86mxARpwKnAowdO5b5Cxey04gRPL9qNY3NTewyejT/XLKEQQMHUlNdzco1axgzciTL6utpbU2MGTWSRUuXMmT7QQCsXreWsTvtxOLnllFVFYwcPpzFy5YxbPBgmltaWLt+fXuZtTX92GHoEJauWMHwoUPZuKmR9Rsa2qfvU1vL8kGDeE19Pc8MG8bQDRsYtHEjj40ezT5LlrC2ro5V/fszbuVKnh4+nB3XrmVAY2P79FX9B9CwXS1jVq1iwYgRjFm1mrrmpvbp9QMH0lxdzag1a3hy5Eh2ra+nujUxf9RI9lq6lOV5nXZct5a/7bQTez63jJaqYOHw4eyxbBnLt6JOdbW1DBk0iOfq6xkxbBgNGzbQsHFj+/QBdXUM6N+fFStXMmr4cFavXcvGxsb26QP7D6Buu1rqV63qM+tpW9dpj8FNVAU8s66a1wxqYeWm7PrEsO1aeXptNeO2b6E1wZKG7PPzm6qojsSQ2sQ/1taw26BmGltg+cZqdh7YwvKNVfSvTmzfb/P0jc3BysYqRg9o4bkNVWzfLzGwZvP09c3BuqZgVP9WljRUM6y2lbp8+vyFC11PvVCnHbZr6dZ62m1QM+uagg0twY51rTy7vpod61qoraZ9+urGoCUFO2zXyjPrqhk9oGWrt72Nmza5nnqhThPL2Jc/N3gwNS0tDF+/vv34sLGmH4uHDmH3FStYPHQoAzY1MnRDQ/v0hh46Ps13PfVKnQb0kfOIrra9NVJkP7cAABbaSURBVK6nXqnTxD64jyjd9ub3ofXU0yKl1OOFAkTE+4FpKaVT8uETgMkppdM7mfd44DTgLSmlTUXlTpw4Mc2ePbsSIW+V6O0AtqAya1dbsus5v+3tEAotvPDI3g7hVcntQp3xOKLOuF2oM24X5YuIB1JKE3uqvEq2NC0CxpUMjwUWd5wpIt4OfJkyEiZJkiRJ2tYqeU/TLGCPiNgtImqBDwA3l84QEW8ALgOOSiktq2AskiRJkrRVKpY0pZSaybrc3Qo8DlyXUpoXEV+PiKPy2b4NbA9cHxFzIuLmLoqTJEmSpF5Rye55pJRuAW7pMO6rJZ/fXsnvlyRJkqSXqqIvt5UkSZKklzuTJkmSJEkqYNIkSZIkSQVMmiRJkiSpgEmTJEmSJBUwaZIkSZKkAiZNkiRJklTApEmSJEmSCpg0SZIkSVIBkyZJkiRJKmDSJEmSJEkFTJokSZIkqYBJkyRJkiQVqOntACRJejV7zTm/7e0Qil14ZG9HIEm9zpYmSZIkSSpgS5MkSVIfYwuk1LfY0iRJkiRJBUyaJEmSJKmASZMkSZIkFTBpkiRJkqQCJk2SJEmSVMCkSZIkSZIKmDRJkiRJUgHf0/QS+R4FSZIk6ZXNliZJkiRJKmDSJEmSJEkFTJokSZIkqYBJkyRJkiQVMGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBUyaJEmSJKmASZMkSZIkFajp7QAkSZIkbdlrzvltb4dQ7MIjezuCirGlSZIkSZIKmDRJkiRJUgGTJkmSJEkqYNIkSZIkSQVMmiRJkiSpgEmTJEmSJBUwaZIkSZKkAiZNkiRJklSgoklTRLwjIp6IiKci4pxOpm8XETPz6X+JiF0rGY8kSZIkdVfFkqaIqAYuAY4A9gE+GBH7dJjtZGBlSul1wEXAf1QqHkmSJEnaGpVsaZoMPJVSWpBSagSuBY7uMM/RwFX55xuAt0VEVDAmSZIkSeqWSiZNOwPPlAwvysd1Ok9KqRlYDQyvYEySJEmS1C01FSy7sxajtBXzEBGnAqfmg+si4omXGFtfNgJY0VOFhR0eXyncLtQZtwt1xu1CnXG7UGdeydvFa3qysEomTYuAcSXDY4HFXcyzKCJqgCHA8x0LSildDlxeoTj7lIiYnVKa2NtxqG9xu1Bn3C7UGbcLdcbtQp1xuyhfJbvnzQL2iIjdIqIW+ABwc4d5bgY+mn8+Fvi/lNKLWpokSZIkqbdUrKUppdQcEacBtwLVwE9TSvMi4uvA7JTSzcCVwNUR8RRZC9MHKhWPJEmSJG2NSnbPI6V0C3BLh3FfLfm8EXh/JWN4GXpVdENUt7ldqDNuF+qM24U643ahzrhdlCnsDSdJkiRJXavkPU2SJEnaShFxQES8o7fjkGTStNUiYl0fiGFhRIyIiKER8enejuflLCKGR8Sc/N/SiHi2ZLi2jOUXRcQj+fyPRMS7u/n9R+fLPhwRj0XEKd1Y9pSI+H53vq+bsVW0/N4WERdFxGdLhm+NiCtKhr8bEWcWLN8rf38RsWtEPNpDZb0rIh4q2f4+0RPlqvsiYlRE/CIiFkTEAxFxX0S8t2D+qRHxmy6mLYyIEZWLVi/Flo47EVEHfAd4sIvlL4iIFBG7low7Ox83oYdiXBQRQ3uirL7gpR7rt1D2xyJipy6m/Twi/pF/zwMRcfBL+a5Oyn97RNzYjfl/HRHvKhn+e0ScUzJ8U0QcFREHR8RF+bh/jYg3lszz84h4zxa+pyYiVpUMvzsinoiIcRHxmYj4cLkx58vf3VPb9tao6D1N2maGAp8GftzbgbxcpZTqgQkAEXEusC6l9J1uFvPmlNKqiNiX7MmQvy5noYjYDrgUmJhSWpwP9+i7BVToXrJ7K78fEVVk76wYXDL9EOCznS2Y6/bfX0QEWffo1u6H27Mioh9Zn/bJKaVF+fa3a4W/syZ/oblK5NvFjcBVKaUP5eNeAxzVq4GpIrZ03MlPDj+fUlpWUMwjZA/RujAffh/weEUCfgUo51j/EvbPHyNLcJd2Mf1zKaUbI+KdZMf8A7tZfk+6l+zY9puIGAWsAt5UMv2NwMkppRXAX/Jx/0r2Pqf7t+YLI+Jw4CLgsJTSM8AlWxl7r7GlqQflGfRf8iu2t+cbYsd5/pKfVLcN/ykiDoqIcyPirJLxj7ZdPYqI4yPir/kVissiorpDsRcCr82nfzsito+IP0bEg5G1ehxdmRq/OkTE5/P18WhEnF7GIoOBlSXLf7Rk/f04PzEvNYTsRc/PA6SUNqWU5ufL7hYRd0TE3Ij4Q0SM7Ubcx+fr/9GI+GY+riYiVkXEhZG1KtwXESPzaaMi4lcRMTuP940dyhsa2dXvmpLhf3SyPb7c3EN28ADYF3gUWBsRw/IEYm/goYK/qxf8/UH71d5Z+Xo7Lx+3a0Q8HhE/JjuwjouIdRHxH/mVx9sjYnK+T1gQEUfly1Xnf9dt5b2oFSgi6iLiv/O4HoqIt+bjT8zX6e8j4smI+M9O6j+I7AJaPbRvf0/ky/8sIo4t+Z51+f9V+bY8LyJ+ExG3tM0XEV/NY300Ii7PT0Da9nXfjIg/A/+2davqFe9fgcaU0k/aRqSUnk4pXdzVOi4V2VX02/Lpl1HyAvmujiP5NviNfH9wf3Ry3NK2FRGvi4g5KaU5KaWHIuKciPj3Lmb/FfDefLk9yU5qny8p6/J8nz4vIr5aMn5RZOcdD+X7lT3z8Tvmx5oHI+JSXrgN/TrfV82LvDdEfky5uuRYc0aP/yDbQP6bPxoRPyHbP4+OiCPyY+SDETEzIgbm855Xso/7SWSmkyVjM2PLrVZ3Aq/Ly9ojst4ND0TEnSXrYbfo5NgfWevOpRFxV0TMj4gjOqnL9vm++6/5+u2s50vpce8Qsos1Y9piAlallFZE3oIVEa8FTgHOzuvXtuxbI+LeyI5ZRS3ibyVLFI9IKf0jH3dB5L08ImtBujCP+Ym28iNiQERcn/8O1wJ1+fhun8tE1lL2cB7/gxExMCJ2zr97Tr4+D+kk/HYmTT3rbuCNKaU3ANcCn+9knmuB4wAiYjQwJqX0QFcFRsTewHRgSkppAtACdGzOPAf4e0ppQkrpbGAj8N6U0oHAW4HvRkSgbouIyWS/92SyqzCfjojxXcx+V0TMA/4I/Hu+/H5kB7RD8vVXQ4dH6+dXEW8Fno6sW84HY3Ni9WPgipTSeOB6oKxucvkO9gKy9f8GYEpsboofAvw5pXQAcB/Z1TGAHwL/mb/k7jjgitIyU0qryHa0bf3rPwRcl1JqKSemviqltBhojohdyA4e95FdWXsTMBGYm1JqpOu/qxf8/UV2NW0Psm1mAnBQRByaf93rgRkppTeklJ4GBgJ/SikdBKwlW2eHkW0zX8+XORlYnVKaBEwCPh4Ru3WoxmfyuuwPfBC4KrKuPeQxTAf2B6ZHROlLx0kpPU/WMvp0RFwTER+OFyf2Hb2PrDVqf7IDaekVyh+llCallPYD+gPvKpk2NKX0lpTSd7dQ/qvVvnTRFYviddzma8Dd+THoZmAX2OJxZCBwf74/uBP4eM9VR9vAKmBpROxFtl1c22H6Ofk+/QDgsIjYp2Tac/m2cgXQ1gX5POCOfD/3e/IT6dxH833VJODMiBgGHASMSCntn//Nz+jh+m1L+wBX5r9JE9m+/W35bzGXzRd7fpDvj/cnO56+I6U0E5gDTM+PBY0F3/NushZCyFr5P53/rl8EfpSPLzr2jwPekpdzeWQX90p9Ffh9Smky2YWY73ayr5gFTIjsImjbce+pPGk7hOxY3y6l9Hey7eTbef3uzSeNBKYA7wG+1UV9BwC/BI5OKT3ZxTyQte5NBs7O6wBwGrAy/x3+g+x8pk13z2XOBk7N94GHkh3Tjwd+nY87gGw9d8nueT1rLNlVhtFALfCPTua5DvgD2cHtOLI/hiJvI9spzcrznv5AUVM9ZFeGvpmfqLUCOwOj6LrJWF17M/DLlFIDQGR9hv+Fzv+w2rrn7QncGlmL4tvJDjCzS9bfMx0XTCmdmCdjbyffUZOdjB7M5pPOGcD5ZcZ9MNnLolfkcf+CbCfxe2BDSul3+XwP5HUk/+7Xl+TXwyKif4dyrwDOAH4DnAScUGY8fV3bVbdDgO+R/c0cAqwm68YAXf9ddXR4/u+hfHh7siTqn8DTKaXSrg2NZOsEsoPoppRSU0Q8wuYucocD42Nzi8+QvLz5JeX8C3AxQErpbxHxNLBnPu2PKaXVABHxGFnXzxdsgymlUyJif7Jt4CyyxO3ETupW+n3X591XlkbEHSXT3hoRnyc7UO4AzGNzV9WZBWWqg4i4hOy3bgQW0fU6bnMoWUJLSum3EdHW4l10HGkk+3uGbH9wWEUqo0qaSXYx7t1kJ9OfKpn2wYg4mex8bwxZYvBYPu1X+f8PAO/MPx/a9jmldFNErC0p63ORt4CTne+8FniK7LjxA7JXzNzWg/Xa1v6eUpqVfz6E7Le6N/+bqSW7MA7wtog4m6zVYwTZ7/c7tuyiyLoELiO7+DWUrBvcL0uOu23n5UXH/uvyfe8TEfEM2fGg1OHAEbH5HqU6sgso7ceMlNKGiHiC7KLawXn5++T1fhObj3tbcmPKHsM9NyJ27mKejWQXIk8C/l9BWaXb467550OB/8xjfii/MN2mu+cy95B1w/8F2XnduoiYBVyWJ5U3ppQeLqqsSVPPuhj4Xkrp5oiYCpzbcYaU0rMRUZ+fIE8H2rraNPPClr+2qwJB1r/9i92I48PAjsBB+QnYwpLy1D3dbqFLKc2PiOeBvfLlf5pS+koZy80l2/H8gqxPetkPg+hEUdylV8Ba2LwfCLL7Wl5whay0kTKl9OeI+FHe1N6UUvrbS4ixL2nr370/Wfe8Z8h27muAn+bzlPt3FcC3UkqXvWBk1t12fYd5m9Lm9z60ApsAUkqt+RXAtvJOTynd2kl5pd/ZlU0ln0vX9wuklB4BHomIq8ku+JxIyX4pb1Vr63LS6fflB54fk92f90x+glD6G3Wsv15oHnBM20BK6TORPchhNvBsmWV09h6RouNI6TbY5fahbaqz84GiewBvAv4G3JufCALt3az+jWy/vioifs4L/x7b9g0d1/uLtqGIeDvZCewb8xPuu4G6lFLb+cwRZBfUjgFOLbumfUvp/inIWmtecGEwIgaQtQYdmJ/PXUD551efSym1P6whb6lbkbdydEfH9dNxOID35K1DRe4FppKtxzURcT+bew6U+/Cn0uNLV8ehVuBY4P8i4vMppc66iZeWtcXtMdetcxnggoi4GTiS7ALS1JTS/+Xn60cC/xMR30op/U8X32f3vB42hM0Hto8WzNfWdW9IfqICsJD8psCIOBBo637zR+DY2NxXc4fIbgwutZbsvoTSOJblJ3ZvxYcKvBR3Au+NiP4RsT1wNHBX0QKRPT1nF7KWhduB4/ITn7Z7DnbpMP/gku5bkF35eTr/fD95d06yZuQ7y4z7frIr/sPzk+8PAH/ewjK3k3cByuPqakf+c+B/gP8uM5aXg3vIruo9n1JqybusDSU7eNyXz9PV31XHv79bgY/l2wuR9Zke+RJiuxX4VGQPbCAi9oy8b32JO8m7W+UtnbsAT5RTeGT936eWjCrd/haStVBAtu33yz/fDRwT2b1No8gOvLD55GFFXv/2+6FUlv8D6iKitKVgQP5/Oeu4dJ4jgGH5+HKOI+o7lgJjIruvso7shK5LKaX1wBd4cfeowWT7pzV5D5hpZXx36Tb0bjbv24aQ7R835L0oJuXz7EjWrep6sh40vflwg550L/CWiNgdILL7X/Yga6VtJdvHDaLkIgcvPhYUSimtBJZEfi9Qvj89IJ9cdOx/f2T2JOuq17HL261kCSx5uW+gc/eQtUq29Yp4iKy1ZieyJLyjbtWvVL6NHgmcFBFF58cdlW6PB5B1Yd6STs9lIuK1KaW5KaVvkdX19fl+cGlK6XLgZ7yw+9+LeEVp6w2IiEUlw98ja1m6PiKeJdvgO9530OYG4Ae8sLn1l8BHImIOWV/T+QAppcciuwH0tsjuM2gi2xjaTmrIr/TcE9njh39H1u/z1xExm6yP7SulNWCbSyn9NSKuIVsnAJeWJLod3RURLWQnlmflXeNWRPYggNtL1t8nyRKqNgF8MSL+C9gArGNz39zTgCsj4ovAc2TN2505OUpu2Ce7F+erwJ/y8n+dd9cp+pv/DHBpRJxEtm+4g5IdT4n/yct+JXW1eoSsm8UvOozbvq2LI1m9X/R31fHvL7+vaW/gvvyK7zqyg97W3vt1BVlXhQfz1p7lZP3HS/0Y+Elk3fqagRNTSpuivFsZA/h8ZA8O2EB2tfXEfNp/ATdFxF/JTrzbrsT+kqzL16Nk+6q/kN13tSrfjh8hS7ja/m5UhpRSiuwRvhdF1sVxOdlv/gWy1oQtrePzgGsi4kGyiyT/zMvd4nFEfUdKaWNkD++ZBSxgc3e6omV+0cnoB/NlH83LuaeTeTr6Gtk2dBzZMaDtQvBvgVMj4mGyfV/bE9XGkR2jgqxF4AtlfEefl1J6LrJujTNj80MdvpQfR68i+02fZvPvANmFxCsiYgOdt3R05gNkx91zyVryfw48TPGx/ymyZGIk2T06jZ3sB76f7yuq8vk7eyDYPcDu5BcG8wuC9cCCktbnUjeRneO+j87PDQql7MES7wD+HBErtrhA5kdk92/OJdueZ5exTFfnMmdFxJvJkt65ZF1Jjye7P6+JzcfqLkXnv4skdS4iPgBMSyl1lcDpVSAits+7Ag0H/kr2kAHvm5SkComsi+UNpd38tO3Y0iSpbJE9gvbtbH6Cnl69fhPZjcy1wPkmTJKkVzJbmiRJkiSpgA+CkCRJkqQCJk2SJEmSVMCkSZIkSZIKmDRJkiomf1fYnPzf0oh4tmS4dssldFnux/J3ovVEjK/LX/cgSVKnfHqeJKliUkr1ZC/MJX8XybqU0nd6oOiPkb2340VP7YuImpRScw98hyRJgC1NkqReEhGfj4hH83+n5+NeFxHzIuLqiHgkIq6LiP4dlptOlojNbGuxiohFEfGViLgHeG9EfDIiZkXEwxFxfVsZEbFTRNwUEXPzaQd3KPt1EfFQRBwYEfvnZczJ5999G/00kqQ+xqRJkrTNRcRk4MPAZOBNwKcjYnw+eR/gkpTS/sBG4BOly6aUZgJzgOkppQkppcZ80vqU0pSU0vXA9SmlSSmlA4C/Ayfm81wC/CGlNB44CHi8JKa9geuBj6SUHgQ+DXwnpTQBmAQs7tEfQZL0smHSJEnqDW8GfplSakgprQVuBP4ln/aPlNL9+eefl4zfkpkln8dHxF0R8QjwAWDffPxU4DKAlFJzSmlNPn4U8L/AB1NKj+Tj7gX+PSI+D4xLKW3sVg0lSa8YJk2SpN4QBdM6vnW93Lewry/5PAP4VN5adQFQt4XyVgHPAlPaZ0rpauC9wCbgDxFxaJlxSJJeYUyaJEm94U6ye4/6R8T2wNHAXfm03SJiUv75g8DdnSy/FhhUUP5AYGlE9AM+VDL+DuCTABFRHRGD8/Gb8hhOjojj8um7p5SeSin9APgtMB5J0quSSZMkaZtLKf0VuAaYBdwPXFrSLW4e8PGImEuW/FzeSRH/DVxR8OjyrwJ/Bf4APFYy/jRgWt5tbzawV0lM64B3AV+IiCOBD+UPpZgD7E7WVVCS9CoUKZXb60GSpMqKiNcBN+QPX5AkqU+wpUmSJEmSCtjSJEmSJEkFbGmSJEmSpAImTZIkSZJUwKRJkiRJkgqYNEmSJElSAZMmSZIkSSpg0iRJkiRJBf4/O+iwV+e3ZzoAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 1008x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(14,5))\n",
    "width=0.3\n",
    "plt.bar(df2.track, df2.danceability, color='cyan',width=width, label='Danceability %')\n",
    "plt.bar(df2.track, df2.liveness,width=width, label='Liveness %')\n",
    "plt.xlabel('Top tracks')\n",
    "plt.ylabel('Percentage')\n",
    "plt.ylim(0,1)\n",
    "plt.legend()\n",
    "plt.grid(color='#95a5a6', linestyle='--', linewidth=0.5, axis='y', alpha=0.7)\n",
    "plt.savefig('danceability_chart.png')"
   ]
  },
  {
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}