.gitattributes CHANGED
@@ -37,8 +37,3 @@ checkpoint-80000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
37
  checkpoint-72000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
38
  checkpoint-64000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
39
  checkpoint-76000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
40
- 202050516 filter=lfs diff=lfs merge=lfs -text
41
- 202050516/ filter=lfs diff=lfs merge=lfs -text
42
- 20250516/ filter=lfs diff=lfs merge=lfs -text
43
- 演示.pptx filter=lfs diff=lfs merge=lfs -text
44
- 二阶段同步会议0521.pptx filter=lfs diff=lfs merge=lfs -text
 
37
  checkpoint-72000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
38
  checkpoint-64000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
39
  checkpoint-76000/trainer_state.json filter=lfs diff=lfs merge=lfs -text
 
 
 
 
 
202050516 DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:7a85877ea711e7a9b7dd6621bcb90dd5d8cab94b4a026bce74acabf2943772c3
3
- size 187596800
 
 
 
 
20250427_test.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:c2d6638d460512d630515705b710c36e2b292ff391a335f90497fb738cacda93
3
- size 376770560
 
 
 
 
20250428/cluster_out_text_and_pic.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:cbeee08d3066723c68bfcd5af2c70451c9afd4b9f2048d1e0371902c3553c7c5
3
- size 36710400
 
 
 
 
20250428/llm_out_text_and_pic.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:1e7712f2a0785b0f0307658be5f1dad390df140827c952445829675d203d4bc9
3
- size 37396480
 
 
 
 
20250428/screenshot_file.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:3c3b76c4f6c82b66288fc614cc5325dc731eae7f219c77273aa8844d7a61d111
3
- size 36311040
 
 
 
 
20250428/win_rate_category_score_comparisonv2.csv DELETED
@@ -1,26 +0,0 @@
1
- category,type,dir1_avg,dir2_avg,comparison,subcategory
2
- 标牌标语,category,0.784,0.835,dir1 < dir2,
3
- 手机屏拍,category,0.871,0.913,dir1 < dir2,
4
- 电脑屏拍,category,0.844,0.882,dir1 < dir2,
5
- 商品包装,category,0.802,0.854,dir1 < dir2,
6
- 纸质文档,category,0.818,0.859,dir1 < dir2,
7
- 商品包装,subcategory,0.777,0.844,<,其他商品
8
- 手机屏拍,subcategory,0.859,0.894,<,网页
9
- 手机屏拍,subcategory,0.883,0.892,<,应用
10
- 手机屏拍,subcategory,0.873,0.925,<,系统
11
- 商品包装,subcategory,0.826,0.829,<,药品保健
12
- 电脑屏拍,subcategory,0.867,0.916,<,网页
13
- 标牌标语,subcategory,0.764,0.828,<,展板标语
14
- 电脑屏拍,subcategory,0.833,0.897,<,应用
15
- 电脑屏拍,subcategory,0.862,0.852,>,文件
16
- 电脑屏拍,subcategory,0.867,0.913,<,系统
17
- 商品包装,subcategory,0.808,0.874,<,食品饮品
18
- 商品包装,subcategory,0.795,0.868,<,美妆护肤
19
- 纸质文档,subcategory,0.819,0.857,<,试卷
20
- 纸质文档,subcategory,0.842,0.88,<,说明书
21
- 手机屏拍,subcategory,0.865,0.922,<,聊天
22
- 纸质文档,subcategory,0.76,0.812,<,菜单
23
- 手机屏拍,subcategory,0.878,0.931,<,提醒
24
- 纸质文档,subcategory,0.85,0.886,<,教材
25
- 电脑屏拍,subcategory,0.794,0.833,<,游戏
26
- 标牌标语,subcategory,0.805,0.842,<,路标路牌
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
20250428/win_rate_comparisonv2.csv DELETED
@@ -1,26 +0,0 @@
1
- category,subcategory,win_rate,wins,total_comparisons
2
- 商品包装,其他商品,0.1,1,10
3
- 手机屏拍,网页,0.1,1,10
4
- 手机屏拍,应用,0.2,2,10
5
- 手机屏拍,系统,0.1,1,10
6
- 商品包装,药品保健,0.4,4,10
7
- 电脑屏拍,网页,0.1,1,10
8
- 标牌标语,展板标语,0.4,4,10
9
- 电脑屏拍,应用,0.0,0,10
10
- 电脑屏拍,文件,0.2,2,10
11
- 电脑屏拍,系统,0.0,0,10
12
- 商品包装,食品饮品,0.0,0,9
13
- 商品包装,美妆护肤,0.1,1,10
14
- 纸质文档,试卷,0.1,1,10
15
- 纸质文档,说明书,0.2,2,10
16
- 手机屏拍,聊天,0.1,1,10
17
- 纸质文档,菜单,0.1,1,10
18
- 手机屏拍,提醒,0.0,0,10
19
- 纸质文档,教材,0.3,3,10
20
- 电脑屏拍,游戏,0.2,2,10
21
- 标牌标语,路标路牌,0.4,4,10
22
- 商品包装,ALL,0.15384615384615385,6,39
23
- 手机屏拍,ALL,0.1,5,50
24
- 电脑屏拍,ALL,0.1,5,50
25
- 标牌标语,ALL,0.4,8,20
26
- 纸质文档,ALL,0.175,7,40
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
20250516 DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:7a85877ea711e7a9b7dd6621bcb90dd5d8cab94b4a026bce74acabf2943772c3
3
- size 187596800
 
 
 
 
20250516.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:7ba58ededebd2263ead9fd7742bb3a92e0dc1083332dfb50bead1cd7d94538f0
3
- size 5898240
 
 
 
 
20250521.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:17d89300f53735a9de23a1097ff35da37b721dafc5f73629d208992a04202d47
3
- size 47646720
 
 
 
 
cluster_out_text_and_pic.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:cbeee08d3066723c68bfcd5af2c70451c9afd4b9f2048d1e0371902c3553c7c5
3
- size 36710400
 
 
 
 
data_zh_all.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:133324891cbefa3135e116ceae94913396f5c8441ca1d800be9c0e56e536213f
3
- size 67153920
 
 
 
 
llm_out_text_and_pic.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:1e7712f2a0785b0f0307658be5f1dad390df140827c952445829675d203d4bc9
3
- size 37396480
 
 
 
 
organized.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:46a1626c0f33a04d580f4c7daae25974d852478c552f874e0357d6047b961b25
3
- size 86579200
 
 
 
 
organized2.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:a7f6e6e0fe8571aace6ab07a85157775cc3cf987da184558ba85fab664421fcc
3
- size 86487040
 
 
 
 
organized_clusterv2.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:fee7217dd8d34fb34f2bc129d4c7e5409c2c788b2d954d0320a2533bb6360023
3
- size 187136000
 
 
 
 
organized_domain_labels.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:21072ebd840c8f56dad11b98f6ffd5b4426f6063754dc4de484b1d46cec9d04c
3
- size 187023360
 
 
 
 
screenshot_file.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:3c3b76c4f6c82b66288fc614cc5325dc731eae7f219c77273aa8844d7a61d111
3
- size 36311040
 
 
 
 
vs.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:55811c4bbcf6c7477b40e9475c3015c5ca023d9293a8d5db78248ddcd9bbe95e
3
- size 67768320
 
 
 
 
win_rate_category_score_comparison.csv DELETED
@@ -1,26 +0,0 @@
1
- category,type,dir1_avg,dir2_avg,comparison,subcategory
2
- 电脑屏拍,category,0.878,0.882,dir1 < dir2,
3
- 纸质文档,category,0.846,0.859,dir1 < dir2,
4
- 商品包装,category,0.839,0.854,dir1 < dir2,
5
- 标牌标语,category,0.832,0.835,dir1 < dir2,
6
- 手机屏拍,category,0.906,0.913,dir1 < dir2,
7
- 纸质文档,subcategory,0.884,0.88,>,说明书
8
- 纸质文档,subcategory,0.826,0.857,<,试卷
9
- 商品包装,subcategory,0.822,0.829,<,药品保健
10
- 电脑屏拍,subcategory,0.838,0.833,>,游戏
11
- 手机屏拍,subcategory,0.905,0.922,<,聊天
12
- 电脑屏拍,subcategory,0.894,0.916,<,网页
13
- 电脑屏拍,subcategory,0.877,0.897,<,应用
14
- 标牌标语,subcategory,0.825,0.828,<,展板标语
15
- 电脑屏拍,subcategory,0.879,0.852,>,文件
16
- 电脑屏拍,subcategory,0.903,0.913,<,系统
17
- 商品包装,subcategory,0.82,0.844,<,其他商品
18
- 纸质文档,subcategory,0.793,0.812,<,菜单
19
- 手机屏拍,subcategory,0.88,0.894,<,网页
20
- 手机屏拍,subcategory,0.898,0.892,>,应用
21
- 标牌标语,subcategory,0.84,0.842,<,路标路牌
22
- 商品包装,subcategory,0.864,0.868,<,美妆护肤
23
- 手机屏拍,subcategory,0.929,0.931,<,提醒
24
- 手机屏拍,subcategory,0.917,0.925,<,系统
25
- 纸质文档,subcategory,0.881,0.886,<,教材
26
- 商品包装,subcategory,0.851,0.874,<,食品饮品
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
win_rate_category_score_comparisonv2.csv DELETED
@@ -1,26 +0,0 @@
1
- category,type,dir1_avg,dir2_avg,comparison,subcategory
2
- 标牌标语,category,0.784,0.835,dir1 < dir2,
3
- 手机屏拍,category,0.871,0.913,dir1 < dir2,
4
- 电脑屏拍,category,0.844,0.882,dir1 < dir2,
5
- 商品包装,category,0.802,0.854,dir1 < dir2,
6
- 纸质文档,category,0.818,0.859,dir1 < dir2,
7
- 商品包装,subcategory,0.777,0.844,<,其他商品
8
- 手机屏拍,subcategory,0.859,0.894,<,网页
9
- 手机屏拍,subcategory,0.883,0.892,<,应用
10
- 手机屏拍,subcategory,0.873,0.925,<,系统
11
- 商品包装,subcategory,0.826,0.829,<,药品保健
12
- 电脑屏拍,subcategory,0.867,0.916,<,网页
13
- 标牌标语,subcategory,0.764,0.828,<,展板标语
14
- 电脑屏拍,subcategory,0.833,0.897,<,应用
15
- 电脑屏拍,subcategory,0.862,0.852,>,文件
16
- 电脑屏拍,subcategory,0.867,0.913,<,系统
17
- 商品包装,subcategory,0.808,0.874,<,食品饮品
18
- 商品包装,subcategory,0.795,0.868,<,美妆护肤
19
- 纸质文档,subcategory,0.819,0.857,<,试卷
20
- 纸质文档,subcategory,0.842,0.88,<,说明书
21
- 手机屏拍,subcategory,0.865,0.922,<,聊天
22
- 纸质文档,subcategory,0.76,0.812,<,菜单
23
- 手机屏拍,subcategory,0.878,0.931,<,提醒
24
- 纸质文档,subcategory,0.85,0.886,<,教材
25
- 电脑屏拍,subcategory,0.794,0.833,<,游戏
26
- 标牌标语,subcategory,0.805,0.842,<,路标路牌
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
win_rate_comparison.csv DELETED
@@ -1,26 +0,0 @@
1
- category,subcategory,win_rate,wins,total_comparisons
2
- 纸质文档,说明书,0.6,6,10
3
- 纸质文档,试卷,0.2,2,10
4
- 商品包装,药品保健,0.4,4,10
5
- 电脑屏拍,游戏,0.3,3,10
6
- 手机屏拍,聊天,0.1,1,10
7
- 电脑屏拍,网页,0.3,3,10
8
- 电脑屏拍,应用,0.4,4,10
9
- 标牌标语,展板标语,0.6,6,10
10
- 电脑屏拍,文件,0.7,7,10
11
- 电脑屏拍,系统,0.3,3,10
12
- 商品包装,其他商品,0.4,4,10
13
- 纸质文档,菜单,0.4,4,10
14
- 手机屏拍,网页,0.2,2,10
15
- 手机屏拍,应用,0.3,3,10
16
- 标牌标语,路标路牌,0.5,5,10
17
- 商品包装,美妆护肤,0.3,3,10
18
- 手机屏拍,提醒,0.4,4,10
19
- 手机屏拍,系统,0.1,1,10
20
- 纸质文档,教材,0.4,4,10
21
- 商品包装,食品饮品,0.3333333333333333,3,9
22
- 纸质文档,ALL,0.4,16,40
23
- 商品包装,ALL,0.358974358974359,14,39
24
- 电脑屏拍,ALL,0.4,20,50
25
- 手机屏拍,ALL,0.22,11,50
26
- 标牌标语,ALL,0.55,11,20
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
win_rate_comparisonv2.csv DELETED
@@ -1,26 +0,0 @@
1
- category,subcategory,win_rate,wins,total_comparisons
2
- 商品包装,其他商品,0.1,1,10
3
- 手机屏拍,网页,0.1,1,10
4
- 手机屏拍,应用,0.2,2,10
5
- 手机屏拍,系统,0.1,1,10
6
- 商品包装,药品保健,0.4,4,10
7
- 电脑屏拍,网页,0.1,1,10
8
- 标牌标语,展板标语,0.4,4,10
9
- 电脑屏拍,应用,0.0,0,10
10
- 电脑屏拍,文件,0.2,2,10
11
- 电脑屏拍,系统,0.0,0,10
12
- 商品包装,食品饮品,0.0,0,9
13
- 商品包装,美妆护肤,0.1,1,10
14
- 纸质文档,试卷,0.1,1,10
15
- 纸质文档,说明书,0.2,2,10
16
- 手机屏拍,聊天,0.1,1,10
17
- 纸质文档,菜单,0.1,1,10
18
- 手机屏拍,提醒,0.0,0,10
19
- 纸质文档,教材,0.3,3,10
20
- 电脑屏拍,游戏,0.2,2,10
21
- 标牌标语,路标路牌,0.4,4,10
22
- 商品包装,ALL,0.15384615384615385,6,39
23
- 手机屏拍,ALL,0.1,5,50
24
- 电脑屏拍,ALL,0.1,5,50
25
- 标牌标语,ALL,0.4,8,20
26
- 纸质文档,ALL,0.175,7,40
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
winrate.py DELETED
@@ -1,271 +0,0 @@
1
- import os
2
- import pandas as pd
3
- from collections import defaultdict
4
-
5
- def calculate_avg_comet(root_dir):
6
- results = []
7
-
8
- for category in os.listdir(root_dir):
9
- category_path = os.path.join(root_dir, category)
10
- if not os.path.isdir(category_path):
11
- continue
12
-
13
- for subcategory in os.listdir(category_path):
14
- subcategory_path = os.path.join(category_path, subcategory)
15
- if not os.path.isdir(subcategory_path):
16
- continue
17
-
18
- report_path = os.path.join(subcategory_path, 'report', 'full_image_comet.csv')
19
- if os.path.exists(report_path):
20
- try:
21
- df = pd.read_csv(report_path)
22
- avg_score = df['avg_comet_sentence'].mean()
23
- results.append({
24
- 'category': category,
25
- 'subcategory': subcategory,
26
- 'avg_comet': avg_score
27
- })
28
- except Exception as e:
29
- print(f"Error processing {report_path}: {e}")
30
-
31
- result_df = pd.DataFrame(results)
32
- result_df.to_csv('comet_avg_scores.csv', index=False)
33
- return result_df
34
-
35
- def compare_win_rate(dir1, dir2):
36
- data1 = defaultdict(dict)
37
- data2 = defaultdict(dict)
38
-
39
- # 读取第一个目录的数据
40
- for category in os.listdir(dir1):
41
- category_path = os.path.join(dir1, category)
42
- if not os.path.isdir(category_path):
43
- continue
44
-
45
- for subcategory in os.listdir(category_path):
46
- subcategory_path = os.path.join(category_path, subcategory)
47
- if not os.path.isdir(subcategory_path):
48
- continue
49
-
50
- report_path = os.path.join(subcategory_path, 'report', 'full_image_comet.csv')
51
- if os.path.exists(report_path):
52
- try:
53
- df = pd.read_csv(report_path)
54
- for _, row in df.iterrows():
55
- data1[(category, subcategory)][row['file_name']] = row['avg_comet_sentence']
56
- except Exception as e:
57
- print(f"Error processing {report_path}: {e}")
58
-
59
- # 读取第二个目录的数据
60
- for category in os.listdir(dir2):
61
- category_path = os.path.join(dir2, category)
62
- if not os.path.isdir(category_path):
63
- continue
64
-
65
- for subcategory in os.listdir(category_path):
66
- subcategory_path = os.path.join(category_path, subcategory)
67
- if not os.path.isdir(subcategory_path):
68
- continue
69
-
70
- report_path = os.path.join(subcategory_path, 'report', 'full_image_comet.csv')
71
- if os.path.exists(report_path):
72
- try:
73
- df = pd.read_csv(report_path)
74
- for _, row in df.iterrows():
75
- data2[(category, subcategory)][row['file_name']] = row['avg_comet_sentence']
76
- except Exception as e:
77
- print(f"Error processing {report_path}: {e}")
78
-
79
- # 计算win rate
80
- win_rate_results = []
81
- category_stats = defaultdict(lambda: {'wins': 0, 'total': 0})
82
-
83
- for key in set(data1.keys()).union(set(data2.keys())):
84
- category, subcategory = key
85
- scores1 = data1.get(key, {})
86
- scores2 = data2.get(key, {})
87
-
88
- common_files = set(scores1.keys()).intersection(set(scores2.keys()))
89
- if not common_files:
90
- continue
91
-
92
- wins = 0
93
- total = 0
94
-
95
- for file in common_files:
96
- total += 1
97
- if scores1[file] > scores2[file]:
98
- wins += 1
99
-
100
- win_rate = wins / total if total > 0 else 0
101
- win_rate_results.append({
102
- 'category': category,
103
- 'subcategory': subcategory,
104
- 'win_rate': win_rate,
105
- 'wins': wins,
106
- 'total_comparisons': total
107
- })
108
-
109
- # 更新大类统计
110
- category_stats[category]['wins'] += wins
111
- category_stats[category]['total'] += total
112
-
113
- # 添加大类统计结果
114
- for category, stats in category_stats.items():
115
- cat_win_rate = stats['wins'] / stats['total'] if stats['total'] > 0 else 0
116
- win_rate_results.append({
117
- 'category': category,
118
- 'subcategory': 'ALL',
119
- 'win_rate': cat_win_rate,
120
- 'wins': stats['wins'],
121
- 'total_comparisons': stats['total']
122
- })
123
-
124
- # 创建DataFrame并保存
125
- win_rate_df = pd.DataFrame(win_rate_results)
126
- win_rate_df.to_csv('win_rate_comparison.csv', index=False)
127
-
128
- # 打印统计数据
129
- print("\n=== 大类统计结果 ===")
130
- for category, stats in category_stats.items():
131
- win_rate = stats['wins'] / stats['total'] if stats['total'] > 0 else 0
132
- print(f"大类: {category}")
133
- print(f"总比较次数: {stats['total']}")
134
- print(f"获胜次数: {stats['wins']}")
135
- print(f"Win Rate: {win_rate:.2%}")
136
- print("-" * 30)
137
-
138
- return win_rate_df
139
- def compare_category_scores(dir1, dir2):
140
- """
141
- 比较两个目录中每个大类和子类的平均分数,并输出总结性比较
142
-
143
- 参数:
144
- dir1: 第一个目录路径
145
- dir2: 第二个目录路径
146
-
147
- 返回:
148
- DataFrame: 包含所有比较结果的DataFrame
149
- """
150
- # 收集两个目录的分数数据
151
- def collect_scores(directory):
152
- scores = defaultdict(lambda: {'total': 0, 'count': 0})
153
- sub_scores = defaultdict(lambda: {'total': 0, 'count': 0})
154
-
155
- for category in os.listdir(directory):
156
- category_path = os.path.join(directory, category)
157
- if not os.path.isdir(category_path):
158
- continue
159
-
160
- for subcategory in os.listdir(category_path):
161
- subcategory_path = os.path.join(category_path, subcategory)
162
- if not os.path.isdir(subcategory_path):
163
- continue
164
-
165
- report_path = os.path.join(subcategory_path, 'report', 'full_image_comet.csv')
166
- if os.path.exists(report_path):
167
- try:
168
- df = pd.read_csv(report_path)
169
- avg_score = df['avg_comet_sentence'].mean()
170
- # 更新大类统计
171
- scores[category]['total'] += avg_score
172
- scores[category]['count'] += 1
173
- # 更新子类统计
174
- sub_scores[(category, subcategory)]['total'] = avg_score
175
- sub_scores[(category, subcategory)]['count'] = 1
176
- except Exception as e:
177
- print(f"Error processing {report_path}: {e}")
178
-
179
- # 计算平均值
180
- for category in scores:
181
- if scores[category]['count'] > 0:
182
- scores[category]['avg'] = scores[category]['total'] / scores[category]['count']
183
-
184
- for key in sub_scores:
185
- if sub_scores[key]['count'] > 0:
186
- sub_scores[key]['avg'] = sub_scores[key]['total'] / sub_scores[key]['count']
187
-
188
- return scores, sub_scores
189
-
190
- # 收集两个目录的数据
191
- scores1, sub_scores1 = collect_scores(dir1)
192
- scores2, sub_scores2 = collect_scores(dir2)
193
-
194
- # 准备结果数据
195
- results = []
196
-
197
- # 比较大类
198
- all_categories = set(scores1.keys()).union(set(scores2.keys()))
199
- category_comparison = []
200
-
201
- for category in all_categories:
202
- avg1 = scores1.get(category, {}).get('avg', 0)
203
- avg2 = scores2.get(category, {}).get('avg', 0)
204
- comparison = "dir1 > dir2" if avg1 > avg2 else ("dir1 < dir2" if avg1 < avg2 else "dir1 == dir2")
205
-
206
- category_comparison.append({
207
- 'category': category,
208
- 'type': 'category',
209
- 'dir1_avg': round(avg1, 3),
210
- 'dir2_avg': round(avg2, 3),
211
- 'comparison': comparison
212
- })
213
-
214
- # 比较子类
215
- all_subcategories = set(sub_scores1.keys()).union(set(sub_scores2.keys()))
216
- subcategory_comparison = []
217
-
218
- for (category, subcategory) in all_subcategories:
219
- avg1 = sub_scores1.get((category, subcategory), {}).get('avg', 0)
220
- avg2 = sub_scores2.get((category, subcategory), {}).get('avg', 0)
221
- comparison = "dir1 > dir2" if avg1 > avg2 else ("dir1 < dir2" if avg1 < avg2 else "dir1 == dir2")
222
-
223
- subcategory_comparison.append({
224
- 'category': category,
225
- 'type': 'subcategory',
226
- 'subcategory': subcategory,
227
- 'dir1_avg': round(avg1, 3),
228
- 'dir2_avg': round(avg2, 3),
229
- 'comparison': comparison
230
- })
231
-
232
- # 合并结果
233
- results = category_comparison + subcategory_comparison
234
-
235
- # 创建DataFrame
236
- comparison_df = pd.DataFrame(results)
237
-
238
- # 总结性比较
239
- total_categories = len(all_categories)
240
- dir1_win_categories = sum(1 for c in category_comparison if c['comparison'] == 'dir1 > dir2')
241
- dir2_win_categories = sum(1 for c in category_comparison if c['comparison'] == 'dir1 < dir2')
242
-
243
- total_subcategories = len(all_subcategories)
244
- dir1_win_subcategories = sum(1 for c in subcategory_comparison if c['comparison'] == 'dir1 > dir2')
245
- dir2_win_subcategories = sum(1 for c in subcategory_comparison if c['comparison'] == 'dir1 < dir2')
246
-
247
- # 打印总结
248
- print("\n=== 总结性比较 ===")
249
- print(f"大类总数: {total_categories}")
250
- print(f"dir1获胜的大类数: {dir1_win_categories} ({dir1_win_categories/total_categories:.1%})")
251
- print(f"dir2获胜的大类数: {dir2_win_categories} ({dir2_win_categories/total_categories:.1%})")
252
- print(f"平局的大类数: {total_categories - dir1_win_categories - dir2_win_categories}")
253
-
254
- print(f"\n子类总数: {total_subcategories}")
255
- print(f"dir1获胜的子类数: {dir1_win_subcategories} ({dir1_win_subcategories/total_subcategories:.1%})")
256
- print(f"dir2获胜的子类数: {dir2_win_subcategories} ({dir2_win_subcategories/total_subcategories:.1%})")
257
- print(f"平局的子类数: {total_subcategories - dir1_win_subcategories - dir2_win_subcategories}")
258
-
259
- # 保存结果
260
- comparison_df.to_csv('category_score_comparison.csv', index=False)
261
- print("\n比较结果已保存到 category_score_comparison.csv")
262
-
263
- return comparison_df
264
- if __name__ == "__main__":
265
- print("Processing task 1...")
266
- avg_scores = calculate_avg_comet('organized_data_1')
267
- print("Average comet scores saved to comet_avg_scores.csv")
268
-
269
- print("\nProcessing task 2...")
270
- win_rate_df = compare_win_rate('organized_data_1', 'organized_data_2')
271
- print("\nWin rate comparison saved to win_rate_comparison.csv")
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
xhs0427.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:792c3a902acf3c9f112aa9d6c27cf710d970a4c57cdccb0fd61578da81bec59e
3
- size 974612480
 
 
 
 
zh_result.tar DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:012d0af1c5f182269b59ffce649e413b798eb6ac12b67be8a3eb086ffab3894d
3
- size 83384320
 
 
 
 
二阶段同步会议0521.pptx DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:dfad9748b34a4b5011bd1a7e075b3e3f7063504f2a6d2346ff9f7e625dc1ab04
3
- size 18422440
 
 
 
 
演示.pptx DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:a6d1908363bec5d5e0aaf2a50d1a5bf11975131a4329d08f09a551c670a0be38
3
- size 8505038