pudl.extract.ferc714 module

Routines used for extracting the raw FERC 714 data.

pudl.extract.ferc714.TABLE_ENCODING = {'adjacency_ba_ferc714': 'iso-8859-1', 'demand_forecast_pa_ferc714': None, 'demand_hourly_pa_ferc714': None, 'demand_monthly_ba_ferc714': None, 'description_pa_ferc714': 'iso-8859-1', 'gen_plants_ba_ferc714': 'iso-8859-1', 'id_certification_ferc714': 'iso-8859-1', 'interchange_ba_ferc714': 'iso-8859-1', 'lambda_description_ferc714': 'iso-8859-1', 'lambda_hourly_ba_ferc714': None, 'net_energy_load_ba_ferc714': None, 'respondent_id_ferc714': None}

Dictionary describing the character encodings of the FERC 714 CSV files.

pudl.extract.ferc714.TABLE_FNAME = {'adjacency_ba_ferc714': 'Part 2 Schedule 4 - Adjacent Balancing Authorities.csv', 'demand_forecast_pa_ferc714': 'Part 3 Schedule 3 - Planning Area Forecast Demand.csv', 'demand_hourly_pa_ferc714': 'Part 3 Schedule 2 - Planning Area Hourly Demand.csv', 'demand_monthly_ba_ferc714': 'Part 2 Schedule 2 - Balancing Authority Monthly Demand.csv', 'description_pa_ferc714': 'Part 3 Schedule 1 - Planning Area Description.csv', 'gen_plants_ba_ferc714': 'Part 2 Schedule 1 - Balancing Authority Generating Plants.csv', 'id_certification_ferc714': 'Part 1 Schedule 1 - Identification Certification.csv', 'interchange_ba_ferc714': 'Part 2 Schedule 5 - Balancing Authority Interchange.csv', 'lambda_description_ferc714': 'Part 2 Schedule 6 - System Lambda Description.csv', 'lambda_hourly_ba_ferc714': 'Part 2 Schedule 6 - Balancing Authority Hourly System Lambda.csv', 'net_energy_load_ba_ferc714': 'Part 2 Schedule 3 - Balancing Authority Net Energy For Load.csv', 'respondent_id_ferc714': 'Respondent IDs.csv'}

Dictionary mapping PUDL tables to filenames within the FERC 714 zipfile.

pudl.extract.ferc714.extract(tables=('respondent_id_ferc714', 'id_certification_ferc714', 'gen_plants_ba_ferc714', 'demand_monthly_ba_ferc714', 'net_energy_load_ba_ferc714', 'adjacency_ba_ferc714', 'interchange_ba_ferc714', 'lambda_hourly_ba_ferc714', 'lambda_description_ferc714', 'description_pa_ferc714', 'demand_forecast_pa_ferc714', 'demand_hourly_pa_ferc714'), pudl_settings=None, ds=None)

Extract the raw FERC Form 714 dataframes from their original CSV files.

Parameters

• ferc714_tables (iterable) – The set of tables to be extracted.

• pudl_settings (dict) – A PUDL settings dictionary.

• ds (Datastore) – instance of the datastore

Returns

A dictionary of dataframes, with raw FERC 714 table names as the keys, and minimally processed pandas.DataFrame instances as the values.

Return type

dict