viva_real.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'pt_BR.UTF-8'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Importando bibliotecas\n",
    "import pandas as pd \n",
    "import numpy as np \n",
    "\n",
    "import requests\n",
    "from bs4 import BeautifulSoup as bs\n",
    "\n",
    "import locale\n",
    "locale.setlocale(locale.LC_ALL, 'pt_BR.UTF-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "URL = 'https://www.vivareal.com.br/venda/distrito-federal/brasilia/bairros/setor-sudoeste/apartamento_residencial/?pagina={}'\n",
    "i = 1\n",
    "retorno = requests.get(URL)\n",
    "soup = bs(retorno.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Verificando o tamanho de objetos carregados por página**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "36"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "objetos_pag = soup.find_all('article', {'class':'property-card__container js-property-card'})\n",
    "len(objetos_pag)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Obtendo o primeiro objeto e verificando os atributos que serão importante e a classe ao qual pertence**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<article class=\"property-card__container js-property-card\" data-see-phone=\"\"> <div class=\"property-card__main-info\"> <div class=\"property-card__main-link\"> <div class=\"property-card__carousel js-property-carousel\"> <a class=\"property-card__labels-container js-main-info js-listing-labels-link\" href=\"/imovel/apartamento-4-quartos-setor-sudoeste-bairros-brasilia-com-garagem-146m2-venda-RS2250000-id-2542005292/\"> <div class=\"property-card__inactive-listing\">Indisponível</div> <div class=\"property-card__already-seen\">Visualizado</div> </a> <div class=\"carousel__container js-carousel-scroll\" style=\"width: calc(5 * 100%);\"> <div class=\"carousel__item-wrapper js-carousel-item-wrapper\"> <img alt=\"Foto 1 de Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília\" class=\"carousel__image js-carousel-image\" src=\"https://resizedimgs.vivareal.com/crop/286x200/vr.images.sp/b53ff5454ff66192c2aeb0a879fa382c.jpg\" title=\"Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília - imagem 1\"/> </div> <div class=\"carousel__item-wrapper js-carousel-item-wrapper\"> <img alt=\"Foto 2 de Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília\" class=\"carousel__image js-carousel-image\" data-src=\"https://resizedimgs.vivareal.com/{action}/{width}x{height}/vr.images.sp/d617cf2af0d4a2907fba5e92f218c160.jpg\" src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/pixel.png\" title=\"Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília - imagem 2\"/> </div> <div class=\"carousel__item-wrapper js-carousel-item-wrapper\"> <img alt=\"Foto 3 de Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília\" class=\"carousel__image js-carousel-image\" data-src=\"https://resizedimgs.vivareal.com/{action}/{width}x{height}/vr.images.sp/d9d4079bab2021a3bae9c981793b3ae9.jpg\" src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/pixel.png\" title=\"Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília - imagem 3\"/> </div> <div class=\"carousel__item-wrapper js-carousel-item-wrapper\"> <img alt=\"Foto 4 de Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília\" class=\"carousel__image js-carousel-image\" data-src=\"https://resizedimgs.vivareal.com/{action}/{width}x{height}/vr.images.sp/c34e1c03845df75fff53da6a55794117.jpg\" src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/pixel.png\" title=\"Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília - imagem 4\"/> </div> <div class=\"carousel__item-wrapper js-carousel-item-wrapper\"> <img alt=\"Foto 5 de Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília\" class=\"carousel__image js-carousel-image\" data-src=\"https://resizedimgs.vivareal.com/{action}/{width}x{height}/vr.images.sp/d2a56f3866925732405339fe17a59e4e.jpg\" src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/pixel.png\" title=\"Apartamento com 4 Quartos à venda, 146m² em Setor Sudoeste, Brasília - imagem 5\"/> <div class=\"carousel__see-more\"> <span class=\"see-more__count\">+ 16 fotos</span> </div> </div> </div> <div class=\"carousel__navigation js-carousel-navigation\"> <div class=\"carousel__prev js-carousel-prev\"></div> <div class=\"carousel__next js-carousel-next\"></div> </div> <div class=\"carousel__navigation-bullets js-carousel-navigation-bullets\"> <div class=\"bullets__item js-bullets-item\" data-index=\"0\"></div> <div class=\"bullets__item js-bullets-item\" data-index=\"1\"></div> <div class=\"bullets__item js-bullets-item\" data-index=\"2\"></div> <div class=\"bullets__item js-bullets-item\" data-index=\"3\"></div> <div class=\"bullets__item js-bullets-item\" data-index=\"4\"></div> </div> </div> </div> </div> <a class=\"property-card__content-link js-card-title\" href=\"/imovel/apartamento-4-quartos-setor-sudoeste-bairros-brasilia-com-garagem-146m2-venda-RS2250000-id-2542005292/\"> <div class=\"property-card__content\"> <h2 class=\"property-card__header\"> <span class=\"property-card__title js-cardLink js-card-title\">  Apartamento com 4 Quartos à Venda, 146m²  </span> <span class=\"property-card__address-container js-property-card-address js-see-on-map\"> <span class=\"property-card__address\">SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasília - DF</span> <span class=\"property-card__map-link\"> ver mapa </span> </span> </h2> <ul class=\"property-card__details\"> <li class=\"property-card__detail-item property-card__detail-area\"> <span class=\"property-card__detail-value js-property-card-value property-card__detail-area js-property-card-detail-area\"> 146 </span> <span class=\"property-card__detail-text js-property-card-detail-text\"> m² </span> </li> <li class=\"property-card__detail-item property-card__detail-room js-property-detail-rooms\"> <span class=\"property-card__detail-value js-property-card-value\"> 4 </span> <span class=\"property-card__detail-text js-property-card-detail-text\"> Quartos </span> </li> <li class=\"property-card__detail-item property-card__detail-bathroom js-property-detail-bathroom\"> <span class=\"property-card__detail-value js-property-card-value\"> 5 </span> <span class=\"property-card__detail-text js-property-card-detail-text\"> Banheiros </span> </li> <li class=\"property-card__detail-item property-card__detail-garage js-property-detail-garages\"> <span class=\"property-card__detail-value js-property-card-value\"> 2 </span> <span class=\"property-card__detail-text js-property-card-detail-text\"> Vagas </span> </li> </ul> <ul class=\"property-card__amenities\"> <li class=\"amenities__item\" title=\"Piscina\">Piscina</li> <li class=\"amenities__item\" title=\"Churrasqueira\">Churrasqueira</li> <li class=\"amenities__item\" title=\"Elevador\">Elevador</li> <li class=\"amenities__item\" title=\"Academia\">Academia</li> <li class=\"amenities__item\" title=\"Aceita animais\">Aceita animais</li> <li class=\"amenities__item\">...</li> </ul> <section class=\"property-card__values\"> <div class=\"property-card__price js-property-card-prices js-property-card__price-small\"> <p style=\"display: block;\">  R$ 2.250.000  </p> </div> <footer class=\"property-card__price-details\"> <div class=\"property-card__price-details--condo\"> Condomínio: <strong class=\"js-condo-price\">  R$ 1.200  </strong> </div> </footer> </section> </div> </a> <div class=\"property-card__actions\"> <button class=\"property-card__button property-card__button--phone js-phone-lead\">Telefone</button> <button class=\"property-card__button property-card__button--message js-contact-lead\"> <span>Mensagem</span> </button> <button class=\"property-card__button property-card__button--whatsapp js-whatsapp-lead\">Whatsapp</button> </div> <picture class=\"property-card__account-link js-property-card-account-link\"> <img alt=\"ALFREDO MARTINS REIS\" class=\"lazyload\" data-src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/publisher-undefined.png\" src=\"https://cdn1.vivareal.com/p/1-eafaa5e/v/static/app/img/pixel.png\"/> </picture> </article>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "objeto = objetos_pag[0]\n",
    "objeto"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Colocando cada objeto dentro de uma variável**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "94.0\n",
      "Apartamento com 4 Quartos à Venda, 146m²\n",
      "SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasília - DF\n",
      "146\n",
      "4\n",
      "5\n",
      "2\n",
      "R$ 2.250.000\n",
      "R$ 1.200\n"
     ]
    }
   ],
   "source": [
    "qtd_imoveis = float(soup.find('strong', {'class':'results-summary__count js-total-records'}).text.replace('.',''))\n",
    "descricao = soup.find('span', {'class': 'property-card__title js-cardLink js-card-title'}).text.strip()\n",
    "endereco = soup.find('span', {'class': 'property-card__address'}).text.strip()\n",
    "metragem = int(soup.find('li', {'class': 'property-card__detail-item property-card__detail-area'}).span.text.strip())\n",
    "quartos = int(soup.find('li', {'class': 'property-card__detail-room'}).span.text.strip())\n",
    "banheiro = int(soup.find('li',{'class': 'property-card__detail-bathroom'}).span.text.strip())\n",
    "vagas = int(soup.find('li',{'class': 'property-card__detail-garage'}).span.text.strip())\n",
    "valor = soup.find(class_='property-card__price js-property-card-prices js-property-card__price-small').text.strip()\n",
    "condominio = soup.find('strong', {'class':'js-condo-price'}).text.strip()\n",
    "\n",
    "print(qtd_imoveis)\n",
    "print(descricao)\n",
    "print(endereco)\n",
    "print(metragem)\n",
    "print(quartos)\n",
    "print(banheiro)\n",
    "print(vagas)\n",
    "print(valor)\n",
    "print(condominio)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Criando Dataframe para organizar as variáveis encontradas. Deixei a quantidade de imóveis encontrados na pesquisa(64) fora do Dataframe**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(columns=[\n",
    "    'descricao',\n",
    "    'endereco',\n",
    "    'metragem',\n",
    "    'quartos',\n",
    "    'banheiro',\n",
    "    'vagas',\n",
    "    'valor',\n",
    "    'condominio',\n",
    "])\n",
    "\n",
    "i = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['descricao', 'endereco', 'metragem', 'quartos', 'banheiro', 'vagas',\n",
       "       'valor', 'condominio'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Laço de repetição para inserir os 64 objetos encontrados**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "valor i: 1 \t\t qtd_imoveis: 0\n",
      "valor i: 2 \t\t qtd_imoveis: 36\n",
      "valor i: 3 \t\t qtd_imoveis: 72\n"
     ]
    }
   ],
   "source": [
    "\n",
    "while qtd_imoveis > df.shape[0]:\n",
    "    \n",
    "    i += 1\n",
    "    print(f\"valor i: {i} \\t\\t qtd_imoveis: {df.shape[0]}\")\n",
    "    ret = requests.get(URL.format(i))\n",
    "    soup = bs(ret.text)\n",
    "\n",
    "    final = soup.find_all('article', {'class':'property-card__container js-property-card'})\n",
    "\n",
    "    for objeto in final:\n",
    "        try:\n",
    "            descricao = objeto.find('span', {'class': 'property-card__title js-cardLink js-card-title'}).text.strip()\n",
    "        except: \n",
    "            descricao = None\n",
    "        try:\n",
    "            endereco = objeto.find('span', {'class': 'property-card__address'}).text.strip()\n",
    "        except: \n",
    "            endereco = None\n",
    "        try:\n",
    "            metragem = int(objeto.find('li', {'class': 'property-card__detail-item property-card__detail-area'}).span.text.strip())\n",
    "        except:\n",
    "            metragem = None\n",
    "        try:\n",
    "            quartos = int(objeto.find('li', {'class': 'property-card__detail-room'}).span.text.strip())\n",
    "        except: \n",
    "            quartos = None\n",
    "        try: \n",
    "            banheiro = int(objeto.find('li',{'class': 'property-card__detail-bathroom'}).span.text.strip())\n",
    "        except:\n",
    "            banheiro = None\n",
    "        try:\n",
    "            vagas = int(objeto.find('li',{'class': 'property-card__detail-garage'}).span.text.strip())\n",
    "        except:\n",
    "            vagas = None\n",
    "        try:\n",
    "            valor = objeto.find(class_='property-card__price js-property-card-prices js-property-card__price-small').text.strip()\n",
    "        except:\n",
    "            valor = None\n",
    "        try:\n",
    "            condominio = objeto.find('strong', {'class':'js-condo-price'}).text.strip()\n",
    "        except:\n",
    "            condominio = None\n",
    "            \n",
    "        df.loc[df.shape[0]] = [\n",
    "            descricao,\n",
    "            endereco,\n",
    "            metragem,\n",
    "            quartos,\n",
    "            banheiro,\n",
    "            vagas,\n",
    "            valor,\n",
    "            condominio\n",
    "        ]      "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>descricao</th>\n",
       "      <th>endereco</th>\n",
       "      <th>metragem</th>\n",
       "      <th>quartos</th>\n",
       "      <th>banheiro</th>\n",
       "      <th>vagas</th>\n",
       "      <th>valor</th>\n",
       "      <th>condominio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 146m²</td>\n",
       "      <td>SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>146</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.250.000</td>\n",
       "      <td>R$ 1.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Haus by Novka</td>\n",
       "      <td>Parque Recreativo Sarah Kubitschek, - - Asa Su...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>Sob Consulta</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 100m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.350.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 86m²</td>\n",
       "      <td>SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>86</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.150.000</td>\n",
       "      <td>R$ 860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 24m²</td>\n",
       "      <td>QMSW 5, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 280.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>90</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.300.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>90</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.255.000</td>\n",
       "      <td>R$ 820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 102m²</td>\n",
       "      <td>SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.200.000</td>\n",
       "      <td>R$ 711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Parque das Figueiras</td>\n",
       "      <td>SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.558.560</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 89m²</td>\n",
       "      <td>SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>89</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.100.000</td>\n",
       "      <td>R$ 800.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 146m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.820.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 68m²</td>\n",
       "      <td>CCSW 3, 3 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 935.000</td>\n",
       "      <td>R$ 733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 87m²</td>\n",
       "      <td>SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>87</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.190.000</td>\n",
       "      <td>R$ 980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 144m²</td>\n",
       "      <td>SQSW 500, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>R$ 2.115.314</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 26m²</td>\n",
       "      <td>CCSW 1, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 510.000</td>\n",
       "      <td>R$ 410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Parque dos Cedros</td>\n",
       "      <td>SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...</td>\n",
       "      <td>165</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 2.681.463</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 95m²</td>\n",
       "      <td>SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>95</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.220.000</td>\n",
       "      <td>R$ 923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 65m²</td>\n",
       "      <td>SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.049.000</td>\n",
       "      <td>R$ 530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 145m²</td>\n",
       "      <td>SQSW 306 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>145</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.900.000</td>\n",
       "      <td>R$ 1.290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 36m²</td>\n",
       "      <td>QRSW 4, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>R$ 288.000</td>\n",
       "      <td>R$ 380</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   descricao  \\\n",
       "0   Apartamento com 4 Quartos à Venda, 146m²   \n",
       "1                              Haus by Novka   \n",
       "2   Apartamento com 3 Quartos à Venda, 100m²   \n",
       "3    Apartamento com 3 Quartos à Venda, 86m²   \n",
       "4      Apartamento com  Quarto à Venda, 24m²   \n",
       "5    Apartamento com 2 Quartos à Venda, 90m²   \n",
       "6    Apartamento com 3 Quartos à Venda, 90m²   \n",
       "7   Apartamento com 3 Quartos à Venda, 102m²   \n",
       "8                       Parque das Figueiras   \n",
       "9    Apartamento com 3 Quartos à Venda, 89m²   \n",
       "10  Apartamento com 3 Quartos à Venda, 146m²   \n",
       "11   Apartamento com 2 Quartos à Venda, 68m²   \n",
       "12   Apartamento com 3 Quartos à Venda, 87m²   \n",
       "13  Apartamento com 4 Quartos à Venda, 144m²   \n",
       "14     Apartamento com  Quarto à Venda, 26m²   \n",
       "15                         Parque dos Cedros   \n",
       "16   Apartamento com 3 Quartos à Venda, 95m²   \n",
       "17   Apartamento com 2 Quartos à Venda, 65m²   \n",
       "18  Apartamento com 3 Quartos à Venda, 145m²   \n",
       "19     Apartamento com  Quarto à Venda, 36m²   \n",
       "\n",
       "                                             endereco metragem quartos  \\\n",
       "0   SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...      146       4   \n",
       "1   Parque Recreativo Sarah Kubitschek, - - Asa Su...     None    None   \n",
       "2                       Setor Sudoeste, Brasília - DF      100       3   \n",
       "3    SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF       86       3   \n",
       "4           QMSW 5, 5 - Setor Sudoeste, Brasília - DF       24       1   \n",
       "5   SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...       90       2   \n",
       "6   SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...       90       3   \n",
       "7   SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...      102       3   \n",
       "8   SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...      102       3   \n",
       "9   SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...       89       3   \n",
       "10                      Setor Sudoeste, Brasília - DF      146       3   \n",
       "11          CCSW 3, 3 - Setor Sudoeste, Brasília - DF       68       2   \n",
       "12  SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...       87       3   \n",
       "13        SQSW 500, 5 - Setor Sudoeste, Brasília - DF      144       4   \n",
       "14          CCSW 1, 4 - Setor Sudoeste, Brasília - DF       26       1   \n",
       "15  SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...      165       4   \n",
       "16  SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...       95       3   \n",
       "17  SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...       65       2   \n",
       "18  SQSW 306 Bloco F, 01 - Setor Sudoeste, Brasíli...      145       3   \n",
       "19          QRSW 4, 4 - Setor Sudoeste, Brasília - DF       36       1   \n",
       "\n",
       "   banheiro vagas         valor  condominio  \n",
       "0         5     2  R$ 2.250.000    R$ 1.200  \n",
       "1      None     1  Sob Consulta        None  \n",
       "2         3     1  R$ 1.350.000        None  \n",
       "3         3     1  R$ 1.150.000      R$ 860  \n",
       "4         1     1    R$ 280.000        None  \n",
       "5         2     1  R$ 1.300.000        None  \n",
       "6         3     1  R$ 1.255.000      R$ 820  \n",
       "7         3     1  R$ 1.200.000      R$ 711  \n",
       "8         4     2  R$ 1.558.560        None  \n",
       "9         1     1  R$ 1.100.000  R$ 800.000  \n",
       "10        4     2  R$ 1.820.000        None  \n",
       "11        2     1    R$ 935.000      R$ 733  \n",
       "12        3     1  R$ 1.190.000      R$ 980  \n",
       "13        5     3  R$ 2.115.314        None  \n",
       "14        1     1    R$ 510.000      R$ 410  \n",
       "15        6     4  R$ 2.681.463        None  \n",
       "16        3     1  R$ 1.220.000      R$ 923  \n",
       "17        2     1  R$ 1.049.000      R$ 530  \n",
       "18        3     2  R$ 1.900.000    R$ 1.290  \n",
       "19        1  None    R$ 288.000      R$ 380  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Verificando as linhas nulas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>descricao</th>\n",
       "      <th>endereco</th>\n",
       "      <th>metragem</th>\n",
       "      <th>quartos</th>\n",
       "      <th>banheiro</th>\n",
       "      <th>vagas</th>\n",
       "      <th>valor</th>\n",
       "      <th>condominio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Haus by Novka</td>\n",
       "      <td>Parque Recreativo Sarah Kubitschek, - - Asa Su...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>Sob Consulta</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 100m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.350.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 24m²</td>\n",
       "      <td>QMSW 5, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 280.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>90</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.300.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Parque das Figueiras</td>\n",
       "      <td>SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.558.560</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 146m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.820.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 144m²</td>\n",
       "      <td>SQSW 500, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>R$ 2.115.314</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Parque dos Cedros</td>\n",
       "      <td>SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...</td>\n",
       "      <td>165</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 2.681.463</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 36m²</td>\n",
       "      <td>QRSW 4, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>R$ 288.000</td>\n",
       "      <td>R$ 380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 244m²</td>\n",
       "      <td>SQSW 500, 7 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>244</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 3.454.653</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 122m²</td>\n",
       "      <td>SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>122</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.550.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 63m²</td>\n",
       "      <td>CLSW 300A - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 555.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 77m²</td>\n",
       "      <td>SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.025.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 27m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 289.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 180m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>180</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.150.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Haus by Novka</td>\n",
       "      <td>Parque Recreativo Sarah Kubitschek, - - Asa Su...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>Sob Consulta</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 100m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.350.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 24m²</td>\n",
       "      <td>QMSW 5, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 280.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>90</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.300.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Parque das Figueiras</td>\n",
       "      <td>SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.558.560</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 146m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.820.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 144m²</td>\n",
       "      <td>SQSW 500, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>R$ 2.115.314</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Parque dos Cedros</td>\n",
       "      <td>SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...</td>\n",
       "      <td>165</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 2.681.463</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 36m²</td>\n",
       "      <td>QRSW 4, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>R$ 288.000</td>\n",
       "      <td>R$ 380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 244m²</td>\n",
       "      <td>SQSW 500, 7 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>244</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 3.454.653</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 122m²</td>\n",
       "      <td>SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>122</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.550.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 63m²</td>\n",
       "      <td>CLSW 300A - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 555.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 77m²</td>\n",
       "      <td>SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.025.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 27m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 289.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 180m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>180</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.150.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Haus by Novka</td>\n",
       "      <td>Parque Recreativo Sarah Kubitschek, - - Asa Su...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>Sob Consulta</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 100m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.350.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 24m²</td>\n",
       "      <td>QMSW 5, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 280.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>90</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.300.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Parque das Figueiras</td>\n",
       "      <td>SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.558.560</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 146m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.820.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 144m²</td>\n",
       "      <td>SQSW 500, 5 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>R$ 2.115.314</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Parque dos Cedros</td>\n",
       "      <td>SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...</td>\n",
       "      <td>165</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 2.681.463</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 36m²</td>\n",
       "      <td>QRSW 4, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>R$ 288.000</td>\n",
       "      <td>R$ 380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 244m²</td>\n",
       "      <td>SQSW 500, 7 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>244</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 3.454.653</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 122m²</td>\n",
       "      <td>SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>122</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.550.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 63m²</td>\n",
       "      <td>CLSW 300A - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 555.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 77m²</td>\n",
       "      <td>SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.025.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 27m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 289.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 180m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>180</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.150.000</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    descricao  \\\n",
       "1                               Haus by Novka   \n",
       "2    Apartamento com 3 Quartos à Venda, 100m²   \n",
       "4       Apartamento com  Quarto à Venda, 24m²   \n",
       "5     Apartamento com 2 Quartos à Venda, 90m²   \n",
       "8                        Parque das Figueiras   \n",
       "10   Apartamento com 3 Quartos à Venda, 146m²   \n",
       "13   Apartamento com 4 Quartos à Venda, 144m²   \n",
       "15                          Parque dos Cedros   \n",
       "19      Apartamento com  Quarto à Venda, 36m²   \n",
       "21   Apartamento com 4 Quartos à Venda, 244m²   \n",
       "25   Apartamento com 3 Quartos à Venda, 122m²   \n",
       "28      Apartamento com  Quarto à Venda, 63m²   \n",
       "29    Apartamento com 2 Quartos à Venda, 77m²   \n",
       "31      Apartamento com  Quarto à Venda, 27m²   \n",
       "32   Apartamento com 4 Quartos à Venda, 180m²   \n",
       "37                              Haus by Novka   \n",
       "38   Apartamento com 3 Quartos à Venda, 100m²   \n",
       "40      Apartamento com  Quarto à Venda, 24m²   \n",
       "41    Apartamento com 2 Quartos à Venda, 90m²   \n",
       "44                       Parque das Figueiras   \n",
       "46   Apartamento com 3 Quartos à Venda, 146m²   \n",
       "49   Apartamento com 4 Quartos à Venda, 144m²   \n",
       "51                          Parque dos Cedros   \n",
       "55      Apartamento com  Quarto à Venda, 36m²   \n",
       "57   Apartamento com 4 Quartos à Venda, 244m²   \n",
       "61   Apartamento com 3 Quartos à Venda, 122m²   \n",
       "64      Apartamento com  Quarto à Venda, 63m²   \n",
       "65    Apartamento com 2 Quartos à Venda, 77m²   \n",
       "67      Apartamento com  Quarto à Venda, 27m²   \n",
       "68   Apartamento com 4 Quartos à Venda, 180m²   \n",
       "73                              Haus by Novka   \n",
       "74   Apartamento com 3 Quartos à Venda, 100m²   \n",
       "76      Apartamento com  Quarto à Venda, 24m²   \n",
       "77    Apartamento com 2 Quartos à Venda, 90m²   \n",
       "80                       Parque das Figueiras   \n",
       "82   Apartamento com 3 Quartos à Venda, 146m²   \n",
       "85   Apartamento com 4 Quartos à Venda, 144m²   \n",
       "87                          Parque dos Cedros   \n",
       "91      Apartamento com  Quarto à Venda, 36m²   \n",
       "93   Apartamento com 4 Quartos à Venda, 244m²   \n",
       "97   Apartamento com 3 Quartos à Venda, 122m²   \n",
       "100     Apartamento com  Quarto à Venda, 63m²   \n",
       "101   Apartamento com 2 Quartos à Venda, 77m²   \n",
       "103     Apartamento com  Quarto à Venda, 27m²   \n",
       "104  Apartamento com 4 Quartos à Venda, 180m²   \n",
       "\n",
       "                                              endereco metragem quartos  \\\n",
       "1    Parque Recreativo Sarah Kubitschek, - - Asa Su...     None    None   \n",
       "2                        Setor Sudoeste, Brasília - DF      100       3   \n",
       "4            QMSW 5, 5 - Setor Sudoeste, Brasília - DF       24       1   \n",
       "5    SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...       90       2   \n",
       "8    SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...      102       3   \n",
       "10                       Setor Sudoeste, Brasília - DF      146       3   \n",
       "13         SQSW 500, 5 - Setor Sudoeste, Brasília - DF      144       4   \n",
       "15   SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...      165       4   \n",
       "19           QRSW 4, 4 - Setor Sudoeste, Brasília - DF       36       1   \n",
       "21         SQSW 500, 7 - Setor Sudoeste, Brasília - DF      244       4   \n",
       "25   SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...      122       3   \n",
       "28           CLSW 300A - Setor Sudoeste, Brasília - DF       63       1   \n",
       "29   SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...       77       2   \n",
       "31                       Setor Sudoeste, Brasília - DF       27       1   \n",
       "32                       Setor Sudoeste, Brasília - DF      180       4   \n",
       "37   Parque Recreativo Sarah Kubitschek, - - Asa Su...     None    None   \n",
       "38                       Setor Sudoeste, Brasília - DF      100       3   \n",
       "40           QMSW 5, 5 - Setor Sudoeste, Brasília - DF       24       1   \n",
       "41   SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...       90       2   \n",
       "44   SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...      102       3   \n",
       "46                       Setor Sudoeste, Brasília - DF      146       3   \n",
       "49         SQSW 500, 5 - Setor Sudoeste, Brasília - DF      144       4   \n",
       "51   SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...      165       4   \n",
       "55           QRSW 4, 4 - Setor Sudoeste, Brasília - DF       36       1   \n",
       "57         SQSW 500, 7 - Setor Sudoeste, Brasília - DF      244       4   \n",
       "61   SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...      122       3   \n",
       "64           CLSW 300A - Setor Sudoeste, Brasília - DF       63       1   \n",
       "65   SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...       77       2   \n",
       "67                       Setor Sudoeste, Brasília - DF       27       1   \n",
       "68                       Setor Sudoeste, Brasília - DF      180       4   \n",
       "73   Parque Recreativo Sarah Kubitschek, - - Asa Su...     None    None   \n",
       "74                       Setor Sudoeste, Brasília - DF      100       3   \n",
       "76           QMSW 5, 5 - Setor Sudoeste, Brasília - DF       24       1   \n",
       "77   SQSW 101 Bloco H, 101 - Setor Sudoeste, Brasíl...       90       2   \n",
       "80   SQNW 103 Bloco G, SQNW 103 - Setor Noroeste, B...      102       3   \n",
       "82                       Setor Sudoeste, Brasília - DF      146       3   \n",
       "85         SQSW 500, 5 - Setor Sudoeste, Brasília - DF      144       4   \n",
       "87   SQNW 306 Bloco A, s/n - Setor Noroeste, Brasíl...      165       4   \n",
       "91           QRSW 4, 4 - Setor Sudoeste, Brasília - DF       36       1   \n",
       "93         SQSW 500, 7 - Setor Sudoeste, Brasília - DF      244       4   \n",
       "97   SQSW 504 Bloco C, 0 - Setor Sudoeste, Brasília...      122       3   \n",
       "100          CLSW 300A - Setor Sudoeste, Brasília - DF       63       1   \n",
       "101  SQSW 104 Bloco G, 0 - Setor Sudoeste, Brasília...       77       2   \n",
       "103                      Setor Sudoeste, Brasília - DF       27       1   \n",
       "104                      Setor Sudoeste, Brasília - DF      180       4   \n",
       "\n",
       "    banheiro vagas         valor condominio  \n",
       "1       None     1  Sob Consulta       None  \n",
       "2          3     1  R$ 1.350.000       None  \n",
       "4          1     1    R$ 280.000       None  \n",
       "5          2     1  R$ 1.300.000       None  \n",
       "8          4     2  R$ 1.558.560       None  \n",
       "10         4     2  R$ 1.820.000       None  \n",
       "13         5     3  R$ 2.115.314       None  \n",
       "15         6     4  R$ 2.681.463       None  \n",
       "19         1  None    R$ 288.000     R$ 380  \n",
       "21         6     4  R$ 3.454.653       None  \n",
       "25         3     1  R$ 1.550.000       None  \n",
       "28         1     1    R$ 555.000       None  \n",
       "29         2     1  R$ 1.025.000       None  \n",
       "31         1     1    R$ 289.000       None  \n",
       "32         4     2  R$ 2.150.000       None  \n",
       "37      None     1  Sob Consulta       None  \n",
       "38         3     1  R$ 1.350.000       None  \n",
       "40         1     1    R$ 280.000       None  \n",
       "41         2     1  R$ 1.300.000       None  \n",
       "44         4     2  R$ 1.558.560       None  \n",
       "46         4     2  R$ 1.820.000       None  \n",
       "49         5     3  R$ 2.115.314       None  \n",
       "51         6     4  R$ 2.681.463       None  \n",
       "55         1  None    R$ 288.000     R$ 380  \n",
       "57         6     4  R$ 3.454.653       None  \n",
       "61         3     1  R$ 1.550.000       None  \n",
       "64         1     1    R$ 555.000       None  \n",
       "65         2     1  R$ 1.025.000       None  \n",
       "67         1     1    R$ 289.000       None  \n",
       "68         4     2  R$ 2.150.000       None  \n",
       "73      None     1  Sob Consulta       None  \n",
       "74         3     1  R$ 1.350.000       None  \n",
       "76         1     1    R$ 280.000       None  \n",
       "77         2     1  R$ 1.300.000       None  \n",
       "80         4     2  R$ 1.558.560       None  \n",
       "82         4     2  R$ 1.820.000       None  \n",
       "85         5     3  R$ 2.115.314       None  \n",
       "87         6     4  R$ 2.681.463       None  \n",
       "91         1  None    R$ 288.000     R$ 380  \n",
       "93         6     4  R$ 3.454.653       None  \n",
       "97         3     1  R$ 1.550.000       None  \n",
       "100        1     1    R$ 555.000       None  \n",
       "101        2     1  R$ 1.025.000       None  \n",
       "103        1     1    R$ 289.000       None  \n",
       "104        4     2  R$ 2.150.000       None  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.isnull().any(axis=1)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Filtrando as linhas nulas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([  1,   2,   4,   5,   8,  10,  13,  15,  19,  21,  25,  28,  29,\n",
       "             31,  32,  37,  38,  40,  41,  44,  46,  49,  51,  55,  57,  61,\n",
       "             64,  65,  67,  68,  73,  74,  76,  77,  80,  82,  85,  87,  91,\n",
       "             93,  97, 100, 101, 103, 104],\n",
       "           dtype='int64')"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtro = df[df.isnull().any(axis=1)].index\n",
    "filtro"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Apagando as linhas nulas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>descricao</th>\n",
       "      <th>endereco</th>\n",
       "      <th>metragem</th>\n",
       "      <th>quartos</th>\n",
       "      <th>banheiro</th>\n",
       "      <th>vagas</th>\n",
       "      <th>valor</th>\n",
       "      <th>condominio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 146m²</td>\n",
       "      <td>SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>146</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.250.000</td>\n",
       "      <td>R$ 1.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 86m²</td>\n",
       "      <td>SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>86</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.150.000</td>\n",
       "      <td>R$ 860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>90</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.255.000</td>\n",
       "      <td>R$ 820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 102m²</td>\n",
       "      <td>SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.200.000</td>\n",
       "      <td>R$ 711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 89m²</td>\n",
       "      <td>SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>89</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.100.000</td>\n",
       "      <td>R$ 800.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 68m²</td>\n",
       "      <td>CCSW 3, 3 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 935.000</td>\n",
       "      <td>R$ 733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 87m²</td>\n",
       "      <td>SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>87</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.190.000</td>\n",
       "      <td>R$ 980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 26m²</td>\n",
       "      <td>CCSW 1, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 510.000</td>\n",
       "      <td>R$ 410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 95m²</td>\n",
       "      <td>SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>95</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.220.000</td>\n",
       "      <td>R$ 923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 65m²</td>\n",
       "      <td>SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.049.000</td>\n",
       "      <td>R$ 530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 145m²</td>\n",
       "      <td>SQSW 306 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>145</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.900.000</td>\n",
       "      <td>R$ 1.290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 82m²</td>\n",
       "      <td>CCSW 4 Lote 5 Bloco B, 306 - Setor Sudoeste, B...</td>\n",
       "      <td>82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 1.050.000</td>\n",
       "      <td>R$ 733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 68m²</td>\n",
       "      <td>CCSW 3 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 950.000</td>\n",
       "      <td>R$ 730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 100m²</td>\n",
       "      <td>SQSW 306 Bloco B, 0 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.550.000</td>\n",
       "      <td>R$ 780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 87m²</td>\n",
       "      <td>SQSW 105 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>87</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 1.150.000</td>\n",
       "      <td>R$ 952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apartamento com 5 Quartos à Venda, 256m²</td>\n",
       "      <td>SQSW 102 Bloco B, 2 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>256</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 3.000.000</td>\n",
       "      <td>R$ 2.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 180m²</td>\n",
       "      <td>SQSW 300 Bloco L - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>180</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>R$ 2.550.000</td>\n",
       "      <td>R$ 1.430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 27m²</td>\n",
       "      <td>Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 425.000</td>\n",
       "      <td>R$ 400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 378m²</td>\n",
       "      <td>SQSW 101 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>378</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>R$ 3.200.000</td>\n",
       "      <td>R$ 3.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 36m²</td>\n",
       "      <td>QMSW 6, 010 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>R$ 360.000</td>\n",
       "      <td>R$ 420</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   descricao  \\\n",
       "0   Apartamento com 4 Quartos à Venda, 146m²   \n",
       "3    Apartamento com 3 Quartos à Venda, 86m²   \n",
       "6    Apartamento com 3 Quartos à Venda, 90m²   \n",
       "7   Apartamento com 3 Quartos à Venda, 102m²   \n",
       "9    Apartamento com 3 Quartos à Venda, 89m²   \n",
       "11   Apartamento com 2 Quartos à Venda, 68m²   \n",
       "12   Apartamento com 3 Quartos à Venda, 87m²   \n",
       "14     Apartamento com  Quarto à Venda, 26m²   \n",
       "16   Apartamento com 3 Quartos à Venda, 95m²   \n",
       "17   Apartamento com 2 Quartos à Venda, 65m²   \n",
       "18  Apartamento com 3 Quartos à Venda, 145m²   \n",
       "20   Apartamento com 2 Quartos à Venda, 82m²   \n",
       "22   Apartamento com 2 Quartos à Venda, 68m²   \n",
       "23  Apartamento com 3 Quartos à Venda, 100m²   \n",
       "24   Apartamento com 3 Quartos à Venda, 87m²   \n",
       "26  Apartamento com 5 Quartos à Venda, 256m²   \n",
       "27  Apartamento com 4 Quartos à Venda, 180m²   \n",
       "30     Apartamento com  Quarto à Venda, 27m²   \n",
       "33  Apartamento com 4 Quartos à Venda, 378m²   \n",
       "34     Apartamento com  Quarto à Venda, 36m²   \n",
       "\n",
       "                                             endereco metragem quartos  \\\n",
       "0   SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...      146       4   \n",
       "3    SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF       86       3   \n",
       "6   SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...       90       3   \n",
       "7   SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...      102       3   \n",
       "9   SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...       89       3   \n",
       "11          CCSW 3, 3 - Setor Sudoeste, Brasília - DF       68       2   \n",
       "12  SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...       87       3   \n",
       "14          CCSW 1, 4 - Setor Sudoeste, Brasília - DF       26       1   \n",
       "16  SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...       95       3   \n",
       "17  SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...       65       2   \n",
       "18  SQSW 306 Bloco F, 01 - Setor Sudoeste, Brasíli...      145       3   \n",
       "20  CCSW 4 Lote 5 Bloco B, 306 - Setor Sudoeste, B...       82       2   \n",
       "22             CCSW 3 - Setor Sudoeste, Brasília - DF       68       2   \n",
       "23  SQSW 306 Bloco B, 0 - Setor Sudoeste, Brasília...      100       3   \n",
       "24  SQSW 105 Bloco F, 01 - Setor Sudoeste, Brasíli...       87       3   \n",
       "26  SQSW 102 Bloco B, 2 - Setor Sudoeste, Brasília...      256       5   \n",
       "27   SQSW 300 Bloco L - Setor Sudoeste, Brasília - DF      180       4   \n",
       "30                      Setor Sudoeste, Brasília - DF       27       1   \n",
       "33           SQSW 101 - Setor Sudoeste, Brasília - DF      378       4   \n",
       "34        QMSW 6, 010 - Setor Sudoeste, Brasília - DF       36       1   \n",
       "\n",
       "   banheiro vagas         valor  condominio  \n",
       "0         5     2  R$ 2.250.000    R$ 1.200  \n",
       "3         3     1  R$ 1.150.000      R$ 860  \n",
       "6         3     1  R$ 1.255.000      R$ 820  \n",
       "7         3     1  R$ 1.200.000      R$ 711  \n",
       "9         1     1  R$ 1.100.000  R$ 800.000  \n",
       "11        2     1    R$ 935.000      R$ 733  \n",
       "12        3     1  R$ 1.190.000      R$ 980  \n",
       "14        1     1    R$ 510.000      R$ 410  \n",
       "16        3     1  R$ 1.220.000      R$ 923  \n",
       "17        2     1  R$ 1.049.000      R$ 530  \n",
       "18        3     2  R$ 1.900.000    R$ 1.290  \n",
       "20        1     2  R$ 1.050.000      R$ 733  \n",
       "22        2     1    R$ 950.000      R$ 730  \n",
       "23        3     1  R$ 1.550.000      R$ 780  \n",
       "24        3     1  R$ 1.150.000      R$ 952  \n",
       "26        3     2  R$ 3.000.000    R$ 2.500  \n",
       "27        4     2  R$ 2.550.000    R$ 1.430  \n",
       "30        1     1    R$ 425.000      R$ 400  \n",
       "33        3     4  R$ 3.200.000    R$ 3.400  \n",
       "34        1     1    R$ 360.000      R$ 420  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new = df.drop(filtro)\n",
    "df_new.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>descricao</th>\n",
       "      <th>endereco</th>\n",
       "      <th>metragem</th>\n",
       "      <th>quartos</th>\n",
       "      <th>banheiro</th>\n",
       "      <th>vagas</th>\n",
       "      <th>valor</th>\n",
       "      <th>condominio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [descricao, endereco, metragem, quartos, banheiro, vagas, valor, condominio]\n",
       "Index: []"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new.query(\"valor == 'Sob Consulta'\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### **Limpeza dos dados.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>descricao</th>\n",
       "      <th>endereco</th>\n",
       "      <th>metragem</th>\n",
       "      <th>quartos</th>\n",
       "      <th>banheiro</th>\n",
       "      <th>vagas</th>\n",
       "      <th>valor</th>\n",
       "      <th>condominio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apartamento com 4 Quartos à Venda, 146m²</td>\n",
       "      <td>SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>146</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>2.250.000</td>\n",
       "      <td>1.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 86m²</td>\n",
       "      <td>SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>86</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.150.000</td>\n",
       "      <td>860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 90m²</td>\n",
       "      <td>SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>90</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.255.000</td>\n",
       "      <td>820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 102m²</td>\n",
       "      <td>SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.200.000</td>\n",
       "      <td>711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 89m²</td>\n",
       "      <td>SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>89</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.100.000</td>\n",
       "      <td>800.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 68m²</td>\n",
       "      <td>CCSW 3, 3 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>935.000</td>\n",
       "      <td>733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 87m²</td>\n",
       "      <td>SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...</td>\n",
       "      <td>87</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.190.000</td>\n",
       "      <td>980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apartamento com  Quarto à Venda, 26m²</td>\n",
       "      <td>CCSW 1, 4 - Setor Sudoeste, Brasília - DF</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>510.000</td>\n",
       "      <td>410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apartamento com 3 Quartos à Venda, 95m²</td>\n",
       "      <td>SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...</td>\n",
       "      <td>95</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.220.000</td>\n",
       "      <td>923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apartamento com 2 Quartos à Venda, 65m²</td>\n",
       "      <td>SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.049.000</td>\n",
       "      <td>530</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   descricao  \\\n",
       "0   Apartamento com 4 Quartos à Venda, 146m²   \n",
       "3    Apartamento com 3 Quartos à Venda, 86m²   \n",
       "6    Apartamento com 3 Quartos à Venda, 90m²   \n",
       "7   Apartamento com 3 Quartos à Venda, 102m²   \n",
       "9    Apartamento com 3 Quartos à Venda, 89m²   \n",
       "11   Apartamento com 2 Quartos à Venda, 68m²   \n",
       "12   Apartamento com 3 Quartos à Venda, 87m²   \n",
       "14     Apartamento com  Quarto à Venda, 26m²   \n",
       "16   Apartamento com 3 Quartos à Venda, 95m²   \n",
       "17   Apartamento com 2 Quartos à Venda, 65m²   \n",
       "\n",
       "                                             endereco metragem quartos  \\\n",
       "0   SQSW 300 Bloco B, 506 - Setor Sudoeste, Brasíl...      146       4   \n",
       "3    SQSW 105 Bloco F - Setor Sudoeste, Brasília - DF       86       3   \n",
       "6   SQSW 100 Bloco D, 1 - Setor Sudoeste, Brasília...       90       3   \n",
       "7   SQSW 304 Bloco D, 304 - Setor Sudoeste, Brasíl...      102       3   \n",
       "9   SQSW 100 Bloco F, 603 - Setor Sudoeste, Brasíl...       89       3   \n",
       "11          CCSW 3, 3 - Setor Sudoeste, Brasília - DF       68       2   \n",
       "12  SQSW 301 Bloco E, 1 - Setor Sudoeste, Brasília...       87       3   \n",
       "14          CCSW 1, 4 - Setor Sudoeste, Brasília - DF       26       1   \n",
       "16  SQSW 305 Bloco F, 01 - Setor Sudoeste, Brasíli...       95       3   \n",
       "17  SQSW 104 Bloco G, 104 - Setor Sudoeste, Brasíl...       65       2   \n",
       "\n",
       "   banheiro vagas      valor condominio  \n",
       "0         5     2  2.250.000      1.200  \n",
       "3         3     1  1.150.000        860  \n",
       "6         3     1  1.255.000        820  \n",
       "7         3     1  1.200.000        711  \n",
       "9         1     1  1.100.000    800.000  \n",
       "11        2     1    935.000        733  \n",
       "12        3     1  1.190.000        980  \n",
       "14        1     1    510.000        410  \n",
       "16        3     1  1.220.000        923  \n",
       "17        2     1  1.049.000        530  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df_new['valor'] = df_new['valor'].apply(lambda x: x.replace('R$','').strip())\n",
    "df_new['condominio'] = df_new['condominio'].replace(np.nan, 'R$ 0.0')\n",
    "df_new['condominio'] = df_new['condominio'].apply(lambda x: x.replace('R$','').strip())\n",
    "\n",
    "\n",
    "\n",
    "df_new.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new.to_csv('imoveis.csv', sep=',', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "1352c9e1a801731cba60e5df049202f8bb14b275a550f79fca2507db53e2ee0e"
  },
  "kernelspec": {
   "display_name": "Python 3.8.5 64-bit ('scraper': virtualenv)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}