{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Pandas_IO-1.3.ipynb","version":"0.3.2","provenance":[],"collapsed_sections":[]},"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":"90e2ca27-a2da-474b-9573-d5adb883d5aa","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1545836083824,"user_tz":120,"elapsed":379,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"cell_type":"code","source":["print(\"Quantidade de nomes: \" + str(len(nomes_f) + len(nomes_m)))"],"execution_count":25,"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":"7eb33fd7-47ae-4335-adab-a05ce522f05a","colab":{"base_uri":"https://localhost:8080/","height":2176},"executionInfo":{"status":"ok","timestamp":1545836086537,"user_tz":120,"elapsed":603,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"cell_type":"code","source":["frames"],"execution_count":27,"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":27}]},{"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":"60a1a8c1-5583-463a-8f5c-1b96593808bd","colab":{"base_uri":"https://localhost:8080/","height":164},"executionInfo":{"status":"error","timestamp":1545835964910,"user_tz":120,"elapsed":863,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"cell_type":"code","source":["nomes.sample(5)"],"execution_count":22,"outputs":[{"output_type":"error","ename":"AttributeError","evalue":"ignored","traceback":["\u001b[0;31m---------------------------------------------------------------------------\u001b[0m","\u001b[0;31mAttributeError\u001b[0m Traceback (most recent call last)","\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mnomes\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msample\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m5\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m","\u001b[0;31mAttributeError\u001b[0m: 'function' object has no attribute 'sample'"]}]},{"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":"d2957726-d47e-4230-df20-9982177b1e96","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1545835930192,"user_tz":120,"elapsed":3530,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"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":"3d02de7b-d85d-4a64-a167-1a1c7e15d409","colab":{"base_uri":"https://localhost:8080/","height":204},"executionInfo":{"status":"ok","timestamp":1545835930194,"user_tz":120,"elapsed":3523,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"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":"9a00440d-5a1c-472d-c3fb-12fe805fed67","colab":{"base_uri":"https://localhost:8080/","height":204},"executionInfo":{"status":"ok","timestamp":1545835930197,"user_tz":120,"elapsed":3516,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"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":"43a82979-d893-40b3-c7bb-6d24596adee2","colab":{"base_uri":"https://localhost:8080/","height":204},"executionInfo":{"status":"ok","timestamp":1545835930199,"user_tz":120,"elapsed":3503,"user":{"displayName":"Guilherme Lima","photoUrl":"https://lh4.googleusercontent.com/-1qJQ2pSryj8/AAAAAAAAAAI/AAAAAAAAAGY/EoCbvB8BzGI/s64/photo.jpg","userId":"07676051327792383707"}}},"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":"PYnQM1eH4PKS","colab_type":"code","colab":{}},"cell_type":"code","source":[""],"execution_count":0,"outputs":[]}]}