df_spot_price = get_spot_price()data
Import and describe data
This project uses two years of data for a French photovoltaïc site between the period August 2020 up to August 22. The main sources of data are French electricity spot prices and the production load curve for the site.
The spot price data is collected from ENTSOE and can be found under the data folder. The load_spot_price function is a wrapper around the import call to directly use the spot price data.
get_spot_price
get_spot_price ()
Load french spot price data.
Let’s load the data and see what’s inside…
df_spot_price.to_frame().head()| spot_price | |
|---|---|
| time | |
| 2020-08-01 00:00:00+02:00 | 37.96 |
| 2020-08-01 01:00:00+02:00 | 32.40 |
| 2020-08-01 02:00:00+02:00 | 31.01 |
| 2020-08-01 03:00:00+02:00 | 28.29 |
| 2020-08-01 04:00:00+02:00 | 27.45 |
Europe truly is in a unique situation regarding its electricity market as the following price time series suggests:
df_spot_price.clip(upper=1000).plot()
Make sure that we will always get this dataset without missing data.
test_eq(df_spot_price.shape, (17520,))
test_eq(df_spot_price.isna().any(), False)get_production
get_production (site_id:int=1)
Get production data for site site_id.
df_production = get_production()Let’s see what the production looks like over the full two year period…
df_production.plot()
As might seem obvious, the production during the winter months is significantly lower than the summer months.