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

Transform high-priority AEO Table 54 data into normalized assets #3581

Closed
3 tasks done
Tracked by #3464
jdangerx opened this issue Apr 20, 2024 · 0 comments · Fixed by #3588
Closed
3 tasks done
Tracked by #3464

Transform high-priority AEO Table 54 data into normalized assets #3581

jdangerx opened this issue Apr 20, 2024 · 0 comments · Fixed by #3588
Assignees
Labels
eiaaeo EIA Annual Energy Outlook epic Any issue whose primary purpose is to organize other issues into a group. gridlab Work related to open modeling input data integration funded/coordinated by GridLab new-data Requests for integration of new data.

Comments

@jdangerx
Copy link
Member

jdangerx commented Apr 20, 2024

Table 54 has heterogeneous data with a variety of different units, so we'll have to pull those out into multiple different assets.

The first set of data we want to pull out of Table 54 is all the data that's in gigawatts. That will be two assets, one with electricity sector data and one with end-use sector data.

Electricity sales data is also high-priority.

For each, we need to subset the raw table 54 data, transform it into a table with one column for each variable, and then persist it to the database.

These are the high priority resources we need to create:

Resources

Preview Give feedback
  1. jdangerx
  2. jdangerx
  3. jdangerx
@jdangerx jdangerx moved this from New to In progress in Catalyst Megaproject Apr 20, 2024
@jdangerx jdangerx self-assigned this Apr 20, 2024
@jdangerx jdangerx changed the title Transform AEO Table 54 into normalized assets Transform AEO Table 54 GW data into normalized assets Apr 20, 2024
@cmgosnell cmgosnell added the gridlab Work related to open modeling input data integration funded/coordinated by GridLab label Apr 22, 2024
@github-project-automation github-project-automation bot moved this from In progress to Done in Catalyst Megaproject Apr 26, 2024
@jdangerx jdangerx reopened this Apr 29, 2024
@jdangerx jdangerx moved this from Done to In progress in Catalyst Megaproject Apr 29, 2024
@jdangerx jdangerx changed the title Transform AEO Table 54 GW data into normalized assets Transform AEO Table 54 data into normalized assets May 8, 2024
@zaneselvans zaneselvans added epic Any issue whose primary purpose is to organize other issues into a group. new-data Requests for integration of new data. eiaaeo EIA Annual Energy Outlook labels May 13, 2024
@jdangerx jdangerx changed the title Transform AEO Table 54 data into normalized assets Transform high-priority AEO Table 54 data into normalized assets May 14, 2024
@jdangerx jdangerx moved this from In progress to Done in Catalyst Megaproject May 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
eiaaeo EIA Annual Energy Outlook epic Any issue whose primary purpose is to organize other issues into a group. gridlab Work related to open modeling input data integration funded/coordinated by GridLab new-data Requests for integration of new data.
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

3 participants