How to add string to all values in a column of pandas DataFrame

Question

Say you have a DataFrame with columns;

 col_1    col_2 
   1        a
   2        b
   3        c
   4        d
   5        e

how would you change the values of col_2 so that, new value = current value + 'new'

Community · Accepted Answer · 2017-05-23 10:29:46Z

16

Use +:

df.col_2 = df.col_2 + 'new'
print (df)
   col_1 col_2
0      1  anew
1      2  bnew
2      3  cnew
3      4  dnew
4      5  enew

Thanks hooy for another solution:

df.col_2 += 'new'

Or assign:

df = df.assign(col_2 = df.col_2 + 'new')
print (df)
   col_1 col_2
0      1  anew
1      2  bnew
2      3  cnew
3      4  dnew
4      5  enew

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Feb 16, 2017 at 12:27

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

mystery man Over a year ago

@jezrael it says that the df has no attribute to assign, and using + doesnt work either. Is there a way to do it through a loop? i.e : for i in df['col2']: .... i+'new'

jezrael Over a year ago

What is df.info() ? Maybe need alternative with [] like df['col_2'] = df['col_2'] + 'new'

Pfalbaum Over a year ago

df.col_2 += 'new' worked for me. Don't know why this answer is not accepted?

Collectives™ on Stack Overflow

How to add string to all values in a column of pandas DataFrame

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related