replace missing value in a matrix using intropolated values

Question

Skirt Zhang 2013-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58940-replace-missing-value-in-a-matrix-using-intropolated-values

Dear All,

I have a matrix A as below: A =

    1.1093   -0.7697    1.1006   -0.6156    0.4882   -0.8045    0.1049
       NaN       NaN       NaN       NaN       NaN       NaN       NaN
       NaN       NaN       NaN       NaN       NaN       NaN       NaN
   -1.2141    1.1174   -1.4916    0.8886    1.4193   -0.2437   -0.6669
   -1.1135   -1.0891   -0.7423   -0.7648    0.2916    0.2157    0.1873
   -0.0068       NaN   -1.0616   -1.4023    0.1978   -1.1658   -0.0825
    1.5326    0.5525       NaN   -1.4224    1.5877   -1.1480       NaN

I want to replace the NaN with the values generated from interpolation which can take care of both the interpolation for rows and column. So far I have in mind is take interpolation for row get value a_row; then do it for column get a_column. In the end replace nan with the mean value for the two. Can anyone help me about this? Also, I have problems with specifying y for the function : output(a)= interp1(A,y,'linear');

if I don't know y how should I specify here?

thanks a lot in advance

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2013-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58940-replace-missing-value-in-a-matrix-using-intropolated-values#answer_71312

编辑：Andrei Bobrov 2013-1-16

在 MATLAB Online 中打开

one way

t = ~isnan(A);
[x,y] = find(t);
F = TriScatteredInterp(x,y,A(t));
[ii,jj] = ndgrid(1:size(A,1),1:size(A,2));
out = F(ii,jj);

ADD variant

out(end) = mean(cellfun(@(x)interp1(1:2,x(1:2),3,'linear','extrap'),...
                       {out(end,end-[2 1 0])', out(end-[2 1 0],end),...
                                out(end - (size(out,1)+1)*(2:-1:0))'}));

2 个评论
显示无隐藏无

Skirt Zhang 2013-1-16

Hi Bobrov, thanks for your reply. But now I still have NaNs in the output which are located in the end of the matrix. Do you have any idea to solve this problem