Find max value with multiple conditions
42 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Anita Fitriani
le 15 Jan 2020
Commenté : Auwal Adamu Abdullahi
le 1 Août 2021
How can I find max value with 2 or more conditions (such as maxifs in excel).
Thanks before
6 commentaires
Andrei Bobrov
le 16 Jan 2020
Please attach small part of your excel-file or data table as MATLAB variable - 'table' in mat -file.
Réponse acceptée
Andrei Bobrov
le 16 Jan 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 commentaires
Auwal Adamu Abdullahi
le 1 Août 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?
Plus de réponses (1)
CAM
le 16 Jan 2020
Modifié(e) : CAM
le 16 Jan 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));
0 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!