How can i name the column on a table ?

Question

Giorgia Fusaroli 2021-5-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/840400-how-can-i-name-the-column-on-a-table

评论： Stephen23 2021-5-26

HI everyone,

I have a matrix (82600x156 double) from a c3d file. I need to built a table and associate at each column a specific name. I already built a vector 'label' (1x156 cells). Using the command:

T = table (matrix, 'VariableNames', label)

the error is "The VariableNames property must contain one name for each variable in the table.".

I need this to save the table in .csv format.

If someone has suggestion about how my problem can be solved or another way to say labels and matrix on a cvs file it will be realy great !

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-5-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/840400-how-can-i-name-the-column-on-a-table#answer_709535

编辑：Stephen23 2021-5-26

在 MATLAB Online 中打开

You created a table with one variable and one row, and that variable contains a large numeric matrix. This is not useful for you. If you want a table where each column is converted into a table variable/column then use array2table:

T = array2table(matrix, 'VariableNames', label)

4 个评论
显示 2更早的评论隐藏 2更早的评论

Giorgia Fusaroli 2021-5-26

The input is a c3d matrix (82600x156 double). The output that i would is a csv (so a file where the elements of the row are devided by a ','). I need to label the column of the matrix and i already did a variable named "label" (1x156 cells). The format of the label is similar to "signal_rx_1:1".

The problem is that the alreayd build functions for csv have problems with mixed input (cells and double) and so first i need to build a table and then i need to save the table as a .csv file, but this is not the problem now because i have problem in the construction of the table.

with array2table MatLab gives me a message of error due to the invalid variable name (which, like i said is in format of a cell).

if you need another information to help me, just ask :)

Stephen23 2021-5-26

MATLAB R2019b and later will accept table variable names containing any characters.

If you are using an earlier version then the table variable names will need to be valid MATLAB variable names: https://www.mathworks.com/help/matlab/matlab_prog/variable-names.html

For example, this means you will need to remove the colon character.

请先登录，再进行评论。