how to merge two data frames based on particular column in pandas python?

PythonPandasPython 2.7Merge

Python Problem Overview

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

Python Solutions

Solution 1 - Python

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 - Python

I think we can also use

df1.merge(df2,on='Company')

Solution 3 - Python

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)
Categories
Recommended Python Solutions
Recommended Pandas Solutions
Recommended Python 2.7 Solutions
Recommended Merge Solutions

Previous Solution:

How can I link/reference another reST file in the documentation?

Python SphinxRestructuredtextRead the-Docs

Next Solution:

Copy multiple directories with one command

DockerCopyDockerfile

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionSai RajeshView Question on Stackoverflow
Solution 1 - PythonjezraelView Answer on Stackoverflow
Solution 2 - PythonSwetank NandiView Answer on Stackoverflow
Solution 3 - PythonGood WillView Answer on Stackoverflow