在Python中将嵌套的Json文件转换为CSV文件

import json
import csv

with open('input.json', 'r') as json_file:
    data = json.load(json_file)

csv_data = []
for item in data:
    row = {
        'field1': item['field1'],
        'field2': item['field2'],
        'field3': item['nested']['field3'],
        'field4': item['nested']['field4']
    }
    csv_data.append(row)

[
    {
        "field1": "value1",
        "field2": "value2",
        "nested": {
            "field3": "value3",
            "field4": "value4"
        }
    },
    ...
]
请根据实际情况修改字段名和嵌套字段的访问路径。

4. 将数据写入CSV文件：
```python
fieldnames = ['field1', 'field2', 'field3', 'field4']
with open('output.csv', 'w', newline='') as csv_file:
    writer = csv.DictWriter(csv_file, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(csv_data)