MATLAB: Replacing elements in a table

find anf replace

I have Table A that constitutes of arrays, Some of the columns were computed using algebraic equations. This yielded certain numbers to be Inf and -Inf

How can I remove these from A and replace them with NaNs?

Best Answer

A=table2array(A);
A(isinf(A)|-isinf(A))=nan;
A=array2table(A)

Related Solutions

MATLAB: Sum two variables ignoring NaN

Try this:

var1 = [1;2;3;nan];
var2 = [4;nan;6; 15];
t = table(var1, var2)
% Initialize with var1
theSum = t.var1;
% If any are nan, replace with value from var2.
badRows = isnan(theSum)
theSum(badRows) = t.var2(badRows)
% If both are not nan, make it the sum
goodRows1 = ~isnan(t.var1)
goodRows2 = ~isnan(t.var2)
goodRows = goodRows1 & goodRows2;
theSum(goodRows) = t.var1(goodRows) + t.var2(goodRows)

You get:

t =

4×2 table

var1 var2

____ ____

1 4

2 NaN

3 6

NaN 15

theSum =

If one is nan, you get the other one which is not a nan.

If both are nans, you get a nan.

If both are not nan, you get the sum.

MATLAB: Replace column

% 2D example:
A = zeros(5)
A(:,3) = 1
% 3D example:
A = zeros(3,3,3)
A(:,2,:) = 1

Best Answer

Related Solutions

MATLAB: Sum two variables ignoring NaN

MATLAB: Replace column

Related Question