擅长:python、mysql、java
<p>有点像黑客:</p>
<pre><code>res = (df.assign(Expiry = df.tradingsymbol.str[3:8],
type = df.tradingsymbol.str[8:].str.split("([a-zA-Z]+)").str[1],
strike = df.tradingsymbol.str[8:].str.split("[a-zA-Z]+").str[0],
)
)
res
tradingsymbol Expiry type strike
0 XYZ2061820500PE 20618 PE 20500
1 XYZ20JUN21000PE 20JUN PE 21000
2 ABC20JUN100CE 20JUN CE 100
3 ABC20JUN102.5PE 20JUN PE 102.5
4 ABC20JUN92.5PE 20JUN PE 92.5
4 XYZ20JUNFUT 20JUN FUT
</code></pre>