Example with multiple Indicators and Multiples timeranges.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b56c9b65",
   "metadata": {},
   "outputs": [],
   "source": [
    "from ESIOS import *\n",
    "\n",
    "# Example token, you need to ask for one\n",
    "token = \"46b5dd314fe42be160d24d6363e23099b81db749850fdaf445a01109aa595c97\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "1847adf8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Getting the indicators...\n"
     ]
    }
   ],
   "source": [
    "esios = ESIOS(token)\n",
    "\n",
    "indicators_ = [632, 633, 680, 681, 1777, 1779, 1775, 10258, 14, 10073, 10186]\n",
    "\n",
    "names = esios.get_names(indicators_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d065da0d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b8a348a3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Asignación Banda de regulación secundaria a subir',\n",
       "       'Asignación Banda de regulación secundaria a bajar',\n",
       "       'Energía utilizada de Regulación Secundaria subir',\n",
       "       'Energía utilizada de Regulación Secundaria bajar',\n",
       "       'Previsión diaria D+1 eólica', 'Previsión diaria D+1 fotovoltaica',\n",
       "       'Previsión diaria D+1 demanda', 'Generación programada PBF total',\n",
       "       'Generación programada PBF Solar fotovoltaica',\n",
       "       'Generación programada PBF Eólica',\n",
       "       'Saldo total interconexiones programa PBF'], dtype='<U49')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "812781c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "import pandas as pd\n",
    "\n",
    "start_ = \"01-01-2012T00\"\n",
    "end_ = \"01-01-2022T00\"\n",
    "start_date = datetime.datetime.strptime(start_, \"%d-%m-%YT%H\")\n",
    "end_date = datetime.datetime.strptime(end_, \"%d-%m-%YT%H\")\n",
    "\n",
    "list_dates = [\n",
    "    (f + datetime.timedelta(days=1)).strftime(\"%d-%m-%YT%H\")\n",
    "    for f in pd.date_range(start_date, end_date, freq=\"Y\")\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a4c56003",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "44350095",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['01-01-2013T00',\n",
       " '01-01-2014T00',\n",
       " '01-01-2015T00',\n",
       " '01-01-2016T00',\n",
       " '01-01-2017T00',\n",
       " '01-01-2018T00',\n",
       " '01-01-2019T00',\n",
       " '01-01-2020T00',\n",
       " '01-01-2021T00',\n",
       " '01-01-2022T00']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The API will break if you try to get more than 2 years of data in a single request.\n",
    "list_dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c419dfca",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e0b83f33",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n",
      "Parsing Asignación Banda de regulación secundaria a subir\n",
      "Parsing Asignación Banda de regulación secundaria a bajar\n",
      "Parsing Energía utilizada de Regulación Secundaria subir\n",
      "Parsing Energía utilizada de Regulación Secundaria bajar\n",
      "Parsing Previsión diaria D+1 eólica\n",
      "Parsing Previsión diaria D+1 fotovoltaica\n",
      "Parsing Previsión diaria D+1 demanda\n",
      "Parsing Generación programada PBF total\n",
      "Parsing Generación programada PBF Solar fotovoltaica\n",
      "Parsing Generación programada PBF Eólica\n",
      "Parsing Saldo total interconexiones programa PBF\n"
     ]
    }
   ],
   "source": [
    "lll = []\n",
    "\n",
    "for i in range(len(list_dates) - 1):\n",
    "    sss = list_dates[i]\n",
    "    eee = list_dates[i + 1]\n",
    "    try:\n",
    "        dfmul = esios.get_multiple_series(indicators_, sss, eee)\n",
    "\n",
    "        ff_df = dfmul[0][0]\n",
    "        for i in range(len(dfmul[0])):\n",
    "            df = dfmul[0][i]\n",
    "            if type(df) == type(None):\n",
    "                continue\n",
    "            cols_to_use = list(df.columns.difference(ff_df.columns))\n",
    "            if len(cols_to_use) == 0:\n",
    "                continue\n",
    "            cols_to_use.append([f for f in df.columns if \"datetime\" in f][0])\n",
    "            ff_df = ff_df.merge(\n",
    "                df[cols_to_use], on=\"datetime\", how=\"left\"\n",
    "            ).reset_index(drop=True)\n",
    "        lll.append(ff_df)\n",
    "    except Exception as e:\n",
    "        print(\"wriong\", e)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "23cd182e",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_data = pd.concat(lll).drop_duplicates().reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "13d7d6cf",
   "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>Asignación Banda de regulación secundaria a subir</th>\n",
       "      <th>datetime</th>\n",
       "      <th>tz_time</th>\n",
       "      <th>geo_id</th>\n",
       "      <th>geo_name</th>\n",
       "      <th>Asignación Banda de regulación secundaria a bajar</th>\n",
       "      <th>Energía utilizada de Regulación Secundaria subir</th>\n",
       "      <th>Energía utilizada de Regulación Secundaria bajar</th>\n",
       "      <th>Generación programada PBF total</th>\n",
       "      <th>Generación programada PBF Solar fotovoltaica</th>\n",
       "      <th>Generación programada PBF Eólica</th>\n",
       "      <th>Saldo total interconexiones programa PBF</th>\n",
       "      <th>Previsión diaria D+1 eólica</th>\n",
       "      <th>Previsión diaria D+1 fotovoltaica</th>\n",
       "      <th>Previsión diaria D+1 demanda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>684.0</td>\n",
       "      <td>2014-01-01T00:00:00.000+01:00</td>\n",
       "      <td>2013-12-31T23:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>595.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>209.8</td>\n",
       "      <td>25635.7</td>\n",
       "      <td>13.7</td>\n",
       "      <td>9578.4</td>\n",
       "      <td>-908.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>586.0</td>\n",
       "      <td>2014-01-01T01:00:00.000+01:00</td>\n",
       "      <td>2014-01-01T00:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>496.0</td>\n",
       "      <td>873.3</td>\n",
       "      <td>7.2</td>\n",
       "      <td>24312.6</td>\n",
       "      <td>13.4</td>\n",
       "      <td>9660.4</td>\n",
       "      <td>-1363.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>499.0</td>\n",
       "      <td>2014-01-01T02:00:00.000+01:00</td>\n",
       "      <td>2014-01-01T01:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>499.0</td>\n",
       "      <td>481.2</td>\n",
       "      <td>5.9</td>\n",
       "      <td>23271.7</td>\n",
       "      <td>13.4</td>\n",
       "      <td>9583.0</td>\n",
       "      <td>-1745.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>497.0</td>\n",
       "      <td>2014-01-01T03:00:00.000+01:00</td>\n",
       "      <td>2014-01-01T02:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>384.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>217.5</td>\n",
       "      <td>21264.9</td>\n",
       "      <td>12.3</td>\n",
       "      <td>9250.3</td>\n",
       "      <td>-1322.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>496.0</td>\n",
       "      <td>2014-01-01T04:00:00.000+01:00</td>\n",
       "      <td>2014-01-01T03:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>381.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>165.9</td>\n",
       "      <td>21108.2</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9263.4</td>\n",
       "      <td>-1590.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70124</th>\n",
       "      <td>694.0</td>\n",
       "      <td>2021-12-31T20:00:00.000+01:00</td>\n",
       "      <td>2021-12-31T19:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>496.0</td>\n",
       "      <td>155.3</td>\n",
       "      <td>29.3</td>\n",
       "      <td>21814.1</td>\n",
       "      <td>42.3</td>\n",
       "      <td>6337.9</td>\n",
       "      <td>4473.6</td>\n",
       "      <td>5570.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26622.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70125</th>\n",
       "      <td>495.0</td>\n",
       "      <td>2021-12-31T21:00:00.000+01:00</td>\n",
       "      <td>2021-12-31T20:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>594.0</td>\n",
       "      <td>149.6</td>\n",
       "      <td>69.6</td>\n",
       "      <td>21243.3</td>\n",
       "      <td>10.7</td>\n",
       "      <td>6396.9</td>\n",
       "      <td>3812.9</td>\n",
       "      <td>5749.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25473.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70126</th>\n",
       "      <td>495.0</td>\n",
       "      <td>2021-12-31T22:00:00.000+01:00</td>\n",
       "      <td>2021-12-31T21:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>595.0</td>\n",
       "      <td>53.6</td>\n",
       "      <td>145.8</td>\n",
       "      <td>20339.4</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6497.9</td>\n",
       "      <td>2501.8</td>\n",
       "      <td>5853.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22964.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70127</th>\n",
       "      <td>491.0</td>\n",
       "      <td>2021-12-31T23:00:00.000+01:00</td>\n",
       "      <td>2021-12-31T22:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>594.0</td>\n",
       "      <td>98.8</td>\n",
       "      <td>27.7</td>\n",
       "      <td>19627.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6545.1</td>\n",
       "      <td>2178.4</td>\n",
       "      <td>5953.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21860.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70128</th>\n",
       "      <td>496.0</td>\n",
       "      <td>2022-01-01T00:00:00.000+01:00</td>\n",
       "      <td>2021-12-31T23:00:00.000Z</td>\n",
       "      <td>8741</td>\n",
       "      <td>Península</td>\n",
       "      <td>498.0</td>\n",
       "      <td>186.9</td>\n",
       "      <td>41.4</td>\n",
       "      <td>19553.3</td>\n",
       "      <td>77.3</td>\n",
       "      <td>7061.7</td>\n",
       "      <td>2052.8</td>\n",
       "      <td>6365.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21705.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70129 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Asignación Banda de regulación secundaria a subir  \\\n",
       "0                                                  684.0   \n",
       "1                                                  586.0   \n",
       "2                                                  499.0   \n",
       "3                                                  497.0   \n",
       "4                                                  496.0   \n",
       "...                                                  ...   \n",
       "70124                                              694.0   \n",
       "70125                                              495.0   \n",
       "70126                                              495.0   \n",
       "70127                                              491.0   \n",
       "70128                                              496.0   \n",
       "\n",
       "                            datetime                   tz_time  geo_id  \\\n",
       "0      2014-01-01T00:00:00.000+01:00  2013-12-31T23:00:00.000Z    8741   \n",
       "1      2014-01-01T01:00:00.000+01:00  2014-01-01T00:00:00.000Z    8741   \n",
       "2      2014-01-01T02:00:00.000+01:00  2014-01-01T01:00:00.000Z    8741   \n",
       "3      2014-01-01T03:00:00.000+01:00  2014-01-01T02:00:00.000Z    8741   \n",
       "4      2014-01-01T04:00:00.000+01:00  2014-01-01T03:00:00.000Z    8741   \n",
       "...                              ...                       ...     ...   \n",
       "70124  2021-12-31T20:00:00.000+01:00  2021-12-31T19:00:00.000Z    8741   \n",
       "70125  2021-12-31T21:00:00.000+01:00  2021-12-31T20:00:00.000Z    8741   \n",
       "70126  2021-12-31T22:00:00.000+01:00  2021-12-31T21:00:00.000Z    8741   \n",
       "70127  2021-12-31T23:00:00.000+01:00  2021-12-31T22:00:00.000Z    8741   \n",
       "70128  2022-01-01T00:00:00.000+01:00  2021-12-31T23:00:00.000Z    8741   \n",
       "\n",
       "        geo_name  Asignación Banda de regulación secundaria a bajar  \\\n",
       "0      Península                                              595.0   \n",
       "1      Península                                              496.0   \n",
       "2      Península                                              499.0   \n",
       "3      Península                                              384.0   \n",
       "4      Península                                              381.0   \n",
       "...          ...                                                ...   \n",
       "70124  Península                                              496.0   \n",
       "70125  Península                                              594.0   \n",
       "70126  Península                                              595.0   \n",
       "70127  Península                                              594.0   \n",
       "70128  Península                                              498.0   \n",
       "\n",
       "       Energía utilizada de Regulación Secundaria subir  \\\n",
       "0                                                  57.2   \n",
       "1                                                 873.3   \n",
       "2                                                 481.2   \n",
       "3                                                  13.9   \n",
       "4                                                   0.0   \n",
       "...                                                 ...   \n",
       "70124                                             155.3   \n",
       "70125                                             149.6   \n",
       "70126                                              53.6   \n",
       "70127                                              98.8   \n",
       "70128                                             186.9   \n",
       "\n",
       "       Energía utilizada de Regulación Secundaria bajar  \\\n",
       "0                                                 209.8   \n",
       "1                                                   7.2   \n",
       "2                                                   5.9   \n",
       "3                                                 217.5   \n",
       "4                                                 165.9   \n",
       "...                                                 ...   \n",
       "70124                                              29.3   \n",
       "70125                                              69.6   \n",
       "70126                                             145.8   \n",
       "70127                                              27.7   \n",
       "70128                                              41.4   \n",
       "\n",
       "       Generación programada PBF total  \\\n",
       "0                              25635.7   \n",
       "1                              24312.6   \n",
       "2                              23271.7   \n",
       "3                              21264.9   \n",
       "4                              21108.2   \n",
       "...                                ...   \n",
       "70124                          21814.1   \n",
       "70125                          21243.3   \n",
       "70126                          20339.4   \n",
       "70127                          19627.0   \n",
       "70128                          19553.3   \n",
       "\n",
       "       Generación programada PBF Solar fotovoltaica  \\\n",
       "0                                              13.7   \n",
       "1                                              13.4   \n",
       "2                                              13.4   \n",
       "3                                              12.3   \n",
       "4                                              12.0   \n",
       "...                                             ...   \n",
       "70124                                          42.3   \n",
       "70125                                          10.7   \n",
       "70126                                           6.5   \n",
       "70127                                           6.4   \n",
       "70128                                          77.3   \n",
       "\n",
       "       Generación programada PBF Eólica  \\\n",
       "0                                9578.4   \n",
       "1                                9660.4   \n",
       "2                                9583.0   \n",
       "3                                9250.3   \n",
       "4                                9263.4   \n",
       "...                                 ...   \n",
       "70124                            6337.9   \n",
       "70125                            6396.9   \n",
       "70126                            6497.9   \n",
       "70127                            6545.1   \n",
       "70128                            7061.7   \n",
       "\n",
       "       Saldo total interconexiones programa PBF  Previsión diaria D+1 eólica  \\\n",
       "0                                        -908.2                          NaN   \n",
       "1                                       -1363.7                          NaN   \n",
       "2                                       -1745.5                          NaN   \n",
       "3                                       -1322.9                          NaN   \n",
       "4                                       -1590.1                          NaN   \n",
       "...                                         ...                          ...   \n",
       "70124                                    4473.6                       5570.0   \n",
       "70125                                    3812.9                       5749.0   \n",
       "70126                                    2501.8                       5853.0   \n",
       "70127                                    2178.4                       5953.0   \n",
       "70128                                    2052.8                       6365.0   \n",
       "\n",
       "       Previsión diaria D+1 fotovoltaica  Previsión diaria D+1 demanda  \n",
       "0                                    NaN                           NaN  \n",
       "1                                    NaN                           NaN  \n",
       "2                                    NaN                           NaN  \n",
       "3                                    NaN                           NaN  \n",
       "4                                    NaN                           NaN  \n",
       "...                                  ...                           ...  \n",
       "70124                                0.0                       26622.0  \n",
       "70125                                0.0                       25473.0  \n",
       "70126                                0.0                       22964.0  \n",
       "70127                                0.0                       21860.0  \n",
       "70128                                0.0                       21705.0  \n",
       "\n",
       "[70129 rows x 15 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0833d328",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ab59dbc3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}