python - 无法使用 writerrows 在 csv 文件中写入列表

Question

我尝试在 csv 文件中写入一些列表的内容，但不断收到错误。

我的代码是:

def saveLeague(csvLink, listOfLeague):
    '''clears the csv-file and replaces it with the stats from your list'''

    header = ['Team', 'GP', 'W', 'L', 'OTL', 'PTS', 'GF', 'GA', 'Plus minus', 'Division']
    sortLeague(listOfLeague)

    with open(csvLink, 'w') as csvFile:
        csvFile.truncate() #clear the csv file

        csvFile.writerows(header) #imput Team, GP, W, L and so on in row 1

        for team in listOfLeague:
            info = returnTeam(team) # info is a list of ints and str 
            csvFile.writerows(info)
    return

我收到的错误消息是

"AttributeError: '_io.TextIOWrapper' object has no attribute 'writerows'"

错误位于 csvFile.writerows(header) 行。

我在 Google 上搜索了很多，您应该能够使用 writerows 将列表输入到 csv 中，不是吗？

Answer 1

不完全是 - 你需要 the csv module对您的文件对象进行操作:

import csv 


csvLink = "t.txt"
header = ['Team', 'GP', 'W', 'L', 'OTL', 'PTS', 'GF', 'GA', 'Plus minus', 'Division']
info   = [ list(range(10)), list(range(10,20))] # some data

with open(csvLink, 'w', newline = "") as f:   # "w" already truncates, you need newline = ""

    csvFile = csv.writer(f)        # the module does the writing
    csvFile.writerow(header)       #  only writerow - not rows

    # no loop needed, write all of info
    csvFile.writerows(info)    # write all data

多库:

• csv.writer(...)

输出:

Team,GP,W,L,OTL,PTS,GF,GA,Plus minus,Division
0,1,2,3,4,5,6,7,8,9
10,11,12,13,14,15,16,17,18,19