How to Apply Joins in Pandas

Program 1

# Advance Data Analysis 
#Join in DataFrame
import pandas as pd
df1=pd.DataFrame({'empname':['rahul','vijay','dipesh'],'Age':[45,43,54]})
df2=pd.DataFrame({'empname':['rahul','vijay','amit'],'Salary in lakhs ':[23,33,28]})

print(df1)
print("----------------------------------------")
print(df2)
print("-------------------------------------------")
# outer join (Full Join)
df3=pd.merge(df1,df2,on='empname',how='outer')
print(df3)

# right join
#df3=pd.merge(df1,df2,on='empname',how='right')

#left Join
# df3=pd.merge(df1,df2,on='empname',how='left')
# print(df3)

# print(df1)
# print(df2)

#inner Join

# df3=pd.merge(df1,df2)
# print(df3)
# print("------------------------------")

# df4=pd.merge(df1,df2,on='empname',how='inner')
# print(df4)


#print(type(df3))