MATLAB: How to exchange all values of a row to zero, if this row contains one or more NaNs

nannan to zerorow

Hey guys,

I have a matrix like that:

2945 545 2 2 2,82; 2394 345 NaN 3 4,89; 3453 123 23 4 NaN; 4564 435 53 2 2,98

How can I change all numbers of a row which contains one or more NaNs to zero? The desired output would be:

2945 545 2 2 2,82; 0 0 0 0 0; 0 0 0 0 0; 4564 435 53 2 2,98

Thanks a lot for your help! Valle

Best Answer

yourmatrix(any(isnan(yourmatrix), 2), :) = 0

Related Solutions

MATLAB: Row numbers of the first zero, repeated

Your first element is a zero. Should that be included in the output? So you just want the last non-zero number in a stretch of non-zero numbers before it turns into a 0, right? Try this:

m = [0 0 0 0 30 60 90 120 119 118 2 1 0 0 0 3 4 0] % Create sample data.
dm = diff(m~=0) % Threshold and find element-to-element differences.
lastElements = find(dm == -1)  % Find the indexes where it goes to zero.

MATLAB: Is corr/corrcoef returning NaNs

You can use

corr(OptimismBias, AmbigTolG, 'rows', 'complete')

to ignore the NaN values.

Best Answer

Related Solutions

MATLAB: Row numbers of the first zero, repeated

MATLAB: Is corr/corrcoef returning NaNs

Related Question