hourly and daily averages
1 次查看(过去 30 天)
显示 更早的评论
%avergae values per hour
[ah,~,ch] = unique(data(:,1:4),'rows');
out_hour = [ah,accumarray(ch,data(:,5),[],@nanmean)];
%avergae values per day
[ad,~,cd] = unique(data(:,1:3),'rows');
out_day = [ad,accumarray(cd,data(:,5),[],@nanmean)];
%avergae values per month
[am,~,cm] = unique(data(:,1:2),'rows');
out_month = [am,accumarray(cm,data(:,5),[],@nanmean)];
%avergae values per year
[ay,~,cy] = unique(data(:,1:2),'rows');
out_year = [ay,accumarray(cy,data(:,5),[],@nanmean)];
I tried to used the same code to calculate the daily and hourly averages of my long term data which is yyyy,MM,DD,HH,MM,SS formate in different csv files. I ran initially code and stored all the data in different coloumn vector and then made the table and trying to avobe code but seems to be not working. Could you guide me how to i would get rid from my problem. It would be really appreciated.
Thanks!
Dev
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!