擅长:python、mysql、java
<p>如果Strike始终为数字,则可以执行以下操作:</p>
<pre><code>posdf[['Symbol','Expiry','Strike','Type']] = posdf['tradingsymbol'].str.extract('^(\D+)(.{5})([0-9.]*)([a-zA-Z]{2,3})', expand=True)
</code></pre>
<p>结果:</p>
<pre><code> tradingsymbol Symbol Expiry Strike Type
0 XYZ2061820500PE XYZ 20618 20500 PE
1 XYZ20JUN21000PE XYZ 20JUN 21000 PE
2 ABC20JUN100CE ABC 20JUN 100 CE
3 ABC20JUN102.5PE ABC 20JUN 102.5 PE
4 ABC20JUN92.5PE ABC 20JUN 92.5 PE
4 XYZ20JUNFUT XYZ 20JUN FUT
</code></pre>