Extra variable when opening a file using readtable.
显示 更早的评论
Has anyone experienced the problem of getting an extra column of data at the very end of the datasset when using readtable() to open a file? For instance, if the file has 20 columns of data, then the output will have a 21st column named Var21 which is always NaNs. I'm not sure if it's a problem with the files that I'm reading or something else.
采纳的回答
Even without seeing the files, with almost 100% certainty there's an extra delimiter at the end of the record which makes it look like an empty data field. If the record were
1,2,3,
4,5,6,
...
for instance, then to the input parser it is
value delim value delim value delim \n
so the sequence between the final delimiter and the newline (\n) is interpreted as missing data.
5 个评论
dpb
2017-12-3
Yea, thanks. You guess is correct.
[David's Answer moved to comment...dpb]
dpb
2017-12-3
Please accept the Answer if it did solve the problem (to indicate closed topic to others if nothing else)...
Peter Perkins
2017-12-19
In recent versions of MATLAB, you should be able to use importoptions to control how this phantom column is handled.
dpb
2017-12-20
Which function(s) are cognizant of importoptions, Peter?
Peter Perkins
2017-12-22
At the moment, I believe it's just readtable.
Also I should correct myself: the function is named detectImportOptions.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Distribution Plots 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
