擅长:python、mysql、java
<p>您可以通过几个拆分调用来处理此问题:</p>
<pre><code>df = pd.DataFrame({'col': ['0020-004241 purple', '00532 - Blue',
'00121 - Yellow', '055 - Greem',
'0025-097 - Orange']})
df[['col1', 'col2']] = df['col'].str.split(n=1, expand=True)
df['col2'] = df['col2'].str.split().str[-1]
print(df)
col col1 col2
0 0020-004241 purple 0020-004241 purple
1 00532 - Blue 00532 Blue
2 00121 - Yellow 00121 Yellow
3 055 - Greem 055 Greem
4 0025-097 - Orange 0025-097 Orange
</code></pre>