File size: 2,220 Bytes
cdbe1c5 5354056 cdbe1c5 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 | import requests
import pandas as pd
import matplotlib.pyplot as plt
import datetime
import gradio as gr
list_of_EIC_codes = ["10Y1001A1001A46L","10YDK-1--------W","10YES-REE------0","10YFR-RTE------C"]
def plot_e_pricing(EIC_code,start_date,end_date,tomorrow_rate):
#
#
if tomorrow_rate == True:
now = datetime.datetime.utcnow()
tomorrow = now + datetime.timedelta(days=1)
now = now.replace(microsecond=0).isoformat() + 'Z'
tomorrow = tomorrow.replace(microsecond=0).isoformat() + 'Z'
#
start_date = now
end_date = tomorrow
#
url = "https://electri.p.rapidapi.com/api/v1/day-ahead-prices"
querystring = {"to":end_date,"from":start_date,"eic":EIC_code}
headers = {
"X-RapidAPI-Key": "7ad267cb53mshf4f5255c38f192ap19f964jsnc7abc0be43eb",
"X-RapidAPI-Host": "electri.p.rapidapi.com"
}
data = requests.request("GET", url, headers=headers, params=querystring).json()
df = pd.json_normalize(data['data']['series'])
df['time'] = pd.to_datetime(df['time'])
#
df_metadata = pd.json_normalize(data)
currency = df_metadata['data.currency'].iloc[0]
power_unit = df_metadata['data.unit'].iloc[0]
eic = df_metadata['data.eic'].iloc[0]
#
fig, ax = plt.subplots(figsize=(8, 6))
ax.plot(df['time'], df['price']);
plt.title('Electrical prices '+ str(eic))
plt.xlabel('Time')
plt.ylabel('Price [' + str(currency) + '/' + str(power_unit) + ']')
fig.autofmt_xdate()
#
#
return fig
inputs = [
gr.Dropdown(list_of_EIC_codes, label="Electrical Provider EIC"),
gr.Textbox(label="Start Date [YYYY-MM-DDTHH:MMZ]"),
gr.Textbox(label="End Date [YYYY-MM-DDTHH:MMZ]"),
gr.Checkbox(label="Tomorrow's rates?",default='False'),
]
outputs = gr.Plot()
demo = gr.Interface(
fn=plot_e_pricing,
inputs=inputs,
outputs=outputs,
examples=[
["10Y1001A1001A46L","2022-04-05T22:00Z","2022-05-05T22:00Z",False],
["10YDK-1--------W","2022-08-05T22:00Z","2022-08-06T22:00Z",False],
["10YDK-1--------W"," "," ",True],
],
cache_examples=True,
)
if __name__ == "__main__":
demo.launch()
# Requirements
# pipreqs . |