python打开csv文件、计算总成绩_实现读取csv文件,文件里面是有限个百分数成绩(99.6、76.8等等...
該樓層疑似違規(guī)已被系統(tǒng)折疊?隱藏此樓查看此樓
實現(xiàn)讀取csv文件,文件里面是有限個百分數(shù)成績(99.6、76.8等等)導(dǎo)出GPA 和等級
==================================
代碼是這樣,但是報錯了,在score = float(sc)這行就報錯了,下面有沒有錯誤還不知道,大佬能幫看看嘛?
錯誤代碼:TypeError: 'float' object is not subscriptable
import pandas as pd
data = pd.read_csv("scores.csv")
grade = []
GPA = []
JD = (score-50)/10
GPA.append(JD)
sc = "%6.1f" % score
score = float(sc)
n = print(score)
for i in (1,n):
if score[i]>= 95:
grade = "A+"
elif score[i] >= 90:
grade = "A"
elif score[i] >= 85:
grade = "A-"
elif score[i] >= 82:
grade = "B+"
elif score[i] >= 78:
grade = "B"
elif score[i] >= 75:
grade = "B-"
elif score[i] >= 71:
grade = "C+"
elif score[i] >= 66:
grade = "C"
elif score[i] >= 62:
grade = "C-"
elif score[i] >= 60:
grade = "D"
else:
grade = "F"
grade.append(grade)
總結(jié)
以上是生活随笔為你收集整理的python打开csv文件、计算总成绩_实现读取csv文件,文件里面是有限个百分数成绩(99.6、76.8等等...的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: xmind思维导图(下载、使用——超级详
- 下一篇: IM应用中如何计算富文本的高度