Join Dataframes By Column Values Pandas

I have two data frames df1 and df2 taken from different databases. Each item in the dataframes is identified by an id. df1 = pd.DataFrame({'id':[10,20,30,50,100,110],'cost':[100,0,

Solution 1:

I think you can use merge, default parameter how='inner' is omited:

print (pd.merge(df1,df2,on='id'))
   cost   id name
0   100   10    a
1   300   30    j
2   400  100    k
3   140  110    g