I'm trying to get a table from this url
So this url returns prices at a specific date, but I need to get prices from the whole year, which is possible by pressing exportdata --> Day-ahead Prices [12.1.D] (Year, XML)
I checked the buttons attributes which were dataitem="DAY_AHEAD_PRICES" timerange="YEAR" exporttype="XML">Day-ahead Prices [12.1.D] (Year, XML)
And tried using them
def extract_from_url():
table = pd.read_html(url, attrs={"timerange": "YEAR", "dataitem": "DAY_AHEAD_PRICES", "exporttype": "XML"})
return table
It returns no tables were found, but if I were to remove those attributes it would return prices of the specific date fine. [here is the html of the webpage and specific table I need]
