编辑csv文件Python 3将文件内容与打印输出匹配

Question

我在获取创建的csv文件的内容以显示为打印输出时遇到问题。你知道吗

代码：

import csv

with open('test.csv', 'w', newline='') as csvfile:
    filewriter = csv.writer(csvfile, delimiter=' ',
                            quotechar=',', quoting=csv.QUOTE_MINIMAL)
    filewriter.writerow(['Spam'] * 2 + ['Baked Beans'])
    filewriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

with open('test.csv', newline='') as csvfile:
     filereader = csv.reader(csvfile, delimiter=' ', quotechar=',')
     for row in filereader:
         print(', '.join(row))

输出：

Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam

test.csv文件：

Spam Spam ,Baked Beans,
Spam ,Lovely Spam, ,Wonderful Spam,

注意奇怪的逗号。

所需的test.csv内容

Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam

Answer 1

获取此输出的原因是使用逗号quotechar=','引用包含空格（分隔符）的字段。也就是说，您想要的是使用,作为分隔符，这是默认的delimiter value。你知道吗

import csv

with open('test.csv', 'w', newline='') as csvfile:
    filewriter = csv.writer(csvfile)
    filewriter.writerow(['Spam'] * 2 + ['Baked Beans'])
    filewriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

如果您想读取csv文件，同样的方法也适用。你知道吗