Mismatch between file and format string.

11 次查看（过去 30 天）
reza
reza 2019-1-21
评论： reza 2019-1-21
Hi there,
I am trying to read the fifth column of attached .CSV file(from row 1377 to 1192) with this simple code:
data = csvread('semga.csv');
CLOSE = data(1377:1192,5);
But I get this error:
Error using dlmread (line 147)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==>
DATE,OPEN,HIGH,LOW,CLOSE,PRICE,YCLOSE,VOL,TICKS\n
Error in csvread (line 48)
m=dlmread(filename, ',', r, c);
Error in sorting (line 8)
data = csvread('semga.csv');
What is the problem and how can I fix it?

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

采纳的回答

Stephan
Stephan 2019-1-21
编辑：Stephan 2019-1-21
Hi,
use readtable, then extract the data from the variable CLOSE (=column named CLOSE) in ascending order:
data = readtable('semga.csv');
CLOSE = data.CLOSE(1191:1376);
Note that your table has only 1376 entries, since the first row are variable names. So i changed
(1192:1377)
to
(1191:1376)
If needed use flip function, to get the order you want:
CLOSE = flip(CLOSE)
Best regards
Stephan
  3 个评论
显示 1更早的评论
Stephan
Stephan 2019-1-21
编辑：Stephan 2019-1-21
you could use the round function:
CLOSE = round(CLOSE)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by