readtable and table2array

28 次查看（过去 30 天）
Chet Sharma
Chet Sharma 2018-3-11
回答： 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
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
Chet Sharma 2018-3-11
Thanks David - thanks for explaining. I ended up doing what you suggested.

请先登录，再进行评论。

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

回答（1 个）

Peter Perkins
Peter Perkins 2018-3-15
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.

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by