Forum Discussion
Interpolate missing data with group by column
ronrsnfld Thanks for all the inputs but unfortunately I do not have any idea on how to manage it.
could you please suggest a best method of implementation where we can fill those missing data.
The suggestions would have to do with the shape of the data. I'm sure someone better versed in statistics would have a better idea, but the data you present does not seem lend itself to a least-squares trend.
Here is a graph of your data for the first day:
For where you have one or two blanks within the data, I suppose you could just "connect the dots". But what do you do for the first twelve data points? There is nothing to connect to, and the pattern is not well defined. Although anything can be programmed, you are the one that will need to decide what to do. I don't know of a viable method to interpolate long periods given this kind of data. One or two missing are probably not a problem. But you have much more than that at the start of your data.