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

Question

Carlos Alonso 2020-5-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/534243-how-to-read-a-table-from-a-csv-file-with-multiple-header

评论： Carlos Alonso 2020-5-26

在 MATLAB Online 中打开

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 

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ruger28 2020-5-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/534243-how-to-read-a-table-from-a-csv-file-with-multiple-header#answer_439293

编辑：Ruger28 2020-5-26

在 MATLAB Online 中打开

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);