-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathLeitura e manipulação de arquivos
1 lines (1 loc) · 84 KB
/
Leitura e manipulação de arquivos
1
{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyNYiE35GFhoPiqo4WvFplbE"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":10,"metadata":{"id":"LIjSQQjnqJKx","executionInfo":{"status":"ok","timestamp":1690414194245,"user_tz":180,"elapsed":3,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"outputs":[],"source":["import pandas as pd"]},{"cell_type":"code","source":["df = pd.read_excel('dados_v4.xlsx')\n","df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":519},"id":"50UxOMN4xAO6","executionInfo":{"status":"ok","timestamp":1690414386958,"user_tz":180,"elapsed":296,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"e077a719-ad4a-4c0f-d496-0ecda271e933"},"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 Isabella Silva 19 Feminino Cientista de dados\n","1 Felippe Dias 20 Masculino Engenheiro de software\n","2 Darla Moreira 26 Feminino Aeromoça\n","3 Joaquim Oliveira 76 Masculino Aposentado\n","4 Marcos Pinto 34 Masculino Agricultor\n","5 Joice Paiva 23 Feminino Arquiteta\n","6 Kaique Lima 40 Masculino Engenheiro Cívil \n","7 Márcia Maria 26 Feminino Advogada \n","8 Thais Espedita 29 Feminino Fisioterapeuta \n","9 Leandro Hilbergt 45 Masculino Bancário \n","10 Vera Pereira 56 Feminino Empresária\n","11 Agostinho Voigt 29 Masculino Advogado \n","12 Heitor Moreira 40 Masculino Jornalista\n","13 Thiago Ferreira 15 Masculino Farmaceutico \n","14 Nilva Meireles 38 Feminino Diretora "],"text/html":["\n","\n"," <div id=\"df-1594fdf9-d85a-467c-aadd-3c16244ee99c\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>Isabella</td>\n"," <td>Silva</td>\n"," <td>19</td>\n"," <td>Feminino</td>\n"," <td>Cientista de dados</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>Felippe</td>\n"," <td>Dias</td>\n"," <td>20</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro de software</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>Darla</td>\n"," <td>Moreira</td>\n"," <td>26</td>\n"," <td>Feminino</td>\n"," <td>Aeromoça</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>Joaquim</td>\n"," <td>Oliveira</td>\n"," <td>76</td>\n"," <td>Masculino</td>\n"," <td>Aposentado</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>Marcos</td>\n"," <td>Pinto</td>\n"," <td>34</td>\n"," <td>Masculino</td>\n"," <td>Agricultor</td>\n"," </tr>\n"," <tr>\n"," <th>5</th>\n"," <td>Joice</td>\n"," <td>Paiva</td>\n"," <td>23</td>\n"," <td>Feminino</td>\n"," <td>Arquiteta</td>\n"," </tr>\n"," <tr>\n"," <th>6</th>\n"," <td>Kaique</td>\n"," <td>Lima</td>\n"," <td>40</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro Cívil</td>\n"," </tr>\n"," <tr>\n"," <th>7</th>\n"," <td>Márcia</td>\n"," <td>Maria</td>\n"," <td>26</td>\n"," <td>Feminino</td>\n"," <td>Advogada</td>\n"," </tr>\n"," <tr>\n"," <th>8</th>\n"," <td>Thais</td>\n"," <td>Espedita</td>\n"," <td>29</td>\n"," <td>Feminino</td>\n"," <td>Fisioterapeuta</td>\n"," </tr>\n"," <tr>\n"," <th>9</th>\n"," <td>Leandro</td>\n"," <td>Hilbergt</td>\n"," <td>45</td>\n"," <td>Masculino</td>\n"," <td>Bancário</td>\n"," </tr>\n"," <tr>\n"," <th>10</th>\n"," <td>Vera</td>\n"," <td>Pereira</td>\n"," <td>56</td>\n"," <td>Feminino</td>\n"," <td>Empresária</td>\n"," </tr>\n"," <tr>\n"," <th>11</th>\n"," <td>Agostinho</td>\n"," <td>Voigt</td>\n"," <td>29</td>\n"," <td>Masculino</td>\n"," <td>Advogado</td>\n"," </tr>\n"," <tr>\n"," <th>12</th>\n"," <td>Heitor</td>\n"," <td>Moreira</td>\n"," <td>40</td>\n"," <td>Masculino</td>\n"," <td>Jornalista</td>\n"," </tr>\n"," <tr>\n"," <th>13</th>\n"," <td>Thiago</td>\n"," <td>Ferreira</td>\n"," <td>15</td>\n"," <td>Masculino</td>\n"," <td>Farmaceutico</td>\n"," </tr>\n"," <tr>\n"," <th>14</th>\n"," <td>Nilva</td>\n"," <td>Meireles</td>\n"," <td>38</td>\n"," <td>Feminino</td>\n"," <td>Diretora</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1594fdf9-d85a-467c-aadd-3c16244ee99c')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-bebd4053-141c-4cce-a73b-2ab51d7286dc\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bebd4053-141c-4cce-a73b-2ab51d7286dc')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-bebd4053-141c-4cce-a73b-2ab51d7286dc button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-1594fdf9-d85a-467c-aadd-3c16244ee99c button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-1594fdf9-d85a-467c-aadd-3c16244ee99c');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":12}]},{"cell_type":"code","source":["df.describe()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":300},"id":"ApDU3KEN6Xl4","executionInfo":{"status":"ok","timestamp":1690387264099,"user_tz":180,"elapsed":274,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"e192b2dd-d473-4220-d0f2-b4279a978540"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Idade\n","count 15.000000\n","mean 34.400000\n","std 15.891597\n","min 15.000000\n","25% 24.500000\n","50% 29.000000\n","75% 40.000000\n","max 76.000000"],"text/html":["\n","\n"," <div id=\"df-ce37d6f1-0ba9-4d2d-ae85-e98c678b2b7a\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Idade</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>count</th>\n"," <td>15.000000</td>\n"," </tr>\n"," <tr>\n"," <th>mean</th>\n"," <td>34.400000</td>\n"," </tr>\n"," <tr>\n"," <th>std</th>\n"," <td>15.891597</td>\n"," </tr>\n"," <tr>\n"," <th>min</th>\n"," <td>15.000000</td>\n"," </tr>\n"," <tr>\n"," <th>25%</th>\n"," <td>24.500000</td>\n"," </tr>\n"," <tr>\n"," <th>50%</th>\n"," <td>29.000000</td>\n"," </tr>\n"," <tr>\n"," <th>75%</th>\n"," <td>40.000000</td>\n"," </tr>\n"," <tr>\n"," <th>max</th>\n"," <td>76.000000</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ce37d6f1-0ba9-4d2d-ae85-e98c678b2b7a')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-f365c626-15f7-4140-9193-e674a0b883d1\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f365c626-15f7-4140-9193-e674a0b883d1')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-f365c626-15f7-4140-9193-e674a0b883d1 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-ce37d6f1-0ba9-4d2d-ae85-e98c678b2b7a button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-ce37d6f1-0ba9-4d2d-ae85-e98c678b2b7a');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":30}]},{"cell_type":"code","source":["df['Nome'].unique()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"7vHn2ueI6qGw","executionInfo":{"status":"ok","timestamp":1690387302916,"user_tz":180,"elapsed":4,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"1962f066-d5f7-4ab2-fce1-b10eb1a9a08f"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["array(['Isabella', 'Felippe', 'Darla', 'Joaquim', 'Marcos', 'Joice',\n"," 'Kaique', 'Márcia', 'Thais', 'Leandro', 'Vera', 'Agostinho',\n"," 'Heitor', 'Thiago', 'Nilva'], dtype=object)"]},"metadata":{},"execution_count":32}]},{"cell_type":"code","source":["df[(df['Sobrenome'] == 'Moreira')]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":112},"id":"AVhzbm-771cb","executionInfo":{"status":"ok","timestamp":1690387482369,"user_tz":180,"elapsed":294,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"1e2a507e-3639-4062-b44d-b53fae19d337"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","2 Darla Moreira 26 Feminino Aeromoça\n","12 Heitor Moreira 40 Masculino Jornalista"],"text/html":["\n","\n"," <div id=\"df-173e4add-a69e-4ca2-8036-2a3a22e087ac\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>2</th>\n"," <td>Darla</td>\n"," <td>Moreira</td>\n"," <td>26</td>\n"," <td>Feminino</td>\n"," <td>Aeromoça</td>\n"," </tr>\n"," <tr>\n"," <th>12</th>\n"," <td>Heitor</td>\n"," <td>Moreira</td>\n"," <td>40</td>\n"," <td>Masculino</td>\n"," <td>Jornalista</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-173e4add-a69e-4ca2-8036-2a3a22e087ac')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-6633a220-c886-4fb0-8240-2f31f977c546\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6633a220-c886-4fb0-8240-2f31f977c546')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-6633a220-c886-4fb0-8240-2f31f977c546 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-173e4add-a69e-4ca2-8036-2a3a22e087ac button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-173e4add-a69e-4ca2-8036-2a3a22e087ac');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":35}]},{"cell_type":"code","source":["df.columns"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"gKrFr9bt8h4n","executionInfo":{"status":"ok","timestamp":1690387567745,"user_tz":180,"elapsed":276,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"eeb915f5-95fb-4cf8-bb00-388c383e1324"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Index(['Nome', 'Sobrenome', 'Idade', 'Gênero', 'Ocupação'], dtype='object')"]},"metadata":{},"execution_count":39}]},{"cell_type":"code","source":["df.loc[6]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Uyli7aYS81xN","executionInfo":{"status":"ok","timestamp":1690387597625,"user_tz":180,"elapsed":283,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"6cffaead-1b38-48f6-ab0b-14f5cddac63e"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Nome Kaique\n","Sobrenome Lima\n","Idade 40\n","Gênero Masculino\n","Ocupação Engenheiro Cívil \n","Name: 6, dtype: object"]},"metadata":{},"execution_count":40}]},{"cell_type":"code","source":["df.head(n=2)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":112},"id":"MnDlVlLD-ZJw","executionInfo":{"status":"ok","timestamp":1690414391373,"user_tz":180,"elapsed":6,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"56840e02-4e7f-4a1d-8dab-f67dd7a22603"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 Isabella Silva 19 Feminino Cientista de dados\n","1 Felippe Dias 20 Masculino Engenheiro de software"],"text/html":["\n","\n"," <div id=\"df-bce9ff65-08e5-4346-a3e2-e853d86381bc\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>Isabella</td>\n"," <td>Silva</td>\n"," <td>19</td>\n"," <td>Feminino</td>\n"," <td>Cientista de dados</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>Felippe</td>\n"," <td>Dias</td>\n"," <td>20</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro de software</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bce9ff65-08e5-4346-a3e2-e853d86381bc')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-64977ea6-88e7-493a-9365-2cb91c0263fd\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-64977ea6-88e7-493a-9365-2cb91c0263fd')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-64977ea6-88e7-493a-9365-2cb91c0263fd button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-bce9ff65-08e5-4346-a3e2-e853d86381bc button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-bce9ff65-08e5-4346-a3e2-e853d86381bc');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["df.tail()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"2xQG-wgp-dgh","executionInfo":{"status":"ok","timestamp":1690388037257,"user_tz":180,"elapsed":311,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"b8e5227d-b32d-4e81-fd47-7264167dfc59"},"execution_count":43,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","10 Vera Pereira 56 Feminino Empresária\n","11 Agostinho Voigt 29 Masculino Advogado \n","12 Heitor Moreira 40 Masculino Jornalista\n","13 Thiago Ferreira 15 Masculino Farmaceutico \n","14 Nilva Meireles 38 Feminino Diretora "],"text/html":["\n","\n"," <div id=\"df-c66cfbd5-0e18-4cc6-8fd6-755cec934a1f\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>10</th>\n"," <td>Vera</td>\n"," <td>Pereira</td>\n"," <td>56</td>\n"," <td>Feminino</td>\n"," <td>Empresária</td>\n"," </tr>\n"," <tr>\n"," <th>11</th>\n"," <td>Agostinho</td>\n"," <td>Voigt</td>\n"," <td>29</td>\n"," <td>Masculino</td>\n"," <td>Advogado</td>\n"," </tr>\n"," <tr>\n"," <th>12</th>\n"," <td>Heitor</td>\n"," <td>Moreira</td>\n"," <td>40</td>\n"," <td>Masculino</td>\n"," <td>Jornalista</td>\n"," </tr>\n"," <tr>\n"," <th>13</th>\n"," <td>Thiago</td>\n"," <td>Ferreira</td>\n"," <td>15</td>\n"," <td>Masculino</td>\n"," <td>Farmaceutico</td>\n"," </tr>\n"," <tr>\n"," <th>14</th>\n"," <td>Nilva</td>\n"," <td>Meireles</td>\n"," <td>38</td>\n"," <td>Feminino</td>\n"," <td>Diretora</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c66cfbd5-0e18-4cc6-8fd6-755cec934a1f')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-bacd3ab3-75c4-4690-9445-a1c71275c864\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bacd3ab3-75c4-4690-9445-a1c71275c864')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-bacd3ab3-75c4-4690-9445-a1c71275c864 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-c66cfbd5-0e18-4cc6-8fd6-755cec934a1f button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-c66cfbd5-0e18-4cc6-8fd6-755cec934a1f');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":43}]},{"cell_type":"code","source":["df['Idade'].value_counts()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"kA_vW5X9-szl","executionInfo":{"status":"ok","timestamp":1690388067740,"user_tz":180,"elapsed":341,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"32e9180b-5c7e-4f00-9a9d-6d2e08c4c043"},"execution_count":44,"outputs":[{"output_type":"execute_result","data":{"text/plain":["26 2\n","40 2\n","29 2\n","19 1\n","20 1\n","76 1\n","34 1\n","23 1\n","45 1\n","56 1\n","15 1\n","38 1\n","Name: Idade, dtype: int64"]},"metadata":{},"execution_count":44}]},{"cell_type":"code","source":["df['Idade'].value_counts(normalize=True)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"FjrpStcV-2cl","executionInfo":{"status":"ok","timestamp":1690388105269,"user_tz":180,"elapsed":256,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"ee60603b-7343-4871-f014-175f5629409e"},"execution_count":45,"outputs":[{"output_type":"execute_result","data":{"text/plain":["26 0.133333\n","40 0.133333\n","29 0.133333\n","19 0.066667\n","20 0.066667\n","76 0.066667\n","34 0.066667\n","23 0.066667\n","45 0.066667\n","56 0.066667\n","15 0.066667\n","38 0.066667\n","Name: Idade, dtype: float64"]},"metadata":{},"execution_count":45}]},{"cell_type":"code","source":["df[\"Gênero\"].apply(lambda x: x[:4])"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"t5zlRK_J_1JN","executionInfo":{"status":"ok","timestamp":1690388381479,"user_tz":180,"elapsed":446,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"f0e1fea7-3cce-4cc6-8ff3-a4d7b2c192f3"},"execution_count":48,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0 Femi\n","1 Masc\n","2 Femi\n","3 Masc\n","4 Masc\n","5 Femi\n","6 Masc\n","7 Femi\n","8 Femi\n","9 Masc\n","10 Femi\n","11 Masc\n","12 Masc\n","13 Masc\n","14 Femi\n","Name: Gênero, dtype: object"]},"metadata":{},"execution_count":48}]},{"cell_type":"code","source":["df.isna()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":519},"id":"qh08srr_Xyyf","executionInfo":{"status":"ok","timestamp":1690394646077,"user_tz":180,"elapsed":1023,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"3b93fbf2-f5c2-4498-c5e0-4be225576213"},"execution_count":49,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 False False False False False\n","1 False False False False False\n","2 False False False False False\n","3 False False False False False\n","4 False False False False False\n","5 False False False False False\n","6 False False False False False\n","7 False False False False False\n","8 False False False False False\n","9 False False False False False\n","10 False False False False False\n","11 False False False False False\n","12 False False False False False\n","13 False False False False False\n","14 False False False False False"],"text/html":["\n","\n"," <div id=\"df-0ae7919a-2840-43de-a25e-9323bbbfc5c6\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>5</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>6</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>7</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>8</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>9</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>10</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>11</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>12</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>13</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>14</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0ae7919a-2840-43de-a25e-9323bbbfc5c6')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-cf17db0b-efe4-45bd-8949-24ce480231ca\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-cf17db0b-efe4-45bd-8949-24ce480231ca')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-cf17db0b-efe4-45bd-8949-24ce480231ca button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-0ae7919a-2840-43de-a25e-9323bbbfc5c6 button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-0ae7919a-2840-43de-a25e-9323bbbfc5c6');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":49}]},{"cell_type":"markdown","source":["#####Brincando a função de tratamento de dados incompletos com Pandas (np.nan)"],"metadata":{"id":"ChZIFVqMklel"}},{"cell_type":"code","source":["df2 = df.head()\n","df2 = df2.replace({\"Ocupação\" : {\"Aeromoça\": np.nan}})\n","df2"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"BKPhWXczjMWU","executionInfo":{"status":"ok","timestamp":1690414601165,"user_tz":180,"elapsed":276,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"271c4a2d-26cd-4be8-ded1-fed7c34f4eae"},"execution_count":16,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 Isabella Silva 19 Feminino Cientista de dados\n","1 Felippe Dias 20 Masculino Engenheiro de software\n","2 Darla Moreira 26 Feminino NaN\n","3 Joaquim Oliveira 76 Masculino Aposentado\n","4 Marcos Pinto 34 Masculino Agricultor"],"text/html":["\n","\n"," <div id=\"df-967f04f4-8b2a-4afe-960c-dea45a7fe0a2\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>Isabella</td>\n"," <td>Silva</td>\n"," <td>19</td>\n"," <td>Feminino</td>\n"," <td>Cientista de dados</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>Felippe</td>\n"," <td>Dias</td>\n"," <td>20</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro de software</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>Darla</td>\n"," <td>Moreira</td>\n"," <td>26</td>\n"," <td>Feminino</td>\n"," <td>NaN</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>Joaquim</td>\n"," <td>Oliveira</td>\n"," <td>76</td>\n"," <td>Masculino</td>\n"," <td>Aposentado</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>Marcos</td>\n"," <td>Pinto</td>\n"," <td>34</td>\n"," <td>Masculino</td>\n"," <td>Agricultor</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-967f04f4-8b2a-4afe-960c-dea45a7fe0a2')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-f32378a0-e1f1-428e-a335-0e5cabb66d9a\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f32378a0-e1f1-428e-a335-0e5cabb66d9a')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-f32378a0-e1f1-428e-a335-0e5cabb66d9a button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-967f04f4-8b2a-4afe-960c-dea45a7fe0a2 button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-967f04f4-8b2a-4afe-960c-dea45a7fe0a2');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","source":["df2.dropna()\n"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":175},"id":"ZpYno99JjYV0","executionInfo":{"status":"ok","timestamp":1690414650351,"user_tz":180,"elapsed":450,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"e1b7b26c-b2f0-4024-c1c5-2477a48bc681"},"execution_count":18,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 Isabella Silva 19 Feminino Cientista de dados\n","1 Felippe Dias 20 Masculino Engenheiro de software\n","3 Joaquim Oliveira 76 Masculino Aposentado\n","4 Marcos Pinto 34 Masculino Agricultor"],"text/html":["\n","\n"," <div id=\"df-1f75e83d-622c-4a24-8a79-dc2b12ecdf5a\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>Isabella</td>\n"," <td>Silva</td>\n"," <td>19</td>\n"," <td>Feminino</td>\n"," <td>Cientista de dados</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>Felippe</td>\n"," <td>Dias</td>\n"," <td>20</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro de software</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>Joaquim</td>\n"," <td>Oliveira</td>\n"," <td>76</td>\n"," <td>Masculino</td>\n"," <td>Aposentado</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>Marcos</td>\n"," <td>Pinto</td>\n"," <td>34</td>\n"," <td>Masculino</td>\n"," <td>Agricultor</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1f75e83d-622c-4a24-8a79-dc2b12ecdf5a')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-66cf2148-8cd1-425e-b22b-d54676b9a738\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-66cf2148-8cd1-425e-b22b-d54676b9a738')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-66cf2148-8cd1-425e-b22b-d54676b9a738 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-1f75e83d-622c-4a24-8a79-dc2b12ecdf5a button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-1f75e83d-622c-4a24-8a79-dc2b12ecdf5a');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":18}]},{"cell_type":"code","source":["df2.fillna(\"Cozinheira\")"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"aw4fEWuhkTBv","executionInfo":{"status":"ok","timestamp":1690414712414,"user_tz":180,"elapsed":391,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"1efac721-54e8-483e-a220-4a6c84fce0df"},"execution_count":19,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 Isabella Silva 19 Feminino Cientista de dados\n","1 Felippe Dias 20 Masculino Engenheiro de software\n","2 Darla Moreira 26 Feminino Cozinheira\n","3 Joaquim Oliveira 76 Masculino Aposentado\n","4 Marcos Pinto 34 Masculino Agricultor"],"text/html":["\n","\n"," <div id=\"df-80eb43be-a651-44e0-92ea-fa551e3422b6\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>Isabella</td>\n"," <td>Silva</td>\n"," <td>19</td>\n"," <td>Feminino</td>\n"," <td>Cientista de dados</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>Felippe</td>\n"," <td>Dias</td>\n"," <td>20</td>\n"," <td>Masculino</td>\n"," <td>Engenheiro de software</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>Darla</td>\n"," <td>Moreira</td>\n"," <td>26</td>\n"," <td>Feminino</td>\n"," <td>Cozinheira</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>Joaquim</td>\n"," <td>Oliveira</td>\n"," <td>76</td>\n"," <td>Masculino</td>\n"," <td>Aposentado</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>Marcos</td>\n"," <td>Pinto</td>\n"," <td>34</td>\n"," <td>Masculino</td>\n"," <td>Agricultor</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-80eb43be-a651-44e0-92ea-fa551e3422b6')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-d16fd6fb-78dc-4439-a540-15b2d33139a2\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d16fd6fb-78dc-4439-a540-15b2d33139a2')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-d16fd6fb-78dc-4439-a540-15b2d33139a2 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-80eb43be-a651-44e0-92ea-fa551e3422b6 button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-80eb43be-a651-44e0-92ea-fa551e3422b6');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":19}]},{"cell_type":"code","source":["df2.isna()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"plITwYRLkZuU","executionInfo":{"status":"ok","timestamp":1690414751032,"user_tz":180,"elapsed":8,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"edf67628-2214-428b-e4bd-f3fd1ddc0bdc"},"execution_count":20,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Nome Sobrenome Idade Gênero Ocupação\n","0 False False False False False\n","1 False False False False False\n","2 False False False False True\n","3 False False False False False\n","4 False False False False False"],"text/html":["\n","\n"," <div id=\"df-99a951cf-30ba-4c3d-bd02-7d0d45478f63\">\n"," <div class=\"colab-df-container\">\n"," <div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>Nome</th>\n"," <th>Sobrenome</th>\n"," <th>Idade</th>\n"," <th>Gênero</th>\n"," <th>Ocupação</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>True</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," <td>False</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-99a951cf-30ba-4c3d-bd02-7d0d45478f63')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n"," <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n"," </svg>\n"," </button>\n","\n","\n","\n"," <div id=\"df-b88ea52f-490d-4f6c-9b06-ebd98daf4159\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b88ea52f-490d-4f6c-9b06-ebd98daf4159')\"\n"," title=\"Suggest charts.\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n"," </div>\n","\n","<style>\n"," .colab-df-quickchart {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const containerElement = document.querySelector('#' + key);\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," }\n"," </script>\n","\n"," <script>\n","\n","function displayQuickchartButton(domScope) {\n"," let quickchartButtonEl =\n"," domScope.querySelector('#df-b88ea52f-490d-4f6c-9b06-ebd98daf4159 button.colab-df-quickchart');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n"," displayQuickchartButton(document);\n"," </script>\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," flex-wrap:wrap;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-99a951cf-30ba-4c3d-bd02-7d0d45478f63 button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-99a951cf-30ba-4c3d-bd02-7d0d45478f63');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n"," </div>\n"]},"metadata":{},"execution_count":20}]}]}