代码如下:
with open("原始数据.csv","r") as f:
with open("工作簿2.csv","w") as F:
n = 1
for line in f:
if n!=1:
i = line.replace("\n","").split(",")
bmi = int(i[2]) / (float(i[1]) ** 2)
F.write(i[0]+","+str(bmi)+"\n")
print(bmi)
else:
i = line.replace("\n","").split(",")
F.write(i[0]+","+'bmi\n')
n = n+1
F.close()
f.close()
新文件如下
若有帮助,谢谢采纳~