openclimatefix / nowcasting_datamodel

Datamodel for the nowcasting project
6 stars 6 forks source link

update get_gsp_yield_sum to return numerical values #208

Closed rachel-labri-tipton closed 1 year ago

rachel-labri-tipton commented 1 year ago

Detailed Description

The get_gsp_yield_sum function currently returns nan values for solar_generation_kw.

Context

This function is being used to visualize PVLive Estimate and PVLive Updated national values as the sum of GSP estimate and truth values in the Analysis Dashboard and numerical values are needed.

Possible Implementation

In read_gsp.py, update get_gsp_yield_sum with the following code: query = query.where(GSPYieldSQL.solar_generation_kw+1 > GSPYieldSQL.solar_generation_kw). This should return a numerical value for solar_generation_kw in the GSPYield object.