How to compare two matrices of different dimensions?

2 次查看(过去 30 天)
I have a matrix B of dimension bx2 and a matrix A of dimension ax5 with the following characteristics:
B=[1 18; 1 19; 3 1; 4 18; 4 20; 5 18; 6 12] %In the first column of B elements are always in ascending order but can be repeated more than once
A=[1 18 19 19 20; 2 7 8 9 10; 3 1 2 2 3; 4 18 19 19 20; 5 18 19 19 20; 6 11 12 13 14] %In the first column of A elements are always in ascending order, they start from 1 and end at a=6 and they are at a distance of 1
I want to construct a matrix C of dimension ax5
C=[1 1 1 0 0; 2 0 0 0 0; 3 1 0 0 0; 4 1 0 0 1; 5 1 0 0 0; 6 0 1 0 0]
Basically in C I do the following: I take A(i,1) and pick the rows j of A with B(j,1) equal to A(i,1); for these rows I pick B(j,2) and reports C(i,h)=1 is B(j,2)=A(i,h).

采纳的回答

Andrei Bobrov
Andrei Bobrov 2014-4-29
编辑:Andrei Bobrov 2014-4-30
B=[1 18; 1 19; 3 1; 4 18; 4 20; 5 18; 6 12];
A=[1 18 19 19 20; 2 7 8 9 10; 3 1 2 2 3; 4 18 19 19 20; 5 18 19 19 20; 6 11 12 13 14];
x = accumarray(B(:,1),B(:,2),[max(B(:,1)),1],@(x){x});
C = [A(:,1),cell2mat(arrayfun(@(z)ismember(A(z,2:end),x{z}),A(:,1),'un',0))];
add
A = [5 18 19 19 20
2 7 8 9 10
6 11 12 13 14
1 18 19 19 20
4 18 19 19 20
8 30 21 0 15];
B=[1 18; 1 19; 3 1; 4 18; 4 20; 5 18; 6 12];
x = accumarray(B(:,1),B(:,2),[max(B(:,1)),1],@(x){x});
C = zeros(size(A));
C(:,1) = A(:,1);
[l,ii] = ismember(A(:,1),(1:numel(x))');
ix = find(l);
ia = ii(l);
C(l,2:end) = cell2mat(arrayfun(@(y,z)ismember(A(y,2:end),x{z}),ix,ia,'un',0));
  2 个评论
MRC
MRC 2014-4-29
编辑:MRC 2014-4-29
I have just realized that if the last/first element of B(:,1) is different from the last/first element of A(:,1) (6 in this case), the code does not work. Could you fix it? Thanks

请先登录,再进行评论。

更多回答(1 个)

Georgia Petsios
Georgia Petsios 2018-1-18
this solution doesnt work with double matrices..

类别

Help CenterFile Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by