Horizontally join two datasets of different sizes based on a common field

2 次查看（过去 30 天）
Lucy
Lucy 2014-10-8
评论： Lucy 2014-10-9
Dear all,
I have two matrices (A and B) that I want to join together horizontally based on a common field to create an output as shown in C. I have included a small example of my very large datasets:
A=
3304 1 329 0
3304 1 819 0
3304 2 76 0
3304 1 12 0
3304 2 971 1
3304 1 76 2
3304 2 230 2
3304 1 258 2
3304 1 27 3
3304 1 73 3
3304 2 179 3
3304 3 190 3
B=
0 29.7 27.7 13.2
1 26.3 24.3 14.1
2 28.1 26.1 24.5
3 27.1 25.1 13.1
C=
3304 1 329 0 0 29.7 27.7 13.2
3304 1 819 0 0 29.7 27.7 13.2
3304 2 76 0 0 29.7 27.7 13.2
3304 1 12 0 0 29.7 27.7 13.2
3304 2 971 1 1 26.3 24.3 14.1
3304 1 76 2 2 28.1 26.1 24.5
3304 2 230 2 2 28.1 26.1 24.5
3304 1 258 2 2 28.1 26.1 24.5
3304 1 27 3 3 27.1 25.1 13.1
3304 1 73 3 3 27.1 25.1 13.1
3304 2 179 3 3 27.1 25.1 13.1
3304 3 190 3 3 27.1 25.1 13.1
I have spent many hours on this what I imagine is a very simple task, so any help would be appreciated.

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

采纳的回答

Thorsten
Thorsten 2014-10-8
编辑：Thorsten 2014-10-8
C = [A B(A(:,4)+1, :)];
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2014-10-8
This answer assumes that the first column of B is always 0,1,2,3,4,etc. in that order, with no gap. A more generic solution, which works regardless of the ordering and values of B's first column:
[tf, ib] = ismember(A(:, 4), B(:, 1));
C = [A(tf, :) B(ib, :)];
The above also works if the common field is not found in B (it just does not include that row).

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by