How to vertically concatenate two tables with different sizes
35 次查看(过去 30 天)
显示 更早的评论
For example:
>> A = table(['A1';'A1';'A1'],[1;1;1],[1;1;1],...
'VariableNames',{'Var1' 'Var2' 'Var3'})
A =
Var1 Var2 Var3
____ ____ ____
A1 1 1
A1 1 1
A1 1 1
>> B = table(['B1';'B1'],[2;2],[2;2],...
'VariableNames',{'Var1' 'Var2' 'Var4'})
B =
Var1 Var2 Var4
____ ____ ____
B1 2 2
B1 2 2
How can I vertically concatenate A and B like the following? Thanks!
Var1 Var2 Var3 Var4
____ ____ ____ ____
A1 1 1 NAN
A1 1 1 NAN
A1 1 1 NAN
B1 2 NAN 2
B1 2 NAN 2
采纳的回答
Walter Roberson
2017-2-3
outerjoin(A,B,'MergeKeys', true)
It took me a few minutes to find the right command.
0 个评论
更多回答(1 个)
Sterling Baird
2020-9-5
编辑:Sterling Baird
2020-9-5
Also consider looking at FEX: tblvertcat which builds on outerjoin and supports 2+ tables and shared variable names
tblvertcat(A,B)
>>
Var1 Var2 Var3 Var4
____ ____ ____ ____
A1 1 1 NaN
A1 1 1 NaN
A1 1 1 NaN
B1 2 NaN 2
B1 2 NaN 2
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!