06-Cap02-Analisando-Dados-Cidades-Digitais.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <font color='blue'>Data Science Academy</font>\n",
    "# <font color='blue'>Big Data Real-Time Analytics com Python e Spark</font>\n",
    "\n",
    "# <font color='blue'>Capítulo 2</font>\n",
    "\n",
    "# <font color='blue'>Exercício</font>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dados obtidos do Portal Brasileiro de Dados Abertos:\n",
    "http://dados.gov.br/dataset/cidades-digitais\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "O projeto Cidades Digitais foi planejado para modernizar a gestão e ampliar o acesso ao serviço público, bem como promover o desenvolvimento dos municípios brasileiros através da tecnologia."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Group By e Reshape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.groupby.html"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "https://pandas.pydata.org/pandas-docs/stable/user_guide/reshaping.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "cidadesDigitais = pd.read_csv('cidades_digitais.csv', sep = ';', encoding = 'latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>UF</th>\n",
       "      <th>CIDADE</th>\n",
       "      <th>IBGE</th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AC</td>\n",
       "      <td>Tarauacá</td>\n",
       "      <td>1200609</td>\n",
       "      <td>38819</td>\n",
       "      <td>484.547,53</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>Delmiro Gouveia</td>\n",
       "      <td>2702405</td>\n",
       "      <td>51997</td>\n",
       "      <td>1.169.381,70</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>Estrela de Alagoas</td>\n",
       "      <td>2702553</td>\n",
       "      <td>18306</td>\n",
       "      <td>527.206,83</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AM</td>\n",
       "      <td>Autazes</td>\n",
       "      <td>1300300</td>\n",
       "      <td>37033</td>\n",
       "      <td>1.171.151,92</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AM</td>\n",
       "      <td>Benjamin Constant</td>\n",
       "      <td>1300607</td>\n",
       "      <td>39484</td>\n",
       "      <td>844.586,48</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   UF              CIDADE     IBGE  POPULAÇÃO VALOR_TOTAL_PREVISTO  \\\n",
       "0  AC            Tarauacá  1200609      38819           484.547,53   \n",
       "1  AL     Delmiro Gouveia  2702405      51997         1.169.381,70   \n",
       "2  AL  Estrela de Alagoas  2702553      18306           527.206,83   \n",
       "3  AM             Autazes  1300300      37033         1.171.151,92   \n",
       "4  AM   Benjamin Constant  1300607      39484           844.586,48   \n",
       "\n",
       "         STATUS  PONTOS_ATENDIDOS VALOR_INVESTIDO  \n",
       "0  Sem Previsão                 8               0  \n",
       "1  Sem Previsão                43               0  \n",
       "2  Sem Previsão                39               0  \n",
       "3  Sem Previsão                51               0  \n",
       "4  Sem Previsão                12               0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesDigitais.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UF                      338\n",
       "CIDADE                  338\n",
       "IBGE                    338\n",
       "POPULAÇÃO               338\n",
       "VALOR_TOTAL_PREVISTO    338\n",
       "STATUS                  338\n",
       "PONTOS_ATENDIDOS        338\n",
       "VALOR_INVESTIDO         338\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesDigitais.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "del cidadesDigitais['IBGE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Aplicando Group By\n",
    "cidadesUF_1 = cidadesDigitais.groupby('UF')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.groupby.groupby.DataFrameGroupBy"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(cidadesUF_1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'AC': Int64Index([0], dtype='int64'),\n",
       " 'AL': Int64Index([1, 2], dtype='int64'),\n",
       " 'AM': Int64Index([3, 4, 5, 6, 7, 8, 9, 10, 11], dtype='int64'),\n",
       " 'AP': Int64Index([12, 13, 14, 15, 16, 17], dtype='int64'),\n",
       " 'BA': Int64Index([18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34,\n",
       "             35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50],\n",
       "            dtype='int64'),\n",
       " 'CE': Int64Index([51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67,\n",
       "             68, 69, 70, 71, 72, 73, 74, 75, 76],\n",
       "            dtype='int64'),\n",
       " 'DF': Int64Index([77], dtype='int64'),\n",
       " 'ES': Int64Index([78, 79, 80, 81], dtype='int64'),\n",
       " 'GO': Int64Index([82, 83, 84, 85, 86, 87, 88, 89, 90, 91], dtype='int64'),\n",
       " 'MA': Int64Index([ 92,  93,  94,  95,  96,  97,  98,  99, 100, 101, 102, 103, 104,\n",
       "             105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117],\n",
       "            dtype='int64'),\n",
       " 'MG': Int64Index([118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130,\n",
       "             131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143,\n",
       "             144, 145],\n",
       "            dtype='int64'),\n",
       " 'MS': Int64Index([146, 147, 148], dtype='int64'),\n",
       " 'MT': Int64Index([149, 150, 151, 152], dtype='int64'),\n",
       " 'PA': Int64Index([153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165,\n",
       "             166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176],\n",
       "            dtype='int64'),\n",
       " 'PB': Int64Index([177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189,\n",
       "             190, 191, 192, 193, 194],\n",
       "            dtype='int64'),\n",
       " 'PE': Int64Index([195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207,\n",
       "             208, 209, 210],\n",
       "            dtype='int64'),\n",
       " 'PI': Int64Index([211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223,\n",
       "             224, 225, 226, 227, 228],\n",
       "            dtype='int64'),\n",
       " 'PR': Int64Index([229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241,\n",
       "             242, 243, 244, 245],\n",
       "            dtype='int64'),\n",
       " 'RJ': Int64Index([246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258,\n",
       "             259, 260],\n",
       "            dtype='int64'),\n",
       " 'RN': Int64Index([261, 262, 263, 264, 265, 266, 267, 268, 269], dtype='int64'),\n",
       " 'RO': Int64Index([270, 271], dtype='int64'),\n",
       " 'RR': Int64Index([272], dtype='int64'),\n",
       " 'RS': Int64Index([273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285,\n",
       "             286, 287, 288],\n",
       "            dtype='int64'),\n",
       " 'SC': Int64Index([289, 290, 291, 292, 293, 294], dtype='int64'),\n",
       " 'SE': Int64Index([295, 296, 297, 298], dtype='int64'),\n",
       " 'SP': Int64Index([299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311,\n",
       "             312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324,\n",
       "             325, 326, 327, 328, 329, 330, 331, 332, 333],\n",
       "            dtype='int64'),\n",
       " 'TO': Int64Index([334, 335, 336, 337], dtype='int64')}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesUF_1.groups"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Número de grupos\n",
    "len(cidadesUF_1.groups)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "ordenaUF = cidadesUF_1.size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UF\n",
       "SP    35\n",
       "BA    33\n",
       "MG    28\n",
       "MA    26\n",
       "CE    26\n",
       "PA    24\n",
       "PI    18\n",
       "PB    18\n",
       "PR    17\n",
       "PE    16\n",
       "RS    16\n",
       "RJ    15\n",
       "GO    10\n",
       "RN     9\n",
       "AM     9\n",
       "AP     6\n",
       "SC     6\n",
       "ES     4\n",
       "TO     4\n",
       "MT     4\n",
       "SE     4\n",
       "MS     3\n",
       "RO     2\n",
       "AL     2\n",
       "DF     1\n",
       "RR     1\n",
       "AC     1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Ordena os grupos por ordem decrescente\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "cidadesUF_2 = cidadesDigitais.groupby(['UF','STATUS'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UF  STATUS      \n",
       "AC  Sem Previsão     1\n",
       "AL  Sem Previsão     2\n",
       "AM  Concluída        3\n",
       "    Sem Previsão     6\n",
       "AP  Concluída        1\n",
       "    Sem Previsão     5\n",
       "BA  Concluída        9\n",
       "    Sem Previsão    24\n",
       "CE  Concluída       11\n",
       "    Sem Previsão    15\n",
       "DF  Concluída        1\n",
       "ES  Sem Previsão     4\n",
       "GO  Sem Previsão    10\n",
       "MA  Concluída        1\n",
       "    Sem Previsão    25\n",
       "MG  Concluída        2\n",
       "    Em andamento     1\n",
       "    Sem Previsão    25\n",
       "MS  Sem Previsão     3\n",
       "MT  Sem Previsão     4\n",
       "PA  Concluída        9\n",
       "    Sem Previsão    15\n",
       "PB  Concluída        6\n",
       "    Em andamento     3\n",
       "    Sem Previsão     9\n",
       "PE  Concluída        1\n",
       "    Sem Previsão    15\n",
       "PI  Concluída        3\n",
       "    Sem Previsão    15\n",
       "PR  Concluída        7\n",
       "    Em andamento     1\n",
       "    Sem Previsão     9\n",
       "RJ  Concluída        1\n",
       "    Em andamento     2\n",
       "    Sem Previsão    12\n",
       "RN  Concluída        1\n",
       "    Sem Previsão     8\n",
       "RO  Sem Previsão     2\n",
       "RR  Sem Previsão     1\n",
       "RS  Concluída        4\n",
       "    Em andamento     2\n",
       "    Sem Previsão    10\n",
       "SC  Concluída        1\n",
       "    Sem Previsão     5\n",
       "SE  Sem Previsão     4\n",
       "SP  Concluída        8\n",
       "    Em andamento     2\n",
       "    Sem Previsão    25\n",
       "TO  Sem Previsão     4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Total agrupado\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>UF</th>\n",
       "      <th>CIDADE</th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AC</td>\n",
       "      <td>Tarauacá</td>\n",
       "      <td>38819</td>\n",
       "      <td>484.547,53</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>Delmiro Gouveia</td>\n",
       "      <td>51997</td>\n",
       "      <td>1.169.381,70</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>Estrela de Alagoas</td>\n",
       "      <td>18306</td>\n",
       "      <td>527.206,83</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AM</td>\n",
       "      <td>Autazes</td>\n",
       "      <td>37033</td>\n",
       "      <td>1.171.151,92</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AM</td>\n",
       "      <td>Benjamin Constant</td>\n",
       "      <td>39484</td>\n",
       "      <td>844.586,48</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   UF              CIDADE  POPULAÇÃO VALOR_TOTAL_PREVISTO        STATUS  \\\n",
       "0  AC            Tarauacá      38819           484.547,53  Sem Previsão   \n",
       "1  AL     Delmiro Gouveia      51997         1.169.381,70  Sem Previsão   \n",
       "2  AL  Estrela de Alagoas      18306           527.206,83  Sem Previsão   \n",
       "3  AM             Autazes      37033         1.171.151,92  Sem Previsão   \n",
       "4  AM   Benjamin Constant      39484           844.586,48  Sem Previsão   \n",
       "\n",
       "   PONTOS_ATENDIDOS VALOR_INVESTIDO  \n",
       "0                 8               0  \n",
       "1                43               0  \n",
       "2                39               0  \n",
       "3                51               0  \n",
       "4                12               0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesDigitais.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "cidadesUF_3 = cidadesDigitais.set_index('STATUS')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Aplicando Group By\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UF</th>\n",
       "      <th>CIDADE</th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATUS</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>Sem Previsão</th>\n",
       "      <td>AC</td>\n",
       "      <td>Tarauacá</td>\n",
       "      <td>38819</td>\n",
       "      <td>484.547,53</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>AL</td>\n",
       "      <td>Delmiro Gouveia</td>\n",
       "      <td>51997</td>\n",
       "      <td>1.169.381,70</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>AL</td>\n",
       "      <td>Estrela de Alagoas</td>\n",
       "      <td>18306</td>\n",
       "      <td>527.206,83</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>AM</td>\n",
       "      <td>Autazes</td>\n",
       "      <td>37033</td>\n",
       "      <td>1.171.151,92</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>AM</td>\n",
       "      <td>Benjamin Constant</td>\n",
       "      <td>39484</td>\n",
       "      <td>844.586,48</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <td>AM</td>\n",
       "      <td>Coari</td>\n",
       "      <td>83078</td>\n",
       "      <td>814.954,75</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <td>AM</td>\n",
       "      <td>Manacapuru</td>\n",
       "      <td>94175</td>\n",
       "      <td>892.096,87</td>\n",
       "      <td>31</td>\n",
       "      <td>763.009,30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <td>AM</td>\n",
       "      <td>Manaquiri</td>\n",
       "      <td>28413</td>\n",
       "      <td>636.682,15</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <td>AP</td>\n",
       "      <td>Serra do Navio</td>\n",
       "      <td>4938</td>\n",
       "      <td>590.073,15</td>\n",
       "      <td>21</td>\n",
       "      <td>495.899,00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <td>BA</td>\n",
       "      <td>Guanambi</td>\n",
       "      <td>85797</td>\n",
       "      <td>533.416,18</td>\n",
       "      <td>15</td>\n",
       "      <td>441.985,58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>MG</td>\n",
       "      <td>Nepomuceno</td>\n",
       "      <td>26897</td>\n",
       "      <td>650.576,00</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>PB</td>\n",
       "      <td>Cabaceiras</td>\n",
       "      <td>5449</td>\n",
       "      <td>355.867,86</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>PB</td>\n",
       "      <td>Esperança</td>\n",
       "      <td>32785</td>\n",
       "      <td>643.482,51</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>PB</td>\n",
       "      <td>Itaporanga</td>\n",
       "      <td>24499</td>\n",
       "      <td>649.011,44</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>PR</td>\n",
       "      <td>Bandeirantes</td>\n",
       "      <td>32639</td>\n",
       "      <td>279.409,70</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              UF              CIDADE  POPULAÇÃO VALOR_TOTAL_PREVISTO  \\\n",
       "STATUS                                                                 \n",
       "Sem Previsão  AC            Tarauacá      38819           484.547,53   \n",
       "Sem Previsão  AL     Delmiro Gouveia      51997         1.169.381,70   \n",
       "Sem Previsão  AL  Estrela de Alagoas      18306           527.206,83   \n",
       "Sem Previsão  AM             Autazes      37033         1.171.151,92   \n",
       "Sem Previsão  AM   Benjamin Constant      39484           844.586,48   \n",
       "Concluída     AM               Coari      83078           814.954,75   \n",
       "Concluída     AM          Manacapuru      94175           892.096,87   \n",
       "Concluída     AM           Manaquiri      28413           636.682,15   \n",
       "Concluída     AP      Serra do Navio       4938           590.073,15   \n",
       "Concluída     BA            Guanambi      85797           533.416,18   \n",
       "Em andamento  MG          Nepomuceno      26897           650.576,00   \n",
       "Em andamento  PB          Cabaceiras       5449           355.867,86   \n",
       "Em andamento  PB           Esperança      32785           643.482,51   \n",
       "Em andamento  PB          Itaporanga      24499           649.011,44   \n",
       "Em andamento  PR        Bandeirantes      32639           279.409,70   \n",
       "\n",
       "              PONTOS_ATENDIDOS VALOR_INVESTIDO  \n",
       "STATUS                                          \n",
       "Sem Previsão                 8               0  \n",
       "Sem Previsão                43               0  \n",
       "Sem Previsão                39               0  \n",
       "Sem Previsão                51               0  \n",
       "Sem Previsão                12               0  \n",
       "Concluída                   27               0  \n",
       "Concluída                   31      763.009,30  \n",
       "Concluída                   21               0  \n",
       "Concluída                   21      495.899,00  \n",
       "Concluída                   15      441.985,58  \n",
       "Em andamento                27               0  \n",
       "Em andamento                15               0  \n",
       "Em andamento                23               0  \n",
       "Em andamento                23               0  \n",
       "Em andamento                 7               0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesUF_3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>CIDADE</th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATUS</th>\n",
       "      <th>UF</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 rowspan=\"6\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>AC</th>\n",
       "      <td>Tarauacá</td>\n",
       "      <td>38819</td>\n",
       "      <td>484.547,53</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <td>Delmiro Gouveia</td>\n",
       "      <td>51997</td>\n",
       "      <td>1.169.381,70</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <td>Estrela de Alagoas</td>\n",
       "      <td>18306</td>\n",
       "      <td>527.206,83</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AM</th>\n",
       "      <td>Autazes</td>\n",
       "      <td>37033</td>\n",
       "      <td>1.171.151,92</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AM</th>\n",
       "      <td>Benjamin Constant</td>\n",
       "      <td>39484</td>\n",
       "      <td>844.586,48</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AM</th>\n",
       "      <td>Careiro</td>\n",
       "      <td>36435</td>\n",
       "      <td>748.797,08</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>AM</th>\n",
       "      <td>Coari</td>\n",
       "      <td>83078</td>\n",
       "      <td>814.954,75</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>AM</th>\n",
       "      <td>Codajás</td>\n",
       "      <td>26777</td>\n",
       "      <td>757.706,74</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AM</th>\n",
       "      <td>Iranduba</td>\n",
       "      <td>45984</td>\n",
       "      <td>800.655,02</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Concluída</th>\n",
       "      <th>AM</th>\n",
       "      <td>Manacapuru</td>\n",
       "      <td>94175</td>\n",
       "      <td>892.096,87</td>\n",
       "      <td>31</td>\n",
       "      <td>763.009,30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AM</th>\n",
       "      <td>Manaquiri</td>\n",
       "      <td>28413</td>\n",
       "      <td>636.682,15</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>AM</th>\n",
       "      <td>Maraã</td>\n",
       "      <td>18423</td>\n",
       "      <td>427.516,78</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AP</th>\n",
       "      <td>Amapá</td>\n",
       "      <td>8622</td>\n",
       "      <td>459.240,58</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AP</th>\n",
       "      <td>Laranjal do Jari</td>\n",
       "      <td>45712</td>\n",
       "      <td>896.578,06</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AP</th>\n",
       "      <td>Mazagão</td>\n",
       "      <td>19571</td>\n",
       "      <td>594.149,70</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AP</th>\n",
       "      <td>Porto Grande</td>\n",
       "      <td>19669</td>\n",
       "      <td>800.403,50</td>\n",
       "      <td>22</td>\n",
       "      <td>96.748,00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>AP</th>\n",
       "      <td>Serra do Navio</td>\n",
       "      <td>4938</td>\n",
       "      <td>590.073,15</td>\n",
       "      <td>21</td>\n",
       "      <td>495.899,00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"13\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>AP</th>\n",
       "      <td>Vitória do Jari</td>\n",
       "      <td>14364</td>\n",
       "      <td>687.756,22</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Abaré</td>\n",
       "      <td>19574</td>\n",
       "      <td>490.227,43</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Anagé</td>\n",
       "      <td>20096</td>\n",
       "      <td>510.328,56</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Anguera</td>\n",
       "      <td>11299</td>\n",
       "      <td>441.915,04</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Baianópolis</td>\n",
       "      <td>14195</td>\n",
       "      <td>499.499,12</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Barra</td>\n",
       "      <td>54188</td>\n",
       "      <td>1.210.503,86</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Barra do Choça</td>\n",
       "      <td>34853</td>\n",
       "      <td>747.990,32</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Boa Vista do Tupim</td>\n",
       "      <td>18658</td>\n",
       "      <td>548.582,05</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Bom Jesus da Serra</td>\n",
       "      <td>10554</td>\n",
       "      <td>413.597,59</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Brejolândia</td>\n",
       "      <td>10698</td>\n",
       "      <td>437.370,14</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Buritirama</td>\n",
       "      <td>21549</td>\n",
       "      <td>486.364,54</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Coronel João Sá</td>\n",
       "      <td>17098</td>\n",
       "      <td>623.361,08</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>Cotegipe</td>\n",
       "      <td>14403</td>\n",
       "      <td>687.927,70</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>SP</th>\n",
       "      <td>Guararapes</td>\n",
       "      <td>32346</td>\n",
       "      <td>831.691,60</td>\n",
       "      <td>26</td>\n",
       "      <td>772.690,54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>SP</th>\n",
       "      <td>Guareí</td>\n",
       "      <td>16867</td>\n",
       "      <td>505.817,04</td>\n",
       "      <td>18</td>\n",
       "      <td>50.581,71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Ibaté</td>\n",
       "      <td>33535</td>\n",
       "      <td>1.584.846,88</td>\n",
       "      <td>34</td>\n",
       "      <td>162.167,00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Ituverava</td>\n",
       "      <td>40994</td>\n",
       "      <td>1.448.262,92</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Jales</td>\n",
       "      <td>48922</td>\n",
       "      <td>1.705.825,26</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Jarinu</td>\n",
       "      <td>27473</td>\n",
       "      <td>1.277.621,82</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>SP</th>\n",
       "      <td>Lourdes</td>\n",
       "      <td>2249</td>\n",
       "      <td>438.445,29</td>\n",
       "      <td>15</td>\n",
       "      <td>354.671,92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>SP</th>\n",
       "      <td>Louveira</td>\n",
       "      <td>43862</td>\n",
       "      <td>1.204.519,24</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Mairinque</td>\n",
       "      <td>46015</td>\n",
       "      <td>1.390.757,84</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Miracatu</td>\n",
       "      <td>20533</td>\n",
       "      <td>652.792,68</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Mirante do Paranapanema</td>\n",
       "      <td>17979</td>\n",
       "      <td>610.647,24</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Orlândia</td>\n",
       "      <td>42678</td>\n",
       "      <td>1.595.135,44</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Pederneiras</td>\n",
       "      <td>44910</td>\n",
       "      <td>1.516.904,64</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Concluída</th>\n",
       "      <th>SP</th>\n",
       "      <td>Penápolis</td>\n",
       "      <td>62071</td>\n",
       "      <td>702.701,56</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Presidente Epitácio</td>\n",
       "      <td>43535</td>\n",
       "      <td>584.153,42</td>\n",
       "      <td>16</td>\n",
       "      <td>245.305,00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>SP</th>\n",
       "      <td>Presidente Venceslau</td>\n",
       "      <td>39407</td>\n",
       "      <td>1.347.227,08</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Promissão</td>\n",
       "      <td>38764</td>\n",
       "      <td>864.957,78</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>SP</th>\n",
       "      <td>Santa Gertrudes</td>\n",
       "      <td>24737</td>\n",
       "      <td>730.256,00</td>\n",
       "      <td>25</td>\n",
       "      <td>674.964,22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>SP</th>\n",
       "      <td>São Joaquim da Barra</td>\n",
       "      <td>50110</td>\n",
       "      <td>1.536.581,60</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>São Manuel</td>\n",
       "      <td>40367</td>\n",
       "      <td>1.119.305,92</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>São Pedro</td>\n",
       "      <td>6216</td>\n",
       "      <td>1.015.248,54</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Serrana</td>\n",
       "      <td>42784</td>\n",
       "      <td>1.199.583,92</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concluída</th>\n",
       "      <th>SP</th>\n",
       "      <td>Socorro</td>\n",
       "      <td>39565</td>\n",
       "      <td>740.416,36</td>\n",
       "      <td>24</td>\n",
       "      <td>711.125,40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>SP</th>\n",
       "      <td>Tietê</td>\n",
       "      <td>40194</td>\n",
       "      <td>1.980.602,66</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Valparaíso</td>\n",
       "      <td>24993</td>\n",
       "      <td>978.516,72</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>Vargem Grande do Sul</td>\n",
       "      <td>41807</td>\n",
       "      <td>1.525.640,54</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <td>Paraíso do Tocantins</td>\n",
       "      <td>49076</td>\n",
       "      <td>1.872.693,90</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <td>Ponte Alta do Bom Jesus</td>\n",
       "      <td>4649</td>\n",
       "      <td>251.266,44</td>\n",
       "      <td>9</td>\n",
       "      <td>23.969,90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <td>Porto Nacional</td>\n",
       "      <td>52182</td>\n",
       "      <td>1.101.168,76</td>\n",
       "      <td>61</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <td>São Miguel do Tocantins</td>\n",
       "      <td>11597</td>\n",
       "      <td>592.549,70</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>338 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  CIDADE  POPULAÇÃO VALOR_TOTAL_PREVISTO  \\\n",
       "STATUS       UF                                                            \n",
       "Sem Previsão AC                 Tarauacá      38819           484.547,53   \n",
       "             AL          Delmiro Gouveia      51997         1.169.381,70   \n",
       "             AL       Estrela de Alagoas      18306           527.206,83   \n",
       "             AM                  Autazes      37033         1.171.151,92   \n",
       "             AM        Benjamin Constant      39484           844.586,48   \n",
       "             AM                  Careiro      36435           748.797,08   \n",
       "Concluída    AM                    Coari      83078           814.954,75   \n",
       "Sem Previsão AM                  Codajás      26777           757.706,74   \n",
       "             AM                 Iranduba      45984           800.655,02   \n",
       "Concluída    AM               Manacapuru      94175           892.096,87   \n",
       "             AM                Manaquiri      28413           636.682,15   \n",
       "Sem Previsão AM                    Maraã      18423           427.516,78   \n",
       "             AP                    Amapá       8622           459.240,58   \n",
       "             AP         Laranjal do Jari      45712           896.578,06   \n",
       "             AP                  Mazagão      19571           594.149,70   \n",
       "             AP             Porto Grande      19669           800.403,50   \n",
       "Concluída    AP           Serra do Navio       4938           590.073,15   \n",
       "Sem Previsão AP          Vitória do Jari      14364           687.756,22   \n",
       "             BA                    Abaré      19574           490.227,43   \n",
       "             BA                    Anagé      20096           510.328,56   \n",
       "             BA                  Anguera      11299           441.915,04   \n",
       "             BA              Baianópolis      14195           499.499,12   \n",
       "             BA                    Barra      54188         1.210.503,86   \n",
       "             BA           Barra do Choça      34853           747.990,32   \n",
       "             BA       Boa Vista do Tupim      18658           548.582,05   \n",
       "             BA       Bom Jesus da Serra      10554           413.597,59   \n",
       "             BA              Brejolândia      10698           437.370,14   \n",
       "             BA               Buritirama      21549           486.364,54   \n",
       "             BA          Coronel João Sá      17098           623.361,08   \n",
       "             BA                 Cotegipe      14403           687.927,70   \n",
       "...                                  ...        ...                  ...   \n",
       "Concluída    SP               Guararapes      32346           831.691,60   \n",
       "Sem Previsão SP                   Guareí      16867           505.817,04   \n",
       "             SP                    Ibaté      33535         1.584.846,88   \n",
       "             SP                Ituverava      40994         1.448.262,92   \n",
       "             SP                    Jales      48922         1.705.825,26   \n",
       "             SP                   Jarinu      27473         1.277.621,82   \n",
       "Concluída    SP                  Lourdes       2249           438.445,29   \n",
       "Sem Previsão SP                 Louveira      43862         1.204.519,24   \n",
       "             SP                Mairinque      46015         1.390.757,84   \n",
       "             SP                 Miracatu      20533           652.792,68   \n",
       "             SP  Mirante do Paranapanema      17979           610.647,24   \n",
       "             SP                 Orlândia      42678         1.595.135,44   \n",
       "             SP              Pederneiras      44910         1.516.904,64   \n",
       "Concluída    SP                Penápolis      62071           702.701,56   \n",
       "             SP      Presidente Epitácio      43535           584.153,42   \n",
       "Sem Previsão SP     Presidente Venceslau      39407         1.347.227,08   \n",
       "             SP                Promissão      38764           864.957,78   \n",
       "Concluída    SP          Santa Gertrudes      24737           730.256,00   \n",
       "Sem Previsão SP     São Joaquim da Barra      50110         1.536.581,60   \n",
       "             SP               São Manuel      40367         1.119.305,92   \n",
       "             SP                São Pedro       6216         1.015.248,54   \n",
       "             SP                  Serrana      42784         1.199.583,92   \n",
       "Concluída    SP                  Socorro      39565           740.416,36   \n",
       "Sem Previsão SP                    Tietê      40194         1.980.602,66   \n",
       "             SP               Valparaíso      24993           978.516,72   \n",
       "             SP     Vargem Grande do Sul      41807         1.525.640,54   \n",
       "             TO     Paraíso do Tocantins      49076         1.872.693,90   \n",
       "             TO  Ponte Alta do Bom Jesus       4649           251.266,44   \n",
       "             TO           Porto Nacional      52182         1.101.168,76   \n",
       "             TO  São Miguel do Tocantins      11597           592.549,70   \n",
       "\n",
       "                 PONTOS_ATENDIDOS VALOR_INVESTIDO  \n",
       "STATUS       UF                                    \n",
       "Sem Previsão AC                 8               0  \n",
       "             AL                43               0  \n",
       "             AL                39               0  \n",
       "             AM                51               0  \n",
       "             AM                12               0  \n",
       "             AM                17               0  \n",
       "Concluída    AM                27               0  \n",
       "Sem Previsão AM                36               0  \n",
       "             AM                30               0  \n",
       "Concluída    AM                31      763.009,30  \n",
       "             AM                21               0  \n",
       "Sem Previsão AM                21               0  \n",
       "             AP                15               0  \n",
       "             AP                17               0  \n",
       "             AP                20               0  \n",
       "             AP                22       96.748,00  \n",
       "Concluída    AP                21      495.899,00  \n",
       "Sem Previsão AP                 7               0  \n",
       "             BA                23               0  \n",
       "             BA                15               0  \n",
       "             BA                20               0  \n",
       "             BA                24               0  \n",
       "             BA                46               0  \n",
       "             BA                23               0  \n",
       "             BA                28               0  \n",
       "             BA                16               0  \n",
       "             BA                17               0  \n",
       "             BA                20               0  \n",
       "             BA                27               0  \n",
       "             BA                36               0  \n",
       "...                           ...             ...  \n",
       "Concluída    SP                26      772.690,54  \n",
       "Sem Previsão SP                18       50.581,71  \n",
       "             SP                34      162.167,00  \n",
       "             SP                28               0  \n",
       "             SP                42               0  \n",
       "             SP                28               0  \n",
       "Concluída    SP                15      354.671,92  \n",
       "Sem Previsão SP                17               0  \n",
       "             SP                23               0  \n",
       "             SP                17               0  \n",
       "             SP                24               0  \n",
       "             SP                58               0  \n",
       "             SP                51               0  \n",
       "Concluída    SP                21               0  \n",
       "             SP                16      245.305,00  \n",
       "Sem Previsão SP                42               0  \n",
       "             SP                30               0  \n",
       "Concluída    SP                25      674.964,22  \n",
       "Sem Previsão SP                22               0  \n",
       "             SP                26               0  \n",
       "             SP                10               0  \n",
       "             SP                47               0  \n",
       "Concluída    SP                24      711.125,40  \n",
       "Sem Previsão SP                44               0  \n",
       "             SP                23               0  \n",
       "             SP                47               0  \n",
       "             TO                49               0  \n",
       "             TO                 9       23.969,90  \n",
       "             TO                61               0  \n",
       "             TO                20               0  \n",
       "\n",
       "[338 rows x 5 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesUF_4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UF</th>\n",
       "      <th>STATUS</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AC</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>38819</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>70303</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AM</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>205666</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>204136</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>4938</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>107938</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">BA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>1171174</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>532445</td>\n",
       "      <td>559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>658927</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>427514</td>\n",
       "      <td>370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DF</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>32148</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ES</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>122164</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>166045</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">MA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>174267</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>571514</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">MG</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>18579</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>26897</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>465789</td>\n",
       "      <td>533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>118431</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77241</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>620301</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>470578</td>\n",
       "      <td>435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PB</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>127879</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62733</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>111071</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37317</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>342519</td>\n",
       "      <td>297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PI</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37987</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187556</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PR</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>418078</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>32639</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>284252</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RJ</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>13626</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>167465</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>413049</td>\n",
       "      <td>312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">RN</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>6218</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77814</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>84470</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RR</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>27288</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RS</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>107356</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>40954</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>300041</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SC</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>29008</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187416</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187455</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">SP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>235299</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62857</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>898779</td>\n",
       "      <td>810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>117504</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 POPULAÇÃO  PONTOS_ATENDIDOS\n",
       "UF STATUS                                   \n",
       "AC Sem Previsão      38819                 8\n",
       "AL Sem Previsão      70303                82\n",
       "AM Concluída        205666                79\n",
       "   Sem Previsão     204136               167\n",
       "AP Concluída          4938                21\n",
       "   Sem Previsão     107938                81\n",
       "BA Concluída       1171174               155\n",
       "   Sem Previsão     532445               559\n",
       "CE Concluída        658927               218\n",
       "   Sem Previsão     427514               370\n",
       "DF Concluída         32148                15\n",
       "ES Sem Previsão     122164                94\n",
       "GO Sem Previsão     166045               168\n",
       "MA Concluída        174267                13\n",
       "   Sem Previsão     571514               566\n",
       "MG Concluída         18579                16\n",
       "   Em andamento      26897                27\n",
       "   Sem Previsão     465789               533\n",
       "MS Sem Previsão     118431                94\n",
       "MT Sem Previsão      77241                97\n",
       "PA Concluída        620301               189\n",
       "   Sem Previsão     470578               435\n",
       "PB Concluída        127879                95\n",
       "   Em andamento      62733                61\n",
       "   Sem Previsão     111071               185\n",
       "PE Concluída         37317                14\n",
       "   Sem Previsão     342519               297\n",
       "PI Concluída         37987                45\n",
       "   Sem Previsão     187556               213\n",
       "PR Concluída        418078               134\n",
       "   Em andamento      32639                 7\n",
       "   Sem Previsão     284252               247\n",
       "RJ Concluída         13626                11\n",
       "   Em andamento     167465                35\n",
       "   Sem Previsão     413049               312\n",
       "RN Concluída          6218                13\n",
       "   Sem Previsão      77814               145\n",
       "RO Sem Previsão      84470                39\n",
       "RR Sem Previsão      27288                21\n",
       "RS Concluída        107356                73\n",
       "   Em andamento      40954                30\n",
       "   Sem Previsão     300041               265\n",
       "SC Concluída         29008                18\n",
       "   Sem Previsão     187416                90\n",
       "SE Sem Previsão     187455               107\n",
       "SP Concluída        235299               173\n",
       "   Em andamento      62857                37\n",
       "   Sem Previsão     898779               810\n",
       "TO Sem Previsão     117504               139"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UF</th>\n",
       "      <th>STATUS</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AC</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>38819</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>70303</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AM</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>205666</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>204136</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>4938</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>107938</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">BA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>1171174</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>532445</td>\n",
       "      <td>559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>658927</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>427514</td>\n",
       "      <td>370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DF</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>32148</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ES</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>122164</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>166045</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">MA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>174267</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>571514</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">MG</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>18579</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>26897</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>465789</td>\n",
       "      <td>533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>118431</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77241</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>620301</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>470578</td>\n",
       "      <td>435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PB</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>127879</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62733</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>111071</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37317</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>342519</td>\n",
       "      <td>297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PI</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37987</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187556</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PR</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>418078</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>32639</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>284252</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RJ</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>13626</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>167465</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>413049</td>\n",
       "      <td>312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">RN</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>6218</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77814</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>84470</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RR</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>27288</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RS</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>107356</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>40954</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>300041</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SC</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>29008</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187416</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187455</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">SP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>235299</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62857</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>898779</td>\n",
       "      <td>810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>117504</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 POPULAÇÃO  PONTOS_ATENDIDOS\n",
       "UF STATUS                                   \n",
       "AC Sem Previsão      38819                 8\n",
       "AL Sem Previsão      70303                82\n",
       "AM Concluída        205666                79\n",
       "   Sem Previsão     204136               167\n",
       "AP Concluída          4938                21\n",
       "   Sem Previsão     107938                81\n",
       "BA Concluída       1171174               155\n",
       "   Sem Previsão     532445               559\n",
       "CE Concluída        658927               218\n",
       "   Sem Previsão     427514               370\n",
       "DF Concluída         32148                15\n",
       "ES Sem Previsão     122164                94\n",
       "GO Sem Previsão     166045               168\n",
       "MA Concluída        174267                13\n",
       "   Sem Previsão     571514               566\n",
       "MG Concluída         18579                16\n",
       "   Em andamento      26897                27\n",
       "   Sem Previsão     465789               533\n",
       "MS Sem Previsão     118431                94\n",
       "MT Sem Previsão      77241                97\n",
       "PA Concluída        620301               189\n",
       "   Sem Previsão     470578               435\n",
       "PB Concluída        127879                95\n",
       "   Em andamento      62733                61\n",
       "   Sem Previsão     111071               185\n",
       "PE Concluída         37317                14\n",
       "   Sem Previsão     342519               297\n",
       "PI Concluída         37987                45\n",
       "   Sem Previsão     187556               213\n",
       "PR Concluída        418078               134\n",
       "   Em andamento      32639                 7\n",
       "   Sem Previsão     284252               247\n",
       "RJ Concluída         13626                11\n",
       "   Em andamento     167465                35\n",
       "   Sem Previsão     413049               312\n",
       "RN Concluída          6218                13\n",
       "   Sem Previsão      77814               145\n",
       "RO Sem Previsão      84470                39\n",
       "RR Sem Previsão      27288                21\n",
       "RS Concluída        107356                73\n",
       "   Em andamento      40954                30\n",
       "   Sem Previsão     300041               265\n",
       "SC Concluída         29008                18\n",
       "   Sem Previsão     187416                90\n",
       "SE Sem Previsão     187455               107\n",
       "SP Concluída        235299               173\n",
       "   Em andamento      62857                37\n",
       "   Sem Previsão     898779               810\n",
       "TO Sem Previsão     117504               139"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">POPULAÇÃO</th>\n",
       "      <th colspan=\"3\" halign=\"left\">PONTOS_ATENDIDOS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "      <th>size</th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "      <th>size</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UF</th>\n",
       "      <th>STATUS</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>AC</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>38819</td>\n",
       "      <td>38819.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>70303</td>\n",
       "      <td>35151.500000</td>\n",
       "      <td>2</td>\n",
       "      <td>82</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AM</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>205666</td>\n",
       "      <td>68555.333333</td>\n",
       "      <td>3</td>\n",
       "      <td>79</td>\n",
       "      <td>26.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>204136</td>\n",
       "      <td>34022.666667</td>\n",
       "      <td>6</td>\n",
       "      <td>167</td>\n",
       "      <td>27.833333</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>4938</td>\n",
       "      <td>4938.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>107938</td>\n",
       "      <td>21587.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>81</td>\n",
       "      <td>16.200000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">BA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>1171174</td>\n",
       "      <td>130130.444444</td>\n",
       "      <td>9</td>\n",
       "      <td>155</td>\n",
       "      <td>17.222222</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>532445</td>\n",
       "      <td>22185.208333</td>\n",
       "      <td>24</td>\n",
       "      <td>559</td>\n",
       "      <td>23.291667</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>658927</td>\n",
       "      <td>59902.454545</td>\n",
       "      <td>11</td>\n",
       "      <td>218</td>\n",
       "      <td>19.818182</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>427514</td>\n",
       "      <td>28500.933333</td>\n",
       "      <td>15</td>\n",
       "      <td>370</td>\n",
       "      <td>24.666667</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DF</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>32148</td>\n",
       "      <td>32148.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ES</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>122164</td>\n",
       "      <td>30541.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>94</td>\n",
       "      <td>23.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>166045</td>\n",
       "      <td>16604.500000</td>\n",
       "      <td>10</td>\n",
       "      <td>168</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">MA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>174267</td>\n",
       "      <td>174267.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>571514</td>\n",
       "      <td>22860.560000</td>\n",
       "      <td>25</td>\n",
       "      <td>566</td>\n",
       "      <td>22.640000</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">MG</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>18579</td>\n",
       "      <td>9289.500000</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>26897</td>\n",
       "      <td>26897.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>465789</td>\n",
       "      <td>18631.560000</td>\n",
       "      <td>25</td>\n",
       "      <td>533</td>\n",
       "      <td>21.320000</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>118431</td>\n",
       "      <td>39477.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>94</td>\n",
       "      <td>31.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77241</td>\n",
       "      <td>19310.250000</td>\n",
       "      <td>4</td>\n",
       "      <td>97</td>\n",
       "      <td>24.250000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PA</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>620301</td>\n",
       "      <td>68922.333333</td>\n",
       "      <td>9</td>\n",
       "      <td>189</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>470578</td>\n",
       "      <td>31371.866667</td>\n",
       "      <td>15</td>\n",
       "      <td>435</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PB</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>127879</td>\n",
       "      <td>21313.166667</td>\n",
       "      <td>6</td>\n",
       "      <td>95</td>\n",
       "      <td>15.833333</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62733</td>\n",
       "      <td>20911.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>61</td>\n",
       "      <td>20.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>111071</td>\n",
       "      <td>12341.222222</td>\n",
       "      <td>9</td>\n",
       "      <td>185</td>\n",
       "      <td>20.555556</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PE</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37317</td>\n",
       "      <td>37317.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>342519</td>\n",
       "      <td>22834.600000</td>\n",
       "      <td>15</td>\n",
       "      <td>297</td>\n",
       "      <td>19.800000</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PI</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>37987</td>\n",
       "      <td>12662.333333</td>\n",
       "      <td>3</td>\n",
       "      <td>45</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187556</td>\n",
       "      <td>12503.733333</td>\n",
       "      <td>15</td>\n",
       "      <td>213</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">PR</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>418078</td>\n",
       "      <td>59725.428571</td>\n",
       "      <td>7</td>\n",
       "      <td>134</td>\n",
       "      <td>19.142857</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>32639</td>\n",
       "      <td>32639.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>284252</td>\n",
       "      <td>31583.555556</td>\n",
       "      <td>9</td>\n",
       "      <td>247</td>\n",
       "      <td>27.444444</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RJ</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>13626</td>\n",
       "      <td>13626.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>167465</td>\n",
       "      <td>83732.500000</td>\n",
       "      <td>2</td>\n",
       "      <td>35</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>413049</td>\n",
       "      <td>34420.750000</td>\n",
       "      <td>12</td>\n",
       "      <td>312</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">RN</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>6218</td>\n",
       "      <td>6218.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>77814</td>\n",
       "      <td>9726.750000</td>\n",
       "      <td>8</td>\n",
       "      <td>145</td>\n",
       "      <td>18.125000</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>84470</td>\n",
       "      <td>42235.000000</td>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>19.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RR</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>27288</td>\n",
       "      <td>27288.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">RS</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>107356</td>\n",
       "      <td>26839.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>73</td>\n",
       "      <td>18.250000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>40954</td>\n",
       "      <td>20477.000000</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>300041</td>\n",
       "      <td>30004.100000</td>\n",
       "      <td>10</td>\n",
       "      <td>265</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SC</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>29008</td>\n",
       "      <td>29008.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187416</td>\n",
       "      <td>37483.200000</td>\n",
       "      <td>5</td>\n",
       "      <td>90</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>187455</td>\n",
       "      <td>46863.750000</td>\n",
       "      <td>4</td>\n",
       "      <td>107</td>\n",
       "      <td>26.750000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">SP</th>\n",
       "      <th>Concluída</th>\n",
       "      <td>235299</td>\n",
       "      <td>29412.375000</td>\n",
       "      <td>8</td>\n",
       "      <td>173</td>\n",
       "      <td>21.625000</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Em andamento</th>\n",
       "      <td>62857</td>\n",
       "      <td>31428.500000</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>898779</td>\n",
       "      <td>35951.160000</td>\n",
       "      <td>25</td>\n",
       "      <td>810</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TO</th>\n",
       "      <th>Sem Previsão</th>\n",
       "      <td>117504</td>\n",
       "      <td>29376.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>139</td>\n",
       "      <td>34.750000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                POPULAÇÃO                     PONTOS_ATENDIDOS                \n",
       "                      sum           mean size              sum       mean size\n",
       "UF STATUS                                                                     \n",
       "AC Sem Previsão     38819   38819.000000    1                8   8.000000    1\n",
       "AL Sem Previsão     70303   35151.500000    2               82  41.000000    2\n",
       "AM Concluída       205666   68555.333333    3               79  26.333333    3\n",
       "   Sem Previsão    204136   34022.666667    6              167  27.833333    6\n",
       "AP Concluída         4938    4938.000000    1               21  21.000000    1\n",
       "   Sem Previsão    107938   21587.600000    5               81  16.200000    5\n",
       "BA Concluída      1171174  130130.444444    9              155  17.222222    9\n",
       "   Sem Previsão    532445   22185.208333   24              559  23.291667   24\n",
       "CE Concluída       658927   59902.454545   11              218  19.818182   11\n",
       "   Sem Previsão    427514   28500.933333   15              370  24.666667   15\n",
       "DF Concluída        32148   32148.000000    1               15  15.000000    1\n",
       "ES Sem Previsão    122164   30541.000000    4               94  23.500000    4\n",
       "GO Sem Previsão    166045   16604.500000   10              168  16.800000   10\n",
       "MA Concluída       174267  174267.000000    1               13  13.000000    1\n",
       "   Sem Previsão    571514   22860.560000   25              566  22.640000   25\n",
       "MG Concluída        18579    9289.500000    2               16   8.000000    2\n",
       "   Em andamento     26897   26897.000000    1               27  27.000000    1\n",
       "   Sem Previsão    465789   18631.560000   25              533  21.320000   25\n",
       "MS Sem Previsão    118431   39477.000000    3               94  31.333333    3\n",
       "MT Sem Previsão     77241   19310.250000    4               97  24.250000    4\n",
       "PA Concluída       620301   68922.333333    9              189  21.000000    9\n",
       "   Sem Previsão    470578   31371.866667   15              435  29.000000   15\n",
       "PB Concluída       127879   21313.166667    6               95  15.833333    6\n",
       "   Em andamento     62733   20911.000000    3               61  20.333333    3\n",
       "   Sem Previsão    111071   12341.222222    9              185  20.555556    9\n",
       "PE Concluída        37317   37317.000000    1               14  14.000000    1\n",
       "   Sem Previsão    342519   22834.600000   15              297  19.800000   15\n",
       "PI Concluída        37987   12662.333333    3               45  15.000000    3\n",
       "   Sem Previsão    187556   12503.733333   15              213  14.200000   15\n",
       "PR Concluída       418078   59725.428571    7              134  19.142857    7\n",
       "   Em andamento     32639   32639.000000    1                7   7.000000    1\n",
       "   Sem Previsão    284252   31583.555556    9              247  27.444444    9\n",
       "RJ Concluída        13626   13626.000000    1               11  11.000000    1\n",
       "   Em andamento    167465   83732.500000    2               35  17.500000    2\n",
       "   Sem Previsão    413049   34420.750000   12              312  26.000000   12\n",
       "RN Concluída         6218    6218.000000    1               13  13.000000    1\n",
       "   Sem Previsão     77814    9726.750000    8              145  18.125000    8\n",
       "RO Sem Previsão     84470   42235.000000    2               39  19.500000    2\n",
       "RR Sem Previsão     27288   27288.000000    1               21  21.000000    1\n",
       "RS Concluída       107356   26839.000000    4               73  18.250000    4\n",
       "   Em andamento     40954   20477.000000    2               30  15.000000    2\n",
       "   Sem Previsão    300041   30004.100000   10              265  26.500000   10\n",
       "SC Concluída        29008   29008.000000    1               18  18.000000    1\n",
       "   Sem Previsão    187416   37483.200000    5               90  18.000000    5\n",
       "SE Sem Previsão    187455   46863.750000    4              107  26.750000    4\n",
       "SP Concluída       235299   29412.375000    8              173  21.625000    8\n",
       "   Em andamento     62857   31428.500000    2               37  18.500000    2\n",
       "   Sem Previsão    898779   35951.160000   25              810  32.400000   25\n",
       "TO Sem Previsão    117504   29376.000000    4              139  34.750000    4"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>UF</th>\n",
       "      <th>CIDADE</th>\n",
       "      <th>POPULAÇÃO</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>PONTOS_ATENDIDOS</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AC</td>\n",
       "      <td>Tarauacá</td>\n",
       "      <td>38819</td>\n",
       "      <td>484.547,53</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>Delmiro Gouveia</td>\n",
       "      <td>51997</td>\n",
       "      <td>1.169.381,70</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>Estrela de Alagoas</td>\n",
       "      <td>18306</td>\n",
       "      <td>527.206,83</td>\n",
       "      <td>Sem Previsão</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   UF              CIDADE  POPULAÇÃO VALOR_TOTAL_PREVISTO        STATUS  \\\n",
       "0  AC            Tarauacá      38819           484.547,53  Sem Previsão   \n",
       "1  AL     Delmiro Gouveia      51997         1.169.381,70  Sem Previsão   \n",
       "2  AL  Estrela de Alagoas      18306           527.206,83  Sem Previsão   \n",
       "\n",
       "   PONTOS_ATENDIDOS VALOR_INVESTIDO  \n",
       "0                 8               0  \n",
       "1                43               0  \n",
       "2                39               0  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cidadesDigitais.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>UF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATUS</th>\n",
       "      <th>VALOR_TOTAL_PREVISTO</th>\n",
       "      <th>VALOR_INVESTIDO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Concluída</th>\n",
       "      <th>1.023.839,75</th>\n",
       "      <th>836.808,10</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1.024.440,40</th>\n",
       "      <th>958.295,60</th>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">234.752,50</th>\n",
       "      <th>189.134,16</th>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621.943,90</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266.802,12</th>\n",
       "      <th>206.113,40</th>\n",
       "      <td>PB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270.085,77</th>\n",
       "      <th>204.232,98</th>\n",
       "      <td>PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285.842,80</th>\n",
       "      <th>240.879,90</th>\n",
       "      <td>MG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290.426,96</th>\n",
       "      <th>288.464,55</th>\n",
       "      <td>MG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324.598,35</th>\n",
       "      <th>0</th>\n",
       "      <td>PI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330.262,76</th>\n",
       "      <th>268.250,96</th>\n",
       "      <td>BA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335.161,32</th>\n",
       "      <th>260.844,47</th>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352.575,00</th>\n",
       "      <th>0</th>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411.047,68</th>\n",
       "      <th>139.501,10</th>\n",
       "      <td>RN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414.096,87</th>\n",
       "      <th>370.584,00</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419.387,54</th>\n",
       "      <th>364.650,70</th>\n",
       "      <td>PB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421.957,11</th>\n",
       "      <th>397.718,72</th>\n",
       "      <td>DF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424.830,85</th>\n",
       "      <th>130.558,10</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428.579,50</th>\n",
       "      <th>377.463,70</th>\n",
       "      <td>PB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433.787,98</th>\n",
       "      <th>377.520,78</th>\n",
       "      <td>BA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438.445,29</th>\n",
       "      <th>354.671,92</th>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451.846,00</th>\n",
       "      <th>431.175,00</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464.730,35</th>\n",
       "      <th>422.459,60</th>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465.564,00</th>\n",
       "      <th>378.125,50</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466.649,65</th>\n",
       "      <th>393.175,34</th>\n",
       "      <td>PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467.642,09</th>\n",
       "      <th>404.337,86</th>\n",
       "      <td>BA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485.264,10</th>\n",
       "      <th>410.386,30</th>\n",
       "      <td>PE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499.010,00</th>\n",
       "      <th>0</th>\n",
       "      <td>PI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509.908,95</th>\n",
       "      <th>191.140,00</th>\n",
       "      <td>PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521.961,00</th>\n",
       "      <th>487.065,00</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522.826,11</th>\n",
       "      <th>242.272,00</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Sem Previsão</th>\n",
       "      <th>864.957,78</th>\n",
       "      <th>0</th>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>866.711,44</th>\n",
       "      <th>0</th>\n",
       "      <td>MG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>871.581,16</th>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876.496,87</th>\n",
       "      <th>79.990,00</th>\n",
       "      <td>GO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876.774,62</th>\n",
       "      <th>0</th>\n",
       "      <td>PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880.570,72</th>\n",
       "      <th>0</th>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884.532,58</th>\n",
       "      <th>0</th>\n",
       "      <td>MG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>885.670,15</th>\n",
       "      <th>0</th>\n",
       "      <td>GO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896.578,06</th>\n",
       "      <th>0</th>\n",
       "      <td>AP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900.614,38</th>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906.494,09</th>\n",
       "      <th>0</th>\n",
       "      <td>GO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907.385,17</th>\n",
       "      <th>83.271,50</th>\n",
       "      <td>SE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907.753,83</th>\n",
       "      <th>0</th>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910.778,44</th>\n",
       "      <th>75.213,50</th>\n",
       "      <td>PE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911.062,16</th>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916.825,30</th>\n",
       "      <th>0</th>\n",
       "      <td>PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918.477,20</th>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918.552,72</th>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918.594,72</th>\n",
       "      <th>75.012,00</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920.152,72</th>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928.283,68</th>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932.719,89</th>\n",
       "      <th>93.271,99</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935.119,68</th>\n",
       "      <th>0</th>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935.412,72</th>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944.073,64</th>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945.054,68</th>\n",
       "      <th>78.965,00</th>\n",
       "      <td>PI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945.609,08</th>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978.516,72</th>\n",
       "      <th>0</th>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982.422,53</th>\n",
       "      <th>0</th>\n",
       "      <td>CE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998.180,59</th>\n",
       "      <th>0</th>\n",
       "      <td>ES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>333 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   UF\n",
       "STATUS       VALOR_TOTAL_PREVISTO VALOR_INVESTIDO    \n",
       "Concluída    1.023.839,75         836.808,10       PA\n",
       "             1.024.440,40         958.295,60       RS\n",
       "             234.752,50           189.134,16       RS\n",
       "                                  621.943,90       CE\n",
       "             266.802,12           206.113,40       PB\n",
       "             270.085,77           204.232,98       PR\n",
       "             285.842,80           240.879,90       MG\n",
       "             290.426,96           288.464,55       MG\n",
       "             324.598,35           0                PI\n",
       "             330.262,76           268.250,96       BA\n",
       "             335.161,32           260.844,47       SP\n",
       "             352.575,00           0                RJ\n",
       "             411.047,68           139.501,10       RN\n",
       "             414.096,87           370.584,00       CE\n",
       "             419.387,54           364.650,70       PB\n",
       "             421.957,11           397.718,72       DF\n",
       "             424.830,85           130.558,10       PA\n",
       "             428.579,50           377.463,70       PB\n",
       "             433.787,98           377.520,78       BA\n",
       "             438.445,29           354.671,92       SP\n",
       "             451.846,00           431.175,00       CE\n",
       "             464.730,35           422.459,60       RS\n",
       "             465.564,00           378.125,50       CE\n",
       "             466.649,65           393.175,34       PR\n",
       "             467.642,09           404.337,86       BA\n",
       "             485.264,10           410.386,30       PE\n",
       "             499.010,00           0                PI\n",
       "             509.908,95           191.140,00       PR\n",
       "             521.961,00           487.065,00       CE\n",
       "             522.826,11           242.272,00       PA\n",
       "...                                                ..\n",
       "Sem Previsão 864.957,78           0                SP\n",
       "             866.711,44           0                MG\n",
       "             871.581,16           0                MA\n",
       "             876.496,87           79.990,00        GO\n",
       "             876.774,62           0                PR\n",
       "             880.570,72           0                RS\n",
       "             884.532,58           0                MG\n",
       "             885.670,15           0                GO\n",
       "             896.578,06           0                AP\n",
       "             900.614,38           0                MA\n",
       "             906.494,09           0                GO\n",
       "             907.385,17           83.271,50        SE\n",
       "             907.753,83           0                RJ\n",
       "             910.778,44           75.213,50        PE\n",
       "             911.062,16           0                PA\n",
       "             916.825,30           0                PR\n",
       "             918.477,20           0                PA\n",
       "             918.552,72           0                PA\n",
       "             918.594,72           75.012,00        MA\n",
       "             920.152,72           0                PA\n",
       "             928.283,68           0                MA\n",
       "             932.719,89           93.271,99        CE\n",
       "             935.119,68           0                SP\n",
       "             935.412,72           0                MA\n",
       "             944.073,64           0                PA\n",
       "             945.054,68           78.965,00        PI\n",
       "             945.609,08           0                MA\n",
       "             978.516,72           0                SP\n",
       "             982.422,53           0                CE\n",
       "             998.180,59           0                ES\n",
       "\n",
       "[333 rows x 1 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Fim"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Obrigado - Data Science Academy - <a href=\"http://facebook.com/dsacademybr\">facebook.com/dsacademybr</a>"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}