How do I replace a substring with another string that contains that substring as a part of it using regex in python

Question

Suppose I have a string "03/25/93" which is in a pandas series. I want to find /93 first and then replace it with /1993. How do I go about it?

The pandas series is 03/25/93
6/18/85
7/8/71
9/27/75
2/6/96

I want this to be 03/25/1993
6/18/1985
7/8/1971
9/27/1975
2/6/1996

df.str.replace(r'[/]\d{2}$', '/19??')

Sunitha · Accepted Answer · 2018-08-12 17:47:30Z

2

Use \1 to reference a match

>>> df.str.replace(r'/(\d{2})$', r'/19\1')
0    03/25/1993
1     6/18/1985
2      7/8/1971
3     9/27/1975
4      2/6/1996
dtype: object

answered Aug 12, 2018 at 17:47

Sunitha

12.1k2 gold badges23 silver badges23 bronze badges

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

Comments

BENY · Accepted Answer · 2018-08-12 17:44:29Z

2

Using to_datetime with strftime

pd.to_datetime(s,format='%m/%d/%y').dt.strftime('%m/%d/%Y')
Out[937]: 
0    03/25/1993
1    06/18/1985
2    07/08/1971
3    09/27/1975
4    02/06/1996
Name: S, dtype: object

answered Aug 12, 2018 at 17:44

BENY

324k22 gold badges176 silver badges250 bronze badges

1 Comment

user8580505 Over a year ago

thanks it cleared my doubt, but I have a question what if the series also contains some data which has year as YYYY, then it would throw me an error

Collectives™ on Stack Overflow

How do I replace a substring with another string that contains that substring as a part of it using regex in python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related