wxyz0001

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)COPY

wxyz0001

回复 4# superman

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)COPY