How to skip lines after the header line when using readtable
214 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fyodor Tatarinov
am 3 Jun. 2021
Bearbeitet: Stephen23
am 3 Jun. 2021
I have csv files where 1st row is always names of variables 2nd row is units (needs to be skiped) and further rows are data to read. Number of columns and column names may differ in different files. I want to read each file with the column names and keep the data in table format. In the description of readtable function I found only the option to skip first n lines, then to read header from (n+1)th line and the data since next line, but I did not find the option to start to read data 2 lines after header.
So, I did such a trick with reading first header line by fgetl, then reading data by readtable since line 3 and then replacing variable names by previously red titles:
fid = fopen(strcat(pathname,eddyDir.name{f}));
tmp = fgetl(fid); % reading 1st header line
xini = readtable(strcat(pathname,eddyDir.name{f}),'HeaderLines',2); % input data for current year
fclose(fid);
j = 0; % parsing header line
while true
j = j+1;
[titles{j}, tmp] = strtok(tmp, ',');
if isempty(titles{j}), break; end
end
xini.Properties.VariableNames = titles;
Maybe there is more fine way to do it?
Thanks
0 Kommentare
Akzeptierte Antwort
Stephen23
am 3 Jun. 2021
Bearbeitet: Stephen23
am 3 Jun. 2021
type test.csv
opts = detectImportOptions('test.csv');
opts.DataLines = 3;
opts.VariableNamesLine = 1;
T = readtable('test.csv',opts)
2 Kommentare
Scott MacKenzie
am 3 Jun. 2021
@Stephen Cobeldick Thanks. This is clearly the correct solution. I deleted my miscued attempt. @Fyodor Tatarinov here's your answer. :) Good luck.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!