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?

5 Comments

Can you include a small .csv file and your code to reproduce this behaviour ?
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!"
"Are there any potential issues with this setup given the file format and size?"
Much more likely cause: the file content.
Thomas
Thomas 19 minutes ago
Edited: Thomas 11 minutes ago
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?
"Does this additional information point to any specific cause for this issue?"
Probably the file content.
Once you provide an MWE we can investigate.

Sign in to comment.

Answers (0)

Products

Release

R2024a

Asked:

about 17 hours ago

Commented:

7 minutes ago

Community Treasure Hunt

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

Start Hunting!