Find and convert date patterns using regex python-CodePudding

I want to convert date from these two formats 21/01/2022 and 21-Jan-22 into 21 Jan 2022. Format needed day(2 int) month(3 string) year(4 int). Thanks

import pandas as pd

data_dict = {
            'date': ['I paid USD 10,000.00 on 21/01/2022 for car service',
                     'I paid USD 10,000.00 on 21-Jan-22 for car service'
                    ]
          }
df = pd.DataFrame(data_dict)

CodePudding user response：

You can use a regex and pandas.to_datetime:

regex = r'(\d\d/\d\d/\d{4}|\d{1,2}-[a-zA-Z]{3}-\d{2})'
df['new'] = (pd.to_datetime(df['date'].str.extract(regex, expand=False),
                            dayfirst=True)
               .dt.strftime('%d %b %y')
             )

output:

                                                date        new
0  I paid USD 10,000.00 on 21/01/2022 for car ser...  21 Jan 22
1  I paid USD 10,000.00 on 21-Jan-22 for car service  21 Jan 22