converting 1 hourly data to 3 hourly data
1 view (last 30 days)
Show older comments
I have file of excel with date,hour,waveheight i need to convert avg of three hourly data set i.e each day i will get 8x3(8 data sets) instead of 24x1 (24 data sets) can anyone help me out in writing code since i am new to matlab. attached file also.
Any kind of help will be useful for me
thanks
janakiram
Answers (1)
Ajay Kumar
on 27 Sep 2019
Edited: Ajay Kumar
on 27 Sep 2019
data = xlsread('www3');
data = data(:,2);
j=1;
try
for i = 1: fix(length(data))
newdata(i) = mean(data(j:j+2));
j=j+3;
end
catch
end
newdata = newdata';
new data has 2912 values. Each is average of 3 hours of original data.
2 Comments
Ajay Kumar
on 27 Sep 2019
Edited: Ajay Kumar
on 27 Sep 2019
My pleasure.
Please accept the answer if you got what you need. Thanks :)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!