Find max value with multiple conditions

55 visualizzazioni (ultimi 30 giorni)
How can I find max value with 2 or more conditions (such as maxifs in excel).
Thanks before
  6 Commenti
Anita Fitriani
Anita Fitriani il 16 Gen 2020
This is small part of my wave height data

Accedi per commentare.

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 16 Gen 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 Commenti
Auwal Adamu Abdullahi
Auwal Adamu Abdullahi il 1 Ago 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?

Accedi per commentare.

Più risposte (1)

CAM il 16 Gen 2020
Modificato: CAM il 16 Gen 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));


Scopri di più su Large Files and Big Data in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by