Does not properly read csv file

Question

0 个投票

I try to read the attached csv file using readtable. But the data does not seem to be read. What can be done?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Walter Roberson 2021-4-14

0 个投票

readcell() instead of readtable(). Your file mixes data types.

Answer 2

Thomas Jensen 2021-4-14

0 个投票

Hi,

Try to use readtable('test.csv','Format','%s,%s'). It will force the data to be treated as text.

Since you columns are mixing number and date values, it is better to keep it as char and post-process it later.

alpedhuez 2021-4-14

Error using readtable (line 245)

Unable to read the entire file. You may need to specify a different format, delimiter, or number of header lines.

Note: readtable detected the following parameters:

'Delimiter', ',', 'HeaderLines', 0, 'ReadVariableNames', true