1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| import pandas as pd
data = (
"12/03/86",
"11/01/1978 برج الغدير",
"19/12/1978 عنابة",
"20/04/1971 عنابة",
"12/06/1962 عنابة",
"07/01/1978 قسنطينة",
"12/06/1965 واد زناتي",
"31/08/1989 سوق أهراس",
"01/04/1988 عنابة",
"02/07/1974 لخضارة",
"04/01/1977 عنابة",
"10/08/1987 toto",
"15-05-89",
"23-10-1995 عنابة",
)
df = pd.DataFrame(data, columns=['input'])
df['date'] = df['input'].str.extract(r'(\d{1,2}(?:\/|-)\d{1,2}(?:\/|-)(?:\d{2}|\d{4}))')
df['date'] = pd.to_datetime(df['date'], dayfirst=True, errors='coerce').dt.strftime('%d/%m/%Y')
print(df['date']) |
Partager