[问题求助] Python把TXT转换为csv格式，转换后对数据作分列删除和增加列操作

import csv
import datetime
if __name__ == '__main__':
    read_txt = 'E:/Python/python测试数据.txt'
    write_csv = 'E:/Python/link.csv'
    today = datetime.date.today()
    with open(read_txt, 'r', encoding='utf8') as f:
        lines = f.readlines()
        for i in range(len(lines)):
            link = lines[i].split(',')[0]
            col = lines[i][lines[i].rindex('/')+1:].strip('\n')
            time = str(today.strftime('%Y%m%d')) + '-xl'
            data = [link, col, time]
            with open(write_csv, 'a', newline='') as c:
                w = csv.writer(c, dialect='excel')
                w.writerow(data)
复制代码

import csv
import datetime
from tqdm import tqdm    # 安装第三方库

read_txt = 'E:/news/Python/python测试数据.txt'
write_csv = 'E:/news/Python/data.csv'
today = datetime.date.today()
with open(read_txt, 'r', encoding='utf8') as f:
    lines = f.readlines()
    for line in tqdm(lines):
        link = line.split(',')[0]
        col = line[line.rindex('/')+1:].strip('\n')
        time = str(today.strftime('%Y%m%d')) + '-xl'
        data = [link, col, time]
        with open(write_csv, 'a', newline='') as c:
            w = csv.writer(c, dialect='excel')
            w.writerow(data)
复制代码

#-*-coding:utf-8 -*-
 
import csv
import time

def getLineData(constant):
    # 读要转换的txt文件
    with open('python测试数据.txt', 'r', encoding='utf-8') as filein:
        for line in filein:
            a, b = line.strip('\n').split(',')
            yield a, b[b.rfind('/')+1:], constant

def saveDataToCsv(fileName):

    constant = time.strftime('%Y%m%d') + '-xl'
    
    with open(fileName, 'w', newline='' ) as csvfile:
        spamwriter = csv.writer(csvfile, dialect='excel')
        for line in getLineData(constant):
            spamwriter.writerow(line)

if __name__ == "__main__":
    
    fileName = 'File.csv'
    saveDataToCsv(fileName)
复制代码