how to read a table from a CSV file with multiple header

13 次查看（过去 30 天）
Carlos Alonso
Carlos Alonso 2020-5-26
评论： Carlos Alonso 2020-5-26
Hello
I want to read a table from a CSV file that has 2 row header.
Time Speed Temp
s kph degC
1 12 24
2 13 25
3 14 26
How I can read the above table and display it showing the 2 row header.?
I have tried to do on different ways but only 1 row header is shown (see below)
3×3 table
Time Speed Temp
____ _____ ____
1 12 24
2 13 25
3 14 26
However I would like to see table as below
3×3 table
Time Speed Temp
s kph degC
1 12 24
2 13 25
3 14 26

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

回答（1 个）

Ruger28
Ruger28 2020-5-26
编辑：Ruger28 2020-5-26
fname = 'MyCSV.csv';
headerlines = 2;
CSV_Data = dlmread(fname,',',headerlines,0); % filename, delimiter, row offset, column offset
% create table with pre-defined headers
TableHeaders = {'Time_s','Speed_kph','Temp_C'};
MyTable = table(CSV_Data(:,1),CSV_Data(:,1),CSV_Data(:,1),'VariableNames',TableHeaders);
  3 个评论
显示 1更早的评论
Ruger28
Ruger28 2020-5-26
Yes, sorry about that. I guess I read too fast.
Will you always know the headers, or are they dynamic?
Carlos Alonso
Carlos Alonso 2020-5-26
Hi , the header will change dynamically, as I will be adding and removing columns. Thanks

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Statistics and Machine Learning Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by