Issue with the activated balancing energy prices with the Pandas client

[manesho]

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]

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](#284), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/ABEC63WHEVHD5K2RD7T3R6DYF4MP7AVCNFSM6AAAAAA7XPVEHGVHI2DSMVQWIX3LMV43ASLTON2WKOZSGAYDOOBUGM4DMMA). You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[fboerman]

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?