如何合并两个数据帧基于特定的列在熊猫巨蟒？

我必须合并两个数据框架:

Df1

company,standard
tata,A1
cts,A2
dell,A3

Df2

company,return
tata,71
dell,78
cts,27
hcl,23

我必须将两个数据帧统一到一个数据帧。我需要输出如下:

company,standard,return
tata,A1,71
cts,A2,27
dell,A3,78

176658 次浏览

小开

最佳答案

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

小开

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)

小开

I think we can also use

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