在python中创建csv文件时添加双引号

Question

import csv
with open('innovators.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(["SN", "Name", "Contribution"])
    writer.writerow([1, "Linus Torvalds", "Linux Kernel"])

我得到的输出：

SN, Name, Contribution
1, Linus Torvalds, Linux Kernel

我想要的输出：

SN, Name, Contribution
1, Linus Torvalds, "Linux Kernel"

所以，我试过

writer.writerow([1, "Linus Torvalds", "\"Linux Kernel\""])

但这只会让它变成：

1, Linus Torvalds, ""Linux Kernel""

我在python 3中使用代码，不确定如何让它输出带有双引号的单词

Answer 1

import csv
with open('innovators.csv', 'w', newline='') as file:
    writer = csv.writer(file,quotechar = "'")
    writer.writerow(["SN", "Name", "Contribution"])
    writer.writerow([1, "Linus Torvalds",'"Linux Kernel"' ])