擅长:python、mysql、java
<pre><code>with open("reportForFergusTwo.csv", "r") as highScore:
subject = []
difficulty = []
score = []
name = []
for line in highScore:
subject.append(line.split(',')[0])
difficulty.append(line.split(',')[1])
score.append(line.split(',')[2])
name.append(line.split(',')[3])
ind = score.index(max(score)
print("The highest score for this quiz is: ", max(score))
print("This was achieved by ", name[ind])
</code></pre>
<p><code>with</code>打开(并将关闭)<code>.csv</code>文件。
然后,创建四个空列表。
接下来,我循环遍历文件中的每一行,并使用逗号作为分隔符拆分每一行。这将生成一个包含四个元素的列表,这些元素将附加到每个列表中。你知道吗</p>