擅长:python、mysql、java
<p>例如,您可以将除<code>bbbb2</code>之外的所有字符进行细分。你知道吗</p>
<pre><code>df = pd.DataFrame(data={"Col1": ["bbbb2"], "Col2": ["Hello I want to removebbbb2"]})
df["Col2"].str.replace("(?:\S*)?(bbbb2)(?:\S*)?", "\\1")
Out[29]:
0 Hello I want to bbbb2
Name: Col2, dtype: object
</code></pre>
<p>编辑:对于多行,例如</p>
<pre><code>import re
df = pd.DataFrame(data={"Col1": ["bbbb2", "aaaa1"], "Col2": ["Hello I want to removebbbb2", "Hello I want to remaaaa1"]})
df["out"] = df.apply(lambda x: re.sub("(?:\S*)?(" + x[0] + ")(?:\S*)?", "\\1", x[1]), axis=1)
df
Out[127]:
Col1 Col2 out
0 bbbb2 Hello I want to removebbbb2 Hello I want to bbbb2
1 aaaa1 Hello I want to remaaaa1 Hello I want to aaaa1
</code></pre>