我在用python写csv文件时遇到了一个问题。

import csv

with open('output.csv', 'w', encoding='utf-8', newline='') as file:
    writer = csv.writer(file)
    # 写入数据...

import csv

data = ['John', 'Doe', 'john.doe@example.com']

with open('output.csv', 'w', encoding='utf-8', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(data)

import csv

data = ['John', None, 'john.doe@example.com']

with open('output.csv', 'w', encoding='utf-8', newline='') as file:
    writer = csv.writer(file)
    writer.writerow([item if item else '' for item in data])

import csv

data = ['John', 'Doe', 'john.doe@example.com', 'Hello, "World"']

with open('output.csv', 'w', encoding='utf-8', newline='') as file:
    writer = csv.writer(file, escapechar='\\', quoting=csv.QUOTE_ALL)
    writer.writerow(data)