Generating Daily Values using Hourly Values

Question

Ugur Acar 2019-10-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486061-generating-daily-values-using-hourly-values

评论： Ugur Acar 2019-10-18

i have hourly (8760h) temperature values of each year. I need to generate daily values using hourly values.

For example, i need to calculate some daily parameters like daily average temperature or daily maximum temprerature using hourly data.

Raw data is in a excel file. File format is like this;

After reading excel data, i used 'datenum' function to assign numeric value to each day. Then corrected the first day's numercal value to "1".

for i=1:8760;
raw(i,1)=datenum(Excel_data(i,1),Excel_data(i,2),Excel_data(i,3));
corrected(i,1)=datenum(Excel_data(i,1),Excel_data(i,2),Excel_data(i,3))-raw(1,1)+1;
corrected(i,2)=Excel_data(i,5);
end

Then i have,

corrected=8760x2

After this point, for example, i need calculate daily average temperature for day 1, day 2 ....day 365 at this step.

it needs to look like this;

but i couldnt manage to get a table seems like above.

2 个评论
显示无隐藏无

Andrei Bobrov 2019-10-18

here attach your data (your xlsx-file)

Ugur Acar 2019-10-18

istanbul_sicaklik3.xlsx

i attached the data for 5 years.

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2019-10-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486061-generating-daily-values-using-hourly-values#answer_396977

T = readtable('your_xlsx_file.xlsx');
t = datetime([T{:,1:4}, zeros(size(T,1),2)]);
TT = timetable(T{:,end},'RowTimes',t) ;
TT_mean = retime(TT,'daily','mean');
TT_max = retime(TT,'daily','max');
TT_out = [TT_mean,TT_max];