擅长:python、mysql、java
<p>试试这个:</p>
<pre><code>import pandas
df = pandas.read_csv('try.csv',sep=';')
df[['Label','Slabel']]=df['Label,Slabel'].str.split(',',expand=True)
df.drop(['Label,Slabel'],axis=1,inplace=True)
df.to_csv('try2.csv',sep=';')
</code></pre>
<p>但我使用多索引dataframe查看您的数据,因此我添加了以下内容:</p>
<pre><code>df.set_index(['Filename','Sentence_num'],inplace=True)
</code></pre>
<p>结果是:</p>
<pre><code>>>> df
Word POS Label Slabel
Filename Sentence_num
File_1 sentence:1 abc NNP B NO
sentence:1 fhj PSP O O
sentence:1 bmm NNP B NO
sentence:1 vbn PSS O O
File_2 sentence:2 vbb NNP B NO
sentence:2 bbn PSP B NO
sentence:2 nnm NNP O O
sentence:2 nnnm PSP B NO
>>>
</code></pre>
<p>简单地说,您可以像这样使用多重分隔符:</p>
<pre><code>import pandas as pd
df = pandas.read_csv('try.csv',sep=' |,', engine='python') # separator space and comma
</code></pre>