我有2个数据帧:
df1型:
branch sessions users
toledo 10 3
new york 14 2
boston 102 43
seattle 9 7
df2型:
branch guests
toledo 10
new york 14
boston 102
seattle 9
我要查找的结果将“guests”列从df2合并到df1,如下所示: df1型:
branch sessions users guests
toledo 10 3 10
new york 14 2 14
boston 102 43 102
seattle 9 7 9
我试过concat
、join
和merge
,但都不走运
与merge
guest_sessions = df2[['branch','guests']].copy()
pd.merge(df1, guest_sessions, left_index=True, right_index=True)
我明白了:
branch_x sessions users guests_x branch_y guests_y
我做错什么了
目前没有回答
相关问题 更多 >
编程相关推荐