ElectricityLCI icon indicating copy to clipboard operation
ElectricityLCI copied to clipboard

Duplicate emission factors in gen_db for ELCI_3

Open WesIngwersen opened this issue 5 years ago • 2 comments

Recreating the old model there are indeed duplicate emission factors in the gen_db. The duplicates appears to be due to different ReliabilityScores. Actually in cases the scores are the same but looking closely its the only difference in other records.

import electricitylci

#Select model ELCI_3 from electricitylci.utils import fill_default_provider_uuids all_generation_db = electricitylci.get_generation_process_df() all_generation_db_cols = all_generation_db.columns all_generation_db_cols_minus_reliability = all_generation_db_cols.drop('ReliabilityScore') dups_true_or_false = all_generation_db.duplicated(subset=all_generation_db_cols_minus_reliability) #lots of Trues indicating duplicate cols when reliability score is dropped

WesIngwersen avatar Oct 04 '19 02:10 WesIngwersen

I found many duplicates before emission factor calculations due to FRS ID. Please check this file. If we solve this maybe the EF wont have any duplicates.

https://drive.google.com/open?id=1360cELnkJFRsGWFqgfz8Qvixe5mHNLIg

tjlca avatar Oct 20 '19 02:10 tjlca

As described this is present in data from stewicombo. I created this issue

WesIngwersen avatar Oct 25 '19 20:10 WesIngwersen