擅长:python、mysql、java
<p>只需使用<code>replace</code></p>
<pre><code>replace_map = {
'[Q|q]uick[P|p]ay with [Z|z]elle payment to ': 'Payment to',
'[Q|q]uick[P|p]ay with [Z|z]elle payment from ': 'Payment from'
}
</code></pre>
<p>代码</p>
<pre><code>df.replace({'title': replace_map}, regex=True, inplace=True)
</code></pre>
<p>输出</p>
<pre><code>>>> df
title
0 QuickPay with Zelle payment to
1 quickPay with zelle payment to
2 quickpay with zelle payment to
3 QuickPay with Zelle payment from
4 Quickpay with zelle payment from
>>> replace_map = {
... '[Q|q]uick[P|p]ay with [Z|z]elle payment to ': 'Payment to',
... '[Q|q]uick[P|p]ay with [Z|z]elle payment from ': 'Payment from'
... }
>>> df.replace({'title': replace_map}, regex=True, inplace=True)
>>> df
title
0 Payment to
1 Payment to
2 Payment to
3 Payment from
4 Payment from
</code></pre>