Opengist Logo 清羽飞扬の代码片段

Explore

  • All gists
  • Topics
  • Users
个人主页 站长博客
Give feedback on the new UI Powered by Opengist ⋅ 22ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login Register
LiuShen

LiuShen

Joined 2 years ago

All gists 41 Liked 3
Recently created Least recently created Recently updated Least recently updated
LiuShen

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

Last active 3 months ago

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

0 0 1
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