Convert Column Timestamp to Date Time

Asked Mar 03 '20 at 14:51

Active Mar 03 '20 at 14:51

Viewed 37 times

I have a dataframe that has a column with a TimeStamp. The data in this column is float64

I want to convert this column to DateTime or add a new column with the readable DateTime

DateTime
2/24/20 14:52
2/24/20 14:50
2/24/20 14:46

I tried the following code -

df1['DateTime'] = datetime.fromtimestamp(df1.timestamp)

And got the following errors -

TypeError("cannot convert the series to " "{0}".format(str(converter)))
TypeError: cannot convert the series to <class 'int'>

asked Mar 03 '20 at 14:51

nafcb10

`pd.to_datetime(df['timestamp'], unit='s')` ..? – Chris Adams Mar 03 '20 at 14:54
One way to avoid this would be ```from datetime import datetime; df['times'] = [datetime.fromtimestamp(t) for t in df['timestamp']]``` – Eric M Mar 03 '20 at 15:00

0 Answers0