MATLAB: Splitting a matrix into submatrices by value

splitting matrices

Hello, I have a 10000×3 matrix called A. The 3rd column of the matrix consists of 0s and 1s. I want to create 2 submatrices where A1 collects all rows of A that has a 1 in the 3rd column. A2 should collect the rest of the columns. How can I do that? Thanks!

Best Answer

Something like this?

 A = [2 3 0 3;...
      3 2 1 3;...
      2 2 1 2]
 A =
     2     3     0     3
     3     2     1     3
     2     2     1     2
 A1 = A(A(:,3)==1,:)
 A1 =
     3     2     1     3
     2     2     1     2
 A2 = A(A(:,3)==0,:)
 A2 =
     2     3     0     3

Related Solutions

MATLAB: How to eliminate column of the matrix

A(:,all(A==0)) = []

MATLAB: Combine 2 column matrix into 1 column matrix

If you want to merge non-zero elements of the last column into the first column, then you can use this:

A = [1.0, 2.0, 3.0, 4.0, 0;...
     1.1, 2.1, 3.1, 4.1, 0;...
     1.2, 2.2, 3.2, 4.2, 0;...
     0,   2.3, 3.3, 4.3, 0;...
     0,   2.4, 3.4, 4.4, 0;...
     0,   2.5, 3.5, 4.5, 1.5;...
     0,   2.6, 3.6, 4.6, 1.6];
X = A(:,end)>0;
A(X,1) = A(X,end);
A(:,end) = [];

This gives A as

A =
    1.0    2.0    3.0    4.0
    1.1    2.1    3.1    4.1
    1.2    2.2    3.2    4.2
    0      2.3    3.3    4.3
    0      2.4    3.4    4.4
    1.5    2.5    3.5    4.5
    1.6    2.6    3.6    4.6

Best Answer

Related Solutions

MATLAB: How to eliminate column of the matrix

MATLAB: Combine 2 column matrix into 1 column matrix

Related Question