擅长:python、mysql、java
<p>下面是一种使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.findall.html" rel="nofollow noreferrer">^{<cd1>}</a>并将结果列表与<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.join.html" rel="nofollow noreferrer">^{<cd2>}</a>连接起来的方法:</p>
<pre><code>df['Missed Trades'].str.findall(r'(\d{4})').str.join('.')
0 4945.4170
1 4953.2878
2 4951.1387
3 4945.1350
4 4940.2211
5 4940.3961
6 4933.1707
7 4932.0696
Name: MissedTrades, dtype: object
</code></pre>