How to convert from daily timestep to monthly average?

3 vues (au cours des 30 derniers jours)
Elizabeth Lees
Elizabeth Lees le 23 Mar 2021
Commenté : Mathieu NOE le 24 Mar 2021
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.

Connectez-vous pour répondre à cette question.

Réponse acceptée

Mathieu NOE
Mathieu NOE le 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');
  2 commentaires
Elizabeth Lees
Elizabeth Lees le 23 Mar 2021
Thank you perfect answer!
Mathieu NOE
Mathieu NOE le 24 Mar 2021
you're welcome !

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur MATLAB dans Help Center et File Exchange

Tags

Produits


Version

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by