json转换为表格

import json
import csv

# 假设我们有以下JSON数据
json_data = '''
[
    {"name": "Alice", "age": 30, "city": "New York"},
    {"name": "Bob", "age": 25, "city": "Los Angeles"}
]
'''

# 解析JSON数据
data = json.loads(json_data)

# 打开一个CSV文件用于写入
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    fieldnames = data[0].keys()  # 获取字段名
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)

    writer.writeheader()  # 写入表头
    for row in data:
        writer.writerow(row)  # 写入数据行

import pandas as pd

# 假设有嵌套的JSON数据
nested_json_data = '''
[
    {"name": "Alice", "details": {"age": 30, "city": "New York"}},
    {"name": "Bob", "details": {"age": 25, "city": "Los Angeles"}}
]
'''

# 解析JSON数据
data = json.loads(nested_json_data)

# 使用Pandas将嵌套的JSON转换为DataFrame
df = pd.json_normalize(data, sep='_')

# 将DataFrame保存为CSV
df.to_csv('output_nested.csv', index=False)