Clear Filters
Clear Filters

How can I find columns with all zeros in my matrix?

98 views (last 30 days)
I've got a large matrix A and would like to find out if any of the columns contain only zeros. I've found a solution for finding all the rows with only zeros but I'm not sure how to make it all columns.
Also, would there be a way to find out which columns have exactly 4 or 3 or 2 or X nonzero entries?

Accepted Answer

Kaushik Lakshminarasimhan
Kaushik Lakshminarasimhan on 28 Apr 2018
Edited: Kaushik Lakshminarasimhan on 28 Apr 2018
cols_with_all_zeros = find(all(A==0)); % all zeros
cols_with_3_nonzeros = find(sum(A~=0)==3); % exactly 3 non-zeros

More Answers (1)

Ameer Hamza
Ameer Hamza on 28 Apr 2018
"I've found a solution for finding all the rows with only zeros"
If you find the solution for rows, just apply to transpose of A (i.e. A'). The rows of A' will represent corresponding columns of A. Nevertheless, the following code will give you the index of all zeros columns
columnNumbers = find(sum(abs(A)) == 0)
To find out which columns have X nonzero entries, do the following
X = 2; % columns having 2 nonzero elements
columnNumbers = find(sum(A~=0) == 4)
  1 Comment
Asko Köhn
Asko Köhn on 16 Mar 2021
Apart from transposition of the input matrix in order to check rows instead of columns or vice versa, the same can be achieved by use of the dimension input parameter with the suggested solutions and also with any(), in which case the comparison operation with zero can be dispensed with:
col_nums = find(~any(A,1)) %default for 2D array
row_nums = find(~any(A,2))
(If A is a multidimensional array, then sum(A) operates along the first array dimension whose size does not equal 1, treating the elements as vectors. This dimension becomes 1while the sizes of all other dimensions remain the same.

Sign in to comment.


Find more on Operating on Diagonal Matrices in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!