MATLAB: Replacing NaN with it previous element

nan

 Dear all,
I have
K={
    'IT'     'ooil'    'TTT'    [  0]    [4.1583]
    'IT'     'ooil'   'TTT'    [  0]    [4.0339]
    'IT'     'ooil'    'TTT'    [  0]    [3.9389]
    'IT'     'ooil'    'TTT'    [  0]    [3.9676]
    'ITn'     'ooilb'    'TTT'    [  0]    [3.9313]
    [NaN]    [      NaN]    [NaN]    [  0]    [3.9313]
    'IT'     'ooil'    'TTT'    [  0]    [3.8720]
    'ITcv'     'ooila'     'TTT'    [  0]    [3.8829]
    [NaN]    [      NaN]    [NaN]    [  0]    [3.9313]
    'IT'     'ooil'    'TTT'    [  0]    [3.8681]
    'ITf'     'ooilg'     'TTT'    [  0]    [4.3944]
    [NaN]    [      NaN]    [NaN]    [  0]    [3.9313]}
And I want to replace the NaNs in each column with its previous element of the same column
That is,
K={
  'IT'     'ooil'    'TTT'    [  0]    [4.1583]
  'IT'     'ooil'   'TTT'    [  0]    [4.0339]
  'IT'     'ooil'    'TTT'    [  0]    [3.9389]
  'IT'     'ooil'    'TTT'    [  0]    [3.9676]
  'ITn'     'ooilb'    'TTT'    [  0]    [3.9313]
  'ITn'     'ooilb'    'TTT'    [  0]    [3.9313]
  'IT'     'ooil'    'TTT'    [  0]    [3.8720]
  'ITcv'     'ooila'     'TTT'    [  0]    [3.8829]
  'ITcv'     'ooila'     'TTT'    [  0]    [3.9313]
  'IT'     'ooil'    'TTT'    [  0]    [3.8681]
  'ITf'     'ooilg'     'TTT'    [  0]    [4.3944]
  'ITf'     'ooilg'     'TTT'    [  0]    [3.9313]}
Thanks in advance

Best Answer

 res=K,
 for k=1:size(K,1);
     if isnan(K{k,1});
       res(k,1:3)=K(k-1,1:3);
     end;
 end
Related Question