Find max value with multiple conditions

24 次查看（过去 30 天）

显示更早的评论

Anita Fitriani 2020-1-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500407-find-max-value-with-multiple-conditions

评论： Auwal Adamu Abdullahi 2021-8-1

采纳的回答： Andrei Bobrov

How can I find max value with 2 or more conditions (such as maxifs in excel).

Thanks before

6 个评论
显示 4更早的评论隐藏 4更早的评论

Andrei Bobrov 2020-1-16

Please attach small part of your excel-file or data table as MATLAB variable - 'table' in mat -file.

Anita Fitriani 2020-1-16

wave height data.xlsx

This is small part of my wave height data

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2020-1-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500407-find-max-value-with-multiple-conditions#answer_410475

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

Andrei Bobrov 2020-1-17

Anita! If my answer solved your problem, then please accept it.

Auwal Adamu Abdullahi 2021-8-1

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?

请先登录，再进行评论。