如何在pandas中按列对数据框进行分组，并在Json数组中获取所有其他列的数据？

import pandas as pd
import json

# 创建一个示例数据框
data = {'A': ['foo', 'bar', 'foo', 'bar', 'foo', 'bar', 'foo', 'foo'],
        'B': ['one', 'one', 'two', 'two', 'two', 'one', 'two', 'one'],
        'C': [1, 2, 3, 4, 5, 6, 7, 8],
        'D': [10, 20, 30, 40, 50, 60, 70, 80]}
df = pd.DataFrame(data)

# 按列'B'进行分组，并获取其他列的数据
grouped = df.groupby('B').apply(lambda x: x[['A', 'C', 'D']].to_dict('records')).reset_index(name='data')

# 将结果转换为JSON数组
result = grouped.to_json(orient='records')

print(result)

[{"B":"one","data":[{"A":"foo","C":1,"D":10},{"A":"bar","C":6,"D":60},{"A":"foo","C":8,"D":80}]},{"B":"two","data":[{"A":"foo","C":3,"D":30},{"A":"bar","C":4,"D":40},{"A":"foo","C":5,"D":50},{"A":"foo","C":7,"D":70}]}]