MATLAB: Problem with statistical function(s) when it’s input is matrix containing some NaN

input of functionnanreturns nan

Hi, I've imported a table from MS Excel to matlab using import wizard. There were some #DIV/0 in excel table, represented as NaN in matlab, which is correct. But, when i use function median and it's input is matrix with NaNs, median returns NaN. Is there any option how to make matlab to skip NaNs when calculating such task without writing any loop or thg like that?

Thanks!!!

Best Answer

http://www.mathworks.com/help/toolbox/stats/nanmedian.html

http://www.mathworks.com/help/toolbox/stats/nanmean.html

Related Solutions

MATLAB: Finding values of specific range from table row or column

>> A = [12345 NaN NaN NaN NaN 457 NaN NaN  NaN 785  NaN NaN NaN NaN NaN NaN 74502].'
A =
  12345
  NaN
  NaN
  NaN
  NaN
  457
  NaN
  NaN
  NaN
  785
  NaN
  NaN
  NaN
  NaN
  NaN
  NaN
  74502

Method one: accumarray:

>> C = accumarray(cumsum(~isnan(A)),A,[],@(v){v});
>> C{:}
ans =
  12345
  NaN
  NaN
  NaN
  NaN
ans =
  457
  NaN
  NaN
  NaN
ans =
  785
  NaN
  NaN
  NaN
  NaN
  NaN
  NaN
ans =
  74502

Method two: mat2cell:

>> X = diff(find([true;diff(isnan(A))<0;true]));
>> C = mat2cell(A,X,1);
>> C{:}
ans =
  12345
  NaN
  NaN
  NaN
  NaN
ans =
  457
  NaN
  NaN
  NaN
ans =
  785
  NaN
  NaN
  NaN
  NaN
  NaN
  NaN
ans =
  74502

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

MATLAB: How to replace findpeaks() with another function

https://nl.mathworks.com/matlabcentral/fileexchange?term=peak+find

Any of these options on the file exchange might help you.

Best Answer

Related Solutions

MATLAB: Finding values of specific range from table row or column

MATLAB: How to replace findpeaks() with another function

Related Question