How can I find columns with all zeros in my matrix?
70 views (last 30 days)
Show older comments
Nick Thomas
on 28 Apr 2018
Commented: Asko Köhn
on 16 Mar 2021
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?
0 Comments
Accepted Answer
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
0 Comments
More Answers (1)
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
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.
See Also
Categories
Find more on Matrix Indexing 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!