{ "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 G 2019 Deficiências" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Bibliotecas Utilizadas" ] }, { "cell_type": "code", "execution_count": 6, "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": 7, "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 | 2019 | G001P | 0.06876299 | 0.06626456 | 0.07126142 | 0.01853804 |
Feminino | Sexo | Feminino | 2019 | G001P | 0.09853017 | 0.09561408 | 0.10144626 | 0.01510021 |
Branca | raça | Branca | 2019 | G001P | 0.07999505 | 0.07677933 | 0.08321078 | 0.02051011 |
Preta | raça | Preta | 2019 | G001P | 0.09701462 | 0.09100475 | 0.10302450 | 0.03160677 |
Parda | raça | Parda | 2019 | G001P | 0.08526914 | 0.08251122 | 0.08802705 | 0.01650215 |
Até 1/2 SM | rend_per_capita | Até 1/2 SM | 2019 | G001P | 0.08035596 | 0.07678659 | 0.08392534 | 0.02266346 |
1/2 até 1 SM | rend_per_capita | 1/2 até 1 SM | 2019 | G001P | 0.10716853 | 0.10303846 | 0.11129859 | 0.01966264 |
1 até 2 SM | rend_per_capita | 1 até 2 SM | 2019 | G001P | 0.08189391 | 0.07773277 | 0.08605504 | 0.02592460 |
2 até 3 SM | rend_per_capita | 2 até 3 SM | 2019 | G001P | 0.06322368 | 0.05704898 | 0.06939837 | 0.04982963 |
Mais de 3 SM | rend_per_capita | Mais de 3 SM | 2019 | G001P | 0.05252131 | 0.04737604 | 0.05766657 | 0.04998321 |
2 a 9 anos | fx_idade_def | 2 a 9 anos | 2019 | G001P | 0.01549085 | 0.01341572 | 0.01756598 | 0.06834748 |
10 a 17 anos | fx_idade_def | 10 a 17 anos | 2019 | G001P | 0.02329338 | 0.02070094 | 0.02588582 | 0.05678433 |
18 a 29 anos | fx_idade_def | 18 a 29 anos | 2019 | G001P | 0.02926698 | 0.02676564 | 0.03176833 | 0.04360616 |
30 a 39 anos | fx_idade_def | 30 a 39 anos | 2019 | G001P | 0.03645363 | 0.03366146 | 0.03924580 | 0.03907987 |
40 a 49 anos | fx_idade_def | 40 a 49 anos | 2019 | G001P | 0.08154384 | 0.07683626 | 0.08625142 | 0.02945497 |
50 a 64 anos | fx_idade_def | 50 a 64 anos | 2019 | G001P | 0.13116427 | 0.12560574 | 0.13672281 | 0.02162204 |
65 anos ou mais | fx_idade_def | 65 anos ou mais | 2019 | G001P | 0.28694909 | 0.27806553 | 0.29583265 | 0.01579552 |
Urbano | urb_rur | Urbano | 2019 | G001P | 0.08217060 | 0.07965910 | 0.08468210 | 0.01559440 |
Rural | urb_rur | Rural | 2019 | G001P | 0.09694166 | 0.09243614 | 0.10144718 | 0.02371299 |
Rondônia | uf | Rondônia | 2019 | G001P | 0.08395773 | 0.07400925 | 0.09390622 | 0.06045721 |
Acre | uf | Acre | 2019 | G001P | 0.07639284 | 0.06825344 | 0.08453224 | 0.05436153 |
Amazonas | uf | Amazonas | 2019 | G001P | 0.06158896 | 0.05358249 | 0.06959543 | 0.06632698 |
Roraima | uf | Roraima | 2019 | G001P | 0.05858155 | 0.05182491 | 0.06533818 | 0.05884663 |
Pará | uf | Pará | 2019 | G001P | 0.08174177 | 0.07410606 | 0.08937748 | 0.04766037 |
Amapá | uf | Amapá | 2019 | G001P | 0.07068705 | 0.06164668 | 0.07972742 | 0.06525266 |
Tocantins | uf | Tocantins | 2019 | G001P | 0.09333447 | 0.08197745 | 0.10469149 | 0.06208322 |
Maranhão | uf | Maranhão | 2019 | G001P | 0.08998896 | 0.08439297 | 0.09558494 | 0.03172776 |
Piauí | uf | Piauí | 2019 | G001P | 0.09661178 | 0.08707333 | 0.10615024 | 0.05037322 |
Ceará | uf | Ceará | 2019 | G001P | 0.10615455 | 0.09948696 | 0.11282214 | 0.03204660 |
Rio Grande do Norte | uf | Rio Grande do Norte | 2019 | G001P | 0.08872197 | 0.07894520 | 0.09849873 | 0.05622323 |
⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |
G002PSim | total | Brasil | 2019 | G002P | 0.034094806 | 0.032792956 | 0.035396655 | 0.019481596 |
G002PSim1 | total | Capital | 2019 | G002P | 0.026171079 | 0.024518239 | 0.027823918 | 0.032222631 |
G003PSim | total | Brasil | 2019 | G003P | 0.011385960 | 0.010684699 | 0.012087220 | 0.031423998 |
G003PSim1 | total | Capital | 2019 | G003P | 0.009152011 | 0.008278781 | 0.010025242 | 0.048681524 |
G004PSim | total | Brasil | 2019 | G004P | 0.049206361 | 0.047589351 | 0.050823372 | 0.016766540 |
G004PSim1 | total | Capital | 2019 | G004P | 0.041627708 | 0.039562127 | 0.043693288 | 0.025316954 |
G005PSim | total | Brasil | 2019 | G005P | 0.011995144 | 0.011265723 | 0.012724565 | 0.031025922 |
G005PSim1 | total | Capital | 2019 | G005P | 0.010705850 | 0.009772194 | 0.011639507 | 0.044495695 |
G006PSim | total | Brasil | 2019 | G006P | 0.018410817 | 0.017524674 | 0.019296960 | 0.024557409 |
G006PSim1 | total | Capital | 2019 | G006P | 0.014514154 | 0.013416934 | 0.015611374 | 0.038570381 |
G007PSim | total | Brasil | 2019 | G007P | 0.157539436 | 0.152594965 | 0.162483907 | 0.016013361 |
G007PSim1 | total | Capital | 2019 | G007P | 0.194515864 | 0.185813844 | 0.203217885 | 0.022825326 |
G008PSim | total | Brasil | 2019 | G008P | 0.514286874 | 0.494363526 | 0.534210221 | 0.019765544 |
G008PSim1 | total | Capital | 2019 | G008P | 0.370720986 | 0.347887955 | 0.393554017 | 0.031424494 |
G009PSim | total | Brasil | 2019 | G009P | 0.056866723 | 0.053331610 | 0.060401836 | 0.031717358 |
G009PSim1 | total | Capital | 2019 | G009P | 0.045419329 | 0.041364626 | 0.049474031 | 0.045548090 |
G010PSim | total | Brasil | 2019 | G010P | 0.008461287 | 0.007866075 | 0.009056499 | 0.035891132 |
G010PSim1 | total | Capital | 2019 | G010P | 0.009315305 | 0.008397101 | 0.010233508 | 0.050291414 |
G011PSim | total | Brasil | 2019 | G011P | 0.021632406 | 0.020501638 | 0.022763174 | 0.026669852 |
G011PSim1 | total | Capital | 2019 | G011P | 0.020226848 | 0.018788645 | 0.021665051 | 0.036278047 |
G012PSim | total | Brasil | 2019 | G012P | 0.403862900 | 0.399067474 | 0.408658326 | 0.006058222 |
G012PSim1 | total | Capital | 2019 | G012P | 0.467985087 | 0.460043729 | 0.475926446 | 0.008657942 |
G013PSim | total | Brasil | 2019 | G013P | 0.038027815 | 0.036670394 | 0.039385237 | 0.018212318 |
G013PSim1 | total | Capital | 2019 | G013P | 0.032640602 | 0.030856618 | 0.034424585 | 0.027885898 |
G014PSim | total | Brasil | 2019 | G014P | 0.026660774 | 0.025492968 | 0.027828580 | 0.022348577 |
G014PSim1 | total | Capital | 2019 | G014P | 0.021654599 | 0.020267243 | 0.023041955 | 0.032688098 |
G015PSim | total | Brasil | 2019 | G015P | 0.017048327 | 0.016183226 | 0.017913428 | 0.025890290 |
G015PSim1 | total | Capital | 2019 | G015P | 0.016545827 | 0.015317801 | 0.017773852 | 0.037867859 |
G016PSim | total | Brasil | 2019 | G016P | 0.005228241 | 0.004362568 | 0.006093914 | 0.084479260 |
G016PSim1 | total | Capital | 2019 | G016P | 0.004150856 | 0.003363644 | 0.004938067 | 0.096762172 |