convert to monthly mean (arrange data)

1 次查看（过去 30 天）

skyhunt 2014-9-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155737-convert-to-monthly-mean-arrange-data

评论： skyhunt 2014-9-27

I attached here 2 text files ..one is input file(complete data of year,month number,Day1 to day31) and second one is output file(year, month wise mean).I want this output format only.

6 个评论
显示 4更早的评论隐藏 4更早的评论

skyhunt 2014-9-24

编辑：skyhunt 2014-9-24

I am very new to this matlab. Still i am not getting my format..please anybody help for this script..save my life

Geoff Hayes 2014-9-24

What happened when you loaded the data from file using importdata? Please post some or all of the code that you have written to accomplish this task.

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2014-9-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155737-convert-to-monthly-mean-arrange-data#answer_152832

编辑：Andrei Bobrov 2014-9-25

在 MATLAB Online 中打开

f=fopen('input.txt');
c = textscan(f,repmat('%f ',1,33),...
                          'EmptyValue',nan,'HeaderLines',1,'CollectOutput',1);
fclose(f);
c1 = c{1};
val = nanmean(c1(:,3:end),2);
[yrs,~,ii] = unique(c1(:,1));
mmm = cellstr(datestr(datenum(2014,(1:12)',1),'mmm'))';
output = [[{'year'},mmm];
                    [num2cell(yrs), accumarray([ii, c1(:,2)],val,[],@(x){x})]];