擅长:python、mysql、java
<p>为了防止拆分不匹配(例如:<code>A_Fruit_100</code>),您可以<code>extract</code>然后<code>replace</code></p>
<pre><code>s = pd.Series(list1)
d = dict(zip(s.str.extract('('+'|'.join(df['col1'])+')',expand=False),s))
df['col22'] = df['col1'].replace(d)
</code></pre>
<hr/>
<pre><code>print(df)
col1 col22
Index
0 Img Img_A_10
1 Fruit Fruit_A_100
2 Img Img_A_10
3 Ball Ball_B_120
4 Ball Ball_B_120
5 Fruit Fruit_A_100
6 shirt shirt
7 Fruit Fruit_A_100
</code></pre>