Household Debt Inequalities#
A relatively simple two sheet extraction from data first published by the UK Office for National Statistics.
Tutorial Structure#
With these example tutorials I’m going to comment heavily and cover nuances in a follow up section (with liberal targetted previews as needed) as it’s the easiest way to grapple with new ideas. It may also be worth opening up these notebooks yourself (they’re in ./jupyterbook in the tidychef github repo) so you can run, alter and generally have a play about with this yourself as part of your learning.
We’ll cover:
source data
requirements, what we’re aiming to do here
show the full script (all logic commented)
output the selection preview
nuances (where applicable)
view the output
This sequencing is necessary as the output for some of the example is really long so that necessitates it coming last. If you’re viewing this via a jupyter book (i.e on the site) you can navigate between the above sections via your right hand menu.
Note - these tutorial scripts might seem verbose due all the comments but that’s ok (this is a tutorial after all). If you take them out you end up with a fairly succinct and human readable encapsulation of what would otherwise (with existing tools) be a rather convoluted and fragile set of instructions to express.
In virtually all cases I’ll make heavy use of preview and bounded to only look at relevant parts of what can be quite large datasets. Downloads links are provided for the source data.
Source#
For this example we’re extracting the tables 11 and 12 from an xls dataset dealing with household debt inequalities.
The example highlights using iteration to join multiple tables into a coherent whole.
from typing import List
from tidychef import acquire, preview
from tidychef.selection import XlsSelectable
tables: List[XlsSelectable] = acquire.xls.http("https://raw.githubusercontent.com/mikeAdamss/tidychef/main/tests/fixtures/xls/householddebtdataset.xls", tables="Table 11|Table 12")
for table in tables:
preview(table)
Table 11
| A | B | C | D | E | F | G | H | |
| 1 | Table 11 | Back to contents | ||||||
| 2 | Individuals with financial liabilities by economic activity: Great Britain, July 2010 to June 2014 | |||||||
| 3 | Great Britain | |||||||
| 4 | Economic Activity | Percentage with financial liabilities (%) | Median value of financial liabilities (£) | Median value of individual annual net income (£) | Median Individual Debt to Income Ratio | Median value of individual gross financial wealth (£) | Unweighted Frequency | Weighted Frequency |
| 5 | July 2012 to June 2014 | |||||||
| 6 | In Employment | 44.0 | 2900.0 | 18000.0 | 0.15 | 1000.0 | 8175.0 | 12748000.0 |
| 7 | Unemployed | 41.0 | 1200.0 | 3700.0 | 0.35 | 0.0 | 481.0 | 813000.0 |
| 8 | Economically Inactive | 21.0 | 1000.0 | 9400.0 | 0.14 | 300.0 | 2909.0 | 3728000.0 |
| 9 | All Individuals with financial liabilities | 35.0 | 2200.0 | 15700.0 | 0.15 | 800.0 | 11565.0 | 17290000.0 |
| 10 | July 2010 to June 2012 | |||||||
| 11 | In Employment | 46.0 | 3100.0 | 17500.0 | 0.17 | 1000.0 | 9375.0 | 12781000.0 |
| 12 | Unemployed | 44.0 | 1100.0 | 3700.0 | 0.36 | 0.0 | 604.0 | 845000.0 |
| 13 | Economically Inactive | 23.0 | 1000.0 | 9300.0 | 0.14 | 300.0 | 3328.0 | 3966000.0 |
| 14 | All Individuals with financial liabilities | 38.0 | 2300.0 | 15200.0 | 0.17 | 800.0 | 13307.0 | 17592000.0 |
| 15 | Source: Wealth and Assets Survey, Office for National Statistics | |||||||
| 16 | Notes: | |||||||
| 17 | Median values include only individuals with financial liabilities | |||||||
| 18 | ' - ' denotes a value less than £50 |
Table 12
| A | B | C | D | E | F | G | H | I | |
| 1 | Table 12 | Back to contents | |||||||
| 2 | Individuals with financial liabilities by education level: Great Britain, July 2010 to June 2014 | ||||||||
| 3 | Great Britain | ||||||||
| 4 | Education Level | Percentage with financial liabilities (%) | Median value of financial liabilities (£) | Median value of individual annual net income (£) | Median Individual Debt to Income Ratio | Median value of individual gross financial wealth (£) | Unweighted Frequency | Weighted Frequency | |
| 5 | July 2012 to June 2014 | ||||||||
| 6 | Degree level or above | 41.0 | 4600.0 | 20500.0 | 0.22 | 2600.0 | 3188.0 | 4844000.0 | |
| 7 | Other qualifications | 37.0 | 1900.0 | 15100.0 | 0.14 | 600.0 | 6638.0 | 9906000.0 | |
| 8 | No qualifications | 22.0 | 900.0 | 11700.0 | 0.09 | 100.0 | 1332.0 | 1860000.0 | |
| 9 | All Individuals with financial liabilities | 35.0 | 2200.0 | 15700.0 | 0.15 | 800.0 | 11158.0 | 16610000.0 | |
| 10 | July 2010 to June 2012 | ||||||||
| 11 | Degree level or above | 41.0 | 4700.0 | 21000.0 | 0.23 | 2600.0 | 3118.0 | 4087000.0 | |
| 12 | Other qualifications | 41.0 | 2200.0 | 14700.0 | 0.17 | 500.0 | 7497.0 | 9940000.0 | |
| 13 | No qualifications | 26.0 | 1100.0 | 12200.0 | 0.11 | 200.0 | 2104.0 | 2737000.0 | |
| 14 | All Individuals with financial liabilities | 38.0 | 2300.0 | 15200.0 | 0.17 | 800.0 | 13307.0 | 17592000.0 | |
| 15 | Source: Wealth and Assets Survey, Office for National Statistics | ||||||||
| 16 | Notes: | ||||||||
| 17 | Median values include only individuals with financial liabilities | ||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 | |||||||||
| 25 | |||||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 |
From an xls source which can be downloaded here.
Requirements#
We’re going to extract “Period” from the obvious dates in column A.
We’re just going to call the principle field indicated by column A “Category”.
We’re going to take “Great Britain” as a constant for a column named “Area”.
We’re going to take the headers on row 4 as “Financial Liability”
As an additional exercise we’re going to use a horizontal condition to create a “Unit Of Measure” column to be one of “Pounds Sterling”, “Percent”, “Ratio” or “Number” depending on the category.
We’re going to prefix “Category” as extracted from table 12 with “Education: “ to make the data a little easier to understand.
We’re going to join both tables into a single tidy data output.
We’re going to de-duplicate with a printout of what we’ve removed - it should be the contents of row 14 as its duplicated on both tables.
We’ll strip trailing “.0”s from the observations (which we’ll call “Value” this time).
from typing import Dict, List
from tidychef import acquire, preview
from tidychef.direction import down, right, left
from tidychef.output import Column, TidyData
from tidychef.selection import XlsSelectable
# We'll use the vategory information to determine the unit of measure.
# For more on how this works see the documentation for horizontal condition and the tourism example.
def derive_unit_of_measure(line) -> str:
"""
Function to define unit of measure based on Financial Liability
"""
cat = line["Category"]
if "(%)" in cat:
return "Percent"
elif "(£)" in cat:
return "Pounds Sterling"
elif "Frequency" in cat:
return "Number"
elif "Ratio" in cat:
return "Ratio"
else:
raise Exception(f"Cannot identify unit of measure from: {cat}")
# We'll use two tables from this data source.
tables: List[XlsSelectable] = acquire.xls.http("https://raw.githubusercontent.com/mikeAdamss/tidychef/main/tests/fixtures/xls/householddebtdataset.xls", tables="Table 11|Table 12")
all_tidy_data = []
for table in tables:
# We just want the cell with Great Britain in it.
# You could hard code this into the tidydata but this way we'll be warned if this area cell is not there
area = table.excel_ref("A").cell_containing_string("Great Britain").label_as("Area")
# We'll need a regex to get the periods out of column A. This regex is looking for any string ending in 4 integers, i.e a year
period = table.excel_ref("A3").fill(down).re(".*[0-9]{4}").assert_len(2).label_as("Period")
# The categories are to one level down and to the right of the area ell
category = area.shift(down).fill(right).label_as("Category")
# Observations are any numeric values below a category
observations = category.fill(down).is_not_blank().is_numeric().label_as("Observation")
# See nuances
financial_liability = (observations.shift(left) - observations).label_as("Financial Liability")
# The table in question dictates the type of liability category
liability_category = "Economic Activity" if table.name == "Table 11" else "Education Level"
preview(observations, area, period, category, financial_liability)
tidy_data = TidyData(
observations,
Column(period.attach_closest(down)),
Column(category.attach_directly(down), apply=lambda x: "Eduction: "+x if table.name == "Table 12" else x), # see nuances
Column(financial_liability.attach_directly(right)),
Column.constant("Area", area.lone_value()),
Column.constant("Liability Category", liability_category),
Column.horizontal_condition("Unit Of Measure", derive_unit_of_measure), # Derive unit of measure
obs_apply=lambda x: x.replace(".0", "") # We'll clean off the unwanted '.0's from the observations.
)
all_tidy_data.append(tidy_data)
final_tidy_data = TidyData.from_tidy_list(all_tidy_data)
| Observation |
| Area |
| Period |
| Category |
| Financial Liability |
Table 11
| A | B | C | D | E | F | G | H | |
| 1 | Table 11 | Back to contents | ||||||
| 2 | Individuals with financial liabilities by economic activity: Great Britain, July 2010 to June 2014 | |||||||
| 3 | Great Britain | |||||||
| 4 | Economic Activity | Percentage with financial liabilities (%) | Median value of financial liabilities (£) | Median value of individual annual net income (£) | Median Individual Debt to Income Ratio | Median value of individual gross financial wealth (£) | Unweighted Frequency | Weighted Frequency |
| 5 | July 2012 to June 2014 | |||||||
| 6 | In Employment | 44.0 | 2900.0 | 18000.0 | 0.15 | 1000.0 | 8175.0 | 12748000.0 |
| 7 | Unemployed | 41.0 | 1200.0 | 3700.0 | 0.35 | 0.0 | 481.0 | 813000.0 |
| 8 | Economically Inactive | 21.0 | 1000.0 | 9400.0 | 0.14 | 300.0 | 2909.0 | 3728000.0 |
| 9 | All Individuals with financial liabilities | 35.0 | 2200.0 | 15700.0 | 0.15 | 800.0 | 11565.0 | 17290000.0 |
| 10 | July 2010 to June 2012 | |||||||
| 11 | In Employment | 46.0 | 3100.0 | 17500.0 | 0.17 | 1000.0 | 9375.0 | 12781000.0 |
| 12 | Unemployed | 44.0 | 1100.0 | 3700.0 | 0.36 | 0.0 | 604.0 | 845000.0 |
| 13 | Economically Inactive | 23.0 | 1000.0 | 9300.0 | 0.14 | 300.0 | 3328.0 | 3966000.0 |
| 14 | All Individuals with financial liabilities | 38.0 | 2300.0 | 15200.0 | 0.17 | 800.0 | 13307.0 | 17592000.0 |
| 15 | Source: Wealth and Assets Survey, Office for National Statistics | |||||||
| 16 | Notes: | |||||||
| 17 | Median values include only individuals with financial liabilities | |||||||
| 18 | ' - ' denotes a value less than £50 |
| Observation |
| Area |
| Period |
| Category |
| Financial Liability |
Table 12
| A | B | C | D | E | F | G | H | I | |
| 1 | Table 12 | Back to contents | |||||||
| 2 | Individuals with financial liabilities by education level: Great Britain, July 2010 to June 2014 | ||||||||
| 3 | Great Britain | ||||||||
| 4 | Education Level | Percentage with financial liabilities (%) | Median value of financial liabilities (£) | Median value of individual annual net income (£) | Median Individual Debt to Income Ratio | Median value of individual gross financial wealth (£) | Unweighted Frequency | Weighted Frequency | |
| 5 | July 2012 to June 2014 | ||||||||
| 6 | Degree level or above | 41.0 | 4600.0 | 20500.0 | 0.22 | 2600.0 | 3188.0 | 4844000.0 | |
| 7 | Other qualifications | 37.0 | 1900.0 | 15100.0 | 0.14 | 600.0 | 6638.0 | 9906000.0 | |
| 8 | No qualifications | 22.0 | 900.0 | 11700.0 | 0.09 | 100.0 | 1332.0 | 1860000.0 | |
| 9 | All Individuals with financial liabilities | 35.0 | 2200.0 | 15700.0 | 0.15 | 800.0 | 11158.0 | 16610000.0 | |
| 10 | July 2010 to June 2012 | ||||||||
| 11 | Degree level or above | 41.0 | 4700.0 | 21000.0 | 0.23 | 2600.0 | 3118.0 | 4087000.0 | |
| 12 | Other qualifications | 41.0 | 2200.0 | 14700.0 | 0.17 | 500.0 | 7497.0 | 9940000.0 | |
| 13 | No qualifications | 26.0 | 1100.0 | 12200.0 | 0.11 | 200.0 | 2104.0 | 2737000.0 | |
| 14 | All Individuals with financial liabilities | 38.0 | 2300.0 | 15200.0 | 0.17 | 800.0 | 13307.0 | 17592000.0 | |
| 15 | Source: Wealth and Assets Survey, Office for National Statistics | ||||||||
| 16 | Notes: | ||||||||
| 17 | Median values include only individuals with financial liabilities | ||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 | |||||||||
| 25 | |||||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 |
Nuances#
Shift and remove self#
So there’s a slightly counter intuitive pattern I’m using here that’s worth exploring, namely:
financial_liability = (observations.shift(left) - observations).label_as("Financial Liability")
To understand this, we’ll look at a few rows only of both observations and observations.shift(left)
preview(observations.shift(left).label_as("Observations shifted left"), bounded="A5:H8")
preview(observations.label_as("Observations"), bounded="A5:H8")
| Observations shifted left |
Table 12
| A | B | C | D | E | F | G | H | |
| 5 | July 2012 to June 2014 | |||||||
| 6 | Degree level or above | 41 | 4600 | 20500 | 0.22 | 2600 | 3188 | 4844000 |
| 7 | Other qualifications | 37 | 1900 | 15100 | 0.14 | 600 | 6638 | 9906000 |
| 8 | No qualifications | 22 | 900 | 11700 | 09 | 100 | 1332 | 1860000 |
| Observations |
Table 12
| A | B | C | D | E | F | G | H | |
| 5 | July 2012 to June 2014 | |||||||
| 6 | Degree level or above | 41 | 4600 | 20500 | 0.22 | 2600 | 3188 | 4844000 |
| 7 | Other qualifications | 37 | 1900 | 15100 | 0.14 | 600 | 6638 | 9906000 |
| 8 | No qualifications | 22 | 900 | 11700 | 09 | 100 | 1332 | 1860000 |
Now lets look at what you get if you remove the first from the second
result = (observations.shift(left) - observations).label_as("Result of subrtraction")
preview(result, bounded="A5:H8")
| Result of subrtraction |
Table 12
| A | B | C | D | E | F | G | H | |
| 5 | July 2012 to June 2014 | |||||||
| 6 | Degree level or above | 41 | 4600 | 20500 | 0.22 | 2600 | 3188 | 4844000 |
| 7 | Other qualifications | 37 | 1900 | 15100 | 0.14 | 600 | 6638 | 9906000 |
| 8 | No qualifications | 22 | 900 | 11700 | 09 | 100 | 1332 | 1860000 |
In simplest terms a subtraction of selections equates to
Remove any cells in the 2nd selection from the cells in the 1st selection.
Which is exactly what we’re doing above.
Outputs#
The tidy data can be downloaded here and a full inline preview of the tidydata generated is shown below for those people who’d prefer to scroll.
print(final_tidy_data)
| Observation | Period | Category | Financial Liability | Area | Liability Category | Unit Of Measure |
| 44 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | In Employment | Great Britain | Economic Activity | Percent |
| 41 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | Unemployed | Great Britain | Economic Activity | Percent |
| 21 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | Economically Inactive | Great Britain | Economic Activity | Percent |
| 35 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | All Individuals with financial liabilities | Great Britain | Economic Activity | Percent |
| 46 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | In Employment | Great Britain | Economic Activity | Percent |
| 44 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | Unemployed | Great Britain | Economic Activity | Percent |
| 23 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | Economically Inactive | Great Britain | Economic Activity | Percent |
| 38 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | All Individuals with financial liabilities | Great Britain | Economic Activity | Percent |
| 2900 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 1200 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 1000 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 2200 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 3100 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 1100 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 1000 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 2300 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 18000 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 3700 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 9400 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 15700 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 17500 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 3700 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 9300 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 15200 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 0.15 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | In Employment | Great Britain | Economic Activity | Ratio |
| 0.35 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | Unemployed | Great Britain | Economic Activity | Ratio |
| 0.14 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | Economically Inactive | Great Britain | Economic Activity | Ratio |
| 0.15 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | All Individuals with financial liabilities | Great Britain | Economic Activity | Ratio |
| 0.17 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | In Employment | Great Britain | Economic Activity | Ratio |
| 0.36 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | Unemployed | Great Britain | Economic Activity | Ratio |
| 0.14 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | Economically Inactive | Great Britain | Economic Activity | Ratio |
| 0.17 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | All Individuals with financial liabilities | Great Britain | Economic Activity | Ratio |
| 1000 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 0 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 300 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 800 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 1000 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | In Employment | Great Britain | Economic Activity | Pounds Sterling |
| 0 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | Unemployed | Great Britain | Economic Activity | Pounds Sterling |
| 300 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | Economically Inactive | Great Britain | Economic Activity | Pounds Sterling |
| 800 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | All Individuals with financial liabilities | Great Britain | Economic Activity | Pounds Sterling |
| 8175 | July 2012 to June 2014 | Eduction: Unweighted Frequency | In Employment | Great Britain | Economic Activity | Number |
| 481 | July 2012 to June 2014 | Eduction: Unweighted Frequency | Unemployed | Great Britain | Economic Activity | Number |
| 2909 | July 2012 to June 2014 | Eduction: Unweighted Frequency | Economically Inactive | Great Britain | Economic Activity | Number |
| 11565 | July 2012 to June 2014 | Eduction: Unweighted Frequency | All Individuals with financial liabilities | Great Britain | Economic Activity | Number |
| 9375 | July 2010 to June 2012 | Eduction: Unweighted Frequency | In Employment | Great Britain | Economic Activity | Number |
| 604 | July 2010 to June 2012 | Eduction: Unweighted Frequency | Unemployed | Great Britain | Economic Activity | Number |
| 3328 | July 2010 to June 2012 | Eduction: Unweighted Frequency | Economically Inactive | Great Britain | Economic Activity | Number |
| 13307 | July 2010 to June 2012 | Eduction: Unweighted Frequency | All Individuals with financial liabilities | Great Britain | Economic Activity | Number |
| 12748000 | July 2012 to June 2014 | Eduction: Weighted Frequency | In Employment | Great Britain | Economic Activity | Number |
| 813000 | July 2012 to June 2014 | Eduction: Weighted Frequency | Unemployed | Great Britain | Economic Activity | Number |
| 3728000 | July 2012 to June 2014 | Eduction: Weighted Frequency | Economically Inactive | Great Britain | Economic Activity | Number |
| 17290000 | July 2012 to June 2014 | Eduction: Weighted Frequency | All Individuals with financial liabilities | Great Britain | Economic Activity | Number |
| 12781000 | July 2010 to June 2012 | Eduction: Weighted Frequency | In Employment | Great Britain | Economic Activity | Number |
| 845000 | July 2010 to June 2012 | Eduction: Weighted Frequency | Unemployed | Great Britain | Economic Activity | Number |
| 3966000 | July 2010 to June 2012 | Eduction: Weighted Frequency | Economically Inactive | Great Britain | Economic Activity | Number |
| 17592000 | July 2010 to June 2012 | Eduction: Weighted Frequency | All Individuals with financial liabilities | Great Britain | Economic Activity | Number |
| 41 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | Degree level or above | Great Britain | Education Level | Percent |
| 37 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | Other qualifications | Great Britain | Education Level | Percent |
| 22 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | No qualifications | Great Britain | Education Level | Percent |
| 35 | July 2012 to June 2014 | Eduction: Percentage with financial liabilities (%) | All Individuals with financial liabilities | Great Britain | Education Level | Percent |
| 41 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | Degree level or above | Great Britain | Education Level | Percent |
| 41 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | Other qualifications | Great Britain | Education Level | Percent |
| 26 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | No qualifications | Great Britain | Education Level | Percent |
| 38 | July 2010 to June 2012 | Eduction: Percentage with financial liabilities (%) | All Individuals with financial liabilities | Great Britain | Education Level | Percent |
| 4600 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 1900 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 900 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 2200 | July 2012 to June 2014 | Eduction: Median value of financial liabilities (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 4700 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 2200 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 1100 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 2300 | July 2010 to June 2012 | Eduction: Median value of financial liabilities (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 20500 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 15100 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 11700 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 15700 | July 2012 to June 2014 | Eduction: Median value of individual annual net income (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 21000 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 14700 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 12200 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 15200 | July 2010 to June 2012 | Eduction: Median value of individual annual net income (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 0.22 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | Degree level or above | Great Britain | Education Level | Ratio |
| 0.14 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | Other qualifications | Great Britain | Education Level | Ratio |
| 09 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | No qualifications | Great Britain | Education Level | Ratio |
| 0.15 | July 2012 to June 2014 | Eduction: Median Individual Debt to Income Ratio | All Individuals with financial liabilities | Great Britain | Education Level | Ratio |
| 0.23 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | Degree level or above | Great Britain | Education Level | Ratio |
| 0.17 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | Other qualifications | Great Britain | Education Level | Ratio |
| 0.11 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | No qualifications | Great Britain | Education Level | Ratio |
| 0.17 | July 2010 to June 2012 | Eduction: Median Individual Debt to Income Ratio | All Individuals with financial liabilities | Great Britain | Education Level | Ratio |
| 2600 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 600 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 100 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 800 | July 2012 to June 2014 | Eduction: Median value of individual gross financial wealth (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 2600 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | Degree level or above | Great Britain | Education Level | Pounds Sterling |
| 500 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | Other qualifications | Great Britain | Education Level | Pounds Sterling |
| 200 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | No qualifications | Great Britain | Education Level | Pounds Sterling |
| 800 | July 2010 to June 2012 | Eduction: Median value of individual gross financial wealth (£) | All Individuals with financial liabilities | Great Britain | Education Level | Pounds Sterling |
| 3188 | July 2012 to June 2014 | Eduction: Unweighted Frequency | Degree level or above | Great Britain | Education Level | Number |
| 6638 | July 2012 to June 2014 | Eduction: Unweighted Frequency | Other qualifications | Great Britain | Education Level | Number |
| 1332 | July 2012 to June 2014 | Eduction: Unweighted Frequency | No qualifications | Great Britain | Education Level | Number |
| 11158 | July 2012 to June 2014 | Eduction: Unweighted Frequency | All Individuals with financial liabilities | Great Britain | Education Level | Number |
| 3118 | July 2010 to June 2012 | Eduction: Unweighted Frequency | Degree level or above | Great Britain | Education Level | Number |
| 7497 | July 2010 to June 2012 | Eduction: Unweighted Frequency | Other qualifications | Great Britain | Education Level | Number |
| 2104 | July 2010 to June 2012 | Eduction: Unweighted Frequency | No qualifications | Great Britain | Education Level | Number |
| 13307 | July 2010 to June 2012 | Eduction: Unweighted Frequency | All Individuals with financial liabilities | Great Britain | Education Level | Number |
| 4844000 | July 2012 to June 2014 | Eduction: Weighted Frequency | Degree level or above | Great Britain | Education Level | Number |
| 9906000 | July 2012 to June 2014 | Eduction: Weighted Frequency | Other qualifications | Great Britain | Education Level | Number |
| 1860000 | July 2012 to June 2014 | Eduction: Weighted Frequency | No qualifications | Great Britain | Education Level | Number |
| 16610000 | July 2012 to June 2014 | Eduction: Weighted Frequency | All Individuals with financial liabilities | Great Britain | Education Level | Number |
| 4087000 | July 2010 to June 2012 | Eduction: Weighted Frequency | Degree level or above | Great Britain | Education Level | Number |
| 9940000 | July 2010 to June 2012 | Eduction: Weighted Frequency | Other qualifications | Great Britain | Education Level | Number |
| 2737000 | July 2010 to June 2012 | Eduction: Weighted Frequency | No qualifications | Great Britain | Education Level | Number |
| 17592000 | July 2010 to June 2012 | Eduction: Weighted Frequency | All Individuals with financial liabilities | Great Britain | Education Level | Number |