Skip to content

Instantly share code, notes, and snippets.

@drkane

drkane/prepare-chord-diagram.ipynb

Created November 25, 2018 20:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drkane/57ec021865f1502e9ccdfcd28e7ab8e3 to your computer and use it in GitHub Desktop.
Save drkane/57ec021865f1502e9ccdfcd28e7ab8e3 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
prepare-chord-diagram.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Visualising the network of 360 Giving grants\n",
"\n",
"## Preparing the data\n",
"\n",
"This notebook takes you through the process of preparing grants data\n",
"to produce a network diagram showing relationships between funders.\n",
"In this notebook I will:\n",
"\n",
"1. Fetch grants data from [GrantNav](http://grantnav.threesixtygiving.org/)\n",
"2. Transform it into a tables of links between funders and recipients\n",
"3. Export those tables to the right format\n",
"\n",
"The resulting table shows which funders share recipients in common with\n",
"other funders."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"The first step is to import the [pandas](https://pandas.pydata.org/) data \n",
"analysis library. I'll be using this to fetch and transform the data."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 1. Fetch grants data"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"First I make a variable containing a URL to a GrantNav CSV file.\n",
"This link was found by performing a search on GrantNav and then\n",
"right clicking on the \"CSV\" download button in the top right, \n",
"and selecting \"Copy link location\" (the exact way of copying the\n",
"link may vary in different browsers)."
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"grantnav_url = 'http://grantnav.threesixtygiving.org/search.csv?json_query=%7B%22aggs%22%3A+%7B%22fundingOrganization%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22fundingOrganization.id_and_name%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientRegionName%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientRegionName%22%2C+%22size%22%3A+3%7D%7D%2C+%22currency%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22currency%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientDistrictName%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientDistrictName%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientOrganization%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientOrganization.id_and_name%22%2C+%22size%22%3A+3%7D%7D%7D%2C+%22query%22%3A+%7B%22bool%22%3A+%7B%22filter%22%3A+%5B%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%2C+%22must%22%3A+%7B%7D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%7B%22range%22%3A+%7B%22amountAwarded%22%3A+%7B%7D%7D%7D%2C+%22must%22%3A+%7B%7D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%5D%2C+%22must%22%3A+%7B%22query_string%22%3A+%7B%22default_field%22%3A+%22_all%22%2C+%22query%22%3A+%22awardDate%3A%5B2016-01-01+TO+2017-12-31%5D%22%7D%7D%7D%7D%2C+%22extra_context%22%3A+%7B%22amountAwardedFixed_facet_size%22%3A+3%2C+%22awardYear_facet_size%22%3A+3%7D%2C+%22sort%22%3A+%7B%22_score%22%3A+%7B%22order%22%3A+%22desc%22%7D%7D%7D'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Make a list of the columns I want to use in the data - only a small number are relevant for this exercise."
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"columns = [\n",
" \"Identifier\", \"Currency\", \"Amount Awarded\", \"Award Date\",\n",
" \"Recipient Org:Identifier\", \"Recipient Org:Name\", \n",
" \"Recipient Org:Charity Number\", \"Recipient Org:Company Number\",\n",
" \"Funding Org:Identifier\", \"Funding Org:Name\"\n",
"]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Then I use pandas to fetch the data. The `read_csv` method accepts an\n",
"`index_col` parameter which tells it which column to use as an index, while\n",
"passing our columns to `usecols` means only those columns will be returned.\n",
"\n",
"This can take a little while to run as it downloads a large amount of data."
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"grants = pd.read_csv(grantnav_url, index_col='Identifier', usecols=columns)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"I've added a dummy `Grants` variable with a value of 1 for each row. This\n",
"will help later when I want to count the number of grants."
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"grants.loc[:, \"Grants\"] = 1"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Some funders put their name with spaces at the end, so I need to get rid of them."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"grants.loc[:, \"Funding Org:Name\"] = grants[\"Funding Org:Name\"].str.strip()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Turn the date field into a date format."
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"grants.loc[:, \"Award Date\"] = grants[\"Award Date\"].astype('datetime64[ns]')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's take a look at the resulting data - first see how many rows there are:"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"60926"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(grants)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Then preview the list itself"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Currency</th>\n",
" <th>Amount Awarded</th>\n",
" <th>Award Date</th>\n",
" <th>Recipient Org:Identifier</th>\n",
" <th>Recipient Org:Name</th>\n",
" <th>Recipient Org:Charity Number</th>\n",
" <th>Recipient Org:Company Number</th>\n",
" <th>Funding Org:Identifier</th>\n",
" <th>Funding Org:Name</th>\n",
" <th>Grants</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Identifier</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>360G-SomersetCF-A397976</th>\n",
" <td>GBP</td>\n",
" <td>1470.00</td>\n",
" <td>2016-03-23</td>\n",
" <td>GB-CHC-1141319</td>\n",
" <td>Young People Frome</td>\n",
" <td>1141319</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A397978</th>\n",
" <td>GBP</td>\n",
" <td>2000.00</td>\n",
" <td>2016-04-04</td>\n",
" <td>GB-COH-09284683</td>\n",
" <td>GoCreate Taunton CIC</td>\n",
" <td>NaN</td>\n",
" <td>09284683</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A401718</th>\n",
" <td>GBP</td>\n",
" <td>2500.00</td>\n",
" <td>2016-06-24</td>\n",
" <td>360G-SomersetCF-ACC351246</td>\n",
" <td>St Francis Youth Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A404393</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2016-06-30</td>\n",
" <td>360G-SomersetCF-ACC763854</td>\n",
" <td>Yeovil &amp; Sherborne Hockey Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A404576</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2016-06-07</td>\n",
" <td>GB-CHC-270392</td>\n",
" <td>Ashill Village Hall Committee</td>\n",
" <td>270392</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A405480</th>\n",
" <td>GBP</td>\n",
" <td>9962.00</td>\n",
" <td>2016-06-14</td>\n",
" <td>GB-COH-04983733</td>\n",
" <td>Tone Leisure (South West) Ltd</td>\n",
" <td>1110756</td>\n",
" <td>04983733</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A405664</th>\n",
" <td>GBP</td>\n",
" <td>11000.00</td>\n",
" <td>2016-06-14</td>\n",
" <td>GB-CHC-305633</td>\n",
" <td>Blackdown District Scouts, Tangier Scout &amp; Gui...</td>\n",
" <td>305633</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A406072</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2016-06-30</td>\n",
" <td>360G-SomersetCF-ACC766126</td>\n",
" <td>Burnham United Junior Football Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A406345</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2016-06-01</td>\n",
" <td>360G-SomersetCF-ACC350213</td>\n",
" <td>Good Fellowship Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A407679</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2016-06-30</td>\n",
" <td>360G-SomersetCF-ACC768284</td>\n",
" <td>Axbridge Saxon Junior Football Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A459995</th>\n",
" <td>GBP</td>\n",
" <td>2000.00</td>\n",
" <td>2017-10-06</td>\n",
" <td>GB-COH-01182566</td>\n",
" <td>The Abbeyfield Burnham and Highbridge Society</td>\n",
" <td>268379</td>\n",
" <td>01182566</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A445077</th>\n",
" <td>GBP</td>\n",
" <td>800.00</td>\n",
" <td>2017-05-02</td>\n",
" <td>GB-CHC-272147</td>\n",
" <td>Fiddington Village Hall</td>\n",
" <td>272147</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A459193</th>\n",
" <td>GBP</td>\n",
" <td>1000.00</td>\n",
" <td>2017-11-07</td>\n",
" <td>360G-SomersetCF-ACC839459</td>\n",
" <td>Corfe Parish Council</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A437366</th>\n",
" <td>GBP</td>\n",
" <td>1000.00</td>\n",
" <td>2017-05-19</td>\n",
" <td>GB-CHC-1172434</td>\n",
" <td>Active and In Touch</td>\n",
" <td>1172434</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A445064</th>\n",
" <td>GBP</td>\n",
" <td>300.00</td>\n",
" <td>2017-05-02</td>\n",
" <td>360G-SomersetCF-ACC713790</td>\n",
" <td>Eastover Park Bowls Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A465216</th>\n",
" <td>GBP</td>\n",
" <td>750.00</td>\n",
" <td>2017-12-19</td>\n",
" <td>GB-CHC-1157281</td>\n",
" <td>Somewhere House Somerset</td>\n",
" <td>1157281</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A464030</th>\n",
" <td>GBP</td>\n",
" <td>1500.00</td>\n",
" <td>2017-12-15</td>\n",
" <td>GB-CHC-1174246</td>\n",
" <td>Somerset Time For Youth</td>\n",
" <td>1174246</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A454686</th>\n",
" <td>GBP</td>\n",
" <td>500.00</td>\n",
" <td>2017-08-23</td>\n",
" <td>GB-CHC-214779</td>\n",
" <td>The Salvation Army</td>\n",
" <td>214779</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A457657</th>\n",
" <td>GBP</td>\n",
" <td>960.00</td>\n",
" <td>2017-11-07</td>\n",
" <td>GB-COH-08658085</td>\n",
" <td>Taunton Theatre Association Ltd</td>\n",
" <td>1156472</td>\n",
" <td>08658085</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-SomersetCF-A462535</th>\n",
" <td>GBP</td>\n",
" <td>300.00</td>\n",
" <td>2017-11-29</td>\n",
" <td>360G-SomersetCF-ACC787881</td>\n",
" <td>The Orchard Social Club</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-COH-04530979</td>\n",
" <td>Somerset Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A459157</th>\n",
" <td>GBP</td>\n",
" <td>4440.00</td>\n",
" <td>2017-11-23</td>\n",
" <td>GB-CHC-1158251</td>\n",
" <td>Fallen Angels Dance Theatre North West</td>\n",
" <td>1158251</td>\n",
" <td>8909000</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A457088</th>\n",
" <td>GBP</td>\n",
" <td>2120.00</td>\n",
" <td>2017-11-23</td>\n",
" <td>360G-CheshireCF-Burtonwood_Sewing_Group</td>\n",
" <td>Burtonwood Sewing Group</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A459158</th>\n",
" <td>GBP</td>\n",
" <td>2369.56</td>\n",
" <td>2017-11-23</td>\n",
" <td>360G-CheshireCF-Neighbour_Favour</td>\n",
" <td>Neighbour Favour</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A459159</th>\n",
" <td>GBP</td>\n",
" <td>4896.00</td>\n",
" <td>2017-11-23</td>\n",
" <td>GB-CHC-1162587</td>\n",
" <td>Autism Inclusive</td>\n",
" <td>1162587</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A449450</th>\n",
" <td>GBP</td>\n",
" <td>3425.00</td>\n",
" <td>2017-11-08</td>\n",
" <td>360G-CheshireCF-Ethnic_Over_50's_Yoga_Group</td>\n",
" <td>Ethnic Over 50's Yoga Group</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A454210</th>\n",
" <td>GBP</td>\n",
" <td>9880.00</td>\n",
" <td>2017-08-10</td>\n",
" <td>GB-CHC-1081416</td>\n",
" <td>Just Drop-In</td>\n",
" <td>1081416</td>\n",
" <td>3884673</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A458178</th>\n",
" <td>GBP</td>\n",
" <td>4478.00</td>\n",
" <td>2017-11-03</td>\n",
" <td>GB-CHC-1107951</td>\n",
" <td>Visyon</td>\n",
" <td>1107951</td>\n",
" <td>5250758</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A447731</th>\n",
" <td>GBP</td>\n",
" <td>10000.00</td>\n",
" <td>2017-07-31</td>\n",
" <td>GB-CHC-1114000</td>\n",
" <td>The Joshua Tree</td>\n",
" <td>1114000</td>\n",
" <td>05654487</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A457356</th>\n",
" <td>GBP</td>\n",
" <td>11993.77</td>\n",
" <td>2017-11-30</td>\n",
" <td>GB-CHC-1075268</td>\n",
" <td>Carers Trust 4 All (formerly Crossroads Care C...</td>\n",
" <td>1075268</td>\n",
" <td>3554493</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-CheshireCF-A455809</th>\n",
" <td>GBP</td>\n",
" <td>2500.00</td>\n",
" <td>2017-11-30</td>\n",
" <td>GB-CHC-247343</td>\n",
" <td>Knutsford Abbeyfield Society Ltd</td>\n",
" <td>247343</td>\n",
" <td>850545</td>\n",
" <td>GB-CHC-1143711</td>\n",
" <td>Cheshire Community Foundation</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13616</th>\n",
" <td>GBP</td>\n",
" <td>40000.00</td>\n",
" <td>2016-11-08</td>\n",
" <td>GB-CHC-1152354</td>\n",
" <td>The Bike Project</td>\n",
" <td>1152354</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13630</th>\n",
" <td>GBP</td>\n",
" <td>50000.00</td>\n",
" <td>2016-11-08</td>\n",
" <td>GB-CHC-1124833</td>\n",
" <td>Mayor's Fund for London</td>\n",
" <td>1124833</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13295</th>\n",
" <td>GBP</td>\n",
" <td>87620.00</td>\n",
" <td>2016-09-22</td>\n",
" <td>GB-CHC-1154668</td>\n",
" <td>St Peter's Bethnal Green</td>\n",
" <td>1154668</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13349</th>\n",
" <td>GBP</td>\n",
" <td>100000.00</td>\n",
" <td>2016-09-22</td>\n",
" <td>GB-CHC-312160</td>\n",
" <td>South London Fine Art Gallery and Library</td>\n",
" <td>312160</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13384</th>\n",
" <td>GBP</td>\n",
" <td>100000.00</td>\n",
" <td>2016-09-22</td>\n",
" <td>GB-CHC-288370</td>\n",
" <td>Highbury Roundhouse Youth and Community Centre</td>\n",
" <td>288370</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13502</th>\n",
" <td>GBP</td>\n",
" <td>102000.00</td>\n",
" <td>2016-09-22</td>\n",
" <td>GB-CHC-1084211</td>\n",
" <td>Age UK Richmond Upon Thames</td>\n",
" <td>1084211</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13489</th>\n",
" <td>GBP</td>\n",
" <td>2400.00</td>\n",
" <td>2016-08-12</td>\n",
" <td>GB-CHC-326899</td>\n",
" <td>Age Exchange Theatre Trust</td>\n",
" <td>326899</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13266</th>\n",
" <td>GBP</td>\n",
" <td>90000.00</td>\n",
" <td>2016-07-14</td>\n",
" <td>GB-CHC-1148420</td>\n",
" <td>Spark Inside</td>\n",
" <td>1148420</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13228</th>\n",
" <td>GBP</td>\n",
" <td>142500.00</td>\n",
" <td>2016-07-14</td>\n",
" <td>GB-CHC-290118</td>\n",
" <td>The Brandon Centre</td>\n",
" <td>290118</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13369</th>\n",
" <td>GBP</td>\n",
" <td>90000.00</td>\n",
" <td>2016-07-14</td>\n",
" <td>GB-MPR-32202R</td>\n",
" <td>Sutton Community Farm</td>\n",
" <td>32202R</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13456</th>\n",
" <td>GBP</td>\n",
" <td>100560.00</td>\n",
" <td>2016-07-14</td>\n",
" <td>GB-CHC-1100214</td>\n",
" <td>Tender Education and Arts</td>\n",
" <td>1100214</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13353</th>\n",
" <td>GBP</td>\n",
" <td>5000.00</td>\n",
" <td>2016-06-30</td>\n",
" <td>GB-CHC-1100795</td>\n",
" <td>Memory Lane Singing Club</td>\n",
" <td>1100795</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13203</th>\n",
" <td>GBP</td>\n",
" <td>102400.00</td>\n",
" <td>2016-05-24</td>\n",
" <td>GB-CHC-1011668</td>\n",
" <td>Age Concern Brent</td>\n",
" <td>1011668</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13222</th>\n",
" <td>GBP</td>\n",
" <td>155400.00</td>\n",
" <td>2016-05-24</td>\n",
" <td>GB-CHC-1151243</td>\n",
" <td>Ealing Law Centre</td>\n",
" <td>1151243</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13246</th>\n",
" <td>GBP</td>\n",
" <td>112100.00</td>\n",
" <td>2016-05-24</td>\n",
" <td>GB-CHC-1116697</td>\n",
" <td>Sycamore Trust U.K.</td>\n",
" <td>1116697</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-12947</th>\n",
" <td>GBP</td>\n",
" <td>2600.00</td>\n",
" <td>2016-05-04</td>\n",
" <td>GB-CHC-287680</td>\n",
" <td>Islington Boat Club (IBC)</td>\n",
" <td>287680</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13264</th>\n",
" <td>GBP</td>\n",
" <td>2150.00</td>\n",
" <td>2016-03-24</td>\n",
" <td>GB-CHC-1081013</td>\n",
" <td>Age UK Croydon</td>\n",
" <td>1081013</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13116</th>\n",
" <td>GBP</td>\n",
" <td>50000.00</td>\n",
" <td>2016-03-21</td>\n",
" <td>GB-CHC-1096492</td>\n",
" <td>ReachOut</td>\n",
" <td>1096492</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13118</th>\n",
" <td>GBP</td>\n",
" <td>34500.00</td>\n",
" <td>2016-03-21</td>\n",
" <td>GB-CHC-1099782</td>\n",
" <td>Teens and Toddlers UK Ltd</td>\n",
" <td>1099782</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-12980</th>\n",
" <td>GBP</td>\n",
" <td>77000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-COH-07975254</td>\n",
" <td>Spectra</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-12984</th>\n",
" <td>GBP</td>\n",
" <td>135000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-1105625</td>\n",
" <td>Asylum Support Appeals Project</td>\n",
" <td>1105625</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13060</th>\n",
" <td>GBP</td>\n",
" <td>2000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>360G-citybridgetrust-8384</td>\n",
" <td>Tate Gallery</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13070</th>\n",
" <td>GBP</td>\n",
" <td>12000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-1140291</td>\n",
" <td>Hands on London</td>\n",
" <td>1140291</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13078</th>\n",
" <td>GBP</td>\n",
" <td>147400.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-296893</td>\n",
" <td>Lambeth and Southwark Mind</td>\n",
" <td>296893</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13126</th>\n",
" <td>GBP</td>\n",
" <td>50000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-1116147</td>\n",
" <td>Only Connect</td>\n",
" <td>1116147</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13194</th>\n",
" <td>GBP</td>\n",
" <td>135000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-1085541</td>\n",
" <td>Children and Families Across Borders</td>\n",
" <td>1085541</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13249</th>\n",
" <td>GBP</td>\n",
" <td>2000.00</td>\n",
" <td>2016-03-18</td>\n",
" <td>GB-CHC-231242</td>\n",
" <td>Royal Court Theatre</td>\n",
" <td>231242</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-12846</th>\n",
" <td>GBP</td>\n",
" <td>94100.00</td>\n",
" <td>2016-01-28</td>\n",
" <td>GB-CHC-1065829</td>\n",
" <td>Camden Arts Centre (CAC)</td>\n",
" <td>1065829</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13051</th>\n",
" <td>GBP</td>\n",
" <td>3600.00</td>\n",
" <td>2016-01-28</td>\n",
" <td>GB-CHC-1124475</td>\n",
" <td>Bethel - London's Riverside Church</td>\n",
" <td>1124475</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360G-citybridgetrust-13220</th>\n",
" <td>GBP</td>\n",
" <td>214000.00</td>\n",
" <td>2016-01-28</td>\n",
" <td>GB-CHC-801013</td>\n",
" <td>London's Air Ambulance Limited</td>\n",
" <td>801013</td>\n",
" <td>NaN</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>City Bridge Trust</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>60926 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" Currency Amount Awarded Award Date \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 GBP 1470.00 2016-03-23 \n",
"360G-SomersetCF-A397978 GBP 2000.00 2016-04-04 \n",
"360G-SomersetCF-A401718 GBP 2500.00 2016-06-24 \n",
"360G-SomersetCF-A404393 GBP 500.00 2016-06-30 \n",
"360G-SomersetCF-A404576 GBP 500.00 2016-06-07 \n",
"360G-SomersetCF-A405480 GBP 9962.00 2016-06-14 \n",
"360G-SomersetCF-A405664 GBP 11000.00 2016-06-14 \n",
"360G-SomersetCF-A406072 GBP 500.00 2016-06-30 \n",
"360G-SomersetCF-A406345 GBP 500.00 2016-06-01 \n",
"360G-SomersetCF-A407679 GBP 500.00 2016-06-30 \n",
"360G-SomersetCF-A459995 GBP 2000.00 2017-10-06 \n",
"360G-SomersetCF-A445077 GBP 800.00 2017-05-02 \n",
"360G-SomersetCF-A459193 GBP 1000.00 2017-11-07 \n",
"360G-SomersetCF-A437366 GBP 1000.00 2017-05-19 \n",
"360G-SomersetCF-A445064 GBP 300.00 2017-05-02 \n",
"360G-SomersetCF-A465216 GBP 750.00 2017-12-19 \n",
"360G-SomersetCF-A464030 GBP 1500.00 2017-12-15 \n",
"360G-SomersetCF-A454686 GBP 500.00 2017-08-23 \n",
"360G-SomersetCF-A457657 GBP 960.00 2017-11-07 \n",
"360G-SomersetCF-A462535 GBP 300.00 2017-11-29 \n",
"360G-CheshireCF-A459157 GBP 4440.00 2017-11-23 \n",
"360G-CheshireCF-A457088 GBP 2120.00 2017-11-23 \n",
"360G-CheshireCF-A459158 GBP 2369.56 2017-11-23 \n",
"360G-CheshireCF-A459159 GBP 4896.00 2017-11-23 \n",
"360G-CheshireCF-A449450 GBP 3425.00 2017-11-08 \n",
"360G-CheshireCF-A454210 GBP 9880.00 2017-08-10 \n",
"360G-CheshireCF-A458178 GBP 4478.00 2017-11-03 \n",
"360G-CheshireCF-A447731 GBP 10000.00 2017-07-31 \n",
"360G-CheshireCF-A457356 GBP 11993.77 2017-11-30 \n",
"360G-CheshireCF-A455809 GBP 2500.00 2017-11-30 \n",
"... ... ... ... \n",
"360G-citybridgetrust-13616 GBP 40000.00 2016-11-08 \n",
"360G-citybridgetrust-13630 GBP 50000.00 2016-11-08 \n",
"360G-citybridgetrust-13295 GBP 87620.00 2016-09-22 \n",
"360G-citybridgetrust-13349 GBP 100000.00 2016-09-22 \n",
"360G-citybridgetrust-13384 GBP 100000.00 2016-09-22 \n",
"360G-citybridgetrust-13502 GBP 102000.00 2016-09-22 \n",
"360G-citybridgetrust-13489 GBP 2400.00 2016-08-12 \n",
"360G-citybridgetrust-13266 GBP 90000.00 2016-07-14 \n",
"360G-citybridgetrust-13228 GBP 142500.00 2016-07-14 \n",
"360G-citybridgetrust-13369 GBP 90000.00 2016-07-14 \n",
"360G-citybridgetrust-13456 GBP 100560.00 2016-07-14 \n",
"360G-citybridgetrust-13353 GBP 5000.00 2016-06-30 \n",
"360G-citybridgetrust-13203 GBP 102400.00 2016-05-24 \n",
"360G-citybridgetrust-13222 GBP 155400.00 2016-05-24 \n",
"360G-citybridgetrust-13246 GBP 112100.00 2016-05-24 \n",
"360G-citybridgetrust-12947 GBP 2600.00 2016-05-04 \n",
"360G-citybridgetrust-13264 GBP 2150.00 2016-03-24 \n",
"360G-citybridgetrust-13116 GBP 50000.00 2016-03-21 \n",
"360G-citybridgetrust-13118 GBP 34500.00 2016-03-21 \n",
"360G-citybridgetrust-12980 GBP 77000.00 2016-03-18 \n",
"360G-citybridgetrust-12984 GBP 135000.00 2016-03-18 \n",
"360G-citybridgetrust-13060 GBP 2000.00 2016-03-18 \n",
"360G-citybridgetrust-13070 GBP 12000.00 2016-03-18 \n",
"360G-citybridgetrust-13078 GBP 147400.00 2016-03-18 \n",
"360G-citybridgetrust-13126 GBP 50000.00 2016-03-18 \n",
"360G-citybridgetrust-13194 GBP 135000.00 2016-03-18 \n",
"360G-citybridgetrust-13249 GBP 2000.00 2016-03-18 \n",
"360G-citybridgetrust-12846 GBP 94100.00 2016-01-28 \n",
"360G-citybridgetrust-13051 GBP 3600.00 2016-01-28 \n",
"360G-citybridgetrust-13220 GBP 214000.00 2016-01-28 \n",
"\n",
" Recipient Org:Identifier \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 GB-CHC-1141319 \n",
"360G-SomersetCF-A397978 GB-COH-09284683 \n",
"360G-SomersetCF-A401718 360G-SomersetCF-ACC351246 \n",
"360G-SomersetCF-A404393 360G-SomersetCF-ACC763854 \n",
"360G-SomersetCF-A404576 GB-CHC-270392 \n",
"360G-SomersetCF-A405480 GB-COH-04983733 \n",
"360G-SomersetCF-A405664 GB-CHC-305633 \n",
"360G-SomersetCF-A406072 360G-SomersetCF-ACC766126 \n",
"360G-SomersetCF-A406345 360G-SomersetCF-ACC350213 \n",
"360G-SomersetCF-A407679 360G-SomersetCF-ACC768284 \n",
"360G-SomersetCF-A459995 GB-COH-01182566 \n",
"360G-SomersetCF-A445077 GB-CHC-272147 \n",
"360G-SomersetCF-A459193 360G-SomersetCF-ACC839459 \n",
"360G-SomersetCF-A437366 GB-CHC-1172434 \n",
"360G-SomersetCF-A445064 360G-SomersetCF-ACC713790 \n",
"360G-SomersetCF-A465216 GB-CHC-1157281 \n",
"360G-SomersetCF-A464030 GB-CHC-1174246 \n",
"360G-SomersetCF-A454686 GB-CHC-214779 \n",
"360G-SomersetCF-A457657 GB-COH-08658085 \n",
"360G-SomersetCF-A462535 360G-SomersetCF-ACC787881 \n",
"360G-CheshireCF-A459157 GB-CHC-1158251 \n",
"360G-CheshireCF-A457088 360G-CheshireCF-Burtonwood_Sewing_Group \n",
"360G-CheshireCF-A459158 360G-CheshireCF-Neighbour_Favour \n",
"360G-CheshireCF-A459159 GB-CHC-1162587 \n",
"360G-CheshireCF-A449450 360G-CheshireCF-Ethnic_Over_50's_Yoga_Group \n",
"360G-CheshireCF-A454210 GB-CHC-1081416 \n",
"360G-CheshireCF-A458178 GB-CHC-1107951 \n",
"360G-CheshireCF-A447731 GB-CHC-1114000 \n",
"360G-CheshireCF-A457356 GB-CHC-1075268 \n",
"360G-CheshireCF-A455809 GB-CHC-247343 \n",
"... ... \n",
"360G-citybridgetrust-13616 GB-CHC-1152354 \n",
"360G-citybridgetrust-13630 GB-CHC-1124833 \n",
"360G-citybridgetrust-13295 GB-CHC-1154668 \n",
"360G-citybridgetrust-13349 GB-CHC-312160 \n",
"360G-citybridgetrust-13384 GB-CHC-288370 \n",
"360G-citybridgetrust-13502 GB-CHC-1084211 \n",
"360G-citybridgetrust-13489 GB-CHC-326899 \n",
"360G-citybridgetrust-13266 GB-CHC-1148420 \n",
"360G-citybridgetrust-13228 GB-CHC-290118 \n",
"360G-citybridgetrust-13369 GB-MPR-32202R \n",
"360G-citybridgetrust-13456 GB-CHC-1100214 \n",
"360G-citybridgetrust-13353 GB-CHC-1100795 \n",
"360G-citybridgetrust-13203 GB-CHC-1011668 \n",
"360G-citybridgetrust-13222 GB-CHC-1151243 \n",
"360G-citybridgetrust-13246 GB-CHC-1116697 \n",
"360G-citybridgetrust-12947 GB-CHC-287680 \n",
"360G-citybridgetrust-13264 GB-CHC-1081013 \n",
"360G-citybridgetrust-13116 GB-CHC-1096492 \n",
"360G-citybridgetrust-13118 GB-CHC-1099782 \n",
"360G-citybridgetrust-12980 GB-COH-07975254 \n",
"360G-citybridgetrust-12984 GB-CHC-1105625 \n",
"360G-citybridgetrust-13060 360G-citybridgetrust-8384 \n",
"360G-citybridgetrust-13070 GB-CHC-1140291 \n",
"360G-citybridgetrust-13078 GB-CHC-296893 \n",
"360G-citybridgetrust-13126 GB-CHC-1116147 \n",
"360G-citybridgetrust-13194 GB-CHC-1085541 \n",
"360G-citybridgetrust-13249 GB-CHC-231242 \n",
"360G-citybridgetrust-12846 GB-CHC-1065829 \n",
"360G-citybridgetrust-13051 GB-CHC-1124475 \n",
"360G-citybridgetrust-13220 GB-CHC-801013 \n",
"\n",
" Recipient Org:Name \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 Young People Frome \n",
"360G-SomersetCF-A397978 GoCreate Taunton CIC \n",
"360G-SomersetCF-A401718 St Francis Youth Club \n",
"360G-SomersetCF-A404393 Yeovil & Sherborne Hockey Club \n",
"360G-SomersetCF-A404576 Ashill Village Hall Committee \n",
"360G-SomersetCF-A405480 Tone Leisure (South West) Ltd \n",
"360G-SomersetCF-A405664 Blackdown District Scouts, Tangier Scout & Gui... \n",
"360G-SomersetCF-A406072 Burnham United Junior Football Club \n",
"360G-SomersetCF-A406345 Good Fellowship Club \n",
"360G-SomersetCF-A407679 Axbridge Saxon Junior Football Club \n",
"360G-SomersetCF-A459995 The Abbeyfield Burnham and Highbridge Society \n",
"360G-SomersetCF-A445077 Fiddington Village Hall \n",
"360G-SomersetCF-A459193 Corfe Parish Council \n",
"360G-SomersetCF-A437366 Active and In Touch \n",
"360G-SomersetCF-A445064 Eastover Park Bowls Club \n",
"360G-SomersetCF-A465216 Somewhere House Somerset \n",
"360G-SomersetCF-A464030 Somerset Time For Youth \n",
"360G-SomersetCF-A454686 The Salvation Army \n",
"360G-SomersetCF-A457657 Taunton Theatre Association Ltd \n",
"360G-SomersetCF-A462535 The Orchard Social Club \n",
"360G-CheshireCF-A459157 Fallen Angels Dance Theatre North West \n",
"360G-CheshireCF-A457088 Burtonwood Sewing Group \n",
"360G-CheshireCF-A459158 Neighbour Favour \n",
"360G-CheshireCF-A459159 Autism Inclusive \n",
"360G-CheshireCF-A449450 Ethnic Over 50's Yoga Group \n",
"360G-CheshireCF-A454210 Just Drop-In \n",
"360G-CheshireCF-A458178 Visyon \n",
"360G-CheshireCF-A447731 The Joshua Tree \n",
"360G-CheshireCF-A457356 Carers Trust 4 All (formerly Crossroads Care C... \n",
"360G-CheshireCF-A455809 Knutsford Abbeyfield Society Ltd \n",
"... ... \n",
"360G-citybridgetrust-13616 The Bike Project \n",
"360G-citybridgetrust-13630 Mayor's Fund for London \n",
"360G-citybridgetrust-13295 St Peter's Bethnal Green \n",
"360G-citybridgetrust-13349 South London Fine Art Gallery and Library \n",
"360G-citybridgetrust-13384 Highbury Roundhouse Youth and Community Centre \n",
"360G-citybridgetrust-13502 Age UK Richmond Upon Thames \n",
"360G-citybridgetrust-13489 Age Exchange Theatre Trust \n",
"360G-citybridgetrust-13266 Spark Inside \n",
"360G-citybridgetrust-13228 The Brandon Centre \n",
"360G-citybridgetrust-13369 Sutton Community Farm \n",
"360G-citybridgetrust-13456 Tender Education and Arts \n",
"360G-citybridgetrust-13353 Memory Lane Singing Club \n",
"360G-citybridgetrust-13203 Age Concern Brent \n",
"360G-citybridgetrust-13222 Ealing Law Centre \n",
"360G-citybridgetrust-13246 Sycamore Trust U.K. \n",
"360G-citybridgetrust-12947 Islington Boat Club (IBC) \n",
"360G-citybridgetrust-13264 Age UK Croydon \n",
"360G-citybridgetrust-13116 ReachOut \n",
"360G-citybridgetrust-13118 Teens and Toddlers UK Ltd \n",
"360G-citybridgetrust-12980 Spectra \n",
"360G-citybridgetrust-12984 Asylum Support Appeals Project \n",
"360G-citybridgetrust-13060 Tate Gallery \n",
"360G-citybridgetrust-13070 Hands on London \n",
"360G-citybridgetrust-13078 Lambeth and Southwark Mind \n",
"360G-citybridgetrust-13126 Only Connect \n",
"360G-citybridgetrust-13194 Children and Families Across Borders \n",
"360G-citybridgetrust-13249 Royal Court Theatre \n",
"360G-citybridgetrust-12846 Camden Arts Centre (CAC) \n",
"360G-citybridgetrust-13051 Bethel - London's Riverside Church \n",
"360G-citybridgetrust-13220 London's Air Ambulance Limited \n",
"\n",
" Recipient Org:Charity Number \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 1141319 \n",
"360G-SomersetCF-A397978 NaN \n",
"360G-SomersetCF-A401718 NaN \n",
"360G-SomersetCF-A404393 NaN \n",
"360G-SomersetCF-A404576 270392 \n",
"360G-SomersetCF-A405480 1110756 \n",
"360G-SomersetCF-A405664 305633 \n",
"360G-SomersetCF-A406072 NaN \n",
"360G-SomersetCF-A406345 NaN \n",
"360G-SomersetCF-A407679 NaN \n",
"360G-SomersetCF-A459995 268379 \n",
"360G-SomersetCF-A445077 272147 \n",
"360G-SomersetCF-A459193 NaN \n",
"360G-SomersetCF-A437366 1172434 \n",
"360G-SomersetCF-A445064 NaN \n",
"360G-SomersetCF-A465216 1157281 \n",
"360G-SomersetCF-A464030 1174246 \n",
"360G-SomersetCF-A454686 214779 \n",
"360G-SomersetCF-A457657 1156472 \n",
"360G-SomersetCF-A462535 NaN \n",
"360G-CheshireCF-A459157 1158251 \n",
"360G-CheshireCF-A457088 NaN \n",
"360G-CheshireCF-A459158 NaN \n",
"360G-CheshireCF-A459159 1162587 \n",
"360G-CheshireCF-A449450 NaN \n",
"360G-CheshireCF-A454210 1081416 \n",
"360G-CheshireCF-A458178 1107951 \n",
"360G-CheshireCF-A447731 1114000 \n",
"360G-CheshireCF-A457356 1075268 \n",
"360G-CheshireCF-A455809 247343 \n",
"... ... \n",
"360G-citybridgetrust-13616 1152354 \n",
"360G-citybridgetrust-13630 1124833 \n",
"360G-citybridgetrust-13295 1154668 \n",
"360G-citybridgetrust-13349 312160 \n",
"360G-citybridgetrust-13384 288370 \n",
"360G-citybridgetrust-13502 1084211 \n",
"360G-citybridgetrust-13489 326899 \n",
"360G-citybridgetrust-13266 1148420 \n",
"360G-citybridgetrust-13228 290118 \n",
"360G-citybridgetrust-13369 32202R \n",
"360G-citybridgetrust-13456 1100214 \n",
"360G-citybridgetrust-13353 1100795 \n",
"360G-citybridgetrust-13203 1011668 \n",
"360G-citybridgetrust-13222 1151243 \n",
"360G-citybridgetrust-13246 1116697 \n",
"360G-citybridgetrust-12947 287680 \n",
"360G-citybridgetrust-13264 1081013 \n",
"360G-citybridgetrust-13116 1096492 \n",
"360G-citybridgetrust-13118 1099782 \n",
"360G-citybridgetrust-12980 NaN \n",
"360G-citybridgetrust-12984 1105625 \n",
"360G-citybridgetrust-13060 NaN \n",
"360G-citybridgetrust-13070 1140291 \n",
"360G-citybridgetrust-13078 296893 \n",
"360G-citybridgetrust-13126 1116147 \n",
"360G-citybridgetrust-13194 1085541 \n",
"360G-citybridgetrust-13249 231242 \n",
"360G-citybridgetrust-12846 1065829 \n",
"360G-citybridgetrust-13051 1124475 \n",
"360G-citybridgetrust-13220 801013 \n",
"\n",
" Recipient Org:Company Number \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 NaN \n",
"360G-SomersetCF-A397978 09284683 \n",
"360G-SomersetCF-A401718 NaN \n",
"360G-SomersetCF-A404393 NaN \n",
"360G-SomersetCF-A404576 NaN \n",
"360G-SomersetCF-A405480 04983733 \n",
"360G-SomersetCF-A405664 NaN \n",
"360G-SomersetCF-A406072 NaN \n",
"360G-SomersetCF-A406345 NaN \n",
"360G-SomersetCF-A407679 NaN \n",
"360G-SomersetCF-A459995 01182566 \n",
"360G-SomersetCF-A445077 NaN \n",
"360G-SomersetCF-A459193 NaN \n",
"360G-SomersetCF-A437366 NaN \n",
"360G-SomersetCF-A445064 NaN \n",
"360G-SomersetCF-A465216 NaN \n",
"360G-SomersetCF-A464030 NaN \n",
"360G-SomersetCF-A454686 NaN \n",
"360G-SomersetCF-A457657 08658085 \n",
"360G-SomersetCF-A462535 NaN \n",
"360G-CheshireCF-A459157 8909000 \n",
"360G-CheshireCF-A457088 NaN \n",
"360G-CheshireCF-A459158 NaN \n",
"360G-CheshireCF-A459159 NaN \n",
"360G-CheshireCF-A449450 NaN \n",
"360G-CheshireCF-A454210 3884673 \n",
"360G-CheshireCF-A458178 5250758 \n",
"360G-CheshireCF-A447731 05654487 \n",
"360G-CheshireCF-A457356 3554493 \n",
"360G-CheshireCF-A455809 850545 \n",
"... ... \n",
"360G-citybridgetrust-13616 NaN \n",
"360G-citybridgetrust-13630 NaN \n",
"360G-citybridgetrust-13295 NaN \n",
"360G-citybridgetrust-13349 NaN \n",
"360G-citybridgetrust-13384 NaN \n",
"360G-citybridgetrust-13502 NaN \n",
"360G-citybridgetrust-13489 NaN \n",
"360G-citybridgetrust-13266 NaN \n",
"360G-citybridgetrust-13228 NaN \n",
"360G-citybridgetrust-13369 NaN \n",
"360G-citybridgetrust-13456 NaN \n",
"360G-citybridgetrust-13353 NaN \n",
"360G-citybridgetrust-13203 NaN \n",
"360G-citybridgetrust-13222 NaN \n",
"360G-citybridgetrust-13246 NaN \n",
"360G-citybridgetrust-12947 NaN \n",
"360G-citybridgetrust-13264 NaN \n",
"360G-citybridgetrust-13116 NaN \n",
"360G-citybridgetrust-13118 NaN \n",
"360G-citybridgetrust-12980 NaN \n",
"360G-citybridgetrust-12984 NaN \n",
"360G-citybridgetrust-13060 NaN \n",
"360G-citybridgetrust-13070 NaN \n",
"360G-citybridgetrust-13078 NaN \n",
"360G-citybridgetrust-13126 NaN \n",
"360G-citybridgetrust-13194 NaN \n",
"360G-citybridgetrust-13249 NaN \n",
"360G-citybridgetrust-12846 NaN \n",
"360G-citybridgetrust-13051 NaN \n",
"360G-citybridgetrust-13220 NaN \n",
"\n",
" Funding Org:Identifier \\\n",
"Identifier \n",
"360G-SomersetCF-A397976 GB-COH-04530979 \n",
"360G-SomersetCF-A397978 GB-COH-04530979 \n",
"360G-SomersetCF-A401718 GB-COH-04530979 \n",
"360G-SomersetCF-A404393 GB-COH-04530979 \n",
"360G-SomersetCF-A404576 GB-COH-04530979 \n",
"360G-SomersetCF-A405480 GB-COH-04530979 \n",
"360G-SomersetCF-A405664 GB-COH-04530979 \n",
"360G-SomersetCF-A406072 GB-COH-04530979 \n",
"360G-SomersetCF-A406345 GB-COH-04530979 \n",
"360G-SomersetCF-A407679 GB-COH-04530979 \n",
"360G-SomersetCF-A459995 GB-COH-04530979 \n",
"360G-SomersetCF-A445077 GB-COH-04530979 \n",
"360G-SomersetCF-A459193 GB-COH-04530979 \n",
"360G-SomersetCF-A437366 GB-COH-04530979 \n",
"360G-SomersetCF-A445064 GB-COH-04530979 \n",
"360G-SomersetCF-A465216 GB-COH-04530979 \n",
"360G-SomersetCF-A464030 GB-COH-04530979 \n",
"360G-SomersetCF-A454686 GB-COH-04530979 \n",
"360G-SomersetCF-A457657 GB-COH-04530979 \n",
"360G-SomersetCF-A462535 GB-COH-04530979 \n",
"360G-CheshireCF-A459157 GB-CHC-1143711 \n",
"360G-CheshireCF-A457088 GB-CHC-1143711 \n",
"360G-CheshireCF-A459158 GB-CHC-1143711 \n",
"360G-CheshireCF-A459159 GB-CHC-1143711 \n",
"360G-CheshireCF-A449450 GB-CHC-1143711 \n",
"360G-CheshireCF-A454210 GB-CHC-1143711 \n",
"360G-CheshireCF-A458178 GB-CHC-1143711 \n",
"360G-CheshireCF-A447731 GB-CHC-1143711 \n",
"360G-CheshireCF-A457356 GB-CHC-1143711 \n",
"360G-CheshireCF-A455809 GB-CHC-1143711 \n",
"... ... \n",
"360G-citybridgetrust-13616 GB-CHC-1035628 \n",
"360G-citybridgetrust-13630 GB-CHC-1035628 \n",
"360G-citybridgetrust-13295 GB-CHC-1035628 \n",
"360G-citybridgetrust-13349 GB-CHC-1035628 \n",
"360G-citybridgetrust-13384 GB-CHC-1035628 \n",
"360G-citybridgetrust-13502 GB-CHC-1035628 \n",
"360G-citybridgetrust-13489 GB-CHC-1035628 \n",
"360G-citybridgetrust-13266 GB-CHC-1035628 \n",
"360G-citybridgetrust-13228 GB-CHC-1035628 \n",
"360G-citybridgetrust-13369 GB-CHC-1035628 \n",
"360G-citybridgetrust-13456 GB-CHC-1035628 \n",
"360G-citybridgetrust-13353 GB-CHC-1035628 \n",
"360G-citybridgetrust-13203 GB-CHC-1035628 \n",
"360G-citybridgetrust-13222 GB-CHC-1035628 \n",
"360G-citybridgetrust-13246 GB-CHC-1035628 \n",
"360G-citybridgetrust-12947 GB-CHC-1035628 \n",
"360G-citybridgetrust-13264 GB-CHC-1035628 \n",
"360G-citybridgetrust-13116 GB-CHC-1035628 \n",
"360G-citybridgetrust-13118 GB-CHC-1035628 \n",
"360G-citybridgetrust-12980 GB-CHC-1035628 \n",
"360G-citybridgetrust-12984 GB-CHC-1035628 \n",
"360G-citybridgetrust-13060 GB-CHC-1035628 \n",
"360G-citybridgetrust-13070 GB-CHC-1035628 \n",
"360G-citybridgetrust-13078 GB-CHC-1035628 \n",
"360G-citybridgetrust-13126 GB-CHC-1035628 \n",
"360G-citybridgetrust-13194 GB-CHC-1035628 \n",
"360G-citybridgetrust-13249 GB-CHC-1035628 \n",
"360G-citybridgetrust-12846 GB-CHC-1035628 \n",
"360G-citybridgetrust-13051 GB-CHC-1035628 \n",
"360G-citybridgetrust-13220 GB-CHC-1035628 \n",
"\n",
" Funding Org:Name Grants \n",
"Identifier \n",
"360G-SomersetCF-A397976 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A397978 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A401718 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A404393 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A404576 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A405480 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A405664 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A406072 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A406345 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A407679 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A459995 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A445077 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A459193 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A437366 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A445064 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A465216 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A464030 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A454686 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A457657 Somerset Community Foundation 1 \n",
"360G-SomersetCF-A462535 Somerset Community Foundation 1 \n",
"360G-CheshireCF-A459157 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A457088 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A459158 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A459159 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A449450 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A454210 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A458178 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A447731 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A457356 Cheshire Community Foundation 1 \n",
"360G-CheshireCF-A455809 Cheshire Community Foundation 1 \n",
"... ... ... \n",
"360G-citybridgetrust-13616 City Bridge Trust 1 \n",
"360G-citybridgetrust-13630 City Bridge Trust 1 \n",
"360G-citybridgetrust-13295 City Bridge Trust 1 \n",
"360G-citybridgetrust-13349 City Bridge Trust 1 \n",
"360G-citybridgetrust-13384 City Bridge Trust 1 \n",
"360G-citybridgetrust-13502 City Bridge Trust 1 \n",
"360G-citybridgetrust-13489 City Bridge Trust 1 \n",
"360G-citybridgetrust-13266 City Bridge Trust 1 \n",
"360G-citybridgetrust-13228 City Bridge Trust 1 \n",
"360G-citybridgetrust-13369 City Bridge Trust 1 \n",
"360G-citybridgetrust-13456 City Bridge Trust 1 \n",
"360G-citybridgetrust-13353 City Bridge Trust 1 \n",
"360G-citybridgetrust-13203 City Bridge Trust 1 \n",
"360G-citybridgetrust-13222 City Bridge Trust 1 \n",
"360G-citybridgetrust-13246 City Bridge Trust 1 \n",
"360G-citybridgetrust-12947 City Bridge Trust 1 \n",
"360G-citybridgetrust-13264 City Bridge Trust 1 \n",
"360G-citybridgetrust-13116 City Bridge Trust 1 \n",
"360G-citybridgetrust-13118 City Bridge Trust 1 \n",
"360G-citybridgetrust-12980 City Bridge Trust 1 \n",
"360G-citybridgetrust-12984 City Bridge Trust 1 \n",
"360G-citybridgetrust-13060 City Bridge Trust 1 \n",
"360G-citybridgetrust-13070 City Bridge Trust 1 \n",
"360G-citybridgetrust-13078 City Bridge Trust 1 \n",
"360G-citybridgetrust-13126 City Bridge Trust 1 \n",
"360G-citybridgetrust-13194 City Bridge Trust 1 \n",
"360G-citybridgetrust-13249 City Bridge Trust 1 \n",
"360G-citybridgetrust-12846 City Bridge Trust 1 \n",
"360G-citybridgetrust-13051 City Bridge Trust 1 \n",
"360G-citybridgetrust-13220 City Bridge Trust 1 \n",
"\n",
"[60926 rows x 10 columns]"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"grants"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Save the data to a pickle so we can use it later"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"grants.to_pickle('grants.pkl')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 2. Transform into a new format"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"I might want to filter the data before plotting it, so it's useful to copy to\n",
"a new variable to keep the original `grants` variable as is. \n",
"\n",
"In this case I've filtered to only include grants in 2017."
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Using 31,290 grants\n"
]
}
],
"source": [
"to_use = grants[grants[\"Award Date\"].dt.year == 2017]\n",
"print(\"Using {:,.0f} grants\".format(len(to_use)))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"I create a table showing links between funders and recipients.\n",
"This has one row per funding relationship, from Funder > Recipient. \n",
"I've added some columns showing the number of grants made by each \n",
"funder to the recipient and the value of those grants.\n",
"\n",
"To do this I use the `groupby` pandas function to group, and then\n",
"`sum` to pick up the amount and number of grants. I've reset the index\n",
"to make it easier to use the table later on."
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"scrolled": true
},
"outputs": [],
"source": [
"links = to_use.groupby(\n",
" [\"Recipient Org:Identifier\", \"Funding Org:Identifier\"]\n",
").sum()[[\"Amount Awarded\", \"Grants\"]].reset_index()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"I only want to use links including recipients that have received\n",
"grants from more than one funder, to limit the size of the network\n",
"diagram. \n",
"\n",
"To do this I've used the `value_counts()` function to get a list\n",
"of unique recipients and how many relationships they occur in."
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"24,976 unique recipients\n"
]
}
],
"source": [
"link_recipients = links[\"Recipient Org:Identifier\"].value_counts()\n",
"print(\"{:,.0f} unique recipients\".format(len(link_recipients)))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Then I filter this list to include only those links where the\n",
"recipient appears more than once."
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [],
"source": [
"links = links[links[\"Recipient Org:Identifier\"].isin(link_recipients[link_recipients>1].index)]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We also add in the names of the funders to help with the data."
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [],
"source": [
"links = links.join(grants.groupby(\"Funding Org:Identifier\").first()[\"Funding Org:Name\"], on=\"Funding Org:Identifier\")"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"2,316 unique recipients with more than one funder in the period\n"
]
}
],
"source": [
"print(\"{:,.0f} unique recipients with more than one funder in the period\".format(len(links[\"Recipient Org:Identifier\"].value_counts())))"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Recipient Org:Identifier</th>\n",
" <th>Funding Org:Identifier</th>\n",
" <th>Amount Awarded</th>\n",
" <th>Grants</th>\n",
" <th>Funding Org:Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>7985</th>\n",
" <td>360G-trafford-theatre_of_the_senses</td>\n",
" <td>GB-COH-04831118</td>\n",
" <td>467.00</td>\n",
" <td>1</td>\n",
" <td>Trafford Housing Trust Social Investment</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7986</th>\n",
" <td>360G-trafford-theatre_of_the_senses</td>\n",
" <td>GB-LAE-TRF</td>\n",
" <td>1720.00</td>\n",
" <td>1</td>\n",
" <td>Trafford Metropolitan Borough Council</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8067</th>\n",
" <td>GB-CHC-1000011</td>\n",
" <td>360G-blf</td>\n",
" <td>8348.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8068</th>\n",
" <td>GB-CHC-1000011</td>\n",
" <td>GB-CHC-226446</td>\n",
" <td>39296.00</td>\n",
" <td>2</td>\n",
" <td>Seafarers UK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8075</th>\n",
" <td>GB-CHC-1000340</td>\n",
" <td>360G-blf</td>\n",
" <td>464600.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8076</th>\n",
" <td>GB-CHC-1000340</td>\n",
" <td>GB-CHC-230260</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>Garfield Weston Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8077</th>\n",
" <td>GB-CHC-1000351</td>\n",
" <td>360G-blf</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8078</th>\n",
" <td>GB-CHC-1000351</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>3162.39</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8092</th>\n",
" <td>GB-CHC-1000714</td>\n",
" <td>360G-blf</td>\n",
" <td>9920.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8093</th>\n",
" <td>GB-CHC-1000714</td>\n",
" <td>GB-CHC-230260</td>\n",
" <td>5000.00</td>\n",
" <td>1</td>\n",
" <td>Garfield Weston Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8097</th>\n",
" <td>GB-CHC-1000799</td>\n",
" <td>GB-CHC-1081124</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>Tuixen Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8098</th>\n",
" <td>GB-CHC-1000799</td>\n",
" <td>GB-CHC-1089893</td>\n",
" <td>31800.00</td>\n",
" <td>1</td>\n",
" <td>True Colours Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8102</th>\n",
" <td>GB-CHC-1001067</td>\n",
" <td>360G-blf</td>\n",
" <td>30000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8103</th>\n",
" <td>GB-CHC-1001067</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>3447.61</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8112</th>\n",
" <td>GB-CHC-1001633</td>\n",
" <td>360G-blf</td>\n",
" <td>9024.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8113</th>\n",
" <td>GB-CHC-1001633</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>1531.39</td>\n",
" <td>2</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8128</th>\n",
" <td>GB-CHC-1002294</td>\n",
" <td>360G-blf</td>\n",
" <td>815974.00</td>\n",
" <td>2</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8129</th>\n",
" <td>GB-CHC-1002294</td>\n",
" <td>GB-CHC-230102</td>\n",
" <td>98500.00</td>\n",
" <td>1</td>\n",
" <td>The Henry Smith Charity</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8143</th>\n",
" <td>GB-CHC-1002721</td>\n",
" <td>360G-blf</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8144</th>\n",
" <td>GB-CHC-1002721</td>\n",
" <td>GB-CHC-1111600</td>\n",
" <td>12104.00</td>\n",
" <td>2</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8145</th>\n",
" <td>GB-CHC-1002721</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>2784.10</td>\n",
" <td>2</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8158</th>\n",
" <td>GB-CHC-1003113</td>\n",
" <td>GB-CHC-1035628</td>\n",
" <td>42500.00</td>\n",
" <td>1</td>\n",
" <td>City Bridge Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8159</th>\n",
" <td>GB-CHC-1003113</td>\n",
" <td>GB-CHC-274100</td>\n",
" <td>4500.00</td>\n",
" <td>1</td>\n",
" <td>The Clothworkers Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8168</th>\n",
" <td>GB-CHC-1003342</td>\n",
" <td>GB-CHC-1000147</td>\n",
" <td>20000.00</td>\n",
" <td>1</td>\n",
" <td>A B Charitable Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8169</th>\n",
" <td>GB-CHC-1003342</td>\n",
" <td>GB-CHC-205629</td>\n",
" <td>1962.00</td>\n",
" <td>1</td>\n",
" <td>Trust for London</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8178</th>\n",
" <td>GB-CHC-1003603</td>\n",
" <td>GB-CHC-230260</td>\n",
" <td>6500.00</td>\n",
" <td>1</td>\n",
" <td>Garfield Weston Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8179</th>\n",
" <td>GB-CHC-1003603</td>\n",
" <td>GB-CHC-327114</td>\n",
" <td>58224.00</td>\n",
" <td>1</td>\n",
" <td>Lloyds Bank Foundation for England and Wales</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8194</th>\n",
" <td>GB-CHC-1004110</td>\n",
" <td>360G-blf</td>\n",
" <td>9978.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8195</th>\n",
" <td>GB-CHC-1004110</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>695.59</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8196</th>\n",
" <td>GB-CHC-1004132</td>\n",
" <td>360G-blf</td>\n",
" <td>474457.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27588</th>\n",
" <td>GB-SC-SC045906</td>\n",
" <td>GB-SC-SC009481</td>\n",
" <td>2470.00</td>\n",
" <td>1</td>\n",
" <td>Corra Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27605</th>\n",
" <td>GB-SC-SC046060</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>3582.55</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27606</th>\n",
" <td>GB-SC-SC046060</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>34500.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27607</th>\n",
" <td>GB-SC-SC046064</td>\n",
" <td>360G-blf</td>\n",
" <td>860000.00</td>\n",
" <td>2</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27608</th>\n",
" <td>GB-SC-SC046064</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>180000.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27613</th>\n",
" <td>GB-SC-SC046113</td>\n",
" <td>360G-blf</td>\n",
" <td>9670.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27614</th>\n",
" <td>GB-SC-SC046113</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>2728.63</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27633</th>\n",
" <td>GB-SC-SC046297</td>\n",
" <td>GB-SC-SC009481</td>\n",
" <td>5500.00</td>\n",
" <td>1</td>\n",
" <td>Corra Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27634</th>\n",
" <td>GB-SC-SC046297</td>\n",
" <td>GB-SC-SC012710</td>\n",
" <td>30000.00</td>\n",
" <td>1</td>\n",
" <td>R S Macdonald Charitable Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27656</th>\n",
" <td>GB-SC-SC046483</td>\n",
" <td>360G-blf</td>\n",
" <td>6750.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27657</th>\n",
" <td>GB-SC-SC046483</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>2812.13</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27661</th>\n",
" <td>GB-SC-SC046501</td>\n",
" <td>360G-blf</td>\n",
" <td>8335.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27662</th>\n",
" <td>GB-SC-SC046501</td>\n",
" <td>GB-CHC-274100</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Clothworkers Foundation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27663</th>\n",
" <td>GB-SC-SC046501</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>45000.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27666</th>\n",
" <td>GB-SC-SC046513</td>\n",
" <td>360G-blf</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27667</th>\n",
" <td>GB-SC-SC046513</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>9000.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27676</th>\n",
" <td>GB-SC-SC046602</td>\n",
" <td>360G-blf</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27677</th>\n",
" <td>GB-SC-SC046602</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>6000.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27689</th>\n",
" <td>GB-SC-SC046713</td>\n",
" <td>360G-blf</td>\n",
" <td>6092.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27690</th>\n",
" <td>GB-SC-SC046713</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>1975.33</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27693</th>\n",
" <td>GB-SC-SC046738</td>\n",
" <td>360G-blf</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27694</th>\n",
" <td>GB-SC-SC046738</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>40500.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27701</th>\n",
" <td>GB-SC-SC046833</td>\n",
" <td>360G-blf</td>\n",
" <td>8880.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27702</th>\n",
" <td>GB-SC-SC046833</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>13500.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27714</th>\n",
" <td>GB-SC-SC046975</td>\n",
" <td>GB-COH-IP00525R</td>\n",
" <td>1705.23</td>\n",
" <td>1</td>\n",
" <td>Co-operative Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27715</th>\n",
" <td>GB-SC-SC046975</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>15000.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27731</th>\n",
" <td>GB-SC-SC047121</td>\n",
" <td>360G-blf</td>\n",
" <td>9961.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27732</th>\n",
" <td>GB-SC-SC047121</td>\n",
" <td>GB-SC-SC002970</td>\n",
" <td>22500.00</td>\n",
" <td>1</td>\n",
" <td>The Robertson Trust</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27795</th>\n",
" <td>GB-SC-SCO27712</td>\n",
" <td>360G-blf</td>\n",
" <td>8236.00</td>\n",
" <td>1</td>\n",
" <td>The Big Lottery Fund</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27796</th>\n",
" <td>GB-SC-SCO27712</td>\n",
" <td>GB-SC-SC009481</td>\n",
" <td>3300.00</td>\n",
" <td>1</td>\n",
" <td>Corra Foundation</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5200 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" Recipient Org:Identifier Funding Org:Identifier \\\n",
"7985 360G-trafford-theatre_of_the_senses GB-COH-04831118 \n",
"7986 360G-trafford-theatre_of_the_senses GB-LAE-TRF \n",
"8067 GB-CHC-1000011 360G-blf \n",
"8068 GB-CHC-1000011 GB-CHC-226446 \n",
"8075 GB-CHC-1000340 360G-blf \n",
"8076 GB-CHC-1000340 GB-CHC-230260 \n",
"8077 GB-CHC-1000351 360G-blf \n",
"8078 GB-CHC-1000351 GB-COH-IP00525R \n",
"8092 GB-CHC-1000714 360G-blf \n",
"8093 GB-CHC-1000714 GB-CHC-230260 \n",
"8097 GB-CHC-1000799 GB-CHC-1081124 \n",
"8098 GB-CHC-1000799 GB-CHC-1089893 \n",
"8102 GB-CHC-1001067 360G-blf \n",
"8103 GB-CHC-1001067 GB-COH-IP00525R \n",
"8112 GB-CHC-1001633 360G-blf \n",
"8113 GB-CHC-1001633 GB-COH-IP00525R \n",
"8128 GB-CHC-1002294 360G-blf \n",
"8129 GB-CHC-1002294 GB-CHC-230102 \n",
"8143 GB-CHC-1002721 360G-blf \n",
"8144 GB-CHC-1002721 GB-CHC-1111600 \n",
"8145 GB-CHC-1002721 GB-COH-IP00525R \n",
"8158 GB-CHC-1003113 GB-CHC-1035628 \n",
"8159 GB-CHC-1003113 GB-CHC-274100 \n",
"8168 GB-CHC-1003342 GB-CHC-1000147 \n",
"8169 GB-CHC-1003342 GB-CHC-205629 \n",
"8178 GB-CHC-1003603 GB-CHC-230260 \n",
"8179 GB-CHC-1003603 GB-CHC-327114 \n",
"8194 GB-CHC-1004110 360G-blf \n",
"8195 GB-CHC-1004110 GB-COH-IP00525R \n",
"8196 GB-CHC-1004132 360G-blf \n",
"... ... ... \n",
"27588 GB-SC-SC045906 GB-SC-SC009481 \n",
"27605 GB-SC-SC046060 GB-COH-IP00525R \n",
"27606 GB-SC-SC046060 GB-SC-SC002970 \n",
"27607 GB-SC-SC046064 360G-blf \n",
"27608 GB-SC-SC046064 GB-SC-SC002970 \n",
"27613 GB-SC-SC046113 360G-blf \n",
"27614 GB-SC-SC046113 GB-COH-IP00525R \n",
"27633 GB-SC-SC046297 GB-SC-SC009481 \n",
"27634 GB-SC-SC046297 GB-SC-SC012710 \n",
"27656 GB-SC-SC046483 360G-blf \n",
"27657 GB-SC-SC046483 GB-COH-IP00525R \n",
"27661 GB-SC-SC046501 360G-blf \n",
"27662 GB-SC-SC046501 GB-CHC-274100 \n",
"27663 GB-SC-SC046501 GB-SC-SC002970 \n",
"27666 GB-SC-SC046513 360G-blf \n",
"27667 GB-SC-SC046513 GB-SC-SC002970 \n",
"27676 GB-SC-SC046602 360G-blf \n",
"27677 GB-SC-SC046602 GB-SC-SC002970 \n",
"27689 GB-SC-SC046713 360G-blf \n",
"27690 GB-SC-SC046713 GB-COH-IP00525R \n",
"27693 GB-SC-SC046738 360G-blf \n",
"27694 GB-SC-SC046738 GB-SC-SC002970 \n",
"27701 GB-SC-SC046833 360G-blf \n",
"27702 GB-SC-SC046833 GB-SC-SC002970 \n",
"27714 GB-SC-SC046975 GB-COH-IP00525R \n",
"27715 GB-SC-SC046975 GB-SC-SC002970 \n",
"27731 GB-SC-SC047121 360G-blf \n",
"27732 GB-SC-SC047121 GB-SC-SC002970 \n",
"27795 GB-SC-SCO27712 360G-blf \n",
"27796 GB-SC-SCO27712 GB-SC-SC009481 \n",
"\n",
" Amount Awarded Grants Funding Org:Name \n",
"7985 467.00 1 Trafford Housing Trust Social Investment \n",
"7986 1720.00 1 Trafford Metropolitan Borough Council \n",
"8067 8348.00 1 The Big Lottery Fund \n",
"8068 39296.00 2 Seafarers UK \n",
"8075 464600.00 1 The Big Lottery Fund \n",
"8076 10000.00 1 Garfield Weston Foundation \n",
"8077 10000.00 1 The Big Lottery Fund \n",
"8078 3162.39 1 Co-operative Group \n",
"8092 9920.00 1 The Big Lottery Fund \n",
"8093 5000.00 1 Garfield Weston Foundation \n",
"8097 10000.00 1 Tuixen Foundation \n",
"8098 31800.00 1 True Colours Trust \n",
"8102 30000.00 1 The Big Lottery Fund \n",
"8103 3447.61 1 Co-operative Group \n",
"8112 9024.00 1 The Big Lottery Fund \n",
"8113 1531.39 2 Co-operative Group \n",
"8128 815974.00 2 The Big Lottery Fund \n",
"8129 98500.00 1 The Henry Smith Charity \n",
"8143 10000.00 1 The Big Lottery Fund \n",
"8144 12104.00 2 Community Foundation for Surrey \n",
"8145 2784.10 2 Co-operative Group \n",
"8158 42500.00 1 City Bridge Trust \n",
"8159 4500.00 1 The Clothworkers Foundation \n",
"8168 20000.00 1 A B Charitable Trust \n",
"8169 1962.00 1 Trust for London \n",
"8178 6500.00 1 Garfield Weston Foundation \n",
"8179 58224.00 1 Lloyds Bank Foundation for England and Wales \n",
"8194 9978.00 1 The Big Lottery Fund \n",
"8195 695.59 1 Co-operative Group \n",
"8196 474457.00 1 The Big Lottery Fund \n",
"... ... ... ... \n",
"27588 2470.00 1 Corra Foundation \n",
"27605 3582.55 1 Co-operative Group \n",
"27606 34500.00 1 The Robertson Trust \n",
"27607 860000.00 2 The Big Lottery Fund \n",
"27608 180000.00 1 The Robertson Trust \n",
"27613 9670.00 1 The Big Lottery Fund \n",
"27614 2728.63 1 Co-operative Group \n",
"27633 5500.00 1 Corra Foundation \n",
"27634 30000.00 1 R S Macdonald Charitable Trust \n",
"27656 6750.00 1 The Big Lottery Fund \n",
"27657 2812.13 1 Co-operative Group \n",
"27661 8335.00 1 The Big Lottery Fund \n",
"27662 10000.00 1 The Clothworkers Foundation \n",
"27663 45000.00 1 The Robertson Trust \n",
"27666 10000.00 1 The Big Lottery Fund \n",
"27667 9000.00 1 The Robertson Trust \n",
"27676 10000.00 1 The Big Lottery Fund \n",
"27677 6000.00 1 The Robertson Trust \n",
"27689 6092.00 1 The Big Lottery Fund \n",
"27690 1975.33 1 Co-operative Group \n",
"27693 10000.00 1 The Big Lottery Fund \n",
"27694 40500.00 1 The Robertson Trust \n",
"27701 8880.00 1 The Big Lottery Fund \n",
"27702 13500.00 1 The Robertson Trust \n",
"27714 1705.23 1 Co-operative Group \n",
"27715 15000.00 1 The Robertson Trust \n",
"27731 9961.00 1 The Big Lottery Fund \n",
"27732 22500.00 1 The Robertson Trust \n",
"27795 8236.00 1 The Big Lottery Fund \n",
"27796 3300.00 1 Corra Foundation \n",
"\n",
"[5200 rows x 5 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"links"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Create Chord output\n",
"\n",
"The next step is to turn the links into a table with the number \n",
"of recipients that pairs of funders have in common.\n",
"\n",
"First I get a list of the funders in the dataset."
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"funders = links[\"Funding Org:Name\"].unique()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Then go through each funder and get a list of the recipients of the funder,\n",
"and which other funders have funded them."
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"funder_rels = {}\n",
"# go through all the funders\n",
"for f in funders:\n",
" \n",
" # a list of the recipients of this funder\n",
" recipients = links.loc[\n",
" links[\"Funding Org:Name\"]==f, \n",
" \"Recipient Org:Identifier\"].unique()\n",
" \n",
" # get a list of all the other funders that have funded those recipients\n",
" funder_rels[f] = pd.DataFrame(links.loc[\n",
" links[\"Recipient Org:Identifier\"].isin(recipients) & (links[\"Funding Org:Name\"]!=f),\n",
" \"Funding Org:Name\"\n",
" ].value_counts().rename(\"grants\"))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Turn into a list of funder > funder relationships."
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [],
"source": [
"funder_rels = pd.concat(funder_rels, names=[\"Funder from\", \"Funder to\"])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Save to a CSV file."
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [],
"source": [
"funder_rels.to_csv(\"chord.csv\")"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"This CSV file is in the right format to use in a [Flourish chord diagram](https://app.flourish.studio/@flourish/chord-diagram)."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Create stats\n",
"\n",
"We want to find out:\n",
"\n",
"- for each funder, what proportion of recipients are found in other funders\n",
"- what the average grant size is for the funder"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Recipient Org:Identifier</th>\n",
" <th>Funding Org:Name</th>\n",
" <th>Amount Awarded</th>\n",
" <th>Grants</th>\n",
" <th>funder_count</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>360G-ArcadiaFund:ORG-University-of-Hamburg</td>\n",
" <td>ARCADIA</td>\n",
" <td>2000000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>360G-BarnetCouncil-ORG:1st-3rd-New-Barnet-Scou...</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>5000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>360G-BarnetCouncil-ORG:Barnet-Bowls-Club</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>5000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>360G-BarnetCouncil-ORG:Finchley-Horticultural-...</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>4950.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>360G-BarnetCouncil-ORG:Mill-Hill-Neighbourhood...</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>750.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>360G-BarnetCouncil-ORG:Stonegrove-Estates-Yout...</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>2405.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>360G-BarnetCouncil-ORG:The-Hope-Of-Childs-Hill</td>\n",
" <td>London Borough of Barnet</td>\n",
" <td>5000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>360G-BirminghamCC-acocks_green_nhood_forum</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>800.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>360G-BirminghamCC-bham_neighbourhood_forum</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>610.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>360G-BirminghamCC-boldmere_neighbourhood_forum</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>700.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>360G-BirminghamCC-cherry_club</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>250.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>360G-BirminghamCC-creative_cohesion_west_midlands</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>6000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>360G-BirminghamCC-grange_park_digby_north_res_...</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>4166.50</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>360G-BirminghamCC-longbridge_methodist_church_dc</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>1618.50</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>360G-BirminghamCC-loudeemy_productions</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>5660.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>360G-BirminghamCC-momentum</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>11823.75</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>360G-BirminghamCC-sparkhill_gurdwara_womens_group</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>250.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>360G-BirminghamCC-the_green_club</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>750.00</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>360G-BirminghamCC-urc_sutton_coldfield_cafe_oasis</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>620.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>360G-BirminghamCC-work_in_progress</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>20000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>360G-BirminghamCC-wylde_green_neighbourhood_forum</td>\n",
" <td>Birmingham City Council</td>\n",
" <td>500.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>360G-CFSurrey-ACC276268</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>3000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>360G-CFSurrey-ACC276287</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>1000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>360G-CFSurrey-ACC276424</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>1200.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>360G-CFSurrey-ACC276425</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>1800.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>360G-CFSurrey-ACC276719</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>200.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>360G-CFSurrey-ACC276721</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>1000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>360G-CFSurrey-ACC276722</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>900.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>360G-CFSurrey-ACC277312</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>2500.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>360G-CFSurrey-ACC277333</td>\n",
" <td>Community Foundation for Surrey</td>\n",
" <td>1000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27830</th>\n",
" <td>IM-GR-1192</td>\n",
" <td>Co-operative Group</td>\n",
" <td>1421.97</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27831</th>\n",
" <td>IM-GR-799</td>\n",
" <td>Co-operative Group</td>\n",
" <td>1446.28</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27832</th>\n",
" <td>IM-GR-954</td>\n",
" <td>Masonic Charitable Foundation</td>\n",
" <td>4000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27833</th>\n",
" <td>SCVO-001b000000SsxHjAAJ</td>\n",
" <td>Scottish Council For Voluntary Organisations</td>\n",
" <td>7379.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27834</th>\n",
" <td>SCVO-001b000000SsxdjAAB-r3-strand-1</td>\n",
" <td>Scottish Council For Voluntary Organisations</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27835</th>\n",
" <td>SCVO-001b000000rtNWpAAM-r3-strand-2</td>\n",
" <td>Scottish Council For Voluntary Organisations</td>\n",
" <td>9930.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27836</th>\n",
" <td>SCVO-001b000003Xu8glAAB-r3-strand-2</td>\n",
" <td>Scottish Council For Voluntary Organisations</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27837</th>\n",
" <td>US-EIN-04-2103580N</td>\n",
" <td>ARCADIA</td>\n",
" <td>200000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27838</th>\n",
" <td>US-EIN-06-0646973</td>\n",
" <td>ARCADIA</td>\n",
" <td>30178000.00</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27839</th>\n",
" <td>US-EIN-13-1851145</td>\n",
" <td>ARCADIA</td>\n",
" <td>2000000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27840</th>\n",
" <td>US-EIN-13-1887440</td>\n",
" <td>ARCADIA</td>\n",
" <td>400000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27841</th>\n",
" <td>US-EIN-20-0049703</td>\n",
" <td>ARCADIA</td>\n",
" <td>1250000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27842</th>\n",
" <td>US-EIN-20-1286572</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>30000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27843</th>\n",
" <td>US-EIN-237065131</td>\n",
" <td>Seafarers UK</td>\n",
" <td>10000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27844</th>\n",
" <td>US-EIN-32-0105791</td>\n",
" <td>ARCADIA</td>\n",
" <td>2241088.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27845</th>\n",
" <td>US-EIN-52-1014754</td>\n",
" <td>Quartet Community Foundation</td>\n",
" <td>4163.89</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27846</th>\n",
" <td>US-EIN-68-0245471</td>\n",
" <td>ARCADIA</td>\n",
" <td>3000000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27847</th>\n",
" <td>US-EIN-84-1648607</td>\n",
" <td>ZING</td>\n",
" <td>50000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27848</th>\n",
" <td>US-EIN-94-3242767</td>\n",
" <td>ARCADIA</td>\n",
" <td>50000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27849</th>\n",
" <td>US-EIN-94-6002123</td>\n",
" <td>ARCADIA</td>\n",
" <td>200000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27850</th>\n",
" <td>US-EIN-95-2250801</td>\n",
" <td>ARCADIA</td>\n",
" <td>200000.00</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27851</th>\n",
" <td>ZA-NPO-032-082</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>33903.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27852</th>\n",
" <td>ZA-NPO-055-382</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>24350.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27853</th>\n",
" <td>ZA-NPO-068-288</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>28252.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27854</th>\n",
" <td>ZA-NPO-077-530</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>25000.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27855</th>\n",
" <td>ZA-NPO-095-260</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>25427.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27856</th>\n",
" <td>ZA-NPO-137-245</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>150228.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27857</th>\n",
" <td>ZA-NPO-174-938</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>25427.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27858</th>\n",
" <td>ZA-PBO-070000190</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>113380.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27859</th>\n",
" <td>ZA-PBO-930050535</td>\n",
" <td>The David &amp; Elaine Potter Foundation</td>\n",
" <td>20089.00</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>27860 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" Recipient Org:Identifier \\\n",
"0 360G-ArcadiaFund:ORG-University-of-Hamburg \n",
"1 360G-BarnetCouncil-ORG:1st-3rd-New-Barnet-Scou... \n",
"2 360G-BarnetCouncil-ORG:Barnet-Bowls-Club \n",
"3 360G-BarnetCouncil-ORG:Finchley-Horticultural-... \n",
"4 360G-BarnetCouncil-ORG:Mill-Hill-Neighbourhood... \n",
"5 360G-BarnetCouncil-ORG:Stonegrove-Estates-Yout... \n",
"6 360G-BarnetCouncil-ORG:The-Hope-Of-Childs-Hill \n",
"7 360G-BirminghamCC-acocks_green_nhood_forum \n",
"8 360G-BirminghamCC-bham_neighbourhood_forum \n",
"9 360G-BirminghamCC-boldmere_neighbourhood_forum \n",
"10 360G-BirminghamCC-cherry_club \n",
"11 360G-BirminghamCC-creative_cohesion_west_midlands \n",
"12 360G-BirminghamCC-grange_park_digby_north_res_... \n",
"13 360G-BirminghamCC-longbridge_methodist_church_dc \n",
"14 360G-BirminghamCC-loudeemy_productions \n",
"15 360G-BirminghamCC-momentum \n",
"16 360G-BirminghamCC-sparkhill_gurdwara_womens_group \n",
"17 360G-BirminghamCC-the_green_club \n",
"18 360G-BirminghamCC-urc_sutton_coldfield_cafe_oasis \n",
"19 360G-BirminghamCC-work_in_progress \n",
"20 360G-BirminghamCC-wylde_green_neighbourhood_forum \n",
"21 360G-CFSurrey-ACC276268 \n",
"22 360G-CFSurrey-ACC276287 \n",
"23 360G-CFSurrey-ACC276424 \n",
"24 360G-CFSurrey-ACC276425 \n",
"25 360G-CFSurrey-ACC276719 \n",
"26 360G-CFSurrey-ACC276721 \n",
"27 360G-CFSurrey-ACC276722 \n",
"28 360G-CFSurrey-ACC277312 \n",
"29 360G-CFSurrey-ACC277333 \n",
"... ... \n",
"27830 IM-GR-1192 \n",
"27831 IM-GR-799 \n",
"27832 IM-GR-954 \n",
"27833 SCVO-001b000000SsxHjAAJ \n",
"27834 SCVO-001b000000SsxdjAAB-r3-strand-1 \n",
"27835 SCVO-001b000000rtNWpAAM-r3-strand-2 \n",
"27836 SCVO-001b000003Xu8glAAB-r3-strand-2 \n",
"27837 US-EIN-04-2103580N \n",
"27838 US-EIN-06-0646973 \n",
"27839 US-EIN-13-1851145 \n",
"27840 US-EIN-13-1887440 \n",
"27841 US-EIN-20-0049703 \n",
"27842 US-EIN-20-1286572 \n",
"27843 US-EIN-237065131 \n",
"27844 US-EIN-32-0105791 \n",
"27845 US-EIN-52-1014754 \n",
"27846 US-EIN-68-0245471 \n",
"27847 US-EIN-84-1648607 \n",
"27848 US-EIN-94-3242767 \n",
"27849 US-EIN-94-6002123 \n",
"27850 US-EIN-95-2250801 \n",
"27851 ZA-NPO-032-082 \n",
"27852 ZA-NPO-055-382 \n",
"27853 ZA-NPO-068-288 \n",
"27854 ZA-NPO-077-530 \n",
"27855 ZA-NPO-095-260 \n",
"27856 ZA-NPO-137-245 \n",
"27857 ZA-NPO-174-938 \n",
"27858 ZA-PBO-070000190 \n",
"27859 ZA-PBO-930050535 \n",
"\n",
" Funding Org:Name Amount Awarded Grants \\\n",
"0 ARCADIA 2000000.00 1 \n",
"1 London Borough of Barnet 5000.00 1 \n",
"2 London Borough of Barnet 5000.00 1 \n",
"3 London Borough of Barnet 4950.00 1 \n",
"4 London Borough of Barnet 750.00 1 \n",
"5 London Borough of Barnet 2405.00 1 \n",
"6 London Borough of Barnet 5000.00 2 \n",
"7 Birmingham City Council 800.00 1 \n",
"8 Birmingham City Council 610.00 2 \n",
"9 Birmingham City Council 700.00 1 \n",
"10 Birmingham City Council 250.00 1 \n",
"11 Birmingham City Council 6000.00 1 \n",
"12 Birmingham City Council 4166.50 1 \n",
"13 Birmingham City Council 1618.50 1 \n",
"14 Birmingham City Council 5660.00 1 \n",
"15 Birmingham City Council 11823.75 1 \n",
"16 Birmingham City Council 250.00 1 \n",
"17 Birmingham City Council 750.00 3 \n",
"18 Birmingham City Council 620.00 1 \n",
"19 Birmingham City Council 20000.00 1 \n",
"20 Birmingham City Council 500.00 1 \n",
"21 Community Foundation for Surrey 3000.00 2 \n",
"22 Community Foundation for Surrey 1000.00 1 \n",
"23 Community Foundation for Surrey 1200.00 1 \n",
"24 Community Foundation for Surrey 1800.00 1 \n",
"25 Community Foundation for Surrey 200.00 1 \n",
"26 Community Foundation for Surrey 1000.00 1 \n",
"27 Community Foundation for Surrey 900.00 2 \n",
"28 Community Foundation for Surrey 2500.00 1 \n",
"29 Community Foundation for Surrey 1000.00 1 \n",
"... ... ... ... \n",
"27830 Co-operative Group 1421.97 1 \n",
"27831 Co-operative Group 1446.28 1 \n",
"27832 Masonic Charitable Foundation 4000.00 1 \n",
"27833 Scottish Council For Voluntary Organisations 7379.00 1 \n",
"27834 Scottish Council For Voluntary Organisations 10000.00 1 \n",
"27835 Scottish Council For Voluntary Organisations 9930.00 1 \n",
"27836 Scottish Council For Voluntary Organisations 10000.00 1 \n",
"27837 ARCADIA 200000.00 2 \n",
"27838 ARCADIA 30178000.00 4 \n",
"27839 ARCADIA 2000000.00 1 \n",
"27840 ARCADIA 400000.00 2 \n",
"27841 ARCADIA 1250000.00 1 \n",
"27842 The David & Elaine Potter Foundation 30000.00 1 \n",
"27843 Seafarers UK 10000.00 1 \n",
"27844 ARCADIA 2241088.00 1 \n",
"27845 Quartet Community Foundation 4163.89 1 \n",
"27846 ARCADIA 3000000.00 1 \n",
"27847 ZING 50000.00 1 \n",
"27848 ARCADIA 50000.00 1 \n",
"27849 ARCADIA 200000.00 2 \n",
"27850 ARCADIA 200000.00 2 \n",
"27851 The David & Elaine Potter Foundation 33903.00 1 \n",
"27852 The David & Elaine Potter Foundation 24350.00 1 \n",
"27853 The David & Elaine Potter Foundation 28252.00 1 \n",
"27854 The David & Elaine Potter Foundation 25000.00 1 \n",
"27855 The David & Elaine Potter Foundation 25427.00 1 \n",
"27856 The David & Elaine Potter Foundation 150228.00 1 \n",
"27857 The David & Elaine Potter Foundation 25427.00 1 \n",
"27858 The David & Elaine Potter Foundation 113380.00 1 \n",
"27859 The David & Elaine Potter Foundation 20089.00 1 \n",
"\n",
" funder_count \n",
"0 1 \n",
"1 1 \n",
"2 1 \n",
"3 1 \n",
"4 1 \n",
"5 1 \n",
"6 1 \n",
"7 1 \n",
"8 1 \n",
"9 1 \n",
"10 1 \n",
"11 1 \n",
"12 1 \n",
"13 1 \n",
"14 1 \n",
"15 1 \n",
"16 1 \n",
"17 1 \n",
"18 1 \n",
"19 1 \n",
"20 1 \n",
"21 1 \n",
"22 1 \n",
"23 1 \n",
"24 1 \n",
"25 1 \n",
"26 1 \n",
"27 1 \n",
"28 1 \n",
"29 1 \n",
"... ... \n",
"27830 1 \n",
"27831 1 \n",
"27832 1 \n",
"27833 1 \n",
"27834 1 \n",
"27835 1 \n",
"27836 1 \n",
"27837 1 \n",
"27838 1 \n",
"27839 1 \n",
"27840 1 \n",
"27841 1 \n",
"27842 1 \n",
"27843 1 \n",
"27844 1 \n",
"27845 1 \n",
"27846 1 \n",
"27847 1 \n",
"27848 1 \n",
"27849 1 \n",
"27850 1 \n",
"27851 1 \n",
"27852 1 \n",
"27853 1 \n",
"27854 1 \n",
"27855 1 \n",
"27856 1 \n",
"27857 1 \n",
"27858 1 \n",
"27859 1 \n",
"\n",
"[27860 rows x 5 columns]"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"funder_count = to_use.groupby(\n",
" [\"Recipient Org:Identifier\", \"Funding Org:Name\"]\n",
").sum()[\n",
" [\"Amount Awarded\", \"Grants\"]\n",
"].reset_index().join(\n",
" link_recipients.rename('funder_count'), on='Recipient Org:Identifier'\n",
")\n",
"funder_count"
]
},
{
"cell_type": "code",
"execution_count": 55,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Funding Org:Name</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>The Big Lottery Fund</th>\n",
" <td>12.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Co-operative Group</th>\n",
" <td>14.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Garfield Weston Foundation</th>\n",
" <td>38.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sport England</th>\n",
" <td>6.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Quartet Community Foundation</th>\n",
" <td>16.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Robertson Trust</th>\n",
" <td>38.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Heart Of England Community Foundation</th>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Tudor Trust</th>\n",
" <td>48.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyds Bank Foundation for England and Wales</th>\n",
" <td>58.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation serving Tyne &amp; Wear and Northumberland</th>\n",
" <td>20.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation for Surrey</th>\n",
" <td>10.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Essex Community Foundation</th>\n",
" <td>16.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Esmée Fairbairn Foundation</th>\n",
" <td>34.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sussex Community Foundation</th>\n",
" <td>18.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Clothworkers Foundation</th>\n",
" <td>55.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Somerset Community Foundation</th>\n",
" <td>15.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Corra Foundation</th>\n",
" <td>53.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Wellcome Trust</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Woodward Charitable Trust</th>\n",
" <td>41.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>National Churches Trust</th>\n",
" <td>9.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Two Ridings Community Foundation</th>\n",
" <td>15.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oxfordshire Community Foundation</th>\n",
" <td>13.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Devon Community Foundation</th>\n",
" <td>18.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>City Bridge Trust</th>\n",
" <td>55.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>London Catalyst</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trust for London</th>\n",
" <td>47.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Comic Relief</th>\n",
" <td>14.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cheshire Community Foundation</th>\n",
" <td>32.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nesta</th>\n",
" <td>10.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Henry Smith Charity</th>\n",
" <td>50.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tuixen Foundation</th>\n",
" <td>53.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The David &amp; Elaine Potter Foundation</th>\n",
" <td>15.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virgin Money Foundation</th>\n",
" <td>45.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Joseph Rowntree Foundation</th>\n",
" <td>26.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lankelly Chase Foundation</th>\n",
" <td>23.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>London Borough of Barnet</th>\n",
" <td>27.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Glasgow City Council</th>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Three Guineas Trust</th>\n",
" <td>37.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Road Safety Trust</th>\n",
" <td>17.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Dunhill Medical Trust</th>\n",
" <td>66.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tedworth Charitable Trust</th>\n",
" <td>55.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wiltshire Community Foundation</th>\n",
" <td>45.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyd's Register Foundation</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Staples Trust</th>\n",
" <td>37.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ARCADIA</th>\n",
" <td>12.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Samworth Foundation</th>\n",
" <td>37.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Quixote Foundation</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>London Councils</th>\n",
" <td>76.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Blagrave Trust</th>\n",
" <td>61.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Dundee City Council</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Macc</th>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Gatsby Charitable Foundation</th>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Stockport MBC</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Culham St Gabriel's Trust</th>\n",
" <td>40.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ZING</th>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Department for Transport</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ministry of Justice</th>\n",
" <td>66.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Millfield House Foundation</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nationwide Foundation</th>\n",
" <td>50.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Power to Change</th>\n",
" <td>0.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>81 rows × 1 columns</p>\n",
"</div>"
],
"text/plain": [
" 0\n",
"Funding Org:Name \n",
"The Big Lottery Fund 12.2\n",
"Co-operative Group 14.7\n",
"Garfield Weston Foundation 38.5\n",
"Sport England 6.7\n",
"Quartet Community Foundation 16.9\n",
"The Robertson Trust 38.5\n",
"Heart Of England Community Foundation 20.0\n",
"The Tudor Trust 48.0\n",
"Lloyds Bank Foundation for England and Wales 58.6\n",
"Community Foundation serving Tyne & Wear and No... 20.1\n",
"Community Foundation for Surrey 10.8\n",
"Essex Community Foundation 16.8\n",
"Esmée Fairbairn Foundation 34.2\n",
"Sussex Community Foundation 18.4\n",
"The Clothworkers Foundation 55.4\n",
"Somerset Community Foundation 15.9\n",
"Corra Foundation 53.0\n",
"The Wellcome Trust 0.0\n",
"Woodward Charitable Trust 41.9\n",
"National Churches Trust 9.1\n",
"Two Ridings Community Foundation 15.9\n",
"Oxfordshire Community Foundation 13.9\n",
"Devon Community Foundation 18.9\n",
"City Bridge Trust 55.8\n",
"London Catalyst 0.0\n",
"Trust for London 47.1\n",
"Comic Relief 14.9\n",
"Cheshire Community Foundation 32.7\n",
"Nesta 10.8\n",
"The Henry Smith Charity 50.0\n",
"... ...\n",
"Tuixen Foundation 53.1\n",
"The David & Elaine Potter Foundation 15.6\n",
"Virgin Money Foundation 45.2\n",
"Joseph Rowntree Foundation 26.7\n",
"Lankelly Chase Foundation 23.3\n",
"London Borough of Barnet 27.6\n",
"Glasgow City Council 25.0\n",
"Three Guineas Trust 37.5\n",
"Road Safety Trust 17.4\n",
"The Dunhill Medical Trust 66.7\n",
"Tedworth Charitable Trust 55.0\n",
"Wiltshire Community Foundation 45.0\n",
"Lloyd's Register Foundation 0.0\n",
"Staples Trust 37.5\n",
"ARCADIA 12.5\n",
"Samworth Foundation 37.5\n",
"Quixote Foundation 0.0\n",
"London Councils 76.9\n",
"The Blagrave Trust 61.5\n",
"Dundee City Council 0.0\n",
"Macc 25.0\n",
"Gatsby Charitable Foundation 20.0\n",
"Stockport MBC 0.0\n",
"Culham St Gabriel's Trust 40.0\n",
"ZING 20.0\n",
"Department for Transport 0.0\n",
"Ministry of Justice 66.7\n",
"Millfield House Foundation 0.0\n",
"Nationwide Foundation 50.0\n",
"Power to Change 0.0\n",
"\n",
"[81 rows x 1 columns]"
]
},
"execution_count": 55,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"link_count = pd.crosstab(\n",
" funder_count['Funding Org:Name'],\n",
" funder_count['funder_count'],\n",
" margins=True\n",
").sort_values(\n",
" by='All', ascending=False\n",
").drop('All')\n",
"pd.DataFrame((1-(link_count[1] / link_count['All'])).multiply(100).round(1))"
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>funder_count</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>All</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Funding Org:Name</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>A B Charitable Trust</th>\n",
" <td>13000.0</td>\n",
" <td>13400.0</td>\n",
" <td>12344.0</td>\n",
" <td>14667.0</td>\n",
" <td>15000.0</td>\n",
" <td>0.0</td>\n",
" <td>13147.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ARCADIA</th>\n",
" <td>2322464.0</td>\n",
" <td>16581364.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3463176.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Barrow Cadbury Trust</th>\n",
" <td>44969.0</td>\n",
" <td>34350.0</td>\n",
" <td>44762.0</td>\n",
" <td>91500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>43859.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Birmingham City Council</th>\n",
" <td>13472.0</td>\n",
" <td>10367.0</td>\n",
" <td>0.0</td>\n",
" <td>22699.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>13285.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Calouste Gulbenkian Foundation, UK Branch</th>\n",
" <td>33627.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>33627.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cheshire Community Foundation</th>\n",
" <td>5293.0</td>\n",
" <td>6386.0</td>\n",
" <td>5295.0</td>\n",
" <td>7135.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5622.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>City Bridge Trust</th>\n",
" <td>71616.0</td>\n",
" <td>102108.0</td>\n",
" <td>79198.0</td>\n",
" <td>100975.0</td>\n",
" <td>0.0</td>\n",
" <td>87900.0</td>\n",
" <td>84614.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Co-operative Group</th>\n",
" <td>2424.0</td>\n",
" <td>2756.0</td>\n",
" <td>3601.0</td>\n",
" <td>2743.0</td>\n",
" <td>3294.0</td>\n",
" <td>2500.0</td>\n",
" <td>2506.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Comic Relief</th>\n",
" <td>274863.0</td>\n",
" <td>90133.0</td>\n",
" <td>97250.0</td>\n",
" <td>62410.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>247159.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation for Surrey</th>\n",
" <td>3081.0</td>\n",
" <td>4313.0</td>\n",
" <td>5383.0</td>\n",
" <td>7500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3305.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation serving Tyne &amp; Wear and Northumberland</th>\n",
" <td>3559.0</td>\n",
" <td>5006.0</td>\n",
" <td>6733.0</td>\n",
" <td>5264.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3964.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Corra Foundation</th>\n",
" <td>8428.0</td>\n",
" <td>7254.0</td>\n",
" <td>4957.0</td>\n",
" <td>22011.0</td>\n",
" <td>5000.0</td>\n",
" <td>0.0</td>\n",
" <td>8454.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Culham St Gabriel's Trust</th>\n",
" <td>17433.0</td>\n",
" <td>14000.0</td>\n",
" <td>0.0</td>\n",
" <td>7000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>14660.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Department for Transport</th>\n",
" <td>15514.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>15514.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Devon Community Foundation</th>\n",
" <td>5632.0</td>\n",
" <td>2898.0</td>\n",
" <td>2094.0</td>\n",
" <td>1000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5079.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Dundee City Council</th>\n",
" <td>6994.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6994.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Esmée Fairbairn Foundation</th>\n",
" <td>151346.0</td>\n",
" <td>136096.0</td>\n",
" <td>180794.0</td>\n",
" <td>111930.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>149991.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Essex Community Foundation</th>\n",
" <td>5828.0</td>\n",
" <td>7255.0</td>\n",
" <td>5772.0</td>\n",
" <td>2815.0</td>\n",
" <td>0.0</td>\n",
" <td>3000.0</td>\n",
" <td>5974.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Garfield Weston Foundation</th>\n",
" <td>33834.0</td>\n",
" <td>22302.0</td>\n",
" <td>17470.0</td>\n",
" <td>24633.0</td>\n",
" <td>23750.0</td>\n",
" <td>9333.0</td>\n",
" <td>28931.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Gatsby Charitable Foundation</th>\n",
" <td>577265.0</td>\n",
" <td>452001.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>113000.0</td>\n",
" <td>512646.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Glasgow City Council</th>\n",
" <td>17068.0</td>\n",
" <td>19381.0</td>\n",
" <td>15300.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>17125.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Greater London Authority</th>\n",
" <td>449410.0</td>\n",
" <td>51123.0</td>\n",
" <td>23192.0</td>\n",
" <td>8000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>312384.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Heart Of England Community Foundation</th>\n",
" <td>2887.0</td>\n",
" <td>2361.0</td>\n",
" <td>2917.0</td>\n",
" <td>2658.0</td>\n",
" <td>2000.0</td>\n",
" <td>0.0</td>\n",
" <td>2782.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indigo Trust</th>\n",
" <td>29570.0</td>\n",
" <td>17250.0</td>\n",
" <td>23500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>27168.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>John Moores Foundation</th>\n",
" <td>6092.0</td>\n",
" <td>9440.0</td>\n",
" <td>5237.0</td>\n",
" <td>6400.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6585.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Joseph Rowntree Charitable Trust</th>\n",
" <td>72214.0</td>\n",
" <td>57399.0</td>\n",
" <td>86688.0</td>\n",
" <td>55676.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>71479.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Joseph Rowntree Foundation</th>\n",
" <td>4603.0</td>\n",
" <td>6040.0</td>\n",
" <td>4975.0</td>\n",
" <td>600.0</td>\n",
" <td>4500.0</td>\n",
" <td>6333.0</td>\n",
" <td>4728.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lankelly Chase Foundation</th>\n",
" <td>116020.0</td>\n",
" <td>46342.0</td>\n",
" <td>15800.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>97230.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyd's Register Foundation</th>\n",
" <td>1347982.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1347982.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyds Bank Foundation for England and Wales</th>\n",
" <td>50922.0</td>\n",
" <td>47231.0</td>\n",
" <td>56663.0</td>\n",
" <td>39541.0</td>\n",
" <td>75000.0</td>\n",
" <td>66540.0</td>\n",
" <td>50130.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sport England</th>\n",
" <td>182184.0</td>\n",
" <td>49741.0</td>\n",
" <td>25869.0</td>\n",
" <td>60764.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>173523.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Staples Trust</th>\n",
" <td>15100.0</td>\n",
" <td>5000.0</td>\n",
" <td>3800.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>10559.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Stockport MBC</th>\n",
" <td>4060.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4060.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sussex Community Foundation</th>\n",
" <td>4149.0</td>\n",
" <td>3765.0</td>\n",
" <td>4827.0</td>\n",
" <td>5097.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4140.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tedworth Charitable Trust</th>\n",
" <td>13644.0</td>\n",
" <td>7000.0</td>\n",
" <td>14900.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>11840.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Big Lottery Fund</th>\n",
" <td>36241.0</td>\n",
" <td>79576.0</td>\n",
" <td>93938.0</td>\n",
" <td>140596.0</td>\n",
" <td>17601.0</td>\n",
" <td>37807.0</td>\n",
" <td>42580.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Blagrave Trust</th>\n",
" <td>61000.0</td>\n",
" <td>127500.0</td>\n",
" <td>52000.0</td>\n",
" <td>90000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>79500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Clothworkers Foundation</th>\n",
" <td>19959.0</td>\n",
" <td>15868.0</td>\n",
" <td>14850.0</td>\n",
" <td>23250.0</td>\n",
" <td>5000.0</td>\n",
" <td>0.0</td>\n",
" <td>18023.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The David &amp; Elaine Potter Foundation</th>\n",
" <td>35981.0</td>\n",
" <td>15333.0</td>\n",
" <td>52500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>35078.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Dulverton Trust</th>\n",
" <td>42886.0</td>\n",
" <td>45437.0</td>\n",
" <td>35378.0</td>\n",
" <td>21750.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41836.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Dunhill Medical Trust</th>\n",
" <td>44261.0</td>\n",
" <td>44824.0</td>\n",
" <td>34567.0</td>\n",
" <td>25000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41250.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Henry Smith Charity</th>\n",
" <td>33646.0</td>\n",
" <td>63543.0</td>\n",
" <td>70733.0</td>\n",
" <td>72743.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>50102.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Joseph Rank Trust</th>\n",
" <td>28242.0</td>\n",
" <td>28824.0</td>\n",
" <td>28357.0</td>\n",
" <td>30000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>28382.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Robertson Trust</th>\n",
" <td>30931.0</td>\n",
" <td>33946.0</td>\n",
" <td>33730.0</td>\n",
" <td>64286.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>32951.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Tudor Trust</th>\n",
" <td>46143.0</td>\n",
" <td>53710.0</td>\n",
" <td>60540.0</td>\n",
" <td>64353.0</td>\n",
" <td>2000.0</td>\n",
" <td>11333.0</td>\n",
" <td>50740.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Wellcome Trust</th>\n",
" <td>423042.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>423042.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Three Guineas Trust</th>\n",
" <td>20426.0</td>\n",
" <td>43403.0</td>\n",
" <td>10000.0</td>\n",
" <td>10000.0</td>\n",
" <td>240000.0</td>\n",
" <td>0.0</td>\n",
" <td>33372.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trafford Housing Trust Social Investment</th>\n",
" <td>2836.0</td>\n",
" <td>4002.0</td>\n",
" <td>4240.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trafford Metropolitan Borough Council</th>\n",
" <td>1586.0</td>\n",
" <td>1497.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1563.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>True Colours Trust</th>\n",
" <td>38472.0</td>\n",
" <td>18391.0</td>\n",
" <td>4836.0</td>\n",
" <td>54284.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>31474.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trust for London</th>\n",
" <td>49634.0</td>\n",
" <td>52784.0</td>\n",
" <td>99330.0</td>\n",
" <td>80500.0</td>\n",
" <td>150000.0</td>\n",
" <td>0.0</td>\n",
" <td>58919.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tuixen Foundation</th>\n",
" <td>28780.0</td>\n",
" <td>29231.0</td>\n",
" <td>33333.0</td>\n",
" <td>50000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30053.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Two Ridings Community Foundation</th>\n",
" <td>2686.0</td>\n",
" <td>4680.0</td>\n",
" <td>10541.0</td>\n",
" <td>2238.0</td>\n",
" <td>0.0</td>\n",
" <td>3000.0</td>\n",
" <td>3344.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>United St Saviour's Charity</th>\n",
" <td>5380.0</td>\n",
" <td>34734.0</td>\n",
" <td>36699.0</td>\n",
" <td>60000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>13604.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virgin Money Foundation</th>\n",
" <td>69214.0</td>\n",
" <td>82990.0</td>\n",
" <td>43964.0</td>\n",
" <td>81180.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>71484.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Walcot Foundation</th>\n",
" <td>22524.0</td>\n",
" <td>36366.0</td>\n",
" <td>45000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23705.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wiltshire Community Foundation</th>\n",
" <td>21021.0</td>\n",
" <td>3052.0</td>\n",
" <td>1808.0</td>\n",
" <td>1016.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>12771.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Woodward Charitable Trust</th>\n",
" <td>1194.0</td>\n",
" <td>795.0</td>\n",
" <td>1210.0</td>\n",
" <td>650.0</td>\n",
" <td>0.0</td>\n",
" <td>2750.0</td>\n",
" <td>1070.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ZING</th>\n",
" <td>65500.0</td>\n",
" <td>15000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>55400.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>All</th>\n",
" <td>51367.0</td>\n",
" <td>46915.0</td>\n",
" <td>45755.0</td>\n",
" <td>48883.0</td>\n",
" <td>24238.0</td>\n",
" <td>12641.0</td>\n",
" <td>50425.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>82 rows × 7 columns</p>\n",
"</div>"
],
"text/plain": [
"funder_count 1 2 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 13000.0 13400.0 \n",
"ARCADIA 2322464.0 16581364.0 \n",
"Barrow Cadbury Trust 44969.0 34350.0 \n",
"Birmingham City Council 13472.0 10367.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 33627.0 0.0 \n",
"Cheshire Community Foundation 5293.0 6386.0 \n",
"City Bridge Trust 71616.0 102108.0 \n",
"Co-operative Group 2424.0 2756.0 \n",
"Comic Relief 274863.0 90133.0 \n",
"Community Foundation for Surrey 3081.0 4313.0 \n",
"Community Foundation serving Tyne & Wear and No... 3559.0 5006.0 \n",
"Corra Foundation 8428.0 7254.0 \n",
"Culham St Gabriel's Trust 17433.0 14000.0 \n",
"Department for Transport 15514.0 0.0 \n",
"Devon Community Foundation 5632.0 2898.0 \n",
"Dundee City Council 6994.0 0.0 \n",
"Esmée Fairbairn Foundation 151346.0 136096.0 \n",
"Essex Community Foundation 5828.0 7255.0 \n",
"Garfield Weston Foundation 33834.0 22302.0 \n",
"Gatsby Charitable Foundation 577265.0 452001.0 \n",
"Glasgow City Council 17068.0 19381.0 \n",
"Greater London Authority 449410.0 51123.0 \n",
"Heart Of England Community Foundation 2887.0 2361.0 \n",
"Indigo Trust 29570.0 17250.0 \n",
"John Moores Foundation 6092.0 9440.0 \n",
"Joseph Rowntree Charitable Trust 72214.0 57399.0 \n",
"Joseph Rowntree Foundation 4603.0 6040.0 \n",
"Lankelly Chase Foundation 116020.0 46342.0 \n",
"Lloyd's Register Foundation 1347982.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 50922.0 47231.0 \n",
"... ... ... \n",
"Sport England 182184.0 49741.0 \n",
"Staples Trust 15100.0 5000.0 \n",
"Stockport MBC 4060.0 0.0 \n",
"Sussex Community Foundation 4149.0 3765.0 \n",
"Tedworth Charitable Trust 13644.0 7000.0 \n",
"The Big Lottery Fund 36241.0 79576.0 \n",
"The Blagrave Trust 61000.0 127500.0 \n",
"The Clothworkers Foundation 19959.0 15868.0 \n",
"The David & Elaine Potter Foundation 35981.0 15333.0 \n",
"The Dulverton Trust 42886.0 45437.0 \n",
"The Dunhill Medical Trust 44261.0 44824.0 \n",
"The Henry Smith Charity 33646.0 63543.0 \n",
"The Joseph Rank Trust 28242.0 28824.0 \n",
"The Robertson Trust 30931.0 33946.0 \n",
"The Tudor Trust 46143.0 53710.0 \n",
"The Wellcome Trust 423042.0 0.0 \n",
"Three Guineas Trust 20426.0 43403.0 \n",
"Trafford Housing Trust Social Investment 2836.0 4002.0 \n",
"Trafford Metropolitan Borough Council 1586.0 1497.0 \n",
"True Colours Trust 38472.0 18391.0 \n",
"Trust for London 49634.0 52784.0 \n",
"Tuixen Foundation 28780.0 29231.0 \n",
"Two Ridings Community Foundation 2686.0 4680.0 \n",
"United St Saviour's Charity 5380.0 34734.0 \n",
"Virgin Money Foundation 69214.0 82990.0 \n",
"Walcot Foundation 22524.0 36366.0 \n",
"Wiltshire Community Foundation 21021.0 3052.0 \n",
"Woodward Charitable Trust 1194.0 795.0 \n",
"ZING 65500.0 15000.0 \n",
"All 51367.0 46915.0 \n",
"\n",
"funder_count 3 4 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 12344.0 14667.0 \n",
"ARCADIA 0.0 0.0 \n",
"Barrow Cadbury Trust 44762.0 91500.0 \n",
"Birmingham City Council 0.0 22699.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 0.0 0.0 \n",
"Cheshire Community Foundation 5295.0 7135.0 \n",
"City Bridge Trust 79198.0 100975.0 \n",
"Co-operative Group 3601.0 2743.0 \n",
"Comic Relief 97250.0 62410.0 \n",
"Community Foundation for Surrey 5383.0 7500.0 \n",
"Community Foundation serving Tyne & Wear and No... 6733.0 5264.0 \n",
"Corra Foundation 4957.0 22011.0 \n",
"Culham St Gabriel's Trust 0.0 7000.0 \n",
"Department for Transport 0.0 0.0 \n",
"Devon Community Foundation 2094.0 1000.0 \n",
"Dundee City Council 0.0 0.0 \n",
"Esmée Fairbairn Foundation 180794.0 111930.0 \n",
"Essex Community Foundation 5772.0 2815.0 \n",
"Garfield Weston Foundation 17470.0 24633.0 \n",
"Gatsby Charitable Foundation 0.0 0.0 \n",
"Glasgow City Council 15300.0 0.0 \n",
"Greater London Authority 23192.0 8000.0 \n",
"Heart Of England Community Foundation 2917.0 2658.0 \n",
"Indigo Trust 23500.0 0.0 \n",
"John Moores Foundation 5237.0 6400.0 \n",
"Joseph Rowntree Charitable Trust 86688.0 55676.0 \n",
"Joseph Rowntree Foundation 4975.0 600.0 \n",
"Lankelly Chase Foundation 15800.0 0.0 \n",
"Lloyd's Register Foundation 0.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 56663.0 39541.0 \n",
"... ... ... \n",
"Sport England 25869.0 60764.0 \n",
"Staples Trust 3800.0 0.0 \n",
"Stockport MBC 0.0 0.0 \n",
"Sussex Community Foundation 4827.0 5097.0 \n",
"Tedworth Charitable Trust 14900.0 0.0 \n",
"The Big Lottery Fund 93938.0 140596.0 \n",
"The Blagrave Trust 52000.0 90000.0 \n",
"The Clothworkers Foundation 14850.0 23250.0 \n",
"The David & Elaine Potter Foundation 52500.0 0.0 \n",
"The Dulverton Trust 35378.0 21750.0 \n",
"The Dunhill Medical Trust 34567.0 25000.0 \n",
"The Henry Smith Charity 70733.0 72743.0 \n",
"The Joseph Rank Trust 28357.0 30000.0 \n",
"The Robertson Trust 33730.0 64286.0 \n",
"The Tudor Trust 60540.0 64353.0 \n",
"The Wellcome Trust 0.0 0.0 \n",
"Three Guineas Trust 10000.0 10000.0 \n",
"Trafford Housing Trust Social Investment 4240.0 0.0 \n",
"Trafford Metropolitan Borough Council 0.0 0.0 \n",
"True Colours Trust 4836.0 54284.0 \n",
"Trust for London 99330.0 80500.0 \n",
"Tuixen Foundation 33333.0 50000.0 \n",
"Two Ridings Community Foundation 10541.0 2238.0 \n",
"United St Saviour's Charity 36699.0 60000.0 \n",
"Virgin Money Foundation 43964.0 81180.0 \n",
"Walcot Foundation 45000.0 0.0 \n",
"Wiltshire Community Foundation 1808.0 1016.0 \n",
"Woodward Charitable Trust 1210.0 650.0 \n",
"ZING 0.0 0.0 \n",
"All 45755.0 48883.0 \n",
"\n",
"funder_count 5 6 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 15000.0 0.0 \n",
"ARCADIA 0.0 0.0 \n",
"Barrow Cadbury Trust 0.0 0.0 \n",
"Birmingham City Council 0.0 0.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 0.0 0.0 \n",
"Cheshire Community Foundation 0.0 0.0 \n",
"City Bridge Trust 0.0 87900.0 \n",
"Co-operative Group 3294.0 2500.0 \n",
"Comic Relief 0.0 0.0 \n",
"Community Foundation for Surrey 0.0 0.0 \n",
"Community Foundation serving Tyne & Wear and No... 0.0 0.0 \n",
"Corra Foundation 5000.0 0.0 \n",
"Culham St Gabriel's Trust 0.0 0.0 \n",
"Department for Transport 0.0 0.0 \n",
"Devon Community Foundation 0.0 0.0 \n",
"Dundee City Council 0.0 0.0 \n",
"Esmée Fairbairn Foundation 0.0 0.0 \n",
"Essex Community Foundation 0.0 3000.0 \n",
"Garfield Weston Foundation 23750.0 9333.0 \n",
"Gatsby Charitable Foundation 0.0 113000.0 \n",
"Glasgow City Council 0.0 0.0 \n",
"Greater London Authority 0.0 0.0 \n",
"Heart Of England Community Foundation 2000.0 0.0 \n",
"Indigo Trust 0.0 4500.0 \n",
"John Moores Foundation 0.0 0.0 \n",
"Joseph Rowntree Charitable Trust 0.0 0.0 \n",
"Joseph Rowntree Foundation 4500.0 6333.0 \n",
"Lankelly Chase Foundation 0.0 0.0 \n",
"Lloyd's Register Foundation 0.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 75000.0 66540.0 \n",
"... ... ... \n",
"Sport England 0.0 0.0 \n",
"Staples Trust 0.0 4500.0 \n",
"Stockport MBC 0.0 0.0 \n",
"Sussex Community Foundation 0.0 0.0 \n",
"Tedworth Charitable Trust 0.0 4500.0 \n",
"The Big Lottery Fund 17601.0 37807.0 \n",
"The Blagrave Trust 0.0 0.0 \n",
"The Clothworkers Foundation 5000.0 0.0 \n",
"The David & Elaine Potter Foundation 0.0 0.0 \n",
"The Dulverton Trust 0.0 0.0 \n",
"The Dunhill Medical Trust 0.0 0.0 \n",
"The Henry Smith Charity 0.0 0.0 \n",
"The Joseph Rank Trust 0.0 0.0 \n",
"The Robertson Trust 0.0 0.0 \n",
"The Tudor Trust 2000.0 11333.0 \n",
"The Wellcome Trust 0.0 0.0 \n",
"Three Guineas Trust 240000.0 0.0 \n",
"Trafford Housing Trust Social Investment 0.0 0.0 \n",
"Trafford Metropolitan Borough Council 0.0 0.0 \n",
"True Colours Trust 0.0 4500.0 \n",
"Trust for London 150000.0 0.0 \n",
"Tuixen Foundation 0.0 0.0 \n",
"Two Ridings Community Foundation 0.0 3000.0 \n",
"United St Saviour's Charity 0.0 0.0 \n",
"Virgin Money Foundation 0.0 0.0 \n",
"Walcot Foundation 0.0 0.0 \n",
"Wiltshire Community Foundation 0.0 0.0 \n",
"Woodward Charitable Trust 0.0 2750.0 \n",
"ZING 0.0 0.0 \n",
"All 24238.0 12641.0 \n",
"\n",
"funder_count All \n",
"Funding Org:Name \n",
"A B Charitable Trust 13147.0 \n",
"ARCADIA 3463176.0 \n",
"Barrow Cadbury Trust 43859.0 \n",
"Birmingham City Council 13285.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 33627.0 \n",
"Cheshire Community Foundation 5622.0 \n",
"City Bridge Trust 84614.0 \n",
"Co-operative Group 2506.0 \n",
"Comic Relief 247159.0 \n",
"Community Foundation for Surrey 3305.0 \n",
"Community Foundation serving Tyne & Wear and No... 3964.0 \n",
"Corra Foundation 8454.0 \n",
"Culham St Gabriel's Trust 14660.0 \n",
"Department for Transport 15514.0 \n",
"Devon Community Foundation 5079.0 \n",
"Dundee City Council 6994.0 \n",
"Esmée Fairbairn Foundation 149991.0 \n",
"Essex Community Foundation 5974.0 \n",
"Garfield Weston Foundation 28931.0 \n",
"Gatsby Charitable Foundation 512646.0 \n",
"Glasgow City Council 17125.0 \n",
"Greater London Authority 312384.0 \n",
"Heart Of England Community Foundation 2782.0 \n",
"Indigo Trust 27168.0 \n",
"John Moores Foundation 6585.0 \n",
"Joseph Rowntree Charitable Trust 71479.0 \n",
"Joseph Rowntree Foundation 4728.0 \n",
"Lankelly Chase Foundation 97230.0 \n",
"Lloyd's Register Foundation 1347982.0 \n",
"Lloyds Bank Foundation for England and Wales 50130.0 \n",
"... ... \n",
"Sport England 173523.0 \n",
"Staples Trust 10559.0 \n",
"Stockport MBC 4060.0 \n",
"Sussex Community Foundation 4140.0 \n",
"Tedworth Charitable Trust 11840.0 \n",
"The Big Lottery Fund 42580.0 \n",
"The Blagrave Trust 79500.0 \n",
"The Clothworkers Foundation 18023.0 \n",
"The David & Elaine Potter Foundation 35078.0 \n",
"The Dulverton Trust 41836.0 \n",
"The Dunhill Medical Trust 41250.0 \n",
"The Henry Smith Charity 50102.0 \n",
"The Joseph Rank Trust 28382.0 \n",
"The Robertson Trust 32951.0 \n",
"The Tudor Trust 50740.0 \n",
"The Wellcome Trust 423042.0 \n",
"Three Guineas Trust 33372.0 \n",
"Trafford Housing Trust Social Investment 3000.0 \n",
"Trafford Metropolitan Borough Council 1563.0 \n",
"True Colours Trust 31474.0 \n",
"Trust for London 58919.0 \n",
"Tuixen Foundation 30053.0 \n",
"Two Ridings Community Foundation 3344.0 \n",
"United St Saviour's Charity 13604.0 \n",
"Virgin Money Foundation 71484.0 \n",
"Walcot Foundation 23705.0 \n",
"Wiltshire Community Foundation 12771.0 \n",
"Woodward Charitable Trust 1070.0 \n",
"ZING 55400.0 \n",
"All 50425.0 \n",
"\n",
"[82 rows x 7 columns]"
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"(pd.crosstab(\n",
" funder_count['Funding Org:Name'],\n",
" funder_count['funder_count'],\n",
" values=funder_count['Amount Awarded'],\n",
" aggfunc='sum',\n",
" margins=True,\n",
") / pd.crosstab(\n",
" funder_count['Funding Org:Name'],\n",
" funder_count['funder_count'],\n",
" values=funder_count['Grants'],\n",
" aggfunc='sum',\n",
" margins=True,\n",
")).fillna(0).round(0)"
]
},
{
"cell_type": "code",
"execution_count": 54,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>funder_count</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>All</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Funding Org:Name</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>A B Charitable Trust</th>\n",
" <td>10000.0</td>\n",
" <td>15000.0</td>\n",
" <td>12500.0</td>\n",
" <td>20000.0</td>\n",
" <td>15000.0</td>\n",
" <td>0.0</td>\n",
" <td>15000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ARCADIA</th>\n",
" <td>1125000.0</td>\n",
" <td>16581364.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1625000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Barrow Cadbury Trust</th>\n",
" <td>36000.0</td>\n",
" <td>27550.0</td>\n",
" <td>44762.0</td>\n",
" <td>91500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>36000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Birmingham City Council</th>\n",
" <td>8659.0</td>\n",
" <td>6100.0</td>\n",
" <td>0.0</td>\n",
" <td>22699.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>8659.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Calouste Gulbenkian Foundation, UK Branch</th>\n",
" <td>29000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>29000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cheshire Community Foundation</th>\n",
" <td>4800.0</td>\n",
" <td>7700.0</td>\n",
" <td>5000.0</td>\n",
" <td>8954.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>City Bridge Trust</th>\n",
" <td>68650.0</td>\n",
" <td>100000.0</td>\n",
" <td>91450.0</td>\n",
" <td>101175.0</td>\n",
" <td>0.0</td>\n",
" <td>87900.0</td>\n",
" <td>87750.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Co-operative Group</th>\n",
" <td>2302.0</td>\n",
" <td>2819.0</td>\n",
" <td>2943.0</td>\n",
" <td>3353.0</td>\n",
" <td>4077.0</td>\n",
" <td>5539.0</td>\n",
" <td>2384.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Comic Relief</th>\n",
" <td>114338.0</td>\n",
" <td>74934.0</td>\n",
" <td>89850.0</td>\n",
" <td>62410.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation for Surrey</th>\n",
" <td>1500.0</td>\n",
" <td>5000.0</td>\n",
" <td>5113.0</td>\n",
" <td>7500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Community Foundation serving Tyne &amp; Wear and Northumberland</th>\n",
" <td>2000.0</td>\n",
" <td>4718.0</td>\n",
" <td>2749.0</td>\n",
" <td>3500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Corra Foundation</th>\n",
" <td>4995.0</td>\n",
" <td>5000.0</td>\n",
" <td>5000.0</td>\n",
" <td>5000.0</td>\n",
" <td>5000.0</td>\n",
" <td>0.0</td>\n",
" <td>5000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Culham St Gabriel's Trust</th>\n",
" <td>24000.0</td>\n",
" <td>14000.0</td>\n",
" <td>0.0</td>\n",
" <td>7000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>14000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Department for Transport</th>\n",
" <td>18692.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>18692.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Devon Community Foundation</th>\n",
" <td>2000.0</td>\n",
" <td>2314.0</td>\n",
" <td>2000.0</td>\n",
" <td>1000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Dundee City Council</th>\n",
" <td>2590.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2590.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Esmée Fairbairn Foundation</th>\n",
" <td>101950.0</td>\n",
" <td>95000.0</td>\n",
" <td>150000.0</td>\n",
" <td>150000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>106730.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Essex Community Foundation</th>\n",
" <td>3956.0</td>\n",
" <td>5000.0</td>\n",
" <td>5500.0</td>\n",
" <td>2815.0</td>\n",
" <td>0.0</td>\n",
" <td>3000.0</td>\n",
" <td>4000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Garfield Weston Foundation</th>\n",
" <td>10000.0</td>\n",
" <td>10000.0</td>\n",
" <td>10000.0</td>\n",
" <td>15000.0</td>\n",
" <td>13750.0</td>\n",
" <td>14000.0</td>\n",
" <td>10000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Gatsby Charitable Foundation</th>\n",
" <td>314659.0</td>\n",
" <td>1356003.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>113000.0</td>\n",
" <td>314659.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Glasgow City Council</th>\n",
" <td>10000.0</td>\n",
" <td>23338.0</td>\n",
" <td>17200.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>11574.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Greater London Authority</th>\n",
" <td>60000.0</td>\n",
" <td>40690.0</td>\n",
" <td>10000.0</td>\n",
" <td>8000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>40000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Heart Of England Community Foundation</th>\n",
" <td>1920.0</td>\n",
" <td>2000.0</td>\n",
" <td>1000.0</td>\n",
" <td>2033.0</td>\n",
" <td>8000.0</td>\n",
" <td>0.0</td>\n",
" <td>1980.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indigo Trust</th>\n",
" <td>20000.0</td>\n",
" <td>8500.0</td>\n",
" <td>23500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>18800.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>John Moores Foundation</th>\n",
" <td>5000.0</td>\n",
" <td>10000.0</td>\n",
" <td>5000.0</td>\n",
" <td>6400.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Joseph Rowntree Charitable Trust</th>\n",
" <td>68000.0</td>\n",
" <td>50000.0</td>\n",
" <td>110000.0</td>\n",
" <td>59950.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>64000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Joseph Rowntree Foundation</th>\n",
" <td>4891.0</td>\n",
" <td>4975.0</td>\n",
" <td>4975.0</td>\n",
" <td>600.0</td>\n",
" <td>4500.0</td>\n",
" <td>6333.0</td>\n",
" <td>4925.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lankelly Chase Foundation</th>\n",
" <td>121200.0</td>\n",
" <td>36040.0</td>\n",
" <td>15800.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>115252.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyd's Register Foundation</th>\n",
" <td>108462.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>108462.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lloyds Bank Foundation for England and Wales</th>\n",
" <td>50000.0</td>\n",
" <td>50000.0</td>\n",
" <td>57017.0</td>\n",
" <td>27500.0</td>\n",
" <td>75000.0</td>\n",
" <td>66540.0</td>\n",
" <td>50000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sport England</th>\n",
" <td>10000.0</td>\n",
" <td>9962.0</td>\n",
" <td>9800.0</td>\n",
" <td>91146.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Staples Trust</th>\n",
" <td>5750.0</td>\n",
" <td>5000.0</td>\n",
" <td>5000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>5000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Stockport MBC</th>\n",
" <td>4590.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4590.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sussex Community Foundation</th>\n",
" <td>4000.0</td>\n",
" <td>4818.0</td>\n",
" <td>4903.0</td>\n",
" <td>5975.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4525.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tedworth Charitable Trust</th>\n",
" <td>10000.0</td>\n",
" <td>5000.0</td>\n",
" <td>19500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>10000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Big Lottery Fund</th>\n",
" <td>9905.0</td>\n",
" <td>9977.0</td>\n",
" <td>9991.0</td>\n",
" <td>10000.0</td>\n",
" <td>9275.0</td>\n",
" <td>9902.0</td>\n",
" <td>9920.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Blagrave Trust</th>\n",
" <td>45000.0</td>\n",
" <td>135000.0</td>\n",
" <td>75000.0</td>\n",
" <td>90000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>90000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Clothworkers Foundation</th>\n",
" <td>10500.0</td>\n",
" <td>10500.0</td>\n",
" <td>10000.0</td>\n",
" <td>15500.0</td>\n",
" <td>5000.0</td>\n",
" <td>0.0</td>\n",
" <td>10000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The David &amp; Elaine Potter Foundation</th>\n",
" <td>30000.0</td>\n",
" <td>6000.0</td>\n",
" <td>52500.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>29126.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Dulverton Trust</th>\n",
" <td>30000.0</td>\n",
" <td>30000.0</td>\n",
" <td>32000.0</td>\n",
" <td>27000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Dunhill Medical Trust</th>\n",
" <td>39510.0</td>\n",
" <td>34724.0</td>\n",
" <td>39836.0</td>\n",
" <td>25000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>39448.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Henry Smith Charity</th>\n",
" <td>10000.0</td>\n",
" <td>80800.0</td>\n",
" <td>83300.0</td>\n",
" <td>77300.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>45500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Joseph Rank Trust</th>\n",
" <td>27250.0</td>\n",
" <td>30000.0</td>\n",
" <td>30000.0</td>\n",
" <td>30000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Robertson Trust</th>\n",
" <td>24000.0</td>\n",
" <td>30000.0</td>\n",
" <td>30000.0</td>\n",
" <td>48750.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>27000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Tudor Trust</th>\n",
" <td>50000.0</td>\n",
" <td>54000.0</td>\n",
" <td>60000.0</td>\n",
" <td>72000.0</td>\n",
" <td>2000.0</td>\n",
" <td>17000.0</td>\n",
" <td>50000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>The Wellcome Trust</th>\n",
" <td>100000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Three Guineas Trust</th>\n",
" <td>8000.0</td>\n",
" <td>9000.0</td>\n",
" <td>10000.0</td>\n",
" <td>10000.0</td>\n",
" <td>240000.0</td>\n",
" <td>0.0</td>\n",
" <td>8700.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trafford Housing Trust Social Investment</th>\n",
" <td>1304.0</td>\n",
" <td>3705.0</td>\n",
" <td>4240.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1550.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trafford Metropolitan Borough Council</th>\n",
" <td>1830.0</td>\n",
" <td>1995.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1944.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>True Colours Trust</th>\n",
" <td>5000.0</td>\n",
" <td>6860.0</td>\n",
" <td>5000.0</td>\n",
" <td>54284.0</td>\n",
" <td>0.0</td>\n",
" <td>4500.0</td>\n",
" <td>5000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Trust for London</th>\n",
" <td>30000.0</td>\n",
" <td>47000.0</td>\n",
" <td>90500.0</td>\n",
" <td>82000.0</td>\n",
" <td>150000.0</td>\n",
" <td>0.0</td>\n",
" <td>50000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tuixen Foundation</th>\n",
" <td>21000.0</td>\n",
" <td>30000.0</td>\n",
" <td>30000.0</td>\n",
" <td>50000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Two Ridings Community Foundation</th>\n",
" <td>1690.0</td>\n",
" <td>4368.0</td>\n",
" <td>5884.0</td>\n",
" <td>2950.0</td>\n",
" <td>0.0</td>\n",
" <td>3000.0</td>\n",
" <td>2000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>United St Saviour's Charity</th>\n",
" <td>2000.0</td>\n",
" <td>22441.0</td>\n",
" <td>42448.0</td>\n",
" <td>60000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2749.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virgin Money Foundation</th>\n",
" <td>35200.0</td>\n",
" <td>49977.0</td>\n",
" <td>41981.0</td>\n",
" <td>48989.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>43000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Walcot Foundation</th>\n",
" <td>17845.0</td>\n",
" <td>25000.0</td>\n",
" <td>45000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>20500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wiltshire Community Foundation</th>\n",
" <td>2120.0</td>\n",
" <td>2000.0</td>\n",
" <td>1808.0</td>\n",
" <td>1016.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Woodward Charitable Trust</th>\n",
" <td>500.0</td>\n",
" <td>750.0</td>\n",
" <td>1000.0</td>\n",
" <td>500.0</td>\n",
" <td>0.0</td>\n",
" <td>2750.0</td>\n",
" <td>500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ZING</th>\n",
" <td>63500.0</td>\n",
" <td>15000.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>50000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>All</th>\n",
" <td>7350.0</td>\n",
" <td>9598.0</td>\n",
" <td>10000.0</td>\n",
" <td>12830.0</td>\n",
" <td>7500.0</td>\n",
" <td>4702.0</td>\n",
" <td>7938.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>82 rows × 7 columns</p>\n",
"</div>"
],
"text/plain": [
"funder_count 1 2 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 10000.0 15000.0 \n",
"ARCADIA 1125000.0 16581364.0 \n",
"Barrow Cadbury Trust 36000.0 27550.0 \n",
"Birmingham City Council 8659.0 6100.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 29000.0 0.0 \n",
"Cheshire Community Foundation 4800.0 7700.0 \n",
"City Bridge Trust 68650.0 100000.0 \n",
"Co-operative Group 2302.0 2819.0 \n",
"Comic Relief 114338.0 74934.0 \n",
"Community Foundation for Surrey 1500.0 5000.0 \n",
"Community Foundation serving Tyne & Wear and No... 2000.0 4718.0 \n",
"Corra Foundation 4995.0 5000.0 \n",
"Culham St Gabriel's Trust 24000.0 14000.0 \n",
"Department for Transport 18692.0 0.0 \n",
"Devon Community Foundation 2000.0 2314.0 \n",
"Dundee City Council 2590.0 0.0 \n",
"Esmée Fairbairn Foundation 101950.0 95000.0 \n",
"Essex Community Foundation 3956.0 5000.0 \n",
"Garfield Weston Foundation 10000.0 10000.0 \n",
"Gatsby Charitable Foundation 314659.0 1356003.0 \n",
"Glasgow City Council 10000.0 23338.0 \n",
"Greater London Authority 60000.0 40690.0 \n",
"Heart Of England Community Foundation 1920.0 2000.0 \n",
"Indigo Trust 20000.0 8500.0 \n",
"John Moores Foundation 5000.0 10000.0 \n",
"Joseph Rowntree Charitable Trust 68000.0 50000.0 \n",
"Joseph Rowntree Foundation 4891.0 4975.0 \n",
"Lankelly Chase Foundation 121200.0 36040.0 \n",
"Lloyd's Register Foundation 108462.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 50000.0 50000.0 \n",
"... ... ... \n",
"Sport England 10000.0 9962.0 \n",
"Staples Trust 5750.0 5000.0 \n",
"Stockport MBC 4590.0 0.0 \n",
"Sussex Community Foundation 4000.0 4818.0 \n",
"Tedworth Charitable Trust 10000.0 5000.0 \n",
"The Big Lottery Fund 9905.0 9977.0 \n",
"The Blagrave Trust 45000.0 135000.0 \n",
"The Clothworkers Foundation 10500.0 10500.0 \n",
"The David & Elaine Potter Foundation 30000.0 6000.0 \n",
"The Dulverton Trust 30000.0 30000.0 \n",
"The Dunhill Medical Trust 39510.0 34724.0 \n",
"The Henry Smith Charity 10000.0 80800.0 \n",
"The Joseph Rank Trust 27250.0 30000.0 \n",
"The Robertson Trust 24000.0 30000.0 \n",
"The Tudor Trust 50000.0 54000.0 \n",
"The Wellcome Trust 100000.0 0.0 \n",
"Three Guineas Trust 8000.0 9000.0 \n",
"Trafford Housing Trust Social Investment 1304.0 3705.0 \n",
"Trafford Metropolitan Borough Council 1830.0 1995.0 \n",
"True Colours Trust 5000.0 6860.0 \n",
"Trust for London 30000.0 47000.0 \n",
"Tuixen Foundation 21000.0 30000.0 \n",
"Two Ridings Community Foundation 1690.0 4368.0 \n",
"United St Saviour's Charity 2000.0 22441.0 \n",
"Virgin Money Foundation 35200.0 49977.0 \n",
"Walcot Foundation 17845.0 25000.0 \n",
"Wiltshire Community Foundation 2120.0 2000.0 \n",
"Woodward Charitable Trust 500.0 750.0 \n",
"ZING 63500.0 15000.0 \n",
"All 7350.0 9598.0 \n",
"\n",
"funder_count 3 4 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 12500.0 20000.0 \n",
"ARCADIA 0.0 0.0 \n",
"Barrow Cadbury Trust 44762.0 91500.0 \n",
"Birmingham City Council 0.0 22699.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 0.0 0.0 \n",
"Cheshire Community Foundation 5000.0 8954.0 \n",
"City Bridge Trust 91450.0 101175.0 \n",
"Co-operative Group 2943.0 3353.0 \n",
"Comic Relief 89850.0 62410.0 \n",
"Community Foundation for Surrey 5113.0 7500.0 \n",
"Community Foundation serving Tyne & Wear and No... 2749.0 3500.0 \n",
"Corra Foundation 5000.0 5000.0 \n",
"Culham St Gabriel's Trust 0.0 7000.0 \n",
"Department for Transport 0.0 0.0 \n",
"Devon Community Foundation 2000.0 1000.0 \n",
"Dundee City Council 0.0 0.0 \n",
"Esmée Fairbairn Foundation 150000.0 150000.0 \n",
"Essex Community Foundation 5500.0 2815.0 \n",
"Garfield Weston Foundation 10000.0 15000.0 \n",
"Gatsby Charitable Foundation 0.0 0.0 \n",
"Glasgow City Council 17200.0 0.0 \n",
"Greater London Authority 10000.0 8000.0 \n",
"Heart Of England Community Foundation 1000.0 2033.0 \n",
"Indigo Trust 23500.0 0.0 \n",
"John Moores Foundation 5000.0 6400.0 \n",
"Joseph Rowntree Charitable Trust 110000.0 59950.0 \n",
"Joseph Rowntree Foundation 4975.0 600.0 \n",
"Lankelly Chase Foundation 15800.0 0.0 \n",
"Lloyd's Register Foundation 0.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 57017.0 27500.0 \n",
"... ... ... \n",
"Sport England 9800.0 91146.0 \n",
"Staples Trust 5000.0 0.0 \n",
"Stockport MBC 0.0 0.0 \n",
"Sussex Community Foundation 4903.0 5975.0 \n",
"Tedworth Charitable Trust 19500.0 0.0 \n",
"The Big Lottery Fund 9991.0 10000.0 \n",
"The Blagrave Trust 75000.0 90000.0 \n",
"The Clothworkers Foundation 10000.0 15500.0 \n",
"The David & Elaine Potter Foundation 52500.0 0.0 \n",
"The Dulverton Trust 32000.0 27000.0 \n",
"The Dunhill Medical Trust 39836.0 25000.0 \n",
"The Henry Smith Charity 83300.0 77300.0 \n",
"The Joseph Rank Trust 30000.0 30000.0 \n",
"The Robertson Trust 30000.0 48750.0 \n",
"The Tudor Trust 60000.0 72000.0 \n",
"The Wellcome Trust 0.0 0.0 \n",
"Three Guineas Trust 10000.0 10000.0 \n",
"Trafford Housing Trust Social Investment 4240.0 0.0 \n",
"Trafford Metropolitan Borough Council 0.0 0.0 \n",
"True Colours Trust 5000.0 54284.0 \n",
"Trust for London 90500.0 82000.0 \n",
"Tuixen Foundation 30000.0 50000.0 \n",
"Two Ridings Community Foundation 5884.0 2950.0 \n",
"United St Saviour's Charity 42448.0 60000.0 \n",
"Virgin Money Foundation 41981.0 48989.0 \n",
"Walcot Foundation 45000.0 0.0 \n",
"Wiltshire Community Foundation 1808.0 1016.0 \n",
"Woodward Charitable Trust 1000.0 500.0 \n",
"ZING 0.0 0.0 \n",
"All 10000.0 12830.0 \n",
"\n",
"funder_count 5 6 \\\n",
"Funding Org:Name \n",
"A B Charitable Trust 15000.0 0.0 \n",
"ARCADIA 0.0 0.0 \n",
"Barrow Cadbury Trust 0.0 0.0 \n",
"Birmingham City Council 0.0 0.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 0.0 0.0 \n",
"Cheshire Community Foundation 0.0 0.0 \n",
"City Bridge Trust 0.0 87900.0 \n",
"Co-operative Group 4077.0 5539.0 \n",
"Comic Relief 0.0 0.0 \n",
"Community Foundation for Surrey 0.0 0.0 \n",
"Community Foundation serving Tyne & Wear and No... 0.0 0.0 \n",
"Corra Foundation 5000.0 0.0 \n",
"Culham St Gabriel's Trust 0.0 0.0 \n",
"Department for Transport 0.0 0.0 \n",
"Devon Community Foundation 0.0 0.0 \n",
"Dundee City Council 0.0 0.0 \n",
"Esmée Fairbairn Foundation 0.0 0.0 \n",
"Essex Community Foundation 0.0 3000.0 \n",
"Garfield Weston Foundation 13750.0 14000.0 \n",
"Gatsby Charitable Foundation 0.0 113000.0 \n",
"Glasgow City Council 0.0 0.0 \n",
"Greater London Authority 0.0 0.0 \n",
"Heart Of England Community Foundation 8000.0 0.0 \n",
"Indigo Trust 0.0 4500.0 \n",
"John Moores Foundation 0.0 0.0 \n",
"Joseph Rowntree Charitable Trust 0.0 0.0 \n",
"Joseph Rowntree Foundation 4500.0 6333.0 \n",
"Lankelly Chase Foundation 0.0 0.0 \n",
"Lloyd's Register Foundation 0.0 0.0 \n",
"Lloyds Bank Foundation for England and Wales 75000.0 66540.0 \n",
"... ... ... \n",
"Sport England 0.0 0.0 \n",
"Staples Trust 0.0 4500.0 \n",
"Stockport MBC 0.0 0.0 \n",
"Sussex Community Foundation 0.0 0.0 \n",
"Tedworth Charitable Trust 0.0 4500.0 \n",
"The Big Lottery Fund 9275.0 9902.0 \n",
"The Blagrave Trust 0.0 0.0 \n",
"The Clothworkers Foundation 5000.0 0.0 \n",
"The David & Elaine Potter Foundation 0.0 0.0 \n",
"The Dulverton Trust 0.0 0.0 \n",
"The Dunhill Medical Trust 0.0 0.0 \n",
"The Henry Smith Charity 0.0 0.0 \n",
"The Joseph Rank Trust 0.0 0.0 \n",
"The Robertson Trust 0.0 0.0 \n",
"The Tudor Trust 2000.0 17000.0 \n",
"The Wellcome Trust 0.0 0.0 \n",
"Three Guineas Trust 240000.0 0.0 \n",
"Trafford Housing Trust Social Investment 0.0 0.0 \n",
"Trafford Metropolitan Borough Council 0.0 0.0 \n",
"True Colours Trust 0.0 4500.0 \n",
"Trust for London 150000.0 0.0 \n",
"Tuixen Foundation 0.0 0.0 \n",
"Two Ridings Community Foundation 0.0 3000.0 \n",
"United St Saviour's Charity 0.0 0.0 \n",
"Virgin Money Foundation 0.0 0.0 \n",
"Walcot Foundation 0.0 0.0 \n",
"Wiltshire Community Foundation 0.0 0.0 \n",
"Woodward Charitable Trust 0.0 2750.0 \n",
"ZING 0.0 0.0 \n",
"All 7500.0 4702.0 \n",
"\n",
"funder_count All \n",
"Funding Org:Name \n",
"A B Charitable Trust 15000.0 \n",
"ARCADIA 1625000.0 \n",
"Barrow Cadbury Trust 36000.0 \n",
"Birmingham City Council 8659.0 \n",
"Calouste Gulbenkian Foundation, UK Branch 29000.0 \n",
"Cheshire Community Foundation 5000.0 \n",
"City Bridge Trust 87750.0 \n",
"Co-operative Group 2384.0 \n",
"Comic Relief 100000.0 \n",
"Community Foundation for Surrey 2000.0 \n",
"Community Foundation serving Tyne & Wear and No... 2000.0 \n",
"Corra Foundation 5000.0 \n",
"Culham St Gabriel's Trust 14000.0 \n",
"Department for Transport 18692.0 \n",
"Devon Community Foundation 2000.0 \n",
"Dundee City Council 2590.0 \n",
"Esmée Fairbairn Foundation 106730.0 \n",
"Essex Community Foundation 4000.0 \n",
"Garfield Weston Foundation 10000.0 \n",
"Gatsby Charitable Foundation 314659.0 \n",
"Glasgow City Council 11574.0 \n",
"Greater London Authority 40000.0 \n",
"Heart Of England Community Foundation 1980.0 \n",
"Indigo Trust 18800.0 \n",
"John Moores Foundation 5000.0 \n",
"Joseph Rowntree Charitable Trust 64000.0 \n",
"Joseph Rowntree Foundation 4925.0 \n",
"Lankelly Chase Foundation 115252.0 \n",
"Lloyd's Register Foundation 108462.0 \n",
"Lloyds Bank Foundation for England and Wales 50000.0 \n",
"... ... \n",
"Sport England 10000.0 \n",
"Staples Trust 5000.0 \n",
"Stockport MBC 4590.0 \n",
"Sussex Community Foundation 4525.0 \n",
"Tedworth Charitable Trust 10000.0 \n",
"The Big Lottery Fund 9920.0 \n",
"The Blagrave Trust 90000.0 \n",
"The Clothworkers Foundation 10000.0 \n",
"The David & Elaine Potter Foundation 29126.0 \n",
"The Dulverton Trust 30000.0 \n",
"The Dunhill Medical Trust 39448.0 \n",
"The Henry Smith Charity 45500.0 \n",
"The Joseph Rank Trust 30000.0 \n",
"The Robertson Trust 27000.0 \n",
"The Tudor Trust 50000.0 \n",
"The Wellcome Trust 100000.0 \n",
"Three Guineas Trust 8700.0 \n",
"Trafford Housing Trust Social Investment 1550.0 \n",
"Trafford Metropolitan Borough Council 1944.0 \n",
"True Colours Trust 5000.0 \n",
"Trust for London 50000.0 \n",
"Tuixen Foundation 25000.0 \n",
"Two Ridings Community Foundation 2000.0 \n",
"United St Saviour's Charity 2749.0 \n",
"Virgin Money Foundation 43000.0 \n",
"Walcot Foundation 20500.0 \n",
"Wiltshire Community Foundation 2000.0 \n",
"Woodward Charitable Trust 500.0 \n",
"ZING 50000.0 \n",
"All 7938.0 \n",
"\n",
"[82 rows x 7 columns]"
]
},
"execution_count": 54,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.crosstab(\n",
" funder_count['Funding Org:Name'],\n",
" funder_count['funder_count'],\n",
" values=funder_count['Amount Awarded'],\n",
" aggfunc='median',\n",
" margins=True,\n",
").fillna(0).round(0)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"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.6.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment