如何使用python从dataframe中以每行的列名作为键来获取json。

import pandas as pd
import json

# 创建一个示例DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 将DataFrame转换为字典
df_dict = df.to_dict(orient='records')

# 遍历字典并获取JSON
json_data = []
for row in df_dict:
    json_row = {col: row[col] for col in df.columns}
    json_data.append(json_row)

# 将JSON数据打印出来
print(json.dumps(json_data, indent=4))

[
    {
        "Name": "Alice",
        "Age": 25,
        "City": "New York"
    },
    {
        "Name": "Bob",
        "Age": 30,
        "City": "London"
    },
    {
        "Name": "Charlie",
        "Age": 35,
        "City": "Tokyo"
    }
]