mean from intersection matrix

Question

eko supriyadi 2021-10-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1565051-mean-from-intersection-matrix

评论： eko supriyadi 2021-10-16

采纳的回答： Ive J

在 MATLAB Online 中打开

Hi matlab community

Suppose i have matrix:

a = [1,3,3,2,2,3,3,4,3,1,3];
b = [1,1,1,3,4,1,2,1,4,1,1];
c = [2,2,2,4,2,3,3,2,1,3,8];

now, I want to get the mean value (from matrix c) of the intersection of matrices [ab] which have the same value, like this:

a = [1,3,2,2,3,4,3];
b = [1,1,3,4,2,1,4];
c = [2.5,3.75,4,2,3,2,1]; %final result

how to do it? tks :)

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

请先登录，再进行评论。

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

Answer 1

Ive J 2021-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1565051-mean-from-intersection-matrix#answer_809881

在 MATLAB Online 中打开

This should work:

a = [1,3,3,2,2,3,3,4,3,1,3];
b = [1,1,1,3,4,1,2,1,4,1,1];
c = [2,2,2,4,2,3,3,2,1,3,8];
x = [a; b];
[~, ia, ic] = unique(x.', 'stable', 'rows');
newC = arrayfun(@(x) mean(c(ic == x)), unique(ic)).'
newC = 1×7
    2.5000    3.7500    4.0000    2.0000    3.0000    2.0000    1.0000