read csv file with dates and numerical in R2016b

1 次查看（过去 30 天）
Simon Lind
Simon Lind 2021-4-30
评论： Simon Lind 2021-5-1
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

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2021-4-30
Use readtable.
  7 个评论
显示 5更早的评论
Cris LaPierre
Cris LaPierre 2021-5-1
编辑：Cris LaPierre 2021-5-1
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)

请先登录，再进行评论。

更多回答（1 个）

Jeremy Hughes
Jeremy Hughes 2021-4-30
Try this:
opts = detectImportOptions(filename)
T = readtable(filename,opts);
  2 个评论
Jeremy Hughes
Jeremy Hughes 2021-4-30
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?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by