header row causes issues in readtable

Question

Budding MATLAB Jockey 2020-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524787-header-row-causes-issues-in-readtable

回答： Walter Roberson 2020-5-13

采纳的回答： Walter Roberson

testfile.csv

Hello I am stumped

I have a pile of files like the attached. They are tab delimited even though they are .csv files.

If I remove the header I can use readtable just fine but I can't figure out how to import the data using readTable without manually deleating the header from each file...

The header and data has the same number of columns.

Otherwise I can't figure out a reasonable way to import them.

To be honest, I don't care about even having the right variable names but I can't work around it.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Budding MATLAB Jockey 2020-5-13

So with that as false it would end up piling everyhing into 1 huge cell for some reason.

My friend tried my same code and same files and it worked. He has a newer matlab so I'll just ignore this for now. If a versino change solves it then I'll just get someone else to run it when the time comes

thanks though!

Star Strider 2020-5-13

Consider: spreadsheetImportOptions

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-5-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524787-header-row-causes-issues-in-readtable#answer_432142

在 MATLAB Online 中打开

T = readtable('testfile.csv', 'ReadVariableNames', false, 'HeaderLines', 1);

Or, R2019b or later,

T = readtable('testfile.csv', 'PreserveVariableNames', true);

Note that the code guesses 'MM/dd/uuuu HH:mm' format instead of 'dd/MM/uuuu HH:mm' . If there were enough input in a column that it could figure it out then it would not have to guess. You can force a particular interpretation by using detectImportOptions and using setvaroptions() of 'InputFormat' and then passing the options to readtable()