search

NREL / buildstock-query

BuildStockQuery is a python library for querying datasets generated by ResStock™ and ComStock™.
https://nrel.github.io/buildstock-query/
BSD 3-Clause "New" or "Revised" License
7 stars 1 forks source link

More efficient timeseries querying w/o aggregation #16

Open aspeake opened 1 year ago

aspeake commented 1 year ago

Enhancement Request

If aggregation is not needed when querying timeseries, there is likely a more efficient way to retrieve data. By default, aggregate_timeseries() will always aggregate data, to avoid this, a user could pass a group_by=building_id and get individual timeseries for all buildings. For this scenario, building an Athena query that does not have any groups or aggregations would be quicker to retrieve (by about ~15% according to my tests).

afontani commented 1 year ago

This feature might also help our Power Outage analysis.

cc: @whiphi92