when doing A(B)=C, get average C values if index is used >1 times

Question

Daniel Neubauer 2022-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1842293-when-doing-a-b-c-get-average-c-values-if-index-is-used-1-times

评论： Daniel Neubauer 2022-11-4

say I have matrices

A = [0 0 0]
B=[1 1 2 3]
C=[10 20 30 40]

conventionally when doing

A(B)=C

I get

A = [20 30 40]

So by having a repeating index in B, the lowermost occurence of the index is uesd.

now what I need in this case is to get

A= [mean(C(1),C(2)) C(3) C(4)]

or alternatively another function such as min, max, etc.

So basically what I need is instead of always getting the last called index I need a function of all same called indices.

hope its possible to understand my problem. the real data i have is much bigger and the indices change iteratively, thus manually writing what I need is no option.

thanks for any help!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2022-11-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1842293-when-doing-a-b-c-get-average-c-values-if-index-is-used-1-times#answer_1090128

See findgroups and splitapply

Caution: if you are using a function that operates along the first non-singular dimension, such as mean() does, then be sure to specify the dimension at the time of calling the function if you are expecting to work by columns . mean() of a N x M matrix is 1 x M unless N == 1 in which case that is mean() of a vector and would return a scalar...