擅长:python、mysql、java
<p>另一个版本使用<code>str.contains</code>,其中<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.select_dtypes.html" rel="nofollow noreferrer">^{<cd2>}</a>对象数据类型来自df和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.stack.html" rel="nofollow noreferrer">^{<cd3>}</a>列来执行str,最后包含<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.unstack.html" rel="nofollow noreferrer">^{<cd4>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.mask.html" rel="nofollow noreferrer">^{<cd5>}</a>:</p>
<pre><code>m=df.select_dtypes('O')
df[m.columns]=m.mask(m.stack(dropna=False).str.contains('abc123',na=False).unstack(),'test')
print(df)
</code></pre>
<hr/>
<pre><code> col_1 col_2
0 abc test
1 test 123
2 abc456 abc456
</code></pre>