How to Use Join without a Common Column Name 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({'citizen':['rahul','vijay','amit'],'Salary in lakhs ':[23,33,28]})


# Outer Join
df3=pd.merge(df2,df1,left_on='citizen',right_on='empname',how='inner')
print(df1)
print("----------------------------------------")
print(df2)
print("-------------------------------------------")
print(df3)







# Outer Join
df3=pd.merge(df1,df2,left_on='empname',right_on='citizen',how='outer')
print(df1)
print("----------------------------------------")
print(df2)
print("-------------------------------------------")
print(df3)








# # Right Join
# df3=pd.merge(df1,df2,left_on='empname',right_on='citizen',how='right')
# print(df1)
# print("----------------------------------------")
# print(df2)
# print("-------------------------------------------")
# print(df3)








# # left Join
# df3=pd.merge(df1,df2,left_on='empname',right_on='citizen',how='left')
# print(df1)
# print("----------------------------------------")
# print(df2)
# print("-------------------------------------------")
# print(df3)


# # Inner Join
# df3=pd.merge(df1,df2,left_on='empname',right_on='citizen',how='inner')
# print(df1)
# print("----------------------------------------")
# print(df2)
# print("-------------------------------------------")
# print(df3)