-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathseparator.py
35 lines (31 loc) · 1.11 KB
/
separator.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
import csv
import os
def separate(file_str):
"""
Разделяет csv файл на csv файлы по годам
Args:
file_str (str): ссылка на файл
"""
with open(file_str, encoding='utf-8-sig') as file:
reader = csv.reader(file)
head = []
is_first = True
years = {}
for row in reader:
if is_first:
is_first = False
head = row
else:
if not "" in row and len(row) == len(head):
year = row[5][:4]
if year in years.keys():
years[year].append(row)
else:
years[year] = [row]
os.mkdir('years')
for year in years.keys():
with open(f'years//{year}.csv', 'w', encoding='utf-8-sig', newline='') as csvfile:
filewriter = csv.writer(csvfile, delimiter=',', quoting=csv.QUOTE_MINIMAL)
filewriter.writerow(head)
for item in years[year]:
filewriter.writerow(item)