2018-05-12_Pandas_UFABC.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = [\n",
    "  [\"Danilo\", 2],\n",
    "  [\"Daniel\", 17],\n",
    "  [\"Amanda\", 5],\n",
    "  [\"Bruna\", 8],\n",
    "  [\"Bruno\", 7],\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Danilo</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daniel</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amanda</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bruna</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bruno</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        0   1\n",
       "0  Danilo   2\n",
       "1  Daniel  17\n",
       "2  Amanda   5\n",
       "3   Bruna   8\n",
       "4   Bruno   7"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>hours</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Danilo</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daniel</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amanda</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bruna</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bruno</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     name  hours\n",
       "0  Danilo      2\n",
       "1  Daniel     17\n",
       "2  Amanda      5\n",
       "3   Bruna      8\n",
       "4   Bruno      7"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe = pd.DataFrame(data, columns=[\"name\", \"hours\"])\n",
    "dframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     2\n",
       "1    17\n",
       "2     5\n",
       "3     8\n",
       "4     7\n",
       "Name: hours, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe[\"hours\"] # Series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>name</th>\n",
       "      <th>hours</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>a</th>\n",
       "      <td>Danilo</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f</th>\n",
       "      <td>Daniel</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c</th>\n",
       "      <td>Amanda</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d</th>\n",
       "      <td>Bruna</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>Bruno</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     name  hours\n",
       "a  Danilo      2\n",
       "f  Daniel     17\n",
       "c  Amanda      5\n",
       "d   Bruna      8\n",
       "b   Bruno      7"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idframe = pd.DataFrame(data,\n",
    "    columns=[\"name\", \"hours\"],\n",
    "    index=[\"a\", \"f\", \"c\", \"d\", \"b\"],\n",
    ")\n",
    "idframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hours    7.8\n",
       "dtype: float64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idframe.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>a</th>\n",
       "      <th>b</th>\n",
       "      <th>c</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.211055</td>\n",
       "      <td>0.413749</td>\n",
       "      <td>0.028429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.247330</td>\n",
       "      <td>0.939611</td>\n",
       "      <td>0.375886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.546861</td>\n",
       "      <td>0.786546</td>\n",
       "      <td>0.585931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.908450</td>\n",
       "      <td>0.783217</td>\n",
       "      <td>0.570994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.257523</td>\n",
       "      <td>0.460104</td>\n",
       "      <td>0.265770</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          a         b         c\n",
       "0  0.211055  0.413749  0.028429\n",
       "1  0.247330  0.939611  0.375886\n",
       "2  0.546861  0.786546  0.585931\n",
       "3  0.908450  0.783217  0.570994\n",
       "4  0.257523  0.460104  0.265770"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(np.random.rand(5, 3),\n",
    "                  columns=[\"a\", \"b\", \"c\"])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "a    0.434244\n",
       "b    0.676645\n",
       "c    0.365402\n",
       "dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>a</th>\n",
       "      <th>b</th>\n",
       "      <th>c</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.434244</td>\n",
       "      <td>0.676645</td>\n",
       "      <td>0.365402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.297294</td>\n",
       "      <td>0.228359</td>\n",
       "      <td>0.231564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.211055</td>\n",
       "      <td>0.413749</td>\n",
       "      <td>0.028429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.247330</td>\n",
       "      <td>0.460104</td>\n",
       "      <td>0.265770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.257523</td>\n",
       "      <td>0.783217</td>\n",
       "      <td>0.375886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.546861</td>\n",
       "      <td>0.786546</td>\n",
       "      <td>0.570994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>0.908450</td>\n",
       "      <td>0.939611</td>\n",
       "      <td>0.585931</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              a         b         c\n",
       "count  5.000000  5.000000  5.000000\n",
       "mean   0.434244  0.676645  0.365402\n",
       "std    0.297294  0.228359  0.231564\n",
       "min    0.211055  0.413749  0.028429\n",
       "25%    0.247330  0.460104  0.265770\n",
       "50%    0.257523  0.783217  0.375886\n",
       "75%    0.546861  0.786546  0.570994\n",
       "max    0.908450  0.939611  0.585931"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"https://pokemondb.net/pokedex/all\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "tables = pd.read_html(requests.get(url).text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "list"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(tables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Name</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total</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>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>318</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>405</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Venusaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>525</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>VenusaurMega Venusaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>625</td>\n",
       "      <td>80</td>\n",
       "      <td>100</td>\n",
       "      <td>123</td>\n",
       "      <td>122</td>\n",
       "      <td>120</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Charmander</td>\n",
       "      <td>Fire</td>\n",
       "      <td>309</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>Fire</td>\n",
       "      <td>405</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Charizard</td>\n",
       "      <td>FireFlying</td>\n",
       "      <td>534</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "      <td>109</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard X</td>\n",
       "      <td>FireDragon</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>130</td>\n",
       "      <td>111</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard Y</td>\n",
       "      <td>FireFlying</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>104</td>\n",
       "      <td>78</td>\n",
       "      <td>159</td>\n",
       "      <td>115</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7</td>\n",
       "      <td>Squirtle</td>\n",
       "      <td>Water</td>\n",
       "      <td>314</td>\n",
       "      <td>44</td>\n",
       "      <td>48</td>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8</td>\n",
       "      <td>Wartortle</td>\n",
       "      <td>Water</td>\n",
       "      <td>405</td>\n",
       "      <td>59</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>9</td>\n",
       "      <td>Blastoise</td>\n",
       "      <td>Water</td>\n",
       "      <td>530</td>\n",
       "      <td>79</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>85</td>\n",
       "      <td>105</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9</td>\n",
       "      <td>BlastoiseMega Blastoise</td>\n",
       "      <td>Water</td>\n",
       "      <td>630</td>\n",
       "      <td>79</td>\n",
       "      <td>103</td>\n",
       "      <td>120</td>\n",
       "      <td>135</td>\n",
       "      <td>115</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10</td>\n",
       "      <td>Caterpie</td>\n",
       "      <td>Bug</td>\n",
       "      <td>195</td>\n",
       "      <td>45</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11</td>\n",
       "      <td>Metapod</td>\n",
       "      <td>Bug</td>\n",
       "      <td>205</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>55</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>12</td>\n",
       "      <td>Butterfree</td>\n",
       "      <td>BugFlying</td>\n",
       "      <td>395</td>\n",
       "      <td>60</td>\n",
       "      <td>45</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>13</td>\n",
       "      <td>Weedle</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>195</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>14</td>\n",
       "      <td>Kakuna</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>205</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15</td>\n",
       "      <td>Beedrill</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>395</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>15</td>\n",
       "      <td>BeedrillMega Beedrill</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>495</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>80</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16</td>\n",
       "      <td>Pidgey</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>251</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>17</td>\n",
       "      <td>Pidgeotto</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>349</td>\n",
       "      <td>63</td>\n",
       "      <td>60</td>\n",
       "      <td>55</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18</td>\n",
       "      <td>Pidgeot</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>479</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>18</td>\n",
       "      <td>PidgeotMega Pidgeot</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>579</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>135</td>\n",
       "      <td>80</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>19</td>\n",
       "      <td>Rattata</td>\n",
       "      <td>Normal</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>19</td>\n",
       "      <td>RattataAlolan Rattata</td>\n",
       "      <td>DarkNormal</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20</td>\n",
       "      <td>Raticate</td>\n",
       "      <td>Normal</td>\n",
       "      <td>413</td>\n",
       "      <td>55</td>\n",
       "      <td>81</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>70</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20</td>\n",
       "      <td>RaticateAlolan Raticate</td>\n",
       "      <td>DarkNormal</td>\n",
       "      <td>413</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>21</td>\n",
       "      <td>Spearow</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>262</td>\n",
       "      <td>40</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22</td>\n",
       "      <td>Fearow</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>442</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>781</td>\n",
       "      <td>Dhelmise</td>\n",
       "      <td>GhostGrass</td>\n",
       "      <td>517</td>\n",
       "      <td>70</td>\n",
       "      <td>131</td>\n",
       "      <td>100</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>782</td>\n",
       "      <td>Jangmo-o</td>\n",
       "      <td>Dragon</td>\n",
       "      <td>300</td>\n",
       "      <td>45</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>783</td>\n",
       "      <td>Hakamo-o</td>\n",
       "      <td>DragonFighting</td>\n",
       "      <td>420</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>70</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>784</td>\n",
       "      <td>Kommo-o</td>\n",
       "      <td>DragonFighting</td>\n",
       "      <td>600</td>\n",
       "      <td>75</td>\n",
       "      <td>110</td>\n",
       "      <td>125</td>\n",
       "      <td>100</td>\n",
       "      <td>105</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>785</td>\n",
       "      <td>Tapu Koko</td>\n",
       "      <td>ElectricFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>786</td>\n",
       "      <td>Tapu Lele</td>\n",
       "      <td>PsychicFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>787</td>\n",
       "      <td>Tapu Bulu</td>\n",
       "      <td>GrassFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>788</td>\n",
       "      <td>Tapu Fini</td>\n",
       "      <td>WaterFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>75</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>789</td>\n",
       "      <td>Cosmog</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>200</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>790</td>\n",
       "      <td>Cosmoem</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>400</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>791</td>\n",
       "      <td>Solgaleo</td>\n",
       "      <td>PsychicSteel</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>792</td>\n",
       "      <td>Lunala</td>\n",
       "      <td>PsychicGhost</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>793</td>\n",
       "      <td>Nihilego</td>\n",
       "      <td>RockPoison</td>\n",
       "      <td>570</td>\n",
       "      <td>109</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>127</td>\n",
       "      <td>131</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900</th>\n",
       "      <td>794</td>\n",
       "      <td>Buzzwole</td>\n",
       "      <td>BugFighting</td>\n",
       "      <td>570</td>\n",
       "      <td>107</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>795</td>\n",
       "      <td>Pheromosa</td>\n",
       "      <td>BugFighting</td>\n",
       "      <td>570</td>\n",
       "      <td>71</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>796</td>\n",
       "      <td>Xurkitree</td>\n",
       "      <td>Electric</td>\n",
       "      <td>570</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "      <td>173</td>\n",
       "      <td>71</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>797</td>\n",
       "      <td>Celesteela</td>\n",
       "      <td>SteelFlying</td>\n",
       "      <td>570</td>\n",
       "      <td>97</td>\n",
       "      <td>101</td>\n",
       "      <td>103</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>798</td>\n",
       "      <td>Kartana</td>\n",
       "      <td>GrassSteel</td>\n",
       "      <td>570</td>\n",
       "      <td>59</td>\n",
       "      <td>181</td>\n",
       "      <td>131</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>799</td>\n",
       "      <td>Guzzlord</td>\n",
       "      <td>DarkDragon</td>\n",
       "      <td>570</td>\n",
       "      <td>223</td>\n",
       "      <td>101</td>\n",
       "      <td>53</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>800</td>\n",
       "      <td>Necrozma</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>600</td>\n",
       "      <td>97</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>127</td>\n",
       "      <td>89</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDusk Mane Necrozma</td>\n",
       "      <td>PsychicSteel</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDawn Wings Necrozma</td>\n",
       "      <td>PsychicGhost</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaUltra Necrozma</td>\n",
       "      <td>PsychicDragon</td>\n",
       "      <td>754</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>801</td>\n",
       "      <td>Magearna</td>\n",
       "      <td>SteelFairy</td>\n",
       "      <td>600</td>\n",
       "      <td>80</td>\n",
       "      <td>95</td>\n",
       "      <td>115</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>802</td>\n",
       "      <td>Marshadow</td>\n",
       "      <td>FightingGhost</td>\n",
       "      <td>600</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>803</td>\n",
       "      <td>Poipole</td>\n",
       "      <td>Poison</td>\n",
       "      <td>420</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>804</td>\n",
       "      <td>Naganadel</td>\n",
       "      <td>PoisonDragon</td>\n",
       "      <td>540</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>73</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>805</td>\n",
       "      <td>Stakataka</td>\n",
       "      <td>RockSteel</td>\n",
       "      <td>570</td>\n",
       "      <td>61</td>\n",
       "      <td>131</td>\n",
       "      <td>211</td>\n",
       "      <td>53</td>\n",
       "      <td>101</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>806</td>\n",
       "      <td>Blacephalon</td>\n",
       "      <td>FireGhost</td>\n",
       "      <td>570</td>\n",
       "      <td>53</td>\n",
       "      <td>127</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>79</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>807</td>\n",
       "      <td>Zeraora</td>\n",
       "      <td>Electric</td>\n",
       "      <td>600</td>\n",
       "      <td>88</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>102</td>\n",
       "      <td>80</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>917 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #                         Name            Type  Total   HP  Attack  \\\n",
       "0      1                    Bulbasaur     GrassPoison    318   45      49   \n",
       "1      2                      Ivysaur     GrassPoison    405   60      62   \n",
       "2      3                     Venusaur     GrassPoison    525   80      82   \n",
       "3      3        VenusaurMega Venusaur     GrassPoison    625   80     100   \n",
       "4      4                   Charmander            Fire    309   39      52   \n",
       "5      5                   Charmeleon            Fire    405   58      64   \n",
       "6      6                    Charizard      FireFlying    534   78      84   \n",
       "7      6    CharizardMega Charizard X      FireDragon    634   78     130   \n",
       "8      6    CharizardMega Charizard Y      FireFlying    634   78     104   \n",
       "9      7                     Squirtle           Water    314   44      48   \n",
       "10     8                    Wartortle           Water    405   59      63   \n",
       "11     9                    Blastoise           Water    530   79      83   \n",
       "12     9      BlastoiseMega Blastoise           Water    630   79     103   \n",
       "13    10                     Caterpie             Bug    195   45      30   \n",
       "14    11                      Metapod             Bug    205   50      20   \n",
       "15    12                   Butterfree       BugFlying    395   60      45   \n",
       "16    13                       Weedle       BugPoison    195   40      35   \n",
       "17    14                       Kakuna       BugPoison    205   45      25   \n",
       "18    15                     Beedrill       BugPoison    395   65      90   \n",
       "19    15        BeedrillMega Beedrill       BugPoison    495   65     150   \n",
       "20    16                       Pidgey    NormalFlying    251   40      45   \n",
       "21    17                    Pidgeotto    NormalFlying    349   63      60   \n",
       "22    18                      Pidgeot    NormalFlying    479   83      80   \n",
       "23    18          PidgeotMega Pidgeot    NormalFlying    579   83      80   \n",
       "24    19                      Rattata          Normal    253   30      56   \n",
       "25    19        RattataAlolan Rattata      DarkNormal    253   30      56   \n",
       "26    20                     Raticate          Normal    413   55      81   \n",
       "27    20      RaticateAlolan Raticate      DarkNormal    413   75      71   \n",
       "28    21                      Spearow    NormalFlying    262   40      60   \n",
       "29    22                       Fearow    NormalFlying    442   65      90   \n",
       "..   ...                          ...             ...    ...  ...     ...   \n",
       "887  781                     Dhelmise      GhostGrass    517   70     131   \n",
       "888  782                     Jangmo-o          Dragon    300   45      55   \n",
       "889  783                     Hakamo-o  DragonFighting    420   55      75   \n",
       "890  784                      Kommo-o  DragonFighting    600   75     110   \n",
       "891  785                    Tapu Koko   ElectricFairy    570   70     115   \n",
       "892  786                    Tapu Lele    PsychicFairy    570   70      85   \n",
       "893  787                    Tapu Bulu      GrassFairy    570   70     130   \n",
       "894  788                    Tapu Fini      WaterFairy    570   70      75   \n",
       "895  789                       Cosmog         Psychic    200   43      29   \n",
       "896  790                      Cosmoem         Psychic    400   43      29   \n",
       "897  791                     Solgaleo    PsychicSteel    680  137     137   \n",
       "898  792                       Lunala    PsychicGhost    680  137     113   \n",
       "899  793                     Nihilego      RockPoison    570  109      53   \n",
       "900  794                     Buzzwole     BugFighting    570  107     139   \n",
       "901  795                    Pheromosa     BugFighting    570   71     137   \n",
       "902  796                    Xurkitree        Electric    570   83      89   \n",
       "903  797                   Celesteela     SteelFlying    570   97     101   \n",
       "904  798                      Kartana      GrassSteel    570   59     181   \n",
       "905  799                     Guzzlord      DarkDragon    570  223     101   \n",
       "906  800                     Necrozma         Psychic    600   97     107   \n",
       "907  800   NecrozmaDusk Mane Necrozma    PsychicSteel    680   97     157   \n",
       "908  800  NecrozmaDawn Wings Necrozma    PsychicGhost    680   97     113   \n",
       "909  800       NecrozmaUltra Necrozma   PsychicDragon    754   97     167   \n",
       "910  801                     Magearna      SteelFairy    600   80      95   \n",
       "911  802                    Marshadow   FightingGhost    600   90     125   \n",
       "912  803                      Poipole          Poison    420   67      73   \n",
       "913  804                    Naganadel    PoisonDragon    540   73      73   \n",
       "914  805                    Stakataka       RockSteel    570   61     131   \n",
       "915  806                  Blacephalon       FireGhost    570   53     127   \n",
       "916  807                      Zeraora        Electric    600   88     112   \n",
       "\n",
       "     Defense  Sp. Atk  Sp. Def  Speed  \n",
       "0         49       65       65     45  \n",
       "1         63       80       80     60  \n",
       "2         83      100      100     80  \n",
       "3        123      122      120     80  \n",
       "4         43       60       50     65  \n",
       "5         58       80       65     80  \n",
       "6         78      109       85    100  \n",
       "7        111      130       85    100  \n",
       "8         78      159      115    100  \n",
       "9         65       50       64     43  \n",
       "10        80       65       80     58  \n",
       "11       100       85      105     78  \n",
       "12       120      135      115     78  \n",
       "13        35       20       20     45  \n",
       "14        55       25       25     30  \n",
       "15        50       90       80     70  \n",
       "16        30       20       20     50  \n",
       "17        50       25       25     35  \n",
       "18        40       45       80     75  \n",
       "19        40       15       80    145  \n",
       "20        40       35       35     56  \n",
       "21        55       50       50     71  \n",
       "22        75       70       70    101  \n",
       "23        80      135       80    121  \n",
       "24        35       25       35     72  \n",
       "25        35       25       35     72  \n",
       "26        60       50       70     97  \n",
       "27        70       40       80     77  \n",
       "28        30       31       31     70  \n",
       "29        65       61       61    100  \n",
       "..       ...      ...      ...    ...  \n",
       "887      100       86       90     40  \n",
       "888       65       45       45     45  \n",
       "889       90       65       70     65  \n",
       "890      125      100      105     85  \n",
       "891       85       95       75    130  \n",
       "892       75      130      115     95  \n",
       "893      115       85       95     75  \n",
       "894      115       95      130     85  \n",
       "895       31       29       31     37  \n",
       "896      131       29      131     37  \n",
       "897      107      113       89     97  \n",
       "898       89      137      107     97  \n",
       "899       47      127      131    103  \n",
       "900      139       53       53     79  \n",
       "901       37      137       37    151  \n",
       "902       71      173       71     83  \n",
       "903      103      107      101     61  \n",
       "904      131       59       31    109  \n",
       "905       53       97       53     43  \n",
       "906      101      127       89     79  \n",
       "907      127      113      109     77  \n",
       "908      109      157      127     77  \n",
       "909       97      167       97    129  \n",
       "910      115      130      115     65  \n",
       "911       80       90       90    125  \n",
       "912       67       73       67     73  \n",
       "913       73      127       73    121  \n",
       "914      211       53      101     13  \n",
       "915       53      151       79    107  \n",
       "916       75      102       80    143  \n",
       "\n",
       "[917 rows x 10 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = tables[0]\n",
    "table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 917 entries, 0 to 916\n",
      "Data columns (total 10 columns):\n",
      "#          917 non-null int64\n",
      "Name       917 non-null object\n",
      "Type       917 non-null object\n",
      "Total      917 non-null int64\n",
      "HP         917 non-null int64\n",
      "Attack     917 non-null int64\n",
      "Defense    917 non-null int64\n",
      "Sp. Atk    917 non-null int64\n",
      "Sp. Def    917 non-null int64\n",
      "Speed      917 non-null int64\n",
      "dtypes: int64(8), object(2)\n",
      "memory usage: 71.7+ KB\n"
     ]
    }
   ],
   "source": [
    "table.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>Total</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>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "      <td>917.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>399.930207</td>\n",
       "      <td>438.146129</td>\n",
       "      <td>69.546347</td>\n",
       "      <td>80.056707</td>\n",
       "      <td>74.532170</td>\n",
       "      <td>73.199564</td>\n",
       "      <td>72.315158</td>\n",
       "      <td>68.496183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>235.970035</td>\n",
       "      <td>120.350210</td>\n",
       "      <td>26.074785</td>\n",
       "      <td>32.586115</td>\n",
       "      <td>31.237579</td>\n",
       "      <td>33.179584</td>\n",
       "      <td>27.839761</td>\n",
       "      <td>29.439288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>175.000000</td>\n",
       "      <td>1.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>196.000000</td>\n",
       "      <td>330.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>395.000000</td>\n",
       "      <td>455.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>65.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>608.000000</td>\n",
       "      <td>517.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>95.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>807.000000</td>\n",
       "      <td>780.000000</td>\n",
       "      <td>255.000000</td>\n",
       "      <td>190.000000</td>\n",
       "      <td>230.000000</td>\n",
       "      <td>194.000000</td>\n",
       "      <td>230.000000</td>\n",
       "      <td>180.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                #       Total          HP      Attack     Defense     Sp. Atk  \\\n",
       "count  917.000000  917.000000  917.000000  917.000000  917.000000  917.000000   \n",
       "mean   399.930207  438.146129   69.546347   80.056707   74.532170   73.199564   \n",
       "std    235.970035  120.350210   26.074785   32.586115   31.237579   33.179584   \n",
       "min      1.000000  175.000000    1.000000    5.000000    5.000000   10.000000   \n",
       "25%    196.000000  330.000000   50.000000   55.000000   50.000000   50.000000   \n",
       "50%    395.000000  455.000000   66.000000   75.000000   70.000000   65.000000   \n",
       "75%    608.000000  517.000000   80.000000  100.000000   90.000000   95.000000   \n",
       "max    807.000000  780.000000  255.000000  190.000000  230.000000  194.000000   \n",
       "\n",
       "          Sp. Def       Speed  \n",
       "count  917.000000  917.000000  \n",
       "mean    72.315158   68.496183  \n",
       "std     27.839761   29.439288  \n",
       "min     20.000000    5.000000  \n",
       "25%     50.000000   45.000000  \n",
       "50%     70.000000   65.000000  \n",
       "75%     90.000000   90.000000  \n",
       "max    230.000000  180.000000  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "msg = \"ThisIsATest\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['This', 'Is', 'A', 'Test']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "re.findall(r\"[A-Z][a-z]*\", msg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['This', 'Is', 'A', 'Test']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "splitter = re.compile(r\"[A-Z][a-z]*\").findall\n",
    "splitter(msg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         [Grass, Poison]\n",
       "1         [Grass, Poison]\n",
       "2         [Grass, Poison]\n",
       "3         [Grass, Poison]\n",
       "4                  [Fire]\n",
       "5                  [Fire]\n",
       "6          [Fire, Flying]\n",
       "7          [Fire, Dragon]\n",
       "8          [Fire, Flying]\n",
       "9                 [Water]\n",
       "10                [Water]\n",
       "11                [Water]\n",
       "12                [Water]\n",
       "13                  [Bug]\n",
       "14                  [Bug]\n",
       "15          [Bug, Flying]\n",
       "16          [Bug, Poison]\n",
       "17          [Bug, Poison]\n",
       "18          [Bug, Poison]\n",
       "19          [Bug, Poison]\n",
       "20       [Normal, Flying]\n",
       "21       [Normal, Flying]\n",
       "22       [Normal, Flying]\n",
       "23       [Normal, Flying]\n",
       "24               [Normal]\n",
       "25         [Dark, Normal]\n",
       "26               [Normal]\n",
       "27         [Dark, Normal]\n",
       "28       [Normal, Flying]\n",
       "29       [Normal, Flying]\n",
       "              ...        \n",
       "887        [Ghost, Grass]\n",
       "888              [Dragon]\n",
       "889    [Dragon, Fighting]\n",
       "890    [Dragon, Fighting]\n",
       "891     [Electric, Fairy]\n",
       "892      [Psychic, Fairy]\n",
       "893        [Grass, Fairy]\n",
       "894        [Water, Fairy]\n",
       "895             [Psychic]\n",
       "896             [Psychic]\n",
       "897      [Psychic, Steel]\n",
       "898      [Psychic, Ghost]\n",
       "899        [Rock, Poison]\n",
       "900       [Bug, Fighting]\n",
       "901       [Bug, Fighting]\n",
       "902            [Electric]\n",
       "903       [Steel, Flying]\n",
       "904        [Grass, Steel]\n",
       "905        [Dark, Dragon]\n",
       "906             [Psychic]\n",
       "907      [Psychic, Steel]\n",
       "908      [Psychic, Ghost]\n",
       "909     [Psychic, Dragon]\n",
       "910        [Steel, Fairy]\n",
       "911     [Fighting, Ghost]\n",
       "912              [Poison]\n",
       "913      [Poison, Dragon]\n",
       "914         [Rock, Steel]\n",
       "915         [Fire, Ghost]\n",
       "916            [Electric]\n",
       "Name: Type, Length: 917, dtype: object"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table[\"Type\"].apply(splitter)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>Name</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total</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>bias</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>318</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>405</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Venusaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>525</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>VenusaurMega Venusaur</td>\n",
       "      <td>GrassPoison</td>\n",
       "      <td>625</td>\n",
       "      <td>80</td>\n",
       "      <td>100</td>\n",
       "      <td>123</td>\n",
       "      <td>122</td>\n",
       "      <td>120</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Charmander</td>\n",
       "      <td>Fire</td>\n",
       "      <td>309</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>Fire</td>\n",
       "      <td>405</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Charizard</td>\n",
       "      <td>FireFlying</td>\n",
       "      <td>534</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "      <td>109</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard X</td>\n",
       "      <td>FireDragon</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>130</td>\n",
       "      <td>111</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard Y</td>\n",
       "      <td>FireFlying</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>104</td>\n",
       "      <td>78</td>\n",
       "      <td>159</td>\n",
       "      <td>115</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7</td>\n",
       "      <td>Squirtle</td>\n",
       "      <td>Water</td>\n",
       "      <td>314</td>\n",
       "      <td>44</td>\n",
       "      <td>48</td>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8</td>\n",
       "      <td>Wartortle</td>\n",
       "      <td>Water</td>\n",
       "      <td>405</td>\n",
       "      <td>59</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>9</td>\n",
       "      <td>Blastoise</td>\n",
       "      <td>Water</td>\n",
       "      <td>530</td>\n",
       "      <td>79</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>85</td>\n",
       "      <td>105</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9</td>\n",
       "      <td>BlastoiseMega Blastoise</td>\n",
       "      <td>Water</td>\n",
       "      <td>630</td>\n",
       "      <td>79</td>\n",
       "      <td>103</td>\n",
       "      <td>120</td>\n",
       "      <td>135</td>\n",
       "      <td>115</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10</td>\n",
       "      <td>Caterpie</td>\n",
       "      <td>Bug</td>\n",
       "      <td>195</td>\n",
       "      <td>45</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11</td>\n",
       "      <td>Metapod</td>\n",
       "      <td>Bug</td>\n",
       "      <td>205</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>55</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>12</td>\n",
       "      <td>Butterfree</td>\n",
       "      <td>BugFlying</td>\n",
       "      <td>395</td>\n",
       "      <td>60</td>\n",
       "      <td>45</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>13</td>\n",
       "      <td>Weedle</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>195</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>14</td>\n",
       "      <td>Kakuna</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>205</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15</td>\n",
       "      <td>Beedrill</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>395</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>15</td>\n",
       "      <td>BeedrillMega Beedrill</td>\n",
       "      <td>BugPoison</td>\n",
       "      <td>495</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>80</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16</td>\n",
       "      <td>Pidgey</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>251</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>17</td>\n",
       "      <td>Pidgeotto</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>349</td>\n",
       "      <td>63</td>\n",
       "      <td>60</td>\n",
       "      <td>55</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18</td>\n",
       "      <td>Pidgeot</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>479</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>101</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>18</td>\n",
       "      <td>PidgeotMega Pidgeot</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>579</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>135</td>\n",
       "      <td>80</td>\n",
       "      <td>121</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>19</td>\n",
       "      <td>Rattata</td>\n",
       "      <td>Normal</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>19</td>\n",
       "      <td>RattataAlolan Rattata</td>\n",
       "      <td>DarkNormal</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20</td>\n",
       "      <td>Raticate</td>\n",
       "      <td>Normal</td>\n",
       "      <td>413</td>\n",
       "      <td>55</td>\n",
       "      <td>81</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>70</td>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20</td>\n",
       "      <td>RaticateAlolan Raticate</td>\n",
       "      <td>DarkNormal</td>\n",
       "      <td>413</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>21</td>\n",
       "      <td>Spearow</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>262</td>\n",
       "      <td>40</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22</td>\n",
       "      <td>Fearow</td>\n",
       "      <td>NormalFlying</td>\n",
       "      <td>442</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>781</td>\n",
       "      <td>Dhelmise</td>\n",
       "      <td>GhostGrass</td>\n",
       "      <td>517</td>\n",
       "      <td>70</td>\n",
       "      <td>131</td>\n",
       "      <td>100</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>782</td>\n",
       "      <td>Jangmo-o</td>\n",
       "      <td>Dragon</td>\n",
       "      <td>300</td>\n",
       "      <td>45</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>783</td>\n",
       "      <td>Hakamo-o</td>\n",
       "      <td>DragonFighting</td>\n",
       "      <td>420</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>70</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>784</td>\n",
       "      <td>Kommo-o</td>\n",
       "      <td>DragonFighting</td>\n",
       "      <td>600</td>\n",
       "      <td>75</td>\n",
       "      <td>110</td>\n",
       "      <td>125</td>\n",
       "      <td>100</td>\n",
       "      <td>105</td>\n",
       "      <td>85</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>785</td>\n",
       "      <td>Tapu Koko</td>\n",
       "      <td>ElectricFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>786</td>\n",
       "      <td>Tapu Lele</td>\n",
       "      <td>PsychicFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>787</td>\n",
       "      <td>Tapu Bulu</td>\n",
       "      <td>GrassFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>788</td>\n",
       "      <td>Tapu Fini</td>\n",
       "      <td>WaterFairy</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>75</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>789</td>\n",
       "      <td>Cosmog</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>200</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>790</td>\n",
       "      <td>Cosmoem</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>400</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>791</td>\n",
       "      <td>Solgaleo</td>\n",
       "      <td>PsychicSteel</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>792</td>\n",
       "      <td>Lunala</td>\n",
       "      <td>PsychicGhost</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>793</td>\n",
       "      <td>Nihilego</td>\n",
       "      <td>RockPoison</td>\n",
       "      <td>570</td>\n",
       "      <td>109</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>127</td>\n",
       "      <td>131</td>\n",
       "      <td>103</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900</th>\n",
       "      <td>794</td>\n",
       "      <td>Buzzwole</td>\n",
       "      <td>BugFighting</td>\n",
       "      <td>570</td>\n",
       "      <td>107</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>795</td>\n",
       "      <td>Pheromosa</td>\n",
       "      <td>BugFighting</td>\n",
       "      <td>570</td>\n",
       "      <td>71</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>796</td>\n",
       "      <td>Xurkitree</td>\n",
       "      <td>Electric</td>\n",
       "      <td>570</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "      <td>173</td>\n",
       "      <td>71</td>\n",
       "      <td>83</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>797</td>\n",
       "      <td>Celesteela</td>\n",
       "      <td>SteelFlying</td>\n",
       "      <td>570</td>\n",
       "      <td>97</td>\n",
       "      <td>101</td>\n",
       "      <td>103</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>798</td>\n",
       "      <td>Kartana</td>\n",
       "      <td>GrassSteel</td>\n",
       "      <td>570</td>\n",
       "      <td>59</td>\n",
       "      <td>181</td>\n",
       "      <td>131</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>109</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>799</td>\n",
       "      <td>Guzzlord</td>\n",
       "      <td>DarkDragon</td>\n",
       "      <td>570</td>\n",
       "      <td>223</td>\n",
       "      <td>101</td>\n",
       "      <td>53</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>800</td>\n",
       "      <td>Necrozma</td>\n",
       "      <td>Psychic</td>\n",
       "      <td>600</td>\n",
       "      <td>97</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>127</td>\n",
       "      <td>89</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDusk Mane Necrozma</td>\n",
       "      <td>PsychicSteel</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDawn Wings Necrozma</td>\n",
       "      <td>PsychicGhost</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaUltra Necrozma</td>\n",
       "      <td>PsychicDragon</td>\n",
       "      <td>754</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>801</td>\n",
       "      <td>Magearna</td>\n",
       "      <td>SteelFairy</td>\n",
       "      <td>600</td>\n",
       "      <td>80</td>\n",
       "      <td>95</td>\n",
       "      <td>115</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>802</td>\n",
       "      <td>Marshadow</td>\n",
       "      <td>FightingGhost</td>\n",
       "      <td>600</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>803</td>\n",
       "      <td>Poipole</td>\n",
       "      <td>Poison</td>\n",
       "      <td>420</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>804</td>\n",
       "      <td>Naganadel</td>\n",
       "      <td>PoisonDragon</td>\n",
       "      <td>540</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>73</td>\n",
       "      <td>121</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>805</td>\n",
       "      <td>Stakataka</td>\n",
       "      <td>RockSteel</td>\n",
       "      <td>570</td>\n",
       "      <td>61</td>\n",
       "      <td>131</td>\n",
       "      <td>211</td>\n",
       "      <td>53</td>\n",
       "      <td>101</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>806</td>\n",
       "      <td>Blacephalon</td>\n",
       "      <td>FireGhost</td>\n",
       "      <td>570</td>\n",
       "      <td>53</td>\n",
       "      <td>127</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>79</td>\n",
       "      <td>107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>807</td>\n",
       "      <td>Zeraora</td>\n",
       "      <td>Electric</td>\n",
       "      <td>600</td>\n",
       "      <td>88</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>102</td>\n",
       "      <td>80</td>\n",
       "      <td>143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>917 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #                         Name            Type  Total   HP  Attack  \\\n",
       "0      1                    Bulbasaur     GrassPoison    318   45      49   \n",
       "1      2                      Ivysaur     GrassPoison    405   60      62   \n",
       "2      3                     Venusaur     GrassPoison    525   80      82   \n",
       "3      3        VenusaurMega Venusaur     GrassPoison    625   80     100   \n",
       "4      4                   Charmander            Fire    309   39      52   \n",
       "5      5                   Charmeleon            Fire    405   58      64   \n",
       "6      6                    Charizard      FireFlying    534   78      84   \n",
       "7      6    CharizardMega Charizard X      FireDragon    634   78     130   \n",
       "8      6    CharizardMega Charizard Y      FireFlying    634   78     104   \n",
       "9      7                     Squirtle           Water    314   44      48   \n",
       "10     8                    Wartortle           Water    405   59      63   \n",
       "11     9                    Blastoise           Water    530   79      83   \n",
       "12     9      BlastoiseMega Blastoise           Water    630   79     103   \n",
       "13    10                     Caterpie             Bug    195   45      30   \n",
       "14    11                      Metapod             Bug    205   50      20   \n",
       "15    12                   Butterfree       BugFlying    395   60      45   \n",
       "16    13                       Weedle       BugPoison    195   40      35   \n",
       "17    14                       Kakuna       BugPoison    205   45      25   \n",
       "18    15                     Beedrill       BugPoison    395   65      90   \n",
       "19    15        BeedrillMega Beedrill       BugPoison    495   65     150   \n",
       "20    16                       Pidgey    NormalFlying    251   40      45   \n",
       "21    17                    Pidgeotto    NormalFlying    349   63      60   \n",
       "22    18                      Pidgeot    NormalFlying    479   83      80   \n",
       "23    18          PidgeotMega Pidgeot    NormalFlying    579   83      80   \n",
       "24    19                      Rattata          Normal    253   30      56   \n",
       "25    19        RattataAlolan Rattata      DarkNormal    253   30      56   \n",
       "26    20                     Raticate          Normal    413   55      81   \n",
       "27    20      RaticateAlolan Raticate      DarkNormal    413   75      71   \n",
       "28    21                      Spearow    NormalFlying    262   40      60   \n",
       "29    22                       Fearow    NormalFlying    442   65      90   \n",
       "..   ...                          ...             ...    ...  ...     ...   \n",
       "887  781                     Dhelmise      GhostGrass    517   70     131   \n",
       "888  782                     Jangmo-o          Dragon    300   45      55   \n",
       "889  783                     Hakamo-o  DragonFighting    420   55      75   \n",
       "890  784                      Kommo-o  DragonFighting    600   75     110   \n",
       "891  785                    Tapu Koko   ElectricFairy    570   70     115   \n",
       "892  786                    Tapu Lele    PsychicFairy    570   70      85   \n",
       "893  787                    Tapu Bulu      GrassFairy    570   70     130   \n",
       "894  788                    Tapu Fini      WaterFairy    570   70      75   \n",
       "895  789                       Cosmog         Psychic    200   43      29   \n",
       "896  790                      Cosmoem         Psychic    400   43      29   \n",
       "897  791                     Solgaleo    PsychicSteel    680  137     137   \n",
       "898  792                       Lunala    PsychicGhost    680  137     113   \n",
       "899  793                     Nihilego      RockPoison    570  109      53   \n",
       "900  794                     Buzzwole     BugFighting    570  107     139   \n",
       "901  795                    Pheromosa     BugFighting    570   71     137   \n",
       "902  796                    Xurkitree        Electric    570   83      89   \n",
       "903  797                   Celesteela     SteelFlying    570   97     101   \n",
       "904  798                      Kartana      GrassSteel    570   59     181   \n",
       "905  799                     Guzzlord      DarkDragon    570  223     101   \n",
       "906  800                     Necrozma         Psychic    600   97     107   \n",
       "907  800   NecrozmaDusk Mane Necrozma    PsychicSteel    680   97     157   \n",
       "908  800  NecrozmaDawn Wings Necrozma    PsychicGhost    680   97     113   \n",
       "909  800       NecrozmaUltra Necrozma   PsychicDragon    754   97     167   \n",
       "910  801                     Magearna      SteelFairy    600   80      95   \n",
       "911  802                    Marshadow   FightingGhost    600   90     125   \n",
       "912  803                      Poipole          Poison    420   67      73   \n",
       "913  804                    Naganadel    PoisonDragon    540   73      73   \n",
       "914  805                    Stakataka       RockSteel    570   61     131   \n",
       "915  806                  Blacephalon       FireGhost    570   53     127   \n",
       "916  807                      Zeraora        Electric    600   88     112   \n",
       "\n",
       "     Defense  Sp. Atk  Sp. Def  Speed  bias  \n",
       "0         49       65       65     45     1  \n",
       "1         63       80       80     60     1  \n",
       "2         83      100      100     80     1  \n",
       "3        123      122      120     80     1  \n",
       "4         43       60       50     65     1  \n",
       "5         58       80       65     80     1  \n",
       "6         78      109       85    100     1  \n",
       "7        111      130       85    100     1  \n",
       "8         78      159      115    100     1  \n",
       "9         65       50       64     43     1  \n",
       "10        80       65       80     58     1  \n",
       "11       100       85      105     78     1  \n",
       "12       120      135      115     78     1  \n",
       "13        35       20       20     45     1  \n",
       "14        55       25       25     30     1  \n",
       "15        50       90       80     70     1  \n",
       "16        30       20       20     50     1  \n",
       "17        50       25       25     35     1  \n",
       "18        40       45       80     75     1  \n",
       "19        40       15       80    145     1  \n",
       "20        40       35       35     56     1  \n",
       "21        55       50       50     71     1  \n",
       "22        75       70       70    101     1  \n",
       "23        80      135       80    121     1  \n",
       "24        35       25       35     72     1  \n",
       "25        35       25       35     72     1  \n",
       "26        60       50       70     97     1  \n",
       "27        70       40       80     77     1  \n",
       "28        30       31       31     70     1  \n",
       "29        65       61       61    100     1  \n",
       "..       ...      ...      ...    ...   ...  \n",
       "887      100       86       90     40     1  \n",
       "888       65       45       45     45     1  \n",
       "889       90       65       70     65     1  \n",
       "890      125      100      105     85     1  \n",
       "891       85       95       75    130     1  \n",
       "892       75      130      115     95     1  \n",
       "893      115       85       95     75     1  \n",
       "894      115       95      130     85     1  \n",
       "895       31       29       31     37     1  \n",
       "896      131       29      131     37     1  \n",
       "897      107      113       89     97     1  \n",
       "898       89      137      107     97     1  \n",
       "899       47      127      131    103     1  \n",
       "900      139       53       53     79     1  \n",
       "901       37      137       37    151     1  \n",
       "902       71      173       71     83     1  \n",
       "903      103      107      101     61     1  \n",
       "904      131       59       31    109     1  \n",
       "905       53       97       53     43     1  \n",
       "906      101      127       89     79     1  \n",
       "907      127      113      109     77     1  \n",
       "908      109      157      127     77     1  \n",
       "909       97      167       97    129     1  \n",
       "910      115      130      115     65     1  \n",
       "911       80       90       90    125     1  \n",
       "912       67       73       67     73     1  \n",
       "913       73      127       73    121     1  \n",
       "914      211       53      101     13     1  \n",
       "915       53      151       79    107     1  \n",
       "916       75      102       80    143     1  \n",
       "\n",
       "[917 rows x 11 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.assign(bias=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Name</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total</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>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>[Grass, Poison]</td>\n",
       "      <td>318</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>[Grass, Poison]</td>\n",
       "      <td>405</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Venusaur</td>\n",
       "      <td>[Grass, Poison]</td>\n",
       "      <td>525</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>VenusaurMega Venusaur</td>\n",
       "      <td>[Grass, Poison]</td>\n",
       "      <td>625</td>\n",
       "      <td>80</td>\n",
       "      <td>100</td>\n",
       "      <td>123</td>\n",
       "      <td>122</td>\n",
       "      <td>120</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Charmander</td>\n",
       "      <td>[Fire]</td>\n",
       "      <td>309</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>[Fire]</td>\n",
       "      <td>405</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Charizard</td>\n",
       "      <td>[Fire, Flying]</td>\n",
       "      <td>534</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "      <td>109</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard X</td>\n",
       "      <td>[Fire, Dragon]</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>130</td>\n",
       "      <td>111</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard Y</td>\n",
       "      <td>[Fire, Flying]</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>104</td>\n",
       "      <td>78</td>\n",
       "      <td>159</td>\n",
       "      <td>115</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7</td>\n",
       "      <td>Squirtle</td>\n",
       "      <td>[Water]</td>\n",
       "      <td>314</td>\n",
       "      <td>44</td>\n",
       "      <td>48</td>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8</td>\n",
       "      <td>Wartortle</td>\n",
       "      <td>[Water]</td>\n",
       "      <td>405</td>\n",
       "      <td>59</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>9</td>\n",
       "      <td>Blastoise</td>\n",
       "      <td>[Water]</td>\n",
       "      <td>530</td>\n",
       "      <td>79</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>85</td>\n",
       "      <td>105</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9</td>\n",
       "      <td>BlastoiseMega Blastoise</td>\n",
       "      <td>[Water]</td>\n",
       "      <td>630</td>\n",
       "      <td>79</td>\n",
       "      <td>103</td>\n",
       "      <td>120</td>\n",
       "      <td>135</td>\n",
       "      <td>115</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10</td>\n",
       "      <td>Caterpie</td>\n",
       "      <td>[Bug]</td>\n",
       "      <td>195</td>\n",
       "      <td>45</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11</td>\n",
       "      <td>Metapod</td>\n",
       "      <td>[Bug]</td>\n",
       "      <td>205</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>55</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>12</td>\n",
       "      <td>Butterfree</td>\n",
       "      <td>[Bug, Flying]</td>\n",
       "      <td>395</td>\n",
       "      <td>60</td>\n",
       "      <td>45</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>13</td>\n",
       "      <td>Weedle</td>\n",
       "      <td>[Bug, Poison]</td>\n",
       "      <td>195</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>14</td>\n",
       "      <td>Kakuna</td>\n",
       "      <td>[Bug, Poison]</td>\n",
       "      <td>205</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15</td>\n",
       "      <td>Beedrill</td>\n",
       "      <td>[Bug, Poison]</td>\n",
       "      <td>395</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>15</td>\n",
       "      <td>BeedrillMega Beedrill</td>\n",
       "      <td>[Bug, Poison]</td>\n",
       "      <td>495</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>80</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16</td>\n",
       "      <td>Pidgey</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>251</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>17</td>\n",
       "      <td>Pidgeotto</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>349</td>\n",
       "      <td>63</td>\n",
       "      <td>60</td>\n",
       "      <td>55</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18</td>\n",
       "      <td>Pidgeot</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>479</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>18</td>\n",
       "      <td>PidgeotMega Pidgeot</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>579</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>135</td>\n",
       "      <td>80</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>19</td>\n",
       "      <td>Rattata</td>\n",
       "      <td>[Normal]</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>19</td>\n",
       "      <td>RattataAlolan Rattata</td>\n",
       "      <td>[Dark, Normal]</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20</td>\n",
       "      <td>Raticate</td>\n",
       "      <td>[Normal]</td>\n",
       "      <td>413</td>\n",
       "      <td>55</td>\n",
       "      <td>81</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>70</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20</td>\n",
       "      <td>RaticateAlolan Raticate</td>\n",
       "      <td>[Dark, Normal]</td>\n",
       "      <td>413</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>21</td>\n",
       "      <td>Spearow</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>262</td>\n",
       "      <td>40</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22</td>\n",
       "      <td>Fearow</td>\n",
       "      <td>[Normal, Flying]</td>\n",
       "      <td>442</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>781</td>\n",
       "      <td>Dhelmise</td>\n",
       "      <td>[Ghost, Grass]</td>\n",
       "      <td>517</td>\n",
       "      <td>70</td>\n",
       "      <td>131</td>\n",
       "      <td>100</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>782</td>\n",
       "      <td>Jangmo-o</td>\n",
       "      <td>[Dragon]</td>\n",
       "      <td>300</td>\n",
       "      <td>45</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>783</td>\n",
       "      <td>Hakamo-o</td>\n",
       "      <td>[Dragon, Fighting]</td>\n",
       "      <td>420</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>70</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>784</td>\n",
       "      <td>Kommo-o</td>\n",
       "      <td>[Dragon, Fighting]</td>\n",
       "      <td>600</td>\n",
       "      <td>75</td>\n",
       "      <td>110</td>\n",
       "      <td>125</td>\n",
       "      <td>100</td>\n",
       "      <td>105</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>785</td>\n",
       "      <td>Tapu Koko</td>\n",
       "      <td>[Electric, Fairy]</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>786</td>\n",
       "      <td>Tapu Lele</td>\n",
       "      <td>[Psychic, Fairy]</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>787</td>\n",
       "      <td>Tapu Bulu</td>\n",
       "      <td>[Grass, Fairy]</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>788</td>\n",
       "      <td>Tapu Fini</td>\n",
       "      <td>[Water, Fairy]</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>75</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>789</td>\n",
       "      <td>Cosmog</td>\n",
       "      <td>[Psychic]</td>\n",
       "      <td>200</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>790</td>\n",
       "      <td>Cosmoem</td>\n",
       "      <td>[Psychic]</td>\n",
       "      <td>400</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>791</td>\n",
       "      <td>Solgaleo</td>\n",
       "      <td>[Psychic, Steel]</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>792</td>\n",
       "      <td>Lunala</td>\n",
       "      <td>[Psychic, Ghost]</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>793</td>\n",
       "      <td>Nihilego</td>\n",
       "      <td>[Rock, Poison]</td>\n",
       "      <td>570</td>\n",
       "      <td>109</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>127</td>\n",
       "      <td>131</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900</th>\n",
       "      <td>794</td>\n",
       "      <td>Buzzwole</td>\n",
       "      <td>[Bug, Fighting]</td>\n",
       "      <td>570</td>\n",
       "      <td>107</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>795</td>\n",
       "      <td>Pheromosa</td>\n",
       "      <td>[Bug, Fighting]</td>\n",
       "      <td>570</td>\n",
       "      <td>71</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>796</td>\n",
       "      <td>Xurkitree</td>\n",
       "      <td>[Electric]</td>\n",
       "      <td>570</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "      <td>173</td>\n",
       "      <td>71</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>797</td>\n",
       "      <td>Celesteela</td>\n",
       "      <td>[Steel, Flying]</td>\n",
       "      <td>570</td>\n",
       "      <td>97</td>\n",
       "      <td>101</td>\n",
       "      <td>103</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>798</td>\n",
       "      <td>Kartana</td>\n",
       "      <td>[Grass, Steel]</td>\n",
       "      <td>570</td>\n",
       "      <td>59</td>\n",
       "      <td>181</td>\n",
       "      <td>131</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>799</td>\n",
       "      <td>Guzzlord</td>\n",
       "      <td>[Dark, Dragon]</td>\n",
       "      <td>570</td>\n",
       "      <td>223</td>\n",
       "      <td>101</td>\n",
       "      <td>53</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>800</td>\n",
       "      <td>Necrozma</td>\n",
       "      <td>[Psychic]</td>\n",
       "      <td>600</td>\n",
       "      <td>97</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>127</td>\n",
       "      <td>89</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDusk Mane Necrozma</td>\n",
       "      <td>[Psychic, Steel]</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDawn Wings Necrozma</td>\n",
       "      <td>[Psychic, Ghost]</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaUltra Necrozma</td>\n",
       "      <td>[Psychic, Dragon]</td>\n",
       "      <td>754</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>801</td>\n",
       "      <td>Magearna</td>\n",
       "      <td>[Steel, Fairy]</td>\n",
       "      <td>600</td>\n",
       "      <td>80</td>\n",
       "      <td>95</td>\n",
       "      <td>115</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>802</td>\n",
       "      <td>Marshadow</td>\n",
       "      <td>[Fighting, Ghost]</td>\n",
       "      <td>600</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>803</td>\n",
       "      <td>Poipole</td>\n",
       "      <td>[Poison]</td>\n",
       "      <td>420</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>804</td>\n",
       "      <td>Naganadel</td>\n",
       "      <td>[Poison, Dragon]</td>\n",
       "      <td>540</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>73</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>805</td>\n",
       "      <td>Stakataka</td>\n",
       "      <td>[Rock, Steel]</td>\n",
       "      <td>570</td>\n",
       "      <td>61</td>\n",
       "      <td>131</td>\n",
       "      <td>211</td>\n",
       "      <td>53</td>\n",
       "      <td>101</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>806</td>\n",
       "      <td>Blacephalon</td>\n",
       "      <td>[Fire, Ghost]</td>\n",
       "      <td>570</td>\n",
       "      <td>53</td>\n",
       "      <td>127</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>79</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>807</td>\n",
       "      <td>Zeraora</td>\n",
       "      <td>[Electric]</td>\n",
       "      <td>600</td>\n",
       "      <td>88</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>102</td>\n",
       "      <td>80</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>917 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #                         Name                Type  Total   HP  Attack  \\\n",
       "0      1                    Bulbasaur     [Grass, Poison]    318   45      49   \n",
       "1      2                      Ivysaur     [Grass, Poison]    405   60      62   \n",
       "2      3                     Venusaur     [Grass, Poison]    525   80      82   \n",
       "3      3        VenusaurMega Venusaur     [Grass, Poison]    625   80     100   \n",
       "4      4                   Charmander              [Fire]    309   39      52   \n",
       "5      5                   Charmeleon              [Fire]    405   58      64   \n",
       "6      6                    Charizard      [Fire, Flying]    534   78      84   \n",
       "7      6    CharizardMega Charizard X      [Fire, Dragon]    634   78     130   \n",
       "8      6    CharizardMega Charizard Y      [Fire, Flying]    634   78     104   \n",
       "9      7                     Squirtle             [Water]    314   44      48   \n",
       "10     8                    Wartortle             [Water]    405   59      63   \n",
       "11     9                    Blastoise             [Water]    530   79      83   \n",
       "12     9      BlastoiseMega Blastoise             [Water]    630   79     103   \n",
       "13    10                     Caterpie               [Bug]    195   45      30   \n",
       "14    11                      Metapod               [Bug]    205   50      20   \n",
       "15    12                   Butterfree       [Bug, Flying]    395   60      45   \n",
       "16    13                       Weedle       [Bug, Poison]    195   40      35   \n",
       "17    14                       Kakuna       [Bug, Poison]    205   45      25   \n",
       "18    15                     Beedrill       [Bug, Poison]    395   65      90   \n",
       "19    15        BeedrillMega Beedrill       [Bug, Poison]    495   65     150   \n",
       "20    16                       Pidgey    [Normal, Flying]    251   40      45   \n",
       "21    17                    Pidgeotto    [Normal, Flying]    349   63      60   \n",
       "22    18                      Pidgeot    [Normal, Flying]    479   83      80   \n",
       "23    18          PidgeotMega Pidgeot    [Normal, Flying]    579   83      80   \n",
       "24    19                      Rattata            [Normal]    253   30      56   \n",
       "25    19        RattataAlolan Rattata      [Dark, Normal]    253   30      56   \n",
       "26    20                     Raticate            [Normal]    413   55      81   \n",
       "27    20      RaticateAlolan Raticate      [Dark, Normal]    413   75      71   \n",
       "28    21                      Spearow    [Normal, Flying]    262   40      60   \n",
       "29    22                       Fearow    [Normal, Flying]    442   65      90   \n",
       "..   ...                          ...                 ...    ...  ...     ...   \n",
       "887  781                     Dhelmise      [Ghost, Grass]    517   70     131   \n",
       "888  782                     Jangmo-o            [Dragon]    300   45      55   \n",
       "889  783                     Hakamo-o  [Dragon, Fighting]    420   55      75   \n",
       "890  784                      Kommo-o  [Dragon, Fighting]    600   75     110   \n",
       "891  785                    Tapu Koko   [Electric, Fairy]    570   70     115   \n",
       "892  786                    Tapu Lele    [Psychic, Fairy]    570   70      85   \n",
       "893  787                    Tapu Bulu      [Grass, Fairy]    570   70     130   \n",
       "894  788                    Tapu Fini      [Water, Fairy]    570   70      75   \n",
       "895  789                       Cosmog           [Psychic]    200   43      29   \n",
       "896  790                      Cosmoem           [Psychic]    400   43      29   \n",
       "897  791                     Solgaleo    [Psychic, Steel]    680  137     137   \n",
       "898  792                       Lunala    [Psychic, Ghost]    680  137     113   \n",
       "899  793                     Nihilego      [Rock, Poison]    570  109      53   \n",
       "900  794                     Buzzwole     [Bug, Fighting]    570  107     139   \n",
       "901  795                    Pheromosa     [Bug, Fighting]    570   71     137   \n",
       "902  796                    Xurkitree          [Electric]    570   83      89   \n",
       "903  797                   Celesteela     [Steel, Flying]    570   97     101   \n",
       "904  798                      Kartana      [Grass, Steel]    570   59     181   \n",
       "905  799                     Guzzlord      [Dark, Dragon]    570  223     101   \n",
       "906  800                     Necrozma           [Psychic]    600   97     107   \n",
       "907  800   NecrozmaDusk Mane Necrozma    [Psychic, Steel]    680   97     157   \n",
       "908  800  NecrozmaDawn Wings Necrozma    [Psychic, Ghost]    680   97     113   \n",
       "909  800       NecrozmaUltra Necrozma   [Psychic, Dragon]    754   97     167   \n",
       "910  801                     Magearna      [Steel, Fairy]    600   80      95   \n",
       "911  802                    Marshadow   [Fighting, Ghost]    600   90     125   \n",
       "912  803                      Poipole            [Poison]    420   67      73   \n",
       "913  804                    Naganadel    [Poison, Dragon]    540   73      73   \n",
       "914  805                    Stakataka       [Rock, Steel]    570   61     131   \n",
       "915  806                  Blacephalon       [Fire, Ghost]    570   53     127   \n",
       "916  807                      Zeraora          [Electric]    600   88     112   \n",
       "\n",
       "     Defense  Sp. Atk  Sp. Def  Speed  \n",
       "0         49       65       65     45  \n",
       "1         63       80       80     60  \n",
       "2         83      100      100     80  \n",
       "3        123      122      120     80  \n",
       "4         43       60       50     65  \n",
       "5         58       80       65     80  \n",
       "6         78      109       85    100  \n",
       "7        111      130       85    100  \n",
       "8         78      159      115    100  \n",
       "9         65       50       64     43  \n",
       "10        80       65       80     58  \n",
       "11       100       85      105     78  \n",
       "12       120      135      115     78  \n",
       "13        35       20       20     45  \n",
       "14        55       25       25     30  \n",
       "15        50       90       80     70  \n",
       "16        30       20       20     50  \n",
       "17        50       25       25     35  \n",
       "18        40       45       80     75  \n",
       "19        40       15       80    145  \n",
       "20        40       35       35     56  \n",
       "21        55       50       50     71  \n",
       "22        75       70       70    101  \n",
       "23        80      135       80    121  \n",
       "24        35       25       35     72  \n",
       "25        35       25       35     72  \n",
       "26        60       50       70     97  \n",
       "27        70       40       80     77  \n",
       "28        30       31       31     70  \n",
       "29        65       61       61    100  \n",
       "..       ...      ...      ...    ...  \n",
       "887      100       86       90     40  \n",
       "888       65       45       45     45  \n",
       "889       90       65       70     65  \n",
       "890      125      100      105     85  \n",
       "891       85       95       75    130  \n",
       "892       75      130      115     95  \n",
       "893      115       85       95     75  \n",
       "894      115       95      130     85  \n",
       "895       31       29       31     37  \n",
       "896      131       29      131     37  \n",
       "897      107      113       89     97  \n",
       "898       89      137      107     97  \n",
       "899       47      127      131    103  \n",
       "900      139       53       53     79  \n",
       "901       37      137       37    151  \n",
       "902       71      173       71     83  \n",
       "903      103      107      101     61  \n",
       "904      131       59       31    109  \n",
       "905       53       97       53     43  \n",
       "906      101      127       89     79  \n",
       "907      127      113      109     77  \n",
       "908      109      157      127     77  \n",
       "909       97      167       97    129  \n",
       "910      115      130      115     65  \n",
       "911       80       90       90    125  \n",
       "912       67       73       67     73  \n",
       "913       73      127       73    121  \n",
       "914      211       53      101     13  \n",
       "915       53      151       79    107  \n",
       "916       75      102       80    143  \n",
       "\n",
       "[917 rows x 10 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t2 = table.assign(Type=table[\"Type\"].apply(splitter))\n",
    "t2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "from functools import reduce"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Bug',\n",
       " 'Dark',\n",
       " 'Dragon',\n",
       " 'Electric',\n",
       " 'Fairy',\n",
       " 'Fighting',\n",
       " 'Fire',\n",
       " 'Flying',\n",
       " 'Ghost',\n",
       " 'Grass',\n",
       " 'Ground',\n",
       " 'Ice',\n",
       " 'Normal',\n",
       " 'Poison',\n",
       " 'Psychic',\n",
       " 'Rock',\n",
       " 'Steel',\n",
       " 'Water'}"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reduce(set.union, t2[\"Type\"].apply(set))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Bug',\n",
       " 'Dark',\n",
       " 'Dragon',\n",
       " 'Electric',\n",
       " 'Fairy',\n",
       " 'Fighting',\n",
       " 'Fire',\n",
       " 'Flying',\n",
       " 'Ghost',\n",
       " 'Grass',\n",
       " 'Ground',\n",
       " 'Ice',\n",
       " 'Normal',\n",
       " 'Poison',\n",
       " 'Psychic',\n",
       " 'Rock',\n",
       " 'Steel',\n",
       " 'Water'}"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# This is what \"reduce\" does:\n",
    "result = set()\n",
    "for item in t2[\"Type\"].apply(set):\n",
    "    result = set.union(result, item)\n",
    "\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "def func(a):\n",
    "    return a * 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'string string '"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "func(\"string \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'string string '"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(lambda a: a * 2)(\"string \")"
   ]
  },
  {
   "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>Name</th>\n",
       "      <th>Total</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>Type=Poison</th>\n",
       "      <th>...</th>\n",
       "      <th>Type=Ghost</th>\n",
       "      <th>Type=Ice</th>\n",
       "      <th>Type=Dragon</th>\n",
       "      <th>Type=Electric</th>\n",
       "      <th>Type=Psychic</th>\n",
       "      <th>Type=Rock</th>\n",
       "      <th>Type=Fighting</th>\n",
       "      <th>Type=Water</th>\n",
       "      <th>Type=Fairy</th>\n",
       "      <th>Type=Steel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bulbasaur</td>\n",
       "      <td>318</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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Ivysaur</td>\n",
       "      <td>405</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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Venusaur</td>\n",
       "      <td>525</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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>VenusaurMega Venusaur</td>\n",
       "      <td>625</td>\n",
       "      <td>80</td>\n",
       "      <td>100</td>\n",
       "      <td>123</td>\n",
       "      <td>122</td>\n",
       "      <td>120</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Charmander</td>\n",
       "      <td>309</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>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Charmeleon</td>\n",
       "      <td>405</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>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Charizard</td>\n",
       "      <td>534</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "      <td>109</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard X</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>130</td>\n",
       "      <td>111</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6</td>\n",
       "      <td>CharizardMega Charizard Y</td>\n",
       "      <td>634</td>\n",
       "      <td>78</td>\n",
       "      <td>104</td>\n",
       "      <td>78</td>\n",
       "      <td>159</td>\n",
       "      <td>115</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7</td>\n",
       "      <td>Squirtle</td>\n",
       "      <td>314</td>\n",
       "      <td>44</td>\n",
       "      <td>48</td>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8</td>\n",
       "      <td>Wartortle</td>\n",
       "      <td>405</td>\n",
       "      <td>59</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>80</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>9</td>\n",
       "      <td>Blastoise</td>\n",
       "      <td>530</td>\n",
       "      <td>79</td>\n",
       "      <td>83</td>\n",
       "      <td>100</td>\n",
       "      <td>85</td>\n",
       "      <td>105</td>\n",
       "      <td>78</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9</td>\n",
       "      <td>BlastoiseMega Blastoise</td>\n",
       "      <td>630</td>\n",
       "      <td>79</td>\n",
       "      <td>103</td>\n",
       "      <td>120</td>\n",
       "      <td>135</td>\n",
       "      <td>115</td>\n",
       "      <td>78</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10</td>\n",
       "      <td>Caterpie</td>\n",
       "      <td>195</td>\n",
       "      <td>45</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11</td>\n",
       "      <td>Metapod</td>\n",
       "      <td>205</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>55</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>12</td>\n",
       "      <td>Butterfree</td>\n",
       "      <td>395</td>\n",
       "      <td>60</td>\n",
       "      <td>45</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>13</td>\n",
       "      <td>Weedle</td>\n",
       "      <td>195</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>14</td>\n",
       "      <td>Kakuna</td>\n",
       "      <td>205</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15</td>\n",
       "      <td>Beedrill</td>\n",
       "      <td>395</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>15</td>\n",
       "      <td>BeedrillMega Beedrill</td>\n",
       "      <td>495</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>80</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16</td>\n",
       "      <td>Pidgey</td>\n",
       "      <td>251</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>17</td>\n",
       "      <td>Pidgeotto</td>\n",
       "      <td>349</td>\n",
       "      <td>63</td>\n",
       "      <td>60</td>\n",
       "      <td>55</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18</td>\n",
       "      <td>Pidgeot</td>\n",
       "      <td>479</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>101</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>18</td>\n",
       "      <td>PidgeotMega Pidgeot</td>\n",
       "      <td>579</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>135</td>\n",
       "      <td>80</td>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>19</td>\n",
       "      <td>Rattata</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>19</td>\n",
       "      <td>RattataAlolan Rattata</td>\n",
       "      <td>253</td>\n",
       "      <td>30</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20</td>\n",
       "      <td>Raticate</td>\n",
       "      <td>413</td>\n",
       "      <td>55</td>\n",
       "      <td>81</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>70</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20</td>\n",
       "      <td>RaticateAlolan Raticate</td>\n",
       "      <td>413</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>21</td>\n",
       "      <td>Spearow</td>\n",
       "      <td>262</td>\n",
       "      <td>40</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22</td>\n",
       "      <td>Fearow</td>\n",
       "      <td>442</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>781</td>\n",
       "      <td>Dhelmise</td>\n",
       "      <td>517</td>\n",
       "      <td>70</td>\n",
       "      <td>131</td>\n",
       "      <td>100</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>782</td>\n",
       "      <td>Jangmo-o</td>\n",
       "      <td>300</td>\n",
       "      <td>45</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>783</td>\n",
       "      <td>Hakamo-o</td>\n",
       "      <td>420</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>90</td>\n",
       "      <td>65</td>\n",
       "      <td>70</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>784</td>\n",
       "      <td>Kommo-o</td>\n",
       "      <td>600</td>\n",
       "      <td>75</td>\n",
       "      <td>110</td>\n",
       "      <td>125</td>\n",
       "      <td>100</td>\n",
       "      <td>105</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>785</td>\n",
       "      <td>Tapu Koko</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>786</td>\n",
       "      <td>Tapu Lele</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>787</td>\n",
       "      <td>Tapu Bulu</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>85</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>788</td>\n",
       "      <td>Tapu Fini</td>\n",
       "      <td>570</td>\n",
       "      <td>70</td>\n",
       "      <td>75</td>\n",
       "      <td>115</td>\n",
       "      <td>95</td>\n",
       "      <td>130</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>789</td>\n",
       "      <td>Cosmog</td>\n",
       "      <td>200</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>790</td>\n",
       "      <td>Cosmoem</td>\n",
       "      <td>400</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>29</td>\n",
       "      <td>131</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>791</td>\n",
       "      <td>Solgaleo</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>792</td>\n",
       "      <td>Lunala</td>\n",
       "      <td>680</td>\n",
       "      <td>137</td>\n",
       "      <td>113</td>\n",
       "      <td>89</td>\n",
       "      <td>137</td>\n",
       "      <td>107</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>793</td>\n",
       "      <td>Nihilego</td>\n",
       "      <td>570</td>\n",
       "      <td>109</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>127</td>\n",
       "      <td>131</td>\n",
       "      <td>103</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900</th>\n",
       "      <td>794</td>\n",
       "      <td>Buzzwole</td>\n",
       "      <td>570</td>\n",
       "      <td>107</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>795</td>\n",
       "      <td>Pheromosa</td>\n",
       "      <td>570</td>\n",
       "      <td>71</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>137</td>\n",
       "      <td>37</td>\n",
       "      <td>151</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>796</td>\n",
       "      <td>Xurkitree</td>\n",
       "      <td>570</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "      <td>173</td>\n",
       "      <td>71</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>797</td>\n",
       "      <td>Celesteela</td>\n",
       "      <td>570</td>\n",
       "      <td>97</td>\n",
       "      <td>101</td>\n",
       "      <td>103</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>61</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>798</td>\n",
       "      <td>Kartana</td>\n",
       "      <td>570</td>\n",
       "      <td>59</td>\n",
       "      <td>181</td>\n",
       "      <td>131</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>109</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>799</td>\n",
       "      <td>Guzzlord</td>\n",
       "      <td>570</td>\n",
       "      <td>223</td>\n",
       "      <td>101</td>\n",
       "      <td>53</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>800</td>\n",
       "      <td>Necrozma</td>\n",
       "      <td>600</td>\n",
       "      <td>97</td>\n",
       "      <td>107</td>\n",
       "      <td>101</td>\n",
       "      <td>127</td>\n",
       "      <td>89</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDusk Mane Necrozma</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaDawn Wings Necrozma</td>\n",
       "      <td>680</td>\n",
       "      <td>97</td>\n",
       "      <td>113</td>\n",
       "      <td>109</td>\n",
       "      <td>157</td>\n",
       "      <td>127</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>800</td>\n",
       "      <td>NecrozmaUltra Necrozma</td>\n",
       "      <td>754</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>167</td>\n",
       "      <td>97</td>\n",
       "      <td>129</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>801</td>\n",
       "      <td>Magearna</td>\n",
       "      <td>600</td>\n",
       "      <td>80</td>\n",
       "      <td>95</td>\n",
       "      <td>115</td>\n",
       "      <td>130</td>\n",
       "      <td>115</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>802</td>\n",
       "      <td>Marshadow</td>\n",
       "      <td>600</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>803</td>\n",
       "      <td>Poipole</td>\n",
       "      <td>420</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>804</td>\n",
       "      <td>Naganadel</td>\n",
       "      <td>540</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>127</td>\n",
       "      <td>73</td>\n",
       "      <td>121</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>805</td>\n",
       "      <td>Stakataka</td>\n",
       "      <td>570</td>\n",
       "      <td>61</td>\n",
       "      <td>131</td>\n",
       "      <td>211</td>\n",
       "      <td>53</td>\n",
       "      <td>101</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>806</td>\n",
       "      <td>Blacephalon</td>\n",
       "      <td>570</td>\n",
       "      <td>53</td>\n",
       "      <td>127</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>79</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>807</td>\n",
       "      <td>Zeraora</td>\n",
       "      <td>600</td>\n",
       "      <td>88</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>102</td>\n",
       "      <td>80</td>\n",
       "      <td>143</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>917 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #                         Name  Total   HP  Attack  Defense  Sp. Atk  \\\n",
       "0      1                    Bulbasaur    318   45      49       49       65   \n",
       "1      2                      Ivysaur    405   60      62       63       80   \n",
       "2      3                     Venusaur    525   80      82       83      100   \n",
       "3      3        VenusaurMega Venusaur    625   80     100      123      122   \n",
       "4      4                   Charmander    309   39      52       43       60   \n",
       "5      5                   Charmeleon    405   58      64       58       80   \n",
       "6      6                    Charizard    534   78      84       78      109   \n",
       "7      6    CharizardMega Charizard X    634   78     130      111      130   \n",
       "8      6    CharizardMega Charizard Y    634   78     104       78      159   \n",
       "9      7                     Squirtle    314   44      48       65       50   \n",
       "10     8                    Wartortle    405   59      63       80       65   \n",
       "11     9                    Blastoise    530   79      83      100       85   \n",
       "12     9      BlastoiseMega Blastoise    630   79     103      120      135   \n",
       "13    10                     Caterpie    195   45      30       35       20   \n",
       "14    11                      Metapod    205   50      20       55       25   \n",
       "15    12                   Butterfree    395   60      45       50       90   \n",
       "16    13                       Weedle    195   40      35       30       20   \n",
       "17    14                       Kakuna    205   45      25       50       25   \n",
       "18    15                     Beedrill    395   65      90       40       45   \n",
       "19    15        BeedrillMega Beedrill    495   65     150       40       15   \n",
       "20    16                       Pidgey    251   40      45       40       35   \n",
       "21    17                    Pidgeotto    349   63      60       55       50   \n",
       "22    18                      Pidgeot    479   83      80       75       70   \n",
       "23    18          PidgeotMega Pidgeot    579   83      80       80      135   \n",
       "24    19                      Rattata    253   30      56       35       25   \n",
       "25    19        RattataAlolan Rattata    253   30      56       35       25   \n",
       "26    20                     Raticate    413   55      81       60       50   \n",
       "27    20      RaticateAlolan Raticate    413   75      71       70       40   \n",
       "28    21                      Spearow    262   40      60       30       31   \n",
       "29    22                       Fearow    442   65      90       65       61   \n",
       "..   ...                          ...    ...  ...     ...      ...      ...   \n",
       "887  781                     Dhelmise    517   70     131      100       86   \n",
       "888  782                     Jangmo-o    300   45      55       65       45   \n",
       "889  783                     Hakamo-o    420   55      75       90       65   \n",
       "890  784                      Kommo-o    600   75     110      125      100   \n",
       "891  785                    Tapu Koko    570   70     115       85       95   \n",
       "892  786                    Tapu Lele    570   70      85       75      130   \n",
       "893  787                    Tapu Bulu    570   70     130      115       85   \n",
       "894  788                    Tapu Fini    570   70      75      115       95   \n",
       "895  789                       Cosmog    200   43      29       31       29   \n",
       "896  790                      Cosmoem    400   43      29      131       29   \n",
       "897  791                     Solgaleo    680  137     137      107      113   \n",
       "898  792                       Lunala    680  137     113       89      137   \n",
       "899  793                     Nihilego    570  109      53       47      127   \n",
       "900  794                     Buzzwole    570  107     139      139       53   \n",
       "901  795                    Pheromosa    570   71     137       37      137   \n",
       "902  796                    Xurkitree    570   83      89       71      173   \n",
       "903  797                   Celesteela    570   97     101      103      107   \n",
       "904  798                      Kartana    570   59     181      131       59   \n",
       "905  799                     Guzzlord    570  223     101       53       97   \n",
       "906  800                     Necrozma    600   97     107      101      127   \n",
       "907  800   NecrozmaDusk Mane Necrozma    680   97     157      127      113   \n",
       "908  800  NecrozmaDawn Wings Necrozma    680   97     113      109      157   \n",
       "909  800       NecrozmaUltra Necrozma    754   97     167       97      167   \n",
       "910  801                     Magearna    600   80      95      115      130   \n",
       "911  802                    Marshadow    600   90     125       80       90   \n",
       "912  803                      Poipole    420   67      73       67       73   \n",
       "913  804                    Naganadel    540   73      73       73      127   \n",
       "914  805                    Stakataka    570   61     131      211       53   \n",
       "915  806                  Blacephalon    570   53     127       53      151   \n",
       "916  807                      Zeraora    600   88     112       75      102   \n",
       "\n",
       "     Sp. Def  Speed  Type=Poison     ...      Type=Ghost  Type=Ice  \\\n",
       "0         65     45            1     ...               0         0   \n",
       "1         80     60            1     ...               0         0   \n",
       "2        100     80            1     ...               0         0   \n",
       "3        120     80            1     ...               0         0   \n",
       "4         50     65            0     ...               0         0   \n",
       "5         65     80            0     ...               0         0   \n",
       "6         85    100            0     ...               0         0   \n",
       "7         85    100            0     ...               0         0   \n",
       "8        115    100            0     ...               0         0   \n",
       "9         64     43            0     ...               0         0   \n",
       "10        80     58            0     ...               0         0   \n",
       "11       105     78            0     ...               0         0   \n",
       "12       115     78            0     ...               0         0   \n",
       "13        20     45            0     ...               0         0   \n",
       "14        25     30            0     ...               0         0   \n",
       "15        80     70            0     ...               0         0   \n",
       "16        20     50            1     ...               0         0   \n",
       "17        25     35            1     ...               0         0   \n",
       "18        80     75            1     ...               0         0   \n",
       "19        80    145            1     ...               0         0   \n",
       "20        35     56            0     ...               0         0   \n",
       "21        50     71            0     ...               0         0   \n",
       "22        70    101            0     ...               0         0   \n",
       "23        80    121            0     ...               0         0   \n",
       "24        35     72            0     ...               0         0   \n",
       "25        35     72            0     ...               0         0   \n",
       "26        70     97            0     ...               0         0   \n",
       "27        80     77            0     ...               0         0   \n",
       "28        31     70            0     ...               0         0   \n",
       "29        61    100            0     ...               0         0   \n",
       "..       ...    ...          ...     ...             ...       ...   \n",
       "887       90     40            0     ...               1         0   \n",
       "888       45     45            0     ...               0         0   \n",
       "889       70     65            0     ...               0         0   \n",
       "890      105     85            0     ...               0         0   \n",
       "891       75    130            0     ...               0         0   \n",
       "892      115     95            0     ...               0         0   \n",
       "893       95     75            0     ...               0         0   \n",
       "894      130     85            0     ...               0         0   \n",
       "895       31     37            0     ...               0         0   \n",
       "896      131     37            0     ...               0         0   \n",
       "897       89     97            0     ...               0         0   \n",
       "898      107     97            0     ...               1         0   \n",
       "899      131    103            1     ...               0         0   \n",
       "900       53     79            0     ...               0         0   \n",
       "901       37    151            0     ...               0         0   \n",
       "902       71     83            0     ...               0         0   \n",
       "903      101     61            0     ...               0         0   \n",
       "904       31    109            0     ...               0         0   \n",
       "905       53     43            0     ...               0         0   \n",
       "906       89     79            0     ...               0         0   \n",
       "907      109     77            0     ...               0         0   \n",
       "908      127     77            0     ...               1         0   \n",
       "909       97    129            0     ...               0         0   \n",
       "910      115     65            0     ...               0         0   \n",
       "911       90    125            0     ...               1         0   \n",
       "912       67     73            1     ...               0         0   \n",
       "913       73    121            1     ...               0         0   \n",
       "914      101     13            0     ...               0         0   \n",
       "915       79    107            0     ...               1         0   \n",
       "916       80    143            0     ...               0         0   \n",
       "\n",
       "     Type=Dragon  Type=Electric  Type=Psychic  Type=Rock  Type=Fighting  \\\n",
       "0              0              0             0          0              0   \n",
       "1              0              0             0          0              0   \n",
       "2              0              0             0          0              0   \n",
       "3              0              0             0          0              0   \n",
       "4              0              0             0          0              0   \n",
       "5              0              0             0          0              0   \n",
       "6              0              0             0          0              0   \n",
       "7              1              0             0          0              0   \n",
       "8              0              0             0          0              0   \n",
       "9              0              0             0          0              0   \n",
       "10             0              0             0          0              0   \n",
       "11             0              0             0          0              0   \n",
       "12             0              0             0          0              0   \n",
       "13             0              0             0          0              0   \n",
       "14             0              0             0          0              0   \n",
       "15             0              0             0          0              0   \n",
       "16             0              0             0          0              0   \n",
       "17             0              0             0          0              0   \n",
       "18             0              0             0          0              0   \n",
       "19             0              0             0          0              0   \n",
       "20             0              0             0          0              0   \n",
       "21             0              0             0          0              0   \n",
       "22             0              0             0          0              0   \n",
       "23             0              0             0          0              0   \n",
       "24             0              0             0          0              0   \n",
       "25             0              0             0          0              0   \n",
       "26             0              0             0          0              0   \n",
       "27             0              0             0          0              0   \n",
       "28             0              0             0          0              0   \n",
       "29             0              0             0          0              0   \n",
       "..           ...            ...           ...        ...            ...   \n",
       "887            0              0             0          0              0   \n",
       "888            1              0             0          0              0   \n",
       "889            1              0             0          0              1   \n",
       "890            1              0             0          0              1   \n",
       "891            0              1             0          0              0   \n",
       "892            0              0             1          0              0   \n",
       "893            0              0             0          0              0   \n",
       "894            0              0             0          0              0   \n",
       "895            0              0             1          0              0   \n",
       "896            0              0             1          0              0   \n",
       "897            0              0             1          0              0   \n",
       "898            0              0             1          0              0   \n",
       "899            0              0             0          1              0   \n",
       "900            0              0             0          0              1   \n",
       "901            0              0             0          0              1   \n",
       "902            0              1             0          0              0   \n",
       "903            0              0             0          0              0   \n",
       "904            0              0             0          0              0   \n",
       "905            1              0             0          0              0   \n",
       "906            0              0             1          0              0   \n",
       "907            0              0             1          0              0   \n",
       "908            0              0             1          0              0   \n",
       "909            1              0             1          0              0   \n",
       "910            0              0             0          0              0   \n",
       "911            0              0             0          0              1   \n",
       "912            0              0             0          0              0   \n",
       "913            1              0             0          0              0   \n",
       "914            0              0             0          1              0   \n",
       "915            0              0             0          0              0   \n",
       "916            0              1             0          0              0   \n",
       "\n",
       "     Type=Water  Type=Fairy  Type=Steel  \n",
       "0             0           0           0  \n",
       "1             0           0           0  \n",
       "2             0           0           0  \n",
       "3             0           0           0  \n",
       "4             0           0           0  \n",
       "5             0           0           0  \n",
       "6             0           0           0  \n",
       "7             0           0           0  \n",
       "8             0           0           0  \n",
       "9             1           0           0  \n",
       "10            1           0           0  \n",
       "11            1           0           0  \n",
       "12            1           0           0  \n",
       "13            0           0           0  \n",
       "14            0           0           0  \n",
       "15            0           0           0  \n",
       "16            0           0           0  \n",
       "17            0           0           0  \n",
       "18            0           0           0  \n",
       "19            0           0           0  \n",
       "20            0           0           0  \n",
       "21            0           0           0  \n",
       "22            0           0           0  \n",
       "23            0           0           0  \n",
       "24            0           0           0  \n",
       "25            0           0           0  \n",
       "26            0           0           0  \n",
       "27            0           0           0  \n",
       "28            0           0           0  \n",
       "29            0           0           0  \n",
       "..          ...         ...         ...  \n",
       "887           0           0           0  \n",
       "888           0           0           0  \n",
       "889           0           0           0  \n",
       "890           0           0           0  \n",
       "891           0           1           0  \n",
       "892           0           1           0  \n",
       "893           0           1           0  \n",
       "894           1           1           0  \n",
       "895           0           0           0  \n",
       "896           0           0           0  \n",
       "897           0           0           1  \n",
       "898           0           0           0  \n",
       "899           0           0           0  \n",
       "900           0           0           0  \n",
       "901           0           0           0  \n",
       "902           0           0           0  \n",
       "903           0           0           1  \n",
       "904           0           0           1  \n",
       "905           0           0           0  \n",
       "906           0           0           0  \n",
       "907           0           0           1  \n",
       "908           0           0           0  \n",
       "909           0           0           0  \n",
       "910           0           1           1  \n",
       "911           0           0           0  \n",
       "912           0           0           0  \n",
       "913           0           0           0  \n",
       "914           0           0           1  \n",
       "915           0           0           0  \n",
       "916           0           0           0  \n",
       "\n",
       "[917 rows x 27 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t3 = \\\n",
    "    table.assign(**{f\"Type={r}\": t2[\"Type\"].apply(lambda a: r in a)\n",
    "                                           .apply(int)\n",
    "                    for r in result}) \\\n",
    "         .drop(columns=[\"Type\"])\n",
    "t3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>Type=Grass</th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">#</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>396.061881</td>\n",
       "      <td>428.605505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>235.712327</td>\n",
       "      <td>236.989218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>193.750000</td>\n",
       "      <td>253.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>386.000000</td>\n",
       "      <td>460.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>606.250000</td>\n",
       "      <td>650.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>807.000000</td>\n",
       "      <td>798.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Attack</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>80.716584</td>\n",
       "      <td>75.165138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>33.130288</td>\n",
       "      <td>27.875887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>27.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>55.000000</td>\n",
       "      <td>55.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>76.000000</td>\n",
       "      <td>70.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>100.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>190.000000</td>\n",
       "      <td>181.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Defense</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>74.637376</td>\n",
       "      <td>73.752294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>31.966656</td>\n",
       "      <td>25.294252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>30.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>50.000000</td>\n",
       "      <td>55.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>70.000000</td>\n",
       "      <td>70.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>90.000000</td>\n",
       "      <td>85.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>230.000000</td>\n",
       "      <td>131.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">HP</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>70.055693</td>\n",
       "      <td>65.770642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>26.904680</td>\n",
       "      <td>18.475025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>30.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>67.000000</td>\n",
       "      <td>65.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">Type=Psychic</th>\n",
       "      <th>std</th>\n",
       "      <td>0.329514</td>\n",
       "      <td>0.164357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Type=Rock</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.082921</td>\n",
       "      <td>0.018349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.275933</td>\n",
       "      <td>0.134829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Type=Steel</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.070545</td>\n",
       "      <td>0.027523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.256221</td>\n",
       "      <td>0.164357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Type=Water</th>\n",
       "      <th>count</th>\n",
       "      <td>808.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.170792</td>\n",
       "      <td>0.027523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.376560</td>\n",
       "      <td>0.164357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Type=Grass                   0           1\n",
       "#            count  808.000000  109.000000\n",
       "             mean   396.061881  428.605505\n",
       "             std    235.712327  236.989218\n",
       "             min      4.000000    1.000000\n",
       "             25%    193.750000  253.000000\n",
       "             50%    386.000000  460.000000\n",
       "             75%    606.250000  650.000000\n",
       "             max    807.000000  798.000000\n",
       "Attack       count  808.000000  109.000000\n",
       "             mean    80.716584   75.165138\n",
       "             std     33.130288   27.875887\n",
       "             min      5.000000   27.000000\n",
       "             25%     55.000000   55.000000\n",
       "             50%     76.000000   70.000000\n",
       "             75%    100.000000   98.000000\n",
       "             max    190.000000  181.000000\n",
       "Defense      count  808.000000  109.000000\n",
       "             mean    74.637376   73.752294\n",
       "             std     31.966656   25.294252\n",
       "             min      5.000000   30.000000\n",
       "             25%     50.000000   55.000000\n",
       "             50%     70.000000   70.000000\n",
       "             75%     90.000000   85.000000\n",
       "             max    230.000000  131.000000\n",
       "HP           count  808.000000  109.000000\n",
       "             mean    70.055693   65.770642\n",
       "             std     26.904680   18.475025\n",
       "             min      1.000000   30.000000\n",
       "             25%     50.000000   50.000000\n",
       "             50%     67.000000   65.000000\n",
       "...                        ...         ...\n",
       "Type=Psychic std      0.329514    0.164357\n",
       "             min      0.000000    0.000000\n",
       "             25%      0.000000    0.000000\n",
       "             50%      0.000000    0.000000\n",
       "             75%      0.000000    0.000000\n",
       "             max      1.000000    1.000000\n",
       "Type=Rock    count  808.000000  109.000000\n",
       "             mean     0.082921    0.018349\n",
       "             std      0.275933    0.134829\n",
       "             min      0.000000    0.000000\n",
       "             25%      0.000000    0.000000\n",
       "             50%      0.000000    0.000000\n",
       "             75%      0.000000    0.000000\n",
       "             max      1.000000    1.000000\n",
       "Type=Steel   count  808.000000  109.000000\n",
       "             mean     0.070545    0.027523\n",
       "             std      0.256221    0.164357\n",
       "             min      0.000000    0.000000\n",
       "             25%      0.000000    0.000000\n",
       "             50%      0.000000    0.000000\n",
       "             75%      0.000000    0.000000\n",
       "             max      1.000000    1.000000\n",
       "Type=Water   count  808.000000  109.000000\n",
       "             mean     0.170792    0.027523\n",
       "             std      0.376560    0.164357\n",
       "             min      0.000000    0.000000\n",
       "             25%      0.000000    0.000000\n",
       "             50%      0.000000    0.000000\n",
       "             75%      0.000000    0.000000\n",
       "             max      1.000000    1.000000\n",
       "\n",
       "[200 rows x 2 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t3.groupby(\"Type=Grass\").describe().T"
   ]
  }
 ],
 "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}