python - 添加来自不同数据框的列中的值

Question

所以我有这两个数据框：

df1:
          No_One
0  Team_1   1 
1  Team_2   1   
2  Team_3   1

df2:
          No_Two
0  Team_1   2
1  Team_2   2
2  Team_3   2

当我尝试这样做时：

df2['No_Two'] = df1['No_One'] + df2['No_Two']
print(df2)

我得到：

df2:
          No_Two
0  Team_1   NaN
1  Team_2   NaN
2  Team_3   NaN

代替

df2:
          No_Two
0  Team_1   3
1  Team_2   3
2  Team_3   3

有谁知道问题是什么？提前致谢！

标签： pythonpandasdataframenull

Answer 1

尝试这个：

df2['No_Two'] = list(map(lambda x:int(x[0])+int(x[1]) ,zip(df1['No_One'],df2['No_Two']))
print(df2)