{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "CNR_.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": [ "\"Open" ] }, { "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": "noSxPUrDk5nr", "colab_type": "text" }, "source": [ "Hoje teremos contato com os conceitos/prática de **Dados Abertos** e realizaremos uma análise exploratória usando comandos do **Python** via [Colab.research](https://colab.research.google.com/notebooks/welcome.ipynb)" ] }, { "cell_type": "markdown", "metadata": { "id": "BY2GUknMk57C", "colab_type": "text" }, "source": [ "Para tanto usaremos conceitos de **Dataframe!?!?!**

\n" ] }, { "cell_type": "markdown", "metadata": { "id": "u14PG0A8lCD4", "colab_type": "text" }, "source": [ "**Estruturas de dados no Pandas**

\n", "**Séries :**

\n", "Uma matriz uni-dimensional capaz de conter qualquer tipo de dado

\n", "s = pd.Series([3, -5, 7, 4], index=[‘a’, ‘b’, ‘c’, ‘d’])

\n", " \n", "![alt text](https://www.vooo.pro/insights/wp-content/uploads/2018/01/pandas1.png)\n", " \n", "**Frame de dados (Data frame) :**

\n", "Uma estrutura de dados bi-dimensional com colunas de diferentes tipos

\n", "\n", "data = {‘País’: [‘Portugal’, ‘Peru’, ‘Chile’], ‘Capital’: [‘Lisboa’, ‘Lima’, ‘Santiago’], ‘População’: [751000, 1120000, 695000]}

\n", "df = pd.DataFrame(data, columns=[‘País’, ‘Capital’, ‘População’])

\n", " \n", "![alt text](https://www.vooo.pro/insights/wp-content/uploads/2018/01/pandas2.png)\n", " \n", "[fonte](https://www.vooo.pro/insights/guia-de-acesso-rapido-ao-pandas/)" ] }, { "cell_type": "markdown", "metadata": { "id": "B9jRomyCk3R3", "colab_type": "text" }, "source": [ "![logos](https://cdn.iconscout.com/icon/premium/png-256-thumb/import-data-832046.png)

\n", "Vamos importar os arquivos para o nosso 'ambiente':

\n", " - 'conare.csv'

\n", " - 'decisoes-conare-ate-jan-2019.xlsx'

\n", " - '1990-a-2019-solicitacoes-de-reconhecimento-da-condicao-de-refugiado.xlsx'

\n" ] }, { "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", "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 }, "outputId": "c1aae1e0-9507-4953-b89e-b3612c91630e" }, "source": [ "from google.colab import files\n", "uploaded = files.upload()" ], "execution_count": 2, "outputs": [ { "output_type": "display_data", "data": { "text/html": [ "\n", " \n", " \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", " \n", " " ], "text/plain": [ "" ] }, "metadata": { "tags": [] } }, { "output_type": "stream", "text": [ "Saving conare.csv to conare (2).csv\n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "hXjburH4wFbF", "colab_type": "code", "colab": {} }, "source": [ "dfc = pd.read_csv(io.BytesIO(uploaded['conare.csv']),encoding ='latin', delimiter=\";\")" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "VXJ7_lVCwXij", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 309 }, "outputId": "ee38921b-5c17-43c4-a0e6-caba597698c4" }, "source": [ "dfc.head()" ], "execution_count": 5, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "

\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StatusProtocoloAno SolicitaçãoSEINome SolicitanteSexoEstado CivilData NascimentoIdade SolicitaçãoPaís de OrigemContinenteData SolicitaçãoCidade SolicitaçãoUF SolicitaçãoData DecisãoAno DecisãoMotivo ArquivamentoData Arquivamento
0ARQUIVADOS12015SIM1MASCULINOSOLTEIRO(A)12/07/196846TANZÂNIAÁfrica1/29/2015São PauloSP11/20/20152015Outros09/11/2015
1ARQUIVADOS22013SIM2FEMININOVIÚVO(A)04/11/195162NIGÉRIAÁfrica6/26/2013São PauloSP11/20/20152015Decisão Cnig Res. 271/19/2016
2ARQUIVADOS32013SIM3FEMININOMENOR10/08/20057COLÔMBIAAmérica Do Sul09/11/2013TabatingaAMNaNNão JulgadoDesistência Voluntária04/04/2016
3ARQUIVADOS42013SIM4FEMININOMENOR11/06/20075COLÔMBIAAmérica Do Sul09/11/2013TabatingaAMNaNNão JulgadoDesistência Voluntária04/04/2016
4ARQUIVADOS52013SIM5MASCULINOCASADO(A)08/04/197637COLÔMBIAAmérica Do Sul09/11/2013TabatingaAMNaNNão JulgadoDesistência Voluntária04/04/2016
\n", "
" ], "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": 5 } ] }, { "cell_type": "markdown", "metadata": { "id": "I2r8pex1wv-h", "colab_type": "text" }, "source": [ "Informação **CONTINENTE**" ] }, { "cell_type": "code", "metadata": { "id": "0NsaZo88wrwl", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 51 }, "outputId": "f68eb349-703b-4c2f-d70d-d5b978220b0c" }, "source": [ "# Para sabermos os valores únicos de uma determinada coluna, usamos o 'unique()'\n", "dfc['Continente'].unique()" ], "execution_count": 7, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "array(['África', 'América Do Sul', 'Ásia', 'América Central', 'Europa',\n", " 'Oriente Médio', 'Apátrida', 'América Do Norte'], dtype=object)" ] }, "metadata": { "tags": [] }, "execution_count": 7 } ] }, { "cell_type": "code", "metadata": { "id": "X7omtbGowtld", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 170 }, "outputId": "477fe36b-5699-4949-8a89-fc68f16e7a4c" }, "source": [ "# Agrupando dados, inicialmente por Continente\n", "dfc['Continente'].value_counts()" ], "execution_count": 8, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "África 21070\n", "Ásia 5815\n", "Oriente Médio 5586\n", "América Do Sul 3132\n", "América Central 2142\n", "Europa 990\n", "América Do Norte 35\n", "Apátrida 12\n", "Name: Continente, dtype: int64" ] }, "metadata": { "tags": [] }, "execution_count": 8 } ] }, { "cell_type": "code", "metadata": { "id": "A9YHgPrvwtve", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 170 }, "outputId": "1b99ed1e-301a-426e-90a5-1856e011cc33" }, "source": [ "# Valores contados também podem ser normalizados para expressar porcentagens\n", "dfc[\"Continente\"].value_counts(normalize=True)" ], "execution_count": 9, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "África 0.543293\n", "Ásia 0.149941\n", "Oriente Médio 0.144036\n", "América Do Sul 0.080759\n", "América Central 0.055232\n", "Europa 0.025527\n", "América Do Norte 0.000902\n", "Apátrida 0.000309\n", "Name: Continente, dtype: float64" ] }, "metadata": { "tags": [] }, "execution_count": 9 } ] }, { "cell_type": "code", "metadata": { "id": "CRlrCaobwt5V", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 360 }, "outputId": "5dbda178-8565-4129-f427-77c349eaf604" }, "source": [ "dfc[\"Continente\"].value_counts().plot.bar(title=\"Continentes\")\n", "plt.show()" ], "execution_count": 11, "outputs": [ { "output_type": "display_data", "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAFXCAYAAABJIIJRAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3Xm4nHV99/H3B1BABQFJKassjVrk\nkcUIsWpFqLK4gNYFtBAtNVKh4mOt4NJiqVRqrbVYxQslGlxAeACNGsVIFcTKEiQS1hK2khggisqi\nooHP88f9GzI595wlmcm578n5vK5rrjPzu5f5nuSc853fLttERER026DpACIion2SHCIioibJISIi\napIcIiKiJskhIiJqkhwiIqImySFiLUi6QdL+TccRsa4kOcR6RdIbJS2U9JCk5ZK+JemFfd7z85I+\n1F1m+9m2v99XsBN77zsl/dm6fp+IkZIcYr0h6V3Ax4F/BrYBdgI+BRzWZFwRwyjJIdYLkp4KnAIc\nZ/tC2w/b/r3tr9v+O0kbS/q4pJ+Wx8clbVyu3V/SUkl/K+m+UuN4Szk2G3gT8J5SG/l6KX/8E72k\nD0o6T9LZkh4sTU4zumLbTtIFklZIukPSO7qOjXqtpC9QJbivl/d+TymfKem/Jf1S0k+6m7ckvVnS\n7eVed0h60zr9h4/1VpJDrC+eD2wCXDTK8fcDM4G9gD2BfYEPdB3/Q+CpwPbAMcAnJW1p+0zgS8BH\nbD/F9itHuf+rgHOBLYB5wH8CSNoA+Drwk3LvA4F3SjpovGttHwX8L/DK8t4fkbQ98E3gQ8BWwLuB\nCyRNk/Rk4HTgENubAX8CLBrzXy1iFEkOsb54GvAz2ytHOf4m4BTb99leAfwjcFTX8d+X47+3PR94\nCHjmGrz/5bbn234U+AJVAgJ4HjDN9im2f2f7duAzwBETuLaXvwDml/Mfs70AWAgcWo4/BuwhaVPb\ny23fsAbfQ8TjkhxiffFzYGtJG41yfDvgrq7Xd5Wyx68fkVh+DTxlDd7/nhHXblJieTqwXWkC+qWk\nXwLvo+oTGe/aXp4OvG7E/V4IbGv7YeANwLHAcknflPSsNfgeIh6X5BDrix8BjwCHj3L8p1R/WDt2\nKmUT0c/SxXcDd9jeouuxme1Dx72y93vfDXxhxP2ebPs0ANsX234psC1wM1UtJWKNJTnEesH2r4B/\noOorOFzSkyQ9QdIhkj4CnAN8oLTNb13O/eIEb38vsOtahnYV8KCkEyVtKmlDSXtIet5avvcXgVdK\nOqjca5PSob6DpG0kHVb6Hh6hahp7bC3jjikuySHWG7b/DXgXVUfzCqpP2ccDX6XqwF0IXAcsBn5c\nyibiLGD30ozz1TWM6VHgFVQd4XcAPwM+S9X5PREfpkpqv5T0btt3Uw3NfR+rvse/o/pd3oDq+/8p\ncD/wYuCv1yTeiA5ls5+IiBgpNYeIiKhJcoiIiJokh4iIqElyiIiImtEm2rTe1ltv7Z133rnpMCIi\nhso111zzM9vTxjtvaJPDzjvvzMKFC5sOIyJiqEi6a/yz0qwUERE9JDlERERNkkNERNQkOURERE2S\nQ0RE1CQ5RERETZJDRETUJDlERERNkkNERNQM7Qzpidr5pG8O/J53nvbygd8zIqJNUnOIiIiaJIeI\niKhJcoiIiJokh4iIqElyiIiImiSHiIioGTc5SNpR0vck3SjpBkknlPKtJC2QdGv5umUpl6TTJS2R\ndJ2kfbruNaucf6ukWV3lz5W0uFxzuiSti282IiImZiI1h5XA39reHZgJHCdpd+Ak4BLb04FLymuA\nQ4Dp5TEbOAOqZAKcDOwH7Auc3Eko5Zy3dl13cP/fWkRErK1xk4Pt5bZ/XJ4/CNwEbA8cBswtp80F\nDi/PDwPOduUKYAtJ2wIHAQts32/7F8AC4OBybHPbV9g2cHbXvSIiogFr1OcgaWdgb+BKYBvby8uh\ne4BtyvPtgbu7LltaysYqX9qjvNf7z5a0UNLCFStWrEnoERGxBiacHCQ9BbgAeKftB7qPlU/8HnBs\nNbbPtD3D9oxp06at67eLiJiyJpQcJD2BKjF8yfaFpfje0iRE+XpfKV8G7Nh1+Q6lbKzyHXqUR0RE\nQyYyWknAWcBNtj/WdWge0BlxNAv4Wlf50WXU0kzgV6X56WLgZZK2LB3RLwMuLscekDSzvNfRXfeK\niIgGTGRV1hcARwGLJS0qZe8DTgPOk3QMcBfw+nJsPnAosAT4NfAWANv3S/on4Opy3im27y/P3w58\nHtgU+FZ5REREQ8ZNDrYvB0abd3Bgj/MNHDfKveYAc3qULwT2GC+WiIiYHJkhHRERNUkOERFRk+QQ\nERE1SQ4REVGT5BARETVJDhERUZPkEBERNUkOERFRk+QQERE1SQ4REVGT5BARETVJDhERUZPkEBER\nNUkOERFRk+QQERE1SQ4REVEzkW1C50i6T9L1XWVfkbSoPO7s7BAnaWdJv+k69umua54rabGkJZJO\nL1uCImkrSQsk3Vq+brkuvtGIiJi4idQcPg8c3F1g+w2297K9F3ABcGHX4ds6x2wf21V+BvBWYHp5\ndO55EnCJ7enAJeV1REQ0aNzkYPsy4P5ex8qn/9cD54x1D0nbApvbvqJsI3o2cHg5fBgwtzyf21Ue\nEREN6bfP4UXAvbZv7SrbRdK1ki6V9KJStj2wtOucpaUMYBvby8vze4BtRnszSbMlLZS0cMWKFX2G\nHhERo+k3ORzJ6rWG5cBOtvcG3gV8WdLmE71ZqVV4jONn2p5he8a0adPWNuaIiBjHRmt7oaSNgNcA\nz+2U2X4EeKQ8v0bSbcAzgGXADl2X71DKAO6VtK3t5aX56b61jSkiIgajn5rDnwE32368uUjSNEkb\nlue7UnU8316ajR6QNLP0UxwNfK1cNg+YVZ7P6iqPiIiGTGQo6znAj4BnSloq6Zhy6AjqHdF/ClxX\nhrb+P+BY253O7LcDnwWWALcB3yrlpwEvlXQrVcI5rY/vJyIiBmDcZiXbR45S/uYeZRdQDW3tdf5C\nYI8e5T8HDhwvjoiImDyZIR0RETVJDhERUZPkEBERNUkOERFRk+QQERE1SQ4REVGT5BARETVJDhER\nUZPkEBERNUkOERFRk+QQERE1SQ4REVGT5BARETVJDhERUZPkEBERNRPZ7GeOpPskXd9V9kFJyyQt\nKo9Du469V9ISSbdIOqir/OBStkTSSV3lu0i6spR/RdITB/kNRkTEmptIzeHzwME9yv/d9l7lMR9A\n0u5UO8Q9u1zzKUkblq1DPwkcAuwOHFnOBfiXcq8/An4BHDPyjSIiYnKNmxxsXwbcP955xWHAubYf\nsX0H1Zag+5bHEtu32/4dcC5wWNlP+gCqLUUB5gKHr+H3EBERA9ZPn8Pxkq4rzU5blrLtgbu7zlla\nykYrfxrwS9srR5T3JGm2pIWSFq5YsaKP0CMiYixrmxzOAHYD9gKWA/82sIjGYPtM2zNsz5g2bdpk\nvGVExJS00dpcZPveznNJnwG+UV4uA3bsOnWHUsYo5T8HtpC0Uak9dJ8fERENWauag6Rtu16+GuiM\nZJoHHCFpY0m7ANOBq4CrgellZNITqTqt59k28D3gteX6WcDX1iamiIgYnHFrDpLOAfYHtpa0FDgZ\n2F/SXoCBO4G3Adi+QdJ5wI3ASuA424+W+xwPXAxsCMyxfUN5ixOBcyV9CLgWOGtg311ERKyVcZOD\n7SN7FI/6B9z2qcCpPcrnA/N7lN9ONZopIiJaIjOkIyKiJskhIiJqkhwiIqImySEiImqSHCIioibJ\nISIiapIcIiKiJskhIiJqkhwiIqImySEiImqSHCIioibJISIiapIcIiKiJskhIiJqkhwiIqImySEi\nImrGTQ6S5ki6T9L1XWX/KulmSddJukjSFqV8Z0m/kbSoPD7ddc1zJS2WtETS6ZJUyreStEDSreXr\nluviG42IiImbSM3h88DBI8oWAHvYfg7wP8B7u47dZnuv8ji2q/wM4K1U+0pP77rnScAltqcDl5TX\nERHRoHGTg+3LgPtHlH3H9sry8gpgh7HuIWlbYHPbV9g2cDZweDl8GDC3PJ/bVR4REQ0ZRJ/DXwLf\n6nq9i6RrJV0q6UWlbHtgadc5S0sZwDa2l5fn9wDbjPZGkmZLWihp4YoVKwYQekRE9NJXcpD0fmAl\n8KVStBzYyfbewLuAL0vafKL3K7UKj3H8TNszbM+YNm1aH5FHRMRYNlrbCyW9GXgFcGD5o47tR4BH\nyvNrJN0GPANYxupNTzuUMoB7JW1re3lpfrpvbWOKiIjBWKuag6SDgfcAr7L9667yaZI2LM93pep4\nvr00Gz0gaWYZpXQ08LVy2TxgVnk+q6s8IiIaMm7NQdI5wP7A1pKWAidTjU7aGFhQRqReUUYm/Slw\niqTfA48Bx9rudGa/nWrk06ZUfRSdforTgPMkHQPcBbx+IN9ZRESstXGTg+0jexSfNcq5FwAXjHJs\nIbBHj/KfAweOF0dEREyezJCOiIiaJIeIiKhJcoiIiJokh4iIqElyiIiImiSHiIioSXKIiIiaJIeI\niKhJcoiIiJokh4iIqElyiIiImiSHiIioSXKIiIiaJIeIiKhJcoiIiJoJJQdJcyTdJ+n6rrKtJC2Q\ndGv5umUpl6TTJS2RdJ2kfbqumVXOv1XSrK7y50paXK45vewWFxERDZlozeHzwMEjyk4CLrE9Hbik\nvAY4hGp70OnAbOAMqJIJ1S5y+wH7Aid3Eko5561d1418r4iImEQTSg62LwPuH1F8GDC3PJ8LHN5V\nfrYrVwBbSNoWOAhYYPt+278AFgAHl2Ob277CtoGzu+4VEREN6KfPYRvby8vze4BtyvPtgbu7zlta\nysYqX9qjPCIiGjKQDunyid+DuNdYJM2WtFDSwhUrVqzrt4uImLL6SQ73liYhytf7SvkyYMeu83Yo\nZWOV79CjvMb2mbZn2J4xbdq0PkKPiIix9JMc5gGdEUezgK91lR9dRi3NBH5Vmp8uBl4macvSEf0y\n4OJy7AFJM8sopaO77hUREQ3YaCInSToH2B/YWtJSqlFHpwHnSToGuAt4fTl9PnAosAT4NfAWANv3\nS/on4Opy3im2O53cb6caEbUp8K3yiIiIhkwoOdg+cpRDB/Y418Bxo9xnDjCnR/lCYI+JxBIREete\nZkhHRERNkkNERNQkOURERE2SQ0RE1CQ5RERETZJDRETUJDlERERNkkNERNQkOURERE2SQ0RE1CQ5\nRERETZJDRETUJDlERERNkkNERNQkOURERE2SQ0RE1Kx1cpD0TEmLuh4PSHqnpA9KWtZVfmjXNe+V\ntETSLZIO6io/uJQtkXRSv99URET0Z0I7wfVi+xZgLwBJGwLLgIuotgX9d9sf7T5f0u7AEcCzge2A\n70p6Rjn8SeClwFLgaknzbN+4trFFRER/1jo5jHAgcJvtuySNds5hwLm2HwHukLQE2LccW2L7dgBJ\n55ZzkxwiIhoyqD6HI4Bzul4fL+k6SXMkbVnKtgfu7jpnaSkbrbxG0mxJCyUtXLFixYBCj4iIkfpO\nDpKeCLwKOL8UnQHsRtXktBz4t37fo8P2mbZn2J4xbdq0Qd02IiJGGESz0iHAj23fC9D5CiDpM8A3\nystlwI5d1+1QyhijPCIiGjCIZqUj6WpSkrRt17FXA9eX5/OAIyRtLGkXYDpwFXA1MF3SLqUWckQ5\nNyIiGtJXzUHSk6lGGb2tq/gjkvYCDNzZOWb7BknnUXU0rwSOs/1ouc/xwMXAhsAc2zf0E1dERPSn\nr+Rg+2HgaSPKjhrj/FOBU3uUzwfm9xNLREQMTmZIR0RETZJDRETUJDlERERNkkNERNQkOURERE2S\nQ0RE1CQ5RERETZJDRETUJDlERERNkkNERNQkOURERM2gdoKLPu180jcHfs87T3v5wO8ZEVNDag4R\nEVGTmkOskdRwIqaG1BwiIqJmEHtI3ylpsaRFkhaWsq0kLZB0a/m6ZSmXpNMlLZF0naR9uu4zq5x/\nq6RZ/cYVERFrb1A1h5fY3sv2jPL6JOAS29OBS8prqPabnl4es4EzoEomwMnAfsC+wMmdhBIREZNv\nXTUrHQbMLc/nAod3lZ/tyhXAFmXP6YOABbbvt/0LYAFw8DqKLSIixjGI5GDgO5KukTS7lG1je3l5\nfg+wTXm+PXB317VLS9lo5RER0YBBjFZ6oe1lkv4AWCDp5u6Dti3JA3gfSvKZDbDTTjsN4pYREdFD\n3zUH28vK1/uAi6j6DO4tzUWUr/eV05cBO3ZdvkMpG6185HudaXuG7RnTpk3rN/SIiBhFX8lB0pMl\nbdZ5DrwMuB6YB3RGHM0CvlaezwOOLqOWZgK/Ks1PFwMvk7Rl6Yh+WSmLiIgG9NustA1wkaTOvb5s\n+9uSrgbOk3QMcBfw+nL+fOBQYAnwa+AtALbvl/RPwNXlvFNs399nbBERsZb6Sg62bwf27FH+c+DA\nHuUGjhvlXnOAOf3EExERg5EZ0hERUZPkEBERNUkOERFRk+QQERE1SQ4REVGT5BARETVJDhERUZPk\nEBERNUkOERFRk+QQERE1SQ4REVGT5BARETVJDhERUTOIneAiWmfnk7458HveedrLB37PiLZKzSEi\nImqSHCIiomatk4OkHSV9T9KNkm6QdEIp/6CkZZIWlcehXde8V9ISSbdIOqir/OBStkTSSf19SxER\n0a9++hxWAn9r+8dlH+lrJC0ox/7d9ke7T5a0O3AE8GxgO+C7kp5RDn8SeCmwFLha0jzbN/YRW0RE\n9GGtk4Pt5cDy8vxBSTcB249xyWHAubYfAe6QtATYtxxbUrYcRdK55dwkh4iIhgykz0HSzsDewJWl\n6HhJ10maI2nLUrY9cHfXZUtL2Wjlvd5ntqSFkhauWLFiEKFHREQPfScHSU8BLgDeafsB4AxgN2Av\nqprFv/X7Hh22z7Q9w/aMadOmDeq2ERExQl/zHCQ9gSoxfMn2hQC27+06/hngG+XlMmDHrst3KGWM\nUR4REQ3oZ7SSgLOAm2x/rKt8267TXg1cX57PA46QtLGkXYDpwFXA1cB0SbtIeiJVp/W8tY0rIiL6\n10/N4QXAUcBiSYtK2fuAIyXtBRi4E3gbgO0bJJ1H1dG8EjjO9qMAko4HLgY2BObYvqGPuCKGRmZy\nR1v1M1rpckA9Ds0f45pTgVN7lM8f67qIiJhcmSEdERE1SQ4REVGT5BARETVJDhERUZPkEBERNUkO\nERFRk+QQERE1SQ4REVGT5BARETV9LbwXEVPDoJf5yBIf7ZeaQ0RE1CQ5RERETZJDRETUJDlERERN\nkkNERNQkOURERE1rkoOkgyXdImmJpJOajiciYiprRXKQtCHwSeAQYHeqrUZ3bzaqiIipqxXJAdgX\nWGL7dtu/A84FDms4poiIKUu2m44BSa8FDrb9V+X1UcB+to8fcd5sYHZ5+UzglgGHsjXwswHfc10Y\nhjiHIUZInIOWOAdrXcT5dNvTxjtpqJbPsH0mcOa6ur+khbZnrKv7D8owxDkMMULiHLTEOVhNxtmW\nZqVlwI5dr3coZRER0YC2JIergemSdpH0ROAIYF7DMUVETFmtaFayvVLS8cDFwIbAHNs3NBDKOmuy\nGrBhiHMYYoTEOWiJc7Aai7MVHdIREdEubWlWioiIFklyiIiImiSHiIioaUWHdAw/SU8FPgi8qBRd\nCpxi+1eNBdVF0mKgVwebANt+ziSH1NOwxDmMJD0dmG77u5I2BTay/WDTcbXVlO+QlrQlMB3YpFNm\n+7LmIuqt7XFKugC4Hphbio4C9rT9muaiWqX8YRiV7bsmK5axDEucIw3Bz+dbqVZX2Mr2bpKmA5+2\nfWDDoa1G0jTgRKo15rr/LQ+Y7FimdM1B0l8BJ1BNulsEzAR+BEz6f8RYhiTO3Wz/edfrf5S0qLFo\nRmjrH9WRhiXObkPy83kc1RpuVwLYvlXSHzQbUk9fAr4CvBw4FpgFrGgikKne53AC8DzgLtsvAfYG\nftlsSD0NQ5y/kfTCzgtJLwB+02A8PUl6UNID5fFbSY9KeqDpuEaSNFPS1ZIekvS7tsZZDMPP5yNl\nUU8AJG1E7+a7pj3N9lnA721favsvaSjJTumaA/Bb27+VhKSNbd8s6ZlNB9XDMMT518Dc0vcg4H7g\nzY1G1IPtzTrPJYlq9d+ZzUU0qv+kWingfGAGcDTwjEYjGt0w/HxeKul9wKaSXgq8Hfh6wzH18vvy\ndbmklwM/BbZqIpCpnhyWStoC+CqwQNIvgDZW61sfp+1FwJ6SNi+v2/op93GuOty+KulkoHUbTNle\nImlD248Cn5N0LfDepuPqofU/n1T/v8cAi4G3AfNtf6bZkHr6UPmA9bfAJ4DNgf/bRCBTvkO6Q9KL\ngacC3+6ufrZN2+KU9Be2vyjpXb2O2/7YZMc0FkndHeQbUH0qf7Ht5zcUUk+SLgP+DPgscA+wHHiz\n7T0bDWwcbfv57JB0gu3/GK8sVpnSNQdJM4EbbD9o+9LyqXdvSqdV0yRtbvsBSd3VysXl61Oomm6a\n9uTydbMxz2qPV3Y9XwncSTs3ljqKKnkdT/XJcUfgz8e8okGS9gFeSNWO/8M2JYZiFjAyEby5R1kj\nJH2CMfpAbL9jEsMBpnjNoVTT9ynNC0jaAFhoe59mI6tI+obtV0i6g+oHR12HbXvXhkKLdahsm3u2\n7Tc1HctESPoH4HXAhaXocOB82x9qLqqKpCOBN1LNv+keWrsZ8FhbhrJKmlWevoBqGOtXyuvXATfa\nPnbSY5riyWGR7b1GlF2XiUYTJ+n0sY438YmnlzLO/ftlCKOAs6g+id9F1Vzz40YDHEHS5cABLfwE\nXiPpFqo5Lb8trzcFFtluvFO6zBvZBfgwq/crPQhcZ3tlI4GNQtIVwAs7cUl6AvAD25M+aGJKNysB\nt0t6B3BGef124PYG4+mpDAtdZPthSX8B7AN83Pb/NhwawDXla89PPI1E1NsJwOfL8yOBPYFdqZoR\n/4NVM7vb4nbgh5LmAQ93CtvWh1P8lGrC1m/L641pyWZdtu+StJRqRNWlTcczAVtSdUJ3moyfUsom\n3VRPDscCpwMfoGq2uYRVe1S3yRlUI4H2pBrF8FngC8CLG40KsD0XQNJfs/onnk8DP2gythFW2u4M\nE3wFVbPNz4HvSvpIg3GN5rby2IBV/Tltreb/CrhB0gKqGF8KXNWpVTZde7T9qKTHJD21Lcu5jOE0\n4FpJ36NqRv5TqmVpJt2UTg6276MaS952K21b0mHAf9o+S9IxTQc1Qms+8YziMUnbAr8ADgRO7Tq2\naTMhjelG2+d3F0h6XVPBjOOi8uj4fkNxjOUhYHFJYN01sVY0e3bY/pykbwH7laITbd/TRCxTMjlI\neo/tj4w2QqBtPzDAg5LeSzWC5UWl47xt/3et+cQzin8AFlLtNDivs9NgGXrZuqZEqvkM50+grHG2\n56ra3rczSe+WrlpaW1zIqg7z1pH0rDJ5sDMY5u7ydTtJ2zXRJzYlO6QlvdL217tGCKym01TSFpL+\nkGrExVW2L5f0p8DnbO/WcGirKXF2PvFc2dQnntGUJRM2s/2LrrInU/0ePNRcZKtIOgQ4FHg9q/pv\noKqV7W5730YCG4Ok/akWXLyT6oPBjsCsNi28B9DmBCbpTNuzy4erkdzEwntTMjnA48MF/8X2u5uO\nZSIk7U2VIF4H3AFcaPsTzUa1ShkB9CZgV9unSNoJ+EPbVzUc2lAp/Up7AadQ1XY6HgS+153Y2kLS\nNcAbbd9SXj8DOMf2c5uNbJVhSGClReD5tn/YdCwwhZMDgKQftW1mLICkP7H93+WX7Mjy+BnVJ8l3\n2x5zWefJomqhvR+VDr8zgMeohl/+saolnL9j+3nNRjmcJD2hTZ9sx9Jr+HfbhoQPQwKDau6V7b2b\njgPa12492RaVoYLns3onVdNtk39ZOk/Ppxrx8wrbSwAkNbLOyigeoxpJNRvYz/Y+ZWIhtn9RqvGx\ndvaV9EHg6VS/p53Nfto48XGhpM8CXyyv30TVv9MmT+gkBgDb/1PmELTNJZL+nKploNFP7lM9OWwC\n/JzVl8Q1DXdc2f4rSZsBr6EaTfU9Sd8GzmX1WdKNKrWbX5eXvy9NdZ3Z5tOokkfrSHoVVYc5wKW2\n27g651lUy2ZcAzzacCzj+Wuq/RI6Azl+AHyquXB6GoYEBtWigO8CVkr6Las+FGw+2YFMyWYlSf9i\n+0RJrxs5XLCNSqfpYVTNSwcAZwMX2f5Oo4F1kfQm4A1UE/TmAq8FPtC2f19JH6ba9OVLpehI4Grb\n72suqjpJV9reb/wzmzUsS31I2pgqgXX2HPkB8CnbjzQXVbtN1eSwGHgOcE1b1lGaqNKW/zrgDW1Z\nF6ZD0rOo5hAIuMT2TQ2HVCPpOmAv24+V1xsC17apfRxA0mlUw24vBB7/A9a2ZT5guJb6aDtJl4z8\nve5VNhmmarPSt6kmQz1F1e5a3U01j9l+ajNhja+MVjmzPBo3YsXY+4Bzuo/ZbsPKsSNtwarJem39\nv+7UGmZ0lZl2bb3Z0dqlPsrQ0NE+AbstH7AkbQI8Cdi6fADs/E3aHNi+iZimZHKw/XfA30n6mu3H\nl2uW9CKqZoaYuJ8BS6mWv4YRK8dSrV/UJh+mPlmvjRv9vKTpGNZAr6U+2qLXUPWZwHuoPsy0xduA\ndwLbUfUzdX6PHqDaFXDSTclmpW5l/sCRVJOO7gAusN3If8YwkvRx4CXAD6lqDZc3PcpiPGUkWGeI\n7VVtm6wHIGkb4J+B7WwfIml3qjHwZzUc2tAqs+H/nmogyqm2v9VwSDWS/qYt85emVHIYlvkDw6ZM\ngNuf6t9zX+A7wBm272gyrpHKDOlDgGeVopuodixr1bLNAGV9nc8B77e9Z4n9Wtv/p+HQakZrumli\nVm8vkg6iWlzzEaqk0GsWcmtI2oNqheNNOmW2z570OKZYcvgs8C1WzR84pmv+wO0tHUM+NFTtI3wE\n8E/A+9yiPXolbQ/8F9V2m9dSVdv3Bv4QeIntnzYYXo2kq20/r3tSlHrsP9IGkronkm1CtU/GStvv\naSikx0m6GpgG/Cvwo5HH29DBr9WX5D+Zql9pV6pVog+mqo2/drLjmlJ9DsMyf2CYdA2zfQPVL+GF\nwHPdjr0mup1KVZv5eHehqv242CXtAAAKL0lEQVQ8Pky1jWSbPCzpaayaNzKTamns1rF9zYiiH0pq\ny7IpD1OtyPpaqqQ1sk+sDbUbAxdK+huqkYh7Av9l+82lefGLY169jkypmsNIwzB/oO0kPQzcSpVg\nb2VE80ILZpsDIOlm288a5dgtbsGuZd3K6pyfAPYArqdKvK+1fV2jgfUwYsTaBsBzgdPb9m/aZqr2\nr9+d6t9tX0mXAQdRbaB002g/u+vSlKo5jGT7YeDLwJe75g+cSNVmHhNzPlVCeGZ5dGt8tnmX34xx\n7NdjHGuE7R+XDtRnUn3abdUqoiNcw6o9zldSDexo234jrWb7AeAKSQtL8+zZwCKqn80rm4hpStcc\nYuqQdDu9hzUK+Ihbsvy5qm1gZfsLI8qPAh61/eVmIovJpmr/6y1s/6SR909yiKlA0ufGOm77LZMV\ny1gkXQkc6BH7S5Qm0MvatIqoyqZZ5flqS9FI+ue2LUkyLCS9hmqZD1N1Rl80ziXrJo4kh4j2kPTj\n0ZZ0aeEy2I/HOjLusb6PpgzDgouSPgX8EatWGngDcJvt4yY7lind5xDRQptKenLpD3tcGWXXtiXQ\nNcrzXq8b1WPBxXdIen4LazcHAH/cmUgqaS5wQxOBbNDEm8b6R9KTJP29pM+U19MlvaLpuIbQWcD/\nK+3NAEjamWo0WNtmR3uU571eN+3lwEttz7E9h2r+QBt/PpcAO3W93rGUTbrUHGJQPkc1aqWzs94y\nqpFM32gsoiFk+6OSHgIuk/SUUvwQcJrtMxoMrZc9uxau3LQ8p7zeZPTLGjMMCy5uBtzUNU/kecDV\nZVFDbL9qsgJJn0MMhKSFtmeMmNH7E9t7Nh3bSG1ZnmA8pSkJ2w82Hcuwk3QkcBqw2oKLtr/SaGAj\nlOHLj78EXkQ1YfftALYvnaxYUnOIQfmdpE1ZNaN3N7r2IWiLsjzB/lTJYT7VWkuXU40rb5UkhcGx\nfY6k77NqwcUT27jgou1Ly2Kgb6Sad3UH8OnJTAodSQ4xKB+k2idjR0lfAl4AtGJ46AivpVqe4Frb\nb2lyeYKYHKMsuPiz5iKqG2UxUDW5dHualWJgylpAM6mqw1fYbtUvIICkq8ryBNdQLTX+IA0tTxDr\n3rAsuCjpMVq2GGhqDjEQXVsZfrNHWZt0lif4DFUH+kP0WK2zDYalb6TlhmXBxdYtBpqaQ/Sla3vD\n71G15Xdvb/jtNn8iL0NEN2/pYnY9+0aaWLp5mA3hgoutWQw08xyiX2+j+gT+rPK18/gaDW1vOBZJ\nr5b0VADbdwL/K+nwZqPq6bXAgcA9ZWmPPWnv8Ms2G7YFFx+2/WXbrwR2oGoKO7GJWFJziIFo0/aG\nY+m1YU738Nu2SN/IYAzLgottlD6HGAjbn5D0J8DOdP1ctbCNvFdtuY2/B0PTN9JylwKvHOXYZZMZ\nyLBJzSEGQtIXgN2o1qB/tBTb9juai6pO0hzgl8AnS9FxwFa239xYUONoc99IrL+SHGIgJN0E7O6W\n/0CVDr+/B/6sFC0APjRyobumSXo11VaRvyqvtwD2t/3VZiOLqSLJIQZC0vnAO2wvbzqW9cGw9I3E\n+quNba0xnLYGbiwLhj2+bMZkLhQ2Fkkft/1OSV+nx4qhbYmzy7D0jcR6Kj9sMSgfbDqAcXS23fxo\no1FM3EJJH2P1vpFrGoxn6GVS4ZpJs1IMTNmDYLrt70p6ErBhmxaPk7QhcLbtNzUdy3iGpW9kWGRS\n4ZpLcoiBkPRWYDbVyJ/dJE2nWk2yVctnSLocOMD275qOJSaPpMWsWnBxz86Ci7Zf2nBorZVmpRiU\n46i2YbwSwPatkv6g2ZB6uh34Ydk85fFP4bY/1lxIqwxh38iw+I3txyStlLQ5cB/VLmsxiiSHGJRH\nbP9OqpZWKsskt7Faelt5bEC161bbDFvfyLDIpMI1lGalGAhJH6GaXHY08DdUO1fdaPv9jQY2CklP\nst26tXVguPpGhlEmFU5MFt6LQTkJWAEsplqMbz7wgUYjKiQ9oev58yXdCNxcXu8p6VONBdeD7UeB\np0t6YtOxrC+GaMHF1kjNIdZ7ko4DfmL7cklXUq14Oq9rr+vrbe/RaJAjSDob+GOglX0jwyaTCtdc\n+hyiL5LOs/36MhqkVwfqcxoIa6RPA/9OtVc0tu/u9I0Uj/a6qGFt7xsZNplUuIbyjxP9OqF8fUWj\nUYyhNNN0FgC8u6we69LcdALVnsKtYvsfod19I0MmkwrXUPocoi+2l5cO1M/bvmvko+n4ejiW6g/D\n9sAyYK/yunHD1jcyZP4G+B3wlfJ4hJb8v7dV+hxiICRdAryms4porLlh7BuJ9VealWJQHgIWS1rA\n6h2obdvPYReqT5E7s/qmRG2YXDaMfSOtlkmFay/JIQblwvJou68CZwFfBx5rOJbVDGPfyBDIpMK1\nlGalGAhJmwB/VF4usf3bJuMZjaQrbe/XdBzjkbQ18B9UC+8J+A5wgu2fNxrYEMqkwrWT5BB9Kctk\n/DPwl8BdVH/IdgQ+B7zf9u8bDK9G0huB6VR/bLv3nfhxY0HFOpcFF9dcmpWiX/9KNQ5/l87y3GVh\ns4+WxwljXNuE/wMcBRzAqmYll9et0fK+kWHU6gUX2yg1h+iLpFuBZ4zcO7pU5W+2Pb2ZyHqTtIRq\nr+tWf4KU9BOqvpHFdPWN2L60saCGWNnPoaYznyTqUnOIfnlkYiiFj0pq4yeP64EtqJZsbrPf2j69\n6SDWF5lUuOYyCS76daOko0cWSvoLygSultkCuFnSxZLmdR5NB9XDf0g6uUyG26fzaDqoYZJJhf1J\ns1L0RdL2VENYf8Oq5QhmAJsCr7a9rKnYepH04l7lbWuukfRhqr6R2+jqG7Hdqr6RNsukwv6kWSn6\nUv747yfpAODZpXi+7UsaDGtUI5OApBcCRwKtSg7A64Bd29430nKZVNiHJIcYCNv/BfxX03FMhKS9\ngTdS/QG+A7ig2Yh6Gpa+kdbKpML+JDnElCDpGVQ1hCOBn1EtvibbL2k0sNF1+kauZvX5GBnKunaO\npZpU2Flw8Ttk4b0xpc8hpgRJjwE/AI6xvaSU3W5712Yj621Y+kZi/ZWaQ0wVrwGOAL4n6dvAuVSz\nuVtpiPpGhkImFa651BxiSpH0ZOAwqj+0BwBnAxfZ/k6jgfXQq2/E9n82G9VwyqTCNZfkEFOWpC2p\n/vC+wfaBTccDo/aNvNv20xsNbMgNy4KLbZLkENEiw9Y3Miyy4OKaS59DRLsMVd/IEBmKBRfbJDWH\niBYapr6RYTAsCy62SdZWimgh2w/b/rLtVwI7ANcCJzYc1jDrTCqMCUrNISLWe5K+DzwHyKTCCUqf\nQ0RMBT33c4jRpeYQEVNOZ1Kh7SyhMYrUHCJiShiSBRdbI8khItZbQ7jgYmukWSki1luZVLj2MpQ1\nItZnrwGWU00q/IykA8mkwglJzSEi1nuZVLjmkhwiYkpp44KLbZTkEBERNelziIiImiSHiIioSXKI\niIiaJIeIiKj5/6eQAueLzy8lAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "tags": [] } } ] }, { "cell_type": "code", "metadata": { "id": "XFeJxuCnwsFo", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 1766 }, "outputId": "ced84691-9860-43f0-e75b-74c0550926bc" }, "source": [ "#selecionando apenas do 'Continente' da América Do Norte\n", "dfc.loc[(dfc['Continente'] == 'América Do Norte')]" ], "execution_count": 18, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StatusProtocoloAno SolicitaçãoSEINome SolicitanteSexoEstado CivilData NascimentoIdade SolicitaçãoPaís de OrigemContinenteData SolicitaçãoCidade SolicitaçãoUF SolicitaçãoData DecisãoAno DecisãoMotivo ArquivamentoData Arquivamento
4059ARQUIVADOS40602004NÃO4060MASCULINOSOLTEIRO(A)8/26/197231MÉXICOAmérica Do Norte07/07/2004São PauloSPNaNNão JulgadoDesistência VoluntáriaDesconhecido
4653ARQUIVADOS46542015SIM4654MASCULINOSOLTEIRO(A)11/03/197539ESTADOS UNIDOSAmérica Do Norte5/22/2015BrasíliaDFNaNNão JulgadoDesconhecido01/06/2016
5092ARQUIVADOS50932015SIM5093MASCULINOSOLTEIRO(A)06/10/196352ESTADOS UNIDOSAmérica Do Norte7/21/2015BrasíliaDFNaNNão JulgadoNaN4/25/2016
5169ARQUIVADOS51702015SIM5170MASCULINOCASADO(A)3/17/197143MÉXICOAmérica Do Norte1/26/2015Rio De JaneiroRJNaNNão JulgadoNaN4/25/2016
5670INDEFERIDOS56712010NÃO5671FEMININOMENOR12/28/20081ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
6138INDEFERIDOS61392010NÃO6139FEMININOCASADO(A)7/13/20100ESTADOS UNIDOSAmérica Do Norte7/13/2010JoinvilleSC3/18/20112011NaNNaN
6242INDEFERIDOS62432010NÃO6243MASCULINOMENOR7/21/20046ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
6348INDEFERIDOS63492012NÃO6349MASCULINOCASADO(A)5/21/196943ESTADOS UNIDOSAmérica Do Norte7/25/2012PacaraímaRR01/03/20142014NaNNaN
6528INDEFERIDOS65292012NÃO6529FEMININOCASADO(A)05/07/197933ESTADOS UNIDOSAmérica Do Norte7/25/2012PacaraímaRR01/03/20142014NaNNaN
7128INDEFERIDOS71292010NÃO7129MASCULINOCASADO(A)12/18/196247ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
7183INDEFERIDOS71842014SIM7184MASCULINODIVORCIADO(A)11/24/198231ESTADOS UNIDOSAmérica Do Norte5/26/2014Rio De JaneiroRJ10/22/20152015NaNNaN
8098INDEFERIDOS80992010NÃO8099MASCULINOMENOR11/18/199911ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
11004INDEFERIDOS110052006NÃO11005MASCULINOCASADO(A)1/15/197234ESTADOS UNIDOSAmérica Do Norte8/29/2006RecifePE12/13/20062006NaNNaN
11232INDEFERIDOS112332010NÃO11233FEMININOCASADO(A)09/01/197238ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
11478INDEFERIDOS114792012NÃO11479MASCULINOMENOR3/28/200210ESTADOS UNIDOSAmérica Do Norte7/25/2012PacaraímaRR01/03/20142014NaNNaN
14868PROCESSOS PENDENTES148692014SIM14869FEMININOSOLTEIRO(A)8/16/196747CANADÁAmérica Do NorteDesconhecidoSão PauloSPNaNNão JulgadoNaNNaN
14942PROCESSOS PENDENTES149432015SIM14943FEMININOSOLTEIRO(A)10/13/199420MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
15249PROCESSOS PENDENTES152502015SIM15250FEMININOVIÚVO(A)4/24/198034ESTADOS UNIDOSAmérica Do Norte1/27/2015São PauloSPNaNNão JulgadoNaNNaN
15909PROCESSOS PENDENTES159102015SIM15910MASCULINOMENOR02/02/199817MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
18171PROCESSOS PENDENTES181722015SIM18172FEMININOSOLTEIRO(A)02/11/197441ESTADOS UNIDOSAmérica Do Norte3/19/2015São PauloSPNaNNão JulgadoNaNNaN
18988PROCESSOS PENDENTES189892015SIM18989MASCULINOSOLTEIRO(A)01/05/199322MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
20175PROCESSOS PENDENTES201762015SIM20176FEMININOMENOR01/09/200114MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
21066PROCESSOS PENDENTES210672015SIM21067FEMININOCASADO(A)1/23/197243MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
25065PROCESSOS PENDENTES250662014SIM25066MASCULINOCASADO(A)11/04/196053ESTADOS UNIDOSAmérica Do Norte5/28/2014BrasíliaDFNaNNão JulgadoNaNNaN
25687PROCESSOS PENDENTES256882014SIM25688MASCULINODIVORCIADO(A)10/12/197142ESTADOS UNIDOSAmérica Do Norte1/30/2014GuarujáSPNaNNão JulgadoNaNNaN
27041PROCESSOS PENDENTES270422015SIM27042MASCULINOMENOR10/26/20095MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
27048PROCESSOS PENDENTES270492015SIM27049MASCULINOCASADO(A)9/14/196154ESTADOS UNIDOSAmérica Do Norte12/09/2015DesconhecidoDesconhecidoNaNNão JulgadoNaNNaN
27157PROCESSOS PENDENTES271582015SIM27158MASCULINOCASADO(A)05/10/196352MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
27526PROCESSOS PENDENTES275272015SIM27527FEMININOMENOR11/13/20131MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
29487RECONHECIDOS294882014SIM29488MASCULINOSOLTEIRO(A)2/21/197638MÉXICOAmérica Do Norte12/02/2014Porto AlegreRS4/29/20162016NaNNaN
32404RECONHECIDOS324062012SIM32406MASCULINOMENOR10/08/199516MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
32405RECONHECIDOS324072012SIM32407FEMININODIVORCIADO(A)6/29/196546MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
32406RECONHECIDOS324082012SIM32408FEMININOMENOR7/26/199912MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
32407RECONHECIDOS324092012SIM32409MASCULINOMENOR9/25/20120MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
32408RECONHECIDOS324102014SIM32410FEMININOMENOR3/13/199915MÉXICOAmérica Do Norte08/08/2014FlorianópolisSC4/24/20152015NaNNaN
\n", "
" ], "text/plain": [ " Status Protocolo Ano Solicitação SEI Nome Solicitante \\\n", "4059 ARQUIVADOS 4060 2004 NÃO 4060 \n", "4653 ARQUIVADOS 4654 2015 SIM 4654 \n", "5092 ARQUIVADOS 5093 2015 SIM 5093 \n", "5169 ARQUIVADOS 5170 2015 SIM 5170 \n", "5670 INDEFERIDOS 5671 2010 NÃO 5671 \n", "6138 INDEFERIDOS 6139 2010 NÃO 6139 \n", "6242 INDEFERIDOS 6243 2010 NÃO 6243 \n", "6348 INDEFERIDOS 6349 2012 NÃO 6349 \n", "6528 INDEFERIDOS 6529 2012 NÃO 6529 \n", "7128 INDEFERIDOS 7129 2010 NÃO 7129 \n", "7183 INDEFERIDOS 7184 2014 SIM 7184 \n", "8098 INDEFERIDOS 8099 2010 NÃO 8099 \n", "11004 INDEFERIDOS 11005 2006 NÃO 11005 \n", "11232 INDEFERIDOS 11233 2010 NÃO 11233 \n", "11478 INDEFERIDOS 11479 2012 NÃO 11479 \n", "14868 PROCESSOS PENDENTES 14869 2014 SIM 14869 \n", "14942 PROCESSOS PENDENTES 14943 2015 SIM 14943 \n", "15249 PROCESSOS PENDENTES 15250 2015 SIM 15250 \n", "15909 PROCESSOS PENDENTES 15910 2015 SIM 15910 \n", "18171 PROCESSOS PENDENTES 18172 2015 SIM 18172 \n", "18988 PROCESSOS PENDENTES 18989 2015 SIM 18989 \n", "20175 PROCESSOS PENDENTES 20176 2015 SIM 20176 \n", "21066 PROCESSOS PENDENTES 21067 2015 SIM 21067 \n", "25065 PROCESSOS PENDENTES 25066 2014 SIM 25066 \n", "25687 PROCESSOS PENDENTES 25688 2014 SIM 25688 \n", "27041 PROCESSOS PENDENTES 27042 2015 SIM 27042 \n", "27048 PROCESSOS PENDENTES 27049 2015 SIM 27049 \n", "27157 PROCESSOS PENDENTES 27158 2015 SIM 27158 \n", "27526 PROCESSOS PENDENTES 27527 2015 SIM 27527 \n", "29487 RECONHECIDOS 29488 2014 SIM 29488 \n", "32404 RECONHECIDOS 32406 2012 SIM 32406 \n", "32405 RECONHECIDOS 32407 2012 SIM 32407 \n", "32406 RECONHECIDOS 32408 2012 SIM 32408 \n", "32407 RECONHECIDOS 32409 2012 SIM 32409 \n", "32408 RECONHECIDOS 32410 2014 SIM 32410 \n", "\n", " Sexo Estado Civil Data Nascimento Idade Solicitação \\\n", "4059 MASCULINO SOLTEIRO(A) 8/26/1972 31 \n", "4653 MASCULINO SOLTEIRO(A) 11/03/1975 39 \n", "5092 MASCULINO SOLTEIRO(A) 06/10/1963 52 \n", "5169 MASCULINO CASADO(A) 3/17/1971 43 \n", "5670 FEMININO MENOR 12/28/2008 1 \n", "6138 FEMININO CASADO(A) 7/13/2010 0 \n", "6242 MASCULINO MENOR 7/21/2004 6 \n", "6348 MASCULINO CASADO(A) 5/21/1969 43 \n", "6528 FEMININO CASADO(A) 05/07/1979 33 \n", "7128 MASCULINO CASADO(A) 12/18/1962 47 \n", "7183 MASCULINO DIVORCIADO(A) 11/24/1982 31 \n", "8098 MASCULINO MENOR 11/18/1999 11 \n", "11004 MASCULINO CASADO(A) 1/15/1972 34 \n", "11232 FEMININO CASADO(A) 09/01/1972 38 \n", "11478 MASCULINO MENOR 3/28/2002 10 \n", "14868 FEMININO SOLTEIRO(A) 8/16/1967 47 \n", "14942 FEMININO SOLTEIRO(A) 10/13/1994 20 \n", "15249 FEMININO VIÚVO(A) 4/24/1980 34 \n", "15909 MASCULINO MENOR 02/02/1998 17 \n", "18171 FEMININO SOLTEIRO(A) 02/11/1974 41 \n", "18988 MASCULINO SOLTEIRO(A) 01/05/1993 22 \n", "20175 FEMININO MENOR 01/09/2001 14 \n", "21066 FEMININO CASADO(A) 1/23/1972 43 \n", "25065 MASCULINO CASADO(A) 11/04/1960 53 \n", "25687 MASCULINO DIVORCIADO(A) 10/12/1971 42 \n", "27041 MASCULINO MENOR 10/26/2009 5 \n", "27048 MASCULINO CASADO(A) 9/14/1961 54 \n", "27157 MASCULINO CASADO(A) 05/10/1963 52 \n", "27526 FEMININO MENOR 11/13/2013 1 \n", "29487 MASCULINO SOLTEIRO(A) 2/21/1976 38 \n", "32404 MASCULINO MENOR 10/08/1995 16 \n", "32405 FEMININO DIVORCIADO(A) 6/29/1965 46 \n", "32406 FEMININO MENOR 7/26/1999 12 \n", "32407 MASCULINO MENOR 9/25/2012 0 \n", "32408 FEMININO MENOR 3/13/1999 15 \n", "\n", " País de Origem Continente Data Solicitação Cidade Solicitação \\\n", "4059 MÉXICO América Do Norte 07/07/2004 São Paulo \n", "4653 ESTADOS UNIDOS América Do Norte 5/22/2015 Brasília \n", "5092 ESTADOS UNIDOS América Do Norte 7/21/2015 Brasília \n", "5169 MÉXICO América Do Norte 1/26/2015 Rio De Janeiro \n", "5670 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "6138 ESTADOS UNIDOS América Do Norte 7/13/2010 Joinville \n", "6242 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "6348 ESTADOS UNIDOS América Do Norte 7/25/2012 Pacaraíma \n", "6528 ESTADOS UNIDOS América Do Norte 7/25/2012 Pacaraíma \n", "7128 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "7183 ESTADOS UNIDOS América Do Norte 5/26/2014 Rio De Janeiro \n", "8098 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "11004 ESTADOS UNIDOS América Do Norte 8/29/2006 Recife \n", "11232 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "11478 ESTADOS UNIDOS América Do Norte 7/25/2012 Pacaraíma \n", "14868 CANADÁ América Do Norte Desconhecido São Paulo \n", "14942 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "15249 ESTADOS UNIDOS América Do Norte 1/27/2015 São Paulo \n", "15909 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "18171 ESTADOS UNIDOS América Do Norte 3/19/2015 São Paulo \n", "18988 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "20175 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "21066 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "25065 ESTADOS UNIDOS América Do Norte 5/28/2014 Brasília \n", "25687 ESTADOS UNIDOS América Do Norte 1/30/2014 Guarujá \n", "27041 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "27048 ESTADOS UNIDOS América Do Norte 12/09/2015 Desconhecido \n", "27157 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "27526 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "29487 MÉXICO América Do Norte 12/02/2014 Porto Alegre \n", "32404 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "32405 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "32406 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "32407 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "32408 MÉXICO América Do Norte 08/08/2014 Florianópolis \n", "\n", " UF Solicitação Data Decisão Ano Decisão Motivo Arquivamento \\\n", "4059 SP NaN Não Julgado Desistência Voluntária \n", "4653 DF NaN Não Julgado Desconhecido \n", "5092 DF NaN Não Julgado NaN \n", "5169 RJ NaN Não Julgado NaN \n", "5670 RJ 3/18/2011 2011 NaN \n", "6138 SC 3/18/2011 2011 NaN \n", "6242 RJ 3/18/2011 2011 NaN \n", "6348 RR 01/03/2014 2014 NaN \n", "6528 RR 01/03/2014 2014 NaN \n", "7128 RJ 3/18/2011 2011 NaN \n", "7183 RJ 10/22/2015 2015 NaN \n", "8098 RJ 3/18/2011 2011 NaN \n", "11004 PE 12/13/2006 2006 NaN \n", "11232 RJ 3/18/2011 2011 NaN \n", "11478 RR 01/03/2014 2014 NaN \n", "14868 SP NaN Não Julgado NaN \n", "14942 RS NaN Não Julgado NaN \n", "15249 SP NaN Não Julgado NaN \n", "15909 RS NaN Não Julgado NaN \n", "18171 SP NaN Não Julgado NaN \n", "18988 RS NaN Não Julgado NaN \n", "20175 RS NaN Não Julgado NaN \n", "21066 RS NaN Não Julgado NaN \n", "25065 DF NaN Não Julgado NaN \n", "25687 SP NaN Não Julgado NaN \n", "27041 RS NaN Não Julgado NaN \n", "27048 Desconhecido NaN Não Julgado NaN \n", "27157 RS NaN Não Julgado NaN \n", "27526 RS NaN Não Julgado NaN \n", "29487 RS 4/29/2016 2016 NaN \n", "32404 SC 4/24/2015 2015 NaN \n", "32405 SC 4/24/2015 2015 NaN \n", "32406 SC 4/24/2015 2015 NaN \n", "32407 SC 4/24/2015 2015 NaN \n", "32408 SC 4/24/2015 2015 NaN \n", "\n", " Data Arquivamento \n", "4059 Desconhecido \n", "4653 01/06/2016 \n", "5092 4/25/2016 \n", "5169 4/25/2016 \n", "5670 NaN \n", "6138 NaN \n", "6242 NaN \n", "6348 NaN \n", "6528 NaN \n", "7128 NaN \n", "7183 NaN \n", "8098 NaN \n", "11004 NaN \n", "11232 NaN \n", "11478 NaN \n", "14868 NaN \n", "14942 NaN \n", "15249 NaN \n", "15909 NaN \n", "18171 NaN \n", "18988 NaN \n", "20175 NaN \n", "21066 NaN \n", "25065 NaN \n", "25687 NaN \n", "27041 NaN \n", "27048 NaN \n", "27157 NaN \n", "27526 NaN \n", "29487 NaN \n", "32404 NaN \n", "32405 NaN \n", "32406 NaN \n", "32407 NaN \n", "32408 NaN " ] }, "metadata": { "tags": [] }, "execution_count": 18 } ] }, { "cell_type": "code", "metadata": { "id": "_mKc5kYaxLvE", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 1094 }, "outputId": "42e6bfd1-8f59-464f-e51e-f9c75615b7ce" }, "source": [ "#selecionando apenas do 'Continente' da América Do Norte e 'Sexo' Masculino\n", "dfc.loc[(dfc['Continente'] == 'América Do Norte') & (dfc['Sexo'] =='MASCULINO')]" ], "execution_count": 19, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StatusProtocoloAno SolicitaçãoSEINome SolicitanteSexoEstado CivilData NascimentoIdade SolicitaçãoPaís de OrigemContinenteData SolicitaçãoCidade SolicitaçãoUF SolicitaçãoData DecisãoAno DecisãoMotivo ArquivamentoData Arquivamento
4059ARQUIVADOS40602004NÃO4060MASCULINOSOLTEIRO(A)8/26/197231MÉXICOAmérica Do Norte07/07/2004São PauloSPNaNNão JulgadoDesistência VoluntáriaDesconhecido
4653ARQUIVADOS46542015SIM4654MASCULINOSOLTEIRO(A)11/03/197539ESTADOS UNIDOSAmérica Do Norte5/22/2015BrasíliaDFNaNNão JulgadoDesconhecido01/06/2016
5092ARQUIVADOS50932015SIM5093MASCULINOSOLTEIRO(A)06/10/196352ESTADOS UNIDOSAmérica Do Norte7/21/2015BrasíliaDFNaNNão JulgadoNaN4/25/2016
5169ARQUIVADOS51702015SIM5170MASCULINOCASADO(A)3/17/197143MÉXICOAmérica Do Norte1/26/2015Rio De JaneiroRJNaNNão JulgadoNaN4/25/2016
6242INDEFERIDOS62432010NÃO6243MASCULINOMENOR7/21/20046ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
6348INDEFERIDOS63492012NÃO6349MASCULINOCASADO(A)5/21/196943ESTADOS UNIDOSAmérica Do Norte7/25/2012PacaraímaRR01/03/20142014NaNNaN
7128INDEFERIDOS71292010NÃO7129MASCULINOCASADO(A)12/18/196247ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
7183INDEFERIDOS71842014SIM7184MASCULINODIVORCIADO(A)11/24/198231ESTADOS UNIDOSAmérica Do Norte5/26/2014Rio De JaneiroRJ10/22/20152015NaNNaN
8098INDEFERIDOS80992010NÃO8099MASCULINOMENOR11/18/199911ESTADOS UNIDOSAmérica Do Norte11/22/2010Rio De JaneiroRJ3/18/20112011NaNNaN
11004INDEFERIDOS110052006NÃO11005MASCULINOCASADO(A)1/15/197234ESTADOS UNIDOSAmérica Do Norte8/29/2006RecifePE12/13/20062006NaNNaN
11478INDEFERIDOS114792012NÃO11479MASCULINOMENOR3/28/200210ESTADOS UNIDOSAmérica Do Norte7/25/2012PacaraímaRR01/03/20142014NaNNaN
15909PROCESSOS PENDENTES159102015SIM15910MASCULINOMENOR02/02/199817MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
18988PROCESSOS PENDENTES189892015SIM18989MASCULINOSOLTEIRO(A)01/05/199322MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
25065PROCESSOS PENDENTES250662014SIM25066MASCULINOCASADO(A)11/04/196053ESTADOS UNIDOSAmérica Do Norte5/28/2014BrasíliaDFNaNNão JulgadoNaNNaN
25687PROCESSOS PENDENTES256882014SIM25688MASCULINODIVORCIADO(A)10/12/197142ESTADOS UNIDOSAmérica Do Norte1/30/2014GuarujáSPNaNNão JulgadoNaNNaN
27041PROCESSOS PENDENTES270422015SIM27042MASCULINOMENOR10/26/20095MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
27048PROCESSOS PENDENTES270492015SIM27049MASCULINOCASADO(A)9/14/196154ESTADOS UNIDOSAmérica Do Norte12/09/2015DesconhecidoDesconhecidoNaNNão JulgadoNaNNaN
27157PROCESSOS PENDENTES271582015SIM27158MASCULINOCASADO(A)05/10/196352MÉXICOAmérica Do Norte9/17/2015Porto AlegreRSNaNNão JulgadoNaNNaN
29487RECONHECIDOS294882014SIM29488MASCULINOSOLTEIRO(A)2/21/197638MÉXICOAmérica Do Norte12/02/2014Porto AlegreRS4/29/20162016NaNNaN
32404RECONHECIDOS324062012SIM32406MASCULINOMENOR10/08/199516MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
32407RECONHECIDOS324092012SIM32409MASCULINOMENOR9/25/20120MÉXICOAmérica Do Norte02/03/2012FlorianópolisSC4/24/20152015NaNNaN
\n", "
" ], "text/plain": [ " Status Protocolo Ano Solicitação SEI Nome Solicitante \\\n", "4059 ARQUIVADOS 4060 2004 NÃO 4060 \n", "4653 ARQUIVADOS 4654 2015 SIM 4654 \n", "5092 ARQUIVADOS 5093 2015 SIM 5093 \n", "5169 ARQUIVADOS 5170 2015 SIM 5170 \n", "6242 INDEFERIDOS 6243 2010 NÃO 6243 \n", "6348 INDEFERIDOS 6349 2012 NÃO 6349 \n", "7128 INDEFERIDOS 7129 2010 NÃO 7129 \n", "7183 INDEFERIDOS 7184 2014 SIM 7184 \n", "8098 INDEFERIDOS 8099 2010 NÃO 8099 \n", "11004 INDEFERIDOS 11005 2006 NÃO 11005 \n", "11478 INDEFERIDOS 11479 2012 NÃO 11479 \n", "15909 PROCESSOS PENDENTES 15910 2015 SIM 15910 \n", "18988 PROCESSOS PENDENTES 18989 2015 SIM 18989 \n", "25065 PROCESSOS PENDENTES 25066 2014 SIM 25066 \n", "25687 PROCESSOS PENDENTES 25688 2014 SIM 25688 \n", "27041 PROCESSOS PENDENTES 27042 2015 SIM 27042 \n", "27048 PROCESSOS PENDENTES 27049 2015 SIM 27049 \n", "27157 PROCESSOS PENDENTES 27158 2015 SIM 27158 \n", "29487 RECONHECIDOS 29488 2014 SIM 29488 \n", "32404 RECONHECIDOS 32406 2012 SIM 32406 \n", "32407 RECONHECIDOS 32409 2012 SIM 32409 \n", "\n", " Sexo Estado Civil Data Nascimento Idade Solicitação \\\n", "4059 MASCULINO SOLTEIRO(A) 8/26/1972 31 \n", "4653 MASCULINO SOLTEIRO(A) 11/03/1975 39 \n", "5092 MASCULINO SOLTEIRO(A) 06/10/1963 52 \n", "5169 MASCULINO CASADO(A) 3/17/1971 43 \n", "6242 MASCULINO MENOR 7/21/2004 6 \n", "6348 MASCULINO CASADO(A) 5/21/1969 43 \n", "7128 MASCULINO CASADO(A) 12/18/1962 47 \n", "7183 MASCULINO DIVORCIADO(A) 11/24/1982 31 \n", "8098 MASCULINO MENOR 11/18/1999 11 \n", "11004 MASCULINO CASADO(A) 1/15/1972 34 \n", "11478 MASCULINO MENOR 3/28/2002 10 \n", "15909 MASCULINO MENOR 02/02/1998 17 \n", "18988 MASCULINO SOLTEIRO(A) 01/05/1993 22 \n", "25065 MASCULINO CASADO(A) 11/04/1960 53 \n", "25687 MASCULINO DIVORCIADO(A) 10/12/1971 42 \n", "27041 MASCULINO MENOR 10/26/2009 5 \n", "27048 MASCULINO CASADO(A) 9/14/1961 54 \n", "27157 MASCULINO CASADO(A) 05/10/1963 52 \n", "29487 MASCULINO SOLTEIRO(A) 2/21/1976 38 \n", "32404 MASCULINO MENOR 10/08/1995 16 \n", "32407 MASCULINO MENOR 9/25/2012 0 \n", "\n", " País de Origem Continente Data Solicitação Cidade Solicitação \\\n", "4059 MÉXICO América Do Norte 07/07/2004 São Paulo \n", "4653 ESTADOS UNIDOS América Do Norte 5/22/2015 Brasília \n", "5092 ESTADOS UNIDOS América Do Norte 7/21/2015 Brasília \n", "5169 MÉXICO América Do Norte 1/26/2015 Rio De Janeiro \n", "6242 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "6348 ESTADOS UNIDOS América Do Norte 7/25/2012 Pacaraíma \n", "7128 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "7183 ESTADOS UNIDOS América Do Norte 5/26/2014 Rio De Janeiro \n", "8098 ESTADOS UNIDOS América Do Norte 11/22/2010 Rio De Janeiro \n", "11004 ESTADOS UNIDOS América Do Norte 8/29/2006 Recife \n", "11478 ESTADOS UNIDOS América Do Norte 7/25/2012 Pacaraíma \n", "15909 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "18988 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "25065 ESTADOS UNIDOS América Do Norte 5/28/2014 Brasília \n", "25687 ESTADOS UNIDOS América Do Norte 1/30/2014 Guarujá \n", "27041 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "27048 ESTADOS UNIDOS América Do Norte 12/09/2015 Desconhecido \n", "27157 MÉXICO América Do Norte 9/17/2015 Porto Alegre \n", "29487 MÉXICO América Do Norte 12/02/2014 Porto Alegre \n", "32404 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "32407 MÉXICO América Do Norte 02/03/2012 Florianópolis \n", "\n", " UF Solicitação Data Decisão Ano Decisão Motivo Arquivamento \\\n", "4059 SP NaN Não Julgado Desistência Voluntária \n", "4653 DF NaN Não Julgado Desconhecido \n", "5092 DF NaN Não Julgado NaN \n", "5169 RJ NaN Não Julgado NaN \n", "6242 RJ 3/18/2011 2011 NaN \n", "6348 RR 01/03/2014 2014 NaN \n", "7128 RJ 3/18/2011 2011 NaN \n", "7183 RJ 10/22/2015 2015 NaN \n", "8098 RJ 3/18/2011 2011 NaN \n", "11004 PE 12/13/2006 2006 NaN \n", "11478 RR 01/03/2014 2014 NaN \n", "15909 RS NaN Não Julgado NaN \n", "18988 RS NaN Não Julgado NaN \n", "25065 DF NaN Não Julgado NaN \n", "25687 SP NaN Não Julgado NaN \n", "27041 RS NaN Não Julgado NaN \n", "27048 Desconhecido NaN Não Julgado NaN \n", "27157 RS NaN Não Julgado NaN \n", "29487 RS 4/29/2016 2016 NaN \n", "32404 SC 4/24/2015 2015 NaN \n", "32407 SC 4/24/2015 2015 NaN \n", "\n", " Data Arquivamento \n", "4059 Desconhecido \n", "4653 01/06/2016 \n", "5092 4/25/2016 \n", "5169 4/25/2016 \n", "6242 NaN \n", "6348 NaN \n", "7128 NaN \n", "7183 NaN \n", "8098 NaN \n", "11004 NaN \n", "11478 NaN \n", "15909 NaN \n", "18988 NaN \n", "25065 NaN \n", "25687 NaN \n", "27041 NaN \n", "27048 NaN \n", "27157 NaN \n", "29487 NaN \n", "32404 NaN \n", "32407 NaN " ] }, "metadata": { "tags": [] }, "execution_count": 19 } ] }, { "cell_type": "markdown", "metadata": { "id": "RVW0j0z7xwDt", "colab_type": "text" }, "source": [ "Informação **STATUS**" ] }, { "cell_type": "code", "metadata": { "id": "OSNriBbHxZXP", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 68 }, "outputId": "f302ceed-5041-423c-faea-df5e6ea266ef" }, "source": [ "dfc['Status'].unique()" ], "execution_count": 21, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "array(['ARQUIVADOS', 'CESSAÃ\\x87ÃO', 'INDEFERIDOS', 'PERDA',\n", " 'PROCESSOS PENDENTES', 'RECONHECIDOS', 'RECONHECIDOS ACNUR',\n", " 'RECURSOS', 'REGULARIZAÃ\\x87ÃO CNIG'], dtype=object)" ] }, "metadata": { "tags": [] }, "execution_count": 21 } ] }, { "cell_type": "code", "metadata": { "id": "9FIqrxJ3xzf_", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 187 }, "outputId": "0001e5b4-d6c1-41a1-b396-c4a28fc8e9b6" }, "source": [ "dfc['Status'].value_counts()" ], "execution_count": 23, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "PROCESSOS PENDENTES 17510\n", "RECONHECIDOS 6722\n", "INDEFERIDOS 6413\n", "ARQUIVADOS 5220\n", "RECONHECIDOS ACNUR 1474\n", "REGULARIZAÇÃO CNIG 742\n", "RECURSOS 404\n", "PERDA 274\n", "CESSAÇÃO 23\n", "Name: Status, dtype: int64" ] }, "metadata": { "tags": [] }, "execution_count": 23 } ] }, { "cell_type": "code", "metadata": { "id": "c2bINbfQxzq3", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 165 }, "outputId": "721cf882-4939-42fa-a54e-228b590c1f5b" }, "source": [ "#selecionando registros da 'ÍNDIA' e com Status de 'RECONHECIDOS' \n", "dfc.loc[(dfc['Status'] == 'RECONHECIDOS') & (dfc['País de Origem'] =='ÍNDIA')]" ], "execution_count": 25, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StatusProtocoloAno SolicitaçãoSEINome SolicitanteSexoEstado CivilData NascimentoIdade SolicitaçãoPaís de OrigemContinenteData SolicitaçãoCidade SolicitaçãoUF SolicitaçãoData DecisãoAno DecisãoMotivo ArquivamentoData Arquivamento
29478RECONHECIDOS294792014SIM29479MASCULINOCASADO(A)11/22/197835ÍNDIAÁsia9/18/2014São PauloSP4/29/20162016NaNNaN
31647RECONHECIDOS316492012NÃO31649MASCULINOSOLTEIRO(A)04/04/198923ÍNDIAÁsia12/21/2012São PauloSP12/17/20132013NaNNaN
\n", "
" ], "text/plain": [ " Status Protocolo Ano Solicitação SEI Nome Solicitante \\\n", "29478 RECONHECIDOS 29479 2014 SIM 29479 \n", "31647 RECONHECIDOS 31649 2012 NÃO 31649 \n", "\n", " Sexo Estado Civil Data Nascimento Idade Solicitação \\\n", "29478 MASCULINO CASADO(A) 11/22/1978 35 \n", "31647 MASCULINO SOLTEIRO(A) 04/04/1989 23 \n", "\n", " País de Origem Continente Data Solicitação Cidade Solicitação \\\n", "29478 ÍNDIA Ásia 9/18/2014 São Paulo \n", "31647 ÍNDIA Ásia 12/21/2012 São Paulo \n", "\n", " UF Solicitação Data Decisão Ano Decisão Motivo Arquivamento \\\n", "29478 SP 4/29/2016 2016 NaN \n", "31647 SP 12/17/2013 2013 NaN \n", "\n", " Data Arquivamento \n", "29478 NaN \n", "31647 NaN " ] }, "metadata": { "tags": [] }, "execution_count": 25 } ] }, { "cell_type": "code", "metadata": { "id": "PlJeKb_PxL8l", "colab_type": "code", "colab": { "base_uri": "https://localhost:8080/", "height": 382 }, "outputId": "aed2093e-413d-4510-9cea-bce56a144097" }, "source": [ "dfc[\"Status\"].value_counts().plot.bar()\n", "plt.show()" ], "execution_count": 27, "outputs": [ { "output_type": "display_data", "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAFtCAYAAADswaaaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3Xm0ZFV5/vHvAzgQRAFpEBkEFJwQ\nUAZZokYhKqgRcARjBEXQCBHjCGKiQTE4xVkMags4gBhEWsXI4IDmJ0KjyIy0CNqEGSPEAQSf3x97\nF326qu7tpu/t2nWt57NWrXvOPjW8t7tuvbVn2SYiIqJrldYBRETE+ElyiIiIAUkOERExIMkhIiIG\nJDlERMSAJIeIiBiQ5BAREQOSHCIiYkCSQ0REDFitdQArat111/Wmm27aOoyIiDnl/PPPv9n2vGXd\nb84mh0033ZSFCxe2DiMiYk6RdM3y3C/NShERMSDJISIiBiQ5RETEgCSHiIgYkOQQEREDlpkcJM2X\ndKOkiztlX5Z0Qb1dLemCWr6ppD90rn2q85jtJF0kaZGkj0pSLV9H0hmSrqw/114Zv2hERCy/5ak5\nHAvs1i2w/RLb29reFjgZ+Grn8i9612y/plN+NHAAsEW99Z7zUOAs21sAZ9XziIhoaJnJwfbZwK3D\nrtVv/y8GTpjuOSRtADzQ9jku+5IeD+xZL+8BHFePj+uUR0REIzPtc3gKcIPtKztlm0n6qaTvS3pK\nLdsQWNy5z+JaBrC+7evq8fXA+jOMKSIiZmimM6T3Yelaw3XAJrZvkbQd8DVJj13eJ7NtSZ7quqQD\ngQMBNtlkk2U+36aHfnN5X3qZrj7qObP2XBER426Faw6SVgOeD3y5V2b7Dtu31OPzgV8AWwLXAht1\nHr5RLQO4oTY79ZqfbpzqNW0fY3t729vPm7fMpUEiImIFzaRZ6W+Ay23f01wkaZ6kVevx5pSO56tq\ns9Ftknaq/RQvB06tD1sA7FuP9+2UR0REI8szlPUE4EfAIyUtlrR/vbQ3gx3RTwUurENb/xN4je1e\nZ/Zrgc8Aiyg1im/V8qOAZ0i6kpJwjprB7xMREbNgmX0OtveZony/IWUnU4a2Drv/QmCrIeW3ALsu\nK46IiBidzJCOiIgBSQ4RETEgySEiIgYkOURExIAkh4iIGJDkEBERA5IcIiJiQJJDREQMSHKIiIgB\nSQ4RETEgySEiIgYkOURExIAkh4iIGJDkEBERA5IcIiJiQJJDREQMSHKIiIgBSQ4RETEgySEiIgYk\nOURExIAkh4iIGLDM5CBpvqQbJV3cKXunpGslXVBvz+5cO0zSIklXSHpWp3y3WrZI0qGd8s0k/biW\nf1nSfWfzF4yIiHtveWoOxwK7DSn/kO1t6+00AEmPAfYGHlsf80lJq0paFfgEsDvwGGCfel+A99bn\negTwG2D/mfxCERExc8tMDrbPBm5dzufbAzjR9h22fwksAnast0W2r7J9J3AisIckAbsA/1kffxyw\n5738HSIiYpbNpM/hYEkX1mantWvZhsCvO/dZXMumKn8w8L+27+orH0rSgZIWSlp40003zSD0iIiY\nzoomh6OBhwPbAtcBH5y1iKZh+xjb29veft68eaN4yYiIibTaijzI9g29Y0mfBr5RT68FNu7cdaNa\nxhTltwBrSVqt1h6694+IiEZWqOYgaYPO6V5AbyTTAmBvSfeTtBmwBXAucB6wRR2ZdF9Kp/UC2wa+\nC7ywPn5f4NQViSkiImbPMmsOkk4AngasK2kx8A7gaZK2BQxcDbwawPYlkk4CLgXuAg6yfXd9noOB\nbwOrAvNtX1Jf4q3AiZLeDfwU+Oys/XYREbFClpkcbO8zpHjKD3DbRwJHDik/DThtSPlVlNFMEREx\nJjJDOiIiBiQ5RETEgCSHiIgYkOQQEREDkhwiImJAkkNERAxIcoiIiAFJDhERMSDJISIiBiQ5RETE\ngCSHiIgYkOQQEREDkhwiImJAkkNERAxIcoiIiAFJDhERMSDJISIiBiQ5RETEgCSHiIgYkOQQERED\nlpkcJM2XdKOkiztl75d0uaQLJZ0iaa1avqmkP0i6oN4+1XnMdpIukrRI0kclqZavI+kMSVfWn2uv\njF80IiKW3/LUHI4FdusrOwPYyvbWwM+BwzrXfmF723p7Taf8aOAAYIt66z3nocBZtrcAzqrnERHR\n0DKTg+2zgVv7yk63fVc9PQfYaLrnkLQB8EDb59g2cDywZ728B3BcPT6uUx4REY3MRp/DK4Fvdc43\nk/RTSd+X9JRatiGwuHOfxbUMYH3b19Xj64H1ZyGmiIiYgdVm8mBJhwN3AV+sRdcBm9i+RdJ2wNck\nPXZ5n8+2JXma1zsQOBBgk002WfHAIyJiWitcc5C0H/Bc4O9qUxG277B9Sz0+H/gFsCVwLUs3PW1U\nywBuqM1OveanG6d6TdvH2N7e9vbz5s1b0dAjImIZVig5SNoNeAvwPNu/75TPk7RqPd6c0vF8VW02\nuk3STnWU0suBU+vDFgD71uN9O+UREdHIMpuVJJ0APA1YV9Ji4B2U0Un3A86oI1LPqSOTngocIelP\nwJ+B19judWa/ljLyaXVKH0Wvn+Io4CRJ+wPXAC+eld8sIiJW2DKTg+19hhR/dor7ngycPMW1hcBW\nQ8pvAXZdVhwRETE6mSEdEREDkhwiImJAkkNERAxIcoiIiAFJDhERMSDJISIiBiQ5RETEgCSHiIgY\nkOQQEREDkhwiImJAkkNERAxIcoiIiAFJDhERMSDJISIiBiQ5RETEgCSHiIgYkOQQEREDkhwiImJA\nkkNERAxIcoiIiAFJDhERMWC5koOk+ZJulHRxp2wdSWdIurL+XLuWS9JHJS2SdKGkJ3Qes2+9/5WS\n9u2UbyfpovqYj0rSbP6SERFx7yxvzeFYYLe+skOBs2xvAZxVzwF2B7aotwOBo6EkE+AdwBOBHYF3\n9BJKvc8Bncf1v1ZERIzQciUH22cDt/YV7wEcV4+PA/bslB/v4hxgLUkbAM8CzrB9q+3fAGcAu9Vr\nD7R9jm0Dx3eeKyIiGphJn8P6tq+rx9cD69fjDYFfd+63uJZNV754SPkASQdKWihp4U033TSD0CMi\nYjqz0iFdv/F7Np5rGa9zjO3tbW8/b968lf1yERETaybJ4YbaJET9eWMtvxbYuHO/jWrZdOUbDSmP\niIhGZpIcFgC9EUf7Aqd2yl9eRy3tBPy2Nj99G3impLVrR/QzgW/Xa7dJ2qmOUnp557kiIqKB1Zbn\nTpJOAJ4GrCtpMWXU0VHASZL2B64BXlzvfhrwbGAR8HvgFQC2b5X0LuC8er8jbPc6uV9LGRG1OvCt\neouIiEaWKznY3meKS7sOua+Bg6Z4nvnA/CHlC4GtlieWiIhY+TJDOiIiBiQ5RETEgCSHiIgYkOQQ\nEREDkhwiImJAkkNERAxIcoiIiAFJDhERMSDJISIiBiQ5RETEgCSHiIgYkOQQEREDkhwiImJAkkNE\nRAxIcoiIiAFJDhERMSDJISIiBiQ5RETEgCSHiIgYkOQQEREDVjg5SHqkpAs6t9skvV7SOyVd2yl/\nducxh0laJOkKSc/qlO9WyxZJOnSmv1RERMzMaiv6QNtXANsCSFoVuBY4BXgF8CHbH+jeX9JjgL2B\nxwIPBc6UtGW9/AngGcBi4DxJC2xfuqKxRUTEzKxwcuizK/AL29dImuo+ewAn2r4D+KWkRcCO9doi\n21cBSDqx3jfJISKikdnqc9gbOKFzfrCkCyXNl7R2LdsQ+HXnPotr2VTlERHRyIyTg6T7As8DvlKL\njgYeTmlyug744Exfo/NaB0paKGnhTTfdNFtPGxERfWaj5rA78BPbNwDYvsH23bb/DHyaJU1H1wIb\ndx63US2bqnyA7WNsb297+3nz5s1C6BERMcxsJId96DQpSdqgc20v4OJ6vADYW9L9JG0GbAGcC5wH\nbCFps1oL2bveNyIiGplRh7SkNSijjF7dKX6fpG0BA1f3rtm+RNJJlI7mu4CDbN9dn+dg4NvAqsB8\n25fMJK6IiJiZGSUH278DHtxX9vfT3P9I4Mgh5acBp80kloiImD2ZIR0REQOSHCIiYkCSQ0REDEhy\niIiIAbO1fEYsp00P/easPdfVRz1n1p4rIqIrNYeIiBiQ5BAREQOSHCIiYkD6HAKYvb6Q9INE/GVI\nzSEiIgYkOURExIAkh4iIGJDkEBERA5IcIiJiQJJDREQMSHKIiIgBSQ4RETEgySEiIgYkOURExIAk\nh4iIGJDkEBERA2acHCRdLekiSRdIWljL1pF0hqQr68+1a7kkfVTSIkkXSnpC53n2rfe/UtK+M40r\nIiJW3Gytyvp02zd3zg8FzrJ9lKRD6/lbgd2BLerticDRwBMlrQO8A9geMHC+pAW2fzNL8cUclJVi\nI9pZWc1KewDH1ePjgD075ce7OAdYS9IGwLOAM2zfWhPCGcBuKym2iIhYhtlIDgZOl3S+pANr2fq2\nr6vH1wPr1+MNgV93Hru4lk1VHhERDcxGs9KTbV8raT3gDEmXdy/atiTPwutQk8+BAJtssslsPGVE\nRAwx45qD7WvrzxuBU4AdgRtqcxH154317tcCG3cevlEtm6q8/7WOsb297e3nzZs309AjImIKM0oO\nktaQtGbvGHgmcDGwAOiNONoXOLUeLwBeXkct7QT8tjY/fRt4pqS168imZ9ayiIhoYKbNSusDp0jq\nPdeXbP+XpPOAkyTtD1wDvLje/zTg2cAi4PfAKwBs3yrpXcB59X5H2L51hrFFRMQKmlFysH0VsM2Q\n8luAXYeUGzhoiueaD8yfSTwRETE7MkM6IiIGJDlERMSAJIeIiBiQ5BAREQOSHCIiYkCSQ0REDEhy\niIiIAUkOERExIMkhIiIGJDlERMSAJIeIiBiQ5BAREQOSHCIiYkCSQ0REDEhyiIiIAUkOERExIMkh\nIiIGJDlERMSAJIeIiBiQ5BAREQOSHCIiYsAKJwdJG0v6rqRLJV0i6ZBa/k5J10q6oN6e3XnMYZIW\nSbpC0rM65bvVskWSDp3ZrxQRETO12gweexfwRts/kbQmcL6kM+q1D9n+QPfOkh4D7A08FngocKak\nLevlTwDPABYD50laYPvSGcQWEREzsMLJwfZ1wHX1+HZJlwEbTvOQPYATbd8B/FLSImDHem2R7asA\nJJ1Y75vkEBHRyKz0OUjaFHg88ONadLCkCyXNl7R2LdsQ+HXnYYtr2VTlw17nQEkLJS286aabZiP0\niIgYYsbJQdIDgJOB19u+DTgaeDiwLaVm8cGZvkaP7WNsb297+3nz5s3W00ZERJ+Z9Dkg6T6UxPBF\n218FsH1D5/qngW/U02uBjTsP36iWMU15REQ0MJPRSgI+C1xm+9875Rt07rYXcHE9XgDsLel+kjYD\ntgDOBc4DtpC0maT7UjqtF6xoXBERMXMzqTnsDPw9cJGkC2rZ24B9JG0LGLgaeDWA7UsknUTpaL4L\nOMj23QCSDga+DawKzLd9yQziioiIGZrJaKUfAhpy6bRpHnMkcOSQ8tOme1xERIxWZkhHRMSAJIeI\niBiQ5BAREQOSHCIiYkCSQ0REDEhyiIiIATOaIR0xaTY99Juz9lxXH/WcWXuuiNmWmkNERAxIcoiI\niAFJDhERMSDJISIiBiQ5RETEgCSHiIgYkOQQEREDkhwiImJAJsFFzHGZmBcrQ2oOERExIMkhIiIG\nJDlERMSA9DlExKxLP8jcNzbJQdJuwEeAVYHP2D6qcUgR8RdmtpLWJCSssWhWkrQq8Algd+AxwD6S\nHtM2qoiIyTUWyQHYEVhk+yrbdwInAns0jikiYmKNS7PShsCvO+eLgSc2iiUiYmTGtalLtmf1CVco\nCOmFwG62X1XP/x54ou2D++53IHBgPX0kcMUsvPy6wM2z8DyzbRzjSkzLJzEtv3GM6y89pofZnres\nO41LzeFaYOPO+Ua1bCm2jwGOmc0XlrTQ9vaz+ZyzYRzjSkzLJzEtv3GMKzEV49LncB6whaTNJN0X\n2BtY0DimiIiJNRY1B9t3SToY+DZlKOt825c0DisiYmKNRXIAsH0acFqDl57VZqpZNI5xJablk5iW\n3zjGlZgYkw7piIgYL+PS5xAREWMkySEiIgZMTHKQ9DBJD+qcP13SRyS9oY6QipgVkraU9OnWcUTM\nxMQkB+AkYA0ASdsCXwF+BWwDfLJhXHOCpAdL2kvSdo1efwdJD+mcv1zSqZI+KmmdRjFtLel0SRdL\nerekDSSdDHwHuLRFTDWuPSQd1Dn/saSr6u2FreKaSyRtLOnNjWN4uqSD6+3po379SUoOq9v+n3r8\nMspw2Q8Cr6Cs7dSMpAMkbVGPJelzkm6TdKGkJzSK6RuStqrHGwAXA68EPi/p9Q1C+g/gzhrPU4Gj\ngOOB39JudMmngS8BLwBuAi4AfgE8wvaHGsUE8BaWnid0P2AH4GnAP7QICMbzfd4X3zxJr5X0A+B7\nwPqN4thQ0o+BdwKb19s7JZ0racORBWJ7Im7ARZ3jnwDP6pxf2Di2i4H71OOXAucDDwb+BvhBo5gu\n6Ry/DTi+Hq/Z4t8L+Fnn+BPAOzvnFzT6N7qg7/yqlu+jThzn9Z1/vHN8TsO4xvF9viawL2WO1S+B\nDwKLG///nQLsN6T85cCpo4pjkmoO35F0kqSPAGtTqv69b8V3No0M7rL9p3r8XMoH8S22z6Q2hTXw\np87xrtQ5KLZvB/7cIJ5VJfXm5exK/f+rWs3Xub+kx0t6Qv3me0ffeStrd0+89Bply1xTZyUax/f5\njZQa8buBzW2/kfafB4+xfWx/oe3jgUeNKoixmQQ3Aq8HXgJsADy58yZ9CHB4s6iKP9ck9RvKB9+R\nnWurtwmJX0v6R8oKuU8A/gtA0urAfRrEcwLwfUk3A38AflDjeQSlaamF64F/n+LcwC4jj6j4saQD\nbC/VKS7p1cC5jWKC8XyfH0ZZrueTwAmSvtwojq6hX9olrUJZQWIkJmYSnKRH2b68Ht/P9h2dazvZ\nPqdhbM+ltKmvCnzd9gG1/K+Bt9ge+bZTktYDjqAk00/YPr2WPx3YzvYHGsS0U43ndNu/q2VbAg+w\n/ZNRxzOu6v/d14A7KE2oANtR+h72tH1Do7jG7n3eiW1zSpLYB9gCeAdwiu2fN4jlQ8ADgNd33udr\nAB8C/mj7dSOJY4KSw09sP6H/eNh5C7XJZE3bv+mUrUH5P/q/dpGBpAcAtI6jxvJ04LH19BLb320Y\ny/P7ikxZVvmC2vzWlKRdWPrf6jvT3X8Uxvl93lMHYrwUeLHtRzR4/fsA/wbsB1xTizcBjgPe5rIh\n2sqPY4KSw09tP77/eNh5C/Xb3kF0/piBT7b6lldj+gdKtXsNQMDtwHttj3zobx2l8VXgj5SOTCjf\nhlcH9rI9sMT7CGL63JDidYCtgf1bfRgva2iv7VtHFUu/cXyfA0hai1JjAPi57VZNlfeoTbi95PQL\n27+XdJ9Ok/hKNUl9Dp7ieNj5SEnamTIk8ljK8EwoH3w/lvR3tv+7QUxvB54EPM32VbVsc+Ajktax\n/e4Rh/Rx4Oj+jjpJL6e0F498W1nbrxhWLulhlHk1rXYzPJ/ynhZLv7d755u3CGpM3+f3ozR17UkZ\nrSTgYZJOAV4zqm/pw9j+A3CRJAG7SHoppSN/JENsJ6nmcCNlb2pROqZP7F2iVB+bjGmusZ0D/IPt\nn/aVbwv8h+2Rf8hIugLYxvYf+8pXpwwr3XLU8dh+5L291so4NFWOmzF9nx8BPJySCG6vZWtShktf\nY/ufRxjL5r0vYvV8J0rz1p6UGulBwIJuk9zKNEk1h+5sx4V91/rPR+2B/X8wALYvqG/UFtyfGGrh\nHyS1GMo6FiM4loekR1I6g1u9/ibTXbf9q1HF0mcc3+fPB3a0/ftOPLdLei1wDjCy5AC8CXitpPcA\nL6Ks4HAC8K/AQtvHjTCWiUoOj7T9ttZBTEGS1u7/RlDbjlvNRblW0q62z+qLaRfgugbxfENlvaJh\nIzha7AOCpK8z2CS5DmVE1ctGH9E9vsmSZqUeU+Y4rEe7ZDqO7/M/dxNDj+3/kzTqZpXeHJQDgCuA\noymjuu5oEMtEJYfdKDN9x9GHgNMlvYmlhx6+t15r4XXAqZJ+yJIO4O2BnWnQvk9ZEuLfgGskXUP5\n4NuYOoKjQTwA/cN5DdwCXNm4rfpx3XNJmwJvpcxEfk+DkHrG8X1uSWuzdCLtGXUNuTfy7iHAMyjD\naj8s6bvA6pJWs33XqIKZpD6Hn1HWlhn2Jmg6ggPuGQP+FpYexfF+219vGNP9KW2evZguBb44rLlp\nhDENjOBoFcu4U1nH6HBKx/gHgeNGNdJlmpjG6n0u6WpKEpjqc2GzkQbUp3aYP5eSKJ4CnGX7pSN5\n7QlKDncA1zL8TWDbTUZwjLtxGuIn6cGUZNVbQuAy4ATbtzSK55dMPdLNth8+ynh66jj9wykfwO+j\n/Bvd3SKWmD21X2avuozGyn+9CUoOzecyTKdO7jqYpT/4Pm77e43i6Q3x24MyxG8V4GGURcFGPsRP\n0qMp6yl9G/gpJck/nlL93qU3+33EMT24r2gV4MWUjsWf2H7BqGMCkHQ38GtK38NAUhjVDNt+kg4A\nvmf7yno+n7Ki7TWUhebGZpZ7nXn/5t4s7gav//8oHeLDhiMDbGx7pS6/Pkl9DmNL0nMo4/iPqDdR\n1jOaL+lg2y06XA+nrKG0yZAhfv/MaEdxALwLOMT2Sd1CSS+grNEz8g/iXo2ljpj6e8qIuAuA59hu\ntp8DsD+N5+5M4RDKHAfqmP1tKHMuHg98hNJsMlKStqb0HT2UsuTIJyh/i72muFZusf2GqS7WeRgr\nlxsuTTvKG0OWwB2XG2Xt+G2GlG8NfL9RTBcDfzWk/AHAxQ3iuWJFrq3kmO4DvBq4HPgMZR+HcXg/\n3R+YN6R8HnD/hnFd0Dn+EiXZ985/0iimH1OWqXgkJXndQGmKa/bvVONasIzrX13ZMUxSzeGvVTaJ\nGca29x9pNEt7iO2f9RfavlBSq8l54zTED+B3K3htZfolcBfwYcqY9K3rN1EAbH+1UVwfpayi2//6\nTwaeSbsNf8ZxVdb7ecms+yskHWL7LY1iGSuTlBy+MaRsY+CfaD+Jahw/+MZpiB/AepKGVbNFuz0K\nzqQ032xTb11m8MN5VLazfWB/oe1TJI162ZOuf6FMOF2V8s34ErhnVdarpnvgSnR/SY9nyfv8ju65\n2/WDbC5pqr4hAWut7AAmpkO6q64R9DbgqZTx1Z91w3Hpkv4XOHvYJcreE2sPubZSLWOInz3i0V2S\n3jHdddv/OqpYxp2ky2w/+t5eG4VpVmXFdXLjiOP5HtOPOGuyJ0ddn6ufKRMsrwfutL1SJ6NOVHKQ\n9Cjg7ZQOsPcDX/AIJ5VMpX5zmpLt748qlrlI0g62z2vwum8Afmv7s33l+1M+AD886pjq63+fMtLm\n3L7yHYAP2p6qebUJSc+g7OfwjNaxjKM6nPwFlGHcj7b90JG87qQkB0lfoczG/CBlxcylhvi58SS4\ncaNlbHPZsLoNgKTHUCYG7QP8r+3tG8RwPrCT+yaWSbovZS2crYc/cqXHtSPlPX4sS89ufzmwt+0f\nN4prF+BTLBkZ9F7gc5Ta6ZEt+mgkvcX2++rxi2x/pXPtPR7hkjvdLzl1sucelITweMpe13sCZ9se\nSbPuJCWHq1lSfez97DWZjLyZpEvSRQyv2ooS28g/ZOqU/ak0qW7XZSB6CeFPlHkX29u+etSx1Hh+\nZru/r6F37SL3LWMxSlqyb8JWtegSyryZGxvG9FNKH9+PgN2BLwCH2v54w5jGZhMwSZ+y/RpJJ1AG\nD5xOWT36O8Aij3i29sR0SNvetHUM03hu6wD62X566xi6JP0IeCDlj+UFtq+U9MtWiaFaRdL67tuo\npuEIs3vUJDBtP00D9pJJnV+TdG3LxFBpiuNh5yvbuvXnoykjui4DLrN9d4sRgq1WQhw5SS/rHO/c\nd+3g0Ue0lPsAG9m+pnsDNmLMErikZ0g6o8FL30CpWq/PktFJrau97we+KemvJa1Zb0+jjIwb+R7b\nc8Bakp7fuwGr9Z23ME6bgH0ZwPa2lJn2awJn1sUv1xz1l45JalYam+rjkNi+ARxm+6K+8scB77H9\ntw1iGsf24QdR1t/vbQK/FvCs/o7XEce0O3AopfnGlOabo2x/q1VM40rDt1Xtse1XjiyYqi418jvK\n+3p1oDe3R5SJcPcZdUz9JG1H6Xt4EbDY9pNG8roTlBzGdg9pSefZ3mGKa03arsexfbirtqm/mJIo\nNrG9ceOQltJqBNWQOB4AZfJi61hiZiQJeIrtYcPeZ91YNVmsZONUfew33YSWVjNHx6p9WNKLKBuf\n/LEGdyNlDZyPTzEmfOT6R1BRRgi1iuW1lBrNGuVUtwPvtf3JhjH1T2I0cDPwQ9u/bBBSb1n611CW\ngb8QmD8Ow9u7Ou+rvYHfMqL31SQlh0dJupBSXXx4Paaet16ue6GkA2x/ulso6VUsGYo4amv1tQOv\n1j1v0Kz0UuATkr5N2Trx267LUNf+mSbGbQRVjentwJOAp7nuSVwnfn5E0jq2W82SHrYV6KbA4ZLe\nafvEIddXtuMo/28/AJ5NWeb8kAZxLGUc3leT1Kw07bfLxh8w61OWwr6Tpcel35eyfvv1DWI6luln\njrZoH34gsBflG9S2wKmUvQqaTBLsG0F1YmcEVesNYq6gLOT4x77y1YGf2d6yTWTDqWwTemaLfr9u\ns22dvX1uy/7HGsdYvK8mpubQ+/DXGG1e01OHQj5JZU+H3rj0b9r+TsOY9mv12lOxfRvlm95xKnsp\nvBD4aP023KLP4QZgQ5aMoLqS9k2UUJL3wG59tv8gqcW6WNOyfWttT2/hngmMtu9qF8ZSxuJ9NUlD\nWe9Xvw1fDRwDfBq4WtL8OqO1ZWy7ANj+LvAN2x/rJYZWQ/wkfbhzfEjftWNHHtDSr782ZdTSS4B1\ngP9sEYftPYHHUWp771TZGW7tOkO5pWsl7dpfWN9nK3U9nhVRvxT9Zpl3XDm2kXRbvd1OWVn3Nkm3\nS7qtRUDj8r6apGald1H6Fl7jwc1rrrE96s1rurGN3TDbcYupjrrZi9IG+3hgAaXa/T2PyZt4XEZQ\nSXospcnthyzdTLkzsIfraqh/ygGYAAAWA0lEQVQN4hq2EsA6wP8A+9q+bPRRjb/a7PxiSnPqyN5X\nk5QcLgZ2dN8eBfVD5xzbWw1/5Mo3jsNslxFTi+RwM2WPghMpndF/WsZDmpL0sMb9WPendOI/thZd\nCnxxWHPTCGPq7/czZcezVsvSzxm1tvy/lOQwkvfVxPQ5MH6b1ywVxhTHw85HZZX6hlylc9xrkG2x\n/8XGtv/Q4HVXSMvEUF//j8D8bpmkJ0vax/ZBjcJaD1i3f4JgnUh4o+1WI/PGiqR/AU6yfbnKXu7/\nRdkv5C5Kwk9ymGXjtnlN1+aSFlCH1dZj6nmrkS8PojRJ9P69uquwtkhY506RxJstTjgXqGxcsw+l\nWeKXtNuACMos+1cMKb+UMvu+yd4JY+gllD3TAfatP+cBW1IGZJw5iiAmKTn0f9h1ta457NE57l+T\np8kaPR6/hQrHbnHCcVPnCrxT0pYsGSN/M2XNHrn9YoprDqtR2b5G0rrDHjCh7uz0oz2LMpz1buAy\nSSNbzmNiksMYftjdo9U4/elIOrg3I1rSY1t1Yva0bqYZRtIBlA7xK+tQzPmUTVmuBvbz6Pe8eHj9\neTllUtdzbS+qsf7TiGMZZrodDf9qZFGMvzskbUUZ0vp04E2dayNbMWFikoOkTaa7bvtXo4ql3xSj\nOO7RqMnklZTlKQA+D7SeGHQ7g30zNwPfBd5q+5YGYR1C2VAHyrf0rSnNgI8HPgI8ZcTx9Drpn08Z\n2fJdSb1O/HEYwH+mpCOBt/e+Gdek+q+UPQuieD1lePY84EO9pUUkPRv46aiCmKTRSr0P4O4fiSn/\nAevZbtHJCiw1ikPANynT+O/R4ltz31DWpgsTTqX2Ie0HPMn2ixq8/gUuyysj6UvAj21/pJ63GNG1\nZm+Ydj1fg9JkuQ+lPf944BTbp48yrr54PgPsCFxQi7cBFgIHdGOP9iYmOfSra5e8Ffgb4KO2P9Y0\noKrVvIYhcVwFvJEyWul9wJu71xusrTSllnNBgOdQJnBdA+zSa36TdJntR486pqnURPpCyjahAxPk\nRhzL5iwZYntJb/2nKCT9LXBhZ1WHf6E0V14DHOIRLVI4Mc1KPZK2AA4HnkjZT/p14z5mvpGzged1\njrt7Spi2o17uUTvoWr2P/4XyrXdVYEEnMfw10PQDr36gDBQDZ9drN9r+1IhjepntL9i+StIGtv+7\nc+2ePq7gSGAnAEnPBV7Gksmfn6J0Uq90E1NzqB08h1O+sbyPsmDb3W2jKiR1v/V+kTKW+Z7mrwYd\nm2NnimVE1qYM+/uh7SNGHBJwz2Jta9r+TadsDcrfVrM9FCSdRul3mKqv4bi6TMPIjNus+3Glzt7k\nkuYDV9h+bz0f2b/TJNUcfgb8mtKmvyOwY3eRLduvaxQXlBpMz/XAv3fOTYPx35I+bPv19fiQXlt6\nPT+2wcJ8/bvhGbgF+Ijtb444lq51gIPqkhVQdoL7pPv2lW7g7rpQ4VCNJn6O037N40x15YbfA7sC\n3T047j+qICYpOexP+/kMQ43B+PNhnto53pcy+qZn5KOnbA+bPNWUyl7kX6KMWDq+Fm8H/FjS33Wb\nTRpY1nu9xd/COK4EMI4+TOmwvw24zPZCuGdC48gWTpyY5GD72Kmu1aaBZiQ9dZrLtv2DkQWzxHTf\n8pqQtAfwFqDX0bsQOML2DyU9yKNffv2DwJ62u8MLF0g6BfgPSr9WK/dR2f9iGNFmCZRx3nBrbNie\nr7Kp1XqUFo+e6xk+w3ylmJjkIOmHtp9cjz9v++87l8+l7Tj+Nw8pM+Ub+sa0+UMeq7WVJP0Dpfb3\nFkpSgLLS6PskfQR4G2VY5Cg9sC8xAGD7grrib0vnUMbL9w/dppb918gjWpLUYxq9jnvK0us7A/8N\nYPs6SQezZP7Ryo1jgjqku6uM9neGjdU4/vqGeDulw/VI219vEMPVlDWnhi43Ynuk3/QkXQbsbPvW\nvvIHA4uBf2ow+uYyyhyL3/SVrwP8P9uPGmU806md5M+nDGV9Tut4uiStAuxj+4utYxkH49JxPzE1\nB6Zv0xyLDKmyQcs/U+J5j+0zWsUyjsuN9CeGWnaLpGtGnRiqDwGnS3oTSxYm3I6ywNyHRh2MpNVs\n39U5vy9lHsZLKcMfT6YMhWyiNnMdRNnlbAFwBnAwZT7Nzygj9WJMOu4nKTmsJWkvSjPJWp2hkaIs\nyteMpOdQhtn+lrK0wA9bxtNT+2J2B3rfgC+l7KVw19SPWmluk7SN7W4bLJK2ofy7jZztYyT9D2UF\nze5opXe3qO1RktIbJT2TMi7+mZTlRY4HdhiDTv3PUyYM/gh4FaUpUJR+mwume+CEGYuO+0lqVvrc\ndNdb/uGo7Ou7mPLtaeA/xPbzBh608mPakLLezXWU9VxEmYTzEODptv9nxPE8mfLN8nMsvbvZvsDL\nxiWhtiTpS7ZfWt9PP6As/tdbl+eqUTcFDonvItuPq8erUt5bm7jhBkTjSNLvgUXUjvt6TD3f3PYa\no4hjYmoOY/CtaTrjOJT1SOBo2x/uFkp6HfBvLFlnfiTqiKQnAq+lrKcEpSazk+3rRxlLl8r+xwez\npHZ1GfBx299rEE6v2e0JlAlwZ9ZlUE6kzaCGfvesRGD7bkmLkxiG2gZYnzIvq2tjyoilkZikmsMT\ngWMomfgi4JUesz1rVbZ2fEQ9XdTyD0fS5VN1qEq6wvYjRx3TVCTt3GJOQW0O/DhwBKXPQZQP5rcD\nB9s+bcTxyH1/0JKeRGliegGlZnqK7WNGGVcnlruB3pagoiw//ft6bNtTDb2dKJK+ARxm+6K+8sdR\n+iL7J4SunDgmKDksBA5jyZpBr7I9kjVKlqW27b+Hskz2NZQ/lo0pTSiHt1j7aboRXC1Gd9VmiBdT\nOjO/ZfuSuu7M24DVW4w2k/Q9ykJo/f0gWwMfs/3Xo45pKnVE0K6U0Ur7t44npibpPNs7THHtnqa5\nlW1impWAVTqjf74i6bCm0Szt/cCawGauyxbXkR0fqLdDGsT0oCnWMxLQ4hveZykJ81zgY7UjeHvg\nUNtfaxAPwEP6EwOA7Qslrd8ioGlsRlnMbafWgcQyrTXNtWz2sxKs1fdht9S52y5B/Vxgy26TgO3b\n6sSvy2mTHL7P4HpGPWePMpBqe2Br23+uzW/XAw93m01+en63gtdGQtJDKQsTvhR4HKWvaO+mQcXy\nWCjpANuf7hZKehVLBmOsdJPUrDTdaCXbfuXIgukj6ee2t7y31ybJOK7iKel/GZ4oBTzZ9nTbYq40\nkg6k9DNsCJxUb6fa3qxFPHHv1FrnKcCdLD0y777AXqMagDExyWGcSfoa8FXbx/eVvwx4caOhrC+f\n5rJtf35kwbDU8D5YeoifgD/3ljgecUzT9im40d7gku6kzCV4Y2fRtuZDWePeqSPhtqqnl9ge6Vaq\nSQ5joM4p+CrwB5b+prA65ZvCtQ1immpnvOcBG9oeaZOklmylulQxpR/iMNvPHnJ9ItUlRV5EqT08\nhFJz2M/2xk0DizklyWGMSNqFJTNtL7V9Vst4eiQJ+DvKtqqXUtZ7unD6R63UeB5PaUd/EfBL4GQ3\n2EVMS/YlH7hEqV2NfGnzgUCkjSj9DvsAa1CGsr6tbVQxFyQ5jAFJOwDr2v5WX/nulO0cR9YJ1ff6\nq1EmnL2Jssrnv9m+olEsW1I+4PYBbga+DLzJ9rAaxahimva1XfcAHhf13/Altt/VOpYYf6u0DmBU\nJO0g6SGd85dLOlXSR+sqmi29l/KNvN+llGGuIyfpoPr62wG72d6vVWKoLqfsiPdc20+2/TGg9Tav\n9wE2sn1N9wZsRMORgJJOkDSwPLbtnwMTP7ghls/EJAfK5it3Ar3NdY6iLEj2W8rM6ZbWHPYts5at\n2yAegI9R5jM8mbKBzYX1dpGWbNIySs+nrMXzXUmfrivYtt6E6MOU3br63VavtfI3wH/VBN/vsUPK\nIgZM0jyHVTtLPr8EOMb2ycDJklqvCDndkMe/GlkUSxurYY91otvX6r4Ee1A2sllP0tGUdvTTG4S1\nfv8SBwC2L5K06ejDucdiymq6x9Wmyf1s31yvtU6oMUdMUs1hVS3ZDnRXyoqjPa2T5JmSjqwdv0Dp\nBJZ0BEvHOTL9TSVDmk6asP0721+q68tsRFkx9q2NwhmLmaxD2Pb1dXmY71AmVe3WMJ6Yg1p/KI7S\nCcD3Jd1MGTL6AwBJj6DRfgAdbwQ+Ayzq1GK2oWyHeUCLgCTdzvQjcZovkuayA9sxtGsWHIuZrNOx\n/e+SzgK+UBcKvG/rmGJumKjRSpJ2AjYATrf9u1q2JfAA2z+Z9sEjIGlzOpvG2L6qZTwxvXGZyTok\nroGFEeuSIx8E/sH2JLUYxAqaqOQA98w67H4Af7dlPEB3Q/GB5aclHdxiDH8sv9YzWYfEs4rtP09x\nbQPb1406pph7JiY5dGYh/5El3/K2o+Es5E5sY7GheNw7knbpJQJJm7nuulbPn99qMUdJb5juuu1/\nH1UsMXdNUp/Dxyk7mx3bLaxrCH2SMgKmlbHYUDzutQ9QNvcBOLlzDGXDn1Yr/a7Z6HXjL8gkJYfH\n2N6rv9D28ZIObxFQN4wpjoedx/gYy6Ru+1+nulaHAkcs0yQlh6GdcHWHrNb76z6qTiwT8PDOJDMB\nWUlzfI1tUq/NqBsAF9q+U9J6lLkh+wEPbRlbzA2TlBy+IenTwOs7I5XWAD4EjHSv3yEGljqIOWFz\nSQuoSbweU8+bTSKU9HrgcMqS5veT9EnKEi3HU/rZIpZpkjqk70PZCWs/lt6n+TjgbbbvbBfdcLVW\ns4/tL7aOJQaN8X4Ol1I2G7pV0ibAz4GdWy3gGHPTxCSHHkmrA4+op7+w/fuW8cA9+0UfRNm5awFw\nBnAwZXLcz2y37CyPOWbIiLeftdgMKea2iUkOdVnsX/cmJtVRSi+g1CLe2Vl3qUVspwK/oezetSuw\nHqVmc4jt1us+xRSm2c8BgFb7OUi6ETixU7R399z260YeVMw5k5QcfgL8Ta1qP5Xyx/KPwLbAo22/\nsGFsF9l+XD1elbL66Ca2/9gqpli2zn4OAr4JLLUbXas1qCTtO91128eNKpaYuyapQ3qcV2X9U+/A\n9t2SFicxjL/uh7+kO8Zlc5+pPvzrEhp/O+JwYo6apDVWxnlV1m0k3VZvtwNb944lDdsvIGK5SFpV\n0rMlfZ7ShPqS1jHF3ND6Q3GUxnZVVtut51nECpDUnRG9et3b+p7Jby0Xc6wjqV5Kaeo6F9gZ2Gwc\nBmDE3DAxfQ4w/quyxtwiabpFG217l5EF0yFpMfAr4Gjga7Zvl/RL22O1gVOMt4mpOUj6K+B823+q\n54+kfKu6ptUCaTG32X566xim8J/AnpQmpLvraLjJ+RYYs2Jiag6Szgb2t31lbUo6F/gi8BjgXNuH\nNQ0w5pw66m0qtv2DkQXTp+4q+DRgH8qXoAcB+wOn2f6/VnHF3DFJyaE7XPRdwDq2D5J0X0qN4nFt\nI4y5RtLXhxQb2BrYeFz6kurqAM+iJIpn2V63cUgxB0xMsxJLV6t3Ad4PUBclG7oxSsR06j7W95C0\nM2Wp7uspc2jGQm1K/QZlfbGTWscTc8MkJYcLJX0AuJayfMbpAJKm2yQ+Ypkk7Qr8M+ULyHtsn9E4\npOns1DqAmBsmKTkcABwCbAo8szOk7zGUTVsi7hVJz6Gsfvpb4O22f9g4pIhZM0l9Dg+0PXRCmaRN\nbP9q1DHF3FabIxcDP2PIaCDbzxt5UAzMv1jqEvAN2xuMMp6Ymyap5vA96jaOks6yvWvn2tdYeovH\niOUxrkNZPzjNtctHFkXMaZOUHLrbNq4zzbWI5dLbr6GuWdRbBn5R63Wxxnj+Rcwhk5QcxnZLx5ib\n6lpd7wFeSWcDKUmfAw7vTbhsENfz+4oM3AxcYPv2BiHFHDRJyWE9SW+g/AH3jqnn89qFFXPY+4E1\nKWsW3Q73bNz0gXo7pFFcw1ZeXYeyoOP+tr8z5HrEUiapQ/od0123/a+jiiX+Mki6EtjSfX9EdU+O\ny21v0Say4er+EyfZfmLrWGL8TUzNIR/+sRK4PzHUwrsljd23LtvX1NnSEcs0Mfs5SHq/pFcPKX+1\npKNaxBRz3qV1u9mlSHoZYzgqqC42eUfrOGJumKRmpfOB7Yc0AawCXGh7qzaRxVwlaUPgq5T9Qc6v\nxdsDqwN72b62UVxfZ3CQxTqU5epfZvtHo48q5pqJaVYC7jdFE8Cf6wqWEfdK/fB/oqRdgMfW4tNs\nn9UwLBic8W/gFuBK23c2iCfmoElKDn+QtIXtK7uFkragfPOLuFck7QCsa/tbdLadlbQ7cKPt86d8\n8ErUm38RMRMT0+cA/AvwLUn7SXpcvb0C+Ga9FnFvvRe4dEj5pdRVf1uQtL+kN3fOF3f2JH9Nq7hi\nbpmYPgcASVsBbwZ6/QuXAO+3fVG7qGKuknSe7R2muHah7a1HHVN97fOA3WzfUs9/avvxdSb3t23/\ndYu4Ym6ZpGYlbF8M7CvpAfU8O2LFTKw9zbW/GlkUg9RLDNVXAGz/UdLqjWKKOWaSmpWQ9FpJv6Is\ndXCNpGskvbZ1XDFnnSnpyO6ABhVH0OmDaGCpPUpsvwfuGZmXXeBiuUxMcpD0duC5wNNsP9j2gymr\nau5er0XcW28ENgcWSTpZ0snAlcCW9Vorp0t695DyI6ibXEUsy8T0OUi6Atimf8XMWs3+me0t20QW\nc52kzVkylPUS21c1jmcN4DPADpS9JgC2ARYCB2TxvVgek9Tn4GFLKdv+Q/aQjhUh6WW2v2D7Kkkb\n2P7vzrWDbX+8RVy2fwfs05e0LrX9ixbxxNw0Mc1KwLV1r9+l1AlM1zWIJ+a+N3SOP9Z37ZWjDKSr\nLt9BrcHcavvrvcQg6eBWccXcMkk1h9cBp0r6IUsvdbAzsEezqGIu0xTHw85H6Q3AF+rxx1h6l8NX\nAk1qNDG3TEzNwfYllPkNZwOb1tvZwFb1WsS9Na4bSI1r0oo5ZJJqDtQ+h/ndMkmrSPo7219sFFbM\nXY+SdCHlA/fh9Zh6vnm7sMY2acUcMkmjlR4IHARsCJwKnFnP30QZrZSmpbhX6uY5U7J9zahi6ZL0\ne2ARNWnVY+r55rbXaBFXzC2TlBxOBX4D/AjYFViP8sdyiO0LWsYWf1nqZLN9WtVGxzVpxdwyScnh\nItuPq8erUkYobTJseGvE8uirjS4AzgAOpkyAG7vaaOukFXPLxHRIA3/qHdi+G1icxBAz9HngkcBF\nwKuA7wIvBPZsmRgkPVDSYZI+LumZdUmPfwSuAl7cKq6YWyap5nA38DuWjNZYHfh9PbftB7aKLeam\nca2Npgk1ZsPEjFayvWrrGOIvzlK1UUnjUhvdvJO0PsOYJK2YWyYmOdS17F8DPAK4EJhv+662UcUc\nt42k2+qxgNXreeva6LgmrZhDJqlZ6cuUP5ofALsD19g+pG1UEbOv04QKNWmRJtS4lyYpOXTbh1cD\nzrX9hGU8LCJiIk3qaKU0J0VETGOSag6pakdELKeJSQ4REbH8JqlZKSIillOSQ0REDEhyiIiIAUkO\nERExIMkhIiIGJDlERMSA/w9SKuN7+fmvVgAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "tags": [] } } ] }, { "cell_type": "code", "metadata": { "id": "k_XZ38T6mcLl", "colab_type": "code", "colab": {} }, "source": [ "# 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": "a7bb4468-0ee6-461a-8d45-76a8f0b4c9f3", "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": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Tipo de Alertas e RestriçõesNacionalidadeMês/AnoUFQuantidade
0SOLICITAÇÃO DE REFÚGIOAFEGANISTÃO12/2001DF1
1SOLICITAÇÃO DE REFÚGIOAFEGANISTÃO01/2010DF1
2SOLICITAÇÃO DE REFÚGIOAFEGANISTÃO03/2010DF2
3SOLICITAÇÃO DE REFÚGIOAFEGANISTÃO03/2010SP2
4SOLICITAÇÃO DE REFÚGIOAFEGANISTÃO08/2010DF1
\n", "
" ], "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": 15 } ] }, { "cell_type": "code", "metadata": { "id": "nwdMNeblpFbs", "colab_type": "code", "outputId": "3f13b78d-1c15-41f8-b39b-ddf06f192a28", "colab": { "base_uri": "https://localhost:8080/", "height": 34 } }, "source": [ "# Quantidade de linhas e colunas do dataframe\n", "dfs.shape" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "(11656, 5)" ] }, "metadata": { "tags": [] }, "execution_count": 17 } ] }, { "cell_type": "code", "metadata": { "id": "Qx5bqo5DpIYz", "colab_type": "code", "outputId": "f504a230-7fa0-438e-a426-a3491a39f9ec", "colab": { "base_uri": "https://localhost:8080/", "height": 68 } }, "source": [ "# Todas as colunas do dataframe\n", "dfs.columns" ], "execution_count": 0, "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": 19 } ] }, { "cell_type": "code", "metadata": { "id": "nZv5FTSApHzq", "colab_type": "code", "outputId": "2217f425-112d-44a5-8f5d-2d9800935201", "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": 0, "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": 21 } ] }, { "cell_type": "markdown", "metadata": { "id": "KvDUKjk6p3fv", "colab_type": "text" }, "source": [ "Informação **NACIONALIDADE**" ] }, { "cell_type": "code", "metadata": { "id": "Gc5fA11SpGK2", "colab_type": "code", "outputId": "55203f09-fb66-46d6-8037-7bdb06f4d44e", "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": 0, "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": 22 } ] }, { "cell_type": "code", "metadata": { "id": "g5bbn_u8p0q3", "colab_type": "code", "outputId": "c021f9d5-90b1-4d2c-8869-740c8fff859b", "colab": { "base_uri": "https://localhost:8080/", "height": 1071 } }, "source": [ "# Agrupando dados, inicialmente por Nacionalidade\n", "dfs['Nacionalidade'].value_counts()" ], "execution_count": 0, "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", "TRINIDAD E TOBAGO 2\n", "UZBEQUISTÃO 2\n", "MACEDÔNIA 2\n", "AUSTRÁLIA 2\n", "ESLOVÁQUIA 1\n", "MALGAXE 1\n", "LETÔNIA 1\n", "LAOS 1\n", "CORÉIA DO NORTE 1\n", "BELIZE 1\n", "NORUEGA 1\n", "IUGUSLAVIA 1\n", "ESTÔNIA 1\n", "BAREINE 1\n", "GUAM 1\n", "BÉLGICA 1\n", "MONGÓLIA 1\n", "BARBADOS 1\n", "DAOME 1\n", "BÓSNIA E HERZEGOVINA 1\n", "CAMBOJA 1\n", "CROÁCIA 1\n", "SUÍÇA 1\n", "MAURÍCIO 1\n", "BUTÃO 1\n", "GABÃO 1\n", "BELARUS 1\n", "IRLANDA 1\n", "ST. PIERRE ET MIQUELON 1\n", "CANADÁ 1\n", "Name: Nacionalidade, Length: 165, dtype: int64" ] }, "metadata": { "tags": [] }, "execution_count": 23 } ] }, { "cell_type": "code", "metadata": { "id": "BFoh58aOqIx8", "colab_type": "code", "outputId": "0789ba66-d4e4-4751-97ee-9a4cd92b804b", "colab": { "base_uri": "https://localhost:8080/", "height": 1969 } }, "source": [ "#selecionando uma Nacionalidade específica\n", "dfs.loc[(dfs['Nacionalidade'] == 'BOLÍVIA')]" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Tipo de Alertas e RestriçõesNacionalidadeMês/AnoUFQuantidade
1082SOLICITAÇÃO DE REFÚGIOBOLÍVIA02/2002SP1
1083SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2002SP7
1084SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2002SP1
1085SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2006SP1
1086SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2006SP1
1087SOLICITAÇÃO DE REFÚGIOBOLÍVIA11/2008AC16
1088SOLICITAÇÃO DE REFÚGIOBOLÍVIA11/2008DF3
1089SOLICITAÇÃO DE REFÚGIOBOLÍVIA11/2008RO3
1090SOLICITAÇÃO DE REFÚGIOBOLÍVIA12/2008AC35
1091SOLICITAÇÃO DE REFÚGIOBOLÍVIA12/2008DF5
1092SOLICITAÇÃO DE REFÚGIOBOLÍVIA12/2008RO1
1093SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2009AC142
1094SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2009DF25
1095SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2009MS1
1096SOLICITAÇÃO DE REFÚGIOBOLÍVIA02/2009AC1
1097SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2009DF1
1098SOLICITAÇÃO DE REFÚGIOBOLÍVIA04/2009AC11
1099SOLICITAÇÃO DE REFÚGIOBOLÍVIA04/2009DF2
1100SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2009AC6
1101SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2009DF2
1102SOLICITAÇÃO DE REFÚGIOBOLÍVIA08/2009RO1
1103SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2010AC5
1104SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2010AC4
1105SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2010MS1
1106SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2010AC1
1107SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2010MS1
1108SOLICITAÇÃO DE REFÚGIOBOLÍVIA08/2010AC2
1109SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2010AC5
1110SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2010MS1
1111SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2010AC3
..................
1165SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2017SP1
1166SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2017DF1
1167SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2017RJ1
1168SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2017SP2
1169SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2018AM1
1170SOLICITAÇÃO DE REFÚGIOBOLÍVIA02/2018SP1
1171SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2018MS1
1172SOLICITAÇÃO DE REFÚGIOBOLÍVIA04/2018SP1
1173SOLICITAÇÃO DE REFÚGIOBOLÍVIA05/2018AM1
1174SOLICITAÇÃO DE REFÚGIOBOLÍVIA05/2018RR1
1175SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2018AC3
1176SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2018MG1
1177SOLICITAÇÃO DE REFÚGIOBOLÍVIA06/2018SP1
1178SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2018AM1
1179SOLICITAÇÃO DE REFÚGIOBOLÍVIA08/2018AM1
1180SOLICITAÇÃO DE REFÚGIOBOLÍVIA08/2018SP1
1181SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2018DF1
1182SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2018MT1
1183SOLICITAÇÃO DE REFÚGIOBOLÍVIA09/2018SP1
1184SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2018AM4
1185SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2018GO1
1186SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2018RR1
1187SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2018SC1
1188SOLICITAÇÃO DE REFÚGIOBOLÍVIA12/2018AC1
1189SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2019DF1
1190SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2019MS1
1191SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2019SP2
1192SOLICITAÇÃO DE REFÚGIOBOLÍVIA02/2019SP3
1193SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2019RJ2
1194SOLICITAÇÃO DE REFÚGIOBOLÍVIA03/2019SP1
\n", "

