擅长:python、mysql、java
<p>我们可以加载csv然后修复你的问题</p>
<pre><code>import io
t="""Apples, Pears
1, 2
3, 4
5, 6, 7"""
df = pd.read_csv(io.StringIO(t), sep='\t')
yourdf=df.iloc[:,0].str.split(', ',expand=True)
s=df.columns.str.split(', ').tolist()[0]
yourdf.columns=s+['unknow'+str(x+1) for x in range(yourdf.shape[1]-len(s))]
yourdf
Out[104]:
Apples Pears unknow1
0 1 2 None
1 3 4 None
2 5 6 7
</code></pre>