| Type |
Col1 |
Col2 |
Col3 |
Result |
| Object 1 |
A |
B |
F |
1,0,1 |
| Object 1 |
B |
D |
S |
0,1,0 |
| Object 1 |
C |
F |
R |
0,0,0 |
| Object 1 |
D |
D |
D |
1,1,1 |
| Object 2 |
A |
F |
F |
1,0,1 |
| Object 2 |
D |
D |
D |
1,1,1 |
I have above data frame in which need to populate Result column based on the comparison between element to element in the same column from two different Types like object 1 and object 2 as mentioned above.
Can anyone help me in getting expected results. The exact requirement is find the unmatched element in the same column from second set of record ( here object 2 ).
Appreciate any solutions with package or without package.