How to Merge Two Data Frames Based on Particular Column in Pandas Python?
I Have to Merge Two Dataframes: Df1 Company, Standard Tata, A1 Cts, A2 Dell, A3 Df2 Company, Return Tata,71 Dell,78 Cts,27 Hcl,23 I Have to Unify Both...
I have to merge two dataframes:
df1
company,standard
tata,A1
cts,A2
dell,A3
df2
company,return
tata,71
dell,78
cts,27
hcl,23
I have to unify both dataframes to one dataframe. I need output like:
company,standard,return
tata,A1,71
cts,A2,27
dell,A3,78
3 Answers
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
I think we can also use
df1.merge(df2,on='Company')
In order to successfully merge two data frames based on common column(s), the dtype for common column(s) in both data frames must be the same! dtype for a column can be changed by:
df['commonCol'] = df['commonCol'].astype(int)
Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.
