我需要 Python pandas 數據框的幫助。我有以下格式的數據幀（請參閱當前數據幀），我的要求是轉換為不同格式的另一個數據幀，我已將其粘貼到下面（請參閱所需的數據幀）。任何人都可以幫助我如何實現所需的輸出。當前數據框Name1 Name2 ScoreBELFIUS INSURANCE BELFIUS INSURANCES 0.79BELFIUS INSURANCE BELFIUS 0.50BELFIUS INSURANCE BELFIUS T 0.31AIR PRODUCTS AIR PRODUCT 0.78AIR PRODUCTS AIR PRO 0.63AIR PRODUCTS PRODUCTS 0.39ARDAGH GLASS ARDAGH 0.60所需的數據框Name1 M1 Score1 M2 Score2 M3 Score3BELFIUS INSURANCE BELFIUS INSURANCES 0.79 BELFIUS 0.50 BELFIUS T 0.31AIR PRODUCTS AIR PRODUCT 0.78 AIR PRO 0.63 PRODUCTS 0.39ARDAGH GLASS ARDAGH 0.60 nan nan nan
1 回答
不負相思意
TA貢獻1777條經驗 獲得超10個贊
這本質上是按一列進行透視：
out_df = (df.assign(col=df.groupby('Name1').cumcount()+1)
.pivot_table(index='Name1', columns='col', aggfunc='first')
.swaplevel(0,1,axis=1)
.sort_index(axis=1)
)
out_df.columns = [f"{y}{x}" if y=="Score" else f"M{x}" for x,y in out_df.columns]
out_df = out_df.reset_index()
輸出：
Name1 M1 Score1 M2 Score2 M3 Score3
-- ----------------- ------------------ -------- ------- -------- --------- --------
0 AIR PRODUCTS AIR PRODUCT 0.78 AIR PRO 0.63 PRODUCTS 0.39
1 ARDAGH GLASS ARDAGH 0.6 nan nan nan nan
2 BELFIUS INSURANCE BELFIUS INSURANCES 0.79 BELFIUS 0.5 BELFIUS T 0.31
添加回答
舉報
0/150
提交
取消