To read a csv with clean dates, use following:
df = pd.read_csv(filename, parse_dates=['date_column_name'])