Merging tables with partly the same column names, but sometimes different dimensions

Question

James Johnson 2022-12-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1882452-merging-tables-with-partly-the-same-column-names-but-sometimes-different-dimensions

编辑： Bora Eryilmaz 2022-12-21

Hi,

I have two tables with partly the same variable names. I want to merge these together and put them underneath each other, with all values of each variable under each other and empty cases for variables that are not present in the one table.

How can I do this?

Thank you!

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

请先登录，再进行评论。

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

Answer 1

Bora Eryilmaz 2022-12-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1882452-merging-tables-with-partly-the-same-column-names-but-sometimes-different-dimensions#answer_1133337

编辑：Bora Eryilmaz 2022-12-21

在 MATLAB Online 中打开

This seems like a table (outer) join problem. Take a look at: https://www.mathworks.com/help/matlab/ref/table.outerjoin.html

Tleft = table({'a' 'b' 'c'}', [1 2 3]', 'VariableNames', {'Key1' 'Var1'})
Tleft = 3×2 table
    Key1     Var1
    _____    ____

    {'a'}     1  
    {'b'}     2  
    {'c'}     3  
Tright = table({'a','b','d'}', [4 5 6]', 'VariableNames', {'Key1' 'Var2'})
Tright = 3×2 table
    Key1     Var2
    _____    ____

    {'a'}     4  
    {'b'}     5  
    {'d'}     6  
T = outerjoin(Tleft, Tright, 'MergeKeys', true)
T = 4×3 table
    Key1     Var1    Var2
    _____    ____    ____

    {'a'}      1       4 
    {'b'}      2       5 
    {'c'}      3     NaN 
    {'d'}    NaN       6 