How to find monthly average from daily data?

Question

samira jahan 2022-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1809665-how-to-find-monthly-average-from-daily-data

评论： Star Strider 2022-9-22

I have a file of 2000 row and 15 columns.First 3 coulmns contain year, month and day.It has 4 years of data of each day. other 12 cloumns contain my variables.This 12 columns has some missing data also.I want to find the monthly average of each variables of each year in one excel sheet.

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2022-9-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1809665-how-to-find-monthly-average-from-daily-data#answer_1058245

You will need to combine the year, month, and day into one datetime array, and then replace the individual variables with the datetime array. (This should not be difficult with removevars and addvars.) Then use the table2timetable function to convert it to a timetable and then use the retime function.

2 个评论
显示无隐藏无

samira jahan 2022-9-22

What about the monthly average?

Star Strider 2022-9-22

See the retime documentation section on Aggregate Timetable Data and Calculate Mean Values for an example. With your timetable, you would use 'monthly' instead of 'hourly' as in the documentation example. Other options are in the section on newTimeStep.

请先登录，再进行评论。