MATLAB Answers

GRPSTATS and datetime columns

6 views (last 30 days)
Brian
Brian on 19 Mar 2015
Commented: Peter Perkins on 22 Mar 2015
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 Comment
dpb
dpb on 19 Mar 2015
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?

Sign in to comment.

Answers (1)

Sean de Wolski
Sean de Wolski on 19 Mar 2015
Use year, hour, day etc. of the datetime to extract the time component that you want to group by and then call grpstats.
  3 Comments
Peter Perkins
Peter Perkins on 22 Mar 2015
Brian, that's certainly something we're looking into.

Sign in to comment.

Tags

No tags entered yet.

Products

Community Treasure Hunt

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

Start Hunting!

Translated by