python - 删除 +00 :00 (UTC offset) from timestamp in Python/pandas

Question

我想从下面的时间戳中删除 +00:00。我使用下面的代码从时间戳中删除了 T 和 Z 但 dtype 仍然是 datetime64[ns, UTC] 理想情况下我想将它转换为 datetime64[ns]

df['Timestamp_column'].dt.tz_localize(None)

转换前的Timestamp_column:

2020-07-10T14:12:39.000Z    

输出:

2020-07-10 14:12:39+00:00   

Answer 1

你可以tz_convert to None :

import pandas as pd

df = pd.DataFrame({'Timestamp_column': ['2020-07-10T14:12:39.000Z']})

df['Timestamp_column'] = pd.to_datetime(df['Timestamp_column']).dt.tz_convert(None)

# df['Timestamp_column']
# 0   2020-07-10 14:12:39
# Name: Timestamp_column, dtype: datetime64[ns]