Skip to content

Code Resources & Explainer

Eskom Python scripts and files

Adding 'tworhour' slots to load shedding history.py
2.5 kB
eskom.py
1.8 kB
Load Shedding Schedule.csv
172.5 kB
Load Shedding Zones - ESP History.csv
52.5 kB
Load Shedding Zones - Gauteng schedule.csv
39.6 kB

Method

1. Create load shedding historical schedule

ESP provides a history of when load shedding changed to a different stage. I found this tricky to work with as it did not enable me to easily lookup what stage the country was in at a particular point in time. It would have required doing a look up of the previous change and then figuring out which slot relates to the time and which block had load shedding in that slot
So, I created 2 hour (column ’twohour’) slots for (12 per day) everyday and expanded the ESP history so that each slot was allocated a stage. These 2 hour slots acted as a time series axis and enabled me to map the historical stages in a time series graph

2. Convert area schedules into ’two-hour’ format

Using schedules provided by Eskom, CPT, Durban and Joburg. I converted the load shedding schedule into two hour slots for the various load shedding stages. This is what then enabled me to now lookup the load shedding schedule for a particular block according to the stage it was in - using the above history

Adding 'tworhour' slots to load shedding script

script


Loom walkthrough

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.