Convert DataFrame column type from string to datetime dd mm yyyy format

Question

How can I convert a DataFrame column of strings  in dd mm yyyy format  to datetimes

User · Answer

You can use the following if you want to specify tricky formats:

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

More details on format here:

User · Answer

If you have a mixture of formats in your date  don t forget to set infer datetime format True to make life easier  df  date     pd to datetime df  date    infer datetime format True  Source  pd to datetime or if you want a customized approach  def autoconvert datetime value       formats      m  d  Y     m- d- y      formats to try     result format     d- m- Y     output format     for dt format in formats          try              dt obj   datetime strptime value  dt format              return dt obj strftime result format          except Exception as e     throws exception when format doesn t match             pass     return value    let it be if it doesn t match  df  date     df  date   apply autoconvert datetime

User · Answer

If your date column is a string of the format  2017-01-01  you can use pandas astype to convert it to datetime   df  date     df  date   astype  datetime64 ns     or use datetime64 D  if you want Day precision and not nanoseconds  print type df launath  date   iloc 0     yields   lt class  pandas  libs tslib Timestamp  gt  the same as when you use pandas to datetime  You can try it with other formats then   Y- m- d  but at least this works

User · Answer

The easiest way is to use to datetime   df  col     pd to datetime df  col      It also offers a dayfirst argument for European times  but beware this isn t strict    Here it is in action   In  11   pd to datetime pd Series   05 23 2005     Out 11   0   2005-05-23 00 00 00 dtype  datetime64 ns    You can pass a specific format   In  12   pd to datetime pd Series   05 23 2005     format   m  d  Y   Out 12   0   2005-05-23 dtype  datetime64 ns

[python] Convert DataFrame column type from string to datetime, dd/mm/yyyy format

Examples related to python

Examples related to pandas

Examples related to dataframe

Examples related to datetime-format

Examples related to python-datetime