merge pandas
a1=pd.merge(dframe1,dframe2) #default merge inner join on some column
a=pd.merge(dframe1,dframe2,on='key') #inner join
b=pd.merge(dframe1,dframe2,on='key',how='left') #left join
c=pd.merge(dframe1,dframe2,on='key',how='outer') #outer join
d=pd.merge(df_left, df_right, on=['key1', 'key2'], how='outer') #on multiple keys
e=pd.merge(left, right, left_on='key1', right_on='key2') #choosing different columns for merging which dont have same name