如果我理解正确,这会解决你的问题
df1 = pd.DataFrame() df1["ID1"] = [np.nan, 1, np.nan, 3] df1["ID2"] =[np.nan, np.nan , 2, 3] df2 = pd.DataFrame() df2["ID"] = [1, 2, 3, 4] if df1["ID1"].equals(df1["ID2"]) == True: pass #do your merging here else: df1["ID1"],df1["ID2"] = df2["ID"],df2["ID"] df1
输出:
ID1 ID2 0 1 1 1 2 2 2 3 3 3 4 4