How do i combine many tables by respective column content?

Question

ahmed obaid 2017-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333339-how-do-i-combine-many-tables-by-respective-column-content

编辑： Andrei Bobrov 2017-4-3

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

Dear Experiences ...

i have three tables ( table A, table B and table C)

table A look like following where first columns contain unique names, and second column contain public names (may contain repeated names)..

      name        sun_name
                 ____________
      Amy        'tomy'    
      Bob        'tomy'     
      Hol        'salmon'    
      Har        'cookies'   
      Sal        'pizza'

second column B look like following

   sun_name       var1(B).....varn(B)
  ____________   _______________
'tomy'         0.0 ....  4.5
'tomy'         4.5 .... 5.2
'salmon'       etc.. 
'cookies'   
'pizza'

table C look like following

   sun_name       var1(c).....varm(c)
  ____________   _______________
'tomy'         0.0 ....  4.5
'tomy'         4.5 .... 5.2
'salmon'       etc.. 
'cookies'   
'pizza'

result table (out) perhaps include all columns .. as follow: out

name sun_name var1(B)...varn(B) var1(C)...varm(C)

the problem here content of name field in table A must be repeated based on other tables ? how to do that please.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2017-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333339-how-do-i-combine-many-tables-by-respective-column-content#answer_261488

编辑：Andrei Bobrov 2017-4-3

在 MATLAB Online 中打开

Maybe so?

Table_out = [A,B(:,2:end),C(:,2:end)];

Added:

As said by Guillaume about innerjoin:

A = readtable('1.xls');
B = readtable('2.xls'); 
C = readtable('3.xls');
Tout = sortrows(innerjoin(A,innerjoin(B,C)),1);

2 个评论
显示无隐藏无

Image Analyst 2017-4-3

Try various join methods, like join and outerjoin.

ahmed obaid 2017-4-3

ok, i have treated join tables and reach to my goal .. thanks a lot

请先登录，再进行评论。

Answer 2

Guillaume 2017-4-3

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333339-how-do-i-combine-many-tables-by-respective-column-content#answer_261510

在 MATLAB Online 中打开

I don't see how your excel tables relate to your original question. There's no repeated key in any of them.

Going back to your original question, it looks like you want innerjoin. I'm not too clear on the relationship between B and C. Are you supposed to have 4 'tomy' after joining these two? Or do B and C have the same number of row and must simply be concatenated:

option 1: innerjoin

D = innerjoin(B, C);

option 2: plain concatenation (probably?)

D = [B, C(:, 2:end)];

The join with A is an innerjoin

A = table({'Amy'; 'Bob'; 'Hol'; 'Har'; 'Sal'}, {'tomy'; 'tomy'; 'salmon'; 'cookies'; 'pizza'}, 'VariableNames', {'name', 'sun_name'})
B = table({'tomy'; 'tomy'; 'salmon'; 'cookies'; 'pizza'}, [0; 4.5; 2; 3; 4], 'VariableNames', {'sun_name', 'var1b'})
C = table({'tomy', 'tomy', 'salmon', 'cookies', 'pizza'}', (10:10:50)', 'VariableNames', {'sun_name', 'var1c'})
D = innerjoin(A, [B, C(:, 2:end)])

results in:

7×4 table
    name     sun_name     var1b    var1c
    _____    _________    _____    _____
    'Har'    'cookies'      3      40   
    'Sal'    'pizza'        4      50   
    'Hol'    'salmon'       2      30   
    'Amy'    'tomy'         0      10   
    'Amy'    'tomy'       4.5      20   
    'Bob'    'tomy'         0      10   
    'Bob'    'tomy'       4.5      20