Python: Remove specific character from dataframe column value

Question

I have a dataframe with Column[ID] and values ('123456','102554','0145220','1554201','0155401','0101010110','0101010105') If last 2 characters of the column starts with 0 then update the value without that 0

Final result of dataframe should be ('123456','102554','0145220','155421','015541','0101010110','010101015')

Please help

Georgina Skibinski · Accepted Answer · 2021-03-19 18:49:02Z

3

You can leverage pd.Series.replace(..., regex=True):

df["ID"] = df["ID"].replace("^(.*)0(.)$", "\\1\\2", regex=True)

Outputs:

           ID
0      123456
1      102554
2     0145220
3      155421
4      015541
5  0101010110
6   010101015

answered Mar 19, 2021 at 18:49

Georgina Skibinski

13.5k2 gold badges16 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Python: Remove specific character from dataframe column value

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