113 rows × 5 columns

\n", "
" ], "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": 28 } ] }, { "cell_type": "code", "metadata": { "id": "rW4l5-lzrPSO", "colab_type": "code", "outputId": "8a5b7385-085f-4d7f-a770-3e2e80c27f6e", "colab": { "base_uri": "https://localhost:8080/", "height": 235 } }, "source": [ "dfs.loc[(dfs['Nacionalidade'] == 'BOLÍVIA') & (dfs['UF'] =='AM')]" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Tipo de Alertas e RestriçõesNacionalidadeMês/AnoUFQuantidade
1157SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2016AM1
1169SOLICITAÇÃO DE REFÚGIOBOLÍVIA01/2018AM1
1173SOLICITAÇÃO DE REFÚGIOBOLÍVIA05/2018AM1
1178SOLICITAÇÃO DE REFÚGIOBOLÍVIA07/2018AM1
1179SOLICITAÇÃO DE REFÚGIOBOLÍVIA08/2018AM1
1184SOLICITAÇÃO DE REFÚGIOBOLÍVIA10/2018AM4
\n", "
" ], "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": 36 } ] }, { "cell_type": "code", "metadata": { "id": "hhkoktMiq38N", "colab_type": "code", "outputId": "1187b4e1-317e-4a4e-83e1-fb94a1f2e11b", "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": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Tipo de Alertas e RestriçõesNacionalidadeMês/AnoUFQuantidade
3960SOLICITAÇÃO DE REFÚGIOESTÔNIA12/2017AM1
10693SOLICITAÇÃO DE REFÚGIOUZBEQUISTÃO07/2009DF1
10694SOLICITAÇÃO DE REFÚGIOUZBEQUISTÃO06/2018SP2
\n", "
" ], "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": 37 } ] }, { "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": { "id": "Od1xnYkTm_kt", "colab_type": "code", "colab": {} }, "source": [ "url1 = 'https://www.justica.gov.br/seus-direitos/refugio/anexos/decisoes-conare-ate-jan-2019.xlsx'" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "Cnysw3XanB-7", "colab_type": "code", "colab": {} }, "source": [ "dfd = pd.read_excel(url1,enconding='latin',delimiter=\";\")" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "KRhSD5ZGnP8j", "colab_type": "code", "outputId": "fd56d182-2276-43f1-bb0b-7e3a85f6269b", "colab": { "base_uri": "https://localhost:8080/", "height": 204 } }, "source": [ "dfd.head()" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TOTAL= 1510STATUSDATA SOLICITAÇÃOPAÍS DE ORIGEMGÊNEROANO DE NASCIMENTOCIDADE SOLICITAÇÃOANO DECISÃO
0NaNELEGIBILIDADE / DEFERIMENTO1993-04-15ANGOLANaNDesconhecidoRJ (RIO DE JANEIRO)1993.000000
1NaNELEGIBILIDADE / DEFERIMENTO1993-04-15ANGOLANaNDesconhecidoRJ (RIO DE JANEIRO)1994.487979
2NaNELEGIBILIDADE / DEFERIMENTO1995-06-22LIBÉRIANaNDesconhecidoRJ (RIO DE JANEIRO)1995.000000
3NaNELEGIBILIDADE / DEFERIMENTO1995-06-22LIBÉRIANaNDesconhecidoRJ (RIO DE JANEIRO)1994.487866
4NaNELEGIBILIDADE / DEFERIMENTO1992-07-22APÁTRIDANaNDesconhecidoRJ (RIO DE JANEIRO)1992.000000
\n", "
" ], "text/plain": [ " TOTAL= 1510 STATUS DATA SOLICITAÇÃO PAÍS DE ORIGEM \\\n", "0 NaN ELEGIBILIDADE / DEFERIMENTO 1993-04-15 ANGOLA \n", "1 NaN ELEGIBILIDADE / DEFERIMENTO 1993-04-15 ANGOLA \n", "2 NaN ELEGIBILIDADE / DEFERIMENTO 1995-06-22 LIBÉRIA \n", "3 NaN ELEGIBILIDADE / DEFERIMENTO 1995-06-22 LIBÉRIA \n", "4 NaN ELEGIBILIDADE / DEFERIMENTO 1992-07-22 APÁTRIDA \n", "\n", " GÊNERO ANO DE NASCIMENTO CIDADE SOLICITAÇÃO ANO DECISÃO \n", "0 NaN Desconhecido RJ (RIO DE JANEIRO) 1993.000000 \n", "1 NaN Desconhecido RJ (RIO DE JANEIRO) 1994.487979 \n", "2 NaN Desconhecido RJ (RIO DE JANEIRO) 1995.000000 \n", "3 NaN Desconhecido RJ (RIO DE JANEIRO) 1994.487866 \n", "4 NaN Desconhecido RJ (RIO DE JANEIRO) 1992.000000 " ] }, "metadata": { "tags": [] }, "execution_count": 47 } ] }, { "cell_type": "code", "metadata": { "id": "Vn-JnvSps6ac", "colab_type": "code", "colab": {} }, "source": [ "dfg = dfd.drop(['TOTAL= 1510'], axis=1)" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "B8l2HzLzliJD", "colab_type": "code", "outputId": "896d184c-827f-472c-fac4-e24535ef6b53", "colab": { "base_uri": "https://localhost:8080/", "height": 34 } }, "source": [ "# quantidade de linhas e colunas do dataframe\n", "dfg.shape" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "(1515, 7)" ] }, "metadata": { "tags": [] }, "execution_count": 49 } ] }, { "cell_type": "code", "metadata": { "id": "g4qFUbLPluad", "colab_type": "code", "outputId": "cc8354f7-8579-4fbb-a51d-26fe61108bfd", "colab": { "base_uri": "https://localhost:8080/", "height": 204 } }, "source": [ "# as últimas 5 linhas\n", "dfg.head()" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
STATUSDATA SOLICITAÇÃOPAÍS DE ORIGEMGÊNEROANO DE NASCIMENTOCIDADE SOLICITAÇÃOANO DECISÃO
0ELEGIBILIDADE / DEFERIMENTO1993-04-15ANGOLANaNDesconhecidoRJ (RIO DE JANEIRO)1993.000000
1ELEGIBILIDADE / DEFERIMENTO1993-04-15ANGOLANaNDesconhecidoRJ (RIO DE JANEIRO)1994.487979
2ELEGIBILIDADE / DEFERIMENTO1995-06-22LIBÉRIANaNDesconhecidoRJ (RIO DE JANEIRO)1995.000000
3ELEGIBILIDADE / DEFERIMENTO1995-06-22LIBÉRIANaNDesconhecidoRJ (RIO DE JANEIRO)1994.487866
4ELEGIBILIDADE / DEFERIMENTO1992-07-22APÁTRIDANaNDesconhecidoRJ (RIO DE JANEIRO)1992.000000
\n", "
" ], "text/plain": [ " STATUS DATA SOLICITAÇÃO PAÍS DE ORIGEM GÊNERO \\\n", "0 ELEGIBILIDADE / DEFERIMENTO 1993-04-15 ANGOLA NaN \n", "1 ELEGIBILIDADE / DEFERIMENTO 1993-04-15 ANGOLA NaN \n", "2 ELEGIBILIDADE / DEFERIMENTO 1995-06-22 LIBÉRIA NaN \n", "3 ELEGIBILIDADE / DEFERIMENTO 1995-06-22 LIBÉRIA NaN \n", "4 ELEGIBILIDADE / DEFERIMENTO 1992-07-22 APÁTRIDA NaN \n", "\n", " ANO DE NASCIMENTO CIDADE SOLICITAÇÃO ANO DECISÃO \n", "0 Desconhecido RJ (RIO DE JANEIRO) 1993.000000 \n", "1 Desconhecido RJ (RIO DE JANEIRO) 1994.487979 \n", "2 Desconhecido RJ (RIO DE JANEIRO) 1995.000000 \n", "3 Desconhecido RJ (RIO DE JANEIRO) 1994.487866 \n", "4 Desconhecido RJ (RIO DE JANEIRO) 1992.000000 " ] }, "metadata": { "tags": [] }, "execution_count": 51 } ] }, { "cell_type": "code", "metadata": { "id": "zqEuTkrRlvGr", "colab_type": "code", "outputId": "fbd0bd38-af17-446c-9295-05a5dd765a01", "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", "dfg.dtypes" ], "execution_count": 0, "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 object\n", "CIDADE SOLICITAÇÃO object\n", "ANO DECISÃO float64\n", "dtype: object" ] }, "metadata": { "tags": [] }, "execution_count": 52 } ] }, { "cell_type": "code", "metadata": { "id": "HZpW3qSGnAOO", "colab_type": "code", "outputId": "50e2f2cd-c5bf-447b-b948-81a7307bc8cc", "colab": { "base_uri": "https://localhost:8080/", "height": 867 } }, "source": [ "dfg['PAÍS DE ORIGEM'].value_counts()" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "ANGOLA 861\n", "LIBÉRIA 182\n", "ZAIRE 93\n", "CUBA 64\n", "IRAQUE 57\n", "IUGOSLÁVIA 37\n", "PERU 28\n", "SERRA LEOA 20\n", "IRÃ 17\n", "RUANDA 15\n", "ARGENTINA 13\n", "NIGÉRIA 12\n", "LÍBANO 11\n", "SOMÁLIA 10\n", "SUDÃO 8\n", "APÁTRIDA 7\n", "SÉRVIA 5\n", "GANA 5\n", "MACEDÔNIA 5\n", "ETIÓPIA 4\n", "EL SALVADOR 4\n", "ARGÉLIA 4\n", "EGITO 4\n", "CROÁCIA 4\n", "VIETNÃ 3\n", "ÁFRICA DO SUL 3\n", "SÍRIA 3\n", "LÍBIA 3\n", "ARMÊNIA 2\n", "MOÇAMBIQUE 2\n", "CAMARÕES 2\n", "GUIANA 2\n", "PALESTINA 2\n", "TANZANIA 2\n", "REPÚBLICA DOMINICANA 2\n", "MAURITÂNIA 2\n", "GUINÉ-BISSAU 2\n", "MALI 1\n", "SRI-LANKA 1\n", "\"PAÍS FORA DA TABELA\" 1\n", "BURUNDI 1\n", "BÓSNIA E HEZERGOVINA 1\n", "ROMÊNIA 1\n", "NICARÁGUA 1\n", "COLÔMBIA 1\n", "CHILE 1\n", "PAQUISTÃO 1\n", "BURKINA FASO 1\n", " 1\n", "Name: PAÍS DE ORIGEM, dtype: int64" ] }, "metadata": { "tags": [] }, "execution_count": 53 } ] }, { "cell_type": "code", "metadata": { "id": "VIs8lT-dnARw", "colab_type": "code", "outputId": "771687e3-2a02-441e-aea4-0c1866c620f3", "colab": { "base_uri": "https://localhost:8080/", "height": 51 } }, "source": [ "dfg['STATUS'].value_counts()" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "ELEGIBILIDADE / DEFERIMENTO 1503\n", "Name: STATUS, dtype: int64" ] }, "metadata": { "tags": [] }, "execution_count": 55 } ] } ] }