我在下面給出的結(jié)構(gòu)中有一個(gè)字典，我需要將它轉(zhuǎn)換成一個(gè) Pandas Dataframe 來做一些聚合操作。但我無法將其轉(zhuǎn)換為給定的輸出格式{ "raj": [ { "subject": "science", "score": "35", "create_time": "1595990288421" }, { "subject": "maths", "score": "40", "create_time": "1595980800000" } ], "dev": [ { "subject": "science", "score": "23", "create_time": "1595990288421" } ], "mag":[ { "subject": "science", "score": "41", "create_time": "1595990288421" }, { "subject": "maths", "score": "25", "create_time": "1595980800000" } ]}我需要輸出數(shù)據(jù)幀為給定格式name subject score create_time------------------------------------------raj science 35 1595990288421raj maths 40 1595980800000dev science 23 1595990288421mag science 35 1595990288421mag maths 25 1595980800000誰能幫我把字典轉(zhuǎn)換成所需的數(shù)據(jù)幀輸出？
1 回答
慕雪6442864
TA貢獻(xiàn)1812條經(jīng)驗(yàn) 獲得超5個(gè)贊
使用列表理解
前任：
df = pd.DataFrame([{'name': k, ** j} for k, v in data.items() for j in v])
print(df)
輸出：
name subject score create_time
0 raj science 35 1595990288421
1 raj maths 40 1595980800000
2 dev science 23 1595990288421
3 mag science 41 1595990288421
4 mag maths 25 1595980800000
添加回答
舉報(bào)
0/150
提交
取消