{ "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 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(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": [], "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": 4, "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": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Sim
1859
Não
59
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1859\n", "\\item[Não] 59\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1859Não\n", ": 59NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1859 59 58284 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
1127
Não
791
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1127\n", "\\item[Não] 791\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1127Não\n", ": 791NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1127 791 58284 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
1665
Não
253
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1665\n", "\\item[Não] 253\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1665Não\n", ": 253NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1665 253 58284 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
923
Não
995
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 923\n", "\\item[Não] 995\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 923Não\n", ": 995NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 923 995 58284 " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Sim
1146
Não
772
NA's
58284
\n" ], "text/latex": [ "\\begin{description*}\n", "\\item[Sim] 1146\n", "\\item[Não] 772\n", "\\item[NA's] 58284\n", "\\end{description*}\n" ], "text/markdown": [ "Sim\n", ": 1146Não\n", ": 772NA's\n", ": 58284\n", "\n" ], "text/plain": [ " Sim Não NA's \n", " 1146 772 58284 " ] }, "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", "pns2013.1$S020P <- NA\n", "pns2013.1$S020P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0] <- 2\n", "pns2013.1$S020P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0 & pns2013.1$S047==1] <- 1\n", "pns2013.1$S020P<-factor(pns2013.1$S020P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S020P)\n", "\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", "pns2013.1$S021P <- NA\n", "pns2013.1$S021P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0] <- 2\n", "pns2013.1$S021P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0 & pns2013.1$S048==1] <- 1\n", "pns2013.1$S021P<-factor(pns2013.1$S021P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.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", "pns2013.1$S022P <- NA\n", "pns2013.1$S022P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0] <- 2\n", "pns2013.1$S022P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001>0 & pns2013.1$S049 == 1 ] <- 1\n", "pns2013.1$S022P<-factor(pns2013.1$S022P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S022P)\n", "\n", "# 23. Proporção de mulheres que tiveram o último parto vaginal/normal - S023P.\n", "pns2013.1$S023P <- NA\n", "pns2013.1$S023P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0] <- 2\n", "pns2013.1$S023P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0 & pns2013.1$S056 == 1] <- 1\n", "pns2013.1$S023P<-factor(pns2013.1$S023P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S023P)\n", "\n", "# 24. Proporção de mulheres que tiveram acompanhante durante o período de parto - S024P.\n", "pns2013.1$S024P <- NA\n", "pns2013.1$S024P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0] <- 2\n", "pns2013.1$S024P[pns2013.1$C006==2 & pns2013.1$C008>=18 & pns2013.1$S001 > 0 & pns2013.1$S054 == 1] <- 1\n", "pns2013.1$S024P<-factor(pns2013.1$S024P, levels=c(1,2), labels=c(\"Sim\",\"Não\"))\n", "summary(pns2013.1$S024P)\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": 6, "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": 7, "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": 8, "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": 9, "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": 10, "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": 11, "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": 12, "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": 13, "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": 14, "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 S020P S021P \n", " Fundamental incompleto ou equivalente:24083 Sim : 1859 Sim : 1127 \n", " Médio incompleto ou equivalente : 9215 Não : 59 Não : 791 \n", " Superior incompleto ou equivalente :19149 NA's:58284 NA's:58284 \n", " Superior completo : 7755 \n", " \n", " \n", " \n", " S022P S023P S024P S001 \n", " Sim : 1665 Sim : 923 Sim : 1146 Min. :1.00 \n", " Não : 253 Não : 995 Não : 772 1st Qu.:1.00 \n", " NA's:58284 NA's:58284 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\", \"S020P\", \"S021P\", \"S022P\", \"S023P\", \"S024P\", \"S001\") \n", "summary(pns2013Ssurvey)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Exporta tabela filtrada com os dados específicos - Módulo S-Parte5 2013" ] }, { "cell_type": "code", "execution_count": 15, "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": 16, "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": 17, "metadata": {}, "outputs": [], "source": [ "#survey design S020P, S021P, S022P e S023\n", "desPNSS=subset(desPNS, C006==2 & C008>=18 & S001>0)\n", "desPNSS_C=subset(desPNS, C006==2 & C008>=18 & S001>0 & V0031==1)\n", "desPNSS_R=subset(desPNS, C006==2 & C008>=18 & S001>0 & !is.na(raça))\n", "desPNSS_Rend=subset(desPNS, C006==2 & C008>=18 & S001>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": 18, "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", ")\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)\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: 358 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><fct><chr><chr><dbl><dbl><dbl><dbl>
Brancaraça Branca 2013S020P0.98672170.97551420.99792935.795193e-03
Pretaraça Preta 2013S020P0.97918420.95750441.00086401.129646e-02
Pardaraça Parda 2013S020P0.97275620.95902030.98649207.204506e-03
Até 1/2 SMrend_per_capitaAté 1/2 SM 2013S020P0.96755440.95124610.98386288.599757e-03
1/2 até 1 SMrend_per_capita1/2 até 1 SM 2013S020P0.98366360.97023010.99709726.967808e-03
1 até 2 SMrend_per_capita1 até 2 SM 2013S020P0.99191780.98446660.99936903.832682e-03
2 até 3 SMrend_per_capita2 até 3 SM 2013S020P1.00000001.00000001.00000002.108608e-17
Mais de 3 SMrend_per_capitaMais de 3 SM 2013S020P0.98651560.96015941.01287171.363108e-02
18 a 24 anosfx_idade_s 18 a 24 anos 2013S020P0.98620940.97427010.99814876.176763e-03
25 a 29 anosfx_idade_s 25 a 29 anos 2013S020P0.97541900.95558230.99525581.037603e-02
30 a 39 anosfx_idade_s 30 a 39 anos 2013S020P0.97252590.95769670.98735517.779802e-03
40 anos ou maisfx_idade_s 40 anos ou mais 2013S020P0.98987420.96990281.00984561.029391e-02
urbanourb_rur urbano 2013S020P0.98841320.98171240.99511403.458922e-03
ruralurb_rur rural 2013S020P0.92866190.89014440.96717952.116182e-02
Rondôniauf Rondônia 2013S020P0.94073560.88465330.99681803.041658e-02
Acreuf Acre 2013S020P0.96361300.92498171.00224432.045449e-02
Amazonasuf Amazonas 2013S020P0.93626980.89060730.98193222.488343e-02
Roraimauf Roraima 2013S020P0.96047510.91994741.00100282.152868e-02
Paráuf Pará 2013S020P0.96218340.91807761.00628912.338779e-02
Amapáuf Amapá 2013S020P0.94932960.90402790.99463142.434726e-02
Tocantinsuf Tocantins 2013S020P1.00000001.00000001.00000000.000000e+00
Maranhãouf Maranhão 2013S020P0.91309510.81145591.01473435.679331e-02
Piauíuf Piauí 2013S020P0.94719350.87360181.02078523.964076e-02
Cearáuf Ceará 2013S020P0.97631040.93046381.02215692.395911e-02
Rio Grande do Norteuf Rio Grande do Norte2013S020P0.97330740.92080981.02580502.751956e-02
Paraíbauf Paraíba 2013S020P0.97632880.94215391.01050381.785927e-02
Pernambucouf Pernambuco 2013S020P0.99576940.98742521.00411354.275394e-03
Alagoasuf Alagoas 2013S020P1.00000001.00000001.00000000.000000e+00
Sergipeuf Sergipe 2013S020P1.00000001.00000001.00000000.000000e+00
Bahiauf Bahia 2013S020P0.96766540.91914171.01618902.558470e-02
⋮⋮⋮⋮⋮⋮⋮⋮⋮
Rio Branco3capitalRio Branco 2013S024P0.70551570.536091950.87493940.12252352
Manaus3capitalManaus 2013S024P0.57782840.418501090.73715570.14068351
Boa Vista3capitalBoa Vista 2013S024P0.73229210.602264450.86231980.09059481
Belém3capitalBelém 2013S024P0.57063150.345645180.79561770.20116491
Macapá3capitalMacapá 2013S024P0.56228260.314138540.81042670.22516515
Palmas3capitalPalmas 2013S024P0.71345320.546959910.87994640.11906471
São Luís3capitalSão Luís 2013S024P0.58203870.396306560.76777090.16281228
Teresina3capitalTeresina 2013S024P0.60774410.431795500.78369270.14771240
Fortaleza3capitalFortaleza 2013S024P0.57315480.353153720.79315580.19584152
Natal3capitalNatal 2013S024P0.66236490.434386490.89034340.17560964
João Pessoa3capitalJoão Pessoa 2013S024P0.65557450.491927260.81922180.12736163
Recife3capitalRecife 2013S024P0.71947050.482986520.95595450.16770292
Maceió3capitalMaceió 2013S024P0.51669790.299876770.73351910.21410010
Aracaju3capitalAracaju 2013S024P0.39392260.089573230.69827200.39419709
Salvador3capitalSalvador 2013S024P0.60287620.419999240.78575320.15476857
Belo Horizonte3capitalBelo Horizonte 2013S024P0.95341340.882781771.02404510.03779810
Vitória3capitalVitória 2013S024P0.53516560.239599810.83073140.28178502
Rio de Janeiro8capitalRio de Janeiro 2013S024P0.62660700.379254660.87395940.20140614
São Paulo7capitalSão Paulo 2013S024P0.84951500.759243640.93978640.05421643
Curitiba3capitalCuritiba 2013S024P0.86705280.748361490.98574420.06984341
Florianópolis3capitalFlorianópolis 2013S024P0.93838920.825833171.05094510.06119804
Porto Alegre3capitalPorto Alegre 2013S024P0.86605000.740511510.99158840.07395809
Campo Grande3capitalCampo Grande 2013S024P0.63789140.452247050.82353580.14848648
Cuiabá3capitalCuiabá 2013S024P0.57178060.278603710.86495740.26160871
Goiânia3capitalGoiânia 2013S024P0.53262890.318191060.74706680.20541332
Brasília3capitalBrasília 2013S024P0.57415040.424882290.72341860.13264574
Fundamental incompleto ou equivalente4gescol Fundamental incompleto ou equivalente2013S024P0.52874310.454108580.60337770.07201900
Médio incompleto ou equivalente4gescol Médio incompleto ou equivalente 2013S024P0.52436170.447675700.60104770.07461685
Superior incompleto ou equivalente4gescol Superior incompleto ou equivalente 2013S024P0.62809310.566785000.68940110.04980185
Superior completo4gescol Superior completo 2013S024P0.69425920.585865360.80265300.07965900
\n" ], "text/latex": [ "A data.frame: 358 × 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 & S020P & 0.9867217 & 0.9755142 & 0.9979293 & 5.795193e-03\\\\\n", "\tPreta & raça & Preta & 2013 & S020P & 0.9791842 & 0.9575044 & 1.0008640 & 1.129646e-02\\\\\n", "\tParda & raça & Parda & 2013 & S020P & 0.9727562 & 0.9590203 & 0.9864920 & 7.204506e-03\\\\\n", "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM & 2013 & S020P & 0.9675544 & 0.9512461 & 0.9838628 & 8.599757e-03\\\\\n", "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM & 2013 & S020P & 0.9836636 & 0.9702301 & 0.9970972 & 6.967808e-03\\\\\n", "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM & 2013 & S020P & 0.9919178 & 0.9844666 & 0.9993690 & 3.832682e-03\\\\\n", "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 2.108608e-17\\\\\n", "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM & 2013 & S020P & 0.9865156 & 0.9601594 & 1.0128717 & 1.363108e-02\\\\\n", "\t18 a 24 anos & fx\\_idade\\_s & 18 a 24 anos & 2013 & S020P & 0.9862094 & 0.9742701 & 0.9981487 & 6.176763e-03\\\\\n", "\t25 a 29 anos & fx\\_idade\\_s & 25 a 29 anos & 2013 & S020P & 0.9754190 & 0.9555823 & 0.9952558 & 1.037603e-02\\\\\n", "\t30 a 39 anos & fx\\_idade\\_s & 30 a 39 anos & 2013 & S020P & 0.9725259 & 0.9576967 & 0.9873551 & 7.779802e-03\\\\\n", "\t40 anos ou mais & fx\\_idade\\_s & 40 anos ou mais & 2013 & S020P & 0.9898742 & 0.9699028 & 1.0098456 & 1.029391e-02\\\\\n", "\turbano & urb\\_rur & urbano & 2013 & S020P & 0.9884132 & 0.9817124 & 0.9951140 & 3.458922e-03\\\\\n", "\trural & urb\\_rur & rural & 2013 & S020P & 0.9286619 & 0.8901444 & 0.9671795 & 2.116182e-02\\\\\n", "\tRondônia & uf & Rondônia & 2013 & S020P & 0.9407356 & 0.8846533 & 0.9968180 & 3.041658e-02\\\\\n", "\tAcre & uf & Acre & 2013 & S020P & 0.9636130 & 0.9249817 & 1.0022443 & 2.045449e-02\\\\\n", "\tAmazonas & uf & Amazonas & 2013 & S020P & 0.9362698 & 0.8906073 & 0.9819322 & 2.488343e-02\\\\\n", "\tRoraima & uf & Roraima & 2013 & S020P & 0.9604751 & 0.9199474 & 1.0010028 & 2.152868e-02\\\\\n", "\tPará & uf & Pará & 2013 & S020P & 0.9621834 & 0.9180776 & 1.0062891 & 2.338779e-02\\\\\n", "\tAmapá & uf & Amapá & 2013 & S020P & 0.9493296 & 0.9040279 & 0.9946314 & 2.434726e-02\\\\\n", "\tTocantins & uf & Tocantins & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tMaranhão & uf & Maranhão & 2013 & S020P & 0.9130951 & 0.8114559 & 1.0147343 & 5.679331e-02\\\\\n", "\tPiauí & uf & Piauí & 2013 & S020P & 0.9471935 & 0.8736018 & 1.0207852 & 3.964076e-02\\\\\n", "\tCeará & uf & Ceará & 2013 & S020P & 0.9763104 & 0.9304638 & 1.0221569 & 2.395911e-02\\\\\n", "\tRio Grande do Norte & uf & Rio Grande do Norte & 2013 & S020P & 0.9733074 & 0.9208098 & 1.0258050 & 2.751956e-02\\\\\n", "\tParaíba & uf & Paraíba & 2013 & S020P & 0.9763288 & 0.9421539 & 1.0105038 & 1.785927e-02\\\\\n", "\tPernambuco & uf & Pernambuco & 2013 & S020P & 0.9957694 & 0.9874252 & 1.0041135 & 4.275394e-03\\\\\n", "\tAlagoas & uf & Alagoas & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tSergipe & uf & Sergipe & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tBahia & uf & Bahia & 2013 & S020P & 0.9676654 & 0.9191417 & 1.0161890 & 2.558470e-02\\\\\n", "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n", "\tRio Branco3 & capital & Rio Branco & 2013 & S024P & 0.7055157 & 0.53609195 & 0.8749394 & 0.12252352\\\\\n", "\tManaus3 & capital & Manaus & 2013 & S024P & 0.5778284 & 0.41850109 & 0.7371557 & 0.14068351\\\\\n", "\tBoa Vista3 & capital & Boa Vista & 2013 & S024P & 0.7322921 & 0.60226445 & 0.8623198 & 0.09059481\\\\\n", "\tBelém3 & capital & Belém & 2013 & S024P & 0.5706315 & 0.34564518 & 0.7956177 & 0.20116491\\\\\n", "\tMacapá3 & capital & Macapá & 2013 & S024P & 0.5622826 & 0.31413854 & 0.8104267 & 0.22516515\\\\\n", "\tPalmas3 & capital & Palmas & 2013 & S024P & 0.7134532 & 0.54695991 & 0.8799464 & 0.11906471\\\\\n", "\tSão Luís3 & capital & São Luís & 2013 & S024P & 0.5820387 & 0.39630656 & 0.7677709 & 0.16281228\\\\\n", "\tTeresina3 & capital & Teresina & 2013 & S024P & 0.6077441 & 0.43179550 & 0.7836927 & 0.14771240\\\\\n", "\tFortaleza3 & capital & Fortaleza & 2013 & S024P & 0.5731548 & 0.35315372 & 0.7931558 & 0.19584152\\\\\n", "\tNatal3 & capital & Natal & 2013 & S024P & 0.6623649 & 0.43438649 & 0.8903434 & 0.17560964\\\\\n", "\tJoão Pessoa3 & capital & João Pessoa & 2013 & S024P & 0.6555745 & 0.49192726 & 0.8192218 & 0.12736163\\\\\n", "\tRecife3 & capital & Recife & 2013 & S024P & 0.7194705 & 0.48298652 & 0.9559545 & 0.16770292\\\\\n", "\tMaceió3 & capital & Maceió & 2013 & S024P & 0.5166979 & 0.29987677 & 0.7335191 & 0.21410010\\\\\n", "\tAracaju3 & capital & Aracaju & 2013 & S024P & 0.3939226 & 0.08957323 & 0.6982720 & 0.39419709\\\\\n", "\tSalvador3 & capital & Salvador & 2013 & S024P & 0.6028762 & 0.41999924 & 0.7857532 & 0.15476857\\\\\n", "\tBelo Horizonte3 & capital & Belo Horizonte & 2013 & S024P & 0.9534134 & 0.88278177 & 1.0240451 & 0.03779810\\\\\n", "\tVitória3 & capital & Vitória & 2013 & S024P & 0.5351656 & 0.23959981 & 0.8307314 & 0.28178502\\\\\n", "\tRio de Janeiro8 & capital & Rio de Janeiro & 2013 & S024P & 0.6266070 & 0.37925466 & 0.8739594 & 0.20140614\\\\\n", "\tSão Paulo7 & capital & São Paulo & 2013 & S024P & 0.8495150 & 0.75924364 & 0.9397864 & 0.05421643\\\\\n", "\tCuritiba3 & capital & Curitiba & 2013 & S024P & 0.8670528 & 0.74836149 & 0.9857442 & 0.06984341\\\\\n", "\tFlorianópolis3 & capital & Florianópolis & 2013 & S024P & 0.9383892 & 0.82583317 & 1.0509451 & 0.06119804\\\\\n", "\tPorto Alegre3 & capital & Porto Alegre & 2013 & S024P & 0.8660500 & 0.74051151 & 0.9915884 & 0.07395809\\\\\n", "\tCampo Grande3 & capital & Campo Grande & 2013 & S024P & 0.6378914 & 0.45224705 & 0.8235358 & 0.14848648\\\\\n", "\tCuiabá3 & capital & Cuiabá & 2013 & S024P & 0.5717806 & 0.27860371 & 0.8649574 & 0.26160871\\\\\n", "\tGoiânia3 & capital & Goiânia & 2013 & S024P & 0.5326289 & 0.31819106 & 0.7470668 & 0.20541332\\\\\n", "\tBrasília3 & capital & Brasília & 2013 & S024P & 0.5741504 & 0.42488229 & 0.7234186 & 0.13264574\\\\\n", "\tFundamental incompleto ou equivalente4 & gescol & Fundamental incompleto ou equivalente & 2013 & S024P & 0.5287431 & 0.45410858 & 0.6033777 & 0.07201900\\\\\n", "\tMédio incompleto ou equivalente4 & gescol & Médio incompleto ou equivalente & 2013 & S024P & 0.5243617 & 0.44767570 & 0.6010477 & 0.07461685\\\\\n", "\tSuperior incompleto ou equivalente4 & gescol & Superior incompleto ou equivalente & 2013 & S024P & 0.6280931 & 0.56678500 & 0.6894011 & 0.04980185\\\\\n", "\tSuperior completo4 & gescol & Superior completo & 2013 & S024P & 0.6942592 & 0.58586536 & 0.8026530 & 0.07965900\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 358 × 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 | S020P | 0.9867217 | 0.9755142 | 0.9979293 | 5.795193e-03 |\n", "| Preta | raça | Preta | 2013 | S020P | 0.9791842 | 0.9575044 | 1.0008640 | 1.129646e-02 |\n", "| Parda | raça | Parda | 2013 | S020P | 0.9727562 | 0.9590203 | 0.9864920 | 7.204506e-03 |\n", "| Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2013 | S020P | 0.9675544 | 0.9512461 | 0.9838628 | 8.599757e-03 |\n", "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2013 | S020P | 0.9836636 | 0.9702301 | 0.9970972 | 6.967808e-03 |\n", "| 1 até 2 SM | rend_per_capita | 1 até 2 SM | 2013 | S020P | 0.9919178 | 0.9844666 | 0.9993690 | 3.832682e-03 |\n", "| 2 até 3 SM | rend_per_capita | 2 até 3 SM | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 2.108608e-17 |\n", "| Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2013 | S020P | 0.9865156 | 0.9601594 | 1.0128717 | 1.363108e-02 |\n", "| 18 a 24 anos | fx_idade_s | 18 a 24 anos | 2013 | S020P | 0.9862094 | 0.9742701 | 0.9981487 | 6.176763e-03 |\n", "| 25 a 29 anos | fx_idade_s | 25 a 29 anos | 2013 | S020P | 0.9754190 | 0.9555823 | 0.9952558 | 1.037603e-02 |\n", "| 30 a 39 anos | fx_idade_s | 30 a 39 anos | 2013 | S020P | 0.9725259 | 0.9576967 | 0.9873551 | 7.779802e-03 |\n", "| 40 anos ou mais | fx_idade_s | 40 anos ou mais | 2013 | S020P | 0.9898742 | 0.9699028 | 1.0098456 | 1.029391e-02 |\n", "| urbano | urb_rur | urbano | 2013 | S020P | 0.9884132 | 0.9817124 | 0.9951140 | 3.458922e-03 |\n", "| rural | urb_rur | rural | 2013 | S020P | 0.9286619 | 0.8901444 | 0.9671795 | 2.116182e-02 |\n", "| Rondônia | uf | Rondônia | 2013 | S020P | 0.9407356 | 0.8846533 | 0.9968180 | 3.041658e-02 |\n", "| Acre | uf | Acre | 2013 | S020P | 0.9636130 | 0.9249817 | 1.0022443 | 2.045449e-02 |\n", "| Amazonas | uf | Amazonas | 2013 | S020P | 0.9362698 | 0.8906073 | 0.9819322 | 2.488343e-02 |\n", "| Roraima | uf | Roraima | 2013 | S020P | 0.9604751 | 0.9199474 | 1.0010028 | 2.152868e-02 |\n", "| Pará | uf | Pará | 2013 | S020P | 0.9621834 | 0.9180776 | 1.0062891 | 2.338779e-02 |\n", "| Amapá | uf | Amapá | 2013 | S020P | 0.9493296 | 0.9040279 | 0.9946314 | 2.434726e-02 |\n", "| Tocantins | uf | Tocantins | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Maranhão | uf | Maranhão | 2013 | S020P | 0.9130951 | 0.8114559 | 1.0147343 | 5.679331e-02 |\n", "| Piauí | uf | Piauí | 2013 | S020P | 0.9471935 | 0.8736018 | 1.0207852 | 3.964076e-02 |\n", "| Ceará | uf | Ceará | 2013 | S020P | 0.9763104 | 0.9304638 | 1.0221569 | 2.395911e-02 |\n", "| Rio Grande do Norte | uf | Rio Grande do Norte | 2013 | S020P | 0.9733074 | 0.9208098 | 1.0258050 | 2.751956e-02 |\n", "| Paraíba | uf | Paraíba | 2013 | S020P | 0.9763288 | 0.9421539 | 1.0105038 | 1.785927e-02 |\n", "| Pernambuco | uf | Pernambuco | 2013 | S020P | 0.9957694 | 0.9874252 | 1.0041135 | 4.275394e-03 |\n", "| Alagoas | uf | Alagoas | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Sergipe | uf | Sergipe | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Bahia | uf | Bahia | 2013 | S020P | 0.9676654 | 0.9191417 | 1.0161890 | 2.558470e-02 |\n", "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n", "| Rio Branco3 | capital | Rio Branco | 2013 | S024P | 0.7055157 | 0.53609195 | 0.8749394 | 0.12252352 |\n", "| Manaus3 | capital | Manaus | 2013 | S024P | 0.5778284 | 0.41850109 | 0.7371557 | 0.14068351 |\n", "| Boa Vista3 | capital | Boa Vista | 2013 | S024P | 0.7322921 | 0.60226445 | 0.8623198 | 0.09059481 |\n", "| Belém3 | capital | Belém | 2013 | S024P | 0.5706315 | 0.34564518 | 0.7956177 | 0.20116491 |\n", "| Macapá3 | capital | Macapá | 2013 | S024P | 0.5622826 | 0.31413854 | 0.8104267 | 0.22516515 |\n", "| Palmas3 | capital | Palmas | 2013 | S024P | 0.7134532 | 0.54695991 | 0.8799464 | 0.11906471 |\n", "| São Luís3 | capital | São Luís | 2013 | S024P | 0.5820387 | 0.39630656 | 0.7677709 | 0.16281228 |\n", "| Teresina3 | capital | Teresina | 2013 | S024P | 0.6077441 | 0.43179550 | 0.7836927 | 0.14771240 |\n", "| Fortaleza3 | capital | Fortaleza | 2013 | S024P | 0.5731548 | 0.35315372 | 0.7931558 | 0.19584152 |\n", "| Natal3 | capital | Natal | 2013 | S024P | 0.6623649 | 0.43438649 | 0.8903434 | 0.17560964 |\n", "| João Pessoa3 | capital | João Pessoa | 2013 | S024P | 0.6555745 | 0.49192726 | 0.8192218 | 0.12736163 |\n", "| Recife3 | capital | Recife | 2013 | S024P | 0.7194705 | 0.48298652 | 0.9559545 | 0.16770292 |\n", "| Maceió3 | capital | Maceió | 2013 | S024P | 0.5166979 | 0.29987677 | 0.7335191 | 0.21410010 |\n", "| Aracaju3 | capital | Aracaju | 2013 | S024P | 0.3939226 | 0.08957323 | 0.6982720 | 0.39419709 |\n", "| Salvador3 | capital | Salvador | 2013 | S024P | 0.6028762 | 0.41999924 | 0.7857532 | 0.15476857 |\n", "| Belo Horizonte3 | capital | Belo Horizonte | 2013 | S024P | 0.9534134 | 0.88278177 | 1.0240451 | 0.03779810 |\n", "| Vitória3 | capital | Vitória | 2013 | S024P | 0.5351656 | 0.23959981 | 0.8307314 | 0.28178502 |\n", "| Rio de Janeiro8 | capital | Rio de Janeiro | 2013 | S024P | 0.6266070 | 0.37925466 | 0.8739594 | 0.20140614 |\n", "| São Paulo7 | capital | São Paulo | 2013 | S024P | 0.8495150 | 0.75924364 | 0.9397864 | 0.05421643 |\n", "| Curitiba3 | capital | Curitiba | 2013 | S024P | 0.8670528 | 0.74836149 | 0.9857442 | 0.06984341 |\n", "| Florianópolis3 | capital | Florianópolis | 2013 | S024P | 0.9383892 | 0.82583317 | 1.0509451 | 0.06119804 |\n", "| Porto Alegre3 | capital | Porto Alegre | 2013 | S024P | 0.8660500 | 0.74051151 | 0.9915884 | 0.07395809 |\n", "| Campo Grande3 | capital | Campo Grande | 2013 | S024P | 0.6378914 | 0.45224705 | 0.8235358 | 0.14848648 |\n", "| Cuiabá3 | capital | Cuiabá | 2013 | S024P | 0.5717806 | 0.27860371 | 0.8649574 | 0.26160871 |\n", "| Goiânia3 | capital | Goiânia | 2013 | S024P | 0.5326289 | 0.31819106 | 0.7470668 | 0.20541332 |\n", "| Brasília3 | capital | Brasília | 2013 | S024P | 0.5741504 | 0.42488229 | 0.7234186 | 0.13264574 |\n", "| Fundamental incompleto ou equivalente4 | gescol | Fundamental incompleto ou equivalente | 2013 | S024P | 0.5287431 | 0.45410858 | 0.6033777 | 0.07201900 |\n", "| Médio incompleto ou equivalente4 | gescol | Médio incompleto ou equivalente | 2013 | S024P | 0.5243617 | 0.44767570 | 0.6010477 | 0.07461685 |\n", "| Superior incompleto ou equivalente4 | gescol | Superior incompleto ou equivalente | 2013 | S024P | 0.6280931 | 0.56678500 | 0.6894011 | 0.04980185 |\n", "| Superior completo4 | gescol | Superior completo | 2013 | S024P | 0.6942592 | 0.58586536 | 0.8026530 | 0.07965900 |\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 Branco3 capital \n", "Manaus3 capital \n", "Boa Vista3 capital \n", "Belém3 capital \n", "Macapá3 capital \n", "Palmas3 capital \n", "São Luís3 capital \n", "Teresina3 capital \n", "Fortaleza3 capital \n", "Natal3 capital \n", "João Pessoa3 capital \n", "Recife3 capital \n", "Maceió3 capital \n", "Aracaju3 capital \n", "Salvador3 capital \n", "Belo Horizonte3 capital \n", "Vitória3 capital \n", "Rio de Janeiro8 capital \n", "São Paulo7 capital \n", "Curitiba3 capital \n", "Florianópolis3 capital \n", "Porto Alegre3 capital \n", "Campo Grande3 capital \n", "Cuiabá3 capital \n", "Goiânia3 capital \n", "Brasília3 capital \n", "Fundamental incompleto ou equivalente4 gescol \n", "Médio incompleto ou equivalente4 gescol \n", "Superior incompleto ou equivalente4 gescol \n", "Superior completo4 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 Branco3 Rio Branco \n", "Manaus3 Manaus \n", "Boa Vista3 Boa Vista \n", "Belém3 Belém \n", "Macapá3 Macapá \n", "Palmas3 Palmas \n", "São Luís3 São Luís \n", "Teresina3 Teresina \n", "Fortaleza3 Fortaleza \n", "Natal3 Natal \n", "João Pessoa3 João Pessoa \n", "Recife3 Recife \n", "Maceió3 Maceió \n", "Aracaju3 Aracaju \n", "Salvador3 Salvador \n", "Belo Horizonte3 Belo Horizonte \n", "Vitória3 Vitória \n", "Rio de Janeiro8 Rio de Janeiro \n", "São Paulo7 São Paulo \n", "Curitiba3 Curitiba \n", "Florianópolis3 Florianópolis \n", "Porto Alegre3 Porto Alegre \n", "Campo Grande3 Campo Grande \n", "Cuiabá3 Cuiabá \n", "Goiânia3 Goiânia \n", "Brasília3 Brasília \n", "Fundamental incompleto ou equivalente4 Fundamental incompleto ou equivalente\n", "Médio incompleto ou equivalente4 Médio incompleto ou equivalente \n", "Superior incompleto ou equivalente4 Superior incompleto ou equivalente \n", "Superior completo4 Superior completo \n", " Ano Indicador Sim LowerS \n", "Branca 2013 S020P 0.9867217 0.9755142 \n", "Preta 2013 S020P 0.9791842 0.9575044 \n", "Parda 2013 S020P 0.9727562 0.9590203 \n", "Até 1/2 SM 2013 S020P 0.9675544 0.9512461 \n", "1/2 até 1 SM 2013 S020P 0.9836636 0.9702301 \n", "1 até 2 SM 2013 S020P 0.9919178 0.9844666 \n", "2 até 3 SM 2013 S020P 1.0000000 1.0000000 \n", "Mais de 3 SM 2013 S020P 0.9865156 0.9601594 \n", "18 a 24 anos 2013 S020P 0.9862094 0.9742701 \n", "25 a 29 anos 2013 S020P 0.9754190 0.9555823 \n", "30 a 39 anos 2013 S020P 0.9725259 0.9576967 \n", "40 anos ou mais 2013 S020P 0.9898742 0.9699028 \n", "urbano 2013 S020P 0.9884132 0.9817124 \n", "rural 2013 S020P 0.9286619 0.8901444 \n", "Rondônia 2013 S020P 0.9407356 0.8846533 \n", "Acre 2013 S020P 0.9636130 0.9249817 \n", "Amazonas 2013 S020P 0.9362698 0.8906073 \n", "Roraima 2013 S020P 0.9604751 0.9199474 \n", "Pará 2013 S020P 0.9621834 0.9180776 \n", "Amapá 2013 S020P 0.9493296 0.9040279 \n", "Tocantins 2013 S020P 1.0000000 1.0000000 \n", "Maranhão 2013 S020P 0.9130951 0.8114559 \n", "Piauí 2013 S020P 0.9471935 0.8736018 \n", "Ceará 2013 S020P 0.9763104 0.9304638 \n", "Rio Grande do Norte 2013 S020P 0.9733074 0.9208098 \n", "Paraíba 2013 S020P 0.9763288 0.9421539 \n", "Pernambuco 2013 S020P 0.9957694 0.9874252 \n", "Alagoas 2013 S020P 1.0000000 1.0000000 \n", "Sergipe 2013 S020P 1.0000000 1.0000000 \n", "Bahia 2013 S020P 0.9676654 0.9191417 \n", "⋮ ⋮ ⋮ ⋮ ⋮ \n", "Rio Branco3 2013 S024P 0.7055157 0.53609195\n", "Manaus3 2013 S024P 0.5778284 0.41850109\n", "Boa Vista3 2013 S024P 0.7322921 0.60226445\n", "Belém3 2013 S024P 0.5706315 0.34564518\n", "Macapá3 2013 S024P 0.5622826 0.31413854\n", "Palmas3 2013 S024P 0.7134532 0.54695991\n", "São Luís3 2013 S024P 0.5820387 0.39630656\n", "Teresina3 2013 S024P 0.6077441 0.43179550\n", "Fortaleza3 2013 S024P 0.5731548 0.35315372\n", "Natal3 2013 S024P 0.6623649 0.43438649\n", "João Pessoa3 2013 S024P 0.6555745 0.49192726\n", "Recife3 2013 S024P 0.7194705 0.48298652\n", "Maceió3 2013 S024P 0.5166979 0.29987677\n", "Aracaju3 2013 S024P 0.3939226 0.08957323\n", "Salvador3 2013 S024P 0.6028762 0.41999924\n", "Belo Horizonte3 2013 S024P 0.9534134 0.88278177\n", "Vitória3 2013 S024P 0.5351656 0.23959981\n", "Rio de Janeiro8 2013 S024P 0.6266070 0.37925466\n", "São Paulo7 2013 S024P 0.8495150 0.75924364\n", "Curitiba3 2013 S024P 0.8670528 0.74836149\n", "Florianópolis3 2013 S024P 0.9383892 0.82583317\n", "Porto Alegre3 2013 S024P 0.8660500 0.74051151\n", "Campo Grande3 2013 S024P 0.6378914 0.45224705\n", "Cuiabá3 2013 S024P 0.5717806 0.27860371\n", "Goiânia3 2013 S024P 0.5326289 0.31819106\n", "Brasília3 2013 S024P 0.5741504 0.42488229\n", "Fundamental incompleto ou equivalente4 2013 S024P 0.5287431 0.45410858\n", "Médio incompleto ou equivalente4 2013 S024P 0.5243617 0.44767570\n", "Superior incompleto ou equivalente4 2013 S024P 0.6280931 0.56678500\n", "Superior completo4 2013 S024P 0.6942592 0.58586536\n", " UpperS cvS \n", "Branca 0.9979293 5.795193e-03\n", "Preta 1.0008640 1.129646e-02\n", "Parda 0.9864920 7.204506e-03\n", "Até 1/2 SM 0.9838628 8.599757e-03\n", "1/2 até 1 SM 0.9970972 6.967808e-03\n", "1 até 2 SM 0.9993690 3.832682e-03\n", "2 até 3 SM 1.0000000 2.108608e-17\n", "Mais de 3 SM 1.0128717 1.363108e-02\n", "18 a 24 anos 0.9981487 6.176763e-03\n", "25 a 29 anos 0.9952558 1.037603e-02\n", "30 a 39 anos 0.9873551 7.779802e-03\n", "40 anos ou mais 1.0098456 1.029391e-02\n", "urbano 0.9951140 3.458922e-03\n", "rural 0.9671795 2.116182e-02\n", "Rondônia 0.9968180 3.041658e-02\n", "Acre 1.0022443 2.045449e-02\n", "Amazonas 0.9819322 2.488343e-02\n", "Roraima 1.0010028 2.152868e-02\n", "Pará 1.0062891 2.338779e-02\n", "Amapá 0.9946314 2.434726e-02\n", "Tocantins 1.0000000 0.000000e+00\n", "Maranhão 1.0147343 5.679331e-02\n", "Piauí 1.0207852 3.964076e-02\n", "Ceará 1.0221569 2.395911e-02\n", "Rio Grande do Norte 1.0258050 2.751956e-02\n", "Paraíba 1.0105038 1.785927e-02\n", "Pernambuco 1.0041135 4.275394e-03\n", "Alagoas 1.0000000 0.000000e+00\n", "Sergipe 1.0000000 0.000000e+00\n", "Bahia 1.0161890 2.558470e-02\n", "⋮ ⋮ ⋮ \n", "Rio Branco3 0.8749394 0.12252352 \n", "Manaus3 0.7371557 0.14068351 \n", "Boa Vista3 0.8623198 0.09059481 \n", "Belém3 0.7956177 0.20116491 \n", "Macapá3 0.8104267 0.22516515 \n", "Palmas3 0.8799464 0.11906471 \n", "São Luís3 0.7677709 0.16281228 \n", "Teresina3 0.7836927 0.14771240 \n", "Fortaleza3 0.7931558 0.19584152 \n", "Natal3 0.8903434 0.17560964 \n", "João Pessoa3 0.8192218 0.12736163 \n", "Recife3 0.9559545 0.16770292 \n", "Maceió3 0.7335191 0.21410010 \n", "Aracaju3 0.6982720 0.39419709 \n", "Salvador3 0.7857532 0.15476857 \n", "Belo Horizonte3 1.0240451 0.03779810 \n", "Vitória3 0.8307314 0.28178502 \n", "Rio de Janeiro8 0.8739594 0.20140614 \n", "São Paulo7 0.9397864 0.05421643 \n", "Curitiba3 0.9857442 0.06984341 \n", "Florianópolis3 1.0509451 0.06119804 \n", "Porto Alegre3 0.9915884 0.07395809 \n", "Campo Grande3 0.8235358 0.14848648 \n", "Cuiabá3 0.8649574 0.26160871 \n", "Goiânia3 0.7470668 0.20541332 \n", "Brasília3 0.7234186 0.13264574 \n", "Fundamental incompleto ou equivalente4 0.6033777 0.07201900 \n", "Médio incompleto ou equivalente4 0.6010477 0.07461685 \n", "Superior incompleto ou equivalente4 0.6894011 0.04980185 \n", "Superior completo4 0.8026530 0.07965900 " ] }, "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", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
A data.frame: 10 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><chr><chr><chr><dbl><dbl><dbl><dbl>
S020PSimtotalBrasil 2013S020P0.97893590.97053190.98733990.004380100
S020PSim1totalCapital2013S020P0.98292800.97004440.99581170.006687578
S021PSimtotalBrasil 2013S021P0.61407170.57808880.65005470.029897151
S021PSim1totalCapital2013S021P0.62527650.57564570.67490720.040497761
S022PSimtotalBrasil 2013S022P0.87800410.85502340.90098480.013354219
S022PSim1totalCapital2013S022P0.86512460.82949510.90075410.021012739
S023PSimtotalBrasil 2013S023P0.45319670.41403860.49235480.044084608
S023PSim1totalCapital2013S023P0.43347540.38169770.48525310.060943851
S024PSimtotalBrasil 2013S024P0.58800580.54963580.62637590.033293744
S024PSim1totalCapital2013S024P0.70264610.65581300.74947910.034006943
\n" ], "text/latex": [ "A data.frame: 10 × 8\n", "\\begin{tabular}{r|llllllll}\n", " & abr\\_tipo & abr\\_nome & Ano & Indicador & Sim & LowerS & UpperS & cvS\\\\\n", " & & & & & & & & \\\\\n", "\\hline\n", "\tS020PSim & total & Brasil & 2013 & S020P & 0.9789359 & 0.9705319 & 0.9873399 & 0.004380100\\\\\n", "\tS020PSim1 & total & Capital & 2013 & S020P & 0.9829280 & 0.9700444 & 0.9958117 & 0.006687578\\\\\n", "\tS021PSim & total & Brasil & 2013 & S021P & 0.6140717 & 0.5780888 & 0.6500547 & 0.029897151\\\\\n", "\tS021PSim1 & total & Capital & 2013 & S021P & 0.6252765 & 0.5756457 & 0.6749072 & 0.040497761\\\\\n", "\tS022PSim & total & Brasil & 2013 & S022P & 0.8780041 & 0.8550234 & 0.9009848 & 0.013354219\\\\\n", "\tS022PSim1 & total & Capital & 2013 & S022P & 0.8651246 & 0.8294951 & 0.9007541 & 0.021012739\\\\\n", "\tS023PSim & total & Brasil & 2013 & S023P & 0.4531967 & 0.4140386 & 0.4923548 & 0.044084608\\\\\n", "\tS023PSim1 & total & Capital & 2013 & S023P & 0.4334754 & 0.3816977 & 0.4852531 & 0.060943851\\\\\n", "\tS024PSim & total & Brasil & 2013 & S024P & 0.5880058 & 0.5496358 & 0.6263759 & 0.033293744\\\\\n", "\tS024PSim1 & total & Capital & 2013 & S024P & 0.7026461 & 0.6558130 & 0.7494791 & 0.034006943\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 10 × 8\n", "\n", "| | abr_tipo <chr> | abr_nome <chr> | Ano <chr> | Indicador <chr> | Sim <dbl> | LowerS <dbl> | UpperS <dbl> | cvS <dbl> |\n", "|---|---|---|---|---|---|---|---|---|\n", "| S020PSim | total | Brasil | 2013 | S020P | 0.9789359 | 0.9705319 | 0.9873399 | 0.004380100 |\n", "| S020PSim1 | total | Capital | 2013 | S020P | 0.9829280 | 0.9700444 | 0.9958117 | 0.006687578 |\n", "| S021PSim | total | Brasil | 2013 | S021P | 0.6140717 | 0.5780888 | 0.6500547 | 0.029897151 |\n", "| S021PSim1 | total | Capital | 2013 | S021P | 0.6252765 | 0.5756457 | 0.6749072 | 0.040497761 |\n", "| S022PSim | total | Brasil | 2013 | S022P | 0.8780041 | 0.8550234 | 0.9009848 | 0.013354219 |\n", "| S022PSim1 | total | Capital | 2013 | S022P | 0.8651246 | 0.8294951 | 0.9007541 | 0.021012739 |\n", "| S023PSim | total | Brasil | 2013 | S023P | 0.4531967 | 0.4140386 | 0.4923548 | 0.044084608 |\n", "| S023PSim1 | total | Capital | 2013 | S023P | 0.4334754 | 0.3816977 | 0.4852531 | 0.060943851 |\n", "| S024PSim | total | Brasil | 2013 | S024P | 0.5880058 | 0.5496358 | 0.6263759 | 0.033293744 |\n", "| S024PSim1 | total | Capital | 2013 | S024P | 0.7026461 | 0.6558130 | 0.7494791 | 0.034006943 |\n", "\n" ], "text/plain": [ " abr_tipo abr_nome Ano Indicador Sim LowerS UpperS \n", "S020PSim total Brasil 2013 S020P 0.9789359 0.9705319 0.9873399\n", "S020PSim1 total Capital 2013 S020P 0.9829280 0.9700444 0.9958117\n", "S021PSim total Brasil 2013 S021P 0.6140717 0.5780888 0.6500547\n", "S021PSim1 total Capital 2013 S021P 0.6252765 0.5756457 0.6749072\n", "S022PSim total Brasil 2013 S022P 0.8780041 0.8550234 0.9009848\n", "S022PSim1 total Capital 2013 S022P 0.8651246 0.8294951 0.9007541\n", "S023PSim total Brasil 2013 S023P 0.4531967 0.4140386 0.4923548\n", "S023PSim1 total Capital 2013 S023P 0.4334754 0.3816977 0.4852531\n", "S024PSim total Brasil 2013 S024P 0.5880058 0.5496358 0.6263759\n", "S024PSim1 total Capital 2013 S024P 0.7026461 0.6558130 0.7494791\n", " cvS \n", "S020PSim 0.004380100\n", "S020PSim1 0.006687578\n", "S021PSim 0.029897151\n", "S021PSim1 0.040497761\n", "S022PSim 0.013354219\n", "S022PSim1 0.021012739\n", "S023PSim 0.044084608\n", "S023PSim1 0.060943851\n", "S024PSim 0.033293744\n", "S024PSim1 0.034006943" ] }, "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: 368 × 8
abr_tipoabr_nomeAnoIndicadorSimLowerSUpperScvS
<chr><fct><chr><chr><dbl><dbl><dbl><dbl>
Brancaraça Branca 2013S020P0.98672170.97551420.99792935.795193e-03
Pretaraça Preta 2013S020P0.97918420.95750441.00086401.129646e-02
Pardaraça Parda 2013S020P0.97275620.95902030.98649207.204506e-03
Até 1/2 SMrend_per_capitaAté 1/2 SM 2013S020P0.96755440.95124610.98386288.599757e-03
1/2 até 1 SMrend_per_capita1/2 até 1 SM 2013S020P0.98366360.97023010.99709726.967808e-03
1 até 2 SMrend_per_capita1 até 2 SM 2013S020P0.99191780.98446660.99936903.832682e-03
2 até 3 SMrend_per_capita2 até 3 SM 2013S020P1.00000001.00000001.00000002.108608e-17
Mais de 3 SMrend_per_capitaMais de 3 SM 2013S020P0.98651560.96015941.01287171.363108e-02
18 a 24 anosfx_idade_s 18 a 24 anos 2013S020P0.98620940.97427010.99814876.176763e-03
25 a 29 anosfx_idade_s 25 a 29 anos 2013S020P0.97541900.95558230.99525581.037603e-02
30 a 39 anosfx_idade_s 30 a 39 anos 2013S020P0.97252590.95769670.98735517.779802e-03
40 anos ou maisfx_idade_s 40 anos ou mais 2013S020P0.98987420.96990281.00984561.029391e-02
urbanourb_rur urbano 2013S020P0.98841320.98171240.99511403.458922e-03
ruralurb_rur rural 2013S020P0.92866190.89014440.96717952.116182e-02
Rondôniauf Rondônia 2013S020P0.94073560.88465330.99681803.041658e-02
Acreuf Acre 2013S020P0.96361300.92498171.00224432.045449e-02
Amazonasuf Amazonas 2013S020P0.93626980.89060730.98193222.488343e-02
Roraimauf Roraima 2013S020P0.96047510.91994741.00100282.152868e-02
Paráuf Pará 2013S020P0.96218340.91807761.00628912.338779e-02
Amapáuf Amapá 2013S020P0.94932960.90402790.99463142.434726e-02
Tocantinsuf Tocantins 2013S020P1.00000001.00000001.00000000.000000e+00
Maranhãouf Maranhão 2013S020P0.91309510.81145591.01473435.679331e-02
Piauíuf Piauí 2013S020P0.94719350.87360181.02078523.964076e-02
Cearáuf Ceará 2013S020P0.97631040.93046381.02215692.395911e-02
Rio Grande do Norteuf Rio Grande do Norte2013S020P0.97330740.92080981.02580502.751956e-02
Paraíbauf Paraíba 2013S020P0.97632880.94215391.01050381.785927e-02
Pernambucouf Pernambuco 2013S020P0.99576940.98742521.00411354.275394e-03
Alagoasuf Alagoas 2013S020P1.00000001.00000001.00000000.000000e+00
Sergipeuf Sergipe 2013S020P1.00000001.00000001.00000000.000000e+00
Bahiauf Bahia 2013S020P0.96766540.91914171.01618902.558470e-02
⋮⋮⋮⋮⋮⋮⋮⋮⋮
João Pessoa3capitalJoão Pessoa 2013S024P0.65557450.491927260.81922180.127361627
Recife3capitalRecife 2013S024P0.71947050.482986520.95595450.167702920
Maceió3capitalMaceió 2013S024P0.51669790.299876770.73351910.214100098
Aracaju3capitalAracaju 2013S024P0.39392260.089573230.69827200.394197088
Salvador3capitalSalvador 2013S024P0.60287620.419999240.78575320.154768570
Belo Horizonte3capitalBelo Horizonte 2013S024P0.95341340.882781771.02404510.037798103
Vitória3capitalVitória 2013S024P0.53516560.239599810.83073140.281785017
Rio de Janeiro8capitalRio de Janeiro 2013S024P0.62660700.379254660.87395940.201406137
São Paulo7capitalSão Paulo 2013S024P0.84951500.759243640.93978640.054216432
Curitiba3capitalCuritiba 2013S024P0.86705280.748361490.98574420.069843406
Florianópolis3capitalFlorianópolis 2013S024P0.93838920.825833171.05094510.061198041
Porto Alegre3capitalPorto Alegre 2013S024P0.86605000.740511510.99158840.073958091
Campo Grande3capitalCampo Grande 2013S024P0.63789140.452247050.82353580.148486480
Cuiabá3capitalCuiabá 2013S024P0.57178060.278603710.86495740.261608713
Goiânia3capitalGoiânia 2013S024P0.53262890.318191060.74706680.205413325
Brasília3capitalBrasília 2013S024P0.57415040.424882290.72341860.132645745
Fundamental incompleto ou equivalente4gescol Fundamental incompleto ou equivalente2013S024P0.52874310.454108580.60337770.072019002
Médio incompleto ou equivalente4gescol Médio incompleto ou equivalente 2013S024P0.52436170.447675700.60104770.074616852
Superior incompleto ou equivalente4gescol Superior incompleto ou equivalente 2013S024P0.62809310.566785000.68940110.049801851
Superior completo4gescol Superior completo 2013S024P0.69425920.585865360.80265300.079658996
S020PSimtotal Brasil 2013S020P0.97893590.970531870.98733990.004380100
S020PSim1total Capital 2013S020P0.98292800.970044410.99581170.006687578
S021PSimtotal Brasil 2013S021P0.61407170.578088770.65005470.029897151
S021PSim1total Capital 2013S021P0.62527650.575645670.67490720.040497761
S022PSimtotal Brasil 2013S022P0.87800410.855023370.90098480.013354219
S022PSim1total Capital 2013S022P0.86512460.829495150.90075410.021012739
S023PSimtotal Brasil 2013S023P0.45319670.414038590.49235480.044084608
S023PSim1total Capital 2013S023P0.43347540.381697730.48525310.060943851
S024PSimtotal Brasil 2013S024P0.58800580.549635760.62637590.033293744
S024PSim1total Capital 2013S024P0.70264610.655813040.74947910.034006943
\n" ], "text/latex": [ "A data.frame: 368 × 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 & S020P & 0.9867217 & 0.9755142 & 0.9979293 & 5.795193e-03\\\\\n", "\tPreta & raça & Preta & 2013 & S020P & 0.9791842 & 0.9575044 & 1.0008640 & 1.129646e-02\\\\\n", "\tParda & raça & Parda & 2013 & S020P & 0.9727562 & 0.9590203 & 0.9864920 & 7.204506e-03\\\\\n", "\tAté 1/2 SM & rend\\_per\\_capita & Até 1/2 SM & 2013 & S020P & 0.9675544 & 0.9512461 & 0.9838628 & 8.599757e-03\\\\\n", "\t1/2 até 1 SM & rend\\_per\\_capita & 1/2 até 1 SM & 2013 & S020P & 0.9836636 & 0.9702301 & 0.9970972 & 6.967808e-03\\\\\n", "\t1 até 2 SM & rend\\_per\\_capita & 1 até 2 SM & 2013 & S020P & 0.9919178 & 0.9844666 & 0.9993690 & 3.832682e-03\\\\\n", "\t2 até 3 SM & rend\\_per\\_capita & 2 até 3 SM & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 2.108608e-17\\\\\n", "\tMais de 3 SM & rend\\_per\\_capita & Mais de 3 SM & 2013 & S020P & 0.9865156 & 0.9601594 & 1.0128717 & 1.363108e-02\\\\\n", "\t18 a 24 anos & fx\\_idade\\_s & 18 a 24 anos & 2013 & S020P & 0.9862094 & 0.9742701 & 0.9981487 & 6.176763e-03\\\\\n", "\t25 a 29 anos & fx\\_idade\\_s & 25 a 29 anos & 2013 & S020P & 0.9754190 & 0.9555823 & 0.9952558 & 1.037603e-02\\\\\n", "\t30 a 39 anos & fx\\_idade\\_s & 30 a 39 anos & 2013 & S020P & 0.9725259 & 0.9576967 & 0.9873551 & 7.779802e-03\\\\\n", "\t40 anos ou mais & fx\\_idade\\_s & 40 anos ou mais & 2013 & S020P & 0.9898742 & 0.9699028 & 1.0098456 & 1.029391e-02\\\\\n", "\turbano & urb\\_rur & urbano & 2013 & S020P & 0.9884132 & 0.9817124 & 0.9951140 & 3.458922e-03\\\\\n", "\trural & urb\\_rur & rural & 2013 & S020P & 0.9286619 & 0.8901444 & 0.9671795 & 2.116182e-02\\\\\n", "\tRondônia & uf & Rondônia & 2013 & S020P & 0.9407356 & 0.8846533 & 0.9968180 & 3.041658e-02\\\\\n", "\tAcre & uf & Acre & 2013 & S020P & 0.9636130 & 0.9249817 & 1.0022443 & 2.045449e-02\\\\\n", "\tAmazonas & uf & Amazonas & 2013 & S020P & 0.9362698 & 0.8906073 & 0.9819322 & 2.488343e-02\\\\\n", "\tRoraima & uf & Roraima & 2013 & S020P & 0.9604751 & 0.9199474 & 1.0010028 & 2.152868e-02\\\\\n", "\tPará & uf & Pará & 2013 & S020P & 0.9621834 & 0.9180776 & 1.0062891 & 2.338779e-02\\\\\n", "\tAmapá & uf & Amapá & 2013 & S020P & 0.9493296 & 0.9040279 & 0.9946314 & 2.434726e-02\\\\\n", "\tTocantins & uf & Tocantins & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tMaranhão & uf & Maranhão & 2013 & S020P & 0.9130951 & 0.8114559 & 1.0147343 & 5.679331e-02\\\\\n", "\tPiauí & uf & Piauí & 2013 & S020P & 0.9471935 & 0.8736018 & 1.0207852 & 3.964076e-02\\\\\n", "\tCeará & uf & Ceará & 2013 & S020P & 0.9763104 & 0.9304638 & 1.0221569 & 2.395911e-02\\\\\n", "\tRio Grande do Norte & uf & Rio Grande do Norte & 2013 & S020P & 0.9733074 & 0.9208098 & 1.0258050 & 2.751956e-02\\\\\n", "\tParaíba & uf & Paraíba & 2013 & S020P & 0.9763288 & 0.9421539 & 1.0105038 & 1.785927e-02\\\\\n", "\tPernambuco & uf & Pernambuco & 2013 & S020P & 0.9957694 & 0.9874252 & 1.0041135 & 4.275394e-03\\\\\n", "\tAlagoas & uf & Alagoas & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tSergipe & uf & Sergipe & 2013 & S020P & 1.0000000 & 1.0000000 & 1.0000000 & 0.000000e+00\\\\\n", "\tBahia & uf & Bahia & 2013 & S020P & 0.9676654 & 0.9191417 & 1.0161890 & 2.558470e-02\\\\\n", "\t⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮ & ⋮\\\\\n", "\tJoão Pessoa3 & capital & João Pessoa & 2013 & S024P & 0.6555745 & 0.49192726 & 0.8192218 & 0.127361627\\\\\n", "\tRecife3 & capital & Recife & 2013 & S024P & 0.7194705 & 0.48298652 & 0.9559545 & 0.167702920\\\\\n", "\tMaceió3 & capital & Maceió & 2013 & S024P & 0.5166979 & 0.29987677 & 0.7335191 & 0.214100098\\\\\n", "\tAracaju3 & capital & Aracaju & 2013 & S024P & 0.3939226 & 0.08957323 & 0.6982720 & 0.394197088\\\\\n", "\tSalvador3 & capital & Salvador & 2013 & S024P & 0.6028762 & 0.41999924 & 0.7857532 & 0.154768570\\\\\n", "\tBelo Horizonte3 & capital & Belo Horizonte & 2013 & S024P & 0.9534134 & 0.88278177 & 1.0240451 & 0.037798103\\\\\n", "\tVitória3 & capital & Vitória & 2013 & S024P & 0.5351656 & 0.23959981 & 0.8307314 & 0.281785017\\\\\n", "\tRio de Janeiro8 & capital & Rio de Janeiro & 2013 & S024P & 0.6266070 & 0.37925466 & 0.8739594 & 0.201406137\\\\\n", "\tSão Paulo7 & capital & São Paulo & 2013 & S024P & 0.8495150 & 0.75924364 & 0.9397864 & 0.054216432\\\\\n", "\tCuritiba3 & capital & Curitiba & 2013 & S024P & 0.8670528 & 0.74836149 & 0.9857442 & 0.069843406\\\\\n", "\tFlorianópolis3 & capital & Florianópolis & 2013 & S024P & 0.9383892 & 0.82583317 & 1.0509451 & 0.061198041\\\\\n", "\tPorto Alegre3 & capital & Porto Alegre & 2013 & S024P & 0.8660500 & 0.74051151 & 0.9915884 & 0.073958091\\\\\n", "\tCampo Grande3 & capital & Campo Grande & 2013 & S024P & 0.6378914 & 0.45224705 & 0.8235358 & 0.148486480\\\\\n", "\tCuiabá3 & capital & Cuiabá & 2013 & S024P & 0.5717806 & 0.27860371 & 0.8649574 & 0.261608713\\\\\n", "\tGoiânia3 & capital & Goiânia & 2013 & S024P & 0.5326289 & 0.31819106 & 0.7470668 & 0.205413325\\\\\n", "\tBrasília3 & capital & Brasília & 2013 & S024P & 0.5741504 & 0.42488229 & 0.7234186 & 0.132645745\\\\\n", "\tFundamental incompleto ou equivalente4 & gescol & Fundamental incompleto ou equivalente & 2013 & S024P & 0.5287431 & 0.45410858 & 0.6033777 & 0.072019002\\\\\n", "\tMédio incompleto ou equivalente4 & gescol & Médio incompleto ou equivalente & 2013 & S024P & 0.5243617 & 0.44767570 & 0.6010477 & 0.074616852\\\\\n", "\tSuperior incompleto ou equivalente4 & gescol & Superior incompleto ou equivalente & 2013 & S024P & 0.6280931 & 0.56678500 & 0.6894011 & 0.049801851\\\\\n", "\tSuperior completo4 & gescol & Superior completo & 2013 & S024P & 0.6942592 & 0.58586536 & 0.8026530 & 0.079658996\\\\\n", "\tS020PSim & total & Brasil & 2013 & S020P & 0.9789359 & 0.97053187 & 0.9873399 & 0.004380100\\\\\n", "\tS020PSim1 & total & Capital & 2013 & S020P & 0.9829280 & 0.97004441 & 0.9958117 & 0.006687578\\\\\n", "\tS021PSim & total & Brasil & 2013 & S021P & 0.6140717 & 0.57808877 & 0.6500547 & 0.029897151\\\\\n", "\tS021PSim1 & total & Capital & 2013 & S021P & 0.6252765 & 0.57564567 & 0.6749072 & 0.040497761\\\\\n", "\tS022PSim & total & Brasil & 2013 & S022P & 0.8780041 & 0.85502337 & 0.9009848 & 0.013354219\\\\\n", "\tS022PSim1 & total & Capital & 2013 & S022P & 0.8651246 & 0.82949515 & 0.9007541 & 0.021012739\\\\\n", "\tS023PSim & total & Brasil & 2013 & S023P & 0.4531967 & 0.41403859 & 0.4923548 & 0.044084608\\\\\n", "\tS023PSim1 & total & Capital & 2013 & S023P & 0.4334754 & 0.38169773 & 0.4852531 & 0.060943851\\\\\n", "\tS024PSim & total & Brasil & 2013 & S024P & 0.5880058 & 0.54963576 & 0.6263759 & 0.033293744\\\\\n", "\tS024PSim1 & total & Capital & 2013 & S024P & 0.7026461 & 0.65581304 & 0.7494791 & 0.034006943\\\\\n", "\\end{tabular}\n" ], "text/markdown": [ "\n", "A data.frame: 368 × 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 | S020P | 0.9867217 | 0.9755142 | 0.9979293 | 5.795193e-03 |\n", "| Preta | raça | Preta | 2013 | S020P | 0.9791842 | 0.9575044 | 1.0008640 | 1.129646e-02 |\n", "| Parda | raça | Parda | 2013 | S020P | 0.9727562 | 0.9590203 | 0.9864920 | 7.204506e-03 |\n", "| Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2013 | S020P | 0.9675544 | 0.9512461 | 0.9838628 | 8.599757e-03 |\n", "| 1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2013 | S020P | 0.9836636 | 0.9702301 | 0.9970972 | 6.967808e-03 |\n", "| 1 até 2 SM | rend_per_capita | 1 até 2 SM | 2013 | S020P | 0.9919178 | 0.9844666 | 0.9993690 | 3.832682e-03 |\n", "| 2 até 3 SM | rend_per_capita | 2 até 3 SM | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 2.108608e-17 |\n", "| Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2013 | S020P | 0.9865156 | 0.9601594 | 1.0128717 | 1.363108e-02 |\n", "| 18 a 24 anos | fx_idade_s | 18 a 24 anos | 2013 | S020P | 0.9862094 | 0.9742701 | 0.9981487 | 6.176763e-03 |\n", "| 25 a 29 anos | fx_idade_s | 25 a 29 anos | 2013 | S020P | 0.9754190 | 0.9555823 | 0.9952558 | 1.037603e-02 |\n", "| 30 a 39 anos | fx_idade_s | 30 a 39 anos | 2013 | S020P | 0.9725259 | 0.9576967 | 0.9873551 | 7.779802e-03 |\n", "| 40 anos ou mais | fx_idade_s | 40 anos ou mais | 2013 | S020P | 0.9898742 | 0.9699028 | 1.0098456 | 1.029391e-02 |\n", "| urbano | urb_rur | urbano | 2013 | S020P | 0.9884132 | 0.9817124 | 0.9951140 | 3.458922e-03 |\n", "| rural | urb_rur | rural | 2013 | S020P | 0.9286619 | 0.8901444 | 0.9671795 | 2.116182e-02 |\n", "| Rondônia | uf | Rondônia | 2013 | S020P | 0.9407356 | 0.8846533 | 0.9968180 | 3.041658e-02 |\n", "| Acre | uf | Acre | 2013 | S020P | 0.9636130 | 0.9249817 | 1.0022443 | 2.045449e-02 |\n", "| Amazonas | uf | Amazonas | 2013 | S020P | 0.9362698 | 0.8906073 | 0.9819322 | 2.488343e-02 |\n", "| Roraima | uf | Roraima | 2013 | S020P | 0.9604751 | 0.9199474 | 1.0010028 | 2.152868e-02 |\n", "| Pará | uf | Pará | 2013 | S020P | 0.9621834 | 0.9180776 | 1.0062891 | 2.338779e-02 |\n", "| Amapá | uf | Amapá | 2013 | S020P | 0.9493296 | 0.9040279 | 0.9946314 | 2.434726e-02 |\n", "| Tocantins | uf | Tocantins | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Maranhão | uf | Maranhão | 2013 | S020P | 0.9130951 | 0.8114559 | 1.0147343 | 5.679331e-02 |\n", "| Piauí | uf | Piauí | 2013 | S020P | 0.9471935 | 0.8736018 | 1.0207852 | 3.964076e-02 |\n", "| Ceará | uf | Ceará | 2013 | S020P | 0.9763104 | 0.9304638 | 1.0221569 | 2.395911e-02 |\n", "| Rio Grande do Norte | uf | Rio Grande do Norte | 2013 | S020P | 0.9733074 | 0.9208098 | 1.0258050 | 2.751956e-02 |\n", "| Paraíba | uf | Paraíba | 2013 | S020P | 0.9763288 | 0.9421539 | 1.0105038 | 1.785927e-02 |\n", "| Pernambuco | uf | Pernambuco | 2013 | S020P | 0.9957694 | 0.9874252 | 1.0041135 | 4.275394e-03 |\n", "| Alagoas | uf | Alagoas | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Sergipe | uf | Sergipe | 2013 | S020P | 1.0000000 | 1.0000000 | 1.0000000 | 0.000000e+00 |\n", "| Bahia | uf | Bahia | 2013 | S020P | 0.9676654 | 0.9191417 | 1.0161890 | 2.558470e-02 |\n", "| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |\n", "| João Pessoa3 | capital | João Pessoa | 2013 | S024P | 0.6555745 | 0.49192726 | 0.8192218 | 0.127361627 |\n", "| Recife3 | capital | Recife | 2013 | S024P | 0.7194705 | 0.48298652 | 0.9559545 | 0.167702920 |\n", "| Maceió3 | capital | Maceió | 2013 | S024P | 0.5166979 | 0.29987677 | 0.7335191 | 0.214100098 |\n", "| Aracaju3 | capital | Aracaju | 2013 | S024P | 0.3939226 | 0.08957323 | 0.6982720 | 0.394197088 |\n", "| Salvador3 | capital | Salvador | 2013 | S024P | 0.6028762 | 0.41999924 | 0.7857532 | 0.154768570 |\n", "| Belo Horizonte3 | capital | Belo Horizonte | 2013 | S024P | 0.9534134 | 0.88278177 | 1.0240451 | 0.037798103 |\n", "| Vitória3 | capital | Vitória | 2013 | S024P | 0.5351656 | 0.23959981 | 0.8307314 | 0.281785017 |\n", "| Rio de Janeiro8 | capital | Rio de Janeiro | 2013 | S024P | 0.6266070 | 0.37925466 | 0.8739594 | 0.201406137 |\n", "| São Paulo7 | capital | São Paulo | 2013 | S024P | 0.8495150 | 0.75924364 | 0.9397864 | 0.054216432 |\n", "| Curitiba3 | capital | Curitiba | 2013 | S024P | 0.8670528 | 0.74836149 | 0.9857442 | 0.069843406 |\n", "| Florianópolis3 | capital | Florianópolis | 2013 | S024P | 0.9383892 | 0.82583317 | 1.0509451 | 0.061198041 |\n", "| Porto Alegre3 | capital | Porto Alegre | 2013 | S024P | 0.8660500 | 0.74051151 | 0.9915884 | 0.073958091 |\n", "| Campo Grande3 | capital | Campo Grande | 2013 | S024P | 0.6378914 | 0.45224705 | 0.8235358 | 0.148486480 |\n", "| Cuiabá3 | capital | Cuiabá | 2013 | S024P | 0.5717806 | 0.27860371 | 0.8649574 | 0.261608713 |\n", "| Goiânia3 | capital | Goiânia | 2013 | S024P | 0.5326289 | 0.31819106 | 0.7470668 | 0.205413325 |\n", "| Brasília3 | capital | Brasília | 2013 | S024P | 0.5741504 | 0.42488229 | 0.7234186 | 0.132645745 |\n", "| Fundamental incompleto ou equivalente4 | gescol | Fundamental incompleto ou equivalente | 2013 | S024P | 0.5287431 | 0.45410858 | 0.6033777 | 0.072019002 |\n", "| Médio incompleto ou equivalente4 | gescol | Médio incompleto ou equivalente | 2013 | S024P | 0.5243617 | 0.44767570 | 0.6010477 | 0.074616852 |\n", "| Superior incompleto ou equivalente4 | gescol | Superior incompleto ou equivalente | 2013 | S024P | 0.6280931 | 0.56678500 | 0.6894011 | 0.049801851 |\n", "| Superior completo4 | gescol | Superior completo | 2013 | S024P | 0.6942592 | 0.58586536 | 0.8026530 | 0.079658996 |\n", "| S020PSim | total | Brasil | 2013 | S020P | 0.9789359 | 0.97053187 | 0.9873399 | 0.004380100 |\n", "| S020PSim1 | total | Capital | 2013 | S020P | 0.9829280 | 0.97004441 | 0.9958117 | 0.006687578 |\n", "| S021PSim | total | Brasil | 2013 | S021P | 0.6140717 | 0.57808877 | 0.6500547 | 0.029897151 |\n", "| S021PSim1 | total | Capital | 2013 | S021P | 0.6252765 | 0.57564567 | 0.6749072 | 0.040497761 |\n", "| S022PSim | total | Brasil | 2013 | S022P | 0.8780041 | 0.85502337 | 0.9009848 | 0.013354219 |\n", "| S022PSim1 | total | Capital | 2013 | S022P | 0.8651246 | 0.82949515 | 0.9007541 | 0.021012739 |\n", "| S023PSim | total | Brasil | 2013 | S023P | 0.4531967 | 0.41403859 | 0.4923548 | 0.044084608 |\n", "| S023PSim1 | total | Capital | 2013 | S023P | 0.4334754 | 0.38169773 | 0.4852531 | 0.060943851 |\n", "| S024PSim | total | Brasil | 2013 | S024P | 0.5880058 | 0.54963576 | 0.6263759 | 0.033293744 |\n", "| S024PSim1 | total | Capital | 2013 | S024P | 0.7026461 | 0.65581304 | 0.7494791 | 0.034006943 |\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", "João Pessoa3 capital \n", "Recife3 capital \n", "Maceió3 capital \n", "Aracaju3 capital \n", "Salvador3 capital \n", "Belo Horizonte3 capital \n", "Vitória3 capital \n", "Rio de Janeiro8 capital \n", "São Paulo7 capital \n", "Curitiba3 capital \n", "Florianópolis3 capital \n", "Porto Alegre3 capital \n", "Campo Grande3 capital \n", "Cuiabá3 capital \n", "Goiânia3 capital \n", "Brasília3 capital \n", "Fundamental incompleto ou equivalente4 gescol \n", "Médio incompleto ou equivalente4 gescol \n", "Superior incompleto ou equivalente4 gescol \n", "Superior completo4 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", " 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", "João Pessoa3 João Pessoa \n", "Recife3 Recife \n", "Maceió3 Maceió \n", "Aracaju3 Aracaju \n", "Salvador3 Salvador \n", "Belo Horizonte3 Belo Horizonte \n", "Vitória3 Vitória \n", "Rio de Janeiro8 Rio de Janeiro \n", "São Paulo7 São Paulo \n", "Curitiba3 Curitiba \n", "Florianópolis3 Florianópolis \n", "Porto Alegre3 Porto Alegre \n", "Campo Grande3 Campo Grande \n", "Cuiabá3 Cuiabá \n", "Goiânia3 Goiânia \n", "Brasília3 Brasília \n", "Fundamental incompleto ou equivalente4 Fundamental incompleto ou equivalente\n", "Médio incompleto ou equivalente4 Médio incompleto ou equivalente \n", "Superior incompleto ou equivalente4 Superior incompleto ou equivalente \n", "Superior completo4 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", " Ano Indicador Sim LowerS \n", "Branca 2013 S020P 0.9867217 0.9755142 \n", "Preta 2013 S020P 0.9791842 0.9575044 \n", "Parda 2013 S020P 0.9727562 0.9590203 \n", "Até 1/2 SM 2013 S020P 0.9675544 0.9512461 \n", "1/2 até 1 SM 2013 S020P 0.9836636 0.9702301 \n", "1 até 2 SM 2013 S020P 0.9919178 0.9844666 \n", "2 até 3 SM 2013 S020P 1.0000000 1.0000000 \n", "Mais de 3 SM 2013 S020P 0.9865156 0.9601594 \n", "18 a 24 anos 2013 S020P 0.9862094 0.9742701 \n", "25 a 29 anos 2013 S020P 0.9754190 0.9555823 \n", "30 a 39 anos 2013 S020P 0.9725259 0.9576967 \n", "40 anos ou mais 2013 S020P 0.9898742 0.9699028 \n", "urbano 2013 S020P 0.9884132 0.9817124 \n", "rural 2013 S020P 0.9286619 0.8901444 \n", "Rondônia 2013 S020P 0.9407356 0.8846533 \n", "Acre 2013 S020P 0.9636130 0.9249817 \n", "Amazonas 2013 S020P 0.9362698 0.8906073 \n", "Roraima 2013 S020P 0.9604751 0.9199474 \n", "Pará 2013 S020P 0.9621834 0.9180776 \n", "Amapá 2013 S020P 0.9493296 0.9040279 \n", "Tocantins 2013 S020P 1.0000000 1.0000000 \n", "Maranhão 2013 S020P 0.9130951 0.8114559 \n", "Piauí 2013 S020P 0.9471935 0.8736018 \n", "Ceará 2013 S020P 0.9763104 0.9304638 \n", "Rio Grande do Norte 2013 S020P 0.9733074 0.9208098 \n", "Paraíba 2013 S020P 0.9763288 0.9421539 \n", "Pernambuco 2013 S020P 0.9957694 0.9874252 \n", "Alagoas 2013 S020P 1.0000000 1.0000000 \n", "Sergipe 2013 S020P 1.0000000 1.0000000 \n", "Bahia 2013 S020P 0.9676654 0.9191417 \n", "⋮ ⋮ ⋮ ⋮ ⋮ \n", "João Pessoa3 2013 S024P 0.6555745 0.49192726\n", "Recife3 2013 S024P 0.7194705 0.48298652\n", "Maceió3 2013 S024P 0.5166979 0.29987677\n", "Aracaju3 2013 S024P 0.3939226 0.08957323\n", "Salvador3 2013 S024P 0.6028762 0.41999924\n", "Belo Horizonte3 2013 S024P 0.9534134 0.88278177\n", "Vitória3 2013 S024P 0.5351656 0.23959981\n", "Rio de Janeiro8 2013 S024P 0.6266070 0.37925466\n", "São Paulo7 2013 S024P 0.8495150 0.75924364\n", "Curitiba3 2013 S024P 0.8670528 0.74836149\n", "Florianópolis3 2013 S024P 0.9383892 0.82583317\n", "Porto Alegre3 2013 S024P 0.8660500 0.74051151\n", "Campo Grande3 2013 S024P 0.6378914 0.45224705\n", "Cuiabá3 2013 S024P 0.5717806 0.27860371\n", "Goiânia3 2013 S024P 0.5326289 0.31819106\n", "Brasília3 2013 S024P 0.5741504 0.42488229\n", "Fundamental incompleto ou equivalente4 2013 S024P 0.5287431 0.45410858\n", "Médio incompleto ou equivalente4 2013 S024P 0.5243617 0.44767570\n", "Superior incompleto ou equivalente4 2013 S024P 0.6280931 0.56678500\n", "Superior completo4 2013 S024P 0.6942592 0.58586536\n", "S020PSim 2013 S020P 0.9789359 0.97053187\n", "S020PSim1 2013 S020P 0.9829280 0.97004441\n", "S021PSim 2013 S021P 0.6140717 0.57808877\n", "S021PSim1 2013 S021P 0.6252765 0.57564567\n", "S022PSim 2013 S022P 0.8780041 0.85502337\n", "S022PSim1 2013 S022P 0.8651246 0.82949515\n", "S023PSim 2013 S023P 0.4531967 0.41403859\n", "S023PSim1 2013 S023P 0.4334754 0.38169773\n", "S024PSim 2013 S024P 0.5880058 0.54963576\n", "S024PSim1 2013 S024P 0.7026461 0.65581304\n", " UpperS cvS \n", "Branca 0.9979293 5.795193e-03\n", "Preta 1.0008640 1.129646e-02\n", "Parda 0.9864920 7.204506e-03\n", "Até 1/2 SM 0.9838628 8.599757e-03\n", "1/2 até 1 SM 0.9970972 6.967808e-03\n", "1 até 2 SM 0.9993690 3.832682e-03\n", "2 até 3 SM 1.0000000 2.108608e-17\n", "Mais de 3 SM 1.0128717 1.363108e-02\n", "18 a 24 anos 0.9981487 6.176763e-03\n", "25 a 29 anos 0.9952558 1.037603e-02\n", "30 a 39 anos 0.9873551 7.779802e-03\n", "40 anos ou mais 1.0098456 1.029391e-02\n", "urbano 0.9951140 3.458922e-03\n", "rural 0.9671795 2.116182e-02\n", "Rondônia 0.9968180 3.041658e-02\n", "Acre 1.0022443 2.045449e-02\n", "Amazonas 0.9819322 2.488343e-02\n", "Roraima 1.0010028 2.152868e-02\n", "Pará 1.0062891 2.338779e-02\n", "Amapá 0.9946314 2.434726e-02\n", "Tocantins 1.0000000 0.000000e+00\n", "Maranhão 1.0147343 5.679331e-02\n", "Piauí 1.0207852 3.964076e-02\n", "Ceará 1.0221569 2.395911e-02\n", "Rio Grande do Norte 1.0258050 2.751956e-02\n", "Paraíba 1.0105038 1.785927e-02\n", "Pernambuco 1.0041135 4.275394e-03\n", "Alagoas 1.0000000 0.000000e+00\n", "Sergipe 1.0000000 0.000000e+00\n", "Bahia 1.0161890 2.558470e-02\n", "⋮ ⋮ ⋮ \n", "João Pessoa3 0.8192218 0.127361627 \n", "Recife3 0.9559545 0.167702920 \n", "Maceió3 0.7335191 0.214100098 \n", "Aracaju3 0.6982720 0.394197088 \n", "Salvador3 0.7857532 0.154768570 \n", "Belo Horizonte3 1.0240451 0.037798103 \n", "Vitória3 0.8307314 0.281785017 \n", "Rio de Janeiro8 0.8739594 0.201406137 \n", "São Paulo7 0.9397864 0.054216432 \n", "Curitiba3 0.9857442 0.069843406 \n", "Florianópolis3 1.0509451 0.061198041 \n", "Porto Alegre3 0.9915884 0.073958091 \n", "Campo Grande3 0.8235358 0.148486480 \n", "Cuiabá3 0.8649574 0.261608713 \n", "Goiânia3 0.7470668 0.205413325 \n", "Brasília3 0.7234186 0.132645745 \n", "Fundamental incompleto ou equivalente4 0.6033777 0.072019002 \n", "Médio incompleto ou equivalente4 0.6010477 0.074616852 \n", "Superior incompleto ou equivalente4 0.6894011 0.049801851 \n", "Superior completo4 0.8026530 0.079658996 \n", "S020PSim 0.9873399 0.004380100 \n", "S020PSim1 0.9958117 0.006687578 \n", "S021PSim 0.6500547 0.029897151 \n", "S021PSim1 0.6749072 0.040497761 \n", "S022PSim 0.9009848 0.013354219 \n", "S022PSim1 0.9007541 0.021012739 \n", "S023PSim 0.4923548 0.044084608 \n", "S023PSim1 0.4852531 0.060943851 \n", "S024PSim 0.6263759 0.033293744 \n", "S024PSim1 0.7494791 0.034006943 " ] }, "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": null, "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 }