Add a variable to table

3 次查看(过去 30 天)
Sarah Yun
Sarah Yun 2019-12-15
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.

回答(1 个)

Turlough Hughes
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
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)];
Turlough Hughes
Turlough Hughes 2019-12-15
Did this work for you?

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by