Importing csv error - incorrectly finalised?

2 次查看（过去 30 天）
MC
MC 2019-2-12
编辑： MC 2019-2-12
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.

请先登录，再回答此问题。

回答（1 个）

HD
HD 2019-2-12
Data = csvread('Original.csv',7,1);
  2 个评论
MC
MC 2019-2-12
Thanks, but this only imports the numbers. I need to import the entire contents of the file.
I have updated question for clarity.
HD
HD 2019-2-12
编辑：HD 2019-2-12
i would then suggest to use scantext since different rows have different nuber of columns

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by