Monthly averages for each year using daily data in datenum form
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Guillaume
il 3 Dic 2014
Modificato: Guillaume
il 3 Dic 2014
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.
2 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Calendar in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!