EXERCISE_05_Indexes_Sorting_SOLUTION.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "id": "c1b8d622",
      "metadata": {
        "id": "c1b8d622"
      },
      "source": [
        "#  Indexes & Sorting Exercise"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "c1573576",
      "metadata": {
        "id": "c1573576"
      },
      "source": [
        "## Part 1\n",
        "* Import the `pokemon.csv` dataset\n",
        "* Make the Name column the index (do it in place on the original DataFrame!)\n",
        "\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "985cede7",
      "metadata": {
        "id": "985cede7"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "pokemon = pd.read_csv(\"data/pokemon.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "bb9fbc25",
      "metadata": {
        "id": "bb9fbc25"
      },
      "outputs": [],
      "source": [
        "pokemon.set_index(\"Name\", inplace=True)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "0867cce0",
      "metadata": {
        "id": "0867cce0"
      },
      "source": [
        "## Part 2\n",
        "* Sort the pokemon by the Attack column, from highest to lowest\n",
        "* Sort the pokemon by the Num column, from lowest to highest, in place.\n",
        "* Sort the pokemon by the Total column AND the Attack column (in that order!) from highest to lowest\n",
        "* Sort the pokemon by their index, from lowest to highest, in place (From A-Z)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "089fa8d9",
      "metadata": {
        "id": "089fa8d9",
        "outputId": "b622ca24-5e8a-476b-cf91-8f0e7bfd915d"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Dragonite</th>\n",
              "      <td>149</td>\n",
              "      <td>Dragon</td>\n",
              "      <td>Flying</td>\n",
              "      <td>600</td>\n",
              "      <td>91</td>\n",
              "      <td>134</td>\n",
              "      <td>95</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Rhydon</th>\n",
              "      <td>112</td>\n",
              "      <td>Ground</td>\n",
              "      <td>Rock</td>\n",
              "      <td>485</td>\n",
              "      <td>105</td>\n",
              "      <td>130</td>\n",
              "      <td>120</td>\n",
              "      <td>45</td>\n",
              "      <td>45</td>\n",
              "      <td>40</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Flareon</th>\n",
              "      <td>136</td>\n",
              "      <td>Fire</td>\n",
              "      <td>NaN</td>\n",
              "      <td>525</td>\n",
              "      <td>65</td>\n",
              "      <td>130</td>\n",
              "      <td>60</td>\n",
              "      <td>95</td>\n",
              "      <td>110</td>\n",
              "      <td>65</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Machamp</th>\n",
              "      <td>68</td>\n",
              "      <td>Fighting</td>\n",
              "      <td>NaN</td>\n",
              "      <td>505</td>\n",
              "      <td>90</td>\n",
              "      <td>130</td>\n",
              "      <td>80</td>\n",
              "      <td>65</td>\n",
              "      <td>85</td>\n",
              "      <td>55</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Kingler</th>\n",
              "      <td>99</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>475</td>\n",
              "      <td>55</td>\n",
              "      <td>130</td>\n",
              "      <td>115</td>\n",
              "      <td>50</td>\n",
              "      <td>50</td>\n",
              "      <td>75</td>\n",
              "      <td>2</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>Kakuna</th>\n",
              "      <td>14</td>\n",
              "      <td>Bug</td>\n",
              "      <td>Poison</td>\n",
              "      <td>205</td>\n",
              "      <td>45</td>\n",
              "      <td>25</td>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>25</td>\n",
              "      <td>35</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Abra</th>\n",
              "      <td>63</td>\n",
              "      <td>Psychic</td>\n",
              "      <td>NaN</td>\n",
              "      <td>310</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>Metapod</th>\n",
              "      <td>11</td>\n",
              "      <td>Bug</td>\n",
              "      <td>NaN</td>\n",
              "      <td>205</td>\n",
              "      <td>50</td>\n",
              "      <td>20</td>\n",
              "      <td>55</td>\n",
              "      <td>25</td>\n",
              "      <td>25</td>\n",
              "      <td>30</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Magikarp</th>\n",
              "      <td>129</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>200</td>\n",
              "      <td>20</td>\n",
              "      <td>10</td>\n",
              "      <td>55</td>\n",
              "      <td>15</td>\n",
              "      <td>20</td>\n",
              "      <td>80</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Chansey</th>\n",
              "      <td>113</td>\n",
              "      <td>Normal</td>\n",
              "      <td>NaN</td>\n",
              "      <td>450</td>\n",
              "      <td>250</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>35</td>\n",
              "      <td>105</td>\n",
              "      <td>50</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>151 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           Num    Type 1  Type 2  Total   HP  Attack  Defense  Sp. Atk  \\\n",
              "Name                                                                     \n",
              "Dragonite  149    Dragon  Flying    600   91     134       95      100   \n",
              "Rhydon     112    Ground    Rock    485  105     130      120       45   \n",
              "Flareon    136      Fire     NaN    525   65     130       60       95   \n",
              "Machamp     68  Fighting     NaN    505   90     130       80       65   \n",
              "Kingler     99     Water     NaN    475   55     130      115       50   \n",
              "...        ...       ...     ...    ...  ...     ...      ...      ...   \n",
              "Kakuna      14       Bug  Poison    205   45      25       50       25   \n",
              "Abra        63   Psychic     NaN    310   25      20       15      105   \n",
              "Metapod     11       Bug     NaN    205   50      20       55       25   \n",
              "Magikarp   129     Water     NaN    200   20      10       55       15   \n",
              "Chansey    113    Normal     NaN    450  250       5        5       35   \n",
              "\n",
              "           Sp. Def  Speed  Stage  Legendary  \n",
              "Name                                         \n",
              "Dragonite      100     80      3      False  \n",
              "Rhydon          45     40      2      False  \n",
              "Flareon        110     65      2      False  \n",
              "Machamp         85     55      3      False  \n",
              "Kingler         50     75      2      False  \n",
              "...            ...    ...    ...        ...  \n",
              "Kakuna          25     35      2      False  \n",
              "Abra            55     90      1      False  \n",
              "Metapod         25     30      2      False  \n",
              "Magikarp        20     80      1      False  \n",
              "Chansey        105     50      1      False  \n",
              "\n",
              "[151 rows x 12 columns]"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.sort_values(\"Attack\", ascending=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "d3710b71",
      "metadata": {
        "id": "d3710b71"
      },
      "outputs": [],
      "source": [
        "pokemon.sort_values(\"Num\", inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "5c4251fd",
      "metadata": {
        "id": "5c4251fd",
        "outputId": "55ce9eb6-454b-41a2-b9d6-e903a93ca690"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Mewtwo</th>\n",
              "      <td>150</td>\n",
              "      <td>Psychic</td>\n",
              "      <td>NaN</td>\n",
              "      <td>680</td>\n",
              "      <td>106</td>\n",
              "      <td>110</td>\n",
              "      <td>90</td>\n",
              "      <td>154</td>\n",
              "      <td>90</td>\n",
              "      <td>130</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Dragonite</th>\n",
              "      <td>149</td>\n",
              "      <td>Dragon</td>\n",
              "      <td>Flying</td>\n",
              "      <td>600</td>\n",
              "      <td>91</td>\n",
              "      <td>134</td>\n",
              "      <td>95</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>80</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Mew</th>\n",
              "      <td>151</td>\n",
              "      <td>Psychic</td>\n",
              "      <td>NaN</td>\n",
              "      <td>600</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Moltres</th>\n",
              "      <td>146</td>\n",
              "      <td>Fire</td>\n",
              "      <td>Flying</td>\n",
              "      <td>580</td>\n",
              "      <td>90</td>\n",
              "      <td>100</td>\n",
              "      <td>90</td>\n",
              "      <td>125</td>\n",
              "      <td>85</td>\n",
              "      <td>90</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Zapdos</th>\n",
              "      <td>145</td>\n",
              "      <td>Electric</td>\n",
              "      <td>Flying</td>\n",
              "      <td>580</td>\n",
              "      <td>90</td>\n",
              "      <td>90</td>\n",
              "      <td>85</td>\n",
              "      <td>125</td>\n",
              "      <td>90</td>\n",
              "      <td>100</td>\n",
              "      <td>1</td>\n",
              "      <td>True</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>Kakuna</th>\n",
              "      <td>14</td>\n",
              "      <td>Bug</td>\n",
              "      <td>Poison</td>\n",
              "      <td>205</td>\n",
              "      <td>45</td>\n",
              "      <td>25</td>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>25</td>\n",
              "      <td>35</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Metapod</th>\n",
              "      <td>11</td>\n",
              "      <td>Bug</td>\n",
              "      <td>NaN</td>\n",
              "      <td>205</td>\n",
              "      <td>50</td>\n",
              "      <td>20</td>\n",
              "      <td>55</td>\n",
              "      <td>25</td>\n",
              "      <td>25</td>\n",
              "      <td>30</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Magikarp</th>\n",
              "      <td>129</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>200</td>\n",
              "      <td>20</td>\n",
              "      <td>10</td>\n",
              "      <td>55</td>\n",
              "      <td>15</td>\n",
              "      <td>20</td>\n",
              "      <td>80</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Weedle</th>\n",
              "      <td>13</td>\n",
              "      <td>Bug</td>\n",
              "      <td>Poison</td>\n",
              "      <td>195</td>\n",
              "      <td>40</td>\n",
              "      <td>35</td>\n",
              "      <td>30</td>\n",
              "      <td>20</td>\n",
              "      <td>20</td>\n",
              "      <td>50</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Caterpie</th>\n",
              "      <td>10</td>\n",
              "      <td>Bug</td>\n",
              "      <td>NaN</td>\n",
              "      <td>195</td>\n",
              "      <td>45</td>\n",
              "      <td>30</td>\n",
              "      <td>35</td>\n",
              "      <td>20</td>\n",
              "      <td>20</td>\n",
              "      <td>45</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>151 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           Num    Type 1  Type 2  Total   HP  Attack  Defense  Sp. Atk  \\\n",
              "Name                                                                     \n",
              "Mewtwo     150   Psychic     NaN    680  106     110       90      154   \n",
              "Dragonite  149    Dragon  Flying    600   91     134       95      100   \n",
              "Mew        151   Psychic     NaN    600  100     100      100      100   \n",
              "Moltres    146      Fire  Flying    580   90     100       90      125   \n",
              "Zapdos     145  Electric  Flying    580   90      90       85      125   \n",
              "...        ...       ...     ...    ...  ...     ...      ...      ...   \n",
              "Kakuna      14       Bug  Poison    205   45      25       50       25   \n",
              "Metapod     11       Bug     NaN    205   50      20       55       25   \n",
              "Magikarp   129     Water     NaN    200   20      10       55       15   \n",
              "Weedle      13       Bug  Poison    195   40      35       30       20   \n",
              "Caterpie    10       Bug     NaN    195   45      30       35       20   \n",
              "\n",
              "           Sp. Def  Speed  Stage  Legendary  \n",
              "Name                                         \n",
              "Mewtwo          90    130      1       True  \n",
              "Dragonite      100     80      3      False  \n",
              "Mew            100    100      1      False  \n",
              "Moltres         85     90      1       True  \n",
              "Zapdos          90    100      1       True  \n",
              "...            ...    ...    ...        ...  \n",
              "Kakuna          25     35      2      False  \n",
              "Metapod         25     30      2      False  \n",
              "Magikarp        20     80      1      False  \n",
              "Weedle          20     50      1      False  \n",
              "Caterpie        20     45      1      False  \n",
              "\n",
              "[151 rows x 12 columns]"
            ]
          },
          "execution_count": 15,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.sort_values([\"Total\", \"Attack\"], ascending=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "11f97c85",
      "metadata": {
        "id": "11f97c85"
      },
      "outputs": [],
      "source": [
        "pokemon.sort_index(inplace=True)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "5957fd4b",
      "metadata": {
        "id": "5957fd4b"
      },
      "source": [
        "## Part 3\n",
        "\n",
        "* Find the average Speed of the 10 pokemon with the highest Speed.\n",
        "* Of the top 20 pokemon with the highest Attack values, what is the most common value for \"Type 1\"? "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "1363ee6a",
      "metadata": {
        "id": "1363ee6a",
        "outputId": "2def5ae1-2776-426e-9dbe-cb42f5c20783"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "122.0"
            ]
          },
          "execution_count": 22,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon[\"Speed\"].nlargest(10).mean()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "c66fd4ce",
      "metadata": {
        "id": "c66fd4ce",
        "outputId": "50cce9a8-6982-482c-f7e0-44060e15245e"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "122.0"
            ]
          },
          "execution_count": 26,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.sort_values(\"Speed\", ascending=False)[\"Speed\"].head(10).mean()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "23861edc",
      "metadata": {
        "id": "23861edc",
        "outputId": "18289105-278c-4813-93b8-3908c729be78"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "0    Fighting\n",
              "dtype: object"
            ]
          },
          "execution_count": 32,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.sort_values(\"Attack\").tail(20)[\"Type 1\"].mode()"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "3c1514d2",
      "metadata": {
        "id": "3c1514d2"
      },
      "source": [
        "## Part 4\n",
        "* Retrieve the row with the index label of \"Diglett\"\n",
        "* Retrieve the rows for the two fox-like Pokemon: Eevee and Vulpix\n",
        "* Make sure your DataFrame is sorted by index (A-Z).  Retrieve the rows from Charizard to Charmeleon.  You should get three rows back.\n",
        "* Retrieve the 30th, 40th, and 50th rows by position."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "680a34ae",
      "metadata": {
        "id": "680a34ae",
        "outputId": "e95433b4-c5d7-4128-d3b8-05349d91ceb5"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "Num              50\n",
              "Type 1       Ground\n",
              "Type 2          NaN\n",
              "Total           265\n",
              "HP               10\n",
              "Attack           55\n",
              "Defense          25\n",
              "Sp. Atk          35\n",
              "Sp. Def          45\n",
              "Speed            95\n",
              "Stage             1\n",
              "Legendary     False\n",
              "Name: Diglett, dtype: object"
            ]
          },
          "execution_count": 33,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.loc[\"Diglett\"]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "f497df23",
      "metadata": {
        "id": "f497df23",
        "outputId": "f49b5544-222e-44ae-ba5f-50be7b207afb"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Eevee</th>\n",
              "      <td>133</td>\n",
              "      <td>Normal</td>\n",
              "      <td>NaN</td>\n",
              "      <td>325</td>\n",
              "      <td>55</td>\n",
              "      <td>55</td>\n",
              "      <td>50</td>\n",
              "      <td>45</td>\n",
              "      <td>65</td>\n",
              "      <td>55</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Vulpix</th>\n",
              "      <td>37</td>\n",
              "      <td>Fire</td>\n",
              "      <td>NaN</td>\n",
              "      <td>299</td>\n",
              "      <td>38</td>\n",
              "      <td>41</td>\n",
              "      <td>40</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "      <td>65</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Num  Type 1 Type 2  Total  HP  Attack  Defense  Sp. Atk  Sp. Def  \\\n",
              "Name                                                                       \n",
              "Eevee   133  Normal    NaN    325  55      55       50       45       65   \n",
              "Vulpix   37    Fire    NaN    299  38      41       40       50       65   \n",
              "\n",
              "        Speed  Stage  Legendary  \n",
              "Name                             \n",
              "Eevee      55      1      False  \n",
              "Vulpix     65      1      False  "
            ]
          },
          "execution_count": 34,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.loc[[\"Eevee\",\"Vulpix\"]]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "38ef8c39",
      "metadata": {
        "id": "38ef8c39",
        "outputId": "39e89126-a6a1-44ab-8a50-76d5345909a5"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Charizard</th>\n",
              "      <td>6</td>\n",
              "      <td>Fire</td>\n",
              "      <td>Flying</td>\n",
              "      <td>534</td>\n",
              "      <td>78</td>\n",
              "      <td>84</td>\n",
              "      <td>78</td>\n",
              "      <td>109</td>\n",
              "      <td>85</td>\n",
              "      <td>100</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Charmander</th>\n",
              "      <td>4</td>\n",
              "      <td>Fire</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>Charmeleon</th>\n",
              "      <td>5</td>\n",
              "      <td>Fire</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>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            Num Type 1  Type 2  Total  HP  Attack  Defense  Sp. Atk  Sp. Def  \\\n",
              "Name                                                                           \n",
              "Charizard     6   Fire  Flying    534  78      84       78      109       85   \n",
              "Charmander    4   Fire     NaN    309  39      52       43       60       50   \n",
              "Charmeleon    5   Fire     NaN    405  58      64       58       80       65   \n",
              "\n",
              "            Speed  Stage  Legendary  \n",
              "Name                                 \n",
              "Charizard     100      3      False  \n",
              "Charmander     65      1      False  \n",
              "Charmeleon     80      2      False  "
            ]
          },
          "execution_count": 37,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.loc[\"Charizard\":\"Charmeleon\"]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "f71ff92e",
      "metadata": {
        "id": "f71ff92e",
        "outputId": "cbc59e0a-f6d0-481f-ce90-cb8e279c51ce"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Eevee</th>\n",
              "      <td>133</td>\n",
              "      <td>Normal</td>\n",
              "      <td>NaN</td>\n",
              "      <td>325</td>\n",
              "      <td>55</td>\n",
              "      <td>55</td>\n",
              "      <td>50</td>\n",
              "      <td>45</td>\n",
              "      <td>65</td>\n",
              "      <td>55</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gengar</th>\n",
              "      <td>94</td>\n",
              "      <td>Ghost</td>\n",
              "      <td>Poison</td>\n",
              "      <td>500</td>\n",
              "      <td>60</td>\n",
              "      <td>65</td>\n",
              "      <td>60</td>\n",
              "      <td>130</td>\n",
              "      <td>75</td>\n",
              "      <td>110</td>\n",
              "      <td>3</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gyarados</th>\n",
              "      <td>130</td>\n",
              "      <td>Water</td>\n",
              "      <td>Flying</td>\n",
              "      <td>540</td>\n",
              "      <td>95</td>\n",
              "      <td>125</td>\n",
              "      <td>79</td>\n",
              "      <td>60</td>\n",
              "      <td>100</td>\n",
              "      <td>81</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          Num  Type 1  Type 2  Total  HP  Attack  Defense  Sp. Atk  Sp. Def  \\\n",
              "Name                                                                          \n",
              "Eevee     133  Normal     NaN    325  55      55       50       45       65   \n",
              "Gengar     94   Ghost  Poison    500  60      65       60      130       75   \n",
              "Gyarados  130   Water  Flying    540  95     125       79       60      100   \n",
              "\n",
              "          Speed  Stage  Legendary  \n",
              "Name                               \n",
              "Eevee        55      1      False  \n",
              "Gengar      110      3      False  \n",
              "Gyarados     81      2      False  "
            ]
          },
          "execution_count": 41,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.iloc[[30,40, 50]]"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "3075abbd",
      "metadata": {
        "id": "3075abbd"
      },
      "source": [
        "## Part 5\n",
        "* Retrieve the rows of the fish-like Pokemon.  Use this list to make it easier:\n",
        "```py\n",
        "fish_pokemon = [\"Magikarp\", \"Goldeen\",\"Horsea\", \"Seaking\", \"Seadra\",\"Gyarados\"]\n",
        "```"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "4b0780ce",
      "metadata": {
        "id": "4b0780ce"
      },
      "outputs": [],
      "source": [
        "fish_pokemon = [\"Magikarp\", \"Goldeen\",\"Horsea\", \"Seaking\", \"Seadra\",\"Gyarados\"]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "e8db233c",
      "metadata": {
        "id": "e8db233c",
        "outputId": "89bf45c3-3b0d-457d-e256-3a0b203e72f1"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Num</th>\n",
              "      <th>Type 1</th>\n",
              "      <th>Type 2</th>\n",
              "      <th>Total</th>\n",
              "      <th>HP</th>\n",
              "      <th>Attack</th>\n",
              "      <th>Defense</th>\n",
              "      <th>Sp. Atk</th>\n",
              "      <th>Sp. Def</th>\n",
              "      <th>Speed</th>\n",
              "      <th>Stage</th>\n",
              "      <th>Legendary</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Name</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",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Magikarp</th>\n",
              "      <td>129</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>200</td>\n",
              "      <td>20</td>\n",
              "      <td>10</td>\n",
              "      <td>55</td>\n",
              "      <td>15</td>\n",
              "      <td>20</td>\n",
              "      <td>80</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Goldeen</th>\n",
              "      <td>118</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>320</td>\n",
              "      <td>45</td>\n",
              "      <td>67</td>\n",
              "      <td>60</td>\n",
              "      <td>35</td>\n",
              "      <td>50</td>\n",
              "      <td>63</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Horsea</th>\n",
              "      <td>116</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>295</td>\n",
              "      <td>30</td>\n",
              "      <td>40</td>\n",
              "      <td>70</td>\n",
              "      <td>70</td>\n",
              "      <td>25</td>\n",
              "      <td>60</td>\n",
              "      <td>1</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Seaking</th>\n",
              "      <td>119</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>450</td>\n",
              "      <td>80</td>\n",
              "      <td>92</td>\n",
              "      <td>65</td>\n",
              "      <td>65</td>\n",
              "      <td>80</td>\n",
              "      <td>68</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Seadra</th>\n",
              "      <td>117</td>\n",
              "      <td>Water</td>\n",
              "      <td>NaN</td>\n",
              "      <td>440</td>\n",
              "      <td>55</td>\n",
              "      <td>65</td>\n",
              "      <td>95</td>\n",
              "      <td>95</td>\n",
              "      <td>45</td>\n",
              "      <td>85</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gyarados</th>\n",
              "      <td>130</td>\n",
              "      <td>Water</td>\n",
              "      <td>Flying</td>\n",
              "      <td>540</td>\n",
              "      <td>95</td>\n",
              "      <td>125</td>\n",
              "      <td>79</td>\n",
              "      <td>60</td>\n",
              "      <td>100</td>\n",
              "      <td>81</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          Num Type 1  Type 2  Total  HP  Attack  Defense  Sp. Atk  Sp. Def  \\\n",
              "Name                                                                         \n",
              "Magikarp  129  Water     NaN    200  20      10       55       15       20   \n",
              "Goldeen   118  Water     NaN    320  45      67       60       35       50   \n",
              "Horsea    116  Water     NaN    295  30      40       70       70       25   \n",
              "Seaking   119  Water     NaN    450  80      92       65       65       80   \n",
              "Seadra    117  Water     NaN    440  55      65       95       95       45   \n",
              "Gyarados  130  Water  Flying    540  95     125       79       60      100   \n",
              "\n",
              "          Speed  Stage  Legendary  \n",
              "Name                               \n",
              "Magikarp     80      1      False  \n",
              "Goldeen      63      1      False  \n",
              "Horsea       60      1      False  \n",
              "Seaking      68      2      False  \n",
              "Seadra       85      2      False  \n",
              "Gyarados     81      2      False  "
            ]
          },
          "execution_count": 43,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pokemon.loc[fish_pokemon]"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "8b19513e",
      "metadata": {
        "id": "8b19513e"
      },
      "source": [
        "## Part 6\n",
        "\n",
        "* Create this bar chart that shows the Attack values for the above fish-like Pokemon.  Pay attention to the sorting!!\n",
        "<div>\n",
        "<img src=\"attachment:fish_plot.png\" width=\"400\"/>\n",
        "</div>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "57bdcac3",
      "metadata": {
        "id": "57bdcac3",
        "outputId": "5b9cedf5-e6a2-43b9-f561-9b2947393427"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "<AxesSubplot:xlabel='Name'>"
            ]
          },
          "execution_count": 47,
          "metadata": {},
          "output_type": "execute_result"
        },
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEsCAYAAAA4ifPKAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAaVklEQVR4nO3de5xddX3u8c9jgiigCGbgBAIGaEQBUSQooOUWUTwIoYrHcICmQhu1qKitEo5t8XI40gu2goDGQowXoFxEYjkCMShIK2DCHQLCkQgRhAAqVBAIPOePtTbsjJPb7L1nzfz283698tp7rbX37O9ihmfW/NbvIttERERZXtR0ARER0X0J94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAo1vugCACRMmePLkyU2XERExpixevPhh2wNDHRsV4T558mQWLVrUdBkREWOKpF+s6liaZSIiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAKNikFMERGjyeTZl4zo5y096cCuf81cuUdEFCjhHhFRoIR7RESBEu4REQVaY7hLOkvSQ5Jubdv3j5LukHSzpIskvaLt2PGS7pZ0p6R39KjuiIhYjbW5cv86cMCgfQuAnWzvDPwMOB5A0g7ADGDH+j2nSxrXtWojImKtrDHcbV8FPDpo3+W2V9Sb1wCT6ufTgXNtP2X7HuBu4E1drDciItZCN9rcjwK+Xz/fEriv7diyet8fkDRL0iJJi5YvX96FMiIioqWjcJf0aWAF8O3WriFe5qHea3uO7am2pw4MDLlKVEREDNOwR6hKmgm8C5hmuxXgy4Ct2l42Cbh/+OVFRMRwDOvKXdIBwHHAwbafaDs0H5ghaX1J2wBTgOs6LzMiItbFGq/cJZ0D7ANMkLQMOIGqd8z6wAJJANfY/qDt2ySdB9xO1VxzjO1ne1V8REQMbY3hbvuwIXafuZrXnwic2ElRERHRmYxQjYgoUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCrTGcJd0lqSHJN3atm9TSQsk3VU/btJ27HhJd0u6U9I7elV4RESs2tpcuX8dOGDQvtnAQttTgIX1NpJ2AGYAO9bvOV3SuK5VGxERa2WN4W77KuDRQbunA/Pq5/OAQ9r2n2v7Kdv3AHcDb+pOqRERsbaG2+a+ue0HAOrHzer9WwL3tb1uWb0vIiJGULdvqGqIfR7yhdIsSYskLVq+fHmXy4iI6G/DDfcHJU0EqB8fqvcvA7Zqe90k4P6hvoDtOban2p46MDAwzDIiImIoww33+cDM+vlM4OK2/TMkrS9pG2AKcF1nJUZExLoav6YXSDoH2AeYIGkZcAJwEnCepKOBe4H3Ati+TdJ5wO3ACuAY28/2qPaIiFiFNYa77cNWcWjaKl5/InBiJ0VFRERnMkI1IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4go0BoHMUVEDDZ59iUj+nlLTzpwRD+vBLlyj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAJ1FO6SPi7pNkm3SjpH0kskbSppgaS76sdNulVsRESsnWGHu6QtgY8CU23vBIwDZgCzgYW2pwAL6+2IiBhBnTbLjAdeKmk8sAFwPzAdmFcfnwcc0uFnRETEOhp2uNv+JfBPwL3AA8BvbV8ObG77gfo1DwCbdaPQiIhYe500y2xCdZW+DbAFsKGkI9bh/bMkLZK0aPny5cMtIyIihtBJs8zbgHtsL7f9DPAdYE/gQUkTAerHh4Z6s+05tqfanjowMNBBGRERMVgn4X4vsLukDSQJmAYsAeYDM+vXzAQu7qzEiIhYV+OH+0bb10q6ALgeWAHcAMwBNgLOk3Q01S+A93aj0IiIWHvDDncA2ycAJwza/RTVVXxERDQkI1QjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCdbRYR0Ss2uTZl4zo5y096cAR/bwY3XLlHhFRoIR7RESB0iwTjUmzRUTv5Mo9IqJACfeIiAIl3CMiCpRwj4goUEfhLukVki6QdIekJZL2kLSppAWS7qofN+lWsRERsXY6vXL/EnCp7dcArweWALOBhbanAAvr7YiIGEHDDndJLwf2As4EsP207d8A04F59cvmAYd0VmJERKyrTq7ctwWWA3Ml3SDpXyVtCGxu+wGA+nGzLtQZERHroJNwHw+8ETjD9i7A71iHJhhJsyQtkrRo+fLlHZQRERGDdRLuy4Bltq+tty+gCvsHJU0EqB8fGurNtufYnmp76sDAQAdlRETEYMMOd9u/Au6TtH29axpwOzAfmFnvmwlc3FGFERGxzjqdW+YjwLclvRj4OfB+ql8Y50k6GrgXeG+HnxEREeuoo3C3fSMwdYhD0zr5uhER0ZmMUI2IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgrUcbhLGifpBkn/Xm9vKmmBpLvqx006LzMiItZFN67cjwWWtG3PBhbangIsrLcjImIEdRTukiYBBwL/2rZ7OjCvfj4POKSTz4iIiHXX6ZX7vwCfAp5r27e57QcA6sfNOvyMiIhYR+OH+0ZJ7wIesr1Y0j7DeP8sYBbA1ltvPdwyijZ59iUj+nlLTzpwRD8vInqnkyv3twAHS1oKnAvsJ+lbwIOSJgLUjw8N9Wbbc2xPtT11YGCggzIiImKwYYe77eNtT7I9GZgBXGH7CGA+MLN+2Uzg4o6rjIiIddKLfu4nAftLugvYv96OiIgRNOw293a2fwT8qH7+CDCtG183IiKGJyNUIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKlHCPiChQwj0iokAJ94iIAiXcIyIKNOxwl7SVpB9KWiLpNknH1vs3lbRA0l314ybdKzciItZGJ1fuK4C/sv1aYHfgGEk7ALOBhbanAAvr7YiIGEHDDnfbD9i+vn7+OLAE2BKYDsyrXzYPOKTDGiMiYh11pc1d0mRgF+BaYHPbD0D1CwDYbBXvmSVpkaRFy5cv70YZERFR6zjcJW0EXAh8zPZja/s+23NsT7U9dWBgoNMyIiKiTUfhLmk9qmD/tu3v1LsflDSxPj4ReKizEiMiYl110ltGwJnAEttfbDs0H5hZP58JXDz88iIiYjjGd/DetwBHArdIurHe97+Ak4DzJB0N3Au8t6MKIyJinQ073G1fDWgVh6cN9+tGRETnMkI1IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCpRwj4goUMI9IqJACfeIiAIl3CMiCtTJxGGNmzz7khH9vKUnHTiinxcRMVy5co+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgqUcI+IKFDCPSKiQAn3iIgCJdwjIgrUs3CXdICkOyXdLWl2rz4nIiL+UE/CXdI44DTgncAOwGGSdujFZ0VExB/q1ZX7m4C7bf/c9tPAucD0Hn1WREQMItvd/6LSocABtv+83j4SeLPtD7e9ZhYwq97cHriz64Ws2gTg4RH8vJGW8xvbSj6/ks8NRv78XmV7YKgDvVqsQ0PsW+m3iO05wJweff5qSVpke2oTnz0Scn5jW8nnV/K5weg6v141yywDtmrbngTc36PPioiIQXoV7j8FpkjaRtKLgRnA/B59VkREDNKTZhnbKyR9GLgMGAecZfu2XnzWMDXSHDSCcn5jW8nnV/K5wSg6v57cUI2IiGZlhGpERIES7hERBUq4R0QUKOEeEdElkl4k6eVN1wF9dkNV0ruBt1INqLra9kUNl9RVkjYBpgAvae2zfVVzFXVP4ef2auCTwKto68Fme7/Gioq1Juls4IPAs8BiYGPgi7b/sdG6+iXcJZ0O/BFwTr3rfcD/s31Mc1V1j6Q/B46lGjB2I7A78JMSAqLkcwOQdBPwFapgeLa13/bixorqIkmPM2iEOvBbYBHwV7Z/PvJVdY+kG22/QdLhwK7AccBi2zs3WVevph8YjfYGdnL920zSPOCWZkvqqmOB3YBrbO8r6TXAZxuuqVtKPjeAFbbPaLqIHvoi1Qj1s6mmJpkB/Deq+aTOAvZprLLuWE/SesAhwJdtPyOp8avmfmpzvxPYum17K+Dmhmrphd/b/j2ApPVt30E1IVsJSj43gO9J+ktJEyVt2vrXdFFddIDtr9p+3PZj9bxS/932vwGbNF1cF3wVWApsCFwl6VXAY41WRH9dub8SWCLpunp7N+AnkuYD2D64scq6Y5mkVwDfBRZI+jXlzOdT8rkBzKwfP9m2z8C2DdTSC89J+h/ABfX2oW3HGr/C7ZTtU4BT2nb9QtK+TdXT0k9t7nuv7rjtK0eqll6rz3Vj4NJ6Pv1ilHxupZK0LfAlYA+qML8G+DjwS2BX21c3WF7HJG0MnADsVe+6Evic7d82V1WfhHu9MtRltt/WdC29JOmtwBTbcyUNABvZvqfpujoh6UXAzbZ3arqWXpG0AfAJYGvbsyRNAba3/e8NlxZrQdKFwK3AvHrXkcDrbb+7uar6pFnG9rOSnpC0cdO/TXtF0gnAVKq26LnAesC3gLc0WVenbD8n6SZJW9u+t+l6emQuVU+ZPevtZcD5QBHhXl9o/AUwmZW7eh7VVE1dtp3t97Rtf1bSjU0V09IX4V77PXCLpAXA71o7bX+0uZK66k+AXYDrAWzfL+llzZbUNROB2+r7Je3fu7F+n6RlO9vvk3QYgO0nJQ214M1YdTHwY+AHtHX1LMiTkt7aal6S9BbgyYZr6qtwv6T+V6qnbbvVBUvShk0X1EUldXscytOSXkp9c1HSdsBTzZbUVRvYPq7pInroQ8C8uu1dwKPAnzVaEX3S5t4PJP011QjO/YEvAEcBZ9s+tdHCYo0k7Q/8DbADcDlVU9qf2f5Rk3V1i6T/Dfyn7f/bdC291Jp2wHbj3SChj8K9vkn1Bar/gdqHsJfS3awVEm+nunq4zPaChkvqyCpGNj7P9qiYw6MbJL2SauStqAZrFbOIdP193JDqr5FnqM7RY/37J+kTqztu+4sjVctQ+qlZZi5Vd6V/BvYF3s/QC3mPSXUzzBW2F0jaHthe0nq2n2m6tuGy/TIASZ8DfgV8k+p7djhQyv0E6vb1dwLb2v6cpK0lvcn2dWt671jQ+j4WqHVe21ONm2ktJXoQ0Pi8R/105b7Y9q6SbrH9unrfj23/cdO1dYOkxcAfU434u4Zq3o4nbB/eaGFdIOla229e076xStIZwHPAfrZfW0+Sdrnt3RourSOSXmP7DklvHOq47etHuqZekHQ58B7bj9fbLwPOt31Ak3X105X77+s+03fV67v+Etis4Zq6SbafkHQ0cKrtf5B0Q9NFdcmz9aRM51I10xxGWb0u3mz7ja3vl+1f1wvLj3WfAGYBJw9xzEARE79RTWvSPqDuaapun43qp3D/GLAB8FHg81Q/WH/aZEFdJkl7UDVZHF3vK+X7+z+pRjh+iSoU/qPeV4pn6oF2rd4yA1RX8mOa7Vn10/08qIlA0kuGeMtY9U3gOkkXUX0P/wT4RrMllfM//9p4zvZ/Af9F1d6OpIOaLamrjgWOBy6yfVs95PuHDdfUFbaXAtObrqOHTgEuAjaTdCLV3Ct/02xJXXUmVe8t4Pn7Q/OBaY1V1EW2T5R0KdVaEQDvt934X8391OZ+PTDT9i319gzg4yW029ZXfSfZ/uQaXzwG1Vd5RwM7snJPp1JGOFJPYzyN6obxQttLGi6payR9Hphg+0P1/YRLgK/ZnttwaV0laTNW/vlsdER1P4X7tlSz0h1O9Rv2T4F3lTIdgaQrSlm8YjBJ5wN3UDXFfI7qe7jE9rGNFtahNU3ra/vRkaql1yT9PdWEb7tSXYhc2HBJXSPpYKr7ClsAD1G1wd9he8dG6+qXcIfnlzP7LnAfcIjtxocId4ukk6kGMZ3PykP0v9NYUV0i6Qbbu0i62fbO9cIIl431X2aS7qFqoxVVIPy6fv4K4F7b2zRXXedULWv5/Cbwt8B1wKVQxs8mPL+S1n7AD+qf032Bw9ruOTSi+DZ3Sbew8kCYTYFxwLWSaHoprC7aFHiElXsgGCjhf6BWX/3fSNqJqs/75ObK6Y5WeEv6CjC/NYJT0juBEmYwHXxP6waqCe0OopyfTYBnbD+ianHsF9n+Yf2XSqOKv3KvV0VZJdu/GKlaYnhUraF6IbAz1WC0jYC/s/2VRgvrktYYjEH7Ftme2lRNsfYk/YBqib0vABOommZ2s73n6t7X87r6INxfbvuxVbVvltKuKWkScCrVvCQGrgaOtb2s0cJijSRdRjVr4reovndHAHvZfkejhXVJ6TfE694/T1ItW3o41b2Fb9t+pMm6+mEN1bPrx8VUozYXt/1b1FRRPTCXqnvZFsCWwPfqfWOepM0lnSnp+/X2DvVgrVIcBgxQdYf8LtXgusOaLKjLvkm1IPY7qFYpmgQ83mhFXVL3VLvY9nO2V9ieZ/uUpoMd+uDKvV9IutH2G9a0byyqQ30u8Gnbr5c0HrihNY1EjG6l3hBvUbUO85Gjredd8TdUW1Yxv8VvgV/YXjHS9fTAw5KOAM6ptw+jusFaggm2z5N0PIDtFZLG/PQDkr7H6me9LGUxkiJviLcZlQsB9U24A6cDbwRupuqW9TrgJuCVkj5o+/Imi+uCo4AvU816aeA/aRsVOMb9rp4StzU8f3eqX8xj3T81XcAImVMPXvpbqqbDjYC/a7akrhqVCwH1TbOMpHOBz9u+rd7eAfgk1Twz3ymh+aJU9V9dpwI7US1EPAAcavvmRgvronqisFfXm3eO5amaY3Topyv317SCHcD27ZJ2sf1zjeHlKiWdyur/tB+za8RK2g24z/b1kvYGPgC8h2q1omJ6AUnaB5gHLKX6q3IrSTNtNz4neDdI2hz4P8AWtt9ZX1jtYfvMhkvritG6EFA/9JZpuVPSGZL2rv+dDvxM0vq80CY4FrX3ADqYlXsDLW6wrm74Ki9Mpbon8GngNKqRnHOaKqoHTgbebntv23tR9Sr554Zr6qavA5dR9eQC+BnVLK2lmAucAaygWgjoG1Q9hBrVT80yLwX+kmpeGVH1Az+d6mbIBvWMkWNaq1dC03V0i6SbbL++fn4asNz2Z+rtInoCAbR6kaxp31gl6ae2d2v/+Szs+zcqFwLqm2aZeh6Zkxl64YAxH+y10n5Tj5M0vu7NNI1q4YeWkn52F0k6kxeu9o5g7P/V1a7UG+Ito3IhoJL+B1mt0douFqt1DnClpIepRgD+GEDSH1FWOHwIOAb4CNVflVdR/VVZik9Q9ZLZTtJ/UN8Qb7akrvoYKy8EtC8ws8mCoL+aZa7mhQWyD6JeINv2CY0W1iFVK8u3vokbAE+0DlHGCvO7AxOp1hT9Xb3v1cBGY30NTknTgUm2T6u3r6MKPgOfsn1Bk/V1qu2G+K/qgWetG+K3U80NVMrUHzvZvrXpOgbrp3Afle1i0b/qq9gZtu+rt2+kmtVzI2Cu7TG9UlG9QM7bbD8qaS+qNXA/ArwBeK3tIq7e6wvHF1PdOD7b9m8aLajWN80yjNJ2sehrL24Fe+3q+mr20XoyqrFuXNvV+fuAOfUiHRfWv8iKYPutdbPvUVT3T34KnGV7QZN19VNXyI/xQrvYrsCRjIJ2sehrm7Rv2P5w2+bACNfSC+Pq5hiobohf0XasqAtL23dRrXt7HLAXcIqkOwYtWDKiivoPvDq2f1o/fX6B7IiGXSvpL2x/rX2npA9QrVg01vXFDXFJO1NlyoHAAuCgeuDdFsBPaGhRkuLb3OsZ21apoMmZYoxRtaDyd4GngNbN4V2B9amWgXywodK6puQb4i2SrgK+BlwweOlOSUfabmRAUz+E+3KqNVPPAa6l6kXyPNtXNlFXRIuk/agWsgC4zfYVq3t9jA5D9Ha6lhea046zfX5jxdEf4T4O2J9qCtydqWZvO6d9npmIiHW1it5O04ANGQW9nYq/oWr7WduX2p4J7A7cDfxI0kcaLi0ixrahejs9YvteqoBvVF/cUK0nBzuQ6up9MnAK5ay8HhHNGNW9nYoPd0nzqOYB/z7w2dE4kiwixqRR3dupH9rcn+OFpa/aT7aI4fkR0YzR3tup+HCPiOil0drbKeEeEVGg4nvLRET0o4R7RESBEu7RNyRZ0slt238t6TMNlhTRMwn36CdPAe+WNKHpQiJ6LeEe/WQFMAf4+OADkg6SdK2kGyT9QNLm9f7PSJon6XJJSyW9W9I/SLpF0qWS1qtft6ukKyUtlnSZpIkje2oRK0u4R785DThc0saD9l8N7G57F6oVgz7Vdmw7qhHO04FvAT+sV/N6EjiwDvhTgUNt7wqcBZzY29OIWL3iR6hGtLP9mKRvUC3a0j496yTg3+or7hcD97Qd+77tZyTdAowDLq3330I1ncX2VKOgF0iifs0DvTyPiDXJlXv0o38BjmblyZ1OBb5cX5F/AHhJ27GnAGw/BzzjFwaHPEd1gSSqwStvqP+9zvbbe3wOEauVcI++U6/reR5VwLdsTLWuLqz78ot3AgOS9gCQtJ6kHdfwnoieSrhHvzoZaO818xngfEk/Bh5ely9k+2ngUODvJd0E3Ajs2Z0yI4Yn0w9ERBQoV+4REQVKuEdEFCjhHhFRoIR7RESBEu4REQVKuEdEFCjhHhFRoIR7RESB/j/ELE9ywrSq1AAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "needs_background": "light"
          },
          "output_type": "display_data"
        }
      ],
      "source": [
        "pokemon.loc[fish_pokemon][\"Attack\"].sort_values().plot(kind=\"bar\")"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.8.8"
    },
    "colab": {
      "provenance": []
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}