Join Multiple Tables horizontally (can have duplicate variables) in which some tables might be empty.
39 次查看(过去 30 天)
显示 更早的评论
Hello All,
I want to Join Multiple Tables horizontally (can have duplicate variables) in which some tables might be empty.
How to do that ?
TIA!!!
0 个评论
回答(1 个)
Benjamin Kraus
2023-2-22
编辑:Benjamin Kraus
2023-2-22
If your goal is to simply concatenate two tables, such that the first row of each table is combined into the first row of the output, the second row of each table is merged into the second row of the output, etc. all you need is to use the [] operator. That is, assuming they are the same height, or one of the tables is empty, and none of the tables have duplicate variable names. However, it is easy to fix duplicate variable names.
Consider this example:
t1 = table((1:10)')
t2 = table((11:20)')
t3 = table()
% Append a prefix to table variable names to avoid duplicate names.
t1.Properties.VariableNames = "t1." + t1.Properties.VariableNames
t2.Properties.VariableNames = "t2." + t2.Properties.VariableNames
% Now concatenate the three matrices:
t = [t1 t2 t3]
If your goal is more of a "join" operation, in which you use the value in one variable of each table as a key to match rows from multiple tables, you want to look into the different ways to Join Tables, including the innerjoin, outerjoin, and join commands.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!