擅长:python、mysql、java
<p>使用左连接:</p>
<pre><code>df2 = pd.DataFrame(reads2, columns = ['ReadName', 'Sequence2', 'Qual2'])
df.merge(df2, on='ReadName')
</code></pre>
<p>看起来像:</p>
<pre class="lang-none prettyprint-override"><code> ReadName Sequence1 Qual1 Sequence2 Qual2
0 read1 ACTG FFFF TGTG F:FF
1 read2 TTTT FF:F AAAA FFFF
2 read3 ATGC F:FF CGCG F::F
</code></pre>