How to concat two column by pandas

Question

How can I concatenate columns and rows like this?

In:
  a  |  b  |  c  |  e
-----------------------
 mm    af    bn    nn
 pp    af    bn    yy

Out:

  b  |  c  |  final
------------------
af      bn    mm:nn&pp:yy

BENY · Accepted Answer · 2020-12-22 20:05:18Z

2

We can do column modify before groupby with agg

out = df.assign(final=df.a+':'+df.e).groupby(['b','c'],as_index=False).agg({'final':'&'.join})
out
Out[198]: 
    b   c        final
0  af  bn  mm:nn&pp:yy

edited Dec 22, 2020 at 20:05

answered Dec 22, 2020 at 19:29

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohammad Hossein Gerami Over a year ago

Thanks, Beny. it's a correct answer. but I edit out. I want separate column by ":" char.

Collectives™ on Stack Overflow

How to concat two column by pandas

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related