Parsing EXIOBASE.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Parsing EXIOBASE\n",
    "\n",
    "Prior to conducting footprint calculation or other types of analysis using EXIOBASE, parsing the raw files and converting them into a dataset file (.mat) is desirable to ease the accessibility of the values used in the calculation."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Import of required libraries\n",
    "\n",
    "In this step all the libraries needed within the script are imported."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import scipy.io\n",
    "import scipy\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Setting directory path for building the EXIOBASE database\n",
    "\n",
    "Take a look of EXIOBASE dataset available in https://www.exiobase.eu/index.php/data-download/exiobase3mon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "Directory = 'C://Users//Gilang Hardadi//Documents//EXIOBASE_v36//IOT_pxp//IOT_2010_pxp//'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting the Final Demand Vectors (Y Matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>region</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>AT</th>\n",
       "      <th>AT.1</th>\n",
       "      <th>AT.2</th>\n",
       "      <th>AT.3</th>\n",
       "      <th>AT.4</th>\n",
       "      <th>AT.5</th>\n",
       "      <th>AT.6</th>\n",
       "      <th>BE</th>\n",
       "      <th>...</th>\n",
       "      <th>WF.4</th>\n",
       "      <th>WF.5</th>\n",
       "      <th>WF.6</th>\n",
       "      <th>WM</th>\n",
       "      <th>WM.1</th>\n",
       "      <th>WM.2</th>\n",
       "      <th>WM.3</th>\n",
       "      <th>WM.4</th>\n",
       "      <th>WM.5</th>\n",
       "      <th>WM.6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>category</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Final consumption expenditure by households</td>\n",
       "      <td>Final consumption expenditure by non-profit or...</td>\n",
       "      <td>Final consumption expenditure by government</td>\n",
       "      <td>Gross fixed capital formation</td>\n",
       "      <td>Changes in inventories</td>\n",
       "      <td>Changes in valuables</td>\n",
       "      <td>Exports: Total (fob)</td>\n",
       "      <td>Final consumption expenditure by households</td>\n",
       "      <td>...</td>\n",
       "      <td>Changes in inventories</td>\n",
       "      <td>Changes in valuables</td>\n",
       "      <td>Exports: Total (fob)</td>\n",
       "      <td>Final consumption expenditure by households</td>\n",
       "      <td>Final consumption expenditure by non-profit or...</td>\n",
       "      <td>Final consumption expenditure by government</td>\n",
       "      <td>Gross fixed capital formation</td>\n",
       "      <td>Changes in inventories</td>\n",
       "      <td>Changes in valuables</td>\n",
       "      <td>Exports: Total (fob)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>region</td>\n",
       "      <td>sector</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>...</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>2</th>\n",
       "      <td>AT</td>\n",
       "      <td>Paddy rice</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AT</td>\n",
       "      <td>Wheat</td>\n",
       "      <td>38.356713659</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.95430686544</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0512743845305</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.271167563621</td>\n",
       "      <td>4.62850192488e-06</td>\n",
       "      <td>0.00465974082497</td>\n",
       "      <td>0.00529528874906</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AT</td>\n",
       "      <td>Cereal grains nec</td>\n",
       "      <td>119.264462236</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.15399988904</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00245356517697</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.962645315647</td>\n",
       "      <td>8.35029736873e-06</td>\n",
       "      <td>1.10071584985e-05</td>\n",
       "      <td>0.00970015528341</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>9797</th>\n",
       "      <td>WM</td>\n",
       "      <td>Membership organisation services n.e.c. (91)</td>\n",
       "      <td>0.0057096061783</td>\n",
       "      <td>0.834108253464</td>\n",
       "      <td>0.0704957965557</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3429.26973987</td>\n",
       "      <td>8962.33381029</td>\n",
       "      <td>1430.89522037</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9798</th>\n",
       "      <td>WM</td>\n",
       "      <td>Recreational, cultural and sporting services (92)</td>\n",
       "      <td>7.79672127946</td>\n",
       "      <td>3.13333828656</td>\n",
       "      <td>5.3542765506</td>\n",
       "      <td>0.616458570861</td>\n",
       "      <td>0.00117477901174</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9.10088065361</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16288.735965</td>\n",
       "      <td>4202.05290337</td>\n",
       "      <td>4396.22985957</td>\n",
       "      <td>1078.35722562</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9799</th>\n",
       "      <td>WM</td>\n",
       "      <td>Other services (93)</td>\n",
       "      <td>2.19557094455</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0817431944515</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15909.57629</td>\n",
       "      <td>1351.26538308</td>\n",
       "      <td>133.015318142</td>\n",
       "      <td>551.872501298</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9800</th>\n",
       "      <td>WM</td>\n",
       "      <td>Private households with employed persons (95)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1951.39148803</td>\n",
       "      <td>0.0742644594432</td>\n",
       "      <td>36.5117233385</td>\n",
       "      <td>23.7047044999</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9801</th>\n",
       "      <td>WM</td>\n",
       "      <td>Extra-territorial organizations and bodies</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9802 rows × 345 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        region                                         Unnamed: 1  \\\n",
       "0     category                                                NaN   \n",
       "1       region                                             sector   \n",
       "2           AT                                         Paddy rice   \n",
       "3           AT                                              Wheat   \n",
       "4           AT                                  Cereal grains nec   \n",
       "...        ...                                                ...   \n",
       "9797        WM       Membership organisation services n.e.c. (91)   \n",
       "9798        WM  Recreational, cultural and sporting services (92)   \n",
       "9799        WM                                Other services (93)   \n",
       "9800        WM      Private households with employed persons (95)   \n",
       "9801        WM         Extra-territorial organizations and bodies   \n",
       "\n",
       "                                               AT  \\\n",
       "0     Final consumption expenditure by households   \n",
       "1                                             NaN   \n",
       "2                                               0   \n",
       "3                                    38.356713659   \n",
       "4                                   119.264462236   \n",
       "...                                           ...   \n",
       "9797                              0.0057096061783   \n",
       "9798                                7.79672127946   \n",
       "9799                                2.19557094455   \n",
       "9800                                            0   \n",
       "9801                                            0   \n",
       "\n",
       "                                                   AT.1  \\\n",
       "0     Final consumption expenditure by non-profit or...   \n",
       "1                                                   NaN   \n",
       "2                                                     0   \n",
       "3                                                     0   \n",
       "4                                                     0   \n",
       "...                                                 ...   \n",
       "9797                                     0.834108253464   \n",
       "9798                                      3.13333828656   \n",
       "9799                                                  0   \n",
       "9800                                                  0   \n",
       "9801                                                  0   \n",
       "\n",
       "                                             AT.2  \\\n",
       "0     Final consumption expenditure by government   \n",
       "1                                             NaN   \n",
       "2                                               0   \n",
       "3                                               0   \n",
       "4                                               0   \n",
       "...                                           ...   \n",
       "9797                              0.0704957965557   \n",
       "9798                                 5.3542765506   \n",
       "9799                              0.0817431944515   \n",
       "9800                                            0   \n",
       "9801                                            0   \n",
       "\n",
       "                               AT.3                    AT.4  \\\n",
       "0     Gross fixed capital formation  Changes in inventories   \n",
       "1                               NaN                     NaN   \n",
       "2                                 0                       0   \n",
       "3                                 0           2.95430686544   \n",
       "4                                 0           6.15399988904   \n",
       "...                             ...                     ...   \n",
       "9797                              0                       0   \n",
       "9798                 0.616458570861        0.00117477901174   \n",
       "9799                              0                       0   \n",
       "9800                              0                       0   \n",
       "9801                              0                       0   \n",
       "\n",
       "                      AT.5                  AT.6  \\\n",
       "0     Changes in valuables  Exports: Total (fob)   \n",
       "1                      NaN                   NaN   \n",
       "2                        0                     0   \n",
       "3                        0                     0   \n",
       "4                        0                     0   \n",
       "...                    ...                   ...   \n",
       "9797                     0                     0   \n",
       "9798                     0                     0   \n",
       "9799                     0                     0   \n",
       "9800                     0                     0   \n",
       "9801                     0                     0   \n",
       "\n",
       "                                               BE  ...  \\\n",
       "0     Final consumption expenditure by households  ...   \n",
       "1                                             NaN  ...   \n",
       "2                                               0  ...   \n",
       "3                                 0.0512743845305  ...   \n",
       "4                                0.00245356517697  ...   \n",
       "...                                           ...  ...   \n",
       "9797                                            0  ...   \n",
       "9798                                9.10088065361  ...   \n",
       "9799                                            0  ...   \n",
       "9800                                            0  ...   \n",
       "9801                                            0  ...   \n",
       "\n",
       "                        WF.4                  WF.5                  WF.6  \\\n",
       "0     Changes in inventories  Changes in valuables  Exports: Total (fob)   \n",
       "1                        NaN                   NaN                   NaN   \n",
       "2                          0                     0                     0   \n",
       "3                          0                     0                     0   \n",
       "4                          0                     0                     0   \n",
       "...                      ...                   ...                   ...   \n",
       "9797                       0                     0                     0   \n",
       "9798                       0                     0                     0   \n",
       "9799                       0                     0                     0   \n",
       "9800                       0                     0                     0   \n",
       "9801                       0                     0                     0   \n",
       "\n",
       "                                               WM  \\\n",
       "0     Final consumption expenditure by households   \n",
       "1                                             NaN   \n",
       "2                                               0   \n",
       "3                                  0.271167563621   \n",
       "4                                  0.962645315647   \n",
       "...                                           ...   \n",
       "9797                                3429.26973987   \n",
       "9798                                 16288.735965   \n",
       "9799                                  15909.57629   \n",
       "9800                                1951.39148803   \n",
       "9801                                            0   \n",
       "\n",
       "                                                   WM.1  \\\n",
       "0     Final consumption expenditure by non-profit or...   \n",
       "1                                                   NaN   \n",
       "2                                                     0   \n",
       "3                                     4.62850192488e-06   \n",
       "4                                     8.35029736873e-06   \n",
       "...                                                 ...   \n",
       "9797                                      8962.33381029   \n",
       "9798                                      4202.05290337   \n",
       "9799                                      1351.26538308   \n",
       "9800                                    0.0742644594432   \n",
       "9801                                                  0   \n",
       "\n",
       "                                             WM.2  \\\n",
       "0     Final consumption expenditure by government   \n",
       "1                                             NaN   \n",
       "2                                               0   \n",
       "3                                0.00465974082497   \n",
       "4                               1.10071584985e-05   \n",
       "...                                           ...   \n",
       "9797                                1430.89522037   \n",
       "9798                                4396.22985957   \n",
       "9799                                133.015318142   \n",
       "9800                                36.5117233385   \n",
       "9801                                            0   \n",
       "\n",
       "                               WM.3                    WM.4  \\\n",
       "0     Gross fixed capital formation  Changes in inventories   \n",
       "1                               NaN                     NaN   \n",
       "2                                 0                       0   \n",
       "3                  0.00529528874906                       0   \n",
       "4                  0.00970015528341                       0   \n",
       "...                             ...                     ...   \n",
       "9797                              0                       0   \n",
       "9798                  1078.35722562                       0   \n",
       "9799                  551.872501298                       0   \n",
       "9800                  23.7047044999                       0   \n",
       "9801                              0                       0   \n",
       "\n",
       "                      WM.5                  WM.6  \n",
       "0     Changes in valuables  Exports: Total (fob)  \n",
       "1                      NaN                   NaN  \n",
       "2                        0                     0  \n",
       "3                        0                     0  \n",
       "4                        0                     0  \n",
       "...                    ...                   ...  \n",
       "9797                     0                     0  \n",
       "9798                     0                     0  \n",
       "9799                     0                     0  \n",
       "9800                     0                     0  \n",
       "9801                     0                     0  \n",
       "\n",
       "[9802 rows x 345 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Path_Y = Directory + 'Y.txt'\n",
    "\n",
    "MRIO_Y = pd.read_csv(Path_Y, sep = '\\t', header=0, encoding='iso-8859-1', low_memory=False)\n",
    "# standard UTF-8 encoding raises error\n",
    "\n",
    "MRIO_Y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['region', 'Unnamed: 1', 'AT', 'AT.1', 'AT.2', 'AT.3', 'AT.4', 'AT.5', 'AT.6', 'BE', 'BE.1', 'BE.2', 'BE.3', 'BE.4', 'BE.5', 'BE.6', 'BG', 'BG.1', 'BG.2', 'BG.3', 'BG.4', 'BG.5', 'BG.6', 'CY', 'CY.1', 'CY.2', 'CY.3', 'CY.4', 'CY.5', 'CY.6', 'CZ', 'CZ.1', 'CZ.2', 'CZ.3', 'CZ.4', 'CZ.5', 'CZ.6', 'DE', 'DE.1', 'DE.2', 'DE.3', 'DE.4', 'DE.5', 'DE.6', 'DK', 'DK.1', 'DK.2', 'DK.3', 'DK.4', 'DK.5', 'DK.6', 'EE', 'EE.1', 'EE.2', 'EE.3', 'EE.4', 'EE.5', 'EE.6', 'ES', 'ES.1', 'ES.2', 'ES.3', 'ES.4', 'ES.5', 'ES.6', 'FI', 'FI.1', 'FI.2', 'FI.3', 'FI.4', 'FI.5', 'FI.6', 'FR', 'FR.1', 'FR.2', 'FR.3', 'FR.4', 'FR.5', 'FR.6', 'GR', 'GR.1', 'GR.2', 'GR.3', 'GR.4', 'GR.5', 'GR.6', 'HR', 'HR.1', 'HR.2', 'HR.3', 'HR.4', 'HR.5', 'HR.6', 'HU', 'HU.1', 'HU.2', 'HU.3', 'HU.4', 'HU.5', 'HU.6', 'IE', 'IE.1', 'IE.2', 'IE.3', 'IE.4', 'IE.5', 'IE.6', 'IT', 'IT.1', 'IT.2', 'IT.3', 'IT.4', 'IT.5', 'IT.6', 'LT', 'LT.1', 'LT.2', 'LT.3', 'LT.4', 'LT.5', 'LT.6', 'LU', 'LU.1', 'LU.2', 'LU.3', 'LU.4', 'LU.5', 'LU.6', 'LV', 'LV.1', 'LV.2', 'LV.3', 'LV.4', 'LV.5', 'LV.6', 'MT', 'MT.1', 'MT.2', 'MT.3', 'MT.4', 'MT.5', 'MT.6', 'NL', 'NL.1', 'NL.2', 'NL.3', 'NL.4', 'NL.5', 'NL.6', 'PL', 'PL.1', 'PL.2', 'PL.3', 'PL.4', 'PL.5', 'PL.6', 'PT', 'PT.1', 'PT.2', 'PT.3', 'PT.4', 'PT.5', 'PT.6', 'RO', 'RO.1', 'RO.2', 'RO.3', 'RO.4', 'RO.5', 'RO.6', 'SE', 'SE.1', 'SE.2', 'SE.3', 'SE.4', 'SE.5', 'SE.6', 'SI', 'SI.1', 'SI.2', 'SI.3', 'SI.4', 'SI.5', 'SI.6', 'SK', 'SK.1', 'SK.2', 'SK.3', 'SK.4', 'SK.5', 'SK.6', 'GB', 'GB.1', 'GB.2', 'GB.3', 'GB.4', 'GB.5', 'GB.6', 'US', 'US.1', 'US.2', 'US.3', 'US.4', 'US.5', 'US.6', 'JP', 'JP.1', 'JP.2', 'JP.3', 'JP.4', 'JP.5', 'JP.6', 'CN', 'CN.1', 'CN.2', 'CN.3', 'CN.4', 'CN.5', 'CN.6', 'CA', 'CA.1', 'CA.2', 'CA.3', 'CA.4', 'CA.5', 'CA.6', 'KR', 'KR.1', 'KR.2', 'KR.3', 'KR.4', 'KR.5', 'KR.6', 'BR', 'BR.1', 'BR.2', 'BR.3', 'BR.4', 'BR.5', 'BR.6', 'IN', 'IN.1', 'IN.2', 'IN.3', 'IN.4', 'IN.5', 'IN.6', 'MX', 'MX.1', 'MX.2', 'MX.3', 'MX.4', 'MX.5', 'MX.6', 'RU', 'RU.1', 'RU.2', 'RU.3', 'RU.4', 'RU.5', 'RU.6', 'AU', 'AU.1', 'AU.2', 'AU.3', 'AU.4', 'AU.5', 'AU.6', 'CH', 'CH.1', 'CH.2', 'CH.3', 'CH.4', 'CH.5', 'CH.6', 'TR', 'TR.1', 'TR.2', 'TR.3', 'TR.4', 'TR.5', 'TR.6', 'TW', 'TW.1', 'TW.2', 'TW.3', 'TW.4', 'TW.5', 'TW.6', 'NO', 'NO.1', 'NO.2', 'NO.3', 'NO.4', 'NO.5', 'NO.6', 'ID', 'ID.1', 'ID.2', 'ID.3', 'ID.4', 'ID.5', 'ID.6', 'ZA', 'ZA.1', 'ZA.2', 'ZA.3', 'ZA.4', 'ZA.5', 'ZA.6', 'WA', 'WA.1', 'WA.2', 'WA.3', 'WA.4', 'WA.5', 'WA.6', 'WL', 'WL.1', 'WL.2', 'WL.3', 'WL.4', 'WL.5', 'WL.6', 'WE', 'WE.1', 'WE.2', 'WE.3', 'WE.4', 'WE.5', 'WE.6', 'WF', 'WF.1', 'WF.2', 'WF.3', 'WF.4', 'WF.5', 'WF.6', 'WM', 'WM.1', 'WM.2', 'WM.3', 'WM.4', 'WM.5', 'WM.6']\n"
     ]
    }
   ],
   "source": [
    "print(list(MRIO_Y))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['AT', 'BE', 'BG', 'CY', 'CZ', 'DE', 'DK', 'EE', 'ES', 'FI', 'FR', 'GR', 'HR', 'HU', 'IE', 'IT', 'LT', 'LU', 'LV', 'MT', 'NL', 'PL', 'PT', 'RO', 'SE', 'SI', 'SK', 'GB', 'US', 'JP', 'CN', 'CA', 'KR', 'BR', 'IN', 'MX', 'RU', 'AU', 'CH', 'TR', 'TW', 'NO', 'ID', 'ZA', 'WA', 'WL', 'WE', 'WF', 'WM']\n"
     ]
    }
   ],
   "source": [
    "MRIO_Country = [list(MRIO_Y)[i] for i in np.arange(2,339,7)]\n",
    "\n",
    "print(MRIO_Country)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9800, 343)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MRIO_Y = MRIO_Y.values[2::,2::]\n",
    "MRIO_Y = MRIO_Y.astype('float')\n",
    "\n",
    "MRIO_Y.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting the Production Recipe Matrix (A Matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9800, 9800)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Path_A = Directory + 'A.txt'\n",
    "\n",
    "MRIO_A = pd.read_csv(Path_A, sep = '\\t', header=0, encoding='iso-8859-1', low_memory=False)\n",
    "# standard UTF-8 encoding raises error\n",
    "MRIO_A = MRIO_A.values[2::,2::]\n",
    "MRIO_A = MRIO_A.astype('float')\n",
    "\n",
    "MRIO_A.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[0.00000000e+00 0.00000000e+00 0.00000000e+00 ... 0.00000000e+00\n",
      "  0.00000000e+00 0.00000000e+00]\n",
      " [0.00000000e+00 2.47228078e-02 0.00000000e+00 ... 6.34001208e-06\n",
      "  6.09465180e-06 0.00000000e+00]\n",
      " [0.00000000e+00 0.00000000e+00 1.14924310e-02 ... 1.98291911e-05\n",
      "  1.91962725e-05 0.00000000e+00]\n",
      " ...\n",
      " [0.00000000e+00 3.08914545e-09 2.91511090e-09 ... 1.01312399e-02\n",
      "  1.14444492e-06 0.00000000e+00]\n",
      " [0.00000000e+00 0.00000000e+00 0.00000000e+00 ... 1.90791966e-09\n",
      "  4.13215755e-08 0.00000000e+00]\n",
      " [0.00000000e+00 0.00000000e+00 0.00000000e+00 ... 0.00000000e+00\n",
      "  0.00000000e+00 0.00000000e+00]]\n"
     ]
    }
   ],
   "source": [
    "print(MRIO_A)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting the Emissions/Resource Dataset of Each Industry (F Matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>sector</th>\n",
       "      <th>Paddy rice</th>\n",
       "      <th>Wheat</th>\n",
       "      <th>Cereal grains nec</th>\n",
       "      <th>Vegetables, fruit, nuts</th>\n",
       "      <th>Oil seeds</th>\n",
       "      <th>Sugar cane, sugar beet</th>\n",
       "      <th>Plant-based fibers</th>\n",
       "      <th>Crops nec</th>\n",
       "      <th>Cattle</th>\n",
       "      <th>...</th>\n",
       "      <th>Paper for treatment: landfill.48</th>\n",
       "      <th>Plastic waste for treatment: landfill.48</th>\n",
       "      <th>Inert/metal/hazardous waste for treatment: landfill.48</th>\n",
       "      <th>Textiles waste for treatment: landfill.48</th>\n",
       "      <th>Wood waste for treatment: landfill.48</th>\n",
       "      <th>Membership organisation services n.e.c. (91).48</th>\n",
       "      <th>Recreational, cultural and sporting services (92).48</th>\n",
       "      <th>Other services (93).48</th>\n",
       "      <th>Private households with employed persons (95).48</th>\n",
       "      <th>Extra-territorial organizations and bodies.48</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Taxes less subsidies on products purchased: Total</td>\n",
       "      <td>0</td>\n",
       "      <td>5.109795</td>\n",
       "      <td>9.176743</td>\n",
       "      <td>11.351649</td>\n",
       "      <td>1.771336</td>\n",
       "      <td>0.912881</td>\n",
       "      <td>0.000029</td>\n",
       "      <td>0.872226</td>\n",
       "      <td>34.625772</td>\n",
       "      <td>...</td>\n",
       "      <td>49.313827</td>\n",
       "      <td>32.497542</td>\n",
       "      <td>52.740949</td>\n",
       "      <td>24.625598</td>\n",
       "      <td>27.531848</td>\n",
       "      <td>787.719440</td>\n",
       "      <td>2470.110146</td>\n",
       "      <td>1757.545999</td>\n",
       "      <td>50.378011</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Other net taxes on production</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.433368</td>\n",
       "      <td>-20.355323</td>\n",
       "      <td>-44.942505</td>\n",
       "      <td>-7.964653</td>\n",
       "      <td>-2.826799</td>\n",
       "      <td>-0.001117</td>\n",
       "      <td>-1.882918</td>\n",
       "      <td>-281.379987</td>\n",
       "      <td>...</td>\n",
       "      <td>16.473914</td>\n",
       "      <td>8.920533</td>\n",
       "      <td>17.084769</td>\n",
       "      <td>5.412450</td>\n",
       "      <td>6.081863</td>\n",
       "      <td>69.850474</td>\n",
       "      <td>841.575479</td>\n",
       "      <td>458.763318</td>\n",
       "      <td>35.337660</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.966326</td>\n",
       "      <td>1.792514</td>\n",
       "      <td>3.998784</td>\n",
       "      <td>0.354524</td>\n",
       "      <td>0.284951</td>\n",
       "      <td>0.000103</td>\n",
       "      <td>0.166238</td>\n",
       "      <td>2.637950</td>\n",
       "      <td>...</td>\n",
       "      <td>38.351409</td>\n",
       "      <td>27.306139</td>\n",
       "      <td>39.014220</td>\n",
       "      <td>17.973006</td>\n",
       "      <td>20.531794</td>\n",
       "      <td>661.958001</td>\n",
       "      <td>1195.109158</td>\n",
       "      <td>702.012606</td>\n",
       "      <td>1195.675615</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0</td>\n",
       "      <td>13.323380</td>\n",
       "      <td>24.714585</td>\n",
       "      <td>55.133903</td>\n",
       "      <td>4.888059</td>\n",
       "      <td>3.928802</td>\n",
       "      <td>0.001426</td>\n",
       "      <td>2.292033</td>\n",
       "      <td>36.371167</td>\n",
       "      <td>...</td>\n",
       "      <td>203.387093</td>\n",
       "      <td>136.053086</td>\n",
       "      <td>208.082505</td>\n",
       "      <td>82.637727</td>\n",
       "      <td>97.127609</td>\n",
       "      <td>1592.344370</td>\n",
       "      <td>3132.567192</td>\n",
       "      <td>2003.167947</td>\n",
       "      <td>968.842426</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0</td>\n",
       "      <td>2.117803</td>\n",
       "      <td>3.928479</td>\n",
       "      <td>8.763746</td>\n",
       "      <td>0.776976</td>\n",
       "      <td>0.624498</td>\n",
       "      <td>0.000227</td>\n",
       "      <td>0.364327</td>\n",
       "      <td>5.781337</td>\n",
       "      <td>...</td>\n",
       "      <td>87.181133</td>\n",
       "      <td>53.798699</td>\n",
       "      <td>88.160522</td>\n",
       "      <td>28.112547</td>\n",
       "      <td>34.897900</td>\n",
       "      <td>1390.332371</td>\n",
       "      <td>2590.971348</td>\n",
       "      <td>1759.795800</td>\n",
       "      <td>132.897564</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>1702</th>\n",
       "      <td>Energy Carrier Net LOSS Sugar</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009442</td>\n",
       "      <td>0.001616</td>\n",
       "      <td>0.011135</td>\n",
       "      <td>0.000632</td>\n",
       "      <td>0.000572</td>\n",
       "      <td>0.006245</td>\n",
       "      <td>0.015979</td>\n",
       "      <td>0.491076</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>Energy Carrier Net LOSS Textiles waste for tre...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1704</th>\n",
       "      <td>Energy Carrier Net LOSS White Spirit &amp; SBP</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1705</th>\n",
       "      <td>Energy Carrier Net LOSS Wood material for trea...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1706</th>\n",
       "      <td>Energy Carrier Net LOSS Wood waste for treatme...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1707 rows × 9801 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 sector  Paddy rice  \\\n",
       "0     Taxes less subsidies on products purchased: Total           0   \n",
       "1                         Other net taxes on production           0   \n",
       "2     Compensation of employees; wages, salaries, & ...           0   \n",
       "3     Compensation of employees; wages, salaries, & ...           0   \n",
       "4     Compensation of employees; wages, salaries, & ...           0   \n",
       "...                                                 ...         ...   \n",
       "1702                      Energy Carrier Net LOSS Sugar           0   \n",
       "1703  Energy Carrier Net LOSS Textiles waste for tre...           0   \n",
       "1704         Energy Carrier Net LOSS White Spirit & SBP           0   \n",
       "1705  Energy Carrier Net LOSS Wood material for trea...           0   \n",
       "1706  Energy Carrier Net LOSS Wood waste for treatme...           0   \n",
       "\n",
       "          Wheat  Cereal grains nec  Vegetables, fruit, nuts  Oil seeds  \\\n",
       "0      5.109795           9.176743                11.351649   1.771336   \n",
       "1    -10.433368         -20.355323               -44.942505  -7.964653   \n",
       "2      0.966326           1.792514                 3.998784   0.354524   \n",
       "3     13.323380          24.714585                55.133903   4.888059   \n",
       "4      2.117803           3.928479                 8.763746   0.776976   \n",
       "...         ...                ...                      ...        ...   \n",
       "1702   0.000000           0.000000                 0.000000   0.000000   \n",
       "1703   0.000000           0.000000                 0.000000   0.000000   \n",
       "1704   0.000000           0.000000                 0.000000   0.000000   \n",
       "1705   0.000000           0.000000                 0.000000   0.000000   \n",
       "1706   0.000000           0.000000                 0.000000   0.000000   \n",
       "\n",
       "      Sugar cane, sugar beet  Plant-based fibers  Crops nec      Cattle  ...  \\\n",
       "0                   0.912881            0.000029   0.872226   34.625772  ...   \n",
       "1                  -2.826799           -0.001117  -1.882918 -281.379987  ...   \n",
       "2                   0.284951            0.000103   0.166238    2.637950  ...   \n",
       "3                   3.928802            0.001426   2.292033   36.371167  ...   \n",
       "4                   0.624498            0.000227   0.364327    5.781337  ...   \n",
       "...                      ...                 ...        ...         ...  ...   \n",
       "1702                0.000000            0.000000   0.000000    0.000000  ...   \n",
       "1703                0.000000            0.000000   0.000000    0.000000  ...   \n",
       "1704                0.000000            0.000000   0.000000    0.000000  ...   \n",
       "1705                0.000000            0.000000   0.000000    0.000000  ...   \n",
       "1706                0.000000            0.000000   0.000000    0.000000  ...   \n",
       "\n",
       "      Paper for treatment: landfill.48  \\\n",
       "0                            49.313827   \n",
       "1                            16.473914   \n",
       "2                            38.351409   \n",
       "3                           203.387093   \n",
       "4                            87.181133   \n",
       "...                                ...   \n",
       "1702                          0.009442   \n",
       "1703                          0.000000   \n",
       "1704                          0.000000   \n",
       "1705                          0.000000   \n",
       "1706                          0.000000   \n",
       "\n",
       "      Plastic waste for treatment: landfill.48  \\\n",
       "0                                    32.497542   \n",
       "1                                     8.920533   \n",
       "2                                    27.306139   \n",
       "3                                   136.053086   \n",
       "4                                    53.798699   \n",
       "...                                        ...   \n",
       "1702                                  0.001616   \n",
       "1703                                  0.000000   \n",
       "1704                                  0.000000   \n",
       "1705                                  0.000000   \n",
       "1706                                  0.000000   \n",
       "\n",
       "      Inert/metal/hazardous waste for treatment: landfill.48  \\\n",
       "0                                             52.740949        \n",
       "1                                             17.084769        \n",
       "2                                             39.014220        \n",
       "3                                            208.082505        \n",
       "4                                             88.160522        \n",
       "...                                                 ...        \n",
       "1702                                           0.011135        \n",
       "1703                                           0.000000        \n",
       "1704                                           0.000000        \n",
       "1705                                           0.000000        \n",
       "1706                                           0.000000        \n",
       "\n",
       "      Textiles waste for treatment: landfill.48  \\\n",
       "0                                     24.625598   \n",
       "1                                      5.412450   \n",
       "2                                     17.973006   \n",
       "3                                     82.637727   \n",
       "4                                     28.112547   \n",
       "...                                         ...   \n",
       "1702                                   0.000632   \n",
       "1703                                   0.000000   \n",
       "1704                                   0.000000   \n",
       "1705                                   0.000000   \n",
       "1706                                   0.000000   \n",
       "\n",
       "      Wood waste for treatment: landfill.48  \\\n",
       "0                                 27.531848   \n",
       "1                                  6.081863   \n",
       "2                                 20.531794   \n",
       "3                                 97.127609   \n",
       "4                                 34.897900   \n",
       "...                                     ...   \n",
       "1702                               0.000572   \n",
       "1703                               0.000000   \n",
       "1704                               0.000000   \n",
       "1705                               0.000000   \n",
       "1706                               0.000000   \n",
       "\n",
       "      Membership organisation services n.e.c. (91).48  \\\n",
       "0                                          787.719440   \n",
       "1                                           69.850474   \n",
       "2                                          661.958001   \n",
       "3                                         1592.344370   \n",
       "4                                         1390.332371   \n",
       "...                                               ...   \n",
       "1702                                         0.006245   \n",
       "1703                                         0.000000   \n",
       "1704                                         0.000000   \n",
       "1705                                         0.000000   \n",
       "1706                                         0.000000   \n",
       "\n",
       "      Recreational, cultural and sporting services (92).48  \\\n",
       "0                                           2470.110146      \n",
       "1                                            841.575479      \n",
       "2                                           1195.109158      \n",
       "3                                           3132.567192      \n",
       "4                                           2590.971348      \n",
       "...                                                 ...      \n",
       "1702                                           0.015979      \n",
       "1703                                           0.000000      \n",
       "1704                                           0.000000      \n",
       "1705                                           0.000000      \n",
       "1706                                           0.000000      \n",
       "\n",
       "      Other services (93).48  \\\n",
       "0                1757.545999   \n",
       "1                 458.763318   \n",
       "2                 702.012606   \n",
       "3                2003.167947   \n",
       "4                1759.795800   \n",
       "...                      ...   \n",
       "1702                0.491076   \n",
       "1703                0.000000   \n",
       "1704                0.000000   \n",
       "1705                0.000000   \n",
       "1706                0.000000   \n",
       "\n",
       "      Private households with employed persons (95).48  \\\n",
       "0                                            50.378011   \n",
       "1                                            35.337660   \n",
       "2                                          1195.675615   \n",
       "3                                           968.842426   \n",
       "4                                           132.897564   \n",
       "...                                                ...   \n",
       "1702                                          0.000004   \n",
       "1703                                          0.000000   \n",
       "1704                                          0.000000   \n",
       "1705                                          0.000000   \n",
       "1706                                          0.000000   \n",
       "\n",
       "      Extra-territorial organizations and bodies.48  \n",
       "0                                                 0  \n",
       "1                                                 0  \n",
       "2                                                 0  \n",
       "3                                                 0  \n",
       "4                                                 0  \n",
       "...                                             ...  \n",
       "1702                                              0  \n",
       "1703                                              0  \n",
       "1704                                              0  \n",
       "1705                                              0  \n",
       "1706                                              0  \n",
       "\n",
       "[1707 rows x 9801 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Path_F = Directory + 'satellite//F.txt'\n",
    "\n",
    "MRIO_F = pd.read_csv(Path_F, sep = '\\t', header=1, encoding='iso-8859-1', low_memory=False)\n",
    "\n",
    "MRIO_F"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1707, 9800)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# standard UTF-8 encoding raises error\n",
    "MRIO_F = MRIO_F.values[0::,1::]\n",
    "MRIO_F = MRIO_F.astype('float')\n",
    "\n",
    "MRIO_F.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Direct Emissions Dataset Emitted by Each Final Demand (Fhh Matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>category</th>\n",
       "      <th>Final consumption expenditure by households</th>\n",
       "      <th>Final consumption expenditure by non-profit organisations serving households (NPISH)</th>\n",
       "      <th>Final consumption expenditure by government</th>\n",
       "      <th>Gross fixed capital formation</th>\n",
       "      <th>Changes in inventories</th>\n",
       "      <th>Changes in valuables</th>\n",
       "      <th>Exports: Total (fob)</th>\n",
       "      <th>Final consumption expenditure by households.1</th>\n",
       "      <th>Final consumption expenditure by non-profit organisations serving households (NPISH).1</th>\n",
       "      <th>...</th>\n",
       "      <th>Changes in inventories.47</th>\n",
       "      <th>Changes in valuables.47</th>\n",
       "      <th>Exports: Total (fob).47</th>\n",
       "      <th>Final consumption expenditure by households.48</th>\n",
       "      <th>Final consumption expenditure by non-profit organisations serving households (NPISH).48</th>\n",
       "      <th>Final consumption expenditure by government.48</th>\n",
       "      <th>Gross fixed capital formation.48</th>\n",
       "      <th>Changes in inventories.48</th>\n",
       "      <th>Changes in valuables.48</th>\n",
       "      <th>Exports: Total (fob).48</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Taxes less subsidies on products purchased: Total</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Other net taxes on production</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>1702</th>\n",
       "      <td>Energy Carrier Net LOSS Sugar</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>-297</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>179</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>Energy Carrier Net LOSS Textiles waste for tre...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1704</th>\n",
       "      <td>Energy Carrier Net LOSS White Spirit &amp; SBP</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>-192</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1705</th>\n",
       "      <td>Energy Carrier Net LOSS Wood material for trea...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>-124</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1706</th>\n",
       "      <td>Energy Carrier Net LOSS Wood waste for treatme...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1707 rows × 344 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               category  \\\n",
       "0     Taxes less subsidies on products purchased: Total   \n",
       "1                         Other net taxes on production   \n",
       "2     Compensation of employees; wages, salaries, & ...   \n",
       "3     Compensation of employees; wages, salaries, & ...   \n",
       "4     Compensation of employees; wages, salaries, & ...   \n",
       "...                                                 ...   \n",
       "1702                      Energy Carrier Net LOSS Sugar   \n",
       "1703  Energy Carrier Net LOSS Textiles waste for tre...   \n",
       "1704         Energy Carrier Net LOSS White Spirit & SBP   \n",
       "1705  Energy Carrier Net LOSS Wood material for trea...   \n",
       "1706  Energy Carrier Net LOSS Wood waste for treatme...   \n",
       "\n",
       "      Final consumption expenditure by households  \\\n",
       "0                                             0.0   \n",
       "1                                             0.0   \n",
       "2                                             0.0   \n",
       "3                                             0.0   \n",
       "4                                             0.0   \n",
       "...                                           ...   \n",
       "1702                                          0.0   \n",
       "1703                                          0.0   \n",
       "1704                                          0.0   \n",
       "1705                                          0.0   \n",
       "1706                                          0.0   \n",
       "\n",
       "      Final consumption expenditure by non-profit organisations serving households (NPISH)  \\\n",
       "0                                                   0.0                                      \n",
       "1                                                   0.0                                      \n",
       "2                                                   0.0                                      \n",
       "3                                                   0.0                                      \n",
       "4                                                   0.0                                      \n",
       "...                                                 ...                                      \n",
       "1702                                                0.0                                      \n",
       "1703                                                0.0                                      \n",
       "1704                                                0.0                                      \n",
       "1705                                                0.0                                      \n",
       "1706                                                0.0                                      \n",
       "\n",
       "      Final consumption expenditure by government  \\\n",
       "0                                             0.0   \n",
       "1                                             0.0   \n",
       "2                                             0.0   \n",
       "3                                             0.0   \n",
       "4                                             0.0   \n",
       "...                                           ...   \n",
       "1702                                          0.0   \n",
       "1703                                          0.0   \n",
       "1704                                          0.0   \n",
       "1705                                          0.0   \n",
       "1706                                          0.0   \n",
       "\n",
       "      Gross fixed capital formation  Changes in inventories  \\\n",
       "0                                 0                       0   \n",
       "1                                 0                       0   \n",
       "2                                 0                       0   \n",
       "3                                 0                       0   \n",
       "4                                 0                       0   \n",
       "...                             ...                     ...   \n",
       "1702                              0                    -297   \n",
       "1703                              0                       0   \n",
       "1704                              0                    -192   \n",
       "1705                              0                    -124   \n",
       "1706                              0                       0   \n",
       "\n",
       "      Changes in valuables  Exports: Total (fob)  \\\n",
       "0                        0                     0   \n",
       "1                        0                     0   \n",
       "2                        0                     0   \n",
       "3                        0                     0   \n",
       "4                        0                     0   \n",
       "...                    ...                   ...   \n",
       "1702                     0                     0   \n",
       "1703                     0                     0   \n",
       "1704                     0                     0   \n",
       "1705                     0                     0   \n",
       "1706                     0                     0   \n",
       "\n",
       "      Final consumption expenditure by households.1  \\\n",
       "0                                               0.0   \n",
       "1                                               0.0   \n",
       "2                                               0.0   \n",
       "3                                               0.0   \n",
       "4                                               0.0   \n",
       "...                                             ...   \n",
       "1702                                            0.0   \n",
       "1703                                            0.0   \n",
       "1704                                            0.0   \n",
       "1705                                            0.0   \n",
       "1706                                            0.0   \n",
       "\n",
       "      Final consumption expenditure by non-profit organisations serving households (NPISH).1  \\\n",
       "0                                                   0.0                                        \n",
       "1                                                   0.0                                        \n",
       "2                                                   0.0                                        \n",
       "3                                                   0.0                                        \n",
       "4                                                   0.0                                        \n",
       "...                                                 ...                                        \n",
       "1702                                                0.0                                        \n",
       "1703                                                0.0                                        \n",
       "1704                                                0.0                                        \n",
       "1705                                                0.0                                        \n",
       "1706                                                0.0                                        \n",
       "\n",
       "      ...  Changes in inventories.47  Changes in valuables.47  \\\n",
       "0     ...                          0                        0   \n",
       "1     ...                          0                        0   \n",
       "2     ...                          0                        0   \n",
       "3     ...                          0                        0   \n",
       "4     ...                          0                        0   \n",
       "...   ...                        ...                      ...   \n",
       "1702  ...                        179                        0   \n",
       "1703  ...                          0                        0   \n",
       "1704  ...                          0                        0   \n",
       "1705  ...                          0                        0   \n",
       "1706  ...                          0                        0   \n",
       "\n",
       "      Exports: Total (fob).47  Final consumption expenditure by households.48  \\\n",
       "0                           0                                             0.0   \n",
       "1                           0                                             0.0   \n",
       "2                           0                                             0.0   \n",
       "3                           0                                             0.0   \n",
       "4                           0                                             0.0   \n",
       "...                       ...                                             ...   \n",
       "1702                        0                                             0.0   \n",
       "1703                        0                                             0.0   \n",
       "1704                        0                                             0.0   \n",
       "1705                        0                                             0.0   \n",
       "1706                        0                                             0.0   \n",
       "\n",
       "      Final consumption expenditure by non-profit organisations serving households (NPISH).48  \\\n",
       "0                                                   0.0                                         \n",
       "1                                                   0.0                                         \n",
       "2                                                   0.0                                         \n",
       "3                                                   0.0                                         \n",
       "4                                                   0.0                                         \n",
       "...                                                 ...                                         \n",
       "1702                                                0.0                                         \n",
       "1703                                                0.0                                         \n",
       "1704                                                0.0                                         \n",
       "1705                                                0.0                                         \n",
       "1706                                                0.0                                         \n",
       "\n",
       "      Final consumption expenditure by government.48  \\\n",
       "0                                                0.0   \n",
       "1                                                0.0   \n",
       "2                                                0.0   \n",
       "3                                                0.0   \n",
       "4                                                0.0   \n",
       "...                                              ...   \n",
       "1702                                             0.0   \n",
       "1703                                             0.0   \n",
       "1704                                             0.0   \n",
       "1705                                             0.0   \n",
       "1706                                             0.0   \n",
       "\n",
       "      Gross fixed capital formation.48  Changes in inventories.48  \\\n",
       "0                                    0                          0   \n",
       "1                                    0                          0   \n",
       "2                                    0                          0   \n",
       "3                                    0                          0   \n",
       "4                                    0                          0   \n",
       "...                                ...                        ...   \n",
       "1702                                 0                        -12   \n",
       "1703                                 0                          0   \n",
       "1704                                 0                        344   \n",
       "1705                                 0                          0   \n",
       "1706                                 0                          0   \n",
       "\n",
       "      Changes in valuables.48  Exports: Total (fob).48  \n",
       "0                           0                        0  \n",
       "1                           0                        0  \n",
       "2                           0                        0  \n",
       "3                           0                        0  \n",
       "4                           0                        0  \n",
       "...                       ...                      ...  \n",
       "1702                        0                        0  \n",
       "1703                        0                        0  \n",
       "1704                        0                        0  \n",
       "1705                        0                        0  \n",
       "1706                        0                        0  \n",
       "\n",
       "[1707 rows x 344 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Path_Fhh = Directory + 'satellite//F_hh.txt'\n",
    "MRIO_Fhh = pd.read_csv(Path_Fhh, sep = '\\t', header=1, encoding='iso-8859-1', low_memory=False)\n",
    "# standard UTF-8 encoding raises error\n",
    "\n",
    "MRIO_Fhh"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1707, 343)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MRIO_FCat= list(MRIO_Fhh)[1:8]\n",
    "MRIO_FCat\n",
    "\n",
    "MRIO_Fhh = MRIO_Fhh.values[0::,1::]\n",
    "MRIO_Fhh = MRIO_Fhh.astype('float')\n",
    "\n",
    "MRIO_Fhh.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 1.61794916e+10,  3.76767290e+08,  7.80745446e+08,  0.00000000e+00,\n",
       "       -1.24017000e+05,  0.00000000e+00,  0.00000000e+00,  2.54597595e+10,\n",
       "        1.40492509e+09,  2.92687270e+09,  0.00000000e+00, -2.21526600e+06,\n",
       "        0.00000000e+00,  0.00000000e+00,  4.68566766e+09,  1.30553697e+07,\n",
       "        2.32697049e+07,  0.00000000e+00, -2.47200000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.69789056e+09,  0.00000000e+00,  6.56828239e+02,\n",
       "        0.00000000e+00,  5.38860000e+04,  0.00000000e+00,  0.00000000e+00,\n",
       "        1.27283193e+10,  7.55676107e+08,  1.67335579e+09,  0.00000000e+00,\n",
       "       -1.48611000e+05,  0.00000000e+00,  0.00000000e+00,  2.25666239e+11,\n",
       "        9.99385077e+05,  5.21894170e+08,  0.00000000e+00, -3.26475000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.04034720e+10,  1.73867596e+08,\n",
       "        6.39219777e+08,  0.00000000e+00, -2.05530000e+05,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.05047311e+09,  7.59321952e+00,  1.18391972e+05,\n",
       "        0.00000000e+00, -5.65010000e+04,  0.00000000e+00,  0.00000000e+00,\n",
       "        5.58848812e+10,  1.24722615e+09,  2.70393147e+09,  0.00000000e+00,\n",
       "        2.32368000e+05,  0.00000000e+00,  0.00000000e+00,  7.78163545e+09,\n",
       "        2.23061338e+07,  4.54440417e+07,  0.00000000e+00, -1.11165000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.03938898e+11,  5.03666912e+09,\n",
       "        9.81288075e+09,  0.00000000e+00,  7.35420000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  2.08360160e+10,  3.90028608e+07,  1.50295221e+08,\n",
       "        0.00000000e+00, -2.97390000e+04,  0.00000000e+00,  0.00000000e+00,\n",
       "        4.34534472e+09,  1.86549660e+08,  3.67368587e+08,  0.00000000e+00,\n",
       "        5.13600000e+03,  0.00000000e+00,  0.00000000e+00,  9.25477607e+09,\n",
       "        1.75144789e+02,  7.69856956e+09,  0.00000000e+00,  5.92917000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.45137797e+10,  9.06939967e+05,\n",
       "        1.66953862e+08,  0.00000000e+00,  3.13300000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  9.31601705e+10,  4.88159398e+09,  1.10482475e+10,\n",
       "        0.00000000e+00, -6.75711000e+05,  0.00000000e+00,  0.00000000e+00,\n",
       "        5.82981960e+09,  7.33048789e+06,  9.06534196e+07,  0.00000000e+00,\n",
       "        6.47000000e+03,  0.00000000e+00,  0.00000000e+00,  1.97393446e+09,\n",
       "        8.27469529e+07,  1.83716306e+08,  0.00000000e+00,  4.79700000e+03,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.81950721e+09,  5.26573452e+07,\n",
       "        6.92084944e+07,  0.00000000e+00, -8.00070000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.54445173e+08,  0.00000000e+00,  0.00000000e+00,\n",
       "        0.00000000e+00,  4.24620000e+04,  0.00000000e+00,  0.00000000e+00,\n",
       "        2.53243534e+10,  2.62022320e+09,  8.52743706e+09,  0.00000000e+00,\n",
       "        1.79627700e+06,  0.00000000e+00,  0.00000000e+00,  5.62106422e+10,\n",
       "        2.37555271e+09,  2.14391410e+09,  0.00000000e+00, -3.62397000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.28328854e+10,  1.04911383e+08,\n",
       "        1.69058291e+08,  0.00000000e+00, -6.15870000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.41304626e+10,  0.00000000e+00,  5.24223883e+09,\n",
       "        0.00000000e+00,  2.68386000e+05,  0.00000000e+00,  0.00000000e+00,\n",
       "        1.06028541e+10,  9.35683656e+06,  6.36817968e+07,  0.00000000e+00,\n",
       "       -5.10336000e+05,  0.00000000e+00,  0.00000000e+00,  4.20194947e+09,\n",
       "        0.00000000e+00,  2.69991484e+08,  0.00000000e+00,  5.68290000e+04,\n",
       "        0.00000000e+00,  0.00000000e+00,  4.52676501e+09,  4.16868066e+08,\n",
       "        7.88293465e+08,  0.00000000e+00,  3.38291000e+05,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.35138966e+11,  1.02207363e+10,  1.79367784e+10,\n",
       "        0.00000000e+00, -2.55780000e+06,  0.00000000e+00,  0.00000000e+00,\n",
       "        1.47907504e+12,  2.32605842e-07,  4.69894499e-07,  0.00000000e+00,\n",
       "        4.29284200e+06,  0.00000000e+00,  0.00000000e+00,  1.77475818e+11,\n",
       "        2.68106847e+09,  5.39689063e+09,  0.00000000e+00,  3.40398300e+06,\n",
       "        0.00000000e+00,  0.00000000e+00,  3.92462947e+11,  7.74376047e+09,\n",
       "        1.22583134e+10,  0.00000000e+00,  1.37116860e+07,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.20938910e+11,  2.43265441e+01,  1.11653925e+02,\n",
       "        0.00000000e+00, -1.96911000e+06,  0.00000000e+00,  0.00000000e+00,\n",
       "        4.54847218e+10,  3.40649123e+09,  7.58902379e+09,  0.00000000e+00,\n",
       "        9.65547000e+05,  0.00000000e+00,  0.00000000e+00,  6.46402643e+10,\n",
       "        2.71954098e+07,  1.39034171e+08,  0.00000000e+00,  7.64820000e+04,\n",
       "        0.00000000e+00,  0.00000000e+00,  1.74576744e+11,  2.07416856e+10,\n",
       "        3.40266502e+10,  0.00000000e+00,  3.73082700e+06,  0.00000000e+00,\n",
       "        0.00000000e+00,  1.11376977e+11,  1.78743867e+08,  2.73542070e+08,\n",
       "        0.00000000e+00, -1.29335600e+06,  0.00000000e+00,  0.00000000e+00,\n",
       "        1.72820848e+11,  7.88412284e+09,  1.47704644e+10,  0.00000000e+00,\n",
       "       -2.40794800e+06,  0.00000000e+00,  0.00000000e+00,  5.37510568e+10,\n",
       "        9.33634800e+07,  1.64592734e+08,  0.00000000e+00, -5.96064000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  2.00325500e+10,  3.17280613e+08,\n",
       "        4.32436694e+08,  0.00000000e+00, -4.70190000e+04,  0.00000000e+00,\n",
       "        0.00000000e+00,  5.08772914e+10,  6.77299819e+08,  4.02740895e+09,\n",
       "        0.00000000e+00,  4.87317000e+05,  0.00000000e+00,  0.00000000e+00,\n",
       "        1.81764230e+10,  1.77325766e+08,  3.64006857e+08,  0.00000000e+00,\n",
       "        5.99208000e+05,  0.00000000e+00,  0.00000000e+00,  5.73943393e+09,\n",
       "        1.52284407e+06,  3.23187430e+06,  0.00000000e+00,  2.03487000e+05,\n",
       "        0.00000000e+00,  0.00000000e+00,  6.50367217e+10,  3.50823617e+06,\n",
       "        6.12756514e+06,  0.00000000e+00, -7.72668000e+05,  0.00000000e+00,\n",
       "        0.00000000e+00,  4.48970402e+10,  8.33224709e+04,  9.15957158e+06,\n",
       "        0.00000000e+00, -5.01933000e+05,  0.00000000e+00,  0.00000000e+00,\n",
       "        2.35016549e+11,  1.51364595e+08,  3.97574097e+08,  0.00000000e+00,\n",
       "        4.09493000e+05,  0.00000000e+00,  0.00000000e+00,  1.88467976e+11,\n",
       "        1.58957650e+06,  4.18244041e+06,  0.00000000e+00, -2.03824800e+06,\n",
       "        0.00000000e+00,  0.00000000e+00,  5.38296615e+10,  1.79906649e+05,\n",
       "        3.19592408e+08,  0.00000000e+00,  1.68268000e+05,  0.00000000e+00,\n",
       "        0.00000000e+00,  2.68279409e+11,  4.27482252e+06,  7.33784565e+08,\n",
       "        0.00000000e+00, -2.23701900e+06,  0.00000000e+00,  0.00000000e+00,\n",
       "        3.43754535e+11,  3.34961243e+07,  5.04433871e+08,  0.00000000e+00,\n",
       "       -5.32421400e+06,  0.00000000e+00,  0.00000000e+00])"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MRIO_Fhh.sum(axis=0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting the Emissions/Resource Names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Unnamed: 0</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Taxes less subsidies on products purchased: Total</td>\n",
       "      <td>M.EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Other net taxes on production</td>\n",
       "      <td>M.EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>M.EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>M.EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Compensation of employees; wages, salaries, &amp; ...</td>\n",
       "      <td>M.EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1702</th>\n",
       "      <td>Energy Carrier Net LOSS Sugar</td>\n",
       "      <td>TJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>Energy Carrier Net LOSS Textiles waste for tre...</td>\n",
       "      <td>TJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1704</th>\n",
       "      <td>Energy Carrier Net LOSS White Spirit &amp; SBP</td>\n",
       "      <td>TJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1705</th>\n",
       "      <td>Energy Carrier Net LOSS Wood material for trea...</td>\n",
       "      <td>TJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1706</th>\n",
       "      <td>Energy Carrier Net LOSS Wood waste for treatme...</td>\n",
       "      <td>TJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1707 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Unnamed: 0   unit\n",
       "0     Taxes less subsidies on products purchased: Total  M.EUR\n",
       "1                         Other net taxes on production  M.EUR\n",
       "2     Compensation of employees; wages, salaries, & ...  M.EUR\n",
       "3     Compensation of employees; wages, salaries, & ...  M.EUR\n",
       "4     Compensation of employees; wages, salaries, & ...  M.EUR\n",
       "...                                                 ...    ...\n",
       "1702                      Energy Carrier Net LOSS Sugar     TJ\n",
       "1703  Energy Carrier Net LOSS Textiles waste for tre...     TJ\n",
       "1704         Energy Carrier Net LOSS White Spirit & SBP     TJ\n",
       "1705  Energy Carrier Net LOSS Wood material for trea...     TJ\n",
       "1706  Energy Carrier Net LOSS Wood waste for treatme...     TJ\n",
       "\n",
       "[1707 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Path_Fdata = Directory + 'satellite//unit.txt'\n",
    "MRIO_Fdata = pd.read_csv(Path_Fdata, sep = '\\t', header=0, encoding = 'iso-8859-1') # standard UTF-8 encoding raises error\n",
    "MRIO_Fdata = MRIO_Fdata.astype('str')\n",
    "\n",
    "MRIO_Fdata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "MRIO_Ftype = list(MRIO_Fdata.iloc[:,0])\n",
    "MRIO_Funit = list(MRIO_Fdata.iloc[:,1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Taxes less subsidies on products purchased: Total', 'Other net taxes on production', \"Compensation of employees; wages, salaries, & employers' social contributions: Low-skilled\", \"Compensation of employees; wages, salaries, & employers' social contributions: Medium-skilled\", \"Compensation of employees; wages, salaries, & employers' social contributions: High-skilled\", 'Operating surplus: Consumption of fixed capital', 'Operating surplus: Rents on land', 'Operating surplus: Royalties on resources', 'Operating surplus: Remaining net operating surplus', 'Employment: Low-skilled male', 'Employment: Low-skilled female', 'Employment: Medium-skilled male', 'Employment: Medium-skilled female', 'Employment: High-skilled male', 'Employment: High-skilled female', 'Employment hours: Low-skilled male', 'Employment hours: Low-skilled female', 'Employment hours: Medium-skilled male', 'Employment hours: Medium-skilled female', 'Employment hours: High-skilled male', 'Employment hours: High-skilled female', 'Employment: Vulnerable employment', 'Employment hours: Vulnerable employment', 'CO2 - combustion - air', 'CH4 - combustion - air', 'N2O - combustion - air', 'SOx - combustion - air', 'NOx - combustion - air', 'NH3 - combustion - air', 'CO - combustion - air', 'Benzo(a)pyrene - combustion - air', 'Benzo(b)fluoranthene - combustion - air', 'Benzo(k)fluoranthene - combustion - air', 'Indeno(1,2,3-cd)pyrene - combustion - air', 'PCBs - combustion - air', 'PCDD_F - combustion - air', 'HCB - combustion - air', 'NMVOC - combustion - air', 'PM10 - combustion - air', 'PM2.5 - combustion - air', 'TSP - combustion - air', 'As - combustion - air', 'Cd - combustion - air', 'Cr - combustion - air', 'Cu - combustion - air', 'Hg - combustion - air', 'Ni - combustion - air', 'Pb - combustion - air', 'Se - combustion - air', 'Zn - combustion - air', 'As - non combustion - Agglomeration plant - pellets - air', 'As - non combustion - Agglomeration plant - sinter - air', 'As - non combustion - Glass production - air', 'As - non combustion - Production of coke oven coke - air', 'As - non combustion - Production of gascoke - air', 'As - non combustion - Steel production: basic oxygen furnace - air', 'As - non combustion - Steel production: electric arc furnace - air', 'As - non combustion - Steel production: open hearth furnace - air', 'B(a)P - non combustion - Primary aluminium production - air', 'B(a)P - non combustion - Production of coke oven coke - air', 'B(a)P - non combustion - Production of gascoke - air', 'B(b)F - non combustion - Primary aluminium production - air', 'B(b)F - non combustion - Production of coke oven coke - air', 'B(b)F - non combustion - Production of gascoke - air', 'B(k)F - non combustion - Primary aluminium production - air', 'B(k)F - non combustion - Production of coke oven coke - air', 'B(k)F - non combustion - Production of gascoke - air', 'CH4 - non combustion - Extraction/production of (natural) gas - air', 'CH4 - non combustion - Extraction/production of crude oil - air', 'CH4 - non combustion - Mining of antracite - air', 'CH4 - non combustion - Mining of bituminous coal - air', 'CH4 - non combustion - Mining of coking coal - air', 'CH4 - non combustion - Mining of lignite (brown coal) - air', 'CH4 - non combustion - Mining of sub-bituminous coal - air', 'CH4 - non combustion - Oil refinery - air', 'CO - non combustion - Agglomeration plant - sinter - air', 'CO - non combustion - Bricks production - air', 'CO - non combustion - Carbon black production - air', 'CO - non combustion - Cement production - air', 'CO - non combustion - Chemical wood pulp, dissolving grades - air', 'CO - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'CO - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'CO - non combustion - Glass production - air', 'CO - non combustion - Lime production - air', 'CO - non combustion - Oil refinery - air', 'CO - non combustion - Pig iron production, blast furnace - air', 'CO - non combustion - Primary aluminium production - air', 'CO - non combustion - Production of coke oven coke - air', 'CO - non combustion - Production of gascoke - air', 'CO - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'CO - non combustion - Steel production: basic oxygen furnace - air', 'CO - non combustion - Steel production: electric arc furnace - air', 'CO2 - non combustion - Cement production - air', 'CO2 - non combustion - Lime production - air', 'Cd - non combustion - Agglomeration plant - pellets - air', 'Cd - non combustion - Agglomeration plant - sinter - air', 'Cd - non combustion - Glass production - air', 'Cd - non combustion - Nickel, unwrought - air', 'Cd - non combustion - Production of coke oven coke - air', 'Cd - non combustion - Production of gascoke - air', 'Cd - non combustion - Refined copper; unwrought, not alloyed - air', 'Cd - non combustion - Refined lead, unwrought - air', 'Cd - non combustion - Steel production: basic oxygen furnace - air', 'Cd - non combustion - Steel production: electric arc furnace - air', 'Cd - non combustion - Steel production: open hearth furnace - air', 'Cd - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'Cd - non combustion - Zinc, unwrought, not alloyed - air', 'Cr - non combustion - Agglomeration plant - pellets - air', 'Cr - non combustion - Agglomeration plant - sinter - air', 'Cr - non combustion - Glass production - air', 'Cr - non combustion - Pig iron production, blast furnace - air', 'Cr - non combustion - Steel production: basic oxygen furnace - air', 'Cr - non combustion - Steel production: electric arc furnace - air', 'Cr - non combustion - Steel production: open hearth furnace - air', 'Cu - non combustion - Agglomeration plant - pellets - air', 'Cu - non combustion - Agglomeration plant - sinter - air', 'Cu - non combustion - Glass production - air', 'Cu - non combustion - Pig iron production, blast furnace - air', 'Cu - non combustion - Steel production: basic oxygen furnace - air', 'Cu - non combustion - Steel production: electric arc furnace - air', 'Cu - non combustion - Steel production: open hearth furnace - air', 'HCB - non combustion - Agglomeration plant - pellets - air', 'HCB - non combustion - Agglomeration plant - sinter - air', 'Hg - non combustion - Agglomeration plant - pellets - air', 'Hg - non combustion - Agglomeration plant - sinter - air', 'Hg - non combustion - Glass production - air', 'Hg - non combustion - Nickel, unwrought - air', 'Hg - non combustion - Pig iron production, blast furnace - air', 'Hg - non combustion - Production of coke oven coke - air', 'Hg - non combustion - Production of gascoke - air', 'Hg - non combustion - Refined copper; unwrought, not alloyed - air', 'Hg - non combustion - Refined lead, unwrought - air', 'HCB - non combustion - Secondary aluminium production - air', 'Hg - non combustion - Steel production: basic oxygen furnace - air', 'Hg - non combustion - Steel production: electric arc furnace - air', 'Hg - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'Hg - non combustion - Zinc, unwrought, not alloyed - air', 'Indeno - non combustion - Primary aluminium production - air', 'Indeno - non combustion - Production of coke oven coke - air', 'Indeno - non combustion - Production of gascoke - air', 'NH3 - non combustion - N- fertilizer production - air', 'NMVOC - non combustion - Beef and veal - air', 'NMVOC - non combustion - Coil coating (coating of aluminum and steel) - air', 'NMVOC - non combustion - Decorative paint applicatoin - air', 'NMVOC - non combustion - Degreasing - air', 'NMVOC - non combustion - Diesel distribution - transport and depots (used in mobile sources) - air', 'NMVOC - non combustion - Diesel distribution - transport and depots (used in stationary sources) - air', 'NMVOC - non combustion - Dry cleaning - air', 'NMVOC - non combustion - Extraction, proc. and distribution of gaseous fuels - air', 'NMVOC - non combustion - Extraction, proc. and distribution of liquid fuels - air', 'NMVOC - non combustion - Extraction/production of (natural) gas - air', 'NMVOC - non combustion - Extraction/production of crude oil - air', 'NMVOC - non combustion - Fat, edible and non-edible oil extraction - air', 'NMVOC - non combustion - Fish, dried, salted or in brine; smoked fish; edible fish meal - air', 'NMVOC - non combustion - Fish, fish fillets, other fish meat and fish livers and roes, frozen - air', 'NMVOC - non combustion - Fish, otherwise prepared or preserved; caviar - air', 'NMVOC - non combustion - Flexography and rotogravure in packaging - air', 'NMVOC - non combustion - Gasoline distribution - service stations - air', 'NMVOC - non combustion - Gasoline distribution - transport and depots (used in mobile sources) - air', 'NMVOC - non combustion - Gasoline distribution - transport and depots (used in stationary sources) - air', 'NMVOC - non combustion - Industrial application of adhesives (use of high performance solvent based adhesives) - air', 'NMVOC - non combustion - Industrial application of adhesives (use of traditional solvent based adhesives) - air', 'NMVOC - non combustion - Industrial paint application, general industry (continuous processes) - air', 'NMVOC - non combustion - Industrial paint application, general industry (plastic parts) - air', 'NMVOC - non combustion - Industrial paint application, general industry - air', 'NMVOC - non combustion - Inorganic chemical industry, fertilizers and other - air', 'NMVOC - non combustion - Leather coating - air', 'NMVOC - non combustion - Manufacture of automobiles - air', 'NMVOC - non combustion - Mutton and lamb - air', 'NMVOC - non combustion - Oil refinery - air', 'NMVOC - non combustion - Organic chemical industry - downstream units - air', 'NMVOC - non combustion - Organic chemical industry, storage - air', 'NMVOC - non combustion - Other industrial use of solvents - air', 'NMVOC - non combustion - Pharmaceutical industry - air', 'NMVOC - non combustion - Polystyrene processing - air', 'NMVOC - non combustion - Polyvinylchloride produceduction by suspension process - air', 'NMVOC - non combustion - Pork - air', 'NMVOC - non combustion - Poultry, dressed - air', 'NMVOC - non combustion - Printing, offset - air', 'NMVOC - non combustion - Products incorporating solvents - air', 'NMVOC - non combustion - Raw sugar - air', 'NMVOC - non combustion - Rotogravure in publication - air', 'NMVOC - non combustion - Screen printing - air', 'NMVOC - non combustion - Steam cracking (ethylene and propylene production) - air', 'NMVOC - non combustion - Synthetic rubber - air', 'NMVOC - non combustion - Tyre production - air', 'NMVOC - non combustion - Vehicle refinishing - air', 'NMVOC - non combustion - Wire coating - air', 'NOx - non combustion - Agglomeration plant - pellets - air', 'NOx - non combustion - Agglomeration plant - sinter - air', 'NOx - non combustion - Bricks production - air', 'NOx - non combustion - Cement production - air', 'NOx - non combustion - Chemical wood pulp, dissolving grades - air', 'NOx - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'NOx - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'NOx - non combustion - Glass production - air', 'NOx - non combustion - Lime production - air', 'NOx - non combustion - Nickel, unwrought - air', 'NOx - non combustion - Oil refinery - air', 'NOx - non combustion - Pig iron production, blast furnace - air', 'NOx - non combustion - Production of coke oven coke - air', 'NOx - non combustion - Production of gascoke - air', 'NOx - non combustion - Refined copper; unwrought, not alloyed - air', 'NOx - non combustion - Refined lead, unwrought - air', 'NOx - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'NOx - non combustion - Steel production: basic oxygen furnace - air', 'NOx - non combustion - Steel production: electric arc furnace - air', 'NOx - non combustion - Sulphuric acid production - air', 'NOx - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'NOx - non combustion - Zinc, unwrought, not alloyed - air', 'Ni - non combustion - Agglomeration plant - pellets - air', 'Ni - non combustion - Agglomeration plant - sinter - air', 'Ni - non combustion - Glass production - air', 'Ni - non combustion - Production of coke oven coke - air', 'Ni - non combustion - Production of gascoke - air', 'Ni - non combustion - Steel production: basic oxygen furnace - air', 'Ni - non combustion - Steel production: electric arc furnace - air', 'Ni - non combustion - Steel production: open hearth furnace - air', 'PAH - non combustion - Agglomeration plant - pellets - air', 'PAH - non combustion - Agglomeration plant - sinter - air', 'PAH - non combustion - Pig iron production, blast furnace - air', 'PAH - non combustion - Production of coke oven coke - air', 'PAH - non combustion - Production of gascoke - air', 'PAH - non combustion - Steel production: basic oxygen furnace - air', 'PAH - non combustion - Steel production: electric arc furnace - air', 'PCB - non combustion - Agglomeration plant - pellets - air', 'PCB - non combustion - Agglomeration plant - sinter - air', 'PCB - non combustion - Pig iron production, blast furnace - air', 'PCB - non combustion - Steel production: basic oxygen furnace - air', 'PCB - non combustion - Steel production: electric arc furnace - air', 'PCDD/F - non combustion - Agglomeration plant - pellets - air', 'PCDD/F - non combustion - Agglomeration plant - sinter - air', 'PCDD/F - non combustion - Pig iron production, blast furnace - air', 'PCDD/F - non combustion - Secondary aluminium production - air', 'PCDD/F - non combustion - Steel production: basic oxygen furnace - air', 'PCDD/F - non combustion - Steel production: electric arc furnace - air', 'PM10 - non combustion - Agglomeration plant - pellets - air', 'PM10 - non combustion - Agglomeration plant - sinter - air', 'PM10 - non combustion - Aluminium ores and concentrates (Bauxite) - air', 'PM10 - non combustion - Bricks production - air', 'PM10 - non combustion - Briquettes production - air', 'PM10 - non combustion - Carbon black production - air', 'PM10 - non combustion - Cast iron production (grey iron foundries) - air', 'PM10 - non combustion - Cement production - air', 'PM10 - non combustion - Chemical wood pulp, dissolving grades - air', 'PM10 - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'PM10 - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'PM10 - non combustion - Chromium ores and concentrates - air', 'PM10 - non combustion - Copper ores and concentrates - air', 'PM10 - non combustion - Fertilizer production (N-fertilizer) - air', 'PM10 - non combustion - Glass production - air', 'PM10 - non combustion - Gold ores and concentrates - air', 'PM10 - non combustion - Iron ores and concentrates - air', 'PM10 - non combustion - Lead ores and concentrates - air', 'PM10 - non combustion - Lime production - air', 'PM10 - non combustion - Mining of antracite - air', 'PM10 - non combustion - Mining of bituminous coal - air', 'PM10 - non combustion - Mining of coking coal - air', 'PM10 - non combustion - Mining of lignite (brown coal) - air', 'PM10 - non combustion - Mining of sub-bituminous coal - air', 'PM10 - non combustion - Molybdenum ores and concentrates - air', 'PM10 - non combustion - N- fertilizer production - air', 'PM10 - non combustion - Nickel ores and concentrates - air', 'PM10 - non combustion - Nickel, unwrought - air', 'PM10 - non combustion - Oil refinery - air', 'PM10 - non combustion - Pig iron production, blast furnace - air', 'PM10 - non combustion - Platinum ores and concentrates - air', 'PM10 - non combustion - Primary aluminium production - air', 'PM10 - non combustion - Production of coke oven coke - air', 'PM10 - non combustion - Production of gascoke - air', 'PM10 - non combustion - Refined copper; unwrought, not alloyed - air', 'PM10 - non combustion - Refined lead, unwrought - air', 'PM10 - non combustion - Secondary aluminium production - air', 'PM10 - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'PM10 - non combustion - Silver ores and concentrates - air', 'PM10 - non combustion - Steel production: basic oxygen furnace - air', 'PM10 - non combustion - Steel production: electric arc furnace - air', 'PM10 - non combustion - Steel production: open hearth furnace - air', 'PM10 - non combustion - Tin ores and concentrates - air', 'PM10 - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'PM10 - non combustion - Zinc ores and concentrates - air', 'PM10 - non combustion - Zinc, unwrought, not alloyed - air', 'PM2.5 - non combustion - Agglomeration plant - pellets - air', 'PM2.5 - non combustion - Agglomeration plant - sinter - air', 'PM2.5 - non combustion - Aluminium ores and concentrates (Bauxite) - air', 'PM2.5 - non combustion - Bricks production - air', 'PM2.5 - non combustion - Briquettes production - air', 'PM2.5 - non combustion - Carbon black production - air', 'PM2.5 - non combustion - Cast iron production (grey iron foundries) - air', 'PM2.5 - non combustion - Cement production - air', 'PM2.5 - non combustion - Chemical wood pulp, dissolving grades - air', 'PM2.5 - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'PM2.5 - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'PM2.5 - non combustion - Chromium ores and concentrates - air', 'PM2.5 - non combustion - Copper ores and concentrates - air', 'PM2.5 - non combustion - Fertilizer production (N-fertilizer) - air', 'PM2.5 - non combustion - Glass production - air', 'PM2.5 - non combustion - Gold ores and concentrates - air', 'PM2.5 - non combustion - Iron ores and concentrates - air', 'PM2.5 - non combustion - Lead ores and concentrates - air', 'PM2.5 - non combustion - Lime production - air', 'PM2.5 - non combustion - Mining of antracite - air', 'PM2.5 - non combustion - Mining of bituminous coal - air', 'PM2.5 - non combustion - Mining of coking coal - air', 'PM2.5 - non combustion - Mining of lignite (brown coal) - air', 'PM2.5 - non combustion - Mining of sub-bituminous coal - air', 'PM2.5 - non combustion - Molybdenum ores and concentrates - air', 'PM2.5 - non combustion - N- fertilizer production - air', 'PM2.5 - non combustion - Nickel ores and concentrates - air', 'PM2.5 - non combustion - Nickel, unwrought - air', 'PM2.5 - non combustion - Oil refinery - air', 'PM2.5 - non combustion - Pig iron production, blast furnace - air', 'PM2.5 - non combustion - Platinum ores and concentrates - air', 'PM2.5 - non combustion - Primary aluminium production - air', 'PM2.5 - non combustion - Production of coke oven coke - air', 'PM2.5 - non combustion - Production of gascoke - air', 'PM2.5 - non combustion - Refined copper; unwrought, not alloyed - air', 'PM2.5 - non combustion - Refined lead, unwrought - air', 'PM2.5 - non combustion - Secondary aluminium production - air', 'PM2.5 - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'PM2.5 - non combustion - Silver ores and concentrates - air', 'PM2.5 - non combustion - Steel production: basic oxygen furnace - air', 'PM2.5 - non combustion - Steel production: electric arc furnace - air', 'PM2.5 - non combustion - Steel production: open hearth furnace - air', 'PM2.5 - non combustion - Tin ores and concentrates - air', 'PM2.5 - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'PM2.5 - non combustion - Zinc ores and concentrates - air', 'PM2.5 - non combustion - Zinc, unwrought, not alloyed - air', 'Pb - non combustion - Agglomeration plant - pellets - air', 'Pb - non combustion - Agglomeration plant - sinter - air', 'Pb - non combustion - Glass production - air', 'Pb - non combustion - Nickel, unwrought - air', 'Pb - non combustion - Pig iron production, blast furnace - air', 'Pb - non combustion - Production of coke oven coke - air', 'Pb - non combustion - Production of gascoke - air', 'Pb - non combustion - Refined copper; unwrought, not alloyed - air', 'Pb - non combustion - Refined lead, unwrought - air', 'Pb - non combustion - Steel production: basic oxygen furnace - air', 'Pb - non combustion - Steel production: electric arc furnace - air', 'Pb - non combustion - Steel production: open hearth furnace - air', 'Pb - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'Pb - non combustion - Zinc, unwrought, not alloyed - air', 'SOx - non combustion - Agglomeration plant - sinter - air', 'SOx - non combustion - Bricks production - air', 'SOx - non combustion - Cement production - air', 'SOx - non combustion - Chemical wood pulp, dissolving grades - air', 'SOx - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'SOx - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'SOx - non combustion - Glass production - air', 'SOx - non combustion - Lime production - air', 'SOx - non combustion - Nickel, unwrought - air', 'SOx - non combustion - Oil refinery - air', 'SOx - non combustion - Pig iron production, blast furnace - air', 'SOx - non combustion - Production of coke oven coke - air', 'SOx - non combustion - Production of gascoke - air', 'SOx - non combustion - Refined copper; unwrought, not alloyed - air', 'SOx - non combustion - Refined lead, unwrought - air', 'SOx - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'SOx - non combustion - Sulphuric acid production - air', 'SOx - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'SOx - non combustion - Zinc, unwrought, not alloyed - air', 'Se - non combustion - Agglomeration plant - pellets - air', 'Se - non combustion - Agglomeration plant - sinter - air', 'Se - non combustion - Glass production - air', 'Se - non combustion - Steel production: basic oxygen furnace - air', 'TSP - non combustion - Agglomeration plant - pellets - air', 'TSP - non combustion - Agglomeration plant - sinter - air', 'TSP - non combustion - Aluminium ores and concentrates (Bauxite) - air', 'TSP - non combustion - Bricks production - air', 'TSP - non combustion - Briquettes production - air', 'TSP - non combustion - Carbon black production - air', 'TSP - non combustion - Cast iron production (grey iron foundries) - air', 'TSP - non combustion - Cement production - air', 'TSP - non combustion - Chemical wood pulp, dissolving grades - air', 'TSP - non combustion - Chemical wood pulp, soda and sulphate, other than dissolving grades - air', 'TSP - non combustion - Chemical wood pulp, sulphite, other than dissolving grades - air', 'TSP - non combustion - Chromium ores and concentrates - air', 'TSP - non combustion - Copper ores and concentrates - air', 'TSP - non combustion - Fertilizer production (N-fertilizer) - air', 'TSP - non combustion - Glass production - air', 'TSP - non combustion - Gold ores and concentrates - air', 'TSP - non combustion - Iron ores and concentrates - air', 'TSP - non combustion - Lead ores and concentrates - air', 'TSP - non combustion - Lime production - air', 'TSP - non combustion - Mining of antracite - air', 'TSP - non combustion - Mining of bituminous coal - air', 'TSP - non combustion - Mining of coking coal - air', 'TSP - non combustion - Mining of lignite (brown coal) - air', 'TSP - non combustion - Mining of sub-bituminous coal - air', 'TSP - non combustion - Molybdenum ores and concentrates - air', 'TSP - non combustion - N- fertilizer production - air', 'TSP - non combustion - Nickel ores and concentrates - air', 'TSP - non combustion - Nickel, unwrought - air', 'TSP - non combustion - Oil refinery - air', 'TSP - non combustion - Pig iron production, blast furnace - air', 'TSP - non combustion - Platinum ores and concentrates - air', 'TSP - non combustion - Primary aluminium production - air', 'TSP - non combustion - Production of coke oven coke - air', 'TSP - non combustion - Production of gascoke - air', 'TSP - non combustion - Refined copper; unwrought, not alloyed - air', 'TSP - non combustion - Refined lead, unwrought - air', 'TSP - non combustion - Secondary aluminium production - air', 'TSP - non combustion - Semi-chemical wood pulp, pulp of fibers other than wood - air', 'TSP - non combustion - Silver ores and concentrates - air', 'TSP - non combustion - Steel production: basic oxygen furnace - air', 'TSP - non combustion - Steel production: electric arc furnace - air', 'TSP - non combustion - Steel production: open hearth furnace - air', 'TSP - non combustion - Tin ores and concentrates - air', 'TSP - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'TSP - non combustion - Zinc ores and concentrates - air', 'TSP - non combustion - Zinc, unwrought, not alloyed - air', 'Zn - non combustion - Agglomeration plant - pellets - air', 'Zn - non combustion - Agglomeration plant - sinter - air', 'Zn - non combustion - Glass production - air', 'Zn - non combustion - Nickel, unwrought - air', 'Zn - non combustion - Pig iron production, blast furnace - air', 'Zn - non combustion - Refined copper; unwrought, not alloyed - air', 'Zn - non combustion - Refined lead, unwrought - air', 'Zn - non combustion - Steel production: basic oxygen furnace - air', 'Zn - non combustion - Steel production: electric arc furnace - air', 'Zn - non combustion - Steel production: open hearth furnace - air', 'Zn - non combustion - Unrefined copper; copper anodes for electrolytic refining - air', 'Zn - non combustion - Zinc, unwrought, not alloyed - air', 'SF6 - air', 'HFC - air', 'PFC - air', 'CH4 - agriculture - air', 'CO2 - agriculture - peat decay - air', 'N - agriculture - water', 'N2O - agriculture - air', 'NH3 - agriculture - air', 'NOX - agriculture - air', 'P - agriculture - soil', 'P - agriculture - water', 'Pxx - agriculture - soil', 'CH4 - waste - air', 'CO - waste - air', 'CO2 - waste - biogenic - air', 'CO2 - waste - fossil - air', 'Emissions nec - waste - undef', 'N - waste - water', 'NH3 - waste - air', 'NOX - waste - air', 'P - waste - water', 'PM2.5 - waste - air', 'SOx - waste - air', 'Cropland - Cereal grains nec', 'Cropland - Crops nec', 'Cropland - Fodder crops-Cattle', 'Cropland - Fodder crops-Meat animals nec', 'Cropland - Fodder crops-Pigs', 'Cropland - Fodder crops-Poultry', 'Cropland - Fodder crops-Raw milk', 'Cropland - Oil seeds', 'Cropland - Paddy rice', 'Cropland - Plant-based fibers', 'Cropland - Sugar cane, sugar beet', 'Cropland - Vegetables, fruit, nuts', 'Cropland - Wheat', 'Forest area - Forestry', 'Other land - Grazing-Cattle', 'Other land - Grazing-Meat animals nec', 'Other land - Grazing-Raw milk', 'Other land - Wood fuel', 'Permanent pastures - Grazing-Cattle', 'Permanent pastures - Grazing-Meat animals nec', 'Permanent pastures - Grazing-Raw milk', 'Infrastructure land', 'Forest area - Marginal use', 'Other land - Grazing', 'Other land - Marginal use', 'Nature Inputs: Anthracite', 'Nature Inputs: Coking Coal', 'Nature Inputs: Other Bituminous Coal', 'Nature Inputs: Sub-Bituminous Coal', 'Nature Inputs: Lignite/Brown Coal', 'Nature Inputs: Peat', 'Nature Inputs: Crude petroleum and services related to crude oil extraction, excluding surveying', 'Nature Inputs: Natural gas and services related to natural gas extraction, excluding surveying', 'Nature Inputs: Natural Gas Liquids', 'Nature Inputs: Other Hydrocarbons', 'Nature Inputs: Uranium and thorium ores (12)', 'Nature Inputs: Electricity by hydro', 'Nature Inputs: Electricity by wind', 'Nature Inputs: Electricity by solar photovoltaic', 'Nature Inputs: Electricity by solar thermal', 'Nature Inputs: Electricity by tide, wave, ocean', 'Nature Inputs: Electricity by Geothermal', 'Nature Inputs: Energy inputs to cultiavted biomass', 'Nature Inputs: Other sources', 'Emission Relevant Energy Carrier Anthracite', 'Emission Relevant Energy Carrier Aviation Gasoline', 'Emission Relevant Energy Carrier BKB/Peat Briquettes', 'Emission Relevant Energy Carrier Biodiesels', 'Emission Relevant Energy Carrier Biogas', 'Emission Relevant Energy Carrier Biogasoline', 'Emission Relevant Energy Carrier Bitumen', 'Emission Relevant Energy Carrier Blast Furnace Gas', 'Emission Relevant Energy Carrier Charcoal', 'Emission Relevant Energy Carrier Coal Tar', 'Emission Relevant Energy Carrier Coke Oven Coke', 'Emission Relevant Energy Carrier Coke oven gas', 'Emission Relevant Energy Carrier Coking Coal', 'Emission Relevant Energy Carrier Crops nec', 'Emission Relevant Energy Carrier Crude petroleum and services related to crude oil extraction, excluding surveying', 'Emission Relevant Energy Carrier Ethane', 'Emission Relevant Energy Carrier Food products nec', 'Emission Relevant Energy Carrier Food waste for treatment: incineration', 'Emission Relevant Energy Carrier Gas Coke', 'Emission Relevant Energy Carrier Gas Works Gas', 'Emission Relevant Energy Carrier Gas/Diesel Oil', 'Emission Relevant Energy Carrier Gasoline Type Jet Fuel', 'Emission Relevant Energy Carrier Heavy Fuel Oil', 'Emission Relevant Energy Carrier Intert/metal waste for treatment: incineration', 'Emission Relevant Energy Carrier Kerosene', 'Emission Relevant Energy Carrier Kerosene Type Jet Fuel', 'Emission Relevant Energy Carrier Lignite/Brown Coal', 'Emission Relevant Energy Carrier Liquefied Petroleum Gases (LPG)', 'Emission Relevant Energy Carrier Lubricants', 'Emission Relevant Energy Carrier Manure (biogas treatment)', 'Emission Relevant Energy Carrier Manure (conventional treatment)', 'Emission Relevant Energy Carrier Motor Gasoline', 'Emission Relevant Energy Carrier Naphtha', 'Emission Relevant Energy Carrier Natural Gas Liquids', 'Emission Relevant Energy Carrier Natural gas and services related to natural gas extraction, excluding surveying', 'Emission Relevant Energy Carrier Non-specified Petroleum Products', 'Emission Relevant Energy Carrier Oil/hazardous waste for treatment: incineration', 'Emission Relevant Energy Carrier Other Bituminous Coal', 'Emission Relevant Energy Carrier Other Hydrocarbons', 'Emission Relevant Energy Carrier Other Liquid Biofuels', 'Emission Relevant Energy Carrier Oxygen Steel Furnace Gas', 'Emission Relevant Energy Carrier Paper waste for treatment: incineration', 'Emission Relevant Energy Carrier Patent Fuel', 'Emission Relevant Energy Carrier Peat', 'Emission Relevant Energy Carrier Petroleum Coke', 'Emission Relevant Energy Carrier Plastic waste for treatment: incineration', 'Emission Relevant Energy Carrier Products of forestry, logging and related services (02)', 'Emission Relevant Energy Carrier Pulp', 'Emission Relevant Energy Carrier Refinery Gas', 'Emission Relevant Energy Carrier Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Emission Relevant Energy Carrier Sub-Bituminous Coal', 'Emission Relevant Energy Carrier Sugar', 'Emission Relevant Energy Carrier Textiles waste for treatment: incineration', 'Emission Relevant Energy Carrier White Spirit & SBP', 'Emission Relevant Energy Carrier Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Emission Relevant Energy Carrier Wood waste for treatment: incineration', 'Energy Carrier Supply Additives/Blending Components', 'Energy Carrier Supply Anthracite', 'Energy Carrier Supply Aviation Gasoline', 'Energy Carrier Supply BKB/Peat Briquettes', 'Energy Carrier Supply Biodiesels', 'Energy Carrier Supply Biogas', 'Energy Carrier Supply Biogasoline', 'Energy Carrier Supply Bitumen', 'Energy Carrier Supply Blast Furnace Gas', 'Energy Carrier Supply Charcoal', 'Energy Carrier Supply Coal Tar', 'Energy Carrier Supply Coke Oven Coke', 'Energy Carrier Supply Coke oven gas', 'Energy Carrier Supply Coking Coal', 'Energy Carrier Supply Crops nec', 'Energy Carrier Supply Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Supply Electricity by Geothermal', 'Energy Carrier Supply Electricity by biomass and waste', 'Energy Carrier Supply Electricity by coal', 'Energy Carrier Supply Electricity by gas', 'Energy Carrier Supply Electricity by hydro', 'Energy Carrier Supply Electricity by nuclear', 'Energy Carrier Supply Electricity by petroleum and other oil derivatives', 'Energy Carrier Supply Electricity by solar photovoltaic', 'Energy Carrier Supply Electricity by solar thermal', 'Energy Carrier Supply Electricity by tide, wave, ocean', 'Energy Carrier Supply Electricity by wind', 'Energy Carrier Supply Electricity nec', 'Energy Carrier Supply Ethane', 'Energy Carrier Supply Food products nec', 'Energy Carrier Supply Food waste for treatment: incineration', 'Energy Carrier Supply Gas Coke', 'Energy Carrier Supply Gas Works Gas', 'Energy Carrier Supply Gas/Diesel Oil', 'Energy Carrier Supply Gasoline Type Jet Fuel', 'Energy Carrier Supply Heavy Fuel Oil', 'Energy Carrier Supply Intert/metal waste for treatment: incineration', 'Energy Carrier Supply Kerosene', 'Energy Carrier Supply Kerosene Type Jet Fuel', 'Energy Carrier Supply Lignite/Brown Coal', 'Energy Carrier Supply Liquefied Petroleum Gases (LPG)', 'Energy Carrier Supply Lubricants', 'Energy Carrier Supply Manure (biogas treatment)', 'Energy Carrier Supply Manure (conventional treatment)', 'Energy Carrier Supply Motor Gasoline', 'Energy Carrier Supply Naphtha', 'Energy Carrier Supply Natural Gas Liquids', 'Energy Carrier Supply Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Supply Non-specified Petroleum Products', 'Energy Carrier Supply Nuclear fuel', 'Energy Carrier Supply Oil/hazardous waste for treatment: incineration', 'Energy Carrier Supply Other Bituminous Coal', 'Energy Carrier Supply Other Hydrocarbons', 'Energy Carrier Supply Other Liquid Biofuels', 'Energy Carrier Supply Oxygen Steel Furnace Gas', 'Energy Carrier Supply Paper waste for treatment: incineration', 'Energy Carrier Supply Paraffin Waxes', 'Energy Carrier Supply Patent Fuel', 'Energy Carrier Supply Peat', 'Energy Carrier Supply Petroleum Coke', 'Energy Carrier Supply Plastic waste for treatment: incineration', 'Energy Carrier Supply Products of forestry, logging and related services (02)', 'Energy Carrier Supply Pulp', 'Energy Carrier Supply Refinery Feedstocks', 'Energy Carrier Supply Refinery Gas', 'Energy Carrier Supply Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Supply Steam and hot water supply services', 'Energy Carrier Supply Sub-Bituminous Coal', 'Energy Carrier Supply Sugar', 'Energy Carrier Supply Textiles waste for treatment: incineration', 'Energy Carrier Supply Uranium and thorium ores (12)', 'Energy Carrier Supply White Spirit & SBP', 'Energy Carrier Supply Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Energy Carrier Supply Wood waste for treatment: incineration', 'Energy Carrier Use Additives/Blending Components', 'Energy Carrier Use Anthracite', 'Energy Carrier Use Aviation Gasoline', 'Energy Carrier Use BKB/Peat Briquettes', 'Energy Carrier Use Biodiesels', 'Energy Carrier Use Biogas', 'Energy Carrier Use Biogasoline', 'Energy Carrier Use Bitumen', 'Energy Carrier Use Blast Furnace Gas', 'Energy Carrier Use Charcoal', 'Energy Carrier Use Coal Tar', 'Energy Carrier Use Coke Oven Coke', 'Energy Carrier Use Coke oven gas', 'Energy Carrier Use Coking Coal', 'Energy Carrier Use Crops nec', 'Energy Carrier Use Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Use Electricity by Geothermal', 'Energy Carrier Use Electricity by biomass and waste', 'Energy Carrier Use Electricity by coal', 'Energy Carrier Use Electricity by gas', 'Energy Carrier Use Electricity by hydro', 'Energy Carrier Use Electricity by nuclear', 'Energy Carrier Use Electricity by petroleum and other oil derivatives', 'Energy Carrier Use Electricity by solar photovoltaic', 'Energy Carrier Use Electricity by solar thermal', 'Energy Carrier Use Electricity by tide, wave, ocean', 'Energy Carrier Use Electricity by wind', 'Energy Carrier Use Electricity nec', 'Energy Carrier Use Ethane', 'Energy Carrier Use Food products nec', 'Energy Carrier Use Food waste for treatment: incineration', 'Energy Carrier Use Gas Coke', 'Energy Carrier Use Gas Works Gas', 'Energy Carrier Use Gas/Diesel Oil', 'Energy Carrier Use Gasoline Type Jet Fuel', 'Energy Carrier Use Heavy Fuel Oil', 'Energy Carrier Use Intert/metal waste for treatment: incineration', 'Energy Carrier Use Kerosene', 'Energy Carrier Use Kerosene Type Jet Fuel', 'Energy Carrier Use Lignite/Brown Coal', 'Energy Carrier Use Liquefied Petroleum Gases (LPG)', 'Energy Carrier Use Lubricants', 'Energy Carrier Use Manure (biogas treatment)', 'Energy Carrier Use Manure (conventional treatment)', 'Energy Carrier Use Motor Gasoline', 'Energy Carrier Use Naphtha', 'Energy Carrier Use Natural Gas Liquids', 'Energy Carrier Use Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Use Non-specified Petroleum Products', 'Energy Carrier Use Nuclear fuel', 'Energy Carrier Use Oil/hazardous waste for treatment: incineration', 'Energy Carrier Use Other Bituminous Coal', 'Energy Carrier Use Other Hydrocarbons', 'Energy Carrier Use Other Liquid Biofuels', 'Energy Carrier Use Oxygen Steel Furnace Gas', 'Energy Carrier Use Paper waste for treatment: incineration', 'Energy Carrier Use Paraffin Waxes', 'Energy Carrier Use Patent Fuel', 'Energy Carrier Use Peat', 'Energy Carrier Use Petroleum Coke', 'Energy Carrier Use Plastic waste for treatment: incineration', 'Energy Carrier Use Products of forestry, logging and related services (02)', 'Energy Carrier Use Pulp', 'Energy Carrier Use Refinery Feedstocks', 'Energy Carrier Use Refinery Gas', 'Energy Carrier Use Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Use Steam and hot water supply services', 'Energy Carrier Use Sub-Bituminous Coal', 'Energy Carrier Use Sugar', 'Energy Carrier Use Textiles waste for treatment: incineration', 'Energy Carrier Use Uranium and thorium ores (12)', 'Energy Carrier Use White Spirit & SBP', 'Energy Carrier Use Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Energy Carrier Use Wood waste for treatment: incineration', 'Domestic Extraction Used - Crop residues - Feed', 'Domestic Extraction Used - Crop residues - Straw', 'Domestic Extraction Used - Fishery - Aquatic plants', 'Domestic Extraction Used - Fishery - Inland waters fish catch', 'Domestic Extraction Used - Fishery - Marine fish catch', 'Domestic Extraction Used - Fishery - Other (e.g. Aquatic mammals)', 'Domestic Extraction Used - Fodder crops - Alfalfa for Forage and Silage', 'Domestic Extraction Used - Fodder crops - Beets for Fodder', 'Domestic Extraction Used - Fodder crops - Cabbage for Fodder', 'Domestic Extraction Used - Fodder crops - Carrots for Fodder', 'Domestic Extraction Used - Fodder crops - Clover for Forage and Silage', 'Domestic Extraction Used - Fodder crops - Forage Products nec', 'Domestic Extraction Used - Fodder crops - Grasses nec for Forage and Silage', 'Domestic Extraction Used - Fodder crops - Green Oilseeds for Fodder', 'Domestic Extraction Used - Fodder crops - Leguminous nec for forage and Silage', 'Domestic Extraction Used - Fodder crops - Maize for Forage and Silage', 'Domestic Extraction Used - Fodder crops - Other grasses', 'Domestic Extraction Used - Fodder crops - Rye Grass, Forage and Silage', 'Domestic Extraction Used - Fodder crops - Sorghum for Forage and Silage', 'Domestic Extraction Used - Fodder crops - Swedes for Fodder', 'Domestic Extraction Used - Fodder crops - Turnips for Fodder', 'Domestic Extraction Used - Fodder crops - Vegetables and Roots, Fodder', 'Domestic Extraction Used - Forestry - Coniferous wood - Industrial roundwood', 'Domestic Extraction Used - Forestry - Coniferous wood - Wood fuel', 'Domestic Extraction Used - Forestry - Kapok Fruit', 'Domestic Extraction Used - Forestry - Natural Gums', 'Domestic Extraction Used - Forestry - Non-coniferous wood - Industrial roundwood', 'Domestic Extraction Used - Forestry - Non-coniferous wood - Wood fuel', 'Domestic Extraction Used - Forestry - Raw materials other than wood', 'Domestic Extraction Used - Fossil Fuels - Anthracite', 'Domestic Extraction Used - Fossil Fuels - Coking coal', 'Domestic Extraction Used - Fossil Fuels - Crude oil', 'Domestic Extraction Used - Fossil Fuels - Lignite/brown coal', 'Domestic Extraction Used - Fossil Fuels - Natural gas', 'Domestic Extraction Used - Fossil Fuels - Natural gas liquids', 'Domestic Extraction Used - Fossil Fuels - Oil shale and oil sands', 'Domestic Extraction Used - Fossil Fuels - Other bituminous coal', 'Domestic Extraction Used - Fossil Fuels - Other hydrocarbons', 'Domestic Extraction Used - Fossil Fuels - Peat', 'Domestic Extraction Used - Fossil Fuels - Sub-bituminous coal', 'Domestic Extraction Used - Grazing', 'Domestic Extraction Used - Metal Ores - Bauxite and aluminium ores', 'Domestic Extraction Used - Metal Ores - Copper ores', 'Domestic Extraction Used - Metal Ores - Gold ores', 'Domestic Extraction Used - Metal Ores - Iron ores', 'Domestic Extraction Used - Metal Ores - Lead ores', 'Domestic Extraction Used - Metal Ores - Nickel ores', 'Domestic Extraction Used - Metal Ores - Other non-ferrous metal ores', 'Domestic Extraction Used - Metal Ores - PGM ores', 'Domestic Extraction Used - Metal Ores - Silver ores', 'Domestic Extraction Used - Metal Ores - Tin ores', 'Domestic Extraction Used - Metal Ores - Uranium and thorium ores', 'Domestic Extraction Used - Metal Ores - Zinc ores', 'Domestic Extraction Used - Non-Metallic Minerals - Building stones', 'Domestic Extraction Used - Non-Metallic Minerals - Chemical and fertilizer minerals', 'Domestic Extraction Used - Non-Metallic Minerals - Clays and kaolin', 'Domestic Extraction Used - Non-Metallic Minerals - Gravel and sand', 'Domestic Extraction Used - Non-Metallic Minerals - Limestone, gypsum, chalk, dolomite', 'Domestic Extraction Used - Non-Metallic Minerals - Other minerals', 'Domestic Extraction Used - Non-Metallic Minerals - Salt', 'Domestic Extraction Used - Non-Metallic Minerals - Slate', 'Domestic Extraction Used - Primary Crops - Kapokseed in Shell', 'Domestic Extraction Used - Primary Crops - Honey', 'Domestic Extraction Used - Primary Crops - Beeswax', 'Domestic Extraction Used - Primary Crops - Abaca', 'Domestic Extraction Used - Primary Crops - Agave Fibres nes', 'Domestic Extraction Used - Primary Crops - Almonds', 'Domestic Extraction Used - Primary Crops - Anise, Badian, Fennel', 'Domestic Extraction Used - Primary Crops - Apples', 'Domestic Extraction Used - Primary Crops - Apricots', 'Domestic Extraction Used - Primary Crops - Arecanuts', 'Domestic Extraction Used - Primary Crops - Artichokes', 'Domestic Extraction Used - Primary Crops - Asparagus', 'Domestic Extraction Used - Primary Crops - Avocados', 'Domestic Extraction Used - Primary Crops - Bambara beans', 'Domestic Extraction Used - Primary Crops - Bananas', 'Domestic Extraction Used - Primary Crops - Barley', 'Domestic Extraction Used - Primary Crops - Beans, dry', 'Domestic Extraction Used - Primary Crops - Beans, green', 'Domestic Extraction Used - Primary Crops - Berries nec', 'Domestic Extraction Used - Primary Crops - Blueberries', 'Domestic Extraction Used - Primary Crops - Brazil nuts, with shell', 'Domestic Extraction Used - Primary Crops - Broad beans, horse beans, dry', 'Domestic Extraction Used - Primary Crops - Buckwheat', 'Domestic Extraction Used - Primary Crops - Cabbages', 'Domestic Extraction Used - Primary Crops - Canary Seed', 'Domestic Extraction Used - Primary Crops - Carobs', 'Domestic Extraction Used - Primary Crops - Carrots', 'Domestic Extraction Used - Primary Crops - Cashew nuts, with shell', 'Domestic Extraction Used - Primary Crops - Cashewapple', 'Domestic Extraction Used - Primary Crops - Cassava', 'Domestic Extraction Used - Primary Crops - Cassava leaves', 'Domestic Extraction Used - Primary Crops - Castor oil seed', 'Domestic Extraction Used - Primary Crops - Cauliflower', 'Domestic Extraction Used - Primary Crops - Cereals nec', 'Domestic Extraction Used - Primary Crops - Cherries', 'Domestic Extraction Used - Primary Crops - Chestnuts', 'Domestic Extraction Used - Primary Crops - Chick peas', 'Domestic Extraction Used - Primary Crops - Chicory Roots', 'Domestic Extraction Used - Primary Crops - Chillies and peppers, dry', 'Domestic Extraction Used - Primary Crops - Chillies and peppers, green', 'Domestic Extraction Used - Primary Crops - Cinnamon', 'Domestic Extraction Used - Primary Crops - Citrus Fruit nec', 'Domestic Extraction Used - Primary Crops - Cloves', 'Domestic Extraction Used - Primary Crops - Cocoa Beans', 'Domestic Extraction Used - Primary Crops - Coconuts', 'Domestic Extraction Used - Primary Crops - Coffee, Green', 'Domestic Extraction Used - Primary Crops - Coir', 'Domestic Extraction Used - Primary Crops - Cotton Lint', 'Domestic Extraction Used - Primary Crops - Cottonseed', 'Domestic Extraction Used - Primary Crops - Cow peas, dry', 'Domestic Extraction Used - Primary Crops - Cranberries', 'Domestic Extraction Used - Primary Crops - Cucumbers and Gherkins', 'Domestic Extraction Used - Primary Crops - Currants', 'Domestic Extraction Used - Primary Crops - Dates', 'Domestic Extraction Used - Primary Crops - Eggplants', 'Domestic Extraction Used - Primary Crops - Fibre Crops nes', 'Domestic Extraction Used - Primary Crops - Figs', 'Domestic Extraction Used - Primary Crops - Flax Fibre and Tow', 'Domestic Extraction Used - Primary Crops - Fonio', 'Domestic Extraction Used - Primary Crops - Fruit Fresh Nes', 'Domestic Extraction Used - Primary Crops - Fruit, tropical fresh nes', 'Domestic Extraction Used - Primary Crops - Garlic', 'Domestic Extraction Used - Primary Crops - Ginger', 'Domestic Extraction Used - Primary Crops - Gooseberries', 'Domestic Extraction Used - Primary Crops - Grapefruit and Pomelos', 'Domestic Extraction Used - Primary Crops - Grapes', 'Domestic Extraction Used - Primary Crops - Groundnuts in Shell', 'Domestic Extraction Used - Primary Crops - Hazelnuts', 'Domestic Extraction Used - Primary Crops - Hemp Fibre and Tow', 'Domestic Extraction Used - Primary Crops - Hempseed', 'Domestic Extraction Used - Primary Crops - Hops', 'Domestic Extraction Used - Primary Crops - Jojoba Seeds', 'Domestic Extraction Used - Primary Crops - Jute and Jute-like Fibres', 'Domestic Extraction Used - Primary Crops - Kapok Fibre', 'Domestic Extraction Used - Primary Crops - Karite Nuts', 'Domestic Extraction Used - Primary Crops - Kiwi Fruit', 'Domestic Extraction Used - Primary Crops - Kolanuts', 'Domestic Extraction Used - Primary Crops - Leeks and other Alliac. Veg.', 'Domestic Extraction Used - Primary Crops - Leguminous vegetables, nes', 'Domestic Extraction Used - Primary Crops - Lemons and Limes', 'Domestic Extraction Used - Primary Crops - Lentils', 'Domestic Extraction Used - Primary Crops - Lettuce', 'Domestic Extraction Used - Primary Crops - Linseed', 'Domestic Extraction Used - Primary Crops - Lupins', 'Domestic Extraction Used - Primary Crops - Maize', 'Domestic Extraction Used - Primary Crops - Maize, green', 'Domestic Extraction Used - Primary Crops - Mangoes, mangosteens, guavas', 'Domestic Extraction Used - Primary Crops - Mate', 'Domestic Extraction Used - Primary Crops - Melonseed', 'Domestic Extraction Used - Primary Crops - Millet', 'Domestic Extraction Used - Primary Crops - Mixed Grain', 'Domestic Extraction Used - Primary Crops - Mushrooms', 'Domestic Extraction Used - Primary Crops - Mustard Seed', 'Domestic Extraction Used - Primary Crops - Natural Rubber', 'Domestic Extraction Used - Primary Crops - Nutmeg, mace and cardamoms', 'Domestic Extraction Used - Primary Crops - Nuts, nes', 'Domestic Extraction Used - Primary Crops - Oats', 'Domestic Extraction Used - Primary Crops - Oil Palm Fruit', 'Domestic Extraction Used - Primary Crops - Oilseeds nec', 'Domestic Extraction Used - Primary Crops - Okra', 'Domestic Extraction Used - Primary Crops - Olives', 'Domestic Extraction Used - Primary Crops - Onions', 'Domestic Extraction Used - Primary Crops - Onions, dry', 'Domestic Extraction Used - Primary Crops - Oranges', 'Domestic Extraction Used - Primary Crops - Other Bastfibres', 'Domestic Extraction Used - Primary Crops - Other melons', 'Domestic Extraction Used - Primary Crops - Papayas', 'Domestic Extraction Used - Primary Crops - Peaches and Nectarines', 'Domestic Extraction Used - Primary Crops - Pears', 'Domestic Extraction Used - Primary Crops - Peas, Green', 'Domestic Extraction Used - Primary Crops - Peas, dry', 'Domestic Extraction Used - Primary Crops - Pepper', 'Domestic Extraction Used - Primary Crops - Peppermint', 'Domestic Extraction Used - Primary Crops - Persimmons', 'Domestic Extraction Used - Primary Crops - Pigeon peas', 'Domestic Extraction Used - Primary Crops - Pineapples', 'Domestic Extraction Used - Primary Crops - Pistachios', 'Domestic Extraction Used - Primary Crops - Plantains', 'Domestic Extraction Used - Primary Crops - Plums', 'Domestic Extraction Used - Primary Crops - Pome fruit, nes', 'Domestic Extraction Used - Primary Crops - Poppy Seed', 'Domestic Extraction Used - Primary Crops - Potatoes', 'Domestic Extraction Used - Primary Crops - Pulses nec', 'Domestic Extraction Used - Primary Crops - Pumpkins, Squash, Gourds', 'Domestic Extraction Used - Primary Crops - Pyrethrum, Dried Flowers', 'Domestic Extraction Used - Primary Crops - Quinces', 'Domestic Extraction Used - Primary Crops - Quinoa', 'Domestic Extraction Used - Primary Crops - Ramie', 'Domestic Extraction Used - Primary Crops - Rapeseed', 'Domestic Extraction Used - Primary Crops - Raspberries', 'Domestic Extraction Used - Primary Crops - Rice', 'Domestic Extraction Used - Primary Crops - Roots and Tubers, nes', 'Domestic Extraction Used - Primary Crops - Rye', 'Domestic Extraction Used - Primary Crops - Safflower Seed', 'Domestic Extraction Used - Primary Crops - Sesame Seed', 'Domestic Extraction Used - Primary Crops - Sisal', 'Domestic Extraction Used - Primary Crops - Sorghum', 'Domestic Extraction Used - Primary Crops - Sour Cherries', 'Domestic Extraction Used - Primary Crops - Soybeans', 'Domestic Extraction Used - Primary Crops - Spices nec', 'Domestic Extraction Used - Primary Crops - Spinach', 'Domestic Extraction Used - Primary Crops - Stone Fruit nec,', 'Domestic Extraction Used - Primary Crops - Strawberries', 'Domestic Extraction Used - Primary Crops - String beans', 'Domestic Extraction Used - Primary Crops - Sugar Beets', 'Domestic Extraction Used - Primary Crops - Sugar Cane', 'Domestic Extraction Used - Primary Crops - Sugar Crops nes', 'Domestic Extraction Used - Primary Crops - Sunflower Seed', 'Domestic Extraction Used - Primary Crops - Sweet Potatoes', 'Domestic Extraction Used - Primary Crops - Tallowtree Seeds', 'Domestic Extraction Used - Primary Crops - Tang. Mand Clement. Satsma', 'Domestic Extraction Used - Primary Crops - Taro', 'Domestic Extraction Used - Primary Crops - Tea', 'Domestic Extraction Used - Primary Crops - Tea nes', 'Domestic Extraction Used - Primary Crops - Tobacco Leaves', 'Domestic Extraction Used - Primary Crops - Tomatoes', 'Domestic Extraction Used - Primary Crops - Triticale', 'Domestic Extraction Used - Primary Crops - Tung Nuts', 'Domestic Extraction Used - Primary Crops - Vanilla', 'Domestic Extraction Used - Primary Crops - Vegetables Fresh nec', 'Domestic Extraction Used - Primary Crops - Vetches', 'Domestic Extraction Used - Primary Crops - Walnuts', 'Domestic Extraction Used - Primary Crops - Watermelons', 'Domestic Extraction Used - Primary Crops - Wheat', 'Domestic Extraction Used - Primary Crops - Yams', 'Domestic Extraction Used - Primary Crops - Yautia', 'Unused Domestic Extraction - Primary Crops - Rice', 'Unused Domestic Extraction - Primary Crops - Wheat', 'Unused Domestic Extraction - Primary Crops - Barley', 'Unused Domestic Extraction - Primary Crops - Buckwheat', 'Unused Domestic Extraction - Primary Crops - Canary Seed', 'Unused Domestic Extraction - Primary Crops - Maize', 'Unused Domestic Extraction - Primary Crops - Millet', 'Unused Domestic Extraction - Primary Crops - Mixed Grain', 'Unused Domestic Extraction - Primary Crops - Oats', 'Unused Domestic Extraction - Primary Crops - Rye', 'Unused Domestic Extraction - Primary Crops - Sorghum', 'Unused Domestic Extraction - Primary Crops - Triticale', 'Unused Domestic Extraction - Primary Crops - Cereals nec', 'Unused Domestic Extraction - Primary Crops - Fonio', 'Unused Domestic Extraction - Primary Crops - Quinoa', 'Unused Domestic Extraction - Primary Crops - Potatoes', 'Unused Domestic Extraction - Primary Crops - Sweet Potatoes', 'Unused Domestic Extraction - Primary Crops - Yams', 'Unused Domestic Extraction - Primary Crops - Lentils', 'Unused Domestic Extraction - Primary Crops - Lupins', 'Unused Domestic Extraction - Primary Crops - Vetches', 'Unused Domestic Extraction - Primary Crops - Pulses nec', 'Unused Domestic Extraction - Primary Crops - Olives', 'Unused Domestic Extraction - Primary Crops - Artichokes', 'Unused Domestic Extraction - Primary Crops - Asparagus', 'Unused Domestic Extraction - Primary Crops - Cabbages', 'Unused Domestic Extraction - Primary Crops - Carrots', 'Unused Domestic Extraction - Primary Crops - Cauliflower', 'Unused Domestic Extraction - Primary Crops - Chillies and peppers, green', 'Unused Domestic Extraction - Primary Crops - Cucumbers and Gherkins', 'Unused Domestic Extraction - Primary Crops - Eggplants', 'Unused Domestic Extraction - Primary Crops - Garlic', 'Unused Domestic Extraction - Primary Crops - Leeks and other Alliac. Veg.', 'Unused Domestic Extraction - Primary Crops - Lettuce', 'Unused Domestic Extraction - Primary Crops - Mushrooms', 'Unused Domestic Extraction - Primary Crops - Peas, Green', 'Unused Domestic Extraction - Primary Crops - Pumpkins, Squash, Gourds', 'Unused Domestic Extraction - Primary Crops - Spinach', 'Unused Domestic Extraction - Primary Crops - Tomatoes', 'Unused Domestic Extraction - Primary Crops - Vegetables Fresh nec', 'Unused Domestic Extraction - Primary Crops - Apples', 'Unused Domestic Extraction - Primary Crops - Apricots', 'Unused Domestic Extraction - Primary Crops - Avocados', 'Unused Domestic Extraction - Primary Crops - Blueberries', 'Unused Domestic Extraction - Primary Crops - Carobs', 'Unused Domestic Extraction - Primary Crops - Cherries', 'Unused Domestic Extraction - Primary Crops - Currants', 'Unused Domestic Extraction - Primary Crops - Dates', 'Unused Domestic Extraction - Primary Crops - Figs', 'Unused Domestic Extraction - Primary Crops - Gooseberries', 'Unused Domestic Extraction - Primary Crops - Grapefruit and Pomelos', 'Unused Domestic Extraction - Primary Crops - Grapes', 'Unused Domestic Extraction - Primary Crops - Kiwi Fruit', 'Unused Domestic Extraction - Primary Crops - Lemons and Limes', 'Unused Domestic Extraction - Primary Crops - Oranges', 'Unused Domestic Extraction - Primary Crops - Peaches and Nectarines', 'Unused Domestic Extraction - Primary Crops - Pears', 'Unused Domestic Extraction - Primary Crops - Persimmons', 'Unused Domestic Extraction - Primary Crops - Pineapples', 'Unused Domestic Extraction - Primary Crops - Plums', 'Unused Domestic Extraction - Primary Crops - Quinces', 'Unused Domestic Extraction - Primary Crops - Raspberries', 'Unused Domestic Extraction - Primary Crops - Sour Cherries', 'Unused Domestic Extraction - Primary Crops - Strawberries', 'Unused Domestic Extraction - Primary Crops - Tang. Mand Clement. Satsma', 'Unused Domestic Extraction - Primary Crops - Berries nec', 'Unused Domestic Extraction - Primary Crops - Citrus Fruit nec', 'Unused Domestic Extraction - Primary Crops - Stone Fruit nec,', 'Unused Domestic Extraction - Primary Crops - Almonds', 'Unused Domestic Extraction - Primary Crops - Chestnuts', 'Unused Domestic Extraction - Primary Crops - Hazelnuts', 'Unused Domestic Extraction - Primary Crops - Pistachios', 'Unused Domestic Extraction - Primary Crops - Walnuts', 'Unused Domestic Extraction - Primary Crops - Cassava', 'Unused Domestic Extraction - Primary Crops - Roots and Tubers, nes', 'Unused Domestic Extraction - Primary Crops - Taro', 'Unused Domestic Extraction - Primary Crops - Yautia', 'Unused Domestic Extraction - Primary Crops - Bambara beans', 'Unused Domestic Extraction - Primary Crops - Beans, dry', 'Unused Domestic Extraction - Primary Crops - Beans, green', 'Unused Domestic Extraction - Primary Crops - Broad beans, horse beans, dry', 'Unused Domestic Extraction - Primary Crops - Chick peas', 'Unused Domestic Extraction - Primary Crops - Cow peas, dry', 'Unused Domestic Extraction - Primary Crops - Peas, dry', 'Unused Domestic Extraction - Primary Crops - Pigeon peas', 'Unused Domestic Extraction - Primary Crops - String beans', 'Unused Domestic Extraction - Primary Crops - Coconuts', 'Unused Domestic Extraction - Primary Crops - Okra', 'Unused Domestic Extraction - Primary Crops - Onions', 'Unused Domestic Extraction - Primary Crops - Onions, dry', 'Unused Domestic Extraction - Primary Crops - Other melons', 'Unused Domestic Extraction - Primary Crops - Watermelons', 'Unused Domestic Extraction - Primary Crops - Bananas', 'Unused Domestic Extraction - Primary Crops - Cashewapple', 'Unused Domestic Extraction - Primary Crops - Cranberries', 'Unused Domestic Extraction - Primary Crops - Fruit Fresh Nes', 'Unused Domestic Extraction - Primary Crops - Fruit, tropical fresh nes', 'Unused Domestic Extraction - Primary Crops - Mangoes, mangosteens, guavas', 'Unused Domestic Extraction - Primary Crops - Papayas', 'Unused Domestic Extraction - Primary Crops - Plantains', 'Unused Domestic Extraction - Primary Crops - Arecanuts', 'Unused Domestic Extraction - Primary Crops - Brazil nuts, with shell', 'Unused Domestic Extraction - Primary Crops - Cashew nuts, with shell', 'Unused Domestic Extraction - Primary Crops - Kolanuts', 'Unused Domestic Extraction - Primary Crops - Nuts, nes', 'Unused Domestic Extraction - Primary Crops - Leguminous vegetables, nes', 'Unused Domestic Extraction - Primary Crops - Maize, green', 'Unused Domestic Extraction - Primary Crops - Pome fruit, nes', 'Unused Domestic Extraction - Primary Crops - Cassava leaves', 'Unused Domestic Extraction - Primary Crops - Groundnuts in Shell', 'Unused Domestic Extraction - Primary Crops - Hempseed', 'Unused Domestic Extraction - Primary Crops - Linseed', 'Unused Domestic Extraction - Primary Crops - Melonseed', 'Unused Domestic Extraction - Primary Crops - Mustard Seed', 'Unused Domestic Extraction - Primary Crops - Poppy Seed', 'Unused Domestic Extraction - Primary Crops - Rapeseed', 'Unused Domestic Extraction - Primary Crops - Safflower Seed', 'Unused Domestic Extraction - Primary Crops - Sesame Seed', 'Unused Domestic Extraction - Primary Crops - Soybeans', 'Unused Domestic Extraction - Primary Crops - Sunflower Seed', 'Unused Domestic Extraction - Primary Crops - Oilseeds nec', 'Unused Domestic Extraction - Primary Crops - Oil Palm Fruit', 'Unused Domestic Extraction - Primary Crops - Castor oil seed', 'Unused Domestic Extraction - Primary Crops - Karite Nuts', 'Unused Domestic Extraction - Primary Crops - Tung Nuts', 'Unused Domestic Extraction - Primary Crops - Jojoba Seeds', 'Unused Domestic Extraction - Primary Crops - Tallowtree Seeds', 'Unused Domestic Extraction - Primary Crops - Cottonseed', 'Unused Domestic Extraction - Primary Crops - Sugar Beets', 'Unused Domestic Extraction - Primary Crops - Sugar Cane', 'Unused Domestic Extraction - Primary Crops - Sugar Crops nes', 'Unused Domestic Extraction - Primary Crops - Cotton Lint', 'Unused Domestic Extraction - Primary Crops - Flax Fibre and Tow', 'Unused Domestic Extraction - Primary Crops - Hemp Fibre and Tow', 'Unused Domestic Extraction - Primary Crops - Abaca', 'Unused Domestic Extraction - Primary Crops - Agave Fibres nes', 'Unused Domestic Extraction - Primary Crops - Coir', 'Unused Domestic Extraction - Primary Crops - Fibre Crops nes', 'Unused Domestic Extraction - Primary Crops - Ramie', 'Unused Domestic Extraction - Primary Crops - Sisal', 'Unused Domestic Extraction - Primary Crops - Kapok Fibre', 'Unused Domestic Extraction - Primary Crops - Jute and Jute-like Fibres', 'Unused Domestic Extraction - Primary Crops - Other Bastfibres', 'Unused Domestic Extraction - Primary Crops - Anise, Badian, Fennel', 'Unused Domestic Extraction - Primary Crops - Chicory Roots', 'Unused Domestic Extraction - Primary Crops - Coffee, Green', 'Unused Domestic Extraction - Primary Crops - Hops', 'Unused Domestic Extraction - Primary Crops - Peppermint', 'Unused Domestic Extraction - Primary Crops - Pyrethrum, Dried Flowers', 'Unused Domestic Extraction - Primary Crops - Tea', 'Unused Domestic Extraction - Primary Crops - Spices nec', 'Unused Domestic Extraction - Primary Crops - Cocoa Beans', 'Unused Domestic Extraction - Primary Crops - Mate', 'Unused Domestic Extraction - Primary Crops - Tobacco Leaves', 'Unused Domestic Extraction - Primary Crops - Natural Rubber', 'Unused Domestic Extraction - Primary Crops - Cinnamon', 'Unused Domestic Extraction - Primary Crops - Cloves', 'Unused Domestic Extraction - Primary Crops - Ginger', 'Unused Domestic Extraction - Primary Crops - Nutmeg, mace and cardamoms', 'Unused Domestic Extraction - Primary Crops - Vanilla', 'Unused Domestic Extraction - Primary Crops - Pepper', 'Unused Domestic Extraction - Primary Crops - Chillies and peppers, dry', 'Unused Domestic Extraction - Primary Crops - Tea nes', 'Unused Domestic Extraction - Crop residues - Feed', 'Unused Domestic Extraction - Crop residues - Straw', 'Unused Domestic Extraction - Fishery - Aquatic plants', 'Unused Domestic Extraction - Fishery - Inland waters fish catch', 'Unused Domestic Extraction - Fishery - Marine fish catch', 'Unused Domestic Extraction - Fishery - Other (e.g. Aquatic mammals)', 'Unused Domestic Extraction - Fodder crops - Alfalfa for Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Beets for Fodder', 'Unused Domestic Extraction - Fodder crops - Cabbage for Fodder', 'Unused Domestic Extraction - Fodder crops - Carrots for Fodder', 'Unused Domestic Extraction - Fodder crops - Clover for Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Forage Products nec', 'Unused Domestic Extraction - Fodder crops - Grasses nec for Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Green Oilseeds for Fodder', 'Unused Domestic Extraction - Fodder crops - Leguminous nec for forage and Silage', 'Unused Domestic Extraction - Fodder crops - Maize for Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Other grasses', 'Unused Domestic Extraction - Fodder crops - Rye Grass, Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Sorghum for Forage and Silage', 'Unused Domestic Extraction - Fodder crops - Swedes for Fodder', 'Unused Domestic Extraction - Fodder crops - Turnips for Fodder', 'Unused Domestic Extraction - Fodder crops - Vegetables and Roots, Fodder', 'Unused Domestic Extraction - Forestry - Coniferous wood - Industrial roundwood', 'Unused Domestic Extraction - Forestry - Coniferous wood - Wood fuel', 'Unused Domestic Extraction - Forestry - Kapok Fruit', 'Unused Domestic Extraction - Forestry - Natural Gums', 'Unused Domestic Extraction - Forestry - Non-coniferous wood - Industrial roundwood', 'Unused Domestic Extraction - Forestry - Non-coniferous wood - Wood fuel', 'Unused Domestic Extraction - Forestry - Raw materials other than wood', 'Unused Domestic Extraction - Fossil Fuels - Anthracite', 'Unused Domestic Extraction - Fossil Fuels - Coking coal', 'Unused Domestic Extraction - Fossil Fuels - Crude oil', 'Unused Domestic Extraction - Fossil Fuels - Lignite/brown coal', 'Unused Domestic Extraction - Fossil Fuels - Natural gas', 'Unused Domestic Extraction - Fossil Fuels - Natural gas liquids', 'Unused Domestic Extraction - Fossil Fuels - Other bituminous coal', 'Unused Domestic Extraction - Fossil Fuels - Peat', 'Unused Domestic Extraction - Fossil Fuels - Sub-bituminous coal', 'Unused Domestic Extraction - Grazing', 'Unused Domestic Extraction - Metal Ores - Bauxite and aluminium ores', 'Unused Domestic Extraction - Metal Ores - Copper ores', 'Unused Domestic Extraction - Metal Ores - Gold ores', 'Unused Domestic Extraction - Metal Ores - Iron ores', 'Unused Domestic Extraction - Metal Ores - Lead ores', 'Unused Domestic Extraction - Metal Ores - Nickel ores', 'Unused Domestic Extraction - Metal Ores - Other non-ferrous metal ores', 'Unused Domestic Extraction - Metal Ores - PGM ores', 'Unused Domestic Extraction - Metal Ores - Silver ores', 'Unused Domestic Extraction - Metal Ores - Tin ores', 'Unused Domestic Extraction - Metal Ores - Uranium and thorium ores', 'Unused Domestic Extraction - Metal Ores - Zinc ores', 'Unused Domestic Extraction - Non-Metallic Minerals - Building stones', 'Unused Domestic Extraction - Non-Metallic Minerals - Chemical and fertilizer minerals', 'Unused Domestic Extraction - Non-Metallic Minerals - Clays and kaolin', 'Unused Domestic Extraction - Non-Metallic Minerals - Gravel and sand', 'Unused Domestic Extraction - Non-Metallic Minerals - Limestone, gypsum, chalk, dolomite', 'Unused Domestic Extraction - Non-Metallic Minerals - Other minerals', 'Unused Domestic Extraction - Non-Metallic Minerals - Salt', 'Unused Domestic Extraction - Non-Metallic Minerals - Slate', 'Unused Domestic Extraction - Primary Crops - Kapokseed in Shell', 'Water Consumption Green - Agriculture - rice', 'Water Consumption Green - Agriculture - wheat', 'Water Consumption Green - Agriculture - other cereals', 'Water Consumption Green - Agriculture - roots and tubers', 'Water Consumption Green - Agriculture - sugar crops', 'Water Consumption Green - Agriculture - pulses', 'Water Consumption Green - Agriculture - nuts', 'Water Consumption Green - Agriculture - oil crops', 'Water Consumption Green - Agriculture - vegetables', 'Water Consumption Green - Agriculture - fruits', 'Water Consumption Green - Agriculture - fibres', 'Water Consumption Green - Agriculture - other crops', 'Water Consumption Green - Agriculture - fodder crops', 'Water Consumption Blue - Agriculture - rice', 'Water Consumption Blue - Agriculture - wheat', 'Water Consumption Blue - Agriculture - other cereals', 'Water Consumption Blue - Agriculture - roots and tubers', 'Water Consumption Blue - Agriculture - sugar crops', 'Water Consumption Blue - Agriculture - pulses', 'Water Consumption Blue - Agriculture - nuts', 'Water Consumption Blue - Agriculture - oil crops', 'Water Consumption Blue - Agriculture - vegetables', 'Water Consumption Blue - Agriculture - fruits', 'Water Consumption Blue - Agriculture - fibres', 'Water Consumption Blue - Agriculture - other crops', 'Water Consumption Blue - Agriculture - fodder crops', 'Water Consumption Blue - Livestock - dairy cattle', 'Water Consumption Blue - Livestock - nondairy cattle', 'Water Consumption Blue - Livestock - pigs', 'Water Consumption Blue - Livestock - sheep', 'Water Consumption Blue - Livestock - goats', 'Water Consumption Blue - Livestock - buffaloes', 'Water Consumption Blue - Livestock - camels', 'Water Consumption Blue - Livestock - horses', 'Water Consumption Blue - Livestock - chicken', 'Water Consumption Blue - Livestock - turkeys', 'Water Consumption Blue - Livestock - ducks', 'Water Consumption Blue - Livestock - geese', 'Water Consumption Blue - Manufacturing - Products of meat cattle', 'Water Consumption Blue - Manufacturing - Products of meat pigs', 'Water Consumption Blue - Manufacturing - Products of meat poultry', 'Water Consumption Blue - Manufacturing - Meat products nec', 'Water Consumption Blue - Manufacturing - products of Vegetable oils and fats', 'Water Consumption Blue - Manufacturing - Dairy products', 'Water Consumption Blue - Manufacturing - Processed rice', 'Water Consumption Blue - Manufacturing - Sugar', 'Water Consumption Blue - Manufacturing - Food products nec', 'Water Consumption Blue - Manufacturing - Beverages', 'Water Consumption Blue - Manufacturing - Fish products', 'Water Consumption Blue - Manufacturing - Tobacco products (16)', 'Water Consumption Blue - Manufacturing - Textiles (17)', 'Water Consumption Blue - Manufacturing - Wearing apparel; furs (18)', 'Water Consumption Blue - Manufacturing - Leather and leather products (19)', 'Water Consumption Blue - Manufacturing - Pulp', 'Water Consumption Blue - Manufacturing - Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Water Consumption Blue - Manufacturing - Paper and paper products', 'Water Consumption Blue - Manufacturing - Printed matter and recorded media (22)', 'Water Consumption Blue - Manufacturing - Plastics, basic', 'Water Consumption Blue - Manufacturing - Secondary plastic for treatment, Re-processing of secondary plastic into new plastic', 'Water Consumption Blue - Manufacturing - N-fertiliser', 'Water Consumption Blue - Manufacturing - P- and other fertiliser', 'Water Consumption Blue - Manufacturing - Chemicals nec', 'Water Consumption Blue - Manufacturing - Rubber and plastic products (25)', 'Water Consumption Blue - Manufacturing - Glass and glass products', 'Water Consumption Blue - Manufacturing - Secondary glass for treatment, Re-processing of secondary glass into new glass', 'Water Consumption Blue - Manufacturing - Ceramic goods', 'Water Consumption Blue - Manufacturing - Bricks, tiles and construction products, in baked clay', 'Water Consumption Blue - Manufacturing - Cement, lime and plaster', 'Water Consumption Blue - Manufacturing - Ash for treatment, Re-processing of ash into clinker', 'Water Consumption Blue - Manufacturing - Other non-metallic mineral products', 'Water Consumption Blue - Manufacturing - Basic iron and steel and of ferro-alloys and first products thereof', 'Water Consumption Blue - Manufacturing - Secondary steel for treatment, Re-processing of secondary steel into new steel', 'Water Consumption Blue - Manufacturing - Precious metals', 'Water Consumption Blue - Manufacturing - Secondary preciuos metals for treatment, Re-processing of secondary preciuos metals into new preciuos metals', 'Water Consumption Blue - Manufacturing - Aluminium and aluminium products', 'Water Consumption Blue - Manufacturing - Secondary aluminium for treatment, Re-processing of secondary aluminium into new aluminium', 'Water Consumption Blue - Manufacturing - Lead, zinc and tin and products thereof', 'Water Consumption Blue - Manufacturing - Secondary lead for treatment, Re-processing of secondary lead into new lead', 'Water Consumption Blue - Manufacturing - Copper products', 'Water Consumption Blue - Manufacturing - Secondary copper for treatment, Re-processing of secondary copper into new copper', 'Water Consumption Blue - Manufacturing - Other non-ferrous metal products', 'Water Consumption Blue - Manufacturing - Secondary other non-ferrous metals for treatment, Re-processing of secondary other non-ferrous metals into new other non-ferrous metals', 'Water Consumption Blue - Manufacturing - Fabricated metal products, except machinery and equipment (28)', 'Water Consumption Blue - Manufacturing - Machinery and equipment n.e.c. (29)', 'Water Consumption Blue - Manufacturing - Office machinery and computers (30)', 'Water Consumption Blue - Manufacturing - Electrical machinery and apparatus n.e.c. (31)', 'Water Consumption Blue - Manufacturing - Radio, television and communication equipment and apparatus (32)', 'Water Consumption Blue - Manufacturing - Medical, precision and optical instruments, watches and clocks (33)', 'Water Consumption Blue - Manufacturing - Motor vehicles, trailers and semi-trailers (34)', 'Water Consumption Blue - Manufacturing - Other transport equipment (35)', 'Water Consumption Blue - Manufacturing - Furniture; other manufactured goods n.e.c. (36)', 'Water Consumption Blue - Electricity - tower - Electricity by coal', 'Water Consumption Blue - Electricity - tower - Electricity by gas', 'Water Consumption Blue - Electricity - tower - Electricity by nuclear', 'Water Consumption Blue - Electricity - tower - Electricity by hydro', 'Water Consumption Blue - Electricity - tower - Electricity by wind', 'Water Consumption Blue - Electricity - tower - Electricity by petroleum and other oil derivatives', 'Water Consumption Blue - Electricity - tower - Electricity by biomass and waste', 'Water Consumption Blue - Electricity - tower - Electricity by solar photovoltaic', 'Water Consumption Blue - Electricity - tower - Electricity by solar thermal', 'Water Consumption Blue - Electricity - tower - Electricity by tide, wave, ocean', 'Water Consumption Blue - Electricity - tower - Electricity by Geothermal', 'Water Consumption Blue - Electricity - tower - Electricity nec', 'Water Consumption Blue - Electricity - once-through - Electricity by coal', 'Water Consumption Blue - Electricity - once-through - Electricity by gas', 'Water Consumption Blue - Electricity - once-through - Electricity by nuclear', 'Water Consumption Blue - Electricity - once-through - Electricity by hydro', 'Water Consumption Blue - Electricity - once-through - Electricity by wind', 'Water Consumption Blue - Electricity - once-through - Electricity by petroleum and other oil derivatives', 'Water Consumption Blue - Electricity - once-through - Electricity by biomass and waste', 'Water Consumption Blue - Electricity - once-through - Electricity by solar photovoltaic', 'Water Consumption Blue - Electricity - once-through - Electricity by solar thermal', 'Water Consumption Blue - Electricity - once-through - Electricity by tide, wave, ocean', 'Water Consumption Blue - Electricity - once-through - Electricity by Geothermal', 'Water Consumption Blue - Electricity - once-through - Electricity nec', 'Water Consumption Blue - Domestic - domestic Water Consumption Blue', 'Water Withdrawal Blue - Manufacturing - Products of meat cattle', 'Water Withdrawal Blue - Manufacturing - Products of meat pigs', 'Water Withdrawal Blue - Manufacturing - Products of meat poultry', 'Water Withdrawal Blue - Manufacturing - Meat products nec', 'Water Withdrawal Blue - Manufacturing - products of Vegetable oils and fats', 'Water Withdrawal Blue - Manufacturing - Dairy products', 'Water Withdrawal Blue - Manufacturing - Processed rice', 'Water Withdrawal Blue - Manufacturing - Sugar', 'Water Withdrawal Blue - Manufacturing - Food products nec', 'Water Withdrawal Blue - Manufacturing - Beverages', 'Water Withdrawal Blue - Manufacturing - Fish products', 'Water Withdrawal Blue - Manufacturing - Tobacco products (16)', 'Water Withdrawal Blue - Manufacturing - Textiles (17)', 'Water Withdrawal Blue - Manufacturing - Wearing apparel; furs (18)', 'Water Withdrawal Blue - Manufacturing - Leather and leather products (19)', 'Water Withdrawal Blue - Manufacturing - Pulp', 'Water Withdrawal Blue - Manufacturing - Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Water Withdrawal Blue - Manufacturing - Paper and paper products', 'Water Withdrawal Blue - Manufacturing - Printed matter and recorded media (22)', 'Water Withdrawal Blue - Manufacturing - Plastics, basic', 'Water Withdrawal Blue - Manufacturing - Secondary plastic for treatment, Re-processing of secondary plastic into new plastic', 'Water Withdrawal Blue - Manufacturing - N-fertiliser', 'Water Withdrawal Blue - Manufacturing - P- and other fertiliser', 'Water Withdrawal Blue - Manufacturing - Chemicals nec', 'Water Withdrawal Blue - Manufacturing - Rubber and plastic products (25)', 'Water Withdrawal Blue - Manufacturing - Glass and glass products', 'Water Withdrawal Blue - Manufacturing - Secondary glass for treatment, Re-processing of secondary glass into new glass', 'Water Withdrawal Blue - Manufacturing - Ceramic goods', 'Water Withdrawal Blue - Manufacturing - Bricks, tiles and construction products, in baked clay', 'Water Withdrawal Blue - Manufacturing - Cement, lime and plaster', 'Water Withdrawal Blue - Manufacturing - Ash for treatment, Re-processing of ash into clinker', 'Water Withdrawal Blue - Manufacturing - Other non-metallic mineral products', 'Water Withdrawal Blue - Manufacturing - Basic iron and steel and of ferro-alloys and first products thereof', 'Water Withdrawal Blue - Manufacturing - Secondary steel for treatment, Re-processing of secondary steel into new steel', 'Water Withdrawal Blue - Manufacturing - Precious metals', 'Water Withdrawal Blue - Manufacturing - Secondary preciuos metals for treatment, Re-processing of secondary preciuos metals into new preciuos metals', 'Water Withdrawal Blue - Manufacturing - Aluminium and aluminium products', 'Water Withdrawal Blue - Manufacturing - Secondary aluminium for treatment, Re-processing of secondary aluminium into new aluminium', 'Water Withdrawal Blue - Manufacturing - Lead, zinc and tin and products thereof', 'Water Withdrawal Blue - Manufacturing - Secondary lead for treatment, Re-processing of secondary lead into new lead', 'Water Withdrawal Blue - Manufacturing - Copper products', 'Water Withdrawal Blue - Manufacturing - Secondary copper for treatment, Re-processing of secondary copper into new copper', 'Water Withdrawal Blue - Manufacturing - Other non-ferrous metal products', 'Water Withdrawal Blue - Manufacturing - Secondary other non-ferrous metals for treatment, Re-processing of secondary other non-ferrous metals into new other non-ferrous metals', 'Water Withdrawal Blue - Manufacturing - Fabricated metal products, except machinery and equipment (28)', 'Water Withdrawal Blue - Manufacturing - Machinery and equipment n.e.c. (29)', 'Water Withdrawal Blue - Manufacturing - Office machinery and computers (30)', 'Water Withdrawal Blue - Manufacturing - Electrical machinery and apparatus n.e.c. (31)', 'Water Withdrawal Blue - Manufacturing - Radio, television and communication equipment and apparatus (32)', 'Water Withdrawal Blue - Manufacturing - Medical, precision and optical instruments, watches and clocks (33)', 'Water Withdrawal Blue - Manufacturing - Motor vehicles, trailers and semi-trailers (34)', 'Water Withdrawal Blue - Manufacturing - Other transport equipment (35)', 'Water Withdrawal Blue - Manufacturing - Furniture; other manufactured goods n.e.c. (36)', 'Water Withdrawal Blue - Electricity - tower - Electricity by coal', 'Water Withdrawal Blue - Electricity - tower - Electricity by gas', 'Water Withdrawal Blue - Electricity - tower - Electricity by nuclear', 'Water Withdrawal Blue - Electricity - tower - Electricity by hydro', 'Water Withdrawal Blue - Electricity - tower - Electricity by wind', 'Water Withdrawal Blue - Electricity - tower - Electricity by petroleum and other oil derivatives', 'Water Withdrawal Blue - Electricity - tower - Electricity by biomass and waste', 'Water Withdrawal Blue - Electricity - tower - Electricity by solar photovoltaic', 'Water Withdrawal Blue - Electricity - tower - Electricity by solar thermal', 'Water Withdrawal Blue - Electricity - tower - Electricity by tide, wave, ocean', 'Water Withdrawal Blue - Electricity - tower - Electricity by Geothermal', 'Water Withdrawal Blue - Electricity - tower - Electricity nec', 'Water Withdrawal Blue - Electricity - once-through - Electricity by coal', 'Water Withdrawal Blue - Electricity - once-through - Electricity by gas', 'Water Withdrawal Blue - Electricity - once-through - Electricity by nuclear', 'Water Withdrawal Blue - Electricity - once-through - Electricity by hydro', 'Water Withdrawal Blue - Electricity - once-through - Electricity by wind', 'Water Withdrawal Blue - Electricity - once-through - Electricity by petroleum and other oil derivatives', 'Water Withdrawal Blue - Electricity - once-through - Electricity by biomass and waste', 'Water Withdrawal Blue - Electricity - once-through - Electricity by solar photovoltaic', 'Water Withdrawal Blue - Electricity - once-through - Electricity by solar thermal', 'Water Withdrawal Blue - Electricity - once-through - Electricity by tide, wave, ocean', 'Water Withdrawal Blue - Electricity - once-through - Electricity by Geothermal', 'Water Withdrawal Blue - Electricity - once-through - Electricity nec', 'Water Withdrawal Blue - Domestic - domestic Water Withdrawal Blue', 'Energy Carrier Net Additives/Blending Components', 'Energy Carrier Net Anthracite', 'Energy Carrier Net Aviation Gasoline', 'Energy Carrier Net BKB/Peat Briquettes', 'Energy Carrier Net Biodiesels', 'Energy Carrier Net Biogas', 'Energy Carrier Net Biogasoline', 'Energy Carrier Net Bitumen', 'Energy Carrier Net Blast Furnace Gas', 'Energy Carrier Net Charcoal', 'Energy Carrier Net Coal Tar', 'Energy Carrier Net Coke Oven Coke', 'Energy Carrier Net Coke oven gas', 'Energy Carrier Net Coking Coal', 'Energy Carrier Net Crops nec', 'Energy Carrier Net Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Net Electricity by Geothermal', 'Energy Carrier Net Electricity by biomass and waste', 'Energy Carrier Net Electricity by coal', 'Energy Carrier Net Electricity by gas', 'Energy Carrier Net Electricity by hydro', 'Energy Carrier Net Electricity by nuclear', 'Energy Carrier Net Electricity by petroleum and other oil derivatives', 'Energy Carrier Net Electricity by solar photovoltaic', 'Energy Carrier Net Electricity by solar thermal', 'Energy Carrier Net Electricity by tide, wave, ocean', 'Energy Carrier Net Electricity by wind', 'Energy Carrier Net Electricity nec', 'Energy Carrier Net Ethane', 'Energy Carrier Net Food products nec', 'Energy Carrier Net Food waste for treatment: incineration', 'Energy Carrier Net Gas Coke', 'Energy Carrier Net Gas Works Gas', 'Energy Carrier Net Gas/Diesel Oil', 'Energy Carrier Net Gasoline Type Jet Fuel', 'Energy Carrier Net Heavy Fuel Oil', 'Energy Carrier Net Intert/metal waste for treatment: incineration', 'Energy Carrier Net Kerosene', 'Energy Carrier Net Kerosene Type Jet Fuel', 'Energy Carrier Net Lignite/Brown Coal', 'Energy Carrier Net Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net Lubricants', 'Energy Carrier Net Manure (biogas treatment)', 'Energy Carrier Net Manure (conventional treatment)', 'Energy Carrier Net Motor Gasoline', 'Energy Carrier Net Naphtha', 'Energy Carrier Net Natural Gas Liquids', 'Energy Carrier Net Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net Non-specified Petroleum Products', 'Energy Carrier Net Nuclear fuel', 'Energy Carrier Net Oil/hazardous waste for treatment: incineration', 'Energy Carrier Net Other Bituminous Coal', 'Energy Carrier Net Other Hydrocarbons', 'Energy Carrier Net Other Liquid Biofuels', 'Energy Carrier Net Oxygen Steel Furnace Gas', 'Energy Carrier Net Paper waste for treatment: incineration', 'Energy Carrier Net Paraffin Waxes', 'Energy Carrier Net Patent Fuel', 'Energy Carrier Net Peat', 'Energy Carrier Net Petroleum Coke', 'Energy Carrier Net Plastic waste for treatment: incineration', 'Energy Carrier Net Products of forestry, logging and related services (02)', 'Energy Carrier Net Pulp', 'Energy Carrier Net Refinery Feedstocks', 'Energy Carrier Net Refinery Gas', 'Energy Carrier Net Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Net Steam and hot water supply services', 'Energy Carrier Net Sub-Bituminous Coal', 'Energy Carrier Net Sugar', 'Energy Carrier Net Textiles waste for treatment: incineration', 'Energy Carrier Net Uranium and thorium ores (12)', 'Energy Carrier Net White Spirit & SBP', 'Energy Carrier Net Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Energy Carrier Net Wood waste for treatment: incineration', 'Energy Carrier Net NENE Anthracite', 'Energy Carrier Net NENE Bitumen', 'Energy Carrier Net NENE BKB/Peat Briquettes', 'Energy Carrier Net NENE Blast Furnace Gas', 'Energy Carrier Net NENE Coal Tar', 'Energy Carrier Net NENE Coke Oven Coke', 'Energy Carrier Net NENE Coke oven gas', 'Energy Carrier Net NENE Coking Coal', 'Energy Carrier Net NENE Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Net NENE Ethane', 'Energy Carrier Net NENE Gas Works Gas', 'Energy Carrier Net NENE Gas/Diesel Oil', 'Energy Carrier Net NENE Heavy Fuel Oil', 'Energy Carrier Net NENE Kerosene', 'Energy Carrier Net NENE Kerosene Type Jet Fuel', 'Energy Carrier Net NENE Lignite/Brown Coal', 'Energy Carrier Net NENE Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net NENE Lubricants', 'Energy Carrier Net NENE Motor Gasoline', 'Energy Carrier Net NENE Naphtha', 'Energy Carrier Net NENE Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net NENE Natural Gas Liquids', 'Energy Carrier Net NENE Non-specified Petroleum Products', 'Energy Carrier Net NENE Other Bituminous Coal', 'Energy Carrier Net NENE Oxygen Steel Furnace Gas', 'Energy Carrier Net NENE Paraffin Waxes', 'Energy Carrier Net NENE Patent Fuel', 'Energy Carrier Net NENE Peat', 'Energy Carrier Net NENE Petroleum Coke', 'Energy Carrier Net NENE Refinery Gas', 'Energy Carrier Net NENE Sub-Bituminous Coal', 'Energy Carrier Net NENE White Spirit & SBP', 'Energy Carrier Net NTRA Additives/Blending Components', 'Energy Carrier Net NTRA Anthracite', 'Energy Carrier Net NTRA Aviation Gasoline', 'Energy Carrier Net NTRA Biodiesels', 'Energy Carrier Net NTRA Biogas', 'Energy Carrier Net NTRA Biogasoline', 'Energy Carrier Net NTRA Bitumen', 'Energy Carrier Net NTRA BKB/Peat Briquettes', 'Energy Carrier Net NTRA Blast Furnace Gas', 'Energy Carrier Net NTRA Charcoal', 'Energy Carrier Net NTRA Coal Tar', 'Energy Carrier Net NTRA Coke Oven Coke', 'Energy Carrier Net NTRA Coke oven gas', 'Energy Carrier Net NTRA Coking Coal', 'Energy Carrier Net NTRA Crops nec', 'Energy Carrier Net NTRA Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Net NTRA Electricity by biomass and waste', 'Energy Carrier Net NTRA Electricity by coal', 'Energy Carrier Net NTRA Electricity by gas', 'Energy Carrier Net NTRA Electricity by Geothermal', 'Energy Carrier Net NTRA Electricity by hydro', 'Energy Carrier Net NTRA Electricity by nuclear', 'Energy Carrier Net NTRA Electricity by petroleum and other oil derivatives', 'Energy Carrier Net NTRA Electricity by solar photovoltaic', 'Energy Carrier Net NTRA Electricity by solar thermal', 'Energy Carrier Net NTRA Electricity by tide, wave, ocean', 'Energy Carrier Net NTRA Electricity by wind', 'Energy Carrier Net NTRA Electricity nec', 'Energy Carrier Net NTRA Ethane', 'Energy Carrier Net NTRA Food products nec', 'Energy Carrier Net NTRA Food waste for treatment: incineration', 'Energy Carrier Net NTRA Gas Coke', 'Energy Carrier Net NTRA Gas Works Gas', 'Energy Carrier Net NTRA Gas/Diesel Oil', 'Energy Carrier Net NTRA Heavy Fuel Oil', 'Energy Carrier Net NTRA Intert/metal waste for treatment: incineration', 'Energy Carrier Net NTRA Kerosene', 'Energy Carrier Net NTRA Kerosene Type Jet Fuel', 'Energy Carrier Net NTRA Lignite/Brown Coal', 'Energy Carrier Net NTRA Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net NTRA Lubricants', 'Energy Carrier Net NTRA Manure (biogas treatment)', 'Energy Carrier Net NTRA Manure (conventional treatment)', 'Energy Carrier Net NTRA Motor Gasoline', 'Energy Carrier Net NTRA Naphtha', 'Energy Carrier Net NTRA Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net NTRA Natural Gas Liquids', 'Energy Carrier Net NTRA Non-specified Petroleum Products', 'Energy Carrier Net NTRA Oil/hazardous waste for treatment: incineration', 'Energy Carrier Net NTRA Other Bituminous Coal', 'Energy Carrier Net NTRA Other Hydrocarbons', 'Energy Carrier Net NTRA Other Liquid Biofuels', 'Energy Carrier Net NTRA Oxygen Steel Furnace Gas', 'Energy Carrier Net NTRA Paper waste for treatment: incineration', 'Energy Carrier Net NTRA Paraffin Waxes', 'Energy Carrier Net NTRA Patent Fuel', 'Energy Carrier Net NTRA Peat', 'Energy Carrier Net NTRA Petroleum Coke', 'Energy Carrier Net NTRA Plastic waste for treatment: incineration', 'Energy Carrier Net NTRA Products of forestry, logging and related services (02)', 'Energy Carrier Net NTRA Pulp', 'Energy Carrier Net NTRA Refinery Gas', 'Energy Carrier Net NTRA Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Net NTRA Steam and hot water supply services', 'Energy Carrier Net NTRA Sub-Bituminous Coal', 'Energy Carrier Net NTRA Sugar', 'Energy Carrier Net NTRA Textiles waste for treatment: incineration', 'Energy Carrier Net NTRA White Spirit & SBP', 'Energy Carrier Net NTRA Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Energy Carrier Net NTRA Wood waste for treatment: incineration', 'Energy Carrier Net TAVI Aviation Gasoline', 'Energy Carrier Net TAVI Gas/Diesel Oil', 'Energy Carrier Net TAVI Gasoline Type Jet Fuel', 'Energy Carrier Net TAVI Heavy Fuel Oil', 'Energy Carrier Net TAVI Kerosene', 'Energy Carrier Net TAVI Kerosene Type Jet Fuel', 'Energy Carrier Net TAVI Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net TAVI Motor Gasoline', 'Energy Carrier Net TMAR Biodiesels', 'Energy Carrier Net TMAR Biogasoline', 'Energy Carrier Net TMAR Bitumen', 'Energy Carrier Net TMAR Coke Oven Coke', 'Energy Carrier Net TMAR Food products nec', 'Energy Carrier Net TMAR Gas/Diesel Oil', 'Energy Carrier Net TMAR Heavy Fuel Oil', 'Energy Carrier Net TMAR Kerosene', 'Energy Carrier Net TMAR Kerosene Type Jet Fuel', 'Energy Carrier Net TMAR Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net TMAR Lubricants', 'Energy Carrier Net TMAR Motor Gasoline', 'Energy Carrier Net TMAR Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net TMAR Non-specified Petroleum Products', 'Energy Carrier Net TMAR Other Bituminous Coal', 'Energy Carrier Net TMAR Sub-Bituminous Coal', 'Energy Carrier Net TOTH Additives/Blending Components', 'Energy Carrier Net TOTH Anthracite', 'Energy Carrier Net TOTH Biodiesels', 'Energy Carrier Net TOTH Biogas', 'Energy Carrier Net TOTH Bitumen', 'Energy Carrier Net TOTH BKB/Peat Briquettes', 'Energy Carrier Net TOTH Coke Oven Coke', 'Energy Carrier Net TOTH Crops nec', 'Energy Carrier Net TOTH Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Net TOTH Electricity by biomass and waste', 'Energy Carrier Net TOTH Electricity by coal', 'Energy Carrier Net TOTH Electricity by gas', 'Energy Carrier Net TOTH Electricity by Geothermal', 'Energy Carrier Net TOTH Electricity by hydro', 'Energy Carrier Net TOTH Electricity by nuclear', 'Energy Carrier Net TOTH Electricity by petroleum and other oil derivatives', 'Energy Carrier Net TOTH Electricity by solar photovoltaic', 'Energy Carrier Net TOTH Electricity by solar thermal', 'Energy Carrier Net TOTH Electricity by tide, wave, ocean', 'Energy Carrier Net TOTH Electricity by wind', 'Energy Carrier Net TOTH Food products nec', 'Energy Carrier Net TOTH Gas/Diesel Oil', 'Energy Carrier Net TOTH Heavy Fuel Oil', 'Energy Carrier Net TOTH Kerosene', 'Energy Carrier Net TOTH Kerosene Type Jet Fuel', 'Energy Carrier Net TOTH Lignite/Brown Coal', 'Energy Carrier Net TOTH Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net TOTH Motor Gasoline', 'Energy Carrier Net TOTH Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net TOTH Non-specified Petroleum Products', 'Energy Carrier Net TOTH Other Bituminous Coal', 'Energy Carrier Net TOTH Products of forestry, logging and related services (02)', 'Energy Carrier Net TOTH Pulp', 'Energy Carrier Net TOTH Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Net TOTH Sub-Bituminous Coal', 'Energy Carrier Net TOTH Sugar', 'Energy Carrier Net TRAI Anthracite', 'Energy Carrier Net TRAI Biodiesels', 'Energy Carrier Net TRAI BKB/Peat Briquettes', 'Energy Carrier Net TRAI Coke Oven Coke', 'Energy Carrier Net TRAI Coking Coal', 'Energy Carrier Net TRAI Crops nec', 'Energy Carrier Net TRAI Electricity by biomass and waste', 'Energy Carrier Net TRAI Electricity by coal', 'Energy Carrier Net TRAI Electricity by gas', 'Energy Carrier Net TRAI Electricity by Geothermal', 'Energy Carrier Net TRAI Electricity by hydro', 'Energy Carrier Net TRAI Electricity by nuclear', 'Energy Carrier Net TRAI Electricity by petroleum and other oil derivatives', 'Energy Carrier Net TRAI Electricity by solar photovoltaic', 'Energy Carrier Net TRAI Electricity by solar thermal', 'Energy Carrier Net TRAI Electricity by tide, wave, ocean', 'Energy Carrier Net TRAI Electricity by wind', 'Energy Carrier Net TRAI Electricity nec', 'Energy Carrier Net TRAI Food products nec', 'Energy Carrier Net TRAI Gas/Diesel Oil', 'Energy Carrier Net TRAI Heavy Fuel Oil', 'Energy Carrier Net TRAI Kerosene', 'Energy Carrier Net TRAI Lignite/Brown Coal', 'Energy Carrier Net TRAI Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net TRAI Lubricants', 'Energy Carrier Net TRAI Motor Gasoline', 'Energy Carrier Net TRAI Non-specified Petroleum Products', 'Energy Carrier Net TRAI Other Bituminous Coal', 'Energy Carrier Net TRAI Peat', 'Energy Carrier Net TRAI Products of forestry, logging and related services (02)', 'Energy Carrier Net TRAI Pulp', 'Energy Carrier Net TRAI Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Net TRAI Sub-Bituminous Coal', 'Energy Carrier Net TRAI Sugar', 'Energy Carrier Net TRAI White Spirit & SBP', 'Energy Carrier Net TROA Biodiesels', 'Energy Carrier Net TROA Biogas', 'Energy Carrier Net TROA Biogasoline', 'Energy Carrier Net TROA Electricity by biomass and waste', 'Energy Carrier Net TROA Electricity by coal', 'Energy Carrier Net TROA Electricity by gas', 'Energy Carrier Net TROA Electricity by nuclear', 'Energy Carrier Net TROA Electricity by petroleum and other oil derivatives', 'Energy Carrier Net TROA Food products nec', 'Energy Carrier Net TROA Gas/Diesel Oil', 'Energy Carrier Net TROA Heavy Fuel Oil', 'Energy Carrier Net TROA Kerosene', 'Energy Carrier Net TROA Kerosene Type Jet Fuel', 'Energy Carrier Net TROA Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net TROA Motor Gasoline', 'Energy Carrier Net TROA Naphtha', 'Energy Carrier Net TROA Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net TROA Natural Gas Liquids', 'Energy Carrier Net TROA Non-specified Petroleum Products', 'Energy Carrier Net TROA Other Liquid Biofuels', 'Energy Carrier Net TROA Products of forestry, logging and related services (02)', 'Energy Carrier Net TROA Pulp', 'Energy Carrier Net TROA Refinery Gas', 'Energy Carrier Net TROA Sugar', 'Energy Carrier Net TROA White Spirit & SBP', 'Energy Carrier Net LOSS Additives/Blending Components', 'Energy Carrier Net LOSS Anthracite', 'Energy Carrier Net LOSS Aviation Gasoline', 'Energy Carrier Net LOSS Biodiesels', 'Energy Carrier Net LOSS Biogas', 'Energy Carrier Net LOSS Biogasoline', 'Energy Carrier Net LOSS Bitumen', 'Energy Carrier Net LOSS BKB/Peat Briquettes', 'Energy Carrier Net LOSS Blast Furnace Gas', 'Energy Carrier Net LOSS Charcoal', 'Energy Carrier Net LOSS Coal Tar', 'Energy Carrier Net LOSS Coke Oven Coke', 'Energy Carrier Net LOSS Coke oven gas', 'Energy Carrier Net LOSS Coking Coal', 'Energy Carrier Net LOSS Crops nec', 'Energy Carrier Net LOSS Crude petroleum and services related to crude oil extraction, excluding surveying', 'Energy Carrier Net LOSS Electricity by biomass and waste', 'Energy Carrier Net LOSS Electricity by coal', 'Energy Carrier Net LOSS Electricity by gas', 'Energy Carrier Net LOSS Electricity by Geothermal', 'Energy Carrier Net LOSS Electricity by hydro', 'Energy Carrier Net LOSS Electricity by nuclear', 'Energy Carrier Net LOSS Electricity by petroleum and other oil derivatives', 'Energy Carrier Net LOSS Electricity by solar photovoltaic', 'Energy Carrier Net LOSS Electricity by solar thermal', 'Energy Carrier Net LOSS Electricity by tide, wave, ocean', 'Energy Carrier Net LOSS Electricity by wind', 'Energy Carrier Net LOSS Electricity nec', 'Energy Carrier Net LOSS Ethane', 'Energy Carrier Net LOSS Food products nec', 'Energy Carrier Net LOSS Food waste for treatment: incineration', 'Energy Carrier Net LOSS Gas Coke', 'Energy Carrier Net LOSS Gas Works Gas', 'Energy Carrier Net LOSS Gas/Diesel Oil', 'Energy Carrier Net LOSS Gasoline Type Jet Fuel', 'Energy Carrier Net LOSS Heavy Fuel Oil', 'Energy Carrier Net LOSS Intert/metal waste for treatment: incineration', 'Energy Carrier Net LOSS Kerosene', 'Energy Carrier Net LOSS Kerosene Type Jet Fuel', 'Energy Carrier Net LOSS Lignite/Brown Coal', 'Energy Carrier Net LOSS Liquefied Petroleum Gases (LPG)', 'Energy Carrier Net LOSS Lubricants', 'Energy Carrier Net LOSS Manure (biogas treatment)', 'Energy Carrier Net LOSS Manure (conventional treatment)', 'Energy Carrier Net LOSS Motor Gasoline', 'Energy Carrier Net LOSS Naphtha', 'Energy Carrier Net LOSS Natural gas and services related to natural gas extraction, excluding surveying', 'Energy Carrier Net LOSS Natural Gas Liquids', 'Energy Carrier Net LOSS Non-specified Petroleum Products', 'Energy Carrier Net LOSS Nuclear fuel', 'Energy Carrier Net LOSS Oil/hazardous waste for treatment: incineration', 'Energy Carrier Net LOSS Other Bituminous Coal', 'Energy Carrier Net LOSS Other Hydrocarbons', 'Energy Carrier Net LOSS Other Liquid Biofuels', 'Energy Carrier Net LOSS Oxygen Steel Furnace Gas', 'Energy Carrier Net LOSS Paper waste for treatment: incineration', 'Energy Carrier Net LOSS Paraffin Waxes', 'Energy Carrier Net LOSS Patent Fuel', 'Energy Carrier Net LOSS Peat', 'Energy Carrier Net LOSS Petroleum Coke', 'Energy Carrier Net LOSS Plastic waste for treatment: incineration', 'Energy Carrier Net LOSS Products of forestry, logging and related services (02)', 'Energy Carrier Net LOSS Pulp', 'Energy Carrier Net LOSS Refinery Feedstocks', 'Energy Carrier Net LOSS Refinery Gas', 'Energy Carrier Net LOSS Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Energy Carrier Net LOSS Steam and hot water supply services', 'Energy Carrier Net LOSS Sub-Bituminous Coal', 'Energy Carrier Net LOSS Sugar', 'Energy Carrier Net LOSS Textiles waste for treatment: incineration', 'Energy Carrier Net LOSS White Spirit & SBP', 'Energy Carrier Net LOSS Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Energy Carrier Net LOSS Wood waste for treatment: incineration']\n",
      "['M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', 'M.EUR', '1000 p', '1000 p', '1000 p', '1000 p', '1000 p', '1000 p', 'M.hr', 'M.hr', 'M.hr', 'M.hr', 'M.hr', 'M.hr', '1000 p', 'M.hr', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg CO2-eq', 'kg CO2-eq', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'kg', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'km2', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'kt', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'Mm3', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ', 'TJ']\n"
     ]
    }
   ],
   "source": [
    "print(MRIO_Ftype)\n",
    "print(MRIO_Funit)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting the Industry and Region Names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "Path_F = Directory + 'products.txt'\n",
    "MRIO_Industries = pd.read_csv(Path_F, sep = '\\t', header=0, encoding = 'iso-8859-1' ) # standard UTF-8 encoding raises error\n",
    "MRIO_Industries = MRIO_Industries.astype('str')\n",
    "MRIO_Industries = MRIO_Industries.reset_index()\n",
    "MRIO_Industries = list(MRIO_Industries['Name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Paddy rice', 'Wheat', 'Cereal grains nec', 'Vegetables, fruit, nuts', 'Oil seeds', 'Sugar cane, sugar beet', 'Plant-based fibers', 'Crops nec', 'Cattle', 'Pigs', 'Poultry', 'Meat animals nec', 'Animal products nec', 'Raw milk', 'Wool, silk-worm cocoons', 'Manure (conventional treatment)', 'Manure (biogas treatment)', 'Products of forestry, logging and related services (02)', 'Fish and other fishing products; services incidental of fishing (05)', 'Anthracite', 'Coking Coal', 'Other Bituminous Coal', 'Sub-Bituminous Coal', 'Patent Fuel', 'Lignite/Brown Coal', 'BKB/Peat Briquettes', 'Peat', 'Crude petroleum and services related to crude oil extraction, excluding surveying', 'Natural gas and services related to natural gas extraction, excluding surveying', 'Natural Gas Liquids', 'Other Hydrocarbons', 'Uranium and thorium ores (12)', 'Iron ores', 'Copper ores and concentrates', 'Nickel ores and concentrates', 'Aluminium ores and concentrates', 'Precious metal ores and concentrates', 'Lead, zinc and tin ores and concentrates', 'Other non-ferrous metal ores and concentrates', 'Stone', 'Sand and clay', 'Chemical and fertilizer minerals, salt and other mining and quarrying products n.e.c.', 'Products of meat cattle', 'Products of meat pigs', 'Products of meat poultry', 'Meat products nec', 'products of Vegetable oils and fats', 'Dairy products', 'Processed rice', 'Sugar', 'Food products nec', 'Beverages', 'Fish products', 'Tobacco products (16)', 'Textiles (17)', 'Wearing apparel; furs (18)', 'Leather and leather products (19)', 'Wood and products of wood and cork (except furniture); articles of straw and plaiting materials (20)', 'Wood material for treatment, Re-processing of secondary wood material into new wood material', 'Pulp', 'Secondary paper for treatment, Re-processing of secondary paper into new pulp', 'Paper and paper products', 'Printed matter and recorded media (22)', 'Coke Oven Coke', 'Gas Coke', 'Coal Tar', 'Motor Gasoline', 'Aviation Gasoline', 'Gasoline Type Jet Fuel', 'Kerosene Type Jet Fuel', 'Kerosene', 'Gas/Diesel Oil', 'Heavy Fuel Oil', 'Refinery Gas', 'Liquefied Petroleum Gases (LPG)', 'Refinery Feedstocks', 'Ethane', 'Naphtha', 'White Spirit & SBP', 'Lubricants', 'Bitumen', 'Paraffin Waxes', 'Petroleum Coke', 'Non-specified Petroleum Products', 'Nuclear fuel', 'Plastics, basic', 'Secondary plastic for treatment, Re-processing of secondary plastic into new plastic', 'N-fertiliser', 'P- and other fertiliser', 'Chemicals nec', 'Charcoal', 'Additives/Blending Components', 'Biogasoline', 'Biodiesels', 'Other Liquid Biofuels', 'Rubber and plastic products (25)', 'Glass and glass products', 'Secondary glass for treatment, Re-processing of secondary glass into new glass', 'Ceramic goods', 'Bricks, tiles and construction products, in baked clay', 'Cement, lime and plaster', 'Ash for treatment, Re-processing of ash into clinker', 'Other non-metallic mineral products', 'Basic iron and steel and of ferro-alloys and first products thereof', 'Secondary steel for treatment, Re-processing of secondary steel into new steel', 'Precious metals', 'Secondary preciuos metals for treatment, Re-processing of secondary preciuos metals into new preciuos metals', 'Aluminium and aluminium products', 'Secondary aluminium for treatment, Re-processing of secondary aluminium into new aluminium', 'Lead, zinc and tin and products thereof', 'Secondary lead for treatment, Re-processing of secondary lead into new lead', 'Copper products', 'Secondary copper for treatment, Re-processing of secondary copper into new copper', 'Other non-ferrous metal products', 'Secondary other non-ferrous metals for treatment, Re-processing of secondary other non-ferrous metals into new other non-ferrous metals', 'Foundry work services', 'Fabricated metal products, except machinery and equipment (28)', 'Machinery and equipment n.e.c. (29)', 'Office machinery and computers (30)', 'Electrical machinery and apparatus n.e.c. (31)', 'Radio, television and communication equipment and apparatus (32)', 'Medical, precision and optical instruments, watches and clocks (33)', 'Motor vehicles, trailers and semi-trailers (34)', 'Other transport equipment (35)', 'Furniture; other manufactured goods n.e.c. (36)', 'Secondary raw materials', 'Bottles for treatment, Recycling of bottles by direct reuse', 'Electricity by coal', 'Electricity by gas', 'Electricity by nuclear', 'Electricity by hydro', 'Electricity by wind', 'Electricity by petroleum and other oil derivatives', 'Electricity by biomass and waste', 'Electricity by solar photovoltaic', 'Electricity by solar thermal', 'Electricity by tide, wave, ocean', 'Electricity by Geothermal', 'Electricity nec', 'Transmission services of electricity', 'Distribution and trade services of electricity', 'Coke oven gas', 'Blast Furnace Gas', 'Oxygen Steel Furnace Gas', 'Gas Works Gas', 'Biogas', 'Distribution services of gaseous fuels through mains', 'Steam and hot water supply services', 'Collected and purified water, distribution services of water (41)', 'Construction work (45)', 'Secondary construction material for treatment, Re-processing of secondary construction material into aggregates', 'Sale, maintenance, repair of motor vehicles, motor vehicles parts, motorcycles, motor cycles parts and accessoiries', 'Retail trade services of motor fuel', 'Wholesale trade and commission trade services, except of motor vehicles and motorcycles (51)', 'Retail  trade services, except of motor vehicles and motorcycles; repair services of personal and household goods (52)', 'Hotel and restaurant services (55)', 'Railway transportation services', 'Other land transportation services', 'Transportation services via pipelines', 'Sea and coastal water transportation services', 'Inland water transportation services', 'Air transport services (62)', 'Supporting and auxiliary transport services; travel agency services (63)', 'Post and telecommunication services (64)', 'Financial intermediation services, except insurance and pension funding services (65)', 'Insurance and pension funding services, except compulsory social security services (66)', 'Services auxiliary to financial intermediation (67)', 'Real estate services (70)', 'Renting services of machinery and equipment without operator and of personal and household goods (71)', 'Computer and related services (72)', 'Research and development services (73)', 'Other business services (74)', 'Public administration and defence services; compulsory social security services (75)', 'Education services (80)', 'Health and social work services (85)', 'Food waste for treatment: incineration', 'Paper waste for treatment: incineration', 'Plastic waste for treatment: incineration', 'Intert/metal waste for treatment: incineration', 'Textiles waste for treatment: incineration', 'Wood waste for treatment: incineration', 'Oil/hazardous waste for treatment: incineration', 'Food waste for treatment: biogasification and land application', 'Paper waste for treatment: biogasification and land application', 'Sewage sludge for treatment: biogasification and land application', 'Food waste for treatment: composting and land application', 'Paper and wood waste for treatment: composting and land application', 'Food waste for treatment: waste water treatment', 'Other waste for treatment: waste water treatment', 'Food waste for treatment: landfill', 'Paper for treatment: landfill', 'Plastic waste for treatment: landfill', 'Inert/metal/hazardous waste for treatment: landfill', 'Textiles waste for treatment: landfill', 'Wood waste for treatment: landfill', 'Membership organisation services n.e.c. (91)', 'Recreational, cultural and sporting services (92)', 'Other services (93)', 'Private households with employed persons (95)', 'Extra-territorial organizations and bodies']\n"
     ]
    }
   ],
   "source": [
    "print(MRIO_Industries)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Inversing the A Matrix to Build the L Matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "I = np.identity(9800)\n",
    "\n",
    "MRIO_L = np.linalg.inv(I-MRIO_A)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9800, 9800)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MRIO_L.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Building the S Matrix (Emissions Intensity)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([    0.        ,   327.37609204,   657.08079216, ...,\n",
       "       20544.18561091,  4727.77025163,     0.        ])"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MRIO_X = MRIO_L.dot(MRIO_Y.sum(axis = 1))\n",
    "\n",
    "MRIO_X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "MRIO_S = np.zeros(MRIO_F.shape)\n",
    "\n",
    "for m in range(0,MRIO_A.shape[0]):\n",
    "    if MRIO_X[m] > 1: # Threshold for sector output: 1 MEUR\n",
    "        MRIO_S[:,m] = MRIO_F[:,m] / MRIO_X[m]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Saving the Newly Built EXIOBASE Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "Filestring_Matlab_out = 'C://Users//Gilang Hardadi//Documents//EXIOBASE_2//' + 'EXIOBASE3_10_ITC_pxp.mat'\n",
    "scipy.io.savemat(Filestring_Matlab_out, mdict={'EB3_FinalDemand_Emissions':MRIO_Fhh,\n",
    "                                               'EB3_S_ITC':MRIO_S,\n",
    "                                               'EB3_L_ITC':MRIO_L,\n",
    "                                               'EB3_Y':MRIO_Y,\n",
    "                                               'EB3_TableUnits':'MEUR',\n",
    "                                               'EB3_Extensions':MRIO_Funit,\n",
    "                                               'EB3_Extensions_Labels':MRIO_Ftype,\n",
    "                                               'EB3_Extensions_Units':MRIO_Funit,\n",
    "                                               'EB3_FDCats':MRIO_FCat,\n",
    "                                               'EB3_ProductNames200':MRIO_Industries,\n",
    "                                               'EB3_RegionList':MRIO_Country})"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}