cudf_pandas.ipynb

{"cells":[{"cell_type":"markdown","metadata":{},"source":["# Testing CuDF's GPU acceleration w/ Pandas dataframes\n","\n","Dataset used: UK property price data from Kaggle:\n","\n","https://www.kaggle.com/datasets/willianoliveiragibin/uk-property-price-data-1995-2023-04/data"]},{"cell_type":"code","execution_count":1,"metadata":{},"outputs":[],"source":["%load_ext cudf.pandas"]},{"cell_type":"markdown","metadata":{},"source":["First, we'll import the data and look at it. \n","\n","Note the datatype for price. We're explicitly setting this, due to the original dataset being parsed as a string. "]},{"cell_type":"code","execution_count":2,"metadata":{},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Transaction_unique_identifier</th>\n","      <th>price</th>\n","      <th>Date_of_Transfer</th>\n","      <th>postcode</th>\n","      <th>Property_Type</th>\n","      <th>Old/New</th>\n","      <th>Duration</th>\n","      <th>PAON</th>\n","      <th>SAON</th>\n","      <th>Street</th>\n","      <th>Locality</th>\n","      <th>Town/City</th>\n","      <th>District</th>\n","      <th>County</th>\n","      <th>PPDCategory_Type</th>\n","      <th>Record_Status - monthly_file_only</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>28276223</th>\n","      <td>{F3B6C198-17C3-6E40-E053-6C04A8C0B3B4}</td>\n","      <td>490000</td>\n","      <td>2023-01-13 00:00</td>\n","      <td>RM1 4SR</td>\n","      <td>T</td>\n","      <td>N</td>\n","      <td>F</td>\n","      <td>12</td>\n","      <td>None</td>\n","      <td>HEATHER GLEN</td>\n","      <td>None</td>\n","      <td>ROMFORD</td>\n","      <td>HAVERING</td>\n","      <td>GREATER LONDON</td>\n","      <td>A</td>\n","      <td>A</td>\n","    </tr>\n","    <tr>\n","      <th>28276224</th>\n","      <td>{F3B6C198-17C9-6E40-E053-6C04A8C0B3B4}</td>\n","      <td>365000</td>\n","      <td>2023-01-10 00:00</td>\n","      <td>SS2 4UA</td>\n","      <td>F</td>\n","      <td>N</td>\n","      <td>L</td>\n","      <td>CENTENARY PLACE, 1</td>\n","      <td>FLAT 22</td>\n","      <td>SOUTHCHURCH BOULEVARD</td>\n","      <td>None</td>\n","      <td>SOUTHEND-ON-SEA</td>\n","      <td>SOUTHEND-ON-SEA</td>\n","      <td>SOUTHEND-ON-SEA</td>\n","      <td>A</td>\n","      <td>A</td>\n","    </tr>\n","    <tr>\n","      <th>28276225</th>\n","      <td>{F3B6C198-17D8-6E40-E053-6C04A8C0B3B4}</td>\n","      <td>730000</td>\n","      <td>2023-01-05 00:00</td>\n","      <td>CO13 0EY</td>\n","      <td>S</td>\n","      <td>N</td>\n","      <td>F</td>\n","      <td>HIGH VIEW</td>\n","      <td>None</td>\n","      <td>LITTLE CLACTON ROAD</td>\n","      <td>GREAT HOLLAND</td>\n","      <td>FRINTON-ON-SEA</td>\n","      <td>TENDRING</td>\n","      <td>ESSEX</td>\n","      <td>A</td>\n","      <td>A</td>\n","    </tr>\n","    <tr>\n","      <th>28276226</th>\n","      <td>{F3B6C198-1807-6E40-E053-6C04A8C0B3B4}</td>\n","      <td>379000</td>\n","      <td>2023-01-06 00:00</td>\n","      <td>CO15 5NA</td>\n","      <td>D</td>\n","      <td>N</td>\n","      <td>F</td>\n","      <td>12</td>\n","      <td>None</td>\n","      <td>DULWICH ROAD</td>\n","      <td>HOLLAND-ON-SEA</td>\n","      <td>CLACTON-ON-SEA</td>\n","      <td>TENDRING</td>\n","      <td>ESSEX</td>\n","      <td>A</td>\n","      <td>A</td>\n","    </tr>\n","    <tr>\n","      <th>28276227</th>\n","      <td>{F3B6C198-182F-6E40-E053-6C04A8C0B3B4}</td>\n","      <td>450000</td>\n","      <td>2023-01-05 00:00</td>\n","      <td>CO7 7PZ</td>\n","      <td>D</td>\n","      <td>N</td>\n","      <td>F</td>\n","      <td>21</td>\n","      <td>None</td>\n","      <td>INGRAMS PIECE</td>\n","      <td>ARDLEIGH</td>\n","      <td>COLCHESTER</td>\n","      <td>TENDRING</td>\n","      <td>ESSEX</td>\n","      <td>A</td>\n","      <td>A</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                   Transaction_unique_identifier   price  Date_of_Transfer  \\\n","28276223  {F3B6C198-17C3-6E40-E053-6C04A8C0B3B4}  490000  2023-01-13 00:00   \n","28276224  {F3B6C198-17C9-6E40-E053-6C04A8C0B3B4}  365000  2023-01-10 00:00   \n","28276225  {F3B6C198-17D8-6E40-E053-6C04A8C0B3B4}  730000  2023-01-05 00:00   \n","28276226  {F3B6C198-1807-6E40-E053-6C04A8C0B3B4}  379000  2023-01-06 00:00   \n","28276227  {F3B6C198-182F-6E40-E053-6C04A8C0B3B4}  450000  2023-01-05 00:00   \n","\n","          postcode Property_Type Old/New Duration                PAON  \\\n","28276223   RM1 4SR             T       N        F                  12   \n","28276224   SS2 4UA             F       N        L  CENTENARY PLACE, 1   \n","28276225  CO13 0EY             S       N        F           HIGH VIEW   \n","28276226  CO15 5NA             D       N        F                  12   \n","28276227   CO7 7PZ             D       N        F                  21   \n","\n","             SAON                 Street        Locality        Town/City  \\\n","28276223     <NA>           HEATHER GLEN            <NA>          ROMFORD   \n","28276224  FLAT 22  SOUTHCHURCH BOULEVARD            <NA>  SOUTHEND-ON-SEA   \n","28276225     <NA>    LITTLE CLACTON ROAD   GREAT HOLLAND   FRINTON-ON-SEA   \n","28276226     <NA>           DULWICH ROAD  HOLLAND-ON-SEA   CLACTON-ON-SEA   \n","28276227     <NA>          INGRAMS PIECE        ARDLEIGH       COLCHESTER   \n","\n","                 District           County PPDCategory_Type  \\\n","28276223         HAVERING   GREATER LONDON                A   \n","28276224  SOUTHEND-ON-SEA  SOUTHEND-ON-SEA                A   \n","28276225         TENDRING            ESSEX                A   \n","28276226         TENDRING            ESSEX                A   \n","28276227         TENDRING            ESSEX                A   \n","\n","         Record_Status - monthly_file_only  \n","28276223                                 A  \n","28276224                                 A  \n","28276225                                 A  \n","28276226                                 A  \n","28276227                                 A  "]},"execution_count":2,"metadata":{},"output_type":"execute_result"}],"source":["import pandas as pd\n","import numpy as np\n","\n","df = pd.read_csv('202304.csv',\n","                 names=['Transaction_unique_identifier', 'price', 'Date_of_Transfer', \n","                        'postcode', 'Property_Type', 'Old/New',\n","                        'Duration', 'PAON', 'SAON', 'Street', 'Locality', \n","                        'Town/City', 'District', 'County', 'PPDCategory_Type',\n","                        'Record_Status - monthly_file_only'],\n","    dtype={'price': \"int64\"},\n",")\n","\n","df.tail()"]},{"cell_type":"code","execution_count":3,"metadata":{},"outputs":[{"data":{"text/plain":["28276228"]},"execution_count":3,"metadata":{},"output_type":"execute_result"}],"source":["len(df)"]},{"cell_type":"markdown","metadata":{},"source":["A simple operation to find unique values. In this case, we're going to grab for unique Towns/Cities."]},{"cell_type":"code","execution_count":12,"metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["1172\n"]}],"source":["# get unique values for a given column:\n","which_unique_col = 'Town/City'\n","uniques = df[which_unique_col].unique()\n","print(len(uniques))"]},{"cell_type":"code","execution_count":5,"metadata":{},"outputs":[{"data":{"text/plain":["array(['MILTON KEYNES', 'SUNDERLAND', 'COLCHESTER', 'SOLIHULL',\n","       'BRIERLEY HILL', 'ROTHERHAM', 'PETERBOROUGH', 'MACCLESFIELD',\n","       'SWANSEA', 'NORWICH'], dtype=object)"]},"execution_count":5,"metadata":{},"output_type":"execute_result"}],"source":["uniques[:10]"]},{"cell_type":"markdown","metadata":{},"source":["Now let's do a slightly more complicated operation. We're going to find the average price for each town/city."]},{"cell_type":"code","execution_count":6,"metadata":{},"outputs":[{"data":{"text/plain":["{'MILTON KEYNES': 216739.41150756637,\n"," 'SUNDERLAND': 115812.21776881721,\n"," 'COLCHESTER': 210157.37292512273,\n"," 'SOLIHULL': 267353.89040272235,\n"," 'BRIERLEY HILL': 123870.11858684511,\n"," 'ROTHERHAM': 114841.08626248685,\n"," 'PETERBOROUGH': 163094.3706850924,\n"," 'MACCLESFIELD': 217603.70160925775,\n"," 'SWANSEA': 134776.42491041098,\n"," 'NORWICH': 184368.1999814746,\n"," 'WALSALL': 148149.57452609713,\n"," 'CHELTENHAM': 250695.22364971685,\n"," 'BECKENHAM': 316173.69662884175,\n"," 'LIVERPOOL': 141620.56214913898,\n"," 'LONDON': 483432.5411589882,\n"," 'NORTHOLT': 198671.39874440577,\n"," 'BLACKPOOL': 99818.77619084086,\n"," 'CORBRIDGE': 294325.6781609195,\n"," 'WORCESTER': 193647.59425942213,\n"," 'SLEAFORD': 140652.94869503705,\n"," 'BRISTOL': 219496.40882534074,\n"," 'SWINDON': 186213.48524310335,\n"," 'CHERTSEY': 326504.30302743614,\n"," 'LUTON': 164208.85756279257,\n"," 'MANCHESTER': 149823.8309340425,\n"," 'HOVE': 258300.5027065111,\n"," 'ASHBY-DE-LA-ZOUCH': 215109.7623155505,\n"," 'SUTTON COLDFIELD': 241525.34700516576,\n"," 'KETTERING': 163202.93254076378,\n"," 'CHALFONT ST. GILES': 437958.9143646409,\n"," 'BELPER': 167568.45187084438,\n"," 'HEREFORD': 186890.06691380907,\n"," 'CHIPPING NORTON': 327808.76093044964,\n"," 'DOVER': 164079.25551173708,\n"," 'REIGATE': 382539.8836122214,\n"," 'OLDHAM': 109637.92848598868,\n"," 'SOUTHWELL': 254201.56788224957,\n"," 'STREET': 165080.99020156774,\n"," 'COVENTRY': 152093.7878687234,\n"," 'MARGATE': 153255.18888450926,\n"," 'CHATHAM': 160132.76549199488,\n"," 'SHEFFIELD': 150793.3703689945,\n"," 'STOCKPORT': 178610.9107444469,\n"," 'LEICESTER': 163675.3222444306,\n"," 'HULL': 101564.28843891839,\n"," 'ILFORD': 237876.21392520337,\n"," 'BOURNEMOUTH': 197816.1755661798,\n"," 'FARNBOROUGH': 219309.32478413815,\n"," 'BOGNOR REGIS': 199370.3540128446,\n"," 'BLACKWOOD': 116523.05632297946,\n"," 'STOKE-ON-TRENT': 114996.49601066836,\n"," 'NOTTINGHAM': 153534.69793422817,\n"," 'READING': 278841.3290154557,\n"," 'NEWPORT': 148116.75877608455,\n"," 'PRESTON': 148834.24395517027,\n"," 'IPSWICH': 179038.47084210618,\n"," 'CANVEY ISLAND': 167513.07309423844,\n"," 'LEIGH-ON-SEA': 225195.30227649142,\n"," 'BECCLES': 178106.0429494812,\n"," 'SHEERNESS': 158556.01081330396,\n"," 'HAVERHILL': 166764.9628192693,\n"," 'MAIDENHEAD': 374851.5233915954,\n"," 'SUTTON': 263366.3532705473,\n"," 'WESTON-SUPER-MARE': 156853.37655675292,\n"," 'BEVERLEY': 164012.00603363753,\n"," 'BILLINGHAM': 140540.00670596506,\n"," 'PICKERING': 193468.4033412888,\n"," 'LEIGH': 104354.8083478117,\n"," 'MANSFIELD': 117146.41398129998,\n"," 'BRIGHTON': 246028.9378888786,\n"," 'SELBY': 155746.9728353816,\n"," 'NORTHAMPTON': 182097.31012595457,\n"," 'HALIFAX': 119253.56452785304,\n"," 'NUNEATON': 156244.58526843405,\n"," 'OSWESTRY': 158249.2259822623,\n"," 'JARROW': 100161.28519762335,\n"," 'WREXHAM': 140063.94864901196,\n"," 'OXFORD': 339480.7988071735,\n"," 'TAMWORTH': 161055.84897891962,\n"," 'UXBRIDGE': 329737.81487231236,\n"," 'BROXBOURNE': 277719.8212864027,\n"," 'COBHAM': 736475.8389057751,\n"," 'BOOTLE': 81921.94121719066,\n"," 'SOUTHSEA': 157247.37956890572,\n"," 'NEWCASTLE UPON TYNE': 167100.18837235417,\n"," 'GRAYS': 193521.71361779392,\n"," 'MIDDLEWICH': 165039.5414555256,\n"," 'CLEATOR MOOR': 92162.0474049857,\n"," 'WISBECH': 148727.47427106695,\n"," 'CARNFORTH': 195036.52505301425,\n"," 'YEOVIL': 171197.06237539163,\n"," 'SLOUGH': 251144.99038087443,\n"," 'BRACKNELL': 260266.7955406587,\n"," 'DONCASTER': 122843.20222572876,\n"," 'THORNTON-CLEVELEYS': 118101.21255368799,\n"," 'PUDSEY': 143635.21649615286,\n"," 'FELIXSTOWE': 171501.6341867642,\n"," 'BARRY': 135176.73180505628,\n"," 'SCARBOROUGH': 131658.681723768,\n"," 'PETERSFIELD': 335587.50433952437,\n"," 'PENZANCE': 184579.04330938047,\n"," 'BUCKLEY': 132641.10098619328,\n"," 'HARROGATE': 245554.01644913593,\n"," 'COTTINGHAM': 160091.64461809376,\n"," 'LITTLEHAMPTON': 212571.80128537124,\n"," 'STOURBRIDGE': 188142.16322414464,\n"," 'LEAMINGTON SPA': 228688.95939616108,\n"," 'NEWTON-LE-WILLOWS': 125302.3970329394,\n"," 'WARRINGTON': 163447.526551905,\n"," 'BURGESS HILL': 238023.67580798242,\n"," 'ALTON': 322214.6662974407,\n"," 'TELFORD': 136116.44103672268,\n"," 'BALDOCK': 227440.88178657394,\n"," 'DUNSTABLE': 209817.05667711922,\n"," 'NEWBURY': 289751.035599835,\n"," 'CHARD': 179356.40024904386,\n"," 'WILMSLOW': 287376.43646816036,\n"," 'DIDCOT': 238655.4334243495,\n"," 'SOUTHAMPTON': 202537.59887743916,\n"," 'GRANTHAM': 158274.8560131345,\n"," 'NEWMARKET': 244231.89159316735,\n"," 'MIDHURST': 356544.03731343284,\n"," 'BIRMINGHAM': 154994.64025603863,\n"," 'OXTED': 442440.27547531115,\n"," 'PORTHCAWL': 184206.91034398632,\n"," 'SEVENOAKS': 425031.6721005908,\n"," 'CHELMSFORD': 251278.78684384964,\n"," 'WALLASEY': 102464.72015675584,\n"," 'BUCKINGHAM': 257381.1635557389,\n"," 'BRENTWOOD': 331995.6227008332,\n"," 'COLWYN BAY': 141221.22897094165,\n"," 'LINCOLN': 146885.57971575792,\n"," 'BOREHAMWOOD': 301580.7885142314,\n"," 'ADDLESTONE': 273135.45185800025,\n"," 'LOUGHBOROUGH': 176795.89942963384,\n"," 'CARSHALTON': 244575.90251503553,\n"," 'BRACKLEY': 226469.26142907928,\n"," 'ENFIELD': 247728.26977023235,\n"," 'DAGENHAM': 181271.23039637823,\n"," 'BURNLEY': 86644.08754298688,\n"," 'CROYDON': 255160.24276443772,\n"," 'BRADFORD': 101726.87201248846,\n"," 'THORNTON HEATH': 200476.40534213686,\n"," 'MITCHAM': 206484.7946009904,\n"," 'ROMFORD': 231457.36343030853,\n"," 'RICHMOND': 471152.4328147492,\n"," 'WEST DRAYTON': 266885.144080199,\n"," 'BELVEDERE': 232822.30975260682,\n"," 'GREENFORD': 265384.16800720285,\n"," 'HAYES': 249458.83338607594,\n"," 'ORPINGTON': 306842.41660380806,\n"," 'BROMLEY': 307533.45034586353,\n"," 'ERITH': 189227.4752792964,\n"," 'PURLEY': 363993.5209806695,\n"," 'HERNE BAY': 193444.40006015296,\n"," 'STANMORE': 400743.15108640725,\n"," 'SOUTH CROYDON': 273767.706946173,\n"," 'HARROW': 282697.1565065768,\n"," 'BARNET': 377876.0019952372,\n"," 'SURBITON': 329447.2272125109,\n"," 'WIRRAL': 168521.60762359732,\n"," 'ALDERSHOT': 206119.84939778384,\n"," 'MALDON': 222869.8906018224,\n"," 'NEWARK': 161029.3484892205,\n"," 'HARLESTON': 192753.30655209452,\n"," 'BURTON-ON-TRENT': 158449.69959186955,\n"," 'EAST COWES': 154570.902299908,\n"," 'ASHFORD': 235354.52899719903,\n"," 'YORK': 206492.38370014777,\n"," 'KIDDERMINSTER': 171861.5620220162,\n"," 'LEATHERHEAD': 498326.5758582969,\n"," 'ST. ALBANS': 220211.40895735275,\n"," 'EXETER': 224798.1498240206,\n"," 'GLOUCESTER': 176233.51328027903,\n"," 'HORNCHURCH': 272631.8551562041,\n"," 'BILLINGSHURST': 356799.47137850465,\n"," 'BIDEFORD': 181643.85952852538,\n"," 'WHITCHURCH': 208130.1985136251,\n"," 'TEDDINGTON': 448334.58099628636,\n"," 'HASTINGS': 170005.49330726924,\n"," 'CORBY': 154545.91563766904,\n"," 'SOUTHEND-ON-SEA': 184139.0801923552,\n"," 'WOLVERHAMPTON': 146822.9833912669,\n"," 'HEMEL HEMPSTEAD': 257671.52512259994,\n"," 'EASTBOURNE': 186895.1901492458,\n"," 'HERTFORD': 306518.2329062651,\n"," 'DERBY': 154598.6608272357,\n"," 'LOUGHTON': 326190.44567937154,\n"," 'BLYTH': 99793.34239623952,\n"," 'CRAWLEY': 230932.5101509102,\n"," 'PLYMOUTH': 149413.32327326582,\n"," 'WIGTON': 136940.1511032309,\n"," 'BROMSGROVE': 199518.9445927191,\n"," 'HALESOWEN': 145570.53356758374,\n"," 'MAIDSTONE': 241771.49298040362,\n"," 'CHESTERFIELD': 137897.45288300287,\n"," 'CATERHAM': 307888.3919018569,\n"," 'CHESTER LE STREET': 119423.7463255112,\n"," 'TIVERTON': 196717.73647719802,\n"," 'AYLESBURY': 249230.6350075379,\n"," 'WINDLESHAM': 537254.5152640264,\n"," 'CROMER': 175614.51064804214,\n"," 'BAMPTON': 317112.64401820546,\n"," 'BOLTON': 124064.71194209701,\n"," 'ST. HELENS': 83386.09161240635,\n"," 'WETHERBY': 268953.2683047377,\n"," 'WOODBRIDGE': 253366.61705592458,\n"," 'LETCHWORTH GARDEN CITY': 234346.9490760039,\n"," 'FOLKESTONE': 172422.8121750092,\n"," 'CHESTER': 194223.3005865946,\n"," 'CAMBRIDGE': 303617.5800817661,\n"," 'BURRY PORT': 114430.72942958101,\n"," 'MAESTEG': 83342.45898754738,\n"," 'WEDNESBURY': 114005.71105977046,\n"," 'DARWEN': 90646.19387318927,\n"," 'POOLE': 253123.11307116807,\n"," 'TADLEY': 255234.13953678697,\n"," 'HEYWOOD': 108377.03736487545,\n"," 'WAKEFIELD': 145365.3489857449,\n"," 'CRICKHOWELL': 241830.78323699423,\n"," 'BRAINTREE': 210050.2642944524,\n"," 'RIPON': 210534.8520479676,\n"," 'EDGWARE': 290516.66278963274,\n"," 'MOUNTAIN ASH': 70243.67156549521,\n"," 'NEWCASTLE': 133615.56882026352,\n"," 'BOURNE': 172006.10941508465,\n"," 'ST. IVES': 134708.09548376183,\n"," 'ANDOVER': 232860.44546378445,\n"," 'BRIDGEND': 132490.22726543705,\n"," 'CLEETHORPES': 97780.1124489999,\n"," 'GOSPORT': 140481.58239889593,\n"," 'DEWSBURY': 108606.16499645264,\n"," 'LONGFIELD': 275765.01460910763,\n"," 'RUSHDEN': 150170.07121171363,\n"," 'DAVENTRY': 187337.85998182118,\n"," 'NEWTON ABBOT': 200927.82541598982,\n"," 'RIPLEY': 135527.06750293294,\n"," 'ROSS-ON-WYE': 225459.41645683453,\n"," 'WATFORD': 264192.82290371816,\n"," 'WADEBRIDGE': 295197.86827989033,\n"," 'CHICHESTER': 286697.0481914871,\n"," 'BICESTER': 241294.2767564403,\n"," 'MELTON CONSTABLE': 191932.07169954476,\n"," 'WITHAM': 204944.85242232052,\n"," 'ILKLEY': 268507.3315415627,\n"," 'SANDBACH': 189268.67124435847,\n"," 'NEWENT': 205054.45745305164,\n"," 'BILLERICAY': 296733.2469691403,\n"," 'HOUNSLOW': 280255.11674912745,\n"," 'BEDFORD': 223691.54108667487,\n"," 'ROCHESTER': 191123.31483746253,\n"," 'WORKSOP': 125199.24224029663,\n"," 'OSSETT': 131050.43418560606,\n"," 'BASINGSTOKE': 227198.7557368763,\n"," 'LANCASTER': 147180.0448666233,\n"," 'TUNBRIDGE WELLS': 323534.1626946818,\n"," 'HEBDEN BRIDGE': 154293.63972976484,\n"," 'CAERNARFON': 125959.34317430326,\n"," 'COLEFORD': 162665.4637079456,\n"," 'BARNSTAPLE': 185955.27898949842,\n"," 'HIGHBRIDGE': 184061.29630855817,\n"," 'ROYSTON': 275099.73546897265,\n"," 'MORPETH': 180523.91621678468,\n"," 'HAYWARDS HEATH': 319011.56281868566,\n"," 'DEESIDE': 147756.23400405725,\n"," 'RYDE': 157976.32674292475,\n"," 'ELLESMERE': 172333.1664586973,\n"," 'HIGH PEAK': 168646.0845604225,\n"," 'GATESHEAD': 114222.96050317351,\n"," 'RUGELEY': 163993.9079262043,\n"," 'EPSOM': 333159.11442504247,\n"," 'CIRENCESTER': 292782.84614551166,\n"," 'BARROW-IN-FURNESS': 96329.52018325904,\n"," 'WALTON-ON-THAMES': 391991.36135486135,\n"," 'HUDDERSFIELD': 134730.67292623184,\n"," 'SOUTHPORT': 153281.29028283065,\n"," 'PORTSMOUTH': 166756.54239548682,\n"," 'SOUTH SHIELDS': 107449.59936558286,\n"," 'GRIMSBY': 107523.08919798576,\n"," 'OAKHAM': 239464.63082358136,\n"," 'LEEDS': 163869.13826531253,\n"," 'HECKMONDWIKE': 98252.83552978387,\n"," 'WAREHAM': 251186.57462947836,\n"," 'WASHINGTON': 128991.38886221795,\n"," 'CHEADLE': 212645.62840770377,\n"," 'BURY': 135881.65809923457,\n"," 'HIGH WYCOMBE': 269439.8232519871,\n"," 'COWBRIDGE': 311192.0186717088,\n"," 'POLEGATE': 211685.22245398772,\n"," 'MIDDLESBROUGH': 112464.122852111,\n"," 'DARLINGTON': 125540.3272473093,\n"," 'UTTOXETER': 166595.09236648335,\n"," 'SOUTHWOLD': 321047.94374497724,\n"," 'BEDWORTH': 127060.0017521727,\n"," 'WIGAN': 124232.4945333445,\n"," 'COLNE': 106616.55839192908,\n"," 'NORTHALLERTON': 184520.73678459227,\n"," 'WEMBLEY': 330955.65918253857,\n"," 'BEXLEYHEATH': 242060.72071402008,\n"," 'HARTLEPOOL': 96521.7306883814,\n"," 'ISLEWORTH': 300254.97794205317,\n"," 'DARTFORD': 223712.68289323105,\n"," 'BRIDGNORTH': 193015.1227739726,\n"," 'WOKING': 337374.3303641992,\n"," 'CARDIFF': 182472.81891823377,\n"," 'ALFRETON': 127876.3764226392,\n"," 'LUTTERWORTH': 325638.11547868623,\n"," 'SOUTH MOLTON': 211239.45708061,\n"," 'CRADLEY HEATH': 124955.55678793257,\n"," 'CHATTERIS': 138791.40838509318,\n"," 'BURY ST. EDMUNDS': 138202.80127072573,\n"," 'BARNSLEY': 111592.95586243352,\n"," 'CANNOCK': 138183.2063183475,\n"," 'RUGBY': 192789.86975161236,\n"," 'DROITWICH': 211230.3340343498,\n"," 'HITCHIN': 270761.6878308443,\n"," 'WATERLOOVILLE': 218524.9389856775,\n"," 'KNEBWORTH': 293792.6608695652,\n"," 'SALISBURY': 247210.22202093748,\n"," 'CAERPHILLY': 123056.19334507732,\n"," 'WIGSTON': 139940.68562144597,\n"," 'NEW MILTON': 240435.12103699704,\n"," 'ROCHDALE': 121382.16768944221,\n"," 'CONSETT': 110531.24427746815,\n"," 'COWES': 186903.54142475346,\n"," 'HORSHAM': 285781.7032973562,\n"," 'ALTRINCHAM': 323553.94176250824,\n"," 'GILLINGHAM': 171374.68290988487,\n"," 'SPALDING': 140951.51465491336,\n"," 'LOUTH': 149586.17907944592,\n"," 'TAUNTON': 200303.5594115494,\n"," 'SUNBURY-ON-THAMES': 320631.8191313909,\n"," 'BOURNE END': 403826.18511450384,\n"," 'KIDLINGTON': 274994.04881525034,\n"," 'SHEFFORD': 244009.6434521371,\n"," 'CHIPPENHAM': 222363.36481164125,\n"," 'WHITLEY BAY': 157715.12866915198,\n"," 'MORECAMBE': 107716.91056989144,\n"," 'ST. NEOTS': 130467.50126103405,\n"," 'SHIFNAL': 216666.63643067845,\n"," 'BURNHAM-ON-SEA': 157353.45360905802,\n"," 'MINEHEAD': 211228.80786998846,\n"," 'LEIGHTON BUZZARD': 223620.20818540157,\n"," 'DUDLEY': 126961.36602694746,\n"," 'HYTHE': 259539.46577060933,\n"," 'BANBURY': 240222.61421045812,\n"," 'MALVERN': 221603.15804310265,\n"," 'HELSTON': 201232.65322849338,\n"," 'STEVENAGE': 198183.78368374944,\n"," 'HAILSHAM': 215642.42125125302,\n"," 'ILKESTON': 120555.30637433402,\n"," 'PRUDHOE': 133267.35858320183,\n"," 'TWICKENHAM': 413068.69872739055,\n"," 'SALTBURN-BY-THE-SEA': 110543.58199987738,\n"," 'THATCHAM': 261718.46339551653,\n"," 'RHYL': 109927.302181987,\n"," 'ROMNEY MARSH': 187179.1389485747,\n"," 'BERKHAMSTED': 411353.41046033567,\n"," 'CLACTON-ON-SEA': 150052.4070928233,\n"," 'WANTAGE': 275107.6628765505,\n"," 'AMERSHAM': 420706.3075384615,\n"," 'PETERLEE': 79562.61511739339,\n"," 'GLOSSOP': 148844.9087434858,\n"," 'WIMBORNE': 280907.6065853774,\n"," 'BISHOP AUCKLAND': 101810.50937939956,\n"," 'NEW MALDEN': 343679.8983393846,\n"," 'WINCANTON': 205285.25145954962,\n"," 'PONTYPOOL': 114226.98830614513,\n"," 'EAST GRINSTEAD': 282636.7207103079,\n"," 'BURNTWOOD': 152516.1527451723,\n"," 'POULTON-LE-FYLDE': 158697.44,\n"," 'CANTERBURY': 240179.6196740987,\n"," 'WALLINGFORD': 320714.7290762554,\n"," 'LOWESTOFT': 131437.53732286306,\n"," 'BRIGHOUSE': 127673.37529869597,\n"," 'ORMSKIRK': 204863.35198112755,\n"," 'WICKFORD': 208176.82341810127,\n"," 'COCKERMOUTH': 173262.94269045984,\n"," 'EMSWORTH': 276455.4893309968,\n"," 'CROWTHORNE': 342471.1081215745,\n"," 'PINNER': 372686.12192518805,\n"," 'CARMARTHEN': 156888.1713424841,\n"," 'KNARESBOROUGH': 257855.197147913,\n"," 'BLANDFORD FORUM': 232806.13532264583,\n"," 'REDCAR': 111048.20885299963,\n"," 'HOOK': 375772.5746755343,\n"," 'GUILDFORD': 376793.22645799385,\n"," 'KEIGHLEY': 128261.0229844993,\n"," 'CAMBERLEY': 293236.31484471716,\n"," 'MARYPORT': 95210.5646840679,\n"," 'WINCHESTER': 375726.5539307948,\n"," 'SALFORD': 157745.0506224534,\n"," 'EGHAM': 360817.1700593044,\n"," 'WALTHAM CROSS': 245763.44657123293,\n"," 'HAMPTON': 368059.085531005,\n"," 'WALLINGTON': 244162.39370949898,\n"," 'FERNDALE': 49367.368963426954,\n"," 'FELTHAM': 232781.35986699784,\n"," 'PAIGNTON': 160105.9502315511,\n"," 'SOWERBY BRIDGE': 138731.4694063927,\n"," 'TEWKESBURY': 205276.865835108,\n"," 'SMETHWICK': 116723.06642550068,\n"," 'CARLISLE': 127383.15842637855,\n"," 'ROSSENDALE': 129301.1422688311,\n"," 'MABLETHORPE': 112592.97762251923,\n"," 'GODALMING': 396081.24467837345,\n"," 'SIDCUP': 255274.45441606114,\n"," 'ELLAND': 132401.68893093662,\n"," 'BATH': 313272.4189410345,\n"," 'SIDMOUTH': 270246.8949865053,\n"," 'CREWE': 156846.99016051012,\n"," 'MONMOUTH': 223786.83565317327,\n"," 'DALTON-IN-FURNESS': 96090.54086181278,\n"," 'ST LEONARDS-ON-SEA': 211443.44331458243,\n"," 'HESSLE': 150690.38275084554,\n"," 'HOUGHTON LE SPRING': 114177.8895360846,\n"," 'LYTHAM ST. ANNES': 131388.34290194185,\n"," 'BASILDON': 196167.678584169,\n"," 'DURHAM': 142055.18842114712,\n"," 'TRURO': 238452.06568473834,\n"," 'BRIGG': 137040.89361702127,\n"," 'HASSOCKS': 349264.90608752164,\n"," 'STEYNING': 265595.27649853803,\n"," 'WARE': 275328.54084672325,\n"," 'WORTHING': 205057.18297119887,\n"," 'MATLOCK': 193886.62523102606,\n"," 'LLANDEILO': 174121.46074380164,\n"," 'LLANDUDNO': 148570.03988537795,\n"," 'WALLSEND': 98542.18513632366,\n"," 'HINCKLEY': 167248.6487990139,\n"," 'TRIMDON STATION': 77626.75797219951,\n"," 'TORPOINT': 171154.62998745294,\n"," 'BLAENAU FFESTINIOG': 80217.23033882499,\n"," 'IVYBRIDGE': 188375.16730488694,\n"," 'FROME': 197169.331510286,\n"," 'BROADSTAIRS': 221100.49166452937,\n"," 'ROMSEY': 306371.12751235586,\n"," 'NEWPORT PAGNELL': 201177.7212054994,\n"," 'WELLINGBOROUGH': 151582.0641905531,\n"," 'WELLING': 224147.83738640728,\n"," 'DRIFFIELD': 150414.20082292287,\n"," 'SEAFORD': 214307.61335500813,\n"," 'PEWSEY': 289441.5606963988,\n"," 'AYLESFORD': 238511.01853109538,\n"," 'COULSDON': 339501.6526900382,\n"," 'LYMINGTON': 331967.0340253212,\n"," 'GREAT YARMOUTH': 134975.95934153112,\n"," 'ALCESTER': 224334.30652318615,\n"," 'SAFFRON WALDEN': 313488.9596330275,\n"," 'STANFORD-LE-HOPE': 197242.27678387827,\n"," 'EXMOUTH': 198417.24269147136,\n"," 'WELWYN GARDEN CITY': 256089.71697343368,\n"," 'LICHFIELD': 234929.1853126062,\n"," 'NORTH SHIELDS': 130896.66807844581,\n"," 'FARNHAM': 382379.89717345627,\n"," 'BODMIN': 187237.4546022328,\n"," 'GODSTONE': 299917.1975672687,\n"," 'WILLENHALL': 115057.19297532656,\n"," 'WEST BROMWICH': 114182.2191410213,\n"," 'NEWHAVEN': 179799.71939243158,\n"," 'TADCASTER': 201883.10638297873,\n"," 'THETFORD': 159676.83183706284,\n"," 'SEAHAM': 112597.4310009368,\n"," 'WOKINGHAM': 331212.55005411257,\n"," 'HARLOW': 210571.2369604835,\n"," 'BROADSTONE': 305957.16380775766,\n"," 'REDRUTH': 159778.02485514703,\n"," 'CRAMLINGTON': 118290.31143335777,\n"," 'ASHINGTON': 91609.38709455745,\n"," 'CALNE': 191705.01350080603,\n"," 'LLANGOLLEN': 190642.57928240742,\n"," 'MARCH': 143823.70030288538,\n"," 'LIGHTWATER': 294804.69773358,\n"," 'BLACKBURN': 112825.86129928358,\n"," 'ABERDARE': 90502.92447527357,\n"," 'ABERGELE': 136211.70806012308,\n"," 'STAINES-UPON-THAMES': 472298.64405010437,\n"," 'DURSLEY': 201429.59774964838,\n"," 'GOOLE': 136294.1104736328,\n"," 'WITHERNSEA': 86275.14049586777,\n"," 'GAINSBOROUGH': 115103.63427109974,\n"," 'HORNSEA': 125498.54017180394,\n"," 'BEDLINGTON': 108717.966577967,\n"," 'BEDALE': 194347.07139821505,\n"," 'WHITBY': 176869.0422303097,\n"," 'THIRSK': 205974.41851028887,\n"," 'FILEY': 134901.5030554343,\n"," 'SKIPTON': 199053.5346133206,\n"," 'LLANELLI': 114783.24417872875,\n"," 'PENARTH': 211563.31030231874,\n"," 'PEMBROKE DOCK': 115869.13864505965,\n"," 'WELSHPOOL': 162307.89517174335,\n"," 'LLANIDLOES': 131727.1204610951,\n"," 'HAVERFORDWEST': 158600.66468346815,\n"," 'LLANDUDNO JUNCTION': 143723.38402777776,\n"," 'USK': 256102.17683523655,\n"," 'LLANFYLLIN': 160585.34905660377,\n"," 'LLANGEFNI': 142408.0246863618,\n"," 'MENAI BRIDGE': 179863.6923945783,\n"," 'CLYNDERWEN': 175880.93871297242,\n"," 'CARDIGAN': 158576.94553376906,\n"," 'BRECON': 183122.93427542993,\n"," 'BANGOR': 138514.14983418753,\n"," 'LEYLAND': 140013.8906622404,\n"," 'RICKMANSWORTH': 402045.7929054367,\n"," 'TOWCESTER': 257655.61341250438,\n"," 'NANTWICH': 209233.00409405257,\n"," 'IBSTOCK': 151438.12802582033,\n"," 'LLANFAIRPWLLGWYNGYLL': 167486.87927644514,\n"," 'COALVILLE': 159194.8754189944,\n"," 'SHIPLEY': 141801.93338389584,\n"," 'ST. LEONARDS-ON-SEA': 101101.18453745668,\n"," 'BIRKENHEAD': 87783.30284552845,\n"," 'WEYMOUTH': 187995.50242890528,\n"," 'NORMANTON': 147221.81384673037,\n"," 'BUXTON': 169004.90700031674,\n"," 'MERTHYR TYDFIL': 91748.36217745194,\n"," 'BILSTON': 109156.66530262028,\n"," 'DEAL': 192214.23760597126,\n"," 'SHOREHAM-BY-SEA': 240181.72179668327,\n"," 'MARLBOROUGH': 344739.84659287444,\n"," 'LEISTON': 180217.42901960784,\n"," 'NELSON': 75299.29244376851,\n"," 'WALTHAM ABBEY': 244025.4490714227,\n"," 'BINGLEY': 160173.7489747321,\n"," 'TORQUAY': 163339.62559717818,\n"," 'WYMONDHAM': 197154.51848308253,\n"," 'NESTON': 213778.14400085396,\n"," 'HUNSTANTON': 219239.6795562599,\n"," 'IMMINGHAM': 93063.14788865745,\n"," 'WOODFORD GREEN': 334951.31419365975,\n"," 'ALNWICK': 190498.69002192983,\n"," 'HARPENDEN': 494866.5420134073,\n"," 'PORT TALBOT': 94732.28186921269,\n"," 'BARTON-UPON-HUMBER': 120297.95657175726,\n"," 'BROMYARD': 196574.48003523194,\n"," 'BUDLEIGH SALTERTON': 286830.13355182303,\n"," 'ACCRINGTON': 84579.58823704056,\n"," 'SOUTHAM': 238227.8660626354,\n"," 'CARTERTON': 200755.2572719898,\n"," 'STAFFORD': 179518.98208144796,\n"," 'SANDOWN': 154951.49309935106,\n"," 'TROWBRIDGE': 176100.5281058101,\n"," 'BIGGLESWADE': 217468.93857362872,\n"," 'KENILWORTH': 260773.5192967999,\n"," 'NEWQUAY': 211518.58508100588,\n"," 'DEREHAM': 169628.73893884892,\n"," 'CREWKERNE': 173783.6628201075,\n"," 'SHREWSBURY': 187909.4456479389,\n"," 'BRIDGWATER': 169128.49841246218,\n"," 'SWADLINCOTE': 149548.62122963453,\n"," 'MELTON MOWBRAY': 184561.56807612814,\n"," 'SOUTH OCKENDON': 174372.1114541979,\n"," 'BRIXHAM': 178531.37108468678,\n"," 'CALLINGTON': 174535.87340651557,\n"," 'UCKFIELD': 287965.52112860035,\n"," 'HENLEY-ON-THAMES': 535594.6917130488,\n"," 'OLDBURY': 127008.15714223443,\n"," 'PEACEHAVEN': 182997.25404661702,\n"," 'RINGWOOD': 323614.40675487975,\n"," 'EVESHAM': 198347.33781920007,\n"," 'EASTLEIGH': 222346.7399266565,\n"," 'STROUD': 242793.7357863888,\n"," 'MOLD': 162108.36829165497,\n"," 'OTLEY': 196243.51693330563,\n"," 'YARM': 209660.9304130492,\n"," 'ABINGDON': 291318.8818006741,\n"," 'HOLMFIRTH': 175702.74262269214,\n"," 'TREHARRIS': 98077.48964218456,\n"," 'CLECKHEATON': 138023.03219974172,\n"," 'MORDEN': 242158.07137003142,\n"," 'RAINHAM': 223914.24060630237,\n"," 'NORTHWOOD': 468484.844874538,\n"," 'WEST WICKHAM': 341546.66734742915,\n"," 'BLAYDON-ON-TYNE': 119484.3601872974,\n"," 'STOWMARKET': 187326.15802437128,\n"," 'HENLEY-IN-ARDEN': 320424.87579617836,\n"," 'CALDICOT': 186865.8458433528,\n"," 'RUNCORN': 124146.58296167823,\n"," 'PAR': 144208.28892331527,\n"," 'STANSTED': 338237.77889447234,\n"," 'PENRITH': 182518.13777730602,\n"," 'FRESHWATER': 181210.9213260762,\n"," 'ROCHFORD': 210507.69914544973,\n"," 'ATHERSTONE': 177692.5374864572,\n"," 'SHEPTON MALLET': 199880.45665343638,\n"," 'HALSTEAD': 203394.6096969697,\n"," 'HAYLING ISLAND': 215135.92551773175,\n"," 'HUNTINGDON': 205720.27305633348,\n"," 'ESHER': 657585.3816467301,\n"," 'ELY': 193890.04202597679,\n"," 'WHITSTABLE': 235902.21703804613,\n"," 'STOCKTON-ON-TEES': 126373.39351936367,\n"," 'DEVIZES': 217811.34510150045,\n"," 'WARMINSTER': 204436.5755158547,\n"," 'TONYPANDY': 66600.16599239917,\n"," 'NEATH': 101369.94739967168,\n"," 'SKELMERSDALE': 113127.32407468064,\n"," 'TENTERDEN': 300328.0585287274,\n"," 'DAWLISH': 179776.706992473,\n"," 'MARKET HARBOROUGH': 225986.06071843446,\n"," 'PONTEFRACT': 124223.0657012159,\n"," 'STAINES': 200517.75255678044,\n"," 'HORLEY': 270467.8279378169,\n"," 'TADWORTH': 453868.19686022657,\n"," 'MALMESBURY': 301150.6802516053,\n"," 'TORRINGTON': 164508.3869640537,\n"," 'WORCESTER PARK': 293780.08265930164,\n"," 'REDDITCH': 167810.2722551929,\n"," 'BERWICK-UPON-TWEED': 135281.20986411677,\n"," 'THAME': 292464.7367770915,\n"," 'BEWDLEY': 199216.17517704063,\n"," 'HAVANT': 184632.04559451138,\n"," 'FERNDOWN': 257022.04857988816,\n"," 'BOLDON COLLIERY': 112923.50374331551,\n"," 'HEBBURN': 115153.25367730256,\n"," 'ROWLEY REGIS': 114000.03829245719,\n"," 'HEANOR': 111801.79212728588,\n"," 'CASTLEFORD': 129659.71506517126,\n"," 'HUNGERFORD': 289759.5177921315,\n"," 'SOUTHALL': 253828.1263648554,\n"," 'KINGSTON UPON THAMES': 411042.48025477707,\n"," 'MUCH WENLOCK': 260994.46341463414,\n"," 'FERRYHILL': 73894.95870841487,\n"," 'STANLEY': 85686.89276664364,\n"," 'CROWBOROUGH': 288257.2085915794,\n"," 'GREENHITHE': 221971.46746454792,\n"," 'ABERTILLERY': 66749.91057768399,\n"," 'STAMFORD': 224342.58489688323,\n"," 'ASHTON-UNDER-LYNE': 104611.6891041723,\n"," 'SALE': 203157.4076505206,\n"," 'CLEVEDON': 207433.31346593666,\n"," 'WITNEY': 267824.0540005043,\n"," 'FLEETWOOD': 98642.88450771815,\n"," 'FARINGDON': 260494.73417880462,\n"," 'WELWYN': 469191.2425087108,\n"," 'FRODSHAM': 205968.29030062395,\n"," 'DORKING': 367409.75349183683,\n"," 'FAREHAM': 214629.74858808197,\n"," 'ELLESMERE PORT': 136938.14524237643,\n"," \"BISHOP'S STORTFORD\": 294229.39750952064,\n"," 'EYE': 246113.66508274619,\n"," 'OKEHAMPTON': 199480.29731800765,\n"," 'SWANAGE': 245945.0103173713,\n"," 'GRAVESEND': 202596.51874432783,\n"," 'NORTHWICH': 184129.25277276244,\n"," 'POTTERS BAR': 359737.64931108494,\n"," 'DULVERTON': 251262.12070175438,\n"," 'STALYBRIDGE': 130657.46927907162,\n"," 'HYDE': 125885.2255783182,\n"," 'RYTON': 124096.84454148472,\n"," 'BATLEY': 112410.11365360304,\n"," 'BRANDON': 133648.62582478006,\n"," 'SANDWICH': 229283.68591037547,\n"," 'WEYBRIDGE': 561364.5450980392,\n"," 'HATFIELD': 278714.1412024566,\n"," 'WHITEHAVEN': 108449.60646608399,\n"," 'LAUNCESTON': 183758.470851165,\n"," 'KINGSBRIDGE': 284318.2538512506,\n"," 'WINSFORD': 133688.30661003452,\n"," 'CRICCIETH': 176244.5816091954,\n"," 'BUSHEY': 341060.27015298617,\n"," 'LLANDYSUL': 167909.81962095876,\n"," 'BARKING': 232379.58485573254,\n"," 'WINDSOR': 374800.63245598273,\n"," 'TREORCHY': 62211.6763986014,\n"," 'SITTINGBOURNE': 190323.82168447023,\n"," 'PULBOROUGH': 354774.00204877404,\n"," 'MALTON': 179014.5149204556,\n"," 'WIDNES': 134118.93214313022,\n"," 'SOUTH PETHERTON': 236642.60585197934,\n"," 'TENBY': 187171.61283643893,\n"," 'TETBURY': 301573.19988401316,\n"," 'WARWICK': 267762.16146152274,\n"," 'RADLETT': 549734.465550169,\n"," 'ALRESFORD': 406380.90469849727,\n"," 'HAYLE': 183764.71161548732,\n"," 'CREDITON': 210002.538616251,\n"," 'FAVERSHAM': 217197.59003935405,\n"," 'MARKET RASEN': 161356.27881010596,\n"," 'KENLEY': 336295.4897813688,\n"," 'LISKEARD': 160548.54727815633,\n"," 'NEWTON AYCLIFFE': 127376.31457761512,\n"," 'BACUP': 97842.61951624378,\n"," 'ROWLANDS GILL': 147090.0924414011,\n"," 'CHORLEY': 147299.24912273974,\n"," 'STRATFORD-UPON-AVON': 295198.9188508064,\n"," 'EAST BOLDON': 168215.85984732825,\n"," 'LEEK': 140441.88137969715,\n"," 'CHOPPINGTON': 85640.77870757788,\n"," 'WELLINGTON': 190595.24585684063,\n"," 'CHRISTCHURCH': 263943.3832576324,\n"," 'HARWICH': 137765.24406352034,\n"," 'KNUTSFORD': 331073.28475925786,\n"," 'ONGAR': 354054.9640778647,\n"," 'MARLOW': 441406.04681497364,\n"," 'CINDERFORD': 133152.2660049628,\n"," 'BRIDPORT': 233485.26900866217,\n"," 'PRESTATYN': 118706.88393536926,\n"," 'ST. AUSTELL': 120342.97634578166,\n"," 'SHEPPERTON': 312023.12631295447,\n"," 'DENBIGH': 143849.23273615635,\n"," 'EDENBRIDGE': 351072.4706642961,\n"," 'ST HELENS': 154724.28001812415,\n"," 'TIPTON': 103910.9229895932,\n"," 'TEIGNMOUTH': 207319.82359362493,\n"," 'DORCHESTER': 243736.9546212753,\n"," 'STONE': 184813.97606084868,\n"," 'ARUNDEL': 288846.8779384035,\n"," 'DRYBROOK': 172124.1303630363,\n"," 'WHYTELEAFE': 226301.03063063064,\n"," 'VIRGINIA WATER': 931594.9026246719,\n"," 'ETCHINGHAM': 323018.7299578059,\n"," 'WEST MALLING': 324705.7706185567,\n"," 'CHESHAM': 300621.92568468966,\n"," 'AMMANFORD': 110601.61205989477,\n"," 'SPILSBY': 178920.39430127802,\n"," 'SALTASH': 172415.28601322506,\n"," 'ROBERTSBRIDGE': 295174.87451133697,\n"," 'SANDHURST': 245675.61433703735,\n"," 'LIPHOOK': 353796.5048304603,\n"," 'RETFORD': 159615.16997246727,\n"," 'HENLOW': 266071.5398153491,\n"," 'GERRARDS CROSS': 607090.8299761337,\n"," 'UPMINSTER': 332800.41926012916,\n"," 'KINGSWINFORD': 160816.9275024139,\n"," 'GUISBOROUGH': 142917.73946772976,\n"," 'MILFORD HAVEN': 122355.1916617034,\n"," 'ILMINSTER': 208951.57981287214,\n"," 'STONEHOUSE': 220983.63212154096,\n"," 'LEYBURN': 223650.56057629338,\n"," 'ST IVES': 307514.46924497135,\n"," 'PORTH': 88979.40811775201,\n"," 'CWMBRAN': 133883.46458923514,\n"," 'PONTYPRIDD': 110867.61320319433,\n"," 'BARGOED': 82574.23140964995,\n"," 'NORTH WALSHAM': 159577.25473746547,\n"," 'CULLOMPTON': 189441.56749332914,\n"," 'WEST MOLESEY': 274555.41160180734,\n"," 'ABERYSTWYTH': 166244.8229703424,\n"," 'BENFLEET': 224809.8370287392,\n"," 'BEXHILL-ON-SEA': 186415.68251968504,\n"," 'PRENTON': 142485.94809445873,\n"," 'REDHILL': 268201.99596661056,\n"," 'BIRCHINGTON': 190760.27707900843,\n"," 'WORKINGTON': 108695.59918622849,\n"," 'TONBRIDGE': 318256.1546622915,\n"," 'SHAFTESBURY': 236174.5883463081,\n"," 'ILFRACOMBE': 181408.76299678322,\n"," 'SEATON': 205756.9014872251,\n"," 'LANCING': 179568.06254347687,\n"," 'BOSTON': 133904.58822469364,\n"," 'LEOMINSTER': 180799.57600868106,\n"," 'CORSHAM': 246191.29493992607,\n"," 'PURFLEET': 182135.22477161675,\n"," 'STOURPORT-ON-SEVERN': 161515.4315630601,\n"," 'HEXHAM': 197942.86685485768,\n"," 'WESTCLIFF-ON-SEA': 168612.8200582722,\n"," 'STURMINSTER NEWTON': 246762.98757671006,\n"," 'HOCKLEY': 270186.8992737003,\n"," 'RAYLEIGH': 233965.48412517132,\n"," 'KENDAL': 180686.68114732497,\n"," 'MARTOCK': 188721.10788381743,\n"," 'RAMSGATE': 160738.4784197388,\n"," 'NEWBIGGIN-BY-THE-SEA': 84991.42770856927,\n"," 'PRESCOT': 129815.74010826497,\n"," 'MILLOM': 96264.90555555555,\n"," 'ST. COLUMB': 110628.89897260274,\n"," 'BRIDLINGTON': 114250.012162599,\n"," 'HODDESDON': 254625.37702828986,\n"," 'BEXLEY': 288882.7779950597,\n"," 'CHESSINGTON': 243165.3363182204,\n"," 'WELLS-NEXT-THE-SEA': 290103.81413043477,\n"," 'HORNCASTLE': 154105.05068193297,\n"," 'TRING': 327051.43308181094,\n"," \"KING'S LYNN\": 173192.0957274109,\n"," 'MORETON-IN-MARSH': 333064.0254195049,\n"," 'HEATHFIELD': 264768.5871986056,\n"," 'CHIGWELL': 390103.54570607643,\n"," 'BARROW-UPON-HUMBER': 130064.21190211346,\n"," 'YATELEY': 250622.2121663563,\n"," 'LEDBURY': 208267.99136709186,\n"," 'FORDINGBRIDGE': 279938.61601615074,\n"," 'TILBURY': 149095.72959474885,\n"," 'PONTYCLUN': 153501.237980105,\n"," 'CAMBORNE': 139641.28822426987,\n"," 'SANDY': 204427.4146650654,\n"," 'CHURCH STRETTON': 266755.9745693191,\n"," 'SUDBURY': 217327.52407275987,\n"," 'DARTMOUTH': 296059.36558984715,\n"," 'HONITON': 194801.18242424243,\n"," 'WINDERMERE': 281617.9030744337,\n"," 'ASCOT': 571037.3412692721,\n"," 'PERSHORE': 233051.62523687436,\n"," 'BURY ST EDMUNDS': 304436.6444317023,\n"," 'CLITHEROE': 192647.44324441085,\n"," 'BROUGH': 170715.967662355,\n"," 'FRINTON-ON-SEA': 217721.1704978868,\n"," 'GRANGE-OVER-SANDS': 193597.4365284974,\n"," 'STOCKSFIELD': 238200.15704967387,\n"," 'SUTTON-IN-ASHFIELD': 109596.88046048816,\n"," 'BUCKHURST HILL': 335926.8373157092,\n"," 'PENMAENMAWR': 122920.70238095238,\n"," 'AMBLESIDE': 320887.20773480664,\n"," 'EAST MOLESEY': 527519.0772603884,\n"," 'SWANLEY': 239071.1447340312,\n"," 'GLASTONBURY': 201348.6189557613,\n"," 'BUNTINGFORD': 341277.8978027593,\n"," 'WALTON ON THE NAZE': 152788.80908193486,\n"," 'HENGOED': 114766.86760371798,\n"," 'PORTLAND': 141132.93715917945,\n"," 'ULVERSTON': 172982.99954783867,\n"," 'TREDEGAR': 83156.07281976745,\n"," 'WATCHET': 175268.76247183778,\n"," 'DUNMOW': 314233.53370491805,\n"," 'CHISLEHURST': 421143.5532075472,\n"," 'RYE': 261108.10726145672,\n"," 'SHANKLIN': 173205.7272327965,\n"," 'HOLYWELL': 133674.13958518897,\n"," 'CRAVEN ARMS': 226221.39855266685,\n"," 'VENTNOR': 187862.66895998165,\n"," 'WINSCOMBE': 284145.2211819778,\n"," 'HASLEMERE': 390664.11253890174,\n"," 'CONGLETON': 187628.4143804913,\n"," 'LYME REGIS': 285866.25223163195,\n"," 'SKEGNESS': 127884.64960157189,\n"," 'ALFORD': 144388.14419061656,\n"," 'LYTHAM ST ANNES': 228176.3550933553,\n"," 'PETWORTH': 455723.6528640442,\n"," 'BARNOLDSWICK': 107195.22352584201,\n"," 'ST ALBANS': 502364.3003785574,\n"," 'PENTRE': 64141.90132614071,\n"," 'SEASCALE': 138699.9385775862,\n"," 'BRAMPTON': 165811.9779654036,\n"," 'PENRHYNDEUDRAETH': 111127.63369245837,\n"," 'FLEET': 296754.72515831894,\n"," 'YARMOUTH': 270990.30432098766,\n"," 'FALMOUTH': 243089.43452151396,\n"," 'BRADFORD-ON-AVON': 270211.90568763955,\n"," 'SCUNTHORPE': 107938.76240591634,\n"," 'MIRFIELD': 148174.80142828805,\n"," 'TAVISTOCK': 208053.96068972597,\n"," 'WARLINGHAM': 367632.4152677152,\n"," 'HALTWHISTLE': 117293.50903119869,\n"," 'HOLYHEAD': 126178.46259389084,\n"," 'ASHTEAD': 417391.85213105247,\n"," 'BORDON': 245087.88472338166,\n"," 'BATTLE': 280325.7303780173,\n"," 'KNOTTINGLEY': 114272.82289119804,\n"," 'BEAUMARIS': 196046.72327726532,\n"," 'MARKFIELD': 161524.8381253594,\n"," 'KIDWELLY': 122606.50154511743,\n"," 'BUNGAY': 176909.5380812889,\n"," 'LITTLEBOROUGH': 127304.40782052888,\n"," 'TENBURY WELLS': 220493.99169063597,\n"," 'IVER': 396204.63035168196,\n"," 'DOWNHAM MARKET': 160489.9255961215,\n"," 'FAIRFORD': 277853.24594813614,\n"," 'WELLS': 227299.87089715537,\n"," 'SHERBORNE': 252420.2655638563,\n"," 'TARPORLEY': 317497.39642447105,\n"," 'BEMBRIDGE': 255334.75192243396,\n"," 'LLANDOVERY': 155377.77768729642,\n"," 'BEACONSFIELD': 700588.4779139685,\n"," 'SNODLAND': 190673.4119428091,\n"," 'NORTH TAWTON': 181462.2432223083,\n"," 'LIVERSEDGE': 121836.73137896326,\n"," 'RUISLIP': 305975.8634231174,\n"," 'HALESWORTH': 196122.39715350728,\n"," 'MARKET DRAYTON': 187394.1258598726,\n"," 'LEE-ON-THE-SOLENT': 218025.98260192157,\n"," 'WINKLEIGH': 215979.23855311357,\n"," 'HINDHEAD': 385036.88910891087,\n"," 'STOCKBRIDGE': 452587.3542260209,\n"," 'DELABOLE': 157821.67649769585,\n"," 'CRANBROOK': 362736.94351747463,\n"," 'SAWBRIDGEWORTH': 244325.21806556932,\n"," 'SHILDON': 70538.63448922212,\n"," 'CHALFONT ST GILES': 841495.1434370772,\n"," 'ABERAERON': 166673.94333843797,\n"," 'KESWICK': 257417.39413875598,\n"," 'BEAMINSTER': 245647.8931383577,\n"," 'LEWES': 323553.39421214536,\n"," 'SHERINGHAM': 188369.84409522326,\n"," 'OLNEY': 251584.2693414593,\n"," 'CRANLEIGH': 391595.9236258921,\n"," 'ABERGAVENNY': 200823.09619327806,\n"," 'MELKSHAM': 187816.41930997948,\n"," 'CROOK': 98749.47174111212,\n"," 'SOUTHMINSTER': 203173.08071025021,\n"," 'EPPING': 369590.99199346406,\n"," 'DRONFIELD': 178522.43347164593,\n"," 'TOTNES': 263908.26240108086,\n"," 'PENRYN': 175807.38579940418,\n"," 'KESTON': 618518.419375,\n"," 'NORTH FERRIBY': 241220.1251497006,\n"," 'SETTLE': 195488.28525434644,\n"," 'MEXBOROUGH': 95523.71498163832,\n"," 'FLINT': 117487.43298570877,\n"," 'BUILTH WELLS': 180827.77818853973,\n"," 'KINGS LANGLEY': 376362.9132791328,\n"," 'WEST BYFLEET': 329516.9610814743,\n"," 'AXMINSTER': 235498.03955375255,\n"," 'MAYFIELD': 429145.7368708972,\n"," 'EGREMONT': 102229.48108398175,\n"," 'TOTLAND BAY': 260470.00698254365,\n"," 'RHAYADER': 149942.40922190202,\n"," 'CHINNOR': 330713.43615384615,\n"," 'Y FELINHELI': 142046.63473818646,\n"," 'NEWTOWN': 137032.88630705394,\n"," 'BAGSHOT': 258095.67707022402,\n"," 'SEAVIEW': 259925.2120758483,\n"," 'HOLSWORTHY': 220404.7507136061,\n"," 'NARBERTH': 177012.94755450796,\n"," 'INGATESTONE': 449126.78378930176,\n"," 'WESTBURY': 174237.08184343614,\n"," 'ASHBOURNE': 245885.43181225553,\n"," 'VERWOOD': 228611.6183258361,\n"," 'THAMES DITTON': 455521.5548031496,\n"," 'BANSTEAD': 370000.000410509,\n"," 'ST. AGNES': 159405.77697841727,\n"," 'PORT ISAAC': 295860.76424581005,\n"," 'PWLLHELI': 187009.0523453433,\n"," 'ABBOTS LANGLEY': 254045.27298180122,\n"," 'BURES': 286325.9371428571,\n"," 'TIDWORTH': 171583.65057283142,\n"," 'LISS': 337034.7426647427,\n"," 'PEVENSEY': 208268.27471169687,\n"," 'MANNINGTREE': 207662.84842370744,\n"," 'WINGATE': 102266.34031620553,\n"," 'LAMPETER': 160703.24351676155,\n"," 'BROADWAY': 370803.08588957053,\n"," 'HOLT': 279498.46602800296,\n"," 'ALDEBURGH': 336669.23409860744,\n"," 'WOTTON-UNDER-EDGE': 249678.6333843798,\n"," 'WATLINGTON': 387313.28545371635,\n"," 'LYDNEY': 176442.95263211278,\n"," 'RADSTOCK': 190717.11506288388,\n"," 'DUKINFIELD': 111289.97528770442,\n"," 'BUDE': 225851.67573696145,\n"," 'BRUTON': 231355.80378378378,\n"," 'HARTFIELD': 532817.4786729858,\n"," 'WESTERHAM': 304954.5983168317,\n"," 'FAIRBOURNE': 107620.47864768683,\n"," 'LYMM': 265111.4586004274,\n"," 'CHEPSTOW': 225862.10754225173,\n"," 'SAXMUNDHAM': 237918.48072497122,\n"," 'HARLECH': 139996.43550724638,\n"," 'SOMERTON': 248414.61050974217,\n"," 'NEW ROMNEY': 202362.94236526947,\n"," 'MILNTHORPE': 206564.8699444885,\n"," 'CHEDDAR': 212565.10732292917,\n"," 'DISS': 201238.0157051282,\n"," 'LYNDHURST': 395337.8181066557,\n"," 'BUCKNELL': 229999.16539923954,\n"," 'LYDBROOK': 162685.81729055257,\n"," 'SOUTH BRENT': 243757.63851937535,\n"," 'ATTLEBOROUGH': 186236.65534262484,\n"," 'CHIPPING CAMPDEN': 398633.37641791045,\n"," 'TEMPLECOMBE': 207738.5233404711,\n"," 'PADSTOW': 326942.450238379,\n"," 'TYWYN': 126247.59451445515,\n"," 'CAERSWS': 161392.408627451,\n"," 'PRINCES RISBOROUGH': 366475.3658237548,\n"," 'HOPE VALLEY': 281453.6599490878,\n"," 'OTTERY ST. MARY': 187166.84699453553,\n"," 'WESTGATE-ON-SEA': 164383.62852246762,\n"," 'TODMORDEN': 119682.64151651652,\n"," 'LANGPORT': 233251.6389116203,\n"," 'COLYTON': 267748.10872894333,\n"," 'BRAUNTON': 240614.9784217987,\n"," 'FRIZINGTON': 102324.42521367522,\n"," 'CLEATOR': 96084.0390070922,\n"," 'CEMAES BAY': 153603.3725490196,\n"," 'TYN-Y-GONGL': 168188.62425554954,\n"," 'BROCKENHURST': 546789.0787304204,\n"," 'FOREST ROW': 366920.5431767338,\n"," 'KILGETTY': 160403.4839228296,\n"," 'CASTLE CARY': 209397.11791666667,\n"," 'PEMBROKE': 143788.389976339,\n"," 'LUDLOW': 195693.10529986053,\n"," 'SWANSCOMBE': 252551.50153307052,\n"," 'BADMINTON': 317560.5520195838,\n"," 'BRENTFORD': 400749.27732602117,\n"," 'GOODWICK': 127167.76673040153,\n"," 'LINGFIELD': 334375.86883983575,\n"," 'LLANON': 164764.59173126615,\n"," 'STUDLEY': 192617.06913996628,\n"," 'YELVERTON': 219121.2215496368,\n"," 'ALDERLEY EDGE': 434369.8623568702,\n"," 'WYLAM': 226962.8639328984,\n"," 'FISHGUARD': 142322.93015075376,\n"," 'WOODSTOCK': 358339.2015558699,\n"," 'CONWY': 178581.7670592031,\n"," 'BEAWORTHY': 240407.31919092254,\n"," 'ASKAM-IN-FURNESS': 115696.26050420168,\n"," 'EBBW VALE': 87440.63660660402,\n"," 'LLANGAMMARCH WELLS': 168376.9634551495,\n"," 'GUNNISLAKE': 180961.54797535212,\n"," 'SPENNYMOOR': 115398.96050989481,\n"," ...}"]},"execution_count":6,"metadata":{},"output_type":"execute_result"}],"source":["uniques_prices = {}\n","for unique in uniques:\n","    uniques_prices[unique] = df[df[which_unique_col] == unique]['price'].mean()\n","\n","uniques_prices"]},{"cell_type":"markdown","metadata":{},"source":["Next, we'll grab data just for 2022:"]},{"cell_type":"code","execution_count":7,"metadata":{},"outputs":[],"source":["df_2022 = df[df['Date_of_Transfer'].str.startswith('2022')]"]},{"cell_type":"markdown","metadata":{},"source":["Grab the lower 20% and upper 20% averages for properties in 2022."]},{"cell_type":"code","execution_count":8,"metadata":{},"outputs":[{"data":{"text/plain":["{'MILTON KEYNES': (145209.19414893616, 1040103.4488711819),\n"," 'SUNDERLAND': (57598.83542039356, 382399.2969588551),\n"," 'COLCHESTER': (165101.45194805195, 743320.1543450064),\n"," 'SOLIHULL': (169737.0992063492, 954522.1623762376),\n"," 'BRIERLEY HILL': (84892.07627118644, 393329.35294117645),\n"," 'ROTHERHAM': (69336.18461538461, 372788.05222734256),\n"," 'PETERBOROUGH': (129923.33620689655, 638733.4009840098),\n"," 'MACCLESFIELD': (125174.44363636363, 1026978.036231884),\n"," 'SWANSEA': (89393.35723431499, 473603.2340153453),\n"," 'NORWICH': (153349.73511450383, 668095.0953470633),\n"," 'WALSALL': (106190.06652360516, 470153.1605995717),\n"," 'CHELTENHAM': (163773.77908937607, 1151449.372053872),\n"," 'BECKENHAM': (243124.5748502994, 1216312.6488095238),\n"," 'LIVERPOOL': (75708.61082352941, 476806.06302916276),\n"," 'LONDON': (275152.6557612647, 2773460.021555368),\n"," 'NORTHOLT': (212971.75, 998280.1470588235),\n"," 'BLACKPOOL': (69852.94966442953, 299120.4221105528),\n"," 'CORBRIDGE': (159136.36363636365, 776450.0),\n"," 'WORCESTER': (139232.3620309051, 659356.2781456953),\n"," 'SLEAFORD': (119877.97222222222, 489160.1724137931),\n"," 'BRISTOL': (189295.88888888888, 891353.1944664032),\n"," 'SWINDON': (139446.11947431302, 814600.6324582339),\n"," 'CHERTSEY': (233178.25757575757, 1167481.3333333333),\n"," 'LUTON': (155975.69245647968, 574033.7104247104),\n"," 'MANCHESTER': (112600.44333448158, 667490.6212121212),\n"," 'HOVE': (206155.46278317153, 1189358.5612903226),\n"," 'ASHBY-DE-LA-ZOUCH': (161346.484375, 619674.921875),\n"," 'SUTTON COLDFIELD': (153829.90168539327, 1374394.955182073),\n"," 'KETTERING': (142326.0071942446, 1286979.5454545454),\n"," 'CHALFONT ST. GILES': (nan, nan),\n"," 'BELPER': (144266.03937007874, 664684.671875),\n"," 'HEREFORD': (141249.48902821317, 635623.0344827586),\n"," 'CHIPPING NORTON': (218726.8051948052, 1837948.4935064935),\n"," 'DOVER': (133552.05714285714, 687811.7045454546),\n"," 'REIGATE': (264250.22580645164, 1721012.255319149),\n"," 'OLDHAM': (81494.08655616942, 405791.6930147059),\n"," 'SOUTHWELL': (181737.03703703705, 754357.1428571428),\n"," 'STREET': (127317.5, 440270.34146341466),\n"," 'COVENTRY': (122557.34669338677, 734802.7867867867),\n"," 'MARGATE': (116537.64516129032, 571566.3935483871),\n"," 'CHATHAM': (156787.75636363638, 555110.4),\n"," 'SHEFFIELD': (96151.4482964734, 571447.0986252242),\n"," 'STOCKPORT': (143115.94993742177, 664376.375),\n"," 'LEICESTER': (142005.08451704544, 601322.5180979418),\n"," 'HULL': (69498.15612648221, 379312.3998025666),\n"," 'ILFORD': (211883.34814814816, 813365.3542435424),\n"," 'BOURNEMOUTH': (135244.54237288135, 775598.9605077574),\n"," 'FARNBOROUGH': (185135.5628742515, 658823.0297619047),\n"," 'BOGNOR REGIS': (134067.9961832061, 1078687.3764258556),\n"," 'BLACKWOOD': (110632.30612244898, 505589.6060606061),\n"," 'STOKE-ON-TRENT': (71918.5408858603, 485789.51829787233),\n"," 'NOTTINGHAM': (116253.17946505608, 608387.8840017249),\n"," 'READING': (208698.4793554884, 1326432.8841893254),\n"," 'NEWPORT': (107882.83266932271, 492019.50663129974),\n"," 'PRESTON': (89405.25127681307, 482021.81224489794),\n"," 'IPSWICH': (133119.0801815431, 752011.4848942598),\n"," 'CANVEY ISLAND': (218397.52475247523, 511669.1176470588),\n"," 'LEIGH-ON-SEA': (214267.5611111111, 837241.3038674033),\n"," 'BECCLES': (174521.52307692307, 631120.2615384615),\n"," 'SHEERNESS': (135037.3103448276, 544294.6034482758),\n"," 'HAVERHILL': (197320.4411764706, 589582.7572815533),\n"," 'MAIDENHEAD': (251895.32699619772, 1464041.9696969697),\n"," 'SUTTON': (217006.80215827338, 959423.7275985663),\n"," 'WESTON-SUPER-MARE': (129881.32044198895, 509874.78453038674),\n"," 'BEVERLEY': (130482.46527777778, 578243.5034482758),\n"," 'BILLINGHAM': (81319.48507462686, 466233.00746268657),\n"," 'PICKERING': (114740.38775510204, 592247.14),\n"," 'LEIGH': (78793.29545454546, 320859.8587570622),\n"," 'MANSFIELD': (92475.60912698413, 417006.39285714284),\n"," 'BRIGHTON': (216398.12214983715, 1235453.4657980455),\n"," 'SELBY': (123245.68553459119, 459818.28125),\n"," 'NORTHAMPTON': (152611.59796954316, 885048.4994923858),\n"," 'HALIFAX': (73537.14084507042, 440430.3988764045),\n"," 'NUNEATON': (121379.15727002967, 625743.5266272189),\n"," 'OSWESTRY': (113315.43650793651, 560217.3543307086),\n"," 'JARROW': (62556.45161290323, 247716.66666666666),\n"," 'WREXHAM': (102607.0612244898, 525938.1540697674),\n"," 'OXFORD': (259181.2819843342, 1962834.1484375),\n"," 'TAMWORTH': (130540.93910256411, 982621.858974359),\n"," 'UXBRIDGE': (259354.5534883721, 1988619.9305555555),\n"," 'BROXBOURNE': (215724.38775510204, 1148039.9),\n"," 'COBHAM': (395044.10169491527, 3500310.316666667),\n"," 'BOOTLE': (62451.23134328358, 289231.81481481483),\n"," 'SOUTHSEA': (130559.70472440944, 571805.5882352941),\n"," 'NEWCASTLE UPON TYNE': (82986.61759729273, 715622.8630600169),\n"," 'GRAYS': (180430.39705882352, 963510.5804878048),\n"," 'MIDDLEWICH': (105934.75409836066, 1257442.7704918033),\n"," 'CLEATOR MOOR': (45603.82352941176, 258075.0),\n"," 'WISBECH': (122018.52879581152, 592773.3854166666),\n"," 'CARNFORTH': (131899.04761904763, 598165.5283018867),\n"," 'YEOVIL': (121015.286407767, 751585.281553398),\n"," 'SLOUGH': (187231.47965116278, 1644871.2318840579),\n"," 'BRACKNELL': (207088.74904942967, 1195375.6539923954),\n"," 'DONCASTER': (77835.27692307692, 400252.0798076923),\n"," 'THORNTON-CLEVELEYS': (98730.26395939087, 315110.8434343434),\n"," 'PUDSEY': (126974.69343065693, 468435.26277372264),\n"," 'FELIXSTOWE': (152566.0, 645826.7373737374),\n"," 'BARRY': (128805.84183673469, 409497.0659898477),\n"," 'SCARBOROUGH': (93064.91496598639, 476590.76271186443),\n"," 'PETERSFIELD': (208599.5, 1507833.3333333333),\n"," 'PENZANCE': (140454.22608695654, 675639.0344827586),\n"," 'BUCKLEY': (120248.86363636363, 349640.44444444444),\n"," 'HARROGATE': (163222.65352112675, 1054971.938028169),\n"," 'COTTINGHAM': (101773.72413793103, 417936.0344827586),\n"," 'LITTLEHAMPTON': (162978.38864628822, 797815.4913043479),\n"," 'STOURBRIDGE': (131260.40449438203, 639362.9477611941),\n"," 'LEAMINGTON SPA': (173181.49344978167, 789540.5608695652),\n"," 'NEWTON-LE-WILLOWS': (94192.3294117647, 609883.6627906977),\n"," 'WARRINGTON': (100984.70921985815, 576293.2365439093),\n"," 'BURGESS HILL': (217294.9537037037, 937801.5688073394),\n"," 'ALTON': (187739.2857142857, 1249939.3628318585),\n"," 'TELFORD': (97807.025, 491882.41164241167),\n"," 'BALDOCK': (180607.14285714287, 853151.1627906977),\n"," 'DUNSTABLE': (162601.84647302906, 1827438.347107438),\n"," 'NEWBURY': (179413.5120772947, 1040106.8942307692),\n"," 'CHARD': (135406.82432432432, 793699.8),\n"," 'WILMSLOW': (153281.33333333334, 1194641.7086614172),\n"," 'DIDCOT': (190586.78443113773, 904341.5773809524),\n"," 'SOUTHAMPTON': (144222.64208074534, 857762.2810559006),\n"," 'GRANTHAM': (111310.65898617511, 543826.6146788991),\n"," 'NEWMARKET': (172295.43636363637, 936126.0636363636),\n"," 'MIDHURST': (193228.08823529413, 1554471.7647058824),\n"," 'BIRMINGHAM': (113038.08399366085, 658361.1319334389),\n"," 'OXTED': (272564.28571428574, 1642488.3720930233),\n"," 'PORTHCAWL': (163321.2962962963, 609202.5272727272),\n"," 'SEVENOAKS': (187898.75238095238, 1747223.6208530806),\n"," 'CHELMSFORD': (194073.86013986013, 910950.9127399651),\n"," 'WALLASEY': (76335.25229357799, 343448.5388127854),\n"," 'BUCKINGHAM': (216725.24545454545, 861868.9459459459),\n"," 'BRENTWOOD': (231621.17142857143, 1181778.4897959183),\n"," 'COLWYN BAY': (89266.79166666667, 421186.79338842974),\n"," 'LINCOLN': (117240.05548216644, 488909.9182058048),\n"," 'BOREHAMWOOD': (252834.96511627908, 1614674.103448276),\n"," 'ADDLESTONE': (211988.06818181818, 936030.3258426966),\n"," 'LOUGHBOROUGH': (139628.50636132315, 593662.4554707379),\n"," 'CARSHALTON': (245116.98039215687, 837927.8446601941),\n"," 'BRACKLEY': (167699.33333333334, 613993.4868421053),\n"," 'ENFIELD': (216208.4597315436, 1058799.5618729098),\n"," 'DAGENHAM': (228380.95263157896, 825551.2722513089),\n"," 'BURNLEY': (48612.130641330165, 354380.7867298578),\n"," 'CROYDON': (192495.97252747254, 1583621.1698630138),\n"," 'BRADFORD': (64139.8471659919, 431044.87765419617),\n"," 'THORNTON HEATH': (189911.4375, 634221.8518518518),\n"," 'MITCHAM': (200668.15596330276, 970302.1090909091),\n"," 'ROMFORD': (205534.2788671024, 748733.7478260869),\n"," 'RICHMOND': (200641.4236453202, 2372567.651960784),\n"," 'WEST DRAYTON': (219323.64864864864, 3507228.0),\n"," 'BELVEDERE': (199033.01886792452, 860291.037735849),\n"," 'GREENFORD': (270205.0375, 1267005.9259259258),\n"," 'HAYES': (223560.39568345324, 2285157.1357142855),\n"," 'ORPINGTON': (269081.15769230766, 1206821.6091954024),\n"," 'BROMLEY': (265667.77702702704, 1120994.7845117846),\n"," 'ERITH': (195099.94252873564, 1444213.0681818181),\n"," 'PURLEY': (234349.425, 1407976.8148148148),\n"," 'HERNE BAY': (163510.8962962963, 644381.0882352941),\n"," 'STANMORE': (281331.94444444444, 1610919.191780822),\n"," 'SOUTH CROYDON': (224002.27272727274, 891039.535483871),\n"," 'HARROW': (215871.12367491165, 981518.3626760563),\n"," 'BARNET': (251241.72988505746, 1588338.2),\n"," 'SURBITON': (267543.88095238095, 1290677.4792899408),\n"," 'WIRRAL': (117755.12757973734, 852080.456928839),\n"," 'ALDERSHOT': (169950.11764705883, 816328.567251462),\n"," 'MALDON': (193373.5894736842, 718976.6145833334),\n"," 'NEWARK': (115409.27814569537, 616918.7491749175),\n"," 'HARLESTON': (151900.0, 1702412.64),\n"," 'BURTON-ON-TRENT': (104441.56050955414, 618238.4952380953),\n"," 'EAST COWES': (144104.6875, 443892.42424242425),\n"," 'ASHFORD': (177393.9357429719, 759105.3446893787),\n"," 'YORK': (168353.63045912655, 811636.004474273),\n"," 'KIDDERMINSTER': (121938.35436893204, 606527.9516908212),\n"," 'LEATHERHEAD': (250254.62416107382, 2175879.533333333),\n"," 'ST. ALBANS': (nan, nan),\n"," 'EXETER': (158935.68410852714, 939549.3539651837),\n"," 'GLOUCESTER': (130090.24273504273, 887819.2474402731),\n"," 'HORNCHURCH': (243198.30857142858, 893674.3125),\n"," 'BILLINGSHURST': (205320.16363636364, 1494576.6785714286),\n"," 'BIDEFORD': (123294.13698630137, 742765.7823129252),\n"," 'WHITCHURCH': (125656.52173913043, 830603.3714285714),\n"," 'TEDDINGTON': (316386.0561797753, 1681831.8666666667),\n"," 'HASTINGS': (140281.14689265538, 739511.2415730337),\n"," 'CORBY': (143342.87671232875, 604283.1590909091),\n"," 'SOUTHEND-ON-SEA': (143132.40268456377, 705747.6543624161),\n"," 'WOLVERHAMPTON': (102760.12258064515, 516199.0869565217),\n"," 'HEMEL HEMPSTEAD': (206698.82291666666, 1595803.4705882352),\n"," 'EASTBOURNE': (145278.84792626728, 650242.5701149425),\n"," 'HERTFORD': (231934.54166666666, 1157002.3719008265),\n"," 'DERBY': (111324.12774451097, 520768.1296111665),\n"," 'LOUGHTON': (275015.0326086957, 1367365.5913978494),\n"," 'BLYTH': (57797.36923076923, 267129.6564885496),\n"," 'CRAWLEY': (194058.32047477746, 1188873.2721893492),\n"," 'PLYMOUTH': (109650.94046306505, 502451.37444933923),\n"," 'WIGTON': (76376.62686567164, 548677.9411764706),\n"," 'BROMSGROVE': (136479.93827160494, 631239.7530864198),\n"," 'HALESOWEN': (121741.77906976744, 562871.5639534884),\n"," 'MAIDSTONE': (175803.624217119, 972149.2229166667),\n"," 'CHESTERFIELD': (101945.83190394512, 478520.352739726),\n"," 'CATERHAM': (222615.82278481012, 1207341.425),\n"," 'CHESTER LE STREET': (63281.79255319149, 322546.72340425535),\n"," 'TIVERTON': (144591.6, 971417.64),\n"," 'AYLESBURY': (186080.45774647887, 1014447.524590164),\n"," 'WINDLESHAM': (278978.92307692306, 2406678.1428571427),\n"," 'CROMER': (124017.61111111111, 610695.4814814815),\n"," 'BAMPTON': (258088.23529411765, 1253788.8333333333),\n"," 'BOLTON': (85042.99656357388, 566159.7070938215),\n"," 'ST. HELENS': (nan, nan),\n"," 'WETHERBY': (174225.5747126437, 922146.8522727273),\n"," 'WOODBRIDGE': (177680.02290076335, 877271.4545454546),\n"," 'LETCHWORTH GARDEN CITY': (197255.13414634147, 878857.5903614458),\n"," 'FOLKESTONE': (127675.10407239819, 623844.0315315315),\n"," 'CHESTER': (130143.62921348315, 626121.2539325843),\n"," 'CAMBRIDGE': (225262.12554744526, 1599402.3489051096),\n"," 'BURRY PORT': (100795.45454545454, 337782.60869565216),\n"," 'MAESTEG': (68506.63461538461, 263211.4423076923),\n"," 'WEDNESBURY': (101619.44444444444, 310664.2417582418),\n"," 'DARWEN': (70153.72093023256, 306564.25581395347),\n"," 'POOLE': (179541.22328244275, 1142481.801904762),\n"," 'TADLEY': (218624.26865671642, 955886.0294117647),\n"," 'HEYWOOD': (92120.0, 416027.4175824176),\n"," 'WAKEFIELD': (104414.71347248578, 485381.5890151515),\n"," 'CRICKHOWELL': (247678.2142857143, 1055710.7142857143),\n"," 'BRAINTREE': (173385.36448598132, 845979.0744186046),\n"," 'RIPON': (147492.91463414635, 725423.7951807228),\n"," 'EDGWARE': (239919.18018018018, 925372.0535714285),\n"," 'MOUNTAIN ASH': (57474.15, 238613.03278688525),\n"," 'NEWCASTLE': (92212.22357723577, 429109.6666666667),\n"," 'BOURNE': (154561.23255813954, 487459.1954022989),\n"," 'ST. IVES': (nan, nan),\n"," 'ANDOVER': (155557.85779816515, 862422.8356164383),\n"," 'BRIDGEND': (100165.58192090396, 410687.9633802817),\n"," 'CLEETHORPES': (71991.80740740741, 337277.7132352941),\n"," 'GOSPORT': (125374.79452054795, 482689.9090909091),\n"," 'DEWSBURY': (69950.99236641222, 340103.1590909091),\n"," 'LONGFIELD': (242264.70588235295, 867311.5384615385),\n"," 'RUSHDEN': (141419.44852941178, 454859.0583941606),\n"," 'DAVENTRY': (142156.02272727274, 1499589.5714285714),\n"," 'NEWTON ABBOT': (160082.48561151078, 758669.7025089606),\n"," 'RIPLEY': (113624.8795180723, 355071.89285714284),\n"," 'ROSS-ON-WYE': (139955.28333333333, 899917.7213114754),\n"," 'WATFORD': (217886.54231974922, 990085.75),\n"," 'WADEBRIDGE': (184176.3962264151, 1807325.4528301887),\n"," 'CHICHESTER': (195949.7993197279, 1046671.1016949152),\n"," 'BICESTER': (218484.22162162163, 723976.7783783784),\n"," 'MELTON CONSTABLE': (184015.38461538462, 791343.8461538461),\n"," 'WITHAM': (160379.03225806452, 709966.4),\n"," 'ILKLEY': (167973.07317073172, 904797.3333333334),\n"," 'SANDBACH': (138115.64150943398, 589356.9626168224),\n"," 'NEWENT': (179910.625, 706500.0),\n"," 'BILLERICAY': (258855.2627737226, 1106068.7028985508),\n"," 'HOUNSLOW': (213100.7962962963, 1255876.495412844),\n"," 'BEDFORD': (174190.20058139536, 1385084.4985465116),\n"," 'ROCHESTER': (182524.10891089108, 572449.5230263158),\n"," 'WORKSOP': (81168.34101382489, 650417.3990825688),\n"," 'OSSETT': (114204.484375, 389227.44615384616),\n"," 'BASINGSTOKE': (165762.0894308943, 878562.9054054054),\n"," 'LANCASTER': (101699.27234042554, 594299.7754237289),\n"," 'TUNBRIDGE WELLS': (191246.6656441718, 1363173.8379204893),\n"," 'HEBDEN BRIDGE': (121091.6, 475024.50980392157),\n"," 'CAERNARFON': (89007.22222222222, 527878.989010989),\n"," 'COLEFORD': (144661.7105263158, 522847.94736842107),\n"," 'BARNSTAPLE': (153794.25153374232, 654583.731707317),\n"," 'HIGHBRIDGE': (122397.2972972973, 847071.3513513514),\n"," 'ROYSTON': (213443.11111111112, 997098.094488189),\n"," 'MORPETH': (89813.82065217392, 807040.1189189189),\n"," 'HAYWARDS HEATH': (206380.04568527918, 1217948.8934010153),\n"," 'DEESIDE': (105199.78703703704, 413748.14814814815),\n"," 'RYDE': (108100.94594594595, 576215.3125),\n"," 'ELLESMERE': (120599.4827586207, 526000.0),\n"," 'HIGH PEAK': (147495.69696969696, 608861.03),\n"," 'GATESHEAD': (69108.07692307692, 334534.3917808219),\n"," 'RUGELEY': (121834.60869565218, 678855.2327586206),\n"," 'EPSOM': (264884.7242990654, 1118651.8504672898),\n"," 'CIRENCESTER': (176140.2, 1412227.3879310344),\n"," 'BARROW-IN-FURNESS': (58311.33179723502, 317570.6605504587),\n"," 'WALTON-ON-THAMES': (261318.654676259, 2581229.4142857143),\n"," 'HUDDERSFIELD': (85302.66555183947, 467146.1953255426),\n"," 'SOUTHPORT': (86960.10242587602, 496888.7150537634),\n"," 'PORTSMOUTH': (137340.20107238606, 580745.0695187165),\n"," 'SOUTH SHIELDS': (58971.555555555555, 309141.66814159293),\n"," 'GRIMSBY': (61304.044052863435, 388319.9868131868),\n"," 'OAKHAM': (162268.22727272726, 895794.2272727273),\n"," 'LEEDS': (105718.67492096944, 691032.2206424434),\n"," 'HECKMONDWIKE': (82777.41935483871, 246209.67741935485),\n"," 'WAREHAM': (197299.97727272726, 859418.8888888889),\n"," 'WASHINGTON': (47759.242647058825, 372749.700729927),\n"," 'CHEADLE': (165932.71276595743, 693191.5079365079),\n"," 'BURY': (104203.44512195123, 475039.60975609755),\n"," 'HIGH WYCOMBE': (190838.91578947369, 971934.2519685039),\n"," 'COWBRIDGE': (246348.2142857143, 1009436.8928571428),\n"," 'POLEGATE': (167179.54545454544, 681750.0),\n"," 'MIDDLESBROUGH': (54179.85179153094, 349403.3013029316),\n"," 'DARLINGTON': (66655.9923076923, 380219.2864450128),\n"," 'UTTOXETER': (122271.53947368421, 488122.33766233764),\n"," 'SOUTHWOLD': (195491.34782608695, 1505562.5),\n"," 'BEDWORTH': (125806.36666666667, 356237.76666666666),\n"," 'WIGAN': (86185.40458015267, 393950.81526717555),\n"," 'COLNE': (65255.17894736842, 364599.77894736844),\n"," 'NORTHALLERTON': (135706.08974358975, 521892.2658227848),\n"," 'WEMBLEY': (218828.23357664235, 3954448.4057971016),\n"," 'BEXLEYHEATH': (243901.4696969697, 1004174.2651515151),\n"," 'HARTLEPOOL': (42398.9701897019, 306185.52432432433),\n"," 'ISLEWORTH': (230582.183908046, 1103979.2159090908),\n"," 'DARTFORD': (198851.67753623187, 742441.6678700361),\n"," 'BRIDGNORTH': (128891.35064935064, 594358.7402597403),\n"," 'WOKING': (229765.0, 1519309.6246418338),\n"," 'CARDIFF': (132421.97340930675, 721623.170940171),\n"," 'ALFRETON': (98193.89142857143, 485397.4147727273),\n"," 'LUTTERWORTH': (202579.77049180327, 2017031.5409836066),\n"," 'SOUTH MOLTON': (159638.0344827586, 693753.3333333334),\n"," 'CRADLEY HEATH': (105039.77272727272, 476611.1111111111),\n"," 'CHATTERIS': (119288.54901960785, 940873.2692307692),\n"," 'BURY ST. EDMUNDS': (nan, nan),\n"," 'BARNSLEY': (76328.39703703704, 370072.00887573964),\n"," 'CANNOCK': (115368.76061776062, 411562.3461538461),\n"," 'RUGBY': (144405.78048780488, 1521463.5896656534),\n"," 'DROITWICH': (135972.10784313726, 740487.274509804),\n"," 'HITCHIN': (202597.05154639174, 1029098.6205128205),\n"," 'WATERLOOVILLE': (178547.93191489362, 641032.156779661),\n"," 'KNEBWORTH': (232253.3, 830595.2380952381),\n"," 'SALISBURY': (161112.45272206303, 791272.5100286533),\n"," 'CAERPHILLY': (113498.38815789473, 396621.3157894737),\n"," 'WIGSTON': (151457.3523809524, 384581.5094339623),\n"," 'NEW MILTON': (179864.88764044945, 856525.3932584269),\n"," 'ROCHDALE': (81403.9312320917, 411681.8114285714),\n"," 'CONSETT': (60767.605633802814, 320022.13986013987),\n"," 'COWES': (113153.38983050847, 722607.1666666666),\n"," 'HORSHAM': (204759.88612099644, 1173652.5195729537),\n"," 'ALTRINCHAM': (198697.6981981982, 1469637.3856502243),\n"," 'GILLINGHAM': (160069.68857142856, 586268.6638176638),\n"," 'SPALDING': (125304.99331103679, 459790.4166666667),\n"," 'LOUTH': (102333.66336633664, 599333.725490196),\n"," 'TAUNTON': (148046.69518716578, 710815.584),\n"," 'SUNBURY-ON-THAMES': (211728.95384615383, 2104087.6923076925),\n"," 'BOURNE END': (270830.4166666667, 1435940.0),\n"," 'KIDLINGTON': (210164.47619047618, 841420.3125),\n"," 'SHEFFORD': (210975.075, 889302.65),\n"," 'CHIPPENHAM': (169471.1443298969, 904350.5846153846),\n"," 'WHITLEY BAY': (88819.25974025975, 533253.5870967741),\n"," 'MORECAMBE': (80984.91208791209, 330793.1912568306),\n"," 'ST. NEOTS': (nan, nan),\n"," 'SHIFNAL': (139369.16666666666, 636180.5555555555),\n"," 'BURNHAM-ON-SEA': (134262.0806451613, 471115.873015873),\n"," 'MINEHEAD': (121708.78378378379, 1785547.3733333333),\n"," 'LEIGHTON BUZZARD': (187752.8370044053, 713199.6578947369),\n"," 'DUDLEY': (106063.2435897436, 362757.18723404256),\n"," 'HYTHE': (172806.84615384616, 870413.4393939395),\n"," 'BANBURY': (167562.4609929078, 935183.2332155477),\n"," 'MALVERN': (160106.71140939597, 873686.9731543624),\n"," 'HELSTON': (147765.12820512822, 927415.1898734177),\n"," 'STEVENAGE': (168804.0663900415, 718956.9628099174),\n"," 'HAILSHAM': (189068.09523809524, 719102.820754717),\n"," 'ILKESTON': (102079.47976878613, 396717.34104046243),\n"," 'PRUDHOE': (85479.05405405405, 390572.1891891892),\n"," 'TWICKENHAM': (309363.37572254334, 1706698.2298850575),\n"," 'SALTBURN-BY-THE-SEA': (55157.75221238938, 405596.6929824561),\n"," 'THATCHAM': (215934.41747572814, 987396.1826923077),\n"," 'RHYL': (98243.93793103448, 335200.0068493151),\n"," 'ROMNEY MARSH': (213402.41025641025, 791186.4102564103),\n"," 'BERKHAMSTED': (291968.63636363635, 1559584.3461538462),\n"," 'CLACTON-ON-SEA': (119261.50511945393, 545524.1870748299),\n"," 'WANTAGE': (192873.04123711342, 1019504.4329896907),\n"," 'AMERSHAM': (316257.90625, 1578893.076923077),\n"," 'PETERLEE': (31047.59477124183, 234019.8831168831),\n"," 'GLOSSOP': (124862.41666666667, 444997.26804123714),\n"," 'WIMBORNE': (236228.23076923078, 887416.0305343511),\n"," 'BISHOP AUCKLAND': (39016.142857142855, 312641.11675126903),\n"," 'NEW MALDEN': (285237.21875, 1335238.2474226805),\n"," 'WINCANTON': (100887.06451612903, 1221751.90625),\n"," 'PONTYPOOL': (89994.17829457365, 396189.88372093026),\n"," 'EAST GRINSTEAD': (180803.32258064515, 999907.808),\n"," 'BURNTWOOD': (143585.05681818182, 481538.76404494385),\n"," 'POULTON-LE-FYLDE': (119295.77884615384, 443906.4857142857),\n"," 'CANTERBURY': (145390.83056478406, 755707.8311258279),\n"," 'WALLINGFORD': (235495.58139534883, 1157863.0813953488),\n"," 'LOWESTOFT': (116968.34909090909, 461385.1014492754),\n"," 'BRIGHOUSE': (74221.16304347826, 411363.3333333333),\n"," 'ORMSKIRK': (129302.86524822695, 681089.7112676057),\n"," 'WICKFORD': (215157.37837837837, 710102.6339285715),\n"," 'COCKERMOUTH': (109791.67213114754, 473327.22580645164),\n"," 'EMSWORTH': (200259.26785714287, 1045735.0701754387),\n"," 'CROWTHORNE': (222616.30434782608, 1013157.9787234042),\n"," 'PINNER': (298843.93333333335, 1347819.8113207547),\n"," 'CARMARTHEN': (101148.41818181818, 678196.6846846847),\n"," 'KNARESBOROUGH': (185879.765625, 1346461.3692307693),\n"," 'BLANDFORD FORUM': (177791.06493506493, 908166.8974358974),\n"," 'REDCAR': (68732.54901960785, 296734.07189542486),\n"," 'HOOK': (216290.87378640776, 1369380.5242718447),\n"," 'GUILDFORD': (230798.69303797468, 1832497.0630914827),\n"," 'KEIGHLEY': (79389.80456026059, 400886.7077922078),\n"," 'CAMBERLEY': (205997.52608695652, 957245.0),\n"," 'MARYPORT': (68192.90697674418, 263166.75),\n"," 'WINCHESTER': (253157.30653266332, 1726799.4623115577),\n"," 'SALFORD': (113231.73553719008, 523609.1978021978),\n"," 'EGHAM': (251360.0, 3271139.4736842103),\n"," 'WALTHAM CROSS': (212044.80838323353, 875418.869047619),\n"," 'HAMPTON': (297554.1666666667, 1355270.1506849315),\n"," 'WALLINGTON': (212374.19191919192, 884496.02),\n"," 'FERNDALE': (48553.934782608696, 196637.9347826087),\n"," 'FELTHAM': (202905.64285714287, 2099311.523809524),\n"," 'PAIGNTON': (127312.13736263737, 726195.5464480874),\n"," 'SOWERBY BRIDGE': (89881.61764705883, 424438.40579710144),\n"," 'TEWKESBURY': (135576.36363636365, 661575.6818181818),\n"," 'SMETHWICK': (108312.09090909091, 499839.63963963964),\n"," 'CARLISLE': (76991.77925531915, 607121.7586206896),\n"," 'ROSSENDALE': (88575.70212765958, 596725.5492957747),\n"," 'MABLETHORPE': (70525.8253968254, 415130.390625),\n"," 'GODALMING': (271626.2269503546, 1941591.4609929079),\n"," 'SIDCUP': (235988.45394736843, 1275661.3790849673),\n"," 'ELLAND': (79023.1875, 780501.696969697),\n"," 'BATH': (227475.90756302522, 1447447.0223463688),\n"," 'SIDMOUTH': (189189.52380952382, 1017541.25),\n"," 'CREWE': (94340.37637362638, 581724.6318681319),\n"," 'MONMOUTH': (150627.1739130435, 823993.4782608695),\n"," 'DALTON-IN-FURNESS': (81907.35294117648, 310680.8823529412),\n"," 'ST LEONARDS-ON-SEA': (131090.47826086957, 623864.2934782609),\n"," 'HESSLE': (106684.82142857143, 526635.0877192982),\n"," 'HOUGHTON LE SPRING': (57432.75543478261, 305595.32608695654),\n"," 'LYTHAM ST. ANNES': (nan, nan),\n"," 'BASILDON': (181491.34827586208, 986009.4536082475),\n"," 'DURHAM': (61438.150588235294, 471399.5469483568),\n"," 'TRURO': (170204.11111111112, 950527.75),\n"," 'BRIGG': (110127.61538461539, 387923.48484848486),\n"," 'HASSOCKS': (213040.5172413793, 1226461.3389830508),\n"," 'STEYNING': (167692.59259259258, 880392.8571428572),\n"," 'WARE': (216840.88, 1043892.168),\n"," 'WORTHING': (159444.45255474452, 795215.9344660194),\n"," 'MATLOCK': (155971.42857142858, 654737.8282828283),\n"," 'LLANDEILO': (114263.15789473684, 640122.5),\n"," 'LLANDUDNO': (91073.27272727272, 546671.9318181818),\n"," 'WALLSEND': (65639.40845070423, 448159.34265734267),\n"," 'HINCKLEY': (138995.31073446327, 564979.8079096045),\n"," 'TRIMDON STATION': (43481.77272727273, 235751.52173913043),\n"," 'TORPOINT': (127316.04166666667, 652142.8571428572),\n"," 'BLAENAU FFESTINIOG': (76769.23076923077, 295139.0740740741),\n"," 'IVYBRIDGE': (163744.48214285713, 569461.4035087719),\n"," 'FROME': (175539.34285714285, 801455.962264151),\n"," 'BROADSTAIRS': (155632.66279069768, 820009.1954022988),\n"," 'ROMSEY': (205853.15789473685, 1092579.1770833333),\n"," 'NEWPORT PAGNELL': (181179.62962962964, 719992.7272727273),\n"," 'WELLINGBOROUGH': (146079.83458646617, 945704.6441947565),\n"," 'WELLING': (236625.0, 647804.5977011494),\n"," 'DRIFFIELD': (112712.41843971632, 568967.7746478873),\n"," 'SEAFORD': (168168.0253164557, 717191.8),\n"," 'PEWSEY': (177083.33333333334, 1061527.64),\n"," 'AYLESFORD': (183703.609375, 753108.59375),\n"," 'COULSDON': (290157.488372093, 1084715.8275862068),\n"," 'LYMINGTON': (237193.29464285713, 1551029.274336283),\n"," 'GREAT YARMOUTH': (61894.522666666664, 548423.0079787234),\n"," 'ALCESTER': (149107.25, 710040.9836065574),\n"," 'SAFFRON WALDEN': (233552.9223300971, 1175902.701923077),\n"," 'STANFORD-LE-HOPE': (222339.79591836734, 530414.1414141414),\n"," 'EXMOUTH': (153938.15972222222, 714965.5172413794),\n"," 'WELWYN GARDEN CITY': (201813.2265625, 928405.2109375),\n"," 'LICHFIELD': (149071.59354838709, 725645.5384615385),\n"," 'NORTH SHIELDS': (78863.25130890052, 463288.9895287958),\n"," 'FARNHAM': (252785.02958579882, 1869636.177514793),\n"," 'BODMIN': (109468.125, 629073.975),\n"," 'GODSTONE': (161859.39130434784, 1133929.1666666667),\n"," 'WILLENHALL': (89694.66666666667, 290113.36440677964),\n"," 'WEST BROMWICH': (93371.05042016807, 383047.5),\n"," 'NEWHAVEN': (176048.425, 548619.2926829269),\n"," 'TADCASTER': (154687.54285714286, 586648.6111111111),\n"," 'THETFORD': (148819.5054945055, 674110.9180327869),\n"," 'SEAHAM': (54671.25, 338469.5714285714),\n"," 'WOKINGHAM': (260312.955, 1101871.7711442786),\n"," 'HARLOW': (183873.8313253012, 784930.724),\n"," 'BROADSTONE': (246506.7142857143, 2845371.4285714286),\n"," 'REDRUTH': (123875.92380952381, 1578792.3301886793),\n"," 'CRAMLINGTON': (73179.52991452992, 352859.78813559323),\n"," 'ASHINGTON': (46075.14173228347, 289964.0236220473),\n"," 'CALNE': (165941.61363636365, 824471.9101123596),\n"," 'LLANGOLLEN': (112583.88888888889, 514518.51851851854),\n"," 'MARCH': (137139.38053097346, 485960.93859649124),\n"," 'LIGHTWATER': (190675.05, 922357.1428571428),\n"," 'BLACKBURN': (65922.27792207792, 463781.8031088083),\n"," 'ABERDARE': (68190.72307692308, 297503.4198473282),\n"," 'ABERGELE': (122769.74285714286, 404657.74647887325),\n"," 'STAINES-UPON-THAMES': (219549.2857142857, 1134601.5957446808),\n"," 'DURSLEY': (147944.11290322582, 564472.0967741936),\n"," 'GOOLE': (88293.7375, 431073.82608695654),\n"," 'WITHERNSEA': (76406.0, 226769.15384615384),\n"," 'GAINSBOROUGH': (60176.15646258504, 460888.16891891893),\n"," 'HORNSEA': (114143.54838709677, 327539.0625),\n"," 'BEDLINGTON': (62224.769230769234, 361549.24242424243),\n"," 'BEDALE': (148493.66666666666, 656241.9354838709),\n"," 'WHITBY': (144605.48780487804, 614806.9634146341),\n"," 'THIRSK': (137230.8088235294, 716340.9710144928),\n"," 'FILEY': (93137.23809523809, 400935.140625),\n"," 'SKIPTON': (145240.9393939394, 766769.9),\n"," 'LLANELLI': (84770.43049327354, 636648.8169642857),\n"," 'PENARTH': (151875.75757575757, 782253.2),\n"," 'PEMBROKE DOCK': (87722.0294117647, 341298.5714285714),\n"," 'WELSHPOOL': (119515.34210526316, 624166.6666666666),\n"," 'LLANIDLOES': (94500.0, 437000.0),\n"," 'HAVERFORDWEST': (110713.45098039215, 544807.1456310679),\n"," 'LLANDUDNO JUNCTION': (109563.15789473684, 488125.0),\n"," 'USK': (207194.44444444444, 878500.4210526316),\n"," 'LLANFYLLIN': (110500.0, 691658.3333333334),\n"," 'LLANGEFNI': (112065.78947368421, 508672.25),\n"," 'MENAI BRIDGE': (127680.27777777778, 633368.4210526316),\n"," 'CLYNDERWEN': (109642.85714285714, 521428.5714285714),\n"," 'CARDIGAN': (124482.14285714286, 727472.023255814),\n"," 'BRECON': (132240.19607843139, 878860.5),\n"," 'BANGOR': (92697.82666666666, 399846.84210526315),\n"," 'LEYLAND': (111161.03267973856, 394406.1038961039),\n"," 'RICKMANSWORTH': (316440.203539823, 1666595.9736842106),\n"," 'TOWCESTER': (219449.04705882352, 803176.2235294117),\n"," 'NANTWICH': (118223.52032520325, 673825.5725806452),\n"," 'IBSTOCK': (146770.83333333334, 369704.1666666667),\n"," 'LLANFAIRPWLLGWYNGYLL': (115309.5625, 560000.0),\n"," 'COALVILLE': (140899.52127659574, 642702.7037037037),\n"," 'SHIPLEY': (99193.29370629371, 466115.7132867133),\n"," 'ST. LEONARDS-ON-SEA': (nan, nan),\n"," 'BIRKENHEAD': (62380.69942196532, 343039.275862069),\n"," 'WEYMOUTH': (139889.9954954955, 614453.3901345291),\n"," 'NORMANTON': (95010.84285714285, 1485662.0563380283),\n"," 'BUXTON': (118230.0350877193, 627630.1565217391),\n"," 'MERTHYR TYDFIL': (70329.3455882353, 333866.5328467153),\n"," 'BILSTON': (92032.10576923077, 314332.95238095237),\n"," 'DEAL': (180067.44827586206, 760779.1452991453),\n"," 'SHOREHAM-BY-SEA': (198310.6081081081, 945518.12),\n"," 'MARLBOROUGH': (215946.36486486485, 1300548.3466666667),\n"," 'LEISTON': (152193.75, 612378.7878787878),\n"," 'NELSON': (50131.56737588652, 306430.93617021275),\n"," 'WALTHAM ABBEY': (218297.91666666666, 869951.9863013698),\n"," 'BINGLEY': (108134.09090909091, 514075.01123595505),\n"," 'TORQUAY': (103721.44, 594822.52),\n"," 'WYMONDHAM': (177331.58227848102, 577404.0),\n"," 'NESTON': (143268.9, 703596.0392156863),\n"," 'HUNSTANTON': (149744.86842105264, 787366.4102564103),\n"," 'IMMINGHAM': (76972.97297297297, 238284.2105263158),\n"," 'WOODFORD GREEN': (276790.7978723404, 1129511.8404255318),\n"," 'ALNWICK': (107194.41428571429, 568546.661971831),\n"," 'HARPENDEN': (301122.44897959183, 1840908.0808080807),\n"," 'PORT TALBOT': (78615.33950617284, 324236.2760736196),\n"," 'BARTON-UPON-HUMBER': (88670.83333333333, 381198.55102040817),\n"," 'BROMYARD': (96605.26315789473, 640950.0),\n"," 'BUDLEIGH SALTERTON': (187363.46153846153, 1111237.037037037),\n"," 'ACCRINGTON': (55867.688888888886, 320118.8230088496),\n"," 'SOUTHAM': (179088.115942029, 816852.6571428571),\n"," 'CARTERTON': (171266.83333333334, 1078251.6216216215),\n"," 'STAFFORD': (126267.66096866097, 689772.9573863636),\n"," 'SANDOWN': (91418.95081967213, 567683.0645161291),\n"," 'TROWBRIDGE': (141967.67515923566, 641827.0696202532),\n"," 'BIGGLESWADE': (180153.8785046729, 671834.3703703703),\n"," 'KENILWORTH': (175440.625, 1119959.3424657534),\n"," 'NEWQUAY': (140079.45901639343, 918749.650406504),\n"," 'DEREHAM': (138097.98449612403, 591659.5230769231),\n"," 'CREWKERNE': (132709.16666666666, 690793.7837837838),\n"," 'SHREWSBURY': (133503.8355091384, 677528.3125),\n"," 'BRIDGWATER': (135132.2048192771, 814183.396),\n"," 'SWADLINCOTE': (118320.55405405405, 426602.8251121076),\n"," 'MELTON MOWBRAY': (150611.9375, 594993.59375),\n"," 'SOUTH OCKENDON': (184191.17647058822, 459978.26086956525),\n"," 'BRIXHAM': (147526.27272727274, 617017.8205128205),\n"," 'CALLINGTON': (87643.54838709677, 536593.75),\n"," 'UCKFIELD': (199559.77906976745, 1194640.2298850575),\n"," 'HENLEY-ON-THAMES': (317933.5569620253, 2463313.25),\n"," 'OLDBURY': (101998.18589743589, 347694.58598726115),\n"," 'PEACEHAVEN': (193063.08333333334, 652973.7704918033),\n"," 'RINGWOOD': (210154.79452054793, 1371453.972972973),\n"," 'EVESHAM': (140147.5076923077, 618439.6488549619),\n"," 'EASTLEIGH': (162173.2226720648, 679788.4677419355),\n"," 'STROUD': (168837.94186046513, 1085721.6416184972),\n"," 'MOLD': (125733.14606741573, 545987.7777777778),\n"," 'OTLEY': (162341.17647058822, 955222.0),\n"," 'YARM': (131026.81132075471, 559457.1851851852),\n"," 'ABINGDON': (207391.39877300613, 950937.6890243902),\n"," 'HOLMFIRTH': (129978.12096774194, 614834.9112903225),\n"," 'TREHARRIS': (81693.47826086957, 348339.3617021277),\n"," 'CLECKHEATON': (86176.6, 491820.38157894736),\n"," 'MORDEN': (245836.57534246575, 713521.2297297297),\n"," 'RAINHAM': (234151.7011494253, 1058112.4431818181),\n"," 'NORTHWOOD': (281302.0833333333, 2152897.9591836734),\n"," 'WEST WICKHAM': (300296.0, 939969.3333333334),\n"," 'BLAYDON-ON-TYNE': (81039.16666666667, 339012.54098360654),\n"," 'STOWMARKET': (151188.5891472868, 1112788.476923077),\n"," 'HENLEY-IN-ARDEN': (231936.47368421053, 1410875.0),\n"," 'CALDICOT': (194164.31506849316, 503913.91891891893),\n"," 'RUNCORN': (79670.50877192983, 824033.2865497076),\n"," 'PAR': (145793.53846153847, 543250.0),\n"," 'STANSTED': (285309.28571428574, 898850.1363636364),\n"," 'PENRITH': (115876.73333333334, 666056.0735294118),\n"," 'FRESHWATER': (134516.8, 617421.1538461539),\n"," 'ROCHFORD': (165901.42424242425, 704418.8636363636),\n"," 'ATHERSTONE': (129995.25862068965, 876905.6101694915),\n"," 'SHEPTON MALLET': (139278.30188679244, 977011.2962962963),\n"," 'HALSTEAD': (172440.11392405065, 744759.9125),\n"," 'HAYLING ISLAND': (151833.62068965516, 758654.2372881356),\n"," 'HUNTINGDON': (155573.07317073172, 1115180.59375),\n"," 'ESHER': (354793.1285714286, 4131870.084507042),\n"," 'ELY': (182742.59360730593, 562447.2045454546),\n"," 'WHITSTABLE': (224909.39215686274, 860940.4466019417),\n"," 'STOCKTON-ON-TEES': (63801.78154425612, 381271.24060150376),\n"," 'DEVIZES': (152136.125, 739943.6283185841),\n"," 'WARMINSTER': (139597.79569892472, 837567.1063829787),\n"," 'TONYPANDY': (62953.64705882353, 209188.07246376813),\n"," 'NEATH': (76431.57219251337, 329686.8882978723),\n"," 'SKELMERSDALE': (70786.1603773585, 765250.0),\n"," 'TENTERDEN': (211671.875, 908206.28125),\n"," 'DAWLISH': (108444.11764705883, 636923.0769230769),\n"," 'MARKET HARBOROUGH': (180279.0583941606, 707398.195652174),\n"," 'PONTEFRACT': (82555.65743944637, 370988.56747404847),\n"," 'STAINES': (128333.33333333333, 715000.0),\n"," 'HORLEY': (200792.3947368421, 878481.7304347826),\n"," 'TADWORTH': (248318.98591549296, 1820916.0833333333),\n"," 'MALMESBURY': (180260.88888888888, 1219505.4347826086),\n"," 'TORRINGTON': (155005.0, 471601.347826087),\n"," 'WORCESTER PARK': (300142.36904761905, 955645.8),\n"," 'REDDITCH': (136302.4549356223, 507901.9316239316),\n"," 'BERWICK-UPON-TWEED': (85148.14814814815, 512569.6909090909),\n"," 'THAME': (237907.56896551725, 919372.033898305),\n"," 'BEWDLEY': (145227.5172413793, 758024.9310344828),\n"," 'HAVANT': (156901.0, 964800.373015873),\n"," 'FERNDOWN': (175029.81651376147, 833783.1818181818),\n"," 'BOLDON COLLIERY': (48919.230769230766, 355341.92307692306),\n"," 'HEBBURN': (65835.29487179487, 290373.4556962025),\n"," 'ROWLEY REGIS': (112852.20588235294, 443627.53623188403),\n"," 'HEANOR': (98105.39682539682, 645225.78125),\n"," 'CASTLEFORD': (90643.6972972973, 323268.3548387097),\n"," 'HUNGERFORD': (207237.9, 1096298.12),\n"," 'SOUTHALL': (223281.5974025974, 903926.5897435897),\n"," 'KINGSTON UPON THAMES': (299748.59589041094, 2527762.7891156464),\n"," 'MUCH WENLOCK': (259550.0, 793227.2727272727),\n"," 'FERRYHILL': (38162.875, 222922.0224719101),\n"," 'STANLEY': (42729.28378378379, 226306.0),\n"," 'CROWBOROUGH': (210509.22222222222, 1134786.6666666667),\n"," 'GREENHITHE': (163878.72340425532, 510312.5),\n"," 'ABERTILLERY': (61511.971830985916, 223575.625),\n"," 'STAMFORD': (170105.99099099098, 903797.1517857143),\n"," 'ASHTON-UNDER-LYNE': (96784.70348837209, 352274.37572254334),\n"," 'SALE': (166680.43956043955, 848437.5792349727),\n"," 'CLEVEDON': (187657.0588235294, 779085.7558139535),\n"," 'WITNEY': (201080.5, 907636.7080745342),\n"," 'FLEETWOOD': (65312.51190476191, 341859.6352941177),\n"," 'FARINGDON': (173600.45098039217, 779490.5961538461),\n"," 'WELWYN': (352621.71875, 1570662.9696969697),\n"," 'FRODSHAM': (141612.375, 665541.9642857143),\n"," 'DORKING': (222104.08910891088, 1471718.0392156863),\n"," 'FAREHAM': (166222.31986531988, 674022.6208053691),\n"," 'ELLESMERE PORT': (94429.17977528089, 403076.46368715086),\n"," \"BISHOP'S STORTFORD\": (246906.3184357542, 993489.75),\n"," 'EYE': (197181.37931034484, 3156483.2),\n"," 'OKEHAMPTON': (150308.11290322582, 745289.0793650794),\n"," 'SWANAGE': (157080.22727272726, 841946.8),\n"," 'GRAVESEND': (182350.6566037736, 764014.515037594),\n"," 'NORTHWICH': (107761.43083003952, 606073.9015748032),\n"," 'POTTERS BAR': (250315.29411764705, 1490887.2209302327),\n"," 'DULVERTON': (215531.25, 937500.0),\n"," 'STALYBRIDGE': (103985.02380952382, 416329.4117647059),\n"," 'HYDE': (111960.75167785234, 388042.43333333335),\n"," 'RYTON': (79104.4262295082, 373671.29032258067),\n"," 'BATLEY': (72482.07920792079, 401165.34653465345),\n"," 'BRANDON': (149955.73333333334, 345811.47540983604),\n"," 'SANDWICH': (233353.675, 825031.25),\n"," 'WEYBRIDGE': (272458.37362637365, 3070367.554347826),\n"," 'HATFIELD': (216289.31914893616, 1302936.2210526315),\n"," 'WHITEHAVEN': (71121.75, 298479.603960396),\n"," 'LAUNCESTON': (110877.69230769231, 681229.5454545454),\n"," 'KINGSBRIDGE': (175502.525, 1297655.0987654321),\n"," 'WINSFORD': (87020.89622641509, 519655.57009345794),\n"," 'CRICCIETH': (130800.0, 586785.7142857143),\n"," 'BUSHEY': (272818.75, 1218474.1232876712),\n"," 'LLANDYSUL': (133653.125, 668685.6666666666),\n"," 'BARKING': (172566.44186046513, 1954287.3448275863),\n"," 'WINDSOR': (276729.73529411765, 1527909.9411764706),\n"," 'TREORCHY': (64634.651162790695, 227328.18181818182),\n"," 'SITTINGBOURNE': (165376.55895196507, 792914.8913043478),\n"," 'PULBOROUGH': (238405.3924050633, 1187323.0632911392),\n"," 'MALTON': (143662.16216216216, 565165.84),\n"," 'WIDNES': (85887.5411764706, 401396.0411764706),\n"," 'SOUTH PETHERTON': (200675.0, 782775.0),\n"," 'TENBY': (141660.97222222222, 719110.027027027),\n"," 'TETBURY': (205472.0588235294, 978149.5142857142),\n"," 'WARWICK': (187533.0956937799, 904227.280952381),\n"," 'RADLETT': (350485.1, 2307536.5853658537),\n"," 'ALRESFORD': (245552.5483870968, 1611310.9375),\n"," 'HAYLE': (134639.39215686274, 643516.7884615385),\n"," 'CREDITON': (158837.96296296295, 758667.9636363636),\n"," 'FAVERSHAM': (180901.54022988505, 709021.2528735632),\n"," 'MARKET RASEN': (102438.88888888889, 503642.0),\n"," 'KENLEY': (262368.9655172414, 1182099.8333333333),\n"," 'LISKEARD': (118898.17647058824, 659773.2093023256),\n"," 'NEWTON AYCLIFFE': (65699.21176470588, 297498.0581395349),\n"," 'BACUP': (69139.39393939394, 362473.3181818182),\n"," 'ROWLANDS GILL': (89357.14285714286, 479208.75),\n"," 'CHORLEY': (95992.81305637982, 466570.5147928994),\n"," 'STRATFORD-UPON-AVON': (169834.78431372548, 1027322.974025974),\n"," 'EAST BOLDON': (88664.28571428571, 423113.63636363635),\n"," 'LEEK': (93765.29411764706, 707831.1627906977),\n"," 'CHOPPINGTON': (48639.65517241379, 229318.33333333334),\n"," 'WELLINGTON': (132003.7, 601765.7142857143),\n"," 'CHRISTCHURCH': (206331.04324324324, 1199478.5483870967),\n"," 'HARWICH': (120620.73033707865, 433787.77777777775),\n"," 'KNUTSFORD': (173733.2435897436, 1528747.2911392406),\n"," 'ONGAR': (274190.8, 1127249.677419355),\n"," 'MARLOW': (296270.95384615386, 1827203.3333333333),\n"," 'CINDERFORD': (115136.36363636363, 372192.4705882353),\n"," 'BRIDPORT': (154212.80487804877, 989593.6585365854),\n"," 'PRESTATYN': (101430.1282051282, 339277.83544303797),\n"," 'ST. AUSTELL': (nan, nan),\n"," 'SHEPPERTON': (225487.6326530612, 883185.84),\n"," 'DENBIGH': (103618.66666666667, 512803.1304347826),\n"," 'EDENBRIDGE': (224692.86842105264, 1682018.5384615385),\n"," 'ST HELENS': (74423.81313131313, 335025.9496221662),\n"," 'TIPTON': (73396.53571428571, 334000.0),\n"," 'TEIGNMOUTH': (132545.2380952381, 729947.1529411764),\n"," 'DORCHESTER': (139447.1017964072, 793875.2857142857),\n"," 'STONE': (128453.63529411764, 862686.3953488372),\n"," 'ARUNDEL': (221404.65217391305, 922653.7872340425),\n"," 'DRYBROOK': (181500.0, 427000.0),\n"," 'WHYTELEAFE': (172393.18181818182, 741663.0434782609),\n"," 'VIRGINIA WATER': (306765.65, 7602207.619047619),\n"," 'ETCHINGHAM': (225630.0, 1437415.625),\n"," 'WEST MALLING': (269312.8289473684, 1218474.012987013),\n"," 'CHESHAM': (221441.5072463768, 1152557.9710144927),\n"," 'AMMANFORD': (100366.46067415731, 350676.9775280899),\n"," 'SPILSBY': (113093.27586206897, 470351.6666666667),\n"," 'SALTASH': (142372.65151515152, 580351.4029850747),\n"," 'ROBERTSBRIDGE': (185989.2857142857, 1543073.3333333333),\n"," 'SANDHURST': (227462.96296296295, 729649.8181818182),\n"," 'LIPHOOK': (192418.23529411765, 1634301.5714285714),\n"," 'RETFORD': (97419.896, 573701.4206349206),\n"," 'HENLOW': (210600.0, 740781.6666666666),\n"," 'GERRARDS CROSS': (375509.868852459, 2141708.3870967743),\n"," 'UPMINSTER': (297279.57692307694, 1027358.9743589744),\n"," 'KINGSWINFORD': (143808.37662337662, 459979.4871794872),\n"," 'GUISBOROUGH': (81827.6119402985, 381491.17647058825),\n"," 'MILFORD HAVEN': (93893.0, 363365.609375),\n"," 'ILMINSTER': (142544.09523809524, 642496.5476190476),\n"," 'STONEHOUSE': (170257.57407407407, 690845.2727272727),\n"," 'LEYBURN': (174082.0344827586, 660300.0),\n"," 'ST IVES': (172467.7438016529, 1092220.024590164),\n"," 'PORTH': (66754.94318181818, 271412.13483146066),\n"," 'CWMBRAN': (112494.26470588235, 590624.5182481752),\n"," 'PONTYPRIDD': (92185.06532663316, 372034.0),\n"," 'BARGOED': (71155.47619047618, 274285.59523809527),\n"," 'NORTH WALSHAM': (144501.22, 502016.6862745098),\n"," 'CULLOMPTON': (153827.26153846155, 736635.4769230769),\n"," 'WEST MOLESEY': (275700.0, 1232909.0487804879),\n"," 'ABERYSTWYTH': (128125.30769230769, 491398.86363636365),\n"," 'BENFLEET': (227522.76712328766, 683764.9178082192),\n"," 'BEXHILL-ON-SEA': (138659.03686635944, 739781.2981651376),\n"," 'PRENTON': (89442.78740157481, 512244.765625),\n"," 'REDHILL': (205226.07784431137, 1033390.6011904762),\n"," 'BIRCHINGTON': (155053.11111111112, 697282.6086956522),\n"," 'WORKINGTON': (60949.67857142857, 393317.80530973454),\n"," 'TONBRIDGE': (217562.7014925373, 1098048.5427509295),\n"," 'SHAFTESBURY': (177350.76, 922345.0),\n"," 'ILFRACOMBE': (121807.28571428571, 653751.8596491228),\n"," 'SEATON': (132337.85714285713, 903192.5813953489),\n"," 'LANCING': (190883.5617977528, 608499.411111111),\n"," 'BOSTON': (99412.5924369748, 431682.67782426777),\n"," 'LEOMINSTER': (123569.93333333333, 670172.131147541),\n"," 'CORSHAM': (186363.50943396226, 719561.1296296297),\n"," 'PURFLEET': (200000.0, 238750.0),\n"," 'STOURPORT-ON-SEVERN': (130014.61538461539, 621040.9076923077),\n"," 'HEXHAM': (114423.78048780488, 657896.6585365854),\n"," 'WESTCLIFF-ON-SEA': (138157.6894409938, 713368.9567901235),\n"," 'STURMINSTER NEWTON': (186406.76470588235, 1088936.9428571428),\n"," 'HOCKLEY': (306194.58461538464, 888265.1515151515),\n"," 'RAYLEIGH': (243482.32323232322, 916555.5555555555),\n"," 'KENDAL': (114364.41726618705, 728882.1214285714),\n"," 'MARTOCK': (152775.0, 592863.8461538461),\n"," 'RAMSGATE': (144243.92771084336, 553745.421686747),\n"," 'NEWBIGGIN-BY-THE-SEA': (55800.0, 185916.66666666666),\n"," 'PRESCOT': (94749.7741935484, 369562.264),\n"," 'MILLOM': (59105.0, 358940.0),\n"," 'ST. COLUMB': (nan, nan),\n"," 'BRIDLINGTON': (30261.005555555555, 343399.27624309395),\n"," 'HODDESDON': (208586.18032786885, 849943.1290322581),\n"," 'BEXLEY': (282419.60655737703, 853888.7096774194),\n"," 'CHESSINGTON': (271700.96153846156, 736923.5849056604),\n"," 'WELLS-NEXT-THE-SEA': (316250.0, 932256.75),\n"," 'HORNCASTLE': (101120.40909090909, 488411.8222222222),\n"," 'TRING': (251506.1403508772, 1094499.1929824562),\n"," \"KING'S LYNN\": (131603.9721362229, 685060.0308641975),\n"," 'MORETON-IN-MARSH': (199821.28205128206, 1610138.925),\n"," 'HEATHFIELD': (160876.31578947368, 1157955.0877192982),\n"," 'CHIGWELL': (253196.26, 1691884.3333333333),\n"," 'BARROW-UPON-HUMBER': (94065.21739130435, 398354.1666666667),\n"," 'YATELEY': (304787.2340425532, 850104.6041666666),\n"," 'LEDBURY': (145581.6, 874323.4130434783),\n"," 'FORDINGBRIDGE': (219649.15555555557, 965515.7826086957),\n"," 'TILBURY': (173510.75, 581787.5),\n"," 'PONTYCLUN': (140826.5375, 477561.9012345679),\n"," 'CAMBORNE': (111788.63636363637, 434682.2921348315),\n"," 'SANDY': (188645.54545454544, 702929.2337662338),\n"," 'CHURCH STRETTON': (128704.40909090909, 760670.4545454546),\n"," 'SUDBURY': (179595.748502994, 745921.8323353294),\n"," 'DARTMOUTH': (29890.1875, 1154979.5918367347),\n"," 'HONITON': (132861.6883116883, 648828.6282051282),\n"," 'WINDERMERE': (189591.25, 1306930.0487804879),\n"," 'ASCOT': (301009.8522727273, 2371628.820224719),\n"," 'PERSHORE': (178588.42592592593, 738381.4545454546),\n"," 'BURY ST EDMUNDS': (179728.01333333334, 1122327.699468085),\n"," 'CLITHEROE': (131624.73504273503, 677355.1440677966),\n"," 'BROUGH': (124629.97872340426, 476960.9894736842),\n"," 'FRINTON-ON-SEA': (194938.6507936508, 601546.796875),\n"," 'GRANGE-OVER-SANDS': (131083.15789473685, 595410.2564102564),\n"," 'STOCKSFIELD': (134265.38461538462, 1020230.7692307692),\n"," 'SUTTON-IN-ASHFIELD': (84423.23741007195, 506808.75),\n"," 'BUCKHURST HILL': (295267.4418604651, 1118284.0909090908),\n"," 'PENMAENMAWR': (82708.35714285714, 337496.6666666667),\n"," 'AMBLESIDE': (197283.91304347827, 1634899.5416666667),\n"," 'EAST MOLESEY': (346470.1111111111, 2265760.714285714),\n"," 'SWANLEY': (228349.2857142857, 1365029.8245614036),\n"," 'GLASTONBURY': (127164.76190476191, 709707.4651162791),\n"," 'BUNTINGFORD': (231537.9714285714, 982004.1666666666),\n"," 'WALTON ON THE NAZE': (141618.18181818182, 401632.0588235294),\n"," 'HENGOED': (103107.69230769231, 336516.9811320755),\n"," 'PORTLAND': (121519.69387755102, 397312.8),\n"," 'ULVERSTON': (126090.20588235294, 743702.1739130435),\n"," 'TREDEGAR': (69484.92424242424, 272253.6567164179),\n"," 'WATCHET': (147425.0, 699396.052631579),\n"," 'DUNMOW': (218548.9120879121, 1052385.2173913044),\n"," 'CHISLEHURST': (293752.09230769234, 1605781.2878787878),\n"," 'RYE': (177940.0909090909, 913887.4107142857),\n"," 'SHANKLIN': (114183.33333333333, 535316.6976744186),\n"," 'HOLYWELL': (100925.60655737705, 455573.53225806454),\n"," 'CRAVEN ARMS': (139976.19047619047, 858386.3636363636),\n"," 'VENTNOR': (138813.5652173913, 756078.7234042553),\n"," 'WINSCOMBE': (221384.61538461538, 729639.6296296297),\n"," 'HASLEMERE': (231473.33333333334, 1685354.0),\n"," 'CONGLETON': (120472.43333333333, 584920.214876033),\n"," 'LYME REGIS': (179484.60869565216, 1004995.6521739131),\n"," 'SKEGNESS': (88932.82882882883, 1420006.9642857143),\n"," 'ALFORD': (115145.83333333333, 416979.1666666667),\n"," 'LYTHAM ST ANNES': (81072.3512195122, 580189.1699029126),\n"," 'PETWORTH': (240938.23529411765, 1947361.111111111),\n"," 'BARNOLDSWICK': (92364.30769230769, 370025.5303030303),\n"," 'ST ALBANS': (261443.582010582, 1383402.9126984128),\n"," 'PENTRE': (58465.71428571428, 215905.13888888888),\n"," 'SEASCALE': (112957.91666666667, 371919.23076923075),\n"," 'BRAMPTON': (90289.28571428571, 490355.35714285716),\n"," 'PENRHYNDEUDRAETH': (91500.0, 321642.85714285716),\n"," 'FLEET': (202665.2857142857, 891012.4060150376),\n"," 'YARMOUTH': (116450.0, 1376136.3636363635),\n"," 'FALMOUTH': (188266.60185185185, 984363.6574074074),\n"," 'BRADFORD-ON-AVON': (187060.71794871794, 1071606.85),\n"," 'SCUNTHORPE': (83862.22461538462, 332130.84969325154),\n"," 'MIRFIELD': (106831.50684931508, 413725.47297297296),\n"," 'TAVISTOCK': (138186.83076923076, 676006.0606060605),\n"," 'WARLINGHAM': (234648.61111111112, 1266189.189189189),\n"," 'HALTWHISTLE': (76500.0, 466300.0),\n"," 'HOLYHEAD': (82359.02777777778, 632878.7671232877),\n"," 'ASHTEAD': (281940.0, 1327712.5),\n"," 'BORDON': (192045.26470588235, 887468.9275362319),\n"," 'BATTLE': (174032.92682926828, 1058236.261904762),\n"," 'KNOTTINGLEY': (89114.02173913043, 291691.4680851064),\n"," 'BEAUMARIS': (124107.14285714286, 610533.3333333334),\n"," 'MARKFIELD': (129997.5, 457095.2380952381),\n"," 'KIDWELLY': (70493.20833333333, 373156.0),\n"," 'BUNGAY': (155080.0, 569038.4615384615),\n"," 'LITTLEBOROUGH': (107629.94642857143, 373512.3214285714),\n"," 'TENBURY WELLS': (140952.27272727274, 745218.5652173914),\n"," 'IVER': (310639.0625, 9055030.303030303),\n"," 'DOWNHAM MARKET': (143495.7258064516, 463557.9365079365),\n"," 'FAIRFORD': (238184.2105263158, 860000.0),\n"," 'WELLS': (185154.79452054793, 870570.9054054054),\n"," 'SHERBORNE': (184556.08333333334, 979750.1917808219),\n"," 'TARPORLEY': (221539.5625, 1021039.4791666666),\n"," 'BEMBRIDGE': (183542.92857142858, 765966.6666666666),\n"," 'LLANDOVERY': (108916.66666666667, 663037.9230769231),\n"," 'BEACONSFIELD': (477171.76470588235, 2922254.901960784),\n"," 'SNODLAND': (183293.13157894736, 447383.3333333333),\n"," 'NORTH TAWTON': (122092.85714285714, 497857.14285714284),\n"," 'LIVERSEDGE': (91296.1568627451, 387828.67307692306),\n"," 'RUISLIP': (285511.3028169014, 991666.1748251749),\n"," 'HALESWORTH': (147632.35294117648, 687581.6285714286),\n"," 'MARKET DRAYTON': (136385.79411764705, 864410.8695652174),\n"," 'LEE-ON-THE-SOLENT': (152355.26315789475, 671986.9230769231),\n"," 'WINKLEIGH': (161666.66666666666, 829730.7692307692),\n"," 'HINDHEAD': (223175.0, 1530339.896551724),\n"," 'STOCKBRIDGE': (345957.1052631579, 1706100.0),\n"," 'DELABOLE': (128723.33333333333, 415357.14285714284),\n"," 'CRANBROOK': (232945.0980392157, 1395126.2884615385),\n"," 'SAWBRIDGEWORTH': (196503.37837837837, 994868.4210526316),\n"," 'SHILDON': (37820.93877551021, 182347.9),\n"," 'CHALFONT ST GILES': (457600.0, 2302857.1428571427),\n"," 'ABERAERON': (176148.75, 565555.5555555555),\n"," 'KESWICK': (175566.66666666666, 920476.0645161291),\n"," 'BEAMINSTER': (165318.75, 887635.24),\n"," 'LEWES': (256341.85714285713, 1288377.3333333333),\n"," 'SHERINGHAM': (145154.0, 587518.03125),\n"," 'OLNEY': (226359.375, 1229757.8125),\n"," 'CRANLEIGH': (255371.93548387097, 1211662.9032258065),\n"," 'ABERGAVENNY': (161494.21333333335, 804289.8157894737),\n"," 'MELKSHAM': (173340.9702970297, 677779.7524752475),\n"," 'CROOK': (53970.35064935065, 273226.16883116885),\n"," 'SOUTHMINSTER': (189382.59259259258, 677592.5925925926),\n"," 'EPPING': (309916.60256410256, 1270220.5128205128),\n"," 'DRONFIELD': (159194.23076923078, 578841.803030303),\n"," 'TOTNES': (202648.35820895524, 959534.9558823529),\n"," 'PENRYN': (148964.2857142857, 483592.85714285716),\n"," 'KESTON': (127728.75, 2238666.6666666665),\n"," 'NORTH FERRIBY': (160098.88888888888, 748884.2702702703),\n"," 'SETTLE': (146541.45, 581636.1904761905),\n"," 'MEXBOROUGH': (57888.87254901961, 251878.64077669903),\n"," 'FLINT': (105331.53333333334, 333079.03225806454),\n"," 'BUILTH WELLS': (133283.17647058822, 2706235.294117647),\n"," 'KINGS LANGLEY': (9970.57142857143, 1220733.5352112676),\n"," 'WEST BYFLEET': (256696.0, 1623938.6666666667),\n"," 'AXMINSTER': (137812.5, 876184.6756756756),\n"," 'MAYFIELD': (310916.6666666667, 1689538.4615384615),\n"," 'EGREMONT': (67326.08695652174, 316222.875),\n"," 'TOTLAND BAY': (151268.18181818182, 647545.4545454546),\n"," 'RHAYADER': (121937.5, 405000.0),\n"," 'CHINNOR': (260879.16666666666, 1377640.0),\n"," 'Y FELINHELI': (117181.81818181818, 393833.3333333333),\n"," 'NEWTOWN': (106459.875, 479973.8780487805),\n"," 'BAGSHOT': (218747.61904761905, 912673.6818181818),\n"," 'SEAVIEW': (223384.61538461538, 1013269.2307692308),\n"," 'HOLSWORTHY': (142533.33333333334, 1163043.2432432433),\n"," 'NARBERTH': (121139.13043478261, 578187.8333333334),\n"," 'INGATESTONE': (356706.8965517241, 1698816.6666666667),\n"," 'WESTBURY': (152481.67105263157, 568206.4935064935),\n"," 'ASHBOURNE': (164826.9605263158, 990022.4675324676),\n"," 'VERWOOD': (231309.78260869565, 690763.5869565217),\n"," 'THAMES DITTON': (359432.8947368421, 2311590.923076923),\n"," 'BANSTEAD': (310702.23214285716, 1228200.4107142857),\n"," 'ST. AGNES': (nan, nan),\n"," 'PORT ISAAC': (250000.0, 1263333.3333333333),\n"," 'PWLLHELI': (146616.46153846153, 1549470.0),\n"," 'ABBOTS LANGLEY': (256462.96296296295, 892644.6428571428),\n"," 'BURES': (252571.42857142858, 1311571.4285714286),\n"," 'TIDWORTH': (123732.35294117648, 387638.8888888889),\n"," 'LISS': (204326.92307692306, 1619780.7407407407),\n"," 'PEVENSEY': (216703.75, 640376.5853658536),\n"," 'MANNINGTREE': (181173.4693877551, 636709.98),\n"," 'WINGATE': (46515.21052631579, 216185.0),\n"," 'LAMPETER': (92647.5, 577047.619047619),\n"," 'BROADWAY': (171950.0, 1543061.857142857),\n"," 'HOLT': (201061.62790697673, 1240747.75),\n"," 'ALDEBURGH': (294384.6153846154, 1847327.923076923),\n"," 'WOTTON-UNDER-EDGE': (199045.45454545456, 817553.5454545454),\n"," 'WATLINGTON': (281763.15789473685, 894400.0),\n"," 'LYDNEY': (151693.13559322033, 679033.3333333334),\n"," 'RADSTOCK': (189644.4019607843, 649905.1553398059),\n"," 'DUKINFIELD': (105489.02173913043, 350413.829787234),\n"," 'BUDE': (108907.87272727273, 785023.6),\n"," 'BRUTON': (120800.0, 1112807.6923076923),\n"," 'HARTFIELD': (239000.0, 2407410.0),\n"," 'WESTERHAM': (274424.0333333333, 948605.737704918),\n"," 'FAIRBOURNE': (49625.0, 331380.0),\n"," 'LYMM': (168728.80952380953, 956480.0697674418),\n"," 'CHEPSTOW': (169775.13043478262, 762730.6666666666),\n"," 'SAXMUNDHAM': (182690.24390243902, 1009398.7619047619),\n"," 'HARLECH': (72000.0, 609666.6666666666),\n"," 'SOMERTON': (198775.0, 964112.0689655172),\n"," 'NEW ROMNEY': (131361.89655172414, 699466.6666666666),\n"," 'MILNTHORPE': (194470.0, 694145.0),\n"," 'CHEDDAR': (132691.66666666666, 663986.947368421),\n"," 'DISS': (170508.84146341463, 787141.2926829269),\n"," 'LYNDHURST': (185964.2857142857, 1419133.0),\n"," 'BUCKNELL': (142500.0, 646250.0),\n"," 'LYDBROOK': (153666.66666666666, 546071.4285714285),\n"," 'SOUTH BRENT': (172000.0, 1133125.9090909092),\n"," 'ATTLEBOROUGH': (163076.2711864407, 689664.406779661),\n"," 'CHIPPING CAMPDEN': (237082.38888888888, 1554473.6842105263),\n"," 'TEMPLECOMBE': (151761.53846153847, 668957.6923076923),\n"," 'PADSTOW': (102293.75, 1721941.1764705882),\n"," 'TYWYN': (83330.95, 531072.8571428572),\n"," 'CAERSWS': (126343.75, 462277.77777777775),\n"," 'PRINCES RISBOROUGH': (267870.22222222225, 1035451.0869565217),\n"," 'HOPE VALLEY': (208661.25, 883066.0714285715),\n"," 'OTTERY ST. MARY': (nan, nan),\n"," 'WESTGATE-ON-SEA': (132507.76923076922, 667277.7777777778),\n"," 'TODMORDEN': (82423.3870967742, 445238.09523809527),\n"," 'LANGPORT': (170219.16666666666, 804511.2903225806),\n"," 'COLYTON': (206115.38461538462, 1071414.4285714286),\n"," 'BRAUNTON': (217907.9375, 935322.4545454546),\n"," 'FRIZINGTON': (54861.53846153846, 366771.4285714286),\n"," 'CLEATOR': (41000.0, 258428.57142857142),\n"," 'CEMAES BAY': (147600.0, 528158.3333333334),\n"," 'TYN-Y-GONGL': (149302.61538461538, 426925.0),\n"," 'BROCKENHURST': (378600.0, 3038525.8666666667),\n"," 'FOREST ROW': (235975.0, 1412727.2727272727),\n"," 'KILGETTY': (151772.72727272726, 461250.0),\n"," 'CASTLE CARY': (148417.85714285713, 708033.3333333334),\n"," 'PEMBROKE': (83762.09090909091, 504699.0294117647),\n"," 'LUDLOW': (125945.15625, 643187.9538461538),\n"," 'SWANSCOMBE': (214019.50980392157, 566607.6470588235),\n"," 'BADMINTON': (363210.0, 1654708.3333333333),\n"," 'BRENTFORD': (247395.6896551724, 1228739.5689655172),\n"," 'GOODWICK': (95625.0, 385666.6666666667),\n"," 'LINGFIELD': (147446.75, 1093690.4761904762),\n"," 'LLANON': (148921.42857142858, 668079.125),\n"," 'STUDLEY': (156722.22222222222, 1313657.894736842),\n"," 'YELVERTON': (161614.8620689655, 675816.7),\n"," 'ALDERLEY EDGE': (257862.44, 1734942.3076923077),\n"," 'WYLAM': (178600.0, 953933.6666666666),\n"," 'FISHGUARD': (115823.5294117647, 422277.77777777775),\n"," 'WOODSTOCK': (266073.4705882353, 1042558.3888888889),\n"," 'CONWY': (151828.0487804878, 611411.4634146341),\n"," 'BEAWORTHY': (173395.83333333334, 900846.1538461539),\n"," 'ASKAM-IN-FURNESS': (95957.69230769231, 306000.0),\n"," 'EBBW VALE': (69915.61, 318669.95049504953),\n"," 'LLANGAMMARCH WELLS': (108750.0, 493333.3333333333),\n"," 'GUNNISLAKE': (152660.0, 611546.875),\n"," 'SPENNYMOOR': (50539.46913580247, 317200.743902439),\n"," ...}"]},"execution_count":8,"metadata":{},"output_type":"execute_result"}],"source":["recent_lower_upper = {}\n","\n","for unique in uniques:\n","\n","    prices = df_2022[df_2022[which_unique_col] == unique]['price']\n","    sorted_prices = prices.sort_values()\n","\n","    # bottom 20% of the prices\n","    bottom_20_percent_prices = sorted_prices[:int(0.2 * len(sorted_prices))]\n","\n","    # average of the bottom 20%\n","    average_of_bottom_20_percent = bottom_20_percent_prices.mean()\n","\n","    # top 20% of the prices\n","    top_20_percent_prices = sorted_prices[int(0.8 * len(sorted_prices)):]\n","    # average of the top 20%\n","    average_of_top_20_percent = top_20_percent_prices.mean()\n","\n","    recent_lower_upper[unique] = (average_of_bottom_20_percent, average_of_top_20_percent)\n","    \n","\n","recent_lower_upper"]},{"cell_type":"markdown","metadata":{},"source":["Then from here, you might calculate range or a ratio to determine variance for a given area and then find standouts:"]},{"cell_type":"code","execution_count":9,"metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["Top 5 ratios: [('KINGS LANGLEY', 122.43365828694262), ('DARTMOUTH', 38.64076101351772), ('IVER', 29.149683333950644), ('VIRGINIA WATER', 24.78180858596006), ('BUILTH WELLS', 20.304402744444165)]\n","Top 5 ranges: [('IVER', 8744391.240530303), ('VIRGINIA WATER', 7295441.969047619), ('ESHER', 3777076.9559356133), ('WEMBLEY', 3735620.172220459), ('WEST DRAYTON', 3287904.3513513515)]\n"]}],"source":["ratios = {}\n","ranges = {}\n","\n","for city in recent_lower_upper:\n","    total_range = recent_lower_upper[city][1] - recent_lower_upper[city][0]\n","    ratio = recent_lower_upper[city][1] / recent_lower_upper[city][0]\n","    #confirm ratio is a number:\n","    if not np.isnan(ratio) and not np.isnan(total_range):\n","        #print(f\"City: {city}, ratio: {ratio}, total_range: {total_range}\")\n","\n","        ratios[city] = ratio\n","        ranges[city] = total_range\n","\n","\n","# top 5 ratios:\n","sorted_ratios = sorted(ratios.items(), key=lambda x: x[1], reverse=True)\n","print(f\"Top 5 ratios: {sorted_ratios[:5]}\")\n","\n","# top 5 ranges:\n","sorted_ranges = sorted(ranges.items(), key=lambda x: x[1], reverse=True)\n","print(f\"Top 5 ranges: {sorted_ranges[:5]}\")\n","\n"]},{"cell_type":"code","execution_count":10,"metadata":{},"outputs":[{"data":{"text/plain":["'2023-04-27 00:00'"]},"execution_count":10,"metadata":{},"output_type":"execute_result"}],"source":["# find the earliest date of transfer:\n","df['Date_of_Transfer'].max()"]},{"cell_type":"code","execution_count":11,"metadata":{},"outputs":[],"source":["# sort the dataframe by price:\n","df = df.sort_values(by=['price'], ascending=False)\n","\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":[]}],"metadata":{"accelerator":"GPU","colab":{"gpuType":"T4","provenance":[]},"kernelspec":{"display_name":"Python 3 (ipykernel)","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.10.13"}},"nbformat":4,"nbformat_minor":0}