different z values for one x y coordinate

Question

Markus 2012-3-7

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31507-different-z-values-for-one-x-y-coordinate

hei,

my problem is, that i have xyz points and it happens, that for one identical x,y value i get several z values.

now i want to get all z values for one x,y koordinate.

i tried first with unique so i now all x,y koordiates. but now i would like to get all z values which belong to this x,y.

thanks for help. ;-) markus

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

请先登录，再进行评论。

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

Answer 1

Markus 2012-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31507-different-z-values-for-one-x-y-coordinate#answer_40029

在 MATLAB Online 中打开

%%looking for unique xy values
      uniCoord=unique(data(:,1:2),'rows');
      uniCoord(:,3:12)=NaN;
%%writing for each xy value in column
% 3-9 all corresponding z values
% 10 amount of corresponding z values
% 11 median of z values
% 12 mean of z values
    for i =1:size(uniCoord,1)
        A=(data(:,1)==uniCoord(i,1)&data(:,2)==uniCoord(i,2));
        B=data(A,3)';
        uniCoord(i,3:2+size(B,2))=B;
        uniCoord(i,10)=size(B,2);
        uniCoord(i,11)=median(uniCoord(i,3:2+size(B,2)));
        uniCoord(i,12)=mean(uniCoord(i,3:2+size(B,2)));
    end

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

请先登录，再进行评论。

Answer 2

Sean de Wolski 2012-3-7

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31507-different-z-values-for-one-x-y-coordinate#answer_40025

在 MATLAB Online 中打开

You could use the index output arguments of unique along with accumarray(). What do you want to do with multiple z values?

doc unique %look at 3rd output
doc accumarray

More per comments:

xy = [1 2; 1 2; 1 2; 3 4; 5 6; 5 6; 7 8]; %xy pairs
z = (1:length(xy))';
[~,idxk,idxn] = unique(xy,'rows'); %idxk = kept rows, idxn = subs_rows
zmean = accumarray(idxn,z,[],@mean); %get the mean of the groups
xyz = [xy(idxk,:) zmean] %concatenate