How to compare rows in a matrix
65 次查看(过去 30 天)
显示 更早的评论
Hello all
I have a matrix A
A =
1 1 0 0 0
0 -1 0 1 0
-1 0 1 1 0
lets say I am looking at the second row in which column 2 and 4 have value present now if I compare it with the row above which has values in the column 1 and column 2 so I want to know the column number which has values in both the rows, I mean here the column number 2 should be returned. Similarly row 3 should be compared with row 1 and 2 and for each row a column number should be returned.
Can anyone please guide me through this.
Regards
1 个评论
Azzi Abdelmalek
2014-7-18
编辑:Azzi Abdelmalek
2014-7-18
What is the expected result for your example?
采纳的回答
Azzi Abdelmalek
2014-7-18
Comparison between row 1 and row 2
A =[ 1 1 0 0 0
0 -1 0 1 0
-1 0 1 1 0]
idx=find(all(A(1:2,:)))
3 个评论
Azzi Abdelmalek
2014-7-18
A =[ 1 1 0 0 0
0 -1 0 1 0
-1 0 1 1 0]
jj=0;
for k=2:size(A,1)
for p=1:k-1
B=A([p,k],:)
jj=jj+1;
out{jj,2}=find(all(B))
out{jj,1}=sprintf('(%d,%d)',k,p)
end
end
更多回答(1 个)
the cyclist
2014-7-18
I think that
[rows,cols] = find(A(2:end,:)~=0 & A(1:end-1,:)~=0)
does what you want.
rows will be the index to the "top" row being compared, and "cols" will be the column numbers that meet your criterion.
For example, in your case
rows = [1; 2];
and
cols = [2; 4];
cols seems to be the main thing you are going for.
2 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!