21/10/13 python csv:
import csv
import random
def complete():
return int(random.randint(0, 101))
csvFile1 = open('C:\\Users\\10551\\Desktop\\学生成绩.csv', 'r+', encoding='utf-8')
csvFile = csvFile1.readlines()
csvFile1.close()
f = open('C:\\Users\\10551\\Desktop\\学生成绩.csv', 'w', encoding='utf-8')
ss1 = 0
ss2 = 0
ss3 = 0
for i in range(0, len(csvFile), 1):
csvFile[i] = csvFile[i].split(',')
if csvFile[i][1] == '':
csvFile[i][1] = complete()
if csvFile[i][2] == '':
csvFile[i][2] = complete()
if csvFile[i][3] == '\n' or csvFile[i][3] == '':
csvFile[i][3] = complete()
ss1 += int(csvFile[i][1])
ss2 += int(csvFile[i][2])
ss3 += int(csvFile[i][3])
kk = int(csvFile[i][3])
avg = (int(csvFile[i][1]) + int(csvFile[i][2]) + int(csvFile[i][3])) / 3
avg = round(avg, 2)
ss = str(avg)
srr = str(csvFile[i][0]) + ',' + str(csvFile[i][1]) + ',' + str(csvFile[i][2]) + ',' + str(kk) + ',' + ss + '\n'
print(srr)
f.write(srr)
ss1 = ss1 / len(csvFile)
ss2 = ss2 / len(csvFile)
ss3 = ss3 / len(csvFile)
ssr2 = '均值,' + str(ss1) + ',' + str(ss2) + ',' + str(ss3) + '\n'
f.write(ssr2)