擅长:python、mysql、java
<p>用给定的数据试试这个,使用regex'或'表达式进行拆分。按5位数或2位数拆分:</p>
<pre><code>df = pd.DataFrame(['BERGEPAINT20FEB550PE', 'BANKNIFTY2020631300CE', 'BANKNIFTY2020631300PE'], columns=list('A'))
df['StrikePrice'] = df.A.str.split('(\d{5}|\d{2})').str[-2]
df['CallPut'] = df.A.str[-2:]
df['Name'] = df.A.str.split('(\d+)').str[0]
print(df.head())
</code></pre>
<p>输出:</p>
<pre><code> A StrikePrice CallPut Name
0 BERGEPAINT20FEB550PE 55 PE BERGEPAINT
1 BANKNIFTY2020631300CE 31300 CE BANKNIFTY
2 BANKNIFTY2020631300PE 31300 PE BANKNIFTY
</code></pre>