how to calculating monthly average?
3 次查看(过去 30 天)
显示 更早的评论
hi all I just want to be sure about this small monthly averaging code
I=1;
for i=1: length(x)/30;
y(i)=mean(x(I:I+29));
L(i)=min(x(I:I+29));
U(i)=max(x(I:I+29));
I=I+29;
end
where x is data matrix (365 day)
thank you
4 个评论
Star Strider
2016-5-8
Well, some of the data, but not what we need to do what you want with it.
Without knowing the times (at least months-days-years, in some format) at which these are collected, it’s not possible to separate them by month.
采纳的回答
Image Analyst
2016-5-8
Try this:
dailyValues = rand(1,365); % Sample data
daysInMonths = [31,28,31,30,31,30,31,31,30,31,30,31]
monthEnds = [0, cumsum(daysInMonths)]
for m = 1 : length(monthEnds)-1
firstDay = monthEnds(m)+1;
lastDay = monthEnds(m+1);
fprintf('For month #%d, the first day = %d and the last day = %d\n',...
m, firstDay, lastDay);
monthlyAverage(m) = mean(dailyValues(firstDay:lastDay));
end
% Echo to command window.
monthlyAverage
Of course you need to take leap years into account, which I didn't do.
7 个评论
Image Analyst
2016-5-13
JanuaryDailyAmounts = dailyValues(1:31);
FebruaryDailyAmounts = dailyValues(32:59);
MarchDailyAmounts = dailyValues(60:90);
and so on for months ending at rows 120 151 181 212 243 273 304 334 365.
You will then have 12 matrices.
更多回答(1 个)
Steven Lord
2016-5-12
Find the month number (either directly from the file or using some of the tools associated with datetime objects then use the month numbers as the subscripts in a call to accumarray, specifying @mean as the accumulation function.
numRows = 30;
X = [randi(12, numRows, 1), randi(100, numRows, 1)] % Column 1 is month, column 2 is data
Y = accumarray(X(:, 1), X(:, 2), [], @mean)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!