I need at least hourly data for individual households' electrical load profile for a renewable energy system model.

I've had a look online and struggled to find such data. For example I've found this

but not only is it 20years old, it looks like it isn't from an individual house.

The UK Household Electricity Survey, which monitored a total of 250 owner-occupier households across England from 2010 to 2011 would be ideal, however the actual data they collected I can't find.

Their report, here shows the report etc, but not the actual data.

Where might I find the actual electrical usage of a household? Could energy companies provide this?

  • 1
    \$\begingroup\$ Measure your own. \$\endgroup\$ Jan 8 '17 at 0:14
  • \$\begingroup\$ @BrianDrummond Unfortunately it needs to be for an entire year, so using my own wouldn't be viable at this stage. \$\endgroup\$
    – Maitiu
    Jan 8 '17 at 0:20
  • \$\begingroup\$ I am SURE it depends a lot on the location of the home. In places where it gets warm in the summer, there will be very large peaks due to air-conditioning load, for example. These peaks are good candidates for localized solar, since the demand and supply are co-incident. \$\endgroup\$
    – mkeith
    Jan 8 '17 at 0:27
  • 2
    \$\begingroup\$ Data for one individual household is not very useful to anyone except that individual. Even one's own data for last year may be of limited use this year if circumstances have changed. It is very unlikely that you will find anything more than an average for a number of households. Even that may be hard to find since most such data is a mix of households, commercial, and industrial users. Are you looking for data any any particular part of the world? \$\endgroup\$ Jan 8 '17 at 0:29
  • \$\begingroup\$ You could see if there is "typical" data provided with software like RETScreen. nrcan.gc.ca/energy/software-tools/7465 that and others are available for free download. \$\endgroup\$ Jan 8 '17 at 0:34

In case anyone going through the pain of trying to find such data comes across this question, I managed to find a good dataset which has half hourly consumption rates for individual houses (over 5500) in London.

The dataset is huge, about 168 million rows of data, so you'll need to find a good way to analyse it and find what you need. There are smaller fills containing the same data broken up in the link, but they are still pretty big.

  • 1
    \$\begingroup\$ The data are in csv files, which can be read by Excel, but which are NOT Excel files. You would probably do better to analyse the data using a better tool that does not load the whole file into memory at once. Matlab or R or something along those lines. The data files are some 10GB in total - working with that much data in Excel could best be described as "painful." Scipy would also be a good tool for handling that much data. \$\endgroup\$
    – JRE
    Apr 15 '17 at 19:56
  • \$\begingroup\$ I've edited to remove excel. I found out the hard way that excel wouldn't cope. I wouldn't describe it as painful, or anything, it simply took too long to load and I closed it. Regarding matlab however, I am struggling to look at the data without importing it. \$\endgroup\$
    – Maitiu
    Apr 22 '17 at 13:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.