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
456 stars 105 forks source link

Reshape EIA-176 data into tidy (long) format #3555

Open davidmudrauskas opened 2 months ago

davidmudrauskas commented 2 months ago

Tidy the table, so that each row represents a single observation of many coincident variables, with one variable per column. The natural primary key identifying each row appears to be (report_year, area, id). Once the table is tidied with clean columns, the line and itemsort information should probably be gone.

e-belfer commented 2 months ago

@davidmudrauskas Happy to chat about the design process here for the transformation, or look over a draft PR. Just nudge me if you need anything!