擅长:python、mysql、java
<p>另一种方法是:</p>
<pre><code>df['RESULT'] = df.apply(lambda x: x['COD_METEL'].replace(x['SUFFIX'], ''), axis=1)
df
SUFFIX COD_METEL RESULT
0 CBR CBR8901027 8901027
1 CBR CBR8901028 8901028
2 CBR CBR8904001 8904001
3 CBR CBR8904002 8904002
4 CBR CBR8904008 8904008
5 CBR CBR8904027 8904027
6 CBR CBR8904039 8904039
7 THO THO96666290 96666290
8 THO THO96666294 96666294
9 THO THO96666298 96666298
10 THO THO96666302 96666302
11 THO THO96666322 96666322
12 THO THO96666326 96666326
13 ZV ZV111900NI 111900NI
14 ZV ZV111910NI 111910NI
15 ZX ZX2021.AC 2021.AC
16 ZX ZX2021.AC 2021.AC
17 ZX ZX6066.AC 6066.AC
18 ZX ZX6111.AC 6111.AC
19 ZX ZX6111.AC 6111.AC
20 ZX ZX6380.AC 6380.AC
21 ZX ZX9030 9030
22 ZX ZX9030 9030
23 ZX ZX9030 9030
24 ZZ ZZ00012565 00012565
</code></pre>