MATLAB Answers

What is the best way to organize two header lines in a Table?

6 views (last 30 days)
Kazi Alam
Kazi Alam on 10 May 2021
Commented: Walter Roberson on 11 May 2021
Hallo, Thanks for Reading!
My dataset has two header lines. The dataset is read from a '*.xlxs' file where line 1 contains the Variable Group names and Line 2 contains Variable Names. I need both for my data classification and exploration. How can I read it with readtable function?
I have tried detectImportOptions with VariableUnitsLine and VariableDescriptionsLine. Everytime, MATLAB returned the following error.
Error:
Unrecognized property '*' for class
'matlab.io.spreadsheet.SpreadsheetImportOptions'.
If possible, could you give me an example on how to organize them ?
Example:
% Line 1: Climate Data
% Line 2: {'Temperature', 'Humidity'}
  12 Comments
Walter Roberson
Walter Roberson on 11 May 2021
I am not sure which version you are using; current versions specifically permit a vector of integers for the VariableNamesRange see https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html#bvetiw8-1_sep_bvetiw8-1-VariableNamesRange
But you could try
opts.VariableNamesRange = '2:2';

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 10 May 2021
If you must use readtable() then you are going to need two calls, one to read the first header line.
Alternately you could use readcell() and extract the first header line and construct a table from the remaining lines.

Community Treasure Hunt

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

Start Hunting!

Translated by