convert cell 2 double with a table inside

7 次查看（过去 30 天）

显示更早的评论

Megha 2018-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/434843-convert-cell-2-double-with-a-table-inside

评论： Astha Singh 2018-12-14

I have a matrix A containing cell array 12x1 which has table inside with dimension 86400x24 in each cell.

I would like to convert this matrix A to double. Is there any way?

Please note I want to keep the cells and hence table concantenated in the output. I do not wish to convert each

cell individually. I want to convert matrix A

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

madhan ravi 2018-12-10

so upload your data as .mat file

Guillaume 2018-12-13

A cell array is not a matrix.

A table is not a matrix either.

Do you want to:

convert each table into matrices (assuming every variable of the table is numeric) and then concatenate the whole lot vertically?
or simply concatenate all the tables into a single table (assuming all the tables have the same variables)

请先登录，再进行评论。

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

回答（1 个）

Astha Singh 2018-12-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/434843-convert-cell-2-double-with-a-table-inside#answer_352158

在 MATLAB Online 中打开

Based on the information provided, I can suggest you to employ a for-loop to convert each table to an array, using the function 'table2array()', and keep concatenating it to your desired matrix. Look at the following code for example:

fin_mat = [];
for =1:length(c)
    fin_mat = [fin_mat ; table2array(c{i})];
end

Here, 'c' is the cell array of tables.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Stephen23 2018-12-13

@Astha Singh: expanding numeric arrays within loops is not efficient, and the MATLAB documentation recommends using more efficient ways to write code:

https://www.mathworks.com/help/matlab/matlab_prog/preallocating-arrays.html

This can be easily avoided in this case e.g. placing the data into a preallocated cell array and concatenating after the loop, or using cellfun as Guillaume showed.

Astha Singh 2018-12-14