Find max value with multiple conditions

21 visualizaciones (últimos 30 días)
Anita Fitriani
Anita Fitriani el 15 de En. de 2020
Comentada: Auwal Adamu Abdullahi el 1 de Ag. de 2021
How can I find max value with 2 or more conditions (such as maxifs in excel).
Thanks before
  6 comentarios
Andrei Bobrov
Andrei Bobrov el 16 de En. de 2020
Please attach small part of your excel-file or data table as MATLAB variable - 'table' in mat -file.
Anita Fitriani
Anita Fitriani el 16 de En. de 2020
This is small part of my wave height data

Iniciar sesión para comentar.

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 16 de En. de 2020
T=readtable('wave height data.xlsx');
[r,rn] = findgroups(T(:,1));
[c,cn] = findgroups(T(:,2));
out = accumarray([r,c],T.WaveHeight,[],@max);
Tout = array2table([rn.Year,out],'VariableNames',[{'Year'};cn.Direction]);
  3 comentarios
Andrei Bobrov
Andrei Bobrov el 17 de En. de 2020
Anita! If my answer solved your problem, then please accept it.
Auwal Adamu Abdullahi
Auwal Adamu Abdullahi el 1 de Ag. de 2021
How do i obtain and tabulate the maximum wave height. Add to that table two separate columns that show the direction and period of each of those yearly maximum wave heights. for 30 years?

Iniciar sesión para comentar.

Más respuestas (1)

CAM
CAM el 16 de En. de 2020
Editada: CAM el 16 de En. de 2020
Use logic statements for each criterion. Use logical "AND" (&) to see which elements meet all criteria. Find the max of those values.
Air Code (untested):
idxC1 = (matrix > criterion1);
idxC2 = (matrix < criterion2);
...
idxOverall = idxC1 & idxC2 & ... & idxCn;
MaxVal = max(matrix(idxOverall));

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by