Merge many columns into one

Asked Feb 05 '20 at 05:11

Active Feb 05 '20 at 05:11

Viewed 86 times

I have:

 A   B  'C'
'l' 'f' 'g'
's' 'y' 'l'
'v' 'W' 'q'

I would like

ABC
'lfg'
'syl'
'vWq'

It meands, I want to get all the columns int one, not a new, just one. I know I could merge it with'+' but I prefer somenthing more simple, must exist.

Thanks

asked Feb 05 '20 at 05:11

HAAB

`df.agg(''.join, axis=1)` – cs95 Feb 05 '20 at 05:16
you can use pandas to do this as well, https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html – Raj Verma Feb 05 '20 at 05:19
`df.agg(''.join, axis=1).str.replace("'",'').rename('ABC').to_frame()` – moys Feb 05 '20 at 05:21

Merge many columns into one

0 Answers0