Folha_Pagamento.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime as dt\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#http://dados.prefeitura.sp.gov.br/pt_PT/dataset/folha-de-pagamento-spturis\n",
    "# SPTURIS - Folha de Pagamento - 2018.xlsx\n",
    "df = pd.read_excel('folhaspturis2018.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>5417</th>\n",
       "      <th>5418</th>\n",
       "      <th>5419</th>\n",
       "      <th>5420</th>\n",
       "      <th>5421</th>\n",
       "      <th>5422</th>\n",
       "      <th>5423</th>\n",
       "      <th>5424</th>\n",
       "      <th>5425</th>\n",
       "      <th>5426</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EMPRESA</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>...</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MÊS</th>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>...</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANO</th>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>...</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOME</th>\n",
       "      <td>JOSE DE JESUS SODRE</td>\n",
       "      <td>ALIRIO ALBINO RIBEIRO</td>\n",
       "      <td>JOSE DEVANIR LINO</td>\n",
       "      <td>MANOEL NILSON OLIVEIRA GAMA</td>\n",
       "      <td>JOSE LINO XAVIER DA SILVA</td>\n",
       "      <td>LUZDALMA PARREIRA DE SOUZA</td>\n",
       "      <td>JOSE BARBOSA COSTA</td>\n",
       "      <td>JOSE LOURENCO DA SILVA</td>\n",
       "      <td>EDSON ANTONIO SAURA</td>\n",
       "      <td>MARIA NEVES RESENDE</td>\n",
       "      <td>...</td>\n",
       "      <td>RAFAEL BRUNO FAVACHO</td>\n",
       "      <td>THIAGO SQUASSONI MARTINS</td>\n",
       "      <td>THIFANNY MIGUEL R DA COSTA</td>\n",
       "      <td>ELEONORA PIAGGI PORTELA</td>\n",
       "      <td>JACINTA DE FATIMA P LOURENCO</td>\n",
       "      <td>AMANDA GONCALVES P CANDIDO</td>\n",
       "      <td>EDSON ANTONIO GILLI E SILVA</td>\n",
       "      <td>FERNANDA DO PRADO GAVA</td>\n",
       "      <td>LUCIMARA RIBEIRO DOS S BARROS</td>\n",
       "      <td>MARIA CAROLINA LOPES PESSOA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CARGO</th>\n",
       "      <td>SUPERV. CARPINTARIA</td>\n",
       "      <td>ANALISTA ADM - RH</td>\n",
       "      <td>SUPERV. OPERACAO</td>\n",
       "      <td>SUPERV. ARRECADACAO</td>\n",
       "      <td>AG MANUT HIDRAULICA</td>\n",
       "      <td>ESPEC ENG ARQUIT-ARQ</td>\n",
       "      <td>PRODUTOR TEC EVENTOS</td>\n",
       "      <td>AG MANUT CIVIL</td>\n",
       "      <td>GERENTE (F. CONF.)</td>\n",
       "      <td>AUXILIAR DE LIMPEZA</td>\n",
       "      <td>...</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>ASSESSOR IV</td>\n",
       "      <td>OPERADOR DE CAIXA</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOTAÇÃO</th>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>COORD ADMINISTRACAO PESSOAL</td>\n",
       "      <td>COORD OPERACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD ARRECADACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>COORD SUPORTE E EVENTOS</td>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>GER DE REDUCAO DESP CONTRATUAIS E ALMOX</td>\n",
       "      <td>COORD SERVICOS AUXILIARES</td>\n",
       "      <td>...</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER COMPRAS E CONTRATOS</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>GER COMUNICACAO E PESQUISA</td>\n",
       "      <td>COORD ARRECADACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER PRODUCAO E EVENTOS</td>\n",
       "      <td>COORD JURIDICA CONTENCIOSA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ADMISSÃO</th>\n",
       "      <td>1978-02-22 00:00:00</td>\n",
       "      <td>1984-04-11 00:00:00</td>\n",
       "      <td>1986-04-01 00:00:00</td>\n",
       "      <td>1986-04-01 00:00:00</td>\n",
       "      <td>1986-05-14 00:00:00</td>\n",
       "      <td>1986-05-27 00:00:00</td>\n",
       "      <td>1986-06-02 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>2018-07-02 00:00:00</td>\n",
       "      <td>2018-07-02 00:00:00</td>\n",
       "      <td>2018-10-08 00:00:00</td>\n",
       "      <td>2013-05-10 00:00:00</td>\n",
       "      <td>2009-07-27 00:00:00</td>\n",
       "      <td>2018-11-01 00:00:00</td>\n",
       "      <td>2018-06-07 00:00:00</td>\n",
       "      <td>2018-12-18 00:00:00</td>\n",
       "      <td>2018-02-02 00:00:00</td>\n",
       "      <td>2017-10-02 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <td>1952</td>\n",
       "      <td>1967</td>\n",
       "      <td>1953</td>\n",
       "      <td>1957</td>\n",
       "      <td>1962</td>\n",
       "      <td>1959</td>\n",
       "      <td>1957</td>\n",
       "      <td>1951</td>\n",
       "      <td>1961</td>\n",
       "      <td>1934</td>\n",
       "      <td>...</td>\n",
       "      <td>1998</td>\n",
       "      <td>1998</td>\n",
       "      <td>1999</td>\n",
       "      <td>1966</td>\n",
       "      <td>1956</td>\n",
       "      <td>1994</td>\n",
       "      <td>1965</td>\n",
       "      <td>1996</td>\n",
       "      <td>1997</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VENCIMENTOS</th>\n",
       "      <td>15264.2</td>\n",
       "      <td>13565.4</td>\n",
       "      <td>6126.61</td>\n",
       "      <td>10025.7</td>\n",
       "      <td>5123.6</td>\n",
       "      <td>19903.7</td>\n",
       "      <td>9047.87</td>\n",
       "      <td>4400.81</td>\n",
       "      <td>21434.9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1176.48</td>\n",
       "      <td>1043.76</td>\n",
       "      <td>1176.48</td>\n",
       "      <td>28386.2</td>\n",
       "      <td>48118.8</td>\n",
       "      <td>6395.75</td>\n",
       "      <td>782.76</td>\n",
       "      <td>387</td>\n",
       "      <td>1920.04</td>\n",
       "      <td>1919.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENCARGOS</th>\n",
       "      <td>5639.77</td>\n",
       "      <td>5012.06</td>\n",
       "      <td>0</td>\n",
       "      <td>3704.26</td>\n",
       "      <td>1893.04</td>\n",
       "      <td>7353.93</td>\n",
       "      <td>3342.96</td>\n",
       "      <td>1625.99</td>\n",
       "      <td>7919.67</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1783.58</td>\n",
       "      <td>155.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BENEFÍCIOS</th>\n",
       "      <td>2102.8</td>\n",
       "      <td>2468.42</td>\n",
       "      <td>1819.47</td>\n",
       "      <td>2185.09</td>\n",
       "      <td>1947.13</td>\n",
       "      <td>1737.18</td>\n",
       "      <td>1418.9</td>\n",
       "      <td>3137.91</td>\n",
       "      <td>1371.56</td>\n",
       "      <td>363</td>\n",
       "      <td>...</td>\n",
       "      <td>886.8</td>\n",
       "      <td>886.8</td>\n",
       "      <td>886.8</td>\n",
       "      <td>3253.2</td>\n",
       "      <td>1690.39</td>\n",
       "      <td>893.26</td>\n",
       "      <td>1087</td>\n",
       "      <td>1059.49</td>\n",
       "      <td>886.8</td>\n",
       "      <td>601.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OUTRAS REMUNERAÇÕES</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VÍNCULO</th>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>...</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DETALHE VÍNCULO</th>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LIMINAR</th>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARQUIVO ID</th>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>0a1b5245-c53a-4e1b-91ac-1a58924c9d04</td>\n",
       "      <td>...</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "      <td>94f2211c-91ab-489d-97bc-883ed44b6694</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16 rows × 5427 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                             0     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                          JOSE DE JESUS SODRE   \n",
       "CARGO                                         SUPERV. CARPINTARIA   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1978-02-22 00:00:00   \n",
       "NASCIMENTO                                                   1952   \n",
       "VENCIMENTOS                                               15264.2   \n",
       "ENCARGOS                                                  5639.77   \n",
       "BENEFÍCIOS                                                 2102.8   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             1     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                        ALIRIO ALBINO RIBEIRO   \n",
       "CARGO                                           ANALISTA ADM - RH   \n",
       "LOTAÇÃO                               COORD ADMINISTRACAO PESSOAL   \n",
       "ADMISSÃO                                      1984-04-11 00:00:00   \n",
       "NASCIMENTO                                                   1967   \n",
       "VENCIMENTOS                                               13565.4   \n",
       "ENCARGOS                                                  5012.06   \n",
       "BENEFÍCIOS                                                2468.42   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             2     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                            JOSE DEVANIR LINO   \n",
       "CARGO                                            SUPERV. OPERACAO   \n",
       "LOTAÇÃO                          COORD OPERACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                      1986-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1953   \n",
       "VENCIMENTOS                                               6126.61   \n",
       "ENCARGOS                                                        0   \n",
       "BENEFÍCIOS                                                1819.47   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             3     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                  MANOEL NILSON OLIVEIRA GAMA   \n",
       "CARGO                                         SUPERV. ARRECADACAO   \n",
       "LOTAÇÃO                       COORD ARRECADACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                      1986-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1957   \n",
       "VENCIMENTOS                                               10025.7   \n",
       "ENCARGOS                                                  3704.26   \n",
       "BENEFÍCIOS                                                2185.09   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             4     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                    JOSE LINO XAVIER DA SILVA   \n",
       "CARGO                                         AG MANUT HIDRAULICA   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1986-05-14 00:00:00   \n",
       "NASCIMENTO                                                   1962   \n",
       "VENCIMENTOS                                                5123.6   \n",
       "ENCARGOS                                                  1893.04   \n",
       "BENEFÍCIOS                                                1947.13   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             5     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                   LUZDALMA PARREIRA DE SOUZA   \n",
       "CARGO                                        ESPEC ENG ARQUIT-ARQ   \n",
       "LOTAÇÃO                               GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                      1986-05-27 00:00:00   \n",
       "NASCIMENTO                                                   1959   \n",
       "VENCIMENTOS                                               19903.7   \n",
       "ENCARGOS                                                  7353.93   \n",
       "BENEFÍCIOS                                                1737.18   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             6     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                           JOSE BARBOSA COSTA   \n",
       "CARGO                                        PRODUTOR TEC EVENTOS   \n",
       "LOTAÇÃO                                   COORD SUPORTE E EVENTOS   \n",
       "ADMISSÃO                                      1986-06-02 00:00:00   \n",
       "NASCIMENTO                                                   1957   \n",
       "VENCIMENTOS                                               9047.87   \n",
       "ENCARGOS                                                  3342.96   \n",
       "BENEFÍCIOS                                                 1418.9   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             7     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                       JOSE LOURENCO DA SILVA   \n",
       "CARGO                                              AG MANUT CIVIL   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1987-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1951   \n",
       "VENCIMENTOS                                               4400.81   \n",
       "ENCARGOS                                                  1625.99   \n",
       "BENEFÍCIOS                                                3137.91   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                         8     \\\n",
       "EMPRESA                                               SPTURIS   \n",
       "MÊS                                                   Janeiro   \n",
       "ANO                                                      2018   \n",
       "NOME                                      EDSON ANTONIO SAURA   \n",
       "CARGO                                      GERENTE (F. CONF.)   \n",
       "LOTAÇÃO               GER DE REDUCAO DESP CONTRATUAIS E ALMOX   \n",
       "ADMISSÃO                                  1987-04-01 00:00:00   \n",
       "NASCIMENTO                                               1961   \n",
       "VENCIMENTOS                                           21434.9   \n",
       "ENCARGOS                                              7919.67   \n",
       "BENEFÍCIOS                                            1371.56   \n",
       "OUTRAS REMUNERAÇÕES                                         0   \n",
       "VÍNCULO                 CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado ocupante de cargo em comissão   \n",
       "LIMINAR                                                     -   \n",
       "ARQUIVO ID               0a1b5245-c53a-4e1b-91ac-1a58924c9d04   \n",
       "\n",
       "                                                             9     ...  \\\n",
       "EMPRESA                                                   SPTURIS  ...   \n",
       "MÊS                                                       Janeiro  ...   \n",
       "ANO                                                          2018  ...   \n",
       "NOME                                          MARIA NEVES RESENDE  ...   \n",
       "CARGO                                         AUXILIAR DE LIMPEZA  ...   \n",
       "LOTAÇÃO                                 COORD SERVICOS AUXILIARES  ...   \n",
       "ADMISSÃO                                      1987-04-01 00:00:00  ...   \n",
       "NASCIMENTO                                                   1934  ...   \n",
       "VENCIMENTOS                                                     0  ...   \n",
       "ENCARGOS                                                        0  ...   \n",
       "BENEFÍCIOS                                                    363  ...   \n",
       "OUTRAS REMUNERAÇÕES                                             0  ...   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado  ...   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão  ...   \n",
       "LIMINAR                                                         -  ...   \n",
       "ARQUIVO ID                   0a1b5245-c53a-4e1b-91ac-1a58924c9d04  ...   \n",
       "\n",
       "                                                                 5417  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                             RAFAEL BRUNO FAVACHO   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-07-02 00:00:00   \n",
       "NASCIMENTO                                                       1998   \n",
       "VENCIMENTOS                                                   1176.48   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5418  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                         THIAGO SQUASSONI MARTINS   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                       GER COMPRAS E CONTRATOS   \n",
       "ADMISSÃO                                          2018-07-02 00:00:00   \n",
       "NASCIMENTO                                                       1998   \n",
       "VENCIMENTOS                                                   1043.76   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5419  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                       THIFANNY MIGUEL R DA COSTA   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-10-08 00:00:00   \n",
       "NASCIMENTO                                                       1999   \n",
       "VENCIMENTOS                                                   1176.48   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                  5420  \\\n",
       "EMPRESA                                                        SPTURIS   \n",
       "MÊS                                                           Dezembro   \n",
       "ANO                                                               2018   \n",
       "NOME                                           ELEONORA PIAGGI PORTELA   \n",
       "CARGO                                               CEDIDO OUTRO ORGAO   \n",
       "LOTAÇÃO                                    GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                           2013-05-10 00:00:00   \n",
       "NASCIMENTO                                                        1966   \n",
       "VENCIMENTOS                                                    28386.2   \n",
       "ENCARGOS                                                             0   \n",
       "BENEFÍCIOS                                                      3253.2   \n",
       "OUTRAS REMUNERAÇÕES                                                  0   \n",
       "VÍNCULO              Servidor público cedido por outro ente: Servid...   \n",
       "DETALHE VÍNCULO       Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                              -   \n",
       "ARQUIVO ID                        94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                  5421  \\\n",
       "EMPRESA                                                        SPTURIS   \n",
       "MÊS                                                           Dezembro   \n",
       "ANO                                                               2018   \n",
       "NOME                                      JACINTA DE FATIMA P LOURENCO   \n",
       "CARGO                                               CEDIDO OUTRO ORGAO   \n",
       "LOTAÇÃO                                    GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                           2009-07-27 00:00:00   \n",
       "NASCIMENTO                                                        1956   \n",
       "VENCIMENTOS                                                    48118.8   \n",
       "ENCARGOS                                                             0   \n",
       "BENEFÍCIOS                                                     1690.39   \n",
       "OUTRAS REMUNERAÇÕES                                                  0   \n",
       "VÍNCULO              Servidor público cedido por outro ente: Servid...   \n",
       "DETALHE VÍNCULO       Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                              -   \n",
       "ARQUIVO ID                        94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                             5422  \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                      Dezembro   \n",
       "ANO                                                          2018   \n",
       "NOME                                   AMANDA GONCALVES P CANDIDO   \n",
       "CARGO                                                 ASSESSOR IV   \n",
       "LOTAÇÃO                                GER COMUNICACAO E PESQUISA   \n",
       "ADMISSÃO                                      2018-11-01 00:00:00   \n",
       "NASCIMENTO                                                   1994   \n",
       "VENCIMENTOS                                               6395.75   \n",
       "ENCARGOS                                                  1783.58   \n",
       "BENEFÍCIOS                                                 893.26   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                                                 Desligado   \n",
       "DETALHE VÍNCULO      Não concursado ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "ARQUIVO ID                   94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5423  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                      EDSON ANTONIO GILLI E SILVA   \n",
       "CARGO                                               OPERADOR DE CAIXA   \n",
       "LOTAÇÃO                           COORD ARRECADACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                          2018-06-07 00:00:00   \n",
       "NASCIMENTO                                                       1965   \n",
       "VENCIMENTOS                                                    782.76   \n",
       "ENCARGOS                                                        155.7   \n",
       "BENEFÍCIOS                                                       1087   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5424  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                           FERNANDA DO PRADO GAVA   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-12-18 00:00:00   \n",
       "NASCIMENTO                                                       1996   \n",
       "VENCIMENTOS                                                       387   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                    1059.49   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5425  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                    LUCIMARA RIBEIRO DOS S BARROS   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                        GER PRODUCAO E EVENTOS   \n",
       "ADMISSÃO                                          2018-02-02 00:00:00   \n",
       "NASCIMENTO                                                       1997   \n",
       "VENCIMENTOS                                                   1920.04   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694   \n",
       "\n",
       "                                                                 5426  \n",
       "EMPRESA                                                       SPTURIS  \n",
       "MÊS                                                          Dezembro  \n",
       "ANO                                                              2018  \n",
       "NOME                                      MARIA CAROLINA LOPES PESSOA  \n",
       "CARGO                                                      ESTAGIARIO  \n",
       "LOTAÇÃO                                    COORD JURIDICA CONTENCIOSA  \n",
       "ADMISSÃO                                          2017-10-02 00:00:00  \n",
       "NASCIMENTO                                                       1991  \n",
       "VENCIMENTOS                                                   1919.52  \n",
       "ENCARGOS                                                            0  \n",
       "BENEFÍCIOS                                                     601.52  \n",
       "OUTRAS REMUNERAÇÕES                                                 0  \n",
       "VÍNCULO                                                     Desligado  \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão  \n",
       "LIMINAR                                                             -  \n",
       "ARQUIVO ID                       94f2211c-91ab-489d-97bc-883ed44b6694  \n",
       "\n",
       "[16 rows x 5427 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "del df['ARQUIVO ID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5427, 15)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 5427 entries, 0 to 5426\n",
      "Data columns (total 15 columns):\n",
      " #   Column               Non-Null Count  Dtype         \n",
      "---  ------               --------------  -----         \n",
      " 0   EMPRESA              5427 non-null   object        \n",
      " 1   MÊS                  5427 non-null   object        \n",
      " 2   ANO                  5427 non-null   int64         \n",
      " 3   NOME                 5427 non-null   object        \n",
      " 4   CARGO                5427 non-null   object        \n",
      " 5   LOTAÇÃO              5427 non-null   object        \n",
      " 6   ADMISSÃO             5427 non-null   datetime64[ns]\n",
      " 7   NASCIMENTO           5427 non-null   int64         \n",
      " 8   VENCIMENTOS          5427 non-null   float64       \n",
      " 9   ENCARGOS             5427 non-null   float64       \n",
      " 10  BENEFÍCIOS           5427 non-null   float64       \n",
      " 11  OUTRAS REMUNERAÇÕES  5427 non-null   int64         \n",
      " 12  VÍNCULO              5427 non-null   object        \n",
      " 13  DETALHE VÍNCULO      5427 non-null   object        \n",
      " 14  LIMINAR              5427 non-null   object        \n",
      "dtypes: datetime64[ns](1), float64(3), int64(3), object(8)\n",
      "memory usage: 636.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ANO</th>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <th>VENCIMENTOS</th>\n",
       "      <th>ENCARGOS</th>\n",
       "      <th>BENEFÍCIOS</th>\n",
       "      <th>OUTRAS REMUNERAÇÕES</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5427.0</td>\n",
       "      <td>5427.000000</td>\n",
       "      <td>5427.000000</td>\n",
       "      <td>5427.000000</td>\n",
       "      <td>5427.000000</td>\n",
       "      <td>5427.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>1972.195135</td>\n",
       "      <td>6729.110024</td>\n",
       "      <td>2321.065084</td>\n",
       "      <td>2063.017942</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.0</td>\n",
       "      <td>12.581268</td>\n",
       "      <td>7159.716651</td>\n",
       "      <td>4255.845930</td>\n",
       "      <td>931.250425</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>1934.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>1963.000000</td>\n",
       "      <td>2946.210000</td>\n",
       "      <td>962.315000</td>\n",
       "      <td>1554.850000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>1971.000000</td>\n",
       "      <td>4924.950000</td>\n",
       "      <td>1633.890000</td>\n",
       "      <td>2051.980000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>1981.000000</td>\n",
       "      <td>8626.840000</td>\n",
       "      <td>3037.440000</td>\n",
       "      <td>2643.290000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>267176.050000</td>\n",
       "      <td>250890.570000</td>\n",
       "      <td>6799.050000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ANO   NASCIMENTO    VENCIMENTOS       ENCARGOS   BENEFÍCIOS  \\\n",
       "count  5427.0  5427.000000    5427.000000    5427.000000  5427.000000   \n",
       "mean   2018.0  1972.195135    6729.110024    2321.065084  2063.017942   \n",
       "std       0.0    12.581268    7159.716651    4255.845930   931.250425   \n",
       "min    2018.0  1934.000000       0.000000       0.000000     0.000000   \n",
       "25%    2018.0  1963.000000    2946.210000     962.315000  1554.850000   \n",
       "50%    2018.0  1971.000000    4924.950000    1633.890000  2051.980000   \n",
       "75%    2018.0  1981.000000    8626.840000    3037.440000  2643.290000   \n",
       "max    2018.0  2015.000000  267176.050000  250890.570000  6799.050000   \n",
       "\n",
       "       OUTRAS REMUNERAÇÕES  \n",
       "count               5427.0  \n",
       "mean                   0.0  \n",
       "std                    0.0  \n",
       "min                    0.0  \n",
       "25%                    0.0  \n",
       "50%                    0.0  \n",
       "75%                    0.0  \n",
       "max                    0.0  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1> Soma de Vencimentos por Mês</h1>\n",
    "<p> Soma dos vencimentos da prefeitura de Santos </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f57689fb4d0>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY4AAAEwCAYAAACgxJZ5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAe0klEQVR4nO3df7RdZX3n8feXJEAsWDFExQQmjGYMUG0Kd2Is7TSDIwmhDrQFSbqUIIxhKSyRKSj+Wjj+QApUGDuWtXDJAmxLYKgKo4bIolC1I8gNTSExRVJL4Tb8CCTQTPkhkO/8cfa9nFxu7jn73nPOPufc92uts+49z3n23s/5sffn7P08e5/ITCRJatZeVTdAktRbDA5JUikGhySpFINDklSKwSFJKsXgkCSVMr3qBrTagQcemPPmzau6GZLUU9avX/9kZs5upm7fBce8efMYHBysuhmS1FMi4p+breuhKklSKQaHJKkUg0OSVErf9XGM5cUXX2RoaIjnn3++6qaoCfvuuy9z585lxowZVTdF0himRHAMDQ2x//77M2/ePCKi6uZoHJnJU089xdDQEIceemjVzZE0hilxqOr5559n1qxZhkYPiAhmzZrl3qHUxaZEcACGRg/xvZK625QJjiotWbKEdevW7VZ2xRVXsHz5cmbOnMnChQtHbtdddx1QOx/lD/7gD0bq33TTTZx22mkj99euXcvAwACHHXYYCxYs4LzzzgPgc5/7HJdddhkAp512Gq95zWvYuXPnyHTnnHMOEcGTTz4JwLRp03Zb/sUXXzzS5oGBgZHpBgcHR57HcN399tuPt73tbSxcuJBTTz0VgB//+McsWrSIBQsWsGDBAq666qqReTzwwAMsWbKEhQsXcthhh7F69epJv7aSOm9K9HGMNu+C77V0fg9dfPy4j69cuZI1a9awdOnSkbI1a9Zw6aWX8vDDD7Nhw4YxpxscHGTTpk0cccQRu5Vv3LiRs88+m+9973ssWLCAl156abcNdL23vvWt3Hzzzbz//e9n165d3HHHHcyZM2fk8ZkzZ+5x+U888QRr167luOOOGylbunTpyPNYsmQJl1122UjAPPbYY/zhH/4h3/nOdzjyyCN58sknWbp0KXPmzOH444/nox/9KOeeey4nnHACAPfff/+4r5uk7uQeRwecdNJJfPe73+WFF14A4KGHHmLr1q3MnTt33OnOO+88LrrooleVX3LJJXz6059mwYIFAEyfPp2PfOQjY85j5cqV3HDDDQDceeedHH300Uyf3tz3hfPPP58vfvGLTdUF+NrXvsZpp53GkUceCcCBBx7IJZdcMrIX8+ijj+72nN/+9rc3PW9J3cPg6IBZs2axaNEibr31VqC2t3HKKacQEfzjP/7jboeKfvSjH41M9773vY97772XLVu27Da/jRs3ctRRRzW17Pnz57Nt2zZ27NjB9ddfz4oVK3Z7/Lnnnttt+cMhA/Cud72LffbZhzvuuKOpZW3atOlV7RoYGGDTpk0AnHvuuRxzzDEcd9xxXH755Tz99NNNzVdSdzE4OmT4cBXUgmPlypUAvOUtb2HDhg0jt9/+7d8emWbatGmcf/75fPnLX57Usn//93+fNWvWcPfdd+82f3jlUNXw7ZRTTtnt8c985jNN73Vk5pgd28NlH/zgB9m8eTMnn3wyd955J4sXLx7ZC5PUOwyODjnxxBO5/fbbuffee3nuuedGDuc08oEPfIAf/vCHPPzwwyNlRxxxBOvXr2962StWrOCzn/0s73nPe9hrr3Jv+THHHMPzzz/PXXfd1bDuEUcc8aoLTK5fv57DDz985P6b3/xmTj/9dG6++WamT5/Oxo0bS7VHUvUMjg7Zb7/9WLJkCaeffvrI3kYzZsyYwbnnnssVV1wxUnb++edz0UUX8fOf/xyAXbt28ZWvfGWP8zjkkEP40pe+tMd+kEY+/elPc8kllzSsd9ZZZ3HNNdeMdLY/9dRTfOITn+DjH/84ALfeeisvvvgiUOtIf+qpp3brqJfUG6bkqKqqrFy5cuSw0bDhPo5hp59+Oh/96Ed3m+6MM87Y7XDRO97xDq644gpWrlzJs88+S0Rw/PHjj+w688wzxywf7uMYtmzZspHO7GHLly9n9uzGl+k/6KCD+PM//3M+9KEPsXPnTjKTj33sY7z3ve8F4Ac/+AHnnHMO++67LwCXXnopb3rTmxrOV1J3icysug0tNTAwkKMPl2zevJnDDjusohZpInzPpM6KiPWZOdC4poeqJEklGRySpFIaBkdEHBwRd0TE5ojYFBHnFOWfi4h/iYgNxW153TSfjIgtEfFARCytK19WlG2JiAvqyg+NiLsj4sGIuCEi9i7K9ynubyken9fKJy9JKq+ZPY6XgD/KzMOAxcBZETE8vvLyzFxY3L4PUDy2AjgCWAb8WURMi4hpwNeA44DDgZV18/njYl7zgR3AGUX5GcCOzHwrcHlRb0L6rS+nn/leSd2tYXBk5qOZeW/x/05gMzDeGMoTgDWZ+UJm/hOwBVhU3LZk5i8y85fAGuCEqJ0ddgxwUzH9tcCJdfO6tvj/JuDdMYFLp+6777489dRTbpB6wPDvcQyPvJLUfUoNxy0OFf0GcDdwNHB2RJwKDFLbK9lBLVTqzxYb4pWgeWRU+TuBWcDTmfnSGPXnDE+TmS9FxDNF/SfLtHvu3LkMDQ2xbdu2MpOpIsO/ACipOzUdHBGxH/BXwMcy818j4krgC0AWf/8EOB0Ya48gGXvvJsepT4PH6tu2GlgNtZPdRpsxY4a/JidJLdLUqKqImEEtNP4iM78FkJmPZ+bLmbkL+Dq1Q1FQ22M4uG7yucDWccqfBF4XEdNHle82r+LxXwW2j25fZl6VmQOZOdDMiWqSpIlrZlRVAN8ANmfmV+rKD6qr9nvA8EWHbgFWFCOiDgXmAz8F7gHmFyOo9qbWgX5L1joe7gBOKqZfBdxcN69Vxf8nAX+ddlRIUqWaOVR1NPAB4P6IGP7Fn09RGxW1kNqho4eAMwEyc1NE3Aj8jNqIrLMy82WAiDgbWAdMA67OzE3F/D4BrImILwJ/Ry2oKP5+MyK2UNvT2P2a4JKkjpsSlxyRJI3PS45IktrG4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpDYMjIg6OiDsiYnNEbIqIc4ry10fEbRHxYPH3gKI8IuKrEbElIu6LiCPr5rWqqP9gRKyqKz8qIu4vpvlqRMR4y5AkVaeZPY6XgD/KzMOAxcBZEXE4cAFwe2bOB24v7gMcB8wvbquBK6EWAsCFwDuBRcCFdUFwZVF3eLplRfmeliFJqkjD4MjMRzPz3uL/ncBmYA5wAnBtUe1a4MTi/xOA67LmLuB1EXEQsBS4LTO3Z+YO4DZgWfHYazPzJ5mZwHWj5jXWMiRJFSnVxxER84DfAO4G3piZj0ItXIA3FNXmAI/UTTZUlI1XPjRGOeMsY3S7VkfEYEQMbtu2rcxTkiSV1HRwRMR+wF8BH8vMfx2v6hhlOYHypmXmVZk5kJkDs2fPLjOpJKmkpoIjImZQC42/yMxvFcWPF4eZKP4+UZQPAQfXTT4X2NqgfO4Y5eMtQ5JUkWZGVQXwDWBzZn6l7qFbgOGRUauAm+vKTy1GVy0GnikOM60Djo2IA4pO8WOBdcVjOyNicbGsU0fNa6xlSJIqMr2JOkcDHwDuj4gNRdmngIuBGyPiDOBh4OTise8Dy4EtwLPABwEyc3tEfAG4p6j3+czcXvz/YeAaYCawtrgxzjIkSRWJ2kCm/jEwMJCDg4NVN0OSekpErM/MgWbqeua4JKkUg0OSVIrBIUkqxeCQJJVicEiSSjE4JEmlGBySpFIMDklSKQaHJKkUg0OSVIrBIUkqxeCQJJVicEiSSjE4JEmlGBySpFIMDklSKQaHJKkUg0OSVIrBIUkqxeCQJJVicEiSSjE4JEmlGBySpFIMDklSKQaHJKkUg0OSVIrBIUkqxeCQJJVicEiSSmkYHBFxdUQ8EREb68o+FxH/EhEbitvyusc+GRFbIuKBiFhaV76sKNsSERfUlR8aEXdHxIMRcUNE7F2U71Pc31I8Pq9VT1qSNHHN7HFcAywbo/zyzFxY3L4PEBGHAyuAI4pp/iwipkXENOBrwHHA4cDKoi7AHxfzmg/sAM4oys8AdmTmW4HLi3qSpIo1DI7M/CGwvcn5nQCsycwXMvOfgC3AouK2JTN/kZm/BNYAJ0REAMcANxXTXwucWDeva4v/bwLeXdSXJFVoMn0cZ0fEfcWhrAOKsjnAI3V1hoqyPZXPAp7OzJdGle82r+LxZ4r6kqQKTTQ4rgTeAiwEHgX+pCgfa48gJ1A+3rxeJSJWR8RgRAxu27ZtvHZLkiZpQsGRmY9n5suZuQv4OrVDUVDbYzi4rupcYOs45U8Cr4uI6aPKd5tX8fivsodDZpl5VWYOZObA7NmzJ/KUJElNmlBwRMRBdXd/DxgecXULsKIYEXUoMB/4KXAPML8YQbU3tQ70WzIzgTuAk4rpVwE3181rVfH/ScBfF/UlSRWa3qhCRFwPLAEOjIgh4EJgSUQspHbo6CHgTIDM3BQRNwI/A14CzsrMl4v5nA2sA6YBV2fmpmIRnwDWRMQXgb8DvlGUfwP4ZkRsobansWLSz1aSNGnRb1/iBwYGcnBwsOpmSFJPiYj1mTnQTF3PHJcklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqRSDQ5JUisEhSSrF4JAklWJwSJJKMTgkSaUYHJKkUgwOSVIpBockqZSGwRERV0fEExGxsa7s9RFxW0Q8WPw9oCiPiPhqRGyJiPsi4si6aVYV9R+MiFV15UdFxP3FNF+NiBhvGZKkajWzx3ENsGxU2QXA7Zk5H7i9uA9wHDC/uK0GroRaCAAXAu8EFgEX1gXBlUXd4emWNViGJKlCDYMjM38IbB9VfAJwbfH/tcCJdeXXZc1dwOsi4iBgKXBbZm7PzB3AbcCy4rHXZuZPMjOB60bNa6xlSJIqNNE+jjdm5qMAxd83FOVzgEfq6g0VZeOVD41RPt4yJEkVanXneIxRlhMoL7fQiNURMRgRg9u2bSs7uSSphIkGx+PFYSaKv08U5UPAwXX15gJbG5TPHaN8vGW8SmZelZkDmTkwe/bsCT4lSVIzJhoctwDDI6NWATfXlZ9ajK5aDDxTHGZaBxwbEQcUneLHAuuKx3ZGxOJiNNWpo+Y11jIkSRWa3qhCRFwPLAEOjIghaqOjLgZujIgzgIeBk4vq3weWA1uAZ4EPAmTm9oj4AnBPUe/zmTnc4f5haiO3ZgJrixvjLEOSVKGoDWbqHwMDAzk4OFh1MySpp0TE+swcaKauZ45LkkoxOCRJpRgckqRSDA5JUikGhySpFINDklSKwSFJKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JUikGhySpFINDklSKwSFJKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JUikGhySpFINDklSKwSFJKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JUikGhySpFINDklTKpIIjIh6KiPsjYkNEDBZlr4+I2yLiweLvAUV5RMRXI2JLRNwXEUfWzWdVUf/BiFhVV35UMf8txbQxmfZKkiavFXsc/zkzF2bmQHH/AuD2zJwP3F7cBzgOmF/cVgNXQi1ogAuBdwKLgAuHw6aos7puumUtaK8kaRLacajqBODa4v9rgRPryq/LmruA10XEQcBS4LbM3J6ZO4DbgGXFY6/NzJ9kZgLX1c1LklSRyQZHAj+IiPURsbooe2NmPgpQ/H1DUT4HeKRu2qGibLzyoTHKJUkVmj7J6Y/OzK0R8Qbgtoj4h3HqjtU/kRMof/WMa6G1GuCQQw4Zv8WSpEmZ1B5HZm4t/j4BfJtaH8XjxWEmir9PFNWHgIPrJp8LbG1QPneM8rHacVVmDmTmwOzZsyfzlCRJDUw4OCLiVyJi/+H/gWOBjcAtwPDIqFXAzcX/twCnFqOrFgPPFIey1gHHRsQBRaf4scC64rGdEbG4GE11at28JEkVmcyhqjcC3y5GyE4H/jIzb42Ie4AbI+IM4GHg5KL+94HlwBbgWeCDAJm5PSK+ANxT1Pt8Zm4v/v8wcA0wE1hb3CRJFYragKX+MTAwkIODg1U3Q5J6SkSsrzutYlyeOS5JKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JUikGhySpFINDklSKwSFJKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JfW3eBd+rugl9x+DQpLliairwc/4Kg0OSVEpfB0c7vyH47UNSK7Vym9Lu7VNfB4fUjHkXfM8vAupZVXx2DQ71JDf00vjq15FWry9TKjjc2Ejj6/d1pN+fX6dMqeDoJVP5A171c696+RJ09+fQ4JAEdPeGqpf14+tqcEzCRD4Q/fghUnfxM9ZZU/H1Njia0OsfjF5vP/THc+gmvp6aDINDklSKwdEBvXwiot9MX+FrUZ6vWX8yOFSKG4I968XXphfbrOoZHFOUG4zx+fq8wteiP7TyCgkGRxfo9hWz29tXVjvPqJ2osdrRLW1rpyqeYy+9rs22tdPPacoFR6MXeE+PT3Tobavf0Gba3y3DhBttDHtpBW5WM5+fiT7vbn+9uqEvbyL1WrnOtHL7Mda03fIZ6PrgiIhlEfFARGyJiAtaPf9Ob9j3VGei0zWrk99oO/XhbvcK1Wj+zW5wWv2+tWr+3bChb9f0E5lPM5+nbtlwV62rgyMipgFfA44DDgdWRsThrV7O6A9DJ761t+IDODyPdl2OeTIrz0Rf08nUadX7OFnd8OVhMl8UmgnMiZRN9PPUzRvxyYR2L7e/q4MDWARsycxfZOYvgTXACVU1phve6HZq9zfjVi+zF3TqEGAV7WjXvNt5uK9TemF9mMwXz8jMVrenZSLiJGBZZv634v4HgHdm5tmj6q0GVhd3j+psKyWpL+zKzGnNVJze7pZMUoxR9qqky8yrgKsAIqJ7k1CSulfTR6C6/VDVEHBw3f25wNaK2iJJovuD4x5gfkQcGhF7AyuAWypukyRNaV19qCozX4qIs4F1wDTg6szc1GCyl+n+QJSkbvNQsxW7unNcktR9/GYuSSrF4JAklWJwSJJK6erO8UYiYi5wP/C6CptxamZ+s8Ll97yIuAxYXNwdPgHp5boqzZQ1qvMfgRmTbmzzxjoHqZPuycxFFbehLSJiOXA98JoOL/ohYHlmPtjh5Xadnu4cj4jbgP9SdTv6WAL/r43zn0mPf3mR+swPM/N3GlXq9eDYAPx61e2QpD6yMzNfO16FXv+292TVDZgKMrMth128PIzUlfZvVKHX9zgOodbHMW46atJeatN8e/2Li9SXGn1Z7NkVt/itjjOopWOn0u8x4EXgkA4tr1v07OekgU59bn6QmcvauYCI2ETtN2ukyfr7RhV6fY/jTqBhR06L/RFwHvB6OjtKB2BXG+e9pysRZ93joz8sEy0LYElm/u3EmlpeRMwBvgkMUHvf2j3qae8OLKORX7Z5/p3+/EM1r2mnN5KPUc325d+A0zLzW40q9npwfAn4VNXt6IBOvElVb+QkVWAifZi9fgjiN6tuQIf040Y9ae8eVL2mfpxGLdHuLzn9uC5UKiKuyszVjWvWTdPLexxVcCRQWzUcBjgRvmdTQjvf4ykXVn3ZOR4R7weuq2jxoz+g7T6OXPWx8gQ+S+23329o5Ywj4jHgjXVF+7uRb6kXmVw/VKM6Z2Xm11vQztIi4k+Bd40qHr6E0q493J9M2TbgL9t9lYiIuIBaP2rDIbFt8gy19X1cPbnHERFnAldW3Y5CO8+sHvYreF2xdunUCvBSZu7drpkbuH2tk+/tn2Xm2Y0q9WRwVMEVsz+18uTGiHgUOLBV8yupJ48eqCttz8xZ41Xo6eCIiP8A3AfsU8Hih1+4HY1e5MkwsCR1Wl/2cdT5OtWEBrzS7/D6iOjU6CD1juFRY8PBf2dmvqddC/MLhlqo4fas14Oj05dV3pNePimpm0aM3J6ZLb/acYUb1fp+qXe3+QvGWM/xMWrryOgTOaPJsr145TL19XWq/BkDtV/D9aXXg2PKXuQwM1vSWV6cff9bYz1E5zvk391H35y7IZAP6vDyXujw8gC2Uxvd9e0Klt0yEbEVeFPV7Sg0/L2RXu/j+PfULnLYLXse0lTXrgtiDuuWkzk7ueHclZlVXN5lj3o6OIZFxK8AnwD+U1G0F7VvfPW/Bje6rJk6Y5W9E9i3hc1X5z2SmR27UGVEvJ3aIA6pJzTqHO/p4IiIfYCLgXOqbksbdcMhj3ZLOv88PdO4dx2QmU8DRMTJwI0Vt6fXXQZ8PEuEQa/3cdwMLK26EZq0Kja0VSzz5cZVJqyKPqkq7AJ+Dfhxcf/3KmxLP0jgU2VCA3p/j2MjcESHF1vFt+PhDU63HN/tVUOZeXBEXAR8surGdEg7+xwCP5P9oj4IHs/McQdW9Poex/+l88FRxTfVV62c7fo5V4CI+F3gL6nuejntMrfiUVuPAAd3eJnTad9ViKvaw0l2Hzrc7g75qs4V66T665A1fL69vsfxM+CwqttBew5BdM03uXaGVCd0yRDflzNzehvP5ejp90jVmcj63evB8e+Av6Ga8c/tHh5Xxbe5sX4jY2dmHlBBW1omIp6nur3rF4CLMvNL7VxIl4SjetO6sj9t3NPBMSwi3gB8G/h12r+BqPoy553ys8zs9GHAlurSjWlbXtcufa7qUf0+HPe/UguMqTCapArZqjPUu03xG+QbqOBqtu049NeFwfF0O/ZUq3ievX6oth16PTj+HnhH1e3oUwnclJnvq7oh7VTBBSqfzcz9Wj3TiAjgWabWyanDG69OvIdV9Dl2euM8/KN038zMD41XsdeDYxA4qup29Jl/yMxuGHCgkiJiM7Cg6nao9zXay+r1wxBPV92APrQgIrL+VnWDtGcR8TcRsat4nwwNdUSv73G8BvgwMBP4TaDUyIAW6MSL9zjwrsz85w4sSz3GYFc79OUPOUXETqDlx4knoBOdZgcBD9UOYfMgsGj4Oj0S8DxTq19D7be+UYWe3uMYS0RMA34XuIkeDcYm7MrMrjlBUNWLiBOpXeyv6stv9/tl1XdQ+ymHYa266nZ92aHAG+j89iuBz2fm/2hUse+CY1hEnAlc2YlFdWAZr+IQQe1JRFwAfIne78NUNZ7JzHF/5bFvg6NdIuJeaicaVrVSPgAs9nCVqhIRHwM+C7y+6raoPfr6BMAqFOP+O/1t/1+Ao+0gVzeIiB34u+N9zeBog+JQwGfpbKfkvwJ3UQuRb2TmTzq4bOlVit/JfmOHFudhtw4yOFosIp4AZlfdDvs4VLXikNVXmBrXbptKGl5qyOAoqVvGzRscqlq3rAsV2Aj8LfBiXdmMUfcnWvZQcb/TRzR2ULt220PAn2bm349X2eAoqVtWFoNDVeuWdYHOnIg7lda3hnsc/XqeQzu9SPVj5X/ZuIo0ZezKzLZty7ooIDulYUja4VTefsA2On/lymHb8ExhdYcfVN2AwserbsBU4x5HkyLifGD4UsNPF7fpvPpM2dFlzdQZq+zrmXnpZNostUNE3AEcTe2L5/CZz1Wd0f1L4I6Klt2vdjaqYB9Hk6reXbVPQ92i6nVhDM9l5mvaNfOI+Dkwv13z7zK/AN6aDYLB4GhS1SuLwaFuUfW6MIa++qXKiFgBfBJ4c1E0/HrHqPuTKau//wjwmcxc23QbDY7mVL2yGBzqFlWvC2NoS3BU8OuQ3bCO78jMhpeS6ZuU7nf+uJK6yOjzEKpWxQa+HbducEBxRYBx2TneJL/xSzWZuXdE/BhYTDUbvPpLkSfQ8DLgE1G/FxMRlwH/ne7ZwLfTQY0qeKhKkvYgIv43cFLV7ei0vvwFQElqNw8J75l9HJKkUjxUJUkqxT0OqUMiYv+IWBsRV1fdFmky3OOQOiQiFgOPA4cCmzLz8YqbJE2IexxSCxTn13yz7v70iNgWEd8t7p8G/B/g29R+/GhdRBweEXtFxFcjYmNE3B8R90TEoZU8CalJjqqSWuPfgF+LiJmZ+RzwHmo/81vvhsw8u74gIlZSu7TEOzJzV0TMLeYldS33OKTWWQscX/y/Eri+iWkOAh7NzF0AmTmUmTva1D6pJQwOqXXWACsiYl/gHcDdox4/JSI21N1mAjcC7y3u/0lE/EanGy2VZXBILZKZ9wHzqO1tfH+MKjdk5sK623OZOQS8jdrVUHcBt0fEuzvWaGkC7OOQWusW4DJgCTCrmQky8wVqh7nWRsTjwInA7e1qoDRZBofUWlcDz2Tm/RGxpFHliDgSeCwzt0bEXtQOcd3X5jZKk2JwSC1UHHr6n3t4+JSI+K26+x8BXgt8PSL2Kcp+CvyvNjZRmjRPAJQklWLnuCSpFINDklSKwSFJKsXgkCSVYnBIkkoxOCRJpRgckqRSDA5JUin/H0xnvvDi1heBAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.plot.bar(x='MÊS', y='VENCIMENTOS')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. Criamos um groupby para somar a coluna VENCIMENTOS e agrupar por mes. <br>\n",
    "2. Define que o retorno sera um DataFrame. <br>\n",
    "3. Criou um novo dataframe dfSumMes <br> "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfSumMes = pd.DataFrame( df.groupby('MÊS').VENCIMENTOS.sum().reset_index() )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. Cria uma coluna chama mes_num\n",
    "2. Utiliza uma biblioteca chama numpy, usamos uma funcao where (NADA MAIS QUE UM IF)\n",
    "3. Lista todos os meses e atribui um valor a eles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfSumMes['mes_num'] = np.where(dfSumMes['MÊS'] == 'Janeiro', 1,\n",
    "                             np.where(dfSumMes['MÊS'] == 'Fevereiro', 2,\n",
    "                             np.where(dfSumMes['MÊS'] == 'Março', 3,\n",
    "                             np.where(dfSumMes['MÊS'] == 'Abril', 4,\n",
    "                             np.where(dfSumMes['MÊS'] == 'Maio', 5,\n",
    "                             np.where(dfSumMes['MÊS'] == 'Junho', 6,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Julho', 7,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Agosto', 8,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Setembro', 9,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Outubro', 10,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Novembro', 11,\n",
    "                            np.where(dfSumMes['MÊS'] == 'Dezembro', 12,0))))))))))))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Estamos ordenando o df pela coluna mes_num, o inplace serve para salvar."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfSumMes.sort_values(by=['mes_num'], inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "plotamos um grafico de barras"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f575ab0a390>"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA4YAAAFnCAYAAAD69FcDAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nOzde7gdZXn///eHgIIKghiVEhSqUU5qxIBYe6BQjlZBBSGKoNDir8JXpJUK1X5FEbUe+WqVFgsCag3UQ0EFkXKo1SoSBIGASESKEYRwEKkiCty/P2Z2WNlZyd47wJ4V5v26rrn2mntO957srLXumWeeJ1WFJEmSJKm/1ug6AUmSJElStywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecmXRgmmZHksiRfbec3S3JxkuuSnJ7kMW38se38onb5pgP7OLqNX5tk14H4bm1sUZKjBuJTPoYkSZIkaWoy2XEMk/w1MBdYr6r+PMkZwJeqan6SfwJ+UFUnJHkT8Lyq+v+S7Ae8oqr2TbIl8HlgO+D3gP8Ant3u/kfAzsBi4BJgXlVdPdVjrCz/Jz/5ybXppptO5dxIkiRJ0qPGpZdeeltVzRy2bM3J7CDJLOClwHHAXycJsCPwmnaVU4FjgBOAPdvXAF8A/rFdf09gflXdC/wkySKaIhFgUVVd3x5rPrBnkmumeoxaSZW76aabsmDBgsn8upIkSZL0qJPkf1a0bLJNSY8H/hZ4oJ3fEPhFVd3Xzi8GNm5fbwz8FKBdfle7/tL4uG1WFF+VY0iSJEmSpmjCwjDJnwO3VtWlg+Ehq9YEyx6u+ETHXyrJIUkWJFmwZMmSIZtIkiRJkiZzx/AlwMuT3ADMp2neeTywfpKxpqizgJva14uBTQDa5U8E7hiMj9tmRfHbVuEYy6iqE6tqblXNnTlzaFNaSZIkSeq9CZ8xrKqjgaMBkuwAvLWqXpvk34C9aYrFA4Ez203Oaue/0y6/oKoqyVnAvyb5CE3nM7OB79Hc/ZudZDPgZ8B+wGvabS6cyjGm+sv/7ne/Y/HixfzmN7+Z6qbqwNprr82sWbNYa621uk5FkiRJelSZVOczK/A2YH6S9wCXASe18ZOAz7Sdy9xBU+hRVQvbXkavBu4DDq2q+wGSHAacC8wATq6qhatyjKlavHgx6667LptuuilN/zgaVVXF7bffzuLFi9lss826TkeSJEl6VJn0cBWru7lz59b4XkmvueYaNt98c4vC1URV8cMf/pAtttii61QkSZKk1U6SS6tq7rBlkx7g/tHKonD14b+VJEmS9MjofWHYpR122IFzzz13mdjxxx/PHnvswTrrrMOcOXOWTqeddhrQjMf4qle9aun6X/jCF3j961+/dP6cc85h7ty5bLHFFmy++ea89a1vBeCYY47hQx/6EACvf/3redzjHsfdd9+9dLvDDz+cJNx2220AzJgxY5njv//971+a89y5D15kWLBgwdLfY2zdJzzhCTznOc9hzpw5HHDAAQB861vfYrvttmPzzTdn880358QTT1y6j2uvvZYddtiBOXPmsMUWW3DIIYc85HMrSZIkafIeyjOGjzqbHvW1h3V/N7z/pStdPm/ePObPn8+uu+66NDZ//nw++MEPcuONN3L55ZcP3W7BggUsXLiQrbbaapn4VVddxWGHHcbXvvY1Nt98c+67775lCrBBz3rWszjzzDPZf//9eeCBB7jwwgvZeOONly5fZ511Vnj8W2+9lXPOOYfdd999aWzXXXdd+nvssMMOfOhDH1paQP785z/nNa95Df/+7//ONttsw2233cauu+7KxhtvzEtf+lLe/OY3c8QRR7DnnnsCcOWVV670vEmSJEl6eHnHsEN77703X/3qV7n33nsBuOGGG7jpppuYNWvWSrd761vfynvf+97l4h/4wAd4+9vfzuabbw7AmmuuyZve9Kah+5g3bx6nn346ABdddBEveclLWHPNyV0nOPLII3nPe94zqXUBPvGJT/D617+ebbbZBoAnP/nJfOADH1h6F/Lmm29e5nd+7nOfO+l9S5IkSXrovGPYoQ033JDtttuOr3/96+y5557Mnz+ffffdlyT8+Mc/Zs6cOUvX/fjHP84f/dEfAfDqV7+aT37ykyxatGiZ/V111VX8zd/8zaSOPXv2bM4880zuvPNOPv/5z7P//vtzzjnnLF1+zz33LHP8o48+mn333ReAF7/4xXz5y1/mwgsvZN11153wWAsXLuTAAw9cJjZ37lwWLmw6nz3iiCPYcccd+YM/+AN22WUX3vCGN7D++utP6veQJEmSHikPd4vCh2Ki1ogPlXcMOzbWnBSaZqTz5s0D4JnPfCaXX3750mmsKITm+b8jjzyS973vfQ/p2K985SuZP38+F1988TL7hwebko5NY0XhmHe84x2TvmtYVUM7jhmLveENb+Caa65hn3324aKLLmL77bdfehdVkiRJ0iPPwrBje+21F+effz7f//73ueeee5Y2t5zI6173Or75zW9y4403Lo1ttdVWXHrppZM+9n777cff//3fs/POO7PGGlP7U9hxxx35zW9+w3e/+90J191qq60YP1TIpZdeypZbbrl0/vd+7/c46KCDOPPMM1lzzTW56qqrppSPJEmSpFVnYdixJzzhCeywww4cdNBBS+8WTsZaa63FEUccwfHHH780duSRR/Le976XH/3oRwA88MADfOQjH1nhPp7+9Kdz3HHHrfA5xIm8/e1v5wMf+MCE6x166KGccsopSzuzuf3223nb297G3/7t3wLw9a9/nd/97ndA01HN7bffvkxHOJIkSZIeWT5jOALmzZu3tFnnmPHPGB500EG8+c1vXma7gw8+eJnmnM973vM4/vjjmTdvHr/+9a9JwktfuvK2yG984xuHxsc/Y7jbbrst7SxmzB577MHMmTMn/P022mgjPvvZz/KXf/mX3H333VQVb3nLW3jZy14GwDe+8Q0OP/xw1l57bQA++MEP8rSnPW3C/UqSJEl6eKSqus5hWsydO7fGN2e85ppr2GKLLTrKSKvCfzNJkiRNl0db5zNJLq2qucOWecdQkjSSHm0fxpIkjTKfMZQkSZKknrMwlCRJkqSe631h2JdnLB8N/LeSJEmSHhm9LgzXXnttbr/9dguO1UBVcfvtty/tuVSSJEnSw6fXnc/MmjWLxYsXs2TJkq5T0SSsvfbazJo1q+s0JEmSpEedXheGa621FptttlnXaUiSJElSp3rdlFSSJEmSZGEoSZIkSb1nYShJkiRJPWdhKEmSJEk91+vOZyRJktQvmx71ta5TWOqG97+06xSkpbxjKEmSJEk9Z2EoSZIkST1nYShJkiRJPTdhYZhk7STfS/KDJAuTvKuNn5LkJ0kub6c5bTxJPpZkUZIrkmwzsK8Dk1zXTgcOxF+Y5Mp2m48lSRt/UpLz2vXPS7LBRMeQJEmSJE3NZO4Y3gvsWFXPB+YAuyXZvl12ZFXNaafL29juwOx2OgQ4AZoiD3gn8CJgO+CdY4Veu84hA9vt1saPAs6vqtnA+e38Co8hSZIkSZq6CQvDavxvO7tWO9VKNtkTOK3d7rvA+kk2AnYFzquqO6rqTuA8miJzI2C9qvpOVRVwGrDXwL5ObV+fOi4+7BiSJEmSpCma1DOGSWYkuRy4laa4u7hddFzblPOjSR7bxjYGfjqw+eI2trL44iFxgKdW1c0A7c+nTHAMSZIkSdIUTaowrKr7q2oOMAvYLsnWwNHA5sC2wJOAt7WrZ9guViG+MpPaJskhSRYkWbBkyZIJdilJkiRJ/TSlXkmr6hfARcBuVXVz25TzXuDTNM8NQnP3bpOBzWYBN00QnzUkDnDLWBPR9uetExxjfL4nVtXcqpo7c+bMqfyqkiRJktQbk+mVdGaS9dvX6wB/BvxwoGALzbN/V7WbnAUc0PYcuj1wV9sM9FxglyQbtJ3O7AKc2y67O8n27b4OAM4c2NdY76UHjosPO4YkSZIkaYrWnMQ6GwGnJplBU0ieUVVfTXJBkpk0zTovB/6/dv2zgT2ARcCvgTcAVNUdSY4FLmnXe3dV3dG+/ivgFGAd4Jx2Ang/cEaSg4EbgX1WdgxJkiRJ0tRNWBhW1RXAC4bEd1zB+gUcuoJlJwMnD4kvALYeEr8d2Gkqx5AkSZIkTc2UnjGUJEmSJD36WBhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz01YGCZZO8n3kvwgycIk72rjmyW5OMl1SU5P8pg2/th2flG7fNOBfR3dxq9NsutAfLc2tijJUQPxKR9DkiRJkjQ1k7ljeC+wY1U9H5gD7JZke+AfgI9W1WzgTuDgdv2DgTur6lnAR9v1SLIlsB+wFbAb8MkkM5LMAD4B7A5sCcxr12Wqx5AkSZIkTd2EhWE1/redXaudCtgR+EIbPxXYq329ZztPu3ynJGnj86vq3qr6CbAI2K6dFlXV9VX1W2A+sGe7zVSPIUmSJEmaokk9Y9je2bscuBU4D/gx8Iuquq9dZTGwcft6Y+CnAO3yu4ANB+PjtllRfMNVOIYkSZIkaYomVRhW1f1VNQeYRXOHb4thq7U/h925q4cxvrJjLCPJIUkWJFmwZMmSIZtIkiRJkqbUK2lV/QK4CNgeWD/Jmu2iWcBN7evFwCYA7fInAncMxsdts6L4batwjPH5nlhVc6tq7syZM6fyq0qSJElSb0ymV9KZSdZvX68D/BlwDXAhsHe72oHAme3rs9p52uUXVFW18f3aHkU3A2YD3wMuAWa3PZA+hqaDmrPabaZ6DEmSJEnSFK058SpsBJza9h66BnBGVX01ydXA/CTvAS4DTmrXPwn4TJJFNHfx9gOoqoVJzgCuBu4DDq2q+wGSHAacC8wATq6qhe2+3jaVY0iSJEmSpm7CwrCqrgBeMCR+Pc3zhuPjvwH2WcG+jgOOGxI/Gzj74TiGJEmSJGlqJnPHUFqpTY/6WtcpLHXD+1/adQqSJEnSamdKnc9IkiRJkh59vGMoSdJqxFYakqRHgncMJUmSJKnnLAwlSZIkqecsDCVJkiSp53zGUHqE+ByQJEmSVhcWhpKmlQWzJEnS6LEwlCRJqz0vOknSQ2NhKEkjwC+1kiSpS3Y+I0mSJEk9Z2EoSZIkST1nYShJkiRJPeczhlPkc0CSJGl14fcWTZZ/K/KOoSRJkiT1nIWhJEmSJPWchaEkSZIk9ZyFoSRJkiT1nIWhJEmSJPWchaEkSZIk9ZyFoSRJkiT1nIWhJEmSJPWchaEkSZIk9ZyFoSRJkiT1nIWhJEmSJPXchIVhkk2SXJjkmiQLkxzexo9J8rMkl7fTHgPbHJ1kUZJrk+w6EN+tjS1KctRAfLMkFye5LsnpSR7Txh/bzi9ql2860TEkSZIkSVMzmTuG9wF/U1VbANsDhybZsl320aqa005nA7TL9gO2AnYDPplkRpIZwCeA3YEtgXkD+/mHdl+zgTuBg9v4wcCdVfUs4KPteis8xiqfBUmSJEnqsQkLw6q6uaq+376+G7gG2Hglm+wJzK+qe6vqJ8AiYLt2WlRV11fVb4H5wJ5JAuwIfKHd/lRgr4F9ndq+/gKwU7v+io4hSZIkSZqiKT1j2DblfAFwcRs6LMkVSU5OskEb2xj46cBmi9vYiuIbAr+oqvvGxZfZV7v8rnb9Fe1LkiRJkjRFky4MkzwB+CLwlqr6JXAC8ExgDnAz8OGxVYdsXqsQX5V9jc/5kCQLkixYsmTJkE0kSZIkSZMqDJOsRVMUfq6qvgRQVbdU1f1V9QDwKR5syrkY2GRg81nATSuJ3wasn2TNcfFl9tUufyJwx0r2tYyqOrGq5lbV3JkzZ07mV5UkSZKk3plMr6QBTgKuqaqPDMQ3GljtFcBV7euzgP3aHkU3A2YD3wMuAWa3PZA+hqbzmLOqqoALgb3b7Q8EzhzY14Ht672BC9r1V3QMSZIkSdIUrTnxKrwEeB1wZZLL29jf0fQqOoemCecNwBsBqmphkjOAq2l6ND20qu4HSHIYcC4wAzi5qha2+3sbMD/Je4DLaApR2p+fSbKI5k7hfhMdQ5IkSZI0NRMWhlX1LYY/03f2SrY5DjhuSPzsYdtV1fUM6VW0qn4D7DOVY0iSJEmSpmZKvZJKkiRJkh59LAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5ywMJUmSJKnnLAwlSZIkqecsDCVJkiSp5yYsDJNskuTCJNckWZjk8Db+pCTnJbmu/blBG0+SjyVZlOSKJNsM7OvAdv3rkhw4EH9hkivbbT6WJKt6DEmSJEnS1EzmjuF9wN9U1RbA9sChSbYEjgLOr6rZwPntPMDuwOx2OgQ4AZoiD3gn8CJgO+CdY4Veu84hA9vt1sandAxJkiRJ0tRNWBhW1c1V9f329d3ANcDGwJ7Aqe1qpwJ7ta/3BE6rxneB9ZNsBOwKnFdVd1TVncB5wG7tsvWq6jtVVcBp4/Y1lWNIkiRJkqZoSs8YJtkUeAFwMfDUqroZmuIReEq72sbATwc2W9zGVhZfPCTOKhxDkiRJkjRFky4MkzwB+CLwlqr65cpWHRKrVYivNJ3JbJPkkCQLkixYsmTJBLuUJEmSpH6aVGGYZC2aovBzVfWlNnzLWPPN9uetbXwxsMnA5rOAmyaIzxoSX5VjLKOqTqyquVU1d+bMmZP5VSVJkiSpdybTK2mAk4BrquojA4vOAsZ6Fj0QOHMgfkDbc+j2wF1tM9BzgV2SbNB2OrMLcG677O4k27fHOmDcvqZyDEmSJEnSFK05iXVeArwOuDLJ5W3s74D3A2ckORi4EdinXXY2sAewCPg18AaAqrojybHAJe16766qO9rXfwWcAqwDnNNOTPUYkiRJkqSpm7AwrKpvMfyZPoCdhqxfwKEr2NfJwMlD4guArYfEb5/qMSRJkiRJUzOlXkklSZIkSY8+FoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzFoaSJEmS1HMWhpIkSZLUcxaGkiRJktRzExaGSU5OcmuSqwZixyT5WZLL22mPgWVHJ1mU5Nokuw7Ed2tji5IcNRDfLMnFSa5LcnqSx7Txx7bzi9rlm050DEmSJEnS1E3mjuEpwG5D4h+tqjntdDZAki2B/YCt2m0+mWRGkhnAJ4DdgS2Bee26AP/Q7ms2cCdwcBs/GLizqp4FfLRdb4XHmNqvLUmSJEkaM2FhWFXfBO6Y5P72BOZX1b1V9RNgEbBdOy2qquur6rfAfGDPJAF2BL7Qbn8qsNfAvk5tX38B2Kldf0XHkCRJkiStgofyjOFhSa5om5pu0MY2Bn46sM7iNrai+IbAL6rqvnHxZfbVLr+rXX9F+5IkSZIkrYJVLQxPAJ4JzAFuBj7cxjNk3VqF+KrsazlJDkmyIMmCJUuWDFtFkiRJknpvlQrDqrqlqu6vqgeAT/FgU87FwCYDq84CblpJ/DZg/SRrjosvs692+RNpmrSuaF/D8jyxquZW1dyZM2euyq8qSZIkSY96q1QYJtloYPYVwFiPpWcB+7U9im4GzAa+B1wCzG57IH0MTecxZ1VVARcCe7fbHwicObCvA9vXewMXtOuv6BiSJEmSpFWw5kQrJPk8sAPw5CSLgXcCOySZQ9OE8wbgjQBVtTDJGcDVwH3AoVV1f7ufw4BzgRnAyVW1sD3E24D5Sd4DXAac1MZPAj6TZBHNncL9JjqGJEmSJGnqJiwMq2rekPBJQ2Jj6x8HHDckfjZw9pD49QzpVbSqfgPsM5VjSJIkSZKm7qH0SipJkiRJehSwMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSem7AwTHJykluTXDUQe1KS85Jc1/7coI0nyceSLEpyRZJtBrY5sF3/uiQHDsRfmOTKdpuPJcmqHkOSJEmSNHWTuWN4CrDbuNhRwPlVNRs4v50H2B2Y3U6HACdAU+QB7wReBGwHvHOs0GvXOWRgu91W5RiSJEmSpFUzYWFYVd8E7hgX3hM4tX19KrDXQPy0anwXWD/JRsCuwHlVdUdV3QmcB+zWLluvqr5TVQWcNm5fUzmGJEmSJGkVrOozhk+tqpsB2p9PaeMbAz8dWG9xG1tZfPGQ+KocQ5IkSZK0Ch7uzmcyJFarEF+VYyy/YnJIkgVJFixZsmSC3UqSJElSP61qYXjLWPPN9uetbXwxsMnAerOAmyaIzxoSX5VjLKeqTqyquVU1d+bMmVP6BSVJkiSpL1a1MDwLGOtZ9EDgzIH4AW3PodsDd7XNQM8FdkmyQdvpzC7Aue2yu5Ns3/ZGesC4fU3lGJIkSZKkVbDmRCsk+TywA/DkJItpehd9P3BGkoOBG4F92tXPBvYAFgG/Bt4AUFV3JDkWuKRd791VNdahzV/R9Hy6DnBOOzHVY0iSJEmSVs2EhWFVzVvBop2GrFvAoSvYz8nAyUPiC4Cth8Rvn+oxJEmSJElT93B3PiNJkiRJWs1YGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs9ZGEqSJElSz1kYSpIkSVLPWRhKkiRJUs89pMIwyQ1JrkxyeZIFbexJSc5Lcl37c4M2niQfS7IoyRVJthnYz4Ht+tclOXAg/sJ2/4vabbOyY0iSJEmSpu7huGP4p1U1p6rmtvNHAedX1Wzg/HYeYHdgdjsdApwATZEHvBN4EbAd8M6BQu+Edt2x7Xab4BiSJEmSpCl6JJqS7gmc2r4+FdhrIH5aNb4LrJ9kI2BX4LyquqOq7gTOA3Zrl61XVd+pqgJOG7evYceQJEmSJE3RQy0MC/hGkkuTHNLGnlpVNwO0P5/SxjcGfjqw7eI2trL44iHxlR1DkiRJkjRFaz7E7V9SVTcleQpwXpIfrmTdDInVKsQnrS1WDwF4+tOfPpVNJUmSJKk3HtIdw6q6qf15K/BlmmcEb2mbgdL+vLVdfTGwycDms4CbJojPGhJnJccYn9+JVTW3qubOnDlzVX9NSZIkSXpUW+XCMMnjk6w79hrYBbgKOAsY61n0QODM9vVZwAFt76TbA3e1zUDPBXZJskHb6cwuwLntsruTbN/2RnrAuH0NO4YkSZIkaYoeSlPSpwJfbkeQWBP416r6epJLgDOSHAzcCOzTrn82sAewCPg18AaAqrojybHAJe16766qO9rXfwWcAqwDnNNOAO9fwTEkSZIkSVO0yoVhVV0PPH9I/HZgpyHxAg5dwb5OBk4eEl8AbD3ZY0iSJEmSpu6RGK5CkiRJkrQasTCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeW60LwyS7Jbk2yaIkR3WdjyRJkiStjlbbwjDJDOATwO7AlsC8JFt2m5UkSZIkrX5W28IQ2A5YVFXXV9VvgfnAnh3nJEmSJEmrnVRV1zmskiR7A7tV1V+0868DXlRVhw2scwhwSDv7HODaaU90uCcDt3WdxAjyvAzneVme52Q4z8twnpfhPC/L85wM53kZzvMynOdleaN0Tp5RVTOHLVhzujN5GGVIbJkqt6pOBE6cnnQmL8mCqprbdR6jxvMynOdleZ6T4Twvw3lehvO8LM9zMpznZTjPy3Cel+WtLudkdW5KuhjYZGB+FnBTR7lIkiRJ0mprdS4MLwFmJ9ksyWOA/YCzOs5JkiRJklY7q21T0qq6L8lhwLnADODkqlrYcVqTNXLNW0eE52U4z8vyPCfDeV6G87wM53lZnudkOM/LcJ6X4Twvy1stzslq2/mMJEmSJOnhsTo3JZUkSZIkPQwsDCVJkiSp5ywMJUmSJKnnLAynQZJZSb6cZEmSW5J8McmsrvOS9OiRZN0kT+g6j1GQ5PlJDmun53edzyjwc0h6eCR5TJKt22mtrvORHk4WhtPj0zRDaWwEbAx8pY0JSPLyJB9qp5d1nc8oSLJWkjcn+UI7/Z8+fgAledLKpq7zGwVJnpvkMstAfSoAABeYSURBVOAq4OoklybZuuu8upLkcOBzwFPa6bNJ/k+3WY0EP4eGSPLEJB9NsqCdPpzkiV3nNQo8N8tLsgNwHfAJ4JPAj5L8cadJjQgvPg23un3HtVfSaZDk8qqaM1Gsj5K8D9iO5oscwDxgQVUd3V1W3UvyL8BawKlt6HXA/VX1F91lNf2S/AQoIEMWV1X9/jSnNHKS/Dfw9qq6sJ3fAXhvVf1Bp4l1JMkVwIur6lft/OOB71TV87rNrFt+Dg2X5Is0F1UG32ufX1Wv7C6r0eC5WV6SS4HXVNW17fyzgc9X1Qu7zax7Sc4D/hX4TBvaH3htVe3cXVbdWh2/46624xiuZm5Lsj/w+XZ+HnB7h/mMkpcCc6rqAYAkpwKXASP7n2aabFtVg03gLkjyg86y6UhVbdZ1DquBx48VhQBVdVFbDPVVgPsH5u9n+IWFvvFzaLhnVtWrBubfleTyzrIZLZ6b5a01VhQCVNWP+tiaZwVmVtVgK4RTkryls2xGw2r3HdempNPjIODVwM+Bm4G925ga6w+87nUzlQH3J3nm2EyS32fZL7u9kGTz9uc2w6au8xsR1yf5+ySbttM7gJ90nVSHPg1cnOSYJMcA3wVO6jalkeDn0HD3JPnDsZkkLwHu6TCfUeK5Wd6CJCcl2aGdPgVc2nVSI+K2JPsnmdFO++PFJ1jNvuPalPQRlmQG8Oaq+mjXuYyiJPOA9wMX0lzV/2Pg6Kqa32liHUuyE80X3OtpzsszgIOq6oJOE5tmSU6sqkOSXDhkcVXVjtOe1IhJsgHwLuAPaf5WvgkcU1V3dppYh5K8EHgJ7fmoqss6Tkkjqu2c6DQe/MJ2J3BgVV3RXVajwXOzvCSPBQ5l2ffbT1bVvZ0mNgKSPB34R+DFNI+A/DdweFX9T6eJdWh1/I5rYTgNklxUVTt0nceoSRJgFnAfsC3Nf5qLq+rnnSY2ItoPoOfQnJcf9vWDJ8kaNM+MfbvrXLR6aC/IPZWBxyWq6sbuMupekpnAXwKbsux56fVdwySbVdVPkqwHUFW/HIt1nVuX2vfdvavqjMFz03FanWrfV06tqv27zmXUeBNkeavrd1wLw2mQ5DiaK26nA78ai1fV9ztLakQkudSHtpeX5J3A/6uqX7TzGwCHVdWx3WbWjSTfqaoXd53HKElyfFW9JclXaK7OLqOqXt5BWp1reyB9J3ALDz5fWHY+k/8G/oum2dvSZulV9cXOkhoBSb5fVduMi/m5BCT5ZlXZ4+aAJOcCL6uq33ady6jxJsjyVsf3EjufmR5jvQO+eyBWQO+bwQHfTbJtVV3SdSIjZq+qetfYTFXdmeSgtuvnTapqjw5z68I3krwK+FJ5NWvMWM9vH+o0i9FzOPCcqvLZlmU9rqre1nUSo6J9fnkr4IlJBnvZXA9Yu5usRs55Sd7K8he17+gupc7dAHw7yVkse04+0llGo+PbSf4Rb4IMWu2+43rHUJ1KcjXwbOB/aN5IvLoPJLkSeOHYVckkawM/qKrnJLmsql7QbYbTK8ndwONp7nTcw4N/J+t1mphGTvs86s5VdV/XuYySJO8B/ruqzu46l1GQZE9gL+DlNOM7jrkbmF9V/91JYiOkHS5ovF4PE9S25lnO4IXcvrIvgOW133GfQ3NBYbX4jmth+AhKsn9VfTbJXw9b7hUmSPKMYfE+P6wMkORtNN0cn9KGDgS+VlUfSPL4sTHapCSzgfcBWzJwp6NvX94G3me3ovkg/hqw9Lncvr7fthdVxsYCfTzNOfkdXlwBIMmLq+o7Xeeh1Uv73GVV1d1d56LRtTp+x7Up6SNrbCyxdTvNYgQlWa99kN031SGq6h/acQv/jOYL3Hur6tx2WS+Lwra51x/SfMn9r6r6945TGhWfpnmm7qPAnwJvoJ/j9o29z97YTo9pp16rKj9/Vu4VSRbStET4OvB84C1V9dlu0+pe21LlTQy87wL/VFW/6TSxDiWZS/Oeu247fxdNj+G9H7IiyYY0n0Vjfy/fAt7d52b9VfU/7dBaY+fk26PetNY7hupEkq9W1Z+3TVXGrmaP6XtTlRnAuVX1Z13nMiqSfBJ4Fg8Ozr0v8OOqOrS7rEbD2MPtSa6sque2sf+qqj/qOjd1b6LxPkf9S8ojLcnlVTUnyStompYeAVxYVc/vOLXOJTmD5uLtWJE8D9igqvbpLqtuJbkCOLSq/qud/0Oa4SpGtmngdElyHs3wHWN/L68Fdujzd5kk/xfYB/hSG9oL+Leqek93Wa2cdwynQZJnAycAT62qrZM8D3j5KP9hPNKq6s/bn5t1ncuoqar7k/w6yROr6q6u8xkRfwJsPdbxTJJTgSu7TWlk/KbtWv66JIcBPwOe0nFOnWnfb9/K8sMy9PU5lw+vZJmdoMFa7c89gM9X1R1NL/Oi6cRpsEC+sG3J0md3jxWFAFX1rba5tuBJ43pOf0+SvTrLZjTMA14wdpc9yfuB7wMj+/3fwnB6fAo4EvhngKq6Ism/MsJ/GNOlHefltcBmVXVsO0Dq06rqex2n1rXfAFe2V+AGe/d6c3cpdepa4Ok0nRQBbAL0dpDlcd4CPA54M3AszRf9AzvNqFv/BvwT8C8MDMvQV1X1p13nMOK+kuSHNE1J39SO99jbppLjXJZk+6r6LkCSFwG9HE924M7795L8M03rlaJpvXJRV3mNmAuT7Aec0c7vTfOsd5/dQPPs/9h7ymOBH3eWzSTYlHQaJLmkqrYd7E1yrPlK17l1LckJwAPAjlW1RTte3zeqatuOU+tUkqFf7Kvq1OnOpUsDY/Q9kWaA2LELBtsC3+lzExUNtzqOGzUdkhwwLF5Vp013LqOm/dz5Zdta43HAeqM+CPUjqe0Vu2jupj6H5pldaC7OXV1VW3eVW1dW0OPmmL73vDm+g6sH2kVrAP/bxw6uknyc5pw8neb7ynnt/M7At6pqvw7TWynvGE6P25I8k3YQ6iR7Azd3m9LIeFFVbZPkMlg6Xp8dRvSsAFyJYWP0heZB7nnTnMtIacfRWqG+DnBPcwfoTcCXWbZX0j6PvQbNl5MxawM70TRp6nVhmGQt4HXAH7dNSP+T5o5zn/151wmMGu+8r5gdXA21oP15Kc1n0ZiLpj+VqfGO4TRI8vvAiTQD3d8J/ATYv6pu6DKvUZDkYprzcklbIM6kuWPYq3H6xnMIguUlmQO8Bng1zf+hL1XVx7vNqjtJlgA/pWnSdDHjeiKtqv/sIq+uOfba5CR5IvCZHl9AACDJv9DcGRu7GPc64P6q+ovushod7d3UTVj2ed3edljUdiaynKp693TnMoraPjQ2Zdm/ly+tcAONHO8YToOquh74sySPB9Zw3JtlfIzmaspTkhxH0yb9Hd2mNBIcgoClHYnsR3N38HbgdJoLWl69hafRNEuZR1Mwf42m84yFnWbVMTu0mrRfA7O7TmIEbDuug5UL7GClkeRY4PU0z0SN3UXoe4dFg8NFrU1zd/WajnIZKUlOBp4HLOTB5qTFgz1y9k6SP6d59v8ZNDXXyI8f6x3DaZDkscCrWP4qileYgCSb0zRrCnB+VfX+TdYhCBpJHqAZO+vgqlrUxq737s+y2veYecAHacaN6vOdVJ+lG2LgeV2AGTStEc6oqrd1l1X3knwf2KeqftzO/z7whapa6TAffZDkWuC5VfXbrnMZVe1771lVtWvXuXQtydVVtWXXeYySJIuAVwJX1mpScHnHcHqcCdxF09b43gnW7Y22i/0r2gfZf9h1PiPGIQgar6K5Y3hhkq8D8+nhndMVab+UvJSmKNyU5g58b6/OtnyWbrgP8WBheB/wP1X1sw7zGRVH0ry/XE/z3vIMmhYagquA9YFbu05khD0O8EJl4ztJtqyqq7tOZIT8FLhqdSkKwTuG0yLJVX3sxWsyknwOOLqqbpxw5R5Jsi1N85T1aZohPBH4wFi34X3TNsPei6YA2pHmeaAvV9U3Ok2sQ+1YjlsD5wDzq+qqjlMaSX1/lm5cj4GDiuZC5Y+Bt1fV+dOd26hoL7A8h+Yc/bCqvIALJJlLc2H7KpbtyKmX/5dgmR5bobnzPhM4ts+tNMYk+WPgK8DPaf5exppNPq/TxDrUfpc7lqZTq8H/Qx/pLKkJWBhOgyQnAh+vKgfkHifJBTw4DMHgeH29/eDRyiV5ErAPsG/Puwh/gAf/zwy+kY/8MwzTqe118oqq2qLrXEZNkhk0Fxc+19eLl0leOSR8F03Tr17fKUuykGb85St58Jmx3nZsBZDkGQOz9wG3VNV9XeUzStpmk3/N8n8v/7PCjR7lknwD+F+WPyfv6iypCVgYToMkVwPPoulJ0asoA5L8ybB4Xz94HIJAemh8lm7qkryxqv656zy6kORrwIuBC2g+m3cAvgs8m+Z53c90l123kvxnVQ39jO6rJJ+pqtdNFOujJBf0+WLtMEkWVNXcrvOYCp8xnB67d53AqKqq/2yvwM2uqv9oBxee0XVeHXoxKxmCQNKEfJZuivpaFLYeALaoqlsAkjwVOAF4EfBNoLeFIXBpkvcBZ7FsM7jeDlcBbDU4k2RN4IUd5TJqfpjkX2makw7+vfT5uff/SLLL6vTYi4XhNBi7jZ7kKQyMSSdI8pfAIcCTgGcCG9MMLrxTl3l1yCEIpFWwsmfpkvgsnVZk07GisHUr8OyquiPJ77pKakSMjSe8/UCsl8NVJDka+DtgnSS/5MH3md/SjFMtWIemINxlINbr4SqAQ4G/TfJbmr+VkX/Uw6ak0yDJy4EPA79H86HzDOCaqtpqpRv2QJLLge2Ai8cGtR8coqHPHIJAenj4LJ1WJMkngacD/9aGXgUspumt9KuOmapBSd5XVUd3nYf0SFmj6wR64liaK24/agdf3gn4drcpjYx7B8dIaptl9PpqRZLHth0ifJbmapNDEEgPQVXdX1U/ALy4ovEOBT4NzGmn79Fc0f9V34vCJE9NclKSc9r5LZMc3HVeHTsnyR+Pn7pOahQkeXaS85Nc1c4/L8k7us6rS2nsn+Tv2/lNkmzXdV4rY2E4PX5XVbcDayRZo6oupPkAEvxnkrHmGTvTXLX9Ssc5daYdguC/gW2Ad1XVtlV1rM9ISQ9dz5+l0xDt+GI/Bn4HvILmwu01nSY1Ok4BzqVp7QTwI+AtnWUzGo4cmP6e5vvKMV0mNEI+BRxN83+JqrqCZhziPvskTd8Rr2nn/xf4RHfpTMxnDKfHL5I8Afgv4HNJbqXpFEFwFHAwTVe+bwTOBv6l04y69TqaIQieDbw5Wfq41Mi3S5ek1UWSZ9N8aZ0H3A6cTvN4Ta/vEo7z5Ko6o32+jqq6L8n9XSfVpap62eB8kk2AD3SUzqh5XFV9b+B7C/hd90VVtU2SywCq6s4kj+k6qZWxMJweLwd+AxwO7A+sB4zsGCbTbE/gtKr6VNeJjIKq8i6+JD3yfkhzsfZlVbUIIMkR3aY0cn6VZEPaxzuSbE8zxqMetJjm+WXBbUmeyYN/L3sDN3ebUud+1z7jPnZOZjIwnuEosjB8BA30krdMuP35f5PYS15TNB+f5JvAfOBcB4uVJD3CXkVzx/DCJF+n+fxxeKBl/TXNUBXPTPJtYCawT7cpdSvJx3nwe90aND23/qC7jEbKoTQ9tG6e5Gc0Y3e/ttuUOvcx4MvAU5IcB+wNjPRzl/ZK2hF7yXtQkrVoxnrcF/hD4Lyq+otus5IkPdoleTywF02T0h2BU4Evr07jjj1S2p6x7weeQ1M0XwusUVX3rnTDR7Ekf0Uz1nLR3D39SVXZmSDN99qqur/9P7VGVd3ddU6jIMnmNM8uBzi/qkb6GWYLw44leaMdIiwtDncD3gD8UVXN7DglSVKPJHkSzR2xfauqd2P1jZfk+1W1zUSxPmh7TH8vcBBwI82X/E2Ak2lafvV9zEuS3Ah8neZ53QvKAoMkJwEfr6rLB2LHVNUx3WW1chaG6lSS3Wia8/wpcBHNG8o3bE4qSdL0S/I0YGOaIZNew4NNbNcD/qmqNu8qt64k+SiwLnDE2J2wJOsBHwLuqarDu8xvFCRZB3gZzXe6bYCvAvOr6ludJtahJIuB24CPVNVpbWykL65YGKpTSebTPNtxTp+bp0iSNAqSHAi8HpgLLBhY9Evg1Krq3bi6Sa4Dnj3+Llj7WNAPq2p2N5mNpiQbAP8PeG1Vzeg6n64k+T6wA/A5mjvNhwOXVNULusxrZSwM1bkkzwBmV9V/tFec1rRtuiRJ3Unyqqr6Ytd5jIIkP6qqZ091Wd8k+ROa/iJ2By4BTu/z31CSy8aKwCTHADsDG1XV73ea2ErYNb46leQvgS8AY89ZzgL+vbuMJEkS8O0kJyU5ByDJlkkO7jqpjlyd5IDxwST70wx90ntJfgK8hWYYmK2r6tV9LgpbZ429aJ8rfB9wQ1fJTIZ3DNWpJJcD2wEXD1xVubKqntttZpIk9VdbEH6apnOV57cdsFzWx8/nJBsDXwLuAS6l6ZV0W2Ad4BVV9bMO0xsJSdarql92nceoGdcq7nHAjFFuFecdQ3Xt3qr67dhM+8Hj1QpJkrr15Ko6g3ZA7rZTuPu7TakbVfWzqnoR8G6aOz43Au+uqu0sCpdaL8mXk9ya5JYkX0wyq+ukujSkVdzGjHirOAe4V9f+M8nfAesk2Rl4E/CVjnOSJKnvfpVkQ9qLtUm2pxm7r7eq6gLggq7zGFGfBv6VZsgXgP3b2M6dZdS9Q2lbxQFU1XVJntJtSivnHUN17ShgCXAl8EbgbOAdnWYkSZL+muYZqWcm+TZwGvB/uk1JI2xmVX26qu5rp1OAvo9Jvdq1irMwVCeSPB2gqh6oqk9V1T5VtXf7eqT/00iS9GiVZNskT6uq7wN/AvwdcC/wDWBxp8lplN2WZP8kM9ppf+D2rpPq2PhWcf/GiLeKszBUV5a2sU7S916rJEkaFf8MjN3l+APg7cAngDuBE7tKSiPvIODVwM+Bm4G921ifrXat4uyVVJ0YN7bL0teSJKk7SX5QVc9vX38CWNJ2tU+Sy6tqTpf5SauTJDMBqmpJ17lMhp3PqCu1gteSJKk7M5Ks2fZCuhNwyMAyvzdqGUn+70oWV1UdO23JjIgkAd4JHAakDd0PfLyq3t1pchPwP7i68vwkv6T5D7NO+5p2vqpqve5SkySptz5P82zUbTTj9v0XQJJn0fNeSTXUr4bEHg8cDGwI9K4wBN4CvATYtqp+ApDk94ETkhxRVR/tNLuVsCmpJEmSlmqHptgI+EZV/aqNPRt4QtspjbScJOsCh9MUhWcAH66qW7vNavoluQzYuapuGxefSfN/amQfn/KOoSRJkpaqqu8Oif2oi1w0+pI8iWZ4k9cCpwLbVNWd3WbVqbXGF4XQPGeYZK0uEposC0NJkiRJU5bkg8AraXqsfW5V/W/HKY2C367iss7ZlFSSJEnSlCV5gGacy/tYtjPB3vYZ0XY0M+zZywBrV9XI3jW0MJQkSZKknnOAe0mSpkGSdZOck+TkrnORJGk87xhKkjQN2p4ebwE2AxZW1S0dpyRJ0lLeMZQk6SFKUkk+MzC/ZpIlSb7azr8e+ArwZeAjwLlJtkyyRpKPJbkqyZVJLkmyWSe/hCSp1+yVVJKkh+5XwNZJ1qmqe4CdgZ+NW+f0qjpsMJBkHvB7wPOq6oEksxjeaYEkSY8o7xhKkvTwOAd4aft6HvD5SWyzEXBzVT0AUFWLez7+lySpIxaGkiQ9POYD+yVZG3gecPG45fsmuXxgWgc4A3hZO//hJC+Y7qQlSQILQ0mSHhZVdQWwKc3dwrOHrHJ6Vc0ZmO6pqsXAc4CjgQeA85PsNG1JS5LU8hlDSZIePmcBHwJ2ADaczAZVdS9NM9RzktwC7AWc/0glKEnSMBaGkiQ9fE4G7qqqK5PsMNHKSbYBfl5VNyVZg6YJ6hWPcI6SJC3HwlCSpIdJ2zT0/61g8b5J/nBg/k3AesCnkjy2jX0P+MdHMEVJkoZygHtJkiRJ6jk7n5EkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQkSZKknrMwlCRJkqSeszCUJEmSpJ6zMJQk/f/t14EAAAAAgCB/60EuiwCAOTEEAACYC4V/TPzjjWV1AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1080x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "dfSumMes.plot.bar(x='MÊS', y='VENCIMENTOS', figsize=(15,5))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1> Salario Liquido por tempo de casa </h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>5417</th>\n",
       "      <th>5418</th>\n",
       "      <th>5419</th>\n",
       "      <th>5420</th>\n",
       "      <th>5421</th>\n",
       "      <th>5422</th>\n",
       "      <th>5423</th>\n",
       "      <th>5424</th>\n",
       "      <th>5425</th>\n",
       "      <th>5426</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EMPRESA</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>...</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>SPTURIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MÊS</th>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>...</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>Dezembro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANO</th>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>...</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOME</th>\n",
       "      <td>JOSE DE JESUS SODRE</td>\n",
       "      <td>ALIRIO ALBINO RIBEIRO</td>\n",
       "      <td>JOSE DEVANIR LINO</td>\n",
       "      <td>MANOEL NILSON OLIVEIRA GAMA</td>\n",
       "      <td>JOSE LINO XAVIER DA SILVA</td>\n",
       "      <td>LUZDALMA PARREIRA DE SOUZA</td>\n",
       "      <td>JOSE BARBOSA COSTA</td>\n",
       "      <td>JOSE LOURENCO DA SILVA</td>\n",
       "      <td>EDSON ANTONIO SAURA</td>\n",
       "      <td>MARIA NEVES RESENDE</td>\n",
       "      <td>...</td>\n",
       "      <td>RAFAEL BRUNO FAVACHO</td>\n",
       "      <td>THIAGO SQUASSONI MARTINS</td>\n",
       "      <td>THIFANNY MIGUEL R DA COSTA</td>\n",
       "      <td>ELEONORA PIAGGI PORTELA</td>\n",
       "      <td>JACINTA DE FATIMA P LOURENCO</td>\n",
       "      <td>AMANDA GONCALVES P CANDIDO</td>\n",
       "      <td>EDSON ANTONIO GILLI E SILVA</td>\n",
       "      <td>FERNANDA DO PRADO GAVA</td>\n",
       "      <td>LUCIMARA RIBEIRO DOS S BARROS</td>\n",
       "      <td>MARIA CAROLINA LOPES PESSOA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CARGO</th>\n",
       "      <td>SUPERV. CARPINTARIA</td>\n",
       "      <td>ANALISTA ADM - RH</td>\n",
       "      <td>SUPERV. OPERACAO</td>\n",
       "      <td>SUPERV. ARRECADACAO</td>\n",
       "      <td>AG MANUT HIDRAULICA</td>\n",
       "      <td>ESPEC ENG ARQUIT-ARQ</td>\n",
       "      <td>PRODUTOR TEC EVENTOS</td>\n",
       "      <td>AG MANUT CIVIL</td>\n",
       "      <td>GERENTE (F. CONF.)</td>\n",
       "      <td>AUXILIAR DE LIMPEZA</td>\n",
       "      <td>...</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>ASSESSOR IV</td>\n",
       "      <td>OPERADOR DE CAIXA</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "      <td>ESTAGIARIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOTAÇÃO</th>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>COORD ADMINISTRACAO PESSOAL</td>\n",
       "      <td>COORD OPERACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD ARRECADACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>COORD SUPORTE E EVENTOS</td>\n",
       "      <td>COORD MANUTENCAO CIVIL</td>\n",
       "      <td>GER DE REDUCAO DESP CONTRATUAIS E ALMOX</td>\n",
       "      <td>COORD SERVICOS AUXILIARES</td>\n",
       "      <td>...</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER COMPRAS E CONTRATOS</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>GER COMUNICACAO E PESQUISA</td>\n",
       "      <td>COORD ARRECADACAO DE ESTACIONAMENTO</td>\n",
       "      <td>COORD DE TURISMO</td>\n",
       "      <td>GER PRODUCAO E EVENTOS</td>\n",
       "      <td>COORD JURIDICA CONTENCIOSA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ADMISSÃO</th>\n",
       "      <td>1978-02-22 00:00:00</td>\n",
       "      <td>1984-04-11 00:00:00</td>\n",
       "      <td>1986-04-01 00:00:00</td>\n",
       "      <td>1986-04-01 00:00:00</td>\n",
       "      <td>1986-05-14 00:00:00</td>\n",
       "      <td>1986-05-27 00:00:00</td>\n",
       "      <td>1986-06-02 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>1987-04-01 00:00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>2018-07-02 00:00:00</td>\n",
       "      <td>2018-07-02 00:00:00</td>\n",
       "      <td>2018-10-08 00:00:00</td>\n",
       "      <td>2013-05-10 00:00:00</td>\n",
       "      <td>2009-07-27 00:00:00</td>\n",
       "      <td>2018-11-01 00:00:00</td>\n",
       "      <td>2018-06-07 00:00:00</td>\n",
       "      <td>2018-12-18 00:00:00</td>\n",
       "      <td>2018-02-02 00:00:00</td>\n",
       "      <td>2017-10-02 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <td>1952</td>\n",
       "      <td>1967</td>\n",
       "      <td>1953</td>\n",
       "      <td>1957</td>\n",
       "      <td>1962</td>\n",
       "      <td>1959</td>\n",
       "      <td>1957</td>\n",
       "      <td>1951</td>\n",
       "      <td>1961</td>\n",
       "      <td>1934</td>\n",
       "      <td>...</td>\n",
       "      <td>1998</td>\n",
       "      <td>1998</td>\n",
       "      <td>1999</td>\n",
       "      <td>1966</td>\n",
       "      <td>1956</td>\n",
       "      <td>1994</td>\n",
       "      <td>1965</td>\n",
       "      <td>1996</td>\n",
       "      <td>1997</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VENCIMENTOS</th>\n",
       "      <td>15264.2</td>\n",
       "      <td>13565.4</td>\n",
       "      <td>6126.61</td>\n",
       "      <td>10025.7</td>\n",
       "      <td>5123.6</td>\n",
       "      <td>19903.7</td>\n",
       "      <td>9047.87</td>\n",
       "      <td>4400.81</td>\n",
       "      <td>21434.9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1176.48</td>\n",
       "      <td>1043.76</td>\n",
       "      <td>1176.48</td>\n",
       "      <td>28386.2</td>\n",
       "      <td>48118.8</td>\n",
       "      <td>6395.75</td>\n",
       "      <td>782.76</td>\n",
       "      <td>387</td>\n",
       "      <td>1920.04</td>\n",
       "      <td>1919.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENCARGOS</th>\n",
       "      <td>5639.77</td>\n",
       "      <td>5012.06</td>\n",
       "      <td>0</td>\n",
       "      <td>3704.26</td>\n",
       "      <td>1893.04</td>\n",
       "      <td>7353.93</td>\n",
       "      <td>3342.96</td>\n",
       "      <td>1625.99</td>\n",
       "      <td>7919.67</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1783.58</td>\n",
       "      <td>155.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BENEFÍCIOS</th>\n",
       "      <td>2102.8</td>\n",
       "      <td>2468.42</td>\n",
       "      <td>1819.47</td>\n",
       "      <td>2185.09</td>\n",
       "      <td>1947.13</td>\n",
       "      <td>1737.18</td>\n",
       "      <td>1418.9</td>\n",
       "      <td>3137.91</td>\n",
       "      <td>1371.56</td>\n",
       "      <td>363</td>\n",
       "      <td>...</td>\n",
       "      <td>886.8</td>\n",
       "      <td>886.8</td>\n",
       "      <td>886.8</td>\n",
       "      <td>3253.2</td>\n",
       "      <td>1690.39</td>\n",
       "      <td>893.26</td>\n",
       "      <td>1087</td>\n",
       "      <td>1059.49</td>\n",
       "      <td>886.8</td>\n",
       "      <td>601.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OUTRAS REMUNERAÇÕES</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VÍNCULO</th>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>...</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Estagiário</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Desligado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DETALHE VÍNCULO</th>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Concursado ocupante de cargo em comissão</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LIMINAR</th>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vl_liquido</th>\n",
       "      <td>11727.3</td>\n",
       "      <td>11021.7</td>\n",
       "      <td>7946.08</td>\n",
       "      <td>8506.56</td>\n",
       "      <td>5177.69</td>\n",
       "      <td>14286.9</td>\n",
       "      <td>7123.81</td>\n",
       "      <td>5912.73</td>\n",
       "      <td>14886.8</td>\n",
       "      <td>363</td>\n",
       "      <td>...</td>\n",
       "      <td>2063.28</td>\n",
       "      <td>1930.56</td>\n",
       "      <td>2063.28</td>\n",
       "      <td>31639.4</td>\n",
       "      <td>49809.2</td>\n",
       "      <td>5505.43</td>\n",
       "      <td>1714.06</td>\n",
       "      <td>1446.49</td>\n",
       "      <td>2806.84</td>\n",
       "      <td>2521.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>anos_trabalhados</th>\n",
       "      <td>42</td>\n",
       "      <td>36</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17 rows × 5427 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                             0     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                          JOSE DE JESUS SODRE   \n",
       "CARGO                                         SUPERV. CARPINTARIA   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1978-02-22 00:00:00   \n",
       "NASCIMENTO                                                   1952   \n",
       "VENCIMENTOS                                               15264.2   \n",
       "ENCARGOS                                                  5639.77   \n",
       "BENEFÍCIOS                                                 2102.8   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                11727.3   \n",
       "anos_trabalhados                                               42   \n",
       "\n",
       "                                                             1     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                        ALIRIO ALBINO RIBEIRO   \n",
       "CARGO                                           ANALISTA ADM - RH   \n",
       "LOTAÇÃO                               COORD ADMINISTRACAO PESSOAL   \n",
       "ADMISSÃO                                      1984-04-11 00:00:00   \n",
       "NASCIMENTO                                                   1967   \n",
       "VENCIMENTOS                                               13565.4   \n",
       "ENCARGOS                                                  5012.06   \n",
       "BENEFÍCIOS                                                2468.42   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                11021.7   \n",
       "anos_trabalhados                                               36   \n",
       "\n",
       "                                                             2     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                            JOSE DEVANIR LINO   \n",
       "CARGO                                            SUPERV. OPERACAO   \n",
       "LOTAÇÃO                          COORD OPERACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                      1986-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1953   \n",
       "VENCIMENTOS                                               6126.61   \n",
       "ENCARGOS                                                        0   \n",
       "BENEFÍCIOS                                                1819.47   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                7946.08   \n",
       "anos_trabalhados                                               34   \n",
       "\n",
       "                                                             3     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                  MANOEL NILSON OLIVEIRA GAMA   \n",
       "CARGO                                         SUPERV. ARRECADACAO   \n",
       "LOTAÇÃO                       COORD ARRECADACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                      1986-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1957   \n",
       "VENCIMENTOS                                               10025.7   \n",
       "ENCARGOS                                                  3704.26   \n",
       "BENEFÍCIOS                                                2185.09   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                8506.56   \n",
       "anos_trabalhados                                               34   \n",
       "\n",
       "                                                             4     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                    JOSE LINO XAVIER DA SILVA   \n",
       "CARGO                                         AG MANUT HIDRAULICA   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1986-05-14 00:00:00   \n",
       "NASCIMENTO                                                   1962   \n",
       "VENCIMENTOS                                                5123.6   \n",
       "ENCARGOS                                                  1893.04   \n",
       "BENEFÍCIOS                                                1947.13   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                5177.69   \n",
       "anos_trabalhados                                               34   \n",
       "\n",
       "                                                             5     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                   LUZDALMA PARREIRA DE SOUZA   \n",
       "CARGO                                        ESPEC ENG ARQUIT-ARQ   \n",
       "LOTAÇÃO                               GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                      1986-05-27 00:00:00   \n",
       "NASCIMENTO                                                   1959   \n",
       "VENCIMENTOS                                               19903.7   \n",
       "ENCARGOS                                                  7353.93   \n",
       "BENEFÍCIOS                                                1737.18   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                14286.9   \n",
       "anos_trabalhados                                               34   \n",
       "\n",
       "                                                             6     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                           JOSE BARBOSA COSTA   \n",
       "CARGO                                        PRODUTOR TEC EVENTOS   \n",
       "LOTAÇÃO                                   COORD SUPORTE E EVENTOS   \n",
       "ADMISSÃO                                      1986-06-02 00:00:00   \n",
       "NASCIMENTO                                                   1957   \n",
       "VENCIMENTOS                                               9047.87   \n",
       "ENCARGOS                                                  3342.96   \n",
       "BENEFÍCIOS                                                 1418.9   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                7123.81   \n",
       "anos_trabalhados                                               34   \n",
       "\n",
       "                                                             7     \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                       Janeiro   \n",
       "ANO                                                          2018   \n",
       "NOME                                       JOSE LOURENCO DA SILVA   \n",
       "CARGO                                              AG MANUT CIVIL   \n",
       "LOTAÇÃO                                    COORD MANUTENCAO CIVIL   \n",
       "ADMISSÃO                                      1987-04-01 00:00:00   \n",
       "NASCIMENTO                                                   1951   \n",
       "VENCIMENTOS                                               4400.81   \n",
       "ENCARGOS                                                  1625.99   \n",
       "BENEFÍCIOS                                                3137.91   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                5912.73   \n",
       "anos_trabalhados                                               33   \n",
       "\n",
       "                                                         8     \\\n",
       "EMPRESA                                               SPTURIS   \n",
       "MÊS                                                   Janeiro   \n",
       "ANO                                                      2018   \n",
       "NOME                                      EDSON ANTONIO SAURA   \n",
       "CARGO                                      GERENTE (F. CONF.)   \n",
       "LOTAÇÃO               GER DE REDUCAO DESP CONTRATUAIS E ALMOX   \n",
       "ADMISSÃO                                  1987-04-01 00:00:00   \n",
       "NASCIMENTO                                               1961   \n",
       "VENCIMENTOS                                           21434.9   \n",
       "ENCARGOS                                              7919.67   \n",
       "BENEFÍCIOS                                            1371.56   \n",
       "OUTRAS REMUNERAÇÕES                                         0   \n",
       "VÍNCULO                 CLT: contrato por tempo indeterminado   \n",
       "DETALHE VÍNCULO      Concursado ocupante de cargo em comissão   \n",
       "LIMINAR                                                     -   \n",
       "vl_liquido                                            14886.8   \n",
       "anos_trabalhados                                           33   \n",
       "\n",
       "                                                             9     ...  \\\n",
       "EMPRESA                                                   SPTURIS  ...   \n",
       "MÊS                                                       Janeiro  ...   \n",
       "ANO                                                          2018  ...   \n",
       "NOME                                          MARIA NEVES RESENDE  ...   \n",
       "CARGO                                         AUXILIAR DE LIMPEZA  ...   \n",
       "LOTAÇÃO                                 COORD SERVICOS AUXILIARES  ...   \n",
       "ADMISSÃO                                      1987-04-01 00:00:00  ...   \n",
       "NASCIMENTO                                                   1934  ...   \n",
       "VENCIMENTOS                                                     0  ...   \n",
       "ENCARGOS                                                        0  ...   \n",
       "BENEFÍCIOS                                                    363  ...   \n",
       "OUTRAS REMUNERAÇÕES                                             0  ...   \n",
       "VÍNCULO                     CLT: contrato por tempo indeterminado  ...   \n",
       "DETALHE VÍNCULO      Concursado NÃO ocupante de cargo em comissão  ...   \n",
       "LIMINAR                                                         -  ...   \n",
       "vl_liquido                                                    363  ...   \n",
       "anos_trabalhados                                               33  ...   \n",
       "\n",
       "                                                                 5417  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                             RAFAEL BRUNO FAVACHO   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-07-02 00:00:00   \n",
       "NASCIMENTO                                                       1998   \n",
       "VENCIMENTOS                                                   1176.48   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    2063.28   \n",
       "anos_trabalhados                                                    2   \n",
       "\n",
       "                                                                 5418  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                         THIAGO SQUASSONI MARTINS   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                       GER COMPRAS E CONTRATOS   \n",
       "ADMISSÃO                                          2018-07-02 00:00:00   \n",
       "NASCIMENTO                                                       1998   \n",
       "VENCIMENTOS                                                   1043.76   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    1930.56   \n",
       "anos_trabalhados                                                    2   \n",
       "\n",
       "                                                                 5419  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                       THIFANNY MIGUEL R DA COSTA   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-10-08 00:00:00   \n",
       "NASCIMENTO                                                       1999   \n",
       "VENCIMENTOS                                                   1176.48   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                    Estagiário   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    2063.28   \n",
       "anos_trabalhados                                                    1   \n",
       "\n",
       "                                                                  5420  \\\n",
       "EMPRESA                                                        SPTURIS   \n",
       "MÊS                                                           Dezembro   \n",
       "ANO                                                               2018   \n",
       "NOME                                           ELEONORA PIAGGI PORTELA   \n",
       "CARGO                                               CEDIDO OUTRO ORGAO   \n",
       "LOTAÇÃO                                    GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                           2013-05-10 00:00:00   \n",
       "NASCIMENTO                                                        1966   \n",
       "VENCIMENTOS                                                    28386.2   \n",
       "ENCARGOS                                                             0   \n",
       "BENEFÍCIOS                                                      3253.2   \n",
       "OUTRAS REMUNERAÇÕES                                                  0   \n",
       "VÍNCULO              Servidor público cedido por outro ente: Servid...   \n",
       "DETALHE VÍNCULO       Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                              -   \n",
       "vl_liquido                                                     31639.4   \n",
       "anos_trabalhados                                                     7   \n",
       "\n",
       "                                                                  5421  \\\n",
       "EMPRESA                                                        SPTURIS   \n",
       "MÊS                                                           Dezembro   \n",
       "ANO                                                               2018   \n",
       "NOME                                      JACINTA DE FATIMA P LOURENCO   \n",
       "CARGO                                               CEDIDO OUTRO ORGAO   \n",
       "LOTAÇÃO                                    GER PLANEJAMENTO E PROJETOS   \n",
       "ADMISSÃO                                           2009-07-27 00:00:00   \n",
       "NASCIMENTO                                                        1956   \n",
       "VENCIMENTOS                                                    48118.8   \n",
       "ENCARGOS                                                             0   \n",
       "BENEFÍCIOS                                                     1690.39   \n",
       "OUTRAS REMUNERAÇÕES                                                  0   \n",
       "VÍNCULO              Servidor público cedido por outro ente: Servid...   \n",
       "DETALHE VÍNCULO       Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                              -   \n",
       "vl_liquido                                                     49809.2   \n",
       "anos_trabalhados                                                    11   \n",
       "\n",
       "                                                             5422  \\\n",
       "EMPRESA                                                   SPTURIS   \n",
       "MÊS                                                      Dezembro   \n",
       "ANO                                                          2018   \n",
       "NOME                                   AMANDA GONCALVES P CANDIDO   \n",
       "CARGO                                                 ASSESSOR IV   \n",
       "LOTAÇÃO                                GER COMUNICACAO E PESQUISA   \n",
       "ADMISSÃO                                      2018-11-01 00:00:00   \n",
       "NASCIMENTO                                                   1994   \n",
       "VENCIMENTOS                                               6395.75   \n",
       "ENCARGOS                                                  1783.58   \n",
       "BENEFÍCIOS                                                 893.26   \n",
       "OUTRAS REMUNERAÇÕES                                             0   \n",
       "VÍNCULO                                                 Desligado   \n",
       "DETALHE VÍNCULO      Não concursado ocupante de cargo em comissão   \n",
       "LIMINAR                                                         -   \n",
       "vl_liquido                                                5505.43   \n",
       "anos_trabalhados                                                1   \n",
       "\n",
       "                                                                 5423  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                      EDSON ANTONIO GILLI E SILVA   \n",
       "CARGO                                               OPERADOR DE CAIXA   \n",
       "LOTAÇÃO                           COORD ARRECADACAO DE ESTACIONAMENTO   \n",
       "ADMISSÃO                                          2018-06-07 00:00:00   \n",
       "NASCIMENTO                                                       1965   \n",
       "VENCIMENTOS                                                    782.76   \n",
       "ENCARGOS                                                        155.7   \n",
       "BENEFÍCIOS                                                       1087   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    1714.06   \n",
       "anos_trabalhados                                                    2   \n",
       "\n",
       "                                                                 5424  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                           FERNANDA DO PRADO GAVA   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                              COORD DE TURISMO   \n",
       "ADMISSÃO                                          2018-12-18 00:00:00   \n",
       "NASCIMENTO                                                       1996   \n",
       "VENCIMENTOS                                                       387   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                    1059.49   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    1446.49   \n",
       "anos_trabalhados                                                    1   \n",
       "\n",
       "                                                                 5425  \\\n",
       "EMPRESA                                                       SPTURIS   \n",
       "MÊS                                                          Dezembro   \n",
       "ANO                                                              2018   \n",
       "NOME                                    LUCIMARA RIBEIRO DOS S BARROS   \n",
       "CARGO                                                      ESTAGIARIO   \n",
       "LOTAÇÃO                                        GER PRODUCAO E EVENTOS   \n",
       "ADMISSÃO                                          2018-02-02 00:00:00   \n",
       "NASCIMENTO                                                       1997   \n",
       "VENCIMENTOS                                                   1920.04   \n",
       "ENCARGOS                                                            0   \n",
       "BENEFÍCIOS                                                      886.8   \n",
       "OUTRAS REMUNERAÇÕES                                                 0   \n",
       "VÍNCULO                                                     Desligado   \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão   \n",
       "LIMINAR                                                             -   \n",
       "vl_liquido                                                    2806.84   \n",
       "anos_trabalhados                                                    2   \n",
       "\n",
       "                                                                 5426  \n",
       "EMPRESA                                                       SPTURIS  \n",
       "MÊS                                                          Dezembro  \n",
       "ANO                                                              2018  \n",
       "NOME                                      MARIA CAROLINA LOPES PESSOA  \n",
       "CARGO                                                      ESTAGIARIO  \n",
       "LOTAÇÃO                                    COORD JURIDICA CONTENCIOSA  \n",
       "ADMISSÃO                                          2017-10-02 00:00:00  \n",
       "NASCIMENTO                                                       1991  \n",
       "VENCIMENTOS                                                   1919.52  \n",
       "ENCARGOS                                                            0  \n",
       "BENEFÍCIOS                                                     601.52  \n",
       "OUTRAS REMUNERAÇÕES                                                 0  \n",
       "VÍNCULO                                                     Desligado  \n",
       "DETALHE VÍNCULO      Não concursado NÃO ocupante de cargo em comissão  \n",
       "LIMINAR                                                             -  \n",
       "vl_liquido                                                    2521.04  \n",
       "anos_trabalhados                                                    2  \n",
       "\n",
       "[17 rows x 5427 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['vl_liquido'] = (df['VENCIMENTOS'] + df['BENEFÍCIOS'] + df['OUTRAS REMUNERAÇÕES']\n",
    "                   ) - df['ENCARGOS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2020-03-07 16:12:05.962941\n"
     ]
    }
   ],
   "source": [
    "dt_do_dia = pd.to_datetime('today').\n",
    "print(dt_do_dia)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['anos_trabalhados'] = (round(((dt_do_dia - df['ADMISSÃO']).dt.days) / 365,0)).astype('int64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD5CAYAAAA+0W6bAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAQAklEQVR4nO3df5BdZX3H8fdXuFuQoPwI7lBCDcVMSxqCtjsUq3Q2oq0/asEpKTgOk7a0wU47RmytacdB7UxH6A9p2tKWKNS0ttAGRSg4KE3vLdgqmvBjDWUsP6oWZUSnSF203Yt++8c9wd3l7u7d7L2798l5v2bu7DlPzrnne5M7n33ynOecE5mJJKk8z1npAiRJB8cAl6RCGeCSVCgDXJIKZYBLUqEOX86DrV69OteuXbuch5R68tRTT3HUUUetdBlSV/v27ft6Zp4wu31ZA3zt2rXs3bt3OQ8p9aTVajE+Pr7SZUhdRcQXu7U7hCJJhTLAJalQBrgkFcoAl6RCGeCSVKhlnYUiDZuIeFabN3hTKeyBq7YOhHej0WDHjh00Go0Z7dKwM8BVa41Gg6mpKTZu3MjU1NQzIS6VwABXrTWbzXnXpWFmgKvWNm3aNO+6NMw8ialaa7fbjnmrWPbAJalQBrhqrdFokJk0m00y05OYKooBrlrzJKZKZoCr1jyJqZIZ4Kq1drvNyMgIExMTjIyM0G63V7okqWfOQlFtZSYRQbvdZtu2bTPapRLYA1etZeaMk5iGt0pigEtSoQxwSSqUAS5JhTLAJalQBrgkFcoAl6RCGeCSVCgDXJIKZYBLUqG8lF615lPpVTJ74Kotn0qv0hngqjWfSq+SGeCqNR/ooJIZ4Ko1H+igkhngqjUf6KCSOQtFteUDHVQ6e+CqNR/ooJL1HOARcVhE3BMRt1Trp0TEXRHxYET8fUSMDK5MSdJsi+mBbwMemLZ+BXBlZq4DngAu7mdhkqT59RTgEbEGeB3wgWo9gFcAN1Sb7ALOG0SBkqTuej2J+cfAbwFHV+vHA9/IzKer9UeBk7rtGBFbga0Ao6OjtFqtgy5WGpTJyUm/myrOggEeET8DPJ6Z+yJi/EBzl027nv3JzJ3AToCxsbEcHx/vtpm0olqtFn43VZpeeuAvA342Il4LHAE8j06P/JiIOLzqha8BvjK4MiVJsy04Bp6Zv52ZazJzLXAh8M+Z+SagCZxfbbYFuGlgVUqSnmUp88DfAbwtIh6iMyZ+TX9KkiT1YlFXYmZmC2hVy48AZ/a/JElSL7wSU5IKZYBLUqEMcEkqlAEuSYUywCWpUAa4JBXKAJekQhngklQoA1ySCuUzMVVrnVvbz+Rj1VQKe+CqrQPh3Wg02LFjB41GY0a7NOwMcNVao9FgamqKjRs3MjU19UyISyUwwFVrzWZz3nVpmBngqrVNmzbNuy4NMwNctdZutxkZGWFiYoKRkRHa7fZKlyT1zFkoqq3MJCJot9ts27ZtRrtUAnvgqrXMJDNpNpvPLEulsAeuWnMeuEpmD1y1NT28169f37VdGmYGuGovM7nqqqvseas4Brhq7eyzz553XRpmjoGr1u68806HTFQse+CSVCgDXJIKZYCr9qbPA5dKYoBLUqE8iana8ySmSmUPXJIKZYCr9hwDV6kMcNXaqaeeOu+6NMwcA1etPfzww46Bq1j2wCWpUAa4JBXKAFetbdiwYcZJzA0bNqx0SVLPFhwDj4gjgDuA76u2vyEz3xURpwDXA8cBdwMXZebUIIuV+m3//v2OgatYvfTA/w94RWaeAbwYeHVEnAVcAVyZmeuAJ4CLB1emJGm2BQM8Oyar1Ub1SuAVwA1V+y7gvIFUKEnqqqdphBFxGLAPeBFwFfAw8I3MfLra5FHgpDn23QpsBRgdHaXVai2xZKm/ms0mk5OTrFq1ik2bNgH4PVURYjFXn0XEMcCNwGXAX2Xmi6r2k4GPZebp8+0/NjaWe/fuXUK5Uv8cGPvOTFqtFuPj4zPapGEREfsyc2x2+6Iu5MnMb0RECzgLOCYiDq964WuAr/SlUmmZeRJTpVpwDDwiTqh63kTEkcArgQeAJnB+tdkW4KZBFSlJerZeZqGcCDQjYgL4LHB7Zt4CvAN4W0Q8BBwPXDO4MqXB8WZWKtWCQyiZOQG8pEv7I8CZgyhKWi6bN29+1vru3btXqBppcbyZlWpt9+7djoGrWF5KL0mFMsAlqVAGuGrPk5gqlQEuSYXyJKZqz5OYKpU9cNXWXEMmDqWoFAa4ai0zZ4yBG94qiQEuSYVyDFy11m382164SmEPXLV1ILwbjQY7duyg0WjMaJeGnQGuWms0GkxNTbFx40ampqaeCXGpBAa4aq3ZbM67Lg0zA1y1duARanOtS8PMAFettdttRkZGmJiYYGRkhHa7vdIlST1zFopqKzOJCNrtNtu2bZvRLpXAHrhqzQt5VDJ74Ko154GrZPbAVVvOA1fpDHDVmvPAVTIDXLXmPHCVzABXrTkPXCUzwFVrzgNXyZyFotpyHrhKZw9cteY8cJXMAJekQhngklQoA1ySCmWAS1KhDHBJKpQBLkmFMsAlqVAGuCQVyisxdUharlvCeuGPVtKCPfCIODkimhHxQETcHxHbqvbjIuL2iHiw+nns4MuVenPgqspeXy98xy2L3sfw1krrZQjlaeA3MvM04Czg1yJiPbAd2JOZ64A91bokaZksGOCZ+Vhm3l0tfxN4ADgJOBfYVW22CzhvUEVKkp5tUWPgEbEWeAlwFzCamY9BJ+Qj4gVz7LMV2AowOjpKq9VaQrnS4PjdVGl6DvCIWAV8GHhrZv5PryeJMnMnsBNgbGwsx8fHD6JMacBuuxW/mypNT9MII6JBJ7z/NjM/UjV/NSJOrP78RODxwZQoSeqml1koAVwDPJCZ75v2RzcDW6rlLcBN/S9PkjSXXoZQXgZcBHwuIu6t2n4HuBz4h4i4GPgSsHkwJUqSulkwwDPzk8BcA97n9LccSVKvvJRekgplgEtSoQxwSSqUAS5JhTLAJalQBrgkFcoAl6RCGeCSVCgDXJIKZYBLUqEMcEkqlAEuSYUywCWpUAa4JBXKAJekQhngklQoA1ySCmWAS1KhDHBJKpQBLkmF6uWp9NKKOuM9n+DJb7cHfpy1228d6Ps//8gG973rpwZ6DNWLAa6h9+S323zh8tcN9BitVovx8fGBHmPQvyBUPw6hSFKhDHBJKpQBLkmFMsAlqVAGuCQVygCXpEIZ4JJUKOeBa+gdfdp2Tt+1ffAH2jXYtz/6NIDBzmdXvRjgGnrffOByL+SRunAIRZIKZYBLUqEMcEkq1IIBHhHXRsTjEbF/WttxEXF7RDxY/Tx2sGVKkmbrpQf+QeDVs9q2A3sycx2wp1qXJC2jBQM8M+8A/ntW87l8b9LVLuC8PtclSVrAwU4jHM3MxwAy87GIeMFcG0bEVmArwOjoKK1W6yAPqTob9PdmcnJyWb6bfv/VTwOfB56ZO4GdAGNjYznoubY6BN1268DnaC/HPPDl+Byql4OdhfLViDgRoPr5eP9KkiT14mAD/GZgS7W8BbipP+VIknrVyzTC64BPAT8UEY9GxMXA5cCrIuJB4FXVuiRpGS04Bp6Zb5zjj87pcy3SnJblPiK3Df6p9FI/eTMrDb1B38gKOr8gluM4Uj95Kb0kFcoAl6RCGeCSVCgDXJIKZYBLUqEMcEkqlAEuSYUywCWpUAa4JBXKAJekQhngklQoA1ySCmWAS1KhDHBJKpQBLkmFMsAlqVAGuCQVygCXpEIZ4JJUKANckgplgEtSoQxwSSqUAS5JhTLAJalQBrgkFcoAl6RCGeCSVCgDXJIKdfhKFyANQkQsfp8rFn+czFz8TlKfGOA6JPUarN2C3lBWKRxCUW1ND+9LLrmka7s0zAxw1V5mcuGFF9rzVnEMcNXalVdeOe+6NMyWFOAR8eqI+HxEPBQR2/tVlLRcLr300nnXpWF20AEeEYcBVwGvAdYDb4yI9f0qTFouEcH111/v2LeKs5Qe+JnAQ5n5SGZOAdcD5/anLGnwpo95X3311V3bpWG2lGmEJwH/NW39UeDHZ28UEVuBrQCjo6O0Wq0lHFLqr2azCcDk5CSrVq0C8DuqYiwlwLv9f/NZXZfM3AnsBBgbG8vx8fElHFIajFarhd9NlWYpQyiPAidPW18DfGVp5UiSerWUAP8ssC4iTomIEeBC4Ob+lCVJWshBD6Fk5tMR8evAx4HDgGsz8/6+VSZJmteS7oWSmR8DPtanWiRJixDLOWUqIr4GfHHZDij1bjXw9ZUuQprDCzPzhNmNyxrg0rCKiL2ZObbSdUiL4b1QJKlQBrgkFcoAlzp2rnQB0mI5Bi5JhbIHLkmFMsAlqVAGuCQVygDXISMiXhwRrz2I/cYj4pZF7tOKiLFqeXKxx5z1Xl+IiNVLeQ/VkwGuQ8mLga4BHhFLum2ENIwMcA1URHw0IvZFxP3Vwz2IiMmI+L2IuC8iPh0Ro1X7CyNiT0RMVD9/oGrfHBH7q+3vmOM4I8DvAhdExL0RcUFEvDsidkbEJ4C/joi1EXFnRNxdvX5i2ls8LyJujIh/j4i/jIjnVO/7FxGxt6r/PfN8zm6f5/URcVdE3BMR/zSt/fiI+ETVfjXT7q0fEW+rPuv+iHhr1XZURNxavf/+iLjgoP9BdGjJTF++BvYCjqt+HgnsB46n8+CP11ftvw+8s1r+R2BLtfxLwEer5c8BJ1XLx8xzrF8A/mza+ruBfcCR1fpzgSOq5XXA3mp5HPhf4Afp3FnzduD8WfUfBrSAjdV6Cxirluf6PMfyvam6vwz8UbX8J8Bl1fLrqv1XAz9WfdajgFXA/cBLgJ8D3j/tcz1/pf9dfQ3Hyx64Bu0tEXEf8Gk6DwBZB0wBB8ac9wFrq+WXAn9XLf8N8PJq+V+BD0bEr9AJ0sW4OTO/XS03gPdHxOeA3XQexn3AZ7LzfNfvANdNO/bPR8TdwD3Aj8za54C5Ps8a4OPV8d5e7Q/wk8CHADLzVuCJqv3lwI2Z+VRmTgIfAc6mE+qvjIgrIuLszHxykX8HOkQZ4BqYiBgHXgm8NDPPoBOCRwDtzDxwBdl3mPu2xp3ubeabgXfS+QVwb0Qcv4gynpq2fCnwVeAMYAwYmX2s6esRcQrwm8A5mbkRuLWqf7a5Ps+f0vkfwenAJbP27XYFXbfHFJKZ/8H3eufvjYjLum2n+jHANUjPB57IzG9FxA8DZy2w/b/RebITwJuATwJExKmZeVdmXkbnlq8nz7H/N4GjF6jnscz8LnARM3vzZ1ZPl3oOcEF17OfR+QXwZDV+/ZoF6u92vC9Xy1umtd9B5/MREa+hM9RyoP28iHhuRBwFvAG4MyK+H/hWZn4I+EPgRxdZhw5RnpnXIN0GvDkiJoDP0xlGmc9bgGsj4u3A14BfrNr/ICLW0emh7gHum2P/JrA9Iu4F3tvlz/8c+HBEbK62nd47/xRwOXA6nSC9MTO/GxH30BmLfoTOUM5ivBvYHRFfpvPZT6na3wNcVw3N/AvwJYDMvDsiPgh8ptruA5l5T0T8NJ2/g+8CbeBXF1mHDlHeC0WSCuUQiiQVyiEUFacaUrhiVvN/ZuYbVqIeaaU4hCJJhXIIRZIKZYBLUqEMcEkqlAEuSYX6f+ZGS3G7aZZiAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "boxplot = df.boxplot(column=['anos_trabalhados'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfFuncUniq = pd.DataFrame(df.groupby('anos_trabalhados').NOME.nunique().reset_index())\n",
    "dfFuncUniq.rename(columns={\"NOME\": \"qtd_func\"}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD5CAYAAAA+0W6bAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAANx0lEQVR4nO3dfYxl9V3H8fcHdhG65Rk6QRYZ1I2CoYBOkNrWTIBqKVZoBGnTkFXRtUbTVrR2NQ0Fo+niU41aW7eFsFoFW1oKspWCuFeKttRdnimpINJKIdBGQIaiPH39455Nx2Fm587DneG3834lN3PumXPu+d3dk/ec/e29c1NVSJLas8dyD0CSND8GXJIaZcAlqVEGXJIaZcAlqVGrlvJghxxySI2Oji7lIaWBPP3006xZs2a5hyFNa8eOHd+sqkOnrl/SgI+OjrJ9+/alPKQ0kF6vx/j4+HIPQ5pWkq9Ot94pFElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYt6Rt5pKWSZEmO4+/T13LyCly7paqa0+3I9147532Mt5abAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRhlwSWqUAZekRg0c8CR7JrktybXd/aOS3JLkviR/m2Sv4Q1TkjTVXK7A3wXcO+n+xcAHq2od8Dhw3mIOTJK0awMFPMla4HTgY939ACcDV3abbAHOHMYAJUnTWzXgdn8M/Aawb3f/YOCJqnq+u/8QcPh0OybZAGwAGBkZodfrzXuw0jB5bqo1swY8yU8Aj1XVjiTjO1dPs2lNt39VbQY2A4yNjdX4+Ph0m0nL67qteG6qNYNcgb8W+MkkbwL2Bvajf0V+QJJV3VX4WuDh4Q1TkjTVrHPgVfWbVbW2qkaBtwL/WFVvB7YBZ3WbrQeuHtooJUkvsZDXgb8XOD/J/fTnxC9ZnCFJkgYx6H9iAlBVPaDXLT8AnLj4Q5IkDcJ3YkpSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDXKgEtSowy4JDVq1WwbJNkbuAn4jm77K6vq/UmOAq4ADgJuBc6tqmeHOVitTMdddD1PPvPc0I8zunHrUB9//31Wc8f7f2yox9DKMmvAgf8FTq6qiSSrgZuT/D1wPvDBqroiyUeA84APD3GsWqGefOY5Htx0+lCP0ev1GB8fH+oxhv0DQivPrFMo1TfR3V3d3Qo4GbiyW78FOHMoI5QkTWuQK3CS7AnsAL4X+BDw78ATVfV8t8lDwOEz7LsB2AAwMjJCr9db4JC1Eg37vJmYmFiSc9PzX4tpoIBX1QvA8UkOAK4Cjp5usxn23QxsBhgbG6th/zNVu6Hrtg59emMpplCW4nloZZnTq1Cq6gmgB5wEHJBk5w+AtcDDizs0SdKuzBrwJId2V94k2Qc4FbgX2Aac1W22Hrh6WIOUJL3UIFMohwFbunnwPYBPVNW1Sb4MXJHkd4DbgEuGOE5J0hSzBryq7gROmGb9A8CJwxiUJGl2vhNTkhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUbMGPMkRSbYluTfJPUne1a0/KMkNSe7rvh44/OFKknYa5Ar8eeDXqupo4CTgl5McA2wEbqyqdcCN3X1J0hKZNeBV9UhV3dotPwXcCxwOnAFs6TbbApw5rEFKkl5q1Vw2TjIKnADcAoxU1SPQj3ySV82wzwZgA8DIyAi9Xm8Bw9VKNezzZmJiYknOTc9/LaaBA57klcCngHdX1X8nGWi/qtoMbAYYGxur8fHxeQxTK9p1Wxn2edPr9YZ+jKV4HlpZBnoVSpLV9OP911X16W71o0kO675/GPDYcIYoSZrOIK9CCXAJcG9V/dGkb10DrO+W1wNXL/7wJEkzGWQK5bXAucBdSW7v1v0WsAn4RJLzgK8BZw9niJKk6cwa8Kq6GZhpwvuUxR2OJGlQvhNTkhplwCWpUQZckhplwCWpUQZckho1p7fSS8th36M3cuyWJfhdaVtm32Qh9j0a4PThHkQrigHXy95T927iwU3DDd9SvJV+dOPWoT6+Vh6nUCSpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUbMGPMmlSR5LcvekdQcluSHJfd3XA4c7TEnSVINcgV8GvHHKuo3AjVW1Drixuy9JWkKzBryqbgL+a8rqM4At3fIW4MxFHpckaRar5rnfSFU9AlBVjyR51UwbJtkAbAAYGRmh1+vN85BayYZ93kxMTCzJuen5r8U034APrKo2A5sBxsbGanx8fNiH1O7muq0M+7zp9XpDP8ZSPA+tLPN9FcqjSQ4D6L4+tnhDkiQNYr4BvwZY3y2vB65enOFIkgY1yMsILwe+AHxfkoeSnAdsAt6Q5D7gDd19SdISmnUOvKreNsO3TlnksUiS5sB3YkpSowy4JDVq6C8jlBbD6Matwz/IdcM9xv77rB7q42vlMeB62Xtw0+lDP8boxq1LchxpMTmFIkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNMuCS1CgDLkmNWrXcA5CGIcnc97l47sepqrnvJC2SBV2BJ3ljkq8kuT/JxsUalLRQVTWn27Zt2+a8j/HWcpt3wJPsCXwIOA04BnhbkmMWa2CSpF1byBX4icD9VfVAVT0LXAGcsTjDkiTNZiFz4IcD/znp/kPAD0/dKMkGYAPAyMgIvV5vAYeUhmNiYsJzU81ZSMCn+1+il0wKVtVmYDPA2NhYjY+PL+CQ0nD0ej08N9WahUyhPAQcMen+WuDhhQ1HkjSohQT8X4F1SY5KshfwVuCaxRmWJGk2855Cqarnk/wK8DlgT+DSqrpn0UYmSdqlBb2Rp6o+C3x2kcYiSZqDLOWbEZJ8A/jqkh1QGtwhwDeXexDSDI6sqkOnrlzSgEsvV0m2V9XYco9Dmgt/mZUkNcqAS1KjDLjUt3m5ByDNlXPgktQor8AlqVEGXJIaZcAlqVEGXLuNJMcnedM89htPcu0c9+klGeuWJ+Z6zCmP9WCSQxbyGFqZDLh2J8cD0wY8iZ//qt2OAddQJflMkh1J7uk+3IMkE0l+N8kdSb6YZKRbf2SSG5Pc2X39rm792Unu7ra/aYbj7AX8NnBOktuTnJPkwiSbk1wP/GWS0SSfT3Jrd/uRSQ+xX5Krknw5yUeS7NE97oeTbO/Gf9Eunud0z+fNSW5JcluSf5i0/uAk13fr/4JJv1s/yfndc707ybu7dWuSbO0e/+4k58z7L0S7l/l8kKs3b4PegIO6r/sAdwMH0//gjzd3638PeF+3/HfA+m7554DPdMt3AYd3ywfs4lg/A/zZpPsXAjuAfbr7rwD27pbXAdu75XHgf4Dvpv+bNW8Azpoy/j2BHvDq7n4PGOuWZ3o+B/Ltl+r+PPCH3fKfABd0y6d3+x8C/FD3XNcArwTuAU4Afgr46KTntf9y/716e3ncvALXsL0zyR3AF+l/AMg64Flg55zzDmC0W34N8Dfd8l8Br+uW/xm4LMkv0A/pXFxTVc90y6uBjya5C/gk/Q/j3ulL1f981xeAyycd+6eT3ArcBvzAlH12mun5rAU+1x3vPd3+AD8KfBygqrYCj3frXwdcVVVPV9UE8Gng9fSjfmqSi5O8vqqenOOfgXZTBlxDk2QcOBV4TVUdRz+CewPPVdXOd5C9wMy/1rh/eVv1DuB99H8A3J7k4DkM4+lJy78KPAocB4wBe0091uT7SY4Cfh04papeDWztxj/VTM/nT+n/i+BY4Ben7DvdO+im+5hCqurf+PbV+QeSXDDddlp5DLiGaX/g8ar6VpLvB06aZft/of/JTgBvB24GSPI9VXVLVV1A/1e+HjHD/k8B+84ynkeq6kXgXP7/1fyJ3adL7QGc0x17P/o/AJ7s5q9Pm2X80x3v693y+knrb6L//EhyGv2plp3rz0zyiiRrgLcAn0/yncC3qurjwB8APzjHcWg35f/Ma5iuA96R5E7gK/SnUXblncClSd4DfAP42W797ydZR/8K9Ubgjhn23wZsTHI78IFpvv/nwKeSnN1tO/nq/AvAJuBY+iG9qqpeTHIb/bnoB+hP5czFhcAnk3yd/nM/qlt/EXB5NzXzT8DXAKrq1iSXAV/qtvtYVd2W5Mfp/xm8CDwH/NIcx6HdlL8LRZIa5RSKJDXKKRQ1p5tSuHjK6v+oqrcsx3ik5eIUiiQ1yikUSWqUAZekRhlwSWqUAZekRv0fvWwQvKQhtPMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "boxplot = dfFuncUniq.boxplot(column=['anos_trabalhados'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD5CAYAAAA+0W6bAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAANsUlEQVR4nO3dcayddX3H8fdHCoMwFBA56cBY5jqBZAHmCWMhW44wDZtudJs4ybJVw3L/cc5lM7Obf0yTLcFk0fGH2XYnzpvpFIIjJdR0sq5n6rIwAcGJxdR1qA0dlSlKmVEh3/1xn8bm9pZ7bs95Tv3R9ytp7nme8zzn+d7k4d2Hp+fcm6pCktSeF5zoASRJx8eAS1KjDLgkNcqAS1KjDLgkNWrDPA923nnn1aZNm+Z5SGkiTz/9NGeeeeaJHkNa1f333/9EVb1k5fq5BnzTpk3cd9998zykNJHxeMxoNDrRY0irSvKV1dZ7C0WSGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRc/0gjzQvSeZyHH+evk4kr8D1vFRV6/rzsnfcve59jLdONAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY2aKOBJzk5yR5JHkuxJ8rNJzk1yT5K93ddz+h5WkvQDk16B3wLsrKqLgcuAPcA2YFdVbQZ2dcuSpDlZM+BJXgj8PHArQFV9r6qeBK4HlrrNloAtfQ0pSTraJFfgPw58Hfi7JJ9L8oEkZwKDqjoA0H09v8c5JUkrTPIr1TYAPw28taruTXIL67hdkmQBWAAYDAaMx+PjmVPqneemWjNJwPcD+6vq3m75DpYD/niSjVV1IMlG4OBqO1fVIrAIMBwOazQaTT+1NGs7d+C5qdaseQulqv4H+FqSV3SrrgW+CNwFbO3WbQW29zKhJGlVk/5W+rcCH0lyGrAPeDPL8b89yU3AV4Eb+hlRkrSaiQJeVQ8Cw1Weuna240iSJuUnMSWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhq1YZKNkjwKPAU8CzxTVcMk5wK3AZuAR4E3VNU3+xlTkrTSeq7AX1VVl1fVsFveBuyqqs3Arm5ZkjQn09xCuR5Y6h4vAVumH0eSNKmJbqEABXwySQF/U1WLwKCqDgBU1YEk56+2Y5IFYAFgMBgwHo+nn1rqgeemWjNpwK+uqse6SN+T5JFJD9DFfhFgOBzWaDRa/5RS33buwHNTrZnoFkpVPdZ9PQjcCVwJPJ5kI0D39WBfQ0qSjrZmwJOcmeSsw4+B1wBfAO4CtnabbQW29zWkJOlok9xCGQB3Jjm8/T9U1c4knwVuT3IT8FXghv7GlCSttGbAq2ofcNkq6/8XuLaPoSRJa/OTmJLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUKAMuSY0y4JLUqIkDnuSUJJ9Lcne3fFGSe5PsTXJbktP6G1OStNJ6rsDfBuw5Yvk9wPuqajPwTeCmWQ4mSXpuEwU8yYXAa4EPdMsBrgHu6DZZArb0MaAkaXUbJtzuL4E/As7qll8MPFlVz3TL+4ELVtsxyQKwADAYDBiPx8c9rNQnz021Zs2AJ3kdcLCq7k8yOrx6lU1rtf2rahFYBBgOhzUajVbbTDqxdu7Ac1OtmeQK/GrgV5L8EnA68EKWr8jPTrKhuwq/EHisvzElSSuteQ+8qv64qi6sqk3AG4F/qarfBHYDr+822wps721KSdJRpnkf+DuAP0jyZZbvid86m5EkSZOY9B8xAaiqMTDuHu8Drpz9SJKkSfhJTElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEYZcElqlAGXpEatGfAkpyf5jyQPJXk4ybu79RcluTfJ3iS3JTmt/3ElSYdNcgX+XeCaqroMuBy4LslVwHuA91XVZuCbwE39jSlJWmnNgNeyQ93iqd2fAq4B7ujWLwFbeplQkrSqDZNslOQU4H7gJ4D3A/8FPFlVz3Sb7AcuOMa+C8ACwGAwYDweTzmy1A/PTbVmooBX1bPA5UnOBu4ELllts2PsuwgsAgyHwxqNRsc3qU5al737k3zrO9/v/Thv2vl0r6//ojNO5aE/fU2vx9DJZaKAH1ZVTyYZA1cBZyfZ0F2FXwg81sN8Et/6zvd59ObX9nqM8XhM3xcXm7bt6PX1dfKZ5F0oL+muvElyBvALwB5gN/D6brOtwPa+hpQkHW2SK/CNwFJ3H/wFwO1VdXeSLwIfS/JnwOeAW3ucU5K0wpoBr6rPA1essn4fcGUfQ0mS1uYnMSWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUQZckhplwCWpUWsGPMlLk+xOsifJw0ne1q0/N8k9SfZ2X8/pf1xJ0mGTXIE/A/xhVV0CXAW8JcmlwDZgV1VtBnZ1y5KkOVkz4FV1oKoe6B4/BewBLgCuB5a6zZaALX0NKUk62ob1bJxkE3AFcC8wqKoDsBz5JOcfY58FYAFgMBgwHo+nGFcnq77Pm0OHDs3l3PT81yxNHPAkPwp8HPj9qvp2kon2q6pFYBFgOBzWaDQ6jjF1Utu5g77Pm/F43Psx5vF96OQy0btQkpzKcrw/UlX/2K1+PMnG7vmNwMF+RpQkrWaSd6EEuBXYU1XvPeKpu4Ct3eOtwPbZjydJOpZJbqFcDfwW8J9JHuzW/QlwM3B7kpuArwI39DOiJGk1awa8qj4DHOuG97WzHUeSNCk/iSlJjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjTLgktQoAy5JjVoz4Ek+mORgki8cse7cJPck2dt9PaffMSVJK01yBf4h4LoV67YBu6pqM7CrW5YkzdGaAa+qTwHfWLH6emCpe7wEbJnxXJKkNRzvPfBBVR0A6L6eP7uRJEmT2ND3AZIsAAsAg8GA8Xjc9yH1PNT3eXPo0KG5nJue/5ql4w3440k2VtWBJBuBg8fasKoWgUWA4XBYo9HoOA+pk9bOHfR93ozH496PMY/vQyeX472FchewtXu8Fdg+m3EkSZOa5G2EHwX+HXhFkv1JbgJuBl6dZC/w6m5ZkjRHa95Cqaobj/HUtTOeRZK0Dn4SU5IaZcAlqVG9v41QmtZZl2zjp5bm8GHfpbU3mcZZlwC8tt+D6KRiwPVD76k9N/Pozf2Gbx5vI9y0bUevr6+Tj7dQJKlRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGmXAJalRBlySGuUvdFAT5vLLEHb2e4wXnXFqr6+vk48B1w+9vn8bDyz/BTGP40izNFXAk1wH3AKcAnygqm6eyVTSlJKsf5/3rP84VbX+naQZOe574ElOAd4P/CJwKXBjkktnNZg0japa15/du3evex/jrRNtmn/EvBL4clXtq6rvAR8Drp/NWJKktUxzC+UC4GtHLO8HfmblRkkWgAWAwWDAeDye4pBSPw4dOuS5qeZME/DVbjIe9f+UVbUILAIMh8MajUZTHFLqx3g8xnNTrZnmFsp+4KVHLF8IPDbdOJKkSU0T8M8Cm5NclOQ04I3AXbMZS5K0luO+hVJVzyT5XeCfWH4b4Qer6uGZTSZJek5TvQ+8qj4BfGJGs0iS1sGfhSJJjco8P4yQ5OvAV+Z2QGly5wFPnOghpGN4WVW9ZOXKuQZc+mGV5L6qGp7oOaT18BaKJDXKgEtSowy4tGzxRA8grZf3wCWpUV6BS1KjDLgkNcqAS1KjDLieN5K8KcmPHeO5UZK7n2PfH0nyz0keTPIb/U0pzY6/1FjPJ28CvsDx/VjjK4BTq+rymU4k9cgrcDUpyTuTfKm7av5okrcDQ+Aj3VX0GUmuS/JIks8Av/Ycr3U+8GHg8m7flyd5NMl53fPDJOPu8buSfDDJOMm+JL93xOv8dpLPJ3koyd/3+f1L4BW4GpTklSz//PkrWD6HHwDuB+4D3l5V9yU5Hfhb4Brgy8Btx3q9qjqY5He6fV/XHeO5RrgYeBVwFvClJH8F/CTwTuDqqnoiybnTfZfS2rwCV4t+Drizqv6vqr7N6r9I5GLgv6tqby1/2OHDMzz+jqr6blU9ARwEBiz/RXFHt46q+sYMjyetyoCrVZN8Am2aT6k9ww/++zh9xXPfPeLxsyz/X0CmPJ60bgZcLfoU8Kvdfe6zgF/u1j/F8m0NgEeAi5K8vFu+cZ3HeBR4Zff41yfYfhfwhiQvBvAWiubBgKs5VfUAy/e0HwQ+Dny6e+pDwF8neZDlK+IFYEf3j5jr/Tn07wZuSfJplq+y15rpYeDPgX9N8hDw3nUeT1o3fxaKmpfkXcChqvqLEz2LNE9egUtSo7wC10klyZuBt61Y/W9V9ZYTMY80DQMuSY3yFookNcqAS1KjDLgkNcqAS1Kj/h+KrqpG5WAHHAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "boxplot = dfFuncUniq.boxplot(column=['qtd_func'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPEAAAHhCAYAAAC/algmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAPK0lEQVR4nO3cf4zkd13H8dfrdq/e3OFReldJ3bZsdS4BDKXqBamKaRBjW8VIBKshpipaMWY5/IFpI2mKicH6u574oyhpFCWGQLG2RMCzFfzR1rtetxyWwoiirIVylB/t3mKPvY9/fD9r59bZ29ub2f3Oa+/5SCb7ne/OfOc9t/O8+c7m+12XUgQg15a2BwAwHCIGwhExEI6IgXBEDIQjYiDc5FpuvHv37jI9Pb1OowBYyaFDh46WUs4f9L01RTw9Pa2DBw+OZioAp832J1f6HrvTQDgiBsIRMRCOiIFwRAyEI2IgHBED4YgYCEfEQDgiBsIRMRCOiIFwRAyEI2IgHBED4YgYCEfEQDgiBsIRMRCOiIFwRAyEI2IgHBED4YgYCEfEQDgiBsIRMRCOiIFwRAyEI2IgHBED4YgYCEfEQDgiBsIRMRCOiIFwRAyEI2IgHBED4YgYCEfEQLjJtgcYtf3796vX67U9xinNzc1pYWFBnU5HU1NTbY+z7rrdrmZmZtoeY9PadBH3ej3Nzs62PcZpmZ+f19GjR9seA+E2XcRLysQ5Wtx+XttjDDRx7HPy4nGVia1a3L6r7XHWzcSxx+XFp9oeY9PbtBEvbj9PC8+9uu0xBup89L2afOLTWty+a2xnHIWl54n1xS+2gHBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDISbHPUG9+/fr16vp263q5mZmVFvHtg0RtXKyCPu9XqanZ0d9WaBTWdUrbA7DYQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAuMlRb3Bubk6S1Ov1tG/fvlFvflW9Xk+StOXLX9rwx8bJln4Gbb0Wxt3Sa3WpmTO1asS2r5N0nSRdfPHFq25wYWFBkjQ/P6/Z2dmhhhuGTxxv7bHRWPoZtP1aGHdLzZypVSMupdwq6VZJ2rt3b1nt9p1OR/Pz89qxY4e63e5Qw52JXq+n+fl5lS1bN/yxcbKyZau8eLy118K4W3qtdjqdobYz8t3pqakpHT16VN1uV7fccsuoN7+qffv2aXZ2Vie27dzwx8bJTmzbqS3Hj7X2Whh3S6/VqampobbDL7aAcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAg3OeoNdrvdk74CGGxUrYw84pmZmVFvEtiURtUKu9NAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEI6IgXBEDIQjYiAcEQPhiBgIR8RAOCIGwhExEG6y7QHWy8Sxx9X56HvbHmOgiWOf+7+v4zrjKEwce7ztEc4KmzZiLz6lySc+3fYYp+TF42M/I8bfpou42+22PcKq5ubmtLCwoE6no6mpqbbHWXcJP5Nkmy7imZmZtkcANhS/2ALCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCETEQjoiBcEQMhCNiIBwRA+GIGAhHxEA4IgbCuZRy+je2Pyvpk8tW75Z0dJRDbYC0mZl3fSXM+5xSyvmDvrGmiAduwD5YStk71EY2WNrMzLu+0uZdjt1pIBwRA+FGEfGtI9jGRkubmXnXV9q8Jxn6MzGAdrE7DYQbKmLbV9p+xHbP9vWjGmpUbL/N9mO2j/StO8/2B2x/vH59Vpsz9rN9ke27bT9s+yO299X1Yzmz7W2277c9W+d9U11/ie376rx/afuctmftZ3vC9mHbd9brYz3vas44YtsTkt4i6SpJz5f0w7afP6rBRuQ2SVcuW3e9pAOllD2SDtTr4+Irkn6+lPI8SS+W9DP133RcZ/4fSS8tpbxQ0mWSrrT9Ykk3S/rtOu/nJb2mxRkH2Sfp4b7r4z7vqZVSzugi6XJJ7+u7foOkG850e+t1kTQt6Ujf9UckXVCXL5D0SNsznmL2v5L0XQkzS9ou6QFJ36LmwInJQa+Tti+SLlTzH+FLJd0pyeM87+lchtmdnpL0X33XP1XXjbtnl1IelaT69Wtanmcg29OSvlHSfRrjmeuu6YOSHpP0AUn/JukLpZSv1JuM2+vidyT9oqQT9foujfe8qxomYg9Yx6+6R8D2MyS9S9LrSylfanueUymlLJZSLlPzDvciSc8bdLONnWow298r6bFSyqH+1QNuOhbznq7JIe77KUkX9V2/UNJ/DzfOhviM7QtKKY/avkDNO8jYsL1VTcB/Xkp5d1091jNLUinlC7bvUfNZ/lzbk/XdbZxeF98m6ftsXy1pm6Sdat6Zx3Xe0zLMO/G/SNpTf7N3jqQfknTHaMZaV3dIurYuX6vmc+dYsG1JfyLp4VLKb/V9ayxntn2+7XPrckfSy9T8wuhuSa+sNxubeUspN5RSLiylTKt5vf5dKeXVGtN5T9uQvyS4WtLH1HwO+qW2P+APmO8dkh6VdFzNnsNr1HwGOiDp4/XreW3P2Tfvt6vZlXtI0oP1cvW4zizpUkmH67xHJN1Y13+dpPsl9SS9U9JXtT3rgNmvkHRnyrynunDEFhCOI7aAcEQMhCNiIBwRA+GIGAhHxEA4Ig5i+7J6tNFa73fF0ml3a7jPPbb31uUn1/qYy7b1H7Z3D7MNrIyIs1ym5uCP/8f2MIfQIhgRD8n2e2wfqifFX1fXPWn7V+rJ8vfafnZd/xzbB2w/VL9eXNe/yvaRevsPrvA450j6ZUnX2H7Q9jW2b7J9q+33S/pT29O2P2T7gXr51r5N7LR9u+1/tf2HtrfU7f6B7YP9J/Wv8PiDns/L68n0h23/bd/6XbbfX9f/kfpOMrD9c/W5HrH9+rpuh+276vaP2L7mjH8gZ6O2DxlLv6geAimpo+bQw11qDp18eV3/a5LeWJf/WtK1dfnHJb2nLn9Y0lRdPvcUj/Wjkn6v7/pNkg5J6tTr2yVtq8t7JB2sy1dI+rKawwsn1Jwy+Mpl809IukfSpfX6PZL21uWVns+z9PTfafsJSb9Zl39XTx+C+T31/rslfXN9rjskPUPSR9ScbvkDkt7a97ye2fbPNenCO/HwXmd7VtK9as7q2iPpKTUnnEtNZNN1+XJJf1GX/0zNsdKS9I+SbrP9k2piWos7SikLdXmrpLfa/rCaY4D7/9LK/aWUT5RSFtUcU7702D9o+wE1x0B/w7L7LFnp+Vwo6X318d5Q7y9J3yHp7ZJUSrlLzV/LUH3M20sp86WUJyW9W9JL1IT9Mts3235JKeWLa/w3OKsR8RBsX6HmzJ3LS/Mnag6rOcXteKlvKZIWtfIpn83bXCmvlfRGNf8JPGh71xrGmO9b/llJn5H0Qkl7JfX/rajlB8kX25dI+gVJ31lKuVTSXXX+5VZ6PvvV7Bm8QNJPLbvvoIPyB527q1LKx/T0u/Sbbd846HYYjIiH80xJny+lHLP9XDXn0p7KP6k5BU6SXi3pHyTJ9teXUu4rpdyo5k/FXLTC/Z+Q9NWrzPNoKeWEpB/Rye/qL6qnjW6RdE197J1q/hP4Yv08e9Uq8w96vLm6fG3f+g+qeX6yfZWa3e6l9d9ve7vtHZJeIelDtr9W0rFSytsl/Yakb1rjHGc1fqM5nL+R9FrbD6n5O1j3rnL710l6m+03SPqspB+r63/d9h4171QHJM2ucP+7JV1f/xzOmwd8//clvcv2q+pt+9+l/1nSr0p6gZqYbi+lnLB9WM1n00+o2a1fi5skvdP2nJrnfkld/yZJ76i76X8v6T8lqZTygO3b1Jz2J0l/XEo5bPu71fwbnFBz2uhPr3GOsxqnIgLh2J0GwrE7PYbq7uXNy1b/eynlFW3Mg/HG7jQQjt1pIBwRA+GIGAhHxEA4IgbC/S8kOrtZDU1R4QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 288x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(4,8))\n",
    "sns.boxplot(x='anos_trabalhados', data=dfFuncUniq, linewidth=2.5)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMPRESA</th>\n",
       "      <th>MÊS</th>\n",
       "      <th>ANO</th>\n",
       "      <th>NOME</th>\n",
       "      <th>CARGO</th>\n",
       "      <th>LOTAÇÃO</th>\n",
       "      <th>ADMISSÃO</th>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <th>VENCIMENTOS</th>\n",
       "      <th>ENCARGOS</th>\n",
       "      <th>BENEFÍCIOS</th>\n",
       "      <th>OUTRAS REMUNERAÇÕES</th>\n",
       "      <th>VÍNCULO</th>\n",
       "      <th>DETALHE VÍNCULO</th>\n",
       "      <th>LIMINAR</th>\n",
       "      <th>vl_liquido</th>\n",
       "      <th>anos_trabalhados</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4520</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Outubro</td>\n",
       "      <td>2018</td>\n",
       "      <td>ESTEVAO ANTONIO VUKELIC</td>\n",
       "      <td>ANAL NEGOCIOS VENDAS</td>\n",
       "      <td>COORD DE MARKETING</td>\n",
       "      <td>2010-09-20</td>\n",
       "      <td>1959</td>\n",
       "      <td>132297.75</td>\n",
       "      <td>31276.45</td>\n",
       "      <td>3241.64</td>\n",
       "      <td>0</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>104262.94</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5421</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Dezembro</td>\n",
       "      <td>2018</td>\n",
       "      <td>JACINTA DE FATIMA P LOURENCO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>2009-07-27</td>\n",
       "      <td>1956</td>\n",
       "      <td>48118.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1690.39</td>\n",
       "      <td>0</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>49809.17</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4515</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Outubro</td>\n",
       "      <td>2018</td>\n",
       "      <td>JACINTA DE FATIMA P LOURENCO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>2009-07-27</td>\n",
       "      <td>1956</td>\n",
       "      <td>47874.51</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1660.07</td>\n",
       "      <td>0</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>49534.58</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4068</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Setembro</td>\n",
       "      <td>2018</td>\n",
       "      <td>JOAO EDUARDO DE V AMARAL AYRES</td>\n",
       "      <td>CHEFE DE GABINETE</td>\n",
       "      <td>CHEFIA DE GABINETE</td>\n",
       "      <td>2017-04-13</td>\n",
       "      <td>1973</td>\n",
       "      <td>56043.94</td>\n",
       "      <td>9486.32</td>\n",
       "      <td>1077.11</td>\n",
       "      <td>0</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Não concursado ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>47634.73</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Janeiro</td>\n",
       "      <td>2018</td>\n",
       "      <td>ELEONORA PIAGGI PORTELA</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>2013-05-10</td>\n",
       "      <td>1966</td>\n",
       "      <td>40171.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2515.76</td>\n",
       "      <td>0</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>42686.95</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      EMPRESA       MÊS   ANO                            NOME  \\\n",
       "4520  SPTURIS   Outubro  2018         ESTEVAO ANTONIO VUKELIC   \n",
       "5421  SPTURIS  Dezembro  2018    JACINTA DE FATIMA P LOURENCO   \n",
       "4515  SPTURIS   Outubro  2018    JACINTA DE FATIMA P LOURENCO   \n",
       "4068  SPTURIS  Setembro  2018  JOAO EDUARDO DE V AMARAL AYRES   \n",
       "439   SPTURIS   Janeiro  2018         ELEONORA PIAGGI PORTELA   \n",
       "\n",
       "                     CARGO                      LOTAÇÃO   ADMISSÃO  \\\n",
       "4520  ANAL NEGOCIOS VENDAS           COORD DE MARKETING 2010-09-20   \n",
       "5421    CEDIDO OUTRO ORGAO  GER PLANEJAMENTO E PROJETOS 2009-07-27   \n",
       "4515    CEDIDO OUTRO ORGAO  GER PLANEJAMENTO E PROJETOS 2009-07-27   \n",
       "4068     CHEFE DE GABINETE           CHEFIA DE GABINETE 2017-04-13   \n",
       "439     CEDIDO OUTRO ORGAO  GER PLANEJAMENTO E PROJETOS 2013-05-10   \n",
       "\n",
       "      NASCIMENTO  VENCIMENTOS  ENCARGOS  BENEFÍCIOS  OUTRAS REMUNERAÇÕES  \\\n",
       "4520        1959    132297.75  31276.45     3241.64                    0   \n",
       "5421        1956     48118.78      0.00     1690.39                    0   \n",
       "4515        1956     47874.51      0.00     1660.07                    0   \n",
       "4068        1973     56043.94   9486.32     1077.11                    0   \n",
       "439         1966     40171.19      0.00     2515.76                    0   \n",
       "\n",
       "                                                VÍNCULO  \\\n",
       "4520                                          Desligado   \n",
       "5421  Servidor público cedido por outro ente: Servid...   \n",
       "4515  Servidor público cedido por outro ente: Servid...   \n",
       "4068                                          Desligado   \n",
       "439   Servidor público cedido por outro ente: Servid...   \n",
       "\n",
       "                                       DETALHE VÍNCULO LIMINAR  vl_liquido  \\\n",
       "4520      Concursado NÃO ocupante de cargo em comissão       -   104262.94   \n",
       "5421  Não concursado NÃO ocupante de cargo em comissão       -    49809.17   \n",
       "4515  Não concursado NÃO ocupante de cargo em comissão       -    49534.58   \n",
       "4068      Não concursado ocupante de cargo em comissão       -    47634.73   \n",
       "439   Não concursado NÃO ocupante de cargo em comissão       -    42686.95   \n",
       "\n",
       "      anos_trabalhados  \n",
       "4520                 9  \n",
       "5421                11  \n",
       "4515                11  \n",
       "4068                 3  \n",
       "439                  7  "
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by=['vl_liquido'], ascending = False,inplace=True)\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Desligado',\n",
       "       'Servidor público cedido por outro ente: Servidor Público Municipal',\n",
       "       'CLT: contrato por tempo indeterminado',\n",
       "       'Estatutário: diretor (estatuto social)',\n",
       "       'Estatutário: conselho administrativo (estatuto social)',\n",
       "       'Estatutário: comitê de auditoria estatutária', 'Estagiário',\n",
       "       'CLT: aprendiz', 'Estatutário: conselho fiscal (estatuto social)',\n",
       "       'CLT: contrato por tempo determinado'], dtype=object)"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['VÍNCULO'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMPRESA</th>\n",
       "      <th>MÊS</th>\n",
       "      <th>ANO</th>\n",
       "      <th>NOME</th>\n",
       "      <th>CARGO</th>\n",
       "      <th>LOTAÇÃO</th>\n",
       "      <th>ADMISSÃO</th>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <th>VENCIMENTOS</th>\n",
       "      <th>ENCARGOS</th>\n",
       "      <th>BENEFÍCIOS</th>\n",
       "      <th>OUTRAS REMUNERAÇÕES</th>\n",
       "      <th>VÍNCULO</th>\n",
       "      <th>DETALHE VÍNCULO</th>\n",
       "      <th>LIMINAR</th>\n",
       "      <th>vl_liquido</th>\n",
       "      <th>anos_trabalhados</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4520</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Outubro</td>\n",
       "      <td>2018</td>\n",
       "      <td>ESTEVAO ANTONIO VUKELIC</td>\n",
       "      <td>ANAL NEGOCIOS VENDAS</td>\n",
       "      <td>COORD DE MARKETING</td>\n",
       "      <td>2010-09-20</td>\n",
       "      <td>1959</td>\n",
       "      <td>132297.75</td>\n",
       "      <td>31276.45</td>\n",
       "      <td>3241.64</td>\n",
       "      <td>0</td>\n",
       "      <td>Desligado</td>\n",
       "      <td>Concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>104262.94</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4515</th>\n",
       "      <td>SPTURIS</td>\n",
       "      <td>Outubro</td>\n",
       "      <td>2018</td>\n",
       "      <td>JACINTA DE FATIMA P LOURENCO</td>\n",
       "      <td>CEDIDO OUTRO ORGAO</td>\n",
       "      <td>GER PLANEJAMENTO E PROJETOS</td>\n",
       "      <td>2009-07-27</td>\n",
       "      <td>1956</td>\n",
       "      <td>47874.51</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1660.07</td>\n",
       "      <td>0</td>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>Não concursado NÃO ocupante de cargo em comissão</td>\n",
       "      <td>-</td>\n",
       "      <td>49534.58</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      EMPRESA      MÊS   ANO                          NOME  \\\n",
       "4520  SPTURIS  Outubro  2018       ESTEVAO ANTONIO VUKELIC   \n",
       "4515  SPTURIS  Outubro  2018  JACINTA DE FATIMA P LOURENCO   \n",
       "\n",
       "                     CARGO                      LOTAÇÃO   ADMISSÃO  \\\n",
       "4520  ANAL NEGOCIOS VENDAS           COORD DE MARKETING 2010-09-20   \n",
       "4515    CEDIDO OUTRO ORGAO  GER PLANEJAMENTO E PROJETOS 2009-07-27   \n",
       "\n",
       "      NASCIMENTO  VENCIMENTOS  ENCARGOS  BENEFÍCIOS  OUTRAS REMUNERAÇÕES  \\\n",
       "4520        1959    132297.75  31276.45     3241.64                    0   \n",
       "4515        1956     47874.51      0.00     1660.07                    0   \n",
       "\n",
       "                                                VÍNCULO  \\\n",
       "4520                                          Desligado   \n",
       "4515  Servidor público cedido por outro ente: Servid...   \n",
       "\n",
       "                                       DETALHE VÍNCULO LIMINAR  vl_liquido  \\\n",
       "4520      Concursado NÃO ocupante de cargo em comissão       -   104262.94   \n",
       "4515  Não concursado NÃO ocupante de cargo em comissão       -    49534.58   \n",
       "\n",
       "      anos_trabalhados  \n",
       "4520                 9  \n",
       "4515                11  "
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selecao = (df['MÊS'] == 'Outubro')\n",
    "dfOut = pd.DataFrame(df[selecao])\n",
    "dfOut.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>VÍNCULO</th>\n",
       "      <th>vl_liquido</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CLT: aprendiz</td>\n",
       "      <td>339541.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CLT: contrato por tempo determinado</td>\n",
       "      <td>98083.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CLT: contrato por tempo indeterminado</td>\n",
       "      <td>31326859.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Desligado</td>\n",
       "      <td>653957.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Estagiário</td>\n",
       "      <td>436111.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Estatutário: comitê de auditoria estatutária</td>\n",
       "      <td>43200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Estatutário: conselho administrativo (estatuto...</td>\n",
       "      <td>369600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Estatutário: conselho fiscal (estatuto social)</td>\n",
       "      <td>117600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Estatutário: diretor (estatuto social)</td>\n",
       "      <td>1317659.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Servidor público cedido por outro ente: Servid...</td>\n",
       "      <td>415845.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             VÍNCULO   vl_liquido\n",
       "0                                      CLT: aprendiz    339541.28\n",
       "1                CLT: contrato por tempo determinado     98083.27\n",
       "2              CLT: contrato por tempo indeterminado  31326859.57\n",
       "3                                          Desligado    653957.33\n",
       "4                                         Estagiário    436111.11\n",
       "5       Estatutário: comitê de auditoria estatutária     43200.00\n",
       "6  Estatutário: conselho administrativo (estatuto...    369600.00\n",
       "7     Estatutário: conselho fiscal (estatuto social)    117600.00\n",
       "8             Estatutário: diretor (estatuto social)   1317659.95\n",
       "9  Servidor público cedido por outro ente: Servid...    415845.75"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('VÍNCULO').vl_liquido.sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}