Monthly averages for each year using daily data in datenum form

Question

Dave 2014-12-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165301-monthly-averages-for-each-year-using-daily-data-in-datenum-form

评论： Guillaume 2014-12-4

Hi, I have matrix A (4000x2), the first column is daily data in datenum form. For example I have 734459, which using datestr brings 17-Nov-2010.

I did not see a post that answers this explicitly so I ask. How can I generate an array with monthly averages for each year of values of the second column? Thanks

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2014-12-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165301-monthly-averages-for-each-year-using-daily-data-in-datenum-form#answer_161159

编辑：Guillaume 2014-12-3

See for example the answers to this question (for which the author unfortunately deleted away the original question, but it's essentially the same as yours).

Basically, use unique, or histc to bin your dates by year and month and find the indice of the bin each row lands in. Use accumarray with these indices to get the mean of column 2.