Convert 10-minute wind data into hourly wind data

Question

Tadgh Cullen 2015-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243056-convert-10-minute-wind-data-into-hourly-wind-data

评论： Adam 2015-9-15

采纳的回答： Adam

Capture.PNG

Hi,

I have wind data as attached, and have read it in so that

Speed - 52561x1 double

TimeStep - 52561x1 datetime

I can't figure out how to convert this data into hourly averaged data. I've tried it in excel using pivot tables but can't get the format correct so i have turned to Matlab. I have attempted multiple methods from previous questions but not very savvy with Matlab so keep getting errors. Hopefully someone can help

Thanks in advance

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

请先登录，再进行评论。

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

Answer 1

Adam 2015-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243056-convert-10-minute-wind-data-into-hourly-wind-data#answer_192386

在 MATLAB Online 中打开

Assuming you do not have any missing times you should just be able to trim off one value from your results to have a data set of size divisible by 6 and then something like:

speeds = reshape( speed, 6, [] );
speedAvg = mean( speeds );

If you have gaps in your time array then you will, of course, need to do something more complicated to deal with those.

2 个评论
显示无隐藏无

Tadgh Cullen 2015-9-15

That works great for the speed. How could I apply this to get the corresponding timestep? I.e basically just list out the timestep every hour in the format DD/MM/YY HH/MM?

Adam 2015-9-15

在 MATLAB Online 中打开

You should be able to reshape your datetime array in exactly the same way. I've never really used datetime though so I'm not too familiar with all its different formats, but there are quite a few examples for formatting on the help page.

TimeStep.Format = 'dd/MM/yy HH:mm';

seems to do the job I think.

请先登录，再进行评论。