Adding DataFrame columns in Python pandas

Question

I have pandas DataFrame that has a number of columns (about 20) containing string objects. I'm looking for a simple method to add all of the columns together into one new column, but have so far been unsuccessful e.g.:

for i in df.columns:
    df[‘newcolumn’] = df[‘newcolumn’] + ‘/‘ + df.ix[:,i]

This results in an empty DataFrame column ‘newcolumn’ instead of the concatenated column.

I’m new to pandas, so any help would be much appreciated.

do you want the values of each column added together as well? — agconti
– agconti, Commented Jan 12, 2014 at 2:27

BrenBarn · Accepted Answer · 2014-01-12 02:29:39Z

3

df['newcolumn'] = df.apply(''.join, axis=1)

answered Jan 12, 2014 at 2:29

BrenBarn

253k39 gold badges421 silver badges392 bronze badges

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

Collectives™ on Stack Overflow

Adding DataFrame columns in Python pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related