Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Tracked by #2603
davidmudrauskas opened this issue Apr 10, 2024 · 1 comment
Open
Tracked by #2603

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

davidmudrauskas opened this issue Apr 10, 2024 · 1 comment
Assignees
Labels
eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. new-data Requests for integration of new data.

Comments

@davidmudrauskas
Copy link
Collaborator

davidmudrauskas commented Apr 10, 2024

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 davidmudrauskas self-assigned this Apr 10, 2024
@zaneselvans zaneselvans changed the title 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. Reshape EIA-176 data into tidy (long) format Apr 13, 2024
@zaneselvans zaneselvans added new-data Requests for integration of new data. eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. labels Apr 13, 2024
@e-belfer
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. new-data Requests for integration of new data.
Projects
Status: In progress
Development

No branches or pull requests

3 participants