I want to zip column B
based on common Column A
values. Please suggest a way to do so on scale in large pandas dataframe
.
df
A B
0 P
0 Q
1 R
1 S
2 T
Expected Result
A B
0 [P,Q]
1 [R,S]
2 [T]
I want to zip column B
based on common Column A
values. Please suggest a way to do so on scale in large pandas dataframe
.
df
A B
0 P
0 Q
1 R
1 S
2 T
Expected Result
A B
0 [P,Q]
1 [R,S]
2 [T]