Python: Concat values of all rows in single row in all columns

Question

I want to concat all the values in the rows from all columns. See below examples for more details.

Input --->

col_1 col_2   
1      a  
2      b  
3      c  
4      d

Output----->

col_1     col_2  
1_2_3_4   a_b_c_d

Is it possible to perform such operation using pandas in python?

BENY · Accepted Answer · 2019-10-25 13:57:58Z

2

Using apply with join ,after convert all value to string type

s=df.astype(str).apply('_'.join).to_frame(0).T
s
Out[247]: 
     col_1    col_2
0  1_2_3_4  a_b_c_d

answered Oct 25, 2019 at 13:57

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Answer 1