Relatório de Análise II.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"mount_file_id":"19VZ36UHew5bOwAiaRFzTYVn-jhsaikfh","authorship_tag":"ABX9TyNH201RiV18DLkG0fs+fydX"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["# **Relatório de Análise II**"],"metadata":{"id":"OtBbHu0m2udx"}},{"cell_type":"markdown","source":["Neste segundo relatório, nosso objetivo consiste em indentificar os tipos de imóveis distintos que estão na base de dados"],"metadata":{"id":"NFyAJDHU22Wr"}},{"cell_type":"markdown","source":["# **Explorando os Tipos de Imóveis**"],"metadata":{"id":"hYsNplfr4CZz"}},{"cell_type":"code","execution_count":1,"metadata":{"id":"ILO75S6ozZZ9","colab":{"base_uri":"https://localhost:8080/","height":261},"executionInfo":{"status":"ok","timestamp":1706643410116,"user_tz":180,"elapsed":1164,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"c0aa8c49-663d-4318-b60f-89ea25aaf667"},"outputs":[{"output_type":"execute_result","data":{"text/plain":["                      Tipo           Bairro  Quartos  Vagas  Suites  Area  \\\n","0                Quitinete       Copacabana        1      0       0    40   \n","1                     Casa  Jardim Botânico        2      0       1   100   \n","2  Conjunto Comercial/Sala  Barra da Tijuca        0      4       0   150   \n","3              Apartamento           Centro        1      0       0    15   \n","4              Apartamento     Higienópolis        1      0       0    48   \n","\n","    Valor  Condominio    IPTU  \n","0  1700.0       500.0    60.0  \n","1  7000.0         NaN     NaN  \n","2  5200.0      4020.0  1111.0  \n","3   800.0       390.0    20.0  \n","4   800.0       230.0     NaN  "],"text/html":["\n","  <div id=\"df-a0754467-f0db-4532-9184-767da61dbeee\" 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>Tipo</th>\n","      <th>Bairro</th>\n","      <th>Quartos</th>\n","      <th>Vagas</th>\n","      <th>Suites</th>\n","      <th>Area</th>\n","      <th>Valor</th>\n","      <th>Condominio</th>\n","      <th>IPTU</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Quitinete</td>\n","      <td>Copacabana</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>40</td>\n","      <td>1700.0</td>\n","      <td>500.0</td>\n","      <td>60.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Casa</td>\n","      <td>Jardim Botânico</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>100</td>\n","      <td>7000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Barra da Tijuca</td>\n","      <td>0</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>150</td>\n","      <td>5200.0</td>\n","      <td>4020.0</td>\n","      <td>1111.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apartamento</td>\n","      <td>Centro</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>15</td>\n","      <td>800.0</td>\n","      <td>390.0</td>\n","      <td>20.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Apartamento</td>\n","      <td>Higienópolis</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>48</td>\n","      <td>800.0</td>\n","      <td>230.0</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a0754467-f0db-4532-9184-767da61dbeee')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-a0754467-f0db-4532-9184-767da61dbeee 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-a0754467-f0db-4532-9184-767da61dbeee');\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","\n","\n","<div id=\"df-7489fb26-de46-4e4d-b51e-59724446813e\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7489fb26-de46-4e4d-b51e-59724446813e')\"\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","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-7489fb26-de46-4e4d-b51e-59724446813e button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":1}],"source":["# Importa o pandas com o apelido pd\n","import pandas as pd\n","\n","# Importa o módulo os\n","import os\n","\n","# Lê o arquivo com os dados dos imóveis\n","imoveis = pd.read_csv('/content/drive/MyDrive/Colab Notebooks/Analise de Dados/Análise de Dados de imóveis/aluguel.csv', sep=';')\n","\n","# Exibe as cinco primeiras linhas do DataFrame\n","imoveis.head()"]},{"cell_type":"code","source":["# Exibe uma série com os tipos de imóveis\n","imoveis['Tipo']"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"u7qRUgrz375k","executionInfo":{"status":"ok","timestamp":1706643576496,"user_tz":180,"elapsed":4,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"5bc928f5-dcb8-4049-ae7c-4212a1c37771"},"execution_count":2,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0                      Quitinete\n","1                           Casa\n","2        Conjunto Comercial/Sala\n","3                    Apartamento\n","4                    Apartamento\n","                  ...           \n","32955                  Quitinete\n","32956                Apartamento\n","32957                Apartamento\n","32958                Apartamento\n","32959    Conjunto Comercial/Sala\n","Name: Tipo, Length: 32960, dtype: object"]},"metadata":{},"execution_count":2}]},{"cell_type":"code","source":["# Armazena a série com os tipos de imóveis em uma variavel\n","tipos_de_imoveis = imoveis['Tipo']\n","\n","# Exibe o tipo da variável\n","type(tipos_de_imoveis)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"YH7TNTg44lN6","executionInfo":{"status":"ok","timestamp":1706643727051,"user_tz":180,"elapsed":5,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"6be2c59c-8961-4d20-a6bd-c64d08a99673"},"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["pandas.core.series.Series"]},"metadata":{},"execution_count":3}]},{"cell_type":"markdown","source":["Suponhamos que queremos saber quais os tipos distintos de imóveis nesta base de dados:"],"metadata":{"id":"-ku8d5dN5Vsj"}},{"cell_type":"code","source":["# Remove os valores duplicados da série, mantendo somente a primeira ocorrência\n","tipos_de_imoveis.drop_duplicates()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"BFxfdt7I5J31","executionInfo":{"status":"ok","timestamp":1706643944935,"user_tz":180,"elapsed":4,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"b0a60a47-396d-471e-f620-e20967e5ccf7"},"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0                          Quitinete\n","1                               Casa\n","2            Conjunto Comercial/Sala\n","3                        Apartamento\n","7                 Casa de Condomínio\n","16                    Prédio Inteiro\n","17                              Flat\n","29                        Loja/Salão\n","80           Galpão/Depósito/Armazém\n","83                    Casa Comercial\n","117                     Casa de Vila\n","159                   Terreno Padrão\n","207                      Box/Garagem\n","347                             Loft\n","589      Loja Shopping/ Ct Comercial\n","2157                         Chácara\n","3354           Loteamento/Condomínio\n","4379                           Sítio\n","4721                   Pousada/Chalé\n","6983                          Studio\n","9687                           Hotel\n","23614                      Indústria\n","Name: Tipo, dtype: object"]},"metadata":{},"execution_count":4}]},{"cell_type":"code","source":["# Remove os valores duplicados da série, mantendo somente a primeira ocorrência.\n","# Com o parâmetro 'inplace' definido com 'TRUE' modificaremos a série de forma permanente.\n","tipos_de_imoveis.drop_duplicates(inplace=True)\n","\n","# Exibe a série\n","tipos_de_imoveis"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"CGfv1nuM5_FA","executionInfo":{"status":"ok","timestamp":1706644191303,"user_tz":180,"elapsed":5,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"25d3a7ad-f4ec-4969-faa9-e0d8ec2f73fd"},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0                          Quitinete\n","1                               Casa\n","2            Conjunto Comercial/Sala\n","3                        Apartamento\n","7                 Casa de Condomínio\n","16                    Prédio Inteiro\n","17                              Flat\n","29                        Loja/Salão\n","80           Galpão/Depósito/Armazém\n","83                    Casa Comercial\n","117                     Casa de Vila\n","159                   Terreno Padrão\n","207                      Box/Garagem\n","347                             Loft\n","589      Loja Shopping/ Ct Comercial\n","2157                         Chácara\n","3354           Loteamento/Condomínio\n","4379                           Sítio\n","4721                   Pousada/Chalé\n","6983                          Studio\n","9687                           Hotel\n","23614                      Indústria\n","Name: Tipo, dtype: object"]},"metadata":{},"execution_count":5}]},{"cell_type":"code","source":["# Exibe os índices da série  na forma de um array.\n","# Estes índices são os índices dos registros na base de dados.\n","tipos_de_imoveis.index"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"ak4QAF5Y67QP","executionInfo":{"status":"ok","timestamp":1706644366743,"user_tz":180,"elapsed":4,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"84e8bcb4-67d8-4cbc-899b-869246e44cde"},"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Int64Index([    0,     1,     2,     3,     7,    16,    17,    29,    80,\n","               83,   117,   159,   207,   347,   589,  2157,  3354,  4379,\n","             4721,  6983,  9687, 23614],\n","           dtype='int64')"]},"metadata":{},"execution_count":6}]},{"cell_type":"markdown","source":["Agora vamos redefinir estes índices para que eles sejam uma sequência de numeros inteiros:"],"metadata":{"id":"5H2024-s7ve-"}},{"cell_type":"code","source":["# Exibe o número de registros da série 'tipos_de_imoveis'\n","len(tipos_de_imoveis)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"eX1aPvPi7mAm","executionInfo":{"status":"ok","timestamp":1706644520288,"user_tz":180,"elapsed":4,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"d7580928-2030-451d-c7a1-bef4a41e7338"},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["22"]},"metadata":{},"execution_count":7}]},{"cell_type":"code","source":["# Redefini o índice da série\n","tipos_de_imoveis.index = range(len(tipos_de_imoveis))\n","\n","# Exibe a série\n","tipos_de_imoveis"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"fV5QzE3y8Lhi","executionInfo":{"status":"ok","timestamp":1706644756663,"user_tz":180,"elapsed":4,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"7fc98162-183c-4180-ad57-c7ee19d37f32"},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0                       Quitinete\n","1                            Casa\n","2         Conjunto Comercial/Sala\n","3                     Apartamento\n","4              Casa de Condomínio\n","5                  Prédio Inteiro\n","6                            Flat\n","7                      Loja/Salão\n","8         Galpão/Depósito/Armazém\n","9                  Casa Comercial\n","10                   Casa de Vila\n","11                 Terreno Padrão\n","12                    Box/Garagem\n","13                           Loft\n","14    Loja Shopping/ Ct Comercial\n","15                        Chácara\n","16          Loteamento/Condomínio\n","17                          Sítio\n","18                  Pousada/Chalé\n","19                         Studio\n","20                          Hotel\n","21                      Indústria\n","Name: Tipo, dtype: object"]},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["# Transforma a série num dataframe\n","tipos_de_imoveis = tipos_de_imoveis.to_frame()\n","tipos_de_imoveis"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":739},"id":"hEZPdvDZ9FKX","executionInfo":{"status":"ok","timestamp":1706644863762,"user_tz":180,"elapsed":6,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"24d15c94-c425-4200-ccda-ca2767cb04e6"},"execution_count":9,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                           Tipo\n","0                     Quitinete\n","1                          Casa\n","2       Conjunto Comercial/Sala\n","3                   Apartamento\n","4            Casa de Condomínio\n","5                Prédio Inteiro\n","6                          Flat\n","7                    Loja/Salão\n","8       Galpão/Depósito/Armazém\n","9                Casa Comercial\n","10                 Casa de Vila\n","11               Terreno Padrão\n","12                  Box/Garagem\n","13                         Loft\n","14  Loja Shopping/ Ct Comercial\n","15                      Chácara\n","16        Loteamento/Condomínio\n","17                        Sítio\n","18                Pousada/Chalé\n","19                       Studio\n","20                        Hotel\n","21                    Indústria"],"text/html":["\n","  <div id=\"df-f7e10e11-00dd-4200-94fe-db1e044c7778\" 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>Tipo</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Quitinete</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Casa</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Conjunto Comercial/Sala</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apartamento</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Casa de Condomínio</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Prédio Inteiro</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Flat</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Loja/Salão</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Galpão/Depósito/Armazém</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Casa Comercial</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Casa de Vila</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>Terreno Padrão</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Box/Garagem</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>Loft</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>Loja Shopping/ Ct Comercial</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>Chácara</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>Loteamento/Condomínio</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>Sítio</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Pousada/Chalé</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Studio</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Hotel</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Indústria</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f7e10e11-00dd-4200-94fe-db1e044c7778')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-f7e10e11-00dd-4200-94fe-db1e044c7778 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-f7e10e11-00dd-4200-94fe-db1e044c7778');\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","\n","\n","<div id=\"df-53085249-519a-4541-90f8-b29aec8afe20\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-53085249-519a-4541-90f8-b29aec8afe20')\"\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","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-53085249-519a-4541-90f8-b29aec8afe20 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":9}]},{"cell_type":"code","source":["# Renomeia o índice do DataFrame\n","tipos_de_imoveis.index.name = 'ID'\n","\n","tipos_de_imoveis"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":771},"id":"bxJJjnrq9ffl","executionInfo":{"status":"ok","timestamp":1706644959974,"user_tz":180,"elapsed":6,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"8baccabd-fffd-408f-a9ab-f74ccdc768b9"},"execution_count":10,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                           Tipo\n","ID                             \n","0                     Quitinete\n","1                          Casa\n","2       Conjunto Comercial/Sala\n","3                   Apartamento\n","4            Casa de Condomínio\n","5                Prédio Inteiro\n","6                          Flat\n","7                    Loja/Salão\n","8       Galpão/Depósito/Armazém\n","9                Casa Comercial\n","10                 Casa de Vila\n","11               Terreno Padrão\n","12                  Box/Garagem\n","13                         Loft\n","14  Loja Shopping/ Ct Comercial\n","15                      Chácara\n","16        Loteamento/Condomínio\n","17                        Sítio\n","18                Pousada/Chalé\n","19                       Studio\n","20                        Hotel\n","21                    Indústria"],"text/html":["\n","  <div id=\"df-59ee0489-7f85-4040-ba0a-fa312ebd3d3d\" 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>Tipo</th>\n","    </tr>\n","    <tr>\n","      <th>ID</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Quitinete</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Casa</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Conjunto Comercial/Sala</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apartamento</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Casa de Condomínio</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Prédio Inteiro</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Flat</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Loja/Salão</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Galpão/Depósito/Armazém</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Casa Comercial</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Casa de Vila</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>Terreno Padrão</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Box/Garagem</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>Loft</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>Loja Shopping/ Ct Comercial</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>Chácara</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>Loteamento/Condomínio</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>Sítio</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Pousada/Chalé</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Studio</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Hotel</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Indústria</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-59ee0489-7f85-4040-ba0a-fa312ebd3d3d')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-59ee0489-7f85-4040-ba0a-fa312ebd3d3d 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-59ee0489-7f85-4040-ba0a-fa312ebd3d3d');\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","\n","\n","<div id=\"df-5bcaacba-4f45-44c3-9576-f1b6340ed46a\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-5bcaacba-4f45-44c3-9576-f1b6340ed46a')\"\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","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-5bcaacba-4f45-44c3-9576-f1b6340ed46a button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":10}]},{"cell_type":"code","source":[],"metadata":{"id":"-c6bB9w892-y"},"execution_count":null,"outputs":[]}]}