本帖最后由 superman 于 2021-7-20 23:15 编辑
刚接触python想将TXT文本数据转换为csv格式保存,然后还需要对第二列数据作分列删除URL,然后再增加一列固定列,具体情况见附件,求大佬指点,谢谢- #-*-coding:utf-8 -*-
-
- import csv
- with open('File.csv', 'w+',newline='' ) as csvfile:
- spamwriter = csv.writer(csvfile, dialect='excel')
- # 读要转换的txt文件
- with open('python测试数据.txt', 'r',encoding='utf-8') as filein:
- for line in filein:
- line_list = line.strip('\n').split(',')
- spamwriter.writerow(line_list)
复制代码 附件https://wwr.lanzoui.com/imOsppu5lub |