Read CSV file with column headers and row headers.

50 次查看（过去 30 天）
Ajpaezm
Ajpaezm 2017-11-2
评论： Walter Roberson 2019-7-2
Hi,
I'd like to know how to read a CSV file that has column headers as well as row headers. Is there a function in Matlab that allows you to do this? Like keeping separately the row headers, the column headers and the data itself? It would be really useful to me, but I don't know if there's a way.
I tried csvread and obviously it didn't work because my csv is not entirely made of numeric data. And I don't know how to use the features in Textscan of column headers and row headers appropriately.
This is how the file looks like.
fid = fopen('FX Returns.csv', 'rt');
data = textscan(fid,'%s %f %f %f','headerlines', 1, 'delimiter', ',');
fclose(fid);
This reads everything except the column headers. The row headers get stored into a cell array, actually each column gets stored into a cell array if the data type specified is string, numerical array if it specified as floating point values.
But I want the data merged into a single matrix, if that's possible. For this case, I'd like to get a 8x3 matrix (for this example), with just the numeric data.
And separately, read only the column headers.
Thanks for reading and for helping out if you can.
  2 个评论
Rupali Wagh
Rupali Wagh 2019-7-2
i have same problem , the data i want to arrenged with headers, give me the solution
Walter Roberson
Walter Roberson 2019-7-2
? That file appears to be just 51 numeric columns. I do not see any headers.

请先登录，再进行评论。

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

采纳的回答

Ajpaezm
Ajpaezm 2017-11-3
Hey guys,
I just went for an even simpler solution, I used this function called csvimport, from here, I can get everything into a single array. After that, I get separetely the row and column headers, and the data separately.
Thanks for your feedback anyways, it was helpful :)

更多回答（2 个）

KSSV
KSSV 2017-11-2
Use xlsread. Read about it.
Walter Roberson
Walter Roberson 2017-11-2
If you have R2013b or later, you could use readtable(), ReadRowNames true (not default).
You can either let with ReadVariableNames default to true, in which case you should not add Headerlines option; or you can set ReadVariableNames to false (not default) and add 'HeaderLines', 1 . The difference is that in the first case it will mangle the dates in the header into something that is a valid variable name, such as x3x29x2017; in the second case it will use variables 'var1', 'var2', 'var3' (unless you tell it which variable names to use.)
... If you do not care what the headers are or what the row labels are, and truly want only the numeric entries, then it is possible to use readtable(), but you could instead just use xlsread() with a single output and it will automatically trim out the header and the row name (unless one of the row names accidentally comes out as numeric...)

类别

在 Help Center 和 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