python获取表格中平均数，极值和中位数

#%%用来进行文本信息的统计
import xlrd
readbook = xlrd.open_workbook(r'.\\评价数据.xlsx')
sheet = readbook.sheet_by_index(0)#索引的方式，从0开始
def midd(data):
    data.sort()
    mid = len(data) / 2
    if len(data) % 2 == 0:
        median = (data[int(mid - 1)] + data[int(mid)]) / 2.0
    else:
        median = data[int(mid)]
    return median
#文本信息的统计
avg=[]
max_v = []
mid_v = []
for i1 in range(0,10):
    lng = sheet.col_values(i1)#获取列内容#获取i行3列的表格值
    while '' in lng:
       lng.remove('')
    mach = []
    kywd = []
    rtnd = []
    
    for i2 in range(1,len(lng)):
        i2=lng[i2]
        i2=i2[1:-1]
        i2=i2.split(',')
        mach.append(int(i2[0]))
        kywd.append(int(i2[1]))
        rtnd.append(int(i2[2])/5)
    avg.append([sum(mach)/len(mach),sum(kywd)/len(kywd),sum(rtnd)/len(rtnd)])
    max_v.append([max(mach),max(kywd),max(rtnd)])
    mid_v.append([midd(mach),midd(kywd),midd(rtnd)])