MATLAB: How to make any math operation when there are NaN in data serial

nan data serial

How to make any math operation when there are NaN in data serial?

I'd like to make an test using in my data serial NaN…

For exemplo: I have 2 matrix (a and b) and I'd like of sum them!!!

Ex:

a=[1,2,3,NaN,5]

b=[1,2,3,8,5]

c=(a+b)

How can I to do?

Best Answer

Try these two different approaches:

a=[1,2,3,NaN,5]
b=[1,2,3,8,5]
cWithNans = a + b % c(4) will = nan
nonNanLocations = ~isnan(cWithNans) % Location of indexes that are good.
cwithoutNans = cWithNans(nonNanLocations)
% c(4) is skipped and new c(4) = old c(5)

Related Solutions

MATLAB: Correlation between two row matrices

Like that, each value of "a" is correlated to each value of "b", but applying the formula of the correlation, the correlation of two single numbers is NaN. To compute the correlation correctly, traspose the input vectors

result  = corr(a', b');

MATLAB: Replace a number in a matrix depending on neighbor numbers

It is unclear if elements connected diagonally count as neighbours. If not, then you could try something like this.

%%Work with At to keep A intact
At=A;
%%Replace NaN with some number
At(isnan(At))=9;
%%B is for saving index of new NaNs
B=zeros(size(At));
%%Find sequences of [2 NaN] and [NaN 2] row-wise
for i=1:size(At,1)
B(i,strfind(At(i,:),[9 2])+1)=NaN;
B(i,strfind(At(i,:),[2 9]))=NaN;
end
%%Transpose A and repeat (same as column-wise)
At=At';
for i=1:size(At,2)
B(strfind(At(i,:),[9 2])+1,i)=NaN;
B(strfind(At(i,:),[2 9]),i)=NaN;
end
A(isnan(B))=NaN

ans =

   NaN   NaN   NaN   NaN   NaN   NaN   NaN
   NaN   NaN   NaN   NaN   NaN   NaN   NaN
   NaN   NaN     1     1     1   NaN   NaN
   NaN   NaN     1     2     1   NaN   NaN
   NaN   NaN     1     1     1   NaN   NaN
   NaN   NaN   NaN   NaN   NaN   NaN   NaN
   NaN   NaN   NaN   NaN   NaN   NaN   NaN

Best Answer

Related Solutions

MATLAB: Correlation between two row matrices

MATLAB: Replace a number in a matrix depending on neighbor numbers

Related Question