Pandas Expressions

from esios import ESIOSClient

client = ESIOSClient()

handle = client.indicators.get(600)
df = handle.historical("2025-01-01", "2025-01-31")
df.head()

                           Portugal  Francia  España  Alemania  Bélgica  Países Bajos
datetime
2025-01-01 00:00:00+01:00    134.49    12.36  134.49      2.16    10.62         13.62
...

df.resample("D").mean().round(2)

                           Portugal  Francia  España  Alemania  Bélgica  Países Bajos
datetime
2025-01-01 00:00:00+01:00    103.62    22.59  100.93      0.95    22.14         35.70
2025-01-02 00:00:00+01:00    134.38   107.69  134.02     92.91   113.18        132.28
...

df["España"].rolling(24).mean().plot(
    figsize=(12, 4),
    title="24h Rolling Average — España",
)

df[df["España"] < 0]

df["España"].describe().round(2)

count    2976.00
mean       96.69
std        48.50
min         0.00
25%        60.08
50%       110.29
75%       131.88
max       225.00
Name: España, dtype: float64

hourly = df.copy()
hourly["hour"] = hourly.index.hour
hourly.groupby("hour")["España"].mean().round(2).plot.bar(
    figsize=(12, 4),
    title="Average Price by Hour — España (€/MWh)",
)