demos/csv_export.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-04-29T07:13:09.581854Z",
     "start_time": "2024-04-29T07:13:07.406953Z"
    }
   },
   "source": [
    "from demos.demo_experiment import get_demo_experiment\n",
    "from enbios import Experiment\n",
    "\n",
    "exp: Experiment = get_demo_experiment()"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "loading experiment from pickle file...\n"
     ]
    }
   ],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-29T07:13:09.593568Z",
     "start_time": "2024-04-29T07:13:09.582985Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# The destination file path is the only required parameter\n",
    "csv_file_destination = \"experiment_export.csv\"\n",
    "exp.results_to_csv(csv_file_destination)"
   ],
   "id": "5e37f5c052d8918b",
   "outputs": [],
   "execution_count": 2
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-29T07:13:09.975083Z",
     "start_time": "2024-04-29T07:13:09.947426Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# let's display that csv file\n",
    "import pandas\n",
    "\n",
    "pandas.read_csv(csv_file_destination).fillna(\"\")"
   ],
   "id": "69b8bcc2d0ff4dc8",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "      scenario  level lvl_0  lvl_1  \\\n",
       "0   scenario 1      0  root          \n",
       "1   scenario 1      1         wind   \n",
       "2   scenario 1      2                \n",
       "3   scenario 1      2                \n",
       "4   scenario 1      1        solar   \n",
       "5   scenario 1      2                \n",
       "6   scenario 1      2                \n",
       "7   scenario 2      0  root          \n",
       "8   scenario 2      1         wind   \n",
       "9   scenario 2      2                \n",
       "10  scenario 2      2                \n",
       "11  scenario 2      1        solar   \n",
       "12  scenario 2      2                \n",
       "13  scenario 2      2                \n",
       "\n",
       "                                                lvl_2 results_GWP1000_unit  \\\n",
       "0                                                                kg CO2-Eq   \n",
       "1                                                                kg CO2-Eq   \n",
       "2   electricity production, wind, 1-3MW turbine, o...            kg CO2-Eq   \n",
       "3   electricity production, wind, 1-3MW turbine, o...            kg CO2-Eq   \n",
       "4                                                                kg CO2-Eq   \n",
       "5   electricity production, solar tower power plan...            kg CO2-Eq   \n",
       "6   electricity production, solar thermal paraboli...            kg CO2-Eq   \n",
       "7                                                                kg CO2-Eq   \n",
       "8                                                                kg CO2-Eq   \n",
       "9   electricity production, wind, 1-3MW turbine, o...            kg CO2-Eq   \n",
       "10  electricity production, wind, 1-3MW turbine, o...            kg CO2-Eq   \n",
       "11                                                               kg CO2-Eq   \n",
       "12  electricity production, solar tower power plan...            kg CO2-Eq   \n",
       "13  electricity production, solar thermal paraboli...            kg CO2-Eq   \n",
       "\n",
       "    results_GWP1000_magnitude results_WCP_unit  results_WCP_magnitude  \\\n",
       "0                    0.163069      cubic meter               0.001251   \n",
       "1                    0.071220      cubic meter               0.000785   \n",
       "2                    0.040728      cubic meter               0.000409   \n",
       "3                    0.030492      cubic meter               0.000376   \n",
       "4                    0.091849      cubic meter               0.000466   \n",
       "5                    0.043362      cubic meter               0.000211   \n",
       "6                    0.048488      cubic meter               0.000255   \n",
       "7                    0.241342      cubic meter               0.001581   \n",
       "8                    0.057644      cubic meter               0.000649   \n",
       "9                    0.027152      cubic meter               0.000273   \n",
       "10                   0.030492      cubic meter               0.000376   \n",
       "11                   0.183698      cubic meter               0.000932   \n",
       "12                   0.086723      cubic meter               0.000423   \n",
       "13                   0.096975      cubic meter               0.000509   \n",
       "\n",
       "   results_HToxicity_unit  results_HToxicity_magnitude  output_0_unit  \\\n",
       "0           kg 1,4-DCB-Eq                     0.000118  kilowatt_hour   \n",
       "1           kg 1,4-DCB-Eq                     0.000073  kilowatt_hour   \n",
       "2           kg 1,4-DCB-Eq                     0.000039  kilowatt_hour   \n",
       "3           kg 1,4-DCB-Eq                     0.000034  kilowatt_hour   \n",
       "4           kg 1,4-DCB-Eq                     0.000046  kilowatt_hour   \n",
       "5           kg 1,4-DCB-Eq                     0.000019  kilowatt_hour   \n",
       "6           kg 1,4-DCB-Eq                     0.000027  kilowatt_hour   \n",
       "7           kg 1,4-DCB-Eq                     0.000151  kilowatt_hour   \n",
       "8           kg 1,4-DCB-Eq                     0.000060  kilowatt_hour   \n",
       "9           kg 1,4-DCB-Eq                     0.000026  kilowatt_hour   \n",
       "10          kg 1,4-DCB-Eq                     0.000034  kilowatt_hour   \n",
       "11          kg 1,4-DCB-Eq                     0.000091  kilowatt_hour   \n",
       "12          kg 1,4-DCB-Eq                     0.000038  kilowatt_hour   \n",
       "13          kg 1,4-DCB-Eq                     0.000053  kilowatt_hour   \n",
       "\n",
       "    output_0_magnitude output_0_label                  bw_activity_code  \n",
       "0                  7.0                                                   \n",
       "1                  5.0                                                   \n",
       "2                  3.0                 ed3da88fc23311ee183e9ffd376de89b  \n",
       "3                  2.0                 6ebfe52dc3ef5b4d35bb603b03559023  \n",
       "4                  2.0                                                   \n",
       "5                  1.0                 f2700b2ffcb6b32143a6f95d9cca1721  \n",
       "6                  1.0                 19040cdacdbf038e2f6ad59814f7a9ed  \n",
       "7                  8.0                                                   \n",
       "8                  4.0                                                   \n",
       "9                  2.0                 ed3da88fc23311ee183e9ffd376de89b  \n",
       "10                 2.0                 6ebfe52dc3ef5b4d35bb603b03559023  \n",
       "11                 4.0                                                   \n",
       "12                 2.0                 f2700b2ffcb6b32143a6f95d9cca1721  \n",
       "13                 2.0                 19040cdacdbf038e2f6ad59814f7a9ed  "
      ],
      "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>scenario</th>\n",
       "      <th>level</th>\n",
       "      <th>lvl_0</th>\n",
       "      <th>lvl_1</th>\n",
       "      <th>lvl_2</th>\n",
       "      <th>results_GWP1000_unit</th>\n",
       "      <th>results_GWP1000_magnitude</th>\n",
       "      <th>results_WCP_unit</th>\n",
       "      <th>results_WCP_magnitude</th>\n",
       "      <th>results_HToxicity_unit</th>\n",
       "      <th>results_HToxicity_magnitude</th>\n",
       "      <th>output_0_unit</th>\n",
       "      <th>output_0_magnitude</th>\n",
       "      <th>output_0_label</th>\n",
       "      <th>bw_activity_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>0</td>\n",
       "      <td>root</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.163069</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001251</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000118</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>7.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>wind</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.071220</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000785</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000073</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>5.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.040728</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000409</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>3.0</td>\n",
       "      <td></td>\n",
       "      <td>ed3da88fc23311ee183e9ffd376de89b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>6ebfe52dc3ef5b4d35bb603b03559023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>solar</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.091849</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000466</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.043362</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000211</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000019</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>f2700b2ffcb6b32143a6f95d9cca1721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.048488</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000255</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000027</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>19040cdacdbf038e2f6ad59814f7a9ed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>0</td>\n",
       "      <td>root</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.241342</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001581</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000151</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>8.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>wind</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.057644</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000649</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000060</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>4.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.027152</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000273</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000026</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>ed3da88fc23311ee183e9ffd376de89b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>6ebfe52dc3ef5b4d35bb603b03559023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>solar</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.183698</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000932</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000091</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>4.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.086723</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000423</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>f2700b2ffcb6b32143a6f95d9cca1721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.096975</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000509</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000053</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>19040cdacdbf038e2f6ad59814f7a9ed</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 3
  },
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": [
    "# parameters for the results_to_csv function\n",
    "\n",
    "file_path: string or Path object\n",
    "\n",
    "scenario_name: Optional string. If not given, all scenarios are included (default).\n",
    "\n",
    "level_names: alternative list of string (level names) to use in the csv file (instead of `level_{i}`). Only used when `flat_hierarchy=False`\n",
    "\n",
    "include_method_units: Optional bool. If True, the units of the method are included in the csv file. (default: True)\n",
    "\n",
    "include_output: Optional bool. If True, the outputs of all nodes are included (unit, magnitude).  (default: True)\n",
    "\n",
    "flat_hierarchy: Optional bool. If True, the hierarchy is flattened, meaning there will only be one column indicating the level of a node.  (default: False)\n",
    "\n",
    "include_extras: Optional bool. If True, the extra information are provided for each, depending on their adapter/aggregator. (default: True)\n",
    "\n",
    "repeat_parent_name: Repeat node name, for all children. Only used when `flat_hierarchy=False`. (default: False)\n",
    "\n",
    "alternative_hierarchy: Optional dict. If given, the hierarchy is replaced by the given hierarchy.\n"
   ],
   "id": "f1cbee59916816e7"
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-29T07:13:15.869379Z",
     "start_time": "2024-04-29T07:13:15.852297Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Flat hierarchy: Just one level columns\n",
    "exp.results_to_csv(csv_file_destination, flat_hierarchy=True, include_output=False)\n",
    "pandas.read_csv(csv_file_destination).fillna(\"\")"
   ],
   "id": "2c2ee9e3396f3187",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "      scenario                                          node_name  level  \\\n",
       "0   scenario 1                                               root      0   \n",
       "1   scenario 1                                               wind      1   \n",
       "2   scenario 1  electricity production, wind, 1-3MW turbine, o...      2   \n",
       "3   scenario 1  electricity production, wind, 1-3MW turbine, o...      2   \n",
       "4   scenario 1                                              solar      1   \n",
       "5   scenario 1  electricity production, solar tower power plan...      2   \n",
       "6   scenario 1  electricity production, solar thermal paraboli...      2   \n",
       "7   scenario 2                                               root      0   \n",
       "8   scenario 2                                               wind      1   \n",
       "9   scenario 2  electricity production, wind, 1-3MW turbine, o...      2   \n",
       "10  scenario 2  electricity production, wind, 1-3MW turbine, o...      2   \n",
       "11  scenario 2                                              solar      1   \n",
       "12  scenario 2  electricity production, solar tower power plan...      2   \n",
       "13  scenario 2  electricity production, solar thermal paraboli...      2   \n",
       "\n",
       "   parent_name results_GWP1000_unit  results_GWP1000_magnitude  \\\n",
       "0                         kg CO2-Eq                   0.163069   \n",
       "1         root            kg CO2-Eq                   0.071220   \n",
       "2         wind            kg CO2-Eq                   0.040728   \n",
       "3         wind            kg CO2-Eq                   0.030492   \n",
       "4         root            kg CO2-Eq                   0.091849   \n",
       "5        solar            kg CO2-Eq                   0.043362   \n",
       "6        solar            kg CO2-Eq                   0.048488   \n",
       "7                         kg CO2-Eq                   0.241342   \n",
       "8         root            kg CO2-Eq                   0.057644   \n",
       "9         wind            kg CO2-Eq                   0.027152   \n",
       "10        wind            kg CO2-Eq                   0.030492   \n",
       "11        root            kg CO2-Eq                   0.183698   \n",
       "12       solar            kg CO2-Eq                   0.086723   \n",
       "13       solar            kg CO2-Eq                   0.096975   \n",
       "\n",
       "   results_WCP_unit  results_WCP_magnitude results_HToxicity_unit  \\\n",
       "0       cubic meter               0.001251          kg 1,4-DCB-Eq   \n",
       "1       cubic meter               0.000785          kg 1,4-DCB-Eq   \n",
       "2       cubic meter               0.000409          kg 1,4-DCB-Eq   \n",
       "3       cubic meter               0.000376          kg 1,4-DCB-Eq   \n",
       "4       cubic meter               0.000466          kg 1,4-DCB-Eq   \n",
       "5       cubic meter               0.000211          kg 1,4-DCB-Eq   \n",
       "6       cubic meter               0.000255          kg 1,4-DCB-Eq   \n",
       "7       cubic meter               0.001581          kg 1,4-DCB-Eq   \n",
       "8       cubic meter               0.000649          kg 1,4-DCB-Eq   \n",
       "9       cubic meter               0.000273          kg 1,4-DCB-Eq   \n",
       "10      cubic meter               0.000376          kg 1,4-DCB-Eq   \n",
       "11      cubic meter               0.000932          kg 1,4-DCB-Eq   \n",
       "12      cubic meter               0.000423          kg 1,4-DCB-Eq   \n",
       "13      cubic meter               0.000509          kg 1,4-DCB-Eq   \n",
       "\n",
       "    results_HToxicity_magnitude                  bw_activity_code  \n",
       "0                      0.000118                                    \n",
       "1                      0.000073                                    \n",
       "2                      0.000039  ed3da88fc23311ee183e9ffd376de89b  \n",
       "3                      0.000034  6ebfe52dc3ef5b4d35bb603b03559023  \n",
       "4                      0.000046                                    \n",
       "5                      0.000019  f2700b2ffcb6b32143a6f95d9cca1721  \n",
       "6                      0.000027  19040cdacdbf038e2f6ad59814f7a9ed  \n",
       "7                      0.000151                                    \n",
       "8                      0.000060                                    \n",
       "9                      0.000026  ed3da88fc23311ee183e9ffd376de89b  \n",
       "10                     0.000034  6ebfe52dc3ef5b4d35bb603b03559023  \n",
       "11                     0.000091                                    \n",
       "12                     0.000038  f2700b2ffcb6b32143a6f95d9cca1721  \n",
       "13                     0.000053  19040cdacdbf038e2f6ad59814f7a9ed  "
      ],
      "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>scenario</th>\n",
       "      <th>node_name</th>\n",
       "      <th>level</th>\n",
       "      <th>parent_name</th>\n",
       "      <th>results_GWP1000_unit</th>\n",
       "      <th>results_GWP1000_magnitude</th>\n",
       "      <th>results_WCP_unit</th>\n",
       "      <th>results_WCP_magnitude</th>\n",
       "      <th>results_HToxicity_unit</th>\n",
       "      <th>results_HToxicity_magnitude</th>\n",
       "      <th>bw_activity_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>root</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.163069</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001251</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000118</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>wind</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.071220</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000785</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000073</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>2</td>\n",
       "      <td>wind</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.040728</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000409</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>ed3da88fc23311ee183e9ffd376de89b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>2</td>\n",
       "      <td>wind</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>6ebfe52dc3ef5b4d35bb603b03559023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>solar</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.091849</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000466</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000046</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>2</td>\n",
       "      <td>solar</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.043362</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000211</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000019</td>\n",
       "      <td>f2700b2ffcb6b32143a6f95d9cca1721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>2</td>\n",
       "      <td>solar</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.048488</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000255</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000027</td>\n",
       "      <td>19040cdacdbf038e2f6ad59814f7a9ed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>root</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.241342</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001581</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000151</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>wind</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.057644</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000649</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000060</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>2</td>\n",
       "      <td>wind</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.027152</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000273</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000026</td>\n",
       "      <td>ed3da88fc23311ee183e9ffd376de89b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>2</td>\n",
       "      <td>wind</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>6ebfe52dc3ef5b4d35bb603b03559023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>solar</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.183698</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000932</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000091</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>2</td>\n",
       "      <td>solar</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.086723</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000423</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>f2700b2ffcb6b32143a6f95d9cca1721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>2</td>\n",
       "      <td>solar</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.096975</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000509</td>\n",
       "      <td>kg 1,4-DCB-Eq</td>\n",
       "      <td>0.000053</td>\n",
       "      <td>19040cdacdbf038e2f6ad59814f7a9ed</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 4
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-29T07:13:17.228266Z",
     "start_time": "2024-04-29T07:13:17.214111Z"
    }
   },
   "cell_type": "code",
   "source": [
    "exp.results_to_csv(\n",
    "    csv_file_destination,\n",
    "    scenarios=\"scenario 2\",\n",
    "    repeat_parent_name=True,\n",
    "    level_names=[\"root\", \"tech\", \"activity\"],\n",
    "    include_method_units=False,\n",
    "    include_extras=False,\n",
    "    include_output=False,\n",
    ")\n",
    "pandas.read_csv(csv_file_destination).fillna(\"\")"
   ],
   "id": "907588964e17e380",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "   level  root   tech                                           activity  \\\n",
       "0      0  root                                                             \n",
       "1      1  root   wind                                                      \n",
       "2      2  root   wind  electricity production, wind, 1-3MW turbine, o...   \n",
       "3      2  root   wind  electricity production, wind, 1-3MW turbine, o...   \n",
       "4      1  root  solar                                                      \n",
       "5      2  root  solar  electricity production, solar tower power plan...   \n",
       "6      2  root  solar  electricity production, solar thermal paraboli...   \n",
       "\n",
       "   results_GWP1000_magnitude  results_WCP_magnitude  \\\n",
       "0                   0.241342               0.001581   \n",
       "1                   0.057644               0.000649   \n",
       "2                   0.027152               0.000273   \n",
       "3                   0.030492               0.000376   \n",
       "4                   0.183698               0.000932   \n",
       "5                   0.086723               0.000423   \n",
       "6                   0.096975               0.000509   \n",
       "\n",
       "   results_HToxicity_magnitude  \n",
       "0                     0.000151  \n",
       "1                     0.000060  \n",
       "2                     0.000026  \n",
       "3                     0.000034  \n",
       "4                     0.000091  \n",
       "5                     0.000038  \n",
       "6                     0.000053  "
      ],
      "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>level</th>\n",
       "      <th>root</th>\n",
       "      <th>tech</th>\n",
       "      <th>activity</th>\n",
       "      <th>results_GWP1000_magnitude</th>\n",
       "      <th>results_WCP_magnitude</th>\n",
       "      <th>results_HToxicity_magnitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>root</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0.241342</td>\n",
       "      <td>0.001581</td>\n",
       "      <td>0.000151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>wind</td>\n",
       "      <td></td>\n",
       "      <td>0.057644</td>\n",
       "      <td>0.000649</td>\n",
       "      <td>0.000060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>root</td>\n",
       "      <td>wind</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>0.027152</td>\n",
       "      <td>0.000273</td>\n",
       "      <td>0.000026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>root</td>\n",
       "      <td>wind</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>0.000034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>solar</td>\n",
       "      <td></td>\n",
       "      <td>0.183698</td>\n",
       "      <td>0.000932</td>\n",
       "      <td>0.000091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>root</td>\n",
       "      <td>solar</td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>0.086723</td>\n",
       "      <td>0.000423</td>\n",
       "      <td>0.000038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>root</td>\n",
       "      <td>solar</td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>0.096975</td>\n",
       "      <td>0.000509</td>\n",
       "      <td>0.000053</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 5
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-24T09:58:43.102781Z",
     "start_time": "2024-04-24T09:58:43.096769Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# let's try with a different hierarchy (a trivial one)\n",
    "# first, let's get the snames of the structural nodes:\n",
    "exp.structural_nodes_names"
   ],
   "id": "3ecdb33d023572af",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['electricity production, wind, 1-3MW turbine, onshore',\n",
       " 'electricity production, wind, 1-3MW turbine, offshore',\n",
       " 'electricity production, solar tower power plant, 20 MW',\n",
       " 'electricity production, solar thermal parabolic trough, 50 MW']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 6
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-24T10:00:40.083622Z",
     "start_time": "2024-04-24T10:00:40.075454Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# construct a new hierarchy. Note that we only need the names to refer to the structural nodes, no configuration!\n",
    "alt_hierarchy = {\n",
    "    \"name\": \"root\",\n",
    "    \"agregator\": \"sum\",\n",
    "    \"children\": [{\"name\": node} for node in exp.structural_nodes_names],\n",
    "}\n",
    "alt_hierarchy"
   ],
   "id": "edfb094c52e97554",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'root',\n",
       " 'agregator': 'sum',\n",
       " 'children': [{'name': 'electricity production, wind, 1-3MW turbine, onshore'},\n",
       "  {'name': 'electricity production, wind, 1-3MW turbine, offshore'},\n",
       "  {'name': 'electricity production, solar tower power plant, 20 MW'},\n",
       "  {'name': 'electricity production, solar thermal parabolic trough, 50 MW'}]}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 10
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-04-24T10:02:06.880182Z",
     "start_time": "2024-04-24T10:02:06.859638Z"
    }
   },
   "cell_type": "code",
   "source": [
    "exp.results_to_csv(\n",
    "    csv_file_destination, flat_hierarchy=True, alternative_hierarchy=alt_hierarchy\n",
    ")\n",
    "pandas.read_csv(csv_file_destination).fillna(\"\")"
   ],
   "id": "e42642e381f13e86",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "     scenario                                          node_name  level  \\\n",
       "0  scenario 1                                               root      0   \n",
       "1  scenario 1  electricity production, wind, 1-3MW turbine, o...      1   \n",
       "2  scenario 1  electricity production, wind, 1-3MW turbine, o...      1   \n",
       "3  scenario 1  electricity production, solar tower power plan...      1   \n",
       "4  scenario 1  electricity production, solar thermal paraboli...      1   \n",
       "5  scenario 2                                               root      0   \n",
       "6  scenario 2  electricity production, wind, 1-3MW turbine, o...      1   \n",
       "7  scenario 2  electricity production, wind, 1-3MW turbine, o...      1   \n",
       "8  scenario 2  electricity production, solar tower power plan...      1   \n",
       "9  scenario 2  electricity production, solar thermal paraboli...      1   \n",
       "\n",
       "  parent_name results_GWP1000_unit  results_GWP1000_magnitude  \\\n",
       "0                        kg CO2-Eq                   0.163069   \n",
       "1        root            kg CO2-Eq                   0.040728   \n",
       "2        root            kg CO2-Eq                   0.030492   \n",
       "3        root            kg CO2-Eq                   0.043362   \n",
       "4        root            kg CO2-Eq                   0.048488   \n",
       "5                        kg CO2-Eq                   0.241342   \n",
       "6        root            kg CO2-Eq                   0.027152   \n",
       "7        root            kg CO2-Eq                   0.030492   \n",
       "8        root            kg CO2-Eq                   0.086723   \n",
       "9        root            kg CO2-Eq                   0.096975   \n",
       "\n",
       "  results_WCP_unit  results_WCP_magnitude  output_0_unit  output_0_magnitude  \\\n",
       "0      cubic meter               0.001251  kilowatt_hour                 7.0   \n",
       "1      cubic meter               0.000409  kilowatt_hour                 3.0   \n",
       "2      cubic meter               0.000376  kilowatt_hour                 2.0   \n",
       "3      cubic meter               0.000211  kilowatt_hour                 1.0   \n",
       "4      cubic meter               0.000255  kilowatt_hour                 1.0   \n",
       "5      cubic meter               0.001581  kilowatt_hour                 8.0   \n",
       "6      cubic meter               0.000273  kilowatt_hour                 2.0   \n",
       "7      cubic meter               0.000376  kilowatt_hour                 2.0   \n",
       "8      cubic meter               0.000423  kilowatt_hour                 2.0   \n",
       "9      cubic meter               0.000509  kilowatt_hour                 2.0   \n",
       "\n",
       "  output_0_label  \n",
       "0                 \n",
       "1                 \n",
       "2                 \n",
       "3                 \n",
       "4                 \n",
       "5                 \n",
       "6                 \n",
       "7                 \n",
       "8                 \n",
       "9                 "
      ],
      "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>scenario</th>\n",
       "      <th>node_name</th>\n",
       "      <th>level</th>\n",
       "      <th>parent_name</th>\n",
       "      <th>results_GWP1000_unit</th>\n",
       "      <th>results_GWP1000_magnitude</th>\n",
       "      <th>results_WCP_unit</th>\n",
       "      <th>results_WCP_magnitude</th>\n",
       "      <th>output_0_unit</th>\n",
       "      <th>output_0_magnitude</th>\n",
       "      <th>output_0_label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>root</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.163069</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001251</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>7.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.040728</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000409</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>3.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.043362</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000211</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>scenario 1</td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.048488</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000255</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>root</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.241342</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.001581</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>8.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.027152</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000273</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, wind, 1-3MW turbine, o...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.030492</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000376</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, solar tower power plan...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.086723</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000423</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>scenario 2</td>\n",
       "      <td>electricity production, solar thermal paraboli...</td>\n",
       "      <td>1</td>\n",
       "      <td>root</td>\n",
       "      <td>kg CO2-Eq</td>\n",
       "      <td>0.096975</td>\n",
       "      <td>cubic meter</td>\n",
       "      <td>0.000509</td>\n",
       "      <td>kilowatt_hour</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 14
  },
  {
   "metadata": {},
   "cell_type": "code",
   "outputs": [],
   "execution_count": null,
   "source": "",
   "id": "788650350f98927e"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}