用两列相等的pandas-python连接两个df

Question

我得到了两个具有两个相似列但名称不同的df，我想用相似列连接它们

那是我的df

data={"col1":["A","B","D","f"],
"col2":[4,2,4,6],
"col3":[7,6,9,11],
"col4":[14,11,22,8],
"multi":[1.4,2.5,1.6,2.2]}
df1=pd.DataFrame.from_dict(data)
data2={"col5":["A","B","D","f"],
"col6":[345,55,44,16],
"col7":[4,7,4,6],
"col8":[1,5,3,9],
"multi_2":[2,2,4,9]}
df2=pd.DataFrame.from_dict(data2)

我想通过列["col1"、"col5"]来连接它们

它需要看起来像这样，但它可以用"；col5"；太

data3={"col1":["A","B","D","f"],
"col2":[4,2,4,6],
"col3":[7,6,9,11],
"col4":[14,11,22,8],
"multi":[1.4,2.5,1.6,2.2],
"col6":[345,55,44,16],
"col7":[4,7,4,6],
"col8":[1,5,3,9],
"multi_2":[2,2,4,9]}
df3=pd.DataFrame.from_dict(data3)
df3

Answer 1

df1.merge(df2, left_on='col1', right_on='col5').drop('col5', axis=1)