Calculate mean value between 2 years

Question

Anh Duong 2022-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1683869-calculate-mean-value-between-2-years

评论： Anh Duong 2022-3-31

I have a set of data from Jan 2000 to 2011, and I want to calculate mean value of data from Nov of one year to Apr of the next year. How can I do it?

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

请先登录，再进行评论。

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

Answer 1

Simon Chan 2022-3-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1683869-calculate-mean-value-between-2-years#answer_930209

编辑：Simon Chan 2022-3-30

在 MATLAB Online 中打开

Not sure what is the format of your data. Use function isbetween and below shows an example that you can implement it into your code.

TimeStamps = datetime([2000 11 4; 2001 3 2; 2001 8 15; 2001 10 10;...
                       2001 12 14; 2002 1 31; 2002 3 25;...
                       2002 4 29; 2002 12 21; 2003 3 18]);
Profit = [2032 3071 1185 2587 1998 2899 3112 909 2619 3085]';
TT = timetable(TimeStamps,Profit);
tlower = datetime(2000,11,1)+calyears(0:11);
thigher = datetime(2001,4,30)+calyears(0:11);
meanProfit = arrayfun(@(x,y) mean(TT.Profit(isbetween(TT.TimeStamps,x,y))),tlower,thigher)
meanProfit = 1×12
1.0e+03 *

    2.5515    2.2295    2.8520       NaN       NaN       NaN       NaN       NaN       NaN       NaN       NaN       NaN

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

Simon Chan 2022-3-31

在 MATLAB Online 中打开

Do you want the following output?

Or do you want to use function timerange?

TimeStamps = datetime([2000 11 4; 2001 3 2; 2001 8 15; 2001 10 10;...
                       2001 12 14; 2002 1 31; 2002 3 25;...
                       2002 4 29; 2002 12 21; 2003 3 18]);
Profit = [2032 3071 1185 2587 1998 2899 3112 909 2619 3085]';
TT = timetable(TimeStamps,Profit);
tlower = datetime(2000,11,1)+calyears(0:11);
thigher = datetime(2001,4,30)+calyears(0:11);
meanProfit = arrayfun(@(x,y) mean(TT.Profit(isbetween(TT.TimeStamps,x,y))),tlower,thigher);
table(tlower',thigher',meanProfit','VariableName',{'Period Start','Period End','Mean'})
ans = 12×3 table
    Period Start    Period End      Mean 
    ____________    ___________    ______

    01-Nov-2000     30-Apr-2001    2551.5
    01-Nov-2001     30-Apr-2002    2229.5
    01-Nov-2002     30-Apr-2003      2852
    01-Nov-2003     30-Apr-2004       NaN
    01-Nov-2004     30-Apr-2005       NaN
    01-Nov-2005     30-Apr-2006       NaN
    01-Nov-2006     30-Apr-2007       NaN
    01-Nov-2007     30-Apr-2008       NaN
    01-Nov-2008     30-Apr-2009       NaN
    01-Nov-2009     30-Apr-2010       NaN
    01-Nov-2010     30-Apr-2011       NaN
    01-Nov-2011     30-Apr-2012       NaN