Skip to content

Instantly share code, notes, and snippets.

@nheeren

nheeren/IEFDC_validation_first_steps.ipynb

Last active September 3, 2018 21:26
Show Gist options
  • Save nheeren/cc8a2d1bf8e9d362f09c40b0af147698 to your computer and use it in GitHub Desktop.
Save nheeren/cc8a2d1bf8e9d362f09c40b0af147698 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
IEFDC_validation_first_steps.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pymysql\n",
"import pandas as pd\n",
"\n",
"# include the keyfile in the path\n",
"import sys\n",
"sys.path.insert(0, '..')"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"# get the keyfile\n",
"import IEDC_PW"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"conn = pymysql.connect(host=IEDC_PW.IEDC_server, \n",
" port=IEDC_PW.IEDC_port, \n",
" user=IEDC_PW.IEDC_write_access_user, \n",
" passwd=IEDC_PW.IEDC_write_access_user_PW, \n",
" db=IEDC_PW.IEDC_database, \n",
" charset=\"utf8\")"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# Will work only with pandas for now - no cursor needed\n",
"# cur = conn.cursor()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"# Just a test how to read different tables - seems to work :)\n",
"gotta_get_em_all = [\"classification_items\", \"classification_definition\"]\n",
"all_tables = {}\n",
"for table in gotta_get_em_all:\n",
" # Don't show this to anybody... Injections into SQL are a big nono...\n",
" all_tables[table] = pd.read_sql(\"SELECT * FROM %s.%s;\" % (IEDC_PW.IEDC_database, table),\n",
" conn, index_col='id')"
]
},
{
"cell_type": "code",
"execution_count": 6,
"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>classification_Name</th>\n",
" <th>dimension</th>\n",
" <th>description</th>\n",
" <th>mutually_exclusive</th>\n",
" <th>collectively_exhaustive</th>\n",
" <th>reference</th>\n",
" <th>reserve1</th>\n",
" <th>reserve2</th>\n",
" <th>reserve3</th>\n",
" <th>reserve4</th>\n",
" <th>...</th>\n",
" <th>meaning_attribute6</th>\n",
" <th>meaning_attribute7</th>\n",
" <th>meaning_attribute8</th>\n",
" <th>meaning_attribute9</th>\n",
" <th>meaning_attribute10</th>\n",
" <th>meaning_attribute11</th>\n",
" <th>meaning_attribute12</th>\n",
" <th>meaning_attribute13</th>\n",
" <th>meaning_attribute14</th>\n",
" <th>meaning_attribute15</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</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",
" <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",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>chemical_elements</td>\n",
" <td>2</td>\n",
" <td>Chemical elements 1-118</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td>UN region</td>\n",
" <td>UN member (bool)</td>\n",
" <td>Official Country (bool)</td>\n",
" <td>Alternative ISO3</td>\n",
" <td>Alternative Name 1</td>\n",
" <td>Alternative Name 2</td>\n",
" <td>Alternative Name 3</td>\n",
" <td>Alternative Name 4</td>\n",
" <td>Alternative Name 5</td>\n",
" <td>Alternative Name 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>regions_iso_iedc</td>\n",
" <td>4</td>\n",
" <td>ISO 3166 classification of states and regions,...</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>time</td>\n",
" <td>1</td>\n",
" <td>Years 1800-2200</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>generic_materials_waste</td>\n",
" <td>5</td>\n",
" <td>List of common materials, products, and waste ...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NACEv2_(ProdCom)</td>\n",
" <td>6</td>\n",
" <td>List of ProdCom commodities</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>broad_industry_groups</td>\n",
" <td>7</td>\n",
" <td>List of broad industry groupts (mining, materi...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>general_product_categories</td>\n",
" <td>6</td>\n",
" <td>List of general building categories, residenti...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>basic_scenario_alternatives</td>\n",
" <td>9</td>\n",
" <td>High-medium-low scenarios</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>ca_time</td>\n",
" <td>1</td>\n",
" <td>Years with ca. prefix</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>general_energy_carriers</td>\n",
" <td>8</td>\n",
" <td>List of general energy carriers</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>cities</td>\n",
" <td>4</td>\n",
" <td>List of cities</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>service_categories</td>\n",
" <td>11</td>\n",
" <td>List of services</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>building_types</td>\n",
" <td>6</td>\n",
" <td>List of commonly used building types</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>age_cohort_ranges</td>\n",
" <td>1</td>\n",
" <td>List of time intervals for age cohorts</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>custom</td>\n",
" <td>0</td>\n",
" <td>Custom classification, dimension specified via...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</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",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>steel_cycle_200R_processes</td>\n",
" <td>7</td>\n",
" <td>List of processes for steel cycle MFA DOI 10.1...</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td>color</td>\n",
" <td>angle</td>\n",
" <td>width</td>\n",
" <td>height</td>\n",
" <td>xPos</td>\n",
" <td>yPos</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>steel_cycle_200R_materials_products</td>\n",
" <td>6</td>\n",
" <td>materials and products for stocks and flows in...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>None</td>\n",
" <td>1</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>...</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>17 rows × 26 columns</p>\n",
"</div>"
],
"text/plain": [
" classification_Name dimension \\\n",
"id \n",
"1 chemical_elements 2 \n",
"2 regions_iso_iedc 4 \n",
"3 time 1 \n",
"4 generic_materials_waste 5 \n",
"5 NACEv2_(ProdCom) 6 \n",
"6 broad_industry_groups 7 \n",
"7 general_product_categories 6 \n",
"8 basic_scenario_alternatives 9 \n",
"9 ca_time 1 \n",
"10 general_energy_carriers 8 \n",
"11 cities 4 \n",
"12 service_categories 11 \n",
"13 building_types 6 \n",
"14 age_cohort_ranges 1 \n",
"15 custom 0 \n",
"16 steel_cycle_200R_processes 7 \n",
"17 steel_cycle_200R_materials_products 6 \n",
"\n",
" description mutually_exclusive \\\n",
"id \n",
"1 Chemical elements 1-118 1 \n",
"2 ISO 3166 classification of states and regions,... 0 \n",
"3 Years 1800-2200 1 \n",
"4 List of common materials, products, and waste ... 0 \n",
"5 List of ProdCom commodities 1 \n",
"6 List of broad industry groupts (mining, materi... 0 \n",
"7 List of general building categories, residenti... 0 \n",
"8 High-medium-low scenarios 1 \n",
"9 Years with ca. prefix 1 \n",
"10 List of general energy carriers 0 \n",
"11 List of cities 0 \n",
"12 List of services 0 \n",
"13 List of commonly used building types 0 \n",
"14 List of time intervals for age cohorts 0 \n",
"15 Custom classification, dimension specified via... 0 \n",
"16 List of processes for steel cycle MFA DOI 10.1... 1 \n",
"17 materials and products for stocks and flows in... 0 \n",
"\n",
" collectively_exhaustive reference reserve1 reserve2 reserve3 reserve4 \\\n",
"id \n",
"1 1 1 \n",
"2 1 1 \n",
"3 0 1 \n",
"4 0 1 \n",
"5 0 1 \n",
"6 0 1 \n",
"7 0 1 \n",
"8 0 1 \n",
"9 0 1 \n",
"10 0 1 \n",
"11 0 1 \n",
"12 0 1 \n",
"13 0 1 \n",
"14 0 1 \n",
"15 0 1 \n",
"16 0 1 \n",
"17 0 None 1 None None None \n",
"\n",
" ... meaning_attribute6 meaning_attribute7 \\\n",
"id ... \n",
"1 ... UN region UN member (bool) \n",
"2 ... \n",
"3 ... \n",
"4 ... \n",
"5 ... \n",
"6 ... \n",
"7 ... \n",
"8 ... \n",
"9 ... \n",
"10 ... \n",
"11 ... \n",
"12 ... \n",
"13 ... \n",
"14 ... \n",
"15 ... \n",
"16 ... color angle \n",
"17 ... None None \n",
"\n",
" meaning_attribute8 meaning_attribute9 meaning_attribute10 \\\n",
"id \n",
"1 Official Country (bool) Alternative ISO3 Alternative Name 1 \n",
"2 \n",
"3 \n",
"4 \n",
"5 \n",
"6 \n",
"7 \n",
"8 \n",
"9 \n",
"10 \n",
"11 \n",
"12 \n",
"13 \n",
"14 \n",
"15 \n",
"16 width height xPos \n",
"17 None None None \n",
"\n",
" meaning_attribute11 meaning_attribute12 meaning_attribute13 \\\n",
"id \n",
"1 Alternative Name 2 Alternative Name 3 Alternative Name 4 \n",
"2 \n",
"3 \n",
"4 \n",
"5 \n",
"6 \n",
"7 \n",
"8 \n",
"9 \n",
"10 \n",
"11 \n",
"12 \n",
"13 \n",
"14 \n",
"15 \n",
"16 yPos \n",
"17 None None None \n",
"\n",
" meaning_attribute14 meaning_attribute15 \n",
"id \n",
"1 Alternative Name 5 Alternative Name 6 \n",
"2 \n",
"3 \n",
"4 \n",
"5 \n",
"6 \n",
"7 \n",
"8 \n",
"9 \n",
"10 \n",
"11 \n",
"12 \n",
"13 \n",
"14 \n",
"15 \n",
"16 \n",
"17 None None \n",
"\n",
"[17 rows x 26 columns]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"all_tables[\"classification_definition\"]"
]
},
{
"cell_type": "code",
"execution_count": 8,
"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>Unity</th>\n",
" <th>Layer</th>\n",
" <th>Time</th>\n",
" <th>Chemical_Elements</th>\n",
" <th>SSP_Scenarios</th>\n",
" <th>RCP_Scenarios</th>\n",
" <th>SSP_Regions_32</th>\n",
" <th>Mines_PrimayProd_i1</th>\n",
" <th>Ores_RawMaterials_m1</th>\n",
" <th>Material_Production_i2</th>\n",
" <th>...</th>\n",
" <th>Products_m3</th>\n",
" <th>Products_components_m3</th>\n",
" <th>Use_Phase_i4</th>\n",
" <th>EoL_Products_m4</th>\n",
" <th>Waste_Mgt_Industries_i5</th>\n",
" <th>Waste_Scrap_m5</th>\n",
" <th>Energy_Supply_Industries_i6</th>\n",
" <th>Energy_Carriers_m6</th>\n",
" <th>Process_Extensions</th>\n",
" <th>SSP_Population_Models</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Name</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",
" <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",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>mass (total mass)</td>\n",
" <td>1700</td>\n",
" <td>All</td>\n",
" <td>SSP1</td>\n",
" <td>RCP2.6</td>\n",
" <td>R32AUNZ</td>\n",
" <td>Limestone quarries</td>\n",
" <td>Limestone</td>\n",
" <td>cement plant (limestone)</td>\n",
" <td>...</td>\n",
" <td>Internal Combustion Engine, gasoline (ICEG)</td>\n",
" <td>all vehicle components</td>\n",
" <td>use phase, Internal Combustion Engine, gasolin...</td>\n",
" <td>EoL Internal Combustion Engine, gasoline (ICEG)</td>\n",
" <td>food waste sorting</td>\n",
" <td>heavy melt, plate, and structural steel scrap</td>\n",
" <td>production of electricity by coal</td>\n",
" <td>electricity</td>\n",
" <td>CO2 emisisons per main output</td>\n",
" <td>IIASA GDP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NaN</td>\n",
" <td>mass ratio</td>\n",
" <td>1701</td>\n",
" <td>H</td>\n",
" <td>SSP2</td>\n",
" <td>RCP3.4</td>\n",
" <td>R32BRA</td>\n",
" <td>Iron ore mines</td>\n",
" <td>Iron ore</td>\n",
" <td>cement from ash or slag</td>\n",
" <td>...</td>\n",
" <td>Internal Combustion Engine, diesel (ICED)</td>\n",
" <td>vehicle body</td>\n",
" <td>use phase, Internal Combustion Engine, diesel ...</td>\n",
" <td>EoL Internal Combustion Engine, diesel (ICED)</td>\n",
" <td>MSW sorting</td>\n",
" <td>steel shred</td>\n",
" <td>production of electricity by gas</td>\n",
" <td>heat</td>\n",
" <td>CH4 emissions per main output</td>\n",
" <td>IIASA-WiC POP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>volume</td>\n",
" <td>1702</td>\n",
" <td>He</td>\n",
" <td>SSP3</td>\n",
" <td>RCP4.5</td>\n",
" <td>R32CAN</td>\n",
" <td>Bauxite mines</td>\n",
" <td>Bauxite</td>\n",
" <td>pig iron production (blast furnace)</td>\n",
" <td>...</td>\n",
" <td>Hybrid Electric Vehicles (HEV)</td>\n",
" <td>drive train incl. suspension</td>\n",
" <td>use phase, Hybrid Electric Vehicles (HEV)</td>\n",
" <td>EoL Hybrid Electric Vehicles (HEV)</td>\n",
" <td>deconstruction</td>\n",
" <td>stainless steel scrap</td>\n",
" <td>production of electricity by nuclear</td>\n",
" <td>coal, hard coal</td>\n",
" <td>N2O emissions per main output</td>\n",
" <td>NCAR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>volume ratio</td>\n",
" <td>1703</td>\n",
" <td>Li</td>\n",
" <td>SSP4</td>\n",
" <td>RCP6.0</td>\n",
" <td>R32CAS</td>\n",
" <td>Co mines</td>\n",
" <td>Oxidic copper ores</td>\n",
" <td>direct iron ore reduction</td>\n",
" <td>...</td>\n",
" <td>Plugin Hybrid Electric Vehicles (PHEV)</td>\n",
" <td>vehicle battery</td>\n",
" <td>use phase, Plugin Hybrid Electric Vehicles (PHEV)</td>\n",
" <td>EoL Plugin Hybrid Electric Vehicles (PHEV)</td>\n",
" <td>dismantling</td>\n",
" <td>steel casting scrap</td>\n",
" <td>production of electricity by hydro</td>\n",
" <td>coal, lignite</td>\n",
" <td>SF6 emisisons per main output</td>\n",
" <td>OECD Env-Growth</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>number ratio (items per items)</td>\n",
" <td>1704</td>\n",
" <td>Be</td>\n",
" <td>SSP5</td>\n",
" <td>RCP8.5</td>\n",
" <td>R32CHN</td>\n",
" <td>Cu-Co mines</td>\n",
" <td>sulfidic copper ores</td>\n",
" <td>BOF route steel making and remelting</td>\n",
" <td>...</td>\n",
" <td>Battery Electric Vehicles (BEV)</td>\n",
" <td>car electronics</td>\n",
" <td>use phase, Battery Electric Vehicles (BEV)</td>\n",
" <td>EoL Battery Electric Vehicles (BEV)</td>\n",
" <td>sorting (hand)</td>\n",
" <td>turnings and busheling fabrication steel scrap</td>\n",
" <td>production of electricity by wind</td>\n",
" <td>coke</td>\n",
" <td>GHG emissions</td>\n",
" <td>PIK GDP-32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>value per mass (purchaser price)</td>\n",
" <td>1705</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>Baseline(unmitigated)</td>\n",
" <td>R32EEU</td>\n",
" <td>Ni-Co mines</td>\n",
" <td>Nickel ore</td>\n",
" <td>EAF route steel making and remelting</td>\n",
" <td>...</td>\n",
" <td>Fuel Cell Vehicles (FCV)</td>\n",
" <td>car interior</td>\n",
" <td>use phase, Fuel Cell Vehicles (FCV)</td>\n",
" <td>EoL Fuel Cell Vehicles (FCV)</td>\n",
" <td>shredding: large sized parts</td>\n",
" <td>Al extrusion scrap, auto rims, clean</td>\n",
" <td>production of electricity by petroleum and oth...</td>\n",
" <td>heavy fuel oil</td>\n",
" <td>service input per main output</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1706</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32EEU-FSU</td>\n",
" <td>Cu-Ni-Co mines</td>\n",
" <td>Timber</td>\n",
" <td>iron foundries</td>\n",
" <td>...</td>\n",
" <td>SFH_non-standard</td>\n",
" <td>all building components</td>\n",
" <td>use phase, SFH_non-standard</td>\n",
" <td>EoL SFH_non-standard</td>\n",
" <td>shredding: medium sized parts</td>\n",
" <td>Al extrusion scrap, auto rims, dirty</td>\n",
" <td>production of electricity by biomass and waste</td>\n",
" <td>diesel</td>\n",
" <td>capital costs per capacity, undiscounted</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1707</td>\n",
" <td>N</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32EFTA</td>\n",
" <td>Forests</td>\n",
" <td>Crude oil</td>\n",
" <td>ferrocromium production</td>\n",
" <td>...</td>\n",
" <td>SFH_standard</td>\n",
" <td>building window</td>\n",
" <td>use phase, SFH_standard</td>\n",
" <td>EoL SFH_standard</td>\n",
" <td>shredding: smalle sized parts</td>\n",
" <td>Al old sheet and construction waste</td>\n",
" <td>production of electricity by solar photovoltaic</td>\n",
" <td>jet fuel</td>\n",
" <td>fixed costs per capacity</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1708</td>\n",
" <td>O</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32EU12-H</td>\n",
" <td>Oil fields</td>\n",
" <td>Natural gas</td>\n",
" <td>ferromanganese production</td>\n",
" <td>...</td>\n",
" <td>SFH_efficient</td>\n",
" <td>building roof</td>\n",
" <td>use phase, SFH_efficient</td>\n",
" <td>EoL SFH_efficient</td>\n",
" <td>magnet separation</td>\n",
" <td>Al old cast</td>\n",
" <td>production of electricity by solar thermal</td>\n",
" <td>gasoline</td>\n",
" <td>operating costs per main output</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1709</td>\n",
" <td>F</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32EU12-M</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>ferronickel production</td>\n",
" <td>...</td>\n",
" <td>SFH_ZEB</td>\n",
" <td>building wall_interior</td>\n",
" <td>use phase, SFH_ZEB</td>\n",
" <td>EoL SFH_ZEB</td>\n",
" <td>eddy current separation</td>\n",
" <td>Al turnings (new)</td>\n",
" <td>production of electricity by tide, wave, ocean</td>\n",
" <td>natural gas</td>\n",
" <td>labour costs per main output</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1710</td>\n",
" <td>Ne</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32EU15</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>primary al production</td>\n",
" <td>...</td>\n",
" <td>MFH_non-standard</td>\n",
" <td>building wall_exterior</td>\n",
" <td>use phase, MFH_non-standard</td>\n",
" <td>EoL MFH_non-standard</td>\n",
" <td>electrostatic separation</td>\n",
" <td>bare bright copper scrap (new)</td>\n",
" <td>production of electricity by geothermal</td>\n",
" <td>hydrogen</td>\n",
" <td>capital service per main output</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1711</td>\n",
" <td>Na</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32IDN</td>\n",
" <td>[To be refined at later stage.]</td>\n",
" <td>[To be refined at later stage.]</td>\n",
" <td>Al foundries (remelting)</td>\n",
" <td>...</td>\n",
" <td>MFH_standard</td>\n",
" <td>building floor_interior</td>\n",
" <td>use phase, MFH_standard</td>\n",
" <td>EoL MFH_standard</td>\n",
" <td>air sorter</td>\n",
" <td>#1 Copper scrap</td>\n",
" <td>production of electicity with production mix</td>\n",
" <td>fuel wood</td>\n",
" <td>GHG emissions, supply chain</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1712</td>\n",
" <td>Mg</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32IND</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Al rolling and extrusion</td>\n",
" <td>...</td>\n",
" <td>MFH_efficient</td>\n",
" <td>building floor_exterior</td>\n",
" <td>use phase, MFH_efficient</td>\n",
" <td>EoL MFH_efficient</td>\n",
" <td>hammer mill</td>\n",
" <td>#2 Copper scrap</td>\n",
" <td>production of heat by coal</td>\n",
" <td>nuclear fuel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1713</td>\n",
" <td>Al</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32JPN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>copper smelter</td>\n",
" <td>...</td>\n",
" <td>MFH_ZEB</td>\n",
" <td>NaN</td>\n",
" <td>use phase, MFH_ZEB</td>\n",
" <td>EoL MFH_ZEB</td>\n",
" <td>sieve</td>\n",
" <td>#3 Copper scrap</td>\n",
" <td>production of heat by gas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1714</td>\n",
" <td>Si</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32KOR</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>copper remelting</td>\n",
" <td>...</td>\n",
" <td>informal_non-standard</td>\n",
" <td>NaN</td>\n",
" <td>use phase, informal_non-standard</td>\n",
" <td>EoL informal_non-standard</td>\n",
" <td>incineration</td>\n",
" <td>copper wire scrap</td>\n",
" <td>production of heat by nuclear</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1715</td>\n",
" <td>P</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32LAM-L</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>copper electrolytic refining</td>\n",
" <td>...</td>\n",
" <td>non-residential_non-standard</td>\n",
" <td>NaN</td>\n",
" <td>use phase, non-residential_non-standard</td>\n",
" <td>EoL non-residential_non-standard</td>\n",
" <td>composting</td>\n",
" <td>lead acid batteries</td>\n",
" <td>production of heat by petroleum</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1716</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32LAM-M</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>oil refineries</td>\n",
" <td>...</td>\n",
" <td>non-residential_standard</td>\n",
" <td>NaN</td>\n",
" <td>use phase, non-residential_standard</td>\n",
" <td>EoL non-residential_standard</td>\n",
" <td>biogasification</td>\n",
" <td>Li-Ion batteries</td>\n",
" <td>production of heat by biomass and waste</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1717</td>\n",
" <td>Cl</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32MEA-H</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>polymerisation plants</td>\n",
" <td>...</td>\n",
" <td>non-residential_efficient</td>\n",
" <td>NaN</td>\n",
" <td>use phase, non-residential_efficient</td>\n",
" <td>EoL non-residential_efficient</td>\n",
" <td>landfill</td>\n",
" <td>shredder Light Fraction (SLF)</td>\n",
" <td>production of heat by solar thermal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1718</td>\n",
" <td>Ar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32MEA-M</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>paper mills</td>\n",
" <td>...</td>\n",
" <td>non-residential_ZEB</td>\n",
" <td>NaN</td>\n",
" <td>use phase, non-residential_ZEB</td>\n",
" <td>EoL non-residential_ZEB</td>\n",
" <td>waste mgt. industry</td>\n",
" <td>automobile Shredder Residue (ASR)</td>\n",
" <td>production of heat by geothermal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1719</td>\n",
" <td>K</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32MEX</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>saw mills and wood processing</td>\n",
" <td>...</td>\n",
" <td>Road infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Road infrastructure</td>\n",
" <td>EoL Road infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>construction waste, insulation</td>\n",
" <td>coal mining, hard coal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1720</td>\n",
" <td>Ca</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32NAF</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>bioplastics plants</td>\n",
" <td>...</td>\n",
" <td>Rail infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Rail infrastructure</td>\n",
" <td>EoL Rail infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>construction waste, concrete, bricks, tiles, c...</td>\n",
" <td>coal mining, lignite</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1721</td>\n",
" <td>Sc</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32OAS-CPA</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of steel shred</td>\n",
" <td>...</td>\n",
" <td>Electricity grid</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity grid</td>\n",
" <td>EoL Electricity grid</td>\n",
" <td>NaN</td>\n",
" <td>construction waste, bituminous mixtures, coal ...</td>\n",
" <td>coking plant</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1722</td>\n",
" <td>Ti</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32OAS-L</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of heavy melt, plate, and structural...</td>\n",
" <td>...</td>\n",
" <td>Water infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Water infrastructure</td>\n",
" <td>EoL Water infrastructure</td>\n",
" <td>NaN</td>\n",
" <td>MSW</td>\n",
" <td>oil and gas refinery</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1723</td>\n",
" <td>V</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32OAS-M</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of construction waste, concrete, bri...</td>\n",
" <td>...</td>\n",
" <td>Pipelines</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Pipelines</td>\n",
" <td>EoL Pipelines</td>\n",
" <td>NaN</td>\n",
" <td>glass</td>\n",
" <td>natural gas supply</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1724</td>\n",
" <td>Cr</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32PAK</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of Al old sheet and construction waste</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Solar PV</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Solar PV</td>\n",
" <td>EoL Electricity generation, Solar PV</td>\n",
" <td>NaN</td>\n",
" <td>waste paper</td>\n",
" <td>forestry</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1725</td>\n",
" <td>Mn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32RUS</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of copper wire scrap</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Concentrated Solar Power</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Concentrate...</td>\n",
" <td>EoL Electricity generation, Concentrated Solar...</td>\n",
" <td>NaN</td>\n",
" <td>waste cardboard</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1726</td>\n",
" <td>Fe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32SAF</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of Al extrusion scrap, auto rims, clean</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Wind (onshore)</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Wind (onshore)</td>\n",
" <td>EoL Electricity generation, Wind (onshore)</td>\n",
" <td>NaN</td>\n",
" <td>thermoplastic waste</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1727</td>\n",
" <td>Co</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32SSA-L</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>remelting of Al old cast</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Wind (offshore)</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Wind (offsh...</td>\n",
" <td>EoL Electricity generation, Wind (offshore)</td>\n",
" <td>NaN</td>\n",
" <td>thermosetting plastic waste</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1728</td>\n",
" <td>Ni</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32SSA-M</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>production of construction grade steel, primary</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Hydro</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Hydro</td>\n",
" <td>EoL Electricity generation, Hydro</td>\n",
" <td>NaN</td>\n",
" <td>waste of natural, untreated wood</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1729</td>\n",
" <td>Cu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>R32TUR</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>production of automotive steel, primary</td>\n",
" <td>...</td>\n",
" <td>Electricity generation, Other Renewable</td>\n",
" <td>NaN</td>\n",
" <td>use phase, Electricity generation, Other Renew...</td>\n",
" <td>EoL Electricity generation, Other Renewable</td>\n",
" <td>NaN</td>\n",
" <td>scrap wood</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</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",
" <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",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1271</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2971</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1272</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2972</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1273</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2973</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1274</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2974</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1275</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2975</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1276</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2976</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1277</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2977</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1278</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2978</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1279</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2979</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1280</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2980</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1281</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2981</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1282</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2982</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1283</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2983</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1284</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2984</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1285</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2985</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1286</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2986</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1287</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2987</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1288</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2988</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1289</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2989</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1290</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2990</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1291</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2991</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1292</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2992</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1293</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2993</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1294</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2994</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1295</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2995</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1296</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2996</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1297</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2997</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1298</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2998</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1299</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2999</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1300</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>3000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1301 rows × 22 columns</p>\n",
"</div>"
],
"text/plain": [
" Unity Layer Time Chemical_Elements \\\n",
"Name \n",
"0 1 mass (total mass) 1700 All \n",
"1 NaN mass ratio 1701 H \n",
"2 NaN volume 1702 He \n",
"3 NaN volume ratio 1703 Li \n",
"4 NaN number ratio (items per items) 1704 Be \n",
"5 NaN value per mass (purchaser price) 1705 B \n",
"6 NaN NaN 1706 C \n",
"7 NaN NaN 1707 N \n",
"8 NaN NaN 1708 O \n",
"9 NaN NaN 1709 F \n",
"10 NaN NaN 1710 Ne \n",
"11 NaN NaN 1711 Na \n",
"12 NaN NaN 1712 Mg \n",
"13 NaN NaN 1713 Al \n",
"14 NaN NaN 1714 Si \n",
"15 NaN NaN 1715 P \n",
"16 NaN NaN 1716 S \n",
"17 NaN NaN 1717 Cl \n",
"18 NaN NaN 1718 Ar \n",
"19 NaN NaN 1719 K \n",
"20 NaN NaN 1720 Ca \n",
"21 NaN NaN 1721 Sc \n",
"22 NaN NaN 1722 Ti \n",
"23 NaN NaN 1723 V \n",
"24 NaN NaN 1724 Cr \n",
"25 NaN NaN 1725 Mn \n",
"26 NaN NaN 1726 Fe \n",
"27 NaN NaN 1727 Co \n",
"28 NaN NaN 1728 Ni \n",
"29 NaN NaN 1729 Cu \n",
"... ... ... ... ... \n",
"1271 NaN NaN 2971 NaN \n",
"1272 NaN NaN 2972 NaN \n",
"1273 NaN NaN 2973 NaN \n",
"1274 NaN NaN 2974 NaN \n",
"1275 NaN NaN 2975 NaN \n",
"1276 NaN NaN 2976 NaN \n",
"1277 NaN NaN 2977 NaN \n",
"1278 NaN NaN 2978 NaN \n",
"1279 NaN NaN 2979 NaN \n",
"1280 NaN NaN 2980 NaN \n",
"1281 NaN NaN 2981 NaN \n",
"1282 NaN NaN 2982 NaN \n",
"1283 NaN NaN 2983 NaN \n",
"1284 NaN NaN 2984 NaN \n",
"1285 NaN NaN 2985 NaN \n",
"1286 NaN NaN 2986 NaN \n",
"1287 NaN NaN 2987 NaN \n",
"1288 NaN NaN 2988 NaN \n",
"1289 NaN NaN 2989 NaN \n",
"1290 NaN NaN 2990 NaN \n",
"1291 NaN NaN 2991 NaN \n",
"1292 NaN NaN 2992 NaN \n",
"1293 NaN NaN 2993 NaN \n",
"1294 NaN NaN 2994 NaN \n",
"1295 NaN NaN 2995 NaN \n",
"1296 NaN NaN 2996 NaN \n",
"1297 NaN NaN 2997 NaN \n",
"1298 NaN NaN 2998 NaN \n",
"1299 NaN NaN 2999 NaN \n",
"1300 NaN NaN 3000 NaN \n",
"\n",
" SSP_Scenarios RCP_Scenarios SSP_Regions_32 \\\n",
"Name \n",
"0 SSP1 RCP2.6 R32AUNZ \n",
"1 SSP2 RCP3.4 R32BRA \n",
"2 SSP3 RCP4.5 R32CAN \n",
"3 SSP4 RCP6.0 R32CAS \n",
"4 SSP5 RCP8.5 R32CHN \n",
"5 NaN Baseline(unmitigated) R32EEU \n",
"6 NaN NaN R32EEU-FSU \n",
"7 NaN NaN R32EFTA \n",
"8 NaN NaN R32EU12-H \n",
"9 NaN NaN R32EU12-M \n",
"10 NaN NaN R32EU15 \n",
"11 NaN NaN R32IDN \n",
"12 NaN NaN R32IND \n",
"13 NaN NaN R32JPN \n",
"14 NaN NaN R32KOR \n",
"15 NaN NaN R32LAM-L \n",
"16 NaN NaN R32LAM-M \n",
"17 NaN NaN R32MEA-H \n",
"18 NaN NaN R32MEA-M \n",
"19 NaN NaN R32MEX \n",
"20 NaN NaN R32NAF \n",
"21 NaN NaN R32OAS-CPA \n",
"22 NaN NaN R32OAS-L \n",
"23 NaN NaN R32OAS-M \n",
"24 NaN NaN R32PAK \n",
"25 NaN NaN R32RUS \n",
"26 NaN NaN R32SAF \n",
"27 NaN NaN R32SSA-L \n",
"28 NaN NaN R32SSA-M \n",
"29 NaN NaN R32TUR \n",
"... ... ... ... \n",
"1271 NaN NaN NaN \n",
"1272 NaN NaN NaN \n",
"1273 NaN NaN NaN \n",
"1274 NaN NaN NaN \n",
"1275 NaN NaN NaN \n",
"1276 NaN NaN NaN \n",
"1277 NaN NaN NaN \n",
"1278 NaN NaN NaN \n",
"1279 NaN NaN NaN \n",
"1280 NaN NaN NaN \n",
"1281 NaN NaN NaN \n",
"1282 NaN NaN NaN \n",
"1283 NaN NaN NaN \n",
"1284 NaN NaN NaN \n",
"1285 NaN NaN NaN \n",
"1286 NaN NaN NaN \n",
"1287 NaN NaN NaN \n",
"1288 NaN NaN NaN \n",
"1289 NaN NaN NaN \n",
"1290 NaN NaN NaN \n",
"1291 NaN NaN NaN \n",
"1292 NaN NaN NaN \n",
"1293 NaN NaN NaN \n",
"1294 NaN NaN NaN \n",
"1295 NaN NaN NaN \n",
"1296 NaN NaN NaN \n",
"1297 NaN NaN NaN \n",
"1298 NaN NaN NaN \n",
"1299 NaN NaN NaN \n",
"1300 NaN NaN NaN \n",
"\n",
" Mines_PrimayProd_i1 Ores_RawMaterials_m1 \\\n",
"Name \n",
"0 Limestone quarries Limestone \n",
"1 Iron ore mines Iron ore \n",
"2 Bauxite mines Bauxite \n",
"3 Co mines Oxidic copper ores \n",
"4 Cu-Co mines sulfidic copper ores \n",
"5 Ni-Co mines Nickel ore \n",
"6 Cu-Ni-Co mines Timber \n",
"7 Forests Crude oil \n",
"8 Oil fields Natural gas \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 [To be refined at later stage.] [To be refined at later stage.] \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 NaN NaN \n",
"20 NaN NaN \n",
"21 NaN NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 NaN NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN NaN \n",
"28 NaN NaN \n",
"29 NaN NaN \n",
"... ... ... \n",
"1271 NaN NaN \n",
"1272 NaN NaN \n",
"1273 NaN NaN \n",
"1274 NaN NaN \n",
"1275 NaN NaN \n",
"1276 NaN NaN \n",
"1277 NaN NaN \n",
"1278 NaN NaN \n",
"1279 NaN NaN \n",
"1280 NaN NaN \n",
"1281 NaN NaN \n",
"1282 NaN NaN \n",
"1283 NaN NaN \n",
"1284 NaN NaN \n",
"1285 NaN NaN \n",
"1286 NaN NaN \n",
"1287 NaN NaN \n",
"1288 NaN NaN \n",
"1289 NaN NaN \n",
"1290 NaN NaN \n",
"1291 NaN NaN \n",
"1292 NaN NaN \n",
"1293 NaN NaN \n",
"1294 NaN NaN \n",
"1295 NaN NaN \n",
"1296 NaN NaN \n",
"1297 NaN NaN \n",
"1298 NaN NaN \n",
"1299 NaN NaN \n",
"1300 NaN NaN \n",
"\n",
" Material_Production_i2 ... \\\n",
"Name ... \n",
"0 cement plant (limestone) ... \n",
"1 cement from ash or slag ... \n",
"2 pig iron production (blast furnace) ... \n",
"3 direct iron ore reduction ... \n",
"4 BOF route steel making and remelting ... \n",
"5 EAF route steel making and remelting ... \n",
"6 iron foundries ... \n",
"7 ferrocromium production ... \n",
"8 ferromanganese production ... \n",
"9 ferronickel production ... \n",
"10 primary al production ... \n",
"11 Al foundries (remelting) ... \n",
"12 Al rolling and extrusion ... \n",
"13 copper smelter ... \n",
"14 copper remelting ... \n",
"15 copper electrolytic refining ... \n",
"16 oil refineries ... \n",
"17 polymerisation plants ... \n",
"18 paper mills ... \n",
"19 saw mills and wood processing ... \n",
"20 bioplastics plants ... \n",
"21 remelting of steel shred ... \n",
"22 remelting of heavy melt, plate, and structural... ... \n",
"23 remelting of construction waste, concrete, bri... ... \n",
"24 remelting of Al old sheet and construction waste ... \n",
"25 remelting of copper wire scrap ... \n",
"26 remelting of Al extrusion scrap, auto rims, clean ... \n",
"27 remelting of Al old cast ... \n",
"28 production of construction grade steel, primary ... \n",
"29 production of automotive steel, primary ... \n",
"... ... ... \n",
"1271 NaN ... \n",
"1272 NaN ... \n",
"1273 NaN ... \n",
"1274 NaN ... \n",
"1275 NaN ... \n",
"1276 NaN ... \n",
"1277 NaN ... \n",
"1278 NaN ... \n",
"1279 NaN ... \n",
"1280 NaN ... \n",
"1281 NaN ... \n",
"1282 NaN ... \n",
"1283 NaN ... \n",
"1284 NaN ... \n",
"1285 NaN ... \n",
"1286 NaN ... \n",
"1287 NaN ... \n",
"1288 NaN ... \n",
"1289 NaN ... \n",
"1290 NaN ... \n",
"1291 NaN ... \n",
"1292 NaN ... \n",
"1293 NaN ... \n",
"1294 NaN ... \n",
"1295 NaN ... \n",
"1296 NaN ... \n",
"1297 NaN ... \n",
"1298 NaN ... \n",
"1299 NaN ... \n",
"1300 NaN ... \n",
"\n",
" Products_m3 \\\n",
"Name \n",
"0 Internal Combustion Engine, gasoline (ICEG) \n",
"1 Internal Combustion Engine, diesel (ICED) \n",
"2 Hybrid Electric Vehicles (HEV) \n",
"3 Plugin Hybrid Electric Vehicles (PHEV) \n",
"4 Battery Electric Vehicles (BEV) \n",
"5 Fuel Cell Vehicles (FCV) \n",
"6 SFH_non-standard \n",
"7 SFH_standard \n",
"8 SFH_efficient \n",
"9 SFH_ZEB \n",
"10 MFH_non-standard \n",
"11 MFH_standard \n",
"12 MFH_efficient \n",
"13 MFH_ZEB \n",
"14 informal_non-standard \n",
"15 non-residential_non-standard \n",
"16 non-residential_standard \n",
"17 non-residential_efficient \n",
"18 non-residential_ZEB \n",
"19 Road infrastructure \n",
"20 Rail infrastructure \n",
"21 Electricity grid \n",
"22 Water infrastructure \n",
"23 Pipelines \n",
"24 Electricity generation, Solar PV \n",
"25 Electricity generation, Concentrated Solar Power \n",
"26 Electricity generation, Wind (onshore) \n",
"27 Electricity generation, Wind (offshore) \n",
"28 Electricity generation, Hydro \n",
"29 Electricity generation, Other Renewable \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" Products_components_m3 \\\n",
"Name \n",
"0 all vehicle components \n",
"1 vehicle body \n",
"2 drive train incl. suspension \n",
"3 vehicle battery \n",
"4 car electronics \n",
"5 car interior \n",
"6 all building components \n",
"7 building window \n",
"8 building roof \n",
"9 building wall_interior \n",
"10 building wall_exterior \n",
"11 building floor_interior \n",
"12 building floor_exterior \n",
"13 NaN \n",
"14 NaN \n",
"15 NaN \n",
"16 NaN \n",
"17 NaN \n",
"18 NaN \n",
"19 NaN \n",
"20 NaN \n",
"21 NaN \n",
"22 NaN \n",
"23 NaN \n",
"24 NaN \n",
"25 NaN \n",
"26 NaN \n",
"27 NaN \n",
"28 NaN \n",
"29 NaN \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" Use_Phase_i4 \\\n",
"Name \n",
"0 use phase, Internal Combustion Engine, gasolin... \n",
"1 use phase, Internal Combustion Engine, diesel ... \n",
"2 use phase, Hybrid Electric Vehicles (HEV) \n",
"3 use phase, Plugin Hybrid Electric Vehicles (PHEV) \n",
"4 use phase, Battery Electric Vehicles (BEV) \n",
"5 use phase, Fuel Cell Vehicles (FCV) \n",
"6 use phase, SFH_non-standard \n",
"7 use phase, SFH_standard \n",
"8 use phase, SFH_efficient \n",
"9 use phase, SFH_ZEB \n",
"10 use phase, MFH_non-standard \n",
"11 use phase, MFH_standard \n",
"12 use phase, MFH_efficient \n",
"13 use phase, MFH_ZEB \n",
"14 use phase, informal_non-standard \n",
"15 use phase, non-residential_non-standard \n",
"16 use phase, non-residential_standard \n",
"17 use phase, non-residential_efficient \n",
"18 use phase, non-residential_ZEB \n",
"19 use phase, Road infrastructure \n",
"20 use phase, Rail infrastructure \n",
"21 use phase, Electricity grid \n",
"22 use phase, Water infrastructure \n",
"23 use phase, Pipelines \n",
"24 use phase, Electricity generation, Solar PV \n",
"25 use phase, Electricity generation, Concentrate... \n",
"26 use phase, Electricity generation, Wind (onshore) \n",
"27 use phase, Electricity generation, Wind (offsh... \n",
"28 use phase, Electricity generation, Hydro \n",
"29 use phase, Electricity generation, Other Renew... \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" EoL_Products_m4 \\\n",
"Name \n",
"0 EoL Internal Combustion Engine, gasoline (ICEG) \n",
"1 EoL Internal Combustion Engine, diesel (ICED) \n",
"2 EoL Hybrid Electric Vehicles (HEV) \n",
"3 EoL Plugin Hybrid Electric Vehicles (PHEV) \n",
"4 EoL Battery Electric Vehicles (BEV) \n",
"5 EoL Fuel Cell Vehicles (FCV) \n",
"6 EoL SFH_non-standard \n",
"7 EoL SFH_standard \n",
"8 EoL SFH_efficient \n",
"9 EoL SFH_ZEB \n",
"10 EoL MFH_non-standard \n",
"11 EoL MFH_standard \n",
"12 EoL MFH_efficient \n",
"13 EoL MFH_ZEB \n",
"14 EoL informal_non-standard \n",
"15 EoL non-residential_non-standard \n",
"16 EoL non-residential_standard \n",
"17 EoL non-residential_efficient \n",
"18 EoL non-residential_ZEB \n",
"19 EoL Road infrastructure \n",
"20 EoL Rail infrastructure \n",
"21 EoL Electricity grid \n",
"22 EoL Water infrastructure \n",
"23 EoL Pipelines \n",
"24 EoL Electricity generation, Solar PV \n",
"25 EoL Electricity generation, Concentrated Solar... \n",
"26 EoL Electricity generation, Wind (onshore) \n",
"27 EoL Electricity generation, Wind (offshore) \n",
"28 EoL Electricity generation, Hydro \n",
"29 EoL Electricity generation, Other Renewable \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" Waste_Mgt_Industries_i5 \\\n",
"Name \n",
"0 food waste sorting \n",
"1 MSW sorting \n",
"2 deconstruction \n",
"3 dismantling \n",
"4 sorting (hand) \n",
"5 shredding: large sized parts \n",
"6 shredding: medium sized parts \n",
"7 shredding: smalle sized parts \n",
"8 magnet separation \n",
"9 eddy current separation \n",
"10 electrostatic separation \n",
"11 air sorter \n",
"12 hammer mill \n",
"13 sieve \n",
"14 incineration \n",
"15 composting \n",
"16 biogasification \n",
"17 landfill \n",
"18 waste mgt. industry \n",
"19 NaN \n",
"20 NaN \n",
"21 NaN \n",
"22 NaN \n",
"23 NaN \n",
"24 NaN \n",
"25 NaN \n",
"26 NaN \n",
"27 NaN \n",
"28 NaN \n",
"29 NaN \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" Waste_Scrap_m5 \\\n",
"Name \n",
"0 heavy melt, plate, and structural steel scrap \n",
"1 steel shred \n",
"2 stainless steel scrap \n",
"3 steel casting scrap \n",
"4 turnings and busheling fabrication steel scrap \n",
"5 Al extrusion scrap, auto rims, clean \n",
"6 Al extrusion scrap, auto rims, dirty \n",
"7 Al old sheet and construction waste \n",
"8 Al old cast \n",
"9 Al turnings (new) \n",
"10 bare bright copper scrap (new) \n",
"11 #1 Copper scrap \n",
"12 #2 Copper scrap \n",
"13 #3 Copper scrap \n",
"14 copper wire scrap \n",
"15 lead acid batteries \n",
"16 Li-Ion batteries \n",
"17 shredder Light Fraction (SLF) \n",
"18 automobile Shredder Residue (ASR) \n",
"19 construction waste, insulation \n",
"20 construction waste, concrete, bricks, tiles, c... \n",
"21 construction waste, bituminous mixtures, coal ... \n",
"22 MSW \n",
"23 glass \n",
"24 waste paper \n",
"25 waste cardboard \n",
"26 thermoplastic waste \n",
"27 thermosetting plastic waste \n",
"28 waste of natural, untreated wood \n",
"29 scrap wood \n",
"... ... \n",
"1271 NaN \n",
"1272 NaN \n",
"1273 NaN \n",
"1274 NaN \n",
"1275 NaN \n",
"1276 NaN \n",
"1277 NaN \n",
"1278 NaN \n",
"1279 NaN \n",
"1280 NaN \n",
"1281 NaN \n",
"1282 NaN \n",
"1283 NaN \n",
"1284 NaN \n",
"1285 NaN \n",
"1286 NaN \n",
"1287 NaN \n",
"1288 NaN \n",
"1289 NaN \n",
"1290 NaN \n",
"1291 NaN \n",
"1292 NaN \n",
"1293 NaN \n",
"1294 NaN \n",
"1295 NaN \n",
"1296 NaN \n",
"1297 NaN \n",
"1298 NaN \n",
"1299 NaN \n",
"1300 NaN \n",
"\n",
" Energy_Supply_Industries_i6 Energy_Carriers_m6 \\\n",
"Name \n",
"0 production of electricity by coal electricity \n",
"1 production of electricity by gas heat \n",
"2 production of electricity by nuclear coal, hard coal \n",
"3 production of electricity by hydro coal, lignite \n",
"4 production of electricity by wind coke \n",
"5 production of electricity by petroleum and oth... heavy fuel oil \n",
"6 production of electricity by biomass and waste diesel \n",
"7 production of electricity by solar photovoltaic jet fuel \n",
"8 production of electricity by solar thermal gasoline \n",
"9 production of electricity by tide, wave, ocean natural gas \n",
"10 production of electricity by geothermal hydrogen \n",
"11 production of electicity with production mix fuel wood \n",
"12 production of heat by coal nuclear fuel \n",
"13 production of heat by gas NaN \n",
"14 production of heat by nuclear NaN \n",
"15 production of heat by petroleum NaN \n",
"16 production of heat by biomass and waste NaN \n",
"17 production of heat by solar thermal NaN \n",
"18 production of heat by geothermal NaN \n",
"19 coal mining, hard coal NaN \n",
"20 coal mining, lignite NaN \n",
"21 coking plant NaN \n",
"22 oil and gas refinery NaN \n",
"23 natural gas supply NaN \n",
"24 forestry NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN NaN \n",
"28 NaN NaN \n",
"29 NaN NaN \n",
"... ... ... \n",
"1271 NaN NaN \n",
"1272 NaN NaN \n",
"1273 NaN NaN \n",
"1274 NaN NaN \n",
"1275 NaN NaN \n",
"1276 NaN NaN \n",
"1277 NaN NaN \n",
"1278 NaN NaN \n",
"1279 NaN NaN \n",
"1280 NaN NaN \n",
"1281 NaN NaN \n",
"1282 NaN NaN \n",
"1283 NaN NaN \n",
"1284 NaN NaN \n",
"1285 NaN NaN \n",
"1286 NaN NaN \n",
"1287 NaN NaN \n",
"1288 NaN NaN \n",
"1289 NaN NaN \n",
"1290 NaN NaN \n",
"1291 NaN NaN \n",
"1292 NaN NaN \n",
"1293 NaN NaN \n",
"1294 NaN NaN \n",
"1295 NaN NaN \n",
"1296 NaN NaN \n",
"1297 NaN NaN \n",
"1298 NaN NaN \n",
"1299 NaN NaN \n",
"1300 NaN NaN \n",
"\n",
" Process_Extensions SSP_Population_Models \n",
"Name \n",
"0 CO2 emisisons per main output IIASA GDP \n",
"1 CH4 emissions per main output IIASA-WiC POP \n",
"2 N2O emissions per main output NCAR \n",
"3 SF6 emisisons per main output OECD Env-Growth \n",
"4 GHG emissions PIK GDP-32 \n",
"5 service input per main output NaN \n",
"6 capital costs per capacity, undiscounted NaN \n",
"7 fixed costs per capacity NaN \n",
"8 operating costs per main output NaN \n",
"9 labour costs per main output NaN \n",
"10 capital service per main output NaN \n",
"11 GHG emissions, supply chain NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 NaN NaN \n",
"20 NaN NaN \n",
"21 NaN NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 NaN NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN NaN \n",
"28 NaN NaN \n",
"29 NaN NaN \n",
"... ... ... \n",
"1271 NaN NaN \n",
"1272 NaN NaN \n",
"1273 NaN NaN \n",
"1274 NaN NaN \n",
"1275 NaN NaN \n",
"1276 NaN NaN \n",
"1277 NaN NaN \n",
"1278 NaN NaN \n",
"1279 NaN NaN \n",
"1280 NaN NaN \n",
"1281 NaN NaN \n",
"1282 NaN NaN \n",
"1283 NaN NaN \n",
"1284 NaN NaN \n",
"1285 NaN NaN \n",
"1286 NaN NaN \n",
"1287 NaN NaN \n",
"1288 NaN NaN \n",
"1289 NaN NaN \n",
"1290 NaN NaN \n",
"1291 NaN NaN \n",
"1292 NaN NaN \n",
"1293 NaN NaN \n",
"1294 NaN NaN \n",
"1295 NaN NaN \n",
"1296 NaN NaN \n",
"1297 NaN NaN \n",
"1298 NaN NaN \n",
"1299 NaN NaN \n",
"1300 NaN NaN \n",
"\n",
"[1301 rows x 22 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's load all master classifications and clean up a bit\n",
"fname = \"/Users/n/Dropbox (Yale_FES)/G7 RECC/Data/RECC_Database/RECC_Classifications_Master_V1.0.xlsx\"\n",
"sheet = \"MAIN_Table\"\n",
"drop_rows = ['Dimension', 'Description', 'ID', 'UUID', 'Date created',\n",
" 'Last modified', 'Last modified by', 'Reference', 'Items']\n",
"master_class = pd.read_excel(fname, sheet_name=sheet, \n",
" header=[0], index_col=[0]).drop(drop_rows, axis=0)\n",
"master_class "
]
},
{
"cell_type": "code",
"execution_count": 9,
"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 tr th {\n",
" text-align: left;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th>Value</th>\n",
" <th colspan=\"5\" halign=\"left\">R32AUNZ</th>\n",
" <th colspan=\"5\" halign=\"left\">R32BRA</th>\n",
" <th>...</th>\n",
" <th colspan=\"5\" halign=\"left\">R32TWN</th>\n",
" <th colspan=\"5\" halign=\"left\">R32USA</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th>SSP1</th>\n",
" <th>SSP2</th>\n",
" <th>SSP3</th>\n",
" <th>SSP4</th>\n",
" <th>SSP5</th>\n",
" <th>SSP1</th>\n",
" <th>SSP2</th>\n",
" <th>SSP3</th>\n",
" <th>SSP4</th>\n",
" <th>SSP5</th>\n",
" <th>...</th>\n",
" <th>SSP1</th>\n",
" <th>SSP2</th>\n",
" <th>SSP3</th>\n",
" <th>SSP4</th>\n",
" <th>SSP5</th>\n",
" <th>SSP1</th>\n",
" <th>SSP2</th>\n",
" <th>SSP3</th>\n",
" <th>SSP4</th>\n",
" <th>SSP5</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"30\" valign=\"top\">IIASA GDP</th>\n",
" <th>1980</th>\n",
" <td>348.595503</td>\n",
" <td>348.595503</td>\n",
" <td>348.595503</td>\n",
" <td>348.595503</td>\n",
" <td>348.595503</td>\n",
" <td>920.935005</td>\n",
" <td>920.935005</td>\n",
" <td>920.935005</td>\n",
" <td>920.935005</td>\n",
" <td>920.935005</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5128.000000</td>\n",
" <td>5128.000000</td>\n",
" <td>5128.000000</td>\n",
" <td>5128.000000</td>\n",
" <td>5128.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1981</th>\n",
" <td>352.675037</td>\n",
" <td>352.671574</td>\n",
" <td>352.745241</td>\n",
" <td>352.668146</td>\n",
" <td>352.671687</td>\n",
" <td>930.776566</td>\n",
" <td>930.786336</td>\n",
" <td>930.782441</td>\n",
" <td>930.791813</td>\n",
" <td>930.776813</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5456.797649</td>\n",
" <td>5456.763261</td>\n",
" <td>5456.901178</td>\n",
" <td>5456.732988</td>\n",
" <td>5456.767567</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1982</th>\n",
" <td>360.639880</td>\n",
" <td>360.635556</td>\n",
" <td>360.727574</td>\n",
" <td>360.631274</td>\n",
" <td>360.635694</td>\n",
" <td>940.156335</td>\n",
" <td>940.168537</td>\n",
" <td>940.163675</td>\n",
" <td>940.175384</td>\n",
" <td>940.156642</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5799.003180</td>\n",
" <td>5798.960233</td>\n",
" <td>5799.132516</td>\n",
" <td>5798.922424</td>\n",
" <td>5798.965587</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1983</th>\n",
" <td>371.679845</td>\n",
" <td>371.676390</td>\n",
" <td>371.749927</td>\n",
" <td>371.672969</td>\n",
" <td>371.676496</td>\n",
" <td>949.722641</td>\n",
" <td>949.732391</td>\n",
" <td>949.728509</td>\n",
" <td>949.737868</td>\n",
" <td>949.722884</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6143.569887</td>\n",
" <td>6143.535575</td>\n",
" <td>6143.673267</td>\n",
" <td>6143.505365</td>\n",
" <td>6143.539824</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1984</th>\n",
" <td>384.984742</td>\n",
" <td>384.983018</td>\n",
" <td>385.019721</td>\n",
" <td>384.981311</td>\n",
" <td>384.983067</td>\n",
" <td>960.123814</td>\n",
" <td>960.128679</td>\n",
" <td>960.126744</td>\n",
" <td>960.131418</td>\n",
" <td>960.123933</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6479.451063</td>\n",
" <td>6479.433945</td>\n",
" <td>6479.502678</td>\n",
" <td>6479.418871</td>\n",
" <td>6479.436040</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1985</th>\n",
" <td>399.744381</td>\n",
" <td>399.744381</td>\n",
" <td>399.744381</td>\n",
" <td>399.744381</td>\n",
" <td>399.744381</td>\n",
" <td>972.008183</td>\n",
" <td>972.008183</td>\n",
" <td>972.008183</td>\n",
" <td>972.008183</td>\n",
" <td>972.008183</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6795.600000</td>\n",
" <td>6795.600000</td>\n",
" <td>6795.600000</td>\n",
" <td>6795.600000</td>\n",
" <td>6795.600000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1986</th>\n",
" <td>415.202773</td>\n",
" <td>415.203795</td>\n",
" <td>415.181980</td>\n",
" <td>415.204808</td>\n",
" <td>415.203777</td>\n",
" <td>986.002754</td>\n",
" <td>985.999866</td>\n",
" <td>986.001006</td>\n",
" <td>985.998222</td>\n",
" <td>986.002689</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7083.120981</td>\n",
" <td>7083.131130</td>\n",
" <td>7083.090251</td>\n",
" <td>7083.140073</td>\n",
" <td>7083.129965</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1987</th>\n",
" <td>430.820726</td>\n",
" <td>430.822076</td>\n",
" <td>430.793206</td>\n",
" <td>430.823415</td>\n",
" <td>430.822064</td>\n",
" <td>1002.649235</td>\n",
" <td>1002.645418</td>\n",
" <td>1002.646917</td>\n",
" <td>1002.643225</td>\n",
" <td>1002.649156</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7341.722245</td>\n",
" <td>7341.735649</td>\n",
" <td>7341.681520</td>\n",
" <td>7341.747469</td>\n",
" <td>7341.734191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1988</th>\n",
" <td>446.113248</td>\n",
" <td>446.114415</td>\n",
" <td>446.089397</td>\n",
" <td>446.115573</td>\n",
" <td>446.114418</td>\n",
" <td>1022.468012</td>\n",
" <td>1022.464709</td>\n",
" <td>1022.465997</td>\n",
" <td>1022.462790</td>\n",
" <td>1022.467951</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7573.263017</td>\n",
" <td>7573.274604</td>\n",
" <td>7573.227663</td>\n",
" <td>7573.284828</td>\n",
" <td>7573.273435</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1989</th>\n",
" <td>460.595346</td>\n",
" <td>460.596002</td>\n",
" <td>460.581892</td>\n",
" <td>460.596653</td>\n",
" <td>460.596014</td>\n",
" <td>1045.979470</td>\n",
" <td>1045.977611</td>\n",
" <td>1045.978328</td>\n",
" <td>1045.976514</td>\n",
" <td>1045.979441</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7779.602527</td>\n",
" <td>7779.609039</td>\n",
" <td>7779.582537</td>\n",
" <td>7779.614791</td>\n",
" <td>7779.608453</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1990</th>\n",
" <td>473.782028</td>\n",
" <td>473.782028</td>\n",
" <td>473.782028</td>\n",
" <td>473.782028</td>\n",
" <td>473.782028</td>\n",
" <td>1073.703993</td>\n",
" <td>1073.703993</td>\n",
" <td>1073.703993</td>\n",
" <td>1073.703993</td>\n",
" <td>1073.703993</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7962.600000</td>\n",
" <td>7962.600000</td>\n",
" <td>7962.600000</td>\n",
" <td>7962.600000</td>\n",
" <td>7962.600000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1991</th>\n",
" <td>485.455000</td>\n",
" <td>485.454374</td>\n",
" <td>485.467966</td>\n",
" <td>485.453751</td>\n",
" <td>485.454333</td>\n",
" <td>1105.802928</td>\n",
" <td>1105.804707</td>\n",
" <td>1105.804042</td>\n",
" <td>1105.805807</td>\n",
" <td>1105.802940</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8127.533626</td>\n",
" <td>8127.527419</td>\n",
" <td>8127.553018</td>\n",
" <td>8127.521918</td>\n",
" <td>8127.527775</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1992</th>\n",
" <td>496.462764</td>\n",
" <td>496.461688</td>\n",
" <td>496.485149</td>\n",
" <td>496.460616</td>\n",
" <td>496.461598</td>\n",
" <td>1141.001457</td>\n",
" <td>1141.004522</td>\n",
" <td>1141.003389</td>\n",
" <td>1141.006446</td>\n",
" <td>1141.001468</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8293.357442</td>\n",
" <td>8293.346770</td>\n",
" <td>8293.391005</td>\n",
" <td>8293.337301</td>\n",
" <td>8293.347248</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1993</th>\n",
" <td>507.920522</td>\n",
" <td>507.919307</td>\n",
" <td>507.945842</td>\n",
" <td>507.918098</td>\n",
" <td>507.919190</td>\n",
" <td>1177.665725</td>\n",
" <td>1177.669186</td>\n",
" <td>1177.667918</td>\n",
" <td>1177.671386</td>\n",
" <td>1177.665728</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8482.444444</td>\n",
" <td>8482.432411</td>\n",
" <td>8482.482482</td>\n",
" <td>8482.421724</td>\n",
" <td>8482.432834</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1994</th>\n",
" <td>520.943473</td>\n",
" <td>520.942571</td>\n",
" <td>520.962310</td>\n",
" <td>520.941673</td>\n",
" <td>520.942474</td>\n",
" <td>1214.161877</td>\n",
" <td>1214.164447</td>\n",
" <td>1214.163512</td>\n",
" <td>1214.166098</td>\n",
" <td>1214.161874</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8717.167631</td>\n",
" <td>8717.158701</td>\n",
" <td>8717.195973</td>\n",
" <td>8717.150764</td>\n",
" <td>8717.158947</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1995</th>\n",
" <td>536.646818</td>\n",
" <td>536.646818</td>\n",
" <td>536.646818</td>\n",
" <td>536.646818</td>\n",
" <td>536.646818</td>\n",
" <td>1248.856055</td>\n",
" <td>1248.856055</td>\n",
" <td>1248.856055</td>\n",
" <td>1248.856055</td>\n",
" <td>1248.856055</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>9019.900000</td>\n",
" <td>9019.900000</td>\n",
" <td>9019.900000</td>\n",
" <td>9019.900000</td>\n",
" <td>9019.900000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1996</th>\n",
" <td>555.839508</td>\n",
" <td>555.840990</td>\n",
" <td>555.808438</td>\n",
" <td>555.842468</td>\n",
" <td>555.841171</td>\n",
" <td>1280.445896</td>\n",
" <td>1280.441665</td>\n",
" <td>1280.443189</td>\n",
" <td>1280.438913</td>\n",
" <td>1280.445913</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>9403.662113</td>\n",
" <td>9403.676793</td>\n",
" <td>9403.615275</td>\n",
" <td>9403.689853</td>\n",
" <td>9403.676536</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1997</th>\n",
" <td>578.105493</td>\n",
" <td>578.108450</td>\n",
" <td>578.043476</td>\n",
" <td>578.111399</td>\n",
" <td>578.108820</td>\n",
" <td>1308.955002</td>\n",
" <td>1308.946560</td>\n",
" <td>1308.949594</td>\n",
" <td>1308.941055</td>\n",
" <td>1308.955039</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>9844.064789</td>\n",
" <td>9844.094072</td>\n",
" <td>9843.971261</td>\n",
" <td>9844.120129</td>\n",
" <td>9844.093615</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1998</th>\n",
" <td>602.722473</td>\n",
" <td>602.726164</td>\n",
" <td>602.645043</td>\n",
" <td>602.729845</td>\n",
" <td>602.726631</td>\n",
" <td>1334.738466</td>\n",
" <td>1334.727928</td>\n",
" <td>1334.731711</td>\n",
" <td>1334.721046</td>\n",
" <td>1334.738516</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>10307.366407</td>\n",
" <td>10307.402954</td>\n",
" <td>10307.249610</td>\n",
" <td>10307.435478</td>\n",
" <td>10307.402427</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1999</th>\n",
" <td>628.968148</td>\n",
" <td>628.971098</td>\n",
" <td>628.906253</td>\n",
" <td>628.974040</td>\n",
" <td>628.971475</td>\n",
" <td>1358.151381</td>\n",
" <td>1358.142958</td>\n",
" <td>1358.145980</td>\n",
" <td>1358.137453</td>\n",
" <td>1358.151423</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>10759.825350</td>\n",
" <td>10759.854558</td>\n",
" <td>10759.731972</td>\n",
" <td>10759.880551</td>\n",
" <td>10759.854159</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000</th>\n",
" <td>656.120219</td>\n",
" <td>656.120219</td>\n",
" <td>656.120219</td>\n",
" <td>656.120219</td>\n",
" <td>656.120219</td>\n",
" <td>1379.548841</td>\n",
" <td>1379.548841</td>\n",
" <td>1379.548841</td>\n",
" <td>1379.548841</td>\n",
" <td>1379.548841</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>11167.700000</td>\n",
" <td>11167.700000</td>\n",
" <td>11167.700000</td>\n",
" <td>11167.700000</td>\n",
" <td>11167.700000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2001</th>\n",
" <td>683.386705</td>\n",
" <td>683.381402</td>\n",
" <td>683.498019</td>\n",
" <td>683.376113</td>\n",
" <td>683.380718</td>\n",
" <td>1400.197218</td>\n",
" <td>1400.212363</td>\n",
" <td>1400.206935</td>\n",
" <td>1400.222273</td>\n",
" <td>1400.197140</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>11507.027520</td>\n",
" <td>11506.975008</td>\n",
" <td>11507.195481</td>\n",
" <td>11506.928270</td>\n",
" <td>11506.975680</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2002</th>\n",
" <td>709.696914</td>\n",
" <td>709.686162</td>\n",
" <td>709.922599</td>\n",
" <td>709.675439</td>\n",
" <td>709.684774</td>\n",
" <td>1425.007996</td>\n",
" <td>1425.038701</td>\n",
" <td>1425.027698</td>\n",
" <td>1425.058797</td>\n",
" <td>1425.007836</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>11792.960203</td>\n",
" <td>11792.853742</td>\n",
" <td>11793.300750</td>\n",
" <td>11792.758985</td>\n",
" <td>11792.855090</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2003</th>\n",
" <td>733.910472</td>\n",
" <td>733.896923</td>\n",
" <td>734.194872</td>\n",
" <td>733.883410</td>\n",
" <td>733.895172</td>\n",
" <td>1459.803938</td>\n",
" <td>1459.842631</td>\n",
" <td>1459.828766</td>\n",
" <td>1459.867957</td>\n",
" <td>1459.803735</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12050.429127</td>\n",
" <td>12050.294972</td>\n",
" <td>12050.858279</td>\n",
" <td>12050.175565</td>\n",
" <td>12050.296659</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2004</th>\n",
" <td>754.887007</td>\n",
" <td>754.876109</td>\n",
" <td>755.115749</td>\n",
" <td>754.865241</td>\n",
" <td>754.874700</td>\n",
" <td>1510.407806</td>\n",
" <td>1510.438926</td>\n",
" <td>1510.427775</td>\n",
" <td>1510.459298</td>\n",
" <td>1510.407643</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12304.365367</td>\n",
" <td>12304.257468</td>\n",
" <td>12304.710538</td>\n",
" <td>12304.161430</td>\n",
" <td>12304.258819</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2005</th>\n",
" <td>771.486144</td>\n",
" <td>771.486144</td>\n",
" <td>771.486144</td>\n",
" <td>771.486144</td>\n",
" <td>771.486144</td>\n",
" <td>1582.642363</td>\n",
" <td>1582.642363</td>\n",
" <td>1582.642363</td>\n",
" <td>1582.642363</td>\n",
" <td>1582.642363</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12579.700000</td>\n",
" <td>12579.700000</td>\n",
" <td>12579.700000</td>\n",
" <td>12579.700000</td>\n",
" <td>12579.700000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2006</th>\n",
" <td>784.905864</td>\n",
" <td>784.923725</td>\n",
" <td>784.530946</td>\n",
" <td>784.941538</td>\n",
" <td>784.926036</td>\n",
" <td>1676.709708</td>\n",
" <td>1676.658701</td>\n",
" <td>1676.676977</td>\n",
" <td>1676.625310</td>\n",
" <td>1676.709977</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12878.430582</td>\n",
" <td>12878.607429</td>\n",
" <td>12877.864827</td>\n",
" <td>12878.764837</td>\n",
" <td>12878.605227</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2007</th>\n",
" <td>805.697554</td>\n",
" <td>805.722642</td>\n",
" <td>805.170957</td>\n",
" <td>805.747661</td>\n",
" <td>805.725888</td>\n",
" <td>1770.329279</td>\n",
" <td>1770.257637</td>\n",
" <td>1770.283306</td>\n",
" <td>1770.210736</td>\n",
" <td>1770.329657</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>13110.820595</td>\n",
" <td>13111.068988</td>\n",
" <td>13110.025953</td>\n",
" <td>13111.290077</td>\n",
" <td>13111.065896</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2008</th>\n",
" <td>846.750955</td>\n",
" <td>846.750955</td>\n",
" <td>846.750955</td>\n",
" <td>846.750955</td>\n",
" <td>846.750955</td>\n",
" <td>1835.599851</td>\n",
" <td>1835.599851</td>\n",
" <td>1835.599851</td>\n",
" <td>1835.599851</td>\n",
" <td>1835.599851</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>13164.200000</td>\n",
" <td>13164.200000</td>\n",
" <td>13164.200000</td>\n",
" <td>13164.200000</td>\n",
" <td>13164.200000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2009</th>\n",
" <td>915.222288</td>\n",
" <td>915.172438</td>\n",
" <td>916.268679</td>\n",
" <td>915.122721</td>\n",
" <td>915.165987</td>\n",
" <td>1855.851624</td>\n",
" <td>1855.993982</td>\n",
" <td>1855.942976</td>\n",
" <td>1856.087179</td>\n",
" <td>1855.850872</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12981.248647</td>\n",
" <td>12980.755071</td>\n",
" <td>12982.827666</td>\n",
" <td>12980.315751</td>\n",
" <td>12980.761212</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <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",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"30\" valign=\"top\">PIK GDP-32</th>\n",
" <th>2071</th>\n",
" <td>3453.120951</td>\n",
" <td>3561.199114</td>\n",
" <td>1865.574029</td>\n",
" <td>3388.873126</td>\n",
" <td>6097.778939</td>\n",
" <td>9861.994926</td>\n",
" <td>9094.230231</td>\n",
" <td>5925.529631</td>\n",
" <td>8009.412767</td>\n",
" <td>12011.251117</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>32674.333180</td>\n",
" <td>33957.963661</td>\n",
" <td>19291.479925</td>\n",
" <td>32532.920443</td>\n",
" <td>54205.933142</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2072</th>\n",
" <td>3486.981624</td>\n",
" <td>3602.006284</td>\n",
" <td>1860.651323</td>\n",
" <td>3415.354884</td>\n",
" <td>6248.080563</td>\n",
" <td>9972.726523</td>\n",
" <td>9240.826758</td>\n",
" <td>5993.374641</td>\n",
" <td>8082.623308</td>\n",
" <td>12234.425785</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>33003.097496</td>\n",
" <td>34332.766809</td>\n",
" <td>19240.642846</td>\n",
" <td>32770.440019</td>\n",
" <td>55541.382337</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2073</th>\n",
" <td>3519.446534</td>\n",
" <td>3641.536856</td>\n",
" <td>1854.575008</td>\n",
" <td>3440.132035</td>\n",
" <td>6399.986945</td>\n",
" <td>10080.880609</td>\n",
" <td>9388.263599</td>\n",
" <td>6061.813651</td>\n",
" <td>8154.329928</td>\n",
" <td>12458.732634</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>33328.767984</td>\n",
" <td>34704.560280</td>\n",
" <td>19183.861726</td>\n",
" <td>33000.242236</td>\n",
" <td>56907.051928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2074</th>\n",
" <td>3550.604154</td>\n",
" <td>3679.835657</td>\n",
" <td>1847.469269</td>\n",
" <td>3463.293147</td>\n",
" <td>6553.570635</td>\n",
" <td>10186.212341</td>\n",
" <td>9536.184177</td>\n",
" <td>6130.654445</td>\n",
" <td>8224.267742</td>\n",
" <td>12683.944925</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>33651.848173</td>\n",
" <td>35073.584090</td>\n",
" <td>19121.930786</td>\n",
" <td>33222.975744</td>\n",
" <td>58303.710941</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2075</th>\n",
" <td>3580.542956</td>\n",
" <td>3716.947516</td>\n",
" <td>1839.458293</td>\n",
" <td>3484.926788</td>\n",
" <td>6708.904179</td>\n",
" <td>10288.476872</td>\n",
" <td>9684.231913</td>\n",
" <td>6199.704804</td>\n",
" <td>8292.171865</td>\n",
" <td>12909.835916</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>33972.841591</td>\n",
" <td>35440.078257</td>\n",
" <td>19055.644244</td>\n",
" <td>33439.289193</td>\n",
" <td>59732.128407</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2076</th>\n",
" <td>3609.351413</td>\n",
" <td>3752.917262</td>\n",
" <td>1830.666266</td>\n",
" <td>3505.121524</td>\n",
" <td>6866.060125</td>\n",
" <td>10387.429360</td>\n",
" <td>9832.050228</td>\n",
" <td>6268.772511</td>\n",
" <td>8357.777411</td>\n",
" <td>13136.178869</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>34292.251766</td>\n",
" <td>35804.282797</td>\n",
" <td>18985.796319</td>\n",
" <td>33649.831232</td>\n",
" <td>61193.073355</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2077</th>\n",
" <td>3637.117995</td>\n",
" <td>3787.789722</td>\n",
" <td>1821.217372</td>\n",
" <td>3523.965925</td>\n",
" <td>7025.111023</td>\n",
" <td>10482.824960</td>\n",
" <td>9979.282546</td>\n",
" <td>6337.665348</td>\n",
" <td>8420.819495</td>\n",
" <td>13362.747044</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>34610.582227</td>\n",
" <td>36166.437726</td>\n",
" <td>18913.181230</td>\n",
" <td>33855.250511</td>\n",
" <td>62687.314812</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2078</th>\n",
" <td>3663.931177</td>\n",
" <td>3821.609726</td>\n",
" <td>1811.235798</td>\n",
" <td>3541.548558</td>\n",
" <td>7186.129419</td>\n",
" <td>10574.418827</td>\n",
" <td>10125.572287</td>\n",
" <td>6406.191099</td>\n",
" <td>8481.033230</td>\n",
" <td>13589.313700</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>34928.336502</td>\n",
" <td>36526.783060</td>\n",
" <td>18838.593197</td>\n",
" <td>34056.195679</td>\n",
" <td>64215.621809</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2079</th>\n",
" <td>3689.879429</td>\n",
" <td>3854.422101</td>\n",
" <td>1800.845730</td>\n",
" <td>3557.957991</td>\n",
" <td>7349.187862</td>\n",
" <td>10661.966118</td>\n",
" <td>10270.562874</td>\n",
" <td>6474.157544</td>\n",
" <td>8538.153732</td>\n",
" <td>13815.652098</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>35246.018120</td>\n",
" <td>36885.558816</td>\n",
" <td>18762.826439</td>\n",
" <td>34253.315387</td>\n",
" <td>65778.763373</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2080</th>\n",
" <td>3715.051225</td>\n",
" <td>3886.271677</td>\n",
" <td>1790.171353</td>\n",
" <td>3573.282791</td>\n",
" <td>7514.358900</td>\n",
" <td>10745.221987</td>\n",
" <td>10413.897727</td>\n",
" <td>6541.372468</td>\n",
" <td>8591.916115</td>\n",
" <td>14041.535498</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>35564.130608</td>\n",
" <td>37243.005011</td>\n",
" <td>18686.675175</td>\n",
" <td>34447.258283</td>\n",
" <td>67377.508535</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2081</th>\n",
" <td>3739.530880</td>\n",
" <td>3917.207523</td>\n",
" <td>1779.321130</td>\n",
" <td>3587.605427</td>\n",
" <td>7681.736256</td>\n",
" <td>10823.988187</td>\n",
" <td>10555.303664</td>\n",
" <td>6607.693671</td>\n",
" <td>8642.131348</td>\n",
" <td>14266.749553</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>35883.058558</td>\n",
" <td>37599.308031</td>\n",
" <td>18610.783755</td>\n",
" <td>34638.532448</td>\n",
" <td>69012.649625</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2082</th>\n",
" <td>3763.386086</td>\n",
" <td>3947.295680</td>\n",
" <td>1768.340633</td>\n",
" <td>3600.983979</td>\n",
" <td>7851.498354</td>\n",
" <td>10898.252854</td>\n",
" <td>10694.841075</td>\n",
" <td>6673.179028</td>\n",
" <td>8688.913821</td>\n",
" <td>14491.129492</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>36202.710811</td>\n",
" <td>37954.439751</td>\n",
" <td>18535.197057</td>\n",
" <td>34827.083686</td>\n",
" <td>70685.072190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2083</th>\n",
" <td>3786.680381</td>\n",
" <td>3976.606430</td>\n",
" <td>1757.259712</td>\n",
" <td>3613.470425</td>\n",
" <td>8023.844793</td>\n",
" <td>10968.050719</td>\n",
" <td>10832.653746</td>\n",
" <td>6737.936433</td>\n",
" <td>8732.453776</td>\n",
" <td>14714.522937</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>36522.877271</td>\n",
" <td>38308.318415</td>\n",
" <td>18459.810089</td>\n",
" <td>35012.717232</td>\n",
" <td>72395.685079</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2084</th>\n",
" <td>3809.477299</td>\n",
" <td>4005.210055</td>\n",
" <td>1746.108215</td>\n",
" <td>3625.116746</td>\n",
" <td>8198.975171</td>\n",
" <td>11033.416516</td>\n",
" <td>10968.885461</td>\n",
" <td>6802.073779</td>\n",
" <td>8772.941459</td>\n",
" <td>14936.777509</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>36843.347843</td>\n",
" <td>38660.862269</td>\n",
" <td>18384.517859</td>\n",
" <td>35195.238321</td>\n",
" <td>74145.397140</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2085</th>\n",
" <td>3831.840378</td>\n",
" <td>4033.176837</td>\n",
" <td>1734.915992</td>\n",
" <td>3635.974920</td>\n",
" <td>8377.089088</td>\n",
" <td>11094.384977</td>\n",
" <td>11103.680007</td>\n",
" <td>6865.698960</td>\n",
" <td>8810.567113</td>\n",
" <td>15157.740831</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>37163.912430</td>\n",
" <td>39011.989555</td>\n",
" <td>18309.215375</td>\n",
" <td>35374.452188</td>\n",
" <td>75935.117222</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2086</th>\n",
" <td>3853.833153</td>\n",
" <td>4060.577059</td>\n",
" <td>1723.712892</td>\n",
" <td>3646.096928</td>\n",
" <td>8558.386143</td>\n",
" <td>11150.990834</td>\n",
" <td>11237.181168</td>\n",
" <td>6928.919869</td>\n",
" <td>8845.520981</td>\n",
" <td>15377.260524</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>37484.360937</td>\n",
" <td>39361.618520</td>\n",
" <td>18233.797646</td>\n",
" <td>35550.164068</td>\n",
" <td>77765.754174</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2087</th>\n",
" <td>3875.519161</td>\n",
" <td>4087.481003</td>\n",
" <td>1712.528764</td>\n",
" <td>3655.534750</td>\n",
" <td>8743.065934</td>\n",
" <td>11203.268819</td>\n",
" <td>11369.532730</td>\n",
" <td>6991.844401</td>\n",
" <td>8877.993309</td>\n",
" <td>15595.184210</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>37804.483267</td>\n",
" <td>39709.667408</td>\n",
" <td>18158.159681</td>\n",
" <td>35722.179195</td>\n",
" <td>79638.216845</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2088</th>\n",
" <td>3896.961938</td>\n",
" <td>4113.958951</td>\n",
" <td>1701.393457</td>\n",
" <td>3664.340365</td>\n",
" <td>8931.328061</td>\n",
" <td>11251.253666</td>\n",
" <td>11500.878477</td>\n",
" <td>7054.580448</td>\n",
" <td>8908.174339</td>\n",
" <td>15811.359510</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>38124.069325</td>\n",
" <td>40056.054464</td>\n",
" <td>18082.196487</td>\n",
" <td>35890.302805</td>\n",
" <td>81553.414085</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2089</th>\n",
" <td>3918.225020</td>\n",
" <td>4140.081185</td>\n",
" <td>1690.336821</td>\n",
" <td>3672.565753</td>\n",
" <td>9123.372122</td>\n",
" <td>11294.980105</td>\n",
" <td>11631.362196</td>\n",
" <td>7117.235904</td>\n",
" <td>8936.254316</td>\n",
" <td>16025.634048</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>38442.909016</td>\n",
" <td>40400.697933</td>\n",
" <td>18005.803073</td>\n",
" <td>36054.340133</td>\n",
" <td>83512.254740</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2090</th>\n",
" <td>3939.371943</td>\n",
" <td>4165.917988</td>\n",
" <td>1679.388704</td>\n",
" <td>3680.262893</td>\n",
" <td>9319.397717</td>\n",
" <td>11334.482870</td>\n",
" <td>11761.127672</td>\n",
" <td>7179.918663</td>\n",
" <td>8962.423484</td>\n",
" <td>16237.855444</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>38760.792242</td>\n",
" <td>40743.516058</td>\n",
" <td>17928.874448</td>\n",
" <td>36214.096414</td>\n",
" <td>85515.647662</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2091</th>\n",
" <td>3960.458193</td>\n",
" <td>4191.534273</td>\n",
" <td>1668.569019</td>\n",
" <td>3687.475250</td>\n",
" <td>9519.601835</td>\n",
" <td>11369.822106</td>\n",
" <td>11890.354431</td>\n",
" <td>7242.758188</td>\n",
" <td>8986.904856</td>\n",
" <td>16447.889387</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>39077.459979</td>\n",
" <td>41084.397160</td>\n",
" <td>17851.251260</td>\n",
" <td>36369.320297</td>\n",
" <td>87564.488435</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2092</th>\n",
" <td>3981.507050</td>\n",
" <td>4216.973482</td>\n",
" <td>1657.857928</td>\n",
" <td>3694.212220</td>\n",
" <td>9724.171032</td>\n",
" <td>11401.159615</td>\n",
" <td>12019.364971</td>\n",
" <td>7305.970227</td>\n",
" <td>9010.052528</td>\n",
" <td>16655.673833</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>39392.457483</td>\n",
" <td>41423.109849</td>\n",
" <td>17772.556724</td>\n",
" <td>36519.534098</td>\n",
" <td>89659.619592</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2093</th>\n",
" <td>4002.533743</td>\n",
" <td>4242.273689</td>\n",
" <td>1647.225654</td>\n",
" <td>3700.474687</td>\n",
" <td>9933.289254</td>\n",
" <td>11428.682609</td>\n",
" <td>12148.517532</td>\n",
" <td>7369.792095</td>\n",
" <td>9032.253365</td>\n",
" <td>16861.164806</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>39705.281080</td>\n",
" <td>41759.392812</td>\n",
" <td>17692.359694</td>\n",
" <td>36664.203546</td>\n",
" <td>91801.870403</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2094</th>\n",
" <td>4023.553501</td>\n",
" <td>4267.472968</td>\n",
" <td>1636.642424</td>\n",
" <td>3706.263530</td>\n",
" <td>10147.140449</td>\n",
" <td>11452.578305</td>\n",
" <td>12278.170351</td>\n",
" <td>7434.461110</td>\n",
" <td>9053.894232</td>\n",
" <td>17064.318327</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>40015.427097</td>\n",
" <td>42092.984735</td>\n",
" <td>17610.229025</td>\n",
" <td>36802.794370</td>\n",
" <td>93992.070139</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2095</th>\n",
" <td>4044.581553</td>\n",
" <td>4292.609391</td>\n",
" <td>1626.078461</td>\n",
" <td>3711.579633</td>\n",
" <td>10365.908563</td>\n",
" <td>11473.033914</td>\n",
" <td>12408.681668</td>\n",
" <td>7500.214588</td>\n",
" <td>9075.361994</td>\n",
" <td>17265.090419</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>40322.391860</td>\n",
" <td>42423.624303</td>\n",
" <td>17525.733573</td>\n",
" <td>36934.772301</td>\n",
" <td>96231.048069</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2096</th>\n",
" <td>4065.633130</td>\n",
" <td>4317.721033</td>\n",
" <td>1615.503990</td>\n",
" <td>3716.423876</td>\n",
" <td>10589.777542</td>\n",
" <td>11490.236653</td>\n",
" <td>12540.409722</td>\n",
" <td>7567.289845</td>\n",
" <td>9097.043515</td>\n",
" <td>17463.437106</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>40625.671696</td>\n",
" <td>42751.050202</td>\n",
" <td>17438.442190</td>\n",
" <td>37059.603068</td>\n",
" <td>98519.633463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2097</th>\n",
" <td>4086.723459</td>\n",
" <td>4342.845967</td>\n",
" <td>1604.889236</td>\n",
" <td>3720.797142</td>\n",
" <td>10818.931334</td>\n",
" <td>11504.373735</td>\n",
" <td>12673.712752</td>\n",
" <td>7635.924198</td>\n",
" <td>9119.325662</td>\n",
" <td>17659.314409</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>40924.762930</td>\n",
" <td>43075.001118</td>\n",
" <td>17347.923734</td>\n",
" <td>37176.752401</td>\n",
" <td>100858.655591</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2098</th>\n",
" <td>4107.867770</td>\n",
" <td>4368.022266</td>\n",
" <td>1594.204424</td>\n",
" <td>3724.700311</td>\n",
" <td>11053.553884</td>\n",
" <td>11515.632375</td>\n",
" <td>12808.948997</td>\n",
" <td>7706.354964</td>\n",
" <td>9142.595300</td>\n",
" <td>17852.678353</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>41219.161891</td>\n",
" <td>43395.215737</td>\n",
" <td>17253.747057</td>\n",
" <td>37285.686029</td>\n",
" <td>103248.943723</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2099</th>\n",
" <td>4129.081292</td>\n",
" <td>4393.288004</td>\n",
" <td>1583.419778</td>\n",
" <td>3728.134266</td>\n",
" <td>11293.829141</td>\n",
" <td>11524.199786</td>\n",
" <td>12946.476697</td>\n",
" <td>7778.819460</td>\n",
" <td>9167.239293</td>\n",
" <td>18043.484958</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>41508.364903</td>\n",
" <td>43711.432745</td>\n",
" <td>17155.481016</td>\n",
" <td>37385.869683</td>\n",
" <td>105691.327129</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2100</th>\n",
" <td>4150.379255</td>\n",
" <td>4418.681255</td>\n",
" <td>1572.505523</td>\n",
" <td>3731.099889</td>\n",
" <td>11539.941049</td>\n",
" <td>11530.263183</td>\n",
" <td>13086.654089</td>\n",
" <td>7853.555002</td>\n",
" <td>9193.644507</td>\n",
" <td>18231.690249</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>41791.868293</td>\n",
" <td>44023.390827</td>\n",
" <td>17052.694465</td>\n",
" <td>37476.769091</td>\n",
" <td>108186.635079</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>363 rows × 160 columns</p>\n",
"</div>"
],
"text/plain": [
"Value R32AUNZ \\\n",
" SSP1 SSP2 SSP3 SSP4 \n",
"IIASA GDP 1980 348.595503 348.595503 348.595503 348.595503 \n",
" 1981 352.675037 352.671574 352.745241 352.668146 \n",
" 1982 360.639880 360.635556 360.727574 360.631274 \n",
" 1983 371.679845 371.676390 371.749927 371.672969 \n",
" 1984 384.984742 384.983018 385.019721 384.981311 \n",
" 1985 399.744381 399.744381 399.744381 399.744381 \n",
" 1986 415.202773 415.203795 415.181980 415.204808 \n",
" 1987 430.820726 430.822076 430.793206 430.823415 \n",
" 1988 446.113248 446.114415 446.089397 446.115573 \n",
" 1989 460.595346 460.596002 460.581892 460.596653 \n",
" 1990 473.782028 473.782028 473.782028 473.782028 \n",
" 1991 485.455000 485.454374 485.467966 485.453751 \n",
" 1992 496.462764 496.461688 496.485149 496.460616 \n",
" 1993 507.920522 507.919307 507.945842 507.918098 \n",
" 1994 520.943473 520.942571 520.962310 520.941673 \n",
" 1995 536.646818 536.646818 536.646818 536.646818 \n",
" 1996 555.839508 555.840990 555.808438 555.842468 \n",
" 1997 578.105493 578.108450 578.043476 578.111399 \n",
" 1998 602.722473 602.726164 602.645043 602.729845 \n",
" 1999 628.968148 628.971098 628.906253 628.974040 \n",
" 2000 656.120219 656.120219 656.120219 656.120219 \n",
" 2001 683.386705 683.381402 683.498019 683.376113 \n",
" 2002 709.696914 709.686162 709.922599 709.675439 \n",
" 2003 733.910472 733.896923 734.194872 733.883410 \n",
" 2004 754.887007 754.876109 755.115749 754.865241 \n",
" 2005 771.486144 771.486144 771.486144 771.486144 \n",
" 2006 784.905864 784.923725 784.530946 784.941538 \n",
" 2007 805.697554 805.722642 805.170957 805.747661 \n",
" 2008 846.750955 846.750955 846.750955 846.750955 \n",
" 2009 915.222288 915.172438 916.268679 915.122721 \n",
"... ... ... ... ... \n",
"PIK GDP-32 2071 3453.120951 3561.199114 1865.574029 3388.873126 \n",
" 2072 3486.981624 3602.006284 1860.651323 3415.354884 \n",
" 2073 3519.446534 3641.536856 1854.575008 3440.132035 \n",
" 2074 3550.604154 3679.835657 1847.469269 3463.293147 \n",
" 2075 3580.542956 3716.947516 1839.458293 3484.926788 \n",
" 2076 3609.351413 3752.917262 1830.666266 3505.121524 \n",
" 2077 3637.117995 3787.789722 1821.217372 3523.965925 \n",
" 2078 3663.931177 3821.609726 1811.235798 3541.548558 \n",
" 2079 3689.879429 3854.422101 1800.845730 3557.957991 \n",
" 2080 3715.051225 3886.271677 1790.171353 3573.282791 \n",
" 2081 3739.530880 3917.207523 1779.321130 3587.605427 \n",
" 2082 3763.386086 3947.295680 1768.340633 3600.983979 \n",
" 2083 3786.680381 3976.606430 1757.259712 3613.470425 \n",
" 2084 3809.477299 4005.210055 1746.108215 3625.116746 \n",
" 2085 3831.840378 4033.176837 1734.915992 3635.974920 \n",
" 2086 3853.833153 4060.577059 1723.712892 3646.096928 \n",
" 2087 3875.519161 4087.481003 1712.528764 3655.534750 \n",
" 2088 3896.961938 4113.958951 1701.393457 3664.340365 \n",
" 2089 3918.225020 4140.081185 1690.336821 3672.565753 \n",
" 2090 3939.371943 4165.917988 1679.388704 3680.262893 \n",
" 2091 3960.458193 4191.534273 1668.569019 3687.475250 \n",
" 2092 3981.507050 4216.973482 1657.857928 3694.212220 \n",
" 2093 4002.533743 4242.273689 1647.225654 3700.474687 \n",
" 2094 4023.553501 4267.472968 1636.642424 3706.263530 \n",
" 2095 4044.581553 4292.609391 1626.078461 3711.579633 \n",
" 2096 4065.633130 4317.721033 1615.503990 3716.423876 \n",
" 2097 4086.723459 4342.845967 1604.889236 3720.797142 \n",
" 2098 4107.867770 4368.022266 1594.204424 3724.700311 \n",
" 2099 4129.081292 4393.288004 1583.419778 3728.134266 \n",
" 2100 4150.379255 4418.681255 1572.505523 3731.099889 \n",
"\n",
"Value R32BRA \\\n",
" SSP5 SSP1 SSP2 SSP3 \n",
"IIASA GDP 1980 348.595503 920.935005 920.935005 920.935005 \n",
" 1981 352.671687 930.776566 930.786336 930.782441 \n",
" 1982 360.635694 940.156335 940.168537 940.163675 \n",
" 1983 371.676496 949.722641 949.732391 949.728509 \n",
" 1984 384.983067 960.123814 960.128679 960.126744 \n",
" 1985 399.744381 972.008183 972.008183 972.008183 \n",
" 1986 415.203777 986.002754 985.999866 986.001006 \n",
" 1987 430.822064 1002.649235 1002.645418 1002.646917 \n",
" 1988 446.114418 1022.468012 1022.464709 1022.465997 \n",
" 1989 460.596014 1045.979470 1045.977611 1045.978328 \n",
" 1990 473.782028 1073.703993 1073.703993 1073.703993 \n",
" 1991 485.454333 1105.802928 1105.804707 1105.804042 \n",
" 1992 496.461598 1141.001457 1141.004522 1141.003389 \n",
" 1993 507.919190 1177.665725 1177.669186 1177.667918 \n",
" 1994 520.942474 1214.161877 1214.164447 1214.163512 \n",
" 1995 536.646818 1248.856055 1248.856055 1248.856055 \n",
" 1996 555.841171 1280.445896 1280.441665 1280.443189 \n",
" 1997 578.108820 1308.955002 1308.946560 1308.949594 \n",
" 1998 602.726631 1334.738466 1334.727928 1334.731711 \n",
" 1999 628.971475 1358.151381 1358.142958 1358.145980 \n",
" 2000 656.120219 1379.548841 1379.548841 1379.548841 \n",
" 2001 683.380718 1400.197218 1400.212363 1400.206935 \n",
" 2002 709.684774 1425.007996 1425.038701 1425.027698 \n",
" 2003 733.895172 1459.803938 1459.842631 1459.828766 \n",
" 2004 754.874700 1510.407806 1510.438926 1510.427775 \n",
" 2005 771.486144 1582.642363 1582.642363 1582.642363 \n",
" 2006 784.926036 1676.709708 1676.658701 1676.676977 \n",
" 2007 805.725888 1770.329279 1770.257637 1770.283306 \n",
" 2008 846.750955 1835.599851 1835.599851 1835.599851 \n",
" 2009 915.165987 1855.851624 1855.993982 1855.942976 \n",
"... ... ... ... ... \n",
"PIK GDP-32 2071 6097.778939 9861.994926 9094.230231 5925.529631 \n",
" 2072 6248.080563 9972.726523 9240.826758 5993.374641 \n",
" 2073 6399.986945 10080.880609 9388.263599 6061.813651 \n",
" 2074 6553.570635 10186.212341 9536.184177 6130.654445 \n",
" 2075 6708.904179 10288.476872 9684.231913 6199.704804 \n",
" 2076 6866.060125 10387.429360 9832.050228 6268.772511 \n",
" 2077 7025.111023 10482.824960 9979.282546 6337.665348 \n",
" 2078 7186.129419 10574.418827 10125.572287 6406.191099 \n",
" 2079 7349.187862 10661.966118 10270.562874 6474.157544 \n",
" 2080 7514.358900 10745.221987 10413.897727 6541.372468 \n",
" 2081 7681.736256 10823.988187 10555.303664 6607.693671 \n",
" 2082 7851.498354 10898.252854 10694.841075 6673.179028 \n",
" 2083 8023.844793 10968.050719 10832.653746 6737.936433 \n",
" 2084 8198.975171 11033.416516 10968.885461 6802.073779 \n",
" 2085 8377.089088 11094.384977 11103.680007 6865.698960 \n",
" 2086 8558.386143 11150.990834 11237.181168 6928.919869 \n",
" 2087 8743.065934 11203.268819 11369.532730 6991.844401 \n",
" 2088 8931.328061 11251.253666 11500.878477 7054.580448 \n",
" 2089 9123.372122 11294.980105 11631.362196 7117.235904 \n",
" 2090 9319.397717 11334.482870 11761.127672 7179.918663 \n",
" 2091 9519.601835 11369.822106 11890.354431 7242.758188 \n",
" 2092 9724.171032 11401.159615 12019.364971 7305.970227 \n",
" 2093 9933.289254 11428.682609 12148.517532 7369.792095 \n",
" 2094 10147.140449 11452.578305 12278.170351 7434.461110 \n",
" 2095 10365.908563 11473.033914 12408.681668 7500.214588 \n",
" 2096 10589.777542 11490.236653 12540.409722 7567.289845 \n",
" 2097 10818.931334 11504.373735 12673.712752 7635.924198 \n",
" 2098 11053.553884 11515.632375 12808.948997 7706.354964 \n",
" 2099 11293.829141 11524.199786 12946.476697 7778.819460 \n",
" 2100 11539.941049 11530.263183 13086.654089 7853.555002 \n",
"\n",
"Value ... R32TWN \\\n",
" SSP4 SSP5 ... SSP1 SSP2 SSP3 \n",
"IIASA GDP 1980 920.935005 920.935005 ... 0 0 0 \n",
" 1981 930.791813 930.776813 ... 0 0 0 \n",
" 1982 940.175384 940.156642 ... 0 0 0 \n",
" 1983 949.737868 949.722884 ... 0 0 0 \n",
" 1984 960.131418 960.123933 ... 0 0 0 \n",
" 1985 972.008183 972.008183 ... 0 0 0 \n",
" 1986 985.998222 986.002689 ... 0 0 0 \n",
" 1987 1002.643225 1002.649156 ... 0 0 0 \n",
" 1988 1022.462790 1022.467951 ... 0 0 0 \n",
" 1989 1045.976514 1045.979441 ... 0 0 0 \n",
" 1990 1073.703993 1073.703993 ... 0 0 0 \n",
" 1991 1105.805807 1105.802940 ... 0 0 0 \n",
" 1992 1141.006446 1141.001468 ... 0 0 0 \n",
" 1993 1177.671386 1177.665728 ... 0 0 0 \n",
" 1994 1214.166098 1214.161874 ... 0 0 0 \n",
" 1995 1248.856055 1248.856055 ... 0 0 0 \n",
" 1996 1280.438913 1280.445913 ... 0 0 0 \n",
" 1997 1308.941055 1308.955039 ... 0 0 0 \n",
" 1998 1334.721046 1334.738516 ... 0 0 0 \n",
" 1999 1358.137453 1358.151423 ... 0 0 0 \n",
" 2000 1379.548841 1379.548841 ... 0 0 0 \n",
" 2001 1400.222273 1400.197140 ... 0 0 0 \n",
" 2002 1425.058797 1425.007836 ... 0 0 0 \n",
" 2003 1459.867957 1459.803735 ... 0 0 0 \n",
" 2004 1510.459298 1510.407643 ... 0 0 0 \n",
" 2005 1582.642363 1582.642363 ... 0 0 0 \n",
" 2006 1676.625310 1676.709977 ... 0 0 0 \n",
" 2007 1770.210736 1770.329657 ... 0 0 0 \n",
" 2008 1835.599851 1835.599851 ... 0 0 0 \n",
" 2009 1856.087179 1855.850872 ... 0 0 0 \n",
"... ... ... ... ... ... ... \n",
"PIK GDP-32 2071 8009.412767 12011.251117 ... 0 0 0 \n",
" 2072 8082.623308 12234.425785 ... 0 0 0 \n",
" 2073 8154.329928 12458.732634 ... 0 0 0 \n",
" 2074 8224.267742 12683.944925 ... 0 0 0 \n",
" 2075 8292.171865 12909.835916 ... 0 0 0 \n",
" 2076 8357.777411 13136.178869 ... 0 0 0 \n",
" 2077 8420.819495 13362.747044 ... 0 0 0 \n",
" 2078 8481.033230 13589.313700 ... 0 0 0 \n",
" 2079 8538.153732 13815.652098 ... 0 0 0 \n",
" 2080 8591.916115 14041.535498 ... 0 0 0 \n",
" 2081 8642.131348 14266.749553 ... 0 0 0 \n",
" 2082 8688.913821 14491.129492 ... 0 0 0 \n",
" 2083 8732.453776 14714.522937 ... 0 0 0 \n",
" 2084 8772.941459 14936.777509 ... 0 0 0 \n",
" 2085 8810.567113 15157.740831 ... 0 0 0 \n",
" 2086 8845.520981 15377.260524 ... 0 0 0 \n",
" 2087 8877.993309 15595.184210 ... 0 0 0 \n",
" 2088 8908.174339 15811.359510 ... 0 0 0 \n",
" 2089 8936.254316 16025.634048 ... 0 0 0 \n",
" 2090 8962.423484 16237.855444 ... 0 0 0 \n",
" 2091 8986.904856 16447.889387 ... 0 0 0 \n",
" 2092 9010.052528 16655.673833 ... 0 0 0 \n",
" 2093 9032.253365 16861.164806 ... 0 0 0 \n",
" 2094 9053.894232 17064.318327 ... 0 0 0 \n",
" 2095 9075.361994 17265.090419 ... 0 0 0 \n",
" 2096 9097.043515 17463.437106 ... 0 0 0 \n",
" 2097 9119.325662 17659.314409 ... 0 0 0 \n",
" 2098 9142.595300 17852.678353 ... 0 0 0 \n",
" 2099 9167.239293 18043.484958 ... 0 0 0 \n",
" 2100 9193.644507 18231.690249 ... 0 0 0 \n",
"\n",
"Value R32USA \\\n",
" SSP4 SSP5 SSP1 SSP2 SSP3 \n",
"IIASA GDP 1980 0 0 5128.000000 5128.000000 5128.000000 \n",
" 1981 0 0 5456.797649 5456.763261 5456.901178 \n",
" 1982 0 0 5799.003180 5798.960233 5799.132516 \n",
" 1983 0 0 6143.569887 6143.535575 6143.673267 \n",
" 1984 0 0 6479.451063 6479.433945 6479.502678 \n",
" 1985 0 0 6795.600000 6795.600000 6795.600000 \n",
" 1986 0 0 7083.120981 7083.131130 7083.090251 \n",
" 1987 0 0 7341.722245 7341.735649 7341.681520 \n",
" 1988 0 0 7573.263017 7573.274604 7573.227663 \n",
" 1989 0 0 7779.602527 7779.609039 7779.582537 \n",
" 1990 0 0 7962.600000 7962.600000 7962.600000 \n",
" 1991 0 0 8127.533626 8127.527419 8127.553018 \n",
" 1992 0 0 8293.357442 8293.346770 8293.391005 \n",
" 1993 0 0 8482.444444 8482.432411 8482.482482 \n",
" 1994 0 0 8717.167631 8717.158701 8717.195973 \n",
" 1995 0 0 9019.900000 9019.900000 9019.900000 \n",
" 1996 0 0 9403.662113 9403.676793 9403.615275 \n",
" 1997 0 0 9844.064789 9844.094072 9843.971261 \n",
" 1998 0 0 10307.366407 10307.402954 10307.249610 \n",
" 1999 0 0 10759.825350 10759.854558 10759.731972 \n",
" 2000 0 0 11167.700000 11167.700000 11167.700000 \n",
" 2001 0 0 11507.027520 11506.975008 11507.195481 \n",
" 2002 0 0 11792.960203 11792.853742 11793.300750 \n",
" 2003 0 0 12050.429127 12050.294972 12050.858279 \n",
" 2004 0 0 12304.365367 12304.257468 12304.710538 \n",
" 2005 0 0 12579.700000 12579.700000 12579.700000 \n",
" 2006 0 0 12878.430582 12878.607429 12877.864827 \n",
" 2007 0 0 13110.820595 13111.068988 13110.025953 \n",
" 2008 0 0 13164.200000 13164.200000 13164.200000 \n",
" 2009 0 0 12981.248647 12980.755071 12982.827666 \n",
"... ... ... ... ... ... \n",
"PIK GDP-32 2071 0 0 32674.333180 33957.963661 19291.479925 \n",
" 2072 0 0 33003.097496 34332.766809 19240.642846 \n",
" 2073 0 0 33328.767984 34704.560280 19183.861726 \n",
" 2074 0 0 33651.848173 35073.584090 19121.930786 \n",
" 2075 0 0 33972.841591 35440.078257 19055.644244 \n",
" 2076 0 0 34292.251766 35804.282797 18985.796319 \n",
" 2077 0 0 34610.582227 36166.437726 18913.181230 \n",
" 2078 0 0 34928.336502 36526.783060 18838.593197 \n",
" 2079 0 0 35246.018120 36885.558816 18762.826439 \n",
" 2080 0 0 35564.130608 37243.005011 18686.675175 \n",
" 2081 0 0 35883.058558 37599.308031 18610.783755 \n",
" 2082 0 0 36202.710811 37954.439751 18535.197057 \n",
" 2083 0 0 36522.877271 38308.318415 18459.810089 \n",
" 2084 0 0 36843.347843 38660.862269 18384.517859 \n",
" 2085 0 0 37163.912430 39011.989555 18309.215375 \n",
" 2086 0 0 37484.360937 39361.618520 18233.797646 \n",
" 2087 0 0 37804.483267 39709.667408 18158.159681 \n",
" 2088 0 0 38124.069325 40056.054464 18082.196487 \n",
" 2089 0 0 38442.909016 40400.697933 18005.803073 \n",
" 2090 0 0 38760.792242 40743.516058 17928.874448 \n",
" 2091 0 0 39077.459979 41084.397160 17851.251260 \n",
" 2092 0 0 39392.457483 41423.109849 17772.556724 \n",
" 2093 0 0 39705.281080 41759.392812 17692.359694 \n",
" 2094 0 0 40015.427097 42092.984735 17610.229025 \n",
" 2095 0 0 40322.391860 42423.624303 17525.733573 \n",
" 2096 0 0 40625.671696 42751.050202 17438.442190 \n",
" 2097 0 0 40924.762930 43075.001118 17347.923734 \n",
" 2098 0 0 41219.161891 43395.215737 17253.747057 \n",
" 2099 0 0 41508.364903 43711.432745 17155.481016 \n",
" 2100 0 0 41791.868293 44023.390827 17052.694465 \n",
"\n",
"Value \n",
" SSP4 SSP5 \n",
"IIASA GDP 1980 5128.000000 5128.000000 \n",
" 1981 5456.732988 5456.767567 \n",
" 1982 5798.922424 5798.965587 \n",
" 1983 6143.505365 6143.539824 \n",
" 1984 6479.418871 6479.436040 \n",
" 1985 6795.600000 6795.600000 \n",
" 1986 7083.140073 7083.129965 \n",
" 1987 7341.747469 7341.734191 \n",
" 1988 7573.284828 7573.273435 \n",
" 1989 7779.614791 7779.608453 \n",
" 1990 7962.600000 7962.600000 \n",
" 1991 8127.521918 8127.527775 \n",
" 1992 8293.337301 8293.347248 \n",
" 1993 8482.421724 8482.432834 \n",
" 1994 8717.150764 8717.158947 \n",
" 1995 9019.900000 9019.900000 \n",
" 1996 9403.689853 9403.676536 \n",
" 1997 9844.120129 9844.093615 \n",
" 1998 10307.435478 10307.402427 \n",
" 1999 10759.880551 10759.854159 \n",
" 2000 11167.700000 11167.700000 \n",
" 2001 11506.928270 11506.975680 \n",
" 2002 11792.758985 11792.855090 \n",
" 2003 12050.175565 12050.296659 \n",
" 2004 12304.161430 12304.258819 \n",
" 2005 12579.700000 12579.700000 \n",
" 2006 12878.764837 12878.605227 \n",
" 2007 13111.290077 13111.065896 \n",
" 2008 13164.200000 13164.200000 \n",
" 2009 12980.315751 12980.761212 \n",
"... ... ... \n",
"PIK GDP-32 2071 32532.920443 54205.933142 \n",
" 2072 32770.440019 55541.382337 \n",
" 2073 33000.242236 56907.051928 \n",
" 2074 33222.975744 58303.710941 \n",
" 2075 33439.289193 59732.128407 \n",
" 2076 33649.831232 61193.073355 \n",
" 2077 33855.250511 62687.314812 \n",
" 2078 34056.195679 64215.621809 \n",
" 2079 34253.315387 65778.763373 \n",
" 2080 34447.258283 67377.508535 \n",
" 2081 34638.532448 69012.649625 \n",
" 2082 34827.083686 70685.072190 \n",
" 2083 35012.717232 72395.685079 \n",
" 2084 35195.238321 74145.397140 \n",
" 2085 35374.452188 75935.117222 \n",
" 2086 35550.164068 77765.754174 \n",
" 2087 35722.179195 79638.216845 \n",
" 2088 35890.302805 81553.414085 \n",
" 2089 36054.340133 83512.254740 \n",
" 2090 36214.096414 85515.647662 \n",
" 2091 36369.320297 87564.488435 \n",
" 2092 36519.534098 89659.619592 \n",
" 2093 36664.203546 91801.870403 \n",
" 2094 36802.794370 93992.070139 \n",
" 2095 36934.772301 96231.048069 \n",
" 2096 37059.603068 98519.633463 \n",
" 2097 37176.752401 100858.655591 \n",
" 2098 37285.686029 103248.943723 \n",
" 2099 37385.869683 105691.327129 \n",
" 2100 37476.769091 108186.635079 \n",
"\n",
"[363 rows x 160 columns]"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's load one of the data files\n",
"fname = \"/Users/n/Dropbox (Yale_FES)/G7 RECC/Data/RECC_Database/1_F_RECC_PPP_GDP_SSP_32R_V1.0.xlsx\"\n",
"sheet = \"Data\"\n",
"drop_cols = []\n",
"compare_df = pd.read_excel(fname, \n",
" sheet_name=sheet, \n",
" header=[0,1],\n",
" index_col=[0,1],\n",
" skiprows=0, ).drop(drop_cols, axis=1)\n",
"compare_df "
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"All seems well :)\n"
]
}
],
"source": [
"# So now let's check if all regions are present in the master classification\n",
"mclass = master_class['SSP_Regions_32'].dropna().values\n",
"dvalues = compare_df.columns.get_level_values(0).unique().values\n",
"assert all([i in mclass for i in dvalues])\n",
"\n",
"# check scenarios as well\n",
"mclass = master_class['SSP_Scenarios'].dropna().values\n",
"dvalues = compare_df.columns.get_level_values(1).unique().values\n",
"assert all([i in mclass for i in dvalues])\n",
"\n",
"print(\"All seems well :)\")"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [],
"source": [
"# good practice!\n",
"conn.close()"
]
}
],
"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.5"
}
},
"nbformat": 4,
"nbformat_minor": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment