dataProcessing/README.md

In CfSOtago/GREENGridEECA: Supports Analysis of NZ GREEN Grid data for EECA

GREENGridEECA

A repo supporting analysis of NZ GREEN Grid electricity demand data for EECA.

Data

• New Zealand GREEN Grid Household Electricity Demand Study 2014-2018

Code

This repo is structured as an R package. This means you (should) be able to install it using:

• devtools::install_github("CfSOtago/GREENGridEECA")

Note that to run the code you will need to register with the UK Data Service, agree to the re-use conditions and download the data.

makeHalfHourlyData.R

This script takes all of the clean 1 minute observations for all households and aggregates them by circuit to half-hourly observations by taking the:

• mean
• min
• max
• sd
• N observations

for powerW across each half-hour within each circuit for each household. This includes the imputed total load which is also aggregated in the same way for all households.

The results are saved as 1 file per household each of which will have the following structure:

    linkID                            circuit   r_dateTimeHalfHour meanPowerW nObs sdPowerW minPowerW maxPowerW
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T02:00:00Z      0.000   16   0.0000         0      0.00
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T02:30:00Z    175.006   30 432.3806         0   1916.25
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T03:00:00Z      0.000   30   0.0000         0      0.00
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T03:30:00Z      0.000   30   0.0000         0      0.00
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T04:00:00Z      0.000   30   0.0000         0      0.00
rf_47 Heat Pump & 2 x Bathroom Heat$4171 2015-03-25T04:30:00Z      0.000   30   0.0000         0      0.00
 

• linkiD: anonyised ID to link to the household data;
• circuit: the monitored circuit, includes imputed total load as a 'circuit'
• r_dateTimeHalfHour: date/time in UTC (what does the T & Z mean?)
• mean/nObs/sd/min/max power in watts

Reporting

Best viewed at https://cfsotago.github.io/GREENGridEECA/

CfSOtago/GREENGridEECA documentation built on May 1, 2022, 8:08 p.m.