擅长:python、mysql、java
<p>您可以创建两个函数,从列A中提取所需的元素并分配给列B和列C:</p>
<pre><code>def get_col_b(item):
if '-' in item:
return item.split('-')[0]
else:
return ''
def get_col_c(item):
if '-' in item:
return item.split('-')[1]
else:
return item
</code></pre>
<p>创建列,然后删除列A:</p>
<pre><code>df['COLUMN B'] = df['COLUMN A'].apply(get_col_b)
df['COLUMN C'] = df['COLUMN A'].apply(get_col_c)
cols = ['COLUMN B', 'COLUMN C']
df = df[cols]
</code></pre>
<p><a href="https://i.stack.imgur.com/Eshcm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Eshcm.png" alt="enter image description here"/></a></p>