Fill missing NaN values with Interpolation

126 次查看（过去 30 天）
ZaidiN
ZaidiN 2018-7-12
评论： Tsehaye Gebreteklie 2022-4-19
I have Matlab 2013, and I want to apply spline interpolation in my data matrix with NaN values. Is there any other method which can do this. As fillmissing functon is not available in lower versions.
  2 个评论
Tsehaye Gebreteklie
Tsehaye Gebreteklie 2022-4-19
knnimpute is prefere than spline. you can write the code like this.
clear all;
clc;
Temp = xlsread(A);
Filldata=knnimpute(Temp);

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2018-7-12
a = rand(100,1) ;
% put some NaN's
a(randsample(100,20)) = NaN ;
%%interpolate
x = 1:length(a) ;
a(isnan(a)) = interp1(x(~isnan(a)),a(~isnan(a)),x(isnan(a))) ;
plot(x,a,'.r')
hold on
plot(x,a,'b')
  1 个评论
EMMA POLLARD
EMMA POLLARD 2021-2-23
@KSSV Is there a way to use the above method but omit larger gaps of data? For example if there is a string longer than 5NaN values could it avoid interpolating these sections?
Thanks

请先登录，再进行评论。

更多回答（1 个）

ZaidiN
ZaidiN 2018-7-12
Is this spline interpolation? Secondly this doesnt fill the locations of NaN with interpolated points.
  1 个评论
Pawan Sharma
Pawan Sharma 2020-5-12
This is liner interpolation. To make it spline interpolation, add spine as a method of interpolation
a(isnan(a)) = interp1(x(~isnan(a)),a(~isnan(a)),x(isnan(a)), 'spline') ;
It do replace NaNs with interpolated values.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Interpolation 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by