with open('file.txt', 'r') as f:
lines = f.readlines()
students = []
student = {}
for line in lines:
if ':' in line:
student['id'] = line.split(':')[0]
elif 'name' in line:
student['Name'] = line.split('=')[1].replace('\n','')
elif 'Age' in line:
student['Age'] = line.split('=')[1].replace('\n','')
elif 'Grade' in line:
student['Grade'] = line.split('=')[1].replace('\n','')
students.append(student)
print(student)
student = {}
import pandas as pd
df = pd.DataFrame(students)
df.to_excel("output.xlsx")
print(df)
我总是用这个词来形容这样的工作。使用“替换”,搜索段落标记并将其替换为制表符
例如,将
:[paragraph mark][space][space][space][space]name=
替换为[tab character]
。这样你就可以扔掉所有的垃圾,最终得到0000[tab character]Jack
完成制表符分隔数据的所有行后,选择包含数据的所有行(确保不要选择没有三个制表符的空行,否则将不起作用),然后单击插入->;表->;插入表格。。。现在,数据被转换为Word表。只需将表格复制到Excel即可
使用熊猫和口述很容易:
相关问题 更多 >
编程相关推荐