Relatório de Análise V.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"mount_file_id":"1KPhSGVczzTtcxKxqCJTuAKDGhAqZtFA1","authorship_tag":"ABX9TyO+VyxCndqVsmvClGfoW3ok"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["# **Relatório de Análise V**"],"metadata":{"id":"IgLYd4QrDkan"}},{"cell_type":"markdown","source":["Neste quinto relatório nosso objetivo consistirá em tratar os valores faltantes de nossa  base de dados."],"metadata":{"id":"glVv6yzzDwl1"}},{"cell_type":"markdown","source":["**Trantando Valores Faltantes**"],"metadata":{"id":"ZlHJJUvxFSdy"}},{"cell_type":"code","execution_count":1,"metadata":{"id":"ILO75S6ozZZ9","colab":{"base_uri":"https://localhost:8080/","height":206},"executionInfo":{"status":"ok","timestamp":1706819109470,"user_tz":180,"elapsed":913,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"09d4e5c6-3dac-45dd-c932-71295befb028"},"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-b68c7961-3037-432c-886e-63b2aa2bcc92\" 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-b68c7961-3037-432c-886e-63b2aa2bcc92')\"\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-b68c7961-3037-432c-886e-63b2aa2bcc92 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-b68c7961-3037-432c-886e-63b2aa2bcc92');\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-ccd04cf3-73cf-4a36-827d-3508fc41863d\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ccd04cf3-73cf-4a36-827d-3508fc41863d')\"\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-ccd04cf3-73cf-4a36-827d-3508fc41863d 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 CSV com os dados de imóveis do dataframe\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 cincos primeiras linhas do  dataframe\n","imoveis.head()"]},{"cell_type":"code","source":["# Cria uma série booleana\n","# Se o valor do aluguel estiver presente, retorna False\n","# Se o valor do aluguel não estiver presente, retorna True\n","imoveis['Valor'].isnull()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"9y1fE6rwGU92","executionInfo":{"status":"ok","timestamp":1706819117277,"user_tz":180,"elapsed":393,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"60d24ce1-fcc0-4217-ecbc-b892de3e488b"},"execution_count":2,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0        False\n","1        False\n","2        False\n","3        False\n","4        False\n","         ...  \n","32955    False\n","32956    False\n","32957    False\n","32958    False\n","32959    False\n","Name: Valor, Length: 32960, dtype: bool"]},"metadata":{},"execution_count":2}]},{"cell_type":"code","source":["# Obtém o número de imóveis sem o valor do aluguel\n","imoveis['Valor'].isnull().sum()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"GUeQkC79G9YD","executionInfo":{"status":"ok","timestamp":1706819123114,"user_tz":180,"elapsed":388,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"0b32adfa-a891-4d7e-d360-02697b8fd6e0"},"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["17"]},"metadata":{},"execution_count":3}]},{"cell_type":"code","source":["# Seleciona todas os registros em que  o valor do alguel está faltando\n","imoveis[imoveis['Valor'].isnull()]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":582},"id":"Dz6yb1MeHZcB","executionInfo":{"status":"ok","timestamp":1706819132898,"user_tz":180,"elapsed":405,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"8d9f02bb-624d-457b-c78b-a85091f5d3df"},"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                              Tipo                   Bairro  Quartos  Vagas  \\\n","76                     Apartamento          Barra da Tijuca        2      1   \n","2186                   Apartamento                     Leme        2      0   \n","2456                          Casa             Campo Grande        3      4   \n","2646                    Loja/Salão          Barra da Tijuca        0      2   \n","2941                   Apartamento                 Botafogo        2      0   \n","2973                   Apartamento               Copacabana        2      0   \n","6598                    Loja/Salão                  Andaraí        0      0   \n","7302                          Casa             Campo Grande        3      2   \n","12683                  Apartamento                     Leme        2      0   \n","13229                  Apartamento                   Glória        3      0   \n","13525                  Apartamento                    Gávea        3      1   \n","13579      Conjunto Comercial/Sala                 Botafogo        0      3   \n","20948      Conjunto Comercial/Sala  Freguesia (Jacarepaguá)        0      1   \n","21822  Loja Shopping/ Ct Comercial          Barra da Tijuca        0      2   \n","23056      Conjunto Comercial/Sala                 Botafogo        0      0   \n","24805      Conjunto Comercial/Sala                 Botafogo        0      0   \n","29166      Conjunto Comercial/Sala                 Botafogo        0      1   \n","\n","       Suites  Area  Valor  Condominio    IPTU  \n","76          1    70    NaN       970.0    68.0  \n","2186        0    75    NaN       878.0     NaN  \n","2456        3   363    NaN         NaN     NaN  \n","2646        0    80    NaN         NaN     NaN  \n","2941        0    95    NaN      1010.0   170.0  \n","2973        0    72    NaN       850.0     NaN  \n","6598        0   326    NaN         NaN  1140.0  \n","7302        1   100    NaN         NaN     NaN  \n","12683       1    75    NaN       878.0     NaN  \n","13229       1   135    NaN       910.0   228.0  \n","13525       1   105    NaN       880.0   221.0  \n","13579       0   200    NaN        10.0     NaN  \n","20948       0    24    NaN       500.0    74.0  \n","21822       0    77    NaN      3600.0  1390.0  \n","23056       0   900    NaN        10.0     NaN  \n","24805       0   500    NaN        10.0     NaN  \n","29166       0    50    NaN        10.0     NaN  "],"text/html":["\n","  <div id=\"df-bb51a5be-1f3b-4cec-81ea-e404635c1f4d\" 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>76</th>\n","      <td>Apartamento</td>\n","      <td>Barra da Tijuca</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>70</td>\n","      <td>NaN</td>\n","      <td>970.0</td>\n","      <td>68.0</td>\n","    </tr>\n","    <tr>\n","      <th>2186</th>\n","      <td>Apartamento</td>\n","      <td>Leme</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>75</td>\n","      <td>NaN</td>\n","      <td>878.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2456</th>\n","      <td>Casa</td>\n","      <td>Campo Grande</td>\n","      <td>3</td>\n","      <td>4</td>\n","      <td>3</td>\n","      <td>363</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2646</th>\n","      <td>Loja/Salão</td>\n","      <td>Barra da Tijuca</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>80</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2941</th>\n","      <td>Apartamento</td>\n","      <td>Botafogo</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>95</td>\n","      <td>NaN</td>\n","      <td>1010.0</td>\n","      <td>170.0</td>\n","    </tr>\n","    <tr>\n","      <th>2973</th>\n","      <td>Apartamento</td>\n","      <td>Copacabana</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>72</td>\n","      <td>NaN</td>\n","      <td>850.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>6598</th>\n","      <td>Loja/Salão</td>\n","      <td>Andaraí</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>326</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>1140.0</td>\n","    </tr>\n","    <tr>\n","      <th>7302</th>\n","      <td>Casa</td>\n","      <td>Campo Grande</td>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>100</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>12683</th>\n","      <td>Apartamento</td>\n","      <td>Leme</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>75</td>\n","      <td>NaN</td>\n","      <td>878.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>13229</th>\n","      <td>Apartamento</td>\n","      <td>Glória</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>135</td>\n","      <td>NaN</td>\n","      <td>910.0</td>\n","      <td>228.0</td>\n","    </tr>\n","    <tr>\n","      <th>13525</th>\n","      <td>Apartamento</td>\n","      <td>Gávea</td>\n","      <td>3</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>105</td>\n","      <td>NaN</td>\n","      <td>880.0</td>\n","      <td>221.0</td>\n","    </tr>\n","    <tr>\n","      <th>13579</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Botafogo</td>\n","      <td>0</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>200</td>\n","      <td>NaN</td>\n","      <td>10.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>20948</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Freguesia (Jacarepaguá)</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>24</td>\n","      <td>NaN</td>\n","      <td>500.0</td>\n","      <td>74.0</td>\n","    </tr>\n","    <tr>\n","      <th>21822</th>\n","      <td>Loja Shopping/ Ct Comercial</td>\n","      <td>Barra da Tijuca</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>77</td>\n","      <td>NaN</td>\n","      <td>3600.0</td>\n","      <td>1390.0</td>\n","    </tr>\n","    <tr>\n","      <th>23056</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Botafogo</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>900</td>\n","      <td>NaN</td>\n","      <td>10.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>24805</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Botafogo</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>500</td>\n","      <td>NaN</td>\n","      <td>10.0</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>29166</th>\n","      <td>Conjunto Comercial/Sala</td>\n","      <td>Botafogo</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>50</td>\n","      <td>NaN</td>\n","      <td>10.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-bb51a5be-1f3b-4cec-81ea-e404635c1f4d')\"\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-bb51a5be-1f3b-4cec-81ea-e404635c1f4d 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-bb51a5be-1f3b-4cec-81ea-e404635c1f4d');\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-00eb31cc-731d-4d91-9317-1176f36c9411\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-00eb31cc-731d-4d91-9317-1176f36c9411')\"\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-00eb31cc-731d-4d91-9317-1176f36c9411 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":4}]},{"cell_type":"code","source":["# Obtém um resumo do dataframe\n","imoveis['Valor'].isnull().sum()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"SS6J6aF9II4D","executionInfo":{"status":"ok","timestamp":1706819138440,"user_tz":180,"elapsed":402,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"51dd81be-6137-4ddf-ed90-93dd7352b0eb"},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["17"]},"metadata":{},"execution_count":5}]},{"cell_type":"markdown","source":["Com este resumo, notamos que a coluna de valor do aluguel possui 17 registros nulos."],"metadata":{"id":"7aYGQ2yFIeet"}},{"cell_type":"code","source":["# Armazena o número de linhas do dataframe\n","a = imoveis.shape[0]\n","\n","# Remove as linhas em que há valores nulos na coluna valor\n","imoveis.dropna(subset=['Valor'], inplace=True)\n","\n","# Armazena o número de linhas do dataframe após a remoção de registros nulos\n","b = imoveis.shape[0]\n","\n","# Exibe o número de linhas eliminadas\n","a - b"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"p6cPJlh9IY17","executionInfo":{"status":"ok","timestamp":1706819143874,"user_tz":180,"elapsed":378,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"3d32f4cd-73f8-4473-b991-f770674c75ac"},"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["17"]},"metadata":{},"execution_count":6}]},{"cell_type":"markdown","source":["Os imóveis classificados como 'Apartamento' devem obrigatóriamente possuir o valor de seu condomínio informado. Portanto, vamos remover todos os apartamentos em que o condomínio não foi informado:"],"metadata":{"id":"xfd92iuWL4B5"}},{"cell_type":"code","source":["# Filtro para selecionar os apartamentos com os valores de condomínio nulos\n","filtro = (imoveis['Tipo'] == 'Apartamento') & (imoveis['Condominio'].isnull())"],"metadata":{"id":"bxg9GRzrKQ7r","executionInfo":{"status":"ok","timestamp":1706819149626,"user_tz":180,"elapsed":384,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}}},"execution_count":7,"outputs":[]},{"cell_type":"code","source":["# Número de imóveis antes de eliminar regsitros\n","a = imoveis.shape[0]\n","\n","# seleciona todos os imóveis que não são do tipo apartamento ou os apartamentos que possuem valor de condomínio informado\n","imoveis = imoveis[~filtro]\n","\n","# Número de imoveis depois de eliminar registros\n","b = imoveis.shape[0]\n","\n","# Número de registros eliminados\n","a - b"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"sqNbBCGYM-K2","executionInfo":{"status":"ok","timestamp":1706819151714,"user_tz":180,"elapsed":393,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"79144c18-bf00-4b9b-d38a-4e315a5fafbf"},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["745"]},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["# Exibe o número de imóveis cujo condomínio é nulo\n","imoveis[imoveis['Condominio'].isnull()].shape[0]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"bhosX8nXOSx7","executionInfo":{"status":"ok","timestamp":1706819155611,"user_tz":180,"elapsed":376,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"4dffb000-5458-42b2-e8d9-86f168407192"},"execution_count":9,"outputs":[{"output_type":"execute_result","data":{"text/plain":["3344"]},"metadata":{},"execution_count":9}]},{"cell_type":"markdown","source":["Para estes imóveis com condomínio nulo, vamos atribuir o valor 0 já que de fato não possuem condomínio:"],"metadata":{"id":"3UVbVixcPC58"}},{"cell_type":"code","source":["imoveis = imoveis.fillna({'Condominio': 0, 'IPTU': 0})"],"metadata":{"id":"CStKQVdCOoi9","executionInfo":{"status":"ok","timestamp":1706819175311,"user_tz":180,"elapsed":380,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}}},"execution_count":10,"outputs":[]},{"cell_type":"code","source":["# imoveis['Condomini'].fillna(0, inplace = True)\n","# imoveis['IPTU'].fillna(0, inplace=True)"],"metadata":{"id":"CZ1sAbFnPspB","executionInfo":{"status":"ok","timestamp":1706819177337,"user_tz":180,"elapsed":388,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}}},"execution_count":11,"outputs":[]},{"cell_type":"code","source":["# Número de imóveis com condomínio nulo\n","imoveis[imoveis['Condominio'].isnull()].shape[0]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"keVK7--fQGT2","executionInfo":{"status":"ok","timestamp":1706819180144,"user_tz":180,"elapsed":383,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"349043c5-627d-474d-f04f-a7d914c67137"},"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0"]},"metadata":{},"execution_count":12}]},{"cell_type":"code","source":["# Número de imóveis com IPTU nulo\n","imoveis[imoveis['IPTU'].isnull()].shape[0]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"n_RtRT4SQbQh","executionInfo":{"status":"ok","timestamp":1706819185691,"user_tz":180,"elapsed":435,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"e5bdd8f4-e578-4a27-8652-9cf436f3a7a0"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0"]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["imoveis.info()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"lCUDGOk1TflK","executionInfo":{"status":"ok","timestamp":1706819188681,"user_tz":180,"elapsed":390,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}},"outputId":"a782a0c9-76d8-45fa-e2bf-a3fb1128c18f"},"execution_count":14,"outputs":[{"output_type":"stream","name":"stdout","text":["<class 'pandas.core.frame.DataFrame'>\n","Int64Index: 32198 entries, 0 to 32959\n","Data columns (total 9 columns):\n"," #   Column      Non-Null Count  Dtype  \n","---  ------      --------------  -----  \n"," 0   Tipo        32198 non-null  object \n"," 1   Bairro      32198 non-null  object \n"," 2   Quartos     32198 non-null  int64  \n"," 3   Vagas       32198 non-null  int64  \n"," 4   Suites      32198 non-null  int64  \n"," 5   Area        32198 non-null  int64  \n"," 6   Valor       32198 non-null  float64\n"," 7   Condominio  32198 non-null  float64\n"," 8   IPTU        32198 non-null  float64\n","dtypes: float64(3), int64(4), object(2)\n","memory usage: 2.5+ MB\n"]}]},{"cell_type":"code","source":["imoveis.to_csv('imoveis-resienciais.csv',sep=';', index=False)"],"metadata":{"id":"8i_G_UZsUHlP","executionInfo":{"status":"ok","timestamp":1706819199398,"user_tz":180,"elapsed":466,"user":{"displayName":"Ewerton Rodrigues","userId":"13325853325283936006"}}},"execution_count":15,"outputs":[]},{"cell_type":"code","source":[],"metadata":{"id":"_q9UhRpTUhps"},"execution_count":null,"outputs":[]}]}