search

catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.
https://catalyst.coop/pudl
MIT License
458 stars 105 forks source link

FERC Form 1 respondent IDs #734

Closed jrea-rmi closed 3 years ago

jrea-rmi commented 3 years ago

A few minor edits to f1_respondent_id:

new respondents in 2019: 529: Tri-State G & T Assn, Inc 531: Basin Electric Power Coop

also, a couple of edits to names for respondents already in f1_respondent_id: 519: Upper Michigan Energy Resources Company 522: Liberty Utilities (CalPeco Electric) LLC

Code I used to make edits for my own use below:

f1_respondent_id = pd.read_sql_table('f1_respondent_id', ferc1_engine) \
    [['respondent_name','respondent_id']] \
    .astype({'respondent_name':'str','respondent_id':'str'})
# add missing respondents
f1_respondent_id_manual_additions = pd.DataFrame([['Tri-State G & T Assn, Inc', '529'], \
                                                  ['Basin Electric Power Coop', '531'] \
                                        ], columns=['respondent_name','respondent_id'])
f1_respondent_id = f1_respondent_id.append(f1_respondent_id_manual_additions,ignore_index=True)
# edit respondents with missing names
f1_respondent_id.loc[f1_respondent_id['respondent_id']=='514','respondent_name'] = 'AEP Texas Inc'
f1_respondent_id.loc[f1_respondent_id['respondent_id']=='519','respondent_name'] = 'Upper Michigan Energy Resources Company'
f1_respondent_id.loc[f1_respondent_id['respondent_id']=='522','respondent_name'] = 'Liberty Utilities (CalPeco Electric) LLC'
zaneselvans commented 3 years ago

These IDs have been assigned to utilities since the 2019 ferc1 data was integrated, so I'll close this issue. Note that we found ID 522 matched to Luning Energy Holdings LLC, Invenergy Investment Co.