MATLAB Answers

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

24 views (last 30 days)
Carlos Alonso
Carlos Alonso on 26 May 2020
Commented: Carlos Alonso on 26 May 2020
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

Answers (1)

Ruger28
Ruger28 on 26 May 2020
Edited: Ruger28 on 26 May 2020
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 Comments
Carlos Alonso
Carlos Alonso on 26 May 2020
Hi , the header will change dynamically, as I will be adding and removing columns. Thanks

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by