{ "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 2013 Pré-natal - Parte 4" ] }, { "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(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": [ "\n", "
  1. 222385
  2. 1000
\n" ], "text/latex": [ "\\begin{enumerate*}\n", "\\item 222385\n", "\\item 1000\n", "\\end{enumerate*}\n" ], "text/markdown": [ "1. 222385\n", "2. 1000\n", "\n", "\n" ], "text/plain": [ "[1] 222385 1000" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Carregando banco de dados para R versão 3.5.0 ou superior\n", "load(\"\")\n", "\n", "#conferindo as dimensões (número de linhas e colunas)\n", "dim(\"\")" ] }, { "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.004156 0.243959 0.521557 1.000000 1.147413 31.179597 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Selecionando registros válidos para o módulo K e calculando peso amostral - summary de verificação\n", "pns2013.1<- %>% filter(M001==1) \n", "pns2013.1<-pns2013.1 %>% mutate(peso_morador_selec=((V00291*(60202/145572211))))\n", "pns2013.1<-pns2013.1 %>% filter(!is.na(peso_morador_selec))\n", "summary(pns2013.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": [ "
Sim
1590
Não
261
NA's
58351
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1590\n", "\\item[Não] 261\n", "\\item[NA's] 58351\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1590Não\n", ": 261NA's\n", ": 58351\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1590 261 58351 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
1362
Não
489
NA's
58351
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1362\n", "\\item[Não] 489\n", "\\item[NA's] 58351\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1362Não\n", ": 489NA's\n", ": 58351\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1362 489 58351 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
1664
Não
254
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1664\n", "\\item[Não] 254\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1664Não\n", ": 254NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1664 254 58284 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Desfechos - Indicadores\n", "\n", "# 16. Proporção de mulheres que fizeram teste de HIV/AIDS durante o pré-natal - S016P.\n", "pns2013.1$S016P <- NA\n", "pns2013.1$S016P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001==1] <- 2\n", "pns2013.1$S016P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001==1 & pns2013.1$S034==1] <- 1\n", "pns2013.1$S016P<-factor(pns2013.1$S016P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S016P)\n", "\n", "\n", "# 18. Proporção de mulheres que receberam indicação da maternidade para o parto durante o pré-natal - S018P.\n", "pns2013.1$S018P <- NA\n", "pns2013.1$S018P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001==1] <- 2\n", "pns2013.1$S018P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001==1 & pns2013.1$S012 == 1 ] <- 1\n", "pns2013.1$S018P<-factor(pns2013.1$S018P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S018P)\n", "\n", "# 19. Proporção de mulheres que foram atendidas por médico no último parto - S019P.\n", "pns2013.1$S019P <- NA\n", "pns2013.1$S019P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0] <- 2\n", "pns2013.1$S019P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0 & pns2013.1$S046 == 1] <- 1\n", "pns2013.1$S019P<-factor(pns2013.1$S019P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S019P)\n" ] }, { "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": [ "
urbano
49245
rural
10957
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[urbano] 49245\n", "\\item[rural] 10957\n", "\\end{description*}\n" ], "text/markdown": [ "urbano\n", ": 49245rural\n", ": 10957\n", "\n" ], "text/plain": [ "urbano rural \n", " 49245 10957 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Situação Urbano ou Rural\n", "pns2013.1 <- pns2013.1 %>% mutate(urb_rur=V0026)\n", "pns2013.1$urb_rur<-factor(pns2013.1$urb_rur, levels=c(1,2), labels=c(\"urbano\", \"rural\"))\n", "summary(pns2013.1$urb_rur)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### UF" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Rondônia
1694
Acre
1814
Amazonas
2586
Roraima
1591
Pará
2004
Amapá
1332
Tocantins
1515
Maranhão
1774
Piauí
1804
Ceará
2560
Rio Grande do Norte
1691
Paraíba
1943
Pernambuco
2591
Alagoas
1748
Sergipe
1553
Bahia
2641
Minas Gerais
3779
Espírito Santo
1724
Rio de Janeiro
3486
São Paulo
5305
Paraná
3012
Santa Catarina
1623
Rio Grande do Sul
2913
Mato Grosso do Sul
1809
Mato Grosso
1476
Goiás
2423
Distrito Federal
1811
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Rondônia] 1694\n", "\\item[Acre] 1814\n", "\\item[Amazonas] 2586\n", "\\item[Roraima] 1591\n", "\\item[Pará] 2004\n", "\\item[Amapá] 1332\n", "\\item[Tocantins] 1515\n", "\\item[Maranhão] 1774\n", "\\item[Piauí] 1804\n", "\\item[Ceará] 2560\n", "\\item[Rio Grande do Norte] 1691\n", "\\item[Paraíba] 1943\n", "\\item[Pernambuco] 2591\n", "\\item[Alagoas] 1748\n", "\\item[Sergipe] 1553\n", "\\item[Bahia] 2641\n", "\\item[Minas Gerais] 3779\n", "\\item[Espírito Santo] 1724\n", "\\item[Rio de Janeiro] 3486\n", "\\item[São Paulo] 5305\n", "\\item[Paraná] 3012\n", "\\item[Santa Catarina] 1623\n", "\\item[Rio Grande do Sul] 2913\n", "\\item[Mato Grosso do Sul] 1809\n", "\\item[Mato Grosso] 1476\n", "\\item[Goiás] 2423\n", "\\item[Distrito Federal] 1811\n", "\\end{description*}\n" ], "text/markdown": [ "Rondônia\n", ": 1694Acre\n", ": 1814Amazonas\n", ": 2586Roraima\n", ": 1591Pará\n", ": 2004Amapá\n", ": 1332Tocantins\n", ": 1515Maranhão\n", ": 1774Piauí\n", ": 1804Ceará\n", ": 2560Rio Grande do Norte\n", ": 1691Paraíba\n", ": 1943Pernambuco\n", ": 2591Alagoas\n", ": 1748Sergipe\n", ": 1553Bahia\n", ": 2641Minas Gerais\n", ": 3779Espírito Santo\n", ": 1724Rio de Janeiro\n", ": 3486São Paulo\n", ": 5305Paraná\n", ": 3012Santa Catarina\n", ": 1623Rio Grande do Sul\n", ": 2913Mato Grosso do Sul\n", ": 1809Mato Grosso\n", ": 1476Goiás\n", ": 2423Distrito Federal\n", ": 1811\n", "\n" ], "text/plain": [ " Rondônia Acre Amazonas Roraima \n", " 1694 1814 2586 1591 \n", " Pará Amapá Tocantins Maranhão \n", " 2004 1332 1515 1774 \n", " Piauí Ceará Rio Grande do Norte Paraíba \n", " 1804 2560 1691 1943 \n", " Pernambuco Alagoas Sergipe Bahia \n", " 2591 1748 1553 2641 \n", " Minas Gerais Espírito Santo Rio de Janeiro São Paulo \n", " 3779 1724 3486 5305 \n", " Paraná Santa Catarina Rio Grande do Sul Mato Grosso do Sul \n", " 3012 1623 2913 1809 \n", " Mato Grosso Goiás Distrito Federal \n", " 1476 2423 1811 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Estados - UFs\n", "pns2013.1 <- pns2013.1 %>% mutate(uf=V0001)\n", "pns2013.1$uf<-factor(pns2013.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(pns2013.1$uf)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Grandes Regiões" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Norte
12536
Nordeste
18305
Sudeste
14294
Sul
7548
Centro-Oeste
7519
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Norte] 12536\n", "\\item[Nordeste] 18305\n", "\\item[Sudeste] 14294\n", "\\item[Sul] 7548\n", "\\item[Centro-Oeste] 7519\n", "\\end{description*}\n" ], "text/markdown": [ "Norte\n", ": 12536Nordeste\n", ": 18305Sudeste\n", ": 14294Sul\n", ": 7548Centro-Oeste\n", ": 7519\n", "\n" ], "text/plain": [ " Norte Nordeste Sudeste Sul Centro-Oeste \n", " 12536 18305 14294 7548 7519 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Grandes Regiões\n", "pns2013.1 <- pns2013.1 %>% mutate(\n", " 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(pns2013.1$região)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Capital" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Porto Velho
1694
Rio Branco
1814
Manaus
2586
Boa Vista
1591
Belém
2004
Macapá
1332
Palmas
1515
São Luís
1774
Teresina
1804
Fortaleza
2560
Natal
1691
João Pessoa
1943
Recife
2591
Maceió
1748
Aracaju
1553
Salvador
2641
Belo Horizonte
3779
Vitória
1724
Rio de Janeiro
3486
São Paulo
5305
Curitiba
3012
Florianópolis
1623
Porto Alegre
2913
Campo Grande
1809
Cuiabá
1476
Goiânia
2423
Brasília
1811
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Porto Velho] 1694\n", "\\item[Rio Branco] 1814\n", "\\item[Manaus] 2586\n", "\\item[Boa Vista] 1591\n", "\\item[Belém] 2004\n", "\\item[Macapá] 1332\n", "\\item[Palmas] 1515\n", "\\item[São Luís] 1774\n", "\\item[Teresina] 1804\n", "\\item[Fortaleza] 2560\n", "\\item[Natal] 1691\n", "\\item[João Pessoa] 1943\n", "\\item[Recife] 2591\n", "\\item[Maceió] 1748\n", "\\item[Aracaju] 1553\n", "\\item[Salvador] 2641\n", "\\item[Belo Horizonte] 3779\n", "\\item[Vitória] 1724\n", "\\item[Rio de Janeiro] 3486\n", "\\item[São Paulo] 5305\n", "\\item[Curitiba] 3012\n", "\\item[Florianópolis] 1623\n", "\\item[Porto Alegre] 2913\n", "\\item[Campo Grande] 1809\n", "\\item[Cuiabá] 1476\n", "\\item[Goiânia] 2423\n", "\\item[Brasília] 1811\n", "\\end{description*}\n" ], "text/markdown": [ "Porto Velho\n", ": 1694Rio Branco\n", ": 1814Manaus\n", ": 2586Boa Vista\n", ": 1591Belém\n", ": 2004Macapá\n", ": 1332Palmas\n", ": 1515São Luís\n", ": 1774Teresina\n", ": 1804Fortaleza\n", ": 2560Natal\n", ": 1691João Pessoa\n", ": 1943Recife\n", ": 2591Maceió\n", ": 1748Aracaju\n", ": 1553Salvador\n", ": 2641Belo Horizonte\n", ": 3779Vitória\n", ": 1724Rio de Janeiro\n", ": 3486São Paulo\n", ": 5305Curitiba\n", ": 3012Florianópolis\n", ": 1623Porto Alegre\n", ": 2913Campo Grande\n", ": 1809Cuiabá\n", ": 1476Goiânia\n", ": 2423Brasília\n", ": 1811\n", "\n" ], "text/plain": [ " Porto Velho Rio Branco Manaus Boa Vista Belém \n", " 1694 1814 2586 1591 2004 \n", " Macapá Palmas São Luís Teresina Fortaleza \n", " 1332 1515 1774 1804 2560 \n", " Natal João Pessoa Recife Maceió Aracaju \n", " 1691 1943 2591 1748 1553 \n", " Salvador Belo Horizonte Vitória Rio de Janeiro São Paulo \n", " 2641 3779 1724 3486 5305 \n", " Curitiba Florianópolis Porto Alegre Campo Grande Cuiabá \n", " 3012 1623 2913 1809 1476 \n", " Goiânia Brasília \n", " 2423 1811 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Capital\n", "pns2013.1<- pns2013.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(pns2013.1$capital)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Faixa Etária" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
18 a 24 anos
7823
25 a 29 anos
6498
30 a 39 anos
14269
40 anos ou mais
31612
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[18 a 24 anos] 7823\n", "\\item[25 a 29 anos] 6498\n", "\\item[30 a 39 anos] 14269\n", "\\item[40 anos ou mais] 31612\n", "\\end{description*}\n" ], "text/markdown": [ "18 a 24 anos\n", ": 782325 a 29 anos\n", ": 649830 a 39 anos\n", ": 1426940 anos ou mais\n", ": 31612\n", "\n" ], "text/plain": [ " 18 a 24 anos 25 a 29 anos 30 a 39 anos 40 anos ou mais \n", " 7823 6498 14269 31612 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Faixas Etárias\n", "pns2013.1 <- pns2013.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(pns2013.1$fx_idade_S)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Raça" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Branca
24106
Preta
5631
Parda
29512
NA's
953
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Branca] 24106\n", "\\item[Preta] 5631\n", "\\item[Parda] 29512\n", "\\item[NA's] 953\n", "\\end{description*}\n" ], "text/markdown": [ "Branca\n", ": 24106Preta\n", ": 5631Parda\n", ": 29512NA's\n", ": 953\n", "\n" ], "text/plain": [ "Branca Preta Parda NA's \n", " 24106 5631 29512 953 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Raça\n", "pns2013.1 <- pns2013.1 %>% mutate(raça= ifelse(C009==1, 1, \n", " ifelse(C009==2, 2, \n", " ifelse(C009==4, 3, 9))))\n", "pns2013.1$raça<-factor(pns2013.1$raça, levels=c(1,2,3),labels=c(\"Branca\", \"Preta\", \"Parda\"))\n", "summary(pns2013.1$raça)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Renda per capita" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Até 1/2 SM
14256
1/2 até 1 SM
17504
1 até 2 SM
15493
2 até 3 SM
5335
Mais de 3 SM
7603
NA's
11
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Até 1/2 SM] 14256\n", "\\item[1/2 até 1 SM] 17504\n", "\\item[1 até 2 SM] 15493\n", "\\item[2 até 3 SM] 5335\n", "\\item[Mais de 3 SM] 7603\n", "\\item[NA's] 11\n", "\\end{description*}\n" ], "text/markdown": [ "Até 1/2 SM\n", ": 142561/2 até 1 SM\n", ": 175041 até 2 SM\n", ": 154932 até 3 SM\n", ": 5335Mais de 3 SM\n", ": 7603NA's\n", ": 11\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", " 14256 17504 15493 5335 7603 11 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Rendimento domiciliar per capita\n", "pns2013.1 <- pns2013.1 %>% mutate(rend_per_capita=cut(VDF003,\n", " breaks = c(-Inf,339, 678, 1356, 2034, Inf),\n", " labels=c(\"Até 1/2 SM\",\"1/2 até 1 SM\",\"1 até 2 SM\",\"2 até 3 SM\",\"Mais de 3 SM\"), \n", " ordered_result = TRUE, right = TRUE, na.exclude= TRUE))\n", "summary(pns2013.1$rend_per_capita)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Escolaridade" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Fundamental incompleto ou equivalente
24083
Médio incompleto ou equivalente
9215
Superior incompleto ou equivalente
19149
Superior completo
7755
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Fundamental incompleto ou equivalente] 24083\n", "\\item[Médio incompleto ou equivalente] 9215\n", "\\item[Superior incompleto ou equivalente] 19149\n", "\\item[Superior completo] 7755\n", "\\end{description*}\n" ], "text/markdown": [ "Fundamental incompleto ou equivalente\n", ": 24083Médio incompleto ou equivalente\n", ": 9215Superior incompleto ou equivalente\n", ": 19149Superior completo\n", ": 7755\n", "\n" ], "text/plain": [ "Fundamental incompleto ou equivalente Médio incompleto ou equivalente \n", " 24083 9215 \n", " Superior incompleto ou equivalente Superior completo \n", " 19149 7755 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Escolaridade\n", "pns2013.1 <- pns2013.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", "pns2013.1$gescol<-factor(pns2013.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", "\n", "summary(pns2013.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", " Min. :1110011 Min. :1100001 Min. : 0.004156 Min. : 18.00 \n", " 1st Qu.:2210013 1st Qu.:2200075 1st Qu.: 0.243959 1st Qu.: 30.00 \n", " Median :2951023 Median :2900192 Median : 0.521557 Median : 41.00 \n", " Mean :3035353 Mean :3007819 Mean : 1.000000 Mean : 43.31 \n", " 3rd Qu.:4110111 3rd Qu.:4100002 3rd Qu.: 1.147413 3rd Qu.: 55.00 \n", " Max. :5310220 Max. :5300180 Max. :31.179597 Max. :101.00 \n", " \n", " C006 C009 V0031 urb_rur \n", " Min. :1.000 Min. :1.00 Min. :1.000 urbano:49245 \n", " 1st Qu.:1.000 1st Qu.:1.00 1st Qu.:1.000 rural :10957 \n", " Median :2.000 Median :3.00 Median :2.000 \n", " Mean :1.569 Mean :2.61 Mean :2.308 \n", " 3rd Qu.:2.000 3rd Qu.:4.00 3rd Qu.:4.000 \n", " Max. :2.000 Max. :9.00 Max. :4.000 \n", " \n", " uf região capital \n", " São Paulo : 5305 Norte :12536 São Paulo : 5305 \n", " Minas Gerais : 3779 Nordeste :18305 Belo Horizonte: 3779 \n", " Rio de Janeiro : 3486 Sudeste :14294 Rio de Janeiro: 3486 \n", " Paraná : 3012 Sul : 7548 Curitiba : 3012 \n", " Rio Grande do Sul: 2913 Centro-Oeste: 7519 Porto Alegre : 2913 \n", " Bahia : 2641 Salvador : 2641 \n", " (Other) :39066 (Other) :39066 \n", " fx_idade_S raça rend_per_capita \n", " 18 a 24 anos : 7823 Branca:24106 Até 1/2 SM :14256 \n", " 25 a 29 anos : 6498 Preta : 5631 1/2 até 1 SM:17504 \n", " 30 a 39 anos :14269 Parda :29512 1 até 2 SM :15493 \n", " 40 anos ou mais:31612 NA's : 953 2 até 3 SM : 5335 \n", " Mais de 3 SM: 7603 \n", " NA's : 11 \n", " \n", " gescol S016P S018P \n", " Fundamental incompleto ou equivalente:24083 Sim : 1590 Sim : 1362 \n", " Médio incompleto ou equivalente : 9215 Não : 261 Não : 489 \n", " Superior incompleto ou equivalente :19149 NA's:58351 NA's:58351 \n", " Superior completo : 7755 \n", " \n", " \n", " \n", " S019P S001 \n", " Sim : 1664 Min. :1.00 \n", " Não : 254 1st Qu.:1.00 \n", " NA's:58284 Median :1.00 \n", " Mean :1.03 \n", " 3rd Qu.:1.00 \n", " Max. :2.00 \n", " NA's :58284 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Selecionando variáveis para cálculo de indicadores no survey\n", "pns2013Ssurvey<- pns2013.1 %>% select(\"V0024\",\"UPA_PNS\",\"peso_morador_selec\", \"C008\", \"C006\", \"C009\", \"V0031\",\n", " \"urb_rur\", \"uf\", \"região\", \"capital\", \"fx_idade_S\", \"raça\",\n", " \"rend_per_capita\", \"gescol\", \"S016P\", \"S018P\", \"S019P\", \"S001\") \n", "summary(pns2013Ssurvey)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Exporta tabela filtrada com os dados específicos - Módulo S - Parte 4 2013" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "# Salvando csv para cálculo de indicadores no survey\n", "diretorio_saida <- \"\"\n", "write.csv(pns2013Ssurvey, file.path(diretorio_saida, \"pns2013Ssurvey.csv\"))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Cria plano amostral complexo" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [], "source": [ "# survey design\n", "desPNS=svydesign(id=~UPA_PNS, \n", " strat=~V0024,\n", " weight=~peso_morador_selec,\n", " nest=TRUE,\n", " data=pns2013Ssurvey)" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [], "source": [ "#survey design S016P, S018P\n", "desPNSS=subset(desPNS, C006==2 & C008>=18 & S001==1)\n", "desPNSS_C=subset(desPNS, C006==2 & C008>=18 & S001==1 & V0031==1)\n", "desPNSS_R=subset(desPNS, C006==2 & C008>=18 & S001==1 & !is.na(raça))\n", "desPNSS_Rend=subset(desPNS, C006==2 & C008>=18 & S001==1 & !is.na(rend_per_capita))" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [], "source": [ "#survey design S019P\n", "desPNSS_S019P=subset(desPNS, C006==2 & C008>=18 & S001>0)\n", "desPNSS_S019P_C=subset(desPNS, C006==2 & C008>=18 & S001>0 & V0031==1)\n", "desPNSS_S019P_R=subset(desPNS, C006==2 & C008>=18 & S001>0 & !is.na(raça))\n", "desPNSS_S019P_Rend=subset(desPNS, C006==2 & C008>=18 & S001>0 & !is.na(rend_per_capita))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Criação da tabela de indicadores\n", "Essa tabela é responsável por unir os indicadores no formato do painel de indicadores" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Definição de variáveis para iteração dos indicadores" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "design_por_abrangencia <- list(\n", " S016P = list(\n", " capital = desPNSS_C,\n", " raça = desPNSS_R,\n", " rend_per_capita = desPNSS_Rend,\n", " default = desPNSS\n", " ),\n", " S018P = list(\n", " capital = desPNSS_C,\n", " raça = desPNSS_R,\n", " rend_per_capita = desPNSS_Rend,\n", " default = desPNSS\n", " ),\n", " S019P = list(\n", " capital = desPNSS_S019P_C,\n", " raça = desPNSS_S019P_R,\n", " rend_per_capita = desPNSS_S019P_Rend,\n", " default = desPNSS_S019P\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(~S016P, ~S018P, ~S019P)\n", "totais <- c(~Brasil,~Capital)\n", "Ano <- \"2013\"" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Preenchendo a tabela de indicadores" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [], "source": [ "matriz_indicadores <- popula_indicadores(design_por_abrangencia, dominios, indicadores, Ano)" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
A data.frame: 231 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><fct><chr><chr><dbl><dbl><dbl><dbl>
Brancaraça Branca 2013S016P0.87048930.82770140.91327720.02507897
Pretaraça Preta 2013S016P0.78243060.65727290.90758820.08161378
Pardaraça Parda 2013S016P0.84614780.80979390.88250180.02192086
Até 1/2 SMrend_per_capitaAté 1/2 SM 2013S016P0.82853700.79182520.86524870.02260709
1/2 até 1 SMrend_per_capita1/2 até 1 SM 2013S016P0.88850540.84298410.93402670.02614005
1 até 2 SMrend_per_capita1 até 2 SM 2013S016P0.84266100.76407680.92124530.04758111
2 até 3 SMrend_per_capita2 até 3 SM 2013S016P0.79885030.58510661.01259400.13651485
Mais de 3 SMrend_per_capitaMais de 3 SM 2013S016P0.88622410.79591290.97653540.05199364
18 a 24 anosfx_idade_s 18 a 24 anos 2013S016P0.85280840.80583200.89978490.02810482
25 a 29 anosfx_idade_s 25 a 29 anos 2013S016P0.82625570.77299420.87951720.03288902
30 a 39 anosfx_idade_s 30 a 39 anos 2013S016P0.86609260.81729040.91489480.02874925
40 anos ou maisfx_idade_s 40 anos ou mais 2013S016P0.84864110.74452490.95275720.06259593
urbanourb_rur urbano 2013S016P0.86668000.83714790.89621210.01738551
ruralurb_rur rural 2013S016P0.76755230.69592950.83917510.04760970
Rondôniauf Rondônia 2013S016P0.82162710.69582310.94743120.07812173
Acreuf Acre 2013S016P0.85471010.77098390.93843640.04997984
Amazonasuf Amazonas 2013S016P0.86678920.79432960.93924880.04265152
Roraimauf Roraima 2013S016P0.97927030.95379071.00474980.01327522
Paráuf Pará 2013S016P0.84053360.74211850.93894860.05973905
Amapáuf Amapá 2013S016P0.93066540.85751161.00381910.04010467
Tocantinsuf Tocantins 2013S016P0.87820340.77392050.98248630.06058569
Maranhãouf Maranhão 2013S016P0.78354740.63364360.93345130.09761116
Piauíuf Piauí 2013S016P0.70361850.57067090.83656610.09640404
Cearáuf Ceará 2013S016P0.85622090.76688260.94555920.05323580
Rio Grande do Norteuf Rio Grande do Norte2013S016P0.91598770.83507900.99689630.04506687
Paraíbauf Paraíba 2013S016P0.77592160.63152600.92031720.09494847
Pernambucouf Pernambuco 2013S016P0.88330220.80077480.96582960.04766951
Alagoasuf Alagoas 2013S016P0.73632610.59529720.87735500.09772144
Sergipeuf Sergipe 2013S016P0.81480580.68252710.94708440.08282999
Bahiauf Bahia 2013S016P0.78358430.66021490.90695370.08032921
⋮⋮⋮⋮⋮⋮⋮⋮⋮
Rio Branco2capitalRio Branco 2013S019P0.85998410.74113210.97883610.07051280
Manaus2capitalManaus 2013S019P0.88364200.78302940.98425460.05809353
Boa Vista2capitalBoa Vista 2013S019P0.83876710.73560970.94192440.06274957
Belém2capitalBelém 2013S019P0.92200370.77707351.06693400.08020074
Macapá2capitalMacapá 2013S019P0.86180150.74060600.98299690.07175152
Palmas2capitalPalmas 2013S019P0.97559860.92829841.02289880.02473681
São Luís2capitalSão Luís 2013S019P0.95817220.90125391.01509050.03030823
Teresina2capitalTeresina 2013S019P0.81948820.61432401.02465240.12773525
Fortaleza2capitalFortaleza 2013S019P0.88287750.70111401.06464110.10504088
Natal2capitalNatal 2013S019P1.00000001.00000001.00000000.00000000
João Pessoa2capitalJoão Pessoa 2013S019P0.95264220.89144181.01384270.03277755
Recife2capitalRecife 2013S019P0.93125560.79917901.06333230.07236175
Maceió2capitalMaceió 2013S019P0.66676960.46823480.86530450.15191926
Aracaju2capitalAracaju 2013S019P1.00000001.00000001.00000000.00000000
Salvador2capitalSalvador 2013S019P0.90615130.80278741.00951530.05819962
Belo Horizonte2capitalBelo Horizonte 2013S019P0.85890350.71941890.99838810.08285789
Vitória2capitalVitória 2013S019P0.95045700.85251531.04839880.05257597
Rio de Janeiro5capitalRio de Janeiro 2013S019P0.89421210.77589891.01252530.06750635
São Paulo4capitalSão Paulo 2013S019P0.93112880.87607550.98618210.03016655
Curitiba2capitalCuritiba 2013S019P0.95801690.88005291.03598100.04152151
Florianópolis2capitalFlorianópolis 2013S019P0.85890800.74914120.96867480.06520431
Porto Alegre2capitalPorto Alegre 2013S019P0.96247950.88878951.03616960.03906333
Campo Grande2capitalCampo Grande 2013S019P0.96766840.90681281.02852410.03208679
Cuiabá2capitalCuiabá 2013S019P0.96687830.90861811.02513840.03074339
Goiânia2capitalGoiânia 2013S019P0.98066240.94215031.01917460.02003687
Brasília2capitalBrasília 2013S019P0.94283260.86540711.02025810.04189879
Fundamental incompleto ou equivalente2gescol Fundamental incompleto ou equivalente2013S019P0.76281610.69883180.82680030.04279619
Médio incompleto ou equivalente2gescol Médio incompleto ou equivalente 2013S019P0.89410550.84423700.94397400.02845703
Superior incompleto ou equivalente2gescol Superior incompleto ou equivalente 2013S019P0.90541780.87556530.93527030.01682225
Superior completo2gescol Superior completo 2013S019P0.96211930.92681370.99742480.01872258
\n" ], "text/latex": [ "A data.frame: 231 × 8\n", "\\begin{tabular}{r|llllllll}\n", " & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n", " & & & & & & & & \\\\\n", "\\hline\n", "\tBranca & raça & Branca & 2013 & S016P & 0.8704893 & 0.8277014 & 0.9132772 & 0.02507897\\\\\n", "\tPreta & raça & Preta & 2013 & S016P & 0.7824306 & 0.6572729 & 0.9075882 & 0.08161378\\\\\n", "\tParda & raça & Parda & 2013 & S016P & 0.8461478 & 0.8097939 & 0.8825018 & 0.02192086\\\\\n", "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM & 2013 & S016P & 0.8285370 & 0.7918252 & 0.8652487 & 0.02260709\\\\\n", "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM & 2013 & S016P & 0.8885054 & 0.8429841 & 0.9340267 & 0.02614005\\\\\n", "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM & 2013 & S016P & 0.8426610 & 0.7640768 & 0.9212453 & 0.04758111\\\\\n", "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM & 2013 & S016P & 0.7988503 & 0.5851066 & 1.0125940 & 0.13651485\\\\\n", "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM & 2013 & S016P & 0.8862241 & 0.7959129 & 0.9765354 & 0.05199364\\\\\n", "\t18 a 24 anos & fx\\_idade\\_s & 18 a 24 anos & 2013 & S016P & 0.8528084 & 0.8058320 & 0.8997849 & 0.02810482\\\\\n", "\t25 a 29 anos & fx\\_idade\\_s & 25 a 29 anos & 2013 & S016P & 0.8262557 & 0.7729942 & 0.8795172 & 0.03288902\\\\\n", "\t30 a 39 anos & fx\\_idade\\_s & 30 a 39 anos & 2013 & S016P & 0.8660926 & 0.8172904 & 0.9148948 & 0.02874925\\\\\n", "\t40 anos ou mais & fx\\_idade\\_s & 40 anos ou mais & 2013 & S016P & 0.8486411 & 0.7445249 & 0.9527572 & 0.06259593\\\\\n", "\turbano & urb\\_rur & urbano & 2013 & S016P & 0.8666800 & 0.8371479 & 0.8962121 & 0.01738551\\\\\n", "\trural & urb\\_rur & rural & 2013 & S016P & 0.7675523 & 0.6959295 & 0.8391751 & 0.04760970\\\\\n", "\tRondônia & uf & Rondônia & 2013 & S016P & 0.8216271 & 0.6958231 & 0.9474312 & 0.07812173\\\\\n", "\tAcre & uf & Acre & 2013 & S016P & 0.8547101 & 0.7709839 & 0.9384364 & 0.04997984\\\\\n", "\tAmazonas & uf & Amazonas & 2013 & S016P & 0.8667892 & 0.7943296 & 0.9392488 & 0.04265152\\\\\n", "\tRoraima & uf & Roraima & 2013 & S016P & 0.9792703 & 0.9537907 & 1.0047498 & 0.01327522\\\\\n", "\tPará & uf & Pará & 2013 & S016P & 0.8405336 & 0.7421185 & 0.9389486 & 0.05973905\\\\\n", "\tAmapá & uf & Amapá & 2013 & S016P & 0.9306654 & 0.8575116 & 1.0038191 & 0.04010467\\\\\n", "\tTocantins & uf & Tocantins & 2013 & S016P & 0.8782034 & 0.7739205 & 0.9824863 & 0.06058569\\\\\n", "\tMaranhão & uf & Maranhão & 2013 & S016P & 0.7835474 & 0.6336436 & 0.9334513 & 0.09761116\\\\\n", "\tPiauí & uf & Piauí & 2013 & S016P & 0.7036185 & 0.5706709 & 0.8365661 & 0.09640404\\\\\n", "\tCeará & uf & Ceará & 2013 & S016P & 0.8562209 & 0.7668826 & 0.9455592 & 0.05323580\\\\\n", "\tRio Grande do Norte & uf & Rio Grande do Norte & 2013 & S016P & 0.9159877 & 0.8350790 & 0.9968963 & 0.04506687\\\\\n", "\tParaíba & uf & Paraíba & 2013 & S016P & 0.7759216 & 0.6315260 & 0.9203172 & 0.09494847\\\\\n", "\tPernambuco & uf & Pernambuco & 2013 & S016P & 0.8833022 & 0.8007748 & 0.9658296 & 0.04766951\\\\\n", "\tAlagoas & uf & Alagoas & 2013 & S016P & 0.7363261 & 0.5952972 & 0.8773550 & 0.09772144\\\\\n", "\tSergipe & uf & Sergipe & 2013 & S016P & 0.8148058 & 0.6825271 & 0.9470844 & 0.08282999\\\\\n", "\tBahia & uf & Bahia & 2013 & S016P & 0.7835843 & 0.6602149 & 0.9069537 & 0.08032921\\\\\n", "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n", "\tRio Branco2 & capital & Rio Branco & 2013 & S019P & 0.8599841 & 0.7411321 & 0.9788361 & 0.07051280\\\\\n", "\tManaus2 & capital & Manaus & 2013 & S019P & 0.8836420 & 0.7830294 & 0.9842546 & 0.05809353\\\\\n", "\tBoa Vista2 & capital & Boa Vista & 2013 & S019P & 0.8387671 & 0.7356097 & 0.9419244 & 0.06274957\\\\\n", "\tBelém2 & capital & Belém & 2013 & S019P & 0.9220037 & 0.7770735 & 1.0669340 & 0.08020074\\\\\n", "\tMacapá2 & capital & Macapá & 2013 & S019P & 0.8618015 & 0.7406060 & 0.9829969 & 0.07175152\\\\\n", "\tPalmas2 & capital & Palmas & 2013 & S019P & 0.9755986 & 0.9282984 & 1.0228988 & 0.02473681\\\\\n", "\tSão Luís2 & capital & São Luís & 2013 & S019P & 0.9581722 & 0.9012539 & 1.0150905 & 0.03030823\\\\\n", "\tTeresina2 & capital & Teresina & 2013 & S019P & 0.8194882 & 0.6143240 & 1.0246524 & 0.12773525\\\\\n", "\tFortaleza2 & capital & Fortaleza & 2013 & S019P & 0.8828775 & 0.7011140 & 1.0646411 & 0.10504088\\\\\n", "\tNatal2 & capital & Natal & 2013 & S019P & 1.0000000 & 1.0000000 & 1.0000000 & 0.00000000\\\\\n", "\tJoão Pessoa2 & capital & João Pessoa & 2013 & S019P & 0.9526422 & 0.8914418 & 1.0138427 & 0.03277755\\\\\n", "\tRecife2 & capital & Recife & 2013 & S019P & 0.9312556 & 0.7991790 & 1.0633323 & 0.07236175\\\\\n", "\tMaceió2 & capital & Maceió & 2013 & S019P & 0.6667696 & 0.4682348 & 0.8653045 & 0.15191926\\\\\n", "\tAracaju2 & capital & Aracaju & 2013 & S019P & 1.0000000 & 1.0000000 & 1.0000000 & 0.00000000\\\\\n", "\tSalvador2 & capital & Salvador & 2013 & S019P & 0.9061513 & 0.8027874 & 1.0095153 & 0.05819962\\\\\n", "\tBelo Horizonte2 & capital & Belo Horizonte & 2013 & S019P & 0.8589035 & 0.7194189 & 0.9983881 & 0.08285789\\\\\n", "\tVitória2 & capital & Vitória & 2013 & S019P & 0.9504570 & 0.8525153 & 1.0483988 & 0.05257597\\\\\n", "\tRio de Janeiro5 & capital & Rio de Janeiro & 2013 & S019P & 0.8942121 & 0.7758989 & 1.0125253 & 0.06750635\\\\\n", "\tSão Paulo4 & capital & São Paulo & 2013 & S019P & 0.9311288 & 0.8760755 & 0.9861821 & 0.03016655\\\\\n", "\tCuritiba2 & capital & Curitiba & 2013 & S019P & 0.9580169 & 0.8800529 & 1.0359810 & 0.04152151\\\\\n", "\tFlorianópolis2 & capital & Florianópolis & 2013 & S019P & 0.8589080 & 0.7491412 & 0.9686748 & 0.06520431\\\\\n", "\tPorto Alegre2 & capital & Porto Alegre & 2013 & S019P & 0.9624795 & 0.8887895 & 1.0361696 & 0.03906333\\\\\n", "\tCampo Grande2 & capital & Campo Grande & 2013 & S019P & 0.9676684 & 0.9068128 & 1.0285241 & 0.03208679\\\\\n", "\tCuiabá2 & capital & Cuiabá & 2013 & S019P & 0.9668783 & 0.9086181 & 1.0251384 & 0.03074339\\\\\n", "\tGoiânia2 & capital & Goiânia & 2013 & S019P & 0.9806624 & 0.9421503 & 1.0191746 & 0.02003687\\\\\n", "\tBrasília2 & capital & Brasília & 2013 & S019P & 0.9428326 & 0.8654071 & 1.0202581 & 0.04189879\\\\\n", "\tFundamental incompleto ou equivalente2 & gescol & Fundamental incompleto ou equivalente & 2013 & S019P & 0.7628161 & 0.6988318 & 0.8268003 & 0.04279619\\\\\n", "\tMédio incompleto ou equivalente2 & gescol & Médio incompleto ou equivalente & 2013 & S019P & 0.8941055 & 0.8442370 & 0.9439740 & 0.02845703\\\\\n", "\tSuperior incompleto ou equivalente2 & gescol & Superior incompleto ou equivalente & 2013 & S019P & 0.9054178 & 0.8755653 & 0.9352703 & 0.01682225\\\\\n", "\tSuperior completo2 & gescol & Superior completo & 2013 & S019P & 0.9621193 & 0.9268137 & 0.9974248 & 0.01872258\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 231 × 8\n", "\n", "| | abr_tipo <chr> | abr_nome <fct> | Ano <chr> | Indicador <chr> | Sim <dbl> | LowerS <dbl> | UpperS <dbl> | cvS <dbl> |\n", "|---|---|---|---|---|---|---|---|---|\n", "| Branca | raça | Branca | 2013 | S016P | 0.8704893 | 0.8277014 | 0.9132772 | 0.02507897 |\n", "| Preta | raça | Preta | 2013 | S016P | 0.7824306 | 0.6572729 | 0.9075882 | 0.08161378 |\n", "| Parda | raça | Parda | 2013 | S016P | 0.8461478 | 0.8097939 | 0.8825018 | 0.02192086 |\n", "| Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2013 | S016P | 0.8285370 | 0.7918252 | 0.8652487 | 0.02260709 |\n", "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2013 | S016P | 0.8885054 | 0.8429841 | 0.9340267 | 0.02614005 |\n", "| 1 até 2 SM | rend_per_capita | 1 até 2 SM | 2013 | S016P | 0.8426610 | 0.7640768 | 0.9212453 | 0.04758111 |\n", "| 2 até 3 SM | rend_per_capita | 2 até 3 SM | 2013 | S016P | 0.7988503 | 0.5851066 | 1.0125940 | 0.13651485 |\n", "| Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2013 | S016P | 0.8862241 | 0.7959129 | 0.9765354 | 0.05199364 |\n", "| 18 a 24 anos | fx_idade_s | 18 a 24 anos | 2013 | S016P | 0.8528084 | 0.8058320 | 0.8997849 | 0.02810482 |\n", "| 25 a 29 anos | fx_idade_s | 25 a 29 anos | 2013 | S016P | 0.8262557 | 0.7729942 | 0.8795172 | 0.03288902 |\n", "| 30 a 39 anos | fx_idade_s | 30 a 39 anos | 2013 | S016P | 0.8660926 | 0.8172904 | 0.9148948 | 0.02874925 |\n", "| 40 anos ou mais | fx_idade_s | 40 anos ou mais | 2013 | S016P | 0.8486411 | 0.7445249 | 0.9527572 | 0.06259593 |\n", "| urbano | urb_rur | urbano | 2013 | S016P | 0.8666800 | 0.8371479 | 0.8962121 | 0.01738551 |\n", "| rural | urb_rur | rural | 2013 | S016P | 0.7675523 | 0.6959295 | 0.8391751 | 0.04760970 |\n", "| Rondônia | uf | Rondônia | 2013 | S016P | 0.8216271 | 0.6958231 | 0.9474312 | 0.07812173 |\n", "| Acre | uf | Acre | 2013 | S016P | 0.8547101 | 0.7709839 | 0.9384364 | 0.04997984 |\n", "| Amazonas | uf | Amazonas | 2013 | S016P | 0.8667892 | 0.7943296 | 0.9392488 | 0.04265152 |\n", "| Roraima | uf | Roraima | 2013 | S016P | 0.9792703 | 0.9537907 | 1.0047498 | 0.01327522 |\n", "| Pará | uf | Pará | 2013 | S016P | 0.8405336 | 0.7421185 | 0.9389486 | 0.05973905 |\n", "| Amapá | uf | Amapá | 2013 | S016P | 0.9306654 | 0.8575116 | 1.0038191 | 0.04010467 |\n", "| Tocantins | uf | Tocantins | 2013 | S016P | 0.8782034 | 0.7739205 | 0.9824863 | 0.06058569 |\n", "| Maranhão | uf | Maranhão | 2013 | S016P | 0.7835474 | 0.6336436 | 0.9334513 | 0.09761116 |\n", "| Piauí | uf | Piauí | 2013 | S016P | 0.7036185 | 0.5706709 | 0.8365661 | 0.09640404 |\n", "| Ceará | uf | Ceará | 2013 | S016P | 0.8562209 | 0.7668826 | 0.9455592 | 0.05323580 |\n", "| Rio Grande do Norte | uf | Rio Grande do Norte | 2013 | S016P | 0.9159877 | 0.8350790 | 0.9968963 | 0.04506687 |\n", "| Paraíba | uf | Paraíba | 2013 | S016P | 0.7759216 | 0.6315260 | 0.9203172 | 0.09494847 |\n", "| Pernambuco | uf | Pernambuco | 2013 | S016P | 0.8833022 | 0.8007748 | 0.9658296 | 0.04766951 |\n", "| Alagoas | uf | Alagoas | 2013 | S016P | 0.7363261 | 0.5952972 | 0.8773550 | 0.09772144 |\n", "| Sergipe | uf | Sergipe | 2013 | S016P | 0.8148058 | 0.6825271 | 0.9470844 | 0.08282999 |\n", "| Bahia | uf | Bahia | 2013 | S016P | 0.7835843 | 0.6602149 | 0.9069537 | 0.08032921 |\n", "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n", "| Rio Branco2 | capital | Rio Branco | 2013 | S019P | 0.8599841 | 0.7411321 | 0.9788361 | 0.07051280 |\n", "| Manaus2 | capital | Manaus | 2013 | S019P | 0.8836420 | 0.7830294 | 0.9842546 | 0.05809353 |\n", "| Boa Vista2 | capital | Boa Vista | 2013 | S019P | 0.8387671 | 0.7356097 | 0.9419244 | 0.06274957 |\n", "| Belém2 | capital | Belém | 2013 | S019P | 0.9220037 | 0.7770735 | 1.0669340 | 0.08020074 |\n", "| Macapá2 | capital | Macapá | 2013 | S019P | 0.8618015 | 0.7406060 | 0.9829969 | 0.07175152 |\n", "| Palmas2 | capital | Palmas | 2013 | S019P | 0.9755986 | 0.9282984 | 1.0228988 | 0.02473681 |\n", "| São Luís2 | capital | São Luís | 2013 | S019P | 0.9581722 | 0.9012539 | 1.0150905 | 0.03030823 |\n", "| Teresina2 | capital | Teresina | 2013 | S019P | 0.8194882 | 0.6143240 | 1.0246524 | 0.12773525 |\n", "| Fortaleza2 | capital | Fortaleza | 2013 | S019P | 0.8828775 | 0.7011140 | 1.0646411 | 0.10504088 |\n", "| Natal2 | capital | Natal | 2013 | S019P | 1.0000000 | 1.0000000 | 1.0000000 | 0.00000000 |\n", "| João Pessoa2 | capital | João Pessoa | 2013 | S019P | 0.9526422 | 0.8914418 | 1.0138427 | 0.03277755 |\n", "| Recife2 | capital | Recife | 2013 | S019P | 0.9312556 | 0.7991790 | 1.0633323 | 0.07236175 |\n", "| Maceió2 | capital | Maceió | 2013 | S019P | 0.6667696 | 0.4682348 | 0.8653045 | 0.15191926 |\n", "| Aracaju2 | capital | Aracaju | 2013 | S019P | 1.0000000 | 1.0000000 | 1.0000000 | 0.00000000 |\n", "| Salvador2 | capital | Salvador | 2013 | S019P | 0.9061513 | 0.8027874 | 1.0095153 | 0.05819962 |\n", "| Belo Horizonte2 | capital | Belo Horizonte | 2013 | S019P | 0.8589035 | 0.7194189 | 0.9983881 | 0.08285789 |\n", "| Vitória2 | capital | Vitória | 2013 | S019P | 0.9504570 | 0.8525153 | 1.0483988 | 0.05257597 |\n", "| Rio de Janeiro5 | capital | Rio de Janeiro | 2013 | S019P | 0.8942121 | 0.7758989 | 1.0125253 | 0.06750635 |\n", "| São Paulo4 | capital | São Paulo | 2013 | S019P | 0.9311288 | 0.8760755 | 0.9861821 | 0.03016655 |\n", "| Curitiba2 | capital | Curitiba | 2013 | S019P | 0.9580169 | 0.8800529 | 1.0359810 | 0.04152151 |\n", "| Florianópolis2 | capital | Florianópolis | 2013 | S019P | 0.8589080 | 0.7491412 | 0.9686748 | 0.06520431 |\n", "| Porto Alegre2 | capital | Porto Alegre | 2013 | S019P | 0.9624795 | 0.8887895 | 1.0361696 | 0.03906333 |\n", "| Campo Grande2 | capital | Campo Grande | 2013 | S019P | 0.9676684 | 0.9068128 | 1.0285241 | 0.03208679 |\n", "| Cuiabá2 | capital | Cuiabá | 2013 | S019P | 0.9668783 | 0.9086181 | 1.0251384 | 0.03074339 |\n", "| Goiânia2 | capital | Goiânia | 2013 | S019P | 0.9806624 | 0.9421503 | 1.0191746 | 0.02003687 |\n", "| Brasília2 | capital | Brasília | 2013 | S019P | 0.9428326 | 0.8654071 | 1.0202581 | 0.04189879 |\n", "| Fundamental incompleto ou equivalente2 | gescol | Fundamental incompleto ou equivalente | 2013 | S019P | 0.7628161 | 0.6988318 | 0.8268003 | 0.04279619 |\n", "| Médio incompleto ou equivalente2 | gescol | Médio incompleto ou equivalente | 2013 | S019P | 0.8941055 | 0.8442370 | 0.9439740 | 0.02845703 |\n", "| Superior incompleto ou equivalente2 | gescol | Superior incompleto ou equivalente | 2013 | S019P | 0.9054178 | 0.8755653 | 0.9352703 | 0.01682225 |\n", "| Superior completo2 | gescol | Superior completo | 2013 | S019P | 0.9621193 | 0.9268137 | 0.9974248 | 0.01872258 |\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", "Rio Branco2 capital \n", "Manaus2 capital \n", "Boa Vista2 capital \n", "Belém2 capital \n", "Macapá2 capital \n", "Palmas2 capital \n", "São Luís2 capital \n", "Teresina2 capital \n", "Fortaleza2 capital \n", "Natal2 capital \n", "João Pessoa2 capital \n", "Recife2 capital \n", "Maceió2 capital \n", "Aracaju2 capital \n", "Salvador2 capital \n", "Belo Horizonte2 capital \n", "Vitória2 capital \n", "Rio de Janeiro5 capital \n", "São Paulo4 capital \n", "Curitiba2 capital \n", "Florianópolis2 capital \n", "Porto Alegre2 capital \n", "Campo Grande2 capital \n", "Cuiabá2 capital \n", "Goiânia2 capital \n", "Brasília2 capital \n", "Fundamental incompleto ou equivalente2 gescol \n", "Médio incompleto ou equivalente2 gescol \n", "Superior incompleto ou equivalente2 gescol \n", "Superior completo2 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", "Rio Branco2 Rio Branco \n", "Manaus2 Manaus \n", "Boa Vista2 Boa Vista \n", "Belém2 Belém \n", "Macapá2 Macapá \n", "Palmas2 Palmas \n", "São Luís2 São Luís \n", "Teresina2 Teresina \n", "Fortaleza2 Fortaleza \n", "Natal2 Natal \n", "João Pessoa2 João Pessoa \n", "Recife2 Recife \n", "Maceió2 Maceió \n", "Aracaju2 Aracaju \n", "Salvador2 Salvador \n", "Belo Horizonte2 Belo Horizonte \n", "Vitória2 Vitória \n", "Rio de Janeiro5 Rio de Janeiro \n", "São Paulo4 São Paulo \n", "Curitiba2 Curitiba \n", "Florianópolis2 Florianópolis \n", "Porto Alegre2 Porto Alegre \n", "Campo Grande2 Campo Grande \n", "Cuiabá2 Cuiabá \n", "Goiânia2 Goiânia \n", "Brasília2 Brasília \n", "Fundamental incompleto ou equivalente2 Fundamental incompleto ou equivalente\n", "Médio incompleto ou equivalente2 Médio incompleto ou equivalente \n", "Superior incompleto ou equivalente2 Superior incompleto ou equivalente \n", "Superior completo2 Superior completo \n", " Ano Indicador Sim LowerS \n", "Branca 2013 S016P 0.8704893 0.8277014\n", "Preta 2013 S016P 0.7824306 0.6572729\n", "Parda 2013 S016P 0.8461478 0.8097939\n", "Até 1/2 SM 2013 S016P 0.8285370 0.7918252\n", "1/2 até 1 SM 2013 S016P 0.8885054 0.8429841\n", "1 até 2 SM 2013 S016P 0.8426610 0.7640768\n", "2 até 3 SM 2013 S016P 0.7988503 0.5851066\n", "Mais de 3 SM 2013 S016P 0.8862241 0.7959129\n", "18 a 24 anos 2013 S016P 0.8528084 0.8058320\n", "25 a 29 anos 2013 S016P 0.8262557 0.7729942\n", "30 a 39 anos 2013 S016P 0.8660926 0.8172904\n", "40 anos ou mais 2013 S016P 0.8486411 0.7445249\n", "urbano 2013 S016P 0.8666800 0.8371479\n", "rural 2013 S016P 0.7675523 0.6959295\n", "Rondônia 2013 S016P 0.8216271 0.6958231\n", "Acre 2013 S016P 0.8547101 0.7709839\n", "Amazonas 2013 S016P 0.8667892 0.7943296\n", "Roraima 2013 S016P 0.9792703 0.9537907\n", "Pará 2013 S016P 0.8405336 0.7421185\n", "Amapá 2013 S016P 0.9306654 0.8575116\n", "Tocantins 2013 S016P 0.8782034 0.7739205\n", "Maranhão 2013 S016P 0.7835474 0.6336436\n", "Piauí 2013 S016P 0.7036185 0.5706709\n", "Ceará 2013 S016P 0.8562209 0.7668826\n", "Rio Grande do Norte 2013 S016P 0.9159877 0.8350790\n", "Paraíba 2013 S016P 0.7759216 0.6315260\n", "Pernambuco 2013 S016P 0.8833022 0.8007748\n", "Alagoas 2013 S016P 0.7363261 0.5952972\n", "Sergipe 2013 S016P 0.8148058 0.6825271\n", "Bahia 2013 S016P 0.7835843 0.6602149\n", "⋮ ⋮ ⋮ ⋮ ⋮ \n", "Rio Branco2 2013 S019P 0.8599841 0.7411321\n", "Manaus2 2013 S019P 0.8836420 0.7830294\n", "Boa Vista2 2013 S019P 0.8387671 0.7356097\n", "Belém2 2013 S019P 0.9220037 0.7770735\n", "Macapá2 2013 S019P 0.8618015 0.7406060\n", "Palmas2 2013 S019P 0.9755986 0.9282984\n", "São Luís2 2013 S019P 0.9581722 0.9012539\n", "Teresina2 2013 S019P 0.8194882 0.6143240\n", "Fortaleza2 2013 S019P 0.8828775 0.7011140\n", "Natal2 2013 S019P 1.0000000 1.0000000\n", "João Pessoa2 2013 S019P 0.9526422 0.8914418\n", "Recife2 2013 S019P 0.9312556 0.7991790\n", "Maceió2 2013 S019P 0.6667696 0.4682348\n", "Aracaju2 2013 S019P 1.0000000 1.0000000\n", "Salvador2 2013 S019P 0.9061513 0.8027874\n", "Belo Horizonte2 2013 S019P 0.8589035 0.7194189\n", "Vitória2 2013 S019P 0.9504570 0.8525153\n", "Rio de Janeiro5 2013 S019P 0.8942121 0.7758989\n", "São Paulo4 2013 S019P 0.9311288 0.8760755\n", "Curitiba2 2013 S019P 0.9580169 0.8800529\n", "Florianópolis2 2013 S019P 0.8589080 0.7491412\n", "Porto Alegre2 2013 S019P 0.9624795 0.8887895\n", "Campo Grande2 2013 S019P 0.9676684 0.9068128\n", "Cuiabá2 2013 S019P 0.9668783 0.9086181\n", "Goiânia2 2013 S019P 0.9806624 0.9421503\n", "Brasília2 2013 S019P 0.9428326 0.8654071\n", "Fundamental incompleto ou equivalente2 2013 S019P 0.7628161 0.6988318\n", "Médio incompleto ou equivalente2 2013 S019P 0.8941055 0.8442370\n", "Superior incompleto ou equivalente2 2013 S019P 0.9054178 0.8755653\n", "Superior completo2 2013 S019P 0.9621193 0.9268137\n", " UpperS cvS \n", "Branca 0.9132772 0.02507897\n", "Preta 0.9075882 0.08161378\n", "Parda 0.8825018 0.02192086\n", "Até 1/2 SM 0.8652487 0.02260709\n", "1/2 até 1 SM 0.9340267 0.02614005\n", "1 até 2 SM 0.9212453 0.04758111\n", "2 até 3 SM 1.0125940 0.13651485\n", "Mais de 3 SM 0.9765354 0.05199364\n", "18 a 24 anos 0.8997849 0.02810482\n", "25 a 29 anos 0.8795172 0.03288902\n", "30 a 39 anos 0.9148948 0.02874925\n", "40 anos ou mais 0.9527572 0.06259593\n", "urbano 0.8962121 0.01738551\n", "rural 0.8391751 0.04760970\n", "Rondônia 0.9474312 0.07812173\n", "Acre 0.9384364 0.04997984\n", "Amazonas 0.9392488 0.04265152\n", "Roraima 1.0047498 0.01327522\n", "Pará 0.9389486 0.05973905\n", "Amapá 1.0038191 0.04010467\n", "Tocantins 0.9824863 0.06058569\n", "Maranhão 0.9334513 0.09761116\n", "Piauí 0.8365661 0.09640404\n", "Ceará 0.9455592 0.05323580\n", "Rio Grande do Norte 0.9968963 0.04506687\n", "Paraíba 0.9203172 0.09494847\n", "Pernambuco 0.9658296 0.04766951\n", "Alagoas 0.8773550 0.09772144\n", "Sergipe 0.9470844 0.08282999\n", "Bahia 0.9069537 0.08032921\n", "⋮ ⋮ ⋮ \n", "Rio Branco2 0.9788361 0.07051280\n", "Manaus2 0.9842546 0.05809353\n", "Boa Vista2 0.9419244 0.06274957\n", "Belém2 1.0669340 0.08020074\n", "Macapá2 0.9829969 0.07175152\n", "Palmas2 1.0228988 0.02473681\n", "São Luís2 1.0150905 0.03030823\n", "Teresina2 1.0246524 0.12773525\n", "Fortaleza2 1.0646411 0.10504088\n", "Natal2 1.0000000 0.00000000\n", "João Pessoa2 1.0138427 0.03277755\n", "Recife2 1.0633323 0.07236175\n", "Maceió2 0.8653045 0.15191926\n", "Aracaju2 1.0000000 0.00000000\n", "Salvador2 1.0095153 0.05819962\n", "Belo Horizonte2 0.9983881 0.08285789\n", "Vitória2 1.0483988 0.05257597\n", "Rio de Janeiro5 1.0125253 0.06750635\n", "São Paulo4 0.9861821 0.03016655\n", "Curitiba2 1.0359810 0.04152151\n", "Florianópolis2 0.9686748 0.06520431\n", "Porto Alegre2 1.0361696 0.03906333\n", "Campo Grande2 1.0285241 0.03208679\n", "Cuiabá2 1.0251384 0.03074339\n", "Goiânia2 1.0191746 0.02003687\n", "Brasília2 1.0202581 0.04189879\n", "Fundamental incompleto ou equivalente2 0.8268003 0.04279619\n", "Médio incompleto ou equivalente2 0.9439740 0.02845703\n", "Superior incompleto ou equivalente2 0.9352703 0.01682225\n", "Superior completo2 0.9974248 0.01872258" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "matriz_indicadores" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Preenchendo a tabela pela abrangência total" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [], "source": [ "matriz_totais <- popula_indicadores(design_por_abrangencia, totais, indicadores, Ano, \"total\")" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
A data.frame: 6 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><chr><chr><chr><dbl><dbl><dbl><dbl>
S016PSimtotalBrasil 2013S016P0.85093190.82344180.87842200.01648289
S016PSim1totalCapital2013S016P0.89477660.86218910.92736410.01858181
S018PSimtotalBrasil 2013S018P0.75140910.71846690.78435140.02236807
S018PSim1totalCapital2013S018P0.80499770.76894070.84105460.02285318
S019PSimtotalBrasil 2013S019P0.87638470.85261170.90015760.01384011
S019PSim1totalCapital2013S019P0.91661400.89073430.94249370.01440536
\n" ], "text/latex": [ "A data.frame: 6 × 8\n", "\\begin{tabular}{r|llllllll}\n", " & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n", " & & & & & & & & \\\\\n", "\\hline\n", "\tS016PSim & total & Brasil & 2013 & S016P & 0.8509319 & 0.8234418 & 0.8784220 & 0.01648289\\\\\n", "\tS016PSim1 & total & Capital & 2013 & S016P & 0.8947766 & 0.8621891 & 0.9273641 & 0.01858181\\\\\n", "\tS018PSim & total & Brasil & 2013 & S018P & 0.7514091 & 0.7184669 & 0.7843514 & 0.02236807\\\\\n", "\tS018PSim1 & total & Capital & 2013 & S018P & 0.8049977 & 0.7689407 & 0.8410546 & 0.02285318\\\\\n", "\tS019PSim & total & Brasil & 2013 & S019P & 0.8763847 & 0.8526117 & 0.9001576 & 0.01384011\\\\\n", "\tS019PSim1 & total & Capital & 2013 & S019P & 0.9166140 & 0.8907343 & 0.9424937 & 0.01440536\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 6 × 8\n", "\n", "| | abr_tipo <chr> | abr_nome <chr> | Ano <chr> | Indicador <chr> | Sim <dbl> | LowerS <dbl> | UpperS <dbl> | cvS <dbl> |\n", "|---|---|---|---|---|---|---|---|---|\n", "| S016PSim | total | Brasil | 2013 | S016P | 0.8509319 | 0.8234418 | 0.8784220 | 0.01648289 |\n", "| S016PSim1 | total | Capital | 2013 | S016P | 0.8947766 | 0.8621891 | 0.9273641 | 0.01858181 |\n", "| S018PSim | total | Brasil | 2013 | S018P | 0.7514091 | 0.7184669 | 0.7843514 | 0.02236807 |\n", "| S018PSim1 | total | Capital | 2013 | S018P | 0.8049977 | 0.7689407 | 0.8410546 | 0.02285318 |\n", "| S019PSim | total | Brasil | 2013 | S019P | 0.8763847 | 0.8526117 | 0.9001576 | 0.01384011 |\n", "| S019PSim1 | total | Capital | 2013 | S019P | 0.9166140 | 0.8907343 | 0.9424937 | 0.01440536 |\n", "\n" ], "text/plain": [ " abr_tipo abr_nome Ano Indicador Sim LowerS UpperS \n", "S016PSim total Brasil 2013 S016P 0.8509319 0.8234418 0.8784220\n", "S016PSim1 total Capital 2013 S016P 0.8947766 0.8621891 0.9273641\n", "S018PSim total Brasil 2013 S018P 0.7514091 0.7184669 0.7843514\n", "S018PSim1 total Capital 2013 S018P 0.8049977 0.7689407 0.8410546\n", "S019PSim total Brasil 2013 S019P 0.8763847 0.8526117 0.9001576\n", "S019PSim1 total Capital 2013 S019P 0.9166140 0.8907343 0.9424937\n", " cvS \n", "S016PSim 0.01648289\n", "S016PSim1 0.01858181\n", "S018PSim 0.02236807\n", "S018PSim1 0.02285318\n", "S019PSim 0.01384011\n", "S019PSim1 0.01440536" ] }, "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": 23, "metadata": {}, "outputs": [], "source": [ "matriz_final <-rbind(matriz_indicadores,matriz_totais)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Visualizando tabela de indicadores" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
A data.frame: 237 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><fct><chr><chr><dbl><dbl><dbl><dbl>
Brancaraça Branca 2013S016P0.87048930.82770140.91327720.02507897
Pretaraça Preta 2013S016P0.78243060.65727290.90758820.08161378
Pardaraça Parda 2013S016P0.84614780.80979390.88250180.02192086
Até 1/2 SMrend_per_capitaAté 1/2 SM 2013S016P0.82853700.79182520.86524870.02260709
1/2 até 1 SMrend_per_capita1/2 até 1 SM 2013S016P0.88850540.84298410.93402670.02614005
1 até 2 SMrend_per_capita1 até 2 SM 2013S016P0.84266100.76407680.92124530.04758111
2 até 3 SMrend_per_capita2 até 3 SM 2013S016P0.79885030.58510661.01259400.13651485
Mais de 3 SMrend_per_capitaMais de 3 SM 2013S016P0.88622410.79591290.97653540.05199364
18 a 24 anosfx_idade_s 18 a 24 anos 2013S016P0.85280840.80583200.89978490.02810482
25 a 29 anosfx_idade_s 25 a 29 anos 2013S016P0.82625570.77299420.87951720.03288902
30 a 39 anosfx_idade_s 30 a 39 anos 2013S016P0.86609260.81729040.91489480.02874925
40 anos ou maisfx_idade_s 40 anos ou mais 2013S016P0.84864110.74452490.95275720.06259593
urbanourb_rur urbano 2013S016P0.86668000.83714790.89621210.01738551
ruralurb_rur rural 2013S016P0.76755230.69592950.83917510.04760970
Rondôniauf Rondônia 2013S016P0.82162710.69582310.94743120.07812173
Acreuf Acre 2013S016P0.85471010.77098390.93843640.04997984
Amazonasuf Amazonas 2013S016P0.86678920.79432960.93924880.04265152
Roraimauf Roraima 2013S016P0.97927030.95379071.00474980.01327522
Paráuf Pará 2013S016P0.84053360.74211850.93894860.05973905
Amapáuf Amapá 2013S016P0.93066540.85751161.00381910.04010467
Tocantinsuf Tocantins 2013S016P0.87820340.77392050.98248630.06058569
Maranhãouf Maranhão 2013S016P0.78354740.63364360.93345130.09761116
Piauíuf Piauí 2013S016P0.70361850.57067090.83656610.09640404
Cearáuf Ceará 2013S016P0.85622090.76688260.94555920.05323580
Rio Grande do Norteuf Rio Grande do Norte2013S016P0.91598770.83507900.99689630.04506687
Paraíbauf Paraíba 2013S016P0.77592160.63152600.92031720.09494847
Pernambucouf Pernambuco 2013S016P0.88330220.80077480.96582960.04766951
Alagoasuf Alagoas 2013S016P0.73632610.59529720.87735500.09772144
Sergipeuf Sergipe 2013S016P0.81480580.68252710.94708440.08282999
Bahiauf Bahia 2013S016P0.78358430.66021490.90695370.08032921
⋮⋮⋮⋮⋮⋮⋮⋮⋮
São Luís2capitalSão Luís 2013S019P0.95817220.90125391.01509050.03030823
Teresina2capitalTeresina 2013S019P0.81948820.61432401.02465240.12773525
Fortaleza2capitalFortaleza 2013S019P0.88287750.70111401.06464110.10504088
Natal2capitalNatal 2013S019P1.00000001.00000001.00000000.00000000
João Pessoa2capitalJoão Pessoa 2013S019P0.95264220.89144181.01384270.03277755
Recife2capitalRecife 2013S019P0.93125560.79917901.06333230.07236175
Maceió2capitalMaceió 2013S019P0.66676960.46823480.86530450.15191926
Aracaju2capitalAracaju 2013S019P1.00000001.00000001.00000000.00000000
Salvador2capitalSalvador 2013S019P0.90615130.80278741.00951530.05819962
Belo Horizonte2capitalBelo Horizonte 2013S019P0.85890350.71941890.99838810.08285789
Vitória2capitalVitória 2013S019P0.95045700.85251531.04839880.05257597
Rio de Janeiro5capitalRio de Janeiro 2013S019P0.89421210.77589891.01252530.06750635
São Paulo4capitalSão Paulo 2013S019P0.93112880.87607550.98618210.03016655
Curitiba2capitalCuritiba 2013S019P0.95801690.88005291.03598100.04152151
Florianópolis2capitalFlorianópolis 2013S019P0.85890800.74914120.96867480.06520431
Porto Alegre2capitalPorto Alegre 2013S019P0.96247950.88878951.03616960.03906333
Campo Grande2capitalCampo Grande 2013S019P0.96766840.90681281.02852410.03208679
Cuiabá2capitalCuiabá 2013S019P0.96687830.90861811.02513840.03074339
Goiânia2capitalGoiânia 2013S019P0.98066240.94215031.01917460.02003687
Brasília2capitalBrasília 2013S019P0.94283260.86540711.02025810.04189879
Fundamental incompleto ou equivalente2gescol Fundamental incompleto ou equivalente2013S019P0.76281610.69883180.82680030.04279619
Médio incompleto ou equivalente2gescol Médio incompleto ou equivalente 2013S019P0.89410550.84423700.94397400.02845703
Superior incompleto ou equivalente2gescol Superior incompleto ou equivalente 2013S019P0.90541780.87556530.93527030.01682225
Superior completo2gescol Superior completo 2013S019P0.96211930.92681370.99742480.01872258
S016PSimtotal Brasil 2013S016P0.85093190.82344180.87842200.01648289
S016PSim1total Capital 2013S016P0.89477660.86218910.92736410.01858181
S018PSimtotal Brasil 2013S018P0.75140910.71846690.78435140.02236807
S018PSim1total Capital 2013S018P0.80499770.76894070.84105460.02285318
S019PSimtotal Brasil 2013S019P0.87638470.85261170.90015760.01384011
S019PSim1total Capital 2013S019P0.91661400.89073430.94249370.01440536
\n" ], "text/latex": [ "A data.frame: 237 × 8\n", "\\begin{tabular}{r|llllllll}\n", " & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n", " & & & & & & & & \\\\\n", "\\hline\n", "\tBranca & raça & Branca & 2013 & S016P & 0.8704893 & 0.8277014 & 0.9132772 & 0.02507897\\\\\n", "\tPreta & raça & Preta & 2013 & S016P & 0.7824306 & 0.6572729 & 0.9075882 & 0.08161378\\\\\n", "\tParda & raça & Parda & 2013 & S016P & 0.8461478 & 0.8097939 & 0.8825018 & 0.02192086\\\\\n", "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM & 2013 & S016P & 0.8285370 & 0.7918252 & 0.8652487 & 0.02260709\\\\\n", "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM & 2013 & S016P & 0.8885054 & 0.8429841 & 0.9340267 & 0.02614005\\\\\n", "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM & 2013 & S016P & 0.8426610 & 0.7640768 & 0.9212453 & 0.04758111\\\\\n", "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM & 2013 & S016P & 0.7988503 & 0.5851066 & 1.0125940 & 0.13651485\\\\\n", "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM & 2013 & S016P & 0.8862241 & 0.7959129 & 0.9765354 & 0.05199364\\\\\n", "\t18 a 24 anos & fx\\_idade\\_s & 18 a 24 anos & 2013 & S016P & 0.8528084 & 0.8058320 & 0.8997849 & 0.02810482\\\\\n", "\t25 a 29 anos & fx\\_idade\\_s & 25 a 29 anos & 2013 & S016P & 0.8262557 & 0.7729942 & 0.8795172 & 0.03288902\\\\\n", "\t30 a 39 anos & fx\\_idade\\_s & 30 a 39 anos & 2013 & S016P & 0.8660926 & 0.8172904 & 0.9148948 & 0.02874925\\\\\n", "\t40 anos ou mais & fx\\_idade\\_s & 40 anos ou mais & 2013 & S016P & 0.8486411 & 0.7445249 & 0.9527572 & 0.06259593\\\\\n", "\turbano & urb\\_rur & urbano & 2013 & S016P & 0.8666800 & 0.8371479 & 0.8962121 & 0.01738551\\\\\n", "\trural & urb\\_rur & rural & 2013 & S016P & 0.7675523 & 0.6959295 & 0.8391751 & 0.04760970\\\\\n", "\tRondônia & uf & Rondônia & 2013 & S016P & 0.8216271 & 0.6958231 & 0.9474312 & 0.07812173\\\\\n", "\tAcre & uf & Acre & 2013 & S016P & 0.8547101 & 0.7709839 & 0.9384364 & 0.04997984\\\\\n", "\tAmazonas & uf & Amazonas & 2013 & S016P & 0.8667892 & 0.7943296 & 0.9392488 & 0.04265152\\\\\n", "\tRoraima & uf & Roraima & 2013 & S016P & 0.9792703 & 0.9537907 & 1.0047498 & 0.01327522\\\\\n", "\tPará & uf & Pará & 2013 & S016P & 0.8405336 & 0.7421185 & 0.9389486 & 0.05973905\\\\\n", "\tAmapá & uf & Amapá & 2013 & S016P & 0.9306654 & 0.8575116 & 1.0038191 & 0.04010467\\\\\n", "\tTocantins & uf & Tocantins & 2013 & S016P & 0.8782034 & 0.7739205 & 0.9824863 & 0.06058569\\\\\n", "\tMaranhão & uf & Maranhão & 2013 & S016P & 0.7835474 & 0.6336436 & 0.9334513 & 0.09761116\\\\\n", "\tPiauí & uf & Piauí & 2013 & S016P & 0.7036185 & 0.5706709 & 0.8365661 & 0.09640404\\\\\n", "\tCeará & uf & Ceará & 2013 & S016P & 0.8562209 & 0.7668826 & 0.9455592 & 0.05323580\\\\\n", "\tRio Grande do Norte & uf & Rio Grande do Norte & 2013 & S016P & 0.9159877 & 0.8350790 & 0.9968963 & 0.04506687\\\\\n", "\tParaíba & uf & Paraíba & 2013 & S016P & 0.7759216 & 0.6315260 & 0.9203172 & 0.09494847\\\\\n", "\tPernambuco & uf & Pernambuco & 2013 & S016P & 0.8833022 & 0.8007748 & 0.9658296 & 0.04766951\\\\\n", "\tAlagoas & uf & Alagoas & 2013 & S016P & 0.7363261 & 0.5952972 & 0.8773550 & 0.09772144\\\\\n", "\tSergipe & uf & Sergipe & 2013 & S016P & 0.8148058 & 0.6825271 & 0.9470844 & 0.08282999\\\\\n", "\tBahia & uf & Bahia & 2013 & S016P & 0.7835843 & 0.6602149 & 0.9069537 & 0.08032921\\\\\n", "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n", "\tSão Luís2 & capital & São Luís & 2013 & S019P & 0.9581722 & 0.9012539 & 1.0150905 & 0.03030823\\\\\n", "\tTeresina2 & capital & Teresina & 2013 & S019P & 0.8194882 & 0.6143240 & 1.0246524 & 0.12773525\\\\\n", "\tFortaleza2 & capital & Fortaleza & 2013 & S019P & 0.8828775 & 0.7011140 & 1.0646411 & 0.10504088\\\\\n", "\tNatal2 & capital & Natal & 2013 & S019P & 1.0000000 & 1.0000000 & 1.0000000 & 0.00000000\\\\\n", "\tJoão Pessoa2 & capital & João Pessoa & 2013 & S019P & 0.9526422 & 0.8914418 & 1.0138427 & 0.03277755\\\\\n", "\tRecife2 & capital & Recife & 2013 & S019P & 0.9312556 & 0.7991790 & 1.0633323 & 0.07236175\\\\\n", "\tMaceió2 & capital & Maceió & 2013 & S019P & 0.6667696 & 0.4682348 & 0.8653045 & 0.15191926\\\\\n", "\tAracaju2 & capital & Aracaju & 2013 & S019P & 1.0000000 & 1.0000000 & 1.0000000 & 0.00000000\\\\\n", "\tSalvador2 & capital & Salvador & 2013 & S019P & 0.9061513 & 0.8027874 & 1.0095153 & 0.05819962\\\\\n", "\tBelo Horizonte2 & capital & Belo Horizonte & 2013 & S019P & 0.8589035 & 0.7194189 & 0.9983881 & 0.08285789\\\\\n", "\tVitória2 & capital & Vitória & 2013 & S019P & 0.9504570 & 0.8525153 & 1.0483988 & 0.05257597\\\\\n", "\tRio de Janeiro5 & capital & Rio de Janeiro & 2013 & S019P & 0.8942121 & 0.7758989 & 1.0125253 & 0.06750635\\\\\n", "\tSão Paulo4 & capital & São Paulo & 2013 & S019P & 0.9311288 & 0.8760755 & 0.9861821 & 0.03016655\\\\\n", "\tCuritiba2 & capital & Curitiba & 2013 & S019P & 0.9580169 & 0.8800529 & 1.0359810 & 0.04152151\\\\\n", "\tFlorianópolis2 & capital & Florianópolis & 2013 & S019P & 0.8589080 & 0.7491412 & 0.9686748 & 0.06520431\\\\\n", "\tPorto Alegre2 & capital & Porto Alegre & 2013 & S019P & 0.9624795 & 0.8887895 & 1.0361696 & 0.03906333\\\\\n", "\tCampo Grande2 & capital & Campo Grande & 2013 & S019P & 0.9676684 & 0.9068128 & 1.0285241 & 0.03208679\\\\\n", "\tCuiabá2 & capital & Cuiabá & 2013 & S019P & 0.9668783 & 0.9086181 & 1.0251384 & 0.03074339\\\\\n", "\tGoiânia2 & capital & Goiânia & 2013 & S019P & 0.9806624 & 0.9421503 & 1.0191746 & 0.02003687\\\\\n", "\tBrasília2 & capital & Brasília & 2013 & S019P & 0.9428326 & 0.8654071 & 1.0202581 & 0.04189879\\\\\n", "\tFundamental incompleto ou equivalente2 & gescol & Fundamental incompleto ou equivalente & 2013 & S019P & 0.7628161 & 0.6988318 & 0.8268003 & 0.04279619\\\\\n", "\tMédio incompleto ou equivalente2 & gescol & Médio incompleto ou equivalente & 2013 & S019P & 0.8941055 & 0.8442370 & 0.9439740 & 0.02845703\\\\\n", "\tSuperior incompleto ou equivalente2 & gescol & Superior incompleto ou equivalente & 2013 & S019P & 0.9054178 & 0.8755653 & 0.9352703 & 0.01682225\\\\\n", "\tSuperior completo2 & gescol & Superior completo & 2013 & S019P & 0.9621193 & 0.9268137 & 0.9974248 & 0.01872258\\\\\n", "\tS016PSim & total & Brasil & 2013 & S016P & 0.8509319 & 0.8234418 & 0.8784220 & 0.01648289\\\\\n", "\tS016PSim1 & total & Capital & 2013 & S016P & 0.8947766 & 0.8621891 & 0.9273641 & 0.01858181\\\\\n", "\tS018PSim & total & Brasil & 2013 & S018P & 0.7514091 & 0.7184669 & 0.7843514 & 0.02236807\\\\\n", "\tS018PSim1 & total & Capital & 2013 & S018P & 0.8049977 & 0.7689407 & 0.8410546 & 0.02285318\\\\\n", "\tS019PSim & total & Brasil & 2013 & S019P & 0.8763847 & 0.8526117 & 0.9001576 & 0.01384011\\\\\n", "\tS019PSim1 & total & Capital & 2013 & S019P & 0.9166140 & 0.8907343 & 0.9424937 & 0.01440536\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 237 × 8\n", "\n", "| | abr_tipo <chr> | abr_nome <fct> | Ano <chr> | Indicador <chr> | Sim <dbl> | LowerS <dbl> | UpperS <dbl> | cvS <dbl> |\n", "|---|---|---|---|---|---|---|---|---|\n", "| Branca | raça | Branca | 2013 | S016P | 0.8704893 | 0.8277014 | 0.9132772 | 0.02507897 |\n", "| Preta | raça | Preta | 2013 | S016P | 0.7824306 | 0.6572729 | 0.9075882 | 0.08161378 |\n", "| Parda | raça | Parda | 2013 | S016P | 0.8461478 | 0.8097939 | 0.8825018 | 0.02192086 |\n", "| Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2013 | S016P | 0.8285370 | 0.7918252 | 0.8652487 | 0.02260709 |\n", "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2013 | S016P | 0.8885054 | 0.8429841 | 0.9340267 | 0.02614005 |\n", "| 1 até 2 SM | rend_per_capita | 1 até 2 SM | 2013 | S016P | 0.8426610 | 0.7640768 | 0.9212453 | 0.04758111 |\n", "| 2 até 3 SM | rend_per_capita | 2 até 3 SM | 2013 | S016P | 0.7988503 | 0.5851066 | 1.0125940 | 0.13651485 |\n", "| Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2013 | S016P | 0.8862241 | 0.7959129 | 0.9765354 | 0.05199364 |\n", "| 18 a 24 anos | fx_idade_s | 18 a 24 anos | 2013 | S016P | 0.8528084 | 0.8058320 | 0.8997849 | 0.02810482 |\n", "| 25 a 29 anos | fx_idade_s | 25 a 29 anos | 2013 | S016P | 0.8262557 | 0.7729942 | 0.8795172 | 0.03288902 |\n", "| 30 a 39 anos | fx_idade_s | 30 a 39 anos | 2013 | S016P | 0.8660926 | 0.8172904 | 0.9148948 | 0.02874925 |\n", "| 40 anos ou mais | fx_idade_s | 40 anos ou mais | 2013 | S016P | 0.8486411 | 0.7445249 | 0.9527572 | 0.06259593 |\n", "| urbano | urb_rur | urbano | 2013 | S016P | 0.8666800 | 0.8371479 | 0.8962121 | 0.01738551 |\n", "| rural | urb_rur | rural | 2013 | S016P | 0.7675523 | 0.6959295 | 0.8391751 | 0.04760970 |\n", "| Rondônia | uf | Rondônia | 2013 | S016P | 0.8216271 | 0.6958231 | 0.9474312 | 0.07812173 |\n", "| Acre | uf | Acre | 2013 | S016P | 0.8547101 | 0.7709839 | 0.9384364 | 0.04997984 |\n", "| Amazonas | uf | Amazonas | 2013 | S016P | 0.8667892 | 0.7943296 | 0.9392488 | 0.04265152 |\n", "| Roraima | uf | Roraima | 2013 | S016P | 0.9792703 | 0.9537907 | 1.0047498 | 0.01327522 |\n", "| Pará | uf | Pará | 2013 | S016P | 0.8405336 | 0.7421185 | 0.9389486 | 0.05973905 |\n", "| Amapá | uf | Amapá | 2013 | S016P | 0.9306654 | 0.8575116 | 1.0038191 | 0.04010467 |\n", "| Tocantins | uf | Tocantins | 2013 | S016P | 0.8782034 | 0.7739205 | 0.9824863 | 0.06058569 |\n", "| Maranhão | uf | Maranhão | 2013 | S016P | 0.7835474 | 0.6336436 | 0.9334513 | 0.09761116 |\n", "| Piauí | uf | Piauí | 2013 | S016P | 0.7036185 | 0.5706709 | 0.8365661 | 0.09640404 |\n", "| Ceará | uf | Ceará | 2013 | S016P | 0.8562209 | 0.7668826 | 0.9455592 | 0.05323580 |\n", "| Rio Grande do Norte | uf | Rio Grande do Norte | 2013 | S016P | 0.9159877 | 0.8350790 | 0.9968963 | 0.04506687 |\n", "| Paraíba | uf | Paraíba | 2013 | S016P | 0.7759216 | 0.6315260 | 0.9203172 | 0.09494847 |\n", "| Pernambuco | uf | Pernambuco | 2013 | S016P | 0.8833022 | 0.8007748 | 0.9658296 | 0.04766951 |\n", "| Alagoas | uf | Alagoas | 2013 | S016P | 0.7363261 | 0.5952972 | 0.8773550 | 0.09772144 |\n", "| Sergipe | uf | Sergipe | 2013 | S016P | 0.8148058 | 0.6825271 | 0.9470844 | 0.08282999 |\n", "| Bahia | uf | Bahia | 2013 | S016P | 0.7835843 | 0.6602149 | 0.9069537 | 0.08032921 |\n", "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n", "| São Luís2 | capital | São Luís | 2013 | S019P | 0.9581722 | 0.9012539 | 1.0150905 | 0.03030823 |\n", "| Teresina2 | capital | Teresina | 2013 | S019P | 0.8194882 | 0.6143240 | 1.0246524 | 0.12773525 |\n", "| Fortaleza2 | capital | Fortaleza | 2013 | S019P | 0.8828775 | 0.7011140 | 1.0646411 | 0.10504088 |\n", "| Natal2 | capital | Natal | 2013 | S019P | 1.0000000 | 1.0000000 | 1.0000000 | 0.00000000 |\n", "| João Pessoa2 | capital | João Pessoa | 2013 | S019P | 0.9526422 | 0.8914418 | 1.0138427 | 0.03277755 |\n", "| Recife2 | capital | Recife | 2013 | S019P | 0.9312556 | 0.7991790 | 1.0633323 | 0.07236175 |\n", "| Maceió2 | capital | Maceió | 2013 | S019P | 0.6667696 | 0.4682348 | 0.8653045 | 0.15191926 |\n", "| Aracaju2 | capital | Aracaju | 2013 | S019P | 1.0000000 | 1.0000000 | 1.0000000 | 0.00000000 |\n", "| Salvador2 | capital | Salvador | 2013 | S019P | 0.9061513 | 0.8027874 | 1.0095153 | 0.05819962 |\n", "| Belo Horizonte2 | capital | Belo Horizonte | 2013 | S019P | 0.8589035 | 0.7194189 | 0.9983881 | 0.08285789 |\n", "| Vitória2 | capital | Vitória | 2013 | S019P | 0.9504570 | 0.8525153 | 1.0483988 | 0.05257597 |\n", "| Rio de Janeiro5 | capital | Rio de Janeiro | 2013 | S019P | 0.8942121 | 0.7758989 | 1.0125253 | 0.06750635 |\n", "| São Paulo4 | capital | São Paulo | 2013 | S019P | 0.9311288 | 0.8760755 | 0.9861821 | 0.03016655 |\n", "| Curitiba2 | capital | Curitiba | 2013 | S019P | 0.9580169 | 0.8800529 | 1.0359810 | 0.04152151 |\n", "| Florianópolis2 | capital | Florianópolis | 2013 | S019P | 0.8589080 | 0.7491412 | 0.9686748 | 0.06520431 |\n", "| Porto Alegre2 | capital | Porto Alegre | 2013 | S019P | 0.9624795 | 0.8887895 | 1.0361696 | 0.03906333 |\n", "| Campo Grande2 | capital | Campo Grande | 2013 | S019P | 0.9676684 | 0.9068128 | 1.0285241 | 0.03208679 |\n", "| Cuiabá2 | capital | Cuiabá | 2013 | S019P | 0.9668783 | 0.9086181 | 1.0251384 | 0.03074339 |\n", "| Goiânia2 | capital | Goiânia | 2013 | S019P | 0.9806624 | 0.9421503 | 1.0191746 | 0.02003687 |\n", "| Brasília2 | capital | Brasília | 2013 | S019P | 0.9428326 | 0.8654071 | 1.0202581 | 0.04189879 |\n", "| Fundamental incompleto ou equivalente2 | gescol | Fundamental incompleto ou equivalente | 2013 | S019P | 0.7628161 | 0.6988318 | 0.8268003 | 0.04279619 |\n", "| Médio incompleto ou equivalente2 | gescol | Médio incompleto ou equivalente | 2013 | S019P | 0.8941055 | 0.8442370 | 0.9439740 | 0.02845703 |\n", "| Superior incompleto ou equivalente2 | gescol | Superior incompleto ou equivalente | 2013 | S019P | 0.9054178 | 0.8755653 | 0.9352703 | 0.01682225 |\n", "| Superior completo2 | gescol | Superior completo | 2013 | S019P | 0.9621193 | 0.9268137 | 0.9974248 | 0.01872258 |\n", "| S016PSim | total | Brasil | 2013 | S016P | 0.8509319 | 0.8234418 | 0.8784220 | 0.01648289 |\n", "| S016PSim1 | total | Capital | 2013 | S016P | 0.8947766 | 0.8621891 | 0.9273641 | 0.01858181 |\n", "| S018PSim | total | Brasil | 2013 | S018P | 0.7514091 | 0.7184669 | 0.7843514 | 0.02236807 |\n", "| S018PSim1 | total | Capital | 2013 | S018P | 0.8049977 | 0.7689407 | 0.8410546 | 0.02285318 |\n", "| S019PSim | total | Brasil | 2013 | S019P | 0.8763847 | 0.8526117 | 0.9001576 | 0.01384011 |\n", "| S019PSim1 | total | Capital | 2013 | S019P | 0.9166140 | 0.8907343 | 0.9424937 | 0.01440536 |\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", "São Luís2 capital \n", "Teresina2 capital \n", "Fortaleza2 capital \n", "Natal2 capital \n", "João Pessoa2 capital \n", "Recife2 capital \n", "Maceió2 capital \n", "Aracaju2 capital \n", "Salvador2 capital \n", "Belo Horizonte2 capital \n", "Vitória2 capital \n", "Rio de Janeiro5 capital \n", "São Paulo4 capital \n", "Curitiba2 capital \n", "Florianópolis2 capital \n", "Porto Alegre2 capital \n", "Campo Grande2 capital \n", "Cuiabá2 capital \n", "Goiânia2 capital \n", "Brasília2 capital \n", "Fundamental incompleto ou equivalente2 gescol \n", "Médio incompleto ou equivalente2 gescol \n", "Superior incompleto ou equivalente2 gescol \n", "Superior completo2 gescol \n", "S016PSim total \n", "S016PSim1 total \n", "S018PSim total \n", "S018PSim1 total \n", "S019PSim total \n", "S019PSim1 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", "São Luís2 São Luís \n", "Teresina2 Teresina \n", "Fortaleza2 Fortaleza \n", "Natal2 Natal \n", "João Pessoa2 João Pessoa \n", "Recife2 Recife \n", "Maceió2 Maceió \n", "Aracaju2 Aracaju \n", "Salvador2 Salvador \n", "Belo Horizonte2 Belo Horizonte \n", "Vitória2 Vitória \n", "Rio de Janeiro5 Rio de Janeiro \n", "São Paulo4 São Paulo \n", "Curitiba2 Curitiba \n", "Florianópolis2 Florianópolis \n", "Porto Alegre2 Porto Alegre \n", "Campo Grande2 Campo Grande \n", "Cuiabá2 Cuiabá \n", "Goiânia2 Goiânia \n", "Brasília2 Brasília \n", "Fundamental incompleto ou equivalente2 Fundamental incompleto ou equivalente\n", "Médio incompleto ou equivalente2 Médio incompleto ou equivalente \n", "Superior incompleto ou equivalente2 Superior incompleto ou equivalente \n", "Superior completo2 Superior completo \n", "S016PSim Brasil \n", "S016PSim1 Capital \n", "S018PSim Brasil \n", "S018PSim1 Capital \n", "S019PSim Brasil \n", "S019PSim1 Capital \n", " Ano Indicador Sim LowerS \n", "Branca 2013 S016P 0.8704893 0.8277014\n", "Preta 2013 S016P 0.7824306 0.6572729\n", "Parda 2013 S016P 0.8461478 0.8097939\n", "Até 1/2 SM 2013 S016P 0.8285370 0.7918252\n", "1/2 até 1 SM 2013 S016P 0.8885054 0.8429841\n", "1 até 2 SM 2013 S016P 0.8426610 0.7640768\n", "2 até 3 SM 2013 S016P 0.7988503 0.5851066\n", "Mais de 3 SM 2013 S016P 0.8862241 0.7959129\n", "18 a 24 anos 2013 S016P 0.8528084 0.8058320\n", "25 a 29 anos 2013 S016P 0.8262557 0.7729942\n", "30 a 39 anos 2013 S016P 0.8660926 0.8172904\n", "40 anos ou mais 2013 S016P 0.8486411 0.7445249\n", "urbano 2013 S016P 0.8666800 0.8371479\n", "rural 2013 S016P 0.7675523 0.6959295\n", "Rondônia 2013 S016P 0.8216271 0.6958231\n", "Acre 2013 S016P 0.8547101 0.7709839\n", "Amazonas 2013 S016P 0.8667892 0.7943296\n", "Roraima 2013 S016P 0.9792703 0.9537907\n", "Pará 2013 S016P 0.8405336 0.7421185\n", "Amapá 2013 S016P 0.9306654 0.8575116\n", "Tocantins 2013 S016P 0.8782034 0.7739205\n", "Maranhão 2013 S016P 0.7835474 0.6336436\n", "Piauí 2013 S016P 0.7036185 0.5706709\n", "Ceará 2013 S016P 0.8562209 0.7668826\n", "Rio Grande do Norte 2013 S016P 0.9159877 0.8350790\n", "Paraíba 2013 S016P 0.7759216 0.6315260\n", "Pernambuco 2013 S016P 0.8833022 0.8007748\n", "Alagoas 2013 S016P 0.7363261 0.5952972\n", "Sergipe 2013 S016P 0.8148058 0.6825271\n", "Bahia 2013 S016P 0.7835843 0.6602149\n", "⋮ ⋮ ⋮ ⋮ ⋮ \n", "São Luís2 2013 S019P 0.9581722 0.9012539\n", "Teresina2 2013 S019P 0.8194882 0.6143240\n", "Fortaleza2 2013 S019P 0.8828775 0.7011140\n", "Natal2 2013 S019P 1.0000000 1.0000000\n", "João Pessoa2 2013 S019P 0.9526422 0.8914418\n", "Recife2 2013 S019P 0.9312556 0.7991790\n", "Maceió2 2013 S019P 0.6667696 0.4682348\n", "Aracaju2 2013 S019P 1.0000000 1.0000000\n", "Salvador2 2013 S019P 0.9061513 0.8027874\n", "Belo Horizonte2 2013 S019P 0.8589035 0.7194189\n", "Vitória2 2013 S019P 0.9504570 0.8525153\n", "Rio de Janeiro5 2013 S019P 0.8942121 0.7758989\n", "São Paulo4 2013 S019P 0.9311288 0.8760755\n", "Curitiba2 2013 S019P 0.9580169 0.8800529\n", "Florianópolis2 2013 S019P 0.8589080 0.7491412\n", "Porto Alegre2 2013 S019P 0.9624795 0.8887895\n", "Campo Grande2 2013 S019P 0.9676684 0.9068128\n", "Cuiabá2 2013 S019P 0.9668783 0.9086181\n", "Goiânia2 2013 S019P 0.9806624 0.9421503\n", "Brasília2 2013 S019P 0.9428326 0.8654071\n", "Fundamental incompleto ou equivalente2 2013 S019P 0.7628161 0.6988318\n", "Médio incompleto ou equivalente2 2013 S019P 0.8941055 0.8442370\n", "Superior incompleto ou equivalente2 2013 S019P 0.9054178 0.8755653\n", "Superior completo2 2013 S019P 0.9621193 0.9268137\n", "S016PSim 2013 S016P 0.8509319 0.8234418\n", "S016PSim1 2013 S016P 0.8947766 0.8621891\n", "S018PSim 2013 S018P 0.7514091 0.7184669\n", "S018PSim1 2013 S018P 0.8049977 0.7689407\n", "S019PSim 2013 S019P 0.8763847 0.8526117\n", "S019PSim1 2013 S019P 0.9166140 0.8907343\n", " UpperS cvS \n", "Branca 0.9132772 0.02507897\n", "Preta 0.9075882 0.08161378\n", "Parda 0.8825018 0.02192086\n", "Até 1/2 SM 0.8652487 0.02260709\n", "1/2 até 1 SM 0.9340267 0.02614005\n", "1 até 2 SM 0.9212453 0.04758111\n", "2 até 3 SM 1.0125940 0.13651485\n", "Mais de 3 SM 0.9765354 0.05199364\n", "18 a 24 anos 0.8997849 0.02810482\n", "25 a 29 anos 0.8795172 0.03288902\n", "30 a 39 anos 0.9148948 0.02874925\n", "40 anos ou mais 0.9527572 0.06259593\n", "urbano 0.8962121 0.01738551\n", "rural 0.8391751 0.04760970\n", "Rondônia 0.9474312 0.07812173\n", "Acre 0.9384364 0.04997984\n", "Amazonas 0.9392488 0.04265152\n", "Roraima 1.0047498 0.01327522\n", "Pará 0.9389486 0.05973905\n", "Amapá 1.0038191 0.04010467\n", "Tocantins 0.9824863 0.06058569\n", "Maranhão 0.9334513 0.09761116\n", "Piauí 0.8365661 0.09640404\n", "Ceará 0.9455592 0.05323580\n", "Rio Grande do Norte 0.9968963 0.04506687\n", "Paraíba 0.9203172 0.09494847\n", "Pernambuco 0.9658296 0.04766951\n", "Alagoas 0.8773550 0.09772144\n", "Sergipe 0.9470844 0.08282999\n", "Bahia 0.9069537 0.08032921\n", "⋮ ⋮ ⋮ \n", "São Luís2 1.0150905 0.03030823\n", "Teresina2 1.0246524 0.12773525\n", "Fortaleza2 1.0646411 0.10504088\n", "Natal2 1.0000000 0.00000000\n", "João Pessoa2 1.0138427 0.03277755\n", "Recife2 1.0633323 0.07236175\n", "Maceió2 0.8653045 0.15191926\n", "Aracaju2 1.0000000 0.00000000\n", "Salvador2 1.0095153 0.05819962\n", "Belo Horizonte2 0.9983881 0.08285789\n", "Vitória2 1.0483988 0.05257597\n", "Rio de Janeiro5 1.0125253 0.06750635\n", "São Paulo4 0.9861821 0.03016655\n", "Curitiba2 1.0359810 0.04152151\n", "Florianópolis2 0.9686748 0.06520431\n", "Porto Alegre2 1.0361696 0.03906333\n", "Campo Grande2 1.0285241 0.03208679\n", "Cuiabá2 1.0251384 0.03074339\n", "Goiânia2 1.0191746 0.02003687\n", "Brasília2 1.0202581 0.04189879\n", "Fundamental incompleto ou equivalente2 0.8268003 0.04279619\n", "Médio incompleto ou equivalente2 0.9439740 0.02845703\n", "Superior incompleto ou equivalente2 0.9352703 0.01682225\n", "Superior completo2 0.9974248 0.01872258\n", "S016PSim 0.8784220 0.01648289\n", "S016PSim1 0.9273641 0.01858181\n", "S018PSim 0.7843514 0.02236807\n", "S018PSim1 0.8410546 0.02285318\n", "S019PSim 0.9001576 0.01384011\n", "S019PSim1 0.9424937 0.01440536" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "matriz_final" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Exportando tabela de indicadores calculados - Módulo S 2013" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "diretorio_saida <- \"\"\n", "write.table(matrizIndicadores,file=paste0(diretorio_saida,\"Indicadores_2013S_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 }