在excel文件进行保存的时候,报错
FutureWarning: As the xlwt package is no longer maintained, the xlwt engine will be removed in a future version of pandas. This is the only engine in pandas that supports writing in the xls format. Install openpyxl and write to an xlsx file instead. You can set the option io.excel.xls.writer to ‘xlwt’ to silence this warning. While this option is deprecated and will also raise a warning, it can be globally set and the warning suppressed.
df2.to_excel(‘D:\数据分析资料\lianxi\eact_6.xls’)
意思是xlwt已经弃用了,所以文件保存写文件格式的时候
df2.to_excel('D:\数据分析资料\lianxi\eact_7.xls')
改成xlsx
df2.to_excel('D:\数据分析资料\lianxi\eact_7.xlsx')