Python Excel 对一整列重新赋值

import pandas as pd
import os


df = pd.read_excel('test.xlsx')


# 对列重新赋值
df["访问时间"] =['2020-05-15 %s' % i for i in df["访问时间"]]


list_excel = []
list_excel.append(df)

writer = pd.ExcelWriter('test2.xlsx')
pd.concat(list_excel).to_excel(writer,'sheet1',index=False)
writer.save()

print('ok')