Generation and Demand

from esios import ESIOSClient

client = ESIOSClient()

ids = [73, 74, 79, 10008, 10010, 10063]

df = client.indicators.compare(
    ids,
    start="2025-01-01",
    end="2025-01-07",
)
df

                           Generación programada P48 Turbinación bombeo  ...
datetime
2025-01-01 00:00:00+01:00                                        39.250  ...
...
[672 rows × 6 columns]

gen_cols = [c for c in df.columns if c != df.columns[-1]]
df[gen_cols].resample("h").mean().plot.area(
    figsize=(14, 6),
    title="Generation Mix (MW) — January 2025",
    alpha=0.7,
)

df_daily = df.resample("D").mean().round(1)
df_daily

                           Generación programada P48 Turbinación bombeo  ...
datetime
2025-01-01 00:00:00+01:00                                         130.8  ...
2025-01-02 00:00:00+01:00                                         156.1  ...
...

df.to_csv("generation_2025_01.csv")