python 时间戳转换问题 前几位1970-01-01

Question

Answer 1

改成

preparedData['timestamp']=pd.to_datetime(preparedData['timestamp'],unit='s').dt.strftime("%Y-%m-%dT%H:%M:%S")

你题目的解答代码如下：

import pandas as pd

preparedData = pd.DataFrame({"timestamp": [1604015171,1604015172,1604015178]})
print(preparedData['timestamp'])
preparedData['timestamp']=pd.to_datetime(preparedData['timestamp'],unit='s').dt.strftime("%Y-%m-%dT%H:%M:%S")
print(preparedData['timestamp'])

这是转成字符串，要转成datetime64[ns]类型是

preparedData['timestamp']=pd.to_datetime(preparedData['timestamp'],unit='s')

如有帮助，请点击我的回答下方的【采纳该答案】按钮帮忙采纳下，谢谢!