How do I get a range of data from csv with unequal columns?
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I want to read in a section of this data.csv. Everything works fine with the xlsx version of the file.
A = xlsread(filename,1, 'I9..N30008');
The trouble is I would rather pull it in as a csv so that I don't have to save all my csv files as xlsx. I think the difficulty arises since there are not equal column numbers on every row.
0 Kommentare
Antworten (1)
Walter Roberson
am 22 Feb. 2019
T = readtable('data.csv', 'HeaderLines', 8, 'ReadVariableNames', false, 'Delimiter', ',');
If you need to convert the second column into dates, then
dates = datetime(T{:,2}, 'InputFormat', 'MM/dd/yyyy hh:mm:ss.SSS a');
and the pure numeric part (ignoring the first column that gives row numbers) would be
num = T{:,3:14};
The events are at T{:,15} and T{:,16}
0 Kommentare
Siehe auch
Kategorien
Mehr zu Shifting and Sorting Matrices 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!