V2_Proyecto_DS_Equipo_6.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "zEm55NWpZSLI",
        "outputId": "1f534c04-d861-4f68-9a7a-c7464b75f336"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: pokebase in /usr/local/lib/python3.7/dist-packages (1.3.0)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.7/dist-packages (from pokebase) (2.23.0)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests->pokebase) (1.24.3)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests->pokebase) (3.0.4)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests->pokebase) (2.10)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests->pokebase) (2022.6.15)\n"
          ]
        }
      ],
      "source": [
        "pip install pokebase"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "MGJGxBH2aSfm"
      },
      "outputs": [],
      "source": [
        "import json\n",
        "import pandas as pd\n",
        "import pokebase as pb\n",
        "import requests\n",
        "import numpy as np\n",
        "from requests import get\n",
        "from bs4 import BeautifulSoup\n",
        "import re\n",
        "from datetime import datetime"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "K_-MQOEokz86",
        "outputId": "9e82a6ec-74e5-45c9-d88c-6bf3648b8189"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1154"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ],
      "source": [
        "#Pedimos el número total de pokemonos\n",
        "number = requests.get('https://pokeapi.co/api/v2/pokemon?limit=100000&offset=0')\n",
        "number = number.json()\n",
        "n=number['count']\n",
        "n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Pedimos el número total de generaciones\n",
        "number2 =requests.get('https://pokeapi.co/api/v2/generation')\n",
        "number2 = number2.json()\n",
        "n2=number2['count']\n",
        "n2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6Bj4KSldcWgv",
        "outputId": "3caece67-ec43-4cc5-851f-44fc574fa53a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "8"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jbZez-DbgTYc"
      },
      "outputs": [],
      "source": [
        "#Una opción para obtener los pokemons https://pokeapi.co/api/v2/pokemon?limit=100000&offset=0\n",
        "#Otra https://pokeapi.co/api/v2/generation/1\n",
        "#Por número https://pokeapi.co/api/v2/pokemon-species/2\n",
        "link='https://pokeapi.co/api/v2/'"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Obtener los movimientos de los pokemon\n",
        "ind2 = requests.get(link+'pokemon/'+str(800))\n",
        "ind2 = ind2.json()\n",
        "str(ind2['moves'][0]['move']['name'])"
      ],
      "metadata": {
        "id": "_R5yb0LwC07z",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "2b222f91-4820-4662-f17e-6dad716d6f4c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'swords-dance'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ORBEtLQZx6L_"
      },
      "outputs": [],
      "source": [
        "from pandas.core.indexes.extension import Index\n",
        "class get_pokemon:\n",
        "\n",
        "  def __init__(self, numero):\n",
        "    ind = requests.get(link+'pokemon-species/'+str(numero+1)+'/')\n",
        "    ind2 = requests.get(link+'pokemon/'+str(numero+1))\n",
        "    ind = ind.json()\n",
        "    ind2 = ind2.json()\n",
        "    self.id= ind['id']\n",
        "    self.name= ind['name']\n",
        "    self.gen= ind['generation']['name']\n",
        "    self.type=listas(ind2, 'types', 'type', 'name')\n",
        "    self.abilities=listas(ind2,'abilities', 'ability', 'name')\n",
        "    self.capture_rate=ind['capture_rate']\n",
        "    self.base_happiness=ind['base_happiness']\n",
        "    self.version_debut=''\n",
        "    self.moves=ind2['moves'][0]['move']['name']\n",
        "    self.attack=ind2['stats'][1]['base_stat']\n",
        "    self.defense=ind2['stats'][2]['base_stat']\n",
        "    self.hp=ind2['stats'][0]['base_stat']\n",
        "    self.sp_attack=ind2['stats'][3]['base_stat']\n",
        "    self.sp_defense=ind2['stats'][4]['base_stat']\n",
        "    self.speed=ind2['stats'][5]['base_stat']\n",
        "\n",
        "    if str(ind2['moves'])=='[]':\n",
        "      self.moves= np.nan\n",
        "    else:\n",
        "      self.moves=ind2['moves'][0]['move']['name']\n",
        "\n",
        "\n",
        "    #Obtenemos la clase de pokemon\n",
        "    if ind['is_baby']==True:\n",
        "      self.clase='Baby'\n",
        "    elif ind['is_legendary']==True:\n",
        "      self.clase='Legendary'\n",
        "    elif ind['is_mythical']==True:\n",
        "      self.clase='Mythical'\n",
        "    else:\n",
        "      self.clase='Común'\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "zw56Ph9e57VO"
      },
      "outputs": [],
      "source": [
        "def listas(dataf, name, dato, dato2):\n",
        "  k=dataf[name]\n",
        "  lista=[]\n",
        "  if dato2!=True:\n",
        "    for i in range(len(k)):\n",
        "      lista.append(k[i][dato][dato2])\n",
        "  else:\n",
        "    for i in range(len(k)):\n",
        "      lista.append(k[i][dato])\n",
        "  if len(lista)==1:\n",
        "    lista.append('')\n",
        "    return lista[0]\n",
        "  else:\n",
        "    lista=sorted(lista)\n",
        "    return lista"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "f_hmcDFHu8wX",
        "outputId": "a676dc32-3fee-4a27-c98a-105e1072b2d9"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0\n",
            "100\n",
            "200\n",
            "300\n",
            "400\n",
            "500\n",
            "600\n",
            "700\n",
            "800\n"
          ]
        }
      ],
      "source": [
        "data=[]\n",
        "for i in range(898):\n",
        "  datos={}\n",
        "  pokemon=get_pokemon(i)\n",
        "  datos['ID']=pokemon.id\n",
        "  datos['Gen']=pokemon.gen\n",
        "  datos['Name']=pokemon.name\n",
        "  datos['Type']=pokemon.type\n",
        "  data.append(datos)\n",
        "  if i%100==0:\n",
        "    print(i)"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Tabla de Pokémon"
      ],
      "metadata": {
        "id": "q5_G1pKxsnhX"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Crea tabla para regiones(para agregar las regiones)"
      ],
      "metadata": {
        "id": "T17khyceBGie"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Se creo esta tabla para agregar las regiones de acuerdo a las 8 generaciones.  #--copia inicio\n",
        "G1=[1,'kanto']\n",
        "G2=[2,'johto']\n",
        "G3=[3,'hoenn']\n",
        "G4=[4,'sinnoh']\n",
        "G5=[5,'unova']\n",
        "G6=[6,'kalos']\n",
        "G7=[7,'alola']\n",
        "G8=[8,'galar']\n",
        "\n",
        "lista_reg=[G1,G2,G3,G4,G5,G6,G7]\n",
        "df_region=pd.DataFrame(lista_reg,columns=['Gen','Region'])\n",
        "# copia final"
      ],
      "metadata": {
        "id": "EcC_ggb1BLEg"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "fFEERsU38Qf_"
      },
      "outputs": [],
      "source": [
        "generaciones={'generation-i':1, 'generation-ii':2, 'generation-iii':3, 'generation-iv':4,\n",
        "       'generation-v':5, 'generation-vi':6, 'generation-vii':7,\n",
        "       'generation-viii':8}"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "nm0X9itow8f6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "9872fb75-a446-426f-d38e-1ec9b8ec892b"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      ID  Gen        Name              Type\n",
              "0      1    1   bulbasaur   [grass, poison]\n",
              "1      2    1     ivysaur   [grass, poison]\n",
              "2      3    1    venusaur   [grass, poison]\n",
              "3      4    1  charmander              fire\n",
              "4      5    1  charmeleon              fire\n",
              "..   ...  ...         ...               ...\n",
              "893  894    8   regieleki          electric\n",
              "894  895    8   regidrago            dragon\n",
              "895  896    8   glastrier               ice\n",
              "896  897    8   spectrier             ghost\n",
              "897  898    8     calyrex  [grass, psychic]\n",
              "\n",
              "[898 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8802b723-a43b-4b3e-9f8d-e447264be1ff\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Gen</th>\n",
              "      <th>Name</th>\n",
              "      <th>Type</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>bulbasaur</td>\n",
              "      <td>[grass, poison]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>ivysaur</td>\n",
              "      <td>[grass, poison]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>venusaur</td>\n",
              "      <td>[grass, poison]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>charmander</td>\n",
              "      <td>fire</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>charmeleon</td>\n",
              "      <td>fire</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>893</th>\n",
              "      <td>894</td>\n",
              "      <td>8</td>\n",
              "      <td>regieleki</td>\n",
              "      <td>electric</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>894</th>\n",
              "      <td>895</td>\n",
              "      <td>8</td>\n",
              "      <td>regidrago</td>\n",
              "      <td>dragon</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>895</th>\n",
              "      <td>896</td>\n",
              "      <td>8</td>\n",
              "      <td>glastrier</td>\n",
              "      <td>ice</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>896</th>\n",
              "      <td>897</td>\n",
              "      <td>8</td>\n",
              "      <td>spectrier</td>\n",
              "      <td>ghost</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>897</th>\n",
              "      <td>898</td>\n",
              "      <td>8</td>\n",
              "      <td>calyrex</td>\n",
              "      <td>[grass, psychic]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>898 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8802b723-a43b-4b3e-9f8d-e447264be1ff')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-8802b723-a43b-4b3e-9f8d-e447264be1ff button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-8802b723-a43b-4b3e-9f8d-e447264be1ff');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ],
      "source": [
        "tabla1=pd.DataFrame(data)\n",
        "tabla1['Gen'].replace(generaciones, inplace= True)\n",
        "tabla1"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "new1 = tabla1.set_index('ID')"
      ],
      "metadata": {
        "id": "6TDsVztt_oSQ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "new1.to_csv('tabla_de_pokemon')"
      ],
      "metadata": {
        "id": "oTVyJjlW_s06"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Tabla Características"
      ],
      "metadata": {
        "id": "Y01-O40u1hDu"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Se van a juntar la tabla de caracteristicas y de region para generar la Tabla de caracteristicas que ocupamos con el dato de region."
      ],
      "metadata": {
        "id": "AqehMcdrNWIV"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "B6_-bZsKa8mW",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "32483e84-372b-4c73-b06b-8334dc4be1a4"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0\n",
            "100\n",
            "200\n",
            "300\n",
            "400\n",
            "500\n",
            "600\n",
            "700\n",
            "800\n"
          ]
        }
      ],
      "source": [
        "data1=[]\n",
        "for i in range(898):\n",
        "  datos1={}\n",
        "  pokemon=get_pokemon(i)\n",
        "  datos1['ID']=pokemon.id\n",
        "  datos1['Clase']=pokemon.clase\n",
        "  datos1['TasaDeCaptura']=pokemon.capture_rate\n",
        "  datos1['Felicidad']=pokemon.base_happiness\n",
        "  datos1['Habilidades']=pokemon.abilities\n",
        "  datos1['Gen']=pokemon.gen #--copia\n",
        "  data1.append(datos1)\n",
        "  if i%100==0:\n",
        "    print(i)\n",
        "tabla2=pd.DataFrame(data1)\n",
        "tabla2['Gen'].replace(generaciones, inplace= True) #copia\n",
        "tabla2_p1=pd.merge(tabla2 ,df_region, on='Gen')#copia\n",
        "#tabla2_final=tabla2_n.drop(['Gen'],axis=1)#copia\n",
        "#copia (solo para visualizar la tabla)\n"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# WebScraping para tabla de características"
      ],
      "metadata": {
        "id": "qWc5YnDU32XT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "url=\"https://press.pokemon.com/en/Items/Schedule/Video-Game?types=2\""
      ],
      "metadata": {
        "id": "rIeR_nAm4Aco"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "response=get(url)\n",
        "mysoup=BeautifulSoup(response.text,'html.parser')"
      ],
      "metadata": {
        "id": "MsL_Q7k34Csv"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "mysoup.find('p')\n",
        "mysoup.find('div')\n",
        "mysoup.find(id='p')\n",
        "tabla=mysoup.find_all(\"div\",class_=\"tableScheduleContainer\")\n",
        "tabla_pok=mysoup.find(\"div\",id=\"footerBg\")\n",
        "tabla_pok=mysoup.find(\"div\",class_=\"tableScheduleContainer\")\n",
        "tabla_pok=str(tabla_pok)\n",
        "tabla_pok"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 122
        },
        "id": "Y0uXVaty4FsY",
        "outputId": "07a52ee9-5b49-4b18-9514-d45c12dbf147"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'<div class=\"tableScheduleContainer\">\\n<div class=\"loadingOuter big jq-loading\"><div class=\"loadingBg\"><div class=\"loadingInner\"></div></div></div>\\n<table class=\"tableSchedule table table-hover jq-table-row-click jq-scheduleHistory\">\\n<thead>\\n<tr>\\n<th class=\"th-prod\">\\n<a class=\"sortable jq-sortable\" data-sortby=\"Product\" href=\"#\">\\r\\n            Product\\r\\n\\t\\t\\t<span class=\"sort\">\\n<span aria-hidden=\"true\" class=\"sort-none fa fa-sort\"></span>\\n<span aria-hidden=\"true\" class=\"sort-asc fa fa-sort-alpha-asc\"></span>\\n<span aria-hidden=\"true\" class=\"sort-desc fa fa-sort-alpha-desc\"></span>\\n</span>\\n</a>\\n</th>\\n<th class=\"th-plat\">\\n<a class=\"sortable jq-sortable\" data-sortby=\"Format\" href=\"#\">\\n<span>Available Platforms</span>\\n<span class=\"sort\">\\n<span aria-hidden=\"true\" class=\"sort-none fa fa-sort\"></span>\\n<span aria-hidden=\"true\" class=\"sort-asc fa fa-sort-alpha-asc\"></span>\\n<span aria-hidden=\"true\" class=\"sort-desc fa fa-sort-alpha-desc\"></span>\\n</span>\\n</a>\\n</th>\\n<th class=\"th-date\">\\n<a class=\"sortable jq-sortable sorted sortreverse \" data-sortby=\"Date\" href=\"#\">\\n<span>Release date</span>\\n<span class=\"sort\">\\n<span aria-hidden=\"true\" class=\"sort-none fa fa-sort\"></span>\\n<span aria-hidden=\"true\" class=\"sort-asc fa fa-sort-numeric-asc\"></span>\\n<span aria-hidden=\"true\" class=\"sort-desc fa fa-sort-numeric-desc\"></span>\\n</span>\\n</a>\\n</th>\\n<tbody>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Scarlet-and-Pokemon-Violet\">Pokémon Scarlet and Pokémon Violet</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\n2022\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Legends-Arceus\">Pokémon Legends: Arceus</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\n2022\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Brilliant-Diamond-and-Pokemon-Shining-Pearl\">Pokémon Brilliant Diamond and Pokémon Shining Pearl</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\n2021\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-UNITE\">Pokémon UNITE</a>\\n</td>\\n<td class=\"td-plat\"> Android, iOS, Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nJul 2021\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/New-Pokemon-Snap\">New Pokémon Snap</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nApril 30, 2021\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Sword-Expansion-Pass-Pokemon-Shield-Expansion-Pass\">Pokémon Sword Expansion Pass and Pokémon Shield Expansion Pass</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nJun 2020\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Cafe-Mix\">Pokémon Café Mix</a>\\n</td>\\n<td class=\"td-plat\"> Android, iOS, Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nJune 24, 2020\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Mystery-Dungeon-Rescue-Team-DX\">Pokémon Mystery Dungeon: Rescue Team DX</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nMarch 6, 2020\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Sword-and-Pokemon-Shield\">Pokémon Sword and Pokémon Shield</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nNovember 15, 2019\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Lets-Go-Pikachu-Pokemon-Lets-Go-Eevee\">Pokémon: Let\\'s Go, Pikachu! and Pokémon: Let\\'s Go, Eevee!</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nNovember 16, 2018\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Quest\">Pokémon Quest (Nintendo Switch)</a>\\n</td>\\n<td class=\"td-plat\"> Android, iOS, Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nMay 29, 2018\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Detective-Pikachu-96765\">Detective Pikachu</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo 3DS</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nMarch 23, 2018\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Ultra-Sun-and-Pokemon-Ultra-Moon\">Pokémon Ultra Sun and Pokémon Ultra Moon</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo 3DS</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nNovember 17, 2017\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokken-Tournament-DX\">Pokkén Tournament DX</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo Switch</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nSeptember 22, 2017\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Sun-and-Pokemon-Moon\">Pokémon Sun and Pokémon Moon</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo 3DS</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nNovember 18, 2016\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Super-Mystery-Dungeon\">Pokémon Super Mystery Dungeon</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo 3DS</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nNovember 20, 2015\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Shuffle\">Pokémon Shuffle</a>\\n</td>\\n<td class=\"td-plat\"> Nintendo 3DS</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nFebruary 18, 2015\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Yellow\">Pokémon Yellow</a>\\n</td>\\n<td class=\"td-plat\"> Game Boy, Virtual Console</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nOctober 25, 1999\\r\\n\\t</td>\\n</tr>\\n<tr class=\"\">\\n<td class=\"td-prod\">\\n<a class=\"prod-name\" href=\"/en/products/Pokemon-Blue\">Pokémon Red and Pokémon Blue</a>\\n</td>\\n<td class=\"td-plat\"> Game Boy, Virtual Console</td>\\n<td class=\"td-date\">\\r\\n\\t\\r\\nSeptember 28, 1998\\r\\n\\t</td>\\n</tr><!-- EOF -->\\n<script>\\r\\n\\t$(function () {\\r\\n\\t\\tif (typeof schedule !== \"undefined\") {\\r\\n\\t\\t\\tschedule.updateUserCounts(\\'1\\', \\'19\\', \\'19\\');\\r\\n\\t\\t}\\r\\n\\t})\\r\\n</script>\\n<tr class=\"jq-ajaxplaceholder jq-keep\" data-pagerevent=\"\" id=\"placeholder-e8bd1244-53c4-45de-a4d1-d6ed0894ac71\" style=\"display:none\"></tr>\\n</tbody>\\n</tr></thead></table>\\n<div class=\"jq-noProducts schedule-no-results\" style=\"display: none\">\\n<span>No results found</span>\\n</div>\\n</div>'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "tabla_pok=re.sub(r'<.*?>',lambda g:g.group(0).upper(),tabla_pok)"
      ],
      "metadata": {
        "id": "Ovi1vOzj4HrH"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df=pd.read_html(tabla_pok)[0]\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 677
        },
        "id": "3G4fDrct4I9q",
        "outputId": "5e78bbb2-61e3-4c0b-a587-57e5f034bf30"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                              Product  \\\n",
              "0                  Pokémon Scarlet and Pokémon Violet   \n",
              "1                             Pokémon Legends: Arceus   \n",
              "2   Pokémon Brilliant Diamond and Pokémon Shining ...   \n",
              "3                                       Pokémon UNITE   \n",
              "4                                    New Pokémon Snap   \n",
              "5   Pokémon Sword Expansion Pass and Pokémon Shiel...   \n",
              "6                                    Pokémon Café Mix   \n",
              "7             Pokémon Mystery Dungeon: Rescue Team DX   \n",
              "8                    Pokémon Sword and Pokémon Shield   \n",
              "9   Pokémon: Let's Go, Pikachu! and Pokémon: Let's...   \n",
              "10                    Pokémon Quest (Nintendo Switch)   \n",
              "11                                  Detective Pikachu   \n",
              "12           Pokémon Ultra Sun and Pokémon Ultra Moon   \n",
              "13                               Pokkén Tournament DX   \n",
              "14                       Pokémon Sun and Pokémon Moon   \n",
              "15                      Pokémon Super Mystery Dungeon   \n",
              "16                                    Pokémon Shuffle   \n",
              "17                                     Pokémon Yellow   \n",
              "18                       Pokémon Red and Pokémon Blue   \n",
              "19                                                NaN   \n",
              "\n",
              "              Available Platforms        Release date  \n",
              "0                 Nintendo Switch                2022  \n",
              "1                 Nintendo Switch                2022  \n",
              "2                 Nintendo Switch                2021  \n",
              "3   Android, iOS, Nintendo Switch            Jul 2021  \n",
              "4                 Nintendo Switch      April 30, 2021  \n",
              "5                 Nintendo Switch            Jun 2020  \n",
              "6   Android, iOS, Nintendo Switch       June 24, 2020  \n",
              "7                 Nintendo Switch       March 6, 2020  \n",
              "8                 Nintendo Switch   November 15, 2019  \n",
              "9                 Nintendo Switch   November 16, 2018  \n",
              "10  Android, iOS, Nintendo Switch        May 29, 2018  \n",
              "11                   Nintendo 3DS      March 23, 2018  \n",
              "12                   Nintendo 3DS   November 17, 2017  \n",
              "13                Nintendo Switch  September 22, 2017  \n",
              "14                   Nintendo 3DS   November 18, 2016  \n",
              "15                   Nintendo 3DS   November 20, 2015  \n",
              "16                   Nintendo 3DS   February 18, 2015  \n",
              "17      Game Boy, Virtual Console    October 25, 1999  \n",
              "18      Game Boy, Virtual Console  September 28, 1998  \n",
              "19                            NaN                 NaN  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3c837863-27ec-4c52-afb8-4240002b6508\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Product</th>\n",
              "      <th>Available Platforms</th>\n",
              "      <th>Release date</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Pokémon Scarlet and Pokémon Violet</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Pokémon Legends: Arceus</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Pokémon Brilliant Diamond and Pokémon Shining ...</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>2021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Pokémon UNITE</td>\n",
              "      <td>Android, iOS, Nintendo Switch</td>\n",
              "      <td>Jul 2021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>New Pokémon Snap</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>April 30, 2021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Pokémon Sword Expansion Pass and Pokémon Shiel...</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>Jun 2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Pokémon Café Mix</td>\n",
              "      <td>Android, iOS, Nintendo Switch</td>\n",
              "      <td>June 24, 2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Pokémon Mystery Dungeon: Rescue Team DX</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>March 6, 2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Pokémon Sword and Pokémon Shield</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>November 15, 2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Pokémon: Let's Go, Pikachu! and Pokémon: Let's...</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Pokémon Quest (Nintendo Switch)</td>\n",
              "      <td>Android, iOS, Nintendo Switch</td>\n",
              "      <td>May 29, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Detective Pikachu</td>\n",
              "      <td>Nintendo 3DS</td>\n",
              "      <td>March 23, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Pokémon Ultra Sun and Pokémon Ultra Moon</td>\n",
              "      <td>Nintendo 3DS</td>\n",
              "      <td>November 17, 2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Pokkén Tournament DX</td>\n",
              "      <td>Nintendo Switch</td>\n",
              "      <td>September 22, 2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Pokémon Sun and Pokémon Moon</td>\n",
              "      <td>Nintendo 3DS</td>\n",
              "      <td>November 18, 2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Pokémon Super Mystery Dungeon</td>\n",
              "      <td>Nintendo 3DS</td>\n",
              "      <td>November 20, 2015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Pokémon Shuffle</td>\n",
              "      <td>Nintendo 3DS</td>\n",
              "      <td>February 18, 2015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Pokémon Yellow</td>\n",
              "      <td>Game Boy, Virtual Console</td>\n",
              "      <td>October 25, 1999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Pokémon Red and Pokémon Blue</td>\n",
              "      <td>Game Boy, Virtual Console</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3c837863-27ec-4c52-afb8-4240002b6508')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3c837863-27ec-4c52-afb8-4240002b6508 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3c837863-27ec-4c52-afb8-4240002b6508');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "tabla_fechas=df.drop([19],axis=0)\n"
      ],
      "metadata": {
        "id": "pV2gCNYn4LRf"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "tabla_fechas.insert(3,\"Gen\",[8,8,8,8,8,8,8,7,7,7,6,5,5,4,4,4,2,2,1])\n",
        "new_table=tabla_fechas.drop([\"Product\",\"Available Platforms\"],axis=1)\n",
        "new_table.loc[19]=[ 'November 11,2022',3]\n"
      ],
      "metadata": {
        "id": "vDvSiJVb4eTA"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "new_table=new_table.drop([1, 2, 3,4,5,7,8,11,13,14,16],axis=0)\n",
        "new_table"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 332
        },
        "id": "PgWJAj24-jgw",
        "outputId": "9cf7b8c9-10ce-4ebf-d115-ddf8ddb58dae"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          Release date  Gen\n",
              "0                 2022    8\n",
              "6        June 24, 2020    8\n",
              "9    November 16, 2018    7\n",
              "10        May 29, 2018    6\n",
              "12   November 17, 2017    5\n",
              "15   November 20, 2015    4\n",
              "17    October 25, 1999    2\n",
              "18  September 28, 1998    1\n",
              "19    November 11,2022    3"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9f18f052-8ce3-422f-a11c-8655496a6fc0\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Release date</th>\n",
              "      <th>Gen</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>June 24, 2020</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>November 16, 2018</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>May 29, 2018</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>November 17, 2017</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>November 20, 2015</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>October 25, 1999</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>September 28, 1998</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>November 11,2022</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9f18f052-8ce3-422f-a11c-8655496a6fc0')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9f18f052-8ce3-422f-a11c-8655496a6fc0 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9f18f052-8ce3-422f-a11c-8655496a6fc0');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Funcionamos ambas tablas"
      ],
      "metadata": {
        "id": "BTrLtcBN4naX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "tabla2_final=pd.merge(tabla2_p1 ,new_table, on='Gen')\n",
        "tabla2_final=tabla2_final.drop(['Gen'],axis=1)"
      ],
      "metadata": {
        "id": "hhUnspgc4rFw"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "new2 = tabla2_final.set_index('ID')\n",
        "new2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 311
        },
        "id": "_A4hp7x5xKAo",
        "outputId": "5a35a666-8060-4c88-c606-0c5b732a5dca"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        Clase  TasaDeCaptura  Felicidad              Habilidades Region  \\\n",
              "ID                                                                        \n",
              "1       Común             45         50  [chlorophyll, overgrow]  kanto   \n",
              "2       Común             45         50  [chlorophyll, overgrow]  kanto   \n",
              "3       Común             45         50  [chlorophyll, overgrow]  kanto   \n",
              "4       Común             45         50     [blaze, solar-power]  kanto   \n",
              "5       Común             45         50     [blaze, solar-power]  kanto   \n",
              "..        ...            ...        ...                      ...    ...   \n",
              "805     Común             30          0              beast-boost  alola   \n",
              "806     Común             30          0              beast-boost  alola   \n",
              "807  Mythical              3          0              volt-absorb  alola   \n",
              "808  Mythical              3          0              magnet-pull  alola   \n",
              "809  Mythical              3          0                iron-fist  alola   \n",
              "\n",
              "           Release date  \n",
              "ID                       \n",
              "1    September 28, 1998  \n",
              "2    September 28, 1998  \n",
              "3    September 28, 1998  \n",
              "4    September 28, 1998  \n",
              "5    September 28, 1998  \n",
              "..                  ...  \n",
              "805   November 16, 2018  \n",
              "806   November 16, 2018  \n",
              "807   November 16, 2018  \n",
              "808   November 16, 2018  \n",
              "809   November 16, 2018  \n",
              "\n",
              "[809 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-177bf8bf-d039-43e1-95c6-d73f1abc0909\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Clase</th>\n",
              "      <th>TasaDeCaptura</th>\n",
              "      <th>Felicidad</th>\n",
              "      <th>Habilidades</th>\n",
              "      <th>Region</th>\n",
              "      <th>Release date</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ID</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Común</td>\n",
              "      <td>45</td>\n",
              "      <td>50</td>\n",
              "      <td>[chlorophyll, overgrow]</td>\n",
              "      <td>kanto</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Común</td>\n",
              "      <td>45</td>\n",
              "      <td>50</td>\n",
              "      <td>[chlorophyll, overgrow]</td>\n",
              "      <td>kanto</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Común</td>\n",
              "      <td>45</td>\n",
              "      <td>50</td>\n",
              "      <td>[chlorophyll, overgrow]</td>\n",
              "      <td>kanto</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Común</td>\n",
              "      <td>45</td>\n",
              "      <td>50</td>\n",
              "      <td>[blaze, solar-power]</td>\n",
              "      <td>kanto</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Común</td>\n",
              "      <td>45</td>\n",
              "      <td>50</td>\n",
              "      <td>[blaze, solar-power]</td>\n",
              "      <td>kanto</td>\n",
              "      <td>September 28, 1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>805</th>\n",
              "      <td>Común</td>\n",
              "      <td>30</td>\n",
              "      <td>0</td>\n",
              "      <td>beast-boost</td>\n",
              "      <td>alola</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>806</th>\n",
              "      <td>Común</td>\n",
              "      <td>30</td>\n",
              "      <td>0</td>\n",
              "      <td>beast-boost</td>\n",
              "      <td>alola</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>807</th>\n",
              "      <td>Mythical</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>volt-absorb</td>\n",
              "      <td>alola</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>808</th>\n",
              "      <td>Mythical</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>magnet-pull</td>\n",
              "      <td>alola</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>809</th>\n",
              "      <td>Mythical</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>iron-fist</td>\n",
              "      <td>alola</td>\n",
              "      <td>November 16, 2018</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>809 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-177bf8bf-d039-43e1-95c6-d73f1abc0909')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-177bf8bf-d039-43e1-95c6-d73f1abc0909 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-177bf8bf-d039-43e1-95c6-d73f1abc0909');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "new2.to_csv('tabla_caractiristicas')"
      ],
      "metadata": {
        "id": "6UOTO5oKxJ9O"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "tabla2.info()"
      ],
      "metadata": {
        "id": "PlUtkTJgxJ7Z",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "7e9bcf69-7ebe-4df0-b185-26a438a22de2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 898 entries, 0 to 897\n",
            "Data columns (total 6 columns):\n",
            " #   Column         Non-Null Count  Dtype \n",
            "---  ------         --------------  ----- \n",
            " 0   ID             898 non-null    int64 \n",
            " 1   Clase          898 non-null    object\n",
            " 2   TasaDeCaptura  898 non-null    int64 \n",
            " 3   Felicidad      898 non-null    int64 \n",
            " 4   Habilidades    898 non-null    object\n",
            " 5   Gen            898 non-null    int64 \n",
            "dtypes: int64(4), object(2)\n",
            "memory usage: 42.2+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "hB6fnFuCxJ48"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Tabla Estadísticas"
      ],
      "metadata": {
        "id": "WAcYBmo4AYCt"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "f6vd2-52jjCj",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 580
        },
        "outputId": "b331ac80-ca1e-4c4f-a020-32658a17df32"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0\n",
            "100\n",
            "200\n",
            "300\n",
            "400\n",
            "500\n",
            "600\n",
            "700\n",
            "800\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      ID    Movimiento  Ataque  Defensa   HP  Ataque_especial  \\\n",
              "0      1    razor-wind      49       49   45               65   \n",
              "1      2  swords-dance      62       63   60               80   \n",
              "2      3  swords-dance      82       83   80              100   \n",
              "3      4    mega-punch      52       43   39               60   \n",
              "4      5    mega-punch      64       58   58               80   \n",
              "..   ...           ...     ...      ...  ...              ...   \n",
              "893  894     body-slam     100       50   80              100   \n",
              "894  895     vice-grip     100       50  200              100   \n",
              "895  896  swords-dance     145      130  100               65   \n",
              "896  897         stomp      65       60  100              145   \n",
              "897  898         pound      80       80  100               80   \n",
              "\n",
              "     Defensa_especial  Velocidad  \n",
              "0                  65         45  \n",
              "1                  80         60  \n",
              "2                 100         80  \n",
              "3                  50         65  \n",
              "4                  65         80  \n",
              "..                ...        ...  \n",
              "893                50        200  \n",
              "894                50         80  \n",
              "895               110         30  \n",
              "896                80        130  \n",
              "897                80         80  \n",
              "\n",
              "[898 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5ad5c47c-e276-43d2-9a3c-2d9a40327f3d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Movimiento</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>HP</th>\n",
              "      <th>Ataque_especial</th>\n",
              "      <th>Defensa_especial</th>\n",
              "      <th>Velocidad</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>razor-wind</td>\n",
              "      <td>49</td>\n",
              "      <td>49</td>\n",
              "      <td>45</td>\n",
              "      <td>65</td>\n",
              "      <td>65</td>\n",
              "      <td>45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>swords-dance</td>\n",
              "      <td>62</td>\n",
              "      <td>63</td>\n",
              "      <td>60</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>swords-dance</td>\n",
              "      <td>82</td>\n",
              "      <td>83</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>mega-punch</td>\n",
              "      <td>52</td>\n",
              "      <td>43</td>\n",
              "      <td>39</td>\n",
              "      <td>60</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>mega-punch</td>\n",
              "      <td>64</td>\n",
              "      <td>58</td>\n",
              "      <td>58</td>\n",
              "      <td>80</td>\n",
              "      <td>65</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>893</th>\n",
              "      <td>894</td>\n",
              "      <td>body-slam</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>894</th>\n",
              "      <td>895</td>\n",
              "      <td>vice-grip</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>200</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>895</th>\n",
              "      <td>896</td>\n",
              "      <td>swords-dance</td>\n",
              "      <td>145</td>\n",
              "      <td>130</td>\n",
              "      <td>100</td>\n",
              "      <td>65</td>\n",
              "      <td>110</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>896</th>\n",
              "      <td>897</td>\n",
              "      <td>stomp</td>\n",
              "      <td>65</td>\n",
              "      <td>60</td>\n",
              "      <td>100</td>\n",
              "      <td>145</td>\n",
              "      <td>80</td>\n",
              "      <td>130</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>897</th>\n",
              "      <td>898</td>\n",
              "      <td>pound</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>898 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5ad5c47c-e276-43d2-9a3c-2d9a40327f3d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5ad5c47c-e276-43d2-9a3c-2d9a40327f3d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5ad5c47c-e276-43d2-9a3c-2d9a40327f3d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 54
        }
      ],
      "source": [
        "data2=[]\n",
        "for i in range(898):\n",
        "  datos2={}\n",
        "  pokemon=get_pokemon(i)\n",
        "  datos2['ID']=pokemon.id\n",
        "  datos2['Movimiento']=pokemon.moves\n",
        "  datos2['Ataque']=pokemon.attack\n",
        "  datos2['Defensa']=pokemon.defense\n",
        "  datos2['HP']=pokemon.hp\n",
        "  datos2['Ataque_especial']=pokemon.sp_attack\n",
        "  datos2['Defensa_especial']=pokemon.sp_defense\n",
        "  datos2['Velocidad']=pokemon.speed\n",
        "  data2.append(datos2)\n",
        "  if i%100==0:\n",
        "    print(i)\n",
        "\n",
        "tabla3=pd.DataFrame(data2)\n",
        "tabla3"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "new3 = tabla3.set_index('ID')\n",
        "new3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "zIq2eT5I_PI9",
        "outputId": "ed395acc-9231-4ba1-eccf-19f43c390cc1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Movimiento  Ataque  Defensa   HP  Ataque_especial  Defensa_especial  \\\n",
              "ID                                                                           \n",
              "1      razor-wind      49       49   45               65                65   \n",
              "2    swords-dance      62       63   60               80                80   \n",
              "3    swords-dance      82       83   80              100               100   \n",
              "4      mega-punch      52       43   39               60                50   \n",
              "5      mega-punch      64       58   58               80                65   \n",
              "..            ...     ...      ...  ...              ...               ...   \n",
              "894     body-slam     100       50   80              100                50   \n",
              "895     vice-grip     100       50  200              100                50   \n",
              "896  swords-dance     145      130  100               65               110   \n",
              "897         stomp      65       60  100              145                80   \n",
              "898         pound      80       80  100               80                80   \n",
              "\n",
              "     Velocidad  \n",
              "ID              \n",
              "1           45  \n",
              "2           60  \n",
              "3           80  \n",
              "4           65  \n",
              "5           80  \n",
              "..         ...  \n",
              "894        200  \n",
              "895         80  \n",
              "896         30  \n",
              "897        130  \n",
              "898         80  \n",
              "\n",
              "[898 rows x 7 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-86eb5cf2-4c91-4e86-ada5-5986d6f1a54b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Movimiento</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>HP</th>\n",
              "      <th>Ataque_especial</th>\n",
              "      <th>Defensa_especial</th>\n",
              "      <th>Velocidad</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ID</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>razor-wind</td>\n",
              "      <td>49</td>\n",
              "      <td>49</td>\n",
              "      <td>45</td>\n",
              "      <td>65</td>\n",
              "      <td>65</td>\n",
              "      <td>45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>swords-dance</td>\n",
              "      <td>62</td>\n",
              "      <td>63</td>\n",
              "      <td>60</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>swords-dance</td>\n",
              "      <td>82</td>\n",
              "      <td>83</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>mega-punch</td>\n",
              "      <td>52</td>\n",
              "      <td>43</td>\n",
              "      <td>39</td>\n",
              "      <td>60</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>mega-punch</td>\n",
              "      <td>64</td>\n",
              "      <td>58</td>\n",
              "      <td>58</td>\n",
              "      <td>80</td>\n",
              "      <td>65</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>894</th>\n",
              "      <td>body-slam</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>895</th>\n",
              "      <td>vice-grip</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>200</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>896</th>\n",
              "      <td>swords-dance</td>\n",
              "      <td>145</td>\n",
              "      <td>130</td>\n",
              "      <td>100</td>\n",
              "      <td>65</td>\n",
              "      <td>110</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>897</th>\n",
              "      <td>stomp</td>\n",
              "      <td>65</td>\n",
              "      <td>60</td>\n",
              "      <td>100</td>\n",
              "      <td>145</td>\n",
              "      <td>80</td>\n",
              "      <td>130</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>898</th>\n",
              "      <td>pound</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>898 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-86eb5cf2-4c91-4e86-ada5-5986d6f1a54b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-86eb5cf2-4c91-4e86-ada5-5986d6f1a54b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-86eb5cf2-4c91-4e86-ada5-5986d6f1a54b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "new3.to_csv('tabla_estadistica')"
      ],
      "metadata": {
        "id": "fjDq-83N_YfZ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "tabla3.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "MAaSxil0ki2U",
        "outputId": "e233d190-4453-4e0e-d5d4-3aa0c7ec1858"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 898 entries, 0 to 897\n",
            "Data columns (total 8 columns):\n",
            " #   Column            Non-Null Count  Dtype \n",
            "---  ------            --------------  ----- \n",
            " 0   ID                898 non-null    int64 \n",
            " 1   Movimiento        898 non-null    object\n",
            " 2   Ataque            898 non-null    int64 \n",
            " 3   Defensa           898 non-null    int64 \n",
            " 4   HP                898 non-null    int64 \n",
            " 5   Ataque_especial   898 non-null    int64 \n",
            " 6   Defensa_especial  898 non-null    int64 \n",
            " 7   Velocidad         898 non-null    int64 \n",
            "dtypes: int64(7), object(1)\n",
            "memory usage: 56.2+ KB\n"
          ]
        }
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}