Practical Implementation of Joins in Python Pandas

Program 1

import pandas as pd
df1=pd.DataFrame({'empname':['Vivek','Rahul','Amit'],'Age':[42,37,27]})
df2=pd.DataFrame({'empname':['Vivek','Rahul','Ravi'],'Salary(in Lakhs)':[20,29,15]})
#inner join
print("Result of Inner Join")
print(pd.merge(df1,df2,on='empname',how='inner'))

#left join
print("Result of Left Join")
print(pd.merge(df1,df2,on='empname',how='left'))
#right join
print("Result of Right Join")
print(pd.merge(df1,df2,on='empname',how='right'))
#full join
print("Result of Outer Join")
print(pd.merge(df1,df2,on='empname',how='outer'))