Output cell values and column number for matrix with specific values
조회 수: 6 (최근 30일)
이전 댓글 표시
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
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]
% I'd like to produce a matrix of the "locations" of the 1 values in
% columns 3:13.
B =
[1 128 1
1 129 2
1 129 3
1 129 4
1 129 6
1 129 7
1 129 11
1 130 1 . . ]
댓글 수: 0
답변 (2개)
Voss
2022년 4월 18일
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];
B = A(:,[1 2]);
A(:,[1 2]) = [];
[c,r] = find(A.');
B = [B(r,:) c]
댓글 수: 0
Stephen23
2022년 4월 19일
편집: Stephen23
2022년 4월 19일
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]
M = A(:,3:end).';
[C,R] = find(M);
B = [A(R,1:2),C]
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Matrices and Arrays에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!