MATLAB: Replacing NaN with the average of previous and next cell value

replacing nan

I have a data set like,

time 1 2 3 4 5 6 7 8 
exp1 45 67 78 NaN 80 81 82 83

These are two separate column with time and exp1 as header. how do I replace the NaN with the average of previous cell value and the next. Like in the above example, NaN should be replaced by 79 ((78+80)/2 )

Thanks in advance

Best Answer

This sounds like a use for fillmissing with linear option:

>> exp1 = [45 67 78 NaN 80 81 82 83];
>> fillmissing(exp1,'linear')
ans =
      45    67    78    79    80    81    82    83

Related Solutions

MATLAB: What is the simplest way to extract lengths of NaN sequences from a vector

Given sequences in a vector of NaNs, you find the location of the start, then find the end. the length is given by the difference. So how do you do it? SIMPLE. Use string search tools.

S = 1:100;
S(rand(size(S)) > .5) = NaN;

So roughly 50% NaNs. I'd bet there are some sequences in there.

Nanstart = strfind([0,isnan(S)],[0 1]);
Nanend = strfind([isnan(S),0],[1 0]);

The length of each sequence is just 1 more than the difference.

Nanlength = Nanend - Nanstart + 1;
S
S =
  Columns 1 through 31
   NaN     2   NaN     4     5   NaN     7     8   NaN   NaN   NaN   NaN   NaN   NaN    15    16   NaN   NaN    19   NaN   NaN    22    23   NaN    25   NaN    27    28    29    30    31
  Columns 32 through 62
    32   NaN   NaN   NaN   NaN    37   NaN   NaN   NaN    41    42    43   NaN    45   NaN    47    48    49   NaN   NaN   NaN   NaN    54   NaN   NaN    57    58    59    60    61   NaN
  Columns 63 through 93
    63   NaN    65   NaN    67   NaN    69    70   NaN    72    73   NaN    75   NaN    77   NaN   NaN   NaN    81    82   NaN    84    85    86   NaN    88    89   NaN    91   NaN   NaN
  Columns 94 through 100
    94   NaN   NaN   NaN    98   NaN   NaN
Nanstart
Nanstart =
     1     3     6     9    17    20    24    26    33    38    44    46    50    55    62    64    66    68    71    74    76    78    83    87    90    92    95    99
Nanlength
Nanlength =
     1     1     1     6     2     2     1     1     4     3     1     1     4     2     1     1     1     1     1     1     1     3     1     1     1     2     3     2

MATLAB: Grouping the pixel having same values

I =[83   81   81   84   85   84   82   82   84   81   83   83   81   81
83   81   81   83   83   82   80   81   83   80   82   83   81   79
81   79   83   84   84   84   81   81   82   80   81   81   79   79
79   80   82   86   85   84   83   83   85   85   81   81   79   79
79   81   84   85   85   83   83   83   84   83   81   83   81   81
84   83   84   85   85   83   84   80   81   81   81   82   82   83
83   84   86   85   85   83   84   80   79   80   82   82   81   83 ];
d = unique(I);
out = [];
for jj = 1:numel(d)
    r = bwconncomp(I == d(jj),4);
    out = [out;[repmat({d(jj)},r.NumObjects,1) r.PixelIdxList']];
end

d = unique(I);
out = [];
for jj = 1:numel(d)
    s=regionprops(bwconncomp(I == d(jj),4),'PixelList');
    out = [out;[repmat({d(jj)},numel(s),1) {s.PixelList}']];
end
[ii,ii] = sortrows(cell2mat(cellfun(@(x)x(1,:),out(:,2),'un',0)),[2 1]);
out = out(ii,:);

Best Answer

Related Solutions

MATLAB: What is the simplest way to extract lengths of NaN sequences from a vector

MATLAB: Grouping the pixel having same values

Related Question