I have an hourly meteorological data screenshot attached which i need to convert to average daily data. Since I have a long period of data it is difficult to do it in excel. If anyone knows how to code it in matlab pls let me know

Question

Jeffrey Marak 2018-2-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383904-i-have-an-hourly-meteorological-data-screenshot-attached-which-i-need-to-convert-to-average-daily-da

评论： Jeffrey Marak 2018-2-27

采纳的回答： Andrei Bobrov

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2018-2-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383904-i-have-an-hourly-meteorological-data-screenshot-attached-which-i-need-to-convert-to-average-daily-da#answer_306258

编辑：Andrei Bobrov 2018-2-21

在 MATLAB Online 中打开

your_xls_file.xls

T = readtable('your_xls_file.xls');
t = datetime(strcat(T{:,2},'_',T{:,1}),'i','MM/dd/uuuu_HH:mm');
TT = table2timetable(T(:,3:end),'RowTimes',t);
E = regexp(TT{:,end},'\d+','match');
E = str2double(cat(1,E{:}));
tt = duration(E(:,1),E(:,2),0);
TT = [TT(:,1:end-1),table(tt,'v',TT.Properties.VariableNames(end))];
TTout = retime(TT,'daily','mean');
TTout = TTout(all(~isnan(TTout{:,:}),2),:);

or

T = readtable('your_xls_file.xls');
t = datetime(T{:,2});
A = regexp(T{:,end},'\d+','match');
A = str2double(cat(1,A{:}));
tt = duration(A(:,1),A(:,2),0);
TT = table2timetable([T(:,3:end-1),table(tt,'v',T.Properties.VariableNames(end))],'RowTimes',t);
TTout = varfun(@mean,TT,'GroupingVariables','Time');