擅长: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/version/0.23.4/generated/pandas.core.groupby.DataFrameGroupBy.agg.html" rel="nofollow noreferrer">^{<cd2>}</a>:</p>
<pre><code>df['descriptions'] = (df['descriptions'].str.extractall('([a-zA_Z]+)')
.groupby(level=0).agg({0:' '.join}))
</code></pre>
<p>或:</p>
<pre><code>df['descriptions'] = (df['descriptions'].str.replace('\d+','')
.str.replace(' ',''))
</code></pre>
<p>或:</p>
<pre><code>df['descriptions'] = [' '.join(re.findall('[a-zA-Z]+',s)) for s in df['descriptions']]
</code></pre>
<hr/>
<pre><code>print(df)
id descriptions
0 0 kartu debit indomaretcipete r
1 1 tarikan atm
2 2 tarikan atm
3 3 biaya adm
4 4 trsf wsid indah lestari
</code></pre>