Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

convert the still baddly mapped plant_id_eia's in the depreciation sheet. #162

Open
1 of 8 tasks
cmgosnell opened this issue Feb 4, 2022 · 0 comments
Open
1 of 8 tasks
Assignees
Labels
deprish Depreciation Data rmi use on all issues in this repo (for project management tools)

Comments

@cmgosnell
Copy link
Member

We used to map the depreciation studies to plant_id_pudl. That was bad bc they change over time. So I converted this id to the plant_id_eia... but there are a lot of records and there are some known errors.

This issue should include:

  • identifying the poorly mapped records
    • the records that are mapped to plant_id_eia's that DON'T EXIST lol see code snipped below
    • the records that we've been unable to match to EIA on the granular level bc of the plant id
    • other wayyys?
  • fix those records (bc we have some mannual overrides this needs to be done in multiple places)
    • in the deprish_raw.xlsx sheet in the raw tab
    • in the deprish_raw.xlsx sheet in the EIA-deprish matching tab
    • in the deprish_common_labels.xlsx sheet
>>> # pudl output object
>>> pudl_settings = pudl.workspace.setup.get_defaults()
>>> pudl_engine = sa.create_engine(pudl_settings["pudl_db"])
>>> pudl_out = pudl.output.pudltabl.PudlTabl(
...     pudl_engine,freq='AS',
...     fill_fuel_cost=True,
...     roll_fuel_cost=True,
...     fill_net_gen=True,
... )
>>> rmi_out = pudl_rmi.coordinate.Output(
...     pudl_out,
... ) 
>>> deprish = rmi_out.grab_deprish()
>>> plants = pudl_out.plants_eia860()
>>> ​
>>> deprish[~deprish.plant_id_eia.isin(plants.plant_id_eia.unique())].plant_id_eia.unique()
<IntegerArray>
[<NA>, 41, 119, 73, 98, 134, 3657, 3660, 3662, 3663, 6, 82, 101, 122, 176, 163, 177, 191, 194, 17633]
Length: 20, dtype: Int64
@cmgosnell cmgosnell added the deprish Depreciation Data label Mar 11, 2022
@aesharpe aesharpe added the rmi use on all issues in this repo (for project management tools) label Mar 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
deprish Depreciation Data rmi use on all issues in this repo (for project management tools)
Projects
None yet
Development

No branches or pull requests

3 participants