擅长:python、mysql、java
<p>您的第二种方法是在正确的轨道上-从那里迭代并分配列-类似这样:</p>
<pre><code>names = ['NUMBER', 'VALUE', 'Accepted', 'Company']
new_cols = df['STRING_COL'].str.split('^', expand=True)
for i, name in enumerate(names):
df[name] = new_cols[i]
df
Out[43]:
ID STRING_COL NUMBER VALUE Accepted \
0 ID2309480 #0809890 ^ True ^ ReP ^ APPLE #0809890 True ReP
1 ID2398403 #0938409 ^ True ^ POST ^ GOOGLE #0938409 True POST
2 ID0398240 #0938402 ^ True ^ POST ^ VERIZON #0938402 True POST
Company
0 APPLE
1 GOOGLE
2 VERIZON
</code></pre>