Tweepy，如何正确格式化输出到csv文件？

import tweepy
import csv

# 假设你已经有了 Twitter API 的认证信息
consumer_key = 'your_consumer_key'
consumer_secret = 'your_consumer_secret'
access_token = 'your_access_token'
access_token_secret = 'your_access_token_secret'

# 认证并创建 API 对象
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)

# 打开 CSV 文件进行写入
with open('tweets.csv', 'w', newline='', encoding='utf-8') as file:
    writer = csv.writer(file)
    
    # 写入表头
    writer.writerow(['id', 'created_at', 'text'])
    
    # 获取并写入推文
    for tweet in tweepy.Cursor(api.search_tweets, q="Python", lang="en").items(10):
        writer.writerow([tweet.id, tweet.created_at, tweet.text])

print("数据已成功写入 tweets.csv 文件")

with open('tweets.csv', 'w', newline='', encoding='utf-8') as file:
    # 其他代码保持不变

with open('tweets.csv', 'w', newline='', encoding='utf-8') as file:
    writer = csv.writer(file, quotechar='"', quoting=csv.QUOTE_ALL)
    # 其他代码保持不变