With the benefit of smart electricity meters it’s possible to obtain hourly data showing household consumption in KWh. I downloaded this dataset for my own house in CSV format from United Energy’s EnergyEasy portal.
With some massaging, the data can be formatted to a structure which which makes aggregation easier. The excellent tool OpenRefine made this task easier, effectively unpivoting half-hourly measures which were in many columns into a single column, so that the data looks like this:
Day,Interval,Quantity 2012-01-01,0000,0.05 2012-01-01,0030,0.05 2012-01-01,0100,0.044 2012-01-01,0130,0.05 2012-01-01,0200,0.044 [...] 2013-12-31,2130,0.025 2013-12-31,2200,0.019 2013-12-31,2230,0.025 2013-12-31,2300,0.025 2013-12-31,2330,0.025
- During which hours of the day is the highest average energy consumption? Is this different in summer vs winter? Has this changed from 2012 to 2013?
View original post 180 more words