Problem adding headers to a matrix and saving it in txt file

Question

Alex castilla 2018-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/394415-problem-adding-headers-to-a-matrix-and-saving-it-in-txt-file

评论： Alex castilla 2018-4-13

Hello everyone,

I have a matrix called data (2618x17) I would like to add headers to each column and save it in a TXT file. I did the following code but it doesn't work. Can someone help me fix this problem? Thanks!

headers={'Timestamp','PosX','PosZ','PosY','RotX','RotY','RotZ','RPosX','RPosZ','RPosY','RRotX','RRotY','RRotZ','velocity','acceleration','curvature','target_reached'};

newdata=[headers; num2cell(data)]; dlmwrite('file_treated.txt',newdata);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2018-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/394415-problem-adding-headers-to-a-matrix-and-saving-it-in-txt-file#answer_314744

编辑：Stephen23 2018-4-12

dlmwrite only writes numeric data: its help states that it "writes numeric data in array M...". You do not have a numeric array, you have a mixed cell array.

If you want to write mixed char/numeric (e.g numeric data with a header) then you could use xlswrite, writetable, or do-it-yourself with fprintf.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Stephen23 2018-4-12

编辑：Stephen23 2018-4-12

在 MATLAB Online 中打开

temp4.csv

You could use fprintf:

headers={'Timestamp','PosX','PosZ','PosY','RotX','RotY','RotZ','RPosX','RPosZ','RPosY','RRotX','RRotY','RRotZ','velocity','acceleration','curvature','target_reached'};
data = rand(4,17); % four rows of fake data.
fmt = repmat(',%.12g',1,size(data,2)); % pick numeric format to suit!
fmt = [fmt(2:end),'\n'];
[fid,msg] = fopen('temp4.csv','wt');
assert(fid>=3,msg)
fprintf(fid,'%s',headers{1})
fprintf(fid,',%s',headers{2:end})
fprintf(fid,'\n')
fprintf(fid,fmt,data.')
fclose(fid);