合并文件

1.合并同一文件夹的txt文件,原始文件存放于filepath目录中

import os
import os.path

def MergeTxt(filepath,outfile):
    k = open(filepath + outfile, 'a+')
    for parent , dirnames ,   in os.walk(filepath):
        for filepath in filenames:
            txtPath = os.path.join(parent, filepath)
            f = open(txtPath)
            k.write(f.read())
            
    k.close()
filepath = "D:\\data\\"
outfile = "merge.txt"
MergeTxt(filepath,outfile)

2.txt转化为excel
（1）

import xlwt
def txt_xls(filename, xlsname):
    try:
        f = open(filename)
        xls = xlwt.Workbook()
                sheet = xls.add_sheet('sheet1', cell_overwrite_ok = True)
        x = 0
        while True:
            line = f.readline()
            if not line:
                break
            for i in range(len(line.split('|'))):
                item = line.split('|')[i]
                sheet.write(x,i,item)
            x += 1
        f.close()
        xls.save(xlsname)
    except:
        raise
            
filename = "D:\\data\\merge.txt"
xlsname = "D:\\data\\merge.xls"
txt_xls(filename, xlsname)

（2）Python可以使用pandas读取文件

df1 = pd.read_csv('test.txt')
df1.to_excel('test.xlsx')