how to select range of dates
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
rohail khan
il 11 Apr 2018
Commentato: Peter Perkins
il 13 Apr 2018
I have stock data of 10 years with two columns.One is the stocks which is numeric and the other is dates which are in datetime format.I converted datetime to Numeric also. I want to calculate mean for each year using mean(stock) formula. But I dont know how can I select the data for each year separately? The days are also not continuous as there are holiday gaps How can I get the range of data for one year e.g like from jan 1 ,2007 to dec 31 2007 and then get its mean
0 Commenti
Risposta accettata
per isakson
il 11 Apr 2018
Modificato: per isakson
il 11 Apr 2018
2 Commenti
Peter Perkins
il 13 Apr 2018
There are any number of ways to do this. accumarray is old school. full(sparse(...)) would have been even older school. More beginner-friendly ways include findgroups/splitapply, and varfun with a grouping variable. And in R2018a, groupsummary.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Dates and Time 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!