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
Torsten
32분 전
Can you include a small .csv file and your code to reproduce this behaviour ?
dpb
23분 전
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!"
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개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!