1 # coding=utf-8 2 import csv,sys,datetime 3 4 time1 = datetime.datetime.now().strftime("%Y%m%d%H%M%S") 5 # input_file = sys.argv[1] 6 input_file = r"/Users/vito/Desktop/SW/Python/python_study/csv/records.csv" 7 8 output_file = input_file+"_Fail_Item_"+time1+".csv" 9 # input_file = r"/Users/vito/Desktop/s/records.csv" 10 # output_file = r"/Users/vito/Desktop/s/records_Fail_Item.csv" 11 12 with open(input_file, 'r', newline='') as csv_in_file: 13 with open(output_file, 'a', newline='') as csv_out_file: 14 filereader = csv.reader(csv_in_file) 15 filewriter = csv.writer(csv_out_file) 16 header = next(filereader) 17 filewriter.writerow(header) 18 for i,rows in enumerate(filereader): 19 # if i == 0: 20 # second = rows 21 # print(rows) 22 # filewriter.writerow(second) 23 # else: 24 status = str(rows[12]).strip() 25 if status == 'FAIL' or rows[0] != "": 26 filewriter.writerow(rows) 27 print("正在处理第{0}行数据...".format(i))