prof_07_pandas_exercicios_dataframe.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "HDm4_x_SS7vM"
   },
   "source": [
    "# Pandas - DataFrames\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import re\n",
    "import numpy as np\n",
    "\n",
    "pd.options.display.max_columns = 500\n",
    "pd.options.display.max_rows = 1000"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "1aDBgkUvgeTL"
   },
   "source": [
    "## EX01\n",
    "\n",
    "* Carregue para um DataFrame a lista de municípios de fronteira do Brasil utilizando o arquivo \"dados/arq_municipios_fronteiricos.tsv\"."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1 - Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1.550</td>\n",
       "      <td>4.138</td>\n",
       "      <td>2,66</td>\n",
       "      <td>71.638.000</td>\n",
       "      <td>17.266</td>\n",
       "      <td>ni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2 - Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1.575</td>\n",
       "      <td>11.520</td>\n",
       "      <td>7,31</td>\n",
       "      <td>114.350.000</td>\n",
       "      <td>9.986</td>\n",
       "      <td>0,680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3 - Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315</td>\n",
       "      <td>7.357</td>\n",
       "      <td>23,35</td>\n",
       "      <td>44.373.000</td>\n",
       "      <td>5.944</td>\n",
       "      <td>0,743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4 - Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72.960</td>\n",
       "      <td>30.903</td>\n",
       "      <td>0,42</td>\n",
       "      <td>462.258.000</td>\n",
       "      <td>13.485</td>\n",
       "      <td>0,745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5 - Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7.067</td>\n",
       "      <td>23.857</td>\n",
       "      <td>3,37</td>\n",
       "      <td>186.812.000</td>\n",
       "      <td>6.525</td>\n",
       "      <td>0,715</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Município             Estado Área territorial  \\\n",
       "0                 1 - Aceguá  Rio Grande do Sul            1.550   \n",
       "1             2 - Acrelândia               Acre            1.575   \n",
       "2                3 - Alecrim  Rio Grande do Sul              315   \n",
       "3               4 - Almeirim               Pará           72.960   \n",
       "4  5 - Alta Floresta d'Oeste           Rondônia            7.067   \n",
       "\n",
       "  População (IBGE/2007) Densidade demográfica (hab/km2) PIB (IBGE/2005)  \\\n",
       "0                 4.138                            2,66      71.638.000   \n",
       "1                11.520                            7,31     114.350.000   \n",
       "2                 7.357                           23,35      44.373.000   \n",
       "3                30.903                            0,42     462.258.000   \n",
       "4                23.857                            3,37     186.812.000   \n",
       "\n",
       "  PIB per capita (R$) IDH/2000  \n",
       "0              17.266       ni  \n",
       "1               9.986    0,680  \n",
       "2               5.944    0,743  \n",
       "3              13.485    0,745  \n",
       "4               6.525    0,715  "
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Complete o código abaixo para realizar a leitura do arquivo\n",
    "# o arquivo utiliza tabulação como separador\n",
    "# dentro de strings a tabulação é representada como \\t\n",
    "df = pd.read_csv(\n",
    "    \"dados/arq_municipios_fronteiricos.tsv\",\n",
    "    sep='\\t',\n",
    "    encoding='utf8',\n",
    "    dtype=str,\n",
    ")\n",
    "\n",
    "\n",
    "# Visualize as 5 primeiras linhas do DataFrame\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Realize um tratamento na coluna Município para remover os números e hífens.\n",
    "    * primeiro crie uma que função recebe uma string com o nome do município, realiza a remoção dos números e hifens e retorna a nova string tratada\n",
    "    * faça os testes com a sua função até que o resultado esteja satisfatório\n",
    "    * passe a sua função como parâmetro para o método apply do DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Aceguá'"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# função que irá realizar o tratamento para um município\n",
    "def tratar_nome_municipio(nome_municipio):\n",
    "    nome_municipio_tratado = re.sub(r'([\\d]* [–-] )(.*)', r'\\2', nome_municipio)\n",
    "    return nome_municipio_tratado\n",
    "\n",
    "# faça um teste de sua função para verificar se a transformação está correta\n",
    "tratar_nome_municipio('1 - Aceguá')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "# aplique a função utilizando o método apply\n",
    "municipio_tratado = df['Município'].apply(tratar_nome_municipio)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                   Aceguá\n",
       "1               Acrelândia\n",
       "2                  Alecrim\n",
       "3                 Almeirim\n",
       "4    Alta Floresta d'Oeste\n",
       "Name: Município, dtype: object"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# exiba todos os dados e verifique se o resultado está correto\n",
    "municipio_tratado.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1.550</td>\n",
       "      <td>4.138</td>\n",
       "      <td>2,66</td>\n",
       "      <td>71.638.000</td>\n",
       "      <td>17.266</td>\n",
       "      <td>ni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1.575</td>\n",
       "      <td>11.520</td>\n",
       "      <td>7,31</td>\n",
       "      <td>114.350.000</td>\n",
       "      <td>9.986</td>\n",
       "      <td>0,680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315</td>\n",
       "      <td>7.357</td>\n",
       "      <td>23,35</td>\n",
       "      <td>44.373.000</td>\n",
       "      <td>5.944</td>\n",
       "      <td>0,743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72.960</td>\n",
       "      <td>30.903</td>\n",
       "      <td>0,42</td>\n",
       "      <td>462.258.000</td>\n",
       "      <td>13.485</td>\n",
       "      <td>0,745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7.067</td>\n",
       "      <td>23.857</td>\n",
       "      <td>3,37</td>\n",
       "      <td>186.812.000</td>\n",
       "      <td>6.525</td>\n",
       "      <td>0,715</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Município             Estado Área territorial  \\\n",
       "0                 Aceguá  Rio Grande do Sul            1.550   \n",
       "1             Acrelândia               Acre            1.575   \n",
       "2                Alecrim  Rio Grande do Sul              315   \n",
       "3               Almeirim               Pará           72.960   \n",
       "4  Alta Floresta d'Oeste           Rondônia            7.067   \n",
       "\n",
       "  População (IBGE/2007) Densidade demográfica (hab/km2) PIB (IBGE/2005)  \\\n",
       "0                 4.138                            2,66      71.638.000   \n",
       "1                11.520                            7,31     114.350.000   \n",
       "2                 7.357                           23,35      44.373.000   \n",
       "3                30.903                            0,42     462.258.000   \n",
       "4                23.857                            3,37     186.812.000   \n",
       "\n",
       "  PIB per capita (R$) IDH/2000  \n",
       "0              17.266       ni  \n",
       "1               9.986    0,680  \n",
       "2               5.944    0,743  \n",
       "3              13.485    0,745  \n",
       "4               6.525    0,715  "
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# com todos os municípios devidamente tratados\n",
    "# sobrescreva a coluna Município com os novos valores\n",
    "df['Município'] = municipio_tratado\n",
    "\n",
    "# exiba as informações\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## EX02\n",
    "\n",
    "Ainda utilizando o DataFrame carregado no exercício anterior, verifique os tipos de dados das colunas do dataframe. Todos os dados numéricos deverão ser transformados para tipos numéricos.\n",
    "\n",
    "* utilize o método info() do DataFrame para saber detalhes dos tipos de dados das colunas\n",
    "* verifique se os números possuem os símbolos de decimal e separadores de milhar compatíveis com a linguagem. Se necessário, fazer as substituições pertinentes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 122 entries, 0 to 121\n",
      "Data columns (total 8 columns):\n",
      "Município                          122 non-null object\n",
      "Estado                             122 non-null object\n",
      "Área territorial                   122 non-null object\n",
      "População (IBGE/2007)              122 non-null object\n",
      "Densidade demográfica (hab/km2)    122 non-null object\n",
      "PIB (IBGE/2005)                    122 non-null object\n",
      "PIB per capita (R$)                122 non-null object\n",
      "IDH/2000                           122 non-null object\n",
      "dtypes: object(8)\n",
      "memory usage: 7.7+ KB\n"
     ]
    }
   ],
   "source": [
    "# verifique os tipos das colunas do DataFrame: df\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1.550</td>\n",
       "      <td>4.138</td>\n",
       "      <td>2,66</td>\n",
       "      <td>71.638.000</td>\n",
       "      <td>17.266</td>\n",
       "      <td>ni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1.575</td>\n",
       "      <td>11.520</td>\n",
       "      <td>7,31</td>\n",
       "      <td>114.350.000</td>\n",
       "      <td>9.986</td>\n",
       "      <td>0,680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315</td>\n",
       "      <td>7.357</td>\n",
       "      <td>23,35</td>\n",
       "      <td>44.373.000</td>\n",
       "      <td>5.944</td>\n",
       "      <td>0,743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72.960</td>\n",
       "      <td>30.903</td>\n",
       "      <td>0,42</td>\n",
       "      <td>462.258.000</td>\n",
       "      <td>13.485</td>\n",
       "      <td>0,745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7.067</td>\n",
       "      <td>23.857</td>\n",
       "      <td>3,37</td>\n",
       "      <td>186.812.000</td>\n",
       "      <td>6.525</td>\n",
       "      <td>0,715</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Município             Estado Área territorial  \\\n",
       "0                 Aceguá  Rio Grande do Sul            1.550   \n",
       "1             Acrelândia               Acre            1.575   \n",
       "2                Alecrim  Rio Grande do Sul              315   \n",
       "3               Almeirim               Pará           72.960   \n",
       "4  Alta Floresta d'Oeste           Rondônia            7.067   \n",
       "\n",
       "  População (IBGE/2007) Densidade demográfica (hab/km2) PIB (IBGE/2005)  \\\n",
       "0                 4.138                            2,66      71.638.000   \n",
       "1                11.520                            7,31     114.350.000   \n",
       "2                 7.357                           23,35      44.373.000   \n",
       "3                30.903                            0,42     462.258.000   \n",
       "4                23.857                            3,37     186.812.000   \n",
       "\n",
       "  PIB per capita (R$) IDH/2000  \n",
       "0              17.266       ni  \n",
       "1               9.986    0,680  \n",
       "2               5.944    0,743  \n",
       "3              13.485    0,745  \n",
       "4               6.525    0,715  "
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1550.0"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# faça a conversão do campo 'Área territorial'\n",
    "def converter_para_float(texto):\n",
    "    try:\n",
    "        if type(texto) == str:\n",
    "            t = texto.replace(' ', '')\n",
    "            t = t.replace('.', '')\n",
    "            t = t.replace(',', '.')\n",
    "            n = float(t)\n",
    "            return n\n",
    "        elif type(texto) == int or type(texto) == float:\n",
    "            return texto\n",
    "    except:\n",
    "        pass\n",
    "    return np.NaN\n",
    "\n",
    "# faça os testes com a sua função\n",
    "converter_para_float('1.550')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [],
   "source": [
    "# substitua a coluna pelos valores convertidos\n",
    "df['Área territorial'] = df['Área territorial'].apply(converter_para_float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [],
   "source": [
    "# faça o mesmo para todas as colunas numéricas\n",
    "colunas = ['População (IBGE/2007)','Densidade demográfica (hab/km2)','PIB (IBGE/2005)','PIB per capita (R$)','IDH/2000']\n",
    "for c in colunas:\n",
    "    df[c] = df[c].apply(converter_para_float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [],
   "source": [
    "# outra forma\n",
    "# faça o mesmo para todas as colunas numéricas\n",
    "for c in df.columns[2:]:\n",
    "    df[c] = df[c].apply(converter_para_float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Área territorial', 'População (IBGE/2007)',\n",
       "       'Densidade demográfica (hab/km2)', 'PIB (IBGE/2005)',\n",
       "       'PIB per capita (R$)', 'IDH/2000'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns[2:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 122 entries, 0 to 121\n",
      "Data columns (total 8 columns):\n",
      "Município                          122 non-null object\n",
      "Estado                             122 non-null object\n",
      "Área territorial                   122 non-null float64\n",
      "População (IBGE/2007)              122 non-null float64\n",
      "Densidade demográfica (hab/km2)    122 non-null float64\n",
      "PIB (IBGE/2005)                    122 non-null float64\n",
      "PIB per capita (R$)                122 non-null float64\n",
      "IDH/2000                           104 non-null float64\n",
      "dtypes: float64(6), object(2)\n",
      "memory usage: 7.7+ KB\n"
     ]
    }
   ],
   "source": [
    "# imprima novamente as informações das colunas e verifique os tipos\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>4138.0</td>\n",
       "      <td>2.66</td>\n",
       "      <td>71638000.0</td>\n",
       "      <td>17266.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1575.0</td>\n",
       "      <td>11520.0</td>\n",
       "      <td>7.31</td>\n",
       "      <td>114350000.0</td>\n",
       "      <td>9986.0</td>\n",
       "      <td>0.680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315.0</td>\n",
       "      <td>7357.0</td>\n",
       "      <td>23.35</td>\n",
       "      <td>44373000.0</td>\n",
       "      <td>5944.0</td>\n",
       "      <td>0.743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72960.0</td>\n",
       "      <td>30903.0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>462258000.0</td>\n",
       "      <td>13485.0</td>\n",
       "      <td>0.745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7067.0</td>\n",
       "      <td>23857.0</td>\n",
       "      <td>3.37</td>\n",
       "      <td>186812000.0</td>\n",
       "      <td>6525.0</td>\n",
       "      <td>0.715</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Município             Estado  Área territorial  \\\n",
       "0                 Aceguá  Rio Grande do Sul            1550.0   \n",
       "1             Acrelândia               Acre            1575.0   \n",
       "2                Alecrim  Rio Grande do Sul             315.0   \n",
       "3               Almeirim               Pará           72960.0   \n",
       "4  Alta Floresta d'Oeste           Rondônia            7067.0   \n",
       "\n",
       "   População (IBGE/2007)  Densidade demográfica (hab/km2)  PIB (IBGE/2005)  \\\n",
       "0                 4138.0                             2.66       71638000.0   \n",
       "1                11520.0                             7.31      114350000.0   \n",
       "2                 7357.0                            23.35       44373000.0   \n",
       "3                30903.0                             0.42      462258000.0   \n",
       "4                23857.0                             3.37      186812000.0   \n",
       "\n",
       "   PIB per capita (R$)  IDH/2000  \n",
       "0              17266.0       NaN  \n",
       "1               9986.0     0.680  \n",
       "2               5944.0     0.743  \n",
       "3              13485.0     0.745  \n",
       "4               6525.0     0.715  "
      ]
     },
     "execution_count": 157,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# imprima novamente as primeiras linhas do DataFrame\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## EX03\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Crie uma coluna com a sigla dos estados.\n",
    "\n",
    "* crie um set à partir da coluna Estados. Atribua a uma variável chamada __nomes_estados__."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Acre',\n",
       " 'Amapá',\n",
       " 'Amazonas',\n",
       " 'Mato Grosso',\n",
       " 'Mato Grosso do Sul',\n",
       " 'Paraná',\n",
       " 'Pará',\n",
       " 'Rio Grande do Sul',\n",
       " 'Rondônia',\n",
       " 'Roraima',\n",
       " 'Santa Cataria',\n",
       " 'Santa Catarina'}"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# crie o set e verifique o seu conteúdo\n",
    "nomes_estados = set(df['Estado'])\n",
    "nomes_estados"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "Você identificou um problema no nome dos estados?\n",
    "Vamos corrigir no final.\n",
    "\n",
    "* crie um dicionário onde o nome completo do estado é a chave e a sigla é o valor: __dic_nomes_siglas__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crie o dicionário\n",
    "dic_nomes_siglas = {'Acre': 'AC',\n",
    " 'Amapá': 'AP',\n",
    " 'Amazonas': 'AM',\n",
    " 'Mato Grosso': 'MT',\n",
    " 'Mato Grosso do Sul': 'MS',\n",
    " 'Paraná': 'PR',\n",
    " 'Pará': 'PA',\n",
    " 'Rio Grande do Sul': 'RS',\n",
    " 'Rondônia': 'RO',\n",
    " 'Roraima': 'RR',\n",
    " 'Santa Cataria': 'SC',\n",
    " 'Santa Catarina': 'SC',\n",
    "}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "* utilize a função map da série para criar uma nova coluna de siglas à partir dos nomes dos estados. Passe o dicionário criado para a função map. Atribua a Série criada à variável __coluna_siglas_uf__."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    RS\n",
       "1    AC\n",
       "2    RS\n",
       "3    PA\n",
       "4    RO\n",
       "5    RR\n",
       "6    RO\n",
       "7    RR\n",
       "8    MS\n",
       "9    MS\n",
       "Name: Estado, dtype: object"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# faça o mapeamento dos valores e atribua a : coluna_siglas_uf\n",
    "coluna_siglas_uf = df['Estado'].map(dic_nomes_siglas)\n",
    "\n",
    "# verifique os 10 primeiros itens criados\n",
    "coluna_siglas_uf.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "      <th>sigla</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>4138.0</td>\n",
       "      <td>2.66</td>\n",
       "      <td>71638000.0</td>\n",
       "      <td>17266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1575.0</td>\n",
       "      <td>11520.0</td>\n",
       "      <td>7.31</td>\n",
       "      <td>114350000.0</td>\n",
       "      <td>9986.0</td>\n",
       "      <td>0.680</td>\n",
       "      <td>AC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315.0</td>\n",
       "      <td>7357.0</td>\n",
       "      <td>23.35</td>\n",
       "      <td>44373000.0</td>\n",
       "      <td>5944.0</td>\n",
       "      <td>0.743</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72960.0</td>\n",
       "      <td>30903.0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>462258000.0</td>\n",
       "      <td>13485.0</td>\n",
       "      <td>0.745</td>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7067.0</td>\n",
       "      <td>23857.0</td>\n",
       "      <td>3.37</td>\n",
       "      <td>186812000.0</td>\n",
       "      <td>6525.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>RO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Município             Estado  Área territorial  \\\n",
       "0                 Aceguá  Rio Grande do Sul            1550.0   \n",
       "1             Acrelândia               Acre            1575.0   \n",
       "2                Alecrim  Rio Grande do Sul             315.0   \n",
       "3               Almeirim               Pará           72960.0   \n",
       "4  Alta Floresta d'Oeste           Rondônia            7067.0   \n",
       "\n",
       "   População (IBGE/2007)  Densidade demográfica (hab/km2)  PIB (IBGE/2005)  \\\n",
       "0                 4138.0                             2.66       71638000.0   \n",
       "1                11520.0                             7.31      114350000.0   \n",
       "2                 7357.0                            23.35       44373000.0   \n",
       "3                30903.0                             0.42      462258000.0   \n",
       "4                23857.0                             3.37      186812000.0   \n",
       "\n",
       "   PIB per capita (R$)  IDH/2000 sigla  \n",
       "0              17266.0       NaN    RS  \n",
       "1               9986.0     0.680    AC  \n",
       "2               5944.0     0.743    RS  \n",
       "3              13485.0     0.745    PA  \n",
       "4               6525.0     0.715    RO  "
      ]
     },
     "execution_count": 161,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# crie a coluna sigla\n",
    "df['sigla'] = coluna_siglas_uf\n",
    "\n",
    "# verifique as informações do dataframe\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rio Grande do Sul     29\n",
       "Paraná                17\n",
       "Acre                  17\n",
       "Mato Grosso do Sul    12\n",
       "Amazonas               9\n",
       "Santa Catarina         9\n",
       "Roraima                9\n",
       "Rondônia               9\n",
       "Mato Grosso            5\n",
       "Pará                   3\n",
       "Amapá                  2\n",
       "Santa Cataria          1\n",
       "Name: Estado, dtype: int64"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# verifique quantos registros possuem o nome do estado de Santa Catarina escrito errado\n",
    "df['Estado'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "# faça a correção dos registros que possuem o nome do estado de Santa Catarina escrito errado\n",
    "df.loc[df['Estado'] == 'Santa Cataria', 'Estado'] = 'Santa Catarina'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rio Grande do Sul     29\n",
       "Paraná                17\n",
       "Acre                  17\n",
       "Mato Grosso do Sul    12\n",
       "Santa Catarina        10\n",
       "Amazonas               9\n",
       "Roraima                9\n",
       "Rondônia               9\n",
       "Mato Grosso            5\n",
       "Pará                   3\n",
       "Amapá                  2\n",
       "Name: Estado, dtype: int64"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# verifique, novamente, quantos registros possuem o nome do estado de Santa Catarina escrito errado\n",
    "df['Estado'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## EX04\n",
    "\n",
    "Identifique quais municípios possuem 2 ou mais desvios na coluna PIB."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   -0.258100\n",
       "1   -0.183876\n",
       "2   -0.305481\n",
       "3    0.420717\n",
       "4   -0.057952\n",
       "Name: PIB (IBGE/2005), dtype: float64"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# normalize a coluna PIB em quantidade de desvios padrão\n",
    "s_desvios = \\\n",
    "    (df['PIB (IBGE/2005)'] - df['PIB (IBGE/2005)'].mean()) / df['PIB (IBGE/2005)'].std()\n",
    "df['PIB Normalizado'] = s_desvios\n",
    "s_desvios.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "      <th>sigla</th>\n",
       "      <th>PIB Normalizado</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Corumbá</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>65304.0</td>\n",
       "      <td>114279.0</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.557253e+09</td>\n",
       "      <td>13234.0</td>\n",
       "      <td>0.771</td>\n",
       "      <td>MS</td>\n",
       "      <td>2.323594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Foz do Iguaçu</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>618.0</td>\n",
       "      <td>311336.0</td>\n",
       "      <td>503.70</td>\n",
       "      <td>4.853331e+09</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>0.802</td>\n",
       "      <td>PR</td>\n",
       "      <td>8.051502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>34082.0</td>\n",
       "      <td>369345.0</td>\n",
       "      <td>10.83</td>\n",
       "      <td>3.656512e+09</td>\n",
       "      <td>9779.0</td>\n",
       "      <td>0.763</td>\n",
       "      <td>RO</td>\n",
       "      <td>5.971676</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Município              Estado  Área territorial  \\\n",
       "33        Corumbá  Mato Grosso do Sul           65304.0   \n",
       "45  Foz do Iguaçu              Paraná             618.0   \n",
       "89    Porto Velho            Rondônia           34082.0   \n",
       "\n",
       "    População (IBGE/2007)  Densidade demográfica (hab/km2)  PIB (IBGE/2005)  \\\n",
       "33               114279.0                             1.74     1.557253e+09   \n",
       "45               311336.0                           503.70     4.853331e+09   \n",
       "89               369345.0                            10.83     3.656512e+09   \n",
       "\n",
       "    PIB per capita (R$)  IDH/2000 sigla  PIB Normalizado  \n",
       "33              13234.0     0.771    MS         2.323594  \n",
       "45              16102.0     0.802    PR         8.051502  \n",
       "89               9779.0     0.763    RO         5.971676  "
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# quais cidades possuem mais de 2 desvios \n",
    "filtro = (s_desvios > 2) | (s_desvios < -2)\n",
    "df[filtro]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## EX05\n",
    "\n",
    "Perguntas rápidas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18"
      ]
     },
     "execution_count": 170,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# quantos registros possuem NaN na coluna IDH/2000?\n",
    "df['IDH/2000'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    104\n",
       "True      18\n",
       "Name: IDH/2000, dtype: int64"
      ]
     },
     "execution_count": 171,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['IDH/2000'].isnull().value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rio Grande do Sul     29\n",
       "Paraná                17\n",
       "Acre                  17\n",
       "Mato Grosso do Sul    12\n",
       "Santa Catarina        10\n",
       "Amazonas               9\n",
       "Roraima                9\n",
       "Rondônia               9\n",
       "Mato Grosso            5\n",
       "Pará                   3\n",
       "Amapá                  2\n",
       "Name: Estado, dtype: int64"
      ]
     },
     "execution_count": 172,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# quantas cidades por estado?\n",
    "df['Estado'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "# faça a ordenação do DataFrame pelo nome do município\n",
    "# a ordenação está correta?\n",
    "\n",
    "from libs.texto import TratamentoTexto"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Município</th>\n",
       "      <th>Estado</th>\n",
       "      <th>Área territorial</th>\n",
       "      <th>População (IBGE/2007)</th>\n",
       "      <th>Densidade demográfica (hab/km2)</th>\n",
       "      <th>PIB (IBGE/2005)</th>\n",
       "      <th>PIB per capita (R$)</th>\n",
       "      <th>IDH/2000</th>\n",
       "      <th>sigla</th>\n",
       "      <th>PIB Normalizado</th>\n",
       "      <th>MunicípioSA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aceguá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>4138.0</td>\n",
       "      <td>2.66</td>\n",
       "      <td>7.163800e+07</td>\n",
       "      <td>17266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.258100</td>\n",
       "      <td>Acegua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acrelândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1575.0</td>\n",
       "      <td>11520.0</td>\n",
       "      <td>7.31</td>\n",
       "      <td>1.143500e+08</td>\n",
       "      <td>9986.0</td>\n",
       "      <td>0.680</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.183876</td>\n",
       "      <td>Acrelandia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alecrim</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>315.0</td>\n",
       "      <td>7357.0</td>\n",
       "      <td>23.35</td>\n",
       "      <td>4.437300e+07</td>\n",
       "      <td>5944.0</td>\n",
       "      <td>0.743</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.305481</td>\n",
       "      <td>Alecrim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almeirim</td>\n",
       "      <td>Pará</td>\n",
       "      <td>72960.0</td>\n",
       "      <td>30903.0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>4.622580e+08</td>\n",
       "      <td>13485.0</td>\n",
       "      <td>0.745</td>\n",
       "      <td>PA</td>\n",
       "      <td>0.420717</td>\n",
       "      <td>Almeirim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>7067.0</td>\n",
       "      <td>23857.0</td>\n",
       "      <td>3.37</td>\n",
       "      <td>1.868120e+08</td>\n",
       "      <td>6525.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.057952</td>\n",
       "      <td>Alta Floresta d'Oeste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alto Alegre</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>25567.0</td>\n",
       "      <td>14386.0</td>\n",
       "      <td>0.56</td>\n",
       "      <td>1.157860e+08</td>\n",
       "      <td>5239.0</td>\n",
       "      <td>0.662</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.181380</td>\n",
       "      <td>Alto Alegre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alto Alegre dos Parecis</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>3959.0</td>\n",
       "      <td>11615.0</td>\n",
       "      <td>2.93</td>\n",
       "      <td>9.022600e+07</td>\n",
       "      <td>6001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.225798</td>\n",
       "      <td>Alto Alegre dos Parecis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Amajari</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>28472.0</td>\n",
       "      <td>7586.0</td>\n",
       "      <td>0.26</td>\n",
       "      <td>3.189700e+04</td>\n",
       "      <td>5240000.0</td>\n",
       "      <td>0.654</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.382537</td>\n",
       "      <td>Amajari</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Antônio João</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>1144.0</td>\n",
       "      <td>8350.0</td>\n",
       "      <td>7.29</td>\n",
       "      <td>3.998900e+07</td>\n",
       "      <td>5067.0</td>\n",
       "      <td>0.702</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.313100</td>\n",
       "      <td>Antonio Joao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Aral Moreira</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>1656.0</td>\n",
       "      <td>9236.0</td>\n",
       "      <td>5.57</td>\n",
       "      <td>1.056970e+08</td>\n",
       "      <td>13132.0</td>\n",
       "      <td>0.723</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.198913</td>\n",
       "      <td>Aral Moreira</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Assis Brasil</td>\n",
       "      <td>Acre</td>\n",
       "      <td>2876.0</td>\n",
       "      <td>5351.0</td>\n",
       "      <td>1.86</td>\n",
       "      <td>3.029800e+07</td>\n",
       "      <td>5984.0</td>\n",
       "      <td>0.670</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.329941</td>\n",
       "      <td>Assis Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Atalaia do Norte</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>76355.0</td>\n",
       "      <td>13682.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>2.902800e+07</td>\n",
       "      <td>2570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.332148</td>\n",
       "      <td>Atalaia do Norte</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Bagé</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>4096.0</td>\n",
       "      <td>112550.0</td>\n",
       "      <td>27.47</td>\n",
       "      <td>9.064880e+08</td>\n",
       "      <td>7473.0</td>\n",
       "      <td>0.802</td>\n",
       "      <td>RS</td>\n",
       "      <td>1.192698</td>\n",
       "      <td>Bage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Bandeirante</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>146.0</td>\n",
       "      <td>3028.0</td>\n",
       "      <td>20.73</td>\n",
       "      <td>2.142300e+07</td>\n",
       "      <td>7546.0</td>\n",
       "      <td>0.765</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.345364</td>\n",
       "      <td>Bandeirante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Barcelos</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>122476.0</td>\n",
       "      <td>24567.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>7.200400e+07</td>\n",
       "      <td>2238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.257464</td>\n",
       "      <td>Barcelos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Barra do Quaraí</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1056.0</td>\n",
       "      <td>3776.0</td>\n",
       "      <td>3.57</td>\n",
       "      <td>6.154000e+07</td>\n",
       "      <td>14429.0</td>\n",
       "      <td>0.777</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.275649</td>\n",
       "      <td>Barra do Quarai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Barracão</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>164.0</td>\n",
       "      <td>9027.0</td>\n",
       "      <td>55.04</td>\n",
       "      <td>6.060100e+07</td>\n",
       "      <td>6718.0</td>\n",
       "      <td>0.764</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.277281</td>\n",
       "      <td>Barracao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Bela Vista</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>4896.0</td>\n",
       "      <td>22868.0</td>\n",
       "      <td>4.67</td>\n",
       "      <td>1.328700e+08</td>\n",
       "      <td>5676.0</td>\n",
       "      <td>0.755</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.151692</td>\n",
       "      <td>Bela Vista</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Belmonte</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>94.0</td>\n",
       "      <td>2681.0</td>\n",
       "      <td>28.52</td>\n",
       "      <td>2.167000e+07</td>\n",
       "      <td>9954.0</td>\n",
       "      <td>0.759</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.344935</td>\n",
       "      <td>Belmonte</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Benjamin Constant</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>8793.0</td>\n",
       "      <td>9268.0</td>\n",
       "      <td>3.32</td>\n",
       "      <td>8.212000e+07</td>\n",
       "      <td>3135.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.239885</td>\n",
       "      <td>Benjamin Constant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Bom Jesus do Sul</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>174.0</td>\n",
       "      <td>3835.0</td>\n",
       "      <td>22.04</td>\n",
       "      <td>1.795000e+07</td>\n",
       "      <td>4638.0</td>\n",
       "      <td>0.696</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.351399</td>\n",
       "      <td>Bom Jesus do Sul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bonfim</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>8095.0</td>\n",
       "      <td>10231.0</td>\n",
       "      <td>1.26</td>\n",
       "      <td>6.836300e+07</td>\n",
       "      <td>5414.0</td>\n",
       "      <td>0.654</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.263792</td>\n",
       "      <td>Bonfim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Brasiléia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>4336.0</td>\n",
       "      <td>19065.0</td>\n",
       "      <td>4.39</td>\n",
       "      <td>1.175250e+08</td>\n",
       "      <td>6632.0</td>\n",
       "      <td>0.669</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.178358</td>\n",
       "      <td>Brasileia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Cabixi</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>1314.0</td>\n",
       "      <td>6575.0</td>\n",
       "      <td>5.00</td>\n",
       "      <td>7.712500e+07</td>\n",
       "      <td>10372.0</td>\n",
       "      <td>0.705</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.248565</td>\n",
       "      <td>Cabixi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Cáceres</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>24398.0</td>\n",
       "      <td>84175.0</td>\n",
       "      <td>3.45</td>\n",
       "      <td>5.966540e+08</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>0.737</td>\n",
       "      <td>MT</td>\n",
       "      <td>0.654270</td>\n",
       "      <td>Caceres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Capanema</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>419.0</td>\n",
       "      <td>18103.0</td>\n",
       "      <td>43.20</td>\n",
       "      <td>1.805190e+08</td>\n",
       "      <td>10297.0</td>\n",
       "      <td>0.803</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.068888</td>\n",
       "      <td>Capanema</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Capixaba</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1713.0</td>\n",
       "      <td>8446.0</td>\n",
       "      <td>4.93</td>\n",
       "      <td>7.838900e+07</td>\n",
       "      <td>11092.0</td>\n",
       "      <td>0.607</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.246369</td>\n",
       "      <td>Capixaba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Caracaraí</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>47411.0</td>\n",
       "      <td>17981.0</td>\n",
       "      <td>0.37</td>\n",
       "      <td>1.008850e+08</td>\n",
       "      <td>5685.0</td>\n",
       "      <td>0.702</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.207275</td>\n",
       "      <td>Caracarai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Caracol</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>2939.0</td>\n",
       "      <td>5095.0</td>\n",
       "      <td>1.73</td>\n",
       "      <td>4.553300e+07</td>\n",
       "      <td>9094.0</td>\n",
       "      <td>0.725</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.303466</td>\n",
       "      <td>Caracol</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Caroebe</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>12066.0</td>\n",
       "      <td>7086.0</td>\n",
       "      <td>0.58</td>\n",
       "      <td>4.229600e+07</td>\n",
       "      <td>7207.0</td>\n",
       "      <td>0.661</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.309091</td>\n",
       "      <td>Caroebe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Chuí</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>203.0</td>\n",
       "      <td>5278.0</td>\n",
       "      <td>26.00</td>\n",
       "      <td>6.752500e+07</td>\n",
       "      <td>10574.0</td>\n",
       "      <td>0.811</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.265248</td>\n",
       "      <td>Chui</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Comodoro</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>21743.0</td>\n",
       "      <td>17939.0</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1.699190e+08</td>\n",
       "      <td>9010.0</td>\n",
       "      <td>0.724</td>\n",
       "      <td>MT</td>\n",
       "      <td>-0.087308</td>\n",
       "      <td>Comodoro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Coronel Sapucaia</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>1029.0</td>\n",
       "      <td>13979.0</td>\n",
       "      <td>13.58</td>\n",
       "      <td>5.479700e+07</td>\n",
       "      <td>4041.0</td>\n",
       "      <td>0.713</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.287367</td>\n",
       "      <td>Coronel Sapucaia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Corumbá</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>65304.0</td>\n",
       "      <td>114279.0</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.557253e+09</td>\n",
       "      <td>13234.0</td>\n",
       "      <td>0.771</td>\n",
       "      <td>MS</td>\n",
       "      <td>2.323594</td>\n",
       "      <td>Corumba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Costa Marques</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>12722.0</td>\n",
       "      <td>13664.0</td>\n",
       "      <td>1.07</td>\n",
       "      <td>6.302200e+07</td>\n",
       "      <td>5553.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.273073</td>\n",
       "      <td>Costa Marques</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Crissiumal</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>362.0</td>\n",
       "      <td>14726.0</td>\n",
       "      <td>40.67</td>\n",
       "      <td>1.140890e+08</td>\n",
       "      <td>8376.0</td>\n",
       "      <td>0.786</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.184329</td>\n",
       "      <td>Crissiumal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Cruzeiro do Sul</td>\n",
       "      <td>Acre</td>\n",
       "      <td>7925.0</td>\n",
       "      <td>73948.0</td>\n",
       "      <td>9.33</td>\n",
       "      <td>3.919430e+08</td>\n",
       "      <td>4647.0</td>\n",
       "      <td>0.668</td>\n",
       "      <td>AC</td>\n",
       "      <td>0.298524</td>\n",
       "      <td>Cruzeiro do Sul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Derrubadas</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>361.0</td>\n",
       "      <td>3378.0</td>\n",
       "      <td>9.35</td>\n",
       "      <td>2.281600e+07</td>\n",
       "      <td>7046.0</td>\n",
       "      <td>0.759</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.342943</td>\n",
       "      <td>Derrubadas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Dionísio Cerqueira</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>378.0</td>\n",
       "      <td>14792.0</td>\n",
       "      <td>39.13</td>\n",
       "      <td>9.175700e+07</td>\n",
       "      <td>6293.0</td>\n",
       "      <td>0.747</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.223138</td>\n",
       "      <td>Dionisio Cerqueira</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Dom Pedrito</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>5192.0</td>\n",
       "      <td>38148.0</td>\n",
       "      <td>7.34</td>\n",
       "      <td>3.998840e+08</td>\n",
       "      <td>9547.0</td>\n",
       "      <td>0.783</td>\n",
       "      <td>RS</td>\n",
       "      <td>0.312324</td>\n",
       "      <td>Dom Pedrito</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Doutor Maurício Cardoso</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>256.0</td>\n",
       "      <td>5494.0</td>\n",
       "      <td>21.46</td>\n",
       "      <td>4.411200e+07</td>\n",
       "      <td>7635.0</td>\n",
       "      <td>0.765</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.305935</td>\n",
       "      <td>Doutor Mauricio Cardoso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Entre Rios do Oeste</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>122.0</td>\n",
       "      <td>3842.0</td>\n",
       "      <td>31.49</td>\n",
       "      <td>4.318500e+07</td>\n",
       "      <td>12063.0</td>\n",
       "      <td>0.847</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.307546</td>\n",
       "      <td>Entre Rios do Oeste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Epitaciolândia</td>\n",
       "      <td>Acre</td>\n",
       "      <td>1659.0</td>\n",
       "      <td>13434.0</td>\n",
       "      <td>8.59</td>\n",
       "      <td>8.816400e+07</td>\n",
       "      <td>6397.0</td>\n",
       "      <td>0.684</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.229382</td>\n",
       "      <td>Epitaciolandia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Esperança do Sul</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>148.0</td>\n",
       "      <td>3445.0</td>\n",
       "      <td>23.27</td>\n",
       "      <td>2.239900e+07</td>\n",
       "      <td>6753.0</td>\n",
       "      <td>0.708</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.343668</td>\n",
       "      <td>Esperanca do Sul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Feijó</td>\n",
       "      <td>Acre</td>\n",
       "      <td>24202.0</td>\n",
       "      <td>31288.0</td>\n",
       "      <td>1.29</td>\n",
       "      <td>1.449770e+08</td>\n",
       "      <td>3791.0</td>\n",
       "      <td>0.541</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.130652</td>\n",
       "      <td>Feijo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Foz do Iguaçu</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>618.0</td>\n",
       "      <td>311336.0</td>\n",
       "      <td>503.70</td>\n",
       "      <td>4.853331e+09</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>0.802</td>\n",
       "      <td>PR</td>\n",
       "      <td>8.051502</td>\n",
       "      <td>Foz do Iguacu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Garruchos</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>800.0</td>\n",
       "      <td>3457.0</td>\n",
       "      <td>4.32</td>\n",
       "      <td>1.429760e+08</td>\n",
       "      <td>35798.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.134130</td>\n",
       "      <td>Garruchos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Guaíra</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>561.0</td>\n",
       "      <td>28683.0</td>\n",
       "      <td>51.12</td>\n",
       "      <td>2.621570e+08</td>\n",
       "      <td>9424.0</td>\n",
       "      <td>0.777</td>\n",
       "      <td>PR</td>\n",
       "      <td>0.072982</td>\n",
       "      <td>Guaira</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Guajará</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>8904.0</td>\n",
       "      <td>14102.0</td>\n",
       "      <td>1.58</td>\n",
       "      <td>3.656400e+07</td>\n",
       "      <td>3030.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.319052</td>\n",
       "      <td>Guajara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Guajará Mirim</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>24856.0</td>\n",
       "      <td>39451.0</td>\n",
       "      <td>1.58</td>\n",
       "      <td>3.455110e+08</td>\n",
       "      <td>8332.0</td>\n",
       "      <td>0.740</td>\n",
       "      <td>RO</td>\n",
       "      <td>0.217835</td>\n",
       "      <td>Guajara Mirim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Guaraciaba</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>331.0</td>\n",
       "      <td>10604.0</td>\n",
       "      <td>32.03</td>\n",
       "      <td>1.036420e+08</td>\n",
       "      <td>10111.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.202484</td>\n",
       "      <td>Guaraciaba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Herval</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1758.0</td>\n",
       "      <td>6873.0</td>\n",
       "      <td>3.90</td>\n",
       "      <td>4.622900e+07</td>\n",
       "      <td>6151.0</td>\n",
       "      <td>0.754</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.302256</td>\n",
       "      <td>Herval</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Iracema</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>14119.0</td>\n",
       "      <td>5863.0</td>\n",
       "      <td>0.41</td>\n",
       "      <td>4.673500e+07</td>\n",
       "      <td>7712.0</td>\n",
       "      <td>0.713</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.301377</td>\n",
       "      <td>Iracema</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Itaipulândia</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>336.0</td>\n",
       "      <td>8581.0</td>\n",
       "      <td>25.53</td>\n",
       "      <td>8.315800e+07</td>\n",
       "      <td>9782.0</td>\n",
       "      <td>0.760</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.238081</td>\n",
       "      <td>Itaipulandia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Itapiranga</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>280.0</td>\n",
       "      <td>15238.0</td>\n",
       "      <td>54.42</td>\n",
       "      <td>2.986820e+08</td>\n",
       "      <td>22447.0</td>\n",
       "      <td>0.832</td>\n",
       "      <td>SC</td>\n",
       "      <td>0.136455</td>\n",
       "      <td>Itapiranga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Itaqui</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>3404.0</td>\n",
       "      <td>36361.0</td>\n",
       "      <td>10.68</td>\n",
       "      <td>4.870620e+08</td>\n",
       "      <td>11494.0</td>\n",
       "      <td>0.801</td>\n",
       "      <td>RS</td>\n",
       "      <td>0.463821</td>\n",
       "      <td>Itaqui</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Jaguarão</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>2054.0</td>\n",
       "      <td>27944.0</td>\n",
       "      <td>13.60</td>\n",
       "      <td>1.930180e+08</td>\n",
       "      <td>6116.0</td>\n",
       "      <td>0.764</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.047167</td>\n",
       "      <td>Jaguarao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Japorã</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>420.0</td>\n",
       "      <td>7362.0</td>\n",
       "      <td>17.52</td>\n",
       "      <td>2.397600e+07</td>\n",
       "      <td>3350.0</td>\n",
       "      <td>0.636</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.340927</td>\n",
       "      <td>Japora</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Japurá</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>55791.0</td>\n",
       "      <td>5281.0</td>\n",
       "      <td>0.09</td>\n",
       "      <td>2.710000e+07</td>\n",
       "      <td>2080.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.335498</td>\n",
       "      <td>Japura</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Jordão</td>\n",
       "      <td>Acre</td>\n",
       "      <td>5429.0</td>\n",
       "      <td>6059.0</td>\n",
       "      <td>1.11</td>\n",
       "      <td>2.380500e+07</td>\n",
       "      <td>5138.0</td>\n",
       "      <td>0.475</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.341224</td>\n",
       "      <td>Jordao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Laranjal do Jari</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>30966.0</td>\n",
       "      <td>37491.0</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1.829010e+08</td>\n",
       "      <td>5099.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AP</td>\n",
       "      <td>-0.064748</td>\n",
       "      <td>Laranjal do Jari</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Mâncio Lima</td>\n",
       "      <td>Acre</td>\n",
       "      <td>4672.0</td>\n",
       "      <td>13785.0</td>\n",
       "      <td>2.95</td>\n",
       "      <td>4.970500e+07</td>\n",
       "      <td>3899.0</td>\n",
       "      <td>0.642</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.296216</td>\n",
       "      <td>Mancio Lima</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Manoel Urbano</td>\n",
       "      <td>Acre</td>\n",
       "      <td>9387.0</td>\n",
       "      <td>7148.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>3.126800e+07</td>\n",
       "      <td>4095.0</td>\n",
       "      <td>0.601</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.328255</td>\n",
       "      <td>Manoel Urbano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Marechal Rondon</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>748.0</td>\n",
       "      <td>44562.0</td>\n",
       "      <td>59.57</td>\n",
       "      <td>6.328180e+08</td>\n",
       "      <td>14155.0</td>\n",
       "      <td>0.829</td>\n",
       "      <td>PR</td>\n",
       "      <td>0.717115</td>\n",
       "      <td>Marechal Rondon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Marechal Thaumaturgo</td>\n",
       "      <td>Acre</td>\n",
       "      <td>7744.0</td>\n",
       "      <td>13061.0</td>\n",
       "      <td>1.68</td>\n",
       "      <td>3.764500e+07</td>\n",
       "      <td>4452.0</td>\n",
       "      <td>0.533</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.317173</td>\n",
       "      <td>Marechal Thaumaturgo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Mercedes</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>201.0</td>\n",
       "      <td>4713.0</td>\n",
       "      <td>23.44</td>\n",
       "      <td>5.448000e+07</td>\n",
       "      <td>11210.0</td>\n",
       "      <td>0.816</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.287918</td>\n",
       "      <td>Mercedes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Mundo Novo</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>479.0</td>\n",
       "      <td>15968.0</td>\n",
       "      <td>33.33</td>\n",
       "      <td>9.824700e+07</td>\n",
       "      <td>6884.0</td>\n",
       "      <td>0.761</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.211860</td>\n",
       "      <td>Mundo Novo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Normandia</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>6967.0</td>\n",
       "      <td>7118.0</td>\n",
       "      <td>1.02</td>\n",
       "      <td>5.107100e+07</td>\n",
       "      <td>9573.0</td>\n",
       "      <td>0.600</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.293842</td>\n",
       "      <td>Normandia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Nova Mamoré</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>10072.0</td>\n",
       "      <td>21162.0</td>\n",
       "      <td>2.10</td>\n",
       "      <td>1.245380e+08</td>\n",
       "      <td>6388.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.166171</td>\n",
       "      <td>Nova Mamore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Novo Machado</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>219.0</td>\n",
       "      <td>4246.0</td>\n",
       "      <td>19.38</td>\n",
       "      <td>2.521000e+07</td>\n",
       "      <td>5922.0</td>\n",
       "      <td>0.773</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.338783</td>\n",
       "      <td>Novo Machado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Óbidos</td>\n",
       "      <td>Pará</td>\n",
       "      <td>28021.0</td>\n",
       "      <td>46793.0</td>\n",
       "      <td>1.66</td>\n",
       "      <td>1.384890e+08</td>\n",
       "      <td>2820.0</td>\n",
       "      <td>0.681</td>\n",
       "      <td>PA</td>\n",
       "      <td>-0.141927</td>\n",
       "      <td>Obidos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Oiapoque</td>\n",
       "      <td>Amapá</td>\n",
       "      <td>22625.0</td>\n",
       "      <td>19181.0</td>\n",
       "      <td>0.84</td>\n",
       "      <td>1.432440e+08</td>\n",
       "      <td>8828.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AP</td>\n",
       "      <td>-0.133664</td>\n",
       "      <td>Oiapoque</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Oriximiná</td>\n",
       "      <td>Pará</td>\n",
       "      <td>107603.0</td>\n",
       "      <td>55175.0</td>\n",
       "      <td>0.51</td>\n",
       "      <td>7.768450e+08</td>\n",
       "      <td>14620.0</td>\n",
       "      <td>0.717</td>\n",
       "      <td>PA</td>\n",
       "      <td>0.967405</td>\n",
       "      <td>Oriximina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Pacaraima</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>8028.0</td>\n",
       "      <td>8640.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>6.060800e+07</td>\n",
       "      <td>7378.0</td>\n",
       "      <td>0.718</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.277268</td>\n",
       "      <td>Pacaraima</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Paraíso</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>179.0</td>\n",
       "      <td>4195.0</td>\n",
       "      <td>23.43</td>\n",
       "      <td>3.360500e+07</td>\n",
       "      <td>8312.0</td>\n",
       "      <td>0.773</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.324194</td>\n",
       "      <td>Paraiso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Paranhos</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>1302.0</td>\n",
       "      <td>11092.0</td>\n",
       "      <td>8.51</td>\n",
       "      <td>4.370300e+07</td>\n",
       "      <td>4094.0</td>\n",
       "      <td>0.676</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.306646</td>\n",
       "      <td>Paranhos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Pato Bragado</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4631.0</td>\n",
       "      <td>34.30</td>\n",
       "      <td>4.169700e+07</td>\n",
       "      <td>9542.0</td>\n",
       "      <td>0.821</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.310132</td>\n",
       "      <td>Pato Bragado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Pedras Altas</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>1377.0</td>\n",
       "      <td>2546.0</td>\n",
       "      <td>1.84</td>\n",
       "      <td>2.782900e+07</td>\n",
       "      <td>10135.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.334232</td>\n",
       "      <td>Pedras Altas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pérola d'Oeste</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>206.0</td>\n",
       "      <td>7046.0</td>\n",
       "      <td>34.20</td>\n",
       "      <td>4.578100e+07</td>\n",
       "      <td>6961.0</td>\n",
       "      <td>0.759</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.303035</td>\n",
       "      <td>Perola d'Oeste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Pimenteiras do Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>6015.0</td>\n",
       "      <td>2358.0</td>\n",
       "      <td>0.39</td>\n",
       "      <td>3.716300e+07</td>\n",
       "      <td>14201.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.318011</td>\n",
       "      <td>Pimenteiras do Oeste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Pirapó</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>292.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>10.23</td>\n",
       "      <td>1.796000e+07</td>\n",
       "      <td>5879.0</td>\n",
       "      <td>0.720</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.351382</td>\n",
       "      <td>Pirapo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Plácido de Castro</td>\n",
       "      <td>Acre</td>\n",
       "      <td>2047.0</td>\n",
       "      <td>17258.0</td>\n",
       "      <td>8.43</td>\n",
       "      <td>1.398140e+08</td>\n",
       "      <td>8377.0</td>\n",
       "      <td>0.683</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.139625</td>\n",
       "      <td>Placido de Castro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Planalto</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>346.0</td>\n",
       "      <td>13649.0</td>\n",
       "      <td>39.44</td>\n",
       "      <td>8.642600e+07</td>\n",
       "      <td>6395.0</td>\n",
       "      <td>0.763</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.232402</td>\n",
       "      <td>Planalto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Poconé</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>17261.0</td>\n",
       "      <td>31118.0</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1.555110e+08</td>\n",
       "      <td>4961.0</td>\n",
       "      <td>0.679</td>\n",
       "      <td>MT</td>\n",
       "      <td>-0.112346</td>\n",
       "      <td>Pocone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Ponta Porã</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>5329.0</td>\n",
       "      <td>72207.0</td>\n",
       "      <td>13.54</td>\n",
       "      <td>5.002460e+08</td>\n",
       "      <td>7445.0</td>\n",
       "      <td>0.780</td>\n",
       "      <td>MS</td>\n",
       "      <td>0.486732</td>\n",
       "      <td>Ponta Pora</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Porto Esperidião</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>5815.0</td>\n",
       "      <td>9607.0</td>\n",
       "      <td>1.65</td>\n",
       "      <td>7.569400e+07</td>\n",
       "      <td>6958.0</td>\n",
       "      <td>0.695</td>\n",
       "      <td>MT</td>\n",
       "      <td>-0.251052</td>\n",
       "      <td>Porto Esperidiao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Porto Lucena</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>250.0</td>\n",
       "      <td>5631.0</td>\n",
       "      <td>22.52</td>\n",
       "      <td>3.480100e+07</td>\n",
       "      <td>5845.0</td>\n",
       "      <td>0.747</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.322116</td>\n",
       "      <td>Porto Lucena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Porto Mauá</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>106.0</td>\n",
       "      <td>2565.0</td>\n",
       "      <td>24.19</td>\n",
       "      <td>1.849600e+07</td>\n",
       "      <td>6833.0</td>\n",
       "      <td>0.802</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.350450</td>\n",
       "      <td>Porto Maua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Porto Murtinho</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>17735.0</td>\n",
       "      <td>14861.0</td>\n",
       "      <td>0.83</td>\n",
       "      <td>1.285740e+08</td>\n",
       "      <td>9430.0</td>\n",
       "      <td>0.698</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.159157</td>\n",
       "      <td>Porto Murtinho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>34082.0</td>\n",
       "      <td>369345.0</td>\n",
       "      <td>10.83</td>\n",
       "      <td>3.656512e+09</td>\n",
       "      <td>9779.0</td>\n",
       "      <td>0.763</td>\n",
       "      <td>RO</td>\n",
       "      <td>5.971676</td>\n",
       "      <td>Porto Velho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Porto Vera Cruz</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>114.0</td>\n",
       "      <td>2084.0</td>\n",
       "      <td>18.28</td>\n",
       "      <td>1.417800e+07</td>\n",
       "      <td>6378.0</td>\n",
       "      <td>0.755</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.357954</td>\n",
       "      <td>Porto Vera Cruz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Porto Walter</td>\n",
       "      <td>Acre</td>\n",
       "      <td>6136.0</td>\n",
       "      <td>8170.0</td>\n",
       "      <td>1.33</td>\n",
       "      <td>2.592500e+07</td>\n",
       "      <td>5225.0</td>\n",
       "      <td>0.540</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.337540</td>\n",
       "      <td>Porto Walter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Porto Xavier</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>281.0</td>\n",
       "      <td>10857.0</td>\n",
       "      <td>38.63</td>\n",
       "      <td>7.133700e+07</td>\n",
       "      <td>6285.0</td>\n",
       "      <td>0.762</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.258624</td>\n",
       "      <td>Porto Xavier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Pranchita</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>226.0</td>\n",
       "      <td>5811.0</td>\n",
       "      <td>25.71</td>\n",
       "      <td>5.733100e+07</td>\n",
       "      <td>10120.0</td>\n",
       "      <td>0.803</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.282963</td>\n",
       "      <td>Pranchita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Princesa</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>86.0</td>\n",
       "      <td>2604.0</td>\n",
       "      <td>30.27</td>\n",
       "      <td>1.880300e+07</td>\n",
       "      <td>7709.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.349917</td>\n",
       "      <td>Princesa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Quaraí</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>3148.0</td>\n",
       "      <td>22552.0</td>\n",
       "      <td>7.16</td>\n",
       "      <td>1.624120e+08</td>\n",
       "      <td>6444.0</td>\n",
       "      <td>0.776</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.100354</td>\n",
       "      <td>Quarai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Rodrigues Alves</td>\n",
       "      <td>Acre</td>\n",
       "      <td>3305.0</td>\n",
       "      <td>12428.0</td>\n",
       "      <td>3.76</td>\n",
       "      <td>5.146800e+07</td>\n",
       "      <td>5254.0</td>\n",
       "      <td>0.550</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.293152</td>\n",
       "      <td>Rodrigues Alves</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Roque Gonzales</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>347.0</td>\n",
       "      <td>7297.0</td>\n",
       "      <td>21.02</td>\n",
       "      <td>5.465500e+07</td>\n",
       "      <td>7626.0</td>\n",
       "      <td>0.749</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.287613</td>\n",
       "      <td>Roque Gonzales</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Santa Helena</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>758.0</td>\n",
       "      <td>22794.0</td>\n",
       "      <td>30.07</td>\n",
       "      <td>2.199730e+08</td>\n",
       "      <td>10226.0</td>\n",
       "      <td>0.799</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.000325</td>\n",
       "      <td>Santa Helena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Santa Helena</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>81.0</td>\n",
       "      <td>2437.0</td>\n",
       "      <td>30.08</td>\n",
       "      <td>1.654490e+08</td>\n",
       "      <td>14812.0</td>\n",
       "      <td>0.787</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.095076</td>\n",
       "      <td>Santa Helena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Santa Isabel do Rio Negro</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>62846.0</td>\n",
       "      <td>16921.0</td>\n",
       "      <td>0.26</td>\n",
       "      <td>2.423100e+07</td>\n",
       "      <td>3181.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.340484</td>\n",
       "      <td>Santa Isabel do Rio Negro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Santa Rosa do Purus</td>\n",
       "      <td>Acre</td>\n",
       "      <td>5981.0</td>\n",
       "      <td>3948.0</td>\n",
       "      <td>0.66</td>\n",
       "      <td>1.532100e+07</td>\n",
       "      <td>4513.0</td>\n",
       "      <td>0.525</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.355968</td>\n",
       "      <td>Santa Rosa do Purus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Santa Vitória do Palmar</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>5244.0</td>\n",
       "      <td>31183.0</td>\n",
       "      <td>5.94</td>\n",
       "      <td>2.892230e+08</td>\n",
       "      <td>8360.0</td>\n",
       "      <td>0.799</td>\n",
       "      <td>RS</td>\n",
       "      <td>0.120018</td>\n",
       "      <td>Santa Vitoria do Palmar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Santana do Livramento</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>6950.0</td>\n",
       "      <td>83479.0</td>\n",
       "      <td>12.01</td>\n",
       "      <td>5.983870e+08</td>\n",
       "      <td>6138.0</td>\n",
       "      <td>0.803</td>\n",
       "      <td>RS</td>\n",
       "      <td>0.657281</td>\n",
       "      <td>Santana do Livramento</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Santo Antônio do Içá</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>12308.0</td>\n",
       "      <td>29249.0</td>\n",
       "      <td>2.37</td>\n",
       "      <td>6.827500e+07</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.263945</td>\n",
       "      <td>Santo Antonio do Ica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Santo Antônio do Sudoeste</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>326.0</td>\n",
       "      <td>18565.0</td>\n",
       "      <td>56.94</td>\n",
       "      <td>9.252100e+07</td>\n",
       "      <td>5101.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.221810</td>\n",
       "      <td>Santo Antonio do Sudoeste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>São Borja</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>3616.0</td>\n",
       "      <td>65671.0</td>\n",
       "      <td>17.10</td>\n",
       "      <td>5.968040e+08</td>\n",
       "      <td>8862.0</td>\n",
       "      <td>0.798</td>\n",
       "      <td>RS</td>\n",
       "      <td>0.654530</td>\n",
       "      <td>Sao Borja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>São Francisco do Guaporé</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>4747.0</td>\n",
       "      <td>15710.0</td>\n",
       "      <td>3.30</td>\n",
       "      <td>1.081830e+08</td>\n",
       "      <td>6453.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RO</td>\n",
       "      <td>-0.194593</td>\n",
       "      <td>Sao Francisco do Guapore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>São Gabriel da Cachoeira</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>109185.0</td>\n",
       "      <td>39129.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>1.110930e+08</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>0.567</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.189536</td>\n",
       "      <td>Sao Gabriel da Cachoeira</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>São José do Cedro</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>280.0</td>\n",
       "      <td>13699.0</td>\n",
       "      <td>48.92</td>\n",
       "      <td>1.537220e+08</td>\n",
       "      <td>11838.0</td>\n",
       "      <td>0.804</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.115455</td>\n",
       "      <td>Sao Jose do Cedro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>São Miguel do Iguaçu</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>851.0</td>\n",
       "      <td>25341.0</td>\n",
       "      <td>29.77</td>\n",
       "      <td>2.973000e+08</td>\n",
       "      <td>11065.0</td>\n",
       "      <td>0.779</td>\n",
       "      <td>PR</td>\n",
       "      <td>0.134054</td>\n",
       "      <td>Sao Miguel do Iguacu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>São Nicolau</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>485.0</td>\n",
       "      <td>5909.0</td>\n",
       "      <td>12.18</td>\n",
       "      <td>3.233800e+07</td>\n",
       "      <td>5290.0</td>\n",
       "      <td>0.713</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.326396</td>\n",
       "      <td>Sao Nicolau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Sena Madureira</td>\n",
       "      <td>Acre</td>\n",
       "      <td>25278.0</td>\n",
       "      <td>34230.0</td>\n",
       "      <td>1.35</td>\n",
       "      <td>2.343810e+08</td>\n",
       "      <td>7105.0</td>\n",
       "      <td>0.652</td>\n",
       "      <td>AC</td>\n",
       "      <td>0.024713</td>\n",
       "      <td>Sena Madureira</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Serranópolis do Iguaçu</td>\n",
       "      <td>Paraná</td>\n",
       "      <td>484.0</td>\n",
       "      <td>4327.0</td>\n",
       "      <td>8.94</td>\n",
       "      <td>5.287600e+07</td>\n",
       "      <td>10635.0</td>\n",
       "      <td>0.796</td>\n",
       "      <td>PR</td>\n",
       "      <td>-0.290705</td>\n",
       "      <td>Serranopolis do Iguacu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Sete Quedas</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>826.0</td>\n",
       "      <td>10659.0</td>\n",
       "      <td>12.90</td>\n",
       "      <td>5.410300e+07</td>\n",
       "      <td>6445.0</td>\n",
       "      <td>0.719</td>\n",
       "      <td>MS</td>\n",
       "      <td>-0.288573</td>\n",
       "      <td>Sete Quedas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Tabatinga</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>3225.0</td>\n",
       "      <td>45293.0</td>\n",
       "      <td>14.04</td>\n",
       "      <td>1.167550e+08</td>\n",
       "      <td>2655.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AM</td>\n",
       "      <td>-0.179696</td>\n",
       "      <td>Tabatinga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>Tiradentes do Sul</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>234.0</td>\n",
       "      <td>6928.0</td>\n",
       "      <td>29.60</td>\n",
       "      <td>4.292600e+07</td>\n",
       "      <td>6577.0</td>\n",
       "      <td>0.746</td>\n",
       "      <td>RS</td>\n",
       "      <td>-0.307996</td>\n",
       "      <td>Tiradentes do Sul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Tunápolis</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>133.0</td>\n",
       "      <td>4650.0</td>\n",
       "      <td>34.96</td>\n",
       "      <td>4.084500e+07</td>\n",
       "      <td>9420.0</td>\n",
       "      <td>0.821</td>\n",
       "      <td>SC</td>\n",
       "      <td>-0.311612</td>\n",
       "      <td>Tunapolis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Uiramutã</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>8066.0</td>\n",
       "      <td>7403.0</td>\n",
       "      <td>0.91</td>\n",
       "      <td>2.725100e+07</td>\n",
       "      <td>4238.0</td>\n",
       "      <td>0.542</td>\n",
       "      <td>RR</td>\n",
       "      <td>-0.335236</td>\n",
       "      <td>Uiramuta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Uruguaiana</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>5716.0</td>\n",
       "      <td>123743.0</td>\n",
       "      <td>21.64</td>\n",
       "      <td>1.187038e+09</td>\n",
       "      <td>8798.0</td>\n",
       "      <td>0.788</td>\n",
       "      <td>RS</td>\n",
       "      <td>1.680236</td>\n",
       "      <td>Uruguaiana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Vila Bela da Santíssima Trindade</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>13631.0</td>\n",
       "      <td>13886.0</td>\n",
       "      <td>1.01</td>\n",
       "      <td>1.169080e+08</td>\n",
       "      <td>8047.0</td>\n",
       "      <td>0.715</td>\n",
       "      <td>MT</td>\n",
       "      <td>-0.179431</td>\n",
       "      <td>Vila Bela da Santissima Trindade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Xapuri</td>\n",
       "      <td>Acre</td>\n",
       "      <td>5251.0</td>\n",
       "      <td>14314.0</td>\n",
       "      <td>2.72</td>\n",
       "      <td>8.237700e+07</td>\n",
       "      <td>6016.0</td>\n",
       "      <td>0.669</td>\n",
       "      <td>AC</td>\n",
       "      <td>-0.239438</td>\n",
       "      <td>Xapuri</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Município              Estado  Área territorial  \\\n",
       "0                              Aceguá   Rio Grande do Sul            1550.0   \n",
       "1                          Acrelândia                Acre            1575.0   \n",
       "2                             Alecrim   Rio Grande do Sul             315.0   \n",
       "3                            Almeirim                Pará           72960.0   \n",
       "4               Alta Floresta d'Oeste            Rondônia            7067.0   \n",
       "5                         Alto Alegre             Roraima           25567.0   \n",
       "6             Alto Alegre dos Parecis            Rondônia            3959.0   \n",
       "7                             Amajari             Roraima           28472.0   \n",
       "8                        Antônio João  Mato Grosso do Sul            1144.0   \n",
       "9                        Aral Moreira  Mato Grosso do Sul            1656.0   \n",
       "10                       Assis Brasil                Acre            2876.0   \n",
       "11                   Atalaia do Norte            Amazonas           76355.0   \n",
       "12                               Bagé   Rio Grande do Sul            4096.0   \n",
       "13                        Bandeirante      Santa Catarina             146.0   \n",
       "14                           Barcelos            Amazonas          122476.0   \n",
       "15                    Barra do Quaraí   Rio Grande do Sul            1056.0   \n",
       "16                           Barracão              Paraná             164.0   \n",
       "17                         Bela Vista  Mato Grosso do Sul            4896.0   \n",
       "18                           Belmonte      Santa Catarina              94.0   \n",
       "19                  Benjamin Constant            Amazonas            8793.0   \n",
       "20                   Bom Jesus do Sul              Paraná             174.0   \n",
       "21                             Bonfim             Roraima            8095.0   \n",
       "22                          Brasiléia                Acre            4336.0   \n",
       "23                             Cabixi            Rondônia            1314.0   \n",
       "24                            Cáceres         Mato Grosso           24398.0   \n",
       "25                           Capanema              Paraná             419.0   \n",
       "26                           Capixaba                Acre            1713.0   \n",
       "27                          Caracaraí             Roraima           47411.0   \n",
       "28                            Caracol  Mato Grosso do Sul            2939.0   \n",
       "29                            Caroebe             Roraima           12066.0   \n",
       "30                               Chuí   Rio Grande do Sul             203.0   \n",
       "31                           Comodoro         Mato Grosso           21743.0   \n",
       "32                   Coronel Sapucaia  Mato Grosso do Sul            1029.0   \n",
       "33                            Corumbá  Mato Grosso do Sul           65304.0   \n",
       "34                      Costa Marques            Rondônia           12722.0   \n",
       "35                         Crissiumal   Rio Grande do Sul             362.0   \n",
       "36                    Cruzeiro do Sul                Acre            7925.0   \n",
       "37                         Derrubadas   Rio Grande do Sul             361.0   \n",
       "38                 Dionísio Cerqueira      Santa Catarina             378.0   \n",
       "39                        Dom Pedrito   Rio Grande do Sul            5192.0   \n",
       "40            Doutor Maurício Cardoso   Rio Grande do Sul             256.0   \n",
       "41                Entre Rios do Oeste              Paraná             122.0   \n",
       "42                     Epitaciolândia                Acre            1659.0   \n",
       "43                   Esperança do Sul   Rio Grande do Sul             148.0   \n",
       "44                              Feijó                Acre           24202.0   \n",
       "45                      Foz do Iguaçu              Paraná             618.0   \n",
       "46                          Garruchos   Rio Grande do Sul             800.0   \n",
       "47                             Guaíra              Paraná             561.0   \n",
       "48                            Guajará            Amazonas            8904.0   \n",
       "49                      Guajará Mirim            Rondônia           24856.0   \n",
       "50                         Guaraciaba      Santa Catarina             331.0   \n",
       "51                             Herval   Rio Grande do Sul            1758.0   \n",
       "52                            Iracema             Roraima           14119.0   \n",
       "53                       Itaipulândia              Paraná             336.0   \n",
       "54                         Itapiranga      Santa Catarina             280.0   \n",
       "55                             Itaqui   Rio Grande do Sul            3404.0   \n",
       "56                           Jaguarão   Rio Grande do Sul            2054.0   \n",
       "57                             Japorã  Mato Grosso do Sul             420.0   \n",
       "58                             Japurá            Amazonas           55791.0   \n",
       "59                             Jordão                Acre            5429.0   \n",
       "60                   Laranjal do Jari               Amapá           30966.0   \n",
       "61                        Mâncio Lima                Acre            4672.0   \n",
       "62                      Manoel Urbano                Acre            9387.0   \n",
       "63                    Marechal Rondon              Paraná             748.0   \n",
       "64               Marechal Thaumaturgo                Acre            7744.0   \n",
       "65                           Mercedes              Paraná             201.0   \n",
       "66                         Mundo Novo  Mato Grosso do Sul             479.0   \n",
       "67                          Normandia             Roraima            6967.0   \n",
       "69                        Nova Mamoré            Rondônia           10072.0   \n",
       "68                       Novo Machado   Rio Grande do Sul             219.0   \n",
       "70                             Óbidos                Pará           28021.0   \n",
       "71                           Oiapoque               Amapá           22625.0   \n",
       "72                          Oriximiná                Pará          107603.0   \n",
       "73                          Pacaraima             Roraima            8028.0   \n",
       "74                            Paraíso      Santa Catarina             179.0   \n",
       "75                           Paranhos  Mato Grosso do Sul            1302.0   \n",
       "76                       Pato Bragado              Paraná             135.0   \n",
       "77                       Pedras Altas   Rio Grande do Sul            1377.0   \n",
       "78                     Pérola d'Oeste              Paraná             206.0   \n",
       "79               Pimenteiras do Oeste            Rondônia            6015.0   \n",
       "80                             Pirapó   Rio Grande do Sul             292.0   \n",
       "81                  Plácido de Castro                Acre            2047.0   \n",
       "82                           Planalto              Paraná             346.0   \n",
       "83                             Poconé         Mato Grosso           17261.0   \n",
       "84                         Ponta Porã  Mato Grosso do Sul            5329.0   \n",
       "85                   Porto Esperidião         Mato Grosso            5815.0   \n",
       "86                       Porto Lucena   Rio Grande do Sul             250.0   \n",
       "87                         Porto Mauá   Rio Grande do Sul             106.0   \n",
       "88                     Porto Murtinho  Mato Grosso do Sul           17735.0   \n",
       "89                        Porto Velho            Rondônia           34082.0   \n",
       "90                    Porto Vera Cruz   Rio Grande do Sul             114.0   \n",
       "91                       Porto Walter                Acre            6136.0   \n",
       "92                       Porto Xavier   Rio Grande do Sul             281.0   \n",
       "93                          Pranchita              Paraná             226.0   \n",
       "94                           Princesa      Santa Catarina              86.0   \n",
       "95                             Quaraí   Rio Grande do Sul            3148.0   \n",
       "96                    Rodrigues Alves                Acre            3305.0   \n",
       "97                     Roque Gonzales   Rio Grande do Sul             347.0   \n",
       "98                       Santa Helena              Paraná             758.0   \n",
       "99                       Santa Helena      Santa Catarina              81.0   \n",
       "100         Santa Isabel do Rio Negro            Amazonas           62846.0   \n",
       "101               Santa Rosa do Purus                Acre            5981.0   \n",
       "102           Santa Vitória do Palmar   Rio Grande do Sul            5244.0   \n",
       "103             Santana do Livramento   Rio Grande do Sul            6950.0   \n",
       "104              Santo Antônio do Içá            Amazonas           12308.0   \n",
       "105         Santo Antônio do Sudoeste              Paraná             326.0   \n",
       "106                         São Borja   Rio Grande do Sul            3616.0   \n",
       "107          São Francisco do Guaporé            Rondônia            4747.0   \n",
       "108          São Gabriel da Cachoeira            Amazonas          109185.0   \n",
       "109                 São José do Cedro      Santa Catarina             280.0   \n",
       "110              São Miguel do Iguaçu              Paraná             851.0   \n",
       "111                       São Nicolau   Rio Grande do Sul             485.0   \n",
       "112                    Sena Madureira                Acre           25278.0   \n",
       "113            Serranópolis do Iguaçu              Paraná             484.0   \n",
       "114                       Sete Quedas  Mato Grosso do Sul             826.0   \n",
       "115                         Tabatinga            Amazonas            3225.0   \n",
       "116                 Tiradentes do Sul   Rio Grande do Sul             234.0   \n",
       "117                         Tunápolis      Santa Catarina             133.0   \n",
       "118                          Uiramutã             Roraima            8066.0   \n",
       "119                        Uruguaiana   Rio Grande do Sul            5716.0   \n",
       "120  Vila Bela da Santíssima Trindade         Mato Grosso           13631.0   \n",
       "121                            Xapuri                Acre            5251.0   \n",
       "\n",
       "     População (IBGE/2007)  Densidade demográfica (hab/km2)  PIB (IBGE/2005)  \\\n",
       "0                   4138.0                             2.66     7.163800e+07   \n",
       "1                  11520.0                             7.31     1.143500e+08   \n",
       "2                   7357.0                            23.35     4.437300e+07   \n",
       "3                  30903.0                             0.42     4.622580e+08   \n",
       "4                  23857.0                             3.37     1.868120e+08   \n",
       "5                  14386.0                             0.56     1.157860e+08   \n",
       "6                  11615.0                             2.93     9.022600e+07   \n",
       "7                   7586.0                             0.26     3.189700e+04   \n",
       "8                   8350.0                             7.29     3.998900e+07   \n",
       "9                   9236.0                             5.57     1.056970e+08   \n",
       "10                  5351.0                             1.86     3.029800e+07   \n",
       "11                 13682.0                             0.17     2.902800e+07   \n",
       "12                112550.0                            27.47     9.064880e+08   \n",
       "13                  3028.0                            20.73     2.142300e+07   \n",
       "14                 24567.0                             0.20     7.200400e+07   \n",
       "15                  3776.0                             3.57     6.154000e+07   \n",
       "16                  9027.0                            55.04     6.060100e+07   \n",
       "17                 22868.0                             4.67     1.328700e+08   \n",
       "18                  2681.0                            28.52     2.167000e+07   \n",
       "19                  9268.0                             3.32     8.212000e+07   \n",
       "20                  3835.0                            22.04     1.795000e+07   \n",
       "21                 10231.0                             1.26     6.836300e+07   \n",
       "22                 19065.0                             4.39     1.175250e+08   \n",
       "23                  6575.0                             5.00     7.712500e+07   \n",
       "24                 84175.0                             3.45     5.966540e+08   \n",
       "25                 18103.0                            43.20     1.805190e+08   \n",
       "26                  8446.0                             4.93     7.838900e+07   \n",
       "27                 17981.0                             0.37     1.008850e+08   \n",
       "28                  5095.0                             1.73     4.553300e+07   \n",
       "29                  7086.0                             0.58     4.229600e+07   \n",
       "30                  5278.0                            26.00     6.752500e+07   \n",
       "31                 17939.0                             0.82     1.699190e+08   \n",
       "32                 13979.0                            13.58     5.479700e+07   \n",
       "33                114279.0                             1.74     1.557253e+09   \n",
       "34                 13664.0                             1.07     6.302200e+07   \n",
       "35                 14726.0                            40.67     1.140890e+08   \n",
       "36                 73948.0                             9.33     3.919430e+08   \n",
       "37                  3378.0                             9.35     2.281600e+07   \n",
       "38                 14792.0                            39.13     9.175700e+07   \n",
       "39                 38148.0                             7.34     3.998840e+08   \n",
       "40                  5494.0                            21.46     4.411200e+07   \n",
       "41                  3842.0                            31.49     4.318500e+07   \n",
       "42                 13434.0                             8.59     8.816400e+07   \n",
       "43                  3445.0                            23.27     2.239900e+07   \n",
       "44                 31288.0                             1.29     1.449770e+08   \n",
       "45                311336.0                           503.70     4.853331e+09   \n",
       "46                  3457.0                             4.32     1.429760e+08   \n",
       "47                 28683.0                            51.12     2.621570e+08   \n",
       "48                 14102.0                             1.58     3.656400e+07   \n",
       "49                 39451.0                             1.58     3.455110e+08   \n",
       "50                 10604.0                            32.03     1.036420e+08   \n",
       "51                  6873.0                             3.90     4.622900e+07   \n",
       "52                  5863.0                             0.41     4.673500e+07   \n",
       "53                  8581.0                            25.53     8.315800e+07   \n",
       "54                 15238.0                            54.42     2.986820e+08   \n",
       "55                 36361.0                            10.68     4.870620e+08   \n",
       "56                 27944.0                            13.60     1.930180e+08   \n",
       "57                  7362.0                            17.52     2.397600e+07   \n",
       "58                  5281.0                             0.09     2.710000e+07   \n",
       "59                  6059.0                             1.11     2.380500e+07   \n",
       "60                 37491.0                             1.21     1.829010e+08   \n",
       "61                 13785.0                             2.95     4.970500e+07   \n",
       "62                  7148.0                             0.76     3.126800e+07   \n",
       "63                 44562.0                            59.57     6.328180e+08   \n",
       "64                 13061.0                             1.68     3.764500e+07   \n",
       "65                  4713.0                            23.44     5.448000e+07   \n",
       "66                 15968.0                            33.33     9.824700e+07   \n",
       "67                  7118.0                             1.02     5.107100e+07   \n",
       "69                 21162.0                             2.10     1.245380e+08   \n",
       "68                  4246.0                            19.38     2.521000e+07   \n",
       "70                 46793.0                             1.66     1.384890e+08   \n",
       "71                 19181.0                             0.84     1.432440e+08   \n",
       "72                 55175.0                             0.51     7.768450e+08   \n",
       "73                  8640.0                             0.10     6.060800e+07   \n",
       "74                  4195.0                            23.43     3.360500e+07   \n",
       "75                 11092.0                             8.51     4.370300e+07   \n",
       "76                  4631.0                            34.30     4.169700e+07   \n",
       "77                  2546.0                             1.84     2.782900e+07   \n",
       "78                  7046.0                            34.20     4.578100e+07   \n",
       "79                  2358.0                             0.39     3.716300e+07   \n",
       "80                  2988.0                            10.23     1.796000e+07   \n",
       "81                 17258.0                             8.43     1.398140e+08   \n",
       "82                 13649.0                            39.44     8.642600e+07   \n",
       "83                 31118.0                             1.80     1.555110e+08   \n",
       "84                 72207.0                            13.54     5.002460e+08   \n",
       "85                  9607.0                             1.65     7.569400e+07   \n",
       "86                  5631.0                            22.52     3.480100e+07   \n",
       "87                  2565.0                            24.19     1.849600e+07   \n",
       "88                 14861.0                             0.83     1.285740e+08   \n",
       "89                369345.0                            10.83     3.656512e+09   \n",
       "90                  2084.0                            18.28     1.417800e+07   \n",
       "91                  8170.0                             1.33     2.592500e+07   \n",
       "92                 10857.0                            38.63     7.133700e+07   \n",
       "93                  5811.0                            25.71     5.733100e+07   \n",
       "94                  2604.0                            30.27     1.880300e+07   \n",
       "95                 22552.0                             7.16     1.624120e+08   \n",
       "96                 12428.0                             3.76     5.146800e+07   \n",
       "97                  7297.0                            21.02     5.465500e+07   \n",
       "98                 22794.0                            30.07     2.199730e+08   \n",
       "99                  2437.0                            30.08     1.654490e+08   \n",
       "100                16921.0                             0.26     2.423100e+07   \n",
       "101                 3948.0                             0.66     1.532100e+07   \n",
       "102                31183.0                             5.94     2.892230e+08   \n",
       "103                83479.0                            12.01     5.983870e+08   \n",
       "104                29249.0                             2.37     6.827500e+07   \n",
       "105                18565.0                            56.94     9.252100e+07   \n",
       "106                65671.0                            17.10     5.968040e+08   \n",
       "107                15710.0                             3.30     1.081830e+08   \n",
       "108                39129.0                             0.35     1.110930e+08   \n",
       "109                13699.0                            48.92     1.537220e+08   \n",
       "110                25341.0                            29.77     2.973000e+08   \n",
       "111                 5909.0                            12.18     3.233800e+07   \n",
       "112                34230.0                             1.35     2.343810e+08   \n",
       "113                 4327.0                             8.94     5.287600e+07   \n",
       "114                10659.0                            12.90     5.410300e+07   \n",
       "115                45293.0                            14.04     1.167550e+08   \n",
       "116                 6928.0                            29.60     4.292600e+07   \n",
       "117                 4650.0                            34.96     4.084500e+07   \n",
       "118                 7403.0                             0.91     2.725100e+07   \n",
       "119               123743.0                            21.64     1.187038e+09   \n",
       "120                13886.0                             1.01     1.169080e+08   \n",
       "121                14314.0                             2.72     8.237700e+07   \n",
       "\n",
       "     PIB per capita (R$)  IDH/2000 sigla  PIB Normalizado  \\\n",
       "0                17266.0       NaN    RS        -0.258100   \n",
       "1                 9986.0     0.680    AC        -0.183876   \n",
       "2                 5944.0     0.743    RS        -0.305481   \n",
       "3                13485.0     0.745    PA         0.420717   \n",
       "4                 6525.0     0.715    RO        -0.057952   \n",
       "5                 5239.0     0.662    RR        -0.181380   \n",
       "6                 6001.0       NaN    RO        -0.225798   \n",
       "7              5240000.0     0.654    RR        -0.382537   \n",
       "8                 5067.0     0.702    MS        -0.313100   \n",
       "9                13132.0     0.723    MS        -0.198913   \n",
       "10                5984.0     0.670    AC        -0.329941   \n",
       "11                2570.0       NaN    AM        -0.332148   \n",
       "12                7473.0     0.802    RS         1.192698   \n",
       "13                7546.0     0.765    SC        -0.345364   \n",
       "14                2238.0       NaN    AM        -0.257464   \n",
       "15               14429.0     0.777    RS        -0.275649   \n",
       "16                6718.0     0.764    PR        -0.277281   \n",
       "17                5676.0     0.755    MS        -0.151692   \n",
       "18                9954.0     0.759    SC        -0.344935   \n",
       "19                3135.0       NaN    AM        -0.239885   \n",
       "20                4638.0     0.696    PR        -0.351399   \n",
       "21                5414.0     0.654    RR        -0.263792   \n",
       "22                6632.0     0.669    AC        -0.178358   \n",
       "23               10372.0     0.705    RO        -0.248565   \n",
       "24                6700.0     0.737    MT         0.654270   \n",
       "25               10297.0     0.803    PR        -0.068888   \n",
       "26               11092.0     0.607    AC        -0.246369   \n",
       "27                5685.0     0.702    RR        -0.207275   \n",
       "28                9094.0     0.725    MS        -0.303466   \n",
       "29                7207.0     0.661    RR        -0.309091   \n",
       "30               10574.0     0.811    RS        -0.265248   \n",
       "31                9010.0     0.724    MT        -0.087308   \n",
       "32                4041.0     0.713    MS        -0.287367   \n",
       "33               13234.0     0.771    MS         2.323594   \n",
       "34                5553.0       NaN    RO        -0.273073   \n",
       "35                8376.0     0.786    RS        -0.184329   \n",
       "36                4647.0     0.668    AC         0.298524   \n",
       "37                7046.0     0.759    RS        -0.342943   \n",
       "38                6293.0     0.747    SC        -0.223138   \n",
       "39                9547.0     0.783    RS         0.312324   \n",
       "40                7635.0     0.765    RS        -0.305935   \n",
       "41               12063.0     0.847    PR        -0.307546   \n",
       "42                6397.0     0.684    AC        -0.229382   \n",
       "43                6753.0     0.708    RS        -0.343668   \n",
       "44                3791.0     0.541    AC        -0.130652   \n",
       "45               16102.0     0.802    PR         8.051502   \n",
       "46               35798.0     0.715    RS        -0.134130   \n",
       "47                9424.0     0.777    PR         0.072982   \n",
       "48                3030.0       NaN    AM        -0.319052   \n",
       "49                8332.0     0.740    RO         0.217835   \n",
       "50               10111.0       NaN    SC        -0.202484   \n",
       "51                6151.0     0.754    RS        -0.302256   \n",
       "52                7712.0     0.713    RR        -0.301377   \n",
       "53                9782.0     0.760    PR        -0.238081   \n",
       "54               22447.0     0.832    SC         0.136455   \n",
       "55               11494.0     0.801    RS         0.463821   \n",
       "56                6116.0     0.764    RS        -0.047167   \n",
       "57                3350.0     0.636    MS        -0.340927   \n",
       "58                2080.0       NaN    AM        -0.335498   \n",
       "59                5138.0     0.475    AC        -0.341224   \n",
       "60                5099.0       NaN    AP        -0.064748   \n",
       "61                3899.0     0.642    AC        -0.296216   \n",
       "62                4095.0     0.601    AC        -0.328255   \n",
       "63               14155.0     0.829    PR         0.717115   \n",
       "64                4452.0     0.533    AC        -0.317173   \n",
       "65               11210.0     0.816    PR        -0.287918   \n",
       "66                6884.0     0.761    MS        -0.211860   \n",
       "67                9573.0     0.600    RR        -0.293842   \n",
       "69                6388.0       NaN    RO        -0.166171   \n",
       "68                5922.0     0.773    RS        -0.338783   \n",
       "70                2820.0     0.681    PA        -0.141927   \n",
       "71                8828.0       NaN    AP        -0.133664   \n",
       "72               14620.0     0.717    PA         0.967405   \n",
       "73                7378.0     0.718    RR        -0.277268   \n",
       "74                8312.0     0.773    SC        -0.324194   \n",
       "75                4094.0     0.676    MS        -0.306646   \n",
       "76                9542.0     0.821    PR        -0.310132   \n",
       "77               10135.0       NaN    RS        -0.334232   \n",
       "78                6961.0     0.759    PR        -0.303035   \n",
       "79               14201.0     0.715    RO        -0.318011   \n",
       "80                5879.0     0.720    RS        -0.351382   \n",
       "81                8377.0     0.683    AC        -0.139625   \n",
       "82                6395.0     0.763    PR        -0.232402   \n",
       "83                4961.0     0.679    MT        -0.112346   \n",
       "84                7445.0     0.780    MS         0.486732   \n",
       "85                6958.0     0.695    MT        -0.251052   \n",
       "86                5845.0     0.747    RS        -0.322116   \n",
       "87                6833.0     0.802    RS        -0.350450   \n",
       "88                9430.0     0.698    MS        -0.159157   \n",
       "89                9779.0     0.763    RO         5.971676   \n",
       "90                6378.0     0.755    RS        -0.357954   \n",
       "91                5225.0     0.540    AC        -0.337540   \n",
       "92                6285.0     0.762    RS        -0.258624   \n",
       "93               10120.0     0.803    PR        -0.282963   \n",
       "94                7709.0       NaN    SC        -0.349917   \n",
       "95                6444.0     0.776    RS        -0.100354   \n",
       "96                5254.0     0.550    AC        -0.293152   \n",
       "97                7626.0     0.749    RS        -0.287613   \n",
       "98               10226.0     0.799    PR        -0.000325   \n",
       "99               14812.0     0.787    SC        -0.095076   \n",
       "100               3181.0       NaN    AM        -0.340484   \n",
       "101               4513.0     0.525    AC        -0.355968   \n",
       "102               8360.0     0.799    RS         0.120018   \n",
       "103               6138.0     0.803    RS         0.657281   \n",
       "104               1958.0       NaN    AM        -0.263945   \n",
       "105               5101.0     0.715    PR        -0.221810   \n",
       "106               8862.0     0.798    RS         0.654530   \n",
       "107               6453.0       NaN    RO        -0.194593   \n",
       "108               3261.0     0.567    AM        -0.189536   \n",
       "109              11838.0     0.804    SC        -0.115455   \n",
       "110              11065.0     0.779    PR         0.134054   \n",
       "111               5290.0     0.713    RS        -0.326396   \n",
       "112               7105.0     0.652    AC         0.024713   \n",
       "113              10635.0     0.796    PR        -0.290705   \n",
       "114               6445.0     0.719    MS        -0.288573   \n",
       "115               2655.0       NaN    AM        -0.179696   \n",
       "116               6577.0     0.746    RS        -0.307996   \n",
       "117               9420.0     0.821    SC        -0.311612   \n",
       "118               4238.0     0.542    RR        -0.335236   \n",
       "119               8798.0     0.788    RS         1.680236   \n",
       "120               8047.0     0.715    MT        -0.179431   \n",
       "121               6016.0     0.669    AC        -0.239438   \n",
       "\n",
       "                          MunicípioSA  \n",
       "0                              Acegua  \n",
       "1                          Acrelandia  \n",
       "2                             Alecrim  \n",
       "3                            Almeirim  \n",
       "4               Alta Floresta d'Oeste  \n",
       "5                         Alto Alegre  \n",
       "6             Alto Alegre dos Parecis  \n",
       "7                             Amajari  \n",
       "8                        Antonio Joao  \n",
       "9                        Aral Moreira  \n",
       "10                       Assis Brasil  \n",
       "11                   Atalaia do Norte  \n",
       "12                               Bage  \n",
       "13                        Bandeirante  \n",
       "14                           Barcelos  \n",
       "15                    Barra do Quarai  \n",
       "16                           Barracao  \n",
       "17                         Bela Vista  \n",
       "18                           Belmonte  \n",
       "19                  Benjamin Constant  \n",
       "20                   Bom Jesus do Sul  \n",
       "21                             Bonfim  \n",
       "22                          Brasileia  \n",
       "23                             Cabixi  \n",
       "24                            Caceres  \n",
       "25                           Capanema  \n",
       "26                           Capixaba  \n",
       "27                          Caracarai  \n",
       "28                            Caracol  \n",
       "29                            Caroebe  \n",
       "30                               Chui  \n",
       "31                           Comodoro  \n",
       "32                   Coronel Sapucaia  \n",
       "33                            Corumba  \n",
       "34                      Costa Marques  \n",
       "35                         Crissiumal  \n",
       "36                    Cruzeiro do Sul  \n",
       "37                         Derrubadas  \n",
       "38                 Dionisio Cerqueira  \n",
       "39                        Dom Pedrito  \n",
       "40            Doutor Mauricio Cardoso  \n",
       "41                Entre Rios do Oeste  \n",
       "42                     Epitaciolandia  \n",
       "43                   Esperanca do Sul  \n",
       "44                              Feijo  \n",
       "45                      Foz do Iguacu  \n",
       "46                          Garruchos  \n",
       "47                             Guaira  \n",
       "48                            Guajara  \n",
       "49                      Guajara Mirim  \n",
       "50                         Guaraciaba  \n",
       "51                             Herval  \n",
       "52                            Iracema  \n",
       "53                       Itaipulandia  \n",
       "54                         Itapiranga  \n",
       "55                             Itaqui  \n",
       "56                           Jaguarao  \n",
       "57                             Japora  \n",
       "58                             Japura  \n",
       "59                             Jordao  \n",
       "60                   Laranjal do Jari  \n",
       "61                        Mancio Lima  \n",
       "62                      Manoel Urbano  \n",
       "63                    Marechal Rondon  \n",
       "64               Marechal Thaumaturgo  \n",
       "65                           Mercedes  \n",
       "66                         Mundo Novo  \n",
       "67                          Normandia  \n",
       "69                        Nova Mamore  \n",
       "68                       Novo Machado  \n",
       "70                             Obidos  \n",
       "71                           Oiapoque  \n",
       "72                          Oriximina  \n",
       "73                          Pacaraima  \n",
       "74                            Paraiso  \n",
       "75                           Paranhos  \n",
       "76                       Pato Bragado  \n",
       "77                       Pedras Altas  \n",
       "78                     Perola d'Oeste  \n",
       "79               Pimenteiras do Oeste  \n",
       "80                             Pirapo  \n",
       "81                  Placido de Castro  \n",
       "82                           Planalto  \n",
       "83                             Pocone  \n",
       "84                         Ponta Pora  \n",
       "85                   Porto Esperidiao  \n",
       "86                       Porto Lucena  \n",
       "87                         Porto Maua  \n",
       "88                     Porto Murtinho  \n",
       "89                        Porto Velho  \n",
       "90                    Porto Vera Cruz  \n",
       "91                       Porto Walter  \n",
       "92                       Porto Xavier  \n",
       "93                          Pranchita  \n",
       "94                           Princesa  \n",
       "95                             Quarai  \n",
       "96                    Rodrigues Alves  \n",
       "97                     Roque Gonzales  \n",
       "98                       Santa Helena  \n",
       "99                       Santa Helena  \n",
       "100         Santa Isabel do Rio Negro  \n",
       "101               Santa Rosa do Purus  \n",
       "102           Santa Vitoria do Palmar  \n",
       "103             Santana do Livramento  \n",
       "104              Santo Antonio do Ica  \n",
       "105         Santo Antonio do Sudoeste  \n",
       "106                         Sao Borja  \n",
       "107          Sao Francisco do Guapore  \n",
       "108          Sao Gabriel da Cachoeira  \n",
       "109                 Sao Jose do Cedro  \n",
       "110              Sao Miguel do Iguacu  \n",
       "111                       Sao Nicolau  \n",
       "112                    Sena Madureira  \n",
       "113            Serranopolis do Iguacu  \n",
       "114                       Sete Quedas  \n",
       "115                         Tabatinga  \n",
       "116                 Tiradentes do Sul  \n",
       "117                         Tunapolis  \n",
       "118                          Uiramuta  \n",
       "119                        Uruguaiana  \n",
       "120  Vila Bela da Santissima Trindade  \n",
       "121                            Xapuri  "
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['MunicípioSA'] = df['Município'].apply(TratamentoTexto.remover_acentuacao)\n",
    "df.sort_values('MunicípioSA')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "___\n",
    "__Material produzido para o curso__:\n",
    "* Introdução à Análise de Dados com Python\n",
    "\n",
    "__Autor__:\n",
    "* Fernando Sola Pereira\n",
    "\n",
    "__Revisão__:\n",
    "* 1.1"
   ]
  }
 ],
 "metadata": {
  "accelerator": "GPU",
  "colab": {
   "collapsed_sections": [],
   "default_view": {},
   "name": "aula_03_01_python_basico.ipynb",
   "private_outputs": true,
   "provenance": [],
   "version": "0.3.2",
   "views": {}
  },
  "hide_input": false,
  "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"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}