Missing rows in cell array generated from CSV file

I am using a MATLAB script that uses the readcell function to read in data from multiple CSV files. Each file is relatively large (4.5 MB) and is read in with the 'ConsecutiveDelimitersRule' set to 'split'.
When I compare the MATLAB cell generated by readcell to the original CSV file, several rows in the CSV file are not present in the cell array. There does not appear to be a consistent pattern of which rows are skipped over during the import process.
Are there any potential issues with this setup given the file format and size?

6 comentarios

Can you include a small .csv file and your code to reproduce this behaviour ?
dpb
dpb hace alrededor de 2 horas
As @Torsten says, it will not be possible to diagnose this without a file that creates the issue. If you can't simply snip out a section around the apparently missing section of the original file and reproduce the symptoms, you would be able to post a compressed version of the file if run into size limits. Of course, the smaller you can make and still reproduce the problem, the better...
My crystal ball says will find some aberration in the file construction underlying it, but "ya' never knows!"
Stephen23
Stephen23 hace alrededor de 3 horas
Editada: Stephen23 hace 16 minutos
"Are there any potential issues with this setup given the file format and size?"
Much more likely cause: the file content.
Thomas
Thomas hace alrededor de 8 horas
Editada: Thomas hace alrededor de 8 horas
I have done some more investigation, and it additionally appears that various rows in the input CSV file have their order changed in the cell array generated by readcell (e.g., a row that appears before another row in the CSV file appears after it in the cell array).
As a test, I tried importing the CSV file through the Import tool, and this method doesn't yield any missing/re-ordered data (all rows are present and in the correct order). Should these two methods yield the same output with no non-default settings in readcell?
Does this additional information point to any specific cause for this issue?
Stephen23
Stephen23 hace alrededor de 7 horas
"Does this additional information point to any specific cause for this issue?"
Probably the file content.
Once you provide an MWE we can investigate.
dpb
dpb hace alrededor de 7 horas
Editada: dpb hace alrededor de 6 horas
Most likely causes are things like differing number of delimiters in one or more rows, embedded nonprinting characters, malformed or non-quoted strings and the like. It is, however, impossible to diagnose a precise issue here without an example file that exhibits the symptoms.

Iniciar sesión para comentar.

Respuestas (0)

Productos

Versión

R2024a

Etiquetas

Preguntada:

el 14 de Jul. de 2026 a las 20:37

Editada:

dpb
el 15 de Jul. de 2026 a las 14:15

Community Treasure Hunt

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

Start Hunting!

Translated by