read csv file with dates and numerical in R2016b

1 view (last 30 days)
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

Accepted Answer

Cris LaPierre
Cris LaPierre on 30 Apr 2021
  7 Comments
Cris LaPierre
Cris LaPierre on 1 May 2021
Edited: Cris LaPierre on 1 May 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)

Sign in to comment.

More Answers (1)

Jeremy Hughes
Jeremy Hughes on 30 Apr 2021
Try this:
opts = detectImportOptions(filename)
T = readtable(filename,opts);
  2 Comments
Jeremy Hughes
Jeremy Hughes on 30 Apr 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?

Sign in to comment.

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Products


Release

R2016b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!