How can I find columns with all zeros in my matrix?
    29 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 Resizing and Reshaping 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!