varfun applied to table not recognising equal values
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Phoebe Armitage
el 10 de Dic. de 2020
Comentada: Phoebe Armitage
el 10 de Dic. de 2020
I have 3 tables with two columns of time (intervals of 10minutes) and speed. The time column is in datetime format. I have stacked the three tables on top of each other and assigned valiables a and b to the new time and speed columns, respecivetly.
Then I used:
x=varfun(@mean,TT,'GroupingVariable','Date & Time')
However the function doesn't seem to recognise Dates & Times that are equal so in x, for example, there are say two 31May2010 15:10 rows.
Oddly, After this date/time the same thing happend for every xx:10 and xx:40 time.
How do I fix this?
0 comentarios
Respuesta aceptada
Steven Lord
el 10 de Dic. de 2020
Are you sure the values are equal? They could be displayed as the same value without the stored value being the same.
dt1 = datetime('now')
dt2 = dt1 + seconds(0.001)
dt1 == dt2 % false
dt2 - dt1
seconds(dt2-dt1)
Más respuestas (0)
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!