GUI Import data: Column names not recognized for large files

2018 3 28
1 个回答
回答已采纳
更新时间：2018 4 2
14 次查看（30 天）

0 个投票

Version R2017b. When using the GUI: Home->Import data for csv files, I observe that the import data interface does not take over the column headers from the .csv file if the number of columns is large. I tested this with csv files containing 365 columns and 3285 columns. The large file contains copies of the data in the small files. For the first short file,the column names are recognized but not for the second file:
Is this intended or a known bug? I could not find a reference on MATLAB Answers.
Thank you!

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Jan
Jan 2018-3-28
Please post the CSV files also.
Jan
Jan 2018-3-28
All headers in the first line are "bla", "bla", "bla", ... Isn't this nonsense? What about using different names?
Timo
Timo 2018-3-28
编辑：Timo 2018-3-28
This is a test file which allows recreating the problem. My original files contain private data.

请先登录，再进行评论。

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

 采纳的回答

Prasanth Sunkara
Prasanth Sunkara 2018-4-2

0 个投票

This behavior is intentional. In order for the import tool to meet performance expectations, it only processes a certain amount of a delimited file to try to find header and variable name information, among other details, and this limit is 1000 columns. Beyond this, the import tool will experience many delays in performance.
Please consider using Datastore for larger data-sets.
-Prasanth

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

Timo
Timo 2018-4-2
Thank you for the very clear answer! Not knowing the reason for this behavior might confuse the user though (as it did for me). A pop-up note or similar to inform the user and point to alternatives would be helpful.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by