我正在用这个python程序根据第二列“ParentID”拆分一个非常大的csv。我最近更新为“a”而不是“w”由于文件量大和每个进程的限制。在这样做时,我的头每次都在写,而不是在每个文件中第一次。你知道吗
我更新添加了“write\u header=true”和“write\u header=false”,但现在它只在第一个文件上写入头。。。我有29000多个文件
#!/usr/bin/env python3
import binascii
import csv
import os.path
import sys
from tkinter.filedialog import askopenfilename, askdirectory
from tkinter.simpledialog import askinteger
def split_csv_file(f, dst_dir, keyfunc):
csv_reader = csv.reader(f)
header = next(csv_reader)
write_header = True
csv_writers = {}
for row in csv_reader:
k = keyfunc(row)
with open(os.path.join(dst_dir, k), mode='a', newline='') as output:
writer = csv.writer(output)
while write_header:
writer.writerow(header)
write_header = False
csv_writers[k] = writer
csv_writers[k].writerow(row[0:1])
def get_args_from_cli():
input_filename = sys.argv[1]
column = int(sys.argv[2])
dst_dir = sys.argv[3]
return (input_filename, column, dst_dir)
def get_args_from_gui():
input_filename = askopenfilename(
filetypes=(('TXT','.txt'),('CSV', '.csv')),
title='Select CSV Input File')
column = askinteger('Choose Table Column', 'Table column')
dst_dir = askdirectory(title='Select Destination Directory')
return (input_filename, column, dst_dir)
if __name__ == '__main__':
if len(sys.argv) == 1:
input_filename, column, dst_dir = get_args_from_gui()
elif len(sys.argv) == 4:
input_filename, column, dst_dir = get_args_from_cli()
else:
raise Exception("Invalid number of arguments")
with open(input_filename, mode='r', newline='') as f:
split_csv_file(f, dst_dir, lambda r: r[column-1]+'.txt')
# if the column has funky values resulting in invalid filenames
# replace the line from above with:
# split_csv_file(f, dst_dir, lambda r: binascii.b2a_hex(r[column-1].encode('utf-8')).decode('utf-8')+'.csv')
下面是一个正在拆分的文件的示例。。你知道吗
<option value=''>Choose SubGroup</option>, ParentID
<option value='/1990-Accord-DX-Glass-s/37918.htm'>Glass</option>,Accord1990DX422F22A1BodyHardwareBackGlass
<option value='/1990-Accord-DX-Glass-s/37919.htm'>Glass</option>,Accord1990DX422F22A1BodyHardwareBackGlass
<option value='/1990-Accord-DX-Reveal-Moldings-s/69090.htm'>Reveal Moldings</option>,Accord1990DX422F22A1BodyHardwareBackGlass
<option value='/1990-Accord-DX-Reveal-Moldings-s/69091.htm'>Reveal Moldings</option>,Accord1990DX422F22A1BodyHardwareBackGlass
<option value='/1990-Accord-DX-Center-s/10331.htm'>Center</option>,Accord1990DX422F22A1BodyHardwareConsole
<option value='/1990-Accord-DX-Cowl-s/16006.htm'>Cowl</option>,Accord1990DX422F22A1BodyHardwareCowl
<option value='/1990-Accord-DX-Exterior-Trim-s/26889.htm'>Exterior Trim</option>,Accord1990DX422F22A1BodyHardwareFender
<option value='/1990-Accord-DX-Exterior-Trim-s/26890.htm'>Exterior Trim</option>,Accord1990DX422F22A1BodyHardwareFender
如何使头在每个输出文件上只写一次?你知道吗
第一次写入头时,将
write_header
设置为false。因此,只有打开的第一个文件才能获得该头文件。你知道吗跟踪哪些文件在集合中设置了头文件:
您可能希望通过跟踪上次写入文件的时间并关闭未写入的文件来延长文件的打开时间。这就需要一个自定义类,它可以在您按键请求文件时透明地跟踪文件,比一个答案中包含的工作更多。你知道吗
相关问题 更多 >
编程相关推荐