我正在合并两个收件箱.第一个 pyramid 看起来是这样的:
A B C D
party1 asset1 product1 Buy
party1 asset1 product2 Sell
party2 asset2 product1 Buy
party2 asset2 product2 Sell
第二个相框看起来是这样的:
A B D
party1 asset1 Buy
party1 asset1 Sell
party2 asset2 Buy
party2 asset2 Sell
我像这样合并收件箱:
df2 = df.merge(df1, on=['A', 'B', 'D'])
返回:
A B D C
party1 asset1 Buy product1
party1 asset1 Sell product2
party2 asset2 Buy product1
party2 asset2 Sell product2
我需要用列"C"中的值替换列"B"中的值,同时保留相同的名称"B".
A B D
party1 product1 Buy
party1 product2 Sell
party2 product1 Buy
party2 product2 Sell
关于如何实现这一目标的任何建议都会有所帮助.