how to select range of dates

3 次查看（过去 30 天）
rohail khan
rohail khan 2018-4-11
评论： Peter Perkins 2018-4-13
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

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

采纳的回答

per isakson
per isakson 2018-4-11
编辑：per isakson 2018-4-11
Hint:
accumarray( t.Year-2007+1, stock, [], @mean )
where t is a datetime object
  2 个评论
rohail khan
rohail khan 2018-4-12
thank you so much.You are amazing
Peter Perkins
Peter Perkins 2018-4-13
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by