15,917,971 members
0.00/5 (No votes)
See more:
Definition of interpolation - Interpolation predicts values at a point by studying its neighbouring points (within the same column), as opposed to data modeling where all the columns are taken into considering when studying the relationship between points.

What I have tried:

Following are the points gathered as part of my research on interpolation & my doubts:

1. Interpolation assumes smoothness & continuity between consecutive data points when connected using curves/lines. So mixing up/sorting of values in the column will affect the interpolation lines/curves & the subsequent results negatively. Hence, we must not modify the order of data points in the dataset.

Doubt - When these data points are plotted on a graph, then the proximity of the values/data points to one another will depend on the magnitude of the values anyways, i.e., values closer in number will lie closer to each other. It doesn't matter how they were ordered in the dataset. So why is there so much emphasis on preserving the original order of the dataset values?

And how practical is it to assume that the person who has prepared the dataset has arranged the values in an order that ensures continuity & smoothness between data points of the column under consideration? We don't know which column has been considered as the key for the ordering of rows.

Note: I have explained my understanding & doubts as detailed as possible. In case my understanding is wrong or my questions aren't clear, do let me know.
Posted
Updated 9-Dec-23 3:40am
Comments
[no name] 10-Dec-23 11:31am
The "order" is a reflection of the order in which these points came into existence. Interpolating (or extrapolating) uses that information to "predict" missing points. Without that condition, you just have a bunch of random points that have no relation to each other.

## Solution 1

First off, there is no code to give feedback to here, so the answer is not very good in that respect.

In mathematics, there are different ways of interpolating points. There is the Lagrangian ineterpolation, or Newton interpolation. These are the same principles that use all the points to fit the highest-order polynomial curve that goes through each point.

There are splines that use lower-order polynomial fits to generate a curve, and here you could use the least squares fit of a given degree polynomial.

The problem you have is actually specifying what you actually want, and you didn't.

Comments
Apoorva666 9-Dec-23 11:34am
My question is with regard to interpolation in general, not referring to any particular technique, which is why I used 'curves/lines' when asking my doubt.

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

Top Experts
Last 24hrsThis month
 Rick York 45 CPallini 45 Graeme_Grant 35 merano99 25 Ravi Bhavnani 10
 Pete O'Hanlon 700 OriginalGriff 483 Dave Kreskowiak 405 Richard MacCutchan 310 merano99 235

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