Fill missing NaN values with Interpolation

138 次查看(过去 30 天)
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
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 CenterFile Exchange 中查找有关 Interpolation 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by