Creating a one hour time interval from a on second data of a wind turbine

Question

hasnain ali 2021-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/807527-creating-a-one-hour-time-interval-from-a-on-second-data-of-a-wind-turbine

编辑： hasnain ali 2021-4-20

Problem Question:

Hey guys i am having trouble with creatin a time interval. i have a data avilible from a wind turbie which generates the power and the data is gathered for every second. i am trying to create an hourly time interval the time stamp is converted into numerical form. I am trying to Use the reshape function but when we calculate them for whole day 24*60*60= 86400 but my data is 86341 so the reshape function says the nymber of elements shold not change. at this point i am doing it for a day but i have a data fro 2 hour were i have to calculate the wind power to determine the battery size i need.

In case of a 1 week of data when i try to do it data sample should be this 24*60*60*7=604800 but my 2D array data set have 604388 samle points so the reshape will not work in this case as well.

Is there anyway i can reshape or creat a time interval using a for loop or someother way so that i can integrate and calculate the hourly data calculation.i can't upload the excel sheet because it is too big but i am uploading the picture of what i looks like in excel and also in matlab from time stam point of view.

any help would be good if you don't understand i can explain more