擅长:python、mysql、java
<p>可以使用pd.merge连接两个数据帧。假设您想加入<em>感觉</em>列,您可以使用:</p>
<pre><code>df= pd.merge(feelingsDF, countryDF, on='feeling', how='left')
</code></pre>
<p>有关pd.merge,请参见<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">documentation</a>,以了解如何使用on和how参数</p>
<pre><code>feelingsDF = pd.DataFrame([{'feeling':1,'count':10,'code':'X'},
{'feeling':2,'count':5,'code':'Y'},{'feeling':3,'count':1,'code':'Z'}])
feeling count code
0 1 10 X
1 2 5 Y
2 3 1 Z
countryDF = pd.DataFrame([{'feeling':1,'country':'US'},{'feeling':2,'country':'UK'},{'feeling':3,'country':'DE'}])
feeling country
0 1 US
1 2 UK
2 3 DE
df= pd.merge(feelingsDF, countryDF, on='feeling', how='left')
feeling count code country
0 1 10 X US
1 2 5 Y UK
2 3 1 Z DE
</code></pre>