Read .CSV file and remove lines
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jake Marvin
le 6 Oct 2018
Réponse apportée : Star Strider
le 6 Oct 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 commentaire
madhan ravi
le 6 Oct 2018
In the csv file which you uploaded I see 5 different types of datas with different headers?
Réponse acceptée
Star Strider
le 6 Oct 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Large Files and Big Data dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!