how to select range of dates
3 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
per isakson
2018 年 4 月 11 日
編集済み: per isakson
2018 年 4 月 11 日
2 件のコメント
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!