rightmove_class.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### New version refactored into class object\n",
    "*** WORK IN PROGRESS ***\n",
    "#### TO DO\n",
    "* Add in extra script to go into individual listings & get long - lat coordinates."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from lxml import html, etree\n",
    "import requests\n",
    "import pandas as pd\n",
    "import datetime as dt\n",
    "\n",
    "class rightmove_data(object):\n",
    "\n",
    "    def __init__(self, url):\n",
    "        self.url = url\n",
    "\n",
    "    def rent_or_sale(self):\n",
    "        try:\n",
    "            start,end = str(self.url).split('www.rightmove.co.uk/property-')\n",
    "            if end[:3] == 'for':\n",
    "                return end[4:8]\n",
    "            elif end[:3] == 'to-':\n",
    "                return end[3:7]\n",
    "        except ValueError:\n",
    "            print(\"ERROR! Not a valid rightmove search URL.\")\n",
    "\n",
    "    def number_of_results(self):\n",
    "        page = requests.get(self.url)\n",
    "        tree = html.fromstring(page.content)\n",
    "        xp_result_count = '//span[@class=\"searchHeader-resultCount\"]/text()'\n",
    "        return int(tree.xpath(xp_result_count)[0].replace(\",\", \"\"))\n",
    "    \n",
    "    def number_of_result_pages(self):\n",
    "        page_count = self.number_of_results() / 24\n",
    "        if self.number_of_results() % 24 > 0:\n",
    "            page_count += 1\n",
    "            \n",
    "        # Rightmove will only actually return a maximum of 42 pages of results, hence:\n",
    "        if page_count >42: page_count = 42\n",
    "            \n",
    "        return page_count\n",
    "    \n",
    "    def one_page_results(self,page_url):\n",
    "        \n",
    "        if self.rent_or_sale() == 'rent':\n",
    "            xp_prices = '//span[@class=\"propertyCard-priceValue\"]/text()'\n",
    "        elif self.rent_or_sale() == 'sale':\n",
    "            xp_prices = '//div[@class=\"propertyCard-priceValue\"]/text()'\n",
    "        \n",
    "        xp_titles = '//div[@class=\"propertyCard-details\"]//a[@class=\"propertyCard-link\"]\\\n",
    "        //h2[@class=\"propertyCard-title\"]/text()'\n",
    "        xp_addresses = '//address[@class=\"propertyCard-address\"]/text()'\n",
    "        xp_weblinks = '//div[@class=\"propertyCard-details\"]//a[@class=\"propertyCard-link\"]/@href'\n",
    "\n",
    "        page = requests.get(page_url)\n",
    "        tree = html.fromstring(page.content)\n",
    "\n",
    "        price_pcm, titles, addresses, weblinks = [], [], [], []\n",
    "\n",
    "    # Create data lists from Xpaths\n",
    "        for val in tree.xpath(xp_prices):\n",
    "            price_pcm.append(val)\n",
    "        for val in tree.xpath(xp_titles):\n",
    "            titles.append(val)\n",
    "        for val in tree.xpath(xp_addresses):\n",
    "            addresses.append(val)\n",
    "        for val in tree.xpath(xp_weblinks):\n",
    "            weblinks.append('http://www.rightmove.co.uk'+val)\n",
    "\n",
    "    # Convert data to temporary DataFrame\n",
    "        data = [price_pcm, titles, addresses, weblinks]\n",
    "        temp_df = pd.DataFrame(data)\n",
    "        temp_df = temp_df.transpose()\n",
    "        temp_df.columns = ['price','type','address','url']\n",
    "        \n",
    "    # Drop empty rows from DataFrame which come from placeholders in rightmove html\n",
    "    # Note this url is correct for Rent or Sale searches.\n",
    "        temp_df = temp_df[temp_df.url != 'http://www.rightmove.co.uk/property-for-sale/property-0.html']\n",
    "\n",
    "        return temp_df\n",
    "    \n",
    "    def full_results(self):\n",
    "        \n",
    "        full_results = pd.DataFrame(columns={'price','type','address','url'})\n",
    "                \n",
    "        for i in range(0,self.number_of_result_pages()+1,1):\n",
    "            iteration_url = str(self.url) + '&index=' + str((i*24))\n",
    "            temp_df = self.one_page_results(iteration_url)\n",
    "            frames = [full_results,temp_df]\n",
    "            full_results = pd.concat(frames)\n",
    "            \n",
    "        # Tidy up results data frame for analysis\n",
    "        \n",
    "        full_results = full_results.reset_index(drop=True)\n",
    "            \n",
    "        # Convert price column to numeric values for analysis\n",
    "        full_results.price.replace(regex=True,inplace=True,to_replace=r'\\D',value=r'')\n",
    "        full_results.price = pd.to_numeric(full_results.price)\n",
    "\n",
    "        # Extract postcode stems to a separate column\n",
    "        full_results['postcode'] = full_results['address'].str.extract\\\n",
    "        (r'\\b([A-Za-z][A-Za-z]?[0-9][0-9]?[A-Za-z]?)\\b',expand=True)\n",
    "\n",
    "    # Extract number of bedrooms from 'type' to a separate column\n",
    "        full_results['number_bedrooms'] = full_results.type.str.extract(r'\\b([\\d][\\d]?)\\b',expand=True)\n",
    "        full_results.loc[full_results['type'].str.contains('studio',case=False),'number_bedrooms']=0\n",
    "\n",
    "    # Add in search_date column to record the date the search was run (i.e. today's date)\n",
    "        now = dt.datetime.today().strftime(\"%d/%m/%Y\")\n",
    "        full_results['search_date'] = now\n",
    "\n",
    "        return full_results\n",
    "        "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## TESTING"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "all_london_rent_url = 'http://www.rightmove.co.uk/property-to-rent/find.html?searchType=RENT&locationIdentifier\\\n",
    "=REGION%5E87490&insId=3&radius=0.0&minPrice=&maxPrice=&minBedrooms=&maxBedrooms=&displayPropertyType=\\\n",
    "&maxDaysSinceAdded=&sortByPriceDescending=&_includeLetAgreed=on&primaryDisplayPropertyType=\\\n",
    "&secondaryDisplayPropertyType=&oldDisplayPropertyType=&oldPrimaryDisplayPropertyType=&letType=\\\n",
    "&letFurnishType=&houseFlatShare=false'\n",
    "\n",
    "london_fields_buy_url = 'http://www.rightmove.co.uk/property-for-sale/find.html?locationIdentifier=\\\n",
    "REGION%5E70417&propertyTypes=detached%2Csemi-detached%2Cterraced%2Cflat%2Cbungalow&includeSSTC=false'\n",
    "\n",
    "fake_url = 'www.fakewebsite.com'\n",
    "\n",
    "rent_data = rightmove_data(all_london_rent_url)\n",
    "buy_data = rightmove_data(london_fields_buy_url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Rent testing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'rent'"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rent_data.rent_or_sale()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "60244"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rent_data.number_of_results()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rent_data.number_of_result_pages()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "      <th>type</th>\n",
       "      <th>address</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>£2,097 pcm</td>\n",
       "      <td>3 bedroom flat</td>\n",
       "      <td>Telferscot Road, SW12</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>£1,000 pcm</td>\n",
       "      <td>2 bedroom flat</td>\n",
       "      <td>Sidney Road, South Norwood, SE25</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>£1,200 pcm</td>\n",
       "      <td>1 bedroom flat</td>\n",
       "      <td>North End Road, Golders Green, London, NW11 7HT</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>£1,000 pcm</td>\n",
       "      <td>1 bedroom flat</td>\n",
       "      <td>Rushey Green London SE6</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>£900 pcm</td>\n",
       "      <td>Studio flat</td>\n",
       "      <td>Anerley Road London SE20</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>£1,050 pcm</td>\n",
       "      <td>1 bedroom flat</td>\n",
       "      <td>Maberley Road Upper Norwood SE19</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>£1,625 pcm</td>\n",
       "      <td>1 bedroom flat</td>\n",
       "      <td>Southstand Highbury Stadium Square, London, N5</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>£3,012 pcm</td>\n",
       "      <td>3 bedroom apartment</td>\n",
       "      <td>Gloucester Terrace, Powell House, W2</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>£1,993 pcm</td>\n",
       "      <td>2 bedroom maisonette</td>\n",
       "      <td>Hazlebury Road, Fulham, London, SW6</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>£2,167 pcm</td>\n",
       "      <td>3 bedroom maisonette</td>\n",
       "      <td>Lysia Street, Fulham, London, SW6</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>£2,318 pcm</td>\n",
       "      <td>2 bedroom flat</td>\n",
       "      <td>Times Square, London</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>£2,080 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>£2,730 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>£1,950 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>£1,907 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>£1,907 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>£1,863 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>1 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>£1,950 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>3 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>£2,600 pcm</td>\n",
       "      <td>3 bedroom apartment</td>\n",
       "      <td>3 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>£1,950 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>3 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>£1,950 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>3 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>£1,950 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>3 Tidal Basin Road, London, E16</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>£3,575 pcm</td>\n",
       "      <td>2 bedroom apartment</td>\n",
       "      <td>The Courthouse, 70 Horseferry Road, Victoria SW1P</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>£1,647 pcm</td>\n",
       "      <td>2 bedroom flat</td>\n",
       "      <td>Dalmeny Mansions, Anson Road, Tufnell Park, Lo...</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>£4,810 pcm</td>\n",
       "      <td>3 bedroom apartment</td>\n",
       "      <td>Chesterfield House, Chesterfield Gardens, Lond...</td>\n",
       "      <td>http://www.rightmove.co.uk/property-to-rent/pr...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         price                  type  \\\n",
       "0   £2,097 pcm        3 bedroom flat   \n",
       "1   £1,000 pcm        2 bedroom flat   \n",
       "2   £1,200 pcm        1 bedroom flat   \n",
       "3   £1,000 pcm        1 bedroom flat   \n",
       "4     £900 pcm           Studio flat   \n",
       "5   £1,050 pcm        1 bedroom flat   \n",
       "6   £1,625 pcm        1 bedroom flat   \n",
       "7   £3,012 pcm   3 bedroom apartment   \n",
       "8   £1,993 pcm  2 bedroom maisonette   \n",
       "9   £2,167 pcm  3 bedroom maisonette   \n",
       "10  £2,318 pcm        2 bedroom flat   \n",
       "11  £2,080 pcm   2 bedroom apartment   \n",
       "12  £2,730 pcm   2 bedroom apartment   \n",
       "13  £1,950 pcm   2 bedroom apartment   \n",
       "14  £1,907 pcm   2 bedroom apartment   \n",
       "15  £1,907 pcm   2 bedroom apartment   \n",
       "16  £1,863 pcm   2 bedroom apartment   \n",
       "17  £1,950 pcm   2 bedroom apartment   \n",
       "18  £2,600 pcm   3 bedroom apartment   \n",
       "19  £1,950 pcm   2 bedroom apartment   \n",
       "20  £1,950 pcm   2 bedroom apartment   \n",
       "21  £1,950 pcm   2 bedroom apartment   \n",
       "22  £3,575 pcm   2 bedroom apartment   \n",
       "23  £1,647 pcm        2 bedroom flat   \n",
       "24  £4,810 pcm   3 bedroom apartment   \n",
       "\n",
       "                                              address  \\\n",
       "0                               Telferscot Road, SW12   \n",
       "1                    Sidney Road, South Norwood, SE25   \n",
       "2     North End Road, Golders Green, London, NW11 7HT   \n",
       "3                             Rushey Green London SE6   \n",
       "4                            Anerley Road London SE20   \n",
       "5                    Maberley Road Upper Norwood SE19   \n",
       "6      Southstand Highbury Stadium Square, London, N5   \n",
       "7                Gloucester Terrace, Powell House, W2   \n",
       "8                 Hazlebury Road, Fulham, London, SW6   \n",
       "9                   Lysia Street, Fulham, London, SW6   \n",
       "10                               Times Square, London   \n",
       "11                    1 Tidal Basin Road, London, E16   \n",
       "12                    1 Tidal Basin Road, London, E16   \n",
       "13                    1 Tidal Basin Road, London, E16   \n",
       "14                    1 Tidal Basin Road, London, E16   \n",
       "15                    1 Tidal Basin Road, London, E16   \n",
       "16                    1 Tidal Basin Road, London, E16   \n",
       "17                    3 Tidal Basin Road, London, E16   \n",
       "18                    3 Tidal Basin Road, London, E16   \n",
       "19                    3 Tidal Basin Road, London, E16   \n",
       "20                    3 Tidal Basin Road, London, E16   \n",
       "21                    3 Tidal Basin Road, London, E16   \n",
       "22  The Courthouse, 70 Horseferry Road, Victoria SW1P   \n",
       "23  Dalmeny Mansions, Anson Road, Tufnell Park, Lo...   \n",
       "24  Chesterfield House, Chesterfield Gardens, Lond...   \n",
       "\n",
       "                                                  url  \n",
       "0   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "1   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "2   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "3   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "4   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "5   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "6   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "7   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "8   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "9   http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "10  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "11  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "12  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "13  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "14  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "15  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "16  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "17  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "18  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "19  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "20  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "21  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "22  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "23  http://www.rightmove.co.uk/property-to-rent/pr...  \n",
       "24  http://www.rightmove.co.uk/property-to-rent/pr...  "
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rent_data.one_page_results(rent_data.url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Sale testing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'sale'"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buy_data.rent_or_sale()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "169"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buy_data.number_of_results()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buy_data.number_of_result_pages()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "      <th>type</th>\n",
       "      <th>address</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>£465,000</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>Well Street, London</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>POA</td>\n",
       "      <td>8 bedroom apartment for sale</td>\n",
       "      <td>King Edward's Road, London</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>£2,350,000</td>\n",
       "      <td>6 bedroom house for sale</td>\n",
       "      <td>Forest Road, Hackney, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>£2,350,000</td>\n",
       "      <td>6 bedroom semi-detached house for sale</td>\n",
       "      <td>Forest Road, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>£2,350,000</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>Albion Square, Hackney, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>£2,000,000</td>\n",
       "      <td>Detached house for sale</td>\n",
       "      <td>76 Shrubland Road, London, Hackney, E8 4NH</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>£1,975,000</td>\n",
       "      <td>3 bedroom house for sale</td>\n",
       "      <td>Malvern Road, London Fields, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>£1,900,000</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>Elrington Road, Hackney</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>£1,825,000</td>\n",
       "      <td>4 bedroom end of terrace house for sale</td>\n",
       "      <td>Lavender Grove, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>£1,775,000</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>Greenwood Road, Hackney, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>£1,759,000</td>\n",
       "      <td>3 bedroom semi-detached house for sale</td>\n",
       "      <td>Elrington Road, London Fields, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>£1,650,000</td>\n",
       "      <td>2 bedroom maisonette for sale</td>\n",
       "      <td>Yorkton Street, Shoreditch, E2</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>£1,650,000</td>\n",
       "      <td>2 bedroom house for sale</td>\n",
       "      <td>Yorkton Street, Hackney, London, E2</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>£1,650,000</td>\n",
       "      <td>2 bedroom maisonette for sale</td>\n",
       "      <td>Yorkton Street, Shoreditch, E2</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>£1,599,500</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>Fassett Square, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>£1,425,000</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>Lansdowne Drive, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>£1,395,000</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>Ritson Road, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>£1,350,000</td>\n",
       "      <td>5 bedroom end of terrace house for sale</td>\n",
       "      <td>Horton Road, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>£1,350,000</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>Mettle &amp; Poise, 331 Hackney Road, E2</td>\n",
       "      <td>http://www.rightmove.co.uk/new-homes-for-sale/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>£1,350,000</td>\n",
       "      <td>3 bedroom flat for sale</td>\n",
       "      <td>Mettle &amp; Poise, Hackney Road, E2</td>\n",
       "      <td>http://www.rightmove.co.uk/new-homes-for-sale/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>£1,295,000</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>The Gransden, Gransden Avenue, Hackney, London</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>£1,295,000</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>Penpoll Road, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>£1,275,000</td>\n",
       "      <td>5 bedroom semi-detached house for sale</td>\n",
       "      <td>Navarino Road, London, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>£1,275,000</td>\n",
       "      <td>3 bedroom house for sale</td>\n",
       "      <td>Mare Street, London Fields, E8</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>£1,250,000</td>\n",
       "      <td>3 bedroom flat for sale</td>\n",
       "      <td>The Gransden, Gransden Avenue, Hackney, London</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 price                                     type  \\\n",
       "0     £465,000                          2 bedroom flat for sale   \n",
       "1          POA                     8 bedroom apartment for sale   \n",
       "2   £2,350,000                         6 bedroom house for sale   \n",
       "3   £2,350,000           6 bedroom semi-detached house for sale   \n",
       "4   £2,350,000                4 bedroom terraced house for sale   \n",
       "5   £2,000,000                          Detached house for sale   \n",
       "6   £1,975,000                         3 bedroom house for sale   \n",
       "7   £1,900,000                4 bedroom terraced house for sale   \n",
       "8   £1,825,000          4 bedroom end of terrace house for sale   \n",
       "9   £1,775,000                4 bedroom terraced house for sale   \n",
       "10  £1,759,000           3 bedroom semi-detached house for sale   \n",
       "11  £1,650,000                    2 bedroom maisonette for sale   \n",
       "12  £1,650,000                         2 bedroom house for sale   \n",
       "13  £1,650,000                    2 bedroom maisonette for sale   \n",
       "14  £1,599,500                4 bedroom terraced house for sale   \n",
       "15  £1,425,000                4 bedroom terraced house for sale   \n",
       "16  £1,395,000                3 bedroom terraced house for sale   \n",
       "17  £1,350,000          5 bedroom end of terrace house for sale   \n",
       "18  £1,350,000                3 bedroom terraced house for sale   \n",
       "19  £1,350,000                          3 bedroom flat for sale   \n",
       "20  £1,295,000                          2 bedroom flat for sale   \n",
       "21  £1,295,000                3 bedroom terraced house for sale   \n",
       "22  £1,275,000           5 bedroom semi-detached house for sale   \n",
       "23  £1,275,000                         3 bedroom house for sale   \n",
       "24  £1,250,000                          3 bedroom flat for sale   \n",
       "\n",
       "                                           address  \\\n",
       "0                              Well Street, London   \n",
       "1                       King Edward's Road, London   \n",
       "2                         Forest Road, Hackney, E8   \n",
       "3                          Forest Road, London, E8   \n",
       "4                       Albion Square, Hackney, E8   \n",
       "5       76 Shrubland Road, London, Hackney, E8 4NH   \n",
       "6                  Malvern Road, London Fields, E8   \n",
       "7                          Elrington Road, Hackney   \n",
       "8                       Lavender Grove, London, E8   \n",
       "9                      Greenwood Road, Hackney, E8   \n",
       "10               Elrington Road, London Fields, E8   \n",
       "11                  Yorkton Street, Shoreditch, E2   \n",
       "12             Yorkton Street, Hackney, London, E2   \n",
       "13                  Yorkton Street, Shoreditch, E2   \n",
       "14                      Fassett Square, London, E8   \n",
       "15                     Lansdowne Drive, London, E8   \n",
       "16                         Ritson Road, London, E8   \n",
       "17                         Horton Road, London, E8   \n",
       "18            Mettle & Poise, 331 Hackney Road, E2   \n",
       "19                Mettle & Poise, Hackney Road, E2   \n",
       "20  The Gransden, Gransden Avenue, Hackney, London   \n",
       "21                        Penpoll Road, London, E8   \n",
       "22                       Navarino Road, London, E8   \n",
       "23                  Mare Street, London Fields, E8   \n",
       "24  The Gransden, Gransden Avenue, Hackney, London   \n",
       "\n",
       "                                                  url  \n",
       "0   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "1   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "2   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "3   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "4   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "5   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "6   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "7   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "8   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "9   http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "10  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "11  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "12  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "13  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "14  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "15  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "16  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "17  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "18  http://www.rightmove.co.uk/new-homes-for-sale/...  \n",
       "19  http://www.rightmove.co.uk/new-homes-for-sale/...  \n",
       "20  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "21  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "22  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "23  http://www.rightmove.co.uk/property-for-sale/p...  \n",
       "24  http://www.rightmove.co.uk/property-for-sale/p...  "
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buy_data.one_page_results(buy_data.url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>price</th>\n",
       "      <th>type</th>\n",
       "      <th>url</th>\n",
       "      <th>postcode</th>\n",
       "      <th>number_bedrooms</th>\n",
       "      <th>search_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Well Street, London</td>\n",
       "      <td>465000.0</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>King Edward's Road, London</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albion Square, Hackney, E8</td>\n",
       "      <td>2350000.0</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Forest Road, London, E8</td>\n",
       "      <td>2350000.0</td>\n",
       "      <td>6 bedroom semi-detached house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>6</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Forest Road, Hackney, E8</td>\n",
       "      <td>2350000.0</td>\n",
       "      <td>6 bedroom house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>6</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>76 Shrubland Road, London, Hackney, E8 4NH</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Detached house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Malvern Road, London Fields, E8</td>\n",
       "      <td>1975000.0</td>\n",
       "      <td>3 bedroom house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Elrington Road, Hackney</td>\n",
       "      <td>1900000.0</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lavender Grove, London, E8</td>\n",
       "      <td>1825000.0</td>\n",
       "      <td>4 bedroom end of terrace house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Greenwood Road, Hackney, E8</td>\n",
       "      <td>1775000.0</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Elrington Road, London Fields, E8</td>\n",
       "      <td>1759000.0</td>\n",
       "      <td>3 bedroom semi-detached house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Yorkton Street, Hackney, London, E2</td>\n",
       "      <td>1650000.0</td>\n",
       "      <td>2 bedroom house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Yorkton Street, Shoreditch, E2</td>\n",
       "      <td>1650000.0</td>\n",
       "      <td>2 bedroom maisonette for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Yorkton Street, Shoreditch, E2</td>\n",
       "      <td>1650000.0</td>\n",
       "      <td>2 bedroom maisonette for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Fassett Square, London, E8</td>\n",
       "      <td>1599500.0</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Lansdowne Drive, London, E8</td>\n",
       "      <td>1425000.0</td>\n",
       "      <td>4 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>4</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ritson Road, London, E8</td>\n",
       "      <td>1395000.0</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Mettle &amp; Poise, 331 Hackney Road, E2</td>\n",
       "      <td>1350000.0</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/new-homes-for-sale/...</td>\n",
       "      <td>E2</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Horton Road, London, E8</td>\n",
       "      <td>1350000.0</td>\n",
       "      <td>5 bedroom end of terrace house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>5</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mettle &amp; Poise, Hackney Road, E2</td>\n",
       "      <td>1350000.0</td>\n",
       "      <td>3 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/new-homes-for-sale/...</td>\n",
       "      <td>E2</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Penpoll Road, London, E8</td>\n",
       "      <td>1295000.0</td>\n",
       "      <td>3 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>The Gransden, Gransden Avenue, Hackney, London</td>\n",
       "      <td>1295000.0</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Navarino Road, London, E8</td>\n",
       "      <td>1275000.0</td>\n",
       "      <td>5 bedroom semi-detached house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>5</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mare Street, London Fields, E8</td>\n",
       "      <td>1275000.0</td>\n",
       "      <td>3 bedroom house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>The Gransden, Gransden Avenue, Hackney, London</td>\n",
       "      <td>1250000.0</td>\n",
       "      <td>3 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Alpha House, Tyssen Street, London</td>\n",
       "      <td>985000.0</td>\n",
       "      <td>3 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/new-homes-for-sale/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Brougham Road, Hackney, London, E8</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>2 bedroom house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Arthaus Apartments, 205 Richmond Road, London, E8</td>\n",
       "      <td>1195000.0</td>\n",
       "      <td>3 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Parkholme Road, London, E8</td>\n",
       "      <td>1150000.0</td>\n",
       "      <td>3 bedroom maisonette for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>3</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Richmond Road, Hackney, E8</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>5 bedroom terraced house for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>5</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Hackney Road, London, E2</td>\n",
       "      <td>449995.0</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Queensbridge Road, London, E2</td>\n",
       "      <td>440000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>Pritchards Road, London</td>\n",
       "      <td>435000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Martello Street, London Fields, E8</td>\n",
       "      <td>435000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Hacon Square, Richmond Road, Hackney</td>\n",
       "      <td>425000.0</td>\n",
       "      <td>2 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Hacon Square, Richmond Road, Hackney</td>\n",
       "      <td>425000.0</td>\n",
       "      <td>2 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Graham Road, London, E8</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Richmond Road, London Fields, E8</td>\n",
       "      <td>415000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Fairchild Place, London, E2</td>\n",
       "      <td>410000.0</td>\n",
       "      <td>1 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Woolstone House, London, E2</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>Hackney Road, London, E2</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Richmond Road, London, E8</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Graham Road, Hackney, E8</td>\n",
       "      <td>399995.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>Graham Road, Hackney, E8</td>\n",
       "      <td>399995.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Woolstone House, Whinston Street, Hoxton, Shor...</td>\n",
       "      <td>399995.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Graham Road, London, E8</td>\n",
       "      <td>399995.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Celandine Drive, Hackney, E8</td>\n",
       "      <td>399950.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>Wharf Place, Tower Hamlets</td>\n",
       "      <td>385000.0</td>\n",
       "      <td>1 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Regents Wharf, Broadway Market, E2</td>\n",
       "      <td>385000.0</td>\n",
       "      <td>1 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Wharf Place, Tower Hamlets</td>\n",
       "      <td>375000.0</td>\n",
       "      <td>1 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Regents Wharf, Broadway Market, E2</td>\n",
       "      <td>375000.0</td>\n",
       "      <td>1 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Linslade House, Whiston Road, Bethnal Green, L...</td>\n",
       "      <td>365000.0</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E2</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>King Edward's Road, London</td>\n",
       "      <td>360000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Classic Mansions, Well Street, London, E9</td>\n",
       "      <td>325000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E9</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Well Street, London</td>\n",
       "      <td>325000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Well Street, Hackney, E9</td>\n",
       "      <td>325000.0</td>\n",
       "      <td>1 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E9</td>\n",
       "      <td>1</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Daubeney Road, London</td>\n",
       "      <td>295000.0</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Mare Street, London, E8</td>\n",
       "      <td>262000.0</td>\n",
       "      <td>2 bedroom apartment for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Quadra, 91 Lansdowne Drive, E8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Quadra, 91 Lansdowne Drive, E8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2 bedroom flat for sale</td>\n",
       "      <td>http://www.rightmove.co.uk/property-for-sale/p...</td>\n",
       "      <td>E8</td>\n",
       "      <td>2</td>\n",
       "      <td>09/03/2017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>171 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               address      price  \\\n",
       "0                                  Well Street, London   465000.0   \n",
       "1                           King Edward's Road, London        NaN   \n",
       "2                           Albion Square, Hackney, E8  2350000.0   \n",
       "3                              Forest Road, London, E8  2350000.0   \n",
       "4                             Forest Road, Hackney, E8  2350000.0   \n",
       "5           76 Shrubland Road, London, Hackney, E8 4NH  2000000.0   \n",
       "6                      Malvern Road, London Fields, E8  1975000.0   \n",
       "7                              Elrington Road, Hackney  1900000.0   \n",
       "8                           Lavender Grove, London, E8  1825000.0   \n",
       "9                          Greenwood Road, Hackney, E8  1775000.0   \n",
       "10                   Elrington Road, London Fields, E8  1759000.0   \n",
       "11                 Yorkton Street, Hackney, London, E2  1650000.0   \n",
       "12                      Yorkton Street, Shoreditch, E2  1650000.0   \n",
       "13                      Yorkton Street, Shoreditch, E2  1650000.0   \n",
       "14                          Fassett Square, London, E8  1599500.0   \n",
       "15                         Lansdowne Drive, London, E8  1425000.0   \n",
       "16                             Ritson Road, London, E8  1395000.0   \n",
       "17                Mettle & Poise, 331 Hackney Road, E2  1350000.0   \n",
       "18                             Horton Road, London, E8  1350000.0   \n",
       "19                    Mettle & Poise, Hackney Road, E2  1350000.0   \n",
       "20                            Penpoll Road, London, E8  1295000.0   \n",
       "21      The Gransden, Gransden Avenue, Hackney, London  1295000.0   \n",
       "22                           Navarino Road, London, E8  1275000.0   \n",
       "23                      Mare Street, London Fields, E8  1275000.0   \n",
       "24      The Gransden, Gransden Avenue, Hackney, London  1250000.0   \n",
       "25                  Alpha House, Tyssen Street, London   985000.0   \n",
       "26                  Brougham Road, Hackney, London, E8  1200000.0   \n",
       "27   Arthaus Apartments, 205 Richmond Road, London, E8  1195000.0   \n",
       "28                          Parkholme Road, London, E8  1150000.0   \n",
       "29                          Richmond Road, Hackney, E8  1100000.0   \n",
       "..                                                 ...        ...   \n",
       "141                           Hackney Road, London, E2   449995.0   \n",
       "142                      Queensbridge Road, London, E2   440000.0   \n",
       "143                            Pritchards Road, London   435000.0   \n",
       "144                 Martello Street, London Fields, E8   435000.0   \n",
       "145               Hacon Square, Richmond Road, Hackney   425000.0   \n",
       "146               Hacon Square, Richmond Road, Hackney   425000.0   \n",
       "147                            Graham Road, London, E8   420000.0   \n",
       "148                   Richmond Road, London Fields, E8   415000.0   \n",
       "149                       Fairchild Place, London, E2    410000.0   \n",
       "150                        Woolstone House, London, E2   400000.0   \n",
       "151                           Hackney Road, London, E2   400000.0   \n",
       "152                          Richmond Road, London, E8   400000.0   \n",
       "153                           Graham Road, Hackney, E8   399995.0   \n",
       "154                           Graham Road, Hackney, E8   399995.0   \n",
       "155  Woolstone House, Whinston Street, Hoxton, Shor...   399995.0   \n",
       "156                            Graham Road, London, E8   399995.0   \n",
       "157                       Celandine Drive, Hackney, E8   399950.0   \n",
       "158                         Wharf Place, Tower Hamlets   385000.0   \n",
       "159                 Regents Wharf, Broadway Market, E2   385000.0   \n",
       "160                         Wharf Place, Tower Hamlets   375000.0   \n",
       "161                 Regents Wharf, Broadway Market, E2   375000.0   \n",
       "162  Linslade House, Whiston Road, Bethnal Green, L...   365000.0   \n",
       "163                         King Edward's Road, London   360000.0   \n",
       "164          Classic Mansions, Well Street, London, E9   325000.0   \n",
       "165                                Well Street, London   325000.0   \n",
       "166                           Well Street, Hackney, E9   325000.0   \n",
       "167                              Daubeney Road, London   295000.0   \n",
       "168                            Mare Street, London, E8   262000.0   \n",
       "169                     Quadra, 91 Lansdowne Drive, E8        NaN   \n",
       "170                     Quadra, 91 Lansdowne Drive, E8        NaN   \n",
       "\n",
       "                                        type  \\\n",
       "0                    2 bedroom flat for sale   \n",
       "1               8 bedroom apartment for sale   \n",
       "2          4 bedroom terraced house for sale   \n",
       "3     6 bedroom semi-detached house for sale   \n",
       "4                   6 bedroom house for sale   \n",
       "5                    Detached house for sale   \n",
       "6                   3 bedroom house for sale   \n",
       "7          4 bedroom terraced house for sale   \n",
       "8    4 bedroom end of terrace house for sale   \n",
       "9          4 bedroom terraced house for sale   \n",
       "10    3 bedroom semi-detached house for sale   \n",
       "11                  2 bedroom house for sale   \n",
       "12             2 bedroom maisonette for sale   \n",
       "13             2 bedroom maisonette for sale   \n",
       "14         4 bedroom terraced house for sale   \n",
       "15         4 bedroom terraced house for sale   \n",
       "16         3 bedroom terraced house for sale   \n",
       "17         3 bedroom terraced house for sale   \n",
       "18   5 bedroom end of terrace house for sale   \n",
       "19                   3 bedroom flat for sale   \n",
       "20         3 bedroom terraced house for sale   \n",
       "21                   2 bedroom flat for sale   \n",
       "22    5 bedroom semi-detached house for sale   \n",
       "23                  3 bedroom house for sale   \n",
       "24                   3 bedroom flat for sale   \n",
       "25              3 bedroom apartment for sale   \n",
       "26                  2 bedroom house for sale   \n",
       "27                   3 bedroom flat for sale   \n",
       "28             3 bedroom maisonette for sale   \n",
       "29         5 bedroom terraced house for sale   \n",
       "..                                       ...   \n",
       "141                  2 bedroom flat for sale   \n",
       "142                  1 bedroom flat for sale   \n",
       "143                  1 bedroom flat for sale   \n",
       "144                  1 bedroom flat for sale   \n",
       "145             2 bedroom apartment for sale   \n",
       "146             2 bedroom apartment for sale   \n",
       "147                  1 bedroom flat for sale   \n",
       "148                  1 bedroom flat for sale   \n",
       "149             1 bedroom apartment for sale   \n",
       "150                  1 bedroom flat for sale   \n",
       "151                  1 bedroom flat for sale   \n",
       "152                  1 bedroom flat for sale   \n",
       "153                  1 bedroom flat for sale   \n",
       "154                  1 bedroom flat for sale   \n",
       "155                  1 bedroom flat for sale   \n",
       "156                  1 bedroom flat for sale   \n",
       "157                  1 bedroom flat for sale   \n",
       "158             1 bedroom apartment for sale   \n",
       "159             1 bedroom apartment for sale   \n",
       "160             1 bedroom apartment for sale   \n",
       "161             1 bedroom apartment for sale   \n",
       "162                  2 bedroom flat for sale   \n",
       "163                  1 bedroom flat for sale   \n",
       "164                  1 bedroom flat for sale   \n",
       "165                  1 bedroom flat for sale   \n",
       "166                  1 bedroom flat for sale   \n",
       "167                  2 bedroom flat for sale   \n",
       "168             2 bedroom apartment for sale   \n",
       "169                  2 bedroom flat for sale   \n",
       "170                  2 bedroom flat for sale   \n",
       "\n",
       "                                                   url postcode  \\\n",
       "0    http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "1    http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "2    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "3    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "4    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "5    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "6    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "7    http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "8    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "9    http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "10   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "11   http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "12   http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "13   http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "14   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "15   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "16   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "17   http://www.rightmove.co.uk/new-homes-for-sale/...       E2   \n",
       "18   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "19   http://www.rightmove.co.uk/new-homes-for-sale/...       E2   \n",
       "20   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "21   http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "22   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "23   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "24   http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "25   http://www.rightmove.co.uk/new-homes-for-sale/...      NaN   \n",
       "26   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "27   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "28   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "29   http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "..                                                 ...      ...   \n",
       "141  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "142  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "143  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "144  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "145  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "146  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "147  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "148  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "149  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "150  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "151  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "152  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "153  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "154  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "155  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "156  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "157  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "158  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "159  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "160  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "161  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "162  http://www.rightmove.co.uk/property-for-sale/p...       E2   \n",
       "163  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "164  http://www.rightmove.co.uk/property-for-sale/p...       E9   \n",
       "165  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "166  http://www.rightmove.co.uk/property-for-sale/p...       E9   \n",
       "167  http://www.rightmove.co.uk/property-for-sale/p...      NaN   \n",
       "168  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "169  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "170  http://www.rightmove.co.uk/property-for-sale/p...       E8   \n",
       "\n",
       "    number_bedrooms search_date  \n",
       "0                 2  09/03/2017  \n",
       "1                 8  09/03/2017  \n",
       "2                 4  09/03/2017  \n",
       "3                 6  09/03/2017  \n",
       "4                 6  09/03/2017  \n",
       "5               NaN  09/03/2017  \n",
       "6                 3  09/03/2017  \n",
       "7                 4  09/03/2017  \n",
       "8                 4  09/03/2017  \n",
       "9                 4  09/03/2017  \n",
       "10                3  09/03/2017  \n",
       "11                2  09/03/2017  \n",
       "12                2  09/03/2017  \n",
       "13                2  09/03/2017  \n",
       "14                4  09/03/2017  \n",
       "15                4  09/03/2017  \n",
       "16                3  09/03/2017  \n",
       "17                3  09/03/2017  \n",
       "18                5  09/03/2017  \n",
       "19                3  09/03/2017  \n",
       "20                3  09/03/2017  \n",
       "21                2  09/03/2017  \n",
       "22                5  09/03/2017  \n",
       "23                3  09/03/2017  \n",
       "24                3  09/03/2017  \n",
       "25                3  09/03/2017  \n",
       "26                2  09/03/2017  \n",
       "27                3  09/03/2017  \n",
       "28                3  09/03/2017  \n",
       "29                5  09/03/2017  \n",
       "..              ...         ...  \n",
       "141               2  09/03/2017  \n",
       "142               1  09/03/2017  \n",
       "143               1  09/03/2017  \n",
       "144               1  09/03/2017  \n",
       "145               2  09/03/2017  \n",
       "146               2  09/03/2017  \n",
       "147               1  09/03/2017  \n",
       "148               1  09/03/2017  \n",
       "149               1  09/03/2017  \n",
       "150               1  09/03/2017  \n",
       "151               1  09/03/2017  \n",
       "152               1  09/03/2017  \n",
       "153               1  09/03/2017  \n",
       "154               1  09/03/2017  \n",
       "155               1  09/03/2017  \n",
       "156               1  09/03/2017  \n",
       "157               1  09/03/2017  \n",
       "158               1  09/03/2017  \n",
       "159               1  09/03/2017  \n",
       "160               1  09/03/2017  \n",
       "161               1  09/03/2017  \n",
       "162               2  09/03/2017  \n",
       "163               1  09/03/2017  \n",
       "164               1  09/03/2017  \n",
       "165               1  09/03/2017  \n",
       "166               1  09/03/2017  \n",
       "167               2  09/03/2017  \n",
       "168               2  09/03/2017  \n",
       "169               2  09/03/2017  \n",
       "170               2  09/03/2017  \n",
       "\n",
       "[171 rows x 7 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buy_data.full_results()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}