Python:为 csv.DictWriter 设置引号？

Question

有没有办法为 csv.DictWriter() 字段名称设置一个 quotechar，类似于如何使用 csv.reader() 设置一个 quotechar？我对使用下面的 quote 变量定义的指定 quotechar 包围非数字字段名称条目特别感兴趣。

我想得到

    fieldnames = ['a', 'b', 'c', 'd', 'e']
    separator = ','
    quote = '"'
    table = [{'a': 10, 'c': 12, 'b': 11, 'e': 14, 'd': 13}]

    with open('output1.csv', 'w') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames = fieldnames, delimiter = separator)
        writer.writeheader()
        for row in table:
            writer.writerow(row)

输出

"a","b","c","d","e"
10,11,12,13,14

当 quote = '"' 而不是

a,b,c,d,e
10,11,12,13,14

Answer 1

import csv

fieldnames = ['a', 'b', 'c', 'd', 'e']
separator = ','
quote = '"'
table = [{'a': 10, 'c': 12, 'b': 11, 'e': 14, 'd': 13}]

with open('output1.csv', 'w') as csvfile:
    writer = csv.DictWriter(
        csvfile,
        fieldnames=fieldnames,
        delimiter=separator,
        quotechar=quote,
        quoting=csv.QUOTE_NONNUMERIC,
    )
    writer.writeheader()
    for row in table:
        writer.writerow(row)

我想你在找csv.QUOTE_NONNUMERIC