ValueError: Excel does not support datetimes with timezones

ValueError: Excel does not support datetimes with timezones 错误提示

ValueError: Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.

ecel并不支持pandas带时区（timezones）的时间数据导出！所以需要通过该函数去掉时区

解决方案 方法一：pandas.Series.dt.tz_localize

1.检查哪些列具有时区datetime64[ns，UTC]
df.dtypes
2.去掉该列的时区
df[‘date’] = df[‘date’].dt.tz_localize(None)
3.导出execl
df.to_excel(r’filename.xlsx’)

若有其他方法再补充