[Pandas] to_excel保存时writer.save() 报错问题

今天试着用pandas在一个excel里保存多个sheet,由于要用到writer = pd.ExcelWriter(......)命令,别的攻略里说最后要用writer.save()保存,但实际运行时遇到了如下报错:

AttributeError: 'OpenpyxlWriter' object has no attribute 'save'. Did you mean: '_save'?

在stackoverflow上看到这样的说法:

The save() method has been deprecated and removed in Pandas. You should use close() instead.

也就是说,新版Pandas中save()函数已经被弃用了,只用writer.close()保存即可。

D:\Anaconda\python.exe D:\PycharmProjects\PythonProject2\.idea\inspectionProfiles\hb.py D:\PycharmProjects\PythonProject2\.idea\inspectionProfiles\hb.py:29: SyntaxWarning: invalid escape sequence '\T' D:\PycharmProjects\PythonProject2\.idea\inspectionProfiles\hb.py:30: SyntaxWarning: invalid escape sequence '\m' Traceback (most recent call last): File "D:\PycharmProjects\PythonProject2\.idea\inspectionProfiles\hb.py", line 27, in <module> merge_excel_files( File "D:\PycharmProjects\PythonProject2\.idea\inspectionProfiles\hb.py", line 22, in merge_excel_files combined_df.to_excel(output_file, index=False) File "D:\Anaconda\Lib\site-packages\pandas\util\_decorators.py", line 333, in wrapper return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "D:\Anaconda\Lib\site-packages\pandas\core\generic.py", line 2417, in to_excel formatter.write( File "D:\Anaconda\Lib\site-packages\pandas\io\formats\excel.py", line 943, in write writer = ExcelWriter( ^^^^^^^^^^^^ File "D:\Anaconda\Lib\site-packages\pandas\io\excel\_openpyxl.py", line 61, in __init__ super().__init__( File "D:\Anaconda\Lib\site-packages\pandas\io\excel\_base.py", line 1246, in __init__ self._handles = get_handle( ^^^^^^^^^^^ File "D:\Anaconda\Lib\site-packages\pandas\io\common.py", line 749, in get_handle check_parent_directory(str(handle)) File "D:\Anaconda\Lib\site-packages\pandas\io\common.py", line 616, in check_parent_directory raise OSError(rf"Cannot save file into a non-existent directory: '{parent}'") 这串报错代码帮我解释一下是什么原因,结合上面问你的那串代码
最新发布
04-03
评论 6
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值