擅长:python、mysql、java
<p>将<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.extract.html" rel="nofollow noreferrer">^{<cd1>}</a>与给定的<code>regex</code>模式一起使用:</p>
<pre><code>df1 = df['tradingsymbol'].str.extract(
r'(?P<expiry>\d{5}|\d{2}\w{3})(?P<strike>\d+(?:\.\d+)?)?(?P<type>\w+)')
df1 = df1[['strike', 'type', 'expiry']]
</code></pre>
<p>结果:</p>
<pre><code># print(df1)
strike type expiry
0 20500 PE 20618
1 21000 PE 20JUN
2 100 CE 20JUN
3 102.5 PE 20JUN
4 92.5 PE 20JUN
4 NaN FUT 20JUN
</code></pre>
<p>您可以测试regex<a href="https://regex101.com/r/ZJq1rV/4" rel="nofollow noreferrer">^{<cd3>}</a></p>