Primeiros Prcessamentos e Análises.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Espacializando os atendimentos do SP156\n",
    "\n",
    "O primeiro passo para espacializarmos os dados de atendimento do SP156 é juntar os arquivos. Para isso vamos utilziar a biblioteca Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/fernando/miniconda3/envs/geo_env/lib/python3.8/site-packages/IPython/core/interactiveshell.py:3062: DtypeWarning: Columns (7) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n",
      "/home/fernando/miniconda3/envs/geo_env/lib/python3.8/site-packages/IPython/core/interactiveshell.py:3062: DtypeWarning: Columns (6,7) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n",
      "/home/fernando/miniconda3/envs/geo_env/lib/python3.8/site-packages/IPython/core/interactiveshell.py:3062: DtypeWarning: Columns (6) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "\n",
    "path = r'download' # use your path\n",
    "all_files = glob.glob(path + \"/*.csv\")\n",
    "\n",
    "li = []\n",
    "\n",
    "for filename in all_files:\n",
    "    df = pd.read_csv(filename, index_col=None, header=0, encoding=\"ISO-8859-1\", delimiter=';', parse_dates=['Data de abertura', 'Data do parecer'])\n",
    "    li.append(df)\n",
    "\n",
    "frame = pd.concat(li, axis=0, ignore_index=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "frame['Latitude'] = pd.to_numeric(frame['Latitude'].str.replace(',', '.'), errors='coerce')\n",
    "frame['Longitude'] = pd.to_numeric(frame['Longitude'].str.replace(',', '.'), errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Data de abertura         datetime64[ns]\n",
       "Canal                            object\n",
       "Tema                             object\n",
       "Assunto                          object\n",
       "Serviço                          object\n",
       "Logradouro                       object\n",
       "Número                           object\n",
       "CEP                              object\n",
       "Subprefeitura                    object\n",
       "Distrito                         object\n",
       "Setor                           float64\n",
       "Quadra                          float64\n",
       "Latitude                        float64\n",
       "Longitude                       float64\n",
       "Data do parecer          datetime64[ns]\n",
       "Status da solicitação            object\n",
       "Órgão                            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.dtypes\n"
   ]
  },
  {
   "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>Data de abertura</th>\n",
       "      <th>Canal</th>\n",
       "      <th>Tema</th>\n",
       "      <th>Assunto</th>\n",
       "      <th>Serviço</th>\n",
       "      <th>Logradouro</th>\n",
       "      <th>Número</th>\n",
       "      <th>CEP</th>\n",
       "      <th>Subprefeitura</th>\n",
       "      <th>Distrito</th>\n",
       "      <th>Setor</th>\n",
       "      <th>Quadra</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Data do parecer</th>\n",
       "      <th>Status da solicitação</th>\n",
       "      <th>Órgão</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-01-01 00:05:06</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE</td>\n",
       "      <td>BOM RETIRO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-12 08:34:17</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-01-01 00:13:07</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUTANTA</td>\n",
       "      <td>BUTANTA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-01-01 02:59:12</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-01-01 00:15:28</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE</td>\n",
       "      <td>REPUBLICA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-01-01 04:27:10</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-01-01 00:18:21</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE</td>\n",
       "      <td>SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-01-01 03:12:53</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-01-01 00:21:26</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MOOCA</td>\n",
       "      <td>AGUA RASA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-01-01 04:24:30</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4487491</th>\n",
       "      <td>2020-03-31 21:44:00</td>\n",
       "      <td>APLICATIVO</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Reparos em asfalto, pontes e viadutos</td>\n",
       "      <td>Tapa-buraco</td>\n",
       "      <td>Avenida Jandira</td>\n",
       "      <td>850</td>\n",
       "      <td>4.08000e+06</td>\n",
       "      <td>VILA MARIANA</td>\n",
       "      <td>MOEMA</td>\n",
       "      <td>45.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>-23.610862</td>\n",
       "      <td>-46.658034</td>\n",
       "      <td>2020-03-31 21:44:00</td>\n",
       "      <td>AGUARDANDO ATENDIMENTO</td>\n",
       "      <td>SMSUB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4487492</th>\n",
       "      <td>2020-03-31 21:44:00</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Calçadas, guias e postes</td>\n",
       "      <td>Sugerir construção de calçadas em áreas públic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAO MATEUS</td>\n",
       "      <td>SAO RAFAEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-03-31 22:15:00</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMSUB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4487493</th>\n",
       "      <td>2020-03-31 21:45:00</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Trânsito e Transporte</td>\n",
       "      <td>Reclamação ônibus</td>\n",
       "      <td>Ônibus - Reclamação de intervalo excessivo da ...</td>\n",
       "      <td>Avenida Brigadeiro Faria Lima</td>\n",
       "      <td>4300</td>\n",
       "      <td>4.54504e+06</td>\n",
       "      <td>PINHEIROS</td>\n",
       "      <td>ITAIM BIBI</td>\n",
       "      <td>299.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>-23.594309</td>\n",
       "      <td>-46.681137</td>\n",
       "      <td>2020-03-31 21:46:00</td>\n",
       "      <td>AGUARDANDO ATENDIMENTO</td>\n",
       "      <td>SPTRANS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4487494</th>\n",
       "      <td>2020-03-31 21:46:00</td>\n",
       "      <td>APLICATIVO</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Reparos em asfalto, pontes e viadutos</td>\n",
       "      <td>Tapa-buraco</td>\n",
       "      <td>Avenida Indianópolis</td>\n",
       "      <td>11</td>\n",
       "      <td>4.062e+06</td>\n",
       "      <td>VILA MARIANA</td>\n",
       "      <td>MOEMA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-23.600107</td>\n",
       "      <td>-46.658728</td>\n",
       "      <td>2020-03-31 21:46:00</td>\n",
       "      <td>AGUARDANDO ATENDIMENTO</td>\n",
       "      <td>SMSUB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4487495</th>\n",
       "      <td>2020-03-31 21:46:00</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE</td>\n",
       "      <td>SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-01-04 01:40:00</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4487496 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Data de abertura               Canal  \\\n",
       "0       2018-01-01 00:05:06  CENTRAL TELEFÔNICA   \n",
       "1       2018-01-01 00:13:07  CENTRAL TELEFÔNICA   \n",
       "2       2018-01-01 00:15:28  CENTRAL TELEFÔNICA   \n",
       "3       2018-01-01 00:18:21  CENTRAL TELEFÔNICA   \n",
       "4       2018-01-01 00:21:26  CENTRAL TELEFÔNICA   \n",
       "...                     ...                 ...   \n",
       "4487491 2020-03-31 21:44:00          APLICATIVO   \n",
       "4487492 2020-03-31 21:44:00       PORTAL ONLINE   \n",
       "4487493 2020-03-31 21:45:00  CENTRAL TELEFÔNICA   \n",
       "4487494 2020-03-31 21:46:00          APLICATIVO   \n",
       "4487495 2020-03-31 21:46:00  CENTRAL TELEFÔNICA   \n",
       "\n",
       "                                   Tema  \\\n",
       "0        Cidadania e assistência social   \n",
       "1        Cidadania e assistência social   \n",
       "2        Cidadania e assistência social   \n",
       "3        Cidadania e assistência social   \n",
       "4        Cidadania e assistência social   \n",
       "...                                 ...   \n",
       "4487491                    Rua e bairro   \n",
       "4487492                    Rua e bairro   \n",
       "4487493           Trânsito e Transporte   \n",
       "4487494                    Rua e bairro   \n",
       "4487495  Cidadania e assistência social   \n",
       "\n",
       "                                        Assunto  \\\n",
       "0        População ou pessoa em situação de rua   \n",
       "1        População ou pessoa em situação de rua   \n",
       "2        População ou pessoa em situação de rua   \n",
       "3        População ou pessoa em situação de rua   \n",
       "4        População ou pessoa em situação de rua   \n",
       "...                                         ...   \n",
       "4487491   Reparos em asfalto, pontes e viadutos   \n",
       "4487492                Calçadas, guias e postes   \n",
       "4487493                       Reclamação ônibus   \n",
       "4487494   Reparos em asfalto, pontes e viadutos   \n",
       "4487495  População ou pessoa em situação de rua   \n",
       "\n",
       "                                                   Serviço  \\\n",
       "0        Serviço Especializado de Abordagem Social às P...   \n",
       "1        Serviço Especializado de Abordagem Social às P...   \n",
       "2        Serviço Especializado de Abordagem Social às P...   \n",
       "3        Serviço Especializado de Abordagem Social às P...   \n",
       "4        Serviço Especializado de Abordagem Social às P...   \n",
       "...                                                    ...   \n",
       "4487491                                        Tapa-buraco   \n",
       "4487492  Sugerir construção de calçadas em áreas públic...   \n",
       "4487493  Ônibus - Reclamação de intervalo excessivo da ...   \n",
       "4487494                                        Tapa-buraco   \n",
       "4487495  Serviço Especializado de Abordagem Social às P...   \n",
       "\n",
       "                            Logradouro Número          CEP Subprefeitura  \\\n",
       "0                                  NaN    NaN          NaN            SE   \n",
       "1                                  NaN    NaN          NaN       BUTANTA   \n",
       "2                                  NaN    NaN          NaN            SE   \n",
       "3                                  NaN    NaN          NaN            SE   \n",
       "4                                  NaN    NaN          NaN         MOOCA   \n",
       "...                                ...    ...          ...           ...   \n",
       "4487491                Avenida Jandira    850  4.08000e+06  VILA MARIANA   \n",
       "4487492                            NaN    NaN          NaN    SAO MATEUS   \n",
       "4487493  Avenida Brigadeiro Faria Lima   4300  4.54504e+06     PINHEIROS   \n",
       "4487494           Avenida Indianópolis     11    4.062e+06  VILA MARIANA   \n",
       "4487495                            NaN    NaN          NaN            SE   \n",
       "\n",
       "           Distrito  Setor  Quadra   Latitude  Longitude     Data do parecer  \\\n",
       "0        BOM RETIRO    NaN     NaN        NaN        NaN 2018-04-12 08:34:17   \n",
       "1           BUTANTA    NaN     NaN        NaN        NaN 2018-01-01 02:59:12   \n",
       "2         REPUBLICA    NaN     NaN        NaN        NaN 2018-01-01 04:27:10   \n",
       "3                SE    NaN     NaN        NaN        NaN 2018-01-01 03:12:53   \n",
       "4         AGUA RASA    NaN     NaN        NaN        NaN 2018-01-01 04:24:30   \n",
       "...             ...    ...     ...        ...        ...                 ...   \n",
       "4487491       MOEMA   45.0   169.0 -23.610862 -46.658034 2020-03-31 21:44:00   \n",
       "4487492  SAO RAFAEL    NaN     NaN        NaN        NaN 2020-03-31 22:15:00   \n",
       "4487493  ITAIM BIBI  299.0    51.0 -23.594309 -46.681137 2020-03-31 21:46:00   \n",
       "4487494       MOEMA    NaN     NaN -23.600107 -46.658728 2020-03-31 21:46:00   \n",
       "4487495          SE    NaN     NaN        NaN        NaN 2020-01-04 01:40:00   \n",
       "\n",
       "          Status da solicitação    Órgão  \n",
       "0                    FINALIZADA    SMADS  \n",
       "1                    FINALIZADA    SMADS  \n",
       "2                    FINALIZADA    SMADS  \n",
       "3                    FINALIZADA    SMADS  \n",
       "4                    FINALIZADA    SMADS  \n",
       "...                         ...      ...  \n",
       "4487491  AGUARDANDO ATENDIMENTO    SMSUB  \n",
       "4487492              FINALIZADA    SMSUB  \n",
       "4487493  AGUARDANDO ATENDIMENTO  SPTRANS  \n",
       "4487494  AGUARDANDO ATENDIMENTO    SMSUB  \n",
       "4487495              FINALIZADA    SMADS  \n",
       "\n",
       "[4487496 rows x 17 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Contabilizando e agrupando\n",
    "\n",
    "Agora podemos ter um panorama geral de cada um dos campos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\ipykernel_launcher.py:2: FutureWarning: The signature of `Series.to_csv` was aligned to that of `DataFrame.to_csv`, and argument 'header' will change its default value from False to True: please pass an explicit value to suppress this warning.\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "#frame.Canal.unique().tolist()\n",
    "frame.groupby(['Canal', 'Tema', 'Assunto', 'Serviço']).size().to_csv(r'resultados\\sp156_atendimentos_agrupados.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\ipykernel_launcher.py:1: FutureWarning: The signature of `Series.to_csv` was aligned to that of `DataFrame.to_csv`, and argument 'header' will change its default value from False to True: please pass an explicit value to suppress this warning.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "frame.groupby(['Tema', 'Assunto', 'Serviço']).size().to_csv(r'resultados\\sp156_atendimentos_agrupados_sem_canal.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Tema\n",
       "Acessibilidade                       1950\n",
       "Animais                            207043\n",
       "Bilhete Único                      108774\n",
       "Canais de Atendimento               16572\n",
       "Cidadania e assistência social     415156\n",
       "Comércio e serviços                 71590\n",
       "Cultura, esporte e lazer             1151\n",
       "Documentos e licenças               37452\n",
       "Educação                            21000\n",
       "Finanças                            16264\n",
       "Lixo e limpeza                     587609\n",
       "Localizacao de tumulo                   1\n",
       "Meio Ambiente                       11569\n",
       "Obras, imóveis e habitação          87221\n",
       "Ouvidoria Geral do Município        87358\n",
       "Rua e bairro                      1531553\n",
       "SAC/GRC                              4989\n",
       "Saúde                              104990\n",
       "Segurança urbana                     3106\n",
       "Trabalho                             8591\n",
       "Trânsito e Transporte              746302\n",
       "Urgência                            67342\n",
       "Name: Tema, dtype: int64"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.groupby('Tema').Tema.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Assunto\n",
       "ATENDE - Transporte Pessoas com Deficiência      1519\n",
       "Acessibilidade Digital                             39\n",
       "Acessibilidade em edificações                    1793\n",
       "Agendamento eletrônico                           4462\n",
       "Alimentação escolar                               223\n",
       "                                                ...  \n",
       "Áreas de pedestre (calçadões)                      69\n",
       "Áreas municipais                                 8810\n",
       "Árvore                                         322125\n",
       "Árvore(Praça Pública)                               8\n",
       "Ônibus                                          57107\n",
       "Name: Assunto, Length: 226, dtype: int64"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.groupby('Assunto')['Assunto'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Distrito\n",
       "AGUA RASA            34902\n",
       "ALTO DE PINHEIROS    19950\n",
       "ANHANGUERA            7499\n",
       "ARICANDUVA           29969\n",
       "ARTUR ALVIM          26242\n",
       "                     ...  \n",
       "VILA MARIANA         47831\n",
       "VILA MATILDE         37212\n",
       "VILA MEDEIROS        32053\n",
       "VILA PRUDENTE        41655\n",
       "VILA SONIA           38360\n",
       "Name: Distrito, Length: 96, dtype: int64"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.groupby('Distrito')['Distrito'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Data de abertura  Data de abertura\n",
       "2015              1                    74059\n",
       "                  2                    64227\n",
       "                  3                    92730\n",
       "                  4                    71418\n",
       "                  5                    56706\n",
       "                  6                    49107\n",
       "                  7                    49803\n",
       "                  8                    51014\n",
       "                  9                    54866\n",
       "                  10                   55461\n",
       "                  11                   64924\n",
       "                  12                   68600\n",
       "2016              1                    80385\n",
       "                  2                    96014\n",
       "                  3                    93911\n",
       "                  4                    70341\n",
       "                  5                    58165\n",
       "                  6                    58497\n",
       "                  7                    50545\n",
       "                  8                    54150\n",
       "                  9                    55095\n",
       "                  10                   56676\n",
       "                  11                   59256\n",
       "                  12                   45655\n",
       "2017              1                    75254\n",
       "                  2                    68808\n",
       "                  3                    75179\n",
       "                  4                    54969\n",
       "                  5                    61523\n",
       "                  6                    57044\n",
       "                  7                    52948\n",
       "                  8                    55020\n",
       "                  9                    58548\n",
       "                  10                   62408\n",
       "                  11                   58566\n",
       "                  12                   52142\n",
       "2018              1                    73596\n",
       "                  2                    61166\n",
       "                  3                    72937\n",
       "                  4                    66635\n",
       "                  5                    53763\n",
       "                  6                    50410\n",
       "                  7                    55358\n",
       "                  8                    58578\n",
       "                  9                    52158\n",
       "                  10                   68046\n",
       "                  11                   70026\n",
       "                  12                   64906\n",
       "2019              1                    92702\n",
       "                  2                   107102\n",
       "                  3                   107830\n",
       "                  4                   104872\n",
       "                  5                   102095\n",
       "                  6                    75596\n",
       "                  7                    88270\n",
       "                  8                    90412\n",
       "                  9                    85909\n",
       "                  10                   97624\n",
       "                  11                   88055\n",
       "                  12                   85523\n",
       "Name: Data de abertura, dtype: int64"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame['Data de abertura'].groupby([frame['Data de abertura'].dt.year, frame['Data de abertura'].dt.month]).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_agrupado = frame.groupby(['Tema', 'Assunto', 'Serviço'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Percentual georeferenciado\n",
    "quantidade_georeferenciada = len(frame[(frame['Data de abertura'] > '2019-01-01 00:00:00') & frame.Longitude.notna() & frame.Latitude.notna()])\n",
    "quantidade_total = len(frame[(frame['Data de abertura'] > '2019-01-01 00:00:00')])\n",
    "percentual = quantidade_georeferenciada / quantidade_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantidade georeferenciada com Lat e Long:\n",
      "294507\n",
      "Quantidade total de registros:\n",
      "1125990\n",
      "Percentual Georeferenciado:\n",
      "0.261553832627288\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantidade georeferenciada com Lat e Long:\")\n",
    "print(quantidade_georeferenciada)\n",
    "print(\"Quantidade total de registros:\")\n",
    "print(quantidade_total)\n",
    "print(\"Percentual Georeferenciado:\")\n",
    "print(percentual)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Percentual com setor e quadra\n",
    "quantidade_setor_quadra = len(frame[(frame['Data de abertura'] > '2019-01-01 00:00:00') & (frame.Setor.str.isnumeric() | frame.Quadra.str.isnumeric()) & frame.Longitude.isna() & frame.Latitude.isna()])\n",
    "quantidade_total = len(frame[(frame['Data de abertura'] > '2019-01-01 00:00:00')])\n",
    "percentual = quantidade_setor_quadra / quantidade_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantidade georeferenciada com Lat e Long:\n",
      "14781\n",
      "Quantidade total de registros:\n",
      "1125990\n",
      "Percentual Georeferenciado:\n",
      "0.013127114805637706\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantidade georeferenciada com Lat e Long:\")\n",
    "print(quantidade_setor_quadra)\n",
    "print(\"Quantidade total de registros:\")\n",
    "print(quantidade_total)\n",
    "print(\"Percentual Georeferenciado:\")\n",
    "print(percentual)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Percentual com Logradouro e número\n",
    "quantidade_logradouro_numero = len(frame[((frame.Logradouro.str.len() > 1) & (frame['Número'].str.len() > 1)) & frame.Longitude.isna() & frame.Latitude.isna()])\n",
    "quantidade_total = len(frame)\n",
    "percentual = quantidade_logradouro_numero / len(frame['Data de abertura'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantidade georeferenciável com Endereço:\n",
      "0\n",
      "Quantidade total de registros:\n",
      "4137583\n",
      "Percentual Georeferenciado:\n",
      "0.0\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantidade georeferenciável com Endereço:\")\n",
    "print(quantidade_logradouro_numero)\n",
    "print(\"Quantidade total de registros:\")\n",
    "print(quantidade_total)\n",
    "print(\"Percentual Georeferenciado:\")\n",
    "print(percentual)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "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>Data de abertura</th>\n",
       "      <th>Canal</th>\n",
       "      <th>Tema</th>\n",
       "      <th>Assunto</th>\n",
       "      <th>Serviço</th>\n",
       "      <th>Logradouro</th>\n",
       "      <th>Número</th>\n",
       "      <th>CEP</th>\n",
       "      <th>Subprefeitura</th>\n",
       "      <th>Distrito</th>\n",
       "      <th>Setor</th>\n",
       "      <th>Quadra</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Data do parecer</th>\n",
       "      <th>Status da solicitação</th>\n",
       "      <th>Órgão</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-07-01 00:00:15</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE</td>\n",
       "      <td>REPUBLICA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-07-01 02:49:11</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-07-01 00:00:42</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SANTANA-TUCURUVI</td>\n",
       "      <td>SANTANA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-07-01 01:56:37</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-07-01 00:04:40</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PINHEIROS</td>\n",
       "      <td>PINHEIROS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-07-01 03:35:26</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-07-01 00:08:07</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Trânsito e Transporte</td>\n",
       "      <td>Reclamação ônibus</td>\n",
       "      <td>Ônibus - Denúncia de problemas no embarque/des...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAO MATEUS</td>\n",
       "      <td>SAO MATEUS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-07-01 01:32:42</td>\n",
       "      <td>CANCELADA</td>\n",
       "      <td>SPTRANS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-07-01 00:14:57</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MOOCA</td>\n",
       "      <td>BRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-07-01 02:18:57</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4137577</th>\n",
       "      <td>2018-12-31 23:21:20</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Calçadas, guias e postes</td>\n",
       "      <td>Obstáculo dificultando acessibilidade</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>VILA MARIANA</td>\n",
       "      <td>SAUDE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-04-11 20:29:05</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMPR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4137578</th>\n",
       "      <td>2018-12-31 23:29:25</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>SE</td>\n",
       "      <td>REPUBLICA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-01-01 03:16:22</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4137579</th>\n",
       "      <td>2018-12-31 23:40:26</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>CIDADE TIRADENTES</td>\n",
       "      <td>CIDADE TIRADENTES</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-01-01 05:30:35</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4137580</th>\n",
       "      <td>2018-12-31 23:40:40</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>SE</td>\n",
       "      <td>SE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-01-01 03:57:14</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4137581</th>\n",
       "      <td>2018-12-31 23:46:31</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Cidadania e assistência social</td>\n",
       "      <td>População ou pessoa em situação de rua</td>\n",
       "      <td>Serviço Especializado de Abordagem Social às P...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MOOCA</td>\n",
       "      <td>BRAS</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-01-01 04:44:28</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMADS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3107914 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Data de abertura               Canal  \\\n",
       "0       2019-07-01 00:00:15  CENTRAL TELEFÔNICA   \n",
       "1       2019-07-01 00:00:42  CENTRAL TELEFÔNICA   \n",
       "2       2019-07-01 00:04:40  CENTRAL TELEFÔNICA   \n",
       "3       2019-07-01 00:08:07       PORTAL ONLINE   \n",
       "4       2019-07-01 00:14:57  CENTRAL TELEFÔNICA   \n",
       "...                     ...                 ...   \n",
       "4137577 2018-12-31 23:21:20       PORTAL ONLINE   \n",
       "4137578 2018-12-31 23:29:25  CENTRAL TELEFÔNICA   \n",
       "4137579 2018-12-31 23:40:26  CENTRAL TELEFÔNICA   \n",
       "4137580 2018-12-31 23:40:40  CENTRAL TELEFÔNICA   \n",
       "4137581 2018-12-31 23:46:31  CENTRAL TELEFÔNICA   \n",
       "\n",
       "                                   Tema  \\\n",
       "0        Cidadania e assistência social   \n",
       "1        Cidadania e assistência social   \n",
       "2        Cidadania e assistência social   \n",
       "3                 Trânsito e Transporte   \n",
       "4        Cidadania e assistência social   \n",
       "...                                 ...   \n",
       "4137577                    Rua e bairro   \n",
       "4137578  Cidadania e assistência social   \n",
       "4137579  Cidadania e assistência social   \n",
       "4137580  Cidadania e assistência social   \n",
       "4137581  Cidadania e assistência social   \n",
       "\n",
       "                                        Assunto  \\\n",
       "0        População ou pessoa em situação de rua   \n",
       "1        População ou pessoa em situação de rua   \n",
       "2        População ou pessoa em situação de rua   \n",
       "3                             Reclamação ônibus   \n",
       "4        População ou pessoa em situação de rua   \n",
       "...                                         ...   \n",
       "4137577                Calçadas, guias e postes   \n",
       "4137578  População ou pessoa em situação de rua   \n",
       "4137579  População ou pessoa em situação de rua   \n",
       "4137580  População ou pessoa em situação de rua   \n",
       "4137581  População ou pessoa em situação de rua   \n",
       "\n",
       "                                                   Serviço Logradouro Número  \\\n",
       "0        Serviço Especializado de Abordagem Social às P...        NaN    NaN   \n",
       "1        Serviço Especializado de Abordagem Social às P...        NaN    NaN   \n",
       "2        Serviço Especializado de Abordagem Social às P...        NaN    NaN   \n",
       "3        Ônibus - Denúncia de problemas no embarque/des...        NaN    NaN   \n",
       "4        Serviço Especializado de Abordagem Social às P...        NaN    NaN   \n",
       "...                                                    ...        ...    ...   \n",
       "4137577              Obstáculo dificultando acessibilidade                     \n",
       "4137578  Serviço Especializado de Abordagem Social às P...                     \n",
       "4137579  Serviço Especializado de Abordagem Social às P...                     \n",
       "4137580  Serviço Especializado de Abordagem Social às P...                     \n",
       "4137581  Serviço Especializado de Abordagem Social às P...                     \n",
       "\n",
       "         CEP      Subprefeitura           Distrito Setor Quadra  Latitude  \\\n",
       "0        NaN                 SE          REPUBLICA   NaN    NaN       NaN   \n",
       "1        NaN   SANTANA-TUCURUVI            SANTANA   NaN    NaN       NaN   \n",
       "2        NaN          PINHEIROS          PINHEIROS   NaN    NaN       NaN   \n",
       "3        NaN         SAO MATEUS         SAO MATEUS   NaN    NaN       NaN   \n",
       "4        NaN              MOOCA               BRAS   NaN    NaN       NaN   \n",
       "...      ...                ...                ...   ...    ...       ...   \n",
       "4137577            VILA MARIANA              SAUDE                    NaN   \n",
       "4137578                      SE          REPUBLICA                    NaN   \n",
       "4137579       CIDADE TIRADENTES  CIDADE TIRADENTES                    NaN   \n",
       "4137580                      SE                 SE                    NaN   \n",
       "4137581                   MOOCA               BRAS                    NaN   \n",
       "\n",
       "         Longitude     Data do parecer Status da solicitação    Órgão  \n",
       "0              NaN 2019-07-01 02:49:11            FINALIZADA    SMADS  \n",
       "1              NaN 2019-07-01 01:56:37            FINALIZADA    SMADS  \n",
       "2              NaN 2019-07-01 03:35:26            FINALIZADA    SMADS  \n",
       "3              NaN 2019-07-01 01:32:42             CANCELADA  SPTRANS  \n",
       "4              NaN 2019-07-01 02:18:57            FINALIZADA    SMADS  \n",
       "...            ...                 ...                   ...      ...  \n",
       "4137577        NaN 2019-04-11 20:29:05            FINALIZADA     SMPR  \n",
       "4137578        NaN 2019-01-01 03:16:22            FINALIZADA    SMADS  \n",
       "4137579        NaN 2019-01-01 05:30:35            FINALIZADA    SMADS  \n",
       "4137580        NaN 2019-01-01 03:57:14            FINALIZADA    SMADS  \n",
       "4137581        NaN 2019-01-01 04:44:28            FINALIZADA    SMADS  \n",
       "\n",
       "[3107914 rows x 17 columns]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame[((frame.Logradouro.str != '') & (frame['Número'].str != '')) & frame.Longitude.isna() & frame.Latitude.isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\ipykernel_launcher.py:2: FutureWarning: The signature of `Series.to_csv` was aligned to that of `DataFrame.to_csv`, and argument 'header' will change its default value from False to True: please pass an explicit value to suppress this warning.\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "# Agrupando por temas os atendimentos georeferenciaveis\n",
    "frame[frame.Setor.str.isnumeric() | frame.Quadra.str.isnumeric() | frame.Longitude.notna() | frame.Latitude.notna()].groupby(['Tema', 'Assunto', 'Serviço']).size().to_csv(r'resultados\\sp156_atendimentos_agrupados_georeferenciaveis.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEGCAYAAAB7DNKzAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAAXlElEQVR4nO3df9BeZZ3f8ffHRBF/gPwIDJtQgyVVgdYfZJDdrTvOZFdStQtOoQ1VyXbpZJZiq7Y7LdR22GozC+6O7DIWWkZYArUCog6ow2o26LhaBIO6YkAkFQqRFKKwLGphN/jtH+d6yp2HJ1eS536e3Am8XzNn7nN/z7muXOfMDZ/n/LjPnapCkqSdecGkByBJ2rcZFJKkLoNCktRlUEiSugwKSVLXwkkPYK4dfvjhtXTp0kkPQ5L2K3fcccePq2rRTMuec0GxdOlSNm7cOOlhSNJ+Jcn/3tkyTz1JkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6nnPfzJakvWnpeV+Y9BAAuP/Ct89b3x5RSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkrl0GRZIrkzyS5HsjtT9I8v0k303y2SSvGFl2fpLNSe5JcspI/cQkd7ZllyRJqx+Q5LpWvy3J0pE2q5Pc26bVc7XRkqTdtztHFFcBK6fV1gMnVNXfA34AnA+Q5DhgFXB8a3NpkgWtzWXAGmBZm6b6PBt4rKqOBS4GLmp9HQpcALwJOAm4IMkhe76JkqRx7DIoquqrwKPTal+qqu3t7TeAJW3+VODaqnqqqu4DNgMnJTkKOKiqbq2qAq4GThtps67N3wCsaEcbpwDrq+rRqnqMIZymB5YkaZ7NxTWK3wZubvOLgQdHlm1ptcVtfnp9hzYtfB4HDuv0JUnai8YKiiQfBLYDn5gqzbBadeqzbTN9HGuSbEyycdu2bf1BS5L2yKyDol1cfgfwrnY6CYa/+o8eWW0J8FCrL5mhvkObJAuBgxlOde2sr2epqsuranlVLV+0aNFsN0mSNINZBUWSlcC/A36zqn4+sugmYFW7k+kYhovWt1fVVuCJJCe36w9nATeOtJm6o+l04JYWPF8E3prkkHYR+62tJknai3b5mPEknwTeAhyeZAvDnUjnAwcA69tdrt+oqt+pqk1JrgfuYjgldW5VPd26OofhDqoDGa5pTF3XuAK4JslmhiOJVQBV9WiSDwPfbOt9qKp2uKguSZp/uwyKqjpzhvIVnfXXAmtnqG8ETpih/iRwxk76uhK4cldjlCTNH7+ZLUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUtcugyLJlUkeSfK9kdqhSdYnube9HjKy7Pwkm5Pck+SUkfqJSe5syy5JklY/IMl1rX5bkqUjbVa3f+PeJKvnaqMlSbtvd44orgJWTqudB2yoqmXAhvaeJMcBq4DjW5tLkyxobS4D1gDL2jTV59nAY1V1LHAxcFHr61DgAuBNwEnABaOBJEnaO3YZFFX1VeDRaeVTgXVtfh1w2kj92qp6qqruAzYDJyU5Cjioqm6tqgKuntZmqq8bgBXtaOMUYH1VPVpVjwHreXZgSZLm2WyvURxZVVsB2usRrb4YeHBkvS2ttrjNT6/v0KaqtgOPA4d1+nqWJGuSbEyycdu2bbPcJEnSTOb6YnZmqFWnPts2OxarLq+q5VW1fNGiRbs1UEnS7pltUDzcTifRXh9p9S3A0SPrLQEeavUlM9R3aJNkIXAww6munfUlSdqLZhsUNwFTdyGtBm4cqa9qdzIdw3DR+vZ2euqJJCe36w9nTWsz1dfpwC3tOsYXgbcmOaRdxH5rq0mS9qKFu1ohySeBtwCHJ9nCcCfShcD1Sc4GHgDOAKiqTUmuB+4CtgPnVtXTratzGO6gOhC4uU0AVwDXJNnMcCSxqvX1aJIPA99s632oqqZfVJckzbNdBkVVnbmTRSt2sv5aYO0M9Y3ACTPUn6QFzQzLrgSu3NUYJUnzx29mS5K6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldu3wooCRNt/S8L0x6CADcf+HbJz2E5wWPKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV1+M1vaTX4bWc9XHlFIkrrGCookH0iyKcn3knwyyYuTHJpkfZJ72+shI+ufn2RzknuSnDJSPzHJnW3ZJUnS6gckua7Vb0uydJzxSpL23KyDIsli4F8By6vqBGABsAo4D9hQVcuADe09SY5ry48HVgKXJlnQursMWAMsa9PKVj8beKyqjgUuBi6a7XglSbMz7qmnhcCBSRYCLwEeAk4F1rXl64DT2vypwLVV9VRV3QdsBk5KchRwUFXdWlUFXD2tzVRfNwArpo42JEl7x6yDoqp+BPwh8ACwFXi8qr4EHFlVW9s6W4EjWpPFwIMjXWxptcVtfnp9hzZVtR14HDhs+liSrEmyMcnGbdu2zXaTJEkzGOfU0yEMf/EfA/wS8NIk7+41maFWnXqvzY6FqsuranlVLV+0aFF/4JKkPTLOqadfB+6rqm1V9TfAZ4BfAR5up5Nor4+09bcAR4+0X8JwqmpLm59e36FNO711MPDoGGOWJO2hcYLiAeDkJC9p1w1WAHcDNwGr2zqrgRvb/E3AqnYn0zEMF61vb6ennkhycuvnrGltpvo6HbilXceQJO0ls/7CXVXdluQG4FvAduDbwOXAy4Drk5zNECZntPU3JbkeuKutf25VPd26Owe4CjgQuLlNAFcA1yTZzHAksWq245Ukzc5Y38yuqguAC6aVn2I4uphp/bXA2hnqG4ETZqg/SQsaSdJk+M1sSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdY319Fg99y097wuTHgIA91/49kkPQXre8ohCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUNVZQJHlFkhuSfD/J3Ul+OcmhSdYnube9HjKy/vlJNie5J8kpI/UTk9zZll2SJK1+QJLrWv22JEvHGa8kac+Ne0Txx8CfVtVrgNcBdwPnARuqahmwob0nyXHAKuB4YCVwaZIFrZ/LgDXAsjatbPWzgceq6ljgYuCiMccrSdpDsw6KJAcBvwZcAVBVf11VfwmcCqxrq60DTmvzpwLXVtVTVXUfsBk4KclRwEFVdWtVFXD1tDZTfd0ArJg62pAk7R3jHFG8CtgG/EmSbyf5eJKXAkdW1VaA9npEW38x8OBI+y2ttrjNT6/v0KaqtgOPA4dNH0iSNUk2Jtm4bdu2MTZJkjTdOEGxEHgjcFlVvQH4Ge00007MdCRQnXqvzY6FqsuranlVLV+0aFF/1JKkPTJOUGwBtlTVbe39DQzB8XA7nUR7fWRk/aNH2i8BHmr1JTPUd2iTZCFwMPDoGGOWJO2hWQdFVf0f4MEkr26lFcBdwE3A6lZbDdzY5m8CVrU7mY5huGh9ezs99USSk9v1h7OmtZnq63TglnYdQ5K0l4z7w0X/EvhEkhcBPwT+GUP4XJ/kbOAB4AyAqtqU5HqGMNkOnFtVT7d+zgGuAg4Ebm4TDBfKr0mymeFIYtWY45Uk7aGxgqKqvgMsn2HRip2svxZYO0N9I3DCDPUnaUEjSZoMv5ktSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklS19hBkWRBkm8n+Xx7f2iS9Unuba+HjKx7fpLNSe5JcspI/cQkd7ZllyRJqx+Q5LpWvy3J0nHHK0naM3NxRPE+4O6R9+cBG6pqGbChvSfJccAq4HhgJXBpkgWtzWXAGmBZm1a2+tnAY1V1LHAxcNEcjFeStAfGCookS4C3Ax8fKZ8KrGvz64DTRurXVtVTVXUfsBk4KclRwEFVdWtVFXD1tDZTfd0ArJg62pAk7R3jHlH8EfBvgV+M1I6sqq0A7fWIVl8MPDiy3pZWW9zmp9d3aFNV24HHgcOmDyLJmiQbk2zctm3bmJskSRo166BI8g7gkaq6Y3ebzFCrTr3XZsdC1eVVtbyqli9atGg3hyNJ2h0Lx2j7q8BvJnkb8GLgoCT/HXg4yVFVtbWdVnqkrb8FOHqk/RLgoVZfMkN9tM2WJAuBg4FHxxizJGkPzfqIoqrOr6olVbWU4SL1LVX1buAmYHVbbTVwY5u/CVjV7mQ6huGi9e3t9NQTSU5u1x/OmtZmqq/T27/xrCMKSdL8GeeIYmcuBK5PcjbwAHAGQFVtSnI9cBewHTi3qp5ubc4BrgIOBG5uE8AVwDVJNjMcSayah/FKkjrmJCiq6ivAV9r8T4AVO1lvLbB2hvpG4IQZ6k/SgkaSNBnzcUSx31t63hcmPQQA7r/w7ZMegiT5CA9JUp9BIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqSuWQdFkqOTfDnJ3Uk2JXlfqx+aZH2Se9vrISNtzk+yOck9SU4ZqZ+Y5M627JIkafUDklzX6rclWTr7TZUkzcY4RxTbgX9TVa8FTgbOTXIccB6woaqWARvae9qyVcDxwErg0iQLWl+XAWuAZW1a2epnA49V1bHAxcBFY4xXkjQLsw6KqtpaVd9q808AdwOLgVOBdW21dcBpbf5U4Nqqeqqq7gM2AyclOQo4qKpuraoCrp7WZqqvG4AVU0cbkqS9Y06uUbRTQm8AbgOOrKqtMIQJcERbbTHw4EizLa22uM1Pr+/Qpqq2A48Dh83w769JsjHJxm3bts3FJkmSmrGDIsnLgE8D76+qv+qtOkOtOvVemx0LVZdX1fKqWr5o0aJdDVmStAfGCookL2QIiU9U1Wda+eF2Oon2+kirbwGOHmm+BHio1ZfMUN+hTZKFwMHAo+OMWZK0Z8a56ynAFcDdVfXRkUU3Aavb/GrgxpH6qnYn0zEMF61vb6ennkhycuvzrGltpvo6HbilXceQJO0lC8do+6vAe4A7k3yn1f49cCFwfZKzgQeAMwCqalOS64G7GO6YOreqnm7tzgGuAg4Ebm4TDEF0TZLNDEcSq8YYryRpFmYdFFX1NWa+hgCwYidt1gJrZ6hvBE6Yof4kLWgkSZPhN7MlSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnq2i+CIsnKJPck2ZzkvEmPR5KeT/b5oEiyAPgvwD8AjgPOTHLcZEclSc8f+3xQACcBm6vqh1X118C1wKkTHpMkPW+kqiY9hq4kpwMrq+qft/fvAd5UVe8dWWcNsKa9fTVwz14f6LMdDvx40oPYR7gvnuG+eIb74hn7wr54ZVUtmmnBwr09klnIDLUd0q2qLgcu3zvD2T1JNlbV8kmPY1/gvniG++IZ7otn7Ov7Yn849bQFOHrk/RLgoQmNRZKed/aHoPgmsCzJMUleBKwCbprwmCTpeWOfP/VUVduTvBf4IrAAuLKqNk14WLtjnzoVNmHui2e4L57hvnjGPr0v9vmL2ZKkydofTj1JkibIoJAkdRkUuynJ0Um+nOTuJJuSvK/VD02yPsm97fWQVj+srf/TJB+b1tdX2iNJvtOmIyaxTbM1x/viRUkuT/KDJN9P8o8msU2zNVf7IsnLRz4P30ny4yR/NKntmo05/lycmeTOJN9N8qdJDp/ENs3WHO+Lf9L2w6YkH5nE9lBVTrsxAUcBb2zzLwd+wPBIkY8A57X6ecBFbf6lwN8Hfgf42LS+vgIsn/Q27SP74j8B/7nNvwA4fNLbN6l9Ma3fO4Bfm/T2TWJfMNxk88jUZ6G1/71Jb9+E9sVhwAPAovZ+HbBib2+PRxS7qaq2VtW32vwTwN3AYobHiaxrq60DTmvr/KyqvgY8OYHhzqs53he/Dfx+W+8XVTXpb6fukfn4XCRZBhwB/Pk8Dn3OzeG+SJtemiTAQexn352aw33xKuAHVbWtvf8zYK8fdRsUs5BkKfAG4DbgyKraCsOHg+E/8N3xJ+0Uw39s/zHsl8bZF0le0WY/nORbST6V5Mh5HO68mqPPBcCZwHXV/oTcH42zL6rqb4BzgDsZAuI44Ip5HO68GvNzsRl4TZKlSRYyBMvRu2gz5wyKPZTkZcCngfdX1V/Nspt3VdXfBd7cpvfM1fj2pjnYFwsZvmn/9ap6I3Ar8IdzOMS9Zo4+F1NWAZ8cf1STMe6+SPJChqB4A/BLwHeB8+d0kHvJuPuiqh5j2BfXMRxh3g9sn8sx7g6DYg+0D/CngU9U1Wda+eEkR7XlRzGcW+2qqh+11yeA/8HwhNz9yhzti58APwc+295/CnjjPAx3Xs3V56Kt+zpgYVXdMS+DnWdztC9eD1BV/6sdVV0P/Mo8DXnezOH/Lz5XVW+qql9meODpvfM15p0xKHZTOz10BXB3VX10ZNFNwOo2vxq4cRf9LJy6g6N9kN4BfG/uRzx/5mpftP8JfA54SyutAO6a08HOs7naFyPOZD89mpjDffEj4LgkU08y/Q2Gc/z7jbn8XKTdFdnukPoXwMfndrS7YW9fPd9fJ4Y7EorhMPg7bXobw10JGxhSfgNw6Eib+4FHgZ8yPNzwOIa7G+5o/WwC/hhYMOntm8S+aPVXAl9tfW0A/takt29S+6It+yHwmklv16T3BcPdP3e3vj4HHDbp7Zvgvvgkwx9QdwGrJrE9PsJDktTlqSdJUpdBIUnqMigkSV0GhSSpy6CQJHUZFHpOSPJ0eyTKpiR/keRfJ+l+vttjEf7pmP/u7yX53XH6aP381vSnhs6ij/cnecm4Y5GmMyj0XPF/q+r1VXU8wxe03gZcsIs2S4GxgmJfkWQB8H5gj4KiPT9I6jIo9JxTVY8Aa4D3ZrA0yZ+3Bw9+K8nU4yAuBN7cjkQ+0FlvB0k+mOH3RP4MePVI/W+33064o/XzmhnanpTkfyb5dnt99cjio1v7e5JcMNLm3Ulub+P8by0UaL9d8KEktwEfZHgu0peTfHlq+Ugfpye5qs1fleSjbb2LdjEmyW9mOz03JuCnM9QeA45k+Cv7xa22DNjY5t8CfH5k/RnXm9bniQxPNX0Jw+OvNwO/25ZtAJa1+TcBt8zQ/iCGZzkB/Drw6Tb/W8BWhm/uHsjwWJflwGsZvpn8wrbepcBZbb6AfzzS9/2M/J7H6D4BTgeuavNXAZ+nPRFgZ2NycpqaPOzUc9nU49tfCHwsyeuBp4G/s5P1d2e9NwOfraqfAyS5qb2+jOHBdZ8aeWr8ATO0PxhYl+E3J6r9m1PWV9VPWn+fYXgMxHaGcPpm6/dAnnmQ3NMMD52bjU9V1dO7MSbJoNBzU5JXMfyP9BGGaxUPA69jON26sx8N+sBurjfTc29eAPxlVb1+F0P7MPDlqnpn+52Cr3T6LYawW1dVMz1m+8mR/9nvapwvnrbsZ7s5JslrFHruaU8d/a8MPylZDH8xb62qXzD89seCtuoTDD9TOWVn6436KvDOJAcmeTnwDwFq+K2B+5Kc0caQ9sjw6Q5meDoqDKebRv1Ght9UPpDhB2q+znA66/SRJ4gemuSVO9n06dvzcJLXtru/3rmTNrsak2RQ6DnjwKnbYxl+LvJLDL/HDcN5/dVJvsFwOmnqr+nvAtvb7bQf6Kz3/9Xw85bXMTwN9NPs+HOl7wLOTvIXDE8GPnWGcX4E+P0kX+fZQfQ14JqpvqtqY1XdBfwH4EtJvgusZ/g95plcDtw8dTGb4TeZPw/cwnD9Y2d6Y5J8eqwkqc8jCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1PX/AHxqrmEzZ6mNAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "frame.index.name = 'id'\n",
    "frame['counter'] = 1\n",
    "#frame_mes_SEAS = frame.loc[frame['Serviço'] == 'Serviço Especializado de Abordagem Social às Pessoas em Situação de Rua - SEAS'].groupby([frame['Data de abertura'].dt.year, frame['Data de abertura'].dt.month]).counter.count()\n",
    "frame_mes_SEAS = frame.loc[frame['Serviço'] == 'Serviço Especializado de Abordagem Social às Pessoas em Situação de Rua - SEAS'].groupby(frame['Data de abertura'].dt.year).counter.count()\n",
    "ax = frame_mes_SEAS.plot.bar(x='m', y='v', rot=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "frame.loc[frame['Serviço'] == 'Serviço Especializado de Abordagem Social às Pessoas em Situação de Rua - SEAS'][['Canal','Data de abertura', 'Distrito']].to_csv(r'resultados\\sp156_atendimento_SEAS.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1c0cb5b07c8>"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEGCAYAAABLgMOSAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAAgAElEQVR4nOy9d5gkV3nv/z0VOqfJMzuzOWp3FXcVEUJCCAmBLRkElg2S7CtbNha+gLH9A2NzbTC+Bhtjy7YwQQLBD5BE8mJAiVVCgV2tpJU2787GyXk6h+rqc/+oc6qr4/TM9HTPTJ/P88wzPdVdPdWh6j3v902EUgqBQCAQCGaLVO8DEAgEAsHSRBgQgUAgEMwJYUAEAoFAMCeEAREIBALBnBAGRCAQCARzQqn3AcyV1tZWumbNmnofhkAgECwpXn311XFKaVs1nmvJGpA1a9Zg37599T4MgUAgWFIQQs5W67mEhCUQCASCOSEMiEAgEAjmhDAgAoFAIJgTwoAIBAKBYE4IAyIQCASCOSEMiEAgEAjmhDAgAoFAIJgTwoAIBAIBgISm49F9fRAjLipnRgNCCHEQQvYSQt4ghBwihPwd295MCHmKEHKC/W6y7PMpQkgvIeQYIeRGy/YdhJAD7L77CCGEbbcTQh5h2/cQQtZU/6UKBAJBaZ46PIK//OGbODYSrvehLBkq8UCSAN5OKb0QwEUAbiKEXAHgkwB2U0o3AtjN/gYhZCuA2wFsA3ATgPsJITJ7rq8AuAfARvZzE9t+N4ApSukGAF8G8IUqvDaBQCComOFgAgAQT+l1PpKlw4wGhBpE2J8q+6EAbgHwENv+EIBb2e1bADxMKU1SSk8D6AVwGSGkC4CPUvoyNXzEb+ftw5/rhwCu596JQCAQ1IKRkGFANF1IWJVSUQyEECITQvYDGAXwFKV0D4AOSukQALDf7ezh3QD6LLv3s23d7Hb+9px9KKVpAEEALUWO4x5CyD5CyL6xsbHKXqFAIBBUwEg4CQDQ9Eydj2TpUJEBoZTqlNKLAPTA8Ca2l3l4Mc+Bltlebp/84/gapXQnpXRnW1tVmkkKBAIBAGCUeSCptDAglTKrLCxK6TSAZ2HELkaYLAX2e5Q9rB/ASstuPQAG2faeIttz9iGEKAD8ACZnc2wCgUAwH0aZB5ISHkjFVJKF1UYICbDbTgDvAHAUwE8B3MUedheAXez2TwHczjKr1sIIlu9lMleYEHIFi2/cmbcPf67bADxNRS6dQCCoEZRSMwYiPJDKqWQeSBeAh1gmlQTgUUrpzwghLwN4lBByN4BzAN4PAJTSQ4SQRwEcBpAGcC+llKc1fBjAtwA4ATzGfgDgAQDfIYT0wvA8bq/GixMIBIJKiCTTiLHsKxEDqZwZDQil9E0AFxfZPgHg+hL7fB7A54ts3wegIH5CKU2AGSCBQCCoNVy+AoQBmQ2iEl0gEDQ8XL4ChIQ1G4QBEQgEDc9oKOuBpEQdSMUIAyIQCBoeqwciJKzKEQZEIBA0PCOhJOyKcTkUElblCAMiEAgansloEm1eOwgRHshsEAZEIBA0PMG4hoBLhU2WRCHhLBAGRCAQNDzBuAa/kxkQIWFVjDAgAoGg4eEGRFUkIWHNAmFABAJBwxOMp00PREuLNN5KEQZEIBA0NJRShOIafE4VqkJEDGQWCAMiEAgamoSWQUrPGBKWCKLPCmFABAJBQxOMawBgkbCEAakUYUAEAkFDk2NAFOGBzAZhQAQCQUNjNSCqLLKwZoMwIAKBoKEplLBEFlalCAMiEAgamhwPRJGQFB5IxQgDIhAIGppcD4RAS2fw8N5z+P7ec3U+ssWPMCACgaCh4QbE68gG0R9+pQ8PvXSmvge2BKhkJrpAIBAsW0JxDV6HAlkiZhA9lkpjaDoBSikIIfU+xEWL8EAEAkFDw/tgATDrQKJJHeFkGqF4us5Ht7gRBkQgEDQ0VgOiMgkrkjQMR99UrJ6HtugRBkQgEDQ0+R5IKm1IWADQPxWv56EteoQBEQgEDU2OAVEkxFI6NN2oBekXHkhZhAERCAQNTTihwedgEpZMkM5kCwmFB1IeYUAEAkFDE0mk4XUYCamqnHtJFAakPMKACASChkXPUERTOjzMgNiU7CVRIkLCmglhQBoATc/gcz87jH/95fF6H4pAsKjg2VYeOzMgFg9kdYsbA1NxUCp6Y5VCGJAG4N7vvoYHXjiNf/3liXofikCwqOAGpJiEtbnDW7QWRM9Q/Ml3X8Vr56Zqd6CLlBkNCCFkJSHkGULIEULIIULIR9n2vyWEDBBC9rOfmy37fIoQ0ksIOUYIudGyfQch5AC77z7CSjwJIXZCyCNs+x5CyJrqv9TGJJOhePLwCACgO+Cs89EIBIuLSIJ7INksLM7mTi+AwlqQ6VgKvzgwjOePj9XoKBcvlXggaQCfoJSeB+AKAPcSQray+75MKb2I/fwCANh9twPYBuAmAPcTQmT2+K8AuAfARvZzE9t+N4ApSukGAF8G8IX5vzQBgJzhOOGEVscjEQgWH5GkcU54inkgzIDkB9ITbGLhdEycTzMaEErpEKX0NXY7DOAIgO4yu9wC4GFKaZJSehpAL4DLCCFdAHyU0pepISp+G8Ctln0eYrd/COB6IhrQVAVuQJyqjEgyLfRcgcBCOJEbA1Hl7GUna0AMD+SbL57Gnz2yHwlNBwBMRlO1PNRFyaxiIExauhjAHrbpI4SQNwkhDxJCmti2bgB9lt362bZudjt/e84+lNI0gCCAliL//x5CyD5CyL6xMeE+VkKKrZaa3TZkKBBnX36BQFAYA7FbJKzugBMeu2J6IP+9fxDPnxg3DchUTBiQig0IIcQD4EcAPkYpDcGQo9YDuAjAEIAv8YcW2Z2W2V5un9wNlH6NUrqTUrqzra2t0kNvaPh4zma3DUBW8xUIBNYYSK6EJUsEdkVCT5MT/VNxJNM6jgyGkNB0JDTjnBIeSIUGhBCiwjAe36WU/hgAKKUjlFKdUpoB8HUAl7GH9wNYadm9B8Ag295TZHvOPoQQBYAfwORcXpAgF6sHAgAhYUAEAhMzjTcvBuK2ySCEMAMSw9GhMFJ6BglNR5J7IMKAVJSFRQA8AOAIpfRfLNu7LA/7LQAH2e2fAridZVathREs30spHQIQJoRcwZ7zTgC7LPvcxW7fBuBpKsT6qsA9kBbugSSFAREIODwG4rblFhJyj6SnyYWBqTje6J8GAKQzFGF2Dk0KCauigVJvAXAHgAOEkP1s218B+B1CyEUwpKYzAP4IACilhwghjwI4DCOD615KKRfePwzgWwCcAB5jP4BhoL5DCOmF4XncPr+XJeAk00LCEghKEUmm4bbJkCVDReceiMs0IE6Ek2k8f3zc3GeaGY6ElkE8pcNpk9GozGhAKKUvoHiM4hdl9vk8gM8X2b4PwPYi2xMA3j/TsQhmD+8q2mR6ICL1UCDgRBJpU74CspXobosBAZBT8zFlSd+diqXgtDVufZWoRF/m8BgIl7DCwgMRCEwiybQpVwFWCcvwKja0ewAAbV47br/UCO1as68aPZAuZqIvc/KzsIQBEQiyhJNpeFgrdyBbB+JiMZEN7V7s/sTbsKrZhacOj+DhV/owHc31QBoZYUCWOflZWCKILhBkiSQ0eC0eCI+BWL2S9W2GF+JUDa9EeCBZhIS1zOFBdKdNNqvRBQKBQb6ExQsJ3fbCwLiDGRBrC5Nnj43hM7sOIp5qzAJd4YEsc7iEZZMleByKkLAEAgv5QfRsHUjhpZFnW03HU7DJErRMBj95fQAAMDAVx1fv2AFFbqw1eWO92gaES1g2RYLXrmAsnMS933sNZ8ajdT4ygaC+aHrGiIFYJSwlNwvLSlbC0uC0yQiwOepbu3zYfXQUz59ovPZKwoAsc7gHojIP5KWT4/j5m0PYc3qizkcmENSPR1/pw8ZPP4awZZwtYFSgf/T6jbj5/M6CfZymhJWCQ5XM1Pgv3nYBAODUWOMtyoSEtczh3XhtigSPXUGMabWRZGNqtgIBAPyqN1sYaPVACCH4+A2biu7jUI31tqZTOFQZ69s8WNfqxrYVPngtTRcbCWFAljlcwlJlKWelJSrSBY1Mp89u3q60ktxheZxDkfGVD16CDDWMTk+zC+cmG29+upCwljncA7Erkjl1DRAV6YLGxuqBVzp4iEtYgOGNKLJkFh6uanYuSgPyb788gX987OiCPb8wIMscLW20MinwQEQ6r6CBiSbTWN3iwlfv2IH371w58w4wziGF9cyyq7ley6pmF/omY4tuYNuu/QN44tDwgj1/QxmQeErHcDBR78OoKSldhywRyBLJ0XpFOq+gkYmy7Ksbt3Wa9R2VwL2Q/H1WNruQTGcwFk5W9TjnQzKt48xEFMPBxIIZtoYyIP+2+wRuvu9XSFvmhC93UumM2SCO57s7VRlR4YEIGpj89N1K4XEQh5J76VzZ7AKARSVjnR6PmlNIF2oOUEMZkOMjYUxGU3ijP1jvQ6kZmk7N/j7Xbm7D7ZeuxPndfiFhCRqa6BwNSEkPpMkwIH1T9Tcgx4bD2Pn3T+HJQyPmtpHQwigvDWVA+tjq4CVLCt9yJ5nOwKYYX/YtnT784/sugN+lCglL0NBEk+mixYIzwVN5+W8Ob/t+bqL+qbxHh0MYj6TwtedPmdsWSrpvGANCKTXztF882TgGRNMzsMm5eSYeuyI8EEFDE0nqczIgpTwQhypjbavbnFy4UGh6Bo+8cg7/vvsEzk4UL1zkDR4jybRp6IaFBzI/JqIpxDUdXoeC185OL/vmZ788PIJP/+SAEQPJ02s9dkXEQAQNjSFhzX6SIDccziKB92s3t+HF3vE5XVve7J/Gfz7TO+Pjdh8Zwf/3owP40lPHS6bnWme1X7a2BQAwIjyQ+cHlq5u3dyGlZ3B0OFTnI1pYnjg0jB/s64emZ8wGcRyPw/BAFlvKoUBQC9J6BnFNz6mLqhRedJifxgsA12/pQDKdwUtzUDh+8voA/umJY0ho5Y3PvjNTsCkS7rxyNZ46PFI062syloJdkSAR4MIeP5pcqvBA5ksfk6+2dfsAGJkJy5mxSBIpPYNIMl3UA9F0arZ6FwgaAUop/uEXR7D39CSA4i3bZyIrYRVeOi9b2wy3Tcbuo6Ozft5g3CjsHZrBU3j13BQu7PHjzitXI52h+NFr/QWPmYpq6Gly4gd/fBX+4K3r0OFziCD6fOln2REb2HCYpLa8L558ZTIVSxUYEF5QKOIggkbi8FAIX3v+FL7/Sh8AzC8LSyk0PjZFwlUbWvHrk7NvVBpiBmRwunQQPqHpODgQxCWrm7Ch3YuLVwXw2IGhgsdNRlNodtuwY3UT/E4VnX6H8EDmS99kHC1um9lBcyZXcakzHjEMyGQkVSBh8VkHoh+WoJF4hnkGp8YiAIq3bJ8Jsw6kRPFhp88xpzG3fEjVQBkDcnAgCE2n2LGqCQBwXpcPfVNxTEVT2Pn3vzQ9q6lYCk0uW84xDQcXpsCxYQxI/1QMPU1Oc+LYcpZvMhmK8YjxJeZ6qBWP8EAEDcjTzICcZrNw5lcHUvzS6XMqCCVmH1/kEtZAmY6+e88YBuKS1YYB6Q44MRlNYX/fNMYjSRwcMOrbpmIpc4Q1AHT4HJiIJs3GqtWkYQzIwHQc3U1Oc+WwnD2QqVgKesb4Aie0wiA6nwEtDIigUZiMpvB6n5Fiy0cazK8OpLgH4nWo0DPU/B+VEiwjYSU0HQlNx3dePouLVwXQ6jE6CXf5HQCAPczzGI8kQSnFVFRDwOKB+J0qKAViqeqf7w3Tzn06pqHZbTM/+OXsgYxFct1VW5EsLEBIWILG4Y2+aVAKbO/24eCAkYG5IB6Iw8jsCidmV6hoGpBgrgGZiCTx1i8+gxaPDUPBBL70gQvN+1YEjOJFPhxuIpJCNKUjpWfQ7M5mmPEYqPBA5gilFMG4Br9TNeWc5eyBjIdzNVi1SBYWIDwQQePAsy43tnvNbXPqhVUmiA4YEhYAhBKlxyUkNB1hy/0JTTcXtIPTucHuYyNhxFI6BqcTuH5LO65a32re180MyAHWmmkimjRrQKwxEL6ATC1AD8CGMCDRlA49Q/MMyHL2QHK/hAUeiDAgggaDj3bmLUeAOabxlqkDAbIeCM+q4lBK8cKJcWQyFJ/72WF86IG95n38sR67goHpeE785My4kT36+Effivs/dEnOc3b4HCAESDO5eiySMqvQrTEQVTE6UWh69eu+GsKAcPfQ71ShsJ7+yfTy9UDyi4tsSl4rExFEFzQYXL7hTQ+BucVAZpKweIp8fq+5b710Bh96YA+eODSMwek4Dg4EzWsQvz5t6fQilc6YCTAAcGYiCpssYV2bB/Y8r8emSGj3ZicrTkSSmGQZYE1uqwdi7KcJD2RuBGNZAwIYbuhy9kDGI7mZV/keiFOVIREjBpLWM3ji0LCoShcsa/jqm3sgikQKshMr4cKVAVy2thmrW9xF7/exa0y+hPUIqz1JswC7nqFmNhg3IOd1GUXO/ZaOvmfGo1jV4oIsFZ+byOMgskQwHklikhmfZouExbtx1yUGQghZSQh5hhByhBByiBDyUba9mRDyFCHkBPvdZNnnU4SQXkLIMULIjZbtOwghB9h99xFCCNtuJ4Q8wrbvIYSsqeaL5B+QzzQg0rL3QNq8driZu51fSEgIMRsq/qp3HH/0nVexv29hm8AJBPUkxc73HuaBuO0K2OVnVqxv8+DRP7qyZPykmISV0HQcHQ6z48iY8ZhjbBu/Pr11Yyskkk03BgwPZE0JYwUAK/yGAdnc4UVCy5h1JE05ElZ9YyBpAJ+glJ4H4AoA9xJCtgL4JIDdlNKNAHazv8Huux3ANgA3AbifEMJ9r68AuAfARvZzE9t+N4ApSukGAF8G8IUqvDaTYNywytwDsSvL2wPhBoRLVflpvICRbhhOpDHNXN5yBUwCwVKHeyBNbhVumzynAHolcAnLOsDphRPZ3lixVNpM8T0xYhQ0cgOyscOLqze24cevDSCTochkKM5OxLC2NSu75bMiYKTyXrwqYDznaASyROCzjK/mCoRWDw+EUjpEKX2N3Q4DOAKgG8AtAB5iD3sIwK3s9i0AHqaUJimlpwH0AriMENIFwEcpfZkaesm38/bhz/VDANeTCpcHCU2fUX6xxkAAwK5KSCxzD6TVYzdPknwPBDACiNFkGpGk8T402qhfQWPBV9+qLKHD71gwA+JQZdgUKUfCer1vyrwdS+lmt94jQyH85zO9pifid6p43yXdGJiO49enJzAcSiCZzmBNa2kPZH2bB6pMsHONIQC9emYSnT5Hjndlq7MHYsKkpYsB7AHQQSkdAgwjA6CdPawbQJ9lt362rZvdzt+esw+lNA0gCKBlpuMJxjRc8rmn8Myx8s3LCgyIIi/rXlgj4QQ6fdmTpJgHwiUs3tZ9oZqtLRb+541BfPonB+p9GII6oVkMyJoWN9p99hn2mDs+h4pQPOuBRJO6eS7GUrpZ0Lf76Cj+6Ylj+NZLZ9h+xox2pyrjyUMjOMNiJGvLSFjv29GDJz/+NjM9eTCYwOVrm3Mew8//hQiiV2yGCSEeAD8C8DFKaaiMg1DsDlpme7l98o/hHhgSGFatWoWhUByxlI7T4+XHSAbjGmSJmB/ico2BZDJGh93pmIZOvwOnxo3XWyxY6HGoCMY104DM1AV0KZNKZ/D5nx/BaDiBv/vNbVCKGFTB8iaVzkCWCGSJ4Iu3XYDMAiaN+BxKTp1HPKXDbZdZhbohYREC8ENIpjPw2hUjQ1QGtnR5cXQ4hPVthuEo54GosoS1rW4MWQoQr1jfkvcYHkSvUxovIUSFYTy+Syn9Mds8wmQpsN/cDegHsNKyew+AQba9p8j2nH0IIQoAP4DJ/OOglH6NUrqTUrqzra3NzK4qVVGdTOs4MhQyiwi50bMr0rLzQB4/OIQLP/skTowa7nCnz2E2TSwaA7EriCQ0M5V3OXsgPz8wiOFQAhlaWKUvaAyMyZzGedDqsaPd61iw/+V1qjkxkLimw2VT4LLJiCTTSKYzeNumNlzY48etF60AkE3wAYzR00eHw9jfF0SL22a2LClHizvrUV25LteA2OspYbFYxAMAjlBK/8Vy108B3MVu3wVgl2X77Syzai2MYPleJnOFCSFXsOe8M28f/ly3AXiaVpBXyqWpaIkeLz/dP4j3/PsLOD4SMeUrgKXxLjMP5MlDIwgn0niBzXvv8jvMIHrpGIhueiAL1e55MfDQS2ehsDTI5expCUqj6dRciS80PoeSk4UVS+lwqjKcNhkTLM32qvUt2PWRq3HLRYaKb70+ndflxXRMw9NHR3DRykBF2WI2RYLPoaA74MTK5tygu1rPIDqAtwC4A8DbCSH72c/NAP4RwA2EkBMAbmB/g1J6CMCjAA4DeBzAvZRSfrX+MIBvwAisnwTwGNv+AIAWQkgvgD8Dy+iaCW5A8ot2OLyp4P5z0zkW3qHIy66VCW+o9utTxu8Ov8Nsmlg8BqKyGIjxPowEk8uyFiStZ3BoMIirNhgtIIamhQFpRFJ64WjnhcLnUHOC6HEtDadNhtumYIJVijuZOrBzTRMkkmtAtnQa9SBTMQ0XrQxU/H+3d/vxru2dBdvrGgOhlL6A4jEKALi+xD6fB/D5Itv3AdheZHsCwPtnOpZ8uAEpVVHNZaqUnsn5gOyqtKyaKfZPxcw03H2s5XOnz2FW2hY7cfhYW/5FT+kZTEZTaPEsXHCxHpybjEHTKa7Z2Irnj4/laMWCxkFLF3alXih8TiVnURtLGUF0PUPNOT0uVtHudah4y4ZWrGeD7gBgc2e2X9fFq8zyuhn57h9cXnQ7P//rGkRfjHA3MVrCgFhlKn8JDySc0PD6uWlcs6ltAY90YXmFGQ1VJoildHgdCtx2JSthlYiBALltT4ZDiWVnQE6MGrn2O9c0w6nKQsJqUGrugcRzg+htHjv0DEXvqOGBuGzZtiQP/f5lkCyV5n6niu6AE4PBOC5Y6a/4/5aSurjhXIhF85JORzE9kFJBdEug3O/M2kqrB/KDff2465t7zYD8UmTv6Sn4HAouXWOk7/GgW7YOpPCLxY3LSCiBNtZPZznWgvQyA7Kh3YMuv2NZvkbBzGh67TwQr0NBMp0xMz1jKR0umwyXTTHVEqfFgEhF2pRctDKArV0+s7J9PpiFhAvQTHFJeyAzSVglPRA164FMRJOgFAgnNfhd8/+w6sFwMI7VLW6sa3PjpZMT6PDlGRC5sHMol7emYhquXNeCsXByWQbST4yE0R1wwmNX0BVwFMxbEDQGqTStoYSVnQli98hGEN2mIGO5frts5S+9//De86smOS2khLU8PJAZYiAAEHBme8M4FAkJLQNKqTmLOD7LCWKLCU2nsCmS2TMn3wMpln3itVTirml1Q5bIsgwwnxiNYEO7oS93+pzCA2lQjDTe2mRh8WmAPOMqoXEPJLuQs94uht+pmpMH54ssEUhEDJQqIDhDDCSZzpjpm9b++LyXf0rPmM8x2xGUi4lUOgNVJmaH0E7mgVy4MoC3bmzNCcpxPJZeOT6ngi6/I6cL6HLA0Jwj2MgMyIqAAyOhBNILsBJbzHzrxdP4yrMn630YdSWVrl0MhFeOnx6PglKjeNCpyjleh3MGA1JtVFkSHkg+ZhpvKQlL07Gh3YP/+tAOvOv8bHqbdajUcjAgST0DmyKblavdrGV1h8+B79x9ec58ZI61F5DHpqCnyYn+qeUl7wxMxZFMZ7CxwzAgXX5nQxYTPvxKH376xuDMD1zG1DIGso6dhyfHIkimM8hQw2DMxgOpNjZZqn8vrMVGkPWbSaUzRd2zZDoDuyrjpu2dOdbfbs5F100DEteW7nAlLZ0xh848cNdOszipHFYD4rYr6GlyLTsDwqvyN7A+QZ3+5ZssUAo9Q3FqPIpIcukmiVRK72i4pBpRSwPithse/cmxiCmNu2wyXJYJiC61tuFnmyIJCSufUFwzJ4MV++IkNL1oHygH25bUMmYMZCl7IEaKoiHVXX9ehzm3uRw5Hojd8EBGwoll1SPshCUDC8hq09Px5X8x5QxMxZFKZ8yC0eVKJkPxm//xIr754umi96f02gXRAaNL7smxKGKaxYBYzkshYdWZDDUunHywfLFAejKdKXox5R5IQst6ILElfIKl0pmitR7lcBfxQChdXpXaJ0Yi6PDZzQy8APu9lFO2Z8vJMcOIlkp1Xy5EWZPCvsniXnQqXXwxuVCsb3Pj1GgE8RRP21VMFUSRSM3iMRxVIWImuhWd5cR1swljxQzITB5IXNPNSuxYiX5aSwFtDkVSNkUy3xu3XTZHfS4nGat3NGy2uQYsHkgsVWqXZQc3ICm9UObtm4zhQ9/Yg77JpZ88wT2sUvGtWvbCAoD17R6Ek2mcYZ3CXWpWwqq19wGIGEgBesZ4M7rZRK5iBiSVzhQ3IMwDGQsnzZbKsSXSG+s/nj6BH+zry9k21wwTPj2NS1gAlk0mFqU0J4UXgDmlzSphLfeMLG5AgEKZ95Uzk3ihdxx3PbjX3JbQdHzuZ4fNlhtLBX7+WzsrWKllDASA2Zrk4GAQAHLSeN0z1IAsBKosYiA5mB7IXCQsdrEdCWW/bEulDuSbL57Bf+8fyNmWmmOfHx4HcdsVdPocUCSCvmViQAaDCcRSupmBBQCKLMHrUEzZ8tF9fdjw6ccwugwLKDknR6Pm7fxzhHe+ODUexYusi/Nzx8fwwAunc8awLlZ2HxnBG33TALLGcTRc/LPU9Iw5G7wW8EysgwMhAIDDJsPJAue1zsACDMVBxEAsZCUsZkCKaLwlJSxmVKwzMJZCED0Y0zARTRWssuba54fHQTxsmE1XwLFsJCzewsQqYQFAwKWaMRB+kfzha/1YrpwciyDAOizkG5CEpdD2iUPDAICXT04Ufexi5DO7Dpn1Lfx4xyMpZDKFWn9yDnHC+dDuNRZk3AN02WS46yxhCQNiQWfa0wq/YUCKZWGVDqIbL9u6WlkKMZDTE8ZqctRiQCilSOkZ2OfpgQDGezk4vfQNSFrP4MEXTkORCDZZPBDA6EjAJayVzcZ358evDSzLVvapdAYT0RQ2MSOabxSSTLbd1OHBwQFDannppGFUS6XDLhYyGYqRUMJ8Tfy3nsVaT1QAACAASURBVKGYKhLjmkuccD7IEkG7145zkzwGopieRz08ECFh5cHP91bWCHB2QXTugWQvxEvBAzk9bqxmpmOamW6bzlBQWnzmx0zwGAj/QnsdKiJLOBuNc9/uE3ju+Bg+d+v2giJKv1M1g+j8M+8djeB1JoUsJ7gsy+d/F3gg7IKyc00zDg+FMBxM4PhIpOhjFxuTsRTSGWoep9XgFQuk1zqIDgCdfoeplDht2Up0Zz1iIIqElMjCysLfCn4RzB8qldYzSGco7Eqhtc+XsFo9tiViQLLxiXHWZ4evKuayuvLYFSgSMY2syyabaYdLmVfOTOHClQH8zmWrCu7zu1TTA7EOFTs8GKrZ8dWKGCuO5d2W82Ve/vp3rGpCQsvgO78+Y9632A0IP3ejxQxInsSrZyj0TG3rQACj8wHHGkR3VVCnVW1sslS3iYSLEi452GQJbptc4HLzdu280NBKfhC90+9YEkH00+PZgCg/SbiuORcD0uqxo9VjN+cIuO0yokvgfZiJUEJDc4nOygFnNgYST+noDjghS2RZVqfzRRE3IPnnSEIz4gIX9BgzJ77+/Gl0B5xo89oRSaQxFIybQerFxig7d7mhC5cxIPM5R+YD74oNwBxpC9QriE5EGm8xZInAbVcK9V1mQMoF0ccjSThUCQGnbWnEQMYjZlNIfpJwD2Quq6s/fftGfPcPs1PMnKqyJAzpTIQT6ZwRxlYCzAMxmtwZw7c6vPZlOWiKF8e2e4unuifTOuyq0QLHoRp1AvdetwF+p4poKo37dp/Ah76xZ0GCr3MhGNcwweQpPnqgqIRVJMkEKD5YbSHhXbHtigRJIrDJEhSJ1CWILirR8+AxEEWS4HEoBRIWjxGUSuPlXyafQ4XTJi96CYtSitNjUVzGhkbxBIDkPCQsv0vNGaXpssmIpdJLPqAcTmimtJlPwGmDzrTzuKbDocro9DtyMvKWC3xR1FYiTpjQjCQTWSK4oDuA7oATt+3ogcdunE9j4STCyTQOsAB7vfnMroP4w2/vA5ArYVFKEU3q8DkUuG1yTpIJAFO6qbWE1ckMCPc4CCHYtsKHLUW6Yy80qpCwcuGXOEkCVje7cgqmgGyKor2IhCVJBH9502YARkaTewkYkP6pOKIpHZeubQYhhRJWNdo0OG0yMnRhRl/WCkopwok0vCUmufGhYcG4hjibFNfpdyzLWem8ONZjV+BUi8i8liSTf/ntC/HwPVfApkjw2BVEk2mzT9xLvYujJqRvMoZjw2FQSk35OUONcz2cSMNjV9DmteOxA0N47/0vmkaGt/ConwHJLmZ2feRq3HHlmpoeB8CaKYogeiGKJOG8Lh9OjkVy0tS4B1IsiA4Ad1+9Fh9/xyb85U2b4bQpi96APH7QyNO/fks7ml22rISlV2915WYrpcX+XpQjoRnJE6U9EMOATMc0xDUdTlVGp8+JoWBiyXte+XA50m2X4XEUyryJtG566D1NLqxsNtoCeZgkzJMNXmK1IfVmKqYhmtIxFdNyPMZwUkM0mYabGZDBYAKvnZvGvd99DZqlhUutYyB8Lk89JKt8bLKE1AI0Sl2yBoSf7BIBzuvyQdOpWTx2/7O92HdmCkDxIDpguJMffcdG/Mm1GxZt9tFkNGUawp8dGML2bh/WtLrR5rWbbrp5clTBgPCV0lKIB5UizHqblfRAnLkeiMMmo8vvQCyll5wrs1ThHodLVZhRyL2AJLVM0fPDbVcQTeqmB7Lv7FROxlq9mIwamYd9k7EcAxJN6oim0vA4FLx/x0r88dvW459uuwD7zk7hl4dHLIus2qbx8iB6PYLm+aiyaKZYgCwREEJwXpcPAHBkKIRUOoMvPn4M3997DkBpD8SKyyYjpumLbgX67vt+hf969hT6JmN4o28a77lgBQBD065GFlY+fKW0lAPpIRYL85XyQMyGioYH4mIxEGD5zQmJs4u+0yYbBiSR24U4kdaLnh9eh4JwQkMwnsKGdg9S6YxZaFgv0pbpoX1TMYyEkubI12gyjUjSkLA+cOlKfPJdW3D1xlYARt8zrU5BdJsiodVjg7MOabvFjkUE0S1QADJLP13T4oJdkXBkKGSuUgZYRXUpD8SK0yaDLjLtP5nWMRRM4PhIGL9iLTdu2mZMVbQakGQVA4S81cJSlrCyHkgpA8IkrHjKkLCYBwKg7plYY+FkVeMNMcswI7ddLpgJkijpgcgIJdLQdIq3sgvxoTrXyQQtDTBPj0UxEU2a/aYiyTQiiXROk0KnZWSDVkWZd7asa/Og3ZLOWy9UWUI6Q4u2eZkPS9aAgBoeCGA0ydvc6cWR4RAmosaFlbvflXgg/Iu3mNo38BNmYDqOc5Mx2GQJq5hG3eqxm91Sq6nv8mZv0SUtYRnHPpOENR3TEEsZBoRLDcN1DqR/5dmTuOPBvaYRnC/cgDhVGR67WiDRJTTd7MpgxWPPvndbOr1odttwaLC+Hoi1PcnLpyZAabbjbSSRRjRpSFgcHtuJa3rdYiAA8JUPXoK/v2V7zf9vPtx4VrsWZMkaEIqsAQGA8zp9ODoUNj0QTiXZSc5FGDzmxW6D03H0TcXQ3eSExF6v26Ygmc4grWdMXbMaWVhcqw0n0vjnJ44tybkZWQNS3ANxqDIcqoSpaAqpdAZONWtA6u2BHB8JQ89QvH6uOsV7sWQaTlWGJBF47MWLbYuluXsso1cDLhu2dvlweKi+HshkNGtUeVD/nds6ABgLHi5hcfj5kNAyVU00mS0tHruZ+VdP+PtRbRlr6RoQSnMMyOpWFyaiKQzkdZOtZLwrv3DGF0GgkDPFDMhoOIlTY1FzXgdgkZosq6tqnBz8fXjt7BT+45lePH10dN7PWWtmCqIDRi3IEAvCOlWZadXZxnf14viIMcN935nJqjxfTNPNz7RoFlaJXnHWlXzAqWLbCh+OD0fqWlDIF4brWg3Z6sKVAWxlsc9IMo1oSjfPC8BIknGoEpOwWNcKpbZB9MUEvz5UO5C+ZA0IkOuB8JS5/JVSJStz1yL0QKyr/2PDoRwDYmZLJXWkdOOYq+Geu9gKrp/Fj4JLcHb4TB4IYMRBeMCcf/aXr2vGc8fGzOZ3tSYY08zMuldYBuF8iTOJDkDRbg0JLWOOd7ZijSUEXDZsXeFDSs/gxEik4LG1gktYvO3Kb1zQZXaRHg+noGdojvQGGIuDhKbXrZBwMWFKWFWO8874jhJCHiSEjBJCDlq2/S0hZIAQsp/93Gy571OEkF5CyDFCyI2W7TsIIQfYffcR1oCJEGInhDzCtu8hhKyp5MDzJSyeSZMf7Ct2guTDtf/FlL5qnZqXoUaePicb7E5XVd/lTd74TJDpJTg7PJzQQAjgKdPx1OfMGhDuod68vQsT0RT2nq7O6n+2nBg1vI81LS7s75uuymo/lsoGlj02Bal0Bp/ZddDSxUAvGkS3eiBNLhXbVhgX7YN1jINwD+SaTW1w22S854IV5vd1hL0eq/QGGJ9tPKXXrRfWYsJWRwnrWwBuKrL9y5TSi9jPLwCAELIVwO0AtrF97ieE8E/1KwDuAbCR/fDnvBvAFKV0A4AvA/hCJQdOaTYLC8h2vjwyBw/EvCAvolbmwbyLt9UD4RkmsZRuVpdWI8edr1YHF4EHcmosMidvIMQqkiWp9PsRcKpmLyXuzV27uQ0OVcJjB4fmdsDz5ASrYbr9slWIa3pVugPHLB7IOhZw/vbLZ/HkoREARh1I0TRey0re51SxttWNVo8Nzx0fm/cxzZWpaApOVcZvXdyNfX99Azr9DhbbUTDCFgNue+6iwanKSKTrGwNZLPDrQ82D6JTS5wFUuiy7BcDDlNIkpfQ0gF4AlxFCugD4KKUvU6PY4tsAbrXs8xC7/UMA13PvZCaKSVj5MlRlEpbxxVtMLayn4ylYr4G5Hkg2a4x7IHZ5/rnmdkWCZGmTUq8g+nQshXd++Xn8aA6TAkMJDb4y8Q/AkLCycxqM74fbruDaTe14/OBw1VMdK+H4SBhOVcbN27sA5K7253o8sVQ2BvLuC7pw9HM3QZUJ+qfi0DPGILJSabyAcQHmvbJu3NaJp4+M1q1GaDKWQrPbBkJymxG67bLFA8k1IHbmgVSz2HapYquXhFWGjxBC3mQSVxPb1g2gz/KYfratm93O356zD6U0DSAIoGWmf06RG0R32mQzRXOFpQtmJbaoO+AEIbnt0uvNVExDk8uGFtZ9l0/PA3JjNtWUsAghOfp3vTyQ6ZiGdIbi6FB41vsafbDKD+yxDpmyJlncsLUDo+FkXWoeekcj2NDuwcpmJ7wOxfRAnj02ikv+/imzrmk2WA0IYLzW7oAT/VOxss1GuYQVsGQPvfuCLsQ1Hc8cq09ixVQ0hSZ34cLAbVcwHDQWPPkGxKlKSKb1uvXCWkxkg+iLw4B8BcB6ABcBGALwJba92NWaltlebp8CCCH3EEL2EUL2JRJJKHkyBS8I28y6XVaa2uq0yVjV7DJ16MVAMKbB71LRFXDArkhoY1W3QNYDiS2Avmtd3U3XyYBwL/LsxOwNerlOvBy/pdW7tdHdtZvbQAiw++jIrP/vfBkLJ7Ei4DA7K3Ap9sRIBNMxDd984fSsnzOeSue8PsDwZPum4kjyZqPFsrDY98v6Pl2+tgWtHhseYz3Zag1fUOXjsStmTRSPg3JEDCRLPWMgBVBKRyilOqU0A+DrAC5jd/UDWGl5aA+AQba9p8j2nH0IIQoAP0pIZpTSr1FKd1JKd9rt9gKdm3+BVja74FClilJ4ORvbveY4z8XAdDyFJpcN61o9WNfmyfGk+KoyyoLoEsmV8+aDdcWaH4epFXE2Se8MMyCxVBr/+NjRiiTGcp14OdaVtbXNRIvHjktWNWH3kdqvshNatrHh1i4fjg4bNSEhlpb88Ct95u1KyfdAAMOTHZiKIVHGA3GqMiSCnAu2LBFc0BPAqbH6nCNTTMLKhxu7Lr8Da1mKL8eIgVhT3UUab7W7bczJgLCYBue3APAMrZ8CuJ1lVq2FESzfSykdAhAmhFzB4ht3Athl2ecudvs2AE/TCppSUYoCD4THQZrdNrR67EVbuZdiU4cHZ8ajCzJ4fi5MxzQEnCr+9je34Rt37cy5L5vGm0ZKz1R1ZeVcBBIW90D6Jg2t/qXeCfzXcyex+8jMnkFFEpYzeyHKv8C+fUs7DgwEMVpmPkgkmcaDL5yuaspvMp0xvYGtK3yIpXScnYgixD6DSDKNpw7NzjOyBtE5PU0ujEdSmGKFecViIIQYQ9oCeQVwbR57wbCmWjEZTRX1QLg3fvWG1gK5mnsgIoierYGpeR0IIeT7AF4GsJkQ0k8IuRvAF1lK7psArgPwcQCglB4C8CiAwwAeB3AvpZRH3T4M4BswAusnATzGtj8AoIUQ0gvgzwB8suKDJ8U9kBZmQIq1aSjFpg4v0hm6aOIg00zCanbb0B1w5tyX9UCM1VU1g4PuPAmrHg0muQFJ6RkMTsfNWR0H+mdOI52thJW/Aud1BmcmShcVPnFwGJ/92WG8WMW+VYYByXoggFHTFIxrZtPAsUjlF29j4mJufyggm83XyzyJUufIhnYPNnXkDj5q89oxEU3VvFYmlkojnEibg7GscA+EN0+04lBlJLRM3ZopLiZsLMmm2kOlyp9pACilv1Nk8wNlHv95AJ8vsn0fgIKmMJTSBID3z3QcRfaDIhePgbR47Njc4TWzMyqBnyzHR8JmDKWeTMdSOStlK3ZFgiwRow6k6h6I8UWzycaI00jSkIT0TDZpIRjXcKA/WPSkrQbWTJ+zEzEMsjTNSibjGS0tKpew8j0QLpPkt8Sxwg3ay6cmcM2mthmPqRKsw502dnggSwRHh8IIJdLo8NkRSmg5/aA4fZMxJNMZbGj35D5fOoMMLZxFwbP5TrK04VJe+o8/fFXBtjavHXqGYiqWMo1aLeDdJayp7BxuQN6yoZgBkcxmiopEyqZ2L3dU0wNZBBLWYoCi0ANZ1WxooF1+Bz5363Z89Y4dFT/fujY3JAKcGKldID2WSmOqyIUqlc4gmtLRVKKHDiGEjZ+tvgfCL6irWowLzXRMw49e7cf6v/qFeeH84uNHcceDe8rKPPPBmop9ZiKKIZaBdHAgWDallfcGm2n+QjkPpDIDYrzul09O5HR7nQ/JdMa8mNsVGa0eG0bDCQTjGvxOFQGniulorqR4oD+Id9/3K3zgqy8X9LmKWzrxWuHZfDN5IISQAkmIewC1lrF4Z4R8TxwAPrBzJf72N7YWNWhOVTabKTayfAWIZopFyY+BXLGuGT/68FW4aGUANkWqqBMvx6HK2LrCh11vDNZseM5f/+QgPviNPQXbeewhX4O24rLJiCWNi1c1PRAueaxpcZvH8okfvAHA8AaiyTR27R8EpcCvF6hqm3cEIMTIxBqcZvOvUzpOlZEYeYBwpuw7/r7amCdnhevsxVb7nGGLR7Tlbx7HR773Wtn/NxNp3ZiiaL2Yt7jtmIikEGIGpMllw3Q8heMjYTzyyjnoGYr/9dArsKsyJqMpfPPF3Cwt3lE534C0eeywKxJ6R7gHUvk5Ui8Dwj2Q7iIeyPk9fvzeW9YW3c/BW5notKED6ED2Wllt+XHJGhBKUeCSEkKwY3VTRbUfxfjkTefh7EQMX33uVDUOsSyZDMXTx0bROxopWFUH48bFy18kaMhx2xQzC6uaq6ts5bJhQH74arZ8J5pM4+dvDiGSTEMiwK9PLcyoU27A17a60TsawWAwji1MVnyzv3Sn2koNiMeuQJZIUU/Focpw22RMRMp7IF6HYp6MT8wyuJ2PedwWOanFY8N4NGUWRgZcKqZiGr7z8ll88scHcHAgiLFwEn9542a847wOfPX5UzkLn6wHkqtSE0KwstmFU+PMgMxi8cFTyedrQAan45iYRTxnYDoORSJo985urobTJiNDDW8yv0q90eALpbQwIBxa4IHMl6s3tuLm8zvx1edPIp7SMRSML1gH0sNDIUzHNKT0TEFwlLeuLiVhAYDLbpGwquiB8Isq90C+xyY7AkaG088ODGFdqxtv29SGPfM0INFkGr1Fam9iKR2KRLBjVRPe6A9iJJTANZva0OK24VM/PoD/fKa36PPx4riZVtWEEAScaslJcc0eGyajhRe4gek4QgkNw6EEbtjagdVM5uOyEKUUx0fCs+5okDV8Vg/EOIZgXIPPaWRETcdSGAklQCnw6D6jXnfbCj9uuWgFwol0TgJIrISEBRgdbXk2zmxS3U0PZBYX/3x++sYgrvvnZ02vthSf/Z/DuP9Z43MemIqjK+CYdao6N45DwXjRDK5GQpGM9yItuvEa5DdTrBYfvHw1Yikd391zFtf+07MlL1bz5QVLBk//VG7Gz8C08feKIpovx2VTFiiIbqzUeE59Kp3BzecbkxBDCQ2joQQ2tHtwxboWnByLmo355sKDL5zGzf/2QsGKlqefXryqCZPRFDSdoqfJiR9++CpsaPfgR6/2F32+csVx+fhdakGAmdPstmOySA3M+7/yEj7z3wcxGU1hbYsbz/3Fdfi9q9ZgOqZhMprCO/7lObzzy8/jn584NuP/zzlubvgUqwdix0goiYSWyUpYMQ0j7L3atX8Qqkywod1jGjJrO3pzmFQxA9KWDbhXMrGT47YrcNnkOXsgp8ej+OjDr4MC2HNqsuTiTNMz+O6es/j33b0IxjQMTMeLxj9mgr/2oWCiaBV7I8ETjvSMiIEAYM0UF8CAXL62Ga0eG/7vY0eRTGfw49cGFiSV9cXecTNltj9vhkn/ZOmgIccaRK+mhOV3qiAEWN+WLcq65SKj60w4kTbqU1wqLl9ndJt55fTcW48PhRJI6Rn8OK/nVZwVwF28KmBu6/I7sbbVjQtXBkrWpxRbyZfCX84DcakFHshEJInBYAKPHzIqsbvYZxNwqQgn0jg8GMLJsShUmcx6el+CGT5HTlGjzaxJ8jlVBJgB4YkLkWQamzq8sCnZSZV9OQaEx0AKpZt1ls92NnFCwPBCzk7E8H9/cQQnZ1lU+MgrfZAIwafetQVxTS85Z/3wYAjJdAZxTcfDr5zDwFQc3QFX0ceWg8eURkKJnPY1jYgiJKxcrDPRq4kiS7hpeyf0DEWHzxgy9EYF9QezYfeREbzYO473XmIU5xcYkKk42rz2svKC26YYzRT1zKx07Jm4bUcPHvr9y9Duc8CmSHCoEt62qQ02RUIoriEY1xBw2XBelxeqTCpKrS0Fb9b4yL6+HCNtDEJSsKnDa0owPEXb71QRShSvTym2ki/FdZvb8daNxVNwm912s9AumdZxYiSMXpb2yi/2/HgCLKPrNIspXLQygOMjkVktOoodd6s7m1XEYyApPWN2EQaAbSuMehG/U4XXoRT1QNxFPBDr4mA2HghgxEF2Hx3BV58/hQ/818sVZy2m9Qx+9Fo/rtvcjndfYNQhf/vls/jN/3gBR4dze4+9etZYlGzu8OKbL57BSDhRNIA+E9wD0XSK5gY3ILIIouexQB4IANx+6SqsbnHh63fuhE2WsGv/QNWeeziYwEe+9zq2rfDjUzdvQYvbVmhApmNFc96tLFQar9+pmrUNbR473rK+FQ5Vhs+hYCySRFzT4XeqsCsyNnd6S64iK2EqaszuODUWxWuWMa7xlDGK1WifYRT2cTnP51Ch6bTo9MhiwehS/O/rN+KT79pS9L4Wjw0TzAP57P8cxrv+7VfYk5dxxotW+cr25JgRf7hiXQuCca2iOAE3Mqb0Zjlua9sOQ8JS2T7Zjgu84JAQglXNrhwDEi8nYbVaJazZeyCUGnGfhKbjwRfPVLTfC73jGAsn8duXrkS712g78pPXB/BmfxD/+tSJnMe+dm4KK/wO/MN7z8do2Ij59MxBwrIax3LxxEaAx0DEREJGfjfearK924/n/uI6XNATwI7VTVWbUQ0AR4dDiGs6/uY9W+GyKehpcpoxkNfPTeHocAj9U3GsbCrvsrvthgei6QuX4/4fv3sxPnurUfvpc6imtMbrKM7v9uPAQHDOEt9ULIXL1zbDJkt43DKHw9qC45pNbej0OcwLAP/foXhhoDobA5lfa/smlw0JLYMD/UE8/Eof0hmK7+05B5dNNj0ifhHn865PjkUgEeDSNc0AYKbJluKLjx/FLf/5IqZjqeJBdE/WgBhB9Ozft1y8ArJEcNnabNPq1S0unJuoTMJqctvQ5FIhS2TW3x0eSP/g5avR3eQsmmxQjFPMwF66pqng9+OHhnM8mdfOTuGS1U3YsboJH71+EwBgTV6fq0qwGsdGl7CyHoiIgZgslAGx0uRWqzonhAcg+QWop8ll5rl/8kcH8IlH38DgdHxGD8RpyxZJLVSX0YtXNZlxGK9DQR8zdLyOYtsKP4JxrcCDmglucKZjGlY2uXDVhhY8fmjY3G5tAvhH16zHM39+rZma7XMaF8RijQVnI2GVg7fQ/+tdB+FSZXjtCoZDCWxs9+CSVU3wOhQzLZRLWCdHI2h228x04+MzSDtPHh7Bm/1B3P3QPvNinyNhefIkLEvx4w3ndWD/Z27AViZhAUYDUT7nAzBqZoDiWViAEUify/u0qtkFmyzhty7uRsBlw1SFDTdHw0nYZMlcAHz42g34wvvOx1fv2AmHKuH///VZAMA4izVdtNKIf/3p2zfgB398pWlwZoPVgDR8EF3EQHJZqCB6Ph67gnBCw1g4iYs/+yT2983PGxln9QWtXuMi1dPkRP90HJkMxbnJGA4NhljW0QweiE2GplNEknpN2lT7LFP8eIuV87sNeYnHQSiluP/Z3pyVsJWxcBJ3PrgXm//6cTx+cBhTsRSa3DbctK0TfZNxHGHzPxKabga4ZSl3gBAfFlUskD4bCascTcyAvNE3jfft6MGV642V/oZ2L/707RvwVzefZz6Wr2wHgwm0uO1o89rhcyjmhMFihBIaTo5F0NPkxKtnp8xZ4/lBdI7fqZrHBADtXkdBx+FVzS6k9AxG2GcUT+mQSGljurnTm2OUKuVDV6zGkx+/Bh0+BwJOtaBj81Q0VfSzGQsn0ea1mwuBta1u/Palq9DstuHKdS341QkjK5F3AOASoSQRXLqmeU61XdYkiUZP45UkAomIGIjJQqXx5uN1qIgk0jg7EcVUTCtbyFYJY+Ek3DbZlBZ6mpxIpTM4PhrO0fVnjoEY+wfjqZq0afA6FHClinsgmzu9UCRinvwnxyL44uPH8NM3iseMfvhqP54/PoZ0JoO9pyeRTGcQcKl4x9YOSARmhlOxNuScrIRVzgOZn4RljT+8c1uH2fNrY4cHl69rwe9ctsq833oRbvEYE/M2dXhNo1CMN/uCoBS4fks7AGCcyUDWi73LppgavpGFlf0/7b7Cth08E4vHQYz3UCl54f3zd27Gt/7XZUXvK4dDlU05qcllK6jY/4Nv78OfF6nxGIsk0VqkGSIAXL2xDafGo0adDftcZ5oqWemxchrdgABGHER4IBYWIgsrH69DQTSlm646b2NRCfGUjl37c9OAxyLJnK6iq1nB3gsncju7rmyeKQaSzTCpZhZWKawnNL+IO1QZ79/Zg+/vPYcHXjhtZs+UkjXe7J/GqmYXuvxOHB4yvJaA0+icvHN1M560GBBnEe0eMC6mQAkPZBZ1IOXgElbApeKyNc24bnM7vA4Fl61tLnk8QNbwbOny4vBQCHqGYtf+gYK+Wvv7jPfpyvWGYeJV7/mGr8Vth02WYFck0+vzOZSigW9et8OTGuJaumSdCz/W/G67syXgVjEdy2bEhRIaXj83VTSxYiyczBmKZuWtzEC/cGLM/Fz9c/CO8hEeSC6yRJAWvbAMinXjXQh4t89B1tBtNgbk/md78dGH9+cMqhoLJ3IMCO+i+uyxMQDAlk4vJAKsCJRv22C9wNZCwrK2SLeuhj93y3Zcv6UdX3z8KJ4/bhjBUn2k3uwP4oIeP7oDTnNkKw+O37i9E0eHwzgzHmWT9Mp7ICOhJH77qy/nXKwqbWUyz//DXgAAG0lJREFUE1wuun5LBxRZwspmFw787Y24ZFWhDi9LBD723vC4xc7VzYgk0/jpGwP46MP7cd/u3Cyj/X3TWNfmNj9jbmDypbdWjw0+p+FF2BQJbpuMDl/x70VPkwvnd/vx3yxjsJwXVy0CThtSesb0nF89O4UMNQr38uOGY+FEUc8JADa2e9Dhs+NXJ8bN2JavCgYkJwurwWMggFFMKDwQC/ndeBcCvvI2DUiFHWgTmo7v7jHagPAutkBWC+Z0+R1w22TsZWmiX/rAhbj/g5fMKMO4LKsrHotYSPj7IEskZ/a0Ikv4k+s2IJnO4OcHjEyq6SIeyHgkiYHpOC7sCaAr4EAoYVxgeAzhnVs7ABgyllEHUvz1c0P26tlJ7Dk9acpnQOWtTGbC71TxVzdvwb3Xra/s8cwIcs9lJwv4fpmlp/7szaEc7fmN/iAu6gmY7+MEMyD5nXFbPfaclXjAZSt5EQaA917SjYMDIRwbDiOa1ItmYFUTbvy5x7nXkup80hIDSusZTERTJT0QQgh2rm7GwYGgGVOphgfCPTUl7zvbqCgSETEQDkVhN96FwMMuWP1lDEgkmS5Ycf3w1X5zZTlqaf2Q78oTYrSjSOkZuG0ytnb5cNP2LswEb7f+iRs24TcuXDHLVzV7+IU74FQLdPVLVgVMDR4o7oHw2NEFPf6cFi18Zbiy2YVtK3z42ZtGp99S8osqGyvxgwOGB8MNO1A9CQsA7rlmfU7Lj3JweamFfa7dASe6/A6cm4xBlQnGI0m8fNLoGzYZTWEsnMTWFb6sAWE1I/keyMdv2ITP3pIdofPeS7rx7vNLf9a/eeEKKBLBj1/vR1wr7cVVC278eUHo3tOTaGXB/16LAZmMpkApig6E4vBhVXxhMdNQsEqwKxIIMY5zrg1WlxOyiIFkKdaNdyHgX2SeajscTBTUPXz0+6/jDx56xfz716cm8LmfHcaFrAiOt59IpnWEikxWW89krO4mZ8Vf9E0dXpz4/Lvwp9dvnMOrmj1cUvAXKcgihOCWi4wLW6vHXtQDeaMvCIkYNTYr/FkZxqpNX7a22ZS2SrUZ4cfCDXmOAWHz4WuxsLDCJT2eOUUIwU5WD3LnlWvgsStmYgG/sG5o95ipwHyhkV8Qur3bnzMo6RPv3IzfvXwVStHisWNDuwcnRyO1kbDY656OaUimdbzZP41bLuqGIhG83jeFv/ufQ5iKpswFVDkD0uK2IZxIm0km1UgMIYTAocgNX0TIUSQCvcqFhEvar6vFhYKnSw6wC1UspSOcTOcElQem4zg6HMbhwRD+6YmjeObYGNa3ufHg712Kt3/pOfME4im8+ScSj4PMtmFcLYfk8PehVOrn779lLWyyhKFQAr84MIQ9pybw6L5+fPG2CyBLBK+dm8LGdi/cdgVd/uzrtEoVG9o94Aukchc/v1M1hzoN5BgQHXZFrvlqk7+GVk+uMfyfNwbxru2dGA4l8PzxcVBKcYJ1H97I2rQQYnynbLJUlQVRwKUiGNcQT+loL3PBrgbW2SnBuAZNp1jb6sbqFhe+t+ccMhQ4r8tnetzljod7b2cmolWJf3CcNjknBbqRkSUCTRQSGlBKIUsLf/hcZrB2IB3JC6Tz1MPf++ZePHd8DB97x0b84I+vQovHjnavHaOhZM5zFBiQtqwHsljhgeJSFb3Nbhv+9PqNaPXYEYxr+PmBIfzotX48cWgYmp7BvjNTuGKdsSrnEpZTlXMyija2Z7OCSmVhGceSa7w51ql+tcT0QCz9q96/owdfu2MHdqxuwlXrWzAcSuD0eBQnRiJw22Ss8DtACIGHvc5qZdIFnEbTxWgqXbMYyHRMQyyZLVy0LgQOD4ZKfu+tcO/t1Fi0KvEPjkORhAfCUOXqx0CWtAdSiwW4z6LFKpKRxTAUTGCjJQUyzHTb0XASH7x8FT72jk3mfR0+B0bCCfzbL0/gpZNGwLfNk5tJw59rpuLBejKTB8JpcqmgFDjEpKivPX8KHT474pqOK1gHX559lH9ib7TM9XbNIGFxwom0OXQpqVW3sWSl8BhIs8UDcagy3rnNaIN/FUvXffHkBHpHI9jQ7jG9JLddQTiZnnfg3zwWl4rpuJFaWy6Ntxr4TQOSsswfUbCl04dfHhlFp8+Bw0Mh03CUm6POExAGg3FcGihMl54rd1y5xkxxbnRkqfpZWEvWgBiFhDXwQCwGZG2rGydGIzmBdD1DEU6msabFBU2n+LMbNuXs3+61Y8/pKB56+YypdfMqdM6aFhc+d+t23MQuOIsR3kKkWAzECq+FODwYgioT7O+bxr88dRwAzDoKv1OFyyYXeDNNbhtaPTaMR1JlJSx+LF1+B4aCCQxNJ+DrVE0Jq9bcctEKOG1Gy5NirGlxYYXfgZdPjuPEaBhXb8h2Aeb1PNUyfH4mYSkSKWuEq4FdMXqDTcc0S+8tGfdcsw43n9+F7/z6DHa9PogtnV74nWrZxo1cwqK0Oim8nA9fW1kmXSOgSFLVYyBLVsICalNIyLvCAkYlMpBbC8Kzrz50xWq8+Mm3mycCp93nwMB0HJNR46Jok6UcqQMwgn13XLG6rItfb8wg+gwnNzcKcU3H+y7pwZZOL17sncDmDq/53hBCsCLgzKn45qxncl651TOXsC5nBokH0pPp+nggGzu8uPe6DSVjL4QQXLm+Fc8dG8NIKGl+j4CsRFot6c3vVJFKZ4wgeg1SVwNOY9Su2T7eLsNtV7C504utXX6Ek2k8cWjYHHpVCut3gS8QBNXF8EBEDMSkFoWEhBAzE6vNY0eL24azll5PZuuFEhdWa+Dw63fuxKN/fGVNCv+qjc+h4tM3n4db2XCpUlhlqQ3tHnztjp1odttw7ebc2Rt/856t+Ng7CjPI+MW1nH7PjRgfatVvNSB1iIFUwh+9bZ3Z32mbpQkiz8SqlufE5TSgfCJCtTAGXaVMD8SpZj83/jpHQkncffXass/jcyhQ2flczRiIIMtCFBIuaVNfi0JCwFglTsc0+J0qrt7YiqcODyOhbYdDlc34h69E3jqvHFZlgp1rmuoisVSLP7xm3YyPsabl9jQ5sarFhef+4tqCtNy3bSo+zGkziweVqwPgxvriVQGoMrF4IPWRsCphU4cXT3zsGhwZCmN7d9aAcA9ktoOdSmHtElALA9LkNmIuVg+Es5l1VVjT6sZ7Lihfq0QIQYvbjuFQoip9sASFLEQh4ZI2ILXK9zcCyHH4nCpu29GDXfsH8cShYVy+tiXbeqHEl55XDp/X5Vu0F7dqYr2A8aSA/M6x5bhtx0p0+Bxl58G/fUs7To9HsKHNgy6/06zRqVcQvVIUWcL5PbldA0wJq2pZWNn3ulwtTbUIOG04EgyZ7eOt0qNDlfF/fmMbtnf7K2p82uy2YTiUEB7IAqFIEtKiDiRLLQoJAZjBUZ9TxVXrW9Hld+Djj+wHAHz63VuNx5S4SHZ4DQ+kFu1GFgMeuyFFGC3p5zaG9J0zJBOsbXXj7289H4DR9nvYLNTMVKWCuZZUW8KySqnuGsRA/C4VobiGOJOw3HnS411Xran4uXgqbzWD6IIssmhlkkvtPBBmQBzGFLf/ff1GbOrwIkOzLTpKBf66Ag5cua7FnAO93CGEIOCywWNXarKS7PQ5zKSGxSxhlcJdbQ/E4gEudBovYJwToXgaUVYHMh+vh6fyCg9kYVBkUUiYQ608EJ7Ky43E71y2Cl+/cycAmJ12S0lYqizh+/dcYdYCNAJNLhU9s2jLMh+6mAdCKV3UQfRSeHgab9XqQCxB9BpIWD6ngpSewVQsBacqz+uc5Fl6peKJgvkhYiB51NoDsa6MeHCcdx31iC+9ydu3dNQs06zD50AqncFUTFv0MZBimEH0Kh232yabBa8LXYkOZBdOQ8HEvIP2XMKaqdZIMDfkBYiBzPitJYQ8SAgZJYQctGxrJoQ8RQg5wX43We77FCGklxByjBByo2X7DkLIAXbffYQtTwkhdkLII2z7HkLImkoPvhZ1IEA2vmH1MmyKhFaPMQ/BVaXmb8uFT75rS0FB5ULRxVJjh4OJpS1hVclzIoSYCx2XvRYeCJ/Pkpi3ZLau1ZjTzuOGgupSr3bu3wJwU962TwLYTSndCGA3+xuEkK0Abgewje1zPyGEf6u+AuAeABvZD3/OuwFMUUo3APgygC9UevC1GGkL8BbmufoykPVCllrgdjnBayuGQ/G6FRLOB0+Vg+hAdgVfizReLjcNBRMFAfTZcuO2Dvz6U9eL5ocLhCzXoZCQUvo8gMm8zbcAeIjdfgjArZbtD1NKk5TS0wB6AVxGCOkC4KOUvkyNXujfztuHP9cPAVxPKhTPa2VAPrBzJb5+x86CTKtOZkBE3nr94AZkKJhYkjGQagfRgWwqr0utgYTF/td4JDlvD4QQIozHAqIsQC+suX5rOyilQwDAfrez7d0A+iyP62fbutnt/O05+1BK0wCCAFqK/VNCyD2EkH2EkH1A7QxIk9uGd7CJeVY6/MIDqTdtHjskYsxr0TN0yUpY5fpEzRYuYdUqCwsweli5ayCZCebOQtSBVHu5VuyKTstsL7dP4UZKv0Yp3Ukp3QnUzoCUwvRARNph3VBkCW1eu9leZqlJWHzxUVUPxGWDKpOaJDJY09edNfB4BHNnMY20HWGyFNjvUba9H8BKy+N6AAyy7T1FtufsQwhRAPhRKJkVpe4GxC8krMVAp9+Js5NRAEvPgCyEhLWy2WV+Nxca63dfeCCLG3kBemHN9Vv7UwB3sdt3Adhl2X47y6xaCyNYvpfJXGFCyBUsvnFn3j78uW4D8DTNnxlbglplYZWiUwTRFwWdPjvOjjMPpAa1D9Wk0+fA716+CldvLN4bbC78ybXrseveq6v2fOVwqLLp6dQiaC+YO4YHUt0g+oxXPkLI9wFcC6CVENIP4P8A+EcAjxJC7gZwDsD7AYBSeogQ8iiAwwDSAO6llOrsqT4MI6PLCeAx9gMADwD4DiGkF4bncXulBy/XoBtvOUwPREhYdaXL70SYtdVfah6ILBH8w2+dX9XndORNevx/7d1/sB1lfcfx9yf3BhIwiYSYNBJ+GBsgAYcAKYIt1jbFH0w7wIgVakucOoPaOlPo+AfUttoqY2E6jnUY22bqmOhUCwwyAh0cYoRRkYo3EMGAQNCMBjJEqG0DFqbEb/94nsM9OZxz77l7du/uJp/XzM7Z+5zd5z77vXvP9zz749mqLZw3l2eee3FW7jux4moZCysiLh3w1voBy18DXNOnfAI4tU/5C+QENFN190CWL5rH2By9PASD1ePslUez6Tu7gHIvh7XhLJw/nhOIY99kHs69x2zdiT7IgnlzufH953DSryyYfmGrzJtPnBwmpm09kINB5zyIeyDN5sEUe8zWWFhTOfP4o16+GczqccRhkwM3tvFhXW3XOYTrHkizjfuJhAequwdizXHR6em2orL/QWx6nbvRnUCabWyOKLkD0u5DWE3ogVgz/MX5q1m9fAG/eeLS6Re2Uk32QFr9cXLQq2K8vlb/xd0DsY7Dxufw7l87ru5mHJJePgfi+0AarYr75lp9CGu2noluZoN17kafjeePWHFVfOFudQIZr/k+EDPzVVht4R5Ij7rvAzEzWLnkSA4bm8OyRYfX3RSbQhU9kFZ/Zah7LCwzgzf96hLu/+vzfDl7w41XcBK93T0QJxCzRnDyaD4fwurhBGJmNhyfRO/hBGJmNhz3QHo4gZiZDaeKGwnbnUB8FZaZ2VDcA+kxPqfVzTczmzU+B9LD+cPMbDjugfRwD8TMbDhVfF62+hPY+cPMbDhVDP3U6o9g90DMzIbjcyA9fBWvmdlwfA6kh3wZr5nZUHwOpItTh5nZ8HwOpIt7H2Zmw/M5EDMzK8TnQLq4/2FmNjyfA+niI1hmZsMb8zkQMzMrYq4PYU3ySXQzs+E17hyIpF2SHpK0XdJELlssaYukx/PrUV3LXy1pp6RHJb2tq/zMXM9OSZ+Rs4OZWamaeg7ktyJibUSsyz9fBWyNiFXA1vwzktYAlwCnAG8HPitpLK/zj8DlwKo8vX26X+oMY2Y2vLacA7kA2JznNwMXdpX/W0S8GBE/BnYCZ0laDiyMiHsjIoAvdK0zkPsoZmbDa+J9IAHcKWmbpMtz2bKI2AOQX5fm8mOAn3atuzuXHZPne8tfQdLlkiYkTezfv3/EppuZHTqqSCDjI67/6xHxlKSlwBZJP5xi2X6tjynKX1kYsRHYCLB05Zq+y5iZ2Ss17iR6RDyVX/cCtwBnAU/nw1Lk17158d3AsV2rrwCeyuUr+pRP6bjFR4zSdDOzQ4qk0pNI4QQi6UhJCzrzwFuBHwC3AhvyYhuAr+b5W4FLJB0u6XWkk+X35cNc+ySdna++uqxrHTMzK0nZCWSUQ1jLgFvyFbfjwJci4muSvgfcKOl9wE+AdwFExA5JNwIPAy8BfxoRnRMZHwQ2AfOBO/JkZmYlKvtmwsIJJCJ+BJzWp/xZYP2Ada4BrulTPgGcWrQtZmY2vcYcwjIzs3YZHyv3I98JxMzsEOEeiJmZFVL2vSBOIGZmh4j1q5dOv9AMOIGYmR0iPnHhG0qtzwnEzMwKcQIxM7NCnEDMzKwQJxAzMyvECcTMzApxAjEzs0KcQMzMrBAnEDMzK0TpMeTtI2kf8OiI1SwC/rvG9cuqYwnwTM1taEIdo8ahjDY0qQ7vF5MOln2jjDacFBELRqwjiYhWTsBECXVsrHP9EusYKRYN2o5R/x617xMNq8P7xUG2bzQlFp3pUD+EdVvN65dVx6iash2ORbl1jKop29GEWEAztqUpsQDafQhrIiLW1d2OJnAsEsfhQI7HJMdiUpmxaHMPZGPdDWgQxyJxHA7keExyLCaVFovW9kDMzKxebe6BmJlZjZxAzMyskMYkEEnHSrpL0iOSdkj6s1y+WNIWSY/n16Ny+dF5+eckXd9T192SHpW0PU/lPoarYiXH4jBJGyU9JumHkt5ZxzYVUVYcJC3o2he2S3pG0qfr2q6iSt4vLpX0kKQHJX1N0pI6tqmokmPx7hyHHZKuq2N7RlEgFudJ2pb//tsk/XZXXWfm8p2SPiNp6mfglnU9cAnXJi8HzsjzC4DHgDXAdcBVufwq4No8fyTwG8AHgOt76robWFf3NjUkFn8DfCLPzwGW1L19dcShp95twJvr3r664gGMA3s7+0Je/2N1b19NsTga+AnwmvzzZmB93dtXcSxOB16b508Fnuyq6z7gHEDAHcA7pvrdjemBRMSeiLg/z+8DHgGOAS4g/VHJrxfmZZ6PiG8DL9TQ3EqVHIs/Bj6Zl/tlRIx6N+6sqWKfkLQKWAp8q8KmV6LEeChPR+ZvmAuBp6rfgvKUGIuVwGMR8bP889eB1vTSoVAsHoiIzt97BzBP0uGSlgMLI+LeSNnkC511BmlMAukm6QRSlvwusCwi9kAKFOmffxifz4cr/mrabliDjRILSa/Osx+XdL+kmyQtq7C5lSlpnwC4FLgh/4O01ijxiIj/Az4IPERKHGuAz1XY3EqNuG/sBE6WdIKkcdIH5rHVtbZaBWLxTuCBiHiRlHR2d723O5cN1LgEIulVwM3AFRHxPwWreU9EvAE4N09/VFb7ZlMJsRgHVgD3RMQZwL3A35fYxFlR0j7RcQnw5dFbVZ9R4yFpLimBnA68FngQuLrURs6SUWMRET8nxeIGUq90F/BSmW2cLTONhaRTgGuB93eK+iw25RetRiWQvGPfDPxrRHwlFz+du1bk173T1RMRT+bXfcCXgLOqaXF1SorFs8AvgFvyzzcBZ1TQ3MqUtU/kZU8DxiNiWyWNnQUlxWMtQEQ8kXtiNwJvqqjJlSnx8+K2iHhjRJxDGqD18araXJWZxkLSCtLnwmUR8UQu3k36wtmxgmkObTYmgeTDTJ8DHomIT3W9dSuwIc9vAL46TT3jnStKclB/F/hB+S2uTlmxyB8OtwFvyUXrgYdLbWyFyopDl0tpce+jxHg8CayR9Jr883mk4+atUea+oXyVZr5K6U+Afym3tdWaaSzyoe1/B66OiHs6C+fDXPsknZ3rvIzp4jfbVwwMmkhXSASpO709T+eTrpLYSvpWsBVY3LXOLuA/gedI2XMN6WqLbbmeHcA/AGN1b18dscjlxwPfzHVtBY6re/vqiEN+70fAyXVvVxPiQboa6ZFc123A0XVvX42x+DLpi9XDwCV1b1vVsQD+Eni+a9ntwNL83jrSF+4ngOvJo5UMmjyUiZmZFdKYQ1hmZtYuTiBmZlaIE4iZmRXiBGJmZoU4gZiZWSFOINYqkvbnIWp2SPq+pD+XNOV+nIep+IMRf+/HJH14lDpyPe/tHQ22QB1XSDpi1LaYjcoJxNrmfyNibUScQroB7nzgo9OscwIwUgJpCkljwBXAjBJIHufJrFROINZaEbEXuBz4kJITJH0rDxx5v6TO8Bx/B5ybey5XTrHcASR9ROm5Ml8HTuoqf73SMzS25XpO7rPuWZK+I+mB/HpS19vH5vUflfTRrnX+UNJ9uZ3/nJMFSs+w+FtJ3wU+Qhq/6i5Jd3Xe76rjYkmb8vwmSZ/Ky107TZvMZq7uuyg9eZrJBDzXp+znwDLSt/J5uWwVMJHn3wLc3rV83+V66jyTNFrtEaThzncCH87vbQVW5fk3At/os/5C0rhbAL8D3Jzn3wvsId0lPJ901+86YDXpjvC5ebnPksYpgnSX8e931b2Lrue6dMcEuBjYlOc3AbeTR2IY1CZPnopO7tbawaAziuhc4HpJa4H9wIkDlh9muXOBWyLiFwCSbs2vryINPHiTJp8ScHif9RcBm5WePxL5d3ZsiYhnc31fIQ1F8RIpaX0v1zufycHv9pMGyivipojYP0SbzGbMCcRaTdJK0gfsXtK5kKeB00iHZwc9WOrKIZfrN87PHOC/ImLtNE37OHBXRFyk9IyGu6eoN0hJcHNE9BtW/YWuJDBdO+f1vPf8kG0ymzGfA7HWyqPJ/hPpEaVB+oa9JyJ+SXoGzFhedB/pUZ8dg5br9k3gIknzJS0Afg8g0nMWfizpXbkNysPE91pEGvUW0mGrbucpPa96PukBRveQDotd3DUy7GJJxw/Y9N7teVrS6nw12kUD1pmuTWYz5gRibTO/cxkv6fGjd5Ke+w7pvMEGSf9BOizV+fb9IPBSvuz3yimWe1mkR4TeQBqp9GYOfATue4D3Sfo+acTnC/q08zrgk5Lu4ZUJ6tvAFzt1R8RERDxMGiX1TkkPAltIz7ruZyNwR+ckOul517cD3yCdXxlkqjaZzZhH4zUzs0LcAzEzs0KcQMzMrBAnEDMzK8QJxMzMCnECMTOzQpxAzMysECcQMzMr5P8BIPePZpsFePYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#frame['Data de abertura'].dt.cumsum()\n",
    "frame.set_index('Data de abertura').groupby(pd.Grouper(freq='W')).counter.count().plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1c0cb600388>"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAEHCAYAAABSjBpvAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAAgAElEQVR4nO3deXxV5b3v8c8vcwJJmAIEAiYIirNCRBTjLGKtdcKW1gEV9La1nlrvq73anns8bc9pj6+eY1tPq+cqzlqHQq12UIsjqAgmOKACgiAQCBAMMwQy/O4f+wlsEMJGElb2zvf9euW1136ynpXfctjf/TxrMndHREQkEWlRFyAiIslDoSEiIglTaIiISMIUGiIikjCFhoiIJCwj6gLaWq9evby0tDTqMkREkkpVVdUady/a13opFxqlpaVUVlZGXYaISFIxsyWJrKfpKRERSZhCQ0REEqbQEBGRhCk0REQkYQoNERFJmEJDREQSptAQEZGEpdx1GsmqudnZ2tDElu1N1IfXLdsb2bo9try1oYmt25sA6FOYQ3H4yc/JjLhyEelMFBoJcne2NTbv8mHe8iG/6wd7Y1hn5wd9bLlxx7q79mtka0MT9Q3NX6qu/OwMirvl0Lcwl36FORQX5lLcrSVUcunXLYe8LP1rFpG2kXKfJk3NTs36rXv4gN75Yb7zm3ysffcP/y0NTdRvb2JLw67f9Pf3eVXZGWnkZaWTl5VBblY6eVnp5GSm06NLFiXd08nNzCAvK53crHRyM9PDuunkZmXseN/Sr6WvO6zcUE/N+npq1m2lZn09K9ZtZeWGej5esYE1m7Z9oY7C3MwdI5PibrFw2REy3XIpLswhJzO9jf4NiEgqs1R7cl928RAvHv+bhNbNTLfw4Zyx40N51w/qjB1tO9ozw4d8VgZ5cevHfrczHHIz00lLs3be2y/a1tjEqvXbqFkfAmX9VmrWhZAJbXWbt3+hX/e8zB0jk+LCXPoW5uxY7leYS5/CbLIzFCwiqcrMqty9fF/rpdxIo7gwh19ccswev6W3hEPLN/vM9NQ7DyA7I52BPfMY2DNvr+vUNzSxcpdA2RpCpZ7qtVt557O1rN/a8IV+vbpmxaa/CnPo1y0WLDuWC3LoW5iTkv9MRWSnlBtplJeXu25YeOC2bG8MU2CxcFkZRior4kJmY33jLn3MoKhrdmzKqyCH4m459NvtGEvv/GwyFCwiHU6nHWlI28jLyuDQoq4cWtR1r+tsrG8II5Z6Vu4WKAtrNzF9QS2bwxlfLdIM+oRRSb8wamk5rlJcmMMhPbvQo0tWe++eiHxJCg350vJzMsnPyWRIn/w9/t7d2VDfuHP6a93O0crKDVuZW7OBl+et+sKZY30Kshnat4Ajigs4ojifI4oLGNSri0YoIh2AQkPajZlRmJtJYW4mQ/sW7HEdd2fdloYdB+oX1W5m7soNzK3ZyFufLqKhKTZ9mpWRxpDeXTmiuIChffM5sriAocUFGpWIHGQ6piEd1vbGZhat2cTcmg3Mq9nIxzWxMIk/rbhPQXYIEo1KRA6EjmlI0svKSGNo31ggcMLO9tqN25i3MhYkc2s2MHflRt5cuOuo5LA+XXdOcfWNhUl3jUpEDphCQ5JOUX42RflFVAzZ+Tjj+FHJ3BAmr82vZXJV9Y51WkYl8VNcZRqViOwXhYakhPhRySV7GJXET3G9uXDN3kclxfkc0VejEpG9UWhIStvbqOTT2k0hTPY8KulbkMPQcIxEoxKRnRQa0ulkZaTtmKb6MqOSI/rGztzSqEQ6I4WGSNDaqGRuzQbmrYyNSl6dv5o/7jYqOaI4PwRJ7MC7RiWSqhQaIq2IH5XEq924LQTJzimu6QvW0Nj8xVHJEcUFDC2OTXF1y9OoRJKbQkPkS2gZlZx22K6jkoWrN+2c4lq58QujkjMPL+LnFx9NSfe931BSpCNTaIi0kayMNI7sV8CR/fY8KqlaspZJ0xcx+tfT+OF5h3P1yaWkR3D7fJEDsc9JVzM73Mzei/vZYGY3m1kPM5tqZgvCa/e4PreZ2UIzm29m58W1DzezOeF3d5mZhfZsM3sqtM80s9K4PuPD31hgZuPbdvdF2l9RfjanHVbED849jH/ccjojynrw0798zGX3vMUnqzZGXZ7IftlnaLj7fHc/3t2PB4YDW4BngFuBl919CPByeI+ZHQmMA44CxgB3m1nL03vuAW4AhoSfMaF9ArDW3QcDvwbuCNvqAdwOnASMAG6PDyeRZNO/Wy4PXnMivx13PEvrtnDBXdO5c+onbGts2ndnkQ5gf0/vOBv41N2XABcBD4f2h4GLw/JFwJPuvs3dFwMLgRFmVgwUuPsMj93w6pHd+rRsazJwdhiFnAdMdfc6d18LTGVn0IgkJTPjouP789Itp3Phsf246+UFXHDXG1QtqYu6NJF92t/QGAc8EZb7uHsNQHjtHdr7A8vi+lSHtv5heff2Xfq4eyOwHujZyrZ2YWY3mFmlmVXW1tbu5y6JRKNHlyzu/MbxPHTtiWzd3sTY/5nBvzz7IRvrv/jURJGOIuHQMLMs4GvAH/e16h7avJX2L9tnZ4P7ve5e7u7lRUVFe+gi0nGdcXhv/vGD07j2lDIefXsJo389jVfmrYq6LJE92p+RxvnAbHdv+a95VZhyIryuDu3VwIC4fiXAitBesof2XfqYWQZQCNS1si2RlNIlO4N/ufBI/vSdUyjIyeS6hyq56Yl3d7kNvEhHsD+h8U12Tk0BPAe0nM00Hng2rn1cOCOqjNgB71lhCmujmY0Mxyuu3q1Py7bGAq+E4x4vAqPNrHs4AD46tImkpBMGducvN53KLecexosfruScO19nSlU1qfbcG0leCT2EyczyiB1bGOTu60NbT+BpYCCwFLjc3evC734CXAc0Aje7+/OhvRx4CMgFngducnc3sxzgUWJPTagDxrn7otDnOuDHoZR/d/cHW6tVD2GSVLFw9UZunTKHyiVrqRjSi19ccgwDeuiiQGkfiT6ESU/uE+nAmpudx2ct5Y7n59HU7Pzv0Ydx7agyXRQobS7R0NAd1UQ6sLQ046qRh/CPH5zGKYf25N/+NpdL736TuTUboi5NOimFhkgS6Nctl0njy/nvb55A9dqtXPjfb/CfL86nvkEXBcrBpdAQSRJmxoXH9eOlW07n4hP687tXF/KV305n5qLPoy5NOhGFhkiS6d4li/+8/DgenTCChuZmvnHv2/zkmTls0EWBchAoNESSVMWQIl68+TSuryjjiVlLGX3nNKZ+rIsCpX0pNESSWF5WBj+54Eie+e4ouuVlcv0jldz4+GxWb6yPujRJUQoNkRRw3IBu/OWmU/nheYczde4qzvmv13n6nWW6KFDanEJDJEVkpqdx45mDef77FQwtLuBHUz7gikkzWfL55qhLkxSi0BBJMYcWdeXJ60fyi0uOYU71es77zTTunfYpjU3NUZcmKUChIZKC0tKMb500kKm3nE7FkCJ+8fd5XHz3m3y0Yn3UpUmSU2iIpLC+hTnce9Vw7r5iGCvXb+Nrv3uTO16Yp4sC5UtTaIikODPjK8cU8/ItpzN2WAn3vPYpY34zjRmf6qJA2X8KDZFOojAvkzvGHssfJp6EA9+8721u+9MHrN+qiwIlcQoNkU7mlMG9eOH7p/G/Th/E05XVnHvn67zw4cqoy5IkodAQ6YRys9K57fwjePbGUfTqms23H6vi249WsWqDLgqU1ik0RDqxo/sX8uz3RnHr+UN5df5qzrnzdZ6YtVQXBcpeKTREOrnM9DS+ffqhvHDzaRzVr4Db/jSHb973NovX6KJA+SKFhogAUNarC09cP5L/uPQYPlqxgTG/mcY9r31Kgy4KlDgKDRHZwcwYN2IgL99yOmcN7c0dL8zjot+9yZxqXRQoMQoNEfmC3gU53HPlcP7nyuGs2bSNi37/Br/8+1y2btdFgZ2dQkNE9mrM0X2ZesvpfOPEAfy/aYsY89tpvLVwTdRlSYQUGiLSqsLcTH556bE8cf1I0sz41qSZ/Gjy+6zfoosCOyOFhogk5ORDe/L89yv47hmHMmX2cs6+83X+9kGNTs/tZBQaIpKwnMx0fjRmKM99bxTFhTnc+IfZ3PBoFSvX66LAzkKhISL77ah+hTzz3VP48VeGMn1BLefe+TqPz1xCc7NGHalOoSEiX0pGeho3nHYoL958GscOKOQnz3zIo28vibosaWcKDRE5IIf07MJjE06i/JDu3Dd9kZ4QmOIUGiJywMyMiRWDqF67lRc/WhV1OdKOFBoi0ibOPbIPh/TMY9Ibi6IuRdqRQkNE2kR6mjHh1DLeXbqOqiV1UZcj7UShISJtZuzwEgpzM7lv2uKoS5F2klBomFk3M5tsZvPMbK6ZnWxmPcxsqpktCK/d49a/zcwWmtl8Mzsvrn24mc0Jv7vLzCy0Z5vZU6F9ppmVxvUZH/7GAjMb33a7LiJtLS8rgytOGsiLH69kyee6tXoqSnSk8VvgBXcfChwHzAVuBV529yHAy+E9ZnYkMA44ChgD3G1m6WE79wA3AEPCz5jQPgFY6+6DgV8Dd4Rt9QBuB04CRgC3x4eTiHQ8408pJSPNePDNz6IuRdrBPkPDzAqA04D7Adx9u7uvAy4CHg6rPQxcHJYvAp50923uvhhYCIwws2KgwN1neOy+A4/s1qdlW5OBs8Mo5DxgqrvXuftaYCo7g0ZEOqA+BTlceFw/nq5cpvtTpaBERhqDgFrgQTN718wmmVkXoI+71wCE195h/f7Asrj+1aGtf1jevX2XPu7eCKwHerayrV2Y2Q1mVmlmlbW1tQnskoi0p4mnDmLL9ib+MGtp1KVIG0skNDKAYcA97n4CsJkwFbUXtoc2b6X9y/bZ2eB+r7uXu3t5UVFRK6WJyMFwZL8CTh3ci4feWsz2Rl3sl0oSCY1qoNrdZ4b3k4mFyKow5UR4XR23/oC4/iXAitBesof2XfqYWQZQCNS1si0R6eAmVJSxasM2/jZH/8umkn2GhruvBJaZ2eGh6WzgY+A5oOVspvHAs2H5OWBcOCOqjNgB71lhCmujmY0Mxyuu3q1Py7bGAq+E4x4vAqPNrHs4AD46tIlIB3fGYUUM6d2V+6Yt1u3TU0hGguvdBDxuZlnAIuBaYoHztJlNAJYClwO4+0dm9jSxYGkEbnT3lmdEfgd4CMgFng8/EDvI/qiZLSQ2whgXtlVnZj8H3gnr/czdddWQSBIwi13sd+uf5jDj0885ZXCvqEuSNmCp9g2gvLzcKysroy5DRID6hiZOveMVji3pxgPXnBh1OdIKM6ty9/J9racrwkWk3eRkpnPVyFJembeahas3Rl2OtAGFhoi0qytHDiQ7I43739CtRVKBQkNE2lXPrtlcOqyEKbOX8/mmbVGXIwdIoSEi7W7CqWVsb2zWk/1SgEJDRNrd4N5dOWtobx6dsYT6hqZ9d5AOS6EhIgfFxIoyPt+8nT+/uzzqUuQAKDRE5KA4eVBPjupXwKQ3FtPcnFqn+ncmCg0ROShizxEvY+HqTby+QDcWTVYKDRE5aC44ph99C3KYNF3PEU9WCg0ROWiyMtIYf0opby78nI9WrI+6HPkSFBoiclB9a8RA8rLSdbFfklJoiMhBVZiXydfLB/CX91ewakN91OXIflJoiMhBd92oMpqanYfe+izqUmQ/KTRE5KAb2DOP847qy+NvL2Hztsaoy5H9oNAQkUhMrBjEhvpGJldVR12K7AeFhohEYvgh3TlhYDfuf2MxTbrYL2koNEQkMtdXDGJp3Ramfrwq6lIkQQoNEYnMeUf1ZUCPXF3sl0QUGiISmfQ049pTyqhcspZ3l66NuhxJgEJDRCL19RMHkJ+TwSRd7JcUFBoiEqmu2Rl866SBPD+nhmV1W6IuR/ZBoSEikbvmlFLSzHSxXxJQaIhI5IoLc/nqscU89c4yNtQ3RF2OtEKhISIdwsSKQWza1siTs5ZGXYq0QqEhIh3C0f0LGTmoBw+9+RkNTc1RlyN7odAQkQ7j+opBrFhfz9/n1ERdiuyFQkNEOowzD+/NoKIuTJq+GHfdWqQjUmiISIeRlmZMOLWMOcvXM2txXdTlyB4oNESkQ7lsWAnd8zK5b7ou9uuIFBoi0qHkZKZz1chDeHneKhbVboq6HNmNQkNEOpyrTi4lMz2NB97UaKOjSSg0zOwzM5tjZu+ZWWVo62FmU81sQXjtHrf+bWa20Mzmm9l5ce3Dw3YWmtldZmahPdvMngrtM82sNK7P+PA3FpjZ+LbacRHpuIrys7nk+P5Mrqpm7ebtUZcjcfZnpHGmux/v7uXh/a3Ay+4+BHg5vMfMjgTGAUcBY4C7zSw99LkHuAEYEn7GhPYJwFp3Hwz8GrgjbKsHcDtwEjACuD0+nEQkdU2oKKO+oZnH3l4SdSkS50Cmpy4CHg7LDwMXx7U/6e7b3H0xsBAYYWbFQIG7z/DYuXSP7NanZVuTgbPDKOQ8YKq717n7WmAqO4NGRFLYYX3yOf2wIh6esYRtjU1RlyNBoqHhwD/MrMrMbghtfdy9BiC89g7t/YFlcX2rQ1v/sLx7+y593L0RWA/0bGVbuzCzG8ys0swqa2trE9wlEenoJlaUsWbTNp59b0XUpUiQaGiMcvdhwPnAjWZ2Wivr2h7avJX2L9tnZ4P7ve5e7u7lRUVFrZQmIsnk1MG9GNo3n/t1sV+HkVBouPuK8LoaeIbY8YVVYcqJ8Lo6rF4NDIjrXgKsCO0le2jfpY+ZZQCFQF0r2xKRTsDMmFgxiPmrNjJ9wZqoyxESCA0z62Jm+S3LwGjgQ+A5oOVspvHAs2H5OWBcOCOqjNgB71lhCmujmY0Mxyuu3q1Py7bGAq+E4x4vAqPNrHs4AD46tIlIJ3HhccUU5Wdzn54j3iFkJLBOH+CZcHZsBvAHd3/BzN4BnjazCcBS4HIAd//IzJ4GPgYagRvdveUo1neAh4Bc4PnwA3A/8KiZLSQ2whgXtlVnZj8H3gnr/czddW8BkU4kOyOda04p5Vcvzmf+yo0c3jc/6pI6NUu1ecLy8nKvrKyMugwRaUPrtmzn5F++wlePLeZXlx8XdTkpycyq4i6p2CtdES4iHV63vCzGDi/h2fdWsHpjfdTldGoKDRFJChNOLaOhuZlHZ+hivygpNEQkKZT26sK5R/ThsbeXsHW7LvaLikJDRJLGxIpBrN3SwOTZ1fteWdqFQkNEksaJpd05rqSQB95YTHNzap3EkywUGiKSNMyMCRWDWLxmMy/PW73vDtLmFBoiklS+cnRf+nfL1cV+EVFoiEhSyUhP49pRpcxaXMcH1euiLqfTUWiISNL5+okD6JqdwSQ9R/ygU2iISNIpyMlk3IkD+NucGlas2xp1OZ2KQkNEktI1o0oBeOitzyKto7NRaIhIUirpnsf5R/fliZlL2VjfEHU5nYZCQ0SS1vUVg9i4rZGnK3Wx38Gi0BCRpHXcgG6MKO3BA28sprGpOepyOgWFhogktQkVZSxft5UXPloZdSmdgkJDRJLaOUf0obRnHvfpOeIHhUJDRJJaepox4dQy3l+2jqola6MuJ+UpNEQk6V02vITC3EzdWuQgUGiISNLLy8rgypED+cfHq1jy+eaoy0lpCg0RSQlXn1xKRprxwBu6tUh7UmiISEroU5DD147rz9OV1azbsj3qclKWQkNEUsbEijK2NjTxh1lLoy4lZSk0RCRlHFFcwKmDe/HwW5+xvVEX+7UHhYaIpJSJFWWs2rCNv36wIupSUpJCQ0RSyumHFTGkd1dd7NdOFBoiklLMjIkVZcyt2cBbn34edTkpR6EhIinnouP706trFpN0sV+bU2iISMrJyUzn6pNLeXV+LQtXb4y6nJSi0BCRlHTFSQPJzkjTc8TbmEJDRFJSz67ZXDa8hD+9u5w1m7ZFXU7KUGiISMq6blQZ2xubeXTGkqhLSRkJh4aZpZvZu2b21/C+h5lNNbMF4bV73Lq3mdlCM5tvZufFtQ83sznhd3eZmYX2bDN7KrTPNLPSuD7jw99YYGbj22KnRaRzGNy7K2cP7c2jby+hvqEp6nJSwv6MNL4PzI17fyvwsrsPAV4O7zGzI4FxwFHAGOBuM0sPfe4BbgCGhJ8xoX0CsNbdBwO/Bu4I2+oB3A6cBIwAbo8PJxGRfZlYMYi6zdt55t3lUZeSEhIKDTMrAS4AJsU1XwQ8HJYfBi6Oa3/S3be5+2JgITDCzIqBAnef4bErbh7ZrU/LtiYDZ4dRyHnAVHevc/e1wFR2Bo2IyD6NHNSDo/oVMGn6IpqbdbHfgUp0pPEb4EdA/M1c+rh7DUB47R3a+wPL4tarDm39w/Lu7bv0cfdGYD3Qs5Vt7cLMbjCzSjOrrK2tTXCXRKQzMDOurxjEp7Wbee2T1VGXk/T2GRpm9lVgtbtXJbhN20Obt9L+ZfvsbHC/193L3b28qKgowTJFpLO44Nhi+hbk6PTbNpDISGMU8DUz+wx4EjjLzB4DVoUpJ8JrS4RXAwPi+pcAK0J7yR7ad+ljZhlAIVDXyrZERBKWmZ7GNaNKeevTz/loxfqoy0lq+wwNd7/N3UvcvZTYAe5X3P1K4Dmg5Wym8cCzYfk5YFw4I6qM2AHvWWEKa6OZjQzHK67erU/LtsaGv+HAi8BoM+seDoCPDm0iIvvlmyMG0iUrnfs12jggB3Kdxn8A55rZAuDc8B53/wh4GvgYeAG40d1bznX7DrGD6QuBT4HnQ/v9QE8zWwjcQjgTy93rgJ8D74Sfn4U2EZH9UpibyddPHMBz769g5fr6qMtJWpZqtw4uLy/3ysrKqMsQkQ5oWd0WTv/Vq9xw2qHcev7QqMvpUMysyt3L97WerggXkU5jQI88xhzdlz/MXMLmbY1Rl5OUFBoi0qlMrBjEhvpG/li5bN8ryxcoNESkUxk2sDvDBnbjgTc/o0kX++03hYaIdDrXVwxiad0Wpn68MupSko5CQ0Q6ndFH9WVAj1zu0+m3+02hISKdTnqacd2oMqqWrGX20rVRl5NUFBoi0il9vXwA+TkZuthvPyk0RKRT6pKdwbdOGsjzH9awrG5L1OUkDYWGiHRa15xSSpoZD7yp0UaiFBoi0mkVF+Zy4XH9ePqdZazf2hB1OUlBoSEindqEU8vYvL2JJ2ctjbqUpKDQEJFO7ej+hZw8qCcPvfUZDU3N++7QySk0RKTTu/60MmrW1/P3OTVRl9LhKTREpNM747DeDCrqwn3TF5Fqd/5uawoNEen00tKMiacO4sPlG5i5WI/saY1CQ0QEuHRYf3p0yWLS9EVRl9KhKTRERICczHSuHHkIL81dzae1m6Iup8NSaIiIBFeNPISsjDQeeEMX++2NQkNEJCjKz+aS4/szuaqaus3boy6nQ1JoiIjEmVhRxrbGZh57e0nUpXRICg0RkThD+uRzxuFFPDLjM+obmqIup8NRaIiI7GbiqYNYs2k7z723IupSOhyFhojIbkYN7snQvvlMekMX++1OoSEishsz4/qKQXyyahPTFqyJupwORaEhIrIHFx7Xj9752brYbzcKDRGRPcjKSGP8KaVMX7CGuTUboi6nw1BoiIjsxRUnDSQ3M537dbHfDgoNEZG96JaXxeXlJTz73nJWb6iPupwOQaEhItKK60aV0djsPDJDF/uBQkNEpFWlvbpw7hF9eGzmEqqWrO30p+AqNERE9uGms4bQ2ORcds9bnPVfr/P7VxeyYt3WqMuKxD5Dw8xyzGyWmb1vZh+Z2U9Dew8zm2pmC8Jr97g+t5nZQjObb2bnxbUPN7M54Xd3mZmF9mwzeyq0zzSz0rg+48PfWGBm49ty50VEEnFMSSFv//hsfjX2WHrnZ/OrF+cz6o5XuHLSTJ55t5qt2zvP7UZsX0Ot8MHexd03mVkm8AbwfeBSoM7d/8PMbgW6u/v/MbMjgSeAEUA/4CXgMHdvMrNZoe/bwN+Bu9z9eTP7LnCsu3/bzMYBl7j7N8ysB1AJlAMOVAHD3X3t3uotLy/3ysrKA/hHIiLSumV1W5gyu5ops6tZVreVrtkZfOWYvowdPoATS7sTvg8nFTOrcvfyfa2Xsa8VPJYqLU8kyQw/DlwEnBHaHwZeA/5PaH/S3bcBi81sITDCzD4DCtx9RijwEeBi4PnQ51/DtiYDvwthdR4w1d3rQp+pwBhioSQiEokBPfK4+ZzD+KezhvDOZ3VMrqrmbx/U8HRlNQN75HHZsBIuHdafAT3yoi61ze0zNADMLJ3Yt/zBwO/dfaaZ9XH3GgB3rzGz3mH1/sRGEi2qQ1tDWN69vaXPsrCtRjNbD/SMb99DHxGRSKWlGScN6slJg3ry04uO4oUPVzJldjW/efkTfv3SJ4wc1IPLhpXwlWOK6ZKd0Mdth5fQXrh7E3C8mXUDnjGzo1tZfU/jMm+l/cv22fkHzW4AbgAYOHBgK6WJiLSPvKwMLh1WwqXDSli+bivPzK5mclU1P5z8Abc/9xHnH13MZcP7M7KsJ2lpyTd91WK/os/d15nZa8SmiFaZWXEYZRQDq8Nq1cCAuG4lwIrQXrKH9vg+1WaWARQCdaH9jN36vLaHuu4F7oXYMY392ScRkbbWv1su3ztrCDeeOZjZS9cyuaqav75fw5TZ1fTvlstlw/pz2fASDunZJepS91siZ08VhREGZpYLnAPMA54DWs5mGg88G5afA8aFM6LKgCHArDCVtdHMRobjFVfv1qdlW2OBV8KxlBeB0WbWPZydNTq0iYh0eGbG8EN68MtLj+Wdfz6H3447nkFFXfjvVxdy+q9e4/L/eYun3lnKxvqGqEtNWCJnTx1L7EB3OrGQedrdf2ZmPYGngYHAUuDyuAPWPwGuAxqBm939+dBeDjwE5BI7AH6Tu7uZ5QCPAicQG2GMc/dFoc91wI9DOf/u7g+2Vq/OnhKRjq5m/VaeeXc5U6qq+bR2MzmZaYw5qi+XDS/hlEN7kR7B9FWiZ0/tMzSSjUJDRJKFu/PesnVMmV3Nc++tYEN9I8WFOVxyQmz66tCirgetFoWGiEgSqW9o4qW5q5hSVc3rn9TS7HDCwG6MHV7CV4/tR2FuZrv+fYWGiEiSWr2hnj+/t5zJVdV8smoTWRlpjD6yD2OHl1AxpKhdpq8UGiIiSc7d+U1oNyEAAAhjSURBVHD5BiZXLePZ91ewbksDvfOzuWRYf8YOK2FIn/w2+1sKDRGRFLKtsYlX561mclU1r86vpanZOa6kkLHDS7jwuH50y8s6oO0rNEREUlTtxm08G6av5q3cSFZ6Gucc2ZvLhpVw+mFFZKTv/w3MFRoiIp3ARyvWM6VqOX9+bzl1m7fTq2s2Fx/fj7HlJQztW5DwdhQaIiKdSENTM6/Nr2Vy1TJembeahibnqH4FjB1ewkXH96dHl9anrxQaIiKdVN3m7Tz33nImz67mw+UbyEgzzhram7HDSzjj8N5kZXxx+kqhISIizFu5gSlV1Tzz7grWbNpGjy5ZXHR8Py4bVsJR/Qp2PPtDoSEiIjs0NjUzbUEtU6qWM/XjVWxvamZo3/wd01e9C3La5iFMIiKS/DLS0zhraB/OGtqHdVu285cPaphcVc2//W0uv3x+XuLbaccaRUSkA+qWl8VVIw/hqpGHsHD1RiZXLee2XybWd/9P5hURkZQxuHc+t54/NOH1FRoiIpIwhYaIiCRMoSEiIglTaIiISMIUGiIikjCFhoiIJEyhISIiCVNoiIhIwlLu3lNmthGYH3Ud7agXsCbqItqR9i+5pfL+pfK+ARzu7vt8fmwq3kZkfiI33UpWZlap/Ute2r/klcr7BrH9S2Q9TU+JiEjCFBoiIpKwVAyNe6MuoJ1p/5Kb9i95pfK+QYL7l3IHwkVEpP2k4khDRETaiUJDREQSllKhYWZjzGy+mS00s1ujrqctmdkDZrbazD6Mupb2YGYDzOxVM5trZh+Z2fejrqmtmFmOmc0ys/fDvv006prag5mlm9m7ZvbXqGtpa2b2mZnNMbP3Ej01NZmYWTczm2xm88L/gyfvdd1UOaZhZunAJ8C5QDXwDvBNd/840sLaiJmdBmwCHnH3o6Oup62ZWTFQ7O6zzSwfqAIuToV/f2ZmQBd332RmmcAbwPfd/e2IS2tTZnYLUA4UuPtXo66nLZnZZ0C5u6fkxX1m9jAw3d0nmVkWkOfu6/a0biqNNEYAC919kbtvB54ELoq4pjbj7tOAuqjraC/uXuPus8PyRmAu0D/aqtqGx2wKbzPDT2p8WwvMrAS4AJgUdS2yf8ysADgNuB/A3bfvLTAgtUKjP7As7n01KfKh09mYWSlwAjAz2kraTpi6eQ9YDUx195TZt+A3wI+A5qgLaScO/MPMqszshqiLaWODgFrgwTC9OMnMuuxt5VQKDdtDW0p9m+sMzKwrMAW42d03RF1PW3H3Jnc/HigBRphZykwxmtlXgdXuXhV1Le1olLsPA84HbgzTxakiAxgG3OPuJwCbgb0eE06l0KgGBsS9LwFWRFSLfAlhvn8K8Li7/ynqetpDGPa/BoyJuJS2NAr4Wpj3fxI4y8wei7aktuXuK8LrauAZYtPhqaIaqI4b/U4mFiJ7lEqh8Q4wxMzKwoGcccBzEdckCQoHi+8H5rr7nVHX05bMrMjMuoXlXOAcYF60VbUdd7/N3UvcvZTY/3evuPuVEZfVZsysSzg5gzBtMxpImbMY3X0lsMzMDg9NZwN7PQElZe5y6+6NZvY94EUgHXjA3T+KuKw2Y2ZPAGcAvcysGrjd3e+Ptqo2NQq4CpgT5v4Bfuzuf4+wprZSDDwczvBLA55295Q7LTWF9QGeiX2vIQP4g7u/EG1Jbe4m4PHwhXsRcO3eVkyZU25FRKT9pdL0lIiItDOFhoiIJEyhISIiCVNoiIhIwhQaIiKSMIWGiIgkLGWu0xBpjZn9K7G7BBcA09z9pQPYVinw11S827DIvig0pFNx93+JugaRZKbpKUlZZvaT8FCul4DDQ9tDZjY2LP+Lmb1jZh+a2b3hViZ729bw8BClGcCNce2lZjbdzGaHn1Na2UaxmU0LD/L50MwqQvtoM5sR+v8x3LSx5cE/vwi/qzSzYWb2opl9ambfDut0NbOXQ985ZnZRXF1zzey+8OCnf4RbmGBm14f9ft/MpphZ3oH+s5bOQ6EhKcnMhhO7D9IJwKXAiXtY7XfufmKYZsoFWntw0IPAP7n77k80Ww2cG+6A+g3grla28S3gxXC32+OA98ysF/DPwDlhG5XALXF9loW/OR14CBgLjAR+Fn5fD1wS+p4J/Fdc+A0Bfu/uRwHrgMtC+5/Cfh9H7LklE1qpWWQXmp6SVFUBPOPuWwDMbE83rzzTzH4E5AE9gI+Av+y+kpkVAt3c/fXQ9CixW2RD7IFKvzOz44Em4LBWanoHeCDczffP7v6emZ0OHAm8GT7rs4AZcX1a6p4DdA0PqNpoZvXhJoibgV+EW3U3E3uGTJ/QZ7G7t9zHqwooDctHm9m/Ad2ArsTu1yaSEIWGpLK93ljNzHKAu4k9wnNZOFCes7fVW9nWD4BVxEYOacS++e+5GPdp4cP9AuBRM/sVsJbYQ5m+uZdu28Jrc9xyy/sM4AqgCBju7g3h9uQ5u/WFWKDlhuWHiD1K930zu4bYjTBFEqLpKUlV04BLzCw33Nb6wt1+3/LBuiYcQxi7tw2FZ2CsN7NTQ9MVcb8uBGrcvZnYXXrT97YdMzuE2MOK7iN2G/hhwNvAKDMbHNbJM7PWRiu7KwzbbDCzM4FDEuiTD9SEEc8V+1pZJJ5GGpKS3H22mT0FvAcsIXZMIP7368zsPmLTPp8RmzpqzbXEppa2sOt0zt3AFDO7HHiV2HTR3pwB/NDMGoid/nu1u9eGb/tPmFl2WO+fgU/2uZMxjwN/MbNKYvuayHM6/i+xR+kuIbb/+Qn+LRHdGl1ERBKn6SkREUmYpqdE4pjZ74k9RTDeb939wf3YxjHEzrCKt83dTzrQ+kSipukpERFJmKanREQkYQoNERFJmEJDREQSptAQEZGE/X8DuFxGVtr7qwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "frame['dia_da_semana'] = frame['Data de abertura'].dt.dayofweek\n",
    "frame.groupby(['dia_da_semana']).counter.count().plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1c0cb63ddc8>"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEGCAYAAAB7DNKzAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAAgAElEQVR4nO3deXhV1bn48e+bOSEDCRkEEuYwKmNA6oQzVG3RKpW2KlauOKBW23p/2uHS6u29tb1qtVYqrShaiwPaSq1WGRQcEEiYB0nCmDAkgSQQyJy8vz/OTj1gSAIk2Wd4P89znrOz9l477zkczpu119priapijDHGnEyI2wEYY4zxbZYojDHGtMgShTHGmBZZojDGGNMiSxTGGGNaFOZ2AO0tOTlZ+/Tp43YYxhjjV3Jycg6qakpz+wIuUfTp04fs7Gy3wzDGGL8iIrtPts8uPRljjGmRJQpjjDEtskRhjDGmRZYojDHGtMgShTHGmBZZojDGGNMiSxTGGGNaFHD3URjT0RoblYrqesoqaymrrKW8qo7yylrKjtXRqMqUrAwSosPdDtOYdmOJwpgT5BdX8K9NByirrKOsspbDznN5089VdTS2sIzLp/kHeX7aWEJCpPOCNqYDtZooRCQKWA5EOscvUNVZIvIL4HagxDn0J6r6rlPnYWA60ADcp6rvO+VjgBeBaOBd4AeqqiISCbwEjAEOATeq6i6nzjTgZ87v+G9VnXeGr9mYk6qpb+CmP6/iwJFqYiJCSYyJoGtMOF1jwuneNZrEmHCnLIKu0eEkdgmna0wEiTERJMaE8/a6fcxauJk/Lt/O3RcPcPvlGNMu2tKiqAEuVdWjIhIOfCIi7zn7nlTV//M+WESGAlOBYUAPYLGIDFTVBmA2MAP4HE+imAS8hyeplKnqABGZCjwG3CgiScAsIAtQIEdEFqpq2Zm9bGOa93p2IQeOVPPy9HFcmNnstDctuuVrvcneXcb/vb+N0b0SGd+vWwdEaUznarUzWz2OOj+GO4+W1k+dDLyqqjWquhPIB8aJSHcgXlVXqGf91ZeAa73qNLUUFgCXiYgAE4FFqlrqJIdFeJKLMe2utr6R2R/mM6Z3IhcMSD6tc4gI//utc+jTrQv3zV9LSUVNO0dpTOdr06gnEQkVkXVAMZ4v7pXOrntEZIOIzBWRRKesJ1DgVb3QKevpbJ9YflwdVa0HDgPdWjjXifHNEJFsEckuKSk5cbcxbbIgp5B9h6v5wWWZeP5OOT2xkWE8e9NojlTX8YNX19LQUoeGMX6gTYlCVRtUdSSQjqd1cDaey0j9gZHAfuBx5/Dm/odpC+WnW8c7vjmqmqWqWSkpp365wJi6hkb+8GE+IzO6cmHm6bUmvA0+K55HJ5/NZ9sP8dTi3HaI0Bj3nNJ9FKpaDnwETFLVIieBNAJ/AsY5hxUCGV7V0oF9Tnl6M+XH1RGRMCABKG3hXMa0q7+t2cve8qozbk14m5KVwZQx6fz+w3yW5VpL1/ivVhOFiKSISFdnOxq4HPjC6XNoch2wydleCEwVkUgR6QtkAqtUdT9QISLjnf6HW4C3vepMc7ZvAJY6/RjvA1eKSKJzaetKp8yYdlPX0MgzH+YzPD2Biwe1b4v0kclnMygtjvtfXcu+8qp2PbcxnaUtLYruwIcisgFYjaeP4h3gNyKy0Sm/BHgAQFU3A68DW4B/ATOdEU8AdwF/xtPBvR3PiCeA54FuIpIP/BB4yDlXKfCo83tXA484Zca0m7fX7WNPaSX3Xdp+rYkm0RGh/OF7o6mtb+Te+Wupa2hs1/Mb0xnE84d74MjKylJb4c60VX1DI1c8uZyYiFDeufeCdk8UTf6xfh/3zl/L7Rf25adXD+2Q32HMmRCRHFXNam6fzfVkgto/Nuxj58Fj3NeOfRPN+caIHtzytd786eOdvL/5QIf9HmM6giUKE7QaGpXfL81n8FlxXDEkrcN/30+vHsLw9AR+/MZ69hyq7PDfZ0x7sURhgtY/N+5nR4mnNdEZ8zJFhoXyh++ORoC7/5pDdV1Dq3WM8QWWKExQamxUfr8kj4FpsUwadlan/d6MpBge//ZINu09wqPvbOm032vMmbBEYYLSe5sOkFd8lHsv7ZzWhLcrhqZxx0X9eGXlHt5et7dTf7cxp8MShQk6jY3K75fm0T+lC1ed0731Ch3gxxMHMbZPIg+/tZH84gpXYjCmrSxRmKDzwZYDfHGggnsvzSTUpTUjwkND+P13RhMVHsrdr6yhsrbelTiMaQtLFCaoqCpPLcmnX3IXvjGih6uxnJUQxVNTR5JXfJSf/X0TgXZPkwkclihMUFm8tZit+48w85IBrrUmvF2YmcJ9l2by1pq9vLa6oPUKxrjAEoUJGp7WRC69u8UweaS7rQlv912WyQUDkvmvhZvZUFjudjjGfIUlChM0PtxWzKa9ntZEWKjvfPRDQ4Snpo4kJTaSO1/O4dBRW+zI+Bbf+d9iTAdq6ptIT4zmulFfWfvKdd1iI/njTWM4eKyWe+evpd4mDzQ+xBKFCQrLcktYX1DOzEsGEO5DrQlv56Qn8KtrPYsd/eb9bW6HY8y/+eb/GGPakac1kUfPrtFcPzq99QoumpKVwU3jezFn+Q7+sd7W6DK+wRKFCXif5h9i7Z5y7rq4PxFhvv+R/69rhjGmdyL/uWADXxw44nY4xliiMIGtaaRT94QopmT5dmuiSURYCM9+bzSxUWHc8XIOh6vq3A7JBDlLFCagrdhxiNW7yrjr4v5EhoW6HU6bpcVHMft7o9lbVsX9r66lsdFuxjPusURhAtrTS/JIjYvk21kZbodyyrL6JDHrG0P5cFsJv1uS53Y4JohZojABa+WOQ3y+o5Q7J/QnKtx/WhPebhrfm+tHp/P0kjwWbylyOxwTpCxRmID19NI8kmMj+e65vdwO5bSJCL+67mzO7hnPA6+tY0fJUbdDMkGo1UQhIlEiskpE1ovIZhH5pVOeJCKLRCTPeU70qvOwiOSLyDYRmehVPkZENjr7nhZnkWIRiRSR15zylSLSx6vONOd35InItPZ88SZwbSgs59P8Q9w5oZ/ftiaaRIWH8sebxhAeFsIdL+dwtMZmmjWdqy0tihrgUlUdAYwEJonIeOAhYImqZgJLnJ8RkaHAVGAYMAl4VkSa/qfOBmYAmc5jklM+HShT1QHAk8BjzrmSgFnAucA4YJZ3QjLmZD7YXERoiDDFD/smmpOeGMMz3xnF9pKj/OeC9TbTrOlUrSYK9Whq74Y7DwUmA/Oc8nnAtc72ZOBVVa1R1Z1APjBORLoD8aq6Qj2f8pdOqNN0rgXAZU5rYyKwSFVLVbUMWMSXycWYk1qeV8LoXl1JiA53O5R2c96AZB76+mDe3XiA55bvcDscE0Ta1EchIqEisg4oxvPFvRJIU9X9AM5zqnN4T8B7vuRCp6yns31i+XF1VLUeOAx0a+FcJ8Y3Q0SyRSS7pKSkLS/JBLCDR2vYUHiYCQNT3A6l3d1+YT+uHt6d3/zrCz7Os8+66RxtShSq2qCqI4F0PK2Ds1s4vLlJ/rWF8tOt4x3fHFXNUtWslJTA+3Iwp+aTvIMATBiY2sqR/kdE+M31w8lMjePe+WspKK10OyQTBMJO5WBVLReRj/Bc/ikSke6qut+5rFTsHFYIeF8YTgf2OeXpzZR71ykUkTAgASh1yi8+oc5HpxKzCT7Lckvo1iWCYT3i3Q6lQ3SJDOO5m8fwjWc+4c6/5PDmXee12GFf19DIvvIqCkqr2FNaSUFZJXtKKyksreTg0VpCQiBUhJAQIVSE0BBBRAg9odx7f2iIcGFmMjeN7+33gwVM61pNFCKSAtQ5SSIauBxPZ/NCYBrwa+f5bafKQuCvIvIE0ANPp/UqVW0QkQqnI3wlcAvwe68604AVwA3AUlVVEXkf+B+vDuwrgYfP9EWbwNXYqCzPLeGigSmE+MAKdh2lT3IXnpo6kunzsvnJWxt5+Kohni//skr2HPoyGRSUVrH/cBXeN3aHhwo9u0aTkRRD/9RYVKFRlYZG/fdzQ2NzZUp9YyM19cqxmgb++59beW75Du65ZABTx2X41Z3v5tS0pUXRHZjnjFwKAV5X1XdEZAXwuohMB/YAUwBUdbOIvA5sAeqBmara4JzrLuBFIBp4z3kAPA+8LCL5eFoSU51zlYrIo8Bq57hHVLX0TF6wCWyb9x3h0LFaLhqY7HYoHe7SwWncf9lAnlycy1tr9x63LyUukl5JMYztk0ivpJ6kJ8XQy3mkxUe1yzKwK3cc4vFFucxauJnnlm3nnkszmZKV7rPTuJvTJ4E2zC4rK0uzs7PdDsO45JmlefzfB7lk/+xykmMj3Q6nwzU2Kq9nF1Bd10CvbjFkJMaQnhhDdETn/HWvqnyaf4jHF21j7Z5yMpKiue/STK4b1dOnVhE0rRORHFXNanafJQoTSL79xxVU1TXwj3svcDuUoKKqfLSthCcW5bJx72H6JnfhB5dl8o0RPdql9WI6XkuJwlK+CRhHquvI2VMWkMNifZ2IcMngVBbecz7P3TyGyLAQ7n9tHZN+t5x3N+632W/9nCUKEzA+yz9IQ6MyYZAlCreICBOHncW7913IM98dRaMqd7+yhqt//wmLthTZHeV+yhKFCRjLckuIiwpjVEZXt0MJeiEhwjXDe/DBAxN48sYRVNXWc/tL2Vz7h0/tRkE/ZInCBARVZdm2Es7vn2ydqD4kNES4blQ6i384gd9cP5yDR2u5+flVLP3Cpkz3J/Y/ygSE/OKj7DtcbZedfFRYaAjfHpvBkh9NYPBZcTz4xgaKK6rdDsu0kSUKExCW5XouZ1xkHdk+LSo8lKe/M4qjNfU8+MYG6+T2E5YoTEBYlltCZmosPbtGux2KacXAtDh+dvUQluWW8MJnu9wOx7SBJQrj96pqG1i5s9SGxfqRm8b35vIhqTz23hds2XfE7XBMKyxRGL/3+c5D1NY3Wv+EHxERHrt+OAkx4dz36lqqahtar2RcY4nC+L1l20qICg9hbJ8kt0Mxp6BbbCRPfHsE+cVH+dW7W9wOx7TAEoXxe8tzSxjfr5tNd+2HLsxM4fYL+/KXz/ewaIsNmfVVliiMX9tzqJIdB49Z/4Qf+/HEQQzrEc9/LlhP0REbMuuLLFEYv7bMucvXEoX/igwL5ampo6iqa+BHr6+3IbM+yBKF8WvLc0vISIqmb3IXt0MxZ2BAaiyzvjGMT/IP8udPdrgdjjmBJQrjt2rrG/ks/yATBqYgYlNZ+7upYzOYOCyN376/jU17D7sdjvFiicL4rZzdZRyrbeCiTLvsFAhEhF9/azjdukRy3/y1VNbWux2ScViiMH5rWW4JYSHCeQMCf9nTYJHYJYInbhzBzkPHePQdGzLrKyxRGL+1LLeErD6JxEa2Zel34y/O65/MnRP6M39VAe9t3O92OAZLFMZPFR+pZuv+I0wYmOp2KKYD/PCKgYxIT+Chtzay/3CV2+EEvVYThYhkiMiHIrJVRDaLyA+c8l+IyF4RWec8rvKq87CI5IvINhGZ6FU+RkQ2OvueFqcHUkQiReQ1p3yliPTxqjNNRPKcx7T2fPHGfy3POwjYsNhAFR4awlNTR1HX0MgDr62jwYbMuqotLYp64EeqOgQYD8wUkaHOvidVdaTzeBfA2TcVGAZMAp4VkaZbZmcDM4BM5zHJKZ8OlKnqAOBJ4DHnXEnALOBcYBwwS0QSz+QFm8CwLLeElLhIhnSPczsU00H6JHfhl98cxuc7Snlu+Xa3wwlqrSYKVd2vqmuc7QpgK9CzhSqTgVdVtUZVdwL5wDgR6Q7Eq+oK9Syc+xJwrVedec72AuAyp7UxEVikqqWqWgYs4svkYoJUQ6PycV6JDYsNAjeMSefq4d154oNc1heUux1O0DqlPgrnktAoYKVTdI+IbBCRuV5/6fcECryqFTplPZ3tE8uPq6Oq9cBhoFsL5zoxrhkiki0i2SUlth5voNtQWE55ZZ0tUhQERIT/ufYc0uKj+MGrazlaY0Nm3dDmRCEiscCbwP2qegTPZaT+wEhgP/B406HNVNcWyk+3zpcFqnNUNUtVs1JS7Msj0C3LLUEELrRhsUEhISacJ28cyZ7SSn793la3wwlKbUoUIhKOJ0m8oqpvAahqkao2qGoj8Cc8fQjg+as/w6t6OrDPKU9vpvy4OiISBiQApS2cywSxZbkljEjvSmKXCLdDMZ1kXN8kbhrfm1dXFbDnUKXb4QSdtox6EuB5YKuqPuFV3t3rsOuATc72QmCqM5KpL55O61Wquh+oEJHxzjlvAd72qtM0oukGYKnTj/E+cKWIJDqXtq50ykyQKq+sZX1BuY12CkL3XDKA0BDhqSV5bocSdNpyp9L5wM3ARhFZ55T9BPiOiIzEcyloF3AHgKpuFpHXgS14RkzNVNWm5avuAl4EooH3nAd4EtHLIpKPpyUx1TlXqYg8Cqx2jntEVUtP76WaQPBJ/kEaFVvNLgilxkdx8/jezP10J3df0p/+KbFuhxQ0xPOHe+DIysrS7Oxst8MwHeTBN9bzwZYi1vz8CkJDbMRTsDl4tIYLH/uQK4am8fR3RrkdTkARkRxVzWpun92ZbfyGqrIst4QLMpMtSQSp5NhIpp3Xh39s2EduUYXb4QQNSxTGb3xxoILiihrrnwhyd1zUjy4RYfxuca7boQQNSxTGbyzLtdXsjGeG2dvO78O7Gw+weZ+tW9EZLFEYv7FsWwmDz4ojLT7K7VCMy6Zf2I/4qDCeXGQjoDqDJQrjF47V1JO9u9RGOxkAEqLDuf3CfizeWmRTe3QCSxTGL6zYfoi6BrXLTubfvn9BXxJjwnlikfVVdDRLFMYvLMstISYilKzeSW6HYnxEbGQYd0zoz7LcEnJ22+1VHckShfF5qspHucWc178bEWH2kTVfuuVrvUmOjeDxD6xV0ZHsf53xebsOVVJQWmWXncxXxESEcdfFA/hs+yFWbD/kdjgByxKF8XnLthUD2LKnplnfO7cXafGRPLkol0CbacJXWKIwPm9Zbgl9k7vQq1uM26EYHxQVHsrMSwawalcpn+QfdDucgGSJwvi06roGVuw4ZJedTItuHJtBj4QoHv/AWhUdwRKF8WnZu8qormvkooG2SJE5uciwUO69LJN1BeV86FyqNO3HEoXxactyi4kIDWF8v25uh2J83A1j0umVFMMT1lfR7ixRGJ+2PPcgY/smEhPRlqVTTDALDw3hvssy2bT3CO9vLnI7nIBiicL4rPLKWrYVVfA1a02YNrp2ZA/6JXfhd4tzaWy0VkV7sURhfNaaPWUAZPWxu7FN24SFhvCDyzP54kAF727a73Y4AcMShfFZq3eVERYijEjv6nYoxo9cM7wHA9Ni+d3iPBqsVdEuLFEYn5W9q5SzeyYQHRHqdijGj4SGCPdfPpD84qMsXL/X7XACgiUK45Nq6htYX3iYsX0S3Q7F+KFJw85iSPd4nlqcR31Do9vh+L1WE4WIZIjIhyKyVUQ2i8gPnPIkEVkkInnOc6JXnYdFJF9EtonIRK/yMSKy0dn3tIiIUx4pIq855StFpI9XnWnO78gTkWnt+eKN79q09zC19Y2MsdlizWkICRF+eMVAdh2q5K011qo4U21pUdQDP1LVIcB4YKaIDAUeApaoaiawxPkZZ99UYBgwCXhWRJquHcwGZgCZzmOSUz4dKFPVAcCTwGPOuZKAWcC5wDhglndCMoFr9a6mjmz75zan5/IhqYxIT+CpJXnU1lur4ky0mihUdb+qrnG2K4CtQE9gMjDPOWwecK2zPRl4VVVrVHUnkA+ME5HuQLyqrlDP3TAvnVCn6VwLgMuc1sZEYJGqlqpqGbCIL5OLCWDZu8rom9yF5NhIt0MxfkpEeOCKgewtr+L17AK3w/Frp9RH4VwSGgWsBNJUdT94kgnQNLVnT8D7X6XQKevpbJ9YflwdVa0HDgPdWjjXiXHNEJFsEckuKSk5lZdkfJCqkrO7lKze1powZ2bCwBTG9E7kmaX5VNc1uB2O32pzohCRWOBN4H5VPdLSoc2UaQvlp1vnywLVOaqapapZKSk2eZy/215yjLLKOsba/RPmDIkID04cxIEj1Tzw2jobLnua2pQoRCQcT5J4RVXfcoqLnMtJOM9NM3EVAhle1dOBfU55ejPlx9URkTAgASht4VwmgGXv8ixrOcb6J0w7GN+vGz+/ZijvbTrAL/+x2eaBOg1tGfUkwPPAVlV9wmvXQqBpFNI04G2v8qnOSKa+eDqtVzmXpypEZLxzzltOqNN0rhuApU4/xvvAlSKS6HRiX+mUmQC2elcZSV0i6Jfcxe1QTICYfkFf7rioHy+t2M2zH213Oxy/05aZ1s4HbgY2isg6p+wnwK+B10VkOrAHmAKgqptF5HVgC54RUzNVteni4F3Ai0A08J7zAE8iellE8vG0JKY65yoVkUeB1c5xj6iqraIe4Jr6J5zR08a0i/83aTDFFTX89v1tpMRF8u2sjNYrGaANiUJVP6H5vgKAy05S51fAr5opzwbObqa8GifRNLNvLjC3tThNYCipqGHXoUq+e24vt0MxASYkRHjs+uEcPFrDw29tJDk2gksHp7kdll+wO7ONT8nZ7Wkw2kSApiNEhIUw+6YxDO0ez92vrGGtM/GkaZklCuNTVu8qIzIshLN7JLgdiglQsZFhzL11LKlxUdz24mp2lBx1OySfZ4nC+JTsXaWMyOhKRJh9NE3HSYmL5KXbxhEiwi1zV1F8pNrtkHya/W80PqOytp7N+47YRICmU/RJ7sIL3x9L6bFapr2wmiPVdW6H5LMsURifsa6gnPpGJcsmAjSdZHh6V2bfNIa8ogrufDmHmnq7e7s5liiMz8jeVYYIjO5lLQrTeSYMTOE3Nwzns+2H+NHr620J1WbYivXGZ2TvLmNQWhwJMeFuh2KCzLdGp1NcUcOv3/uC1Lgofn7NELuPx4slCuMTGhqVNbvLmDyyh9uhmCB1x0X9KDpSzdxPd3JWQiQzLurvdkg+wxKF8QnbDlRwtKbeJgI0rhERfn71UIoravifd78gJS6S60alt14xCFiiMD4h27nRboxNLW5cFBIiPPHtEZQereXBNzbQrUskFw20GamtM9v4hNW7yjgrPor0xGi3QzFBLjIslOduGcOA1Fju/EsOGwrL3Q7JdZYojE/I2VVKVh+bCND4hviocObdNo7EmAi++6eVLN5S5HZIrrJEYVy3t7yKfYerbUU741PS4qN4486v0Te5C//xUjZPL8kL2qGzliiM65oWKrKJAI2v6dE1mjfu/BrXjerJE4tyufuVNRytqXc7rE5nicK4LntXGV0iQhl8VpzboRjzFVHhoTzx7RH8/JqhLNpaxLee/ZRdB4+5HVanskRhXLd6VymjeycSFmofR+ObRITpF/TlpdvGUVxRwzef+YRluSVuh9Vp7H+mcdWR6jq2FVXY/E7GL5w/IJl/3HMBPbpG8/0XVvHcsu1BsQa3JQrjqjW7y1CFLJsx1viJjKQY3rr7PL5+Tnf+970vuO/VdVTVBvZkgpYojKuyd5URGiKMzOjqdijGtFlMRBjPfGcU/2/SYN7ZsI/rZ39GQWml22F1GEsUxlXZu0sZ1iOeLpE2SYDxLyLCXRf3Z+6tYykoq+Sbz3zCZ9sPuh1Wh2g1UYjIXBEpFpFNXmW/EJG9IrLOeVzlte9hEckXkW0iMtGrfIyIbHT2PS3OnVUiEikirznlK0Wkj1edaSKS5zymtdeLNr6htr6RdQXlNm2H8WuXDEpl4T0X0C02kpufX8ULn+4MuH6LtrQoXgQmNVP+pKqOdB7vAojIUGAqMMyp86yIhDrHzwZmAJnOo+mc04EyVR0APAk85pwrCZgFnAuMA2aJiH2jBJDN+w5TXddoEwEav9c3uQt/u/s8Lh2cyi//sYUfv7GB6rrA6bdoNVGo6nKgtI3nmwy8qqo1qroTyAfGiUh3IF5VV6gn1b4EXOtVZ56zvQC4zGltTAQWqWqpqpYBi2g+YRk/lbO7DMDuyDYBIS4qnOduGsP9l2fy5ppCbnxuBcUVgbEW95n0UdwjIhucS1NN/9N7AgVexxQ6ZT2d7RPLj6ujqvXAYaBbC+f6ChGZISLZIpJdUhI8Y5v93epdpfRKiiE1PsrtUIxpFyEhwv2XD2TOzWPIKz7K1DmfU3TE/5PF6SaK2UB/YCSwH3jcKW9uRjdtofx06xxfqDpHVbNUNSslxaYE9geqSs7uMhsWawLSlcPOYt5t4yg6XM3UOZ9z4LB/J4vTShSqWqSqDaraCPwJTx8CeP7qz/A6NB3Y55SnN1N+XB0RCQMS8FzqOtm5TADYdaiSg0dr7UY7E7DG9knipenjKKmoYeqcFew/XOV2SKfttBKF0+fQ5DqgaUTUQmCqM5KpL55O61Wquh+oEJHxTv/DLcDbXnWaRjTdACx1+jHeB64UkUTn0taVTpkJAKudiQDHWovCBLAxvT3J4tDRWm587nP2lvtnsmjL8Nj5wApgkIgUish04DfOUNcNwCXAAwCquhl4HdgC/AuYqapNXf93AX/G08G9HXjPKX8e6CYi+cAPgYecc5UCjwKrnccjTpkJADm7yugaE07/lFi3QzGmQ43ulchL08dRdqyWqXNWUFjmfzfmSaCN983KytLs7Gy3wzCtuPTxj+jbrQvP3zrW7VCM6RTrC8q5+fmVxEeHM//28WQkxbgd0nFEJEdVs5rbZ3dmm0536GgNO0qO2foTJqiMyOjKK/8xnorqeqbO+Zw9h/ynZWGJwnS6f98/Yf0TJsick57AK/9xLkdr6pk6ZwW7D/nHuhaWKEyny95dRkRoCOf0THA7FGM63dk9E/jr7edSVdfA1Dmf+8UiSJYoTKfL3lXK8PQEosJDWz/YmAA0rEcCf719PDX1jdw4ZwU7So66HVKLLFGYTlVd18DGvYcZY5edTJAb0j2e+bePp75BmTrnc7b7cLKwRGE61fqCcuoalLF2o50xDDorjvkzxtOonmSRX1zhdkjNskRhOlW205FtU4sb4zEwLY75t49HFabOWUleke8lC0sUplNl7yplQGosiV0i3A7FGJ+RmRbHqzPGIwJT53zOFweOuB3ScSxRmE7T2OiZCNCm7TDmq5YOiDYAABTGSURBVAakxvLqjPGEhghff+pjrp/9GX/4MJ+t+4+4vhCSrT9pOk1e8VGOVNczxvonjGlW/5RY/j7zfF5bXcDSL4r57fvb+O372+ieEMUlg1O5bHAq5/VPJjqic0cMWqIwncYmAjSmdT26RvPAFQN54IqBFB+p5sNtxSz9opi/r93LX1fuITIshPP6d+PSwalcMjiV9MSOnwrEEoXpNDm7y0iJi6SXj81xY4yvSo2P4saxvbhxbC9q6htYtbOUpV94EseHb2+GtzczKC2OS4ekcungVEZldCUstP17FCxRmE6zelcpWb0T8cw0b4w5FZFhoVyYmcKFmSn81zVD2XHwGEu3epLGn5bvYPZH2+kaE86vrj2Hq4d3b/2Ep8AShekUBw5XU1hWxffP7+t2KMb4PRGhf0os/VNiuf2ifhypruPj3IPM+XgH97+2lq4x4Zw/ILndfp+NejKdInu39U8Y01Hio8K5enh3XrptHP2SY7nj5Rw27zvcbue3RGE6RfauMqLDQxnSPd7tUIwJWAnR4bx421jiosK49YXVFJS2z1TmlihMp8jeXcqoXl0J74CONmPMl7onRDPvtnHU1DUw7YVVlB2rPeNz2v9a0+GO1tSzZd8RsmzaDmM6xcC0OP48bSyFZVXcNm81VbUNrVdqgSUK0+HW7imjUbEV7YzpROP6JvH01JGsKyjn3vlrqG9oPO1zWaIwHW7RliIiwkIYbS0KYzrVpLO788tvDmPx1mJ+/vam054KpNVEISJzRaRYRDZ5lSWJyCIRyXOeE732PSwi+SKyTUQmepWPEZGNzr6nxRlMLyKRIvKaU75SRPp41Znm/I48EZl2Wq/QuKq6roG31+1j4rCziI200djGdLZbvtaHuy/uz/xVBTy9JP+0ztGWFsWLwKQTyh4ClqhqJrDE+RkRGQpMBYY5dZ4VkaZJSWYDM4BM59F0zulAmaoOAJ4EHnPOlQTMAs4FxgGzvBOS8Q9LthZzuKqOKWPS3Q7FmKD14MRBXD86nScX5/Lqqj2nXL/VRKGqy4HSE4onA/Oc7XnAtV7lr6pqjaruBPKBcSLSHYhX1RXqafu8dEKdpnMtAC5zWhsTgUWqWqqqZcAivpqwjI97I6eA7glR7XrzjzHm1IgIv77+HCYMTOGnf9/Ekq1Fp1T/dPso0lR1P4DznOqU9wQKvI4rdMp6Otsnlh9XR1XrgcNAtxbO9RUiMkNEskUku6Sk5DRfkmlvBw5Xszy3hG+N7kloiE3bYYybwkNDePZ7oxnWI56Zf13Dmj1lba7b3p3ZzX0baAvlp1vn+ELVOaqapapZKSkpbQrUdLy/rd1Lo8INYzLcDsUYA3SJDGPurWNJi49i+our27xO9+kmiiLnchLOc7FTXgh4fyukA/uc8vRmyo+rIyJhQAKeS10nO5fxA6rKGzkFjO2TSN/kLm6HY4xxJMdG8tJt4wgRYdrcVRQfqW61zukmioVA0yikacDbXuVTnZFMffF0Wq9yLk9ViMh4p//hlhPqNJ3rBmCp04/xPnCliCQ6ndhXOmXGD6zZU86OkmPcYJ3Yxvic3t268ML3x1J6rJZbX1hNRXVdi8e3ZXjsfGAFMEhECkVkOvBr4AoRyQOucH5GVTcDrwNbgH8BM1W16ZbAu4A/4+ng3g6855Q/D3QTkXzghzgjqFS1FHgUWO08HnHKjB9YkFNIdHgoVw/v4XYoxphmDE/vyrPfG822ogru+suaFo8Vt9dibW9ZWVmanZ3tdhhBraq2gXG/WswVQ9N44saRbodjjGnBG9kFPLhgA7sfuyZHVbOaO8buzDbt7v3NB6ioqeeGLLvsZIyvm5KVwYMTB7V4jCUK0+4W5BSSnhjN+L7d3A7FGNMGd1/cv8X9lihMu9pbXsWn2w9y/eh0QuzeCWP8QmvLE1uiMO3qrZxCVLHRTsYEEEsUpt2oKgvWFPK1ft3ISIpxOxxjTDuxRGHazaqdpew+VGmtCWMCjCUK024W5BQSGxnG1885y+1QjDHtyBKFaRfHaur558b9XH1Od2IibN0JYwKJJQrTLt7duJ/K2ga7d8KYAGSJwrSLBTmF9E3uQpYtd2pMwLFEYc7YnkOVrNxZyg1j0lsdj22M8T+WKMwZW5BTgAhcN6rZdaWMMX7OEoU5I42Nyptr9nLBgGR6dI12OxxjTAewRGHOyIodh9hbXmX3ThgTwAIuUdTUN7odQlBZkFNIXFQYE4fZvRPGBKqASxS5RRXM/WQngbbOhi86Ul3He5v2880RPYgKD3U7HGNMBwm4RBEfFc4j72zhoTc3UlPf0HoFc9r+uWE/1XWNdtnJmAAXcImid7cY7r10AK9lF/C9P63k4NEat0MKWAtyChmQGsvIjK5uh2KM6UABlygAfnTlIH7/nVFs2neYyc98yuZ9h90OKeBsLzlKzu4ypti9E8YEvIBMFADfGNGDN+44j0ZVbpi9gvc27nc7pICyIKeQ0BCxeyeMCQJnlChEZJeIbBSRdSKS7ZQlicgiEclznhO9jn9YRPJFZJuITPQqH+OcJ19EnhbnT1QRiRSR15zylSLS51TiOyc9gbfvOZ/B3eO465U1/G5xLo2N1sl9phoalbfWFDJhYAqp8VFuh2OM6WDt0aK4RFVHqmqW8/NDwBJVzQSWOD8jIkOBqcAwYBLwrIg0DZWZDcwAMp3HJKd8OlCmqgOAJ4HHTjW41Lgo5t8+nm+N7snvFudxz/w1VNbWn9YLNR4f55VQdKSGKdaJbUxQ6IhLT5OBec72POBar/JXVbVGVXcC+cA4EekOxKvqCvWMaX3phDpN51oAXCancUE8KjyUx6eM4KdXDeFfmw4w5Y8r2FtedXqvzrAgp5CuMeFcOiTV7VCMMZ3gTBOFAh+ISI6IzHDK0lR1P4Dz3PRt0hMo8Kpb6JT1dLZPLD+ujqrWA4eBbicGISIzRCRbRLJLSkqaDVREuP2ifjx/61j2HKpk8jOfkLO79NRfcZA7XFnHB1uKuHZkTyLD7N4JY4LBmSaK81V1NPB1YKaIXNTCsc21BLSF8pbqHF+gOkdVs1Q1KyUlpcWALxmUyt9mnkdsZBjfmbOSN7ILWjzeHG/h+r3U1tu9E8YEkzNKFKq6z3kuBv4GjAOKnMtJOM/FzuGFQIZX9XRgn1Oe3kz5cXVEJAxIAM64GTAgNY63Z17AuL5JPLhgA4++s4X6Bpv6oy0W5BQy+Kw4hvWIdzsUY0wnOe1EISJdRCSuaRu4EtgELASmOYdNA952thcCU52RTH3xdFqvci5PVYjIeKf/4ZYT6jSd6wZgqbbT3BwJMeG8+P2x3HpeH57/ZCe3zcvmcFVde5w6YOUWVbC+8DBTsjLs3gljgsiZLG6cBvzN+cIIA/6qqv8SkdXA6yIyHdgDTAFQ1c0i8jqwBagHZqpq0xwbdwEvAtHAe84D4HngZRHJx9OSmHoG8X5FWGgIv/jmMAafFcfP397EVU99zCOTh3HZkLT2/DUB443sAsJChGtH9nA7FGNMJ5JAmzwvKytLs7OzT7lezu4yHnpzA3nFR5k07CxmfXMo3RNsfYUm2w5UcOOcFYzrk8ScW7Jar2CM8SsikuN1m8NxAvbO7FM1pnci/7zvQh6cOIgPtxVz+ePLmPvJThrsBj1W7Sxlyh8/IyI0hP+cNMjtcIwxncwShZeIsBBmXjKARQ9MIKtPEo+8s4XJf/iEDYXlbofmmg82H+Dm51eSHBvJm3edx4DUOLdDMsZ0MksUzejVLYYXvz+WZ747iqIjNVz7h0/5xcLNVFQHV2f3q6v2cOdfchjcPZ4Fd51HRlKM2yEZY1xgieIkRIRrhvdgyY8mcPP43sxbsYvLn1jGuxv3B/yiSKrK75fk8dBbG7kwM4X5t59LUpcIt8MyxrjEEkUr4qPC+eXks/n73eeTHBvJ3a+s4bYXV1NQWul2aB2ioVGZtXAzjy/K5bpRPfnztCxiIs5kcJwxxt9ZomijERldeXvm+fz8mqGs3FnKFU8uY/ZH26kLoBv1auobuHf+Gl5asZsZF/Xj8SkjCA+1j4gxwc6+BU5BWGgI0y/oy+IfTmDCwBQe+9cXXPP0J2Tv8v85oyqq67h17mre3XiAn141hJ9cNYSQELupzhhj91GckcVbipi1cDN7y6s4u2c8lw9J44qhaQztHu9Xdy4XV1Rz69zV5BZV8Nspw7lulM3jZEywaek+CksUZ+hYTT1/+Xw3H2wpYs2eMlShR0IUlw9N4/IhaZzbL8mnZ1nddfAYN89dycGKWmbfNJqLB9nU4cYEI0sUneTg0RqWflHM4i1FfJx3kKq6BmIjw5gwMIXLh6ZyyaBUusb4zuihjYWHufWFVTSqMvfWsYzqldh6JWNMQLJE4YLqugY+zT/I4q1FLN5aTElFDaEhQlbvRK4Y6rlE1btbF9fi+zivhDtfzqFrTAQvTR9H/5RY12IxxrjPEoXLGhuVDXsPs3hLEYu3FvHFgQoAMlNj+Vr/bmQkxpCeGE3PxGh6do0mqUtEh/ZxLFy/jx+9vo7+KbHMu20cabbutTFBzxKFjykorWTx1iIWbSliQ+FhjtYcv4Z3dHgoPbpGkZ4Y8+/kkf7v5xhS4yKPG5FUXdfAkao6yqvqOFxVR3ll03PtV8rLq+pYX1DOuL5J/OmWLBKiwzv75RtjfJAlCh+mqhypqqewvJK9ZVXsLa+isKzq39t7y6soPVZ7XJ3wUCEtPoq6hkYOV9VRXXfyezlEPDcNdo0JJyHa8xiUFsePJw4iKtx3O9mNMZ2rpURht9y6TERIiAknISaBYT0Smj2msraevWVVFJZ/mUD2l1cRGRbqqeskAO9k0DU6goTocOKiwux+CGPMGbFE4QdiIsLITIsjM81mbjXGdD67M9sYY0yLLFEYY4xpkSUKY4wxLfKLRCEik0Rkm4jki8hDbsdjjDHBxOcThYiEAn8Avg4MBb4jIkPdjcoYY4KHzycKYByQr6o7VLUWeBWY7HJMxhgTNPwhUfQECrx+LnTKjDHGdAJ/SBTN3S123O3kIjJDRLJFJLukpKSTwjLGmODgDzfcFQIZXj+nA/u8D1DVOcAcABGpEJFtnReeX0oGDrodhI+z96h19h61zp/eo94n2+EPiWI1kCkifYG9wFTguy0cv+1k85UYDxHJtveoZfYetc7eo9YFynvk84lCVetF5B7gfSAUmKuqm10OyxhjgobPJwoAVX0XeNftOIwxJhj5Q2f2qZrjdgB+wN6j1tl71Dp7j1oXEO9RwK1HYYwxpn0FYovCGGNMO7JEYYwxpkUBlShs8sDWicguEdkoIutExH/WjO1AIjJXRIpFZJNXWZKILBKRPOc50c0Y3XaS9+gXIrLX+SytE5Gr3IzRTSKSISIfishWEdksIj9wygPicxQwicImDzwll6jqyEAY391OXgQmnVD2ELBEVTOBJc7PwexFvvoeATzpfJZGOqMTg1U98CNVHQKMB2Y63z8B8TkKmESBTR5oTpOqLgdKTyieDMxztucB13ZqUD7mJO+RcajqflVd42xXAFvxzEkXEJ+jQEoUNnlg2yjwgYjkiMgMt4PxYWmquh88XwJAqsvx+Kp7RGSDc2nKLy+rtDcR6QOMAlYSIJ+jQEoUrU4eaAA4X1VH47lEN1NELnI7IOO3ZgP9gZHAfuBxd8Nxn4jEAm8C96vqEbfjaS+BlChanTzQgKruc56Lgb/huWRnvqpIRLoDOM/FLsfjc1S1SFUbVLUR+BNB/lkSkXA8SeIVVX3LKQ6Iz1EgJYp/Tx4oIhF4Jg9c6HJMPkVEuohIXNM2cCWwqeVaQWshMM3Znga87WIsPqnpC9BxHUH8WRIRAZ4HtqrqE167AuJzFFB3ZjvD837Hl5MH/srlkHyKiPTD04oAzzxff7X3CERkPnAxnimhi4BZwN+B14FewB5giqoGbWfuSd6ji/FcdlJgF3BH0/X4YCMiFwAfAxuBRqf4J3j6Kfz+cxRQicIYY0z7C6RLT8YYYzqAJQpjjDEtskRhjDGmRZYojDHGtMgShTHGmBZZojABQUQanBlMN4vIehH5oYi0+PkWkT4i8t0z/L2/EJEfn8k5nPPcKiLPnOE57heRmDONxZgTWaIwgaLKmcF0GHAFcBWesf4t6QOcUaLwFc7syfcDp5QoRCSsYyIygcQShQk4zvQkM/BMWCdOy+FjEVnjPM5zDv01cKHTEnmgheOOIyI/ddY9WQwM8irvLyL/ciZc/FhEBjdTd5yIfCYia53nQV67M5z620Rklledm0RklRPnc05SQESOisgjIrIS+CnQA/hQRD5s2u91jhtE5EVn+0URecI57rFWYjIGVNUe9vD7B3C0mbIyIA3PX9lRTlkmkO1sXwy843V8s8edcM4xeO6+jQHigXzgx86+JUCms30usLSZ+vFAmLN9OfCms30rnon1ugHReKbDyAKGAP8Awp3jngVucbYV+LbXuXcByc29J8ANwIvO9ovAO0BoSzHZwx5ND2t2mkDWNKNwOPCMiIwEGoCBJzm+LcddCPxNVSsBRGSh8xwLnAe84Zn2B4DIZuonAPNEJBPPF324175FqnrIOd9bwAV4FsQZA6x2zhvNlxPLNeCZhO50vKGqDW2IyRhLFCYwOfNaNeD5Up2FZ36iEXgut1afpNoDbTyuuXlvQoByVR3ZSmiPAh+q6nXOugUftXBexZPs5qnqw82cq9rry761OKNO2HesjTEZY30UJvCISArwR+AZVVU8fzHvV8902DfjmTQSoAKI86p6suO8LQeuE5FoZybebwCoZ+2BnSIyxYlBRGREM/UTgL3O9q0n7LvCWWM5Gs9KaJ/iuZx1g4ikOudNEpHeJ3npJ76eIhEZ4oz+uu4kdVqLyRhLFCZgRDcNjwUWAx8Av3T2PQtME5HP8VxOavpregNQ7wynfaCF4/5NPctdvgasw3PZ52Ov3d8DpovIemAzzS/F+xvgf0XkU76aiD4BXm46t6pmq+oW4Gd4ViXcACwCutO8OcB7TZ3ZeNZnfgdYiqf/42RaiskYmz3WGGNMy6xFYYwxpkWWKIwxxrTIEoUxxpgWWaIwxhjTIksUxhhjWmSJwhhjTIssURhjjGnR/wcojF04P7cVwgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "frame['horario'] = frame['Data de abertura'].dt.time\n",
    "frame.groupby(frame['Data de abertura'].dt.hour).counter.count().plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2020/9/22 13:30:38\n"
     ]
    }
   ],
   "source": [
    "# Importando o PyEphem, uma biblioteca de calculos astronomicos, afim de determinar a estação do ano.\n",
    "import ephem\n",
    "print(ephem.next_equinox('2020/3/20 03:49:33'))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Separando os atendimentos de 2019\n",
    "\n",
    "Agora vamos separar apenas os atendimentos de 2019 que tenham Latitude e Longitude em arquivos agregados por seu tema."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "frame_2019_geo = frame[frame['Data de abertura'] > '2019-01-01 00:00:00'][frame.Longitude.notna() & frame.Latitude.notna()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Transformando o DataFrame em GeoDataFrame\n",
    "\n",
    "Agora que temos o DataFrame dos atendimentos de 2019 que tem latitude e longitude, podemos criar a informação espacializada com a li GeoPandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\pyproj\\crs.py:77: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method.\n",
      "  return _prepare_from_string(\" \".join(pjargs))\n"
     ]
    }
   ],
   "source": [
    "gdf = geopandas.GeoDataFrame(frame_2019_geo, geometry=geopandas.points_from_xy(frame_2019_geo.Longitude, frame_2019_geo.Latitude)).drop(columns=\"horario\")\n",
    "gdf.crs = {'init': 'epsg:4326', 'no_defs': True}\n",
    "gdf = gdf.to_crs({'init': 'epsg:31983'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Salvando o Arquivo em GeoJson\n",
    "gdf.to_file(\"resultados/atendimentos_SP156_geo_2019.gpkg\", layer='atendimentos_SP156_2019', driver=\"GPKG\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "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>Data de abertura</th>\n",
       "      <th>Canal</th>\n",
       "      <th>Tema</th>\n",
       "      <th>Assunto</th>\n",
       "      <th>Serviço</th>\n",
       "      <th>Logradouro</th>\n",
       "      <th>Número</th>\n",
       "      <th>CEP</th>\n",
       "      <th>Subprefeitura</th>\n",
       "      <th>Distrito</th>\n",
       "      <th>Setor</th>\n",
       "      <th>Quadra</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Data do parecer</th>\n",
       "      <th>Status da solicitação</th>\n",
       "      <th>Órgão</th>\n",
       "      <th>counter</th>\n",
       "      <th>dia_da_semana</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2019-07-01 00:42:41</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Feira Livre</td>\n",
       "      <td>Reclamação de falta de limpeza de ruas após a ...</td>\n",
       "      <td>Rua Ataliba Viêira</td>\n",
       "      <td>842</td>\n",
       "      <td>2.216e+06</td>\n",
       "      <td>VILA MARIA-VILA GUILHERME</td>\n",
       "      <td>VILA MEDEIROS</td>\n",
       "      <td>68</td>\n",
       "      <td>501</td>\n",
       "      <td>-23.489937</td>\n",
       "      <td>-46.583679</td>\n",
       "      <td>2019-07-01 11:12:32</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (338279.679 7401351.609)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2019-07-01 01:40:09</td>\n",
       "      <td>APLICATIVO</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Reparos em asfalto, pontes e viadutos</td>\n",
       "      <td>Tapa-buraco</td>\n",
       "      <td>Alameda Santo Amaro</td>\n",
       "      <td>273</td>\n",
       "      <td>4.745e+06</td>\n",
       "      <td>SANTO AMARO</td>\n",
       "      <td>SANTO AMARO</td>\n",
       "      <td>88</td>\n",
       "      <td>272</td>\n",
       "      <td>-23.656073</td>\n",
       "      <td>-46.706463</td>\n",
       "      <td>2019-07-28 11:42:36</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMSUB</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (325958.079 7382810.000)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2019-07-01 01:41:42</td>\n",
       "      <td>APLICATIVO</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Drenagem de água de chuva</td>\n",
       "      <td>Limpeza de bueiros, boca de lobo e poços de vi...</td>\n",
       "      <td>Rua Maria Almeida do Prado</td>\n",
       "      <td>85</td>\n",
       "      <td>4.74502e+06</td>\n",
       "      <td>SANTO AMARO</td>\n",
       "      <td>SANTO AMARO</td>\n",
       "      <td>88</td>\n",
       "      <td>272</td>\n",
       "      <td>-23.657470</td>\n",
       "      <td>-46.704432</td>\n",
       "      <td>2019-07-01 08:26:10</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (326167.130 7382657.735)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2019-07-01 04:51:57</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Trânsito e Transporte</td>\n",
       "      <td>Reclamação ônibus</td>\n",
       "      <td>Ônibus - Reclamação de intervalo excessivo da ...</td>\n",
       "      <td>Avenida Dezenove de Janeiro</td>\n",
       "      <td>884</td>\n",
       "      <td>3.449e+06</td>\n",
       "      <td>ARICANDUVA-FORMOSA-CARRAO</td>\n",
       "      <td>CARRAO</td>\n",
       "      <td>116</td>\n",
       "      <td>273</td>\n",
       "      <td>-23.558670</td>\n",
       "      <td>-46.522110</td>\n",
       "      <td>2019-07-01 18:51:42</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SPTRANS</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (344648.660 7393808.573)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2019-07-01 05:16:48</td>\n",
       "      <td>APLICATIVO</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Ponto viciado, entulho e caçamba de entulho</td>\n",
       "      <td>Remoção de entulho em via pública</td>\n",
       "      <td>Rua dos Protestantes</td>\n",
       "      <td>173</td>\n",
       "      <td>1.21202e+06</td>\n",
       "      <td>SE</td>\n",
       "      <td>REPUBLICA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-23.535332</td>\n",
       "      <td>-46.637868</td>\n",
       "      <td>2019-07-03 00:49:42</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (332802.395 7396262.689)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2762789</th>\n",
       "      <td>2019-06-30 22:50:22</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Rua e bairro</td>\n",
       "      <td>Reparos em asfalto, pontes e viadutos</td>\n",
       "      <td>Tapa-buraco</td>\n",
       "      <td>Rua Bento Gonçalves</td>\n",
       "      <td>235</td>\n",
       "      <td>3334000</td>\n",
       "      <td>MOOCA</td>\n",
       "      <td>AGUA RASA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-23.553722</td>\n",
       "      <td>-46.571100</td>\n",
       "      <td>2019-07-24 11:35:35</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>SMPR</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (339641.736 7394302.494)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2762793</th>\n",
       "      <td>2019-06-30 22:53:42</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Ponto viciado, entulho e caçamba de entulho</td>\n",
       "      <td>Remoção de entulho em via pública</td>\n",
       "      <td>Rua Professor José Lourenço</td>\n",
       "      <td>915</td>\n",
       "      <td>2977020</td>\n",
       "      <td>PIRITUBA-JARAGUA</td>\n",
       "      <td>PIRITUBA</td>\n",
       "      <td>126</td>\n",
       "      <td>313</td>\n",
       "      <td>-23.467568</td>\n",
       "      <td>-46.713742</td>\n",
       "      <td>2019-07-03 11:36:28</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (324965.907 7403676.356)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2762803</th>\n",
       "      <td>2019-06-30 23:05:23</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Ponto viciado, entulho e caçamba de entulho</td>\n",
       "      <td>Remoção de entulho em via pública</td>\n",
       "      <td>Viaduto Dante Delmanto</td>\n",
       "      <td>1126</td>\n",
       "      <td>4310100</td>\n",
       "      <td>JABAQUARA</td>\n",
       "      <td>JABAQUARA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-23.628850</td>\n",
       "      <td>-46.641316</td>\n",
       "      <td>2019-07-05 12:56:13</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (332569.005 7385902.528)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2762823</th>\n",
       "      <td>2019-06-30 23:40:31</td>\n",
       "      <td>CENTRAL TELEFÔNICA</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Remoção de grandes objetos</td>\n",
       "      <td>Remoção de grandes objetos em vias públicas</td>\n",
       "      <td>Rua Jovino Mouzinho de Pontes</td>\n",
       "      <td>141</td>\n",
       "      <td>5843330</td>\n",
       "      <td>M'BOI MIRIM</td>\n",
       "      <td>JARDIM SAO LUIS</td>\n",
       "      <td>122</td>\n",
       "      <td>75</td>\n",
       "      <td>-23.651227</td>\n",
       "      <td>-46.740997</td>\n",
       "      <td>2019-07-01 17:36:27</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (322428.694 7383304.115)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2762827</th>\n",
       "      <td>2019-06-30 23:44:47</td>\n",
       "      <td>PORTAL ONLINE</td>\n",
       "      <td>Lixo e limpeza</td>\n",
       "      <td>Ponto viciado, entulho e caçamba de entulho</td>\n",
       "      <td>Remoção de entulho em via pública</td>\n",
       "      <td>Rua Adelino José da Silva</td>\n",
       "      <td>30</td>\n",
       "      <td>4812380</td>\n",
       "      <td>CAPELA DO SOCORRO</td>\n",
       "      <td>CIDADE DUTRA</td>\n",
       "      <td>162</td>\n",
       "      <td>138</td>\n",
       "      <td>-23.717155</td>\n",
       "      <td>-46.685239</td>\n",
       "      <td>2019-07-01 07:59:03</td>\n",
       "      <td>FINALIZADA</td>\n",
       "      <td>AMLURB</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (328203.082 7376071.384)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>294507 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Data de abertura               Canal                   Tema  \\\n",
       "id                                                                       \n",
       "9       2019-07-01 00:42:41       PORTAL ONLINE         Lixo e limpeza   \n",
       "25      2019-07-01 01:40:09          APLICATIVO           Rua e bairro   \n",
       "26      2019-07-01 01:41:42          APLICATIVO           Rua e bairro   \n",
       "35      2019-07-01 04:51:57  CENTRAL TELEFÔNICA  Trânsito e Transporte   \n",
       "37      2019-07-01 05:16:48          APLICATIVO         Lixo e limpeza   \n",
       "...                     ...                 ...                    ...   \n",
       "2762789 2019-06-30 22:50:22       PORTAL ONLINE           Rua e bairro   \n",
       "2762793 2019-06-30 22:53:42  CENTRAL TELEFÔNICA         Lixo e limpeza   \n",
       "2762803 2019-06-30 23:05:23       PORTAL ONLINE         Lixo e limpeza   \n",
       "2762823 2019-06-30 23:40:31  CENTRAL TELEFÔNICA         Lixo e limpeza   \n",
       "2762827 2019-06-30 23:44:47       PORTAL ONLINE         Lixo e limpeza   \n",
       "\n",
       "                                             Assunto  \\\n",
       "id                                                     \n",
       "9                                        Feira Livre   \n",
       "25             Reparos em asfalto, pontes e viadutos   \n",
       "26                         Drenagem de água de chuva   \n",
       "35                                 Reclamação ônibus   \n",
       "37       Ponto viciado, entulho e caçamba de entulho   \n",
       "...                                              ...   \n",
       "2762789        Reparos em asfalto, pontes e viadutos   \n",
       "2762793  Ponto viciado, entulho e caçamba de entulho   \n",
       "2762803  Ponto viciado, entulho e caçamba de entulho   \n",
       "2762823                   Remoção de grandes objetos   \n",
       "2762827  Ponto viciado, entulho e caçamba de entulho   \n",
       "\n",
       "                                                   Serviço  \\\n",
       "id                                                           \n",
       "9        Reclamação de falta de limpeza de ruas após a ...   \n",
       "25                                             Tapa-buraco   \n",
       "26       Limpeza de bueiros, boca de lobo e poços de vi...   \n",
       "35       Ônibus - Reclamação de intervalo excessivo da ...   \n",
       "37                       Remoção de entulho em via pública   \n",
       "...                                                    ...   \n",
       "2762789                                        Tapa-buraco   \n",
       "2762793                  Remoção de entulho em via pública   \n",
       "2762803                  Remoção de entulho em via pública   \n",
       "2762823        Remoção de grandes objetos em vias públicas   \n",
       "2762827                  Remoção de entulho em via pública   \n",
       "\n",
       "                            Logradouro Número          CEP  \\\n",
       "id                                                           \n",
       "9                   Rua Ataliba Viêira    842    2.216e+06   \n",
       "25                 Alameda Santo Amaro    273    4.745e+06   \n",
       "26          Rua Maria Almeida do Prado     85  4.74502e+06   \n",
       "35         Avenida Dezenove de Janeiro    884    3.449e+06   \n",
       "37                Rua dos Protestantes    173  1.21202e+06   \n",
       "...                                ...    ...          ...   \n",
       "2762789            Rua Bento Gonçalves    235      3334000   \n",
       "2762793    Rua Professor José Lourenço    915      2977020   \n",
       "2762803         Viaduto Dante Delmanto   1126      4310100   \n",
       "2762823  Rua Jovino Mouzinho de Pontes    141      5843330   \n",
       "2762827      Rua Adelino José da Silva     30      4812380   \n",
       "\n",
       "                     Subprefeitura         Distrito Setor Quadra   Latitude  \\\n",
       "id                                                                            \n",
       "9        VILA MARIA-VILA GUILHERME    VILA MEDEIROS    68    501 -23.489937   \n",
       "25                     SANTO AMARO      SANTO AMARO    88    272 -23.656073   \n",
       "26                     SANTO AMARO      SANTO AMARO    88    272 -23.657470   \n",
       "35       ARICANDUVA-FORMOSA-CARRAO           CARRAO   116    273 -23.558670   \n",
       "37                              SE        REPUBLICA   NaN    NaN -23.535332   \n",
       "...                            ...              ...   ...    ...        ...   \n",
       "2762789                      MOOCA        AGUA RASA   NaN    NaN -23.553722   \n",
       "2762793           PIRITUBA-JARAGUA         PIRITUBA   126    313 -23.467568   \n",
       "2762803                  JABAQUARA        JABAQUARA   NaN    NaN -23.628850   \n",
       "2762823                M'BOI MIRIM  JARDIM SAO LUIS   122     75 -23.651227   \n",
       "2762827          CAPELA DO SOCORRO     CIDADE DUTRA   162    138 -23.717155   \n",
       "\n",
       "         Longitude     Data do parecer Status da solicitação    Órgão  \\\n",
       "id                                                                      \n",
       "9       -46.583679 2019-07-01 11:12:32            FINALIZADA   AMLURB   \n",
       "25      -46.706463 2019-07-28 11:42:36            FINALIZADA    SMSUB   \n",
       "26      -46.704432 2019-07-01 08:26:10            FINALIZADA   AMLURB   \n",
       "35      -46.522110 2019-07-01 18:51:42            FINALIZADA  SPTRANS   \n",
       "37      -46.637868 2019-07-03 00:49:42            FINALIZADA   AMLURB   \n",
       "...            ...                 ...                   ...      ...   \n",
       "2762789 -46.571100 2019-07-24 11:35:35            FINALIZADA     SMPR   \n",
       "2762793 -46.713742 2019-07-03 11:36:28            FINALIZADA   AMLURB   \n",
       "2762803 -46.641316 2019-07-05 12:56:13            FINALIZADA   AMLURB   \n",
       "2762823 -46.740997 2019-07-01 17:36:27            FINALIZADA   AMLURB   \n",
       "2762827 -46.685239 2019-07-01 07:59:03            FINALIZADA   AMLURB   \n",
       "\n",
       "         counter  dia_da_semana                        geometry  \n",
       "id                                                               \n",
       "9              1              0  POINT (338279.679 7401351.609)  \n",
       "25             1              0  POINT (325958.079 7382810.000)  \n",
       "26             1              0  POINT (326167.130 7382657.735)  \n",
       "35             1              0  POINT (344648.660 7393808.573)  \n",
       "37             1              0  POINT (332802.395 7396262.689)  \n",
       "...          ...            ...                             ...  \n",
       "2762789        1              6  POINT (339641.736 7394302.494)  \n",
       "2762793        1              6  POINT (324965.907 7403676.356)  \n",
       "2762803        1              6  POINT (332569.005 7385902.528)  \n",
       "2762823        1              6  POINT (322428.694 7383304.115)  \n",
       "2762827        1              6  POINT (328203.082 7376071.384)  \n",
       "\n",
       "[294507 rows x 20 columns]"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Trantando pontos fora dos limites do município de São Paulo\n",
    "\n",
    "Existem casos em que os pontos estão localizados fora dos limites do município de São Paulo e para finalidade de estudo vamos quantifica-los e discriminá-los para estudos posteriores."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [],
   "source": [
    "msp = geopandas.read_file('arquivos/SP.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\geopandas\\tools\\sjoin.py:61: UserWarning: CRS of frames being joined does not match!({'init': 'epsg:31983'} != {'proj': 'utm', 'zone': 23, 'south': True, 'ellps': 'GRS80', 'units': 'm', 'no_defs': True})\n",
      "  \"(%s != %s)\" % (left_df.crs, right_df.crs)\n"
     ]
    }
   ],
   "source": [
    "gdf_sp = geopandas.sjoin(gdf, msp, how='left', op='within')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf_sp[gdf_sp.municipio.isna()].to_file(\"resultados/fora_dos_limites.gpkg\", layer='fora_dos_limites', driver=\"GPKG\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Salvando as camadas de tema\n",
    "\n",
    "Vamos organizar inicialmente esses dados por camadas de acordo com o tema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Tema\n",
       "Animais                    4015\n",
       "Lixo e limpeza           113220\n",
       "Rua e bairro             158998\n",
       "Trânsito e Transporte     18274\n",
       "Name: Tema, dtype: int64"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Determinando os temas\n",
    "gdf_sp.groupby('Tema').Tema.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\D877341\\AppData\\Local\\Continuum\\miniconda3\\lib\\site-packages\\geopandas\\geodataframe.py:557: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  result = super(GeoDataFrame, self).__getitem__(key)\n"
     ]
    }
   ],
   "source": [
    "# salvando uma camada por tema dentro do arquivo gpkg\n",
    "\n",
    "for index, row in gdf_sp.groupby('Tema').agg({'Tema': 'unique'}).iterrows():\n",
    "    #print(row['Tema'][0])\n",
    "    gdf_sp[gdf_sp.municipio.notna()][gdf_sp.Tema == row['Tema'][0]].to_file(\"resultados/temas_SP156_2019.gpkg\", layer=row['Tema'][0], driver=\"GPKG\")"
   ]
  }
 ],
 "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.9.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}