擅长:python、mysql、java
<p>可以按如下方式应用“替换”两次:</p>
<pre><code>In [460]: df
Out[460]:
A B
0 Apple Med6g7867
1 Orange Med7g8976
2 Banana Signal
3 Peach Med8g8989
4 Mango Possible result %gggyy
In [461]: df.replace(r'Med\dg\d{4}', np.nan, regex=True).replace(r'\s+%.*', '', regex=True)
Out[461]:
A B
0 Apple NaN
1 Orange NaN
2 Banana Signal
3 Peach NaN
4 Mango Possible result
</code></pre>