Yearly maximum of a dataset
2 views (last 30 days)
Show older comments
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 Comments
Simon Chan
on 6 Jan 2022
Did you try my reply on your previous question?
G2 = groupfilter(Data1,'YYYYMMDD','year',@(x) x==max(x),'FH')
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!