GRPSTATS and datetime columns
显示 更早的评论
Hi, I use grpstats to calculate statistics by different variables often. The new datetime format is very useful and I have converted many of my date handling procedures to utilize datetime arrays. However, when I have a table with a date field in the format of datetime it seems like grpstats can not properly use this field as a grouping statistic. I get the message below, indicating that a datetime field is not a plausible grouping variable format. Is there a way around this? Will this be fixed in the near future?
Error using grp2idx (line 117) A grouping variable must be a categorical, numeric, or logical vector, a cell vector of strings, or a 2D character array.
Thanks for your help, Brian
1 个评论
dpb
2015-3-19
I don't have the latest datetime type/class/whatever it actually is; can you cast it to a double a la a traditional date number for the purpose?
回答（1 个）
Sean de Wolski
2015-3-19
0 个投票
Use year, hour, day etc. of the datetime to extract the time component that you want to group by and then call grpstats.
3 个评论
Brian
2015-3-19
Sean de Wolski
2015-3-20
I don't know and wouldn't be able to discuss future enhancements anyway.
Peter Perkins
2015-3-22
Brian, that's certainly something we're looking into.
类别
在 帮助中心 和 File Exchange 中查找有关 Calendar 的更多信息
产品
2015-3-22
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
