df1 = pd.DataFrame({'name':['张三','李四','王五','张三'],'age':[18,19,20,18]})
df2 = pd.DataFrame({'name':['张三','李四','王五','张三'],'id':[300,260,280,300]})
df3 = pd.merge(df1,df2,on='name',how='left')
# print(df3)
df4 = df3.drop_duplicates()
# print(df4)
df4.index=list(range(df4.shape[0]))
# print(df4)
df1 df2
---------------------------------------------------------------------------------------------------------
df3 重建索引前的df4
---------------------------------------------------------------------------------------------------------
最终df4
