Problem with interpolating missing data

Question

D.J 2018-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422093-problem-with-interpolating-missing-data

评论： Star Strider 2018-10-4

Hi all, I have the following data:

d=[1:13]'
 T_Req3 = [
        26     24.6
  27.3  26.4
  19.3  16.1
  24.3  23.3
  25.1  21.2
        26.2  25.6
  29.7  28.7
  32.7  30.9
  28.5  27.3
  30.5  30.3
  NAN  33.3
  35.5  35.2
  26.1  25.4];

I need to find the value of NaN using interpolation. I tried the following code but didn't work: Any help would be highly appreciated. Thank you

Tl1 = T_Req3;
  %Using the"find" function to filter the the NAN data
 f = find(~isnan(T_Req3(11,:)));
    % 4- Using the interpolation function to estimate the value of Tmax29
    Tl1(11,1) = interp1(d(f),T_Req3(11,f),1);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2018-10-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422093-problem-with-interpolating-missing-data#answer_339664

在 MATLAB Online 中打开

Try this:

d_T_Req3 = cat(2, d, T_Req3);                               % Concatenate
idx = ~any(isnan(d_T_Req3), 2);                             % Logical Index Of Rows Without ‘NaN’
T_new = interp1(d_T_Req3(idx,1), d_T_Req3(idx,2:end), d)    % Interpolate
T_new =
             26         24.6
           27.3         26.4
           19.3         16.1
           24.3         23.3
           25.1         21.2
           26.2         25.6
           29.7         28.7
           32.7         30.9
           28.5         27.3
           30.5         30.3
             33        32.75
           35.5         35.2
           26.1         25.4

2 个评论
显示无隐藏无

D.J 2018-10-4

This is actually a much better answer as it shows both columns,, while the solution provided before displays only one column.

Thank you Star ! much appreciated

Star Strider 2018-10-4

As always, my pleasure!

请先登录，再进行评论。

Answer 2

Kevin Chng 2018-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422093-problem-with-interpolating-missing-data#answer_339656

编辑：Kevin Chng 2018-10-4

在 MATLAB Online 中打开

Hi D J,

Hope my code could help you.

 T_Req3 = [
        26     24.6
  27.3  26.4
  19.3  16.1
  24.3  23.3
  25.1  21.2
        26.2  25.6
  29.7  28.7
  32.7  30.9
  28.5  27.3
  30.5  30.3
  NAN  33.3
  35.5  35.2
  26.1  25.4];
[TF,F] = fillmissing(T_Req3,'linear')