Joining 2 tables with outer join both having extra elements

1 次查看（过去 30 天）

显示更早的评论

Mehul Agrawal 2016-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/292508-joining-2-tables-with-outer-join-both-having-extra-elements

关闭： MATLAB Answer Bot 2021-8-20

在 MATLAB Online 中打开

I have 2 tables having names and scores of individuals. I want to find the total marks scored by people in the tests. If they took one test, it is that, else it is sum of two (or more) tests. Eg: Data is like:

A.Name = {'S';'P';'R';'M';'K'};
A.Score = [80;82;85;95;55];
>> A = struct2table(A);
B.Name = {'Mi';'J';'K'};
B.Score = [80;82;25];
B = struct2table(B);

I am trying to create a table by joining:

X = join(A, B,  'MergeKeys', true, 'Keys','Name');
X.Score_A(isNan(X.Score_A)) = 0;
X.Score_B(isNan(X.Score_B)) = 0;
X.Score = X.Score_A+X.Score_B;

Is there a more efficient way to do this ?

Sorry, I didn't mention one more step. I had to first do a union to create A, B with all elements. Else, just join fails.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ruchir Kemnaik 2016-7-6

在 MATLAB Online 中打开

Hi Mehul,

Did the above code work for you? It will give an error since "MergeKeys" is not a valid parameter for "join" function. I used "outerjoin" function and it gave the expected result. The code I used is as follows:

X = outerjoin(A,B, 'MergeKeys', true, 'Keys','Name');
X.Score_A(isnan(X.Score_A)) = 0;
X.Score_B(isnan(X.Score_B)) = 0;
X.Score = X.Score_A+X.Score_B;