import numpy as np
import csv
file=open('test.csv')
reader=csv.reader(file)
with open('test.csv','w',newline='') as fp:
test_write=csv.writer(fp,delimiter=',',quotechar='"')
test_write.writerow(['数学','英语','数据库','概率论','线性代数'])
test_write.writerow([98,99,97,90,94])
fp.close()
with open('test.csv', newline='') as fp:
test_reader=csv.reader(fp,delimiter=',',quotechar='"')
for row in test_reader:
print (row)
list_row=list(reader)[1]
num=len(list_row)
sum=0
for i in list_row:
sum=sum+eval(i)
avg=sum/num
print('------------------')
print('总分:\n',sum)
print('------------------')
print('平均分:\n',avg)
fp.close()
代码比较臃肿,一开始读取的话,是可以正常读取的,但是无法计算总分和平均值,然后参考了百度经验:https://jingyan.baidu.com/article/454316abdd7ff4f7a7c03ab3.html
于是就按照这个方法把第二行数据生成list_row数组,然后再进行计算