擅长:python、mysql、java
<p>使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.join.html" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>df = df1.join(df2, on='accountname', how='inner').reset_index()
print (df)
ip accountname name gsm
0 192.168.1.1 aaaa john doe 850
1 192.168.1.2 bbbb jane doe 860
</code></pre>