tutorial.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Welcome to Delta -E\n",
    "<div style=\"width:500px; height:500px\">\n",
    "\n",
    "![section1 image](https://github.com/DeltaE/delta-e-utils/blob/e32dd3014d6ab317d3e852b03a40e5af3ef92dcf/docs/_static/logo.png?raw=true)\n",
    "\n",
    "</div>\n",
    "\n",
    "In this small example, we will learn how to use delta-e pacakage. \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Installing development version from github repo\n",
    "\n",
    "`pip install .`\n",
    "\n",
    "Intsalling from pip\n",
    "\n",
    "`pip install delta-e`\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from delta_e.utils import FileReader\n",
    "import pandas as pd\n",
    "from pathlib import Path"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "**One of our notable attributes is the ability to generate specialized sub-packages tailored to the specific requirements of each dataset.**\n",
    "\n",
    "An example of such a sub-package is the EPAEmissions package.\n",
    "\n",
    "https://delta-e.readthedocs.io/en/latest/api/delta_e.EPAEmissions.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from delta_e.EPAEmissions.EPAEmissions import EpaEmissions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Function to get the global warming potential adjusted emissions.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50.3458"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "epa = EpaEmissions()\n",
    "gwp = epa.get_gwp()\n",
    "gwp.loc['Natural Gas', ('co2_eq', 'kT/PJ')]\n",
    "# Output: 50.3 # kT / PJ"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Creates emission activity ratio dataframe for OSeMOSYS Models.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>REGION</th>\n",
       "      <th>TECHNOLOGY</th>\n",
       "      <th>EMISSION</th>\n",
       "      <th>MODE_OF_OPERATION</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>VALUE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BC</td>\n",
       "      <td>GAS</td>\n",
       "      <td>co2</td>\n",
       "      <td>1</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BC</td>\n",
       "      <td>GAS</td>\n",
       "      <td>co2</td>\n",
       "      <td>1</td>\n",
       "      <td>2021</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BC</td>\n",
       "      <td>GAS</td>\n",
       "      <td>co2</td>\n",
       "      <td>2</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BC</td>\n",
       "      <td>GAS</td>\n",
       "      <td>co2</td>\n",
       "      <td>2</td>\n",
       "      <td>2021</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  REGION TECHNOLOGY EMISSION  MODE_OF_OPERATION  YEAR  VALUE\n",
       "0     BC        GAS      co2                  1  2020    NaN\n",
       "1     BC        GAS      co2                  1  2021    NaN\n",
       "2     BC        GAS      co2                  2  2020    NaN\n",
       "3     BC        GAS      co2                  2  2021    NaN"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "epa.get_osemosys_emissions(\n",
    "        epa_fuel='Natural Gas',\n",
    "        regions=['BC'],\n",
    "        technologies=['GAS'],\n",
    "        emissions=['co2'],\n",
    "        modes=[1,2],\n",
    "        years=[2020,2021])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**List of available fuels**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Anthracite Coal',\n",
       " 'Bituminous Coal',\n",
       " 'Sub-bituminous Coal',\n",
       " 'Lignite Coal',\n",
       " 'Mixed (Commercial Sector)',\n",
       " 'Mixed (Electric Power Sector)',\n",
       " 'Mixed (Industrial Coking)',\n",
       " 'Mixed (Industrial Sector)',\n",
       " 'Coal Coke',\n",
       " 'Municipal Solid Waste',\n",
       " 'Petroleum Coke (Solid)',\n",
       " 'Plastics',\n",
       " 'Tires',\n",
       " 'Agricultural Byproducts',\n",
       " 'Peat',\n",
       " 'Solid Byproducts',\n",
       " 'Wood and Wood Residuals',\n",
       " 'Natural Gas',\n",
       " 'Blast Furnace Gas',\n",
       " 'Coke Oven Gas',\n",
       " 'Fuel Gas',\n",
       " 'Propane Gas',\n",
       " 'Landfill Gas',\n",
       " 'Other Biomass Gases',\n",
       " 'Asphalt and Road Oil',\n",
       " 'Aviation Gasoline',\n",
       " 'Butane',\n",
       " 'Butylene',\n",
       " 'Crude Oil',\n",
       " 'Distillate Fuel Oil No. 1',\n",
       " 'Distillate Fuel Oil No. 2',\n",
       " 'Distillate Fuel Oil No. 4',\n",
       " 'Ethane',\n",
       " 'Ethylene',\n",
       " 'Heavy Gas Oils',\n",
       " 'Isobutane',\n",
       " 'Isobutylene',\n",
       " 'Kerosene',\n",
       " 'Kerosene-Type Jet Fuel',\n",
       " 'Liquefied Petroleum Gases (LPG)',\n",
       " 'Lubricants',\n",
       " 'Motor Gasoline',\n",
       " 'Naphtha (<401 deg F)',\n",
       " 'Natural Gasoline',\n",
       " 'Other Oil (>401 deg F)',\n",
       " 'Pentanes Plus',\n",
       " 'Petrochemical Feedstocks',\n",
       " 'Petroleum Coke',\n",
       " 'Propane',\n",
       " 'Propylene',\n",
       " 'Residual Fuel Oil No. 5',\n",
       " 'Residual Fuel Oil No. 6',\n",
       " 'Special Naphtha',\n",
       " 'Unfinished Oils',\n",
       " 'Used Oil',\n",
       " 'Biodiesel (100%)',\n",
       " 'Ethanol (100%)',\n",
       " 'Rendered Animal Fat',\n",
       " 'Vegetable Oil',\n",
       " 'North American Softwood',\n",
       " 'North American Hardwood',\n",
       " 'Bagasse',\n",
       " 'Bamboo',\n",
       " 'Straw']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "epa.get_available_fuels()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ___Utility functions for delta_e___\n",
    "\n",
    "\n",
    "#### delta_e.utils.FileReader(filepath: str | Path)\n",
    "\n",
    "Reads in raw data.\n",
    "\n",
    "    get_data() → DataFrame\n",
    "\n",
    "Reads data to a pandas dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from delta_e.utils import FileReader\n",
    "import os\n",
    "\n",
    "# Reading in the file using our inbuilt file reader\n",
    "# Only supporting CSV's currently\n",
    "# Local File\n",
    "file_path = Path(\"epa_emissions.csv\")\n",
    "data = FileReader(file_path,isUrl=False).get_data()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\Natsu\\miniconda3\\envs\\delta-e\\lib\\site-packages\\delta_e\\utils.py:77: DtypeWarning: Columns (9,10,13,14,17) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  data = pd.read_csv(self.file_path)\n"
     ]
    }
   ],
   "source": [
    "# Online File\n",
    "online_data = FileReader(\"https://oedi-data-lake.s3.amazonaws.com/ATB/electricity/csv/2023/ATBe.csv\",isUrl=True).get_data()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Since, its a panda datframe any and all functions asscociated with pandas library can be used here.\n",
    "type(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FUEL</th>\n",
       "      <th>co2_factor</th>\n",
       "      <th>ch4_factor</th>\n",
       "      <th>n2o_factor</th>\n",
       "      <th>co2_gwp</th>\n",
       "      <th>ch4_gwp</th>\n",
       "      <th>n2o_gwp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UNIT</td>\n",
       "      <td>kg_per_mmBtu</td>\n",
       "      <td>g_per_mmBtu</td>\n",
       "      <td>g_per_mmBtu</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Anthracite Coal</td>\n",
       "      <td>103.69</td>\n",
       "      <td>11</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bituminous Coal</td>\n",
       "      <td>93.28</td>\n",
       "      <td>11</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sub-bituminous Coal</td>\n",
       "      <td>97.17</td>\n",
       "      <td>11</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lignite Coal</td>\n",
       "      <td>97.72</td>\n",
       "      <td>11</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>North American Softwood</td>\n",
       "      <td>94.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>North American Hardwood</td>\n",
       "      <td>93.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Bagasse</td>\n",
       "      <td>95.5</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Bamboo</td>\n",
       "      <td>93.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Straw</td>\n",
       "      <td>95.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       FUEL    co2_factor   ch4_factor   n2o_factor co2_gwp  \\\n",
       "0                      UNIT  kg_per_mmBtu  g_per_mmBtu  g_per_mmBtu      na   \n",
       "1           Anthracite Coal        103.69           11          1.6       1   \n",
       "2           Bituminous Coal         93.28           11          1.6       1   \n",
       "3       Sub-bituminous Coal         97.17           11          1.6       1   \n",
       "4              Lignite Coal         97.72           11          1.6       1   \n",
       "..                      ...           ...          ...          ...     ...   \n",
       "60  North American Softwood          94.4          1.9         0.42       1   \n",
       "61  North American Hardwood          93.7          1.9         0.42       1   \n",
       "62                  Bagasse          95.5          1.9         0.42       1   \n",
       "63                   Bamboo          93.7          1.9         0.42       1   \n",
       "64                    Straw          95.1          1.9         0.42       1   \n",
       "\n",
       "   ch4_gwp n2o_gwp  \n",
       "0       na      na  \n",
       "1       25     298  \n",
       "2       25     298  \n",
       "3       25     298  \n",
       "4       25     298  \n",
       "..     ...     ...  \n",
       "60      25     298  \n",
       "61      25     298  \n",
       "62      25     298  \n",
       "63      25     298  \n",
       "64      25     298  \n",
       "\n",
       "[65 rows x 7 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>atb_year</th>\n",
       "      <th>core_metric_key</th>\n",
       "      <th>core_metric_parameter</th>\n",
       "      <th>core_metric_case</th>\n",
       "      <th>crpyears</th>\n",
       "      <th>technology</th>\n",
       "      <th>technology_alias</th>\n",
       "      <th>techdetail</th>\n",
       "      <th>techdetail2</th>\n",
       "      <th>resourcedetail</th>\n",
       "      <th>display_name</th>\n",
       "      <th>default</th>\n",
       "      <th>scale</th>\n",
       "      <th>maturity</th>\n",
       "      <th>scenario</th>\n",
       "      <th>core_metric_variable</th>\n",
       "      <th>units</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "      <td>M100CAPEXHHNPD1A21</td>\n",
       "      <td>CAPEX</td>\n",
       "      <td>Market</td>\n",
       "      <td>100</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>NPD1</td>\n",
       "      <td>NPD 1</td>\n",
       "      <td>Hydropower - Lake</td>\n",
       "      <td>Hydropower - NPD 1</td>\n",
       "      <td>1</td>\n",
       "      <td>Utility</td>\n",
       "      <td>Y</td>\n",
       "      <td>Advanced</td>\n",
       "      <td>2021</td>\n",
       "      <td>$/kW</td>\n",
       "      <td>3007.709653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2023</td>\n",
       "      <td>M100CAPEXHHNPD1A22</td>\n",
       "      <td>CAPEX</td>\n",
       "      <td>Market</td>\n",
       "      <td>100</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>NPD1</td>\n",
       "      <td>NPD 1</td>\n",
       "      <td>Hydropower - Lake</td>\n",
       "      <td>Hydropower - NPD 1</td>\n",
       "      <td>1</td>\n",
       "      <td>Utility</td>\n",
       "      <td>Y</td>\n",
       "      <td>Advanced</td>\n",
       "      <td>2022</td>\n",
       "      <td>$/kW</td>\n",
       "      <td>3007.709653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2023</td>\n",
       "      <td>M100CAPEXHHNPD1A23</td>\n",
       "      <td>CAPEX</td>\n",
       "      <td>Market</td>\n",
       "      <td>100</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>NPD1</td>\n",
       "      <td>NPD 1</td>\n",
       "      <td>Hydropower - Lake</td>\n",
       "      <td>Hydropower - NPD 1</td>\n",
       "      <td>1</td>\n",
       "      <td>Utility</td>\n",
       "      <td>Y</td>\n",
       "      <td>Advanced</td>\n",
       "      <td>2023</td>\n",
       "      <td>$/kW</td>\n",
       "      <td>3007.709653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2023</td>\n",
       "      <td>M100CAPEXHHNPD1A24</td>\n",
       "      <td>CAPEX</td>\n",
       "      <td>Market</td>\n",
       "      <td>100</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>NPD1</td>\n",
       "      <td>NPD 1</td>\n",
       "      <td>Hydropower - Lake</td>\n",
       "      <td>Hydropower - NPD 1</td>\n",
       "      <td>1</td>\n",
       "      <td>Utility</td>\n",
       "      <td>Y</td>\n",
       "      <td>Advanced</td>\n",
       "      <td>2024</td>\n",
       "      <td>$/kW</td>\n",
       "      <td>3007.709653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2023</td>\n",
       "      <td>M100CAPEXHHNPD1A25</td>\n",
       "      <td>CAPEX</td>\n",
       "      <td>Market</td>\n",
       "      <td>100</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>Hydropower</td>\n",
       "      <td>NPD1</td>\n",
       "      <td>NPD 1</td>\n",
       "      <td>Hydropower - Lake</td>\n",
       "      <td>Hydropower - NPD 1</td>\n",
       "      <td>1</td>\n",
       "      <td>Utility</td>\n",
       "      <td>Y</td>\n",
       "      <td>Advanced</td>\n",
       "      <td>2025</td>\n",
       "      <td>$/kW</td>\n",
       "      <td>3007.709653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508639</th>\n",
       "      <td>508639</td>\n",
       "      <td>2023</td>\n",
       "      <td>R75WACCRCFEM46</td>\n",
       "      <td>WACC Real</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>75</td>\n",
       "      <td>Coal_FE</td>\n",
       "      <td>Coal</td>\n",
       "      <td>*</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>2046</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508640</th>\n",
       "      <td>508640</td>\n",
       "      <td>2023</td>\n",
       "      <td>R75WACCRCFEM47</td>\n",
       "      <td>WACC Real</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>75</td>\n",
       "      <td>Coal_FE</td>\n",
       "      <td>Coal</td>\n",
       "      <td>*</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>2047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508641</th>\n",
       "      <td>508641</td>\n",
       "      <td>2023</td>\n",
       "      <td>R75WACCRCFEM48</td>\n",
       "      <td>WACC Real</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>75</td>\n",
       "      <td>Coal_FE</td>\n",
       "      <td>Coal</td>\n",
       "      <td>*</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>2048</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508642</th>\n",
       "      <td>508642</td>\n",
       "      <td>2023</td>\n",
       "      <td>R75WACCRCFEM49</td>\n",
       "      <td>WACC Real</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>75</td>\n",
       "      <td>Coal_FE</td>\n",
       "      <td>Coal</td>\n",
       "      <td>*</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>2049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508643</th>\n",
       "      <td>508643</td>\n",
       "      <td>2023</td>\n",
       "      <td>R75WACCRCFEM50</td>\n",
       "      <td>WACC Real</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>75</td>\n",
       "      <td>Coal_FE</td>\n",
       "      <td>Coal</td>\n",
       "      <td>*</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>2050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055780</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>508644 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0  atb_year     core_metric_key core_metric_parameter  \\\n",
       "0                0      2023  M100CAPEXHHNPD1A21                 CAPEX   \n",
       "1                1      2023  M100CAPEXHHNPD1A22                 CAPEX   \n",
       "2                2      2023  M100CAPEXHHNPD1A23                 CAPEX   \n",
       "3                3      2023  M100CAPEXHHNPD1A24                 CAPEX   \n",
       "4                4      2023  M100CAPEXHHNPD1A25                 CAPEX   \n",
       "...            ...       ...                 ...                   ...   \n",
       "508639      508639      2023      R75WACCRCFEM46             WACC Real   \n",
       "508640      508640      2023      R75WACCRCFEM47             WACC Real   \n",
       "508641      508641      2023      R75WACCRCFEM48             WACC Real   \n",
       "508642      508642      2023      R75WACCRCFEM49             WACC Real   \n",
       "508643      508643      2023      R75WACCRCFEM50             WACC Real   \n",
       "\n",
       "       core_metric_case  crpyears  technology technology_alias techdetail  \\\n",
       "0                Market       100  Hydropower       Hydropower       NPD1   \n",
       "1                Market       100  Hydropower       Hydropower       NPD1   \n",
       "2                Market       100  Hydropower       Hydropower       NPD1   \n",
       "3                Market       100  Hydropower       Hydropower       NPD1   \n",
       "4                Market       100  Hydropower       Hydropower       NPD1   \n",
       "...                 ...       ...         ...              ...        ...   \n",
       "508639              R&D        75     Coal_FE             Coal          *   \n",
       "508640              R&D        75     Coal_FE             Coal          *   \n",
       "508641              R&D        75     Coal_FE             Coal          *   \n",
       "508642              R&D        75     Coal_FE             Coal          *   \n",
       "508643              R&D        75     Coal_FE             Coal          *   \n",
       "\n",
       "       techdetail2     resourcedetail        display_name  default    scale  \\\n",
       "0            NPD 1  Hydropower - Lake  Hydropower - NPD 1        1  Utility   \n",
       "1            NPD 1  Hydropower - Lake  Hydropower - NPD 1        1  Utility   \n",
       "2            NPD 1  Hydropower - Lake  Hydropower - NPD 1        1  Utility   \n",
       "3            NPD 1  Hydropower - Lake  Hydropower - NPD 1        1  Utility   \n",
       "4            NPD 1  Hydropower - Lake  Hydropower - NPD 1        1  Utility   \n",
       "...            ...                ...                 ...      ...      ...   \n",
       "508639         NaN                NaN                   *        0      NaN   \n",
       "508640         NaN                NaN                   *        0      NaN   \n",
       "508641         NaN                NaN                   *        0      NaN   \n",
       "508642         NaN                NaN                   *        0      NaN   \n",
       "508643         NaN                NaN                   *        0      NaN   \n",
       "\n",
       "       maturity  scenario  core_metric_variable units        value  \n",
       "0             Y  Advanced                  2021  $/kW  3007.709653  \n",
       "1             Y  Advanced                  2022  $/kW  3007.709653  \n",
       "2             Y  Advanced                  2023  $/kW  3007.709653  \n",
       "3             Y  Advanced                  2024  $/kW  3007.709653  \n",
       "4             Y  Advanced                  2025  $/kW  3007.709653  \n",
       "...         ...       ...                   ...   ...          ...  \n",
       "508639      NaN  Moderate                  2046   NaN     0.055780  \n",
       "508640      NaN  Moderate                  2047   NaN     0.055780  \n",
       "508641      NaN  Moderate                  2048   NaN     0.055780  \n",
       "508642      NaN  Moderate                  2049   NaN     0.055780  \n",
       "508643      NaN  Moderate                  2050   NaN     0.055780  \n",
       "\n",
       "[508644 rows x 19 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "online_data"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "delta-e",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.17"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}