MATLAB Answers

How to convert hourly data to monthly average?

7 views (last 30 days)
Ali Saremi
Ali Saremi on 16 Aug 2017
Commented: Ali Saremi on 17 Aug 2017
Hi, I made a table which its first column shows date and time(every 3 hours) and its second column shows Wave Height collected on that day and time. I need to convert it to monthly data and take the average. I have attached a screen shot. If you could take a look and help me with that, I would really appreciate it.
Regards Ali

Accepted Answer

Sean de Wolski
Sean de Wolski on 16 Aug 2017
tt = table2timetable(wavetable);
retime(tt,'monthly','mean')
Time tables make this type of work super straightforward.
  1 Comment
Ali Saremi
Ali Saremi on 17 Aug 2017
IT worked. Thank you so much. I appreciate it. Regards Ali

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!