Avance 2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: spotipy in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (2.25.0)\n",
      "Requirement already satisfied: redis>=3.5.3 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from spotipy) (5.2.1)\n",
      "Requirement already satisfied: requests>=2.25.0 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from spotipy) (2.32.3)\n",
      "Requirement already satisfied: urllib3>=1.26.0 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from spotipy) (2.3.0)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from requests>=2.25.0->spotipy) (3.4.1)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from requests>=2.25.0->spotipy) (3.10)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from requests>=2.25.0->spotipy) (2025.1.31)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "[notice] A new release of pip is available: 24.0 -> 25.0.1\n",
      "[notice] To update, run: C:\\Users\\InvitadoLaptop\\AppData\\Local\\Microsoft\\WindowsApps\\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\\python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "pip install spotipy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: tqdm in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (4.67.1)\n",
      "Requirement already satisfied: colorama in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from tqdm) (0.4.6)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "[notice] A new release of pip is available: 24.0 -> 25.0.1\n",
      "[notice] To update, run: C:\\Users\\InvitadoLaptop\\AppData\\Local\\Microsoft\\WindowsApps\\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\\python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "pip install tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Para importar\n",
    "\n",
    "import spotipy\n",
    "import pandas as pd\n",
    "import tqdm\n",
    "import requests\n",
    "import json\n",
    "from spotipy.oauth2 import SpotifyClientCredentials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Credenciales obtenidas de SPOTIPY\n",
    "\n",
    "CLIENT_ID = 'e89a20fa9f524fbe91a34ed52c346ce5'\n",
    "CLIENT_SECRET = '5b776dd228714f9cad9716a07a6d6a25'\n",
    "\n",
    "# Autenticación\n",
    "auth_manager = SpotifyClientCredentials(client_id=CLIENT_ID, client_secret=CLIENT_SECRET)\n",
    "sp = spotipy.Spotify(auth_manager=auth_manager)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Obteniendo álbumes de artistas::   0%|          | 0/5 [00:00<?, ?it/s]"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Obteniendo álbumes de artistas:: 100%|██████████| 5/5 [00:04<00:00,  1.10it/s]\n"
     ]
    },
    {
     "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>ID</th>\n",
       "      <th>Artista</th>\n",
       "      <th>Género</th>\n",
       "      <th>Tipo</th>\n",
       "      <th>Nombre_album</th>\n",
       "      <th>Año_lanzamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Pobre Corazón (En Vivo)</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Adiós Amor / Oye Mujer</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Si No Te Tengo / Ángel / Aquello Que Pasó</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Otro Día Más</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Cómo estás</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Como la Flor</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Entre Beso y Beso</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Entre el Odio y el Amor (En Vivo)</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>cumbia</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Intento (En Vivo)</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>eternal sunshine</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>thank u, next</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Positions</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>eternal sunshine</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Stuck with U</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>66CXWjxzNUsdJxJ2JdwvnR</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>pop</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Positions (Deluxe)</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>6XyY86QOPPrYVGvF9ch6wz</td>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>nu metal</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>From Zero</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6XyY86QOPPrYVGvF9ch6wz</td>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>nu metal</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>The Emptiness Machine</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6XyY86QOPPrYVGvF9ch6wz</td>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>nu metal</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Heavy Is the Crown</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>6XyY86QOPPrYVGvF9ch6wz</td>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>nu metal</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Meteora 20th Anniversary Edition</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Falling For You</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Breathe</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Feel It</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>You and Me</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Global Underground #44: Amelie Lens - Antwerp ...</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Underneath The Strobelights (Exhale VA005)</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Global Underground #44: Amelie Lens - Antwerp ...</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>fabric presents Amelie Lens (DJ Mix)</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5Ho1vKl1Uz8bJlk4vbmvmf</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>techno</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Hypnotized</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>Teatro d'ira - Vol. I</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>RUSH!</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>RUSH! (ARE U COMING?)</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>RUSH!</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>THE LONELIEST</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>GOSSIP (feat. Tom Morello)</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>SUPERMODEL</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>None</td>\n",
       "      <td>Álbum</td>\n",
       "      <td>MAMMAMIA</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        ID        Artista    Género   Tipo  \\\n",
       "0   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "1   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "2   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "3   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "4   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "5   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "6   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "7   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "8   06Q5VlSAku57lFzyME3HrM  Ke Personajes    cumbia  Álbum   \n",
       "9   66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "10  66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "11  66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "12  66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "13  66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "14  66CXWjxzNUsdJxJ2JdwvnR  Ariana Grande       pop  Álbum   \n",
       "15  6XyY86QOPPrYVGvF9ch6wz    Linkin Park  nu metal  Álbum   \n",
       "16  6XyY86QOPPrYVGvF9ch6wz    Linkin Park  nu metal  Álbum   \n",
       "17  6XyY86QOPPrYVGvF9ch6wz    Linkin Park  nu metal  Álbum   \n",
       "18  6XyY86QOPPrYVGvF9ch6wz    Linkin Park  nu metal  Álbum   \n",
       "19  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "20  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "21  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "22  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "23  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "24  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "25  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "26  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "27  5Ho1vKl1Uz8bJlk4vbmvmf    Amelie Lens    techno  Álbum   \n",
       "28  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "29  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "30  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "31  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "32  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "33  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "34  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "35  0lAWpj5szCSwM4rUMHYmrr       Måneskin      None  Álbum   \n",
       "\n",
       "                                         Nombre_album Año_lanzamiento  \n",
       "0                             Pobre Corazón (En Vivo)            2023  \n",
       "1                              Adiós Amor / Oye Mujer            2020  \n",
       "2           Si No Te Tengo / Ángel / Aquello Que Pasó            2021  \n",
       "3                                        Otro Día Más            2021  \n",
       "4                                          Cómo estás            2019  \n",
       "5                                        Como la Flor            2022  \n",
       "6                                   Entre Beso y Beso            2023  \n",
       "7                   Entre el Odio y el Amor (En Vivo)            2024  \n",
       "8                                   Intento (En Vivo)            2024  \n",
       "9                                    eternal sunshine            2024  \n",
       "10                                      thank u, next            2019  \n",
       "11                                          Positions            2020  \n",
       "12                                   eternal sunshine            2024  \n",
       "13                                       Stuck with U            2020  \n",
       "14                                 Positions (Deluxe)            2021  \n",
       "15                                          From Zero            2024  \n",
       "16                              The Emptiness Machine            2024  \n",
       "17                                 Heavy Is the Crown            2024  \n",
       "18                   Meteora 20th Anniversary Edition            2023  \n",
       "19                                    Falling For You            2024  \n",
       "20                                            Breathe            2024  \n",
       "21                                            Feel It            2023  \n",
       "22                                         You and Me            2023  \n",
       "23  Global Underground #44: Amelie Lens - Antwerp ...            2022  \n",
       "24         Underneath The Strobelights (Exhale VA005)            2024  \n",
       "25  Global Underground #44: Amelie Lens - Antwerp ...            2022  \n",
       "26               fabric presents Amelie Lens (DJ Mix)            2019  \n",
       "27                                         Hypnotized            2019  \n",
       "28                              Teatro d'ira - Vol. I            2021  \n",
       "29                                              RUSH!            2023  \n",
       "30                              RUSH! (ARE U COMING?)            2023  \n",
       "31                                              RUSH!            2023  \n",
       "32                                      THE LONELIEST            2022  \n",
       "33                         GOSSIP (feat. Tom Morello)            2023  \n",
       "34                                         SUPERMODEL            2022  \n",
       "35                                           MAMMAMIA            2021  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Código para ALBUM y obtener su DATAFRAME\n",
    "\n",
    "artistas_list = ['Ke Personajes', 'Ariana Grande', 'Linkin Park', 'Amelie lens', 'Maneskin']\n",
    "\n",
    "album_data = []\n",
    "\n",
    "for artista_nombre in tqdm.tqdm(artistas_list, desc='Obteniendo álbumes de artistas:'):\n",
    "    resultados = sp.search(q=f'artist:{artista_nombre}', type='album')\n",
    "\n",
    "    for album in resultados['albums']['items']:\n",
    "        nombre_album = album['name']\n",
    "        fecha_lanzamiento = album['release_date']\n",
    "\n",
    "        artistas = [artist['name'] for artist in album['artists']]\n",
    "        artista_principal = artistas[0] if artistas else \"Artista no disponible\"\n",
    "\n",
    "        genero = None\n",
    "        artista_id = None  # Inicializa artista_id fuera del bloque if\n",
    "        \n",
    "        if album['artists']:\n",
    "            artista_id = album['artists'][0]['id']  # Ahora artista_id tiene el ID del artista\n",
    "            artista_info = sp.artist(artista_id)\n",
    "            generos_artista = artista_info.get('genres', [])\n",
    "            if generos_artista:\n",
    "                genero = generos_artista[0]\n",
    "\n",
    "        año_lanzamiento = fecha_lanzamiento[:4]  # Obtiene solo el año\n",
    "\n",
    "        # Verifica si el año está en el rango deseado\n",
    "        if 2019 <= int(año_lanzamiento) <= 2024:\n",
    "            album_info = {\n",
    "                \"ID\": artista_id,  # Usa artista_id en lugar de album['id']\n",
    "                \"Artista\": artista_principal,\n",
    "                \"Género\": genero,\n",
    "                \"Tipo\": \"Álbum\",\n",
    "                \"Nombre_album\": nombre_album,\n",
    "                \"Año_lanzamiento\": año_lanzamiento\n",
    "            }\n",
    "\n",
    "            album_data.append(album_info)\n",
    "\n",
    "df_albumes = pd.DataFrame(album_data)\n",
    "df_albumes #Esta data es un documento virtual que se introduce al SQL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_albumes.to_csv(\"Albumes.csv\") #Convierte a documento CSV y se guarda en la carpeta donde esta este visual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>ID</th>\n",
       "      <th>Artista</th>\n",
       "      <th>Biografía</th>\n",
       "      <th>Oyentes</th>\n",
       "      <th>Reproducciones</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke personajes</td>\n",
       "      <td>&lt;a href=\"https://www.last.fm/music/Ke+persona...</td>\n",
       "      <td>42172</td>\n",
       "      <td>1032097</td>\n",
       "      <td>https://www.last.fm/music/Ke+personajes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>Ariana Grande-Butera, better known professiona...</td>\n",
       "      <td>3738711</td>\n",
       "      <td>806191269</td>\n",
       "      <td>https://www.last.fm/music/Ariana+Grande</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>Linkin Park is an American nu-metal band from ...</td>\n",
       "      <td>5867022</td>\n",
       "      <td>524320381</td>\n",
       "      <td>https://www.last.fm/music/Linkin+Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Amelie Lens</td>\n",
       "      <td>Amelie Lens (born 31 May 1990) is a Belgian el...</td>\n",
       "      <td>121540</td>\n",
       "      <td>1160834</td>\n",
       "      <td>https://www.last.fm/music/Amelie+Lens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>Måneskin is an Italian rock band formed in Rom...</td>\n",
       "      <td>5116</td>\n",
       "      <td>82644</td>\n",
       "      <td>https://www.last.fm/music/Maneskin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       ID        Artista  \\\n",
       "0  0lAWpj5szCSwM4rUMHYmrr  Ke personajes   \n",
       "1  0lAWpj5szCSwM4rUMHYmrr  Ariana Grande   \n",
       "2  0lAWpj5szCSwM4rUMHYmrr    Linkin Park   \n",
       "3  0lAWpj5szCSwM4rUMHYmrr    Amelie Lens   \n",
       "4  0lAWpj5szCSwM4rUMHYmrr       Maneskin   \n",
       "\n",
       "                                           Biografía  Oyentes Reproducciones  \\\n",
       "0   <a href=\"https://www.last.fm/music/Ke+persona...    42172        1032097   \n",
       "1  Ariana Grande-Butera, better known professiona...  3738711      806191269   \n",
       "2  Linkin Park is an American nu-metal band from ...  5867022      524320381   \n",
       "3  Amelie Lens (born 31 May 1990) is a Belgian el...   121540        1160834   \n",
       "4  Måneskin is an Italian rock band formed in Rom...     5116          82644   \n",
       "\n",
       "                                       URL  \n",
       "0  https://www.last.fm/music/Ke+personajes  \n",
       "1  https://www.last.fm/music/Ariana+Grande  \n",
       "2    https://www.last.fm/music/Linkin+Park  \n",
       "3    https://www.last.fm/music/Amelie+Lens  \n",
       "4       https://www.last.fm/music/Maneskin  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Código para ARTISTA y obtener su DATAFRAME\n",
    "\n",
    "API_KEY = \"d43d3344b1962fd39c8e7dd314d2296c\"  # Reemplaza con tu clave de Last.fm\n",
    "ARTISTS = ['Ke Personajes', 'Ariana Grande', 'Linkin Park', 'Amelie lens', 'Maneskin']  # Lista de artistas\n",
    "\n",
    "artist_data = []\n",
    "\n",
    "def get_artist_info(artist):\n",
    "    url = f\"http://ws.audioscrobbler.com/2.0/?method=artist.getinfo&artist={artist}&api_key={API_KEY}&format=json\"\n",
    "    response = requests.get(url)\n",
    "    if response.status_code == 200:\n",
    "        data = response.json()\n",
    "        if \"artist\" in data:\n",
    "            artist_info = {\n",
    "                \"ID\": artista_id,\n",
    "                \"Artista\": data['artist']['name'],\n",
    "                \"Biografía\": data['artist']['bio']['summary'],  \n",
    "                \"Oyentes\": data['artist']['stats']['listeners'],  \n",
    "                \"Reproducciones\": data['artist']['stats']['playcount'],  \n",
    "                \"URL\": data['artist']['url']\n",
    "            }\n",
    "            artist_data.append(artist_info)\n",
    "        else:\n",
    "            print(f\"No se encontró el artista: {artist}\")\n",
    "    else:\n",
    "        print(f\"Error en la solicitud para {artist}: {response.status_code}\")\n",
    "\n",
    "# Llama a la función para cada artista en la lista\n",
    "for artist in ARTISTS:\n",
    "    get_artist_info(artist)\n",
    "\n",
    "# Crea el DataFrame después de recopilar todos los datos\n",
    "df_artista = pd.DataFrame(artist_data)\n",
    "\n",
    "df_artista #Esta data es un documento virtual que se introduce al SQL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_artista.to_csv(\"Artista.csv\") #Convierte a documento CSV y se guarda en la carpeta donde esta este visual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>ID</th>\n",
       "      <th>Artista_original</th>\n",
       "      <th>Artista_similar</th>\n",
       "      <th>Coincidencia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>La T y la M</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Ráfaga</td>\n",
       "      <td>0.517295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Damas Gratis</td>\n",
       "      <td>0.504201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Los Palmeras</td>\n",
       "      <td>0.464110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Leo Mattioli</td>\n",
       "      <td>0.459296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>Inioranti</td>\n",
       "      <td>0.081652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>Luca Bacconi</td>\n",
       "      <td>0.081652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>Marco Notari</td>\n",
       "      <td>0.081652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>La ragazza dello Sputnik</td>\n",
       "      <td>0.081652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Maneskin</td>\n",
       "      <td>Ze Hop</td>\n",
       "      <td>0.081652</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         ID Artista_original           Artista_similar  \\\n",
       "0    0lAWpj5szCSwM4rUMHYmrr    Ke Personajes               La T y la M   \n",
       "1    0lAWpj5szCSwM4rUMHYmrr    Ke Personajes                    Ráfaga   \n",
       "2    0lAWpj5szCSwM4rUMHYmrr    Ke Personajes              Damas Gratis   \n",
       "3    0lAWpj5szCSwM4rUMHYmrr    Ke Personajes              Los Palmeras   \n",
       "4    0lAWpj5szCSwM4rUMHYmrr    Ke Personajes              Leo Mattioli   \n",
       "..                      ...              ...                       ...   \n",
       "495  0lAWpj5szCSwM4rUMHYmrr         Maneskin                 Inioranti   \n",
       "496  0lAWpj5szCSwM4rUMHYmrr         Maneskin              Luca Bacconi   \n",
       "497  0lAWpj5szCSwM4rUMHYmrr         Maneskin              Marco Notari   \n",
       "498  0lAWpj5szCSwM4rUMHYmrr         Maneskin  La ragazza dello Sputnik   \n",
       "499  0lAWpj5szCSwM4rUMHYmrr         Maneskin                    Ze Hop   \n",
       "\n",
       "    Coincidencia  \n",
       "0              1  \n",
       "1       0.517295  \n",
       "2       0.504201  \n",
       "3       0.464110  \n",
       "4       0.459296  \n",
       "..           ...  \n",
       "495     0.081652  \n",
       "496     0.081652  \n",
       "497     0.081652  \n",
       "498     0.081652  \n",
       "499     0.081652  \n",
       "\n",
       "[500 rows x 4 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Código para ARTISTA SIMILAR y obtener su DATAFRAME\n",
    "\n",
    "similar_artist_data = []\n",
    "def get_similar_artists(artist):\n",
    "    url_similar = f\"http://ws.audioscrobbler.com/2.0/?method=artist.getsimilar&artist={artist}&api_key={API_KEY}&format=json\"\n",
    "    response_similar = requests.get(url_similar)\n",
    "    if response_similar.status_code == 200:\n",
    "        data_similar = response_similar.json()\n",
    "        if \"similarartists\" in data_similar and \"artist\" in data_similar[\"similarartists\"]:\n",
    "            for similar_artist in data_similar['similarartists']['artist']:\n",
    "                similar_artist_data.append({\n",
    "                    \"ID\": artista_id,\n",
    "                    \"Artista_original\": artist,\n",
    "                    \"Artista_similar\": similar_artist['name'],\n",
    "                    \"Coincidencia\": similar_artist['match']\n",
    "                })\n",
    "        else:\n",
    "            print(f\"No se encontraron artistas similares para {artist}.\")\n",
    "    else:\n",
    "        print(f\"Error en la solicitud de artistas similares para {artist}: {response_similar.status_code}\")\n",
    "# Llama a la función para cada artista en la lista\n",
    "for artist in ARTISTS:\n",
    "    get_similar_artists(artist)\n",
    "# Crea el DataFrame después de recopilar todos los datos\n",
    "df_artistas_similares = pd.DataFrame(similar_artist_data)\n",
    "df_artistas_similares #Esta data es un documento virtual que se introduce al SQL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_artistas_similares.to_csv(\"Artistas_similares.csv\") #Convierte a documento CSV y se guarda en la carpeta donde esta este visual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Obteniendo canciones de artistas:: 100%|██████████| 5/5 [00:04<00:00,  1.19it/s]\n"
     ]
    },
    {
     "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>ID</th>\n",
       "      <th>Artista</th>\n",
       "      <th>Nombre_album</th>\n",
       "      <th>Nombre_canción</th>\n",
       "      <th>Año_lanzamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Pobre Corazón (En Vivo)</td>\n",
       "      <td>Pobre Corazón - En Vivo</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Adiós Amor / Oye Mujer</td>\n",
       "      <td>Adiós Amor / Oye Mujer</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Si No Te Tengo / Ángel / Aquello Que Pasó</td>\n",
       "      <td>Si No Te Tengo / Ángel / Aquello Que Pasó</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Otro Día Más</td>\n",
       "      <td>Otro Día Más</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>06Q5VlSAku57lFzyME3HrM</td>\n",
       "      <td>Ke Personajes</td>\n",
       "      <td>Cómo estás</td>\n",
       "      <td>Cómo estás</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>RUSH!</td>\n",
       "      <td>THE LONELIEST</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>THE LONELIEST</td>\n",
       "      <td>THE LONELIEST</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>GOSSIP (feat. Tom Morello)</td>\n",
       "      <td>GOSSIP (feat. Tom Morello)</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>SUPERMODEL</td>\n",
       "      <td>SUPERMODEL</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>0lAWpj5szCSwM4rUMHYmrr</td>\n",
       "      <td>Måneskin</td>\n",
       "      <td>MAMMAMIA</td>\n",
       "      <td>MAMMAMIA</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>299 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         ID        Artista  \\\n",
       "0    06Q5VlSAku57lFzyME3HrM  Ke Personajes   \n",
       "1    06Q5VlSAku57lFzyME3HrM  Ke Personajes   \n",
       "2    06Q5VlSAku57lFzyME3HrM  Ke Personajes   \n",
       "3    06Q5VlSAku57lFzyME3HrM  Ke Personajes   \n",
       "4    06Q5VlSAku57lFzyME3HrM  Ke Personajes   \n",
       "..                      ...            ...   \n",
       "294  0lAWpj5szCSwM4rUMHYmrr       Måneskin   \n",
       "295  0lAWpj5szCSwM4rUMHYmrr       Måneskin   \n",
       "296  0lAWpj5szCSwM4rUMHYmrr       Måneskin   \n",
       "297  0lAWpj5szCSwM4rUMHYmrr       Måneskin   \n",
       "298  0lAWpj5szCSwM4rUMHYmrr       Måneskin   \n",
       "\n",
       "                                  Nombre_album  \\\n",
       "0                      Pobre Corazón (En Vivo)   \n",
       "1                       Adiós Amor / Oye Mujer   \n",
       "2    Si No Te Tengo / Ángel / Aquello Que Pasó   \n",
       "3                                 Otro Día Más   \n",
       "4                                   Cómo estás   \n",
       "..                                         ...   \n",
       "294                                      RUSH!   \n",
       "295                              THE LONELIEST   \n",
       "296                 GOSSIP (feat. Tom Morello)   \n",
       "297                                 SUPERMODEL   \n",
       "298                                   MAMMAMIA   \n",
       "\n",
       "                                Nombre_canción Año_lanzamiento  \n",
       "0                      Pobre Corazón - En Vivo            2023  \n",
       "1                       Adiós Amor / Oye Mujer            2020  \n",
       "2    Si No Te Tengo / Ángel / Aquello Que Pasó            2021  \n",
       "3                                 Otro Día Más            2021  \n",
       "4                                   Cómo estás            2019  \n",
       "..                                         ...             ...  \n",
       "294                              THE LONELIEST            2023  \n",
       "295                              THE LONELIEST            2022  \n",
       "296                 GOSSIP (feat. Tom Morello)            2023  \n",
       "297                                 SUPERMODEL            2022  \n",
       "298                                   MAMMAMIA            2021  \n",
       "\n",
       "[299 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Código para CANCIÓN y obtener su DATAFRAME\n",
    "\n",
    "artistas_list = ['Ke Personajes', 'Ariana Grande', 'Linkin Park', 'Amelie lens', 'Maneskin']\n",
    "\n",
    "cancion_data = []\n",
    "\n",
    "for artista_nombre in tqdm.tqdm(artistas_list, desc='Obteniendo canciones de artistas:'):\n",
    "    try:\n",
    "        resultados = sp.search(q=f'artist:{artista_nombre}', type='album')\n",
    "\n",
    "        for album in resultados['albums']['items']:\n",
    "            nombre_album = album['name']\n",
    "            fecha_lanzamiento = album['release_date']\n",
    "\n",
    "            artistas = [artist['name'] for artist in album['artists']]\n",
    "            artista_principal = artistas[0] if artistas else \"Artista no disponible\"\n",
    "\n",
    "            artista_id = album['artists'][0]['id'] if album['artists'] else None\n",
    "\n",
    "            año_lanzamiento = fecha_lanzamiento[:4]  # Obtiene solo el año\n",
    "\n",
    "            # Verifica si el año está en el rango deseado\n",
    "            if 2019 <= int(año_lanzamiento) <= 2024:\n",
    "                # Obtiene las canciones del álbum\n",
    "                tracks = sp.album_tracks(album['id'])\n",
    "                for track in tracks['items']:\n",
    "            \n",
    "                    cancion_info = {\n",
    "                        \"ID\": artista_id,\n",
    "                        \"Artista\": artista_principal,\n",
    "                        \"Nombre_album\": nombre_album,\n",
    "                        \"Nombre_canción\": track['name'],\n",
    "                        \"Año_lanzamiento\": año_lanzamiento\n",
    "                    }\n",
    "                    cancion_data.append(cancion_info)\n",
    "    except spotipy.exceptions.SpotifyException as e:\n",
    "        print(f\"Error con el artista {artista_nombre}: {e}\")\n",
    "        auth_manager.cache_handler.clear()\n",
    "        sp = spotipy.Spotify(auth_manager=auth_manager)\n",
    "        continue\n",
    "\n",
    "df_canciones = pd.DataFrame(cancion_data)\n",
    "df_canciones #Esta data es un documento virtual que se introduce al SQL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_canciones.to_csv(\"Canciones.csv\") #Convierte a documento CSV y se guarda en la carpeta donde esta este visual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importar para establecer conexion\n",
    "\n",
    "import mysql.connector\n",
    "from mysql.connector import errorcode\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# Código para tener un ingreso a SQL\n",
    "\n",
    "try:\n",
    "  cnx = mysql.connector.connect(user='root', password='AlumnaAdalab',\n",
    "                              host='127.0.0.1',\n",
    "                              database='northwind')\n",
    "\n",
    "except mysql.connector.Error as err:\n",
    "\n",
    "  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "    print(\"Something is wrong with your user name or password\")\n",
    "  \n",
    "  \n",
    "  elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "    print(\"Database does not exist\")\n",
    "  \n",
    "  \n",
    "  else:\n",
    "    print(err)\n",
    "else:\n",
    "  cnx.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MySQLCursor: CREATE DATABASE music_stream_proyecto\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# Código para crear un squema en SQL\n",
    "\n",
    "cnx = mysql.connector.connect(user='root', password='AlumnaAdalab',\n",
    "                              host='127.0.0.1')\n",
    "\n",
    "\n",
    "mycursor = cnx.cursor()\n",
    "try:\n",
    "    mycursor.execute(\"CREATE DATABASE music_stream_proyecto\")\n",
    "    print(mycursor)\n",
    "except mysql.connector.Error as err:\n",
    "    print(err)\n",
    "    print(\"Error Code:\", err.errno)\n",
    "    print(\"SQLSTATE\", err.sqlstate)\n",
    "    print(\"Message\", err.msg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# Código para crear tablas para SQL\n",
    "\n",
    "cnx = mysql.connector.connect(user='root', password='AlumnaAdalab',\n",
    "                              host='127.0.0.1', database='music_stream_proyecto')\n",
    "\n",
    "\n",
    "mycursor = cnx.cursor()\n",
    "try:\n",
    "    mycursor.execute(\"\"\"\n",
    "    CREATE TABLE albumes(\n",
    "        ID VARCHAR(100),\n",
    "        Artista VARCHAR(200),\n",
    "        Género VARCHAR(100),\n",
    "        Tipo VARCHAR(50),\n",
    "        Nombre_album VARCHAR(200),\n",
    "        Año_lanzamiento YEAR)\"\"\")\n",
    "\n",
    "    mycursor.execute(\"\"\"\n",
    "    CREATE TABLE artista(\n",
    "        ID VARCHAR(50), \n",
    "        Artista VARCHAR(200), \n",
    "        Biografía VARCHAR(500), \n",
    "        Oyentes INT,\n",
    "        Reproducciones INT,\n",
    "        URL VARCHAR(50))\"\"\")\n",
    "\n",
    "    mycursor.execute(\"\"\"\n",
    "    CREATE TABLE artistas_similares(\n",
    "        ID VARCHAR(50), \n",
    "        Artista_original VARCHAR(200), \n",
    "        Artista_similar VARCHAR(200), \n",
    "        Coincidencia FLOAT)\"\"\")\n",
    "\n",
    "    mycursor.execute(\"\"\"\n",
    "    CREATE TABLE canciones(\n",
    "        ID_Artista VARCHAR(50), \n",
    "        Artista VARCHAR(200), \n",
    "        Nombre_album VARCHAR(200), \n",
    "        Nombre_canción VARCHAR(200),\n",
    "        Año_lanzamiento YEAR)\"\"\")\n",
    "\n",
    "except mysql.connector.Error as err:\n",
    "    print(err)\n",
    "    print(\"Error Code:\", err.errno)\n",
    "    print(\"SQLSTATE\", err.sqlstate)\n",
    "    print(\"Message\", err.msg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Note: you may need to restart the kernel to use updated packages.Requirement already satisfied: sqlalchemy in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (2.0.38)\n",
      "Requirement already satisfied: greenlet!=0.4.17 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from sqlalchemy) (3.1.1)\n",
      "Requirement already satisfied: typing-extensions>=4.6.0 in c:\\users\\invitadolaptop\\appdata\\local\\packages\\pythonsoftwarefoundation.python.3.11_qbz5n2kfra8p0\\localcache\\local-packages\\python311\\site-packages (from sqlalchemy) (4.12.2)\n",
      "\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "[notice] A new release of pip is available: 24.0 -> 25.0.1\n",
      "[notice] To update, run: C:\\Users\\InvitadoLaptop\\AppData\\Local\\Microsoft\\WindowsApps\\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\\python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "pip install sqlalchemy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Código para crear una linea para nuestas DATAFRAME\n",
    "\n",
    "from sqlalchemy import create_engine\n",
    "engine = create_engine('mysql+mysqlconnector://root:AlumnaAdalab@127.0.0.1/music_stream_proyecto')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Datos insertados correctamente.\n",
      "Datos insertados correctamente.\n",
      "Datos insertados correctamente.\n",
      "Datos insertados correctamente.\n"
     ]
    }
   ],
   "source": [
    "# Código para INSERTAR los DATAFREME en las TABLAS ya creadas del SQL\n",
    "\n",
    "df_albumes.to_sql('albumes', engine, if_exists='replace', index=False)\n",
    "print(\"Datos insertados correctamente.\")\n",
    "\n",
    "df_artista.to_sql('artista', engine, if_exists='replace', index=False)\n",
    "print(\"Datos insertados correctamente.\")\n",
    "\n",
    "df_artistas_similares.to_sql('artistas_similares', engine, if_exists='replace', index=False)\n",
    "print(\"Datos insertados correctamente.\")\n",
    "\n",
    "df_canciones.to_sql('canciones', engine, if_exists='replace', index=False)\n",
    "print(\"Datos insertados correctamente.\")"
   ]
  }
 ],
 "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.11.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}