Missing Dates, Time Series, Linear Interpolation
In a 13 year series of data there are several gaps in monthly data. With help, I was able to use Linear Interpolation in the Missing Value node for numeric data like “sold price”, etc., and with some recent help (Date&Time to SerialNumber – KNIME Community Hub and Sporadic Missing Dates In Time Series Data - #2 by takbb ) was able to solve the missing dates via Linear Interpolation.
I’m just trying to fix a bit of a glitch where the LI produces the same date several times in a row. Admittedly, LI repeats the numeric values such as close price when there’s no solid beginning or end known data in the series, but the price repetition is okay for a time series presentation. Whereas, repeating dates does not work out as well when presenting time series data.
Here’s some snap shots of the output. Perhaps you have a know method for dealing with time series glitches and the shortcoming of Linear Interpolation.
The missing date LI system linked above works great where I have know dates at the beginning and end of the data gaps (below):
Where date interpolation repeats is when I’m missing a known beginning or end value (below). And don’t worry about two different neighborhoods named in this table. All the calculations occur in a Group Loop series per each neighborhood. This table is combined after the Linear Interpolation.
Any suggestions on correcting these repeating dates is very appreciated.