Monthly averages for each year using daily data in datenum form

2 次查看（过去 30 天）
Dave
Dave 2014-12-3
评论： 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

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

采纳的回答

Guillaume
Guillaume 2014-12-3
编辑：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.

更多回答（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!

Translated by