Price paid.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:cd734a9e057b2b16c3fef1783ba132aae231b82bbd6670684771b0c671bfc652"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#url='http://landregistry.data.gov.uk/app/ppd/ppd_data.csv?county=Isle+of+Wight&et%5B%5D=lrcommon%3Afreehold&et%5B%5D=lrcommon%3Aleasehold&header=true&limit=all&nb%5B%5D=true&nb%5B%5D=false&ptype%5B%5D=lrcommon%3Adetached&ptype%5B%5D=lrcommon%3Asemi-detached&ptype%5B%5D=lrcommon%3Aterraced&ptype%5B%5D=lrcommon%3Aflat-maisonette'\n",
      "#df=pd.read_csv(url)\n",
      "#df"
     ],
     "language": "python",
     "metadata": {
      "activity": false
     },
     "outputs": []
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "url2='http://landregistry.data.gov.uk/app/ppd/ppd_data.csv?county=Isle+of+Wight&et%5B%5D=lrcommon%3Afreehold&et%5B%5D=lrcommon%3Aleasehold&header=true&limit=all&min_date=18+March+2015&nb%5B%5D=true&nb%5B%5D=false&ptype%5B%5D=lrcommon%3Adetached&ptype%5B%5D=lrcommon%3Asemi-detached&ptype%5B%5D=lrcommon%3Aterraced&ptype%5B%5D=lrcommon%3Aflat-maisonette'\n",
      "df2=pd.read_csv(url2)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df2"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>unique_id</th>\n",
        "      <th>price_paid</th>\n",
        "      <th>deed_date</th>\n",
        "      <th>postcode</th>\n",
        "      <th>property_type</th>\n",
        "      <th>new_build</th>\n",
        "      <th>estate_type</th>\n",
        "      <th>saon</th>\n",
        "      <th>paon</th>\n",
        "      <th>street</th>\n",
        "      <th>locality</th>\n",
        "      <th>town</th>\n",
        "      <th>district</th>\n",
        "      <th>county</th>\n",
        "      <th>linked_data_uri</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> C51497E0-18BF-448F-B818-B6C9D44396DF</td>\n",
        "      <td> 167500</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO30 2JA</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             5</td>\n",
        "      <td>     CYNTHIA GROVE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     NEWPORT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 8F880463-0747-4D55-B587-FEF54145D271</td>\n",
        "      <td> 177000</td>\n",
        "      <td> 2015-03-26</td>\n",
        "      <td> PO30 2JA</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             6</td>\n",
        "      <td>     CYNTHIA GROVE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     NEWPORT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 1FAFEB63-A6C8-4DD8-ACC1-78FBC2F13B06</td>\n",
        "      <td> 131250</td>\n",
        "      <td> 2015-03-23</td>\n",
        "      <td> PO30 5EA</td>\n",
        "      <td> T</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>            98</td>\n",
        "      <td>      CAESARS ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     NEWPORT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 9E7C8589-AA2C-4C22-8866-D24D0BA83DAB</td>\n",
        "      <td> 138000</td>\n",
        "      <td> 2015-03-23</td>\n",
        "      <td> PO30 5LQ</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>           151</td>\n",
        "      <td>     GUNVILLE ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     NEWPORT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 015A866D-0B09-4094-88F9-1AF1C3BB9E23</td>\n",
        "      <td> 185000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO30 5QZ</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>            13</td>\n",
        "      <td>       HINTON ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     NEWPORT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 23E6F9E1-D49F-4171-896A-F6FF6A528649</td>\n",
        "      <td>  55000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO31 7NE</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>           204</td>\n",
        "      <td>         PARK ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>       COWES</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> C5303863-493A-400D-8379-6A91F238B8F1</td>\n",
        "      <td> 220000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO31 8PN</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             5</td>\n",
        "      <td> CORONATION AVENUE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>       COWES</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> ACBBDA71-A1EC-43CA-9ADA-16BC5AFBDFD5</td>\n",
        "      <td> 160000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO32 6QD</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             4</td>\n",
        "      <td>     VEREKER DRIVE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>  EAST COWES</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 1D11F427-E67B-4B0F-8991-D4CB55589787</td>\n",
        "      <td> 197500</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO32 6TH</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>            96</td>\n",
        "      <td>     SYLVAN AVENUE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>  EAST COWES</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> FA6265A9-2444-458D-BD3A-0458C70C6A55</td>\n",
        "      <td> 190000</td>\n",
        "      <td> 2015-03-23</td>\n",
        "      <td> PO33 1DP</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             5</td>\n",
        "      <td>     BANBURY CLOSE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>        RYDE</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 16FBB1EA-4CE2-4268-86BD-30744169102A</td>\n",
        "      <td> 213300</td>\n",
        "      <td> 2015-03-24</td>\n",
        "      <td> PO33 1NG</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>            24</td>\n",
        "      <td>     MARINA AVENUE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>        RYDE</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 245609C0-688B-42EB-AF8C-CF55C41F6AFD</td>\n",
        "      <td> 267000</td>\n",
        "      <td> 2015-03-23</td>\n",
        "      <td> PO33 2DQ</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             9</td>\n",
        "      <td>   ALDERMORE CLOSE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>        RYDE</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td> BD9BC2EA-514A-4F93-AF37-8A64E5C0745B</td>\n",
        "      <td>  58000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO33 2EN</td>\n",
        "      <td> F</td>\n",
        "      <td> N</td>\n",
        "      <td> L</td>\n",
        "      <td>  FLAT 3</td>\n",
        "      <td>            44</td>\n",
        "      <td>     GEORGE STREET</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>        RYDE</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td> CBA136E9-0F29-4677-9758-03B72E546009</td>\n",
        "      <td> 200000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO33 3XB</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             1</td>\n",
        "      <td>     BIRCH GARDENS</td>\n",
        "      <td> BINSTEAD</td>\n",
        "      <td>        RYDE</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td> 0D7C9A2E-7B6F-4C65-B7B0-822D90AFED68</td>\n",
        "      <td>  95000</td>\n",
        "      <td> 2015-03-27</td>\n",
        "      <td> PO36 9JL</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>           39A</td>\n",
        "      <td>      SANDOWN ROAD</td>\n",
        "      <td>     LAKE</td>\n",
        "      <td>     SANDOWN</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td> B90DB134-265E-468E-9870-A4EF2374871E</td>\n",
        "      <td> 165000</td>\n",
        "      <td> 2015-03-23</td>\n",
        "      <td> PO36 9QF</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>            21</td>\n",
        "      <td>   HOME FARM CLOSE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     SANDOWN</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td> ABD634BB-38E9-4604-810F-2F4DE3435362</td>\n",
        "      <td> 275000</td>\n",
        "      <td> 2015-03-26</td>\n",
        "      <td> PO37 6QE</td>\n",
        "      <td> T</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             3</td>\n",
        "      <td>    WESTCOMBE PARK</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    SHANKLIN</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td> 77F30FEF-D220-43DD-97BC-557805EBCBF5</td>\n",
        "      <td> 150000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO37 7EZ</td>\n",
        "      <td> S</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>           113</td>\n",
        "      <td>        GREEN LANE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    SHANKLIN</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td> 3B081B44-CA73-4AAE-BBE1-F18F65A27326</td>\n",
        "      <td> 355000</td>\n",
        "      <td> 2015-03-18</td>\n",
        "      <td> PO37 7NU</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>   BATTS LODGE</td>\n",
        "      <td>        BATTS ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    SHANKLIN</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td> DB6452D2-09C7-48C0-BA84-81DF28F0565D</td>\n",
        "      <td> 182000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO38 1AL</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             1</td>\n",
        "      <td>          DOWNSIDE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     VENTNOR</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td> 35877ACA-D46A-4EE8-A8EF-B3D73445E0BD</td>\n",
        "      <td> 132000</td>\n",
        "      <td> 2015-03-19</td>\n",
        "      <td> PO38 1NR</td>\n",
        "      <td> F</td>\n",
        "      <td> N</td>\n",
        "      <td> L</td>\n",
        "      <td>  FLAT 3</td>\n",
        "      <td>    THE MAPLES</td>\n",
        "      <td>      MAPLES DRIVE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     VENTNOR</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td> 9E805CB1-D055-44FC-B44F-B71ABF65F98F</td>\n",
        "      <td> 164000</td>\n",
        "      <td> 2015-03-24</td>\n",
        "      <td> PO38 1QJ</td>\n",
        "      <td> F</td>\n",
        "      <td> N</td>\n",
        "      <td> L</td>\n",
        "      <td> FLAT 16</td>\n",
        "      <td> MADEIRA COURT</td>\n",
        "      <td>      MADEIRA ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     VENTNOR</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td> E41D3721-AAEE-4810-95C7-746CDACD01E2</td>\n",
        "      <td> 332000</td>\n",
        "      <td> 2015-03-19</td>\n",
        "      <td> PO38 1TX</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>             7</td>\n",
        "      <td>      TWINING ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     VENTNOR</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td> 53F9645F-927C-4A83-9EB3-EACA9800302E</td>\n",
        "      <td> 250000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO38 3AX</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>      PITVILLE</td>\n",
        "      <td>          REW LANE</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>     VENTNOR</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td> 32CF15DE-72B7-4241-945C-A93E869743B5</td>\n",
        "      <td> 117000</td>\n",
        "      <td> 2015-03-20</td>\n",
        "      <td> PO39 0EJ</td>\n",
        "      <td> F</td>\n",
        "      <td> N</td>\n",
        "      <td> L</td>\n",
        "      <td>  FLAT 3</td>\n",
        "      <td>    HURST VIEW</td>\n",
        "      <td>         EDEN ROAD</td>\n",
        "      <td>      NaN</td>\n",
        "      <td> TOTLAND BAY</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td> 6E0A8F6C-6AA0-42E7-8309-C899EF1F0125</td>\n",
        "      <td> 228000</td>\n",
        "      <td> 2015-03-24</td>\n",
        "      <td> PO41 0SX</td>\n",
        "      <td> D</td>\n",
        "      <td> N</td>\n",
        "      <td> F</td>\n",
        "      <td>     NaN</td>\n",
        "      <td>     THE MANSE</td>\n",
        "      <td>         MAIN ROAD</td>\n",
        "      <td>  THORLEY</td>\n",
        "      <td>    YARMOUTH</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> ISLE OF WIGHT</td>\n",
        "      <td> http://landregistry.data.gov.uk/data/ppi/trans...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "                               unique_id  price_paid   deed_date  postcode  \\\n",
        "0   C51497E0-18BF-448F-B818-B6C9D44396DF      167500  2015-03-20  PO30 2JA   \n",
        "1   8F880463-0747-4D55-B587-FEF54145D271      177000  2015-03-26  PO30 2JA   \n",
        "2   1FAFEB63-A6C8-4DD8-ACC1-78FBC2F13B06      131250  2015-03-23  PO30 5EA   \n",
        "3   9E7C8589-AA2C-4C22-8866-D24D0BA83DAB      138000  2015-03-23  PO30 5LQ   \n",
        "4   015A866D-0B09-4094-88F9-1AF1C3BB9E23      185000  2015-03-20  PO30 5QZ   \n",
        "5   23E6F9E1-D49F-4171-896A-F6FF6A528649       55000  2015-03-20  PO31 7NE   \n",
        "6   C5303863-493A-400D-8379-6A91F238B8F1      220000  2015-03-20  PO31 8PN   \n",
        "7   ACBBDA71-A1EC-43CA-9ADA-16BC5AFBDFD5      160000  2015-03-20  PO32 6QD   \n",
        "8   1D11F427-E67B-4B0F-8991-D4CB55589787      197500  2015-03-20  PO32 6TH   \n",
        "9   FA6265A9-2444-458D-BD3A-0458C70C6A55      190000  2015-03-23  PO33 1DP   \n",
        "10  16FBB1EA-4CE2-4268-86BD-30744169102A      213300  2015-03-24  PO33 1NG   \n",
        "11  245609C0-688B-42EB-AF8C-CF55C41F6AFD      267000  2015-03-23  PO33 2DQ   \n",
        "12  BD9BC2EA-514A-4F93-AF37-8A64E5C0745B       58000  2015-03-20  PO33 2EN   \n",
        "13  CBA136E9-0F29-4677-9758-03B72E546009      200000  2015-03-20  PO33 3XB   \n",
        "14  0D7C9A2E-7B6F-4C65-B7B0-822D90AFED68       95000  2015-03-27  PO36 9JL   \n",
        "15  B90DB134-265E-468E-9870-A4EF2374871E      165000  2015-03-23  PO36 9QF   \n",
        "16  ABD634BB-38E9-4604-810F-2F4DE3435362      275000  2015-03-26  PO37 6QE   \n",
        "17  77F30FEF-D220-43DD-97BC-557805EBCBF5      150000  2015-03-20  PO37 7EZ   \n",
        "18  3B081B44-CA73-4AAE-BBE1-F18F65A27326      355000  2015-03-18  PO37 7NU   \n",
        "19  DB6452D2-09C7-48C0-BA84-81DF28F0565D      182000  2015-03-20  PO38 1AL   \n",
        "20  35877ACA-D46A-4EE8-A8EF-B3D73445E0BD      132000  2015-03-19  PO38 1NR   \n",
        "21  9E805CB1-D055-44FC-B44F-B71ABF65F98F      164000  2015-03-24  PO38 1QJ   \n",
        "22  E41D3721-AAEE-4810-95C7-746CDACD01E2      332000  2015-03-19  PO38 1TX   \n",
        "23  53F9645F-927C-4A83-9EB3-EACA9800302E      250000  2015-03-20  PO38 3AX   \n",
        "24  32CF15DE-72B7-4241-945C-A93E869743B5      117000  2015-03-20  PO39 0EJ   \n",
        "25  6E0A8F6C-6AA0-42E7-8309-C899EF1F0125      228000  2015-03-24  PO41 0SX   \n",
        "\n",
        "   property_type new_build estate_type     saon           paon  \\\n",
        "0              D         N           F      NaN              5   \n",
        "1              S         N           F      NaN              6   \n",
        "2              T         N           F      NaN             98   \n",
        "3              S         N           F      NaN            151   \n",
        "4              D         N           F      NaN             13   \n",
        "5              D         N           F      NaN            204   \n",
        "6              D         N           F      NaN              5   \n",
        "7              D         N           F      NaN              4   \n",
        "8              D         N           F      NaN             96   \n",
        "9              S         N           F      NaN              5   \n",
        "10             S         N           F      NaN             24   \n",
        "11             D         N           F      NaN              9   \n",
        "12             F         N           L   FLAT 3             44   \n",
        "13             D         N           F      NaN              1   \n",
        "14             D         N           F      NaN            39A   \n",
        "15             S         N           F      NaN             21   \n",
        "16             T         N           F      NaN              3   \n",
        "17             S         N           F      NaN            113   \n",
        "18             D         N           F      NaN    BATTS LODGE   \n",
        "19             D         N           F      NaN              1   \n",
        "20             F         N           L   FLAT 3     THE MAPLES   \n",
        "21             F         N           L  FLAT 16  MADEIRA COURT   \n",
        "22             D         N           F      NaN              7   \n",
        "23             D         N           F      NaN       PITVILLE   \n",
        "24             F         N           L   FLAT 3     HURST VIEW   \n",
        "25             D         N           F      NaN      THE MANSE   \n",
        "\n",
        "               street  locality         town       district         county  \\\n",
        "0       CYNTHIA GROVE       NaN      NEWPORT  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "1       CYNTHIA GROVE       NaN      NEWPORT  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "2        CAESARS ROAD       NaN      NEWPORT  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "3       GUNVILLE ROAD       NaN      NEWPORT  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "4         HINTON ROAD       NaN      NEWPORT  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "5           PARK ROAD       NaN        COWES  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "6   CORONATION AVENUE       NaN        COWES  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "7       VEREKER DRIVE       NaN   EAST COWES  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "8       SYLVAN AVENUE       NaN   EAST COWES  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "9       BANBURY CLOSE       NaN         RYDE  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "10      MARINA AVENUE       NaN         RYDE  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "11    ALDERMORE CLOSE       NaN         RYDE  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "12      GEORGE STREET       NaN         RYDE  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "13      BIRCH GARDENS  BINSTEAD         RYDE  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "14       SANDOWN ROAD      LAKE      SANDOWN  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "15    HOME FARM CLOSE       NaN      SANDOWN  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "16     WESTCOMBE PARK       NaN     SHANKLIN  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "17         GREEN LANE       NaN     SHANKLIN  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "18         BATTS ROAD       NaN     SHANKLIN  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "19           DOWNSIDE       NaN      VENTNOR  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "20       MAPLES DRIVE       NaN      VENTNOR  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "21       MADEIRA ROAD       NaN      VENTNOR  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "22       TWINING ROAD       NaN      VENTNOR  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "23           REW LANE       NaN      VENTNOR  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "24          EDEN ROAD       NaN  TOTLAND BAY  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "25          MAIN ROAD   THORLEY     YARMOUTH  ISLE OF WIGHT  ISLE OF WIGHT   \n",
        "\n",
        "                                      linked_data_uri  \n",
        "0   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "1   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "2   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "3   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "4   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "5   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "6   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "7   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "8   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "9   http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "10  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "11  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "12  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "13  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "14  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "15  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "16  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "17  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "18  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "19  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "20  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "21  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "22  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "23  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "24  http://landregistry.data.gov.uk/data/ppi/trans...  \n",
        "25  http://landregistry.data.gov.uk/data/ppi/trans...  "
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#do an approximap geolocated by postcode rather than house number + postcode\n",
      "import folium"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import requests\n",
      "import json\n",
      "\n",
      "url='http://uk-postcodes.com/postcode/PO377EZ.json'\n",
      "json.loads(requests.get(url).content)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "{u'administrative': {u'constituency': {u'code': u'E14000762',\n",
        "   u'title': u'Isle of Wight',\n",
        "   u'uri': u'http://statistics.data.gov.uk/id/statistical-geography/E14000762'},\n",
        "  u'council': {u'code': u'E06000046',\n",
        "   u'title': u'Isle of Wight',\n",
        "   u'uri': u'http://statistics.data.gov.uk/id/statistical-geography/E06000046'},\n",
        "  u'parish': {u'code': u'E04001313',\n",
        "   u'title': u'Shanklin',\n",
        "   u'uri': u'http://statistics.data.gov.uk/id/statistical-geography/E04001313'}},\n",
        " u'geo': {u'easting': 458519.0,\n",
        "  u'geohash': u'http://geohash.org/gcp0j6cm3jjr',\n",
        "  u'lat': 50.64103548498601,\n",
        "  u'lng': -1.1737705157507463,\n",
        "  u'northing': 82697.0},\n",
        " u'postcode': u'PO37 7EZ'}"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import time\n",
      "\n",
      "pclookup={}\n",
      "for pc in df2['postcode'].unique():\n",
      "    time.sleep(1)\n",
      "    print(pc,)\n",
      "    url='http://uk-postcodes.com/postcode/{pc}.json'.format(pc=pc.replace(' ',''))\n",
      "    jdata=json.loads(requests.get(url).content)\n",
      "    pclookup[pc]={'data':jdata,'lat':jdata['geo']['lat'], 'lng':jdata['geo']['lng']}"
     ],
     "language": "python",
     "metadata": {},
     "outputs": []
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df2['lat']=df2['postcode'].apply(lambda x: pclookup[x]['lat'])\n",
      "df2['lon']=df2['postcode'].apply(lambda x: pclookup[x]['lng'])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 23
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Probably need to install folium\n",
      "#!pip install folium\n",
      "\n",
      "#A couple of standard helper routines to preview the maps.\n",
      "\n",
      "from IPython.display import HTML\n",
      "\n",
      "import folium\n",
      "reload(folium)\n",
      "\n",
      "def mapfix(path):\n",
      "    f=open(path,'r')\n",
      "    html=f.read()\n",
      "    f.close()\n",
      "    html=html.replace('\"//','\"http://')\n",
      "    f=open(path,'w')\n",
      "    f.write(html)\n",
      "    f.close()\n",
      "    \n",
      "def inline_map(map):\n",
      "    \"\"\"\n",
      "    Embeds the HTML source of the map directly into the IPython notebook.\n",
      "    \n",
      "    This method will not work if the map depends on any files (json data). Also this uses\n",
      "    the HTML5 srcdoc attribute, which may not be supported in all browsers.\n",
      "    \"\"\"\n",
      "    map._build_map()\n",
      "    return HTML('<iframe srcdoc=\"{srcdoc}\" style=\"width: 100%; height: 510px; border: none\"></iframe>'.format(srcdoc=map.HTML.replace('\"', '&quot;')))\n",
      "\n",
      "#The embed_map approach saves an HTML file that generates the map if you access if access it via a webserver\n",
      "#The server stuff is all handled for you when viewing the map in an IPython notebook\n",
      "def embed_map(map, path=\"map.html\"):\n",
      "    \"\"\"\n",
      "    Embeds a linked iframe to the map into the IPython notebook.\n",
      "    \n",
      "    Note: this method will not capture the source of the map into the notebook.\n",
      "    This method should work for all maps (as long as they use relative urls).\n",
      "    \"\"\"\n",
      "    map.create_map(path=path)\n",
      "    mapfix(path)\n",
      "    return HTML('<iframe src=\"files/{path}\" style=\"width: 100%; height: 510px; border: none\"></iframe>'.format(path=path))\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 24
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def mapper(tmp,df):\n",
      "    for row in df[ df['lon'].notnull() ].iterrows():\n",
      "        #print(row[1]['lon'],row[1]['lat'])\n",
      "        #Define a template that will contain information in the pop-up marker\n",
      "        template='<strong>{price}</strong><br/>Date: {date}<br/><em>Location:</em> {location}'\n",
      "        tmp.simple_marker([row[1]['lat'], row[1]['lon']],\n",
      "                          popup=template.format(price='\u00a3{:,}'.format(row[1]['price_paid']),\n",
      "                                                date=row[1]['deed_date'],\n",
      "                                                location='{}, {}'.format(row[1]['paon'],row[1]['street'])\n",
      "                                                ),\n",
      "                          #This parameter switches on a feature of the leafle map library that auto-clusters numerous close markers\n",
      "                          clustered_marker=True)\n",
      "    return tmp\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 35
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Create a base map - I'm guessing the mid-pointlat-long - we should create it from the data...\n",
      "longm=df2[ df2['lon'].notnull() ]['lon'].mean()\n",
      "latm=df2[ df2['lat'].notnull() ]['lat'].mean()\n",
      "\n",
      "pricesmap = folium.Map(location=[latm, longm], zoom_start=11)\n",
      "pricesmap=mapper(pricesmap,df2)\n",
      "#An example of generating the \"inline\" preview map\n",
      "inline_map(pricesmap)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<iframe srcdoc=\"<!DOCTYPE html>\n",
        "<head>\n",
        "   <meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; />\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet/0.7.3/leaflet.css&quot; />\n",
        "   <script src=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet/0.7.3/leaflet.js&quot;></script>\n",
        "\n",
        "   <script src=&quot;//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js&quot;></script>\n",
        "\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;>\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;>\n",
        "   <script src=&quot;//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js&quot;></script>\n",
        "\n",
        "   <link href=&quot;//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css&quot; rel=&quot;stylesheet&quot;>\n",
        "\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//rawgit.com/lvoogdt/Leaflet.awesome-markers/2.0/develop/dist/leaflet.awesome-markers.css&quot;>\n",
        "   <script src=&quot;//rawgithub.com/lvoogdt/Leaflet.awesome-markers/2.0/develop/dist/leaflet.awesome-markers.js&quot;></script>\n",
        "\n",
        "\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/0.4.0/MarkerCluster.Default.css&quot;>\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/0.4.0/MarkerCluster.css&quot;>\n",
        "   <script src=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/0.4.0/leaflet.markercluster-src.js&quot;></script>\n",
        "   <script src=&quot;//cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/0.4.0/leaflet.markercluster.js&quot;></script>\n",
        "\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;//birdage.github.io/Leaflet.awesome-markers/dist/leaflet.awesome.rotate.css&quot;>\n",
        "\n",
        "   \n",
        "   \n",
        "   \n",
        "   \n",
        "\n",
        "   <style>\n",
        "\n",
        "      html, body {\n",
        "        width: 100%;\n",
        "        height: 100%;\n",
        "        margin: 0;\n",
        "        padding: 0;\n",
        "      }\n",
        "\n",
        "      #map {\n",
        "        position:absolute;\n",
        "        top:0;\n",
        "        bottom:0;\n",
        "        right:0;\n",
        "        left:0;\n",
        "      }\n",
        "\n",
        "   </style>\n",
        "</head>\n",
        "\n",
        "<body>\n",
        "\n",
        "   <div class=&quot;folium-map&quot; id=&quot;folium_002857a8870744b6a1bd47210e2ef9f6&quot; style=&quot;width: 960px; height: 500px&quot;></div>\n",
        "\n",
        "   <script>\n",
        "\n",
        "      \n",
        "\n",
        "      var base_tile = L.tileLayer('http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {\n",
        "          maxZoom: 18,\n",
        "          minZoom: 1,\n",
        "          attribution: 'Map data (c) <a href=&quot;http://openstreetmap.org&quot;>OpenStreetMap</a> contributors'\n",
        "      });\n",
        "\n",
        "      var baseLayer = {\n",
        "        &quot;Base Layer&quot;: base_tile\n",
        "      };\n",
        "\n",
        "      /*\n",
        "      addition of the wms layers\n",
        "      */\n",
        "\n",
        "      \n",
        "\n",
        "      /*\n",
        "      addition of the tile layers\n",
        "      */\n",
        "      \n",
        "\n",
        "      /*\n",
        "      list of layers to be added\n",
        "      */\n",
        "      var layer_list = {\n",
        "      \n",
        "      };\n",
        "\n",
        "      /*\n",
        "      Bounding box.\n",
        "      */\n",
        "      var southWest = L.latLng(-90, -180),\n",
        "          northEast = L.latLng(90, 180),\n",
        "          bounds = L.latLngBounds(southWest, northEast);\n",
        "\n",
        "      /*\n",
        "      Creates the map and adds the selected layers\n",
        "      */\n",
        "      var map = L.map('folium_002857a8870744b6a1bd47210e2ef9f6', {\n",
        "                                       center:[50.6797832633, -1.24772088148],\n",
        "                                       zoom: 11,\n",
        "                                       maxBounds: bounds,\n",
        "                                       layers: [base_tile]\n",
        "                                     });\n",
        "\n",
        "      L.control.layers(baseLayer, layer_list).addTo(map);\n",
        "\n",
        "      //cluster group\n",
        "      var clusteredmarkers = L.markerClusterGroup();\n",
        "      //section for adding clustered markers\n",
        "      \n",
        "      var marker_1_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_1 = L.marker([50.7027922548, \n",
        "\t\t\t\t\t\t\t-1.28281421748],\n",
        "\t\t\t\t\t\t\t{'icon':marker_1_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_1.bindPopup(&quot;<strong>\\u00a3167,500</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 5, CYNTHIA GROVE&quot;);\n",
        "      marker_1._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_1)\n",
        "      \n",
        "      var marker_2_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_2 = L.marker([50.7027922548, \n",
        "\t\t\t\t\t\t\t-1.28281421748],\n",
        "\t\t\t\t\t\t\t{'icon':marker_2_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_2.bindPopup(&quot;<strong>\\u00a3177,000</strong><br/>Date: 2015-03-26<br/><em>Location:</em> 6, CYNTHIA GROVE&quot;);\n",
        "      marker_2._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_2)\n",
        "      \n",
        "      var marker_3_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_3 = L.marker([50.6987974697, \n",
        "\t\t\t\t\t\t\t-1.30174974696],\n",
        "\t\t\t\t\t\t\t{'icon':marker_3_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_3.bindPopup(&quot;<strong>\\u00a3131,250</strong><br/>Date: 2015-03-23<br/><em>Location:</em> 98, CAESARS ROAD&quot;);\n",
        "      marker_3._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_3)\n",
        "      \n",
        "      var marker_4_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_4 = L.marker([50.6966913105, \n",
        "\t\t\t\t\t\t\t-1.321235283],\n",
        "\t\t\t\t\t\t\t{'icon':marker_4_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_4.bindPopup(&quot;<strong>\\u00a3138,000</strong><br/>Date: 2015-03-23<br/><em>Location:</em> 151, GUNVILLE ROAD&quot;);\n",
        "      marker_4._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_4)\n",
        "      \n",
        "      var marker_5_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_5 = L.marker([50.6958143624, \n",
        "\t\t\t\t\t\t\t-1.30972283912],\n",
        "\t\t\t\t\t\t\t{'icon':marker_5_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_5.bindPopup(&quot;<strong>\\u00a3185,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 13, HINTON ROAD&quot;);\n",
        "      marker_5._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_5)\n",
        "      \n",
        "      var marker_6_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_6 = L.marker([50.7584615514, \n",
        "\t\t\t\t\t\t\t-1.30575385319],\n",
        "\t\t\t\t\t\t\t{'icon':marker_6_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_6.bindPopup(&quot;<strong>\\u00a355,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 204, PARK ROAD&quot;);\n",
        "      marker_6._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_6)\n",
        "      \n",
        "      var marker_7_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_7 = L.marker([50.7385761797, \n",
        "\t\t\t\t\t\t\t-1.30535338437],\n",
        "\t\t\t\t\t\t\t{'icon':marker_7_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_7.bindPopup(&quot;<strong>\\u00a3220,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 5, CORONATION AVENUE&quot;);\n",
        "      marker_7._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_7)\n",
        "      \n",
        "      var marker_8_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_8 = L.marker([50.757120394, \n",
        "\t\t\t\t\t\t\t-1.28178603732],\n",
        "\t\t\t\t\t\t\t{'icon':marker_8_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_8.bindPopup(&quot;<strong>\\u00a3160,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 4, VEREKER DRIVE&quot;);\n",
        "      marker_8._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_8)\n",
        "      \n",
        "      var marker_9_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_9 = L.marker([50.754957568, \n",
        "\t\t\t\t\t\t\t-1.27813324847],\n",
        "\t\t\t\t\t\t\t{'icon':marker_9_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_9.bindPopup(&quot;<strong>\\u00a3197,500</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 96, SYLVAN AVENUE&quot;);\n",
        "      marker_9._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_9)\n",
        "      \n",
        "      var marker_10_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_10 = L.marker([50.7202416374, \n",
        "\t\t\t\t\t\t\t-1.14706421256],\n",
        "\t\t\t\t\t\t\t{'icon':marker_10_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_10.bindPopup(&quot;<strong>\\u00a3190,000</strong><br/>Date: 2015-03-23<br/><em>Location:</em> 5, BANBURY CLOSE&quot;);\n",
        "      marker_10._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_10)\n",
        "      \n",
        "      var marker_11_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_11 = L.marker([50.724392389, \n",
        "\t\t\t\t\t\t\t-1.14407041091],\n",
        "\t\t\t\t\t\t\t{'icon':marker_11_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_11.bindPopup(&quot;<strong>\\u00a3213,300</strong><br/>Date: 2015-03-24<br/><em>Location:</em> 24, MARINA AVENUE&quot;);\n",
        "      marker_11._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_11)\n",
        "      \n",
        "      var marker_12_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_12 = L.marker([50.7179883196, \n",
        "\t\t\t\t\t\t\t-1.16499597523],\n",
        "\t\t\t\t\t\t\t{'icon':marker_12_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_12.bindPopup(&quot;<strong>\\u00a3267,000</strong><br/>Date: 2015-03-23<br/><em>Location:</em> 9, ALDERMORE CLOSE&quot;);\n",
        "      marker_12._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_12)\n",
        "      \n",
        "      var marker_13_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_13 = L.marker([50.7307645418, \n",
        "\t\t\t\t\t\t\t-1.16087239482],\n",
        "\t\t\t\t\t\t\t{'icon':marker_13_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_13.bindPopup(&quot;<strong>\\u00a358,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 44, GEORGE STREET&quot;);\n",
        "      marker_13._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_13)\n",
        "      \n",
        "      var marker_14_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_14 = L.marker([50.7262291167, \n",
        "\t\t\t\t\t\t\t-1.18452869368],\n",
        "\t\t\t\t\t\t\t{'icon':marker_14_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_14.bindPopup(&quot;<strong>\\u00a3200,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 1, BIRCH GARDENS&quot;);\n",
        "      marker_14._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_14)\n",
        "      \n",
        "      var marker_15_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_15 = L.marker([50.6489115974, \n",
        "\t\t\t\t\t\t\t-1.16846964946],\n",
        "\t\t\t\t\t\t\t{'icon':marker_15_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_15.bindPopup(&quot;<strong>\\u00a395,000</strong><br/>Date: 2015-03-27<br/><em>Location:</em> 39A, SANDOWN ROAD&quot;);\n",
        "      marker_15._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_15)\n",
        "      \n",
        "      var marker_16_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_16 = L.marker([50.6440591764, \n",
        "\t\t\t\t\t\t\t-1.17787558633],\n",
        "\t\t\t\t\t\t\t{'icon':marker_16_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_16.bindPopup(&quot;<strong>\\u00a3165,000</strong><br/>Date: 2015-03-23<br/><em>Location:</em> 21, HOME FARM CLOSE&quot;);\n",
        "      marker_16._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_16)\n",
        "      \n",
        "      var marker_17_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_17 = L.marker([50.6259865043, \n",
        "\t\t\t\t\t\t\t-1.18344990716],\n",
        "\t\t\t\t\t\t\t{'icon':marker_17_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_17.bindPopup(&quot;<strong>\\u00a3275,000</strong><br/>Date: 2015-03-26<br/><em>Location:</em> 3, WESTCOMBE PARK&quot;);\n",
        "      marker_17._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_17)\n",
        "      \n",
        "      var marker_18_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_18 = L.marker([50.641035485, \n",
        "\t\t\t\t\t\t\t-1.17377051575],\n",
        "\t\t\t\t\t\t\t{'icon':marker_18_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_18.bindPopup(&quot;<strong>\\u00a3150,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 113, GREEN LANE&quot;);\n",
        "      marker_18._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_18)\n",
        "      \n",
        "      var marker_19_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_19 = L.marker([50.6299532345, \n",
        "\t\t\t\t\t\t\t-1.18485166144],\n",
        "\t\t\t\t\t\t\t{'icon':marker_19_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_19.bindPopup(&quot;<strong>\\u00a3355,000</strong><br/>Date: 2015-03-18<br/><em>Location:</em> BATTS LODGE, BATTS ROAD&quot;);\n",
        "      marker_19._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_19)\n",
        "      \n",
        "      var marker_20_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_20 = L.marker([50.5973883485, \n",
        "\t\t\t\t\t\t\t-1.213460388],\n",
        "\t\t\t\t\t\t\t{'icon':marker_20_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_20.bindPopup(&quot;<strong>\\u00a3182,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> 1, DOWNSIDE&quot;);\n",
        "      marker_20._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_20)\n",
        "      \n",
        "      var marker_21_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_21 = L.marker([50.5995669107, \n",
        "\t\t\t\t\t\t\t-1.19405218286],\n",
        "\t\t\t\t\t\t\t{'icon':marker_21_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_21.bindPopup(&quot;<strong>\\u00a3132,000</strong><br/>Date: 2015-03-19<br/><em>Location:</em> THE MAPLES, MAPLES DRIVE&quot;);\n",
        "      marker_21._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_21)\n",
        "      \n",
        "      var marker_22_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_22 = L.marker([50.5974771446, \n",
        "\t\t\t\t\t\t\t-1.19226520057],\n",
        "\t\t\t\t\t\t\t{'icon':marker_22_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_22.bindPopup(&quot;<strong>\\u00a3164,000</strong><br/>Date: 2015-03-24<br/><em>Location:</em> MADEIRA COURT, MADEIRA ROAD&quot;);\n",
        "      marker_22._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_22)\n",
        "      \n",
        "      var marker_23_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_23 = L.marker([50.5880260977, \n",
        "\t\t\t\t\t\t\t-1.24325329206],\n",
        "\t\t\t\t\t\t\t{'icon':marker_23_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_23.bindPopup(&quot;<strong>\\u00a3332,000</strong><br/>Date: 2015-03-19<br/><em>Location:</em> 7, TWINING ROAD&quot;);\n",
        "      marker_23._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_23)\n",
        "      \n",
        "      var marker_24_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_24 = L.marker([50.6015800537, \n",
        "\t\t\t\t\t\t\t-1.22839697993],\n",
        "\t\t\t\t\t\t\t{'icon':marker_24_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_24.bindPopup(&quot;<strong>\\u00a3250,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> PITVILLE, REW LANE&quot;);\n",
        "      marker_24._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_24)\n",
        "      \n",
        "      var marker_25_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_25 = L.marker([50.679196825, \n",
        "\t\t\t\t\t\t\t-1.54413680516],\n",
        "\t\t\t\t\t\t\t{'icon':marker_25_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_25.bindPopup(&quot;<strong>\\u00a3117,000</strong><br/>Date: 2015-03-20<br/><em>Location:</em> HURST VIEW, EDEN ROAD&quot;);\n",
        "      marker_25._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_25)\n",
        "      \n",
        "      var marker_26_icon = L.AwesomeMarkers.icon({ icon: 'info-sign',markerColor: 'blue',prefix: 'glyphicon',extraClasses: 'fa-rotate-0'});\n",
        "      var marker_26 = L.marker([50.6955641175, \n",
        "\t\t\t\t\t\t\t-1.46586623521],\n",
        "\t\t\t\t\t\t\t{'icon':marker_26_icon}\n",
        "\t\t\t\t\t\t\t);\n",
        "      marker_26.bindPopup(&quot;<strong>\\u00a3228,000</strong><br/>Date: 2015-03-24<br/><em>Location:</em> THE MANSE, MAIN ROAD&quot;);\n",
        "      marker_26._popup.options.maxWidth = 300;\n",
        "      clusteredmarkers.addLayer(marker_26)\n",
        "      \n",
        "      //add the clustered markers to the group anyway\n",
        "      map.addLayer(clusteredmarkers);\n",
        "\n",
        "      \n",
        "\n",
        "      \n",
        "\n",
        "      \n",
        "\n",
        "      \n",
        "\n",
        "      \n",
        "\n",
        "      \n",
        "\n",
        "   </script>\n",
        "\n",
        "</body>\" style=\"width: 100%; height: 510px; border: none\"></iframe>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 36,
       "text": [
        "<IPython.core.display.HTML at 0x10d6cf510>"
       ]
      }
     ],
     "prompt_number": 36
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}