擅长:python、mysql、java
<p>我想你需要<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.merge.html" rel="nofollow noreferrer">^{<cd1>}</a>和{a2}:</p>
<pre><code>print (pd.merge(oss, p1, left_on=['Stream','SeqNo'],
right_on=['StreamId','SeqNum'],how='left')
.drop(['StreamId','SeqNum'], axis=1))
OrderID Symbol Stream SeqNo Timestamp
0 5000000 AXBANK 3 1158 1.490250e+18
1 5000001 AXBANK 6 1733 NaN
2 5000002 AXBANK 6 1244 NaN
3 5000003 AXBANK 6 1388 NaN
4 5000004 AXBANK 3 1389 1.490250e+18
</code></pre>
<p>另一个具有<code>rename</code>列的解决方案:</p>
^{pr2}$