Arbol_familiar_costarricense.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/juanandres-montero/arbolfamiliar_CostaRica/blob/main/Arbol_familiar_costarricense.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 264
        },
        "id": "XGST0nIng4Kj",
        "outputId": "7bea86f1-c0e6-44af-9a58-24058be060c6"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: anvil-uplink in /usr/local/lib/python3.10/dist-packages (0.4.2)\n",
            "Collecting argparse (from anvil-uplink)\n",
            "  Using cached argparse-1.4.0-py2.py3-none-any.whl (23 kB)\n",
            "Requirement already satisfied: future in /usr/local/lib/python3.10/dist-packages (from anvil-uplink) (0.18.3)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.10/dist-packages (from anvil-uplink) (1.16.0)\n",
            "Requirement already satisfied: ws4py in /usr/local/lib/python3.10/dist-packages (from anvil-uplink) (0.5.1)\n",
            "Installing collected packages: argparse\n",
            "Successfully installed argparse-1.4.0\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "application/vnd.colab-display-data+json": {
              "pip_warning": {
                "packages": [
                  "argparse"
                ]
              },
              "id": "ac974677fc69455fb8215b1c26527a8e"
            }
          },
          "metadata": {}
        }
      ],
      "source": [
        "!pip install anvil-uplink"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Zo_flq6lg5we"
      },
      "outputs": [],
      "source": [
        "import anvil.server"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jdLWvxPfg6A9",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "98c68a2c-922b-41bc-b048-861df3f4af09"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Disconnecting from previous connection first...\n",
            "Connecting to wss://anvil.works/uplink\n",
            "Anvil websocket open\n",
            "Connected to \"Default Environment\" as SERVER\n"
          ]
        }
      ],
      "source": [
        "anvil.server.connect('server_GHJIFJU6KC7XUD3VSFAMU5X4-VWTPMBK7DBXDF2BQ')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "cellView": "form",
        "id": "qjWtLB2dOeDr",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "d97a44ff-ff5d-4182-d704-7af9e3b0c5c0"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Collecting selenium\n",
            "  Downloading selenium-4.18.1-py3-none-any.whl (10.0 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m10.0/10.0 MB\u001b[0m \u001b[31m13.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: urllib3[socks]<3,>=1.26 in /usr/local/lib/python3.10/dist-packages (from selenium) (2.0.7)\n",
            "Collecting trio~=0.17 (from selenium)\n",
            "  Downloading trio-0.24.0-py3-none-any.whl (460 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m460.2/460.2 kB\u001b[0m \u001b[31m33.6 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hCollecting trio-websocket~=0.9 (from selenium)\n",
            "  Downloading trio_websocket-0.11.1-py3-none-any.whl (17 kB)\n",
            "Requirement already satisfied: certifi>=2021.10.8 in /usr/local/lib/python3.10/dist-packages (from selenium) (2024.2.2)\n",
            "Requirement already satisfied: typing_extensions>=4.9.0 in /usr/local/lib/python3.10/dist-packages (from selenium) (4.10.0)\n",
            "Requirement already satisfied: attrs>=20.1.0 in /usr/local/lib/python3.10/dist-packages (from trio~=0.17->selenium) (23.2.0)\n",
            "Requirement already satisfied: sortedcontainers in /usr/local/lib/python3.10/dist-packages (from trio~=0.17->selenium) (2.4.0)\n",
            "Requirement already satisfied: idna in /usr/local/lib/python3.10/dist-packages (from trio~=0.17->selenium) (3.6)\n",
            "Collecting outcome (from trio~=0.17->selenium)\n",
            "  Downloading outcome-1.3.0.post0-py2.py3-none-any.whl (10 kB)\n",
            "Requirement already satisfied: sniffio>=1.3.0 in /usr/local/lib/python3.10/dist-packages (from trio~=0.17->selenium) (1.3.1)\n",
            "Requirement already satisfied: exceptiongroup in /usr/local/lib/python3.10/dist-packages (from trio~=0.17->selenium) (1.2.0)\n",
            "Collecting wsproto>=0.14 (from trio-websocket~=0.9->selenium)\n",
            "  Downloading wsproto-1.2.0-py3-none-any.whl (24 kB)\n",
            "Requirement already satisfied: pysocks!=1.5.7,<2.0,>=1.5.6 in /usr/local/lib/python3.10/dist-packages (from urllib3[socks]<3,>=1.26->selenium) (1.7.1)\n",
            "Collecting h11<1,>=0.9.0 (from wsproto>=0.14->trio-websocket~=0.9->selenium)\n",
            "  Downloading h11-0.14.0-py3-none-any.whl (58 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m58.3/58.3 kB\u001b[0m \u001b[31m5.2 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hInstalling collected packages: outcome, h11, wsproto, trio, trio-websocket, selenium\n",
            "Successfully installed h11-0.14.0 outcome-1.3.0.post0 selenium-4.18.1 trio-0.24.0 trio-websocket-0.11.1 wsproto-1.2.0\n",
            "Get:1 https://cloud.r-project.org/bin/linux/ubuntu jammy-cran40/ InRelease [3,626 B]\n",
            "Hit:2 https://developer.download.nvidia.com/compute/cuda/repos/ubuntu2204/x86_64  InRelease\n",
            "Get:3 http://security.ubuntu.com/ubuntu jammy-security InRelease [110 kB]\n",
            "Hit:4 http://archive.ubuntu.com/ubuntu jammy InRelease\n",
            "Get:5 http://archive.ubuntu.com/ubuntu jammy-updates InRelease [119 kB]\n",
            "Hit:6 https://ppa.launchpadcontent.net/c2d4u.team/c2d4u4.0+/ubuntu jammy InRelease\n",
            "Hit:7 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy InRelease\n",
            "Hit:8 https://ppa.launchpadcontent.net/graphics-drivers/ppa/ubuntu jammy InRelease\n",
            "Hit:9 http://archive.ubuntu.com/ubuntu jammy-backports InRelease\n",
            "Hit:10 https://ppa.launchpadcontent.net/ubuntugis/ppa/ubuntu jammy InRelease\n",
            "Get:11 http://security.ubuntu.com/ubuntu jammy-security/restricted amd64 Packages [1,951 kB]\n",
            "Get:12 http://archive.ubuntu.com/ubuntu jammy-updates/universe amd64 Packages [1,349 kB]\n",
            "Get:13 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages [1,561 kB]\n",
            "Get:14 http://security.ubuntu.com/ubuntu jammy-security/universe amd64 Packages [1,076 kB]\n",
            "Get:15 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages [1,843 kB]\n",
            "Get:16 http://archive.ubuntu.com/ubuntu jammy-updates/restricted amd64 Packages [1,994 kB]\n",
            "Fetched 10.0 MB in 2s (4,343 kB/s)\n",
            "Reading package lists... Done\n",
            "Reading package lists... Done\n",
            "Building dependency tree... Done\n",
            "Reading state information... Done\n",
            "The following additional packages will be installed:\n",
            "  apparmor chromium-browser libfuse3-3 liblzo2-2 libudev1 snapd squashfs-tools systemd-hwe-hwdb\n",
            "  udev\n",
            "Suggested packages:\n",
            "  apparmor-profiles-extra apparmor-utils fuse3 zenity | kdialog\n",
            "The following NEW packages will be installed:\n",
            "  apparmor chromium-browser chromium-chromedriver libfuse3-3 liblzo2-2 snapd squashfs-tools\n",
            "  systemd-hwe-hwdb udev\n",
            "The following packages will be upgraded:\n",
            "  libudev1\n",
            "1 upgraded, 9 newly installed, 0 to remove and 39 not upgraded.\n",
            "Need to get 26.4 MB of archives.\n",
            "After this operation, 116 MB of additional disk space will be used.\n",
            "Get:1 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 apparmor amd64 3.0.4-2ubuntu2.3 [595 kB]\n",
            "Get:2 http://archive.ubuntu.com/ubuntu jammy/main amd64 liblzo2-2 amd64 2.10-2build3 [53.7 kB]\n",
            "Get:3 http://archive.ubuntu.com/ubuntu jammy/main amd64 squashfs-tools amd64 1:4.5-3build1 [159 kB]\n",
            "Get:4 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libudev1 amd64 249.11-0ubuntu3.12 [78.2 kB]\n",
            "Get:5 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 udev amd64 249.11-0ubuntu3.12 [1,557 kB]\n",
            "Get:6 http://archive.ubuntu.com/ubuntu jammy/main amd64 libfuse3-3 amd64 3.10.5-1build1 [81.2 kB]\n",
            "Get:7 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 snapd amd64 2.58+22.04.1 [23.8 MB]\n",
            "Get:8 http://archive.ubuntu.com/ubuntu jammy-updates/universe amd64 chromium-browser amd64 1:85.0.4183.83-0ubuntu2.22.04.1 [49.2 kB]\n",
            "Get:9 http://archive.ubuntu.com/ubuntu jammy-updates/universe amd64 chromium-chromedriver amd64 1:85.0.4183.83-0ubuntu2.22.04.1 [2,308 B]\n",
            "Get:10 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 systemd-hwe-hwdb all 249.11.5 [3,228 B]\n",
            "Fetched 26.4 MB in 3s (10.5 MB/s)\n",
            "Preconfiguring packages ...\n",
            "Selecting previously unselected package apparmor.\n",
            "(Reading database ... 121749 files and directories currently installed.)\n",
            "Preparing to unpack .../apparmor_3.0.4-2ubuntu2.3_amd64.deb ...\n",
            "Unpacking apparmor (3.0.4-2ubuntu2.3) ...\n",
            "Selecting previously unselected package liblzo2-2:amd64.\n",
            "Preparing to unpack .../liblzo2-2_2.10-2build3_amd64.deb ...\n",
            "Unpacking liblzo2-2:amd64 (2.10-2build3) ...\n",
            "Selecting previously unselected package squashfs-tools.\n",
            "Preparing to unpack .../squashfs-tools_1%3a4.5-3build1_amd64.deb ...\n",
            "Unpacking squashfs-tools (1:4.5-3build1) ...\n",
            "Preparing to unpack .../libudev1_249.11-0ubuntu3.12_amd64.deb ...\n",
            "Unpacking libudev1:amd64 (249.11-0ubuntu3.12) over (249.11-0ubuntu3.10) ...\n",
            "Setting up libudev1:amd64 (249.11-0ubuntu3.12) ...\n",
            "Selecting previously unselected package udev.\n",
            "(Reading database ... 121957 files and directories currently installed.)\n",
            "Preparing to unpack .../udev_249.11-0ubuntu3.12_amd64.deb ...\n",
            "Unpacking udev (249.11-0ubuntu3.12) ...\n",
            "Selecting previously unselected package libfuse3-3:amd64.\n",
            "Preparing to unpack .../libfuse3-3_3.10.5-1build1_amd64.deb ...\n",
            "Unpacking libfuse3-3:amd64 (3.10.5-1build1) ...\n",
            "Selecting previously unselected package snapd.\n",
            "Preparing to unpack .../snapd_2.58+22.04.1_amd64.deb ...\n",
            "Unpacking snapd (2.58+22.04.1) ...\n",
            "Setting up apparmor (3.0.4-2ubuntu2.3) ...\n",
            "Created symlink /etc/systemd/system/sysinit.target.wants/apparmor.service → /lib/systemd/system/apparmor.service.\n",
            "Setting up liblzo2-2:amd64 (2.10-2build3) ...\n",
            "Setting up squashfs-tools (1:4.5-3build1) ...\n",
            "Setting up udev (249.11-0ubuntu3.12) ...\n",
            "invoke-rc.d: could not determine current runlevel\n",
            "invoke-rc.d: policy-rc.d denied execution of start.\n",
            "Setting up libfuse3-3:amd64 (3.10.5-1build1) ...\n",
            "Setting up snapd (2.58+22.04.1) ...\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.aa-prompt-listener.service → /lib/systemd/system/snapd.aa-prompt-listener.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.apparmor.service → /lib/systemd/system/snapd.apparmor.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.autoimport.service → /lib/systemd/system/snapd.autoimport.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.core-fixup.service → /lib/systemd/system/snapd.core-fixup.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.recovery-chooser-trigger.service → /lib/systemd/system/snapd.recovery-chooser-trigger.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.seeded.service → /lib/systemd/system/snapd.seeded.service.\n",
            "Created symlink /etc/systemd/system/cloud-final.service.wants/snapd.seeded.service → /lib/systemd/system/snapd.seeded.service.\n",
            "Unit /lib/systemd/system/snapd.seeded.service is added as a dependency to a non-existent unit cloud-final.service.\n",
            "Created symlink /etc/systemd/system/multi-user.target.wants/snapd.service → /lib/systemd/system/snapd.service.\n",
            "Created symlink /etc/systemd/system/timers.target.wants/snapd.snap-repair.timer → /lib/systemd/system/snapd.snap-repair.timer.\n",
            "Created symlink /etc/systemd/system/sockets.target.wants/snapd.socket → /lib/systemd/system/snapd.socket.\n",
            "Created symlink /etc/systemd/system/final.target.wants/snapd.system-shutdown.service → /lib/systemd/system/snapd.system-shutdown.service.\n",
            "Selecting previously unselected package chromium-browser.\n",
            "(Reading database ... 122190 files and directories currently installed.)\n",
            "Preparing to unpack .../chromium-browser_1%3a85.0.4183.83-0ubuntu2.22.04.1_amd64.deb ...\n",
            "=> Installing the chromium snap\n",
            "==> Checking connectivity with the snap store\n",
            "===> System doesn't have a working snapd, skipping\n",
            "Unpacking chromium-browser (1:85.0.4183.83-0ubuntu2.22.04.1) ...\n",
            "Selecting previously unselected package chromium-chromedriver.\n",
            "Preparing to unpack .../chromium-chromedriver_1%3a85.0.4183.83-0ubuntu2.22.04.1_amd64.deb ...\n",
            "Unpacking chromium-chromedriver (1:85.0.4183.83-0ubuntu2.22.04.1) ...\n",
            "Selecting previously unselected package systemd-hwe-hwdb.\n",
            "Preparing to unpack .../systemd-hwe-hwdb_249.11.5_all.deb ...\n",
            "Unpacking systemd-hwe-hwdb (249.11.5) ...\n",
            "Setting up systemd-hwe-hwdb (249.11.5) ...\n",
            "Setting up chromium-browser (1:85.0.4183.83-0ubuntu2.22.04.1) ...\n",
            "update-alternatives: using /usr/bin/chromium-browser to provide /usr/bin/x-www-browser (x-www-browser) in auto mode\n",
            "update-alternatives: using /usr/bin/chromium-browser to provide /usr/bin/gnome-www-browser (gnome-www-browser) in auto mode\n",
            "Setting up chromium-chromedriver (1:85.0.4183.83-0ubuntu2.22.04.1) ...\n",
            "Processing triggers for udev (249.11-0ubuntu3.12) ...\n",
            "Processing triggers for hicolor-icon-theme (0.17-2) ...\n",
            "Processing triggers for libc-bin (2.35-0ubuntu3.4) ...\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbbbind_2_5.so.3 is not a symbolic link\n",
            "\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbbbind.so.3 is not a symbolic link\n",
            "\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbbbind_2_0.so.3 is not a symbolic link\n",
            "\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbbmalloc.so.2 is not a symbolic link\n",
            "\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbbmalloc_proxy.so.2 is not a symbolic link\n",
            "\n",
            "/sbin/ldconfig.real: /usr/local/lib/libtbb.so.12 is not a symbolic link\n",
            "\n",
            "Processing triggers for man-db (2.10.2-1) ...\n",
            "Processing triggers for dbus (1.12.20-2ubuntu4.1) ...\n",
            "cp: '/usr/lib/chromium-browser/chromedriver' and '/usr/bin/chromedriver' are the same file\n",
            "Collecting webdriver_manager\n",
            "  Downloading webdriver_manager-4.0.1-py2.py3-none-any.whl (27 kB)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.10/dist-packages (from webdriver_manager) (2.31.0)\n",
            "Collecting python-dotenv (from webdriver_manager)\n",
            "  Downloading python_dotenv-1.0.1-py3-none-any.whl (19 kB)\n",
            "Requirement already satisfied: packaging in /usr/local/lib/python3.10/dist-packages (from webdriver_manager) (23.2)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests->webdriver_manager) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests->webdriver_manager) (3.6)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests->webdriver_manager) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests->webdriver_manager) (2024.2.2)\n",
            "Installing collected packages: python-dotenv, webdriver_manager\n",
            "Successfully installed python-dotenv-1.0.1 webdriver_manager-4.0.1\n"
          ]
        }
      ],
      "source": [
        "#@markdown # Instalar requerimientos\n",
        "!pip install selenium\n",
        "!apt-get update # to update ubuntu to correctly run apt install\n",
        "!apt install chromium-chromedriver\n",
        "!cp /usr/lib/chromium-browser/chromedriver /usr/bin\n",
        "!pip install webdriver_manager\n",
        "import sys\n",
        "sys.path.insert(0,'/usr/lib/chromium-browser/chromedriver')\n",
        "from selenium import webdriver\n",
        "from webdriver_manager.chrome import ChromeDriverManager\n",
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "air2AB1_T7UR",
        "cellView": "form",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "23d6957f-0674-45bc-aa33-f4c6f684a2ff"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mi nombre es: DIEGO EMILIO\n",
            "El padre de DIEGO EMILIO es: JUAN CARLOS SALAZAR SAENZ\n",
            "La madre de DIEGO EMILIO es: PAMELA ZAMORA RODRIGUEZ\n",
            "\n",
            "\n",
            "El padre de JUAN CARLOS es: OMAR ALFONSO SALAZAR SANCHEZ\n",
            "La madre de JUAN CARLOS es: NOEMY MARIA SAENZ MORA\n",
            "\n",
            "\n",
            "El padre de PAMELA MARIA es: EDVIN ZAMORA NUÑEZ\n",
            "La madre de PAMELA MARIA es: YOLANDA RODRIGUEZ RETANA\n",
            "\n",
            "\n",
            "El padre de EDVIN MARTIN es: COSTARRICENSE\n",
            "La madre de EDVIN MARTIN es: 0\n",
            "\n",
            "\n"
          ]
        }
      ],
      "source": [
        "from re import A\n",
        "#@markdown # Encuentre su árbol familiar\n",
        "from io import open_code\n",
        "import time\n",
        "import warnings\n",
        "warnings.filterwarnings('ignore')\n",
        "def get_info(cedula):\n",
        "  options = webdriver.ChromeOptions()\n",
        "  options.add_argument('--headless')\n",
        "  options.add_argument('--no-sandbox')\n",
        "  options.add_argument('--disable-dev-shm-usage')\n",
        "  driver = webdriver.Chrome(options=options)\n",
        "  driver.get('https://servicioselectorales.tse.go.cr/chc/consulta_cedula.aspx')\n",
        "  # Enter the cedula number\n",
        "  box = driver.find_element('xpath','//*[@id=\"txtcedula\"]')\n",
        "  box.send_keys(cedula)\n",
        "  driver.find_element('xpath','//*[@id=\"btnConsultaCedula\"]').click()\n",
        "  time.sleep(1)\n",
        "  driver.find_element('xpath','//*[@id=\"LinkButton11\"]').click()\n",
        "  time.sleep(1)\n",
        "  table = driver.find_element('xpath', '//*[@id=\"form1\"]/table[2]')\n",
        "  rows = table.find_elements('xpath','//*[@id=\"form1\"]/table[2]/tbody/tr')\n",
        "  df = pd.read_html(table.get_attribute('outerHTML'))\n",
        "  driver.find_element('xpath','//*[@id=\"ImageConsultaCedula\"]').click()\n",
        "  time.sleep(1)\n",
        "  return df\n",
        "\n",
        "def get_info_by_name(nombre,apellido1,apellido2):\n",
        "  options = webdriver.ChromeOptions()\n",
        "  options.add_argument('--headless')\n",
        "  options.add_argument('--no-sandbox')\n",
        "  options.add_argument('--disable-dev-shm-usage')\n",
        "  driver = webdriver.Chrome(options=options)\n",
        "  driver.get('https://servicioselectorales.tse.go.cr/chc/consulta_nombres.aspx')\n",
        "  # Enter the cedula number\n",
        "  box = driver.find_element('xpath','//*[@id=\"txtnombre\"]')\n",
        "  box.send_keys(nombre)\n",
        "  box = driver.find_element('xpath','//*[@id=\"txtapellido1\"]')\n",
        "  box.send_keys(apellido1)\n",
        "  box = driver.find_element('xpath','//*[@id=\"txtapellido2\"]')\n",
        "  box.send_keys(apellido2)\n",
        "  driver.find_element('xpath','//*[@id=\"btnConsultarNombre\"]').click()\n",
        "  time.sleep(3)\n",
        "  try:\n",
        "    driver.find_element('xpath','//*[@id=\"chk1_0\"]').click()\n",
        "\n",
        "    driver.find_element('xpath','//*[@id=\"Button1\"]').click()\n",
        "\n",
        "    time.sleep(1)\n",
        "    ced = driver.find_element('xpath', '//*[@id=\"lblcedula\"]')\n",
        "    ced = ced.text\n",
        "    return ced\n",
        "  except:\n",
        "    ced = \"\"\n",
        "    return ced\n",
        "\n",
        "\n",
        "def format(df):\n",
        "  df_transposed = df.transpose()\n",
        "  f0 = df_transposed.iloc[[0]]\n",
        "  f1 = df_transposed.iloc[[1]]\n",
        "  f2 = df_transposed.iloc[[2]]\n",
        "  f3 = df_transposed.iloc[[3]]\n",
        "  df0 = pd.concat([f0, f1], axis=0)\n",
        "  df1 = pd.concat([f2, f3], axis=0)\n",
        "  df1 = df1.reset_index()\n",
        "  new_df = pd.concat([df0, df1], axis=1)\n",
        "  new_df = new_df.drop(columns=['index'])\n",
        "  new_df.columns = new_df.iloc[0]\n",
        "  new_df = new_df.drop(0)\n",
        "  new_df = new_df.dropna(axis=1, how='all')\n",
        "  return new_df\n",
        "#@markdown - Ingrese su número de cédula.\n",
        "\n",
        "def tree(data,yo,string_var):\n",
        "  padre = data.iloc[0, 7]\n",
        "  madre = data.iloc[0, 9]\n",
        "  padre_c = data.iloc[0, 8]  # (fila 0, columna 9)\n",
        "  madre_c = data.iloc[0, 10]\n",
        "  print(f\"El padre de {yo} es: {padre}\")\n",
        "  print(f\"La madre de {yo} es: {madre}\")\n",
        "  print(\"\\n\")\n",
        "  try:\n",
        "    a = '\\n' + 'El padre de ' + str(yo) + ' es: ' + str(padre)\n",
        "    b = '\\n' + 'La madre de ' + str(yo) + ' es: ' + str(madre)\n",
        "    c = '\\n'\n",
        "    string_var = string_var + a + b + c\n",
        "  except:\n",
        "    try:\n",
        "      a= '\\n' + 'El padre de ' + str(yo) + ' no está registrado'\n",
        "      b = '\\n' + 'La madre de ' + str(yo) + ' es: ' + str(madre)\n",
        "      c = '\\n'\n",
        "      string_var = string_var + a + b + c\n",
        "    except:\n",
        "      try:\n",
        "        a = '\\n' + 'El padre de ' + str(yo) + ' es: ' + str(padre)\n",
        "        b = '\\n' + 'La madre de ' + str(yo) + ' no está registrada'\n",
        "        c = '\\n'\n",
        "        string_var = string_var + a + b + c\n",
        "      except:\n",
        "        a = '\\n' + 'El padre y la madre de ' + str(yo) + 'no están registrados'\n",
        "        string_var = string_var + a\n",
        "\n",
        "  if madre_c.isalpha() or padre_c.isalpha():\n",
        "    cedulas = None\n",
        "    return cedulas\n",
        "  if padre_c == '0':\n",
        "    partes_nombre = padre.split()\n",
        "    if len(partes_nombre) > 3:\n",
        "      nombre = partes_nombre[0] + \" \" + partes_nombre[1]\n",
        "      apellido1 = partes_nombre[2]\n",
        "      apellido2 = partes_nombre[3]\n",
        "      padre_c = get_info_by_name(nombre,apellido1,apellido2)\n",
        "    elif len(partes_nombre) == 2:\n",
        "      nombre = partes_nombre[0]\n",
        "      apellido1 = partes_nombre[1]\n",
        "      ### Fix\n",
        "      padre_c = \"\"\n",
        "    else:\n",
        "      nombre = partes_nombre[0]\n",
        "      apellido1 = partes_nombre[1]\n",
        "      apellido2 = partes_nombre[2]\n",
        "      padre_c = get_info_by_name(nombre,apellido1,apellido2)\n",
        "  if madre_c == '0':\n",
        "    partes_nombre = madre.split()\n",
        "    if len(partes_nombre) > 3:\n",
        "      nombre = partes_nombre[0] + \" \" + partes_nombre[1]\n",
        "      apellido1 = partes_nombre[2]\n",
        "      apellido2 = partes_nombre[3]\n",
        "      madre_c = get_info_by_name(nombre,apellido1,apellido2)\n",
        "    elif len(partes_nombre) == 2:\n",
        "      nombre = partes_nombre[0]\n",
        "      apellido1 = partes_nombre[1]\n",
        "      ### Fix\n",
        "      madre_c = \"\"\n",
        "    else:\n",
        "      nombre = partes_nombre[0]\n",
        "      apellido1 = partes_nombre[1]\n",
        "      apellido2 = partes_nombre[2]\n",
        "      madre_c = get_info_by_name(nombre,apellido1,apellido2)\n",
        "  if madre_c == \"\":\n",
        "    cedulas = padre_c\n",
        "  elif padre_c == \"\":\n",
        "    cedulas = madre_c\n",
        "  elif padre_c and madre_c == \"\":\n",
        "    cedulas = None\n",
        "  else:\n",
        "    cedulas = padre_c,madre_c\n",
        "  data = pd.DataFrame()\n",
        "  return cedulas, string_var\n",
        "\n",
        "def main():\n",
        "  cedula = \"305320322\" #@param {type:\"string\"}\n",
        "  df = pd.DataFrame()\n",
        "  try:\n",
        "    df = df.append(get_info(cedula))\n",
        "  except:\n",
        "    print('Error: Invalid cedula number')\n",
        "  data = pd.DataFrame()\n",
        "  data = data.append(format(df))\n",
        "  yo = data.iloc[0, 1]\n",
        "  print(f'Mi nombre es: {yo}')\n",
        "  string_var = 'Mi nombre es: ' + str(yo)\n",
        "  cedulas, string_var = tree(data,yo,string_var)\n",
        "  ids = list(cedulas)\n",
        "  i=3\n",
        "  #try:\n",
        "  while i > 0:\n",
        "\n",
        "    for cedula in ids:\n",
        "      if i>0:\n",
        "        df = pd.DataFrame()\n",
        "        data = pd.DataFrame()\n",
        "        df = df.append(get_info(cedula))\n",
        "        data = data.append(format(df))\n",
        "        yo = data.iloc[0, 1]\n",
        "        tupla, string_var = tree(data,yo,string_var)\n",
        "        try:\n",
        "          lista_t = list(tupla)\n",
        "        except:\n",
        "          lista_t = None\n",
        "        #try:\n",
        "        if lista_t != None:\n",
        "          ids.extend(lista_t)\n",
        "        #except:\n",
        "          #print(f'Los padres de {yo} no tienen la cedula registrada en el TSE')\n",
        "        data = pd.DataFrame()\n",
        "        df = pd.DataFrame()\n",
        "        i=i-1\n",
        "  return string_var\n",
        "  #except:\n",
        "   # print('Done!')\n",
        "    #return string_var\n",
        "if __name__ == '__main__':\n",
        "  main()\n",
        "#@markdown *Código utiliza solo la información disponible en el TSE"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "7aHi03ith05z"
      },
      "outputs": [],
      "source": [
        "@anvil.server.callable\n",
        "def send(text_box_1):\n",
        "  string_var = main(text_box_1)\n",
        "  return string_var"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 557
        },
        "id": "D3h1oLMoipdQ",
        "outputId": "d767e8a2-a166-4a91-9bab-e9870dc3a66c"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mi nombre es: MARIPAZ\n",
            "El padre de MARIPAZ es: VICTOR MANUEL FALLAS FALLAS\n",
            "La madre de MARIPAZ es: ANA MARCELA CORDERO MEZA\n",
            "\n",
            "\n",
            "El padre de VICTOR MANUEL es: VICTOR MANUEL FALLAS MARIN\n",
            "La madre de VICTOR MANUEL es: NOEMY FALLAS FALLAS\n",
            "\n",
            "\n",
            "El padre de ANA MARCELA es: JORGE CORDERO FALLAS\n",
            "La madre de ANA MARCELA es: ANA CECILIA MEZA RAMOS\n",
            "\n",
            "\n",
            "El padre de VICTOR MANUEL es: MANUEL FALLAS VARGAS\n",
            "La madre de VICTOR MANUEL es: ROSA MARIN\n",
            "\n",
            "\n"
          ]
        },
        {
          "output_type": "error",
          "ename": "KeyboardInterrupt",
          "evalue": "",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-13-95cac3476493>\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0manvil\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mserver\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwait_forever\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/anvil/server.py\u001b[0m in \u001b[0;36mwait_forever\u001b[0;34m()\u001b[0m\n\u001b[1;32m    435\u001b[0m     \u001b[0m_get_connection\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    436\u001b[0m     \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 437\u001b[0;31m         \u001b[0mtime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msleep\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
          ]
        }
      ],
      "source": [
        "anvil.server.wait_forever()"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPbgd14+bucR069m+EuZbBq",
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}