varfun applied to table not recognising equal values

Question

Phoebe Armitage 2020-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/689934-varfun-applied-to-table-not-recognising-equal-values

评论： Phoebe Armitage 2020-12-10

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2020-12-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/689934-varfun-applied-to-table-not-recognising-equal-values#answer_571699

在 MATLAB Online 中打开

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')
dt1 = datetime
   10-Dec-2020 19:46:58
dt2 = dt1 + seconds(0.001)
dt2 = datetime
   10-Dec-2020 19:46:58
dt1 == dt2 % false
ans = logical
   0
dt2 - dt1
ans = duration
   00:00:00
seconds(dt2-dt1)
ans = 1.0000e-03