Reading csv files starting from a different row
21 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hariharan MK
el 24 de Feb. de 2021
Comentada: Mohammad Sami
el 25 de Feb. de 2021
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
2 comentarios
KALYAN ACHARJYA
el 24 de Feb. de 2021
Editada: KALYAN ACHARJYA
el 24 de Feb. de 2021
Please attach the data file
See detectImportOptions
Respuesta aceptada
Mohammad Sami
el 24 de Feb. de 2021
Editada: Mohammad Sami
el 24 de Feb. de 2021
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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!