Pandas将将txt转变成转变成xlsx格式格式
# coding=utf-8
from pandas import DataFrame
import sys
input_file = sys.argv[1] # 输入文件
output_file = sys.argv[2] # 输出文件
dict_data = {}
with open(input_file, 'r', encoding="utf-8") as df:
for line in df:
line = line.replace(" ", ',').split(',')
a= line[0] b = line[1] c = line[2] d = line[3] e = line[4] f = line[5] dict_data.setdefault('a', []).append(a)
dict_data.setdefault('b', []).append(b)
dict_data.setdefault('c', []).append(c)
dict_data.setdefault('d', []).append(d)
dict_data.setdefault('e', []).append(e)
dict_data.setdefault('f', []).append(f)
columnsname = ['a', 'b', 'c', 'd', 'e', 'f'] frame = DataFrame(dict_data, columns=columnsname)
frame.to_excel(output_file, sheet_name='sheet1', na_rep='', float_format=None, columns=None,
header=True, index=False, index_label=None, startrow=0, startcol=0, engine=None,
merge_cells=True, encoding=None, inf_rep='inf', verbose=True, freeze_panes=None)
作者:itcast_xiaohuer
评论0