GRPSTATS and datetime columns
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
dpb
el 19 de Mzo. de 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?
Respuestas (1)
Sean de Wolski
el 19 de Mzo. de 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 comentarios
Sean de Wolski
el 20 de Mzo. de 2015
I don't know and wouldn't be able to discuss future enhancements anyway.
Ver también
Categorías
Más información sobre Data Type Identification en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!