Trabalho_Pandas.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Trabalho Pandas.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/athossouza/repository/blob/master/Trabalho_Pandas.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Eu82vS1KDuUX"
      },
      "source": [
        "# Acesso aos dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jVMUv6QuDrGl",
        "outputId": "95d10153-0051-489c-c37c-1d6b8a18b3f3"
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "df = pd.read_csv('https://raw.githubusercontent.com/leonhgomes/Pandas/main/pokemon_data.csv')\n",
        "\n",
        "#Acessando o nome das colunas e o inicio e fim da tabela\n",
        "print ( df.columns )\n",
        "print(df.head(3))\n",
        "print (df.tail(2))\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Index(['#', 'Nome', 'Tipo 1', 'Tipo 2', 'Vida', 'Ataque', 'Defensa', 'Atq Esp',\n",
            "       'Def Esp', 'Velocidade', 'Geracao', 'Lendario'],\n",
            "      dtype='object')\n",
            "   #       Nome  Tipo 1    Tipo 2  ...  Def Esp  Velocidade  Geracao  Lendario\n",
            "0  1  Bulbasaur  Planta  Venenoso  ...       65          45        1     False\n",
            "1  2    Ivysaur  Planta  Venenoso  ...       80          60        1     False\n",
            "2  3   Venusaur  Planta  Venenoso  ...      100          80        1     False\n",
            "\n",
            "[3 rows x 12 columns]\n",
            "       #                Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
            "798  720  HoopaHoopa Unbound  Psiquico  ...         80        6      True\n",
            "799  721           Volcanion      Fogo  ...         70        6      True\n",
            "\n",
            "[2 rows x 12 columns]\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WFSUccMEez8K"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "9CG_BDsYGM0y",
        "outputId": "cf8217d4-0a28-4adf-fd44-34f722c87358"
      },
      "source": [
        "#Acessar colunas individuais\n",
        "#df['Nome']\n",
        "df[['Nome','Tipo 1']][0:150:2]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Charizard</td>\n",
              "      <td>Fogo</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>CharizardMega Charizard Y</td>\n",
              "      <td>Fogo</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>140</th>\n",
              "      <td>Gyarados</td>\n",
              "      <td>Agua</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>142</th>\n",
              "      <td>Lapras</td>\n",
              "      <td>Agua</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>144</th>\n",
              "      <td>Eevee</td>\n",
              "      <td>Normal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>146</th>\n",
              "      <td>Jolteon</td>\n",
              "      <td>Electric</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>148</th>\n",
              "      <td>Porygon</td>\n",
              "      <td>Normal</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>75 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                          Nome    Tipo 1\n",
              "0                    Bulbasaur    Planta\n",
              "2                     Venusaur    Planta\n",
              "4                   Charmander      Fogo\n",
              "6                    Charizard      Fogo\n",
              "8    CharizardMega Charizard Y      Fogo\n",
              "..                         ...       ...\n",
              "140                   Gyarados      Agua\n",
              "142                     Lapras      Agua\n",
              "144                      Eevee    Normal\n",
              "146                    Jolteon  Electric\n",
              "148                    Porygon    Normal\n",
              "\n",
              "[75 rows x 2 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 172
        },
        "id": "D8JcnGocHO2u",
        "outputId": "192dee4a-a80d-46a8-daca-1c1bde4401af"
      },
      "source": [
        "#acessando linhas individuais\n",
        "df.iloc[:4]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   #                   Nome  Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0  1              Bulbasaur  Planta  ...         45        1     False\n",
              "1  2                Ivysaur  Planta  ...         60        1     False\n",
              "2  3               Venusaur  Planta  ...         80        1     False\n",
              "3  3  VenusaurMega Venusaur  Planta  ...         80        1     False\n",
              "\n",
              "[4 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "T1PnoNNJHfDI",
        "outputId": "62645a9a-1d39-4778-8bb6-4b372fce489c"
      },
      "source": [
        "#acessando linhas e colunas individuais\n",
        "df.iloc[2,1]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'Venusaur'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n6jLLE7GH0KY"
      },
      "source": [
        "#busca por nome\n",
        "df.loc[df['Tipo 1'] == 'Fogo' ]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "62u7GJ2LINHa"
      },
      "source": [
        "#acessar linhas por nome\n",
        "\n",
        "for indice, linha in df.iterrows() :\n",
        "  print(indice,linha['Nome'])\n",
        "  if linha['#'] == 150 :\n",
        "    break"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        },
        "id": "kyzGV-_IISvg",
        "outputId": "cc0ef80d-028a-4516-a053-f84334d69bd1"
      },
      "source": [
        "#valores estatísticos básicos\n",
        "df.describe()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.000000</td>\n",
              "      <td>800.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>362.813750</td>\n",
              "      <td>69.258750</td>\n",
              "      <td>79.001250</td>\n",
              "      <td>73.842500</td>\n",
              "      <td>72.820000</td>\n",
              "      <td>71.902500</td>\n",
              "      <td>68.277500</td>\n",
              "      <td>3.32375</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>208.343798</td>\n",
              "      <td>25.534669</td>\n",
              "      <td>32.457366</td>\n",
              "      <td>31.183501</td>\n",
              "      <td>32.722294</td>\n",
              "      <td>27.828916</td>\n",
              "      <td>29.060474</td>\n",
              "      <td>1.66129</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>1.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",
              "      <td>1.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>184.750000</td>\n",
              "      <td>50.000000</td>\n",
              "      <td>55.000000</td>\n",
              "      <td>50.000000</td>\n",
              "      <td>49.750000</td>\n",
              "      <td>50.000000</td>\n",
              "      <td>45.000000</td>\n",
              "      <td>2.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>364.500000</td>\n",
              "      <td>65.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",
              "      <td>3.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>539.250000</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",
              "      <td>5.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>721.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",
              "      <td>6.00000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                #        Vida      Ataque  ...     Def Esp  Velocidade    Geracao\n",
              "count  800.000000  800.000000  800.000000  ...  800.000000  800.000000  800.00000\n",
              "mean   362.813750   69.258750   79.001250  ...   71.902500   68.277500    3.32375\n",
              "std    208.343798   25.534669   32.457366  ...   27.828916   29.060474    1.66129\n",
              "min      1.000000    1.000000    5.000000  ...   20.000000    5.000000    1.00000\n",
              "25%    184.750000   50.000000   55.000000  ...   50.000000   45.000000    2.00000\n",
              "50%    364.500000   65.000000   75.000000  ...   70.000000   65.000000    3.00000\n",
              "75%    539.250000   80.000000  100.000000  ...   90.000000   90.000000    5.00000\n",
              "max    721.000000  255.000000  190.000000  ...  230.000000  180.000000    6.00000\n",
              "\n",
              "[8 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SWlB0Rw2g503"
      },
      "source": [
        "# Ordenação"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "7DrC_q1Ug7gS",
        "outputId": "923a1e50-84b6-421b-97af-af9cfb4eb084"
      },
      "source": [
        "#ordem alfabética inversa\n",
        "df.sort_values('Nome',ascending=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>794</th>\n",
              "      <td>718</td>\n",
              "      <td>Zygarde50% Forme</td>\n",
              "      <td>Dragao</td>\n",
              "      <td>Terra</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "      <td>121</td>\n",
              "      <td>81</td>\n",
              "      <td>95</td>\n",
              "      <td>95</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>695</th>\n",
              "      <td>634</td>\n",
              "      <td>Zweilous</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>Dragao</td>\n",
              "      <td>72</td>\n",
              "      <td>85</td>\n",
              "      <td>70</td>\n",
              "      <td>65</td>\n",
              "      <td>70</td>\n",
              "      <td>58</td>\n",
              "      <td>5</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>41</td>\n",
              "      <td>Zubat</td>\n",
              "      <td>Venenoso</td>\n",
              "      <td>Voador</td>\n",
              "      <td>40</td>\n",
              "      <td>45</td>\n",
              "      <td>35</td>\n",
              "      <td>30</td>\n",
              "      <td>40</td>\n",
              "      <td>55</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>631</th>\n",
              "      <td>570</td>\n",
              "      <td>Zorua</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>NaN</td>\n",
              "      <td>40</td>\n",
              "      <td>65</td>\n",
              "      <td>40</td>\n",
              "      <td>80</td>\n",
              "      <td>40</td>\n",
              "      <td>65</td>\n",
              "      <td>5</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>632</th>\n",
              "      <td>571</td>\n",
              "      <td>Zoroark</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>NaN</td>\n",
              "      <td>60</td>\n",
              "      <td>105</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>60</td>\n",
              "      <td>105</td>\n",
              "      <td>5</td>\n",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>393</th>\n",
              "      <td>359</td>\n",
              "      <td>AbsolMega Absol</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65</td>\n",
              "      <td>150</td>\n",
              "      <td>60</td>\n",
              "      <td>115</td>\n",
              "      <td>60</td>\n",
              "      <td>115</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>392</th>\n",
              "      <td>359</td>\n",
              "      <td>Absol</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65</td>\n",
              "      <td>130</td>\n",
              "      <td>60</td>\n",
              "      <td>75</td>\n",
              "      <td>60</td>\n",
              "      <td>75</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>63</td>\n",
              "      <td>Abra</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25</td>\n",
              "      <td>20</td>\n",
              "      <td>15</td>\n",
              "      <td>105</td>\n",
              "      <td>55</td>\n",
              "      <td>90</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>511</th>\n",
              "      <td>460</td>\n",
              "      <td>AbomasnowMega Abomasnow</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Gelo</td>\n",
              "      <td>90</td>\n",
              "      <td>132</td>\n",
              "      <td>105</td>\n",
              "      <td>132</td>\n",
              "      <td>105</td>\n",
              "      <td>30</td>\n",
              "      <td>4</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>510</th>\n",
              "      <td>460</td>\n",
              "      <td>Abomasnow</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Gelo</td>\n",
              "      <td>90</td>\n",
              "      <td>92</td>\n",
              "      <td>75</td>\n",
              "      <td>92</td>\n",
              "      <td>85</td>\n",
              "      <td>60</td>\n",
              "      <td>4</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                     Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "794  718         Zygarde50% Forme    Dragao  ...         95        6      True\n",
              "695  634                 Zweilous   Noturno  ...         58        5     False\n",
              "46    41                    Zubat  Venenoso  ...         55        1     False\n",
              "631  570                    Zorua   Noturno  ...         65        5     False\n",
              "632  571                  Zoroark   Noturno  ...        105        5     False\n",
              "..   ...                      ...       ...  ...        ...      ...       ...\n",
              "393  359          AbsolMega Absol   Noturno  ...        115        3     False\n",
              "392  359                    Absol   Noturno  ...         75        3     False\n",
              "68    63                     Abra  Psiquico  ...         90        1     False\n",
              "511  460  AbomasnowMega Abomasnow    Planta  ...         30        4     False\n",
              "510  460                Abomasnow    Planta  ...         60        4     False\n",
              "\n",
              "[800 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UXMQ71dChyc4"
      },
      "source": [
        "# Realizando Mudanças nos dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "NrhEZQpSh1go",
        "outputId": "67bb589d-1744-420e-d8ec-be1de21fadb1"
      },
      "source": [
        "df['Total'] = df['Ataque'] + df['Atq Esp'] + df['Def Esp'] + df['Defensa'] +df['Velocidade'] + df['Vida']\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "      <th>Total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>405</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>525</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "      <td>309</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Geracao  Lendario  Total\n",
              "0      1              Bulbasaur    Planta  ...       1     False    318\n",
              "1      2                Ivysaur    Planta  ...       1     False    405\n",
              "2      3               Venusaur    Planta  ...       1     False    525\n",
              "3      3  VenusaurMega Venusaur    Planta  ...       1     False    625\n",
              "4      4             Charmander      Fogo  ...       1     False    309\n",
              "..   ...                    ...       ...  ...     ...       ...    ...\n",
              "795  719                Diancie     Pedra  ...       6      True    600\n",
              "796  719    DiancieMega Diancie     Pedra  ...       6      True    700\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...       6      True    600\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...       6      True    680\n",
              "799  721              Volcanion      Fogo  ...       6      True    600\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "Vs6Ikg2fiXtj",
        "outputId": "fbe94895-617b-4c75-f2f0-30d50faa459e"
      },
      "source": [
        "df = df.drop(columns=['Total'])\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur    Planta  ...         45        1     False\n",
              "1      2                Ivysaur    Planta  ...         60        1     False\n",
              "2      3               Venusaur    Planta  ...         80        1     False\n",
              "3      3  VenusaurMega Venusaur    Planta  ...         80        1     False\n",
              "4      4             Charmander      Fogo  ...         65        1     False\n",
              "..   ...                    ...       ...  ...        ...      ...       ...\n",
              "795  719                Diancie     Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie     Pedra  ...        110        6      True\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...         80        6      True\n",
              "799  721              Volcanion      Fogo  ...         70        6      True\n",
              "\n",
              "[800 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "P6xWxQGVitCA",
        "outputId": "9f497e4f-c6c9-4441-9ec4-0b0378aab5f6"
      },
      "source": [
        "#forma alternativa de criar coluna Total\n",
        "df['Total'] = df.iloc[:,4:10].sum(axis=1)\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defensa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "      <th>Total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>405</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>525</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "      <td>309</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Geracao  Lendario  Total\n",
              "0      1              Bulbasaur    Planta  ...       1     False    318\n",
              "1      2                Ivysaur    Planta  ...       1     False    405\n",
              "2      3               Venusaur    Planta  ...       1     False    525\n",
              "3      3  VenusaurMega Venusaur    Planta  ...       1     False    625\n",
              "4      4             Charmander      Fogo  ...       1     False    309\n",
              "..   ...                    ...       ...  ...     ...       ...    ...\n",
              "795  719                Diancie     Pedra  ...       6      True    600\n",
              "796  719    DiancieMega Diancie     Pedra  ...       6      True    700\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...       6      True    600\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...       6      True    680\n",
              "799  721              Volcanion      Fogo  ...       6      True    600\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "i3gS87yIjXFc",
        "outputId": "2a606239-a028-4010-b724-f42a439d291d"
      },
      "source": [
        "#renomeando\n",
        "df.rename({'Defensa':'Defesa'},axis=1,inplace=True)\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "      <th>Total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>405</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>525</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "      <td>625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "      <td>309</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "      <td>600</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Geracao  Lendario  Total\n",
              "0      1              Bulbasaur    Planta  ...       1     False    318\n",
              "1      2                Ivysaur    Planta  ...       1     False    405\n",
              "2      3               Venusaur    Planta  ...       1     False    525\n",
              "3      3  VenusaurMega Venusaur    Planta  ...       1     False    625\n",
              "4      4             Charmander      Fogo  ...       1     False    309\n",
              "..   ...                    ...       ...  ...     ...       ...    ...\n",
              "795  719                Diancie     Pedra  ...       6      True    600\n",
              "796  719    DiancieMega Diancie     Pedra  ...       6      True    700\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...       6      True    600\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...       6      True    680\n",
              "799  721              Volcanion      Fogo  ...       6      True    600\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "PELtDzATkezM",
        "outputId": "0657115e-f107-481b-d6ff-5e1175f951f0"
      },
      "source": [
        "#reordenar colunas\n",
        "\n",
        "#df = df[ ['Total','Vida','Defesa']    ]\n",
        "\n",
        "cols = list(df.columns.values )\n",
        "df = df [cols[0:4] + [cols[-1]] + cols[4:12]]\n",
        "df\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>700</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur    Planta  ...         45        1     False\n",
              "1      2                Ivysaur    Planta  ...         60        1     False\n",
              "2      3               Venusaur    Planta  ...         80        1     False\n",
              "3      3  VenusaurMega Venusaur    Planta  ...         80        1     False\n",
              "4      4             Charmander      Fogo  ...         65        1     False\n",
              "..   ...                    ...       ...  ...        ...      ...       ...\n",
              "795  719                Diancie     Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie     Pedra  ...        110        6      True\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...         80        6      True\n",
              "799  721              Volcanion      Fogo  ...         70        6      True\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VW4jPbhUlt7_"
      },
      "source": [
        "#Salvar Arquivos"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6jziK8C3lwkT"
      },
      "source": [
        "#df.to_csv('modificado.csv')\n",
        "df.to_csv('modificado.csv',index=False)\n",
        "\n",
        "#df.to_csv('modificado.txt',index=False,sep='\\t')\n",
        "\n",
        "#df.to_excel('modificado.xlsx',index=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2fnm90Q_qsHP"
      },
      "source": [
        "#Filtrando dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 80
        },
        "id": "P-ZKaUpqqtyL",
        "outputId": "e448f6cf-a5c7-4007-8c21-011fda3876fd"
      },
      "source": [
        "#fogo E agua\n",
        "novo_df = df.loc[(df['Tipo 1'] =='Fogo') & (df['Tipo 2'] == 'Agua') ]\n",
        "novo_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       #       Nome Tipo 1 Tipo 2  ...  Def Esp  Velocidade  Geracao  Lendario\n",
              "799  721  Volcanion   Fogo   Agua  ...       90          70        6      True\n",
              "\n",
              "[1 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "WkDmJKa1rUd4",
        "outputId": "b0e1ee9d-ae2b-452a-978e-137ba4400344"
      },
      "source": [
        "#fogo OU agua\n",
        "novo_df = df.loc[(df['Tipo 1'] =='Fogo') | (df['Tipo 1'] == 'Agua') ]\n",
        "novo_df.reset_index(drop=True,inplace=True)\n",
        "novo_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5</td>\n",
              "      <td>Charmeleon</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>6</td>\n",
              "      <td>Charizard</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Voador</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>6</td>\n",
              "      <td>CharizardMega Charizard X</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Dragao</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>6</td>\n",
              "      <td>CharizardMega Charizard Y</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Voador</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>159</th>\n",
              "      <td>667</td>\n",
              "      <td>Litleo</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Normal</td>\n",
              "      <td>369</td>\n",
              "      <td>62</td>\n",
              "      <td>50</td>\n",
              "      <td>58</td>\n",
              "      <td>73</td>\n",
              "      <td>54</td>\n",
              "      <td>72</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>668</td>\n",
              "      <td>Pyroar</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Normal</td>\n",
              "      <td>507</td>\n",
              "      <td>86</td>\n",
              "      <td>68</td>\n",
              "      <td>72</td>\n",
              "      <td>109</td>\n",
              "      <td>66</td>\n",
              "      <td>106</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>692</td>\n",
              "      <td>Clauncher</td>\n",
              "      <td>Agua</td>\n",
              "      <td>NaN</td>\n",
              "      <td>330</td>\n",
              "      <td>50</td>\n",
              "      <td>53</td>\n",
              "      <td>62</td>\n",
              "      <td>58</td>\n",
              "      <td>63</td>\n",
              "      <td>44</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>693</td>\n",
              "      <td>Clawitzer</td>\n",
              "      <td>Agua</td>\n",
              "      <td>NaN</td>\n",
              "      <td>500</td>\n",
              "      <td>71</td>\n",
              "      <td>73</td>\n",
              "      <td>88</td>\n",
              "      <td>120</td>\n",
              "      <td>89</td>\n",
              "      <td>59</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>163</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>164 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                       Nome Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      4                 Charmander   Fogo  ...         65        1     False\n",
              "1      5                 Charmeleon   Fogo  ...         80        1     False\n",
              "2      6                  Charizard   Fogo  ...        100        1     False\n",
              "3      6  CharizardMega Charizard X   Fogo  ...        100        1     False\n",
              "4      6  CharizardMega Charizard Y   Fogo  ...        100        1     False\n",
              "..   ...                        ...    ...  ...        ...      ...       ...\n",
              "159  667                     Litleo   Fogo  ...         72        6     False\n",
              "160  668                     Pyroar   Fogo  ...        106        6     False\n",
              "161  692                  Clauncher   Agua  ...         44        6     False\n",
              "162  693                  Clawitzer   Agua  ...         59        6     False\n",
              "163  721                  Volcanion   Fogo  ...         70        6      True\n",
              "\n",
              "[164 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "pOiSkYLIsJW3",
        "outputId": "a6052896-21c5-43ad-dedb-a638841e146b"
      },
      "source": [
        "#filtrando versões Mega\n",
        "novo_df = df.loc[~df['Nome'].str.contains('Mega ')]\n",
        "novo_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>5</td>\n",
              "      <td>Charmeleon</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>794</th>\n",
              "      <td>718</td>\n",
              "      <td>Zygarde50% Forme</td>\n",
              "      <td>Dragao</td>\n",
              "      <td>Terra</td>\n",
              "      <td>600</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "      <td>121</td>\n",
              "      <td>81</td>\n",
              "      <td>95</td>\n",
              "      <td>95</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>752 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                 Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1            Bulbasaur    Planta  ...         45        1     False\n",
              "1      2              Ivysaur    Planta  ...         60        1     False\n",
              "2      3             Venusaur    Planta  ...         80        1     False\n",
              "4      4           Charmander      Fogo  ...         65        1     False\n",
              "5      5           Charmeleon      Fogo  ...         80        1     False\n",
              "..   ...                  ...       ...  ...        ...      ...       ...\n",
              "794  718     Zygarde50% Forme    Dragao  ...         95        6      True\n",
              "795  719              Diancie     Pedra  ...         50        6      True\n",
              "797  720  HoopaHoopa Confined  Psiquico  ...         70        6      True\n",
              "798  720   HoopaHoopa Unbound  Psiquico  ...         80        6      True\n",
              "799  721            Volcanion      Fogo  ...         70        6      True\n",
              "\n",
              "[752 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "PL8tJJpis_95",
        "outputId": "51e80fa1-1fba-4fcc-82f1-38ef8c493927"
      },
      "source": [
        "#expressão para pokemons de agua ou fogo\n",
        "import re\n",
        "\n",
        "novo_df = df.loc[df['Tipo 1'].str.contains('fogo|agua',flags=re.I,regex=True)]\n",
        "novo_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>5</td>\n",
              "      <td>Charmeleon</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>6</td>\n",
              "      <td>Charizard</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Voador</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>6</td>\n",
              "      <td>CharizardMega Charizard X</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Dragao</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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>6</td>\n",
              "      <td>CharizardMega Charizard Y</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Voador</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>735</th>\n",
              "      <td>667</td>\n",
              "      <td>Litleo</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Normal</td>\n",
              "      <td>369</td>\n",
              "      <td>62</td>\n",
              "      <td>50</td>\n",
              "      <td>58</td>\n",
              "      <td>73</td>\n",
              "      <td>54</td>\n",
              "      <td>72</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>736</th>\n",
              "      <td>668</td>\n",
              "      <td>Pyroar</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Normal</td>\n",
              "      <td>507</td>\n",
              "      <td>86</td>\n",
              "      <td>68</td>\n",
              "      <td>72</td>\n",
              "      <td>109</td>\n",
              "      <td>66</td>\n",
              "      <td>106</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>762</th>\n",
              "      <td>692</td>\n",
              "      <td>Clauncher</td>\n",
              "      <td>Agua</td>\n",
              "      <td>NaN</td>\n",
              "      <td>330</td>\n",
              "      <td>50</td>\n",
              "      <td>53</td>\n",
              "      <td>62</td>\n",
              "      <td>58</td>\n",
              "      <td>63</td>\n",
              "      <td>44</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>763</th>\n",
              "      <td>693</td>\n",
              "      <td>Clawitzer</td>\n",
              "      <td>Agua</td>\n",
              "      <td>NaN</td>\n",
              "      <td>500</td>\n",
              "      <td>71</td>\n",
              "      <td>73</td>\n",
              "      <td>88</td>\n",
              "      <td>120</td>\n",
              "      <td>89</td>\n",
              "      <td>59</td>\n",
              "      <td>6</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>164 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                       Nome Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "4      4                 Charmander   Fogo  ...         65        1     False\n",
              "5      5                 Charmeleon   Fogo  ...         80        1     False\n",
              "6      6                  Charizard   Fogo  ...        100        1     False\n",
              "7      6  CharizardMega Charizard X   Fogo  ...        100        1     False\n",
              "8      6  CharizardMega Charizard Y   Fogo  ...        100        1     False\n",
              "..   ...                        ...    ...  ...        ...      ...       ...\n",
              "735  667                     Litleo   Fogo  ...         72        6     False\n",
              "736  668                     Pyroar   Fogo  ...        106        6     False\n",
              "762  692                  Clauncher   Agua  ...         44        6     False\n",
              "763  693                  Clawitzer   Agua  ...         59        6     False\n",
              "799  721                  Volcanion   Fogo  ...         70        6      True\n",
              "\n",
              "[164 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 110
        },
        "id": "buclhM4ot_Mj",
        "outputId": "b57664fb-d8cd-437e-efc9-a483729b4735"
      },
      "source": [
        "#filtrando pokemons que comecem com PI\n",
        "novo_df = df.loc[df['Nome'].str.contains('^pi',flags=re.I,regex=True)]\n",
        "novo_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>189</th>\n",
              "      <td>175</td>\n",
              "      <td>Togepi</td>\n",
              "      <td>Fada</td>\n",
              "      <td>NaN</td>\n",
              "      <td>245</td>\n",
              "      <td>35</td>\n",
              "      <td>20</td>\n",
              "      <td>65</td>\n",
              "      <td>40</td>\n",
              "      <td>65</td>\n",
              "      <td>20</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>501</th>\n",
              "      <td>451</td>\n",
              "      <td>Skorupi</td>\n",
              "      <td>Venenoso</td>\n",
              "      <td>Inseto</td>\n",
              "      <td>330</td>\n",
              "      <td>40</td>\n",
              "      <td>50</td>\n",
              "      <td>90</td>\n",
              "      <td>30</td>\n",
              "      <td>55</td>\n",
              "      <td>65</td>\n",
              "      <td>4</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       #     Nome    Tipo 1  Tipo 2  ...  Def Esp  Velocidade  Geracao  Lendario\n",
              "189  175   Togepi      Fada     NaN  ...       65          20        2     False\n",
              "501  451  Skorupi  Venenoso  Inseto  ...       55          65        4     False\n",
              "\n",
              "[2 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9XXV-7Leu-Ap"
      },
      "source": [
        "#Mudanças condicionais"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "dVaD24AuvAJt",
        "outputId": "04a49720-5bd0-4516-c8f6-6c03f2cd8fb0"
      },
      "source": [
        "df.loc[df['Tipo 1'] == 'Fogo', 'Tipo 1'] = 'Fogueteiro'\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>700</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome      Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur      Planta  ...         45        1     False\n",
              "1      2                Ivysaur      Planta  ...         60        1     False\n",
              "2      3               Venusaur      Planta  ...         80        1     False\n",
              "3      3  VenusaurMega Venusaur      Planta  ...         80        1     False\n",
              "4      4             Charmander  Fogueteiro  ...         65        1     False\n",
              "..   ...                    ...         ...  ...        ...      ...       ...\n",
              "795  719                Diancie       Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie       Pedra  ...        110        6      True\n",
              "797  720    HoopaHoopa Confined    Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound    Psiquico  ...         80        6      True\n",
              "799  721              Volcanion  Fogueteiro  ...         70        6      True\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "Er3qAXYzvn9O",
        "outputId": "93f9712c-2e68-4b23-f60a-d111291e1f60"
      },
      "source": [
        "df.loc[df['Total'] >500, 'Lendario'] = True\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>700</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome      Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur      Planta  ...         45        1     False\n",
              "1      2                Ivysaur      Planta  ...         60        1     False\n",
              "2      3               Venusaur      Planta  ...         80        1      True\n",
              "3      3  VenusaurMega Venusaur      Planta  ...         80        1      True\n",
              "4      4             Charmander  Fogueteiro  ...         65        1     False\n",
              "..   ...                    ...         ...  ...        ...      ...       ...\n",
              "795  719                Diancie       Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie       Pedra  ...        110        6      True\n",
              "797  720    HoopaHoopa Confined    Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound    Psiquico  ...         80        6      True\n",
              "799  721              Volcanion  Fogueteiro  ...         70        6      True\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "NxDcqN6Lv8_U",
        "outputId": "a91b5e3b-95de-415f-d895-e723a1003233"
      },
      "source": [
        "df.loc[df['Velocidade'] > 70, ['Lendario','Geracao']] = ['Teste1','Teste2']\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>Teste2</td>\n",
              "      <td>Teste1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>Teste2</td>\n",
              "      <td>Teste1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>700</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>Teste2</td>\n",
              "      <td>Teste1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>Teste2</td>\n",
              "      <td>Teste1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogueteiro</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome      Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur      Planta  ...         45        1     False\n",
              "1      2                Ivysaur      Planta  ...         60        1     False\n",
              "2      3               Venusaur      Planta  ...         80   Teste2    Teste1\n",
              "3      3  VenusaurMega Venusaur      Planta  ...         80   Teste2    Teste1\n",
              "4      4             Charmander  Fogueteiro  ...         65        1     False\n",
              "..   ...                    ...         ...  ...        ...      ...       ...\n",
              "795  719                Diancie       Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie       Pedra  ...        110   Teste2    Teste1\n",
              "797  720    HoopaHoopa Confined    Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound    Psiquico  ...         80   Teste2    Teste1\n",
              "799  721              Volcanion  Fogueteiro  ...         70        6      True\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2VLqaTMDwmf4"
      },
      "source": [
        "#Estatisticas agrupadas (Groupby)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "3dRGgKz6wsY9",
        "outputId": "f96ab4d2-2519-4802-d5d8-e2910fd53563"
      },
      "source": [
        "df = pd.read_csv('modificado.csv')\n",
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Tipo 1</th>\n",
              "      <th>Tipo 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Bulbasaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Ivysaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>VenusaurMega Venusaur</td>\n",
              "      <td>Planta</td>\n",
              "      <td>Venenoso</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>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Charmander</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>NaN</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",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>719</td>\n",
              "      <td>Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>600</td>\n",
              "      <td>50</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>100</td>\n",
              "      <td>150</td>\n",
              "      <td>50</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>719</td>\n",
              "      <td>DiancieMega Diancie</td>\n",
              "      <td>Pedra</td>\n",
              "      <td>Fada</td>\n",
              "      <td>700</td>\n",
              "      <td>50</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>160</td>\n",
              "      <td>110</td>\n",
              "      <td>110</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Confined</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Fantasma</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>130</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>798</th>\n",
              "      <td>720</td>\n",
              "      <td>HoopaHoopa Unbound</td>\n",
              "      <td>Psiquico</td>\n",
              "      <td>Noturno</td>\n",
              "      <td>680</td>\n",
              "      <td>80</td>\n",
              "      <td>160</td>\n",
              "      <td>60</td>\n",
              "      <td>170</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>799</th>\n",
              "      <td>721</td>\n",
              "      <td>Volcanion</td>\n",
              "      <td>Fogo</td>\n",
              "      <td>Agua</td>\n",
              "      <td>600</td>\n",
              "      <td>80</td>\n",
              "      <td>110</td>\n",
              "      <td>120</td>\n",
              "      <td>130</td>\n",
              "      <td>90</td>\n",
              "      <td>70</td>\n",
              "      <td>6</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>800 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       #                   Nome    Tipo 1  ... Velocidade  Geracao  Lendario\n",
              "0      1              Bulbasaur    Planta  ...         45        1     False\n",
              "1      2                Ivysaur    Planta  ...         60        1     False\n",
              "2      3               Venusaur    Planta  ...         80        1     False\n",
              "3      3  VenusaurMega Venusaur    Planta  ...         80        1     False\n",
              "4      4             Charmander      Fogo  ...         65        1     False\n",
              "..   ...                    ...       ...  ...        ...      ...       ...\n",
              "795  719                Diancie     Pedra  ...         50        6      True\n",
              "796  719    DiancieMega Diancie     Pedra  ...        110        6      True\n",
              "797  720    HoopaHoopa Confined  Psiquico  ...         70        6      True\n",
              "798  720     HoopaHoopa Unbound  Psiquico  ...         80        6      True\n",
              "799  721              Volcanion      Fogo  ...         70        6      True\n",
              "\n",
              "[800 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 43
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 634
        },
        "id": "g5o-dVgNxEEG",
        "outputId": "cdd43756-a913-492e-f1a3-c13e11a37557"
      },
      "source": [
        "df.groupby(['Tipo 1']).mean().sort_values('Ataque',ascending=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Vida</th>\n",
              "      <th>Ataque</th>\n",
              "      <th>Defesa</th>\n",
              "      <th>Atq Esp</th>\n",
              "      <th>Def Esp</th>\n",
              "      <th>Velocidade</th>\n",
              "      <th>Geracao</th>\n",
              "      <th>Lendario</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Tipo 1</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Dragao</th>\n",
              "      <td>474.375000</td>\n",
              "      <td>550.531250</td>\n",
              "      <td>83.312500</td>\n",
              "      <td>112.125000</td>\n",
              "      <td>86.375000</td>\n",
              "      <td>96.843750</td>\n",
              "      <td>88.843750</td>\n",
              "      <td>83.031250</td>\n",
              "      <td>3.875000</td>\n",
              "      <td>0.375000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lutador</th>\n",
              "      <td>363.851852</td>\n",
              "      <td>416.444444</td>\n",
              "      <td>69.851852</td>\n",
              "      <td>96.777778</td>\n",
              "      <td>65.925926</td>\n",
              "      <td>53.111111</td>\n",
              "      <td>64.703704</td>\n",
              "      <td>66.074074</td>\n",
              "      <td>3.370370</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Terra</th>\n",
              "      <td>356.281250</td>\n",
              "      <td>437.500000</td>\n",
              "      <td>73.781250</td>\n",
              "      <td>95.750000</td>\n",
              "      <td>84.843750</td>\n",
              "      <td>56.468750</td>\n",
              "      <td>62.750000</td>\n",
              "      <td>63.906250</td>\n",
              "      <td>3.156250</td>\n",
              "      <td>0.125000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Pedra</th>\n",
              "      <td>392.727273</td>\n",
              "      <td>453.750000</td>\n",
              "      <td>65.363636</td>\n",
              "      <td>92.863636</td>\n",
              "      <td>100.795455</td>\n",
              "      <td>63.340909</td>\n",
              "      <td>75.477273</td>\n",
              "      <td>55.909091</td>\n",
              "      <td>3.454545</td>\n",
              "      <td>0.090909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Metalico</th>\n",
              "      <td>442.851852</td>\n",
              "      <td>487.703704</td>\n",
              "      <td>65.222222</td>\n",
              "      <td>92.703704</td>\n",
              "      <td>126.370370</td>\n",
              "      <td>67.518519</td>\n",
              "      <td>80.629630</td>\n",
              "      <td>55.259259</td>\n",
              "      <td>3.851852</td>\n",
              "      <td>0.148148</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Noturno</th>\n",
              "      <td>461.354839</td>\n",
              "      <td>445.741935</td>\n",
              "      <td>66.806452</td>\n",
              "      <td>88.387097</td>\n",
              "      <td>70.225806</td>\n",
              "      <td>74.645161</td>\n",
              "      <td>69.516129</td>\n",
              "      <td>76.161290</td>\n",
              "      <td>4.032258</td>\n",
              "      <td>0.064516</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Fogo</th>\n",
              "      <td>327.403846</td>\n",
              "      <td>458.076923</td>\n",
              "      <td>69.903846</td>\n",
              "      <td>84.769231</td>\n",
              "      <td>67.769231</td>\n",
              "      <td>88.980769</td>\n",
              "      <td>72.211538</td>\n",
              "      <td>74.442308</td>\n",
              "      <td>3.211538</td>\n",
              "      <td>0.096154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Voador</th>\n",
              "      <td>677.750000</td>\n",
              "      <td>485.000000</td>\n",
              "      <td>70.750000</td>\n",
              "      <td>78.750000</td>\n",
              "      <td>66.250000</td>\n",
              "      <td>94.250000</td>\n",
              "      <td>72.500000</td>\n",
              "      <td>102.500000</td>\n",
              "      <td>5.500000</td>\n",
              "      <td>0.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Venenoso</th>\n",
              "      <td>251.785714</td>\n",
              "      <td>399.142857</td>\n",
              "      <td>67.250000</td>\n",
              "      <td>74.678571</td>\n",
              "      <td>68.821429</td>\n",
              "      <td>60.428571</td>\n",
              "      <td>64.392857</td>\n",
              "      <td>63.571429</td>\n",
              "      <td>2.535714</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Agua</th>\n",
              "      <td>303.089286</td>\n",
              "      <td>430.455357</td>\n",
              "      <td>72.062500</td>\n",
              "      <td>74.151786</td>\n",
              "      <td>72.946429</td>\n",
              "      <td>74.812500</td>\n",
              "      <td>70.517857</td>\n",
              "      <td>65.964286</td>\n",
              "      <td>2.857143</td>\n",
              "      <td>0.035714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Fantasma</th>\n",
              "      <td>486.500000</td>\n",
              "      <td>439.562500</td>\n",
              "      <td>64.437500</td>\n",
              "      <td>73.781250</td>\n",
              "      <td>81.187500</td>\n",
              "      <td>79.343750</td>\n",
              "      <td>76.468750</td>\n",
              "      <td>64.343750</td>\n",
              "      <td>4.187500</td>\n",
              "      <td>0.062500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Normal</th>\n",
              "      <td>319.173469</td>\n",
              "      <td>401.683673</td>\n",
              "      <td>77.275510</td>\n",
              "      <td>73.469388</td>\n",
              "      <td>59.846939</td>\n",
              "      <td>55.816327</td>\n",
              "      <td>63.724490</td>\n",
              "      <td>71.551020</td>\n",
              "      <td>3.051020</td>\n",
              "      <td>0.020408</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Planta</th>\n",
              "      <td>344.871429</td>\n",
              "      <td>421.142857</td>\n",
              "      <td>67.271429</td>\n",
              "      <td>73.214286</td>\n",
              "      <td>70.800000</td>\n",
              "      <td>77.500000</td>\n",
              "      <td>70.428571</td>\n",
              "      <td>61.928571</td>\n",
              "      <td>3.357143</td>\n",
              "      <td>0.042857</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gelo</th>\n",
              "      <td>423.541667</td>\n",
              "      <td>433.458333</td>\n",
              "      <td>72.000000</td>\n",
              "      <td>72.750000</td>\n",
              "      <td>71.416667</td>\n",
              "      <td>77.541667</td>\n",
              "      <td>76.291667</td>\n",
              "      <td>63.458333</td>\n",
              "      <td>3.541667</td>\n",
              "      <td>0.083333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Psiquico</th>\n",
              "      <td>380.807018</td>\n",
              "      <td>475.947368</td>\n",
              "      <td>70.631579</td>\n",
              "      <td>71.456140</td>\n",
              "      <td>67.684211</td>\n",
              "      <td>98.403509</td>\n",
              "      <td>86.280702</td>\n",
              "      <td>81.491228</td>\n",
              "      <td>3.385965</td>\n",
              "      <td>0.245614</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Inseto</th>\n",
              "      <td>334.492754</td>\n",
              "      <td>378.927536</td>\n",
              "      <td>56.884058</td>\n",
              "      <td>70.971014</td>\n",
              "      <td>70.724638</td>\n",
              "      <td>53.869565</td>\n",
              "      <td>64.797101</td>\n",
              "      <td>61.681159</td>\n",
              "      <td>3.217391</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Electric</th>\n",
              "      <td>363.500000</td>\n",
              "      <td>443.409091</td>\n",
              "      <td>59.795455</td>\n",
              "      <td>69.090909</td>\n",
              "      <td>66.295455</td>\n",
              "      <td>90.022727</td>\n",
              "      <td>73.704545</td>\n",
              "      <td>84.500000</td>\n",
              "      <td>3.272727</td>\n",
              "      <td>0.090909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Fada</th>\n",
              "      <td>449.529412</td>\n",
              "      <td>413.176471</td>\n",
              "      <td>74.117647</td>\n",
              "      <td>61.529412</td>\n",
              "      <td>65.705882</td>\n",
              "      <td>78.529412</td>\n",
              "      <td>84.705882</td>\n",
              "      <td>48.588235</td>\n",
              "      <td>4.117647</td>\n",
              "      <td>0.058824</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                   #       Total       Vida  ...  Velocidade   Geracao  Lendario\n",
              "Tipo 1                                       ...                                \n",
              "Dragao    474.375000  550.531250  83.312500  ...   83.031250  3.875000  0.375000\n",
              "Lutador   363.851852  416.444444  69.851852  ...   66.074074  3.370370  0.000000\n",
              "Terra     356.281250  437.500000  73.781250  ...   63.906250  3.156250  0.125000\n",
              "Pedra     392.727273  453.750000  65.363636  ...   55.909091  3.454545  0.090909\n",
              "Metalico  442.851852  487.703704  65.222222  ...   55.259259  3.851852  0.148148\n",
              "Noturno   461.354839  445.741935  66.806452  ...   76.161290  4.032258  0.064516\n",
              "Fogo      327.403846  458.076923  69.903846  ...   74.442308  3.211538  0.096154\n",
              "Voador    677.750000  485.000000  70.750000  ...  102.500000  5.500000  0.500000\n",
              "Venenoso  251.785714  399.142857  67.250000  ...   63.571429  2.535714  0.000000\n",
              "Agua      303.089286  430.455357  72.062500  ...   65.964286  2.857143  0.035714\n",
              "Fantasma  486.500000  439.562500  64.437500  ...   64.343750  4.187500  0.062500\n",
              "Normal    319.173469  401.683673  77.275510  ...   71.551020  3.051020  0.020408\n",
              "Planta    344.871429  421.142857  67.271429  ...   61.928571  3.357143  0.042857\n",
              "Gelo      423.541667  433.458333  72.000000  ...   63.458333  3.541667  0.083333\n",
              "Psiquico  380.807018  475.947368  70.631579  ...   81.491228  3.385965  0.245614\n",
              "Inseto    334.492754  378.927536  56.884058  ...   61.681159  3.217391  0.000000\n",
              "Electric  363.500000  443.409091  59.795455  ...   84.500000  3.272727  0.090909\n",
              "Fada      449.529412  413.176471  74.117647  ...   48.588235  4.117647  0.058824\n",
              "\n",
              "[18 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ajdWWUpax2TV",
        "outputId": "949ed26e-0521-45d2-863e-47e3c890f555"
      },
      "source": [
        "df['contador']=1\n",
        "\n",
        "df.groupby(['Tipo 1','Tipo 2']).count()['contador']"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Tipo 1    Tipo 2  \n",
              "Agua      Dragao      2\n",
              "          Electric    2\n",
              "          Fada        2\n",
              "          Fantasma    2\n",
              "          Gelo        3\n",
              "                     ..\n",
              "Venenoso  Lutador     2\n",
              "          Noturno     3\n",
              "          Terra       2\n",
              "          Voador      3\n",
              "Voador    Dragao      2\n",
              "Name: contador, Length: 136, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vCwcmwd2y0dQ"
      },
      "source": [
        "#Blocos de memória"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DXSfY5S4y2Lr"
      },
      "source": [
        "#carregar linhas de 5 em 5\n",
        "for df in pd.read_csv('modificado.csv',chunksize=5) :\n",
        "  print(df)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AA1ueu3aAUNM"
      },
      "source": [
        "# Plotagem de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        },
        "id": "6CtW90soAV93",
        "outputId": "464a5e3e-dd15-491b-d047-b2757ed244b7"
      },
      "source": [
        "#histograma\n",
        "\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "\n",
        "atributo='Defesa'\n",
        "\n",
        "bins = range(0,201,20)\n",
        "plt.xticks(bins)\n",
        "\n",
        "df = pd.read_csv('modificado.csv')\n",
        "\n",
        "plt.title('Distribuição dos pokemons por ' + atributo)\n",
        "plt.xlabel('Valor do atributo ' + atributo)\n",
        "plt.ylabel('Quantidade de pokemons')\n",
        "plt.hist(df[atributo],bins=bins)\n",
        "plt.show()\n",
        "\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEWCAYAAACJ0YulAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deZwcVbn/8c+XEIgsIRcScwMJGUD0GlAWA4KgRhZlk+AVWQRZBQX0AnKvJOKCy/VGVAQ3EAXCZiCySFj8sUQIbiwJsiOyGEhCEoICCYtI4Pn9cc40xdAzUzPp6k5mvu/Xq19TdWo5z+nu6aerTvUpRQRmZmYAK7U6ADMzW344KZiZWY2TgpmZ1TgpmJlZjZOCmZnVOCmYmVmNk8IKRtKZkr7SoH2tL+l5SQPy/M2SPt3LfX1J0i9KrnuDpN/n+i/vTX2d7LfX8VdBUkh6W6vj6A8kDZd0i6Qlkr7f6nhWZCu3OgB7naTZwHBgKfAq8ABwPnBWRLwGEBGf7cG+Ph0RN3a2TkQ8AayxbFHX9vXtknGtDcwFLgQuA77RiPptxSXpEOBs4KVctAi4Gfi/iPhryd0cCTwNDA7/+GqZ+Ehh+fPRiFgTGA1MAk4k/cM0lKSWfCGIiH9ExKERMT0itoqIq1oRh7VGF++7P0XEGsBawE6kBDFL0qYldz0aeMAJYdk5KSynIuK5iJgG7Asc3P7PIWmypG/l6aGSrpb0rKR/SPqdpJUkXQCsD1yVTw99UVJbPp1xuKQngN8Wyor/qBtJul3SYklX5m/2SBonaW4xRkmzJe2Up0+WdGFh2faS/phjm5O/DSJpd0l/zvufI+nkDvvcU9L9ebubJb2zs+dI0s6S/iLpOUk/BlRYtpKkL0t6XNJTks6XtFZeNkjShZL+nuu5Q9LwTuqYLWmipAckPSPpXEmDCsuPkPRIfv6nSVq3k/1sn9s7Ls8fJunBvM/rJI0urBuSjpb0cD4d8k1JG+Xnc7GkqZJWKRND3tdn876elfQTScrL3iZpRn7+npZ0SSext79PjpT0pKT5kv67sHxVSaflZU/m6VXzsnGS5ko6UdIC4NzOXk+AiHg1Ih6NiKOBGcDJhXq2Kbyn7i48l5OBg4Ev5vf7Tvn1nyDp0fw6Ty28lzt9/SUdml+XJZIek/SZruLtkyLCj+XkAcwGdqpT/gRwVJ6eDHwrT/8fcCYwMD/eD6jevoA2IEino1YH3lIoWzmvczMwD9g0r3MZcGFeNg6Y21m8pH/e9nVHA0uA/XNc6wCbF/bzLtIXkncDC4G98rK3Ay8AO+ftvgg8AqxS5zkZmuvYO697POm026fz8sPythuSTpFdDlyQl30GuApYDRgAvId02qGz1+Q+YBSwNvCHwvO/A+mUxZbAqsCPgFsK2wbwNmAXYA6wdS4fn2N7J+kU7peBP3bY7kpgMLAJ8DIwPbdlLdJpxYN7EMPVwBDSF4VFwC552RTgpPxaDAK27+Q5aMv7mZLfF+/K+2l/7b8B3Aq8FRgG/BH4ZuH1Xgp8J8f3ljr7PwT4fZ3yw4CFeXo94O/AbjnenfP8sI7/F3n+2BzTyFzvz4Ap3b3+wO7ARqQvGB8EXgS2bPVnQ1M/h1odgB+FF6PzpHArcFKerr358z/jlcDbuttX4R97wzplxaQwqbB8DPCv/I8zjvJJYSJwRck2nwb8IE9/BZhaWLYSKUmNq7PdQcCthXmR+irak8J04OjC8ncAr5A+hA/LH1zvLvmafLYwvxvwaJ4+GzilsGyNXEdbno/8XDwObFpY7zfA4R3a+SIwurDddoXls4ATC/PfB07rQQzbF5ZPBSbk6fOBs4CR3TwH7e+T/yiUnQKcnacfBXYrLPsIMDtPj8vvoUFd7P8Q6ieFXYBX8vSJ5KReWH4dryfHybwxKTwI7FiYH9HL1//XwLG9+X9eUR8+fbRiWA/4R53y75K+cV6fD3UnlNjXnB4sf5z0LXxoqShfN4r0QfEmkt4r6SZJiyQ9B3y2sP91c50AROpcn0Nqf0frFmON9B88p8Pyxwvzj5M+EIYDF5A+UC7OpztOkTSwi/Z0fE7aT890jPd50rfXYrzHkRLdfYWy0cDp+dTFs6TXVh22W1iYfqnOfPsFAmViWFCYfrGw7RdzvbfnU3aH0bVSz0OHZQCLIuKf3ey7nuL7fjTwifbnLD9v25M+7OsZDVxRWPdB0sUbXb7+knaVdGs+Ffcs6UtAT9//KzQnheWcpK1I/xy/77gsIpZExAkRsSGwJ/AFSTu2L+5kl911xI0qTK9P+nb1NOm0zmqFuAaQThXUM4d0CF7PL4FpwKiIWIt0+qu9L+BJ0j9zex3K8cyrs5/5xVgL67Z7w75yW5aSTke8EhFfj4gxwPuAPUhHHp3p+Jw82Um8q5NOlRXj/QSwl6RjC2VzgM9ExJDC4y0R8ccuYuhMmRjqiogFEXFERKxLOqXyU3V9CW2p56HDMuj+PdeZjwG/y9NzSEcKxeds9YiY1Mm2c4BdO6w/KCLmdfb6536Qy4DvAcMjYghwLYW+qv7ASWE5JWmwpD2Ai0mnZe6ts84eubNQwHOkb0Kv5cULSeege+pASWMkrUY6PXVpRLwK/BUYpNRRPJB0HnzVTvZxEbCTpH0krSxpHUmb52VrAv+IiH9K2hr4ZGG7qcDuknbMdZxAOp9e78PyGmATSf+p1FH+X8C/F5ZPAY6XtIGkNYBvA5dExFJJH5L0rpzYFpMS32sdKyg4RtLI3FF5EtDeITsFOFTS5vkD5dvAbRExu7Dtk8COwLGSjsplZwITJW0CIGktSZ/oov6ulImhLkmfkDQyzz5D+vDu6nn4iqTVctyH8sbn4cuShkkaCnyVdMlxj0kakF+zH5FOPX09L7oQ+Kikj+R1BuVO7JGd7OpM4H+VO/BzbOPzdGev/yqk9/QiYKmkXYEP96YdKzInheXPVZKWkL7pnAScSvoHrGdj4EbgeeBPwE8j4qa87P9I/6jPqnClSAkXkM7PLiB1Pv4XpKuhgKOBX5C+hb5AOof/JpF+/7Ab6UP9FVJH7WZ58dHAN3Ibv0pKBO3bPQQcSOosfRr4KOkS3X/VqeNp0rfwSaTTJRuTOoHbnZPbcgvwN+CfwOfzsn8HLiV9IDxIusrlgi6ek18C1wOPkU6LfSvHcCOpH+Qy0pHLRsB+nTwfOwITJH06Iq4gdbxeLGlxfn527aL+TpWNoRNbAbdJep509HZsRDzWxfozSKcrpwPfi4jrc/m3gJnAPcC9wJ25rCe2zXEsJvVtDQa2av8yFBFzSB30XyJ9aM8B/ofOP8NOz226Pr/XbgXem5fVff0jYgnp/T6VlCQ/mffRr7RfqWJWCUmfIl091PDfWjSDSvwIsK+T1EZKrAMjYmlro7Gq+UjBKpNP2zwBfKjVsZhZOU4KVqVzSdeD/6bVgZhZOT59ZGZmNT5SMDOzmhV6lNShQ4dGW1tbq8MwM1uhzJo16+mIqPs7oxU6KbS1tTFz5sxWh2FmtkKR9Hhny3z6yMzMapwUzMysxknBzMxqnBTMzKzGScHMzGqcFMzMrMZJwczMapwUzMysxknBzMxqVuhfNNuKo23CNS2pd/ak3VtSr9mKykcKZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZWU1lSkDRK0k2SHpB0v6Rjc/nakm6Q9HD++2+5XJJ+KOkRSfdI2rKq2MzMrL6VK9z3UuCEiLhT0prALEk3AIcA0yNikqQJwATgRGBXYOP8eC9wRv5rDdI24ZpWh2Bmy7nKjhQiYn5E3JmnlwAPAusB44Hz8mrnAXvl6fHA+ZHcCgyRNKKq+MzM7M2a0qcgqQ3YArgNGB4R8/OiBcDwPL0eMKew2dxcZmZmTVJ5UpC0BnAZcFxELC4ui4gAoof7O1LSTEkzFy1a1MBIzcys0qQgaSApIVwUEZfn4oXtp4Xy36dy+TxgVGHzkbnsDSLirIgYGxFjhw0bVl3wZmb9UJVXHwk4G3gwIk4tLJoGHJynDwauLJQflK9C2gZ4rnCayczMmqDKq4+2Az4F3Cvprlz2JWASMFXS4cDjwD552bXAbsAjwIvAoRXGZmZmdVSWFCLi94A6WbxjnfUDOKaqeMzMrHv+RbOZmdU4KZiZWY2TgpmZ1TgpmJlZjZOCmZnVOCmYmVmNk4KZmdV0mxQkbSdp9Tx9oKRTJY2uPjQzM2u2MkcKZwAvStoMOAF4FDi/0qjMzKwlyiSFpfnXxuOBH0fET4A1qw3LzMxaocwwF0skTQQOBD4gaSVgYLVhmZlZK5Q5UtgXeBk4PCIWkIa0/m6lUZmZWUt0e6SQE8GphfkncJ+CmVmfVObqo/+U9LCk5yQtlrRE0uLutjMzsxVPmT6FU4CPRsSDVQdjZmatVaZPYaETgplZ/1DmSGGmpEuAX5M6nAEo3HPZzMz6iDJJYTDp9pgfLpQF4KRgZtbHlLn6yPdKNjPrJ8pcfTRS0hWSnsqPyySNbEZwZmbWXGU6ms8FpgHr5sdVuczMzPqYMklhWEScGxFL82MyMKziuMzMrAXKJIW/5yGzB+THgcDfqw7MzMyar0xSOAzYB1gAzAf2Btz5bGbWB5W5+uhxYM8mxGJmZi3WbVKQtAHweaCtuH5EOFGYmfUxZX689mvgbNJVR69VG46ZmbVSmaTwz4j4YeWRmJlZy5VJCqdL+hpwPW8c++jOyqIyM7OWKJMU3gV8CtiB108fRZ43M7M+pExS+ASwYUT8q+pgzMystcr8TuE+YEjVgZiZWeuVOVIYAvxF0h28sU/Bl6SamfUxZZLC1yqPwszMlgtlftE8Q9JoYOOIuFHSasCA6kMzM7NmK3M/hSOAS4Gf5aL1SD9oMzOzPqZMR/MxwHbAYoCIeBh4a5VBmZlZa5RJCi8XL0eVtDLpdwpdknROvlPbfYWykyXNk3RXfuxWWDZR0iOSHpL0kZ42xMzMll2ZpDBD0peAt0jaGfgVaRyk7kwGdqlT/oOI2Dw/rgWQNAbYD9gkb/NTSe63MDNrsjJJYQKwCLgX+AxwbUSc1N1GEXEL8I+ScYwHLo6IlyPib8AjwNYltzUzswYpc0nqyRHxVeDnAPnuaxdFxAG9rPNzkg4CZgInRMQzpM7rWwvrzM1lbyLpSOBIgPXXX7+XIVh/0TbhmpbVPXvS7i2r26y3yhwpjJI0EUDSKsBlwMO9rO8MYCNgc9Jd3L7f0x1ExFkRMTYixg4b5ltFm5k1Utnbcb4rJ4argRkRcXJvKouIhRHxakS8RjryaD9FNA8YVVh1ZC4zM7Mm6jQpSNpS0pbAFsDpwL6kI4QZubzHJI0ozH6MNK4SwDRgP0mr5ju9bQzc3ps6zMys97rqU+h4aucZYEwu73bobElTgHHAUElzScNljJO0ed5+Nqnjmoi4X9JU4AFgKXBMRLza08aYmdmy6TQpRMSHlmXHEbF/neKzu1j/f4H/XZY6zcxs2ZQZ5mItSadKmpkf35e0VjOCMzOz5irT0XwOsATYJz8WA+dWGZSZmbVGmd8pbBQRHy/Mf13SXVUFZGZmrVPmSOElSdu3z0jaDnipupDMzKxVyhwpHAWcl/sRRBq64uBKozIzs5Yoc5Odu4DNJA3O84srj8rMzFqizNVH60j6IXAzcJOk0yWtU3lkZmbWdGX6FC4mjZL6cWDvPH1JlUGZmVlrlOlTGBER3yzMf0vSvlUFZGZmrVPmSOF6SftJWik/9gGuqzowMzNrvjJJ4Qjgl8DL+XEx8BlJSyS509nMrA8pc/XRms0IxMzMWq/MkYKZmfUTTgpmZlbjpGBmZjWlkoKk7SUdmqeH5bujmZlZH1PmF81fA04EJuaigcCFVQZlZmatUeZI4WPAnsALABHxJOArkszM+qAySeFfERGk+yojafVqQzIzs1YpkxSmSvoZMETSEcCNwM+rDcvMzFqhzI/XvidpZ9JtON8BfDUibqg8MjMza7oyA+KRk4ATgZlZH9dpUpC0hNyPUE9EDK4kIjMza5lOk0L7mEeSvgnMBy4g3Y7zAGBEU6IzM7OmKtPRvGdE/DQilkTE4og4AxhfdWBmZtZ8ZZLCC5IOkDQg30/hAPJvFszMrG8pkxQ+CewDLMyPT+QyMzPrY8pckjobny4yM+sXPEqqmZnVOCmYmVmNk4KZmdWUGTp7uKSzJf0mz4+RdHj1oZmZWbOVOVKYDFwHrJvn/wocV1VAZmbWOmWSwtCImAq8BhARS4FXK43KzMxaouyP19bh9fspbAM8V2lUZmbWEmVGSf0CMA3YSNIfgGHA3pVGZWZmLVHmx2t3Svog6V4KAh6KiFcqj8zMzJquq6Gz/7OTRW+XRERc3tWOJZ0D7AE8FRGb5rK1gUuANmA2sE9EPCNJwOnAbsCLwCERcWcP22JmZsuoqz6Fj+bH4cDZpCGzDwB+ARxWYt+TgV06lE0ApkfExsD0PA+wK7BxfhwJnFEufDMza6ROk0JEHBoRhwIDgTER8fGI+DiwSS7rUkTcAvyjQ/F44Lw8fR6wV6H8/EhuJd0P2vdsMDNrsjJXH42KiPmF+YXA+r2sb3hhXwuA4Xl6PWBOYb25uexNJB0paaakmYsWLeplGGZmVk+Zq4+mS7oOmJLn9wVuXNaKIyIkdXq7zy62Ows4C2Ds2LE93t7MzDpX5uqjz+VO5/fnorMi4ope1rdQ0oiImJ9PDz2Vy+cBowrrjcxlZmbWRGWOFNqvNOryaqOSpgEHA5Py3ysL5Z+TdDHwXuC5DqeszMysCcoMiLeNpDskPS/pX5JelbS4xHZTgD8B75A0Nw+iNwnYWdLDwE55HuBa4DHgEeDnwNG9bI+ZmS2DMkcKPwb2A34FjAUOAt7e3UYRsX8ni3ass24Ax5SIxczMKlTqfgoR8QgwICJejYhzefPvD8zMrA8oc6TwoqRVgLsknQLMxzfnMTPrk8p8uH8KGAB8DniBdJXQx6sMyszMWqPMJamP58mXgK9XG46ZmbVSVwPi3Uu+h0I9EfHuSiIyM7OW6epIYY/8t/2qoAvy3wPpIlmYmdmKq9Ok0H7aSNLOEbFFYdGJku7k9RFOzcysjyhz9ZEkbRcRf8gz78NXH5l1q23CNS2pd/ak3VtSr/UNZZLC4cA5ktYi3XntGcrdT8HMzFYwZa4+mgVslpMCEfFc5VGZmVlLdHX10YERcaGkL3QoByAiTq04NjMza7KujhRWz3/XrLPMVx+ZmfVBXV199LM8eWN7J3M7SdtVGpWZmbVEmauIflSyzMzMVnBd9SlsC7wPGNahX2EwaSwkMzPrY7rqU1gFWCOvU+xXWAzsXWVQZmbWGl31KcwAZkiaXBgUz8zM+rAyP15bVdJZQFtx/YjYoaqgzMysNcokhV8BZwK/AF6tNhwzM2ulMklhaUScUXkkZmbWcmUuSb1K0tGSRkhau/1ReWRmZtZ0ZY4UDs5//6dQFsCGjQ/HzMxaqcyAeBs0IxAzM2u9MkcKSNoUGAMMai+LiPOrCsrMzFqj26Qg6WvAOFJSuBbYFfg94KRgZtbHlOlo3hvYEVgQEYcCmwFrVRqVmZm1RJmk8FJEvAYslTQYeAoYVW1YZmbWCmX6FGZKGgL8HJgFPA/8qdKozMysJcpcfXR0njxT0v8DBkfEPdWGZWZmrVCmo/kD9coi4pZqQjIzs1Ypc/qo+KO1QcDWpNNIHhDPzKyPKXP66KPFeUmjgNMqi8jMzFqmzNVHHc0F3tnoQMzMrPXK9Cn8iDTWEaQksjlwZ5VB9XVtE65pdQhmZnWVuiS1ML0UmBIRf6goHjMza6GyN9l5W55+KCJerjAeMzNroU77FCQNlHQaMAc4F5gMPCZpQl6+eVMiNDOzpunqSOH7wGpAW0QsAcjDXHxP0hnALkCvhtWWNBtYQrq959KIGJtv3HMJ6V7Qs4F9IuKZ3uzfzMx6p6urj3YDjmhPCAARsRg4CtgP2H8Z6/5QRGweEWPz/ARgekRsDEzP82Zm1kRdJYXXIiI6FkbEq8CiiLi1wbGMB87L0+cBezV4/2Zm1o2uksIDkg7qWCjpQODBZaw3gOslzZJ0ZC4bHhHz8/QCYHi9DSUdKWmmpJmLFi1axjDMzKyoqz6FY4DLJR1GGtYCYCzwFuBjy1jv9hExT9JbgRsk/aW4MCJC0puOUvKys4CzAMaOHVt3HTMz651Ok0JEzAPeK2kHYJNcfG1ETF/WSvO+iYinJF1BGk9poaQRETFf0gjSfRvMzKyJyox99Fvgt42qUNLqwEoRsSRPfxj4BjANOBiYlP9e2ag6zcysnDI/Xmu04cAVktrr/2VE/D9JdwBTJR0OPA7s04LYzMz6taYnhYh4jHSf547lfyfdC9rMzFqkN6OkmplZH9WK00dmVqFWjcI7e9LuLanXGstHCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjVOCmZmVuOkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBmZjUrtzoAM+sb2iZc07K6Z0/avWV19zU+UjAzsxonBTMzq3FSMDOzGicFMzOrcVIwM7MaJwUzM6vpt5ektvLyOTOz5VW/TQpmZsuqL/42w6ePzMysxkcKZrbC8+ngxlnujhQk7SLpIUmPSJrQ6njMzPqT5SopSBoA/ATYFRgD7C9pTGujMjPrP5arpABsDTwSEY9FxL+Ai4HxLY7JzKzfWN76FNYD5hTm5wLvLa4g6UjgyDz7vKSHelnXUODpXm67rFpVt9vcP+rub/W2su6WtVnfWaa6R3e2YHlLCt2KiLOAs5Z1P5JmRsTYBoS0wtTtNvePuvtbva2suy+2eXk7fTQPGFWYH5nLzMysCZa3pHAHsLGkDSStAuwHTGtxTGZm/cZydfooIpZK+hxwHTAAOCci7q+oumU+BbUC1u0294+6+1u9ray7z7VZEVHFfs3MbAW0vJ0+MjOzFnJSMDOzmn6ZFJo1lIakUZJukvSApPslHZvL15Z0g6SH899/q6j+AZL+LOnqPL+BpNtyuy/JnflV1DtE0qWS/iLpQUnbNrHNx+fn+j5JUyQNqqLdks6R9JSk+wpldduo5Ie5/nskbVlB3d/Nz/c9kq6QNKSwbGKu+yFJH2lkvYVlJ0gKSUPzfOVtzuWfz+2+X9IphfLK2ixpc0m3SrpL0kxJW+fyhrW5p58dDX2+I6JfPUgd2I8CGwKrAHcDYyqqawSwZZ5eE/grafiOU4AJuXwC8J2K6v8C8Evg6jw/FdgvT58JHFVRvecBn87TqwBDmtFm0o8f/wa8pdDeQ6poN/ABYEvgvkJZ3TYCuwG/AQRsA9xWQd0fBlbO098p1D0mv8dXBTbI7/0Bjao3l48iXRzyODC0iW3+EHAjsGqef2sz2gxcD+xaaOfNjW5zTz87Glr3sv5zrGgPYFvgusL8RGBik+q+EtgZeAgYUXjxH6qgrpHAdGAH4Or8Znm68MHxhuehgfWuRfpgVofyZrS5/Rfxa5OurLsa+EhV7QbaOnxY1G0j8DNg/3rrNaruDss+BlyUp9/w/iZ9eG/byHqBS4HNgNm8nhQqbzMp2e9UZ71K25z3t2+e3h/4ZVVtLuyry8+ORtbdH08f1RtKY72qK5XUBmwB3AYMj4j5edECYHgFVZ4GfBF4Lc+vAzwbEUvzfFXt3gBYBJybT139QtLqNKHNETEP+B7wBDAfeA6YRXPaDZ23sdnvucNI3xorr1vSeGBeRNzdYVEz2vx24P351OAMSVs1qe7jgO9KmkN6v02sst6Snx0Nq7s/JoWmk7QGcBlwXEQsLi6LlNYbel2wpD2ApyJiViP3W9LKpMPtMyJiC+AF0mFuTRVtBsjnV8eTEtO6wOrALo2up4yq2tgdSScBS4GLmlDXasCXgK9WXVcnViYdFW4D/A8wVZKaUO9RwPERMQo4Hji7qoqa/dkB/TMpNHUoDUkDSS/qRRFxeS5eKGlEXj4CeKrB1W4H7ClpNmmk2R2A04Ehktp/sFhVu+cCcyPitjx/KSlJVN1mgJ2Av0XEooh4Bbic9Fw0o93QeRub8p6TdAiwB3BA/sCouu6NSAn47vxeGwncKenfK6633Vzg8khuJx0VD21C3QeT3lsAvyKN7kyj6+3hZ0fD6u6PSaFpQ2nkby1nAw9GxKmFRdNIbyzy3ysbWW9ETIyIkRHRRmrfbyPiAOAmYO+q6s11LwDmSHpHLtoReICK25w9AWwjabX83LfXXXm7s87aOA04KF8hsg3wXOEUQENI2oV0unDPiHixQ0z7SVpV0gbAxsDtjagzIu6NiLdGRFt+r80ldY4uoAltBn5N6mxG0ttJFzU8TYVtzp4EPpindwAeztMNa3MvPjsa93w3ohNkRXuQeur/Sroq4aQK69medHh3D3BXfuxGOr8/nfRmuhFYu8IYxvH61Ucbkv45HiF9w1m1ojo3B2bmdv8a+LdmtRn4OvAX4D7gAtIVKA1vNzCF1G/xCunD8PDO2kjq5P9Jfr/dC4ytoO5HSOeU299nZxbWPynX/RD5qplG1dth+Wxe72huRptXAS7Mr/WdwA7NaHP+v55FusLpNuA9jW5zTz87Glm3h7kwM7Oa/nj6yMzMOuGkYGZmNU4KZmZW46RgZmY1TgpmZlbjpGBNkUd8/EiHsuMkndHFNjdLasiNySW1dRxhs5f7GSLp6G7W+WP+O055hNoe7H8vSWN6uM3JkublUTsflnR5mX1I+o+8zZ8lbdSTOq3vclKwZplC+iFd0X65vCEkDWjUvrowBKibFNp/NR0R71uG/e9FGg2zp34QEZtHxMbAJcBvJQ0rUdelEbFFRDzaizqtD3JSsGa5FNg9/4q8fZCvdYHfSTpDaVz6+yV9vd7GkvaXdK/SfRK+Uyh/XtL3Jd1NGgG1uM17JN2dlx1TKB8k6dy8vz9L+lCd+taQNF3SnXm98XnRJGCj/A37u/lo4HbuehwAAAPeSURBVHeSppF+PY2k5wu7GizpGqVx/c+UtFLHdSTtLWmypPcBe5IGW7tL0kZ6fez+9vskdHsfioi4hDS88ycLz8MMSbMkXSdphKTdSAO7HSXpprzegZJuz3X/TOl+HANybPfl5+H4vO4Rku7Iz+9lSuMgWV+wrL/s9MOPsg/SUNbj8/QE4Ht5uv1XmQOAm4F35/mbgbGk5PEEMIw0CNpvgb3yOgHs00l99wAfyNPfJQ9/DJwAnJOn/yPve1CHbVcGBufpoaRfDIs3D6M8jjTo3waFsucLy/5J+kX1AOAGYO/iOnl6b2Bynp7cvk6hDR/M098ATqvTzpOB/+5QdhxwBjAQ+CMwLJfvW2h7bTvgncBVwMA8/1PgIOA9wA2F/Q7Jf9cplH0L+Hyr319+NObhIwVrpuIppOKpo30k3Qn8GdiEN58+2Yp0I5NFkYbAvoh08xOAV0mDhr2B0p3HhkTELbnogsLi7UnDIxARfyHdHObtHXcBfFvSPaThBNaj8+G+b4+Iv3Wx7LGIeDW3d/tO1nsTSWvlNszIRefxeru73Tz/fQewKXCDpLuAL5MGS+toR1ICuCOvtyMpmT0GbCjpR3l8pfaROjfNR0j3AgeQXjfrA1bufhWzhrkS+IHSrQJXi4hZecCy/wa2iohnJE0GBvVgn//MH7iNdgDpyOQ9EfGK0iigncX1Qhf76TiOTNQp70l7y9qCNP6UgPsjYttu1hdwXkRMfNMCaTPSzYo+C+xDul/DZNLR2t1Ko7OOa1jk1lI+UrCmiYjnSSOWnsPrRwmDSR+qz0kaDuxaZ9PbgQ9KGpo7k/cHZtRZr1jXs8Czktq/mR9QWPy79nml0TXXJw2cVrQW6Z4Ur+Q+h9G5fAnp9ohlba00Iu9KpFM3v8/lCyW9M5d/rLB+bf8R8RzwjKT352Wfopt25zZ9nHR7zim5XcMkbZuXDZRU71v9dGBvSW/N660tabTSPZdXiojLSEcZ7ff+XROYrzS88wF19mcrKB8pWLNNAa4gn0bK3zT/TBrZdA7wh44bRMR8SRNICUXANRFRZvjrQ4FzJAWp47XdT4Ez8qmPpcAhEfFyh20vAq7K68zM8RERf5f0B6XLW38DXNNNDHcAPwbeluO/IpdPIPWxLMr7XyOXXwz8XNJ/kfoaDgbOzB25j+U21XO8pANJNxa6jzRi6CJIHdnAD/PpqJVJd+W7v7hxRDwg6cvA9TlRvULqnH+JdBe99i+Q7UcSXyGNELoo/+1JorTlmEdJNTOzGp8+MjOzGicFMzOrcVIwM7MaJwUzM6txUjAzsxonBTMzq3FSMDOzmv8P3sP8GERX0bcAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 366
        },
        "id": "2gok9eDaCqI2",
        "outputId": "3614b6a8-203e-4da4-e2f9-41145ca26d8d"
      },
      "source": [
        "#barra vertical\n",
        "\n",
        "atributo='Defesa'\n",
        "tipos = df.groupby('Tipo 1').mean().sort_values(atributo,ascending=False)\n",
        "linha = tipos.index.tolist()\n",
        "coluna = tipos[atributo].tolist()\n",
        "figura = plt.figure(figsize=(14,4)).add_axes([0,0,1,1])\n",
        "figura.bar(linha,coluna)\n",
        "\n",
        "\n",
        "plt.xlabel('Tipos de pokemons')\n",
        "plt.ylabel('Valor médio do atributo ' +atributo)\n",
        "plt.title('Valor médio do atributo ' + atributo + 'por tipo de pokemons')\n",
        "\n",
        "\n",
        "for i,v in enumerate(coluna) :\n",
        "  plt.annotate( f\"{v:.2f}\",(i-0.3,v+1) )\n",
        "\n",
        "\n",
        "\n",
        "plt.show()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAABCYAAAFdCAYAAADfdmyaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdfZzNdf7/8cfLDJWEitFchFKYzIyJ2fDdUq0lF10sYbNTKeSn3UpF0tV2sbWkWimlTXJVy6qIJJVrJauRIYuSUgbrKiLXw/v3x+fM6czMOTMnM2fO4Hm/3T63Oef9+bzfn9f7c85J53Xe7/fHnHOIiIiIiIiIiERDhWgHICIiIiIiIiInLyUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQEZFSZ2bOzC6IcgwVzGyqmfUu4pi6vlhjfc8/MLPupXT+qF0DM7vMzL4KeL7ezH4fjVhKg5l1NLMNZvazmV0c7XhKg5nV9vUnpgzONc/MekX6PAXOeYWZ5ZTlOUVE5PilxISIiBRiZjPN7Ikg5deZ2f/yvsiXc08Cc5xzr4ZbwTnXzjk3NoIxlVg4CQ/n3ELnXINSOt8YM3uyBPXnmdkBM9tjZrvNbKmZDTSzU35FM88Cdzjnqjjnlh1rLNFUMDnknPvB158j0YxLRESkPFBiQkREghkL3GhmVqD8JuBN51xuJE5amgkP59yDzrlhpdXe8aKcJo3ucM6dAcQD/YAbgBlB3l+h1AH+G6ngSpN59P9XIiIiv4L+4RQRkWDeBc4GLssrMLMzgauBcWZ2iZl9Zma7zGyzmQ03s0rBGjKzamY2zsy2mdn3ZvZw3hc3M7vFzD41s6FmtgN4LEj9x8zsLTN7w/er+5dmVt/MHjCzrb4h/m0KnG+UL66NZvZk3nB5M4sxs2fNbLuZfQt0KHAu/5B331SQh30xb/X1oVqoC2Zm9/nOucnMeoR7DYK0E/LamtkC32HLfdMA/pg3ZN7M7jez/wGjQwyj/42ZrTKznWY22sxODXgNPikQgzOzC8ybBpMJDPCd7z3f/mTftdplZv81s2tDXZdAzrm9zrl5wLVAC3zX33etB5rZOjPbYWaTzOwsMzvFzH4GYnx9Xuc7PsHM3vFdz+/M7K4C1y/LNzpji5n9I2DfW+aN+PnJzBaYWaOAfWPM7BUz+9j3PptvZnUC9v+fmX3uq/u5mf1fwL55ZvaUmX0K7APOL3A9xwO1gfd813GAFZ5GNM/MBpnZEl/sU83srIA2rvVd612+Y5NDXWcza21ma3yxDgeswP4eZrba9174MLCfBY7Li7G373292cz6B+w/xcye9+3b5HscdCSMmd3le/8l+eo9a2Y/+F6jV8zsNN9xee/nAeZ97jab2R/MrL2ZfW1mP5rZg+HEENBWv4C2bg2o294X0x7z/lvRv3DkIiJSFpSYEBGRQpxz+4FJwM0BxV2BNc655cAR4B6gBt4XzFbAn0M09yJQDe/L2uW+Nm8N2N8M+BaoBTwVoo1rgPHAmcAy4EO8f8MSgSeAfwYcOwbIBS4ALgbaAHnz62/DS65cDGQAnUOcD+AW33alL/YqwPBgB5pZW6A/0Bq4ECi4nkNx1yBQyGvrnGvpO6axbxrAv33PzwHOwhtZEGpNjUzgKqAeUB94OMRxfr5pMG8CQ3znu8bMKgLvAR8BccCdwJtmFvbUEefcD0AWvyS+7gT+gHdtEoCdwEvOuYPOuSoBfa5nXkLnPWA53uvfCrjbzK7yHTcMGOacq+rr66SAU3+A9/rEAV/4+hYoE/gb3rXPztvvSxC8D7yAl7D7B/C+mZ0dUPcmvGt/BvB9gf7eBPwAXOO7jkNCXJqbgR54I0tyfefDzOoDE4C7gZrADLwkR6FkoJnVACbjvb41gHXAbwP2Xwc8CHTytbXQ13ZRrsS7bm2A++2XKSkPAc2BdKAxcAlB3ldm9le8z9LlzrkcYDDeezAd73OaCPw1oMo5wKkB5SOBG4GmeO+ZR8zsvDBjOAfvs5cI9AReMi/JCjAK+H++0TwpwJxiroOIiESKc06bNm3atGkrtAGXAruAU33PPwXuCXHs3cCUgOcO7wtHDHAIuChg3/8D5vke3wL8UEwcjwEfBzy/BvgZiPE9P8N3vup4yY2DwGkBx3cD5voezwH6BOxr46sb63s+D+jlezwb+HPAsQ2Aw3nHFojxdWBwwPP64V6DMF6HoNc24PkVvvZPLVCWE/B8fYF+twfWBbwGnxQ4p/8ceImeJwP2XQb8D6gQUDYBeCxE/P5rWqB8IjDS93g10CpgX3zgtS4QT7OC7xngAWC07/EC4HGgRjHXtbqv3WoB/ZwYsL8KXpLoXLykw5IC9T8Dbgno4xPFnG898PuA53WDvPcC30MX+V7XGOARYFLAvgrARuCKIOe5GVgc8NyAHH55X38A9CzQ1j6gTpC28mJsGFA2BBjle7wOaB+w7ypgfcB7cCNeEueTgOtswF6gXkC9FsB3AfX2U/jz3Szg+KXAH8KMYT8Bn1lgK9Dc9/gHvM9i1XA+i9q0adOmLXKbRkyIiEhQzrlPgO3AH8ysHt4vkf8C7xdcM5vuGxa/G/g73q+zBdUAKpL/F+Tv8X69zLMhjHC2BDzeD2x3vywauN/3twreiIGKwGbfkPddeKMp4nzHJBQ4X75ftgtICBJ3LF7yI9ixodoN5xr4/YprG2ibc+5AMccUjC+hmONDSQA2OOeOFmgvaH+KkAj86HtcB5gS8JqtxksKBLvWdYCEvGN9xz8YcGxPvMTQGt+Ui6vBP41nsHnTRXbjJQog/7X1XyPn3M+++BIo/F4I1udw3sfFKfgaVfTFl+/8vmu/geDXPN970TnnCrRbBxgWcO1+xEsWFPX6hXrvBPuMBL6vquONIhnknPvJV1YTqAwsDYhhpq88z44gn++C/w3IG0lTXAw7XP41cfYF1L0eL0n3vW/qTgtERCQqlJgQEZGijMP7BfZG4EPnXN6XgxHAGuBC5w2Zf5AC89h9tuP98h04h7023i+peVwpxrsBb8REDedcdd9W1TmXt5bAZrxfwANjCWUThePOJf8XpDxFtRvONQgU7rUNFM41LBjfJt/jvXhfFAEws3OKaXsTcK7lXyOjqP4UYmbn4g3LX+gr2gC0C3jNqjvnTnXOBWtzA96v64HHnuGcaw/gnFvrnOuGl4x6GnjbzE4H/gRchzfNphreaADIf23918jMquBNj9lE4fdCsD4X9xocy2t0GO/9k+/8Zma+Y4Ndn3zvxYBj82zAm74QeP1Oc84t+hVx5b13gn1GNgU834k3dWq0meVNJ9mOl1hoFHD+au6XKTu/VnExhOSc+9w5dx3ee+Vd8k/7ERGRMqTEhIiIFGUc3he52/Du1JHnDGA38LOZNQRuD1bZ96vnJOApMzvDt8jevcAbkQjWObcZb+2D58ysqnmLKtYzs8t9h0wC7vItwHcmMLCI5iYA95jZeb4vqX8H/u2C35FkEnCLmV1kZpWBRwNi+rXXoLhru4UCiyuG6S++fp+FNy8/b32K5UAjM0s3b0HMx4o533/wfnUeYGYVzewKvOk1E4sLwMwq+16LqcASvLUSAF7Buz51fMfV9K2FEMwSYI95i32e5hsJkWJmv/HVvdHMavpGFezy1TmKd10PAjvwEjF/D9J2ezO71Ld2w9/wpkRs8MVZ38z+ZGaxZvZHvKkW04vrc4BwXrcbA95DTwBvB7x/OphZK98aH/18fQmWTHgf7/XsZN7CmnfhrbOQ5xXgAfMt/GnewqxdionrEd9r1whvbZS8984E4GHf61UDbz2IfO9r5y12mglMNrNLfK/LSGComcX5YkgMWCPk1yo2hmDMrJKZZZpZNefcYbzP3NHi6omISGQoMSEiIiE559bjffk5HZgWsKs/3i/Qe/C+ZPy7UOVf3In3q/y3eHPN/4W3JkOk3AxUAlbh/WL7Nt6aBeDF+iHel/Ev8BYJDOV1vAU3FwDfAQfw+lKIc+4D4Hm8NSy+ofAier/mGhR3bR8DxvqGwXctIv6C/oWXtPkWb17+k77Yv8b7EjwLWOuLL9Ao4CLf+d51zh3CS0S0w/v1+2XgZufcmiLOPdzM9uB9OX8eeAdoGzAdZBje++sj33GL8daSKMT3Rf1qvMUOv/PF8BreKAiAtsB/zbubxzDgBuct5joOb5j/Rrz3xuIQ1+hRvOkNTfFGCuGc2+E7Zz+8xMYA4Grn3PYi+lzQILwv0LuKuPvDeLy1Lv6Ht/jjXb7zf+WL5UVff6/BW0jzUMEGfDF1wVtgcgfeopWfBuyfgjeSZKJvSstKvNeyKPPx3tezgWedcx/5yp/EW8R0BfAl3mfqySAxfYy3qOd7ZtYEuN/X3mJfDLPw1nA5FmHFEMJNwHpfDH3wEigiIhIF5k09FBERETl5mdkYvAVDi71bSYTOPw94wzn3WjTOH4yZ1cVL/lQMMVJIRESkVGjEhIiIiIiIiIhEjRITIiIiIiIiIhI1msohIiIiIiIiIlGjERMiIiIiIiIiEjVKTIiIiIiIiIhI1MRGO4CSqFGjhqtbt260wxARERERERGRIixdunS7c65msH3HdWKibt26ZGVlRTsMERERERERESmCmX0fap+mcoiIiIiIiIhI1CgxISIiIiIiIiJRo8REOdKjRw/i4uJISUnxl9133300bNiQtLQ0OnbsyK5du/z7VqxYQYsWLWjUqBGpqakcOHCgUJuPPPIIaWlppKen06ZNGzZt2gTAM888Q3p6Ounp6aSkpBATE8OPP/4Y+U6KiIiIiIiIBDDnXLRjOGYZGRnuRFpjYsGCBVSpUoWbb76ZlStXAvDRRx/xu9/9jtjYWO6//34Ann76aXJzc2nSpAnjx4+ncePG7Nixg+rVqxMTE5Ovzd27d1O1alUAXnjhBVatWsUrr7yS75j33nuPoUOHMmfOnDLopYiIiIiIiJxszGypcy4j2D6NmChHWrZsyVlnnZWvrE2bNsTGemuUNm/enJycHMBLWKSlpdG4cWMAzj777EJJCcCflADYu3cvZlbomAkTJtCtW7dS64eIiIiIiIhIuJSYOI68/vrrtGvXDoCvv/4aM+Oqq66iSZMmDBkyJGS9hx56iHPPPZc333yTJ554It++ffv2MXPmTK6//vqIxi4iIiIiIiISjBITx4mnnnqK2NhYMjMzAcjNzeWTTz7hzTff5JNPPmHKlCnMnj07ZN0NGzaQmZnJ8OHD8+177733+O1vf1topIaIiIiIiIhIWVBi4jgwZswYpk+fzptvvumfipGUlETLli2pUaMGlStXpn379nzxxRdFtpOZmck777yTr2zixImaxiEiIiIiIiJRo8REOTdz5kyGDBnCtGnTqFy5sr/8qquu4ssvv2Tfvn3k5uYyf/58LrrookL1165d6388depUGjZs6H/+008/MX/+fK677rrIdkJEREREREQkBCUmypFu3brRokULvvrqK5KSkhg1ahR33HEHe/bsoXXr1qSnp9OnTx8AzjzzTO69915+85vfkJ6eTpMmTejQoQMAvXr1Iu9uJQMHDiQlJYW0tDQ++ugjhg0b5j/flClTaNOmDaeffnrZd1ZEREREREQE3S5URERERERERCJMtwsVERERERERkXIpNtoBnIzqDnw/2iEUa/3gDtEOQURERERERE4CGjEhIiIiIiIiIlGjxISIiIiIiIiIRI0SEyIiIiIiIiISNUpMiIiIiIiIiEjUKDEhIiIiIiIiIlGjxISIiIiIiIiIRI0SEyIiIiIiIiISNUpMiIiIiIiIiEjUKDEhIiIiIiIiIlETscSEmb1uZlvNbGVA2TNmtsbMVpjZFDOrHrDvATP7xsy+MrOrIhWXiIiIiIiIiJQfkRwxMQZoW6DsYyDFOZcGfA08AGBmFwE3AI18dV42s5gIxiYiIiIiIiIi5UDEEhPOuQXAjwXKPnLO5fqeLgaSfI+vAyY65w46574DvgEuiVRsIiIiIiIiIlI+RHONiR7AB77HicCGgH05vrJCzKy3mWWZWda2bdsiHKKIiIiIiIiIRFJUEhNm9hCQC7z5a+s65151zmU45zJq1qxZ+sGJiIiIiIiISJmJLesTmtktwNVAK+ec8xVvBM4NOCzJVyYiIiIiIiIiJ7AyHTFhZm2BAcC1zrl9AbumATeY2Slmdh5wIbCkLGMTERERERERkbIXsRETZjYBuAKoYWY5wKN4d+E4BfjYzAAWO+f6OOf+a2aTgFV4Uzz+4pw7EqnYRERERERERKR8iFhiwjnXLUjxqCKOfwp4KlLxiIiIiIiIiEj5E827coiIiIiIiIjISU6JCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmRERERERERCRqlJgQERERERERkahRYkJEREREREREokaJCRERERERERGJGiUmJGJ69OhBXFwcKSkp/rIff/yR1q1bc+GFF9K6dWt27twJgHOOu+66iwsuuIC0tDS++OKLoG1OmDCB1NRU0tLSaNu2Ldu3by+yXRERERERESnflJiQiLnllluYOXNmvrLBgwfTqlUr1q5dS6tWrRg8eDAAH3zwAWvXrmXt2rW8+uqr3H777YXay83NpW/fvsydO5cVK1aQlpbG8OHDi2xXREREREREyjclJiRiWrZsyVlnnZWvbOrUqXTv3h2A7t278+677/rLb775ZsyM5s2bs2vXLjZv3pyvrnMO5xx79+7FOcfu3btJSEgosl0REREREREp35SYkDK1ZcsW4uPjATjnnHPYsmULABs3buTcc8/1H5eUlMTGjRvz1a1YsSIjRowgNTWVhIQEVq1aRc+ePYtsV0RERERERMo3JSYkaswMMwv7+MOHDzNixAiWLVvGpk2bSEtLY9CgQSVuV0RERERERKJHiQkpU7Vq1fJP0di8eTNxcXEAJCYmsmHDBv9xOTk5JCYm5qubnZ0NQL169TAzunbtyqJFi4psV0RERERERMo3JSakTF177bWMHTsWgLFjx3Ldddf5y8eNG4dzjsWLF1OtWjX/1Iw8iYmJrFq1im3btgHw8ccfk5ycXGS7IiIiIiIiUr7FRjsAOXF169aNefPmsX37dpKSknj88ccZOHAgXbt2ZdSoUdSpU4dJkyYB0L59e2bMmMEFF1xA5cqVGT16tL+d9PR0srOzSUhI4NFHH6Vly5ZUrFiROnXqMGbMGICQ7YqIiIiIiEj5Zs65yDRs9jpwNbDVOZfiKzsL+DdQF1gPdHXO7TRvQYBhQHtgH3CLc+6L4s6RkZHhsrKyIhJ/JNUd+H60QyjW+sEdoh2CiIiIiIiInCDMbKlzLiPYvmKncphZTTN71sxmmNmcvC2M844B2hYoGwjMds5dCMz2PQdoB1zo23oDI8JoX0RERERERESOc+FM5XgTb5RDB6AP0B3YVlwl59wCM6tboPg64Arf47HAPOB+X/k45w3fWGxm1c0s3jm3OYz4JIqOh9EfoBEgIiIiIiIi5VU4i1+e7ZwbBRx2zs13zvUAfneM56sVkGz4H1DL9zgR2BBwXI6vTEREREREREROYOGMmDjs+7vZzDoAm4CzSnpi55wzs1+9wIWZ9cab7kHt2rVLGoaIiIiIiIiIRFE4IyaeNLNqQD+gP/AacM8xnm+LmcUD+P5u9ZVvBM4NOC7JV1aIc+5V51yGcy6jZs2axxiGiIiIiIiIiJQHxSYmnHPTnXM/OedWOueudM41dc5NO8bzTcNbowLf36kB5Tebpznwk9aXEBERERERETnxhXNXjiFmVtXMKprZbDPbZmY3hlFvAvAZ0MDMcsysJzAYaG1ma4Hf+54DzAC+Bb4BRgJ/Psb+iIiIiIiIiMhxJJw1Jto45waYWUdgPdAJWAC8UVQl51y3ELtaBTnWAX8JIxYREREREREROYGEs8ZEXvKiA/CWc+6nCMYjIiIiIiIiIieRcEZMTDezNcB+4HYzqwkciGxYIiIiIiIiInIyCGfxy4HA/wEZzrnDwD7gukgHJiIiIiIiIiInvnAWv6yMtxjlCF9RApARyaBERERERERE5OQQzhoTo4FDeKMmADYCT0YsIhERERERERE5aYSTmKjnnBsCHAZwzu0DLKJRiYiIiIiIiMhJIZzExCEzOw1wAGZWDzgY0ahERERERERE5KQQzl05HgVmAuea2ZvAb4FbIhmUiIiIiIiIiJwcQiYmzOy3zrlPgQVAJ6A53hSOvs657WUUn4iIiIiIiIicwIoaMfEC0BT4zDnXBHi/bEISERERERERkZNFUYmJw2b2KpBkZi8U3OmcuytyYYmIiIiIiIjIyaCoxMTVwO+Bq4ClZROOiIiIiIiIiJxMQiYmfOtITDSz1c655WUYk4iIiIiIiIicJMK5Xeh+M5ttZisBzCzNzB6OcFwiIiIiIiIichIIJzExEngAOAzgnFsB3BDJoERERERERETk5BBOYqKyc25JgbLcSAQjUp4NHTqURo0akZKSQrdu3Thw4ADOOR566CHq169PcnIyL7xQaJ1Yvv/+e5o0aUJ6ejqNGjXilVde8e+bMGECqamppKWl0bZtW7Zv1514RURERETk5FLU4pd5tptZPcABmFlnYHNEoxIpZzZu3MgLL7zAqlWrOO200+jatSsTJ07EOceGDRtYs2YNFSpUYOvWrYXqxsfH89lnn3HKKafw888/k5KSwrXXXktcXBx9+/Zl1apV1KhRgwEDBjB8+HAee+yxsu+giIiIiIhIlISTmPgL8CrQ0Mw2At8BmRGNSqQcys3NZf/+/VSsWJF9+/aRkJDAww8/zL/+9S8qVPAGH8XFxRWqV6lSJf/jgwcPcvToUQCcczjn2Lt3L2effTa7d+/mggsuKJvOiIiIiIiIlBPFTuVwzn3rnPs9UBNo6Jy71Dn3feRDEyk/EhMT6d+/P7Vr1yY+Pp5q1arRpk0b1q1bx7///W8yMjJo164da9euDVp/w4YNpKWlce6553L//feTkJBAxYoVGTFiBKmpqSQkJLBq1Sp69uxZJv0JNi0lz1133UWVKlWC1jt8+DDdu3cnNTWV5ORkBg0alG//kSNHuPjii7n66qsjGr+IiIiIiJw4ikxMmFkDM3vOzN4HJgGPmln9sglNpPzYuXMnU6dO5bvvvmPTpk3s3buXN954g4MHD3LqqaeSlZXFbbfdRo8ePYLWP/fcc1mxYgXffPMNY8eOZcuWLRw+fJgRI0awbNkyNm3aRFpaWqEv+pGQNy0lKyuLlStXcuTIESZOnAhAVlYWO3fuDFn3rbfe4uDBg3z55ZcsXbqUf/7zn6xfv96/f9iwYSQnJ0e6CyIiIiIicgIJmZgwsxbAPGAP3lSOkcBeYJ6ZNS+T6ETKiVmzZnHeeedRs2ZNKlasSKdOnVi0aBFJSUl06tQJgI4dO7JixYoi20lISCAlJYWFCxeSnZ0NQL169TAzunbtyqJFiyLeF/hlWkpubq5/WsqRI0e47777GDJkSMh6ZsbevXv99StVqkTVqlUByMnJ4f3336dXr15l0gcRERERETkxFDVi4q9AN+fcY865qc65d51zjwLdgEfLJjyR8qF27dosXryYffv24Zxj9uzZJCcn84c//IG5c+cCMH/+fOrXLzygKCcnh/379wPeyItPPvmEBg0akJiYyKpVq9i2bRsAH3/8cZmMNgg1LWX48OFce+21xMfHh6zbuXNnTj/9dOLj46lduzb9+/fnrLPOAuDuu+9myJAh/vU2REREREREwlHU4pf1nHPzChY65+ab2auRC0mk/GnWrBmdO3emSZMmxMbGcvHFF9O7d2/2799PZmYmQ4cOpUqVKrz22muANyXilVde4bXXXmP16tX069cPM8M5R//+/UlNTQXg0UcfpWXLllSsWJE6deowZsyYiPclcFpK9erV6dKlC+PGjeOtt95i3rx5RdZdsmQJMTExbNq0iZ07d3LZZZfx+9//nlWrVhEXF0fTpk2LbUNERERERCSQOeeC7zBb6pxrGmLfF865JhGNLAwZGRkuKysr2mH8anUHvh/tEIq1fnCHsI47HvoC4ffnZPDWW28xc+ZMRo0aBcC4ceN49NFH2b9/P6eeeioAP/zwA+effz7ffPNNvrp/+ctfaN68OTfddBMAPXr0oG3btixbtozx48cTGxvLgQMH2L17N506deKNN94o286JiIiIiEi55MsxZATbV9SIiXPN7IVg7QGJpRKZSDlzPCRaSppkCZyWctpppzF79mzuvfde7rzzTv8xVapUKZSUyKs7Z84cbrrpJvbu3cvixYu5++676dq1q3/hznnz5vHss88qKSEiIiIiImEpKjFxXxH7jr9hCiIChJ6WEsq0adPIysriiSee4C9/+Qu33norjRo1wjnHrbfeSlpaWhlGLyIiIiIiJ5qQUzmOB5rKETkn61SO46E/mpZS2NChQ3nttdcwM1JTUxk9ejSvvfYazz//POvWrWPbtm3UqFEjaN22bduyePFiLr30UqZPn+4vnzNnDv379+fQoUM0bdqUUaNGERtbVC5XRERERERCKWoqh5bPF5Hj2saNG3nhhRfIyspi5cqVHDlyhIkTJ/Lb3/6WWbNmUadOnSLr33fffYwfPz5f2dGjR+nevTsTJ05k5cqV1KlTh7Fjx0ayGyIiIiIiJy39/CdygjoeRn9A6YwAyc3NZf/+/VSsWJF9+/aRkJDAxRdfHFbdVq1aFbqTyI4dO6hUqZL/9q+tW7dm0KBB9OzZs8SxioiIiIhIfhoxISLHtcTERPr370/t2rWJj4+nWrVqtGnTpkRt1qhRg9zcXEgcUvMAACAASURBVPKmir399tts2LChNMIVEREREZECik1MmFmSmU0xs21mttXM3jGzpLIITkSkODt37mTq1Kl89913bNq0ib1795b4jiBmxsSJE7nnnnu45JJLOOOMM4iJiSmliEVEREREJFA4IyZGA9OAeCABeM9XJiISdbNmzeK8886jZs2aVKxYkU6dOrFo0aISt9uiRQsWLlzIkiVLaNmypX9ah4iIiIiIlK5wEhM1nXOjnXO5vm0MUDPCcYmIhKV27dosXryYffv24Zxj9uzZJCcnl7jdrVu3AnDw4EGefvpp+vTpU+I2RURERESksHASEzvM7EYzi/FtNwI7Ih2YiEg4mjVrRufOnWnSpAmpqakcPXqU3r1788ILL5CUlEROTg5paWn06tULgKysLP9jgMsuu4wuXbowe/ZskpKS+PDDDwF45plnSE5OJi0tjWuuuYbf/e53UemfiIiIiMiJzpxzRR9gVgd4EWgBOGARcKdzLuorwWVkZLi8xemOJ8fD3RLCvVPC8dAXOLH6cyL1BUrnrhwiIiIiIlK+mdlS51xGsH3hjJhIcs5d65yr6ZyLc879AahdwoDuMbP/mtlKM5tgZqea2Xlm9h8z+8bM/m1mlUpyDhEREREREREp/2LDOOZFoEkYZWExs0TgLuAi59x+M5sE3AC0B4Y65yaa2StAT2DEsZxDRE48x8MIEI3+EBERERH59UImJsysBfB/QE0zuzdgV1WgpPfNiwVOM7PDQGVgM/A74E++/WOBx1BiQkREREREROSEVtRUjkpAFbwkwhkB226g87Ge0Dm3EXgW+AEvIfETsBTY5ZzL9R2WAyQGq29mvc0sy8yytm3bdqxhiIiIiIiIiEg5EHLEhHNuPjDfzMY4574vrROa2ZnAdcB5wC7gLaBtuPWdc68Cr4K3+GVpxSUiIiIiIiIiZS+cNSbGmFmhBIBz7ljvnfd74Dvn3DYAM5sM/BaobmaxvlETScDGY2xfRERERERERI4T4SQm+gc8PhW4HsgNcWw4fgCam1llYD/QCsgC5uJNEZkIdAemluAcIiIiIiIiInIcKDYx4ZxbWqDoUzNbcqwndM79x8zeBr7AS3Asw5ua8T4w0cye9JWNOtZziIiIiIiIiMjxodjEhJmdFfC0AtAUqFaSkzrnHgUeLVD8LXBJSdoVERERERERkeNLUXflyLMUb6rFUuAzoB/QM5JBiYicjL766ivS09P9W9WqVXn++ee57777aNiwIWlpaXTs2JFdu3YFrT9s2DBSUlJo1KgRzz//vL/8scceIzEx0d/ujBkzyqpLIiIiIiLFKjYx4Zw7zzl3vu/vhc65Ns65T8oiOBGRk0mDBg3Izs4mOzubpUuXUrlyZTp27Ejr1q1ZuXIlK1asoH79+gwaNKhQ3ZUrVzJy5EiWLFnC8uXLmT59Ot98841//z333ONvu3379mXZLRERERGRIhWbmDCzU83sXjObbGbvmNndZnZqWQQnInKymj17NvXq1aNOnTq0adOG2Fhv5l3z5s3JyckpdPzq1atp1qwZlStXJjY2lssvv5zJkyeXddgiIiIiIr9aOFM5xgGNgBeB4b7H4yMZlIjIyW7ixIl069atUPnrr79Ou3btCpWnpKSwcOFCduzYwb59+5gxYwYbNmzw7x8+fDhpaWn06NGDnTt3RjT2PKGmprz11ls0atSIChUqkJWVVWQbR44c4eKLL+bqq6/2l2VmZtKgQQNSUlLo0aMHhw8fjnRXRERERCSCwklMpDjnejrn5vq22/CSEyIiEgGHDh1i2rRpdOnSJV/5U089RWxsLJmZmYXqJCcnc//999OmTRvatm1Leno6MTExANx+++2sW7eO7Oxs4uPj6devX5n0I9TUlJSUFCZPnkzLli2LbWPYsGEkJyfnK8vMzGTNmjV8+eWX7N+/n9deey1SXfALlWT58ccfad26NRdeeCGtW7cOmfQZMGAAjRo1Ijk5mbvuugvnHABLly4lNTWVCy64IF+5iIiIyMkknMTEF2bWPO+JmTXDWwxTREQi4IMPPqBJkybUqlXLXzZmzBimT5/Om2++iZkFrdezZ0+WLl3KggULOPPMM6lfvz4AtWrVIiYmhgoVKnDbbbexZMkx3/H5mAVOTUlOTqZBgwbF1snJyeH999+nV69e+crbt2+PmWFmXHLJJUGntpS2UEmWwYMH06pVK9auXUurVq0YPHhwobqLFi3i008/ZcWKFaxcuZLPP/+c+fPnA17SaOTIkaxdu5a1a9cyc+bMiPcFSpZomTt3br66p556Ku+++y6g0SwiIiJybEImJszsSzNbgXd70EVmtt7MvsO7M0dGWQUoInKymTBhQr5pHDNnzmTIkCFMmzaNypUrh6y3detWAH744QcmT57Mn/70JwA2b97sP2bKlCmkpKREKPLQQk1NKcrdd9/NkCFDqFAh+D9Vhw8fZvz48bRt27Y0QgxbYJJl6tSpdO/eHYDu3bv7v6AHMjMOHDjAoUOHOHjwIIcPH6ZWrVps3ryZ3bt307x5c8yMm2++OWj9SChJouXKK6/0150zZw6VK1emTZs2wPE3miU7O5sWLVrQqFEj0tLS+Pe//+3f17NnTxo3bkxaWhqdO3fm559/jnhfRERETlZFjZi4GrgGaAucB1wOXOF7XHiCs4iIlNjevXv5+OOP6dSpk7/sjjvuYM+ePbRu3Zr09HT69OkDwKZNm/LdYeP666/noosu4pprruGll16ievXqgDeNIDU1lbS0NObOncvQoUPLtE+hpqYUZfr06cTFxdG0adOQx/z5z3+mZcuWXHbZZaURZtgCkyxbtmwhPj4egHPOOYctW7YUOr5FixZceeWVxMfHEx8fz1VXXUVycjIbN24kKSnJf1xSUhIbN24sm04E+LWJlkBvv/027dq18yfMjrfRLJUrV2bcuHH897//ZebMmdx9993+2/EOHTqU5cuXs2LFCmrXrs3w4cMj3hcREZGTVWwR+3Y653ab2VllFo2IyEnu9NNPZ8eOHfnKAm/7GSghIYEZM2b4ny9cuDDocePHR3e94mBTU4rz6aefMm3aNGbMmMGBAwfYvXs3N954I2+88QYAjz/+ONu2beOf//xnpMIOKi/JEuyWrXlfyAv65ptvWL16tf9LeuvWrVm4cCGnnXZaxOMNx69NtBSse++99xYqzxvNMmzYsNIPuAgFkyzz5s0DvCTLFVdcwdNPP53v+LzpTuB9nuLi4ti2bRvVq1enatWqADjn2L9/f8gpVCIiIlJyRSUm/oU3amIp4IDAf5EdcH4E4xIROWHVHfh+tEMIy/rBHUqlnYJTU8IxaNAg/5f/efPm8eyzz/qTEq+99hoffvghs2fPDjnNI1IKJlnypmTEx8ezefNm4uLiCtWZMmUKzZs3p0qVKgC0a9eOzz77jJtuuinfiIKcnBwSExPLpiM+x5JoybN582a+/PJLrrrqqkL7jpfRLIGWLFnCoUOHqFevnr/s1ltvZcaMGVx00UU899xzkQu8gF27dtGrVy9WrlyJmfH6669z2mmn0adPHw4cOEBsbCwvv/wyl1xySaG6AwYM4P333+fo0aO0bt2aYcOGsX//frp06cK6deuIiYnhmmuuCTqCREREJFpC/h+dc+5q8/6P5HLn3PnOufMCNiUlRESkWMGmpkyZMoWkpCQ+++wzOnTo4P9iW3BqSih9+vRhy5YttGjRgvT0dJ544omIxV9QwSTLtddey9ixYwEYO3Ys1113XaE6tWvXZv78+eTm5nL48GHmz59PcnIy8fHxVK1alcWLF+OcY9y4cUHrR1KoRAsQMtGSZ9KkSXTs2JGKFSvmK88bzfKPf/wjcoEHUdSUoXCSLDfddBOjR4/Ol+waPXo0mzZtIjk5Od/6E5HWt29f2rZty5o1a1i+fDnJyckMGDCARx99lOzsbJ544gkGDBhQqF5RC63279+fNWvWsGzZMj799FM++OCDMuuPiIhIcYr8qcl59y07Pn7aExGRcidvakq1atX8ZR07diQnJ4eDBw+yZcsWPvzwQ6Dw1JQ8V1xxBdOnT/c/z83N9d/+NDs7m7/+9a+R7wjBkywDBw7k448/5sILL2TWrFkMHDgQgKysLP/dRDp37ky9evVITU2lcePGNG7cmGuuuQaAl19+mV69enHBBRdQr1492rUr2yWcjiXREqou/DKaZcKECeVmNAsUnWTZvXs3HTp04KmnnqJ58+aF9sfExHDDDTfwzjvvRC74AD/99BMLFiygZ8+eAFSqVInq1atjZuzevdt/TEJCQqG6oRZarVy5MldeeaW/vSZNmpTJ+h/gjf7o3LkzDRs2JDk5mc8++4w//vGP/sVK69atS3p6eqF6oRY1BcKqX976E6oueIuwNm/enPT0dDIyMqJy5yQRkWgraipHni/M7DfOuc8jHo2IiEg5FWz9j7PPPpvZs2cXOjYjI8N/R4qYmJiQa2FkZGSwcuXK0g82DHmJlsDYBg4cSNeuXRk1ahR16tRh0qRJgJdoeeWVV/x9Wr9+PRs2bODyyy/P12afPn2oU6cOLVq0AKBTp05lljgKlWQZOHBgyCTLoUOH6NixIzfffDOdO3f2lzvnWLduHRdccAHOOaZNm0bDhg3LpB/fffcdNWvW5NZbb2X58uU0bdqUYcOG8fzzz3PVVVfRv39/jh49yqJFiwrVDVxo1TnHHXfcQXJycr5jdu3axXvvvUffvn3LpD95oz/efvttDh06xL59+/KNPunXr1++xGWevEVNAY4cOUJiYiIdO3YECKt+pBxrf0LVBfyjYdq1a8eMGTMYMGCAf30UEZGTRTiJiWZAppl9D+zFW2vCOefSIhqZiIgcF46HNTNKa72ME8mxJloA6tatG/QOIrm5uaUfaBiONckyadIkFixYwI4dOxgzZgwAY8aMIS0tje7du7N7926cczRu3JgRI0aUSV9yc3P54osvePHFF2nWrBl9+/Zl8ODB/PTTTwwdOpTrr7+eSZMm0bNnT2bNmpWvbqiFVvPW+sjNzaVbt27cddddnH9+5Gfl5o3+yLu2lSpVolKlSv79zjkmTZrEnDlzimwncFHTQOHWLy0l6U9RdcMZDSMicqILJzFReFUrERGRE9DxkGSB8BMtx0N/SiNpdKxJlhtvvJEbb7wxaJuffvppieM6FklJSSQlJdGsWTPAmwo0ePBgPvnkE/9dTrp06eKfKhQo1EKreYmJ3r17c+GFF3L33XeXSV9Cjf44/fTTAe9OQrVq1eLCCy8ssp3ARU0DhVu/tJSkP0XVDWc0TCQEW2S1RYsWvPjii7z00kvExMTQoUMHhgwZkq/egQMHaNmyJQcPHiQ3N5fOnTvz+OOP+/t5ww03sGPHDpo2bcr48ePzJW/KY382bNjAzTffzJYtWzAzevfu7R9R9NhjjzFy5Ehq1qwJwN///vew1kISkV8vnMTEk865mwILzGw8cFOI40VERERK1fGQZIGSJ1rOOecczj33XL766isaNGjA7Nmzueiii/j222+ZP38+V1xxBXPmzAn65bd27dqMHDmSBx54AOcc8+fP9ychHn74YX766ad8I18iLdToj7/97W9AeHfsKerOMcdyx5+SKEl/iqo7YsSIYkfDREKwqSVz585l6tSpLF++nFNOOYWtW7cWqnfKKacwZ84cqlSpwuHDh7n00ktp164dzZs35/777+eee+7hhhtuoE+fPowaNYrbb7894n0pSX9iY2N57rnnaNKkCXv27KFp06a0bt2aiy66CIB77rmH/v37l0kf8gRLsnz44YdhJUmGDRvGyJEjcc5x2223+f8b8MgjjzB16lQqVKhAXFwcY8aMKbPROcfan6+++oo//vGP/ufffvstTzzxBHfffTdvvfUWjz32GKtXr2bJkiVkZGSUSV8kcsJZmapR4BMziwGaRiYcERERkZPbiy++SGZmJmlpaWRnZ/Pggw8ycuRI+vXrR+PGjXnwwQd59dVXgfAWWs3JyeGpp55i1apVNGnShPT09DJJUAQb/fHFF18A3hf1yZMn5/vSEUzBRU3zhFu/NJWkP0XVHTt2rH9R3S5dupTJ4pehFlkdMWIEAwcO5JRTTgEIumismflH5Rw+fJjDhw9jZjjnmDNnjn+9lu7du/Puu+9GvC8l7U98fDxNmjQB4IwzziA5OTnoVLWyFOzOPOAlSfIWfg6WlFi5ciUjR45kyZIlLF++nOnTp/PNN98AcN9997FixQqys7O5+uqry/SOVsfan7y1ZrKzs1m6dCmVK1f2rzWTkpLC5MmTadmyZZn1QyIrZGLCzB4wsz1Ampnt9m17gK3A1DKLUEREROQkkp6eTlZWFitWrODdd9/lzDPP5NJLL2Xp0qUsX76c//znPzRt6v1GFGyh1dWrV7Nq1Sr/LVuTkpJwzrF69Wr//+QHmwpS2gJHfwD+0R8As2bNomHDhiQlJRXZRqhRCOHWL00l6U9RdRMSEvy3dQ01Gqa0BU4tufjii+nVqxd79+7l66+/ZuHChTRr1ozLL7+czz8Pvvb9kSNHSE9PJy4ujtatW9OsWTN27NhB9erViY31BmQnJSWV2Rf8kvYnz/r161m2bJk/gQQwfPhw0tLS6NGjBzt37ox0V0ImWcKxevVqmjVrRuXKlYmNjeXyyy9n8uTJAFStWtV/3N69e4u8hXJpKkl/AhVcayY5OZkGDRqUaqwSXSGncjjnBgGDzGyQc+6BMoxJRERE5IR2PExNKY31P/JGfxw6dIjzzz+f0aNHA8HXjdi0aRO9evXy3zY42KKmeUKtOxFpJelPqLojR46kb9++5Obmcuqpp/pHw0RSqKklubm5/PjjjyxevJjPP/+crl278u233xb6EhsTE0N2dja7du2iY8eOrFy5knPOOSficYdS0v4A/Pzzz1x//fU8//zz/i/xt99+O4888ghmxiOPPEK/fv14/fXXI9qXUOuRgJckGTduHBkZGTz33HOceeaZ+eqmpKTw0EMPsWPHDk477TRmzJiRb4rDQw89xLhx46hWrRpz586NaD9Koz+BovWZl7JT7FQO59wDZnammV1iZi3ztrIITkRERESOX8FGf4B395M+ffrkOzYhIcH/JR5+WdQ02O03g9UvCyXpT6i6oUbDRFKoqSVJSUl06tQJM+OSSy6hQoUKbN++PWQ71atX58orr2TmzJmcffbZ7Nq1y393npycHBITEyPel9Loz+HDh7n++uvJzMz0T6sBqFWrFjExMVSoUIHbbrutTKbZ5CVZbr/9dpYtW8bpp5/O4MGDuf3221m3bh3Z2dnEx8fTr1+/QnWTk5O5//77adOmDW3btiU9PZ2YmBj//qeeeooNGzaQmZnJ8OHDI96XkvYnT95aM126dCmTmCU6ik1MmFkvYAHwIfC47+9jkQ1LREREREQiIdTUkj/84Q/+X9K//vprDh06RI0aNfLV3bZtG7t27QJg//79fPzxxzRs2BAz48orr+Ttt98GvLUzrrvuunLfH+ccPXv2JDk5mXvvvTffvs2bN/sfT5kyhZSUlAj3JHSSJdwkSc+ePVm6dCkLFizgzDPPpH79+oWOyczM5J133oloP/KUtD8Qeq0ZObGEc1eOvsBvgMXOuSvNrCHw98iGJSIiIiLHgxNtWsqJ1p9Qgk0tOf300+nRowcpKSlUqlSJsWPHYmb5pqVs3ryZ7t27c+TIEY4ePUrXrl25+uqrAXj66ae54YYbePjhh7n44ov96wqUhWPtz6effsr48eNJTU0lPT0d+OUOEQMGDCA7Oxszo27dukGnFZW2UHfm2bx5M/Hx8UDRSZKtW7cSFxfHDz/8wOTJk1m8eDEAa9eu9a9fMnXqVBo2bBjxvpRGf6Ds78Aj0RFOYuKAc+6AmWFmpzjn1piZVhoRERERETlO5U0tKeiNN94oVBY4LSUtLY1ly5YFbfP8888vk+kOwRxrfy699FKcc0HbHD9+fOkGGaZgSZa77roraJKk4Fom119/PTt27KBixYq89NJL/oUmBw4cyFdffUWFChWoU6cOr7zyynHRn1BrzUyZMoU777yTbdu20aFDB9LT0/nwww/LrE9S+sJJTOSYWXXgXeBjM9sJfB/ZsERERERERE4+wZIsoZIkBdcyWbhwYdDjymrqRjAl6U/eWjMFdezY0X/rUDkxFJuYcM7lveKPmdlcoBowM6JRiYiIiIhIiZxo01JOtP6IyC/CGTHh55ybH6lARERERERETgYnWpLlROuPlL1i78ohIiIiIiIiIhIpSkyIiIiIiIiISNSElZgws1pmdrVvi4t0UCIiIiIiIiLlSd26df23ls3IyABg+fLltGjRgtTUVK655hp2794dtO7QoUNp1KgRKSkpdOvWjQMHDgBwyy23cN5555Genk56ejrZ2dll1p/ypNjEhJl1BZYAXYCuwH/MrHOkAxMREREREREpT+bOnUt2drb/TiO9evVi8ODBfPnll3Ts2JFnnnmmUJ2NGzfywgsvkJWVxcqVKzly5AgTJ07073/mmWfIzs4mOzub9PT0MutLeRLOiImHgN8457o7524GLgEeiWxYIiIiIiIiIuXb119/TcuWLQFo3bp1yFuz5ubmsn//fnJzc9m3bx8JCQllGWa5F05iooJzbmvA8x1h1hMRERERERE5IZgZbdq0oWnTprz66qsANGrUiKlTpwLw1ltvsWHDhkL1EhMT6d+/P7Vr1yY+Pp5q1arRpk0b//6HHnqItLQ07rnnHg4ePFg2nSlnwkkwzDSzD83sFjO7BXgfmBHZsERERERERETKj08++YQvvviCDz74gJdeeokFCxbw+uuv8/LLL9O0aVP27NlDpUqVCtXbuXMnU6dO5bvvvmPTpk3s3buXN954A4BBgwaxZs0aPv/8c3788Ueefvrpsu5WuVBsYsI5dx/wKpDm2151zt0f6cBEREREREREyovExEQA4uLi6NixI0uWLKFhw4Z89NFHLF26lG7dulGvXr1C9WbNmsV5551HzZo1qVixIp06dWLRokUAxMfHY2accsop3HrrrSxZsqRM+1RehDUlwzn3jnPuXt82paQnNbPqZva2ma0xs9Vm1sLMzjKzj81sre/vmSU9j4iIiIiIiEhJ7d27lz179vgff/TRR6SkpLB1q7fqwdGjR3nyySfp06dPobq1a9dm8eLF7Nu3D+ccs2fPJjk5GYDNmzcD4Jzj3XffJSUlpYx6VL6ETEyY2R4z2x1qK+F5hwEznXMNgcbAamAgMNs5dyEw2/dcREREREREJKq2bNnCpZdeSuPGjbnkkkvo0KEDbdu2ZcKECdSvX5+GDRuSkJDArbfeCsCmTZto3749AM2aNaNz5840adKE1NRUjh49Su/evQHIzMwkNTWV1NRUtm/fzsMPPxy1PkZTbKgdzrkzAMzsb8BmYDxgQCYQf6wnNLNqQEvgFt95DgGHzOw64ArfYWOBeYCmjIiIiIiIiEhUnX/++SxfvrxQed++fenbt2+h8oSEBGbM+GVpxscff5zHH3+80HFz5swp3UCPU+FM5bjWOfeyc26Pc263c24EcF0JznkesA0YbWbLzOw1MzsdqOWc2+w75n9ArRKcQ0RERERERESOAyFHTATYa2aZwETAAd2AvSU8ZxPgTufcf8xsGAWmbTjnnJm5YJXNrDfQG7y5OiIiIiIiIiKloe7A96MdQrHWD+4Q7RBKXTgjJv4EdAW2+LYuvrJjlQPkOOf+43v+Nl6iYouZxQP4/m4NVtk596pzLsM5l1GzZs0ShCEiIiIiIiIi0VbsiAnn3HpKNnWjYHv/M7MNZtbAOfcV0ApY5du6A4N9f6eW1jlFREREREREpHwKZypHJNwJvGlmlYBvgVvxRm9MMrOewPd4ozRERERERERE5AQWlcSEcy4byAiyq1VZxyIiIiIiIiIi0RPOGhMiIiIiIiIiIhFRbGLCzKqZ2VAzy/Jtz5lZtbIITkRERERERERObOGMmHgd2I235kNX3+PRkQxKRERERP5/e3ceJVtV3n38++MiXgQuKPASHDE4LeKACKgBFdQkKlFRWBJijBgTEuMYJYqviWIwEZxniQOBKIIaRRAHJMgVUCPjZRJRX4UEI4rRqCiiwPP+cXZzi6aqu7pvV1VT/f2s1avP2VV1zrNP7TM9Z59TkiStDMM8Y2LHqtqvZ/y1SdaNKiBJkiRJkrRyDNNj4voke86MJNkDuH50IUmSJEmSpJVimB4TzwOObc+VCPBj4KBRBiVJkiRJklaGeRMT7ac9H5JkTRv/2cijkiRJkiRJK8LAxESSP6mqDyd56axyAKrqLSOOTZIkSZIkTbm5ekxs1v5vMY5AJEmSJEnSyjMwMVFV/9z+v3Z84UiSJEmSpJVkrls53jHXB6vqRUsfjiRJkiRJWknm+rnQ89vfamAX4Fvtb2dgk9GHJkmSJEmSpt1ct3IcC5DkecCeVXVjGz8KOGs84UmSJEmSpGk2V4+JGXcG1vSMb97KJEmSJEmSNshcv8ox4wjgwiRnAAEeDRw2yqAkSZIkSdLKMG9ioqr+JcnngIe3oldU1TWjDUuSJEmSJK0E897KkSTA44GHVNVJwCZJdh95ZJIkSZIkaer1TUwk2TPJqjb6HuCRwIFt/OfAu8cQmyRJkiRJmnKDekzcDLy3DT+8qp4P/Aqgqn6CPxcqSZIkSZKWQN9nTFTVV5L8so3+pvWeKIAk29IlLiRJkiRJkjbIwGdMVNW6NvgO4ETg/yT5R+Bs4J/GEJskSZIkSZpyw/wqx3FJzgceR/dzoftW1eUjj0ySJEmSJE29eRMTzQ+As9r7N02yS1VdMLqwJEmSJEnSSjBvYiLJ4cBBwP+jPWei/X/s6MKSJEmSJEkrwTA9Jp4B7FhVvx51MJIkSZIkaWUZ+PDLHpcCW406EEmSJEmStPIM02Pi9cCFSS4FbpgprKqnjCwqtbkM0AAAHcdJREFUSZIkSZK0IgyTmDgWOBK4BLh5tOFIkiRJkqSVZJjExC+r6h0jj0SSJEmSJK04wyQmzkryeuBkbn0rhz8XKkmSJEmSNsgwiYmHtv+P6Cnz50IlSZIkSdIGmzcxUVV7jyMQSZIkSZK08gzzc6GSJEmSJEkjYWJCkiRJkiRNzJyJiSQbJfndUcw4yaokFyY5pY3fO8nXknw7yUeTbDKK+UqSJEmSpOVjzsREVd0MvHtE834xcHnP+JHAW6vqPsBPgOeOaL6SJEmSJGmZGOZWjtOT7JckSzXTJHcH9gE+0MZD9ysf/9beciyw71LNT5IkSZIkLU/DJCb+Evg48OskP0vy8yQ/28D5vg14OXBzG98a+N+qurGNXw3cbQPnIUmSJEmSlrl5ExNVtUVVbVRVd6iqNW18zWJnmOQPgR9W1fmL/PzBSc5Lct6111672DAkSZIkSdIysPEwb0ryFODRbXRtVZ2yAfPcA3hKkicBq4E1wNuBrZJs3HpN3B34Xr8PV9X7gPcB7LrrrrUBcUiSJEmSpAmbt8dEkiPoHlT59fb34iSvX+wMq+qVVXX3qtoB+CPgi1X1TOAMYP/2tmcDJy12HpIkSZIk6fZhmB4TTwJ2br/QQZJjgQuBVy5xLK8ATkjyujb9Dy7x9CVJkiRJ0jIz1K0cwFbAj9vwlks186paC6xtw98Bdl+qaUuSJEmSpOVvmMTE64ELk5wBhO5ZE4eONCpJkiRJkrQizJuYqKrjk6wFdmtFr6iqa0YalSRJkiRJWhEGJiaS7DKr6Or2/65J7lpVF4wuLEmSJEmStBLM1WPizXO8VsBjlzgWSZIkSZK0wgxMTFTV3uMMRJIkSZIkrTxD/SpHkgcCOwGrZ8qq6l9HFZQkSZIkSVoZ5k1MJHkNsBddYuKzwBOBswETE5IkSZIkaYNsNMR79gceB1xTVc8BHgJsOdKoJEmSJEnSijBMYuL6qroZuDHJGuCHwD1GG5YkSZIkSVoJhnnGxHlJtgLeD5wPXAd8daRRSZIkSZKkFWFgYiLJu4GPVNVft6KjknweWFNVF48lOkmSJEmSNNXm6jHxTeBNSbYHPgYcX1UXjicsSZIkSZK0Egx8xkRVvb2qHgk8Bvgf4Ogk30jymiT3G1uEkiRJkiRpas378MuquqqqjqyqhwIHAvsCl488MkmSJEmSNPXmTUwk2TjJk5McB3wOuAJ4+sgjkyRJkiRJU2+uh1/+Hl0PiScB5wAnAAdX1S/GFJskSZIkSZpycz388pXAR4CXVdVPxhSPJEmSJElaQQYmJqrqseMMRJIkSZIkrTzzPmNCkiRJkiRpVExMSJIkSZKkiTExIUmSJEmSJsbEhCRJkiRJmhgTE5IkSZIkaWJMTEiSJEmSpIkxMSFJkiRJkibGxIQkSZIkSZoYExOSJEmSJGliTExIkiRJkqSJMTEhSZIkSZImxsSEJEmSJEmaGBMTkiRJkiRpYkxMSJIkSZKkiTExIUmSJEmSJsbEhCRJkiRJmhgTE5IkSZIkaWLGnphIco8kZyT5epLLkry4ld8lyWlJvtX+33ncsUmSJEmSpPGaRI+JG4GXVdVOwCOA5yfZCTgUOL2q7guc3sYlSZIkSdIUG3tioqq+X1UXtOGfA5cDdwOeChzb3nYssO+4Y5MkSZIkSeM10WdMJNkBeCjwNWC7qvp+e+kaYLsBnzk4yXlJzrv22mvHEqckSZIkSRqNiSUmkmwOfAJ4SVX9rPe1qiqg+n2uqt5XVbtW1a7bbrvtGCKVJEmSJEmjMpHERJI70CUljquqT7biHyTZvr2+PfDDScQmSZIkSZLGZxK/yhHgg8DlVfWWnpdOBp7dhp8NnDTu2CRJkiRJ0nhtPIF57gE8C7gkybpW9n+BI4CPJXkucBXwjAnEJkmSJEmSxmjsiYmqOhvIgJcfN85YJEmSJEnSZE30VzkkSZIkSdLKZmJCkiRJkiRNjIkJSZIkSZI0MSYmJEmSJEnSxJiYkCRJkiRJE2NiQpIkSZIkTYyJCUmSJEmSNDEmJiRJkiRJ0sSYmJAkSZIkSRNjYkKSJEmSJE2MiQlJkiRJkjQxJiYkSZIkSdLEmJiQJEmSJEkTY2JCkiRJkiRNjIkJSZIkSZI0MSYmJEmSJEnSxJiYkCRJkiRJE2NiQpIkSZIkTYyJCUmSJEmSNDEmJiRJkiRJ0sSYmJAkSZIkSRNjYkKSJEmSJE2MiQlJkiRJkjQxJiYkSZIkSdLEmJiQJEmSJEkTY2JCkiRJkiRNjIkJSZIkSZI0MSYmJEmSJEnSxJiYkCRJkiRJE2NiQpIkSZIkTYyJCUmSJEmSNDEmJiRJkiRJ0sSYmJAkSZIkSRNjYkKSJEmSJE3MsktMJHlCkiuSfDvJoZOOR5IkSZIkjc6ySkwkWQW8G3gisBNwYJKdJhuVJEmSJEkalWWVmAB2B75dVd+pql8DJwBPnXBMkiRJkiRpRJZbYuJuwH/1jF/dyiRJkiRJ0hRKVU06hlsk2R94QlX9eRt/FvDwqnpBz3sOBg5uo/cHrhh7oMvTNsCPJh3EEpmmusB01Wea6gLTVR/rsnxNU32mqS4wXfWZprrAdNVnmuoC01WfaaoLTFd9pqkuMH31Wax7VdW2/V7YeNyRzON7wD16xu/eym5RVe8D3jfOoG4PkpxXVbtOOo6lME11gemqzzTVBaarPtZl+Zqm+kxTXWC66jNNdYHpqs801QWmqz7TVBeYrvpMU11g+uozCsvtVo5zgfsmuXeSTYA/Ak6ecEySJEmSJGlEllWPiaq6MckLgFOBVcDRVXXZhMOSJEmSJEkjsqwSEwBV9Vngs5OO43Zomm5vmaa6wHTVZ5rqAtNVH+uyfE1TfaapLjBd9ZmmusB01Wea6gLTVZ9pqgtMV32mqS4wffVZcsvq4ZeSJEmSJGllWW7PmJAkSZIkSSuIiYkJSVJJPtwzvnGSa5OcMs/ndk7ypCGmv9fMtJI8JcmhGx71wiW5Kcm6JJcm+XiSOy3gs2uTTOzptT2xX5bkoiQvSzJV60ySrVsd1yW5Jsn3esY3WQbx3dQTz7okOyxiGgcluevSRzd6SfZt24oHTDqWpZJkuyQfSfKdJOcn+WqSp83x/h2SXDrOGAfE0XdbluS6DZjmxNrmhsQ9YHp7JfndpZzmHPOqJG/uGT8kyWHzfGbfJDuNPLi5YzgjyR/MKntJkvdOKqZxW4pt+rgs5PglyWeTbLXI+eya5B2Lj3RB85q9/A9t5Ys63prvmHTUdRvFOtV7/DxOC9kmD3su0OdzEz2u7oljUduBJIclOWS00Q2c94L3OyOIYVl8f6M0VSdZtzO/AB6YZNM2/nvM+mnUAXYGFrQxqqqTq+qIBca3VK6vqp2r6oHAr4G/2tAJJlm14WENZSb236H7fp4IvKZPPMvuWS3Dqqr/aXXcGTgKeOvMeFX9etDnZtd5hMvg+p54dq6qKxcxjYOA22ViAjgQOLv9v91LEuBTwJlV9dtV9TC6X1+6+2QjG8qSb8u4fbfN2fYCxpKYAG4Anp5kmwV8Zl9gQYmJEWzXjqdr773+qJWvFEuxTR+Xodf5qnpSVf3vYmZSVedV1YsWG+QCzV7+G3psOPCYNMnGY6jbxNepCR0DLvhcYDFGeLx9e9oOzFjMfucWt+dzhXEyMTFZnwX2acMH0rMhTbJZkqOTnJPkwiRPbVew/wE4oGUYD0iye7vieGGSryS5/+yZtKty72rD2yU5MV0PgItmrnAleWm7KnBpkpeMqL5nAffpV7cWw6ZJTkhyeZITgZmkDUmuS/LmJBcBj0zy6iTntnjf1054RqaqfggcDLwgnYOSnJzki8DpSTZPcnqSC5JcMlOnFvvfJ7kiydlJjp/J9ib5i1aHi5J8IuuvwO6Q5ItJLm7TvOco6zZbkocl+VK6q9mnJtm+la9N8rYk5wEv7jP+5CRfa9/pvyfZbgSx9V3ObZldnuT96Xq4fKG1p/2BXYHj2jqz6aC2k+RFSb7elvsJreywJMcmOSvJVUmenuQNbd6fT3KH9r4lb49JNgf2BJ5LO/BKslGS9yT5RpLT0l2l27+9dmXaDjPdVaq1bXjebcQYPRb4dVUdNVNQVVdV1TuTrEryxrYcL07yl7M/nGR1kn9py//CJHuPNfr1zgLuMyu2kbXNUUp3dXBtkn9r7eq4nnXiiJ514k2tbNu2vTq3/e2R7mrXXwF/0+ryqBFvx26ke4jY3/Spz23mm24/9xTgjS2+HdNz5SnJNkmubMOzt+0HJflkW9+/leQNPfM6sH3XlyY5coi4/w3YJ603WltudwU2bevoBemuzG/eXr8yyWt72tQDWvmgfeiCYm3r3DGt7JIkf9PKd07yH20Znpjkzgv5chZq0PyS7NbK1rVtw6WtfBLbgZnjl+2TnJn1PSke1WLq3f6+Ksk3c9t9/qA219vDdfOeul2cZL9WvtC2tmhJfn9Ae9wt3T7kotb2tuS2x6SHJflQki8DHxqmbhto0Dp1t37LK8l7k5yXblv82p7yJ6Tb/l0APL2n/C5JPtXi/Y8kD27lt6rnEtSjr35tJgs4F8jcx9V921RmHW+Pqm6z6jnXMfQt6xNw/57yvsfQI7Sg/U4rPybJUUm+Bryhjb+3taXvtPXj6Pb9HNMzvb7tdEWoKv8m8AdcBzyYbqO6GlhHd8XplPb6PwF/0oa3Ar4JbEZ3he1dPdNZA2zchh8PfKIN907rls8AHwVe0oZXAVsCDwMuadPfHLgMeOhS1bP93xg4CXjeHHV7Kd1PxNKWzY3Arm28gGf0TPcuPcMfAp48iu+oT9n/Atu1ZXr1TBytfmva8DbAt4EAu7XvdjWwBfAt4JD2vq17pvs64IVt+NPAs9vwnwGfGlObPAz4W+ArwLat7ICe72Qt8J6e988evzPc8kDdPwfevAQx3dSW3zrgxDmW8w6tvezcXvtYTxtbO9OO5mo7wH8Dd5xplz3L5GzgDsBDgF8CT2yvnQjsO6r2CDwT+GAb/grdero/XUJzI+C3gJ8A+7f3XAls04Z3Bda24b7biEn8AS+i65XT77WDgb9rw3cEzgPu3b7bS1v5y3ra4wOA/wRWjyn222zL+pSPpG2OuD57AT+l67WyEfBVuoTY1sAVrF+nZ9aJjwB7tuF7Apf3rCuH9Ex/ZNsxuv3nmtbmtwQOAQ6ba77AMTPryuxl376vK9vwQdx6234Q8J02n9XAVcA96E5+/hPYtn33X6RtD+aJ/RTgqW34UOADwJnAZq3sFcCr2/CVrN8v/DXwgTY81/HB0LHSbVNO64lt5ju+GHhMG/4H4G1L+N3daps+1/yAS4FHtuEjGPN2gP7HLy8DXtXKVwFb9HxX27D+eOpOdG3026zf5w9qc3ux/njtyN7lTbdfXVRbG2L5rwMO6I2txXWb9ghs0trWbq18TYvlIG59THoYcD6w6TB1W6LvafY6dfSg5cX69XpVq/OD6daV/wLuS7fN/lhPzO8EXtOGHwus61fPpWxvs8oGtZnZy33QuUDf4+q52hSzjrdH8cfwx3ZzrU99j6FHGPNi9zunAKt6xk9odXsq8DPgQXT73vNZf5xwm3Y6uz1M65/dSiaoqi5u2d0Due1PpP4+8JSsv5dqNd1B4GxbAscmuS/dxuQO88z2scCftvnfBPw0yZ50Bwi/AEjySeBRwIULrVMfmyZZ14bPAj5Id5LVr26PBt7RYrs4ycU907kJ+ETP+N5JXk63sboLXTLl00sQ70KcVlU/bsMB/inJo4GbgbvRJTD2AE6qql8Bv0rSG+MDk7yO7sByc+DUVv5I1mfsPwS8gfG5I/BA4LR0F01XAd/vef2js97fO3534KPpelhsAnx3CeK5vrrbTABI10Oh33IG+G5VzbS18+lOCPsZ1HYuprt6/Sm62w1mfK6qfpPkErrl8flWfknPPEbRHg8E3t6GT2jjGwMfr6qbgWuSnDHEdBa6jRibJO+mOwn+Nd1J1IPTeoDQxX1fupOuGXvSHShSVd9IchVwP7rvbtT6bct6DdoGwIa3zVE7p6quBmh13AH4D+BXwAfbFc+Ze64fD+yU9Z051qRdUZ1lpNuxqvpZkn+lS3Zdv8Tz7d22A5xeVT8FSPJ14F50iZu1VXVtKz+Obh/2qdkTm2Wm6/lJ7f+JdEmCL7dlugldcmjGJ9v/83vqNdfxwUJiPRz47STvBD4DfCHdVfCtqupLbXrHAh+fp04LMXub3nd+6Z7XsEVVzSyLjwB/2IbHtR3ot84/Aji67Ys+1bNez3gU3fHUL1v9Tl7gPB9Pz60JVfWTtk1ZTFvr51bLv49H0N3yNLs93h/4flWd2+L6WYul3zROrqrr+5Tfpm6LiL+ffuvUoOX1jCQH0+1Lt6er60Z02+hvtfd/mC5RDl1b26/F+8V0z+VaM089J2HQfn7QcfVuDF5Gs4+3R2HYY7u51qdBx9Ajs8j9zsfb+daMT1dVtWPKH1TVJQBJLqPb966jfzsdx3HOxJmYmLyTgTfRZZW37ikPsF9VXdH75iQPn/X5w4EzquppLcmxdlSBLtJtdoLp9mT96jbXdH41s2InWQ28hy5r+F/pHj6zekmj7iPJb9NtsH/Yin7R8/Iz6TLPD2snsVcOEdMxdBnqi5IcRNcGJi3AZVU1qPveL+YYfyfwlqo6OcledFcUltpcy/mGnvfdRE+XxRnztJ196HbMTwZeleRBvdOtqpuT/KZa2ppu57nxKNpjkrvQJREflKToEiJFd8A1yI2svz2vd/7LaRtxGe0gD6Cqnp+u+/N5dFdvXlhVtzq4yPJ5ON58B/SjbJujNju+javqxiS7A4+j66nzAro2uRHwiJZsvcU82+9ReRtwAfAvi/jsoPUFbrudu83yWcT8ZpwEvDXJLnQJqAvoEiGDniMzM+/e+c51fDB0rO2k9yHAH9DdivMM+nRTXsH6rfNntpOnfYBjkrylqv51yOnN1eaWi9CnPfbsD4cxe/0Ztdnr1Dpgx9lvSnJvuqvcu7W2fwwb9j2Mo57Dtpml3M/fcrw9RrenY+iF7ncG7U9u5tbb65ljyqVup7crPmNi8o4GXjuTMetxKvDCdhJPkoe28p/T3RIwY0vWPzTzoCHmdzpdd8SZ+0u3pLsSsG+SOyXZDHhaKxuVQXU7E/jjVvZAum5n/cysoD9qV+r2H/C+JZNkW7qHQ76r58S015bAD9sGdW+6q1QAXwaenO6e2M1Zf8UHuu/x+y1T/Mye8q+w/qrCMxntdzHbDcC2SR4JXRY7ye8M+dnetvjsUQTH4OU8l951pm/bSfdrK/eoqjPouq5uSZeBH8Yo2uP+wIeq6l5VtUNV3YOuB8qPgf3SPWtiO269I76Srtsj9Jz8s/BtxCh9EVid5Hk9ZTP3hZ4KPC/rn9txv7Y96nUWbV1Jcj+6q8RXsDyMpG1OSothy6r6LN3J6kPaS18AXtjzvpkTt9n7ppFvx1qvho/RPYdlvvnOju9K1q8vi1nW5wCPSXff9yq6Hk1fmuczVNV1wBl0+/7j6Xqm7JHkPnDL8yPuN89kBu1DFxRrSwpuVFWfAP4O2KX1tvhJ2rMTgGcNU6/FGjS/6h4k+fOeizG9Dzic2HYgyb3ornK+n+42nF1mveVMuuOpTZNsQZfonnEl87e504Dn98zvziyyrS3SoPZ4BbB9kt1a+RbpHuY3e72aS7+6bbA+69Sg5bWG7iTxp23/+cQ2iW8AOySZSWb0JmV629pewI9meouMyZX0bzPDngsMOq4eZ5saxqD951zr06Bj6JFa4H5nMQa10xXBxMSEVdXVVdXvp5QOp+uKdXHr3nN4Kz+DrhvtuiQH0HUXen2SCxnuKs6L6boLX0LXNXSnqrqALvN4DvA1uvtYl+I2jkEG1e29wOZJLqe7z/T8fh9uByzvp7v/9FTg3BHFuWlbzpcB/053QD7oITTHAbu25fqndDs6WrfHk+m6YH2Orvv/T9tn/p5ueX955v3NC4HnpOty9yy672xcbqbb+R2Z7sFH6xj+SfuH0XXBPR/40WjC67+c53EMcFS6Lrk30L/trAI+3KZ7IfCOGvIJ6yNqjwdy294Rn6B7rsTVwNeBD9Nl7Wfa02uBt6d7GGnv1Y6FbiNGpiX19qU7IPpuknPoum6/gu4g/+vABekecvfP3Dbe9wAbte/po8BBVXUDy8Oo2uakbAGc0rZDZ9PdqwxdF9Zd0z3k6+us/6WCTwNPa9vMRzG+7dib6e5JnjFovicAf5vu4XA70vVUfF5bLxb8lPWq+j7d/exnABcB51fVSUN+/Hi6RM/xrSv1QcDxLeav0j03YS6D9qELjfVuwNrW/j4MvLJ95Nl0Dwq9mO7p//8wZL0Wa9D8ngu8v8W3Geu3dZPcDuwFXNTazQGsv90OgHY89VG65fw5br0eD9PmXgfcOd0DCS8C9t7AtjbbzHHNzN+tfpVjUHus7le6DgDe2eI6jS6ZOvuYdC63qdsi69BP7zrVd3lV1UV0+/dv0N0a9OVW51/R3brxmXQPv/xhz3QPAx7WlsURjO6iC8Cdklzd8/dSBreZYc8F+h5XL3GbWgqDjqHnWp8GHUOPw7D7nQUb1E5XipmHWkkakSSbV9V16Z4YfCZwcNvYSgvW0562pksm7lFV10w6LklaSjPbujZ8KLB9VY0zUb/B0t2SdV1VvWnSsUjScuczJqTRe1+SneiuLhxrUkIb6JR0D4bbBDjcpISkKbVPklfSHatexeRvRZMkjZA9JiRJkiRJ0sT4jAlJkiRJkjQxJiYkSZIkSdLEmJiQJEmSJEkTY2JCkqQpk2Trnp8EvCbJ99rwdUneM6YY9kpyyojncd0opy9JksbDX+WQJGnKVNX/ADuDP1koSZKWP3tMSJK0QvT2YkhyWJIPJflqkm8l+YtWniRvTHJpkkuSHNDKt09yZut5cWmSR/WZ/hOSfCPJBcDTe8o3S3J0knOSXJjkqQNiOzPJZ5JckeSoJBu11w5ssVya5Mg+n92m1WOfJNsm+USSc9vfHj31PTbJWUmuSvL0JG9o0/18kju09z2uxXhJi/mOrfzKJK9NckF77QGt/DE9vVMuTLLFBn9RkiStMCYmJElauR4MPBZ4JPDqJHelSyjsDDwEeDzwxiTbA38MnFpVM6+t651QktXA+4EnAw8Dfqvn5VcBX6yq3YG92zQ36xPP7sALgZ2AHYGnt5iObHHuDOyWZN+e+W4HfAZ4dVV9Bng78Naq2g3YD/hAz/R3bNN5CvBh4IyqehBwPbBPq8MxwAGtfGPgeT2f/1FV7QK8FziklR0CPL8tl0e1aUmSpAUwMSFJ0sp1UlVdX1U/As6gSwzsCRxfVTdV1Q+ALwG7AecCz2m3hjyoqn4+a1oPAL5bVd+qqqI78Z/x+8ChSdYBa4HVwD37xHNOVX2nqm4Cjm+x7Aasraprq+pG4Djg0e39dwBOB15eVae1sscD72rzOhlYk2Tz9trnquo3wCXAKuDzrfwSYAfg/q0O32zlx/bMC+CT7f/57f0AXwbekuRFwFYtRkmStAAmJiRJWrlqnvH1L1SdSXeS/j3gmCR/uoD5BNivqnZuf/esqss3JJ7mRrokwR/0lG0EPKJnXnerqpmHZN7Q6nIz8JuWQAG4meGeu3VD+3/TzPur6gjgz4FNgS/P3OIhSZKGZ2JCkqSV66lJVifZGtiLrlfEWcABSVYl2ZYuGXFOknsBP6iq99PdHrHLrGl9A9ghyY5t/MCe104FXpgkAEkeOiCe3ZPcuz1b4gDgbOAc4DHtORKr2nS/1N5fwJ8BD0jyilb2BbrbQWjz2nkBy+OKVof7tPFn9cyrryQ7VtUlVXUk3fIzMSFJ0gL5qxySJK1cF9PdwrENcHhV/XeSE+meOXER3Yn/y6vqmiTPBv42yW+A64Bb9Zioql8lORj4TJJf0iU4Zh4EeTjwNuDilnT4LvCHfeI5F3gXcJ8W14lVdXOSQ9t4gM9U1Uk9870pyYHAyUl+DrwIeHeSi+mOc84E/mqYhdHq8Bzg40k2bvEcNc/HXpJkb7peF5cBnxtmXpIkab2s78UoSZJWiuX2M6JJ9gIOqap+CQtJkjTFvJVDkiRJkiRNjD0mJEmSJEnSxNhjQpIkSZIkTYyJCUmSJEmSNDEmJiRJkiRJ0sSYmJAkSZIkSRNjYkKSJEmSJE2MiQlJkiRJkjQx/x8xhuLXHJw8IwAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 1008x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "grHKwtDLe5S7"
      },
      "source": [
        "# Exemplo"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 234
        },
        "id": "R_uwNXEde9uq",
        "outputId": "fb0f426e-ff1d-4e97-ef81-24ed3ad2c87b"
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "df = pd.read_csv('https://raw.githubusercontent.com/leonhgomes/Pandas/main/pokemon_data.csv')\n",
        "\n",
        "df.sample(n=6)[ ['Nome','Ataque']  ]\n",
        "\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome</th>\n",
              "      <th>Ataque</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>630</th>\n",
              "      <td>Garbodor</td>\n",
              "      <td>95</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>776</th>\n",
              "      <td>Goodra</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>447</th>\n",
              "      <td>Kricketune</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91</th>\n",
              "      <td>Doduo</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Spearow</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>Poliwag</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           Nome  Ataque\n",
              "630    Garbodor      95\n",
              "776      Goodra     100\n",
              "447  Kricketune      85\n",
              "91        Doduo      85\n",
              "26      Spearow      60\n",
              "65      Poliwag      50"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    }
  ]
}