python pandas data frame replace ends of string values to another character

Question

I want to replace ends of string values in one column to another character. Here, I want to convert every ends of string values to '0'. The values in 'Codes' column are string.

e.g

    Code    
1   11-1111
2   12-2231
3   12-1014
4   15-0117
5   16-2149

to

    Code    
1   11-1110
2   12-2230
3   12-1010
4   15-0110
5   16-2140

What method I can use?

Vaishali · Accepted Answer · 2017-08-25 18:38:07Z

3

One way could be

df.Code = df.Code.str[:-1] + '0'

You get

    Code
1   11-1110
2   12-2230
3   12-1010
4   15-0110
5   16-2140

answered Aug 25, 2017 at 18:38

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

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

3 Comments

Scott Boston Over a year ago

You can't beat that solution. +1

Vaishali Over a year ago

Thank you! You made my Friday:)

BENY Over a year ago

Happy weekends +1

Collectives™ on Stack Overflow

python pandas data frame replace ends of string values to another character

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related