Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.

Closed 11 years ago.

我确实再次 st。

就我的工作而言,问题是

减去从3份CSV档案中得出的实地[年]价值47美元。

ok! 但是,在我使用“SUM”职能时,现在就出现了错误。

我的法典是这样说的。

import csv
myFile = csv.reader(open( 3028571a.csv , newline=  ), delimiter= , , quotechar= | )

next(myFile)

for record in myFile:
   records = int(record[0])
   if records < 47:
        sum(records)
        print(records)

如同5个记录,但错误一得到

类型:无物体

......任何建议? 我必须思考一下由此而来的理由。

Answer 1

甲 Python已经拥有极好的CSV教区,处理各种划界器、越狱等。它称作csv.reader,并在csv模块中注明。您可使用以下方法:

sum(int(row[0]) for row in csv.reader(open(f, "rb")) for f in files if int(row[0]) < 47)

当然,这还不是真正做家务——它只是利用沙尔的内在工具为你做。如果你想这样做的话,你必须人工阅读文件的每一条线,根据分离者进行分类,可能会在引文中引起对 com泥的担忧(这应当算作mas)。

Answer 2

http://docs.python.org/library/csv.html

基本上,你通过校对机处理文件,然后你可以整整行。

3. 也许与下列内容大致相同的是:

import csv
import sys

agecol = 1
namecol = 0
agelimit = 47

def sum_ages(files):
    agesum = 0
    for f in files:
        with open(f,  r ) as fp:
            reader = csv.reader(fp)
            for row in reader:
                age = int(row[agecol])
                name = row[namecol]
                if age < agelimit:
                    print  Adding %s s age (%d)  % (name, age)
                    agesum += age
                else:
                    print  Skipping %s s age (%d)  % (name, age)

    print  Sum of Ages < %d: %d  % (agelimit, agesum)

友情链接