擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.extractall.html" rel="nofollow noreferrer">^{<cd1>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.apply.html" rel="nofollow noreferrer">^{<cd2>}</a>的单行程序</p>
<pre><code>df1[['column1', 'column2', 'column3']] = \
df1[['column1', 'column2', 'column3']].apply(
lambda x: x.astype(str).str.extractall(r'([0-9]+)')\
.reset_index(drop=True)[0])
</code></pre>