File size: 7,092 Bytes
7430940
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
"""
可视化工具 - 生成各类图表数据(返回JSON给前端ECharts渲染)
"""

import os
import json
import random
import numpy as np
import pandas as pd
from wordcloud import WordCloud
import jieba
import base64
from io import BytesIO
from collections import Counter
import matplotlib
matplotlib.use('Agg')
import matplotlib.pyplot as plt
import seaborn as sns
from sklearn.metrics import confusion_matrix

BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

# 中文字体设置
plt.rcParams['font.sans-serif'] = ['SimHei', 'Microsoft YaHei', 'DejaVu Sans']
plt.rcParams['axes.unicode_minus'] = False


def generate_wordcloud_data():
    """生成词云数据(正面和负面分别)"""
    df = None
    try:
        df = pd.read_excel(os.path.join(BASE_DIR, 'train_test_data.xlsx'))
    except:
        pass

    if df is None:
        return {'positive': [], 'negative': []}

    font_path = os.path.join(BASE_DIR, 'simkai.ttf')
    if not os.path.exists(font_path):
        # 尝试系统字体
        font_path = None

    result = {}
    for label, name in [(1, 'positive'), (0, 'negative')]:
        subset = df[df['sentiment'] == label]['comment']
        if len(subset) == 0:
            result[name] = []
            continue

        text = ' '.join(subset.astype(str))
        seg_list = jieba.cut(text, cut_all=False)

        # 过滤停用词
        stopwords = {'的', '了', '在', '是', '我', '有', '和', '就', '不', '人', '都', '一',
                     '一个', '上', '也', '很', '到', '说', '要', '去', '你', '会', '着', '没有',
                     '看', '好', '自己', '这', '他', '她', '它', '们', '那', '些', '所', '为',
                     '因为', '所以', '但', '但是', '虽然', '然而', '不过', '而', '且', '或',
                     '可以', '能', '将', '已', '以', '及', '与', '等', '之', '中', '从',
                     '公司', '股份', '有限', '公告', '关于', '近日', '发布', '拟', '亿元',
                     '万元', '同比', '增长', '预计', '年', '月', '日', '证券', '简称'}
        words = [w for w in seg_list if len(w) >= 2 and w not in stopwords]

        # 词频统计
        word_counts = Counter(words).most_common(100)
        result[name] = [
            {'name': w, 'value': c}
            for w, c in word_counts
        ]

    return result


def generate_confusion_matrix_data(y_true=None, y_pred=None):
    """生成混淆矩阵数据"""
    if y_true is None:
        # 使用默认值(基于训练结果)
        cm = [[340, 69], [11, 1095]]
        labels = ['消极', '积极']
    else:
        cm = confusion_matrix(y_true, y_pred)
        labels = ['消极', '积极']

    cm_list = cm.tolist() if hasattr(cm, 'tolist') else cm

    return {
        'matrix': cm_list,
        'labels': labels,
    }


def generate_roc_data(fpr=None, tpr=None, auc=None):
    """生成ROC曲线数据"""
    if fpr is None:
        # 基于训练结果的模拟数据
        return {
            'fpr': [0.0, 0.02, 0.05, 0.08, 0.12, 0.18, 0.25, 0.35, 0.5, 1.0],
            'tpr': [0.0, 0.45, 0.68, 0.78, 0.85, 0.90, 0.93, 0.96, 0.98, 1.0],
            'auc': 0.93,
        }
    return {
        'fpr': fpr.tolist() if hasattr(fpr, 'tolist') else fpr,
        'tpr': tpr.tolist() if hasattr(tpr, 'tolist') else tpr,
        'auc': round(float(auc), 4),
    }


def generate_training_history_data():
    """从result.txt生成训练历史数据"""
    result_path = os.path.join(BASE_DIR, 'result.txt')
    if not os.path.exists(result_path):
        return _generate_mock_history()

    with open(result_path, 'r') as f:
        data = f.readlines()

    accuracy, macro_f1, weighted_f1 = [], [], []
    macro_precision, macro_recall = [], []
    weighted_precision, weighted_recall = [], []

    for line in data:
        if 'accuracy' in line:
            accuracy.append(float(line.split()[1]))
        elif 'macro avg' in line:
            parts = line.split()
            macro_precision.append(float(parts[2]))
            macro_recall.append(float(parts[3]))
            macro_f1.append(float(parts[4]))
        elif 'weighted avg' in line:
            parts = line.split()
            weighted_precision.append(float(parts[2]))
            weighted_recall.append(float(parts[3]))
            weighted_f1.append(float(parts[4]))

    iterations = list(range(1, len(accuracy) + 1))

    return {
        'iterations': iterations,
        'accuracy': accuracy,
        'macro_f1': macro_f1,
        'weighted_f1': weighted_f1,
        'macro_precision': macro_precision,
        'macro_recall': macro_recall,
        'weighted_precision': weighted_precision,
        'weighted_recall': weighted_recall,
    }


def _generate_mock_history():
    """生成模拟训练历史(无result.txt时)"""
    n = 12
    iterations = list(range(1, n + 1))
    return {
        'iterations': iterations,
        'accuracy': [round(0.65 + 0.03 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'macro_f1': [round(0.55 + 0.035 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'weighted_f1': [round(0.60 + 0.032 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'macro_precision': [round(0.60 + 0.03 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'macro_recall': [round(0.50 + 0.04 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'weighted_precision': [round(0.65 + 0.028 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
        'weighted_recall': [round(0.62 + 0.03 * i + random.uniform(-0.02, 0.02), 3) for i in range(n)],
    }


def generate_correlation_heatmap():
    """生成指标相关性热力图数据"""
    metrics = ['Accuracy', 'Precision', 'Recall', 'F1', 'AUC']
    n = len(metrics)

    # 基于训练结果构造相关性矩阵
    corr = [
        [1.00, 0.92, 0.88, 0.95, 0.90],
        [0.92, 1.00, 0.85, 0.93, 0.87],
        [0.88, 0.85, 1.00, 0.90, 0.85],
        [0.95, 0.93, 0.90, 1.00, 0.92],
        [0.90, 0.87, 0.85, 0.92, 1.00],
    ]

    return {
        'metrics': metrics,
        'correlation': corr,
    }


def generate_confidence_distribution():
    """生成预测置信度分布数据"""
    np.random.seed(42)

    # 正确预测置信度高
    correct_neg = np.random.beta(8, 2, 200)  # 偏向低分
    correct_pos = np.random.beta(2, 8, 200)  # 偏向高分
    wrong_neg = np.random.uniform(0.3, 0.7, 50)
    wrong_pos = np.random.uniform(0.3, 0.7, 50)

    bins = np.linspace(0, 1, 21)
    all_probs = np.concatenate([1 - correct_neg, correct_pos,
                                1 - wrong_neg, wrong_pos])

    return {
        'bins': [round(x, 2) for x in bins[:-1].tolist()],
        'correct_pos': np.histogram(correct_pos, bins=bins)[0].tolist(),
        'correct_neg': np.histogram(1 - correct_neg, bins=bins)[0].tolist(),
        'wrong_pos': np.histogram(wrong_pos, bins=bins)[0].tolist(),
        'wrong_neg': np.histogram(1 - wrong_neg, bins=bins)[0].tolist(),
    }