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
471 stars 108 forks source link

Recategorize fuel types in generation_fuel_eia923 based on heat content #88

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

plotting mmbtu / unit of fuel from records in the generation_fuel_eia923 table, it looks as if many of the fuel types are miscategorized. Either that, or they got munged somehow on ingest. There's a clear distribution showing natural gas, petroleum, lignite, subbituminous, and bituminous coal... kinda no matter which one you select and try to plot. Records can be re-categorized according to fuel heat content, if we want. When records are weighted by the total heat content delivered, the errors aren't as prominent, but it's still there.

gen_fuel_mmbtu_per_unit

zaneselvans commented 7 years ago

It turned out that this issue was coming up because of a bad merge in the data being imported. It's been fixed.