使用Python将复杂的JSON转换为CSV可以通过以下步骤实现:
import json
import csv
with open('data.json', 'r') as json_file:
data = json.load(json_file)
# 假设JSON数据的结构为{"key1": "value1", "key2": "value2", ...}
# 可以根据实际情况进行调整
rows = []
for item in data:
row = [item['key1'], item['key2'], ...]
rows.append(row)
with open('output.csv', 'w', newline='') as csv_file:
writer = csv.writer(csv_file)
writer.writerow(['Column1', 'Column2', ...]) # 写入CSV文件的列名
writer.writerows(rows) # 写入数据行
完整的代码示例:
import json
import csv
with open('data.json', 'r') as json_file:
data = json.load(json_file)
rows = []
for item in data:
row = [item['key1'], item['key2'], ...]
rows.append(row)
with open('output.csv', 'w', newline='') as csv_file:
writer = csv.writer(csv_file)
writer.writerow(['Column1', 'Column2', ...])
writer.writerows(rows)
这样,复杂的JSON数据就会被转换为CSV格式的文件。你可以根据实际情况调整代码中的字段名和文件名。
领取专属 10元无门槛券
手把手带您无忧上云