Convert data from minutes to hourly average

My data has time set up as dd-month-yyyy hh:mm:ss How do I average my data from minutes to hours

Answers (1)

If your data is in timetable / table format. You can use the groupsummary to summarise your data into any intervals.
a = groupsummary(TT,"Column_w_datetime","hour","mean");

2 Comments

Thanks. In the answer you posted, do I just put "hour", or does that need to be replaced with something?
Yes hour will provide hourly average. There are also other options if you want to change the interval.

Sign in to comment.

Categories

Asked:

on 8 Oct 2020

Commented:

on 8 Oct 2020

Community Treasure Hunt

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

Start Hunting!