Is it possible to decide which line is variable names in readtable?

Question

Saeid 2022-6-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1747670-is-it-possible-to-decide-which-line-is-variable-names-in-readtable

评论： Walter Roberson 2022-6-24

I want to use readtable to read data from an excel file. As I understand, in readtable, the first line is automatically the variable names. However, in my excel file, not just the first line, but the starting 3 lines contain characters and I want to know whether it is possible to use readtable to have an output where the vaiable names are the words that appear in the 3rd (or any desired) line.

A part of the excel file looks like this:

and I want the output to be like this:

ML125    MLCorr    ML100    Ds
--------------------------------
32.2    32.2        48.44   15.2
...

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2022-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1747670-is-it-possible-to-decide-which-line-is-variable-names-in-readtable#answer_992900

在 MATLAB Online 中打开

Yes, you can do that. For example,

variable_row = 3;
datatable = readtable(filename, 'VariableNamesRange', variable_row);

In some cases you want to specify a location to read the data from. You can use 'Range' in some cases, but if you have complicated headers then it might be better to use the 'DataRange' option.

Note: 'VariableNamesRange' and 'DataRange' may be specific to spreadsheets; the option names might be different for text files.

2 个评论
显示无隐藏无

Saeid 2022-6-24

在 MATLAB Online 中打开

Thanks Walter. When I try this, and although the said rows have different names, the output ends up looking like:

Var1 Var2 Var3

(or some strange number) and so on. I als tried setting 'VariableNamingRule' to 'preserve' but still turns out some strange variable name that is not what appears in the excel table