Effacer les filtres
Effacer les filtres

Adding column headers to writetable csv file

206 vues (au cours des 30 derniers jours)
Erika Joh
Erika Joh le 29 Avr 2019
Commenté : Adam Danz le 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')

Réponse acceptée

Adam Danz
Adam Danz le 29 Avr 2019
Modifié(e) : Adam Danz le 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 commentaires
CMatlabWold
CMatlabWold le 11 Sep 2021
I believe the "True" has to be lowercase.
writetable(T6, 'avg_num_per_bin.csv', 'WriteVariableNames', true)
Adam Danz
Adam Danz le 13 Sep 2021
Yep, thanks. Corrected.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by