0-2018-11-12-bf-municipios-brasileiros-tse.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from io import BytesIO\n",
    "from urllib.request import urlopen\n",
    "from zipfile import ZipFile\n",
    "\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Primeiramente, carrego a lista de municípios do tse direto do site oficial"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1570</td>\n",
       "      <td>AC</td>\n",
       "      <td>ASSIS BRASIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1058</td>\n",
       "      <td>AC</td>\n",
       "      <td>BRASILÉIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1007</td>\n",
       "      <td>AC</td>\n",
       "      <td>BUJARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1015</td>\n",
       "      <td>AC</td>\n",
       "      <td>CAPIXABA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CÓDIGO  UF          NOME\n",
       "0    1120  AC    ACRELÂNDIA\n",
       "1    1570  AC  ASSIS BRASIL\n",
       "2    1058  AC     BRASILÉIA\n",
       "3    1007  AC        BUJARI\n",
       "4    1015  AC      CAPIXABA"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_ = 'http://www.tse.jus.br/arquivos/tse-lista-de-municipios-do-cadastro-da-justica-eleitoral/at_download/file'\n",
    "\n",
    "with urlopen(_) as _:\n",
    "    _ = BytesIO(_.read())\n",
    "\n",
    "with ZipFile(_) as _:\n",
    "    with _.open('lista_municipios_justica_eleitoral.txt') as _:\n",
    "        municipios_tse = pd.read_csv(_, encoding='latin1', sep=';')\n",
    "\n",
    "municipios_tse.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### E a lista de múnicipios do ibge, através do repositório git@github:kelvins/Municipios-Brasileiros"
   ]
  },
  {
   "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>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5200050</td>\n",
       "      <td>Abadia de Goiás</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>0</td>\n",
       "      <td>-16.75730</td>\n",
       "      <td>-49.4412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3100104</td>\n",
       "      <td>Abadia dos Dourados</td>\n",
       "      <td>31</td>\n",
       "      <td>MG</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>0</td>\n",
       "      <td>-18.48310</td>\n",
       "      <td>-47.3916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5200100</td>\n",
       "      <td>Abadiânia</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>0</td>\n",
       "      <td>-16.19700</td>\n",
       "      <td>-48.7057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3100203</td>\n",
       "      <td>Abaeté</td>\n",
       "      <td>31</td>\n",
       "      <td>MG</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>0</td>\n",
       "      <td>-19.15510</td>\n",
       "      <td>-45.4444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1500107</td>\n",
       "      <td>Abaetetuba</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.72183</td>\n",
       "      <td>-48.8788</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ibge       nome_municipio  codigo_uf  uf        estado  capital  \\\n",
       "0      5200050      Abadia de Goiás         52  GO         Goiás        0   \n",
       "1      3100104  Abadia dos Dourados         31  MG  Minas Gerais        0   \n",
       "2      5200100            Abadiânia         52  GO         Goiás        0   \n",
       "3      3100203               Abaeté         31  MG  Minas Gerais        0   \n",
       "4      1500107           Abaetetuba         15  PA          Pará        0   \n",
       "\n",
       "   latitude  longitude  \n",
       "0 -16.75730   -49.4412  \n",
       "1 -18.48310   -47.3916  \n",
       "2 -16.19700   -48.7057  \n",
       "3 -19.15510   -45.4444  \n",
       "4  -1.72183   -48.8788  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_ = 'https://raw.githubusercontent.com/kelvins/Municipios-Brasileiros/8730f8f9f90a47546f08b216484f5c336a1f531a/municipios_brasileiros.csv'\n",
    "\n",
    "municipios_brasileiros = pd.read_csv(_)\n",
    "\n",
    "municipios_brasileiros.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Note que ambas as listas contém o mesmo número de rows, desejávelmente seja uma relação de 1 pra 1 em cada lista"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5570, 5570)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(municipios_tse), len(municipios_brasileiros)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Indexo cada tabela por (uf, municipio), todos em uppercase"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AC, ACRELÂNDIA)</th>\n",
       "      <td>1120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, ASSIS BRASIL)</th>\n",
       "      <td>1570</td>\n",
       "      <td>AC</td>\n",
       "      <td>ASSIS BRASIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BRASILÉIA)</th>\n",
       "      <td>1058</td>\n",
       "      <td>AC</td>\n",
       "      <td>BRASILÉIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BUJARI)</th>\n",
       "      <td>1007</td>\n",
       "      <td>AC</td>\n",
       "      <td>BUJARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, CAPIXABA)</th>\n",
       "      <td>1015</td>\n",
       "      <td>AC</td>\n",
       "      <td>CAPIXABA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    CÓDIGO  UF          NOME\n",
       "(AC, ACRELÂNDIA)      1120  AC    ACRELÂNDIA\n",
       "(AC, ASSIS BRASIL)    1570  AC  ASSIS BRASIL\n",
       "(AC, BRASILÉIA)       1058  AC     BRASILÉIA\n",
       "(AC, BUJARI)          1007  AC        BUJARI\n",
       "(AC, CAPIXABA)        1015  AC      CAPIXABA"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_tse = (\n",
    "    municipios_tse\n",
    "    .set_index(\n",
    "        municipios_tse\n",
    "        [['UF', 'NOME']]\n",
    "        .apply(tuple, axis='columns')\n",
    "    )\n",
    "    .sort_index()\n",
    ")\n",
    "\n",
    "indexed_tse.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AC, ACRELÂNDIA)</th>\n",
       "      <td>1200013</td>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.82581</td>\n",
       "      <td>-66.8972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, ASSIS BRASIL)</th>\n",
       "      <td>1200054</td>\n",
       "      <td>Assis Brasil</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.92980</td>\n",
       "      <td>-69.5738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BRASILÉIA)</th>\n",
       "      <td>1200104</td>\n",
       "      <td>Brasiléia</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.99500</td>\n",
       "      <td>-68.7497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BUJARI)</th>\n",
       "      <td>1200138</td>\n",
       "      <td>Bujari</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.81528</td>\n",
       "      <td>-67.9550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, CAPIXABA)</th>\n",
       "      <td>1200179</td>\n",
       "      <td>Capixaba</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.56600</td>\n",
       "      <td>-67.6860</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    codigo_ibge nome_municipio  codigo_uf  uf estado  capital  \\\n",
       "(AC, ACRELÂNDIA)        1200013     Acrelândia         12  AC   Acre        0   \n",
       "(AC, ASSIS BRASIL)      1200054   Assis Brasil         12  AC   Acre        0   \n",
       "(AC, BRASILÉIA)         1200104      Brasiléia         12  AC   Acre        0   \n",
       "(AC, BUJARI)            1200138         Bujari         12  AC   Acre        0   \n",
       "(AC, CAPIXABA)          1200179       Capixaba         12  AC   Acre        0   \n",
       "\n",
       "                    latitude  longitude  \n",
       "(AC, ACRELÂNDIA)    -9.82581   -66.8972  \n",
       "(AC, ASSIS BRASIL) -10.92980   -69.5738  \n",
       "(AC, BRASILÉIA)    -10.99500   -68.7497  \n",
       "(AC, BUJARI)        -9.81528   -67.9550  \n",
       "(AC, CAPIXABA)     -10.56600   -67.6860  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_ibge = (\n",
    "    municipios_brasileiros\n",
    "    .set_index(\n",
    "        municipios_brasileiros\n",
    "        [['uf', 'nome_municipio']]\n",
    "        .applymap(str.upper)\n",
    "        .apply(tuple, axis='columns')\n",
    "    )\n",
    "    .sort_index()\n",
    ")\n",
    "\n",
    "indexed_ibge.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Tento o join:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "      <th>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AC, ACRELÂNDIA)</th>\n",
       "      <td>1120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELÂNDIA</td>\n",
       "      <td>1200013</td>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.82581</td>\n",
       "      <td>-66.8972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, ASSIS BRASIL)</th>\n",
       "      <td>1570</td>\n",
       "      <td>AC</td>\n",
       "      <td>ASSIS BRASIL</td>\n",
       "      <td>1200054</td>\n",
       "      <td>Assis Brasil</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.92980</td>\n",
       "      <td>-69.5738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BRASILÉIA)</th>\n",
       "      <td>1058</td>\n",
       "      <td>AC</td>\n",
       "      <td>BRASILÉIA</td>\n",
       "      <td>1200104</td>\n",
       "      <td>Brasiléia</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.99500</td>\n",
       "      <td>-68.7497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, BUJARI)</th>\n",
       "      <td>1007</td>\n",
       "      <td>AC</td>\n",
       "      <td>BUJARI</td>\n",
       "      <td>1200138</td>\n",
       "      <td>Bujari</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.81528</td>\n",
       "      <td>-67.9550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(AC, CAPIXABA)</th>\n",
       "      <td>1015</td>\n",
       "      <td>AC</td>\n",
       "      <td>CAPIXABA</td>\n",
       "      <td>1200179</td>\n",
       "      <td>Capixaba</td>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.56600</td>\n",
       "      <td>-67.6860</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    CÓDIGO  UF          NOME  codigo_ibge nome_municipio  \\\n",
       "(AC, ACRELÂNDIA)      1120  AC    ACRELÂNDIA      1200013     Acrelândia   \n",
       "(AC, ASSIS BRASIL)    1570  AC  ASSIS BRASIL      1200054   Assis Brasil   \n",
       "(AC, BRASILÉIA)       1058  AC     BRASILÉIA      1200104      Brasiléia   \n",
       "(AC, BUJARI)          1007  AC        BUJARI      1200138         Bujari   \n",
       "(AC, CAPIXABA)        1015  AC      CAPIXABA      1200179       Capixaba   \n",
       "\n",
       "                    codigo_uf  uf estado  capital  latitude  longitude  \n",
       "(AC, ACRELÂNDIA)           12  AC   Acre        0  -9.82581   -66.8972  \n",
       "(AC, ASSIS BRASIL)         12  AC   Acre        0 -10.92980   -69.5738  \n",
       "(AC, BRASILÉIA)            12  AC   Acre        0 -10.99500   -68.7497  \n",
       "(AC, BUJARI)               12  AC   Acre        0  -9.81528   -67.9550  \n",
       "(AC, CAPIXABA)             12  AC   Acre        0 -10.56600   -67.6860  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "joined = indexed_tse.join(indexed_ibge, how='inner')\n",
    "joined.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ficam faltando:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "52"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(indexed_tse) - len(joined)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Analisando quais são:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, ÁGUA BRANCA DO AMAPARI)</th>\n",
       "      <td>6084</td>\n",
       "      <td>AP</td>\n",
       "      <td>ÁGUA BRANCA DO AMAPARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, ARAÇÁS)</th>\n",
       "      <td>33383</td>\n",
       "      <td>BA</td>\n",
       "      <td>ARAÇÁS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, CAEM)</th>\n",
       "      <td>34010</td>\n",
       "      <td>BA</td>\n",
       "      <td>CAEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, IUIU)</th>\n",
       "      <td>30660</td>\n",
       "      <td>BA</td>\n",
       "      <td>IUIU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, MUQUÉM DO SÃO FRANCISCO)</th>\n",
       "      <td>37460</td>\n",
       "      <td>BA</td>\n",
       "      <td>MUQUÉM DO SÃO FRANCISCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, QUINJINGUE)</th>\n",
       "      <td>38199</td>\n",
       "      <td>BA</td>\n",
       "      <td>QUINJINGUE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTA TEREZINHA)</th>\n",
       "      <td>38695</td>\n",
       "      <td>BA</td>\n",
       "      <td>SANTA TEREZINHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTO ESTEVÃO)</th>\n",
       "      <td>38750</td>\n",
       "      <td>BA</td>\n",
       "      <td>SANTO ESTEVÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(CE, ITAPAGÉ)</th>\n",
       "      <td>14273</td>\n",
       "      <td>CE</td>\n",
       "      <td>ITAPAGÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(ES, ATÍLIO VIVÁCQUA)</th>\n",
       "      <td>56138</td>\n",
       "      <td>ES</td>\n",
       "      <td>ATÍLIO VIVÁCQUA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(GO, ANHANGÜERA)</th>\n",
       "      <td>92231</td>\n",
       "      <td>GO</td>\n",
       "      <td>ANHANGÜERA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, PASSA VINTE)</th>\n",
       "      <td>49557</td>\n",
       "      <td>MG</td>\n",
       "      <td>PASSA VINTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, PINGO D'ÁGUA)</th>\n",
       "      <td>41360</td>\n",
       "      <td>MG</td>\n",
       "      <td>PINGO D'ÁGUA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, SEM PEIXE)</th>\n",
       "      <td>40827</td>\n",
       "      <td>MG</td>\n",
       "      <td>SEM PEIXE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, ELDORADO DOS CARAJÁS)</th>\n",
       "      <td>4120</td>\n",
       "      <td>PA</td>\n",
       "      <td>ELDORADO DOS CARAJÁS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, SANTA ISABEL DO PARÁ)</th>\n",
       "      <td>5290</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA ISABEL DO PARÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, QUIXABA)</th>\n",
       "      <td>21539</td>\n",
       "      <td>PB</td>\n",
       "      <td>QUIXABA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SANTARÉM)</th>\n",
       "      <td>19666</td>\n",
       "      <td>PB</td>\n",
       "      <td>SANTARÉM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SÃO DOMINGOS DE POMBAL)</th>\n",
       "      <td>19429</td>\n",
       "      <td>PB</td>\n",
       "      <td>SÃO DOMINGOS DE POMBAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, BELÉM DE SÃO FRANCISCO)</th>\n",
       "      <td>23310</td>\n",
       "      <td>PE</td>\n",
       "      <td>BELÉM DE SÃO FRANCISCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, IGUARACI)</th>\n",
       "      <td>24376</td>\n",
       "      <td>PE</td>\n",
       "      <td>IGUARACI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SÃO CAITANO)</th>\n",
       "      <td>25615</td>\n",
       "      <td>PE</td>\n",
       "      <td>SÃO CAITANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SÃO VICENTE FERRÉR)</th>\n",
       "      <td>25755</td>\n",
       "      <td>PE</td>\n",
       "      <td>SÃO VICENTE FERRÉR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PI, LUIS CORREIA)</th>\n",
       "      <td>11134</td>\n",
       "      <td>PI</td>\n",
       "      <td>LUIS CORREIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PR, ANTONIO OLINTO)</th>\n",
       "      <td>74233</td>\n",
       "      <td>PR</td>\n",
       "      <td>ANTONIO OLINTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PR, SANTO ANTONIO DO CAIUÁ)</th>\n",
       "      <td>78611</td>\n",
       "      <td>PR</td>\n",
       "      <td>SANTO ANTONIO DO CAIUÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RJ, TRAJANO DE MORAIS)</th>\n",
       "      <td>59170</td>\n",
       "      <td>RJ</td>\n",
       "      <td>TRAJANO DE MORAIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, ASSÚ)</th>\n",
       "      <td>16039</td>\n",
       "      <td>RN</td>\n",
       "      <td>ASSÚ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, BOA SAÚDE)</th>\n",
       "      <td>17035</td>\n",
       "      <td>RN</td>\n",
       "      <td>BOA SAÚDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, CAMPO GRANDE)</th>\n",
       "      <td>16250</td>\n",
       "      <td>RN</td>\n",
       "      <td>CAMPO GRANDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, OLHO D'ÁGUA DO BORGES)</th>\n",
       "      <td>17671</td>\n",
       "      <td>RN</td>\n",
       "      <td>OLHO D'ÁGUA DO BORGES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ALTA FLORESTA DO OESTE)</th>\n",
       "      <td>310</td>\n",
       "      <td>RO</td>\n",
       "      <td>ALTA FLORESTA DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ALVORADA DO OESTE)</th>\n",
       "      <td>337</td>\n",
       "      <td>RO</td>\n",
       "      <td>ALVORADA DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ESPIGÃO DO OESTE)</th>\n",
       "      <td>256</td>\n",
       "      <td>RO</td>\n",
       "      <td>ESPIGÃO DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, MACHADINHO DO OESTE)</th>\n",
       "      <td>396</td>\n",
       "      <td>RO</td>\n",
       "      <td>MACHADINHO DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, NOVA BRASILÂNDIA DO OESTE)</th>\n",
       "      <td>370</td>\n",
       "      <td>RO</td>\n",
       "      <td>NOVA BRASILÂNDIA DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, SANTA LUZIA DO OESTE)</th>\n",
       "      <td>353</td>\n",
       "      <td>RO</td>\n",
       "      <td>SANTA LUZIA DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, SÃO FELIPE DO OESTE)</th>\n",
       "      <td>710</td>\n",
       "      <td>RO</td>\n",
       "      <td>SÃO FELIPE DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RS, SANTANA DO LIVRAMENTO)</th>\n",
       "      <td>88455</td>\n",
       "      <td>RS</td>\n",
       "      <td>SANTANA DO LIVRAMENTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, GRÃO-PARÁ)</th>\n",
       "      <td>81191</td>\n",
       "      <td>SC</td>\n",
       "      <td>GRÃO-PARÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LAURO MÜLLER)</th>\n",
       "      <td>81892</td>\n",
       "      <td>SC</td>\n",
       "      <td>LAURO MÜLLER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LUÍS ALVES)</th>\n",
       "      <td>81973</td>\n",
       "      <td>SC</td>\n",
       "      <td>LUÍS ALVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, PRESIDENTE CASTELO BRANCO)</th>\n",
       "      <td>82732</td>\n",
       "      <td>SC</td>\n",
       "      <td>PRESIDENTE CASTELO BRANCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, SÃO CRISTÓVÃO DO SUL)</th>\n",
       "      <td>80942</td>\n",
       "      <td>SC</td>\n",
       "      <td>SÃO CRISTÓVÃO DO SUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SE, GRACCHO CARDOSO)</th>\n",
       "      <td>31518</td>\n",
       "      <td>SE</td>\n",
       "      <td>GRACCHO CARDOSO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, BIRITIBA MIRIM)</th>\n",
       "      <td>62316</td>\n",
       "      <td>SP</td>\n",
       "      <td>BIRITIBA MIRIM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, FLORÍNEA)</th>\n",
       "      <td>64238</td>\n",
       "      <td>SP</td>\n",
       "      <td>FLORÍNEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, GUAIMBÉ)</th>\n",
       "      <td>64475</td>\n",
       "      <td>SP</td>\n",
       "      <td>GUAIMBÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, ITAOCA)</th>\n",
       "      <td>61603</td>\n",
       "      <td>SP</td>\n",
       "      <td>ITAOCA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, SÃO LUÍS DO PARAITINGA)</th>\n",
       "      <td>71013</td>\n",
       "      <td>SP</td>\n",
       "      <td>SÃO LUÍS DO PARAITINGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, COUTO DE MAGALHÃES)</th>\n",
       "      <td>93211</td>\n",
       "      <td>TO</td>\n",
       "      <td>COUTO DE MAGALHÃES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, SÃO VALÉRIO DA NATIVIDADE)</th>\n",
       "      <td>92681</td>\n",
       "      <td>TO</td>\n",
       "      <td>SÃO VALÉRIO DA NATIVIDADE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 CÓDIGO  UF                       NOME\n",
       "(AP, ÁGUA BRANCA DO AMAPARI)       6084  AP     ÁGUA BRANCA DO AMAPARI\n",
       "(BA, ARAÇÁS)                      33383  BA                     ARAÇÁS\n",
       "(BA, CAEM)                        34010  BA                       CAEM\n",
       "(BA, IUIU)                        30660  BA                       IUIU\n",
       "(BA, MUQUÉM DO SÃO FRANCISCO)     37460  BA    MUQUÉM DO SÃO FRANCISCO\n",
       "(BA, QUINJINGUE)                  38199  BA                 QUINJINGUE\n",
       "(BA, SANTA TEREZINHA)             38695  BA            SANTA TEREZINHA\n",
       "(BA, SANTO ESTEVÃO)               38750  BA              SANTO ESTEVÃO\n",
       "(CE, ITAPAGÉ)                     14273  CE                    ITAPAGÉ\n",
       "(ES, ATÍLIO VIVÁCQUA)             56138  ES            ATÍLIO VIVÁCQUA\n",
       "(GO, ANHANGÜERA)                  92231  GO                 ANHANGÜERA\n",
       "(MG, PASSA VINTE)                 49557  MG                PASSA VINTE\n",
       "(MG, PINGO D'ÁGUA)                41360  MG               PINGO D'ÁGUA\n",
       "(MG, SEM PEIXE)                   40827  MG                  SEM PEIXE\n",
       "(PA, ELDORADO DOS CARAJÁS)         4120  PA       ELDORADO DOS CARAJÁS\n",
       "(PA, SANTA ISABEL DO PARÁ)         5290  PA       SANTA ISABEL DO PARÁ\n",
       "(PB, QUIXABA)                     21539  PB                    QUIXABA\n",
       "(PB, SANTARÉM)                    19666  PB                   SANTARÉM\n",
       "(PB, SÃO DOMINGOS DE POMBAL)      19429  PB     SÃO DOMINGOS DE POMBAL\n",
       "(PE, BELÉM DE SÃO FRANCISCO)      23310  PE     BELÉM DE SÃO FRANCISCO\n",
       "(PE, IGUARACI)                    24376  PE                   IGUARACI\n",
       "(PE, SÃO CAITANO)                 25615  PE                SÃO CAITANO\n",
       "(PE, SÃO VICENTE FERRÉR)          25755  PE         SÃO VICENTE FERRÉR\n",
       "(PI, LUIS CORREIA)                11134  PI               LUIS CORREIA\n",
       "(PR, ANTONIO OLINTO)              74233  PR             ANTONIO OLINTO\n",
       "(PR, SANTO ANTONIO DO CAIUÁ)      78611  PR     SANTO ANTONIO DO CAIUÁ\n",
       "(RJ, TRAJANO DE MORAIS)           59170  RJ          TRAJANO DE MORAIS\n",
       "(RN, ASSÚ)                        16039  RN                       ASSÚ\n",
       "(RN, BOA SAÚDE)                   17035  RN                  BOA SAÚDE\n",
       "(RN, CAMPO GRANDE)                16250  RN               CAMPO GRANDE\n",
       "(RN, OLHO D'ÁGUA DO BORGES)       17671  RN      OLHO D'ÁGUA DO BORGES\n",
       "(RO, ALTA FLORESTA DO OESTE)        310  RO     ALTA FLORESTA DO OESTE\n",
       "(RO, ALVORADA DO OESTE)             337  RO          ALVORADA DO OESTE\n",
       "(RO, ESPIGÃO DO OESTE)              256  RO           ESPIGÃO DO OESTE\n",
       "(RO, MACHADINHO DO OESTE)           396  RO        MACHADINHO DO OESTE\n",
       "(RO, NOVA BRASILÂNDIA DO OESTE)     370  RO  NOVA BRASILÂNDIA DO OESTE\n",
       "(RO, SANTA LUZIA DO OESTE)          353  RO       SANTA LUZIA DO OESTE\n",
       "(RO, SÃO FELIPE DO OESTE)           710  RO        SÃO FELIPE DO OESTE\n",
       "(RS, SANTANA DO LIVRAMENTO)       88455  RS      SANTANA DO LIVRAMENTO\n",
       "(SC, GRÃO-PARÁ)                   81191  SC                  GRÃO-PARÁ\n",
       "(SC, LAURO MÜLLER)                81892  SC               LAURO MÜLLER\n",
       "(SC, LUÍS ALVES)                  81973  SC                 LUÍS ALVES\n",
       "(SC, PRESIDENTE CASTELO BRANCO)   82732  SC  PRESIDENTE CASTELO BRANCO\n",
       "(SC, SÃO CRISTÓVÃO DO SUL)        80942  SC       SÃO CRISTÓVÃO DO SUL\n",
       "(SE, GRACCHO CARDOSO)             31518  SE            GRACCHO CARDOSO\n",
       "(SP, BIRITIBA MIRIM)              62316  SP             BIRITIBA MIRIM\n",
       "(SP, FLORÍNEA)                    64238  SP                   FLORÍNEA\n",
       "(SP, GUAIMBÉ)                     64475  SP                    GUAIMBÉ\n",
       "(SP, ITAOCA)                      61603  SP                     ITAOCA\n",
       "(SP, SÃO LUÍS DO PARAITINGA)      71013  SP     SÃO LUÍS DO PARAITINGA\n",
       "(TO, COUTO DE MAGALHÃES)          93211  TO         COUTO DE MAGALHÃES\n",
       "(TO, SÃO VALÉRIO DA NATIVIDADE)   92681  TO  SÃO VALÉRIO DA NATIVIDADE"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_tse2 = indexed_tse[~indexed_tse.index.isin(joined.index)]\n",
    "indexed_tse2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, PEDRA BRANCA DO AMAPARI)</th>\n",
       "      <td>1600154</td>\n",
       "      <td>Pedra Branca do Amapari</td>\n",
       "      <td>16</td>\n",
       "      <td>AP</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>0</td>\n",
       "      <td>0.777424</td>\n",
       "      <td>-51.9503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, ARAÇAS)</th>\n",
       "      <td>2902054</td>\n",
       "      <td>Araças</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.220000</td>\n",
       "      <td>-38.2027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, CAÉM)</th>\n",
       "      <td>2905107</td>\n",
       "      <td>Caém</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.067700</td>\n",
       "      <td>-40.4320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, IUIÚ)</th>\n",
       "      <td>2917334</td>\n",
       "      <td>Iuiú</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-14.405400</td>\n",
       "      <td>-43.5595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, MUQUÉM DE SÃO FRANCISCO)</th>\n",
       "      <td>2922250</td>\n",
       "      <td>Muquém de São Francisco</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.065000</td>\n",
       "      <td>-43.5497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, QUIJINGUE)</th>\n",
       "      <td>2925907</td>\n",
       "      <td>Quijingue</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.750500</td>\n",
       "      <td>-39.2137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTA TERESINHA)</th>\n",
       "      <td>2928505</td>\n",
       "      <td>Santa Teresinha</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.769700</td>\n",
       "      <td>-39.5215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTO ESTÊVÃO)</th>\n",
       "      <td>2928802</td>\n",
       "      <td>Santo Estêvão</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.428000</td>\n",
       "      <td>-39.2505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(CE, ITAPAJÉ)</th>\n",
       "      <td>2306306</td>\n",
       "      <td>Itapajé</td>\n",
       "      <td>23</td>\n",
       "      <td>CE</td>\n",
       "      <td>Ceará</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.683140</td>\n",
       "      <td>-39.5855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(ES, ATILIO VIVACQUA)</th>\n",
       "      <td>3200706</td>\n",
       "      <td>Atilio Vivacqua</td>\n",
       "      <td>32</td>\n",
       "      <td>ES</td>\n",
       "      <td>Espírito Santo</td>\n",
       "      <td>0</td>\n",
       "      <td>-20.913000</td>\n",
       "      <td>-41.1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(GO, ANHANGUERA)</th>\n",
       "      <td>5201207</td>\n",
       "      <td>Anhanguera</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>0</td>\n",
       "      <td>-18.333900</td>\n",
       "      <td>-48.2204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, PASSA-VINTE)</th>\n",
       "      <td>3147808</td>\n",
       "      <td>Passa-Vinte</td>\n",
       "      <td>31</td>\n",
       "      <td>MG</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.209700</td>\n",
       "      <td>-44.2344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, PINGO-D'ÁGUA)</th>\n",
       "      <td>3150539</td>\n",
       "      <td>Pingo-d'Água</td>\n",
       "      <td>31</td>\n",
       "      <td>MG</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>0</td>\n",
       "      <td>-19.728700</td>\n",
       "      <td>-42.4095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(MG, SEM-PEIXE)</th>\n",
       "      <td>3165560</td>\n",
       "      <td>Sem-Peixe</td>\n",
       "      <td>31</td>\n",
       "      <td>MG</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>0</td>\n",
       "      <td>-20.100800</td>\n",
       "      <td>-42.8483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, ELDORADO DO CARAJÁS)</th>\n",
       "      <td>1502954</td>\n",
       "      <td>Eldorado do Carajás</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.103890</td>\n",
       "      <td>-49.3553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, SANTA IZABEL DO PARÁ)</th>\n",
       "      <td>1506500</td>\n",
       "      <td>Santa Izabel do Pará</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.296860</td>\n",
       "      <td>-48.1606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, JOCA CLAUDINO)</th>\n",
       "      <td>2513653</td>\n",
       "      <td>Joca Claudino</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.483620</td>\n",
       "      <td>-38.4764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, QUIXABÁ)</th>\n",
       "      <td>2512606</td>\n",
       "      <td>Quixabá</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.022400</td>\n",
       "      <td>-37.1458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SÃO DOMINGOS)</th>\n",
       "      <td>2513968</td>\n",
       "      <td>São Domingos</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.803130</td>\n",
       "      <td>-37.9488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, BELÉM DO SÃO FRANCISCO)</th>\n",
       "      <td>2601607</td>\n",
       "      <td>Belém do São Francisco</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.750460</td>\n",
       "      <td>-38.9623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, IGUARACY)</th>\n",
       "      <td>2606903</td>\n",
       "      <td>Iguaracy</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.832220</td>\n",
       "      <td>-37.5082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SÃO CAETANO)</th>\n",
       "      <td>2613107</td>\n",
       "      <td>São Caetano</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.337630</td>\n",
       "      <td>-36.2869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SÃO VICENTE FERRER)</th>\n",
       "      <td>2613800</td>\n",
       "      <td>São Vicente Ferrer</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.589690</td>\n",
       "      <td>-35.4808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PI, LUÍS CORREIA)</th>\n",
       "      <td>2205706</td>\n",
       "      <td>Luís Correia</td>\n",
       "      <td>22</td>\n",
       "      <td>PI</td>\n",
       "      <td>Piauí</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.884380</td>\n",
       "      <td>-41.6641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PR, ANTÔNIO OLINTO)</th>\n",
       "      <td>4101309</td>\n",
       "      <td>Antônio Olinto</td>\n",
       "      <td>41</td>\n",
       "      <td>PR</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>0</td>\n",
       "      <td>-25.980400</td>\n",
       "      <td>-50.1972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PR, SANTO ANTÔNIO DO CAIUÁ)</th>\n",
       "      <td>4124202</td>\n",
       "      <td>Santo Antônio do Caiuá</td>\n",
       "      <td>41</td>\n",
       "      <td>PR</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.735100</td>\n",
       "      <td>-52.3440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RJ, TRAJANO DE MORAES)</th>\n",
       "      <td>3305901</td>\n",
       "      <td>Trajano de Moraes</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.063800</td>\n",
       "      <td>-42.0643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, AUGUSTO SEVERO (CAMPO GRANDE))</th>\n",
       "      <td>2401305</td>\n",
       "      <td>Augusto Severo (Campo Grande)</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.862060</td>\n",
       "      <td>-37.3135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, AÇU)</th>\n",
       "      <td>2400208</td>\n",
       "      <td>Açu</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.583620</td>\n",
       "      <td>-36.9140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, JANUÁRIO CICCO (BOA SAÚDE))</th>\n",
       "      <td>2405306</td>\n",
       "      <td>Januário Cicco (Boa Saúde)</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.165660</td>\n",
       "      <td>-35.6219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, OLHO-D'ÁGUA DO BORGES)</th>\n",
       "      <td>2408409</td>\n",
       "      <td>Olho-d'Água do Borges</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.948600</td>\n",
       "      <td>-37.7047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ALTA FLORESTA D'OESTE)</th>\n",
       "      <td>1100015</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.928300</td>\n",
       "      <td>-61.9953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ALVORADA D'OESTE)</th>\n",
       "      <td>1100346</td>\n",
       "      <td>Alvorada D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.346300</td>\n",
       "      <td>-62.2847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, ESPIGÃO D'OESTE)</th>\n",
       "      <td>1100098</td>\n",
       "      <td>Espigão D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.526600</td>\n",
       "      <td>-61.0252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, MACHADINHO D'OESTE)</th>\n",
       "      <td>1100130</td>\n",
       "      <td>Machadinho D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.443630</td>\n",
       "      <td>-61.9818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, NOVA BRASILÂNDIA D'OESTE)</th>\n",
       "      <td>1100148</td>\n",
       "      <td>Nova Brasilândia D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.724700</td>\n",
       "      <td>-62.3127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, SANTA LUZIA D'OESTE)</th>\n",
       "      <td>1100296</td>\n",
       "      <td>Santa Luzia D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.907400</td>\n",
       "      <td>-61.7777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RO, SÃO FELIPE D'OESTE)</th>\n",
       "      <td>1101484</td>\n",
       "      <td>São Felipe D'Oeste</td>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.902300</td>\n",
       "      <td>-61.5026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RS, SANT'ANA DO LIVRAMENTO)</th>\n",
       "      <td>4317103</td>\n",
       "      <td>Sant'Ana do Livramento</td>\n",
       "      <td>43</td>\n",
       "      <td>RS</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>0</td>\n",
       "      <td>-30.877300</td>\n",
       "      <td>-55.5392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, GRÃO PARÁ)</th>\n",
       "      <td>4206108</td>\n",
       "      <td>Grão Pará</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-28.180900</td>\n",
       "      <td>-49.2252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LAURO MULLER)</th>\n",
       "      <td>4209607</td>\n",
       "      <td>Lauro Muller</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-28.385900</td>\n",
       "      <td>-49.4035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LUIZ ALVES)</th>\n",
       "      <td>4210001</td>\n",
       "      <td>Luiz Alves</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-26.715100</td>\n",
       "      <td>-48.9322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, PRESIDENTE CASTELLO BRANCO)</th>\n",
       "      <td>4213906</td>\n",
       "      <td>Presidente Castello Branco</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-27.221800</td>\n",
       "      <td>-51.8089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, SÃO CRISTOVÃO DO SUL)</th>\n",
       "      <td>4216057</td>\n",
       "      <td>São Cristovão do Sul</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-27.266600</td>\n",
       "      <td>-50.4388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SE, GRACHO CARDOSO)</th>\n",
       "      <td>2802601</td>\n",
       "      <td>Gracho Cardoso</td>\n",
       "      <td>28</td>\n",
       "      <td>SE</td>\n",
       "      <td>Sergipe</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.225200</td>\n",
       "      <td>-37.2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, BIRITIBA-MIRIM)</th>\n",
       "      <td>3506607</td>\n",
       "      <td>Biritiba-Mirim</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.569800</td>\n",
       "      <td>-46.0407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, FLORÍNIA)</th>\n",
       "      <td>3516101</td>\n",
       "      <td>Florínia</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.868000</td>\n",
       "      <td>-50.6814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, GUAIMBÊ)</th>\n",
       "      <td>3517307</td>\n",
       "      <td>Guaimbê</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-21.909100</td>\n",
       "      <td>-49.8986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, ITAÓCA)</th>\n",
       "      <td>3522158</td>\n",
       "      <td>Itaóca</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-24.639300</td>\n",
       "      <td>-48.8413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, SÃO LUIZ DO PARAITINGA)</th>\n",
       "      <td>3550001</td>\n",
       "      <td>São Luiz do Paraitinga</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.222000</td>\n",
       "      <td>-45.3109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, COUTO MAGALHÃES)</th>\n",
       "      <td>1706001</td>\n",
       "      <td>Couto Magalhães</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.284110</td>\n",
       "      <td>-49.2473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, SÃO VALÉRIO)</th>\n",
       "      <td>1720499</td>\n",
       "      <td>São Valério</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.974300</td>\n",
       "      <td>-48.2353</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     codigo_ibge  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)            1600154   \n",
       "(BA, ARAÇAS)                             2902054   \n",
       "(BA, CAÉM)                               2905107   \n",
       "(BA, IUIÚ)                               2917334   \n",
       "(BA, MUQUÉM DE SÃO FRANCISCO)            2922250   \n",
       "(BA, QUIJINGUE)                          2925907   \n",
       "(BA, SANTA TERESINHA)                    2928505   \n",
       "(BA, SANTO ESTÊVÃO)                      2928802   \n",
       "(CE, ITAPAJÉ)                            2306306   \n",
       "(ES, ATILIO VIVACQUA)                    3200706   \n",
       "(GO, ANHANGUERA)                         5201207   \n",
       "(MG, PASSA-VINTE)                        3147808   \n",
       "(MG, PINGO-D'ÁGUA)                       3150539   \n",
       "(MG, SEM-PEIXE)                          3165560   \n",
       "(PA, ELDORADO DO CARAJÁS)                1502954   \n",
       "(PA, SANTA IZABEL DO PARÁ)               1506500   \n",
       "(PB, JOCA CLAUDINO)                      2513653   \n",
       "(PB, QUIXABÁ)                            2512606   \n",
       "(PB, SÃO DOMINGOS)                       2513968   \n",
       "(PE, BELÉM DO SÃO FRANCISCO)             2601607   \n",
       "(PE, IGUARACY)                           2606903   \n",
       "(PE, SÃO CAETANO)                        2613107   \n",
       "(PE, SÃO VICENTE FERRER)                 2613800   \n",
       "(PI, LUÍS CORREIA)                       2205706   \n",
       "(PR, ANTÔNIO OLINTO)                     4101309   \n",
       "(PR, SANTO ANTÔNIO DO CAIUÁ)             4124202   \n",
       "(RJ, TRAJANO DE MORAES)                  3305901   \n",
       "(RN, AUGUSTO SEVERO (CAMPO GRANDE))      2401305   \n",
       "(RN, AÇU)                                2400208   \n",
       "(RN, JANUÁRIO CICCO (BOA SAÚDE))         2405306   \n",
       "(RN, OLHO-D'ÁGUA DO BORGES)              2408409   \n",
       "(RO, ALTA FLORESTA D'OESTE)              1100015   \n",
       "(RO, ALVORADA D'OESTE)                   1100346   \n",
       "(RO, ESPIGÃO D'OESTE)                    1100098   \n",
       "(RO, MACHADINHO D'OESTE)                 1100130   \n",
       "(RO, NOVA BRASILÂNDIA D'OESTE)           1100148   \n",
       "(RO, SANTA LUZIA D'OESTE)                1100296   \n",
       "(RO, SÃO FELIPE D'OESTE)                 1101484   \n",
       "(RS, SANT'ANA DO LIVRAMENTO)             4317103   \n",
       "(SC, GRÃO PARÁ)                          4206108   \n",
       "(SC, LAURO MULLER)                       4209607   \n",
       "(SC, LUIZ ALVES)                         4210001   \n",
       "(SC, PRESIDENTE CASTELLO BRANCO)         4213906   \n",
       "(SC, SÃO CRISTOVÃO DO SUL)               4216057   \n",
       "(SE, GRACHO CARDOSO)                     2802601   \n",
       "(SP, BIRITIBA-MIRIM)                     3506607   \n",
       "(SP, FLORÍNIA)                           3516101   \n",
       "(SP, GUAIMBÊ)                            3517307   \n",
       "(SP, ITAÓCA)                             3522158   \n",
       "(SP, SÃO LUIZ DO PARAITINGA)             3550001   \n",
       "(TO, COUTO MAGALHÃES)                    1706001   \n",
       "(TO, SÃO VALÉRIO)                        1720499   \n",
       "\n",
       "                                                    nome_municipio  codigo_uf  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)              Pedra Branca do Amapari         16   \n",
       "(BA, ARAÇAS)                                                Araças         29   \n",
       "(BA, CAÉM)                                                    Caém         29   \n",
       "(BA, IUIÚ)                                                    Iuiú         29   \n",
       "(BA, MUQUÉM DE SÃO FRANCISCO)              Muquém de São Francisco         29   \n",
       "(BA, QUIJINGUE)                                          Quijingue         29   \n",
       "(BA, SANTA TERESINHA)                              Santa Teresinha         29   \n",
       "(BA, SANTO ESTÊVÃO)                                  Santo Estêvão         29   \n",
       "(CE, ITAPAJÉ)                                              Itapajé         23   \n",
       "(ES, ATILIO VIVACQUA)                              Atilio Vivacqua         32   \n",
       "(GO, ANHANGUERA)                                        Anhanguera         52   \n",
       "(MG, PASSA-VINTE)                                      Passa-Vinte         31   \n",
       "(MG, PINGO-D'ÁGUA)                                    Pingo-d'Água         31   \n",
       "(MG, SEM-PEIXE)                                          Sem-Peixe         31   \n",
       "(PA, ELDORADO DO CARAJÁS)                      Eldorado do Carajás         15   \n",
       "(PA, SANTA IZABEL DO PARÁ)                    Santa Izabel do Pará         15   \n",
       "(PB, JOCA CLAUDINO)                                  Joca Claudino         25   \n",
       "(PB, QUIXABÁ)                                              Quixabá         25   \n",
       "(PB, SÃO DOMINGOS)                                    São Domingos         25   \n",
       "(PE, BELÉM DO SÃO FRANCISCO)                Belém do São Francisco         26   \n",
       "(PE, IGUARACY)                                            Iguaracy         26   \n",
       "(PE, SÃO CAETANO)                                      São Caetano         26   \n",
       "(PE, SÃO VICENTE FERRER)                        São Vicente Ferrer         26   \n",
       "(PI, LUÍS CORREIA)                                    Luís Correia         22   \n",
       "(PR, ANTÔNIO OLINTO)                                Antônio Olinto         41   \n",
       "(PR, SANTO ANTÔNIO DO CAIUÁ)                Santo Antônio do Caiuá         41   \n",
       "(RJ, TRAJANO DE MORAES)                          Trajano de Moraes         33   \n",
       "(RN, AUGUSTO SEVERO (CAMPO GRANDE))  Augusto Severo (Campo Grande)         24   \n",
       "(RN, AÇU)                                                      Açu         24   \n",
       "(RN, JANUÁRIO CICCO (BOA SAÚDE))        Januário Cicco (Boa Saúde)         24   \n",
       "(RN, OLHO-D'ÁGUA DO BORGES)                  Olho-d'Água do Borges         24   \n",
       "(RO, ALTA FLORESTA D'OESTE)                  Alta Floresta D'Oeste         11   \n",
       "(RO, ALVORADA D'OESTE)                            Alvorada D'Oeste         11   \n",
       "(RO, ESPIGÃO D'OESTE)                              Espigão D'Oeste         11   \n",
       "(RO, MACHADINHO D'OESTE)                        Machadinho D'Oeste         11   \n",
       "(RO, NOVA BRASILÂNDIA D'OESTE)            Nova Brasilândia D'Oeste         11   \n",
       "(RO, SANTA LUZIA D'OESTE)                      Santa Luzia D'Oeste         11   \n",
       "(RO, SÃO FELIPE D'OESTE)                        São Felipe D'Oeste         11   \n",
       "(RS, SANT'ANA DO LIVRAMENTO)                Sant'Ana do Livramento         43   \n",
       "(SC, GRÃO PARÁ)                                          Grão Pará         42   \n",
       "(SC, LAURO MULLER)                                    Lauro Muller         42   \n",
       "(SC, LUIZ ALVES)                                        Luiz Alves         42   \n",
       "(SC, PRESIDENTE CASTELLO BRANCO)        Presidente Castello Branco         42   \n",
       "(SC, SÃO CRISTOVÃO DO SUL)                    São Cristovão do Sul         42   \n",
       "(SE, GRACHO CARDOSO)                                Gracho Cardoso         28   \n",
       "(SP, BIRITIBA-MIRIM)                                Biritiba-Mirim         35   \n",
       "(SP, FLORÍNIA)                                            Florínia         35   \n",
       "(SP, GUAIMBÊ)                                              Guaimbê         35   \n",
       "(SP, ITAÓCA)                                                Itaóca         35   \n",
       "(SP, SÃO LUIZ DO PARAITINGA)                São Luiz do Paraitinga         35   \n",
       "(TO, COUTO MAGALHÃES)                              Couto Magalhães         17   \n",
       "(TO, SÃO VALÉRIO)                                      São Valério         17   \n",
       "\n",
       "                                     uf               estado  capital  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)        AP                Amapá        0   \n",
       "(BA, ARAÇAS)                         BA                Bahia        0   \n",
       "(BA, CAÉM)                           BA                Bahia        0   \n",
       "(BA, IUIÚ)                           BA                Bahia        0   \n",
       "(BA, MUQUÉM DE SÃO FRANCISCO)        BA                Bahia        0   \n",
       "(BA, QUIJINGUE)                      BA                Bahia        0   \n",
       "(BA, SANTA TERESINHA)                BA                Bahia        0   \n",
       "(BA, SANTO ESTÊVÃO)                  BA                Bahia        0   \n",
       "(CE, ITAPAJÉ)                        CE                Ceará        0   \n",
       "(ES, ATILIO VIVACQUA)                ES       Espírito Santo        0   \n",
       "(GO, ANHANGUERA)                     GO                Goiás        0   \n",
       "(MG, PASSA-VINTE)                    MG         Minas Gerais        0   \n",
       "(MG, PINGO-D'ÁGUA)                   MG         Minas Gerais        0   \n",
       "(MG, SEM-PEIXE)                      MG         Minas Gerais        0   \n",
       "(PA, ELDORADO DO CARAJÁS)            PA                 Pará        0   \n",
       "(PA, SANTA IZABEL DO PARÁ)           PA                 Pará        0   \n",
       "(PB, JOCA CLAUDINO)                  PB              Paraíba        0   \n",
       "(PB, QUIXABÁ)                        PB              Paraíba        0   \n",
       "(PB, SÃO DOMINGOS)                   PB              Paraíba        0   \n",
       "(PE, BELÉM DO SÃO FRANCISCO)         PE           Pernambuco        0   \n",
       "(PE, IGUARACY)                       PE           Pernambuco        0   \n",
       "(PE, SÃO CAETANO)                    PE           Pernambuco        0   \n",
       "(PE, SÃO VICENTE FERRER)             PE           Pernambuco        0   \n",
       "(PI, LUÍS CORREIA)                   PI                Piauí        0   \n",
       "(PR, ANTÔNIO OLINTO)                 PR               Paraná        0   \n",
       "(PR, SANTO ANTÔNIO DO CAIUÁ)         PR               Paraná        0   \n",
       "(RJ, TRAJANO DE MORAES)              RJ       Rio de Janeiro        0   \n",
       "(RN, AUGUSTO SEVERO (CAMPO GRANDE))  RN  Rio Grande do Norte        0   \n",
       "(RN, AÇU)                            RN  Rio Grande do Norte        0   \n",
       "(RN, JANUÁRIO CICCO (BOA SAÚDE))     RN  Rio Grande do Norte        0   \n",
       "(RN, OLHO-D'ÁGUA DO BORGES)          RN  Rio Grande do Norte        0   \n",
       "(RO, ALTA FLORESTA D'OESTE)          RO             Rondônia        0   \n",
       "(RO, ALVORADA D'OESTE)               RO             Rondônia        0   \n",
       "(RO, ESPIGÃO D'OESTE)                RO             Rondônia        0   \n",
       "(RO, MACHADINHO D'OESTE)             RO             Rondônia        0   \n",
       "(RO, NOVA BRASILÂNDIA D'OESTE)       RO             Rondônia        0   \n",
       "(RO, SANTA LUZIA D'OESTE)            RO             Rondônia        0   \n",
       "(RO, SÃO FELIPE D'OESTE)             RO             Rondônia        0   \n",
       "(RS, SANT'ANA DO LIVRAMENTO)         RS    Rio Grande do Sul        0   \n",
       "(SC, GRÃO PARÁ)                      SC       Santa Catarina        0   \n",
       "(SC, LAURO MULLER)                   SC       Santa Catarina        0   \n",
       "(SC, LUIZ ALVES)                     SC       Santa Catarina        0   \n",
       "(SC, PRESIDENTE CASTELLO BRANCO)     SC       Santa Catarina        0   \n",
       "(SC, SÃO CRISTOVÃO DO SUL)           SC       Santa Catarina        0   \n",
       "(SE, GRACHO CARDOSO)                 SE              Sergipe        0   \n",
       "(SP, BIRITIBA-MIRIM)                 SP            São Paulo        0   \n",
       "(SP, FLORÍNIA)                       SP            São Paulo        0   \n",
       "(SP, GUAIMBÊ)                        SP            São Paulo        0   \n",
       "(SP, ITAÓCA)                         SP            São Paulo        0   \n",
       "(SP, SÃO LUIZ DO PARAITINGA)         SP            São Paulo        0   \n",
       "(TO, COUTO MAGALHÃES)                TO            Tocantins        0   \n",
       "(TO, SÃO VALÉRIO)                    TO            Tocantins        0   \n",
       "\n",
       "                                      latitude  longitude  \n",
       "(AP, PEDRA BRANCA DO AMAPARI)         0.777424   -51.9503  \n",
       "(BA, ARAÇAS)                        -12.220000   -38.2027  \n",
       "(BA, CAÉM)                          -11.067700   -40.4320  \n",
       "(BA, IUIÚ)                          -14.405400   -43.5595  \n",
       "(BA, MUQUÉM DE SÃO FRANCISCO)       -12.065000   -43.5497  \n",
       "(BA, QUIJINGUE)                     -10.750500   -39.2137  \n",
       "(BA, SANTA TERESINHA)               -12.769700   -39.5215  \n",
       "(BA, SANTO ESTÊVÃO)                 -12.428000   -39.2505  \n",
       "(CE, ITAPAJÉ)                        -3.683140   -39.5855  \n",
       "(ES, ATILIO VIVACQUA)               -20.913000   -41.1986  \n",
       "(GO, ANHANGUERA)                    -18.333900   -48.2204  \n",
       "(MG, PASSA-VINTE)                   -22.209700   -44.2344  \n",
       "(MG, PINGO-D'ÁGUA)                  -19.728700   -42.4095  \n",
       "(MG, SEM-PEIXE)                     -20.100800   -42.8483  \n",
       "(PA, ELDORADO DO CARAJÁS)            -6.103890   -49.3553  \n",
       "(PA, SANTA IZABEL DO PARÁ)           -1.296860   -48.1606  \n",
       "(PB, JOCA CLAUDINO)                  -6.483620   -38.4764  \n",
       "(PB, QUIXABÁ)                        -7.022400   -37.1458  \n",
       "(PB, SÃO DOMINGOS)                   -6.803130   -37.9488  \n",
       "(PE, BELÉM DO SÃO FRANCISCO)         -8.750460   -38.9623  \n",
       "(PE, IGUARACY)                       -7.832220   -37.5082  \n",
       "(PE, SÃO CAETANO)                    -8.337630   -36.2869  \n",
       "(PE, SÃO VICENTE FERRER)             -7.589690   -35.4808  \n",
       "(PI, LUÍS CORREIA)                   -2.884380   -41.6641  \n",
       "(PR, ANTÔNIO OLINTO)                -25.980400   -50.1972  \n",
       "(PR, SANTO ANTÔNIO DO CAIUÁ)        -22.735100   -52.3440  \n",
       "(RJ, TRAJANO DE MORAES)             -22.063800   -42.0643  \n",
       "(RN, AUGUSTO SEVERO (CAMPO GRANDE))  -5.862060   -37.3135  \n",
       "(RN, AÇU)                            -5.583620   -36.9140  \n",
       "(RN, JANUÁRIO CICCO (BOA SAÚDE))     -6.165660   -35.6219  \n",
       "(RN, OLHO-D'ÁGUA DO BORGES)          -5.948600   -37.7047  \n",
       "(RO, ALTA FLORESTA D'OESTE)         -11.928300   -61.9953  \n",
       "(RO, ALVORADA D'OESTE)              -11.346300   -62.2847  \n",
       "(RO, ESPIGÃO D'OESTE)               -11.526600   -61.0252  \n",
       "(RO, MACHADINHO D'OESTE)             -9.443630   -61.9818  \n",
       "(RO, NOVA BRASILÂNDIA D'OESTE)      -11.724700   -62.3127  \n",
       "(RO, SANTA LUZIA D'OESTE)           -11.907400   -61.7777  \n",
       "(RO, SÃO FELIPE D'OESTE)            -11.902300   -61.5026  \n",
       "(RS, SANT'ANA DO LIVRAMENTO)        -30.877300   -55.5392  \n",
       "(SC, GRÃO PARÁ)                     -28.180900   -49.2252  \n",
       "(SC, LAURO MULLER)                  -28.385900   -49.4035  \n",
       "(SC, LUIZ ALVES)                    -26.715100   -48.9322  \n",
       "(SC, PRESIDENTE CASTELLO BRANCO)    -27.221800   -51.8089  \n",
       "(SC, SÃO CRISTOVÃO DO SUL)          -27.266600   -50.4388  \n",
       "(SE, GRACHO CARDOSO)                -10.225200   -37.2006  \n",
       "(SP, BIRITIBA-MIRIM)                -23.569800   -46.0407  \n",
       "(SP, FLORÍNIA)                      -22.868000   -50.6814  \n",
       "(SP, GUAIMBÊ)                       -21.909100   -49.8986  \n",
       "(SP, ITAÓCA)                        -24.639300   -48.8413  \n",
       "(SP, SÃO LUIZ DO PARAITINGA)        -23.222000   -45.3109  \n",
       "(TO, COUTO MAGALHÃES)                -8.284110   -49.2473  \n",
       "(TO, SÃO VALÉRIO)                   -11.974300   -48.2353  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_ibge2 = indexed_ibge[~indexed_ibge.index.isin(joined.index)]\n",
    "indexed_ibge2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Aplicando correções para o join:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def normalize(col):\n",
    "    return (\n",
    "        col\n",
    "        .str.upper()\n",
    "        .str.replace(r'[ÁÀÃ]', 'A')\n",
    "        .str.replace(r'[ÉÊ]', 'E')\n",
    "        .str.replace('Í', 'I')\n",
    "        .str.replace('Ç', 'C')\n",
    "        .str.replace(r'[ÓÔ]', 'O')\n",
    "        .str.replace(r'[ÚÜ]', 'U')\n",
    "        .str.replace('ELLO', 'ELO')\n",
    "        .str.replace(\"D'O\", \"DO O\")\n",
    "        .str.replace(\"D'A\", \"DA A\")\n",
    "        .str.replace(\"T'A\", \"TA\")\n",
    "        .str.replace(' DE ', ' DO ')\n",
    "        .str.replace('-', ' ')\n",
    "        .str.replace(r'.+\\((.+)\\).*', r'\\1')\n",
    "    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, AGUA BRANCA DO AMAPARI)</th>\n",
       "      <td>6084</td>\n",
       "      <td>AP</td>\n",
       "      <td>ÁGUA BRANCA DO AMAPARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, ARACAS)</th>\n",
       "      <td>33383</td>\n",
       "      <td>BA</td>\n",
       "      <td>ARAÇÁS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, CAEM)</th>\n",
       "      <td>34010</td>\n",
       "      <td>BA</td>\n",
       "      <td>CAEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, IUIU)</th>\n",
       "      <td>30660</td>\n",
       "      <td>BA</td>\n",
       "      <td>IUIU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, MUQUEM DO SAO FRANCISCO)</th>\n",
       "      <td>37460</td>\n",
       "      <td>BA</td>\n",
       "      <td>MUQUÉM DO SÃO FRANCISCO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               CÓDIGO  UF                     NOME\n",
       "(AP, AGUA BRANCA DO AMAPARI)     6084  AP   ÁGUA BRANCA DO AMAPARI\n",
       "(BA, ARACAS)                    33383  BA                   ARAÇÁS\n",
       "(BA, CAEM)                      34010  BA                     CAEM\n",
       "(BA, IUIU)                      30660  BA                     IUIU\n",
       "(BA, MUQUEM DO SAO FRANCISCO)   37460  BA  MUQUÉM DO SÃO FRANCISCO"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_tse2_fixed = indexed_tse2.set_index(indexed_tse2[['UF', 'NOME']].assign(\n",
    "    NOME=normalize(indexed_tse2.NOME)\n",
    ").apply(tuple, axis='columns'))\n",
    "\n",
    "indexed_tse2_fixed.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, PEDRA BRANCA DO AMAPARI)</th>\n",
       "      <td>1600154</td>\n",
       "      <td>Pedra Branca do Amapari</td>\n",
       "      <td>16</td>\n",
       "      <td>AP</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>0</td>\n",
       "      <td>0.777424</td>\n",
       "      <td>-51.9503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, ARACAS)</th>\n",
       "      <td>2902054</td>\n",
       "      <td>Araças</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.220000</td>\n",
       "      <td>-38.2027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, CAEM)</th>\n",
       "      <td>2905107</td>\n",
       "      <td>Caém</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.067700</td>\n",
       "      <td>-40.4320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, IUIU)</th>\n",
       "      <td>2917334</td>\n",
       "      <td>Iuiú</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-14.405400</td>\n",
       "      <td>-43.5595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, MUQUEM DO SAO FRANCISCO)</th>\n",
       "      <td>2922250</td>\n",
       "      <td>Muquém de São Francisco</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.065000</td>\n",
       "      <td>-43.5497</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               codigo_ibge           nome_municipio  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)      1600154  Pedra Branca do Amapari   \n",
       "(BA, ARACAS)                       2902054                   Araças   \n",
       "(BA, CAEM)                         2905107                     Caém   \n",
       "(BA, IUIU)                         2917334                     Iuiú   \n",
       "(BA, MUQUEM DO SAO FRANCISCO)      2922250  Muquém de São Francisco   \n",
       "\n",
       "                               codigo_uf  uf estado  capital   latitude  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)         16  AP  Amapá        0   0.777424   \n",
       "(BA, ARACAS)                          29  BA  Bahia        0 -12.220000   \n",
       "(BA, CAEM)                            29  BA  Bahia        0 -11.067700   \n",
       "(BA, IUIU)                            29  BA  Bahia        0 -14.405400   \n",
       "(BA, MUQUEM DO SAO FRANCISCO)         29  BA  Bahia        0 -12.065000   \n",
       "\n",
       "                               longitude  \n",
       "(AP, PEDRA BRANCA DO AMAPARI)   -51.9503  \n",
       "(BA, ARACAS)                    -38.2027  \n",
       "(BA, CAEM)                      -40.4320  \n",
       "(BA, IUIU)                      -43.5595  \n",
       "(BA, MUQUEM DO SAO FRANCISCO)   -43.5497  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_ibge2_fixed = indexed_ibge2.set_index(indexed_ibge2[['uf', 'nome_municipio']].assign(\n",
    "    nome_municipio=normalize(indexed_ibge2.nome_municipio)\n",
    ").apply(tuple, axis='columns'))\n",
    "\n",
    "indexed_ibge2_fixed.head()"
   ]
  },
  {
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "      <th>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(BA, ARACAS)</th>\n",
       "      <td>33383</td>\n",
       "      <td>BA</td>\n",
       "      <td>ARAÇÁS</td>\n",
       "      <td>2902054</td>\n",
       "      <td>Araças</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.2200</td>\n",
       "      <td>-38.2027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, CAEM)</th>\n",
       "      <td>34010</td>\n",
       "      <td>BA</td>\n",
       "      <td>CAEM</td>\n",
       "      <td>2905107</td>\n",
       "      <td>Caém</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.0677</td>\n",
       "      <td>-40.4320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, IUIU)</th>\n",
       "      <td>30660</td>\n",
       "      <td>BA</td>\n",
       "      <td>IUIU</td>\n",
       "      <td>2917334</td>\n",
       "      <td>Iuiú</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-14.4054</td>\n",
       "      <td>-43.5595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, MUQUEM DO SAO FRANCISCO)</th>\n",
       "      <td>37460</td>\n",
       "      <td>BA</td>\n",
       "      <td>MUQUÉM DO SÃO FRANCISCO</td>\n",
       "      <td>2922250</td>\n",
       "      <td>Muquém de São Francisco</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.0650</td>\n",
       "      <td>-43.5497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTO ESTEVAO)</th>\n",
       "      <td>38750</td>\n",
       "      <td>BA</td>\n",
       "      <td>SANTO ESTEVÃO</td>\n",
       "      <td>2928802</td>\n",
       "      <td>Santo Estêvão</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.4280</td>\n",
       "      <td>-39.2505</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               CÓDIGO  UF                     NOME  \\\n",
       "(BA, ARACAS)                    33383  BA                   ARAÇÁS   \n",
       "(BA, CAEM)                      34010  BA                     CAEM   \n",
       "(BA, IUIU)                      30660  BA                     IUIU   \n",
       "(BA, MUQUEM DO SAO FRANCISCO)   37460  BA  MUQUÉM DO SÃO FRANCISCO   \n",
       "(BA, SANTO ESTEVAO)             38750  BA            SANTO ESTEVÃO   \n",
       "\n",
       "                               codigo_ibge           nome_municipio  \\\n",
       "(BA, ARACAS)                       2902054                   Araças   \n",
       "(BA, CAEM)                         2905107                     Caém   \n",
       "(BA, IUIU)                         2917334                     Iuiú   \n",
       "(BA, MUQUEM DO SAO FRANCISCO)      2922250  Muquém de São Francisco   \n",
       "(BA, SANTO ESTEVAO)                2928802            Santo Estêvão   \n",
       "\n",
       "                               codigo_uf  uf estado  capital  latitude  \\\n",
       "(BA, ARACAS)                          29  BA  Bahia        0  -12.2200   \n",
       "(BA, CAEM)                            29  BA  Bahia        0  -11.0677   \n",
       "(BA, IUIU)                            29  BA  Bahia        0  -14.4054   \n",
       "(BA, MUQUEM DO SAO FRANCISCO)         29  BA  Bahia        0  -12.0650   \n",
       "(BA, SANTO ESTEVAO)                   29  BA  Bahia        0  -12.4280   \n",
       "\n",
       "                               longitude  \n",
       "(BA, ARACAS)                    -38.2027  \n",
       "(BA, CAEM)                      -40.4320  \n",
       "(BA, IUIU)                      -43.5595  \n",
       "(BA, MUQUEM DO SAO FRANCISCO)   -43.5497  \n",
       "(BA, SANTO ESTEVAO)             -39.2505  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "joined2 = indexed_tse2_fixed.join(indexed_ibge2_fixed, how='inner')\n",
    "joined2.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ainda faltam:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(indexed_tse2)- len(joined2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Analisando:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, AGUA BRANCA DO AMAPARI)</th>\n",
       "      <td>6084</td>\n",
       "      <td>AP</td>\n",
       "      <td>ÁGUA BRANCA DO AMAPARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, QUINJINGUE)</th>\n",
       "      <td>38199</td>\n",
       "      <td>BA</td>\n",
       "      <td>QUINJINGUE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTA TEREZINHA)</th>\n",
       "      <td>38695</td>\n",
       "      <td>BA</td>\n",
       "      <td>SANTA TEREZINHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(CE, ITAPAGE)</th>\n",
       "      <td>14273</td>\n",
       "      <td>CE</td>\n",
       "      <td>ITAPAGÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, ELDORADO DOS CARAJAS)</th>\n",
       "      <td>4120</td>\n",
       "      <td>PA</td>\n",
       "      <td>ELDORADO DOS CARAJÁS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, SANTA ISABEL DO PARA)</th>\n",
       "      <td>5290</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA ISABEL DO PARÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SANTAREM)</th>\n",
       "      <td>19666</td>\n",
       "      <td>PB</td>\n",
       "      <td>SANTARÉM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SAO DOMINGOS DO POMBAL)</th>\n",
       "      <td>19429</td>\n",
       "      <td>PB</td>\n",
       "      <td>SÃO DOMINGOS DE POMBAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, IGUARACI)</th>\n",
       "      <td>24376</td>\n",
       "      <td>PE</td>\n",
       "      <td>IGUARACI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SAO CAITANO)</th>\n",
       "      <td>25615</td>\n",
       "      <td>PE</td>\n",
       "      <td>SÃO CAITANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RJ, TRAJANO DO MORAIS)</th>\n",
       "      <td>59170</td>\n",
       "      <td>RJ</td>\n",
       "      <td>TRAJANO DE MORAIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, ASSU)</th>\n",
       "      <td>16039</td>\n",
       "      <td>RN</td>\n",
       "      <td>ASSÚ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LUIS ALVES)</th>\n",
       "      <td>81973</td>\n",
       "      <td>SC</td>\n",
       "      <td>LUÍS ALVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SE, GRACCHO CARDOSO)</th>\n",
       "      <td>31518</td>\n",
       "      <td>SE</td>\n",
       "      <td>GRACCHO CARDOSO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, FLORINEA)</th>\n",
       "      <td>64238</td>\n",
       "      <td>SP</td>\n",
       "      <td>FLORÍNEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, SAO LUIS DO PARAITINGA)</th>\n",
       "      <td>71013</td>\n",
       "      <td>SP</td>\n",
       "      <td>SÃO LUÍS DO PARAITINGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, COUTO DO MAGALHAES)</th>\n",
       "      <td>93211</td>\n",
       "      <td>TO</td>\n",
       "      <td>COUTO DE MAGALHÃES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, SAO VALERIO DA NATIVIDADE)</th>\n",
       "      <td>92681</td>\n",
       "      <td>TO</td>\n",
       "      <td>SÃO VALÉRIO DA NATIVIDADE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 CÓDIGO  UF                       NOME\n",
       "(AP, AGUA BRANCA DO AMAPARI)       6084  AP     ÁGUA BRANCA DO AMAPARI\n",
       "(BA, QUINJINGUE)                  38199  BA                 QUINJINGUE\n",
       "(BA, SANTA TEREZINHA)             38695  BA            SANTA TEREZINHA\n",
       "(CE, ITAPAGE)                     14273  CE                    ITAPAGÉ\n",
       "(PA, ELDORADO DOS CARAJAS)         4120  PA       ELDORADO DOS CARAJÁS\n",
       "(PA, SANTA ISABEL DO PARA)         5290  PA       SANTA ISABEL DO PARÁ\n",
       "(PB, SANTAREM)                    19666  PB                   SANTARÉM\n",
       "(PB, SAO DOMINGOS DO POMBAL)      19429  PB     SÃO DOMINGOS DE POMBAL\n",
       "(PE, IGUARACI)                    24376  PE                   IGUARACI\n",
       "(PE, SAO CAITANO)                 25615  PE                SÃO CAITANO\n",
       "(RJ, TRAJANO DO MORAIS)           59170  RJ          TRAJANO DE MORAIS\n",
       "(RN, ASSU)                        16039  RN                       ASSÚ\n",
       "(SC, LUIS ALVES)                  81973  SC                 LUÍS ALVES\n",
       "(SE, GRACCHO CARDOSO)             31518  SE            GRACCHO CARDOSO\n",
       "(SP, FLORINEA)                    64238  SP                   FLORÍNEA\n",
       "(SP, SAO LUIS DO PARAITINGA)      71013  SP     SÃO LUÍS DO PARAITINGA\n",
       "(TO, COUTO DO MAGALHAES)          93211  TO         COUTO DE MAGALHÃES\n",
       "(TO, SAO VALERIO DA NATIVIDADE)   92681  TO  SÃO VALÉRIO DA NATIVIDADE"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_tse3 = indexed_tse2_fixed[~indexed_tse2_fixed.index.isin(joined2.index)]\n",
    "indexed_tse3"
   ]
  },
  {
   "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>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(AP, PEDRA BRANCA DO AMAPARI)</th>\n",
       "      <td>1600154</td>\n",
       "      <td>Pedra Branca do Amapari</td>\n",
       "      <td>16</td>\n",
       "      <td>AP</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>0</td>\n",
       "      <td>0.777424</td>\n",
       "      <td>-51.9503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, QUIJINGUE)</th>\n",
       "      <td>2925907</td>\n",
       "      <td>Quijingue</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.750500</td>\n",
       "      <td>-39.2137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(BA, SANTA TERESINHA)</th>\n",
       "      <td>2928505</td>\n",
       "      <td>Santa Teresinha</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.769700</td>\n",
       "      <td>-39.5215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(CE, ITAPAJE)</th>\n",
       "      <td>2306306</td>\n",
       "      <td>Itapajé</td>\n",
       "      <td>23</td>\n",
       "      <td>CE</td>\n",
       "      <td>Ceará</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.683140</td>\n",
       "      <td>-39.5855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, ELDORADO DO CARAJAS)</th>\n",
       "      <td>1502954</td>\n",
       "      <td>Eldorado do Carajás</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.103890</td>\n",
       "      <td>-49.3553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PA, SANTA IZABEL DO PARA)</th>\n",
       "      <td>1506500</td>\n",
       "      <td>Santa Izabel do Pará</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.296860</td>\n",
       "      <td>-48.1606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, JOCA CLAUDINO)</th>\n",
       "      <td>2513653</td>\n",
       "      <td>Joca Claudino</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.483620</td>\n",
       "      <td>-38.4764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PB, SAO DOMINGOS)</th>\n",
       "      <td>2513968</td>\n",
       "      <td>São Domingos</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.803130</td>\n",
       "      <td>-37.9488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, IGUARACY)</th>\n",
       "      <td>2606903</td>\n",
       "      <td>Iguaracy</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.832220</td>\n",
       "      <td>-37.5082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(PE, SAO CAETANO)</th>\n",
       "      <td>2613107</td>\n",
       "      <td>São Caetano</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.337630</td>\n",
       "      <td>-36.2869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RJ, TRAJANO DO MORAES)</th>\n",
       "      <td>3305901</td>\n",
       "      <td>Trajano de Moraes</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.063800</td>\n",
       "      <td>-42.0643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(RN, ACU)</th>\n",
       "      <td>2400208</td>\n",
       "      <td>Açu</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.583620</td>\n",
       "      <td>-36.9140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SC, LUIZ ALVES)</th>\n",
       "      <td>4210001</td>\n",
       "      <td>Luiz Alves</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-26.715100</td>\n",
       "      <td>-48.9322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SE, GRACHO CARDOSO)</th>\n",
       "      <td>2802601</td>\n",
       "      <td>Gracho Cardoso</td>\n",
       "      <td>28</td>\n",
       "      <td>SE</td>\n",
       "      <td>Sergipe</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.225200</td>\n",
       "      <td>-37.2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, FLORINIA)</th>\n",
       "      <td>3516101</td>\n",
       "      <td>Florínia</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.868000</td>\n",
       "      <td>-50.6814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SP, SAO LUIZ DO PARAITINGA)</th>\n",
       "      <td>3550001</td>\n",
       "      <td>São Luiz do Paraitinga</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.222000</td>\n",
       "      <td>-45.3109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, COUTO MAGALHAES)</th>\n",
       "      <td>1706001</td>\n",
       "      <td>Couto Magalhães</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.284110</td>\n",
       "      <td>-49.2473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(TO, SAO VALERIO)</th>\n",
       "      <td>1720499</td>\n",
       "      <td>São Valério</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.974300</td>\n",
       "      <td>-48.2353</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               codigo_ibge           nome_municipio  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)      1600154  Pedra Branca do Amapari   \n",
       "(BA, QUIJINGUE)                    2925907                Quijingue   \n",
       "(BA, SANTA TERESINHA)              2928505          Santa Teresinha   \n",
       "(CE, ITAPAJE)                      2306306                  Itapajé   \n",
       "(PA, ELDORADO DO CARAJAS)          1502954      Eldorado do Carajás   \n",
       "(PA, SANTA IZABEL DO PARA)         1506500     Santa Izabel do Pará   \n",
       "(PB, JOCA CLAUDINO)                2513653            Joca Claudino   \n",
       "(PB, SAO DOMINGOS)                 2513968             São Domingos   \n",
       "(PE, IGUARACY)                     2606903                 Iguaracy   \n",
       "(PE, SAO CAETANO)                  2613107              São Caetano   \n",
       "(RJ, TRAJANO DO MORAES)            3305901        Trajano de Moraes   \n",
       "(RN, ACU)                          2400208                      Açu   \n",
       "(SC, LUIZ ALVES)                   4210001               Luiz Alves   \n",
       "(SE, GRACHO CARDOSO)               2802601           Gracho Cardoso   \n",
       "(SP, FLORINIA)                     3516101                 Florínia   \n",
       "(SP, SAO LUIZ DO PARAITINGA)       3550001   São Luiz do Paraitinga   \n",
       "(TO, COUTO MAGALHAES)              1706001          Couto Magalhães   \n",
       "(TO, SAO VALERIO)                  1720499              São Valério   \n",
       "\n",
       "                               codigo_uf  uf               estado  capital  \\\n",
       "(AP, PEDRA BRANCA DO AMAPARI)         16  AP                Amapá        0   \n",
       "(BA, QUIJINGUE)                       29  BA                Bahia        0   \n",
       "(BA, SANTA TERESINHA)                 29  BA                Bahia        0   \n",
       "(CE, ITAPAJE)                         23  CE                Ceará        0   \n",
       "(PA, ELDORADO DO CARAJAS)             15  PA                 Pará        0   \n",
       "(PA, SANTA IZABEL DO PARA)            15  PA                 Pará        0   \n",
       "(PB, JOCA CLAUDINO)                   25  PB              Paraíba        0   \n",
       "(PB, SAO DOMINGOS)                    25  PB              Paraíba        0   \n",
       "(PE, IGUARACY)                        26  PE           Pernambuco        0   \n",
       "(PE, SAO CAETANO)                     26  PE           Pernambuco        0   \n",
       "(RJ, TRAJANO DO MORAES)               33  RJ       Rio de Janeiro        0   \n",
       "(RN, ACU)                             24  RN  Rio Grande do Norte        0   \n",
       "(SC, LUIZ ALVES)                      42  SC       Santa Catarina        0   \n",
       "(SE, GRACHO CARDOSO)                  28  SE              Sergipe        0   \n",
       "(SP, FLORINIA)                        35  SP            São Paulo        0   \n",
       "(SP, SAO LUIZ DO PARAITINGA)          35  SP            São Paulo        0   \n",
       "(TO, COUTO MAGALHAES)                 17  TO            Tocantins        0   \n",
       "(TO, SAO VALERIO)                     17  TO            Tocantins        0   \n",
       "\n",
       "                                latitude  longitude  \n",
       "(AP, PEDRA BRANCA DO AMAPARI)   0.777424   -51.9503  \n",
       "(BA, QUIJINGUE)               -10.750500   -39.2137  \n",
       "(BA, SANTA TERESINHA)         -12.769700   -39.5215  \n",
       "(CE, ITAPAJE)                  -3.683140   -39.5855  \n",
       "(PA, ELDORADO DO CARAJAS)      -6.103890   -49.3553  \n",
       "(PA, SANTA IZABEL DO PARA)     -1.296860   -48.1606  \n",
       "(PB, JOCA CLAUDINO)            -6.483620   -38.4764  \n",
       "(PB, SAO DOMINGOS)             -6.803130   -37.9488  \n",
       "(PE, IGUARACY)                 -7.832220   -37.5082  \n",
       "(PE, SAO CAETANO)              -8.337630   -36.2869  \n",
       "(RJ, TRAJANO DO MORAES)       -22.063800   -42.0643  \n",
       "(RN, ACU)                      -5.583620   -36.9140  \n",
       "(SC, LUIZ ALVES)              -26.715100   -48.9322  \n",
       "(SE, GRACHO CARDOSO)          -10.225200   -37.2006  \n",
       "(SP, FLORINIA)                -22.868000   -50.6814  \n",
       "(SP, SAO LUIZ DO PARAITINGA)  -23.222000   -45.3109  \n",
       "(TO, COUTO MAGALHAES)          -8.284110   -49.2473  \n",
       "(TO, SAO VALERIO)             -11.974300   -48.2353  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed_ibge3 = indexed_ibge2_fixed[~indexed_ibge2_fixed.index.isin(joined2.index)]\n",
    "indexed_ibge3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Esses últimos podem ser joinados por ordem alfabética:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CÓDIGO</th>\n",
       "      <th>UF</th>\n",
       "      <th>NOME</th>\n",
       "      <th>codigo_ibge</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado</th>\n",
       "      <th>capital</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6084</td>\n",
       "      <td>AP</td>\n",
       "      <td>ÁGUA BRANCA DO AMAPARI</td>\n",
       "      <td>1600154</td>\n",
       "      <td>Pedra Branca do Amapari</td>\n",
       "      <td>16</td>\n",
       "      <td>AP</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>0</td>\n",
       "      <td>0.777424</td>\n",
       "      <td>-51.9503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>38199</td>\n",
       "      <td>BA</td>\n",
       "      <td>QUINJINGUE</td>\n",
       "      <td>2925907</td>\n",
       "      <td>Quijingue</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.750500</td>\n",
       "      <td>-39.2137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38695</td>\n",
       "      <td>BA</td>\n",
       "      <td>SANTA TEREZINHA</td>\n",
       "      <td>2928505</td>\n",
       "      <td>Santa Teresinha</td>\n",
       "      <td>29</td>\n",
       "      <td>BA</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.769700</td>\n",
       "      <td>-39.5215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>14273</td>\n",
       "      <td>CE</td>\n",
       "      <td>ITAPAGÉ</td>\n",
       "      <td>2306306</td>\n",
       "      <td>Itapajé</td>\n",
       "      <td>23</td>\n",
       "      <td>CE</td>\n",
       "      <td>Ceará</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.683140</td>\n",
       "      <td>-39.5855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4120</td>\n",
       "      <td>PA</td>\n",
       "      <td>ELDORADO DOS CARAJÁS</td>\n",
       "      <td>1502954</td>\n",
       "      <td>Eldorado do Carajás</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.103890</td>\n",
       "      <td>-49.3553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5290</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA ISABEL DO PARÁ</td>\n",
       "      <td>1506500</td>\n",
       "      <td>Santa Izabel do Pará</td>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.296860</td>\n",
       "      <td>-48.1606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>19666</td>\n",
       "      <td>PB</td>\n",
       "      <td>SANTARÉM</td>\n",
       "      <td>2513653</td>\n",
       "      <td>Joca Claudino</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.483620</td>\n",
       "      <td>-38.4764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>19429</td>\n",
       "      <td>PB</td>\n",
       "      <td>SÃO DOMINGOS DE POMBAL</td>\n",
       "      <td>2513968</td>\n",
       "      <td>São Domingos</td>\n",
       "      <td>25</td>\n",
       "      <td>PB</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.803130</td>\n",
       "      <td>-37.9488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>24376</td>\n",
       "      <td>PE</td>\n",
       "      <td>IGUARACI</td>\n",
       "      <td>2606903</td>\n",
       "      <td>Iguaracy</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.832220</td>\n",
       "      <td>-37.5082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>25615</td>\n",
       "      <td>PE</td>\n",
       "      <td>SÃO CAITANO</td>\n",
       "      <td>2613107</td>\n",
       "      <td>São Caetano</td>\n",
       "      <td>26</td>\n",
       "      <td>PE</td>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.337630</td>\n",
       "      <td>-36.2869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>59170</td>\n",
       "      <td>RJ</td>\n",
       "      <td>TRAJANO DE MORAIS</td>\n",
       "      <td>3305901</td>\n",
       "      <td>Trajano de Moraes</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.063800</td>\n",
       "      <td>-42.0643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>16039</td>\n",
       "      <td>RN</td>\n",
       "      <td>ASSÚ</td>\n",
       "      <td>2400208</td>\n",
       "      <td>Açu</td>\n",
       "      <td>24</td>\n",
       "      <td>RN</td>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.583620</td>\n",
       "      <td>-36.9140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>81973</td>\n",
       "      <td>SC</td>\n",
       "      <td>LUÍS ALVES</td>\n",
       "      <td>4210001</td>\n",
       "      <td>Luiz Alves</td>\n",
       "      <td>42</td>\n",
       "      <td>SC</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>0</td>\n",
       "      <td>-26.715100</td>\n",
       "      <td>-48.9322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>31518</td>\n",
       "      <td>SE</td>\n",
       "      <td>GRACCHO CARDOSO</td>\n",
       "      <td>2802601</td>\n",
       "      <td>Gracho Cardoso</td>\n",
       "      <td>28</td>\n",
       "      <td>SE</td>\n",
       "      <td>Sergipe</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.225200</td>\n",
       "      <td>-37.2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>64238</td>\n",
       "      <td>SP</td>\n",
       "      <td>FLORÍNEA</td>\n",
       "      <td>3516101</td>\n",
       "      <td>Florínia</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-22.868000</td>\n",
       "      <td>-50.6814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>71013</td>\n",
       "      <td>SP</td>\n",
       "      <td>SÃO LUÍS DO PARAITINGA</td>\n",
       "      <td>3550001</td>\n",
       "      <td>São Luiz do Paraitinga</td>\n",
       "      <td>35</td>\n",
       "      <td>SP</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.222000</td>\n",
       "      <td>-45.3109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>93211</td>\n",
       "      <td>TO</td>\n",
       "      <td>COUTO DE MAGALHÃES</td>\n",
       "      <td>1706001</td>\n",
       "      <td>Couto Magalhães</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.284110</td>\n",
       "      <td>-49.2473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>92681</td>\n",
       "      <td>TO</td>\n",
       "      <td>SÃO VALÉRIO DA NATIVIDADE</td>\n",
       "      <td>1720499</td>\n",
       "      <td>São Valério</td>\n",
       "      <td>17</td>\n",
       "      <td>TO</td>\n",
       "      <td>Tocantins</td>\n",
       "      <td>0</td>\n",
       "      <td>-11.974300</td>\n",
       "      <td>-48.2353</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    CÓDIGO  UF                       NOME  codigo_ibge  \\\n",
       "0     6084  AP     ÁGUA BRANCA DO AMAPARI      1600154   \n",
       "1    38199  BA                 QUINJINGUE      2925907   \n",
       "2    38695  BA            SANTA TEREZINHA      2928505   \n",
       "3    14273  CE                    ITAPAGÉ      2306306   \n",
       "4     4120  PA       ELDORADO DOS CARAJÁS      1502954   \n",
       "5     5290  PA       SANTA ISABEL DO PARÁ      1506500   \n",
       "6    19666  PB                   SANTARÉM      2513653   \n",
       "7    19429  PB     SÃO DOMINGOS DE POMBAL      2513968   \n",
       "8    24376  PE                   IGUARACI      2606903   \n",
       "9    25615  PE                SÃO CAITANO      2613107   \n",
       "10   59170  RJ          TRAJANO DE MORAIS      3305901   \n",
       "11   16039  RN                       ASSÚ      2400208   \n",
       "12   81973  SC                 LUÍS ALVES      4210001   \n",
       "13   31518  SE            GRACCHO CARDOSO      2802601   \n",
       "14   64238  SP                   FLORÍNEA      3516101   \n",
       "15   71013  SP     SÃO LUÍS DO PARAITINGA      3550001   \n",
       "16   93211  TO         COUTO DE MAGALHÃES      1706001   \n",
       "17   92681  TO  SÃO VALÉRIO DA NATIVIDADE      1720499   \n",
       "\n",
       "             nome_municipio  codigo_uf  uf               estado  capital  \\\n",
       "0   Pedra Branca do Amapari         16  AP                Amapá        0   \n",
       "1                 Quijingue         29  BA                Bahia        0   \n",
       "2           Santa Teresinha         29  BA                Bahia        0   \n",
       "3                   Itapajé         23  CE                Ceará        0   \n",
       "4       Eldorado do Carajás         15  PA                 Pará        0   \n",
       "5      Santa Izabel do Pará         15  PA                 Pará        0   \n",
       "6             Joca Claudino         25  PB              Paraíba        0   \n",
       "7              São Domingos         25  PB              Paraíba        0   \n",
       "8                  Iguaracy         26  PE           Pernambuco        0   \n",
       "9               São Caetano         26  PE           Pernambuco        0   \n",
       "10        Trajano de Moraes         33  RJ       Rio de Janeiro        0   \n",
       "11                      Açu         24  RN  Rio Grande do Norte        0   \n",
       "12               Luiz Alves         42  SC       Santa Catarina        0   \n",
       "13           Gracho Cardoso         28  SE              Sergipe        0   \n",
       "14                 Florínia         35  SP            São Paulo        0   \n",
       "15   São Luiz do Paraitinga         35  SP            São Paulo        0   \n",
       "16          Couto Magalhães         17  TO            Tocantins        0   \n",
       "17              São Valério         17  TO            Tocantins        0   \n",
       "\n",
       "     latitude  longitude  \n",
       "0    0.777424   -51.9503  \n",
       "1  -10.750500   -39.2137  \n",
       "2  -12.769700   -39.5215  \n",
       "3   -3.683140   -39.5855  \n",
       "4   -6.103890   -49.3553  \n",
       "5   -1.296860   -48.1606  \n",
       "6   -6.483620   -38.4764  \n",
       "7   -6.803130   -37.9488  \n",
       "8   -7.832220   -37.5082  \n",
       "9   -8.337630   -36.2869  \n",
       "10 -22.063800   -42.0643  \n",
       "11  -5.583620   -36.9140  \n",
       "12 -26.715100   -48.9322  \n",
       "13 -10.225200   -37.2006  \n",
       "14 -22.868000   -50.6814  \n",
       "15 -23.222000   -45.3109  \n",
       "16  -8.284110   -49.2473  \n",
       "17 -11.974300   -48.2353  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "joined3 = indexed_tse3.reset_index(drop=True).join(indexed_ibge3.reset_index(drop=True))\n",
    "joined3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### O único estranho é Santarém -> Joca Claudino em PB, mas googlando confirmo que o município mudou de nome"
   ]
  },
  {
   "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>codigo_tse</th>\n",
       "      <th>uf</th>\n",
       "      <th>nome_municipio</th>\n",
       "      <th>capital</th>\n",
       "      <th>codigo_ibge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELÂNDIA</td>\n",
       "      <td>0</td>\n",
       "      <td>1200013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1570</td>\n",
       "      <td>AC</td>\n",
       "      <td>ASSIS BRASIL</td>\n",
       "      <td>0</td>\n",
       "      <td>1200054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1058</td>\n",
       "      <td>AC</td>\n",
       "      <td>BRASILÉIA</td>\n",
       "      <td>0</td>\n",
       "      <td>1200104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1007</td>\n",
       "      <td>AC</td>\n",
       "      <td>BUJARI</td>\n",
       "      <td>0</td>\n",
       "      <td>1200138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1015</td>\n",
       "      <td>AC</td>\n",
       "      <td>CAPIXABA</td>\n",
       "      <td>0</td>\n",
       "      <td>1200179</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_tse  uf nome_municipio  capital  codigo_ibge\n",
       "0        1120  AC     ACRELÂNDIA        0      1200013\n",
       "1        1570  AC   ASSIS BRASIL        0      1200054\n",
       "2        1058  AC      BRASILÉIA        0      1200104\n",
       "3        1007  AC         BUJARI        0      1200138\n",
       "4        1015  AC       CAPIXABA        0      1200179"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final = pd.concat([joined, joined2, joined3]).sort_values(['UF', 'NOME']).reset_index(drop=True)[[\n",
    "    'CÓDIGO',\n",
    "    'UF',\n",
    "    'NOME',\n",
    "    'capital',\n",
    "    'codigo_ibge',\n",
    "]].rename(columns={\n",
    "    'CÓDIGO': 'codigo_tse',\n",
    "    'UF': 'uf',\n",
    "    'NOME': 'nome_municipio',\n",
    "})\n",
    "\n",
    "final.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "final.to_csv('municipios_brasileiros_tse.csv', index=None)\n",
    "final.to_json('municipios_brasileiros_tse.json', orient='records', force_ascii=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}