{ "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome
149CICERA
94SABRINA
112TATIANA
24FABIO
41CLAUDIO
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_aluno
188POLIANA369
57DAIANE303
3FRANCISCO382
182CHARLES33
30ANDERSON111
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominio
84SEVERINO78@dominiodoemail.com.br
0JOSE331@servicodoemail.com
179IAGO340@dominiodoemail.com.br
10SANDRA174@dominiodoemail.com.br
171TERESINHA45@dominiodoemail.com.br
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemail
114ARTHUR320@dominiodoemail.com.brarthur@dominiodoemail.com.br
57DAIANE303@servicodoemail.comdaiane@servicodoemail.com
85HELENA221@dominiodoemail.com.brhelena@dominiodoemail.com.br
183IRACI8@dominiodoemail.com.briraci@dominiodoemail.com.br
189DALVA137@dominiodoemail.com.brdalva@dominiodoemail.com.br
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Nome do curso
0Lógica de programação
1Java para Web
2C# para Web
3Ruby on Rails
4Cursos de Python
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_curso
0Lógica de programação
1Java para Web
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_cursoid
0Lógica de programação1
1Java para Web2
2C# para Web3
3Ruby on Rails4
4Cursos de Python5
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_curso
id
1Lógica de programação
2Java para Web
3C# para Web
4Ruby on Rails
5Cursos de Python
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemail
59ISABEL83@dominiodoemail.com.brisabel@dominiodoemail.com.br
172REBECA165@servicodoemail.comrebeca@servicodoemail.com
130JUNIOR184@dominiodoemail.com.brjunior@dominiodoemail.com.br
70JOAQUIM248@servicodoemail.comjoaquim@servicodoemail.com
171VALDEMIR3@dominiodoemail.com.brvaldemir@dominiodoemail.com.br
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemailmatriculas
133RUAN130@servicodoemail.comruan@servicodoemail.com1
44RAIMUNDA259@servicodoemail.comraimunda@servicodoemail.com1
50RAFAELA27@dominiodoemail.com.brrafaela@dominiodoemail.com.br1
45ADRIANO196@servicodoemail.comadriano@servicodoemail.com2
117PAMELA189@dominiodoemail.com.brpamela@dominiodoemail.com.br1
\n", "
" ], "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": [ "" ] }, "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": [ "" ] }, "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemailmatriculas
97BARBARA201@servicodoemail.combarbara@servicodoemail.com1
170ALEXANDRO341@servicodoemail.comalexandro@servicodoemail.com1
197MICHAEL323@dominiodoemail.com.brmichael@dominiodoemail.com.br2
196ARLINDO99@servicodoemail.comarlindo@servicodoemail.com1
138NEUSA75@dominiodoemail.com.brneusa@dominiodoemail.com.br2
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemailmatriculas
34CRISTIANE350@dominiodoemail.com.brcristiane@dominiodoemail.com.br1
154NICOLE182@dominiodoemail.com.brnicole@dominiodoemail.com.br2
191TERESA264@dominiodoemail.com.brteresa@dominiodoemail.com.br1
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_alunoid_curso
023519
123519
2439
3431
44319
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
id_curso
162Lógica de programação
252Java para Web
325C# para Web
433Ruby on Rails
559Cursos de Python
617PHP com MySql
756.NET para web
837Novas integrações com Java
970TDD com Java
1012Código limpo com C#
1181Preparatório para certificação Java
1222Hardware básico
1352Persistência com .NET
1431Desenvolvendo jogos
1582Análise de dados
1616Estatística básica
1744Internet das coisas
1823Programação funcional
1967Boas práticas em Java
2018Orientação objetos com Java
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemailmatriculas
167TAINARA128@servicodoemail.comtainara@servicodoemail.com2
141NEIDE325@dominiodoemail.com.brneide@dominiodoemail.com.br1
88GILMAR142@servicodoemail.comgilmar@servicodoemail.com1
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_curso
id
1Lógica de programação
2Java para Web
3C# para Web
4Ruby on Rails
5Cursos de Python
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_alunoid_curso
023519
123519
2439
3431
44319
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
id_curso
162Lógica de programação
252Java para Web
325C# para Web
433Ruby on Rails
559Cursos de Python
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
id_curso
162Lógica de programação
252Java para Web
325C# para Web
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
062Lógica de programação
152Java para Web
225C# para Web
333Ruby on Rails
459Cursos de Python
517PHP com MySql
656.NET para web
737Novas integrações com Java
870TDD com Java
912Código limpo com C#
1081Preparatório para certificação Java
1122Hardware básico
1252Persistência com .NET
1331Desenvolvendo jogos
1482Análise de dados
1516Estatística básica
1644Internet das coisas
1723Programação funcional
1867Boas práticas em Java
1918Orientação objetos com Java
\n", "
" ], "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": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
id_curso
162Lógica de programação
252Java para Web
325C# para Web
433Ruby on Rails
559Cursos de Python
617PHP com MySql
756.NET para web
837Novas integrações com Java
970TDD com Java
1012Código limpo com C#
1181Preparatório para certificação Java
1222Hardware básico
1352Persistência com .NET
1431Desenvolvendo jogos
1582Análise de dados
1616Estatística básica
1744Internet das coisas
1823Programação funcional
1967Boas práticas em Java
2018Orientação objetos com Java
\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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_cursoquantidade_de_alunosnome_do_curso
0617PHP com MySql
11012Código limpo com C#
21616Estatística básica
32018Orientação objetos com Java
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_cursoquantidade_de_alunos
0Lógica de programação62
1Java para Web52
2C# para Web25
3Ruby on Rails33
4Cursos de Python59
5PHP com MySql17
6.NET para web56
7Novas integrações com Java37
8TDD com Java70
9Código limpo com C#12
10Preparatório para certificação Java81
11Hardware básico22
12Persistência com .NET52
13Desenvolvendo jogos31
14Análise de dados82
15Estatística básica16
16Internet das coisas44
17Programação funcional23
18Boas práticas em Java67
19Orientação objetos com Java18
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome_do_cursoquantidade_de_alunos
10Preparatório para certificação Java81
14Análise de dados82
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
quantidade_de_alunosnome_do_curso
id_curso
162Lógica de programação
252Java para Web
325C# para Web
433Ruby on Rails
559Cursos de Python
617PHP com MySql
756.NET para web
837Novas integrações com Java
970TDD com Java
1012Código limpo com C#
1181Preparatório para certificação Java
1222Hardware básico
1352Persistência com .NET
1431Desenvolvendo jogos
1582Análise de dados
1616Estatística básica
1744Internet das coisas
1823Programação funcional
1967Boas práticas em Java
2018Orientação objetos com Java
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_alunoid_curso
023519
123519
2439
3431
44319
54314
630410
715612
83432
93103
1031013
113101
125514
135519
145514
1528811
1628815
1737915
189212
19924
201741
211749
221745
232185
2421711
25348
263411
27345
283412
2918513
.........
829745
8304811
8311275
83212713
83311411
8349717
8352264
83621515
8375818
8381241
8391079
8401077
841841
8428415
8438418
8448415
8458415
846847
847845
8481810
8492312
85023113
8519912
85232319
85332319
85438319
8553662
85636615
8573666
85836615
\n", "

859 rows × 2 columns

\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_alunoid_curso
9525916
15515116
17617916
17817916
33436816
35420216
41638916
42431916
72018416
74237816
74714716
74820616
77921416
78735916
79236216
80439816
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nomeid_alunodominioemailmatriculas
188POLIANA369@servicodoemail.compoliana@servicodoemail.com2
12AMANDA217@servicodoemail.comamanda@servicodoemail.com1
185SHEILA116@dominiodoemail.com.brsheila@dominiodoemail.com.br1
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
id_cursonomedominioemailmatriculas
id_aluno
14716VINICIOS@servicodoemail.comvinicios@servicodoemail.com3
15116TEREZA@servicodoemail.comtereza@servicodoemail.com1
17916TAIS@dominiodoemail.com.brtais@dominiodoemail.com.br4
17916TAIS@dominiodoemail.com.brtais@dominiodoemail.com.br4
18416JUNIOR@dominiodoemail.com.brjunior@dominiodoemail.com.br3
20216ESTER@servicodoemail.comester@servicodoemail.com8
20616ITALO@dominiodoemail.com.britalo@dominiodoemail.com.br1
21416JAIME@servicodoemail.comjaime@servicodoemail.com5
25916RAIMUNDA@servicodoemail.comraimunda@servicodoemail.com1
31916INES@servicodoemail.comines@servicodoemail.com4
35916ARNALDO@servicodoemail.comarnaldo@servicodoemail.com5
36216NIVALDO@servicodoemail.comnivaldo@servicodoemail.com2
36816CLEIDE@servicodoemail.comcleide@servicodoemail.com2
37816HUGO@servicodoemail.comhugo@servicodoemail.com1
38916LIDIANE@servicodoemail.comlidiane@servicodoemail.com2
39816CRISTIAN@servicodoemail.comcristian@servicodoemail.com3
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome
id_aluno
147VINICIOS
151TEREZA
179TAIS
179TAIS
184JUNIOR
202ESTER
206ITALO
214JAIME
259RAIMUNDA
319INES
359ARNALDO
362NIVALDO
368CLEIDE
378HUGO
389LIDIANE
398CRISTIAN
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nome
id_aluno
147VINICIOS
151TEREZA
179TAIS
179TAIS
184JUNIOR
202ESTER
206ITALO
214JAIME
259RAIMUNDA
319INES
359ARNALDO
362NIVALDO
368CLEIDE
378HUGO
389LIDIANE
398CRISTIAN
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Alunos do curso de Estatística básica
id_aluno
214JAIME
179TAIS
184JUNIOR
319INES
398CRISTIAN
\n", "
" ], "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": [] } ] }