Using Accumarray with @maxk instead of @max?

1 次查看(过去 30 天)
Hi,
Say you have three vectors:
a = [1;2;3;4;5;1;3;1;4];
b = [100;200;300;400;500;400;300;200;100];
c = [123;456;221;111;800;1000;10;25;150];
And you use accumarray so that:
maxval = sparse(accumarray(a(:,1),max(b,c),[],@max))
You get:
maxval =
(1,1) 1000
(2,1) 456
(3,1) 300
(4,1) 400
(5,1) 800
Now lets, say I have a whole lot of variables for each subs (something like 2000 each), and I want the average of the top 3 values using the same method. How can I accomplish this? For example, in the same problem, I want my output to be:
The top three values with subs 1 are: 100,400 and 200, so their average is 233.33 and the first row in my sparse matrix is:
maxval =
(1,1) 1000
and so on.
Is it maybe possible to use maxk as a function handle?

采纳的回答

Walter Roberson
Walter Roberson 2019-12-16
accumarray(a(:,1), max(b,c), [], @(v) mean(maxk(v,3)), 0, true) %final parameter is sparse flag
  3 个评论
dpb
dpb 2019-12-17
@() is the preamble to define an anonymous function. The v is the dummy argument variable name Walter chose; you'll see it reflected in the argument to maxk().
All the details about anonymous functions is in the documentation under the general subject of functions.

请先登录,再进行评论。

更多回答(1 个)

dpb
dpb 2019-12-16
编辑:dpb 2019-12-16
Don't see anyway around with accumarray because the VAL parameter must be 1:1 with rows of SUBS; use findgroups/splitapply or varfun (altho latter must be table or timetable).
g=findgroups(a);
mnk=splitapply(@(x) mean(maxk(x,3)),b,g);
yields
>> mnk =
233.3333
200.0000
300.0000
250.0000
500.0000
>>
  7 个评论
dpb
dpb 2019-12-16
What it looked like to me, too, Walter.
Your's works for the specific instance (or anywhere sum is the needed intemediary); however in the followup here I was thinking of the more general cases where the function needs the elements rather than a single result.
Ayman Al-Sukhon
Ayman Al-Sukhon 2019-12-17
Just wanted to thank everyone else for the help. All the suggestions were good, however Walter's got right to the point for me.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by