How can I find the max and min amongst a set of grouping variables?

2015 2 3
2 个回答
回答已采纳
更新时间：2015 2 3
4 次查看（30 天）

0 个投票

I have a 150x2 matrix in which the first column contains numbers that can be considered 'grouping variables' and the second column contains values associated with those grouping variables. So a small 6x2 version would look like this
1 23
1 29
1 43
2 38
2 22
2 100
I'd like to find the maximum of the values associated with each grouping variable. Similarly the minimum amongst the values associated with each grouping variable. So the above example would yield an max of 43(for variable 1) and min of 23 (for variable 1). Similarly, max of 100 (for variable 2) and min of 22 (for variable 2). Does anybody know of a similar function or method to achieve this in Matlab?

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

 采纳的回答

2 个投票

Since you didn't write if every number will occur in the first column, I allow for "missing" numbers here (it doesn't make a big difference anyway):
a=1+fix(0:.23:8)' ;
b=randi(50,length(a),1);
M=[a b]
nums=unique(M(:,1));
mmin=zeros(max(nums),1);
mmax=zeros(max(nums),1);
for cnt=1:max(nums)
mmin(nums(cnt))=min(M(M(:,1)==nums(cnt),2));
mmax(nums(cnt))=max(M(M(:,1)==nums(cnt),2));
end
If every number will occur, nums(cnt)==cnt, so the expressions inside the loop can be simplified a bit.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Thank u so much Michael. Never in my wildest dreams did I think that people would reply so fast and come up with accurate answers.

请先登录，再进行评论。

更多回答（1 个）

David Young
David Young 2015-2-3

4 个投票

% test data
data = [1 23; 1 29; 1 43; 2 38; 2 22; 2 100];
% compute minima and maxima
mins = accumarray(data(:,1), data(:,2), [], @min);
maxs = accumarray(data(:,1), data(:,2), [], @max);
Then mins(k) and maxs(k) hold the min and max for grouping variable k.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

accumarray... I didn't know this function. Thanks!
Prateek Samuel Daniels
编辑：Prateek Samuel Daniels 2015-2-3
Thank u David. I've tried going thru the documentation on accumarray and I couldn't understand why and how it was used. But when I saw your response, things were pretty clear, except for the [] (the 3rd argument). Why do we need to put that. would it be possible for you to recommend me any matlab advanced/ intermediate book which covers these functions and its usage. Many thanks !!!
David Young
David Young 2015-2-3
The third argument specifies the size of the output array, but if you're happy to let it be determined by the values in the first argument you can just let it default by putting [].
I'm afraid I don't know which books cover relatively recent functions like accumarray.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by