How can i sum over seconds ?

1 次查看（过去 30 天）
Sarah Gutermuth
Sarah Gutermuth 2018-10-16
评论： Sarah Gutermuth 2018-10-16
Hej, I would like to sum up my events over seconds. So I would like to know how many counts I have in one second.
if true
% code Noisedb0061 Noisedb0062 Noisedb0063 Noisedb0064 Noisedb0065 Noisedb0066 Var7
_________________________ ___________ ___________ ___________ ___________ ___________ __________
'2017-06-18 08:00:01.324' 51 114.21 0 0 4 7.3686e+05
'2017-06-18 08:00:04.129' 67 112.63 0 0 4 7.3686e+05
'2017-06-18 08:00:04.167' 105 116.26 0 0 4 7.3686e+05
'2017-06-18 08:00:04.209' 207 118.54 0 0 4 7.3686e+05
'2017-06-18 08:00:04.251' 195 114.22 0 0 4 7.3686e+05
'2017-06-18 08:00:04.668' 43 114.54 0 0 4 7.3686e+05
'2017-06-18 08:00:06.843' 57 113.4 0 0 4 7.3686e+05
'2017-06-18 08:00:06.869' 63 116.71 0 0 4 7.3686e+05
'2017-06-18 08:00:06.895' 51 113.97 0 0 4 7.3686e+05
'2017-06-18 08:00:07.894' 73 115.6 0 0 4 7.3686e+05
end
At the end I would just need two columns on with the time and one with the counts.
  3 个评论
显示 1更早的评论
Sarah Gutermuth
Sarah Gutermuth 2018-10-16
sure okay, I just made a subsample.
ANKUR KUMAR
ANKUR KUMAR 2018-10-16
Whats your expected output?
"how many counts I have in one second"- please elaborate your query.

请先登录，再进行评论。

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

回答（2 个）

jonas
jonas 2018-10-16
编辑：jonas 2018-10-16
t = datetime(testclick{:,1});
ts = dateshift(t, 'start', 'second')
N = histcounts(ts,'binmethod','second')
This will also give you the zero counts. And here is a table with your counts:
tc = ts(1):seconds(1):ts(end);
T = table(tc',N')
T =
Var1 Var2
____________________ ____
18-Jun-2017 08:00:01 1
18-Jun-2017 08:00:02 0
18-Jun-2017 08:00:03 0
18-Jun-2017 08:00:04 5
18-Jun-2017 08:00:05 0
Andrei Bobrov
Andrei Bobrov 2018-10-16
编辑：Andrei Bobrov 2018-10-16
T = testclick;
T.Noisedb0061 = datetime(T.Noisedb0061,'I','uuuu-MM-dd hh:mm:ss.SSS');
TT = table2timetable(T(:,2:end),'RowTime',T{:,1});
TTT = retime(TT,'secondly','sum');

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by