Adding column headers to writetable csv file

169 Ansichten (letzte 30 Tage)
Erika Joh
Erika Joh am 29 Apr. 2019
Kommentiert: Adam Danz am 13 Sep. 2021
I'm trying to figure out how to add column headers to my csv files using writetable.
I started with creating a table of variables (transposed into columns) and then used writetable to export it as a csv. Right now the headersin the output file are Var1 and Var2. How can I change this?
T6 = table(average_in_bin.',num_per_bin.');
writetable(T6,'avg_num_per_bin.csv')

Akzeptierte Antwort

Adam Danz
Adam Danz am 29 Apr. 2019
Bearbeitet: Adam Danz am 13 Sep. 2021
The default value for the WriteVariableNames parameter in writetable() is true so all you need is to add variable names to your 'T6' table. Below I named them "NameOne" and "NameTwo".
T6 = table(average_in_bin.',num_per_bin.', 'VariableNames', {'NameOne', 'NameTwo'});
writetable(T6, 'avg_num_per_bin.csv', 'WriteVariableNames', true)
  3 Kommentare
CMatlabWold
CMatlabWold am 11 Sep. 2021
I believe the "True" has to be lowercase.
writetable(T6, 'avg_num_per_bin.csv', 'WriteVariableNames', true)
Adam Danz
Adam Danz am 13 Sep. 2021
Yep, thanks. Corrected.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Large Files and Big Data finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by