我在下面給出的結構中有一個字典，我需要將它轉換成一個 Pandas Dataframe 來做一些聚合操作。但我無法將其轉換為給定的輸出格式{ "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" } ]}我需要輸出數據幀為給定格式name subject score create_time------------------------------------------raj science 35 1595990288421raj maths 40 1595980800000dev science 23 1595990288421mag science 35 1595990288421mag maths 25 1595980800000誰能幫我把字典轉換成所需的數據幀輸出？
1 回答
慕雪6442864
TA貢獻1812條經驗 獲得超5個贊
使用列表理解
前任：
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
添加回答
舉報
0/150
提交
取消