python读取txt转为csv

data.txt 文本内容如如下：

2021-04-04 10:37:09 Sum 293 ValidNumber_S 1 ValidNumber_L 81
2021-04-04 10:37:17 Sum 312 ValidNumber_S 1 ValidNumber_L 64
2021-04-04 10:37:27 Sum 659 ValidNumber_S 3 ValidNumber_L 110
2021-04-04 10:37:37 Sum 394 ValidNumber_S 5 ValidNumber_L 66
2021-04-04 10:37:47 Sum 934 ValidNumber_S 4 ValidNumber_L 81
2021-04-04 10:37:57 Sum 623 ValidNumber_S 5 ValidNumber_L 52

读写data.txt后，第一列和第二列合并后转换为csv格式

import csv

with open('data.csv','w+',encoding='utf-8',newline='') as csvfile:
    datawriter = csv.writer(csvfile,dialect='excel')
    with open('data.txt','r',encoding='utf-8') as filein:
        #print(filein.readlines())
        for line in filein.readlines():
            #print(line)
            line_list = line.strip('\n').split(' ')
            #p