擅长:python、mysql、java
<p>使用轴</p>
<pre><code>df[['description', 'seq']] = df['description'].str.split(':', expand = True)
df.pivot('description', 'seq', 'sequence').add_prefix('Sequence_')
seq Sequence_A Sequence_B Sequence_C Sequence_D
description
AAAA AAAAAAAAAAA AAAAAAABBBBBB AAAAAAAACCCCCCC AAAAAAAADDDDDDD
BBBB BBBBBBAAAAA BBBBBBBBBBBBB None None
</code></pre>