Pandas formatos diferentes de entrada e saída (IO)_Lendo e escrevendo excel.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Pandas_IO.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "collapsed_sections": [
        "OV2e4bJ12eOi",
        "NXuU1IUz2jnJ",
        "rWFG7JlcAEwc",
        "enq_vtyNCpps",
        "7AVQoMOlNWkK"
      ]
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "metadata": {
        "id": "OV2e4bJ12eOi",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Criando os nomes"
      ]
    },
    {
      "metadata": {
        "id": "7f53UWACvaCX",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import pandas as pd"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "XxOW1IZZwV-K",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "nomes_m = pd.read_json(\"https://servicodados.ibge.gov.br/api/v1/censos/nomes/ranking?qtd=200&sexo=m\")\n",
        "nomes_f = pd.read_json(\"https://servicodados.ibge.gov.br/api/v1/censos/nomes/ranking?qtd=200&sexo=f\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "glPFYAfIwqag",
        "colab_type": "code",
        "outputId": "6cb24454-72c6-45ee-b1f4-f647bd8cc2b1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "print(\"Quantidade de nomes: \" + str(len(nomes_f) + len(nomes_m)))"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Quantidade de nomes: 400\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "ZhxSJe14w6t8",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "frames = [nomes_f, nomes_m]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "TexNJ2VoxotO",
        "colab_type": "code",
        "outputId": "b6b8fe90-8663-459f-b5c6-ea3055def67e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 2196
        }
      },
      "cell_type": "code",
      "source": [
        "frames"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[         freq        nome  rank  regiao sexo\n",
              " 0    11694738       MARIA     1       0    F\n",
              " 1     3079729         ANA     2       0    F\n",
              " 2      721637   FRANCISCA     3       0    F\n",
              " 3      588783     ANTONIA     4       0    F\n",
              " 4      565621     ADRIANA     5       0    F\n",
              " 5      562589     JULIANA     6       0    F\n",
              " 6      551855      MARCIA     7       0    F\n",
              " 7      531607    FERNANDA     8       0    F\n",
              " 8      529446    PATRICIA     9       0    F\n",
              " 9      509869       ALINE    10       0    F\n",
              " 10     479230      SANDRA    11       0    F\n",
              " 11     469851      CAMILA    12       0    F\n",
              " 12     464624      AMANDA    13       0    F\n",
              " 13     460770       BRUNA    14       0    F\n",
              " 14     456472     JESSICA    15       0    F\n",
              " 15     434056     LETICIA    16       0    F\n",
              " 16     430067       JULIA    17       0    F\n",
              " 17     429769     LUCIANA    18       0    F\n",
              " 18     417512     VANESSA    19       0    F\n",
              " 19     381778     MARIANA    20       0    F\n",
              " 20     378807    GABRIELA    21       0    F\n",
              " 21     376202        VERA    22       0    F\n",
              " 22     366797     VITORIA    23       0    F\n",
              " 23     360523     LARISSA    24       0    F\n",
              " 24     358175     CLAUDIA    25       0    F\n",
              " 25     354980     BEATRIZ    26       0    F\n",
              " 26     354720        RITA    27       0    F\n",
              " 27     354625       LUANA    28       0    F\n",
              " 28     354487       SONIA    29       0    F\n",
              " 29     345195      RENATA    30       0    F\n",
              " ..        ...         ...   ...     ...  ...\n",
              " 170     93355   MARINALVA   171       0    F\n",
              " 171     92470   TERESINHA   172       0    F\n",
              " 172     92065      REBECA   173       0    F\n",
              " 173     91752     GERALDA   174       0    F\n",
              " 174     90779    CLEONICE   175       0    F\n",
              " 175     89381   ALEXANDRA   176       0    F\n",
              " 176     88631        MARA   177       0    F\n",
              " 177     88574     JENIFER   178       0    F\n",
              " 178     88505  ELIZANGELA   179       0    F\n",
              " 179     88064     LILIANE   180       0    F\n",
              " 180     88023       LIDIA   181       0    F\n",
              " 181     87953     IRACEMA   182       0    F\n",
              " 182     86963     LIDIANE   183       0    F\n",
              " 183     86816       IRACI   184       0    F\n",
              " 184     86734     MARILIA   185       0    F\n",
              " 185     85939      SHEILA   186       0    F\n",
              " 186     85322        INES   187       0    F\n",
              " 187     85317      NAIARA   188       0    F\n",
              " 188     84237     POLIANA   189       0    F\n",
              " 189     83485       DALVA   190       0    F\n",
              " 190     83288      LURDES   191       0    F\n",
              " 191     83045      TERESA   192       0    F\n",
              " 192     82927       ZILDA   193       0    F\n",
              " 193     82838    LUCILENE   194       0    F\n",
              " 194     82626       CLARA   195       0    F\n",
              " 195     82203      ROSANE   196       0    F\n",
              " 196     81878     IVONETE   197       0    F\n",
              " 197     81230     LUCIANE   198       0    F\n",
              " 198     81100     ISADORA   199       0    F\n",
              " 199     80128       NILZA   200       0    F\n",
              " \n",
              " [200 rows x 5 columns],         freq       nome  rank  regiao sexo\n",
              " 0    5732508       JOSE     1       0    M\n",
              " 1    2971935       JOAO     2       0    M\n",
              " 2    2567494    ANTONIO     3       0    M\n",
              " 3    1765197  FRANCISCO     4       0    M\n",
              " 4    1483121     CARLOS     5       0    M\n",
              " 5    1417907      PAULO     6       0    M\n",
              " 6    1213557      PEDRO     7       0    M\n",
              " 7    1116818      LUCAS     8       0    M\n",
              " 8    1102927       LUIZ     9       0    M\n",
              " 9    1101126     MARCOS    10       0    M\n",
              " 10    931530       LUIS    11       0    M\n",
              " 11    922744    GABRIEL    12       0    M\n",
              " 12    814709     RAFAEL    13       0    M\n",
              " 13    706527     DANIEL    14       0    M\n",
              " 14    690098    MARCELO    15       0    M\n",
              " 15    663271      BRUNO    16       0    M\n",
              " 16    628539    EDUARDO    17       0    M\n",
              " 17    615924     FELIPE    18       0    M\n",
              " 18    611174   RAIMUNDO    19       0    M\n",
              " 19    598825    RODRIGO    20       0    M\n",
              " 20    590924     MANOEL    21       0    M\n",
              " 21    583962     MATEUS    22       0    M\n",
              " 22    578975      ANDRE    23       0    M\n",
              " 23    551776   FERNANDO    24       0    M\n",
              " 24    545581      FABIO    25       0    M\n",
              " 25    544258   LEONARDO    26       0    M\n",
              " 26    537598    GUSTAVO    27       0    M\n",
              " 27    525028  GUILHERME    28       0    M\n",
              " 28    506483    LEANDRO    29       0    M\n",
              " 29    492149      TIAGO    30       0    M\n",
              " ..       ...        ...   ...     ...  ...\n",
              " 170    76472  ALEXANDRO   171       0    M\n",
              " 171    75699   VALDEMIR   172       0    M\n",
              " 172    75619  WANDERSON   173       0    M\n",
              " 173    75076    JAILSON   174       0    M\n",
              " 174    75029      DENIS   175       0    M\n",
              " 175    74729       RIAN   176       0    M\n",
              " 176    74693      CELIO   177       0    M\n",
              " 177    74264  CLAUDINEI   178       0    M\n",
              " 178    74095   DENILSON   179       0    M\n",
              " 179    73618       IAGO   180       0    M\n",
              " 180    73467       EDER   181       0    M\n",
              " 181    73204       YURI   182       0    M\n",
              " 182    72715    CHARLES   183       0    M\n",
              " 183    72507     MARLON   184       0    M\n",
              " 184    72186     ALISON   185       0    M\n",
              " 185    71812    JONATAN   186       0    M\n",
              " 186    71759       ERIC   187       0    M\n",
              " 187    71566      ELTON   188       0    M\n",
              " 188    71383   VALDECIR   189       0    M\n",
              " 189    70454     WESLEI   190       0    M\n",
              " 190    69835   NATANAEL   191       0    M\n",
              " 191    69692      ERICK   192       0    M\n",
              " 192    68920    AGNALDO   193       0    M\n",
              " 193    68526      KAUAN   194       0    M\n",
              " 194    67758      ODAIR   195       0    M\n",
              " 195    67207     WALTER   196       0    M\n",
              " 196    66669    ARLINDO   197       0    M\n",
              " 197    65736    MICHAEL   198       0    M\n",
              " 198    65444     ALVARO   199       0    M\n",
              " 199    65435    GEOVANE   200       0    M\n",
              " \n",
              " [200 rows x 5 columns]]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "metadata": {
        "id": "swTtxsp3xhmg",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "nomes = pd.concat(frames)['nome'].to_frame()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "jYI_nw1bx0ZT",
        "colab_type": "code",
        "outputId": "31b1b4a7-8c48-407f-962d-fc60c9a781eb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>149</th>\n",
              "      <td>CICERA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94</th>\n",
              "      <td>SABRINA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>112</th>\n",
              "      <td>TATIANA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>FABIO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>CLAUDIO</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        nome\n",
              "149   CICERA\n",
              "94   SABRINA\n",
              "112  TATIANA\n",
              "24     FABIO\n",
              "41   CLAUDIO"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "metadata": {
        "id": "NXuU1IUz2jnJ",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Incluindo ID dos alunos"
      ]
    },
    {
      "metadata": {
        "id": "QsOlbPOH2Sxm",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import numpy as np\n",
        "np.random.seed(123)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "lOKUmPXt2zKe",
        "colab_type": "code",
        "outputId": "ff73e841-15d4-4aed-bd9a-bc9a2756ea19",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "total_alunos = len(nomes)\n",
        "total_alunos"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "400"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "metadata": {
        "id": "NSZZyQD627Fn",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "nomes[\"id_aluno\"] = np.random.permutation(total_alunos) + 1"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "phR4SHAt3E_3",
        "colab_type": "code",
        "outputId": "038d3d6f-dc44-4819-9cc1-a58f6c24eaa1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>188</th>\n",
              "      <td>POLIANA</td>\n",
              "      <td>369</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>DAIANE</td>\n",
              "      <td>303</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>FRANCISCO</td>\n",
              "      <td>382</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>182</th>\n",
              "      <td>CHARLES</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>ANDERSON</td>\n",
              "      <td>111</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          nome  id_aluno\n",
              "188    POLIANA       369\n",
              "57      DAIANE       303\n",
              "3    FRANCISCO       382\n",
              "182    CHARLES        33\n",
              "30    ANDERSON       111"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "metadata": {
        "id": "-GFdbNbI3Gyn",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "dominios = ['@dominiodoemail.com.br', '@servicodoemail.com']\n",
        "nomes['dominio'] = np.random.choice(dominios, total_alunos)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "_CCuE4e9355N",
        "colab_type": "code",
        "outputId": "6c6602d0-322e-414c-d1dd-65837c93fd35",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>84</th>\n",
              "      <td>SEVERINO</td>\n",
              "      <td>78</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>JOSE</td>\n",
              "      <td>331</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>IAGO</td>\n",
              "      <td>340</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>SANDRA</td>\n",
              "      <td>174</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>171</th>\n",
              "      <td>TERESINHA</td>\n",
              "      <td>45</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          nome  id_aluno                 dominio\n",
              "84    SEVERINO        78  @dominiodoemail.com.br\n",
              "0         JOSE       331     @servicodoemail.com\n",
              "179       IAGO       340  @dominiodoemail.com.br\n",
              "10      SANDRA       174  @dominiodoemail.com.br\n",
              "171  TERESINHA        45  @dominiodoemail.com.br"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "metadata": {
        "id": "6G24smfL363Q",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "nomes['email'] = nomes.nome.str.cat(nomes.dominio).str.lower()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "Sn7M84lw4Nil",
        "colab_type": "code",
        "outputId": "3f07e40e-8af7-4acd-8f64-517aa9d85679",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>114</th>\n",
              "      <td>ARTHUR</td>\n",
              "      <td>320</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>arthur@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>DAIANE</td>\n",
              "      <td>303</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>daiane@servicodoemail.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>85</th>\n",
              "      <td>HELENA</td>\n",
              "      <td>221</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>helena@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>183</th>\n",
              "      <td>IRACI</td>\n",
              "      <td>8</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>iraci@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>189</th>\n",
              "      <td>DALVA</td>\n",
              "      <td>137</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>dalva@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       nome  id_aluno                 dominio                         email\n",
              "114  ARTHUR       320  @dominiodoemail.com.br  arthur@dominiodoemail.com.br\n",
              "57   DAIANE       303     @servicodoemail.com     daiane@servicodoemail.com\n",
              "85   HELENA       221  @dominiodoemail.com.br  helena@dominiodoemail.com.br\n",
              "183   IRACI         8  @dominiodoemail.com.br   iraci@dominiodoemail.com.br\n",
              "189   DALVA       137  @dominiodoemail.com.br   dalva@dominiodoemail.com.br"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "metadata": {
        "id": "rWFG7JlcAEwc",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Criando a tabela Cursos"
      ]
    },
    {
      "metadata": {
        "id": "6j05EJoi_yXg",
        "colab_type": "code",
        "outputId": "f9f281bd-cead-40b2-c132-3b13e3d2c5bf",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 105
        }
      },
      "cell_type": "code",
      "source": [
        "!pip3 install html5lib\n",
        "!pip3 install lxml"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: html5lib in /usr/local/lib/python3.6/dist-packages (1.0.1)\n",
            "Requirement already satisfied: six>=1.9 in /usr/local/lib/python3.6/dist-packages (from html5lib) (1.11.0)\n",
            "Requirement already satisfied: webencodings in /usr/local/lib/python3.6/dist-packages (from html5lib) (0.5.1)\n",
            "Requirement already satisfied: lxml in /usr/local/lib/python3.6/dist-packages (4.2.5)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "V3QDmWgKAl_O",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import html5lib"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "enuJcHMuAqER",
        "colab_type": "code",
        "outputId": "fe7eb5e5-0dcc-4b45-b2b6-990fadb77d62",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        }
      },
      "cell_type": "code",
      "source": [
        "url = 'http://tabela-cursos.herokuapp.com/index.html'\n",
        "cursos = pd.read_html(url)\n",
        "cursos"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[                          Nome do curso\n",
              " 0                 Lógica de programação\n",
              " 1                         Java para Web\n",
              " 2                           C# para Web\n",
              " 3                         Ruby on Rails\n",
              " 4                      Cursos de Python\n",
              " 5                         PHP com MySql\n",
              " 6                         .NET para web\n",
              " 7            Novas integrações com Java\n",
              " 8                          TDD com Java\n",
              " 9                   Código limpo com C#\n",
              " 10  Preparatório para certificação Java\n",
              " 11                      Hardware básico\n",
              " 12                Persistência com .NET\n",
              " 13                  Desenvolvendo jogos\n",
              " 14                     Análise de dados\n",
              " 15                   Estatística básica\n",
              " 16                  Internet das coisas\n",
              " 17                Programação funcional\n",
              " 18                Boas práticas em Java\n",
              " 19          Orientação objetos com Java]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "metadata": {
        "id": "yF95u6gjAz9x",
        "colab_type": "code",
        "outputId": "3cecf76e-9785-422c-dde7-b396a2546874",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "type(cursos)"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "list"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "metadata": {
        "id": "U9OaBLe1BCnD",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "cursos = cursos[0]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "Lgs_KUwFBF8G",
        "colab_type": "code",
        "outputId": "52831f01-0041-4d47-c571-90a580f5d2ab",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "type(cursos)"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.frame.DataFrame"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "metadata": {
        "id": "mX4W0KOpBKh1",
        "colab_type": "code",
        "outputId": "695e12a5-da4c-4e24-b3ba-f0c37044fb93",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 292
        }
      },
      "cell_type": "code",
      "source": [
        "cursos.head()"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Nome do curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           Nome do curso\n",
              "0  Lógica de programação\n",
              "1          Java para Web\n",
              "2            C# para Web\n",
              "3          Ruby on Rails\n",
              "4       Cursos de Python"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "metadata": {
        "id": "enq_vtyNCpps",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Alterando o index de cursos"
      ]
    },
    {
      "metadata": {
        "id": "_koRYbS7BM7d",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "cursos = cursos.rename(columns={'Nome do curso' : 'nome_do_curso'})"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "sFQLU45gC3m0",
        "colab_type": "code",
        "outputId": "789730c8-079a-4461-be15-3be8ce16db8a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 148
        }
      },
      "cell_type": "code",
      "source": [
        "cursos.head(2)"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           nome_do_curso\n",
              "0  Lógica de programação\n",
              "1          Java para Web"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "metadata": {
        "id": "1yB5jnREC8rU",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "cursos['id'] = cursos.index + 1"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "wEVs9MzuDGzE",
        "colab_type": "code",
        "outputId": "db985594-aab4-4745-cc2c-b4ef1073852c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 241
        }
      },
      "cell_type": "code",
      "source": [
        "cursos.head()"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "      <th>id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Lógica de programação</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Java para Web</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>C# para Web</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Ruby on Rails</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Cursos de Python</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           nome_do_curso  id\n",
              "0  Lógica de programação   1\n",
              "1          Java para Web   2\n",
              "2            C# para Web   3\n",
              "3          Ruby on Rails   4\n",
              "4       Cursos de Python   5"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "metadata": {
        "id": "0kJXsjEwDJcM",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "cursos = cursos.set_index('id')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "2C2eR9HwDVvg",
        "colab_type": "code",
        "outputId": "1f539d7e-e46f-451d-a15b-3b290a4bcba6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        }
      },
      "cell_type": "code",
      "source": [
        "cursos.head(5)"
      ],
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            nome_do_curso\n",
              "id                       \n",
              "1   Lógica de programação\n",
              "2           Java para Web\n",
              "3             C# para Web\n",
              "4           Ruby on Rails\n",
              "5        Cursos de Python"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "metadata": {
        "id": "7AVQoMOlNWkK",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Matriculando os alunos nos cursos"
      ]
    },
    {
      "metadata": {
        "id": "yLtJnrAHNCHr",
        "colab_type": "code",
        "outputId": "411103b1-650d-40b8-c8ad-10ef8f34aee0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>ISABEL</td>\n",
              "      <td>83</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>isabel@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>172</th>\n",
              "      <td>REBECA</td>\n",
              "      <td>165</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>rebeca@servicodoemail.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>130</th>\n",
              "      <td>JUNIOR</td>\n",
              "      <td>184</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>junior@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>JOAQUIM</td>\n",
              "      <td>248</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>joaquim@servicodoemail.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>171</th>\n",
              "      <td>VALDEMIR</td>\n",
              "      <td>3</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>valdemir@dominiodoemail.com.br</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         nome  id_aluno                 dominio  \\\n",
              "59     ISABEL        83  @dominiodoemail.com.br   \n",
              "172    REBECA       165     @servicodoemail.com   \n",
              "130    JUNIOR       184  @dominiodoemail.com.br   \n",
              "70    JOAQUIM       248     @servicodoemail.com   \n",
              "171  VALDEMIR         3  @dominiodoemail.com.br   \n",
              "\n",
              "                              email  \n",
              "59     isabel@dominiodoemail.com.br  \n",
              "172       rebeca@servicodoemail.com  \n",
              "130    junior@dominiodoemail.com.br  \n",
              "70       joaquim@servicodoemail.com  \n",
              "171  valdemir@dominiodoemail.com.br  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "metadata": {
        "id": "c87LZA_mNNtf",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "nomes['matriculas'] = np.ceil(np.random.exponential(size=total_alunos) * 1.5).astype(int) "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "dQHn7LiCNzrJ",
        "colab_type": "code",
        "outputId": "14490557-9de5-4266-b040-41a9fe826c93",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>RUAN</td>\n",
              "      <td>130</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>ruan@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>RAIMUNDA</td>\n",
              "      <td>259</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>raimunda@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>RAFAELA</td>\n",
              "      <td>27</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>rafaela@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>ADRIANO</td>\n",
              "      <td>196</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>adriano@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>117</th>\n",
              "      <td>PAMELA</td>\n",
              "      <td>189</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>pamela@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         nome  id_aluno                 dominio  \\\n",
              "133      RUAN       130     @servicodoemail.com   \n",
              "44   RAIMUNDA       259     @servicodoemail.com   \n",
              "50    RAFAELA        27  @dominiodoemail.com.br   \n",
              "45    ADRIANO       196     @servicodoemail.com   \n",
              "117    PAMELA       189  @dominiodoemail.com.br   \n",
              "\n",
              "                             email  matriculas  \n",
              "133        ruan@servicodoemail.com           1  \n",
              "44     raimunda@servicodoemail.com           1  \n",
              "50   rafaela@dominiodoemail.com.br           1  \n",
              "45      adriano@servicodoemail.com           2  \n",
              "117   pamela@dominiodoemail.com.br           1  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "metadata": {
        "id": "NHbxmhGWN1gC",
        "colab_type": "code",
        "outputId": "3f81e4fe-59db-4a73-9d1a-1f88855663ee",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 190
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.matriculas.describe()"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count    400.000000\n",
              "mean       2.147500\n",
              "std        1.619352\n",
              "min        1.000000\n",
              "25%        1.000000\n",
              "50%        1.500000\n",
              "75%        3.000000\n",
              "max       10.000000\n",
              "Name: matriculas, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "metadata": {
        "id": "IO0eak1GOH1x",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import seaborn as sns"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "17t8xOhcOTh5",
        "colab_type": "code",
        "outputId": "449644d5-8f6d-4893-b571-456d19b1c384",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 398
        }
      },
      "cell_type": "code",
      "source": [
        "sns.distplot(nomes.matriculas)"
      ],
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fcb0b1aa9e8>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 34
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAeYAAAFYCAYAAACGU1/KAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3Xt8VfWd7//32rfc9k6yE7ITEkKI\n4RKIRUDFIqioYD2jtnN6Eep46amnHmfqaTv+OKMyjxn6mA5UO3Z6nRl9tLbHB1TB2rTaowVrlYqV\ni6iAhIsQIJALud92LjvZl98fuZBwSwI7WSvZr+fjofu29lqf/U3Ie6+1vuv7NSKRSEQAAMASbGYX\nAAAAziCYAQCwEIIZAAALIZgBALAQghkAAAshmAEAsBDHWG+wtrZ1rDd5QV5vohob280uwzJoj3PR\nJueiTQajPc5Fmwzm9SbK4bAPe/mY3mMeSUPFAtrjXLTJuWiTwWiPc9Emg420PWI6mAEAsBqCGQAA\nCyGYAQCwEIIZAAALIZgBALAQghkAAAshmAEAsBCCGQAACyGYAQCwEIIZAAALIZgBALAQghkAAAsZ\n89mlcK6teyqisp6l83Kish4AgHnYYwYAwEIIZgAALIRgBgDAQghmAAAshGAGAMBCCGYAACyEYAYA\nwEIIZgAALIRgBgDAQghmAAAshGAGAMBCCGYAACyEYAYAwEIIZgAALIRgBgDAQghmAAAshGAGAMBC\nCGYAACyEYAYAwEIIZgAALIRgBgDAQghmAAAshGAGAMBCCGYAACyEYAYAwEIIZgAALIRgBgDAQghm\nAAAshGAGAMBCCGYAACyEYAYAwEIIZgAALIRgBgDAQghmAAAshGAGAMBCCGYAACyEYAYAwEIIZgAA\nLIRgBgDAQhzDWWjdunXau3evDMPQ6tWrNXfu3P7XfvWrX+nVV1+VzWbTlVdeqX/8x38ctWIBAJjo\nhtxj3rVrl8rKyrRp0yatXbtWa9eu7X/N7/frueee069+9Su9+OKLKi0t1Z49e0a1YAAAJrIhg3n7\n9u1atmyZJKmgoEDNzc3y+/2SJKfTKafTqfb2dgWDQXV0dCglJWV0KwYAYAIbMpjr6urk9Xr7H6el\npam2tlaSFBcXp69//etatmyZbr75Zl111VXKz88fvWoBAJjghnWOeaBIJNJ/3+/369lnn9XmzZvl\ndrv1wAMP6NChQyosLLzg+73eRDkc9kurdhRkZHjMLkEed3xU1hONz2KF9rAa2uRctMlgtMe5aJNL\nN2Qw+3w+1dXV9T+uqalRRkaGJKm0tFS5ublKS0uTJF1zzTXav3//RYO5sbH9cmuOmowMj2prW80u\nQ63+zqis53I/i1Xaw0pok3PRJoPRHueiTQYb6ZeUIQ9lL168WFu2bJEklZSUyOfzye12S5JycnJU\nWlqqzs6eYNm/f7+mTZs2wpIBAECfIfeYFyxYoKKiIq1cuVKGYWjNmjUqLi6Wx+PR8uXL9eCDD+r+\n+++X3W7X/Pnzdc0114xF3QAATEjDOse8atWqQY8HHqpeuXKlVq5cGd2qAACIUYz8BQCAhRDMAABY\nCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDMAABYCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjB\nDACAhRDMAABYCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDMAABYCMEMAICFEMwAAFgIwQwA\ngIUQzAAAWAjBDACAhRDMAABYCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDMAABYCMEMAICF\nEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDMAABYCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDM\nAABYCMEMAICFEMwAAFgIwQwAgIUQzAAAWAjBDACAhRDMAABYCMEMAICFOIaz0Lp167R3714ZhqHV\nq1dr7ty5/a9VVVXp0UcfVXd3t+bMmaN/+Zd/GbViAQCY6IbcY961a5fKysq0adMmrV27VmvXrh30\n+pNPPqmvfvWrevnll2W321VZWTlqxQIAMNENGczbt2/XsmXLJEkFBQVqbm6W3++XJIXDYX3wwQe6\n5ZZbJElr1qxRdnb2KJYLAMDENmQw19XVyev19j9OS0tTbW2tJKmhoUFJSUn67ne/qy9/+cv6/ve/\nP3qVAgAQA4Z1jnmgSCQy6H51dbXuv/9+5eTk6KGHHtLWrVu1dOnSC77f602Uw2G/pGJHQ0aGx+wS\n5HHHR2U90fgsVmgPq6FNzkWbDEZ7nIs2uXRDBrPP51NdXV3/45qaGmVkZEiSvF6vsrOzNXXqVEnS\nokWLdOTIkYsGc2Nj+2WWHD0ZGR7V1raaXYZa/Z1RWc/lfhartIeV0Cbnok0Goz3ORZsMNtIvKUMe\nyl68eLG2bNkiSSopKZHP55Pb7ZYkORwO5ebm6sSJE/2v5+fnj7BkAADQZ8g95gULFqioqEgrV66U\nYRhas2aNiouL5fF4tHz5cq1evVqPP/64IpGIZs6c2d8RDAAAjNywzjGvWrVq0OPCwsL++3l5eXrx\nxRejWxUAADGKkb8AALAQghkAAAshmAEAsBCCGQAACyGYAQCwEIIZAAALIZgBALAQghkAAAshmAEA\nsBCCGQAACyGYAQCwEIIZAAALIZgBALAQghkAAAshmAEAsBCCGQAACyGYAQCwEIIZAAALIZgBALAQ\nghkAAAshmAEAsBCCGQAACyGYAQCwEIIZAAALIZgBALAQghkAAAshmAEAsBCCGQAACyGYAQCwEIIZ\nAAALIZgBALAQghkAAAshmAEAsBCCGQAACyGYAQCwEIIZAAALIZgBALAQghkAAAshmAEAsBCCGQAA\nCyGYAQCwEIIZAAALcZhdAKRQKKzSyhYdr2rRFdnJmp6TIsMwzC4LAGACgtlE3cGQtuw6pdd3lKmz\nKyRJqm7oUHlNmxZdmal4Fz8eAIg1/OU30ca3jurtDyvkdNhUlJ+mvEy3Pjhcq1M1ftX9pUM3zstW\npjfR7DIBAGOIc8wmOVndqq0fVSgrLVFfWHqFrp6VoUmpCVq+MFcLZk5SZ1dI7+ypVFcwZHapAIAx\nRDCbIBKJ6IU3jygSke5ZNkMuh73/NZth6Mor0jW3IF0dgZD2Hqk3sVIAwFgjmE2w62CNPjnVpPkz\nJunKK9LPu8yV+WnyJDp16GSjGlsDY1whAMAsBPMYC3SF9NLbR+Ww27Ti1hkXXM5ut2nhbJ8iEWnn\ngWpFIpExrBIAYBaCeYxt3nVSja0B3X7dVPlSEy66bE6GW1Mz3app7NCxypYxqhAAYCaCeQyFIxG9\ns7dSCXEO3fHpvGG959pCnxx2Qx9+UqtQmL1mAJjoCOYxdLS8WY2tAV09M0NxLvvQb5CUlODUzNxU\ndQRCKjvNXjMATHTDuo553bp12rt3rwzD0OrVqzV37txzlvn+97+vPXv2aP369VEvcqLYeaBaknTd\nnMwRva9wqlcHTzTqwIlG5U9OvuCoYFv3VFxWfR53vFr9nVo6L+ey1gMAuHRD7jHv2rVLZWVl2rRp\nk9auXau1a9ees8zRo0f1/vvvj0qBE0UwFNb7h2qUnOhUYV7qiN7rTnQqN9OthpaAapo6RqlCAIAV\nDBnM27dv17JlyyRJBQUFam5ult/vH7TMk08+qb//+78fnQoniINljfJ3dOuaQp/stpGfQZg9zduz\nnhON0S4NAGAhQx7KrqurU1FRUf/jtLQ01dbWyu12S5KKi4u1cOFC5eQM7/Cn15soh2N451fHQkaG\nZ0y2s/fNI5Kkz1yff842Pe74Id/vTopTxid1OlXtV8QwlJwUNyp1etzxY9Ym4wXtcS7aZDDa41y0\nyaUb8VjZA6+nbWpqUnFxsX75y1+qurp6WO9vbGwf6SZHTUaGR7W1raO+na7ukN7bV6n05DilJznP\n2Warv3NY65mVm6Laxg59cLBa1xT6ol5n3znmsWiT8WKsfkfGE9pkMNrjXLTJYCP9kjLkMVWfz6e6\nurr+xzU1NcrIyJAk7dixQw0NDfqbv/kbPfLIIyopKdG6detGWPLEt6+0Xp1dIS2cnSnbZUznmJeV\nrIQ4u46UN6s7GI5ihQAAqxgymBcvXqwtW7ZIkkpKSuTz+foPY99+++16/fXX9dJLL+mnP/2pioqK\ntHr16tGteBzadfDSemOfzW4zNGNKqrqDYZWd5tsoAExEQx7KXrBggYqKirRy5UoZhqE1a9aouLhY\nHo9Hy5cvH4sax7VgKKyPjzfI501Qrs992eubPiVF+0rrdaS8WdOnpEShQgCAlQzrHPOqVasGPS4s\nLDxnmSlTpnAN83mcqGpVoCukoqK0C15/PBLuBKcmpyeqqr5dzf6AUtyj0wkMAGAORv4aZQfKGiRJ\ns/O8UVtn357y0YrmqK0TAGANBPMoO3iiUYakwigG89RMt1xOm0orWhRm/GwAmFAI5lEU6A6ptLJZ\nUzM9cic4o7Zeu82mguwUdXaFVF7rH/oNAIBxg2AeRUfKmxQMRfpH7YqmvsPZR8o5nA0AEwnBPIr6\nhs+cE8XD2H28njilp8SrsrZN7Z3dUV8/AMAcBPMoOlDW2H/t8WiYkZOiiKTSCqaDBICJgmAeJW2d\n3Tp5ulUF2cnDnnt5pKZN9shuM3S0onnQUKkAgPGLYB4lh8qaFJE0e1raqG3D5bQrL8uj1vZuVTcw\nHSQATAQE8yg5OArXL5/PDK5pBoAJhWAeJQfLGhXntOuK7ORR3Y7Pm6DkRKfKTreqqzs0qtsCAIw+\ngnkUNLd1qaq+XTNyU+Swj24TG4ah6VNSFApHdKyKTmAAMN4RzKPgWGXPYeXpOWMzyURBTooMQzrK\nNc0AMO4RzKPgWGXPnutoH8bukxDnUE6GWw0tATW0dI7JNgEAo4NgHgX9wTx5bIJZOtMJ7JNTTWO2\nTQBA9BHMURYOR3S8qkWT0xOVGB+98bGHkpORpKR4h45VttAJDADGMYI5yirr29TZFRqzw9h9bIah\nmVNTFQxFGAkMAMYxgjnKzpxfHpuOXwPNmJIim83Q4ZONjAQGAOMUwRxlfT2yC8Z4j1mS4l0OTcvy\nqKW9W1X17WO+fQDA5SOYo+xYZYtcTptyMpJM2X5hXs+EGYdO0gkMAMYjgjmKOgJBVdS2aVpWsuw2\nc5p2UkqC0lPiVV7jl7+d6SABYLwhmKPoxOlWRTR21y9fSOHUnr3mw6caTa0DADByBHMUmXl+eaBp\nWR7Fu+z65GSzAlw6BQDjCsEcRWb2yB7IbrepKD9N3aGwDpWx1wwA4wnBHCWRSESllS3yeuLk9cSZ\nXY5m5qbK5bTpYFmjuoNhs8sBAAwTwRwl9S2damnrMv38ch+nw6Y5eV51dYd1mGE6AWDcIJijpO8w\ndoHJh7EHmpXnldNu04HjDQqG2GsGgPGAYI6SsZ5RajjinHbNyktVZ1eIKSEBYJwgmKOktLJZNsNQ\nXpbH7FIGmTPNK7vN0MfHGjjXDADjAMEcBcFQWGWn/ZriS1Kc0252OYPEuxyaM82rjkBQB040mF0O\nAGAIBHMUnKrxKxgKW+r88kBXXpGuhDi7So43qL2T0cAAwMoI5iiw4vnlgZwOm+bNmKRgKKKPjtSZ\nXQ4A4CII5igo7R3xy6rBLEkFOSnyeuJUWtGi+uZOs8sBAFwAwRwFxypblBjnUGZaotmlXJDNMHRN\nYYYkafehGuZrBgCLIpgvk7+jWzWNHboiO1k2wzC7nIuanJ6kXJ9b1Y0dKq1oMbscAMB5EMyX6dg4\nOIw90LWzfXLYDe0+VKOOQNDscgAAZyGYL5NVJq4YLneCUwtmZagrGNbOA9VmlwMAOAvBfJlKLd4j\n+3xm5abK503QyWq/yk63ml0OAGAAgvkyhCMRHa9sUaY3Qe4Ep9nlDJthGFpUlCWbzdCug9UKdDFn\nMwBYBcF8Gaob2tUeCI6rveU+KW6X5k1PV0cgpO0lp+mlDQAWQTBfhvF2fvlsc/LTlNl7SJtJLgDA\nGgjmyzAezy8PZDMMLZ47WS6HTe8fqlFjKwOPAIDZCObLcKyyWU6HTbk+t9mlXDJ3glOLrsxSMBTR\nGztPKhRmBioAMBPBfIkC3SGV17QpL9Mjh318N2NelkfTc1JU19Shjz5hLG0AMNP4ThQTlZ1uVTgS\nGbeHsc927WyfUtwuHTjRqJLjTA8JAGYhmC/ReJi4YiScDptuuy5PNkP6+WsH1NLeZXZJABCTCOZL\nZPWpHi+Fz5uoeTMmqdnfpf/7+iEuoQIAExDMl+hYZYtSklxKT443u5SoKspP0+w8r/YcrdNbH1aY\nXQ4AxByC+RI0tHSqsTWgK7KTZVh8RqmRMgxD//POOXInOLXpraM6VeM3uyQAiCkE8yWYiIexB/J6\n4vTVv5qtYCisZ17Zz5CdADCGHGYXMB4dqxrfI34Nx7wZk7Tsmil6c3e5XnjzE/2Pv5p9SevZuic6\nh8OXzsuJynoAwOrYY74ExyqaZRjStCyP2aWMqi8tna6pmW5t21elXQeZIhIAxsKwgnndunVasWKF\nVq5cqX379g16bceOHbr77ru1cuVKPfHEEwpP8JGjQuGwTpxuVc6kJCXETewDDk6HTQ9/7krFOe16\nfvMh1TZ1mF0SAEx4Qwbzrl27VFZWpk2bNmnt2rVau3btoNf/+Z//WT/+8Y+1ceNGtbW1adu2baNW\nrBWU17SpKxie0IexB8pKS9S9t81URyCkZ14pUTA0sb94AYDZhgzm7du3a9myZZKkgoICNTc3y+8/\n01O3uLhYWVlZkqS0tDQ1NjaOUqnWcOb88sTs+HU+iz81WYuKMnW8qkW/feeY2eUAwIQ2ZDDX1dXJ\n6/X2P05LS1NtbW3/Y7e7ZwKHmpoa/eUvf9FNN900CmVaR2nFxBrxa7juvW2WfN4E/WHnSe0/Xm92\nOQAwYY34JOn5RoOqr6/Xww8/rDVr1gwK8fPxehPlcNhHutlRk5Exsg5cx6talZTg1FWFWbLZonMN\ns8dtnUFKPO74C7bJEw8s1P/5yTv6xWuH9OP/b6m8wxhcJVqfbaQ/p2gyc9tWRZsMRnuciza5dEMG\ns8/nU13dmRmHampqlJGR0f/Y7/fra1/7mr71rW9pyZIlQ26wsbH9EkuNvowMj2prW4e9fLM/oKr6\nNs0tSFd9ffQG3mj1W2MeZI87Xq3+zgu2SUq8XV+8qUAb3zqqp57fpb9fMU+2IQZYidZnG8nPKZpG\n+jsSC2iTwWiPc9Emg430S8qQh7IXL16sLVu2SJJKSkrk8/n6D19L0pNPPqkHHnhAN9544whLHX+O\nlPccxp4xJTY6fp3P8mtzNbcgXSUnGrVl50mzywGACWfIPeYFCxaoqKhIK1eulGEYWrNmjYqLi+Xx\neLRkyRL97ne/U1lZmV5++WVJ0p133qkVK1aMeuFm6Avm6TmxG8yGYeird8zWml/sUvE7xzRzaqoK\nYqSHOgCMhWGdY161atWgx4WFhf339+/fH92KLOxoRZPsNkP5k2Or49fZkhNdeuiuIj394kd69pUS\nfft/XKvEeKfZZQHAhMDIX8MU6Aqp7LRf0yZ75HJap/OaWWbneXXH9dNU19ypZ189oHCYKSIBIBoI\n5mE6VtmscCSiGVNSzS7FMv56Sb6uvCJNHx+r12+3cX0zAEQDwTxMR3qvX54Rw+eXz2azGfpfny2S\nz5ug17aXMZ42AEQBwTxMfR2/CmK4R/b5JMU79b8//ynFuez6xesHVXaaSyQA4HIQzMMQDkdUWtGs\nyemJSk50mV2O5eRkuPXQnXPU3R3WD17ao+oG61yrDgDjDcE8DOW1fnV2hWL6MqmhzJ+ZoXtvm6mW\n9m59f9MeNbYGzC4JAMYlgnkYzgwsQsevi7l5wRT99Q35qmvu1L9v2iN/R7fZJQHAuEMwD8OR8iZJ\n0oxc9piHctf107TsmimqqGvTv734kdo7g2aXBADjyognsYg1kUhEh081KTnJJV9qgtnlWJ5hGFp5\n6wwFQxFt/ahCja0BLbtmipKTODcPAMPBHvMQKura1Ozv0pxpXhlDTNiAHjbD0H23zdTnluTL39Gt\nzTtPqq65w+yyAGBcIJiHcOBEoyRpTl6ayZWML4Zh6HNL8nXdnEwFukLavPOUDpU1nnfaUADAGQTz\nEA6caJAkFeUTzJdi1tRU3XJ1jpx2m3YdrNGf91Qq0B0yuywAsCzOMV9EMBTW4ZNNmpyeKK8nzuxy\nxq2cDLfuWpynbXurdLLar7rmE7q20Kepme4xPz2wdU/FiJbvm6P6bEvn5USrJAAYhD3miyitaFag\nO6Q509hbvlyJ8U4tX5iredPT1RkI6s97KvXWBxVqbe8yuzQAsBSC+SJKes8vFxHMUWEzDM2dPkl3\nLc7X5PREVdS16ZVtJ7T7UI06uzi8DQASwXxRB040yGYYmjWVgUWiKcXt0rJrpuiGqyYrIc6uAyca\n9dt3jmlfab26g2GzywMAU3GO+QLaOrt1vKpFBTkpSoijmaLNMAzlT07W1Ey3Dp9s0selDdpzpE6H\nTzZqbsEkzZiSIpuNy9MAxB4S5wIOlTUpEuEw9miz22yaMy1N03NSVHKiUQdPNGjngWodONGg+TMm\nKS/Lw/XjAGIKwXwBfZdJzZnmNbmS2OBy2jV/xiQVTk3VvtJ6fXKqSe/srVL68QbNn5lhdnkAMGYI\n5gsoOdGgeJdd+ZOTzS4lpiTEOXTdnEzNzvNqz5E6nTjdqjd3l6uyrk1fXFqgaVn8PABMbHT+Oo+q\n+jbVNHZodp5XDjtNZIbkJJdunJetOxblaXJ6og6caNS//N/deuaV/apuZL5nABMXe8zn8cHhWknS\n1bM4hGq29JR4Lb82V5mpCfr11lLtOlijDw7X6sarsvXZxdOU4mbgFwATC8F8HrsP18huMzRv+iSz\nS0Gv2dPS9E8PeLX7cK2K/1yqtz+q0F/2V+m2a3N1+8I8JcbzqwxgYuCv2Vlqmjp0stqvK69IU2K8\n0+xyMIBhGLq20Kf5Mybp3X1VeuUvx/X/3ivT1o8qdeeiPN28IEdOh93sMgHgshDMZ/mw9zD2NbN8\nJleCC3HYbVo6P0eLirL0x92n9IedZdr41lH9cfcp/dWiaVryqSwCGsC4Rc+ms+w+XCObYWj+DA5j\nW12cy647r5+mpx6+Xp9ZmKvmtm6t33JY//Bf2/WHnWVq7wyaXSIAjBh7zAM0tHTqWGWLZud55Ul0\nmV0Ohsmd4NSKW2bo9oVT9cbuU3r7wwr9+u1SvbLtuBbOztRN87J1RXYyA5UAGBcI5gE++KTvMDa9\nscejFHecvrR0uu74dJ7e/qhC7+yt1LsfV+ndj6uUmZaoq2dmSEZE6cnxhDQAyyKYB/jgUI0MSQsY\naWpcS4x36o5F0/TfPp2ng2WNemdPpfaW1un1HWWSpIQ4uzK9icpMS1RWWoKSk1wENQDLIJh7NfsD\nOlLerBlTUrg2doKwGYaKpqWpaFqaAt0hlRxv0Os7ylRZ16YTp1t14nSrJCneZVdmWqIy0xKU5U1U\nipugBmAegrnXtn1VikhaOCfT7FIwCuKcdi2YmaGW9i5FIhG1tHWruqFdpxvbVd3QrrLTrSobENQ+\nb4Ky05M0k0lMAIwxgllSOBzR1j0VinPZtagoy+xyMMoMw1CK26UUt0szp6YqEomotb1bpxt6Qrq6\nseda9pPVfu04UK1Ut0tTfG5Ny/LI64ljbxrAqCKYJe09WqeGloBunp/D3MsxyDAMJSe5lJzk0szc\nM0FdWdem6sYOldf4tf9Yg/Yfa1BykktXTPboqoJJ8no45QEg+kghSW99VCFJunl+jsmVwAoGBvW1\nRZPV2Nyuito2nahqUXltm/Ycrde+0vd01fR0LZ2fo6L8NNkucS96656KqNS8dB6/u8BEEfPBfLqh\nXSXHGzRzSoqm+NxmlwMLcthtysvyKC/Lo+5gWMerWlRV166PjtTpoyN1mpQSrxuvytYNcyfTcRDA\nZYv5YN7au7d8y9VTTK4E44HTYdPM3FQ9dFeRjle16M97KrTjQLWK3zmmV949rvkzJmnp/BwV5nkv\neS8aQGyL6WDu7Arq3X1VSk5yce0yRix/crLyJyfr7ptnaMeB09r6UYV2H67V7sO18nkTdNO8bC3+\n1GQlM4ocgBGI6WD+0/un1B4I6s6rp8lhZ9hwXJrEeIduWTBFN8/PUWlli/78UYV2HarRr98u1W/f\nOaarZ/m0ZO5kFU5Nld3G7xmAi4vZYO4IBPXiG4cU57Tr1gV0nMHlMwxD03NSND0nRSuXzdB7H5/W\n1j0V2nmgWjsPVCs50amrC326dpZP06ek8GUQwHnFbDC/vqNMzf4u/fcb8umwg6hLindq+bW5WnbN\nFB0pb9bOA9XafbhGb39Yobc/rFBCnF1F09LkdNiU4U1QCsOCAugVk8Hc0NKpN94/pfSUeN22cKrZ\n5WACMwxDM3NTNTM3Vfcsn6FDZU3ac6ROe0vrtLt37m9JcjltykhJUIY3QRmp8ZqUkiCngz1qIBbF\nZDD/5s/H1B0M677/NltxTrvZ5SBG2G02FeWnqSg/TfdEZuh0Q7te+ctx1TV1qrapQxV1baqoa5Mk\nGZKSk1zyJscpLTleaZ44pSXHKd4Vk/9kgZgSc//KT5xu0faS05rqc+vmq3NVX+83uyTEIMMwNDk9\nSYVTvVLvQZuOQFC1TR2qbepUXVOHGloDaq7q0omq1v73JcY5lNYb1t7esHYnOKNW13AGPPG449Xq\n7xxyuWgNesIgLIg1MRXMga6QnnvtoCTp7lumy2bjnB6sIyHOoamZHk3N9EiSIpGI/B3damgJqKE1\noIaWTjW2BFRe26by2rb+9zkdNu06UKPcTLfyMj3K9bmVPSmJzmXAOBUzwRyJRPT85kOqqG3TLQty\nNIdZg2BxhmHIk+iSJ9GlvCxP//MdgaAae4O6oSWgxtaAPjnVpMOnmvqXcdgNZU9K6gl6n1tTewOb\nseAB64uZf6V/+qBcOw5UqyAnWStvnWF2OcAlS4hzKCHOoexJSf3PLZqTpfJav05Wt+pkTc9teW2b\nTlYPPlXTN52lNzmu57y1J15pyXHyJsfLy9UJgCXERDAfKW/SpreOKjnRqb/7609xiA8TTpzLroKc\nFBXkpPQ/FwqHdbq+vT+oe6a8UrydAAAN50lEQVSybNWeo3UXXI/DbsjpsCvOaZPTYZfLaZPLYZPL\nae/5z2GTJylOoVBITrtNDodNTrtNTodNjv5bg0u/gMsw4YP5YFmjflr8sSIR6eHPXclUfYgZdptN\nORlu5WS4++cZj0Qiag8Ee85bt3SeOXfd2nNIvKaxXV3BsNoDQXX7uxS5xG077IZe2XZccS674l12\nOew22WyGHDZDtt7/7MbwAryuuUN2e0/gO+y9XwB677ucdiXGO5QU71RSgoMv3ZgQJnQwv7e/Sr98\n/ZAk6X/eOVuFeV6TKwLMZRhGT4jFO5V7ntnUBvaAjkQiCoYiCnSH1B0Mqas7rEB3SA6HXa1tAXUH\nwwqGIuoOhtUdCit41q3TblNnd0jNbV0KhcIKhSOKXGrSD5PLaev9fA4lJ7mU6o5TqtvFIEIYVyZk\nMAdDYf3+Lyf0+/dOKDHOoUc+/ylCGRghwzDkdBi9A52cuSTrci6XCkciCod7/usJ6oh6rtoeuN3B\n79m2r1KhcETBUM8XgZ7bsLqDYQW6w2rv7FZbZ1BtHd1q7wyqtb1Lja0BaUDPdUl6Y9dJZU9yK2dS\nkiZPSlTOJLcmpyfSIQ6WM6F+IyORiD46UqeX3j6qmsYOpSfH61t3X6WcAZ1kAJjHZhiy2Q1pBOP6\nuEY4CFAkElGgO6zmtoCa/V1q8vfctgeC+vhYvT4+Vj9o+VS3S1lpiZqcntR7m6jMtER5PXEcGocp\nhhXM69at0969e2UYhlavXq25c+f2v/bee+/p3//932W323XjjTfq61//+qgVeyGBrpA+OlKrrXsq\n9cmpJtkMQ7dePUWfW5If1cEXAFifYRiKd9kV70pUpjex//ml83LU1tmtyt4R1ipr21TV0K7T9e06\ndLJJh042nbUeKSXJpfTkeHl7R19LT45Xitsld4Kz/7+U1MSzSwAuy5DBvGvXLpWVlWnTpk0qLS3V\n6tWrtWnTpv7X//Vf/1XPPfecMjMzde+99+ozn/mMpk+fPqpF92nr7NaLbx7RB4drFegOSZLmFqRr\nxS3TNTmdvWQAgyXFOzVjSqpmTEkd9HygO6Tqhnad7g3q043tamju6Rx34nSrSitbLrpeh92Qy2mX\nc0Av9b77jgH3nQ6b7Hab7DZDVxWkD3i+570Dl7XZDNkM9d72dpjrvW8Youf7BDZkMG/fvl3Lli2T\nJBUUFKi5uVl+v19ut1unTp1SSkqKJk+eLEm66aabtH379jEL5lPVfr23/7R8qQm6bk6mrpuTOeja\nTgAYjjinfdCoawOFwxE1t3WpobVn5LXdn9Qo0BVSoCukzu6QQqGI2jq7FegKqSMQVGswrPAwOrm9\nu6/qsmruCeue+4bOhHX/bc8LGnAzKMzPznWj90ljwBMDFzn7vUbvAsaAdfVtNyMtUcHuUH89fV8u\n7LbBXzD6eugPfG3Q/d4vJ/azevPbLvD47PXaz/OlpjvY83Pr7PsZdoUU6A6ptb1L9c2dqm8JyGE3\n9H++PN+0/gdDbrWurk5FRUX9j9PS0lRbWyu3263a2lqlpaUNeu3UqVOjU+l5FOZ59YP/vUTJiU6+\nPQIYFTabIa8nrudSy2zJ39k96PXzdYYLhXs6p/X0XO+7H1F3KNzfQz1/cnJPD/beXux9y/c97usk\nF470dJQLRyKKhPvun+lI1+zv6nktElFEUiTcezvgy0Gk90G478lBN73/H7R83+tnFux/OXLm+Ujf\n873b7luuurHjElraGuJdduVlemQ3ccjmEX8diFzm9Q4ZGed+I7289V3u+6Nbz6X40vJCs0sYNVb7\nbNRzcVarR7JeTVarBxPPkF0OfT6f6urOjBRUU1OjjN40PPu16upq+Xy+USgTAIDYMGQwL168WFu2\nbJEklZSUyOfzye3uGZhgypQp8vv9Ki8vVzAY1Ntvv63FixePbsUAAExgRmQYx6affvpp7d69W4Zh\naM2aNTpw4IA8Ho+WL1+u999/X08//bQk6bbbbtODDz446kUDADBRDSuYAQDA2GBYGwAALIRgBgDA\nQmIymNetW6cVK1Zo5cqV2rdvn9nlWML3vvc9rVixQl/4whf0xhtvmF2OJXR2dmrZsmUqLi42uxRL\nePXVV/XZz35Wn//857V161azyzFdW1ubHnnkEd13331auXKltm3bZnZJpvnkk0+0bNkybdiwQZJU\nVVWl++67T/fcc4+++c1vqqury+QKx9b52uMrX/mK7r33Xn3lK19RbW3tRd8fc8E8cIjRtWvXau3a\ntWaXZLodO3boyJEj2rRpk37+859r3bp1ZpdkCf/1X/+llJQUs8uwhMbGRv3Hf/yHXnjhBT3zzDP6\n05/+ZHZJpvvtb3+r/Px8rV+/Xj/60Y9i9m9Je3u7vvOd72jRokX9z/34xz/WPffcoxdeeEF5eXl6\n+eWXTaxwbJ2vPX74wx/q7rvv1oYNG7R8+XL98pe/vOg6Yi6YLzTEaCy79tpr9aMf/UiSlJycrI6O\nDoVCIZOrMldpaamOHj2qpUuXml2KJWzfvl2LFi2S2+2Wz+fTd77zHbNLMp3X61VTU8/EFy0tLfJ6\nY3NqWZfLpZ/97GeDxrDYuXOnbr31VknSzTffrO3bt5tV3pg7X3usWbNGn/nMZyQN/r25kJgL5rq6\nukH/gPqGGI1ldrtdiYk9M+S8/PLLuvHGG2W3j2yqvYnmqaee0uOPP252GZZRXl6uzs5OPfzww7rn\nnnti6g/thdxxxx2qrKzU8uXLde+99+qxxx4zuyRTOBwOxcfHD3quo6NDLpdLkpSenh5Tf2PP1x6J\niYmy2+0KhUJ64YUXdNddd118HaNZ4HjA1WJnvPnmm3r55Zf1i1/8wuxSTPW73/1O8+bNU25urtml\nWEpTU5N++tOfqrKyUvfff7/efvvtmB6j/pVXXlF2draee+45HTp0SKtXr6Y/wnnwN7ZHKBTSP/zD\nP+jTn/70oMPc5xNzwXyxIUZj2bZt2/TMM8/o5z//uTwe88cPN9PWrVt16tQpbd26VadPn5bL5VJW\nVpauv/56s0szTXp6uubPny+Hw6GpU6cqKSlJDQ0NSk9PN7s003z44YdasmSJJKmwsFA1NTUKhUIx\nf7RJ6tlD7OzsVHx8PEM193riiSeUl5enRx55ZMhlY+5Q9sWGGI1Vra2t+t73vqdnn31WqampQ79h\ngvvhD3+o3/zmN3rppZf0pS99SX/3d38X06EsSUuWLNGOHTsUDofV2Nio9vb2mD2n2icvL0979+6V\nJFVUVCgpKYlQ7nX99df3/5194403dMMNN5hckbleffVVOZ1OfeMb3xjW8jE58tfZQ4wWFsb2bDGb\nNm3ST37yE+Xn5/c/99RTTyk7O9vEqqzhJz/5iXJycvT5z3/e7FJMt3Hjxv7etX/7t3/b37knVrW1\ntWn16tWqr69XMBjUN7/5zSEPUU5E+/fv11NPPaWKigo5HA5lZmbq6aef1uOPP65AIKDs7Gx997vf\nldPpNLvUMXG+9qivr1dcXFz/TmBBQYG+/e1vX3AdMRnMAABYVcwdygYAwMoIZgAALIRgBgDAQghm\nAAAshGAGAMBCCGZgAvjwww916tSp87523333XdLY57fccovKysoutzQAI0QwAxNAcXHxBYN5/fr1\nDHwBjCMxNyQnYFU7d+7UM888o6ysLH388ce66qqrNGvWLP3xj39UU1OTfvazn+mtt97SK6+8IqfT\nqbi4OP3gBz/Qzp07tXnzZu3bt09PPPGE/vM//1OFhYU6ePCgnn/+ec2ZM0clJSUKBoN64oknVFVV\nJUl69NFHtXDhQs2aNUslJSVyOBwqLi7We++9p6effrq/rvb2dj322GNqampSW1ubbr/9dj300EOq\nrq7WqlWrJPXMXb1ixQp98YtfNKXtgImEPWbAQvbt26fHHntMv/nNb/T73/9eycnJWr9+vYqKirR5\n82YFAgE999xz2rBhg3JycvTqq69q+fLlmj17th5//PH+kacSExO1YcOGQXvKzz33nLKysrRx40Y9\n+eST+vWvfz2smurr63Xrrbdq/fr12rhxo5599ln5/X794Q9/0BVXXKH169drw4YN6uzsHJU2AWIN\ne8yAhRQUFPSPV56amqr58+dLkjIzM+X3+5WTk6OHHnpINptNFRUVF5yAZcGCBec8t2/fPn35y1+W\nJE2bNk3/9m//Nqya0tPT9cEHH2jjxo1yOp0KBAJqamrSDTfcoBdeeEGPP/64brrpJq1YseJSPjKA\nsxDMgIWcfS544OOqqipt2LBBr732mtLT0/XUU09dcD3nG5fYMAyFw+GLbr+7u/uc555//nl1dXXp\nxRdflGEYuu666yT1fIl47bXX9P7772vz5s16/vnntXHjxouuH8DQOJQNjBP19fXyer1KT09XU1OT\n3n33XXV1dUnqCd3zhepA8+fP17Zt2yRJ5eXleuCBByRJbre7/7zzzp07z7vdgoICGYahP/3pT+rs\n7FRXV5d+//vf6+OPP9b111+vNWvWqKqqSsFgMJofGYhJ7DED48Ts2bMlSV/84hc1depUfeMb39C3\nv/1t3XTTTVq8eLHWrFmj1atXX/D99913n/7pn/5J99xzj8LhsL71rW9Jkh566CE9+OCDysvLU2Fh\nYX9I9/nCF76gRx99VO+++65uvfVW3XXXXVq1apXWrl2rNWvWyOVyKRKJ6Gtf+5ocDv6kAJeL2aUA\nALAQDmUDAGAhBDMAABZCMAMAYCEEMwAAFkIwAwBgIQQzAAAWQjADAGAhBDMAABby/wNMq28PDKBR\nYgAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<matplotlib.figure.Figure at 0x7fcb0b1aa390>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "metadata": {
        "id": "CM9DPt25OXNz",
        "colab_type": "code",
        "outputId": "a871d9ea-8ccb-48d3-b8b4-58e779891353",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.matriculas.value_counts()"
      ],
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1     200\n",
              "2      87\n",
              "3      46\n",
              "4      30\n",
              "5      15\n",
              "7       9\n",
              "6       9\n",
              "8       2\n",
              "10      1\n",
              "9       1\n",
              "Name: matriculas, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 35
        }
      ]
    },
    {
      "metadata": {
        "id": "TSc_Tk0UtTuj",
        "colab_type": "code",
        "outputId": "bdd58a68-7597-43c5-d014-3b154cce6f70",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(5)"
      ],
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>BARBARA</td>\n",
              "      <td>201</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>barbara@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>170</th>\n",
              "      <td>ALEXANDRO</td>\n",
              "      <td>341</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>alexandro@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>197</th>\n",
              "      <td>MICHAEL</td>\n",
              "      <td>323</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>michael@dominiodoemail.com.br</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>196</th>\n",
              "      <td>ARLINDO</td>\n",
              "      <td>99</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>arlindo@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>NEUSA</td>\n",
              "      <td>75</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>neusa@dominiodoemail.com.br</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          nome  id_aluno                 dominio  \\\n",
              "97     BARBARA       201     @servicodoemail.com   \n",
              "170  ALEXANDRO       341     @servicodoemail.com   \n",
              "197    MICHAEL       323  @dominiodoemail.com.br   \n",
              "196    ARLINDO        99     @servicodoemail.com   \n",
              "138      NEUSA        75  @dominiodoemail.com.br   \n",
              "\n",
              "                             email  matriculas  \n",
              "97      barbara@servicodoemail.com           1  \n",
              "170   alexandro@servicodoemail.com           1  \n",
              "197  michael@dominiodoemail.com.br           2  \n",
              "196     arlindo@servicodoemail.com           1  \n",
              "138    neusa@dominiodoemail.com.br           2  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 36
        }
      ]
    },
    {
      "metadata": {
        "id": "Mpw0I-iHt2y2",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Selecionando cursos"
      ]
    },
    {
      "metadata": {
        "id": "dCrXkDp3tkQh",
        "colab_type": "code",
        "outputId": "6d2fde64-bb03-4985-9601-ee736443c470",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 162
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(3)"
      ],
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>CRISTIANE</td>\n",
              "      <td>350</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>cristiane@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>154</th>\n",
              "      <td>NICOLE</td>\n",
              "      <td>182</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>nicole@dominiodoemail.com.br</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>191</th>\n",
              "      <td>TERESA</td>\n",
              "      <td>264</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>teresa@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          nome  id_aluno                 dominio  \\\n",
              "34   CRISTIANE       350  @dominiodoemail.com.br   \n",
              "154     NICOLE       182  @dominiodoemail.com.br   \n",
              "191     TERESA       264  @dominiodoemail.com.br   \n",
              "\n",
              "                               email  matriculas  \n",
              "34   cristiane@dominiodoemail.com.br           1  \n",
              "154     nicole@dominiodoemail.com.br           2  \n",
              "191     teresa@dominiodoemail.com.br           1  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "metadata": {
        "id": "czPyMmylt-03",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "todas_matriculas = []\n",
        "x = np.random.rand(20)\n",
        "prob = x  / sum(x)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "OTZJxQAouUV7",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "for index, row in nomes.iterrows():\n",
        "  id = row.id_aluno\n",
        "  matriculas = row.matriculas\n",
        "  for i in range(matriculas):\n",
        "    mat = [id, np.random.choice(cursos.index, p = prob)]\n",
        "    todas_matriculas.append(mat)\n",
        "    \n",
        "matriculas = pd.DataFrame(todas_matriculas, columns = ['id_aluno', 'id_curso'])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "LQg7x8qmvOxR",
        "colab_type": "code",
        "outputId": "d5edfae3-fb30-47cb-e310-c88426965564",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas.head()"
      ],
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_aluno</th>\n",
              "      <th>id_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>43</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>43</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   id_aluno  id_curso\n",
              "0       235        19\n",
              "1       235        19\n",
              "2        43         9\n",
              "3        43         1\n",
              "4        43        19"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 40
        }
      ]
    },
    {
      "metadata": {
        "id": "nSrKX3g0vQ--",
        "colab_type": "code",
        "outputId": "11b17ec3-e352-4235-826c-4d6e6dfd26d9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 941
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas.groupby('id_curso').count().join(cursos['nome_do_curso']).rename(columns={'id_aluno':'quantidade_de_alunos'})"
      ],
      "execution_count": 41,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_curso</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>62</td>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>52</td>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>25</td>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>33</td>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>59</td>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>17</td>\n",
              "      <td>PHP com MySql</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>56</td>\n",
              "      <td>.NET para web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>37</td>\n",
              "      <td>Novas integrações com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>70</td>\n",
              "      <td>TDD com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>12</td>\n",
              "      <td>Código limpo com C#</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>81</td>\n",
              "      <td>Preparatório para certificação Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>22</td>\n",
              "      <td>Hardware básico</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>52</td>\n",
              "      <td>Persistência com .NET</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>31</td>\n",
              "      <td>Desenvolvendo jogos</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>82</td>\n",
              "      <td>Análise de dados</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>16</td>\n",
              "      <td>Estatística básica</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>44</td>\n",
              "      <td>Internet das coisas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>23</td>\n",
              "      <td>Programação funcional</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>67</td>\n",
              "      <td>Boas práticas em Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>18</td>\n",
              "      <td>Orientação objetos com Java</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          quantidade_de_alunos                        nome_do_curso\n",
              "id_curso                                                           \n",
              "1                           62                Lógica de programação\n",
              "2                           52                        Java para Web\n",
              "3                           25                          C# para Web\n",
              "4                           33                        Ruby on Rails\n",
              "5                           59                     Cursos de Python\n",
              "6                           17                        PHP com MySql\n",
              "7                           56                        .NET para web\n",
              "8                           37           Novas integrações com Java\n",
              "9                           70                         TDD com Java\n",
              "10                          12                  Código limpo com C#\n",
              "11                          81  Preparatório para certificação Java\n",
              "12                          22                      Hardware básico\n",
              "13                          52                Persistência com .NET\n",
              "14                          31                  Desenvolvendo jogos\n",
              "15                          82                     Análise de dados\n",
              "16                          16                   Estatística básica\n",
              "17                          44                  Internet das coisas\n",
              "18                          23                Programação funcional\n",
              "19                          67                Boas práticas em Java\n",
              "20                          18          Orientação objetos com Java"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "metadata": {
        "id": "Cz9tW9KuvuF5",
        "colab_type": "code",
        "outputId": "f70cb57f-43f6-48db-8d8b-5462038d4851",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 162
        }
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(3)"
      ],
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>167</th>\n",
              "      <td>TAINARA</td>\n",
              "      <td>128</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>tainara@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>NEIDE</td>\n",
              "      <td>325</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>neide@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88</th>\n",
              "      <td>GILMAR</td>\n",
              "      <td>142</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>gilmar@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        nome  id_aluno                 dominio                        email  \\\n",
              "167  TAINARA       128     @servicodoemail.com   tainara@servicodoemail.com   \n",
              "141    NEIDE       325  @dominiodoemail.com.br  neide@dominiodoemail.com.br   \n",
              "88    GILMAR       142     @servicodoemail.com    gilmar@servicodoemail.com   \n",
              "\n",
              "     matriculas  \n",
              "167           2  \n",
              "141           1  \n",
              "88            1  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "metadata": {
        "id": "ENlo-LIxwKAi",
        "colab_type": "code",
        "outputId": "404b3324-b460-45d6-e1f2-25b6b7c47e62",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        }
      },
      "cell_type": "code",
      "source": [
        "cursos.head()"
      ],
      "execution_count": 43,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            nome_do_curso\n",
              "id                       \n",
              "1   Lógica de programação\n",
              "2           Java para Web\n",
              "3             C# para Web\n",
              "4           Ruby on Rails\n",
              "5        Cursos de Python"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 43
        }
      ]
    },
    {
      "metadata": {
        "id": "arVWfiGYwN9f",
        "colab_type": "code",
        "outputId": "2844fb46-2751-4eeb-ac89-5a8f122c0976",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas.head()"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_aluno</th>\n",
              "      <th>id_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>43</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>43</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   id_aluno  id_curso\n",
              "0       235        19\n",
              "1       235        19\n",
              "2        43         9\n",
              "3        43         1\n",
              "4        43        19"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "metadata": {
        "id": "XKgJ9vuXwQHI",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso = matriculas.groupby('id_curso').count().join(cursos['nome_do_curso']).rename(columns={'id_aluno':'quantidade_de_alunos'})"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "zhESGL3qwW65",
        "colab_type": "code",
        "outputId": "e0e638a8-d303-4a7e-e540-70f1e1468741",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso.head()"
      ],
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_curso</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>62</td>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>52</td>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>25</td>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>33</td>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>59</td>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          quantidade_de_alunos          nome_do_curso\n",
              "id_curso                                             \n",
              "1                           62  Lógica de programação\n",
              "2                           52          Java para Web\n",
              "3                           25            C# para Web\n",
              "4                           33          Ruby on Rails\n",
              "5                           59       Cursos de Python"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "metadata": {
        "id": "Spjf7ONM1DWt",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Saída em diferentes formatos"
      ]
    },
    {
      "metadata": {
        "id": "1doVYT7N0k5J",
        "colab_type": "code",
        "outputId": "1a4a9f1f-ad9a-4511-f40e-974f35d0f889",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 210
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso.head(3)"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_curso</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>62</td>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>52</td>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>25</td>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          quantidade_de_alunos          nome_do_curso\n",
              "id_curso                                             \n",
              "1                           62  Lógica de programação\n",
              "2                           52          Java para Web\n",
              "3                           25            C# para Web"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        }
      ]
    },
    {
      "metadata": {
        "id": "7CcVYSM71Jut",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso.to_csv('matriculas_por_curso.csv', index=False)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "Rc81odDa1XUI",
        "colab_type": "code",
        "outputId": "caf5eda6-5426-4495-9889-670ffcf7d3bf",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 910
        }
      },
      "cell_type": "code",
      "source": [
        "pd.read_csv('matriculas_por_curso.csv')"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>62</td>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>52</td>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>25</td>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>33</td>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>59</td>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>17</td>\n",
              "      <td>PHP com MySql</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>56</td>\n",
              "      <td>.NET para web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>37</td>\n",
              "      <td>Novas integrações com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>70</td>\n",
              "      <td>TDD com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>12</td>\n",
              "      <td>Código limpo com C#</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>81</td>\n",
              "      <td>Preparatório para certificação Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>22</td>\n",
              "      <td>Hardware básico</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>52</td>\n",
              "      <td>Persistência com .NET</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>31</td>\n",
              "      <td>Desenvolvendo jogos</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>82</td>\n",
              "      <td>Análise de dados</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>16</td>\n",
              "      <td>Estatística básica</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>44</td>\n",
              "      <td>Internet das coisas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>23</td>\n",
              "      <td>Programação funcional</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>67</td>\n",
              "      <td>Boas práticas em Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>18</td>\n",
              "      <td>Orientação objetos com Java</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    quantidade_de_alunos                        nome_do_curso\n",
              "0                     62                Lógica de programação\n",
              "1                     52                        Java para Web\n",
              "2                     25                          C# para Web\n",
              "3                     33                        Ruby on Rails\n",
              "4                     59                     Cursos de Python\n",
              "5                     17                        PHP com MySql\n",
              "6                     56                        .NET para web\n",
              "7                     37           Novas integrações com Java\n",
              "8                     70                         TDD com Java\n",
              "9                     12                  Código limpo com C#\n",
              "10                    81  Preparatório para certificação Java\n",
              "11                    22                      Hardware básico\n",
              "12                    52                Persistência com .NET\n",
              "13                    31                  Desenvolvendo jogos\n",
              "14                    82                     Análise de dados\n",
              "15                    16                   Estatística básica\n",
              "16                    44                  Internet das coisas\n",
              "17                    23                Programação funcional\n",
              "18                    67                Boas práticas em Java\n",
              "19                    18          Orientação objetos com Java"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "metadata": {
        "id": "N9AjsDmP1gBi",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "matriculas_json = matriculas_por_curso.to_json()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "5wENq92N1sY6",
        "colab_type": "code",
        "outputId": "d8179939-eb9a-42a0-8bac-0356e3f1b06c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "matriculas_json"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'{\"quantidade_de_alunos\":{\"1\":62,\"2\":52,\"3\":25,\"4\":33,\"5\":59,\"6\":17,\"7\":56,\"8\":37,\"9\":70,\"10\":12,\"11\":81,\"12\":22,\"13\":52,\"14\":31,\"15\":82,\"16\":16,\"17\":44,\"18\":23,\"19\":67,\"20\":18},\"nome_do_curso\":{\"1\":\"L\\\\u00f3gica de programa\\\\u00e7\\\\u00e3o\",\"2\":\"Java para Web\",\"3\":\"C# para Web\",\"4\":\"Ruby on Rails\",\"5\":\"Cursos de Python\",\"6\":\"PHP com MySql\",\"7\":\".NET para web\",\"8\":\"Novas integra\\\\u00e7\\\\u00f5es com Java\",\"9\":\"TDD com Java\",\"10\":\"C\\\\u00f3digo limpo com C#\",\"11\":\"Preparat\\\\u00f3rio para certifica\\\\u00e7\\\\u00e3o Java\",\"12\":\"Hardware b\\\\u00e1sico\",\"13\":\"Persist\\\\u00eancia com .NET\",\"14\":\"Desenvolvendo jogos\",\"15\":\"An\\\\u00e1lise de dados\",\"16\":\"Estat\\\\u00edstica b\\\\u00e1sica\",\"17\":\"Internet das coisas\",\"18\":\"Programa\\\\u00e7\\\\u00e3o funcional\",\"19\":\"Boas pr\\\\u00e1ticas em Java\",\"20\":\"Orienta\\\\u00e7\\\\u00e3o objetos com Java\"}}'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "metadata": {
        "id": "mWe30iDw1t4W",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "matriculas_html = matriculas_por_curso.to_html()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "klxkANa7146S",
        "colab_type": "code",
        "outputId": "b15e1ab6-5ee6-4a6e-ccc7-ab007251cbbf",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 2009
        }
      },
      "cell_type": "code",
      "source": [
        "print(matriculas_html)"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<table border=\"1\" class=\"dataframe\">\n",
            "  <thead>\n",
            "    <tr style=\"text-align: right;\">\n",
            "      <th></th>\n",
            "      <th>quantidade_de_alunos</th>\n",
            "      <th>nome_do_curso</th>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>id_curso</th>\n",
            "      <th></th>\n",
            "      <th></th>\n",
            "    </tr>\n",
            "  </thead>\n",
            "  <tbody>\n",
            "    <tr>\n",
            "      <th>1</th>\n",
            "      <td>62</td>\n",
            "      <td>Lógica de programação</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>2</th>\n",
            "      <td>52</td>\n",
            "      <td>Java para Web</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>3</th>\n",
            "      <td>25</td>\n",
            "      <td>C# para Web</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>4</th>\n",
            "      <td>33</td>\n",
            "      <td>Ruby on Rails</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>5</th>\n",
            "      <td>59</td>\n",
            "      <td>Cursos de Python</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>6</th>\n",
            "      <td>17</td>\n",
            "      <td>PHP com MySql</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>7</th>\n",
            "      <td>56</td>\n",
            "      <td>.NET para web</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>8</th>\n",
            "      <td>37</td>\n",
            "      <td>Novas integrações com Java</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>9</th>\n",
            "      <td>70</td>\n",
            "      <td>TDD com Java</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>10</th>\n",
            "      <td>12</td>\n",
            "      <td>Código limpo com C#</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>11</th>\n",
            "      <td>81</td>\n",
            "      <td>Preparatório para certificação Java</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>12</th>\n",
            "      <td>22</td>\n",
            "      <td>Hardware básico</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>13</th>\n",
            "      <td>52</td>\n",
            "      <td>Persistência com .NET</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>14</th>\n",
            "      <td>31</td>\n",
            "      <td>Desenvolvendo jogos</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>15</th>\n",
            "      <td>82</td>\n",
            "      <td>Análise de dados</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>16</th>\n",
            "      <td>16</td>\n",
            "      <td>Estatística básica</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>17</th>\n",
            "      <td>44</td>\n",
            "      <td>Internet das coisas</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>18</th>\n",
            "      <td>23</td>\n",
            "      <td>Programação funcional</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>19</th>\n",
            "      <td>67</td>\n",
            "      <td>Boas práticas em Java</td>\n",
            "    </tr>\n",
            "    <tr>\n",
            "      <th>20</th>\n",
            "      <td>18</td>\n",
            "      <td>Orientação objetos com Java</td>\n",
            "    </tr>\n",
            "  </tbody>\n",
            "</table>\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "zoj2fpiQFWg5",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Criando o banco sql"
      ]
    },
    {
      "metadata": {
        "id": "qJDPzfM_FJ_Y",
        "colab_type": "code",
        "outputId": "a2098f50-ecb8-49b8-a160-eb4ccd75eba2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "!pip install sqlalchemy"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: sqlalchemy in /usr/local/lib/python3.6/dist-packages (1.2.15)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "YZa4-Dl8FcJo",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sqlalchemy import create_engine, MetaData, Table"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "2ZlmNUfMFjjL",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "engine = create_engine('sqlite:///:memory:')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "cl9NuVLmF0j_",
        "colab_type": "code",
        "outputId": "74f8452f-bea8-40d9-9586-b61249d62c17",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "engine"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Engine(sqlite:///:memory:)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "metadata": {
        "id": "2N9Xeik4F1gd",
        "colab_type": "code",
        "outputId": "c2b9b89c-7c99-417e-bcd1-816187ee9d1e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "type(engine)"
      ],
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "sqlalchemy.engine.base.Engine"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "metadata": {
        "id": "sZZczNnwF4Uo",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso.to_sql('matriculas', engine)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "qz1m1seCF9yF",
        "colab_type": "code",
        "outputId": "f796910f-d2c7-4cd6-ca63-8bbd2c6024ef",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "cell_type": "code",
      "source": [
        "print(engine.table_names())"
      ],
      "execution_count": 60,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['matriculas']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "ORsf6fNLL3xM",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Buscando do banco sql"
      ]
    },
    {
      "metadata": {
        "id": "IhZj3K7yKogx",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "query = 'select * from matriculas where quantidade_de_alunos < 20'"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "dJYyz9fkMFWA",
        "colab_type": "code",
        "outputId": "53e7180d-1df3-426a-dc62-215db8cc8aa9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 261
        }
      },
      "cell_type": "code",
      "source": [
        "pd.read_sql(query, engine)"
      ],
      "execution_count": 62,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_curso</th>\n",
              "      <th>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>6</td>\n",
              "      <td>17</td>\n",
              "      <td>PHP com MySql</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10</td>\n",
              "      <td>12</td>\n",
              "      <td>Código limpo com C#</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>16</td>\n",
              "      <td>16</td>\n",
              "      <td>Estatística básica</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>20</td>\n",
              "      <td>18</td>\n",
              "      <td>Orientação objetos com Java</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   id_curso  quantidade_de_alunos                nome_do_curso\n",
              "0         6                    17                PHP com MySql\n",
              "1        10                    12          Código limpo com C#\n",
              "2        16                    16           Estatística básica\n",
              "3        20                    18  Orientação objetos com Java"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        }
      ]
    },
    {
      "metadata": {
        "id": "ZfDsvPWdMIfc",
        "colab_type": "code",
        "outputId": "3a24b108-fcad-44a3-bc39-684a2362eac4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 910
        }
      },
      "cell_type": "code",
      "source": [
        "pd.read_sql_table('matriculas', engine, columns=['nome_do_curso', 'quantidade_de_alunos'])"
      ],
      "execution_count": 63,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "      <th>quantidade_de_alunos</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Lógica de programação</td>\n",
              "      <td>62</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Java para Web</td>\n",
              "      <td>52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>C# para Web</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Ruby on Rails</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Cursos de Python</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>PHP com MySql</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>.NET para web</td>\n",
              "      <td>56</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Novas integrações com Java</td>\n",
              "      <td>37</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>TDD com Java</td>\n",
              "      <td>70</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Código limpo com C#</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Preparatório para certificação Java</td>\n",
              "      <td>81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Hardware básico</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Persistência com .NET</td>\n",
              "      <td>52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Desenvolvendo jogos</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Análise de dados</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Estatística básica</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Internet das coisas</td>\n",
              "      <td>44</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Programação funcional</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Boas práticas em Java</td>\n",
              "      <td>67</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Orientação objetos com Java</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                          nome_do_curso  quantidade_de_alunos\n",
              "0                 Lógica de programação                    62\n",
              "1                         Java para Web                    52\n",
              "2                           C# para Web                    25\n",
              "3                         Ruby on Rails                    33\n",
              "4                      Cursos de Python                    59\n",
              "5                         PHP com MySql                    17\n",
              "6                         .NET para web                    56\n",
              "7            Novas integrações com Java                    37\n",
              "8                          TDD com Java                    70\n",
              "9                   Código limpo com C#                    12\n",
              "10  Preparatório para certificação Java                    81\n",
              "11                      Hardware básico                    22\n",
              "12                Persistência com .NET                    52\n",
              "13                  Desenvolvendo jogos                    31\n",
              "14                     Análise de dados                    82\n",
              "15                   Estatística básica                    16\n",
              "16                  Internet das coisas                    44\n",
              "17                Programação funcional                    23\n",
              "18                Boas práticas em Java                    67\n",
              "19          Orientação objetos com Java                    18"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 63
        }
      ]
    },
    {
      "metadata": {
        "id": "aJluqE5OMiDz",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "muitas_matriculas = pd.read_sql_table('matriculas', engine, columns=['nome_do_curso', 'quantidade_de_alunos'])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "VsSTyTfxMxns",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "muitas_matriculas = muitas_matriculas.query('quantidade_de_alunos > 80')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "NjGASl-1My6K",
        "colab_type": "code",
        "outputId": "9324da11-ad01-4eed-ddcd-a6c9eb8ede5a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 148
        }
      },
      "cell_type": "code",
      "source": [
        "muitas_matriculas"
      ],
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome_do_curso</th>\n",
              "      <th>quantidade_de_alunos</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Preparatório para certificação Java</td>\n",
              "      <td>81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Análise de dados</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                          nome_do_curso  quantidade_de_alunos\n",
              "10  Preparatório para certificação Java                    81\n",
              "14                     Análise de dados                    82"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 66
        }
      ]
    },
    {
      "metadata": {
        "id": "0nV_HpGQNJbz",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Escrevendo no banco"
      ]
    },
    {
      "metadata": {
        "id": "p5KiuPVENFFT",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "muitas_matriculas.to_sql('muitas_matriculas', con=engine)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "D-KTIJSSNUh6",
        "colab_type": "code",
        "outputId": "893a7ee0-ddab-415a-9383-c34e43c232fb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "cell_type": "code",
      "source": [
        "print(engine.table_names())"
      ],
      "execution_count": 68,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['matriculas', 'muitas_matriculas']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "i5BKOMSvTz8M",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Nomes dos alunos e alunas da próxima turma"
      ]
    },
    {
      "metadata": {
        "id": "dBenvUUaThSV",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 693
        },
        "outputId": "60b19d18-ad46-4947-ba18-71a22a37f1ce"
      },
      "cell_type": "code",
      "source": [
        "matriculas_por_curso.head(20)"
      ],
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>quantidade_de_alunos</th>\n",
              "      <th>nome_do_curso</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_curso</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>62</td>\n",
              "      <td>Lógica de programação</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>52</td>\n",
              "      <td>Java para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>25</td>\n",
              "      <td>C# para Web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>33</td>\n",
              "      <td>Ruby on Rails</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>59</td>\n",
              "      <td>Cursos de Python</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>17</td>\n",
              "      <td>PHP com MySql</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>56</td>\n",
              "      <td>.NET para web</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>37</td>\n",
              "      <td>Novas integrações com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>70</td>\n",
              "      <td>TDD com Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>12</td>\n",
              "      <td>Código limpo com C#</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>81</td>\n",
              "      <td>Preparatório para certificação Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>22</td>\n",
              "      <td>Hardware básico</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>52</td>\n",
              "      <td>Persistência com .NET</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>31</td>\n",
              "      <td>Desenvolvendo jogos</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>82</td>\n",
              "      <td>Análise de dados</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>16</td>\n",
              "      <td>Estatística básica</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>44</td>\n",
              "      <td>Internet das coisas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>23</td>\n",
              "      <td>Programação funcional</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>67</td>\n",
              "      <td>Boas práticas em Java</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>18</td>\n",
              "      <td>Orientação objetos com Java</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          quantidade_de_alunos                        nome_do_curso\n",
              "id_curso                                                           \n",
              "1                           62                Lógica de programação\n",
              "2                           52                        Java para Web\n",
              "3                           25                          C# para Web\n",
              "4                           33                        Ruby on Rails\n",
              "5                           59                     Cursos de Python\n",
              "6                           17                        PHP com MySql\n",
              "7                           56                        .NET para web\n",
              "8                           37           Novas integrações com Java\n",
              "9                           70                         TDD com Java\n",
              "10                          12                  Código limpo com C#\n",
              "11                          81  Preparatório para certificação Java\n",
              "12                          22                      Hardware básico\n",
              "13                          52                Persistência com .NET\n",
              "14                          31                  Desenvolvendo jogos\n",
              "15                          82                     Análise de dados\n",
              "16                          16                   Estatística básica\n",
              "17                          44                  Internet das coisas\n",
              "18                          23                Programação funcional\n",
              "19                          67                Boas práticas em Java\n",
              "20                          18          Orientação objetos com Java"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 72
        }
      ]
    },
    {
      "metadata": {
        "id": "zddSy4DdT8hv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1949
        },
        "outputId": "878abbc7-f7df-470c-cf3d-502a6d00883c"
      },
      "cell_type": "code",
      "source": [
        "matriculas"
      ],
      "execution_count": 73,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_aluno</th>\n",
              "      <th>id_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>235</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>43</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>43</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>43</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>304</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>156</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>343</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>310</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>310</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>310</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>55</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>55</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>55</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>288</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>288</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>379</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>92</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>92</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>174</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>174</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>174</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>218</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>217</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>34</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>34</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>34</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>34</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>185</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>829</th>\n",
              "      <td>74</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>830</th>\n",
              "      <td>48</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>831</th>\n",
              "      <td>127</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>832</th>\n",
              "      <td>127</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>833</th>\n",
              "      <td>114</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>834</th>\n",
              "      <td>97</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>835</th>\n",
              "      <td>226</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>836</th>\n",
              "      <td>215</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>837</th>\n",
              "      <td>58</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>838</th>\n",
              "      <td>124</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>839</th>\n",
              "      <td>107</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>840</th>\n",
              "      <td>107</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>841</th>\n",
              "      <td>84</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>842</th>\n",
              "      <td>84</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>843</th>\n",
              "      <td>84</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>844</th>\n",
              "      <td>84</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>845</th>\n",
              "      <td>84</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>846</th>\n",
              "      <td>84</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>847</th>\n",
              "      <td>84</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>848</th>\n",
              "      <td>18</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>849</th>\n",
              "      <td>231</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>850</th>\n",
              "      <td>231</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>851</th>\n",
              "      <td>99</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>852</th>\n",
              "      <td>323</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>853</th>\n",
              "      <td>323</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>854</th>\n",
              "      <td>383</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>855</th>\n",
              "      <td>366</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>856</th>\n",
              "      <td>366</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>857</th>\n",
              "      <td>366</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>858</th>\n",
              "      <td>366</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>859 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     id_aluno  id_curso\n",
              "0         235        19\n",
              "1         235        19\n",
              "2          43         9\n",
              "3          43         1\n",
              "4          43        19\n",
              "5          43        14\n",
              "6         304        10\n",
              "7         156        12\n",
              "8         343         2\n",
              "9         310         3\n",
              "10        310        13\n",
              "11        310         1\n",
              "12         55        14\n",
              "13         55        19\n",
              "14         55        14\n",
              "15        288        11\n",
              "16        288        15\n",
              "17        379        15\n",
              "18         92        12\n",
              "19         92         4\n",
              "20        174         1\n",
              "21        174         9\n",
              "22        174         5\n",
              "23        218         5\n",
              "24        217        11\n",
              "25         34         8\n",
              "26         34        11\n",
              "27         34         5\n",
              "28         34        12\n",
              "29        185        13\n",
              "..        ...       ...\n",
              "829        74         5\n",
              "830        48        11\n",
              "831       127         5\n",
              "832       127        13\n",
              "833       114        11\n",
              "834        97        17\n",
              "835       226         4\n",
              "836       215        15\n",
              "837        58        18\n",
              "838       124         1\n",
              "839       107         9\n",
              "840       107         7\n",
              "841        84         1\n",
              "842        84        15\n",
              "843        84        18\n",
              "844        84        15\n",
              "845        84        15\n",
              "846        84         7\n",
              "847        84         5\n",
              "848        18        10\n",
              "849       231         2\n",
              "850       231        13\n",
              "851        99        12\n",
              "852       323        19\n",
              "853       323        19\n",
              "854       383        19\n",
              "855       366         2\n",
              "856       366        15\n",
              "857       366         6\n",
              "858       366        15\n",
              "\n",
              "[859 rows x 2 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 73
        }
      ]
    },
    {
      "metadata": {
        "id": "_MC4xCvwUMYu",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 539
        },
        "outputId": "65750a2e-9b9f-481d-b878-f93450300bd4"
      },
      "cell_type": "code",
      "source": [
        "id_curso = 16\n",
        "proxima_turma = matriculas.query(\"id_curso == {}\".format(id_curso))\n",
        "proxima_turma"
      ],
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_aluno</th>\n",
              "      <th>id_curso</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>259</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>155</th>\n",
              "      <td>151</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>176</th>\n",
              "      <td>179</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>178</th>\n",
              "      <td>179</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>334</th>\n",
              "      <td>368</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>354</th>\n",
              "      <td>202</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>389</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>424</th>\n",
              "      <td>319</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>720</th>\n",
              "      <td>184</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>742</th>\n",
              "      <td>378</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>747</th>\n",
              "      <td>147</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>748</th>\n",
              "      <td>206</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>779</th>\n",
              "      <td>214</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>787</th>\n",
              "      <td>359</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>792</th>\n",
              "      <td>362</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>804</th>\n",
              "      <td>398</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     id_aluno  id_curso\n",
              "95        259        16\n",
              "155       151        16\n",
              "176       179        16\n",
              "178       179        16\n",
              "334       368        16\n",
              "354       202        16\n",
              "416       389        16\n",
              "424       319        16\n",
              "720       184        16\n",
              "742       378        16\n",
              "747       147        16\n",
              "748       206        16\n",
              "779       214        16\n",
              "787       359        16\n",
              "792       362        16\n",
              "804       398        16"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "metadata": {
        "id": "aOHnrIbCUpaf",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 136
        },
        "outputId": "86148dad-189d-4227-b88e-acba4901cca5"
      },
      "cell_type": "code",
      "source": [
        "nomes.sample(3)"
      ],
      "execution_count": 75,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "      <th>id_aluno</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>188</th>\n",
              "      <td>POLIANA</td>\n",
              "      <td>369</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>poliana@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>AMANDA</td>\n",
              "      <td>217</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>amanda@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>185</th>\n",
              "      <td>SHEILA</td>\n",
              "      <td>116</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>sheila@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        nome  id_aluno                 dominio                         email  \\\n",
              "188  POLIANA       369     @servicodoemail.com    poliana@servicodoemail.com   \n",
              "12    AMANDA       217     @servicodoemail.com     amanda@servicodoemail.com   \n",
              "185   SHEILA       116  @dominiodoemail.com.br  sheila@dominiodoemail.com.br   \n",
              "\n",
              "     matriculas  \n",
              "188           2  \n",
              "12            1  \n",
              "185           1  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 75
        }
      ]
    },
    {
      "metadata": {
        "id": "Fi_Z7VCxU1vy",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 550
        },
        "outputId": "0b15530e-d084-4f40-b5d3-caccfcb2e7b9"
      },
      "cell_type": "code",
      "source": [
        "proxima_turma.set_index('id_aluno').join(nomes.set_index('id_aluno'))"
      ],
      "execution_count": 76,
      "outputs": [
        {
          "output_type": "execute_result",
          "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_curso</th>\n",
              "      <th>nome</th>\n",
              "      <th>dominio</th>\n",
              "      <th>email</th>\n",
              "      <th>matriculas</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_aluno</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>16</td>\n",
              "      <td>VINICIOS</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>vinicios@servicodoemail.com</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>16</td>\n",
              "      <td>TEREZA</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>tereza@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>16</td>\n",
              "      <td>TAIS</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>tais@dominiodoemail.com.br</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>16</td>\n",
              "      <td>TAIS</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>tais@dominiodoemail.com.br</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>16</td>\n",
              "      <td>JUNIOR</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>junior@dominiodoemail.com.br</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>202</th>\n",
              "      <td>16</td>\n",
              "      <td>ESTER</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>ester@servicodoemail.com</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>206</th>\n",
              "      <td>16</td>\n",
              "      <td>ITALO</td>\n",
              "      <td>@dominiodoemail.com.br</td>\n",
              "      <td>italo@dominiodoemail.com.br</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214</th>\n",
              "      <td>16</td>\n",
              "      <td>JAIME</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>jaime@servicodoemail.com</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259</th>\n",
              "      <td>16</td>\n",
              "      <td>RAIMUNDA</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>raimunda@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>319</th>\n",
              "      <td>16</td>\n",
              "      <td>INES</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>ines@servicodoemail.com</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>359</th>\n",
              "      <td>16</td>\n",
              "      <td>ARNALDO</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>arnaldo@servicodoemail.com</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>362</th>\n",
              "      <td>16</td>\n",
              "      <td>NIVALDO</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>nivaldo@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>368</th>\n",
              "      <td>16</td>\n",
              "      <td>CLEIDE</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>cleide@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>16</td>\n",
              "      <td>HUGO</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>hugo@servicodoemail.com</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>389</th>\n",
              "      <td>16</td>\n",
              "      <td>LIDIANE</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>lidiane@servicodoemail.com</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>398</th>\n",
              "      <td>16</td>\n",
              "      <td>CRISTIAN</td>\n",
              "      <td>@servicodoemail.com</td>\n",
              "      <td>cristian@servicodoemail.com</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          id_curso      nome                 dominio  \\\n",
              "id_aluno                                               \n",
              "147             16  VINICIOS     @servicodoemail.com   \n",
              "151             16    TEREZA     @servicodoemail.com   \n",
              "179             16      TAIS  @dominiodoemail.com.br   \n",
              "179             16      TAIS  @dominiodoemail.com.br   \n",
              "184             16    JUNIOR  @dominiodoemail.com.br   \n",
              "202             16     ESTER     @servicodoemail.com   \n",
              "206             16     ITALO  @dominiodoemail.com.br   \n",
              "214             16     JAIME     @servicodoemail.com   \n",
              "259             16  RAIMUNDA     @servicodoemail.com   \n",
              "319             16      INES     @servicodoemail.com   \n",
              "359             16   ARNALDO     @servicodoemail.com   \n",
              "362             16   NIVALDO     @servicodoemail.com   \n",
              "368             16    CLEIDE     @servicodoemail.com   \n",
              "378             16      HUGO     @servicodoemail.com   \n",
              "389             16   LIDIANE     @servicodoemail.com   \n",
              "398             16  CRISTIAN     @servicodoemail.com   \n",
              "\n",
              "                                 email  matriculas  \n",
              "id_aluno                                            \n",
              "147        vinicios@servicodoemail.com           3  \n",
              "151          tereza@servicodoemail.com           1  \n",
              "179         tais@dominiodoemail.com.br           4  \n",
              "179         tais@dominiodoemail.com.br           4  \n",
              "184       junior@dominiodoemail.com.br           3  \n",
              "202           ester@servicodoemail.com           8  \n",
              "206        italo@dominiodoemail.com.br           1  \n",
              "214           jaime@servicodoemail.com           5  \n",
              "259        raimunda@servicodoemail.com           1  \n",
              "319            ines@servicodoemail.com           4  \n",
              "359         arnaldo@servicodoemail.com           5  \n",
              "362         nivaldo@servicodoemail.com           2  \n",
              "368          cleide@servicodoemail.com           2  \n",
              "378            hugo@servicodoemail.com           1  \n",
              "389         lidiane@servicodoemail.com           2  \n",
              "398        cristian@servicodoemail.com           3  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 76
        }
      ]
    },
    {
      "metadata": {
        "id": "bFpfpMX9VEb1",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 319
        },
        "outputId": "3a388d88-7cb2-4a8b-a40f-57bae032064e"
      },
      "cell_type": "code",
      "source": [
        "proxima_turma.set_index('id_aluno').join(nomes.set_index('id_aluno'))['nome']"
      ],
      "execution_count": 77,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_aluno\n",
              "147    VINICIOS\n",
              "151      TEREZA\n",
              "179        TAIS\n",
              "179        TAIS\n",
              "184      JUNIOR\n",
              "202       ESTER\n",
              "206       ITALO\n",
              "214       JAIME\n",
              "259    RAIMUNDA\n",
              "319        INES\n",
              "359     ARNALDO\n",
              "362     NIVALDO\n",
              "368      CLEIDE\n",
              "378        HUGO\n",
              "389     LIDIANE\n",
              "398    CRISTIAN\n",
              "Name: nome, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 77
        }
      ]
    },
    {
      "metadata": {
        "id": "0-KJkD-JVRTv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 550
        },
        "outputId": "ba2327b0-1161-4fcb-fb9f-14899590cce5"
      },
      "cell_type": "code",
      "source": [
        "proxima_turma.set_index('id_aluno').join(nomes.set_index('id_aluno'))['nome'].to_frame()"
      ],
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_aluno</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>VINICIOS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>TEREZA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>TAIS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>TAIS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>JUNIOR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>202</th>\n",
              "      <td>ESTER</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>206</th>\n",
              "      <td>ITALO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214</th>\n",
              "      <td>JAIME</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259</th>\n",
              "      <td>RAIMUNDA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>319</th>\n",
              "      <td>INES</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>359</th>\n",
              "      <td>ARNALDO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>362</th>\n",
              "      <td>NIVALDO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>368</th>\n",
              "      <td>CLEIDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>HUGO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>389</th>\n",
              "      <td>LIDIANE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>398</th>\n",
              "      <td>CRISTIAN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              nome\n",
              "id_aluno          \n",
              "147       VINICIOS\n",
              "151         TEREZA\n",
              "179           TAIS\n",
              "179           TAIS\n",
              "184         JUNIOR\n",
              "202          ESTER\n",
              "206          ITALO\n",
              "214          JAIME\n",
              "259       RAIMUNDA\n",
              "319           INES\n",
              "359        ARNALDO\n",
              "362        NIVALDO\n",
              "368         CLEIDE\n",
              "378           HUGO\n",
              "389        LIDIANE\n",
              "398       CRISTIAN"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 78
        }
      ]
    },
    {
      "metadata": {
        "id": "FPnwtGHAVaMv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 50
        },
        "outputId": "fb05d175-a9f0-482f-d238-934055316e5f"
      },
      "cell_type": "code",
      "source": [
        "nome_curso = cursos.loc[id_curso]\n",
        "nome_curso"
      ],
      "execution_count": 79,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "nome_do_curso    Estatística básica\n",
              "Name: 16, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 79
        }
      ]
    },
    {
      "metadata": {
        "id": "z9TY65pnVxzw",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "c3d217e0-fe63-4641-d3e6-9116331f9ddf"
      },
      "cell_type": "code",
      "source": [
        "nome_curso = nome_curso.nome_do_curso\n",
        "nome_curso"
      ],
      "execution_count": 80,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Estatística básica'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 80
        }
      ]
    },
    {
      "metadata": {
        "id": "5HcHLhp0V6nV",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "proxima_turma = proxima_turma.set_index('id_aluno').join(nomes.set_index('id_aluno'))['nome'].to_frame()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "T67fpZphWHfN",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 576
        },
        "outputId": "2533ef36-9c40-4da5-e5dc-2fd445a37f9d"
      },
      "cell_type": "code",
      "source": [
        "proxima_turma"
      ],
      "execution_count": 82,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>nome</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_aluno</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>VINICIOS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>TEREZA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>TAIS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>TAIS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>JUNIOR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>202</th>\n",
              "      <td>ESTER</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>206</th>\n",
              "      <td>ITALO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214</th>\n",
              "      <td>JAIME</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259</th>\n",
              "      <td>RAIMUNDA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>319</th>\n",
              "      <td>INES</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>359</th>\n",
              "      <td>ARNALDO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>362</th>\n",
              "      <td>NIVALDO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>368</th>\n",
              "      <td>CLEIDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>HUGO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>389</th>\n",
              "      <td>LIDIANE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>398</th>\n",
              "      <td>CRISTIAN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              nome\n",
              "id_aluno          \n",
              "147       VINICIOS\n",
              "151         TEREZA\n",
              "179           TAIS\n",
              "179           TAIS\n",
              "184         JUNIOR\n",
              "202          ESTER\n",
              "206          ITALO\n",
              "214          JAIME\n",
              "259       RAIMUNDA\n",
              "319           INES\n",
              "359        ARNALDO\n",
              "362        NIVALDO\n",
              "368         CLEIDE\n",
              "378           HUGO\n",
              "389        LIDIANE\n",
              "398       CRISTIAN"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 82
        }
      ]
    },
    {
      "metadata": {
        "id": "4hgjmVgWWIlW",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "proxima_turma = proxima_turma.rename(columns = {'nome': 'Alunos do curso de {}'.format(nome_curso)})"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "W_rWJX__WbJG",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        },
        "outputId": "7024acfc-0204-447f-b013-9cd5e906f7e3"
      },
      "cell_type": "code",
      "source": [
        "proxima_turma.sample(5)"
      ],
      "execution_count": 86,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Alunos do curso de Estatística básica</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id_aluno</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>214</th>\n",
              "      <td>JAIME</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>TAIS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>JUNIOR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>319</th>\n",
              "      <td>INES</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>398</th>\n",
              "      <td>CRISTIAN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Alunos do curso de Estatística básica\n",
              "id_aluno                                      \n",
              "214                                      JAIME\n",
              "179                                       TAIS\n",
              "184                                     JUNIOR\n",
              "319                                       INES\n",
              "398                                   CRISTIAN"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 86
        }
      ]
    },
    {
      "metadata": {
        "id": "ZM1aq7P2Wh2X",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "–"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}