将json格式转换为结构化数据框架

Question

我有这个熊猫:

results = requests.request("POST", url, headers=headers, data=payload).json()
results
{‘ABC: {’26/03/2021': {‘A’: ‘1234’,
‘B’: ‘5678’},
'29/03/2021': {‘A’: ‘5555’,
‘B’: ‘6666’},
'30/03/2021': {‘A’: '44779',
‘B’: '10364'} } 

您想转换这个数据帧吗?

<表类>COLUMN1COLUMN2Btbody><<tr>ABC26/03/202112345678ABC29/03/202155556666ABC30/03/20214477910364

试试(results是你的字典从问题):

all_data = []
for k, v in results.items():
for kk, vv in v.items():
all_data.append({"COLUMN1": k, "COLUMN2": kk, **vv})
df = pd.DataFrame(all_data)
print(df)

打印:

COLUMN1     COLUMN2      A      B
0     ABC  26/03/2021   1234   5678
1     ABC  29/03/2021   5555   6666
2     ABC  30/03/2021  44779  10364

打印: