擅长:python、mysql、java
<p>您需要的是<code>pd.merge</code>查看文档<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">here</a></p>
<pre><code>import pandas as pd
df1 = pd.DataFrame(
{'id': [1, 2, 3], 'link': ["google.com", "yahoo.com", "gmail.com"]})
df2 = pd.DataFrame({'id': [1, 2, 3, 4, 5, 6],
"link": ["linkedin.com","facebook.com","gmail.com","google.com","twitter.com","yahoo.com"],
"numberOfEmployees": [15,70,90,1000,155,2]})
df1.merge(df2, on="link", suffixes=('_left', '_right'))
</code></pre>
<pre><code>
| |id_left | link |id_right | numberOfEmployees|
| -| | | -| |
|0 |1 |google.com| 4 | 1000 |
|1 |2 |yahoo.com | 6 | 2 |
|2 |3 |gmail.com | 3 | 90 |
</code></pre>