Counting bin and averaging using retime to include all of my data

5 views (last 30 days)
I have a question about the reptime function. I'm trying to count a redistributed data every 24 hr, from a data set that is taken every minute.
TT2 = retime(TT1, 'daily', 'count');
"retime" starts counting 24 hours from the first row. The question that I have is that my data set in TT1 does not have complete 24 hour data set at the end, so when I use 'count' the number of points in the last data bit is lower than in TT1.
How can I use retime on all the data set from TT1?
  2 Comments
Image Analyst
Image Analyst on 5 Sep 2017
How about you help people to help you by attaching TT1 in a .mat file?
Akira Agata
Akira Agata on 6 Sep 2017
retime starts counting 24 hours from 00:00:00 of the day in the 1st row, and the total count is equal to the number of row of the input timetable, as shown below. Please tell us more detail of the problem you are facing (attaching .mat file would be quite helpful!).
% Sample timetable
Time = datetime({'2015-12-18 07:02:12';'2015-12-18 08:00:47';...
'2015-12-18 09:01:37';'2015-12-18 10:03:10';...
'2015-12-19 02:59:34'});
Temp = [37.3;41.9;45.7;42.3;39.8];
Pressure = [30.1;29.9;30.03;29.9;29.8];
TT = timetable(Time,Temp,Pressure);
retime(TT,'daily','count')

Sign in to comment.

Answers (0)

Categories

Find more on Timetables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!