Using monthly home sale data from to 2009 to 2023 for each of 82 separate neighborhoods, there are months with zero sale data. See Image. [1] As you can see, the range of months of missing data varies greatly (zeros are there simply because I used the Missing Value node, which can just as easily be converted back to “?”). I can’t use the pre-formatted functions in the Missing Value node, such as Mean, Median, or Moving Average, as the range of years’ data and sporadic zeros would create huge errors. Next Value or Previous Value won’t work due to the unevenly placed zeros. [2] I’m thinking that perhaps the Rule Engine or Math Formula nodes might be able to help me “average” the previous non-zero value with the next available non-zero value, but have not come up with a way to automatically seek the non-zero value in each direction since there may be 1-6 or more zeros clustered in the column. [3] Any suggestions are appreciated. A single neighborhood of data is attached in excel format ~$temp.xlsx (165 Bytes) Thanks!

Auto-Calculating & Populating Missing Data In A Table

mlauber71 November 23, 2023, 6:58am 2

@creedssmith one thing you could do is try the R/Rstudio package Amelia to have a more complex importation of values

I have a python project using several packages somewhere unfinished…

Also there was this suggestion