How to find the mean between rows by a group with missing data in a forward-looking format?
I'm running into this issue where I have two sets of datapoints across my timeline. One is collected at every point in the interval "Temperature (Celsius)", the other is collected sporadically "Residual Glucose (g/L)". When placed together in a data table, one of the columns is missing data in the interval. I attached a data table as an example but essentially looks like this: What I need is to g...