pudl.extract.eia923 module

Retrieves data from EIA Form 923 spreadsheets for analysis.

This modules pulls data from EIA’s published Excel spreadsheets.

This code is for use analyzing EIA Form 923 data. Currenly only years 2009-2016 work, as they share nearly identical file formatting.

class pudl.extract.eia923.Extractor(*args, **kwargs)

Bases: pudl.extract.excel.GenericExtractor

Extractor for EIA form 923.

static get_dtypes(page, **partition)

Returns dtypes for plant id columns.

static process_final_page(df, page)

Removes reserved columns from the final dataframe.

process_raw(df, page, **partition)

Drops reserved columns.

static process_renamed(df, page, **partition)

Cleans up unnamed_0 column in stocks page, drops invalid plan_id_eia rows.