converting 1 hourly data to 3 hourly data
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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
1 Kommentar
Antworten (1)
Ajay Kumar
am 27 Sep. 2019
Bearbeitet: Ajay Kumar
am 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 Kommentare
Ajay Kumar
am 27 Sep. 2019
Bearbeitet: Ajay Kumar
am 27 Sep. 2019
My pleasure.
Please accept the answer if you got what you need. Thanks :)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!