search

EnergieID / entsoe-py

Python client for the ENTSO-E API (european network of transmission system operators for electricity)
MIT License
401 stars 179 forks source link

Issue with the activated balancing energy prices with the Pandas client #284

Open manesho opened 8 months ago

manesho commented 8 months ago

Hi,

There seems to be an issue with the activated balancing energy prices - at least for switzerland - in the pandas client. In the resulting dataframe, each timestamp appears only once and wether it contains the price for Up or Down seems somewhat random.

EntsoePandasClient.query_activated_balancing_energy_prices('CH', 
     start=pd.Timestamp('2023-11-21 0:00', tz='CET'),
     end=pd.Timestamp('2023-11-21 3:00', tz='CET'),)
Direction Price
2023-11-21 00:00:00+01:00 Up 138.31
2023-11-21 00:15:00+01:00 Up 120.02
2023-11-21 00:30:00+01:00 Up 120.02
2023-11-21 00:45:00+01:00 Up 0
2023-11-21 01:00:00+01:00 Up 121.99
2023-11-21 01:15:00+01:00 Down 72.8
2023-11-21 01:30:00+01:00 Down 72.68
2023-11-21 01:45:00+01:00 Down 71.11
2023-11-21 02:00:00+01:00 Down 70
2023-11-21 02:15:00+01:00 Down 69.91
2023-11-21 02:30:00+01:00 Down 70.04
2023-11-21 02:45:00+01:00 Up 120

The raw client on the otherhand works fine.

btw: thanks for the great api-client!

fboerman commented 8 months ago

Ah yeah there is a bug which removes to many entries when dedupping. Will need to fix that when I get back from leave.

-------- Original Message -------- On 23 Nov 2023, 09:55, manesho wrote:

Hi,

There seems to be an issue with the activated balancing energy prices - at least for switzerland - in the pandas client. In the resulting dataframe, each timestamp appears only once and wether it contains the price for Up or Down seems somewhat random.

EntsoePandasClient.query_activated_balancing_energy_prices('CH', start=pd.Timestamp('2023-11-21 0:00', tz='CET'), end=pd.Timestamp('2023-11-21 3:00', tz='CET'),)

Direction Price 2023-11-21 00:00:00+01:00 Up 138.31 2023-11-21 00:15:00+01:00 Up 120.02 2023-11-21 00:30:00+01:00 Up 120.02 2023-11-21 00:45:00+01:00 Up 0 2023-11-21 01:00:00+01:00 Up 121.99 2023-11-21 01:15:00+01:00 Down 72.8 2023-11-21 01:30:00+01:00 Down 72.68 2023-11-21 01:45:00+01:00 Down 71.11 2023-11-21 02:00:00+01:00 Down 70 2023-11-21 02:15:00+01:00 Down 69.91 2023-11-21 02:30:00+01:00 Down 70.04 2023-11-21 02:45:00+01:00 Up 120

The raw client on the otherhand works fine.

btw: thanks for the great api-client!

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.Message ID: @.***>

fboerman commented 6 months ago

hi @manesho thanks again for the report (and the kind words). the dedup issue was fixed in a recent pull request with some great community help. However I still saw some deduplication. After some investigation I concluded that a column was missing. I find the UI on this topic a bit confusing, but I think I got the data right now. Could you check with the latest release and get back to me if its fixed like this?