How to Apply Join Without a Common Column in Pandas
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!
Program 1
import pandas as pd
df1=pd.DataFrame({'empname':['Vivek','Rahul','Nilesh'],'Age':[43,38,27]})
df2=pd.DataFrame({'citizen':['Vivek','Rahul','Anurag'],'Salary(In Lakhs)':[20,16,19]})
#Inner Join
print("Inner Join")
print(pd.merge(df1,df2,left_on='empname',right_on='citizen',how='inner'))
#left Join
print("Left Join")
print(pd.merge(df1,df2,left_on='empname',right_on='citizen',how='left'))
#Right join
print("Right Join")
print(pd.merge(df1,df2,left_on='empname',right_on='citizen',how='right'))
#Outer Join
print("Outer Join")
print(pd.merge(df1,df2,left_on='empname',right_on='citizen',how='outer'))
Did you like this article? If Yes, please give DataFlair 5 Stars on Google
