在csv的单独行中写入json数据

import csv

data = [
    {"name": "John", "age": 30},
    {"name": "Alice", "age": 25},
    {"name": "Bob", "age": 35}
]

csv_file = open('data.csv', 'w', newline='')
csv_writer = csv.writer(csv_file)
csv_writer.writerow(['name', 'age'])  # 写入表头

for item in data:
    csv_writer.writerow([item['name'], item['age']])

csv_file.close()

import csv
import json

data = {
    "name": "John",
    "age": 30,
    "city": "New York"
}

csv_file = open('data.csv', 'w', newline='')
csv_writer = csv.writer(csv_file)

# 将json对象转换成字符串并写入csv文件
csv_writer.writerow([json.dumps(data)])

csv_file.close()