GRPSTATS and datetime columns
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
dpb
am 19 Mär. 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?
Antworten (1)
Sean de Wolski
am 19 Mär. 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 Kommentare
Sean de Wolski
am 20 Mär. 2015
I don't know and wouldn't be able to discuss future enhancements anyway.
Siehe auch
Kategorien
Mehr zu Data Type Identification finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!