필터 지우기
필터 지우기

how to find the hourly average of datetime series

조회 수: 15 (최근 30일)
Daniel Abraham
Daniel Abraham 2021년 7월 28일
댓글: Daniel Abraham 2021년 8월 3일
Hello everyone. I have a datetime series of this form for about 1 month
Dates =datetime(Dates,'InputFormat','dd-MM-yyyy HH:mm:ss')
The variables in the table
Data.Dates
Data.Records1
Data.Records2
I have data for a month at 3 mins intervals.
I visualized plots for the whole time series but I am having troubles visualizing daily averages. 12 to 12 or something like that.
Is it possible to make daily average in hours from this time series into another table with 3 variables?
Thanks in advance

채택된 답변

Scott MacKenzie
Scott MacKenzie 2021년 7월 28일
편집: Scott MacKenzie 2021년 7월 28일
TT1 = table2timetable(Data);
TT2 = retime(TT1, 'hourly', 'mean'); % hourly averages
TT3 = retime(TT1, 'daily', 'mean'); % daily averages
  댓글 수: 3
Scott MacKenzie
Scott MacKenzie 2021년 7월 29일
@Daniel Abraham You state: I was actually looking for was to see the hourly averages for all hours
That's exactly what this line does:
TT2 = retime(TT1, 'hourly', 'mean');
Of course, the line is terminated with a semicolon, so nothing is actually "seen".
You also state: and daily averages for each day of the week of the datetime series
And that's what the following line does:
TT3 = retime(TT1, 'daily', 'mean');
In your example, you include the name of the weekday. If you want to add the weekday name, then add the following:
[~, name] = weekday(TT3.Var1, 'long');
TT3.Weekday = cellstr(name);
If this isn't what you are looking for, please explain further.
Also, it would help if you post your data.
Daniel Abraham
Daniel Abraham 2021년 8월 3일
thank you, it works perfectly

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Dates and Time에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by