擅长:python、mysql、java
<p>如果所有字符串的格式都相同,则可以使用regex和<a href="https://pandas.pydata.org/pandas-docs/version/0.21/generated/pandas.Series.str.extract.html" rel="nofollow noreferrer">^{<cd1>}</a>,如下所示:</p>
<pre><code>df['Frame'] = df['name'].str.extract(r"FR0(\d+)_STR").astype(int)
# class name Frame
# 0 a C-FRA_FRA-S18_FU_L_FUS_FR073_STR001-STR00 73
# 1 b C-FRA_FRA-S18_FU_L_FUS_FR074_STR010-STR011 74
</code></pre>