Clustering data from index

Question

0 个投票

Good morning, I have a matrix like this

ID =
         10032       10033
         10140       10141
         10604       10607
         10610       10611
         10615       10626
         11199       11201
         11200       11203
         11279       11365
         11283       11380
         11605       11606
         11635       11972
          1168        1169
            11         382
            11         505
            11         617
            11         761
            11         975
            975        1320
            3000       617

And I want to get all the families for which a same shared number is available for example a family will contain all these couples:

family = [11         382;
          11         505;
          11         617;
          11         761;
          11         975;
          975        1320;
          3000       617]

Do you have any idea about how to cluster this data?

Thanks in advance!

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

请先登录，再进行评论。

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

Follow Question

Answer 1

KSSV 2016-9-16

在 MATLAB Online 中打开

0 个投票

k = mode(ID(:,1)); % Gets most frequent number 
idx = find(ID(:,1)==k) ;   % get the indices where k=11 is 
iwant = ID(idx,:)

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

Piero Poli 2016-9-16

编辑：Piero Poli 2016-9-16

在 MATLAB Online 中打开

Thanks, however I would like to iterate this process to get all possible families. For examples some families will have just a couple of index (e.g. one line of ID). Any suggestions?

Also, you code is not finding the last two couples of the family one:

 975        1320
3000       617

Thank you

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2016-9-16

在 MATLAB Online 中打开

0 个投票

[a,~,c] = unique(ID);
out = ID(any(ismember(ID,a(accumarray(c,1) > 1)),2),:);

2 个评论
显示无隐藏无

Piero Poli 2016-9-16

Thank you Andrei, unfortunately this lines are not providing the output. I was looking for a way to come out with group of families all sharing at the same index, just as show in the family matrix in my question. At the end I would like to have N families.

Thank you

Andrei Bobrov 2016-9-18

在 MATLAB Online 中打开

function cl = fun_for_piero(ID)
[a,~,c] = unique(ID);
ii = reshape(c,size(ID));
k = 1;
i1 = 1;
cl{k} = [];
c = 1:numel(a);
while ~isempty(ii)
    t = any(ismember(ii,i1),2);
    if ~any(t)
        k = k + 1;
        cl{k} = [];
        i1 = c(1);
    else
        p = unique(ii(t,:));
        cl{k} = [cl{k};sort(a(p(:)))];
        ii = ii(~t,:);
        c = setdiff(c,p);
        i1 = p(:);
    end
end

请先登录，再进行评论。

Clustering data from index

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

回答（2 个）

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

2 个评论
显示无隐藏无

类别

标签

Community Treasure Hunt

Clustering data from index

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

回答（2 个）

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

2 个评论 显示 无 隐藏 无

类别

标签

另请参阅

Community Treasure Hunt

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

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

2 个评论
显示无隐藏无