Does not properly read csv file

20 visualizaciones (últimos 30 días)
alpedhuez
alpedhuez el 14 de Abr. de 2021
Respondida: Walter Roberson el 14 de Abr. de 2021
I try to read the attached csv file using readtable. But the data does not seem to be read. What can be done?

Respuesta aceptada

Walter Roberson
Walter Roberson el 14 de Abr. de 2021
readcell() instead of readtable(). Your file mixes data types.

Más respuestas (1)

Thomas Jensen
Thomas Jensen el 14 de Abr. de 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.
  1 comentario
alpedhuez
alpedhuez el 14 de Abr. de 2021
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

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import and Analysis en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by