varfun applied to table not recognising equal values
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Phoebe Armitage
il 10 Dic 2020
Commentato: Phoebe Armitage
il 10 Dic 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 Commenti
Risposta accettata
Steven Lord
il 10 Dic 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)
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!