Use datetime module: from datetime import datetime ts = int(‘1284101485’) # if you encounter a “year is out of range” error the timestamp # may be in milliseconds, try `ts /= 1000` in that case print(datetime.utcfromtimestamp(ts).strftime(‘%Y-%m-%d %H:%M:%S’))
You can use dt.strftime if you need to convert datetime to other formats (but note that then dtype of column will be object (string)): import pandas as pd df = pd.DataFrame({‘DOB’: {0: ’26/1/2016′, 1: ’26/1/2016′}}) print (df) DOB 0 26/1/2016 1 26/1/2016 df[‘DOB’] = pd.to_datetime(df.DOB) print (df) DOB 0 2016-01-26 1 2016-01-26 df[‘DOB1’] = df[‘DOB’].dt.strftime(‘%m/%d/%Y’) … Read more