df['due_in_date'] = pd.to_datetime(df['due_in_date'] , format='%Y%m%d') code example

Example 1: from string to time python dataframe

dfc['Time_of_Sail'] = pd.to_datetime(dfc['Time_of_Sail'],format= '%H:%M:%S' ).dt.time

Example 2: pd.to_datetime python

import pandas as pd
date='2020/11/26 12:00:00'
date_time=pd.to_datetime(date, format='%Y/%m/%d %H:%M:%S')