merge_csv_shp.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "O objetivo do código é realizar um merge entre um arquivo shapefile (limites municipais) com um arquivo csv (lista de municípos), onde, a única informação em comum entre os dois arquivos são os nomes dos municípios."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Importando as bibliotecas necessárias"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Realizamos a importação das bibliotecas necessárias. Importamos a pandas apenas para uma visualização e, se necessário, manipulação do arquivo csv.\n",
    "\n",
    "import geopandas as gpd\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Carregando e manipulando o arquivo csv."
   ]
  },
  {
   "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>id</th>\n",
       "      <th>mun</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Anagé</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Andaraí</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Andorinha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Aracatu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Araci</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id        mun\n",
       "0   1      Anagé\n",
       "1   2    Andaraí\n",
       "2   3  Andorinha\n",
       "3   4    Aracatu\n",
       "4   5      Araci"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Carregando e fazendo uma visualização prévia do conteúdo do arquivo csv\n",
    "\n",
    "csv = pd.read_csv('/home/rivas/Estudos/PythonGIS/data/relacao_municipios.csv', header=0) # Acessando o arquivo\n",
    "\n",
    "csv.head() # Visualizando os cinco primeiros registros"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Andaraí</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Andorinha</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Aracatu</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id        mun emer_seca\n",
       "0   1      Anagé       Sim\n",
       "1   2    Andaraí       Sim\n",
       "2   3  Andorinha       Sim\n",
       "3   4    Aracatu       Sim\n",
       "4   5      Araci       Sim"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv['emer_seca'] = 'Sim' # Aqui criamos o campo 'emer_seca' e atribuímos o valor 'Sim' aos municípios em siuação de emergência.\n",
    "\n",
    "csv.head() # Mais uma vez visualizando os cinco primeiros registros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(95, 3)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv.shape # Com a instrução shape podemos ter a informação da \"forma\" da tabela csv que possui 95 linhas e 3 colunas."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Carregando e manipulando o arquivo shapefile."
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>2900207</td>\n",
       "      <td>Abaré</td>\n",
       "      <td>Itaparica</td>\n",
       "      <td>16991</td>\n",
       "      <td>1885</td>\n",
       "      <td>1700</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.708172</td>\n",
       "      <td>POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>2900405</td>\n",
       "      <td>Água Fria</td>\n",
       "      <td>Portal do Sertão</td>\n",
       "      <td>15659</td>\n",
       "      <td>2165</td>\n",
       "      <td>1705</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.129475</td>\n",
       "      <td>POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489</td>\n",
       "      <td>2475</td>\n",
       "      <td>2065</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536</td>\n",
       "      <td>4779</td>\n",
       "      <td>3635</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>2902658</td>\n",
       "      <td>Banzaê</td>\n",
       "      <td>Semiárido Nordeste II</td>\n",
       "      <td>11801</td>\n",
       "      <td>1754</td>\n",
       "      <td>1590</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.923486</td>\n",
       "      <td>POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID   CD_MUN     NM_MUN             Territorio  PopRes  Est_Agrico  \\\n",
       "0         2  2900207      Abaré              Itaparica   16991        1885   \n",
       "1         5  2900405  Água Fria       Portal do Sertão   15659        2165   \n",
       "2        14  2901205      Anagé        Sudoeste Baiano   25489        2475   \n",
       "3        26  2902104      Araci                  Sisal   51536        4779   \n",
       "4        33  2902658     Banzaê  Semiárido Nordeste II   11801        1754   \n",
       "\n",
       "   Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0        1700                   Caatinga    1.708172   \n",
       "1        1705  Caatinga e Mata Atlântica    1.129475   \n",
       "2        2065  Caatinga e Mata Atlântica    2.296842   \n",
       "3        3635                   Caatinga    2.061252   \n",
       "4        1590                   Caatinga    0.923486   \n",
       "\n",
       "                                            geometry  \n",
       "0  POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...  \n",
       "1  POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...  \n",
       "2  POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...  \n",
       "3  POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...  \n",
       "4  POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shp = gpd.read_file('/home/rivas/Estudos/PythonGIS/data/mun_limites.shp')\n",
    "\n",
    "shp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(417, 10)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shp.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Realizando o merge"
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489</td>\n",
       "      <td>2475</td>\n",
       "      <td>2065</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "      <td>1</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>26</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536</td>\n",
       "      <td>4779</td>\n",
       "      <td>3635</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "      <td>5</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>47</td>\n",
       "      <td>2903805</td>\n",
       "      <td>Boa Vista do Tupim</td>\n",
       "      <td>Piemonte do Paraguaçu</td>\n",
       "      <td>17917</td>\n",
       "      <td>2536</td>\n",
       "      <td>1901</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.612894</td>\n",
       "      <td>POLYGON ((-40.56749 -12.45239, -40.56697 -12.4...</td>\n",
       "      <td>10</td>\n",
       "      <td>Boa Vista do Tupim</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49</td>\n",
       "      <td>2903953</td>\n",
       "      <td>Bom Jesus da Serra</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>10111</td>\n",
       "      <td>1570</td>\n",
       "      <td>1433</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.087668</td>\n",
       "      <td>POLYGON ((-40.67763 -14.32803, -40.67726 -14.3...</td>\n",
       "      <td>12</td>\n",
       "      <td>Bom Jesus da Serra</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>56</td>\n",
       "      <td>2904506</td>\n",
       "      <td>Brotas de Macaúbas</td>\n",
       "      <td>Velho Chico</td>\n",
       "      <td>10697</td>\n",
       "      <td>1640</td>\n",
       "      <td>1579</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>3.138704</td>\n",
       "      <td>POLYGON ((-42.75099 -11.72904, -42.75076 -11.7...</td>\n",
       "      <td>13</td>\n",
       "      <td>Brotas de Macaúbas</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID   CD_MUN              NM_MUN             Territorio  PopRes  \\\n",
       "0        14  2901205               Anagé        Sudoeste Baiano   25489   \n",
       "1        26  2902104               Araci                  Sisal   51536   \n",
       "2        47  2903805  Boa Vista do Tupim  Piemonte do Paraguaçu   17917   \n",
       "3        49  2903953  Bom Jesus da Serra        Sudoeste Baiano   10111   \n",
       "4        56  2904506  Brotas de Macaúbas            Velho Chico   10697   \n",
       "\n",
       "   Est_Agrico  Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0        2475        2065  Caatinga e Mata Atlântica    2.296842   \n",
       "1        4779        3635                   Caatinga    2.061252   \n",
       "2        2536        1901                   Caatinga    2.612894   \n",
       "3        1570        1433  Caatinga e Mata Atlântica    1.087668   \n",
       "4        1640        1579                   Caatinga    3.138704   \n",
       "\n",
       "                                            geometry  id                 mun  \\\n",
       "0  POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...   1               Anagé   \n",
       "1  POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...   5               Araci   \n",
       "2  POLYGON ((-40.56749 -12.45239, -40.56697 -12.4...  10  Boa Vista do Tupim   \n",
       "3  POLYGON ((-40.67763 -14.32803, -40.67726 -14.3...  12  Bom Jesus da Serra   \n",
       "4  POLYGON ((-42.75099 -11.72904, -42.75076 -11.7...  13  Brotas de Macaúbas   \n",
       "\n",
       "  emer_seca  \n",
       "0       Sim  \n",
       "1       Sim  \n",
       "2       Sim  \n",
       "3       Sim  \n",
       "4       Sim  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Para a realização do merge serão utilizados os campos NM_MUN da camada mun_limites e o campo mun da lisat csv.\n",
    "\n",
    "uniao = shp.merge(csv, left_on= 'NM_MUN', right_on='mun')\n",
    "\n",
    "\n",
    "uniao.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(85, 13)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "uniao.shape # Após o merge verificamos que tivemos 10 municipios a menos em relação aos 95 listados no arquivo csv."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Como é comum, ao se realizar operações de merge/join utilizando coampos de texto a chances de ocorrer erro é maior. Podem ocorrer erros por diversos fatores como escrita de formas diferentes, palavras com acentuação gráfica e outras sem... e por aí vai.\n",
    "\n",
    "Agora precisaremos identificar os campos que não forma unidos para verificarmos quais os erros e realizar alguma correção.\n",
    "\n",
    "Para isso iremos refazer o merge mas adicionando alguns parâmetros que poderão ajudar na identificação nos campos com problema."
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2900207</td>\n",
       "      <td>Abaré</td>\n",
       "      <td>Itaparica</td>\n",
       "      <td>16991.0</td>\n",
       "      <td>1885.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.708172</td>\n",
       "      <td>POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2900405</td>\n",
       "      <td>Água Fria</td>\n",
       "      <td>Portal do Sertão</td>\n",
       "      <td>15659.0</td>\n",
       "      <td>2165.0</td>\n",
       "      <td>1705.0</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.129475</td>\n",
       "      <td>POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.0</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489.0</td>\n",
       "      <td>2475.0</td>\n",
       "      <td>2065.0</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26.0</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536.0</td>\n",
       "      <td>4779.0</td>\n",
       "      <td>3635.0</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33.0</td>\n",
       "      <td>2902658</td>\n",
       "      <td>Banzaê</td>\n",
       "      <td>Semiárido Nordeste II</td>\n",
       "      <td>11801.0</td>\n",
       "      <td>1754.0</td>\n",
       "      <td>1590.0</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.923486</td>\n",
       "      <td>POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID   CD_MUN     NM_MUN             Territorio   PopRes  Est_Agrico  \\\n",
       "0       2.0  2900207      Abaré              Itaparica  16991.0      1885.0   \n",
       "1       5.0  2900405  Água Fria       Portal do Sertão  15659.0      2165.0   \n",
       "2      14.0  2901205      Anagé        Sudoeste Baiano  25489.0      2475.0   \n",
       "3      26.0  2902104      Araci                  Sisal  51536.0      4779.0   \n",
       "4      33.0  2902658     Banzaê  Semiárido Nordeste II  11801.0      1754.0   \n",
       "\n",
       "   Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0      1700.0                   Caatinga    1.708172   \n",
       "1      1705.0  Caatinga e Mata Atlântica    1.129475   \n",
       "2      2065.0  Caatinga e Mata Atlântica    2.296842   \n",
       "3      3635.0                   Caatinga    2.061252   \n",
       "4      1590.0                   Caatinga    0.923486   \n",
       "\n",
       "                                            geometry   id    mun emer_seca  \\\n",
       "0  POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...  NaN    NaN       NaN   \n",
       "1  POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...  NaN    NaN       NaN   \n",
       "2  POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...  1.0  Anagé       Sim   \n",
       "3  POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...  5.0  Araci       Sim   \n",
       "4  POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...  NaN    NaN       NaN   \n",
       "\n",
       "      _merge  \n",
       "0  left_only  \n",
       "1  left_only  \n",
       "2       both  \n",
       "3       both  \n",
       "4  left_only  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Realizando o merge\n",
    "\n",
    "uniao = shp.merge(csv, left_on= 'NM_MUN', right_on='mun', how='outer', indicator=True) #Com os parâmetros 'outer' e 'indicator' podemos identificar os campos que não tiveram correspondência\n",
    "\n",
    "\n",
    "uniao.head()"
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2900207</td>\n",
       "      <td>Abaré</td>\n",
       "      <td>Itaparica</td>\n",
       "      <td>16991.0</td>\n",
       "      <td>1885.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.708172</td>\n",
       "      <td>POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2900405</td>\n",
       "      <td>Água Fria</td>\n",
       "      <td>Portal do Sertão</td>\n",
       "      <td>15659.0</td>\n",
       "      <td>2165.0</td>\n",
       "      <td>1705.0</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.129475</td>\n",
       "      <td>POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33.0</td>\n",
       "      <td>2902658</td>\n",
       "      <td>Banzaê</td>\n",
       "      <td>Semiárido Nordeste II</td>\n",
       "      <td>11801.0</td>\n",
       "      <td>1754.0</td>\n",
       "      <td>1590.0</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.923486</td>\n",
       "      <td>POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>38.0</td>\n",
       "      <td>2903102</td>\n",
       "      <td>Barra do Rocha</td>\n",
       "      <td>Médio Rio de Contas</td>\n",
       "      <td>6263.0</td>\n",
       "      <td>461.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>Mata Atlântica</td>\n",
       "      <td>0.936836</td>\n",
       "      <td>POLYGON ((-39.54388 -13.94903, -39.54394 -13.9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>42.0</td>\n",
       "      <td>2903300</td>\n",
       "      <td>Barro Preto</td>\n",
       "      <td>Litoral Sul</td>\n",
       "      <td>6447.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>257.0</td>\n",
       "      <td>Mata Atlântica</td>\n",
       "      <td>0.735178</td>\n",
       "      <td>POLYGON ((-39.39394 -14.70161, -39.39384 -14.7...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>66.0</td>\n",
       "      <td>Presidente Jânio quadros</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Santa Brigida</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Sitio do Mato</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Vitoria da Conquista</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>92.0</td>\n",
       "      <td>Palmas de MOnte Alto</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>342 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID   CD_MUN          NM_MUN             Territorio   PopRes  \\\n",
       "0         2.0  2900207           Abaré              Itaparica  16991.0   \n",
       "1         5.0  2900405       Água Fria       Portal do Sertão  15659.0   \n",
       "4        33.0  2902658          Banzaê  Semiárido Nordeste II  11801.0   \n",
       "5        38.0  2903102  Barra do Rocha    Médio Rio de Contas   6263.0   \n",
       "6        42.0  2903300     Barro Preto            Litoral Sul   6447.0   \n",
       "..        ...      ...             ...                    ...      ...   \n",
       "422       NaN      NaN             NaN                    NaN      NaN   \n",
       "423       NaN      NaN             NaN                    NaN      NaN   \n",
       "424       NaN      NaN             NaN                    NaN      NaN   \n",
       "425       NaN      NaN             NaN                    NaN      NaN   \n",
       "426       NaN      NaN             NaN                    NaN      NaN   \n",
       "\n",
       "     Est_Agrico  Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0        1885.0      1700.0                   Caatinga    1.708172   \n",
       "1        2165.0      1705.0  Caatinga e Mata Atlântica    1.129475   \n",
       "4        1754.0      1590.0                   Caatinga    0.923486   \n",
       "5         461.0       296.0             Mata Atlântica    0.936836   \n",
       "6         393.0       257.0             Mata Atlântica    0.735178   \n",
       "..          ...         ...                        ...         ...   \n",
       "422         NaN         NaN                        NaN         NaN   \n",
       "423         NaN         NaN                        NaN         NaN   \n",
       "424         NaN         NaN                        NaN         NaN   \n",
       "425         NaN         NaN                        NaN         NaN   \n",
       "426         NaN         NaN                        NaN         NaN   \n",
       "\n",
       "                                              geometry    id  \\\n",
       "0    POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...   NaN   \n",
       "1    POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...   NaN   \n",
       "4    POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...   NaN   \n",
       "5    POLYGON ((-39.54388 -13.94903, -39.54394 -13.9...   NaN   \n",
       "6    POLYGON ((-39.39394 -14.70161, -39.39384 -14.7...   NaN   \n",
       "..                                                 ...   ...   \n",
       "422                                               None  66.0   \n",
       "423                                               None  72.0   \n",
       "424                                               None  80.0   \n",
       "425                                               None  87.0   \n",
       "426                                               None  92.0   \n",
       "\n",
       "                          mun emer_seca      _merge  \n",
       "0                         NaN       NaN   left_only  \n",
       "1                         NaN       NaN   left_only  \n",
       "4                         NaN       NaN   left_only  \n",
       "5                         NaN       NaN   left_only  \n",
       "6                         NaN       NaN   left_only  \n",
       "..                        ...       ...         ...  \n",
       "422  Presidente Jânio quadros       Sim  right_only  \n",
       "423             Santa Brigida       Sim  right_only  \n",
       "424             Sitio do Mato       Sim  right_only  \n",
       "425      Vitoria da Conquista       Sim  right_only  \n",
       "426      Palmas de MOnte Alto       Sim  right_only  \n",
       "\n",
       "[342 rows x 14 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "uniao[uniao[\"_merge\"] != \"both\"] # Verifcação se tivemos ou não campos sem correspondncia. Qualquer valor diferente de \"both\" significa que a correspondência foi unilateral."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "O resultado acima serviu para evidenciar que tivemos valores que só existiam ou na esquerda ou na direita.\n",
    "Neste caso devemos corrigir todos os valores marcados com 'right_only' e refazer o merge de forma a termos\n",
    "todos os 95 municípios da lista (variável csv) com correspondência na camada dos limites municipais (variável shp)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Candido Sales</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Itiuba</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>44.0</td>\n",
       "      <td>Livramento de N° Senhora</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>51.0</td>\n",
       "      <td>Marcionilio de Souza</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>55.0</td>\n",
       "      <td>Muquém de São Francisco</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>66.0</td>\n",
       "      <td>Presidente Jânio quadros</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Santa Brigida</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Sitio do Mato</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Vitoria da Conquista</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>92.0</td>\n",
       "      <td>Palmas de MOnte Alto</td>\n",
       "      <td>Sim</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID CD_MUN NM_MUN Territorio  PopRes  Est_Agrico  Est_AgricF  \\\n",
       "417       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "418       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "419       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "420       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "421       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "422       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "423       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "424       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "425       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "426       NaN    NaN    NaN        NaN     NaN         NaN         NaN   \n",
       "\n",
       "    BiomaPredo  Shape_Leng geometry    id                       mun emer_seca  \\\n",
       "417        NaN         NaN     None  18.0             Candido Sales       Sim   \n",
       "418        NaN         NaN     None  38.0                    Itiuba       Sim   \n",
       "419        NaN         NaN     None  44.0  Livramento de N° Senhora       Sim   \n",
       "420        NaN         NaN     None  51.0      Marcionilio de Souza       Sim   \n",
       "421        NaN         NaN     None  55.0   Muquém de São Francisco       Sim   \n",
       "422        NaN         NaN     None  66.0  Presidente Jânio quadros       Sim   \n",
       "423        NaN         NaN     None  72.0             Santa Brigida       Sim   \n",
       "424        NaN         NaN     None  80.0             Sitio do Mato       Sim   \n",
       "425        NaN         NaN     None  87.0      Vitoria da Conquista       Sim   \n",
       "426        NaN         NaN     None  92.0      Palmas de MOnte Alto       Sim   \n",
       "\n",
       "         _merge  \n",
       "417  right_only  \n",
       "418  right_only  \n",
       "419  right_only  \n",
       "420  right_only  \n",
       "421  right_only  \n",
       "422  right_only  \n",
       "423  right_only  \n",
       "424  right_only  \n",
       "425  right_only  \n",
       "426  right_only  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Utilizando o loc para filtrar todos os municípios com valor 'right_only'.\n",
    "\n",
    "uniao.loc[(uniao['_merge'] == 'right_only')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Corrigindo nomes dos municípios"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Agora que identificamos quais linhas estão com erros nos nomes, podemos utilizar o replace() para realizar a correção."
   ]
  },
  {
   "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>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Cândido Sales</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id            mun emer_seca\n",
       "17  18  Cândido Sales       Sim"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Testando a correção com a função replace().\n",
    "\n",
    "csv_corrercao = csv\n",
    "csv_corrercao['mun'].replace('Candido Sales', 'Cândido Sales', inplace=True)\n",
    "csv_corrercao.loc[(csv_corrercao['mun'] == 'Cândido Sales')]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Corrigindo todos os demais municípios com a função replace().\n",
    "\n",
    "csv_corrercao['mun'].replace('Itiuba', 'Itiúba', inplace=True)\n",
    "csv_corrercao['mun'].replace('Livramento de N° Senhora', 'Livramento de Nossa Senhora', inplace=True)\n",
    "csv_corrercao['mun'].replace('Marcionilio de Souza', 'Marcionílio Souza', inplace=True)\n",
    "csv_corrercao['mun'].replace('Muquém de São Francisco', 'Muquém do São Francisco', inplace=True)\n",
    "csv_corrercao['mun'].replace('Presidente Jânio quadros', 'Presidente Jânio Quadros', inplace=True)\n",
    "csv_corrercao['mun'].replace('Santa Brigida', 'Santa Brígida', inplace=True)\n",
    "csv_corrercao['mun'].replace('Sitio do Mato', 'Sítio do Mato', inplace=True)\n",
    "csv_corrercao['mun'].replace('Vitoria da Conquista', 'Vitória da Conquista', inplace=True)\n",
    "csv_corrercao['mun'].replace('Palmas de MOnte Alto', 'Palmas de Monte Alto', inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Com os nomes corrigidos na lista csv podemos refazer o merge com a camada shapefile."
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>2900207</td>\n",
       "      <td>Abaré</td>\n",
       "      <td>Itaparica</td>\n",
       "      <td>16991</td>\n",
       "      <td>1885</td>\n",
       "      <td>1700</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.708172</td>\n",
       "      <td>POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>2900405</td>\n",
       "      <td>Água Fria</td>\n",
       "      <td>Portal do Sertão</td>\n",
       "      <td>15659</td>\n",
       "      <td>2165</td>\n",
       "      <td>1705</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.129475</td>\n",
       "      <td>POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489</td>\n",
       "      <td>2475</td>\n",
       "      <td>2065</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536</td>\n",
       "      <td>4779</td>\n",
       "      <td>3635</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>2902658</td>\n",
       "      <td>Banzaê</td>\n",
       "      <td>Semiárido Nordeste II</td>\n",
       "      <td>11801</td>\n",
       "      <td>1754</td>\n",
       "      <td>1590</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.923486</td>\n",
       "      <td>POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID   CD_MUN     NM_MUN             Territorio  PopRes  Est_Agrico  \\\n",
       "0         2  2900207      Abaré              Itaparica   16991        1885   \n",
       "1         5  2900405  Água Fria       Portal do Sertão   15659        2165   \n",
       "2        14  2901205      Anagé        Sudoeste Baiano   25489        2475   \n",
       "3        26  2902104      Araci                  Sisal   51536        4779   \n",
       "4        33  2902658     Banzaê  Semiárido Nordeste II   11801        1754   \n",
       "\n",
       "   Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0        1700                   Caatinga    1.708172   \n",
       "1        1705  Caatinga e Mata Atlântica    1.129475   \n",
       "2        2065  Caatinga e Mata Atlântica    2.296842   \n",
       "3        3635                   Caatinga    2.061252   \n",
       "4        1590                   Caatinga    0.923486   \n",
       "\n",
       "                                            geometry   id    mun emer_seca  \\\n",
       "0  POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...  NaN    NaN       NaN   \n",
       "1  POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...  NaN    NaN       NaN   \n",
       "2  POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...  1.0  Anagé       Sim   \n",
       "3  POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...  5.0  Araci       Sim   \n",
       "4  POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...  NaN    NaN       NaN   \n",
       "\n",
       "      _merge  \n",
       "0  left_only  \n",
       "1  left_only  \n",
       "2       both  \n",
       "3       both  \n",
       "4  left_only  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Refazendo a união\n",
    "\n",
    "uniao = shp.merge(csv, left_on= 'NM_MUN', right_on='mun', how='outer', indicator=True) # Realizando o merge mas identificando os campos que não tiveram correspondência\n",
    "\n",
    "uniao.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489</td>\n",
       "      <td>2475</td>\n",
       "      <td>2065</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536</td>\n",
       "      <td>4779</td>\n",
       "      <td>3635</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>47</td>\n",
       "      <td>2903805</td>\n",
       "      <td>Boa Vista do Tupim</td>\n",
       "      <td>Piemonte do Paraguaçu</td>\n",
       "      <td>17917</td>\n",
       "      <td>2536</td>\n",
       "      <td>1901</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.612894</td>\n",
       "      <td>POLYGON ((-40.56749 -12.45239, -40.56697 -12.4...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Boa Vista do Tupim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>49</td>\n",
       "      <td>2903953</td>\n",
       "      <td>Bom Jesus da Serra</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>10111</td>\n",
       "      <td>1570</td>\n",
       "      <td>1433</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.087668</td>\n",
       "      <td>POLYGON ((-40.67763 -14.32803, -40.67726 -14.3...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Bom Jesus da Serra</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>56</td>\n",
       "      <td>2904506</td>\n",
       "      <td>Brotas de Macaúbas</td>\n",
       "      <td>Velho Chico</td>\n",
       "      <td>10697</td>\n",
       "      <td>1640</td>\n",
       "      <td>1579</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>3.138704</td>\n",
       "      <td>POLYGON ((-42.75099 -11.72904, -42.75076 -11.7...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Brotas de Macaúbas</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>384</td>\n",
       "      <td>2931053</td>\n",
       "      <td>Tanque Novo</td>\n",
       "      <td>Sertão Produtivo</td>\n",
       "      <td>16108</td>\n",
       "      <td>2612</td>\n",
       "      <td>2267</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.326464</td>\n",
       "      <td>POLYGON ((-42.62353 -13.40672, -42.58339 -13.4...</td>\n",
       "      <td>82.0</td>\n",
       "      <td>Tanque Novo</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>395</td>\n",
       "      <td>2932002</td>\n",
       "      <td>Uauá</td>\n",
       "      <td>Sertão do São Francisco</td>\n",
       "      <td>24273</td>\n",
       "      <td>3215</td>\n",
       "      <td>2917</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.332941</td>\n",
       "      <td>POLYGON ((-39.32506 -9.59735, -39.32384 -9.597...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>Uauá</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>402</td>\n",
       "      <td>2932606</td>\n",
       "      <td>Urandi</td>\n",
       "      <td>Sertão Produtivo</td>\n",
       "      <td>16447</td>\n",
       "      <td>2076</td>\n",
       "      <td>1771</td>\n",
       "      <td>Cerrado e Caatinga</td>\n",
       "      <td>1.494008</td>\n",
       "      <td>POLYGON ((-42.56093 -14.52860, -42.56219 -14.5...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Urandi</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>406</td>\n",
       "      <td>2933000</td>\n",
       "      <td>Valente</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>24544</td>\n",
       "      <td>1511</td>\n",
       "      <td>1191</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.891934</td>\n",
       "      <td>POLYGON ((-39.33191 -11.34150, -39.32531 -11.3...</td>\n",
       "      <td>86.0</td>\n",
       "      <td>Valente</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>417</td>\n",
       "      <td>2933604</td>\n",
       "      <td>Xique-Xique</td>\n",
       "      <td>Irecê</td>\n",
       "      <td>45461</td>\n",
       "      <td>2453</td>\n",
       "      <td>2176</td>\n",
       "      <td>Cerrado e Caatinga</td>\n",
       "      <td>4.805813</td>\n",
       "      <td>POLYGON ((-42.38095 -10.24423, -42.37974 -10.2...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>Xique-Xique</td>\n",
       "      <td>Sim</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID   CD_MUN              NM_MUN               Territorio  PopRes  \\\n",
       "2          14  2901205               Anagé          Sudoeste Baiano   25489   \n",
       "3          26  2902104               Araci                    Sisal   51536   \n",
       "7          47  2903805  Boa Vista do Tupim    Piemonte do Paraguaçu   17917   \n",
       "8          49  2903953  Bom Jesus da Serra          Sudoeste Baiano   10111   \n",
       "9          56  2904506  Brotas de Macaúbas              Velho Chico   10697   \n",
       "..        ...      ...                 ...                      ...     ...   \n",
       "395       384  2931053         Tanque Novo         Sertão Produtivo   16108   \n",
       "402       395  2932002                Uauá  Sertão do São Francisco   24273   \n",
       "406       402  2932606              Urandi         Sertão Produtivo   16447   \n",
       "409       406  2933000             Valente                    Sisal   24544   \n",
       "416       417  2933604         Xique-Xique                    Irecê   45461   \n",
       "\n",
       "     Est_Agrico  Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "2          2475        2065  Caatinga e Mata Atlântica    2.296842   \n",
       "3          4779        3635                   Caatinga    2.061252   \n",
       "7          2536        1901                   Caatinga    2.612894   \n",
       "8          1570        1433  Caatinga e Mata Atlântica    1.087668   \n",
       "9          1640        1579                   Caatinga    3.138704   \n",
       "..          ...         ...                        ...         ...   \n",
       "395        2612        2267                   Caatinga    1.326464   \n",
       "402        3215        2917                   Caatinga    2.332941   \n",
       "406        2076        1771         Cerrado e Caatinga    1.494008   \n",
       "409        1511        1191                   Caatinga    0.891934   \n",
       "416        2453        2176         Cerrado e Caatinga    4.805813   \n",
       "\n",
       "                                              geometry    id  \\\n",
       "2    POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...   1.0   \n",
       "3    POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...   5.0   \n",
       "7    POLYGON ((-40.56749 -12.45239, -40.56697 -12.4...  10.0   \n",
       "8    POLYGON ((-40.67763 -14.32803, -40.67726 -14.3...  12.0   \n",
       "9    POLYGON ((-42.75099 -11.72904, -42.75076 -11.7...  13.0   \n",
       "..                                                 ...   ...   \n",
       "395  POLYGON ((-42.62353 -13.40672, -42.58339 -13.4...  82.0   \n",
       "402  POLYGON ((-39.32506 -9.59735, -39.32384 -9.597...  84.0   \n",
       "406  POLYGON ((-42.56093 -14.52860, -42.56219 -14.5...  85.0   \n",
       "409  POLYGON ((-39.33191 -11.34150, -39.32531 -11.3...  86.0   \n",
       "416  POLYGON ((-42.38095 -10.24423, -42.37974 -10.2...  88.0   \n",
       "\n",
       "                    mun emer_seca _merge  \n",
       "2                 Anagé       Sim   both  \n",
       "3                 Araci       Sim   both  \n",
       "7    Boa Vista do Tupim       Sim   both  \n",
       "8    Bom Jesus da Serra       Sim   both  \n",
       "9    Brotas de Macaúbas       Sim   both  \n",
       "..                  ...       ...    ...  \n",
       "395         Tanque Novo       Sim   both  \n",
       "402                Uauá       Sim   both  \n",
       "406              Urandi       Sim   both  \n",
       "409             Valente       Sim   both  \n",
       "416         Xique-Xique       Sim   both  \n",
       "\n",
       "[95 rows x 14 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checando se algum valor para 'mun' ficou sem correspondência\n",
    "\n",
    "uniao.loc[(uniao['_merge'] == 'both')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exportando para um arquivo shapefile."
   ]
  },
  {
   "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>OBJECTID</th>\n",
       "      <th>CD_MUN</th>\n",
       "      <th>NM_MUN</th>\n",
       "      <th>Territorio</th>\n",
       "      <th>PopRes</th>\n",
       "      <th>Est_Agrico</th>\n",
       "      <th>Est_AgricF</th>\n",
       "      <th>BiomaPredo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>geometry</th>\n",
       "      <th>id</th>\n",
       "      <th>mun</th>\n",
       "      <th>emer_seca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>2900207</td>\n",
       "      <td>Abaré</td>\n",
       "      <td>Itaparica</td>\n",
       "      <td>16991</td>\n",
       "      <td>1885</td>\n",
       "      <td>1700</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.708172</td>\n",
       "      <td>POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>2900405</td>\n",
       "      <td>Água Fria</td>\n",
       "      <td>Portal do Sertão</td>\n",
       "      <td>15659</td>\n",
       "      <td>2165</td>\n",
       "      <td>1705</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>1.129475</td>\n",
       "      <td>POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>2901205</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sudoeste Baiano</td>\n",
       "      <td>25489</td>\n",
       "      <td>2475</td>\n",
       "      <td>2065</td>\n",
       "      <td>Caatinga e Mata Atlântica</td>\n",
       "      <td>2.296842</td>\n",
       "      <td>POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Anagé</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26</td>\n",
       "      <td>2902104</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sisal</td>\n",
       "      <td>51536</td>\n",
       "      <td>4779</td>\n",
       "      <td>3635</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>2.061252</td>\n",
       "      <td>POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Araci</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>2902658</td>\n",
       "      <td>Banzaê</td>\n",
       "      <td>Semiárido Nordeste II</td>\n",
       "      <td>11801</td>\n",
       "      <td>1754</td>\n",
       "      <td>1590</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>0.923486</td>\n",
       "      <td>POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>409</td>\n",
       "      <td>2933158</td>\n",
       "      <td>Várzea Nova</td>\n",
       "      <td>Piemonte da Diamantina</td>\n",
       "      <td>13049</td>\n",
       "      <td>1542</td>\n",
       "      <td>1395</td>\n",
       "      <td>Caatinga</td>\n",
       "      <td>1.521162</td>\n",
       "      <td>POLYGON ((-41.23382 -10.95670, -41.13406 -10.9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>410</td>\n",
       "      <td>2933174</td>\n",
       "      <td>Varzedo</td>\n",
       "      <td>Recôncavo</td>\n",
       "      <td>9108</td>\n",
       "      <td>1354</td>\n",
       "      <td>1163</td>\n",
       "      <td>Mata Atlântica</td>\n",
       "      <td>0.755003</td>\n",
       "      <td>POLYGON ((-39.32318 -12.99110, -39.32298 -12.9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>412</td>\n",
       "      <td>2933257</td>\n",
       "      <td>Vereda</td>\n",
       "      <td>Extremo Sul</td>\n",
       "      <td>6786</td>\n",
       "      <td>284</td>\n",
       "      <td>194</td>\n",
       "      <td>Mata Atlântica</td>\n",
       "      <td>3.180570</td>\n",
       "      <td>POLYGON ((-40.40267 -16.89737, -40.40300 -16.8...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>415</td>\n",
       "      <td>2933455</td>\n",
       "      <td>Wanderley</td>\n",
       "      <td>Bacia do Rio Grande</td>\n",
       "      <td>12450</td>\n",
       "      <td>1660</td>\n",
       "      <td>1053</td>\n",
       "      <td>Cerrado</td>\n",
       "      <td>3.272708</td>\n",
       "      <td>POLYGON ((-43.82126 -11.37674, -43.81968 -11.3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>417</td>\n",
       "      <td>2933604</td>\n",
       "      <td>Xique-Xique</td>\n",
       "      <td>Irecê</td>\n",
       "      <td>45461</td>\n",
       "      <td>2453</td>\n",
       "      <td>2176</td>\n",
       "      <td>Cerrado e Caatinga</td>\n",
       "      <td>4.805813</td>\n",
       "      <td>POLYGON ((-42.38095 -10.24423, -42.37974 -10.2...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>Xique-Xique</td>\n",
       "      <td>Sim</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>417 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID   CD_MUN       NM_MUN              Territorio  PopRes  \\\n",
       "0           2  2900207        Abaré               Itaparica   16991   \n",
       "1           5  2900405    Água Fria        Portal do Sertão   15659   \n",
       "2          14  2901205        Anagé         Sudoeste Baiano   25489   \n",
       "3          26  2902104        Araci                   Sisal   51536   \n",
       "4          33  2902658       Banzaê   Semiárido Nordeste II   11801   \n",
       "..        ...      ...          ...                     ...     ...   \n",
       "412       409  2933158  Várzea Nova  Piemonte da Diamantina   13049   \n",
       "413       410  2933174      Varzedo               Recôncavo    9108   \n",
       "414       412  2933257       Vereda             Extremo Sul    6786   \n",
       "415       415  2933455    Wanderley     Bacia do Rio Grande   12450   \n",
       "416       417  2933604  Xique-Xique                   Irecê   45461   \n",
       "\n",
       "     Est_Agrico  Est_AgricF                 BiomaPredo  Shape_Leng  \\\n",
       "0          1885        1700                   Caatinga    1.708172   \n",
       "1          2165        1705  Caatinga e Mata Atlântica    1.129475   \n",
       "2          2475        2065  Caatinga e Mata Atlântica    2.296842   \n",
       "3          4779        3635                   Caatinga    2.061252   \n",
       "4          1754        1590                   Caatinga    0.923486   \n",
       "..          ...         ...                        ...         ...   \n",
       "412        1542        1395                   Caatinga    1.521162   \n",
       "413        1354        1163             Mata Atlântica    0.755003   \n",
       "414         284         194             Mata Atlântica    3.180570   \n",
       "415        1660        1053                    Cerrado    3.272708   \n",
       "416        2453        2176         Cerrado e Caatinga    4.805813   \n",
       "\n",
       "                                              geometry    id          mun  \\\n",
       "0    POLYGON ((-39.35855 -8.54733, -39.35830 -8.547...   NaN          NaN   \n",
       "1    POLYGON ((-38.64762 -11.69026, -38.64682 -11.6...   NaN          NaN   \n",
       "2    POLYGON ((-40.71652 -14.38046, -40.71652 -14.3...   1.0        Anagé   \n",
       "3    POLYGON ((-39.26250 -10.99298, -39.26168 -10.9...   5.0        Araci   \n",
       "4    POLYGON ((-38.66991 -10.48238, -38.66963 -10.4...   NaN          NaN   \n",
       "..                                                 ...   ...          ...   \n",
       "412  POLYGON ((-41.23382 -10.95670, -41.13406 -10.9...   NaN          NaN   \n",
       "413  POLYGON ((-39.32318 -12.99110, -39.32298 -12.9...   NaN          NaN   \n",
       "414  POLYGON ((-40.40267 -16.89737, -40.40300 -16.8...   NaN          NaN   \n",
       "415  POLYGON ((-43.82126 -11.37674, -43.81968 -11.3...   NaN          NaN   \n",
       "416  POLYGON ((-42.38095 -10.24423, -42.37974 -10.2...  88.0  Xique-Xique   \n",
       "\n",
       "    emer_seca  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         Sim  \n",
       "3         Sim  \n",
       "4         NaN  \n",
       "..        ...  \n",
       "412       NaN  \n",
       "413       NaN  \n",
       "414       NaN  \n",
       "415       NaN  \n",
       "416       Sim  \n",
       "\n",
       "[417 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Removendo a coluna '_merge' com a função drop().\n",
    "\n",
    "shp_seca = uniao\n",
    "\n",
    "shp_seca = shp_seca.drop(columns=['_merge'])\n",
    "\n",
    "shp_seca"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Exportando oresutado final para arquivo shapefile.\n",
    "\n",
    "shp_seca.to_file('/home/rivas/Estudos/PythonGIS/data/mun_seca2023.shp')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "pygis",
   "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.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}