GRPSTATS and datetime columns

2 次查看(过去 30 天)
Brian
Brian 2015-3-19
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
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
Sean de Wolski 2015-3-19
Use year, hour, day etc. of the datetime to extract the time component that you want to group by and then call grpstats.
  3 个评论
Sean de Wolski
Sean de Wolski 2015-3-20
I don't know and wouldn't be able to discuss future enhancements anyway.
Peter Perkins
Peter Perkins 2015-3-22
Brian, that's certainly something we're looking into.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Calendar 的更多信息

标签

尚未输入任何标签。

产品

Community Treasure Hunt

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

Start Hunting!

Translated by