在pandas json中添加一个更高一级的对象

Question

我是json和pandas的新手，并希望在以下模式中输出我的数据，但我不确定如何添加领先的'结果'。

我dataframe:

Name     Id    Qty   Value
thing1   123   10    12.5
thing2   456   20    15.4
thing3   789   40    84.2

我代码:

json_output = df.reset_index().to_json(orient='record')

Json输出:

[{"id":456,
"name":"thing2",
"qty":20,
"value":15.4
},
"id":123,
"name":"thing1",
"qty":10,
"value":12.4
},
"id":789,
"name":"thing3",
"qty":40
"value":84.2
}
]

我想要的Json模式:

results:
id:
name:
qty:
value:

Answer 1

试试这个:

import pandas as pd
import json
tmp = [('thing1', 123, 10, 12.5),
('thing2', 456, 20, 15.4),
('thing3', 789, 40, 84.2),
]
df = pd.DataFrame(tmp, columns=['Name', 'Id','Qty', 'Value'], )
df_dict = df.to_dict(orient='records')
final_dict = {'results': df_dict}
json_output = json.dumps(final_dict)