OPenDataR.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "OPenDataR.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/triatebr/aprenda-python/blob/master/OPenDataR.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "baCo8xMkk4X3",
        "colab_type": "text"
      },
      "source": [
        "![logos](https://mundogeo.com/wp-content/uploads/2014/01/Plataforma-Dados-Abertos.jpg)\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "B9jRomyCk3R3",
        "colab_type": "text"
      },
      "source": [
        "Vamos importar o arquivo para o nosso 'ambiente':<p>\n",
        "  - 'conare.csv'<p>\n",
        " Arquivo com Dados do Conselho Nacional dos Refugiados <p>\n",
        "   Fonte: ACNUR - Alto Comissariado das Nações Unidas para os Refugiados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9ODlU6jzky3e",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import seaborn as sns\n",
        "import numpy as np\n",
        "import io\n",
        "import matplotlib.pyplot as plt\n",
        "%matplotlib inline"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WHzPMDsiv06y",
        "colab_type": "code",
        "outputId": "27b939c7-f07b-48cd-c9b3-feca1c3b4b25",
        "colab": {
          "resources": {
            "http://localhost:8080/nbextensions/google.colab/files.js": {
              "data": "Ly8gQ29weXJpZ2h0IDIwMTcgR29vZ2xlIExMQwovLwovLyBMaWNlbnNlZCB1bmRlciB0aGUgQXBhY2hlIExpY2Vuc2UsIFZlcnNpb24gMi4wICh0aGUgIkxpY2Vuc2UiKTsKLy8geW91IG1heSBub3QgdXNlIHRoaXMgZmlsZSBleGNlcHQgaW4gY29tcGxpYW5jZSB3aXRoIHRoZSBMaWNlbnNlLgovLyBZb3UgbWF5IG9idGFpbiBhIGNvcHkgb2YgdGhlIExpY2Vuc2UgYXQKLy8KLy8gICAgICBodHRwOi8vd3d3LmFwYWNoZS5vcmcvbGljZW5zZXMvTElDRU5TRS0yLjAKLy8KLy8gVW5sZXNzIHJlcXVpcmVkIGJ5IGFwcGxpY2FibGUgbGF3IG9yIGFncmVlZCB0byBpbiB3cml0aW5nLCBzb2Z0d2FyZQovLyBkaXN0cmlidXRlZCB1bmRlciB0aGUgTGljZW5zZSBpcyBkaXN0cmlidXRlZCBvbiBhbiAiQVMgSVMiIEJBU0lTLAovLyBXSVRIT1VUIFdBUlJBTlRJRVMgT1IgQ09ORElUSU9OUyBPRiBBTlkgS0lORCwgZWl0aGVyIGV4cHJlc3Mgb3IgaW1wbGllZC4KLy8gU2VlIHRoZSBMaWNlbnNlIGZvciB0aGUgc3BlY2lmaWMgbGFuZ3VhZ2UgZ292ZXJuaW5nIHBlcm1pc3Npb25zIGFuZAovLyBsaW1pdGF0aW9ucyB1bmRlciB0aGUgTGljZW5zZS4KCi8qKgogKiBAZmlsZW92ZXJ2aWV3IEhlbHBlcnMgZm9yIGdvb2dsZS5jb2xhYiBQeXRob24gbW9kdWxlLgogKi8KKGZ1bmN0aW9uKHNjb3BlKSB7CmZ1bmN0aW9uIHNwYW4odGV4dCwgc3R5bGVBdHRyaWJ1dGVzID0ge30pIHsKICBjb25zdCBlbGVtZW50ID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgnc3BhbicpOwogIGVsZW1lbnQudGV4dENvbnRlbnQgPSB0ZXh0OwogIGZvciAoY29uc3Qga2V5IG9mIE9iamVjdC5rZXlzKHN0eWxlQXR0cmlidXRlcykpIHsKICAgIGVsZW1lbnQuc3R5bGVba2V5XSA9IHN0eWxlQXR0cmlidXRlc1trZXldOwogIH0KICByZXR1cm4gZWxlbWVudDsKfQoKLy8gTWF4IG51bWJlciBvZiBieXRlcyB3aGljaCB3aWxsIGJlIHVwbG9hZGVkIGF0IGEgdGltZS4KY29uc3QgTUFYX1BBWUxPQURfU0laRSA9IDEwMCAqIDEwMjQ7Ci8vIE1heCBhbW91bnQgb2YgdGltZSB0byBibG9jayB3YWl0aW5nIGZvciB0aGUgdXNlci4KY29uc3QgRklMRV9DSEFOR0VfVElNRU9VVF9NUyA9IDMwICogMTAwMDsKCmZ1bmN0aW9uIF91cGxvYWRGaWxlcyhpbnB1dElkLCBvdXRwdXRJZCkgewogIGNvbnN0IHN0ZXBzID0gdXBsb2FkRmlsZXNTdGVwKGlucHV0SWQsIG91dHB1dElkKTsKICBjb25zdCBvdXRwdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQob3V0cHV0SWQpOwogIC8vIENhY2hlIHN0ZXBzIG9uIHRoZSBvdXRwdXRFbGVtZW50IHRvIG1ha2UgaXQgYXZhaWxhYmxlIGZvciB0aGUgbmV4dCBjYWxsCiAgLy8gdG8gdXBsb2FkRmlsZXNDb250aW51ZSBmcm9tIFB5dGhvbi4KICBvdXRwdXRFbGVtZW50LnN0ZXBzID0gc3RlcHM7CgogIHJldHVybiBfdXBsb2FkRmlsZXNDb250aW51ZShvdXRwdXRJZCk7Cn0KCi8vIFRoaXMgaXMgcm91Z2hseSBhbiBhc3luYyBnZW5lcmF0b3IgKG5vdCBzdXBwb3J0ZWQgaW4gdGhlIGJyb3dzZXIgeWV0KSwKLy8gd2hlcmUgdGhlcmUgYXJlIG11bHRpcGxlIGFzeW5jaHJvbm91cyBzdGVwcyBhbmQgdGhlIFB5dGhvbiBzaWRlIGlzIGdvaW5nCi8vIHRvIHBvbGwgZm9yIGNvbXBsZXRpb24gb2YgZWFjaCBzdGVwLgovLyBUaGlzIHVzZXMgYSBQcm9taXNlIHRvIGJsb2NrIHRoZSBweXRob24gc2lkZSBvbiBjb21wbGV0aW9uIG9mIGVhY2ggc3RlcCwKLy8gdGhlbiBwYXNzZXMgdGhlIHJlc3VsdCBvZiB0aGUgcHJldmlvdXMgc3RlcCBhcyB0aGUgaW5wdXQgdG8gdGhlIG5leHQgc3RlcC4KZnVuY3Rpb24gX3VwbG9hZEZpbGVzQ29udGludWUob3V0cHV0SWQpIHsKICBjb25zdCBvdXRwdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQob3V0cHV0SWQpOwogIGNvbnN0IHN0ZXBzID0gb3V0cHV0RWxlbWVudC5zdGVwczsKCiAgY29uc3QgbmV4dCA9IHN0ZXBzLm5leHQob3V0cHV0RWxlbWVudC5sYXN0UHJvbWlzZVZhbHVlKTsKICByZXR1cm4gUHJvbWlzZS5yZXNvbHZlKG5leHQudmFsdWUucHJvbWlzZSkudGhlbigodmFsdWUpID0+IHsKICAgIC8vIENhY2hlIHRoZSBsYXN0IHByb21pc2UgdmFsdWUgdG8gbWFrZSBpdCBhdmFpbGFibGUgdG8gdGhlIG5leHQKICAgIC8vIHN0ZXAgb2YgdGhlIGdlbmVyYXRvci4KICAgIG91dHB1dEVsZW1lbnQubGFzdFByb21pc2VWYWx1ZSA9IHZhbHVlOwogICAgcmV0dXJuIG5leHQudmFsdWUucmVzcG9uc2U7CiAgfSk7Cn0KCi8qKgogKiBHZW5lcmF0b3IgZnVuY3Rpb24gd2hpY2ggaXMgY2FsbGVkIGJldHdlZW4gZWFjaCBhc3luYyBzdGVwIG9mIHRoZSB1cGxvYWQKICogcHJvY2Vzcy4KICogQHBhcmFtIHtzdHJpbmd9IGlucHV0SWQgRWxlbWVudCBJRCBvZiB0aGUgaW5wdXQgZmlsZSBwaWNrZXIgZWxlbWVudC4KICogQHBhcmFtIHtzdHJpbmd9IG91dHB1dElkIEVsZW1lbnQgSUQgb2YgdGhlIG91dHB1dCBkaXNwbGF5LgogKiBAcmV0dXJuIHshSXRlcmFibGU8IU9iamVjdD59IEl0ZXJhYmxlIG9mIG5leHQgc3RlcHMuCiAqLwpmdW5jdGlvbiogdXBsb2FkRmlsZXNTdGVwKGlucHV0SWQsIG91dHB1dElkKSB7CiAgY29uc3QgaW5wdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQoaW5wdXRJZCk7CiAgaW5wdXRFbGVtZW50LmRpc2FibGVkID0gZmFsc2U7CgogIGNvbnN0IG91dHB1dEVsZW1lbnQgPSBkb2N1bWVudC5nZXRFbGVtZW50QnlJZChvdXRwdXRJZCk7CiAgb3V0cHV0RWxlbWVudC5pbm5lckhUTUwgPSAnJzsKCiAgY29uc3QgcGlja2VkUHJvbWlzZSA9IG5ldyBQcm9taXNlKChyZXNvbHZlKSA9PiB7CiAgICBpbnB1dEVsZW1lbnQuYWRkRXZlbnRMaXN0ZW5lcignY2hhbmdlJywgKGUpID0+IHsKICAgICAgcmVzb2x2ZShlLnRhcmdldC5maWxlcyk7CiAgICB9KTsKICB9KTsKCiAgY29uc3QgY2FuY2VsID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgnYnV0dG9uJyk7CiAgaW5wdXRFbGVtZW50LnBhcmVudEVsZW1lbnQuYXBwZW5kQ2hpbGQoY2FuY2VsKTsKICBjYW5jZWwudGV4dENvbnRlbnQgPSAnQ2FuY2VsIHVwbG9hZCc7CiAgY29uc3QgY2FuY2VsUHJvbWlzZSA9IG5ldyBQcm9taXNlKChyZXNvbHZlKSA9PiB7CiAgICBjYW5jZWwub25jbGljayA9ICgpID0+IHsKICAgICAgcmVzb2x2ZShudWxsKTsKICAgIH07CiAgfSk7CgogIC8vIENhbmNlbCB1cGxvYWQgaWYgdXNlciBoYXNuJ3QgcGlja2VkIGFueXRoaW5nIGluIHRpbWVvdXQuCiAgY29uc3QgdGltZW91dFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgc2V0VGltZW91dCgoKSA9PiB7CiAgICAgIHJlc29sdmUobnVsbCk7CiAgICB9LCBGSUxFX0NIQU5HRV9USU1FT1VUX01TKTsKICB9KTsKCiAgLy8gV2FpdCBmb3IgdGhlIHVzZXIgdG8gcGljayB0aGUgZmlsZXMuCiAgY29uc3QgZmlsZXMgPSB5aWVsZCB7CiAgICBwcm9taXNlOiBQcm9taXNlLnJhY2UoW3BpY2tlZFByb21pc2UsIHRpbWVvdXRQcm9taXNlLCBjYW5jZWxQcm9taXNlXSksCiAgICByZXNwb25zZTogewogICAgICBhY3Rpb246ICdzdGFydGluZycsCiAgICB9CiAgfTsKCiAgaWYgKCFmaWxlcykgewogICAgcmV0dXJuIHsKICAgICAgcmVzcG9uc2U6IHsKICAgICAgICBhY3Rpb246ICdjb21wbGV0ZScsCiAgICAgIH0KICAgIH07CiAgfQoKICBjYW5jZWwucmVtb3ZlKCk7CgogIC8vIERpc2FibGUgdGhlIGlucHV0IGVsZW1lbnQgc2luY2UgZnVydGhlciBwaWNrcyBhcmUgbm90IGFsbG93ZWQuCiAgaW5wdXRFbGVtZW50LmRpc2FibGVkID0gdHJ1ZTsKCiAgZm9yIChjb25zdCBmaWxlIG9mIGZpbGVzKSB7CiAgICBjb25zdCBsaSA9IGRvY3VtZW50LmNyZWF0ZUVsZW1lbnQoJ2xpJyk7CiAgICBsaS5hcHBlbmQoc3BhbihmaWxlLm5hbWUsIHtmb250V2VpZ2h0OiAnYm9sZCd9KSk7CiAgICBsaS5hcHBlbmQoc3BhbigKICAgICAgICBgKCR7ZmlsZS50eXBlIHx8ICduL2EnfSkgLSAke2ZpbGUuc2l6ZX0gYnl0ZXMsIGAgKwogICAgICAgIGBsYXN0IG1vZGlmaWVkOiAkewogICAgICAgICAgICBmaWxlLmxhc3RNb2RpZmllZERhdGUgPyBmaWxlLmxhc3RNb2RpZmllZERhdGUudG9Mb2NhbGVEYXRlU3RyaW5nKCkgOgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAnbi9hJ30gLSBgKSk7CiAgICBjb25zdCBwZXJjZW50ID0gc3BhbignMCUgZG9uZScpOwogICAgbGkuYXBwZW5kQ2hpbGQocGVyY2VudCk7CgogICAgb3V0cHV0RWxlbWVudC5hcHBlbmRDaGlsZChsaSk7CgogICAgY29uc3QgZmlsZURhdGFQcm9taXNlID0gbmV3IFByb21pc2UoKHJlc29sdmUpID0+IHsKICAgICAgY29uc3QgcmVhZGVyID0gbmV3IEZpbGVSZWFkZXIoKTsKICAgICAgcmVhZGVyLm9ubG9hZCA9IChlKSA9PiB7CiAgICAgICAgcmVzb2x2ZShlLnRhcmdldC5yZXN1bHQpOwogICAgICB9OwogICAgICByZWFkZXIucmVhZEFzQXJyYXlCdWZmZXIoZmlsZSk7CiAgICB9KTsKICAgIC8vIFdhaXQgZm9yIHRoZSBkYXRhIHRvIGJlIHJlYWR5LgogICAgbGV0IGZpbGVEYXRhID0geWllbGQgewogICAgICBwcm9taXNlOiBmaWxlRGF0YVByb21pc2UsCiAgICAgIHJlc3BvbnNlOiB7CiAgICAgICAgYWN0aW9uOiAnY29udGludWUnLAogICAgICB9CiAgICB9OwoKICAgIC8vIFVzZSBhIGNodW5rZWQgc2VuZGluZyB0byBhdm9pZCBtZXNzYWdlIHNpemUgbGltaXRzLiBTZWUgYi82MjExNTY2MC4KICAgIGxldCBwb3NpdGlvbiA9IDA7CiAgICB3aGlsZSAocG9zaXRpb24gPCBmaWxlRGF0YS5ieXRlTGVuZ3RoKSB7CiAgICAgIGNvbnN0IGxlbmd0aCA9IE1hdGgubWluKGZpbGVEYXRhLmJ5dGVMZW5ndGggLSBwb3NpdGlvbiwgTUFYX1BBWUxPQURfU0laRSk7CiAgICAgIGNvbnN0IGNodW5rID0gbmV3IFVpbnQ4QXJyYXkoZmlsZURhdGEsIHBvc2l0aW9uLCBsZW5ndGgpOwogICAgICBwb3NpdGlvbiArPSBsZW5ndGg7CgogICAgICBjb25zdCBiYXNlNjQgPSBidG9hKFN0cmluZy5mcm9tQ2hhckNvZGUuYXBwbHkobnVsbCwgY2h1bmspKTsKICAgICAgeWllbGQgewogICAgICAgIHJlc3BvbnNlOiB7CiAgICAgICAgICBhY3Rpb246ICdhcHBlbmQnLAogICAgICAgICAgZmlsZTogZmlsZS5uYW1lLAogICAgICAgICAgZGF0YTogYmFzZTY0LAogICAgICAgIH0sCiAgICAgIH07CiAgICAgIHBlcmNlbnQudGV4dENvbnRlbnQgPQogICAgICAgICAgYCR7TWF0aC5yb3VuZCgocG9zaXRpb24gLyBmaWxlRGF0YS5ieXRlTGVuZ3RoKSAqIDEwMCl9JSBkb25lYDsKICAgIH0KICB9CgogIC8vIEFsbCBkb25lLgogIHlpZWxkIHsKICAgIHJlc3BvbnNlOiB7CiAgICAgIGFjdGlvbjogJ2NvbXBsZXRlJywKICAgIH0KICB9Owp9CgpzY29wZS5nb29nbGUgPSBzY29wZS5nb29nbGUgfHwge307CnNjb3BlLmdvb2dsZS5jb2xhYiA9IHNjb3BlLmdvb2dsZS5jb2xhYiB8fCB7fTsKc2NvcGUuZ29vZ2xlLmNvbGFiLl9maWxlcyA9IHsKICBfdXBsb2FkRmlsZXMsCiAgX3VwbG9hZEZpbGVzQ29udGludWUsCn07Cn0pKHNlbGYpOwo=",
              "ok": true,
              "headers": [
                [
                  "content-type",
                  "application/javascript"
                ]
              ],
              "status": 200,
              "status_text": ""
            }
          },
          "base_uri": "https://localhost:8080/",
          "height": 74
        }
      },
      "source": [
        "from google.colab import files\n",
        "uploaded = files.upload()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-60f818bb-d303-4cf3-8a49-3fbf1749af3f\" name=\"files[]\" multiple disabled />\n",
              "     <output id=\"result-60f818bb-d303-4cf3-8a49-3fbf1749af3f\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script src=\"/nbextensions/google.colab/files.js\"></script> "
            ],
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "stream",
          "text": [
            "Saving conar_e.csv to conar_e.csv\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hXjburH4wFbF",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# CONARE - Comitê Nacional para os Refugiados\n",
        "dfc = pd.read_csv(io.BytesIO(uploaded['conar_e.csv']),encoding ='latin', delimiter=\";\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VXJ7_lVCwXij",
        "colab_type": "code",
        "outputId": "409a6c57-550e-46b7-96fc-5cd6689283d3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 309
        }
      },
      "source": [
        "dfc.head()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Status</th>\n",
              "      <th>Protocolo</th>\n",
              "      <th>Ano Solicitação</th>\n",
              "      <th>SEI</th>\n",
              "      <th>Nome Solicitante</th>\n",
              "      <th>Sexo</th>\n",
              "      <th>Estado Civil</th>\n",
              "      <th>Data Nascimento</th>\n",
              "      <th>Idade Solicitação</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Continente</th>\n",
              "      <th>Data Solicitação</th>\n",
              "      <th>Cidade Solicitação</th>\n",
              "      <th>UF Solicitação</th>\n",
              "      <th>Data Decisão</th>\n",
              "      <th>Ano Decisão</th>\n",
              "      <th>Motivo Arquivamento</th>\n",
              "      <th>Data Arquivamento</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ARQUIVADOS</td>\n",
              "      <td>1</td>\n",
              "      <td>2015</td>\n",
              "      <td>SIM</td>\n",
              "      <td>1</td>\n",
              "      <td>MASCULINO</td>\n",
              "      <td>SOLTEIRO(A)</td>\n",
              "      <td>12/07/1968</td>\n",
              "      <td>46</td>\n",
              "      <td>TANZÂNIA</td>\n",
              "      <td>África</td>\n",
              "      <td>1/29/2015</td>\n",
              "      <td>São Paulo</td>\n",
              "      <td>SP</td>\n",
              "      <td>11/20/2015</td>\n",
              "      <td>2015</td>\n",
              "      <td>Outros</td>\n",
              "      <td>09/11/2015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ARQUIVADOS</td>\n",
              "      <td>2</td>\n",
              "      <td>2013</td>\n",
              "      <td>SIM</td>\n",
              "      <td>2</td>\n",
              "      <td>FEMININO</td>\n",
              "      <td>VIÚVO(A)</td>\n",
              "      <td>04/11/1951</td>\n",
              "      <td>62</td>\n",
              "      <td>NIGÉRIA</td>\n",
              "      <td>África</td>\n",
              "      <td>6/26/2013</td>\n",
              "      <td>São Paulo</td>\n",
              "      <td>SP</td>\n",
              "      <td>11/20/2015</td>\n",
              "      <td>2015</td>\n",
              "      <td>Decisão Cnig Res. 27</td>\n",
              "      <td>1/19/2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ARQUIVADOS</td>\n",
              "      <td>3</td>\n",
              "      <td>2013</td>\n",
              "      <td>SIM</td>\n",
              "      <td>3</td>\n",
              "      <td>FEMININO</td>\n",
              "      <td>MENOR</td>\n",
              "      <td>10/08/2005</td>\n",
              "      <td>7</td>\n",
              "      <td>COLÔMBIA</td>\n",
              "      <td>América Do Sul</td>\n",
              "      <td>09/11/2013</td>\n",
              "      <td>Tabatinga</td>\n",
              "      <td>AM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Não Julgado</td>\n",
              "      <td>Desistência Voluntária</td>\n",
              "      <td>04/04/2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ARQUIVADOS</td>\n",
              "      <td>4</td>\n",
              "      <td>2013</td>\n",
              "      <td>SIM</td>\n",
              "      <td>4</td>\n",
              "      <td>FEMININO</td>\n",
              "      <td>MENOR</td>\n",
              "      <td>11/06/2007</td>\n",
              "      <td>5</td>\n",
              "      <td>COLÔMBIA</td>\n",
              "      <td>América Do Sul</td>\n",
              "      <td>09/11/2013</td>\n",
              "      <td>Tabatinga</td>\n",
              "      <td>AM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Não Julgado</td>\n",
              "      <td>Desistência Voluntária</td>\n",
              "      <td>04/04/2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ARQUIVADOS</td>\n",
              "      <td>5</td>\n",
              "      <td>2013</td>\n",
              "      <td>SIM</td>\n",
              "      <td>5</td>\n",
              "      <td>MASCULINO</td>\n",
              "      <td>CASADO(A)</td>\n",
              "      <td>08/04/1976</td>\n",
              "      <td>37</td>\n",
              "      <td>COLÔMBIA</td>\n",
              "      <td>América Do Sul</td>\n",
              "      <td>09/11/2013</td>\n",
              "      <td>Tabatinga</td>\n",
              "      <td>AM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Não Julgado</td>\n",
              "      <td>Desistência Voluntária</td>\n",
              "      <td>04/04/2016</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Status  Protocolo Ano Solicitação  SEI  Nome Solicitante       Sexo  \\\n",
              "0  ARQUIVADOS          1            2015  SIM                 1  MASCULINO   \n",
              "1  ARQUIVADOS          2            2013  SIM                 2   FEMININO   \n",
              "2  ARQUIVADOS          3            2013  SIM                 3   FEMININO   \n",
              "3  ARQUIVADOS          4            2013  SIM                 4   FEMININO   \n",
              "4  ARQUIVADOS          5            2013  SIM                 5  MASCULINO   \n",
              "\n",
              "  Estado Civil Data Nascimento Idade Solicitação País de Origem  \\\n",
              "0  SOLTEIRO(A)      12/07/1968                46       TANZÂNIA   \n",
              "1     VIÚVO(A)      04/11/1951                62        NIGÉRIA   \n",
              "2        MENOR      10/08/2005                 7       COLÔMBIA   \n",
              "3        MENOR      11/06/2007                 5       COLÔMBIA   \n",
              "4    CASADO(A)      08/04/1976                37       COLÔMBIA   \n",
              "\n",
              "       Continente Data Solicitação Cidade Solicitação UF Solicitação  \\\n",
              "0          África        1/29/2015          São Paulo             SP   \n",
              "1          África        6/26/2013          São Paulo             SP   \n",
              "2  América Do Sul       09/11/2013          Tabatinga             AM   \n",
              "3  América Do Sul       09/11/2013          Tabatinga             AM   \n",
              "4  América Do Sul       09/11/2013          Tabatinga             AM   \n",
              "\n",
              "  Data Decisão  Ano Decisão     Motivo Arquivamento Data Arquivamento  \n",
              "0   11/20/2015         2015                  Outros        09/11/2015  \n",
              "1   11/20/2015         2015    Decisão Cnig Res. 27         1/19/2016  \n",
              "2          NaN  Não Julgado  Desistência Voluntária        04/04/2016  \n",
              "3          NaN  Não Julgado  Desistência Voluntária        04/04/2016  \n",
              "4          NaN  Não Julgado  Desistência Voluntária        04/04/2016  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "k_XZ38T6mcLl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# Tabela de solicitações de reconhecimento da condição de refugiado - 1994 (primeiro registro disponível) a 13 de março de 2019\n",
        "# Fonte dos dados: http://dados.gov.br/dataset/comite-nacional-para-os-refugiados\n",
        "url = 'https://www.justica.gov.br/seus-direitos/refugio/anexos/1990-a-2019-solicitacoes-de-reconhecimento-da-condicao-de-refugiado.xlsx'"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3SW_HkYimpb7",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "dfs = pd.read_excel(url,enconding='latin',delimiter=\";\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8sEpxQ3Km8Jo",
        "colab_type": "code",
        "outputId": "17dd550a-c99e-4084-be34-fcc6509e56ad",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        }
      },
      "source": [
        "# Visualização das 5 primeiras linhas do dataframe, mas caso prefira mais linhas? insira o numero entre os '()'\n",
        "# Costuma-se usar nome sugestivos para os Dataframes, com foco na facilidade de lembrar e usar\n",
        "dfs.head()"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Tipo de Alertas e Restrições</th>\n",
              "      <th>Nacionalidade</th>\n",
              "      <th>Mês/Ano</th>\n",
              "      <th>UF</th>\n",
              "      <th>Quantidade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>AFEGANISTÃO</td>\n",
              "      <td>12/2001</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>AFEGANISTÃO</td>\n",
              "      <td>01/2010</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>AFEGANISTÃO</td>\n",
              "      <td>03/2010</td>\n",
              "      <td>DF</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>AFEGANISTÃO</td>\n",
              "      <td>03/2010</td>\n",
              "      <td>SP</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>AFEGANISTÃO</td>\n",
              "      <td>08/2010</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Tipo de Alertas e Restrições Nacionalidade  Mês/Ano  UF  Quantidade\n",
              "0       SOLICITAÇÃO DE REFÚGIO   AFEGANISTÃO  12/2001  DF           1\n",
              "1       SOLICITAÇÃO DE REFÚGIO   AFEGANISTÃO  01/2010  DF           1\n",
              "2       SOLICITAÇÃO DE REFÚGIO   AFEGANISTÃO  03/2010  DF           2\n",
              "3       SOLICITAÇÃO DE REFÚGIO   AFEGANISTÃO  03/2010  SP           2\n",
              "4       SOLICITAÇÃO DE REFÚGIO   AFEGANISTÃO  08/2010  DF           1"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nwdMNeblpFbs",
        "colab_type": "code",
        "outputId": "361965c7-94e3-4e24-fca9-87ebf473c6f6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "# Quantidade de linhas e colunas do dataframe\n",
        "dfs.shape"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(11656, 5)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Qx5bqo5DpIYz",
        "colab_type": "code",
        "outputId": "d6ffc50d-ff17-4d4b-cabc-8574fec91d22",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 68
        }
      },
      "source": [
        "# Todas as colunas do dataframe\n",
        "dfs.columns"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Tipo de Alertas e Restrições', 'Nacionalidade', 'Mês/Ano', 'UF',\n",
              "       'Quantidade'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nZv5FTSApHzq",
        "colab_type": "code",
        "outputId": "000e0901-df30-4020-8d6a-9eca9421c0ce",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 119
        }
      },
      "source": [
        "# Após a importação e visualização, como serão as colunas e características do nosso Dataframe?\n",
        "dfs.dtypes"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Tipo de Alertas e Restrições    object\n",
              "Nacionalidade                   object\n",
              "Mês/Ano                         object\n",
              "UF                              object\n",
              "Quantidade                       int64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KvDUKjk6p3fv",
        "colab_type": "text"
      },
      "source": [
        "Informação **NACIONALIDADE**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gc5fA11SpGK2",
        "colab_type": "code",
        "outputId": "61b8cf0b-9b4a-4fb7-ce99-e2e9c543dce1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 612
        }
      },
      "source": [
        "# Para sabermos os valores únicos de uma determinada coluna, usamos o 'unique()'\n",
        "dfs['Nacionalidade'].unique()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['AFEGANISTÃO', 'ALBÂNIA', 'ALEMANHA', 'ANDORRA', 'ANGOLA',\n",
              "       'APÁTRIDA', 'ARGENTINA', 'ARGÉLIA', 'ARMÊNIA', 'ARÁBIA SAUDITA',\n",
              "       'AUSTRÁLIA', 'BANGLADESH', 'BARBADOS', 'BAREINE', 'BELARUS',\n",
              "       'BELIZE', 'BENIN', 'BHUTAN', 'BOLÍVIA', 'BRASIL', 'BULGÁRIA',\n",
              "       'BURKINA FASO', 'BURUNDI', 'BUTÃO', 'BÉLGICA',\n",
              "       'BÓSNIA E HERZEGOVINA', 'CABO VERDE', 'CAMARÕES', 'CAMBOJA',\n",
              "       'CANADÁ', 'CAZAQUISTÃO', 'CHILE', 'CHINA', 'COLÔMBIA', 'CONGO',\n",
              "       'CORÉIA DO NORTE', 'CORÉIA DO SUL', 'COSTA DO MARFIM',\n",
              "       'COSTA RICA', 'CROÁCIA', 'CUBA', 'DAOME', 'DINAMARCA', 'DJIBUTI',\n",
              "       'DOMINICA', 'EGITO', 'EL SALVADOR', 'EMIRADOS ÁRABES', 'EQUADOR',\n",
              "       'ERITRÉIA', 'ESLOVÁQUIA', 'ESPANHA', 'ESTADOS UNIDOS', 'ESTÔNIA',\n",
              "       'ETIÓPIA', 'FIJI, ILHAS', 'FILIPINAS', 'FRANÇA', 'GABÃO', 'GANA',\n",
              "       'GEÓRGIA', 'GRÉCIA', 'GUAM', 'GUATEMALA', 'GUIANA',\n",
              "       'GUIANA FRANCESA', 'GUINÉ', 'GUINÉ BISSAU', 'GUINÉ EQUATORIAL',\n",
              "       'GÂMBIA', 'HAITI', 'HONDURAS', 'HUNGRIA', 'INDONÉSIA', 'IRAQUE',\n",
              "       'IRLANDA', 'IRÃ', 'ISRAEL', 'ITÁLIA', 'IUGUSLAVIA', 'IÊMEN',\n",
              "       'JAMAICA', 'JAPÃO', 'JORDÂNIA', 'KUAITE', 'LAOS', 'LESOTO',\n",
              "       'LETÔNIA', 'LIBÉRIA', 'LITUÂNIA', 'LÍBANO', 'LÍBIA',\n",
              "       'MACAU (R.A.E.)', 'MACEDÔNIA', 'MALGAXE', 'MALI', 'MALTA',\n",
              "       'MALÁSIA', 'MARROCOS', 'MAURITÂNIA', 'MAURÍCIO', 'MONGÓLIA',\n",
              "       'MOÇAMBIQUE', 'MYANMAR', 'MÉXICO', 'NACIONALIDADE INDEFINIDA',\n",
              "       'NAMÍBIA', 'NEPAL', 'NICARÁGUA', 'NIGÉRIA', 'NORUEGA',\n",
              "       'NOVA ZELÂNDIA', 'NÍGER', 'PALESTINA', 'PANAMÁ', 'PAQUISTÃO',\n",
              "       'PARAGUAI', 'PAÍSES BAIXOS', 'PERU', 'POLÔNIA', 'PORTUGAL',\n",
              "       'QUÊNIA', 'REINO UNIDO', 'REP. CENTRO AFRICANA', 'REP. DOMINICANA',\n",
              "       'REPÚBLICA DEMOCRÁTICA DO CONGO', 'REPÚBLICA TCHECA', 'ROMÊNIA',\n",
              "       'RUANDA', 'RÚSSIA', 'SAARA OCIDENTAL\\n- SAARAUI, REPÚBLICA',\n",
              "       'SENEGAL', 'SERRA LEOA', 'SOMÁLIA', 'SRI LANKA',\n",
              "       'ST. PIERRE ET MIQUELON', 'SUDÃO', 'SURINAME', 'SUÉCIA', 'SUÍÇA',\n",
              "       'SÃO TOMÉ E PRÍNCIPE', 'SÉRVIA', 'SÍRIA', 'TAILÂNDIA', 'TAIWAN',\n",
              "       'TANZÂNIA', 'TOGO', 'TRINIDAD E TOBAGO', 'TUNÍSIA',\n",
              "       'TURCOMENISTÃO', 'TURQUIA', 'UCRÂNIA', 'UGANDA', 'UNIÃO SOVIÉTICA',\n",
              "       'URUGUAI', 'UZBEQUISTÃO', 'VANUATU', 'VATICANO', 'VENEZUELA',\n",
              "       'VIETNÃ', 'ZAIRE', 'ZIMBÁBUE', 'ZÂMBIA', 'ÁFRICA DO SUL', 'ÍNDIA'],\n",
              "      dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "g5bbn_u8p0q3",
        "colab_type": "code",
        "outputId": "b6abe90c-c29f-44ed-9d89-30046a20e490",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1071
        }
      },
      "source": [
        "# Agrupando dados, inicialmente por Nacionalidade\n",
        "dfs['Nacionalidade'].value_counts()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CUBA                                     887\n",
              "HAITI                                    775\n",
              "VENEZUELA                                665\n",
              "COLÔMBIA                                 556\n",
              "SENEGAL                                  469\n",
              "SÍRIA                                    466\n",
              "BANGLADESH                               385\n",
              "GUINÉ BISSAU                             371\n",
              "ANGOLA                                   343\n",
              "CONGO                                    337\n",
              "PAQUISTÃO                                325\n",
              "GANA                                     298\n",
              "NIGÉRIA                                  294\n",
              "REP. DOMINICANA                          289\n",
              "LÍBANO                                   255\n",
              "GUINÉ                                    219\n",
              "MARROCOS                                 178\n",
              "IRAQUE                                   164\n",
              "PALESTINA                                150\n",
              "ÍNDIA                                    147\n",
              "NACIONALIDADE INDEFINIDA                 144\n",
              "EGITO                                    137\n",
              "SERRA LEOA                               132\n",
              "TOGO                                     131\n",
              "CAMARÕES                                 124\n",
              "SOMÁLIA                                  122\n",
              "REPÚBLICA DEMOCRÁTICA DO CONGO           118\n",
              "CHINA                                    117\n",
              "GÂMBIA                                   116\n",
              "BOLÍVIA                                  113\n",
              "                                        ... \n",
              "SAARA OCIDENTAL\\n- SAARAUI, REPÚBLICA      2\n",
              "GEÓRGIA                                    2\n",
              "MALTA                                      2\n",
              "TURCOMENISTÃO                              2\n",
              "BAREINE                                    1\n",
              "MAURÍCIO                                   1\n",
              "BARBADOS                                   1\n",
              "ESLOVÁQUIA                                 1\n",
              "BELIZE                                     1\n",
              "MONGÓLIA                                   1\n",
              "CAMBOJA                                    1\n",
              "SUÍÇA                                      1\n",
              "NORUEGA                                    1\n",
              "IUGUSLAVIA                                 1\n",
              "MALGAXE                                    1\n",
              "CORÉIA DO NORTE                            1\n",
              "ESTÔNIA                                    1\n",
              "BÓSNIA E HERZEGOVINA                       1\n",
              "IRLANDA                                    1\n",
              "BUTÃO                                      1\n",
              "LAOS                                       1\n",
              "GUAM                                       1\n",
              "DAOME                                      1\n",
              "BÉLGICA                                    1\n",
              "BELARUS                                    1\n",
              "CROÁCIA                                    1\n",
              "LETÔNIA                                    1\n",
              "GABÃO                                      1\n",
              "ST. PIERRE ET MIQUELON                     1\n",
              "CANADÁ                                     1\n",
              "Name: Nacionalidade, Length: 165, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BFoh58aOqIx8",
        "colab_type": "code",
        "outputId": "2fec193d-46e4-4225-d07d-3bf9f41e3a74",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1969
        }
      },
      "source": [
        "#selecionando uma Nacionalidade específica\n",
        "dfs.loc[(dfs['Nacionalidade'] == 'BOLÍVIA')]"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Tipo de Alertas e Restrições</th>\n",
              "      <th>Nacionalidade</th>\n",
              "      <th>Mês/Ano</th>\n",
              "      <th>UF</th>\n",
              "      <th>Quantidade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1082</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>02/2002</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1083</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2002</td>\n",
              "      <td>SP</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1084</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2002</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1085</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2006</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1086</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2006</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1087</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>11/2008</td>\n",
              "      <td>AC</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1088</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>11/2008</td>\n",
              "      <td>DF</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1089</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>11/2008</td>\n",
              "      <td>RO</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1090</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>12/2008</td>\n",
              "      <td>AC</td>\n",
              "      <td>35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1091</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>12/2008</td>\n",
              "      <td>DF</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1092</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>12/2008</td>\n",
              "      <td>RO</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1093</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2009</td>\n",
              "      <td>AC</td>\n",
              "      <td>142</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1094</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2009</td>\n",
              "      <td>DF</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1095</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2009</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1096</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>02/2009</td>\n",
              "      <td>AC</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1097</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2009</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1098</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>04/2009</td>\n",
              "      <td>AC</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1099</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>04/2009</td>\n",
              "      <td>DF</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1100</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2009</td>\n",
              "      <td>AC</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1101</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2009</td>\n",
              "      <td>DF</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1102</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>08/2009</td>\n",
              "      <td>RO</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1103</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1104</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1105</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2010</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1106</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1107</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2010</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1108</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>08/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1109</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1110</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2010</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1111</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2010</td>\n",
              "      <td>AC</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1165</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2017</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1166</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2017</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1167</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2017</td>\n",
              "      <td>RJ</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1168</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2017</td>\n",
              "      <td>SP</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1169</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1170</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>02/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1171</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2018</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1172</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>04/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1173</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>05/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1174</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>05/2018</td>\n",
              "      <td>RR</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1175</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2018</td>\n",
              "      <td>AC</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1176</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2018</td>\n",
              "      <td>MG</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1177</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>06/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1178</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1179</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>08/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1180</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>08/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1181</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2018</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1182</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2018</td>\n",
              "      <td>MT</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1183</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>09/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1184</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1185</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2018</td>\n",
              "      <td>GO</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1186</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2018</td>\n",
              "      <td>RR</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1187</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2018</td>\n",
              "      <td>SC</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1188</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>12/2018</td>\n",
              "      <td>AC</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1189</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2019</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1190</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2019</td>\n",
              "      <td>MS</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1191</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2019</td>\n",
              "      <td>SP</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1192</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>02/2019</td>\n",
              "      <td>SP</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1193</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2019</td>\n",
              "      <td>RJ</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1194</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>03/2019</td>\n",
              "      <td>SP</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>113 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Tipo de Alertas e Restrições Nacionalidade  Mês/Ano  UF  Quantidade\n",
              "1082       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  02/2002  SP           1\n",
              "1083       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2002  SP           7\n",
              "1084       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2002  SP           1\n",
              "1085       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2006  SP           1\n",
              "1086       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2006  SP           1\n",
              "1087       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  11/2008  AC          16\n",
              "1088       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  11/2008  DF           3\n",
              "1089       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  11/2008  RO           3\n",
              "1090       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  12/2008  AC          35\n",
              "1091       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  12/2008  DF           5\n",
              "1092       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  12/2008  RO           1\n",
              "1093       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2009  AC         142\n",
              "1094       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2009  DF          25\n",
              "1095       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2009  MS           1\n",
              "1096       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  02/2009  AC           1\n",
              "1097       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2009  DF           1\n",
              "1098       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  04/2009  AC          11\n",
              "1099       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  04/2009  DF           2\n",
              "1100       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2009  AC           6\n",
              "1101       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2009  DF           2\n",
              "1102       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  08/2009  RO           1\n",
              "1103       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2010  AC           5\n",
              "1104       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2010  AC           4\n",
              "1105       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2010  MS           1\n",
              "1106       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2010  AC           1\n",
              "1107       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2010  MS           1\n",
              "1108       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  08/2010  AC           2\n",
              "1109       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2010  AC           5\n",
              "1110       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2010  MS           1\n",
              "1111       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2010  AC           3\n",
              "...                           ...           ...      ...  ..         ...\n",
              "1165       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2017  SP           1\n",
              "1166       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2017  DF           1\n",
              "1167       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2017  RJ           1\n",
              "1168       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2017  SP           2\n",
              "1169       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2018  AM           1\n",
              "1170       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  02/2018  SP           1\n",
              "1171       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2018  MS           1\n",
              "1172       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  04/2018  SP           1\n",
              "1173       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  05/2018  AM           1\n",
              "1174       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  05/2018  RR           1\n",
              "1175       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2018  AC           3\n",
              "1176       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2018  MG           1\n",
              "1177       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  06/2018  SP           1\n",
              "1178       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2018  AM           1\n",
              "1179       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  08/2018  AM           1\n",
              "1180       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  08/2018  SP           1\n",
              "1181       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2018  DF           1\n",
              "1182       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2018  MT           1\n",
              "1183       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  09/2018  SP           1\n",
              "1184       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2018  AM           4\n",
              "1185       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2018  GO           1\n",
              "1186       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2018  RR           1\n",
              "1187       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2018  SC           1\n",
              "1188       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  12/2018  AC           1\n",
              "1189       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2019  DF           1\n",
              "1190       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2019  MS           1\n",
              "1191       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2019  SP           2\n",
              "1192       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  02/2019  SP           3\n",
              "1193       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2019  RJ           2\n",
              "1194       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  03/2019  SP           1\n",
              "\n",
              "[113 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rW4l5-lzrPSO",
        "colab_type": "code",
        "outputId": "9afe8b19-083e-4e60-8307-ff0ee78a2f71",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        }
      },
      "source": [
        "dfs.loc[(dfs['Nacionalidade'] == 'BOLÍVIA')  & (dfs['UF'] =='AM')]"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Tipo de Alertas e Restrições</th>\n",
              "      <th>Nacionalidade</th>\n",
              "      <th>Mês/Ano</th>\n",
              "      <th>UF</th>\n",
              "      <th>Quantidade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1157</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2016</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1169</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>01/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1173</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>05/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1178</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>07/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1179</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>08/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1184</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>BOLÍVIA</td>\n",
              "      <td>10/2018</td>\n",
              "      <td>AM</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Tipo de Alertas e Restrições Nacionalidade  Mês/Ano  UF  Quantidade\n",
              "1157       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2016  AM           1\n",
              "1169       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  01/2018  AM           1\n",
              "1173       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  05/2018  AM           1\n",
              "1178       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  07/2018  AM           1\n",
              "1179       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  08/2018  AM           1\n",
              "1184       SOLICITAÇÃO DE REFÚGIO       BOLÍVIA  10/2018  AM           4"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hhkoktMiq38N",
        "colab_type": "code",
        "outputId": "d249edc3-0c4c-4e6b-fff4-c8f37e07e09c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 142
        }
      },
      "source": [
        "#selecionando + de 1 Nacionalidade específica\n",
        "dfs.loc[(dfs['Nacionalidade'] == 'UZBEQUISTÃO')  | (dfs['Nacionalidade'] =='ESTÔNIA')]"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Tipo de Alertas e Restrições</th>\n",
              "      <th>Nacionalidade</th>\n",
              "      <th>Mês/Ano</th>\n",
              "      <th>UF</th>\n",
              "      <th>Quantidade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3960</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>ESTÔNIA</td>\n",
              "      <td>12/2017</td>\n",
              "      <td>AM</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10693</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>UZBEQUISTÃO</td>\n",
              "      <td>07/2009</td>\n",
              "      <td>DF</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10694</th>\n",
              "      <td>SOLICITAÇÃO DE REFÚGIO</td>\n",
              "      <td>UZBEQUISTÃO</td>\n",
              "      <td>06/2018</td>\n",
              "      <td>SP</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Tipo de Alertas e Restrições Nacionalidade  Mês/Ano  UF  Quantidade\n",
              "3960        SOLICITAÇÃO DE REFÚGIO       ESTÔNIA  12/2017  AM           1\n",
              "10693       SOLICITAÇÃO DE REFÚGIO   UZBEQUISTÃO  07/2009  DF           1\n",
              "10694       SOLICITAÇÃO DE REFÚGIO   UZBEQUISTÃO  06/2018  SP           2"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LX-mg6y7sANw",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 493
        },
        "outputId": "f262a503-d66e-4f31-f311-1f804cc349f2"
      },
      "source": [
        "# Agrupando dados por Estado\n",
        "dfs['UF'].value_counts()"
      ],
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SP    3762\n",
              "DF    1296\n",
              "RJ     992\n",
              "PR     884\n",
              "RS     677\n",
              "SC     672\n",
              "AM     587\n",
              "RR     574\n",
              "AC     422\n",
              "MS     273\n",
              "MG     221\n",
              "CE     196\n",
              "GO     175\n",
              "MT     163\n",
              "BA     112\n",
              "RO     109\n",
              "PA     103\n",
              "ES      86\n",
              "PE      81\n",
              "RN      62\n",
              "AP      57\n",
              "MA      38\n",
              "PB      33\n",
              "TO      30\n",
              "AL      25\n",
              "SE      18\n",
              "PI       8\n",
              "Name: UF, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CRqJTQxxsYMP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 493
        },
        "outputId": "4226d148-2000-453b-a070-156ee00ea01f"
      },
      "source": [
        "dfs['UF'].value_counts(dropna=False, normalize=True)"
      ],
      "execution_count": 60,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SP    0.322752\n",
              "DF    0.111187\n",
              "RJ    0.085106\n",
              "PR    0.075841\n",
              "RS    0.058082\n",
              "SC    0.057653\n",
              "AM    0.050360\n",
              "RR    0.049245\n",
              "AC    0.036205\n",
              "MS    0.023421\n",
              "MG    0.018960\n",
              "CE    0.016815\n",
              "GO    0.015014\n",
              "MT    0.013984\n",
              "BA    0.009609\n",
              "RO    0.009351\n",
              "PA    0.008837\n",
              "ES    0.007378\n",
              "PE    0.006949\n",
              "RN    0.005319\n",
              "AP    0.004890\n",
              "MA    0.003260\n",
              "PB    0.002831\n",
              "TO    0.002574\n",
              "AL    0.002145\n",
              "SE    0.001544\n",
              "PI    0.000686\n",
              "Name: UF, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 60
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lXlFeM50uB59",
        "colab_type": "text"
      },
      "source": [
        "![logos](https://d1nhio0ox7pgb.cloudfront.net/_img/o_collection_png/green_dark_grey/256x256/plain/table.png)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LGEptXHasqTm",
        "colab_type": "text"
      },
      "source": [
        "Outro **Dataframe** agora ..."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "ogY0OYGBmvcu",
        "colab": {}
      },
      "source": [
        "# Tabela com decisões sobre pedidos de reconhecimento da condição de refugiado - ACNUR (1993-1997) e Conare (1998 a janeiro de 2019)\n",
        "# Fonte dos dados: http://dados.gov.br/dataset/comite-nacional-para-os-refugiados\n",
        "url1 = 'https://www.justica.gov.br/seus-direitos/refugio/anexos/decisoes-conare-ate-jan-2019.xlsx'"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "aYQnzRlumvcz",
        "colab": {}
      },
      "source": [
        "# Vamos utilizar os dados de 2019, no arquivo Excel há uma ABA chamada 'jan-2019'\n",
        "df19 = pd.read_excel(url1,enconding='latin',delimiter=\";\", sheet_name='jan-2019')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bDEumd4Rm707",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "7309313d-b3bd-4cd6-f78c-0c4b5406b8d4"
      },
      "source": [
        "df19.head()"
      ],
      "execution_count": 41,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>TOTAL= 115</th>\n",
              "      <th>STATUS</th>\n",
              "      <th>DATA SOLICITAÇÃO</th>\n",
              "      <th>PAÍS DE ORIGEM</th>\n",
              "      <th>GÊNERO</th>\n",
              "      <th>ANO DE NASCIMENTO</th>\n",
              "      <th>CIDADE SOLICITAÇÃO</th>\n",
              "      <th>DATA DA  DECISÃO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2014-11-05</td>\n",
              "      <td>PAQUISTÃO</td>\n",
              "      <td>M</td>\n",
              "      <td>1987</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2017-04-19</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>M</td>\n",
              "      <td>1996</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2002</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2007</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>M</td>\n",
              "      <td>2012</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   TOTAL= 115                    STATUS  ... CIDADE SOLICITAÇÃO DATA DA  DECISÃO\n",
              "0         NaN  ELIGIBILIDADE - DEFERIDO  ...           BRASÍLIA       2019-01-25\n",
              "1         NaN  ELIGIBILIDADE - DEFERIDO  ...             RECIFE       2019-01-25\n",
              "2         NaN  ELIGIBILIDADE - DEFERIDO  ...     BELO HORIZONTE       2019-01-25\n",
              "3         NaN  ELIGIBILIDADE - DEFERIDO  ...     BELO HORIZONTE       2019-01-25\n",
              "4         NaN  ELIGIBILIDADE - DEFERIDO  ...     BELO HORIZONTE       2019-01-25\n",
              "\n",
              "[5 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "wSXQ2DF4nEv-",
        "colab": {}
      },
      "source": [
        "df19 = df19.drop(['TOTAL= 115'], axis=1)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "outputId": "f3ac0dc8-2b4b-4acf-ca29-bed2ee30eb6e",
        "id": "5Xaz7Qn-ngyW",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "# quantidade de linhas e colunas do dataframe\n",
        "df19.shape"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(115, 7)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "outputId": "c2dceebf-1f37-4913-f8fc-8d9b08fe578a",
        "id": "7Tk1WpLbnEwh",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        }
      },
      "source": [
        "# as primeiras 5 linhas\n",
        "df19.head()"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>STATUS</th>\n",
              "      <th>DATA SOLICITAÇÃO</th>\n",
              "      <th>PAÍS DE ORIGEM</th>\n",
              "      <th>GÊNERO</th>\n",
              "      <th>ANO DE NASCIMENTO</th>\n",
              "      <th>CIDADE SOLICITAÇÃO</th>\n",
              "      <th>DATA DA  DECISÃO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2014-11-05</td>\n",
              "      <td>PAQUISTÃO</td>\n",
              "      <td>M</td>\n",
              "      <td>1987</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2017-04-19</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>M</td>\n",
              "      <td>1996</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2002</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2007</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2015-09-25</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>M</td>\n",
              "      <td>2012</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                     STATUS  ... DATA DA  DECISÃO\n",
              "0  ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "1  ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "2  ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "3  ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "4  ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "\n",
              "[5 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "outputId": "74748936-a7f0-427f-a0e1-67d75799ee2f",
        "id": "n1pvxaJrnEwm",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 153
        }
      },
      "source": [
        "# após a importação e visualização, como serão as colunas e características do nosso Dataframe?\n",
        "df19.dtypes"
      ],
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "STATUS                        object\n",
              "DATA SOLICITAÇÃO      datetime64[ns]\n",
              "PAÍS DE ORIGEM                object\n",
              "GÊNERO                        object\n",
              "ANO DE NASCIMENTO              int64\n",
              "CIDADE SOLICITAÇÃO            object\n",
              "DATA DA  DECISÃO      datetime64[ns]\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yKys98REoZPV",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 459
        },
        "outputId": "1eae6e32-2cec-4cc7-b341-ed07ae25bd15"
      },
      "source": [
        "df19['PAÍS DE ORIGEM'].value_counts()"
      ],
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SÍRIA                 41\n",
              "SENEGAL               11\n",
              "QUÊNIA                 9\n",
              "ANGOLA                 9\n",
              "BANGLADESH             8\n",
              "VENEZUELA              6\n",
              "REP. DEM. DO CONGO     4\n",
              "CUBA                   4\n",
              "UCRÂNIA                3\n",
              "NIGÉRIA                2\n",
              "PAQUISTÃO              2\n",
              "SERRA LEOA             2\n",
              "ÁFRICA DO SUL          2\n",
              "AFEGANISTAO            1\n",
              "TOGO                   1\n",
              "EQUADOR                1\n",
              "COLÔMBIA               1\n",
              "EGITO                  1\n",
              "GÂMBIA                 1\n",
              "GUINÉ-BISSAU           1\n",
              "GUIANA                 1\n",
              "MALI                   1\n",
              "HAITI                  1\n",
              "PALESTINA              1\n",
              "TUNÍSIA                1\n",
              "Name: PAÍS DE ORIGEM, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SA9XDyoZo72y",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 241
        },
        "outputId": "49fce76e-e7b0-4929-e223-805c40d8b3ed"
      },
      "source": [
        "#selecionando uma Nacionalidade específica\n",
        "df19.loc[(df19['PAÍS DE ORIGEM'] == 'CUBA')]"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>STATUS</th>\n",
              "      <th>DATA SOLICITAÇÃO</th>\n",
              "      <th>PAÍS DE ORIGEM</th>\n",
              "      <th>GÊNERO</th>\n",
              "      <th>ANO DE NASCIMENTO</th>\n",
              "      <th>CIDADE SOLICITAÇÃO</th>\n",
              "      <th>DATA DA  DECISÃO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ELIGIBILIDADE - DEFERIDO</td>\n",
              "      <td>2017-04-19</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>M</td>\n",
              "      <td>1996</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO ...</td>\n",
              "      <td>2017-03-16</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>F</td>\n",
              "      <td>2007</td>\n",
              "      <td>PERNAMBUCO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO ...</td>\n",
              "      <td>2017-03-16</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>F</td>\n",
              "      <td>1984</td>\n",
              "      <td>PERNAMBUCO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>110</th>\n",
              "      <td>EXTINÇÃO (DESISTÊNCIA SEM FORMULÁRIO PRÓPRIO)</td>\n",
              "      <td>2016-10-13</td>\n",
              "      <td>CUBA</td>\n",
              "      <td>M</td>\n",
              "      <td>1984</td>\n",
              "      <td>BOA VISTA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                STATUS  ... DATA DA  DECISÃO\n",
              "1                             ELIGIBILIDADE - DEFERIDO  ...       2019-01-25\n",
              "63   EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO ...  ...       2019-01-25\n",
              "64   EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO ...  ...       2019-01-25\n",
              "110      EXTINÇÃO (DESISTÊNCIA SEM FORMULÁRIO PRÓPRIO)  ...       2019-01-25\n",
              "\n",
              "[4 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PSEuEbIkpKm2",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 328
        },
        "outputId": "99e4f12c-5f55-4e5b-cf18-fba408e72a21"
      },
      "source": [
        "df19.loc[(df19['PAÍS DE ORIGEM'] == 'ANGOLA')]"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>STATUS</th>\n",
              "      <th>DATA SOLICITAÇÃO</th>\n",
              "      <th>PAÍS DE ORIGEM</th>\n",
              "      <th>GÊNERO</th>\n",
              "      <th>ANO DE NASCIMENTO</th>\n",
              "      <th>CIDADE SOLICITAÇÃO</th>\n",
              "      <th>DATA DA  DECISÃO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-06-26</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1970</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>80</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-04-05</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1975</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>81</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-08-27</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1995</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>83</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-09-13</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>F</td>\n",
              "      <td>1981</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>103</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-09-05</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1976</td>\n",
              "      <td>MACAÉ</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-01-14</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>F</td>\n",
              "      <td>1992</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-09-22</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1995</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-05-19</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1988</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-09-03</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1992</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         STATUS  ... DATA DA  DECISÃO\n",
              "77   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "80   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "81   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "83   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "103  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "104  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "106  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "107  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "108  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "\n",
              "[9 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LTzFgPs6rQUL",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 527
        },
        "outputId": "3393d9fd-f414-4396-8cd9-542ea51cba62"
      },
      "source": [
        "df19['CIDADE SOLICITAÇÃO'].value_counts()"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SÃO PAULO            49\n",
              "BELO HORIZONTE       10\n",
              "FLORIANÓPOLIS         8\n",
              "BRASILÉIA             5\n",
              "CAXIAS DO SUL         5\n",
              "MANAUS                3\n",
              "RIO BRANCO            3\n",
              "CAMPINAS              3\n",
              "GUAÍRA                2\n",
              "GUARAPUAVA            2\n",
              "RIO DE JANEIRO        2\n",
              "BRASÍLIA              2\n",
              "PERNAMBUCO            2\n",
              "CURITIBA              2\n",
              "PACARAÍMA             2\n",
              "GUARULHOS             2\n",
              "RECIFE                1\n",
              "NATAL                 1\n",
              "BOA VISTA             1\n",
              "JOÃO PESSOA           1\n",
              "AMAZONAS              1\n",
              "ANÁPOLIS              1\n",
              "BARRACÃO              1\n",
              "FORTALEZA             1\n",
              "ERECHIM               1\n",
              "VITÓRIA DO PALMAR     1\n",
              "VITÓRIA               1\n",
              "MARABÁ                1\n",
              "MACAÉ                 1\n",
              "Name: CIDADE SOLICITAÇÃO, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TEh6Cwsfn_zY",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 102
        },
        "outputId": "d3e6d67a-615d-46da-b4de-9b70f768332b"
      },
      "source": [
        "df19['STATUS'].value_counts()"
      ],
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ELIGIBILIDADE - DEFERIDO                                    61\n",
              "ELIGIBILIDADE - INDEFERIDO                                  45\n",
              "EXTINÇÃO (DESISTÊNCIA SEM FORMULÁRIO PRÓPRIO)                5\n",
              "EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO - DEFERIDO     4\n",
              "Name: STATUS, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FSvpyGqnqJhn",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 102
        },
        "outputId": "1502f31f-8f38-4f24-e0de-b656aed43e17"
      },
      "source": [
        "df19['STATUS'].value_counts(dropna=False, normalize=True)"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ELIGIBILIDADE - DEFERIDO                                    0.530435\n",
              "ELIGIBILIDADE - INDEFERIDO                                  0.391304\n",
              "EXTINÇÃO (DESISTÊNCIA SEM FORMULÁRIO PRÓPRIO)               0.043478\n",
              "EXTENSÃO DOS EFEITOS DA CONDIÇÃO DE REFUGIADO - DEFERIDO    0.034783\n",
              "Name: STATUS, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YpC0MSOkpb0K",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1444
        },
        "outputId": "8b28a789-efcf-4a71-c3df-461eb1775b22"
      },
      "source": [
        "df19.loc[(df19['STATUS'] == 'ELIGIBILIDADE - INDEFERIDO')]"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>STATUS</th>\n",
              "      <th>DATA SOLICITAÇÃO</th>\n",
              "      <th>PAÍS DE ORIGEM</th>\n",
              "      <th>GÊNERO</th>\n",
              "      <th>ANO DE NASCIMENTO</th>\n",
              "      <th>CIDADE SOLICITAÇÃO</th>\n",
              "      <th>DATA DA  DECISÃO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-06-12</td>\n",
              "      <td>ÁFRICA DO SUL</td>\n",
              "      <td>F</td>\n",
              "      <td>1964</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-12-07</td>\n",
              "      <td>REP. DEM. DO CONGO</td>\n",
              "      <td>M</td>\n",
              "      <td>1989</td>\n",
              "      <td>JOÃO PESSOA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-11-01</td>\n",
              "      <td>TUNÍSIA</td>\n",
              "      <td>M</td>\n",
              "      <td>1996</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-11-04</td>\n",
              "      <td>REP. DEM. DO CONGO</td>\n",
              "      <td>M</td>\n",
              "      <td>1980</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-12-01</td>\n",
              "      <td>MALI</td>\n",
              "      <td>M</td>\n",
              "      <td>1985</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-07-20</td>\n",
              "      <td>REP. DEM. DO CONGO</td>\n",
              "      <td>M</td>\n",
              "      <td>1985</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2012-01-10</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2010</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>72</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-07-29</td>\n",
              "      <td>GUIANA</td>\n",
              "      <td>M</td>\n",
              "      <td>1985</td>\n",
              "      <td>GUARULHOS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-06-09</td>\n",
              "      <td>GUINÉ-BISSAU</td>\n",
              "      <td>M</td>\n",
              "      <td>1981</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-12-31</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1994</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-09-29</td>\n",
              "      <td>TOGO</td>\n",
              "      <td>F</td>\n",
              "      <td>1970</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-04-24</td>\n",
              "      <td>GÂMBIA</td>\n",
              "      <td>M</td>\n",
              "      <td>1991</td>\n",
              "      <td>RIO BRANCO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-06-26</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1970</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-08-30</td>\n",
              "      <td>ÁFRICA DO SUL</td>\n",
              "      <td>F</td>\n",
              "      <td>1970</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-11-21</td>\n",
              "      <td>NIGÉRIA</td>\n",
              "      <td>M</td>\n",
              "      <td>1980</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>80</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-04-05</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1975</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>81</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-08-27</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1995</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>82</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-08-10</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1978</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>83</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-09-13</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>F</td>\n",
              "      <td>1981</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>84</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-06-30</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1985</td>\n",
              "      <td>RIO BRANCO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>85</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-01-28</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1978</td>\n",
              "      <td>BRASILÉIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>86</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-05-15</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1987</td>\n",
              "      <td>BRASILÉIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>87</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-07-14</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1977</td>\n",
              "      <td>RIO BRANCO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-04-14</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1976</td>\n",
              "      <td>BRASILÉIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-06-24</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1989</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-10-21</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1993</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-07-03</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1987</td>\n",
              "      <td>BRASILÉIA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>92</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-08-05</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1973</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-11-06</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1987</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-08-18</td>\n",
              "      <td>SENEGAL</td>\n",
              "      <td>M</td>\n",
              "      <td>1973</td>\n",
              "      <td>ERECHIM</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1985</td>\n",
              "      <td>GUAÍRA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-05-26</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1983</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-07-07</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1991</td>\n",
              "      <td>GUAÍRA</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-06-22</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1986</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-09-15</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1991</td>\n",
              "      <td>GUARULHOS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>100</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2018-01-16</td>\n",
              "      <td>BANGLADESH</td>\n",
              "      <td>M</td>\n",
              "      <td>1989</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>101</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-01-21</td>\n",
              "      <td>SERRA LEOA</td>\n",
              "      <td>M</td>\n",
              "      <td>1984</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>102</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2014-11-05</td>\n",
              "      <td>SERRA LEOA</td>\n",
              "      <td>M</td>\n",
              "      <td>1964</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>103</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2017-09-05</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1976</td>\n",
              "      <td>MACAÉ</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-01-14</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>F</td>\n",
              "      <td>1992</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>105</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-11-25</td>\n",
              "      <td>REP. DEM. DO CONGO</td>\n",
              "      <td>M</td>\n",
              "      <td>1975</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-09-22</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1995</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2015-05-19</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1988</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-09-03</td>\n",
              "      <td>ANGOLA</td>\n",
              "      <td>M</td>\n",
              "      <td>1992</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>109</th>\n",
              "      <td>ELIGIBILIDADE - INDEFERIDO</td>\n",
              "      <td>2016-01-01</td>\n",
              "      <td>QUÊNIA</td>\n",
              "      <td>F</td>\n",
              "      <td>2010</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>2019-01-25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         STATUS  ... DATA DA  DECISÃO\n",
              "65   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "66   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "67   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "68   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "69   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "70   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "71   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "72   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "73   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "74   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "75   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "76   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "77   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "78   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "79   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "80   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "81   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "82   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "83   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "84   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "85   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "86   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "87   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "88   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "89   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "90   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "91   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "92   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "93   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "94   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "95   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "96   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "97   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "98   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "99   ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "100  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "101  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "102  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "103  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "104  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "105  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "106  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "107  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "108  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "109  ELIGIBILIDADE - INDEFERIDO  ...       2019-01-25\n",
              "\n",
              "[45 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 52
        }
      ]
    }
  ]
}