csv文件生成python源码

import sys import os import csv import re def picture_num(filename): f = filename t = f.split("/", 7)[7] pic_num = t.split(".", 1)[0] #print(t) #print(pic_num) #pic_num = int(pic_num) #将输出图片的编号转化为整型 return pic_num #去除空各行函数 def Delblackline(infile, outfile): """ Delete blanklines of infile """ filename_in = open(infile, "r") filename_out = open(outfile, "w") lines = filename_in.readlines() for li in lines: if li.split(): filename_out.writelines(li) filename_in.close() filename_out.close() def K2F(x): t = float(x) yf = round(t/1.000001, 7) y = '{:.7f}'.format(yf) # 5f表示保留5位小数点的float型 return (y) # def writer_to_csv(csv_row1, csv_row2, csv_row3): current_dir = os.path.abspath('.') file_name = os.path.join(current_dir, "cssdfdf.csv") csv_f = open(file_name, 'w', newline='', encoding="UTF8") writer = csv.writer(csv_f, delimiter=",") # header = ['pic_num', 'pig_num', 'gai_lv'] # csv_row1 = [] # csv_row2 = [] # csv_row1.append("测试1") # csv_row1.append("测试2") # csv_row2.append("111") # csv_row2.append("222") # writer.writerow(header) # writer.writerows(zip(csv_row1, csv_row2, csv_row3)) # csv_f.close() # C:\Users\Administrator\Desktop\127 filename_r = 'C:/Users/Administrator/Desktop/20171208/densenet121_crop_pig128.txt' #filename_w = 'C:/Users/Administrator/Desktop/fenzu_1203/pig.txt' #filename_ww = 'C:/Users/Administrator/Desktop/fenzu_1203/Final version.txt' txt_file_r = open(filename_r, "r") # txt_file_w = open(filename_w, "w") # txt_file_ww = open(filename_ww, "w") pic_num_sz = [] pig_num_sz = [] glv_num_sz = [] zz = [] fdf = [] for line in txt_file_r.readlines(): print(line) line1 = re.split('\n', line)[0] line_txt = line1.split(" ", 30) pic_num = picture_num(line_txt[0]) for i in range(1, 31): m = str(i) #print(line_txt[i]) # txt_file_w.write(' ' + pic_num + "," + " " + m + "," + line_txt[i] + "\n") #txt_file_w.write(pic_num + "," + m + "," + line_txt[i] + "," + "\n") pic_num_sz.append(pic_num) # print(pic_num_sz) pig_num_sz.append(m) #print(pig_num_sz) xy = K2F(line_txt[i]) glv_num_sz.append(xy) # glv_num_sz.append(line_txt[i]) zz.append(m) #print(glv_num_sz) # pic_num_sz = ['01', '02', '03', '04', '05'] # pig_num_sz = ['01', '02', '03', '04', '05'] # glv_num_sz = ['01', '02', '03', '04', '05'] u = zip(pic_num_sz, pig_num_sz, glv_num_sz) #u = zip(pic_num_sz, pig_num_sz) writer.writerows(u) #writer.writerows(glv_num_sz) csv_f.close() print(xy) # print(glv_num_sz) # print(zz) #txt_file_r.close() #txt_file_w.close() #Delblackline(filename_w, filename_ww)