GUI Import data: Column names not recognized for large files
6 views (last 30 days)
Show older comments
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.
Prasanth Sunkara on 2 Apr 2018
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.
More Answers (0)
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!