search

open-innovations / jrf-insight

JRF North England Insight Finder
https://open-innovations.github.io/jrf-insight/
MIT License
1 stars 0 forks source link

Decide how to deal with 0.0 entries that are actually N/A #28

Open luke-strange opened 1 year ago

luke-strange commented 1 year ago

No survey in 20/21. NA values displaying as 0.0 but we need to correct this to N/A. Might be a note in the result of the API we can include.

luke-strange commented 1 year ago

HBAI uses 3 year averages, and the guidance says to omit 2020/21 from these calculations.

Image

I will write a function to create a 3 year averaged table, including the above caveat.

luke-strange commented 1 year ago

Looking at the example, the function needs to calculate the average for the year chosen plus the next two years ahead of it.