DoB = pd.Series(["07Sep59","01Jan55","15Dec47","11Jul42"]) DoB = DoB.str[:-2]+'19'+DoB.str[-2:] pd.to_datetime(DoB,format = '%d%b%Y')