{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Local Authority Housing Returns\n", "\n", "Metadata for [local authority housing statistics 2017 to 2018](https://www.gov.uk/government/publications/completing-local-authority-housing-statistics-2017-to-2018-guidance-notes)." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "scrolled": true }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MHCLG codeArea codeArea namea1aa1ba2aa2aaa2aba2ba2ba...j3daj3dbj3eaj3ebj3faj3fbj3gaj3gbj3haj3hb
21P2114E06000046Isle of Wight0500.0000.0...0000000000
\n", "

1 rows × 385 columns

\n", "
" ], "text/plain": [ " MHCLG code Area code Area name a1a a1b a2a a2aa a2ab a2b a2ba \\\n", "21 P2114 E06000046 Isle of Wight 0 5 0 0.0 0 0 0.0 \n", "\n", " ... j3da j3db j3ea j3eb j3fa j3fb j3ga j3gb j3ha j3hb \n", "21 ... 0 0 0 0 0 0 0 0 0 0 \n", "\n", "[1 rows x 385 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#The simplest full dataset has code based column labels\n", "lahs_2017_18 = pd.read_csv('LAHS_2017_18/LAHS_2017-18.csv')\n", "\n", "#TIdy up whitespace in column names\n", "lahs_2017_18.columns = [c.strip() for c in lahs_2017_18.columns]\n", "\n", "#Find Island data\n", "lahs_2017_18 = lahs_2017_18[lahs_2017_18['Area name'].str.contains('Wight')]\n", "\n", "#Grab a dict of the Island data (colnames are dict keys, cell values are dict values)\n", "lahs_2017_18_dict = lahs_2017_18.to_dict(orient='records')[0]\n", "\n", "lahs_2017_18" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(44, 385)" ] }, "execution_count": 54, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#Simple data quality check\n", "#Number of informative / non-empty / non-zero cols vs total cols\n", "lahs_2017_18.replace('0','').replace('-','').iloc[0].astype(bool).sum(), len(lahs_2017_18.columns)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "#Read the bulk upload guidance doc\n", "xl = pd.read_excel('LAHS_guidance_notes_bulk_upload.xlsx', sheet_name=None)\n", "\n", "#Clean it...\n", "for k in xl.keys():\n", " #Drop empty cols and empty rows\n", " xl[k] = xl[k].dropna(axis=0, how='all').dropna(axis=1, how='all').reset_index(drop=True)\n", " " ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Cover\n", "Guidance\n", "Upload Guidance\n", "A Stock\n", "B Disposals\n", "C Allocations\n", "D Lettings\n", "E Vacants\n", "F Condition\n", "G Management\n", "H Rents and Rent Arrears\n", "I Affordable Housing Supply\n", "J Affordable Housing Starts\n", "Data Sign Off\n", "Bulk Upload Sheet\n" ] } ], "source": [ "#What are the sheets?\n", "for k in xl.keys():\n", " print(k)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'A': {'sheet': 'A Stock',\n", " 'fullname': 'Section A - Dwelling Stock',\n", " 'name': 'Stock',\n", " 'desc': ''},\n", " 'B': {'sheet': 'B Disposals',\n", " 'fullname': 'Section B - Local Authority Dwelling Sales and Transfers ',\n", " 'name': 'Disposals',\n", " 'desc': ''},\n", " 'C': {'sheet': 'C Allocations',\n", " 'fullname': 'Section C - Allocations',\n", " 'name': 'Allocations',\n", " 'desc': ''},\n", " 'D': {'sheet': 'D Lettings',\n", " 'fullname': 'Section D - Lettings, Nominations and Mobility Schemes',\n", " 'name': 'Lettings',\n", " 'desc': ''},\n", " 'E': {'sheet': 'E Vacants',\n", " 'fullname': 'Section E: Vacants',\n", " 'name': 'Vacants',\n", " 'desc': ''},\n", " 'F': {'sheet': 'F Condition',\n", " 'fullname': 'Section F - Condition of Dwelling Stock',\n", " 'name': 'Condition',\n", " 'desc': ''},\n", " 'G': {'sheet': 'G Management',\n", " 'fullname': 'Section G - Stock Management',\n", " 'name': 'Management',\n", " 'desc': ''},\n", " 'H': {'sheet': 'H Rents and Rent Arrears',\n", " 'fullname': 'Section H - Local Authority Rents and Rent Arrears',\n", " 'name': 'Rents and Rent Arrears',\n", " 'desc': ''},\n", " 'I': {'sheet': 'I Affordable Housing Supply',\n", " 'fullname': 'Section I - Affordable Housing Supply',\n", " 'name': 'Affordable Housing Supply',\n", " 'desc': ''},\n", " 'J': {'sheet': 'J Affordable Housing Starts',\n", " 'fullname': 'Section J - Provision of New Build Affordable Housing STARTS',\n", " 'name': 'Affordable Housing Starts',\n", " 'desc': ''}}" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import re\n", "\n", "#Create a lookup of stuff\n", "metadata={}\n", "#Just grab sheetnames starting with one letter in range A-J then a space...\n", "for k in [k for k in xl.keys() if re.search('^[ABCDEFGHIJ]\\s',k) ]:\n", " \n", " metadata[k.split()[0]]={'sheet':k,'fullname':xl[k].columns[0],\n", " 'name':' '.join(k.split()[1:]), 'desc':''}\n", " xl[k].columns = list(range(0,len(xl[k].columns)))\n", " \n", "metadata" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## A Stock" ] }, { "cell_type": "code", "execution_count": 169, "metadata": {}, "outputs": [], "source": [ "k = 'A'" ] }, { "cell_type": "code", "execution_count": 170, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
01234
0Dwelling Stock In your Local Authority Area as...NaNNaNNaNNaN
1This section collects information on dwelling ...NaNNaNNaNNaN
21. Number of dwellings located in your local a...NaNNaNCensus DefinitionNaN
3NaNa. Local Authority Owned (including those owne...NaNa1aNaN
4NaNb. 'Other' public sector (eg government depart...NaNa1bNaN
5Dwelling Stock Owned by your Local AuthorityNaNNaNNaNNaN
6This section collects information on dwelling ...NaNNaNNaNNaN
72. Number of Dwellings owned by your Local Aut...NaNNaNof whichNaN
8NaNNaNSocial RentAffordable RentAll
9NaNa. Bedsits (including Public Finance Initiativ...a2aaa2aba2a
10NaNb. One bedroom (including Public Finance Initi...a2baa2bba2b
11NaNc. Two bedrooms (including Public Finance Init...a2caa2cba2c
12NaNd. Three bedrooms (including Public Finance In...a2daa2dba2d
13NaNe. Four bedrooms (including Public Finance Ini...a2eaa2eba2e
14NaNf. Five bedrooms (including Public Finance Ini...a2faa2fba2f
15NaNg. Six or more bedrooms (including Public Fina...a2gaa2gba2g
16NaNh. Dwellings equivalent of HMOs Hostels (inclu...a2haa2hba2h
17NaNi. Total (including Public Finance Initiative ...a2iaaa2iaba2ia
18NaNTotal excluding PFI and Shared OwnershipNaNNaNa2ib
19NaNNaNSocial RentNaNAll (£ millions)
203. Total value of stock at 1st January 1999 pr...NaNa3aaNaNa3a
21Changes to Local Authority owned stockNaNNaNNaNNaN
22This section refers to stock owned by your Loc...NaNNaNNaNNaN
23stock at the beginning of the year as it colle...NaNNaNNaNNaN
24had any demolitions, conversions, acquisitions...NaNNaNNaNNaN
254. Changes to Local Authority owned stockNaNNaNNaNNaN
26NaNa. Number of demolitionsNaNa4aNaN
27NaNb i. Number of conversions resulting in an inc...NaNa4baNaN
28NaNb ii. Number of conversions resulting in a dec...NaNa4bbNaN
29NaNc. Number of new buildsNaNa4cNaN
30NaNd. Number of acquisitionsNaNa4dNaN
31Private Sector DemolitionNaNNaNNaNNaN
32This section should be completed by all Local ...NaNNaNNaNNaN
335. Total number of private sector dwellings de...NaNNaNa5aNaN
\n", "
" ], "text/plain": [ " 0 \\\n", "0 Dwelling Stock In your Local Authority Area as... \n", "1 This section collects information on dwelling ... \n", "2 1. Number of dwellings located in your local a... \n", "3 NaN \n", "4 NaN \n", "5 Dwelling Stock Owned by your Local Authority \n", "6 This section collects information on dwelling ... \n", "7 2. Number of Dwellings owned by your Local Aut... \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 3. Total value of stock at 1st January 1999 pr... \n", "21 Changes to Local Authority owned stock \n", "22 This section refers to stock owned by your Loc... \n", "23 stock at the beginning of the year as it colle... \n", "24 had any demolitions, conversions, acquisitions... \n", "25 4. Changes to Local Authority owned stock \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 Private Sector Demolition \n", "32 This section should be completed by all Local ... \n", "33 5. Total number of private sector dwellings de... \n", "\n", " 1 2 \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 a. Local Authority Owned (including those owne... NaN \n", "4 b. 'Other' public sector (eg government depart... NaN \n", "5 NaN NaN \n", "6 NaN NaN \n", "7 NaN NaN \n", "8 NaN Social Rent \n", "9 a. Bedsits (including Public Finance Initiativ... a2aa \n", "10 b. One bedroom (including Public Finance Initi... a2ba \n", "11 c. Two bedrooms (including Public Finance Init... a2ca \n", "12 d. Three bedrooms (including Public Finance In... a2da \n", "13 e. Four bedrooms (including Public Finance Ini... a2ea \n", "14 f. Five bedrooms (including Public Finance Ini... a2fa \n", "15 g. Six or more bedrooms (including Public Fina... a2ga \n", "16 h. Dwellings equivalent of HMOs Hostels (inclu... a2ha \n", "17 i. Total (including Public Finance Initiative ... a2iaa \n", "18 Total excluding PFI and Shared Ownership NaN \n", "19 NaN Social Rent \n", "20 NaN a3aa \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 a. Number of demolitions NaN \n", "27 b i. Number of conversions resulting in an inc... NaN \n", "28 b ii. Number of conversions resulting in a dec... NaN \n", "29 c. Number of new builds NaN \n", "30 d. Number of acquisitions NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "\n", " 3 4 \n", "0 NaN NaN \n", "1 NaN NaN \n", "2 Census Definition NaN \n", "3 a1a NaN \n", "4 a1b NaN \n", "5 NaN NaN \n", "6 NaN NaN \n", "7 of which NaN \n", "8 Affordable Rent All \n", "9 a2ab a2a \n", "10 a2bb a2b \n", "11 a2cb a2c \n", "12 a2db a2d \n", "13 a2eb a2e \n", "14 a2fb a2f \n", "15 a2gb a2g \n", "16 a2hb a2h \n", "17 a2iab a2ia \n", "18 NaN a2ib \n", "19 NaN All (£ millions) \n", "20 NaN a3a \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 a4a NaN \n", "27 a4ba NaN \n", "28 a4bb NaN \n", "29 a4c NaN \n", "30 a4d NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 a5a NaN " ] }, "execution_count": 170, "metadata": {}, "output_type": "execute_result" } ], "source": [ "xl[metadata[k]['sheet']]" ] }, { "cell_type": "code", "execution_count": 206, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
01234
0Dwelling Stock In your Local Authority Area as...
1This section collects information on dwelling ...
21. Number of dwellings located in your local a...Census Definition
3a. Local Authority Owned (including those owne...0
4b. 'Other' public sector (eg government depart...5
5Dwelling Stock Owned by your Local Authority
6This section collects information on dwelling ...
72. Number of Dwellings owned by your Local Aut...of which
8Social RentAffordable RentAll
9a. Bedsits (including Public Finance Initiativ...000
10b. One bedroom (including Public Finance Initi...000
11c. Two bedrooms (including Public Finance Init...000
12d. Three bedrooms (including Public Finance In...000
13e. Four bedrooms (including Public Finance Ini...000
14f. Five bedrooms (including Public Finance Ini...000
15g. Six or more bedrooms (including Public Fina...000
16h. Dwellings equivalent of HMOs Hostels (inclu...000
17i. Total (including Public Finance Initiative ...000
18Total excluding PFI and Shared Ownership0
19Social RentAll (£ millions)
203. Total value of stock at 1st January 1999 pr...00
21Changes to Local Authority owned stock
22This section refers to stock owned by your Loc...
23stock at the beginning of the year as it colle...
24had any demolitions, conversions, acquisitions...
254. Changes to Local Authority owned stock
26a. Number of demolitions0
27b i. Number of conversions resulting in an inc...0
28b ii. Number of conversions resulting in a dec...0
29c. Number of new builds0
30d. Number of acquisitions0
31Private Sector Demolition
32This section should be completed by all Local ...
335. Total number of private sector dwellings de...0
\n", "
" ], "text/plain": [ " 0 \\\n", "0 Dwelling Stock In your Local Authority Area as... \n", "1 This section collects information on dwelling ... \n", "2 1. Number of dwellings located in your local a... \n", "3 \n", "4 \n", "5 Dwelling Stock Owned by your Local Authority \n", "6 This section collects information on dwelling ... \n", "7 2. Number of Dwellings owned by your Local Aut... \n", "8 \n", "9 \n", "10 \n", "11 \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 3. Total value of stock at 1st January 1999 pr... \n", "21 Changes to Local Authority owned stock \n", "22 This section refers to stock owned by your Loc... \n", "23 stock at the beginning of the year as it colle... \n", "24 had any demolitions, conversions, acquisitions... \n", "25 4. Changes to Local Authority owned stock \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 Private Sector Demolition \n", "32 This section should be completed by all Local ... \n", "33 5. Total number of private sector dwellings de... \n", "\n", " 1 2 \\\n", "0 \n", "1 \n", "2 \n", "3 a. Local Authority Owned (including those owne... \n", "4 b. 'Other' public sector (eg government depart... \n", "5 \n", "6 \n", "7 \n", "8 Social Rent \n", "9 a. Bedsits (including Public Finance Initiativ... 0 \n", "10 b. One bedroom (including Public Finance Initi... 0 \n", "11 c. Two bedrooms (including Public Finance Init... 0 \n", "12 d. Three bedrooms (including Public Finance In... 0 \n", "13 e. Four bedrooms (including Public Finance Ini... 0 \n", "14 f. Five bedrooms (including Public Finance Ini... 0 \n", "15 g. Six or more bedrooms (including Public Fina... 0 \n", "16 h. Dwellings equivalent of HMOs Hostels (inclu... 0 \n", "17 i. Total (including Public Finance Initiative ... 0 \n", "18 Total excluding PFI and Shared Ownership \n", "19 Social Rent \n", "20 0 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 a. Number of demolitions \n", "27 b i. Number of conversions resulting in an inc... \n", "28 b ii. Number of conversions resulting in a dec... \n", "29 c. Number of new builds \n", "30 d. Number of acquisitions \n", "31 \n", "32 \n", "33 \n", "\n", " 3 4 \n", "0 \n", "1 \n", "2 Census Definition \n", "3 0 \n", "4 5 \n", "5 \n", "6 \n", "7 of which \n", "8 Affordable Rent All \n", "9 0 0 \n", "10 0 0 \n", "11 0 0 \n", "12 0 0 \n", "13 0 0 \n", "14 0 0 \n", "15 0 0 \n", "16 0 0 \n", "17 0 0 \n", "18 0 \n", "19 All (£ millions) \n", "20 0 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 0 \n", "27 0 \n", "28 0 \n", "29 0 \n", "30 0 \n", "31 \n", "32 \n", "33 0 " ] }, "execution_count": 206, "metadata": {}, "output_type": "execute_result" } ], "source": [ "xl[metadata[k]['sheet']].replace(to_replace=lahs_2017_18_dict).fillna('')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## C Allocations" ] }, { "cell_type": "code", "execution_count": 215, "metadata": {}, "outputs": [], "source": [ "k = 'C'" ] }, { "cell_type": "code", "execution_count": 216, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
01234
0NaNNaNNaNAs at 1st April 2018NaN
1Waiting ListsNaNNaNNaNNaN
21. Total households on the housing waiting lis...NaNNaNNaNcc1a
3NaNHow many bedrooms did these households require?NaNNaNNaN
4NaN(cc1a should equal the sum of cc1aa to cc1ae)NaNNaNNaN
5NaNa. Households requiring 1 bedroomNaNNaNcc1aa
6NaNb. Households requiring 2 bedroomsNaNNaNcc1ab
7NaNc. Households requiring 3 bedroomsNaNNaNcc1ac
8NaNd. Households requiring more than 3 bedroomsNaNNaNcc1ad
9NaNe. Households requiring an unspecif...NaNNaNcc1ae
102. Have you changed your waiting list criteria...NaNNaNNaNcc2a
113. Do your waiting list criteria include:NaNNaNNaNNaN
12(only answer Y to one of these questions; if y...NaNNaNNaNNaN
13NaNa. A residency test? (Y or N)NaNNaNcc3a
14NaNNaNi . If yes, how many years of residency are re...NaNcc3aa
15NaNNaNIf your residency test requires less than 1 ye...NaNNaN
16NaNNaNhousehold on the waiting list then please rep...NaNNaN
17NaNb. A local connection test? (Y or N)NaNNaNcc3b
184. Do your waiting list criteria disqualify an...NaNNaNNaNcc4a
19NaNa. If your waiting list criteria do disqualify...NaNNaNcc4aa
20NaNNaNi. If yes, how many such exceptions have you m...NaNcc4ab
215. Total number of households on the housing w...NaNNaNNaNcc5a
22NaNHow many of these households were in each reas...NaNNaNNaN
23NaN(cc5a does not need to equal the sum of a-e be...NaNNaNNaN
24NaNa. People who are homeless within the meaning ...NaNNaNcc5aa
25NaNb. People who are owed a duty by any local hou...NaNNaNcc5ab
26NaNAct (or under section 65(2) or 68(2) of the Ho...NaNNaNNaN
27NaNsecured by any such authority under section 19...NaNNaNNaN
28NaNc. People occupying insanitary or overcrowded ...NaNNaNcc5ac
29NaNconditionsNaNNaNNaN
30NaNd. People who need to move on medical or welfa...NaNNaNcc5ad
31NaNe. People who need to move to a particular loc...NaNNaNcc5ae
326. If your scheme gives additional preference ...NaNNaNNaNcc6a
33needs, how many households on your waiting lis...NaNNaNNaNNaN
34NaNa. Of which, how many are members of the Armed...NaNNaNcc6aa
35AllocationsNaNNaNNaNNaN
367. Do you participate in a choice-based lettin...NaNNaNNaNcc7a
37from a selection of available to let vacancie...NaNNaNNaNNaN
38housing need)? (Y or N)NaNNaNNaNNaN
398. Does your allocation scheme or transfer pol...NaNNaNNaNcc8a
40their current home? (Y or N)NaNNaNNaNNaN
\n", "
" ], "text/plain": [ " 0 \\\n", "0 NaN \n", "1 Waiting Lists \n", "2 1. Total households on the housing waiting lis... \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 2. Have you changed your waiting list criteria... \n", "11 3. Do your waiting list criteria include: \n", "12 (only answer Y to one of these questions; if y... \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 4. Do your waiting list criteria disqualify an... \n", "19 NaN \n", "20 NaN \n", "21 5. Total number of households on the housing w... \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 6. If your scheme gives additional preference ... \n", "33 needs, how many households on your waiting lis... \n", "34 NaN \n", "35 Allocations \n", "36 7. Do you participate in a choice-based lettin... \n", "37 from a selection of available to let vacancie... \n", "38 housing need)? (Y or N) \n", "39 8. Does your allocation scheme or transfer pol... \n", "40 their current home? (Y or N) \n", "\n", " 1 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 How many bedrooms did these households require? \n", "4 (cc1a should equal the sum of cc1aa to cc1ae) \n", "5 a. Households requiring 1 bedroom \n", "6 b. Households requiring 2 bedrooms \n", "7 c. Households requiring 3 bedrooms \n", "8 d. Households requiring more than 3 bedrooms \n", "9 e. Households requiring an unspecif... \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 a. A residency test? (Y or N) \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 b. A local connection test? (Y or N) \n", "18 NaN \n", "19 a. If your waiting list criteria do disqualify... \n", "20 NaN \n", "21 NaN \n", "22 How many of these households were in each reas... \n", "23 (cc5a does not need to equal the sum of a-e be... \n", "24 a. People who are homeless within the meaning ... \n", "25 b. People who are owed a duty by any local hou... \n", "26 Act (or under section 65(2) or 68(2) of the Ho... \n", "27 secured by any such authority under section 19... \n", "28 c. People occupying insanitary or overcrowded ... \n", "29 conditions \n", "30 d. People who need to move on medical or welfa... \n", "31 e. People who need to move to a particular loc... \n", "32 NaN \n", "33 NaN \n", "34 a. Of which, how many are members of the Armed... \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "\n", " 2 3 \\\n", "0 NaN As at 1st April 2018 \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "5 NaN NaN \n", "6 NaN NaN \n", "7 NaN NaN \n", "8 NaN NaN \n", "9 NaN NaN \n", "10 NaN NaN \n", "11 NaN NaN \n", "12 NaN NaN \n", "13 NaN NaN \n", "14 i . If yes, how many years of residency are re... NaN \n", "15 If your residency test requires less than 1 ye... NaN \n", "16 household on the waiting list then please rep... NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 NaN NaN \n", "20 i. If yes, how many such exceptions have you m... NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NaN NaN \n", "29 NaN NaN \n", "30 NaN NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "34 NaN NaN \n", "35 NaN NaN \n", "36 NaN NaN \n", "37 NaN NaN \n", "38 NaN NaN \n", "39 NaN NaN \n", "40 NaN NaN \n", "\n", " 4 \n", "0 NaN \n", "1 NaN \n", "2 cc1a \n", "3 NaN \n", "4 NaN \n", "5 cc1aa \n", "6 cc1ab \n", "7 cc1ac \n", "8 cc1ad \n", "9 cc1ae \n", "10 cc2a \n", "11 NaN \n", "12 NaN \n", "13 cc3a \n", "14 cc3aa \n", "15 NaN \n", "16 NaN \n", "17 cc3b \n", "18 cc4a \n", "19 cc4aa \n", "20 cc4ab \n", "21 cc5a \n", "22 NaN \n", "23 NaN \n", "24 cc5aa \n", "25 cc5ab \n", "26 NaN \n", "27 NaN \n", "28 cc5ac \n", "29 NaN \n", "30 cc5ad \n", "31 cc5ae \n", "32 cc6a \n", "33 NaN \n", "34 cc6aa \n", "35 NaN \n", "36 cc7a \n", "37 NaN \n", "38 NaN \n", "39 cc8a \n", "40 NaN " ] }, "execution_count": 216, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp = xl[metadata[k]['sheet']]\n", "tmp" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "In terms of the households required by numbers of bedrooms:\n", "\n", "\t- 1030 required 1 bedroom\n", "\t- 600 required 2 bedrooms\n", "\t- 342 required 3 bedrooms\n", "\t- 89 required more than bedrooms\n", "\t- 0 required an unspecified number of bedrooms.\n", "\n" ] } ], "source": [ "txt='''\n", "In terms of the households required by numbers of bedrooms:\n", "\n", "\\t- {cc1aa} required 1 bedroom\n", "\\t- {cc1ab} required 2 bedrooms\n", "\\t- {cc1ac} required 3 bedrooms\n", "\\t- {cc1ad} required more than bedrooms\n", "\\t- {cc1ae} required an unspecified number of bedrooms.\n", "'''\n", "\n", "print(txt.format( **lahs_2017_18_dict ))" ] }, { "cell_type": "code", "execution_count": 217, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
01234
0As at 1st April 2018
1Waiting Lists
21. Total households on the housing waiting lis...2061
3How many bedrooms did these households require?
4(cc1a should equal the sum of cc1aa to cc1ae)
5a. Households requiring 1 bedroom1030
6b. Households requiring 2 bedrooms600
7c. Households requiring 3 bedrooms342
8d. Households requiring more than 3 bedrooms89
9e. Households requiring an unspecif...0
102. Have you changed your waiting list criteria...N
113. Do your waiting list criteria include:
12(only answer Y to one of these questions; if y...
13a. A residency test? (Y or N)Y
14i . If yes, how many years of residency are re...5
15If your residency test requires less than 1 ye...
16household on the waiting list then please rep...
17b. A local connection test? (Y or N)cc3b
184. Do your waiting list criteria disqualify an...N
19a. If your waiting list criteria do disqualify...N
20i. If yes, how many such exceptions have you m.....
215. Total number of households on the housing w...1442
22How many of these households were in each reas...
23(cc5a does not need to equal the sum of a-e be...
24a. People who are homeless within the meaning ...63
25b. People who are owed a duty by any local hou...148
26Act (or under section 65(2) or 68(2) of the Ho...
27secured by any such authority under section 19...
28c. People occupying insanitary or overcrowded ...1194
29conditions
30d. People who need to move on medical or welfa...533
31e. People who need to move to a particular loc...0
326. If your scheme gives additional preference ...9
33needs, how many households on your waiting lis...
34a. Of which, how many are members of the Armed...0
35Allocations
367. Do you participate in a choice-based lettin...Y
37from a selection of available to let vacancie...
38housing need)? (Y or N)
398. Does your allocation scheme or transfer pol...Y
40their current home? (Y or N)
\n", "
" ], "text/plain": [ " 0 \\\n", "0 \n", "1 Waiting Lists \n", "2 1. Total households on the housing waiting lis... \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 \n", "9 \n", "10 2. Have you changed your waiting list criteria... \n", "11 3. Do your waiting list criteria include: \n", "12 (only answer Y to one of these questions; if y... \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 4. Do your waiting list criteria disqualify an... \n", "19 \n", "20 \n", "21 5. Total number of households on the housing w... \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 6. If your scheme gives additional preference ... \n", "33 needs, how many households on your waiting lis... \n", "34 \n", "35 Allocations \n", "36 7. Do you participate in a choice-based lettin... \n", "37 from a selection of available to let vacancie... \n", "38 housing need)? (Y or N) \n", "39 8. Does your allocation scheme or transfer pol... \n", "40 their current home? (Y or N) \n", "\n", " 1 \\\n", "0 \n", "1 \n", "2 \n", "3 How many bedrooms did these households require? \n", "4 (cc1a should equal the sum of cc1aa to cc1ae) \n", "5 a. Households requiring 1 bedroom \n", "6 b. Households requiring 2 bedrooms \n", "7 c. Households requiring 3 bedrooms \n", "8 d. Households requiring more than 3 bedrooms \n", "9 e. Households requiring an unspecif... \n", "10 \n", "11 \n", "12 \n", "13 a. A residency test? (Y or N) \n", "14 \n", "15 \n", "16 \n", "17 b. A local connection test? (Y or N) \n", "18 \n", "19 a. If your waiting list criteria do disqualify... \n", "20 \n", "21 \n", "22 How many of these households were in each reas... \n", "23 (cc5a does not need to equal the sum of a-e be... \n", "24 a. People who are homeless within the meaning ... \n", "25 b. People who are owed a duty by any local hou... \n", "26 Act (or under section 65(2) or 68(2) of the Ho... \n", "27 secured by any such authority under section 19... \n", "28 c. People occupying insanitary or overcrowded ... \n", "29 conditions \n", "30 d. People who need to move on medical or welfa... \n", "31 e. People who need to move to a particular loc... \n", "32 \n", "33 \n", "34 a. Of which, how many are members of the Armed... \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "\n", " 2 3 \\\n", "0 As at 1st April 2018 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 \n", "9 \n", "10 \n", "11 \n", "12 \n", "13 \n", "14 i . If yes, how many years of residency are re... \n", "15 If your residency test requires less than 1 ye... \n", "16 household on the waiting list then please rep... \n", "17 \n", "18 \n", "19 \n", "20 i. If yes, how many such exceptions have you m... \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "\n", " 4 \n", "0 \n", "1 \n", "2 2061 \n", "3 \n", "4 \n", "5 1030 \n", "6 600 \n", "7 342 \n", "8 89 \n", "9 0 \n", "10 N \n", "11 \n", "12 \n", "13 Y \n", "14 5 \n", "15 \n", "16 \n", "17 cc3b \n", "18 N \n", "19 N \n", "20 .. \n", "21 1442 \n", "22 \n", "23 \n", "24 63 \n", "25 148 \n", "26 \n", "27 \n", "28 1194 \n", "29 \n", "30 533 \n", "31 0 \n", "32 9 \n", "33 \n", "34 0 \n", "35 \n", "36 Y \n", "37 \n", "38 \n", "39 Y \n", "40 " ] }, "execution_count": 217, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp.replace(to_replace=lahs_2017_18_dict).fillna('')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## I Affordable Housing Supply" ] }, { "cell_type": "code", "execution_count": 212, "metadata": {}, "outputs": [], "source": [ "k = 'I'" ] }, { "cell_type": "code", "execution_count": 213, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
012345678910111213141516171819
0This section should be completed by all Local ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1Provision of New Build Additional Affordable H...NaNNaNNaNProvision of additional affordable housing oth...NaNNaNNaNNaNNaNNaNNaNAffordable housing funded with recycled Right ...NaNNaNNaNNaNNaNNaNNaN
2Units sold under the Help to buy scheme are no...NaNNaNNaNPlease see guidance for more detailed definitionsNaNNaNNaNNaNNaNNaNUnitsNaNNaNNaNNaNNaNNaNNaNNaN
3For Questions 1 and 2 please report all new bu...NaNNaNUnits completedNaNNaNNaNNaNNaNNaNNaNi6aUnits counted in question 17 may also be count...NaNNaNNaNNaNNaNNaNNaN
41. In populations of less than 3,000 peopleNaNNaNi1a6. In populations of less than 3,000 people (a...NaNNaNNaNNaNNaNNaNNaNaffordable housing supply.NaNNaNNaNNaNNaNNaNNaN
52. On Rural Exception SitesNaNNaNi2aIn Questions 7, 8, 9 only report affordable ho...NaNNaNNaNNaNNaNNaNNaN17. Number of affordable homes completed with ...NaNNew BuildAcquisitionsNaNNaNNaNNaN
6NaNNaNNaNNaNNaNNaNUnits\\nSocial Rent\\n\\n(a)Units Intermediate Rent\\n(b)Units Affordable Rent \\n(c)Units Affordable Ownership (exc SO) (d)Shared Ownership\\n(e)Total number of units\\n(f)recycled RTB receiptsNaNNaNNaNNaNNaNNaNNaN
7In Questions 3, 4 and 5 only report new build ...NaNNaNNaNIf any dwellings are not funded by the HCA/GLA...NaNNaNNaNNaNNaNNaNNaNNaNa. 1 bedroomi17aai17abof which are Flatsof whichOther ex-local authorityGeneral market
83. Owned by Local Authority, not reported to H...NaN(a)(b)7.Owned by Local Authority (not reported to HC...NaNi7ai7bi7ci7di7ei7fNaNb. 2 bedroomsi17bai17bbNaNBuy BackNaNNaN
9NaNNaNUnits completed without developer contributionsUnits completed with developer contributions t...NaNNaNNaNNaNNaNNaNNaNNaNNaNc. 3+ bedroomsi17cai17cbNaN(SI No 501)NaNNaN
10If any dwellings are not funded by the HCA/GLA...NaNNaNNaN8.Owned by Private Registered Providers (not r...NaNi8ai8bi8ci8di8ei8fNaNd. Totali17dai17dbi17ei17dci17ddi17de
11please record how the dwellings are funded in ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNInclude where the local authority contra...NaNNaNNaNNaNNaNNaNNaN
12NaNNaNNaNNaN9. Owned by Non-registered providerNaNi9ai9bi9ci9di9ei9fExcludes any provision with HCA or GLA g...NaNNaNNaNNaNNaNNaNNaN
13NaNa.Social Renti3aai3abNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
14NaNb.Affordable Renti3bai3bbNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
15NaNNaNNaNNaNPlanning for Affordable Housing units with dev...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
16NaNc.Intermediate Renti3cai3cbNaNNaNNaNNaNNaNNaNNaNUnits with developer contributionsNaNNaNNaNNaNNaNNaNNaNNaN
17NaNNaNNaNNaN10. Affordable units granted final planning pe...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
18NaNd.Affordable Home Ownership (excluding Shared ...i3dai3dbNaNa. For Social RentNaNNaNNaNNaNNaNi10aNaNNaNNaNNaNNaNNaNNaNNaN
19NaNe.Shared Ownershipi3eai3ebNaNb. For Affordable RentNaNNaNNaNNaNNaNi10bNaNNaNNaNNaNNaNNaNNaNNaN
20NaNf.Total Number of unitsi3fai3fbNaNc. For Intermediate RentNaNNaNNaNNaNNaNi10cNaNNaNNaNNaNNaNNaNNaNNaN
21NaNNaNNaNNaNNaNd. For Affordable Home Ownership (excluding Sh...NaNNaNNaNNaNNaNi10dNaNNaNNaNNaNNaNNaNNaNNaN
224. Owned by Private Registered Providers (incl...NaNUnits completed without developer contributionsUnits completed with developer contributions t...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23(note Affordable Rent delivery is not asked fo...NaNNaNNaNNaNe. For Shared OwnershipNaNNaNNaNNaNNaNi10eNaNNaNNaNNaNNaNNaNNaNNaN
24If any dwellings are not funded by the HCA/GLA...NaNNaNNaNNaNf. For Starter HomesNaNNaNNaNNaNNaNi10fNaNNaNNaNNaNNaNNaNNaNNaN
25please record how the dwellings are funded in ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
26NaNa.Social Renti4aai4abNaNg. For unknown affordable tenureNaNNaNNaNNaNNaNi10gNaNNaNNaNNaNNaNNaNNaNNaN
27NaNb.Affordable Renti4bai4bbNaNh. Total number of unitsNaNNaNNaNNaNNaNi10hNaNNaNNaNNaNNaNNaNNaNNaN
28NaNc.Intermediate Renti4cai4cbNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
29NaNNaNNaNNaNOther Developer Contributions to Affordable Ho...NaNNaNNaNNaNNaNNaNhectaresNaNNaNNaNNaNNaNNaNNaNNaN
30NaNd.Affordable Home Ownership (excluding Shared ...i4dai4dbNaNNaNNaNNaNNaNNaNNaNi11aNaNNaNNaNNaNNaNNaNNaNNaN
31NaNNaNNaNNaN11. Amount of discounted or free land received...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
32NaNe.Shared Ownershipi4eai4ebNaNNaNNaNNaNValue of contributions £ thousandsNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
33NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNi12aNaNNaNNaNNaNNaNNaNNaNNaN
34NaNf.Total Number of unitsi4fai4fb12.Financial contributions from planning oblig...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
35NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNi13aNaNNaNNaNNaNNaNNaNNaNNaN
365. Owned by non-registered providersNaNUnits completed without developer contributionsUnits completed with developer contributions t...13.Financial contributions from planning oblig...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
37NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNi14aNaNNaNNaNNaNNaNNaNNaNNaN
38If any dwellings are not funded by the HCA/GLA...NaNNaNNaN14.Financial contributions from planning oblig...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
39please record how the dwellings are funded in ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
40NaNa.Social Renti5aai5abNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
41NaNNaNNaNNaNCash Incentive Scheme GrantsNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
42NaNb.Affordable Renti5bai5bb(Only grants for the purchase of private secto...NaNNaNNaNNaNNaNNaNunitsNaNNaNNaNNaNNaNNaNNaNNaN
43NaNNaNNaNNaN15. Total number of grantsNaNNaNNaNNaNNaNNaNi15aNaNNaNNaNNaNNaNNaNNaNNaN
44NaNc.Intermediate Renti5cai5cbNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
45NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN£ thousandsNaNNaNNaNNaNNaNNaNNaNNaN
46NaNd.Affordable Home Ownership (excluding Shared ...i5dai5db16. Total expenditure (£000s)NaNNaNNaNNaNNaNNaNi16aNaNNaNNaNNaNNaNNaNNaNNaN
47NaNe.Shared Ownershipi5eai5ebNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
48NaNf.Total Number of unitsi5fai5fbNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " 0 \\\n", "0 This section should be completed by all Local ... \n", "1 Provision of New Build Additional Affordable H... \n", "2 Units sold under the Help to buy scheme are no... \n", "3 For Questions 1 and 2 please report all new bu... \n", "4 1. In populations of less than 3,000 people \n", "5 2. On Rural Exception Sites \n", "6 NaN \n", "7 In Questions 3, 4 and 5 only report new build ... \n", "8 3. Owned by Local Authority, not reported to H... \n", "9 NaN \n", "10 If any dwellings are not funded by the HCA/GLA... \n", "11 please record how the dwellings are funded in ... \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 4. Owned by Private Registered Providers (incl... \n", "23 (note Affordable Rent delivery is not asked fo... \n", "24 If any dwellings are not funded by the HCA/GLA... \n", "25 please record how the dwellings are funded in ... \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 5. Owned by non-registered providers \n", "37 NaN \n", "38 If any dwellings are not funded by the HCA/GLA... \n", "39 please record how the dwellings are funded in ... \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "\n", " 1 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 a.Social Rent \n", "14 b.Affordable Rent \n", "15 NaN \n", "16 c.Intermediate Rent \n", "17 NaN \n", "18 d.Affordable Home Ownership (excluding Shared ... \n", "19 e.Shared Ownership \n", "20 f.Total Number of units \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 a.Social Rent \n", "27 b.Affordable Rent \n", "28 c.Intermediate Rent \n", "29 NaN \n", "30 d.Affordable Home Ownership (excluding Shared ... \n", "31 NaN \n", "32 e.Shared Ownership \n", "33 NaN \n", "34 f.Total Number of units \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 a.Social Rent \n", "41 NaN \n", "42 b.Affordable Rent \n", "43 NaN \n", "44 c.Intermediate Rent \n", "45 NaN \n", "46 d.Affordable Home Ownership (excluding Shared ... \n", "47 e.Shared Ownership \n", "48 f.Total Number of units \n", "\n", " 2 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 (a) \n", "9 Units completed without developer contributions \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 i3aa \n", "14 i3ba \n", "15 NaN \n", "16 i3ca \n", "17 NaN \n", "18 i3da \n", "19 i3ea \n", "20 i3fa \n", "21 NaN \n", "22 Units completed without developer contributions \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 i4aa \n", "27 i4ba \n", "28 i4ca \n", "29 NaN \n", "30 i4da \n", "31 NaN \n", "32 i4ea \n", "33 NaN \n", "34 i4fa \n", "35 NaN \n", "36 Units completed without developer contributions \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 i5aa \n", "41 NaN \n", "42 i5ba \n", "43 NaN \n", "44 i5ca \n", "45 NaN \n", "46 i5da \n", "47 i5ea \n", "48 i5fa \n", "\n", " 3 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 Units completed \n", "4 i1a \n", "5 i2a \n", "6 NaN \n", "7 NaN \n", "8 (b) \n", "9 Units completed with developer contributions t... \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 i3ab \n", "14 i3bb \n", "15 NaN \n", "16 i3cb \n", "17 NaN \n", "18 i3db \n", "19 i3eb \n", "20 i3fb \n", "21 NaN \n", "22 Units completed with developer contributions t... \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 i4ab \n", "27 i4bb \n", "28 i4cb \n", "29 NaN \n", "30 i4db \n", "31 NaN \n", "32 i4eb \n", "33 NaN \n", "34 i4fb \n", "35 NaN \n", "36 Units completed with developer contributions t... \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 i5ab \n", "41 NaN \n", "42 i5bb \n", "43 NaN \n", "44 i5cb \n", "45 NaN \n", "46 i5db \n", "47 i5eb \n", "48 i5fb \n", "\n", " 4 \\\n", "0 NaN \n", "1 Provision of additional affordable housing oth... \n", "2 Please see guidance for more detailed definitions \n", "3 NaN \n", "4 6. In populations of less than 3,000 people (a... \n", "5 In Questions 7, 8, 9 only report affordable ho... \n", "6 NaN \n", "7 If any dwellings are not funded by the HCA/GLA... \n", "8 7.Owned by Local Authority (not reported to HC... \n", "9 NaN \n", "10 8.Owned by Private Registered Providers (not r... \n", "11 NaN \n", "12 9. Owned by Non-registered provider \n", "13 NaN \n", "14 NaN \n", "15 Planning for Affordable Housing units with dev... \n", "16 NaN \n", "17 10. Affordable units granted final planning pe... \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 Other Developer Contributions to Affordable Ho... \n", "30 NaN \n", "31 11. Amount of discounted or free land received... \n", "32 NaN \n", "33 NaN \n", "34 12.Financial contributions from planning oblig... \n", "35 NaN \n", "36 13.Financial contributions from planning oblig... \n", "37 NaN \n", "38 14.Financial contributions from planning oblig... \n", "39 NaN \n", "40 NaN \n", "41 Cash Incentive Scheme Grants \n", "42 (Only grants for the purchase of private secto... \n", "43 15. Total number of grants \n", "44 NaN \n", "45 NaN \n", "46 16. Total expenditure (£000s) \n", "47 NaN \n", "48 NaN \n", "\n", " 5 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 a. For Social Rent \n", "19 b. For Affordable Rent \n", "20 c. For Intermediate Rent \n", "21 d. For Affordable Home Ownership (excluding Sh... \n", "22 NaN \n", "23 e. For Shared Ownership \n", "24 f. For Starter Homes \n", "25 NaN \n", "26 g. For unknown affordable tenure \n", "27 h. Total number of units \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "\n", " 6 7 \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "5 NaN NaN \n", "6 Units\\nSocial Rent\\n\\n(a) Units Intermediate Rent\\n(b) \n", "7 NaN NaN \n", "8 i7a i7b \n", "9 NaN NaN \n", "10 i8a i8b \n", "11 NaN NaN \n", "12 i9a i9b \n", "13 NaN NaN \n", "14 NaN NaN \n", "15 NaN NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 NaN NaN \n", "20 NaN NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NaN NaN \n", "29 NaN NaN \n", "30 NaN NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "34 NaN NaN \n", "35 NaN NaN \n", "36 NaN NaN \n", "37 NaN NaN \n", "38 NaN NaN \n", "39 NaN NaN \n", "40 NaN NaN \n", "41 NaN NaN \n", "42 NaN NaN \n", "43 NaN NaN \n", "44 NaN NaN \n", "45 NaN NaN \n", "46 NaN NaN \n", "47 NaN NaN \n", "48 NaN NaN \n", "\n", " 8 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 Units Affordable Rent \\n(c) \n", "7 NaN \n", "8 i7c \n", "9 NaN \n", "10 i8c \n", "11 NaN \n", "12 i9c \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 Value of contributions £ thousands \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "\n", " 9 10 \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "5 NaN NaN \n", "6 Units Affordable Ownership (exc SO) (d) Shared Ownership\\n(e) \n", "7 NaN NaN \n", "8 i7d i7e \n", "9 NaN NaN \n", "10 i8d i8e \n", "11 NaN NaN \n", "12 i9d i9e \n", "13 NaN NaN \n", "14 NaN NaN \n", "15 NaN NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 NaN NaN \n", "20 NaN NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NaN NaN \n", "29 NaN NaN \n", "30 NaN NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "34 NaN NaN \n", "35 NaN NaN \n", "36 NaN NaN \n", "37 NaN NaN \n", "38 NaN NaN \n", "39 NaN NaN \n", "40 NaN NaN \n", "41 NaN NaN \n", "42 NaN NaN \n", "43 NaN NaN \n", "44 NaN NaN \n", "45 NaN NaN \n", "46 NaN NaN \n", "47 NaN NaN \n", "48 NaN NaN \n", "\n", " 11 \\\n", "0 NaN \n", "1 NaN \n", "2 Units \n", "3 i6a \n", "4 NaN \n", "5 NaN \n", "6 Total number of units\\n(f) \n", "7 NaN \n", "8 i7f \n", "9 NaN \n", "10 i8f \n", "11 NaN \n", "12 i9f \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 Units with developer contributions \n", "17 NaN \n", "18 i10a \n", "19 i10b \n", "20 i10c \n", "21 i10d \n", "22 NaN \n", "23 i10e \n", "24 i10f \n", "25 NaN \n", "26 i10g \n", "27 i10h \n", "28 NaN \n", "29 hectares \n", "30 i11a \n", "31 NaN \n", "32 NaN \n", "33 i12a \n", "34 NaN \n", "35 i13a \n", "36 NaN \n", "37 i14a \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 units \n", "43 i15a \n", "44 NaN \n", "45 £ thousands \n", "46 i16a \n", "47 NaN \n", "48 NaN \n", "\n", " 12 13 \\\n", "0 NaN NaN \n", "1 Affordable housing funded with recycled Right ... NaN \n", "2 NaN NaN \n", "3 Units counted in question 17 may also be count... NaN \n", "4 affordable housing supply. NaN \n", "5 17. Number of affordable homes completed with ... NaN \n", "6 recycled RTB receipts NaN \n", "7 NaN a. 1 bedroom \n", "8 NaN b. 2 bedrooms \n", "9 NaN c. 3+ bedrooms \n", "10 NaN d. Total \n", "11 Include where the local authority contra... NaN \n", "12 Excludes any provision with HCA or GLA g... NaN \n", "13 NaN NaN \n", "14 NaN NaN \n", "15 NaN NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 NaN NaN \n", "20 NaN NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NaN NaN \n", "29 NaN NaN \n", "30 NaN NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "34 NaN NaN \n", "35 NaN NaN \n", "36 NaN NaN \n", "37 NaN NaN \n", "38 NaN NaN \n", "39 NaN NaN \n", "40 NaN NaN \n", "41 NaN NaN \n", "42 NaN NaN \n", "43 NaN NaN \n", "44 NaN NaN \n", "45 NaN NaN \n", "46 NaN NaN \n", "47 NaN NaN \n", "48 NaN NaN \n", "\n", " 14 15 16 17 \\\n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "3 NaN NaN NaN NaN \n", "4 NaN NaN NaN NaN \n", "5 New Build Acquisitions NaN NaN \n", "6 NaN NaN NaN NaN \n", "7 i17aa i17ab of which are Flats of which \n", "8 i17ba i17bb NaN Buy Back \n", "9 i17ca i17cb NaN (SI No 501) \n", "10 i17da i17db i17e i17dc \n", "11 NaN NaN NaN NaN \n", "12 NaN NaN NaN NaN \n", "13 NaN NaN NaN NaN \n", "14 NaN NaN NaN NaN \n", "15 NaN NaN NaN NaN \n", "16 NaN NaN NaN NaN \n", "17 NaN NaN NaN NaN \n", "18 NaN NaN NaN NaN \n", "19 NaN NaN NaN NaN \n", "20 NaN NaN NaN NaN \n", "21 NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN \n", "24 NaN NaN NaN NaN \n", "25 NaN NaN NaN NaN \n", "26 NaN NaN NaN NaN \n", "27 NaN NaN NaN NaN \n", "28 NaN NaN NaN NaN \n", "29 NaN NaN NaN NaN \n", "30 NaN NaN NaN NaN \n", "31 NaN NaN NaN NaN \n", "32 NaN NaN NaN NaN \n", "33 NaN NaN NaN NaN \n", "34 NaN NaN NaN NaN \n", "35 NaN NaN NaN NaN \n", "36 NaN NaN NaN NaN \n", "37 NaN NaN NaN NaN \n", "38 NaN NaN NaN NaN \n", "39 NaN NaN NaN NaN \n", "40 NaN NaN NaN NaN \n", "41 NaN NaN NaN NaN \n", "42 NaN NaN NaN NaN \n", "43 NaN NaN NaN NaN \n", "44 NaN NaN NaN NaN \n", "45 NaN NaN NaN NaN \n", "46 NaN NaN NaN NaN \n", "47 NaN NaN NaN NaN \n", "48 NaN NaN NaN NaN \n", "\n", " 18 19 \n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "5 NaN NaN \n", "6 NaN NaN \n", "7 Other ex-local authority General market \n", "8 NaN NaN \n", "9 NaN NaN \n", "10 i17dd i17de \n", "11 NaN NaN \n", "12 NaN NaN \n", "13 NaN NaN \n", "14 NaN NaN \n", "15 NaN NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 NaN NaN \n", "20 NaN NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 NaN NaN \n", "25 NaN NaN \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NaN NaN \n", "29 NaN NaN \n", "30 NaN NaN \n", "31 NaN NaN \n", "32 NaN NaN \n", "33 NaN NaN \n", "34 NaN NaN \n", "35 NaN NaN \n", "36 NaN NaN \n", "37 NaN NaN \n", "38 NaN NaN \n", "39 NaN NaN \n", "40 NaN NaN \n", "41 NaN NaN \n", "42 NaN NaN \n", "43 NaN NaN \n", "44 NaN NaN \n", "45 NaN NaN \n", "46 NaN NaN \n", "47 NaN NaN \n", "48 NaN NaN " ] }, "execution_count": 213, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp = xl[metadata[k]['sheet']]\n", "tmp" ] }, { "cell_type": "code", "execution_count": 214, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
012345678910111213141516171819
0This section should be completed by all Local ...
1Provision of New Build Additional Affordable H...Provision of additional affordable housing oth...Affordable housing funded with recycled Right ...
2Units sold under the Help to buy scheme are no...Please see guidance for more detailed definitionsUnits
3For Questions 1 and 2 please report all new bu...Units completed0Units counted in question 17 may also be count...
41. In populations of less than 3,000 people136. In populations of less than 3,000 people (a...affordable housing supply.
52. On Rural Exception Sites0In Questions 7, 8, 9 only report affordable ho...17. Number of affordable homes completed with ...New BuildAcquisitions
6Units\\nSocial Rent\\n\\n(a)Units Intermediate Rent\\n(b)Units Affordable Rent \\n(c)Units Affordable Ownership (exc SO) (d)Shared Ownership\\n(e)Total number of units\\n(f)recycled RTB receipts
7In Questions 3, 4 and 5 only report new build ...If any dwellings are not funded by the HCA/GLA...a. 1 bedroom00of which are Flatsof whichOther ex-local authorityGeneral market
83. Owned by Local Authority, not reported to H...(a)(b)7.Owned by Local Authority (not reported to HC...000000b. 2 bedrooms00Buy Back
9Units completed without developer contributionsUnits completed with developer contributions t...c. 3+ bedrooms00(SI No 501)
10If any dwellings are not funded by the HCA/GLA...8.Owned by Private Registered Providers (not r...000000d. Total000000
11please record how the dwellings are funded in ...Include where the local authority contra...
129. Owned by Non-registered provider000000Excludes any provision with HCA or GLA g...
13a.Social Rent00
14b.Affordable Rent00
15Planning for Affordable Housing units with dev...
16c.Intermediate Rent00Units with developer contributions
1710. Affordable units granted final planning pe...
18d.Affordable Home Ownership (excluding Shared ...00a. For Social Rent-
19e.Shared Ownership00b. For Affordable Rent-
20f.Total Number of units00c. For Intermediate Rent-
21d. For Affordable Home Ownership (excluding Sh...-
224. Owned by Private Registered Providers (incl...Units completed without developer contributionsUnits completed with developer contributions t...
23(note Affordable Rent delivery is not asked fo...e. For Shared Ownership-
24If any dwellings are not funded by the HCA/GLA...f. For Starter Homes-
25please record how the dwellings are funded in ...
26a.Social Rent00g. For unknown affordable tenure351
27b.Affordable Rent013h. Total number of units351
28c.Intermediate Rent00
29Other Developer Contributions to Affordable Ho...hectares
30d.Affordable Home Ownership (excluding Shared ...000
3111. Amount of discounted or free land received...
32e.Shared Ownership00Value of contributions £ thousands
33-
34f.Total Number of units01312.Financial contributions from planning oblig...
3510
365. Owned by non-registered providersUnits completed without developer contributionsUnits completed with developer contributions t...13.Financial contributions from planning oblig...
370
38If any dwellings are not funded by the HCA/GLA...14.Financial contributions from planning oblig...
39please record how the dwellings are funded in ...
40a.Social Rent00
41Cash Incentive Scheme Grants
42b.Affordable Rent00(Only grants for the purchase of private secto...units
4315. Total number of grants0
44c.Intermediate Rent00
45£ thousands
46d.Affordable Home Ownership (excluding Shared ...0016. Total expenditure (£000s)0
47e.Shared Ownership00
48f.Total Number of units00
\n", "
" ], "text/plain": [ " 0 \\\n", "0 This section should be completed by all Local ... \n", "1 Provision of New Build Additional Affordable H... \n", "2 Units sold under the Help to buy scheme are no... \n", "3 For Questions 1 and 2 please report all new bu... \n", "4 1. In populations of less than 3,000 people \n", "5 2. On Rural Exception Sites \n", "6 \n", "7 In Questions 3, 4 and 5 only report new build ... \n", "8 3. Owned by Local Authority, not reported to H... \n", "9 \n", "10 If any dwellings are not funded by the HCA/GLA... \n", "11 please record how the dwellings are funded in ... \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 4. Owned by Private Registered Providers (incl... \n", "23 (note Affordable Rent delivery is not asked fo... \n", "24 If any dwellings are not funded by the HCA/GLA... \n", "25 please record how the dwellings are funded in ... \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 5. Owned by non-registered providers \n", "37 \n", "38 If any dwellings are not funded by the HCA/GLA... \n", "39 please record how the dwellings are funded in ... \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 1 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 \n", "9 \n", "10 \n", "11 \n", "12 \n", "13 a.Social Rent \n", "14 b.Affordable Rent \n", "15 \n", "16 c.Intermediate Rent \n", "17 \n", "18 d.Affordable Home Ownership (excluding Shared ... \n", "19 e.Shared Ownership \n", "20 f.Total Number of units \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 a.Social Rent \n", "27 b.Affordable Rent \n", "28 c.Intermediate Rent \n", "29 \n", "30 d.Affordable Home Ownership (excluding Shared ... \n", "31 \n", "32 e.Shared Ownership \n", "33 \n", "34 f.Total Number of units \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 a.Social Rent \n", "41 \n", "42 b.Affordable Rent \n", "43 \n", "44 c.Intermediate Rent \n", "45 \n", "46 d.Affordable Home Ownership (excluding Shared ... \n", "47 e.Shared Ownership \n", "48 f.Total Number of units \n", "\n", " 2 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 (a) \n", "9 Units completed without developer contributions \n", "10 \n", "11 \n", "12 \n", "13 0 \n", "14 0 \n", "15 \n", "16 0 \n", "17 \n", "18 0 \n", "19 0 \n", "20 0 \n", "21 \n", "22 Units completed without developer contributions \n", "23 \n", "24 \n", "25 \n", "26 0 \n", "27 0 \n", "28 0 \n", "29 \n", "30 0 \n", "31 \n", "32 0 \n", "33 \n", "34 0 \n", "35 \n", "36 Units completed without developer contributions \n", "37 \n", "38 \n", "39 \n", "40 0 \n", "41 \n", "42 0 \n", "43 \n", "44 0 \n", "45 \n", "46 0 \n", "47 0 \n", "48 0 \n", "\n", " 3 \\\n", "0 \n", "1 \n", "2 \n", "3 Units completed \n", "4 13 \n", "5 0 \n", "6 \n", "7 \n", "8 (b) \n", "9 Units completed with developer contributions t... \n", "10 \n", "11 \n", "12 \n", "13 0 \n", "14 0 \n", "15 \n", "16 0 \n", "17 \n", "18 0 \n", "19 0 \n", "20 0 \n", "21 \n", "22 Units completed with developer contributions t... \n", "23 \n", "24 \n", "25 \n", "26 0 \n", "27 13 \n", "28 0 \n", "29 \n", "30 0 \n", "31 \n", "32 0 \n", "33 \n", "34 13 \n", "35 \n", "36 Units completed with developer contributions t... \n", "37 \n", "38 \n", "39 \n", "40 0 \n", "41 \n", "42 0 \n", "43 \n", "44 0 \n", "45 \n", "46 0 \n", "47 0 \n", "48 0 \n", "\n", " 4 \\\n", "0 \n", "1 Provision of additional affordable housing oth... \n", "2 Please see guidance for more detailed definitions \n", "3 \n", "4 6. In populations of less than 3,000 people (a... \n", "5 In Questions 7, 8, 9 only report affordable ho... \n", "6 \n", "7 If any dwellings are not funded by the HCA/GLA... \n", "8 7.Owned by Local Authority (not reported to HC... \n", "9 \n", "10 8.Owned by Private Registered Providers (not r... \n", "11 \n", "12 9. Owned by Non-registered provider \n", "13 \n", "14 \n", "15 Planning for Affordable Housing units with dev... \n", "16 \n", "17 10. Affordable units granted final planning pe... \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 Other Developer Contributions to Affordable Ho... \n", "30 \n", "31 11. Amount of discounted or free land received... \n", "32 \n", "33 \n", "34 12.Financial contributions from planning oblig... \n", "35 \n", "36 13.Financial contributions from planning oblig... \n", "37 \n", "38 14.Financial contributions from planning oblig... \n", "39 \n", "40 \n", "41 Cash Incentive Scheme Grants \n", "42 (Only grants for the purchase of private secto... \n", "43 15. Total number of grants \n", "44 \n", "45 \n", "46 16. Total expenditure (£000s) \n", "47 \n", "48 \n", "\n", " 5 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 \n", "9 \n", "10 \n", "11 \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 a. For Social Rent \n", "19 b. For Affordable Rent \n", "20 c. For Intermediate Rent \n", "21 d. For Affordable Home Ownership (excluding Sh... \n", "22 \n", "23 e. For Shared Ownership \n", "24 f. For Starter Homes \n", "25 \n", "26 g. For unknown affordable tenure \n", "27 h. Total number of units \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 6 7 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 Units\\nSocial Rent\\n\\n(a) Units Intermediate Rent\\n(b) \n", "7 \n", "8 0 0 \n", "9 \n", "10 0 0 \n", "11 \n", "12 0 0 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 8 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 Units Affordable Rent \\n(c) \n", "7 \n", "8 0 \n", "9 \n", "10 0 \n", "11 \n", "12 0 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 Value of contributions £ thousands \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 9 10 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 Units Affordable Ownership (exc SO) (d) Shared Ownership\\n(e) \n", "7 \n", "8 0 0 \n", "9 \n", "10 0 0 \n", "11 \n", "12 0 0 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 11 \\\n", "0 \n", "1 \n", "2 Units \n", "3 0 \n", "4 \n", "5 \n", "6 Total number of units\\n(f) \n", "7 \n", "8 0 \n", "9 \n", "10 0 \n", "11 \n", "12 0 \n", "13 \n", "14 \n", "15 \n", "16 Units with developer contributions \n", "17 \n", "18 - \n", "19 - \n", "20 - \n", "21 - \n", "22 \n", "23 - \n", "24 - \n", "25 \n", "26 351 \n", "27 351 \n", "28 \n", "29 hectares \n", "30 0 \n", "31 \n", "32 \n", "33 - \n", "34 \n", "35 10 \n", "36 \n", "37 0 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 units \n", "43 0 \n", "44 \n", "45 £ thousands \n", "46 0 \n", "47 \n", "48 \n", "\n", " 12 13 \\\n", "0 \n", "1 Affordable housing funded with recycled Right ... \n", "2 \n", "3 Units counted in question 17 may also be count... \n", "4 affordable housing supply. \n", "5 17. Number of affordable homes completed with ... \n", "6 recycled RTB receipts \n", "7 a. 1 bedroom \n", "8 b. 2 bedrooms \n", "9 c. 3+ bedrooms \n", "10 d. Total \n", "11 Include where the local authority contra... \n", "12 Excludes any provision with HCA or GLA g... \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 14 15 16 17 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 New Build Acquisitions \n", "6 \n", "7 0 0 of which are Flats of which \n", "8 0 0 Buy Back \n", "9 0 0 (SI No 501) \n", "10 0 0 0 0 \n", "11 \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 \n", "\n", " 18 19 \n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 Other ex-local authority General market \n", "8 \n", "9 \n", "10 0 0 \n", "11 \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 \n", "17 \n", "18 \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 \n", "29 \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "38 \n", "39 \n", "40 \n", "41 \n", "42 \n", "43 \n", "44 \n", "45 \n", "46 \n", "47 \n", "48 " ] }, "execution_count": 214, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp.replace(to_replace=lahs_2017_18_dict).fillna('')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## J Affordable Housing Starts'" ] }, { "cell_type": "code", "execution_count": 208, "metadata": {}, "outputs": [], "source": [ "k = 'J'" ] }, { "cell_type": "code", "execution_count": 209, "metadata": {}, "outputs": [], "source": [ "metadata['J']['desc']= 'Completed by all Local Authorities. Report units STARTED during financial year 2017-18.\\n \\\n", " Units that have been started and completed in the year will be counted both in section I and J.'" ] }, { "cell_type": "code", "execution_count": 210, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123
0This section should be completed by all Local ...NaNNaNNaN
1Provision of New Build Additional Affordable H...NaNNaNNaN
2In Questions 1, 2 and 3 only report new build ...NaNNaNNaN
3Units that have been started and completed in ...NaNNaNNaN
41. Owned by Local Authority, not reported to H...NaN(a)(b)
5NaNNaNUnits started without developer contributionsUnits started with developer contributions thr...
6If any dwellings are not funded by the HCA/GLA...NaNNaNNaN
7please record how the dwellings are funded in ...NaNNaNNaN
8NaNa.Social Rentj1aaj1ab
9NaNb.Affordable Rentj1baj1bb
10NaNc.Intermediate Rentj1caj1cb
11NaNd.Affordable Home Ownership (excluding Shared ...j1daj1db
12NaNe.Shared Ownershipj1eaj1eb
13NaNf.Starter Homesj1faj1fb
14NaNg.Unknown tenurej1gaj1gb
15NaNh.Total Number of unitsj1haj1hb
162. Owned by Private Registered Providers (incl...NaNUnits starteed without developer contributionsUnits started with developer contributions thr...
17If any dwellings are not funded by the HCA/GLA...NaNNaNNaN
18please record how the dwellings are funded in ...NaNNaNNaN
19NaNa.Social Rentj2aaj2ab
20NaNb.Affordable Rentj2baj2bb
21NaNc.Intermediate Rentj2caj2cb
22NaNd.Affordable Home Ownership (excluding Shared ...j2daj2db
23NaNe.Shared Ownershipj2eaj2eb
24NaNf.Starter Homesj2faj2fb
25NaNg.Unknown tenurej2gaj2gb
26NaNh.Total Number of unitsj2haj2hb
273. Owned by non-registered providersNaNUnits started without developer contributionsUnits started with developer contributions thr...
28If any dwellings are not funded by the HCA/GLA...NaNNaNNaN
29please record how the dwellings are funded in ...NaNNaNNaN
30NaNa.Social Rentj3aaj3ab
31NaNb.Affordable Rentj3baj3bb
32NaNc.Intermediate Rentj3caj3cb
33NaNd.Affordable Home Ownership (excluding Shared ...j3daj3db
34NaNe.Shared Ownershipj3eaj3eb
35NaNf.Starter Homesj3faj3fb
36NaNg.Unknown tenurej3gaj3gb
37NaNh.Total Number of unitsj3haj3hb
\n", "
" ], "text/plain": [ " 0 \\\n", "0 This section should be completed by all Local ... \n", "1 Provision of New Build Additional Affordable H... \n", "2 In Questions 1, 2 and 3 only report new build ... \n", "3 Units that have been started and completed in ... \n", "4 1. Owned by Local Authority, not reported to H... \n", "5 NaN \n", "6 If any dwellings are not funded by the HCA/GLA... \n", "7 please record how the dwellings are funded in ... \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 2. Owned by Private Registered Providers (incl... \n", "17 If any dwellings are not funded by the HCA/GLA... \n", "18 please record how the dwellings are funded in ... \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 3. Owned by non-registered providers \n", "28 If any dwellings are not funded by the HCA/GLA... \n", "29 please record how the dwellings are funded in ... \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "\n", " 1 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 a.Social Rent \n", "9 b.Affordable Rent \n", "10 c.Intermediate Rent \n", "11 d.Affordable Home Ownership (excluding Shared ... \n", "12 e.Shared Ownership \n", "13 f.Starter Homes \n", "14 g.Unknown tenure \n", "15 h.Total Number of units \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 a.Social Rent \n", "20 b.Affordable Rent \n", "21 c.Intermediate Rent \n", "22 d.Affordable Home Ownership (excluding Shared ... \n", "23 e.Shared Ownership \n", "24 f.Starter Homes \n", "25 g.Unknown tenure \n", "26 h.Total Number of units \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 a.Social Rent \n", "31 b.Affordable Rent \n", "32 c.Intermediate Rent \n", "33 d.Affordable Home Ownership (excluding Shared ... \n", "34 e.Shared Ownership \n", "35 f.Starter Homes \n", "36 g.Unknown tenure \n", "37 h.Total Number of units \n", "\n", " 2 \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 (a) \n", "5 Units started without developer contributions \n", "6 NaN \n", "7 NaN \n", "8 j1aa \n", "9 j1ba \n", "10 j1ca \n", "11 j1da \n", "12 j1ea \n", "13 j1fa \n", "14 j1ga \n", "15 j1ha \n", "16 Units starteed without developer contributions \n", "17 NaN \n", "18 NaN \n", "19 j2aa \n", "20 j2ba \n", "21 j2ca \n", "22 j2da \n", "23 j2ea \n", "24 j2fa \n", "25 j2ga \n", "26 j2ha \n", "27 Units started without developer contributions \n", "28 NaN \n", "29 NaN \n", "30 j3aa \n", "31 j3ba \n", "32 j3ca \n", "33 j3da \n", "34 j3ea \n", "35 j3fa \n", "36 j3ga \n", "37 j3ha \n", "\n", " 3 \n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 (b) \n", "5 Units started with developer contributions thr... \n", "6 NaN \n", "7 NaN \n", "8 j1ab \n", "9 j1bb \n", "10 j1cb \n", "11 j1db \n", "12 j1eb \n", "13 j1fb \n", "14 j1gb \n", "15 j1hb \n", "16 Units started with developer contributions thr... \n", "17 NaN \n", "18 NaN \n", "19 j2ab \n", "20 j2bb \n", "21 j2cb \n", "22 j2db \n", "23 j2eb \n", "24 j2fb \n", "25 j2gb \n", "26 j2hb \n", "27 Units started with developer contributions thr... \n", "28 NaN \n", "29 NaN \n", "30 j3ab \n", "31 j3bb \n", "32 j3cb \n", "33 j3db \n", "34 j3eb \n", "35 j3fb \n", "36 j3gb \n", "37 j3hb " ] }, "execution_count": 210, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp = xl[metadata[k]['sheet']]\n", "tmp" ] }, { "cell_type": "code", "execution_count": 211, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123
0This section should be completed by all Local ...
1Provision of New Build Additional Affordable H...
2In Questions 1, 2 and 3 only report new build ...
3Units that have been started and completed in ...
41. Owned by Local Authority, not reported to H...(a)(b)
5Units started without developer contributionsUnits started with developer contributions thr...
6If any dwellings are not funded by the HCA/GLA...
7please record how the dwellings are funded in ...
8a.Social Rent00
9b.Affordable Rent00
10c.Intermediate Rent00
11d.Affordable Home Ownership (excluding Shared ...00
12e.Shared Ownership00
13f.Starter Homes00
14g.Unknown tenure00
15h.Total Number of units00
162. Owned by Private Registered Providers (incl...Units starteed without developer contributionsUnits started with developer contributions thr...
17If any dwellings are not funded by the HCA/GLA...
18please record how the dwellings are funded in ...
19a.Social Rent00
20b.Affordable Rent00
21c.Intermediate Rent00
22d.Affordable Home Ownership (excluding Shared ...00
23e.Shared Ownership00
24f.Starter Homes00
25g.Unknown tenure00
26h.Total Number of units00
273. Owned by non-registered providersUnits started without developer contributionsUnits started with developer contributions thr...
28If any dwellings are not funded by the HCA/GLA...
29please record how the dwellings are funded in ...
30a.Social Rent00
31b.Affordable Rent00
32c.Intermediate Rent00
33d.Affordable Home Ownership (excluding Shared ...00
34e.Shared Ownership00
35f.Starter Homes00
36g.Unknown tenure00
37h.Total Number of units00
\n", "
" ], "text/plain": [ " 0 \\\n", "0 This section should be completed by all Local ... \n", "1 Provision of New Build Additional Affordable H... \n", "2 In Questions 1, 2 and 3 only report new build ... \n", "3 Units that have been started and completed in ... \n", "4 1. Owned by Local Authority, not reported to H... \n", "5 \n", "6 If any dwellings are not funded by the HCA/GLA... \n", "7 please record how the dwellings are funded in ... \n", "8 \n", "9 \n", "10 \n", "11 \n", "12 \n", "13 \n", "14 \n", "15 \n", "16 2. Owned by Private Registered Providers (incl... \n", "17 If any dwellings are not funded by the HCA/GLA... \n", "18 please record how the dwellings are funded in ... \n", "19 \n", "20 \n", "21 \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 3. Owned by non-registered providers \n", "28 If any dwellings are not funded by the HCA/GLA... \n", "29 please record how the dwellings are funded in ... \n", "30 \n", "31 \n", "32 \n", "33 \n", "34 \n", "35 \n", "36 \n", "37 \n", "\n", " 1 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 a.Social Rent \n", "9 b.Affordable Rent \n", "10 c.Intermediate Rent \n", "11 d.Affordable Home Ownership (excluding Shared ... \n", "12 e.Shared Ownership \n", "13 f.Starter Homes \n", "14 g.Unknown tenure \n", "15 h.Total Number of units \n", "16 \n", "17 \n", "18 \n", "19 a.Social Rent \n", "20 b.Affordable Rent \n", "21 c.Intermediate Rent \n", "22 d.Affordable Home Ownership (excluding Shared ... \n", "23 e.Shared Ownership \n", "24 f.Starter Homes \n", "25 g.Unknown tenure \n", "26 h.Total Number of units \n", "27 \n", "28 \n", "29 \n", "30 a.Social Rent \n", "31 b.Affordable Rent \n", "32 c.Intermediate Rent \n", "33 d.Affordable Home Ownership (excluding Shared ... \n", "34 e.Shared Ownership \n", "35 f.Starter Homes \n", "36 g.Unknown tenure \n", "37 h.Total Number of units \n", "\n", " 2 \\\n", "0 \n", "1 \n", "2 \n", "3 \n", "4 (a) \n", "5 Units started without developer contributions \n", "6 \n", "7 \n", "8 0 \n", "9 0 \n", "10 0 \n", "11 0 \n", "12 0 \n", "13 0 \n", "14 0 \n", "15 0 \n", "16 Units starteed without developer contributions \n", "17 \n", "18 \n", "19 0 \n", "20 0 \n", "21 0 \n", "22 0 \n", "23 0 \n", "24 0 \n", "25 0 \n", "26 0 \n", "27 Units started without developer contributions \n", "28 \n", "29 \n", "30 0 \n", "31 0 \n", "32 0 \n", "33 0 \n", "34 0 \n", "35 0 \n", "36 0 \n", "37 0 \n", "\n", " 3 \n", "0 \n", "1 \n", "2 \n", "3 \n", "4 (b) \n", "5 Units started with developer contributions thr... \n", "6 \n", "7 \n", "8 0 \n", "9 0 \n", "10 0 \n", "11 0 \n", "12 0 \n", "13 0 \n", "14 0 \n", "15 0 \n", "16 Units started with developer contributions thr... \n", "17 \n", "18 \n", "19 0 \n", "20 0 \n", "21 0 \n", "22 0 \n", "23 0 \n", "24 0 \n", "25 0 \n", "26 0 \n", "27 Units started with developer contributions thr... \n", "28 \n", "29 \n", "30 0 \n", "31 0 \n", "32 0 \n", "33 0 \n", "34 0 \n", "35 0 \n", "36 0 \n", "37 0 " ] }, "execution_count": 211, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tmp.replace(to_replace=lahs_2017_18_dict).fillna('')" ] }, { "cell_type": "code", "execution_count": 133, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
1. Owned by Local Authority, not reported to HCA or GLAUnits started without developer contributionsUnits started with developer contributions through planning obligations
0a.Social Rentj1aaj1ab
1b.Affordable Rentj1baj1bb
2c.Intermediate Rentj1caj1cb
3d.Affordable Home Ownership (excluding Shared ...j1daj1db
4e.Shared Ownershipj1eaj1eb
5f.Starter Homesj1faj1fb
6g.Unknown tenurej1gaj1gb
7h.Total Number of unitsj1haj1hb
\n", "
" ], "text/plain": [ " 1. Owned by Local Authority, not reported to HCA or GLA \\\n", "0 a.Social Rent \n", "1 b.Affordable Rent \n", "2 c.Intermediate Rent \n", "3 d.Affordable Home Ownership (excluding Shared ... \n", "4 e.Shared Ownership \n", "5 f.Starter Homes \n", "6 g.Unknown tenure \n", "7 h.Total Number of units \n", "\n", " Units started without developer contributions \\\n", "0 j1aa \n", "1 j1ba \n", "2 j1ca \n", "3 j1da \n", "4 j1ea \n", "5 j1fa \n", "6 j1ga \n", "7 j1ha \n", "\n", " Units started with developer contributions through planning obligations \n", "0 j1ab \n", "1 j1bb \n", "2 j1cb \n", "3 j1db \n", "4 j1eb \n", "5 j1fb \n", "6 j1gb \n", "7 j1hb " ] }, "execution_count": 133, "metadata": {}, "output_type": "execute_result" } ], "source": [ "j1 = tmp.loc[8:15,[1,2,3]].reset_index(drop=True)\n", "j1.columns = tmp.loc[4,[0]].tolist() + tmp.loc[5,[2,3]].tolist()\n", "j1" ] }, { "cell_type": "code", "execution_count": 134, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2. Owned by Private Registered Providers (including HAs) not reported to HCA or GLAUnits starteed without developer contributionsUnits started with developer contributions through planning obligations
19a.Social Rentj2aaj2ab
20b.Affordable Rentj2baj2bb
21c.Intermediate Rentj2caj2cb
22d.Affordable Home Ownership (excluding Shared ...j2daj2db
23e.Shared Ownershipj2eaj2eb
24f.Starter Homesj2faj2fb
25g.Unknown tenurej2gaj2gb
26h.Total Number of unitsj2haj2hb
\n", "
" ], "text/plain": [ " 2. Owned by Private Registered Providers (including HAs) not reported to HCA or GLA \\\n", "19 a.Social Rent \n", "20 b.Affordable Rent \n", "21 c.Intermediate Rent \n", "22 d.Affordable Home Ownership (excluding Shared ... \n", "23 e.Shared Ownership \n", "24 f.Starter Homes \n", "25 g.Unknown tenure \n", "26 h.Total Number of units \n", "\n", " Units starteed without developer contributions \\\n", "19 j2aa \n", "20 j2ba \n", "21 j2ca \n", "22 j2da \n", "23 j2ea \n", "24 j2fa \n", "25 j2ga \n", "26 j2ha \n", "\n", " Units started with developer contributions through planning obligations \n", "19 j2ab \n", "20 j2bb \n", "21 j2cb \n", "22 j2db \n", "23 j2eb \n", "24 j2fb \n", "25 j2gb \n", "26 j2hb " ] }, "execution_count": 134, "metadata": {}, "output_type": "execute_result" } ], "source": [ "j2 = tmp.loc[19:26,[1,2,3]]\n", "j2.columns = tmp.loc[16,[0,2,3]].tolist()\n", "j2" ] }, { "cell_type": "code", "execution_count": 135, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
3. Owned by non-registered providersUnits started without developer contributionsUnits started with developer contributions through planning obligations
30a.Social Rentj3aaj3ab
31b.Affordable Rentj3baj3bb
32c.Intermediate Rentj3caj3cb
33d.Affordable Home Ownership (excluding Shared ...j3daj3db
34e.Shared Ownershipj3eaj3eb
35f.Starter Homesj3faj3fb
36g.Unknown tenurej3gaj3gb
37h.Total Number of unitsj3haj3hb
\n", "
" ], "text/plain": [ " 3. Owned by non-registered providers \\\n", "30 a.Social Rent \n", "31 b.Affordable Rent \n", "32 c.Intermediate Rent \n", "33 d.Affordable Home Ownership (excluding Shared ... \n", "34 e.Shared Ownership \n", "35 f.Starter Homes \n", "36 g.Unknown tenure \n", "37 h.Total Number of units \n", "\n", " Units started without developer contributions \\\n", "30 j3aa \n", "31 j3ba \n", "32 j3ca \n", "33 j3da \n", "34 j3ea \n", "35 j3fa \n", "36 j3ga \n", "37 j3ha \n", "\n", " Units started with developer contributions through planning obligations \n", "30 j3ab \n", "31 j3bb \n", "32 j3cb \n", "33 j3db \n", "34 j3eb \n", "35 j3fb \n", "36 j3gb \n", "37 j3hb " ] }, "execution_count": 135, "metadata": {}, "output_type": "execute_result" } ], "source": [ "j3 = tmp.loc[30:37,[1,2,3]]\n", "j3.columns = tmp.loc[27,[0,2,3]].tolist()\n", "j3" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Unused But Possibly Useful Elsewhere" ] }, { "cell_type": "code", "execution_count": 166, "metadata": {}, "outputs": [], "source": [ "#https://gist.github.com/bgusach/a967e0587d6e01e889fd1d776c5f3729\n", "#Python string multireplacement\n", "import re\n", "\n", "def multireplace(string, replacements):\n", " \"\"\"\n", " Given a string and a replacement map, it returns the replaced string.\n", " :param str string: string to execute replacements on\n", " :param dict replacements: replacement dictionary {value to find: value to replace}\n", " :rtype: str\n", " \"\"\"\n", " # Place longer ones first to keep shorter substrings from matching where the longer ones should take place\n", " # For instance given the replacements {'ab': 'AB', 'abc': 'ABC'} against the string 'hey abc', it should produce\n", " # 'hey ABC' and not 'hey ABc'\n", " substrs = sorted(replacements, key=len, reverse=True)\n", "\n", " # Create a big OR regex that matches any of the substrings to replace\n", " regexp = re.compile('|'.join(map(re.escape, substrs)))\n", "\n", " # For each match, look up the new string in the replacements\n", " return regexp.sub(lambda match: replacements[match.group(0)], string)\n" ] } ], "metadata": { "jupytext": { "main_language": "python", "text_representation": { "extension": ".md", "format_name": "markdown", "format_version": "1.0", "jupytext_version": "0.8.6" } }, "kernelspec": { "display_name": "Python 3", "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.7.0" } }, "nbformat": 4, "nbformat_minor": 2 }