matlab structure to csv file

Question

Sanjay Zamindar 2022-2-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1651535-matlab-structure-to-csv-file

编辑： Jan 2022-2-17

采纳的回答： Jan

I have a struct like below

header: {1x6 cell}

dates: 202201

data: [0.9779 0.2625 -0.0108 0.1753 -0.0049 -0.0172]

AssetID: 'PAR'

where

K>> coef.header

ans =

Columns 1 through 5

'mexico' 'france' 'berlin' 'italy' 'china'

Column 6

'srilanka'

I want to take output of this in .csv file like

Any help or guidance will be really appricated

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

请先登录，再进行评论。

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

Answer 1

Jan 2022-2-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1651535-matlab-structure-to-csv-file#answer_897840

编辑：Jan 2022-2-17

在 MATLAB Online 中打开

% [EDITED] Adjusted for comma separators:
coef.header  = {'mexico', 'france', 'berlin', 'italy', 'china', 'srilanka'};
coef.dates   = 202201;
coef.data    = [0.9779 0.2625 -0.0108 0.1753 -0.0049 -0.0172];
coef.AssetID = 'PAR';
[fid, msg] = fopen('C:\Folder\YourFile.csv', 'w');
assert(fid > 0, msg);  % No file opening without checking the success!
fprintf(fid, '%s', 'dates');
fprintf(fid, ',%s', 'AssetID', coef.header{:});
fprintf(fid, '\n');
fprintf(fid, '%i,%s', coef.dates, coef.AssetID);
fprintf(fid, ',%g', coef.data);
fprintf(fid, '\n');
fclose(fid);

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

Walter Roberson 2022-2-17

Each place Jan had a \t change that to a comma.

Jan 2022-2-17

编辑：Jan 2022-2-17

@Sanjay Zamindar: I've modified the code. A problem with the commas is that they should not appear after the last element of each row.

With tabs as separators, a trailing tab is okay usually.

There are smarter methods to export an CSV file, e.g. writematrix and a lot of tools in the FileExchange. I wanted to suggest a simple "wooden" method, because it can be adjusted easily.

请先登录，再进行评论。