Concatenate a DataFrame column into a String

Question

I have a DataFrame like below:

column_A   column_B
  2           4 
  7           1  
 Seven      Three
  34         23

I would like to return the values of column_A and column_B as a single string like below:

concatenated_A = 2, 7, Seven, 34
concatenated_B = 4, 1, Three, 23

I have tried to the below code:

concatenated_A = df[column_A].to_json()
print(concatenated_A)

But it is getting printed like below:

{"0":"2", "1":"7", "2":"Seven", "3":"34"}

Any help would be appreciated.

Answer 1

Get two columns output

df.apply(', '.join)
Out[41]: 
column_A    2, 7, Seven, 34
column_B    4, 1, Three, 23
dtype: object

Answer 2

Use str.cat

>>> df.column_A.str.cat(sep=' ')
'2 7 Seven 34'