readtable and table2array

Question

Chet Sharma 2018-3-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/387551-readtable-and-table2array

回答： Peter Perkins 2018-3-15

Hi I have a large data set (hourly electricity load data for 1 year, so 8760 observations). This is an excel file, so I used the readtable function to get the data. Everything works fine so far. Next, I wanted to convert the table to an array using table2array. It works fine, except that all the header names are gone. Why is this happening?

Here's my code:

inPutsT = readtable(inFile,'Sheet','load','Range','A1:D8785','ReadVariableNames',true);
inPutsA = table2array(inPutsT);

Is there a way to do this and keep the headers? Thanks

2 个评论
显示无隐藏无

David Fletcher 2018-3-11

编辑：David Fletcher 2018-3-11

Matrices don't have labelled columns, but you can extract the column names from the table properties and store them in a separate cell array

Chet Sharma 2018-3-11

Thanks David - thanks for explaining. I ended up doing what you suggested.

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2018-3-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/387551-readtable-and-table2array#answer_310097

Depending on what you are doing after you read in the spreadsheet, you may not need to convert to one numeric array. You might, but you can do a lot with the data in a table, and as you have discovered, tables have variable names and double matrices do not.