How to convert from daily timestep to monthly average?

3 次查看（过去 30 天）
Elizabeth Lees
Elizabeth Lees 2021-3-23
评论： Mathieu NOE 2021-3-24
Hi I currently have a datatable loaded into MATLAB with the first column stating the date in yyyy-MM-dd HH:mm:ss timestep. I then have 11 other columns with data values. I want to convert this data from the current daily timestep stated to mean monthly values for each column of data. How do I go about doing this? I have attached the data file in question.

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

采纳的回答

Mathieu NOE
Mathieu NOE 2021-3-23
hello Elizabeth
here you are :
Daily_Data = load('example_data.mat');
Daily_Data = Daily_Data.MIKESHEver10calibrationDetailedTSM11;
Monthly_avg_Data=retime(table2timetable(Daily_Data),'monthly','mean');

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by