replace numeric values in column dataframe python

Question

Im new using python. I have a dataframe with 3 columns (id, name, description), My dataframe contains as example these rows ('id1', 'paul', 'tmp123'), ('id2', 'laura', 'vi34jay'). I want to replace the numeric characters of my column description by "TT".

expected output

('id1', 'paul', 'tmpTTT'), ('id2', 'laura', 'viTTjay')

Does anyone knows how to do? Thank you

jezrael · Accepted Answer · 2020-08-05 13:03:35Z

3

Use Series.replace with \d for match digit:

df = pd.DataFrame({'description': ['tmp123', 'vi34jay']})

df['description'] = df['description'].replace('\d', 'T', regex=True)
print(df)
  description
0      tmpTTT
1     viTTjay

answered Aug 5, 2020 at 13:03

jezrael

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

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

Collectives™ on Stack Overflow

replace numeric values in column dataframe python

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