Why is importdata bringing in cell array?

19 次查看（过去 30 天）
K
K 2018-11-16
评论： dpb 2018-11-17
I have two different .csv files that I would like to import and create structure arrays.
I'm using this:
A = importdata(filepath, filename);
The first one works and the heading looks like this:
1.JPG
The second one comes in as cell array so I cannot grab A.data:
2.JPG
What is the difference that I'm not seeing?
  3 个评论
显示 1更早的评论
K
K 2018-11-16
Thanks for the response!
By "works" I mean just having the ability to grab an array of all data points in the data file. The second file comes in as a cell array that is made up of only one column
3.JPG
I'm just trying to get a program that grabs that data no matter how many header lines there are. I definitely might be able to get it using readtable but it will be inefficient if I use this in the code.
dpb
dpb 2018-11-17
What data, specifically are you wanting and how do you expect MATLAB to know where those data are or how they're organized for any totally arbitrary file excepting by some sort of preprocessing procedure?
detectImportOptions is the TMW-supplied routine to make a stab at that; anything else you do will be some variant of the techniques used therein.

请先登录，再进行评论。

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

采纳的回答

Mark Sherstan
Mark Sherstan 2018-11-16
You might have better luck going through the file line by line. For example:
f = fopen('test.csv');
lineCount = 1;
tline = fgetl(f);
while ischar(tline)
data{lineCount} = tline;
tline = fgetl(f);
lineCount = lineCount + 1;
end
fclose(f);
This will give you the header information as well but you can cut that out with a string compare assuming you know the header names or when the data becomes a number instead of a string. Just depends on how different all the .csv's might be.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by