pudl.extract.ferc60

Extract FERC Form 60 data from DBF archives.

Module Contents

Classes

Ferc60DbfExtractor

Extracts FERC Form 60 data from the legacy DBF archives.

class pudl.extract.ferc60.Ferc60DbfExtractor(datastore: pudl.workspace.datastore.Datastore, settings: pudl.settings.FercToSqliteSettings, output_path: pathlib.Path, clobber: bool = False)

Bases: pudl.extract.dbf.FercDbfExtractor

Extracts FERC Form 60 data from the legacy DBF archives.

DATASET = 'ferc60'

DATABASE_NAME = 'ferc60_dbf.sqlite'

get_settings(global_settings: pudl.settings.FercToSqliteSettings) → pudl.settings.GenericDatasetSettings

Returns settings for FERC Form 60 DBF dataset.

finalize_schema(meta: sqlalchemy.MetaData) → sqlalchemy.MetaData

Add primary and foreign keys for respondent_id.

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

Runs the deduplication on f60_s0_respondent_id table.

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