Answers for "pandas read column in date format"

pandas read column in date format

df['date'] = pd.to_datetime(df.date, format='%Y-%m-%d')

pandas read column in date format

from datetime import datetime
dateparse = lambda x: datetime.strptime(x, '%Y-%m-%d %H:%M:%S')

df = pd.read_csv(infile, parse_dates=['datetime'], date_parser=dateparse)