C:\Users\Gentle\AppData\Local\Temp\ipykernel_6808\4070415186.py:2: 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. data.to_excel('clean_beautymakeup.xls',sheet_name='clean_data') --------------------------------------------------------------------------- ModuleNotFoundError Traceback (most recent call last) Cell In[41], line 2 1 # 保存清理好的数据为Excel格式 ----> 2 data.to_excel('clean_beautymakeup.xls',sheet_name='clean_data') File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\util\_decorators.py:211, in deprecate_kwarg.._deprecate_kwarg..wrapper(*args, **kwargs) 209 else: 210 kwargs[new_arg_name] = new_arg_value --> 211 return func(*args, **kwargs) File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\util\_decorators.py:211, in deprecate_kwarg.._deprecate_kwarg..wrapper(*args, **kwargs) 209 else: 210 kwargs[new_arg_name] = new_arg_value --> 211 return func(*args, **kwargs) File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\generic.py:2374, in NDFrame.to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes, storage_options) 2361 from pandas.io.formats.excel import ExcelFormatter 2363 formatter = ExcelFormatter( 2364 df, 2365 na_rep=na_rep, (...) 2372 inf_rep=inf_rep, 2373 ) -> 2374 formatter.write( ... ---> 48 import xlwt 50 engine_kwargs = combine_kwargs(engine_kwargs, kwargs) 52 if mode == "a": ModuleNotFoundError: No module named 'xlwt'

这个报错的原因是缺少 `xlwt` 模块，因为您的代码使用了 `xlwt` 的引擎将数据写入 Excel 文件，而目前的 pandas 版本已经不再支持 `xlwt` 引擎，建议您安装 `openpyxl` 模块并使用 `xlsx` 格式保存数据。另外，您可以通过设置 `io.excel.xls.writer` 选项来禁止该警告的出现。您可以通过以下命令安装 `openpyxl` 模块：

pip install openpyxl

然后，您可以使用以下代码将数据保存为 `xlsx` 格式：

data.to_excel('clean_beautymakeup.xlsx',sheet_name='clean_data')

这样就可以避免该警告的出现并成功保存数据。