forked from GeekBrainsTutorial/Python_lessons_basic
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path6_csv.py
More file actions
69 lines (47 loc) · 1.98 KB
/
6_csv.py
File metadata and controls
69 lines (47 loc) · 1.98 KB
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
import csv
# -= Чтение =-
# Создание диалекта
csv.register_dialect('excel-semicolon', delimiter=';')
f = open('employees.csv', 'rt')
try:
reader = csv.reader(f, dialect="excel-semicolon")
for row in reader:
print(row)
finally:
f.close()
# Авто определение диалекта файла
with open('employees.csv') as csvfile:
dialect = csv.Sniffer().sniff(csvfile.read(1024))
csvfile.seek(0)
reader = csv.reader(csvfile, dialect)
for row in reader:
print(row)
# Считывание в namedtuple
from collections import namedtuple
Employee = namedtuple('Employee', 'name, age, department, pay')
with open('employees.csv') as csvfile:
for emp in map(Employee._make, csv.reader(csvfile, dialect)):
print(emp.name, emp.pay)
# Работа со словарями
# В качестве ключей используется первая строка
with open('employees_excel.csv', encoding='windows-1251') as csvfile:
reader = csv.DictReader(csvfile, dialect=dialect)
for row in reader:
print (row)
# -= Запись =-
encoding = 'windows-1251'
# encoding = 'utf-8'
with open('employees_out.csv', 'w', encoding=encoding) as csvfile:
writer = csv.writer(csvfile, dialect='excel-semicolon')
writer.writerow( ('Заголовок 1', 'Заголовок 2', 'Заголовок 3') )
for i in range(10):
writer.writerow( ('строка %s' % (i+1), 2**i, '08/%02d/13' % (i+1)) )
# Запись словарей
with open('employees_out.csv', 'w', encoding=encoding) as csvfile:
fieldnames = ('Заголовок 1', 'Заголовок 2', 'Заголовок 3')
writer = csv.DictWriter(csvfile, fieldnames=fieldnames, dialect='excel-semicolon')
headers = {name:name for name in fieldnames}
writer.writerow(headers)
for i in range(10):
data = dict(zip(fieldnames, ['строка %s' % (i+1), 2**i, '08/%02d/13' % (i+1)]))
writer.writerow(data)