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

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!"
Stephen23
Stephen23 대략 3시간 전
편집: Stephen23 12분 전
"Are there any potential issues with this setup given the file format and size?"
Much more likely cause: the file content.
Thomas
Thomas 대략 11시간 전
편집: Thomas 대략 11시간 전
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.
dpb
dpb 대략 10시간 전
편집: dpb 대략 10시간 전
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.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

제품

릴리스

R2024a

태그

질문:

2026년 7월 14일 20:37

편집:

dpb
대략 10시간 전

Community Treasure Hunt

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

Start Hunting!

Translated by