Clear Filters
Clear Filters

readtable and table2array

20 views (last 30 days)
Chet Sharma
Chet Sharma on 11 Mar 2018
Answered: Peter Perkins on 15 Mar 2018
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 Comments
David Fletcher
David Fletcher on 11 Mar 2018
Edited: David Fletcher on 11 Mar 2018
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 on 11 Mar 2018
Thanks David - thanks for explaining. I ended up doing what you suggested.

Sign in to comment.

Answers (1)

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

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!