SUS Santa Catarina.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "import pandas as pd\n",
    "import seaborn as sb\n",
    "low_memory=False\n",
    "%matplotlib inline\n",
    "pd.options.display.max_columns = 80\n",
    "pd.options.display.max_rows = 90"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\fmasa\\appdata\\local\\programs\\python\\python37\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3044: DtypeWarning: Columns (7,12,13,16) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "filename = 'fila-publica-2017-11-30.csv'\n",
    "df = pd.read_csv(filename)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1306967, 17)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>POSIÇÃO</th>\n",
       "      <th>TEMPO MÉDIO DE ESPERA(DIAS)</th>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <th>CNES DA UNIDADE SOLICITANTE</th>\n",
       "      <th>CÓDIGO SIGTAP DO PROCEDIMENTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.306967e+06</td>\n",
       "      <td>1.288724e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.306967e+06</td>\n",
       "      <td>1.305728e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.502004e+03</td>\n",
       "      <td>1.942741e+02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.539747e+06</td>\n",
       "      <td>2.414849e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.291319e+03</td>\n",
       "      <td>3.145126e+02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.972460e+06</td>\n",
       "      <td>5.118480e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.925900e+04</td>\n",
       "      <td>2.040601e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.490000e+02</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.418916e+06</td>\n",
       "      <td>2.020602e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.011000e+03</td>\n",
       "      <td>9.900000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.660792e+06</td>\n",
       "      <td>2.060101e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3.351000e+03</td>\n",
       "      <td>1.590000e+02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.465893e+06</td>\n",
       "      <td>3.010101e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.874000e+04</td>\n",
       "      <td>2.019000e+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.362223e+06</td>\n",
       "      <td>7.010701e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            POSIÇÃO  TEMPO MÉDIO DE ESPERA(DIAS)  NASCIMENTO  \\\n",
       "count  1.306967e+06                 1.288724e+06         0.0   \n",
       "mean   2.502004e+03                 1.942741e+02         NaN   \n",
       "std    3.291319e+03                 3.145126e+02         NaN   \n",
       "min    1.000000e+00                 0.000000e+00         NaN   \n",
       "25%    2.490000e+02                 3.100000e+01         NaN   \n",
       "50%    1.011000e+03                 9.900000e+01         NaN   \n",
       "75%    3.351000e+03                 1.590000e+02         NaN   \n",
       "max    1.874000e+04                 2.019000e+03         NaN   \n",
       "\n",
       "       CNES DA UNIDADE SOLICITANTE  CÓDIGO SIGTAP DO PROCEDIMENTO  \n",
       "count                 1.306967e+06                   1.305728e+06  \n",
       "mean                  3.539747e+06                   2.414849e+08  \n",
       "std                   1.972460e+06                   5.118480e+07  \n",
       "min                   1.925900e+04                   2.040601e+07  \n",
       "25%                   2.418916e+06                   2.020602e+08  \n",
       "50%                   2.660792e+06                   2.060101e+08  \n",
       "75%                   5.465893e+06                   3.010101e+08  \n",
       "max                   9.362223e+06                   7.010701e+08  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1306967 entries, 0 to 1306966\n",
      "Data columns (total 17 columns):\n",
      "SERVIÇO                               1306967 non-null object\n",
      "CENTRAL DE REGULAÇÃO/RESPONSÁVEL      1306967 non-null object\n",
      "MUNICÍPIO DE RESIDÊNCIA               1306967 non-null object\n",
      "POSIÇÃO                               1306967 non-null int64\n",
      "TEMPO MÉDIO DE ESPERA(DIAS)           1288724 non-null float64\n",
      "CLASSIFICAÇÃO                         1306967 non-null object\n",
      "TIPO DA LISTA                         1306967 non-null object\n",
      "DOCUMENTO                             1306967 non-null object\n",
      "DATA DA SOLICITAÇÃO                   1306273 non-null object\n",
      "CIDADÃO                               1306967 non-null object\n",
      "NASCIMENTO                            0 non-null float64\n",
      "DESCRIÇÃO DO PROCEDIMENTO             1306967 non-null object\n",
      "CNES DA CENTRAL SOLICITANTE           1306967 non-null object\n",
      "CNES DA CENTRAL EXECUTANTE            1306966 non-null object\n",
      "CNES DA UNIDADE SOLICITANTE           1306967 non-null int64\n",
      "CÓDIGO SIGTAP DO PROCEDIMENTO         1305728 non-null float64\n",
      "DESCRIÇÃO DO GRUPO DO PROCEDIMENTO    724444 non-null object\n",
      "dtypes: float64(3), int64(2), object(12)\n",
      "memory usage: 169.5+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "df.rename(columns={'MUNICÍPIO DE RESIDÊNCIA': 'MUNICÍPIODERESIDÊNCIA',\n",
    "                   'CENTRAL DE REGULAÇÃO/RESPONSÁVEL': 'CENTRALDEREGULAÇÃO/RESPONSÁVEL',\n",
    "                   'TEMPO MÉDIO DE ESPERA(DIAS)': 'TEMPOMÉDIODEESPERA(DIAS)',\n",
    "                   'DATA DA SOLICITAÇÃO': 'DATADASOLICITAÇÃO',\n",
    "                   'DESCRIÇÃO DO PROCEDIMENTO': 'DESCRIÇÃODOPROCEDIMENTO',\n",
    "                   'CNES DA CENTRAL EXECUTANTE': 'CNESDACENTRALEXECUTANTE',\n",
    "                   'CNES DA UNIDADE SOLICITANTE': 'CNESDAUNIDADESOLICITANTE'\n",
    "                  }, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>SERVIÇO</th>\n",
       "      <th>CENTRALDEREGULAÇÃO/RESPONSÁVEL</th>\n",
       "      <th>MUNICÍPIODERESIDÊNCIA</th>\n",
       "      <th>POSIÇÃO</th>\n",
       "      <th>TEMPOMÉDIODEESPERA(DIAS)</th>\n",
       "      <th>CLASSIFICAÇÃO</th>\n",
       "      <th>TIPO DA LISTA</th>\n",
       "      <th>DOCUMENTO</th>\n",
       "      <th>DATADASOLICITAÇÃO</th>\n",
       "      <th>CIDADÃO</th>\n",
       "      <th>NASCIMENTO</th>\n",
       "      <th>DESCRIÇÃODOPROCEDIMENTO</th>\n",
       "      <th>CNES DA CENTRAL SOLICITANTE</th>\n",
       "      <th>CNESDACENTRALEXECUTANTE</th>\n",
       "      <th>CNESDAUNIDADESOLICITANTE</th>\n",
       "      <th>CÓDIGO SIGTAP DO PROCEDIMENTO</th>\n",
       "      <th>DESCRIÇÃO DO GRUPO DO PROCEDIMENTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>858328</th>\n",
       "      <td>Exame</td>\n",
       "      <td>UNIDADE SANITARIA LUCIA ELENA DOS SANTOS</td>\n",
       "      <td>PAULO LOPES</td>\n",
       "      <td>2408</td>\n",
       "      <td>194.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>700903945817494</td>\n",
       "      <td>27/11/2017 16:21:19</td>\n",
       "      <td>K P</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ULTRA-SONOGRAFIA  DE ARTICULACAO OMBRO DIREITO</td>\n",
       "      <td>2419033</td>\n",
       "      <td>2692260</td>\n",
       "      <td>2418975</td>\n",
       "      <td>205020062.0</td>\n",
       "      <td>GRUPO - EXAMES ULTRA-SONOGRAFICOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904137</th>\n",
       "      <td>Consulta</td>\n",
       "      <td>SECRETARIA MUNICIPAL DE SAUDE DE TIMBE DO SUL</td>\n",
       "      <td>TIMBE DO SUL</td>\n",
       "      <td>342</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3 - Verde</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>702500374987234</td>\n",
       "      <td>19/09/2017 13:39:05</td>\n",
       "      <td>N A D S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSULTA EM OFTALMOLOGIA - GERAL</td>\n",
       "      <td>421810</td>\n",
       "      <td>6490212</td>\n",
       "      <td>2647176</td>\n",
       "      <td>301010072.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417564</th>\n",
       "      <td>Exame</td>\n",
       "      <td>CENTRO DE SAUDE ALTO ARIRIU</td>\n",
       "      <td>PALHOCA</td>\n",
       "      <td>194</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2 - Amarelo</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>704509323899014</td>\n",
       "      <td>10/10/2017 15:03:07</td>\n",
       "      <td>L A V</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SECRECAO VAGINAL (BACTERIOSCOPIA)</td>\n",
       "      <td>6082351</td>\n",
       "      <td>6082351</td>\n",
       "      <td>2641542</td>\n",
       "      <td>202080080.0</td>\n",
       "      <td>GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891409</th>\n",
       "      <td>Consulta</td>\n",
       "      <td>SECRETARIA MUNICIPAL DE SAUDE</td>\n",
       "      <td>SALETE</td>\n",
       "      <td>34</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>704504385345719</td>\n",
       "      <td>29/08/2017 10:26:16</td>\n",
       "      <td>A G</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSULTA EM UROLOGIA - ADULTO</td>\n",
       "      <td>421530</td>\n",
       "      <td>6008763</td>\n",
       "      <td>2672715</td>\n",
       "      <td>301010072.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20301</th>\n",
       "      <td>Consulta</td>\n",
       "      <td>REGIAO 08 PRADO</td>\n",
       "      <td>BIGUACU</td>\n",
       "      <td>2562</td>\n",
       "      <td>152.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>708407782077865</td>\n",
       "      <td>02/06/2017 15:10:49</td>\n",
       "      <td>L R R</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSULTA EM OTORRINOLARINGOLOGIA - GERAL</td>\n",
       "      <td>7606907</td>\n",
       "      <td>7606907</td>\n",
       "      <td>3387720</td>\n",
       "      <td>301010072.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543214</th>\n",
       "      <td>Exame</td>\n",
       "      <td>SECRETARIA MUNICIPAL DE SAUDE</td>\n",
       "      <td>CHAPECO</td>\n",
       "      <td>435</td>\n",
       "      <td>19.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>705609444247716</td>\n",
       "      <td>07/08/2017 12:57:36</td>\n",
       "      <td>J A D S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IMITANCIOMETRIA</td>\n",
       "      <td>7974671</td>\n",
       "      <td>7974671</td>\n",
       "      <td>6361315</td>\n",
       "      <td>211070203.0</td>\n",
       "      <td>GRUPO - REABILITAÇÃO AUDITIVA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841236</th>\n",
       "      <td>Consulta</td>\n",
       "      <td>CENTRO DE SAUDE COLONIA SANTANA</td>\n",
       "      <td>SAO JOSE</td>\n",
       "      <td>1548</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Regulada</td>\n",
       "      <td>898002859088921</td>\n",
       "      <td>22/10/2012 13:21:34</td>\n",
       "      <td>M B F</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSULTA EM OFTALMOLOGIA - PLASTICA OCULAR</td>\n",
       "      <td>5908418</td>\n",
       "      <td>2692260</td>\n",
       "      <td>2663791</td>\n",
       "      <td>301010072.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113888</th>\n",
       "      <td>Exame</td>\n",
       "      <td>REGIAO 02 MARCOS ANTONIO</td>\n",
       "      <td>BIGUACU</td>\n",
       "      <td>1405</td>\n",
       "      <td>184.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Fila única</td>\n",
       "      <td>705002898842457</td>\n",
       "      <td>24/10/2017 10:36:43</td>\n",
       "      <td>R C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EAS - SUMARIO DE URINA</td>\n",
       "      <td>420230</td>\n",
       "      <td>7606907</td>\n",
       "      <td>3387453</td>\n",
       "      <td>202050017.0</td>\n",
       "      <td>GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1280263</th>\n",
       "      <td>Cirurgia eletiva</td>\n",
       "      <td>CENTRAL DE REGULACAO MUNICIPIO DE CHAPECO</td>\n",
       "      <td>CHAPECO</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 - Verde</td>\n",
       "      <td>Fila única</td>\n",
       "      <td>705009843766259</td>\n",
       "      <td>22/08/2017 09:52:09</td>\n",
       "      <td>A R F D S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TRANSFERENCIA MUSCULAR / TENDINOSA NO MEMBRO I...</td>\n",
       "      <td>420420</td>\n",
       "      <td>6361315</td>\n",
       "      <td>7974671</td>\n",
       "      <td>408050390.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1241845</th>\n",
       "      <td>Exame</td>\n",
       "      <td>CENTRO DE SAUDE PALHOCA CENTRAL UNIDADE MISTA ...</td>\n",
       "      <td>PALHOCA</td>\n",
       "      <td>10182</td>\n",
       "      <td>127.0</td>\n",
       "      <td>4 - Azul</td>\n",
       "      <td>Fila única</td>\n",
       "      <td>705002870108554</td>\n",
       "      <td>24/10/2017 08:23:18</td>\n",
       "      <td>M D S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TGP</td>\n",
       "      <td>6082351</td>\n",
       "      <td>6939392</td>\n",
       "      <td>2418398</td>\n",
       "      <td>202010651.0</td>\n",
       "      <td>GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  SERVIÇO                     CENTRALDEREGULAÇÃO/RESPONSÁVEL  \\\n",
       "858328              Exame           UNIDADE SANITARIA LUCIA ELENA DOS SANTOS   \n",
       "904137           Consulta      SECRETARIA MUNICIPAL DE SAUDE DE TIMBE DO SUL   \n",
       "417564              Exame                        CENTRO DE SAUDE ALTO ARIRIU   \n",
       "891409           Consulta                      SECRETARIA MUNICIPAL DE SAUDE   \n",
       "20301            Consulta                                    REGIAO 08 PRADO   \n",
       "543214              Exame                      SECRETARIA MUNICIPAL DE SAUDE   \n",
       "841236           Consulta                    CENTRO DE SAUDE COLONIA SANTANA   \n",
       "113888              Exame                           REGIAO 02 MARCOS ANTONIO   \n",
       "1280263  Cirurgia eletiva          CENTRAL DE REGULACAO MUNICIPIO DE CHAPECO   \n",
       "1241845             Exame  CENTRO DE SAUDE PALHOCA CENTRAL UNIDADE MISTA ...   \n",
       "\n",
       "        MUNICÍPIODERESIDÊNCIA  POSIÇÃO  TEMPOMÉDIODEESPERA(DIAS)  \\\n",
       "858328            PAULO LOPES     2408                     194.0   \n",
       "904137           TIMBE DO SUL      342                      60.0   \n",
       "417564                PALHOCA      194                      23.0   \n",
       "891409                 SALETE       34                      38.0   \n",
       "20301                 BIGUACU     2562                     152.0   \n",
       "543214                CHAPECO      435                      19.0   \n",
       "841236               SAO JOSE     1548                     199.0   \n",
       "113888                BIGUACU     1405                     184.0   \n",
       "1280263               CHAPECO        1                       NaN   \n",
       "1241845               PALHOCA    10182                     127.0   \n",
       "\n",
       "        CLASSIFICAÇÃO TIPO DA LISTA        DOCUMENTO    DATADASOLICITAÇÃO  \\\n",
       "858328       4 - Azul      Regulada  700903945817494  27/11/2017 16:21:19   \n",
       "904137      3 - Verde      Regulada  702500374987234  19/09/2017 13:39:05   \n",
       "417564    2 - Amarelo      Regulada  704509323899014  10/10/2017 15:03:07   \n",
       "891409       4 - Azul      Regulada  704504385345719  29/08/2017 10:26:16   \n",
       "20301        4 - Azul      Regulada  708407782077865  02/06/2017 15:10:49   \n",
       "543214       4 - Azul      Regulada  705609444247716  07/08/2017 12:57:36   \n",
       "841236       4 - Azul      Regulada  898002859088921  22/10/2012 13:21:34   \n",
       "113888       4 - Azul    Fila única  705002898842457  24/10/2017 10:36:43   \n",
       "1280263     3 - Verde    Fila única  705009843766259  22/08/2017 09:52:09   \n",
       "1241845      4 - Azul    Fila única  705002870108554  24/10/2017 08:23:18   \n",
       "\n",
       "           CIDADÃO  NASCIMENTO  \\\n",
       "858328         K P         NaN   \n",
       "904137     N A D S         NaN   \n",
       "417564       L A V         NaN   \n",
       "891409         A G         NaN   \n",
       "20301        L R R         NaN   \n",
       "543214     J A D S         NaN   \n",
       "841236       M B F         NaN   \n",
       "113888         R C         NaN   \n",
       "1280263  A R F D S         NaN   \n",
       "1241845      M D S         NaN   \n",
       "\n",
       "                                   DESCRIÇÃODOPROCEDIMENTO  \\\n",
       "858328      ULTRA-SONOGRAFIA  DE ARTICULACAO OMBRO DIREITO   \n",
       "904137                    CONSULTA EM OFTALMOLOGIA - GERAL   \n",
       "417564                   SECRECAO VAGINAL (BACTERIOSCOPIA)   \n",
       "891409                       CONSULTA EM UROLOGIA - ADULTO   \n",
       "20301             CONSULTA EM OTORRINOLARINGOLOGIA - GERAL   \n",
       "543214                                     IMITANCIOMETRIA   \n",
       "841236          CONSULTA EM OFTALMOLOGIA - PLASTICA OCULAR   \n",
       "113888                              EAS - SUMARIO DE URINA   \n",
       "1280263  TRANSFERENCIA MUSCULAR / TENDINOSA NO MEMBRO I...   \n",
       "1241845                                                TGP   \n",
       "\n",
       "        CNES DA CENTRAL SOLICITANTE CNESDACENTRALEXECUTANTE  \\\n",
       "858328                      2419033                 2692260   \n",
       "904137                       421810                 6490212   \n",
       "417564                      6082351                 6082351   \n",
       "891409                       421530                 6008763   \n",
       "20301                       7606907                 7606907   \n",
       "543214                      7974671                 7974671   \n",
       "841236                      5908418                 2692260   \n",
       "113888                       420230                 7606907   \n",
       "1280263                      420420                 6361315   \n",
       "1241845                     6082351                 6939392   \n",
       "\n",
       "         CNESDAUNIDADESOLICITANTE  CÓDIGO SIGTAP DO PROCEDIMENTO  \\\n",
       "858328                    2418975                    205020062.0   \n",
       "904137                    2647176                    301010072.0   \n",
       "417564                    2641542                    202080080.0   \n",
       "891409                    2672715                    301010072.0   \n",
       "20301                     3387720                    301010072.0   \n",
       "543214                    6361315                    211070203.0   \n",
       "841236                    2663791                    301010072.0   \n",
       "113888                    3387453                    202050017.0   \n",
       "1280263                   7974671                    408050390.0   \n",
       "1241845                   2418398                    202010651.0   \n",
       "\n",
       "                        DESCRIÇÃO DO GRUPO DO PROCEDIMENTO  \n",
       "858328                   GRUPO - EXAMES ULTRA-SONOGRAFICOS  \n",
       "904137                                                 NaN  \n",
       "417564   GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)  \n",
       "891409                                                 NaN  \n",
       "20301                                                  NaN  \n",
       "543214                       GRUPO - REABILITAÇÃO AUDITIVA  \n",
       "841236                                                 NaN  \n",
       "113888   GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)  \n",
       "1280263                                                NaN  \n",
       "1241845  GRUPO - PATOLOGIA CLINICA (EXAMES DE LABORATORIO)  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x250f8e38eb8>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAcIAAAD8CAYAAADkH6QsAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAFNNJREFUeJzt3X2QZXV95/H3RwYGdGBAQTPgVgaSWQIhiDASXC0iimQV82DEMGxSQoyym4ddNbtxYU1pSEqdgMlSVlIKGiOVVVARI6sxQEBEkQVnZGR4NKCjPEoUM44PGMDv/nFOM5dOd9956Hv7tr/3q+rWPfd3fuec7+1zuz99nu5JVSFJUquetNAFSJK0kAxCSVLTDEJJUtMMQklS0wxCSVLTDEJJUtMMQklS0wxCSVLTDEJJUtOWLHQBGm7fffetlStXLnQZkrSorF+//ptVtd+wfgbhIrBy5UrWrVu30GVI0qKS5Gvb0s9do5KkphmEkqSmGYSSpKYZhJKkphmEkqSmGYSSpKYZhJKkphmEkqSmGYSSpKYZhJKkphmEkqSmGYSSpKYZhJKkphmEkqSmGYSSpKYZhJKkpnlj3kVg472bWXnGJxe6DEkaq01rTxzLctwilCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXN2zABSR4DNg40XVRVaxeqHknS+BiEnR9U1RELXYQkafzcNTqLJMuT3JHk4P71hUle2w+/K8m6JLckOWtgmk1J3pbkun78kUkuS3JXkv8y0O8Pk3whyU2D00uSxs8g7OyRZMPA4+Sq2gz8PvD+JGuAfarqPX3/N1XVauBw4BeSHD4wr7ur6rnAZ4H3AycBxwB/ApDkBGAVcDRwBHBUkmPH8B4lSTNw12hnxl2jVXVFklcCfwU8a2DUryc5ne7ntwI4FLipH3dp/7wRWFZVW4AtSR5OsjdwQv+4se+3jC4Yrxlcdj//0wF22Wu/nX+HkqQZGYRzSPIk4BDgB8BTgXuSHAj8D+A5VfXtJO8Hdh+Y7If9848GhqdeLwECvL2qzptr2VV1PnA+wNIVq2rn340kaSbuGp3bG4DbgFOA9yXZFdgL+B6wOckzgJds5zwvA16dZBlAkgOSPH0ea5YkbQe3CDt7JNkw8PofgPcBrwGOrqotSa4B/qiq3pLkRuAW4CvAtduzoKq6PMkhwHVJAL4L/Cbw4Dy8D0nSdkqVe90m3dIVq2rFqecudBmSNFab1p64U9MnWd+f2Dgnd41KkppmEEqSmmYQSpKaZhBKkppmEEqSmmYQSpKaZhBKkppmEEqSmmYQSpKaZhBKkppmEEqSmmYQSpKaZhBKkprmbZgWgZ87YDnrdvJb2CVJM3OLUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1DSDUJLUNINQktQ0g1CS1LQl29Ipye7ATwMF3FVVD4+0KkmSxmTOLcIkS5KcDdwDXAD8H+DuJGcn2XUcBUqSNErDtgjPAfYEDqyqLQBJ9gLe0T9eN9ryBLDx3s2sPOOTC12GtM02rT1xoUuQttmwY4QvA147FYIAVfUd4HeAl46yMEmSxmFYEFZV1QyNj9EdL5QkaVEbFoS3JnnV9MYkvwncPpqSJEkan2HHCH8PuCTJq4H1dFuBzwH2AF4+4tokSRq5OYOwqu4Ffj7JC4GfBQJ8qqquHEdxkiSN2pxBmOQ5wL5V9SngqoH2XwLuq6r1I65PkqSRGnaM8Bzgthnab+vHSZK0qA0LwqdV1abpjVV1J7Ayyd8k+dxIKpMkaQyGBeEec42sqt8CnjJ/5UiSNF7DgvAfk7w1SQYbk5wF/GP/8vkjqUySpDEYdvnEfwfeC9yZZEPf9ixgHfAagKr63ujKkyRptIZdPvE94JQkB9FdPgFwS1V9ZeSVSZI0BsMunzhy4OW9/fPeU+1V9cVRFSZJ0jgM2zX653OMK+CF81jLSCT5CeBcum/E+SGwCXh9VX15hMtcCXyiqg5LcgSwf1X9/aiWJ0naccOC8ISqemQslYxAf5LPx4ALqmpN33YE8AxgZEE4zRHAasAglKQJNOys0XuTvCfJcdPPHF0kjgMeqap3TzVU1Qbgc0nOSXJzko1JTgZI8oIkVye5OMntST4w9b6TrE1ya5Kbkryjb3t/kpOm5p3ku4MLT7Ib8CfAyUk2JDk5ydFJPp/kxv754NH/GCRJsxm2RXgIcBLwZuBvk1wMXFhV14+8svlxGN2XhU/3a3Rbas8C9gW+kOSaftyz6U4Mug+4FnheklvpvmT8Z6qqkuy9LQuvqn9N8mZgdVX9Pjx+Y+Njq+rRJMcDbwNescPvUJK0U+bcIqyqb1XVeVV1HHA08FXg3CR3JXnrWCocjefTBfpjVfUN4DN0xxABbqiqe6rqR8AGYCXwHeBh4L1Jfg34/k4seznwkSQ3A/+brWfjPkGS05OsS7Luse9v3onFSZLmMmzX6OOq6j7gr4F3AVvoryOccLcAR83QPtdu3h8ODD8GLKmqR+n+Efgo8KvAP/TjH6X/Gfa7UHfbhpr+FPh0VR0G/BKw+0ydqur8qlpdVat3efLybZitJGlHDA3CJLsneWWSS4C7gBcBZwL7j7q4eXAVsDTJa6ca+jtqfJvuuN0uSfYDjgVumG0mSZYBy/szP19Pt1sVujNQp4L2V4BdZ5h8C7DnwOvlbL0U5bTtfD+SpHk27DrCDwLHA9cAHwT+U1U9PI7C5kN/PO/ldLtzz6DbvbmJLsyWAV+iuwzkjVX1QJKfmWVWewIfT7I73dbkG/r29/TtNwBXAjN9y86ngTP6b+Z5O3A2cEGSP2Dg1laSpIWRqpp9ZHIqcElVbRlfSZpu6YpVteLUcxe6DGmbbVp74kKXIJFkfVWtHtZv2MkyFwDfT7LvwIx360/kmOk+hZIkLSpzBmGSNcBDwE1JPpPkOOArwEuA3xhDfZIkjdSw6wj/CDiqqu7sv1/0OmBNVX1s9KVJkjR6w84a/df+bvRTX7D9VUNQkvTjZNgW4dP7sxunLBt8XVV/MZqyJEkaj2FB+B6eeA3c9NeSJC1qw27Me9a4CpEkaSEMO2v0wwPDfzZt3OWjKkqSpHEZdrLMqoHhF08bt9881yJJ0tgNC8LZv3Zm7nGSJC0Kw06WeXKSZ9MF5h79tYTQfd/mHiOtTJKkMRgWhPcDf04XfA8A7xgY98CoipIkaVyGBeH/BO6uqvvh8S/hfgXdHRz+eKSVSZI0BsPuPvFF4PiqeijJscBFwH+lux/fIVV10njKbNvq1atr3bp1C12GJC0q23r3iWFbhLtU1UP98MnA+VX1UeCj/f31JEla1IadNbpLkqmwfBFPvJHssBCVJGniDQuzC4HPJPkm8APgswBJfhrYPOLaJEkauWFfsfbWJFcCK4DLa+sBxSfRHSuUJGlRG7p7s6r+3wxtXx5NOZIkjdewY4SSJP1YMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTVuy0AVouI33bmblGZ+cs8+mtSeOqRpJ+vHiFqEkqWkGoSSpaQahJKlpBqEkqWkGoSSpaQahJKlpBqEkqWkGoSSpaQahJKlpBqEkqWkGoSSpaQahJKlpBqEkqWkGoSSpaSMLwiQ/keSiJHcluTXJ3yf590n2T3LxCJe7Osk752le3x0yfu8kvzvweqTvTZI0/0YShEkCfAy4uqp+qqoOBf4X8Iyquq+qTpphmm2+N2KSXWYbV1Xrquq/7UjdO2Bv4PEgnO29SZIm16i2CI8DHqmqd081VNWGqvpskpVJbgZIclqSjyT5v8DlSV6Q5BNT0yT5yySn9cObkrw5yeeAVyZ5TpKbklyX5JyBeT4+jyRHJ/l8khv754NnKjbJHyb5Qj+/s7ajz1rgp5Js6GsYfG/XJ/nZgemvTnLUttYkSRqPUd2h/jBg/Tb2fS5weFU9lOQFQ/o+XFXPB+gD5/Sq+nyStbP0vx04tqoeTXI88DbgFYMdkpwArAKOBgJcmuTYqrpmWB/gDOCwqjqi77dyYNYXAb8OvCXJCmD/qlqfZK9hNUmSxmdUQbg9rqiqh7ax74egOzYH7FlVn+/bPwi8bIb+y4ELkqwCCth1hj4n9I8b+9fL6ELvmm3o8/U5av0wcAXwFrpA/Mh21ESS04HTAXbZa785FiNJ2hmjCsJbgG09Vva9geFHeeLu2t1n6ZttnPefAp+uqpf3W2tXz9AnwNur6rw55jNjn2lbgE9QVfcm+VaSw4GTgf+8HTVRVecD5wMsXbGq5qhNkrQTRnWM8CpgaZLXTjX0x/R+Ych0XwMOTbI0yXLgRTN1qqpvA1uSHNM3rZllfsuBe/vh02bpcxnw6iTL+joPSPL0beyzBdhzjvdzEfBGYHlVbdyOmiRJYzKSIKyqAl4OvLi/fOIW4I+B+4ZMdzfdLsWbgA+wdVfkTH4bOD/JdXRbbJtn6HM28PYk1wIznmlaVZfT7Vq9LslG4GKmhdtsfarqW8C1SW5Ocs4Ms7+YLqQ/vD01SZLGJ11mLT5JllXVd/vhM4AVVfW6BS5rJJauWFUrTj13zj6b1p44pmokaXFIsr6qVg/rNwkny+yoE5OcSfcevoa7GSVJO2DRBmFVfYj+LFJJknaU3zUqSWqaQShJappBKElqmkEoSWqaQShJappBKElqmkEoSWqaQShJappBKElqmkEoSWqaQShJatqi/a7RlvzcActZ590lJGkk3CKUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNc0glCQ1zSCUJDXNIJQkNS1VtdA1aIgkW4A7FrqOGewLfHOhi5jFpNZmXdtnUuuCya3Nurb6yarab1inJeOoRDvtjqpavdBFTJdk3STWBZNbm3Vtn0mtCya3Nuvafu4alSQ1zSCUJDXNIFwczl/oAmYxqXXB5NZmXdtnUuuCya3NuraTJ8tIkprmFqEkqW1V5WNCH8B/pLts4k7gjHme9/uAB4GbB9qeClwB/FP/vE/fHuCdfR03AUcOTHNq3/+fgFMH2o8CNvbTvJOtex9mXEY/7t8BnwZuA24BXjcJdfXjdwduAL7U13ZW334gcH0/3YeA3fr2pf3rO/vxKwfmdWbffgfwi8PW92zLmFbfLsCNwCcmpS5gU/+z3gCsm5R12ffZG7gYuJ3u8/bcha4NOLj/WU09vgO8fqHr6se/ge5zfzNwId3vw4J/xubt7+EoZupjHlZM94ftLuAgYDe6P8CHzuP8jwWO5IlBePbUhxA4A/izfvilwKf6X7xjgOv79qcCX+mf9+mHp35Jb6D745J+2pfMtYz+9YqpX2ZgT+DLwKELXVffFmBZP7xr/8t5DPBhYE3f/m7gd/rh3wXe3Q+vAT7UDx/ar8ul/S/5Xf26nnV9z7aMafX9AfBBtgbhgtdFF4T7Tmtb8HXZt18AvKYf3o0uGCeitoHf/weAn1zouoADgK8Cewys99NmW/+M+bM/L38PRzFTH/OwYroP62UDr88EzpznZazkiUF4B7CiH15Bd/0iwHnAKdP7AacA5w20n9e3rQBuH2h/vN9sy5ilvo8DL57Aup4MfBH4eboLhJdMX2fAZcBz++Elfb9MX49T/WZb3/00My5joO8zgSuBFwKfmGuaMde1iX8bhAu+LoG96P6wZ9JqG5jmBODaSaiLLgjvpgvWJXSfsV+cbf0zxs/YfD08Rji5pj58U+7p20bpGVV1P0D//PQhtczVfs8M7XMt4wmSrASeTbflNRF1JdklyQa6XcpX0P0X+y9V9egM83u8hn78ZuBpO1Dz0+ZYxpRzgTcCP+pfzzXNOOsq4PIk65Oc3rdNwro8CPhn4G+S3JjkvUmeMiG1TVlDtwtyrmnGUldV3Qu8A/g6cD/dZ2Y9k/EZmxcG4eTKDG019io6s9Wyve3btrBkGfBR4PVV9Z1JqauqHquqI+i2wI4GDpljfvNV25w1J3kZ8GBVrR8YP9c0Y6mr97yqOhJ4CfB7SY6dYZop41yXS+gOC7yrqp4NfI9ud+Ak1EaS3YBfBj4yrOs46kqyD/ArdLsz9weeQrdOZ5vXOD9j88IgnFz30J08MuWZwH0jXuY3kqwA6J8fHFLLXO3PnKF9rmXQt+1KF4IfqKpLJqWuQVX1L8DVdMdl9k4y9VWFg/N7vIZ+/HLgoR2o+ZtzLAPgecAvJ9kEXES3e/TcCaiLqrqvf34Q+BjdPw+TsC7vAe6pquv71xfTBeMk1AZdyHyxqr4xZJpx1XU88NWq+ueqegS4BPgPTMBnbL4YhJPrC8CqJAf2/yGuAS4d8TIvpTvbjP754wPtr0rnGGBzv/vkMuCEJPv0/zWeQLcP/35gS5JjkgR41bR5zbQM+r5/DdxWVX8xKXX1te2XZO9+eA+6Pw630Z3letIstU3N7yTgquoOdFwKrEmyNMmBwCq6ExhmXN/9NLMtg6o6s6qeWVUr+2muqqrfWOi6kjwlyZ5Tw/06uHmOn/PY1mVVPQDcneTgvulFwK2TUFvvFLbuFp1rmnHV9XXgmCRP7qeb+nkt6GdsXo3iwKOP+XnQnRX2ZbpjUW+a53lfSLe//xG6/8h+m26f/JV0pypfCTy17xvgr/o6NgKrB+bzarpTnu8EfmugfTXdH767gL9k62naMy6jH/d8ul0fN7H1FPKXLnRd/fjD6S5PuKmf/s19+0F0v8x30u3KWtq3796/vrMff9DAvN7UL/8O+rP25lrfsy1jhnX6AraeNbqgdfXjvsTWy03eNNfPeZzrsu9zBLCuX59/R3d25YLXRnci1reA5QNtk1DXWXSXmtwM/C3dmZ8T89nf2YffLCNJapq7RiVJTTMIJUlNMwglSU0zCCVJTTMIJUlNMwglSU0zCCVJTTMIJUlN+//1qT5HCy3XgQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('SERVIÇO').size().sort_values().plot(kind='barh')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x25080076ef0>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAvoAAAJCCAYAAACxhmPNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzs3XucXWV97/HPl6AxCERRhIjKCAao3GJIvVC8oGi1oQLeIMoRrJZ6qvVWFERs0faUVNDitR68FPAoYOUiQi9aIV5pIcFACFcjEUVbDbbRSEQNv/PHXoMr2z2zh8xMJtnzeb9e+5W1nudZz/qtNfnjN8/81tqpKiRJkiQNlm2mOgBJkiRJE89EX5IkSRpAJvqSJEnSADLRlyRJkgaQib4kSZI0gEz0JUmSpAFkoi9JkiQNIBN9SZIkaQCZ6EuSJEkDaNupDkCaTI985CNraGhoqsOQJEnqa9myZWuqaueJms9EXwNtaGiIpUuXTnUYkiRJfSX57kTOZ+mOJEmSNIBM9CVJkqQBZKIvSZIkDSATfUmSJGkAmehLkiRJA8i37migrbhrLUMnXzHVYUiSpK3U6sULpzqETeaKviRJkjSATPQlSZKkAWSiLwCSbEiyPMmNSf4xyXatvqOSVJJ9Wm1DSW7sMc85SV7S1bautb1vkiuT3Jbk9iTvTJJW/wuSLE1yc5JbkpzZNdf1Sc6fqOuWJEkaVCb6Gra+quZV1X7AL4HXtvoWAV8HjhnPCZLMAi4DFlfVXsCBwMHAnzb9+wEfAo6tqt8B9gO+0zr+d+j8n31GkoeOJxZJkqRBZ6KvXr4GPAEgyfbA7wGvZpyJPvBy4BtV9UWAqroHeD1wctP/NuD/VNUtTf+vq+ojXcd/Cvgi8MJxxiJJkjTQTPS1kSTbAi8AVjRNRwL/UlW3AT9JMn8M05zRlAEtT7K81b4vsKw9sKpWAdsn2ZHOCv5G/V2OBi4EzqfzVwZJkiSNwERfw2Y1SflS4E7gE037IuCCZvsCxpZgv7UpA5pXVfNa7QFqhGNGau8cmPwu8OOq+i7wZWB+koePMPaEps5/6YZ71o4hXEmSpMHje/Q1bH1XUk6SRwDPBvZLUsAMoJK8bRPPsRJ4Rtc59gDWVdXPkqwEDgKu73HsImCfJKub/R2BFwMf7x5YVWcDZwPMnDN31F8gJEmSBpUr+hrNS4Dzqmr3qhqqqscCdwCHbOJ8nwYOSXIY3P9w7geA9zT9ZwCnJNmr6d8myVuSbAO8FDigiWMIOALLdyRJkkZkoq/RLAIu6Wq7iM5DsQB7J/l+6/PS0SarqvV0EvRTk9xK5zmAa+m8aYequgF4E3B+kpuBG4E5dP4KcFdV3dWa7qvAE5PMGdcVSpIkDahUWdmgwTVzztyac9xZUx2GJEnaSq1evHCznSvJsqpaMFHzuaIvSZIkDSATfUmSJGkA+dYdDbT9d5vN0s34JzdJkqQthSv6kiRJ0gAy0ZckSZIGkIm+JEmSNIBM9CVJkqQBZKIvSZIkDSATfUmSJGkAmehLkiRJA8hEX5IkSRpAJvqSJEnSADLRlyRJkgaQib4kSZI0gEz0JUmSpAG07VQHIE2mFXetZejkK6Y6DGmLsHrxwqkOQZK0GbmiL0mSJA0gE31JkiRpAJno635J3pFkZZIbkixP8pRW385JfpXkT7qOmZ3kvCSrms95SWaPMP+61va+Sa5McluS25O8M0mavl2SXJ7k+iQ3Jfmnpn0oyfomtuHPKyfnbkiSJG3dTPQFQJKnAYcD86vqAOAw4HutIS8F/h1Y1HXoJ4DvVNWeVbUncAfw8T7nmgVcBiyuqr2AA4GDgT9thrwb+FJVHVhVTwRObh2+qqrmtT7nbcr1SpIkDToTfQ2bA6ypqnsBqmpNVf2g1b8I+HPgMUl2A0jyBOAg4K9a494NLEiy5yjnejnwjar6YnOue4DX85uEfg7w/eHBVXXDeC5MkiRpOjLR17AvAo9tSmk+kuSZwx1JHgvsWlXXAJ8Fjm66nggsr6oNw2Ob7eXAvqOca19gWbuhqlYB2yfZEfgw8IkkVzXlRI9uDd2zq3Tn6Zt+yZIkSYPLRF8AVNU6OqvzJwA/Bi5McnzTfQydBB/gAn5TvhOgekw3UvtY+quq/hXYA/gYsA/wrSQ7N/3dpTtf+63JkxOSLE2ydMM9a0cJQ5IkaXD5Hn3dr1mNXwIsSbICOA44h05iv0uSVzRDH51kLrASeFKSbarqPoAk29Cpub95lFOtBJ7RbkiyB7Cuqn7WxPIT4DPAZ5Jc3oxf1j3RCNdxNnA2wMw5c0f7hUOSJGlguaIvAJLs3STvw+YB302yN/DQqtqtqoaqagg4HTimqr4NfAs4tXXcqcB1Td9IPg0ckuSw5tyzgA8A72n2n51ku2Z7B2BP4M6JuE5JkqTpwkRfw7YHzm1eZ3kDnfr70+is5l/SNfYiflO+82pgryTfTrIK2Ktp20iSbYHhB33XA0cApya5FVgBXAt8qBl+ELC0ieNq4ONVdW3T112j/4YJuHZJkqSBkyorGzT5khwIfKyqnrw5zztzztyac9xZm/OU0hZr9eKFUx2CJGkUSZZV1YKJms8VfU26JK8FzmfjEh9JkiRNIh/G1aSrqo8CH53qOCRJkqYTE30NtP13m81SyxUkSdI0ZOmOJEmSNIBM9CVJkqQBZKIvSZIkDSATfUmSJGkAmehLkiRJA8hEX5IkSRpAJvqSJEnSADLRlyRJkgaQib4kSZI0gEz0JUmSpAFkoi9JkiQNIBN9SZIkaQBtO9UBSJNpxV1rGTr5iqkOQ9PU6sULpzoESdI05oq+JEmSNIBM9CVJkqQBZKIvSZIkDSAT/S1Ekg1Jlrc+Q0meleTyHmMfnOSsJKuS3J7k80ke02OuG5N8IcnDmvahJDd2zfX+JHcl2abVdnyS+5Ic0Gq7MclQsz07yXnN+Vc127Nb51jfnP+mJB8dnjvJvkmuTHJbE/c7k6R1zg/1uNbVSR7ZbL8jycokNzTzP2U891ySJGmQmehvOdZX1bzWZ/UoY/8G2AHYq6rmApcCFw8nza259gN+Aryu1yRNAn4U8D3gGV3d3wfeMcL5PwF8p6r2rKo9gTuAj7f6V1XVPOAA4InAkUlmAZcBi6tqL+BA4GDgT0e5znasTwMOB+ZX1QHAYU3ckiRJ6sFEfyuTZDvgVcCbq2oDQFX9A3Av8Oweh1wN7DbCdIcCNwJ/Dyzq6rsc2DfJ3l3nfwJwEPBXreZ3AwuS7NkeW1W/Br4JPAF4OfCNqvpi03cP8Hrg5NGut2UOsKaq7m2OX1NVPxjjsZIkSdOOif6WY1arbOeSUcY9Abizqn7a1b4U2LfdkGQG8Bw6K+m9LALOBy4BDk/yoFbffcB7gFO6jnkisHz4lwyAZnt5j/Nv15x/RdO3rN1fVauA7ZPsOEJ8bV8EHtuU/XwkyTNHGpjkhCRLkyzdcM/aMUwtSZI0eEz0txzt0p2jRhkXoPq0z0qyHLgb2An40m8NTh4M/AFwafNLw38Az+sa9hngqUke/wDPv2dz/m8AV1TVP49yHKO0/2ZA1To6f0k4AfgxcGGS40cYe3ZVLaiqBTO2m91vakmSpIHkF2Ztfb4N7J5kh6r6Wat9PvCFZnt9Vc1rHpC9nE6N/ge65nk+MBtY0ZT2bwfcA9z/7VJV9esk7wVOah23EnhSkm2q6j64v9b/QODmZsxwjT5dx230HECSPYB1VfWz3zxeMLLmLwdLgCVJVgDHAef0PVCSJGkackV/K1NVPwfOBd7XlOaQ5JV0EvUru8auBd4AnNhVlgOdsp3XVNVQVQ0Bjwee15TbtJ1D58HXnZs5vw18Czi1NeZU4LqmbySfBg5JclgT8yw6v3y8ZwyXTZK9k8xtNc0DvjuWYyVJkqYjE/0t33OSfL/1eRrwduAXwG1JbgdeChxVVb9VAlNV3wKuB44ZbmuS+d9n49X7nwNfB/6w6/hf0knIH9VqfjWwV5JvJ1kF7NW0jaiq1gNHAKcmuZVO3f61QPuVmsd3XetjWn3bA+c2r+y8gc6zAqeNdk5JkqTpLD1yQ2lgzJwzt+Ycd9ZUh6FpavXihVMdgiRpK5JkWVUtmKj5XNGXJEmSBpAP42qg7b/bbJa6qipJkqYhV/QlSZKkAWSiL0mSJA0gE31JkiRpAJnoS5IkSQPIRF+SJEkaQCb6kiRJ0gAy0ZckSZIGkIm+JEmSNIBM9CVJkqQBZKIvSZIkDSATfUmSJGkAmehLkiRJA8hEX5IkSRpA2051ANJkWnHXWoZOvmKqw9BWbvXihVMdgiRJD5gr+pIkSdIAMtGXJEmSBpCJvkiya5ILkqxKclOSf0qyV5L1SZY3becleVAz/llJLm8d/4IkS5PcnOSWJGc27aclObHZXpJkQeuYoSQ3tuarJK9u9T+paTux1bZtkjVJTp/8uyJJkrR1M9Gf5pIEuARYUlV7VtUTgVOAXYBVVTUP2B94DPCyHsfvB3wIOLaqfgfYD/jOJoSyAji6tX8McH3XmOcBtwIva+KWJEnSCEz0dSjwq6r66HBDVS0Hvtfa3wBcA+zW4/i3Af+nqm5pxv66qj6yCXHcCTwkyS5NEv984J+7xiwC3t+MfeomnEOSJGnaMNHXfsCy0QYkeQjwFOBfNuX4B+BzwEuBg4HrgHtbMcwCngNcDpxPJ+kfKd4TmlKipRvuWTtBoUmSJG1dTPQ1mj2TLAfuBu6sqhvGMVeNoe2zdBL9RXSS+bbDgauq6h7gIuCoJDN6nqjq7KpaUFULZmw3exwhS5Ikbb1M9LUSOGiEvuEa/ScAT03ywgd4fNvdwMNb+zsBa9oDquo/gV8BzwW+3HX8IuCwJKvp/AXhEXTKjiRJktSDib6uBGYm+ePhhiS/C+w+vF9VPwROBt7e4/gzgFOS7NUcu02St/QYtwQ4tvUQ7XHAVT3G/QVwUvNcwHA8OwKHAI+rqqGqGgJexyjlO5IkSdOdif40V1UFHAU8t3m95krgNOAHXUMvBbZL8vSu428A3gScn+Rm4EZgTo9TnQ38DLg+yfXA9sCZPeL5ZlVd2tX8IuDKqrq31fZ54IVJZo7tSiVJkqaXdPI8aTDNnDO35hx31lSHoa3c6sULpzoESdI0kGRZVS3oP3JsXNGXJEmSBtC2Ux2ANJn23202S12NlSRJ05Ar+pIkSdIAMtGXJEmSBpCJviRJkjSATPQlSZKkAWSiL0mSJA0gE31JkiRpAJnoS5IkSQPIRF+SJEkaQCb6kiRJ0gAy0ZckSZIGkIm+JEmSNIBM9CVJkqQBZKIvSZIkDaBtpzoAaTKtuGstQydfMdVhaBKsXrxwqkOQJGmL5oq+JEmSNIBM9CVJkqQBZKI/DSTZkGR5kuuTXJfk4KZ9KMmNPcYvSbKgtX//uCTPSlJJXt3qf1LTdmKzf06SO5pzLk/yzab9+CT3JTmgdeyNSYZ6zPX7vc7fajtt+HySJEn6bSb608P6qppXVQcCbwdOH+d8K4CjW/vHANd3jXlrc855VXVwq/37wDtGmXsR8PXmX0mSJG0iE/3pZ0fgv8c5x53AQ5LskiTA84F/HuOxlwP7Jtm7u6OZ6yXA8cDzkjxknHFKkiRNWyb608OspoTmFuDjwF9NwJyfA14KHAxcB9zb1X9Gq3Tn0632+4D3AKf0mPP3gDuqahWwBPiDCYhTkiRpWjLRnx6GS3f2obP6fl6zej6SGkPbZ+kk+ouA83uMb5fuvKKr7zPAU5M8vqt9EXBBs30Bvynf6RXPiO1JTkiyNMnSDfesHeFQSZKkwWaiP81U1dXAI4GdRxl2N/Dw1v5OwJquef4T+BXwXODLDzCGXwPvBU4abksyA3gx8BdJVgMfBF6QZIce8fSMqTX/2VW1oKoWzNhu9gMJTZIkaWCY6E8zSfYBZtBJnkeyBDi2tep/HHBVj3F/AZxUVRs2IZRzgMP4zS8chwHXV9Vjq2qoqnYHLgKOrKp1wA+TPKe5hp3o/GXi65twXkmSpGnBb8adHmYlWd5sBziuqjY0efzeSb7fGvtm4GxgH+D6JAUspfO2no1U1TdHOecZSU5t7T+569hfJvkA8P6maRFwSdccFwH/G/gU8Ergw0ne2/S9q6nllyRJUg+pGqn8Wdr6zZwzt+Ycd9ZUh6FJsHrxwqkOQZKkCZVkWVUt6D9ybCzdkSRJkgaQpTsaaPvvNpulrvxKkqRpyBV9SZIkaQCZ6EuSJEkDyERfkiRJGkAm+pIkSdIAMtGXJEmSBpCJviRJkjSATPQlSZKkAWSiL0mSJA0gE31JkiRpAJnoS5IkSQPIRF+SJEkaQCb6kiRJ0gAy0ZckSZIG0LZTHYA0mVbctZahk6+Y6jA0RqsXL5zqECRJGhiu6EuSJEkDyERfkiRJGkAm+tpIkg1Jlie5Psl1SQ5u2oeS3Nga9+QkS5Lc3oy7Isn+Td85SV7SNe+6rv03J/lFktld7U9O8tUktya5JcnHk2yX5LQkJ3aNXZ3kkRN9DyRJkgaBNfrqtr6q5gEk+X3gdOCZ7QFJdgE+C7y8qr7ZtB0C7AmsGON5FgHXAkcB57Tm/UfgmKq6OkmAFwM7jPOaJEmSph1X9DWaHYH/7tH+euDc4SQfoKq+XlWXjmXSJHsC2wOn0kn4h72umffqZs6qqs9V1X9t6gVIkiRNV67oq9usJMuBhwBzgGf3GLMvcO44zrEIOB/4GrB3kkdV1Y+A/cY5ryRJkhqu6Kvb+qqaV1X7AM8HzmtKaEaU5D+S3Jzk/U1T9RjWbjsGuKCq7gMuBl46hrh6zdmzPckJSZYmWbrhnrVjmFqSJGnwmOhrRE0JzSOBnbu6VgLzW+OeArwTGH6w9m7g4cP9SXYC1jTbBwBzgS8lWU0n6R8u31kJHDRCOBvN2dgB+J8ecZ9dVQuqasGM7WZ3d0uSJE0LJvoaUZJ9gBl0kuy2DwPHD7+Rp7Fda3sJcHSSBzf7xwNXNduLgNOqaqj5PBrYLcnuwIeA45I8pRXDsUl2Bb4KvDDJDk37i4Drq2rDBFyqJEnSwLFGX92Ga/QBAhxXVRva1TtV9Z9Jjgb+NsluwI/orNi/u+m/PMlBwLIkG4BVwGubw48BXtB1zkvovGnnb5McA5yZ5FHAfXQS/Iubc34I+HqSas75mgm/ekmSpAGRqpFKn6Wt38w5c2vOcWdNdRgao9WLF051CJIkTZkky6pqwUTNZ+mOJEmSNIAs3dFA23+32Sx1lViSJE1DruhLkiRJA8hEX5IkSRpAJvqSJEnSADLRlyRJkgaQib4kSZI0gEz0JUmSpAFkoi9JkiQNIBN9SZIkaQCZ6EuSJEkDyERfkiRJGkAm+pIkSdIAMtGXJEmSBpCJviRJkjSAtp3qAKTJtOKutQydfMVUhzEtrV68cKpDkCRpWnNFX5IkSRpAJvqSJEnSADLRFwBJdk1yQZJVSW5K8k9J9kpyY9e405Kc2NrfNsmaJKd3jVuS5NYk1yf5RpK9u9qXN5/PtY55ZZIbk6xsYjixaU+SU5PcnuS2JFcl2Xdy74gkSdLWzURfJAlwCbCkqvasqicCpwC7jOHw5wG3Ai9r5ml7RVUdCJwLnNHVPq/5vKSJ4QXAm4DnVdW+wHxgbTP+dcDBwIFVtRdwOnBZkodsyvVKkiRNByb6AjgU+FVVfXS4oaqWA98bw7GLgPcDdwJPHWHMV4En9Jnn7cCJVfWD5vy/qKqPNX0nAX9WVfc0fV8Evgm8YgzxSZIkTUu+dUcA+wHLRujbM8ny1v6uwJkASWYBzwH+BHgYnaT/6h5z/CGworX/6STrm+0vVdVbR4ohyY7AQ6tqVVfXUsDyHUmSpBGY6KufVVU1b3gnyWmtvsOBq6rqniQXAe9M8uaq2tD0Dyf0q4E/ax33iqpaOs64AlTPjuQE4ASAGTvuPM7TSJIkbZ0s3RHASuCgTThuEXBYktV0VuMfQacMaNhwLf6RVdWvDKhnDFX1U+DnSfbo6poP3NRroqo6u6oWVNWCGdvNHuOlSJIkDRYTfQFcCcxM8sfDDUl+F9h9pAOakppDgMdV1VBVDdF5aHbRJsZwOvCeJLs2889M8oam7wzgA02pEEkOa879mU08lyRJ0sCzdEdUVSU5CjgrycnAL+iU27xplMNeBFxZVfe22j5PJ1mf2eeU7Rr9NVV1WFX9U5JdgH9r3t5TwCebMR8EHg6sSLIB+E/giKpa/1szS5IkCYBU9SxzlgbCzDlza85xZ011GNPS6sULpzoESZK2KkmWVdWCiZrP0h1JkiRpAJnoS5IkSQPIGn0NtP13m81SS0gkSdI05Iq+JEmSNIBM9CVJkqQBZKIvSZIkDSATfUmSJGkAmehLkiRJA8hEX5IkSRpAJvqSJEnSADLRlyRJkgaQib4kSZI0gEz0JUmSpAFkoi9JkiQNIBN9SZIkaQBtO9UBSJNpxV1rGTr5iqkOY4u0evHCqQ5BkiRNIlf0JUmSpAFkoi9JkiQNIBN9SZIkaQCZ6IskG5IsT3J9kuuSHNy0DyVZ3/TdlOS8JA9q+o5P8qGueZYkWdBs/1GSFUluSHJjkiOa9iQ5NcntSW5L8pUkB7TmWNc15/3nSXJakruaeIY/D5vcuyNJkrR18mFcAayvqnkASX4fOB14ZtO3qqrmJZkBfAl4GfDp0SZL8hjgHcD8qlqbZHtg56b7dcDBwIFVdU+S5wFfSPLEqvr5GGL9u6o684FeoCRJ0nTjir667Qj8d3djVW0ArgF2G8McjwJ+Bqxrjl1XVXc0fScBf1ZV9zR9XwS+Crxi/KFLkiRpmCv6ApiVZDnwEGAO8OzuAUkeAjwFeOMY5rse+C/gjiRfBi6uqi8k2RF4aFWt6hq/FHjiGGN9c5Jjm+3/rqpDe8R6AnACwIwdd+7uliRJmhZc0Rc0pTtVtQ/wfOC8JGn69mx+CbgbuLOqbmjaa4S5qln9fz7wEuA24O+SnDbK+TNKX/e5/q6JdV6vJL8J4OyqWlBVC2ZsN7vP1JIkSYPJRF8bqaqrgUfym5r6VU39/hOApyZ5YdN+N/DwrsN3AtY081RVXVNVpwPHAC+uqp8CP0+yR9dx8+ms6gOsT/LgXnNKkiRp7Ez0tZEk+wAz6CTy96uqHwInA29vmq4Ffi/Jrs1xC4CZwPeSPDrJ/Nbh84DvNttnAB9IMqs57jBgX+BzTf9XgGObvll0Hv69aiKvUZIkaTqwRl/wmxp96JTRHFdVG35TvXO/S4HTkjy9qr6W5I3APyXZhs6Dt4uq6r7mFZxnJnk08Avgx8Brmzk+CDwMuKEZ92Bgv6r6RdP/RuD/JnlDE8t5VfXVVgztGn2AI6tq9fhvgSRJ0mBJ1Uil1tLkal67eQlwbVWdMhnnmDlnbs057qzJmHqrt3rxwqkOQZIktSRZVlULJmo+V/Q1ZapqHfDcqY5DkiRpED3gRD/JnsAi4Jiq2m/iQ5Imzv67zWapK9eSJGkaGtPDuEnmJHlTkmuAlXQe1lw0qZFJkiRJ2mSjJvpJ/jjJlXTehPJI4DXAD6vqXVW1YnMEKEmSJOmB61e682HgauDlVbUUIIlP70qSJElbuH6J/qOBlwLvS7IL8FngQZMelSRJkqRxGbV0p6rWVNXfV9UzgOcAa4EfJbk5yd9slgglSZIkPWBj/mbcqvp+VZ1ZVQcBRwD3Tl5YkiRJksZj1NKdJC8apduHcSVJkqQtVL8a/T8cpa+AiycwFkmSJEkTZNREv6petbkCkSRJkjRx+r1H/y1JXt2j/c+SvGnywpIkSZI0Hv0exv0j4FM92s9u+iRJkiRtgfol+lVVv+zReC+QyQlJkiRJ0nj1exiXJLtU1X91t01eSNLEWXHXWoZOvmKznGv14oWb5TySJElj0W9F/wzgiiTPTLJD83kW8AXgzEmPTpIkSdIm6ffWnfOS/Bh4N7Bf03wj8JdV9c+THZwkSZKkTdO3dKdJ6E3qJUmSpK1Iv9dr/sUon3eO58RJdknymSTfSbIsydVJjmr1H5LkmiS3NJ8TmvZnJbm6a65tk/xXkjlJzklyR5LlzeebzZjjk/y4abslyZtbx5+W5J4kj2q1res6x1FJKsk+rbahJOuTfCvJzU28x3Udd2SSG5pzrkhyZKuvHev1SZ4zyv06sZnjxmbsK5v2JUlubV3v51rXdGKPed6RZGUT0/IkT2naH5zkrCSrktye5PNJHjNCLKuba7khyVeS7D7Ge1VJ/qrV9sgkv0ryoVbbCa2f+TVJDmn1Hd7c6+uT3JTkT0a6X5IkSdNdvxr9n/f4ALwaOGlTT5okwKXAV6tqj6o6CDgGeEzTvyvwGeC1VbUPcAjwJ0kWAl8FHpNkqDXlYcCNVfXDZv+tVTWv+RzcGndhVc0Dfg94R5LHtvrWAH8+StiLgK83cbatqqonVdXvNH1vTvKq5joOpPMswxHNdbwQODPJAa3j39rE9CbgoyPcr9cCzwWeXFX7Ac9g47cevaJ1vS8Z6QKSPA04HJhfVQfQuW/fa7r/BtgB2Kuq5tL5+Vzc/Kx6ObSZYwlwalffSPfqO835h70UWNmK73DgT4BDmvv1WuAzSXZN8iA6r3X9w6o6EHhSc25JkiT1MGqiX1XvHf7QSbJmAa8CLgD2GMd5nw38sqruT2yr6rtV9cFm93XAOVV1XdO3BngbcHJV3Qf8I3B0a75jgPPHevKquhv4NjCn1fxJ4OgkO3WPT7I9nV8OXs1vJ6/teb8DvAV4Q9N0IvA3VXVH038HcDrw1h6HXw3sNsLUpwB/WlU/beZZW1XnjniBI5sDrGlej0pVramqHyTZjs7P9c1VtaHp+wfgXjo/q9FsFHefe7UeuDnJgmb/aOCzrf6T6Pzis6aJ4TrgXDr/H3agU2p2d9N3b1Xd+gCuXZIkaVrpt6JPkp2S/DVwA51Ea35VnVRVPxrHefcFruvTv6yrbWnTDp2k/pgmvpnAHwAXtcae0Spl+XT35EkeBzyEzjUNW0cn2X9jj3iOBP6lqm4DfpJk/iixXwcMl6z0u46259NZRe+OdQdgh6paNco5P9263jNGGfdF4LFJbkvykSTPbNqfANw5/IvEGGIdLe5+9+oC4JimLGgD8INW34j3q6p+AlwGfDfJ+UlekaTn/9+tP/x7AAAgAElEQVSm/GdpkqUb7lnbJ3xJkqTB1K9G/wzgWuBnwP5VdVpV/fdEB5Hkw03d9bXDTUD1GFoAVXUtsH2SvYEXAP/eFVe7dOcVrfajk6ykU0Ly/qr6Rdf8HwCOS7JjV/siOgkqzb+LRrucru3u6+huOyPJd4D/R6d8ptd8ve5FW7t0p9dfCwCoqnXAQcAJwI+BC5McP8o5Rjv3VUl+RKf85zOt9n736l/olCEtAi4c7aK6Y6iq1wDPAa6h89eST/Y6oKrOrqoFVbVgxnazx3AKSZKkwdNvRf/PgUfTqcH+QZKfNp+fJele/X0gVgL3r/RW1evoJHA7t/oXdB1zEHBTa/8COqv6D6Rs58Kq2hd4OvDe5lmA+1XV/9BJWv90uC3JI+iUr3w8yWo6ZTdHj1K7/iTg5lGuY37XdbyVzor6qXTKVDbSrLL/PMl4SqXa822oqiVV9ZfA64EX0ylj2r3568FosbYdCuxO5xrfDWO7V803LS+j83/roq45b6Lzcx4xhqpaUVV/R+eXhReP5ZolSZKmo341+ttU1ayq2qGqdmx9dqiq7lXvB+JK4CFJ/nerbbvW9oeB45PMg/sTyL8F3tMacz5wLJ3E8rIHcvKquhr4FL3LdN5H54HQ4VePvgQ4r6p2r6qhqnoscAedB4Q30jwgfCYw/KzBmcDbhx8cbv49BXhvVzz3Ae8Htkny+z1iOh348PBfGpLsmOYtRA9Ekr2TzG01zQO+W1U/p/NLxvuSzGjGvpLOz+TKkearqvV0HiJ+ZfNsw1jv1XuBk5pnJdreA/xt8/Om+fkfD3wkyfbpfFnbRrGP/eolSZKml36lO89ubT++q+9Fm3rSqio6tdzPTOf1ktfQSTRPavp/SCeJ/1iSW4BvAp+sqi+05rgJuAe4sklU29o1+suTPLhHGH8LvKp7Fbt5EPQSYGbTtKjZb7sIeHmzvWfzyseb6TxY+sHmQVaqanlzTV9oruMLwNua9l735K/pPHTc7e+Bq4Brk9wIfKW59mHtGv1/a7WfmuT7wx9ge+Dc5tWUNwBPBE5rxr4d+AVwW5Lb6bwR56gmrhE1P6vz6Tww2+9eDR+zstfDxFV1GZ1ynG829+tjwLHNOQK8Lc2rRIF30fklQJIkST2kVx7XlFrMBS6oqvlN23XD2732pS3RzDlza85xZ22Wc61evHCznEeSJA2mJMuqqrvse5ONtKL/j8BD+e0HSxllX5IkSdIWYtsR2offdNJe7u9e+u/3Jhhpyu2/22yWutIuSZKmoZES/ZfSKd3ZI8lldBL/4W2a/cePcKwkSZKkKdYz0W/eAnNrkiNazWd2DevelyRJkrSFGGlFH4Cq+srwdpKdm7YfT3ZQkiRJksan3+s1k+Qvk6wBbqHz6sUfJ/mLzROeJEmSpE3R75tx30Tny45+t6oeUVUPB54C/F6SN096dJIkSZI2Sb9E/5XAoqq6Y7ihqr5D58usXjmZgUmSJEnadP0S/Qc13xS7kaZO/0GTE5IkSZKk8eqX6P9yE/skSZIkTaFR37oDHJjkpz3aAzxkEuKRJEmSNAH6vV5zxuYKRJIkSdLEGTXRT7LTaP1V9ZOJDUeSJEnSROhXurMMKDqlOt0K2GPCI5IkSZI0bv1Kdx6/uQKRJEmSNHH6le7sDvxPVa1t9g8FjgRWAx+uKt+8oy3airvWMnTyFZM2/+rFCydtbkmSpPHo93rNzwIPBUgyD/hH4E5gHvCRyQ1NkiRJ0qbqV6M/q6p+0GwfC3yyqt6bZBtg+eSGJkmSJGlT9VvRbz+E+2zgywBVdd+kRaStXpJ1SfZPsrz5/CTJHc32v7XGvTnJL5LMbrU9K8nlXfN9PsnVXW2nJTlx8q9GkiRp69RvRf/KJJ8Ffgg8HLgSIMkc/GZcjaKqVtAp8SLJOcDlVfW5rmGLgGuBo4Bzes2T5GHAfGBdksdX1R2TFbMkSdIg6bei/ybgYjoP3x5SVb9q2ncF3jGJcWnAJdkT2B44lU7CP5IXA18ALgCO2QyhSZIkDYR+if7eVXVBVf0dsGa4saq+Bayd1Mg06BYB5wNfA/ZO8qg+485n9F8I7pfkhCRLkyzdcI//TSVJ0vTUL9H/TGv76q4+37qj8TgGuKB53uNi4KXdA5LsAjwB+HpV3Qb8Osl+/SauqrOrakFVLZix3ex+wyVJkgbSA3kYt/vbcXt9W67UV5IDgLnAl5KsppP091qtP5rOsyF3NOOGsHxHkiRpTPol+jXCdq99aawWAadV1VDzeTSwW/MFbd3jnj88DjgIE31JkqQx6ffWncck+QCd1fvhbZr93SY1Mg2yY4AXdLVd0rQvA+5NMgQ8Dvj34QFVdUeSnyZ5ymaKU5IkaavVL9F/a2t7aVdf974EQFVt37V/fNf+43sc8xaAJG8EVlXVanr8MllV85vN/5igcCVJkgbSqIl+VZ07Ul+PMgtpXJJ8AtgPeNlUxyJJkrS1S9XopfZJnkZnZfWrVfWj5kHKk4GnV9VjN0OM0iZbsGBBLV3qH58kSdKWL8myqlowUfON+jBukjOAT9L50qIrkvwl8CU6ZRNzJyoISZIkSROrX43+QuBJVfWLJA8HfgAcUFW3T35okiRJkjZVv9drrq+qXwBU1X8Dt5rkS5IkSVu+fiv6eya5rLU/1N6vqhdOTliSJEmSxqNfon9E1/57JysQSZIkSROnX6L/rar6aa+OJI+bhHgkSZIkTYB+NfpLhjeSfLmr79IJj0aSJEnShOiX6Ke1vdMofZIkSZK2IP0S/Rphu9e+JEmSpC1Evxr9RyV5C53V++Ftmv2dJzUySZIkSZusX6L/MWCHHtsAH5+UiCRJkiSN26iJflW9a3MFIkmSJGni9KvRJ8mhSS5KsrL5fC7JszZDbJIkSZI20agr+kkWAh8C3t18AswHPpnk9VX1T5MforTpVty1lqGTr5jweVcvXjjhc0qSJE2kfjX6bwWOrKrrW23LkywFPgiY6EuSJElboH6lO7t2JfkAVNUNwC6TE5IkSZKk8eqX6P98E/tI8o6mpv+GJMuTPKXVt3OSXyX5k65jVie5qLX/kiTnJHlVM8fyJL9MsqLZXtyMO7I5zy1N35F9Yrs+yfldbeckuSfJDq229yepJI9stR3VtO3TahtKsr6J6aYk5yV5UKv/kCTXNPHdkuSEEeI6PsmPk3wrye1J/jXJwV1jtk2yJsnpo1zfOUle0mwvSXJnkrT6L02yboTYP5pkm6724c8rm2NWN/f5hiRfSbJ71/k3ukdJ9m/N8ZMkdzTb/zbavUvyrCSXN9v/0BXL6iT/NdI9kCRJmu76le7smeSyHu0B9hjpoCRPAw4H5lfVvU2i/ODWkJcC/w4sAv5v1+ELkuxbVSuHG6rqH4B/aOZeDRxaVWua/QOBM4HnVtUdSR4PfCnJd5q/PHTH9jt0fsF5RpKHVlX7F5ZvA0cA/y/JNsChwF1dUywCvg4cA5zWal9VVfOSzAC+BLwM+HSSXYHP0CmBuq65F/+a5K6q6lU8fmFVvb6J9VDg4iSHVtXNTf/zgFuBlyU5parG8sVl/wP8HvD1JA8D5nT1D8e+LXAlcCRw3XD7CHMeWlVrkrwLOBX441bfRveoqlYA85prOge4vKo+1+wPMcK9a5+sql41vN38bJYA543h2iVJkqalfiv6RwDv7fE5k04yOJI5wJqquhegqtZU1Q9a/YuAPwcek2S3rmPPBE4Z8xXAicDfVNUdzbnuAE6n83xBLy8HPgV8EXhhV9/5wNHN9rOAbwC/Hu5Msj2dhPnVdJLY31JVG4BrgOHreh1wTlVd1/SvAd4GnNzvwqrqKuBsoP0XgEXA+4E7gaf2m6NxQSveFwEXj3C+XwPfBJ4wxnkBruY31zqmezSSHvduJKfQ+f/ldzlIkiSNYNREv6q+UlVfAf4DuBtYA/xHq30kXwQem+S2JB9J8szhjiSPpVP7fw3wWX6TWA/7LDA/yViTzX2BZV1tS5v2Xo4GLqST1C/q6rsd2DnJw5u+C7r6jwT+papuA36SZH735EkeAjwF+JdNjK/bdcBwCcws4DnA5SPEP5Iv0/kLxgw6yfeFvQYl2a6Zf0XTtGdXuczTexz2fODS1n7fezSSHveu15gnA69pPpIkSRrBqIl+Uw/+HuD7wLnA/wO+l+Q97Rr0blW1DjiIzkr0j4ELkxzfdB9DJ5mHTiLdnaxuAM4A3j7GawjQXb7Sq40kvwv8uKq+Syf5nd8k9W0XNzE+BfhaV187+e+Ofc8ky+n8QnRnq2yoZywjtPWS1vbhwFVVdQ9wEXBUk7z3s4FOKc3RwKyqWt3VPxz7N4Arquqfm/ZVVTWv9Wnfj6uS/Ag4jE5p0rDR7tFIRrp3G2n+WvAp4NVV9ZORJktyQpKlSZZuuGftGE4vSZI0ePqV7pwB7AQ8vqoOqqonAXsCD6NTYjOiqtpQVUuq6i+B1wMvbroWAcc3tfaXAQcmmdt1+KeAZwCPG8M1rAQWdLXNB27qMXYRsE9z7lXAjq24hl0A/BXwpaq6b7gxySOAZwMfb45/K3B06yHX4Xr2JwBPTTJcFtQrvoNGiK+XJwHD9fmLgMOa8y8DHkHnOYKxuIDOK1E/26NvOKF/UlWdNsb5DgV2p3N974Yx3aORjHTvun0QuKyqvjzaZFV1dlUtqKoFM7abPcbLkSRJGiz9Ev3DgT+uqp8NN1TVT4H/DfzBSAcl2bsreZ8HfDfJ3sBDq2q3qhqqqiE69fQb1XJX1a+AvwPeNIZrOBN4e/NQ5/DDnafQeZagHdM2dB4CPqB17iPoWnGuqjuBdwAf6TrPS4Dzqmr35vjHAncAh3Qd/0M69ffDf5H4MJ1fbIYfRn0E8LfAe/pdWFPydALwsSQ7Nud6XCv+13XHP4qv0bnX5/cbOFZVtZ7Oz+iVSXZijPdolPm679390nmL0IF0fjaSJEnqo1+iX73e6tI8NDla6cn2wLnN6xJvAJ5I5w01i4BLusZeRO9k9RP0fysQVbUcOAn4QpJbgC8Ab2va254B3FVV7bfofBV4YpKN3kJTVf+3qlZ1HT9S7C/vEdalwHZJnt4kr8fSSdZvofOw6yer6gsjXNLRTT38bXR+YXlx88adFwFXDj/g3Pg88MIkM0eYq31NVVVnDr+taIy6a/Tf0GPeH9L55WH4l46x3qOR3H/vutr/D7AzcE1XTLMewNySJEnTRkZ7O2OSS4GLq+q8rvZjgZdV1UglFtIWYeacuTXnuLMmfN7VixdO+JySJGl6S7KsqrpLvjdZvxXz19F5j/sf0akJL+B3gVnAURMVhCRJkqSJNeqK/v2DkmfTeR1kgJX9HoaUthQLFiyopUuXTnUYkiRJfW3WFf3mAUuA5c1no/bRXnEoSZIkaer0K93p/qKn4eX/4XfD7zHhEUmSJEkat1ET/ap6/OYKRJIkSdLE6ffNuI9KclaSy5P8TfMud0mSJElbuH7v0T8P+DmdbyTdAfjApEckSZIkadz61ejvWlXD30T6r0mum+yAJEmSJI1fv0Q/SR5O5+FbgBntfd+6I0mSJG2Z+iX6s+m8eSettuFVfd+6I0mSJG2h+r11Z2gzxSFJkiRpAvVM9JOcBrwLeNJoB1eVNfuSJEnSFmikFf0bgJcDrxnl2AKePeERSZIkSRq3nol+VV3cbH56M8YiSZIkaYL0+8KsY5P8rx7tf5zk5ZMXliRJkqTxSFWN3Jl8C3hGVf2sq31H4KqqOmiS45PGZeacuTXnuLMmdM7VixdO6HySJEkASZZV1YKJmq/fN+PO6E7yAarqp8CDJioISZIkSROrX6L/oCQP7W5MsgPw4MkJSZIkSdJ49Uv0PwF8LsnQcEOzfUHTpwGRZF3z775JrkxyW5Lbk7wzSZq+45N8qNk+Lck9SR7VY44lSX6/a/43JflIkqEkNzZtz0pyeY9YliRZ0NX2rCRrkyxvfQ6b6PsgSZI0KEZN9KvqTODzwFeS3J3kbuArwOVVdcbmCFCbT5JZwGXA4qraCzgQOBj40xEOWQP8eY/284FjutqOadrH42tVNa/1+bdxzidJkjSw+q3oU1Ufrardgd2Boaravar+fvJD0xR4OfCNqvoiQFXdA7weOHmE8Z8Ejk6yU1f754DDk8yE+/8K9Gjg65MQsyRJknoY6QuzAEjylh5t929X1fsmISZNnX2BZe2GqlqVZPvmTUvd1tFJ9t8I/GXrmLuTXAM8n85fhI4BLqyqav//2QRPT7K8tf/iqlo1ngklSZIG1aiJPrDDZolCW4rQ+cbjXkZq/wCwPMl7u9qHy3eGE/0/moD4vlZVh/cblOQE4ASAGTvuPAGnlSRJ2vqMmuhX1bs2VyDaIqwEntFuSLIHsK6qftZrNb6q/ifJZ/jtOv5LgfclmQ/MqqrrJinmXjGdDZwNnffob67zSpIkbUn6le78xSjdVVV/NcHxaGp9GjglyWFV9W/Nw7kfAN7T57j3AdfS+v9UVeuSLKFT2jPeh3AlSZL0APV7GPfnPT4ArwZOmsS4tBkl2Ra4t6rWA0cApya5FVhBJ4H/0GjHV9Ua4BJgZlfX+XTe3HPBKIc/J8n3W5+nNe1XtNr+sWl7etfrNV/ywK5UkiRp+kjV2Cobmi/JeiOdJP+zwHur6keTGJs2kyQHAh+rqidPdSwTbeacuTXnuLMmdM7VixdO6HySJEkASZZV1YL+I8em7+s1k+yU5K+BG+iUZsyvqpNM8gdDktfSWXk/dapjkSRJ0sTpV6N/BvAiOg827l9V6zZLVNpsquqjwEenOg5JkiRNrFFLd5LcB9wL/JqNX68YOg/j9nq3urTFWLBgQS1dunSqw5AkSeprokt3+r1es29pjyRJkqQtT7/SnZ26mgr4nxrrE7ySJEmSpkS/b8ZdRie5b39T0g5JlgOvqarVkxWYJEmSpE3Xr3Tn8b3ak7yIzgOcz5+MoCRJkiSNzybV4FfVxcCjJjgWSZIkSRNkkxL9JNtv6rGSJEmSJl+/h3Hf0qP54cALgQ9NSkSSJEmSxq3fw7g7dO0X8J/AsVW1YnJCkiRJkjRe/R7GfdfmCkSSJEnSxOlXunPZaP1V9cKJDUeSJEnSROhXuvM04HvA+cB/sPH79CVJkiRtofol+rsCzwUWAS8HrgDOr6qVkx2YJEmSpE2XqhrbwGQmnYT/DODdVfXByQxMmggz58ytOcedNSFzrV68cELmkSRJ6iXJsqpaMFHz9VvRH07wF9JJ8oeADwAXT1QAkiRJkiZev4dxzwX2A/4ZeFdV3bhZopIkSZI0Lv1W9P8X8HNgL+ANyf3P4gaoqtpxEmPTViLJuqrafoS+64GbqmpRV/tbgBOAXwH3AV8GTqqqXyVZDfwM2NAM/2pVvSHJU4H3AzObz4VVddokXJIkSfr/7d17nF1lfe/xz5cgYAQjImoIlACmIDdjTKsWREGL1KDIEUsGrGD1oK2el8WqxQPniPa0xmoVrVaL1iJWAauiFMTLESiiCAwaSFC5hAQlonI5BLmIGn7nj71GljuzJ5Mwk8uaz/v12q/Z67mt53lYm/nNs5+1os3e2p6jv8WG6oi6J8lTgS2Ag5I8pqrua9JfBxwKPKuq7k6yFfAm4NH0An+Ag6vqjr4mPwn8aVVdk2QasOcGGYgkSdJmaK179KVH4BjgU8BTgZfQe0wrwMnAQVV1N0BV/QpYNI72ngjc1tRZDXx/ojssSZLUFa7YazIdDZxDL8AfAkiyHbBtVS1fS92LkyxuXic2ae8Hrk9ybpLXJtlm0nouSZK0mTPQ16RI8gfA7VV1C7399/OSbE9zf0er3AubYH5Fkj9qNXFwVc1tXu8HqKp3AvOBr9H7tuArA859QpLhJMOr7181OQOUJEnaxBnoa7IMAXs1N9YuAx4LvKyq7gHuS7IbQFV9tarmAkuBrdbWaFUtq6qPAM8HnpZkh1HKnF5V86tq/rTpMyZuRJIkSZsRA31NuCRbAC8H9q+q2VU1GziCZvsO8C7gI0ke15QPsNZtOEkW5OFHP82h91Seuye4+5IkSZ3gzbiaCNOT3No6fh+wsqpWttIuBfZOMhP4CDAduCLJg8C9wLeA77XKX5xk5PGa11bVK+k97vX9Se4HfgMc29yUK0mSpD4G+nrEBjyG9X19ZVYDM1tJ721eo7U3e0D6wvXsoiRJ0pTj1h1JkiSpgwz0JUmSpA5y6446bb9ZMxhetGBjd0OSJGmDc0VfkiRJ6iADfUmSJKmDDPQlSZKkDjLQlyRJkjrIQF+SJEnqIAN9SZIkqYMM9CVJkqQOMtCXJEmSOshAX5IkSeogA31JkiSpgwz0JUmSpA4y0JckSZI6aMuN3QFpMi1ZuYrZJ12wXnVXLFowwb2RJEnacFzRlyRJkjrIQF+SJEnqIAN9SZIkqYMM9DUuSZ6U5DNJbk5ydZLLkxzZyv9AkpVJtuirc36Sa5J8P8mXm/TZSR5IsrhJ/2hfvROT/DLJjFba85KsSvK9JD9M8t4NNXZJkqTNkYG+1ipJgC8Cl1bV7lX1DGAhsHOTvwVwJPBj4KBW1XcCX6+qp1XV3sBJrbxlVTUX2B/YG3hpK28IuKpps+2bVfV04OnA4UkOmKgxSpIkdY2BvsbjEOBXVfXRkYSquqWq/qk5PBhYCnyEXpA+YiZwa6vOtf0NV9VvgG8DTwFIsgewLXBKX1vtOg8Ai4FZ6z8kSZKkbjPQ13jsA3x3jPwh4CzgXHor7Y9q0j8M/GuSi5OcnGSn/opJpgPPB5b0tfVNYM8kTxylzvbAHODS0TqT5IQkw0mGV9+/alwDlCRJ6hoDfa2zJB9u9t1flWQr4EXAF6vqHuAK4FCAqvoqsDvwMWAv4HtJdmya2SPJYuBbwAVVdWGTvhA4u6oeAr4AvLx16uckuRb4KXB+Vf10tP5V1elVNb+q5k+bPmO0IpIkSZ3nP5il8bgOeNnIQVW9PskTgGHgMGAGsKS3lZ/pwP3ABU3Zu4DPAJ9Jcj69PfxX8/Ae/d9Ksj+9lfqvN21tBdxM75sB6O3RPzzJ7wOXJTm3qhZPzpAlSZI2b67oazwuArZJ8hettOnNzyHgNVU1u6pmA7sBhyaZnuSQZmsOSbYD9gB+NMZ5hoBTR9qqqp2AWUl2bReqqhuAdwF/MxGDkyRJ6iIDfa1VVRW9p+I8N8nyJFcCnwTeDryQZvW+KXsfcBnwYuAZwHCz3eZy4ONVddUYp1pIb59/27lNer+PAgcl2W39RiVJktRt6cVwUjdtPXNOzTzutPWqu2LRggnujSRJ0mBJrq6q+RPVniv6kiRJUgd5M646bb9ZMxh2ZV6SJE1BruhLkiRJHWSgL0mSJHWQgb4kSZLUQQb6kiRJUgcZ6EuSJEkdZKAvSZIkdZCBviRJktRBBvqSJElSBxnoS5IkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHGehLkiRJHbTlxu6ANJmWrFzF7JMuWOd6KxYtmITeSJIkbTiu6EuSJEkdZKAvSZIkdZCBfockOTJJJdmrOZ6d5IEki5N8P8mZSR7VV+cDSVYm2aKVdnyS25t6P0xy4ijnuibJWX1pZzRtbd0cPyHJilb+nCTnJ1mW5OokFyc5qMk7Ncmb+9pbkeQJg8YnSZKkwQz0u2UIuAxY2EpbVlVzgf2AnYE/HclogvsjgR8DB/W1dU5T7wDg5CS7tOo9ld61c1CSx/TVWw38eX/HkmwDXACcXlV7VNUzgP8B7P4IxydJkqRRGOh3RJJt6QXlr2aUQLiqVgNXArNayQcDS4GP0Aui11BVdwI3ATNbyccAnwK+Brykr8ppwIlJ+m/0Pha4vKrOa7W9tKrOWNvYYO3jkyRJ0u8y0O+OlwJfqaobgLuSzGtnNivqzwS+0koeAs4CzgUO79/W09T7PWAb4NpW8tHAOU3d/j8QfkRv1f3P+tL3Ab67jmNqG3N8fX0+IclwkuHV9696BKeUJEnafBnod8cQcHbz/mweDsD3SLIYuBP4UVVdC5BkK+BFwBer6h7gCuDQVntHJ7kOuBn4QFX9sqn3B8DtVXUL8A1gXpLt+/ry98BbGOP6SnJukqVJvtAk1YCiI+mDxrdmharTq2p+Vc2fNn3GoGKSJEmd5nP0OyDJDsAhwL5JCphGL0D+Z5o9+klmApckeUmzfeYwYAawJAnAdOB+evvoobdH/w1Jng1ckOTCqvopvQB7r9ZNto8FXgZ8fKQ/VXVT88fFb+8HAK6jdR9AVR2ZZD7w3ibpTn53exDAdsDdg8aX5K1VNegPBEmSpCnNFf1uOAo4s6p2rarZVbULsJzezbcAVNVtwEnA25qkIeA1TfnZwG7AoUmmtxuuqsvp7cd/Y3Pz7suB/Vv1jmD01fW/A9pP0fkMcECS9p7+9rkuBV6SZDuAJP8NuKa5t2DQ+A4c5/xIkiRNOQb63TBEb5992+eB/9mX9kVgepLnAi/k4dV7quo+envrXzxK++8GXgUsAFZW1cpW3qXA3s03Br9VVdfR2pNfVQ8AhwOvS3JzksuBU4D/0+RfC3wIuKz5NuB1wGvWMr5jRumrJEmSgLjzQV229cw5NfO409a53opFCyahN5IkSYMlubqq5k9Ue67oS5IkSR3kzbjqtP1mzWDY1XlJkjQFuaIvSZIkdZCBviRJktRBBvqSJElSBxnoS5IkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHGehLkiRJHWSgL0mSJHWQgb4kSZLUQQb6kiRJUgcZ6EuSJEkdZKAvSZIkddCWG7sD0mRasnIVs0+6YNzlVyxaMIm9kSRJ2nBc0ZckSZI6yEBfkiRJ6iAD/SkiyZOSfCbJzUmuTnJ5kiNb+R9IsjLJFq2045PcnmRxkh8mObGvzROa9B8muTLJga28S5Jcn+SaJN9Ksmcrb8ckv07y2r72ViRZ0pxvSZIj+vKPTFJJ9prIuZEkSeoiA/0pIEmALwKXVtXuVfUMYNhuf14AABd3SURBVCGwc5O/BXAk8GPgoL7q51TVXOAA4OQkuzR1DgdeCxxYVXsBrwM+k+TJrbrHVtXTgE8C72mlvxz4DjA0SncPbs53FPDBvrwh4LKm75IkSRqDgf7UcAjwq6r66EhCVd1SVf/UHB4MLAU+wujBN1V1J3ATMLNJ+hvgLVV1R5P/XXoB/etHqX4p8JTW8RDw18DOSWYN6PNjgf83cpBkW3p/bLwaA31JkqS1MtCfGvYBvjtG/hBwFnAucHiSR/UXSPJ7wDbAta02r+4rNtyk93sxsKRpZxfgyVV1JfBZ4Oi+shcnWQr8F3BKK/2lwFeq6gbgriTzBg2m2VI0nGR49f2rBhWTJEnqNAP9KSjJh5u981cl2Qp4EfDFqroHuAI4tFX86CTXATcDH6iqX47VNFCt408nWUxvJf7NTdpCegE+wNms+Q3CwVW1L7Af8KFmJZ+m3Nlj1Putqjq9quZX1fxp02eM0V1JkqTu8jn6U8N1wMtGDqrq9UmeQG8F/jBgBrCkt5Wf6cD9wMjD58+pqjckeTZwQZILq+qnwPeBZwAXtc4zr0kfcWxVDff1ZQh4UpJjm+OdksypqhvbhapqWZKfAXsnWUZv+9G+SQqYBlSSt1ZVIUmSpDW4oj81XARsk+QvWmnTm59DwGuqanZVzQZ2Aw5NMr3dQFVdDnwKeGOT9A/Au5PsAJBkLnA88M+DOtE8eecxVTWrdb53Mcqe+yRPbPpyC70bc8+sql2bersAy4ED++tJkiSpx0B/CmhWvV8KPDfJ8iRX0rtx9u3AC3l49Z6quo/ek21ePEpT7wZelWS7qjoP+ATw7SQ/BD4GvKKqbhujK0P07gNo+zy/uw3n4ma7z8XASVX1szHqHTPGuSRJkqa0uPNBXbb1zDk187jTxl1+xaIFk9gbSZKkwZJcXVXzJ6o9V/QlSZKkDvJmXHXafrNmMOwqvSRJmoJc0ZckSZI6yEBfkiRJ6iADfUmSJKmDDPQlSZKkDjLQlyRJkjrIQF+SJEnqIAN9SZIkqYMM9CVJkqQOMtCXJEmSOshAX5IkSeogA31JkiSpgwz0JUmSpA4y0JckSZI6aMuN3QFpMi1ZuYrZJ10w7vIrFi2YxN5IkiRtOK7oS5IkSR1koC9JkiR1kIG+RpXk3iT7JVncvO5Ksrx5/39b5U5M8sskM1ppz0uyKsn3kvwgydv70he3Xi9o8irJp1ptbJnk9iTn9/XrS0kun/wZkCRJ2ry5R18DVdUSYC5AkjOA86vqc33FhoCrgCOBM1rp36yqw5M8BljcCti/WVWHj3K6+4B9kzy6qh4A/hhY2S6Q5HHAPODeJLtV1fJHNEBJkqQOc0Vf6y3JHsC2wCn0Av41VNV9wNXAHuNo8kJg5G7YIeCsvvyXAf8JnA0sXI8uS5IkTRkG+nokRoLxbwJ7Jnlif4EkOwDPAq5rkp7Tt3Wn/QfA2cDCJNsA+wNXDDjfWQz4w0KSJEk9Bvp6JBYCZ1fVQ8AXgJe38p6T5HvA14BFVTUS6H+zqua2XstGKlTVtcBsekH8l9snSvIk4CnAZVV1A/CbJPuO1qkkJyQZTjK8+v5VEzNSSZKkzYx79LVekuwPzAG+ngRgK+Bm4MNNkUF78dfmPOC9wPOAHVrpRwPbA8ub8z2W3h8ap/Q3UFWnA6cDbD1zTq1HHyRJkjZ7ruhrfQ0Bp1bV7Oa1EzArya6PsN1PAO9sbgTuP99hI+cDnoH79CVJkgYy0Nf6Wgic25d2LmsPvvv36B/VzqyqW6vqA+20JLOB3wO+0yq3HLgnyTPXs/+SJEmd5tYdjaqqtu07Pr7veLdR6rypdXjJKPmXADP600c7X6v8SDuzRsmfN1pbkiRJckVfkiRJ6iRX9NVp+82awfCiBWsvKEmS1DGu6EuSJEkdZKAvSZIkdZCBviRJktRBBvqSJElSBxnoS5IkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHGehLkiRJHWSgL0mSJHWQgb4kSZLUQQb6kiRJUgcZ6EuSJEkdtOXG7oA0mZasXMXsky4YV9kVixZMcm8kSZI2HFf0JUmSpA4y0JckSZI6aEoG+klOTnJdkmuTLE7yzFbejkl+neS1fXVmJDkzybLmdWaSGQParySfah1vmeT2JOc3x8cn+VAr/xVNX65Lck2Sjyd5XJO3IskTWmWf19fO7c0YRl57J5mdZOla5uDUJCubOjcm+UKSvVv5WyU5rRnrjUm+lGTnAW0NnJumLw/09fGVTd6fJ1nSjH1pkiOSfLgp8/2+ekclOSPJ8lbat8caoyRJ0lQ25fboJ3k2cDgwr6oebILorVpFXg58BxgC/qWV/q/A0qoaCVLfAXy8Kd/vPmDfJI+uqgeAPwZWDujPYcCJwJ9U1cok04DjgCcBd49jSOdU1Rv62pw9jnoA76+q9zZ1jgYuSrJfVd0O/D2wHfD7VbU6yauALyR5ZlVVXztrm5tlVTW3r487AyfT+++wKsm2wI5V9aXWGM5v10tyOPCWqvrcOMcnSZI0ZU3FFf2ZwB1V9SBAVd1RVT9p5Q8Bfw3snGQWQJKnAM8A/rZV7p3A/CR7DDjPhcDI3Z1DwFkDyp0MvLmqVjb9WV1Vn6iq69d9aOuvqs4BvgYck2Q68CrgxKpa3eT/G/AgcEi73nrODcATgV8A9zbt31tVyydoOJIkSVPeVAz0vwbskuSGJP+c5LkjGUl2AZ5cVVcCnwWObrL2BhaPBL3QC8iBxcA+A85zNrAwyTbA/sAVA8rtA3z3EYzn6L5tMY9+BG19F9gLeArwo6q6py9/mDXHO5652aOvj88BrgF+BixP8m9JXjzOPr6n1c6n1214kiRJU8eUC/Sr6l56K9AnALcD5yQ5vsleSC/Ah16gPtS8D9C/XWWsdKrqWmB208aXx9O3JPs1AeyyZisNA9pvp51TVXNbrwfGc65BXWj9HO94x1N2WV8fv9n8MXAYcBRwA/D+JKeOo49vabVz7KiDSE5IMpxkePX9q8bRpCRJUvdMuUAffrs95pKqejvwBuBlTdYQcHySFcB5wNOSzAGuA56e5Lfz1bx/GvCDMU51HvBeBm/boWl7XtOvJc2e9AuBkZX5O4HtW+UfD9wxnnGuh6fTG89NwK5JtuvLnwd8vy9tfeeG6rmyqt5F74+sl41Vfryq6vSqml9V86dNH/V+aUmSpM6bcoF+kj2b4H3EXOCWJHsCj6mqWVU1u6pmA+8CFlbVTcD3gFNa9U4BvtvkDfIJ4J1VtWSMMu8C3tv3RJv29ptLgD9r+j4NeAVw8VhjXB9JXgYcCpxVVfcBnwTe15yT5kk504GL2vXWd26S7JRkXitpLnDLRIxFkiRJU/CpO8C2wD81j6/8Db3V6xPoreyf21f28/S28Pwt8Oqm3k30tqVc3qQNVFW3Ah9YS5kvJ9kRuLAJqu8GlgJfbYr8LfCRJNc05/0K8O+tJo5OcmDr+C+BnwB7Jrm1lX5iVf1H3+lPTPIK4DHNOQ9pnrgD8DZ630bckOQh4IfAkaM8cQfWPjd7JFncOv4E8CV6f+DsBPyS3jaq143Sdr/3JGn/UfGHVfWrcdSTJEmaUjJ63CZ1w9Yz59TM404bV9kVixasvZAkSdIkSXJ1Vc2fqPam3NYdSZIkaSow0JckSZI6aCru0dcUst+sGQy7JUeSJE1BruhLkiRJHWSgL0mSJHWQgb4kSZLUQQb6kiRJUgcZ6EuSJEkdZKAvSZIkdZCBviRJktRBBvqSJElSBxnoS5IkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHbbmxOyBNpiUrVzH7pAvWWm7FogUboDeSJEkbjiv6kiRJUgcZ6EuSJEkdZKAvSZIkdZCB/hSXZIcki5vXT5OsbN7fneT7fWVPTfLm5v0ZSZY3ZX+Y5O19ZXdM8uskr+1LX5FkSZJrk/xXkl378o9MUkn26kvfJ8lFSW5IcmOS/5UkEzsbkiRJ3WGgP8VV1Z1VNbeq5gIfBd7fvJ8LPLSW6m9plT0uyW6tvJcD3wGGRql3cFXtD1wCnNKXNwRcBiwcSUjyaOA8YFFV/T7wNOCPgL8c3yglSZKmHgN9TYRtmp/3tdKGgL8Gdk4ya0C9y4Hf5iXZFjgAeDWtQB84BvhWVX0NoKruB94AnDQhvZckSeogA309Eu9Jshi4FTi7qn4OkGQX4MlVdSXwWeDoAfUPA77YOn4p8JWqugG4K8m8Jn0f4Op2xapaBmyb5LH9jSY5IclwkuHV9696BMOTJEnafBnoa5AaR/rI1p0nA89P8kdN+kJ6AT7A2ay5fefiJD8HXgB8ppU+1JTvr5dx9qeXUHV6Vc2vqvnTps8YUE2SJKnb/AezNMidwPZ9aY8HlvcXrKp7k1wCHAh8m16A/qQkxzZFdkoyp6pubI4PprfN5wzgncCbkuwAHALsm6SAaUAleStwHXBQ+5xJdgfurapfPNKBSpIkdZEr+hpVVd0L3Jbk+QBJHk9vq81l/WWTbAk8E1iWZE/gMVU1q6pmV9Vs4F387p57quoB4K+AVzZtHwWcWVW7NvV2ofdHxYHAp4EDk7ygOd+jgQ8C/zAJQ5ckSeoEA32N5ZXAKc0+/IuAdzR740eM7NG/FlgCfIHeav65fe18nlGevlNVtwFnAa8fo94xzR8FRzR9ub4511XAhx7Z8CRJkrorVYO2Pkubv61nzqmZx5221nIrFi3YAL2RJEkaLMnVVTV/otpzRV+SJEnqIG/GVaftN2sGw67WS5KkKcgVfUmSJKmDDPQlSZKkDjLQlyRJkjrIQF+SJEnqIAN9SZIkqYMM9CVJkqQOMtCXJEmSOshAX5IkSeogA31JkiSpgwz0JUmSpA4y0JckSZI6yEBfkiRJ6qAtN3YHpMm0ZOUqZp90wZhlVixasIF6I0mStOG4oi9JkiR1kIG+JEmS1EEG+pIkSVIHGehrrZLskGRx8/ppkpWt4/ubMrOTLG3eH5/kQ31tXJJkfvN+2yT/kmRZkuuSXJrkma2yRyapJHu10rZI8sEkS5MsSXJVkt02zAxIkiRtfrwZV2tVVXcCcwGSnArcW1XvbY7vXY8mPw4sB+ZU1UNJdgee2sofAi4DFgKnNmlHAzsB+zd1dgbuW49zS5IkTQkG+tqgkuwBPBM4tqoeAqiqm4Gbm/xtgQOAg4HzeDjQnwnc1qpz64btuSRJ0ubFrTva0PYBFlfV6gH5LwW+UlU3AHclmdekfxZ4cbNd6B+TPH3QCZKckGQ4yfDq+1dNbO8lSZI2Ewb6mgy1jultQ8DZzfuzm+ORFfw9gbcBDwHfSPL8UU9SdXpVza+q+dOmz1injkuSJHWFW3c0Ge4Etu9LezxwB3A38LQkW4xswxmRZAfgEGDfJAVMAyrJW6vnQeBC4MIkP6O3+v+NSR6LJEnSZskVfU2Gq4ADkjwZoHnaztbAj6tqGTAMvCNJmvw5SY4AjgLOrKpdq2p2Ve1C76bdA5PMS7JTU34LYH/glg0+MkmSpM2Egb4mypbAgwBV9TPgjcCXkywGTgOGWiv4rwGeDNyUZAnwMeAn9LbpnNvX7ueBY4AnAv/ZPMLzWuA3wIeQJEnSqNy6o3VSVaf2HW/bvN0HWNZK/xLwpQFt3AP891GynjdK2Q+2Dr+ybr2VJEmaugz09YgleSdwBHD8Ru6KJEmSGqkaz4NQpM3T/Pnza3h4eGN3Q5Ikaa2SXF1V8yeqPffoS5IkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHGehLkiRJHWSgL0mSJHWQj9dUpyX5BXD9xu7HJuYJwB0buxObGOdkTc7JmpyTNTkno3Ne1uScrGm0Odm1qnacqBP4D2ap666fyOfRdkGSYefkdzkna3JO1uScrMk5GZ3zsibnZE0bYk7cuiNJkiR1kIG+JEmS1EEG+uq60zd2BzZBzsmanJM1OSdrck7W5JyMznlZk3OypkmfE2/GlSRJkjrIFX1JkiSpgwz01UlJDktyfZKbkpy0sfszGZKsSLIkyeIkw03a45N8PcmNzc/tm/Qk+WAzH9cmmddq57im/I1JjmulP6Np/6ambjb8KMeW5BNJfp5kaStt0udg0Dk2BQPm5NQkK5trZXGSF7Xy3taM7/okL2ylj/oZSrJbkiuasZ+TZKsmfevm+KYmf/aGGfHaJdklycVJfpDkuiRvbNKn7LUyxpxM9WtlmyRXJrmmmZd3NOnrPJaJmq+NbYw5OSPJ8ta1MrdJ7/znZ0SSaUm+l+T85njTu06qypevTr2AacAyYHdgK+AaYO+N3a9JGOcK4Al9af8AnNS8Pwl4d/P+RcCFQIBnAVc06Y8Hbm5+bt+8377JuxJ4dlPnQuBPNvaYR5mDg4B5wNINOQeDzrEpvAbMyanAm0cpu3fz+dga2K353Ewb6zMEfBZY2Lz/KPAXzfu/BD7avF8InLOx56I1zpnAvOb9dsANzdin7LUyxpxM9WslwLbN+0cBVzTXwDqNZSLna2O/xpiTM4CjRinf+c9Pa6xvAj4DnL8+1/yGuE5c0VcX/SFwU1XdXFW/As4GjtjIfdpQjgA+2bz/JPDSVvqZ1fMd4HFJZgIvBL5eVXdV1f8Dvg4c1uQ9tqour97/Tc5stbXJqKpLgbv6kjfEHAw6x0Y3YE4GOQI4u6oerKrlwE30Pj+jfoaaVbZDgM819fvnd2ROPgc8f2RVbmOrqtuq6rvN+18APwBmMYWvlTHmZJCpcq1UVd3bHD6qeRXrPpaJnK+Naow5GaTznx+AJDsDC4CPN8frc81P+nVioK8umgX8uHV8K2P/AttcFfC1JFcnOaFJe1JV3Qa9X+TAE5v0QXMyVvqto6RvDjbEHAw6x6bsDc3X6J9off29rnOyA3B3Vf2mL/132mryVzXlNynNV+ZPp7cq6bXCGnMCU/xaabZjLAZ+Ti8YXca6j2Ui52uj65+Tqhq5Vv6uuVben2TrJm2qfH5OA94KPNQcr881P+nXiYG+umi0laEuPl7qgKqaB/wJ8PokB41RdtCcrGv65mwqz8FHgD2AucBtwD826RM5J5v8fCXZFvg88FdVdc9YRUdJ6+S1MsqcTPlrpapWV9VcYGd6K6tPHa1Y83Oi5mWzmpMk+wJvA/YC/oDedpy/aYp3auyjSXI48POqurqdPErRjX6dGOiri24Fdmkd7wz8ZCP1ZdJU1U+anz8HzqX3C+lnzdegND9/3hQfNCdjpe88SvrmYEPMwaBzbJKq6mfNL+qHgI/Ru1Zg3efkDnpfw2/Zl/47bTX5Mxj/FqJJl+RR9ALaT1fVF5rkKX2tjDYnXisPq6q7gUvo7TNf17FM5HxtMlpzcliz/auq6kHg31j/a2Vz/PwcALwkyQp622oOobfCv8ldJwb66qKrgDnNnelb0bvx5byN3KcJleQxSbYbeQ8cCiylN86RJxkcB3ypeX8e8Mr0PAtY1XwN+lXg0CTbN1/RHwp8tcn7RZJnNXsCX9lqa1O3IeZg0Dk2SSO/KBtH0rtWoDeOhc0TIXYD5tC7KW7Uz1Czf/Zi4Kimfv/8jszJUcBFTfmNrvnv96/AD6rqfa2sKXutDJoTr5XsmORxzftHAy+gd//Cuo5lIudroxowJz9sBeCht0+8fa10+vNTVW+rqp2raja9/4YXVdWxbIrXSW0Cdy378jXRL3p3/d9Ab2/lyRu7P5Mwvt3p3YV/DXDdyBjp7d/7BnBj8/PxTXqADzfzsQSY32rrz+ndAHQT8KpW+nx6/+NeBnyI5h/Y25RewFn0thf8mt4KyKs3xBwMOsem8BowJ59qxnxt84tlZqv8yc34rqf1ZKVBn6Hm2ruymav/ALZu0rdpjm9q8nff2HPR6vOB9L7evhZY3LxeNJWvlTHmZKpfK/sD32vGvxT43+s7lomar439GmNOLmqulaXAv/Pwk3k6//npm5/n8fBTdza568R/GVeSJEnqILfuSJIkSR1koC9JkiR1kIG+JEmS1EEG+pIkSVIHGehLkiRJHWSgL0mSJHWQgb4kSZLUQQb6kiRJUgf9fxCubE1uQmF6AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 720x720 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('MUNICÍPIODERESIDÊNCIA').size().sort_values().tail(20).plot(kind='barh', figsize=(10,10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x25080356c50>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAbgAAAD8CAYAAAAFdLF9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAF8VJREFUeJzt3X+QZWV95/H3BxAcBEYIaFqgbMAB5OcIE38gS7JKUNSNskLJGMsha4o1amXjrokoaBGtRMSYRReNIiaIq6BGMQbWFUukFHWVGZxhhvBzZFTQiGicQJj4Y/juH/dpuHPtbnr61+0+vF9Vt/rc5zznPN9z5s585jzndHeqCkmSumaHYRcgSdJcMOAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE7aadgFPBrtvffeNTo6OuwyJGlRWbNmzb1Vtc9U+xtwQzA6Osrq1auHXYYkLSpJvrs9/Z2ilCR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHWSP8lkCNbfvZnRs64adhmPaNN5Lxx2CZI0bV7BSZI6yYCTJHWSASdJ6iQDTpLUSQacJKmTDDhJUic9YsAl2Zpkbd9rNMnvJLlynL47J7kgycYktyf5hyT7jbOvDUn+McnjW/tokg0D+3pPkruT7NDXdkaSB5Mc1de2IcloW16a5NI2/sa2vLRvjC1t/H9K8oGxfSc5PMk1SW5rdb8lSfrGvHCcY92UZO+2fHaSm5Lc2Pb/jEc6r5KkuTWVK7gtVbW877Vpkr5/CewOHFxVy4DPAp8ZC4u+fR0B/BR47Xg7acFzCvB94ISB1XcBZ08w/oeB71TVQVV1EHAncHHf+o1VtRw4CjgMeEmSJcDngPOq6mDgaOA44DWTHGd/rc8CXgQcU1VHASe2uiVJQzRrU5RJdgX+AHh9VW0FqKq/A34OPGecTb4B7DvB7v4jsAH4G2DlwLorgcOTHDIw/lOAY4G39zW/DViR5KD+vlX1K+DrwFOAlwNfq6qr27oHgNcBZ012vH1GgHur6udt+3ur6gdT3FaSNEemEnBL+qYnr5ik31OA71XVvw60rwYO729IsiPwXHpXTuNZCVwGXAG8KMlj+tY9CJwPvHlgm8OAtWPhCtCW144z/q5t/PVt3Zr+9VW1EdgtyR4T1NfvamD/Nr35/iS/PYVtJElzbHunKE+ZpF+AeoT2JUnWAj8B9gK++Gudk52BFwCfbWH5TeCkgW4fB56Z5IDtHP+gNv7XgKuq6vOTbMck7Q93qLqf3pXjmcCPgU8kOWOc4zozyeokq7c+sPmRditJmqHZ/FmUdwBPTrJ7Vd3X134M8I9teUtVLW8PflxJ7x7cewf283xgKbC+3brbFXgAeOiHN1bVr5K8G3hj33Y3AU9LskNVPQgP3cs7Gri59Rm7B8fAdtvc50tyIHB/Vd338O3DibUrxWuBa5OsB1YBlwz0uQi4CGCXkWWPGJySpJmZtXtwVfVvwEeAv25TkCR5Jb2Aumag72bgj4E3DEw/Qm968g+rarSqRoEDgJPatGK/S+g90LFP2+cdwLeBc/r6nAPc0NZN5GPA8UlObDUvoRe650/hsElySJJlfU3Lge9OZVtJ0tyZScA9N8ldfa9nAW8C/h24LcntwGnAKVX1a1csVfVtYB1w+lhbC7Hnse3V2r8B1wH/aWD7X9ALoif0Nb8KODjJHUk2Age3tglV1RbgxcA5SW6ld1/ueqD/WwPOGDjW/frW7QZ8pH3rwY307gWeO9mYkqS5l3GyR3Nsl5FlNbLqgmGX8Yj8dTmSFpIka6pqxVT7+5NMJEmdZMBJkjrJgJMkdZIBJ0nqJANOktRJBpwkqZNm8yeZaIqO3Hcpq30EX5LmlFdwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHWSASdJ6iQDTpLUSQacJKmTDDhJUicZcJKkTjLgJEmdZMBJkjrJgJMkdZIBJ0nqpJ2GXcCj0fq7NzN61lXDLmPWbDrvhcMuQZJ+jVdwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EmLIuCSbE2yNsm6JDckOa61jybZ0Nfv6UmuTXJ763dVkiPbukuSnDqw3/sH3r8+yb8nWTrQ/vQkX0lya5JbklycZNck5yZ5w0DfTUn2nu1zIEnaPovl++C2VNVygCTPA94B/HZ/hyRPBD4JvLyqvt7ajgcOAtZPcZyVwPXAKcAlffv9FHB6VX0jSYCXArvP8JgkSXNoUVzBDdgD+Jdx2l8HfGQs3ACq6rqq+uxUdprkIGA34Bx6QTfmtW2/32j7rKr6+6r60XQPQJI09xbLFdySJGuBxwIjwHPG6XM48JEZjLESuAz4KnBIkidU1T3AETPcryRpCBbLFdyWqlpeVYcCzwcubVOFE0ryzSQ3J3lPa6pxuvW3nQ5cXlUPAp8BTptCXePtc9z2JGcmWZ1k9dYHNk9h15KkmVgsAfeQNlW4N7DPwKqbgGP6+j0DeAsw9sDIT4A9x9Yn2Qu4ty0fBSwDvphkE72wG5umvAk4doJyttlnszvws3HqvqiqVlTVih13XTq4WpI0yxZdwCU5FNiRXrj0ex9wxtgTls2ufcvXAi9LsnN7fwbw5ba8Eji3qkbb60nAvkmeDFwIrEryjL4aXpHkN4GvAL+XZPfW/p+BdVW1dRYOVZI0A4vtHhxAgFVVtbV/lrKq/jnJy4B3JtkXuIfeFdrb2vorkxwLrEmyFdgIvLptfjpw8sCYV9B7cvKdSU4H/irJE4AH6QXbZ9qYFwLXJak25h/O+tFLkrZbqia6jaS5ssvIshpZdcGwy5g1/rocSfMhyZqqWjHV/otuilKSpKkw4CRJnWTASZI6yYCTJHWSASdJ6qTF8m0CnXLkvktZ7ZOHkjSnvIKTJHWSASdJ6iQDTpLUSQacJKmTDDhJUicZcJKkTjLgJEmdZMBJkjrJgJMkdZIBJ0nqJANOktRJBpwkqZMMOElSJxlwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVIn7TTsAh6N1t+9mdGzrhp2GbNq03kvHHYJkrQNr+AkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpk4YacEm2JlmbZF2SG5Ic19pHk2wYp/+1SVb0vX+oX5LfSVJJXtW3/mmt7Q3t/SVJ7mxjrk3y9dZ+RpIHkxzVt+2GJKPj7Ot5443f13bu2HiSpOEZ9hXclqpaXlVHA28C3jHD/a0HXtb3/nRg3UCfP21jLq+q4/ra7wLOnmTfK4Hr2ldJ0gI37IDrtwfwLzPcx/eAxyZ5YpIAzwc+P8VtrwQOT3LI4Iq2r1OBM4CTkjx2hnVKkubYsANuSZsqvAW4GHj7LOzz74HTgOOAG4CfD6x/V98U5cf62h8EzgfePM4+nw3cWVUbgWuBF8xCnZKkOTTsgBubojyU3tXWpe1qaSI1hbZP0gu4lcBl4/Tvn6L8/YF1HweemeSAgfaVwOVt+XIenqYcr55x25OcmWR1ktVbH9g8wWaSpNky7IB7SFV9A9gb2GeSbj8B9ux7vxdw78B+/hn4JfC7wJe2s4ZfAe8G3jjWlmRH4KXAW5NsAv4XcHKS3cepZ9ya2r4vqqoVVbVix12Xbk9ZkqRpWDABl+RQYEd6oTGRa4FX9F3lrQK+PE6/twJvrKqt0yjlEuBEHg7aE4F1VbV/VY1W1ZOBTwMvqar7gR8meW47hr3oXYleN41xJUmzaNi/TWBJkrVtOcCqqtra8uuQJHf19X09cBFwKLAuSQGr6T19uY2q+vokY74ryTl9758+sO0vkrwXeE9rWglcMbCPTwN/BHwUeCXwviTvbuv+vN2rkyQNUaomuo2kubLLyLIaWXXBsMuYVf66HElzLcmaqlrxyD17FswUpSRJs8mAkyR1kgEnSeokA06S1EkGnCSpkww4SVInDfv74B6Vjtx3Kat9rF6S5pRXcJKkTjLgJEmdZMBJkjrJgJMkdZIBJ0nqJANOktRJBpwkqZMMOElSJxlwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHWSASdJ6qSdhl3Ao9H6uzczetZVwy7jUWfTeS8cdgmS5pFXcJKkTjLgJEmdZMBJkjrJgJMkdZIBJ0nqJANOktRJCz7gkpyd5KYkNyZZm+QZfev2SfLLJP91YJulSS5NsrG9Lk2ydIL939+3fHiSa5LcluT2JG9JkrbuiUmuTLIuyT8l+T+tfTTJllbb2OuVc3M2JElTtaADLsmzgBcBx1TVUcCJwPf7upwG/D9g5cCmHwa+U1UHVdVBwJ3AxY8w1hLgc8B5VXUwcDRwHPCa1uVtwBer6uiqOgw4q2/zjVW1vO916XSOV5I0exZ0wAEjwL1V9XOAqrq3qn7Qt34l8D+A/ZLsC5DkKcCxwNv7+r0NWJHkoEnGejnwtaq6uo31APA6Hg6yEeCusc5VdeNMDkySNLcWesBdDezfpgzfn+S3x1Yk2R/4zar6FvBJ4GVt1WHA2qraOta3La8FDp9krMOBNf0NVbUR2C3JHsD7gA8n+XKbNn1SX9eDBqYo/8P0D1mSNBsWdMBV1f30rsbOBH4MfCLJGW316fSCDeByHp6mDFDj7G6i9qmsr6r6AnAg8CHgUODbSfZp6wenKL/6aztPzkyyOsnqrQ9snqQMSdJsWPA/i7JdfV0LXJtkPbAKuIReoD0xye+3rk9Ksgy4CXhakh2q6kGAJDvQu6d28yRD3QSc0N+Q5EDg/qq6r9XyU+DjwMeTXNn6rxnc0QTHcRFwEcAuI8smC1pJ0ixY0FdwSQ5poTVmOfDdJIcAj6uqfatqtKpGgXcAp1fVHcC3gXP6tjsHuKGtm8jHgOOTnNjGXgK8Fzi/vX9Okl3b8u7AQcD3ZuM4JUmzb0EHHLAb8JH2WP6N9O6vnUvv6u2Kgb6f5uFpylcBBye5I8lG4ODWto0kOwFjD7BsAV4MnJPkVmA9cD1wYet+LLC61fEN4OKqur6tG7wH98ezcOySpBlI1aN3tizJ0cCHqurp8znuLiPLamTVBfM5pPDX5UiLXZI1VbViqv0X+hXcnEnyauAytp3KlCR1xIJ/yGSuVNUHgA8Muw5J0tx41F7BSZK6zYCTJHWSASdJ6qRH7T24YTpy36Ws9ok+SZpTXsFJkjrJgJMkdZIBJ0nqJANOktRJBpwkqZMMOElSJxlwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHWSASdJ6iQDTpLUSQacJKmTdhp2AY9G6+/ezOhZVw27DEmaV5vOe+G8jucVnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHXSgg+4JFuTrE2yIcmnkuzat+6UJJXk0L620SQbxtnPJUlOHWi7v2/58CTXJLktye1J3pIkfetPTrI6yc1JbknyVwP7Wpfkstk6bknSzCz4gAO2VNXyqjoC+AXw6r51K4HrgNNnMkCSJcDngPOq6mDgaOA44DVt/RHAhcArquqpwBHAd/q2fyq9c3lCksfNpBZJ0uxYDAHX76vAUwCS7AY8G3gVMww44OXA16rqaoCqegB4HXBWW/9nwF9U1S1t/a+q6v0D238UuBr4vRnWIkmaBYsm4JLsBJwMrG9NLwH+b1XdBvw0yTFT2M272nTn2iRr+9oPB9b0d6yqjcBuSfagd8W2zfoBLwM+AVxG76pSkjRkiyHglrQwWg18D/hwa18JXN6WL2dqwfKnbbpzeVUt72sPUBNsM1F7b8Pkt4AfV9V3gS8BxyTZc5x+Z7Z7eKu3PrB5CqVKkmZiMfwsyi0DYUSS3wCeAxyRpIAdgUryZ9Mc4ybghIExDgTur6r7ktwEHAusG2fblcChSTa193sALwUu7u9UVRcBFwHsMrJs0tCUJM3cYriCG8+pwKVV9eSqGq2q/YE7geOnub+PAccnOREeeujkvcD5bf27gDcnObit3yHJf0+yA3AacFSrYxR4MU5TStLQLdaAWwlcMdD2aXoPewAckuSuvtdpk+2sqrbQC6ZzktxK7z7f9fSenKSqbgT+BLgsyc3ABmCE3lXf3VV1d9/uvgIclmRkRkcoSZqRVDlbNt92GVlWI6suGHYZkjSvZvrrcpKsqaoVU+2/WK/gJEmalAEnSeokA06S1EkGnCSpkww4SVInGXCSpE5aDD/JpHOO3Hcpq2f4uKwkaXJewUmSOsmAkyR1kgEnSeokA06S1EkGnCSpkww4SVInGXCSpE4y4CRJnWTASZI6yYCTJHWSv9F7CJLcB9w67DqmYW/g3mEXMQ3WPb+se/4sxpph+nU/uar2mWpnfxblcNy6Pb92faFIstq65491z6/FWPdirBnmr26nKCVJnWTASZI6yYAbjouGXcA0Wff8su75tRjrXow1wzzV7UMmkqRO8gpOktRJBtw8S/L8JLcmuSPJWUOqYVOS9UnWJlnd2vZK8sUkt7eve7b2JHlvq/fGJMf07WdV6397klV97ce2/d/Rts006/zbJPck2dDXNud1TjTGDOs+N8nd7ZyvTfKCvnVvajXcmuR5fe3jflaSHJDkm62+TyTZubXv0t7f0daPbmfd+yf5cpKbk9yU5L9Ndj4WwjmfpOYFfb6TPDbJt5Ksa3X/+XTHmq3jmWHdlyS5s+98L2/tw/2MVJWveXoBOwIbgQOBnYF1wGFDqGMTsPdA2/nAWW35LOCdbfkFwOeBAM8Evtna9wK+077u2Zb3bOu+BTyrbfN54ORp1nkCcAywYT7rnGiMGdZ9LvCGcfoe1j4HuwAHtM/HjpN9VoBPAqe35Q8Af9SWXwN8oC2fDnxiO+seAY5py7sDt7X6Fuw5n6TmBX2+2/Hv1pYfA3yzncPtGms2j2eGdV8CnDpO/6F+Rub1H9ZH+6v9oX2h7/2bgDcNoY5N/HrA3QqMtOURet+rB/BBYOVgP2Al8MG+9g+2thHglr72bfpNo9ZRtg2KOa9zojFmWPe5jP8P7jafAeAL7XMy7mel/aW/F9hp8DM1tm1b3qn1ywzO/T8Av7tYzvlAzYvmfAO7AjcAz9jesWbzeGZY9yWMH3BD/Yw4RTm/9gW+3/f+rtY23wq4OsmaJGe2tidW1Q8B2tcntPaJap6s/a5x2mfLfNQ50Rgz9bo2TfO3fdMr21v3bwA/q6pfjVP3Q9u09Ztb/+3WpsCeRu9/6IvinA/UDAv8fCfZMcla4B7gi/SuuLZ3rNk8nmnVXVVj5/sv2vn+n0l2Gax7ivXN6mfEgJtf492LGsZjrM+uqmOAk4HXJjlhkr4T1by97XNtodf5N8BBwHLgh8C7W/ts1j0rx5RkN+DTwJ9U1b9O1nWC8eb9nI9T84I/31W1taqWA/sBTweeOo2x5v3PYLDuJEfQuzo8FPgtetOOb5zluqfFgJtfdwH7973fD/jBfBdRVT9oX+8BrqD3l+tHSUYA2td7WveJap6sfb9x2mfLfNQ50RjTVlU/av8wPAh8iN45n07d9wKPT7LTQPs2+2rrlwI/3Z46kzyGXlB8rKo+05oX9Dkfr+bFcr5brT8DrqV3j2p7x5rN45lu3c+vqh9Wz8+Bv2P653tWPyMG3Py6HljWnmLamd7N4s/NZwFJHpdk97Fl4CRgQ6tjVeu2it69DFr7K9vTUM8ENrfpgS8AJyXZs03/nERvLv+HwH1Jntmefnpl375mw3zUOdEY0zb2F7M5hd45Hxvr9PaU3AHAMno32cf9rFTvBsSXgVMnOAdjdZ8KXNP6T7XGAB8Gbq6qv+5btWDP+UQ1L/TznWSfJI9vy0uAE4GbpzHWbB7PdOu+pS94AryEbc/38D4j07m56Gv6L3pPFd1Gb7797CGMfyC9J6rWATeN1UBvbv5LwO3t616tPcD7Wr3rgRV9+/ovwB3t9Qd97SvaB3wjcCHTfNABuIze9NIv6f3P7lXzUedEY8yw7o+2um5sf1FH+vqf3Wq4lb4nTif6rLQ/w2+14/kUsEtrf2x7f0dbf+B21n08vemgG4G17fWChXzOJ6l5QZ9v4Cjg262+DcBbpzvWbB3PDOu+pp3vDcD/5uEnLYf6GfEnmUiSOskpSklSJxlwkqROMuAkSZ1kwEmSOsmAkyR1kgEnSeokA06S1EkGnCSpk/4/DDZqtsQ7SkAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.query('SERVIÇO == \"Exame\"')['MUNICÍPIODERESIDÊNCIA'].value_counts().head().plot(kind='barh')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PALHOCA          347913\n",
       "SAO JOSE         102497\n",
       "BLUMENAU          57577\n",
       "BIGUACU           55737\n",
       "FLORIANOPOLIS     45871\n",
       "Name: MUNICÍPIODERESIDÊNCIA, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('SERVIÇO == \"Exame\"')['MUNICÍPIODERESIDÊNCIA'].value_counts().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    31797.000000\n",
       "mean        10.941693\n",
       "std         12.505739\n",
       "min          1.000000\n",
       "25%          2.000000\n",
       "50%          4.000000\n",
       "75%         18.000000\n",
       "max         90.000000\n",
       "Name: DOCUMENTO, dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('SERVIÇO == \"Exame\" and MUNICÍPIODERESIDÊNCIA == \"PALHOCA\"').DOCUMENTO.value_counts().describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "704207709501384    90\n",
       "700603418445267    80\n",
       "700000291920300    80\n",
       "700505394201153    78\n",
       "702005327186289    77\n",
       "Name: DOCUMENTO, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('SERVIÇO == \"Exame\" and MUNICÍPIODERESIDÊNCIA == \"PALHOCA\"').DOCUMENTO.value_counts().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>DESCRIÇÃODOPROCEDIMENTO</th>\n",
       "      <th>DATADASOLICITAÇÃO</th>\n",
       "      <th>CENTRALDEREGULAÇÃO/RESPONSÁVEL</th>\n",
       "      <th>POSIÇÃO</th>\n",
       "      <th>CNESDACENTRALEXECUTANTE</th>\n",
       "      <th>CNESDAUNIDADESOLICITANTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>264552</th>\n",
       "      <td>25 HIDROXIVITAMINA D (25 OHD)</td>\n",
       "      <td>23/08/2017 11:07:41</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>6519</td>\n",
       "      <td>6082351</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1189115</th>\n",
       "      <td>25 HIDROXIVITAMINA D (25 OHD)</td>\n",
       "      <td>23/08/2017 11:07:41</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>4990</td>\n",
       "      <td>6939392</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300253</th>\n",
       "      <td>ACIDO FOLICO</td>\n",
       "      <td>29/09/2017 13:13:39</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>10017</td>\n",
       "      <td>6082351</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224544</th>\n",
       "      <td>ACIDO FOLICO</td>\n",
       "      <td>29/09/2017 13:13:39</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>8466</td>\n",
       "      <td>6939392</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264515</th>\n",
       "      <td>ACIDO URICO</td>\n",
       "      <td>23/08/2017 11:06:38</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>6515</td>\n",
       "      <td>6082351</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1189078</th>\n",
       "      <td>ACIDO URICO</td>\n",
       "      <td>23/08/2017 11:06:38</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>4986</td>\n",
       "      <td>6939392</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1189079</th>\n",
       "      <td>ANTIBIOGRAMA</td>\n",
       "      <td>23/08/2017 11:06:38</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>4986</td>\n",
       "      <td>6939392</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264516</th>\n",
       "      <td>ANTIBIOGRAMA</td>\n",
       "      <td>23/08/2017 11:06:38</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>6515</td>\n",
       "      <td>6082351</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300254</th>\n",
       "      <td>ANTIPEROXIDASE /ANTI TPO</td>\n",
       "      <td>29/09/2017 13:13:39</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>10017</td>\n",
       "      <td>6082351</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224545</th>\n",
       "      <td>ANTIPEROXIDASE /ANTI TPO</td>\n",
       "      <td>29/09/2017 13:13:39</td>\n",
       "      <td>CENTRO DE SAUDE VILA NOVA</td>\n",
       "      <td>8466</td>\n",
       "      <td>6939392</td>\n",
       "      <td>7124619</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               DESCRIÇÃODOPROCEDIMENTO    DATADASOLICITAÇÃO  \\\n",
       "264552   25 HIDROXIVITAMINA D (25 OHD)  23/08/2017 11:07:41   \n",
       "1189115  25 HIDROXIVITAMINA D (25 OHD)  23/08/2017 11:07:41   \n",
       "300253                    ACIDO FOLICO  29/09/2017 13:13:39   \n",
       "1224544                   ACIDO FOLICO  29/09/2017 13:13:39   \n",
       "264515                     ACIDO URICO  23/08/2017 11:06:38   \n",
       "1189078                    ACIDO URICO  23/08/2017 11:06:38   \n",
       "1189079                   ANTIBIOGRAMA  23/08/2017 11:06:38   \n",
       "264516                    ANTIBIOGRAMA  23/08/2017 11:06:38   \n",
       "300254        ANTIPEROXIDASE /ANTI TPO  29/09/2017 13:13:39   \n",
       "1224545       ANTIPEROXIDASE /ANTI TPO  29/09/2017 13:13:39   \n",
       "\n",
       "        CENTRALDEREGULAÇÃO/RESPONSÁVEL  POSIÇÃO CNESDACENTRALEXECUTANTE  \\\n",
       "264552       CENTRO DE SAUDE VILA NOVA     6519                 6082351   \n",
       "1189115      CENTRO DE SAUDE VILA NOVA     4990                 6939392   \n",
       "300253       CENTRO DE SAUDE VILA NOVA    10017                 6082351   \n",
       "1224544      CENTRO DE SAUDE VILA NOVA     8466                 6939392   \n",
       "264515       CENTRO DE SAUDE VILA NOVA     6515                 6082351   \n",
       "1189078      CENTRO DE SAUDE VILA NOVA     4986                 6939392   \n",
       "1189079      CENTRO DE SAUDE VILA NOVA     4986                 6939392   \n",
       "264516       CENTRO DE SAUDE VILA NOVA     6515                 6082351   \n",
       "300254       CENTRO DE SAUDE VILA NOVA    10017                 6082351   \n",
       "1224545      CENTRO DE SAUDE VILA NOVA     8466                 6939392   \n",
       "\n",
       "         CNESDAUNIDADESOLICITANTE  \n",
       "264552                    7124619  \n",
       "1189115                   7124619  \n",
       "300253                    7124619  \n",
       "1224544                   7124619  \n",
       "264515                    7124619  \n",
       "1189078                   7124619  \n",
       "1189079                   7124619  \n",
       "264516                    7124619  \n",
       "300254                    7124619  \n",
       "1224545                   7124619  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('DOCUMENTO == 704207709501384')[['DESCRIÇÃODOPROCEDIMENTO','DATADASOLICITAÇÃO', 'CENTRALDEREGULAÇÃO/RESPONSÁVEL', 'POSIÇÃO', 'CNESDACENTRALEXECUTANTE', 'CNESDAUNIDADESOLICITANTE']].sort_values(by='DESCRIÇÃODOPROCEDIMENTO').head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>DESCRIÇÃODOPROCEDIMENTO</th>\n",
       "      <th>DATADASOLICITAÇÃO</th>\n",
       "      <th>CENTRALDEREGULAÇÃO/RESPONSÁVEL</th>\n",
       "      <th>POSIÇÃO</th>\n",
       "      <th>CNESDACENTRALEXECUTANTE</th>\n",
       "      <th>CNESDAUNIDADESOLICITANTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>194548</th>\n",
       "      <td>25 HIDROXIVITAMINA D (25 OHD)</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>339</td>\n",
       "      <td>6082351</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134084</th>\n",
       "      <td>25 HIDROXIVITAMINA D (25 OHD)</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>295</td>\n",
       "      <td>6939392</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194549</th>\n",
       "      <td>ACIDO URICO</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>339</td>\n",
       "      <td>6082351</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134085</th>\n",
       "      <td>ACIDO URICO</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>295</td>\n",
       "      <td>6939392</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194550</th>\n",
       "      <td>AMILASE</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>339</td>\n",
       "      <td>6082351</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134086</th>\n",
       "      <td>AMILASE</td>\n",
       "      <td>18/04/2017 17:04:52</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>295</td>\n",
       "      <td>6939392</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134105</th>\n",
       "      <td>ANTI HBC - IGG ANTICORPOS IGG CONTRA ANTIGENO ...</td>\n",
       "      <td>18/04/2017 17:27:57</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>296</td>\n",
       "      <td>6939392</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194569</th>\n",
       "      <td>ANTI HBC - IGG ANTICORPOS IGG CONTRA ANTIGENO ...</td>\n",
       "      <td>18/04/2017 17:27:57</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>340</td>\n",
       "      <td>6082351</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134106</th>\n",
       "      <td>ANTI HBC - IGM ANTICORPOS IGM CONTRA ANTIGENO ...</td>\n",
       "      <td>18/04/2017 17:27:57</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>296</td>\n",
       "      <td>6939392</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194570</th>\n",
       "      <td>ANTI HBC - IGM ANTICORPOS IGM CONTRA ANTIGENO ...</td>\n",
       "      <td>18/04/2017 17:27:57</td>\n",
       "      <td>CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...</td>\n",
       "      <td>340</td>\n",
       "      <td>6082351</td>\n",
       "      <td>5969018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   DESCRIÇÃODOPROCEDIMENTO  \\\n",
       "194548                       25 HIDROXIVITAMINA D (25 OHD)   \n",
       "1134084                      25 HIDROXIVITAMINA D (25 OHD)   \n",
       "194549                                         ACIDO URICO   \n",
       "1134085                                        ACIDO URICO   \n",
       "194550                                             AMILASE   \n",
       "1134086                                            AMILASE   \n",
       "1134105  ANTI HBC - IGG ANTICORPOS IGG CONTRA ANTIGENO ...   \n",
       "194569   ANTI HBC - IGG ANTICORPOS IGG CONTRA ANTIGENO ...   \n",
       "1134106  ANTI HBC - IGM ANTICORPOS IGM CONTRA ANTIGENO ...   \n",
       "194570   ANTI HBC - IGM ANTICORPOS IGM CONTRA ANTIGENO ...   \n",
       "\n",
       "           DATADASOLICITAÇÃO  \\\n",
       "194548   18/04/2017 17:04:52   \n",
       "1134084  18/04/2017 17:04:52   \n",
       "194549   18/04/2017 17:04:52   \n",
       "1134085  18/04/2017 17:04:52   \n",
       "194550   18/04/2017 17:04:52   \n",
       "1134086  18/04/2017 17:04:52   \n",
       "1134105  18/04/2017 17:27:57   \n",
       "194569   18/04/2017 17:27:57   \n",
       "1134106  18/04/2017 17:27:57   \n",
       "194570   18/04/2017 17:27:57   \n",
       "\n",
       "                            CENTRALDEREGULAÇÃO/RESPONSÁVEL  POSIÇÃO  \\\n",
       "194548   CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      339   \n",
       "1134084  CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      295   \n",
       "194549   CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      339   \n",
       "1134085  CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      295   \n",
       "194550   CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      339   \n",
       "1134086  CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      295   \n",
       "1134105  CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      296   \n",
       "194569   CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      340   \n",
       "1134106  CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      296   \n",
       "194570   CEAP CENTRO ESPECIALIZADO EM ACONSELHAMENTO E ...      340   \n",
       "\n",
       "        CNESDACENTRALEXECUTANTE  CNESDAUNIDADESOLICITANTE  \n",
       "194548                  6082351                   5969018  \n",
       "1134084                 6939392                   5969018  \n",
       "194549                  6082351                   5969018  \n",
       "1134085                 6939392                   5969018  \n",
       "194550                  6082351                   5969018  \n",
       "1134086                 6939392                   5969018  \n",
       "1134105                 6939392                   5969018  \n",
       "194569                  6082351                   5969018  \n",
       "1134106                 6939392                   5969018  \n",
       "194570                  6082351                   5969018  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('DOCUMENTO == 700603418445267')[['DESCRIÇÃODOPROCEDIMENTO','DATADASOLICITAÇÃO', 'CENTRALDEREGULAÇÃO/RESPONSÁVEL', 'POSIÇÃO', 'CNESDACENTRALEXECUTANTE', 'CNESDAUNIDADESOLICITANTE']].sort_values(by='DESCRIÇÃODOPROCEDIMENTO').head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "def deduplicate_stats(query=None):\n",
    "    if query:\n",
    "        df_tmp = df.query(query)\n",
    "    else:\n",
    "        df_tmp = df\n",
    "    total_rows = len(df_tmp)\n",
    "    unique_rows = len(df_tmp.groupby(['DOCUMENTO', 'DESCRIÇÃODOPROCEDIMENTO']))\n",
    "    unique_rows_same_date = len(df_tmp.groupby(['DOCUMENTO', 'DESCRIÇÃODOPROCEDIMENTO', 'DATADASOLICITAÇÃO']))\n",
    "    reducao_fila = (total_rows - unique_rows) / total_rows\n",
    "    print('           registros na fila:', total_rows)\n",
    "    print('    registros únicos na fila:', unique_rows)\n",
    "    print('          duplicados (total):', total_rows - unique_rows)\n",
    "    print('duplicados (mesmo timestamp):', total_rows - unique_rows_same_date)\n",
    "    print('    redução com deduplicação:', int(100*reducao_fila), '%')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           registros na fila: 384253\n",
      "    registros únicos na fila: 223579\n",
      "          duplicados (total): 160674\n",
      "duplicados (mesmo timestamp): 160305\n",
      "    redução com deduplicação: 41 %\n"
     ]
    }
   ],
   "source": [
    "deduplicate_stats('MUNICÍPIODERESIDÊNCIA == \"PALHOCA\"')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           registros na fila: 1306967\n",
      "    registros únicos na fila: 1080625\n",
      "          duplicados (total): 226342\n",
      "duplicados (mesmo timestamp): 222124\n",
      "    redução com deduplicação: 17 %\n"
     ]
    }
   ],
   "source": [
    "deduplicate_stats()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           registros na fila: 115959\n",
      "    registros únicos na fila: 113856\n",
      "          duplicados (total): 2103\n",
      "duplicados (mesmo timestamp): 1636\n",
      "    redução com deduplicação: 1 %\n"
     ]
    }
   ],
   "source": [
    "deduplicate_stats('MUNICÍPIODERESIDÊNCIA == \"FLORIANOPOLIS\"')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           registros na fila: 15208\n",
      "    registros únicos na fila: 15186\n",
      "          duplicados (total): 22\n",
      "duplicados (mesmo timestamp): 0\n",
      "    redução com deduplicação: 0 %\n"
     ]
    }
   ],
   "source": [
    "deduplicate_stats('MUNICÍPIODERESIDÊNCIA == \"JOINVILLE\"')"
   ]
  },
  {
   "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>DESCRIÇÃODOPROCEDIMENTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CONSULTA EM OFTALMOLOGIA - GERAL</th>\n",
       "      <td>66417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONSULTA EM OTORRINOLARINGOLOGIA - GERAL</th>\n",
       "      <td>29972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ULTRA-SONOGRAFIA TRANSVAGINAL</th>\n",
       "      <td>28250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONSULTA EM ORTOPEDIA - GERAL</th>\n",
       "      <td>26785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HEMOGRAMA COMPLETO</th>\n",
       "      <td>26014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIGLICERIDEOS</th>\n",
       "      <td>21507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CREATININA</th>\n",
       "      <td>19010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLICEMIA DE JEJUM</th>\n",
       "      <td>18521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENDOSCOPIA DIGESTIVA ALTA</th>\n",
       "      <td>17761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONSULTA EM DERMATOLOGIA - GERAL</th>\n",
       "      <td>17345</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          DESCRIÇÃODOPROCEDIMENTO\n",
       "CONSULTA EM OFTALMOLOGIA - GERAL                            66417\n",
       "CONSULTA EM OTORRINOLARINGOLOGIA - GERAL                    29972\n",
       "ULTRA-SONOGRAFIA TRANSVAGINAL                               28250\n",
       "CONSULTA EM ORTOPEDIA - GERAL                               26785\n",
       "HEMOGRAMA COMPLETO                                          26014\n",
       "TRIGLICERIDEOS                                              21507\n",
       "CREATININA                                                  19010\n",
       "GLICEMIA DE JEJUM                                           18521\n",
       "ENDOSCOPIA DIGESTIVA ALTA                                   17761\n",
       "CONSULTA EM DERMATOLOGIA - GERAL                            17345"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['DESCRIÇÃODOPROCEDIMENTO'].value_counts().to_frame().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>MUNICÍPIODERESIDÊNCIA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>FLORIANOPOLIS</th>\n",
       "      <td>19032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CRICIUMA</th>\n",
       "      <td>13661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHAPECO</th>\n",
       "      <td>9142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PALHOCA</th>\n",
       "      <td>7677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAO JOSE</th>\n",
       "      <td>2633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAGES</th>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAO JOAO BATISTA</th>\n",
       "      <td>1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONCORDIA</th>\n",
       "      <td>1175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAO MIGUEL DO OESTE</th>\n",
       "      <td>1131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARARANGUA</th>\n",
       "      <td>1040</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     MUNICÍPIODERESIDÊNCIA\n",
       "FLORIANOPOLIS                        19032\n",
       "CRICIUMA                             13661\n",
       "CHAPECO                               9142\n",
       "PALHOCA                               7677\n",
       "SAO JOSE                              2633\n",
       "LAGES                                 2004\n",
       "SAO JOAO BATISTA                      1597\n",
       "CONCORDIA                             1175\n",
       "SAO MIGUEL DO OESTE                   1131\n",
       "ARARANGUA                             1040"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('DESCRIÇÃODOPROCEDIMENTO == \"CONSULTA EM OFTALMOLOGIA - GERAL\"')['MUNICÍPIODERESIDÊNCIA'].value_counts().to_frame().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>POSIÇÃO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CÓDIGO SIGTAP DO PROCEDIMENTO</th>\n",
       "      <th>MUNICÍPIODERESIDÊNCIA</th>\n",
       "      <th>CNESDACENTRALEXECUTANTE</th>\n",
       "      <th>TEMPOMÉDIODEESPERA(DIAS)</th>\n",
       "      <th>CLASSIFICAÇÃO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">301010072.0</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">CANELINHA</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">2692260</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">417.0</th>\n",
       "      <th>2 - Amarelo</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3 - Verde</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 - Azul</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">6515681</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">44.0</th>\n",
       "      <th>1 - Vermelho</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 - Azul</th>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">45.0</th>\n",
       "      <th>1 - Vermelho</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 - Azul</th>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6541666</th>\n",
       "      <th>34.0</th>\n",
       "      <th>4 - Azul</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6939392</th>\n",
       "      <th>395.0</th>\n",
       "      <th>4 - Azul</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                    POSIÇÃO\n",
       "CÓDIGO SIGTAP DO PROCEDIMENTO MUNICÍPIODERESIDÊNCIA CNESDACENTRALEXECUTANTE TEMPOMÉDIODEESPERA(DIAS) CLASSIFICAÇÃO         \n",
       "301010072.0                   CANELINHA             2692260                 417.0                    2 - Amarelo         12\n",
       "                                                                                                     3 - Verde            7\n",
       "                                                                                                     4 - Azul             6\n",
       "                                                    6515681                 44.0                     1 - Vermelho         4\n",
       "                                                                                                     4 - Azul            34\n",
       "                                                                            45.0                     1 - Vermelho         1\n",
       "                                                                                                     4 - Azul            32\n",
       "                                                    6541666                 34.0                     4 - Azul             4\n",
       "                                                    6939392                 395.0                    4 - Azul            16"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('DESCRIÇÃODOPROCEDIMENTO == \"CONSULTA EM OFTALMOLOGIA - GERAL\"').groupby(['CÓDIGO SIGTAP DO PROCEDIMENTO', 'MUNICÍPIODERESIDÊNCIA', 'CNESDACENTRALEXECUTANTE', 'TEMPOMÉDIODEESPERA(DIAS)', 'CLASSIFICAÇÃO']).count()[['POSIÇÃO']].query('MUNICÍPIODERESIDÊNCIA == \"CANELINHA\"')"
   ]
  },
  {
   "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}