import xlwt
import numpy as np
from pathlib import Path, WindowsPath
sheet_names = ["ACC_mean", "ACC_std", "F1_mean", "F1_std", "MAE_mean", "MAE_std", "QYR_mean", "QYR_std", "ALC_Acc_mean",
"ALC_Acc_std", "ALC_F1_mean", "ALC_F1_std", "ALC_MAE_mean", "ALC_MAE_std"]
names = ["car","computer15-5bin","ERA","ESL","eucalyptus","housing-5bin","LEV","machine-5bin","newthyroid","stock-5bin","SWD","winequality-red"]
for name in names:
save_path = WindowsPath(r"D:\Result_HS2")
workbook = xlwt.Workbook()
for sn in sheet_names:
workbook.add_sheet(sn)
dir = save_path.joinpath(name+"-result.xls")
# """重点来了,加上路径强制字符串转换,就不会在出现问题了"""
# dir = str(dir)
# print(save_path)
workbook.save(dir)
上述代码在部分windows 环境下不会出错。但是,就在我的电脑上出错了!
solution:
"""重点来了,加上路径强制字符串转换,就不会在出现问题了"""
dir = str(dir)
加上路径字符串强制转换问题解决。