Does not properly read csv file

 Risposta accettata

Walter Roberson
Walter Roberson il 14 Apr 2021

0 voti

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

Più risposte (1)

Thomas Jensen
Thomas Jensen il 14 Apr 2021

0 voti

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 Commento

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

Accedi per commentare.

Prodotti

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by