AulaAoVivo_semana2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyOFlRd5pb2/P+LKMLowg5Ks",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/camilacruz-cs/python-para-inovacao-civica/blob/main/AulaAoVivo_semana2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "MMfjmdxiAwBt"
      },
      "outputs": [],
      "source": [
        "import matplotlib as plt\n",
        "import pandas as pd\n",
        "import glob"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados_candidatura = glob.glob('/content/consulta_cand_2022_*.csv')"
      ],
      "metadata": {
        "id": "wGiUkft-A-lD"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(dados_candidatura)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DIAzpTLgBMWO",
        "outputId": "931626b0-784d-4443-f637-c37a9e7c0cf3"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['/content/consulta_cand_2022_PA.csv', '/content/consulta_cand_2022_AP.csv']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados_completo = []\n",
        "\n",
        "for dados_estados in dados_candidatura:\n",
        "  dados_candidatura = pd.read_csv(dados_estados, sep =';', encoding = 'latin_1')\n",
        "  dados_completo.append(dados_candidatura)"
      ],
      "metadata": {
        "id": "SRgWwam8BrBC"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "dados_completo"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "s7t2MMJ3CCWN",
        "outputId": "940054d3-dfd5-4979-c33a-0ec9dce288f3"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[      DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
              " 0     13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1     13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 2     13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 3     13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 4     13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " ...          ...        ...          ...              ...                ...   \n",
              " 1038  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1039  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1040  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1041  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1042  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " \n",
              "       NR_TURNO  CD_ELEICAO                      DS_ELEICAO  DT_ELEICAO  \\\n",
              " 0            1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1            1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 2            1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 3            1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 4            1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " ...        ...         ...                             ...         ...   \n",
              " 1038         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1039         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1040         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1041         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1042         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " \n",
              "      TP_ABRANGENCIA  ...          NR_PROCESSO CD_SITUACAO_CANDIDATO_PLEITO  \\\n",
              " 0          ESTADUAL  ...  6006408620226140000                            2   \n",
              " 1          ESTADUAL  ...  6011397020226140000                           -1   \n",
              " 2          ESTADUAL  ...  6012245620226140000                           -1   \n",
              " 3          ESTADUAL  ...  6006754620226140000                            2   \n",
              " 4          ESTADUAL  ...  6008876720226140000                            2   \n",
              " ...             ...  ...                  ...                          ...   \n",
              " 1038       ESTADUAL  ...  6002268820226140000                            2   \n",
              " 1039       ESTADUAL  ...  6005637720226140000                            4   \n",
              " 1040       ESTADUAL  ...  6004866820226140000                            2   \n",
              " 1041       ESTADUAL  ...  6004312020226140000                            2   \n",
              " 1042       ESTADUAL  ...  6009040620226140000                            2   \n",
              " \n",
              "      DS_SITUACAO_CANDIDATO_PLEITO  CD_SITUACAO_CANDIDATO_URNA  \\\n",
              " 0                        DEFERIDO                           2   \n",
              " 1                          #NULO#                          -1   \n",
              " 2                          #NULO#                          -1   \n",
              " 3                        DEFERIDO                           2   \n",
              " 4                        DEFERIDO                           2   \n",
              " ...                           ...                         ...   \n",
              " 1038                     DEFERIDO                           2   \n",
              " 1039       INDEFERIDO COM RECURSO                           4   \n",
              " 1040                     DEFERIDO                           2   \n",
              " 1041                     DEFERIDO                           2   \n",
              " 1042                     DEFERIDO                           2   \n",
              " \n",
              "      DS_SITUACAO_CANDIDATO_URNA  ST_CANDIDATO_INSERIDO_URNA  \\\n",
              " 0                      DEFERIDO                         SIM   \n",
              " 1                        #NULO#                         NÃO   \n",
              " 2                        #NULO#                         NÃO   \n",
              " 3                      DEFERIDO                         SIM   \n",
              " 4                      DEFERIDO                         SIM   \n",
              " ...                         ...                         ...   \n",
              " 1038                   DEFERIDO                         SIM   \n",
              " 1039     INDEFERIDO COM RECURSO                         SIM   \n",
              " 1040                   DEFERIDO                         SIM   \n",
              " 1041                   DEFERIDO                         SIM   \n",
              " 1042                   DEFERIDO                         SIM   \n",
              " \n",
              "       NM_TIPO_DESTINACAO_VOTOS CD_SITUACAO_CANDIDATO_TOT  \\\n",
              " 0                       Válido                         2   \n",
              " 1                       #NULO#                        -1   \n",
              " 2                       #NULO#                        -1   \n",
              " 3                       Válido                         2   \n",
              " 4                       Válido                         2   \n",
              " ...                        ...                       ...   \n",
              " 1038                    Válido                         2   \n",
              " 1039        Anulado sub judice                         4   \n",
              " 1040                    Válido                         2   \n",
              " 1041                    Válido                         2   \n",
              " 1042                    Válido                         2   \n",
              " \n",
              "      DS_SITUACAO_CANDIDATO_TOT ST_PREST_CONTAS  \n",
              " 0                     Deferido               S  \n",
              " 1                       #NULO#               N  \n",
              " 2                       #NULO#               N  \n",
              " 3                     Deferido               S  \n",
              " 4                     Deferido               S  \n",
              " ...                        ...             ...  \n",
              " 1038                  Deferido               S  \n",
              " 1039    Indeferido com recurso               N  \n",
              " 1040                  Deferido               S  \n",
              " 1041                  Deferido               S  \n",
              " 1042                  Deferido               S  \n",
              " \n",
              " [1043 rows x 71 columns],\n",
              "      DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
              " 0    25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 1    25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 2    25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 3    25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 4    25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " ..          ...        ...          ...              ...                ...   \n",
              " 552  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 553  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 554  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 555  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " 556  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              " \n",
              "      NR_TURNO  CD_ELEICAO                      DS_ELEICAO  DT_ELEICAO  \\\n",
              " 0           1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 1           1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 2           1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 3           1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 4           1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " ..        ...         ...                             ...         ...   \n",
              " 552         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 553         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 554         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 555         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " 556         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              " \n",
              "     TP_ABRANGENCIA  ... DS_SITUACAO_CANDIDATO_URNA ST_CANDIDATO_INSERIDO_URNA  \\\n",
              " 0         ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 1         ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 2         ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 3         ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 4         ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " ..             ...  ...                        ...                        ...   \n",
              " 552       ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 553       ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 554       ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 555       ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " 556       ESTADUAL  ...                   DEFERIDO                        SIM   \n",
              " \n",
              "     NM_TIPO_DESTINACAO_VOTOS  CD_SITUACAO_CANDIDATO_TOT  \\\n",
              " 0                     Válido                          2   \n",
              " 1                     Válido                          2   \n",
              " 2         Anulado sub judice                          2   \n",
              " 3                     Válido                          2   \n",
              " 4                     Válido                          2   \n",
              " ..                       ...                        ...   \n",
              " 552                   Válido                          2   \n",
              " 553                   Válido                          2   \n",
              " 554                   Válido                          2   \n",
              " 555                   Válido                          2   \n",
              " 556                   Válido                          2   \n",
              " \n",
              "     DS_SITUACAO_CANDIDATO_TOT  ST_PREST_CONTAS  ST_SUBSTITUIDO SQ_SUBSTITUIDO  \\\n",
              " 0                    Deferido                S               N             -1   \n",
              " 1                    Deferido                S               N             -1   \n",
              " 2                    Deferido                S               N             -1   \n",
              " 3                    Deferido                S               N             -1   \n",
              " 4                    Deferido                S               N             -1   \n",
              " ..                        ...              ...             ...            ...   \n",
              " 552                  Deferido                S               N             -1   \n",
              " 553                  Deferido                S               N             -1   \n",
              " 554                  Deferido                S               N             -1   \n",
              " 555                  Deferido                S               N             -1   \n",
              " 556                  Deferido                S               N             -1   \n",
              " \n",
              "     SQ_ORDEM_SUPLENCIA DT_ACEITE_CANDIDATURA  \n",
              " 0                   -1   07/08/2022 13:28:01  \n",
              " 1                   -1   06/08/2022 14:19:14  \n",
              " 2                   -1   15/08/2022 07:56:26  \n",
              " 3                    9   10/08/2022 12:45:49  \n",
              " 4                   -1   06/08/2022 14:01:04  \n",
              " ..                 ...                   ...  \n",
              " 552                 -1   07/08/2022 13:28:01  \n",
              " 553                  6   04/08/2022 08:13:16  \n",
              " 554                 -1   13/08/2022 08:52:28  \n",
              " 555                 -1   01/08/2022 09:46:52  \n",
              " 556                 11   12/08/2022 14:36:18  \n",
              " \n",
              " [557 rows x 75 columns]]"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(dados_completo[0].columns)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4WCEc0a-495N",
        "outputId": "1994ed48-b00f-4d64-9819-482c87e785c8"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Index(['DT_GERACAO', 'HH_GERACAO', 'ANO_ELEICAO', 'CD_TIPO_ELEICAO',\n",
            "       'NM_TIPO_ELEICAO', 'NR_TURNO', 'CD_ELEICAO', 'DS_ELEICAO', 'DT_ELEICAO',\n",
            "       'TP_ABRANGENCIA', 'SG_UF', 'SG_UE', 'NM_UE', 'CD_CARGO', 'DS_CARGO',\n",
            "       'SQ_CANDIDATO', 'NR_CANDIDATO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO',\n",
            "       'NM_SOCIAL_CANDIDATO', 'NR_CPF_CANDIDATO', 'NM_EMAIL',\n",
            "       'CD_SITUACAO_CANDIDATURA', 'DS_SITUACAO_CANDIDATURA',\n",
            "       'CD_DETALHE_SITUACAO_CAND', 'DS_DETALHE_SITUACAO_CAND', 'TP_AGREMIACAO',\n",
            "       'NR_PARTIDO', 'SG_PARTIDO', 'NM_PARTIDO', 'NR_FEDERACAO',\n",
            "       'NM_FEDERACAO', 'SG_FEDERACAO', 'DS_COMPOSICAO_FEDERACAO',\n",
            "       'SQ_COLIGACAO', 'NM_COLIGACAO', 'DS_COMPOSICAO_COLIGACAO',\n",
            "       'CD_NACIONALIDADE', 'DS_NACIONALIDADE', 'SG_UF_NASCIMENTO',\n",
            "       'CD_MUNICIPIO_NASCIMENTO', 'NM_MUNICIPIO_NASCIMENTO', 'DT_NASCIMENTO',\n",
            "       'NR_IDADE_DATA_POSSE', 'NR_TITULO_ELEITORAL_CANDIDATO', 'CD_GENERO',\n",
            "       'DS_GENERO', 'CD_GRAU_INSTRUCAO', 'DS_GRAU_INSTRUCAO',\n",
            "       'CD_ESTADO_CIVIL', 'DS_ESTADO_CIVIL', 'CD_COR_RACA', 'DS_COR_RACA',\n",
            "       'CD_OCUPACAO', 'DS_OCUPACAO', 'VR_DESPESA_MAX_CAMPANHA',\n",
            "       'CD_SIT_TOT_TURNO', 'DS_SIT_TOT_TURNO', 'ST_REELEICAO',\n",
            "       'ST_DECLARAR_BENS', 'NR_PROTOCOLO_CANDIDATURA', 'NR_PROCESSO',\n",
            "       'CD_SITUACAO_CANDIDATO_PLEITO', 'DS_SITUACAO_CANDIDATO_PLEITO',\n",
            "       'CD_SITUACAO_CANDIDATO_URNA', 'DS_SITUACAO_CANDIDATO_URNA',\n",
            "       'ST_CANDIDATO_INSERIDO_URNA', 'NM_TIPO_DESTINACAO_VOTOS',\n",
            "       'CD_SITUACAO_CANDIDATO_TOT', 'DS_SITUACAO_CANDIDATO_TOT',\n",
            "       'ST_PREST_CONTAS'],\n",
            "      dtype='object')\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(dados_completo[1].columns)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yG_GkUy64_5G",
        "outputId": "6eca0fa2-f30e-492f-e806-cfa7b97ab4b1"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Index(['DT_GERACAO', 'HH_GERACAO', 'ANO_ELEICAO', 'CD_TIPO_ELEICAO',\n",
            "       'NM_TIPO_ELEICAO', 'NR_TURNO', 'CD_ELEICAO', 'DS_ELEICAO', 'DT_ELEICAO',\n",
            "       'TP_ABRANGENCIA', 'SG_UF', 'SG_UE', 'NM_UE', 'CD_CARGO', 'DS_CARGO',\n",
            "       'SQ_CANDIDATO', 'NR_CANDIDATO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO',\n",
            "       'NM_SOCIAL_CANDIDATO', 'NR_CPF_CANDIDATO', 'NM_EMAIL',\n",
            "       'CD_SITUACAO_CANDIDATURA', 'DS_SITUACAO_CANDIDATURA',\n",
            "       'CD_DETALHE_SITUACAO_CAND', 'DS_DETALHE_SITUACAO_CAND', 'TP_AGREMIACAO',\n",
            "       'NR_PARTIDO', 'SG_PARTIDO', 'NM_PARTIDO', 'NR_FEDERACAO',\n",
            "       'NM_FEDERACAO', 'SG_FEDERACAO', 'DS_COMPOSICAO_FEDERACAO',\n",
            "       'SQ_COLIGACAO', 'NM_COLIGACAO', 'DS_COMPOSICAO_COLIGACAO',\n",
            "       'CD_NACIONALIDADE', 'DS_NACIONALIDADE', 'SG_UF_NASCIMENTO',\n",
            "       'CD_MUNICIPIO_NASCIMENTO', 'NM_MUNICIPIO_NASCIMENTO', 'DT_NASCIMENTO',\n",
            "       'NR_IDADE_DATA_POSSE', 'NR_TITULO_ELEITORAL_CANDIDATO', 'CD_GENERO',\n",
            "       'DS_GENERO', 'CD_GRAU_INSTRUCAO', 'DS_GRAU_INSTRUCAO',\n",
            "       'CD_ESTADO_CIVIL', 'DS_ESTADO_CIVIL', 'CD_COR_RACA', 'DS_COR_RACA',\n",
            "       'CD_OCUPACAO', 'DS_OCUPACAO', 'VR_DESPESA_MAX_CAMPANHA',\n",
            "       'CD_SIT_TOT_TURNO', 'DS_SIT_TOT_TURNO', 'ST_REELEICAO',\n",
            "       'ST_DECLARAR_BENS', 'NR_PROTOCOLO_CANDIDATURA', 'NR_PROCESSO',\n",
            "       'CD_SITUACAO_CANDIDATO_PLEITO', 'DS_SITUACAO_CANDIDATO_PLEITO',\n",
            "       'CD_SITUACAO_CANDIDATO_URNA', 'DS_SITUACAO_CANDIDATO_URNA',\n",
            "       'ST_CANDIDATO_INSERIDO_URNA', 'NM_TIPO_DESTINACAO_VOTOS',\n",
            "       'CD_SITUACAO_CANDIDATO_TOT', 'DS_SITUACAO_CANDIDATO_TOT',\n",
            "       'ST_PREST_CONTAS', 'ST_SUBSTITUIDO', 'SQ_SUBSTITUIDO',\n",
            "       'SQ_ORDEM_SUPLENCIA', 'DT_ACEITE_CANDIDATURA'],\n",
            "      dtype='object')\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Importante, a fórmula deu errado pois os 2 DF são diferentes.\n",
        "dados_completo[0].columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tu5UYRcbF_P1",
        "outputId": "e22b63b0-9f0c-4ad2-c650-01f8ef4a317d"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['DT_GERACAO', 'HH_GERACAO', 'ANO_ELEICAO', 'CD_TIPO_ELEICAO',\n",
              "       'NM_TIPO_ELEICAO', 'NR_TURNO', 'CD_ELEICAO', 'DS_ELEICAO', 'DT_ELEICAO',\n",
              "       'TP_ABRANGENCIA', 'SG_UF', 'SG_UE', 'NM_UE', 'CD_CARGO', 'DS_CARGO',\n",
              "       'SQ_CANDIDATO', 'NR_CANDIDATO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO',\n",
              "       'NM_SOCIAL_CANDIDATO', 'NR_CPF_CANDIDATO', 'NM_EMAIL',\n",
              "       'CD_SITUACAO_CANDIDATURA', 'DS_SITUACAO_CANDIDATURA',\n",
              "       'CD_DETALHE_SITUACAO_CAND', 'DS_DETALHE_SITUACAO_CAND', 'TP_AGREMIACAO',\n",
              "       'NR_PARTIDO', 'SG_PARTIDO', 'NM_PARTIDO', 'NR_FEDERACAO',\n",
              "       'NM_FEDERACAO', 'SG_FEDERACAO', 'DS_COMPOSICAO_FEDERACAO',\n",
              "       'SQ_COLIGACAO', 'NM_COLIGACAO', 'DS_COMPOSICAO_COLIGACAO',\n",
              "       'CD_NACIONALIDADE', 'DS_NACIONALIDADE', 'SG_UF_NASCIMENTO',\n",
              "       'CD_MUNICIPIO_NASCIMENTO', 'NM_MUNICIPIO_NASCIMENTO', 'DT_NASCIMENTO',\n",
              "       'NR_IDADE_DATA_POSSE', 'NR_TITULO_ELEITORAL_CANDIDATO', 'CD_GENERO',\n",
              "       'DS_GENERO', 'CD_GRAU_INSTRUCAO', 'DS_GRAU_INSTRUCAO',\n",
              "       'CD_ESTADO_CIVIL', 'DS_ESTADO_CIVIL', 'CD_COR_RACA', 'DS_COR_RACA',\n",
              "       'CD_OCUPACAO', 'DS_OCUPACAO', 'VR_DESPESA_MAX_CAMPANHA',\n",
              "       'CD_SIT_TOT_TURNO', 'DS_SIT_TOT_TURNO', 'ST_REELEICAO',\n",
              "       'ST_DECLARAR_BENS', 'NR_PROTOCOLO_CANDIDATURA', 'NR_PROCESSO',\n",
              "       'CD_SITUACAO_CANDIDATO_PLEITO', 'DS_SITUACAO_CANDIDATO_PLEITO',\n",
              "       'CD_SITUACAO_CANDIDATO_URNA', 'DS_SITUACAO_CANDIDATO_URNA',\n",
              "       'ST_CANDIDATO_INSERIDO_URNA', 'NM_TIPO_DESTINACAO_VOTOS',\n",
              "       'CD_SITUACAO_CANDIDATO_TOT', 'DS_SITUACAO_CANDIDATO_TOT',\n",
              "       'ST_PREST_CONTAS'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Juntando todos os DF\n",
        "#linha (axis=0) ou coluna (axis=1)\n",
        "data_completo = pd.concat(dados_completo, axis = 0, ignore_index= True)"
      ],
      "metadata": {
        "id": "P1TH3fmjySXh"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Gera linhas aleatórias do DF\n",
        "data_completo.sample(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 560
        },
        "id": "YWyyhU_yylx3",
        "outputId": "9938c89d-ae42-494c-eaac-dbcd0fd39202"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
              "917   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1471  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1330  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "266   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1499  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "\n",
              "      NR_TURNO  CD_ELEICAO                      DS_ELEICAO  DT_ELEICAO  \\\n",
              "917          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1471         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1330         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "266          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1499         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "\n",
              "     TP_ABRANGENCIA  ... DS_SITUACAO_CANDIDATO_URNA  \\\n",
              "917        ESTADUAL  ...                   DEFERIDO   \n",
              "1471       ESTADUAL  ...                   DEFERIDO   \n",
              "1330       ESTADUAL  ...                   DEFERIDO   \n",
              "266        ESTADUAL  ...                   DEFERIDO   \n",
              "1499       ESTADUAL  ...                   DEFERIDO   \n",
              "\n",
              "     ST_CANDIDATO_INSERIDO_URNA NM_TIPO_DESTINACAO_VOTOS  \\\n",
              "917                         SIM                   #NULO#   \n",
              "1471                        SIM                   Válido   \n",
              "1330                        SIM                   Válido   \n",
              "266                         SIM                   Válido   \n",
              "1499                        SIM                   Válido   \n",
              "\n",
              "      CD_SITUACAO_CANDIDATO_TOT DS_SITUACAO_CANDIDATO_TOT  ST_PREST_CONTAS  \\\n",
              "917                           2                  Deferido                N   \n",
              "1471                          2                  Deferido                S   \n",
              "1330                          2                  Deferido                S   \n",
              "266                           2                  Deferido                S   \n",
              "1499                          2                  Deferido                S   \n",
              "\n",
              "      ST_SUBSTITUIDO SQ_SUBSTITUIDO SQ_ORDEM_SUPLENCIA DT_ACEITE_CANDIDATURA  \n",
              "917              NaN            NaN                NaN                   NaN  \n",
              "1471               N           -1.0               -1.0   01/08/2022 09:46:52  \n",
              "1330               N           -1.0               15.0   06/08/2022 15:03:48  \n",
              "266              NaN            NaN                NaN                   NaN  \n",
              "1499               N           -1.0               -1.0   07/08/2022 13:28:01  \n",
              "\n",
              "[5 rows x 75 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-81f6d6e2-df48-4d30-b351-70602dad8c14\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DT_GERACAO</th>\n",
              "      <th>HH_GERACAO</th>\n",
              "      <th>ANO_ELEICAO</th>\n",
              "      <th>CD_TIPO_ELEICAO</th>\n",
              "      <th>NM_TIPO_ELEICAO</th>\n",
              "      <th>NR_TURNO</th>\n",
              "      <th>CD_ELEICAO</th>\n",
              "      <th>DS_ELEICAO</th>\n",
              "      <th>DT_ELEICAO</th>\n",
              "      <th>TP_ABRANGENCIA</th>\n",
              "      <th>...</th>\n",
              "      <th>DS_SITUACAO_CANDIDATO_URNA</th>\n",
              "      <th>ST_CANDIDATO_INSERIDO_URNA</th>\n",
              "      <th>NM_TIPO_DESTINACAO_VOTOS</th>\n",
              "      <th>CD_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>DS_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>ST_PREST_CONTAS</th>\n",
              "      <th>ST_SUBSTITUIDO</th>\n",
              "      <th>SQ_SUBSTITUIDO</th>\n",
              "      <th>SQ_ORDEM_SUPLENCIA</th>\n",
              "      <th>DT_ACEITE_CANDIDATURA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>917</th>\n",
              "      <td>13/05/2023</td>\n",
              "      <td>19:32:48</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>DEFERIDO</td>\n",
              "      <td>SIM</td>\n",
              "      <td>#NULO#</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>N</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1471</th>\n",
              "      <td>25/06/2023</td>\n",
              "      <td>19:31:27</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>DEFERIDO</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>N</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>01/08/2022 09:46:52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1330</th>\n",
              "      <td>25/06/2023</td>\n",
              "      <td>19:31:27</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>DEFERIDO</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>N</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>06/08/2022 15:03:48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>266</th>\n",
              "      <td>13/05/2023</td>\n",
              "      <td>19:32:48</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>DEFERIDO</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1499</th>\n",
              "      <td>25/06/2023</td>\n",
              "      <td>19:31:27</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>DEFERIDO</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>N</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>07/08/2022 13:28:01</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 75 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-81f6d6e2-df48-4d30-b351-70602dad8c14')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-45256993-c953-405a-b284-ce00b357d0d3\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-45256993-c953-405a-b284-ce00b357d0d3')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-45256993-c953-405a-b284-ce00b357d0d3 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-81f6d6e2-df48-4d30-b351-70602dad8c14 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-81f6d6e2-df48-4d30-b351-70602dad8c14');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Tamanho total do DF\n",
        "data_completo.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1147W7gIzM2k",
        "outputId": "a70d1554-5071-4c36-a0ba-4b03d75ad426"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(1600, 75)"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ZKnpnrS5375m",
        "outputId": "9403ad5f-b1f4-4500-ee90-6af472d5b66c"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 1600 entries, 0 to 1599\n",
            "Data columns (total 75 columns):\n",
            " #   Column                         Non-Null Count  Dtype  \n",
            "---  ------                         --------------  -----  \n",
            " 0   DT_GERACAO                     1600 non-null   object \n",
            " 1   HH_GERACAO                     1600 non-null   object \n",
            " 2   ANO_ELEICAO                    1600 non-null   int64  \n",
            " 3   CD_TIPO_ELEICAO                1600 non-null   int64  \n",
            " 4   NM_TIPO_ELEICAO                1600 non-null   object \n",
            " 5   NR_TURNO                       1600 non-null   int64  \n",
            " 6   CD_ELEICAO                     1600 non-null   int64  \n",
            " 7   DS_ELEICAO                     1600 non-null   object \n",
            " 8   DT_ELEICAO                     1600 non-null   object \n",
            " 9   TP_ABRANGENCIA                 1600 non-null   object \n",
            " 10  SG_UF                          1600 non-null   object \n",
            " 11  SG_UE                          1600 non-null   object \n",
            " 12  NM_UE                          1600 non-null   object \n",
            " 13  CD_CARGO                       1600 non-null   int64  \n",
            " 14  DS_CARGO                       1600 non-null   object \n",
            " 15  SQ_CANDIDATO                   1600 non-null   int64  \n",
            " 16  NR_CANDIDATO                   1600 non-null   int64  \n",
            " 17  NM_CANDIDATO                   1600 non-null   object \n",
            " 18  NM_URNA_CANDIDATO              1600 non-null   object \n",
            " 19  NM_SOCIAL_CANDIDATO            1600 non-null   object \n",
            " 20  NR_CPF_CANDIDATO               1600 non-null   int64  \n",
            " 21  NM_EMAIL                       1600 non-null   object \n",
            " 22  CD_SITUACAO_CANDIDATURA        1600 non-null   int64  \n",
            " 23  DS_SITUACAO_CANDIDATURA        1600 non-null   object \n",
            " 24  CD_DETALHE_SITUACAO_CAND       1600 non-null   int64  \n",
            " 25  DS_DETALHE_SITUACAO_CAND       1600 non-null   object \n",
            " 26  TP_AGREMIACAO                  1600 non-null   object \n",
            " 27  NR_PARTIDO                     1600 non-null   int64  \n",
            " 28  SG_PARTIDO                     1600 non-null   object \n",
            " 29  NM_PARTIDO                     1600 non-null   object \n",
            " 30  NR_FEDERACAO                   1600 non-null   int64  \n",
            " 31  NM_FEDERACAO                   1600 non-null   object \n",
            " 32  SG_FEDERACAO                   1600 non-null   object \n",
            " 33  DS_COMPOSICAO_FEDERACAO        1600 non-null   object \n",
            " 34  SQ_COLIGACAO                   1600 non-null   int64  \n",
            " 35  NM_COLIGACAO                   1600 non-null   object \n",
            " 36  DS_COMPOSICAO_COLIGACAO        1600 non-null   object \n",
            " 37  CD_NACIONALIDADE               1600 non-null   int64  \n",
            " 38  DS_NACIONALIDADE               1600 non-null   object \n",
            " 39  SG_UF_NASCIMENTO               1600 non-null   object \n",
            " 40  CD_MUNICIPIO_NASCIMENTO        1600 non-null   int64  \n",
            " 41  NM_MUNICIPIO_NASCIMENTO        1600 non-null   object \n",
            " 42  DT_NASCIMENTO                  1599 non-null   object \n",
            " 43  NR_IDADE_DATA_POSSE            1599 non-null   float64\n",
            " 44  NR_TITULO_ELEITORAL_CANDIDATO  1600 non-null   int64  \n",
            " 45  CD_GENERO                      1600 non-null   int64  \n",
            " 46  DS_GENERO                      1600 non-null   object \n",
            " 47  CD_GRAU_INSTRUCAO              1600 non-null   int64  \n",
            " 48  DS_GRAU_INSTRUCAO              1600 non-null   object \n",
            " 49  CD_ESTADO_CIVIL                1600 non-null   int64  \n",
            " 50  DS_ESTADO_CIVIL                1600 non-null   object \n",
            " 51  CD_COR_RACA                    1600 non-null   int64  \n",
            " 52  DS_COR_RACA                    1600 non-null   object \n",
            " 53  CD_OCUPACAO                    1600 non-null   int64  \n",
            " 54  DS_OCUPACAO                    1600 non-null   object \n",
            " 55  VR_DESPESA_MAX_CAMPANHA        1600 non-null   float64\n",
            " 56  CD_SIT_TOT_TURNO               1600 non-null   int64  \n",
            " 57  DS_SIT_TOT_TURNO               1600 non-null   object \n",
            " 58  ST_REELEICAO                   1600 non-null   object \n",
            " 59  ST_DECLARAR_BENS               1600 non-null   object \n",
            " 60  NR_PROTOCOLO_CANDIDATURA       1600 non-null   int64  \n",
            " 61  NR_PROCESSO                    1600 non-null   int64  \n",
            " 62  CD_SITUACAO_CANDIDATO_PLEITO   1600 non-null   int64  \n",
            " 63  DS_SITUACAO_CANDIDATO_PLEITO   1600 non-null   object \n",
            " 64  CD_SITUACAO_CANDIDATO_URNA     1600 non-null   int64  \n",
            " 65  DS_SITUACAO_CANDIDATO_URNA     1600 non-null   object \n",
            " 66  ST_CANDIDATO_INSERIDO_URNA     1600 non-null   object \n",
            " 67  NM_TIPO_DESTINACAO_VOTOS       1600 non-null   object \n",
            " 68  CD_SITUACAO_CANDIDATO_TOT      1600 non-null   int64  \n",
            " 69  DS_SITUACAO_CANDIDATO_TOT      1600 non-null   object \n",
            " 70  ST_PREST_CONTAS                1600 non-null   object \n",
            " 71  ST_SUBSTITUIDO                 557 non-null    object \n",
            " 72  SQ_SUBSTITUIDO                 557 non-null    float64\n",
            " 73  SQ_ORDEM_SUPLENCIA             557 non-null    float64\n",
            " 74  DT_ACEITE_CANDIDATURA          557 non-null    object \n",
            "dtypes: float64(4), int64(27), object(44)\n",
            "memory usage: 937.6+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo['ST_SUBSTITUIDO'].unique"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "j2fECMQc7JRd",
        "outputId": "4623c711-59f8-4bfe-8ead-2d35ee6a26d2"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method Series.unique of 0       NaN\n",
              "1       NaN\n",
              "2       NaN\n",
              "3       NaN\n",
              "4       NaN\n",
              "       ... \n",
              "1595      N\n",
              "1596      N\n",
              "1597      N\n",
              "1598      N\n",
              "1599      N\n",
              "Name: ST_SUBSTITUIDO, Length: 1600, dtype: object>"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo['DS_CARGO'].unique()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QxTkqraD5Ap5",
        "outputId": "06a82f4f-605a-4fd4-ef14-300a857e3039"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['DEPUTADO ESTADUAL', 'VICE-GOVERNADOR', 'DEPUTADO FEDERAL',\n",
              "       '2º SUPLENTE', '1º SUPLENTE', 'GOVERNADOR', 'SENADOR'],\n",
              "      dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo['DS_GENERO'].unique()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QKveIA6-5gv4",
        "outputId": "0a17bd66-4cba-4fca-bb22-e0d44a5ff842"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['FEMININO', 'MASCULINO', 'NÃO DIVULGÁVEL'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo['DS_DETALHE_SITUACAO_CAND'].unique()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sPqK936x5nCz",
        "outputId": "8a83b2fc-2f63-4c20-fd53-991780ec03e9"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['DEFERIDO', 'RENÚNCIA', 'INDEFERIDO', 'CANCELADO'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_completo['DS_SITUACAO_CANDIDATURA'].unique()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "YECIHZZX5tby",
        "outputId": "11ed5b2d-b526-41c4-8d35-0042e05b2469"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['APTO', 'INAPTO'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Habilitando filtros que serão usados na análise de dados."
      ],
      "metadata": {
        "id": "K-acHvit6Urf"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Armazenando o primeiro filtro que será usado\n",
        "filtro_cargo = data_completo['DS_CARGO'] == 'GOVERNADOR'"
      ],
      "metadata": {
        "id": "zdRsECJo6Iw9"
      },
      "execution_count": 18,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Segundo filtro que será usado\n",
        "filtro_deferimento = data_completo['DS_DETALHE_SITUACAO_CAND'] == 'DEFERIDO'"
      ],
      "metadata": {
        "id": "PPi3QjAY6ZuB"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Aqui estou fazendo uma cópia do meu DF original com apenas as colunas que eu vou precisar nessa análise\n",
        "df_governadores = data_completo[filtro_cargo & filtro_deferimento].copy"
      ],
      "metadata": {
        "id": "zmhuR0yJ-GUi"
      },
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_governadores"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "J3HCcMfh_nWW",
        "outputId": "efa1f286-61f2-4a95-ba80-dfb0d67536fe"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method NDFrame.copy of       DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
              "101   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "173   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "200   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "468   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "529   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "573   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "710   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "907   13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1054  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1065  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1280  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1514  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "1574  25/06/2023   19:31:27         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "\n",
              "      NR_TURNO  CD_ELEICAO                      DS_ELEICAO  DT_ELEICAO  \\\n",
              "101          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "173          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "200          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "468          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "529          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "573          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "710          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "907          1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1054         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1065         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1280         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1514         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "1574         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "\n",
              "     TP_ABRANGENCIA  ... DS_SITUACAO_CANDIDATO_URNA  \\\n",
              "101        ESTADUAL  ...                   DEFERIDO   \n",
              "173        ESTADUAL  ...                   DEFERIDO   \n",
              "200        ESTADUAL  ...                   DEFERIDO   \n",
              "468        ESTADUAL  ...                   DEFERIDO   \n",
              "529        ESTADUAL  ...       DEFERIDO COM RECURSO   \n",
              "573        ESTADUAL  ...                   DEFERIDO   \n",
              "710        ESTADUAL  ...                   DEFERIDO   \n",
              "907        ESTADUAL  ...                   DEFERIDO   \n",
              "1054       ESTADUAL  ...                   DEFERIDO   \n",
              "1065       ESTADUAL  ...                   DEFERIDO   \n",
              "1280       ESTADUAL  ...                   DEFERIDO   \n",
              "1514       ESTADUAL  ...                   DEFERIDO   \n",
              "1574       ESTADUAL  ...                   DEFERIDO   \n",
              "\n",
              "     ST_CANDIDATO_INSERIDO_URNA NM_TIPO_DESTINACAO_VOTOS  \\\n",
              "101                         SIM                   Válido   \n",
              "173                         SIM                   Válido   \n",
              "200                         SIM                   Válido   \n",
              "468                         SIM                   Válido   \n",
              "529                         SIM                   Válido   \n",
              "573                         SIM                   Válido   \n",
              "710                         SIM                   Válido   \n",
              "907                         SIM                   Válido   \n",
              "1054                        SIM                   Válido   \n",
              "1065                        SIM                   Válido   \n",
              "1280                        SIM                   Válido   \n",
              "1514                        SIM                   Válido   \n",
              "1574                        SIM                   Válido   \n",
              "\n",
              "      CD_SITUACAO_CANDIDATO_TOT DS_SITUACAO_CANDIDATO_TOT  ST_PREST_CONTAS  \\\n",
              "101                           2                  Deferido                S   \n",
              "173                           2                  Deferido                S   \n",
              "200                           2                  Deferido                S   \n",
              "468                           2                  Deferido                S   \n",
              "529                          16      Deferido com recurso                S   \n",
              "573                           2                  Deferido                S   \n",
              "710                           2                  Deferido                S   \n",
              "907                           2                  Deferido                S   \n",
              "1054                          2                  Deferido                S   \n",
              "1065                          2                  Deferido                S   \n",
              "1280                          2                  Deferido                S   \n",
              "1514                          2                  Deferido                S   \n",
              "1574                          2                  Deferido                S   \n",
              "\n",
              "      ST_SUBSTITUIDO SQ_SUBSTITUIDO SQ_ORDEM_SUPLENCIA DT_ACEITE_CANDIDATURA  \n",
              "101              NaN            NaN                NaN                   NaN  \n",
              "173              NaN            NaN                NaN                   NaN  \n",
              "200              NaN            NaN                NaN                   NaN  \n",
              "468              NaN            NaN                NaN                   NaN  \n",
              "529              NaN            NaN                NaN                   NaN  \n",
              "573              NaN            NaN                NaN                   NaN  \n",
              "710              NaN            NaN                NaN                   NaN  \n",
              "907              NaN            NaN                NaN                   NaN  \n",
              "1054               N           -1.0               -1.0   11/08/2022 15:11:50  \n",
              "1065               N           -1.0               -1.0   08/08/2022 14:18:40  \n",
              "1280               N           -1.0               -1.0   10/08/2022 12:48:48  \n",
              "1514               N           -1.0               -1.0   10/08/2022 15:12:37  \n",
              "1574               N           -1.0               -1.0   12/08/2022 08:50:40  \n",
              "\n",
              "[13 rows x 75 columns]>"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca_genero = df_governadores(['ANO_ELEICAO' 'CD_CARGO', 'SG_UF', 'NR_PARTIDO', 'SG_PARTIDO','CD_GENERO', 'DS_GENERO', 'CD_COR_RACA', 'DS_COR_RACA', 'NR_IDADE_DATA_POSSE',' VR_DESPESA_MAX_CAMPANHA']).copy()"
      ],
      "metadata": {
        "id": "Rq1etJgJAd1J"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Quantas candidaturas houveram em cada ano agrupado por gênero?"
      ],
      "metadata": {
        "id": "jhizsBeh4SW2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca_genero[['ANO_ELEICAO', 'DS_GENERO', 'CD_CARGO']].groupby(by=['ANO_ELEICAO', 'DS_GENERO']).count()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "id": "gyoXW9njL45Q",
        "outputId": "5b8b3b26-ae33-49f8-c768-839382fca9c8"
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       CD_CARGO\n",
              "ANO_ELEICAO DS_GENERO          \n",
              "2022        FEMININO          1\n",
              "            MASCULINO        12"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-32a7ab9f-47c0-4fb0-a222-3ca33056a1f8\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>CD_CARGO</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ANO_ELEICAO</th>\n",
              "      <th>DS_GENERO</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">2022</th>\n",
              "      <th>FEMININO</th>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MASCULINO</th>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-32a7ab9f-47c0-4fb0-a222-3ca33056a1f8')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-e4f75d08-4629-476e-af74-bcf65e6913a6\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e4f75d08-4629-476e-af74-bcf65e6913a6')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-e4f75d08-4629-476e-af74-bcf65e6913a6 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-32a7ab9f-47c0-4fb0-a222-3ca33056a1f8 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-32a7ab9f-47c0-4fb0-a222-3ca33056a1f8');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_grafico = df_raca_genero[['ANO_ELEICAO', 'DS_GENERO', 'CD_CARGO']].groupby(by=['ANO_ELEICAO', 'DS_GENERO'], as_index=False).count()"
      ],
      "metadata": {
        "id": "bciFMXSkOLyk"
      },
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_grafico.groupby(['ANO_ELEICAO','DS_GENERO']).sum().unstack(0).plot(kind='bar')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 536
        },
        "id": "-D3nisaRNtmx",
        "outputId": "b6c1d1bb-c792-4b45-9cb5-30c17b834242"
      },
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<Axes: xlabel='DS_GENERO'>"
            ]
          },
          "metadata": {},
          "execution_count": 25
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 640x480 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAh8AAAH2CAYAAADQ/u4GAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA7d0lEQVR4nO3dd3gU1f7H8c8mJCGQQg0QCQSEUEJVELxYaCEiIthIEDSCigKCGJBioSm9ilTvDQQEAihFUEER4YJKUQJIkyIlXCCgAgk1hDC/P3zYn2sKATdnE/J+Pc88j3vm7Mx31iT74cyZGZtlWZYAAAAMcXN1AQAAIH8hfAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwqoCrC/i769ev68SJE/L19ZXNZnN1OQAAIBssy9L58+cVGBgoN7esxzZyXfg4ceKEgoKCXF0GAAC4DceOHVPZsmWz7JPrwoevr6+kP4v38/NzcTUAACA7kpOTFRQUZP8ez0quCx83TrX4+fkRPgAAyGOyM2WCCacAAMAowgcAADCK8AEAAIzKdXM+sistLU2pqamuLgP4xzw8POTu7u7qMgDAmDwXPizLUmJios6dO+fqUgCnKVKkiEqXLs29bQDkC3kufNwIHgEBASpUqBB/rJGnWZalS5cu6fTp05KkMmXKuLgiAMh5eSp8pKWl2YNH8eLFXV0O4BTe3t6SpNOnTysgIIBTMADueHlqwumNOR6FChVycSWAc934mWYeE4D8IE+Fjxs41YI7DT/TAPKTPBk+AABA3nXL4WP9+vVq3bq1AgMDZbPZtGzZMvu61NRU9evXTzVr1lThwoUVGBio559/XidOnHBmzQAAIA+75fBx8eJF1a5dW1OmTEm37tKlS4qPj9e7776r+Ph4LVmyRPv27dPjjz/ulGJNeOGFF2Sz2TRy5EiH9mXLluWqofHw8HC5u7vrxx9/TLfuVo4hLS1NEyZMUM2aNVWwYEEVLVpULVu21Pfff5/tWmJjY2Wz2dItBQsWdKipbdu2mW4jODg4w23cOIYjR47IZrNp+/btDu9bvHixGjduLH9/f/n4+KhWrVoaOnSozpw549Dv8uXLKlasmEqUKKGUlJQMa5g9e7bq16+vQoUKydfXVw8//LA+//zzbH8OAIDsueXw0bJlS73//vt64okn0q3z9/fX6tWr1a5dO1WpUkUNGzbU5MmTtXXrViUkJDilYBMKFiyoUaNG6ezZs64uJUMJCQn64Ycf9Nprr2nmzJkZ9snOMViWpcjISA0dOlSvv/669u7dq3Xr1ikoKEiNGzd2GNW6GT8/P508edJhOXr06C0d19ChQ9Nto0ePHpn2f/vttxUREaH69etr5cqV2rVrl8aNG6cdO3bo448/dui7ePFihYaGqmrVqhkeV58+ffTKK68oIiJCP//8s7Zs2aIHHnhAbdq00eTJk2/pOAAAN2H9A5KspUuXZtln9erVls1ms5KSkrK1zaSkJEtShv0vX75s7dmzx7p8+fLtlJstUVFR1mOPPWZVrVrVevPNN+3tS5cutf76cX366adW9erVLU9PT6t8+fLW2LFjHbZTvnx5a9iwYVanTp0sHx8fKygoyJoxY4ZDn4SEBOuZZ56x/P39raJFi1qPP/64dfjw4ZvWOHjwYCsyMtLau3ev5e/vb126dOm2jmHBggWWJGv58uXp9vHkk09axYsXty5cuHDTembNmmX5+/tn2ScqKspq06ZNpuvLly9vTZgwIdP1hw8ftiRZ27ZtsyzLsjZv3mxJsiZOnJhh/7Nnzzq8bty4sTV9+nRr2rRpVlhYmMO6jRs3WpKsSZMmpdtOdHS05eHhYSUkJGRamzOY+NkGgJyU1ff33+XohNMrV66oX79+at++vfz8/DLsk5KSouTkZIfF1dzd3TV8+HB9+OGH+t///pdu/datW9WuXTtFRkZq586dGjx4sN59913FxsY69Bs3bpzq1aunbdu2qVu3buratav27dsn6c/5MeHh4fL19dWGDRv0/fffy8fHR4888oiuXr2aaW2WZWnWrFnq2LGjqlatqkqVKunTTz+95WOQpPnz5yskJEStW7dOt6537976448/tHr16qw+KpeZN2+efHx81K1btwzXFylSxP7fv/76qzZu3Kh27dqpXbt22rBhg8OoTFxcnHx8fPTKK6+k207v3r2VmpqqxYsXO/0YACC/yrGbjKWmpqpdu3ayLEvTpk3LtN+IESM0ZMiQnCrjtj3xxBOqU6eOBg0apJiYGId148ePV7NmzfTuu+9KkkJCQrRnzx6NGTNGL7zwgr3fo48+av9y7NevnyZMmKC1a9eqSpUqWrhwoa5fv67//Oc/9nkYs2bNUpEiRbRu3Tq1aNEiw7q++eYbXbp0SeHh4ZKkjh07KiYmRs8999wtHYMk7d+/X9WqVctwPzfa9+/fn9XHZJeUlCQfHx+HtgcffFArV67M1vulPz+jd955x6Ft5cqVevDBB9P1PXDggCpWrCgPD4+bbnfmzJlq2bKlihYtKunP+TKzZs3S4MGDJf15jHfffbc8PT3TvTcwMFB+fn7Z/hyAzAT3/8LVJcCgIyNbubqEXC1HRj5uBI+jR49q9erVmY56SNKAAQOUlJRkX44dO5YTJd2WUaNGafbs2dq7d69D+969e9WoUSOHtkaNGunAgQNKS0uzt9WqVcv+3zabTaVLl7bfRnvHjh06ePCgfH195ePjIx8fHxUrVkxXrlzRr7/+mmlNM2fOVEREhAoU+DM3tm/fXt9//32m78nsGG6wLCuLTyD7fH19tX37doflP//5zy1t480330y3jXr16mXYN7t1p6Wlafbs2erYsaO9rWPHjoqNjdX169dveXsAgH/O6SMfN4LHgQMHtHbt2pveBt3Ly0teXl7OLsMpHnroIYWHh2vAgAEOIxrZ9fd/ldtsNvsX3oULF3Tvvfdq3rx56d5XsmTJDLd35swZLV26VKmpqQ6jSWlpaZo5c6aGDRt2S8cQEhKSaSi50R4SEpL5Af6Fm5ubKlWqlK2+mSlRokS2txESEqLvvvtOqampWY5+fPXVVzp+/LgiIiIc2tPS0rRmzRqFhYXZt3X16tV0ox8nTpxQcnJytj8HAMDN3fLIx4ULF+z/KpWkw4cPa/v27UpISFBqaqqefvpp/fTTT5o3b57S0tKUmJioxMTELOcx5GYjR47UihUrtHHjRntbtWrV0l2K+v333yskJCTbz+W45557dODAAQUEBKhSpUoOi7+/f4bvmTdvnsqWLasdO3Y4jA6MGzdOsbGxDqMuNzsGSYqMjNSBAwe0YsWKdO8ZN26cihcvrrCwsGwdj2nPPvusLly4oKlTp2a4/sZTj2NiYhQZGZluRCUyMtJ+KioyMlIXLlzQjBkz0m1n7Nix8vDw0FNPPZVjxwIA+c0tj3z89NNPatKkif11dHS0JCkqKkqDBw/W8uXLJUl16tRxeN/atWvVuHHj26/URWrWrKkOHTpo0qRJ9rbevXurfv36eu+99xQREaGNGzdq8uTJmX4RZqRDhw4aM2aM2rRpo6FDh6ps2bI6evSolixZor59+6ps2bLp3hMTE6Onn35aNWrUcGgPCgrSgAEDtGrVKrVqlf48Y0bHIP35pfvJJ58oKipKY8aMUbNmzZScnKwpU6Zo+fLl+uSTT1S4cOFsHY9lWUpMTEzXHhAQIDe3PzNuUlJSuvt0FC9eXEFBQZKk8+fPp9tGoUKFMjxt16BBA/Xt21e9e/fW8ePH9cQTTygwMFAHDx7U9OnT9cADD+jZZ5/VihUrtHz58nSf2fPPP68nnnhCZ86c0f3336/XX39db775pq5evaq2bdsqNTVVc+fO1QcffKCJEyfaawQA/HO3PPLRuHFjWZaVbomNjVVwcHCG6yzLypPB44ahQ4c6zA+45557tGjRIi1YsEA1atTQwIEDNXTo0Fs6NVOoUCGtX79e5cqV05NPPqlq1arpxRdf1JUrV+xftuvWrZPNZtORI0e0detW7dixI8N/gfv7+6tZs2YZTirN7BikP08DLVq0SG+99ZYmTJigKlWq6MEHH9TRo0e1bt26LG8K9nfJyckqU6ZMuuXGHJcbx1O3bl2H5a+TjQcOHJju/X379s10n6NGjdL8+fO1efNmhYeHKzQ0VNHR0apVq5aioqI0Z84cFS5cWM2aNUv33mbNmsnb21tz586VJE2cOFFTp05VXFycatSooXr16mn9+vVatmxZlvcaAQDcOpuVy2baJScny9/fX0lJSen+xXvlyhUdPnxYFSpUcLh75p1q1qxZGj58uPbs2ZOtqzqQd+W3n+38iKtd8pf8eLVLVt/ff8eD5XKxL7/8UsOHDyd4AADuKDl2nw/8c5988omrS5AkhYaGZnqr9BkzZqhDhw6GKwIA5GWED9zUl19+qdTU1AzXlSpVynA1AIC8jvCBmypfvryrSwAA3EGY8wEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8GPTHH38oICBAR44ccXUpMGj69Olq3bq1q8sAgFzjjgkfwf2/MLrcjmHDhqlNmzYKDg52aF+8eLEaN24sf39/+fj4qFatWho6dKjOnDkjSYqNjZXNZpPNZpO7u7uKFi2qBg0aaOjQoUpKSrqlGhITE9WjRw9VrFhRXl5eCgoKUuvWrbVmzZp0fUeMGCF3d3eNGTMm3bq/1uTm5qYyZcooIiJCCQkJ6foePHhQnTt3Vrly5eTl5aW77rpLzZo107x583Tt2jWHvp9//rkefvhh+fr6qlChQqpfv75iY2Nv6RglacmSJQoLC1PJkiXl5+en+++/X1999VW6flOmTFFwcLAKFiyoBg0aaMuWLfZ1Z86cUY8ePVSlShV5e3urXLly6tmzp8NnvmPHDrVv315BQUHy9vZWtWrV9MEHHzjso3PnzoqPj9eGDRtu+TgA4E50x4SP3O7SpUuKiYnRiy++6ND+9ttvKyIiQvXr19fKlSu1a9cujRs3Tjt27NDHH39s7+fn56eTJ0/qf//7n3744Qd16dJFc+bMUZ06dXTixIls1XDkyBHde++9+vbbbzVmzBjt3LlTq1atUpMmTdS9e/d0/WfOnKm+fftq5syZGW7vRk3Hjx/X4sWLtW/fPj3zzDMOfbZs2aJ77rlHe/fu1ZQpU7Rr1y6tW7dOL730kqZNm6bdu3fb+3744Ydq06aNGjVqpM2bN+vnn39WZGSkXn31VfXp0ydbx3jD+vXrFRYWpi+//FJbt25VkyZN1Lp1a23bts3eZ+HChYqOjtagQYMUHx+v2rVrKzw83P4wvBMnTujEiRMaO3asdu3apdjYWK1atcrh/+HWrVsVEBCguXPnavfu3Xr77bc1YMAATZ482d7H09NTzz77bLqnCgNAfnXHPFjO9EObbvWhQZ9++qm6devm8JTXLVu2qEGDBpo4caJef/31dO85d+6cihQpotjYWPXq1Uvnzp1zWH/69GmFhoYqPDzc/nTWrDz66KP6+eeftW/fPhUuXDjDfd3w3//+Vx06dNDhw4cVHBysTz75RP/617/s6zOq6cMPP7SPDPj5+cmyLIWGhqpQoULasmWL3NzSZ13LsmSz2XTs2DHdfffd6tGjh8aNG+fQ58Z2N23apAYNGtz0ODMTGhqqiIgIDRw4UJLUoEED1a9f3x4Url+/rqCgIPXo0UP9+/fPcBuffPKJOnbsqIsXL6pAgYzv0de9e3ft3btX3377rb3tRhg6d+6cvL29072HB8vd+XiwXP7Cg+V4sFyusGHDBt17770ObfPmzZOPj4+6deuW4Xv+GgYyEhAQoA4dOmj58uVKS0vLsu+ZM2e0atUqde/ePV3wyGhfMTExat++vTw8PNS+fXvFxMRkuf3Tp09r6dKlcnd3l7u7uyRp+/bt2rt3r/r06ZNh8JAkm80m6c9wlpqamuEIxyuvvCIfHx/FxcVlWUNWrl+/rvPnz6tYsWKSpKtXr2rr1q1q3ry5vY+bm5uaN2+ujRs3ZrqdG79UmQWPG31u7OeGevXq6dq1a9q8efNtHwMA3CkIH4YcPXpUgYGBDm0HDhxQxYoV/9FTa6tWrarz58/rjz/+yLLfwYMHZVmWqlatetNtJicn69NPP1XHjh0lSR07dtSiRYt04cIFh35JSUny8fFR4cKFVapUKa1du9Yh3Ozfv1+SVKVKFft7Tp8+LR8fH/sydepUe19/f3+VKVMmXT2enp6qWLGifXu3Y+zYsbpw4YLatWsnSfr999+VlpaW7tk0pUqVUmJiYobb+P333/Xee++pS5cume7nhx9+0MKFC9P1KVSokPz9/TN9QB8A5CeED0MuX76cbjjdGWe8bmzjxgjCzfplR1xcnO6++27Vrl1bklSnTh2VL19eCxcudOjn6+ur7du366efftK4ceN0zz33aNiwYVluu3jx4tq+fbu2b9+uIkWK6OrVq9mu63bNnz9fQ4YM0aJFixQQEHBb20hOTlarVq1UvXp1DR48OMM+u3btUps2bTRo0CC1aNEi3Xpvb29dunTptvYPAHcSwochJUqU0NmzZx3aQkJCdOjQoUyfGJsde/fulZ+fn4oXL55lv8qVK8tms+mXX3656TZjYmK0e/duFShQwL7s2bMn3cRTNzc3VapUSdWqVVN0dLQaNmyorl27OuxTkvbt22dvc3d3V6VKlVSpUiWHUxchISFKSkrKcPLs1atX9euvvyokJOSmtf/dggUL9NJLL2nRokUOp1hKlCghd3d3nTp1yqH/qVOnVLp0aYe28+fP65FHHpGvr6+WLl2a4UjVnj171KxZM3Xp0kXvvPNOhrWcOXNGJUuWvOVjAIA7DeHDkLp162rPnj0Obc8++6wuXLhgP/Xwd3+fYPp3p0+f1vz589W2bdtM51TcUKxYMYWHh2vKlCm6ePFipvvauXOnfvrpJ61bt84+QrF9+3atW7dOGzduzDK89O/fXwsXLlR8fLykP4+5atWqGjt2rK5fv55lfU899ZQ8PDzSTTaV/rxPxsWLF9W+ffsst/F3cXFx6tSpk+Li4tSqlePkL09PT917770Olxhfv35da9as0f33329vS05OVosWLeTp6anly5dnOBl09+7datKkiaKiojId+fn111915coV1a1b95aOAQDuRJnPmoNThYeHa8CAATp79qyKFi0q6c+rLfr27avevXvr+PHjeuKJJxQYGKiDBw9q+vTpeuCBB+xXwViWpcTERFmWpXPnzmnjxo0aPny4/P39NXLkyGzVMGXKFDVq1Ej33Xefhg4dqlq1aunatWtavXq1pk2bpr179yomJkb33XefHnrooXTvr1+/vmJiYjK874ckBQUF6YknntDAgQP1+eefy2azadasWQoLC1OjRo00YMAAVatWTampqVq/fr1+++03++TUcuXKafTo0erdu7cKFiyo5557Th4eHvrss8/01ltvqXfv3rd0pcv8+fMVFRWlDz74QA0aNLDP4/D29pa/v78kKTo6WlFRUapXr57uu+8+TZw4URcvXlSnTp0k/X/wuHTpkubOnavk5GQlJydLkkqWLCl3d3ft2rVLTZs2VXh4uKKjo+37cXd3dxjl2LBhgypWrKi7774728cAAHcqRj4MqVmzpu655x4tWrTIoX3UqFGaP3++Nm/erPDwcIWGhio6Olq1atVSVFSUvV9ycrLKlCmju+66S/fff79mzJihqKgobdu2LcNJmhmpWLGi4uPj1aRJE/Xu3Vs1atRQWFiY1qxZo2nTpunq1auaO3eunnrqqQzf/9RTT2nOnDlZniZ644039MUXX9hv1tWwYUNt3bpVVapUUffu3VW9enX961//UlxcnCZMmOBwmqZXr15aunSpNmzYoHr16qlGjRqaP3++pk2bprFjxzrsJzg4ONO5F5L00Ucf6dq1a+revbvKlCljX/56SXNERITGjh2rgQMHqk6dOtq+fbtWrVpln4QaHx+vzZs3a+fOnapUqZLDdo4dOybpz6t0fvvtN82dO9dhff369R3qiYuL08svv5xpvQCQn9wx9/nIC7744gu9+eab2rVr101PkyBzly5dUvHixbVy5Uo1btzY1eXc1O7du9W0aVP7FT0Zyes/27g57vORv3Cfj6zv88FpF4NatWqlAwcO6Pjx4woKCnJ1OXnW2rVr1bRp0zwRPCTp5MmTmjNnTqbBAwDyG8KHYb169cqR7SYkJKh69eqZrt+zZ4/KlSuXI/s2rVWrVukmkOZmf73KBgBA+LhjBAYGavv27VmuBwAgNyB83CEKFCigSpUquboMAABuilmPAADAqDwZPm52wyogr+FnGkB+kqdOu3h6esrNzU0nTpxQyZIl5enpedNnmgC5mWVZunr1qn777Te5ubnJ09PT1SUBQI7LU+HDzc1NFSpU0MmTJzN8BgiQVxUqVEjlypXj/i8A8oU8FT6kP0c/ypUrp2vXriktLc3V5QD/mLu7uwoUKMAoHoB8I8+FD+nPx8d7eHhk+HRRAACQuzHGCwAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAw6pbDx/r169W6dWsFBgbKZrNp2bJlDusty9LAgQNVpkwZeXt7q3nz5jpw4ICz6gUAAHncLYePixcvqnbt2poyZUqG60ePHq1JkyZp+vTp2rx5swoXLqzw8HBduXLlHxcLAADyvgK3+oaWLVuqZcuWGa6zLEsTJ07UO++8ozZt2kiS5syZo1KlSmnZsmWKjIz8Z9UCAIA8z6lzPg4fPqzExEQ1b97c3ubv768GDRpo48aNGb4nJSVFycnJDgsAALhzOTV8JCYmSpJKlSrl0F6qVCn7ur8bMWKE/P397UtQUJAzSwIAALmMy692GTBggJKSkuzLsWPHXF0SAADIQU4NH6VLl5YknTp1yqH91KlT9nV/5+XlJT8/P4cFAADcuZwaPipUqKDSpUtrzZo19rbk5GRt3rxZ999/vzN3BQAA8qhbvtrlwoULOnjwoP314cOHtX37dhUrVkzlypVTr1699P7776ty5cqqUKGC3n33XQUGBqpt27bOrBsAAORRtxw+fvrpJzVp0sT+Ojo6WpIUFRWl2NhY9e3bVxcvXlSXLl107tw5PfDAA1q1apUKFizovKoBAECeZbMsy3J1EX+VnJwsf39/JSUlMf8DwB0juP8Xri4BBh0Z2crVJRh3K9/fLr/aBQAA5C+EDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABjl9PCRlpamd999VxUqVJC3t7fuvvtuvffee7Isy9m7AgAAeVABZ29w1KhRmjZtmmbPnq3Q0FD99NNP6tSpk/z9/dWzZ09n7w4AAOQxTg8fP/zwg9q0aaNWrVpJkoKDgxUXF6ctW7Y4e1cAACAPcvppl3/9619as2aN9u/fL0nasWOHvvvuO7Vs2dLZuwIAAHmQ00c++vfvr+TkZFWtWlXu7u5KS0vTsGHD1KFDhwz7p6SkKCUlxf46OTnZ2SUBAIBcxOkjH4sWLdK8efM0f/58xcfHa/bs2Ro7dqxmz56dYf8RI0bI39/fvgQFBTm7JAAAkIvYLCdfhhIUFKT+/fure/fu9rb3339fc+fO1S+//JKuf0YjH0FBQUpKSpKfn58zSwMAlwnu/4WrS4BBR0a2cnUJxiUnJ8vf3z9b399OP+1y6dIlubk5Dqi4u7vr+vXrGfb38vKSl5eXs8sAAAC5lNPDR+vWrTVs2DCVK1dOoaGh2rZtm8aPH6/OnTs7e1cAACAPcnr4+PDDD/Xuu++qW7duOn36tAIDA/XKK69o4MCBzt4VAADIg5wePnx9fTVx4kRNnDjR2ZsGAAB3AJ7tAgAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMCpHwsfx48fVsWNHFS9eXN7e3qpZs6Z++umnnNgVAADIYwo4e4Nnz55Vo0aN1KRJE61cuVIlS5bUgQMHVLRoUWfvCgAA5EFODx+jRo1SUFCQZs2aZW+rUKGCs3cDAADyKKefdlm+fLnq1aunZ555RgEBAapbt67+/e9/O3s3AAAgj3J6+Dh06JCmTZumypUr66uvvlLXrl3Vs2dPzZ49O8P+KSkpSk5OdlgAAMCdy+mnXa5fv6569epp+PDhkqS6detq165dmj59uqKiotL1HzFihIYMGeLsMgAAQC7l9JGPMmXKqHr16g5t1apVU0JCQob9BwwYoKSkJPty7NgxZ5cEAAByEaePfDRq1Ej79u1zaNu/f7/Kly+fYX8vLy95eXk5uwwAAJBLOX3k44033tCmTZs0fPhwHTx4UPPnz9dHH32k7t27O3tXAAAgD3J6+Khfv76WLl2quLg41ahRQ++9954mTpyoDh06OHtXAAAgD3L6aRdJeuyxx/TYY4/lxKYBAEAex7NdAACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARuV4+Bg5cqRsNpt69eqV07sCAAB5QI6Gjx9//FEzZsxQrVq1cnI3AAAgD8mx8HHhwgV16NBB//73v1W0aNGc2g0AAMhjcix8dO/eXa1atVLz5s2z7JeSkqLk5GSHBQAA3LkK5MRGFyxYoPj4eP3444837TtixAgNGTIkJ8oAAAC5kNNHPo4dO6bXX39d8+bNU8GCBW/af8CAAUpKSrIvx44dc3ZJAAAgF3H6yMfWrVt1+vRp3XPPPfa2tLQ0rV+/XpMnT1ZKSorc3d3t67y8vOTl5eXsMgAAQC7l9PDRrFkz7dy506GtU6dOqlq1qvr16+cQPAAAQP7j9PDh6+urGjVqOLQVLlxYxYsXT9cOAADyH+5wCgAAjMqRq13+bt26dSZ2AwAA8gBGPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABhF+AAAAEYRPgAAgFGEDwAAYBThAwAAGEX4AAAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGET4AAIBRhA8AAGAU4QMAABjl9PAxYsQI1a9fX76+vgoICFDbtm21b98+Z+8GAADkUU4PH//973/VvXt3bdq0SatXr1ZqaqpatGihixcvOntXAAAgDyrg7A2uWrXK4XVsbKwCAgK0detWPfTQQ87eHQAAyGNyfM5HUlKSJKlYsWI5vSsAAJAHOH3k46+uX7+uXr16qVGjRqpRo0aGfVJSUpSSkmJ/nZycnJMlAQAAF8vRkY/u3btr165dWrBgQaZ9RowYIX9/f/sSFBSUkyUBAAAXy7Hw8dprr+nzzz/X2rVrVbZs2Uz7DRgwQElJSfbl2LFjOVUSAADIBZx+2sWyLPXo0UNLly7VunXrVKFChSz7e3l5ycvLy9llAACAXMrp4aN79+6aP3++PvvsM/n6+ioxMVGS5O/vL29vb2fvDgAA5DFOP+0ybdo0JSUlqXHjxipTpox9WbhwobN3BQAA8qAcOe0CAACQGZ7tAgAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwKgCri4A/y+4/xeuLgEGHRnZytUlAIBLMPIBAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AEAAIwifAAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwKsfCx5QpUxQcHKyCBQuqQYMG2rJlS07tCgAA5CE5Ej4WLlyo6OhoDRo0SPHx8apdu7bCw8N1+vTpnNgdAADIQ3IkfIwfP14vv/yyOnXqpOrVq2v69OkqVKiQZs6cmRO7AwAAeYjTw8fVq1e1detWNW/e/P934uam5s2ba+PGjc7eHQAAyGMKOHuDv//+u9LS0lSqVCmH9lKlSumXX35J1z8lJUUpKSn210lJSZKk5ORkZ5eW611PueTqEmBQfvwZz8/4/c5f8uPv941jtizrpn2dHj5u1YgRIzRkyJB07UFBQS6oBjDHf6KrKwCQU/Lz7/f58+fl7++fZR+nh48SJUrI3d1dp06dcmg/deqUSpcuna7/gAEDFB0dbX99/fp1nTlzRsWLF5fNZnN2echlkpOTFRQUpGPHjsnPz8/V5QBwIn6/8xfLsnT+/HkFBgbetK/Tw4enp6fuvfderVmzRm3btpX0Z6BYs2aNXnvttXT9vby85OXl5dBWpEgRZ5eFXM7Pz48/TsAdit/v/ONmIx435Mhpl+joaEVFRalevXq67777NHHiRF28eFGdOnXKid0BAIA8JEfCR0REhH777TcNHDhQiYmJqlOnjlatWpVuEioAAMh/cmzC6WuvvZbhaRbgr7y8vDRo0KB0p94A5H38fiMzNis718QAAAA4CQ+WAwAARhE+AACAUYQPAABgFOEDAAAYRfgAAABGufzZLgCAO8/PP/+s/fv3S5JCQkJUq1YtF1eE3ITwAZc4fvy4Fi9ebP/jVKVKFT355JO66667XFwZgH9iy5YtevHFF7Vnzx77001tNptCQ0MVExOj+vXru7hC5Abc5wPGTZ06VdHR0bp69ar9eQ/Jycny9PTU+PHj1a1bNxdXCOB27NmzRw0aNFC1atX0xhtvqFq1avb2CRMmaN++fdq0aZOqV6/u4krhaoQPGPXFF1+oTZs26tWrl3r37q0yZcpIkk6ePKkxY8boww8/1GeffaZHH33UxZUCuFXt2rXTtWvXtHjx4nRPJbcsS08++aQ8PDy0aNEiF1WI3ILwAaMaN26sBx54QO+//36G69955x199913WrdundnCAPxjJUuW1MqVK1WvXr0M1//444969NFH9dtvvxmuDLkNV7vAqPj4eD333HOZrn/uuecUHx9vsCIAznL+/PksHyBaunRpnT9/3mBFyK0IHzAqLS1NHh4ema738PBQWlqawYoAOEv58uW1ZcuWTNdv3rxZ5cuXN1gRcivCB4wKDQ3VZ599lun6ZcuWKTQ01GBFAJwlMjJS0dHR2rVrV7p1O3fuVJ8+fRQREeGCypDbcKktjOrevbu6du0qLy8vdenSRQUK/PkjeO3aNc2YMUPvvPOOpk6d6uIqAdyOAQMG6JtvvlGdOnUUFhamatWqybIs7d27V998843uu+8+vfXWW64uE7kAE05hXJ8+fTR+/Hj5+vrq7rvvlmVZOnTokC5cuKCePXtqwoQJri4RwG26evWqJkyYoLi4OIebjEVGRuqNN96Ql5eXiytEbkD4gEts2rRJcXFxOnDggKT//+PUsGFDF1cGAMhphA8AAGAUcz5gVEJCQrb6lStXLocrAeBsFSpUSHdzsb+z2Wz69ddfDVWE3IqRDxjl5uaW4R8ny7Ls7TabTdeuXTNdGoB/6IMPPsh03ZEjRzRjxgylpKRwOT0IHzBrx44dGbZblqUFCxZo0qRJ8vHx0enTpw1XBiAnnDlzRu+9956mTZumBg0aaNSoUcztAqddYFbt2rXTtX3zzTfq37+/9u/fr759+6p3794uqAyAM12+fFnjx4/X2LFjVb58eS1ZsoRnNsGO8AGXiY+PV79+/bRhwwa99NJL+vLLLxUQEODqsgD8A2lpafr3v/+tIUOGqGDBgpo0aZI6dux407kgyF8IHzDu119/1VtvvaXFixerXbt22rNnjypWrOjqsgD8Q4sWLdI777yjc+fO6e2331bXrl3l6enp6rKQCzHnA0Z169ZNMTExatKkiUaOHKk6deq4uiQATuLm5iZvb2+1b99efn5+mfYbP368waqQGxE+YJSbm5sKFiyoqlWrZtmPJ9sCeU/jxo2zdantt99+a6gi5FacdoFRgwYNcnUJAHLIunXrXF0C8ghGPgAAgFGMfAAAnCI6Ojpb/ZjzAcIHjKpbt262LrljzgeQ92zbts3VJSCPIHzAqLZt27q6BAA5ZO3ata4uAXkEcz4AAEYcOnRIr776qr7++mtXlwIXc3N1AQCA/OH8+fNas2aNq8tALsBpFxjVpEmTbN0HgD9QAHDnInzAqKzuaHr+/HnNnz9fKSkp5goCABhH+IBREyZMSNd27do1TZkyRcOGDdNdd92l9957zwWVAQBMIXzApebNm6eBAwfq8uXLGjx4sLp06aICBfixBPKim11Kf+nSJYPVIDfjrzxcYtWqVerfv78OHz6sPn36KDo6WoULF3Z1WQD+AS6lR3ZxqS2M2rJli/r166dNmzbp1Vdf1dtvv60SJUq4uiwAgEGEDxh145HbXbp0UYUKFTLt17NnT4NVAQBMInzAqODg4Gxdanvo0CFDFQFwlqJFi2b4++3v76+QkBD16dNHYWFhLqgMuQ3hAwDgFLNnz86w/dy5c9q6dasWLlyoTz/9VK1btzZcGXIbwgcAwIjx48fr008/1Q8//ODqUuBihA8YNWnSpGz1Y84HcOfZv3+/GjZsqDNnzri6FLgY4QNGZTXJ9AbmfAB3pp07dyosLEyJiYmuLgUuxn0+YNThw4ddXQIAF4mJicnyEQvIPwgfAACniI6OzrA9KSlJ8fHx2r9/v9avX2+4KuRGhA8YNWfOnGz1e/7553O4EgDOtm3btgzb/fz8FBYWpiVLlmTr1CvufMz5gFFubm7y8fFRgQIFlNmPns1mY0IaANzB3FxdAPKXatWqydPTU88//7z++9//6uzZs+kWggeQN6Wlpennn3/W5cuX0627dOmSfv75Z12/ft0FlSG3IXzAqN27d+uLL77Q5cuX9dBDD6levXqaNm2akpOTXV0agH/o448/VufOneXp6Zlunaenpzp37qz58+e7oDLkNpx2gctcvnxZn3zyiWbNmqUtW7aobdu2mjlzpry8vFxdGoDb8OCDD6p79+6KjIzMcP2iRYs0efJkJp2C8AHXW79+vQYNGqT169fr999/V9GiRV1dEoDbEBAQoC1btig4ODjD9YcPH9Z9992n3377zWxhyHU47QKXOH78uIYPH67KlSsrMjJS9evX1+7duwkeQB528eLFLE+hnj9/XpcuXTJYEXIrwgeMWrRokVq2bKnKlSvrxx9/1Lhx43Ts2DGNHj1aVatWdXV5AP6BypUrZ/nclu+++06VK1c2WBFyK067wCg3NzeVK1dOHTp0UKlSpTLtx7NdgLxn9OjRGj16tL799lvVqlXLYd2OHTvUrFkz9e3bV3379nVRhcgtCB8wKjg4WDabLcs+PNsFyJtSU1PVokULfffdd2revLl9NPOXX37RN998o0aNGmn16tXy8PBwcaVwNcIHAMBpUlNTNWHCBM2fP18HDhyQZVkKCQnRs88+q169emV4GS7yH8IHAAAwigmnMOrRRx9VUlKS/fXIkSN17tw5++s//vhD1atXd0FlAHLClStXNHv2bE2dOlUHDhxwdTnIJRj5gFHu7u46efKkAgICJP35wKnt27erYsWKkqRTp04pMDBQaWlpriwTwG2Ijo5WamqqPvzwQ0nS1atXdd9992nPnj0qVKiQrl27ptWrV+v+++93caVwNUY+YNTfsy7ZF7hzfP311woLC7O/njdvnhISEnTgwAGdPXtWzzzzjN5//30XVojcgvABAHCKhIQEh9OmX3/9tZ5++mmVL19eNptNr7/+urZt2+bCCpFbED5glM1mS3ep7c0uvQWQN7i5uTmMZm7atEkNGza0vy5SpIjOnj3ritKQyxRwdQHIXyzL0gsvvGB/eNyVK1f06quvqnDhwpKklJQUV5YH4B+oVq2aVqxYoejoaO3evVsJCQlq0qSJff3Ro0ezvLkg8g8mnMKoF154IVsjHbNmzTJQDQBnWrp0qSIjI/XAAw9o9+7dql+/vlasWGFf369fPx0+fFiLFi1yYZXIDQgfMOrQoUMKDg6Wmxtn/IA70Zo1a/T555+rdOnS6tGjhwoVKmRfN2TIED388MNq3Lix6wpErkD4gFF/v9Q2IiJCkyZNYigWyCd27dqlGjVquLoMuBj//IRRf8+6X375pS5evOiiagCYcP78eX300Udq0KCBateu7epykAsQPgAAOWL9+vWKiopSmTJlNHbsWDVp0kSbNm1ydVnIBbjaBUZxqS1wZ0tMTFRsbKxiYmKUnJysdu3aKSUlRcuWLePRCbBjzgeMcnNzU8uWLe2X2q5YsUJNmza1X2p7w5IlS1xRHoB/oHXr1lq/fr1atWqlDh066JFHHpG7u7s8PDy0Y8cOwgfsGPmAUVFRUQ6vO3bs6KJKADjbypUr1bNnT3Xt2lWVK1d2dTnIxQgfMIr7dwB3ru+++04xMTG69957Va1aNT333HOKjIx0dVnIhTjtAgBwqosXL2rhwoWaOXOmtmzZorS0NI0fP16dO3eWr6+vq8tDLkD4AADkmH379ikmJkYff/yxzp07p7CwMC1fvtzVZcHFCB8AgByXlpamzz//XDNnztRnn33m6nLgYsz5AAA4RefOnW/ap3jx4gYqQW7HyAcAwCnc3NxUvnx51a1bN93djG+w2WxcSg9GPgAAztG1a1fFxcXp8OHD6tSpkzp27KhixYq5uizkQox8AACcJiUlRUuWLNHMmTP1ww8/qFWrVnrxxRfVokUL7mYMO8IHACBHHD16VLGxsZozZ46uXbum3bt3y8fHx9VlIRfgwXIAgBzh5uYmm80my7KUlpbm6nKQixA+AABOk5KSori4OIWFhSkkJEQ7d+7U5MmTlZCQwKgH7JhwCgBwim7dumnBggUKCgpS586dFRcXpxIlSri6LORCzPkAADiFm5ubypUrp7p162Y5uZRLbcHIBwDAKZ5//nmuaEG2MPIBAACMYsIpAAAwivABAACMInwAAACjCB8AAMAowgcAADCK8AHcQV544QXZbDbZbDZ5eHioVKlSCgsL08yZM3X9+nV7vx07dujxxx9XQECAChYsqODgYEVEROj06dPZ3tfixYvVtGlTFS1aVN7e3qpSpYo6d+6sbdu22fvExsba6/nrUrBgwXQ1jxw50mH7y5Ytc7hsc926dRluy2azKTExUZI0ePBge5u7u7uCgoLUpUsXnTlzJl39P/zwgx599FEVLVpUBQsWVM2aNTV+/HhuAw4YQPgA7jCPPPKITp48qSNHjmjlypVq0qSJXn/9dT322GO6du2afvvtNzVr1kzFihXTV199pb1792rWrFkKDAzUxYsXs7WPfv36KSIiQnXq1NHy5cu1b98+zZ8/XxUrVtSAAQMc+vr5+enkyZMOy9GjRx36FCxYUKNGjdLZs2dvuu99+/al215AQIB9fWhoqE6ePKmEhATNmjVLq1atUteuXR22sXTpUj388MMqW7as1q5dq19++UWvv/663n//fUVGRoo7EAA5i5uMAXcYLy8vlS5dWpJ011136Z577lHDhg3VrFkzxcbGqkSJEkpKStJ//vMfFSjw55+AChUqqEmTJtna/qZNmzR69Gh98MEH6tmzp729XLlyuvfee9N9cdtsNns9mWnevLkOHjyoESNGaPTo0Vn2DQgIUJEiRTJdX6BAAYfjf+aZZzRr1iz7+osXL+rll1/W448/ro8++sje/tJLL6lUqVJ6/PHHtWjRIkVERGRZB4Dbx8gHkA80bdpUtWvX1pIlS1S6dGldu3ZNS5cuva1/4cfFxcnHx0fdunXLcP3t3OHS3d1dw4cP14cffqj//e9/t/z+zBw5ckRfffWVPD097W1ff/21/vjjD/Xp0ydd/9atWyskJERxcXFOqwFAeoQPIJ+oWrWqjhw5ooYNG+qtt97Ss88+qxIlSqhly5YaM2aMTp06la3t7N+/XxUrVrSPmkjS+PHj5ePjY1+SkpLs65KSkhzW+fj4qGXLlum2+8QTT6hOnToaNGhQlvsvW7asw7ZCQ0Md1u/cuVM+Pj7y9vZWhQoVtHv3bvXr18+hfkmqVq1ahtuvWrWqvQ+AnMFpFyCfsCzLPioxbNgwRUdH69tvv9XmzZs1ffp0DR8+XOvXr1fNmjVvedudO3fW448/rs2bN6tjx44OIyq+vr6Kj4936O/t7Z3hdkaNGqWmTZtmOCpxw4YNG+Tr62t/7eHh4bC+SpUqWr58ua5cuaK5c+dq+/bt6tGjR7rtMK8DcB1GPoB8Yu/evapQoYL9dfHixfXMM89o7Nix2rt3rwIDAzV27Nibbqdy5co6dOiQUlNT7W1FihRRpUqVdNddd6Xr7+bmpkqVKjksGfWTpIceekjh4eHpJq3+VYUKFRy2Vb58eYf1np6eqlSpkmrUqKGRI0fK3d1dQ4YMsa8PCQmxfx4Z2bt3r70PgJxB+ADygW+//VY7d+7UU089leF6T09P3X333dm62qV9+/a6cOGCpk6d6uwyJUkjR47UihUrtHHjRqds75133tHYsWN14sQJSVKLFi1UrFgxjRs3Ll3f5cuX68CBA2rfvr1T9g0gY5x2Ae4wKSkpSkxMVFpamk6dOqVVq1ZpxIgReuyxx/T888/r888/14IFCxQZGamQkBBZlqUVK1boyy+/dLgqJDP333+/evfurd69e+vo0aN68sknFRQUpJMnTyomJkY2m01ubv//7xrLsuz34firgIAAh3431KxZUx06dNCkSZMy3P/p06d15coVh7bixYunO/3y13pr1aql4cOHa/LkySpcuLBmzJihyMhIdenSRa+99pr8/Py0Zs0avfnmm3r66afVrl27m34OAP4BC8AdIyoqypJkSbIKFChglSxZ0mrevLk1c+ZMKy0tzbIsy/r111+tl19+2QoJCbG8vb2tIkWKWPXr17dmzZp1S/tauHCh1bhxY8vf39/y8PCwypYtaz377LPWpk2b7H1mzZplr+fvy8mTJ+01t2nTxmHbhw8ftjw9Pa2//olau3ZtptvauHGjZVmWNWjQIKt27drpao2Li7O8vLyshIQEe9v69eut8PBwy8/Pz/L09LRCQ0OtsWPHWteuXbulzwHArbNZFrOuAACAOcz5AAAARhE+ADh49dVX092X48by6quvuro8AHcATrsAcHD69GklJydnuM7Pz8/hOSoAcDsIHwAAwChOuwAAAKMIHwAAwCjCBwAAMIrwAQAAjCJ8AAAAowgfAADAKMIHAAAwivABAACM+j/r9fvQdLYJOAAAAABJRU5ErkJggg==\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Qual a faixa etária média das pessoas candidatas?"
      ],
      "metadata": {
        "id": "WsKVQSq5Pns7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca_genero['NR_IDADE_DATA_POSSE'].unique"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DmokzNJWPwG5",
        "outputId": "0eb0adb7-0a05-4a95-9c53-8dfa886a8748"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method Series.unique of 101     51.0\n",
              "173     37.0\n",
              "200     56.0\n",
              "468     50.0\n",
              "529     63.0\n",
              "573     43.0\n",
              "710     63.0\n",
              "907     38.0\n",
              "1054    44.0\n",
              "1065    49.0\n",
              "1280    50.0\n",
              "1514    64.0\n",
              "1574    63.0\n",
              "Name: NR_IDADE_DATA_POSSE, dtype: float64>"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Aqui estamos estabelecendo idades aleatóriamente, pois não temos uma coluna específica com essa informação.\n",
        "cortes = [18, 25, 45, 55, 65, 100]"
      ],
      "metadata": {
        "id": "uBYSiSJrRuXp"
      },
      "execution_count": 27,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Aqui nós vamos estabelecer faixas para os cortes\n",
        "\n",
        "categorias = ['18 a 24 anos', '25 a 34 anos', '35 a 44 anos', '55 a 64 anos', 'acima de 64 anos']"
      ],
      "metadata": {
        "id": "Bo1lLtcoSFJe"
      },
      "execution_count": 28,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Panda.cut()\n",
        "### Use cut when you need to segment and sort data values into bins. This function is also useful for going from a continuous variable to a categorical variable. For example, cut could convert ages to groups of age ranges."
      ],
      "metadata": {
        "id": "nOKoHzHrTGiY"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Label são as etiquetas que serão os cortes\n",
        "df_raca_genero['FAIXA_ETARIA'] = pd.cut(df_raca_genero['NR_IDADE_DATA_POSSE'],cortes, labels=categorias)"
      ],
      "metadata": {
        "id": "1HgxjvXGSkc_"
      },
      "execution_count": 29,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Agora a FAIXA ETARIA está contida no DataFrame que foi criado no início.\n",
        "df_raca_genero.sample(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 393
        },
        "id": "Do1T_PRNTSag",
        "outputId": "74293be8-34f9-41e9-a779-07e59f3ea238"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
              "710  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "529  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "907  13/05/2023   19:32:48         2022                2  ELEIÇÃO ORDINÁRIA   \n",
              "\n",
              "     NR_TURNO  CD_ELEICAO                      DS_ELEICAO  DT_ELEICAO  \\\n",
              "710         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "529         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "907         1         546  Eleições Gerais Estaduais 2022  02/10/2022   \n",
              "\n",
              "    TP_ABRANGENCIA  ... ST_CANDIDATO_INSERIDO_URNA NM_TIPO_DESTINACAO_VOTOS  \\\n",
              "710       ESTADUAL  ...                        SIM                   Válido   \n",
              "529       ESTADUAL  ...                        SIM                   Válido   \n",
              "907       ESTADUAL  ...                        SIM                   Válido   \n",
              "\n",
              "    CD_SITUACAO_CANDIDATO_TOT  DS_SITUACAO_CANDIDATO_TOT ST_PREST_CONTAS  \\\n",
              "710                         2                   Deferido               S   \n",
              "529                        16       Deferido com recurso               S   \n",
              "907                         2                   Deferido               S   \n",
              "\n",
              "     ST_SUBSTITUIDO  SQ_SUBSTITUIDO SQ_ORDEM_SUPLENCIA DT_ACEITE_CANDIDATURA  \\\n",
              "710             NaN             NaN                NaN                   NaN   \n",
              "529             NaN             NaN                NaN                   NaN   \n",
              "907             NaN             NaN                NaN                   NaN   \n",
              "\n",
              "     FAIXA_ETARIA  \n",
              "710  55 a 64 anos  \n",
              "529  55 a 64 anos  \n",
              "907  25 a 34 anos  \n",
              "\n",
              "[3 rows x 76 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-3e56f53a-e2e7-47b5-a2e0-9210ae17e4dc\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DT_GERACAO</th>\n",
              "      <th>HH_GERACAO</th>\n",
              "      <th>ANO_ELEICAO</th>\n",
              "      <th>CD_TIPO_ELEICAO</th>\n",
              "      <th>NM_TIPO_ELEICAO</th>\n",
              "      <th>NR_TURNO</th>\n",
              "      <th>CD_ELEICAO</th>\n",
              "      <th>DS_ELEICAO</th>\n",
              "      <th>DT_ELEICAO</th>\n",
              "      <th>TP_ABRANGENCIA</th>\n",
              "      <th>...</th>\n",
              "      <th>ST_CANDIDATO_INSERIDO_URNA</th>\n",
              "      <th>NM_TIPO_DESTINACAO_VOTOS</th>\n",
              "      <th>CD_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>DS_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>ST_PREST_CONTAS</th>\n",
              "      <th>ST_SUBSTITUIDO</th>\n",
              "      <th>SQ_SUBSTITUIDO</th>\n",
              "      <th>SQ_ORDEM_SUPLENCIA</th>\n",
              "      <th>DT_ACEITE_CANDIDATURA</th>\n",
              "      <th>FAIXA_ETARIA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>710</th>\n",
              "      <td>13/05/2023</td>\n",
              "      <td>19:32:48</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>55 a 64 anos</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>529</th>\n",
              "      <td>13/05/2023</td>\n",
              "      <td>19:32:48</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>16</td>\n",
              "      <td>Deferido com recurso</td>\n",
              "      <td>S</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>55 a 64 anos</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>907</th>\n",
              "      <td>13/05/2023</td>\n",
              "      <td>19:32:48</td>\n",
              "      <td>2022</td>\n",
              "      <td>2</td>\n",
              "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
              "      <td>1</td>\n",
              "      <td>546</td>\n",
              "      <td>Eleições Gerais Estaduais 2022</td>\n",
              "      <td>02/10/2022</td>\n",
              "      <td>ESTADUAL</td>\n",
              "      <td>...</td>\n",
              "      <td>SIM</td>\n",
              "      <td>Válido</td>\n",
              "      <td>2</td>\n",
              "      <td>Deferido</td>\n",
              "      <td>S</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25 a 34 anos</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>3 rows × 76 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3e56f53a-e2e7-47b5-a2e0-9210ae17e4dc')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-b7abd1e0-12c9-47cb-b8bd-8d40ed0f4b99\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b7abd1e0-12c9-47cb-b8bd-8d40ed0f4b99')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-b7abd1e0-12c9-47cb-b8bd-8d40ed0f4b99 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3e56f53a-e2e7-47b5-a2e0-9210ae17e4dc button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3e56f53a-e2e7-47b5-a2e0-9210ae17e4dc');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Verificando se a categoria deu certo\n",
        "\n",
        "df_raca_genero[df_raca_genero['NR_IDADE_DATA_POSSE']== 55]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "id": "iXm_BhmyUcQj",
        "outputId": "77e1e1e8-6409-4940-c254-d79e2fb6caec"
      },
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [DT_GERACAO, HH_GERACAO, ANO_ELEICAO, CD_TIPO_ELEICAO, NM_TIPO_ELEICAO, NR_TURNO, CD_ELEICAO, DS_ELEICAO, DT_ELEICAO, TP_ABRANGENCIA, SG_UF, SG_UE, NM_UE, CD_CARGO, DS_CARGO, SQ_CANDIDATO, NR_CANDIDATO, NM_CANDIDATO, NM_URNA_CANDIDATO, NM_SOCIAL_CANDIDATO, NR_CPF_CANDIDATO, NM_EMAIL, CD_SITUACAO_CANDIDATURA, DS_SITUACAO_CANDIDATURA, CD_DETALHE_SITUACAO_CAND, DS_DETALHE_SITUACAO_CAND, TP_AGREMIACAO, NR_PARTIDO, SG_PARTIDO, NM_PARTIDO, NR_FEDERACAO, NM_FEDERACAO, SG_FEDERACAO, DS_COMPOSICAO_FEDERACAO, SQ_COLIGACAO, NM_COLIGACAO, DS_COMPOSICAO_COLIGACAO, CD_NACIONALIDADE, DS_NACIONALIDADE, SG_UF_NASCIMENTO, CD_MUNICIPIO_NASCIMENTO, NM_MUNICIPIO_NASCIMENTO, DT_NASCIMENTO, NR_IDADE_DATA_POSSE, NR_TITULO_ELEITORAL_CANDIDATO, CD_GENERO, DS_GENERO, CD_GRAU_INSTRUCAO, DS_GRAU_INSTRUCAO, CD_ESTADO_CIVIL, DS_ESTADO_CIVIL, CD_COR_RACA, DS_COR_RACA, CD_OCUPACAO, DS_OCUPACAO, VR_DESPESA_MAX_CAMPANHA, CD_SIT_TOT_TURNO, DS_SIT_TOT_TURNO, ST_REELEICAO, ST_DECLARAR_BENS, NR_PROTOCOLO_CANDIDATURA, NR_PROCESSO, CD_SITUACAO_CANDIDATO_PLEITO, DS_SITUACAO_CANDIDATO_PLEITO, CD_SITUACAO_CANDIDATO_URNA, DS_SITUACAO_CANDIDATO_URNA, ST_CANDIDATO_INSERIDO_URNA, NM_TIPO_DESTINACAO_VOTOS, CD_SITUACAO_CANDIDATO_TOT, DS_SITUACAO_CANDIDATO_TOT, ST_PREST_CONTAS, ST_SUBSTITUIDO, SQ_SUBSTITUIDO, SQ_ORDEM_SUPLENCIA, DT_ACEITE_CANDIDATURA, FAIXA_ETARIA]\n",
              "Index: []\n",
              "\n",
              "[0 rows x 76 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-3c869b56-8499-4c86-bdb0-cd333c733ff8\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DT_GERACAO</th>\n",
              "      <th>HH_GERACAO</th>\n",
              "      <th>ANO_ELEICAO</th>\n",
              "      <th>CD_TIPO_ELEICAO</th>\n",
              "      <th>NM_TIPO_ELEICAO</th>\n",
              "      <th>NR_TURNO</th>\n",
              "      <th>CD_ELEICAO</th>\n",
              "      <th>DS_ELEICAO</th>\n",
              "      <th>DT_ELEICAO</th>\n",
              "      <th>TP_ABRANGENCIA</th>\n",
              "      <th>...</th>\n",
              "      <th>ST_CANDIDATO_INSERIDO_URNA</th>\n",
              "      <th>NM_TIPO_DESTINACAO_VOTOS</th>\n",
              "      <th>CD_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>DS_SITUACAO_CANDIDATO_TOT</th>\n",
              "      <th>ST_PREST_CONTAS</th>\n",
              "      <th>ST_SUBSTITUIDO</th>\n",
              "      <th>SQ_SUBSTITUIDO</th>\n",
              "      <th>SQ_ORDEM_SUPLENCIA</th>\n",
              "      <th>DT_ACEITE_CANDIDATURA</th>\n",
              "      <th>FAIXA_ETARIA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>0 rows × 76 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3c869b56-8499-4c86-bdb0-cd333c733ff8')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-1a4012e2-fb36-4c9d-84ee-284f500b2478\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1a4012e2-fb36-4c9d-84ee-284f500b2478')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-1a4012e2-fb36-4c9d-84ee-284f500b2478 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3c869b56-8499-4c86-bdb0-cd333c733ff8 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3c869b56-8499-4c86-bdb0-cd333c733ff8');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Qual é a faixa etária mais predominante?"
      ],
      "metadata": {
        "id": "W0KXftP-U-hg"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca_genero['FAIXA_ETARIA'].mode()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4nvV4t0qU-Js",
        "outputId": "8f560d47-67f0-434b-e229-493f98ee68f1"
      },
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0    55 a 64 anos\n",
              "Name: FAIXA_ETARIA, dtype: category\n",
              "Categories (5, object): ['18 a 24 anos' < '25 a 34 anos' < '35 a 44 anos' < '55 a 64 anos' <\n",
              "                         'acima de 64 anos']"
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Visualize graficamente a distribuição da variável DS_COR_RACA em 2022"
      ],
      "metadata": {
        "id": "OWlezhyIVJ8x"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca = df_governadores(['CD_COR_RACA', 'DS_COR_RACA']).copy()"
      ],
      "metadata": {
        "id": "eboRPf-eYRWR"
      },
      "execution_count": 57,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca[['CD_COR_RACA', 'DS_COR_RACA']].groupby(by=['DS_COR_RACA']).count()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "id": "rScsLIlAX-1d",
        "outputId": "e7f0b3eb-21f8-4f10-b074-3417e3a9aa0a"
      },
      "execution_count": 59,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             CD_COR_RACA\n",
              "DS_COR_RACA             \n",
              "BRANCA                 7\n",
              "PARDA                  3\n",
              "PRETA                  3"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-c796ce21-36cd-44a6-a463-87ce2ae9aa00\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>CD_COR_RACA</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DS_COR_RACA</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>BRANCA</th>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PARDA</th>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PRETA</th>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c796ce21-36cd-44a6-a463-87ce2ae9aa00')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-1b97f23c-7bbe-4689-a4f2-93606d4d1f38\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1b97f23c-7bbe-4689-a4f2-93606d4d1f38')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-1b97f23c-7bbe-4689-a4f2-93606d4d1f38 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c796ce21-36cd-44a6-a463-87ce2ae9aa00 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c796ce21-36cd-44a6-a463-87ce2ae9aa00');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 59
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "frequencia = df_raca[['DS_COR_RACA']].value_counts(sort=False).tolist()"
      ],
      "metadata": {
        "id": "gsw8cgEYaziq"
      },
      "execution_count": 67,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import matplotlib.pyplot as plt"
      ],
      "metadata": {
        "id": "Qw2A8gIXcZGv"
      },
      "execution_count": 76,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "plt.bar('DS_COR_RACA', frequencia)\n",
        "plt.xticks(rotation=45)\n",
        "plt.title('Distribuição por Raça em 2022')\n",
        "plt.ylabel('Quantidade de candidatura')\n",
        "\n",
        "plt.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 520
        },
        "id": "hSTRtf2AafX-",
        "outputId": "f2d2bc75-cd10-4a2f-f595-18c41597b3fc"
      },
      "execution_count": 81,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 640x480 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAioAAAH3CAYAAACVeHTfAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABHHElEQVR4nO3de3zP9f//8ft7m20225jNeRjmnIQIk9NyikIhKqfER6SiDy1JRJNPDiGHyKGSHDogZ3PWyCERlvMhzXFsNmy2vX5/9Nv7693Q9vbm/ZrdrpfL+9Jez9fr/Xw93u/U7p6v5+v5shiGYQgAAMCEXJxdAAAAwJ0QVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVPBQ+uCDD2SxWB7IuRo0aKAGDRpYtzds2CCLxaJFixY57BwnTpyQxWLR7Nmzs/zeRYsWKW/evKpbt64OHz6snj17avz48Q6rDQDuJ4IKTG/27NmyWCzWl6enp4oUKaKmTZtqwoQJunr1qkPO89dff+mDDz7Qnj17HNKfWYwePVo9e/ZU4cKFVb58eX3//fdq3bq1s8tyqPQgl/5ycXGRv7+/mjdvrqioKGeXZ1qRkZHq3r27ypYtKy8vL5UqVUo9evRQTEzMbY//+eefFRoaKi8vLxUqVEj9+vVTQkKCzTE7duxQ3759ValSJXl7e6t48eJq3769Dh06ZHNcWlqaZs+erWeeeUZBQUHy9vZW5cqVNWLECN24ceO+fWZkPxae9QOzmz17trp166bhw4crODhYN2/e1NmzZ7VhwwatWbNGxYsX15IlS1SlShXre1JSUpSSkiJPT89Mn2fnzp16/PHHNWvWLHXt2jXT70tOTpYkubu7S/p7RKVhw4ZauHChnn/++Uz3czeGYSgpKUm5cuWSq6trlt578uRJFS1aVG5ubrpw4YJ8fHyy9L1kBydOnFBwcLA6duyoFi1aKDU1VYcOHdLkyZN1/fp17dixQ4888oizyzSdGjVqKDY2Vu3atVNISIiOHTumSZMmycvLS3v27FGhQoWsx+7Zs0e1a9dWhQoV1LNnT/3555/65JNP1LBhQ61YscJ63PPPP6+tW7eqXbt2qlKlis6ePatJkyYpISFB27ZtU+XKlSVJCQkJ8vHx0RNPPKGWLVuqQIECioqK0pw5c/Tkk09q3bp1D2xUFCZnACY3a9YsQ5KxY8eODPsiIyON3LlzGyVKlDCuXbt2T+fZsWOHIcmYNWtWpo5PTEy8bfv69esNScbChQvvqR7YSkhIuOO+48ePG5KM//3vfzbtK1asMCQZvXv3vt/lZUsbN240UlNTM7RJMgYPHmzT3rx5c6Nw4cJGXFyctW369OmGJGPVqlXWtq1btxpJSUk27z106JDh4eFhvPjii9a2pKQkY+vWrRlqGjZsmCHJWLNmzT19Njw8uPSDbK1Ro0YaMmSITp48qa+//trafrs5KmvWrFFoaKjy5s2rPHnyqFy5cnr33Xcl/T0K8vjjj0uSunXrZr2EkD4npEGDBqpcubJ27dqlJ598Ul5eXtb3/nOOSrrU1FS9++67KlSokLy9vfXMM8/o9OnTNseULFnytqM3/+zzTnNUoqOj1b59ewUGBip37twqV66cBg8ebN1//Phx9e7dW2XLllXu3LmVP39+tWvXTidOnMhwzmPHjqldu3by9/eXl5eXnnjiCS1btizDcbdjsVjUt29fzZ07V+XKlZOnp6eqV6+uTZs2ZTj2119/VfPmzeXr66s8efKocePG2rZtm80x6Zf7Nm7cqNdee00FChRQsWLFMlXLrerVqydJOnr0qE37rFmz1KhRIxUoUEAeHh6qWLGipkyZcts+VqxYofr168vHx0e+vr56/PHH9c0331j3b968We3atVPx4sXl4eGhoKAgvfXWW7p+/Xqmarxy5YrefPNNBQUFycPDQ2XKlNHHH3+stLQ06zHp//4/+eQTffbZZypVqpS8vLzUpEkTnT59WoZh6MMPP1SxYsWUO3duPfvss4qNjf3Xcz/55JNycXHJ0Obv76+DBw9a2+Lj47VmzRq99NJL8vX1tbZ37txZefLk0YIFC6xtderUsY4upgsJCVGlSpVs+nR3d1edOnUy1NSmTRtJsjkWOZubswsA7tXLL7+sd999V6tXr9arr75622P279+vli1bqkqVKho+fLg8PDx05MgRbd26VZJUoUIFDR8+XO+//7569uxp/QV36/9IL126pObNm+uFF17QSy+9pIIFC961rpEjR8pisWjQoEE6f/68xo8fr7CwMO3Zs0e5c+e+58+9d+9e1atXT7ly5VLPnj1VsmRJHT16VEuXLtXIkSMlSdu3b1dUVJQ6duyoYsWK6fjx45o6daoaNGigAwcOyMvLS5J07tw51alTR9euXVO/fv2UP39+zZkzR88884wWLVpk/eVxNxs3btT8+fPVr18/eXh4aPLkyWrWrJl++eUX63D//v37Va9ePfn6+mrgwIHKlSuXpk2bpgYNGmjjxo2qVauWTZ+vvfaaAgMD9f777ysxMTHL31F6IMuXL59N+5QpU1SpUiU988wzcnNz09KlS/Xaa68pLS1Nffr0sR43e/Zsde/eXZUqVVJ4eLjy5s2rX3/9VStXrlSnTp0kSQsXLtS1a9fUu3dv5c+fX7/88osmTpyoP//8UwsXLrxrfdeuXVP9+vV15swZ9erVS8WLF9fPP/+s8PBwxcTEZJj0PHfuXCUnJ+v1119XbGysRo8erfbt26tRo0basGGDBg0apCNHjmjixIl6++23NXPmzCx/ZwkJCUpISFBAQIC1bd++fUpJSVGNGjVsjnV3d1fVqlX166+/3rVPwzB07tw5VapU6V/Pf/bsWUmyOT9yOGcP6QD/5m6XftL5+fkZjz32mHV76NChxq1/vMeNG2dIMi5cuHDHPu526ad+/fqGJGPq1Km33Ve/fn3rdvqln6JFixrx8fHW9gULFhiSjE8//dTaVqJECaNLly7/2mf6pY1ba3vyyScNHx8f4+TJkzbvTUtLs/58u8thUVFRhiTjyy+/tLa9+eabhiRj8+bN1rarV68awcHBRsmSJTNcHvgnSYYkY+fOnda2kydPGp6enkabNm2sba1btzbc3d2No0ePWtv++usvw8fHx3jyySetben/zkNDQ42UlJS7ntsw/u/7GTZsmHHhwgXj7NmzxubNm43HH3/8tpfhbve9NG3a1ChVqpR1+8qVK4aPj49Rq1Yt4/r16zbH/tt3HBERYVgslgz/bv7pww8/NLy9vY1Dhw7ZtL/zzjuGq6urcerUKZvPFxgYaFy5csV6XHh4uCHJePTRR42bN29a2zt27Gi4u7sbN27cuOv571STJCMyMtLatnDhQkOSsWnTpgzHt2vXzihUqNBd+/zqq68MScYXX3zxr+cPCwszfH19jcuXL2e5djycuPSDh0KePHnuevdP3rx5JUmLFy+2GVLPCg8PD3Xr1i3Tx3fu3Fk+Pj7W7eeff16FCxfW8uXL7Tr/rS5cuKBNmzape/fuKl68uM2+Wy953Tpyc/PmTV26dEllypRR3rx5tXv3buu+5cuXq2bNmgoNDbW25cmTRz179tSJEyd04MCBf62pdu3aql69unW7ePHievbZZ7Vq1SqlpqYqNTVVq1evVuvWrVWqVCnrcYULF1anTp20ZcsWxcfH2/T56quvZmny8NChQxUYGKhChQqpXr16OnjwoMaMGZNhUvOt30tcXJwuXryo+vXr69ixY4qLi5P096XCq1ev6p133skw+fhO33FiYqIuXryoOnXqyDCMfx1pWLhwoerVq6d8+fLp4sWL1ldYWJhSU1MzXDpr166d/Pz8rNvpI1AvvfSS3NzcbNqTk5N15syZu57/nzZt2qRhw4ZZR2nSpV/G8vDwyPAeT0/Pu17mio6OVp8+fVS7dm116dLlruf/6KOPtHbtWo0aNcr63yxAUMFDIf0Ogjvp0KGD6tatqx49eqhgwYJ64YUXtGDBgiyFlqJFi2a49n43ISEhNtsWi0VlypS57fyQrDp27JgkWS+p3Mn169f1/vvvW+c/BAQEKDAwUFeuXLH+Qpb+vjOoXLlyGd5foUIF6/5/88/PK0lly5bVtWvXdOHCBV24cEHXrl2743nS0tIyzOEJDg7+1/PeqmfPnlqzZo2WLl1qnSeSmpqa4bitW7cqLCxM3t7eyps3rwIDA61zjtK/l/R5Lf/2HZ86dUpdu3aVv7+/8uTJo8DAQNWvX9+mrzs5fPiwVq5cqcDAQJtXWFiYJOn8+fM2x/8zlKaHlqCgoNu2X758+a7nv1V0dLTatGmjypUra8aMGTb70sNYUlJShvfduHHjjpcyz549q6efflp+fn5atGjRXUPn/Pnz9d577+mVV15R7969M103Hn7MUUG29+effyouLk5lypS54zG5c+fWpk2btH79ei1btkwrV67U/Pnz1ahRI61evTpTf2t3xLySf7rT7ZepqalZvg35dl5//XXNmjVLb775pmrXri0/Pz9ZLBa98MILdo8sPUhZ/c5DQkKsv+RbtmwpV1dXvfPOO2rYsKF1fsXRo0fVuHFjlS9fXmPHjlVQUJDc3d21fPlyjRs3LkvfS2pqqp566inFxsZq0KBBKl++vLy9vXXmzBl17dr1X/tKS0vTU089pYEDB952f9myZW227/Rn4k7tRiZXnzh9+rSaNGkiPz8/LV++PEPoL1y4sCTddn2VmJgYFSlSJEN7XFycmjdvritXrmjz5s23PSbdmjVr1LlzZz399NOaOnVqpmpGzkFQQbb31VdfSZKaNm161+NcXFzUuHFjNW7cWGPHjtVHH32kwYMHa/369QoLC3P4mg2HDx+22TYMQ0eOHLFZ7yVfvny6cuVKhveePHnS5vLIP6Xv+/333+9aw6JFi9SlSxeNGTPG2nbjxo0M5yxRooT++OOPDO+Pjo627v83//y8knTo0CF5eXkpMDBQkuTl5XXH87i4uGQYGbhXgwcP1vTp0/Xee+9p5cqVkqSlS5cqKSlJS5YssRmhWL9+vc17S5cuLenv7/hOIXjfvn06dOiQ5syZo86dO1vb16xZk6n6SpcurYSEBGu4coZLly6pSZMmSkpKUmRkpDWU3Kpy5cpyc3PTzp071b59e2t7cnKy9uzZY9Mm/f1nrFWrVjp06JDWrl2rihUr3vH827dvV5s2bVSjRg0tWLDA5hIWIHHpB9ncunXr9OGHHyo4OFgvvvjiHY+73a2aVatWlfR/w9ne3t6SdNvgYI8vv/zSZt7MokWLFBMTo+bNm1vbSpcurW3btlkXjZOkn376KcMlkH8KDAzUk08+qZkzZ+rUqVM2+279W7Srq2uGv1VPnDgxw+WQFi1a6JdffrFZxTUxMVGff/65SpYseddfNOmioqJs5r2cPn1aixcvVpMmTeTq6ipXV1c1adJEixcvtrn8de7cOX3zzTcKDQ21ufXVEfLmzatevXpp1apV1hWH00cfbv1e4uLiNGvWLJv3NmnSRD4+PoqIiMiwUmr6e2/Xl2EY+vTTTzNVX/v27RUVFaVVq1Zl2HflyhWlpKRkqh97JSYmqkWLFjpz5oyWL19+28t30t+XksLCwvT111/b/Jn+6quvlJCQoHbt2lnbUlNT1aFDB0VFRWnhwoWqXbv2Hc9/8OBBPf300ypZsqR++umn+zJqieyP6IpsY8WKFYqOjlZKSorOnTundevWac2aNSpRooSWLFly19VWhw8frk2bNunpp59WiRIldP78eU2ePFnFihWzTiAtXbq08ubNq6lTp8rHx0fe3t6qVatWludJpPP391doaKi6deumc+fOafz48SpTpozNLdQ9evTQokWL1KxZM7Vv315Hjx7V119/bf3b/N1MmDBBoaGhqlatmnr27Kng4GCdOHFCy5Yts/5Sbtmypb766iv5+fmpYsWKioqK0tq1a5U/f36bvt555x3NmzdPzZs3V79+/eTv7685c+bo+PHj+u677zKstXE7lStXVtOmTW1uT5akYcOGWY8ZMWKEdT2b1157TW5ubpo2bZqSkpI0evTozHytWfbGG29o/PjxGjVqlL799ls1adJE7u7uatWqlXr16qWEhARNnz5dBQoUsLm04evrq3HjxqlHjx56/PHH1alTJ+XLl0+//fabrl27pjlz5qh8+fIqXbq03n77bZ05c0a+vr767rvvMj035L///a+WLFmili1bqmvXrqpevboSExO1b98+LVq0SCdOnLivt+m++OKL+uWXX9S9e3cdPHjQZu2SPHny2DxqYeTIkapTp47q169vXZl2zJgxatKkiZo1a2Y9bsCAAVqyZIlatWql2NhYm/WNpL8n/krS1atX1bRpU12+fFn//e9/M6zZU7p06buGHOQgTrvfCMik9FtV01/u7u5GoUKFjKeeesr49NNPbW4BTvfP25MjIyONZ5991ihSpIjh7u5uFClSxOjYsWOG20IXL15sVKxY0XBzc7O5Hbh+/fpGpUqVblvfnW5PnjdvnhEeHm4UKFDAyJ07t/H000/f9nbVMWPGGEWLFjU8PDyMunXrGjt37szU7cmGYRi///670aZNG8PX19eQZJQrV84YMmSIdf/ly5eNbt26GQEBAUaePHmMpk2bGtHR0be9Lfro0aPG888/b+TNm9fw9PQ0atasafz000+3/cz/JMno06eP8fXXXxshISGGh4eH8dhjjxnr16/PcOzu3buNpk2bGnny5DG8vLyMhg0bGj///LPNMZm5Jf1Wd1qZNl3Xrl0NV1dX48iRI4ZhGMaSJUuMKlWqGJ6enkbJkiWNjz/+2Jg5c6YhyTh+/LjNe5csWWLUqVPH+uevZs2axrx586z7Dxw4YISFhRl58uQxAgICjFdffdX47bffMr3K8dWrV43w8HCjTJkyhru7uxEQEGDUqVPH+OSTT4zk5OS7fr47rYKc2e+vRIkSNv9t3foqUaJEhuM3b95s1KlTx/D09DQCAwONPn36ZPjvL/1W/ju90qV/pju9bnfbPnImnvUDPCTCwsI0cOBANWnS5IGf22KxqE+fPpo0adIDP/eDcvXqVevqxCxGBjw4zFEBHhKtWrXKMMwOx/Hx8VG1atW0ZMkSZ5cC5CjMUQGyuXnz5ikxMVELFy5UgQIFnF3OQ+mTTz6Rj4+Ptm3bpoYNGzq7HCBHIagA2dz+/fv1ySefqHDhwvdtQmpO99NPPykqKkqPPfaY9Rk/AB4M5qgAAADTYo4KAAAwLYIKAAAwrWw9RyUtLU1//fWXfHx8HL78OQAAuD8Mw9DVq1dVpEiRf11QMlsHlb/++svhzwYBAAAPxunTp1WsWLG7HpOtg0r6Ez5Pnz7t8GeEAACA+yM+Pl5BQUEZntR9O9k6qKRf7vH19SWoAACQzWRm2gaTaQEAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGkRVAAAgGk5NaiULFlSFoslw6tPnz7OLAsAAJiEU5/1s2PHDqWmplq3f//9dz311FNq166dE6sCAABm4dSgEhgYaLM9atQolS5dWvXr13dSRQAAwExMM0clOTlZX3/9tbp3756ppykCAICHn1NHVG71448/6sqVK+ratesdj0lKSlJSUpJ1Oz4+/gFUBgAAnMU0QeWLL75Q8+bNVaRIkTseExERoWHDhj2wmkq+s+yBnQsAADM6Meppp57fFJd+Tp48qbVr16pHjx53PS48PFxxcXHW1+nTpx9QhQAAwBlMMaIya9YsFShQQE8/fffU5uHhIQ8PjwdUFQAAcDanj6ikpaVp1qxZ6tKli9zcTJGbAACASTg9qKxdu1anTp1S9+7dnV0KAAAwGacPYTRp0kSGYTi7DAAAYEJOH1EBAAC4E4IKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLacHlTNnzuill15S/vz5lTt3bj3yyCPauXOns8sCAAAm4ObMk1++fFl169ZVw4YNtWLFCgUGBurw4cPKly+fM8sCAAAm4dSg8vHHHysoKEizZs2ytgUHBzuxIgAAYCZOvfSzZMkS1ahRQ+3atVOBAgX02GOPafr06Xc8PikpSfHx8TYvAADw8HJqUDl27JimTJmikJAQrVq1Sr1791a/fv00Z86c2x4fEREhPz8/6ysoKOgBVwwAAB4ki2EYhrNO7u7urho1aujnn3+2tvXr1087duxQVFRUhuOTkpKUlJRk3Y6Pj1dQUJDi4uLk6+vr8PpKvrPM4X0CAJCdnBj1tMP7jI+Pl5+fX6Z+fzt1RKVw4cKqWLGiTVuFChV06tSp2x7v4eEhX19fmxcAAHh4OTWo1K1bV3/88YdN26FDh1SiRAknVQQAAMzEqUHlrbfe0rZt2/TRRx/pyJEj+uabb/T555+rT58+ziwLAACYhFODyuOPP64ffvhB8+bNU+XKlfXhhx9q/PjxevHFF51ZFgAAMAmnrqMiSS1btlTLli2dXQYAADAhpy+hDwAAcCcEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFoEFQAAYFpu9rwpNTVV48aN04IFC3Tq1CklJyfb7I+NjXVIcQAAIGeza0Rl2LBhGjt2rDp06KC4uDj1799fbdu2lYuLiz744AMHlwgAAHIqu4LK3LlzNX36dA0YMEBubm7q2LGjZsyYoffff1/btm1zdI0AACCHsiuonD17Vo888ogkKU+ePIqLi5MktWzZUsuWLXNcdQAAIEezK6gUK1ZMMTExkqTSpUtr9erVkqQdO3bIw8PDcdUBAIAcza6g0qZNG0VGRkqSXn/9dQ0ZMkQhISHq3Lmzunfv7tACAQBAzmXXXT+jRo2y/tyhQweVKFFCP//8s0JCQtSqVSuHFQcAAHK2LAeVmzdvqlevXhoyZIiCg4MlSU888YSeeOIJhxcHAABytixf+smVK5e+++67+1ELAACADbvmqLRu3Vo//vijg0sBAACwZdcclZCQEA0fPlxbt25V9erV5e3tbbO/X79+DikOAADkbHYFlS+++EJ58+bVrl27tGvXLpt9FouFoAIAABzCrqBy/PhxR9cBAACQAU9PBgAApmXXiMq/Leo2c+ZMu4oBAAC4lV1B5fLlyzbbN2/e1O+//64rV66oUaNGDikMAADArqDyww8/ZGhLS0tT7969Vbp06XsuCgAAQHLgHBUXFxf1799f48aNc1SXAAAgh3PoZNqjR48qJSXFkV0CAIAczK5LP/3797fZNgxDMTExWrZsmbp06eKQwgAAAOwKKr/++qvNtouLiwIDAzVmzJh/vSMIAAAgs+wKKuvXr3d0HQAAABnYNUelUaNGunLlSob2+Pj4LN2e/MEHH8hisdi8ypcvb09JAADgIWTXiMqGDRuUnJycof3GjRvavHlzlvqqVKmS1q5d+38FudlVEgAAeAhlKRXs3bvX+vOBAwd09uxZ63ZqaqpWrlypokWLZq0ANzcVKlQoS+8BAAA5Q5aCStWqVa2XaG53iSd37tyaOHFilgo4fPiwihQpIk9PT9WuXVsREREqXrz4bY9NSkpSUlKSdTs+Pj5L5wIAANlLloLK8ePHZRiGSpUqpV9++UWBgYHWfe7u7ipQoIBcXV0z3V+tWrU0e/ZslStXTjExMRo2bJjq1aun33//XT4+PhmOj4iI0LBhw7JSMgAAyMYshmEYzi4i3ZUrV1SiRAmNHTtWr7zySob9txtRCQoKUlxcnHx9fR1eT8l3ljm8TwAAspMTo552eJ/x8fHy8/PL1O/ve5q5euDAAZ06dSrDxNpnnnnGrv7y5s2rsmXL6siRI7fd7+HhIQ8PD7v6BgAA2Y9dQeXYsWNq06aN9u3bJ4vFovRBGYvFIunvibX2SEhI0NGjR/Xyyy/b9X4AAPBwsWsdlTfeeEPBwcE6f/68vLy8tH//fm3atEk1atTQhg0bMt3P22+/rY0bN+rEiRP6+eef1aZNG7m6uqpjx472lAUAAB4ydo2oREVFad26dQoICJCLi4tcXFwUGhqqiIgI9evXL8MS+3fy559/qmPHjrp06ZICAwMVGhqqbdu22UzSBQAAOZddQSU1NdV6V05AQID++usvlStXTiVKlNAff/yR6X6+/fZbe04PAAByCLuCSuXKlfXbb78pODhYtWrV0ujRo+Xu7q7PP/9cpUqVcnSNAAAgh7IrqLz33ntKTEyUJA0fPlwtW7ZUvXr1lD9/fs2fP9+hBQIAgJzLrqDStGlT689lypRRdHS0YmNjlS9fPuudPwAAAPfKYU8A9Pf3d1RXAAAAkrIQVNq2bZvpTr///nu7igEAALhVptdR8fPzs758fX0VGRmpnTt3Wvfv2rVLkZGR8vPzuy+FAgCAnCfTIyqzZs2y/jxo0CC1b99eU6dOtT6EMDU1Va+99tp9eeYOAADImexamXbmzJl6++23bZ6U7Orqqv79+2vmzJkOKw4AAORsdgWVlJQURUdHZ2iPjo5WWlraPRcFAAAg2XnXT7du3fTKK6/o6NGjqlmzpiRp+/btGjVqlLp16+bQAgEAQM5lV1D55JNPVKhQIY0ZM0YxMTGSpMKFC+u///2vBgwY4NACAQBAzmVXUHFxcdHAgQM1cOBAxcfHSxKTaAEAgMPd84JvBBQAAHC/ZDqoVKtWTZGRkcqXL58ee+yxuy6Vv3v3bocUBwAAcrZMB5Vnn31WHh4ekqTWrVvfr3oAAACsMh1Uhg4detufAQAA7he71lEBAAB4EDI9opIvX767zku5VWxsrN0FAQAApMt0UBk/frz150uXLmnEiBFq2rSpateuLUmKiorSqlWrNGTIEIcXCQAAciaLYRhGVt/03HPPqWHDhurbt69N+6RJk7R27Vr9+OOPjqrvruLj4+Xn56e4uLj7cpt0yXeWObxPAACykxOjnnZ4n1n5/W3XHJVVq1apWbNmGdqbNWumtWvX2tMlAABABnYFlfz582vx4sUZ2hcvXqz8+fPfc1EAAACSnSvTDhs2TD169NCGDRtUq1YtSX8/lHDlypWaPn26QwsEAAA5l11BpWvXrqpQoYImTJig77//XpJUoUIFbdmyxRpcAAAA7pXdz/qpVauW5s6d68haAAAAbNgdVNLS0nTkyBGdP39eaWlpNvuefPLJey4MAADArqCybds2derUSSdPntQ/7262WCxKTU11SHEAACBnsyuo/Oc//1GNGjW0bNkyFS5cONMr1gIAAGSFXUHl8OHDWrRokcqUKePoegAAAKzsWkelVq1aOnLkiKNrAQAAsGHXiMrrr7+uAQMG6OzZs3rkkUeUK1cum/1VqlRxSHEAACBnsyuoPPfcc5Kk7t27W9ssFosMw2AyLQAAcBi7gsrx48cdXQcAAEAGdgWVEiVKOLoOAACADOxe8E2SDhw4oFOnTik5Odmm/ZlnnrmnogAAACQ7g8qxY8fUpk0b7du3zzo3RZJ1PRXmqAAAAEew6/bkN954Q8HBwTp//ry8vLy0f/9+bdq0STVq1NCGDRscXCIAAMip7BpRiYqK0rp16xQQECAXFxe5uLgoNDRUERER6tevn3799VdH1wkAAHIgu0ZUUlNT5ePjI0kKCAjQX3/9JenvSbZ//PGH46oDAAA5ml1BpXLlyvrtt98k/b1K7ejRo7V161YNHz5cpUqVsquQUaNGyWKx6M0337Tr/QAA4OFj16Wf9957T4mJiZKk4cOHq2XLlqpXr57y58+v+fPnZ7m/HTt2aNq0aaxoCwAAbNgVVJo2bWr9uUyZMoqOjlZsbKzy5cuX5ScpJyQk6MUXX9T06dM1YsQIe8oBAAAPKbsu/cTFxSk2Ntamzd/fX5cvX1Z8fHyW+urTp4+efvpphYWF2VMKAAB4iNkVVF544QV9++23GdoXLFigF154IdP9fPvtt9q9e7ciIiIydXxSUpLi4+NtXgAA4OFlV1DZvn27GjZsmKG9QYMG2r59e6b6OH36tN544w3NnTtXnp6emXpPRESE/Pz8rK+goKAs1Q0AALIXu4JKUlKSUlJSMrTfvHlT169fz1Qfu3bt0vnz51WtWjW5ubnJzc1NGzdu1IQJE+Tm5nbb1W3Dw8MVFxdnfZ0+fdqe8gEAQDZh12TamjVr6vPPP9fEiRNt2qdOnarq1atnqo/GjRtr3759Nm3dunVT+fLlNWjQILm6umZ4j4eHhzw8POwpGQAAZEN2BZURI0YoLCxMv/32mxo3bixJioyM1I4dO7R69epM9eHj46PKlSvbtHl7eyt//vwZ2gEAQM5k16WfunXrKioqSkFBQVqwYIGWLl2qMmXKaO/evapXr56jawQAADmUXSMqklS1alXNnTvXkbXwQEMAAGDDrhEVAACAB4GgAgAATIugAgAATIugAgAATOuegsqRI0e0atUq6yJvhmE4pCgAAADJzqBy6dIlhYWFqWzZsmrRooViYmIkSa+88ooGDBjg0AIBAEDOZVdQeeutt+Tm5qZTp07Jy8vL2t6hQwetXLnSYcUBAICcza51VFavXq1Vq1apWLFiNu0hISE6efKkQwoDAACwa0QlMTHRZiQlXWxsLM/iAQAADmNXUKlXr56+/PJL67bFYlFaWppGjx6thg0bOqw4AACQs9l16Wf06NFq3Lixdu7cqeTkZA0cOFD79+9XbGystm7d6ugaAQBADmXXiErlypV16NAhhYaG6tlnn1ViYqLatm2rX3/9VaVLl3Z0jQAAIIey+6GEfn5+Gjx4sCNrAQAAsJHpoLJ3795Md1qlShW7igEAALhVpoNK1apVZbFYZBiGLBaLtT19Ndpb21JTUx1YIgAAyKkyPUfl+PHjOnbsmI4fP67vvvtOwcHBmjx5svbs2aM9e/Zo8uTJKl26tL777rv7WS8AAMhBMj2iUqJECevP7dq104QJE9SiRQtrW5UqVRQUFKQhQ4aodevWDi0SAADkTHbd9bNv3z4FBwdnaA8ODtaBAwfuuSgAAADJzqBSoUIFRUREKDk52dqWnJysiIgIVahQwWHFAQCAnM2u25OnTp2qVq1aqVixYtY7fPbu3SuLxaKlS5c6tEAAAJBz2RVUatasqWPHjmnu3LmKjo6W9PeTkzt16iRvb2+HFggAAHIuuxd88/b2Vs+ePR1ZCwAAgA275qgAAAA8CAQVAABgWgQVAABgWgQVAABgWnYHlStXrmjGjBkKDw9XbGysJGn37t06c+aMw4oDAAA5m113/ezdu1dhYWHy8/PTiRMn9Oqrr8rf31/ff/+9Tp06pS+//NLRdQIAgBzIrhGV/v37q2vXrjp8+LA8PT2t7S1atNCmTZscVhwAAMjZ7AoqO3bsUK9evTK0Fy1aVGfPnr3nogAAACQ7g4qHh4fi4+MztB86dEiBgYH3XBQAAIBkZ1B55plnNHz4cN28eVOSZLFYdOrUKQ0aNEjPPfecQwsEAAA5l11BZcyYMUpISFCBAgV0/fp11a9fX2XKlJGPj49Gjhzp6BoBAEAOZdddP35+flqzZo22bNmivXv3KiEhQdWqVVNYWJij6wMAADmY3Q8llKTQ0FCFhoY6qhYAAAAbmQ4qEyZMyHSn/fr1s6sYAACAW2U6qIwbN85m+8KFC7p27Zry5s0r6e+Var28vFSgQAGCCgAAcIhMT6Y9fvy49TVy5EhVrVpVBw8eVGxsrGJjY3Xw4EFVq1ZNH3744f2sFwAA5CB23fUzZMgQTZw4UeXKlbO2lStXTuPGjdN7773nsOIAAEDOZldQiYmJUUpKSob21NRUnTt37p6LAgAAkOwMKo0bN1avXr20e/dua9uuXbvUu3fvLN2iPGXKFFWpUkW+vr7y9fVV7dq1tWLFCntKAgAADyG7gsrMmTNVqFAh1ahRQx4eHvLw8FDNmjVVsGBBzZgxI9P9FCtWTKNGjdKuXbu0c+dONWrUSM8++6z2799vT1kAAOAhY9c6KoGBgVq+fLkOHTqk6OhoSVL58uVVtmzZLPXTqlUrm+2RI0dqypQp2rZtmypVqmRPaQAA4CFyTwu+lS1bNsvh5E5SU1O1cOFCJSYmqnbt2rc9JikpSUlJSdbt2z0YEQAAPDzsDip//vmnlixZolOnTik5Odlm39ixYzPdz759+1S7dm3duHFDefLk0Q8//KCKFSve9tiIiAgNGzbM3pIBAEA2Y1dQiYyM1DPPPKNSpUopOjpalStX1okTJ2QYhqpVq5alvsqVK6c9e/YoLi5OixYtUpcuXbRx48bbhpXw8HD179/fuh0fH6+goCB7PgIAAMgG7JpMGx4errffflv79u2Tp6envvvuO50+fVr169dXu3btstSXu7u7ypQpo+rVqysiIkKPPvqoPv3009se6+HhYb1DKP0FAAAeXnYFlYMHD6pz586SJDc3N12/fl158uTR8OHD9fHHH99TQWlpaTbzUAAAQM5l16Ufb29v67yUwoUL6+jRo9a7dC5evJjpfsLDw9W8eXMVL15cV69e1TfffKMNGzZo1apV9pQFAAAeMnYFlSeeeEJbtmxRhQoV1KJFCw0YMED79u3T999/ryeeeCLT/Zw/f16dO3dWTEyM/Pz8VKVKFa1atUpPPfWUPWUBAICHjF1BZezYsUpISJAkDRs2TAkJCZo/f75CQkKydMfPF198Yc/pAQBADmFXUClVqpT1Z29vb02dOtVhBQEAAKSzazItAADAg5DpEZV8+fLJYrFk6tjY2Fi7CwIAAEiX6aAyfvx468+XLl3SiBEj1LRpU+ty91FRUVq1apWGDBni8CIBAEDOZDEMw8jqm5577jk1bNhQffv2tWmfNGmS1q5dqx9//NFR9d1VfHy8/Pz8FBcXd18Wfyv5zjKH9wkAQHZyYtTTDu8zK7+/7ZqjsmrVKjVr1ixDe7NmzbR27Vp7ugQAAMjArqCSP39+LV68OEP74sWLlT9//nsuCgAAQLLz9uRhw4apR48e2rBhg2rVqiVJ2r59u1auXKnp06c7tEAAAJBz2RVUunbtqgoVKmjChAn6/vvvJUkVKlTQli1brMEFAADgXtkVVCSpVq1amjt3riNrAQAAsJHpoBIfH2+dmRsfH3/XY+/HHTgAACDnydKCbzExMSpQoIDy5s1728XfDMOQxWJRamqqQ4sEAAA5U6aDyrp16+Tv7y9JWr9+/X0rCAAAIF2mg0r9+vWtPwcHBysoKCjDqIphGDp9+rTjqgMAADmaXeuoBAcH68KFCxnaY2NjFRwcfM9FAQAASHYGlfS5KP+UkJAgT0/Pey4KAABAyuLtyf3795ckWSwWDRkyRF5eXtZ9qamp2r59u6pWrerQAgEAQM6VpaDy66+/Svp7RGXfvn1yd3e37nN3d9ejjz6qt99+27EVAgCAHCtLQSX9bp9u3brp008/Zb0UAABwX9m1Mu2sWbMcXQcAAEAGdgWVxMREjRo1SpGRkTp//rzS0tJs9h87dswhxQEAgJzNrqDSo0cPbdy4US+//LIKFy582zuAAAAA7pVdQWXFihVatmyZ6tat6+h6AAAArOxaRyVfvnzW5fQBAADuF7uCyocffqj3339f165dc3Q9AAAAVnZd+hkzZoyOHj2qggULqmTJksqVK5fN/t27dzukOAAAkLPZFVRat27t4DIAAAAysiuoDB061NF1AAAAZGDXHBUAAIAHwa4RldTUVI0bN04LFizQqVOnlJycbLM/NjbWIcUBAICcza4RlWHDhmns2LHq0KGD4uLi1L9/f7Vt21YuLi764IMPHFwiAADIqewKKnPnztX06dM1YMAAubm5qWPHjpoxY4bef/99bdu2zdE1AgCAHMquoHL27Fk98sgjkqQ8efIoLi5OktSyZUstW7bMcdUBAIAcza6gUqxYMcXExEiSSpcurdWrV0uSduzYIQ8PD8dVBwAAcjS7gkqbNm0UGRkpSXr99dc1ZMgQhYSEqHPnzurevbtDCwQAADmXXXf9jBo1yvpzhw4dVLx4cUVFRSkkJEStWrVyWHEAACBnsyuo/FPt2rVVu3ZtR3QFAABgZVdQ+fLLL++6v3PnznYVAwAAcCu7gsobb7xhs33z5k1du3ZN7u7u8vLyIqgAAACHsGsy7eXLl21eCQkJ+uOPPxQaGqp58+Zlup+IiAg9/vjj8vHxUYECBdS6dWv98ccf9pQEAAAeQg571k9ISIhGjRqVYbTlbjZu3Kg+ffpo27ZtWrNmjW7evKkmTZooMTHRUWUBAIBszCGTaa2dubnpr7/+yvTxK1eutNmePXu2ChQooF27dunJJ590ZGkAACAbsiuoLFmyxGbbMAzFxMRo0qRJqlu3rt3FpK9w6+/vf9v9SUlJSkpKsm7Hx8fbfS4AAGB+dgWV1q1b22xbLBYFBgaqUaNGGjNmjF2FpKWl6c0331TdunVVuXLl2x4TERGhYcOG2dU/AADIfuwKKmlpaY6uQ3369NHvv/+uLVu23PGY8PBw9e/f37odHx+voKAgh9cCAADM4Z7mqFy8eFHu7u7y9fW9pyL69u2rn376SZs2bVKxYsXueJyHhwfPEgIAIAfJ8l0/V65cUZ8+fRQQEKCCBQsqX758KlSokMLDw3Xt2rUs9WUYhvr27asffvhB69atU3BwcFbLAQAAD7EsjajExsaqdu3aOnPmjF588UVVqFBBknTgwAFNnDhRa9as0ZYtW7R3715t27ZN/fr1u2t/ffr00TfffKPFixfLx8dHZ8+elST5+fkpd+7cdn4kAADwsMhSUBk+fLjc3d119OhRFSxYMMO+Jk2a6OWXX9bq1as1YcKEf+1vypQpkqQGDRrYtM+aNUtdu3bNSmkAAOAhlKWg8uOPP2ratGkZQookFSpUSKNHj1aLFi00dOhQdenS5V/7MwwjK6cHAAA5TJbmqMTExKhSpUp33F+5cmW5uLho6NCh91wYAABAloJKQECATpw4ccf9x48fV4ECBe61JgAAAElZDCpNmzbV4MGDlZycnGFfUlKShgwZombNmjmsOAAAkLNleTJtjRo1FBISoj59+qh8+fIyDEMHDx7U5MmTlZSUpC+//PJ+1QoAAHKYLAWVYsWKKSoqSq+99prCw8Otk2EtFoueeuopTZo0ScWLF78vhQIAgJwnyyvTBgcHa8WKFbp8+bIOHz4sSSpTpswdHyQIAABgL7uX0M+XL59q1qzpyFoAAABsZHkJfQAAgAeFoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEyLoAIAAEzLqUFl06ZNatWqlYoUKSKLxaIff/zRmeUAAACTcWpQSUxM1KOPPqrPPvvMmWUAAACTcnPmyZs3b67mzZs7swQAAGBiTg0qWZWUlKSkpCTrdnx8vBOrAQAA91u2mkwbEREhPz8/6ysoKMjZJQEAgPsoWwWV8PBwxcXFWV+nT592dkkAAOA+ylaXfjw8POTh4eHsMgAAwAOSrUZUAABAzuLUEZWEhAQdOXLEun38+HHt2bNH/v7+Kl68uBMrAwAAZuDUoLJz5041bNjQut2/f39JUpcuXTR79mwnVQUAAMzCqUGlQYMGMgzDmSUAAAATY44KAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLYIKAAAwLVMElc8++0wlS5aUp6enatWqpV9++cXZJQEAABNwelCZP3+++vfvr6FDh2r37t169NFH1bRpU50/f97ZpQEAACdzelAZO3asXn31VXXr1k0VK1bU1KlT5eXlpZkzZzq7NAAA4GRODSrJycnatWuXwsLCrG0uLi4KCwtTVFSUEysDAABm4ObMk1+8eFGpqakqWLCgTXvBggUVHR2d4fikpCQlJSVZt+Pi4iRJ8fHx96W+tKRr96VfAACyi/vxOza9T8Mw/vVYpwaVrIqIiNCwYcMytAcFBTmhGgAAHn5+4+9f31evXpWfn99dj3FqUAkICJCrq6vOnTtn037u3DkVKlQow/Hh4eHq37+/dTstLU2xsbHKnz+/LBbLfa8XwIMTHx+voKAgnT59Wr6+vs4uB4ADGYahq1evqkiRIv96rFODiru7u6pXr67IyEi1bt1a0t/hIzIyUn379s1wvIeHhzw8PGza8ubN+wAqBeAsvr6+BBXgIfRvIynpnH7pp3///urSpYtq1KihmjVravz48UpMTFS3bt2cXRoAAHAypweVDh066MKFC3r//fd19uxZVa1aVStXrswwwRYAAOQ8FiMzU24B4AFLSkpSRESEwsPDM1zyBZBzEFQAAIBpOX1lWgAAgDshqAAAANMiqAAAANMiqAAAANMiqAAAANMiqAAAANMiqAAAANMiqADA//f777/r8OHDNm1paWlOqgaARFABAEnS2rVrVaVKFdWrV09jxoxRVFSUJMnF5e//TbI2JuAcTn/WDwCYQVpamlq2bKlOnTrpm2++0fLly+Xt7a2IiAgVLlxY/v7+MgxDFovF2aUCOQojKgAg6YknntDhw4d1+fJlLVmyROPHj1fu3LnVp08ftWvXTpGRkbp48aKzywRyHJ71AyDHS0lJkZubm3766SeNGTNGkyZNUqVKlSRJ/v7+CggI0KVLl1S3bl2VKVNGY8eOdXLFQM7BiAqAHOny5cs6ffq0JMnN7e+r4CEhIUpISNC5c+ckSVWrVlXlypV16NAh/fDDDypXrpz27NnDBFvgAWJEBUCOs2jRIn311Vfav3+/Pv/8czVo0MA6aXbkyJGaMWOGcuXKpUKFCmnhwoUqWLCgJCk5OVnu7u6S/p7Tkv4eAPcPQQVAjjJz5kwNHDhQo0ePVtmyZRUaGipJ1omyJ06cUKtWrVSwYEEtWLBA/v7+GfpgUi3w4HDXD4AcY926dQoPD9e4ceP08ssvW9tvDR4lS5ZU9erVdfDgQWtI+WcwIaQADw7jlgAeeukDx6tWrVJoaKjatm1rsz89eKSmpkr6+/LP6dOnNWnSJJv9AB48ggqAHGP9+vUqXLiwvL29MyzgZhiGXF1ddf78eRUpUkQlS5bU0aNHnVQpgHTMUQGQYzRt2lSGYWjlypVycXHJcEnn6tWratiwoWbMmCFXV1dVrFhRrq6uTqwYACMqAB5qhmFYR0+qVKmivXv3aunSpUpLS5PFYrFe7pGkuLg4FShQQElJSXrkkUfk6upqsx/Ag8eICoCHUmJiory9vW3aLl68qGrVqsnf31+jRo1SWFiY3NzcZBiG4uLi1K1bNyUnJ2vp0qXcegyYBEEFwEPn66+/1rx58/T888/rxRdftK59Ikl79uxR8+bN5enpqZYtW6p9+/b65ZdftHz5cl24cEG7du1Srly5WCcFMAmCCoCHyrVr19S2bVslJSXp1KlTql69ukqVKqX33ntPuXPnlqurq06ePKnXX39du3fvVkxMjKpXr65q1app0qRJcnNzsy6pD8D5CCoAHjpDhw7VmTNnNGnSJC1YsEAzZsxQXFycWrZsqTZt2qhGjRpKTU2VYRg6dOiQSpcuLQ8PD0l/36LMBFrAPAgqAB4a6XfxxMXF6ZFHHtFHH32kl156SZI0ceJEvfHGG8qdO7e6deumBg0a6Pnnn7/t+wGYBxdgATw0LBaLUlJS5Ofnp169emn9+vXWfTNnzlSbNm00c+ZMnThxQl26dNGAAQMyvB+AuTCiAiBbu3LliiwWi3Lnzm0zaXbLli16/vnnNW/ePL3zzjvy8PCwPmDw0qVLOnTokB5//HHmogAmx4gKgGxr/vz56tSpk6pWrarXX39dW7dute4LDQ1V+/bt1bhxY3l7e+v777+3PgU5f/78ql27ttzc3FgnBTA5ggqAbGnatGl65ZVXVKtWLXXo0EHz5s3Txx9/rMuXL1sXeHvqqadUtGhRjRgxQgEBAbcNJUycBcyNSz8Asp0vv/xS3bp107Jly9SsWTNJ0uuvv67Jkyfr4MGDKlu2rPXY0NBQ5cuXT0uXLnVWuQDuASMqALINwzB0+vRp9ejRQ02bNlW1atWs+44cOSKLxaIDBw7ol19+0cmTJyVJ4eHh2r9/v9atW+essgHcA0ZUAGQ706ZN06hRo9SxY0e99dZb6tu3r7Zv3646deqoWLFimjNnjooWLaoaNWooT548OnPmjObNm8dKs0A2RFABkG3cuqz9559/ruHDhyt37txyc3PT5s2bFRAQIEmKjo7W8ePHFR4erieeeEKfffaZXF1dWRYfyIYIKgCylVsXZZszZ47efPNNtW/fXkOGDFGxYsVsjk1OTlauXLlksVgIKUA2xQICALKVW0NHly5dlJycrGHDhsnPz0+9e/dWcHCwpL+Xwk9fV4WQAmRfBBUA2Y6Li4s1fLz66qsyDEMffvihXFxc1KNHD5UpU8bmtmNCCpB9EVQAZEsuLi7Wy0A9e/aUi4uL/vOf/ygoKEhlypRxdnkAHIQ5KgBM7d8u29w6Z2Xp0qVq0aIFi7gBDxGCCgBTOXz4sJKTk5WUlGRdJ+Xfwso/99+8eVO5cuW677UCuP+4cAvANL788ku1bdtWTZs2VYsWLfS///1P0r/PMbn1qceXLl0ipAAPEYIKAFOYNm2aevToof/+97+aMmWKwsLCNGjQIEVGRt71fbde+pk8ebLCwsIUFxf3IEoG8AAwmRaA0y1atEi9e/fW+vXrVb9+fUlSUlKSvv32W507dy7D8enh5NaQMm3aNL377ruaPn26/Pz8Hmj9AO4fggoAp4qPj9dPP/2kgIAAxcfHW9vnzZuntLQ0LVmyRLGxsfLz81OnTp3k6uqaYQG3adOmaeDAgZo5c6aee+45Z30UAPcBQQWAU/n6+urNN9+Up6enBg0aJEmaP3++9u/fr2nTpsnV1VXbt2/XwoULNXXqVKWkpOjbb7+1Luw2bdo0DRo0iJACPKS46weAKezevVtTpkzRDz/8IFdXV508eVKenp7W/efOndOiRYu0Z88eTZkyRW5ublq4cKE6dOigRYsWqW3btk6sHsD9QlAB8MBFR0frwoULOn78uAICAtSiRQtJ0sGDBzV27Fht3LhRo0aNsoaP5ORkubu728xJuXHjhlasWCEfHx+FhYU57bMAuL+49APggZo9e7ZGjRoli8WiY8eOKS0tTVWqVNHYsWNVv359DRgwQIZhaPDgwUpJSVH79u3l7u6eYa0UT09PPfvssyyPDzzk+C8cwAPz1VdfqXfv3hoyZIhWrVqls2fP6ptvvlFqaqo6duyo5cuXq3z58urbt6/q1aun4cOHa86cOZJuv5YKIQV4+HHpB8ADcfLkSbVr1069evXSK6+8Yh0hMQxDJ06cUPv27RUfH68dO3bI19dXv/32m0aMGCF3d3fNnTvX2eUDcBL+OgLggbh69arOnDmjSpUqSfq/0RCLxaLg4GBNmDBBf/75p8aPHy9JevTRRzVq1Ch99dVXzioZgAkQVAA8EEePHtXFixdVokQJSVJqaqrN/po1ayokJEQxMTHWttKlS8vFxUVpaWkPtFYA5kFQAXDfpKWlWQPJY489Jh8fH40ZM0aS5Orqag0ghmHI1dVVAQEB8vDwyNAPc1GAnIu7fgDcF5GRkdq4caNSUlLUrVs3FS1aVHXr1tXChQtVvXp1dezY0ebyz5UrV5SQkGC9NAQAEiMqAO6DmTNnqmvXrrp+/boqVqyoMmXKyMvLS5MmTVJaWprCw8P1ySefKCUlRTdu3FBMTIxefPFF3bx5U927d3d2+QBMhLt+ADjUokWL1K1bN82cOVPt2rWztqekpMjNzU2nTp1S+/bt9ccff8jb21t58+ZVnjx5ZLFYtGnTJuXKlUupqalydXV14qcAYBYEFQAOExcXp5deekmPPvqoRowYkWF/egC5fPmytmzZoi1btsjX11dly5ZV27Zt5erqag00ACARVAA40OnTp/XYY49pwoQJ6tSpU4b96WunXLt2TV5eXhn2M5IC4J+YowLAYS5evChJKlq0qCTp5s2bNvtdXFx06dIlffTRR/rzzz+V/vek9H8SUgD8E0EFgMOEhITI29tbEydOlCTrfJNbbdy4UYcOHbLOS5Fk/ScA/BNBBYBDGIYhLy8vde3aVWvXrtXQoUMl2Y6SJCUl6ZtvvlFgYKD8/PycVSqAbIQ5KgAc6sSJE+rXr5+ioqLUrl07ffjhh7px44aOHTum4cOH68KFC9q5c6fc3NxkGAajKQDuiqACwGHSg8fRo0c1evRozZs3T7ly5VJycrIqVKggf39/LV26lFuQAWQaQQWAQ6WHlcTERJ09e1YbNmyQq6urKlasqBo1asjFxYVbkAFkGkEFQKbFx8fL19f3nvpIv0UZADKD/1sAyJQlS5aoV69eWrduXZaeZvzPW5AJKQCygv9jAPhXX3zxhV599VUVKVJEhmFkOmzcOlmWSbMA7MGlHwB39eOPP6p79+6aNm2azbN7/umfl3RuDSnffvutLl68qL59+973egE8XJjNBuCOUlJStGjRIvXs2dMmpJw6dUq7d+/W9evXVapUKdWqVeuOIWXq1Knq37+/fvzxxwddPoCHAEEFwG0ZhqGkpCT99ttvqlatmrV99OjRioyM1ObNm+Xp6anixYtr6NChatOmjfV96SFl2rRpCg8P11dffaUmTZo45XMAyN6YowLgtiwWi7y9vVWvXj0NGzZMn332merXr68ZM2aoZs2a2r9/v3bt2iU/Pz+tXLlShmEoLS3NGlI+//xzDRw4UDNmzNBzzz3n5E8DILtiRAWAjbNnz+rChQv69ddfVa1aNb388svy8vLSjBkzFBgYqIULFyo4ONh6m3LJkiV18eJFWSwWa0iZPn263nzzTX399ddq27atMz8OgGyOoALA6vvvv9cXX3yh3bt3KyEhQRaLRY0aNdKQIUP0ySefZDg+Pj5eZ86cUb169ST9fdnn7NmzWr58uebOnWu9HAQA9uKuHwCS/h4FGTRokAYPHqyqVauqevXq+vTTTzVv3jwZhqFZs2apTp06kqSbN2/q0qVLeuWVV3T+/HlFRUXZrDR78eJFBQQEOOujAHiIEFQAaPr06erbt6/mzZuX4VLNwoULNXLkSPn6+urbb7+Vv7+/3n//fe3evVvXrl3Txo0brc/ucXFxYb0UAA7FZFogh9uwYYN69eqlwYMHq23btjIMQ4ZhKCUlRZLUrl07vfrqq9q1a5e2bdumc+fOKX/+/GrYsKE2b96sXLlyKSUlRa6uroQUAA7HiAqQwx0+fFivvPKK/P39NWDAAOt8E8l2EbcqVaqoYcOG+vTTT3Xjxg15enpKEk9BBnBfMaIC5HAhISH64osvlJSUpJEjR2rLli3WfekjJPHx8bp+/bry588vSdaQIomQAuC+IqgAUEhIiCZMmCCLxaIRI0Zo69atNvuPHTumYsWKqXbt2pL+7wGDAHC/cekHgNXhw4fVr18/GYahwYMHq169ekpJSdGzzz4rFxcXLV68mKcfA3igCCoAbKSHFRcXF7377rsaO3asoqOjtWfPHuXKlSvDwwcB4H4iqADI4PDhw3rrrbe0evVqlSpVSvv27bPe3XPreikAcL8RVADcVnR0tCZPnqyxY8fKzc2NkALAKQgqAP4VIQWAsxBUAACAaTEjDgAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmBZBBQAAmNb/AyySWOMKzWKFAAAAAElFTkSuQmCC\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Há correlação entre idade, gênero e custo da campanha?"
      ],
      "metadata": {
        "id": "QVAzKJb_c7l4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_raca_genero = [['CD_GENERO', 'NR_IDADE_DATA_POSSE','VR_DESPESA_MAX_CAMPANHA']].corr(method='pearson')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "id": "zzXglfQmc8cu",
        "outputId": "2c675bc3-9edd-40f4-a3fe-14a49ad8f305"
      },
      "execution_count": 85,
      "outputs": [
        {
          "output_type": "error",
          "ename": "AttributeError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-85-68817abdb814>\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf_raca_genero\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'CD_GENERO'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'NR_IDADE_DATA_POSSE'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'VR_DESPESA_MAX_CAMPANHA'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcorr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'pearson'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;31mAttributeError\u001b[0m: 'list' object has no attribute 'corr'"
          ]
        }
      ]
    }
  ]
}