擅长:python、mysql、java
<p>假设您不想要的部分(“20FEB”、“20206”、“20206”)都以<code>20</code>开头,并且由5个字符组成,那么您可以使用:</p>
<pre><code>df = pd.DataFrame(['BERGEPAINT20FEB550PE', 'BANKNIFTY2020631300CE', 'BANKNIFTY2020631300PE'], columns=list('A'))
df['Toto'] = df.A.apply(lambda x: x[:x.index("20")])
df['StrikePrice'] = df.A.apply(lambda x: x[x.index("20")+5:-2])
df['CallPut'] = df.A.str[-2:]
print(df)
</code></pre>
<p>输出:</p>
<pre><code> A Toto StrikePrice CallPut
0 BERGEPAINT20FEB550PE BERGEPAINT 550 PE
1 BANKNIFTY2020631300CE BANKNIFTY 31300 CE
2 BANKNIFTY2020631300PE BANKNIFTY 31300 PE
</code></pre>