{ "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 - módulo N 2013 Percepção do Estado de Saúde" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Bibliotecas Utilizadas" ] }, { "cell_type": "code", "execution_count": 48, "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)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Carregando microdados da PNS" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "
abr_tipo | abr_nome | Ano | Indicador | Sim | LowerS | UpperS | cvS | |
---|---|---|---|---|---|---|---|---|
<chr> | <fct> | <chr> | <chr> | <dbl> | <dbl> | <dbl> | <dbl> | |
Masculino | sexo | Masculino | 2013 | N001P | 0.7031699 | 0.6938318 | 0.7125079 | 0.006775591 |
Feminino | sexo | Feminino | 2013 | N001P | 0.6252309 | 0.6158062 | 0.6346555 | 0.007690901 |
Branca | raça | Branca | 2013 | N001P | 0.7033768 | 0.6937259 | 0.7130277 | 0.007000550 |
Preta | raça | Preta | 2013 | N001P | 0.6187419 | 0.5963304 | 0.6411533 | 0.018480452 |
Parda | raça | Parda | 2013 | N001P | 0.6242451 | 0.6137391 | 0.6347511 | 0.008586841 |
Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2013 | N001P | 0.5776641 | 0.5618607 | 0.5934675 | 0.013958136 |
1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2013 | N001P | 0.5966493 | 0.5829515 | 0.6103471 | 0.011713388 |
1 até 2 SM | rend_per_capita | 1 até 2 SM | 2013 | N001P | 0.6826010 | 0.6697993 | 0.6954027 | 0.009568687 |
2 até 3 SM | rend_per_capita | 2 até 3 SM | 2013 | N001P | 0.7709383 | 0.7521914 | 0.7896852 | 0.012406845 |
Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2013 | N001P | 0.8288350 | 0.8146985 | 0.8429716 | 0.008702155 |
18 a 29 anos | fx_idade_18 | 18 a 29 anos | 2013 | N001P | 0.8166931 | 0.8054995 | 0.8278867 | 0.006993008 |
30 a 44 anos | fx_idade_18 | 30 a 44 anos | 2013 | N001P | 0.7353775 | 0.7240642 | 0.7466907 | 0.007849279 |
45 a 59 anos | fx_idade_18 | 45 a 59 anos | 2013 | N001P | 0.5685950 | 0.5536194 | 0.5835706 | 0.013437991 |
60 a 74 anos | fx_idade_18 | 60 a 74 anos | 2013 | N001P | 0.4611766 | 0.4426399 | 0.4797132 | 0.020507618 |
75 anos ou mais | fx_idade_18 | 75 anos ou mais | 2013 | N001P | 0.3927346 | 0.3623769 | 0.4230924 | 0.039438667 |
urbano | urb_rur | urbano | 2013 | N001P | 0.6795350 | 0.6718652 | 0.6872048 | 0.005758668 |
rural | urb_rur | rural | 2013 | N001P | 0.5523207 | 0.5345585 | 0.5700828 | 0.016408042 |
Rondônia | uf | Rondônia | 2013 | N001P | 0.6192240 | 0.5820907 | 0.6563574 | 0.030596239 |
Acre | uf | Acre | 2013 | N001P | 0.6286710 | 0.5978234 | 0.6595187 | 0.025035181 |
Amazonas | uf | Amazonas | 2013 | N001P | 0.6621802 | 0.6389807 | 0.6853798 | 0.017875397 |
Roraima | uf | Roraima | 2013 | N001P | 0.6456946 | 0.6162629 | 0.6751262 | 0.023256213 |
Pará | uf | Pará | 2013 | N001P | 0.5541022 | 0.5195624 | 0.5886421 | 0.031804044 |
Amapá | uf | Amapá | 2013 | N001P | 0.6440162 | 0.6030788 | 0.6849537 | 0.032432167 |
Tocantins | uf | Tocantins | 2013 | N001P | 0.6013269 | 0.5594419 | 0.6432120 | 0.035538575 |
Maranhão | uf | Maranhão | 2013 | N001P | 0.5047935 | 0.4667728 | 0.5428143 | 0.038428973 |
Piauí | uf | Piauí | 2013 | N001P | 0.5249208 | 0.4897949 | 0.5600467 | 0.034141736 |
Ceará | uf | Ceará | 2013 | N001P | 0.6067453 | 0.5810553 | 0.6324353 | 0.021602782 |
Rio Grande do Norte | uf | Rio Grande do Norte | 2013 | N001P | 0.6255039 | 0.5945231 | 0.6564847 | 0.025270528 |
Paraíba | uf | Paraíba | 2013 | N001P | 0.5924437 | 0.5623132 | 0.6225743 | 0.025948475 |
Pernambuco | uf | Pernambuco | 2013 | N001P | 0.5806347 | 0.5575102 | 0.6037591 | 0.020319832 |
⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |
Rio Branco 1 | capital | Rio Branco | 2013 | N002P | 0.06609218 | 0.046451346 | 0.08573301 | 0.151621838 |
Manaus1 | capital | Manaus | 2013 | N002P | 0.04306712 | 0.028395484 | 0.05773876 | 0.173813951 |
Boa Vista1 | capital | Boa Vista | 2013 | N002P | 0.05661760 | 0.040754275 | 0.07248092 | 0.142953445 |
Belém1 | capital | Belém | 2013 | N002P | 0.04298639 | 0.026245838 | 0.05972693 | 0.198696692 |
Macapá1 | capital | Macapá | 2013 | N002P | 0.03953032 | 0.019958638 | 0.05910200 | 0.252609519 |
Palmas1 | capital | Palmas | 2013 | N002P | 0.03086990 | 0.015646062 | 0.04609374 | 0.251617486 |
São Luís1 | capital | São Luís | 2013 | N002P | 0.06169871 | 0.042921838 | 0.08047557 | 0.155274098 |
Teresina1 | capital | Teresina | 2013 | N002P | 0.04952244 | 0.033245818 | 0.06579906 | 0.167692687 |
Fortaleza1 | capital | Fortaleza | 2013 | N002P | 0.04603416 | 0.031660623 | 0.06040771 | 0.159307215 |
Natal1 | capital | Natal | 2013 | N002P | 0.04550725 | 0.030313653 | 0.06070084 | 0.170345976 |
João Pessoa1 | capital | João Pessoa | 2013 | N002P | 0.05956199 | 0.040695340 | 0.07842864 | 0.161613441 |
Recife1 | capital | Recife | 2013 | N002P | 0.06361240 | 0.045231652 | 0.08199315 | 0.147425742 |
Maceió1 | capital | Maceió | 2013 | N002P | 0.11058380 | 0.085831645 | 0.13533596 | 0.114201936 |
Aracaju1 | capital | Aracaju | 2013 | N002P | 0.05670612 | 0.032838051 | 0.08057418 | 0.214752999 |
Salvador1 | capital | Salvador | 2013 | N002P | 0.07083185 | 0.050677210 | 0.09098649 | 0.145177178 |
Belo Horizonte1 | capital | Belo Horizonte | 2013 | N002P | 0.02987961 | 0.019875210 | 0.03988400 | 0.170831475 |
Vitória1 | capital | Vitória | 2013 | N002P | 0.02947515 | 0.016557867 | 0.04239244 | 0.223597572 |
Rio de Janeiro3 | capital | Rio de Janeiro | 2013 | N002P | 0.03300222 | 0.021690584 | 0.04431386 | 0.174877632 |
São Paulo2 | capital | São Paulo | 2013 | N002P | 0.04393285 | 0.034354049 | 0.05351166 | 0.111243288 |
Curitiba1 | capital | Curitiba | 2013 | N002P | 0.03723600 | 0.023104395 | 0.05136761 | 0.193633454 |
Florianópolis1 | capital | Florianópolis | 2013 | N002P | 0.05219305 | 0.031333531 | 0.07305256 | 0.203912331 |
Porto Alegre1 | capital | Porto Alegre | 2013 | N002P | 0.03913161 | 0.025913026 | 0.05235019 | 0.172349132 |
Campo Grande1 | capital | Campo Grande | 2013 | N002P | 0.04002359 | 0.024653174 | 0.05539400 | 0.195939263 |
Cuiabá1 | capital | Cuiabá | 2013 | N002P | 0.01638297 | 0.006611379 | 0.02615457 | 0.304315900 |
Goiânia1 | capital | Goiânia | 2013 | N002P | 0.04115592 | 0.023711821 | 0.05860001 | 0.216255968 |
Brasília1 | capital | Brasília | 2013 | N002P | 0.04587040 | 0.035746641 | 0.05599417 | 0.112605947 |
N001PSim | total | Brasil | 2013 | N001P | 0.66194410 | 0.654841113 | 0.66904709 | 0.005474844 |
N001PSim1 | total | Capital | 2013 | N001P | 0.71821798 | 0.709425084 | 0.72701088 | 0.006246370 |
N002PSim | total | Brasil | 2013 | N002P | 0.05792560 | 0.054863078 | 0.06098811 | 0.026974908 |
N002PSim1 | total | Capital | 2013 | N002P | 0.04541273 | 0.041715521 | 0.04910994 | 0.041538254 |