zaf-erc-delskv-1994-2014-v1
Domestic Electrical Load Survey - Key Variables 1994-2014
Name | Country code |
---|---|
South Africa | ZAF |
Household Survey [hh]
Toussaint, Wiebke. Domestic Electrical Load Survey - Key Variables 1994-2014 [dataset]. version 1. Johannesburg: SANEDI [funders]. Cape Town: UCT Energy Research Centre [producers], 2014. Cape Town: DataFirst [distributor], 2019. DOI: https://doi.org/10.25828/mf8s-hh79
This dataset is a harmonisation of the Domestic Electrical Load Survey (DELS) 1994-2014 dataset. The DELS 1994-2014 questionnaires were changed in 2000. Subsequently survey questions vary between 1994-1999 and 2000-2014. This makes data processing complex, as survey responses first need to be associated with their year of collection and corresponding questionnaire before they can be correctly interpreted. This Key Variables dataset is a user-friendly version of the original dataset. It contains household responses to the most important survey questions, as well as geographic and linking information that allows for the households to be matched to their respective electricity metering data. This dataset and similar custom datasets can be produced from the DELS 1994-2014 dataset with the python package delprocess. The data processing section includes a description of how this dataset was created. The development of the tools to create this dataset was funded by the South African National Energy Development Initiative (SANEDI).
Administrative records
Households
v1: licensed data, available under conditions
2019-05-13
Version 1
The scope of the South African Domestic Electrical Load Survey includes:
HOUSEHOLD: Household characteristics, occupant demographics of gender and age, employment, income, number of household occupants with income
DWELLING: Dwelling characteristics, wall material, roof material, floor area, water source
APPLIANCES: stove, hotplate, kettle, heater, iron, geyser, washing machine, TV, fridge, freezer, microwave
BEHAVIOUR: frequency of appliance usage
ELECTRICITY: time since electrification, circuit breaker
The study had national coverage.
Settlement/suburb and municipality
The dataset covers South African households in the DELS 1994-2014 dataset. These are electrified households that received electricity either directly from Eskom or from their local municipality.
Name | Affiliation |
---|---|
Wiebke Toussaint | University of Cape Town |
Name | Role |
---|---|
South African National Energy Development Initiative | Funder |
Name | Affiliation | Role |
---|---|---|
Marcus Dekenah | MDekenah Consulting | [Expert knowledge for] understanding database design and conveying details around data collection |
The dataset includes all households for which survey responses have been captured in the DELS1994-2014 dataset.
Data is provided as is and no weightings have been applied.
Start | End | Cycle |
---|---|---|
1994 | 2013 | Other cycles |
2014 | 2014 | Final cycle |
This dataset has been constructed from the DELS 1994-2014 dataset using the data processing functions in the delprocess python package (www.github.com/wiebket/delprocess: release v1.0). The delprocess python package takes the complexities of the original DELS 1994-2014 dataset into account and makes use of 'spec files' to specify the processing steps that must be performed. To retrieve data for all survey years, two separate spec files are required to process survey response from 1994-1999 and 2000-2014. The spec files used to produce this dataset are included in the program files and can be used as templates for new custom datasets. Full instructions on how to use them to process the data are in the README file contained in the delprocess package.
SPEC FILES specify the following processing steps:
In particular, the DELSKV 1994-2014 dataset has been produced by specifying the following processing steps:
TRANSFORMATIONS
REPLACEMENTS
Appliance usage values have been replaced with:
0=never
1=monthly
2=weekly
3=daily
water_access values have been replaced with:
1=nearby river/dam/borehole
2=block/street taps
3=tap in yard
4=tap inside house
roof_material and wall_material values have been replaced with:
1=IBR/Corr.Iron/Zinc
2=Thatch/Grass
3=Wood/Masonite board
4=Brick
5=Block
6=Plaster
7=Concrete
8=Tiles
9=Plastic
10=Asbestos
11=Daub/Mud/Clay
OTHER NOTES
Appliance usage information was only collected after 2000.
No binning was done to segment survey responses for this dataset.
MISSING VALUES
Missing values have not been replaced and are represented as blanks except for imputed columns (total_adults, total_children, ...) and appliances after 2000, where missing values have been replaced with a 0.
Name | Affiliation | URL | |
---|---|---|---|
DataFirst | University of Cape Town | support.data1st.org | support@data1st.org |
Licensed use files, available for non-commercial use only
Toussaint, Wiebke. Domestic Electrical Load Survey - Key Variables 1994-2014 [dataset]. version 1. Johannesburg: SANEDI [funders]. Cape Town: UCT Energy Research Centre [producers], 2014. Cape Town: DataFirst [distributor], 2019. DOI: https://doi.org/10.25828/mf8s-hh79
Name | Affiliation | URL | |
---|---|---|---|
DataFirst Support Site | University of Cape Town | support@data1st.org | support.data1st.org |
Name | Affiliation | Role |
---|---|---|
Energy Research Centre | University of Cape Town | Metadata producer |
2020-04-29
Version 4