{ "cells": [ { "attachments": {}, "cell_type": "markdown", "id": "8096b98a", "metadata": {}, "source": [ "Here we are giving a brief introduction in working with IAMC-styled data with pandas and pandas-indexing." ] }, { "cell_type": "code", "execution_count": 1, "id": "bee121f7", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "attachments": {}, "cell_type": "markdown", "id": "814f4bb8-be13-47cd-9853-eb23f61a1da3", "metadata": {}, "source": [ "# Test data set\n", "\n", "For experimenting and easy testing `pandas-indexing` brings along the power sector generation and capacity of the HighRE illustrative modelling pathway from the IPCC AR6 scenario database in IAMC format." ] }, { "cell_type": "code", "execution_count": 2, "id": "48012a50-1881-4c41-abad-4062828331a5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionvariableunit
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldCapacity|Electricity|BiomassGW42.984362.471785.6698108.8834128.5653137.8452132.8316122.7382106.377286.026565.654845.759114.50473.96280.81980.2150
Capacity|Electricity|CoalGW1238.87661525.94971876.59542075.23211225.4509182.01491.35321.07290.77630.50290.31110.18360.07830.09180.09650.0866
Capacity|Electricity|GasGW1096.67361343.10771603.16861852.64851761.80571584.40331423.53931289.4777863.8716562.8482393.7209349.9091306.3883213.597052.60450.2717
Capacity|Electricity|GeothermalGW8.112912.998524.161246.657370.646983.450684.489382.968879.145269.662858.202148.400739.279533.479327.653026.0198
Capacity|Electricity|HydroGW806.5684963.35231239.61741500.45081669.35651786.04681858.78211902.63471925.65351933.51991931.10961922.56891893.64101860.86111846.10201805.1398
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 42.9843 \n", " Capacity|Electricity|Coal GW 1238.8766 \n", " Capacity|Electricity|Gas GW 1096.6736 \n", " Capacity|Electricity|Geothermal GW 8.1129 \n", " Capacity|Electricity|Hydro GW 806.5684 \n", "\n", " 2010 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 62.4717 \n", " Capacity|Electricity|Coal GW 1525.9497 \n", " Capacity|Electricity|Gas GW 1343.1077 \n", " Capacity|Electricity|Geothermal GW 12.9985 \n", " Capacity|Electricity|Hydro GW 963.3523 \n", "\n", " 2015 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 85.6698 \n", " Capacity|Electricity|Coal GW 1876.5954 \n", " Capacity|Electricity|Gas GW 1603.1686 \n", " Capacity|Electricity|Geothermal GW 24.1612 \n", " Capacity|Electricity|Hydro GW 1239.6174 \n", "\n", " 2020 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 108.8834 \n", " Capacity|Electricity|Coal GW 2075.2321 \n", " Capacity|Electricity|Gas GW 1852.6485 \n", " Capacity|Electricity|Geothermal GW 46.6573 \n", " Capacity|Electricity|Hydro GW 1500.4508 \n", "\n", " 2025 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 128.5653 \n", " Capacity|Electricity|Coal GW 1225.4509 \n", " Capacity|Electricity|Gas GW 1761.8057 \n", " Capacity|Electricity|Geothermal GW 70.6469 \n", " Capacity|Electricity|Hydro GW 1669.3565 \n", "\n", " 2030 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 137.8452 \n", " Capacity|Electricity|Coal GW 182.0149 \n", " Capacity|Electricity|Gas GW 1584.4033 \n", " Capacity|Electricity|Geothermal GW 83.4506 \n", " Capacity|Electricity|Hydro GW 1786.0468 \n", "\n", " 2035 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 132.8316 \n", " Capacity|Electricity|Coal GW 1.3532 \n", " Capacity|Electricity|Gas GW 1423.5393 \n", " Capacity|Electricity|Geothermal GW 84.4893 \n", " Capacity|Electricity|Hydro GW 1858.7821 \n", "\n", " 2040 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 122.7382 \n", " Capacity|Electricity|Coal GW 1.0729 \n", " Capacity|Electricity|Gas GW 1289.4777 \n", " Capacity|Electricity|Geothermal GW 82.9688 \n", " Capacity|Electricity|Hydro GW 1902.6347 \n", "\n", " 2045 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 106.3772 \n", " Capacity|Electricity|Coal GW 0.7763 \n", " Capacity|Electricity|Gas GW 863.8716 \n", " Capacity|Electricity|Geothermal GW 79.1452 \n", " Capacity|Electricity|Hydro GW 1925.6535 \n", "\n", " 2050 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 86.0265 \n", " Capacity|Electricity|Coal GW 0.5029 \n", " Capacity|Electricity|Gas GW 562.8482 \n", " Capacity|Electricity|Geothermal GW 69.6628 \n", " Capacity|Electricity|Hydro GW 1933.5199 \n", "\n", " 2055 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 65.6548 \n", " Capacity|Electricity|Coal GW 0.3111 \n", " Capacity|Electricity|Gas GW 393.7209 \n", " Capacity|Electricity|Geothermal GW 58.2021 \n", " Capacity|Electricity|Hydro GW 1931.1096 \n", "\n", " 2060 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 45.7591 \n", " Capacity|Electricity|Coal GW 0.1836 \n", " Capacity|Electricity|Gas GW 349.9091 \n", " Capacity|Electricity|Geothermal GW 48.4007 \n", " Capacity|Electricity|Hydro GW 1922.5689 \n", "\n", " 2070 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 14.5047 \n", " Capacity|Electricity|Coal GW 0.0783 \n", " Capacity|Electricity|Gas GW 306.3883 \n", " Capacity|Electricity|Geothermal GW 39.2795 \n", " Capacity|Electricity|Hydro GW 1893.6410 \n", "\n", " 2080 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 3.9628 \n", " Capacity|Electricity|Coal GW 0.0918 \n", " Capacity|Electricity|Gas GW 213.5970 \n", " Capacity|Electricity|Geothermal GW 33.4793 \n", " Capacity|Electricity|Hydro GW 1860.8611 \n", "\n", " 2090 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 0.8198 \n", " Capacity|Electricity|Coal GW 0.0965 \n", " Capacity|Electricity|Gas GW 52.6045 \n", " Capacity|Electricity|Geothermal GW 27.6530 \n", " Capacity|Electricity|Hydro GW 1846.1020 \n", "\n", " 2100 \n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 0.2150 \n", " Capacity|Electricity|Coal GW 0.0866 \n", " Capacity|Electricity|Gas GW 0.2717 \n", " Capacity|Electricity|Geothermal GW 26.0198 \n", " Capacity|Electricity|Hydro GW 1805.1398 " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing.datasets import remindhighre_power\n", "\n", "\n", "df = remindhighre_power()\n", "df.head()" ] }, { "attachments": {}, "cell_type": "markdown", "id": "0d61c065", "metadata": {}, "source": [ "# Usage styles\n", "\n", "`pandas-indexing` defines two different usage styles:\n", "\n", "1. functions that can be imported from the toplevel module, like\n", " \n", " ```python\n", " from pandas_indexing import assignlevel\n", " assignlevel(df, unit=\"Mt CO2e/yr\")\n", " ```\n", "2. convenience accessors that are hooking into pandas as extensions, like\n", " \n", " ```python\n", " df.pix.assign(unit=\"Mt CO2e/yr)\n", " ```\n", "\n", "Most of the functionality is available with both styles under slightly different names. I'll present the functional style here first (and add the alternative as comments)" ] }, { "cell_type": "code", "execution_count": 3, "id": "e7586672", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Index:\n", " * model : REMIND-MAgPIE 2.1-4.3 (1)\n", " * scenario : DeepElec_SSP2_HighRE_Budg900 (1)\n", " * region : World (1)\n", " * variable : Capacity|Electricity|Biomass, ... (20)\n", " * unit : GW, GWh/yr (2)\n", "\n", "Columns:\n", " * : 2005, 2010, 2015, 2020, 2025, 2030, 2035, 2040, ... 2100 (16)\n" ] } ], "source": [ "from pandas_indexing.core import describelevel\n", "\n", "\n", "describelevel(df) # or: df.pix" ] }, { "cell_type": "code", "execution_count": 4, "id": "a4f23678", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index:\n", " * model : REMIND-MAgPIE 2.1-4.3 (1)\n", " * scenario : DeepElec_SSP2_HighRE_Budg900 (1)\n", " * region : World (1)\n", " * variable : Capacity|Electricity|Biomass, ... (20)\n", " * unit : GW, GWh/yr (2)\n", "\n", "Columns:\n", " * : 2005, 2010, 2015, 2020, 2025, 2030, 2035, 2040, ... 2100 (16)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.pix" ] }, { "attachments": {}, "cell_type": "markdown", "id": "5b948e75", "metadata": {}, "source": [ "As one can see the IAMC format is defined by five index levels: `model`, `scenario`, `variable`, `unit` and `region`. In this data subset, we have a single `model`, `scenario` combination for one `region` and with several capacity `variable`s starting with `Capacity|Electricity|` and generation variables starting with `Secondary Energy|Electricity|`.\n", "\n", "The data comes with two different units: `GW` and `GWh/yr`, (hopefully) for capacity and generation, respectively." ] }, { "attachments": {}, "cell_type": "markdown", "id": "61d70ee2", "metadata": {}, "source": [ "# Selecting data\n", "\n", "For using pandas indexes effectively for computations, it makes sense to split the hierarchically variable index out into separate python variables: `generation` and `capacity`. The standard pandas tools for this job are `pd.DataFrame.loc` in conjunction with `pd.IndexSlice` or `pd.DataFrame.query`. \n", "\n", "`pandas_indexing` brings `ismatch` and `isin` to make this job as easy as possible." ] }, { "cell_type": "code", "execution_count": 5, "id": "36d58553", "metadata": {}, "outputs": [], "source": [ "from pandas_indexing import isin, ismatch # no .idx equivalents" ] }, { "cell_type": "code", "execution_count": 6, "id": "982b9663", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region variable unit\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity|Electricity|Biomass GW 137.8452\n", " Capacity|Electricity|Coal GW 182.0149\n", " Capacity|Electricity|Gas GW 1584.4033\n", " Capacity|Electricity|Geothermal GW 83.4506\n", " Capacity|Electricity|Hydro GW 1786.0468\n", " Capacity|Electricity|Nuclear GW 275.5920\n", " Capacity|Electricity|Oil GW 90.2329\n", " Capacity|Electricity|Other GW 469.5231\n", " Capacity|Electricity|Solar GW 11094.4847\n", " Capacity|Electricity|Wind GW 3522.8061\n", "Name: 2030, dtype: float64" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.loc[ismatch(variable=\"Capacity|**\"), 2030]" ] }, { "attachments": {}, "cell_type": "markdown", "id": "5f0dfdd8", "metadata": {}, "source": [ "`ismatch` allows using a glob-like pattern to subset into one or multiple named levels, together with the standard `rename` method we can get cleaned up capacity and generation data easily:" ] }, { "cell_type": "code", "execution_count": 7, "id": "711f2683", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionvariableunit
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldBiomassGWh/yr2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
CoalGWh/yr7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
GasGWh/yr3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
GeothermalGWh/yr6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
HydroGWh/yr2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
NuclearGWh/yr2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
OilGWh/yr1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
OtherGWh/yr0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
SolarGWh/yr4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
WindGWh/yr1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 2.352778e+05 \n", " Coal GWh/yr 7.419778e+06 \n", " Gas GWh/yr 3.816028e+06 \n", " Geothermal GWh/yr 6.041667e+04 \n", " Hydro GWh/yr 2.976944e+06 \n", " Nuclear GWh/yr 2.861861e+06 \n", " Oil GWh/yr 1.088861e+06 \n", " Other GWh/yr 0.000000e+00 \n", " Solar GWh/yr 4.083333e+03 \n", " Wind GWh/yr 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 3.407222e+05 \n", " Coal GWh/yr 8.252667e+06 \n", " Gas GWh/yr 5.050500e+06 \n", " Geothermal GWh/yr 9.677778e+04 \n", " Hydro GWh/yr 3.557028e+06 \n", " Nuclear GWh/yr 2.642750e+06 \n", " Oil GWh/yr 1.016972e+06 \n", " Other GWh/yr 0.000000e+00 \n", " Solar GWh/yr 8.325000e+04 \n", " Wind GWh/yr 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 4.669444e+05 \n", " Coal GWh/yr 9.246333e+06 \n", " Gas GWh/yr 5.968778e+06 \n", " Geothermal GWh/yr 1.799167e+05 \n", " Hydro GWh/yr 4.386694e+06 \n", " Nuclear GWh/yr 2.448556e+06 \n", " Oil GWh/yr 8.353889e+05 \n", " Other GWh/yr 4.444444e+02 \n", " Solar GWh/yr 2.616111e+05 \n", " Wind GWh/yr 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 5.942778e+05 \n", " Coal GWh/yr 1.075747e+07 \n", " Gas GWh/yr 7.060083e+06 \n", " Geothermal GWh/yr 3.474167e+05 \n", " Hydro GWh/yr 5.302056e+06 \n", " Nuclear GWh/yr 2.214167e+06 \n", " Oil GWh/yr 6.174167e+05 \n", " Other GWh/yr 2.166667e+03 \n", " Solar GWh/yr 9.263611e+05 \n", " Wind GWh/yr 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 7.219167e+05 \n", " Coal GWh/yr 6.045972e+06 \n", " Gas GWh/yr 6.469250e+06 \n", " Geothermal GWh/yr 5.260278e+05 \n", " Hydro GWh/yr 5.813167e+06 \n", " Nuclear GWh/yr 2.055667e+06 \n", " Oil GWh/yr 4.317778e+05 \n", " Other GWh/yr 8.913889e+04 \n", " Solar GWh/yr 5.500722e+06 \n", " Wind GWh/yr 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 8.496389e+05 \n", " Coal GWh/yr 8.733611e+05 \n", " Gas GWh/yr 4.551528e+06 \n", " Geothermal GWh/yr 6.213611e+05 \n", " Hydro GWh/yr 6.173778e+06 \n", " Nuclear GWh/yr 1.876222e+06 \n", " Oil GWh/yr 1.960556e+05 \n", " Other GWh/yr 4.938889e+05 \n", " Solar GWh/yr 1.566242e+07 \n", " Wind GWh/yr 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 9.855833e+05 \n", " Coal GWh/yr 6.444444e+03 \n", " Gas GWh/yr 2.907250e+06 \n", " Geothermal GWh/yr 6.291111e+05 \n", " Hydro GWh/yr 6.423194e+06 \n", " Nuclear GWh/yr 1.617278e+06 \n", " Oil GWh/yr 6.919444e+04 \n", " Other GWh/yr 1.204583e+06 \n", " Solar GWh/yr 2.575731e+07 \n", " Wind GWh/yr 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.173833e+06 \n", " Coal GWh/yr 5.027778e+03 \n", " Gas GWh/yr 2.602278e+06 \n", " Geothermal GWh/yr 6.177778e+05 \n", " Hydro GWh/yr 6.604167e+06 \n", " Nuclear GWh/yr 1.502778e+06 \n", " Oil GWh/yr 4.797222e+04 \n", " Other GWh/yr 1.985111e+06 \n", " Solar GWh/yr 3.404253e+07 \n", " Wind GWh/yr 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.359639e+06 \n", " Coal GWh/yr 3.694444e+03 \n", " Gas GWh/yr 1.752056e+06 \n", " Geothermal GWh/yr 5.893056e+05 \n", " Hydro GWh/yr 6.717417e+06 \n", " Nuclear GWh/yr 1.304083e+06 \n", " Oil GWh/yr 3.175000e+04 \n", " Other GWh/yr 2.790639e+06 \n", " Solar GWh/yr 4.088394e+07 \n", " Wind GWh/yr 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.471139e+06 \n", " Coal GWh/yr 2.416667e+03 \n", " Gas GWh/yr 1.218361e+06 \n", " Geothermal GWh/yr 5.187222e+05 \n", " Hydro GWh/yr 6.770250e+06 \n", " Nuclear GWh/yr 1.098694e+06 \n", " Oil GWh/yr 1.169444e+04 \n", " Other GWh/yr 3.488083e+06 \n", " Solar GWh/yr 4.723214e+07 \n", " Wind GWh/yr 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.513056e+06 \n", " Coal GWh/yr 1.555556e+03 \n", " Gas GWh/yr 6.538889e+05 \n", " Geothermal GWh/yr 4.333611e+05 \n", " Hydro GWh/yr 6.782028e+06 \n", " Nuclear GWh/yr 8.686111e+05 \n", " Oil GWh/yr 6.722222e+03 \n", " Other GWh/yr 4.020806e+06 \n", " Solar GWh/yr 5.327061e+07 \n", " Wind GWh/yr 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.544750e+06 \n", " Coal GWh/yr 9.444444e+02 \n", " Gas GWh/yr 5.281944e+05 \n", " Geothermal GWh/yr 3.603889e+05 \n", " Hydro GWh/yr 6.775917e+06 \n", " Nuclear GWh/yr 6.451944e+05 \n", " Oil GWh/yr 2.777778e+01 \n", " Other GWh/yr 4.434639e+06 \n", " Solar GWh/yr 5.819236e+07 \n", " Wind GWh/yr 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.564583e+06 \n", " Coal GWh/yr 4.444444e+02 \n", " Gas GWh/yr 2.423333e+05 \n", " Geothermal GWh/yr 2.924722e+05 \n", " Hydro GWh/yr 6.722667e+06 \n", " Nuclear GWh/yr 2.717500e+05 \n", " Oil GWh/yr 2.777778e+01 \n", " Other GWh/yr 5.261472e+06 \n", " Solar GWh/yr 6.826367e+07 \n", " Wind GWh/yr 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.557556e+06 \n", " Coal GWh/yr 5.277778e+02 \n", " Gas GWh/yr 1.685833e+05 \n", " Geothermal GWh/yr 2.492778e+05 \n", " Hydro GWh/yr 6.655833e+06 \n", " Nuclear GWh/yr 5.925000e+04 \n", " Oil GWh/yr 2.777778e+01 \n", " Other GWh/yr 6.099583e+06 \n", " Solar GWh/yr 7.754106e+07 \n", " Wind GWh/yr 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.543056e+06 \n", " Coal GWh/yr 5.555556e+02 \n", " Gas GWh/yr 4.166667e+04 \n", " Geothermal GWh/yr 2.059167e+05 \n", " Hydro GWh/yr 6.631806e+06 \n", " Nuclear GWh/yr 3.916667e+03 \n", " Oil GWh/yr 2.777778e+01 \n", " Other GWh/yr 6.740833e+06 \n", " Solar GWh/yr 8.359456e+07 \n", " Wind GWh/yr 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Biomass GWh/yr 1.574306e+06 \n", " Coal GWh/yr 5.000000e+02 \n", " Gas GWh/yr 3.888889e+02 \n", " Geothermal GWh/yr 1.937500e+05 \n", " Hydro GWh/yr 6.533167e+06 \n", " Nuclear GWh/yr 1.388889e+02 \n", " Oil GWh/yr 2.777778e+01 \n", " Other GWh/yr 7.547194e+06 \n", " Solar GWh/yr 9.270394e+07 \n", " Wind GWh/yr 4.123369e+07 " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "generation = df.loc[ismatch(variable=\"Secondary Energy|**\")].rename(\n", " index=lambda s: s.removeprefix(\"Secondary Energy|Electricity|\")\n", ")\n", "generation" ] }, { "attachments": {}, "cell_type": "markdown", "id": "3087eb3c", "metadata": {}, "source": [ "Since this extraction of data is relatively common, `extractlevel` simplifies this by matching against a format-like template string:" ] }, { "cell_type": "code", "execution_count": 8, "id": "16032dd2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionunitcarrierfuel
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldGWh/yrElectricityBiomass2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
Coal7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
Gas3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
Geothermal6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
Hydro2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
Nuclear2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
Oil1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
Other0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
Solar4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
Wind1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 2.352778e+05 \n", " Coal 7.419778e+06 \n", " Gas 3.816028e+06 \n", " Geothermal 6.041667e+04 \n", " Hydro 2.976944e+06 \n", " Nuclear 2.861861e+06 \n", " Oil 1.088861e+06 \n", " Other 0.000000e+00 \n", " Solar 4.083333e+03 \n", " Wind 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 3.407222e+05 \n", " Coal 8.252667e+06 \n", " Gas 5.050500e+06 \n", " Geothermal 9.677778e+04 \n", " Hydro 3.557028e+06 \n", " Nuclear 2.642750e+06 \n", " Oil 1.016972e+06 \n", " Other 0.000000e+00 \n", " Solar 8.325000e+04 \n", " Wind 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 4.669444e+05 \n", " Coal 9.246333e+06 \n", " Gas 5.968778e+06 \n", " Geothermal 1.799167e+05 \n", " Hydro 4.386694e+06 \n", " Nuclear 2.448556e+06 \n", " Oil 8.353889e+05 \n", " Other 4.444444e+02 \n", " Solar 2.616111e+05 \n", " Wind 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 5.942778e+05 \n", " Coal 1.075747e+07 \n", " Gas 7.060083e+06 \n", " Geothermal 3.474167e+05 \n", " Hydro 5.302056e+06 \n", " Nuclear 2.214167e+06 \n", " Oil 6.174167e+05 \n", " Other 2.166667e+03 \n", " Solar 9.263611e+05 \n", " Wind 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 7.219167e+05 \n", " Coal 6.045972e+06 \n", " Gas 6.469250e+06 \n", " Geothermal 5.260278e+05 \n", " Hydro 5.813167e+06 \n", " Nuclear 2.055667e+06 \n", " Oil 4.317778e+05 \n", " Other 8.913889e+04 \n", " Solar 5.500722e+06 \n", " Wind 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 8.496389e+05 \n", " Coal 8.733611e+05 \n", " Gas 4.551528e+06 \n", " Geothermal 6.213611e+05 \n", " Hydro 6.173778e+06 \n", " Nuclear 1.876222e+06 \n", " Oil 1.960556e+05 \n", " Other 4.938889e+05 \n", " Solar 1.566242e+07 \n", " Wind 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 9.855833e+05 \n", " Coal 6.444444e+03 \n", " Gas 2.907250e+06 \n", " Geothermal 6.291111e+05 \n", " Hydro 6.423194e+06 \n", " Nuclear 1.617278e+06 \n", " Oil 6.919444e+04 \n", " Other 1.204583e+06 \n", " Solar 2.575731e+07 \n", " Wind 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.173833e+06 \n", " Coal 5.027778e+03 \n", " Gas 2.602278e+06 \n", " Geothermal 6.177778e+05 \n", " Hydro 6.604167e+06 \n", " Nuclear 1.502778e+06 \n", " Oil 4.797222e+04 \n", " Other 1.985111e+06 \n", " Solar 3.404253e+07 \n", " Wind 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.359639e+06 \n", " Coal 3.694444e+03 \n", " Gas 1.752056e+06 \n", " Geothermal 5.893056e+05 \n", " Hydro 6.717417e+06 \n", " Nuclear 1.304083e+06 \n", " Oil 3.175000e+04 \n", " Other 2.790639e+06 \n", " Solar 4.088394e+07 \n", " Wind 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.471139e+06 \n", " Coal 2.416667e+03 \n", " Gas 1.218361e+06 \n", " Geothermal 5.187222e+05 \n", " Hydro 6.770250e+06 \n", " Nuclear 1.098694e+06 \n", " Oil 1.169444e+04 \n", " Other 3.488083e+06 \n", " Solar 4.723214e+07 \n", " Wind 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.513056e+06 \n", " Coal 1.555556e+03 \n", " Gas 6.538889e+05 \n", " Geothermal 4.333611e+05 \n", " Hydro 6.782028e+06 \n", " Nuclear 8.686111e+05 \n", " Oil 6.722222e+03 \n", " Other 4.020806e+06 \n", " Solar 5.327061e+07 \n", " Wind 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.544750e+06 \n", " Coal 9.444444e+02 \n", " Gas 5.281944e+05 \n", " Geothermal 3.603889e+05 \n", " Hydro 6.775917e+06 \n", " Nuclear 6.451944e+05 \n", " Oil 2.777778e+01 \n", " Other 4.434639e+06 \n", " Solar 5.819236e+07 \n", " Wind 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.564583e+06 \n", " Coal 4.444444e+02 \n", " Gas 2.423333e+05 \n", " Geothermal 2.924722e+05 \n", " Hydro 6.722667e+06 \n", " Nuclear 2.717500e+05 \n", " Oil 2.777778e+01 \n", " Other 5.261472e+06 \n", " Solar 6.826367e+07 \n", " Wind 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.557556e+06 \n", " Coal 5.277778e+02 \n", " Gas 1.685833e+05 \n", " Geothermal 2.492778e+05 \n", " Hydro 6.655833e+06 \n", " Nuclear 5.925000e+04 \n", " Oil 2.777778e+01 \n", " Other 6.099583e+06 \n", " Solar 7.754106e+07 \n", " Wind 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.543056e+06 \n", " Coal 5.555556e+02 \n", " Gas 4.166667e+04 \n", " Geothermal 2.059167e+05 \n", " Hydro 6.631806e+06 \n", " Nuclear 3.916667e+03 \n", " Oil 2.777778e+01 \n", " Other 6.740833e+06 \n", " Solar 8.359456e+07 \n", " Wind 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Electricity Biomass 1.574306e+06 \n", " Coal 5.000000e+02 \n", " Gas 3.888889e+02 \n", " Geothermal 1.937500e+05 \n", " Hydro 6.533167e+06 \n", " Nuclear 1.388889e+02 \n", " Oil 2.777778e+01 \n", " Other 7.547194e+06 \n", " Solar 9.270394e+07 \n", " Wind 4.123369e+07 " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import extractlevel, formatlevel\n", "\n", "\n", "generation = extractlevel(df, variable=\"Secondary Energy|{carrier}|{fuel}\", drop=True)\n", "capacity = extractlevel(df, variable=\"Capacity|{carrier}|{fuel}\", drop=True)\n", "# or: df.pix.extract(variable=\"Secondary Energy|{carrier}|{fuel}\")\n", "generation" ] }, { "attachments": {}, "cell_type": "markdown", "id": "405720c7", "metadata": {}, "source": [ "The inverse operation is to combine strings back together with `formatlevel`:" ] }, { "cell_type": "code", "execution_count": 9, "id": "8e355684", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionunitvariable
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldGWh/yrSecondary Energy|Electricity|Biomass2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
Secondary Energy|Electricity|Coal7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
Secondary Energy|Electricity|Gas3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
Secondary Energy|Electricity|Geothermal6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
Secondary Energy|Electricity|Hydro2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
Secondary Energy|Electricity|Nuclear2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
Secondary Energy|Electricity|Oil1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
Secondary Energy|Electricity|Other0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
Secondary Energy|Electricity|Solar4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
Secondary Energy|Electricity|Wind1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 2.352778e+05 \n", " Secondary Energy|Electricity|Coal 7.419778e+06 \n", " Secondary Energy|Electricity|Gas 3.816028e+06 \n", " Secondary Energy|Electricity|Geothermal 6.041667e+04 \n", " Secondary Energy|Electricity|Hydro 2.976944e+06 \n", " Secondary Energy|Electricity|Nuclear 2.861861e+06 \n", " Secondary Energy|Electricity|Oil 1.088861e+06 \n", " Secondary Energy|Electricity|Other 0.000000e+00 \n", " Secondary Energy|Electricity|Solar 4.083333e+03 \n", " Secondary Energy|Electricity|Wind 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 3.407222e+05 \n", " Secondary Energy|Electricity|Coal 8.252667e+06 \n", " Secondary Energy|Electricity|Gas 5.050500e+06 \n", " Secondary Energy|Electricity|Geothermal 9.677778e+04 \n", " Secondary Energy|Electricity|Hydro 3.557028e+06 \n", " Secondary Energy|Electricity|Nuclear 2.642750e+06 \n", " Secondary Energy|Electricity|Oil 1.016972e+06 \n", " Secondary Energy|Electricity|Other 0.000000e+00 \n", " Secondary Energy|Electricity|Solar 8.325000e+04 \n", " Secondary Energy|Electricity|Wind 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 4.669444e+05 \n", " Secondary Energy|Electricity|Coal 9.246333e+06 \n", " Secondary Energy|Electricity|Gas 5.968778e+06 \n", " Secondary Energy|Electricity|Geothermal 1.799167e+05 \n", " Secondary Energy|Electricity|Hydro 4.386694e+06 \n", " Secondary Energy|Electricity|Nuclear 2.448556e+06 \n", " Secondary Energy|Electricity|Oil 8.353889e+05 \n", " Secondary Energy|Electricity|Other 4.444444e+02 \n", " Secondary Energy|Electricity|Solar 2.616111e+05 \n", " Secondary Energy|Electricity|Wind 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 5.942778e+05 \n", " Secondary Energy|Electricity|Coal 1.075747e+07 \n", " Secondary Energy|Electricity|Gas 7.060083e+06 \n", " Secondary Energy|Electricity|Geothermal 3.474167e+05 \n", " Secondary Energy|Electricity|Hydro 5.302056e+06 \n", " Secondary Energy|Electricity|Nuclear 2.214167e+06 \n", " Secondary Energy|Electricity|Oil 6.174167e+05 \n", " Secondary Energy|Electricity|Other 2.166667e+03 \n", " Secondary Energy|Electricity|Solar 9.263611e+05 \n", " Secondary Energy|Electricity|Wind 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 7.219167e+05 \n", " Secondary Energy|Electricity|Coal 6.045972e+06 \n", " Secondary Energy|Electricity|Gas 6.469250e+06 \n", " Secondary Energy|Electricity|Geothermal 5.260278e+05 \n", " Secondary Energy|Electricity|Hydro 5.813167e+06 \n", " Secondary Energy|Electricity|Nuclear 2.055667e+06 \n", " Secondary Energy|Electricity|Oil 4.317778e+05 \n", " Secondary Energy|Electricity|Other 8.913889e+04 \n", " Secondary Energy|Electricity|Solar 5.500722e+06 \n", " Secondary Energy|Electricity|Wind 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 8.496389e+05 \n", " Secondary Energy|Electricity|Coal 8.733611e+05 \n", " Secondary Energy|Electricity|Gas 4.551528e+06 \n", " Secondary Energy|Electricity|Geothermal 6.213611e+05 \n", " Secondary Energy|Electricity|Hydro 6.173778e+06 \n", " Secondary Energy|Electricity|Nuclear 1.876222e+06 \n", " Secondary Energy|Electricity|Oil 1.960556e+05 \n", " Secondary Energy|Electricity|Other 4.938889e+05 \n", " Secondary Energy|Electricity|Solar 1.566242e+07 \n", " Secondary Energy|Electricity|Wind 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 9.855833e+05 \n", " Secondary Energy|Electricity|Coal 6.444444e+03 \n", " Secondary Energy|Electricity|Gas 2.907250e+06 \n", " Secondary Energy|Electricity|Geothermal 6.291111e+05 \n", " Secondary Energy|Electricity|Hydro 6.423194e+06 \n", " Secondary Energy|Electricity|Nuclear 1.617278e+06 \n", " Secondary Energy|Electricity|Oil 6.919444e+04 \n", " Secondary Energy|Electricity|Other 1.204583e+06 \n", " Secondary Energy|Electricity|Solar 2.575731e+07 \n", " Secondary Energy|Electricity|Wind 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.173833e+06 \n", " Secondary Energy|Electricity|Coal 5.027778e+03 \n", " Secondary Energy|Electricity|Gas 2.602278e+06 \n", " Secondary Energy|Electricity|Geothermal 6.177778e+05 \n", " Secondary Energy|Electricity|Hydro 6.604167e+06 \n", " Secondary Energy|Electricity|Nuclear 1.502778e+06 \n", " Secondary Energy|Electricity|Oil 4.797222e+04 \n", " Secondary Energy|Electricity|Other 1.985111e+06 \n", " Secondary Energy|Electricity|Solar 3.404253e+07 \n", " Secondary Energy|Electricity|Wind 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.359639e+06 \n", " Secondary Energy|Electricity|Coal 3.694444e+03 \n", " Secondary Energy|Electricity|Gas 1.752056e+06 \n", " Secondary Energy|Electricity|Geothermal 5.893056e+05 \n", " Secondary Energy|Electricity|Hydro 6.717417e+06 \n", " Secondary Energy|Electricity|Nuclear 1.304083e+06 \n", " Secondary Energy|Electricity|Oil 3.175000e+04 \n", " Secondary Energy|Electricity|Other 2.790639e+06 \n", " Secondary Energy|Electricity|Solar 4.088394e+07 \n", " Secondary Energy|Electricity|Wind 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.471139e+06 \n", " Secondary Energy|Electricity|Coal 2.416667e+03 \n", " Secondary Energy|Electricity|Gas 1.218361e+06 \n", " Secondary Energy|Electricity|Geothermal 5.187222e+05 \n", " Secondary Energy|Electricity|Hydro 6.770250e+06 \n", " Secondary Energy|Electricity|Nuclear 1.098694e+06 \n", " Secondary Energy|Electricity|Oil 1.169444e+04 \n", " Secondary Energy|Electricity|Other 3.488083e+06 \n", " Secondary Energy|Electricity|Solar 4.723214e+07 \n", " Secondary Energy|Electricity|Wind 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.513056e+06 \n", " Secondary Energy|Electricity|Coal 1.555556e+03 \n", " Secondary Energy|Electricity|Gas 6.538889e+05 \n", " Secondary Energy|Electricity|Geothermal 4.333611e+05 \n", " Secondary Energy|Electricity|Hydro 6.782028e+06 \n", " Secondary Energy|Electricity|Nuclear 8.686111e+05 \n", " Secondary Energy|Electricity|Oil 6.722222e+03 \n", " Secondary Energy|Electricity|Other 4.020806e+06 \n", " Secondary Energy|Electricity|Solar 5.327061e+07 \n", " Secondary Energy|Electricity|Wind 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.544750e+06 \n", " Secondary Energy|Electricity|Coal 9.444444e+02 \n", " Secondary Energy|Electricity|Gas 5.281944e+05 \n", " Secondary Energy|Electricity|Geothermal 3.603889e+05 \n", " Secondary Energy|Electricity|Hydro 6.775917e+06 \n", " Secondary Energy|Electricity|Nuclear 6.451944e+05 \n", " Secondary Energy|Electricity|Oil 2.777778e+01 \n", " Secondary Energy|Electricity|Other 4.434639e+06 \n", " Secondary Energy|Electricity|Solar 5.819236e+07 \n", " Secondary Energy|Electricity|Wind 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.564583e+06 \n", " Secondary Energy|Electricity|Coal 4.444444e+02 \n", " Secondary Energy|Electricity|Gas 2.423333e+05 \n", " Secondary Energy|Electricity|Geothermal 2.924722e+05 \n", " Secondary Energy|Electricity|Hydro 6.722667e+06 \n", " Secondary Energy|Electricity|Nuclear 2.717500e+05 \n", " Secondary Energy|Electricity|Oil 2.777778e+01 \n", " Secondary Energy|Electricity|Other 5.261472e+06 \n", " Secondary Energy|Electricity|Solar 6.826367e+07 \n", " Secondary Energy|Electricity|Wind 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.557556e+06 \n", " Secondary Energy|Electricity|Coal 5.277778e+02 \n", " Secondary Energy|Electricity|Gas 1.685833e+05 \n", " Secondary Energy|Electricity|Geothermal 2.492778e+05 \n", " Secondary Energy|Electricity|Hydro 6.655833e+06 \n", " Secondary Energy|Electricity|Nuclear 5.925000e+04 \n", " Secondary Energy|Electricity|Oil 2.777778e+01 \n", " Secondary Energy|Electricity|Other 6.099583e+06 \n", " Secondary Energy|Electricity|Solar 7.754106e+07 \n", " Secondary Energy|Electricity|Wind 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.543056e+06 \n", " Secondary Energy|Electricity|Coal 5.555556e+02 \n", " Secondary Energy|Electricity|Gas 4.166667e+04 \n", " Secondary Energy|Electricity|Geothermal 2.059167e+05 \n", " Secondary Energy|Electricity|Hydro 6.631806e+06 \n", " Secondary Energy|Electricity|Nuclear 3.916667e+03 \n", " Secondary Energy|Electricity|Oil 2.777778e+01 \n", " Secondary Energy|Electricity|Other 6.740833e+06 \n", " Secondary Energy|Electricity|Solar 8.359456e+07 \n", " Secondary Energy|Electricity|Wind 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region unit variable \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GWh/yr Secondary Energy|Electricity|Biomass 1.574306e+06 \n", " Secondary Energy|Electricity|Coal 5.000000e+02 \n", " Secondary Energy|Electricity|Gas 3.888889e+02 \n", " Secondary Energy|Electricity|Geothermal 1.937500e+05 \n", " Secondary Energy|Electricity|Hydro 6.533167e+06 \n", " Secondary Energy|Electricity|Nuclear 1.388889e+02 \n", " Secondary Energy|Electricity|Oil 2.777778e+01 \n", " Secondary Energy|Electricity|Other 7.547194e+06 \n", " Secondary Energy|Electricity|Solar 9.270394e+07 \n", " Secondary Energy|Electricity|Wind 4.123369e+07 " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "formatlevel(generation, variable=\"Secondary Energy|{carrier}|{fuel}\", drop=True)\n", "# or: df.pix.format(variable=\"Secondary Energy|{carrier}|{fuel}\")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "e78ace7d", "metadata": {}, "source": [ "With `generation` and `capacity` conveniently split into separate variables, we can calculate capacity factors (ratios of generation and capacity) directly, as long as we take care of removing the conflicting `unit` level. Similarly to `ismatch`, `isin` can be provided as an argument to `.loc[]` to select on named index levels with the difference that only exact matches are considered." ] }, { "cell_type": "code", "execution_count": 10, "id": "9b4be2b0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
20302035204020452050
modelscenarioregioncarrierfuel
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldElectricityGeothermal0.8499840.8500050.8499890.8499860.850021
Hydro0.3945970.3944740.3962400.3982170.399716
Solar0.1611560.1542370.1519940.1506980.149422
Wind0.2638200.2757810.2890830.3020180.298163
\n", "
" ], "text/plain": [ " 2030 \\\n", "model scenario region carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Geothermal 0.849984 \n", " Hydro 0.394597 \n", " Solar 0.161156 \n", " Wind 0.263820 \n", "\n", " 2035 \\\n", "model scenario region carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Geothermal 0.850005 \n", " Hydro 0.394474 \n", " Solar 0.154237 \n", " Wind 0.275781 \n", "\n", " 2040 \\\n", "model scenario region carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Geothermal 0.849989 \n", " Hydro 0.396240 \n", " Solar 0.151994 \n", " Wind 0.289083 \n", "\n", " 2045 \\\n", "model scenario region carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Geothermal 0.849986 \n", " Hydro 0.398217 \n", " Solar 0.150698 \n", " Wind 0.302018 \n", "\n", " 2050 \n", "model scenario region carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Geothermal 0.850021 \n", " Hydro 0.399716 \n", " Solar 0.149422 \n", " Wind 0.298163 " ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "capacity_factor = generation.droplevel(\"unit\") / 8760 / capacity.droplevel(\"unit\")\n", "capacity_factor.loc[isin(fuel=[\"Solar\", \"Wind\", \"Hydro\", \"Geothermal\"]), 2030:2051]" ] }, { "cell_type": "markdown", "id": "d62fabd9", "metadata": {}, "source": [ "Instead of dropping the `unit` level, there is also a set of unit-aware calculation functions, so that this full capacity factor calculation can be performed in very few steps (the unit aware calculation realizes correctly that the capacity factor is unit-less):" ] }, { "cell_type": "code", "execution_count": 11, "id": "94c1f308", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionunitcarrierfuel
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldElectricityBiomass0.6244100.6221790.6217790.6226250.6405630.7031390.8464291.0910011.4580541.9508322.6289783.85105112.30519444.837349214.719844835.312733
Coal0.6832210.6169540.5620790.5913470.5628190.5473760.5432780.5345830.5428980.5481930.5704060.5868160.6475220.6558540.6567480.658644
Gas0.3969470.4289650.4247220.4347260.4188850.3277100.2329760.2302180.2313650.2469350.1894580.1722020.0902280.0900360.0903580.163281
Geothermal0.8495310.8493390.8494770.8494340.8494040.8494020.8494230.8494070.8494040.8494400.8493950.8494120.8494100.8493870.8494690.849447
Hydro0.4210450.4212120.4036900.4031080.3972480.3943270.3942040.3959690.3979450.3994430.4006370.4020540.4049880.4080250.4098030.412868
Nuclear0.7994540.7456600.7367360.7316580.7560450.7766340.7860770.7994520.7994530.7994550.7994420.7994410.7994750.7994170.8007200.833897
Oil0.2429620.2505170.2568950.2499930.2548470.2478640.2498230.2498870.2497500.2497690.2502530.2640670.2640670.2640670.2618850.251493
OtherNaNNaN0.1492960.1492370.1253700.1199970.1096620.1004680.0952650.0932510.0931260.0931080.0933140.0930450.0924090.092235
Solar0.1736560.1914170.1357440.1623380.1657580.1610460.1541310.1518900.1505950.1493190.1478430.1466260.1430600.1402840.1385110.136580
Wind0.3859300.3744430.2302120.2531290.2608390.2636390.2755920.2888850.3018110.2979590.2951010.2919830.2834670.2791350.2736590.270820
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.624410 \n", " Coal 0.683221 \n", " Gas 0.396947 \n", " Geothermal 0.849531 \n", " Hydro 0.421045 \n", " Nuclear 0.799454 \n", " Oil 0.242962 \n", " Other NaN \n", " Solar 0.173656 \n", " Wind 0.385930 \n", "\n", " 2010 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.622179 \n", " Coal 0.616954 \n", " Gas 0.428965 \n", " Geothermal 0.849339 \n", " Hydro 0.421212 \n", " Nuclear 0.745660 \n", " Oil 0.250517 \n", " Other NaN \n", " Solar 0.191417 \n", " Wind 0.374443 \n", "\n", " 2015 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.621779 \n", " Coal 0.562079 \n", " Gas 0.424722 \n", " Geothermal 0.849477 \n", " Hydro 0.403690 \n", " Nuclear 0.736736 \n", " Oil 0.256895 \n", " Other 0.149296 \n", " Solar 0.135744 \n", " Wind 0.230212 \n", "\n", " 2020 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.622625 \n", " Coal 0.591347 \n", " Gas 0.434726 \n", " Geothermal 0.849434 \n", " Hydro 0.403108 \n", " Nuclear 0.731658 \n", " Oil 0.249993 \n", " Other 0.149237 \n", " Solar 0.162338 \n", " Wind 0.253129 \n", "\n", " 2025 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.640563 \n", " Coal 0.562819 \n", " Gas 0.418885 \n", " Geothermal 0.849404 \n", " Hydro 0.397248 \n", " Nuclear 0.756045 \n", " Oil 0.254847 \n", " Other 0.125370 \n", " Solar 0.165758 \n", " Wind 0.260839 \n", "\n", " 2030 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.703139 \n", " Coal 0.547376 \n", " Gas 0.327710 \n", " Geothermal 0.849402 \n", " Hydro 0.394327 \n", " Nuclear 0.776634 \n", " Oil 0.247864 \n", " Other 0.119997 \n", " Solar 0.161046 \n", " Wind 0.263639 \n", "\n", " 2035 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 0.846429 \n", " Coal 0.543278 \n", " Gas 0.232976 \n", " Geothermal 0.849423 \n", " Hydro 0.394204 \n", " Nuclear 0.786077 \n", " Oil 0.249823 \n", " Other 0.109662 \n", " Solar 0.154131 \n", " Wind 0.275592 \n", "\n", " 2040 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 1.091001 \n", " Coal 0.534583 \n", " Gas 0.230218 \n", " Geothermal 0.849407 \n", " Hydro 0.395969 \n", " Nuclear 0.799452 \n", " Oil 0.249887 \n", " Other 0.100468 \n", " Solar 0.151890 \n", " Wind 0.288885 \n", "\n", " 2045 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 1.458054 \n", " Coal 0.542898 \n", " Gas 0.231365 \n", " Geothermal 0.849404 \n", " Hydro 0.397945 \n", " Nuclear 0.799453 \n", " Oil 0.249750 \n", " Other 0.095265 \n", " Solar 0.150595 \n", " Wind 0.301811 \n", "\n", " 2050 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 1.950832 \n", " Coal 0.548193 \n", " Gas 0.246935 \n", " Geothermal 0.849440 \n", " Hydro 0.399443 \n", " Nuclear 0.799455 \n", " Oil 0.249769 \n", " Other 0.093251 \n", " Solar 0.149319 \n", " Wind 0.297959 \n", "\n", " 2055 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 2.628978 \n", " Coal 0.570406 \n", " Gas 0.189458 \n", " Geothermal 0.849395 \n", " Hydro 0.400637 \n", " Nuclear 0.799442 \n", " Oil 0.250253 \n", " Other 0.093126 \n", " Solar 0.147843 \n", " Wind 0.295101 \n", "\n", " 2060 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 3.851051 \n", " Coal 0.586816 \n", " Gas 0.172202 \n", " Geothermal 0.849412 \n", " Hydro 0.402054 \n", " Nuclear 0.799441 \n", " Oil 0.264067 \n", " Other 0.093108 \n", " Solar 0.146626 \n", " Wind 0.291983 \n", "\n", " 2070 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 12.305194 \n", " Coal 0.647522 \n", " Gas 0.090228 \n", " Geothermal 0.849410 \n", " Hydro 0.404988 \n", " Nuclear 0.799475 \n", " Oil 0.264067 \n", " Other 0.093314 \n", " Solar 0.143060 \n", " Wind 0.283467 \n", "\n", " 2080 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 44.837349 \n", " Coal 0.655854 \n", " Gas 0.090036 \n", " Geothermal 0.849387 \n", " Hydro 0.408025 \n", " Nuclear 0.799417 \n", " Oil 0.264067 \n", " Other 0.093045 \n", " Solar 0.140284 \n", " Wind 0.279135 \n", "\n", " 2090 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 214.719844 \n", " Coal 0.656748 \n", " Gas 0.090358 \n", " Geothermal 0.849469 \n", " Hydro 0.409803 \n", " Nuclear 0.800720 \n", " Oil 0.261885 \n", " Other 0.092409 \n", " Solar 0.138511 \n", " Wind 0.273659 \n", "\n", " 2100 \n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Electricity Biomass 835.312733 \n", " Coal 0.658644 \n", " Gas 0.163281 \n", " Geothermal 0.849447 \n", " Hydro 0.412868 \n", " Nuclear 0.833897 \n", " Oil 0.251493 \n", " Other 0.092235 \n", " Solar 0.136580 \n", " Wind 0.270820 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "generation = extractlevel(df, variable=\"Secondary Energy|{carrier}|{fuel}\", drop=True)\n", "capacity = extractlevel(df, variable=\"Capacity|{carrier}|{fuel}\", drop=True)\n", "generation.pix.unitdiv(capacity)" ] }, { "attachments": {}, "cell_type": "markdown", "id": "b4d501a3", "metadata": {}, "source": [ "Under the hood `isin` and `ismatch` generate `Selector` objects. They can be composed into complex queries intuitively, which are kept as a hierarchical structure of objects." ] }, { "cell_type": "code", "execution_count": 12, "id": "4197be7d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "And(a=Isin(filters={'fuel': ['Coal', 'Gas', 'Nuclear'], 'unit': 'GW'}), b=Not(a=Ismatch(filters={'fuel': 'S*'}, regex=False)))" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "query = isin(fuel=[\"Coal\", \"Gas\", \"Nuclear\"], unit=\"GW\") & ~ismatch(fuel=\"S*\")\n", "query" ] }, { "attachments": {}, "cell_type": "markdown", "id": "f137127f", "metadata": {}, "source": [ "For evaluating such a query one needs to pass in a data object to produce a boolean mask. Since pandas `.loc` indexer does exactly that, these queries work as expected.\n" ] }, { "cell_type": "code", "execution_count": 13, "id": "18401aa0", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Biomass False\n", " Coal True\n", " Gas True\n", " Geothermal False\n", " Hydro False\n", " Nuclear True\n", " Oil False\n", " Other False\n", " Solar False\n", " Wind False\n", "dtype: bool" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "query(capacity)" ] }, { "attachments": {}, "cell_type": "markdown", "id": "7e1d4f00", "metadata": {}, "source": [ "````{note}\n", "It is only possible from version 0.5.2 to use a pandas boolean series **in front of** a selector; ie.\n", "```python\n", "(capacity[2030] > 250) & isin(variable=[\"Coal\", \"Gas\", \"Nuclear\"], unit=\"GW\")\n", "```\n", "works, as you would expect it, in the same way as\n", "```python\n", "isin(variable=[\"Coal\", \"Gas\", \"Nuclear\"], unit=\"GW\") & (capacity[2030] > 250)\n", "```\n", "````" ] }, { "cell_type": "code", "execution_count": 14, "id": "8b421dba", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
20052010201520202025203020352040
modelscenarioregionunitcarrierfuel
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldGWElectricityGas1096.67361343.10771603.16861852.64851761.80571584.40331423.53931289.4777
Nuclear408.3700404.3094379.1375345.2239310.1729275.5920234.7028214.4376
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1096.6736 \n", " Nuclear 408.3700 \n", "\n", " 2010 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1343.1077 \n", " Nuclear 404.3094 \n", "\n", " 2015 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1603.1686 \n", " Nuclear 379.1375 \n", "\n", " 2020 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1852.6485 \n", " Nuclear 345.2239 \n", "\n", " 2025 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1761.8057 \n", " Nuclear 310.1729 \n", "\n", " 2030 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1584.4033 \n", " Nuclear 275.5920 \n", "\n", " 2035 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1423.5393 \n", " Nuclear 234.7028 \n", "\n", " 2040 \n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1289.4777 \n", " Nuclear 214.4376 " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "high_capacity_fossil = capacity.loc[\n", " isin(fuel=[\"Coal\", \"Gas\", \"Nuclear\"], unit=\"GW\") & (capacity[2030] > 250),\n", " :2041,\n", "]\n", "high_capacity_fossil" ] }, { "attachments": {}, "cell_type": "markdown", "id": "50fe70b7", "metadata": {}, "source": [ "The simple fact that this is an operation on `[]`, means that we can also use it to modify values in-place:" ] }, { "cell_type": "code", "execution_count": 15, "id": "71d7aa7d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
20052010201520202025203020352040
modelscenarioregionunitcarrierfuel
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldGWElectricityGas1096.67361343.10771603.16861852.64851761.80571000.0001000.00001000.0000
Nuclear408.3700404.3094379.1375345.2239310.1729275.592234.7028214.4376
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1096.6736 \n", " Nuclear 408.3700 \n", "\n", " 2010 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1343.1077 \n", " Nuclear 404.3094 \n", "\n", " 2015 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1603.1686 \n", " Nuclear 379.1375 \n", "\n", " 2020 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1852.6485 \n", " Nuclear 345.2239 \n", "\n", " 2025 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1761.8057 \n", " Nuclear 310.1729 \n", "\n", " 2030 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1000.000 \n", " Nuclear 275.592 \n", "\n", " 2035 \\\n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1000.0000 \n", " Nuclear 234.7028 \n", "\n", " 2040 \n", "model scenario region unit carrier fuel \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Gas 1000.0000 \n", " Nuclear 214.4376 " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "high_capacity_fossil.loc[isin(fuel=\"Gas\"), 2030:] = 1000.0\n", "high_capacity_fossil" ] }, { "attachments": {}, "cell_type": "markdown", "id": "25dd3f6e", "metadata": {}, "source": [ "Most methods in `pandas_indexing` do not care whether they are run on an index, a series or a dataframe, but will transiently take care of handing them down to the appropriate level:" ] }, { "cell_type": "code", "execution_count": 16, "id": "e0ff32d5", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel year\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", " Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", " Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "dtype: float64" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fossil_series = (\n", " capacity.loc[isin(fuel=[\"Coal\", \"Gas\", \"Nuclear\"]), [2030, 2040, 2050, 2060]]\n", " .rename_axis(columns=\"year\")\n", " .stack()\n", ")\n", "fossil_series" ] }, { "cell_type": "code", "execution_count": 17, "id": "6d4686e6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel year\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Coal 2030 182.0149\n", " 2050 0.5029\n", " Gas 2030 1584.4033\n", " 2050 562.8482\n", " Nuclear 2030 275.5920\n", " 2050 156.7766\n", "dtype: float64" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fossil_series.loc[isin(year=[2030, 2050])]" ] }, { "cell_type": "code", "execution_count": 18, "id": "8d4e91fb", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel year\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Coal 2030 False\n", " 2040 False\n", " 2050 False\n", " 2060 False\n", " Gas 2030 False\n", " 2040 False\n", " 2050 False\n", " 2060 False\n", " Nuclear 2030 True\n", " 2040 True\n", " 2050 True\n", " 2060 True\n", "dtype: bool" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "isin(fossil_series.index, fuel=\"Nuclear\")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "36c41351", "metadata": {}, "source": [ "# Selecting based on a multi-index\n", "\n", "If we need pairs of data like `Coal` in 2030 and `Gas` in 2040 and `Nuclear` in 2040 and 2050, based on a given multiindex, then this defines right-oriented `semijoin` like:" ] }, { "cell_type": "code", "execution_count": 19, "id": "cde4ff9f", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "MultiIndex([( 'Coal', 2030),\n", " ( 'Gas', 2035),\n", " ('Nuclear', 2040),\n", " ('Nuclear', 2050)],\n", " names=['fuel', 'year'])" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "idx = pd.MultiIndex.from_tuples(\n", " [(\"Coal\", 2030), (\"Gas\", 2035), (\"Nuclear\", 2040), (\"Nuclear\", 2050)],\n", " names=[\"fuel\", \"year\"],\n", ")\n", "idx" ] }, { "cell_type": "code", "execution_count": 20, "id": "dc294f2f", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "fuel year model scenario region unit carrier \n", "Coal 2030 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity 182.0149\n", "Gas 2035 NaN NaN NaN NaN NaN NaN\n", "Nuclear 2040 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity 214.4376\n", " 2050 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity 156.7766\n", "dtype: float64" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import semijoin\n", "\n", "\n", "semijoin(\n", " fossil_series, idx, how=\"right\"\n", ") # or: fossil_series.pix.semijoin(idx, how=\"right\")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "cbaa73b0", "metadata": {}, "source": [ "Since the `(\"Gas\", 2035)` is not part of the original `fossil_series` it shows up as `NaN`s here, an inner join will skip it silently:" ] }, { "cell_type": "code", "execution_count": 21, "id": "f82d6bf4", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel year\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Coal 2030 182.0149\n", " Nuclear 2040 214.4376\n", " 2050 156.7766\n", "dtype: float64" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "semijoin(fossil_series, idx, how=\"inner\")" ] }, { "cell_type": "markdown", "id": "4c420dc1", "metadata": {}, "source": [ "It is also possible to get the inverted result, with only the not matching rows, with an `antijoin`" ] }, { "cell_type": "code", "execution_count": 22, "id": "bed99ac9", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario region unit carrier fuel year\n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World GW Electricity Coal 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", " Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", " Nuclear 2030 275.5920\n", " 2060 92.0667\n", "dtype: float64" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import antijoin\n", "\n", "\n", "antijoin(fossil_series, idx)\n", "# or: fossil_series.pix.antijoin(idx)" ] }, { "attachments": {}, "cell_type": "markdown", "id": "f2e1e0e4", "metadata": {}, "source": [ "# Projecting levels\n", "\n", "Often after selecting the right subsets, ie the interesting `model` or `scenario` it makes sense to consolidate the data to a given set of `levels`. That is what `projectlevel` is used for:" ] }, { "cell_type": "code", "execution_count": 23, "id": "6d0000aa", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "fuel year\n", "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "dtype: float64" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import projectlevel\n", "\n", "\n", "simple_fossil_series = projectlevel(fossil_series, [\"fuel\", \"year\"])\n", "# or: fossil_series.pix.project([\"fuel\", \"year\"])\n", "simple_fossil_series" ] }, { "attachments": {}, "cell_type": "markdown", "id": "715fe070", "metadata": {}, "source": [ "`projectlevel` reduces the levels attached to a multiindex to the ones explicitly named. It is basically the complement to `droplevel` which removes the listed names" ] }, { "cell_type": "code", "execution_count": 24, "id": "308fb920", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "model scenario \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", " DeepElec_SSP2_HighRE_Budg900 True\n", "dtype: bool" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "projectlevel(fossil_series, [\"model\", \"scenario\"]) == fossil_series.droplevel(\n", " [\"carrier\", \"fuel\", \"unit\", \"region\", \"year\"]\n", ")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "6eb7b029", "metadata": {}, "source": [ "# Assigning to levels\n", "\n", "`assignlevel` allows to modify individual values with helpful keyword arguments," ] }, { "cell_type": "code", "execution_count": 25, "id": "ca2a3c70", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionvariableunit
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldUpdated|Capacity|Electricity|Biomassbla4.298430e+016.247170e+018.566980e+011.088834e+021.285653e+021.378452e+021.328316e+021.227382e+021.063772e+028.602650e+016.565480e+014.575910e+011.450470e+013.962800e+008.198000e-012.150000e-01
Updated|Capacity|Electricity|Coalbla1.238877e+031.525950e+031.876595e+032.075232e+031.225451e+031.820149e+021.353200e+001.072900e+007.763000e-015.029000e-013.111000e-011.836000e-017.830000e-029.180000e-029.650000e-028.660000e-02
Updated|Capacity|Electricity|Gasbla1.096674e+031.343108e+031.603169e+031.852649e+031.761806e+031.584403e+031.423539e+031.289478e+038.638716e+025.628482e+023.937209e+023.499091e+023.063883e+022.135970e+025.260450e+012.717000e-01
Updated|Capacity|Electricity|Geothermalbla8.112900e+001.299850e+012.416120e+014.665730e+017.064690e+018.345060e+018.448930e+018.296880e+017.914520e+016.966280e+015.820210e+014.840070e+013.927950e+013.347930e+012.765300e+012.601980e+01
Updated|Capacity|Electricity|Hydrobla8.065684e+029.633523e+021.239617e+031.500451e+031.669357e+031.786047e+031.858782e+031.902635e+031.925653e+031.933520e+031.931110e+031.922569e+031.893641e+031.860861e+031.846102e+031.805140e+03
Updated|Capacity|Electricity|Nuclearbla4.083700e+024.043094e+023.791375e+023.452239e+023.101729e+022.755920e+022.347028e+022.144376e+021.860849e+021.567766e+021.239472e+029.206670e+013.877600e+018.455000e+005.580000e-011.900000e-02
Updated|Capacity|Electricity|Oilbla5.112499e+024.630961e+023.709638e+022.817401e+021.932768e+029.023290e+013.159640e+012.190000e+011.450230e+015.341200e+003.064300e+001.200000e-021.200000e-021.200000e-021.210000e-021.260000e-02
Updated|Capacity|Electricity|Otherbla0.000000e+000.000000e+003.396000e-011.656200e+008.110980e+014.695231e+021.253078e+032.254017e+033.341699e+034.267072e+034.925403e+035.433398e+036.432168e+037.478326e+038.321384e+039.334424e+03
Updated|Capacity|Electricity|Solarbla2.682400e+004.961380e+012.198533e+026.509654e+023.785689e+031.109448e+041.906378e+042.556775e+043.097003e+043.608447e+044.110399e+044.527457e+045.443399e+046.305545e+046.884808e+047.743017e+04
Updated|Capacity|Electricity|Windbla3.226040e+011.811785e+024.124751e+026.682517e+021.616334e+033.522806e+035.459596e+036.821745e+037.986305e+039.064963e+039.934779e+031.082886e+041.320022e+041.459313e+041.601071e+041.736882e+04
Updated|Secondary Energy|Electricity|Biomassbla2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
Updated|Secondary Energy|Electricity|Coalbla7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
Updated|Secondary Energy|Electricity|Gasbla3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
Updated|Secondary Energy|Electricity|Geothermalbla6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
Updated|Secondary Energy|Electricity|Hydrobla2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
Updated|Secondary Energy|Electricity|Nuclearbla2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
Updated|Secondary Energy|Electricity|Oilbla1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
Updated|Secondary Energy|Electricity|Otherbla0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
Updated|Secondary Energy|Electricity|Solarbla4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
Updated|Secondary Energy|Electricity|Windbla1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 4.298430e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.238877e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.096674e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.112900e+00 \n", " Updated|Capacity|Electricity|Hydro bla 8.065684e+02 \n", " Updated|Capacity|Electricity|Nuclear bla 4.083700e+02 \n", " Updated|Capacity|Electricity|Oil bla 5.112499e+02 \n", " Updated|Capacity|Electricity|Other bla 0.000000e+00 \n", " Updated|Capacity|Electricity|Solar bla 2.682400e+00 \n", " Updated|Capacity|Electricity|Wind bla 3.226040e+01 \n", " Updated|Secondary Energy|Electricity|Biomass bla 2.352778e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 7.419778e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 3.816028e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.041667e+04 \n", " Updated|Secondary Energy|Electricity|Hydro bla 2.976944e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.861861e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.088861e+06 \n", " Updated|Secondary Energy|Electricity|Other bla 0.000000e+00 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.083333e+03 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 6.247170e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.525950e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.343108e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 1.299850e+01 \n", " Updated|Capacity|Electricity|Hydro bla 9.633523e+02 \n", " Updated|Capacity|Electricity|Nuclear bla 4.043094e+02 \n", " Updated|Capacity|Electricity|Oil bla 4.630961e+02 \n", " Updated|Capacity|Electricity|Other bla 0.000000e+00 \n", " Updated|Capacity|Electricity|Solar bla 4.961380e+01 \n", " Updated|Capacity|Electricity|Wind bla 1.811785e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 3.407222e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 8.252667e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.050500e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 9.677778e+04 \n", " Updated|Secondary Energy|Electricity|Hydro bla 3.557028e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.642750e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.016972e+06 \n", " Updated|Secondary Energy|Electricity|Other bla 0.000000e+00 \n", " Updated|Secondary Energy|Electricity|Solar bla 8.325000e+04 \n", " Updated|Secondary Energy|Electricity|Wind bla 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.566980e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.876595e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.603169e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 2.416120e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.239617e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.791375e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.709638e+02 \n", " Updated|Capacity|Electricity|Other bla 3.396000e-01 \n", " Updated|Capacity|Electricity|Solar bla 2.198533e+02 \n", " Updated|Capacity|Electricity|Wind bla 4.124751e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 4.669444e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 9.246333e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.968778e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 1.799167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 4.386694e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.448556e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 8.353889e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 4.444444e+02 \n", " Updated|Secondary Energy|Electricity|Solar bla 2.616111e+05 \n", " Updated|Secondary Energy|Electricity|Wind bla 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.088834e+02 \n", " Updated|Capacity|Electricity|Coal bla 2.075232e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.852649e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 4.665730e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.500451e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.452239e+02 \n", " Updated|Capacity|Electricity|Oil bla 2.817401e+02 \n", " Updated|Capacity|Electricity|Other bla 1.656200e+00 \n", " Updated|Capacity|Electricity|Solar bla 6.509654e+02 \n", " Updated|Capacity|Electricity|Wind bla 6.682517e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 5.942778e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 1.075747e+07 \n", " Updated|Secondary Energy|Electricity|Gas bla 7.060083e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 3.474167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 5.302056e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.214167e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.174167e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 2.166667e+03 \n", " Updated|Secondary Energy|Electricity|Solar bla 9.263611e+05 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.285653e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.225451e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.761806e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 7.064690e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.669357e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.101729e+02 \n", " Updated|Capacity|Electricity|Oil bla 1.932768e+02 \n", " Updated|Capacity|Electricity|Other bla 8.110980e+01 \n", " Updated|Capacity|Electricity|Solar bla 3.785689e+03 \n", " Updated|Capacity|Electricity|Wind bla 1.616334e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 7.219167e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 6.045972e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 6.469250e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.260278e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 5.813167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.055667e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 4.317778e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 8.913889e+04 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.500722e+06 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.378452e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.820149e+02 \n", " Updated|Capacity|Electricity|Gas bla 1.584403e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.345060e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.786047e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.755920e+02 \n", " Updated|Capacity|Electricity|Oil bla 9.023290e+01 \n", " Updated|Capacity|Electricity|Other bla 4.695231e+02 \n", " Updated|Capacity|Electricity|Solar bla 1.109448e+04 \n", " Updated|Capacity|Electricity|Wind bla 3.522806e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 8.496389e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 8.733611e+05 \n", " Updated|Secondary Energy|Electricity|Gas bla 4.551528e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.213611e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.173778e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.876222e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.960556e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 4.938889e+05 \n", " Updated|Secondary Energy|Electricity|Solar bla 1.566242e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.328316e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.353200e+00 \n", " Updated|Capacity|Electricity|Gas bla 1.423539e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.448930e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.858782e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.347028e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.159640e+01 \n", " Updated|Capacity|Electricity|Other bla 1.253078e+03 \n", " Updated|Capacity|Electricity|Solar bla 1.906378e+04 \n", " Updated|Capacity|Electricity|Wind bla 5.459596e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 9.855833e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 6.444444e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.907250e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.291111e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.423194e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.617278e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.919444e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 1.204583e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 2.575731e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.227382e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.072900e+00 \n", " Updated|Capacity|Electricity|Gas bla 1.289478e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.296880e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.902635e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.144376e+02 \n", " Updated|Capacity|Electricity|Oil bla 2.190000e+01 \n", " Updated|Capacity|Electricity|Other bla 2.254017e+03 \n", " Updated|Capacity|Electricity|Solar bla 2.556775e+04 \n", " Updated|Capacity|Electricity|Wind bla 6.821745e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.173833e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.027778e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.602278e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.177778e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.604167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.502778e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 4.797222e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 1.985111e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 3.404253e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.063772e+02 \n", " Updated|Capacity|Electricity|Coal bla 7.763000e-01 \n", " Updated|Capacity|Electricity|Gas bla 8.638716e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 7.914520e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.925653e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.860849e+02 \n", " Updated|Capacity|Electricity|Oil bla 1.450230e+01 \n", " Updated|Capacity|Electricity|Other bla 3.341699e+03 \n", " Updated|Capacity|Electricity|Solar bla 3.097003e+04 \n", " Updated|Capacity|Electricity|Wind bla 7.986305e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.359639e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 3.694444e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.752056e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.893056e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.717417e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.304083e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 3.175000e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 2.790639e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.088394e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.602650e+01 \n", " Updated|Capacity|Electricity|Coal bla 5.029000e-01 \n", " Updated|Capacity|Electricity|Gas bla 5.628482e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 6.966280e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.933520e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.567766e+02 \n", " Updated|Capacity|Electricity|Oil bla 5.341200e+00 \n", " Updated|Capacity|Electricity|Other bla 4.267072e+03 \n", " Updated|Capacity|Electricity|Solar bla 3.608447e+04 \n", " Updated|Capacity|Electricity|Wind bla 9.064963e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.471139e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 2.416667e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.218361e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.187222e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.770250e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.098694e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.169444e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 3.488083e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.723214e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 6.565480e+01 \n", " Updated|Capacity|Electricity|Coal bla 3.111000e-01 \n", " Updated|Capacity|Electricity|Gas bla 3.937209e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 5.820210e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.931110e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.239472e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.064300e+00 \n", " Updated|Capacity|Electricity|Other bla 4.925403e+03 \n", " Updated|Capacity|Electricity|Solar bla 4.110399e+04 \n", " Updated|Capacity|Electricity|Wind bla 9.934779e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.513056e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 1.555556e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 6.538889e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 4.333611e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.782028e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 8.686111e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.722222e+03 \n", " Updated|Secondary Energy|Electricity|Other bla 4.020806e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.327061e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 4.575910e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.836000e-01 \n", " Updated|Capacity|Electricity|Gas bla 3.499091e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 4.840070e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.922569e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 9.206670e+01 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 5.433398e+03 \n", " Updated|Capacity|Electricity|Solar bla 4.527457e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.082886e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.544750e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 9.444444e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.281944e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 3.603889e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.775917e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 6.451944e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 4.434639e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.819236e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.450470e+01 \n", " Updated|Capacity|Electricity|Coal bla 7.830000e-02 \n", " Updated|Capacity|Electricity|Gas bla 3.063883e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 3.927950e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.893641e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.877600e+01 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 6.432168e+03 \n", " Updated|Capacity|Electricity|Solar bla 5.443399e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.320022e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.564583e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 4.444444e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.423333e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.924722e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.722667e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.717500e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 5.261472e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 6.826367e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 3.962800e+00 \n", " Updated|Capacity|Electricity|Coal bla 9.180000e-02 \n", " Updated|Capacity|Electricity|Gas bla 2.135970e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 3.347930e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.860861e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 8.455000e+00 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 7.478326e+03 \n", " Updated|Capacity|Electricity|Solar bla 6.305545e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.459313e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.557556e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.277778e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.685833e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.492778e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.655833e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 5.925000e+04 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 6.099583e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 7.754106e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.198000e-01 \n", " Updated|Capacity|Electricity|Coal bla 9.650000e-02 \n", " Updated|Capacity|Electricity|Gas bla 5.260450e+01 \n", " Updated|Capacity|Electricity|Geothermal bla 2.765300e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.846102e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 5.580000e-01 \n", " Updated|Capacity|Electricity|Oil bla 1.210000e-02 \n", " Updated|Capacity|Electricity|Other bla 8.321384e+03 \n", " Updated|Capacity|Electricity|Solar bla 6.884808e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.601071e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.543056e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.555556e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 4.166667e+04 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.059167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.631806e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 3.916667e+03 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 6.740833e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 8.359456e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 2.150000e-01 \n", " Updated|Capacity|Electricity|Coal bla 8.660000e-02 \n", " Updated|Capacity|Electricity|Gas bla 2.717000e-01 \n", " Updated|Capacity|Electricity|Geothermal bla 2.601980e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.805140e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.900000e-02 \n", " Updated|Capacity|Electricity|Oil bla 1.260000e-02 \n", " Updated|Capacity|Electricity|Other bla 9.334424e+03 \n", " Updated|Capacity|Electricity|Solar bla 7.743017e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.736882e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.574306e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.000000e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 3.888889e+02 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 1.937500e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.533167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.388889e+02 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 7.547194e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 9.270394e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 4.123369e+07 " ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import assignlevel\n", "\n", "\n", "assignlevel(df, variable=\"Updated|\" + projectlevel(df.index, \"variable\"), unit=\"bla\")\n", "# or: df.pix.assign(variable=df.index.pix.project(\"variable\"), unit=\"bla\")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "1349c89d", "metadata": {}, "source": [ "This particular case is even more clearly handled with `formatlevel`:" ] }, { "cell_type": "code", "execution_count": 26, "id": "f4cb55c2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionvariableunit
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldUpdated|Capacity|Electricity|Biomassbla4.298430e+016.247170e+018.566980e+011.088834e+021.285653e+021.378452e+021.328316e+021.227382e+021.063772e+028.602650e+016.565480e+014.575910e+011.450470e+013.962800e+008.198000e-012.150000e-01
Updated|Capacity|Electricity|Coalbla1.238877e+031.525950e+031.876595e+032.075232e+031.225451e+031.820149e+021.353200e+001.072900e+007.763000e-015.029000e-013.111000e-011.836000e-017.830000e-029.180000e-029.650000e-028.660000e-02
Updated|Capacity|Electricity|Gasbla1.096674e+031.343108e+031.603169e+031.852649e+031.761806e+031.584403e+031.423539e+031.289478e+038.638716e+025.628482e+023.937209e+023.499091e+023.063883e+022.135970e+025.260450e+012.717000e-01
Updated|Capacity|Electricity|Geothermalbla8.112900e+001.299850e+012.416120e+014.665730e+017.064690e+018.345060e+018.448930e+018.296880e+017.914520e+016.966280e+015.820210e+014.840070e+013.927950e+013.347930e+012.765300e+012.601980e+01
Updated|Capacity|Electricity|Hydrobla8.065684e+029.633523e+021.239617e+031.500451e+031.669357e+031.786047e+031.858782e+031.902635e+031.925653e+031.933520e+031.931110e+031.922569e+031.893641e+031.860861e+031.846102e+031.805140e+03
Updated|Capacity|Electricity|Nuclearbla4.083700e+024.043094e+023.791375e+023.452239e+023.101729e+022.755920e+022.347028e+022.144376e+021.860849e+021.567766e+021.239472e+029.206670e+013.877600e+018.455000e+005.580000e-011.900000e-02
Updated|Capacity|Electricity|Oilbla5.112499e+024.630961e+023.709638e+022.817401e+021.932768e+029.023290e+013.159640e+012.190000e+011.450230e+015.341200e+003.064300e+001.200000e-021.200000e-021.200000e-021.210000e-021.260000e-02
Updated|Capacity|Electricity|Otherbla0.000000e+000.000000e+003.396000e-011.656200e+008.110980e+014.695231e+021.253078e+032.254017e+033.341699e+034.267072e+034.925403e+035.433398e+036.432168e+037.478326e+038.321384e+039.334424e+03
Updated|Capacity|Electricity|Solarbla2.682400e+004.961380e+012.198533e+026.509654e+023.785689e+031.109448e+041.906378e+042.556775e+043.097003e+043.608447e+044.110399e+044.527457e+045.443399e+046.305545e+046.884808e+047.743017e+04
Updated|Capacity|Electricity|Windbla3.226040e+011.811785e+024.124751e+026.682517e+021.616334e+033.522806e+035.459596e+036.821745e+037.986305e+039.064963e+039.934779e+031.082886e+041.320022e+041.459313e+041.601071e+041.736882e+04
Updated|Secondary Energy|Electricity|Biomassbla2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
Updated|Secondary Energy|Electricity|Coalbla7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
Updated|Secondary Energy|Electricity|Gasbla3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
Updated|Secondary Energy|Electricity|Geothermalbla6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
Updated|Secondary Energy|Electricity|Hydrobla2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
Updated|Secondary Energy|Electricity|Nuclearbla2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
Updated|Secondary Energy|Electricity|Oilbla1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
Updated|Secondary Energy|Electricity|Otherbla0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
Updated|Secondary Energy|Electricity|Solarbla4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
Updated|Secondary Energy|Electricity|Windbla1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 4.298430e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.238877e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.096674e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.112900e+00 \n", " Updated|Capacity|Electricity|Hydro bla 8.065684e+02 \n", " Updated|Capacity|Electricity|Nuclear bla 4.083700e+02 \n", " Updated|Capacity|Electricity|Oil bla 5.112499e+02 \n", " Updated|Capacity|Electricity|Other bla 0.000000e+00 \n", " Updated|Capacity|Electricity|Solar bla 2.682400e+00 \n", " Updated|Capacity|Electricity|Wind bla 3.226040e+01 \n", " Updated|Secondary Energy|Electricity|Biomass bla 2.352778e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 7.419778e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 3.816028e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.041667e+04 \n", " Updated|Secondary Energy|Electricity|Hydro bla 2.976944e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.861861e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.088861e+06 \n", " Updated|Secondary Energy|Electricity|Other bla 0.000000e+00 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.083333e+03 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 6.247170e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.525950e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.343108e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 1.299850e+01 \n", " Updated|Capacity|Electricity|Hydro bla 9.633523e+02 \n", " Updated|Capacity|Electricity|Nuclear bla 4.043094e+02 \n", " Updated|Capacity|Electricity|Oil bla 4.630961e+02 \n", " Updated|Capacity|Electricity|Other bla 0.000000e+00 \n", " Updated|Capacity|Electricity|Solar bla 4.961380e+01 \n", " Updated|Capacity|Electricity|Wind bla 1.811785e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 3.407222e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 8.252667e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.050500e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 9.677778e+04 \n", " Updated|Secondary Energy|Electricity|Hydro bla 3.557028e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.642750e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.016972e+06 \n", " Updated|Secondary Energy|Electricity|Other bla 0.000000e+00 \n", " Updated|Secondary Energy|Electricity|Solar bla 8.325000e+04 \n", " Updated|Secondary Energy|Electricity|Wind bla 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.566980e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.876595e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.603169e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 2.416120e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.239617e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.791375e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.709638e+02 \n", " Updated|Capacity|Electricity|Other bla 3.396000e-01 \n", " Updated|Capacity|Electricity|Solar bla 2.198533e+02 \n", " Updated|Capacity|Electricity|Wind bla 4.124751e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 4.669444e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 9.246333e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.968778e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 1.799167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 4.386694e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.448556e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 8.353889e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 4.444444e+02 \n", " Updated|Secondary Energy|Electricity|Solar bla 2.616111e+05 \n", " Updated|Secondary Energy|Electricity|Wind bla 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.088834e+02 \n", " Updated|Capacity|Electricity|Coal bla 2.075232e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.852649e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 4.665730e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.500451e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.452239e+02 \n", " Updated|Capacity|Electricity|Oil bla 2.817401e+02 \n", " Updated|Capacity|Electricity|Other bla 1.656200e+00 \n", " Updated|Capacity|Electricity|Solar bla 6.509654e+02 \n", " Updated|Capacity|Electricity|Wind bla 6.682517e+02 \n", " Updated|Secondary Energy|Electricity|Biomass bla 5.942778e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 1.075747e+07 \n", " Updated|Secondary Energy|Electricity|Gas bla 7.060083e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 3.474167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 5.302056e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.214167e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.174167e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 2.166667e+03 \n", " Updated|Secondary Energy|Electricity|Solar bla 9.263611e+05 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.285653e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.225451e+03 \n", " Updated|Capacity|Electricity|Gas bla 1.761806e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 7.064690e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.669357e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.101729e+02 \n", " Updated|Capacity|Electricity|Oil bla 1.932768e+02 \n", " Updated|Capacity|Electricity|Other bla 8.110980e+01 \n", " Updated|Capacity|Electricity|Solar bla 3.785689e+03 \n", " Updated|Capacity|Electricity|Wind bla 1.616334e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 7.219167e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 6.045972e+06 \n", " Updated|Secondary Energy|Electricity|Gas bla 6.469250e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.260278e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 5.813167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.055667e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 4.317778e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 8.913889e+04 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.500722e+06 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.378452e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.820149e+02 \n", " Updated|Capacity|Electricity|Gas bla 1.584403e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.345060e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.786047e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.755920e+02 \n", " Updated|Capacity|Electricity|Oil bla 9.023290e+01 \n", " Updated|Capacity|Electricity|Other bla 4.695231e+02 \n", " Updated|Capacity|Electricity|Solar bla 1.109448e+04 \n", " Updated|Capacity|Electricity|Wind bla 3.522806e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 8.496389e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 8.733611e+05 \n", " Updated|Secondary Energy|Electricity|Gas bla 4.551528e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.213611e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.173778e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.876222e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.960556e+05 \n", " Updated|Secondary Energy|Electricity|Other bla 4.938889e+05 \n", " Updated|Secondary Energy|Electricity|Solar bla 1.566242e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.328316e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.353200e+00 \n", " Updated|Capacity|Electricity|Gas bla 1.423539e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.448930e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.858782e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.347028e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.159640e+01 \n", " Updated|Capacity|Electricity|Other bla 1.253078e+03 \n", " Updated|Capacity|Electricity|Solar bla 1.906378e+04 \n", " Updated|Capacity|Electricity|Wind bla 5.459596e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 9.855833e+05 \n", " Updated|Secondary Energy|Electricity|Coal bla 6.444444e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.907250e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.291111e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.423194e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.617278e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.919444e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 1.204583e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 2.575731e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.227382e+02 \n", " Updated|Capacity|Electricity|Coal bla 1.072900e+00 \n", " Updated|Capacity|Electricity|Gas bla 1.289478e+03 \n", " Updated|Capacity|Electricity|Geothermal bla 8.296880e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.902635e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 2.144376e+02 \n", " Updated|Capacity|Electricity|Oil bla 2.190000e+01 \n", " Updated|Capacity|Electricity|Other bla 2.254017e+03 \n", " Updated|Capacity|Electricity|Solar bla 2.556775e+04 \n", " Updated|Capacity|Electricity|Wind bla 6.821745e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.173833e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.027778e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.602278e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 6.177778e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.604167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.502778e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 4.797222e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 1.985111e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 3.404253e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.063772e+02 \n", " Updated|Capacity|Electricity|Coal bla 7.763000e-01 \n", " Updated|Capacity|Electricity|Gas bla 8.638716e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 7.914520e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.925653e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.860849e+02 \n", " Updated|Capacity|Electricity|Oil bla 1.450230e+01 \n", " Updated|Capacity|Electricity|Other bla 3.341699e+03 \n", " Updated|Capacity|Electricity|Solar bla 3.097003e+04 \n", " Updated|Capacity|Electricity|Wind bla 7.986305e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.359639e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 3.694444e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.752056e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.893056e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.717417e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.304083e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 3.175000e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 2.790639e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.088394e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.602650e+01 \n", " Updated|Capacity|Electricity|Coal bla 5.029000e-01 \n", " Updated|Capacity|Electricity|Gas bla 5.628482e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 6.966280e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.933520e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.567766e+02 \n", " Updated|Capacity|Electricity|Oil bla 5.341200e+00 \n", " Updated|Capacity|Electricity|Other bla 4.267072e+03 \n", " Updated|Capacity|Electricity|Solar bla 3.608447e+04 \n", " Updated|Capacity|Electricity|Wind bla 9.064963e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.471139e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 2.416667e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.218361e+06 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 5.187222e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.770250e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.098694e+06 \n", " Updated|Secondary Energy|Electricity|Oil bla 1.169444e+04 \n", " Updated|Secondary Energy|Electricity|Other bla 3.488083e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 4.723214e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 6.565480e+01 \n", " Updated|Capacity|Electricity|Coal bla 3.111000e-01 \n", " Updated|Capacity|Electricity|Gas bla 3.937209e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 5.820210e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.931110e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.239472e+02 \n", " Updated|Capacity|Electricity|Oil bla 3.064300e+00 \n", " Updated|Capacity|Electricity|Other bla 4.925403e+03 \n", " Updated|Capacity|Electricity|Solar bla 4.110399e+04 \n", " Updated|Capacity|Electricity|Wind bla 9.934779e+03 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.513056e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 1.555556e+03 \n", " Updated|Secondary Energy|Electricity|Gas bla 6.538889e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 4.333611e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.782028e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 8.686111e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 6.722222e+03 \n", " Updated|Secondary Energy|Electricity|Other bla 4.020806e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.327061e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 4.575910e+01 \n", " Updated|Capacity|Electricity|Coal bla 1.836000e-01 \n", " Updated|Capacity|Electricity|Gas bla 3.499091e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 4.840070e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.922569e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 9.206670e+01 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 5.433398e+03 \n", " Updated|Capacity|Electricity|Solar bla 4.527457e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.082886e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.544750e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 9.444444e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 5.281944e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 3.603889e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.775917e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 6.451944e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 4.434639e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 5.819236e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 1.450470e+01 \n", " Updated|Capacity|Electricity|Coal bla 7.830000e-02 \n", " Updated|Capacity|Electricity|Gas bla 3.063883e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 3.927950e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.893641e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 3.877600e+01 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 6.432168e+03 \n", " Updated|Capacity|Electricity|Solar bla 5.443399e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.320022e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.564583e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 4.444444e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 2.423333e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.924722e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.722667e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 2.717500e+05 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 5.261472e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 6.826367e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 3.962800e+00 \n", " Updated|Capacity|Electricity|Coal bla 9.180000e-02 \n", " Updated|Capacity|Electricity|Gas bla 2.135970e+02 \n", " Updated|Capacity|Electricity|Geothermal bla 3.347930e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.860861e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 8.455000e+00 \n", " Updated|Capacity|Electricity|Oil bla 1.200000e-02 \n", " Updated|Capacity|Electricity|Other bla 7.478326e+03 \n", " Updated|Capacity|Electricity|Solar bla 6.305545e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.459313e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.557556e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.277778e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 1.685833e+05 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.492778e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.655833e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 5.925000e+04 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 6.099583e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 7.754106e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 8.198000e-01 \n", " Updated|Capacity|Electricity|Coal bla 9.650000e-02 \n", " Updated|Capacity|Electricity|Gas bla 5.260450e+01 \n", " Updated|Capacity|Electricity|Geothermal bla 2.765300e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.846102e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 5.580000e-01 \n", " Updated|Capacity|Electricity|Oil bla 1.210000e-02 \n", " Updated|Capacity|Electricity|Other bla 8.321384e+03 \n", " Updated|Capacity|Electricity|Solar bla 6.884808e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.601071e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.543056e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.555556e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 4.166667e+04 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 2.059167e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.631806e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 3.916667e+03 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 6.740833e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 8.359456e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Updated|Capacity|Electricity|Biomass bla 2.150000e-01 \n", " Updated|Capacity|Electricity|Coal bla 8.660000e-02 \n", " Updated|Capacity|Electricity|Gas bla 2.717000e-01 \n", " Updated|Capacity|Electricity|Geothermal bla 2.601980e+01 \n", " Updated|Capacity|Electricity|Hydro bla 1.805140e+03 \n", " Updated|Capacity|Electricity|Nuclear bla 1.900000e-02 \n", " Updated|Capacity|Electricity|Oil bla 1.260000e-02 \n", " Updated|Capacity|Electricity|Other bla 9.334424e+03 \n", " Updated|Capacity|Electricity|Solar bla 7.743017e+04 \n", " Updated|Capacity|Electricity|Wind bla 1.736882e+04 \n", " Updated|Secondary Energy|Electricity|Biomass bla 1.574306e+06 \n", " Updated|Secondary Energy|Electricity|Coal bla 5.000000e+02 \n", " Updated|Secondary Energy|Electricity|Gas bla 3.888889e+02 \n", " Updated|Secondary Energy|Electricity|Geothermal bla 1.937500e+05 \n", " Updated|Secondary Energy|Electricity|Hydro bla 6.533167e+06 \n", " Updated|Secondary Energy|Electricity|Nuclear bla 1.388889e+02 \n", " Updated|Secondary Energy|Electricity|Oil bla 2.777778e+01 \n", " Updated|Secondary Energy|Electricity|Other bla 7.547194e+06 \n", " Updated|Secondary Energy|Electricity|Solar bla 9.270394e+07 \n", " Updated|Secondary Energy|Electricity|Wind bla 4.123369e+07 " ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import formatlevel\n", "\n", "\n", "formatlevel(df, variable=\"Updated|{variable}\", unit=\"bla\")\n", "# or: df.pix.format(variable=...)" ] }, { "attachments": {}, "cell_type": "markdown", "id": "a8416465", "metadata": {}, "source": [ "Both functions avoid having to rely on `reset_index`, `set_index` pairs, which are painful for large data, since `set_index` is expensive!" ] }, { "cell_type": "code", "execution_count": 27, "id": "72d60d5e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2005201020152020202520302035204020452050205520602070208020902100
modelscenarioregionvariableunit
REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900WorldCapacityGW4.298430e+016.247170e+018.566980e+011.088834e+021.285653e+021.378452e+021.328316e+021.227382e+021.063772e+028.602650e+016.565480e+014.575910e+011.450470e+013.962800e+008.198000e-012.150000e-01
GW1.238877e+031.525950e+031.876595e+032.075232e+031.225451e+031.820149e+021.353200e+001.072900e+007.763000e-015.029000e-013.111000e-011.836000e-017.830000e-029.180000e-029.650000e-028.660000e-02
GW1.096674e+031.343108e+031.603169e+031.852649e+031.761806e+031.584403e+031.423539e+031.289478e+038.638716e+025.628482e+023.937209e+023.499091e+023.063883e+022.135970e+025.260450e+012.717000e-01
GW8.112900e+001.299850e+012.416120e+014.665730e+017.064690e+018.345060e+018.448930e+018.296880e+017.914520e+016.966280e+015.820210e+014.840070e+013.927950e+013.347930e+012.765300e+012.601980e+01
GW8.065684e+029.633523e+021.239617e+031.500451e+031.669357e+031.786047e+031.858782e+031.902635e+031.925653e+031.933520e+031.931110e+031.922569e+031.893641e+031.860861e+031.846102e+031.805140e+03
GW4.083700e+024.043094e+023.791375e+023.452239e+023.101729e+022.755920e+022.347028e+022.144376e+021.860849e+021.567766e+021.239472e+029.206670e+013.877600e+018.455000e+005.580000e-011.900000e-02
GW5.112499e+024.630961e+023.709638e+022.817401e+021.932768e+029.023290e+013.159640e+012.190000e+011.450230e+015.341200e+003.064300e+001.200000e-021.200000e-021.200000e-021.210000e-021.260000e-02
GW0.000000e+000.000000e+003.396000e-011.656200e+008.110980e+014.695231e+021.253078e+032.254017e+033.341699e+034.267072e+034.925403e+035.433398e+036.432168e+037.478326e+038.321384e+039.334424e+03
GW2.682400e+004.961380e+012.198533e+026.509654e+023.785689e+031.109448e+041.906378e+042.556775e+043.097003e+043.608447e+044.110399e+044.527457e+045.443399e+046.305545e+046.884808e+047.743017e+04
GW3.226040e+011.811785e+024.124751e+026.682517e+021.616334e+033.522806e+035.459596e+036.821745e+037.986305e+039.064963e+039.934779e+031.082886e+041.320022e+041.459313e+041.601071e+041.736882e+04
GWh/yr2.352778e+053.407222e+054.669444e+055.942778e+057.219167e+058.496389e+059.855833e+051.173833e+061.359639e+061.471139e+061.513056e+061.544750e+061.564583e+061.557556e+061.543056e+061.574306e+06
GWh/yr7.419778e+068.252667e+069.246333e+061.075747e+076.045972e+068.733611e+056.444444e+035.027778e+033.694444e+032.416667e+031.555556e+039.444444e+024.444444e+025.277778e+025.555556e+025.000000e+02
GWh/yr3.816028e+065.050500e+065.968778e+067.060083e+066.469250e+064.551528e+062.907250e+062.602278e+061.752056e+061.218361e+066.538889e+055.281944e+052.423333e+051.685833e+054.166667e+043.888889e+02
GWh/yr6.041667e+049.677778e+041.799167e+053.474167e+055.260278e+056.213611e+056.291111e+056.177778e+055.893056e+055.187222e+054.333611e+053.603889e+052.924722e+052.492778e+052.059167e+051.937500e+05
GWh/yr2.976944e+063.557028e+064.386694e+065.302056e+065.813167e+066.173778e+066.423194e+066.604167e+066.717417e+066.770250e+066.782028e+066.775917e+066.722667e+066.655833e+066.631806e+066.533167e+06
GWh/yr2.861861e+062.642750e+062.448556e+062.214167e+062.055667e+061.876222e+061.617278e+061.502778e+061.304083e+061.098694e+068.686111e+056.451944e+052.717500e+055.925000e+043.916667e+031.388889e+02
GWh/yr1.088861e+061.016972e+068.353889e+056.174167e+054.317778e+051.960556e+056.919444e+044.797222e+043.175000e+041.169444e+046.722222e+032.777778e+012.777778e+012.777778e+012.777778e+012.777778e+01
GWh/yr0.000000e+000.000000e+004.444444e+022.166667e+038.913889e+044.938889e+051.204583e+061.985111e+062.790639e+063.488083e+064.020806e+064.434639e+065.261472e+066.099583e+066.740833e+067.547194e+06
GWh/yr4.083333e+038.325000e+042.616111e+059.263611e+055.500722e+061.566242e+072.575731e+073.404253e+074.088394e+074.723214e+075.327061e+075.819236e+076.826367e+077.754106e+078.359456e+079.270394e+07
GWh/yr1.091389e+055.946944e+058.323889e+051.482806e+063.695778e+068.141417e+061.318953e+071.727517e+072.112919e+072.367689e+072.569986e+072.771675e+073.280081e+073.570786e+073.840797e+074.123369e+07
\n", "
" ], "text/plain": [ " 2005 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 4.298430e+01 \n", " GW 1.238877e+03 \n", " GW 1.096674e+03 \n", " GW 8.112900e+00 \n", " GW 8.065684e+02 \n", " GW 4.083700e+02 \n", " GW 5.112499e+02 \n", " GW 0.000000e+00 \n", " GW 2.682400e+00 \n", " GW 3.226040e+01 \n", " GWh/yr 2.352778e+05 \n", " GWh/yr 7.419778e+06 \n", " GWh/yr 3.816028e+06 \n", " GWh/yr 6.041667e+04 \n", " GWh/yr 2.976944e+06 \n", " GWh/yr 2.861861e+06 \n", " GWh/yr 1.088861e+06 \n", " GWh/yr 0.000000e+00 \n", " GWh/yr 4.083333e+03 \n", " GWh/yr 1.091389e+05 \n", "\n", " 2010 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 6.247170e+01 \n", " GW 1.525950e+03 \n", " GW 1.343108e+03 \n", " GW 1.299850e+01 \n", " GW 9.633523e+02 \n", " GW 4.043094e+02 \n", " GW 4.630961e+02 \n", " GW 0.000000e+00 \n", " GW 4.961380e+01 \n", " GW 1.811785e+02 \n", " GWh/yr 3.407222e+05 \n", " GWh/yr 8.252667e+06 \n", " GWh/yr 5.050500e+06 \n", " GWh/yr 9.677778e+04 \n", " GWh/yr 3.557028e+06 \n", " GWh/yr 2.642750e+06 \n", " GWh/yr 1.016972e+06 \n", " GWh/yr 0.000000e+00 \n", " GWh/yr 8.325000e+04 \n", " GWh/yr 5.946944e+05 \n", "\n", " 2015 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 8.566980e+01 \n", " GW 1.876595e+03 \n", " GW 1.603169e+03 \n", " GW 2.416120e+01 \n", " GW 1.239617e+03 \n", " GW 3.791375e+02 \n", " GW 3.709638e+02 \n", " GW 3.396000e-01 \n", " GW 2.198533e+02 \n", " GW 4.124751e+02 \n", " GWh/yr 4.669444e+05 \n", " GWh/yr 9.246333e+06 \n", " GWh/yr 5.968778e+06 \n", " GWh/yr 1.799167e+05 \n", " GWh/yr 4.386694e+06 \n", " GWh/yr 2.448556e+06 \n", " GWh/yr 8.353889e+05 \n", " GWh/yr 4.444444e+02 \n", " GWh/yr 2.616111e+05 \n", " GWh/yr 8.323889e+05 \n", "\n", " 2020 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.088834e+02 \n", " GW 2.075232e+03 \n", " GW 1.852649e+03 \n", " GW 4.665730e+01 \n", " GW 1.500451e+03 \n", " GW 3.452239e+02 \n", " GW 2.817401e+02 \n", " GW 1.656200e+00 \n", " GW 6.509654e+02 \n", " GW 6.682517e+02 \n", " GWh/yr 5.942778e+05 \n", " GWh/yr 1.075747e+07 \n", " GWh/yr 7.060083e+06 \n", " GWh/yr 3.474167e+05 \n", " GWh/yr 5.302056e+06 \n", " GWh/yr 2.214167e+06 \n", " GWh/yr 6.174167e+05 \n", " GWh/yr 2.166667e+03 \n", " GWh/yr 9.263611e+05 \n", " GWh/yr 1.482806e+06 \n", "\n", " 2025 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.285653e+02 \n", " GW 1.225451e+03 \n", " GW 1.761806e+03 \n", " GW 7.064690e+01 \n", " GW 1.669357e+03 \n", " GW 3.101729e+02 \n", " GW 1.932768e+02 \n", " GW 8.110980e+01 \n", " GW 3.785689e+03 \n", " GW 1.616334e+03 \n", " GWh/yr 7.219167e+05 \n", " GWh/yr 6.045972e+06 \n", " GWh/yr 6.469250e+06 \n", " GWh/yr 5.260278e+05 \n", " GWh/yr 5.813167e+06 \n", " GWh/yr 2.055667e+06 \n", " GWh/yr 4.317778e+05 \n", " GWh/yr 8.913889e+04 \n", " GWh/yr 5.500722e+06 \n", " GWh/yr 3.695778e+06 \n", "\n", " 2030 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.378452e+02 \n", " GW 1.820149e+02 \n", " GW 1.584403e+03 \n", " GW 8.345060e+01 \n", " GW 1.786047e+03 \n", " GW 2.755920e+02 \n", " GW 9.023290e+01 \n", " GW 4.695231e+02 \n", " GW 1.109448e+04 \n", " GW 3.522806e+03 \n", " GWh/yr 8.496389e+05 \n", " GWh/yr 8.733611e+05 \n", " GWh/yr 4.551528e+06 \n", " GWh/yr 6.213611e+05 \n", " GWh/yr 6.173778e+06 \n", " GWh/yr 1.876222e+06 \n", " GWh/yr 1.960556e+05 \n", " GWh/yr 4.938889e+05 \n", " GWh/yr 1.566242e+07 \n", " GWh/yr 8.141417e+06 \n", "\n", " 2035 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.328316e+02 \n", " GW 1.353200e+00 \n", " GW 1.423539e+03 \n", " GW 8.448930e+01 \n", " GW 1.858782e+03 \n", " GW 2.347028e+02 \n", " GW 3.159640e+01 \n", " GW 1.253078e+03 \n", " GW 1.906378e+04 \n", " GW 5.459596e+03 \n", " GWh/yr 9.855833e+05 \n", " GWh/yr 6.444444e+03 \n", " GWh/yr 2.907250e+06 \n", " GWh/yr 6.291111e+05 \n", " GWh/yr 6.423194e+06 \n", " GWh/yr 1.617278e+06 \n", " GWh/yr 6.919444e+04 \n", " GWh/yr 1.204583e+06 \n", " GWh/yr 2.575731e+07 \n", " GWh/yr 1.318953e+07 \n", "\n", " 2040 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.227382e+02 \n", " GW 1.072900e+00 \n", " GW 1.289478e+03 \n", " GW 8.296880e+01 \n", " GW 1.902635e+03 \n", " GW 2.144376e+02 \n", " GW 2.190000e+01 \n", " GW 2.254017e+03 \n", " GW 2.556775e+04 \n", " GW 6.821745e+03 \n", " GWh/yr 1.173833e+06 \n", " GWh/yr 5.027778e+03 \n", " GWh/yr 2.602278e+06 \n", " GWh/yr 6.177778e+05 \n", " GWh/yr 6.604167e+06 \n", " GWh/yr 1.502778e+06 \n", " GWh/yr 4.797222e+04 \n", " GWh/yr 1.985111e+06 \n", " GWh/yr 3.404253e+07 \n", " GWh/yr 1.727517e+07 \n", "\n", " 2045 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.063772e+02 \n", " GW 7.763000e-01 \n", " GW 8.638716e+02 \n", " GW 7.914520e+01 \n", " GW 1.925653e+03 \n", " GW 1.860849e+02 \n", " GW 1.450230e+01 \n", " GW 3.341699e+03 \n", " GW 3.097003e+04 \n", " GW 7.986305e+03 \n", " GWh/yr 1.359639e+06 \n", " GWh/yr 3.694444e+03 \n", " GWh/yr 1.752056e+06 \n", " GWh/yr 5.893056e+05 \n", " GWh/yr 6.717417e+06 \n", " GWh/yr 1.304083e+06 \n", " GWh/yr 3.175000e+04 \n", " GWh/yr 2.790639e+06 \n", " GWh/yr 4.088394e+07 \n", " GWh/yr 2.112919e+07 \n", "\n", " 2050 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 8.602650e+01 \n", " GW 5.029000e-01 \n", " GW 5.628482e+02 \n", " GW 6.966280e+01 \n", " GW 1.933520e+03 \n", " GW 1.567766e+02 \n", " GW 5.341200e+00 \n", " GW 4.267072e+03 \n", " GW 3.608447e+04 \n", " GW 9.064963e+03 \n", " GWh/yr 1.471139e+06 \n", " GWh/yr 2.416667e+03 \n", " GWh/yr 1.218361e+06 \n", " GWh/yr 5.187222e+05 \n", " GWh/yr 6.770250e+06 \n", " GWh/yr 1.098694e+06 \n", " GWh/yr 1.169444e+04 \n", " GWh/yr 3.488083e+06 \n", " GWh/yr 4.723214e+07 \n", " GWh/yr 2.367689e+07 \n", "\n", " 2055 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 6.565480e+01 \n", " GW 3.111000e-01 \n", " GW 3.937209e+02 \n", " GW 5.820210e+01 \n", " GW 1.931110e+03 \n", " GW 1.239472e+02 \n", " GW 3.064300e+00 \n", " GW 4.925403e+03 \n", " GW 4.110399e+04 \n", " GW 9.934779e+03 \n", " GWh/yr 1.513056e+06 \n", " GWh/yr 1.555556e+03 \n", " GWh/yr 6.538889e+05 \n", " GWh/yr 4.333611e+05 \n", " GWh/yr 6.782028e+06 \n", " GWh/yr 8.686111e+05 \n", " GWh/yr 6.722222e+03 \n", " GWh/yr 4.020806e+06 \n", " GWh/yr 5.327061e+07 \n", " GWh/yr 2.569986e+07 \n", "\n", " 2060 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 4.575910e+01 \n", " GW 1.836000e-01 \n", " GW 3.499091e+02 \n", " GW 4.840070e+01 \n", " GW 1.922569e+03 \n", " GW 9.206670e+01 \n", " GW 1.200000e-02 \n", " GW 5.433398e+03 \n", " GW 4.527457e+04 \n", " GW 1.082886e+04 \n", " GWh/yr 1.544750e+06 \n", " GWh/yr 9.444444e+02 \n", " GWh/yr 5.281944e+05 \n", " GWh/yr 3.603889e+05 \n", " GWh/yr 6.775917e+06 \n", " GWh/yr 6.451944e+05 \n", " GWh/yr 2.777778e+01 \n", " GWh/yr 4.434639e+06 \n", " GWh/yr 5.819236e+07 \n", " GWh/yr 2.771675e+07 \n", "\n", " 2070 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 1.450470e+01 \n", " GW 7.830000e-02 \n", " GW 3.063883e+02 \n", " GW 3.927950e+01 \n", " GW 1.893641e+03 \n", " GW 3.877600e+01 \n", " GW 1.200000e-02 \n", " GW 6.432168e+03 \n", " GW 5.443399e+04 \n", " GW 1.320022e+04 \n", " GWh/yr 1.564583e+06 \n", " GWh/yr 4.444444e+02 \n", " GWh/yr 2.423333e+05 \n", " GWh/yr 2.924722e+05 \n", " GWh/yr 6.722667e+06 \n", " GWh/yr 2.717500e+05 \n", " GWh/yr 2.777778e+01 \n", " GWh/yr 5.261472e+06 \n", " GWh/yr 6.826367e+07 \n", " GWh/yr 3.280081e+07 \n", "\n", " 2080 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 3.962800e+00 \n", " GW 9.180000e-02 \n", " GW 2.135970e+02 \n", " GW 3.347930e+01 \n", " GW 1.860861e+03 \n", " GW 8.455000e+00 \n", " GW 1.200000e-02 \n", " GW 7.478326e+03 \n", " GW 6.305545e+04 \n", " GW 1.459313e+04 \n", " GWh/yr 1.557556e+06 \n", " GWh/yr 5.277778e+02 \n", " GWh/yr 1.685833e+05 \n", " GWh/yr 2.492778e+05 \n", " GWh/yr 6.655833e+06 \n", " GWh/yr 5.925000e+04 \n", " GWh/yr 2.777778e+01 \n", " GWh/yr 6.099583e+06 \n", " GWh/yr 7.754106e+07 \n", " GWh/yr 3.570786e+07 \n", "\n", " 2090 \\\n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 8.198000e-01 \n", " GW 9.650000e-02 \n", " GW 5.260450e+01 \n", " GW 2.765300e+01 \n", " GW 1.846102e+03 \n", " GW 5.580000e-01 \n", " GW 1.210000e-02 \n", " GW 8.321384e+03 \n", " GW 6.884808e+04 \n", " GW 1.601071e+04 \n", " GWh/yr 1.543056e+06 \n", " GWh/yr 5.555556e+02 \n", " GWh/yr 4.166667e+04 \n", " GWh/yr 2.059167e+05 \n", " GWh/yr 6.631806e+06 \n", " GWh/yr 3.916667e+03 \n", " GWh/yr 2.777778e+01 \n", " GWh/yr 6.740833e+06 \n", " GWh/yr 8.359456e+07 \n", " GWh/yr 3.840797e+07 \n", "\n", " 2100 \n", "model scenario region variable unit \n", "REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 World Capacity GW 2.150000e-01 \n", " GW 8.660000e-02 \n", " GW 2.717000e-01 \n", " GW 2.601980e+01 \n", " GW 1.805140e+03 \n", " GW 1.900000e-02 \n", " GW 1.260000e-02 \n", " GW 9.334424e+03 \n", " GW 7.743017e+04 \n", " GW 1.736882e+04 \n", " GWh/yr 1.574306e+06 \n", " GWh/yr 5.000000e+02 \n", " GWh/yr 3.888889e+02 \n", " GWh/yr 1.937500e+05 \n", " GWh/yr 6.533167e+06 \n", " GWh/yr 1.388889e+02 \n", " GWh/yr 2.777778e+01 \n", " GWh/yr 7.547194e+06 \n", " GWh/yr 9.270394e+07 \n", " GWh/yr 4.123369e+07 " ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.reset_index().assign(variable=\"Capacity\").set_index(df.index.names)" ] }, { "attachments": {}, "cell_type": "markdown", "id": "63103fb7", "metadata": {}, "source": [ "# Examining level values and level combinations\n", "\n", "We already encountered the possibility to get an overview of the available levels and their values with describelevel:" ] }, { "cell_type": "code", "execution_count": 28, "id": "029603e9", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Index:\n", " * model : REMIND-MAgPIE 2.1-4.3 (1)\n", " * scenario : DeepElec_SSP2_HighRE_Budg900 (1)\n", " * region : World (1)\n", " * variable : Capacity|Electricity|Biomass, ... (20)\n", " * unit : GW, GWh/yr (2)\n", "\n", "Columns:\n", " * : 2005, 2010, 2015, 2020, 2025, 2030, 2035, 2040, ... 2100 (16)\n" ] } ], "source": [ "describelevel(df) # or: df.idx" ] }, { "attachments": {}, "cell_type": "markdown", "id": "5938866f", "metadata": {}, "source": [ "Often it is necessary to get programmatic access to the unique values of one or more levels:" ] }, { "cell_type": "code", "execution_count": 29, "id": "f9fe7174", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Capacity|Electricity|Biomass', 'Capacity|Electricity|Coal',\n", " 'Capacity|Electricity|Gas', 'Capacity|Electricity|Geothermal',\n", " 'Capacity|Electricity|Hydro', 'Capacity|Electricity|Nuclear',\n", " 'Capacity|Electricity|Oil', 'Capacity|Electricity|Other',\n", " 'Capacity|Electricity|Solar', 'Capacity|Electricity|Wind',\n", " 'Secondary Energy|Electricity|Biomass',\n", " 'Secondary Energy|Electricity|Coal', 'Secondary Energy|Electricity|Gas',\n", " 'Secondary Energy|Electricity|Geothermal',\n", " 'Secondary Energy|Electricity|Hydro',\n", " 'Secondary Energy|Electricity|Nuclear',\n", " 'Secondary Energy|Electricity|Oil',\n", " 'Secondary Energy|Electricity|Other',\n", " 'Secondary Energy|Electricity|Solar',\n", " 'Secondary Energy|Electricity|Wind'],\n", " dtype='object', name='variable')" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import uniquelevel\n", "\n", "\n", "uniquelevel(df, \"variable\")\n", "# or: df.pix.unique(\"variable\")\n", "# or in vanilla pandas: df.index.unique(\"variable\")" ] }, { "cell_type": "code", "execution_count": 30, "id": "23378320", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "MultiIndex([( 'Capacity|Electricity|Biomass', 'GW'),\n", " ( 'Capacity|Electricity|Coal', 'GW'),\n", " ( 'Capacity|Electricity|Gas', 'GW'),\n", " ( 'Capacity|Electricity|Geothermal', 'GW'),\n", " ( 'Capacity|Electricity|Hydro', 'GW'),\n", " ( 'Capacity|Electricity|Nuclear', 'GW'),\n", " ( 'Capacity|Electricity|Oil', 'GW'),\n", " ( 'Capacity|Electricity|Other', 'GW'),\n", " ( 'Capacity|Electricity|Solar', 'GW'),\n", " ( 'Capacity|Electricity|Wind', 'GW'),\n", " ( 'Secondary Energy|Electricity|Biomass', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Coal', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Gas', 'GWh/yr'),\n", " ('Secondary Energy|Electricity|Geothermal', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Hydro', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Nuclear', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Oil', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Other', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Solar', 'GWh/yr'),\n", " ( 'Secondary Energy|Electricity|Wind', 'GWh/yr')],\n", " names=['variable', 'unit'])" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "uniquelevel(df, [\"variable\", \"unit\"])" ] }, { "attachments": {}, "cell_type": "markdown", "id": "c84e2a30-1880-4687-b450-6c5b4dac3c01", "metadata": {}, "source": [ "# BEWARE: Pitfalls" ] }, { "attachments": {}, "cell_type": "markdown", "id": "ec137242", "metadata": {}, "source": [ "`concat` ignores level order, so make sure to `reorder_levels` them" ] }, { "cell_type": "code", "execution_count": 31, "id": "24d42af8-ffd3-4281-9d75-1449046fd6fd", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "2030 Coal 182.0149\n", "2040 Coal 1.0729\n", "2050 Coal 0.5029\n", "2060 Coal 0.1836\n", "2030 Gas 1584.4033\n", "2040 Gas 1289.4777\n", "2050 Gas 562.8482\n", "2060 Gas 349.9091\n", "2030 Nuclear 275.5920\n", "2040 Nuclear 214.4376\n", "2050 Nuclear 156.7766\n", "2060 Nuclear 92.0667\n", "dtype: float64" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.concat([simple_fossil_series, simple_fossil_series.swaplevel()])" ] }, { "cell_type": "code", "execution_count": 32, "id": "254197c5-8498-4c69-a30d-044e7edb7b53", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "fuel year\n", "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "dtype: float64" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.concat(\n", " [\n", " simple_fossil_series,\n", " simple_fossil_series.swaplevel().reorder_levels(\n", " simple_fossil_series.index.names\n", " ),\n", " ]\n", ")" ] }, { "attachments": {}, "cell_type": "markdown", "id": "ac53aa0b", "metadata": {}, "source": [ "Therefore, `pandas-indexing` brings a variant which does this automatically:" ] }, { "cell_type": "code", "execution_count": 33, "id": "ef1d54c6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "fuel year\n", "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "Coal 2030 182.0149\n", " 2040 1.0729\n", " 2050 0.5029\n", " 2060 0.1836\n", "Gas 2030 1584.4033\n", " 2040 1289.4777\n", " 2050 562.8482\n", " 2060 349.9091\n", "Nuclear 2030 275.5920\n", " 2040 214.4376\n", " 2050 156.7766\n", " 2060 92.0667\n", "dtype: float64" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pandas_indexing import concat\n", "\n", "\n", "concat([simple_fossil_series, simple_fossil_series.swaplevel()])" ] }, { "attachments": {}, "cell_type": "markdown", "id": "c91c2ef3", "metadata": {}, "source": [ "# Additional helpful multi-index helpers" ] }, { "attachments": {}, "cell_type": "markdown", "id": "46c57e84", "metadata": {}, "source": [ "MultiIndex rendering is often annoying to read, since the important information might get abbreviated away, then converting it into a dataframe is helpful" ] }, { "cell_type": "code", "execution_count": 34, "id": "5b7cb7db", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "MultiIndex([('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...),\n", " ('REMIND-MAgPIE 2.1-4.3', 'DeepElec_SSP2_HighRE_Budg900', ...)],\n", " names=['model', 'scenario', 'fuel'])" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "projectlevel(fossil_series.index, [\"model\", \"scenario\", \"fuel\"])" ] }, { "cell_type": "code", "execution_count": 35, "id": "5b7cb7db", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
modelscenariofuel
0REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Coal
1REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Coal
2REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Coal
3REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Coal
4REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Gas
5REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Gas
6REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Gas
7REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Gas
8REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Nuclear
9REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Nuclear
10REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Nuclear
11REMIND-MAgPIE 2.1-4.3DeepElec_SSP2_HighRE_Budg900Nuclear
\n", "
" ], "text/plain": [ " model scenario fuel\n", "0 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Coal\n", "1 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Coal\n", "2 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Coal\n", "3 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Coal\n", "4 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Gas\n", "5 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Gas\n", "6 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Gas\n", "7 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Gas\n", "8 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Nuclear\n", "9 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Nuclear\n", "10 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Nuclear\n", "11 REMIND-MAgPIE 2.1-4.3 DeepElec_SSP2_HighRE_Budg900 Nuclear" ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "projectlevel(fossil_series.index, [\"model\", \"scenario\", \"fuel\"]).to_frame(index=False)" ] } ], "metadata": { "kernelspec": { "display_name": "pandas-indexing", "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.12.2" }, "vscode": { "interpreter": { "hash": "732ee3529802bbe1f666a01ab0e9ab3b4d171af6c336b5420cf46105d49163f8" } } }, "nbformat": 4, "nbformat_minor": 5 }