convert all records to their "true gran" for easier connection btw depreciation data and FERC steam

catalyst-cooperative / rmi-ferc1-eia

A collaboration with RMI to integrate FERC Form 1 and EIA CapEx and OpEx reporting

MIT License

3 stars 3 forks source link

convert all records to their "true gran" for easier connection btw depreciation data and FERC steam #53

Closed cmgosnell closed 4 years ago

cmgosnell commented 4 years ago

The EIA master unit list (MUL) contains all possible granularities of plants, but sometimes many of those are duplicates. We have incorporated a flag for when a MUL record is a "true granularity" (relevant columns= ['true_gran', 'appro_part_label', 'appro_record_id_eia']).

When trying to connect the deprecation data to the FERC1 steam records, if we first convert all MUL connections to their "true gran"s then we can avoid some headaches.

cmgosnell commented 4 years ago

wahoo! doing increased the number of records that match perfectly from 9% to 20%. Progress. I'll take it.