How can I convert a table into separate columns?

Question

Bella 2020-6-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556201-how-can-i-convert-a-table-into-separate-columns

回答： Steven Lord 2020-6-28

I tried to use table2array to turn the table with separate columns. However, matlab did not allow me to do so. I need to turn them into columns as I want to use the retime function to do daily average calculation afterwards. But before using retime function, I will need to be able to produce a timetable with the variables in each column in it. Any suggestions?

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

请先登录，再进行评论。

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

Answer 1

Gaurav Aggarwal 2020-6-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556201-how-can-i-convert-a-table-into-separate-columns#answer_458338

在 MATLAB Online 中打开

Hi Oi,

table2array tries to create a homogeneous array from the table i.e. the table should have same data type throughout. However, as I see it, your table consists of multiple data type and thus the error. Read more here:https://www.mathworks.com/help/matlab/ref/table2array.html

You can try creating a cell array and then extract the columns

cell_name = table2cell(table_name); %% converts table structure to cell structure
ithcol = cell_name(:,i);            %% extracts ith column
var = cell2mat(ithcol);             %% converts cell array to matrix (assumes same data type throughout column)

Hope this helps. Thanks.