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)