Convert data from minutes to hourly average

2 ビュー (過去 30 日間)
Marina Minic
Marina Minic 2020 年 10 月 8 日
コメント済み: Mohammad Sami 2020 年 10 月 8 日
My data has time set up as dd-month-yyyy hh:mm:ss How do I average my data from minutes to hours

回答 (1 件)

Mohammad Sami
Mohammad Sami 2020 年 10 月 8 日
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 件のコメント
Marina Minic
Marina Minic 2020 年 10 月 8 日
Thanks. In the answer you posted, do I just put "hour", or does that need to be replaced with something?
Mohammad Sami
Mohammad Sami 2020 年 10 月 8 日
Yes hour will provide hourly average. There are also other options if you want to change the interval.

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeData Type Conversion についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by