search

OSUKED / ElexonDataPortal

Python wrapper for the Elexon/BMRS API
https://osuked.github.io/ElexonDataPortal
MIT License
52 stars 14 forks source link

B1610 report issue #21

Open ghost opened 1 year ago

ghost commented 1 year ago

Hi gang,

First of all, thanks for producing such a useful module - your hard work is appreciated!

We've had an issue with using the B1610 report - an error is returned when running the B1610 report for COWE1 for 2016, there seem to be a couple of columns generated in the output table called '0' and '1', which is breaking when calling col.lower() in orchestrator.py

Not had a chance to work out if it's garbage output from Elexon or something in the ElexonDataPortal module but thought you might be interested to know in case you want to smooth it out?

robhawkes commented 1 year ago

I'm also hitting this issue, the orchestrator crashes out on this line which correlates with the original report that the column names are integers.

For debugging purposes I've seen this issue during these date ranges so far:

I've been scraping all B1610 data on a weekly basis since 2023 and only started seeing the error for two weeks in mid-2018 and a few weeks at the start of 2015. I haven't processed any data before 2015 yet but will update as I do.

I'm not sure why there are columns with integers for those dates but perhaps a workaround in the meantime is to cast the column names to strings before running col.lower().