Importing csv error - incorrectly finalised?
3 次查看(过去 30 天)
显示 更早的评论
Hi Guys,
R2018a
I have been struggling to import certain *.csv files using readtable(). The files contain a mixture of text and numbers and include some header data followed by a table of actual data.
I guess the files themselves have not been written / finalised correctly by the system that generates the CSVs.
- If I import the data from an original file, all the heading data is ignored. (see attached screenshot).
- If I open and save the csv file in excel first ( without changing any of the data or file type ), the data is imported correctly. n.b. the file size changes.
- When I open and view the files using notepad++ all the delimiters and end of line characters appear identical before and after saving.
I have tried various readtable options such as ('ReadVariableNames',false) and ('DatetimeType','text'). I have also tried detectImportOptions(filename, 'NumHeaderLines', 0), but this did not change the import behaviour.
Any help / insight would be appreciated.
Best regards, MC.
Edit: To be clear, I want to import the entire file. Text and Numbers.
Edit2: It looks like Excel pads the empty columns on save, allowing readtable() to work correctly.
0 个评论
回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!