pandas取并集求差

Question

取两个df中两个name相同的差值，得出一个新的df，排序name获取的苹果变化趋势

 

Answer 1

import pandas as pd

if __name__ == '__main__':
    dfOne = pd.read_excel("1.xlsx")
    dfTwo = pd.read_excel("2.xlsx")
    dfTotal = dfOne.merge(dfTwo, how='inner', on='build_name')
    dfTotal['avg_price_diff'] = dfTotal['avg_price_x'] - dfTotal['avg_price_y']
    # 列名修改
    # dfTotal.rename(columns={'avg_price_x': 'A价格', 'avg_price_y': 'B价格'}, inplace=True)
    # 导出
    # dfTotal.to_excel("3.xlsx", index=False)
    print(dfTotal)