Does not properly read csv file
13 views (last 30 days)
Show older comments
I try to read the attached csv file using readtable. But the data does not seem to be read. What can be done?
0 Comments
Accepted Answer
Walter Roberson
on 14 Apr 2021
readcell() instead of readtable(). Your file mixes data types.
0 Comments
More Answers (1)
Thomas Jensen
on 14 Apr 2021
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.
See Also
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!