尝试在数学公式中使用文件中的数据

Question

我不确定这个代码有什么问题。它应该允许我在数学方程中使用来自fitnessfile.csv的数据。这是我的密码：

 import csv 
 csvfile = file.open("fitness file.csv")
 readcsv = csv.reader(csvfile, delimiter=",")

 genders = []

 for row in readcsv:
     print (row)
     gender = row[3]

    genders.append(gender)

如果你有更好或更简单的方法来使用数学方程中的文件数据，那么请告诉我。当我运行这个代码时，它说

NameError: name 'file' is not defined

file在第二行代码中

Answer 1

我没有测试，但考虑到：

import csv 
with open("fitness file.csv") as csvfile:
    readcsv = csv.reader(csvfile, delimiter=",")
    genders = []
    for row in readcsv:
        print (row)
        gender = row[3]
        # you will probably need to convert 'gender' to float 
        # with float(gender) to use in arithmetic, which I *think* is the question
        genders.append(gender)