python pandas how to combine the pandas with the same column value

Question

convert this frame:

1, 2
----
a, g
a, a
a, j
d, b
c, e

into:

1, 2
----
a, g,a,j
d, b
c, e   

what can I do, can I use groupby? what other methods?

Answer 1

You can use groupby with apply function join:

df.columns = list('AB')
print (df)
   A  B
0  a  g
1  a  a
2  a  j
3  d  b
4  c  e

df = df.groupby('A')['B'].apply(','.join).reset_index()
print (df)
   A      B
0  a  g,a,j
1  c      e
2  d      b