如何计算csv文件的平均值？

Question

我有一个csv文件，我可以把它导入程序。我需要知道如何计算文件特定列的平均值。在

Answer 1

import csv
with open('your_csv.csv', 'rb') as f:
    reader = csv.reader(f)
    if your_file_has_a_header_row:
        next(reader)
    the_numbers = [float(row[col_index_you_want]) for row in reader]
    average = sum(the_numbers) / len(the_numbers)

如果使用python3，请将with语句更改为

^{pr2}$