15,916,463 members
1.00/5 (1 vote)
See more:
'Interpolation' is a technique that is used to predict a null/empty value by studying its neighbouring points.

Interpolation doesn't take into consideration the entire dataset when predicting the missing value of a column. It only considers the values of the column that is being interpolated.

What I have tried:

So, how does this technique identify the null value's closest neighbours? How does a value that doesn't exist be considered for anything? What is its reference point?
Posted

## Solution 1

To interpolate, you need the "relative position" of the missing point, relative to the "two" points on "either side" of the missing value.

In other words, you can't interpolate unless you have at least 2 points to start with, and you know "about" where the missing value should be.

e.g. If the two points are 6 and 12, a missing "middle value" would be 6 + ((12-6) * .5) = 9.

CPallini 9-Nov-23 5:52am
5.
Andre Oosthuizen 9-Nov-23 13:55pm
And my 5!