pudl icon indicating copy to clipboard operation
pudl copied to clipboard

Reshape EIA-176 data into tidy (long) format

Open davidmudrauskas opened this issue 10 months ago • 1 comments

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.

davidmudrauskas avatar Apr 10 '24 05:04 davidmudrauskas

@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!

e-belfer avatar Apr 24 '24 15:04 e-belfer