Add a variable to table
5 次查看(过去 30 天)
显示 更早的评论
Hi,
I want to join 2 tables together.
In order to do that, table 1 must have the same number of columns as table 2.
table 1 has 8 variables
table 2 has 9 variables
So, I want to add a column to table 8
The variable will be of no use - it will just be a kind of dummy variable
How can I do this?
Thank you.
0 个评论
回答(1 个)
Turlough Hughes
2019-12-15
编辑:Turlough Hughes
2019-12-15
Hey Sarah,
Let's say you have two tables, as follows:
T1=table((1:10).',(10:-1:1).');
T2=table((11:20).',(20:-1:11).',(1:10).');
To add a dummy column you could write the following;
T1.dummy=NaN(size(T1,1),1);
To concatenate them, ensure firstly that the VariableNames are the same, which ought to be the case anyway except for T1.dummy:
T1.Properties.VariableNames=T2.Properties.VariableNames;
You can then concatenate the tables as follows:
T=[T1;T2];
Finally, with this approach I assume that the values in the last column of T2 are still important (otherwise you could just write a table without the last column of T1)
T=[T1;T2(:,1:end-1)];
EDIT: following comments below.
4 个评论
Turlough Hughes
2019-12-15
编辑:Turlough Hughes
2019-12-15
For example if you had:
T1=table((1:10).',(10:-1:1).');
T2=table((11:20).',(20:-1:11).',(1:10).');
You could concatenate them as follows:
T=[T1; T2(:,1:end-1)];
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!