Yearly maximum of a dataset

2 visualizaciones (últimos 30 días)
Murielle van Pampus
Murielle van Pampus el 6 de En. de 2022
Comentada: Murielle van Pampus el 6 de En. de 2022
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 comentarios
Simon Chan
Simon Chan el 6 de En. de 2022
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 el 6 de En. de 2022
Thank you, this works perfect! Thank you so mucht :)

Iniciar sesión para comentar.

Respuestas (0)

Etiquetas

Productos


Versión

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by