csv文件中求出各科最大值、最小值、平均值和方差

[王宝龙]

import numpy as np
import pandas as pd
p="score.csv"
data=pd.read_csv(p)
a,b=data.shape
for columns in range(3,b):
    ClassName=list(data.columns.values)[columns]
    print("科目：",ClassName,"的平均分为：%.2f"%data[f"{ClassName}"].mean())
print('_'*20)
for columns in range(3,b):
    ClassName=list(data.columns.values)[columns]
    print("科目：",ClassName,"的最大值为：",data[f"{ClassName}"].max())
print('_'*20)
for columns in range(3,b):
    ClassName = list(data.columns.values)[columns]
    print("科目：",ClassName,"的最小值为：",data[f"{ClassName}"].min())
print('_'*20)
for columns in range(3,b):
    ClassName = list(data.columns.values)[columns]
    print("科目：",ClassName,"的标准差为：","方差为：",data[f"{ClassName}"].std(),data[f"{ClassName}"].std()**2)
print('_'*20)