MATLAB Answers

How to convert from daily timestep to monthly average?

1 view (last 30 days)
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.

Accepted Answer

Mathieu NOE
Mathieu NOE on 23 Mar 2021
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');

More Answers (0)

Products


Release

R2018a

Community Treasure Hunt

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

Start Hunting!