Yearly maximum of a dataset
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
Using a large dataset, I have to determine the yearly maximum value. As the dataset is a table, the function retime doesn't seem te work. Can any of you help me with which function should work?
clear; clc; close all;
filename = 'data_1981_2020_FH';
Data1 = readtable(filename,'PreserveVariableNames',true);
Data1(:,1)=[]; % Remove the 1st column
Data1.YYYYMMDD=datetime(string(Data1.YYYYMMDD),'InputFormat','yyyyMMdd'); % Convert to datetime format
Gmean=groupsummary(Data1,"YYYYMMDD",'day',"mean"); % Calculate daily mean
Gmean.GroupCount=[]
Gmean.mean_HH=[]
%Gmax=groupsummary(Data1,"YYYYMMDD",'year',"max");
TT2_data_year = retime(Gmean,'yearly','max')
%tsmax = max(Data1,'mean_FH','year')
%YrMean = retime(Gmean, 'yearly', 'max'); % Yearly Maximum
%Max = [YrMean.Times.Year YrMean.mean_FH]
2 commentaires
Simon Chan
le 6 Jan 2022
Did you try my reply on your previous question?
G2 = groupfilter(Data1,'YYYYMMDD','year',@(x) x==max(x),'FH')
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!