Read .CSV file and remove lines
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Jake Marvin
am 6 Okt. 2018
Beantwortet: Star Strider
am 6 Okt. 2018
I need to read in a .csv file that has 3 header lines and each line of data also ends in 'Speed 1' which is unwanted. I would like the data in just a double array with 4 columns.
1 Kommentar
madhan ravi
am 6 Okt. 2018
In the csv file which you uploaded I see 5 different types of datas with different headers?
Akzeptierte Antwort
Star Strider
am 6 Okt. 2018
This may be the least aesthetically appealing code I ever wrote. Its only redeeming factor is that ‘Result’ is the matrix you want:
[D,S,R] = xlsread('20lbin.csv');
S2 = S(4:end,:);
S3 = strsplit([S2{:}],'Speed 1')';
S4 = sscanf([S3{:}],'%f,');
Result = reshape(S4, 4, [])';
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Large Files and Big Data 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!