如何将两个不同excel文件中的特定数据与Panda组合

Question

如何使用panda将链接从file2.xlsx转移到file1.xlsx中的匹配名称？

file1.xlsx

0 Names Ratings Links
1 Joe   10
2 Jack  7
3 Jim   8

文件2.xlsx

Names Links
0 Jim   example.com/32145
1 Joe   example.com/35235
2 Jack  example.com/90234

新文件1.xlsx

Names Ratings Links
0 Joe   10      example.com/35235
1 Jack  7       example.com/90234
2 Jim   8       example.com/32145

Answer 1

如果您的第一个数据帧包含Links列，则需要删除它：

df1.drop('Links', axis=1, inplace=True)

然后，

new_df = df1.merge(df2, on='Names')

输出：

>>> new_df
Names  Ratings              Links
0   Joe       10  example.com/35235
1  Jack        7  example.com/90234
2   Jim        8  example.com/32145