Extraindo os discentes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "turmas = pd.read_csv(\"data/turmas-20172.csv\", sep=';')"
   ]
  },
  {
   "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>id_turma</th>\n",
       "      <th>codigo_turma</th>\n",
       "      <th>id_docente_interno</th>\n",
       "      <th>id_docente_externo</th>\n",
       "      <th>observacao</th>\n",
       "      <th>id_componente_curricular</th>\n",
       "      <th>nivel_ensino</th>\n",
       "      <th>campus_turma</th>\n",
       "      <th>local</th>\n",
       "      <th>ano</th>\n",
       "      <th>...</th>\n",
       "      <th>tipo</th>\n",
       "      <th>distancia</th>\n",
       "      <th>data_consolidacao</th>\n",
       "      <th>agrupadora</th>\n",
       "      <th>id_turma_agrupadora</th>\n",
       "      <th>qtd_aulas_lancadas</th>\n",
       "      <th>situacao_turma</th>\n",
       "      <th>convenio</th>\n",
       "      <th>modalidade_participantes</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>57602445</td>\n",
       "      <td>01</td>\n",
       "      <td>5755233.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63499</td>\n",
       "      <td>LATO SENSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Auditório do DEF e LabLUD do DEF da UFRN</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-10-30 16:56:59.858</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>57602445</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120983811.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63499</td>\n",
       "      <td>LATO SENSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Auditório do DEF e LabLUD do DEF da UFRN</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-10-30 16:56:59.858</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>57602446</td>\n",
       "      <td>01</td>\n",
       "      <td>5757053.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63503</td>\n",
       "      <td>LATO SENSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Auditório do DEF da UFRN</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-11-13 13:37:22.286</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>57602447</td>\n",
       "      <td>01</td>\n",
       "      <td>5752677.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63327</td>\n",
       "      <td>LATO SENSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Auditório do DEF e Sala de danças do DAD da UFRN</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2018-08-28 09:51:04.942</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>57602447</td>\n",
       "      <td>01</td>\n",
       "      <td>5755233.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63327</td>\n",
       "      <td>LATO SENSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Auditório do DEF e Sala de danças do DAD da UFRN</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2018-08-28 09:51:04.942</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_turma codigo_turma  id_docente_interno  id_docente_externo observacao  \\\n",
       "0  57602445           01           5755233.0                 NaN        NaN   \n",
       "1  57602445           01                 NaN         120983811.0        NaN   \n",
       "2  57602446           01           5757053.0                 NaN        NaN   \n",
       "3  57602447           01           5752677.0                 NaN        NaN   \n",
       "4  57602447           01           5755233.0                 NaN        NaN   \n",
       "\n",
       "   id_componente_curricular nivel_ensino campus_turma  \\\n",
       "0                     63499   LATO SENSU          NaN   \n",
       "1                     63499   LATO SENSU          NaN   \n",
       "2                     63503   LATO SENSU          NaN   \n",
       "3                     63327   LATO SENSU          NaN   \n",
       "4                     63327   LATO SENSU          NaN   \n",
       "\n",
       "                                              local   ano     ...      \\\n",
       "0          Auditório do DEF e LabLUD do DEF da UFRN  2017     ...       \n",
       "1          Auditório do DEF e LabLUD do DEF da UFRN  2017     ...       \n",
       "2                          Auditório do DEF da UFRN  2017     ...       \n",
       "3  Auditório do DEF e Sala de danças do DAD da UFRN  2017     ...       \n",
       "4  Auditório do DEF e Sala de danças do DAD da UFRN  2017     ...       \n",
       "\n",
       "      tipo distancia        data_consolidacao agrupadora  id_turma_agrupadora  \\\n",
       "0  REGULAR         f  2017-10-30 16:56:59.858          f                  NaN   \n",
       "1  REGULAR         f  2017-10-30 16:56:59.858          f                  NaN   \n",
       "2  REGULAR         f  2017-11-13 13:37:22.286          f                  NaN   \n",
       "3  REGULAR         f  2018-08-28 09:51:04.942          f                  NaN   \n",
       "4  REGULAR         f  2018-08-28 09:51:04.942          f                  NaN   \n",
       "\n",
       "   qtd_aulas_lancadas situacao_turma convenio modalidade_participantes  \\\n",
       "0                15.0    CONSOLIDADA      NaN               Presencial   \n",
       "1                15.0    CONSOLIDADA      NaN               Presencial   \n",
       "2                15.0    CONSOLIDADA      NaN               Presencial   \n",
       "3                 0.0    CONSOLIDADA      NaN               Presencial   \n",
       "4                 0.0    CONSOLIDADA      NaN               Presencial   \n",
       "\n",
       "  Unnamed: 25  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         NaN  \n",
       "3         NaN  \n",
       "4         NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "turmas.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "docentes = pd.read_csv(\"data/docentes.csv\", sep=';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_servidor</th>\n",
       "      <th>siape</th>\n",
       "      <th>nome</th>\n",
       "      <th>formacao</th>\n",
       "      <th>tipo_jornada_trabalho</th>\n",
       "      <th>vinculo</th>\n",
       "      <th>categoria</th>\n",
       "      <th>classe_funcional</th>\n",
       "      <th>id_unidade_lotacao</th>\n",
       "      <th>lotacao</th>\n",
       "      <th>admissao</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21041</td>\n",
       "      <td>349938</td>\n",
       "      <td>GILDETE AZEVEDO</td>\n",
       "      <td>DESCONHECIDA</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DE 1  E 2  GRAUS</td>\n",
       "      <td>C                                             ...</td>\n",
       "      <td>1452</td>\n",
       "      <td>NÚCLEO DE EDUCAÇÃO DA INFÂNCIA</td>\n",
       "      <td>1984-08-27 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5753261</td>\n",
       "      <td>709857</td>\n",
       "      <td>MARIA NUBIA PESSOA</td>\n",
       "      <td>ESPECIALIZAÇÃO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DE ENSINO BASICO DE EX-TERRITORIO</td>\n",
       "      <td>D                                             ...</td>\n",
       "      <td>1452</td>\n",
       "      <td>NÚCLEO DE EDUCAÇÃO DA INFÂNCIA</td>\n",
       "      <td>2010-01-06 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5752617</td>\n",
       "      <td>713506</td>\n",
       "      <td>RUTILENE SANTOS DE SOUSA</td>\n",
       "      <td>MESTRADO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DE ENSINO BASICO DE EX-TERRITORIO</td>\n",
       "      <td>D                                             ...</td>\n",
       "      <td>1452</td>\n",
       "      <td>NÚCLEO DE EDUCAÇÃO DA INFÂNCIA</td>\n",
       "      <td>2009-03-12 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>22092</td>\n",
       "      <td>709496</td>\n",
       "      <td>ADAUTO CHIAMENTI</td>\n",
       "      <td>DOUTORADO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DE ENSINO BASICO TECNICO E TECNOLOGICO</td>\n",
       "      <td>DV                                            ...</td>\n",
       "      <td>351</td>\n",
       "      <td>ESCOLA AGRÍCOLA DE JUNDIAÍ</td>\n",
       "      <td>1988-03-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2263697</td>\n",
       "      <td>1543339</td>\n",
       "      <td>ADELE GUIMARAES UBARANA SANTOS</td>\n",
       "      <td>MESTRADO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DE ENSINO BASICO TECNICO E TECNOLOGICO</td>\n",
       "      <td>DIII                                          ...</td>\n",
       "      <td>1452</td>\n",
       "      <td>NÚCLEO DE EDUCAÇÃO DA INFÂNCIA</td>\n",
       "      <td>2006-07-24 00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_servidor    siape                            nome        formacao  \\\n",
       "0        21041   349938                 GILDETE AZEVEDO    DESCONHECIDA   \n",
       "1      5753261   709857              MARIA NUBIA PESSOA  ESPECIALIZAÇÃO   \n",
       "2      5752617   713506        RUTILENE SANTOS DE SOUSA        MESTRADO   \n",
       "3        22092   709496                ADAUTO CHIAMENTI       DOUTORADO   \n",
       "4      2263697  1543339  ADELE GUIMARAES UBARANA SANTOS        MESTRADO   \n",
       "\n",
       "            tipo_jornada_trabalho           vinculo  \\\n",
       "0  Dedicação exclusiva             Ativo Permanente   \n",
       "1  Dedicação exclusiva             Ativo Permanente   \n",
       "2  Dedicação exclusiva             Ativo Permanente   \n",
       "3  Dedicação exclusiva             Ativo Permanente   \n",
       "4  Dedicação exclusiva             Ativo Permanente   \n",
       "\n",
       "                                          categoria  \\\n",
       "0          PROFESSOR DE 1  E 2  GRAUS                 \n",
       "1       PROFESSOR DE ENSINO BASICO DE EX-TERRITORIO   \n",
       "2       PROFESSOR DE ENSINO BASICO DE EX-TERRITORIO   \n",
       "3  PROFESSOR DE ENSINO BASICO TECNICO E TECNOLOGICO   \n",
       "4  PROFESSOR DE ENSINO BASICO TECNICO E TECNOLOGICO   \n",
       "\n",
       "                                    classe_funcional  id_unidade_lotacao  \\\n",
       "0  C                                             ...                1452   \n",
       "1  D                                             ...                1452   \n",
       "2  D                                             ...                1452   \n",
       "3  DV                                            ...                 351   \n",
       "4  DIII                                          ...                1452   \n",
       "\n",
       "                          lotacao             admissao  \n",
       "0  NÚCLEO DE EDUCAÇÃO DA INFÂNCIA  1984-08-27 00:00:00  \n",
       "1  NÚCLEO DE EDUCAÇÃO DA INFÂNCIA  2010-01-06 00:00:00  \n",
       "2  NÚCLEO DE EDUCAÇÃO DA INFÂNCIA  2009-03-12 00:00:00  \n",
       "3      ESCOLA AGRÍCOLA DE JUNDIAÍ  1988-03-01 00:00:00  \n",
       "4  NÚCLEO DE EDUCAÇÃO DA INFÂNCIA  2006-07-24 00:00:00  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "docentes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2393, 11)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "docentes.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>id_servidor</th>\n",
       "      <th>siape</th>\n",
       "      <th>nome</th>\n",
       "      <th>formacao</th>\n",
       "      <th>tipo_jornada_trabalho</th>\n",
       "      <th>vinculo</th>\n",
       "      <th>categoria</th>\n",
       "      <th>classe_funcional</th>\n",
       "      <th>id_unidade_lotacao</th>\n",
       "      <th>lotacao</th>\n",
       "      <th>admissao</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1861</th>\n",
       "      <td>5752477</td>\n",
       "      <td>1475328</td>\n",
       "      <td>NEEMIAS ALVES DE LIMA</td>\n",
       "      <td>DOUTORADO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DO MAGISTERIO SUPERIOR</td>\n",
       "      <td>Classe C - Adjunto                            ...</td>\n",
       "      <td>4885</td>\n",
       "      <td>ESCOLA DE CIÊNCIAS E TECNOLOGIA</td>\n",
       "      <td>2009-03-25 00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id_servidor    siape                   nome   formacao  \\\n",
       "1861      5752477  1475328  NEEMIAS ALVES DE LIMA  DOUTORADO   \n",
       "\n",
       "               tipo_jornada_trabalho           vinculo  \\\n",
       "1861  Dedicação exclusiva             Ativo Permanente   \n",
       "\n",
       "                             categoria  \\\n",
       "1861  PROFESSOR DO MAGISTERIO SUPERIOR   \n",
       "\n",
       "                                       classe_funcional  id_unidade_lotacao  \\\n",
       "1861  Classe C - Adjunto                            ...                4885   \n",
       "\n",
       "                              lotacao             admissao  \n",
       "1861  ESCOLA DE CIÊNCIAS E TECNOLOGIA  2009-03-25 00:00:00  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "docentes[docentes.id_servidor == 5752477]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>id_turma</th>\n",
       "      <th>codigo_turma</th>\n",
       "      <th>id_docente_interno</th>\n",
       "      <th>id_docente_externo</th>\n",
       "      <th>observacao</th>\n",
       "      <th>id_componente_curricular</th>\n",
       "      <th>nivel_ensino</th>\n",
       "      <th>campus_turma</th>\n",
       "      <th>local</th>\n",
       "      <th>ano</th>\n",
       "      <th>...</th>\n",
       "      <th>tipo</th>\n",
       "      <th>distancia</th>\n",
       "      <th>data_consolidacao</th>\n",
       "      <th>agrupadora</th>\n",
       "      <th>id_turma_agrupadora</th>\n",
       "      <th>qtd_aulas_lancadas</th>\n",
       "      <th>situacao_turma</th>\n",
       "      <th>convenio</th>\n",
       "      <th>modalidade_participantes</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5127</th>\n",
       "      <td>57605947</td>\n",
       "      <td>01</td>\n",
       "      <td>5752891.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57594</td>\n",
       "      <td>GRADUAÇÃO</td>\n",
       "      <td>Campus Central</td>\n",
       "      <td>ECT - Sala 5</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-12-14 18:02:18.621</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5128</th>\n",
       "      <td>57605948</td>\n",
       "      <td>02</td>\n",
       "      <td>5752477.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57594</td>\n",
       "      <td>GRADUAÇÃO</td>\n",
       "      <td>Campus Central</td>\n",
       "      <td>ECT - Sala 5</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-12-10 07:42:20.911</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5129</th>\n",
       "      <td>57605949</td>\n",
       "      <td>03</td>\n",
       "      <td>5752477.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57594</td>\n",
       "      <td>GRADUAÇÃO</td>\n",
       "      <td>Campus Central</td>\n",
       "      <td>ECT - Sala 1</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-12-13 19:45:08.823</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5130</th>\n",
       "      <td>57605950</td>\n",
       "      <td>04</td>\n",
       "      <td>5758562.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57594</td>\n",
       "      <td>GRADUAÇÃO</td>\n",
       "      <td>Campus Central</td>\n",
       "      <td>ECT - Auditório D</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-12-14 11:40:16.711</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id_turma codigo_turma  id_docente_interno  id_docente_externo  \\\n",
       "5127  57605947           01           5752891.0                 NaN   \n",
       "5128  57605948           02           5752477.0                 NaN   \n",
       "5129  57605949           03           5752477.0                 NaN   \n",
       "5130  57605950           04           5758562.0                 NaN   \n",
       "\n",
       "     observacao  id_componente_curricular nivel_ensino    campus_turma  \\\n",
       "5127        NaN                     57594    GRADUAÇÃO  Campus Central   \n",
       "5128        NaN                     57594    GRADUAÇÃO  Campus Central   \n",
       "5129        NaN                     57594    GRADUAÇÃO  Campus Central   \n",
       "5130        NaN                     57594    GRADUAÇÃO  Campus Central   \n",
       "\n",
       "                  local   ano     ...         tipo distancia  \\\n",
       "5127       ECT - Sala 5  2017     ...      REGULAR         f   \n",
       "5128       ECT - Sala 5  2017     ...      REGULAR         f   \n",
       "5129       ECT - Sala 1  2017     ...      REGULAR         f   \n",
       "5130  ECT - Auditório D  2017     ...      REGULAR         f   \n",
       "\n",
       "            data_consolidacao agrupadora  id_turma_agrupadora  \\\n",
       "5127  2017-12-14 18:02:18.621          f                  NaN   \n",
       "5128  2017-12-10 07:42:20.911          f                  NaN   \n",
       "5129  2017-12-13 19:45:08.823          f                  NaN   \n",
       "5130  2017-12-14 11:40:16.711          f                  NaN   \n",
       "\n",
       "      qtd_aulas_lancadas situacao_turma convenio modalidade_participantes  \\\n",
       "5127                70.0    CONSOLIDADA      NaN               Presencial   \n",
       "5128                70.0    CONSOLIDADA      NaN               Presencial   \n",
       "5129                76.0    CONSOLIDADA      NaN               Presencial   \n",
       "5130                74.0    CONSOLIDADA      NaN               Presencial   \n",
       "\n",
       "     Unnamed: 25  \n",
       "5127         NaN  \n",
       "5128         NaN  \n",
       "5129         NaN  \n",
       "5130         NaN  \n",
       "\n",
       "[4 rows x 26 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "turmas[turmas.id_componente_curricular == 57594]\n",
    "# turmas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id_turma', 'codigo_turma', 'id_docente_interno', 'id_docente_externo',\n",
       "       'observacao', 'id_componente_curricular', 'nivel_ensino',\n",
       "       'campus_turma', 'local', 'ano', 'periodo', 'data_inicio', 'data_fim',\n",
       "       'descricao_horario', 'total_solicitacoes', 'capacidade_aluno', 'tipo',\n",
       "       'distancia', 'data_consolidacao', 'agrupadora', 'id_turma_agrupadora',\n",
       "       'qtd_aulas_lancadas', 'situacao_turma', 'convenio',\n",
       "       'modalidade_participantes', 'Unnamed: 25'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "turmas.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "avaliacoes = pd.read_csv(\"avaliacaodocencia.csv\", sep=';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id_docente', 'nome_docente', 'id_turma', 'ano', 'periodo',\n",
       "       'qtd_discentes', 'postura_profissional_media',\n",
       "       'postura_profissional_DP', 'atuacao_profissional_media',\n",
       "       'atuacao_profissional_DP', 'autoavaliacao_aluno_media',\n",
       "       'autoavaliacao_aluno_DP'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avaliacoes.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# avaliacoes[avaliacoes.id_docente == 5752477]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>id_turma</th>\n",
       "      <th>codigo_turma</th>\n",
       "      <th>id_docente_interno</th>\n",
       "      <th>id_docente_externo</th>\n",
       "      <th>observacao</th>\n",
       "      <th>id_componente_curricular</th>\n",
       "      <th>nivel_ensino</th>\n",
       "      <th>campus_turma</th>\n",
       "      <th>local</th>\n",
       "      <th>ano</th>\n",
       "      <th>...</th>\n",
       "      <th>tipo</th>\n",
       "      <th>distancia</th>\n",
       "      <th>data_consolidacao</th>\n",
       "      <th>agrupadora</th>\n",
       "      <th>id_turma_agrupadora</th>\n",
       "      <th>qtd_aulas_lancadas</th>\n",
       "      <th>situacao_turma</th>\n",
       "      <th>convenio</th>\n",
       "      <th>modalidade_participantes</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4339</th>\n",
       "      <td>57605539</td>\n",
       "      <td>08</td>\n",
       "      <td>5757166.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57587</td>\n",
       "      <td>GRADUAÇÃO</td>\n",
       "      <td>Campus Central</td>\n",
       "      <td>ECT - Aud. D</td>\n",
       "      <td>2017</td>\n",
       "      <td>...</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>f</td>\n",
       "      <td>2017-12-16 13:10:30.852</td>\n",
       "      <td>f</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.0</td>\n",
       "      <td>CONSOLIDADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presencial</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id_turma codigo_turma  id_docente_interno  id_docente_externo  \\\n",
       "4339  57605539           08           5757166.0                 NaN   \n",
       "\n",
       "     observacao  id_componente_curricular nivel_ensino    campus_turma  \\\n",
       "4339        NaN                     57587    GRADUAÇÃO  Campus Central   \n",
       "\n",
       "             local   ano     ...         tipo distancia  \\\n",
       "4339  ECT - Aud. D  2017     ...      REGULAR         f   \n",
       "\n",
       "            data_consolidacao agrupadora  id_turma_agrupadora  \\\n",
       "4339  2017-12-16 13:10:30.852          f                  NaN   \n",
       "\n",
       "      qtd_aulas_lancadas situacao_turma convenio modalidade_participantes  \\\n",
       "4339                76.0    CONSOLIDADA      NaN               Presencial   \n",
       "\n",
       "     Unnamed: 25  \n",
       "4339         NaN  \n",
       "\n",
       "[1 rows x 26 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# turmas[turmas.id_turma == 57605667]\n",
    "turmas[turmas.id_turma == 57605539]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_servidor</th>\n",
       "      <th>siape</th>\n",
       "      <th>nome</th>\n",
       "      <th>formacao</th>\n",
       "      <th>tipo_jornada_trabalho</th>\n",
       "      <th>vinculo</th>\n",
       "      <th>categoria</th>\n",
       "      <th>classe_funcional</th>\n",
       "      <th>id_unidade_lotacao</th>\n",
       "      <th>lotacao</th>\n",
       "      <th>admissao</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>5757166</td>\n",
       "      <td>2998751</td>\n",
       "      <td>PAULO HENRIQUE SOUSA DE OLIVEIRA</td>\n",
       "      <td>DOUTORADO</td>\n",
       "      <td>Dedicação exclusiva</td>\n",
       "      <td>Ativo Permanente</td>\n",
       "      <td>PROFESSOR DO MAGISTERIO SUPERIOR</td>\n",
       "      <td>Classe C - Adjunto                            ...</td>\n",
       "      <td>4885</td>\n",
       "      <td>ESCOLA DE CIÊNCIAS E TECNOLOGIA</td>\n",
       "      <td>2015-02-09 00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id_servidor    siape                              nome   formacao  \\\n",
       "1927      5757166  2998751  PAULO HENRIQUE SOUSA DE OLIVEIRA  DOUTORADO   \n",
       "\n",
       "               tipo_jornada_trabalho           vinculo  \\\n",
       "1927  Dedicação exclusiva             Ativo Permanente   \n",
       "\n",
       "                             categoria  \\\n",
       "1927  PROFESSOR DO MAGISTERIO SUPERIOR   \n",
       "\n",
       "                                       classe_funcional  id_unidade_lotacao  \\\n",
       "1927  Classe C - Adjunto                            ...                4885   \n",
       "\n",
       "                              lotacao             admissao  \n",
       "1927  ESCOLA DE CIÊNCIAS E TECNOLOGIA  2015-02-09 00:00:00  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# docentes[docentes.id_servidor == 5757983]\n",
    "docentes[docentes.id_servidor == 5757166]\n",
    "# docentes[docentes.id_servidor > 5757000]"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}