import datetime as dt
dt.datetime.strptime('30MAR1990', '%d%b%Y')
parser = lambda date: pd.datetime.strptime(date, '%d%b%Y')
pd.read_csv(StringIO(s), parse_dates=[0], date_parser=parser)
Parse_dates в пандах