read csv file with dates and numerical in R2016b
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a csv data file like this:
2014-01-01 01:30:00,5.728,100.0,
2014-01-01 02:00:00,5.892,100.0,
2014-01-01 02:30:00,6.0120000000000005,100.0,
2014-01-01 03:00:00,5.982,100.0,
2014-01-01 03:30:00,6.122999999999999,98.277,
2014-01-01 04:00:00,6.02,98.09,
2014-01-01 04:30:00,5.763999999999999,97.54899999999999,
2014-01-01 05:00:00,5.406000000000001,96.83200000000001,
2014-01-01 05:30:00,5.162999999999999,96.961,
2014-01-01 06:00:00,5.109,97.315,
Is there any way to import both the dates and numerical values?
Thank you
0 commentaires
Réponse acceptée
Cris LaPierre
le 30 Avr 2021
7 commentaires
Cris LaPierre
le 1 Mai 2021
Modifié(e) : Cris LaPierre
le 1 Mai 2021
I get an odd character at the beginning of the first line that is messing up my attempts to read this file in. I was trying to use textscan to just see if I could read in the file.
fid = fopen('sample.csv');
out = textscan(fid,'%q')
fclose(fid)
Plus de réponses (1)
Jeremy Hughes
le 30 Avr 2021
Try this:
opts = detectImportOptions(filename)
T = readtable(filename,opts);
2 commentaires
Jeremy Hughes
le 30 Avr 2021
After looking more closely at this file that won't exactly work, it's problematic since each line starts with a double quote character. To "correctly" read CSV formats you have to take everything between the quotes, this will read each line into a separate row without considering the commas.
Where does the file come from? Is it produced by other software, or just a file you have?
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!