18 - Ejemplos Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "!wget --no-cache -O init.py -q https://raw.githubusercontent.com/UDEA-Esp-Analitica-y-Ciencia-de-Datos/EACD-01-FUNDAMENTOS/master/init.py\n",
    "import init; init.init(force_download=False); "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ejemplos Pandas\n",
    "\n",
    "Ahora unos ejemplos usando Pandas y un [dataset the Pokemon](https://github.com/travishn/pokemon-showdown-scraper/tree/master/pokemon-data)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Leer un CSV es bastante fácil usando Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_gen1 = pd.read_csv(\"local/data/pokemon-gen1-data.csv\")\n",
    "df_gen2 = pd.read_csv(\"local/data/pokemon-gen2-data.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora podemos crear unas breves descripciones de los datos..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pokemon</th>\n",
       "      <th>Number</th>\n",
       "      <th>Type1</th>\n",
       "      <th>Type2</th>\n",
       "      <th>Ability1</th>\n",
       "      <th>Ability2</th>\n",
       "      <th>Ability3</th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Sprite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>1</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>45</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/bu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>2</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>60</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/iv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Venusaur</td>\n",
       "      <td>3</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>80</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Charmander</td>\n",
       "      <td>4</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>39</td>\n",
       "      <td>52</td>\n",
       "      <td>43</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>5</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>58</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Pokemon  Number  Type1   Type2  Ability1     Ability2 Ability3  HP  \\\n",
       "0   Bulbasaur       1  GRASS  POISON  Overgrow  Chlorophyll     none  45   \n",
       "1     Ivysaur       2  GRASS  POISON  Overgrow  Chlorophyll     none  60   \n",
       "2    Venusaur       3  GRASS  POISON  Overgrow  Chlorophyll     none  80   \n",
       "3  Charmander       4   FIRE    none     Blaze  Solar Power     none  39   \n",
       "4  Charmeleon       5   FIRE    none     Blaze  Solar Power     none  58   \n",
       "\n",
       "   Attack  Defense  Sp. Atk  Sp. Def  Speed  \\\n",
       "0      49       49       65       65     45   \n",
       "1      62       63       80       80     60   \n",
       "2      82       83      100      100     80   \n",
       "3      52       43       60       50     65   \n",
       "4      64       58       80       65     80   \n",
       "\n",
       "                                              Sprite  \n",
       "0  https://play.pokemonshowdown.com/sprites/bw/bu...  \n",
       "1  https://play.pokemonshowdown.com/sprites/bw/iv...  \n",
       "2  https://play.pokemonshowdown.com/sprites/bw/ve...  \n",
       "3  https://play.pokemonshowdown.com/sprites/bw/ch...  \n",
       "4  https://play.pokemonshowdown.com/sprites/bw/ch...  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_gen1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pokemon</th>\n",
       "      <th>Number</th>\n",
       "      <th>Type1</th>\n",
       "      <th>Type2</th>\n",
       "      <th>Ability1</th>\n",
       "      <th>Ability2</th>\n",
       "      <th>Ability3</th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Sprite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chikorita</td>\n",
       "      <td>152</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>none</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Leaf Guard</td>\n",
       "      <td>none</td>\n",
       "      <td>45</td>\n",
       "      <td>49</td>\n",
       "      <td>65</td>\n",
       "      <td>49</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bayleef</td>\n",
       "      <td>153</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>none</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Leaf Guard</td>\n",
       "      <td>none</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>80</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>60</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Meganium</td>\n",
       "      <td>154</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>none</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Leaf Guard</td>\n",
       "      <td>none</td>\n",
       "      <td>80</td>\n",
       "      <td>82</td>\n",
       "      <td>100</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/me...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cyndaquil</td>\n",
       "      <td>155</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Flash Fire</td>\n",
       "      <td>none</td>\n",
       "      <td>39</td>\n",
       "      <td>52</td>\n",
       "      <td>43</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/cy...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Quilava</td>\n",
       "      <td>156</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Flash Fire</td>\n",
       "      <td>none</td>\n",
       "      <td>58</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/qu...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Pokemon  Number  Type1 Type2  Ability1    Ability2 Ability3  HP  Attack  \\\n",
       "0  Chikorita     152  GRASS  none  Overgrow  Leaf Guard     none  45      49   \n",
       "1    Bayleef     153  GRASS  none  Overgrow  Leaf Guard     none  60      62   \n",
       "2   Meganium     154  GRASS  none  Overgrow  Leaf Guard     none  80      82   \n",
       "3  Cyndaquil     155   FIRE  none     Blaze  Flash Fire     none  39      52   \n",
       "4    Quilava     156   FIRE  none     Blaze  Flash Fire     none  58      64   \n",
       "\n",
       "   Defense  Sp. Atk  Sp. Def  Speed  \\\n",
       "0       65       49       65     45   \n",
       "1       80       63       80     60   \n",
       "2      100       83      100     80   \n",
       "3       43       60       50     65   \n",
       "4       58       80       65     80   \n",
       "\n",
       "                                              Sprite  \n",
       "0  https://play.pokemonshowdown.com/sprites/bw/ch...  \n",
       "1  https://play.pokemonshowdown.com/sprites/bw/ba...  \n",
       "2  https://play.pokemonshowdown.com/sprites/bw/me...  \n",
       "3  https://play.pokemonshowdown.com/sprites/bw/cy...  \n",
       "4  https://play.pokemonshowdown.com/sprites/bw/qu...  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_gen2.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "podemos combinar ambos datasets en uno solo, para manejarlo más fácilmente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df_gen1, df_gen2], keys=[\"gen1\", \"gen2\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Pokemon</th>\n",
       "      <th>Number</th>\n",
       "      <th>Type1</th>\n",
       "      <th>Type2</th>\n",
       "      <th>Ability1</th>\n",
       "      <th>Ability2</th>\n",
       "      <th>Ability3</th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Sprite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">gen1</th>\n",
       "      <th>0</th>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>1</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>45</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/bu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>2</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>60</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/iv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Venusaur</td>\n",
       "      <td>3</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>80</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Charmander</td>\n",
       "      <td>4</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>39</td>\n",
       "      <td>52</td>\n",
       "      <td>43</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>5</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>58</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">gen2</th>\n",
       "      <th>95</th>\n",
       "      <td>Pupitar</td>\n",
       "      <td>247</td>\n",
       "      <td>ROCK</td>\n",
       "      <td>GROUND</td>\n",
       "      <td>Shed Skin</td>\n",
       "      <td>none</td>\n",
       "      <td>none</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>70</td>\n",
       "      <td>65</td>\n",
       "      <td>70</td>\n",
       "      <td>51</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/pu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Tyranitar</td>\n",
       "      <td>248</td>\n",
       "      <td>ROCK</td>\n",
       "      <td>DARK</td>\n",
       "      <td>Sand Stream</td>\n",
       "      <td>Unnerve</td>\n",
       "      <td>none</td>\n",
       "      <td>100</td>\n",
       "      <td>134</td>\n",
       "      <td>110</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>61</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Lugia</td>\n",
       "      <td>249</td>\n",
       "      <td>PSYCHIC</td>\n",
       "      <td>FLYING</td>\n",
       "      <td>Pressure</td>\n",
       "      <td>Multiscale</td>\n",
       "      <td>none</td>\n",
       "      <td>106</td>\n",
       "      <td>90</td>\n",
       "      <td>130</td>\n",
       "      <td>90</td>\n",
       "      <td>154</td>\n",
       "      <td>110</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/lu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Ho-Oh</td>\n",
       "      <td>250</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>FLYING</td>\n",
       "      <td>Pressure</td>\n",
       "      <td>Regenerator</td>\n",
       "      <td>none</td>\n",
       "      <td>106</td>\n",
       "      <td>130</td>\n",
       "      <td>90</td>\n",
       "      <td>110</td>\n",
       "      <td>154</td>\n",
       "      <td>90</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Celebi</td>\n",
       "      <td>251</td>\n",
       "      <td>PSYCHIC</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>Natural Cure</td>\n",
       "      <td>none</td>\n",
       "      <td>none</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ce...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>251 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Pokemon  Number    Type1   Type2      Ability1     Ability2  \\\n",
       "gen1 0    Bulbasaur       1    GRASS  POISON      Overgrow  Chlorophyll   \n",
       "     1      Ivysaur       2    GRASS  POISON      Overgrow  Chlorophyll   \n",
       "     2     Venusaur       3    GRASS  POISON      Overgrow  Chlorophyll   \n",
       "     3   Charmander       4     FIRE    none         Blaze  Solar Power   \n",
       "     4   Charmeleon       5     FIRE    none         Blaze  Solar Power   \n",
       "...             ...     ...      ...     ...           ...          ...   \n",
       "gen2 95     Pupitar     247     ROCK  GROUND     Shed Skin         none   \n",
       "     96   Tyranitar     248     ROCK    DARK   Sand Stream      Unnerve   \n",
       "     97       Lugia     249  PSYCHIC  FLYING      Pressure   Multiscale   \n",
       "     98       Ho-Oh     250     FIRE  FLYING      Pressure  Regenerator   \n",
       "     99      Celebi     251  PSYCHIC   GRASS  Natural Cure         none   \n",
       "\n",
       "        Ability3   HP  Attack  Defense  Sp. Atk  Sp. Def  Speed  \\\n",
       "gen1 0      none   45      49       49       65       65     45   \n",
       "     1      none   60      62       63       80       80     60   \n",
       "     2      none   80      82       83      100      100     80   \n",
       "     3      none   39      52       43       60       50     65   \n",
       "     4      none   58      64       58       80       65     80   \n",
       "...          ...  ...     ...      ...      ...      ...    ...   \n",
       "gen2 95     none   70      84       70       65       70     51   \n",
       "     96     none  100     134      110       95      100     61   \n",
       "     97     none  106      90      130       90      154    110   \n",
       "     98     none  106     130       90      110      154     90   \n",
       "     99     none  100     100      100      100      100    100   \n",
       "\n",
       "                                                    Sprite  \n",
       "gen1 0   https://play.pokemonshowdown.com/sprites/bw/bu...  \n",
       "     1   https://play.pokemonshowdown.com/sprites/bw/iv...  \n",
       "     2   https://play.pokemonshowdown.com/sprites/bw/ve...  \n",
       "     3   https://play.pokemonshowdown.com/sprites/bw/ch...  \n",
       "     4   https://play.pokemonshowdown.com/sprites/bw/ch...  \n",
       "...                                                    ...  \n",
       "gen2 95  https://play.pokemonshowdown.com/sprites/bw/pu...  \n",
       "     96  https://play.pokemonshowdown.com/sprites/bw/ty...  \n",
       "     97  https://play.pokemonshowdown.com/sprites/bw/lu...  \n",
       "     98  https://play.pokemonshowdown.com/sprites/bw/ho...  \n",
       "     99  https://play.pokemonshowdown.com/sprites/bw/ce...  \n",
       "\n",
       "[251 rows x 14 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Honestamente, a mí me parece un poco más enredado trabajar con múltiples índices, por lo que convertiré los datos a un dataframe con un solo índice"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>generation</th>\n",
       "      <th>Pokemon</th>\n",
       "      <th>Number</th>\n",
       "      <th>Type1</th>\n",
       "      <th>Type2</th>\n",
       "      <th>Ability1</th>\n",
       "      <th>Ability2</th>\n",
       "      <th>Ability3</th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Sprite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>gen1</td>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>1</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>45</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/bu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>gen1</td>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>2</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>60</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/iv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>gen1</td>\n",
       "      <td>Venusaur</td>\n",
       "      <td>3</td>\n",
       "      <td>GRASS</td>\n",
       "      <td>POISON</td>\n",
       "      <td>Overgrow</td>\n",
       "      <td>Chlorophyll</td>\n",
       "      <td>none</td>\n",
       "      <td>80</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>gen1</td>\n",
       "      <td>Charmander</td>\n",
       "      <td>4</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>39</td>\n",
       "      <td>52</td>\n",
       "      <td>43</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>gen1</td>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>5</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>none</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>Solar Power</td>\n",
       "      <td>none</td>\n",
       "      <td>58</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>https://play.pokemonshowdown.com/sprites/bw/ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  generation     Pokemon  Number  Type1   Type2  Ability1     Ability2  \\\n",
       "0       gen1   Bulbasaur       1  GRASS  POISON  Overgrow  Chlorophyll   \n",
       "1       gen1     Ivysaur       2  GRASS  POISON  Overgrow  Chlorophyll   \n",
       "2       gen1    Venusaur       3  GRASS  POISON  Overgrow  Chlorophyll   \n",
       "3       gen1  Charmander       4   FIRE    none     Blaze  Solar Power   \n",
       "4       gen1  Charmeleon       5   FIRE    none     Blaze  Solar Power   \n",
       "\n",
       "  Ability3  HP  Attack  Defense  Sp. Atk  Sp. Def  Speed  \\\n",
       "0     none  45      49       49       65       65     45   \n",
       "1     none  60      62       63       80       80     60   \n",
       "2     none  80      82       83      100      100     80   \n",
       "3     none  39      52       43       60       50     65   \n",
       "4     none  58      64       58       80       65     80   \n",
       "\n",
       "                                              Sprite  \n",
       "0  https://play.pokemonshowdown.com/sprites/bw/bu...  \n",
       "1  https://play.pokemonshowdown.com/sprites/bw/iv...  \n",
       "2  https://play.pokemonshowdown.com/sprites/bw/ve...  \n",
       "3  https://play.pokemonshowdown.com/sprites/bw/ch...  \n",
       "4  https://play.pokemonshowdown.com/sprites/bw/ch...  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.reset_index(level=0).rename(columns={\"level_0\": \"generation\"}).reset_index().drop(columns=\"index\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "podemos sacar un breve resumen de nuestro dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "      <td>251.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>126.000000</td>\n",
       "      <td>66.908367</td>\n",
       "      <td>71.059761</td>\n",
       "      <td>68.808765</td>\n",
       "      <td>66.087649</td>\n",
       "      <td>68.577689</td>\n",
       "      <td>66.015936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>72.601653</td>\n",
       "      <td>29.794153</td>\n",
       "      <td>27.469117</td>\n",
       "      <td>30.442524</td>\n",
       "      <td>27.373277</td>\n",
       "      <td>27.480556</td>\n",
       "      <td>27.316510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>63.500000</td>\n",
       "      <td>49.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>49.500000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>126.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>65.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>188.500000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>85.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>251.000000</td>\n",
       "      <td>255.000000</td>\n",
       "      <td>134.000000</td>\n",
       "      <td>230.000000</td>\n",
       "      <td>154.000000</td>\n",
       "      <td>230.000000</td>\n",
       "      <td>150.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Number          HP      Attack     Defense     Sp. Atk     Sp. Def  \\\n",
       "count  251.000000  251.000000  251.000000  251.000000  251.000000  251.000000   \n",
       "mean   126.000000   66.908367   71.059761   68.808765   66.087649   68.577689   \n",
       "std     72.601653   29.794153   27.469117   30.442524   27.373277   27.480556   \n",
       "min      1.000000   10.000000    5.000000    5.000000   10.000000   20.000000   \n",
       "25%     63.500000   49.000000   50.000000   49.500000   45.000000   50.000000   \n",
       "50%    126.000000   65.000000   70.000000   65.000000   65.000000   65.000000   \n",
       "75%    188.500000   80.000000   90.000000   85.000000   85.000000   85.000000   \n",
       "max    251.000000  255.000000  134.000000  230.000000  154.000000  230.000000   \n",
       "\n",
       "            Speed  \n",
       "count  251.000000  \n",
       "mean    66.015936  \n",
       "std     27.316510  \n",
       "min      5.000000  \n",
       "25%     45.000000  \n",
       "50%     65.000000  \n",
       "75%     85.000000  \n",
       "max    150.000000  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A partir de este punto puedes empezar a utilizar pandas para responder las preguntas que acerca de tus datos.\n",
    "\n",
    "**¿Cuántos Pokemon hay en cada generación?***"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "generation\n",
       "gen1    151\n",
       "gen2    100\n",
       "dtype: int64"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(\"generation\").size()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**¿Cuáles son los tipos de Pokemon con mayor velocidad promedio?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Type1\n",
       "BUG         54.545455\n",
       "DARK        86.200000\n",
       "DRAGON      66.666667\n",
       "ELECTRIC    87.000000\n",
       "FAIRY       35.000000\n",
       "FIGHTING    63.111111\n",
       "FIRE        78.800000\n",
       "GHOST       92.500000\n",
       "GRASS       55.238095\n",
       "GROUND      58.181818\n",
       "ICE         70.000000\n",
       "NORMAL      66.621622\n",
       "POISON      63.533333\n",
       "PSYCHIC     87.333333\n",
       "ROCK        54.461538\n",
       "STEEL       50.000000\n",
       "WATER       63.456522\n",
       "Name: Speed, dtype: float64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(\"Type1\").mean()[\"Speed\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HP</th>\n",
       "      <th>Attack</th>\n",
       "      <th>Defense</th>\n",
       "      <th>Sp. Atk</th>\n",
       "      <th>Sp. Def</th>\n",
       "      <th>Speed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>generation</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>gen1</th>\n",
       "      <td>64.211921</td>\n",
       "      <td>72.913907</td>\n",
       "      <td>68.225166</td>\n",
       "      <td>67.139073</td>\n",
       "      <td>66.086093</td>\n",
       "      <td>69.066225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gen2</th>\n",
       "      <td>70.980000</td>\n",
       "      <td>68.260000</td>\n",
       "      <td>69.690000</td>\n",
       "      <td>64.500000</td>\n",
       "      <td>72.340000</td>\n",
       "      <td>61.410000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   HP     Attack    Defense    Sp. Atk    Sp. Def      Speed\n",
       "generation                                                                  \n",
       "gen1        64.211921  72.913907  68.225166  67.139073  66.086093  69.066225\n",
       "gen2        70.980000  68.260000  69.690000  64.500000  72.340000  61.410000"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"generation\", \"HP\", \"Attack\", \"Defense\", \"Sp. Atk\", \"Sp. Def\", \"Speed\"]].groupby(\"generation\").mean()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}