Creating table: how to define variable names

Question

turquoise_squid 2016-5-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282710-creating-table-how-to-define-variable-names

编辑： Deborah 2019-7-15

How can I define Variable names for each column after creating a table from a single variable with several columns?

For instance, when creating a table from one matrix x, MATLAB defines one name for the whole matrix irrespective of its column size. The only way to circumvene this problem is to subdefine each column of the matrix as a seperate variable. In my case I have go a matrix with 150 columns and it is very time consuming to do it this way:

table(x(:,1),x(:,2),..., x(:,150), 'VariableNames',{'Gender' 'Age' ... 'Sex'})

thank you for your assistance!

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-5-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282710-creating-table-how-to-define-variable-names#answer_220907

编辑：Guillaume 2016-5-5

在 MATLAB Online 中打开

The way to circumvent this problem is to use the proper function to create a table from a matrix which is array2table (see also cell2table and struct2table):

t = array2table(x)

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

请先登录，再进行评论。

Answer 2

Deborah 2019-7-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282710-creating-table-how-to-define-variable-names#answer_383184

编辑：Deborah 2019-7-15

See Adding column headers to writetable csv file . I think it may help.

I have however noticed that you may have to use the exact names of the column vectors you are passing to the 'table' function for that to work. For example:

Gender = x(:,1); Age = x(:,2);

T = table(Gender,Age,'VariableNames',{'Gender','Age'})

Note that you can only use array2table when the array entries are homogenous, but the above works for mixed entries (for example if Gender is a column vector of strings while Age is a numeric column vector).