擅长:python、mysql、java
<p>您有一个逗号分隔值(csv)文件。使用<code>csv</code>模块。你知道吗</p>
<pre><code>import csv
data = []
with open("state_meet.txt") as f:
reader = csv.DictReader(f, fieldnames=["school", "participant", "score"])
for line in reader:
data.append(line)
# first place
record = max(data, lambda d: d["score"])
best_score = int(record["score"])
# last place
record = min(data, lambda d: d["score"])
worst_score = int(record["score"])
# Mean score
mean = sum(d["score"] for d in data) / len(data)
# Median score
median = sorted([d["score"] for d in data])[(len(data) - 1) // 2]
</code></pre>
<p><a href="https://docs.python.org/3/library/csv.html#csv.DictReader" rel="nofollow">^{<cd2>}</a>读取csv文件中的行,并自动将每一行转换为一个字典,由您喜欢的任何内容键入。这可能比dokelung答案中的<code>collections.namedtuple</code>建议更容易理解,尽管<code>namedtuple</code>同样有效。这里的关键是我们可以保持完整的记录,而不是丢掉一切,除了分数。你知道吗</p>