Really hard interpolation!!!

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!!!

little test.xlsx

Help

Accepted answers

danilang

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

All comments

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703