Combine 2 column matrix into 1 column matrix

Question

Phong Pham 2015-2-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/178736-combine-2-column-matrix-into-1-column-matrix

编辑： Stephen23 2015-2-16

采纳的回答： Stephen23

在 MATLAB Online 中打开

I have a matrix A which contains x components, Note that A have multiple rows and columns.

Let's say

   A=[ 1   2   3   4   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];

Now I want A to be

     A=[ 1   2   3   4 ;
       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 ];
Note that the matrix is big so I cant use my vision to do so. I want to combine the one that has 0 as starting point (A(1,:)=0) to the one that has zero somewhere which is the first column and the condition is that the last point of first column is closer to the value of last column (you can see the last column has value of 1.5 which is closer to 1.2 that is why I combine them together)

Please helps. I am appreciated your opinions and helps.

2 个评论
显示无隐藏无

Guillaume 2015-2-16

You haven't explained very well what you want to do.

You say that 'B is same as A' and that you 'want A to be [..] same as B'. That would mean that A stays the same.

With the example you've given, it looks like you're removing the last column and if a row of that column is not 0, replace the first column of the same row with it. Is that what you want? Probably not, as it does not involve combining any matrix.

Image Analyst 2015-2-16

Clear as mud. Even after reading several times and looking at the example.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2015-2-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/178736-combine-2-column-matrix-into-1-column-matrix#answer_168196

编辑：Stephen23 2015-2-16

在 MATLAB Online 中打开

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 =
0    2.0    3.0    4.0
1    2.1    3.1    4.1
2    2.2    3.2    4.2
    2.3    3.3    4.3
    2.4    3.4    4.4
5    2.5    3.5    4.5
6    2.6    3.6    4.6