{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](https://github.com/bigdata-icict/ETL-Dataiku-DSS/raw/master/tutoriais/pcdas_1.5.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Notebook para criação de tabela de indicadores da PNS - S 2019 Pré-natal - Parte 5"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Bibliotecas Utilizadas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Lendo pacotes necessários\n",
    "library(survey)\n",
    "library(ggplot2)\n",
    "library(dplyr)\n",
    "library(tictoc)\n",
    "library(foreign)\n",
    "library(forcats)\n",
    "library(tidyverse)\n",
    "source(\"utils.R\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Carregando microdados da PNS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".list-inline {list-style: none; margin:0; padding: 0}\n",
       ".list-inline>li {display: inline-block}\n",
       ".list-inline>li:not(:last-child)::after {content: \"\\00b7\"; padding: 0 .5ex}\n",
       "</style>\n",
       "<ol class=list-inline><li>293726</li><li>1087</li></ol>\n"
      ],
      "text/latex": [
       "\\begin{enumerate*}\n",
       "\\item 293726\n",
       "\\item 1087\n",
       "\\end{enumerate*}\n"
      ],
      "text/markdown": [
       "1. 293726\n",
       "2. 1087\n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "[1] 293726   1087"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Carregando banco de dados para R versão 3.5.0 ou superior\n",
    "load(\"<coloque aqui o caminho para o arquivo dos microdados formato RDATA PNS 2019>\")\n",
    "\n",
    "#conferindo as dimensões (número de linhas e colunas)\n",
    "dim(\"<Coloque aqui o nome do arquivo RDATA PNS 2019>\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Definição do peso e filtragem de respondentes do questionário"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "    Min.  1st Qu.   Median     Mean  3rd Qu.     Max. \n",
       " 0.00562  0.26621  0.54401  1.00000  1.12765 61.09981 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Selecionando registros válidos e calculando peso amostral - summary de verificação\n",
    "pns2019.1<-  <Coloque aqui o nome do arquivo RDATA>  %>% filter(V0025A==1) \n",
    "pns2019.1<-pns2019.1 %>% mutate(peso_morador_selec=((V00291*(90846/168426190))))\n",
    "pns2019.1<-pns2019.1 %>% filter(!is.na(peso_morador_selec))\n",
    "summary(pns2019.1$peso_morador_selec)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Criação de variáveis dos indicadores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>2633</dd><dt>Não</dt><dd>185</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 2633\n",
       "\\item[Não] 185\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   2633Não\n",
       ":   185NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       " 2633   185 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>1903</dd><dt>Não</dt><dd>915</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 1903\n",
       "\\item[Não] 915\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   1903Não\n",
       ":   915NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       " 1903   915 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>2015</dd><dt>Não</dt><dd>803</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 2015\n",
       "\\item[Não] 803\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   2015Não\n",
       ":   803NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       " 2015   803 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>1336</dd><dt>Não</dt><dd>1482</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 1336\n",
       "\\item[Não] 1482\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   1336Não\n",
       ":   1482NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       " 1336  1482 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>2370</dd><dt>Não</dt><dd>448</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 2370\n",
       "\\item[Não] 448\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   2370Não\n",
       ":   448NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       " 2370   448 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>447</dd><dt>Não</dt><dd>2371</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 447\n",
       "\\item[Não] 2371\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   447Não\n",
       ":   2371NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       "  447  2371 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Sim</dt><dd>246</dd><dt>Não</dt><dd>2572</dd><dt>NA's</dt><dd>88028</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Sim] 246\n",
       "\\item[Não] 2572\n",
       "\\item[NA's] 88028\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Sim\n",
       ":   246Não\n",
       ":   2572NA's\n",
       ":   88028\n",
       "\n"
      ],
      "text/plain": [
       "  Sim   Não  NA's \n",
       "  246  2572 88028 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Desfechos - Indicadores\n",
    "# 20. Proporção de mulheres que realizaram o último parto em hospital ou maternidade - S020P\n",
    "pns2019.1$S020P <- NA\n",
    "pns2019.1$S020P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S020P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & (pns2019.1$S112 == 3 | pns2019.1$S112 == 4 | pns2019.1$S112 == 6 | pns2019.1$S112 == 7)] <- 1\n",
    "pns2019.1$S020P<-factor(pns2019.1$S020P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S020P)\n",
    "\n",
    "# 21. Proporção de mulheres que tiveram o último parto realizado no estabelecimento de saúde indicado durante o pré-natal - S021P.\n",
    "pns2019.1$S021P <- NA\n",
    "pns2019.1$S021P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S021P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & pns2019.1$S128==1] <- 1\n",
    "pns2019.1$S021P<-factor(pns2019.1$S021P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S021P)\n",
    "\n",
    "\n",
    "# 22. Proporção de mulheres que tiveram o último parto realizado no primeiro estabelecimento de saúde que procuraram  - S022P.\n",
    "pns2019.1$S022P <- NA\n",
    "pns2019.1$S022P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S022P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & (pns2019.1$S128==1 | pns2019.1$S129==1)] <- 1\n",
    "pns2019.1$S022P<-factor(pns2019.1$S022P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S022P)\n",
    "\n",
    "# 23.  Proporção de mulheres que tiveram o último parto vaginal/normal  - S023P.\n",
    "pns2019.1$S023P <- NA\n",
    "pns2019.1$S023P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S023P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & pns2019.1$S115==1] <- 1\n",
    "pns2019.1$S023P<-factor(pns2019.1$S023P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S023P)\n",
    "\n",
    "# 24. Proporção de mulheres que tiveram acompanhante durante o período de parto - S024P.\n",
    "pns2019.1$S024P <- NA\n",
    "pns2019.1$S024P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S024P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & pns2019.1$S123==1] <- 1\n",
    "pns2019.1$S024P<-factor(pns2019.1$S024P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S024P)\n",
    "\n",
    "# 25. Proporção de mulheres com idade gestacional referida inferior a 37 semanas no momento do parto. - S025P.\n",
    "pns2019.1$S025P <- NA\n",
    "pns2019.1$S025P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S025P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & pns2019.1$S11801<37] <- 1\n",
    "pns2019.1$S025P<-factor(pns2019.1$S025P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S025P)\n",
    "\n",
    "# 26. Proporção de nascidos vivos cujo peso ao nascer foi inferior a 2500g - S026P.\n",
    "pns2019.1$S026P <- NA\n",
    "pns2019.1$S026P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0] <- 2\n",
    "pns2019.1$S026P[pns2019.1$C006==2 & pns2019.1$C008>=18 & pns2019.1$S068>0 & pns2019.1$S11001<2500] <- 1\n",
    "pns2019.1$S026P<-factor(pns2019.1$S026P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n",
    "summary(pns2019.1$S026P)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Definições de abrangências"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Situação urbana ou rural"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>urbano</dt><dd>69873</dd><dt>rural</dt><dd>20973</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[urbano] 69873\n",
       "\\item[rural] 20973\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "urbano\n",
       ":   69873rural\n",
       ":   20973\n",
       "\n"
      ],
      "text/plain": [
       "urbano  rural \n",
       " 69873  20973 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Situação Urbano ou Rural\n",
    "pns2019.1 <- pns2019.1 %>% rename(urb_rur=V0026)\n",
    "pns2019.1$urb_rur<-factor(pns2019.1$urb_rur, levels=c(1,2), labels=c(\"urbano\", \"rural\"))\n",
    "summary(pns2019.1$urb_rur)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### UF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Rondônia</dt><dd>2176</dd><dt>Acre</dt><dd>2380</dd><dt>Amazonas</dt><dd>3479</dd><dt>Roraima</dt><dd>2238</dd><dt>Pará</dt><dd>3853</dd><dt>Amapá</dt><dd>1554</dd><dt>Tocantins</dt><dd>1922</dd><dt>Maranhão</dt><dd>5080</dd><dt>Piauí</dt><dd>2740</dd><dt>Ceará</dt><dd>4265</dd><dt>Rio Grande do Norte</dt><dd>2962</dd><dt>Paraíba</dt><dd>3158</dd><dt>Pernambuco</dt><dd>4083</dd><dt>Alagoas</dt><dd>2987</dd><dt>Sergipe</dt><dd>2610</dd><dt>Bahia</dt><dd>3659</dd><dt>Minas Gerais</dt><dd>5209</dd><dt>Espírito Santo</dt><dd>3541</dd><dt>Rio de Janeiro</dt><dd>4966</dd><dt>São Paulo</dt><dd>6114</dd><dt>Paraná</dt><dd>3967</dd><dt>Santa Catarina</dt><dd>3738</dd><dt>Rio Grande do Sul</dt><dd>3767</dd><dt>Mato Grosso do Sul</dt><dd>2863</dd><dt>Mato Grosso</dt><dd>2468</dd><dt>Goiás</dt><dd>2702</dd><dt>Distrito Federal</dt><dd>2365</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Rondônia] 2176\n",
       "\\item[Acre] 2380\n",
       "\\item[Amazonas] 3479\n",
       "\\item[Roraima] 2238\n",
       "\\item[Pará] 3853\n",
       "\\item[Amapá] 1554\n",
       "\\item[Tocantins] 1922\n",
       "\\item[Maranhão] 5080\n",
       "\\item[Piauí] 2740\n",
       "\\item[Ceará] 4265\n",
       "\\item[Rio Grande do Norte] 2962\n",
       "\\item[Paraíba] 3158\n",
       "\\item[Pernambuco] 4083\n",
       "\\item[Alagoas] 2987\n",
       "\\item[Sergipe] 2610\n",
       "\\item[Bahia] 3659\n",
       "\\item[Minas Gerais] 5209\n",
       "\\item[Espírito Santo] 3541\n",
       "\\item[Rio de Janeiro] 4966\n",
       "\\item[São Paulo] 6114\n",
       "\\item[Paraná] 3967\n",
       "\\item[Santa Catarina] 3738\n",
       "\\item[Rio Grande do Sul] 3767\n",
       "\\item[Mato Grosso do Sul] 2863\n",
       "\\item[Mato Grosso] 2468\n",
       "\\item[Goiás] 2702\n",
       "\\item[Distrito Federal] 2365\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Rondônia\n",
       ":   2176Acre\n",
       ":   2380Amazonas\n",
       ":   3479Roraima\n",
       ":   2238Pará\n",
       ":   3853Amapá\n",
       ":   1554Tocantins\n",
       ":   1922Maranhão\n",
       ":   5080Piauí\n",
       ":   2740Ceará\n",
       ":   4265Rio Grande do Norte\n",
       ":   2962Paraíba\n",
       ":   3158Pernambuco\n",
       ":   4083Alagoas\n",
       ":   2987Sergipe\n",
       ":   2610Bahia\n",
       ":   3659Minas Gerais\n",
       ":   5209Espírito Santo\n",
       ":   3541Rio de Janeiro\n",
       ":   4966São Paulo\n",
       ":   6114Paraná\n",
       ":   3967Santa Catarina\n",
       ":   3738Rio Grande do Sul\n",
       ":   3767Mato Grosso do Sul\n",
       ":   2863Mato Grosso\n",
       ":   2468Goiás\n",
       ":   2702Distrito Federal\n",
       ":   2365\n",
       "\n"
      ],
      "text/plain": [
       "           Rondônia                Acre            Amazonas             Roraima \n",
       "               2176                2380                3479                2238 \n",
       "               Pará               Amapá           Tocantins            Maranhão \n",
       "               3853                1554                1922                5080 \n",
       "              Piauí               Ceará Rio Grande do Norte             Paraíba \n",
       "               2740                4265                2962                3158 \n",
       "         Pernambuco             Alagoas             Sergipe               Bahia \n",
       "               4083                2987                2610                3659 \n",
       "       Minas Gerais      Espírito Santo      Rio de Janeiro           São Paulo \n",
       "               5209                3541                4966                6114 \n",
       "             Paraná      Santa Catarina   Rio Grande do Sul  Mato Grosso do Sul \n",
       "               3967                3738                3767                2863 \n",
       "        Mato Grosso               Goiás    Distrito Federal \n",
       "               2468                2702                2365 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Estados - UFs\n",
    "pns2019.1 <- pns2019.1 %>% rename(uf=V0001)\n",
    "pns2019.1$uf<-factor(pns2019.1$uf, levels=c(11,12,13,14,15,16,17,21,22,23,24,25,26,27,28,29,31,32,33,35,41,42,43,50,51,52,53),\n",
    "                                       label=c(\"Rondônia\",\"Acre\",\"Amazonas\",\"Roraima\",\"Pará\",\"Amapá\",\"Tocantins\",\"Maranhão\",\"Piauí\",\"Ceará\",\n",
    "                                        \"Rio Grande do Norte\",\"Paraíba\",\"Pernambuco\",\"Alagoas\",\"Sergipe\",\"Bahia\",\n",
    "                                        \"Minas Gerais\",\"Espírito Santo\",\"Rio de Janeiro\",\"São Paulo\",\n",
    "                                        \"Paraná\",\"Santa Catarina\",\"Rio Grande do Sul\", \n",
    "                                        \"Mato Grosso do Sul\",\"Mato Grosso\",\"Goiás\",\"Distrito Federal\"))\n",
    "summary(pns2019.1$uf)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Grandes Regiões"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Norte</dt><dd>17602</dd><dt>Nordeste</dt><dd>31544</dd><dt>Sudeste</dt><dd>19830</dd><dt>Sul</dt><dd>11472</dd><dt>Centro-Oeste</dt><dd>10398</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Norte] 17602\n",
       "\\item[Nordeste] 31544\n",
       "\\item[Sudeste] 19830\n",
       "\\item[Sul] 11472\n",
       "\\item[Centro-Oeste] 10398\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Norte\n",
       ":   17602Nordeste\n",
       ":   31544Sudeste\n",
       ":   19830Sul\n",
       ":   11472Centro-Oeste\n",
       ":   10398\n",
       "\n"
      ],
      "text/plain": [
       "       Norte     Nordeste      Sudeste          Sul Centro-Oeste \n",
       "       17602        31544        19830        11472        10398 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Grandes Regiões\n",
    "pns2019.1 <- pns2019.1 %>% \n",
    "  mutate(região = fct_collapse(uf, \n",
    "                                  `Norte` = c(\"Rondônia\",\"Acre\",\"Amazonas\",\"Roraima\",\"Pará\", \"Amapá\",\"Tocantins\"),\n",
    "                                  `Nordeste` = c(\"Maranhão\", \"Piauí\", \"Ceará\", \"Rio Grande do Norte\", \"Paraíba\",\"Pernambuco\", \"Alagoas\",\"Sergipe\",\"Bahia\"),\n",
    "                                  `Sudeste` = c(\"Minas Gerais\", \"Espírito Santo\",\"Rio de Janeiro\", \"São Paulo\"), \n",
    "                                  `Sul` = c(\"Paraná\", \"Santa Catarina\", \"Rio Grande do Sul\"),\n",
    "                                  `Centro-Oeste`= c(\"Mato Grosso do Sul\",\"Mato Grosso\", \"Goiás\", \"Distrito Federal\"))\n",
    "        )\n",
    "summary(pns2019.1$região)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Capital"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Porto Velho</dt><dd>2176</dd><dt>Rio Branco</dt><dd>2380</dd><dt>Manaus</dt><dd>3479</dd><dt>Boa Vista</dt><dd>2238</dd><dt>Belém</dt><dd>3853</dd><dt>Macapá</dt><dd>1554</dd><dt>Palmas</dt><dd>1922</dd><dt>São Luís</dt><dd>5080</dd><dt>Teresina</dt><dd>2740</dd><dt>Fortaleza</dt><dd>4265</dd><dt>Natal</dt><dd>2962</dd><dt>João Pessoa</dt><dd>3158</dd><dt>Recife</dt><dd>4083</dd><dt>Maceió</dt><dd>2987</dd><dt>Aracaju</dt><dd>2610</dd><dt>Salvador</dt><dd>3659</dd><dt>Belo Horizonte</dt><dd>5209</dd><dt>Vitória</dt><dd>3541</dd><dt>Rio de Janeiro</dt><dd>4966</dd><dt>São Paulo</dt><dd>6114</dd><dt>Curitiba</dt><dd>3967</dd><dt>Florianópolis</dt><dd>3738</dd><dt>Porto Alegre</dt><dd>3767</dd><dt>Campo Grande</dt><dd>2863</dd><dt>Cuiabá</dt><dd>2468</dd><dt>Goiânia</dt><dd>2702</dd><dt>Brasília</dt><dd>2365</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Porto Velho] 2176\n",
       "\\item[Rio Branco] 2380\n",
       "\\item[Manaus] 3479\n",
       "\\item[Boa Vista] 2238\n",
       "\\item[Belém] 3853\n",
       "\\item[Macapá] 1554\n",
       "\\item[Palmas] 1922\n",
       "\\item[São Luís] 5080\n",
       "\\item[Teresina] 2740\n",
       "\\item[Fortaleza] 4265\n",
       "\\item[Natal] 2962\n",
       "\\item[João Pessoa] 3158\n",
       "\\item[Recife] 4083\n",
       "\\item[Maceió] 2987\n",
       "\\item[Aracaju] 2610\n",
       "\\item[Salvador] 3659\n",
       "\\item[Belo Horizonte] 5209\n",
       "\\item[Vitória] 3541\n",
       "\\item[Rio de Janeiro] 4966\n",
       "\\item[São Paulo] 6114\n",
       "\\item[Curitiba] 3967\n",
       "\\item[Florianópolis] 3738\n",
       "\\item[Porto Alegre] 3767\n",
       "\\item[Campo Grande] 2863\n",
       "\\item[Cuiabá] 2468\n",
       "\\item[Goiânia] 2702\n",
       "\\item[Brasília] 2365\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Porto Velho\n",
       ":   2176Rio Branco\n",
       ":   2380Manaus\n",
       ":   3479Boa Vista\n",
       ":   2238Belém\n",
       ":   3853Macapá\n",
       ":   1554Palmas\n",
       ":   1922São Luís\n",
       ":   5080Teresina\n",
       ":   2740Fortaleza\n",
       ":   4265Natal\n",
       ":   2962João Pessoa\n",
       ":   3158Recife\n",
       ":   4083Maceió\n",
       ":   2987Aracaju\n",
       ":   2610Salvador\n",
       ":   3659Belo Horizonte\n",
       ":   5209Vitória\n",
       ":   3541Rio de Janeiro\n",
       ":   4966São Paulo\n",
       ":   6114Curitiba\n",
       ":   3967Florianópolis\n",
       ":   3738Porto Alegre\n",
       ":   3767Campo Grande\n",
       ":   2863Cuiabá\n",
       ":   2468Goiânia\n",
       ":   2702Brasília\n",
       ":   2365\n",
       "\n"
      ],
      "text/plain": [
       "   Porto Velho     Rio Branco         Manaus      Boa Vista          Belém \n",
       "          2176           2380           3479           2238           3853 \n",
       "        Macapá         Palmas       São Luís       Teresina      Fortaleza \n",
       "          1554           1922           5080           2740           4265 \n",
       "         Natal    João Pessoa         Recife         Maceió        Aracaju \n",
       "          2962           3158           4083           2987           2610 \n",
       "      Salvador Belo Horizonte        Vitória Rio de Janeiro      São Paulo \n",
       "          3659           5209           3541           4966           6114 \n",
       "      Curitiba  Florianópolis   Porto Alegre   Campo Grande         Cuiabá \n",
       "          3967           3738           3767           2863           2468 \n",
       "       Goiânia       Brasília \n",
       "          2702           2365 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Capital\n",
    "pns2019.1<- pns2019.1 %>% mutate(capital= fct_collapse(uf,\n",
    "                                        `Porto Velho`= \"Rondônia\", \n",
    "                                        `Boa Vista`= \"Roraima\",              \n",
    "                                        `Rio Branco`= \"Acre\", \n",
    "                                        `Manaus` = \"Amazonas\",\n",
    "                                        `Belém` = \"Pará\" ,\n",
    "                                        `Macapá`= \"Amapá\",\n",
    "                                        `Palmas` = \"Tocantins\",\n",
    "                                        `São Luís` = \"Maranhão\",\n",
    "                                        `Teresina`= \"Piauí\" ,\n",
    "                                        `Fortaleza`= \"Ceará\",\n",
    "                                        `Natal`= \"Rio Grande do Norte\",\n",
    "                                        `João Pessoa`= \"Paraíba\",\n",
    "                                        `Recife`= \"Pernambuco\",\n",
    "                                        `Maceió`= \"Alagoas\",\n",
    "                                        `Aracaju`= \"Sergipe\",\n",
    "                                        `Salvador`= \"Bahia\",\n",
    "                                        `Belo Horizonte`= \"Minas Gerais\",\n",
    "                                        `Vitória`= \"Espírito Santo\",\n",
    "                                        `Rio de Janeiro`= \"Rio de Janeiro\",\n",
    "                                        `São Paulo`= \"São Paulo\",\n",
    "                                        `Curitiba`= \"Paraná\",\n",
    "                                        `Florianópolis`= \"Santa Catarina\",\n",
    "                                        `Porto Alegre`= \"Rio Grande do Sul\",\n",
    "                                        `Campo Grande`=  \"Mato Grosso do Sul\",\n",
    "                                        `Cuiabá`= \"Mato Grosso\",\n",
    "                                        `Goiânia` = \"Goiás\",\n",
    "                                        `Brasília`= \"Distrito Federal\"))\n",
    "summary(pns2019.1$capital)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Faixa Etária"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>18 a 24 anos</dt><dd>8145</dd><dt>25 a 29 anos</dt><dd>7249</dd><dt>30 a 39 anos</dt><dd>18150</dd><dt>40 anos ou mais</dt><dd>54987</dd><dt>NA's</dt><dd>2315</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[18 a 24 anos] 8145\n",
       "\\item[25 a 29 anos] 7249\n",
       "\\item[30 a 39 anos] 18150\n",
       "\\item[40 anos ou mais] 54987\n",
       "\\item[NA's] 2315\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "18 a 24 anos\n",
       ":   814525 a 29 anos\n",
       ":   724930 a 39 anos\n",
       ":   1815040 anos ou mais\n",
       ":   54987NA's\n",
       ":   2315\n",
       "\n"
      ],
      "text/plain": [
       "   18 a 24 anos    25 a 29 anos    30 a 39 anos 40 anos ou mais            NA's \n",
       "           8145            7249           18150           54987            2315 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Faixas Etárias\n",
    "\n",
    "pns2019.1 <- pns2019.1 %>% mutate(fx_idade_S=cut(C008,\n",
    "  breaks = c(18,25,30,40,120),\n",
    "  labels = c(\"18 a 24 anos\", \"25 a 29 anos\", \"30 a 39 anos\", \"40 anos ou mais\"), \n",
    "  ordered_result = TRUE, right = FALSE))\n",
    "summary(pns2019.1$fx_idade_S)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Raça"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Branca</dt><dd>33133</dd><dt>Preta</dt><dd>10345</dd><dt>Parda</dt><dd>45994</dd><dt>NA's</dt><dd>1374</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Branca] 33133\n",
       "\\item[Preta] 10345\n",
       "\\item[Parda] 45994\n",
       "\\item[NA's] 1374\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Branca\n",
       ":   33133Preta\n",
       ":   10345Parda\n",
       ":   45994NA's\n",
       ":   1374\n",
       "\n"
      ],
      "text/plain": [
       "Branca  Preta  Parda   NA's \n",
       " 33133  10345  45994   1374 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Raça\n",
    "pns2019.1 <- pns2019.1 %>% mutate(raça= ifelse(C009==1, 1, \n",
    "                                               ifelse(C009==2, 2, \n",
    "                                                      ifelse(C009==4, 3, 9))))\n",
    "pns2019.1$raça<-factor(pns2019.1$raça, levels=c(1,2,3),labels=c(\"Branca\", \"Preta\", \"Parda\"))\n",
    "summary(pns2019.1$raça)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Renda per capita"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Até 1/2 SM</dt><dd>23697</dd><dt>1/2 até 1 SM</dt><dd>26406</dd><dt>1 até 2 SM</dt><dd>22466</dd><dt>2 até 3 SM</dt><dd>7612</dd><dt>Mais de 3 SM</dt><dd>10643</dd><dt>NA's</dt><dd>22</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Até 1/2 SM] 23697\n",
       "\\item[1/2 até 1 SM] 26406\n",
       "\\item[1 até 2 SM] 22466\n",
       "\\item[2 até 3 SM] 7612\n",
       "\\item[Mais de 3 SM] 10643\n",
       "\\item[NA's] 22\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Até 1/2 SM\n",
       ":   236971/2 até 1 SM\n",
       ":   264061 até 2 SM\n",
       ":   224662 até 3 SM\n",
       ":   7612Mais de 3 SM\n",
       ":   10643NA's\n",
       ":   22\n",
       "\n"
      ],
      "text/plain": [
       "  Até 1/2 SM 1/2 até 1 SM   1 até 2 SM   2 até 3 SM Mais de 3 SM         NA's \n",
       "       23697        26406        22466         7612        10643           22 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Rendimento domiciliar per capita\n",
    "pns2019.1 <- pns2019.1 %>% mutate(rend_per_capita = ifelse(VDF004 %in% 1:2, 1, \n",
    "                        ifelse(VDF004%in% 3, 2, \n",
    "                        ifelse(VDF004%in% 4, 3,\n",
    "                        ifelse(VDF004%in% 5, 4, \n",
    "                        ifelse(is.na(VDF004)==TRUE, NA_real_, 5))))))\n",
    "pns2019.1$rend_per_capita<-factor(pns2019.1$rend_per_capita, levels=c(1,2,3,4,5), labels=c(\"Até 1/2 SM\",\"1/2 até 1 SM\",\"1 até 2 SM\",\n",
    "                                                                                   \"2 até 3 SM\",\"Mais de 3 SM\"))\n",
    "summary(pns2019.1$rend_per_capita)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Escolaridade"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       ".dl-inline {width: auto; margin:0; padding: 0}\n",
       ".dl-inline>dt, .dl-inline>dd {float: none; width: auto; display: inline-block}\n",
       ".dl-inline>dt::after {content: \":\\0020\"; padding-right: .5ex}\n",
       ".dl-inline>dt:not(:first-of-type) {padding-left: .5ex}\n",
       "</style><dl class=dl-inline><dt>Fundamental incompleto ou equivalente</dt><dd>36276</dd><dt>Médio incompleto ou equivalente</dt><dd>13520</dd><dt>Superior incompleto ou equivalente</dt><dd>27433</dd><dt>Superior completo</dt><dd>13617</dd></dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Fundamental incompleto ou equivalente] 36276\n",
       "\\item[Médio incompleto ou equivalente] 13520\n",
       "\\item[Superior incompleto ou equivalente] 27433\n",
       "\\item[Superior completo] 13617\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Fundamental incompleto ou equivalente\n",
       ":   36276Médio incompleto ou equivalente\n",
       ":   13520Superior incompleto ou equivalente\n",
       ":   27433Superior completo\n",
       ":   13617\n",
       "\n"
      ],
      "text/plain": [
       "Fundamental incompleto ou equivalente       Médio incompleto ou equivalente \n",
       "                                36276                                 13520 \n",
       "   Superior incompleto ou equivalente                     Superior completo \n",
       "                                27433                                 13617 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Escolaridade\n",
    "pns2019.1 <- pns2019.1 %>% mutate(gescol = ifelse(VDD004A %in% 1:2, 1, \n",
    "                        ifelse(VDD004A%in% 3:4, 2, \n",
    "                        ifelse(VDD004A%in% 5:6, 3,4\n",
    "                        ))))\n",
    "\n",
    "pns2019.1$gescol<-factor(pns2019.1$gescol, levels=c(1,2,3,4), \n",
    "                                  labels=c(\"Fundamental incompleto ou equivalente\",\"Médio incompleto ou equivalente\",\n",
    "                                           \"Superior incompleto ou equivalente\",\"Superior completo\"))\n",
    "summary(pns2019.1$gescol)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Criando indicadores"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Filtrando base de indicadores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "     V0024            UPA_PNS      peso_morador_selec      C008       \n",
       " 1210010: 1167   140001681:   18   Min.   : 0.00562   Min.   : 15.00  \n",
       " 1410011:  792   140003815:   18   1st Qu.: 0.26621   1st Qu.: 32.00  \n",
       " 2710111:  779   140005777:   18   Median : 0.54401   Median : 45.00  \n",
       " 2410011:  745   140006746:   18   Mean   : 1.00000   Mean   : 46.39  \n",
       " 5010011:  738   140007081:   18   3rd Qu.: 1.12765   3rd Qu.: 60.00  \n",
       " 3210011:  711   140007715:   18   Max.   :61.09981   Max.   :107.00  \n",
       " (Other):85914   (Other)  :90738                                      \n",
       "      C006            C009           V0031         urb_rur     \n",
       " Min.   :1.000   Min.   :1.000   Min.   :1.000   urbano:69873  \n",
       " 1st Qu.:1.000   1st Qu.:1.000   1st Qu.:1.000   rural :20973  \n",
       " Median :2.000   Median :4.000   Median :2.000                 \n",
       " Mean   :1.529   Mean   :2.679   Mean   :2.605                 \n",
       " 3rd Qu.:2.000   3rd Qu.:4.000   3rd Qu.:4.000                 \n",
       " Max.   :2.000   Max.   :9.000   Max.   :4.000                 \n",
       "                                                               \n",
       "              uf                 região                capital     \n",
       " São Paulo     : 6114   Norte       :17602   São Paulo     : 6114  \n",
       " Minas Gerais  : 5209   Nordeste    :31544   Belo Horizonte: 5209  \n",
       " Maranhão      : 5080   Sudeste     :19830   São Luís      : 5080  \n",
       " Rio de Janeiro: 4966   Sul         :11472   Rio de Janeiro: 4966  \n",
       " Ceará         : 4265   Centro-Oeste:10398   Fortaleza     : 4265  \n",
       " Pernambuco    : 4083                        Recife        : 4083  \n",
       " (Other)       :61129                        (Other)       :61129  \n",
       "           fx_idade_S        raça           rend_per_capita \n",
       " 18 a 24 anos   : 8145   Branca:33133   Até 1/2 SM  :23697  \n",
       " 25 a 29 anos   : 7249   Preta :10345   1/2 até 1 SM:26406  \n",
       " 30 a 39 anos   :18150   Parda :45994   1 até 2 SM  :22466  \n",
       " 40 anos ou mais:54987   NA's  : 1374   2 até 3 SM  : 7612  \n",
       " NA's           : 2315                  Mais de 3 SM:10643  \n",
       "                                        NA's        :   22  \n",
       "                                                            \n",
       "                                   gescol       S020P        S021P      \n",
       " Fundamental incompleto ou equivalente:36276   Sim : 2633   Sim : 1903  \n",
       " Médio incompleto ou equivalente      :13520   Não :  185   Não :  915  \n",
       " Superior incompleto ou equivalente   :27433   NA's:88028   NA's:88028  \n",
       " Superior completo                    :13617                            \n",
       "                                                                        \n",
       "                                                                        \n",
       "                                                                        \n",
       "  S022P        S023P        S024P        S025P        S026P      \n",
       " Sim : 2015   Sim : 1336   Sim : 2370   Sim :  447   Sim :  246  \n",
       " Não :  803   Não : 1482   Não :  448   Não : 2371   Não : 2572  \n",
       " NA's:88028   NA's:88028   NA's:88028   NA's:88028   NA's:88028  \n",
       "                                                                 \n",
       "                                                                 \n",
       "                                                                 \n",
       "                                                                 \n",
       "      S068      \n",
       " Min.   :1.00   \n",
       " 1st Qu.:1.00   \n",
       " Median :1.00   \n",
       " Mean   :1.03   \n",
       " 3rd Qu.:1.00   \n",
       " Max.   :2.00   \n",
       " NA's   :87936  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Selecionando variáveis para cálculo de indicadores no survey\n",
    "pns2019Ssurvey<- pns2019.1 %>% select(\"V0024\",\"UPA_PNS\",\"peso_morador_selec\", \"C008\", \"C006\", \"C009\", \"V0031\", \n",
    "                                      \"urb_rur\", \"uf\", \"região\",  \"capital\", \"fx_idade_S\", \"raça\", \"rend_per_capita\", \"gescol\",\n",
    "                                      \"S020P\", \"S021P\", \"S022P\", \"S023P\", \"S024P\", \"S025P\", \"S026P\", \"S068\") \n",
    "summary(pns2019Ssurvey)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Exporta tabela filtrada com os dados específicos - Módulo S - Parte5 2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Salvando csv para cálculo de indicadores no survey\n",
    "diretorio_saida <- \"<coloque aqui o diretório>\"\n",
    "write.csv(pns2019Ssurvey, file.path(diretorio_saida, \"pns2019Ssurvey.csv\"))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Cria plano amostral complexo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "desPNS=svydesign(id=~UPA_PNS, \n",
    "                 strat=~V0024,\n",
    "                 weight=~peso_morador_selec,\n",
    "                 nest=TRUE, \n",
    "                 data=pns2019Ssurvey)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "#survey design S020P a S026P\n",
    "desPNSS=subset(desPNS, C006==2 & C008>=18 & S068>0)\n",
    "desPNSS_C=subset(desPNS, C006==2 & C008>=18 & S068>0 & V0031==1)\n",
    "desPNSS_R=subset(desPNS, C006==2 & C008>=18 & S068>0 & !is.na(raça))\n",
    "desPNSS_Rend=subset(desPNS, C006==2 & C008>=18 & S068>0 & !is.na(rend_per_capita))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Definição de variáveis para iteração dos indicadores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "design_por_abrangencia <- list(\n",
    "    S020P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS\n",
    "    ),\n",
    "    S021P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS\n",
    "    ),\n",
    "    S022P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS\n",
    "    ),\n",
    "    S023P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS,\n",
    "        excluir = c(\"capital\")\n",
    "    ),\n",
    "    S024P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS\n",
    "    ),\n",
    "    S025P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS,\n",
    "        excluir = c(\"capital\", \"uf\")\n",
    "    ),\n",
    "    S026P = list(\n",
    "        capital = desPNSS_C,\n",
    "        raça = desPNSS_R,\n",
    "        rend_per_capita = desPNSS_Rend,\n",
    "        default = desPNSS,\n",
    "        excluir = c(\"capital\", \"uf\")\n",
    "    )\n",
    ")\n",
    "dominios <- c(\n",
    "    ~raça,\n",
    "    ~rend_per_capita,\n",
    "    ~fx_idade_S,\n",
    "    ~urb_rur,\n",
    "    ~uf,\n",
    "    ~região,\n",
    "    ~capital,\n",
    "    ~gescol\n",
    ") \n",
    "indicadores <- c(~S020P, ~S021P, ~S022P, ~S023P, ~S024P, ~S025P, ~S026P)\n",
    "totais <- c(~Brasil,~Capital)\n",
    "Ano <- \"2019\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Preenchendo a tabela de indicadores\n",
    "Essas iterações rodam por indicador, abrangência e por design"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "matriz_indicadores <- popula_indicadores(design_por_abrangencia, dominios, indicadores, Ano)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table class=\"dataframe\">\n",
       "<caption>A data.frame: 404 × 8</caption>\n",
       "<thead>\n",
       "\t<tr><th></th><th scope=col>abr_tipo</th><th scope=col>abr_nome</th><th scope=col>Ano</th><th scope=col>Indicador</th><th scope=col>Sim</th><th scope=col>LowerS</th><th scope=col>UpperS</th><th scope=col>cvS</th></tr>\n",
       "\t<tr><th></th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;fct&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "\t<tr><th scope=row>Branca</th><td>raça           </td><td>Branca             </td><td>2019</td><td>S020P</td><td>0.9462652</td><td>0.9150585</td><td>0.9774720</td><td>0.016826270</td></tr>\n",
       "\t<tr><th scope=row>Preta</th><td>raça           </td><td>Preta              </td><td>2019</td><td>S020P</td><td>0.9491546</td><td>0.9190134</td><td>0.9792958</td><td>0.016202236</td></tr>\n",
       "\t<tr><th scope=row>Parda</th><td>raça           </td><td>Parda              </td><td>2019</td><td>S020P</td><td>0.9406377</td><td>0.9204789</td><td>0.9607964</td><td>0.010934363</td></tr>\n",
       "\t<tr><th scope=row>Até 1/2 SM</th><td>rend_per_capita</td><td>Até 1/2 SM         </td><td>2019</td><td>S020P</td><td>0.9296724</td><td>0.9109426</td><td>0.9484022</td><td>0.010279112</td></tr>\n",
       "\t<tr><th scope=row>1/2 até 1 SM</th><td>rend_per_capita</td><td>1/2 até 1 SM       </td><td>2019</td><td>S020P</td><td>0.9413991</td><td>0.9069147</td><td>0.9758836</td><td>0.018689675</td></tr>\n",
       "\t<tr><th scope=row>1 até 2 SM</th><td>rend_per_capita</td><td>1 até 2 SM         </td><td>2019</td><td>S020P</td><td>0.9616164</td><td>0.9246481</td><td>0.9985846</td><td>0.019614569</td></tr>\n",
       "\t<tr><th scope=row>2 até 3 SM</th><td>rend_per_capita</td><td>2 até 3 SM         </td><td>2019</td><td>S020P</td><td>0.9887464</td><td>0.9716482</td><td>1.0058446</td><td>0.008823016</td></tr>\n",
       "\t<tr><th scope=row>Mais de 3 SM</th><td>rend_per_capita</td><td>Mais de 3 SM       </td><td>2019</td><td>S020P</td><td>0.9642104</td><td>0.9161889</td><td>1.0122318</td><td>0.025410618</td></tr>\n",
       "\t<tr><th scope=row>18 a 24 anos</th><td>fx_idade_s     </td><td>18 a 24 anos       </td><td>2019</td><td>S020P</td><td>0.9495413</td><td>0.9244755</td><td>0.9746072</td><td>0.013468538</td></tr>\n",
       "\t<tr><th scope=row>25 a 29 anos</th><td>fx_idade_s     </td><td>25 a 29 anos       </td><td>2019</td><td>S020P</td><td>0.9529889</td><td>0.9344372</td><td>0.9715406</td><td>0.009932271</td></tr>\n",
       "\t<tr><th scope=row>30 a 39 anos</th><td>fx_idade_s     </td><td>30 a 39 anos       </td><td>2019</td><td>S020P</td><td>0.9332568</td><td>0.9026042</td><td>0.9639095</td><td>0.016757868</td></tr>\n",
       "\t<tr><th scope=row>40 anos ou mais</th><td>fx_idade_s     </td><td>40 anos ou mais    </td><td>2019</td><td>S020P</td><td>0.9370615</td><td>0.8874357</td><td>0.9866874</td><td>0.027020387</td></tr>\n",
       "\t<tr><th scope=row>urbano</th><td>urb_rur        </td><td>urbano             </td><td>2019</td><td>S020P</td><td>0.9462480</td><td>0.9285206</td><td>0.9639755</td><td>0.009558592</td></tr>\n",
       "\t<tr><th scope=row>rural</th><td>urb_rur        </td><td>rural              </td><td>2019</td><td>S020P</td><td>0.9244595</td><td>0.8935373</td><td>0.9553818</td><td>0.017066135</td></tr>\n",
       "\t<tr><th scope=row>Rondônia</th><td>uf             </td><td>Rondônia           </td><td>2019</td><td>S020P</td><td>0.8862161</td><td>0.8171283</td><td>0.9553040</td><td>0.039775344</td></tr>\n",
       "\t<tr><th scope=row>Acre</th><td>uf             </td><td>Acre               </td><td>2019</td><td>S020P</td><td>0.9384015</td><td>0.8740413</td><td>1.0027618</td><td>0.034992968</td></tr>\n",
       "\t<tr><th scope=row>Amazonas</th><td>uf             </td><td>Amazonas           </td><td>2019</td><td>S020P</td><td>0.8776843</td><td>0.8087780</td><td>0.9465905</td><td>0.040056436</td></tr>\n",
       "\t<tr><th scope=row>Roraima</th><td>uf             </td><td>Roraima            </td><td>2019</td><td>S020P</td><td>0.9469861</td><td>0.9000798</td><td>0.9938923</td><td>0.025271953</td></tr>\n",
       "\t<tr><th scope=row>Pará</th><td>uf             </td><td>Pará               </td><td>2019</td><td>S020P</td><td>0.9306247</td><td>0.8747821</td><td>0.9864672</td><td>0.030615586</td></tr>\n",
       "\t<tr><th scope=row>Amapá</th><td>uf             </td><td>Amapá              </td><td>2019</td><td>S020P</td><td>0.9275277</td><td>0.8519172</td><td>1.0031382</td><td>0.041591750</td></tr>\n",
       "\t<tr><th scope=row>Tocantins</th><td>uf             </td><td>Tocantins          </td><td>2019</td><td>S020P</td><td>0.9361957</td><td>0.8448937</td><td>1.0274977</td><td>0.049758309</td></tr>\n",
       "\t<tr><th scope=row>Maranhão</th><td>uf             </td><td>Maranhão           </td><td>2019</td><td>S020P</td><td>0.9482602</td><td>0.9167190</td><td>0.9798014</td><td>0.016970815</td></tr>\n",
       "\t<tr><th scope=row>Piauí</th><td>uf             </td><td>Piauí              </td><td>2019</td><td>S020P</td><td>0.9468641</td><td>0.9035875</td><td>0.9901407</td><td>0.023319385</td></tr>\n",
       "\t<tr><th scope=row>Ceará</th><td>uf             </td><td>Ceará              </td><td>2019</td><td>S020P</td><td>0.9822641</td><td>0.9478668</td><td>1.0166614</td><td>0.017866842</td></tr>\n",
       "\t<tr><th scope=row>Rio Grande do Norte</th><td>uf             </td><td>Rio Grande do Norte</td><td>2019</td><td>S020P</td><td>0.9232503</td><td>0.8679509</td><td>0.9785498</td><td>0.030559988</td></tr>\n",
       "\t<tr><th scope=row>Paraíba</th><td>uf             </td><td>Paraíba            </td><td>2019</td><td>S020P</td><td>0.9439027</td><td>0.8976978</td><td>0.9901076</td><td>0.024975396</td></tr>\n",
       "\t<tr><th scope=row>Pernambuco</th><td>uf             </td><td>Pernambuco         </td><td>2019</td><td>S020P</td><td>0.8733903</td><td>0.7446742</td><td>1.0021063</td><td>0.075192807</td></tr>\n",
       "\t<tr><th scope=row>Alagoas</th><td>uf             </td><td>Alagoas            </td><td>2019</td><td>S020P</td><td>0.9651868</td><td>0.9326968</td><td>0.9976769</td><td>0.017174762</td></tr>\n",
       "\t<tr><th scope=row>Sergipe</th><td>uf             </td><td>Sergipe            </td><td>2019</td><td>S020P</td><td>0.9699511</td><td>0.9274677</td><td>1.0124344</td><td>0.022347080</td></tr>\n",
       "\t<tr><th scope=row>Bahia</th><td>uf             </td><td>Bahia              </td><td>2019</td><td>S020P</td><td>0.9805097</td><td>0.9530631</td><td>1.0079562</td><td>0.014281971</td></tr>\n",
       "\t<tr><th scope=row>⋮</th><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td></tr>\n",
       "\t<tr><th scope=row>Sudeste5</th><td>região         </td><td>Sudeste                              </td><td>2019</td><td>S025P</td><td>0.13334405</td><td>0.08904333</td><td>0.17764477</td><td>0.1695076</td></tr>\n",
       "\t<tr><th scope=row>Sul5</th><td>região         </td><td>Sul                                  </td><td>2019</td><td>S025P</td><td>0.12806156</td><td>0.07922818</td><td>0.17689494</td><td>0.1945584</td></tr>\n",
       "\t<tr><th scope=row>Centro-Oeste5</th><td>região         </td><td>Centro-Oeste                         </td><td>2019</td><td>S025P</td><td>0.13347382</td><td>0.08438707</td><td>0.18256058</td><td>0.1876377</td></tr>\n",
       "\t<tr><th scope=row>Fundamental incompleto ou equivalente5</th><td>gescol         </td><td>Fundamental incompleto ou equivalente</td><td>2019</td><td>S025P</td><td>0.16858638</td><td>0.11590749</td><td>0.22126528</td><td>0.1594285</td></tr>\n",
       "\t<tr><th scope=row>Médio incompleto ou equivalente5</th><td>gescol         </td><td>Médio incompleto ou equivalente      </td><td>2019</td><td>S025P</td><td>0.16503723</td><td>0.11415347</td><td>0.21592099</td><td>0.1573074</td></tr>\n",
       "\t<tr><th scope=row>Superior incompleto ou equivalente5</th><td>gescol         </td><td>Superior incompleto ou equivalente   </td><td>2019</td><td>S025P</td><td>0.12789785</td><td>0.10017951</td><td>0.15561619</td><td>0.1105747</td></tr>\n",
       "\t<tr><th scope=row>Superior completo5</th><td>gescol         </td><td>Superior completo                    </td><td>2019</td><td>S025P</td><td>0.11136936</td><td>0.06900445</td><td>0.15373428</td><td>0.1940852</td></tr>\n",
       "\t<tr><th scope=row>Branca6</th><td>raça           </td><td>Branca                               </td><td>2019</td><td>S026P</td><td>0.08305509</td><td>0.05280832</td><td>0.11330186</td><td>0.1858081</td></tr>\n",
       "\t<tr><th scope=row>Preta6</th><td>raça           </td><td>Preta                                </td><td>2019</td><td>S026P</td><td>0.08955581</td><td>0.03930327</td><td>0.13980835</td><td>0.2862966</td></tr>\n",
       "\t<tr><th scope=row>Parda6</th><td>raça           </td><td>Parda                                </td><td>2019</td><td>S026P</td><td>0.09970484</td><td>0.07352162</td><td>0.12588806</td><td>0.1339858</td></tr>\n",
       "\t<tr><th scope=row>Até 1/2 SM6</th><td>rend_per_capita</td><td>Até 1/2 SM                           </td><td>2019</td><td>S026P</td><td>0.09639457</td><td>0.07007214</td><td>0.12271699</td><td>0.1393238</td></tr>\n",
       "\t<tr><th scope=row>1/2 até 1 SM6</th><td>rend_per_capita</td><td>1/2 até 1 SM                         </td><td>2019</td><td>S026P</td><td>0.08061936</td><td>0.04815518</td><td>0.11308354</td><td>0.2054551</td></tr>\n",
       "\t<tr><th scope=row>1 até 2 SM6</th><td>rend_per_capita</td><td>1 até 2 SM                           </td><td>2019</td><td>S026P</td><td>0.08099726</td><td>0.03497868</td><td>0.12701584</td><td>0.2898777</td></tr>\n",
       "\t<tr><th scope=row>2 até 3 SM6</th><td>rend_per_capita</td><td>2 até 3 SM                           </td><td>2019</td><td>S026P</td><td>0.13168372</td><td>0.01618990</td><td>0.24717754</td><td>0.4474851</td></tr>\n",
       "\t<tr><th scope=row>Mais de 3 SM6</th><td>rend_per_capita</td><td>Mais de 3 SM                         </td><td>2019</td><td>S026P</td><td>0.11071546</td><td>0.02886413</td><td>0.19256679</td><td>0.3771980</td></tr>\n",
       "\t<tr><th scope=row>18 a 24 anos6</th><td>fx_idade_s     </td><td>18 a 24 anos                         </td><td>2019</td><td>S026P</td><td>0.06707236</td><td>0.04321910</td><td>0.09092562</td><td>0.1814496</td></tr>\n",
       "\t<tr><th scope=row>25 a 29 anos6</th><td>fx_idade_s     </td><td>25 a 29 anos                         </td><td>2019</td><td>S026P</td><td>0.09006160</td><td>0.05263542</td><td>0.12748778</td><td>0.2120253</td></tr>\n",
       "\t<tr><th scope=row>30 a 39 anos6</th><td>fx_idade_s     </td><td>30 a 39 anos                         </td><td>2019</td><td>S026P</td><td>0.11228868</td><td>0.07823102</td><td>0.14634634</td><td>0.1547500</td></tr>\n",
       "\t<tr><th scope=row>40 anos ou mais6</th><td>fx_idade_s     </td><td>40 anos ou mais                      </td><td>2019</td><td>S026P</td><td>0.08040375</td><td>0.03261232</td><td>0.12819518</td><td>0.3032673</td></tr>\n",
       "\t<tr><th scope=row>urbano6</th><td>urb_rur        </td><td>urbano                               </td><td>2019</td><td>S026P</td><td>0.09123426</td><td>0.07078246</td><td>0.11168607</td><td>0.1143736</td></tr>\n",
       "\t<tr><th scope=row>rural6</th><td>urb_rur        </td><td>rural                                </td><td>2019</td><td>S026P</td><td>0.09491624</td><td>0.05783730</td><td>0.13199517</td><td>0.1993144</td></tr>\n",
       "\t<tr><th scope=row>Norte6</th><td>região         </td><td>Norte                                </td><td>2019</td><td>S026P</td><td>0.08748685</td><td>0.05386950</td><td>0.12110419</td><td>0.1960526</td></tr>\n",
       "\t<tr><th scope=row>Nordeste6</th><td>região         </td><td>Nordeste                             </td><td>2019</td><td>S026P</td><td>0.08794721</td><td>0.06295773</td><td>0.11293669</td><td>0.1449730</td></tr>\n",
       "\t<tr><th scope=row>Sudeste6</th><td>região         </td><td>Sudeste                              </td><td>2019</td><td>S026P</td><td>0.09298834</td><td>0.05444746</td><td>0.13152923</td><td>0.2114682</td></tr>\n",
       "\t<tr><th scope=row>Sul6</th><td>região         </td><td>Sul                                  </td><td>2019</td><td>S026P</td><td>0.11172938</td><td>0.06460214</td><td>0.15885661</td><td>0.2152070</td></tr>\n",
       "\t<tr><th scope=row>Centro-Oeste6</th><td>região         </td><td>Centro-Oeste                         </td><td>2019</td><td>S026P</td><td>0.07506477</td><td>0.04169546</td><td>0.10843408</td><td>0.2268104</td></tr>\n",
       "\t<tr><th scope=row>Fundamental incompleto ou equivalente6</th><td>gescol         </td><td>Fundamental incompleto ou equivalente</td><td>2019</td><td>S026P</td><td>0.12548939</td><td>0.07474790</td><td>0.17623088</td><td>0.2063042</td></tr>\n",
       "\t<tr><th scope=row>Médio incompleto ou equivalente6</th><td>gescol         </td><td>Médio incompleto ou equivalente      </td><td>2019</td><td>S026P</td><td>0.11484022</td><td>0.06966174</td><td>0.16001871</td><td>0.2007195</td></tr>\n",
       "\t<tr><th scope=row>Superior incompleto ou equivalente6</th><td>gescol         </td><td>Superior incompleto ou equivalente   </td><td>2019</td><td>S026P</td><td>0.06364051</td><td>0.04203844</td><td>0.08524259</td><td>0.1731864</td></tr>\n",
       "\t<tr><th scope=row>Superior completo6</th><td>gescol         </td><td>Superior completo                    </td><td>2019</td><td>S026P</td><td>0.10049694</td><td>0.05485221</td><td>0.14614167</td><td>0.2317340</td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "A data.frame: 404 × 8\n",
       "\\begin{tabular}{r|llllllll}\n",
       "  & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n",
       "  & <chr> & <fct> & <chr> & <chr> & <dbl> & <dbl> & <dbl> & <dbl>\\\\\n",
       "\\hline\n",
       "\tBranca & raça            & Branca              & 2019 & S020P & 0.9462652 & 0.9150585 & 0.9774720 & 0.016826270\\\\\n",
       "\tPreta & raça            & Preta               & 2019 & S020P & 0.9491546 & 0.9190134 & 0.9792958 & 0.016202236\\\\\n",
       "\tParda & raça            & Parda               & 2019 & S020P & 0.9406377 & 0.9204789 & 0.9607964 & 0.010934363\\\\\n",
       "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM          & 2019 & S020P & 0.9296724 & 0.9109426 & 0.9484022 & 0.010279112\\\\\n",
       "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM        & 2019 & S020P & 0.9413991 & 0.9069147 & 0.9758836 & 0.018689675\\\\\n",
       "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM          & 2019 & S020P & 0.9616164 & 0.9246481 & 0.9985846 & 0.019614569\\\\\n",
       "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM          & 2019 & S020P & 0.9887464 & 0.9716482 & 1.0058446 & 0.008823016\\\\\n",
       "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM        & 2019 & S020P & 0.9642104 & 0.9161889 & 1.0122318 & 0.025410618\\\\\n",
       "\t18 a 24 anos & fx\\_idade\\_s      & 18 a 24 anos        & 2019 & S020P & 0.9495413 & 0.9244755 & 0.9746072 & 0.013468538\\\\\n",
       "\t25 a 29 anos & fx\\_idade\\_s      & 25 a 29 anos        & 2019 & S020P & 0.9529889 & 0.9344372 & 0.9715406 & 0.009932271\\\\\n",
       "\t30 a 39 anos & fx\\_idade\\_s      & 30 a 39 anos        & 2019 & S020P & 0.9332568 & 0.9026042 & 0.9639095 & 0.016757868\\\\\n",
       "\t40 anos ou mais & fx\\_idade\\_s      & 40 anos ou mais     & 2019 & S020P & 0.9370615 & 0.8874357 & 0.9866874 & 0.027020387\\\\\n",
       "\turbano & urb\\_rur         & urbano              & 2019 & S020P & 0.9462480 & 0.9285206 & 0.9639755 & 0.009558592\\\\\n",
       "\trural & urb\\_rur         & rural               & 2019 & S020P & 0.9244595 & 0.8935373 & 0.9553818 & 0.017066135\\\\\n",
       "\tRondônia & uf              & Rondônia            & 2019 & S020P & 0.8862161 & 0.8171283 & 0.9553040 & 0.039775344\\\\\n",
       "\tAcre & uf              & Acre                & 2019 & S020P & 0.9384015 & 0.8740413 & 1.0027618 & 0.034992968\\\\\n",
       "\tAmazonas & uf              & Amazonas            & 2019 & S020P & 0.8776843 & 0.8087780 & 0.9465905 & 0.040056436\\\\\n",
       "\tRoraima & uf              & Roraima             & 2019 & S020P & 0.9469861 & 0.9000798 & 0.9938923 & 0.025271953\\\\\n",
       "\tPará & uf              & Pará                & 2019 & S020P & 0.9306247 & 0.8747821 & 0.9864672 & 0.030615586\\\\\n",
       "\tAmapá & uf              & Amapá               & 2019 & S020P & 0.9275277 & 0.8519172 & 1.0031382 & 0.041591750\\\\\n",
       "\tTocantins & uf              & Tocantins           & 2019 & S020P & 0.9361957 & 0.8448937 & 1.0274977 & 0.049758309\\\\\n",
       "\tMaranhão & uf              & Maranhão            & 2019 & S020P & 0.9482602 & 0.9167190 & 0.9798014 & 0.016970815\\\\\n",
       "\tPiauí & uf              & Piauí               & 2019 & S020P & 0.9468641 & 0.9035875 & 0.9901407 & 0.023319385\\\\\n",
       "\tCeará & uf              & Ceará               & 2019 & S020P & 0.9822641 & 0.9478668 & 1.0166614 & 0.017866842\\\\\n",
       "\tRio Grande do Norte & uf              & Rio Grande do Norte & 2019 & S020P & 0.9232503 & 0.8679509 & 0.9785498 & 0.030559988\\\\\n",
       "\tParaíba & uf              & Paraíba             & 2019 & S020P & 0.9439027 & 0.8976978 & 0.9901076 & 0.024975396\\\\\n",
       "\tPernambuco & uf              & Pernambuco          & 2019 & S020P & 0.8733903 & 0.7446742 & 1.0021063 & 0.075192807\\\\\n",
       "\tAlagoas & uf              & Alagoas             & 2019 & S020P & 0.9651868 & 0.9326968 & 0.9976769 & 0.017174762\\\\\n",
       "\tSergipe & uf              & Sergipe             & 2019 & S020P & 0.9699511 & 0.9274677 & 1.0124344 & 0.022347080\\\\\n",
       "\tBahia & uf              & Bahia               & 2019 & S020P & 0.9805097 & 0.9530631 & 1.0079562 & 0.014281971\\\\\n",
       "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n",
       "\tSudeste5 & região          & Sudeste                               & 2019 & S025P & 0.13334405 & 0.08904333 & 0.17764477 & 0.1695076\\\\\n",
       "\tSul5 & região          & Sul                                   & 2019 & S025P & 0.12806156 & 0.07922818 & 0.17689494 & 0.1945584\\\\\n",
       "\tCentro-Oeste5 & região          & Centro-Oeste                          & 2019 & S025P & 0.13347382 & 0.08438707 & 0.18256058 & 0.1876377\\\\\n",
       "\tFundamental incompleto ou equivalente5 & gescol          & Fundamental incompleto ou equivalente & 2019 & S025P & 0.16858638 & 0.11590749 & 0.22126528 & 0.1594285\\\\\n",
       "\tMédio incompleto ou equivalente5 & gescol          & Médio incompleto ou equivalente       & 2019 & S025P & 0.16503723 & 0.11415347 & 0.21592099 & 0.1573074\\\\\n",
       "\tSuperior incompleto ou equivalente5 & gescol          & Superior incompleto ou equivalente    & 2019 & S025P & 0.12789785 & 0.10017951 & 0.15561619 & 0.1105747\\\\\n",
       "\tSuperior completo5 & gescol          & Superior completo                     & 2019 & S025P & 0.11136936 & 0.06900445 & 0.15373428 & 0.1940852\\\\\n",
       "\tBranca6 & raça            & Branca                                & 2019 & S026P & 0.08305509 & 0.05280832 & 0.11330186 & 0.1858081\\\\\n",
       "\tPreta6 & raça            & Preta                                 & 2019 & S026P & 0.08955581 & 0.03930327 & 0.13980835 & 0.2862966\\\\\n",
       "\tParda6 & raça            & Parda                                 & 2019 & S026P & 0.09970484 & 0.07352162 & 0.12588806 & 0.1339858\\\\\n",
       "\tAté 1/2 SM6 & rend\\_per\\_capita & Até 1/2 SM                            & 2019 & S026P & 0.09639457 & 0.07007214 & 0.12271699 & 0.1393238\\\\\n",
       "\t1/2 até 1 SM6 & rend\\_per\\_capita & 1/2 até 1 SM                          & 2019 & S026P & 0.08061936 & 0.04815518 & 0.11308354 & 0.2054551\\\\\n",
       "\t1 até 2 SM6 & rend\\_per\\_capita & 1 até 2 SM                            & 2019 & S026P & 0.08099726 & 0.03497868 & 0.12701584 & 0.2898777\\\\\n",
       "\t2 até 3 SM6 & rend\\_per\\_capita & 2 até 3 SM                            & 2019 & S026P & 0.13168372 & 0.01618990 & 0.24717754 & 0.4474851\\\\\n",
       "\tMais de 3 SM6 & rend\\_per\\_capita & Mais de 3 SM                          & 2019 & S026P & 0.11071546 & 0.02886413 & 0.19256679 & 0.3771980\\\\\n",
       "\t18 a 24 anos6 & fx\\_idade\\_s      & 18 a 24 anos                          & 2019 & S026P & 0.06707236 & 0.04321910 & 0.09092562 & 0.1814496\\\\\n",
       "\t25 a 29 anos6 & fx\\_idade\\_s      & 25 a 29 anos                          & 2019 & S026P & 0.09006160 & 0.05263542 & 0.12748778 & 0.2120253\\\\\n",
       "\t30 a 39 anos6 & fx\\_idade\\_s      & 30 a 39 anos                          & 2019 & S026P & 0.11228868 & 0.07823102 & 0.14634634 & 0.1547500\\\\\n",
       "\t40 anos ou mais6 & fx\\_idade\\_s      & 40 anos ou mais                       & 2019 & S026P & 0.08040375 & 0.03261232 & 0.12819518 & 0.3032673\\\\\n",
       "\turbano6 & urb\\_rur         & urbano                                & 2019 & S026P & 0.09123426 & 0.07078246 & 0.11168607 & 0.1143736\\\\\n",
       "\trural6 & urb\\_rur         & rural                                 & 2019 & S026P & 0.09491624 & 0.05783730 & 0.13199517 & 0.1993144\\\\\n",
       "\tNorte6 & região          & Norte                                 & 2019 & S026P & 0.08748685 & 0.05386950 & 0.12110419 & 0.1960526\\\\\n",
       "\tNordeste6 & região          & Nordeste                              & 2019 & S026P & 0.08794721 & 0.06295773 & 0.11293669 & 0.1449730\\\\\n",
       "\tSudeste6 & região          & Sudeste                               & 2019 & S026P & 0.09298834 & 0.05444746 & 0.13152923 & 0.2114682\\\\\n",
       "\tSul6 & região          & Sul                                   & 2019 & S026P & 0.11172938 & 0.06460214 & 0.15885661 & 0.2152070\\\\\n",
       "\tCentro-Oeste6 & região          & Centro-Oeste                          & 2019 & S026P & 0.07506477 & 0.04169546 & 0.10843408 & 0.2268104\\\\\n",
       "\tFundamental incompleto ou equivalente6 & gescol          & Fundamental incompleto ou equivalente & 2019 & S026P & 0.12548939 & 0.07474790 & 0.17623088 & 0.2063042\\\\\n",
       "\tMédio incompleto ou equivalente6 & gescol          & Médio incompleto ou equivalente       & 2019 & S026P & 0.11484022 & 0.06966174 & 0.16001871 & 0.2007195\\\\\n",
       "\tSuperior incompleto ou equivalente6 & gescol          & Superior incompleto ou equivalente    & 2019 & S026P & 0.06364051 & 0.04203844 & 0.08524259 & 0.1731864\\\\\n",
       "\tSuperior completo6 & gescol          & Superior completo                     & 2019 & S026P & 0.10049694 & 0.05485221 & 0.14614167 & 0.2317340\\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "A data.frame: 404 × 8\n",
       "\n",
       "| <!--/--> | abr_tipo &lt;chr&gt; | abr_nome &lt;fct&gt; | Ano &lt;chr&gt; | Indicador &lt;chr&gt; | Sim &lt;dbl&gt; | LowerS &lt;dbl&gt; | UpperS &lt;dbl&gt; | cvS &lt;dbl&gt; |\n",
       "|---|---|---|---|---|---|---|---|---|\n",
       "| Branca | raça            | Branca              | 2019 | S020P | 0.9462652 | 0.9150585 | 0.9774720 | 0.016826270 |\n",
       "| Preta | raça            | Preta               | 2019 | S020P | 0.9491546 | 0.9190134 | 0.9792958 | 0.016202236 |\n",
       "| Parda | raça            | Parda               | 2019 | S020P | 0.9406377 | 0.9204789 | 0.9607964 | 0.010934363 |\n",
       "| Até 1/2 SM | rend_per_capita | Até 1/2 SM          | 2019 | S020P | 0.9296724 | 0.9109426 | 0.9484022 | 0.010279112 |\n",
       "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM        | 2019 | S020P | 0.9413991 | 0.9069147 | 0.9758836 | 0.018689675 |\n",
       "| 1 até 2 SM | rend_per_capita | 1 até 2 SM          | 2019 | S020P | 0.9616164 | 0.9246481 | 0.9985846 | 0.019614569 |\n",
       "| 2 até 3 SM | rend_per_capita | 2 até 3 SM          | 2019 | S020P | 0.9887464 | 0.9716482 | 1.0058446 | 0.008823016 |\n",
       "| Mais de 3 SM | rend_per_capita | Mais de 3 SM        | 2019 | S020P | 0.9642104 | 0.9161889 | 1.0122318 | 0.025410618 |\n",
       "| 18 a 24 anos | fx_idade_s      | 18 a 24 anos        | 2019 | S020P | 0.9495413 | 0.9244755 | 0.9746072 | 0.013468538 |\n",
       "| 25 a 29 anos | fx_idade_s      | 25 a 29 anos        | 2019 | S020P | 0.9529889 | 0.9344372 | 0.9715406 | 0.009932271 |\n",
       "| 30 a 39 anos | fx_idade_s      | 30 a 39 anos        | 2019 | S020P | 0.9332568 | 0.9026042 | 0.9639095 | 0.016757868 |\n",
       "| 40 anos ou mais | fx_idade_s      | 40 anos ou mais     | 2019 | S020P | 0.9370615 | 0.8874357 | 0.9866874 | 0.027020387 |\n",
       "| urbano | urb_rur         | urbano              | 2019 | S020P | 0.9462480 | 0.9285206 | 0.9639755 | 0.009558592 |\n",
       "| rural | urb_rur         | rural               | 2019 | S020P | 0.9244595 | 0.8935373 | 0.9553818 | 0.017066135 |\n",
       "| Rondônia | uf              | Rondônia            | 2019 | S020P | 0.8862161 | 0.8171283 | 0.9553040 | 0.039775344 |\n",
       "| Acre | uf              | Acre                | 2019 | S020P | 0.9384015 | 0.8740413 | 1.0027618 | 0.034992968 |\n",
       "| Amazonas | uf              | Amazonas            | 2019 | S020P | 0.8776843 | 0.8087780 | 0.9465905 | 0.040056436 |\n",
       "| Roraima | uf              | Roraima             | 2019 | S020P | 0.9469861 | 0.9000798 | 0.9938923 | 0.025271953 |\n",
       "| Pará | uf              | Pará                | 2019 | S020P | 0.9306247 | 0.8747821 | 0.9864672 | 0.030615586 |\n",
       "| Amapá | uf              | Amapá               | 2019 | S020P | 0.9275277 | 0.8519172 | 1.0031382 | 0.041591750 |\n",
       "| Tocantins | uf              | Tocantins           | 2019 | S020P | 0.9361957 | 0.8448937 | 1.0274977 | 0.049758309 |\n",
       "| Maranhão | uf              | Maranhão            | 2019 | S020P | 0.9482602 | 0.9167190 | 0.9798014 | 0.016970815 |\n",
       "| Piauí | uf              | Piauí               | 2019 | S020P | 0.9468641 | 0.9035875 | 0.9901407 | 0.023319385 |\n",
       "| Ceará | uf              | Ceará               | 2019 | S020P | 0.9822641 | 0.9478668 | 1.0166614 | 0.017866842 |\n",
       "| Rio Grande do Norte | uf              | Rio Grande do Norte | 2019 | S020P | 0.9232503 | 0.8679509 | 0.9785498 | 0.030559988 |\n",
       "| Paraíba | uf              | Paraíba             | 2019 | S020P | 0.9439027 | 0.8976978 | 0.9901076 | 0.024975396 |\n",
       "| Pernambuco | uf              | Pernambuco          | 2019 | S020P | 0.8733903 | 0.7446742 | 1.0021063 | 0.075192807 |\n",
       "| Alagoas | uf              | Alagoas             | 2019 | S020P | 0.9651868 | 0.9326968 | 0.9976769 | 0.017174762 |\n",
       "| Sergipe | uf              | Sergipe             | 2019 | S020P | 0.9699511 | 0.9274677 | 1.0124344 | 0.022347080 |\n",
       "| Bahia | uf              | Bahia               | 2019 | S020P | 0.9805097 | 0.9530631 | 1.0079562 | 0.014281971 |\n",
       "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n",
       "| Sudeste5 | região          | Sudeste                               | 2019 | S025P | 0.13334405 | 0.08904333 | 0.17764477 | 0.1695076 |\n",
       "| Sul5 | região          | Sul                                   | 2019 | S025P | 0.12806156 | 0.07922818 | 0.17689494 | 0.1945584 |\n",
       "| Centro-Oeste5 | região          | Centro-Oeste                          | 2019 | S025P | 0.13347382 | 0.08438707 | 0.18256058 | 0.1876377 |\n",
       "| Fundamental incompleto ou equivalente5 | gescol          | Fundamental incompleto ou equivalente | 2019 | S025P | 0.16858638 | 0.11590749 | 0.22126528 | 0.1594285 |\n",
       "| Médio incompleto ou equivalente5 | gescol          | Médio incompleto ou equivalente       | 2019 | S025P | 0.16503723 | 0.11415347 | 0.21592099 | 0.1573074 |\n",
       "| Superior incompleto ou equivalente5 | gescol          | Superior incompleto ou equivalente    | 2019 | S025P | 0.12789785 | 0.10017951 | 0.15561619 | 0.1105747 |\n",
       "| Superior completo5 | gescol          | Superior completo                     | 2019 | S025P | 0.11136936 | 0.06900445 | 0.15373428 | 0.1940852 |\n",
       "| Branca6 | raça            | Branca                                | 2019 | S026P | 0.08305509 | 0.05280832 | 0.11330186 | 0.1858081 |\n",
       "| Preta6 | raça            | Preta                                 | 2019 | S026P | 0.08955581 | 0.03930327 | 0.13980835 | 0.2862966 |\n",
       "| Parda6 | raça            | Parda                                 | 2019 | S026P | 0.09970484 | 0.07352162 | 0.12588806 | 0.1339858 |\n",
       "| Até 1/2 SM6 | rend_per_capita | Até 1/2 SM                            | 2019 | S026P | 0.09639457 | 0.07007214 | 0.12271699 | 0.1393238 |\n",
       "| 1/2 até 1 SM6 | rend_per_capita | 1/2 até 1 SM                          | 2019 | S026P | 0.08061936 | 0.04815518 | 0.11308354 | 0.2054551 |\n",
       "| 1 até 2 SM6 | rend_per_capita | 1 até 2 SM                            | 2019 | S026P | 0.08099726 | 0.03497868 | 0.12701584 | 0.2898777 |\n",
       "| 2 até 3 SM6 | rend_per_capita | 2 até 3 SM                            | 2019 | S026P | 0.13168372 | 0.01618990 | 0.24717754 | 0.4474851 |\n",
       "| Mais de 3 SM6 | rend_per_capita | Mais de 3 SM                          | 2019 | S026P | 0.11071546 | 0.02886413 | 0.19256679 | 0.3771980 |\n",
       "| 18 a 24 anos6 | fx_idade_s      | 18 a 24 anos                          | 2019 | S026P | 0.06707236 | 0.04321910 | 0.09092562 | 0.1814496 |\n",
       "| 25 a 29 anos6 | fx_idade_s      | 25 a 29 anos                          | 2019 | S026P | 0.09006160 | 0.05263542 | 0.12748778 | 0.2120253 |\n",
       "| 30 a 39 anos6 | fx_idade_s      | 30 a 39 anos                          | 2019 | S026P | 0.11228868 | 0.07823102 | 0.14634634 | 0.1547500 |\n",
       "| 40 anos ou mais6 | fx_idade_s      | 40 anos ou mais                       | 2019 | S026P | 0.08040375 | 0.03261232 | 0.12819518 | 0.3032673 |\n",
       "| urbano6 | urb_rur         | urbano                                | 2019 | S026P | 0.09123426 | 0.07078246 | 0.11168607 | 0.1143736 |\n",
       "| rural6 | urb_rur         | rural                                 | 2019 | S026P | 0.09491624 | 0.05783730 | 0.13199517 | 0.1993144 |\n",
       "| Norte6 | região          | Norte                                 | 2019 | S026P | 0.08748685 | 0.05386950 | 0.12110419 | 0.1960526 |\n",
       "| Nordeste6 | região          | Nordeste                              | 2019 | S026P | 0.08794721 | 0.06295773 | 0.11293669 | 0.1449730 |\n",
       "| Sudeste6 | região          | Sudeste                               | 2019 | S026P | 0.09298834 | 0.05444746 | 0.13152923 | 0.2114682 |\n",
       "| Sul6 | região          | Sul                                   | 2019 | S026P | 0.11172938 | 0.06460214 | 0.15885661 | 0.2152070 |\n",
       "| Centro-Oeste6 | região          | Centro-Oeste                          | 2019 | S026P | 0.07506477 | 0.04169546 | 0.10843408 | 0.2268104 |\n",
       "| Fundamental incompleto ou equivalente6 | gescol          | Fundamental incompleto ou equivalente | 2019 | S026P | 0.12548939 | 0.07474790 | 0.17623088 | 0.2063042 |\n",
       "| Médio incompleto ou equivalente6 | gescol          | Médio incompleto ou equivalente       | 2019 | S026P | 0.11484022 | 0.06966174 | 0.16001871 | 0.2007195 |\n",
       "| Superior incompleto ou equivalente6 | gescol          | Superior incompleto ou equivalente    | 2019 | S026P | 0.06364051 | 0.04203844 | 0.08524259 | 0.1731864 |\n",
       "| Superior completo6 | gescol          | Superior completo                     | 2019 | S026P | 0.10049694 | 0.05485221 | 0.14614167 | 0.2317340 |\n",
       "\n"
      ],
      "text/plain": [
       "                                       abr_tipo       \n",
       "Branca                                 raça           \n",
       "Preta                                  raça           \n",
       "Parda                                  raça           \n",
       "Até 1/2 SM                             rend_per_capita\n",
       "1/2 até 1 SM                           rend_per_capita\n",
       "1 até 2 SM                             rend_per_capita\n",
       "2 até 3 SM                             rend_per_capita\n",
       "Mais de 3 SM                           rend_per_capita\n",
       "18 a 24 anos                           fx_idade_s     \n",
       "25 a 29 anos                           fx_idade_s     \n",
       "30 a 39 anos                           fx_idade_s     \n",
       "40 anos ou mais                        fx_idade_s     \n",
       "urbano                                 urb_rur        \n",
       "rural                                  urb_rur        \n",
       "Rondônia                               uf             \n",
       "Acre                                   uf             \n",
       "Amazonas                               uf             \n",
       "Roraima                                uf             \n",
       "Pará                                   uf             \n",
       "Amapá                                  uf             \n",
       "Tocantins                              uf             \n",
       "Maranhão                               uf             \n",
       "Piauí                                  uf             \n",
       "Ceará                                  uf             \n",
       "Rio Grande do Norte                    uf             \n",
       "Paraíba                                uf             \n",
       "Pernambuco                             uf             \n",
       "Alagoas                                uf             \n",
       "Sergipe                                uf             \n",
       "Bahia                                  uf             \n",
       "⋮                                      ⋮              \n",
       "Sudeste5                               região         \n",
       "Sul5                                   região         \n",
       "Centro-Oeste5                          região         \n",
       "Fundamental incompleto ou equivalente5 gescol         \n",
       "Médio incompleto ou equivalente5       gescol         \n",
       "Superior incompleto ou equivalente5    gescol         \n",
       "Superior completo5                     gescol         \n",
       "Branca6                                raça           \n",
       "Preta6                                 raça           \n",
       "Parda6                                 raça           \n",
       "Até 1/2 SM6                            rend_per_capita\n",
       "1/2 até 1 SM6                          rend_per_capita\n",
       "1 até 2 SM6                            rend_per_capita\n",
       "2 até 3 SM6                            rend_per_capita\n",
       "Mais de 3 SM6                          rend_per_capita\n",
       "18 a 24 anos6                          fx_idade_s     \n",
       "25 a 29 anos6                          fx_idade_s     \n",
       "30 a 39 anos6                          fx_idade_s     \n",
       "40 anos ou mais6                       fx_idade_s     \n",
       "urbano6                                urb_rur        \n",
       "rural6                                 urb_rur        \n",
       "Norte6                                 região         \n",
       "Nordeste6                              região         \n",
       "Sudeste6                               região         \n",
       "Sul6                                   região         \n",
       "Centro-Oeste6                          região         \n",
       "Fundamental incompleto ou equivalente6 gescol         \n",
       "Médio incompleto ou equivalente6       gescol         \n",
       "Superior incompleto ou equivalente6    gescol         \n",
       "Superior completo6                     gescol         \n",
       "                                       abr_nome                             \n",
       "Branca                                 Branca                               \n",
       "Preta                                  Preta                                \n",
       "Parda                                  Parda                                \n",
       "Até 1/2 SM                             Até 1/2 SM                           \n",
       "1/2 até 1 SM                           1/2 até 1 SM                         \n",
       "1 até 2 SM                             1 até 2 SM                           \n",
       "2 até 3 SM                             2 até 3 SM                           \n",
       "Mais de 3 SM                           Mais de 3 SM                         \n",
       "18 a 24 anos                           18 a 24 anos                         \n",
       "25 a 29 anos                           25 a 29 anos                         \n",
       "30 a 39 anos                           30 a 39 anos                         \n",
       "40 anos ou mais                        40 anos ou mais                      \n",
       "urbano                                 urbano                               \n",
       "rural                                  rural                                \n",
       "Rondônia                               Rondônia                             \n",
       "Acre                                   Acre                                 \n",
       "Amazonas                               Amazonas                             \n",
       "Roraima                                Roraima                              \n",
       "Pará                                   Pará                                 \n",
       "Amapá                                  Amapá                                \n",
       "Tocantins                              Tocantins                            \n",
       "Maranhão                               Maranhão                             \n",
       "Piauí                                  Piauí                                \n",
       "Ceará                                  Ceará                                \n",
       "Rio Grande do Norte                    Rio Grande do Norte                  \n",
       "Paraíba                                Paraíba                              \n",
       "Pernambuco                             Pernambuco                           \n",
       "Alagoas                                Alagoas                              \n",
       "Sergipe                                Sergipe                              \n",
       "Bahia                                  Bahia                                \n",
       "⋮                                      ⋮                                    \n",
       "Sudeste5                               Sudeste                              \n",
       "Sul5                                   Sul                                  \n",
       "Centro-Oeste5                          Centro-Oeste                         \n",
       "Fundamental incompleto ou equivalente5 Fundamental incompleto ou equivalente\n",
       "Médio incompleto ou equivalente5       Médio incompleto ou equivalente      \n",
       "Superior incompleto ou equivalente5    Superior incompleto ou equivalente   \n",
       "Superior completo5                     Superior completo                    \n",
       "Branca6                                Branca                               \n",
       "Preta6                                 Preta                                \n",
       "Parda6                                 Parda                                \n",
       "Até 1/2 SM6                            Até 1/2 SM                           \n",
       "1/2 até 1 SM6                          1/2 até 1 SM                         \n",
       "1 até 2 SM6                            1 até 2 SM                           \n",
       "2 até 3 SM6                            2 até 3 SM                           \n",
       "Mais de 3 SM6                          Mais de 3 SM                         \n",
       "18 a 24 anos6                          18 a 24 anos                         \n",
       "25 a 29 anos6                          25 a 29 anos                         \n",
       "30 a 39 anos6                          30 a 39 anos                         \n",
       "40 anos ou mais6                       40 anos ou mais                      \n",
       "urbano6                                urbano                               \n",
       "rural6                                 rural                                \n",
       "Norte6                                 Norte                                \n",
       "Nordeste6                              Nordeste                             \n",
       "Sudeste6                               Sudeste                              \n",
       "Sul6                                   Sul                                  \n",
       "Centro-Oeste6                          Centro-Oeste                         \n",
       "Fundamental incompleto ou equivalente6 Fundamental incompleto ou equivalente\n",
       "Médio incompleto ou equivalente6       Médio incompleto ou equivalente      \n",
       "Superior incompleto ou equivalente6    Superior incompleto ou equivalente   \n",
       "Superior completo6                     Superior completo                    \n",
       "                                       Ano  Indicador Sim        LowerS    \n",
       "Branca                                 2019 S020P     0.9462652  0.9150585 \n",
       "Preta                                  2019 S020P     0.9491546  0.9190134 \n",
       "Parda                                  2019 S020P     0.9406377  0.9204789 \n",
       "Até 1/2 SM                             2019 S020P     0.9296724  0.9109426 \n",
       "1/2 até 1 SM                           2019 S020P     0.9413991  0.9069147 \n",
       "1 até 2 SM                             2019 S020P     0.9616164  0.9246481 \n",
       "2 até 3 SM                             2019 S020P     0.9887464  0.9716482 \n",
       "Mais de 3 SM                           2019 S020P     0.9642104  0.9161889 \n",
       "18 a 24 anos                           2019 S020P     0.9495413  0.9244755 \n",
       "25 a 29 anos                           2019 S020P     0.9529889  0.9344372 \n",
       "30 a 39 anos                           2019 S020P     0.9332568  0.9026042 \n",
       "40 anos ou mais                        2019 S020P     0.9370615  0.8874357 \n",
       "urbano                                 2019 S020P     0.9462480  0.9285206 \n",
       "rural                                  2019 S020P     0.9244595  0.8935373 \n",
       "Rondônia                               2019 S020P     0.8862161  0.8171283 \n",
       "Acre                                   2019 S020P     0.9384015  0.8740413 \n",
       "Amazonas                               2019 S020P     0.8776843  0.8087780 \n",
       "Roraima                                2019 S020P     0.9469861  0.9000798 \n",
       "Pará                                   2019 S020P     0.9306247  0.8747821 \n",
       "Amapá                                  2019 S020P     0.9275277  0.8519172 \n",
       "Tocantins                              2019 S020P     0.9361957  0.8448937 \n",
       "Maranhão                               2019 S020P     0.9482602  0.9167190 \n",
       "Piauí                                  2019 S020P     0.9468641  0.9035875 \n",
       "Ceará                                  2019 S020P     0.9822641  0.9478668 \n",
       "Rio Grande do Norte                    2019 S020P     0.9232503  0.8679509 \n",
       "Paraíba                                2019 S020P     0.9439027  0.8976978 \n",
       "Pernambuco                             2019 S020P     0.8733903  0.7446742 \n",
       "Alagoas                                2019 S020P     0.9651868  0.9326968 \n",
       "Sergipe                                2019 S020P     0.9699511  0.9274677 \n",
       "Bahia                                  2019 S020P     0.9805097  0.9530631 \n",
       "⋮                                      ⋮    ⋮         ⋮          ⋮         \n",
       "Sudeste5                               2019 S025P     0.13334405 0.08904333\n",
       "Sul5                                   2019 S025P     0.12806156 0.07922818\n",
       "Centro-Oeste5                          2019 S025P     0.13347382 0.08438707\n",
       "Fundamental incompleto ou equivalente5 2019 S025P     0.16858638 0.11590749\n",
       "Médio incompleto ou equivalente5       2019 S025P     0.16503723 0.11415347\n",
       "Superior incompleto ou equivalente5    2019 S025P     0.12789785 0.10017951\n",
       "Superior completo5                     2019 S025P     0.11136936 0.06900445\n",
       "Branca6                                2019 S026P     0.08305509 0.05280832\n",
       "Preta6                                 2019 S026P     0.08955581 0.03930327\n",
       "Parda6                                 2019 S026P     0.09970484 0.07352162\n",
       "Até 1/2 SM6                            2019 S026P     0.09639457 0.07007214\n",
       "1/2 até 1 SM6                          2019 S026P     0.08061936 0.04815518\n",
       "1 até 2 SM6                            2019 S026P     0.08099726 0.03497868\n",
       "2 até 3 SM6                            2019 S026P     0.13168372 0.01618990\n",
       "Mais de 3 SM6                          2019 S026P     0.11071546 0.02886413\n",
       "18 a 24 anos6                          2019 S026P     0.06707236 0.04321910\n",
       "25 a 29 anos6                          2019 S026P     0.09006160 0.05263542\n",
       "30 a 39 anos6                          2019 S026P     0.11228868 0.07823102\n",
       "40 anos ou mais6                       2019 S026P     0.08040375 0.03261232\n",
       "urbano6                                2019 S026P     0.09123426 0.07078246\n",
       "rural6                                 2019 S026P     0.09491624 0.05783730\n",
       "Norte6                                 2019 S026P     0.08748685 0.05386950\n",
       "Nordeste6                              2019 S026P     0.08794721 0.06295773\n",
       "Sudeste6                               2019 S026P     0.09298834 0.05444746\n",
       "Sul6                                   2019 S026P     0.11172938 0.06460214\n",
       "Centro-Oeste6                          2019 S026P     0.07506477 0.04169546\n",
       "Fundamental incompleto ou equivalente6 2019 S026P     0.12548939 0.07474790\n",
       "Médio incompleto ou equivalente6       2019 S026P     0.11484022 0.06966174\n",
       "Superior incompleto ou equivalente6    2019 S026P     0.06364051 0.04203844\n",
       "Superior completo6                     2019 S026P     0.10049694 0.05485221\n",
       "                                       UpperS     cvS        \n",
       "Branca                                 0.9774720  0.016826270\n",
       "Preta                                  0.9792958  0.016202236\n",
       "Parda                                  0.9607964  0.010934363\n",
       "Até 1/2 SM                             0.9484022  0.010279112\n",
       "1/2 até 1 SM                           0.9758836  0.018689675\n",
       "1 até 2 SM                             0.9985846  0.019614569\n",
       "2 até 3 SM                             1.0058446  0.008823016\n",
       "Mais de 3 SM                           1.0122318  0.025410618\n",
       "18 a 24 anos                           0.9746072  0.013468538\n",
       "25 a 29 anos                           0.9715406  0.009932271\n",
       "30 a 39 anos                           0.9639095  0.016757868\n",
       "40 anos ou mais                        0.9866874  0.027020387\n",
       "urbano                                 0.9639755  0.009558592\n",
       "rural                                  0.9553818  0.017066135\n",
       "Rondônia                               0.9553040  0.039775344\n",
       "Acre                                   1.0027618  0.034992968\n",
       "Amazonas                               0.9465905  0.040056436\n",
       "Roraima                                0.9938923  0.025271953\n",
       "Pará                                   0.9864672  0.030615586\n",
       "Amapá                                  1.0031382  0.041591750\n",
       "Tocantins                              1.0274977  0.049758309\n",
       "Maranhão                               0.9798014  0.016970815\n",
       "Piauí                                  0.9901407  0.023319385\n",
       "Ceará                                  1.0166614  0.017866842\n",
       "Rio Grande do Norte                    0.9785498  0.030559988\n",
       "Paraíba                                0.9901076  0.024975396\n",
       "Pernambuco                             1.0021063  0.075192807\n",
       "Alagoas                                0.9976769  0.017174762\n",
       "Sergipe                                1.0124344  0.022347080\n",
       "Bahia                                  1.0079562  0.014281971\n",
       "⋮                                      ⋮          ⋮          \n",
       "Sudeste5                               0.17764477 0.1695076  \n",
       "Sul5                                   0.17689494 0.1945584  \n",
       "Centro-Oeste5                          0.18256058 0.1876377  \n",
       "Fundamental incompleto ou equivalente5 0.22126528 0.1594285  \n",
       "Médio incompleto ou equivalente5       0.21592099 0.1573074  \n",
       "Superior incompleto ou equivalente5    0.15561619 0.1105747  \n",
       "Superior completo5                     0.15373428 0.1940852  \n",
       "Branca6                                0.11330186 0.1858081  \n",
       "Preta6                                 0.13980835 0.2862966  \n",
       "Parda6                                 0.12588806 0.1339858  \n",
       "Até 1/2 SM6                            0.12271699 0.1393238  \n",
       "1/2 até 1 SM6                          0.11308354 0.2054551  \n",
       "1 até 2 SM6                            0.12701584 0.2898777  \n",
       "2 até 3 SM6                            0.24717754 0.4474851  \n",
       "Mais de 3 SM6                          0.19256679 0.3771980  \n",
       "18 a 24 anos6                          0.09092562 0.1814496  \n",
       "25 a 29 anos6                          0.12748778 0.2120253  \n",
       "30 a 39 anos6                          0.14634634 0.1547500  \n",
       "40 anos ou mais6                       0.12819518 0.3032673  \n",
       "urbano6                                0.11168607 0.1143736  \n",
       "rural6                                 0.13199517 0.1993144  \n",
       "Norte6                                 0.12110419 0.1960526  \n",
       "Nordeste6                              0.11293669 0.1449730  \n",
       "Sudeste6                               0.13152923 0.2114682  \n",
       "Sul6                                   0.15885661 0.2152070  \n",
       "Centro-Oeste6                          0.10843408 0.2268104  \n",
       "Fundamental incompleto ou equivalente6 0.17623088 0.2063042  \n",
       "Médio incompleto ou equivalente6       0.16001871 0.2007195  \n",
       "Superior incompleto ou equivalente6    0.08524259 0.1731864  \n",
       "Superior completo6                     0.14614167 0.2317340  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "matriz_indicadores"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Preenchendo a tabela com as abrangencia Brasil e total das capitais"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "matriz_totais <- popula_indicadores(design_por_abrangencia, totais, indicadores, Ano, \"total\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table class=\"dataframe\">\n",
       "<caption>A data.frame: 14 × 8</caption>\n",
       "<thead>\n",
       "\t<tr><th></th><th scope=col>abr_tipo</th><th scope=col>abr_nome</th><th scope=col>Ano</th><th scope=col>Indicador</th><th scope=col>Sim</th><th scope=col>LowerS</th><th scope=col>UpperS</th><th scope=col>cvS</th></tr>\n",
       "\t<tr><th></th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "\t<tr><th scope=row>S020PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S020P</td><td>0.94288075</td><td>0.92716331</td><td>0.9585982</td><td>0.008505053</td></tr>\n",
       "\t<tr><th scope=row>S020PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S020P</td><td>0.93159431</td><td>0.91045976</td><td>0.9527289</td><td>0.011574921</td></tr>\n",
       "\t<tr><th scope=row>S021PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S021P</td><td>0.72256554</td><td>0.69506341</td><td>0.7500677</td><td>0.019419631</td></tr>\n",
       "\t<tr><th scope=row>S021PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S021P</td><td>0.75117212</td><td>0.70981244</td><td>0.7925318</td><td>0.028092449</td></tr>\n",
       "\t<tr><th scope=row>S022PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S022P</td><td>0.75411181</td><td>0.72742385</td><td>0.7807998</td><td>0.018056418</td></tr>\n",
       "\t<tr><th scope=row>S022PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S022P</td><td>0.78080922</td><td>0.74082019</td><td>0.8207982</td><td>0.026130502</td></tr>\n",
       "\t<tr><th scope=row>S023PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S023P</td><td>0.44394229</td><td>0.41276521</td><td>0.4751194</td><td>0.035831150</td></tr>\n",
       "\t<tr><th scope=row>S023PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S023P</td><td>0.44329869</td><td>0.39325467</td><td>0.4933427</td><td>0.057598032</td></tr>\n",
       "\t<tr><th scope=row>S024PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S024P</td><td>0.85014508</td><td>0.82818447</td><td>0.8721057</td><td>0.013179631</td></tr>\n",
       "\t<tr><th scope=row>S024PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S024P</td><td>0.89007310</td><td>0.85453745</td><td>0.9256088</td><td>0.020369976</td></tr>\n",
       "\t<tr><th scope=row>S025PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S025P</td><td>0.13926777</td><td>0.11858300</td><td>0.1599525</td><td>0.075779522</td></tr>\n",
       "\t<tr><th scope=row>S025PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S025P</td><td>0.16857959</td><td>0.13172529</td><td>0.2054339</td><td>0.111541139</td></tr>\n",
       "\t<tr><th scope=row>S026PSim</th><td>total</td><td>Brasil </td><td>2019</td><td>S026P</td><td>0.09180329</td><td>0.07358851</td><td>0.1100181</td><td>0.101231969</td></tr>\n",
       "\t<tr><th scope=row>S026PSim1</th><td>total</td><td>Capital</td><td>2019</td><td>S026P</td><td>0.08467879</td><td>0.06019173</td><td>0.1091658</td><td>0.147541381</td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "A data.frame: 14 × 8\n",
       "\\begin{tabular}{r|llllllll}\n",
       "  & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n",
       "  & <chr> & <chr> & <chr> & <chr> & <dbl> & <dbl> & <dbl> & <dbl>\\\\\n",
       "\\hline\n",
       "\tS020PSim & total & Brasil  & 2019 & S020P & 0.94288075 & 0.92716331 & 0.9585982 & 0.008505053\\\\\n",
       "\tS020PSim1 & total & Capital & 2019 & S020P & 0.93159431 & 0.91045976 & 0.9527289 & 0.011574921\\\\\n",
       "\tS021PSim & total & Brasil  & 2019 & S021P & 0.72256554 & 0.69506341 & 0.7500677 & 0.019419631\\\\\n",
       "\tS021PSim1 & total & Capital & 2019 & S021P & 0.75117212 & 0.70981244 & 0.7925318 & 0.028092449\\\\\n",
       "\tS022PSim & total & Brasil  & 2019 & S022P & 0.75411181 & 0.72742385 & 0.7807998 & 0.018056418\\\\\n",
       "\tS022PSim1 & total & Capital & 2019 & S022P & 0.78080922 & 0.74082019 & 0.8207982 & 0.026130502\\\\\n",
       "\tS023PSim & total & Brasil  & 2019 & S023P & 0.44394229 & 0.41276521 & 0.4751194 & 0.035831150\\\\\n",
       "\tS023PSim1 & total & Capital & 2019 & S023P & 0.44329869 & 0.39325467 & 0.4933427 & 0.057598032\\\\\n",
       "\tS024PSim & total & Brasil  & 2019 & S024P & 0.85014508 & 0.82818447 & 0.8721057 & 0.013179631\\\\\n",
       "\tS024PSim1 & total & Capital & 2019 & S024P & 0.89007310 & 0.85453745 & 0.9256088 & 0.020369976\\\\\n",
       "\tS025PSim & total & Brasil  & 2019 & S025P & 0.13926777 & 0.11858300 & 0.1599525 & 0.075779522\\\\\n",
       "\tS025PSim1 & total & Capital & 2019 & S025P & 0.16857959 & 0.13172529 & 0.2054339 & 0.111541139\\\\\n",
       "\tS026PSim & total & Brasil  & 2019 & S026P & 0.09180329 & 0.07358851 & 0.1100181 & 0.101231969\\\\\n",
       "\tS026PSim1 & total & Capital & 2019 & S026P & 0.08467879 & 0.06019173 & 0.1091658 & 0.147541381\\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "A data.frame: 14 × 8\n",
       "\n",
       "| <!--/--> | abr_tipo &lt;chr&gt; | abr_nome &lt;chr&gt; | Ano &lt;chr&gt; | Indicador &lt;chr&gt; | Sim &lt;dbl&gt; | LowerS &lt;dbl&gt; | UpperS &lt;dbl&gt; | cvS &lt;dbl&gt; |\n",
       "|---|---|---|---|---|---|---|---|---|\n",
       "| S020PSim | total | Brasil  | 2019 | S020P | 0.94288075 | 0.92716331 | 0.9585982 | 0.008505053 |\n",
       "| S020PSim1 | total | Capital | 2019 | S020P | 0.93159431 | 0.91045976 | 0.9527289 | 0.011574921 |\n",
       "| S021PSim | total | Brasil  | 2019 | S021P | 0.72256554 | 0.69506341 | 0.7500677 | 0.019419631 |\n",
       "| S021PSim1 | total | Capital | 2019 | S021P | 0.75117212 | 0.70981244 | 0.7925318 | 0.028092449 |\n",
       "| S022PSim | total | Brasil  | 2019 | S022P | 0.75411181 | 0.72742385 | 0.7807998 | 0.018056418 |\n",
       "| S022PSim1 | total | Capital | 2019 | S022P | 0.78080922 | 0.74082019 | 0.8207982 | 0.026130502 |\n",
       "| S023PSim | total | Brasil  | 2019 | S023P | 0.44394229 | 0.41276521 | 0.4751194 | 0.035831150 |\n",
       "| S023PSim1 | total | Capital | 2019 | S023P | 0.44329869 | 0.39325467 | 0.4933427 | 0.057598032 |\n",
       "| S024PSim | total | Brasil  | 2019 | S024P | 0.85014508 | 0.82818447 | 0.8721057 | 0.013179631 |\n",
       "| S024PSim1 | total | Capital | 2019 | S024P | 0.89007310 | 0.85453745 | 0.9256088 | 0.020369976 |\n",
       "| S025PSim | total | Brasil  | 2019 | S025P | 0.13926777 | 0.11858300 | 0.1599525 | 0.075779522 |\n",
       "| S025PSim1 | total | Capital | 2019 | S025P | 0.16857959 | 0.13172529 | 0.2054339 | 0.111541139 |\n",
       "| S026PSim | total | Brasil  | 2019 | S026P | 0.09180329 | 0.07358851 | 0.1100181 | 0.101231969 |\n",
       "| S026PSim1 | total | Capital | 2019 | S026P | 0.08467879 | 0.06019173 | 0.1091658 | 0.147541381 |\n",
       "\n"
      ],
      "text/plain": [
       "          abr_tipo abr_nome Ano  Indicador Sim        LowerS     UpperS   \n",
       "S020PSim  total    Brasil   2019 S020P     0.94288075 0.92716331 0.9585982\n",
       "S020PSim1 total    Capital  2019 S020P     0.93159431 0.91045976 0.9527289\n",
       "S021PSim  total    Brasil   2019 S021P     0.72256554 0.69506341 0.7500677\n",
       "S021PSim1 total    Capital  2019 S021P     0.75117212 0.70981244 0.7925318\n",
       "S022PSim  total    Brasil   2019 S022P     0.75411181 0.72742385 0.7807998\n",
       "S022PSim1 total    Capital  2019 S022P     0.78080922 0.74082019 0.8207982\n",
       "S023PSim  total    Brasil   2019 S023P     0.44394229 0.41276521 0.4751194\n",
       "S023PSim1 total    Capital  2019 S023P     0.44329869 0.39325467 0.4933427\n",
       "S024PSim  total    Brasil   2019 S024P     0.85014508 0.82818447 0.8721057\n",
       "S024PSim1 total    Capital  2019 S024P     0.89007310 0.85453745 0.9256088\n",
       "S025PSim  total    Brasil   2019 S025P     0.13926777 0.11858300 0.1599525\n",
       "S025PSim1 total    Capital  2019 S025P     0.16857959 0.13172529 0.2054339\n",
       "S026PSim  total    Brasil   2019 S026P     0.09180329 0.07358851 0.1100181\n",
       "S026PSim1 total    Capital  2019 S026P     0.08467879 0.06019173 0.1091658\n",
       "          cvS        \n",
       "S020PSim  0.008505053\n",
       "S020PSim1 0.011574921\n",
       "S021PSim  0.019419631\n",
       "S021PSim1 0.028092449\n",
       "S022PSim  0.018056418\n",
       "S022PSim1 0.026130502\n",
       "S023PSim  0.035831150\n",
       "S023PSim1 0.057598032\n",
       "S024PSim  0.013179631\n",
       "S024PSim1 0.020369976\n",
       "S025PSim  0.075779522\n",
       "S025PSim1 0.111541139\n",
       "S026PSim  0.101231969\n",
       "S026PSim1 0.147541381"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "matriz_totais"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Unindo tabela de indicadores e de totais"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "matriz_final <-rbind(matriz_indicadores,matriz_totais)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Visualizando tabela de indicadores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table class=\"dataframe\">\n",
       "<caption>A data.frame: 418 × 8</caption>\n",
       "<thead>\n",
       "\t<tr><th></th><th scope=col>abr_tipo</th><th scope=col>abr_nome</th><th scope=col>Ano</th><th scope=col>Indicador</th><th scope=col>Sim</th><th scope=col>LowerS</th><th scope=col>UpperS</th><th scope=col>cvS</th></tr>\n",
       "\t<tr><th></th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;fct&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "\t<tr><th scope=row>Branca</th><td>raça           </td><td>Branca             </td><td>2019</td><td>S020P</td><td>0.9462652</td><td>0.9150585</td><td>0.9774720</td><td>0.016826270</td></tr>\n",
       "\t<tr><th scope=row>Preta</th><td>raça           </td><td>Preta              </td><td>2019</td><td>S020P</td><td>0.9491546</td><td>0.9190134</td><td>0.9792958</td><td>0.016202236</td></tr>\n",
       "\t<tr><th scope=row>Parda</th><td>raça           </td><td>Parda              </td><td>2019</td><td>S020P</td><td>0.9406377</td><td>0.9204789</td><td>0.9607964</td><td>0.010934363</td></tr>\n",
       "\t<tr><th scope=row>Até 1/2 SM</th><td>rend_per_capita</td><td>Até 1/2 SM         </td><td>2019</td><td>S020P</td><td>0.9296724</td><td>0.9109426</td><td>0.9484022</td><td>0.010279112</td></tr>\n",
       "\t<tr><th scope=row>1/2 até 1 SM</th><td>rend_per_capita</td><td>1/2 até 1 SM       </td><td>2019</td><td>S020P</td><td>0.9413991</td><td>0.9069147</td><td>0.9758836</td><td>0.018689675</td></tr>\n",
       "\t<tr><th scope=row>1 até 2 SM</th><td>rend_per_capita</td><td>1 até 2 SM         </td><td>2019</td><td>S020P</td><td>0.9616164</td><td>0.9246481</td><td>0.9985846</td><td>0.019614569</td></tr>\n",
       "\t<tr><th scope=row>2 até 3 SM</th><td>rend_per_capita</td><td>2 até 3 SM         </td><td>2019</td><td>S020P</td><td>0.9887464</td><td>0.9716482</td><td>1.0058446</td><td>0.008823016</td></tr>\n",
       "\t<tr><th scope=row>Mais de 3 SM</th><td>rend_per_capita</td><td>Mais de 3 SM       </td><td>2019</td><td>S020P</td><td>0.9642104</td><td>0.9161889</td><td>1.0122318</td><td>0.025410618</td></tr>\n",
       "\t<tr><th scope=row>18 a 24 anos</th><td>fx_idade_s     </td><td>18 a 24 anos       </td><td>2019</td><td>S020P</td><td>0.9495413</td><td>0.9244755</td><td>0.9746072</td><td>0.013468538</td></tr>\n",
       "\t<tr><th scope=row>25 a 29 anos</th><td>fx_idade_s     </td><td>25 a 29 anos       </td><td>2019</td><td>S020P</td><td>0.9529889</td><td>0.9344372</td><td>0.9715406</td><td>0.009932271</td></tr>\n",
       "\t<tr><th scope=row>30 a 39 anos</th><td>fx_idade_s     </td><td>30 a 39 anos       </td><td>2019</td><td>S020P</td><td>0.9332568</td><td>0.9026042</td><td>0.9639095</td><td>0.016757868</td></tr>\n",
       "\t<tr><th scope=row>40 anos ou mais</th><td>fx_idade_s     </td><td>40 anos ou mais    </td><td>2019</td><td>S020P</td><td>0.9370615</td><td>0.8874357</td><td>0.9866874</td><td>0.027020387</td></tr>\n",
       "\t<tr><th scope=row>urbano</th><td>urb_rur        </td><td>urbano             </td><td>2019</td><td>S020P</td><td>0.9462480</td><td>0.9285206</td><td>0.9639755</td><td>0.009558592</td></tr>\n",
       "\t<tr><th scope=row>rural</th><td>urb_rur        </td><td>rural              </td><td>2019</td><td>S020P</td><td>0.9244595</td><td>0.8935373</td><td>0.9553818</td><td>0.017066135</td></tr>\n",
       "\t<tr><th scope=row>Rondônia</th><td>uf             </td><td>Rondônia           </td><td>2019</td><td>S020P</td><td>0.8862161</td><td>0.8171283</td><td>0.9553040</td><td>0.039775344</td></tr>\n",
       "\t<tr><th scope=row>Acre</th><td>uf             </td><td>Acre               </td><td>2019</td><td>S020P</td><td>0.9384015</td><td>0.8740413</td><td>1.0027618</td><td>0.034992968</td></tr>\n",
       "\t<tr><th scope=row>Amazonas</th><td>uf             </td><td>Amazonas           </td><td>2019</td><td>S020P</td><td>0.8776843</td><td>0.8087780</td><td>0.9465905</td><td>0.040056436</td></tr>\n",
       "\t<tr><th scope=row>Roraima</th><td>uf             </td><td>Roraima            </td><td>2019</td><td>S020P</td><td>0.9469861</td><td>0.9000798</td><td>0.9938923</td><td>0.025271953</td></tr>\n",
       "\t<tr><th scope=row>Pará</th><td>uf             </td><td>Pará               </td><td>2019</td><td>S020P</td><td>0.9306247</td><td>0.8747821</td><td>0.9864672</td><td>0.030615586</td></tr>\n",
       "\t<tr><th scope=row>Amapá</th><td>uf             </td><td>Amapá              </td><td>2019</td><td>S020P</td><td>0.9275277</td><td>0.8519172</td><td>1.0031382</td><td>0.041591750</td></tr>\n",
       "\t<tr><th scope=row>Tocantins</th><td>uf             </td><td>Tocantins          </td><td>2019</td><td>S020P</td><td>0.9361957</td><td>0.8448937</td><td>1.0274977</td><td>0.049758309</td></tr>\n",
       "\t<tr><th scope=row>Maranhão</th><td>uf             </td><td>Maranhão           </td><td>2019</td><td>S020P</td><td>0.9482602</td><td>0.9167190</td><td>0.9798014</td><td>0.016970815</td></tr>\n",
       "\t<tr><th scope=row>Piauí</th><td>uf             </td><td>Piauí              </td><td>2019</td><td>S020P</td><td>0.9468641</td><td>0.9035875</td><td>0.9901407</td><td>0.023319385</td></tr>\n",
       "\t<tr><th scope=row>Ceará</th><td>uf             </td><td>Ceará              </td><td>2019</td><td>S020P</td><td>0.9822641</td><td>0.9478668</td><td>1.0166614</td><td>0.017866842</td></tr>\n",
       "\t<tr><th scope=row>Rio Grande do Norte</th><td>uf             </td><td>Rio Grande do Norte</td><td>2019</td><td>S020P</td><td>0.9232503</td><td>0.8679509</td><td>0.9785498</td><td>0.030559988</td></tr>\n",
       "\t<tr><th scope=row>Paraíba</th><td>uf             </td><td>Paraíba            </td><td>2019</td><td>S020P</td><td>0.9439027</td><td>0.8976978</td><td>0.9901076</td><td>0.024975396</td></tr>\n",
       "\t<tr><th scope=row>Pernambuco</th><td>uf             </td><td>Pernambuco         </td><td>2019</td><td>S020P</td><td>0.8733903</td><td>0.7446742</td><td>1.0021063</td><td>0.075192807</td></tr>\n",
       "\t<tr><th scope=row>Alagoas</th><td>uf             </td><td>Alagoas            </td><td>2019</td><td>S020P</td><td>0.9651868</td><td>0.9326968</td><td>0.9976769</td><td>0.017174762</td></tr>\n",
       "\t<tr><th scope=row>Sergipe</th><td>uf             </td><td>Sergipe            </td><td>2019</td><td>S020P</td><td>0.9699511</td><td>0.9274677</td><td>1.0124344</td><td>0.022347080</td></tr>\n",
       "\t<tr><th scope=row>Bahia</th><td>uf             </td><td>Bahia              </td><td>2019</td><td>S020P</td><td>0.9805097</td><td>0.9530631</td><td>1.0079562</td><td>0.014281971</td></tr>\n",
       "\t<tr><th scope=row>⋮</th><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td><td>⋮</td></tr>\n",
       "\t<tr><th scope=row>Mais de 3 SM6</th><td>rend_per_capita</td><td>Mais de 3 SM                         </td><td>2019</td><td>S026P</td><td>0.11071546</td><td>0.02886413</td><td>0.19256679</td><td>0.377198018</td></tr>\n",
       "\t<tr><th scope=row>18 a 24 anos6</th><td>fx_idade_s     </td><td>18 a 24 anos                         </td><td>2019</td><td>S026P</td><td>0.06707236</td><td>0.04321910</td><td>0.09092562</td><td>0.181449635</td></tr>\n",
       "\t<tr><th scope=row>25 a 29 anos6</th><td>fx_idade_s     </td><td>25 a 29 anos                         </td><td>2019</td><td>S026P</td><td>0.09006160</td><td>0.05263542</td><td>0.12748778</td><td>0.212025320</td></tr>\n",
       "\t<tr><th scope=row>30 a 39 anos6</th><td>fx_idade_s     </td><td>30 a 39 anos                         </td><td>2019</td><td>S026P</td><td>0.11228868</td><td>0.07823102</td><td>0.14634634</td><td>0.154750013</td></tr>\n",
       "\t<tr><th scope=row>40 anos ou mais6</th><td>fx_idade_s     </td><td>40 anos ou mais                      </td><td>2019</td><td>S026P</td><td>0.08040375</td><td>0.03261232</td><td>0.12819518</td><td>0.303267312</td></tr>\n",
       "\t<tr><th scope=row>urbano6</th><td>urb_rur        </td><td>urbano                               </td><td>2019</td><td>S026P</td><td>0.09123426</td><td>0.07078246</td><td>0.11168607</td><td>0.114373564</td></tr>\n",
       "\t<tr><th scope=row>rural6</th><td>urb_rur        </td><td>rural                                </td><td>2019</td><td>S026P</td><td>0.09491624</td><td>0.05783730</td><td>0.13199517</td><td>0.199314376</td></tr>\n",
       "\t<tr><th scope=row>Norte6</th><td>região         </td><td>Norte                                </td><td>2019</td><td>S026P</td><td>0.08748685</td><td>0.05386950</td><td>0.12110419</td><td>0.196052563</td></tr>\n",
       "\t<tr><th scope=row>Nordeste6</th><td>região         </td><td>Nordeste                             </td><td>2019</td><td>S026P</td><td>0.08794721</td><td>0.06295773</td><td>0.11293669</td><td>0.144972960</td></tr>\n",
       "\t<tr><th scope=row>Sudeste6</th><td>região         </td><td>Sudeste                              </td><td>2019</td><td>S026P</td><td>0.09298834</td><td>0.05444746</td><td>0.13152923</td><td>0.211468215</td></tr>\n",
       "\t<tr><th scope=row>Sul6</th><td>região         </td><td>Sul                                  </td><td>2019</td><td>S026P</td><td>0.11172938</td><td>0.06460214</td><td>0.15885661</td><td>0.215207044</td></tr>\n",
       "\t<tr><th scope=row>Centro-Oeste6</th><td>região         </td><td>Centro-Oeste                         </td><td>2019</td><td>S026P</td><td>0.07506477</td><td>0.04169546</td><td>0.10843408</td><td>0.226810433</td></tr>\n",
       "\t<tr><th scope=row>Fundamental incompleto ou equivalente6</th><td>gescol         </td><td>Fundamental incompleto ou equivalente</td><td>2019</td><td>S026P</td><td>0.12548939</td><td>0.07474790</td><td>0.17623088</td><td>0.206304228</td></tr>\n",
       "\t<tr><th scope=row>Médio incompleto ou equivalente6</th><td>gescol         </td><td>Médio incompleto ou equivalente      </td><td>2019</td><td>S026P</td><td>0.11484022</td><td>0.06966174</td><td>0.16001871</td><td>0.200719497</td></tr>\n",
       "\t<tr><th scope=row>Superior incompleto ou equivalente6</th><td>gescol         </td><td>Superior incompleto ou equivalente   </td><td>2019</td><td>S026P</td><td>0.06364051</td><td>0.04203844</td><td>0.08524259</td><td>0.173186377</td></tr>\n",
       "\t<tr><th scope=row>Superior completo6</th><td>gescol         </td><td>Superior completo                    </td><td>2019</td><td>S026P</td><td>0.10049694</td><td>0.05485221</td><td>0.14614167</td><td>0.231733978</td></tr>\n",
       "\t<tr><th scope=row>S020PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S020P</td><td>0.94288075</td><td>0.92716331</td><td>0.95859820</td><td>0.008505053</td></tr>\n",
       "\t<tr><th scope=row>S020PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S020P</td><td>0.93159431</td><td>0.91045976</td><td>0.95272885</td><td>0.011574921</td></tr>\n",
       "\t<tr><th scope=row>S021PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S021P</td><td>0.72256554</td><td>0.69506341</td><td>0.75006767</td><td>0.019419631</td></tr>\n",
       "\t<tr><th scope=row>S021PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S021P</td><td>0.75117212</td><td>0.70981244</td><td>0.79253179</td><td>0.028092449</td></tr>\n",
       "\t<tr><th scope=row>S022PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S022P</td><td>0.75411181</td><td>0.72742385</td><td>0.78079977</td><td>0.018056418</td></tr>\n",
       "\t<tr><th scope=row>S022PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S022P</td><td>0.78080922</td><td>0.74082019</td><td>0.82079824</td><td>0.026130502</td></tr>\n",
       "\t<tr><th scope=row>S023PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S023P</td><td>0.44394229</td><td>0.41276521</td><td>0.47511936</td><td>0.035831150</td></tr>\n",
       "\t<tr><th scope=row>S023PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S023P</td><td>0.44329869</td><td>0.39325467</td><td>0.49334271</td><td>0.057598032</td></tr>\n",
       "\t<tr><th scope=row>S024PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S024P</td><td>0.85014508</td><td>0.82818447</td><td>0.87210569</td><td>0.013179631</td></tr>\n",
       "\t<tr><th scope=row>S024PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S024P</td><td>0.89007310</td><td>0.85453745</td><td>0.92560875</td><td>0.020369976</td></tr>\n",
       "\t<tr><th scope=row>S025PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S025P</td><td>0.13926777</td><td>0.11858300</td><td>0.15995253</td><td>0.075779522</td></tr>\n",
       "\t<tr><th scope=row>S025PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S025P</td><td>0.16857959</td><td>0.13172529</td><td>0.20543388</td><td>0.111541139</td></tr>\n",
       "\t<tr><th scope=row>S026PSim</th><td>total          </td><td>Brasil                               </td><td>2019</td><td>S026P</td><td>0.09180329</td><td>0.07358851</td><td>0.11001807</td><td>0.101231969</td></tr>\n",
       "\t<tr><th scope=row>S026PSim1</th><td>total          </td><td>Capital                              </td><td>2019</td><td>S026P</td><td>0.08467879</td><td>0.06019173</td><td>0.10916584</td><td>0.147541381</td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "A data.frame: 418 × 8\n",
       "\\begin{tabular}{r|llllllll}\n",
       "  & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n",
       "  & <chr> & <fct> & <chr> & <chr> & <dbl> & <dbl> & <dbl> & <dbl>\\\\\n",
       "\\hline\n",
       "\tBranca & raça            & Branca              & 2019 & S020P & 0.9462652 & 0.9150585 & 0.9774720 & 0.016826270\\\\\n",
       "\tPreta & raça            & Preta               & 2019 & S020P & 0.9491546 & 0.9190134 & 0.9792958 & 0.016202236\\\\\n",
       "\tParda & raça            & Parda               & 2019 & S020P & 0.9406377 & 0.9204789 & 0.9607964 & 0.010934363\\\\\n",
       "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM          & 2019 & S020P & 0.9296724 & 0.9109426 & 0.9484022 & 0.010279112\\\\\n",
       "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM        & 2019 & S020P & 0.9413991 & 0.9069147 & 0.9758836 & 0.018689675\\\\\n",
       "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM          & 2019 & S020P & 0.9616164 & 0.9246481 & 0.9985846 & 0.019614569\\\\\n",
       "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM          & 2019 & S020P & 0.9887464 & 0.9716482 & 1.0058446 & 0.008823016\\\\\n",
       "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM        & 2019 & S020P & 0.9642104 & 0.9161889 & 1.0122318 & 0.025410618\\\\\n",
       "\t18 a 24 anos & fx\\_idade\\_s      & 18 a 24 anos        & 2019 & S020P & 0.9495413 & 0.9244755 & 0.9746072 & 0.013468538\\\\\n",
       "\t25 a 29 anos & fx\\_idade\\_s      & 25 a 29 anos        & 2019 & S020P & 0.9529889 & 0.9344372 & 0.9715406 & 0.009932271\\\\\n",
       "\t30 a 39 anos & fx\\_idade\\_s      & 30 a 39 anos        & 2019 & S020P & 0.9332568 & 0.9026042 & 0.9639095 & 0.016757868\\\\\n",
       "\t40 anos ou mais & fx\\_idade\\_s      & 40 anos ou mais     & 2019 & S020P & 0.9370615 & 0.8874357 & 0.9866874 & 0.027020387\\\\\n",
       "\turbano & urb\\_rur         & urbano              & 2019 & S020P & 0.9462480 & 0.9285206 & 0.9639755 & 0.009558592\\\\\n",
       "\trural & urb\\_rur         & rural               & 2019 & S020P & 0.9244595 & 0.8935373 & 0.9553818 & 0.017066135\\\\\n",
       "\tRondônia & uf              & Rondônia            & 2019 & S020P & 0.8862161 & 0.8171283 & 0.9553040 & 0.039775344\\\\\n",
       "\tAcre & uf              & Acre                & 2019 & S020P & 0.9384015 & 0.8740413 & 1.0027618 & 0.034992968\\\\\n",
       "\tAmazonas & uf              & Amazonas            & 2019 & S020P & 0.8776843 & 0.8087780 & 0.9465905 & 0.040056436\\\\\n",
       "\tRoraima & uf              & Roraima             & 2019 & S020P & 0.9469861 & 0.9000798 & 0.9938923 & 0.025271953\\\\\n",
       "\tPará & uf              & Pará                & 2019 & S020P & 0.9306247 & 0.8747821 & 0.9864672 & 0.030615586\\\\\n",
       "\tAmapá & uf              & Amapá               & 2019 & S020P & 0.9275277 & 0.8519172 & 1.0031382 & 0.041591750\\\\\n",
       "\tTocantins & uf              & Tocantins           & 2019 & S020P & 0.9361957 & 0.8448937 & 1.0274977 & 0.049758309\\\\\n",
       "\tMaranhão & uf              & Maranhão            & 2019 & S020P & 0.9482602 & 0.9167190 & 0.9798014 & 0.016970815\\\\\n",
       "\tPiauí & uf              & Piauí               & 2019 & S020P & 0.9468641 & 0.9035875 & 0.9901407 & 0.023319385\\\\\n",
       "\tCeará & uf              & Ceará               & 2019 & S020P & 0.9822641 & 0.9478668 & 1.0166614 & 0.017866842\\\\\n",
       "\tRio Grande do Norte & uf              & Rio Grande do Norte & 2019 & S020P & 0.9232503 & 0.8679509 & 0.9785498 & 0.030559988\\\\\n",
       "\tParaíba & uf              & Paraíba             & 2019 & S020P & 0.9439027 & 0.8976978 & 0.9901076 & 0.024975396\\\\\n",
       "\tPernambuco & uf              & Pernambuco          & 2019 & S020P & 0.8733903 & 0.7446742 & 1.0021063 & 0.075192807\\\\\n",
       "\tAlagoas & uf              & Alagoas             & 2019 & S020P & 0.9651868 & 0.9326968 & 0.9976769 & 0.017174762\\\\\n",
       "\tSergipe & uf              & Sergipe             & 2019 & S020P & 0.9699511 & 0.9274677 & 1.0124344 & 0.022347080\\\\\n",
       "\tBahia & uf              & Bahia               & 2019 & S020P & 0.9805097 & 0.9530631 & 1.0079562 & 0.014281971\\\\\n",
       "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n",
       "\tMais de 3 SM6 & rend\\_per\\_capita & Mais de 3 SM                          & 2019 & S026P & 0.11071546 & 0.02886413 & 0.19256679 & 0.377198018\\\\\n",
       "\t18 a 24 anos6 & fx\\_idade\\_s      & 18 a 24 anos                          & 2019 & S026P & 0.06707236 & 0.04321910 & 0.09092562 & 0.181449635\\\\\n",
       "\t25 a 29 anos6 & fx\\_idade\\_s      & 25 a 29 anos                          & 2019 & S026P & 0.09006160 & 0.05263542 & 0.12748778 & 0.212025320\\\\\n",
       "\t30 a 39 anos6 & fx\\_idade\\_s      & 30 a 39 anos                          & 2019 & S026P & 0.11228868 & 0.07823102 & 0.14634634 & 0.154750013\\\\\n",
       "\t40 anos ou mais6 & fx\\_idade\\_s      & 40 anos ou mais                       & 2019 & S026P & 0.08040375 & 0.03261232 & 0.12819518 & 0.303267312\\\\\n",
       "\turbano6 & urb\\_rur         & urbano                                & 2019 & S026P & 0.09123426 & 0.07078246 & 0.11168607 & 0.114373564\\\\\n",
       "\trural6 & urb\\_rur         & rural                                 & 2019 & S026P & 0.09491624 & 0.05783730 & 0.13199517 & 0.199314376\\\\\n",
       "\tNorte6 & região          & Norte                                 & 2019 & S026P & 0.08748685 & 0.05386950 & 0.12110419 & 0.196052563\\\\\n",
       "\tNordeste6 & região          & Nordeste                              & 2019 & S026P & 0.08794721 & 0.06295773 & 0.11293669 & 0.144972960\\\\\n",
       "\tSudeste6 & região          & Sudeste                               & 2019 & S026P & 0.09298834 & 0.05444746 & 0.13152923 & 0.211468215\\\\\n",
       "\tSul6 & região          & Sul                                   & 2019 & S026P & 0.11172938 & 0.06460214 & 0.15885661 & 0.215207044\\\\\n",
       "\tCentro-Oeste6 & região          & Centro-Oeste                          & 2019 & S026P & 0.07506477 & 0.04169546 & 0.10843408 & 0.226810433\\\\\n",
       "\tFundamental incompleto ou equivalente6 & gescol          & Fundamental incompleto ou equivalente & 2019 & S026P & 0.12548939 & 0.07474790 & 0.17623088 & 0.206304228\\\\\n",
       "\tMédio incompleto ou equivalente6 & gescol          & Médio incompleto ou equivalente       & 2019 & S026P & 0.11484022 & 0.06966174 & 0.16001871 & 0.200719497\\\\\n",
       "\tSuperior incompleto ou equivalente6 & gescol          & Superior incompleto ou equivalente    & 2019 & S026P & 0.06364051 & 0.04203844 & 0.08524259 & 0.173186377\\\\\n",
       "\tSuperior completo6 & gescol          & Superior completo                     & 2019 & S026P & 0.10049694 & 0.05485221 & 0.14614167 & 0.231733978\\\\\n",
       "\tS020PSim & total           & Brasil                                & 2019 & S020P & 0.94288075 & 0.92716331 & 0.95859820 & 0.008505053\\\\\n",
       "\tS020PSim1 & total           & Capital                               & 2019 & S020P & 0.93159431 & 0.91045976 & 0.95272885 & 0.011574921\\\\\n",
       "\tS021PSim & total           & Brasil                                & 2019 & S021P & 0.72256554 & 0.69506341 & 0.75006767 & 0.019419631\\\\\n",
       "\tS021PSim1 & total           & Capital                               & 2019 & S021P & 0.75117212 & 0.70981244 & 0.79253179 & 0.028092449\\\\\n",
       "\tS022PSim & total           & Brasil                                & 2019 & S022P & 0.75411181 & 0.72742385 & 0.78079977 & 0.018056418\\\\\n",
       "\tS022PSim1 & total           & Capital                               & 2019 & S022P & 0.78080922 & 0.74082019 & 0.82079824 & 0.026130502\\\\\n",
       "\tS023PSim & total           & Brasil                                & 2019 & S023P & 0.44394229 & 0.41276521 & 0.47511936 & 0.035831150\\\\\n",
       "\tS023PSim1 & total           & Capital                               & 2019 & S023P & 0.44329869 & 0.39325467 & 0.49334271 & 0.057598032\\\\\n",
       "\tS024PSim & total           & Brasil                                & 2019 & S024P & 0.85014508 & 0.82818447 & 0.87210569 & 0.013179631\\\\\n",
       "\tS024PSim1 & total           & Capital                               & 2019 & S024P & 0.89007310 & 0.85453745 & 0.92560875 & 0.020369976\\\\\n",
       "\tS025PSim & total           & Brasil                                & 2019 & S025P & 0.13926777 & 0.11858300 & 0.15995253 & 0.075779522\\\\\n",
       "\tS025PSim1 & total           & Capital                               & 2019 & S025P & 0.16857959 & 0.13172529 & 0.20543388 & 0.111541139\\\\\n",
       "\tS026PSim & total           & Brasil                                & 2019 & S026P & 0.09180329 & 0.07358851 & 0.11001807 & 0.101231969\\\\\n",
       "\tS026PSim1 & total           & Capital                               & 2019 & S026P & 0.08467879 & 0.06019173 & 0.10916584 & 0.147541381\\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "A data.frame: 418 × 8\n",
       "\n",
       "| <!--/--> | abr_tipo &lt;chr&gt; | abr_nome &lt;fct&gt; | Ano &lt;chr&gt; | Indicador &lt;chr&gt; | Sim &lt;dbl&gt; | LowerS &lt;dbl&gt; | UpperS &lt;dbl&gt; | cvS &lt;dbl&gt; |\n",
       "|---|---|---|---|---|---|---|---|---|\n",
       "| Branca | raça            | Branca              | 2019 | S020P | 0.9462652 | 0.9150585 | 0.9774720 | 0.016826270 |\n",
       "| Preta | raça            | Preta               | 2019 | S020P | 0.9491546 | 0.9190134 | 0.9792958 | 0.016202236 |\n",
       "| Parda | raça            | Parda               | 2019 | S020P | 0.9406377 | 0.9204789 | 0.9607964 | 0.010934363 |\n",
       "| Até 1/2 SM | rend_per_capita | Até 1/2 SM          | 2019 | S020P | 0.9296724 | 0.9109426 | 0.9484022 | 0.010279112 |\n",
       "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM        | 2019 | S020P | 0.9413991 | 0.9069147 | 0.9758836 | 0.018689675 |\n",
       "| 1 até 2 SM | rend_per_capita | 1 até 2 SM          | 2019 | S020P | 0.9616164 | 0.9246481 | 0.9985846 | 0.019614569 |\n",
       "| 2 até 3 SM | rend_per_capita | 2 até 3 SM          | 2019 | S020P | 0.9887464 | 0.9716482 | 1.0058446 | 0.008823016 |\n",
       "| Mais de 3 SM | rend_per_capita | Mais de 3 SM        | 2019 | S020P | 0.9642104 | 0.9161889 | 1.0122318 | 0.025410618 |\n",
       "| 18 a 24 anos | fx_idade_s      | 18 a 24 anos        | 2019 | S020P | 0.9495413 | 0.9244755 | 0.9746072 | 0.013468538 |\n",
       "| 25 a 29 anos | fx_idade_s      | 25 a 29 anos        | 2019 | S020P | 0.9529889 | 0.9344372 | 0.9715406 | 0.009932271 |\n",
       "| 30 a 39 anos | fx_idade_s      | 30 a 39 anos        | 2019 | S020P | 0.9332568 | 0.9026042 | 0.9639095 | 0.016757868 |\n",
       "| 40 anos ou mais | fx_idade_s      | 40 anos ou mais     | 2019 | S020P | 0.9370615 | 0.8874357 | 0.9866874 | 0.027020387 |\n",
       "| urbano | urb_rur         | urbano              | 2019 | S020P | 0.9462480 | 0.9285206 | 0.9639755 | 0.009558592 |\n",
       "| rural | urb_rur         | rural               | 2019 | S020P | 0.9244595 | 0.8935373 | 0.9553818 | 0.017066135 |\n",
       "| Rondônia | uf              | Rondônia            | 2019 | S020P | 0.8862161 | 0.8171283 | 0.9553040 | 0.039775344 |\n",
       "| Acre | uf              | Acre                | 2019 | S020P | 0.9384015 | 0.8740413 | 1.0027618 | 0.034992968 |\n",
       "| Amazonas | uf              | Amazonas            | 2019 | S020P | 0.8776843 | 0.8087780 | 0.9465905 | 0.040056436 |\n",
       "| Roraima | uf              | Roraima             | 2019 | S020P | 0.9469861 | 0.9000798 | 0.9938923 | 0.025271953 |\n",
       "| Pará | uf              | Pará                | 2019 | S020P | 0.9306247 | 0.8747821 | 0.9864672 | 0.030615586 |\n",
       "| Amapá | uf              | Amapá               | 2019 | S020P | 0.9275277 | 0.8519172 | 1.0031382 | 0.041591750 |\n",
       "| Tocantins | uf              | Tocantins           | 2019 | S020P | 0.9361957 | 0.8448937 | 1.0274977 | 0.049758309 |\n",
       "| Maranhão | uf              | Maranhão            | 2019 | S020P | 0.9482602 | 0.9167190 | 0.9798014 | 0.016970815 |\n",
       "| Piauí | uf              | Piauí               | 2019 | S020P | 0.9468641 | 0.9035875 | 0.9901407 | 0.023319385 |\n",
       "| Ceará | uf              | Ceará               | 2019 | S020P | 0.9822641 | 0.9478668 | 1.0166614 | 0.017866842 |\n",
       "| Rio Grande do Norte | uf              | Rio Grande do Norte | 2019 | S020P | 0.9232503 | 0.8679509 | 0.9785498 | 0.030559988 |\n",
       "| Paraíba | uf              | Paraíba             | 2019 | S020P | 0.9439027 | 0.8976978 | 0.9901076 | 0.024975396 |\n",
       "| Pernambuco | uf              | Pernambuco          | 2019 | S020P | 0.8733903 | 0.7446742 | 1.0021063 | 0.075192807 |\n",
       "| Alagoas | uf              | Alagoas             | 2019 | S020P | 0.9651868 | 0.9326968 | 0.9976769 | 0.017174762 |\n",
       "| Sergipe | uf              | Sergipe             | 2019 | S020P | 0.9699511 | 0.9274677 | 1.0124344 | 0.022347080 |\n",
       "| Bahia | uf              | Bahia               | 2019 | S020P | 0.9805097 | 0.9530631 | 1.0079562 | 0.014281971 |\n",
       "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n",
       "| Mais de 3 SM6 | rend_per_capita | Mais de 3 SM                          | 2019 | S026P | 0.11071546 | 0.02886413 | 0.19256679 | 0.377198018 |\n",
       "| 18 a 24 anos6 | fx_idade_s      | 18 a 24 anos                          | 2019 | S026P | 0.06707236 | 0.04321910 | 0.09092562 | 0.181449635 |\n",
       "| 25 a 29 anos6 | fx_idade_s      | 25 a 29 anos                          | 2019 | S026P | 0.09006160 | 0.05263542 | 0.12748778 | 0.212025320 |\n",
       "| 30 a 39 anos6 | fx_idade_s      | 30 a 39 anos                          | 2019 | S026P | 0.11228868 | 0.07823102 | 0.14634634 | 0.154750013 |\n",
       "| 40 anos ou mais6 | fx_idade_s      | 40 anos ou mais                       | 2019 | S026P | 0.08040375 | 0.03261232 | 0.12819518 | 0.303267312 |\n",
       "| urbano6 | urb_rur         | urbano                                | 2019 | S026P | 0.09123426 | 0.07078246 | 0.11168607 | 0.114373564 |\n",
       "| rural6 | urb_rur         | rural                                 | 2019 | S026P | 0.09491624 | 0.05783730 | 0.13199517 | 0.199314376 |\n",
       "| Norte6 | região          | Norte                                 | 2019 | S026P | 0.08748685 | 0.05386950 | 0.12110419 | 0.196052563 |\n",
       "| Nordeste6 | região          | Nordeste                              | 2019 | S026P | 0.08794721 | 0.06295773 | 0.11293669 | 0.144972960 |\n",
       "| Sudeste6 | região          | Sudeste                               | 2019 | S026P | 0.09298834 | 0.05444746 | 0.13152923 | 0.211468215 |\n",
       "| Sul6 | região          | Sul                                   | 2019 | S026P | 0.11172938 | 0.06460214 | 0.15885661 | 0.215207044 |\n",
       "| Centro-Oeste6 | região          | Centro-Oeste                          | 2019 | S026P | 0.07506477 | 0.04169546 | 0.10843408 | 0.226810433 |\n",
       "| Fundamental incompleto ou equivalente6 | gescol          | Fundamental incompleto ou equivalente | 2019 | S026P | 0.12548939 | 0.07474790 | 0.17623088 | 0.206304228 |\n",
       "| Médio incompleto ou equivalente6 | gescol          | Médio incompleto ou equivalente       | 2019 | S026P | 0.11484022 | 0.06966174 | 0.16001871 | 0.200719497 |\n",
       "| Superior incompleto ou equivalente6 | gescol          | Superior incompleto ou equivalente    | 2019 | S026P | 0.06364051 | 0.04203844 | 0.08524259 | 0.173186377 |\n",
       "| Superior completo6 | gescol          | Superior completo                     | 2019 | S026P | 0.10049694 | 0.05485221 | 0.14614167 | 0.231733978 |\n",
       "| S020PSim | total           | Brasil                                | 2019 | S020P | 0.94288075 | 0.92716331 | 0.95859820 | 0.008505053 |\n",
       "| S020PSim1 | total           | Capital                               | 2019 | S020P | 0.93159431 | 0.91045976 | 0.95272885 | 0.011574921 |\n",
       "| S021PSim | total           | Brasil                                | 2019 | S021P | 0.72256554 | 0.69506341 | 0.75006767 | 0.019419631 |\n",
       "| S021PSim1 | total           | Capital                               | 2019 | S021P | 0.75117212 | 0.70981244 | 0.79253179 | 0.028092449 |\n",
       "| S022PSim | total           | Brasil                                | 2019 | S022P | 0.75411181 | 0.72742385 | 0.78079977 | 0.018056418 |\n",
       "| S022PSim1 | total           | Capital                               | 2019 | S022P | 0.78080922 | 0.74082019 | 0.82079824 | 0.026130502 |\n",
       "| S023PSim | total           | Brasil                                | 2019 | S023P | 0.44394229 | 0.41276521 | 0.47511936 | 0.035831150 |\n",
       "| S023PSim1 | total           | Capital                               | 2019 | S023P | 0.44329869 | 0.39325467 | 0.49334271 | 0.057598032 |\n",
       "| S024PSim | total           | Brasil                                | 2019 | S024P | 0.85014508 | 0.82818447 | 0.87210569 | 0.013179631 |\n",
       "| S024PSim1 | total           | Capital                               | 2019 | S024P | 0.89007310 | 0.85453745 | 0.92560875 | 0.020369976 |\n",
       "| S025PSim | total           | Brasil                                | 2019 | S025P | 0.13926777 | 0.11858300 | 0.15995253 | 0.075779522 |\n",
       "| S025PSim1 | total           | Capital                               | 2019 | S025P | 0.16857959 | 0.13172529 | 0.20543388 | 0.111541139 |\n",
       "| S026PSim | total           | Brasil                                | 2019 | S026P | 0.09180329 | 0.07358851 | 0.11001807 | 0.101231969 |\n",
       "| S026PSim1 | total           | Capital                               | 2019 | S026P | 0.08467879 | 0.06019173 | 0.10916584 | 0.147541381 |\n",
       "\n"
      ],
      "text/plain": [
       "                                       abr_tipo       \n",
       "Branca                                 raça           \n",
       "Preta                                  raça           \n",
       "Parda                                  raça           \n",
       "Até 1/2 SM                             rend_per_capita\n",
       "1/2 até 1 SM                           rend_per_capita\n",
       "1 até 2 SM                             rend_per_capita\n",
       "2 até 3 SM                             rend_per_capita\n",
       "Mais de 3 SM                           rend_per_capita\n",
       "18 a 24 anos                           fx_idade_s     \n",
       "25 a 29 anos                           fx_idade_s     \n",
       "30 a 39 anos                           fx_idade_s     \n",
       "40 anos ou mais                        fx_idade_s     \n",
       "urbano                                 urb_rur        \n",
       "rural                                  urb_rur        \n",
       "Rondônia                               uf             \n",
       "Acre                                   uf             \n",
       "Amazonas                               uf             \n",
       "Roraima                                uf             \n",
       "Pará                                   uf             \n",
       "Amapá                                  uf             \n",
       "Tocantins                              uf             \n",
       "Maranhão                               uf             \n",
       "Piauí                                  uf             \n",
       "Ceará                                  uf             \n",
       "Rio Grande do Norte                    uf             \n",
       "Paraíba                                uf             \n",
       "Pernambuco                             uf             \n",
       "Alagoas                                uf             \n",
       "Sergipe                                uf             \n",
       "Bahia                                  uf             \n",
       "⋮                                      ⋮              \n",
       "Mais de 3 SM6                          rend_per_capita\n",
       "18 a 24 anos6                          fx_idade_s     \n",
       "25 a 29 anos6                          fx_idade_s     \n",
       "30 a 39 anos6                          fx_idade_s     \n",
       "40 anos ou mais6                       fx_idade_s     \n",
       "urbano6                                urb_rur        \n",
       "rural6                                 urb_rur        \n",
       "Norte6                                 região         \n",
       "Nordeste6                              região         \n",
       "Sudeste6                               região         \n",
       "Sul6                                   região         \n",
       "Centro-Oeste6                          região         \n",
       "Fundamental incompleto ou equivalente6 gescol         \n",
       "Médio incompleto ou equivalente6       gescol         \n",
       "Superior incompleto ou equivalente6    gescol         \n",
       "Superior completo6                     gescol         \n",
       "S020PSim                               total          \n",
       "S020PSim1                              total          \n",
       "S021PSim                               total          \n",
       "S021PSim1                              total          \n",
       "S022PSim                               total          \n",
       "S022PSim1                              total          \n",
       "S023PSim                               total          \n",
       "S023PSim1                              total          \n",
       "S024PSim                               total          \n",
       "S024PSim1                              total          \n",
       "S025PSim                               total          \n",
       "S025PSim1                              total          \n",
       "S026PSim                               total          \n",
       "S026PSim1                              total          \n",
       "                                       abr_nome                             \n",
       "Branca                                 Branca                               \n",
       "Preta                                  Preta                                \n",
       "Parda                                  Parda                                \n",
       "Até 1/2 SM                             Até 1/2 SM                           \n",
       "1/2 até 1 SM                           1/2 até 1 SM                         \n",
       "1 até 2 SM                             1 até 2 SM                           \n",
       "2 até 3 SM                             2 até 3 SM                           \n",
       "Mais de 3 SM                           Mais de 3 SM                         \n",
       "18 a 24 anos                           18 a 24 anos                         \n",
       "25 a 29 anos                           25 a 29 anos                         \n",
       "30 a 39 anos                           30 a 39 anos                         \n",
       "40 anos ou mais                        40 anos ou mais                      \n",
       "urbano                                 urbano                               \n",
       "rural                                  rural                                \n",
       "Rondônia                               Rondônia                             \n",
       "Acre                                   Acre                                 \n",
       "Amazonas                               Amazonas                             \n",
       "Roraima                                Roraima                              \n",
       "Pará                                   Pará                                 \n",
       "Amapá                                  Amapá                                \n",
       "Tocantins                              Tocantins                            \n",
       "Maranhão                               Maranhão                             \n",
       "Piauí                                  Piauí                                \n",
       "Ceará                                  Ceará                                \n",
       "Rio Grande do Norte                    Rio Grande do Norte                  \n",
       "Paraíba                                Paraíba                              \n",
       "Pernambuco                             Pernambuco                           \n",
       "Alagoas                                Alagoas                              \n",
       "Sergipe                                Sergipe                              \n",
       "Bahia                                  Bahia                                \n",
       "⋮                                      ⋮                                    \n",
       "Mais de 3 SM6                          Mais de 3 SM                         \n",
       "18 a 24 anos6                          18 a 24 anos                         \n",
       "25 a 29 anos6                          25 a 29 anos                         \n",
       "30 a 39 anos6                          30 a 39 anos                         \n",
       "40 anos ou mais6                       40 anos ou mais                      \n",
       "urbano6                                urbano                               \n",
       "rural6                                 rural                                \n",
       "Norte6                                 Norte                                \n",
       "Nordeste6                              Nordeste                             \n",
       "Sudeste6                               Sudeste                              \n",
       "Sul6                                   Sul                                  \n",
       "Centro-Oeste6                          Centro-Oeste                         \n",
       "Fundamental incompleto ou equivalente6 Fundamental incompleto ou equivalente\n",
       "Médio incompleto ou equivalente6       Médio incompleto ou equivalente      \n",
       "Superior incompleto ou equivalente6    Superior incompleto ou equivalente   \n",
       "Superior completo6                     Superior completo                    \n",
       "S020PSim                               Brasil                               \n",
       "S020PSim1                              Capital                              \n",
       "S021PSim                               Brasil                               \n",
       "S021PSim1                              Capital                              \n",
       "S022PSim                               Brasil                               \n",
       "S022PSim1                              Capital                              \n",
       "S023PSim                               Brasil                               \n",
       "S023PSim1                              Capital                              \n",
       "S024PSim                               Brasil                               \n",
       "S024PSim1                              Capital                              \n",
       "S025PSim                               Brasil                               \n",
       "S025PSim1                              Capital                              \n",
       "S026PSim                               Brasil                               \n",
       "S026PSim1                              Capital                              \n",
       "                                       Ano  Indicador Sim        LowerS    \n",
       "Branca                                 2019 S020P     0.9462652  0.9150585 \n",
       "Preta                                  2019 S020P     0.9491546  0.9190134 \n",
       "Parda                                  2019 S020P     0.9406377  0.9204789 \n",
       "Até 1/2 SM                             2019 S020P     0.9296724  0.9109426 \n",
       "1/2 até 1 SM                           2019 S020P     0.9413991  0.9069147 \n",
       "1 até 2 SM                             2019 S020P     0.9616164  0.9246481 \n",
       "2 até 3 SM                             2019 S020P     0.9887464  0.9716482 \n",
       "Mais de 3 SM                           2019 S020P     0.9642104  0.9161889 \n",
       "18 a 24 anos                           2019 S020P     0.9495413  0.9244755 \n",
       "25 a 29 anos                           2019 S020P     0.9529889  0.9344372 \n",
       "30 a 39 anos                           2019 S020P     0.9332568  0.9026042 \n",
       "40 anos ou mais                        2019 S020P     0.9370615  0.8874357 \n",
       "urbano                                 2019 S020P     0.9462480  0.9285206 \n",
       "rural                                  2019 S020P     0.9244595  0.8935373 \n",
       "Rondônia                               2019 S020P     0.8862161  0.8171283 \n",
       "Acre                                   2019 S020P     0.9384015  0.8740413 \n",
       "Amazonas                               2019 S020P     0.8776843  0.8087780 \n",
       "Roraima                                2019 S020P     0.9469861  0.9000798 \n",
       "Pará                                   2019 S020P     0.9306247  0.8747821 \n",
       "Amapá                                  2019 S020P     0.9275277  0.8519172 \n",
       "Tocantins                              2019 S020P     0.9361957  0.8448937 \n",
       "Maranhão                               2019 S020P     0.9482602  0.9167190 \n",
       "Piauí                                  2019 S020P     0.9468641  0.9035875 \n",
       "Ceará                                  2019 S020P     0.9822641  0.9478668 \n",
       "Rio Grande do Norte                    2019 S020P     0.9232503  0.8679509 \n",
       "Paraíba                                2019 S020P     0.9439027  0.8976978 \n",
       "Pernambuco                             2019 S020P     0.8733903  0.7446742 \n",
       "Alagoas                                2019 S020P     0.9651868  0.9326968 \n",
       "Sergipe                                2019 S020P     0.9699511  0.9274677 \n",
       "Bahia                                  2019 S020P     0.9805097  0.9530631 \n",
       "⋮                                      ⋮    ⋮         ⋮          ⋮         \n",
       "Mais de 3 SM6                          2019 S026P     0.11071546 0.02886413\n",
       "18 a 24 anos6                          2019 S026P     0.06707236 0.04321910\n",
       "25 a 29 anos6                          2019 S026P     0.09006160 0.05263542\n",
       "30 a 39 anos6                          2019 S026P     0.11228868 0.07823102\n",
       "40 anos ou mais6                       2019 S026P     0.08040375 0.03261232\n",
       "urbano6                                2019 S026P     0.09123426 0.07078246\n",
       "rural6                                 2019 S026P     0.09491624 0.05783730\n",
       "Norte6                                 2019 S026P     0.08748685 0.05386950\n",
       "Nordeste6                              2019 S026P     0.08794721 0.06295773\n",
       "Sudeste6                               2019 S026P     0.09298834 0.05444746\n",
       "Sul6                                   2019 S026P     0.11172938 0.06460214\n",
       "Centro-Oeste6                          2019 S026P     0.07506477 0.04169546\n",
       "Fundamental incompleto ou equivalente6 2019 S026P     0.12548939 0.07474790\n",
       "Médio incompleto ou equivalente6       2019 S026P     0.11484022 0.06966174\n",
       "Superior incompleto ou equivalente6    2019 S026P     0.06364051 0.04203844\n",
       "Superior completo6                     2019 S026P     0.10049694 0.05485221\n",
       "S020PSim                               2019 S020P     0.94288075 0.92716331\n",
       "S020PSim1                              2019 S020P     0.93159431 0.91045976\n",
       "S021PSim                               2019 S021P     0.72256554 0.69506341\n",
       "S021PSim1                              2019 S021P     0.75117212 0.70981244\n",
       "S022PSim                               2019 S022P     0.75411181 0.72742385\n",
       "S022PSim1                              2019 S022P     0.78080922 0.74082019\n",
       "S023PSim                               2019 S023P     0.44394229 0.41276521\n",
       "S023PSim1                              2019 S023P     0.44329869 0.39325467\n",
       "S024PSim                               2019 S024P     0.85014508 0.82818447\n",
       "S024PSim1                              2019 S024P     0.89007310 0.85453745\n",
       "S025PSim                               2019 S025P     0.13926777 0.11858300\n",
       "S025PSim1                              2019 S025P     0.16857959 0.13172529\n",
       "S026PSim                               2019 S026P     0.09180329 0.07358851\n",
       "S026PSim1                              2019 S026P     0.08467879 0.06019173\n",
       "                                       UpperS     cvS        \n",
       "Branca                                 0.9774720  0.016826270\n",
       "Preta                                  0.9792958  0.016202236\n",
       "Parda                                  0.9607964  0.010934363\n",
       "Até 1/2 SM                             0.9484022  0.010279112\n",
       "1/2 até 1 SM                           0.9758836  0.018689675\n",
       "1 até 2 SM                             0.9985846  0.019614569\n",
       "2 até 3 SM                             1.0058446  0.008823016\n",
       "Mais de 3 SM                           1.0122318  0.025410618\n",
       "18 a 24 anos                           0.9746072  0.013468538\n",
       "25 a 29 anos                           0.9715406  0.009932271\n",
       "30 a 39 anos                           0.9639095  0.016757868\n",
       "40 anos ou mais                        0.9866874  0.027020387\n",
       "urbano                                 0.9639755  0.009558592\n",
       "rural                                  0.9553818  0.017066135\n",
       "Rondônia                               0.9553040  0.039775344\n",
       "Acre                                   1.0027618  0.034992968\n",
       "Amazonas                               0.9465905  0.040056436\n",
       "Roraima                                0.9938923  0.025271953\n",
       "Pará                                   0.9864672  0.030615586\n",
       "Amapá                                  1.0031382  0.041591750\n",
       "Tocantins                              1.0274977  0.049758309\n",
       "Maranhão                               0.9798014  0.016970815\n",
       "Piauí                                  0.9901407  0.023319385\n",
       "Ceará                                  1.0166614  0.017866842\n",
       "Rio Grande do Norte                    0.9785498  0.030559988\n",
       "Paraíba                                0.9901076  0.024975396\n",
       "Pernambuco                             1.0021063  0.075192807\n",
       "Alagoas                                0.9976769  0.017174762\n",
       "Sergipe                                1.0124344  0.022347080\n",
       "Bahia                                  1.0079562  0.014281971\n",
       "⋮                                      ⋮          ⋮          \n",
       "Mais de 3 SM6                          0.19256679 0.377198018\n",
       "18 a 24 anos6                          0.09092562 0.181449635\n",
       "25 a 29 anos6                          0.12748778 0.212025320\n",
       "30 a 39 anos6                          0.14634634 0.154750013\n",
       "40 anos ou mais6                       0.12819518 0.303267312\n",
       "urbano6                                0.11168607 0.114373564\n",
       "rural6                                 0.13199517 0.199314376\n",
       "Norte6                                 0.12110419 0.196052563\n",
       "Nordeste6                              0.11293669 0.144972960\n",
       "Sudeste6                               0.13152923 0.211468215\n",
       "Sul6                                   0.15885661 0.215207044\n",
       "Centro-Oeste6                          0.10843408 0.226810433\n",
       "Fundamental incompleto ou equivalente6 0.17623088 0.206304228\n",
       "Médio incompleto ou equivalente6       0.16001871 0.200719497\n",
       "Superior incompleto ou equivalente6    0.08524259 0.173186377\n",
       "Superior completo6                     0.14614167 0.231733978\n",
       "S020PSim                               0.95859820 0.008505053\n",
       "S020PSim1                              0.95272885 0.011574921\n",
       "S021PSim                               0.75006767 0.019419631\n",
       "S021PSim1                              0.79253179 0.028092449\n",
       "S022PSim                               0.78079977 0.018056418\n",
       "S022PSim1                              0.82079824 0.026130502\n",
       "S023PSim                               0.47511936 0.035831150\n",
       "S023PSim1                              0.49334271 0.057598032\n",
       "S024PSim                               0.87210569 0.013179631\n",
       "S024PSim1                              0.92560875 0.020369976\n",
       "S025PSim                               0.15995253 0.075779522\n",
       "S025PSim1                              0.20543388 0.111541139\n",
       "S026PSim                               0.11001807 0.101231969\n",
       "S026PSim1                              0.10916584 0.147541381"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "matriz_final"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exportando tabela de indicadores calculados - Módulo S  2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "diretorio_saida <- \"<coloque aqui o diretório>\"\n",
    "write.table(matrizIndicadores,file=paste0(diretorio_saida,\"Indicadores_2019S_R.csv\"),sep = \";\",dec = \",\",row.names = FALSE)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "R",
   "language": "R",
   "name": "ir"
  },
  "language_info": {
   "codemirror_mode": "r",
   "file_extension": ".r",
   "mimetype": "text/x-r-source",
   "name": "R",
   "pygments_lexer": "r",
   "version": "4.1.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}