我有一个大的csv文件,包含以下列头:id
、type
、state
、location
以及以下数值:
124, preschool, Pennsylvania, Pittsburgh
421, secondary school, Ohio, Cleveland
213, primary school, California, Los Angeles
155, secondary school, Pennsylvania, Pittsburgh
etc...
这个文件没有排序,我想为每种类型的学校创建一个 CSV 文件。
我发现的答案都是关于有序的 CSV 文件或者在特定行数后拆分它们。
编辑: 我已经找到了我想要的:
import csv
csv_file = 'school.csv'
value = 'preschool'
with open(csv_file, 'rb') as csvfile:
spamreader = csv.reader(csvfile, delimiter=',', quotechar='|')
for row in spamreader:
if value in row:
with open(value + '.csv', 'ab') as myfile:
spamwriter = csv.writer(myfile)
spamwriter.writerow(row)
myfile.close()
我只需从原始表格中复制粘贴标题行即可保留标题列。