How to obtain hourly average from several years of data

Question

Srilatha Raghavan 2020-7-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/566793-how-to-obtain-hourly-average-from-several-years-of-data

编辑： KSSV 2023-9-11

Hello,

I have 7 years of hourly data(attached file). I have them in a timetable that has (7*8760 + extra hours from leap year) number of rows.

I am trying to find the average of each hour of the years. I have been exporting the table above to excel and then splittin it column wise and averaging and coming back to matlab and working on it. I tried the groupsummary function, but it gives me 24 hours of value.

I did find a previous answer to a similar question, but that was confusing to me as well. I have attached the link to that answer.

https://www.mathworks.com/matlabcentral/answers/455537-trouble-using-retime-to-obtain-1-year-of-hourly-average-values-from-15-years-of-hourly-average-value

I would appreciate if someone could help me with this.

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sindar 2020-7-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/566793-how-to-obtain-hourly-average-from-several-years-of-data#answer_467319

在 MATLAB Online 中打开

G = groupsummary(struct2table(WSHelp),'DateTime','hour','mean');

7 个评论
显示 5更早的评论隐藏 5更早的评论

Sindar 2020-7-17

编辑：Sindar 2020-7-17

在 MATLAB Online 中打开

Here's what I've got:

mytable = struct2table(WSHelp);
% add a column with the datetime excluding year and minute info
% you can mess with the format, but '01/01 00' sorts well and looks nice to me
mytable.yearhour = string(mytable.DateTime,'MM/dd HH');
% perform summary based on that column (exclude original time column from summary)
G = groupsummary(mytable(:,2:end),'yearhour','mean');

this gets you 8784 rows (includes leap year hours), looking like this:

G(1:10,:)
  10×3 table
     yearhour     GroupCount    mean_WindSpeed
    __________    __________    ______________
    "01/01 00"        7             13.905    
    "01/01 01"        7             14.095    
    "01/01 02"        7             14.178    
    "01/01 03"        7             14.098    
    "01/01 04"        7             14.302    
    "01/01 05"        6             12.989    
    "01/01 06"        6             12.796    
    "01/01 07"        6             12.485    
    "01/01 08"        6             12.888    
    "01/01 09"        6             12.601    
    

If you want to exclude leap days:

idx = ~(month(mytable.DateTime)==2 & day(mytable.DateTime)==29);
G = groupsummary(mytable(idx,2:end),'yearhour','mean');

Srilatha Raghavan 2020-7-17

Oh yes! This works. Thank you so much! I appreciate your help :)

Sindar 2020-7-17

Sorry, I had some typos, try the updated

请先登录，再进行评论。

How to obtain hourly average from several years of data

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

7 个评论
显示 5更早的评论隐藏 5更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

How to obtain hourly average from several years of data

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

7 个评论 显示 5更早的评论隐藏 5更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

7 个评论
显示 5更早的评论隐藏 5更早的评论