Skip to content

Instantly share code, notes, and snippets.

@ClebsonDantasUchoa

ClebsonDantasUchoa/melhoresDoENEM.ipynb

Created August 31, 2018 01:41
Show Gist options
  • Save ClebsonDantasUchoa/b2176931044382ea7976358b0f65c1ca to your computer and use it in GitHub Desktop.
Save ClebsonDantasUchoa/b2176931044382ea7976358b0f65c1ca to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
melhoresDoENEM.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Melhores colocados ENEM\n",
"### desafio retirado do site: CodeNation\n",
"## link: https://www.codenation.com.br/journey/data-science/challenge/enem-1.html\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Importação das bibliotecas"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"%matplotlib inline\n",
"import pandas as pd\n",
"import numpy as np\n",
"from sklearn.preprocessing import Imputer"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Carregando o dataset"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"scrolled": true
},
"outputs": [],
"source": [
"df = pd.read_csv('enem.csv')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Visualização e descrição dos dados"
]
},
{
"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>Unnamed: 0</th>\n",
" <th>NU_INSCRICAO</th>\n",
" <th>NU_ANO</th>\n",
" <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
" <th>NO_MUNICIPIO_RESIDENCIA</th>\n",
" <th>CO_UF_RESIDENCIA</th>\n",
" <th>SG_UF_RESIDENCIA</th>\n",
" <th>NU_IDADE</th>\n",
" <th>TP_SEXO</th>\n",
" <th>TP_ESTADO_CIVIL</th>\n",
" <th>...</th>\n",
" <th>Q041</th>\n",
" <th>Q042</th>\n",
" <th>Q043</th>\n",
" <th>Q044</th>\n",
" <th>Q045</th>\n",
" <th>Q046</th>\n",
" <th>Q047</th>\n",
" <th>Q048</th>\n",
" <th>Q049</th>\n",
" <th>Q050</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>ed50e8aaa58e7a806c337585efee9ca41f1eb1ad</td>\n",
" <td>2016</td>\n",
" <td>4314902</td>\n",
" <td>Porto Alegre</td>\n",
" <td>43</td>\n",
" <td>RS</td>\n",
" <td>24</td>\n",
" <td>M</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>5.0</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>B</td>\n",
" <td>D</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>2c3acac4b33ec2b195d77e7c04a2d75727fad723</td>\n",
" <td>2016</td>\n",
" <td>2304707</td>\n",
" <td>Granja</td>\n",
" <td>23</td>\n",
" <td>CE</td>\n",
" <td>17</td>\n",
" <td>F</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>C</td>\n",
" <td>A</td>\n",
" <td>B</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>C</td>\n",
" <td>A</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>f4545f8ccb9ff5c8aad7d32951b3f251a26e6568</td>\n",
" <td>2016</td>\n",
" <td>2304400</td>\n",
" <td>Fortaleza</td>\n",
" <td>23</td>\n",
" <td>CE</td>\n",
" <td>21</td>\n",
" <td>F</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>C</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>B</td>\n",
" <td>A</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>3d6ec248fef899c414e77f82d5c6d2bffbeaf7fe</td>\n",
" <td>2016</td>\n",
" <td>3304557</td>\n",
" <td>Rio de Janeiro</td>\n",
" <td>33</td>\n",
" <td>RJ</td>\n",
" <td>25</td>\n",
" <td>F</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>5.0</td>\n",
" <td>C</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>D</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>bf896ac8d3ecadd6dba1dfbf50110afcbf5d3268</td>\n",
" <td>2016</td>\n",
" <td>1302603</td>\n",
" <td>Manaus</td>\n",
" <td>13</td>\n",
" <td>AM</td>\n",
" <td>28</td>\n",
" <td>M</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" <td>A</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 167 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 NU_INSCRICAO NU_ANO \\\n",
"0 1 ed50e8aaa58e7a806c337585efee9ca41f1eb1ad 2016 \n",
"1 2 2c3acac4b33ec2b195d77e7c04a2d75727fad723 2016 \n",
"2 3 f4545f8ccb9ff5c8aad7d32951b3f251a26e6568 2016 \n",
"3 4 3d6ec248fef899c414e77f82d5c6d2bffbeaf7fe 2016 \n",
"4 5 bf896ac8d3ecadd6dba1dfbf50110afcbf5d3268 2016 \n",
"\n",
" CO_MUNICIPIO_RESIDENCIA NO_MUNICIPIO_RESIDENCIA CO_UF_RESIDENCIA \\\n",
"0 4314902 Porto Alegre 43 \n",
"1 2304707 Granja 23 \n",
"2 2304400 Fortaleza 23 \n",
"3 3304557 Rio de Janeiro 33 \n",
"4 1302603 Manaus 13 \n",
"\n",
" SG_UF_RESIDENCIA NU_IDADE TP_SEXO TP_ESTADO_CIVIL ... Q041 Q042 Q043 \\\n",
"0 RS 24 M 0.0 ... 5.0 A A \n",
"1 CE 17 F 0.0 ... NaN A A \n",
"2 CE 21 F 0.0 ... NaN A A \n",
"3 RJ 25 F 0.0 ... 5.0 C A \n",
"4 AM 28 M 0.0 ... NaN A A \n",
"\n",
" Q044 Q045 Q046 Q047 Q048 Q049 Q050 \n",
"0 A A A A A B D \n",
"1 C A B A A C A \n",
"2 A A C A A B A \n",
"3 A A A D A A A \n",
"4 A A A A A A A \n",
"\n",
"[5 rows x 167 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 4,
"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>Unnamed: 0</th>\n",
" <th>NU_ANO</th>\n",
" <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
" <th>CO_UF_RESIDENCIA</th>\n",
" <th>NU_IDADE</th>\n",
" <th>TP_ESTADO_CIVIL</th>\n",
" <th>TP_COR_RACA</th>\n",
" <th>TP_NACIONALIDADE</th>\n",
" <th>CO_MUNICIPIO_NASCIMENTO</th>\n",
" <th>CO_UF_NASCIMENTO</th>\n",
" <th>...</th>\n",
" <th>Q032</th>\n",
" <th>Q033</th>\n",
" <th>Q034</th>\n",
" <th>Q035</th>\n",
" <th>Q036</th>\n",
" <th>Q037</th>\n",
" <th>Q038</th>\n",
" <th>Q039</th>\n",
" <th>Q040</th>\n",
" <th>Q041</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td>13730.000000</td>\n",
" <td>13730.0</td>\n",
" <td>1.373000e+04</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13202.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>1.312100e+04</td>\n",
" <td>13121.000000</td>\n",
" <td>...</td>\n",
" <td>6354.000000</td>\n",
" <td>6354.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>13730.000000</td>\n",
" <td>2938.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mean</th>\n",
" <td>2288.173926</td>\n",
" <td>2016.0</td>\n",
" <td>3.088548e+06</td>\n",
" <td>30.736708</td>\n",
" <td>21.593809</td>\n",
" <td>0.116043</td>\n",
" <td>2.185652</td>\n",
" <td>1.048871</td>\n",
" <td>3.057946e+06</td>\n",
" <td>30.429159</td>\n",
" <td>...</td>\n",
" <td>4.530217</td>\n",
" <td>3.962858</td>\n",
" <td>4.645594</td>\n",
" <td>4.678441</td>\n",
" <td>3.341515</td>\n",
" <td>4.458995</td>\n",
" <td>3.724618</td>\n",
" <td>3.506409</td>\n",
" <td>4.442098</td>\n",
" <td>3.671545</td>\n",
" </tr>\n",
" <tr>\n",
" <th>std</th>\n",
" <td>1321.230607</td>\n",
" <td>0.0</td>\n",
" <td>9.890495e+05</td>\n",
" <td>9.862405</td>\n",
" <td>7.043654</td>\n",
" <td>0.365986</td>\n",
" <td>1.007285</td>\n",
" <td>0.258895</td>\n",
" <td>9.703020e+05</td>\n",
" <td>9.670030</td>\n",
" <td>...</td>\n",
" <td>1.027613</td>\n",
" <td>1.625356</td>\n",
" <td>0.920998</td>\n",
" <td>0.865039</td>\n",
" <td>1.711930</td>\n",
" <td>1.200172</td>\n",
" <td>1.689362</td>\n",
" <td>1.718858</td>\n",
" <td>1.181549</td>\n",
" <td>1.746444</td>\n",
" </tr>\n",
" <tr>\n",
" <th>min</th>\n",
" <td>0.000000</td>\n",
" <td>2016.0</td>\n",
" <td>1.100023e+06</td>\n",
" <td>11.000000</td>\n",
" <td>13.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>1.100023e+06</td>\n",
" <td>11.000000</td>\n",
" <td>...</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25%</th>\n",
" <td>1144.000000</td>\n",
" <td>2016.0</td>\n",
" <td>2.307650e+06</td>\n",
" <td>23.000000</td>\n",
" <td>17.000000</td>\n",
" <td>0.000000</td>\n",
" <td>1.000000</td>\n",
" <td>1.000000</td>\n",
" <td>2.306900e+06</td>\n",
" <td>23.000000</td>\n",
" <td>...</td>\n",
" <td>5.000000</td>\n",
" <td>3.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>2.000000</td>\n",
" <td>5.000000</td>\n",
" <td>3.000000</td>\n",
" <td>2.000000</td>\n",
" <td>4.000000</td>\n",
" <td>3.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50%</th>\n",
" <td>2288.000000</td>\n",
" <td>2016.0</td>\n",
" <td>3.118601e+06</td>\n",
" <td>31.000000</td>\n",
" <td>19.000000</td>\n",
" <td>0.000000</td>\n",
" <td>3.000000</td>\n",
" <td>1.000000</td>\n",
" <td>3.106200e+06</td>\n",
" <td>31.000000</td>\n",
" <td>...</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>4.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>4.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75%</th>\n",
" <td>3432.000000</td>\n",
" <td>2016.0</td>\n",
" <td>3.550308e+06</td>\n",
" <td>35.000000</td>\n",
" <td>23.000000</td>\n",
" <td>0.000000</td>\n",
" <td>3.000000</td>\n",
" <td>1.000000</td>\n",
" <td>3.549805e+06</td>\n",
" <td>35.000000</td>\n",
" <td>...</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>max</th>\n",
" <td>4586.000000</td>\n",
" <td>2016.0</td>\n",
" <td>5.300108e+06</td>\n",
" <td>53.000000</td>\n",
" <td>67.000000</td>\n",
" <td>3.000000</td>\n",
" <td>5.000000</td>\n",
" <td>4.000000</td>\n",
" <td>5.300108e+06</td>\n",
" <td>53.000000</td>\n",
" <td>...</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" <td>5.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>8 rows × 107 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 NU_ANO CO_MUNICIPIO_RESIDENCIA CO_UF_RESIDENCIA \\\n",
"count 13730.000000 13730.0 1.373000e+04 13730.000000 \n",
"mean 2288.173926 2016.0 3.088548e+06 30.736708 \n",
"std 1321.230607 0.0 9.890495e+05 9.862405 \n",
"min 0.000000 2016.0 1.100023e+06 11.000000 \n",
"25% 1144.000000 2016.0 2.307650e+06 23.000000 \n",
"50% 2288.000000 2016.0 3.118601e+06 31.000000 \n",
"75% 3432.000000 2016.0 3.550308e+06 35.000000 \n",
"max 4586.000000 2016.0 5.300108e+06 53.000000 \n",
"\n",
" NU_IDADE TP_ESTADO_CIVIL TP_COR_RACA TP_NACIONALIDADE \\\n",
"count 13730.000000 13202.000000 13730.000000 13730.000000 \n",
"mean 21.593809 0.116043 2.185652 1.048871 \n",
"std 7.043654 0.365986 1.007285 0.258895 \n",
"min 13.000000 0.000000 0.000000 0.000000 \n",
"25% 17.000000 0.000000 1.000000 1.000000 \n",
"50% 19.000000 0.000000 3.000000 1.000000 \n",
"75% 23.000000 0.000000 3.000000 1.000000 \n",
"max 67.000000 3.000000 5.000000 4.000000 \n",
"\n",
" CO_MUNICIPIO_NASCIMENTO CO_UF_NASCIMENTO ... Q032 \\\n",
"count 1.312100e+04 13121.000000 ... 6354.000000 \n",
"mean 3.057946e+06 30.429159 ... 4.530217 \n",
"std 9.703020e+05 9.670030 ... 1.027613 \n",
"min 1.100023e+06 11.000000 ... 0.000000 \n",
"25% 2.306900e+06 23.000000 ... 5.000000 \n",
"50% 3.106200e+06 31.000000 ... 5.000000 \n",
"75% 3.549805e+06 35.000000 ... 5.000000 \n",
"max 5.300108e+06 53.000000 ... 5.000000 \n",
"\n",
" Q033 Q034 Q035 Q036 Q037 \\\n",
"count 6354.000000 13730.000000 13730.000000 13730.000000 13730.000000 \n",
"mean 3.962858 4.645594 4.678441 3.341515 4.458995 \n",
"std 1.625356 0.920998 0.865039 1.711930 1.200172 \n",
"min 0.000000 0.000000 0.000000 0.000000 0.000000 \n",
"25% 3.000000 5.000000 5.000000 2.000000 5.000000 \n",
"50% 5.000000 5.000000 5.000000 4.000000 5.000000 \n",
"75% 5.000000 5.000000 5.000000 5.000000 5.000000 \n",
"max 5.000000 5.000000 5.000000 5.000000 5.000000 \n",
"\n",
" Q038 Q039 Q040 Q041 \n",
"count 13730.000000 13730.000000 13730.000000 2938.000000 \n",
"mean 3.724618 3.506409 4.442098 3.671545 \n",
"std 1.689362 1.718858 1.181549 1.746444 \n",
"min 0.000000 0.000000 0.000000 0.000000 \n",
"25% 3.000000 2.000000 4.000000 3.000000 \n",
"50% 5.000000 4.000000 5.000000 5.000000 \n",
"75% 5.000000 5.000000 5.000000 5.000000 \n",
"max 5.000000 5.000000 5.000000 5.000000 \n",
"\n",
"[8 rows x 107 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.describe()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"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>Unnamed: 0</th>\n",
" <th>NU_ANO</th>\n",
" <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
" <th>CO_UF_RESIDENCIA</th>\n",
" <th>NU_IDADE</th>\n",
" <th>TP_ESTADO_CIVIL</th>\n",
" <th>TP_COR_RACA</th>\n",
" <th>TP_NACIONALIDADE</th>\n",
" <th>CO_MUNICIPIO_NASCIMENTO</th>\n",
" <th>CO_UF_NASCIMENTO</th>\n",
" <th>...</th>\n",
" <th>Q032</th>\n",
" <th>Q033</th>\n",
" <th>Q034</th>\n",
" <th>Q035</th>\n",
" <th>Q036</th>\n",
" <th>Q037</th>\n",
" <th>Q038</th>\n",
" <th>Q039</th>\n",
" <th>Q040</th>\n",
" <th>Q041</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Unnamed: 0</th>\n",
" <td>1.000000</td>\n",
" <td>NaN</td>\n",
" <td>-0.007258</td>\n",
" <td>-0.007250</td>\n",
" <td>-0.007201</td>\n",
" <td>0.003678</td>\n",
" <td>0.005707</td>\n",
" <td>-0.006217</td>\n",
" <td>-0.004527</td>\n",
" <td>-0.004615</td>\n",
" <td>...</td>\n",
" <td>0.001520</td>\n",
" <td>0.018074</td>\n",
" <td>0.001693</td>\n",
" <td>-0.008141</td>\n",
" <td>0.002724</td>\n",
" <td>-0.004914</td>\n",
" <td>0.003906</td>\n",
" <td>0.001002</td>\n",
" <td>-0.010967</td>\n",
" <td>-0.029937</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_ANO</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
" <td>-0.007258</td>\n",
" <td>NaN</td>\n",
" <td>1.000000</td>\n",
" <td>0.999865</td>\n",
" <td>-0.002296</td>\n",
" <td>0.020813</td>\n",
" <td>-0.236178</td>\n",
" <td>0.009710</td>\n",
" <td>0.865294</td>\n",
" <td>0.865216</td>\n",
" <td>...</td>\n",
" <td>0.004115</td>\n",
" <td>-0.030114</td>\n",
" <td>-0.050304</td>\n",
" <td>-0.050138</td>\n",
" <td>-0.040668</td>\n",
" <td>-0.013479</td>\n",
" <td>-0.032710</td>\n",
" <td>-0.094862</td>\n",
" <td>-0.077456</td>\n",
" <td>-0.033205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_UF_RESIDENCIA</th>\n",
" <td>-0.007250</td>\n",
" <td>NaN</td>\n",
" <td>0.999865</td>\n",
" <td>1.000000</td>\n",
" <td>-0.002017</td>\n",
" <td>0.020947</td>\n",
" <td>-0.234786</td>\n",
" <td>0.009433</td>\n",
" <td>0.864791</td>\n",
" <td>0.864919</td>\n",
" <td>...</td>\n",
" <td>0.003968</td>\n",
" <td>-0.030345</td>\n",
" <td>-0.050096</td>\n",
" <td>-0.049292</td>\n",
" <td>-0.040688</td>\n",
" <td>-0.013647</td>\n",
" <td>-0.032467</td>\n",
" <td>-0.094113</td>\n",
" <td>-0.076838</td>\n",
" <td>-0.033149</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_IDADE</th>\n",
" <td>-0.007201</td>\n",
" <td>NaN</td>\n",
" <td>-0.002296</td>\n",
" <td>-0.002017</td>\n",
" <td>1.000000</td>\n",
" <td>0.533462</td>\n",
" <td>0.009675</td>\n",
" <td>-0.017713</td>\n",
" <td>-0.030711</td>\n",
" <td>-0.030259</td>\n",
" <td>...</td>\n",
" <td>-0.044791</td>\n",
" <td>0.025077</td>\n",
" <td>-0.030681</td>\n",
" <td>0.012739</td>\n",
" <td>0.021949</td>\n",
" <td>-0.003569</td>\n",
" <td>-0.035306</td>\n",
" <td>-0.069973</td>\n",
" <td>-0.010988</td>\n",
" <td>0.160526</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_ESTADO_CIVIL</th>\n",
" <td>0.003678</td>\n",
" <td>NaN</td>\n",
" <td>0.020813</td>\n",
" <td>0.020947</td>\n",
" <td>0.533462</td>\n",
" <td>1.000000</td>\n",
" <td>0.004950</td>\n",
" <td>-0.012160</td>\n",
" <td>-0.000046</td>\n",
" <td>0.000243</td>\n",
" <td>...</td>\n",
" <td>-0.017455</td>\n",
" <td>-0.009670</td>\n",
" <td>-0.016354</td>\n",
" <td>-0.002580</td>\n",
" <td>0.025840</td>\n",
" <td>0.002294</td>\n",
" <td>-0.014725</td>\n",
" <td>-0.066346</td>\n",
" <td>-0.022736</td>\n",
" <td>0.108771</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_COR_RACA</th>\n",
" <td>0.005707</td>\n",
" <td>NaN</td>\n",
" <td>-0.236178</td>\n",
" <td>-0.234786</td>\n",
" <td>0.009675</td>\n",
" <td>0.004950</td>\n",
" <td>1.000000</td>\n",
" <td>0.015761</td>\n",
" <td>-0.253524</td>\n",
" <td>-0.252162</td>\n",
" <td>...</td>\n",
" <td>-0.010398</td>\n",
" <td>0.004446</td>\n",
" <td>0.031514</td>\n",
" <td>0.026052</td>\n",
" <td>0.055185</td>\n",
" <td>0.086642</td>\n",
" <td>0.069298</td>\n",
" <td>0.046830</td>\n",
" <td>0.053556</td>\n",
" <td>0.020966</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_NACIONALIDADE</th>\n",
" <td>-0.006217</td>\n",
" <td>NaN</td>\n",
" <td>0.009710</td>\n",
" <td>0.009433</td>\n",
" <td>-0.017713</td>\n",
" <td>-0.012160</td>\n",
" <td>0.015761</td>\n",
" <td>1.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>0.013515</td>\n",
" <td>0.001575</td>\n",
" <td>-0.003419</td>\n",
" <td>-0.018290</td>\n",
" <td>-0.005285</td>\n",
" <td>0.032588</td>\n",
" <td>0.024112</td>\n",
" <td>0.011327</td>\n",
" <td>0.014847</td>\n",
" <td>0.008132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_MUNICIPIO_NASCIMENTO</th>\n",
" <td>-0.004527</td>\n",
" <td>NaN</td>\n",
" <td>0.865294</td>\n",
" <td>0.864791</td>\n",
" <td>-0.030711</td>\n",
" <td>-0.000046</td>\n",
" <td>-0.253524</td>\n",
" <td>NaN</td>\n",
" <td>1.000000</td>\n",
" <td>0.999860</td>\n",
" <td>...</td>\n",
" <td>-0.001793</td>\n",
" <td>-0.043358</td>\n",
" <td>-0.051102</td>\n",
" <td>-0.057239</td>\n",
" <td>-0.046998</td>\n",
" <td>-0.024174</td>\n",
" <td>-0.038666</td>\n",
" <td>-0.097273</td>\n",
" <td>-0.081490</td>\n",
" <td>-0.042237</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_UF_NASCIMENTO</th>\n",
" <td>-0.004615</td>\n",
" <td>NaN</td>\n",
" <td>0.865216</td>\n",
" <td>0.864919</td>\n",
" <td>-0.030259</td>\n",
" <td>0.000243</td>\n",
" <td>-0.252162</td>\n",
" <td>NaN</td>\n",
" <td>0.999860</td>\n",
" <td>1.000000</td>\n",
" <td>...</td>\n",
" <td>-0.002089</td>\n",
" <td>-0.043492</td>\n",
" <td>-0.051094</td>\n",
" <td>-0.056401</td>\n",
" <td>-0.047069</td>\n",
" <td>-0.024201</td>\n",
" <td>-0.038305</td>\n",
" <td>-0.096666</td>\n",
" <td>-0.080963</td>\n",
" <td>-0.042134</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_ST_CONCLUSAO</th>\n",
" <td>0.005852</td>\n",
" <td>NaN</td>\n",
" <td>0.025402</td>\n",
" <td>0.025822</td>\n",
" <td>-0.253403</td>\n",
" <td>-0.099077</td>\n",
" <td>0.000738</td>\n",
" <td>-0.000054</td>\n",
" <td>0.036523</td>\n",
" <td>0.036919</td>\n",
" <td>...</td>\n",
" <td>-0.010453</td>\n",
" <td>-0.113770</td>\n",
" <td>0.031020</td>\n",
" <td>-0.092979</td>\n",
" <td>-0.048354</td>\n",
" <td>0.001767</td>\n",
" <td>0.080592</td>\n",
" <td>0.019877</td>\n",
" <td>0.051951</td>\n",
" <td>0.028234</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_ANO_CONCLUIU</th>\n",
" <td>-0.003362</td>\n",
" <td>NaN</td>\n",
" <td>-0.032664</td>\n",
" <td>-0.032538</td>\n",
" <td>0.681435</td>\n",
" <td>0.373637</td>\n",
" <td>0.003942</td>\n",
" <td>-0.026154</td>\n",
" <td>-0.052958</td>\n",
" <td>-0.052839</td>\n",
" <td>...</td>\n",
" <td>-0.004940</td>\n",
" <td>0.122058</td>\n",
" <td>-0.035955</td>\n",
" <td>0.039764</td>\n",
" <td>0.049243</td>\n",
" <td>-0.007379</td>\n",
" <td>-0.072813</td>\n",
" <td>-0.048672</td>\n",
" <td>-0.052564</td>\n",
" <td>0.084309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_ESCOLA</th>\n",
" <td>-0.006252</td>\n",
" <td>NaN</td>\n",
" <td>0.041738</td>\n",
" <td>0.041406</td>\n",
" <td>-0.296328</td>\n",
" <td>-0.153619</td>\n",
" <td>-0.041713</td>\n",
" <td>0.024070</td>\n",
" <td>0.048779</td>\n",
" <td>0.048580</td>\n",
" <td>...</td>\n",
" <td>-0.014161</td>\n",
" <td>-0.133879</td>\n",
" <td>0.020858</td>\n",
" <td>0.011888</td>\n",
" <td>-0.010416</td>\n",
" <td>-0.019991</td>\n",
" <td>0.035877</td>\n",
" <td>0.018430</td>\n",
" <td>0.036985</td>\n",
" <td>-0.087935</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_ENSINO</th>\n",
" <td>0.011372</td>\n",
" <td>NaN</td>\n",
" <td>0.018070</td>\n",
" <td>0.018145</td>\n",
" <td>0.516253</td>\n",
" <td>0.295596</td>\n",
" <td>0.040504</td>\n",
" <td>0.020522</td>\n",
" <td>-0.002364</td>\n",
" <td>-0.002106</td>\n",
" <td>...</td>\n",
" <td>-0.045370</td>\n",
" <td>0.057219</td>\n",
" <td>0.003773</td>\n",
" <td>-0.033346</td>\n",
" <td>-0.007937</td>\n",
" <td>0.024624</td>\n",
" <td>0.041203</td>\n",
" <td>-0.029358</td>\n",
" <td>0.032923</td>\n",
" <td>0.126503</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_TREINEIRO</th>\n",
" <td>0.006717</td>\n",
" <td>NaN</td>\n",
" <td>-0.035317</td>\n",
" <td>-0.034944</td>\n",
" <td>-0.295091</td>\n",
" <td>-0.117932</td>\n",
" <td>0.009676</td>\n",
" <td>-0.015179</td>\n",
" <td>-0.018218</td>\n",
" <td>-0.018005</td>\n",
" <td>...</td>\n",
" <td>-0.000943</td>\n",
" <td>-0.071335</td>\n",
" <td>0.055265</td>\n",
" <td>-0.061032</td>\n",
" <td>-0.069476</td>\n",
" <td>-0.020651</td>\n",
" <td>0.018855</td>\n",
" <td>0.040348</td>\n",
" <td>0.005270</td>\n",
" <td>-0.046232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_ESCOLA</th>\n",
" <td>-0.000351</td>\n",
" <td>NaN</td>\n",
" <td>0.983407</td>\n",
" <td>0.983393</td>\n",
" <td>-0.019091</td>\n",
" <td>0.003213</td>\n",
" <td>-0.256299</td>\n",
" <td>0.011570</td>\n",
" <td>0.886402</td>\n",
" <td>0.886396</td>\n",
" <td>...</td>\n",
" <td>0.065956</td>\n",
" <td>0.038252</td>\n",
" <td>-0.027267</td>\n",
" <td>-0.052980</td>\n",
" <td>-0.059440</td>\n",
" <td>0.012459</td>\n",
" <td>-0.040819</td>\n",
" <td>-0.122494</td>\n",
" <td>-0.078344</td>\n",
" <td>-0.066173</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_MUNICIPIO_ESC</th>\n",
" <td>-0.000586</td>\n",
" <td>NaN</td>\n",
" <td>0.983630</td>\n",
" <td>0.983417</td>\n",
" <td>-0.019710</td>\n",
" <td>0.002774</td>\n",
" <td>-0.257769</td>\n",
" <td>0.012304</td>\n",
" <td>0.886961</td>\n",
" <td>0.886802</td>\n",
" <td>...</td>\n",
" <td>0.067116</td>\n",
" <td>0.038963</td>\n",
" <td>-0.026767</td>\n",
" <td>-0.053391</td>\n",
" <td>-0.059404</td>\n",
" <td>0.012914</td>\n",
" <td>-0.040648</td>\n",
" <td>-0.123456</td>\n",
" <td>-0.078338</td>\n",
" <td>-0.065058</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CO_UF_ESC</th>\n",
" <td>-0.000214</td>\n",
" <td>NaN</td>\n",
" <td>0.983488</td>\n",
" <td>0.983552</td>\n",
" <td>-0.019013</td>\n",
" <td>0.002854</td>\n",
" <td>-0.255696</td>\n",
" <td>0.011734</td>\n",
" <td>0.886473</td>\n",
" <td>0.886542</td>\n",
" <td>...</td>\n",
" <td>0.065871</td>\n",
" <td>0.038237</td>\n",
" <td>-0.026826</td>\n",
" <td>-0.052553</td>\n",
" <td>-0.059335</td>\n",
" <td>0.012547</td>\n",
" <td>-0.040294</td>\n",
" <td>-0.122504</td>\n",
" <td>-0.077712</td>\n",
" <td>-0.064864</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_DEPENDENCIA_ADM_ESC</th>\n",
" <td>-0.011217</td>\n",
" <td>NaN</td>\n",
" <td>0.080064</td>\n",
" <td>0.079229</td>\n",
" <td>-0.082980</td>\n",
" <td>-0.036364</td>\n",
" <td>-0.172229</td>\n",
" <td>-0.012981</td>\n",
" <td>0.079579</td>\n",
" <td>0.078843</td>\n",
" <td>...</td>\n",
" <td>-0.065096</td>\n",
" <td>-0.127836</td>\n",
" <td>-0.039220</td>\n",
" <td>0.033621</td>\n",
" <td>-0.096330</td>\n",
" <td>-0.242419</td>\n",
" <td>-0.145333</td>\n",
" <td>-0.005773</td>\n",
" <td>-0.059893</td>\n",
" <td>-0.104268</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_LOCALIZACAO_ESC</th>\n",
" <td>-0.013523</td>\n",
" <td>NaN</td>\n",
" <td>-0.055710</td>\n",
" <td>-0.054736</td>\n",
" <td>0.009653</td>\n",
" <td>-0.013583</td>\n",
" <td>0.059965</td>\n",
" <td>-0.017525</td>\n",
" <td>-0.056358</td>\n",
" <td>-0.055630</td>\n",
" <td>...</td>\n",
" <td>-0.037945</td>\n",
" <td>-0.064740</td>\n",
" <td>-0.007511</td>\n",
" <td>-0.023955</td>\n",
" <td>0.005273</td>\n",
" <td>-0.017336</td>\n",
" <td>0.005955</td>\n",
" <td>0.010145</td>\n",
" <td>-0.003063</td>\n",
" <td>-0.023198</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_SIT_FUNC_ESC</th>\n",
" <td>0.019805</td>\n",
" <td>NaN</td>\n",
" <td>0.024364</td>\n",
" <td>0.024666</td>\n",
" <td>0.007082</td>\n",
" <td>-0.006323</td>\n",
" <td>-0.024081</td>\n",
" <td>-0.008031</td>\n",
" <td>0.026327</td>\n",
" <td>0.026616</td>\n",
" <td>...</td>\n",
" <td>0.013276</td>\n",
" <td>0.007205</td>\n",
" <td>0.001305</td>\n",
" <td>0.008600</td>\n",
" <td>-0.030003</td>\n",
" <td>0.007576</td>\n",
" <td>-0.030931</td>\n",
" <td>-0.027551</td>\n",
" <td>-0.053643</td>\n",
" <td>-0.047072</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_BAIXA_VISAO</th>\n",
" <td>0.003334</td>\n",
" <td>NaN</td>\n",
" <td>0.001188</td>\n",
" <td>0.001360</td>\n",
" <td>0.027907</td>\n",
" <td>0.023243</td>\n",
" <td>-0.014715</td>\n",
" <td>0.009354</td>\n",
" <td>0.018112</td>\n",
" <td>0.018324</td>\n",
" <td>...</td>\n",
" <td>-0.047254</td>\n",
" <td>-0.020079</td>\n",
" <td>-0.006691</td>\n",
" <td>-0.006066</td>\n",
" <td>-0.020333</td>\n",
" <td>-0.030724</td>\n",
" <td>-0.028589</td>\n",
" <td>-0.013989</td>\n",
" <td>-0.009669</td>\n",
" <td>0.014038</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_CEGUEIRA</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_SURDEZ</th>\n",
" <td>0.007724</td>\n",
" <td>NaN</td>\n",
" <td>-0.010872</td>\n",
" <td>-0.010716</td>\n",
" <td>0.006520</td>\n",
" <td>0.025740</td>\n",
" <td>0.007852</td>\n",
" <td>0.011142</td>\n",
" <td>-0.003174</td>\n",
" <td>-0.003032</td>\n",
" <td>...</td>\n",
" <td>0.002886</td>\n",
" <td>-0.012876</td>\n",
" <td>-0.009235</td>\n",
" <td>-0.010557</td>\n",
" <td>0.007342</td>\n",
" <td>-0.007300</td>\n",
" <td>-0.003668</td>\n",
" <td>0.001039</td>\n",
" <td>0.002551</td>\n",
" <td>0.012383</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_DEFICIENCIA_AUDITIVA</th>\n",
" <td>0.004315</td>\n",
" <td>NaN</td>\n",
" <td>0.012790</td>\n",
" <td>0.013035</td>\n",
" <td>0.011380</td>\n",
" <td>-0.006761</td>\n",
" <td>-0.004163</td>\n",
" <td>-0.004264</td>\n",
" <td>0.006800</td>\n",
" <td>0.006825</td>\n",
" <td>...</td>\n",
" <td>-0.000738</td>\n",
" <td>0.000574</td>\n",
" <td>-0.019336</td>\n",
" <td>-0.017714</td>\n",
" <td>-0.004506</td>\n",
" <td>-0.011326</td>\n",
" <td>-0.003958</td>\n",
" <td>-0.002900</td>\n",
" <td>-0.005720</td>\n",
" <td>0.003471</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_SURDO_CEGUEIRA</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_DEFICIENCIA_FISICA</th>\n",
" <td>0.005417</td>\n",
" <td>NaN</td>\n",
" <td>-0.001965</td>\n",
" <td>-0.001914</td>\n",
" <td>0.036361</td>\n",
" <td>0.043869</td>\n",
" <td>-0.002431</td>\n",
" <td>0.003217</td>\n",
" <td>0.001364</td>\n",
" <td>0.001534</td>\n",
" <td>...</td>\n",
" <td>0.009304</td>\n",
" <td>-0.001236</td>\n",
" <td>0.006152</td>\n",
" <td>0.013789</td>\n",
" <td>0.008888</td>\n",
" <td>0.002899</td>\n",
" <td>-0.001605</td>\n",
" <td>-0.006527</td>\n",
" <td>0.007574</td>\n",
" <td>0.019857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_DEFICIENCIA_MENTAL</th>\n",
" <td>0.004539</td>\n",
" <td>NaN</td>\n",
" <td>0.000846</td>\n",
" <td>0.000934</td>\n",
" <td>0.000696</td>\n",
" <td>-0.003903</td>\n",
" <td>0.009759</td>\n",
" <td>-0.002279</td>\n",
" <td>0.001272</td>\n",
" <td>0.001367</td>\n",
" <td>...</td>\n",
" <td>0.005736</td>\n",
" <td>0.008006</td>\n",
" <td>0.004645</td>\n",
" <td>0.004487</td>\n",
" <td>-0.002408</td>\n",
" <td>0.005441</td>\n",
" <td>-0.008750</td>\n",
" <td>-0.007067</td>\n",
" <td>0.005699</td>\n",
" <td>0.014038</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_DEFICIT_ATENCAO</th>\n",
" <td>0.000268</td>\n",
" <td>NaN</td>\n",
" <td>0.012051</td>\n",
" <td>0.011867</td>\n",
" <td>-0.006294</td>\n",
" <td>-0.009564</td>\n",
" <td>-0.012727</td>\n",
" <td>0.003336</td>\n",
" <td>0.015845</td>\n",
" <td>0.015606</td>\n",
" <td>...</td>\n",
" <td>-0.000522</td>\n",
" <td>0.011324</td>\n",
" <td>-0.003581</td>\n",
" <td>-0.002244</td>\n",
" <td>-0.021358</td>\n",
" <td>-0.059131</td>\n",
" <td>-0.010402</td>\n",
" <td>-0.017337</td>\n",
" <td>-0.029558</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IN_DISLEXIA</th>\n",
" <td>0.012234</td>\n",
" <td>NaN</td>\n",
" <td>0.003969</td>\n",
" <td>0.003689</td>\n",
" <td>0.000492</td>\n",
" <td>-0.002760</td>\n",
" <td>-0.010046</td>\n",
" <td>-0.001611</td>\n",
" <td>0.004414</td>\n",
" <td>0.004127</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>-0.005983</td>\n",
" <td>0.003173</td>\n",
" <td>0.008268</td>\n",
" <td>-0.017487</td>\n",
" <td>-0.003661</td>\n",
" <td>-0.002515</td>\n",
" <td>-0.010417</td>\n",
" <td>NaN</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>TP_PRESENCA_CN</th>\n",
" <td>0.017135</td>\n",
" <td>NaN</td>\n",
" <td>-0.035441</td>\n",
" <td>-0.035438</td>\n",
" <td>-0.245190</td>\n",
" <td>-0.153870</td>\n",
" <td>-0.024471</td>\n",
" <td>-0.020359</td>\n",
" <td>-0.023048</td>\n",
" <td>-0.023120</td>\n",
" <td>...</td>\n",
" <td>-0.021150</td>\n",
" <td>-0.034084</td>\n",
" <td>0.012139</td>\n",
" <td>0.035485</td>\n",
" <td>-0.038984</td>\n",
" <td>-0.028485</td>\n",
" <td>-0.016003</td>\n",
" <td>0.029835</td>\n",
" <td>-0.013657</td>\n",
" <td>-0.054062</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_PRESENCA_CH</th>\n",
" <td>0.017135</td>\n",
" <td>NaN</td>\n",
" <td>-0.035441</td>\n",
" <td>-0.035438</td>\n",
" <td>-0.245190</td>\n",
" <td>-0.153870</td>\n",
" <td>-0.024471</td>\n",
" <td>-0.020359</td>\n",
" <td>-0.023048</td>\n",
" <td>-0.023120</td>\n",
" <td>...</td>\n",
" <td>-0.021150</td>\n",
" <td>-0.034084</td>\n",
" <td>0.012139</td>\n",
" <td>0.035485</td>\n",
" <td>-0.038984</td>\n",
" <td>-0.028485</td>\n",
" <td>-0.016003</td>\n",
" <td>0.029835</td>\n",
" <td>-0.013657</td>\n",
" <td>-0.054062</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_PRESENCA_LC</th>\n",
" <td>0.017073</td>\n",
" <td>NaN</td>\n",
" <td>-0.034269</td>\n",
" <td>-0.034287</td>\n",
" <td>-0.241092</td>\n",
" <td>-0.150748</td>\n",
" <td>-0.021861</td>\n",
" <td>-0.024097</td>\n",
" <td>-0.022827</td>\n",
" <td>-0.022934</td>\n",
" <td>...</td>\n",
" <td>-0.024603</td>\n",
" <td>-0.036928</td>\n",
" <td>0.015406</td>\n",
" <td>0.036456</td>\n",
" <td>-0.037794</td>\n",
" <td>-0.026968</td>\n",
" <td>-0.019277</td>\n",
" <td>0.023827</td>\n",
" <td>-0.016834</td>\n",
" <td>-0.050498</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_PRESENCA_MT</th>\n",
" <td>0.017073</td>\n",
" <td>NaN</td>\n",
" <td>-0.034269</td>\n",
" <td>-0.034287</td>\n",
" <td>-0.241092</td>\n",
" <td>-0.150748</td>\n",
" <td>-0.021861</td>\n",
" <td>-0.024097</td>\n",
" <td>-0.022827</td>\n",
" <td>-0.022934</td>\n",
" <td>...</td>\n",
" <td>-0.024603</td>\n",
" <td>-0.036928</td>\n",
" <td>0.015406</td>\n",
" <td>0.036456</td>\n",
" <td>-0.037794</td>\n",
" <td>-0.026968</td>\n",
" <td>-0.019277</td>\n",
" <td>0.023827</td>\n",
" <td>-0.016834</td>\n",
" <td>-0.050498</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_CN</th>\n",
" <td>0.000970</td>\n",
" <td>NaN</td>\n",
" <td>0.085643</td>\n",
" <td>0.084534</td>\n",
" <td>-0.056171</td>\n",
" <td>-0.049384</td>\n",
" <td>-0.149429</td>\n",
" <td>-0.039746</td>\n",
" <td>0.092466</td>\n",
" <td>0.091436</td>\n",
" <td>...</td>\n",
" <td>-0.094999</td>\n",
" <td>-0.100490</td>\n",
" <td>-0.084112</td>\n",
" <td>0.031346</td>\n",
" <td>-0.129898</td>\n",
" <td>-0.273410</td>\n",
" <td>-0.202920</td>\n",
" <td>-0.000128</td>\n",
" <td>-0.113885</td>\n",
" <td>-0.119035</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_CH</th>\n",
" <td>-0.008336</td>\n",
" <td>NaN</td>\n",
" <td>0.124272</td>\n",
" <td>0.122825</td>\n",
" <td>-0.001611</td>\n",
" <td>-0.013475</td>\n",
" <td>-0.161831</td>\n",
" <td>-0.049801</td>\n",
" <td>0.131918</td>\n",
" <td>0.130598</td>\n",
" <td>...</td>\n",
" <td>-0.068755</td>\n",
" <td>-0.059146</td>\n",
" <td>-0.083110</td>\n",
" <td>0.041605</td>\n",
" <td>-0.134443</td>\n",
" <td>-0.235883</td>\n",
" <td>-0.221562</td>\n",
" <td>-0.039593</td>\n",
" <td>-0.133741</td>\n",
" <td>-0.118760</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_LC</th>\n",
" <td>-0.006097</td>\n",
" <td>NaN</td>\n",
" <td>0.130161</td>\n",
" <td>0.128479</td>\n",
" <td>-0.024979</td>\n",
" <td>-0.024306</td>\n",
" <td>-0.168624</td>\n",
" <td>-0.049631</td>\n",
" <td>0.132173</td>\n",
" <td>0.130673</td>\n",
" <td>...</td>\n",
" <td>-0.042855</td>\n",
" <td>-0.059173</td>\n",
" <td>-0.083234</td>\n",
" <td>0.033435</td>\n",
" <td>-0.125487</td>\n",
" <td>-0.212129</td>\n",
" <td>-0.221847</td>\n",
" <td>-0.052357</td>\n",
" <td>-0.128051</td>\n",
" <td>-0.118779</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_MT</th>\n",
" <td>0.006530</td>\n",
" <td>NaN</td>\n",
" <td>0.108850</td>\n",
" <td>0.107493</td>\n",
" <td>-0.061485</td>\n",
" <td>-0.035393</td>\n",
" <td>-0.157364</td>\n",
" <td>-0.034965</td>\n",
" <td>0.113416</td>\n",
" <td>0.112236</td>\n",
" <td>...</td>\n",
" <td>-0.090325</td>\n",
" <td>-0.114083</td>\n",
" <td>-0.104780</td>\n",
" <td>0.031685</td>\n",
" <td>-0.145501</td>\n",
" <td>-0.265249</td>\n",
" <td>-0.202259</td>\n",
" <td>-0.019360</td>\n",
" <td>-0.119997</td>\n",
" <td>-0.131795</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_LINGUA</th>\n",
" <td>0.007925</td>\n",
" <td>NaN</td>\n",
" <td>-0.098682</td>\n",
" <td>-0.096473</td>\n",
" <td>0.082065</td>\n",
" <td>0.054704</td>\n",
" <td>0.116860</td>\n",
" <td>0.015266</td>\n",
" <td>-0.108556</td>\n",
" <td>-0.106415</td>\n",
" <td>...</td>\n",
" <td>0.009185</td>\n",
" <td>0.038196</td>\n",
" <td>0.036835</td>\n",
" <td>0.025548</td>\n",
" <td>0.058586</td>\n",
" <td>0.106602</td>\n",
" <td>0.092053</td>\n",
" <td>0.019176</td>\n",
" <td>0.060805</td>\n",
" <td>0.053789</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TP_STATUS_REDACAO</th>\n",
" <td>0.000369</td>\n",
" <td>NaN</td>\n",
" <td>-0.017227</td>\n",
" <td>-0.016955</td>\n",
" <td>0.055675</td>\n",
" <td>0.035152</td>\n",
" <td>0.020586</td>\n",
" <td>0.005211</td>\n",
" <td>-0.023882</td>\n",
" <td>-0.023695</td>\n",
" <td>...</td>\n",
" <td>-0.040251</td>\n",
" <td>-0.011527</td>\n",
" <td>-0.017759</td>\n",
" <td>-0.009929</td>\n",
" <td>0.007216</td>\n",
" <td>0.011440</td>\n",
" <td>0.017835</td>\n",
" <td>0.010357</td>\n",
" <td>0.003761</td>\n",
" <td>0.009012</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_COMP1</th>\n",
" <td>-0.002789</td>\n",
" <td>NaN</td>\n",
" <td>0.069971</td>\n",
" <td>0.069195</td>\n",
" <td>-0.102243</td>\n",
" <td>-0.052769</td>\n",
" <td>-0.097606</td>\n",
" <td>-0.031126</td>\n",
" <td>0.082979</td>\n",
" <td>0.082136</td>\n",
" <td>...</td>\n",
" <td>0.018366</td>\n",
" <td>-0.009741</td>\n",
" <td>-0.027431</td>\n",
" <td>0.025580</td>\n",
" <td>-0.089333</td>\n",
" <td>-0.136336</td>\n",
" <td>-0.141339</td>\n",
" <td>-0.032053</td>\n",
" <td>-0.081407</td>\n",
" <td>-0.088096</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_COMP2</th>\n",
" <td>-0.004959</td>\n",
" <td>NaN</td>\n",
" <td>0.048547</td>\n",
" <td>0.047746</td>\n",
" <td>-0.114181</td>\n",
" <td>-0.067324</td>\n",
" <td>-0.090291</td>\n",
" <td>-0.030800</td>\n",
" <td>0.063531</td>\n",
" <td>0.062861</td>\n",
" <td>...</td>\n",
" <td>0.004089</td>\n",
" <td>-0.008846</td>\n",
" <td>-0.033403</td>\n",
" <td>0.034569</td>\n",
" <td>-0.091875</td>\n",
" <td>-0.173082</td>\n",
" <td>-0.157421</td>\n",
" <td>-0.024866</td>\n",
" <td>-0.095383</td>\n",
" <td>-0.082863</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_COMP3</th>\n",
" <td>-0.004945</td>\n",
" <td>NaN</td>\n",
" <td>0.051289</td>\n",
" <td>0.050400</td>\n",
" <td>-0.104293</td>\n",
" <td>-0.060856</td>\n",
" <td>-0.096344</td>\n",
" <td>-0.027184</td>\n",
" <td>0.067943</td>\n",
" <td>0.067181</td>\n",
" <td>...</td>\n",
" <td>0.001432</td>\n",
" <td>-0.019752</td>\n",
" <td>-0.031051</td>\n",
" <td>0.041211</td>\n",
" <td>-0.100383</td>\n",
" <td>-0.177818</td>\n",
" <td>-0.164138</td>\n",
" <td>-0.023113</td>\n",
" <td>-0.099993</td>\n",
" <td>-0.069967</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_COMP4</th>\n",
" <td>-0.003911</td>\n",
" <td>NaN</td>\n",
" <td>0.062718</td>\n",
" <td>0.061881</td>\n",
" <td>-0.110452</td>\n",
" <td>-0.064127</td>\n",
" <td>-0.102936</td>\n",
" <td>-0.031422</td>\n",
" <td>0.074401</td>\n",
" <td>0.073592</td>\n",
" <td>...</td>\n",
" <td>-0.005205</td>\n",
" <td>-0.019351</td>\n",
" <td>-0.025741</td>\n",
" <td>0.037275</td>\n",
" <td>-0.088738</td>\n",
" <td>-0.159789</td>\n",
" <td>-0.153423</td>\n",
" <td>-0.022182</td>\n",
" <td>-0.090415</td>\n",
" <td>-0.082042</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_COMP5</th>\n",
" <td>-0.011240</td>\n",
" <td>NaN</td>\n",
" <td>0.044335</td>\n",
" <td>0.043565</td>\n",
" <td>-0.086709</td>\n",
" <td>-0.040135</td>\n",
" <td>-0.091136</td>\n",
" <td>-0.025561</td>\n",
" <td>0.045327</td>\n",
" <td>0.044690</td>\n",
" <td>...</td>\n",
" <td>-0.003048</td>\n",
" <td>-0.026208</td>\n",
" <td>-0.040076</td>\n",
" <td>0.052849</td>\n",
" <td>-0.093167</td>\n",
" <td>-0.175356</td>\n",
" <td>-0.147931</td>\n",
" <td>-0.006653</td>\n",
" <td>-0.084367</td>\n",
" <td>-0.057855</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NU_NOTA_REDACAO</th>\n",
" <td>-0.006711</td>\n",
" <td>NaN</td>\n",
" <td>0.061549</td>\n",
" <td>0.060629</td>\n",
" <td>-0.116125</td>\n",
" <td>-0.063570</td>\n",
" <td>-0.107840</td>\n",
" <td>-0.032759</td>\n",
" <td>0.073846</td>\n",
" <td>0.073013</td>\n",
" <td>...</td>\n",
" <td>0.002906</td>\n",
" <td>-0.019940</td>\n",
" <td>-0.036293</td>\n",
" <td>0.044519</td>\n",
" <td>-0.104972</td>\n",
" <td>-0.187413</td>\n",
" <td>-0.172875</td>\n",
" <td>-0.023452</td>\n",
" <td>-0.102026</td>\n",
" <td>-0.087124</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q005</th>\n",
" <td>-0.002971</td>\n",
" <td>NaN</td>\n",
" <td>-0.117804</td>\n",
" <td>-0.117288</td>\n",
" <td>-0.097169</td>\n",
" <td>-0.104883</td>\n",
" <td>0.096772</td>\n",
" <td>0.018954</td>\n",
" <td>-0.107950</td>\n",
" <td>-0.107347</td>\n",
" <td>...</td>\n",
" <td>0.008208</td>\n",
" <td>-0.035427</td>\n",
" <td>0.027044</td>\n",
" <td>0.017361</td>\n",
" <td>0.002087</td>\n",
" <td>0.041987</td>\n",
" <td>0.046494</td>\n",
" <td>0.042499</td>\n",
" <td>0.053892</td>\n",
" <td>0.034236</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q029</th>\n",
" <td>0.012977</td>\n",
" <td>NaN</td>\n",
" <td>-0.073321</td>\n",
" <td>-0.073029</td>\n",
" <td>-0.035952</td>\n",
" <td>-0.079450</td>\n",
" <td>0.058776</td>\n",
" <td>0.018761</td>\n",
" <td>-0.082560</td>\n",
" <td>-0.082275</td>\n",
" <td>...</td>\n",
" <td>0.225648</td>\n",
" <td>0.320981</td>\n",
" <td>0.188397</td>\n",
" <td>0.148412</td>\n",
" <td>0.137702</td>\n",
" <td>0.172342</td>\n",
" <td>0.169494</td>\n",
" <td>0.183869</td>\n",
" <td>0.181488</td>\n",
" <td>0.164861</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q030</th>\n",
" <td>0.000160</td>\n",
" <td>NaN</td>\n",
" <td>-0.079831</td>\n",
" <td>-0.078885</td>\n",
" <td>0.418387</td>\n",
" <td>0.348302</td>\n",
" <td>0.059865</td>\n",
" <td>-0.007630</td>\n",
" <td>-0.110083</td>\n",
" <td>-0.109386</td>\n",
" <td>...</td>\n",
" <td>0.129877</td>\n",
" <td>0.228742</td>\n",
" <td>0.082049</td>\n",
" <td>0.085898</td>\n",
" <td>0.105733</td>\n",
" <td>0.093032</td>\n",
" <td>0.130559</td>\n",
" <td>0.094260</td>\n",
" <td>0.146498</td>\n",
" <td>0.254543</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q031</th>\n",
" <td>0.023548</td>\n",
" <td>NaN</td>\n",
" <td>-0.025616</td>\n",
" <td>-0.025491</td>\n",
" <td>0.018634</td>\n",
" <td>-0.016960</td>\n",
" <td>0.003155</td>\n",
" <td>0.000202</td>\n",
" <td>-0.024254</td>\n",
" <td>-0.023908</td>\n",
" <td>...</td>\n",
" <td>0.524584</td>\n",
" <td>0.343212</td>\n",
" <td>0.196486</td>\n",
" <td>0.168763</td>\n",
" <td>0.138909</td>\n",
" <td>0.118516</td>\n",
" <td>0.101342</td>\n",
" <td>0.104165</td>\n",
" <td>0.157666</td>\n",
" <td>0.133700</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q032</th>\n",
" <td>0.001520</td>\n",
" <td>NaN</td>\n",
" <td>0.004115</td>\n",
" <td>0.003968</td>\n",
" <td>-0.044791</td>\n",
" <td>-0.017455</td>\n",
" <td>-0.010398</td>\n",
" <td>0.013515</td>\n",
" <td>-0.001793</td>\n",
" <td>-0.002089</td>\n",
" <td>...</td>\n",
" <td>1.000000</td>\n",
" <td>0.375848</td>\n",
" <td>0.279328</td>\n",
" <td>0.189872</td>\n",
" <td>0.168574</td>\n",
" <td>0.220839</td>\n",
" <td>0.159887</td>\n",
" <td>0.144264</td>\n",
" <td>0.215292</td>\n",
" <td>0.233832</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q033</th>\n",
" <td>0.018074</td>\n",
" <td>NaN</td>\n",
" <td>-0.030114</td>\n",
" <td>-0.030345</td>\n",
" <td>0.025077</td>\n",
" <td>-0.009670</td>\n",
" <td>0.004446</td>\n",
" <td>0.001575</td>\n",
" <td>-0.043358</td>\n",
" <td>-0.043492</td>\n",
" <td>...</td>\n",
" <td>0.375848</td>\n",
" <td>1.000000</td>\n",
" <td>0.204584</td>\n",
" <td>0.158553</td>\n",
" <td>0.233115</td>\n",
" <td>0.225791</td>\n",
" <td>0.223508</td>\n",
" <td>0.206979</td>\n",
" <td>0.176028</td>\n",
" <td>0.205239</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q034</th>\n",
" <td>0.001693</td>\n",
" <td>NaN</td>\n",
" <td>-0.050304</td>\n",
" <td>-0.050096</td>\n",
" <td>-0.030681</td>\n",
" <td>-0.016354</td>\n",
" <td>0.031514</td>\n",
" <td>-0.003419</td>\n",
" <td>-0.051102</td>\n",
" <td>-0.051094</td>\n",
" <td>...</td>\n",
" <td>0.279328</td>\n",
" <td>0.204584</td>\n",
" <td>1.000000</td>\n",
" <td>0.294599</td>\n",
" <td>0.176742</td>\n",
" <td>0.245757</td>\n",
" <td>0.215767</td>\n",
" <td>0.189252</td>\n",
" <td>0.243190</td>\n",
" <td>0.154743</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q035</th>\n",
" <td>-0.008141</td>\n",
" <td>NaN</td>\n",
" <td>-0.050138</td>\n",
" <td>-0.049292</td>\n",
" <td>0.012739</td>\n",
" <td>-0.002580</td>\n",
" <td>0.026052</td>\n",
" <td>-0.018290</td>\n",
" <td>-0.057239</td>\n",
" <td>-0.056401</td>\n",
" <td>...</td>\n",
" <td>0.189872</td>\n",
" <td>0.158553</td>\n",
" <td>0.294599</td>\n",
" <td>1.000000</td>\n",
" <td>0.112920</td>\n",
" <td>0.202230</td>\n",
" <td>0.142610</td>\n",
" <td>0.225724</td>\n",
" <td>0.179292</td>\n",
" <td>0.113574</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q036</th>\n",
" <td>0.002724</td>\n",
" <td>NaN</td>\n",
" <td>-0.040668</td>\n",
" <td>-0.040688</td>\n",
" <td>0.021949</td>\n",
" <td>0.025840</td>\n",
" <td>0.055185</td>\n",
" <td>-0.005285</td>\n",
" <td>-0.046998</td>\n",
" <td>-0.047069</td>\n",
" <td>...</td>\n",
" <td>0.168574</td>\n",
" <td>0.233115</td>\n",
" <td>0.176742</td>\n",
" <td>0.112920</td>\n",
" <td>1.000000</td>\n",
" <td>0.387722</td>\n",
" <td>0.378421</td>\n",
" <td>0.270343</td>\n",
" <td>0.177025</td>\n",
" <td>0.214736</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q037</th>\n",
" <td>-0.004914</td>\n",
" <td>NaN</td>\n",
" <td>-0.013479</td>\n",
" <td>-0.013647</td>\n",
" <td>-0.003569</td>\n",
" <td>0.002294</td>\n",
" <td>0.086642</td>\n",
" <td>0.032588</td>\n",
" <td>-0.024174</td>\n",
" <td>-0.024201</td>\n",
" <td>...</td>\n",
" <td>0.220839</td>\n",
" <td>0.225791</td>\n",
" <td>0.245757</td>\n",
" <td>0.202230</td>\n",
" <td>0.387722</td>\n",
" <td>1.000000</td>\n",
" <td>0.496678</td>\n",
" <td>0.254418</td>\n",
" <td>0.270380</td>\n",
" <td>0.187921</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q038</th>\n",
" <td>0.003906</td>\n",
" <td>NaN</td>\n",
" <td>-0.032710</td>\n",
" <td>-0.032467</td>\n",
" <td>-0.035306</td>\n",
" <td>-0.014725</td>\n",
" <td>0.069298</td>\n",
" <td>0.024112</td>\n",
" <td>-0.038666</td>\n",
" <td>-0.038305</td>\n",
" <td>...</td>\n",
" <td>0.159887</td>\n",
" <td>0.223508</td>\n",
" <td>0.215767</td>\n",
" <td>0.142610</td>\n",
" <td>0.378421</td>\n",
" <td>0.496678</td>\n",
" <td>1.000000</td>\n",
" <td>0.374424</td>\n",
" <td>0.259947</td>\n",
" <td>0.219529</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q039</th>\n",
" <td>0.001002</td>\n",
" <td>NaN</td>\n",
" <td>-0.094862</td>\n",
" <td>-0.094113</td>\n",
" <td>-0.069973</td>\n",
" <td>-0.066346</td>\n",
" <td>0.046830</td>\n",
" <td>0.011327</td>\n",
" <td>-0.097273</td>\n",
" <td>-0.096666</td>\n",
" <td>...</td>\n",
" <td>0.144264</td>\n",
" <td>0.206979</td>\n",
" <td>0.189252</td>\n",
" <td>0.225724</td>\n",
" <td>0.270343</td>\n",
" <td>0.254418</td>\n",
" <td>0.374424</td>\n",
" <td>1.000000</td>\n",
" <td>0.305357</td>\n",
" <td>0.262031</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q040</th>\n",
" <td>-0.010967</td>\n",
" <td>NaN</td>\n",
" <td>-0.077456</td>\n",
" <td>-0.076838</td>\n",
" <td>-0.010988</td>\n",
" <td>-0.022736</td>\n",
" <td>0.053556</td>\n",
" <td>0.014847</td>\n",
" <td>-0.081490</td>\n",
" <td>-0.080963</td>\n",
" <td>...</td>\n",
" <td>0.215292</td>\n",
" <td>0.176028</td>\n",
" <td>0.243190</td>\n",
" <td>0.179292</td>\n",
" <td>0.177025</td>\n",
" <td>0.270380</td>\n",
" <td>0.259947</td>\n",
" <td>0.305357</td>\n",
" <td>1.000000</td>\n",
" <td>0.306438</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Q041</th>\n",
" <td>-0.029937</td>\n",
" <td>NaN</td>\n",
" <td>-0.033205</td>\n",
" <td>-0.033149</td>\n",
" <td>0.160526</td>\n",
" <td>0.108771</td>\n",
" <td>0.020966</td>\n",
" <td>0.008132</td>\n",
" <td>-0.042237</td>\n",
" <td>-0.042134</td>\n",
" <td>...</td>\n",
" <td>0.233832</td>\n",
" <td>0.205239</td>\n",
" <td>0.154743</td>\n",
" <td>0.113574</td>\n",
" <td>0.214736</td>\n",
" <td>0.187921</td>\n",
" <td>0.219529</td>\n",
" <td>0.262031</td>\n",
" <td>0.306438</td>\n",
" <td>1.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>107 rows × 107 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 NU_ANO CO_MUNICIPIO_RESIDENCIA \\\n",
"Unnamed: 0 1.000000 NaN -0.007258 \n",
"NU_ANO NaN NaN NaN \n",
"CO_MUNICIPIO_RESIDENCIA -0.007258 NaN 1.000000 \n",
"CO_UF_RESIDENCIA -0.007250 NaN 0.999865 \n",
"NU_IDADE -0.007201 NaN -0.002296 \n",
"TP_ESTADO_CIVIL 0.003678 NaN 0.020813 \n",
"TP_COR_RACA 0.005707 NaN -0.236178 \n",
"TP_NACIONALIDADE -0.006217 NaN 0.009710 \n",
"CO_MUNICIPIO_NASCIMENTO -0.004527 NaN 0.865294 \n",
"CO_UF_NASCIMENTO -0.004615 NaN 0.865216 \n",
"TP_ST_CONCLUSAO 0.005852 NaN 0.025402 \n",
"TP_ANO_CONCLUIU -0.003362 NaN -0.032664 \n",
"TP_ESCOLA -0.006252 NaN 0.041738 \n",
"TP_ENSINO 0.011372 NaN 0.018070 \n",
"IN_TREINEIRO 0.006717 NaN -0.035317 \n",
"CO_ESCOLA -0.000351 NaN 0.983407 \n",
"CO_MUNICIPIO_ESC -0.000586 NaN 0.983630 \n",
"CO_UF_ESC -0.000214 NaN 0.983488 \n",
"TP_DEPENDENCIA_ADM_ESC -0.011217 NaN 0.080064 \n",
"TP_LOCALIZACAO_ESC -0.013523 NaN -0.055710 \n",
"TP_SIT_FUNC_ESC 0.019805 NaN 0.024364 \n",
"IN_BAIXA_VISAO 0.003334 NaN 0.001188 \n",
"IN_CEGUEIRA NaN NaN NaN \n",
"IN_SURDEZ 0.007724 NaN -0.010872 \n",
"IN_DEFICIENCIA_AUDITIVA 0.004315 NaN 0.012790 \n",
"IN_SURDO_CEGUEIRA NaN NaN NaN \n",
"IN_DEFICIENCIA_FISICA 0.005417 NaN -0.001965 \n",
"IN_DEFICIENCIA_MENTAL 0.004539 NaN 0.000846 \n",
"IN_DEFICIT_ATENCAO 0.000268 NaN 0.012051 \n",
"IN_DISLEXIA 0.012234 NaN 0.003969 \n",
"... ... ... ... \n",
"TP_PRESENCA_CN 0.017135 NaN -0.035441 \n",
"TP_PRESENCA_CH 0.017135 NaN -0.035441 \n",
"TP_PRESENCA_LC 0.017073 NaN -0.034269 \n",
"TP_PRESENCA_MT 0.017073 NaN -0.034269 \n",
"NU_NOTA_CN 0.000970 NaN 0.085643 \n",
"NU_NOTA_CH -0.008336 NaN 0.124272 \n",
"NU_NOTA_LC -0.006097 NaN 0.130161 \n",
"NU_NOTA_MT 0.006530 NaN 0.108850 \n",
"TP_LINGUA 0.007925 NaN -0.098682 \n",
"TP_STATUS_REDACAO 0.000369 NaN -0.017227 \n",
"NU_NOTA_COMP1 -0.002789 NaN 0.069971 \n",
"NU_NOTA_COMP2 -0.004959 NaN 0.048547 \n",
"NU_NOTA_COMP3 -0.004945 NaN 0.051289 \n",
"NU_NOTA_COMP4 -0.003911 NaN 0.062718 \n",
"NU_NOTA_COMP5 -0.011240 NaN 0.044335 \n",
"NU_NOTA_REDACAO -0.006711 NaN 0.061549 \n",
"Q005 -0.002971 NaN -0.117804 \n",
"Q029 0.012977 NaN -0.073321 \n",
"Q030 0.000160 NaN -0.079831 \n",
"Q031 0.023548 NaN -0.025616 \n",
"Q032 0.001520 NaN 0.004115 \n",
"Q033 0.018074 NaN -0.030114 \n",
"Q034 0.001693 NaN -0.050304 \n",
"Q035 -0.008141 NaN -0.050138 \n",
"Q036 0.002724 NaN -0.040668 \n",
"Q037 -0.004914 NaN -0.013479 \n",
"Q038 0.003906 NaN -0.032710 \n",
"Q039 0.001002 NaN -0.094862 \n",
"Q040 -0.010967 NaN -0.077456 \n",
"Q041 -0.029937 NaN -0.033205 \n",
"\n",
" CO_UF_RESIDENCIA NU_IDADE TP_ESTADO_CIVIL \\\n",
"Unnamed: 0 -0.007250 -0.007201 0.003678 \n",
"NU_ANO NaN NaN NaN \n",
"CO_MUNICIPIO_RESIDENCIA 0.999865 -0.002296 0.020813 \n",
"CO_UF_RESIDENCIA 1.000000 -0.002017 0.020947 \n",
"NU_IDADE -0.002017 1.000000 0.533462 \n",
"TP_ESTADO_CIVIL 0.020947 0.533462 1.000000 \n",
"TP_COR_RACA -0.234786 0.009675 0.004950 \n",
"TP_NACIONALIDADE 0.009433 -0.017713 -0.012160 \n",
"CO_MUNICIPIO_NASCIMENTO 0.864791 -0.030711 -0.000046 \n",
"CO_UF_NASCIMENTO 0.864919 -0.030259 0.000243 \n",
"TP_ST_CONCLUSAO 0.025822 -0.253403 -0.099077 \n",
"TP_ANO_CONCLUIU -0.032538 0.681435 0.373637 \n",
"TP_ESCOLA 0.041406 -0.296328 -0.153619 \n",
"TP_ENSINO 0.018145 0.516253 0.295596 \n",
"IN_TREINEIRO -0.034944 -0.295091 -0.117932 \n",
"CO_ESCOLA 0.983393 -0.019091 0.003213 \n",
"CO_MUNICIPIO_ESC 0.983417 -0.019710 0.002774 \n",
"CO_UF_ESC 0.983552 -0.019013 0.002854 \n",
"TP_DEPENDENCIA_ADM_ESC 0.079229 -0.082980 -0.036364 \n",
"TP_LOCALIZACAO_ESC -0.054736 0.009653 -0.013583 \n",
"TP_SIT_FUNC_ESC 0.024666 0.007082 -0.006323 \n",
"IN_BAIXA_VISAO 0.001360 0.027907 0.023243 \n",
"IN_CEGUEIRA NaN NaN NaN \n",
"IN_SURDEZ -0.010716 0.006520 0.025740 \n",
"IN_DEFICIENCIA_AUDITIVA 0.013035 0.011380 -0.006761 \n",
"IN_SURDO_CEGUEIRA NaN NaN NaN \n",
"IN_DEFICIENCIA_FISICA -0.001914 0.036361 0.043869 \n",
"IN_DEFICIENCIA_MENTAL 0.000934 0.000696 -0.003903 \n",
"IN_DEFICIT_ATENCAO 0.011867 -0.006294 -0.009564 \n",
"IN_DISLEXIA 0.003689 0.000492 -0.002760 \n",
"... ... ... ... \n",
"TP_PRESENCA_CN -0.035438 -0.245190 -0.153870 \n",
"TP_PRESENCA_CH -0.035438 -0.245190 -0.153870 \n",
"TP_PRESENCA_LC -0.034287 -0.241092 -0.150748 \n",
"TP_PRESENCA_MT -0.034287 -0.241092 -0.150748 \n",
"NU_NOTA_CN 0.084534 -0.056171 -0.049384 \n",
"NU_NOTA_CH 0.122825 -0.001611 -0.013475 \n",
"NU_NOTA_LC 0.128479 -0.024979 -0.024306 \n",
"NU_NOTA_MT 0.107493 -0.061485 -0.035393 \n",
"TP_LINGUA -0.096473 0.082065 0.054704 \n",
"TP_STATUS_REDACAO -0.016955 0.055675 0.035152 \n",
"NU_NOTA_COMP1 0.069195 -0.102243 -0.052769 \n",
"NU_NOTA_COMP2 0.047746 -0.114181 -0.067324 \n",
"NU_NOTA_COMP3 0.050400 -0.104293 -0.060856 \n",
"NU_NOTA_COMP4 0.061881 -0.110452 -0.064127 \n",
"NU_NOTA_COMP5 0.043565 -0.086709 -0.040135 \n",
"NU_NOTA_REDACAO 0.060629 -0.116125 -0.063570 \n",
"Q005 -0.117288 -0.097169 -0.104883 \n",
"Q029 -0.073029 -0.035952 -0.079450 \n",
"Q030 -0.078885 0.418387 0.348302 \n",
"Q031 -0.025491 0.018634 -0.016960 \n",
"Q032 0.003968 -0.044791 -0.017455 \n",
"Q033 -0.030345 0.025077 -0.009670 \n",
"Q034 -0.050096 -0.030681 -0.016354 \n",
"Q035 -0.049292 0.012739 -0.002580 \n",
"Q036 -0.040688 0.021949 0.025840 \n",
"Q037 -0.013647 -0.003569 0.002294 \n",
"Q038 -0.032467 -0.035306 -0.014725 \n",
"Q039 -0.094113 -0.069973 -0.066346 \n",
"Q040 -0.076838 -0.010988 -0.022736 \n",
"Q041 -0.033149 0.160526 0.108771 \n",
"\n",
" TP_COR_RACA TP_NACIONALIDADE \\\n",
"Unnamed: 0 0.005707 -0.006217 \n",
"NU_ANO NaN NaN \n",
"CO_MUNICIPIO_RESIDENCIA -0.236178 0.009710 \n",
"CO_UF_RESIDENCIA -0.234786 0.009433 \n",
"NU_IDADE 0.009675 -0.017713 \n",
"TP_ESTADO_CIVIL 0.004950 -0.012160 \n",
"TP_COR_RACA 1.000000 0.015761 \n",
"TP_NACIONALIDADE 0.015761 1.000000 \n",
"CO_MUNICIPIO_NASCIMENTO -0.253524 NaN \n",
"CO_UF_NASCIMENTO -0.252162 NaN \n",
"TP_ST_CONCLUSAO 0.000738 -0.000054 \n",
"TP_ANO_CONCLUIU 0.003942 -0.026154 \n",
"TP_ESCOLA -0.041713 0.024070 \n",
"TP_ENSINO 0.040504 0.020522 \n",
"IN_TREINEIRO 0.009676 -0.015179 \n",
"CO_ESCOLA -0.256299 0.011570 \n",
"CO_MUNICIPIO_ESC -0.257769 0.012304 \n",
"CO_UF_ESC -0.255696 0.011734 \n",
"TP_DEPENDENCIA_ADM_ESC -0.172229 -0.012981 \n",
"TP_LOCALIZACAO_ESC 0.059965 -0.017525 \n",
"TP_SIT_FUNC_ESC -0.024081 -0.008031 \n",
"IN_BAIXA_VISAO -0.014715 0.009354 \n",
"IN_CEGUEIRA NaN NaN \n",
"IN_SURDEZ 0.007852 0.011142 \n",
"IN_DEFICIENCIA_AUDITIVA -0.004163 -0.004264 \n",
"IN_SURDO_CEGUEIRA NaN NaN \n",
"IN_DEFICIENCIA_FISICA -0.002431 0.003217 \n",
"IN_DEFICIENCIA_MENTAL 0.009759 -0.002279 \n",
"IN_DEFICIT_ATENCAO -0.012727 0.003336 \n",
"IN_DISLEXIA -0.010046 -0.001611 \n",
"... ... ... \n",
"TP_PRESENCA_CN -0.024471 -0.020359 \n",
"TP_PRESENCA_CH -0.024471 -0.020359 \n",
"TP_PRESENCA_LC -0.021861 -0.024097 \n",
"TP_PRESENCA_MT -0.021861 -0.024097 \n",
"NU_NOTA_CN -0.149429 -0.039746 \n",
"NU_NOTA_CH -0.161831 -0.049801 \n",
"NU_NOTA_LC -0.168624 -0.049631 \n",
"NU_NOTA_MT -0.157364 -0.034965 \n",
"TP_LINGUA 0.116860 0.015266 \n",
"TP_STATUS_REDACAO 0.020586 0.005211 \n",
"NU_NOTA_COMP1 -0.097606 -0.031126 \n",
"NU_NOTA_COMP2 -0.090291 -0.030800 \n",
"NU_NOTA_COMP3 -0.096344 -0.027184 \n",
"NU_NOTA_COMP4 -0.102936 -0.031422 \n",
"NU_NOTA_COMP5 -0.091136 -0.025561 \n",
"NU_NOTA_REDACAO -0.107840 -0.032759 \n",
"Q005 0.096772 0.018954 \n",
"Q029 0.058776 0.018761 \n",
"Q030 0.059865 -0.007630 \n",
"Q031 0.003155 0.000202 \n",
"Q032 -0.010398 0.013515 \n",
"Q033 0.004446 0.001575 \n",
"Q034 0.031514 -0.003419 \n",
"Q035 0.026052 -0.018290 \n",
"Q036 0.055185 -0.005285 \n",
"Q037 0.086642 0.032588 \n",
"Q038 0.069298 0.024112 \n",
"Q039 0.046830 0.011327 \n",
"Q040 0.053556 0.014847 \n",
"Q041 0.020966 0.008132 \n",
"\n",
" CO_MUNICIPIO_NASCIMENTO CO_UF_NASCIMENTO ... \\\n",
"Unnamed: 0 -0.004527 -0.004615 ... \n",
"NU_ANO NaN NaN ... \n",
"CO_MUNICIPIO_RESIDENCIA 0.865294 0.865216 ... \n",
"CO_UF_RESIDENCIA 0.864791 0.864919 ... \n",
"NU_IDADE -0.030711 -0.030259 ... \n",
"TP_ESTADO_CIVIL -0.000046 0.000243 ... \n",
"TP_COR_RACA -0.253524 -0.252162 ... \n",
"TP_NACIONALIDADE NaN NaN ... \n",
"CO_MUNICIPIO_NASCIMENTO 1.000000 0.999860 ... \n",
"CO_UF_NASCIMENTO 0.999860 1.000000 ... \n",
"TP_ST_CONCLUSAO 0.036523 0.036919 ... \n",
"TP_ANO_CONCLUIU -0.052958 -0.052839 ... \n",
"TP_ESCOLA 0.048779 0.048580 ... \n",
"TP_ENSINO -0.002364 -0.002106 ... \n",
"IN_TREINEIRO -0.018218 -0.018005 ... \n",
"CO_ESCOLA 0.886402 0.886396 ... \n",
"CO_MUNICIPIO_ESC 0.886961 0.886802 ... \n",
"CO_UF_ESC 0.886473 0.886542 ... \n",
"TP_DEPENDENCIA_ADM_ESC 0.079579 0.078843 ... \n",
"TP_LOCALIZACAO_ESC -0.056358 -0.055630 ... \n",
"TP_SIT_FUNC_ESC 0.026327 0.026616 ... \n",
"IN_BAIXA_VISAO 0.018112 0.018324 ... \n",
"IN_CEGUEIRA NaN NaN ... \n",
"IN_SURDEZ -0.003174 -0.003032 ... \n",
"IN_DEFICIENCIA_AUDITIVA 0.006800 0.006825 ... \n",
"IN_SURDO_CEGUEIRA NaN NaN ... \n",
"IN_DEFICIENCIA_FISICA 0.001364 0.001534 ... \n",
"IN_DEFICIENCIA_MENTAL 0.001272 0.001367 ... \n",
"IN_DEFICIT_ATENCAO 0.015845 0.015606 ... \n",
"IN_DISLEXIA 0.004414 0.004127 ... \n",
"... ... ... ... \n",
"TP_PRESENCA_CN -0.023048 -0.023120 ... \n",
"TP_PRESENCA_CH -0.023048 -0.023120 ... \n",
"TP_PRESENCA_LC -0.022827 -0.022934 ... \n",
"TP_PRESENCA_MT -0.022827 -0.022934 ... \n",
"NU_NOTA_CN 0.092466 0.091436 ... \n",
"NU_NOTA_CH 0.131918 0.130598 ... \n",
"NU_NOTA_LC 0.132173 0.130673 ... \n",
"NU_NOTA_MT 0.113416 0.112236 ... \n",
"TP_LINGUA -0.108556 -0.106415 ... \n",
"TP_STATUS_REDACAO -0.023882 -0.023695 ... \n",
"NU_NOTA_COMP1 0.082979 0.082136 ... \n",
"NU_NOTA_COMP2 0.063531 0.062861 ... \n",
"NU_NOTA_COMP3 0.067943 0.067181 ... \n",
"NU_NOTA_COMP4 0.074401 0.073592 ... \n",
"NU_NOTA_COMP5 0.045327 0.044690 ... \n",
"NU_NOTA_REDACAO 0.073846 0.073013 ... \n",
"Q005 -0.107950 -0.107347 ... \n",
"Q029 -0.082560 -0.082275 ... \n",
"Q030 -0.110083 -0.109386 ... \n",
"Q031 -0.024254 -0.023908 ... \n",
"Q032 -0.001793 -0.002089 ... \n",
"Q033 -0.043358 -0.043492 ... \n",
"Q034 -0.051102 -0.051094 ... \n",
"Q035 -0.057239 -0.056401 ... \n",
"Q036 -0.046998 -0.047069 ... \n",
"Q037 -0.024174 -0.024201 ... \n",
"Q038 -0.038666 -0.038305 ... \n",
"Q039 -0.097273 -0.096666 ... \n",
"Q040 -0.081490 -0.080963 ... \n",
"Q041 -0.042237 -0.042134 ... \n",
"\n",
" Q032 Q033 Q034 Q035 Q036 \\\n",
"Unnamed: 0 0.001520 0.018074 0.001693 -0.008141 0.002724 \n",
"NU_ANO NaN NaN NaN NaN NaN \n",
"CO_MUNICIPIO_RESIDENCIA 0.004115 -0.030114 -0.050304 -0.050138 -0.040668 \n",
"CO_UF_RESIDENCIA 0.003968 -0.030345 -0.050096 -0.049292 -0.040688 \n",
"NU_IDADE -0.044791 0.025077 -0.030681 0.012739 0.021949 \n",
"TP_ESTADO_CIVIL -0.017455 -0.009670 -0.016354 -0.002580 0.025840 \n",
"TP_COR_RACA -0.010398 0.004446 0.031514 0.026052 0.055185 \n",
"TP_NACIONALIDADE 0.013515 0.001575 -0.003419 -0.018290 -0.005285 \n",
"CO_MUNICIPIO_NASCIMENTO -0.001793 -0.043358 -0.051102 -0.057239 -0.046998 \n",
"CO_UF_NASCIMENTO -0.002089 -0.043492 -0.051094 -0.056401 -0.047069 \n",
"TP_ST_CONCLUSAO -0.010453 -0.113770 0.031020 -0.092979 -0.048354 \n",
"TP_ANO_CONCLUIU -0.004940 0.122058 -0.035955 0.039764 0.049243 \n",
"TP_ESCOLA -0.014161 -0.133879 0.020858 0.011888 -0.010416 \n",
"TP_ENSINO -0.045370 0.057219 0.003773 -0.033346 -0.007937 \n",
"IN_TREINEIRO -0.000943 -0.071335 0.055265 -0.061032 -0.069476 \n",
"CO_ESCOLA 0.065956 0.038252 -0.027267 -0.052980 -0.059440 \n",
"CO_MUNICIPIO_ESC 0.067116 0.038963 -0.026767 -0.053391 -0.059404 \n",
"CO_UF_ESC 0.065871 0.038237 -0.026826 -0.052553 -0.059335 \n",
"TP_DEPENDENCIA_ADM_ESC -0.065096 -0.127836 -0.039220 0.033621 -0.096330 \n",
"TP_LOCALIZACAO_ESC -0.037945 -0.064740 -0.007511 -0.023955 0.005273 \n",
"TP_SIT_FUNC_ESC 0.013276 0.007205 0.001305 0.008600 -0.030003 \n",
"IN_BAIXA_VISAO -0.047254 -0.020079 -0.006691 -0.006066 -0.020333 \n",
"IN_CEGUEIRA NaN NaN NaN NaN NaN \n",
"IN_SURDEZ 0.002886 -0.012876 -0.009235 -0.010557 0.007342 \n",
"IN_DEFICIENCIA_AUDITIVA -0.000738 0.000574 -0.019336 -0.017714 -0.004506 \n",
"IN_SURDO_CEGUEIRA NaN NaN NaN NaN NaN \n",
"IN_DEFICIENCIA_FISICA 0.009304 -0.001236 0.006152 0.013789 0.008888 \n",
"IN_DEFICIENCIA_MENTAL 0.005736 0.008006 0.004645 0.004487 -0.002408 \n",
"IN_DEFICIT_ATENCAO -0.000522 0.011324 -0.003581 -0.002244 -0.021358 \n",
"IN_DISLEXIA NaN NaN -0.005983 0.003173 0.008268 \n",
"... ... ... ... ... ... \n",
"TP_PRESENCA_CN -0.021150 -0.034084 0.012139 0.035485 -0.038984 \n",
"TP_PRESENCA_CH -0.021150 -0.034084 0.012139 0.035485 -0.038984 \n",
"TP_PRESENCA_LC -0.024603 -0.036928 0.015406 0.036456 -0.037794 \n",
"TP_PRESENCA_MT -0.024603 -0.036928 0.015406 0.036456 -0.037794 \n",
"NU_NOTA_CN -0.094999 -0.100490 -0.084112 0.031346 -0.129898 \n",
"NU_NOTA_CH -0.068755 -0.059146 -0.083110 0.041605 -0.134443 \n",
"NU_NOTA_LC -0.042855 -0.059173 -0.083234 0.033435 -0.125487 \n",
"NU_NOTA_MT -0.090325 -0.114083 -0.104780 0.031685 -0.145501 \n",
"TP_LINGUA 0.009185 0.038196 0.036835 0.025548 0.058586 \n",
"TP_STATUS_REDACAO -0.040251 -0.011527 -0.017759 -0.009929 0.007216 \n",
"NU_NOTA_COMP1 0.018366 -0.009741 -0.027431 0.025580 -0.089333 \n",
"NU_NOTA_COMP2 0.004089 -0.008846 -0.033403 0.034569 -0.091875 \n",
"NU_NOTA_COMP3 0.001432 -0.019752 -0.031051 0.041211 -0.100383 \n",
"NU_NOTA_COMP4 -0.005205 -0.019351 -0.025741 0.037275 -0.088738 \n",
"NU_NOTA_COMP5 -0.003048 -0.026208 -0.040076 0.052849 -0.093167 \n",
"NU_NOTA_REDACAO 0.002906 -0.019940 -0.036293 0.044519 -0.104972 \n",
"Q005 0.008208 -0.035427 0.027044 0.017361 0.002087 \n",
"Q029 0.225648 0.320981 0.188397 0.148412 0.137702 \n",
"Q030 0.129877 0.228742 0.082049 0.085898 0.105733 \n",
"Q031 0.524584 0.343212 0.196486 0.168763 0.138909 \n",
"Q032 1.000000 0.375848 0.279328 0.189872 0.168574 \n",
"Q033 0.375848 1.000000 0.204584 0.158553 0.233115 \n",
"Q034 0.279328 0.204584 1.000000 0.294599 0.176742 \n",
"Q035 0.189872 0.158553 0.294599 1.000000 0.112920 \n",
"Q036 0.168574 0.233115 0.176742 0.112920 1.000000 \n",
"Q037 0.220839 0.225791 0.245757 0.202230 0.387722 \n",
"Q038 0.159887 0.223508 0.215767 0.142610 0.378421 \n",
"Q039 0.144264 0.206979 0.189252 0.225724 0.270343 \n",
"Q040 0.215292 0.176028 0.243190 0.179292 0.177025 \n",
"Q041 0.233832 0.205239 0.154743 0.113574 0.214736 \n",
"\n",
" Q037 Q038 Q039 Q040 Q041 \n",
"Unnamed: 0 -0.004914 0.003906 0.001002 -0.010967 -0.029937 \n",
"NU_ANO NaN NaN NaN NaN NaN \n",
"CO_MUNICIPIO_RESIDENCIA -0.013479 -0.032710 -0.094862 -0.077456 -0.033205 \n",
"CO_UF_RESIDENCIA -0.013647 -0.032467 -0.094113 -0.076838 -0.033149 \n",
"NU_IDADE -0.003569 -0.035306 -0.069973 -0.010988 0.160526 \n",
"TP_ESTADO_CIVIL 0.002294 -0.014725 -0.066346 -0.022736 0.108771 \n",
"TP_COR_RACA 0.086642 0.069298 0.046830 0.053556 0.020966 \n",
"TP_NACIONALIDADE 0.032588 0.024112 0.011327 0.014847 0.008132 \n",
"CO_MUNICIPIO_NASCIMENTO -0.024174 -0.038666 -0.097273 -0.081490 -0.042237 \n",
"CO_UF_NASCIMENTO -0.024201 -0.038305 -0.096666 -0.080963 -0.042134 \n",
"TP_ST_CONCLUSAO 0.001767 0.080592 0.019877 0.051951 0.028234 \n",
"TP_ANO_CONCLUIU -0.007379 -0.072813 -0.048672 -0.052564 0.084309 \n",
"TP_ESCOLA -0.019991 0.035877 0.018430 0.036985 -0.087935 \n",
"TP_ENSINO 0.024624 0.041203 -0.029358 0.032923 0.126503 \n",
"IN_TREINEIRO -0.020651 0.018855 0.040348 0.005270 -0.046232 \n",
"CO_ESCOLA 0.012459 -0.040819 -0.122494 -0.078344 -0.066173 \n",
"CO_MUNICIPIO_ESC 0.012914 -0.040648 -0.123456 -0.078338 -0.065058 \n",
"CO_UF_ESC 0.012547 -0.040294 -0.122504 -0.077712 -0.064864 \n",
"TP_DEPENDENCIA_ADM_ESC -0.242419 -0.145333 -0.005773 -0.059893 -0.104268 \n",
"TP_LOCALIZACAO_ESC -0.017336 0.005955 0.010145 -0.003063 -0.023198 \n",
"TP_SIT_FUNC_ESC 0.007576 -0.030931 -0.027551 -0.053643 -0.047072 \n",
"IN_BAIXA_VISAO -0.030724 -0.028589 -0.013989 -0.009669 0.014038 \n",
"IN_CEGUEIRA NaN NaN NaN NaN NaN \n",
"IN_SURDEZ -0.007300 -0.003668 0.001039 0.002551 0.012383 \n",
"IN_DEFICIENCIA_AUDITIVA -0.011326 -0.003958 -0.002900 -0.005720 0.003471 \n",
"IN_SURDO_CEGUEIRA NaN NaN NaN NaN NaN \n",
"IN_DEFICIENCIA_FISICA 0.002899 -0.001605 -0.006527 0.007574 0.019857 \n",
"IN_DEFICIENCIA_MENTAL 0.005441 -0.008750 -0.007067 0.005699 0.014038 \n",
"IN_DEFICIT_ATENCAO -0.059131 -0.010402 -0.017337 -0.029558 NaN \n",
"IN_DISLEXIA -0.017487 -0.003661 -0.002515 -0.010417 NaN \n",
"... ... ... ... ... ... \n",
"TP_PRESENCA_CN -0.028485 -0.016003 0.029835 -0.013657 -0.054062 \n",
"TP_PRESENCA_CH -0.028485 -0.016003 0.029835 -0.013657 -0.054062 \n",
"TP_PRESENCA_LC -0.026968 -0.019277 0.023827 -0.016834 -0.050498 \n",
"TP_PRESENCA_MT -0.026968 -0.019277 0.023827 -0.016834 -0.050498 \n",
"NU_NOTA_CN -0.273410 -0.202920 -0.000128 -0.113885 -0.119035 \n",
"NU_NOTA_CH -0.235883 -0.221562 -0.039593 -0.133741 -0.118760 \n",
"NU_NOTA_LC -0.212129 -0.221847 -0.052357 -0.128051 -0.118779 \n",
"NU_NOTA_MT -0.265249 -0.202259 -0.019360 -0.119997 -0.131795 \n",
"TP_LINGUA 0.106602 0.092053 0.019176 0.060805 0.053789 \n",
"TP_STATUS_REDACAO 0.011440 0.017835 0.010357 0.003761 0.009012 \n",
"NU_NOTA_COMP1 -0.136336 -0.141339 -0.032053 -0.081407 -0.088096 \n",
"NU_NOTA_COMP2 -0.173082 -0.157421 -0.024866 -0.095383 -0.082863 \n",
"NU_NOTA_COMP3 -0.177818 -0.164138 -0.023113 -0.099993 -0.069967 \n",
"NU_NOTA_COMP4 -0.159789 -0.153423 -0.022182 -0.090415 -0.082042 \n",
"NU_NOTA_COMP5 -0.175356 -0.147931 -0.006653 -0.084367 -0.057855 \n",
"NU_NOTA_REDACAO -0.187413 -0.172875 -0.023452 -0.102026 -0.087124 \n",
"Q005 0.041987 0.046494 0.042499 0.053892 0.034236 \n",
"Q029 0.172342 0.169494 0.183869 0.181488 0.164861 \n",
"Q030 0.093032 0.130559 0.094260 0.146498 0.254543 \n",
"Q031 0.118516 0.101342 0.104165 0.157666 0.133700 \n",
"Q032 0.220839 0.159887 0.144264 0.215292 0.233832 \n",
"Q033 0.225791 0.223508 0.206979 0.176028 0.205239 \n",
"Q034 0.245757 0.215767 0.189252 0.243190 0.154743 \n",
"Q035 0.202230 0.142610 0.225724 0.179292 0.113574 \n",
"Q036 0.387722 0.378421 0.270343 0.177025 0.214736 \n",
"Q037 1.000000 0.496678 0.254418 0.270380 0.187921 \n",
"Q038 0.496678 1.000000 0.374424 0.259947 0.219529 \n",
"Q039 0.254418 0.374424 1.000000 0.305357 0.262031 \n",
"Q040 0.270380 0.259947 0.305357 1.000000 0.306438 \n",
"Q041 0.187921 0.219529 0.262031 0.306438 1.000000 \n",
"\n",
"[107 rows x 107 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.corr()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Criação de uma função para pré-processamento dos dados"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"def preprocess(data):\n",
" new_df = pd.DataFrame()\n",
" new_df['NU_INSCRICAO'] = data['NU_INSCRICAO']\n",
" new_df['NOTA_FINAL'] = (data['NU_NOTA_CN']* 2 + data['NU_NOTA_CH'] + data['NU_NOTA_LC']* 1.5 + data['NU_NOTA_MT'] * 3 + data['NU_NOTA_REDACAO'] * 3)/10.5\n",
" new_df = new_df.dropna(thresh=2)\n",
" return new_df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Criação da variável que recebe o retorno da função"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"NU_INSCRICAO 0\n",
"NOTA_FINAL 0\n",
"dtype: int64"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notas = preprocess(df)\n",
"notas.isnull().sum()"
]
},
{
"cell_type": "code",
"execution_count": 12,
"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>NU_INSCRICAO</th>\n",
" <th>NOTA_FINAL</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>ed50e8aaa58e7a806c337585efee9ca41f1eb1ad</td>\n",
" <td>476.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2c3acac4b33ec2b195d77e7c04a2d75727fad723</td>\n",
" <td>524.857143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>a37c99ec251d4f6e8ddbeabadf1c87fdbfddc4d1</td>\n",
" <td>479.280952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>63b4e128e9ffe8ab27f5d093db1976ef4f353e0a</td>\n",
" <td>517.976190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2eb189d4912f64b19d1967e8e84b6141aba18770</td>\n",
" <td>603.990476</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" NU_INSCRICAO NOTA_FINAL\n",
"0 ed50e8aaa58e7a806c337585efee9ca41f1eb1ad 476.000000\n",
"1 2c3acac4b33ec2b195d77e7c04a2d75727fad723 524.857143\n",
"5 a37c99ec251d4f6e8ddbeabadf1c87fdbfddc4d1 479.280952\n",
"6 63b4e128e9ffe8ab27f5d093db1976ef4f353e0a 517.976190\n",
"7 2eb189d4912f64b19d1967e8e84b6141aba18770 603.990476"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notas.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Criação e ajustes finais do arquivo de resposta"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"notas = notas.sort_values('NOTA_FINAL',ascending=False)\n",
"notas.head(20).to_csv(\"answer.csv\")"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.15"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
@regispires
Copy link

  • ao gerar o csv, é só não gravar o índice: notas.head(20).to_csv("answer.csv", index=False)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment