Gráficos fofos em Python.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: cutecharts in /Users/kizzyterra/Workspace/machine-learning/venv-ml/lib/python3.7/site-packages (1.2.0)\n",
      "Requirement already satisfied: jinja2 in /Users/kizzyterra/Workspace/machine-learning/venv-ml/lib/python3.7/site-packages (from cutecharts) (2.10.3)\n",
      "Requirement already satisfied: MarkupSafe>=0.23 in /Users/kizzyterra/Workspace/machine-learning/venv-ml/lib/python3.7/site-packages (from jinja2->cutecharts) (1.1.1)\n"
     ]
    }
   ],
   "source": [
    "!pip install cutecharts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import cutecharts.charts as ctc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "microdados_enem_rj = pd.read_csv('../dados/microdados_enem_ufs_2019/microdados_enem_RJ_2019.csv', index_col=0)"
   ]
  },
  {
   "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>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>TP_COR_RACA</th>\n",
       "      <th>...</th>\n",
       "      <th>Q016</th>\n",
       "      <th>Q017</th>\n",
       "      <th>Q018</th>\n",
       "      <th>Q019</th>\n",
       "      <th>Q020</th>\n",
       "      <th>Q021</th>\n",
       "      <th>Q022</th>\n",
       "      <th>Q023</th>\n",
       "      <th>Q024</th>\n",
       "      <th>Q025</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10600</th>\n",
       "      <td>190001015227</td>\n",
       "      <td>2019</td>\n",
       "      <td>3302056</td>\n",
       "      <td>Italva</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>32</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21074</th>\n",
       "      <td>190001025702</td>\n",
       "      <td>2019</td>\n",
       "      <td>3305109</td>\n",
       "      <td>São João de Meriti</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>32</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22657</th>\n",
       "      <td>190001027285</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>26</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30365</th>\n",
       "      <td>190001034993</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>19</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</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>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60937</th>\n",
       "      <td>190001065566</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>22</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>C</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 136 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       NU_INSCRICAO  NU_ANO  CO_MUNICIPIO_RESIDENCIA NO_MUNICIPIO_RESIDENCIA  \\\n",
       "10600  190001015227    2019                  3302056                  Italva   \n",
       "21074  190001025702    2019                  3305109      São João de Meriti   \n",
       "22657  190001027285    2019                  3304557          Rio de Janeiro   \n",
       "30365  190001034993    2019                  3304557          Rio de Janeiro   \n",
       "60937  190001065566    2019                  3304557          Rio de Janeiro   \n",
       "\n",
       "       CO_UF_RESIDENCIA SG_UF_RESIDENCIA  NU_IDADE TP_SEXO  TP_ESTADO_CIVIL  \\\n",
       "10600                33               RJ        32       F                1   \n",
       "21074                33               RJ        32       M                1   \n",
       "22657                33               RJ        26       M                1   \n",
       "30365                33               RJ        19       F                1   \n",
       "60937                33               RJ        22       F                1   \n",
       "\n",
       "       TP_COR_RACA  ...  Q016  Q017 Q018  Q019 Q020  Q021  Q022  Q023  Q024  \\\n",
       "10600            3  ...     A     A    A     B    B     A     B     A     A   \n",
       "21074            3  ...     A     A    A     B    A     A     B     A     A   \n",
       "22657            3  ...     B     A    A     B    A     A     B     A     B   \n",
       "30365            3  ...     A     A    A     A    A     A     B     A     A   \n",
       "60937            3  ...     A     A    A     B    B     A     C     A     A   \n",
       "\n",
       "       Q025  \n",
       "10600     A  \n",
       "21074     A  \n",
       "22657     B  \n",
       "30365     B  \n",
       "60937     A  \n",
       "\n",
       "[5 rows x 136 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "microdados_enem_rj.reset_index(inplace=True,drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>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>TP_COR_RACA</th>\n",
       "      <th>...</th>\n",
       "      <th>Q016</th>\n",
       "      <th>Q017</th>\n",
       "      <th>Q018</th>\n",
       "      <th>Q019</th>\n",
       "      <th>Q020</th>\n",
       "      <th>Q021</th>\n",
       "      <th>Q022</th>\n",
       "      <th>Q023</th>\n",
       "      <th>Q024</th>\n",
       "      <th>Q025</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>190001015227</td>\n",
       "      <td>2019</td>\n",
       "      <td>3302056</td>\n",
       "      <td>Italva</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>32</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>190001025702</td>\n",
       "      <td>2019</td>\n",
       "      <td>3305109</td>\n",
       "      <td>São João de Meriti</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>32</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>190001027285</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>26</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>190001034993</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>19</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</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>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>190001065566</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>22</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>C</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</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>338705</th>\n",
       "      <td>190006118895</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>18</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>D</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>E</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338706</th>\n",
       "      <td>190006118896</td>\n",
       "      <td>2019</td>\n",
       "      <td>3305109</td>\n",
       "      <td>São João de Meriti</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>52</td>\n",
       "      <td>F</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338707</th>\n",
       "      <td>190006118897</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304557</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>23</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>D</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>E</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338708</th>\n",
       "      <td>190006118898</td>\n",
       "      <td>2019</td>\n",
       "      <td>3300308</td>\n",
       "      <td>Barra do Piraí</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>32</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>B</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338709</th>\n",
       "      <td>190006118899</td>\n",
       "      <td>2019</td>\n",
       "      <td>3304904</td>\n",
       "      <td>São Gonçalo</td>\n",
       "      <td>33</td>\n",
       "      <td>RJ</td>\n",
       "      <td>41</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>A</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",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>338710 rows × 136 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        NU_INSCRICAO  NU_ANO  CO_MUNICIPIO_RESIDENCIA NO_MUNICIPIO_RESIDENCIA  \\\n",
       "0       190001015227    2019                  3302056                  Italva   \n",
       "1       190001025702    2019                  3305109      São João de Meriti   \n",
       "2       190001027285    2019                  3304557          Rio de Janeiro   \n",
       "3       190001034993    2019                  3304557          Rio de Janeiro   \n",
       "4       190001065566    2019                  3304557          Rio de Janeiro   \n",
       "...              ...     ...                      ...                     ...   \n",
       "338705  190006118895    2019                  3304557          Rio de Janeiro   \n",
       "338706  190006118896    2019                  3305109      São João de Meriti   \n",
       "338707  190006118897    2019                  3304557          Rio de Janeiro   \n",
       "338708  190006118898    2019                  3300308          Barra do Piraí   \n",
       "338709  190006118899    2019                  3304904             São Gonçalo   \n",
       "\n",
       "        CO_UF_RESIDENCIA SG_UF_RESIDENCIA  NU_IDADE TP_SEXO  TP_ESTADO_CIVIL  \\\n",
       "0                     33               RJ        32       F                1   \n",
       "1                     33               RJ        32       M                1   \n",
       "2                     33               RJ        26       M                1   \n",
       "3                     33               RJ        19       F                1   \n",
       "4                     33               RJ        22       F                1   \n",
       "...                  ...              ...       ...     ...              ...   \n",
       "338705                33               RJ        18       F                0   \n",
       "338706                33               RJ        52       F                2   \n",
       "338707                33               RJ        23       F                1   \n",
       "338708                33               RJ        32       F                1   \n",
       "338709                33               RJ        41       F                0   \n",
       "\n",
       "        TP_COR_RACA  ...  Q016  Q017 Q018  Q019 Q020  Q021  Q022  Q023  Q024  \\\n",
       "0                 3  ...     A     A    A     B    B     A     B     A     A   \n",
       "1                 3  ...     A     A    A     B    A     A     B     A     A   \n",
       "2                 3  ...     B     A    A     B    A     A     B     A     B   \n",
       "3                 3  ...     A     A    A     A    A     A     B     A     A   \n",
       "4                 3  ...     A     A    A     B    B     A     C     A     A   \n",
       "...             ...  ...   ...   ...  ...   ...  ...   ...   ...   ...   ...   \n",
       "338705            3  ...     B     A    B     D    A     B     E     B     A   \n",
       "338706            3  ...     A     A    A     B    A     A     B     B     A   \n",
       "338707            1  ...     B     A    A     D    B     B     E     A     B   \n",
       "338708            2  ...     A     A    A     B    B     A     B     A     A   \n",
       "338709            3  ...     B     A    A     B    A     A     C     A     B   \n",
       "\n",
       "        Q025  \n",
       "0          A  \n",
       "1          A  \n",
       "2          B  \n",
       "3          B  \n",
       "4          A  \n",
       "...      ...  \n",
       "338705     B  \n",
       "338706     A  \n",
       "338707     B  \n",
       "338708     A  \n",
       "338709     B  \n",
       "\n",
       "[338710 rows x 136 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['RJ'], dtype=object)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj.SG_UF_RESIDENCIA.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['NU_INSCRICAO', 'NU_ANO', 'CO_MUNICIPIO_RESIDENCIA',\n",
       "       'NO_MUNICIPIO_RESIDENCIA', 'CO_UF_RESIDENCIA', 'SG_UF_RESIDENCIA',\n",
       "       'NU_IDADE', 'TP_SEXO', 'TP_ESTADO_CIVIL', 'TP_COR_RACA',\n",
       "       'TP_NACIONALIDADE', 'CO_MUNICIPIO_NASCIMENTO',\n",
       "       'NO_MUNICIPIO_NASCIMENTO', 'CO_UF_NASCIMENTO', 'SG_UF_NASCIMENTO',\n",
       "       'TP_ST_CONCLUSAO', 'TP_ANO_CONCLUIU', 'TP_ESCOLA', 'TP_ENSINO',\n",
       "       'IN_TREINEIRO', 'CO_ESCOLA', 'CO_MUNICIPIO_ESC',\n",
       "       'NO_MUNICIPIO_ESC', 'CO_UF_ESC', 'SG_UF_ESC',\n",
       "       'TP_DEPENDENCIA_ADM_ESC', 'TP_LOCALIZACAO_ESC', 'TP_SIT_FUNC_ESC',\n",
       "       'IN_BAIXA_VISAO', 'IN_CEGUEIRA', 'IN_SURDEZ',\n",
       "       'IN_DEFICIENCIA_AUDITIVA', 'IN_SURDO_CEGUEIRA',\n",
       "       'IN_DEFICIENCIA_FISICA', 'IN_DEFICIENCIA_MENTAL',\n",
       "       'IN_DEFICIT_ATENCAO', 'IN_DISLEXIA', 'IN_DISCALCULIA',\n",
       "       'IN_AUTISMO', 'IN_VISAO_MONOCULAR', 'IN_OUTRA_DEF', 'IN_GESTANTE',\n",
       "       'IN_LACTANTE', 'IN_IDOSO', 'IN_ESTUDA_CLASSE_HOSPITALAR',\n",
       "       'IN_SEM_RECURSO', 'IN_BRAILLE', 'IN_AMPLIADA_24', 'IN_AMPLIADA_18',\n",
       "       'IN_LEDOR', 'IN_ACESSO', 'IN_TRANSCRICAO', 'IN_LIBRAS',\n",
       "       'IN_TEMPO_ADICIONAL', 'IN_LEITURA_LABIAL', 'IN_MESA_CADEIRA_RODAS',\n",
       "       'IN_MESA_CADEIRA_SEPARADA', 'IN_APOIO_PERNA', 'IN_GUIA_INTERPRETE',\n",
       "       'IN_COMPUTADOR', 'IN_CADEIRA_ESPECIAL', 'IN_CADEIRA_CANHOTO',\n",
       "       'IN_CADEIRA_ACOLCHOADA', 'IN_PROVA_DEITADO', 'IN_MOBILIARIO_OBESO',\n",
       "       'IN_LAMINA_OVERLAY', 'IN_PROTETOR_AURICULAR', 'IN_MEDIDOR_GLICOSE',\n",
       "       'IN_MAQUINA_BRAILE', 'IN_SOROBAN', 'IN_MARCA_PASSO', 'IN_SONDA',\n",
       "       'IN_MEDICAMENTOS', 'IN_SALA_INDIVIDUAL', 'IN_SALA_ESPECIAL',\n",
       "       'IN_SALA_ACOMPANHANTE', 'IN_MOBILIARIO_ESPECIFICO',\n",
       "       'IN_MATERIAL_ESPECIFICO', 'IN_NOME_SOCIAL', 'CO_MUNICIPIO_PROVA',\n",
       "       'NO_MUNICIPIO_PROVA', 'CO_UF_PROVA', 'SG_UF_PROVA',\n",
       "       'TP_PRESENCA_CN', 'TP_PRESENCA_CH', 'TP_PRESENCA_LC',\n",
       "       'TP_PRESENCA_MT', 'CO_PROVA_CN', 'CO_PROVA_CH', 'CO_PROVA_LC',\n",
       "       'CO_PROVA_MT', 'NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
       "       'NU_NOTA_MT', 'TX_RESPOSTAS_CN', 'TX_RESPOSTAS_CH',\n",
       "       'TX_RESPOSTAS_LC', 'TX_RESPOSTAS_MT', 'TP_LINGUA',\n",
       "       'TX_GABARITO_CN', 'TX_GABARITO_CH', 'TX_GABARITO_LC',\n",
       "       'TX_GABARITO_MT', 'TP_STATUS_REDACAO', 'NU_NOTA_COMP1',\n",
       "       'NU_NOTA_COMP2', 'NU_NOTA_COMP3', 'NU_NOTA_COMP4', 'NU_NOTA_COMP5',\n",
       "       'NU_NOTA_REDACAO', 'Q001', 'Q002', 'Q003', 'Q004', 'Q005', 'Q006',\n",
       "       'Q007', 'Q008', 'Q009', 'Q010', 'Q011', 'Q012', 'Q013', 'Q014',\n",
       "       'Q015', 'Q016', 'Q017', 'Q018', 'Q019', 'Q020', 'Q021', 'Q022',\n",
       "       'Q023', 'Q024', 'Q025'], dtype=object)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj.columns.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NU_NOTA_CN    491.892385\n",
       "NU_NOTA_CH    523.361916\n",
       "NU_NOTA_LC    535.900530\n",
       "NU_NOTA_MT    539.564877\n",
       "dtype: float64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj[['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT']].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'chartXkcd':'https://cdn.jsdelivr.net/npm/chart.xkcd@1.1/dist/chart.xkcd.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "<div id=\"6fee3606ed0f437b842f6893bd4b8c8c\" class=\"chart-container\" style=\"width: 500px\">\n",
       "        <svg id=\"chart_6fee3606ed0f437b842f6893bd4b8c8c\"></svg>\n",
       "    </div>\n",
       "    <script>\n",
       "        require(['chartXkcd'], function(chartXkcd) {\n",
       "            const svg_6fee3606ed0f437b842f6893bd4b8c8c = document.querySelector('#chart_6fee3606ed0f437b842f6893bd4b8c8c')\n",
       "            const chart_6fee3606ed0f437b842f6893bd4b8c8c = new chartXkcd.Bar(svg_6fee3606ed0f437b842f6893bd4b8c8c, {\"title\": \"M\\u00e9dias Notas RJ\", \"data\": {\"datasets\": [{\"label\": \"M\\u00e9dia\", \"data\": [491.8923845764329, 523.3619155427118, 535.9005299310816, 539.5648768597539, 597.706100378357]}], \"labels\": [\"C. Natureza\", \"C. Humanas\", \"Linguagens\", \"Matem\\u00e1tica\", \"Reda\\u00e7\\u00e3o\"]}, \"xLabel\": \"Provas\", \"yLabel\": \"M\\u00e9dia por Prova\", \"options\": {\"yTickCount\": 3, \"dataColors\": [\"#D9F1BB\", \"#F7B7A3\", \"#EA5F89\", \"#9B3192\", \"#FFFF77\"]}});\n",
       "        })\n",
       "    </script>\n"
      ],
      "text/plain": [
       "<cutecharts.render.engine.HTML at 0x139e3ff50>"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart = ctc.Bar('Médias Notas RJ',width='500px',height='400px')\n",
    "chart.set_options(\n",
    " labels=['C. Natureza', 'C. Humanas', 'Linguagens', 'Matemática', 'Redação'],\n",
    " x_label=\"Provas\",\n",
    " y_label=\"Média por Prova\" ,\n",
    " colors=['#D9F1BB','#F7B7A3','#EA5F89','#9B3192', '#FFFF77']\n",
    " )\n",
    "chart.add_series(\"Média\",list(microdados_enem_rj[['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT', 'NU_NOTA_REDACAO']].mean()))\n",
    "chart.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'chartXkcd':'https://cdn.jsdelivr.net/npm/chart.xkcd@1.1/dist/chart.xkcd.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "<div id=\"bf7b051deeac406281522541fe2a8080\" class=\"chart-container\" style=\"width: 600px\">\n",
       "        <svg id=\"chart_bf7b051deeac406281522541fe2a8080\"></svg>\n",
       "    </div>\n",
       "    <script>\n",
       "        require(['chartXkcd'], function(chartXkcd) {\n",
       "            const svg_bf7b051deeac406281522541fe2a8080 = document.querySelector('#chart_bf7b051deeac406281522541fe2a8080')\n",
       "            const chart_bf7b051deeac406281522541fe2a8080 = new chartXkcd.Radar(svg_bf7b051deeac406281522541fe2a8080, {\"title\": \"M\\u00e9dias Notas RJ\", \"data\": {\"datasets\": [{\"label\": \"M\\u00e9dia dos Munic\\u00edpios RJ\", \"data\": [491.8923845764329, 523.3619155427118, 535.9005299310816, 539.5648768597539, 597.706100378357]}, {\"label\": \"M\\u00e9dia do Munic\\u00edpio Angra dos Reis\", \"data\": [475.9840377513345, 508.694180704441, 527.015926493109, 520.8457529749692, 549.8698315467075]}], \"labels\": [\"C. Natureza\", \"C. Humanas\", \"Linguagens\", \"Matem\\u00e1tica\"]}, \"options\": {\"showLegend\": true, \"showLabel\": true, \"tickCount\": 3, \"legendPosition\": 2}});\n",
       "        })\n",
       "    </script>\n"
      ],
      "text/plain": [
       "<cutecharts.render.engine.HTML at 0x139e95910>"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "municipio = \"Angra dos Reis\"\n",
    "\n",
    "radar_chart = ctc.Radar('Médias Notas RJ',width='600px',height='600px')\n",
    "radar_chart.set_options(\n",
    " labels=['C. Natureza', 'C. Humanas', 'Linguagens', 'Matemática'],\n",
    " is_show_legend=True, #by default, it is true. You can turn it off.\n",
    " legend_pos='upRight'  #location of the legend\n",
    " )\n",
    "\n",
    "radar_chart.add_series(\"Média dos Municípios RJ\",list(microdados_enem_rj[['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT','NU_NOTA_REDACAO']].mean()))\n",
    "radar_chart.add_series(\"Média do Município {}\".format(municipio),\n",
    "                       list(microdados_enem_rj.groupby(['NO_MUNICIPIO_RESIDENCIA'])['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT','NU_NOTA_REDACAO'].mean().loc[municipio]))\n",
    "\n",
    "radar_chart.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NU_NOTA_CN    475.984038\n",
       "NU_NOTA_CH    508.694181\n",
       "NU_NOTA_LC    527.015926\n",
       "NU_NOTA_MT    520.845753\n",
       "Name: Angra dos Reis, dtype: float64"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj.groupby(['NO_MUNICIPIO_RESIDENCIA'])['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT'].mean().loc['Angra dos Reis']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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_NOTA_CN</th>\n",
       "      <th>NU_NOTA_CH</th>\n",
       "      <th>NU_NOTA_LC</th>\n",
       "      <th>NU_NOTA_MT</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NO_MUNICIPIO_RESIDENCIA</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Angra dos Reis</th>\n",
       "      <td>475.984038</td>\n",
       "      <td>508.694181</td>\n",
       "      <td>527.015926</td>\n",
       "      <td>520.845753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aperibé</th>\n",
       "      <td>493.393789</td>\n",
       "      <td>518.341379</td>\n",
       "      <td>528.701724</td>\n",
       "      <td>542.992547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Araruama</th>\n",
       "      <td>488.075321</td>\n",
       "      <td>514.994308</td>\n",
       "      <td>529.860574</td>\n",
       "      <td>532.785762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Areal</th>\n",
       "      <td>474.303145</td>\n",
       "      <td>503.188304</td>\n",
       "      <td>523.457895</td>\n",
       "      <td>515.313208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armação dos Búzios</th>\n",
       "      <td>490.474903</td>\n",
       "      <td>525.274910</td>\n",
       "      <td>535.007040</td>\n",
       "      <td>530.700000</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>Três Rios</th>\n",
       "      <td>482.053123</td>\n",
       "      <td>511.984375</td>\n",
       "      <td>527.105288</td>\n",
       "      <td>522.841703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Valença</th>\n",
       "      <td>495.254925</td>\n",
       "      <td>522.922297</td>\n",
       "      <td>534.024662</td>\n",
       "      <td>546.180657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Varre-Sai</th>\n",
       "      <td>492.420492</td>\n",
       "      <td>503.276692</td>\n",
       "      <td>512.384211</td>\n",
       "      <td>534.113934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vassouras</th>\n",
       "      <td>485.166593</td>\n",
       "      <td>513.554167</td>\n",
       "      <td>528.432917</td>\n",
       "      <td>525.596239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Volta Redonda</th>\n",
       "      <td>507.400156</td>\n",
       "      <td>535.504062</td>\n",
       "      <td>544.084667</td>\n",
       "      <td>569.327552</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         NU_NOTA_CN  NU_NOTA_CH  NU_NOTA_LC  NU_NOTA_MT\n",
       "NO_MUNICIPIO_RESIDENCIA                                                \n",
       "Angra dos Reis           475.984038  508.694181  527.015926  520.845753\n",
       "Aperibé                  493.393789  518.341379  528.701724  542.992547\n",
       "Araruama                 488.075321  514.994308  529.860574  532.785762\n",
       "Areal                    474.303145  503.188304  523.457895  515.313208\n",
       "Armação dos Búzios       490.474903  525.274910  535.007040  530.700000\n",
       "...                             ...         ...         ...         ...\n",
       "Três Rios                482.053123  511.984375  527.105288  522.841703\n",
       "Valença                  495.254925  522.922297  534.024662  546.180657\n",
       "Varre-Sai                492.420492  503.276692  512.384211  534.113934\n",
       "Vassouras                485.166593  513.554167  528.432917  525.596239\n",
       "Volta Redonda            507.400156  535.504062  544.084667  569.327552\n",
       "\n",
       "[92 rows x 4 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "microdados_enem_rj.groupby(['NO_MUNICIPIO_RESIDENCIA'])['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
    "       'NU_NOTA_MT'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}