Beta
⚡ Recommendation ⚡
Store your energy with 70MWh storage systems! 💡
Hidden code
💾 The data
The data is presented by the following columns:
- "date" - from January 1, 2015, to October 6, 2020.
- "demand" - daily electricity demand in MWh.
- "price" - recommended retail price in AUD/MWh.
- "demand_pos_price" - total daily demand at a positive price in MWh.
- "price_positive" - average positive price, weighted by the corresponding intraday demand in AUD/MWh.
- "demand_neg_price" - total daily demand at a negative price in MWh.
- "price_negative" - average negative price, weighted by the corresponding intraday demand in AUD/MWh.
- "frac_neg_price" - the fraction of the day when the demand traded at a negative price.
- "min_temperature" - minimum temperature during the day in Celsius.
- "max_temperature" - maximum temperature during the day in Celsius.
- "solar_exposure" - total daily sunlight energy in MJ/m^2.
- "rainfall" - daily rainfall in mm.
- "school_day" - "Y" if that day was a school day, "N" otherwise.
- "holiday" - "Y" if the day was a state or national holiday, "N" otherwise.
Note: The price was negative during some intraday intervals, so energy producers were paying buyers rather than vice-versa.
Hidden code
Missing data detected 🔎
In the columns 'solar_exposure' and 'rainfall', that would be filled by its median value.
Hidden code
🧮 Correlating The Data
Trust me, I'm a Data Scientist. ☝🏻
🔌🐽 And the first thing you always need to do is to check how the correlates your data in your dataset 🔎
Hidden code
The Price are correlates with the Demand and 🌡️ Maximal Temparature mainly.
💲 Price by month
Hidden code
As we see on the chart above: there is a pattern in the first month of the year, as well as that is the 🌡️ highest temperature month in Australia, what we can see in the frame below:
Hidden code