Borrar filtros
Borrar filtros

Adding column headers to writetable csv file

206 visualizaciones (últimos 30 días)
Erika Joh
Erika Joh el 29 de Abr. de 2019
Comentada: Adam Danz el 13 de Sept. de 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')

Respuesta aceptada

Adam Danz
Adam Danz el 29 de Abr. de 2019
Editada: Adam Danz el 13 de Sept. de 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 comentarios
CMatlabWold
CMatlabWold el 11 de Sept. de 2021
I believe the "True" has to be lowercase.
writetable(T6, 'avg_num_per_bin.csv', 'WriteVariableNames', true)
Adam Danz
Adam Danz el 13 de Sept. de 2021
Yep, thanks. Corrected.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by