Concatenate all values of a pandas column into a string

Question

I have a single pandas dataframe like this:

I want to concatenate the values into a single string and store it in a variable like this:

emp_ids = "1111,2222,3333,4444"

Is that possible? If yes, how?

mozway · Accepted Answer · 2021-08-25 11:47:50Z

3

use ','.join:

emp_ids = ','.join(df['EMP ID'])

If the original type is not string (e.g., int):

emp_ids = ','.join(df['EMP ID'].astype(str))

answered Aug 25, 2021 at 11:47

mozway

267k13 gold badges56 silver badges106 bronze badges

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

1 Answer 1