import pandas as pd
df1=pd.read_excel('input1.xlsx')
df2=pd.read_excel('input2.xlsx')
df1.columns=['name','information1','information2']
df2.columns=['name','information3','information4']
df3 = pd.merge(df1, df2, on="name", how="left")
df3.dropna(axis=0, how='any', inplace=True)
df3.to_excel('output.xlsx')
合并表一表二保留公共项
最新推荐文章于 2024-09-11 18:01:31 发布