Output cell values and column number for matrix with specific values

Question

Emma Kuttler 2022-4-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699425-output-cell-values-and-column-number-for-matrix-with-specific-values

编辑： Stephen23 2022-4-19

Hi,

I have a 105 x 13 matrix where the first two columns represent an identifier and columns 3:13 have values either 0 or 1. What I'd like to do is output the first two columns, and then the column number for cells that have a value of 1. I'd like the column numbering to start at column 3, however, so something that is in actual column 13 should have the value 11.

For example, if this is my matrix A I want to produce B:

A = [ 1	128	1	0	0	0	0	0	0	0	0	0	0
129	0	1	1	1	0	1	1	0	0	0	1
130	1	0	1	0	0	0	0	1	0	0	0
149	0	0	0	0	1	0	1	1	0	0	0
150	1	1	0	0	1	1	1	0	0	0	0
154	1	1	1	1	1	1	0	0	1	1	1]
% I'd like to produce a matrix of the "locations" of the 1 values in
% columns 3:13. 
B = 
[1 128 1
129 2
129 3
129 4
129 6
129 7
129 11
130 1 . . ]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2022-4-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699425-output-cell-values-and-column-number-for-matrix-with-specific-values#answer_945440

在 MATLAB Online 中打开

A = [1	128	1	0	0	0	0	0	0	0	0	0	0
129	0	1	1	1	0	1	1	0	0	0	1
130	1	0	1	0	0	0	0	1	0	0	0
149	0	0	0	0	1	0	1	1	0	0	0
150	1	1	0	0	1	1	1	0	0	0	0
154	1	1	1	1	1	1	0	0	1	1	1];
B = A(:,[1 2]);
A(:,[1 2]) = [];
[c,r] = find(A.');
B = [B(r,:) c]
B = 27×3
 128     1
 129     2
 129     3
 129     4
 129     6
 129     7
 129    11
 130     1
 130     3
 130     8

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Stephen23 2022-4-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699425-output-cell-values-and-column-number-for-matrix-with-specific-values#answer_945910

编辑：Stephen23 2022-4-19

在 MATLAB Online 中打开

Without changing the input matrix A:

A = [1,128,1,0,0,0,0,0,0,0,0,0,0;1,129,0,1,1,1,0,1,1,0,0,0,1;1,130,1,0,1,0,0,0,0,1,0,0,0;1,149,0,0,0,0,1,0,1,1,0,0,0;1,150,1,1,0,0,1,1,1,0,0,0,0;1,154,1,1,1,1,1,1,0,0,1,1,1]
A = 6×13
 128     1     0     0     0     0     0     0     0     0     0     0
 129     0     1     1     1     0     1     1     0     0     0     1
 130     1     0     1     0     0     0     0     1     0     0     0
 149     0     0     0     0     1     0     1     1     0     0     0
 150     1     1     0     0     1     1     1     0     0     0     0
 154     1     1     1     1     1     1     0     0     1     1     1
M = A(:,3:end).';
[C,R] = find(M);
B = [A(R,1:2),C]
B = 27×3
 128     1
 129     2
 129     3
 129     4
 129     6
 129     7
 129    11
 130     1
 130     3
 130     8