Introducción a Pandas.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LYYRoNB-JJim"
      },
      "source": [
        "# Pandas\n",
        "\n",
        "Pandas es un herramienta de Python que sirve para manipular y analizar datos.\n",
        "\n",
        "Las dos estructuras básicas que usa pandas para guardar la información son los *DataFrames* y las *Series*.\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ux7-wCDxJrfP"
      },
      "source": [
        "## Carga del paquete"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "StWTaNIWJHK0"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QfOxfAOiJyP4"
      },
      "source": [
        "## *DataFrame*\n",
        "\n",
        "Un *DataFrame* tiene filas y columnas para almacenar los datos. Cada fila representa los datos de un caso, igual que en una base de datos relacional o en una hoja de cálculo."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "v8D_58niJxZo",
        "outputId": "04700ae9-efd2-4152-a05e-c89606ffd531"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "        nombre  salario    sexo\n",
            "A  Aitor Tilla     2000    male\n",
            "B  Helen Chufe     2500  female\n",
            "C   Lola Mento     1400  female\n"
          ]
        }
      ],
      "source": [
        "employees = pd.DataFrame(\n",
        "    {\n",
        "        \"nombre\": [\"Aitor Tilla\", \"Helen Chufe\", \"Lola Mento\"],\n",
        "        \"salario\": [2000, 2500, 1400],\n",
        "        \"sexo\": [\"male\", \"female\", \"female\"]\n",
        "    },index=['A', 'B', 'C']\n",
        ")\n",
        "\n",
        "print(employees)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "HotVhyoFONKd"
      },
      "source": [
        "## Series\n",
        "\n",
        "Las *Series* son secuencias de datos (como en una lista)."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sWsq86mYJjCh",
        "outputId": "aebc42fc-4aa0-4731-e096-8e093f0f722e"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "A    500\n",
            "B    200\n",
            "C    300\n",
            "dtype: int64\n"
          ]
        }
      ],
      "source": [
        "numbers = pd.Series([500, 200, 300],\n",
        "             index=['A', 'B', 'C'])\n",
        "print(numbers)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "g74bRg1kPczm"
      },
      "source": [
        "Las *Series* se pueden etiquetar igual que los *DataFrames*."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0BqLmTTKPk3T",
        "outputId": "4a0081d5-ae28-491b-c939-0d118aff2de0"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0    500\n",
            "1    200\n",
            "2    300\n",
            "3    400\n",
            "4    850\n",
            "5    600\n",
            "Name: extra salary, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "extra_salary = pd.Series([500, 200, 300, 400, 850, 600], name=\"extra salary\")\n",
        "print(extra_salary)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PG1oKQY_OvO0"
      },
      "source": [
        "Cada columna de un *DataFrame* es una *Series*. Por ejemplo, si queremos trabajar con el sueldo, sacamos únicamente \"salary\"."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "9LjeQCQxOkYS",
        "outputId": "896e9b96-5129-45e3-ca84-c1c5ebd76122"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "A    2000\n",
            "B    2500\n",
            "C    1400\n",
            "Name: salario, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "print(employees[\"salario\"])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "f2G-DZ4uPLGl",
        "outputId": "9858c1d5-0c9a-43b5-f076-070c80a93fb6"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "El salario máximo es 2500 € y el mínimo 1400 €\n"
          ]
        }
      ],
      "source": [
        "print(f\"El salario máximo es {employees['salario'].max()} € y el mínimo {employees['salario'].min()} €\")"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6O_s6meBRKpu"
      },
      "source": [
        "También podemos sacar datos estadísticos."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 300
        },
        "id": "gvYc7v4ARohh",
        "outputId": "cbac785d-58d5-4116-a24d-8df9a0531649"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           salario\n",
              "count     3.000000\n",
              "mean   1966.666667\n",
              "std     550.757055\n",
              "min    1400.000000\n",
              "25%    1700.000000\n",
              "50%    2000.000000\n",
              "75%    2250.000000\n",
              "max    2500.000000"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b60bf86f-927d-4f03-b6f1-5f90a01d4a35\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>salario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>3.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>1966.666667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>550.757055</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>1400.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>1700.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>2000.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>2250.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>2500.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b60bf86f-927d-4f03-b6f1-5f90a01d4a35')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-b60bf86f-927d-4f03-b6f1-5f90a01d4a35 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-b60bf86f-927d-4f03-b6f1-5f90a01d4a35');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-9cc142da-8e5d-45fe-9ff4-b27de8d2f6be\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9cc142da-8e5d-45fe-9ff4-b27de8d2f6be')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-9cc142da-8e5d-45fe-9ff4-b27de8d2f6be button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ],
      "source": [
        "employees.describe()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "skRApi5HfTnm"
      },
      "source": [
        "## Carga de datos de un CSV\n",
        "\n",
        "Normalmente, los datos se obtienen de una fuente externa, como puede ser un archivo CSV.\n",
        "\n",
        "Hemos subido el archivo `employees.csv` a la carpeta `sample_data` de nuestro Colab."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jcAcZ2BvRsc5"
      },
      "outputs": [],
      "source": [
        "employees = pd.read_csv(\"sample_data/employees.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "VXB9b7axgHIX",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "390518da-6a8c-4013-c35e-56e8d58ed23d"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "    EMPLOYEE_ID   FIRST_NAME    LAST_NAME     EMAIL  PHONE_NUMBER  HIRE_DATE  \\\n",
            "0           198       Donald     OConnell  DOCONNEL  650.507.9833  21-JUN-07   \n",
            "1           199      Douglas        Grant    DGRANT  650.507.9844  13-JAN-08   \n",
            "2           200     Jennifer       Whalen   JWHALEN  515.123.4444  17-SEP-03   \n",
            "3           201      Michael    Hartstein  MHARTSTE  515.123.5555  17-FEB-04   \n",
            "4           202          Pat          Fay      PFAY  603.123.6666  17-AUG-05   \n",
            "5           203        Susan       Mavris   SMAVRIS  515.123.7777  07-JUN-02   \n",
            "6           204      Hermann         Baer     HBAER  515.123.8888  07-JUN-02   \n",
            "7           205      Shelley      Higgins  SHIGGINS  515.123.8080  07-JUN-02   \n",
            "8           206      William        Gietz    WGIETZ  515.123.8181  07-JUN-02   \n",
            "9           100       Steven         King     SKING  515.123.4567  17-JUN-03   \n",
            "10          101        Neena      Kochhar  NKOCHHAR  515.123.4568  21-SEP-05   \n",
            "11          102          Lex      De Haan   LDEHAAN  515.123.4569  13-JAN-01   \n",
            "12          103    Alexander       Hunold   AHUNOLD  590.423.4567  03-JAN-06   \n",
            "13          104        Bruce        Ernst    BERNST  590.423.4568  21-MAY-07   \n",
            "14          105        David       Austin   DAUSTIN  590.423.4569  25-JUN-05   \n",
            "15          106        Valli    Pataballa  VPATABAL  590.423.4560  05-FEB-06   \n",
            "16          107        Diana      Lorentz  DLORENTZ  590.423.5567  07-FEB-07   \n",
            "17          108        Nancy    Greenberg  NGREENBE  515.124.4569  17-AUG-02   \n",
            "18          109       Daniel       Faviet   DFAVIET  515.124.4169  16-AUG-02   \n",
            "19          110         John         Chen     JCHEN  515.124.4269  28-SEP-05   \n",
            "20          111       Ismael      Sciarra  ISCIARRA  515.124.4369  30-SEP-05   \n",
            "21          112  Jose Manuel        Urman   JMURMAN  515.124.4469  07-MAR-06   \n",
            "22          113         Luis         Popp     LPOPP  515.124.4567  07-DEC-07   \n",
            "23          114          Den     Raphaely  DRAPHEAL  515.127.4561  07-DEC-02   \n",
            "24          115    Alexander         Khoo     AKHOO  515.127.4562  18-MAY-03   \n",
            "25          116       Shelli        Baida    SBAIDA  515.127.4563  24-DEC-05   \n",
            "26          117        Sigal       Tobias   STOBIAS  515.127.4564  24-JUL-05   \n",
            "27          118          Guy       Himuro   GHIMURO  515.127.4565  15-NOV-06   \n",
            "28          119        Karen   Colmenares  KCOLMENA  515.127.4566  10-AUG-07   \n",
            "29          120      Matthew        Weiss    MWEISS  650.123.1234  18-JUL-04   \n",
            "30          121         Adam        Fripp    AFRIPP  650.123.2234  10-APR-05   \n",
            "31          122        Payam     Kaufling  PKAUFLIN  650.123.3234  01-MAY-03   \n",
            "32          123       Shanta      Vollman  SVOLLMAN  650.123.4234  10-OCT-05   \n",
            "33          124        Kevin      Mourgos  KMOURGOS  650.123.5234  16-NOV-07   \n",
            "34          125        Julia        Nayer    JNAYER  650.124.1214  16-JUL-05   \n",
            "35          126        Irene  Mikkilineni  IMIKKILI  650.124.1224  28-SEP-06   \n",
            "36          127        James       Landry   JLANDRY  650.124.1334  14-JAN-07   \n",
            "37          128       Steven       Markle   SMARKLE  650.124.1434  08-MAR-08   \n",
            "38          129        Laura       Bissot   LBISSOT  650.124.5234  20-AUG-05   \n",
            "39          130        Mozhe     Atkinson  MATKINSO  650.124.6234  30-OCT-05   \n",
            "40          131        James       Marlow   JAMRLOW  650.124.7234  16-FEB-05   \n",
            "41          132           TJ        Olson   TJOLSON  650.124.8234  10-APR-07   \n",
            "42          133        Jason       Mallin   JMALLIN  650.127.1934  14-JUN-04   \n",
            "43          134      Michael       Rogers   MROGERS  650.127.1834  26-AUG-06   \n",
            "44          135           Ki          Gee      KGEE  650.127.1734  12-DEC-07   \n",
            "45          136        Hazel   Philtanker  HPHILTAN  650.127.1634  06-FEB-08   \n",
            "46          137       Renske       Ladwig   RLADWIG  650.121.1234  14-JUL-03   \n",
            "47          138      Stephen       Stiles   SSTILES  650.121.2034  26-OCT-05   \n",
            "48          139         John          Seo      JSEO  650.121.2019  12-FEB-06   \n",
            "49          140       Joshua        Patel    JPATEL  650.121.1834  06-APR-06   \n",
            "\n",
            "        JOB_ID  SALARY COMMISSION_PCT MANAGER_ID  DEPARTMENT_ID  \n",
            "0     SH_CLERK    2600             -         124             50  \n",
            "1     SH_CLERK    2600             -         124             50  \n",
            "2      AD_ASST    4400             -         101             10  \n",
            "3       MK_MAN   13000             -         100             20  \n",
            "4       MK_REP    6000             -         201             20  \n",
            "5       HR_REP    6500             -         101             40  \n",
            "6       PR_REP   10000             -         101             70  \n",
            "7       AC_MGR   12008             -         101            110  \n",
            "8   AC_ACCOUNT    8300             -         205            110  \n",
            "9      AD_PRES   24000             -          -              90  \n",
            "10       AD_VP   17000             -         100             90  \n",
            "11       AD_VP   17000             -         100             90  \n",
            "12     IT_PROG    9000             -         102             60  \n",
            "13     IT_PROG    6000             -         103             60  \n",
            "14     IT_PROG    4800             -         103             60  \n",
            "15     IT_PROG    4800             -         103             60  \n",
            "16     IT_PROG    4200             -         103             60  \n",
            "17      FI_MGR   12008             -         101            100  \n",
            "18  FI_ACCOUNT    9000             -         108            100  \n",
            "19  FI_ACCOUNT    8200             -         108            100  \n",
            "20  FI_ACCOUNT    7700             -         108            100  \n",
            "21  FI_ACCOUNT    7800             -         108            100  \n",
            "22  FI_ACCOUNT    6900             -         108            100  \n",
            "23      PU_MAN   11000             -         100             30  \n",
            "24    PU_CLERK    3100             -         114             30  \n",
            "25    PU_CLERK    2900             -         114             30  \n",
            "26    PU_CLERK    2800             -         114             30  \n",
            "27    PU_CLERK    2600             -         114             30  \n",
            "28    PU_CLERK    2500             -         114             30  \n",
            "29      ST_MAN    8000             -         100             50  \n",
            "30      ST_MAN    8200             -         100             50  \n",
            "31      ST_MAN    7900             -         100             50  \n",
            "32      ST_MAN    6500             -         100             50  \n",
            "33      ST_MAN    5800             -         100             50  \n",
            "34    ST_CLERK    3200             -         120             50  \n",
            "35    ST_CLERK    2700             -         120             50  \n",
            "36    ST_CLERK    2400             -         120             50  \n",
            "37    ST_CLERK    2200             -         120             50  \n",
            "38    ST_CLERK    3300             -         121             50  \n",
            "39    ST_CLERK    2800             -         121             50  \n",
            "40    ST_CLERK    2500             -         121             50  \n",
            "41    ST_CLERK    2100             -         121             50  \n",
            "42    ST_CLERK    3300             -         122             50  \n",
            "43    ST_CLERK    2900             -         122             50  \n",
            "44    ST_CLERK    2400             -         122             50  \n",
            "45    ST_CLERK    2200             -         122             50  \n",
            "46    ST_CLERK    3600             -         123             50  \n",
            "47    ST_CLERK    3200             -         123             50  \n",
            "48    ST_CLERK    2700             -         123             50  \n",
            "49    ST_CLERK    2500             -         123             50  \n"
          ]
        }
      ],
      "source": [
        "print(employees)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "eI5ZtP9KgLPP",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 300
        },
        "outputId": "4d201629-33aa-4f45-d2a9-43f20eee429e"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       EMPLOYEE_ID        SALARY  DEPARTMENT_ID\n",
              "count    50.000000     50.000000       50.00000\n",
              "mean    134.760000   6182.320000       57.60000\n",
              "std      33.631594   4586.181772       25.11687\n",
              "min     100.000000   2100.000000       10.00000\n",
              "25%     112.250000   2725.000000       50.00000\n",
              "50%     124.500000   4600.000000       50.00000\n",
              "75%     136.750000   8150.000000       60.00000\n",
              "max     206.000000  24000.000000      110.00000"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-43af5680-c96d-4a83-8612-9570ee1480fc\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>EMPLOYEE_ID</th>\n",
              "      <th>SALARY</th>\n",
              "      <th>DEPARTMENT_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>50.000000</td>\n",
              "      <td>50.000000</td>\n",
              "      <td>50.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>134.760000</td>\n",
              "      <td>6182.320000</td>\n",
              "      <td>57.60000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>33.631594</td>\n",
              "      <td>4586.181772</td>\n",
              "      <td>25.11687</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>100.000000</td>\n",
              "      <td>2100.000000</td>\n",
              "      <td>10.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>112.250000</td>\n",
              "      <td>2725.000000</td>\n",
              "      <td>50.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>124.500000</td>\n",
              "      <td>4600.000000</td>\n",
              "      <td>50.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>136.750000</td>\n",
              "      <td>8150.000000</td>\n",
              "      <td>60.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>206.000000</td>\n",
              "      <td>24000.000000</td>\n",
              "      <td>110.00000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-43af5680-c96d-4a83-8612-9570ee1480fc')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-43af5680-c96d-4a83-8612-9570ee1480fc button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-43af5680-c96d-4a83-8612-9570ee1480fc');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7466e0b5-5811-481f-92f2-17c52ba038b6\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7466e0b5-5811-481f-92f2-17c52ba038b6')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7466e0b5-5811-481f-92f2-17c52ba038b6 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ],
      "source": [
        "employees.describe()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "wQFeypkjgkHH"
      },
      "source": [
        "Igual que con los comando `head` y `tail` de Linux, podemos visualizar los primeros y los últimos elementos del *DataFrame*"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "rHrWUB4Kgafn",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 226
        },
        "outputId": "3f6c8ed4-54a3-4a9c-cf5e-23b7f39ba4aa"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   EMPLOYEE_ID FIRST_NAME  LAST_NAME     EMAIL  PHONE_NUMBER  HIRE_DATE  \\\n",
              "0          198     Donald   OConnell  DOCONNEL  650.507.9833  21-JUN-07   \n",
              "1          199    Douglas      Grant    DGRANT  650.507.9844  13-JAN-08   \n",
              "2          200   Jennifer     Whalen   JWHALEN  515.123.4444  17-SEP-03   \n",
              "3          201    Michael  Hartstein  MHARTSTE  515.123.5555  17-FEB-04   \n",
              "4          202        Pat        Fay      PFAY  603.123.6666  17-AUG-05   \n",
              "\n",
              "     JOB_ID  SALARY COMMISSION_PCT MANAGER_ID  DEPARTMENT_ID  \n",
              "0  SH_CLERK    2600             -         124             50  \n",
              "1  SH_CLERK    2600             -         124             50  \n",
              "2   AD_ASST    4400             -         101             10  \n",
              "3    MK_MAN   13000             -         100             20  \n",
              "4    MK_REP    6000             -         201             20  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-417cee39-5ee1-4c92-8824-d53592549a1d\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>EMPLOYEE_ID</th>\n",
              "      <th>FIRST_NAME</th>\n",
              "      <th>LAST_NAME</th>\n",
              "      <th>EMAIL</th>\n",
              "      <th>PHONE_NUMBER</th>\n",
              "      <th>HIRE_DATE</th>\n",
              "      <th>JOB_ID</th>\n",
              "      <th>SALARY</th>\n",
              "      <th>COMMISSION_PCT</th>\n",
              "      <th>MANAGER_ID</th>\n",
              "      <th>DEPARTMENT_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>198</td>\n",
              "      <td>Donald</td>\n",
              "      <td>OConnell</td>\n",
              "      <td>DOCONNEL</td>\n",
              "      <td>650.507.9833</td>\n",
              "      <td>21-JUN-07</td>\n",
              "      <td>SH_CLERK</td>\n",
              "      <td>2600</td>\n",
              "      <td>-</td>\n",
              "      <td>124</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>199</td>\n",
              "      <td>Douglas</td>\n",
              "      <td>Grant</td>\n",
              "      <td>DGRANT</td>\n",
              "      <td>650.507.9844</td>\n",
              "      <td>13-JAN-08</td>\n",
              "      <td>SH_CLERK</td>\n",
              "      <td>2600</td>\n",
              "      <td>-</td>\n",
              "      <td>124</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>200</td>\n",
              "      <td>Jennifer</td>\n",
              "      <td>Whalen</td>\n",
              "      <td>JWHALEN</td>\n",
              "      <td>515.123.4444</td>\n",
              "      <td>17-SEP-03</td>\n",
              "      <td>AD_ASST</td>\n",
              "      <td>4400</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201</td>\n",
              "      <td>Michael</td>\n",
              "      <td>Hartstein</td>\n",
              "      <td>MHARTSTE</td>\n",
              "      <td>515.123.5555</td>\n",
              "      <td>17-FEB-04</td>\n",
              "      <td>MK_MAN</td>\n",
              "      <td>13000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>202</td>\n",
              "      <td>Pat</td>\n",
              "      <td>Fay</td>\n",
              "      <td>PFAY</td>\n",
              "      <td>603.123.6666</td>\n",
              "      <td>17-AUG-05</td>\n",
              "      <td>MK_REP</td>\n",
              "      <td>6000</td>\n",
              "      <td>-</td>\n",
              "      <td>201</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-417cee39-5ee1-4c92-8824-d53592549a1d')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-417cee39-5ee1-4c92-8824-d53592549a1d button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-417cee39-5ee1-4c92-8824-d53592549a1d');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-e7dfa462-7658-43ae-b6d1-951d58075ef4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e7dfa462-7658-43ae-b6d1-951d58075ef4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-e7dfa462-7658-43ae-b6d1-951d58075ef4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ],
      "source": [
        "employees.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "qUPr0U18gz1d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "3899d19b-8a1d-4818-d5a5-eaf1637fe239"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    EMPLOYEE_ID   FIRST_NAME   LAST_NAME     EMAIL  PHONE_NUMBER  HIRE_DATE  \\\n",
              "0           198       Donald    OConnell  DOCONNEL  650.507.9833  21-JUN-07   \n",
              "1           199      Douglas       Grant    DGRANT  650.507.9844  13-JAN-08   \n",
              "2           200     Jennifer      Whalen   JWHALEN  515.123.4444  17-SEP-03   \n",
              "3           201      Michael   Hartstein  MHARTSTE  515.123.5555  17-FEB-04   \n",
              "4           202          Pat         Fay      PFAY  603.123.6666  17-AUG-05   \n",
              "5           203        Susan      Mavris   SMAVRIS  515.123.7777  07-JUN-02   \n",
              "6           204      Hermann        Baer     HBAER  515.123.8888  07-JUN-02   \n",
              "7           205      Shelley     Higgins  SHIGGINS  515.123.8080  07-JUN-02   \n",
              "8           206      William       Gietz    WGIETZ  515.123.8181  07-JUN-02   \n",
              "9           100       Steven        King     SKING  515.123.4567  17-JUN-03   \n",
              "10          101        Neena     Kochhar  NKOCHHAR  515.123.4568  21-SEP-05   \n",
              "11          102          Lex     De Haan   LDEHAAN  515.123.4569  13-JAN-01   \n",
              "12          103    Alexander      Hunold   AHUNOLD  590.423.4567  03-JAN-06   \n",
              "13          104        Bruce       Ernst    BERNST  590.423.4568  21-MAY-07   \n",
              "14          105        David      Austin   DAUSTIN  590.423.4569  25-JUN-05   \n",
              "15          106        Valli   Pataballa  VPATABAL  590.423.4560  05-FEB-06   \n",
              "16          107        Diana     Lorentz  DLORENTZ  590.423.5567  07-FEB-07   \n",
              "17          108        Nancy   Greenberg  NGREENBE  515.124.4569  17-AUG-02   \n",
              "18          109       Daniel      Faviet   DFAVIET  515.124.4169  16-AUG-02   \n",
              "19          110         John        Chen     JCHEN  515.124.4269  28-SEP-05   \n",
              "20          111       Ismael     Sciarra  ISCIARRA  515.124.4369  30-SEP-05   \n",
              "21          112  Jose Manuel       Urman   JMURMAN  515.124.4469  07-MAR-06   \n",
              "22          113         Luis        Popp     LPOPP  515.124.4567  07-DEC-07   \n",
              "23          114          Den    Raphaely  DRAPHEAL  515.127.4561  07-DEC-02   \n",
              "24          115    Alexander        Khoo     AKHOO  515.127.4562  18-MAY-03   \n",
              "25          116       Shelli       Baida    SBAIDA  515.127.4563  24-DEC-05   \n",
              "26          117        Sigal      Tobias   STOBIAS  515.127.4564  24-JUL-05   \n",
              "27          118          Guy      Himuro   GHIMURO  515.127.4565  15-NOV-06   \n",
              "28          119        Karen  Colmenares  KCOLMENA  515.127.4566  10-AUG-07   \n",
              "29          120      Matthew       Weiss    MWEISS  650.123.1234  18-JUL-04   \n",
              "\n",
              "        JOB_ID  SALARY COMMISSION_PCT MANAGER_ID  DEPARTMENT_ID  \n",
              "0     SH_CLERK    2600             -         124             50  \n",
              "1     SH_CLERK    2600             -         124             50  \n",
              "2      AD_ASST    4400             -         101             10  \n",
              "3       MK_MAN   13000             -         100             20  \n",
              "4       MK_REP    6000             -         201             20  \n",
              "5       HR_REP    6500             -         101             40  \n",
              "6       PR_REP   10000             -         101             70  \n",
              "7       AC_MGR   12008             -         101            110  \n",
              "8   AC_ACCOUNT    8300             -         205            110  \n",
              "9      AD_PRES   24000             -          -              90  \n",
              "10       AD_VP   17000             -         100             90  \n",
              "11       AD_VP   17000             -         100             90  \n",
              "12     IT_PROG    9000             -         102             60  \n",
              "13     IT_PROG    6000             -         103             60  \n",
              "14     IT_PROG    4800             -         103             60  \n",
              "15     IT_PROG    4800             -         103             60  \n",
              "16     IT_PROG    4200             -         103             60  \n",
              "17      FI_MGR   12008             -         101            100  \n",
              "18  FI_ACCOUNT    9000             -         108            100  \n",
              "19  FI_ACCOUNT    8200             -         108            100  \n",
              "20  FI_ACCOUNT    7700             -         108            100  \n",
              "21  FI_ACCOUNT    7800             -         108            100  \n",
              "22  FI_ACCOUNT    6900             -         108            100  \n",
              "23      PU_MAN   11000             -         100             30  \n",
              "24    PU_CLERK    3100             -         114             30  \n",
              "25    PU_CLERK    2900             -         114             30  \n",
              "26    PU_CLERK    2800             -         114             30  \n",
              "27    PU_CLERK    2600             -         114             30  \n",
              "28    PU_CLERK    2500             -         114             30  \n",
              "29      ST_MAN    8000             -         100             50  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-99cc34d6-1d6f-4e8b-9a80-08ad43a93d53\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>EMPLOYEE_ID</th>\n",
              "      <th>FIRST_NAME</th>\n",
              "      <th>LAST_NAME</th>\n",
              "      <th>EMAIL</th>\n",
              "      <th>PHONE_NUMBER</th>\n",
              "      <th>HIRE_DATE</th>\n",
              "      <th>JOB_ID</th>\n",
              "      <th>SALARY</th>\n",
              "      <th>COMMISSION_PCT</th>\n",
              "      <th>MANAGER_ID</th>\n",
              "      <th>DEPARTMENT_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>198</td>\n",
              "      <td>Donald</td>\n",
              "      <td>OConnell</td>\n",
              "      <td>DOCONNEL</td>\n",
              "      <td>650.507.9833</td>\n",
              "      <td>21-JUN-07</td>\n",
              "      <td>SH_CLERK</td>\n",
              "      <td>2600</td>\n",
              "      <td>-</td>\n",
              "      <td>124</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>199</td>\n",
              "      <td>Douglas</td>\n",
              "      <td>Grant</td>\n",
              "      <td>DGRANT</td>\n",
              "      <td>650.507.9844</td>\n",
              "      <td>13-JAN-08</td>\n",
              "      <td>SH_CLERK</td>\n",
              "      <td>2600</td>\n",
              "      <td>-</td>\n",
              "      <td>124</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>200</td>\n",
              "      <td>Jennifer</td>\n",
              "      <td>Whalen</td>\n",
              "      <td>JWHALEN</td>\n",
              "      <td>515.123.4444</td>\n",
              "      <td>17-SEP-03</td>\n",
              "      <td>AD_ASST</td>\n",
              "      <td>4400</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201</td>\n",
              "      <td>Michael</td>\n",
              "      <td>Hartstein</td>\n",
              "      <td>MHARTSTE</td>\n",
              "      <td>515.123.5555</td>\n",
              "      <td>17-FEB-04</td>\n",
              "      <td>MK_MAN</td>\n",
              "      <td>13000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>202</td>\n",
              "      <td>Pat</td>\n",
              "      <td>Fay</td>\n",
              "      <td>PFAY</td>\n",
              "      <td>603.123.6666</td>\n",
              "      <td>17-AUG-05</td>\n",
              "      <td>MK_REP</td>\n",
              "      <td>6000</td>\n",
              "      <td>-</td>\n",
              "      <td>201</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>203</td>\n",
              "      <td>Susan</td>\n",
              "      <td>Mavris</td>\n",
              "      <td>SMAVRIS</td>\n",
              "      <td>515.123.7777</td>\n",
              "      <td>07-JUN-02</td>\n",
              "      <td>HR_REP</td>\n",
              "      <td>6500</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>204</td>\n",
              "      <td>Hermann</td>\n",
              "      <td>Baer</td>\n",
              "      <td>HBAER</td>\n",
              "      <td>515.123.8888</td>\n",
              "      <td>07-JUN-02</td>\n",
              "      <td>PR_REP</td>\n",
              "      <td>10000</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>70</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>205</td>\n",
              "      <td>Shelley</td>\n",
              "      <td>Higgins</td>\n",
              "      <td>SHIGGINS</td>\n",
              "      <td>515.123.8080</td>\n",
              "      <td>07-JUN-02</td>\n",
              "      <td>AC_MGR</td>\n",
              "      <td>12008</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>110</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>206</td>\n",
              "      <td>William</td>\n",
              "      <td>Gietz</td>\n",
              "      <td>WGIETZ</td>\n",
              "      <td>515.123.8181</td>\n",
              "      <td>07-JUN-02</td>\n",
              "      <td>AC_ACCOUNT</td>\n",
              "      <td>8300</td>\n",
              "      <td>-</td>\n",
              "      <td>205</td>\n",
              "      <td>110</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>100</td>\n",
              "      <td>Steven</td>\n",
              "      <td>King</td>\n",
              "      <td>SKING</td>\n",
              "      <td>515.123.4567</td>\n",
              "      <td>17-JUN-03</td>\n",
              "      <td>AD_PRES</td>\n",
              "      <td>24000</td>\n",
              "      <td>-</td>\n",
              "      <td>-</td>\n",
              "      <td>90</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>101</td>\n",
              "      <td>Neena</td>\n",
              "      <td>Kochhar</td>\n",
              "      <td>NKOCHHAR</td>\n",
              "      <td>515.123.4568</td>\n",
              "      <td>21-SEP-05</td>\n",
              "      <td>AD_VP</td>\n",
              "      <td>17000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>90</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>102</td>\n",
              "      <td>Lex</td>\n",
              "      <td>De Haan</td>\n",
              "      <td>LDEHAAN</td>\n",
              "      <td>515.123.4569</td>\n",
              "      <td>13-JAN-01</td>\n",
              "      <td>AD_VP</td>\n",
              "      <td>17000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>90</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>103</td>\n",
              "      <td>Alexander</td>\n",
              "      <td>Hunold</td>\n",
              "      <td>AHUNOLD</td>\n",
              "      <td>590.423.4567</td>\n",
              "      <td>03-JAN-06</td>\n",
              "      <td>IT_PROG</td>\n",
              "      <td>9000</td>\n",
              "      <td>-</td>\n",
              "      <td>102</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>104</td>\n",
              "      <td>Bruce</td>\n",
              "      <td>Ernst</td>\n",
              "      <td>BERNST</td>\n",
              "      <td>590.423.4568</td>\n",
              "      <td>21-MAY-07</td>\n",
              "      <td>IT_PROG</td>\n",
              "      <td>6000</td>\n",
              "      <td>-</td>\n",
              "      <td>103</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>105</td>\n",
              "      <td>David</td>\n",
              "      <td>Austin</td>\n",
              "      <td>DAUSTIN</td>\n",
              "      <td>590.423.4569</td>\n",
              "      <td>25-JUN-05</td>\n",
              "      <td>IT_PROG</td>\n",
              "      <td>4800</td>\n",
              "      <td>-</td>\n",
              "      <td>103</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>106</td>\n",
              "      <td>Valli</td>\n",
              "      <td>Pataballa</td>\n",
              "      <td>VPATABAL</td>\n",
              "      <td>590.423.4560</td>\n",
              "      <td>05-FEB-06</td>\n",
              "      <td>IT_PROG</td>\n",
              "      <td>4800</td>\n",
              "      <td>-</td>\n",
              "      <td>103</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>107</td>\n",
              "      <td>Diana</td>\n",
              "      <td>Lorentz</td>\n",
              "      <td>DLORENTZ</td>\n",
              "      <td>590.423.5567</td>\n",
              "      <td>07-FEB-07</td>\n",
              "      <td>IT_PROG</td>\n",
              "      <td>4200</td>\n",
              "      <td>-</td>\n",
              "      <td>103</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>108</td>\n",
              "      <td>Nancy</td>\n",
              "      <td>Greenberg</td>\n",
              "      <td>NGREENBE</td>\n",
              "      <td>515.124.4569</td>\n",
              "      <td>17-AUG-02</td>\n",
              "      <td>FI_MGR</td>\n",
              "      <td>12008</td>\n",
              "      <td>-</td>\n",
              "      <td>101</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>109</td>\n",
              "      <td>Daniel</td>\n",
              "      <td>Faviet</td>\n",
              "      <td>DFAVIET</td>\n",
              "      <td>515.124.4169</td>\n",
              "      <td>16-AUG-02</td>\n",
              "      <td>FI_ACCOUNT</td>\n",
              "      <td>9000</td>\n",
              "      <td>-</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>110</td>\n",
              "      <td>John</td>\n",
              "      <td>Chen</td>\n",
              "      <td>JCHEN</td>\n",
              "      <td>515.124.4269</td>\n",
              "      <td>28-SEP-05</td>\n",
              "      <td>FI_ACCOUNT</td>\n",
              "      <td>8200</td>\n",
              "      <td>-</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>111</td>\n",
              "      <td>Ismael</td>\n",
              "      <td>Sciarra</td>\n",
              "      <td>ISCIARRA</td>\n",
              "      <td>515.124.4369</td>\n",
              "      <td>30-SEP-05</td>\n",
              "      <td>FI_ACCOUNT</td>\n",
              "      <td>7700</td>\n",
              "      <td>-</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>112</td>\n",
              "      <td>Jose Manuel</td>\n",
              "      <td>Urman</td>\n",
              "      <td>JMURMAN</td>\n",
              "      <td>515.124.4469</td>\n",
              "      <td>07-MAR-06</td>\n",
              "      <td>FI_ACCOUNT</td>\n",
              "      <td>7800</td>\n",
              "      <td>-</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>113</td>\n",
              "      <td>Luis</td>\n",
              "      <td>Popp</td>\n",
              "      <td>LPOPP</td>\n",
              "      <td>515.124.4567</td>\n",
              "      <td>07-DEC-07</td>\n",
              "      <td>FI_ACCOUNT</td>\n",
              "      <td>6900</td>\n",
              "      <td>-</td>\n",
              "      <td>108</td>\n",
              "      <td>100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>114</td>\n",
              "      <td>Den</td>\n",
              "      <td>Raphaely</td>\n",
              "      <td>DRAPHEAL</td>\n",
              "      <td>515.127.4561</td>\n",
              "      <td>07-DEC-02</td>\n",
              "      <td>PU_MAN</td>\n",
              "      <td>11000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>115</td>\n",
              "      <td>Alexander</td>\n",
              "      <td>Khoo</td>\n",
              "      <td>AKHOO</td>\n",
              "      <td>515.127.4562</td>\n",
              "      <td>18-MAY-03</td>\n",
              "      <td>PU_CLERK</td>\n",
              "      <td>3100</td>\n",
              "      <td>-</td>\n",
              "      <td>114</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>116</td>\n",
              "      <td>Shelli</td>\n",
              "      <td>Baida</td>\n",
              "      <td>SBAIDA</td>\n",
              "      <td>515.127.4563</td>\n",
              "      <td>24-DEC-05</td>\n",
              "      <td>PU_CLERK</td>\n",
              "      <td>2900</td>\n",
              "      <td>-</td>\n",
              "      <td>114</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>117</td>\n",
              "      <td>Sigal</td>\n",
              "      <td>Tobias</td>\n",
              "      <td>STOBIAS</td>\n",
              "      <td>515.127.4564</td>\n",
              "      <td>24-JUL-05</td>\n",
              "      <td>PU_CLERK</td>\n",
              "      <td>2800</td>\n",
              "      <td>-</td>\n",
              "      <td>114</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>118</td>\n",
              "      <td>Guy</td>\n",
              "      <td>Himuro</td>\n",
              "      <td>GHIMURO</td>\n",
              "      <td>515.127.4565</td>\n",
              "      <td>15-NOV-06</td>\n",
              "      <td>PU_CLERK</td>\n",
              "      <td>2600</td>\n",
              "      <td>-</td>\n",
              "      <td>114</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>119</td>\n",
              "      <td>Karen</td>\n",
              "      <td>Colmenares</td>\n",
              "      <td>KCOLMENA</td>\n",
              "      <td>515.127.4566</td>\n",
              "      <td>10-AUG-07</td>\n",
              "      <td>PU_CLERK</td>\n",
              "      <td>2500</td>\n",
              "      <td>-</td>\n",
              "      <td>114</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>120</td>\n",
              "      <td>Matthew</td>\n",
              "      <td>Weiss</td>\n",
              "      <td>MWEISS</td>\n",
              "      <td>650.123.1234</td>\n",
              "      <td>18-JUL-04</td>\n",
              "      <td>ST_MAN</td>\n",
              "      <td>8000</td>\n",
              "      <td>-</td>\n",
              "      <td>100</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-99cc34d6-1d6f-4e8b-9a80-08ad43a93d53')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-99cc34d6-1d6f-4e8b-9a80-08ad43a93d53 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-99cc34d6-1d6f-4e8b-9a80-08ad43a93d53');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-3012a815-1ae7-4728-8734-6b825a7c964e\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3012a815-1ae7-4728-8734-6b825a7c964e')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-3012a815-1ae7-4728-8734-6b825a7c964e button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ],
      "source": [
        "employees.head(30)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "T3mFnzlTg3ge",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 226
        },
        "outputId": "8eebf244-d63e-42f3-e560-ecb95f628b2c"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    EMPLOYEE_ID FIRST_NAME   LAST_NAME     EMAIL  PHONE_NUMBER  HIRE_DATE  \\\n",
              "45          136      Hazel  Philtanker  HPHILTAN  650.127.1634  06-FEB-08   \n",
              "46          137     Renske      Ladwig   RLADWIG  650.121.1234  14-JUL-03   \n",
              "47          138    Stephen      Stiles   SSTILES  650.121.2034  26-OCT-05   \n",
              "48          139       John         Seo      JSEO  650.121.2019  12-FEB-06   \n",
              "49          140     Joshua       Patel    JPATEL  650.121.1834  06-APR-06   \n",
              "\n",
              "      JOB_ID  SALARY COMMISSION_PCT MANAGER_ID  DEPARTMENT_ID  \n",
              "45  ST_CLERK    2200             -         122             50  \n",
              "46  ST_CLERK    3600             -         123             50  \n",
              "47  ST_CLERK    3200             -         123             50  \n",
              "48  ST_CLERK    2700             -         123             50  \n",
              "49  ST_CLERK    2500             -         123             50  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8f613f17-23c6-4621-ab91-4d7f00459d3e\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>EMPLOYEE_ID</th>\n",
              "      <th>FIRST_NAME</th>\n",
              "      <th>LAST_NAME</th>\n",
              "      <th>EMAIL</th>\n",
              "      <th>PHONE_NUMBER</th>\n",
              "      <th>HIRE_DATE</th>\n",
              "      <th>JOB_ID</th>\n",
              "      <th>SALARY</th>\n",
              "      <th>COMMISSION_PCT</th>\n",
              "      <th>MANAGER_ID</th>\n",
              "      <th>DEPARTMENT_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>136</td>\n",
              "      <td>Hazel</td>\n",
              "      <td>Philtanker</td>\n",
              "      <td>HPHILTAN</td>\n",
              "      <td>650.127.1634</td>\n",
              "      <td>06-FEB-08</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2200</td>\n",
              "      <td>-</td>\n",
              "      <td>122</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>137</td>\n",
              "      <td>Renske</td>\n",
              "      <td>Ladwig</td>\n",
              "      <td>RLADWIG</td>\n",
              "      <td>650.121.1234</td>\n",
              "      <td>14-JUL-03</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>3600</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>138</td>\n",
              "      <td>Stephen</td>\n",
              "      <td>Stiles</td>\n",
              "      <td>SSTILES</td>\n",
              "      <td>650.121.2034</td>\n",
              "      <td>26-OCT-05</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>3200</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>139</td>\n",
              "      <td>John</td>\n",
              "      <td>Seo</td>\n",
              "      <td>JSEO</td>\n",
              "      <td>650.121.2019</td>\n",
              "      <td>12-FEB-06</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2700</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>140</td>\n",
              "      <td>Joshua</td>\n",
              "      <td>Patel</td>\n",
              "      <td>JPATEL</td>\n",
              "      <td>650.121.1834</td>\n",
              "      <td>06-APR-06</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2500</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8f613f17-23c6-4621-ab91-4d7f00459d3e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-8f613f17-23c6-4621-ab91-4d7f00459d3e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-8f613f17-23c6-4621-ab91-4d7f00459d3e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-ddc4fe96-5320-490c-b8f0-3072cc33b77b\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ddc4fe96-5320-490c-b8f0-3072cc33b77b')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-ddc4fe96-5320-490c-b8f0-3072cc33b77b button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ],
      "source": [
        "employees.tail()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "anbHD6-Dg6_9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 383
        },
        "outputId": "9147c843-114e-422b-c222-d2aca928d394"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    EMPLOYEE_ID FIRST_NAME   LAST_NAME     EMAIL  PHONE_NUMBER  HIRE_DATE  \\\n",
              "40          131      James      Marlow   JAMRLOW  650.124.7234  16-FEB-05   \n",
              "41          132         TJ       Olson   TJOLSON  650.124.8234  10-APR-07   \n",
              "42          133      Jason      Mallin   JMALLIN  650.127.1934  14-JUN-04   \n",
              "43          134    Michael      Rogers   MROGERS  650.127.1834  26-AUG-06   \n",
              "44          135         Ki         Gee      KGEE  650.127.1734  12-DEC-07   \n",
              "45          136      Hazel  Philtanker  HPHILTAN  650.127.1634  06-FEB-08   \n",
              "46          137     Renske      Ladwig   RLADWIG  650.121.1234  14-JUL-03   \n",
              "47          138    Stephen      Stiles   SSTILES  650.121.2034  26-OCT-05   \n",
              "48          139       John         Seo      JSEO  650.121.2019  12-FEB-06   \n",
              "49          140     Joshua       Patel    JPATEL  650.121.1834  06-APR-06   \n",
              "\n",
              "      JOB_ID  SALARY COMMISSION_PCT MANAGER_ID  DEPARTMENT_ID  \n",
              "40  ST_CLERK    2500             -         121             50  \n",
              "41  ST_CLERK    2100             -         121             50  \n",
              "42  ST_CLERK    3300             -         122             50  \n",
              "43  ST_CLERK    2900             -         122             50  \n",
              "44  ST_CLERK    2400             -         122             50  \n",
              "45  ST_CLERK    2200             -         122             50  \n",
              "46  ST_CLERK    3600             -         123             50  \n",
              "47  ST_CLERK    3200             -         123             50  \n",
              "48  ST_CLERK    2700             -         123             50  \n",
              "49  ST_CLERK    2500             -         123             50  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1af733b8-0a89-49d4-8bc5-37a43117e478\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>EMPLOYEE_ID</th>\n",
              "      <th>FIRST_NAME</th>\n",
              "      <th>LAST_NAME</th>\n",
              "      <th>EMAIL</th>\n",
              "      <th>PHONE_NUMBER</th>\n",
              "      <th>HIRE_DATE</th>\n",
              "      <th>JOB_ID</th>\n",
              "      <th>SALARY</th>\n",
              "      <th>COMMISSION_PCT</th>\n",
              "      <th>MANAGER_ID</th>\n",
              "      <th>DEPARTMENT_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>131</td>\n",
              "      <td>James</td>\n",
              "      <td>Marlow</td>\n",
              "      <td>JAMRLOW</td>\n",
              "      <td>650.124.7234</td>\n",
              "      <td>16-FEB-05</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2500</td>\n",
              "      <td>-</td>\n",
              "      <td>121</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>132</td>\n",
              "      <td>TJ</td>\n",
              "      <td>Olson</td>\n",
              "      <td>TJOLSON</td>\n",
              "      <td>650.124.8234</td>\n",
              "      <td>10-APR-07</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2100</td>\n",
              "      <td>-</td>\n",
              "      <td>121</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>133</td>\n",
              "      <td>Jason</td>\n",
              "      <td>Mallin</td>\n",
              "      <td>JMALLIN</td>\n",
              "      <td>650.127.1934</td>\n",
              "      <td>14-JUN-04</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>3300</td>\n",
              "      <td>-</td>\n",
              "      <td>122</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>134</td>\n",
              "      <td>Michael</td>\n",
              "      <td>Rogers</td>\n",
              "      <td>MROGERS</td>\n",
              "      <td>650.127.1834</td>\n",
              "      <td>26-AUG-06</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2900</td>\n",
              "      <td>-</td>\n",
              "      <td>122</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>135</td>\n",
              "      <td>Ki</td>\n",
              "      <td>Gee</td>\n",
              "      <td>KGEE</td>\n",
              "      <td>650.127.1734</td>\n",
              "      <td>12-DEC-07</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2400</td>\n",
              "      <td>-</td>\n",
              "      <td>122</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>136</td>\n",
              "      <td>Hazel</td>\n",
              "      <td>Philtanker</td>\n",
              "      <td>HPHILTAN</td>\n",
              "      <td>650.127.1634</td>\n",
              "      <td>06-FEB-08</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2200</td>\n",
              "      <td>-</td>\n",
              "      <td>122</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>137</td>\n",
              "      <td>Renske</td>\n",
              "      <td>Ladwig</td>\n",
              "      <td>RLADWIG</td>\n",
              "      <td>650.121.1234</td>\n",
              "      <td>14-JUL-03</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>3600</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>138</td>\n",
              "      <td>Stephen</td>\n",
              "      <td>Stiles</td>\n",
              "      <td>SSTILES</td>\n",
              "      <td>650.121.2034</td>\n",
              "      <td>26-OCT-05</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>3200</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>139</td>\n",
              "      <td>John</td>\n",
              "      <td>Seo</td>\n",
              "      <td>JSEO</td>\n",
              "      <td>650.121.2019</td>\n",
              "      <td>12-FEB-06</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2700</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>140</td>\n",
              "      <td>Joshua</td>\n",
              "      <td>Patel</td>\n",
              "      <td>JPATEL</td>\n",
              "      <td>650.121.1834</td>\n",
              "      <td>06-APR-06</td>\n",
              "      <td>ST_CLERK</td>\n",
              "      <td>2500</td>\n",
              "      <td>-</td>\n",
              "      <td>123</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1af733b8-0a89-49d4-8bc5-37a43117e478')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1af733b8-0a89-49d4-8bc5-37a43117e478 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1af733b8-0a89-49d4-8bc5-37a43117e478');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-49ca49fa-1463-49f1-9bb6-13b5f452461d\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-49ca49fa-1463-49f1-9bb6-13b5f452461d')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-49ca49fa-1463-49f1-9bb6-13b5f452461d button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ],
      "source": [
        "employees.tail(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PWAJ1_zZhZX6"
      },
      "source": [
        "## Cómo guardar los datos en otro formato\n",
        "\n",
        "El *DataFrame* se puede guardar en varios formatos como hoja de cálculo o JSON por ejemplo."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "mGsUtbQGg-jN"
      },
      "outputs": [],
      "source": [
        "employees.to_excel(\"sample_data/employees.xlsx\")\n",
        "employees.to_json(\"sample_data/employees.json\")"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "11q20fG8i9U_"
      },
      "source": [
        "## Información sobre los tipos de datos\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "XJxFeUAGiImQ",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "f2569d52-3e62-41a2-f5ee-af438aef7c2b"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 50 entries, 0 to 49\n",
            "Data columns (total 11 columns):\n",
            " #   Column          Non-Null Count  Dtype \n",
            "---  ------          --------------  ----- \n",
            " 0   EMPLOYEE_ID     50 non-null     int64 \n",
            " 1   FIRST_NAME      50 non-null     object\n",
            " 2   LAST_NAME       50 non-null     object\n",
            " 3   EMAIL           50 non-null     object\n",
            " 4   PHONE_NUMBER    50 non-null     object\n",
            " 5   HIRE_DATE       50 non-null     object\n",
            " 6   JOB_ID          50 non-null     object\n",
            " 7   SALARY          50 non-null     int64 \n",
            " 8   COMMISSION_PCT  50 non-null     object\n",
            " 9   MANAGER_ID      50 non-null     object\n",
            " 10  DEPARTMENT_ID   50 non-null     int64 \n",
            "dtypes: int64(3), object(8)\n",
            "memory usage: 4.4+ KB\n"
          ]
        }
      ],
      "source": [
        "employees.info()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "boJ_TgMQjsdx"
      },
      "source": [
        "## Selección de subconjuntos de datos\n",
        "\n",
        "Vamos a utilizar un dataset de Kaggle sobre la calidad del café:\n",
        "https://www.kaggle.com/datasets/volpatto/coffee-quality-database-from-cqi"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "CfYVz78xpRrn"
      },
      "outputs": [],
      "source": [
        "coffe_df = pd.read_csv(\"/content/merged_data_cleaned.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "cKIgSaNXprbU",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 551
        },
        "outputId": "c9c115d7-76dd-4ffc-a9bd-1027ca363717"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Unnamed: 0  Species                     Owner Country.of.Origin  \\\n",
              "0           0  Arabica                 metad plc          Ethiopia   \n",
              "1           1  Arabica                 metad plc          Ethiopia   \n",
              "2           2  Arabica  grounds for health admin         Guatemala   \n",
              "3           3  Arabica       yidnekachew dabessa          Ethiopia   \n",
              "4           4  Arabica                 metad plc          Ethiopia   \n",
              "\n",
              "                                  Farm.Name Lot.Number       Mill ICO.Number  \\\n",
              "0                                 metad plc        NaN  metad plc  2014/2015   \n",
              "1                                 metad plc        NaN  metad plc  2014/2015   \n",
              "2  san marcos barrancas \"san cristobal cuch        NaN        NaN        NaN   \n",
              "3     yidnekachew dabessa coffee plantation        NaN    wolensu        NaN   \n",
              "4                                 metad plc        NaN  metad plc  2014/2015   \n",
              "\n",
              "                                 Company       Altitude  ...  Color  \\\n",
              "0      metad agricultural developmet plc      1950-2200  ...  Green   \n",
              "1      metad agricultural developmet plc      1950-2200  ...  Green   \n",
              "2                                    NaN  1600 - 1800 m  ...    NaN   \n",
              "3  yidnekachew debessa coffee plantation      1800-2200  ...  Green   \n",
              "4      metad agricultural developmet plc      1950-2200  ...  Green   \n",
              "\n",
              "  Category.Two.Defects        Expiration                  Certification.Body  \\\n",
              "0                    0   April 3rd, 2016  METAD Agricultural Development plc   \n",
              "1                    1   April 3rd, 2016  METAD Agricultural Development plc   \n",
              "2                    0    May 31st, 2011        Specialty Coffee Association   \n",
              "3                    2  March 25th, 2016  METAD Agricultural Development plc   \n",
              "4                    2   April 3rd, 2016  METAD Agricultural Development plc   \n",
              "\n",
              "                      Certification.Address  \\\n",
              "0  309fcf77415a3661ae83e027f7e5f05dad786e44   \n",
              "1  309fcf77415a3661ae83e027f7e5f05dad786e44   \n",
              "2  36d0d00a3724338ba7937c52a378d085f2172daa   \n",
              "3  309fcf77415a3661ae83e027f7e5f05dad786e44   \n",
              "4  309fcf77415a3661ae83e027f7e5f05dad786e44   \n",
              "\n",
              "                      Certification.Contact unit_of_measurement  \\\n",
              "0  19fef5a731de2db57d16da10287413f5f99bc2dd                   m   \n",
              "1  19fef5a731de2db57d16da10287413f5f99bc2dd                   m   \n",
              "2  0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660                   m   \n",
              "3  19fef5a731de2db57d16da10287413f5f99bc2dd                   m   \n",
              "4  19fef5a731de2db57d16da10287413f5f99bc2dd                   m   \n",
              "\n",
              "  altitude_low_meters altitude_high_meters altitude_mean_meters  \n",
              "0              1950.0               2200.0               2075.0  \n",
              "1              1950.0               2200.0               2075.0  \n",
              "2              1600.0               1800.0               1700.0  \n",
              "3              1800.0               2200.0               2000.0  \n",
              "4              1950.0               2200.0               2075.0  \n",
              "\n",
              "[5 rows x 44 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1629962f-6cc9-405c-b8bd-51ec709f4991\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Species</th>\n",
              "      <th>Owner</th>\n",
              "      <th>Country.of.Origin</th>\n",
              "      <th>Farm.Name</th>\n",
              "      <th>Lot.Number</th>\n",
              "      <th>Mill</th>\n",
              "      <th>ICO.Number</th>\n",
              "      <th>Company</th>\n",
              "      <th>Altitude</th>\n",
              "      <th>...</th>\n",
              "      <th>Color</th>\n",
              "      <th>Category.Two.Defects</th>\n",
              "      <th>Expiration</th>\n",
              "      <th>Certification.Body</th>\n",
              "      <th>Certification.Address</th>\n",
              "      <th>Certification.Contact</th>\n",
              "      <th>unit_of_measurement</th>\n",
              "      <th>altitude_low_meters</th>\n",
              "      <th>altitude_high_meters</th>\n",
              "      <th>altitude_mean_meters</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>Arabica</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>NaN</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>2014/2015</td>\n",
              "      <td>metad agricultural developmet plc</td>\n",
              "      <td>1950-2200</td>\n",
              "      <td>...</td>\n",
              "      <td>Green</td>\n",
              "      <td>0</td>\n",
              "      <td>April 3rd, 2016</td>\n",
              "      <td>METAD Agricultural Development plc</td>\n",
              "      <td>309fcf77415a3661ae83e027f7e5f05dad786e44</td>\n",
              "      <td>19fef5a731de2db57d16da10287413f5f99bc2dd</td>\n",
              "      <td>m</td>\n",
              "      <td>1950.0</td>\n",
              "      <td>2200.0</td>\n",
              "      <td>2075.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>Arabica</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>NaN</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>2014/2015</td>\n",
              "      <td>metad agricultural developmet plc</td>\n",
              "      <td>1950-2200</td>\n",
              "      <td>...</td>\n",
              "      <td>Green</td>\n",
              "      <td>1</td>\n",
              "      <td>April 3rd, 2016</td>\n",
              "      <td>METAD Agricultural Development plc</td>\n",
              "      <td>309fcf77415a3661ae83e027f7e5f05dad786e44</td>\n",
              "      <td>19fef5a731de2db57d16da10287413f5f99bc2dd</td>\n",
              "      <td>m</td>\n",
              "      <td>1950.0</td>\n",
              "      <td>2200.0</td>\n",
              "      <td>2075.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>Arabica</td>\n",
              "      <td>grounds for health admin</td>\n",
              "      <td>Guatemala</td>\n",
              "      <td>san marcos barrancas \"san cristobal cuch</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1600 - 1800 m</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>May 31st, 2011</td>\n",
              "      <td>Specialty Coffee Association</td>\n",
              "      <td>36d0d00a3724338ba7937c52a378d085f2172daa</td>\n",
              "      <td>0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660</td>\n",
              "      <td>m</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>1700.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>Arabica</td>\n",
              "      <td>yidnekachew dabessa</td>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>yidnekachew dabessa coffee plantation</td>\n",
              "      <td>NaN</td>\n",
              "      <td>wolensu</td>\n",
              "      <td>NaN</td>\n",
              "      <td>yidnekachew debessa coffee plantation</td>\n",
              "      <td>1800-2200</td>\n",
              "      <td>...</td>\n",
              "      <td>Green</td>\n",
              "      <td>2</td>\n",
              "      <td>March 25th, 2016</td>\n",
              "      <td>METAD Agricultural Development plc</td>\n",
              "      <td>309fcf77415a3661ae83e027f7e5f05dad786e44</td>\n",
              "      <td>19fef5a731de2db57d16da10287413f5f99bc2dd</td>\n",
              "      <td>m</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>2200.0</td>\n",
              "      <td>2000.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Arabica</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>NaN</td>\n",
              "      <td>metad plc</td>\n",
              "      <td>2014/2015</td>\n",
              "      <td>metad agricultural developmet plc</td>\n",
              "      <td>1950-2200</td>\n",
              "      <td>...</td>\n",
              "      <td>Green</td>\n",
              "      <td>2</td>\n",
              "      <td>April 3rd, 2016</td>\n",
              "      <td>METAD Agricultural Development plc</td>\n",
              "      <td>309fcf77415a3661ae83e027f7e5f05dad786e44</td>\n",
              "      <td>19fef5a731de2db57d16da10287413f5f99bc2dd</td>\n",
              "      <td>m</td>\n",
              "      <td>1950.0</td>\n",
              "      <td>2200.0</td>\n",
              "      <td>2075.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 44 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1629962f-6cc9-405c-b8bd-51ec709f4991')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1629962f-6cc9-405c-b8bd-51ec709f4991 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1629962f-6cc9-405c-b8bd-51ec709f4991');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-4627e604-6222-46cd-a5c3-83dd05cf313d\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4627e604-6222-46cd-a5c3-83dd05cf313d')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-4627e604-6222-46cd-a5c3-83dd05cf313d button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ],
      "source": [
        "coffe_df.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "2qGo6lIlqIb_",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "8aa7b8ee-da7d-40a4-fa06-53327c8e0c37"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 1339 entries, 0 to 1338\n",
            "Data columns (total 44 columns):\n",
            " #   Column                 Non-Null Count  Dtype  \n",
            "---  ------                 --------------  -----  \n",
            " 0   Unnamed: 0             1339 non-null   int64  \n",
            " 1   Species                1339 non-null   object \n",
            " 2   Owner                  1332 non-null   object \n",
            " 3   Country.of.Origin      1338 non-null   object \n",
            " 4   Farm.Name              980 non-null    object \n",
            " 5   Lot.Number             276 non-null    object \n",
            " 6   Mill                   1021 non-null   object \n",
            " 7   ICO.Number             1182 non-null   object \n",
            " 8   Company                1130 non-null   object \n",
            " 9   Altitude               1113 non-null   object \n",
            " 10  Region                 1280 non-null   object \n",
            " 11  Producer               1107 non-null   object \n",
            " 12  Number.of.Bags         1339 non-null   int64  \n",
            " 13  Bag.Weight             1339 non-null   object \n",
            " 14  In.Country.Partner     1339 non-null   object \n",
            " 15  Harvest.Year           1292 non-null   object \n",
            " 16  Grading.Date           1339 non-null   object \n",
            " 17  Owner.1                1332 non-null   object \n",
            " 18  Variety                1113 non-null   object \n",
            " 19  Processing.Method      1169 non-null   object \n",
            " 20  Aroma                  1339 non-null   float64\n",
            " 21  Flavor                 1339 non-null   float64\n",
            " 22  Aftertaste             1339 non-null   float64\n",
            " 23  Acidity                1339 non-null   float64\n",
            " 24  Body                   1339 non-null   float64\n",
            " 25  Balance                1339 non-null   float64\n",
            " 26  Uniformity             1339 non-null   float64\n",
            " 27  Clean.Cup              1339 non-null   float64\n",
            " 28  Sweetness              1339 non-null   float64\n",
            " 29  Cupper.Points          1339 non-null   float64\n",
            " 30  Total.Cup.Points       1339 non-null   float64\n",
            " 31  Moisture               1339 non-null   float64\n",
            " 32  Category.One.Defects   1339 non-null   int64  \n",
            " 33  Quakers                1338 non-null   float64\n",
            " 34  Color                  1121 non-null   object \n",
            " 35  Category.Two.Defects   1339 non-null   int64  \n",
            " 36  Expiration             1339 non-null   object \n",
            " 37  Certification.Body     1339 non-null   object \n",
            " 38  Certification.Address  1339 non-null   object \n",
            " 39  Certification.Contact  1339 non-null   object \n",
            " 40  unit_of_measurement    1339 non-null   object \n",
            " 41  altitude_low_meters    1109 non-null   float64\n",
            " 42  altitude_high_meters   1109 non-null   float64\n",
            " 43  altitude_mean_meters   1109 non-null   float64\n",
            "dtypes: float64(16), int64(4), object(24)\n",
            "memory usage: 460.4+ KB\n"
          ]
        }
      ],
      "source": [
        "coffe_df.info()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hkvJm2znjsTl"
      },
      "source": [
        "Vamos a extraer un subconjunto de los datos que contenga la siguiente información: Country.of.Origin, Region, Variety, Aroma, Flavor, Body, Sweetness, Total.Cup.Points."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "VKtns7XirbSz",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ffec4377-d71d-4dba-98b2-71a6375b2043"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "     Country.of.Origin                         Region  Variety  Aroma  Flavor  \\\n",
            "0             Ethiopia                   guji-hambela      NaN   8.67    8.83   \n",
            "1             Ethiopia                   guji-hambela    Other   8.75    8.67   \n",
            "2            Guatemala                            NaN  Bourbon   8.42    8.50   \n",
            "3             Ethiopia                         oromia      NaN   8.17    8.58   \n",
            "4             Ethiopia                   guji-hambela    Other   8.25    8.50   \n",
            "...                ...                            ...      ...    ...     ...   \n",
            "1334           Ecuador               san juan, playas      NaN   7.75    7.58   \n",
            "1335           Ecuador               san juan, playas      NaN   7.50    7.67   \n",
            "1336     United States  kwanza norte province, angola      NaN   7.33    7.33   \n",
            "1337             India                            NaN      NaN   7.42    6.83   \n",
            "1338           Vietnam                            NaN      NaN   6.75    6.67   \n",
            "\n",
            "      Body  Sweetness  Total.Cup.Points  \n",
            "0     8.50      10.00             90.58  \n",
            "1     8.42      10.00             89.92  \n",
            "2     8.33      10.00             89.75  \n",
            "3     8.50      10.00             89.00  \n",
            "4     8.42      10.00             88.83  \n",
            "...    ...        ...               ...  \n",
            "1334  5.08       7.75             78.75  \n",
            "1335  5.17       8.42             78.08  \n",
            "1336  7.50       7.42             77.17  \n",
            "1337  7.25       7.08             75.08  \n",
            "1338  6.92       6.67             73.75  \n",
            "\n",
            "[1339 rows x 8 columns]\n"
          ]
        }
      ],
      "source": [
        "coffe_subset = coffe_df[[\"Country.of.Origin\", \"Region\", \"Variety\", \"Aroma\", \"Flavor\", \"Body\", \"Sweetness\", \"Total.Cup.Points\"]]\n",
        "\n",
        "print(coffe_subset)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Mld8pBlmr55I",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "36ac1c52-d503-44d6-f9da-25b6733e7240"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     Country.of.Origin                         Region  Variety  Aroma  Flavor  \\\n",
              "0             Ethiopia                   guji-hambela      NaN   8.67    8.83   \n",
              "1             Ethiopia                   guji-hambela    Other   8.75    8.67   \n",
              "2            Guatemala                            NaN  Bourbon   8.42    8.50   \n",
              "3             Ethiopia                         oromia      NaN   8.17    8.58   \n",
              "4             Ethiopia                   guji-hambela    Other   8.25    8.50   \n",
              "...                ...                            ...      ...    ...     ...   \n",
              "1334           Ecuador               san juan, playas      NaN   7.75    7.58   \n",
              "1335           Ecuador               san juan, playas      NaN   7.50    7.67   \n",
              "1336     United States  kwanza norte province, angola      NaN   7.33    7.33   \n",
              "1337             India                            NaN      NaN   7.42    6.83   \n",
              "1338           Vietnam                            NaN      NaN   6.75    6.67   \n",
              "\n",
              "      Body  Sweetness  Total.Cup.Points  \n",
              "0     8.50      10.00             90.58  \n",
              "1     8.42      10.00             89.92  \n",
              "2     8.33      10.00             89.75  \n",
              "3     8.50      10.00             89.00  \n",
              "4     8.42      10.00             88.83  \n",
              "...    ...        ...               ...  \n",
              "1334  5.08       7.75             78.75  \n",
              "1335  5.17       8.42             78.08  \n",
              "1336  7.50       7.42             77.17  \n",
              "1337  7.25       7.08             75.08  \n",
              "1338  6.92       6.67             73.75  \n",
              "\n",
              "[1339 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2166706e-9e78-4866-b117-2bf58109df68\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country.of.Origin</th>\n",
              "      <th>Region</th>\n",
              "      <th>Variety</th>\n",
              "      <th>Aroma</th>\n",
              "      <th>Flavor</th>\n",
              "      <th>Body</th>\n",
              "      <th>Sweetness</th>\n",
              "      <th>Total.Cup.Points</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>guji-hambela</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8.67</td>\n",
              "      <td>8.83</td>\n",
              "      <td>8.50</td>\n",
              "      <td>10.00</td>\n",
              "      <td>90.58</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>guji-hambela</td>\n",
              "      <td>Other</td>\n",
              "      <td>8.75</td>\n",
              "      <td>8.67</td>\n",
              "      <td>8.42</td>\n",
              "      <td>10.00</td>\n",
              "      <td>89.92</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Guatemala</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Bourbon</td>\n",
              "      <td>8.42</td>\n",
              "      <td>8.50</td>\n",
              "      <td>8.33</td>\n",
              "      <td>10.00</td>\n",
              "      <td>89.75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>oromia</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8.17</td>\n",
              "      <td>8.58</td>\n",
              "      <td>8.50</td>\n",
              "      <td>10.00</td>\n",
              "      <td>89.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Ethiopia</td>\n",
              "      <td>guji-hambela</td>\n",
              "      <td>Other</td>\n",
              "      <td>8.25</td>\n",
              "      <td>8.50</td>\n",
              "      <td>8.42</td>\n",
              "      <td>10.00</td>\n",
              "      <td>88.83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1334</th>\n",
              "      <td>Ecuador</td>\n",
              "      <td>san juan, playas</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.75</td>\n",
              "      <td>7.58</td>\n",
              "      <td>5.08</td>\n",
              "      <td>7.75</td>\n",
              "      <td>78.75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1335</th>\n",
              "      <td>Ecuador</td>\n",
              "      <td>san juan, playas</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.50</td>\n",
              "      <td>7.67</td>\n",
              "      <td>5.17</td>\n",
              "      <td>8.42</td>\n",
              "      <td>78.08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1336</th>\n",
              "      <td>United States</td>\n",
              "      <td>kwanza norte province, angola</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.33</td>\n",
              "      <td>7.33</td>\n",
              "      <td>7.50</td>\n",
              "      <td>7.42</td>\n",
              "      <td>77.17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1337</th>\n",
              "      <td>India</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.42</td>\n",
              "      <td>6.83</td>\n",
              "      <td>7.25</td>\n",
              "      <td>7.08</td>\n",
              "      <td>75.08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1338</th>\n",
              "      <td>Vietnam</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.75</td>\n",
              "      <td>6.67</td>\n",
              "      <td>6.92</td>\n",
              "      <td>6.67</td>\n",
              "      <td>73.75</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1339 rows × 8 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2166706e-9e78-4866-b117-2bf58109df68')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-2166706e-9e78-4866-b117-2bf58109df68 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-2166706e-9e78-4866-b117-2bf58109df68');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-bf90d3b7-1d5c-4af7-9f3b-19ee002ce519\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bf90d3b7-1d5c-4af7-9f3b-19ee002ce519')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-bf90d3b7-1d5c-4af7-9f3b-19ee002ce519 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ],
      "source": [
        "coffe_subset"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0qQnS3F0jsHe"
      },
      "source": [
        "# Filtrado de datos\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "zLyallG8sUF3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "outputId": "b2fdc653-28cc-4edf-e455-b5adeb66e04f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     Country.of.Origin                       Region Variety  Aroma  Flavor  \\\n",
              "286            Ecuador  province of manabi, ecuador     NaN   7.50    7.67   \n",
              "1334           Ecuador             san juan, playas     NaN   7.75    7.58   \n",
              "1335           Ecuador             san juan, playas     NaN   7.50    7.67   \n",
              "\n",
              "      Body  Sweetness  Total.Cup.Points  \n",
              "286   7.83      10.00             83.83  \n",
              "1334  5.08       7.75             78.75  \n",
              "1335  5.17       8.42             78.08  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-217c7704-a6fb-45c1-a2ae-f4e1b2b3d674\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country.of.Origin</th>\n",
              "      <th>Region</th>\n",
              "      <th>Variety</th>\n",
              "      <th>Aroma</th>\n",
              "      <th>Flavor</th>\n",
              "      <th>Body</th>\n",
              "      <th>Sweetness</th>\n",
              "      <th>Total.Cup.Points</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>286</th>\n",
              "      <td>Ecuador</td>\n",
              "      <td>province of manabi, ecuador</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.50</td>\n",
              "      <td>7.67</td>\n",
              "      <td>7.83</td>\n",
              "      <td>10.00</td>\n",
              "      <td>83.83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1334</th>\n",
              "      <td>Ecuador</td>\n",
              "      <td>san juan, playas</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.75</td>\n",
              "      <td>7.58</td>\n",
              "      <td>5.08</td>\n",
              "      <td>7.75</td>\n",
              "      <td>78.75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1335</th>\n",
              "      <td>Ecuador</td>\n",
              "      <td>san juan, playas</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.50</td>\n",
              "      <td>7.67</td>\n",
              "      <td>5.17</td>\n",
              "      <td>8.42</td>\n",
              "      <td>78.08</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-217c7704-a6fb-45c1-a2ae-f4e1b2b3d674')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-217c7704-a6fb-45c1-a2ae-f4e1b2b3d674 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-217c7704-a6fb-45c1-a2ae-f4e1b2b3d674');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-4675551d-47e8-4552-945c-1447f7ca97fa\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4675551d-47e8-4552-945c-1447f7ca97fa')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-4675551d-47e8-4552-945c-1447f7ca97fa button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ],
      "source": [
        "# Todos los cafés de Ecuador\n",
        "\n",
        "coffe_subset[coffe_subset['Country.of.Origin'] == 'Ecuador']\n",
        "\n",
        "# Ojo, lo que sale con\n",
        "# coffe_subset['Country.of.Origin'] == 'Ecuador'\n",
        "# es diferente."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "gqEUANWMdLu7"
      },
      "outputs": [],
      "source": [
        "# Los cafés con más de 85 puntos\n",
        "\n",
        "coffe_subset[coffe_subset['Total.Cup.Points'] > 85]\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "aCcOBiEtefM4"
      },
      "outputs": [],
      "source": [
        "# Todos los cafés de Colombia, Guatemala o Mexico\n",
        "\n",
        "coffe_subset[coffe_subset['Country.of.Origin'].isin(['Colombia', 'Guatemala', 'Mexico'])]\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "pjIvm79bfJgJ"
      },
      "outputs": [],
      "source": [
        "# Todos los cafés cuya región es conocida\n",
        "\n",
        "coffe_subset[coffe_subset['Region'].notna()]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "WWZgeAYHfJt7"
      },
      "outputs": [],
      "source": [
        "# Variedad y aroma de los cafés con más aroma (con una puntuación de aroma de más de 8 puntos)\n",
        "\n",
        "coffe_subset.loc[coffe_subset['Aroma'] > 8, [\"Variety\", \"Aroma\"]]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "fNzV_xppfJ1o"
      },
      "outputs": [],
      "source": [
        "# Igual que la anterior sin tener en cuenta cuando no hay variedad o cuando es \"Other\".\n",
        "\n",
        "coffe_subset_clean = coffe_subset[coffe_subset['Variety'].notna()]\n",
        "coffe_subset_clean = coffe_subset_clean[coffe_subset_clean['Variety'] != 'Other']\n",
        "coffe_subset_clean.loc[coffe_subset_clean['Aroma'] > 8, [\"Variety\", \"Aroma\"]]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "x8h0kAh8tXZO",
        "outputId": "a2d58bed-cade-40c7-ed6f-f5dd07077c23"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "array([nan, 'Other', 'Bourbon', 'Catimor', 'Ethiopian Yirgacheffe',\n",
              "       'Caturra', 'SL14', 'Sumatra', 'SL34', 'Hawaiian Kona',\n",
              "       'Yellow Bourbon', 'SL28', 'Gesha', 'Catuai', 'Pacamara', 'Typica',\n",
              "       'Sumatra Lintong', 'Mundo Novo', 'Java', 'Peaberry', 'Pacas',\n",
              "       'Mandheling', 'Ruiru 11', 'Arusha', 'Ethiopian Heirlooms',\n",
              "       'Moka Peaberry', 'Sulawesi', 'Blue Mountain', 'Marigojipe',\n",
              "       'Pache Comun'], dtype=object)"
            ]
          },
          "execution_count": 11,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Una lista con todas las variedades de café\n",
        "\n",
        "coffe_df.Variety.unique()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ALaG_TZtjrjS"
      },
      "source": [
        "## Datos estadísticos"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "NOkrVBbmfJ-3"
      },
      "outputs": [],
      "source": [
        "# Puntuación media de los cafés de Etiopía\n",
        "\n",
        "coffe_subset.loc[coffe_subset['Country.of.Origin'] == \"Ethiopia\", \"Total.Cup.Points\"].mean()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rjU_T0f3jr5M"
      },
      "source": [
        "Los datos estadísticos se pueden ver con `describe()` como vimos al principio."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "QRqUBdYUl1ox"
      },
      "outputs": [],
      "source": [
        "coffe_subset.describe()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "9Iwh_HCBjKOt"
      },
      "outputs": [],
      "source": [
        "# Media de dulzor (Sweetness) en función del pais\n",
        "\n",
        "coffe_subset[[\"Country.of.Origin\", \"Sweetness\"]].groupby(\"Country.of.Origin\").mean()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "9w7hCKFHm_ex"
      },
      "outputs": [],
      "source": [
        "# ¿Cuántos cafés se han contabilizado por cada pais?\n",
        "\n",
        "coffe_subset.groupby(\"Country.of.Origin\")[\"Country.of.Origin\"].count()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GSwVs80ZpUP8"
      },
      "source": [
        "## Ordenación"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-xjcqzB4oYAx"
      },
      "outputs": [],
      "source": [
        "coffe_df.sort_values(by=\"Country.of.Origin\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "sVF8BS4ApqQ6"
      },
      "outputs": [],
      "source": [
        "# Cafés ordenados por puntuación (de más a menos)\n",
        "\n",
        "coffe_subset.sort_values(by=\"Total.Cup.Points\", ascending=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "SEq9LUV5qb7K"
      },
      "outputs": [],
      "source": [
        "# Cafés ordenados por pais (por orden alfabético), región (por orden alfabético) y puntuación (de más a menos)\n",
        "\n",
        "coffe_subset.sort_values(by=[\"Country.of.Origin\", \"Region\", \"Total.Cup.Points\"], ascending=[True, True, False])"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}