Import .csv that has the characters '-'
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
I have an .csv file as you can see below and was wondering how to import it into matlab. 'csvread' wont work from what I've tried. Thanks for any help you might offer.
Date,Open,High,Low,Close,Volume
23-Mar-10,40.90,41.50,40.74,41.30,44335408
22-Mar-10,38.90,41.03,38.80,40.40,50007926
19-Mar-10,40.30,40.50,39.00,39.00,55803035
18-Mar-10,40.90,40.90,40.00,40.20,35021589
17-Mar-10,41.00,41.70,39.90,40.50,68063581
16-Mar-10,39.50,40.68,39.20,40.50,54320539
15-Mar-10,38.80,39.40,38.30,38.90,63595754
0 Commenti
Risposta accettata
per isakson
il 23 Mar 2014
Modificato: per isakson
il 23 Mar 2014
Not tested:
fid = fopen( 'filename.csv' );
cac = textscan( fid, '%s%f%f%f%f%f', 'delimiter', ',', 'headerlines', 1 )
fclose(fid);
and
sdn = datenum( cac{1}, 'dd-mmm-yy' );
.
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import and Export in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!