MATLAB: How do we eliminated (empty or zeros) Columns or Rows from tables in Matlab

importing excel dataMATLABtable

Dear all

i have read tables using matlab, in my dataset some existed rows and columns are fully empty or contain zero's values, how do we can eliminated these columns or rows from tables , thanks for any suggestion

Best Answer

To eliminate columns fully containing NaN in table t, use

t(:,all(ismissing(t)))=[];

Similar logic for zero values; be careful what you eliminate looks like you could get down to having very little left, perhaps...

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: 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');

Best Answer

Related Solutions

MATLAB: Sum two variables ignoring NaN

MATLAB: Correlation between two row matrices

Related Question