擅长:python、mysql、java
<p>由于有两列,第二列的字数可变,因此需要将其作为常规文件读取,然后将第二列与最后一列合并</p>
<pre><code>id = []
Name = []
year = []
Age = []
Score = []
with open('data.txt') as f:
text = f.read()
lines = text.split('\n')
for line in lines:
if len(line) < 3: continue
words = line.split()
id.append(words[0])
Name.append(' '.join(words[1:-3]))
year.append(words[-3])
Age.append(words[-2])
Score.append(words[-1])
df = pd.DataFrame.from_dict({'id': id, 'Name': Name,
'year': year, 'Age': Age, 'Score': Score})
</code></pre>
<p>编辑:您已经发布了总体数据,因此我将更改我的答案以适应它</p>