在PYTHON中将基于行的JSON转换为基于列的JSON

import pandas as pd
import json

# 基于行的JSON数据
row_json = '''
[
    {
        "name": "Alice",
        "age": 25,
        "city": "New York"
    },
    {
        "name": "Bob",
        "age": 30,
        "city": "San Francisco"
    },
    {
        "name": "Charlie",
        "age": 35,
        "city": "London"
    }
]
'''

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

# 转换为DataFrame
df = pd.DataFrame(data)

# 将基于行的JSON转换为基于列的JSON
column_json = df.to_json(orient='records')

# 打印结果
print(column_json)

[{"name":"Alice","age":25,"city":"New York"},{"name":"Bob","age":30,"city":"San Francisco"},{"name":"Charlie","age":35,"city":"London"}]