ROC曲线

import numpy as np
import pandas as pd
from sklearn.metrics import roc_curve, auc, accuracy_score
import openpyxl  # 确保安装了openpyxl库

# 你的数据和模型定义
kf = ...  # 定义你的KFold或其他交叉验证方法
X = ...   # 特征数据
y = ...   # 标签数据
model = ...  # 定义你的模型
mean_fpr = np.linspace(0, 1, 100)  # 用于插值的平均FPR值

# 用于存储结果的列表
accuracy_list = []
aucs = []
tprs = []

for train_index, test_index in kf.split(X):
    X_train, X_test = X[train_index], X[test_index]
    y_train, y_test = y[train_index], y[test_index]
 
    # 训练SVM模型
    model.fit(X_train, y_train)
 
    # 评估模型
    y_pred = model.predict(X_test)
    y_prob = model.predict_proba(X_test)[:, 1]
 
    accuracy = accuracy_score(y_test, y_pred)
    accuracy_list.append(accuracy)
 
    # 计算ROC曲线
    fpr, tpr, _ = roc_curve(y_test, y_prob)
    roc_auc = auc(fpr, tpr)
    aucs.append(roc_auc)
    tprs.append(np.interp(mean_fpr, fpr, tpr))
    tprs[-1][0] = 0.0
 
# 计算平均TPR和AUC
mean_tpr = np.mean(tprs, axis=0)
mean_tpr[-1] = 1.0
mean_auc = auc(mean_fpr, mean_tpr)
std_auc = np.std(aucs)

# 计算TPR的标准差
std_tpr = np.std(tprs, axis=0)
tprs_upper = np.minimum(mean_tpr + std_tpr, 1)
tprs_lower = np.maximum(mean_tpr - std_tpr, 0)

# 创建一个数据框架来存储结果
results = pd.DataFrame({
    'mean_fpr': mean_fpr,
    'mean_tpr': mean_tpr,
    'tprs_upper': tprs_upper,
    'tprs_lower': tprs_lower,
    'mean_auc': [mean_auc] * len(mean_fpr),
    'std_auc': [std_auc] * len(mean_fpr)
})

# 将数据框架写入Excel文件
results.to_excel('/mnt/data/roc_results.xlsx', index=False)

print("ROC曲线数据已存储到Excel文件中。")
/home/wagnchogn/anaconda3/envs/pytorch/bin/python /media/wagnchogn/data/lishuxin/_2_2403_sam/pre_code/second/1_SVM_ROC.py
Traceback (most recent call last):
  File "/media/wagnchogn/data/lishuxin/_2_2403_sam/pre_code/second/1_SVM_ROC.py", line 105, in <module>
    results.to_excel('/media/wagnchogn/data/01/second/excel/SVM_roc_results.xlsx', index=False)
  File "/home/wagnchogn/anaconda3/envs/pytorch/lib/python3.8/site-packages/pandas/util/_decorators.py", line 211, in wrapper
    return func(*args, **kwargs)
  File "/home/wagnchogn/anaconda3/envs/pytorch/lib/python3.8/site-packages/pandas/util/_decorators.py", line 211, in wrapper
    return func(*args, **kwargs)
  File "/home/wagnchogn/anaconda3/envs/pytorch/lib/python3.8/site-packages/pandas/core/generic.py", line 2374, in to_excel
    formatter.write(
  File "/home/wagnchogn/anaconda3/envs/pytorch/lib/python3.8/site-packages/pandas/io/formats/excel.py", line 944, in write
    writer = ExcelWriter(  # type: ignore[abstract]
  File "/home/wagnchogn/anaconda3/envs/pytorch/lib/python3.8/site-packages/pandas/io/excel/_openpyxl.py", line 56, in __init__
    from openpyxl.workbook import Workbook
ModuleNotFoundError: No module named 'openpyxl'

Process finished with exit code 1

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值