All New

Login

All gists

LiuShen / 从xlsx获取加权成绩

0 likes

0 forks

1 files

Last active 1725433447

将自评，互评，辅导员评分加权取平均，得到最终成绩

1	import openpyxl
2
3	# 定义数据范围
4	data_range = "C5:R39"
5
6	# 定义源文件名称数组
7	source_files = ["./自评总表.xlsx", "./互评总表.xlsx", "./辅导员评分.xlsx", "./最终总表.xlsx"]
8
9	# 打开所有源文件
10	workbooks = [openpyxl.load_workbook(file) for file in source_files]

LiuShen / 多xlsx互评结果中取平均

0 likes

0 forks

1 files

Last active 1725433464

将互评的结果，去掉最高，去掉最低，保留中间部分并求平均数

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

Powered by Opengist ⋅ Load: 52ms⋅

English

⋅ 个人主页 ⋅ 站长博客