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

 採用された回答

Walter Roberson
Walter Roberson 2021 年 4 月 14 日

0 投票

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

その他の回答 (1 件)

Thomas Jensen
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.

1 件のコメント

alpedhuez
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

サインインしてコメントする。

製品

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by