MATLAB: How to delete a zeros in matrix

mathematicsmatrixmatrix arraymatrix manipulation

I have a matrix like this

 a=[ 0.7446    0.0364  186.1153         0  134.5022  114.8212   84.7745  130.8661
          0         0   13.8840         0   16.1683   10.4461   69.8035  114.2774];

i want to delete zeros and their corresponding values. The solution should be like this…

 b= [186.1153 134.5022  114.8212   84.7745  130.8661
     13.8840  16.1683   10.4461   69.8035  114.2774];

Best Answer

This will get rid of all columns that have a zero anywhere in them:

colsWithZeros = any(a==0)
b = a(:, ~colsWithZeros)

Related Solutions

MATLAB: How to count specific numbers in a matrix

sum(X(:)>100);

MATLAB: How to convert a char into double

Note that there are not only numbers in that string, it also contains 'S' characters apparently at random, e,g.:

>> f(8480:8500)
ans =
3 -118 S 623 1623 -71
%      ^ not digit character!

One simple and efficient solution is to remove those 'S' characters before using sscanf:

v = sscanf(strrep(f,'S',''),'%d');

This correctly returns all 4297 numbers in the string, and can be easily adapted (e.g. using regexprep to remove specific types of characters, e.g. if it is possible that other alphabetic characters might occur in the string).

The simplest and most efficient solution by far is this:

v = sscanf(f,'%d%*[S ]');

Nothing will beat that simple command in terms of simplicity or speed.

Best Answer

Related Solutions

MATLAB: How to count specific numbers in a matrix

MATLAB: How to convert a char into double

Related Question