Does not properly read csv file
22 views (last 30 days)
Show older comments
alpedhuez
on 14 Apr 2021
Answered: Walter Roberson
on 14 Apr 2021
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
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!