如何在 Pandas 中拼接两个数据框？

Question

有两个数据框。

如何逐元素地连接？

您可以在此处查看代码。

df1 = pd.DataFrame(columns = ['string1', 'string2'])
df1.loc[len(df1), :] = ['Hello', 'This is Sam']
df1.loc[len(df1), :] = ['Good?', 'Are you free']

df2 = pd.DataFrame(columns = ['string1', 'string2'])
df2.loc[len(df2), :] = ['how are you?', 'from Canada']
df2.loc[len(df2), :] = ['morning', 'to have a talk?']

df1

  string1       string2
0   Hello   This is Sam
1   Good?  Are you free

df2

        string1          string2
0  how are you?      from Canada
1       morning  to have a talk?


#How to get the desired dataframe: [['Hello how are you?', 'This is Sam from Canada'], ['Good morning?', 'Are you free to have a talk?']]

- Chan

---

如何获取下一行：我看到两行？不是1。结果放在哪里？ - cs95

Answer 1

如果索引和列名相同，则可以使用以下任意一种DataFrame字符串连接操作。

df1 + ' ' + df2

              string1                       string2
0  Hello how are you?       This is Sam from Canada
1       Good? morning  Are you free to have a talk?

---

df1.add(' ').add(df2)

              string1                       string2
0  Hello how are you?       This is Sam from Canada
1       Good? morning  Are you free to have a talk?

---

df2.radd(df1.add(' '))

              string1                       string2
0  Hello how are you?       This is Sam from Canada
1       Good? morning  Are you free to have a talk?

- cs95