-
Notifications
You must be signed in to change notification settings - Fork 2
/
csv_reader.py
executable file
·55 lines (47 loc) · 1.9 KB
/
csv_reader.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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
import csv
import Download_File
def get_download():
Download_File.download()
def csv_line_parse(line):
return line.split(",")
def get_request(zf):
request_list = []
name_list = []
with zf.open("temporary_files/requests.csv", "r") as f: #open csv file
for bytes_line in f.readlines()[1:]: # iterate over all non-header lines
line = csv_line_parse(bytes_line.decode())
modified_row = line
name_list.append(modified_row[0])
del modified_row[0] # remove name
request_list.append(modified_row)
# csvreader = csv.reader(csvfile)
# next(csvreader) #ignore heading
# for row in csvreader:
# modified_row = row
# name_list.append(modified_row[0])
# del(modified_row[0]) #remove name
# request_list.append(modified_row)
for i in range(0, len(request_list)):
for x in range(0, len(request_list[i])):
request_list[i][x] = int(request_list[i][x])
return request_list, name_list
def get_qualifs(zf):
qualif_list = []
name_list = []
with zf.open("temporary_files/qualifications.csv", "r") as f:
for bytes_line in f.readlines()[1:]: # iterate over non-header lines
line = csv_line_parse(bytes_line.decode())
modified_row = line
name_list.append(modified_row[0])
del modified_row[0] # remove name
qualif_list.append(modified_row)
# csvreader = csv.reader(csvfile)
# next(csvreader)
# for row in csvreader:
# modified_row = row
# del(modified_row[0])
# qualif_list.append(modified_row)
for i in range(0, len(qualif_list)):
for x in range(0, len(qualif_list[i])):
qualif_list[i][x] = int(qualif_list[i][x])
return qualif_list, name_list