How to Apply Join Without a Common Column in Pandas
Free Pandas course with real-time 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'))
Your opinion matters
Please write your valuable feedback about DataFlair on Google