ReEDS: Historical electricity demand profiles

This record provides hourly state-level electricity demand profiles for the contiguous United States (U.S.) for 15 weather years (2007–2013 + 2016–2023), used in the Regional Energy Deployment System (ReEDS) model. Profiles for 2007–2013 use data from FERC Form 714 and ISO/RTO websites; profiles for 2016–2023 use data from EIA Form 930 and ISO/RTO websites. Important caveats and details on data processing are provided in the ReEDS documentation.

Demand profiles represent gross end-use load in hour-ending format, in units of [MWh/h]. All profiles are at hourly resolution in U.S. Central Standard Time (UTC–06:00). For leap years, the final day of the weather year (December 31) is dropped, such that each weather year contains 8760 hours.

File structure

Electricity demand profiles are saved as a Hierarchical Data Format (HDF5) file. The following Python function can be used to read a demand profile .h5 file into a pandas dataframe:

import h5py
import pandas as pd
def read_profile(filepath):
    """
    Read an hourly profile from `filepath` and return a pandas dataframe.
    Usage:
    `df = read_profile('/path/to/filename.h5')`
    """
    encoding = 'utf-8'
    with h5py.File(filepath, 'r') as f:
        df = pd.DataFrame(
            f['data'][:],
            columns=pd.Series(f['columns']).str.decode(encoding),
            index=f['index_0'],
        )
        df.index = pd.to_datetime(
            pd.Series(df.index, name='datetime').str.decode(encoding)
        )
    return df