match index of arrays

1 次查看（过去 30 天）
Tiina
Tiina 2017-6-10
评论： Tiina 2017-6-12
Hi, I have a problem with matching and indexing. The problem was raised in this forum earlier and was solved. This is how it was raised
A = [9 10 11 12 13 14 15 16 17]'
B = [10 13 16; 999 900 950]'
The desired solution is
M =
9 0
10 999
11 0
12 0
13 900
14 0
15 0
16 950
17 0
This can be attained as follows
M = A*[1 0]
M(ismember(A,B(:,1)),2) = B(:,2)
My problem is exactly the same but the solution is not working. The only difference I have is the size of A and B
A is too large and is of size(A)
ans =
1035593 1
B is small and is of size(B)
ans =
72 2
Column 1 of B contains unique ids that match unique ids in A. Column 2 is the data to be matched given ids.
When I apply the solution above, I get Subscripted assignment dimension mismatch. I am not sure why this is happening, could you kindly advise or provide an alternative solution.
  1 个评论
Stephen23
Stephen23 2017-6-10
编辑：Stephen23 2017-6-10
>> M = A(:);
>> M(:,2) = 0;
>> [~,ia,ib] = intersect(A,B(:,1));
>> M(ia,2) = B(ib,2)
M =
9 0
10 999
11 0
12 0
13 900
14 0
15 0
16 950
17 0
If you are having problems than you will need to check that every value in column one of B exists once in columns one of A.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2017-6-10
You would get that error if there are columns in B that are not matched in A.
[~, ia, ib] = intersect(A, B(:,1));
M(ia,:) = B(ib,:);
  7 个评论
显示 5更早的评论
Walter Roberson
Walter Roberson 2017-6-11
I loaded your data and then did
M = A*[1 0];
[~, ia, ib] = intersect(A, B(:,1));
M(ia,:) = B(ib,:);
there were no error messages.
Tiina
Tiina 2017-6-12
I restarted Matlab and it works fine. Thank you.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by