how to merge two data frames based on particular column in pandas python?
Solution 1:
Use merge:
print (pd.merge(df1, df2, on='company'))
Sample:
print (df1)
company standard
0 tata A1
1 cts A2
2 dell A3
print (df2)
company return
0 tata 71
1 dell 78
2 cts 27
3 hcl 23
print (pd.merge(df1, df2, on='company'))
company standard return
0 tata A1 71
1 cts A2 27
2 dell A3 78
Solution 2:
I think we can also use
df1.merge(df2,on='Company')