pudl.extract.ferc6#

Extract FERC Form 6 data from DBF archives.

Classes#

Ferc6DbfExtractor

Extracts FERC Form 6 data from the legacy DBF archives.

Module Contents#

class pudl.extract.ferc6.Ferc6DbfExtractor(datastore: pudl.workspace.datastore.Datastore, data_config: pudl.settings.FercToSqliteDataConfig, output_path: pathlib.Path)[source]#

Bases: pudl.extract.dbf.FercDbfExtractor

Extracts FERC Form 6 data from the legacy DBF archives.

DATASET = 'ferc6'[source]#
DATABASE_NAME = 'ferc6_dbf.sqlite'[source]#
finalize_schema(meta: sqlalchemy.MetaData) → sqlalchemy.MetaData[source]#

Add primary and foreign keys for respondent_id.

aggregate_table_frames(table_name: str, dfs: list[pudl.extract.dbf.PartitionedDataFrame]) → pandas.DataFrame | None[source]#

Runs the deduplication on f6_s0_respondent_id table.

Other tables are aggregated as usual, meaning that the partial frames are simply concatenated.