Mod09 - Tarefa1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"https://raw.githubusercontent.com/rhatiro/Curso_EBAC-Profissao_Cientista_de_Dados/main/ebac-course-utils/media/logo/newebac_logo_black_half.png\" alt=\"ebac-logo\">\n",
    "\n",
    "---\n",
    "\n",
    "# **Profissão: Cientista de Dados**\n",
    "### **Módulo 9** | Exercício 1\n",
    "\n",
    "Aluno [Lays Félix](https://www.linkedin.com/in/laysfelixbusiness)<br>\n",
    "Data: 17 de janeiro de 2023\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. Importando bibliotecas <a name=\"import\"></a>\n",
    "\n",
    "<div style=\"text-align: right\"\n",
    "     \n",
    "[Voltar ao índice](#Contents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-06-06T21:12:37.298706Z",
     "start_time": "2021-06-06T21:12:36.656481Z"
    }
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2. Carregando o dataframe SINASC <a name=\"read\"></a>\n",
    "<div style=\"text-align: right\"\n",
    "     \n",
    "[Voltar ao índice](#Contents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-06-06T21:12:37.762376Z",
     "start_time": "2021-06-06T21:12:37.728383Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2679477.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2679477.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2679477.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>513205.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>2516500.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>231205.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alto Alegre dos Parecis</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-12.13178</td>\n",
       "      <td>-61.85308</td>\n",
       "      <td>397.0</td>\n",
       "      <td>3958.273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>2516500.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "0       1  2679477.0      110001        1        19        5.0   \n",
       "1       1  2679477.0      110001        1        29        2.0   \n",
       "2       1  2679477.0      110001        1        37        9.0   \n",
       "3       1  2516500.0      110001        1        30        5.0   \n",
       "4       1  2516500.0      110001        1        30        2.0   \n",
       "\n",
       "            ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "0      8 a 11 anos         NaN         0.0         0.0  ...           5   \n",
       "1      8 a 11 anos    999992.0         1.0         0.0  ...           5   \n",
       "2      8 a 11 anos    513205.0         2.0         0.0  ...           5   \n",
       "3  12 anos ou mais    231205.0         0.0         0.0  ...           4   \n",
       "4      8 a 11 anos    999992.0         1.0         0.0  ...           5   \n",
       "\n",
       "  CONTADOR munResStatus munResTipo               munResNome  munResUf  \\\n",
       "0        1        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "1        2        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "2        3        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "3        4        ATIVO      MUNIC  Alto Alegre dos Parecis  Rondônia   \n",
       "4        5        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "\n",
       "   munResLat munResLon  munResAlt  munResArea  \n",
       "0  -11.93554 -61.99982      338.0    7067.025  \n",
       "1  -11.93554 -61.99982      338.0    7067.025  \n",
       "2  -11.93554 -61.99982      338.0    7067.025  \n",
       "3  -12.13178 -61.85308      397.0    3958.273  \n",
       "4  -11.93554 -61.99982      338.0    7067.025  \n",
       "\n",
       "[5 rows x 69 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sinasc_raw = pd.read_csv('RO_2019.csv')\n",
    "sinasc_raw.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tarefa 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Idade media das mães e dos pais por município (coluna munResNome)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>munResNome</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>IDADEPAI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>19</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>29</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>37</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alto Alegre dos Parecis</td>\n",
       "      <td>30</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>30</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                munResNome  IDADEMAE  IDADEPAI\n",
       "0    Alta Floresta D'Oeste        19      26.0\n",
       "1    Alta Floresta D'Oeste        29      24.0\n",
       "2    Alta Floresta D'Oeste        37      32.0\n",
       "3  Alto Alegre dos Parecis        30      24.0\n",
       "4    Alta Floresta D'Oeste        30      27.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecionando só as colunas que preciso\n",
    "\n",
    "sinasc_1 = sinasc_raw[['munResNome', 'IDADEMAE','IDADEPAI']]\n",
    "sinasc_1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>IDADEPAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>munResNome</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alta Floresta D'Oeste</th>\n",
       "      <td>25.991826</td>\n",
       "      <td>29.548701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alto Alegre dos Parecis</th>\n",
       "      <td>24.844156</td>\n",
       "      <td>29.179104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alto Paraíso</th>\n",
       "      <td>24.960177</td>\n",
       "      <td>28.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alvorada D'Oeste</th>\n",
       "      <td>25.770732</td>\n",
       "      <td>30.757282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ariquemes</th>\n",
       "      <td>25.607866</td>\n",
       "      <td>32.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Buritis</th>\n",
       "      <td>25.559177</td>\n",
       "      <td>30.812500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cabixi</th>\n",
       "      <td>26.037500</td>\n",
       "      <td>34.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cacaulândia</th>\n",
       "      <td>25.546667</td>\n",
       "      <td>36.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cacoal</th>\n",
       "      <td>26.890102</td>\n",
       "      <td>30.931854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Campo Novo de Rondônia</th>\n",
       "      <td>24.825301</td>\n",
       "      <td>30.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Candeias do Jamari</th>\n",
       "      <td>25.243323</td>\n",
       "      <td>29.894737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Castanheiras</th>\n",
       "      <td>27.281250</td>\n",
       "      <td>30.392857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerejeiras</th>\n",
       "      <td>27.240506</td>\n",
       "      <td>31.652778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chupinguaia</th>\n",
       "      <td>25.333333</td>\n",
       "      <td>29.629630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colorado do Oeste</th>\n",
       "      <td>27.602804</td>\n",
       "      <td>34.354839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Corumbiara</th>\n",
       "      <td>24.716535</td>\n",
       "      <td>32.470588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Costa Marques</th>\n",
       "      <td>24.412017</td>\n",
       "      <td>30.613636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cujubim</th>\n",
       "      <td>24.482927</td>\n",
       "      <td>31.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Espigão D'Oeste</th>\n",
       "      <td>26.093333</td>\n",
       "      <td>31.198113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Governador Jorge Teixeira</th>\n",
       "      <td>24.401786</td>\n",
       "      <td>29.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guajará-Mirim</th>\n",
       "      <td>25.462228</td>\n",
       "      <td>30.470588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Itapuã do Oeste</th>\n",
       "      <td>26.064220</td>\n",
       "      <td>42.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jaru</th>\n",
       "      <td>25.982974</td>\n",
       "      <td>32.197183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ji-Paraná</th>\n",
       "      <td>26.361137</td>\n",
       "      <td>31.132239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Machadinho D'Oeste</th>\n",
       "      <td>25.480000</td>\n",
       "      <td>31.326923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ministro Andreazza</th>\n",
       "      <td>27.904762</td>\n",
       "      <td>33.849315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mirante da Serra</th>\n",
       "      <td>26.304878</td>\n",
       "      <td>32.154762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monte Negro</th>\n",
       "      <td>25.648241</td>\n",
       "      <td>34.678571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Município ignorado - RO</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>22.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nova Brasilândia D'Oeste</th>\n",
       "      <td>26.222222</td>\n",
       "      <td>30.520833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nova Mamoré</th>\n",
       "      <td>25.326389</td>\n",
       "      <td>31.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nova União</th>\n",
       "      <td>26.894231</td>\n",
       "      <td>31.371429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Novo Horizonte do Oeste</th>\n",
       "      <td>26.938776</td>\n",
       "      <td>31.588235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ouro Preto do Oeste</th>\n",
       "      <td>26.375594</td>\n",
       "      <td>31.233244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parecis</th>\n",
       "      <td>26.454545</td>\n",
       "      <td>32.473684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pimenta Bueno</th>\n",
       "      <td>25.199675</td>\n",
       "      <td>29.745174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pimenteiras do Oeste</th>\n",
       "      <td>25.075000</td>\n",
       "      <td>35.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Porto Velho</th>\n",
       "      <td>26.312670</td>\n",
       "      <td>32.352679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Presidente Médici</th>\n",
       "      <td>25.796053</td>\n",
       "      <td>30.150754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Primavera de Rondônia</th>\n",
       "      <td>27.023256</td>\n",
       "      <td>31.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rio Crespo</th>\n",
       "      <td>26.660000</td>\n",
       "      <td>28.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rolim de Moura</th>\n",
       "      <td>26.600863</td>\n",
       "      <td>30.360479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Santa Luzia D'Oeste</th>\n",
       "      <td>26.121212</td>\n",
       "      <td>30.703297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Seringueiras</th>\n",
       "      <td>24.910714</td>\n",
       "      <td>30.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>São Felipe D'Oeste</th>\n",
       "      <td>26.481481</td>\n",
       "      <td>31.395833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>São Francisco do Guaporé</th>\n",
       "      <td>25.660066</td>\n",
       "      <td>31.638889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>São Miguel do Guaporé</th>\n",
       "      <td>25.926346</td>\n",
       "      <td>32.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Teixeirópolis</th>\n",
       "      <td>26.031250</td>\n",
       "      <td>31.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theobroma</th>\n",
       "      <td>25.536082</td>\n",
       "      <td>30.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Urupá</th>\n",
       "      <td>26.688235</td>\n",
       "      <td>31.008929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vale do Anari</th>\n",
       "      <td>26.096774</td>\n",
       "      <td>34.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vale do Paraíso</th>\n",
       "      <td>25.679012</td>\n",
       "      <td>29.976744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vilhena</th>\n",
       "      <td>26.433962</td>\n",
       "      <td>34.152941</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            IDADEMAE   IDADEPAI\n",
       "munResNome                                     \n",
       "Alta Floresta D'Oeste      25.991826  29.548701\n",
       "Alto Alegre dos Parecis    24.844156  29.179104\n",
       "Alto Paraíso               24.960177  28.833333\n",
       "Alvorada D'Oeste           25.770732  30.757282\n",
       "Ariquemes                  25.607866  32.466667\n",
       "Buritis                    25.559177  30.812500\n",
       "Cabixi                     26.037500  34.333333\n",
       "Cacaulândia                25.546667  36.333333\n",
       "Cacoal                     26.890102  30.931854\n",
       "Campo Novo de Rondônia     24.825301  30.500000\n",
       "Candeias do Jamari         25.243323  29.894737\n",
       "Castanheiras               27.281250  30.392857\n",
       "Cerejeiras                 27.240506  31.652778\n",
       "Chupinguaia                25.333333  29.629630\n",
       "Colorado do Oeste          27.602804  34.354839\n",
       "Corumbiara                 24.716535  32.470588\n",
       "Costa Marques              24.412017  30.613636\n",
       "Cujubim                    24.482927  31.400000\n",
       "Espigão D'Oeste            26.093333  31.198113\n",
       "Governador Jorge Teixeira  24.401786  29.222222\n",
       "Guajará-Mirim              25.462228  30.470588\n",
       "Itapuã do Oeste            26.064220  42.500000\n",
       "Jaru                       25.982974  32.197183\n",
       "Ji-Paraná                  26.361137  31.132239\n",
       "Machadinho D'Oeste         25.480000  31.326923\n",
       "Ministro Andreazza         27.904762  33.849315\n",
       "Mirante da Serra           26.304878  32.154762\n",
       "Monte Negro                25.648241  34.678571\n",
       "Município ignorado - RO    24.000000  22.000000\n",
       "Nova Brasilândia D'Oeste   26.222222  30.520833\n",
       "Nova Mamoré                25.326389  31.692308\n",
       "Nova União                 26.894231  31.371429\n",
       "Novo Horizonte do Oeste    26.938776  31.588235\n",
       "Ouro Preto do Oeste        26.375594  31.233244\n",
       "Parecis                    26.454545  32.473684\n",
       "Pimenta Bueno              25.199675  29.745174\n",
       "Pimenteiras do Oeste       25.075000  35.600000\n",
       "Porto Velho                26.312670  32.352679\n",
       "Presidente Médici          25.796053  30.150754\n",
       "Primavera de Rondônia      27.023256  31.888889\n",
       "Rio Crespo                 26.660000  28.000000\n",
       "Rolim de Moura             26.600863  30.360479\n",
       "Santa Luzia D'Oeste        26.121212  30.703297\n",
       "Seringueiras               24.910714  30.500000\n",
       "São Felipe D'Oeste         26.481481  31.395833\n",
       "São Francisco do Guaporé   25.660066  31.638889\n",
       "São Miguel do Guaporé      25.926346  32.666667\n",
       "Teixeirópolis              26.031250  31.500000\n",
       "Theobroma                  25.536082  30.083333\n",
       "Urupá                      26.688235  31.008929\n",
       "Vale do Anari              26.096774  34.000000\n",
       "Vale do Paraíso            25.679012  29.976744\n",
       "Vilhena                    26.433962  34.152941"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Fazendo a média das idades dos pais por município\n",
    "\n",
    "sinasc_1.groupby('munResNome').mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. Peso médio dos bebes por sexo que nasceram no dia do seu aniversário por faixas de escolaridade mae\n",
    "Ex: Você, aluna(o), nasceu no dia 10/01, então você precisa filtrar o conjunto de dados nessa data e calcular o peso médio dos bebês de cada sexo por faixa de escolaridade da mãe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PESO</th>\n",
       "      <th>SEXO</th>\n",
       "      <th>DTNASC</th>\n",
       "      <th>ESCMAE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3685</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-02-19</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3055</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-02-21</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3460</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-02-25</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2982</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-03-20</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3310</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-03-23</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   PESO       SEXO      DTNASC           ESCMAE\n",
       "0  3685  Masculino  2019-02-19      8 a 11 anos\n",
       "1  3055   Feminino  2019-02-21      8 a 11 anos\n",
       "2  3460   Feminino  2019-02-25      8 a 11 anos\n",
       "3  2982   Feminino  2019-03-20  12 anos ou mais\n",
       "4  3310   Feminino  2019-03-23      8 a 11 anos"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecionando só as colunas que preciso\n",
    "\n",
    "sinasc_2 = sinasc_raw[['PESO', 'SEXO', 'DTNASC', 'ESCMAE']]\n",
    "sinasc_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PESO</th>\n",
       "      <th>SEXO</th>\n",
       "      <th>DTNASC</th>\n",
       "      <th>ESCMAE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13799</th>\n",
       "      <td>3240</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14470</th>\n",
       "      <td>3560</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14521</th>\n",
       "      <td>3410</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14522</th>\n",
       "      <td>3405</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14561</th>\n",
       "      <td>2150</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26361</th>\n",
       "      <td>3930</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26362</th>\n",
       "      <td>3780</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26384</th>\n",
       "      <td>3290</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26582</th>\n",
       "      <td>4005</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26708</th>\n",
       "      <td>2830</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       PESO       SEXO      DTNASC           ESCMAE\n",
       "13799  3240  Masculino  2019-10-16  12 anos ou mais\n",
       "14470  3560   Feminino  2019-10-16      8 a 11 anos\n",
       "14521  3410  Masculino  2019-10-16  12 anos ou mais\n",
       "14522  3405  Masculino  2019-10-16  12 anos ou mais\n",
       "14561  2150  Masculino  2019-10-16  12 anos ou mais\n",
       "...     ...        ...         ...              ...\n",
       "26361  3930   Feminino  2019-10-16      8 a 11 anos\n",
       "26362  3780  Masculino  2019-10-16      8 a 11 anos\n",
       "26384  3290   Feminino  2019-10-16       4 a 7 anos\n",
       "26582  4005   Feminino  2019-10-16      8 a 11 anos\n",
       "26708  2830   Feminino  2019-10-16  12 anos ou mais\n",
       "\n",
       "[85 rows x 4 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Criei um nova DF só com 'DTNASC' == '2019-10-16'\n",
    "\n",
    "niver = sinasc_2[sinasc_2['DTNASC'] == '2019-10-16']\n",
    "niver"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>SEXO</th>\n",
       "      <th>Feminino</th>\n",
       "      <th>Masculino</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESCMAE</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1 a 3 anos</th>\n",
       "      <td>2800.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 anos ou mais</th>\n",
       "      <td>3096.500000</td>\n",
       "      <td>3105.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 a 7 anos</th>\n",
       "      <td>3374.166667</td>\n",
       "      <td>3203.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8 a 11 anos</th>\n",
       "      <td>3331.464286</td>\n",
       "      <td>3431.052632</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "SEXO                Feminino    Masculino\n",
       "ESCMAE                                   \n",
       "1 a 3 anos       2800.000000          NaN\n",
       "12 anos ou mais  3096.500000  3105.000000\n",
       "4 a 7 anos       3374.166667  3203.888889\n",
       "8 a 11 anos      3331.464286  3431.052632"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Peso médio dos bebes por sexo que nasceram no meu niver por faixas de escolaridade mae\n",
    "\n",
    "niver.groupby(['ESCMAE', 'SEXO'])['PESO'].mean().unstack()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ESCMAE           SEXO     \n",
       "1 a 3 anos       Feminino     2800.000000\n",
       "12 anos ou mais  Feminino     3096.500000\n",
       "                 Masculino    3105.000000\n",
       "4 a 7 anos       Feminino     3374.166667\n",
       "                 Masculino    3203.888889\n",
       "8 a 11 anos      Feminino     3331.464286\n",
       "                 Masculino    3431.052632\n",
       "Name: PESO, dtype: float64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mesmo comando, porém sem unstack. \n",
    "# Observe que não exibe dados para Masculino na ESCMAE = 1 a 3 anos, confirmando o \"NaN\" acima.\n",
    "\n",
    "niver.groupby(['ESCMAE', 'SEXO'])['PESO'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ESCMAE           SEXO     \n",
       "1 a 3 anos       Feminino     3126.363636\n",
       "                 Masculino    3191.354386\n",
       "12 anos ou mais  Feminino     3182.427912\n",
       "                 Masculino    3309.658421\n",
       "4 a 7 anos       Feminino     3158.036123\n",
       "                 Masculino    3288.963439\n",
       "8 a 11 anos      Feminino     3193.250588\n",
       "                 Masculino    3305.898320\n",
       "Nenhuma          Feminino     2972.333333\n",
       "                 Masculino    3178.181818\n",
       "Name: PESO, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Como exemplo, executando o mesmo comando, porém consultando tada a base\n",
    "\n",
    "sinasc_2.groupby(['ESCMAE', 'SEXO'])['PESO'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. Qual o municipio que nasceu menos bebe em 2019?\n",
    "    - qual a idade media, maxima, minima das maes nesse municipio?\n",
    "    - qual a idade media, maxima, minima dos pais nesse municipio?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Porto Velho                  8437\n",
       "Ji-Paraná                    2182\n",
       "Ariquemes                    1729\n",
       "Vilhena                      1590\n",
       "Cacoal                       1374\n",
       "Rolim de Moura                927\n",
       "Jaru                          881\n",
       "Guajará-Mirim                 781\n",
       "Ouro Preto do Oeste           631\n",
       "Pimenta Bueno                 616\n",
       "Buritis                       583\n",
       "Machadinho D'Oeste            500\n",
       "Espigão D'Oeste               450\n",
       "Nova Mamoré                   432\n",
       "Alta Floresta D'Oeste         367\n",
       "São Miguel do Guaporé         353\n",
       "Candeias do Jamari            337\n",
       "Presidente Médici             304\n",
       "São Francisco do Guaporé      303\n",
       "Nova Brasilândia D'Oeste      261\n",
       "Cerejeiras                    237\n",
       "Costa Marques                 233\n",
       "Alto Paraíso                  226\n",
       "Colorado do Oeste             214\n",
       "Alvorada D'Oeste              205\n",
       "Cujubim                       205\n",
       "Monte Negro                   199\n",
       "Urupá                         170\n",
       "Seringueiras                  168\n",
       "Campo Novo de Rondônia        166\n",
       "Mirante da Serra              164\n",
       "Chupinguaia                   162\n",
       "Alto Alegre dos Parecis       154\n",
       "Corumbiara                    127\n",
       "Governador Jorge Teixeira     112\n",
       "Itapuã do Oeste               109\n",
       "Nova União                    104\n",
       "Santa Luzia D'Oeste            99\n",
       "Novo Horizonte do Oeste        98\n",
       "Theobroma                      97\n",
       "Vale do Anari                  93\n",
       "Ministro Andreazza             84\n",
       "Vale do Paraíso                81\n",
       "Cabixi                         80\n",
       "Cacaulândia                    75\n",
       "Teixeirópolis                  64\n",
       "São Felipe D'Oeste             54\n",
       "Rio Crespo                     50\n",
       "Parecis                        44\n",
       "Primavera de Rondônia          43\n",
       "Pimenteiras do Oeste           40\n",
       "Castanheiras                   32\n",
       "Município ignorado - RO         1\n",
       "Name: munResNome, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sinasc_raw.munResNome.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Resposta: desconsiderando o município 'Município ignorado - RO'\n",
    "### Castanheiras"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>1</td>\n",
       "      <td>2496046.0</td>\n",
       "      <td>110004</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>2087</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>1</td>\n",
       "      <td>7648693.0</td>\n",
       "      <td>110004</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2323</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4512</th>\n",
       "      <td>1</td>\n",
       "      <td>2495279.0</td>\n",
       "      <td>110012</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>521135.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>4538</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5881</th>\n",
       "      <td>1</td>\n",
       "      <td>2516047.0</td>\n",
       "      <td>110018</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5913</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5952</th>\n",
       "      <td>1</td>\n",
       "      <td>2516047.0</td>\n",
       "      <td>110018</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5984</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10762</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10842</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10768</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10848</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10882</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10963</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10962</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11043</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10988</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11069</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10997</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11078</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11017</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>251605.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11098</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11175</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>11256</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11196</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>11277</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11293</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11374</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11354</th>\n",
       "      <td>1</td>\n",
       "      <td>2516594.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>11435</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11371</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>421125.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11452</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17441</th>\n",
       "      <td>1</td>\n",
       "      <td>3152928.0</td>\n",
       "      <td>110012</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>252105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1483994</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24282</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1490901</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24288</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1490907</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24299</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1490918</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24316</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1490935</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24486</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1491105</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24507</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491127</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24517</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>422105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491137</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24528</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491148</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24605</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491225</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24639</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491259</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24674</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491294</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24715</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491335</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24781</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1491401</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24863</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1491483</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "2067        1  2496046.0      110004        1        18        1.0   \n",
       "2300        1  7648693.0      110004        1        31        5.0   \n",
       "4512        1  2495279.0      110012        1        22        1.0   \n",
       "5881        1  2516047.0      110018        1        26        2.0   \n",
       "5952        1  2516047.0      110018        1        32        1.0   \n",
       "10762       1  2495228.0      110028        1        21        1.0   \n",
       "10768       1  2495228.0      110028        1        31        5.0   \n",
       "10882       1  2495228.0      110028        1        23        2.0   \n",
       "10962       1  2495228.0      110028        1        29        1.0   \n",
       "10988       1  2495228.0      110028        1        31        2.0   \n",
       "10997       1  2495228.0      110028        1        35        4.0   \n",
       "11017       1  2495228.0      110028        1        27        1.0   \n",
       "11175       1  2495228.0      110028        1        24        1.0   \n",
       "11196       1  2495228.0      110028        1        27        2.0   \n",
       "11293       1  2495228.0      110028        1        25        1.0   \n",
       "11354       1  2516594.0      110028        1        34        5.0   \n",
       "11371       1  2495228.0      110028        1        21        5.0   \n",
       "17441       1  3152928.0      110012        1        39        2.0   \n",
       "24282       1  2495228.0      110028        1        28        5.0   \n",
       "24288       1  2495228.0      110028        1        27        2.0   \n",
       "24299       1  2495228.0      110028        1        30        2.0   \n",
       "24316       1  2495228.0      110028        1        17        5.0   \n",
       "24486       1  2495228.0      110028        1        35        1.0   \n",
       "24507       1  2495228.0      110028        1        27        5.0   \n",
       "24517       1  2495228.0      110028        1        27        5.0   \n",
       "24528       1  2495228.0      110028        1        25        1.0   \n",
       "24605       1  2495228.0      110028        1        32        2.0   \n",
       "24639       1  2495228.0      110028        1        18        1.0   \n",
       "24674       1  2495228.0      110028        1        27        1.0   \n",
       "24715       1  2495228.0      110028        1        32        2.0   \n",
       "24781       1  2495228.0      110028        1        22        2.0   \n",
       "24863       1  2495228.0      110028        1        30        5.0   \n",
       "\n",
       "                ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "2067       8 a 11 anos    999992.0         0.0         0.0  ...           3   \n",
       "2300       8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "4512       8 a 11 anos    521135.0         0.0         0.0  ...           2   \n",
       "5881       8 a 11 anos         NaN         0.0         0.0  ...           5   \n",
       "5952   12 anos ou mais         NaN         2.0         0.0  ...           5   \n",
       "10762      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "10768      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "10882      8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "10962      8 a 11 anos    621005.0         3.0         0.0  ...           5   \n",
       "10988      8 a 11 anos    999992.0         1.0         1.0  ...           5   \n",
       "10997      8 a 11 anos    621005.0         2.0         0.0  ...           5   \n",
       "11017  12 anos ou mais    251605.0         1.0         0.0  ...           5   \n",
       "11175       4 a 7 anos    999992.0         2.0         0.0  ...           4   \n",
       "11196       4 a 7 anos    621005.0         1.0         0.0  ...           3   \n",
       "11293      8 a 11 anos    621005.0         2.0         1.0  ...           5   \n",
       "11354  12 anos ou mais    621005.0         1.0         0.0  ...           2   \n",
       "11371      8 a 11 anos    421125.0         0.0         0.0  ...           5   \n",
       "17441  12 anos ou mais    252105.0         0.0         0.0  ...           5   \n",
       "24282      8 a 11 anos    621005.0         1.0         0.0  ...           9   \n",
       "24288      8 a 11 anos    621005.0         2.0         0.0  ...           5   \n",
       "24299       4 a 7 anos    999992.0         2.0         0.0  ...           5   \n",
       "24316       4 a 7 anos    999992.0         0.0         0.0  ...           4   \n",
       "24486       4 a 7 anos    999992.0         6.0         1.0  ...           2   \n",
       "24507      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "24517  12 anos ou mais    422105.0         0.0         0.0  ...           5   \n",
       "24528      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "24605      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "24639       4 a 7 anos    621005.0         0.0         0.0  ...           5   \n",
       "24674      8 a 11 anos    999992.0         1.0         0.0  ...           5   \n",
       "24715      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "24781      8 a 11 anos    621005.0         2.0         0.0  ...           9   \n",
       "24863      8 a 11 anos    621005.0         2.0         0.0  ...           4   \n",
       "\n",
       "      CONTADOR munResStatus munResTipo    munResNome  munResUf  munResLat  \\\n",
       "2067      2087        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "2300      2323        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "4512      4538        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "5881      5913        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "5952      5984        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10762    10842        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10768    10848        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10882    10963        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10962    11043        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10988    11069        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10997    11078        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11017    11098        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11175    11256        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11196    11277        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11293    11374        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11354    11435        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11371    11452        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "17441  1483994        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24282  1490901        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24288  1490907        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24299  1490918        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24316  1490935        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24486  1491105        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24507  1491127        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24517  1491137        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24528  1491148        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24605  1491225        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24639  1491259        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24674  1491294        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24715  1491335        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24781  1491401        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24863  1491483        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "\n",
       "      munResLon  munResAlt  munResArea  \n",
       "2067  -61.94916      215.0     892.842  \n",
       "2300  -61.94916      215.0     892.842  \n",
       "4512  -61.94916      215.0     892.842  \n",
       "5881  -61.94916      215.0     892.842  \n",
       "5952  -61.94916      215.0     892.842  \n",
       "10762 -61.94916      215.0     892.842  \n",
       "10768 -61.94916      215.0     892.842  \n",
       "10882 -61.94916      215.0     892.842  \n",
       "10962 -61.94916      215.0     892.842  \n",
       "10988 -61.94916      215.0     892.842  \n",
       "10997 -61.94916      215.0     892.842  \n",
       "11017 -61.94916      215.0     892.842  \n",
       "11175 -61.94916      215.0     892.842  \n",
       "11196 -61.94916      215.0     892.842  \n",
       "11293 -61.94916      215.0     892.842  \n",
       "11354 -61.94916      215.0     892.842  \n",
       "11371 -61.94916      215.0     892.842  \n",
       "17441 -61.94916      215.0     892.842  \n",
       "24282 -61.94916      215.0     892.842  \n",
       "24288 -61.94916      215.0     892.842  \n",
       "24299 -61.94916      215.0     892.842  \n",
       "24316 -61.94916      215.0     892.842  \n",
       "24486 -61.94916      215.0     892.842  \n",
       "24507 -61.94916      215.0     892.842  \n",
       "24517 -61.94916      215.0     892.842  \n",
       "24528 -61.94916      215.0     892.842  \n",
       "24605 -61.94916      215.0     892.842  \n",
       "24639 -61.94916      215.0     892.842  \n",
       "24674 -61.94916      215.0     892.842  \n",
       "24715 -61.94916      215.0     892.842  \n",
       "24781 -61.94916      215.0     892.842  \n",
       "24863 -61.94916      215.0     892.842  \n",
       "\n",
       "[32 rows x 69 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Criei um nova DF só com dados do municípo 'Castanheiras'\n",
    "\n",
    "menor_nasc = sinasc_raw[sinasc_raw['munResNome'] == 'Castanheiras']\n",
    "menor_nasc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>1</td>\n",
       "      <td>2496046.0</td>\n",
       "      <td>110004</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>2087</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>1</td>\n",
       "      <td>7648693.0</td>\n",
       "      <td>110004</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2323</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4512</th>\n",
       "      <td>1</td>\n",
       "      <td>2495279.0</td>\n",
       "      <td>110012</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>521135.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>4538</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5881</th>\n",
       "      <td>1</td>\n",
       "      <td>2516047.0</td>\n",
       "      <td>110018</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5913</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5952</th>\n",
       "      <td>1</td>\n",
       "      <td>2516047.0</td>\n",
       "      <td>110018</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5984</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10762</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10842</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10768</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10848</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10882</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10963</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10962</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11043</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10988</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11069</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10997</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11078</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11017</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>251605.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11098</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11175</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>11256</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11196</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>11277</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11293</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11374</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11354</th>\n",
       "      <td>1</td>\n",
       "      <td>2516594.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>11435</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11371</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>421125.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11452</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17441</th>\n",
       "      <td>1</td>\n",
       "      <td>3152928.0</td>\n",
       "      <td>110012</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>252105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1483994</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24282</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1490901</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24288</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1490907</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24299</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1490918</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24316</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1490935</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24486</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1491105</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24507</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491127</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24517</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>422105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491137</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24528</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491148</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24605</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491225</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24639</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491259</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24674</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491294</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24715</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1491335</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24781</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1491401</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24863</th>\n",
       "      <td>1</td>\n",
       "      <td>2495228.0</td>\n",
       "      <td>110028</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1491483</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.42684</td>\n",
       "      <td>-61.94916</td>\n",
       "      <td>215.0</td>\n",
       "      <td>892.842</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "2067        1  2496046.0      110004        1        18        1.0   \n",
       "2300        1  7648693.0      110004        1        31        5.0   \n",
       "4512        1  2495279.0      110012        1        22        1.0   \n",
       "5881        1  2516047.0      110018        1        26        2.0   \n",
       "5952        1  2516047.0      110018        1        32        1.0   \n",
       "10762       1  2495228.0      110028        1        21        1.0   \n",
       "10768       1  2495228.0      110028        1        31        5.0   \n",
       "10882       1  2495228.0      110028        1        23        2.0   \n",
       "10962       1  2495228.0      110028        1        29        1.0   \n",
       "10988       1  2495228.0      110028        1        31        2.0   \n",
       "10997       1  2495228.0      110028        1        35        4.0   \n",
       "11017       1  2495228.0      110028        1        27        1.0   \n",
       "11175       1  2495228.0      110028        1        24        1.0   \n",
       "11196       1  2495228.0      110028        1        27        2.0   \n",
       "11293       1  2495228.0      110028        1        25        1.0   \n",
       "11354       1  2516594.0      110028        1        34        5.0   \n",
       "11371       1  2495228.0      110028        1        21        5.0   \n",
       "17441       1  3152928.0      110012        1        39        2.0   \n",
       "24282       1  2495228.0      110028        1        28        5.0   \n",
       "24288       1  2495228.0      110028        1        27        2.0   \n",
       "24299       1  2495228.0      110028        1        30        2.0   \n",
       "24316       1  2495228.0      110028        1        17        5.0   \n",
       "24486       1  2495228.0      110028        1        35        1.0   \n",
       "24507       1  2495228.0      110028        1        27        5.0   \n",
       "24517       1  2495228.0      110028        1        27        5.0   \n",
       "24528       1  2495228.0      110028        1        25        1.0   \n",
       "24605       1  2495228.0      110028        1        32        2.0   \n",
       "24639       1  2495228.0      110028        1        18        1.0   \n",
       "24674       1  2495228.0      110028        1        27        1.0   \n",
       "24715       1  2495228.0      110028        1        32        2.0   \n",
       "24781       1  2495228.0      110028        1        22        2.0   \n",
       "24863       1  2495228.0      110028        1        30        5.0   \n",
       "\n",
       "                ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "2067       8 a 11 anos    999992.0         0.0         0.0  ...           3   \n",
       "2300       8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "4512       8 a 11 anos    521135.0         0.0         0.0  ...           2   \n",
       "5881       8 a 11 anos         NaN         0.0         0.0  ...           5   \n",
       "5952   12 anos ou mais         NaN         2.0         0.0  ...           5   \n",
       "10762      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "10768      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "10882      8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "10962      8 a 11 anos    621005.0         3.0         0.0  ...           5   \n",
       "10988      8 a 11 anos    999992.0         1.0         1.0  ...           5   \n",
       "10997      8 a 11 anos    621005.0         2.0         0.0  ...           5   \n",
       "11017  12 anos ou mais    251605.0         1.0         0.0  ...           5   \n",
       "11175       4 a 7 anos    999992.0         2.0         0.0  ...           4   \n",
       "11196       4 a 7 anos    621005.0         1.0         0.0  ...           3   \n",
       "11293      8 a 11 anos    621005.0         2.0         1.0  ...           5   \n",
       "11354  12 anos ou mais    621005.0         1.0         0.0  ...           2   \n",
       "11371      8 a 11 anos    421125.0         0.0         0.0  ...           5   \n",
       "17441  12 anos ou mais    252105.0         0.0         0.0  ...           5   \n",
       "24282      8 a 11 anos    621005.0         1.0         0.0  ...           9   \n",
       "24288      8 a 11 anos    621005.0         2.0         0.0  ...           5   \n",
       "24299       4 a 7 anos    999992.0         2.0         0.0  ...           5   \n",
       "24316       4 a 7 anos    999992.0         0.0         0.0  ...           4   \n",
       "24486       4 a 7 anos    999992.0         6.0         1.0  ...           2   \n",
       "24507      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "24517  12 anos ou mais    422105.0         0.0         0.0  ...           5   \n",
       "24528      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "24605      8 a 11 anos    621005.0         0.0         0.0  ...           5   \n",
       "24639       4 a 7 anos    621005.0         0.0         0.0  ...           5   \n",
       "24674      8 a 11 anos    999992.0         1.0         0.0  ...           5   \n",
       "24715      8 a 11 anos    621005.0         1.0         0.0  ...           5   \n",
       "24781      8 a 11 anos    621005.0         2.0         0.0  ...           9   \n",
       "24863      8 a 11 anos    621005.0         2.0         0.0  ...           4   \n",
       "\n",
       "      CONTADOR munResStatus munResTipo    munResNome  munResUf  munResLat  \\\n",
       "2067      2087        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "2300      2323        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "4512      4538        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "5881      5913        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "5952      5984        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10762    10842        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10768    10848        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10882    10963        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10962    11043        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10988    11069        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "10997    11078        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11017    11098        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11175    11256        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11196    11277        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11293    11374        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11354    11435        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "11371    11452        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "17441  1483994        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24282  1490901        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24288  1490907        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24299  1490918        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24316  1490935        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24486  1491105        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24507  1491127        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24517  1491137        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24528  1491148        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24605  1491225        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24639  1491259        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24674  1491294        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24715  1491335        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24781  1491401        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "24863  1491483        ATIVO      MUNIC  Castanheiras  Rondônia  -11.42684   \n",
       "\n",
       "      munResLon  munResAlt  munResArea  \n",
       "2067  -61.94916      215.0     892.842  \n",
       "2300  -61.94916      215.0     892.842  \n",
       "4512  -61.94916      215.0     892.842  \n",
       "5881  -61.94916      215.0     892.842  \n",
       "5952  -61.94916      215.0     892.842  \n",
       "10762 -61.94916      215.0     892.842  \n",
       "10768 -61.94916      215.0     892.842  \n",
       "10882 -61.94916      215.0     892.842  \n",
       "10962 -61.94916      215.0     892.842  \n",
       "10988 -61.94916      215.0     892.842  \n",
       "10997 -61.94916      215.0     892.842  \n",
       "11017 -61.94916      215.0     892.842  \n",
       "11175 -61.94916      215.0     892.842  \n",
       "11196 -61.94916      215.0     892.842  \n",
       "11293 -61.94916      215.0     892.842  \n",
       "11354 -61.94916      215.0     892.842  \n",
       "11371 -61.94916      215.0     892.842  \n",
       "17441 -61.94916      215.0     892.842  \n",
       "24282 -61.94916      215.0     892.842  \n",
       "24288 -61.94916      215.0     892.842  \n",
       "24299 -61.94916      215.0     892.842  \n",
       "24316 -61.94916      215.0     892.842  \n",
       "24486 -61.94916      215.0     892.842  \n",
       "24507 -61.94916      215.0     892.842  \n",
       "24517 -61.94916      215.0     892.842  \n",
       "24528 -61.94916      215.0     892.842  \n",
       "24605 -61.94916      215.0     892.842  \n",
       "24639 -61.94916      215.0     892.842  \n",
       "24674 -61.94916      215.0     892.842  \n",
       "24715 -61.94916      215.0     892.842  \n",
       "24781 -61.94916      215.0     892.842  \n",
       "24863 -61.94916      215.0     892.842  \n",
       "\n",
       "[32 rows x 69 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecionando as colunas necessárias para tratar os dados a fim de realizar a consulta solicitada\n",
    "\n",
    "menor_nasc[['munResNome','IDADEMAE', 'IDADEPAI']]\n",
    "menor_nasc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>munResNome</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>IDADEPAI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>18</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4512</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5881</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>26</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5952</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10762</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>21</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10768</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10882</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>23</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10962</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>29</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10988</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10997</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>35</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11017</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11175</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>24</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11196</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11293</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>25</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11354</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>34</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11371</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17441</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>39</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24282</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>28</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24288</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24299</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>30</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24316</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24486</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>35</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24507</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24517</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24528</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>25</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24605</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24639</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>18</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24674</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24715</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24781</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>22</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24863</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>30</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         munResNome  IDADEMAE  IDADEPAI\n",
       "2067   Castanheiras        18      17.0\n",
       "2300   Castanheiras        31      36.0\n",
       "4512   Castanheiras        22       NaN\n",
       "5881   Castanheiras        26      24.0\n",
       "5952   Castanheiras        32      29.0\n",
       "10762  Castanheiras        21      19.0\n",
       "10768  Castanheiras        31      31.0\n",
       "10882  Castanheiras        23      25.0\n",
       "10962  Castanheiras        29      32.0\n",
       "10988  Castanheiras        31      42.0\n",
       "10997  Castanheiras        35      38.0\n",
       "11017  Castanheiras        27      32.0\n",
       "11175  Castanheiras        24      28.0\n",
       "11196  Castanheiras        27      35.0\n",
       "11293  Castanheiras        25      29.0\n",
       "11354  Castanheiras        34      38.0\n",
       "11371  Castanheiras        21       NaN\n",
       "17441  Castanheiras        39      43.0\n",
       "24282  Castanheiras        28      29.0\n",
       "24288  Castanheiras        27      35.0\n",
       "24299  Castanheiras        30      35.0\n",
       "24316  Castanheiras        17       NaN\n",
       "24486  Castanheiras        35      38.0\n",
       "24507  Castanheiras        27      27.0\n",
       "24517  Castanheiras        27      20.0\n",
       "24528  Castanheiras        25      32.0\n",
       "24605  Castanheiras        32      25.0\n",
       "24639  Castanheiras        18      27.0\n",
       "24674  Castanheiras        27       NaN\n",
       "24715  Castanheiras        32      33.0\n",
       "24781  Castanheiras        22      19.0\n",
       "24863  Castanheiras        30      33.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Realiando a cópia do DF menor_nasc só com os dados necessários para tratar NaN\n",
    "castanheiras = menor_nasc[['munResNome','IDADEMAE', 'IDADEPAI']].copy()\n",
    "castanheiras"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Eliminando linhas com missing para fazer Média\n",
    "\n",
    "castanheiras.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "castanheiras.IDADEPAI.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(28, 3)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "castanheiras.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>munResNome</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>IDADEPAI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>18</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5881</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>26</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5952</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10762</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>21</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10768</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10882</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>23</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10962</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>29</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10988</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>31</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10997</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>35</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11017</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11175</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>24</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11196</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11293</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>25</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11354</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>34</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17441</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>39</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24282</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>28</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24288</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24299</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>30</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24486</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>35</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24507</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24517</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>27</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24528</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>25</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24605</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24639</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>18</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24715</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>32</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24781</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>22</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24863</th>\n",
       "      <td>Castanheiras</td>\n",
       "      <td>30</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         munResNome  IDADEMAE  IDADEPAI\n",
       "2067   Castanheiras        18      17.0\n",
       "2300   Castanheiras        31      36.0\n",
       "5881   Castanheiras        26      24.0\n",
       "5952   Castanheiras        32      29.0\n",
       "10762  Castanheiras        21      19.0\n",
       "10768  Castanheiras        31      31.0\n",
       "10882  Castanheiras        23      25.0\n",
       "10962  Castanheiras        29      32.0\n",
       "10988  Castanheiras        31      42.0\n",
       "10997  Castanheiras        35      38.0\n",
       "11017  Castanheiras        27      32.0\n",
       "11175  Castanheiras        24      28.0\n",
       "11196  Castanheiras        27      35.0\n",
       "11293  Castanheiras        25      29.0\n",
       "11354  Castanheiras        34      38.0\n",
       "17441  Castanheiras        39      43.0\n",
       "24282  Castanheiras        28      29.0\n",
       "24288  Castanheiras        27      35.0\n",
       "24299  Castanheiras        30      35.0\n",
       "24486  Castanheiras        35      38.0\n",
       "24507  Castanheiras        27      27.0\n",
       "24517  Castanheiras        27      20.0\n",
       "24528  Castanheiras        25      32.0\n",
       "24605  Castanheiras        32      25.0\n",
       "24639  Castanheiras        18      27.0\n",
       "24715  Castanheiras        32      33.0\n",
       "24781  Castanheiras        22      19.0\n",
       "24863  Castanheiras        30      33.0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "castanheiras"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">IDADEMAE</th>\n",
       "      <th colspan=\"3\" halign=\"left\">IDADEPAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Média</th>\n",
       "      <th>Máximo</th>\n",
       "      <th>Mínimo</th>\n",
       "      <th>Média</th>\n",
       "      <th>Máximo</th>\n",
       "      <th>Mínimo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>munResNome</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Castanheiras</th>\n",
       "      <td>28.071429</td>\n",
       "      <td>39</td>\n",
       "      <td>18</td>\n",
       "      <td>30.392857</td>\n",
       "      <td>43.0</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               IDADEMAE                 IDADEPAI              \n",
       "                  Média Máximo Mínimo      Média Máximo Mínimo\n",
       "munResNome                                                    \n",
       "Castanheiras  28.071429     39     18  30.392857   43.0   17.0"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Qual a idade media, maxima, minima das maes nesse municipio?\n",
    "# Qual a idade media, maxima, minima dos pais nesse municipio?\n",
    "\n",
    "agrupamento = castanheiras.groupby(['munResNome'])\n",
    "agrupamento.agg([('Média','mean'), ('Máximo','max'), ('Mínimo','min')])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4. Qual o municipio que nasceu mais bebe no mês de março?\n",
    "    a) qual a quantidade de filhos vivos media, maxima, minima nesse municipio?\n",
    "    b) qual a idade media, maxima, minima dos pais nesse municipio?\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Criando DF com os dados do mês de março\n",
    "\n",
    "selecao = (sinasc_raw['DTNASC'] >= '2019-03-01') & (sinasc_raw['DTNASC'] <= '2019-03-31')\n",
    "marco = sinasc_raw[selecao]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>2516500.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>231205.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alto Alegre dos Parecis</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-12.13178</td>\n",
       "      <td>-61.85308</td>\n",
       "      <td>397.0</td>\n",
       "      <td>3958.273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>2516500.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>2516500.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1 a 3 anos</td>\n",
       "      <td>621005.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>2679477.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1 a 3 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>2679477.0</td>\n",
       "      <td>110001</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>512105.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Alta Floresta D'Oeste</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-11.93554</td>\n",
       "      <td>-61.99982</td>\n",
       "      <td>338.0</td>\n",
       "      <td>7067.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13670</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>18687</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13671</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>18702</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13736</th>\n",
       "      <td>1</td>\n",
       "      <td>2688611.0</td>\n",
       "      <td>355030</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>10210.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1066018</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13748</th>\n",
       "      <td>1</td>\n",
       "      <td>2311682.0</td>\n",
       "      <td>510340</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>354605.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1386627</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Vilhena</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-12.74137</td>\n",
       "      <td>-60.13858</td>\n",
       "      <td>595.0</td>\n",
       "      <td>11518.915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13750</th>\n",
       "      <td>1</td>\n",
       "      <td>2604388.0</td>\n",
       "      <td>510340</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>142305.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1388221</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Ji-Paraná</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-10.88205</td>\n",
       "      <td>-61.94509</td>\n",
       "      <td>157.0</td>\n",
       "      <td>6896.648</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2456 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "3           1  2516500.0      110001        1        30        5.0   \n",
       "4           1  2516500.0      110001        1        30        2.0   \n",
       "5           1  2516500.0      110001        1        33        5.0   \n",
       "9           1  2679477.0      110001        1        30        2.0   \n",
       "10          1  2679477.0      110001        1        31        5.0   \n",
       "...       ...        ...         ...      ...       ...        ...   \n",
       "13670       1  2000733.0      120040        1        24        5.0   \n",
       "13671       1  2000733.0      120040        1        24        5.0   \n",
       "13736       1  2688611.0      355030        1        35        2.0   \n",
       "13748       1  2311682.0      510340        1        36        4.0   \n",
       "13750       1  2604388.0      510340        1        31        2.0   \n",
       "\n",
       "                ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "3      12 anos ou mais    231205.0         0.0         0.0  ...           4   \n",
       "4          8 a 11 anos    999992.0         1.0         0.0  ...           5   \n",
       "5           1 a 3 anos    621005.0         2.0         1.0  ...           5   \n",
       "9           1 a 3 anos    999992.0         1.0         1.0  ...           5   \n",
       "10         8 a 11 anos    512105.0         1.0         0.0  ...           5   \n",
       "...                ...         ...         ...         ...  ...         ...   \n",
       "13670      8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "13671       4 a 7 anos    999992.0         2.0         0.0  ...           9   \n",
       "13736  12 anos ou mais     10210.0         1.0         0.0  ...           5   \n",
       "13748  12 anos ou mais    354605.0         2.0         1.0  ...           5   \n",
       "13750  12 anos ou mais    142305.0         0.0         1.0  ...           5   \n",
       "\n",
       "      CONTADOR munResStatus munResTipo               munResNome  munResUf  \\\n",
       "3            4        ATIVO      MUNIC  Alto Alegre dos Parecis  Rondônia   \n",
       "4            5        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "5            6        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "9           10        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "10          11        ATIVO      MUNIC    Alta Floresta D'Oeste  Rondônia   \n",
       "...        ...          ...        ...                      ...       ...   \n",
       "13670    18687        ATIVO      MUNIC              Porto Velho  Rondônia   \n",
       "13671    18702        ATIVO      MUNIC              Porto Velho  Rondônia   \n",
       "13736  1066018        ATIVO      MUNIC              Porto Velho  Rondônia   \n",
       "13748  1386627        ATIVO      MUNIC                  Vilhena  Rondônia   \n",
       "13750  1388221        ATIVO      MUNIC                Ji-Paraná  Rondônia   \n",
       "\n",
       "       munResLat munResLon  munResAlt  munResArea  \n",
       "3      -12.13178 -61.85308      397.0    3958.273  \n",
       "4      -11.93554 -61.99982      338.0    7067.025  \n",
       "5      -11.93554 -61.99982      338.0    7067.025  \n",
       "9      -11.93554 -61.99982      338.0    7067.025  \n",
       "10     -11.93554 -61.99982      338.0    7067.025  \n",
       "...          ...       ...        ...         ...  \n",
       "13670   -8.76889 -63.83145       87.0   34096.394  \n",
       "13671   -8.76889 -63.83145       87.0   34096.394  \n",
       "13736   -8.76889 -63.83145       87.0   34096.394  \n",
       "13748  -12.74137 -60.13858      595.0   11518.915  \n",
       "13750  -10.88205 -61.94509      157.0    6896.648  \n",
       "\n",
       "[2456 rows x 69 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "marco"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "744"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultando qual município teve mais nascimentos - Essa consulta exibe só o valor\n",
    "\n",
    "marco.munResNome.value_counts().max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Porto Velho                  744\n",
       "Ji-Paraná                    188\n",
       "Vilhena                      148\n",
       "Ariquemes                    141\n",
       "Cacoal                       133\n",
       "Jaru                          80\n",
       "Guajará-Mirim                 75\n",
       "Rolim de Moura                69\n",
       "Ouro Preto do Oeste           67\n",
       "Pimenta Bueno                 62\n",
       "Buritis                       59\n",
       "Nova Mamoré                   53\n",
       "Machadinho D'Oeste            44\n",
       "Espigão D'Oeste               44\n",
       "São Miguel do Guaporé         41\n",
       "Candeias do Jamari            33\n",
       "São Francisco do Guaporé      31\n",
       "Alta Floresta D'Oeste         31\n",
       "Presidente Médici             29\n",
       "Costa Marques                 24\n",
       "Alto Paraíso                  22\n",
       "Alvorada D'Oeste              22\n",
       "Monte Negro                   20\n",
       "Nova Brasilândia D'Oeste      20\n",
       "Seringueiras                  19\n",
       "Colorado do Oeste             19\n",
       "Chupinguaia                   18\n",
       "Cujubim                       17\n",
       "Cerejeiras                    16\n",
       "Urupá                         14\n",
       "Vale do Paraíso               13\n",
       "Campo Novo de Rondônia        13\n",
       "Corumbiara                    12\n",
       "Vale do Anari                 11\n",
       "Governador Jorge Teixeira     10\n",
       "Alto Alegre dos Parecis       10\n",
       "Cacaulândia                   10\n",
       "Mirante da Serra               9\n",
       "Rio Crespo                     9\n",
       "Theobroma                      8\n",
       "Itapuã do Oeste                8\n",
       "Santa Luzia D'Oeste            7\n",
       "Nova União                     7\n",
       "Pimenteiras do Oeste           6\n",
       "Cabixi                         6\n",
       "Parecis                        6\n",
       "Ministro Andreazza             6\n",
       "Primavera de Rondônia          5\n",
       "Novo Horizonte do Oeste        5\n",
       "São Felipe D'Oeste             5\n",
       "Castanheiras                   4\n",
       "Teixeirópolis                  3\n",
       "Name: munResNome, dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultando qual município teve mais nascimentos\n",
    "\n",
    "marco.munResNome.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Qual o municipio que nasceu mais bebe no mês de março?\n",
    "    - Porto Velho"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>1</td>\n",
       "      <td>2494299.0</td>\n",
       "      <td>110002</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>618</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>1</td>\n",
       "      <td>2494299.0</td>\n",
       "      <td>110002</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>706</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>1</td>\n",
       "      <td>2808609.0</td>\n",
       "      <td>110011</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Nenhuma</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>3257</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3238</th>\n",
       "      <td>1</td>\n",
       "      <td>2808609.0</td>\n",
       "      <td>110011</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3263</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6818</th>\n",
       "      <td>1</td>\n",
       "      <td>2515369.0</td>\n",
       "      <td>110020</td>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>999991.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>6864</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13668</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>18630</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13669</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>18667</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13670</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>18687</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13671</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>18702</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13736</th>\n",
       "      <td>1</td>\n",
       "      <td>2688611.0</td>\n",
       "      <td>355030</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>10210.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1066018</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>744 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "612         1  2494299.0      110002        1        19        5.0   \n",
       "700         1  2494299.0      110002        1        19        5.0   \n",
       "3232        1  2808609.0      110011        1        34        5.0   \n",
       "3238        1  2808609.0      110011        1        24        5.0   \n",
       "6818        1  2515369.0      110020        1        38        2.0   \n",
       "...       ...        ...         ...      ...       ...        ...   \n",
       "13668       1  2000733.0      120040        1        19        5.0   \n",
       "13669       1  2000733.0      120040        1        21        5.0   \n",
       "13670       1  2000733.0      120040        1        24        5.0   \n",
       "13671       1  2000733.0      120040        1        24        5.0   \n",
       "13736       1  2688611.0      355030        1        35        2.0   \n",
       "\n",
       "                ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "612         4 a 7 anos    999992.0         0.0         0.0  ...           3   \n",
       "700         4 a 7 anos    622020.0         1.0         0.0  ...           4   \n",
       "3232           Nenhuma    622020.0         0.0         1.0  ...           4   \n",
       "3238       8 a 11 anos    622020.0         1.0         0.0  ...           5   \n",
       "6818   12 anos ou mais    999991.0         2.0         1.0  ...           5   \n",
       "...                ...         ...         ...         ...  ...         ...   \n",
       "13668       4 a 7 anos    999992.0         1.0         0.0  ...           3   \n",
       "13669       4 a 7 anos    999992.0         0.0         0.0  ...           9   \n",
       "13670      8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "13671       4 a 7 anos    999992.0         2.0         0.0  ...           9   \n",
       "13736  12 anos ou mais     10210.0         1.0         0.0  ...           5   \n",
       "\n",
       "      CONTADOR munResStatus munResTipo   munResNome  munResUf  munResLat  \\\n",
       "612        618        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "700        706        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "3232      3257        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "3238      3263        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "6818      6864        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "...        ...          ...        ...          ...       ...        ...   \n",
       "13668    18630        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13669    18667        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13670    18687        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13671    18702        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13736  1066018        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "\n",
       "      munResLon  munResAlt  munResArea  \n",
       "612   -63.83145       87.0   34096.394  \n",
       "700   -63.83145       87.0   34096.394  \n",
       "3232  -63.83145       87.0   34096.394  \n",
       "3238  -63.83145       87.0   34096.394  \n",
       "6818  -63.83145       87.0   34096.394  \n",
       "...         ...        ...         ...  \n",
       "13668 -63.83145       87.0   34096.394  \n",
       "13669 -63.83145       87.0   34096.394  \n",
       "13670 -63.83145       87.0   34096.394  \n",
       "13671 -63.83145       87.0   34096.394  \n",
       "13736 -63.83145       87.0   34096.394  \n",
       "\n",
       "[744 rows x 69 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Criando DF somente com o município com mais nascimentos no mês de março\n",
    "\n",
    "selecao = (marco['munResNome'] == 'Porto Velho') & (marco['DTNASC'])\n",
    "marco_2 = marco[selecao]\n",
    "marco_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Qual a quantidade de filhos vivos media, maxima, minima nesse municipio?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "munResNome\n",
       "Porto Velho    627\n",
       "Name: QTDFILVIVO, dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "marco_2.groupby('munResNome')['QTDFILVIVO'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>DTNASC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2019-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2019-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3238</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-03-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6818</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2019-03-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13668</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-03-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13669</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2019-03-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13670</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2019-03-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13671</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2019-03-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13736</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-03-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>744 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       QTDFILVIVO      DTNASC\n",
       "612           0.0  2019-03-09\n",
       "700           1.0  2019-03-28\n",
       "3232          0.0  2019-03-11\n",
       "3238          1.0  2019-03-13\n",
       "6818          2.0  2019-03-01\n",
       "...           ...         ...\n",
       "13668         1.0  2019-03-20\n",
       "13669         0.0  2019-03-25\n",
       "13670         0.0  2019-03-21\n",
       "13671         2.0  2019-03-22\n",
       "13736         1.0  2019-03-07\n",
       "\n",
       "[744 rows x 2 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tarefa_4 = marco_2[['QTDFILVIVO', 'DTNASC']].copy()\n",
    "tarefa_4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DTNASC\n",
       "2019-03-01    31\n",
       "2019-03-02    23\n",
       "2019-03-03    10\n",
       "2019-03-04    15\n",
       "2019-03-05    23\n",
       "2019-03-06    14\n",
       "2019-03-07    12\n",
       "2019-03-08    17\n",
       "2019-03-09    15\n",
       "2019-03-10    14\n",
       "2019-03-11    27\n",
       "2019-03-12    15\n",
       "2019-03-13    18\n",
       "2019-03-14    16\n",
       "2019-03-15    31\n",
       "2019-03-16    21\n",
       "2019-03-17    16\n",
       "2019-03-18    25\n",
       "2019-03-19    17\n",
       "2019-03-20    19\n",
       "2019-03-21    26\n",
       "2019-03-22    18\n",
       "2019-03-23    19\n",
       "2019-03-24    22\n",
       "2019-03-25    24\n",
       "2019-03-26    23\n",
       "2019-03-27    25\n",
       "2019-03-28    30\n",
       "2019-03-29    25\n",
       "2019-03-30    19\n",
       "2019-03-31    17\n",
       "Name: QTDFILVIVO, dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resultado = tarefa_4.groupby('DTNASC')['QTDFILVIVO'].count()\n",
    "resultado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DTNASC</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-03-01</th>\n",
       "      <td>1.322581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-02</th>\n",
       "      <td>1.434783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-03</th>\n",
       "      <td>1.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-04</th>\n",
       "      <td>1.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-05</th>\n",
       "      <td>1.652174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-06</th>\n",
       "      <td>1.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-07</th>\n",
       "      <td>1.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-08</th>\n",
       "      <td>1.588235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-09</th>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-10</th>\n",
       "      <td>1.214286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-11</th>\n",
       "      <td>1.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-12</th>\n",
       "      <td>1.533333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-13</th>\n",
       "      <td>1.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-14</th>\n",
       "      <td>1.562500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-15</th>\n",
       "      <td>1.193548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-16</th>\n",
       "      <td>1.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-17</th>\n",
       "      <td>1.562500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-18</th>\n",
       "      <td>1.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-19</th>\n",
       "      <td>1.235294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-20</th>\n",
       "      <td>1.315789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-21</th>\n",
       "      <td>1.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-22</th>\n",
       "      <td>0.944444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-23</th>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-24</th>\n",
       "      <td>0.818182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-25</th>\n",
       "      <td>1.041667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-26</th>\n",
       "      <td>1.217391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-27</th>\n",
       "      <td>1.960000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-28</th>\n",
       "      <td>0.933333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-29</th>\n",
       "      <td>1.080000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-30</th>\n",
       "      <td>1.789474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-31</th>\n",
       "      <td>0.588235</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            QTDFILVIVO\n",
       "DTNASC                \n",
       "2019-03-01    1.322581\n",
       "2019-03-02    1.434783\n",
       "2019-03-03    1.400000\n",
       "2019-03-04    1.600000\n",
       "2019-03-05    1.652174\n",
       "2019-03-06    1.285714\n",
       "2019-03-07    1.416667\n",
       "2019-03-08    1.588235\n",
       "2019-03-09    1.000000\n",
       "2019-03-10    1.214286\n",
       "2019-03-11    1.222222\n",
       "2019-03-12    1.533333\n",
       "2019-03-13    1.222222\n",
       "2019-03-14    1.562500\n",
       "2019-03-15    1.193548\n",
       "2019-03-16    1.523810\n",
       "2019-03-17    1.562500\n",
       "2019-03-18    1.600000\n",
       "2019-03-19    1.235294\n",
       "2019-03-20    1.315789\n",
       "2019-03-21    1.153846\n",
       "2019-03-22    0.944444\n",
       "2019-03-23    1.000000\n",
       "2019-03-24    0.818182\n",
       "2019-03-25    1.041667\n",
       "2019-03-26    1.217391\n",
       "2019-03-27    1.960000\n",
       "2019-03-28    0.933333\n",
       "2019-03-29    1.080000\n",
       "2019-03-30    1.789474\n",
       "2019-03-31    0.588235"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Média da quantidade de filhos vivos por dia do mês de março ordenado pela data de nascimento\n",
    "\n",
    "tarefa_4.groupby('DTNASC', sort=True)['QTDFILVIVO'].mean().to_frame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">QTDFILVIVO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Média</th>\n",
       "      <th>Máximo</th>\n",
       "      <th>Mínimo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DTNASC</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-03-01</th>\n",
       "      <td>1.322581</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-02</th>\n",
       "      <td>1.434783</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-03</th>\n",
       "      <td>1.400000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-04</th>\n",
       "      <td>1.600000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-05</th>\n",
       "      <td>1.652174</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-06</th>\n",
       "      <td>1.285714</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-07</th>\n",
       "      <td>1.416667</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-08</th>\n",
       "      <td>1.588235</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-09</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-10</th>\n",
       "      <td>1.214286</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-11</th>\n",
       "      <td>1.222222</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-12</th>\n",
       "      <td>1.533333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-13</th>\n",
       "      <td>1.222222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-14</th>\n",
       "      <td>1.562500</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-15</th>\n",
       "      <td>1.193548</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-16</th>\n",
       "      <td>1.523810</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-17</th>\n",
       "      <td>1.562500</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-18</th>\n",
       "      <td>1.600000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-19</th>\n",
       "      <td>1.235294</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-20</th>\n",
       "      <td>1.315789</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-21</th>\n",
       "      <td>1.153846</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-22</th>\n",
       "      <td>0.944444</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-23</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-24</th>\n",
       "      <td>0.818182</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-25</th>\n",
       "      <td>1.041667</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-26</th>\n",
       "      <td>1.217391</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-27</th>\n",
       "      <td>1.960000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-28</th>\n",
       "      <td>0.933333</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-29</th>\n",
       "      <td>1.080000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-30</th>\n",
       "      <td>1.789474</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-31</th>\n",
       "      <td>0.588235</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           QTDFILVIVO              \n",
       "                Média Máximo Mínimo\n",
       "DTNASC                             \n",
       "2019-03-01   1.322581    3.0    0.0\n",
       "2019-03-02   1.434783    4.0    0.0\n",
       "2019-03-03   1.400000    3.0    0.0\n",
       "2019-03-04   1.600000    4.0    0.0\n",
       "2019-03-05   1.652174    5.0    0.0\n",
       "2019-03-06   1.285714    4.0    0.0\n",
       "2019-03-07   1.416667    7.0    0.0\n",
       "2019-03-08   1.588235    4.0    0.0\n",
       "2019-03-09   1.000000    2.0    0.0\n",
       "2019-03-10   1.214286    3.0    0.0\n",
       "2019-03-11   1.222222    4.0    0.0\n",
       "2019-03-12   1.533333    5.0    0.0\n",
       "2019-03-13   1.222222    5.0    0.0\n",
       "2019-03-14   1.562500    6.0    0.0\n",
       "2019-03-15   1.193548    4.0    0.0\n",
       "2019-03-16   1.523810    6.0    0.0\n",
       "2019-03-17   1.562500    3.0    0.0\n",
       "2019-03-18   1.600000    6.0    0.0\n",
       "2019-03-19   1.235294    4.0    0.0\n",
       "2019-03-20   1.315789    6.0    0.0\n",
       "2019-03-21   1.153846    5.0    0.0\n",
       "2019-03-22   0.944444    2.0    0.0\n",
       "2019-03-23   1.000000    6.0    0.0\n",
       "2019-03-24   0.818182    2.0    0.0\n",
       "2019-03-25   1.041667    9.0    0.0\n",
       "2019-03-26   1.217391    5.0    0.0\n",
       "2019-03-27   1.960000    6.0    0.0\n",
       "2019-03-28   0.933333    4.0    0.0\n",
       "2019-03-29   1.080000    5.0    0.0\n",
       "2019-03-30   1.789474    5.0    0.0\n",
       "2019-03-31   0.588235    2.0    0.0"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Média, Mínimo e Máximo de fihos vivos por dia do mês de março\n",
    "\n",
    "agrupamento = tarefa_4.groupby(['DTNASC'])\n",
    "agrupamento.agg([('Média','mean'), ('Máximo','max'), ('Mínimo','min')])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Qual a idade media, maxima, minima dos pais nesse municipio?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ORIGEM</th>\n",
       "      <th>CODESTAB</th>\n",
       "      <th>CODMUNNASC</th>\n",
       "      <th>LOCNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>ESTCIVMAE</th>\n",
       "      <th>ESCMAE</th>\n",
       "      <th>CODOCUPMAE</th>\n",
       "      <th>QTDFILVIVO</th>\n",
       "      <th>QTDFILMORT</th>\n",
       "      <th>...</th>\n",
       "      <th>KOTELCHUCK</th>\n",
       "      <th>CONTADOR</th>\n",
       "      <th>munResStatus</th>\n",
       "      <th>munResTipo</th>\n",
       "      <th>munResNome</th>\n",
       "      <th>munResUf</th>\n",
       "      <th>munResLat</th>\n",
       "      <th>munResLon</th>\n",
       "      <th>munResAlt</th>\n",
       "      <th>munResArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>1</td>\n",
       "      <td>2494299.0</td>\n",
       "      <td>110002</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>618</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>1</td>\n",
       "      <td>2494299.0</td>\n",
       "      <td>110002</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>706</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>1</td>\n",
       "      <td>2808609.0</td>\n",
       "      <td>110011</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Nenhuma</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>3257</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3238</th>\n",
       "      <td>1</td>\n",
       "      <td>2808609.0</td>\n",
       "      <td>110011</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>622020.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3263</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6818</th>\n",
       "      <td>1</td>\n",
       "      <td>2515369.0</td>\n",
       "      <td>110020</td>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>999991.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>6864</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13668</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>18630</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13669</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>18667</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13670</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8 a 11 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>18687</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13671</th>\n",
       "      <td>1</td>\n",
       "      <td>2000733.0</td>\n",
       "      <td>120040</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4 a 7 anos</td>\n",
       "      <td>999992.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>18702</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13736</th>\n",
       "      <td>1</td>\n",
       "      <td>2688611.0</td>\n",
       "      <td>355030</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12 anos ou mais</td>\n",
       "      <td>10210.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>1066018</td>\n",
       "      <td>ATIVO</td>\n",
       "      <td>MUNIC</td>\n",
       "      <td>Porto Velho</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>-8.76889</td>\n",
       "      <td>-63.83145</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34096.394</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>744 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ORIGEM   CODESTAB  CODMUNNASC  LOCNASC  IDADEMAE  ESTCIVMAE  \\\n",
       "612         1  2494299.0      110002        1        19        5.0   \n",
       "700         1  2494299.0      110002        1        19        5.0   \n",
       "3232        1  2808609.0      110011        1        34        5.0   \n",
       "3238        1  2808609.0      110011        1        24        5.0   \n",
       "6818        1  2515369.0      110020        1        38        2.0   \n",
       "...       ...        ...         ...      ...       ...        ...   \n",
       "13668       1  2000733.0      120040        1        19        5.0   \n",
       "13669       1  2000733.0      120040        1        21        5.0   \n",
       "13670       1  2000733.0      120040        1        24        5.0   \n",
       "13671       1  2000733.0      120040        1        24        5.0   \n",
       "13736       1  2688611.0      355030        1        35        2.0   \n",
       "\n",
       "                ESCMAE  CODOCUPMAE  QTDFILVIVO  QTDFILMORT  ...  KOTELCHUCK  \\\n",
       "612         4 a 7 anos    999992.0         0.0         0.0  ...           3   \n",
       "700         4 a 7 anos    622020.0         1.0         0.0  ...           4   \n",
       "3232           Nenhuma    622020.0         0.0         1.0  ...           4   \n",
       "3238       8 a 11 anos    622020.0         1.0         0.0  ...           5   \n",
       "6818   12 anos ou mais    999991.0         2.0         1.0  ...           5   \n",
       "...                ...         ...         ...         ...  ...         ...   \n",
       "13668       4 a 7 anos    999992.0         1.0         0.0  ...           3   \n",
       "13669       4 a 7 anos    999992.0         0.0         0.0  ...           9   \n",
       "13670      8 a 11 anos    999992.0         0.0         0.0  ...           5   \n",
       "13671       4 a 7 anos    999992.0         2.0         0.0  ...           9   \n",
       "13736  12 anos ou mais     10210.0         1.0         0.0  ...           5   \n",
       "\n",
       "      CONTADOR munResStatus munResTipo   munResNome  munResUf  munResLat  \\\n",
       "612        618        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "700        706        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "3232      3257        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "3238      3263        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "6818      6864        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "...        ...          ...        ...          ...       ...        ...   \n",
       "13668    18630        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13669    18667        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13670    18687        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13671    18702        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "13736  1066018        ATIVO      MUNIC  Porto Velho  Rondônia   -8.76889   \n",
       "\n",
       "      munResLon  munResAlt  munResArea  \n",
       "612   -63.83145       87.0   34096.394  \n",
       "700   -63.83145       87.0   34096.394  \n",
       "3232  -63.83145       87.0   34096.394  \n",
       "3238  -63.83145       87.0   34096.394  \n",
       "6818  -63.83145       87.0   34096.394  \n",
       "...         ...        ...         ...  \n",
       "13668 -63.83145       87.0   34096.394  \n",
       "13669 -63.83145       87.0   34096.394  \n",
       "13670 -63.83145       87.0   34096.394  \n",
       "13671 -63.83145       87.0   34096.394  \n",
       "13736 -63.83145       87.0   34096.394  \n",
       "\n",
       "[744 rows x 69 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "selecao = (marco['munResNome'] == 'Porto Velho') & (marco['DTNASC'])\n",
    "marco_2 = marco[selecao]\n",
    "marco_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DTNASC</th>\n",
       "      <th>IDADEMAE</th>\n",
       "      <th>IDADEPAI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>2019-03-09</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>2019-03-11</td>\n",
       "      <td>34</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3238</th>\n",
       "      <td>2019-03-13</td>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6818</th>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>38</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13668</th>\n",
       "      <td>2019-03-20</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13669</th>\n",
       "      <td>2019-03-25</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13670</th>\n",
       "      <td>2019-03-21</td>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13671</th>\n",
       "      <td>2019-03-22</td>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13736</th>\n",
       "      <td>2019-03-07</td>\n",
       "      <td>35</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>744 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           DTNASC  IDADEMAE  IDADEPAI\n",
       "612    2019-03-09        19       NaN\n",
       "700    2019-03-28        19       NaN\n",
       "3232   2019-03-11        34       NaN\n",
       "3238   2019-03-13        24       NaN\n",
       "6818   2019-03-01        38      41.0\n",
       "...           ...       ...       ...\n",
       "13668  2019-03-20        19       NaN\n",
       "13669  2019-03-25        21       NaN\n",
       "13670  2019-03-21        24       NaN\n",
       "13671  2019-03-22        24       NaN\n",
       "13736  2019-03-07        35      42.0\n",
       "\n",
       "[744 rows x 3 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Criando DF somente com as colunas necessárias\n",
    "\n",
    "tarefa4_b = marco_2[['DTNASC', 'IDADEMAE', 'IDADEPAI']].copy()\n",
    "tarefa4_b "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">IDADEMAE</th>\n",
       "      <th colspan=\"3\" halign=\"left\">IDADEPAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Média</th>\n",
       "      <th>Máximo</th>\n",
       "      <th>Mínimo</th>\n",
       "      <th>Média</th>\n",
       "      <th>Máximo</th>\n",
       "      <th>Mínimo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DTNASC</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-03-01</th>\n",
       "      <td>28.343750</td>\n",
       "      <td>44</td>\n",
       "      <td>15</td>\n",
       "      <td>40.200000</td>\n",
       "      <td>51.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-02</th>\n",
       "      <td>26.285714</td>\n",
       "      <td>38</td>\n",
       "      <td>14</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>38.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-03</th>\n",
       "      <td>28.285714</td>\n",
       "      <td>42</td>\n",
       "      <td>17</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>34.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-04</th>\n",
       "      <td>27.650000</td>\n",
       "      <td>43</td>\n",
       "      <td>16</td>\n",
       "      <td>33.800000</td>\n",
       "      <td>38.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-05</th>\n",
       "      <td>26.000000</td>\n",
       "      <td>38</td>\n",
       "      <td>15</td>\n",
       "      <td>39.000000</td>\n",
       "      <td>39.0</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-06</th>\n",
       "      <td>26.095238</td>\n",
       "      <td>37</td>\n",
       "      <td>16</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-07</th>\n",
       "      <td>27.350000</td>\n",
       "      <td>42</td>\n",
       "      <td>16</td>\n",
       "      <td>41.666667</td>\n",
       "      <td>52.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-08</th>\n",
       "      <td>28.095238</td>\n",
       "      <td>42</td>\n",
       "      <td>17</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-09</th>\n",
       "      <td>24.777778</td>\n",
       "      <td>38</td>\n",
       "      <td>17</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>37.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-10</th>\n",
       "      <td>25.000000</td>\n",
       "      <td>39</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-11</th>\n",
       "      <td>27.129032</td>\n",
       "      <td>41</td>\n",
       "      <td>15</td>\n",
       "      <td>32.250000</td>\n",
       "      <td>40.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-12</th>\n",
       "      <td>28.222222</td>\n",
       "      <td>39</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-13</th>\n",
       "      <td>26.333333</td>\n",
       "      <td>37</td>\n",
       "      <td>17</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>37.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-14</th>\n",
       "      <td>27.578947</td>\n",
       "      <td>42</td>\n",
       "      <td>16</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-15</th>\n",
       "      <td>27.088235</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>31.600000</td>\n",
       "      <td>38.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-16</th>\n",
       "      <td>26.290323</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>26.333333</td>\n",
       "      <td>34.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-17</th>\n",
       "      <td>24.500000</td>\n",
       "      <td>36</td>\n",
       "      <td>16</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>40.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-18</th>\n",
       "      <td>26.137931</td>\n",
       "      <td>40</td>\n",
       "      <td>14</td>\n",
       "      <td>34.666667</td>\n",
       "      <td>51.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-19</th>\n",
       "      <td>29.043478</td>\n",
       "      <td>41</td>\n",
       "      <td>18</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>53.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-20</th>\n",
       "      <td>27.666667</td>\n",
       "      <td>43</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-21</th>\n",
       "      <td>25.464286</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>44.000000</td>\n",
       "      <td>44.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-22</th>\n",
       "      <td>26.736842</td>\n",
       "      <td>41</td>\n",
       "      <td>19</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-23</th>\n",
       "      <td>27.894737</td>\n",
       "      <td>40</td>\n",
       "      <td>16</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-24</th>\n",
       "      <td>25.391304</td>\n",
       "      <td>39</td>\n",
       "      <td>17</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>55.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-25</th>\n",
       "      <td>25.880000</td>\n",
       "      <td>38</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-26</th>\n",
       "      <td>26.760000</td>\n",
       "      <td>40</td>\n",
       "      <td>17</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>28.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-27</th>\n",
       "      <td>27.680000</td>\n",
       "      <td>44</td>\n",
       "      <td>15</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>62.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-28</th>\n",
       "      <td>26.290323</td>\n",
       "      <td>40</td>\n",
       "      <td>16</td>\n",
       "      <td>35.666667</td>\n",
       "      <td>39.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-29</th>\n",
       "      <td>24.880000</td>\n",
       "      <td>35</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-30</th>\n",
       "      <td>28.368421</td>\n",
       "      <td>39</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-31</th>\n",
       "      <td>22.352941</td>\n",
       "      <td>43</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             IDADEMAE                 IDADEPAI              \n",
       "                Média Máximo Mínimo      Média Máximo Mínimo\n",
       "DTNASC                                                      \n",
       "2019-03-01  28.343750     44     15  40.200000   51.0   33.0\n",
       "2019-03-02  26.285714     38     14  32.000000   38.0   25.0\n",
       "2019-03-03  28.285714     42     17  34.000000   34.0   34.0\n",
       "2019-03-04  27.650000     43     16  33.800000   38.0   30.0\n",
       "2019-03-05  26.000000     38     15  39.000000   39.0   39.0\n",
       "2019-03-06  26.095238     37     16  35.000000   35.0   35.0\n",
       "2019-03-07  27.350000     42     16  41.666667   52.0   31.0\n",
       "2019-03-08  28.095238     42     17  31.000000   31.0   31.0\n",
       "2019-03-09  24.777778     38     17  31.000000   37.0   26.0\n",
       "2019-03-10  25.000000     39     16        NaN    NaN    NaN\n",
       "2019-03-11  27.129032     41     15  32.250000   40.0   28.0\n",
       "2019-03-12  28.222222     39     15        NaN    NaN    NaN\n",
       "2019-03-13  26.333333     37     17  36.000000   37.0   35.0\n",
       "2019-03-14  27.578947     42     16  31.000000   31.0   31.0\n",
       "2019-03-15  27.088235     40     15  31.600000   38.0   23.0\n",
       "2019-03-16  26.290323     44     16  26.333333   34.0   19.0\n",
       "2019-03-17  24.500000     36     16  32.000000   40.0   24.0\n",
       "2019-03-18  26.137931     40     14  34.666667   51.0   21.0\n",
       "2019-03-19  29.043478     41     18  51.000000   53.0   49.0\n",
       "2019-03-20  27.666667     43     18        NaN    NaN    NaN\n",
       "2019-03-21  25.464286     40     15  44.000000   44.0   44.0\n",
       "2019-03-22  26.736842     41     19  23.000000   23.0   23.0\n",
       "2019-03-23  27.894737     40     16  29.000000   29.0   29.0\n",
       "2019-03-24  25.391304     39     17  40.000000   55.0   30.0\n",
       "2019-03-25  25.880000     38     16        NaN    NaN    NaN\n",
       "2019-03-26  26.760000     40     17  27.000000   28.0   26.0\n",
       "2019-03-27  27.680000     44     15  41.000000   62.0   20.0\n",
       "2019-03-28  26.290323     40     16  35.666667   39.0   30.0\n",
       "2019-03-29  24.880000     35     16        NaN    NaN    NaN\n",
       "2019-03-30  28.368421     39     15        NaN    NaN    NaN\n",
       "2019-03-31  22.352941     43     14        NaN    NaN    NaN"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agrupamento = tarefa4_b.groupby(['DTNASC'])\n",
    "agrupamento.agg([('Média','mean'), ('Máximo','max'), ('Mínimo','min')])\n",
    "# Análise com DADOS FALTANTES - Optei por não excluir"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Analise as respostas encontradas, tire algum insight delas, conte pra gente algo encontrado nos dados. Algo que você julgue relevante e novo pra você."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- A consulta \"Média, Mínimo e Máximo de fihos vivos por dia do mês de março\" confirma a ausência dos dados do pai em muitos registros de nascimentos. Seja por não registrarem os filhos, por morte do pai antes do nascimento do bebê, são vários fatores. Dependendo do objetivo da consulta, acredito que o NaN poderia ser substituído por 0 para não ser necessário excluir os registros das mães e influenciar na análise. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- A consulta \"Qual município teve mais nascimentos\" confirma que a capital do estado de Rondônia teve mais nascimentos. Uma análise mais detalhada seria o tamanho da população. Geralmente, a capital é mais populosa e por isso ter mais nascimentos. Outro indíce a ser avaliado em conjunto são as condições hospitalares da capital serem mais equipadas do que demais municípios, principalmente do interior. "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}