Reading csv files starting from a different row

32 次查看（过去 30 天）
Hariharan MK
Hariharan MK 2021-2-24
评论： Mohammad Sami 2021-2-25
I have this csv file which I would like to import into Matlab. The "readtable" function allows me to import the csv into matlab easily into a table format. It automatically makes the first row the column names and assigns the cell A1 "Var1" since it is empty.
However, what I would like it to do is to read assign the column names according to the 3rd row since that contains the proper headers.
Is it always possible to locate the row containing " time(s) " and make that particular the header when using the readtable function?
Or is there an alternative method available that is accomplish the tasks mentioned above?
edit: attached the csv file

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

采纳的回答

Mohammad Sami
Mohammad Sami 2021-2-24
编辑：Mohammad Sami 2021-2-24
You can use the import options to change the behaviour of the readtable function.
a = delimitedTextImportOptions('VariableNamesLine',3,'DataLines',5);
% or
% a = detectImportOptions('myfile.csv','VariableNamesLine',3,'Range',5);
b = readtable('myfile.csv',a);
% use the following if excel file
% a = detectImportOptions('testfile.xlsx','VariableNamesRange','A3','DataRange','A5');
  6 个评论
显示 4更早的评论
Hariharan MK
Hariharan MK 2021-2-25
Hi
I managed to figure it out, since I always know that the headers appear 2 rows before the DataLines, I could change the
opts.VariableNamesLine = opts.DataLines(1)-2;
data = readtable("matlabqn_file1.csv",opts);
This method then allows me to select a particular row to become my header.
Thank you for your help!

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by