pudl.extract.eia923

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.

Attributes

logger

raw_eia923__all_dfs

Classes

Extractor

Extractor for EIA form 923.

Functions

extract_eia923(raw_eia923__all_dfs)

Extract raw EIA-923 data from excel sheets into dataframes.

Module Contents

pudl.extract.eia923.logger[source]
class pudl.extract.eia923.Extractor(*args, **kwargs)[source]

Bases: pudl.extract.excel.ExcelExtractor

Extractor for EIA form 923.

METADATA[source]
BLACKLISTED_PAGES = ['plant_frame'][source]
cols_added = [][source]
process_raw(df, page, **partition)[source]

Drops reserved columns.

static process_renamed(df, page, **partition)[source]

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

process_final_page(df, page)[source]

Removes reserved columns from the final dataframe.

static get_dtypes(page, **partition)[source]

Returns dtypes for plant id columns and county FIPS column.

pudl.extract.eia923.raw_eia923__all_dfs[source]
pudl.extract.eia923.extract_eia923(raw_eia923__all_dfs)[source]

Extract raw EIA-923 data from excel sheets into dataframes.