Adding column headers to writetable csv file
显示 更早的评论
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')
采纳的回答
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 个评论
Note that table variables still have to comply with the character restrictions for MATLAB variable names. So if you want more flexibility in your exported table names, consider using writecell(). Although softwares like R handle names with hyphens and spaces and dots, best-practices include camelCase and underscores.
CMatlabWold
2021-9-11
I believe the "True" has to be lowercase.
writetable(T6, 'avg_num_per_bin.csv', 'WriteVariableNames', true)
Adam Danz
2021-9-13
Yep, thanks. Corrected.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 MATLAB Report Generator 的更多信息
Translated by 
