Python将一个csv文件分成多个
今天实现了之前爬取某城市网站获得的空气质量数据,根据监测点细分到多个csv文件中,用到多次if 语句,如果能简化就好了。还是太菜!
import csv
with open('新数据.csv','r',encoding='utf-8')as fp:
reader=csv.reader(fp)
for i,rows in enumerate(reader):
print(rows)
if i%13==1:
row =rows
# print(row)
filename=row[1]
path=r'F:/软件学习/python/Recall python 2020.0504/alone/'+filename+'.csv'
with open (path,'a',newline='')as fp:
writer=csv.writer(fp)
writer.writerow(row)
fp.close()
elif i%13==2:
row = rows
# print(row)
filename = row[1]
# print(filename)
path = r'F:/软件学习/python/Recall python 2020.0504/alone/' + filename + '.csv'
with open(path, 'a', newline='')as fp:
writer = csv.writer(fp)