擅长:python、mysql、java
<p>第一个索引“id”:</p>
<pre><code>sequels_fin = sequels_fin.set_index('id')
</code></pre>
<p>之后:</p>
<pre><code>orig_seq = sequels_fin.merge(sequels_fin, how='inner', left_on='sequel',
right_on='id', right_index=True,
suffixes=('_org','_seq'))
</code></pre>