Yearly maximum of a dataset

2 次查看（过去 30 天）
Murielle van Pampus
评论： Murielle van Pampus 2022-1-6
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 个评论
Simon Chan
Simon Chan 2022-1-6
Did you try my reply on your previous question?
G2 = groupfilter(Data1,'YYYYMMDD','year',@(x) x==max(x),'FH')
Murielle van Pampus
Murielle van Pampus 2022-1-6
Thank you, this works perfect! Thank you so mucht :)

请先登录，再进行评论。

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

回答（0 个）

类别

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

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by