import requests import pandas as pd
url = "https://www.nord-stream.info/ajax.php"
operations = nom (Nomination), flow (Physical Flow), gcv (Gross Calorific Value), wobi (Wobbe Index) timefrom/timeto = YYYY-MM-DD sort = True (Ascending) / False (Descending)
""" operations = input("Operations: Nomination (nom), Physical Flow (flow), Gross Calorific Value (gcv) or Wobbe Index (wobi)?: ") time_from = input("Time From (YYYY-MM-DD): ") time_to = input("Time To (YYYY-MM-DD): ") sort = input("Sort by Ascending (true) or Descending (false) order?: ") basis = input("Hourly or Daily?: ") payload = f"start=0&timefrom={time_from}&timeto={time_to}&show={operations}&sort={sort}&basis={basis}" headers = {"Content-Type": "application/x-www-form-urlencoded; charset=UTF-8"}
r = requests.request("POST", url, data=payload, headers=headers)
nord_stream_data = r.json()
data = [] for d in nord_stream_data["data"]: data.append(d)
nord_stream_dataframe = pd.DataFrame(data)
nord_stream_dataframe.to_csv("data.csv", index=False, header=["Date", "Hour", "Nomination, kWh/h"])