Webscraping.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Webscraping.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyP+b7+rFO9yNmedf0f85akH",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ildacec/Python/blob/main/Webscraping.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "metadata": {
        "id": "0jFgQfH4A9BA"
      },
      "outputs": [],
      "source": [
        "from bs4 import BeautifulSoup\n",
        "import requests\n",
        "import pandas as pd\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "website = 'https://aig.gob.pa/viajes-y-viaticos/'\n",
        "result = requests.get(website)\n",
        "#\n",
        "#html = requests.get(website).content\n",
        "#df_list = pd.read_html(html)\n",
        "content = result.text\n"
      ],
      "metadata": {
        "id": "ojWhifLpBJCE"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "soup = BeautifulSoup(content,'lxml')\n",
        "#df = df_list[-1]\n",
        "print (soup)\n"
      ],
      "metadata": {
        "id": "YHUygDwmB1X8"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#box = soup.find(\"div\", class_ = 'bodywidth')\n",
        "#.get_text()\n",
        "#print (box.get_text())\n",
        "\n",
        "#box.find('table').get_text()\n",
        "\n",
        "table_data = soup.find('table', {'id': 'tablepress-1'}) #.get_text()\n",
        "table_data = soup.find('table', {'id': 'tableID'}) #.get_text()\n",
        "\n",
        "htmltable = soup.find('table', { 'class' : 'table table-striped' })\n",
        "\n",
        "def tableDataText(table):       \n",
        "    rows = []\n",
        "    trs = table.find_all('tr')\n",
        "    headerow = [td.get_text(strip=True) for td in trs[0].find_all('th')] # header row\n",
        "    if headerow: # if there is a header row include first\n",
        "        rows.append(headerow)\n",
        "        trs = trs[1:]\n",
        "    for tr in trs: # for every table row\n",
        "        rows.append([td.get_text(strip=True) for td in tr.find_all('td')]) # data row\n",
        "    return rows\n",
        "\n",
        "list_table = tableDataText(table_data)\n",
        "list_table[:2]\n",
        "\n",
        "#for table_data in soup.find_all('table ', {'id': 'tablepress-1'}):\n",
        "\n",
        "#print(table_data)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eypdVcN3GMTP",
        "outputId": "4da5e342-c13e-452e-f581-4cfb75e47c3f"
      },
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[['Funcionario',\n",
              "  'Cargo',\n",
              "  'Destino',\n",
              "  'Misión',\n",
              "  'Fecha Inicio',\n",
              "  'Fecha Fin',\n",
              "  'Total',\n",
              "  'CostoPasaje Aéreo',\n",
              "  'Viático',\n",
              "  'Observaciones',\n",
              "  'Informe de Misión'],\n",
              " ['Juan Ramón Anria',\n",
              "  'Dir. Ciberseguridad',\n",
              "  'Isrrael',\n",
              "  'Participar de Firma de Acuerdo de Colaboración en CIBERSEGURIDAD entre Panamá e Israel.',\n",
              "  '05/02/22',\n",
              "  '04/03/22',\n",
              "  '$5,949.00',\n",
              "  '$2,449.00',\n",
              "  '$3,500.00',\n",
              "  '',\n",
              "  'Ver']]"
            ]
          },
          "metadata": {},
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dftable = pd.DataFrame(list_table[1:], columns=list_table[0])\n",
        "dftable.head(131)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1192
        },
        "id": "jFVSUIRkTdTO",
        "outputId": "7ba6deec-c33d-437f-9f6b-6f5d62a955e3"
      },
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           Funcionario                                              Cargo  \\\n",
              "0     Juan Ramón Anria                                Dir. Ciberseguridad   \n",
              "1           Luis Oliva                              Administrador General   \n",
              "2        Yen Caballero  Coordinador de Planes y Programas             ...   \n",
              "3       Naiemeh Hijouj  Coordinador de Planes y Programas             ...   \n",
              "4        Yen Caballero                  Coordinador de Planes y Programas   \n",
              "5           Luis Oliva                              Administrador General   \n",
              "6     Juan Ramón Anria                                  Director Nacional   \n",
              "7       Luis Del Vasto                  Coordinador de Planes y Programas   \n",
              "8           Carlos Kan                  Coordinador de Planes y Programas   \n",
              "9       Banitza Lozano                                Relaciones Públicas   \n",
              "10      Janice Becerra                 Asesor Presidencia de La República   \n",
              "11         Yessika Yau                                        Yessika Yau   \n",
              "12          Luis Oliva                           Asesor Despacho Superior   \n",
              "13  Luis Carlos Stoute                          Sub-Administrador General   \n",
              "14    Juan Ramón Anria                                  Director Nacional   \n",
              "\n",
              "                                   Destino  \\\n",
              "0                                  Isrrael   \n",
              "1                                   España   \n",
              "2                                 Colombia   \n",
              "3                                 Colombia   \n",
              "4                                 Colombia   \n",
              "5                                 Colombia   \n",
              "6                     República Dominicana   \n",
              "7   Boston - Massachusetts, Estados Unidos   \n",
              "8   Boston - Massachusetts, Estados Unidos   \n",
              "9                Las Vegas, Estados Unidos   \n",
              "10               Las Vegas, Estados Unidos   \n",
              "11               Las Vegas, Estados Unidos   \n",
              "12               Las Vegas, Estados Unidos   \n",
              "13           Miami-Florida, Estados Unidos   \n",
              "14                                Alemania   \n",
              "\n",
              "                                               Misión            Fecha Inicio  \\\n",
              "0   Participar de Firma de Acuerdo de Colaboración...                05/02/22   \n",
              "1   Asistir a Programa Minsiterial de la GSMA MWC ...                25/02/22   \n",
              "2   Misión oficial para conocer los centros de for...         21 de noviembre   \n",
              "3   Misión oficial para asistir a la firma del MOU...            5 de octubre   \n",
              "4   Misión oficial para asistir a la firma del MOU...            5 de octubre   \n",
              "5   Misión oficial para asistir a la firma del MOU...            5 de octubre   \n",
              "6   Participación en conferencia sobre CiberSeguri...  19 de febrero  de 2020   \n",
              "7   Asistencia en Misión Oficial a la Primera Cumb...        19 de enero 2020   \n",
              "8   Asistencia en Misión Oficial a la Primera Cumb...        19 de enero 2020   \n",
              "9   Participar en el Cosumer Electronics Show (CES...               07-ene-20   \n",
              "10  Asesor de Presdencia de la República invitada ...        6 de enero  2020   \n",
              "11  Participar en el Cosumer Electronics Show (CES...         6 de enero 2020   \n",
              "12  Participar en el Cosumer Electronics Show (CES...         6 de enero 2020   \n",
              "13           Misión oficial Executive Briefing Center     2 de diciembre 2019   \n",
              "14  Participación en programa de estudios en Ciber...    30 de noviembre 2019   \n",
              "\n",
              "                Fecha Fin      Total CostoPasaje Aéreo    Viático  \\\n",
              "0                04/03/22  $5,949.00         $2,449.00  $3,500.00   \n",
              "1                03/03/22  $5,398.20         $1,798.20  $3,600.00   \n",
              "2         25 de noviembre  $1,734.00           $534.00  $1,200.00   \n",
              "3            7 de octubre  $1,298.00                 $          $   \n",
              "4            7 de octubre  $1,898.00         $1,298.00    $600.00   \n",
              "5            9 de octubre  $3,023.00         $1,423.00  $1,600.00   \n",
              "6   22 de febrero de 2020  $1,645.80           $445.80   $1200.00   \n",
              "7        24 de enero 2020  $3,222.55           $722.55  $2,500.00   \n",
              "8        24 de enero 2020  $3,222.55           $722.55  $2,500.00   \n",
              "9               11-ene-20  $3,253.45         $1,253.45  $2,000.00   \n",
              "10       10 de enero 2020  $3,595.45         $1,595.45  $2,000.00   \n",
              "11       10 de enero 2020  $3,595.45         $1,595.45  $2,000.00   \n",
              "12       10 de enero 2020  $3,253.45         $1,253.45      $2000   \n",
              "13    4 de diciembre 2019       $300                $0       $300   \n",
              "14   20 de diciembre 2019      $3000                $0      $3000   \n",
              "\n",
              "                                   Observaciones Informe de Misión  \n",
              "0                                                              Ver  \n",
              "1                                                              Ver  \n",
              "2                                                              Ver  \n",
              "3                                                              Ver  \n",
              "4                                                              Ver  \n",
              "5                                                              Ver  \n",
              "6                                                              Ver  \n",
              "7                                                              Ver  \n",
              "8                                                              Ver  \n",
              "9                                                              Ver  \n",
              "10                                                             Ver  \n",
              "11                                                             Ver  \n",
              "12                                                             Ver  \n",
              "13  Corresponde a vigencia expirada del año 2019               Ver  \n",
              "14  Corresponde a vigencia expirada del año 2019               Ver  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-398159fe-78d5-44b2-bfe0-43670be342ab\">\n",
              "    <div 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>Funcionario</th>\n",
              "      <th>Cargo</th>\n",
              "      <th>Destino</th>\n",
              "      <th>Misión</th>\n",
              "      <th>Fecha Inicio</th>\n",
              "      <th>Fecha Fin</th>\n",
              "      <th>Total</th>\n",
              "      <th>CostoPasaje Aéreo</th>\n",
              "      <th>Viático</th>\n",
              "      <th>Observaciones</th>\n",
              "      <th>Informe de Misión</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Juan Ramón Anria</td>\n",
              "      <td>Dir. Ciberseguridad</td>\n",
              "      <td>Isrrael</td>\n",
              "      <td>Participar de Firma de Acuerdo de Colaboración...</td>\n",
              "      <td>05/02/22</td>\n",
              "      <td>04/03/22</td>\n",
              "      <td>$5,949.00</td>\n",
              "      <td>$2,449.00</td>\n",
              "      <td>$3,500.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Luis Oliva</td>\n",
              "      <td>Administrador General</td>\n",
              "      <td>España</td>\n",
              "      <td>Asistir a Programa Minsiterial de la GSMA MWC ...</td>\n",
              "      <td>25/02/22</td>\n",
              "      <td>03/03/22</td>\n",
              "      <td>$5,398.20</td>\n",
              "      <td>$1,798.20</td>\n",
              "      <td>$3,600.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Yen Caballero</td>\n",
              "      <td>Coordinador de Planes y Programas             ...</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>Misión oficial para conocer los centros de for...</td>\n",
              "      <td>21 de noviembre</td>\n",
              "      <td>25 de noviembre</td>\n",
              "      <td>$1,734.00</td>\n",
              "      <td>$534.00</td>\n",
              "      <td>$1,200.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Naiemeh Hijouj</td>\n",
              "      <td>Coordinador de Planes y Programas             ...</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>Misión oficial para asistir a la firma del MOU...</td>\n",
              "      <td>5 de octubre</td>\n",
              "      <td>7 de octubre</td>\n",
              "      <td>$1,298.00</td>\n",
              "      <td>$</td>\n",
              "      <td>$</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Yen Caballero</td>\n",
              "      <td>Coordinador de Planes y Programas</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>Misión oficial para asistir a la firma del MOU...</td>\n",
              "      <td>5 de octubre</td>\n",
              "      <td>7 de octubre</td>\n",
              "      <td>$1,898.00</td>\n",
              "      <td>$1,298.00</td>\n",
              "      <td>$600.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Luis Oliva</td>\n",
              "      <td>Administrador General</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>Misión oficial para asistir a la firma del MOU...</td>\n",
              "      <td>5 de octubre</td>\n",
              "      <td>9 de octubre</td>\n",
              "      <td>$3,023.00</td>\n",
              "      <td>$1,423.00</td>\n",
              "      <td>$1,600.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Juan Ramón Anria</td>\n",
              "      <td>Director Nacional</td>\n",
              "      <td>República Dominicana</td>\n",
              "      <td>Participación en conferencia sobre CiberSeguri...</td>\n",
              "      <td>19 de febrero  de 2020</td>\n",
              "      <td>22 de febrero de 2020</td>\n",
              "      <td>$1,645.80</td>\n",
              "      <td>$445.80</td>\n",
              "      <td>$1200.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Luis Del Vasto</td>\n",
              "      <td>Coordinador de Planes y Programas</td>\n",
              "      <td>Boston - Massachusetts, Estados Unidos</td>\n",
              "      <td>Asistencia en Misión Oficial a la Primera Cumb...</td>\n",
              "      <td>19 de enero 2020</td>\n",
              "      <td>24 de enero 2020</td>\n",
              "      <td>$3,222.55</td>\n",
              "      <td>$722.55</td>\n",
              "      <td>$2,500.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Carlos Kan</td>\n",
              "      <td>Coordinador de Planes y Programas</td>\n",
              "      <td>Boston - Massachusetts, Estados Unidos</td>\n",
              "      <td>Asistencia en Misión Oficial a la Primera Cumb...</td>\n",
              "      <td>19 de enero 2020</td>\n",
              "      <td>24 de enero 2020</td>\n",
              "      <td>$3,222.55</td>\n",
              "      <td>$722.55</td>\n",
              "      <td>$2,500.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Banitza Lozano</td>\n",
              "      <td>Relaciones Públicas</td>\n",
              "      <td>Las Vegas, Estados Unidos</td>\n",
              "      <td>Participar en el Cosumer Electronics Show (CES...</td>\n",
              "      <td>07-ene-20</td>\n",
              "      <td>11-ene-20</td>\n",
              "      <td>$3,253.45</td>\n",
              "      <td>$1,253.45</td>\n",
              "      <td>$2,000.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Janice Becerra</td>\n",
              "      <td>Asesor Presidencia de La República</td>\n",
              "      <td>Las Vegas, Estados Unidos</td>\n",
              "      <td>Asesor de Presdencia de la República invitada ...</td>\n",
              "      <td>6 de enero  2020</td>\n",
              "      <td>10 de enero 2020</td>\n",
              "      <td>$3,595.45</td>\n",
              "      <td>$1,595.45</td>\n",
              "      <td>$2,000.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Yessika Yau</td>\n",
              "      <td>Yessika Yau</td>\n",
              "      <td>Las Vegas, Estados Unidos</td>\n",
              "      <td>Participar en el Cosumer Electronics Show (CES...</td>\n",
              "      <td>6 de enero 2020</td>\n",
              "      <td>10 de enero 2020</td>\n",
              "      <td>$3,595.45</td>\n",
              "      <td>$1,595.45</td>\n",
              "      <td>$2,000.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Luis Oliva</td>\n",
              "      <td>Asesor Despacho Superior</td>\n",
              "      <td>Las Vegas, Estados Unidos</td>\n",
              "      <td>Participar en el Cosumer Electronics Show (CES...</td>\n",
              "      <td>6 de enero 2020</td>\n",
              "      <td>10 de enero 2020</td>\n",
              "      <td>$3,253.45</td>\n",
              "      <td>$1,253.45</td>\n",
              "      <td>$2000</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Luis Carlos Stoute</td>\n",
              "      <td>Sub-Administrador General</td>\n",
              "      <td>Miami-Florida, Estados Unidos</td>\n",
              "      <td>Misión oficial Executive Briefing Center</td>\n",
              "      <td>2 de diciembre 2019</td>\n",
              "      <td>4 de diciembre 2019</td>\n",
              "      <td>$300</td>\n",
              "      <td>$0</td>\n",
              "      <td>$300</td>\n",
              "      <td>Corresponde a vigencia expirada del año 2019</td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Juan Ramón Anria</td>\n",
              "      <td>Director Nacional</td>\n",
              "      <td>Alemania</td>\n",
              "      <td>Participación en programa de estudios en Ciber...</td>\n",
              "      <td>30 de noviembre 2019</td>\n",
              "      <td>20 de diciembre 2019</td>\n",
              "      <td>$3000</td>\n",
              "      <td>$0</td>\n",
              "      <td>$3000</td>\n",
              "      <td>Corresponde a vigencia expirada del año 2019</td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-398159fe-78d5-44b2-bfe0-43670be342ab')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-398159fe-78d5-44b2-bfe0-43670be342ab 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-398159fe-78d5-44b2-bfe0-43670be342ab');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dftable.describe()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "ACwuULa2UE1w",
        "outputId": "9b64d964-0100-4277-d946-0cd45e42786c"
      },
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             Funcionario                              Cargo   Destino  \\\n",
              "count                 15                                 15        15   \n",
              "unique                10                                 11         8   \n",
              "top     Juan Ramón Anria  Coordinador de Planes y Programas  Colombia   \n",
              "freq                   3                                  3         4   \n",
              "\n",
              "                                                   Misión  Fecha Inicio  \\\n",
              "count                                                  15            15   \n",
              "unique                                                 11            11   \n",
              "top     Misión oficial para asistir a la firma del MOU...  5 de octubre   \n",
              "freq                                                    3             3   \n",
              "\n",
              "               Fecha Fin      Total CostoPasaje Aéreo    Viático  \\\n",
              "count                 15         15                15         15   \n",
              "unique                11         12                11         12   \n",
              "top     10 de enero 2020  $3,222.55           $722.55  $2,000.00   \n",
              "freq                   3          2                 2          3   \n",
              "\n",
              "       Observaciones Informe de Misión  \n",
              "count             15                15  \n",
              "unique             2                 1  \n",
              "top                                Ver  \n",
              "freq              13                15  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-264ae10f-7f28-4bf3-bc44-75cfea8a4ce5\">\n",
              "    <div 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>Funcionario</th>\n",
              "      <th>Cargo</th>\n",
              "      <th>Destino</th>\n",
              "      <th>Misión</th>\n",
              "      <th>Fecha Inicio</th>\n",
              "      <th>Fecha Fin</th>\n",
              "      <th>Total</th>\n",
              "      <th>CostoPasaje Aéreo</th>\n",
              "      <th>Viático</th>\n",
              "      <th>Observaciones</th>\n",
              "      <th>Informe de Misión</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>10</td>\n",
              "      <td>11</td>\n",
              "      <td>8</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>12</td>\n",
              "      <td>11</td>\n",
              "      <td>12</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>Juan Ramón Anria</td>\n",
              "      <td>Coordinador de Planes y Programas</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>Misión oficial para asistir a la firma del MOU...</td>\n",
              "      <td>5 de octubre</td>\n",
              "      <td>10 de enero 2020</td>\n",
              "      <td>$3,222.55</td>\n",
              "      <td>$722.55</td>\n",
              "      <td>$2,000.00</td>\n",
              "      <td></td>\n",
              "      <td>Ver</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>13</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-264ae10f-7f28-4bf3-bc44-75cfea8a4ce5')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-264ae10f-7f28-4bf3-bc44-75cfea8a4ce5 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-264ae10f-7f28-4bf3-bc44-75cfea8a4ce5');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 56
        }
      ]
    }
  ]
}