Really hard interpolation!!!

[Baoxin]

Hi every expert,

I have a very hard problem here. In this case, I want to interpolate the longitude and latitude with the time by Lagrange's interpolation or cubic spline interpolation. in addition to this ,I want every track ID to interpolate independently.

I would really appreciate it if you could solve my problem!!!

[danilang]

Hi @Baoxin 

Do you mean that you want to interpolate the missing points using one of the two methods or that you want to approximate the entire paths using an interpolation?

Dan

[Baoxin]

hi Dan，

I want to interpolate the missing points

[danilang · Accepted solution]

Hi @Baoxin 

This would be difficult to do in pure Alteryx, but you should able to use a Python tool and leverage the interpolate functionality from scipy

Also, why do you need to use a complex interpolation method?  From browsing your data, looks like a simple linear interpolation would work.

Dan 

[Baoxin]

Really thank for your answer

First,  I used python, but it didn't work out very well. Some of the results look like far from the data.

Second, these data is a very small part of the car track point about two million, because I delete some data such as Velocity and Acceleration and so on. I need to make the lines of these points very smooth, so i choose to use some complex ways.

Maybe, i need improve my Python algorithm……