I have a csv file where each row contains a pair of values. For example, it might look something like this:
A, B
B, D
E, G
F, G
H, C
Each row should be interpreted to mean that the two values should be in the same group. I'm trying to find an elegant/simple way to take the ordered pairs from the csv and determine the groupings. Based on the pairs above, the groups would be {A, B, D}, {C, H}, {E, F, G} and I would want to output something like:
A, Group 1
B, Group 1
C, Group 2
D, Group 1
E, Group 3
F, Group 3
G, Group 3
H, Group 2
I'm having a hard time wrapping my head around the best way to approach this. Is there a simple way to do this?