Click here to Skip to main content
15,916,463 members
Please Sign up or sign in to vote.
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?

1 solution

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.
Share this answer
CPallini 9-Nov-23 5:52am    
Andre Oosthuizen 9-Nov-23 13:55pm    
And my 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900