Hi Expects,
Assume I have dataset below:
ID
v1
v2
…..
vn
1
a
2
a
b
3
b
d
4
d
5
a
the desired output I wanted:
Group_id
ID
v1
v2
…..
vn
1
1
a
1
2
a
b
1
3
b
d
1
4
d
1
5
a
I want the same value from each column resolved together. ID=1,2,5 resolve together due to same value 'a' in V1. ID=2,3 resolve together in V2 due to same value 'b'. ID=3,4 resolve together in Vn due to same value 'd'. Because ID=1,2,5 and ID=2,3 and ID=3,4 resolve by v1, v2, Vn respectively so ID=1,2,3,4,5 all resolved together due to indirect resolution among V1, V2,... Vn. This is because ID=1,2,5 and ID=2,3 share same ID=2. ID=2,3 and ID=3,4 share same ID=3. So they all should be assigned same ID.
Can someone help me on this? the number of variables used to link rows are not confirmed so I need a program flexible enough to adjust for more or less.
... View more