I want to merge the content of two tables with identical variables, but for a given key variable value the columns 1:N in table 1 are filled and columns N+1:end in the other.

2 次查看（过去 30 天）
Ronald Ouwerkerk
Ronald Ouwerkerk 2017-9-18
编辑： Ramnarayan Krishnamurthy 2017-9-21
This is what I would like to achieve: A = table({'a'}, 5, 15, 25, 0, 0, 0,'VariableNames',{'A1','A2', 'A3', 'A4', 'B1', 'B2', 'B3'}) A = A1 A2 A3 A4 B1 B2 B3 _
'a' 5 15 25 0 0 0
>> B = table({'a'}, 0, 0, 0, 6, 12, 18,'VariableNames',{'A1','A2', 'A3', 'A4', 'B1', 'B2', 'B3'}) B = A1 A2 A3 A4 B1 B2 B3 _
'a' 0 0 0 6 12 18
>> What operation would yield table C (matching the values of variable 'A1'): C = table({'a'}, 5, 15, 25, 6, 12, 18,'VariableNames',{'A1','A2', 'A3', 'A4', 'B1', 'B2', 'B3'}) C =
A1 A2 A3 A4 B1 B2 B3
___ __ __ __ __ __ __
'a' 5 15 25 6 12 18

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

回答（1 个）

Ramnarayan Krishnamurthy
编辑：Ramnarayan Krishnamurthy 2017-9-21
Merging 2 tables on the basis of key variables and retaining only the common rows can be achieved using the 'innerjoin' function.
For the requirements in this question, we would need to manipulate the input data A and B, so that only the desired columns from both the tables are selected
t = innerjoin(A(:,[1:4]),B(:,[1,5:end]),'LeftKeys',1,'RightKeys',1);
t =
A1 A2 A3 A4 B1 B2 B3
___ __ __ __ __ __ __
'a' 5 15 25 6 12 18
Additionally, to generalize the above code where N is the number of filled columns in Table 1:
N = 4;
t = innerjoin(A(:,[1:N]),B(:,[1,N+1:end]),'LeftKeys',1,'RightKeys',1);
The documentation for the 'innerjoin' function is available at: https://www.mathworks.com/help/matlab/ref/innerjoin.html
Hope this helps!

类别

在 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