Residential Power Traces for Five Houses: The iHomeLab RAPT Dataset
Abstract
:1. Summary
Relation to Other Datasets
2. Data Description
2.1. Electrical Power Data
2.2. Weather Data
2.3. Thermal Metadata
3. Methods
3.1. Measurement Equipment and Data Collection
3.2. Processing of Raw Data
- Round timestamps for the respective capture period, e.g., rounding ‘2018-10-01 18:05:08’ to ‘2018-10-01 18:05:00’
- Convert electrical meter measurements to mean consumed power ([W]) per period.
- Linearly interpolate missing data for periods up to 15 min.
- Down-sample everything to a capture period of 5 min using the mean, except for the weather data, where an hourly resolution was kept.
- Calculate boiler_power: the boiler_power is calculated (not measured) in the RPi Boiler Control Unit, see sensor h in Table 5. Switch-on times are provided as sensors C_boiler_heater_1\2\3. As these sensors were also event-driven, the energy consumption was redistributed on the regular capture period of 5 min during pre-processing.
4. Usage Notes
4.1. Reading the Dataset
- import pandas as pd
- pathToHouseA = "datasets/dfA_300s.hdf"
- dfA_300s = pd.read_hdf(pathToHouseA)
4.2. Missing Data
4.3. Known Issues
4.4. Particularities of the Installations and Corresponding Data
- Houses B has a solar panel, battery and a hot water boiler. The latter two are controlled by a custom controller, see sensor h in Table 5: If (B_pv_prod_power - B_total_cons_power) > 600 W, the B_boiler_heater_* are controlled according to the logic below:
- Daytime rules, i.e. high electrical tariff
- -
- ifboiler_on_thermostat == off then boiler_heater_* = off
- -
- ifboiler_on_thermostat == on and (boilertemp_top or boilertemp_bottom ) then boiler_heater_* = on
- -
- if (boilertemp_top and boilertemp_bottom > ) and (batt_state %) then boiler_heater_* = off
- -
- if (boiler_on_thermostat == ’on’) and batt_state > 85% and boilertemp_top and boilertemp_bottom then boiler_heater_* = on
- Night-time rules, i.e., low electrical tariff
- -
- ifboiler_on_thermostat == on and boilertemp_top then boiler_heater_* = on
- -
- ifboilertemp_topthenboiler_heater_* = off
Here, T °C, T °C and T °C, T °C. Depending on the current photovoltaic production, the three heating elements boiler_heater_1/2/3 are individually switched on. Remaining power will, in all cases, be used to charge the battery to its maximum. Further excess power is only after that allowed to flow back into the electrical grid. - Installed battery: ‘Fronius Solar Battery 6.0’ from Fronius (www.fronius.com): Usable capacity of the battery: 4800 Wh, nominal discharging and charging power 3200 W.
- The family inhabiting house C was on an extended leave from 2016-06-24 until 2016-08-13 with corresponding low power consumption in that period.
- The heat pump of house C is directly connected to the electrical grid that means the corresponding power is not subsumed in C_total_cons_power. In exchange for a lower electrical tariff, the utility has the right to control switch-on times of the heat pump by means of ripple control. Before the 2016-04-01, the utility inhibited switch-on with minor exception from 11 to 12 o’clock, 15 to 18 o’clock and from 22 to 2 o’clock the following morning. Starting with the 2016-04-01, the utility is allowed to variably block the heat pump, where each blocked period has to be followed by a period of equal or longer duration within which the heat pump is allowed to pull power. The ripple control signal has been obtained from the utility and is available as sensor C_hp_on_utility, a value of 1 indicating the pump is allowed to pull power.
- Heating of the hot water boiler was controlled in the following ways:
- -
- Before 2016-10-17: The boiler heating is turned on if the following signals are in the ‘on’ status: C_boiler_on_utility and C_boiler_on_thermostat. The former corresponds to the ripple control signal from the utility and the latter indicates if the water temperature in the boiler is below a certain threshold. The sensor C_boiler_on_relais is irrelevant for this period.
- -
- Between 2016-10-17 and 2017-01-23: The boiler heating is turned on if in addition to C_boiler_on_utility and C_boiler_on_thermostat, the signal C_boiler_on_relais is also in status ’on’. The signal C_boiler_on_relais is switched according to the following logic: (i) ’on’ if C_boilertemp_top < 42 °C (ii) ’off’ if C_boilertemp_top > 48 °C (approximately every 14 days the threshold was manually set to 60 °C).
- -
- Between 2017-01-23 and 2017-10-11: Due to recurrent difficulties with the more advanced control, the logic was switched back to the one used before 2016-10-17, see above.
- -
- After 2017-10-15: After the retrofit, see below, battery charging and boiler heating is controlled by a custom controller, see sensor h in Table 5: If (C_pv_prod_power - C_total_cons_power) > 900 W, the C_boiler_heater_* are controlled according to the logic as described for house B with the following difference. In case the boiler is charged during the night, battery discharging is disallowed. The sensor C_boiler_on_relais is irrelevant for this period.
- 2017-09-26: Established electrical connection of new photovoltaic panels.
- 2017-11-29: Connected new battery to power system. The battery type is identical as for house B, see corresponding specifications.
- The installations of PV panels and battery had the following consequences on the electrical installation:
- -
- Before the PV installation, the solar irradiation was logged with a solar irradiation sensor Tritec Spektron 320, see Table 5. The corresponding sensor is called C_solarlog_radiation and is only available until the retrofit.
- -
- After the retrofit, electrical power consumption from the boiler was calculated by the RPi Boiler Control Unit, see sensor h in Table 5. This sensor was not available before. The power consumption level of the boiler before the retrofit did however not vary because heating elements were always jointly turned on. The consumed power can be indirectly deduced from the power steps in the aggregate signal.
- The house is constructed as a “Zero-energy home”—Minergie-P, see Minergie (www.minergie.ch). That means that calculated heating energy per inhabited square meter and year amounts to 33 kWh.
- Solar panels have been disconnected between 2017-07-14 and 2017-10-18 because panels were exchanged. The area and exposition of the installed panels did not change but due to the improved efficiency, peak power changed from 8.14 kW to 10.45 kW.
- A new dishwasher has been installed on the 2017-09-01.
- A new washing machine has been installed on the 2017-12-15
- The dehumidifier is located in the cellar. Its control logic ensures that the cellar is dehumidified at all times while maximizing the usage of excess solar power to this end. That means that every 10 min, the control logic checks if the relative humidity in the cellar exceeds an upper or falls below a lower limit and switches the dehumidifier on or off, respectively. Depending on the situation, different limits are applied. The limits are listed in Table 6.
Author Contributions
Acknowledgments
Conflicts of Interest
References
- Siano, P. Demand Response and Smart Grids—A Survey. Renew. Sustain. Energy Rev. 2014, 30, 461–478. [Google Scholar] [CrossRef]
- Birrer, E.; Picard, C.; Huber, P.; Bolliger, D.; Klapproth, A. Demand Response Optimized Heat Pump Control for Service Sector Buildings–A Modular Framework for Simulation and Building Operation. Comput. Sci. Res. Dev. 2017, 32, 25–34. [Google Scholar] [CrossRef]
- Luthander, R.; Widén, J.; Nilsson, D.; Palm, J. Photovoltaic Self-Consumption in Buildings: A Review. Appl. Energy 2015, 142, 80–94. [Google Scholar] [CrossRef] [Green Version]
- Kok, K. The PowerMatcher: Smart Coordination for the Smart Electricity Grid. Ph.D. Thesis, Technical University of Denmark, Kgs. Lyngby, Denmark, July 2013. [Google Scholar]
- Hart, G.W. Nonintrusive Appliance Load Monitoring. Proc. IEEE 1992, 80, 1870–1891. [Google Scholar] [CrossRef]
- Zeifman, M.; Roth, K. Nonintrusive Appliance Load Monitoring: Review and Outlook. IEEE Trans. Consum. Electron. 2011, 57, 76–84. [Google Scholar] [CrossRef]
- WizEE–Wizard for the Optimal Management of Electrical Energy in a Prosumer Household. Available online: https://www.aramis.admin.ch/Grunddaten/?ProjectID=37341 (accessed on 30 January 2020).
- Swiss Competence Center for Energy Research SCCER FEEB&D of the Swiss Innovation Agency Innosuisse. Available online: https://www.sccer-feebd.ch (accessed on 30 January 2020).
- Huber, P.; Gerber, M.; Rumsch, A.; Paice, A. Prediction of Domestic Appliances Usage Based on Electrical Consumption. Energy Inform. 2018, 1, 16. [Google Scholar] [CrossRef] [Green Version]
- Murray, D.; Stankovic, L.; Stankovic, V. An Electrical Load Measurements Dataset of United Kingdom Households from a Two-Year Longitudinal Study. Sci. Data 2017, 4, 1–12. [Google Scholar] [CrossRef] [PubMed] [Green Version]
- Beckel, C.; Kleiminger, W.; Cicchetti, R.; Staake, T.; Santini, S. The ECO Data Set and the Performance of Non-intrusive Load Monitoring Algorithms. In Proceedings of the 1st ACM Conference on Embedded Systems for Energy-Efficient Buildings, Memphis, TN, USA, 4–6 November 2014. [Google Scholar] [CrossRef]
- Dataport. Available online: https://dataport.pecanstreet.org/ (accessed on 29 January 2020).
- Archive, I.S.S.D. Home, Irish Social Science Data Archive. Available online: https://www.ucd.ie/issda/data/commissionforenergyregulationcer/ (accessed on 18 January 2019).
- Miller, C.; Meggers, F. The Building Data Genome Project: An Open, Public Data Set from Non-Residential Building Electrical Meters. Energy Procedia 2017, 122, 439–444. [Google Scholar] [CrossRef]
- The HDF Group. Hierarchical Data Format Version 5. Available online: https://www.hdfgroup.org (accessed on 30 January 2020).
- McKinney, W. Data Structures for Statistical Computing in Python. In Proceedings of the 9th Python in Science Conference, Austin, TX, USA, 28 June–3 July 2010. [Google Scholar]
- Python Data Analysis Library—Pandas: Python Data Analysis Library. Available online: https://pandas.pydata.org (accessed on 21 January 2019).
# | Description | Sensor Name | Unit | T | M-id |
---|---|---|---|---|---|
House A | |||||
1 | total pc | A_total_cons_power | W | 120 s | a |
2 | pc of dishwasher | A_dishwasher_power | W | 120 s | b |
3 | pc of cooking, backing | A_stove_power | W | 120 s | c |
4 | PV power production | A_exp_power | W | 120 s | d,e 1 |
5 | pc of heat pump | A_hp_power | W | 120 s | f |
6 | pc of several devices: sauna, steam shower, outdoor lighting | A_sauna_power | W | 120 s | c |
7 | pc of several devices: fridge, comfort ventilation, central vacuum cleaner | A_additional_power | W | 120 s | b |
8 | pc of washing machine | A_washing_machine_power | W | 120 s | f |
House B | |||||
1 | total pc | B_total_cons_power | W | 300 s | g |
2 | pc of boiler | B_boiler_power | W | 300 s | h |
3 | water boiler: temp. at the top | B_boilertemp_top | °C | 300 s | i |
4 | water boiler: temp. at the bottom | B_boilertemp_bottom | °C | 300 s | i |
5 | water boiler: on/off-status of heater 1, 2, 3 and thermostat 2 | B_boiler_heater_*, B_boiler_on_thermostat | – | 300 s ed | j |
6 | total PV power production | B_pv_prod_power | W | 300 s | g |
7 | from solar panel to battery | B_to_batt_power | W | 300 s | g |
8 | pc from solar panel directly | B_direct_cons_power | W | 300 s | g |
9 | battery charge state (100% = full) | B_batt_state | % | 300 s | g |
10 | pc from battery | B_from_batt_power | W | 300 s | g |
11 | from solar panel in grid | B_to_net_power | W | 300 s | g |
12 | pc from grid | B_from_net_power | W | 300 s | g |
House C | |||||
1 | total pc | C_total_cons_power | W | 120 s 3 300 s | a,g 3 |
2 | pc of boiler | C_boiler_power | W | 300 s | h |
3 | water boiler: temp. at the top | C_boilertemp_top | °C | 300 s | i |
4 | water boiler: temp. at the bottom | C_boilertemp_bottom | °C | 300 s | i |
5 | water boiler: on/off-status of heater 1, 2, 3, thermostat, relay, utility 2 | C_boiler_heater_*, C_boiler_on_* | – | 300 s ed | j |
6 | total PV power production | C_pv_prod_power | W | 300 s | g |
7 | from solar panel to battery | C_to_batt_power | W | 300 s | g |
8 | pc from solar panel directly | C_direct_cons_power | W | 300 s | g |
9 | battery charging state (100% = full) | C_batt_state | % | 300 s | g |
10 | pc from battery | C_from_batt_power | W | 300 s | g |
11 | from solar panel in grid | C_to_net_power | W | 300 s | g |
12 | pc from grid | C_from_net_power | W | 300 s | g |
metering of solar radiation | C_solarlog_radiation | 120 s | k | ||
13 | environmental data logged by weather station, see Table 3 | C_weather_* | * | 1 h | l |
14 | pc of heat pump | C_hp_power | W | 120 s | a |
14 | ripple control signal for heat pump | C_hp_on_utility | - | ed | m |
15 | outdoor temperature next to sensor of heat pump | C_temperature_out | °C | 120 s | i |
House D | |||||
1 | total pc | D_total_cons_power | W | 120 s | a |
2 | pc of dishwasher | D_dishwasher_power | W | 60 s | n |
3 | pc of tumble dryer | D_tumble_dryer_power | W | 60 s | n |
4 | PV power production | D_exp_power | W | 120 s | d |
5 | pc of heat pump | D_hp_power | W | 300 s | o |
6 | pc of rainwater pump | D_rainwater_power | W | 60 s | n |
7 | pc of HiFi system and router | D_audio_wlan_og_power | W | 60 s | n |
8 | pc of washing machine | D_washing_machine_power | W | 60 s | n |
House E | |||||
1 | total pc | E_total_cons_power | W | 300 s | p |
2 | pc of dishwasher | E_dishwasher_power | W | 60 s | n |
3 | pc of tumble dryer | E_tumble_dryer_power | W | 60 s | n |
4 | PV power production | E_prod_power | W | 300 s | p |
5 | pc of heating gas pump | E_gasheating_pump_power | W | 60 s | n |
6 | pc of water pump of solar thermal collectors | E_solarheating_pump_power | W | 60 s | n |
7 | pc of washing machine | E_washing_machine_power | W | 60 s | n |
8 | environmental data logged by weather station, see Table 3 | E_weather_* | * | 1 h | l |
9 | pc of dehumidifier | E_dehumidifier_power | W | 60 s | n |
Houses | File Name | Sampling Rate | Time Range | Weather Station |
---|---|---|---|---|
house A | datasets/dfA_300s.hdf | 5 min | 2017-04-01–2018-10-30 | LUZ |
house B | datasets/dfB_300s.hdf | 5 min | 2017-03-01–2019-07-31 | MMSTA |
house C | datasets/dfC_300s.hdf datasets/dfC_3600s.hdf | 5 min 1 h (weather) | 2015-11-30–2019-07-31 | EGO |
house D | datasets/dfD_300s.hdf | 5 min | 2016-04-23–2019-07-31 | LUZ |
house E | datasets/dfE_300s.hdf datasets/dfE_3600s.hdf | 5 min 1 h (weather) | 2016-12-01–2019-07-31 | LUZ |
Description | Sensor Name | Unit | T |
---|---|---|---|
House C | |||
indoor humidity | C_weather_humidity_in | RH | 3600 s |
outdoor humidity | C_weather_humidity_out | RH | 3600 s |
outdoor pressure | C_weather_pressure | mbar | 3600 s |
indoor temperature | C_weather_temperature_in | °C | 3600 s |
outdoor temperature | C_weather_temperature_out | °C | 3600 s |
House E | |||
indoor humidity | E_weather_humidity_in | RH | 3600 s |
indoor humidity in cellar | E_weather_humidity_cellar | RH | 3600 s |
outdoor humidity | E_weather_humidity_out | RH | 3600 s |
outdoor pressure | E_weather_pressure | mbar | 3600 s |
indoor temperature | E_weather_temperature_in | °C | 3600 s |
indoor temperature in cellar | E_weather_temperature_cellar | °C | 3600 s |
outdoor temperature | E_weather_temperature_out | °C | 3600 s |
House A | House C | House D | |
---|---|---|---|
Building Information | |||
Description | Semi-detached house with three floors: The lowest floor of the southern facade is partially built into the hillside. The window area on the main northern facade (three floors) is small. The window area on the main southern facade (two floors) is large. | Detached house with 4 floors: only the topmost floor is freestanding. The rest of the north-east (NE) facade and around 1/3 of south-east and north-west facades are embedded in the hillside. The main facade is oriented towards south-west (SW). The heated volume includes an additional self-contained flat. No electrical consumption (except heat pump) origins from that flat. | Detached house with 2 floors: only the upper floor is freestanding, the complete NE and SW facades of the lower floor are embedded in the hillside. The main facades are oriented towards NE and SW. |
Inhabitants | three-person household | four-person household + one person in flat | five-person household |
Heated space [m] | 146 | 295 | 218 |
Building envelope | Construction year: 2005, one-shell brickwork, 16 cm Isolation | Construction year: 2005, two-shell brickwork: outer: 15 cm brick, insulation: 14 cm, flumroc.ch ’Dämmplatte 1’, thermal conductivity: 0.035 W/mK, inner: 15 cm brick | Construction year: 2008, ground floor concrete, first floor 80 mm massive wood construction encased in 260–300 mm insulation. Energy balance according to SAI 380/1 (2007) 33 kWh/m year. See also Section 4.4 |
Windows | double glazing, heat transmission coefficient: 1.9 W/(m K) | double glazing, heat transmission coefficient: 1.9 W/(m K) | triple glazing |
Heat Pump Information | |||
Comments | Heat pump has two compressors, one is used for domestic hot water (60 °C), the other for space heating (30–35 °C). | Heat pump is only used for space heating. Domestic hot water is generated in a conventional hot water boiler. | Heat pump has two compressors, one is used for domestic hot water (60 °C), the other for space heating (35–40 °C). |
Heat pump specs | Manufacturer: KWT (acquired by Viessmann), Model: Swissline 28NHB, Type: Sole—Wasser | Manufacturer: Stiebel Eltron, Model: WPL 23, Type: air–water | Manufacturer: alpha-innotec, Model: SWC 60H, Type: sole–water |
Emitter type | floor heating | floor heating | floor heating |
Ripple controlled heat pump | No | Yes | No |
M-id | Device Name | Details |
---|---|---|
a | L+G ZMD120AP | Meter installed by utility. Readout of pulse output (S0): 1000 impulses/kWh. |
b | MCI single-phase | Readout of pulse output (S0): 1000 impulses/kWh. |
c | ABB OD4165 | Readout of pulse output (S0): 100 impulses/kWh. |
d | L+G E350 | Readout of pulse output (S0): 1000 impulses/kWh. |
e | Elster AS3000 | Readout of pulse output (S0): 1000 impulses/kWh. |
f | Voltcraft DPM-314D | Readout of pulse output: 1000 impulses/kWh. |
g | Fronius Symo Hybrid 5.0-3-S | Inverter from Fronius (www.fronius.com) with an integrated logging system to monitor the various power flows through the device. |
h | RPi Boiler Control Unit | Custom made boiler control unit implemented on a Raspberry Pi that switches the three individual heating elements of the boiler. The boiler_power is calculated based on the configured value of the nominal consumption of the switched-on heating elements. The control logic is documented in Section 4.4, house B. |
i | Temp. Sensor DS1820 | 1-wire bus temperature sensor DS1820 |
j | Switch State Sensor | Sensor is connected to RPi Boiler Control unit. The information on the voltage drop over the switch is transformed in a binary state signal. |
k | Tritec Spektron 320 | Soloar irradiation sensor from Tritec (www.tritec-energy.com). Measuring range 0-1500 W/m. Accuracy % annual mean. Considering an area and efficiency of a solar panel, the output of the sensor can be used to calculate the generated power of a corresponding installation. |
l | TFA My Weatherbox | Weather station from TFA (www.tfa-dostmann.de). Temperature sensors–accuracy: °C; humidity sensor–resolution: 1% RH, accuracy: % RH. |
m | Ripple Control | Ripple control signal as obtained from the utility company. |
n | myStrom WiFi Switch (CH) | Smart plug from myStrom (mystrom.ch). Measuring range 2–2300 W. Accuracy %. |
o | Hager EC311 | Readout of pulse output (S0): 10 impulses/kWh. |
p | Solar-Log 1200 | Monitoring and energy management system from Solar-Log (www.solar-log.com). It includes options to export data. |
Situation | Lower Limit [RH] | Upper Limit [RH] |
---|---|---|
(B_pv_prod_power - B_total_cons_power) > 600 W (nominal power of dehumidifier) | 48 | 53 |
high electrical tariff (starting at 6 am) | 58 | 63 |
low electrical tariff (starting at 10pm) | 53 | 58 |
© 2020 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).
Share and Cite
Huber, P.; Ott, M.; Friedli, M.; Rumsch, A.; Paice, A. Residential Power Traces for Five Houses: The iHomeLab RAPT Dataset. Data 2020, 5, 17. https://doi.org/10.3390/data5010017
Huber P, Ott M, Friedli M, Rumsch A, Paice A. Residential Power Traces for Five Houses: The iHomeLab RAPT Dataset. Data. 2020; 5(1):17. https://doi.org/10.3390/data5010017
Chicago/Turabian StyleHuber, Patrick, Melvin Ott, Martin Friedli, Andreas Rumsch, and Andrew Paice. 2020. "Residential Power Traces for Five Houses: The iHomeLab RAPT Dataset" Data 5, no. 1: 17. https://doi.org/10.3390/data5010017
APA StyleHuber, P., Ott, M., Friedli, M., Rumsch, A., & Paice, A. (2020). Residential Power Traces for Five Houses: The iHomeLab RAPT Dataset. Data, 5(1), 17. https://doi.org/10.3390/data5010017