csv文件的目录操作

#读
def read(al):
    with open("11.csv","r")as f:
        for r in f:
            al.append(r.rstrip("\n").split(","))
        al[0].append("平均数")
#加平均数排序
# def avg(al):
#     a=[]#创建个新列表将csv文件中的信息添加到a列表中
#     for i in al[1:len(al)]:
#         a.append(i)
#         count1 = 0  # 计数器
#     for j in a:
#         s = 0
#         count = 0#计数器1
#         #获取平均数
#         for k in j[1:len(j)]:
#             count = count + 1
#             s=s+float(k)
#         aver=round(s/count,1)
#         #获取添加平均数位置
#         count1=count1+1#计数器2
#         b=count1-1
#         a[b].append(aver)
#
#     a.sort(key=lambda x:x[-1],reverse=True)
#     al[1:len(al)]=a

# def avg(al):
#     for i in range(len(al[1:])):
#         sum = 0
#         for j in range(len(al[i + 1][1:])):
#             sum += float(al[i + 1][j + 1])
#             average = sum / (j + 1)
#         al[i + 1].append("%.2f" % average)
#     al.sort(key=lambda x: x[-1], reverse=True)


def avg(al):
    a=len(al[1:])
    for i in range(a):
        sum = 0
        b=len(al[i + 1][1:])
        for j in range(b):
            c=al[i + 1][j + 1]
            sum += float(c)
            aver = sum / (j + 1)
        al[i + 1].append("%.2f" % aver)
    al.sort(key=lambda x: x[-1], reverse=True)




#输出
def out(al):
    with open("out.csv", "w") as f:
        for n in al:
            f.write(",".join(map(str,n))+"\n")
        print(al)
al=[]
read(al)
avg(al)
out(al)