LiuShen / 多xlsx互评结果中取平均
0 likes
0 forks
1 files
Last active 2 years ago
将互评的结果，去掉最高，去掉最低，保留中间部分并求平均数
| 1 | import openpyxl |
| 2 | import numpy as np |
| 3 | |
| 4 | # 定义数据范围 |
| 5 | data_range = "C5:R39" |
| 6 | |
| 7 | # 定义源文件名称数组 |
| 8 | source_files = ["./1.xlsx", "./2.xlsx", "./3.xlsx", "./4.xlsx", "./5.xlsx", "./6.xlsx", "./7.xlsx", "./8.xlsx", "./9.xlsx"] |
| 9 | |
| 10 | # 定义目标文件名称 |
Newer
Older