I have an example of data frame I am working with:
column 1 step equipment
0 A 1 eq16
1 A 2 eq56
2 A 3 eq80
3 B 1 eq16
4 B 2 eq49
5 B 3 eq80
6 C 1 eq16
7 C 2 eq49
8 C 3 eq80
I want a new data frame to output something like this (Desired Output):
column 1 step common
A,B,C 1 eq16
A,B,C 3 eq80
For first I'm trying to get all inputted groups to be True for all 'equipment'(column 3) commonality. But later I will try conditional like 3/4 etc.
I tried iterating by separating column 1 groups into new data frames, storing in dictionary and comparing. Which is long and gets confusing as the data gets more complex.
